API and developers
This demo is a static website: the catalogue, every table and the metadata are published as plain files in CKAN's and DCAT-AP formats. No key needed, open CORS.
In service, the catalogue runs on CKAN: the same data comes from the standard CKAN Action API, with search, filters and SQL on the tables, so existing CKAN clients and the data.gouv.fr harvester work unchanged.
The catalogue
Every dataset: title, description, themes, formats, service
curl '/data/search.json'
Publishers (CKAN organization_list format)
Themes (CKAN group_list format)
One dataset's metadata (CKAN package_show format): Délibérations
Governance report: freshness, schemas and metadata per dataset and service
Tables
Each table is one JSON file (CKAN DataStore format: columns, then rows), one CSV and, with geometries, one GeoJSON. Example: Délibérations
The whole table as JSON
curl '/data/tables/ecd9c5ef-0a4b-4e96-9f32-d581245ff327.json'
The whole table as CSV
A table with geometries as GeoJSON: Equipements publics cannois
DCAT-AP
The whole catalogue in DCAT-AP 3 (ckanext-dcat), with EU frequency and licence URIs and high-value dataset categories. Each dataset page also links its own DCAT record.
Catalogue (RDF/XML)
Catalogue (JSON-LD)
Ville de Cannes datasets only (RDF/XML)
The old data.cannes.com DCAT export address, which data.gouv.fr harvests daily, redirects here, so the harvest keeps working:
/api/explore/v2.1/catalog/exports/dcat/?where=…
Static files and the CKAN API
Each file of this demo stands for a CKAN call; on the CKAN service the calls also take filters, paging and SQL.
| File in this demo | CKAN | Call on the CKAN service |
|---|---|---|
| /data/search.json | package_search | /api/3/action/package_search?q=…&fq=groups:finances |
| /data/datasets/<name>.json | package_show | /api/3/action/package_show?id=<name> |
| /data/organizations.json | organization_list | /api/3/action/organization_list?all_fields=true |
| /data/groups.json | group_list | /api/3/action/group_list?all_fields=true |
| /data/tables/<id>.json | datastore_search | /api/3/action/datastore_search?resource_id=<id>&filters={…}&q=… |
| — | datastore_search_sql | /api/3/action/datastore_search_sql?sql=SELECT … FROM "<id>" |
| /data/tables/<id>.csv | /datastore/dump | /datastore/dump/<id>?format=csv|json|tsv|xlsx |
| /catalog.ttl, .xml, .jsonld | ckanext-dcat | /catalog.ttl?fq=organization:ville-de-cannes |
Read-only access with no key. In service, writing (publishing, updating) needs a CKAN API token per service.