culture-and-recreation

name: Culture and Recreation description: | EN: Access Montreal's parks, cultural facilities, programming, public art, and recreational infrastructure through CKAN datasets. FR: Accédez aux parcs, installations culturelles, programmation, art public et infrastructures récréatives de Montréal via les données CKAN. triggers: - culture - recreation - parks - facilities - sports - arts - murals - patinoires - skating rinks - programming - parcs - installations - programmation - art public

Culture and Recreation / Culture et Loisirs

Access Montreal's parks, recreational facilities, cultural programming, public art installations, and seasonal conditions through the CKAN open data portal.

Available Datasets / Ensembles de données disponibles

Real-time Condition Feeds / Flux temps réel

Note: Skating rink (patinoires) and ski (conditions-ski) real-time conditions are NOT in DataStore. They are available as separate JSON feeds updated throughout the day. Query these directly via their feed endpoints rather than through standard DataStore SQL queries.

Common SQL Queries / Requêtes SQL courantes

Find all parks in a specific borough

SELECT name, borough, type, address
FROM "grands-parcs-parcs-d-arrondissements-et-espaces-publics"
WHERE borough = 'Plateau-Mont-Royal'
ORDER BY name;

List cultural facilities with type filtering

SELECT name, address, borough, facility_type, phone
FROM "installations-recreatives-sportives-et-culturelles"
WHERE facility_type ILIKE '%cultural%'
  OR facility_type ILIKE '%art%'
ORDER BY borough, name;

Find murals near a location (requires lat/lon)

SELECT title, artist, address, coordinates
FROM "murales"
WHERE ST_DWithin(
  coordinates::geography,
  ST_SetSRID(ST_MakePoint(-73.5673, 45.5017), 4326)::geography,
  500
)
ORDER BY title;

Search programming by activity type

SELECT activity_name, schedule, location, borough
FROM "programmation-sports-loisirs-montreal"
WHERE activity_name ILIKE '%swimming%'
  OR activity_name ILIKE '%natation%'
LIMIT 20;

Common Questions / Questions fréquentes

Gotchas / Pièges

1. Real-time condition feeds — patinoires and conditions-ski update throughout the day via separate JSON feeds, NOT through DataStore. Standard SQL queries won't capture live updates.

2. Park names are proper nouns — Always match exact capitalization and accents when filtering by park name (e.g., "Parc La Fontaine", not "parc la fontaine").

3. Borough filtering — Borough names are specific and case-sensitive. Use exact values like "Plateau-Mont-Royal", "Rosemont–La Petite-Patrie", "Ville-Marie".

4. Seasonal data — Programming and facility availability vary by season. Filter results by date ranges if querying historical or future schedules.

5. Coordinates format — Some datasets use PostGIS geometry; others use text coordinates. Check schema before performing spatial queries.

6. Funding records — Support datasets (soutien-artistes-organismes-culturels) may have annual publication delays. Current year data may not be available.

Provenance / Provenance

Related Skills / Compétences connexes

• Permits & Buildings — batiments-certifies-qualite-famille overlaps with family-certified facility queries
• Events & Programming — Complements programmation-sports-loisirs-montreal scheduling
• Geography & Boundaries — Required for borough filtering and spatial queries
• Arts & Heritage — Connects to public art and cultural funding datasets