alistaircroll
Community@alistaircroll
Bilingual skill suite for querying, joining, and visualizing Montréal's 436+ CKAN open datasets spanning transit, budgets, safety, environment, and infrastructure.
Agent Skills by alistaircroll
Showing 20 vetted skills indexed across 1 GitHub repositories.
alistaircrolltransit
Access Montréal transit data from STM, BIXI, Exo, and STL feeds.
alistaircrollbudget-and-finance
Query Montréal budget, contracts, subsidies, tax rates, and real estate datasets via CKAN DataStore SQL.
alistaircrollsafety
Query Montréal public safety datasets including crime, collisions, 311 requests, and fire interventions.
alistaircrollenvironment
Query Montréal environmental datasets including tree inventory, air quality, and green spaces via CKAN API.
alistaircrollMontreal Infrastructure Data
Query Montreal infrastructure datasets via CKAN REST, SOAP, and Overpass APIs.
alistaircrollpermits-and-planning
Query Montréal building permits, zoning, property assessments, and land use datasets via CKAN API.
alistaircrollCulture and Recreation
Query Montreal parks, cultural facilities, programming, and public art datasets via CKAN.
alistaircrollunderstand-ckan
Documents the CKAN Action API endpoints, pagination, and conventions for Montréal's open data portal.
alistaircrolldownload-resource
Download raw CSV, GeoJSON, Shapefile, PDF, and GBFS files from Montréal's open data portal.
alistaircrollquery-dataset
Query tabular data from Montréal's open data portal via the CKAN DataStore API.
alistaircrolldiscover-datasets
Search and browse Montréal's open data catalog via the CKAN API.
alistaircrollvisualization
Generates charts, maps, tables, and CSV exports from Montréal open data query results.
alistaircrolltime-series
Analyze temporal trends, seasonality, and anomalies in Montréal open datasets using CKAN SQL.
alistaircrollcross-dataset-joins
Combines multiple Montréal CKAN datasets via client-side borough, proximity, and temporal joins.
alistaircrolladdress-geocoding
Convert Montréal addresses to coordinates using Nominatim and open dataset lookups.
alistaircrollspatial-queries
Implements bounding-box SQL filters and Haversine distance calculations for proximity queries on Montréal open datasets.
alistaircrollborough-context
Provides reference data for Montréal's 19 boroughs and 15 reconstituted municipalities.
alistaircrolldata-freshness
Detect stale Montréal open data and interpret dataset update schedules.
alistaircrollbilingual-handling
Translates search terms and field names between French and English for Montréal open data queries.
alistaircrollerror-recovery
Diagnose and recover from CKAN API failures when querying Montréal open data endpoints.
Frequently Asked Questions About alistaircroll
FAQPage SchemaWhat tasks can I accomplish with alistaircroll's Montréal open data skills?▼
You can discover and query 436+ Montréal datasets covering STM transit, BIXI bikes, budgets, contracts, crime incidents, 311 requests, tree inventory, building permits, zoning, snow removal, and parking. Skills support SQL queries, filtered searches, aggregation, geocoding, spatial radius queries, cross-dataset joins, and time-series trend analysis.
Who are these Montréal data skills designed for?▼
They target civic data analysts, urban planners, journalists, researchers, and developers building on Montréal's open data portal. Bilingual French/English handling, borough reference data for all 19 arrondissements, and field-name mappings make them accessible to both francophone and anglophone users.
How do the skills access and process Montréal's data at runtime?▼
Skills query the CKAN DataStore API for tabular data with SQL, filters, and pagination, and download raw CSV, GeoJSON, Shapefile, PDF, and GBFS files directly. Infrastructure data uses REST and SOAP endpoints plus Overpass QL for nearby amenities, with built-in error recovery for timeouts and rate limits.
What prerequisites or dependencies do these skills require?▼
Skills rely on Montréal's public open data portal at donnees.montreal.ca and its CKAN API, which the included reference guide covers for authentication, endpoints, and pagination. Spatial queries assume WGS84 coordinates; no proprietary services or paid data sources are required.
Can I combine and visualize multiple Montréal datasets together?▼
Yes. Dedicated skills handle borough-based, proximity, and temporal joins while working around CKAN's single-table SQL limitation. Visualization patterns produce HTML/SVG inline charts, text tables, and map links, with data-freshness checks to detect stale datasets before analysis.