search

nationalparkservice / places-data

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

Update EBLA boundary #755

Closed chadlawlis closed 8 years ago

chadlawlis commented 8 years ago

Currently pulling from WSD_Parks, update to Lands requested by Allen @ PWR.

ebla

chadlawlis commented 8 years ago

Done via:

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

Will go live once boundaries are regenerated.

chadlawlis commented 8 years ago

This is all set.