Skip to content

Instantly share code, notes, and snippets.

@chriswhong

chriswhong/statenisland.SQL

Created May 17, 2016 21:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chriswhong/c76abaf7107dc13a89bd85ecfc57396b to your computer and use it in GitHub Desktop.
Save chriswhong/c76abaf7107dc13a89bd85ecfc57396b to your computer and use it in GitHub Desktop.
Download ZIP
Moving Staten Island to the left of NYC
Raw
statenisland.SQL
select geom from nybb WHERE borocode < 5
UNION ALL SELECT ST_Translate(geom,.05,.2,4326) as geom FROM nybb WHERE borocode=5
@chriswhong
Copy link
Author

postgis_preview 4

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment