Skip to main content
100%

Tim's transform of dentists

✓ Published0🌍 Public
Aandrewxhill
Last edited Sep 3, 2014
Created on Sep 3, 2014

The visualization shows the distribution of open Mexican restaurants across Arizona and Nevada, highlighting clusters within a 7-mile radius of any business. It uses hexagonal grid cells to aggregate restaurant locations and calculates the minimum distance from each hexagon’s center to the nearest business. The SQL query relies on PostGIS functions like `ST_Distance_Sphere` and `CDB_HexagonGrid` from CartoDB, while the web mapping renders the resulting hexagons as geographic features. The map reveals dense food corridors and isolated spots, with color or size indicating proximity, though the exact rendering method is not shown in the code.

AI-generated description

Similar vizzes

Loading thumbnail…

Untitled

This visualization shows the growth of soda franchise locations across four western U.S. states—Arizona, Idaho, Nevada, and Utah—over time, with each store colored by its parent company (yellow for Swig 'n Sweets, blue for FiiZ, red for Sodalicious). A range slider filters the map to display stores opened up to a selected year. The code uses `d3.geoAlbersUsa` projection and `d3.geoPath` to render state boundaries from TopoJSON, and dynamically joins circles representing store locations from the CSV data into an SVG using D3’s data join and exit selection.

Ssowbalas
61% match
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
60% match
Loading thumbnail…

Gist 6bf5a60d08034143bf8b

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.

Aandrewxhill
60% match
Loading thumbnail…

McDowell's Location Hexbins

This interactive map uses Mapbox GL to display hexagonal bins that reveal the density of locations across the continental United States. The visualization dynamically requests GeoJSON data from a local server based on the current map bounds and zoom level, coloring each hexagon by its location count, with a categorical color scale ranging from light blue to dark blue. At higher zoom levels, individual location points appear as orange circles, and hovering over a bin triggers a popup showing the exact count. The code uses Mapbox GL’s `addSource`, `addLayer`, and `setData` methods to update both the hexbin and point layers as the user pans or zooms.

WWill Carter
59% match
Loading thumbnail…

Untitled

This visualization shows the locations of soda franchises in four U.S. states—Arizona, Idaho, Nevada, and Utah—with an interactive slider that filters which stores appear based on their opening year. It uses d3.geoAlbersUsa projection with d3.geoPath to render state boundaries from GeoJSON, and appends SVG circles for each store, colored by company (Swig 'n Sweets, FiiZ, or Sodalicious). A range input controls year filtering, with d3's data join handling enter and exit transitions for the circles.

Ssowbalas
59% match
Loading thumbnail…

Gist 6c134b97d49c17b1d0b4

This visualization maps grocery stores, public libraries, and transit lines across Austin, Texas. Using data from three CSV files (groceries.csv, libraries.csv, metrorail.csv, metrorapid.csv), the map plots H-E-B, Randalls, Fiesta, Wheatsville, and Central Market locations alongside library branches and transit routes. The visualization likely uses color or icon encoding to distinguish store brands and transit types, revealing spatial relationships between grocery access, library locations, and public transportation infrastructure in the city.

Aandrewthornton
59% match
Loading thumbnail…

Gist 403e87d556c707e6d2b4d920c05ba2e3

A scatterplot maps veterinary clinics and animal hospitals by geographic coordinates, with each point labeled by facility name. The visualization uses d3.forceSimulation to prevent label overlap, while d3.geoPath renders a base map from geographic data. Points are colored and positioned via an equirectangular projection, with tooltips activated on hover. The dataset originates from a gist containing longitude, latitude, and facility names, though a stray SQL injection string appears in the data. The visualization highlights spatial clustering of animal care providers across the western United States, using Canvas getImageData for pixel-level collision detection during label placement.

WWill Carter
59% 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
58% match