search

nationalparkservice / places-data

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

Update CRLA boundary #798

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).

chadlawlis commented 6 years ago

Updated in DB via:

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

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

Will go live once boundaries are regenerated.

chadlawlis commented 6 years ago

This is now live in PT.