Skip to content

Instantly share code, notes, and snippets.

@javierarce
Created March 3, 2012 12:53
Show Gist options
  • Save javierarce/1965936 to your computer and use it in GitHub Desktop.
Save javierarce/1965936 to your computer and use it in GitHub Desktop.
SELECT count(cartodb_id) as ct, ST_Transform(ST_Buffer(ST_SnapToGrid(the_geom,0.002),0.001, ‘quad_segs=2 endcap=square’),3857) as the_geom_webmercator FROM hoteles_playground GROUP BY ST_SnapToGrid(the_geom,0.002)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment