Skip to main content
100%

How the Twitter Template works

✓ Published0🌍 Public
Aandrewxhill
Last edited Jun 23, 2015
Created on Jun 23, 2015

The Twitter Template demonstrates a three-step workflow for visualizing geolocated tweets. It first computes a bounding box by sampling the most dense hexgrid cells, then renders a hexbin map that colors cells by category dominance. It also displays impactful tweets with follower counts as scaled text labels. The template uses SQL queries with PostGIS functions like `CDB_rectanglegrid` and `CDB_HexagonGrid`, alongside CartoCSS for map styling.

AI-generated description

Similar vizzes

Loading thumbnail…

Client side hexgrid | CartoDB.js

This example visualizes point data from a table named `za` as a hexbin density grid over a Leaflet map, using the CartoDB.js library. It initially renders hexagonal cells colored by point density, then recomputes the grid at a finer resolution and updates the map’s SQL and CartoCSS style to reflect the new bin size. The client-side SQL queries use PostGIS functions like `CDB_HexagonGrid` and `ST_Expand`, while `cartodb.SQL` and sublayer methods handle dynamic style and data updates. The base map uses Stamen toner tiles.

Aandrewxhill
67% match
Loading thumbnail…

Tracking @tmcw's prediction

This example tracks a series of tweets and links that compare Esri’s products and events to those of Mapbox and the wider FOSS4G community. It presents a timeline of exhibits, from drone no-fly zones and hexbin maps to GeoDev HackerLabs and GPS track mapping, each with corresponding URLs. The data is sourced from a gist by TheMapSmith, with entries linked via Twitter statuses and blog posts. The visualization does not use external libraries, relying on plain HTML and Markdown to structure the chronological log.

SStephen
65% match
Loading thumbnail…

CartoDB Point Clustering

This example demonstrates point clustering on a map using CartoDB, visualizing tornado data with adaptive hexagon grids. The SQL template computes three levels of hexagonal clusters (bigs, mids, smalls) based on point density, while CartoCSS styles the markers with different sizes and labels according to cluster level. As users zoom in, the marker sizes and cluster classifications update dynamically. Clicking a point reveals the number of tornadoes in that cluster, providing an interactive summary of spatial distribution.

Aandrewxhill
64% 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
63% match
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
63% match
Loading thumbnail…

CartoDB Point Clustering

This example demonstrates point clustering on a map using CartoDB.js, Google Maps, and a custom SQL template. It visualizes tornado data, grouping nearby points into hexagonal clusters of varying sizes based on a user-adjustable "cluster size" slider. The clustering algorithm runs through a SQL query that creates three levels of hexagon grids (large, medium, small) to aggregate points, with each cluster's size and opacity reflecting the number of points it contains. Clicking a cluster reveals details about the original points it represents. The side panel includes a range input to dynamically adjust the cluster radius, which updates the visualization via CartoDB's SQL and CartoCSS templating.

Aandrewxhill
63% match
Loading thumbnail…

Gist 8393672

This example visualizes a grid of geospatial tiles covering a region in Romania, with each tile representing a downloadable SRTM elevation data file. The map uses a GeoJSON FeatureCollection and renders polygon boundaries via D3's `d3.geoPath` projection. Each cell is labeled with its tile number, and a hover interaction likely reveals the associated download URL. The visualization relies on D3 for geographic path generation and the underlying data comes from a geomorphology website’s SRTM dataset, making the tile structure and coverage area immediately clear.

Aadkatrit
62% 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
62% match