nationalparkservice / places-data

Data from the Places system.
http://www.nps.gov/npmap/tools/places/
13 stars 5 forks source link

Update Lands boundaries with 20150723 release #537

Open chadlawlis opened 8 years ago

chadlawlis commented 8 years ago

Released 7/23/2015: http://webmail.itc.nps.gov/pipermail/gis/2015-July/004275.html.

Email subject line: "[Gis] Administrative Boundaries of National Park System Units 7/23/2015 Update".

New Units in this Release

chadlawlis commented 8 years ago
unit_id name unit_code unit_region data_source poly_last_updated
155 First State National Historic Park frst ner Land Resources Division
181 Guilford Courthouse National Military Park guco ser Land Resources Division 2016-02-11 11:37:52.035989-07
250 Lower Saint Croix National Scenic Riverway losa mwr Land Resources Division
311 Paterson Great Falls National Historical Park pagr ner Land Resources Division
395 Vanderbilt Mansion National Historic Site vama ner Land Resources Division
282 National Capital Parks naca ncr npmap placeholder
335 Richmond National Battlefield Park rich ner rich
17 Apostle Islands National Lakeshore apis mwr WSD_Parks
106 Dinosaur National Monument dino imr WSD_Parks
200 Hot Springs National Park hosp mwr WSD_Parks
215 John Day Fossil Beds National Monument joda pwr WSD_Parks
275 Mojave National Preserve moja pwr WSD_Parks
313 Pecos National Historical Park peco imr WSD_Parks
346 Saint Croix National Scenic River sacn mwr WSD_Parks

via:

select parks.unit_id,
unit_name_long || ' ' || coalesce(unit_desig_full, '') as "name",
parks.unit_code,
unit_region,
data_source,
parks_poly.last_updated as poly_last_updated
from parks
JOIN parks_poly
ON parks_poly.unit_id = parks.unit_id
where parks.unit_code = 'guco'
or parks.unit_code = 'joda'
or parks.unit_code = 'pagr'
or parks.unit_code = 'vama'
or parks.unit_code = 'apis'
or parks.unit_code = 'dino'
or parks.unit_code = 'frst'
or parks.unit_code = 'hosp'
or parks.unit_code = 'losa'
or parks.unit_code = 'moja'
or parks.unit_code = 'naca'
or parks.unit_code = 'peco'
or parks.unit_code = 'rich'
or parks.unit_code = 'sacn'
order by data_source, unit_code;
chadlawlis commented 8 years ago

Update:

status unit_id name unit_code unit_region data_source poly_last_updated
155 First State National Historic Park frst ner Land Resources Division
:heavy_check_mark: #486 181 Guilford Courthouse National Military Park guco ser Land Resources Division 2016-02-11 11:37:52.035989-07
250 Lower Saint Croix National Scenic Riverway losa mwr Land Resources Division
311 Paterson Great Falls National Historical Park pagr ner Land Resources Division
395 Vanderbilt Mansion National Historic Site vama ner Land Resources Division
335 Richmond National Battlefield Park rich ner rich
17 Apostle Islands National Lakeshore apis mwr WSD_Parks
106 Dinosaur National Monument dino imr WSD_Parks
200 Hot Springs National Park hosp mwr WSD_Parks
215 John Day Fossil Beds National Monument joda pwr WSD_Parks
275 Mojave National Preserve moja pwr WSD_Parks
313 Pecos National Historical Park peco imr WSD_Parks
346 Saint Croix National Scenic River sacn mwr WSD_Parks
no boundary, per work with NCR #347 282 National Capital Parks naca ncr 2016-02-29 14:42:24.404278-07