data.duckdb

One-Click Database of All CARTA's Open Data

Try it Out

You can quickly start querying the data by clicking here

Import

You can add this database into your own DuckDB instance with one line by using DuckDB's attach mechanism:

ATTACH 'https://gocarta.s3.us-east-2.amazonaws.com/public/duckdb/data.duckdb' as data;

Background

Both data availability and access are important. CARTA publishes all its open datasets using datablob in numerous file formats, including parquet. After making data available, we wanted to drive down the friction in accessing and analyzing the data, so we created data.duckdb. A single DuckDB database that points to all our open datasets. It enables people to easily query, filter, and join all our open datasets.

Example

Here's an example of using data.duckdb to query across multiple tables. In this example we get all the Bike Chattanooga stations within 25 meters of Route 4.

Download

You can directly download the database here:
https://gocarta.s3.us-east-2.amazonaws.com/public/duckdb/data.duckdb