Use Goldberry to harvest a single basketball game and push it to CartoDB. WARNING This will pull ~2-3,000,000 points, so probably not for your typical free CartoDB account :)

100%

Use Goldberry to harvest a single basketball game and push it to CartoDB. WARNING This will pull ~2-3,000,000 points, so probably not for your typical free CartoDB account :)

✓ Published0🌍 Public

Last edited Aug 31, 2015

Created on Aug 31, 2015

This example uses Goldberry to fetch a single NBA basketball game’s play-by-play data, then pushes roughly 2-3 million player-movement points to CartoDB. It first identifies Klay Thompson’s game log via the NBA stats API, selects a specific matchup from January 2014, and queries `locations_getmoments` for each event. The script extracts player and ball positions for moments after the second quarter, appends timestamps, and constructs SQL INSERT statements for CartoDB’s SQL API, storing spatial coordinates as `the_geom` for mapping.

AI-generated description

Similar vizzes

Loading thumbnail…

Node.js app to harvest a georss feed into CartoDB

A Node.js app harvests live GeoRSS incident reports from Portland’s 911 feed and inserts new records into a CartoDB table. The animation shows a continuously updating map of emergency locations as fresh entries are parsed from XML using `xml2js`, then posted via CartoDB’s SQL API with `http.request`. Each feed item’s title, timestamps, category label, and point coordinates are extracted and formatted into an SQL `VALUES` insert, skipping duplicates. The process runs repeatedly, appending visible points to the map over time.

Aandrewxhill

58% match

Loading thumbnail…

Use yahoo string geolocation api and drop results into cartodb

This visualization streams text from a local file through the Yahoo Placemaker API, geolocating mentioned places and inserting their coordinates into a CartoDB table. It shows how raw text lines map to geographic points, with each detected place labeled by name, WOEID, and placetype. The Python script uses the `placemaker` library to extract locations and `urllib2` to send SQL insert statements to CartoDB’s SQL API, storing geometry via `CDB_LatLng`. Failed requests are logged to a file.

Aandrewxhill

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

57% match

Loading thumbnail…

Batch API uploads to CARTO

This example shows how to upload large datasets to CARTO by splitting them into smaller chunks and using the SQL Batch API to merge them. It demonstrates three chained batch queries: creating a combined table with `CREATE TABLE ... UNION ALL`, dropping the `cartodb_id` column with `ALTER TABLE`, and finalizing with `cdb_cartodbfytable`. The code references CARTO’s SQL API and batch query chaining, alongside a Python script from `carto-etl` and GDAL/ogr2ogr alternatives for record-by-record inserts.

Aandrewbt

57% match

Loading thumbnail…

CartoDB CSV Bulkloader for Python

This example demonstrates a Python script that bulk-loads CSV data into a CartoDB table via the CartoDB SQL API, converting latitude and longitude columns into geometry using the CDB_LatLng function. It reads rows from a local CSV file, batches inserts of up to 25,000 rows per request, and skips records already present by checking a unique identifier against the table’s latest entry. The code uses Python’s csv, urllib2, and json modules to parse data and send HTTP POST requests, with error handling that writes failed SQL statements to a log file.

Aandrewxhill

56% match

Loading thumbnail…

CartoDB SQL tricks: Various things that as a SQL-newbie I had to search for >10 minutes to find answers for.

This example demonstrates a collection of SQL recipes for solving common spatial data problems in CartoDB, ranging from merging neighboring county polygons with ST_Union to creating great circle lines via ST_MakeLine and ST_Segmentize. It shows practical techniques like updating geometries with conditional CASE statements, extracting coordinates with ST_X and ST_Y, stripping HTML tags using regexp_replace, and formatting zip codes with to_char. The code also covers performance strategies for large updates and querying spatial relationships with st_contains. Each snippet targets PostGIS functions within the CartoDB platform, emphasizing data preparation and geometric transformations.

Aandrewbt

56% match

Loading thumbnail…

Application | CartoDB

This example shows how to add download buttons to a CartoDB map, allowing users to export the underlying dataset in CSV, GeoJSON, or Shapefile formats. The map itself displays earthquake data (all_week) and is rendered using the CartoDB.js library via cartodb.createVis(). Below the map, three styled buttons link to the CartoDB SQL API, querying the same dataset with different format parameters so visitors can easily download the raw data. The page demonstrates a clean pattern for combining an embedded interactive map with simple data export functionality.

Aandrewxhill

55% match

Loading thumbnail…

CartoDB Point Clustering

This example displays point clustering on an interactive map centered on New Orleans, using CartoDB and Leaflet. It shows a sublayer of Twain dataset points filtered by city name, rendered as large blue markers. Clicking a marker queries overlapping points via CartoDB’s SQL API, revealing their count and source values in a side panel. The map uses Stamen toner tiles, while hover interactions change the cursor through CartoDB’s `featureOver` and `featureOut` events.

Aandrewxhill

55% match