Effortlessly query and retrieve 988+ City of Calgary datasets for transit, environment, and government research.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install calgary-opendata
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install calgary-opendata using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is City of Calgary Open Data?
The City of Calgary Open Data skill provides a robust interface for AI agents and developers to interact with the city's vast repository of public data. By integrating this skill into your Openclaw Skills library, you gain the ability to search, filter, and fetch real-time information across nearly a thousand categories including transit, environmental monitoring, and urban census data.
Built on top of the Socrata SODA API, this skill ensures that your AI coding assistant can perform data-driven tasks with accuracy. It serves as a bridge between raw municipal databases and your development environment, making it easier than ever to build applications that are grounded in high-quality, local government data.
City of Calgary Open Data Use Cases
- Analyzing urban transit patterns and facility locations for city planning projects.
- Researching environmental metrics like solar PV production trends within the City of Calgary.
- Integrating real-time municipal dataset search into custom Openclaw Skills workflows.
- Automating the retrieval of census and demographic data for business intelligence reports.
How City of Calgary Open Data Works
- The agent uses the search command to locate relevant dataset IDs based on user keywords.
- The skill fetches metadata for a selected dataset to understand its columns, data types, and row counts.
- Detailed queries are constructed using SQL-like parameters such as where, select, and order.
- The skill executes the request against the City of Calgary Open Data Portal via the SODA API.
- Structured data is returned to the environment in JSON, CSV, or GeoJSON formats for further analysis.
City of Calgary Open Data Setup
To begin using this skill with your Openclaw Skills environment, ensure you have the necessary scripts available in your path. While the skill works without authentication, you can add a Socrata token to avoid rate limits.
# Optional: Set your Socrata App Token
export SOCRATA_APP_TOKEN=your_token_here
# Search for a dataset
python3 scripts/calgary_data.py search "transit"
# Fetch data from a specific dataset ID
python3 scripts/calgary_data.py fetch c9sh-grss --limit 10
City of Calgary Open Data Data Schema & Taxonomy
The skill interacts with the City of Calgary's data taxonomy, identifying datasets by unique 9-character alphanumeric codes. Data is typically returned with the following metadata structure:
| Property | Description |
|---|---|
| Dataset ID | Unique identifier (e.g., iric-4rrc) |
| Column Name | The technical name of the field |
| Column Type | Socrata type (Number, Text, Location, etc.) |
| Categories | Dataset classification such as Environment or Transit |
| Export Formats | Support for JSON, CSV, and GeoJSON (if geocoded) |
City of Calgary Open Data Advanced Features
- SQL-like filtering using the
--whereparameter to narrow down large datasets. - Native GeoJSON support for exporting spatial data directly into mapping applications.
- Pagination controls using
--limitand--offsetfor handling multi-thousand row datasets. - Category-based listing to discover new data sources within the Openclaw Skills ecosystem.
SKILL.md
Loading
Related Openclaw Skills
City of Edmonton Open Data
A Python-based interface for searching, filtering, and fetching thousands of municipal datasets from the City of Edmonton Open Data Portal.
Design to Code (Local)
High-fidelity transformation of design mockups into semantic, responsive, and production-ready frontend code.
Cisco Firewall Hardening Tool
A powerful tool for generating production-ready, CIS-compliant security configurations for Cisco ASA and FTD devices.
NSAP: Neural Sparse Asynchronous Processing
A brain-inspired framework for AI architecture that uses sparse activation and asynchronous processing to maximize efficiency.
Cisco IOS XE Security Hardening Tool
A professional-grade API service designed to automatically generate security-hardened configuration files for Cisco routers and switches running IOS XE.
SEO Companion
A high-performance SEO auditing and execution agent designed for deep technical analysis, content strategy, and on-page optimization.
Featured*
