Drinking Water Fountains Across the Metropolitan Area from OpenStreetMapFontaines à boire sur l'ensemble de la métropole issues d'OpenStreetMap

Fontaines à boire sur l'ensemble de la métropole issues d'OpenStreetMapDrinking Water Fountains Across the Metropolitan Area from OpenStreetMap

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This API lists drinking water points located within the Aix-Marseille-Provence metropolitan area, sourced from OpenStreetMap. It is based on a detailed OSM query covering tags such as amenity=drinking_water, amenity=water_point, drinking_water=treated or yes, and waterway=water_point, while excluding natural springs and fee-based points. The dataset is published and maintained by Métropole Aix-Marseille-Provence and provides geolocated information on public drinking water fountains across the local territory.Liste des points d'eau potable sur le territoire de la métropole Aix-Marseille-Provence présents dans OpenStreetMap. Requête détaillée OSM : (amenity=drinking_water OR amenity=water_point OR drinking_water=treated OR drinking_water=yes OR waterway=water_point) and natural!=spring and fee!=yes in...

environment

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

Filterable via the API (9)

typeidlatlontagscommunecodetags_operatortags_source

Click a field to see example values.

Field	Type	Description
type	text	OpenStreetMap element type, e.g. node.OpenStreetMap element type, e.g. node.
id	int	OpenStreetMap identifier for the feature.OpenStreetMap identifier for the feature.
lat	double	Latitude coordinate of the drinking water point.Latitude coordinate of the drinking water point.
lon	double	Longitude coordinate of the drinking water point.Longitude coordinate of the drinking water point.
tags	text	Raw OpenStreetMap tags associated with the point, as key-value data.Raw OpenStreetMap tags associated with the point, as key-value data.
point_geoPoint geo	geo_point_2d	Geographic point location of the drinking water fountain.Geographic point location of the drinking water fountain.
communeCommune	text	Name of the municipality where the point is located.Name of the municipality where the point is located.
code	text	INSEE or postal code of the municipality.INSEE or postal code of the municipality.
tags_operatorTags operator	text	Operator of the drinking water point, from OSM tags.Operator of the drinking water point, from OSM tags.
tags_sourceTags source	text	Data source referenced in the OpenStreetMap tags.Data source referenced in the OpenStreetMap tags.

Schema captured from opendatasoft 3 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 1id: 10126554562 · lat: 43.447118

{
  "id": 10126554562,
  "lat": 43.447118,
  "lon": 5.6391133,
  "code": "13072",
  "tags": "{\"access\": \"yes\", \"amenity\": \"drinking_water\", \"bottle\": \"yes\", \"fee\": \"no\", \"fountain\": \"drinking\"}",
  "type": "node",
  "commune": "Peynier",
  "point_geo": {
    "lat": 43.447118,
    "lon": 5.6391133
  },
  "tags_source": null,
  "tags_operator": null
}

Record 2id: 4260461390 · lat: 43.4008927

{
  "id": 4260461390,
  "lat": 43.4008927,
  "lon": 4.9768401,
  "code": "13077",
  "tags": "{\"amenity\": \"drinking_water\"}",
  "type": "node",
  "commune": "Port-de-Bouc",
  "point_geo": {
    "lat": 43.4008927,
    "lon": 4.9768401
  },
  "tags_source": null,
  "tags_operator": null
}

Record 3id: 11663281513 · lat: 43.2789485

{
  "id": 11663281513,
  "lat": 43.2789485,
  "lon": 5.354219,
  "code": "13207",
  "tags": "{\"amenity\": \"drinking_water\"}",
  "type": "node",
  "commune": "Marseille 7e Arrondissement",
  "point_geo": {
    "lat": 43.2789485,
    "lon": 5.354219
  },
  "tags_source": null,
  "tags_operator": null
}

Record 4id: 4289366866 · lat: 43.2301758

{
  "id": 4289366866,
  "lat": 43.2301758,
  "lon": 5.4370615,
  "code": "13209",
  "tags": "{\"amenity\": \"drinking_water\", \"bottle\": \"yes\", \"description\": \"2019-12 : Robinet d'eau potable et abondante tout au long de l'année. Il peut y avoir une petite file d'attente le WE.\", \"ele\": \"140\", \"man_made\": \"water_tap\", \"name\": \"Borne fontaine de Luminy\", \"ref:refuges.info\": \"3718\"}",
  "type": "node",
  "commune": "Marseille 9e Arrondissement",
  "point_geo": {
    "lat": 43.2301758,
    "lon": 5.4370615
  },
  "tags_source": null,
  "tags_operator": null
}

Record 5id: 5747865622 · lat: 43.2951479

{
  "id": 5747865622,
  "lat": 43.2951479,
  "lon": 5.3624843,
  "code": "13202",
  "tags": "{\"amenity\": \"drinking_water\"}",
  "type": "node",
  "commune": "Marseille 2e Arrondissement",
  "point_geo": {
    "lat": 43.2951479,
    "lon": 5.3624843
  },
  "tags_source": null,
  "tags_operator": null
}

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/fr-fontaines_a_boire-osm

License

Terms stated by the source (not a recognized license):

Licence ODBL

Query examples

curl -s 'https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fr-fontaines_a_boire-osm/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 3 days ago

Dataset

Volume & freshness

Records

515

Last upstream update

23 days ago

2026-09-30

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.