ebrelsford/nycproj2latlon.sql

Last active December 21, 2015 05:39

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ebrelsford/6258702.js"></script>
Save ebrelsford/6258702 to your computer and use it in GitHub Desktop.

Download ZIP

Convert a table with coordinates in NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet (common for NYC data) to lat and lon in 4326. We first convert the coordinates from feet to meters.

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