ERP (Establishments Open to the Public) of BordeauxERP (établissements recevant du public) de Bordeaux
ERP (établissements recevant du public) de BordeauxERP (Establishments Open to the Public) of Bordeaux
This API provides a complete list of establishments open to the public (ERP) in the city of Bordeaux. It is published as part of the Bordeaux Métropole open-data portal and offers free access without authentication. The dataset covers venues such as shops, public buildings, and other facilities accessible to the public within the city, and can be used for mapping, safety planning, or accessibility studies related to public establishments in Bordeaux.Liste complète des établissements ouverts de la ville de Bordeaux recevant du public.
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (13 fields)
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| 100% | avec_hebergementAvec hebergement | text | Indicates whether the establishment offers overnight accommodation.Indicates whether the establishment offers overnight accommodation. |
| 100% | nom_etablissementNom etablissement | text | Name of the establishment open to the public.Name of the establishment open to the public. |
| 100% | propriete_villePropriete ville | text | Indicates whether the building is owned by the city.Indicates whether the building is owned by the city. |
| 94% | categorie | double | Regulatory category code of the establishment (ERP classification).Regulatory category code of the establishment (ERP classification). |
| 94.6% | type | text | Type code of the establishment according to ERP classification.Type code of the establishment according to ERP classification. |
| 98% | adresse_1Adresse 1 | text | First line of the establishment's street address.First line of the establishment's street address. |
| 6.3% | adresse_2Adresse 2 | text | Second line of the establishment's street address, if any.Second line of the establishment's street address, if any. |
| 99.8% | code_postalPostal code | text | Postal code of the establishment's location.Postal code of the establishment's location. |
| 100% | communeCommune | text | Name of the municipality where the establishment is located.Name of the municipality where the establishment is located. |
| 100% | effectif_personnelEffectif personnel | int | Number of staff members at the establishment.Number of staff members at the establishment. |
| — | nb_visiteurs_maxNb visiteurs max | int | Maximum number of visitors allowed in the establishment.Maximum number of visitors allowed in the establishment. |
| — | geometrie | geo_point_2d | Geographic coordinates (latitude and longitude) of the establishment.Geographic coordinates (latitude and longitude) of the establishment. |
| — | canton | text | Canton in which the establishment is located.Canton in which the establishment is located. |
Schema captured from opendatasoft 2 days ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
Sample data (5 records)
Record 1type: N · canton: —
{
"type": "N",
"canton": null,
"commune": "BORDEAUX",
"adresse_1": "15 rue des Faussets",
"adresse_2": null,
"categorie": 5,
"geometrie": {
"lat": 44.840383,
"lon": -0.570594
},
"code_postal": "33000",
"propriete_ville": "0",
"avec_hebergement": "0",
"nb_visiteurs_max": 30,
"nom_etablissement": "RESTAURANT LE JARDIN GOURMAND",
"effectif_personnel": 0
}Record 2type: W · canton: —
{
"type": "W",
"canton": null,
"commune": "BORDEAUX",
"adresse_1": "25 rue Pierre Loti",
"adresse_2": null,
"categorie": 5,
"geometrie": {
"lat": 44.824558,
"lon": -0.55924
},
"code_postal": "33800",
"propriete_ville": "0",
"avec_hebergement": "0",
"nb_visiteurs_max": 0,
"nom_etablissement": "SESSAD TGP",
"effectif_personnel": 0
}Record 3type: N · canton: —
{
"type": "N",
"canton": null,
"commune": "BORDEAUX",
"adresse_1": "67 COURS DE LA SOMME",
"adresse_2": null,
"categorie": 5,
"geometrie": {
"lat": 44.854647,
"lon": -0.572877
},
"code_postal": "33000",
"propriete_ville": "0",
"avec_hebergement": "0",
"nb_visiteurs_max": 0,
"nom_etablissement": "RESTAURANT CHEZ NADINE",
"effectif_personnel": 0
}Record 4type: M · canton: 13 St Jean Belcier Carle Vernet Albert 1
{
"type": "M",
"canton": "13 St Jean Belcier Carle Vernet Albert 1er Sacré C",
"commune": "BORDEAUX",
"adresse_1": "RUES DE TAUZIA / GRENIER / BELLE ETOILE",
"adresse_2": null,
"categorie": 5,
"geometrie": null,
"code_postal": "33000",
"propriete_ville": "0",
"avec_hebergement": "0",
"nb_visiteurs_max": 0,
"nom_etablissement": "LES JARDINS DE TAUZIA - COMMERCE 1",
"effectif_personnel": 0
}Record 5type: R · canton: 03 Chartrons Grand parc
{
"type": "R",
"canton": "03 Chartrons Grand parc",
"commune": "BORDEAUX",
"adresse_1": "181 COURS DU MEDOC",
"adresse_2": null,
"categorie": 5,
"geometrie": {
"lat": 44.864093,
"lon": -0.573405
},
"code_postal": "33300",
"propriete_ville": "1",
"avec_hebergement": "0",
"nb_visiteurs_max": 12,
"nom_etablissement": "CRECHE LES JARDINS D'HAUSSMANN",
"effectif_personnel": 5
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Configuration
- Base URL
- https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_erp/records?limit=20' -H 'Accept: application/json'First 20 records of the dataset as JSON.
Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.
Rate limits
Dataset
Volume & freshness
License
No license declared upstream.
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.