search

nationalparkservice / places-data

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

Move ALCA label #714

Closed chadlawlis closed 8 years ago

chadlawlis commented 8 years ago

I'd like to move this a bit northwest to avoid knocking out the visitor center and other prominent features on the southeastern side of the island.

Screenshot below from placement via geojson.io: geojson io 2016-05-10 17-38-34

Done via:

BEGIN;
UPDATE parks_label
SET geom_label = (SELECT ST_GeomFromText('POINT(-122.42432355880736 37.82765411187886)', 4326))
WHERE unit_id = 425;

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

This is now live and working properly.