Skip to content

Instantly share code, notes, and snippets.

@jatorre
Created July 10, 2014 14:16
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/f2d5801a7365dc4ab364 to your computer and use it in GitHub Desktop.
Save jatorre/f2d5801a7365dc4ab364 to your computer and use it in GitHub Desktop.
Exampel SQL
https://stagingfonmaps.cartodb.com/api/v2/sql?q=SELECT%20external_id,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lon,%20network_id,%20category_NAME,%20status,%20hotspots,%20metadata%20FROM%20pois%20WHERE%20the_geom%20%26%26%20ST_MakeEnvelope(0,%200,%20180,%2090,%204326)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment