Gist 6bf5a60d08034143bf8b

100%

Gist 6bf5a60d08034143bf8b

✓ Published0🌍 Public

Last edited Dec 8, 2014

Created on Dec 8, 2014

This map visualizes building footprints across Cambridge and Somerville, joined with distances to Boston libraries and MBTA transit stations. Using CartoDB’s SQL interface, the code applies `ST_Distance` with a nearest-neighbor subquery to compute proximity metrics, then publishes the results as a multilayer visualization. The map is rendered through CartoDB’s mapping engine, displaying thematic styling based on the calculated spatial relationships.

AI-generated description

Similar vizzes

Loading thumbnail…

rundown

This example demonstrates how SQL queries can filter, analyze, and modify geographic data in CartoDB, using Massachusetts census blocks and Boston corner store locations. It shows spatial queries like distance calculations and bounding-box filters, plus joins to compute nearest fire station distances. The code uses the CartoDB SQL API and CartoDB.js library, with Leaflet for map rendering, to apply dynamic SQL filters and create visualizations without altering the underlying dataset.

Aandrewxhill

74% 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

70% match

Loading thumbnail…

Gist 7c1efd9bdead734010b0

This tutorial demonstrates how to build interactive maps and animated visualizations of a cat’s GPS tracking data using CartoDB’s web interface, SQL, and CartoCSS. It shows point, categorical, and temporal bubble maps, including a Torque animation of Spencer the Cat’s movements over time. The code uses CartoDB’s SQL API with functions like `ST_MakeLine` and `date_part`, along with CartoCSS styling for markers. It also covers importing polygon building datasets from MassGIS and querying them with spatial operations like `ST_Distance` and `CDB_LatLng`.

Aandrewxhill

70% match

Loading thumbnail…

Gist 3163949

This visualization maps development projects and their work areas as geographic points, connected by curved links to the responsible agencies. It displays project details, budgets, and topic classifications, with agency positions marked as separate nodes. The map uses CartoDB’s SQL API to query project, solution, agency, and topic tables, then renders GeoJSON geometries through D3’s `d3.geoPath`. Node positions are computed via `d3.forceSimulation`, while centroids for work-area polygons are calculated with PostGIS functions (`ST_Centroid`, `ST_X`, `ST_Y`).

Aandrewxhill

69% match

Loading thumbnail…

My first map

This map displays the neighborhoods of Boston as a static set of gray polygons. The visualization uses D3.js version 3.5.5, with the `d3.geo.albers` projection and `d3.geo.path` to render the geographic features. It pulls spatial data from a `neighborhoods.js` file, sourced from a gist by Sokrates86. The map is centered on Boston coordinates, and the code was built with Blockbuilder.org.

SSokrates86

69% match

Loading thumbnail…

Gist 1198897

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.

Aandrewxhill

68% match

Loading thumbnail…

Gist 652595e55960a8e04a29

This example visualizes the spatial relationships between metropolitan statistical areas and their constituent counties, townships, and other administrative geometries. The code first builds a combined geometry table using SQL, merging overlapping regions across multiple spatial layers while excluding special cases like Boston. It then renders these shapes using D3.js, likely leveraging `d3.geoPath` for projection and canvas or SVG drawing. The query explicitly handles hierarchical and overlapping geographies, prioritizing township-level detail where available and falling back to county unions for other areas. The final visualization shows how different government boundaries interlock within U.S. metropolitan regions, with the SQL preprocessing ensuring no duplicated or missing polygons.

CCaged

68% 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

68% match