Drinking water fountains of the city of BordeauxFontaines d'eau potable de la ville de Bordeaux
Fontaines d'eau potable de la ville de BordeauxDrinking water fountains of the city of Bordeaux
This API provides the location of public drinking water fountains in the city of Bordeaux, published via the Bordeaux Métropole open data portal. For each fountain it indicates the model, operational status, and any information signs displayed on it. The dataset also includes fountains located in cemeteries, some of which are not suitable for drinking, a detail specified in the fountain model field. It is useful for mapping public water access points and monitoring their maintenance status across the city.Emplacement des fontaines à boire de la ville de Bordeaux avec modèle, état de fonctionnement et affichettes présentes sur les fontaines. Comprend également les fontaines des cimetières dont certaines sont non-potables (précisé dans le modèle de la fontaine).
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% | id | double | identifiant fontaine |
| 100% | nom_fontaineNom fontaine | text | Nom de la fontaine |
| 100% | nombre_robinetsNombre robinets | double | nombre de robinets de la fontaine |
| 100% | modele_fontaineModèle_fontaine | text | modèle de fontaine |
| 100% | x | double | — |
| 100% | y | double | — |
| 100% | adresse | text | adresse et précisions sur la localisation de la fontaine |
| 100% | date_dernier_controledate_dernier_contrôle | date | date du dernier contrôle technique |
| 100% | etatétat | text | état de fonctionnement de la fontaine : Fonctionnelle : en fonctionnement Condamnée : fermée, non alimentée Hors service : problème technique empêchant son bon fonctionnement Inaccessible : des travaux sur l’espace public en empêche l’accès |
| 100% | hivernage | text | mise en hivernage de la fontaine |
| — | complement_informationcomplément_information | text | contenu de l'affichette en place sur la fontaine |
| — | geom | geo_point_2d | — |
| — | code_inseeINSEE commune code | text | — |
Schema captured from opendatasoft 1 day 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 1x: 1418687.2427895 · y: 4190985.3827378
{
"x": 1418687.2427895,
"y": 4190985.3827378,
"id": 1,
"etat": "fonctionnelle",
"geom": {
"lat": 44.863239439273954,
"lon": -0.5608207350033559
},
"adresse": "place John Lewis Brown, 33300 Bordeaux",
"hivernage": "oui",
"code_insee": "33063",
"nom_fontaine": "J. Lewis Brown",
"modele_fontaine": "BAYARD",
"nombre_robinets": 1,
"date_dernier_controle": "2026-03-05",
"complement_information": null
}Record 2x: 1418093.9831366 · y: 4187797.1171791
{
"x": 1418093.9831366,
"y": 4187797.1171791,
"id": 4,
"etat": "fonctionnelle",
"geom": {
"lat": 44.8343402809431,
"lon": -0.5665452083357112
},
"adresse": "Place Meynard, 33800 Bordeaux",
"hivernage": "oui",
"code_insee": "33063",
"nom_fontaine": "Place Saint Michel",
"modele_fontaine": "METALCO",
"nombre_robinets": 1,
"date_dernier_controle": "2026-03-11",
"complement_information": null
}Record 3x: 1418096.4120676 · y: 4187697.41602
{
"x": 1418096.4120676,
"y": 4187697.41602,
"id": 5,
"etat": "fonctionnelle",
"geom": {
"lat": 44.83344486927675,
"lon": -0.5664590333341131
},
"adresse": "rue gaspard philippe, 33800 Bordeaux",
"hivernage": "non",
"code_insee": "33063",
"nom_fontaine": "Place Saint Michel",
"modele_fontaine": "METALCO",
"nombre_robinets": 1,
"date_dernier_controle": "2026-03-11",
"complement_information": null
}Record 4x: 1414351.2952797 · y: 4189944.4423268
{
"x": 1414351.2952797,
"y": 4189944.4423268,
"id": 11,
"etat": "fonctionnelle",
"geom": {
"lat": 44.85215358761391,
"lon": -0.6150448649982171
},
"adresse": "Place de l'église Saint Amand, 33200 Bordeaux Caudéran",
"hivernage": "non",
"code_insee": "33063",
"nom_fontaine": "Place de l’Eglise St Amand",
"modele_fontaine": "TANA",
"nombre_robinets": 1,
"date_dernier_controle": "2026-03-06",
"complement_information": null
}Record 5x: 1416659.3695889 · y: 4188836.2377277
{
"x": 1416659.3695889,
"y": 4188836.2377277,
"id": 16,
"etat": "fonctionnelle",
"geom": {
"lat": 44.84311295594552,
"lon": -0.5852529883395016
},
"adresse": "Place des Martyrs de la Résistance, 60 rue Rodriguès-Peirere, 33000 Bordeaux",
"hivernage": "non",
"code_insee": "33063",
"nom_fontaine": "Place des Martyrs de la Résistance (proche basilique Saint Seurin)",
"modele_fontaine": "TANA",
"nombre_robinets": 1,
"date_dernier_controle": "2026-03-06",
"complement_information": null
}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_fontaines_eau_potable
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/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.