Skip to main content
100%

Gist 1198897

✓ Published0🌍 Public
Aandrewxhill
Last edited Sep 6, 2011
Created on Sep 6, 2011

This visualization demonstrates the geographic distribution of the 2010 U.S. Census data, mapping population counts and related demographic metrics across states. Built with Ruby and CartoDB importer, it renders interactive choropleth maps using color-coded polygons to represent data values, allowing users to explore spatial patterns in the dataset. The visualization leverages Google Spreadsheet integration for data input and PostgreSQL for storage, with map rendering handled through CartoDB’s geospatial processing pipeline.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 57ea4f5c69eb3675c729

This map visualizes U.S. congressional districts with population data, using color to encode the total population and voting-age population for each district. The visualization employs a choropleth style, where district boundaries from the GeoJSON file are rendered as polygons and shaded according to their associated population values. The author, andrewthornton, created this gist to display the demographic distribution across districts, with hover or selection interactions likely revealing exact population numbers for each geographic area.

Aandrewthornton
78% match
Loading thumbnail…

Gist 2e969e0d45ceb3555cc4

This visualization demonstrates unemployment rates across U.S. states and zip codes using interactive maps. It begins with a choropleth map of April unemployment data by state, then shifts to a bubble map of zip-code-level rates, with bubble size reflecting percentage values. The example uses CartoDB’s georeferencing, SQL updates to clean and convert data, and dynamic SQL queries to reorder or filter results, such as sorting by rate or selecting points within a distance of Washington, D.C. It also incorporates CartoDB.js for interactivity, including a street-view preview on hover.

Aandrewxhill
77% match
Loading thumbnail…

Gist 334df5480f67798d54a9b2e827a2c37f

This visualization maps population counts for U.S. states and Canadian provinces using a geographic choropleth. It shows relative population density through color shading on a map, with darker areas indicating higher populations. The code uses D3.js with `d3.geoPath` to render the geographic outlines and applies a color scale to fill each region based on its population value from the CSV file. The visualization relies on standard D3 data loading and projection methods to display the map.

AAlan McConchie
77% match
Loading thumbnail…

Gist 4354110

This visualization displays a map rendered with CartoDB, showing geographic data from a hosted visualization. The page loads a full-screen map using the CartoDB.js library, which initializes the map via `cartodb.createVis` and connects to a remote visualization URL. The map itself is embedded in a fixed-size `<div>` element and relies on CartoDB’s built-in rendering and tile services to draw the geographic layers. The code does not include custom data processing or interaction logic; it simply leverages the CartoDB API to present the pre-configured map.

Aandrewxhill
75% match
Loading thumbnail…

CartoDB Point Clustering

This example uses CartoDB to render U.S. state polygons with clustered point data. Clicking a state triggers an SQL query that applies ST_Dump and ST_SimplifyPreserveTopology to generate line segments radiating from the state centroid to its boundary points, producing a stylized "POW!" label effect. The visualization combines CartoDB’s tile layer API with custom CartoCSS styling, including pattern fills and text labels, to show how dynamic SQL can reshape geographic features interactively.

Aandrewxhill
74% match
Loading thumbnail…

Shared Data

This interactive map visualizes the population distribution of the United States by rendering state and county boundaries alongside state centroids. Built using D3.js, the visualization combines `d3.geoPath` to project and draw the geographic shapes from the included `us-states.json` and `us-counties.json` files, while `d3.geoPath` also handles the state centroids from `us-state-centroids.json`. The map is rendered dynamically, displaying the detailed boundaries and population data sourced from the provided gist.

Mmbostock
73% match
Loading thumbnail…

Gist 89811213f98645c51fa8

Using CartoDB’s SQL API and PostGIS functions, this notebook explores Gilt purchase data aggregated by zip code. It shows a series of interactive maps, including a bubble map of average session time and choropleths of purchase rates, built from geocoded postal points and polygon tables. The workflow demonstrates nested SQL subqueries to join transaction aggregates with geometries, spatial filtering with `ST_Intersects` and `ST_Buffer` around New York City, and on-the-fly centroid generation via `st_centroid` for a target audience map. Geocoding and tile rendering rely on CartoDB’s default web-mercator projection.

Aandrewxhill
73% match
Loading thumbnail…

Gist a61b3f54da810f6e9490

This example demonstrates how to map and animate earthquake data from the USGS CSV feed using CartoDB’s mapping tools. It shows temporal earthquake occurrences through an interactive map, with points updating over time. The code relies on CartoDB’s SQL API and JavaScript library for layer management, alongside D3.js for data-driven visualizations. It also integrates Chart.js for supplementary graphs and uses dynamic styling via CartoDB’s tile rendering. The visualization highlights both spatial distribution and time-based animation of seismic events.

Aandrewxhill
73% match