torque query and output

100%

torque query and output

✓ Published0🌍 Public

Last edited Jun 21, 2013

Created on Jun 21, 2013

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.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 6114786

This example implements a private torque-style time-series visualization for geospatial data using PostgreSQL and PostGIS. It defines custom SQL functions that aggregate point features into web-Mercator grid cells, grouping counts by time steps and returning arrays of values and dates for rendering. The code uses `ST_SnapToGrid`, `CDB_XYZ_Resolution`, and `CDB_XYZ_Extent` to tile data at a given zoom level, with two variants: a standard response for instantaneous counts and a cumulative response that includes expiration dates for each cell. A metadata function returns the spatial bounds and time range from the source table, supporting both timestamped and numeric columns.

Aandrewxhill

73% match

Loading thumbnail…

Torque runtime example | CartoDB.js

This example displays a Torque animated map of Twitter data from the table `twitter_wowfakta`, showing cumulative point aggregation over time. It uses CartoDB.js with the Leaflet map API, initializing a map centered on Java with a Stamen toner basemap. The Torque layer is created via `cartodb.createLayer` with a custom CartoCSS template that sets cumulative aggregation, a marker width of 4 pixels, and a red fill color. The animation runs through the Torque runtime, which processes the data client-side to render temporal patterns.

Aandrewxhill

71% match

Loading thumbnail…

Torque runtime example | CartoDB.js

This example shows the movement of Twitter messages across a map of Java, Indonesia, using a Torque animation over a Stamen toner tile layer. The visualization renders an arrow marker for each data point, with color intensity varying by the cumulative count of messages at each location. The code builds the map with Leaflet and CartoDB.js, applying a custom CartoCSS template that defines the torque frame count, aggregation function, and marker styling. Data comes from the "twitter_wowfakta" table hosted on the "andrew" CartoDB user account.

Aandrewxhill

69% match

Loading thumbnail…

Fun with Torque

Torque maps animate Denver traffic accident data using CartoDB’s Torque library, which renders time-series point data as animated markers over a base map. The visualization cycles through 512 frames, with each frame aggregating accident counts per geotemporal bin via SQL aggregation functions like `count(cartodb_id)` or `CDB_Math_Mode(district_i)`. Marker size and opacity vary with frame offset to create motion trails, while categorical coloring uses CSS-like `[value=...]` selectors to distinguish districts. The example demonstrates multiple Torque configurations—category, bubble, discrete continuous, and static “Torque-Zero” modes—all driven by CartoCSS properties such as `-torque-frame-count`, `-torque-resolution`, and `-torque-aggregation-function`.

Aandrewxhill

67% match

Loading thumbnail…

Torque runtime example | CartoDB.js

A Torque map from CartoDB.js animates the movement of a monkey across a world map over 19 time frames. The code creates a Leaflet map centered on the equator, adds a Stamen toner tile layer, and loads a torque layer from the `monkey_jump` table on the `andrew` user account. The torque visualization uses custom CartoCSS to aggregate points by `count(cartodb_id)` with a linear data aggregation, rendering the path as red markers on a lighter blend over two seconds.

Aandrewxhill

67% match

Loading thumbnail…

Gist d7a736227751a4a49072

This example demonstrates Torque, a CartoCSS compiler that renders animated point data directly on HTML canvas in the browser, bypassing server-side Mapnik processing for responsive visualizations. The code shows how CartoCSS rules are translated into canvas drawing instructions, with markers rendered efficiently using Sprites generated at runtime. It includes static torque maps, animated bubble maps that change size over time, and a non-map visualization, all leveraging the Torque library’s shader and cartocss_reference.js APIs. The approach keeps data client-side, enabling fast, interactive rendering of temporal geospatial data.

Aandrewxhill

65% match

Loading thumbnail…

CartoDB Point Clustering

This example demonstrates point clustering on a map using CartoDB, showing how thousands of tornado records can be aggregated into hierarchical groups of different sizes. The visualization uses an SQL query with ST_SnapToGrid to cluster points at multiple scales, dynamically adjusting the cluster radius based on zoom level and a slider control. CartoCSS styles differentiate the cluster sizes, and clicking a point reveals the individual records it contains. The map is embedded with Google Maps and uses CartoDB.js, with an interactive side panel for cluster-size adjustments.

Aandrewxhill

65% match

Loading thumbnail…

Fun SQL statements for CartoDB

This example shows how to explore and analyze tornado and county data in CartoDB using SQL statements. It demonstrates basic queries for filtering, sorting, and aggregating records, followed by spatial functions that inspect geometry types, compute areas, distances, and intersections. The code uses PostGIS functions such as `ST_Area`, `ST_Distance`, `ST_Intersects`, and `ST_DWithin`, alongside CartoDB-specific helpers like `CDB_LatLng`. It also includes updates to add tornado counts and density per county, highlighting how SQL can drive interactive map visualizations.

Aandrewxhill

65% match