search

nationalparkservice / places-data

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

Update CRMO boundary #797

Closed chadlawlis closed 6 years ago

chadlawlis commented 6 years ago

Currently pulling from legacy source WSD_Parks, needs to be updated to latest Lands release (20170630).

Lands includes two geometries for this - one for the monument (CRMO: Craters of the Moon National Monument) and one for the preserve (CRMP: Craters of the Moon National Preserve). Park Tiles houses both as Craters of the Moon National Monument & Preserve (using the unit code CRMO, mimicking nps.gov).

The Lands boundaries for CRMO and CRMP have to be joined and dissolved to output the geometry suitable for Park Tiles.

chadlawlis commented 6 years ago

Updated in DB with combined CRMO/CRMP Lands boundary:

psql -U postgres -d places_boundaries_v2 -c "UPDATE parks_poly SET geom_poly = (SELECT wkb_geometry FROM crmo), data_source = 'Land Resources Division' WHERE unit_id = 94;"

psql -U postgres -d places_boundaries_v2 -c "UPDATE parks SET unit_area = (SELECT ST_Area(geom_poly) FROM parks_poly WHERE unit_id = 94) WHERE unit_id = 94;"

Will go live once boundaries are regenerated.

chadlawlis commented 6 years ago

This is now live in PT.