A Python-based interface for searching, filtering, and fetching thousands of municipal datasets from the City of Edmonton Open Data Portal.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install edmonton-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 edmonton-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 Edmonton Open Data?
This skill provides a robust interface to the City of Edmonton Open Data Portal, allowing developers and data scientists to tap into a vast repository of municipal information. By utilizing Openclaw Skills, users can programmatically interact with the Socrata SODA API to search for datasets, inspect metadata, and extract specific data points for analysis.
The integration simplifies the process of gathering urban data, offering a bridge to over 2,179 datasets covering everything from traffic patterns and transit routes to environmental metrics and census results. It is designed to facilitate rapid data discovery and extraction for researchers and developers working on urban solutions.
City of Edmonton Open Data Use Cases
- Gathering real-time traffic and transit statistics for logistics and transportation modeling.
- Analyzing census data for demographic research and municipal urban development projects.
- Monitoring city administration, budgeting, and environmental metrics through open records.
- Exporting geospatial data in GeoJSON format for mapping and GIS analysis.
How City of Edmonton Open Data Works
- Identify relevant datasets by using the search command with specific keywords like traffic or environment.
- Review dataset metadata using the info command to understand the available columns, data types, and total row counts.
- Construct queries using SQL-like filters to isolate specific records based on your research needs.
- Execute the fetch command to retrieve the data in your preferred format.
- Integrate the exported JSON, CSV, or GeoJSON data into your local analysis environment or application.
City of Edmonton Open Data Setup
To start using this Openclaw Skills integration, ensure you have Python 3 installed. You can immediately begin searching for data using the following command:
python3 scripts/edmonton_data.py search "traffic"
While the skill works without authentication, you can avoid rate limits by providing a Socrata app token:
export SOCRATA_APP_TOKEN='your_api_token'
City of Edmonton Open Data Data Schema & Taxonomy
The skill organizes data based on the Socrata SODA API taxonomy. Below is how the data is structured during interaction:
| Component | Description | Example |
|---|---|---|
| Dataset ID | A unique 9-character alphanumeric identifier for each dataset. | 24uj-dj8v |
| Metadata | Includes column names, data types (Number, Text, Point), and row counts. | construction_value (Number) |
| Output Formats | Supports standard data interchange formats for diverse workflows. | JSON, CSV, GeoJSON |
| Categories | Datasets are grouped by city departments and functions. | Transit, Infrastructure, Environment |
City of Edmonton Open Data Advanced Features
- Complex filtering capabilities using the SODA Query Language via the --where flag for precise data subsets.
- Built-in GeoJSON export functionality for datasets containing spatial or coordinate data.
- Advanced pagination support using --limit and --offset to handle high-volume data retrieval without crashing.
- Customizable column selection via the --select flag to optimize payload size and processing speed.
SKILL.md
Loading
Related Openclaw Skills
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.
NormieClaw Subscription Tracker
A privacy-focused AI agent that scans bank statements to detect, track, and manage recurring subscriptions without requiring direct bank access.
City of Calgary Open Data
Effortlessly query and retrieve 988+ City of Calgary datasets for transit, environment, and government research.
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.
Featured*
