search

nationalparkservice / places-data

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

Update HOSP boundary #750

Closed chadlawlis closed 8 years ago

chadlawlis commented 8 years ago

From https://github.com/nationalparkservice/places-data/issues/746. Currently pulling from WSD_Parks which is almost identical to the latest Lands release 20160630:

hosp

Going to go ahead and transition this to Lands.

chadlawlis commented 8 years ago

Done via:

BEGIN;
UPDATE
    parks_poly
SET
    geom_poly = (SELECT wkb_geometry FROM lands_20160630 WHERE unit_code = 'hosp')
WHERE
    unit_id = 200;
UPDATE 
    parks
SET
    unit_area = (SELECT ST_Area(geom_poly) FROM parks_poly WHERE unit_id = 200)
WHERE
    unit_id = 200;
UPDATE 
    parks_point
SET
    geom_point = (SELECT ST_Centroid(geom_poly) FROM parks_poly WHERE unit_id = 200)
WHERE
    unit_id = 200;
COMMIT;

Will go live once boundaries are regenerated.

chadlawlis commented 8 years ago

This is now live.