Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@andrewxhill

andrewxhill/bounding circle on cartodb

Created February 23, 2012 16:27
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save andrewxhill/1893544 to your computer and use it in GitHub Desktop.
Save andrewxhill/1893544 to your computer and use it in GitHub Desktop.
Download ZIP
Creates a bounding circle from the_geom_webmercator on cartodb
Raw
bounding circle on cartodb
WITH inp as ( SELECT ST_Centroid(ST_Collect(ST_envelope(the_geom_webmercator))) as centroid,
ST_ConvexHull(ST_Collect(ST_Envelope(the_geom_webmercator))) as hull
FROM table_name GROUP BY some_column)
SELECT ST_Buffer(centroid,
ST_Length( ST_LongestLine(centroid, hull))) as the_geom_webmercator
FROM inp;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment