{"version":"1.0","type":"rich","title":"SQL for building a dynamic topo","description":"This example builds a dynamic topographic map from traffic data by buffering and dissolving point geometries into nested contour layers. It first generates a series of buffer rings around each data point, scales the car counts across nine distance levels, and then unions those buffers into isolines representing traffic intensity. The SQL query uses PostGIS functions like `ST_Transform`, `ST_Buffer`, and `ST_Union`, while a second pass outputs the original points. The result combines colored topo bands and overlaid points, with the visualization likely rendered using a web-mapping library that consumes the `the_geom_webmercator` geometries.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-3791208?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}