Downloads a double-zipped shapefile from NYC Socrata, separates it, and uploads to CartoDB

Import CartoDB file with cURL

This example demonstrates how to upload a file into a CartoDB account using the command-line tool cURL, showing the complete import workflow from submission to completion. The shell script sends the file to CartoDB’s `/api/v1/imports/` endpoint, extracts the job ID from the JSON response, and then polls the import status until it reports “complete.” It uses cURL for HTTP requests and `sed` for parsing the JSON, with platform-specific regex variations for macOS (Darwin) and Linux. The script takes three arguments: the CartoDB username, API key, and the filename to import.

67% match

Import CartoDB file with cURL (Mac version)

A shell script demonstrates how to import a file into a CartoDB account using cURL. It sends the file to CartoDB's import API endpoint, parses the returned job ID with sed, then polls the import status endpoint every two seconds until the state reports "complete." The script requires the CartoDB username, API key, and filename as command-line arguments.

66% match

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.

61% match

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.

Merging an entire directory of data and loading it to CartoDB

This example shows a shell script that uploads every GPX file in a directory to an existing CartoDB table. It demonstrates how to merge an entire folder of GPS track data into a single cloud-hosted dataset. The script relies on a Python utility called `cartodb-utils.py` to handle the upload process. For each `.gpx` file, the script calls the `append` command, passing the file path, table name, API key, and CartoDB account name as arguments. This approach automates the bulk ingestion of geospatial data without manual intervention.

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

NACIS Workshop | CartoDB

A step-by-step workshop guide demonstrates CartoDB's mapping and data-analysis capabilities through a sequence of exercises. The HTML page embeds a Speaker Deck presentation and lists tasks covering data import, visualization styling with CartoCSS, SQL filtering, and spatial queries. It references downloadable shapefiles, including tornado paths, NYC bike blocks, and tracked location data, with example SQL statements for distance calculations. The code loads CartoDB.js v3 and its CSS to support interactive map rendering throughout the tutorial.

command-line python interface for manipulating data on CartoDB

This example demonstrates a command-line Python tool for managing and manipulating data stored on CartoDB, allowing users to upload files, overwrite or append rows, add columns, drop tables, and export datasets. It first shows the workflow of interacting with CartoDB’s SQL and Import APIs, then explains the underlying implementation. The script uses the `requests` library for HTTP calls, `urllib2` for polling import status, and `argparse` for command-line options, translating between CartoDB’s data types and PostgreSQL types during column alterations and insertions.