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

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

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).

water

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (13 fields)

Filterable via the API (12)

idnom_fontainenombre_robinetsmodele_fontainexyadressedate_dernier_controleetathivernagecomplement_informationcode_insee

Click a field to see example values.

Fill	Field	Type	Description
100%	id	double	Unique identifier of the fountain.identifiant fontaine
100%	nom_fontaineNom fontaine	text	Name of the drinking fountain.Nom de la fontaine
100%	nombre_robinetsNombre robinets	double	Number of taps on the fountain.nombre de robinets de la fontaine
100%	modele_fontaineModèle_fontaine	text	Model or type of the fountain.modèle de fontaine
100%	x	double	X coordinate of the fountain in the local projection system.X coordinate of the fountain in the local projection system.
100%	y	double	Y coordinate of the fountain in the local projection system.Y coordinate of the fountain in the local projection system.
100%	adresse	text	Address and location details of the fountain.adresse et précisions sur la localisation de la fontaine
100%	date_dernier_controledate_dernier_contrôle	date	Date of the fountain's last technical inspection.date du dernier contrôle technique
100%	etatétat	text	Operating status of the fountain (functional, closed, out of service, inaccessible).é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	Indicates whether the fountain is put into winter shutdown.mise en hivernage de la fontaine
—	complement_informationcomplément_information	text	Text of the notice displayed on the fountain.contenu de l'affichette en place sur la fontaine
—	geom	geo_point_2d	Geographic coordinates (latitude/longitude) of the fountain.Geographic coordinates (latitude/longitude) of the fountain.
—	code_inseeINSEE commune code	text	INSEE code of the municipality where the fountain is located.INSEE code of the municipality where the fountain is located.

Schema captured from opendatasoft 4 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.

Where=

Sort by

Sample data (5 records)

Record 1x: 1418729.38 · y: 4190519.11

{
  "x": 1418729.38,
  "y": 4190519.11,
  "id": 262,
  "etat": "fonctionnelle",
  "geom": {
    "lat": 44.85906402482394,
    "lon": -0.5600289047862554
  },
  "adresse": "rue Emile Peynaud, 33300 Bordeaux",
  "hivernage": "oui",
  "code_insee": "33063",
  "nom_fontaine": "jardin de ta soeur",
  "modele_fontaine": "METALCO\n+\nabreuvoir",
  "nombre_robinets": 1,
  "date_dernier_controle": "2026-03-05",
  "complement_information": null
}

Record 2x: 1417730.71 · y: 4186155.89

{
  "x": 1417730.71,
  "y": 4186155.89,
  "id": 191,
  "etat": "fonctionnelle",
  "geom": {
    "lat": 44.81944073251538,
    "lon": -0.5702209029855192
  },
  "adresse": "278 rue Pelleport, 33800 Bordeaux",
  "hivernage": "non",
  "code_insee": "33063",
  "nom_fontaine": "Square Paul Antin",
  "modele_fontaine": "BAYARD",
  "nombre_robinets": 1,
  "date_dernier_controle": "2026-03-09",
  "complement_information": null
}

Record 3x: 1419264.1699947 · y: 4186594.6511227

{
  "x": 1419264.1699947,
  "y": 4186594.6511227,
  "id": 45,
  "etat": "fonctionnelle",
  "geom": {
    "lat": 44.82399172273586,
    "lon": -0.5510932277570527
  },
  "adresse": "Place Ferdinand Buisson, 33800 Bordeaux",
  "hivernage": "oui",
  "code_insee": "33063",
  "nom_fontaine": "Place Ferdinand Buisson",
  "modele_fontaine": "METLACO",
  "nombre_robinets": 1,
  "date_dernier_controle": "2026-03-04",
  "complement_information": null
}

Record 4x: 1418444.4641783 · y: 4187799.966253

{
  "x": 1418444.4641783,
  "y": 4187799.966253,
  "id": 148,
  "etat": "fonctionnelle",
  "geom": {
    "lat": 44.834504599275334,
    "lon": -0.5621183816728135
  },
  "adresse": "Quai de la Monnaie, 33800 Bordeaux",
  "hivernage": "oui",
  "code_insee": "33063",
  "nom_fontaine": "Quai des Salinières (Grave)",
  "modele_fontaine": "FONTAINE MONUMENT PIERRE",
  "nombre_robinets": 3,
  "date_dernier_controle": "2026-03-13",
  "complement_information": null
}

Record 5x: 1418306.39 · y: 4186452.69

{
  "x": 1418306.39,
  "y": 4186452.69,
  "id": 230,
  "etat": "fonctionnelle",
  "geom": {
    "lat": 44.822337123230014,
    "lon": -0.5631139096976988
  },
  "adresse": "110 rue Pelleport, 33000 Bordeaux",
  "hivernage": "oui",
  "code_insee": "33063",
  "nom_fontaine": "Place Cardinal / Eglise Sacré Cœur",
  "modele_fontaine": "METALCO",
  "nombre_robinets": 1,
  "date_dernier_controle": "2026-03-09",
  "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

Licence Ouverte 2.0 (France / Etalab)Open

✓ 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.

Full API documentation ↗

Rate limits

50 000 req/day

per ipmeasured

observed 4 days ago

Dataset

Volume & freshness

Records

279

Last upstream update

7 months ago

2026-03-26

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.