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
# 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
| Command | Description |
|---|---|
search <query> | Search datasets by keyword |
list | List all datasets |
info <dataset-id> | Show dataset metadata and fields |
fetch <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.