Skip to content

Instantly share code, notes, and snippets.

@jatorre

jatorre/gist:11371647

Created April 28, 2014 13:13
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 jatorre/11371647 to your computer and use it in GitHub Desktop.
Save jatorre/11371647 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT *,
'http://maps.googleapis.com/maps/api/streetview?size=300x190&location='||
ST_Y((the_geom))||','||ST_X((the_geom))
||'&sensor=false&fov=110' as image
FROM table_2012_entire_tree_down_complaints_sandy
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment