Skip to content

Instantly share code, notes, and snippets.

@lvngd

lvngd/nycproj2latlon.sql

Forked from ebrelsford/nycproj2latlon.sql
Created July 27, 2014 17:55
Show Gist options
  • Save lvngd/bcf58e7e5b83fbe33ebe to your computer and use it in GitHub Desktop.
Save lvngd/bcf58e7e5b83fbe33ebe to your computer and use it in GitHub Desktop.
Download ZIP
Raw
nycproj2latlon.sql
UPDATE graffiti_locations
SET the_geom = ST_Transform(
ST_SetSRID(
ST_MakePoint(x * 0.3048006096012192, y * 0.3048006096012192),
32118),
4326
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment