search

nationalparkservice / places-data

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

Move GERO label #764

Closed chadlawlis closed 7 years ago

chadlawlis commented 7 years ago

Now that the boundary has been updated to Lands, the label on Park Tiles is a bit out of place:

https://www.nps.gov/maps/tools/park-tiles/view/#17/38.67830/-87.53479 gero_label

Let's move this on top of the boundary.

chadlawlis commented 7 years ago

Done via:

BEGIN;
UPDATE parks_label
SET geom_label = (SELECT ST_GeomFromText('POINT(-87.53680408000946 38.67841175980509)', 4326))
WHERE unit_id = 160;

UPDATE parks_label
SET geom_label = ST_Transform(ST_SetSRID(geom_label, 4326), 3857)
WHERE unit_id = 160;
COMMIT;
chadlawlis commented 7 years ago

All set here.