Drinking Fountains (Marseille and Allauch) - Metropolitan ManagementFontaines à boire (Marseille et Allauch) - Gestion métropolitaine

Fontaines à boire (Marseille et Allauch) - Gestion métropolitaineDrinking Fountains (Marseille and Allauch) - Metropolitan Management

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This dataset lists the locations of public drinking water fountains along streets and roads in Marseille and Allauch, as recorded by the services of the Aix-Marseille-Provence Metropolis. For each fountain it provides the model and operating status (functional or out of service). Fountains installed in municipal parks and gardens are excluded, since those fall under separate communal management rather than metropolitan authority. The dataset is published as open data by the metropolis and is useful for locating public drinking water access points on public roads within the two municipalities.Localisation des fontaines à boire (eau potable) sur la voierie, avec modèle et état de fonctionnement, recensées par les services de la métropole. Les fontaines installées dans les parcs et jardins publics ne sont pas disponibles dans ce jeu de donnée (gestion communale). Points collectés sur le...

⬇ 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 (26 fields)

Filterable via the API (24)

objectidcodenomadressevillenom_de_la_communemodelelatitudelongitudeen_servicecommentairesphotourl_photonom_donneedatemajsourcecodecommcodeinseereceptionnb_pjcreated_usercreated_datelast_edited_userlast_edited_date

Click a field to see example values.

Fill	Field	Type	Description
100%	objectid	int	Internal unique record identifier.Internal unique record identifier.
100%	code	text	Unique code identifying the drinking fountain.Unique code identifying the drinking fountain.
100%	nom	text	Name or label of the fountain.Name or label of the fountain.
100%	adresse	text	Street address where the fountain is located.Street address where the fountain is located.
100%	ville	text	City where the fountain is located.City where the fountain is located.
100%	nom_de_la_communeCommune	text	Name of the municipality or district.Name of the municipality or district.
100%	modele	text	Model or manufacturer type of the fountain.Model or manufacturer type of the fountain.
100%	latitudeLatitude	double	Latitude coordinate of the fountain's location.Latitude coordinate of the fountain's location.
100%	longitudeLongitude	double	Longitude coordinate of the fountain's location.Longitude coordinate of the fountain's location.
100%	en_serviceEtat (en service / hors service)	text	Operating status: in service or out of service.Operating status: in service or out of service.
4.9%	commentaires	text	Free-text comments about the fountain.Free-text comments about the fountain.
97.2%	photo	text	File name of the fountain's photo.File name of the fountain's photo.
100%	url_photoUrl photo	text	URL link to the fountain's photo.URL link to the fountain's photo.
100%	nom_donneeNom de la Donnée	text	Name of the dataset the record belongs to.Name of the dataset the record belongs to.
100%	datemajDate	datetime	Date the record was last updated.Date the record was last updated.
100%	sourceSource de production	text	Organization or department that produced the data.Organization or department that produced the data.
97.2%	codecommCode Commune DGFIP	text	Municipality code from the DGFIP registry.Municipality code from the DGFIP registry.
100%	codeinseeCode Commune INSEE	text	Municipality code from the INSEE registry.Municipality code from the INSEE registry.
100%	receptionRéception	text	Indicates whether the fountain has been officially accepted/commissioned.Indicates whether the fountain has been officially accepted/commissioned.
100%	geo_shapeShape	geo_shape	Geographic geometry of the fountain's location.Geographic geometry of the fountain's location.
—	geo_point_2dCoordinates	geo_point_2d	Geographic point coordinates (latitude and longitude) of the fountain.Geographic point coordinates (latitude and longitude) of the fountain.
—	nb_pjNb documents	int	Number of attached documents or files.Number of attached documents or files.
—	created_userCreated user	text	User or service that created the record.User or service that created the record.
—	created_dateCreated date	datetime	Date and time the record was created.Date and time the record was created.
—	last_edited_userLast edited user	text	User or service that last edited the record.User or service that last edited the record.
—	last_edited_dateLast edited date	datetime	Date and time the record was last edited.Date and time the record was last edited.

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.

Where=

Sort by

Sample data (5 records)

Record 1nom: MALPASSE · code: BF-13008

{
  "nom": "MALPASSE",
  "code": "BF-13008",
  "nb_pj": 1,
  "photo": "BF-13008.jpg",
  "ville": "Marseille",
  "modele": "BAYARD",
  "source": "DGEP",
  "adresse": "7 Av. de St Paul",
  "datemaj": "2026-04-23T12:30:18+00:00",
  "codecomm": "131213",
  "latitude": 43.32670972,
  "objectid": 2053,
  "codeinsee": "13213",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.41058596439335,
        43.326709726064216
      ]
    },
    "properties": {}
  },
  "longitude": 5.41058596,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-13008.jpg",
  "en_service": "HORS SERVICE",
  "nom_donnee": "Fontaines à boire voirie",
  "commentaires": "BF Arrachée",
  "created_date": "2024-12-20T16:37:50+00:00",
  "created_user": "VOIRIE",
  "geo_point_2d": {
    "lat": 43.326709726064216,
    "lon": 5.41058596439335
  },
  "last_edited_date": null,
  "last_edited_user": "dona_habib.djimenou_bossou@ampmetropole.fr",
  "nom_de_la_commune": "Marseille XIII"
}

