Skip to content

Instantly share code, notes, and snippets.

@TDahlberg

TDahlberg/readme.md

Last active August 29, 2015 14:19
Show Gist options
  • Save TDahlberg/8d98cd424b517de69f2a to your computer and use it in GitHub Desktop.
Save TDahlberg/8d98cd424b517de69f2a to your computer and use it in GitHub Desktop.
Download ZIP
Add Google Streetview images to CartoDB points
Raw
readme.md

#How to add Google Streetview images to CartoDB points ##Add points to CartoDB ##Run the following code in the SQL editor:

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 tablename

##Set the infowindow popup as "image header" type, select "image" as the title field ##Click a point, be amazed.

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