Fontaines à boire (Marseille et Allauch) - Gestion métropolitaine

Name: Fontaines à boire (Marseille et Allauch) - Gestion métropolitaine
Creator: opendatasoft

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

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 6 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: J4 (2) · code: BF-02006

{
  "nom": "J4 (2)",
  "code": "BF-02006",
  "nb_pj": 1,
  "photo": "BF-02006.jpg",
  "ville": "Marseille",
  "modele": "BF RBT. DELABIE",
  "source": "DGEP",
  "adresse": "999 Quai de la Tourette",
  "datemaj": "2024-12-20T16:37:50+00:00",
  "codecomm": "131202",
  "latitude": 43.297681,
  "objectid": 1971,
  "codeinsee": "13202",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.361184000500959,
        43.29768099976396
      ]
    },
    "properties": {}
  },
  "longitude": 5.361184,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-02006.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.29768099976396,
    "lon": 5.361184000500959
  },
  "last_edited_date": null,
  "last_edited_user": "VOIRIE",
  "nom_de_la_commune": "Marseille II"
}

Record 2nom: J4 (3) · code: BF-02007

{
  "nom": "J4 (3)",
  "code": "BF-02007",
  "nb_pj": 1,
  "photo": "BF-02007.jpg",
  "ville": "Marseille",
  "modele": "BF RBT. DELABIE",
  "source": "DGEP",
  "adresse": "999 Quai de la Tourette",
  "datemaj": "2024-12-20T16:37:50+00:00",
  "codecomm": "131202",
  "latitude": 43.297788,
  "objectid": 1972,
  "codeinsee": "13202",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.361498000599725,
        43.29778800041767
      ]
    },
    "properties": {}
  },
  "longitude": 5.361498,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-02007.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.29778800041767,
    "lon": 5.361498000599725
  },
  "last_edited_date": null,
  "last_edited_user": "VOIRIE",
  "nom_de_la_commune": "Marseille II"
}

Record 3nom: PALAIS DE LA BOURSE · code: BF-01009

{
  "nom": "PALAIS DE LA BOURSE",
  "code": "BF-01009",
  "nb_pj": 1,
  "photo": "BF-01009.jpg",
  "ville": "Marseille",
  "modele": "ATLANTIDA",
  "source": "DGEP",
  "adresse": "Place Général de Gaule",
  "datemaj": "2026-05-18T12:16:16+00:00",
  "codecomm": "131201",
  "latitude": 43.29540686,
  "objectid": 1965,
  "codeinsee": "13201",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.3755221009718035,
        43.29540686186751
      ]
    },
    "properties": {}
  },
  "longitude": 5.3755221,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-01009.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.29540686186751,
    "lon": 5.3755221009718035
  },
  "last_edited_date": null,
  "last_edited_user": "dona_habib.djimenou_bossou@ampmetropole.fr",
  "nom_de_la_commune": "Marseille I"
}

Record 4nom: ST VICTOR · code: BF-07001

{
  "nom": "ST VICTOR",
  "code": "BF-07001",
  "nb_pj": 1,
  "photo": "BF-07001.jpg",
  "ville": "Marseille",
  "modele": "BAYARD",
  "source": "DGEP",
  "adresse": "163 rue Sainte",
  "datemaj": "2024-12-20T16:37:50+00:00",
  "codecomm": "131207",
  "latitude": 43.29049388,
  "objectid": 1988,
  "codeinsee": "13207",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.365841781715219,
        43.29049387572325
      ]
    },
    "properties": {}
  },
  "longitude": 5.36584178,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-07001.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.29049387572325,
    "lon": 5.365841781715219
  },
  "last_edited_date": null,
  "last_edited_user": "VOIRIE",
  "nom_de_la_commune": "Marseille VII"
}

Record 5nom: POINTE ROUGE · code: BF-08003

{
  "nom": "POINTE ROUGE",
  "code": "BF-08003",
  "nb_pj": 1,
  "photo": "BF-08003.jpg",
  "ville": "Marseille",
  "modele": "ATLAS",
  "source": "DGEP",
  "adresse": "41 Avenue de Montredon",
  "datemaj": "2024-12-20T16:37:50+00:00",
  "codecomm": "131208",
  "latitude": 43.24401094,
  "objectid": 1991,
  "codeinsee": "13208",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        5.3709405949402305,
        43.24401093932248
      ]
    },
    "properties": {}
  },
  "longitude": 5.3709406,
  "reception": "OUI",
  "url_photo": "https://datamedia.ampmetropole.fr/media/mdata/fontaines/BF-08003.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.24401093932248,
    "lon": 5.3709405949402305
  },
  "last_edited_date": null,
  "last_edited_user": "VOIRIE",
  "nom_de_la_commune": "Marseille VIII"
}

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 6 days ago

Dataset

Volume & freshness

Records

142

Last upstream update

10 days ago

2026-08-28

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.