City of Edmonton Open Data#

Access and analyze 2,179+ open datasets from the City of Edmonton via the Socrata SODA API. Data covers transit, traffic, census, environment, city administration, and more.

Portal: https://data.edmonton.ca Licence: Open Government Licence – City of Edmonton

Quick Start#

bash

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

# List datasets by category
python3 scripts/edmonton_data.py list --category "Transit"

# View dataset info
python3 scripts/edmonton_data.py info 24uj-dj8v

# Fetch data (default JSON, 10 rows)
python3 scripts/edmonton_data.py fetch 24uj-dj8v --limit 5

# Fetch with filters
python3 scripts/edmonton_data.py fetch 24uj-dj8v --where "year='2025'" --select "job_category,address,construction_value"

# Export to CSV
python3 scripts/edmonton_data.py fetch 24uj-dj8v --limit 100 --csv > permits.csv

# List all categories
python3 scripts/edmonton_data.py categories

# View popular datasets
python3 scripts/edmonton_data.py popular

# GeoJSON export (if dataset has location columns)
python3 scripts/edmonton_data.py geojson h4ti-be2n --limit 50

Commands Reference#

CommandDescriptionsearch <query>Search datasets by keywordlist [--category <cat>]List datasets, optionally filter by categoryinfo <dataset-id>Show dataset metadata (columns, types, row count)fetch <dataset-id>Download data rows (opts: --limit, --where, --select, --order, --csv, --json)categoriesList all categories with dataset countspopularShow most-viewed datasetsgeojson <dataset-id>Export geocoded data as GeoJSON

Query Parameters#

The fetch command supports Socrata SODA query parameters:

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

Dataset IDs#

Dataset IDs are 9-character alphanumeric codes (e.g., 24uj-dj8v). Find them via search or list, or from the dataset URL: data.edmonton.ca/dataset/{id}.

Data Sources#

All data sourced from the City of Edmonton's Open Data Portal (data.edmonton.ca) under the Open Government Licence – City of Edmonton. See references/datasets.md for a curated list of popular datasets.

Environment Variables#

VariableRequiredDescriptionSOCRATA_APP_TOKENNoOptional Socrata app token to reduce rate limits. Works without it.