{"id":"b4f89d90-14cc-4443-8b11-99d607052bdd","type":"API","name":"Fontaines d'eau potable de la ville de Bordeaux","slug":"fontaines-deau-potable-de-la-ville-de-bordeaux","description":"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).","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_fontaines_eau_potable/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_fontaines_eau_potable/","repo_url":null,"status":"ACTIVE","verification_state":"UNVERIFIED","tags":[],"logo_url":"https://opendata.bordeaux-metropole.fr/assets/favicon?tstamp=174885191012131","primary_source_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_fontaines_eau_potable/","extraction_confidence":"0.00","created_at":"2026-07-28T16:29:37.471Z","updated_at":"2026-07-28T16:32:38.355Z","last_verified_at":null,"deprecated_at":null,"ranking_score":0,"last_ranked_at":null,"last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'a':62B 'affichett':26B 'affichettes':75B 'avec':20B,69B 'boir':14B 'boire':63B 'bordeaux':9A,19B,58A,68B 'certain':38B 'certaines':87B 'cimetieres':85B 'cimetièr':36B 'comprend':31B,80B 'd':2A,51A 'dan':44B 'dans':93B 'de':5A,8A,15B,18B,23B,47B,54A,57A,64B,67B,72B,96B 'des':11B,35B,60B,84B 'dont':37B,86B 'eau':3A,52A 'egalement':81B 'emplac':10B 'emplacement':59B 'et':25B,74B 'etat':71B 'fonctionn':24B 'fonctionnement':73B 'fontain':1A,12B,30B,34B,49B 'fontaine':98B 'fontaines':50A,61B,79B,83B 'la':6A,16B,48B,55A,65B,97B 'le':45B,94B 'les':29B,33B,78B,82B 'modele':70B,95B 'modèl':21B,46B 'non':41B,90B 'non-pot':40B 'non-potables':89B 'potabl':4A,42B 'potable':53A 'potables':91B 'precise':92B 'presentes':76B 'précisé':43B 'présent':27B 'sont':39B,88B 'sur':28B,77B 'vill':7A,17B 'ville':56A,66B 'à':13B 'également':32B 'état':22B","popularity_score":"0.0000","maintenance_score":"0.0000","institution_id":null,"institution_type":null,"country_code":"FR","official_confidence":0,"proof_summary":"Confidence: 0%","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-30T09:57:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":0,"access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/records?limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Select & filter","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/records?select=id%2Cnom_fontaine%2Cnombre_robinets&where=nom_fontaine+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"API base URL","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable","source":"base_url","runnable":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_fontaines_eau_potable/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"b4f89d90-14cc-4443-8b11-99d607052bdd","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"discovered","level_index":1,"level_label":"Discovered","meaning":"Source and metadata recorded","counts_as_coverage":false,"blocked_by":"verified","rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":false,"reached":false,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":true,"reached":false,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":true,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":0,"proven_threshold":80,"institution_id":null,"definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"opendata.bordeaux-metropole.fr","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-07-28T19:05:52.240Z"},"api_details":{"id":"1ec211d2-1e81-49ca-ad69-ad6483cf148e","entry_id":"b4f89d90-14cc-4443-8b11-99d607052bdd","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":null,"endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable","created_at":"2026-07-28T16:29:37.628Z","updated_at":"2026-07-28T16:29:37.628Z"},"dataset_details":{"id":"df9264ef-1e88-4fbd-86a0-92bd6e082172","entry_id":"b4f89d90-14cc-4443-8b11-99d607052bdd","upstream_issued":null,"upstream_modified":"2026-03-26T11:00:48.000Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"opendatasoft","source_portal_url":"https://opendata.bordeaux-metropole.fr","created_at":"2026-07-28T16:32:37.845Z","updated_at":"2026-07-28T16:32:37.845Z","publisher":null,"publisher_url":null,"distributions":[],"license":null},"license":{"id":"lo-2.0","spdx_id":"etalab-2.0","name":"Licence Ouverte 2.0 (France / Etalab)","url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z","commercial_use":true,"redistribution":true,"attribution_required":true,"share_alike":false,"personal_data_warning":true,"cache_and_mirror":true,"reuse_basis":"licence_text","reuse_source_text":"Texte de la licence - le reutilisateur est libre \"de la communiquer, la reproduire, la copier ; de l'adapter, la modifier, l'extraire et la transformer, notamment pour creer des Informations derivees ; de la diffuser, la redistribuer, la publier et la transmettre, de l'exploiter a titre commercial\". Seule obligation : \"mentionner la paternite de l'Information : sa source (a minima le nom du Concedant) et la date de la derniere mise a jour\". Le texte rappelle que le reutilisateur doit respecter \"le cadre legal relatif a la protection des donnees a caractere personnel\". Aucune clause de partage a l'identique n'est imposee.","reuse_source_url":"https://github.com/etalab/licence-ouverte/blob/master/LO.md","reuse_reviewed_at":null,"reuse_confidence":"0.95"},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","latest_check":null,"data_profile":{"id":"fcc104ea-221d-46ca-82ea-eb12ecc5d884","entry_id":"b4f89d90-14cc-4443-8b11-99d607052bdd","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"bor_fontaines_eau_potable","fields":[{"name":"id","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"identifiant fontaine"},{"name":"nom_fontaine","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Nom de la fontaine"},{"name":"nombre_robinets","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"nombre de robinets de la fontaine"},{"name":"modele_fontaine","type":"text","label":"Modèle_fontaine","fill_pct":100,"filterable":true,"description":"modèle de fontaine"},{"name":"x","type":"double","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"y","type":"double","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"adresse","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"adresse et précisions sur la localisation de la fontaine"},{"name":"date_dernier_controle","type":"date","label":"date_dernier_contrôle","fill_pct":100,"filterable":true,"description":"date du dernier contrôle technique"},{"name":"etat","type":"text","label":"état","fill_pct":100,"filterable":true,"description":"état de fonctionnement de la fontaine :\nFonctionnelle : en fonctionnement\nCondamnée : fermée, non alimentée \nHors service : problème technique empêchant son bon fonctionnement\nInaccessible : des travaux sur l’espace public en empêche l’accès"},{"name":"hivernage","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"mise en hivernage de la fontaine"},{"name":"complement_information","type":"text","label":"complément_information","filterable":true,"description":"contenu de l'affichette en place sur la fontaine"},{"name":"geom","type":"geo_point_2d","label":null,"filterable":false,"description":null},{"name":"code_insee","type":"text","label":null,"filterable":true,"description":null}],"field_count":13,"sample_records":[{"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},{"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},{"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},{"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},{"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}],"record_count":"279","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/records?limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/records?select=id%2Cnom_fontaine%2Cnombre_robinets&where=nom_fontaine+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/records?select=id%2Cnom_fontaine%2Cnombre_robinets&where=nom_fontaine+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (id, nom_fontaine, nombre_robinets) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_fontaines_eau_potable/exports/csv' -o dataset.csv","label":"Export CSV","method":"GET","description":"Full dataset export as CSV (also available: json, parquet, xlsx)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-28T16:32:37.339Z","run_id":"460c44c2-82f8-4c34-9929-b80edf6c65eb","created_at":"2026-07-28T16:32:37.339Z","updated_at":"2026-07-28T16:32:37.339Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","license_id":"lo-2.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[{"id":"7e83da01-71d8-4c8c-bb0b-8c4793291531","entry_id":"b4f89d90-14cc-4443-8b11-99d607052bdd","limit_type":"requests_per_day","value":"50000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-07-28T16:32:38.003Z"}]}