search

nationalparkservice / places-data

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

Update GERO boundary #763

Closed chadlawlis closed 7 years ago

chadlawlis commented 7 years ago

Currently pulling from legacy source WSD_Parks, needs to be updated to Lands.

chadlawlis commented 7 years ago

Done via:


BEGIN;
UPDATE
    parks_poly
SET
    geom_poly = (SELECT wkb_geometry FROM lands_20160630 WHERE unit_code = 'gero'),
    data_source = 'Land Resources Division'
WHERE
    unit_id = 160;
UPDATE 
    parks
SET
    unit_area = (SELECT ST_Area(geom_poly) FROM parks_poly WHERE unit_id = 160)
WHERE
    unit_id = 160;
UPDATE 
    parks_point
SET
    geom_point = (SELECT ST_Centroid(geom_poly) FROM parks_poly WHERE unit_id = 160)
WHERE
    unit_id = 160;
COMMIT;

Will go live once boundaries are regenerated.

chadlawlis commented 7 years ago

This is now live.