CartoDB Fiesta
✓ Published0🌍 Public
Aandrewxhill
Last edited Dec 11, 2014
Created on Dec 6, 2014
This example shows a live map of Denver traffic accidents from 2013, colored and animated over time with CartoDB’s Torque rendering, alongside a census-neighborhood choropleth layer for normalization. The visualization is built through the CartoDB editor and its JavaScript API, using SQL queries to filter and delete pre-2013 records, compute distances with `CDB_LatLng` and the `<->` operator, and join accident points to districts via `ST_Intersects`. The embedded map is served from a CartoDB-hosted URL.
AI-generated description