← Back to Skills Marketplace
City of Calgary Open Data
by
Ray Chan, PMP
· GitHub ↗
· v1.0.2
· MIT-0
143
Downloads
0
Stars
0
Active Installs
3
Versions
Install in OpenClaw
/install calgary-opendata
Description
Access 988+ datasets from the City of Calgary open data portal. Search, fetch, and analyze city data on transit, environment, government, and more. The skill...
README (SKILL.md)
City of Calgary Open Data
Access and analyze 988+ open datasets from the City of Calgary via the Socrata SODA API. Data covers transit, environment, government, demographics, health, business, and more.
Portal: https://data.calgary.ca Licence: Open Government Licence – City of Calgary
Quick Start
# Search for datasets
python3 scripts/calgary_data.py search "traffic"
# List datasets by category
python3 scripts/calgary_data.py list --category "Environment"
# View dataset info
python3 scripts/calgary_data.py info iric-4rrc
# Fetch data (default JSON, 10 rows)
python3 scripts/calgary_data.py fetch iric-4rrc --limit 5
# Fetch with filters
python3 scripts/calgary_data.py fetch iric-4rrc --where "period='2024-01'" --select "facility_name,solar_pv_production_kwh"
# Export to CSV
python3 scripts/calgary_data.py fetch iric-4rrc --limit 100 --csv > solar.csv
# List all categories
python3 scripts/calgary_data.py categories
# View popular datasets
python3 scripts/calgary_data.py popular
# GeoJSON export (if dataset has location columns)
python3 scripts/calgary_data.py geojson c9sh-grss --limit 50
Commands Reference
| Command | Description |
|---|---|
search \x3Cquery> |
Search datasets by keyword |
list [--category \x3Ccat>] |
List datasets, optionally filter by category |
info \x3Cdataset-id> |
Show dataset metadata (columns, types, row count) |
fetch \x3Cdataset-id> |
Download data rows (opts: --limit, --where, --select, --order, --csv, --json) |
categories |
List all categories with dataset counts |
popular |
Show most-viewed datasets |
geojson \x3Cdataset-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.,"population > 5000")--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., iric-4rrc). Find them via search or list, or from the dataset URL: data.calgary.ca/dataset/{id}.
Data Sources
All data sourced from the City of Calgary Open Data Portal (data.calgary.ca) under the Open Government Licence.
Environment Variables
| Variable | Required | Description |
|---|---|---|
SOCRATA_APP_TOKEN |
No | Optional Socrata app token to reduce rate limits. Works without it. |
| All data is sourced from the City of Calgary's Open Data Portal (data.calgary.ca) and is provided under the Open Government Licence – City of Calgary. See references/datasets.md for a curated list of popular datasets. |
Usage Guidance
This skill appears coherent and implements a simple CLI against the City of Calgary's open data portal. Things to consider before installing: (1) the skill will make outbound HTTPS requests only to data.calgary.ca; (2) it optionally uses SOCRATA_APP_TOKEN — provide that only if you trust the skill and want higher API rate limits; (3) it writes a local cache file (.cache/catalog_cache.json) next to the script; and (4) the package source/homepage is unknown — if provenance matters, review the script contents yourself (scripts/calgary_data.py) to confirm they match your expectations before use.
Capability Analysis
Type: OpenClaw Skill
Name: calgary-opendata
Version: 1.0.2
The skill bundle provides a legitimate interface for accessing the City of Calgary's Open Data portal via the Socrata SODA API. The Python script (scripts/calgary_data.py) uses only standard libraries to perform searches, metadata retrieval, and data fetching from https://data.calgary.ca, with no evidence of data exfiltration, malicious execution, or prompt injection.
Capability Assessment
Purpose & Capability
Name/description (City of Calgary Open Data) match the included CLI and scripts which call the Socrata SODA API on data.calgary.ca. No unrelated services, binaries, or credentials are requested.
Instruction Scope
SKILL.md instructs the agent to run the included Python CLI and documents supported commands and an optional SOCRATA_APP_TOKEN. The runtime instructions do not request unrelated files, secrets, or system state beyond running the CLI.
Install Mechanism
This is an instruction-only skill with a single Python script; there is no install spec, no external downloads, and no archive extraction. The script uses only Python stdlib network calls.
Credentials
No required environment variables are declared. The only optional env var is SOCRATA_APP_TOKEN (documented in SKILL.md) which is appropriate for reducing API rate limits. The code reads that same env var and nothing else.
Persistence & Privilege
The skill does not request always:true and is user-invocable only. It does create a local cache file (.cache/catalog_cache.json) alongside the script to cache the dataset catalogue for one hour — this is reasonable for performance but worth noting if you expect no disk writes.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install calgary-opendata - After installation, invoke the skill by name or use
/calgary-opendata - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.2
Fixed: cache in skill dir, documented env vars
v1.0.1
Trim triggers list to improve discovery accuracy
v1.0.0
Initial release — search, fetch, and analyze 988+ City of Calgary open datasets via the Socrata SODA API
Metadata
Frequently Asked Questions
What is City of Calgary Open Data?
Access 988+ datasets from the City of Calgary open data portal. Search, fetch, and analyze city data on transit, environment, government, and more. The skill... It is an AI Agent Skill for Claude Code / OpenClaw, with 143 downloads so far.
How do I install City of Calgary Open Data?
Run "/install calgary-opendata" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is City of Calgary Open Data free?
Yes, City of Calgary Open Data is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does City of Calgary Open Data support?
City of Calgary Open Data is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created City of Calgary Open Data?
It is built and maintained by Ray Chan, PMP (@raychanpmp); the current version is v1.0.2.
More Skills