{"version":"1.0","type":"rich","title":"torque query and output","description":"This example demonstrates a CartoDB SQL query that aggregates and grids a dataset of points over both space and time. The query snaps geographic coordinates to a grid, groups counts by spatial cell and time bin, and returns an array of counts and corresponding date indices for each cell. The accompanying JSON shows the result—rows with x/y coordinates, value arrays, and date indices, which can be used to build a temporal heatmap or animated map. The visualization highlights how spatial and temporal aggregation can reveal patterns in point data, such as event frequency over time across a gridded map.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-5831325?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}