{"version":"1.0","type":"rich","title":"Creates a bounding circle from the_geom_webmercator on cartodb","description":"This example shows a bounding circle generated around grouped point data, visualized as a single polygon overlay on a CartoDB map. It displays the spatial extent of each group by computing a circular buffer from the group’s centroid. The code uses PostGIS functions—`ST_Collect`, `ST_Envelope`, `ST_ConvexHull`, `ST_Centroid`, `ST_LongestLine`, and `ST_Buffer`—to derive the circle from the `the_geom_webmercator` column. The result is rendered as a geographic layer, with the circle’s radius determined by the longest distance from the centroid to the group’s convex hull.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-1893544?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}