City of Vancouver Open Data#

Access and analyze 194+ open datasets from the City of Vancouver via the Opendatasoft API. Data covers parking, transit, permits, demographics, environment, infrastructure, and more.

Portal: https://opendata.vancouver.ca Platform: Opendatasoft

Quick Start#

bash

# Search for datasets
python3 scripts/vancouver_data.py search "parking"

# List all datasets
python3 scripts/vancouver_data.py list

# View dataset info
python3 scripts/vancouver_data.py info parking-tickets-2017-2019

# Fetch data
python3 scripts/vancouver_data.py fetch parking-tickets-2017-2019 --limit 5

# Fetch with filters
python3 scripts/vancouver_data.py fetch parking-tickets-2017-2019 --where "year='2019'" --limit 10

# Export as CSV
python3 scripts/vancouver_data.py fetch parking-tickets-2017-2019 --limit 100 --csv > tickets.csv

Commands Reference#

CommandDescriptionsearch <query>Search datasets by keywordlistList all datasetsinfo <dataset-id>Show dataset metadata and fieldsfetch <dataset-id>Fetch data rows (opts: --limit, --where, --select, --order, --csv)

Query Parameters#

• --limit N — Max rows to return (default: 10)
• --where "condition" — SQL-like filter
• --select "col1,col2" — Choose specific columns
• --order "col DESC" — Sort results
• --csv — Output as CSV instead of JSON

Dataset IDs#

Dataset IDs are URL-safe slugs (e.g., parking-tickets-2017-2019). Find them via search or list, or from the dataset URL: opendata.vancouver.ca/explore/dataset/{id}.

Data Sources#

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