Description: Buildings, churches, hospitals, post offices, school and other places in NC
File: NCdata.csv
Source: USGS
NCdata <- read.csv("NCdata.csv", stringsAsFactors = FALSE)
names(NCdata)## [1] "FEATURE_ID" "FEATURE_NAME" "FEATURE_CLASS"
## [4] "STATE_ALPHA" "STATE_NUMERIC" "COUNTY_NAME"
## [7] "COUNTY_NUMERIC" "PRIMARY_LAT_DMS" "PRIM_LONG_DMS"
## [10] "PRIM_LAT_DEC" "PRIM_LONG_DEC" "SOURCE_LAT_DMS"
## [13] "SOURCE_LONG_DMS" "SOURCE_LAT_DEC" "SOURCE_LONG_DEC"
## [16] "ELEV_IN_M" "ELEV_IN_FT" "MAP_NAME"
## [19] "DATE_CREATED" "DATE_EDITED" "Town"
## [22] "Address"table(NCdata$FEATURE_CLASS)##
## Building Census Church Civil
## 1166 82 3487 578
## Hospital Locale Populated Place Post Office
## 80 760 2641 157
## School
## 1091str(NCdata) ## 'data.frame': 10042 obs. of 22 variables:
## $ FEATURE_ID : int 980026 980028 980031 980042 980047 980048 980052 980061 980070 980071 ...
## $ FEATURE_NAME : chr "Academy Heights School" "Acme Delco Middle School" "Acorn Ridge Church" "Adams Creek School" ...
## $ FEATURE_CLASS : chr "School" "School" "Church" "School" ...
## $ STATE_ALPHA : chr "NC" "NC" "NC" "NC" ...
## $ STATE_NUMERIC : int 37 37 37 37 37 37 37 37 37 37 ...
## $ COUNTY_NAME : chr "Moore" "Columbus" "Moore" "Craven" ...
## $ COUNTY_NUMERIC : int 125 47 125 49 183 145 181 185 107 83 ...
## $ PRIMARY_LAT_DMS: chr "351239N" "341858N" "352746N" "345517N" ...
## $ PRIM_LONG_DMS : chr "0792903W" "0781257W" "0793639W" "0764100W" ...
## $ PRIM_LAT_DEC : num 35.2 34.3 35.5 34.9 35.8 ...
## $ PRIM_LONG_DEC : num -79.5 -78.2 -79.6 -76.7 -78.8 ...
## $ SOURCE_LAT_DMS : logi NA NA NA NA NA NA ...
## $ SOURCE_LONG_DMS: logi NA NA NA NA NA NA ...
## $ SOURCE_LAT_DEC : logi NA NA NA NA NA NA ...
## $ SOURCE_LONG_DEC: logi NA NA NA NA NA NA ...
## $ ELEV_IN_M : int 137 18 163 2 137 222 154 132 22 49 ...
## $ ELEV_IN_FT : int 449 59 535 7 449 728 505 433 72 161 ...
## $ MAP_NAME : chr "Southern Pines" "Acme" "Robbins" "Merrimon" ...
## $ DATE_CREATED : chr "6/17/1980" "6/17/1980" "6/17/1980" "6/17/1980" ...
## $ DATE_EDITED : chr "" "4/28/2015" "" "" ...
## $ Town : chr "West End" "Delco" "Robbins" "Havelock" ...
## $ Address : chr "143 Douglas Ave, West End, NC 27376, USA" "26133 Andrew Jackson Hwy, Delco, NC 28436, USA" "299 Acorn Ridge Rd, Robbins, NC 27325, USA" "101 Belangia Rd, Havelock, NC 28532, USA" ...head(NCdata)## FEATURE_ID FEATURE_NAME FEATURE_CLASS STATE_ALPHA
## 1 980026 Academy Heights School School NC
## 2 980028 Acme Delco Middle School School NC
## 3 980031 Acorn Ridge Church Church NC
## 4 980042 Adams Creek School School NC
## 5 980047 Adams Elementary School School NC
## 6 980048 Adams School School NC
## STATE_NUMERIC COUNTY_NAME COUNTY_NUMERIC PRIMARY_LAT_DMS PRIM_LONG_DMS
## 1 37 Moore 125 351239N 0792903W
## 2 37 Columbus 47 341858N 0781257W
## 3 37 Moore 125 352746N 0793639W
## 4 37 Craven 49 345517N 0764100W
## 5 37 Wake 183 354637N 0784544W
## 6 37 Person 145 362335N 0785644W
## PRIM_LAT_DEC PRIM_LONG_DEC SOURCE_LAT_DMS SOURCE_LONG_DMS SOURCE_LAT_DEC
## 1 35.21071 -79.48420 NA NA NA
## 2 34.31602 -78.21591 NA NA NA
## 3 35.46264 -79.61086 NA NA NA
## 4 34.92127 -76.68326 NA NA NA
## 5 35.77691 -78.76219 NA NA NA
## 6 36.39292 -78.94556 NA NA NA
## SOURCE_LONG_DEC ELEV_IN_M ELEV_IN_FT MAP_NAME DATE_CREATED
## 1 NA 137 449 Southern Pines 6/17/1980
## 2 NA 18 59 Acme 6/17/1980
## 3 NA 163 535 Robbins 6/17/1980
## 4 NA 2 7 Merrimon 6/17/1980
## 5 NA 137 449 Cary 6/17/1980
## 6 NA 222 728 Roxboro 6/17/1980
## DATE_EDITED Town Address
## 1 West End 143 Douglas Ave, West End, NC 27376, USA
## 2 4/28/2015 Delco 26133 Andrew Jackson Hwy, Delco, NC 28436, USA
## 3 Robbins 299 Acorn Ridge Rd, Robbins, NC 27325, USA
## 4 Havelock 101 Belangia Rd, Havelock, NC 28532, USA
## 5 8/4/2015 Cary 805 Cary Towne Blvd, Cary, NC 27511, USA
## 6 Roxboro 2075 Mountain Rd, Roxboro, NC 27574, USAlocal_places <- subset(NCdata, (COUNTY_NAME=="Wake") |(COUNTY_NAME=="Orange") |(COUNTY_NAME=="Johnston")|(COUNTY_NAME=="Durham"))
str(local_places)## 'data.frame': 2368 obs. of 22 variables:
## $ FEATURE_ID : int 980047 980119 980154 980160 980189 980227 980234 980236 980238 980279 ...
## $ FEATURE_NAME : chr "Adams Elementary School" "Allens Chapel" "Alston Grove Church" "Amelia Church" ...
## $ FEATURE_CLASS : chr "School" "Church" "Church" "Church" ...
## $ STATE_ALPHA : chr "NC" "NC" "NC" "NC" ...
## $ STATE_NUMERIC : int 37 37 37 37 37 37 37 37 37 37 ...
## $ COUNTY_NAME : chr "Wake" "Orange" "Orange" "Johnston" ...
## $ COUNTY_NUMERIC : int 183 135 135 101 63 101 101 183 135 101 ...
## $ PRIMARY_LAT_DMS: chr "354637N" "360241N" "355348N" "353814N" ...
## $ PRIM_LONG_DMS : chr "0784544W" "0790842W" "0791224W" "0782944W" ...
## $ PRIM_LAT_DEC : num 35.8 36 35.9 35.6 35.9 ...
## $ PRIM_LONG_DEC : num -78.8 -79.1 -79.2 -78.5 -78.8 ...
## $ SOURCE_LAT_DMS : logi NA NA NA NA NA NA ...
## $ SOURCE_LONG_DMS: logi NA NA NA NA NA NA ...
## $ SOURCE_LAT_DEC : logi NA NA NA NA NA NA ...
## $ SOURCE_LONG_DEC: logi NA NA NA NA NA NA ...
## $ ELEV_IN_M : int 137 193 163 103 142 46 82 95 170 103 ...
## $ ELEV_IN_FT : int 449 633 535 338 466 151 269 312 558 338 ...
## $ MAP_NAME : chr "Cary" "Efland" "White Cross" "Clayton" ...
## $ DATE_CREATED : chr "6/17/1980" "6/17/1980" "6/17/1980" "6/17/1980" ...
## $ DATE_EDITED : chr "8/4/2015" "" "" "" ...
## $ Town : chr "Cary" "Hillsborough" "Chapel Hill" "Clayton" ...
## $ Address : chr "805 Cary Towne Blvd, Cary, NC 27511, USA" "2515-2803 Moorefields Rd, Hillsborough, NC 27278, USA" "5209 Old Greensboro Rd, Chapel Hill, NC 27516, USA" "1696 Amelia Church Rd, Clayton, NC 27520, USA" ...Contributor: Mark Hutchinson