Record 2nom: GRAND PAVOIS · code: BF-08019

{
  "nom": "GRAND PAVOIS",
  "code": "BF-08019",
  "nb_pj": 1,
  "photo": "BF-08019.jpg",
  "ville": "Marseille",
  "modele": "ATLAS",
  "source": "DGEP",
  "adresse": "324 Avenue du Prado (grand pavois arrêt de bus vers plage)",
  "datemaj": "2024-12-20T16:37:50+00:00",
  "codecomm": "131208",
  "latitude": 43.27201439,
  "objectid": 2059,
  "codeinsee": "13208",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.390254407530504,
        43.27201439283014
      ]
    },
    "properties": {}
  },
  "longitude": 5.39025441,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-08019.jpg",
  "en_service": "EN SERVICE",
  "nom_donnee": "Fontaines à boire voirie",
  "commentaires": null,
  "created_date": "2024-12-20T16:37:50+00:00",
  "created_user": "VOIRIE",
  "geo_point_2d": {
    "lat": 43.27201439283014,
    "lon": 5.390254407530504
  },
  "last_edited_date": null,
  "last_edited_user": "VOIRIE",
  "nom_de_la_commune": "Marseille VIII"
}

Record 3nom: JARDIN DES FABRIQUES · code: BF-15003

{
  "nom": "JARDIN DES FABRIQUES",
  "code": "BF-15003",
  "nb_pj": 1,
  "photo": "BF-15003.jpg",
  "ville": "Marseille",
  "modele": "ATLAS",
  "source": "DGEP",
  "adresse": "6 rue Pascal Posado 13015 Marseille 15e Arrondissement",
  "datemaj": "2025-04-01T11:29:54+00:00",
  "codecomm": "131215",
  "latitude": 6250228.56012034,
  "objectid": 2495,
  "codeinsee": "13215",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.3639039109928435,
        43.32536812500335
      ]
    },
    "properties": {}
  },
  "longitude": 891815.63935555,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-15003.jpg",
  "en_service": "EN SERVICE",
  "nom_donnee": "Fontaines à boire voirie",
  "commentaires": "au bout de la rue entre une résidence",
  "created_date": "2025-04-01T11:24:43+00:00",
  "created_user": "junior_macair.tchiegang_ngongang@ampmetropole.fr",
  "geo_point_2d": {
    "lat": 43.32536812500335,
    "lon": 5.3639039109928435
  },
  "last_edited_date": null,
  "last_edited_user": "junior_macair.tchiegang_ngongang@ampmetropole.fr",
  "nom_de_la_commune": "Marseille 15e Arrondissement"
}

Record 4nom: VIEILLE CHARITE · code: BF-02009

{
  "nom": "VIEILLE CHARITE",
  "code": "BF-02009",
  "nb_pj": 1,
  "photo": "BF-02009.jpg",
  "ville": "Marseille",
  "modele": "ATLAS",
  "source": "DGEP",
  "adresse": "4 Place Père Pierre Saisse",
  "datemaj": "2024-12-20T16:37:50+00:00",
  "codecomm": "131201",
  "latitude": 43.300079,
  "objectid": 2046,
  "codeinsee": "13201",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.367858711500115,
        43.30005884556523
      ]
    },
    "properties": {}
  },
  "longitude": 5.367857,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-02009.jpg",
  "en_service": "EN SERVICE",
  "nom_donnee": "Fontaines à boire voirie",
  "commentaires": null,
  "created_date": "2024-12-20T16:37:50+00:00",
  "created_user": "VOIRIE",
  "geo_point_2d": {
    "lat": 43.30005884556523,
    "lon": 5.367858711500115
  },
  "last_edited_date": null,
  "last_edited_user": "VOIRIE",
  "nom_de_la_commune": "Marseille II"
}

Record 5nom: LES PROPHÈTES · code: BF-07005

{
  "nom": "LES PROPHÈTES",
  "code": "BF-07005",
  "nb_pj": 1,
  "photo": "BF-07005.jpg",
  "ville": "Marseille",
  "modele": "INOX",
  "source": "DGEP",
  "adresse": "323 Promenade du Président  JF Kennedy",
  "datemaj": "2024-12-20T16:37:50+00:00",
  "codecomm": "131207",
  "latitude": 43.27411253,
  "objectid": 2087,
  "codeinsee": "13207",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.361983845365475,
        43.274112532610054
      ]
    },
    "properties": {}
  },
  "longitude": 5.36198385,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-07005.jpg",
  "en_service": "EN SERVICE",
  "nom_donnee": "Fontaines à boire voirie",
  "commentaires": null,
  "created_date": "2024-12-20T16:37:50+00:00",
  "created_user": "VOIRIE",
  "geo_point_2d": {
    "lat": 43.274112532610054,
    "lon": 5.361983845365475
  },
  "last_edited_date": null,
  "last_edited_user": "VOIRIE",
  "nom_de_la_commune": "Marseille VII"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fontaines-a-boire-voirie-ct1

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fontaines-a-boire-voirie-ct1/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

5 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

142

Last upstream update

7 days ago

2026-10-16

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.