shield_lock
JinDaGe
← Back to skills
extension
Category: Data & AnalyticsNo API key required

City of Vancouver Open Data

Access 194+ datasets from the City of Vancouver open data portal. Search, fetch, and analyze city data on parking, transit, permits, demographics, and more v...

personAuthor: raychanpmphubclawhub
open_in_newRepositorydownloadDownload package

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.