City of Toronto Open Data

Access and analyze 537+ open datasets from the City of Toronto via the CKAN API. Data covers transit, traffic, housing, environment, budget, community services, and more.

Portal: https://open.toronto.ca Platform: CKAN API: https://ckan0.cf.opendata.inter.prod-toronto.ca

Quick Start

# Search for datasets
python3 scripts/toronto_data.py search "traffic"

# List all datasets
python3 scripts/toronto_data.py list

# View dataset info
python3 scripts/toronto_data.py info 311-service-request-codes

# Fetch data from CKAN datastore
python3 scripts/toronto_data.py fetch traffic-volumes-at-intersections-for-all-modes --limit 5

# Fetch with filters
python3 scripts/toronto_data.py fetch traffic-volumes-at-intersections-for-all-modes --where "total_vehicle > 20000" --limit 10

# Export as CSV
python3 scripts/toronto_data.py fetch traffic-volumes-at-intersections-for-all-modes --limit 100 --csv > traffic.csv

# List datastore-enabled datasets
python3 scripts/toronto_data.py searchable

Commands Reference

| Command | Description | |---------|-------------| | search <query> | Search datasets by keyword | | list | List all datasets | | info <dataset-id> | Show dataset metadata and resources | | fetch <dataset-id> | Fetch data from datastore (opts: --limit, --where, --select, --csv) | | searchable | List datasets with queryable datastore resources |

Query Parameters

• --limit N — Max rows to return (default: 10)
• --where "condition" — SQL filter (e.g., "total_vehicle > 20000")
• --select "col1,col2" — Choose specific columns
• --csv — Output as CSV instead of JSON
• --resource-id ID — Specify which resource to query

Dataset IDs

Dataset IDs are URL-safe slugs (e.g., traffic-volumes-at-intersections-for-all-modes). Find them via search or list, or from the dataset URL: open.toronto.ca/dataset/{id}.

Data Sources

All data is sourced from the City of Toronto's Open Data Portal (open.toronto.ca). See references/datasets.md for a curated list of popular datasets.