← 返回 Skills 市场
raychanpmp

City of Edmonton Open Data

作者 Ray Chan, PMP · GitHub ↗ · v1.0.3 · MIT-0
cross-platform ✓ 安全检测通过
134
总下载
0
收藏
0
当前安装
4
版本数
在 OpenClaw 中安装
/install edmonton-opendata
功能描述
Access 2,179+ datasets from the City of Edmonton open data portal. Search, fetch, and analyze city data on transit, traffic, environment, census, and more. D...
使用说明 (SKILL.md)

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

# 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

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., "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

Variable Required Description
SOCRATA_APP_TOKEN No Optional Socrata app token to reduce rate limits. Works without it.
安全使用建议
This skill appears to do exactly what it says: query the City of Edmonton Socrata open-data portal. Things to consider before installing: (1) the script caches the dataset catalog to a .cache/catalog.json file inside the skill directory (it may grow if you run large queries) — check or change the cache location if you have storage/privacy concerns; (2) the only environment variable is an optional SOCRATA_APP_TOKEN to reduce rate limits — do not provide unrelated secrets; (3) SKILL.md notes 'permissions: Bash' although the implementation is Python — benign but slightly inconsistent; (4) the skill will make outbound HTTPS requests to data.edmonton.ca when used, so run under normal network policies you trust. If you want extra assurance, inspect or run the included scripts in a sandboxed environment before enabling autonomous invocation.
功能分析
Type: OpenClaw Skill Name: edmonton-opendata Version: 1.0.3 The skill bundle provides a legitimate interface for accessing the City of Edmonton's Open Data portal via the Socrata SODA API. The Python script (scripts/edmonton_data.py) uses only standard libraries to search, list, and fetch public datasets from data.edmonton.ca, with no evidence of data exfiltration, malicious execution, or prompt injection.
能力评估
✓ Purpose & Capability
Name/description claim access to City of Edmonton open data; the included script implements Socrata API calls to data.edmonton.ca and provides search, list, info, fetch, categories, popular, and geojson commands — all consistent with the stated purpose. No unrelated services or credentials are requested.
ℹ Instruction Scope
SKILL.md instructs running the included Python script and documents an optional SOCRATA_APP_TOKEN environment variable. The script performs only network calls to data.edmonton.ca and writes a local cache file (.cache/catalog.json) inside the skill directory. Note: the SKILL.md header lists 'permissions: Bash' although the code is a Python CLI; this is a minor mismatch but does not indicate broader scope creep.
✓ Install Mechanism
No install spec; this is instruction-only with an included Python script that has no third‑party dependencies (uses stdlib urllib). No network downloads or archive extraction during install, so install risk is low.
✓ Credentials
Only an optional SOCRATA_APP_TOKEN is referenced to reduce rate limits; no other secrets, tokens, or unrelated environment variables are requested or accessed by the code.
✓ Persistence & Privilege
Skill does not request always:true, does not modify other skills or system configuration, and only writes a cache file in its own directory. Autonomous invocation remains enabled (platform default) but is not accompanied by broad credentials or escalated privileges.
如何使用
  1. 确保已安装 OpenClaw（本地或 Docker 部署）
  2. 在对话框中输入安装命令：/install edmonton-opendata
  3. 安装完成后，直接呼叫该 Skill 的名称或使用 /edmonton-opendata 触发
  4. 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.3
Fixed: cache now in skill directory instead of home; documented optional env var
v1.0.2
Fixed description wording — removed awkward phrasing flagged as suspicious
v1.0.1
Trim triggers list to fix 'too long' security issue
v1.0.0
Initial release — search, fetch, and analyze 2,179+ City of Edmonton open datasets via the Socrata SODA API
元数据
Slug edmonton-opendata
版本 1.0.3
许可证 MIT-0
累计安装 0
当前安装数 0
历史版本数 4
常见问题

City of Edmonton Open Data 是什么？

Access 2,179+ datasets from the City of Edmonton open data portal. Search, fetch, and analyze city data on transit, traffic, environment, census, and more. D... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 134 次。

如何安装 City of Edmonton Open Data？

在 OpenClaw 或 Claude Code 对话框中运行命令「/install edmonton-opendata」即可一键安装，无需额外配置。

City of Edmonton Open Data 是免费的吗？

是的，City of Edmonton Open Data 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。

City of Edmonton Open Data 支持哪些平台？

City of Edmonton Open Data 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。

谁开发了 City of Edmonton Open Data？

由 Ray Chan, PMP（@raychanpmp）开发并维护，当前版本 v1.0.3。

推荐 Skills
self-improving agent
Captures learnings, errors, and corrections to enable continuous improvement. Use when: (1) A command or operation fails unexpectedly, (2) User corrects Clau...
⬇ 463283 · by pskoett
Skill Vetter
Security-first skill vetting for AI agents. Use before installing any skill from ClawdHub, GitHub, or other sources. Checks for red flags, permission scope, and suspicious patterns.
⬇ 259410 · by spclaudehome
Polymarket
Query Polymarket prediction markets. Check odds, find trending markets, search events, track price movements.
⬇ 232503 · by joelchance
Self-Improving + Proactive Agent
Self-reflection + Self-criticism + Self-learning + Self-organizing memory. Agent evaluates its own work, catches mistakes, and improves permanently. Use when...
⬇ 200423 · by ivangdavila
Github
Interact with GitHub using the `gh` CLI. Use `gh issue`, `gh pr`, `gh run`, and `gh api` for issues, PRs, CI runs, and advanced queries.
⬇ 191115 · by steipete
ontology
Typed knowledge graph for structured agent memory and composable skills. Use when creating/querying entities (Person, Project, Task, Event, Document), linkin...
⬇ 190156 · by oswalpalash

💬 留言讨论