API and developers
This demo is a static site: the catalogue, every table and the metadata are published as files, in CKAN and DCAT-AP formats. No key, open CORS.
Behind this site the catalogue runs on the PoC’s CKAN service (CKAN 2.11): the same data is served by CKAN’s standard Action API, with search, filters and SQL over the tables; 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)
A dataset’s metadata (CKAN package_show format): RGA2020_epci
Governance report: freshness, schemas, licences and personal data per dataset, per service and per organisation
The tables
Every table is a JSON file (CKAN DataStore format: columns then rows), a CSV and, with geometries, a GeoJSON. Example: RGA2020_epci
The whole table as JSON
curl '/data/tables/264fc8d3-8074-4133-a155-03571ba4b424.json'
The whole table as CSV
A table with geometries as GeoJSON: RGA2020_epci
DCAT-AP
The whole catalogue in DCAT-AP 3 (ckanext-dcat), with EU frequency and licence URIs and high-value dataset categories. Every dataset page also gives its own DCAT record.
Catalogue (RDF/XML)
Catalogue (JSON-LD)
The CAPB’s and the communes’ own datasets (RDF/XML): what data.gouv.fr would harvest
Without the copies of national datasets, which stay published by their original publisher.
The static files and the CKAN API
Every file of this demo stands for a call on the PoC’s CKAN service, which also takes filters, paging and SQL.
| File in this demo | CKAN | Call on the PoC’s 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?q=…&fq=organization:<organisation> |
Read with no key and no quota. Writing (publishing, updating) uses one CKAN API token per publisher.