{"id":"4f9524be-8a7e-4d0b-8990-a122d2a111a8","type":"API","name":"Patrimoine arboré de Bordeaux Métropole","slug":"patrimoine-arbore-de-bordeaux-metropole","description":"Dictionnaire Public Ensemble du patrimoine arboré sur le territoire de Bordeaux Métropole. Ce jeu de données est disponible dans un format additionnel : Téléchargement au format AutoCAD DWG","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/ec_arbre_p/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/ec_arbre_p/","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://opendata.bordeaux-metropole.fr/assets/favicon?tstamp=174885191012131","primary_source_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/ec_arbre_p/","extraction_confidence":"0.00","created_at":"2026-07-25T17:57:25.141Z","updated_at":"2026-09-09T04:35:59.395Z","last_verified_at":"2026-09-06T10:02:29.499Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-09-03T06:33:45.334Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-09-08T01:28:19.029Z","search_vector":"'a':147B 'access':41B,145B 'across':52B,156B 'addit':70B 'addition':174B 'additionnel':32B,136B 'also':75B,179B 'and':172B,198B 'api':39B,143B 'arbore':106A,120B 'arboré':2A,16B 'area':101B,205B 'as':166B 'au':34B,138B 'autocad':36B,80B,140B,184B 'avail':76B 'available':180B 'be':190B 'bordeaux':4A,9A,21B,56B,66B,108A,113A,125B,160B,170B 'by':169B 'can':189B 'ce':23B,127B 'cover':45B 'covering':149B 'dan':29B 'dans':133B 'data':64B,168B 'dataset':44B,84B,148B,188B 'de':3A,20B,25B,107A,124B,129B 'dictionnair':11B 'dictionnaire':115B 'dispon':28B 'disponible':132B 'donnees':130B 'donné':26B 'download':78B,182B 'du':14B,118B 'dwg':37B,81B,141B,185B 'ensembl':13B 'ensemble':117B 'environment':95B 'environmental':199B 'est':27B,131B 'for':181B,192B 'format':31B,35B,73B,82B,135B,139B,186B 'formats':177B 'franc':58B 'france':162B 'full':47B,151B 'green':91B,195B 'heritag':7A,49B 'heritage':111A,153B 'in':173B,183B 'is':164B,178B 'it':163B 'jeu':24B,128B 'le':18B,122B 'manag':93B 'management':197B 'metropole':109A,114A,126B,161B,171B 'metropolitan':100B,204B 'métropol':5A,10A,22B,57B,67B 'of':112A,159B 'open':63B,167B 'patrimoin':1A,15B 'patrimoine':105A,119B 'plan':90B 'planning':194B 'provid':40B 'provides':144B 'public':12B,50B,116B,154B 'publish':61B 'published':165B 'relat':97B 'related':201B 's':206B 'space':92B,196B 'standard':72B,176B 'stock':104B,208B 'studi':96B 'studies':200B 'sur':17B,121B 'telechargement':137B 'territoir':19B 'territoire':123B 'territori':54B 'territory':158B 'the':150B,157B,187B,203B 'this':142B 'to':146B,175B,202B 'tree':6A,48B,51B,103B,110A,152B,207B 'trees':155B 'téléchargement':33B 'un':30B,134B 'urban':89B,193B 'use':87B 'used':191B","popularity_score":"0.0000","maintenance_score":"0.7000","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-26T18:53:34.017Z","geographic_scope":"NATIONAL","name_en":"Tree Heritage of Bordeaux Métropole","description_en":"This API provides access to a dataset covering the full tree heritage (public trees) across the territory of Bordeaux Métropole, France. It is published as open data by Bordeaux Métropole and, in addition to standard formats, is also available for download in AutoCAD DWG format. The dataset can be used for urban planning, green space management, and environmental studies related to the metropolitan area's tree stock.","native_lang":"fr","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":38.75,"merged_into_entry_id":null,"identity_key":"API|https://opendata.bordeaux-metropole.fr/explore/dataset/ec_arbre_p|patrimoine arboré de bordeaux métropole","upstream_ref":"opendata.bordeaux-metropole.fr:dataset:ec_arbre_p","access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p/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/ec_arbre_p/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/ec_arbre_p/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/ec_arbre_p/records?select=geo_point_2d%2Cgeo_shape%2Cgid&where=geom_o+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/ec_arbre_p/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"4f9524be-8a7e-4d0b-8990-a122d2a111a8","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":"executable","level_index":4,"level_label":"Executable","meaning":"Queries run through Commodity","counts_as_coverage":true,"blocked_by":null,"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":true,"reached":true,"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":true,"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":true,"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":false,"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-09-09T09:06:41.550Z"},"api_details":{"id":"58c9dc5d-0811-427f-833b-7ac8d9ad7455","entry_id":"4f9524be-8a7e-4d0b-8990-a122d2a111a8","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p","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/ec_arbre_p","created_at":"2026-07-25T17:57:25.312Z","updated_at":"2026-07-25T17:57:25.312Z"},"dataset_details":{"id":"64715799-6e4b-418b-9345-441cec267a60","entry_id":"4f9524be-8a7e-4d0b-8990-a122d2a111a8","upstream_issued":null,"upstream_modified":"2026-09-02T03:14:34.000Z","themes":[],"update_frequency":"daily","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-25T23:53:56.802Z","updated_at":"2026-09-02T20:22:45.585Z","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"},"reuse":{"license_id":"lo-2.0","license_name":"Licence Ouverte 2.0 (France / Etalab)","license_url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","commercial_use":{"status":"yes","value":true},"redistribution":{"status":"yes","value":true},"attribution_required":{"status":"yes","value":true},"share_alike":{"status":"no","value":false},"personal_data_warning":{"status":"yes","value":true},"cache_and_mirror":{"status":"yes","value":true},"undetermined":[],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","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.","source_url":"https://github.com/etalab/licence-ouverte/blob/master/LO.md","reviewed_at":null},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","latest_check":{"id":"0f62f6bd-69a4-4f8b-92a4-39dcffcaba1b","entry_id":"4f9524be-8a7e-4d0b-8990-a122d2a111a8","status":"VERIFIED","last_checked_at":"2026-09-06T10:02:29.181Z","p50_latency_ms":856,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-28T12:58:53.720Z","updated_at":"2026-09-06T10:02:29.181Z","consecutive_successes":8,"probe_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-09-06T10:02:29.181Z"},"data_profile":{"id":"0056b1a6-ea95-4346-b222-c61d58ed6be1","entry_id":"4f9524be-8a7e-4d0b-8990-a122d2a111a8","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"ec_arbre_p","fields":[{"name":"geo_point_2d","type":"geo_point_2d","label":"Geo Point","filterable":false,"description":null},{"name":"geo_shape","type":"geo_shape","label":null,"filterable":false,"description":null},{"name":"gid","type":"int","label":null,"filterable":true,"description":"Clé primaire"},{"name":"geom_o","type":"text","label":null,"filterable":true,"description":"Orientation du point"},{"name":"geom_err","type":"text","label":null,"filterable":true,"description":"Code d'erreur géométrique : \nListe des valeurs possibles : \n9999 : Polygone compose et / ou à sections multiples\n9998 : Linéaire compose et / ou à sections multiples\n9996 : La géométrie contient des informations LRS\n9995 : Nombre de dimensions différent de 2 ou 3\n9994 : Présence d'un arc de cercle\n9000 : Erreur autre\n13343 : Polygone de moins de 4 points\n13349 : Polygone papillon\n13350 : Deux éléments d'un polygone archipel se touchent\n13351 : Deux éléments d'un polygone archipel  se touchent\n13356 : Point double\n13366 : Combinaison invalide d'intérieur / extérieur d'un polygone\n13367 : Orientation invalide d'intérieur / extérieur d'un polygone"},{"name":"insee","type":"text","label":null,"filterable":true,"description":"Code INSEE de la commune : \nListe des valeurs possibles : \n33009 : Arcachon\n33003 : Ambarès-et-Lagrave\n33004 : Ambès\n33013 : Artigues-Près-Bordeaux\n33032 : Bassens\n33039 : Bègles\n33056 : Blanquefort\n33063 : Bordeaux\n33065 : Bouliac\n33069 : Le Bouscat\n33075 : Bruges\n33096 : Carbon-Blanc\n33119 : Cenon\n33162 : Eysines\n33167 : Floirac\n33192 : Gradignan\n33200 : Le Haillan\n33249 : Lormont\n33273 : Martignas-sur-Jalle\n33281 : Mérignac\n33312 : Parempuyre\n33318 : Pessac\n33376 : Saint-Aubin-de-Médoc\n33434 : Saint-Louis-de-Montferrand\n33449 : Saint-Médard-en-Jalles\n33487 : Saint-Vincent-de-Paul\n33519 : Le Taillan-Médoc\n33522 : Talence\n33550 : Villenave-d'Ornon"},{"name":"nom","type":"text","label":null,"filterable":true,"description":"Nom de la commune"},{"name":"nom_francais","type":"text","label":null,"filterable":true,"description":"Nom Français"},{"name":"hauteur","type":"int","label":null,"filterable":true,"description":"Hauteur totale (en m)"},{"name":"statut","type":"text","label":null,"filterable":true,"description":"Statut : \nListe des valeurs possibles : \nMORT : Mort\nSOUCHE : Souche\nVIVANT : Vivant\nPROJET : Projet"},{"name":"date_plantation","type":"date","label":null,"fill_pct":22.9,"filterable":true,"description":"Date de plantation"},{"name":"cdate","type":"datetime","label":null,"fill_pct":100,"filterable":true,"description":"Date de création"},{"name":"mdate","type":"datetime","label":null,"fill_pct":96.2,"filterable":true,"description":"Date de modification"},{"name":"station","type":"text","label":null,"fill_pct":89.6,"filterable":true,"description":"Station de gestion ou regroupement d'arbres au sein d'un site  (niv. hiérarchique 3)"},{"name":"carre","type":"text","label":null,"fill_pct":18.7,"filterable":true,"description":"Carré ou regroupement d'arbres au sein d'une station (niv. hiérarchique 4)"},{"name":"fruitier","type":"boolean","label":null,"fill_pct":100,"filterable":true,"description":"Fruitier"},{"name":"cepee","type":"boolean","label":null,"fill_pct":100,"filterable":true,"description":"Taille en Cépée"},{"name":"diametre_couronne","type":"int","label":null,"fill_pct":26.8,"filterable":true,"description":"Diamètre de la couronne (en m)"},{"name":"diametre_souche","type":"int","label":null,"fill_pct":16.8,"filterable":true,"description":"Diamètre de la souche (en cm)"},{"name":"vigueur","type":"text","label":null,"fill_pct":60.9,"filterable":true,"description":"Vigueur : \nListe des valeurs possibles : \nFAIBLE : Faible\nMOYENNE : Moyenne\nELEVEE : Elevée"},{"name":"numero","type":"text","label":null,"fill_pct":82.8,"filterable":true,"description":"Numéro d'emplacement de l'arbres (niv. hiérarchique 5)"},{"name":"site","type":"text","label":null,"fill_pct":16.2,"filterable":true,"description":"Site de gestion ou regroupement d'arbres au sein d'une unité (niv. hiérarchique 2 optionnel)"},{"name":"unite","type":"text","label":null,"fill_pct":98.6,"filterable":true,"description":"Unité de gestion ou premier regroupement d'arbres fonctionnel  (niv. hiérarchique 1)"},{"name":"espece","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Espèce"},{"name":"famille","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Famille"},{"name":"classe","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Classe"},{"name":"stock_carbone","type":"double","label":null,"fill_pct":76.2,"filterable":true,"description":"Stock carbone (Estimation du carbone stocké/séquestré par l'arbre en kg)"},{"name":"date_disparition","type":"date","label":null,"fill_pct":4.8,"filterable":true,"description":"Date de la disparition (arbre au statut mort ou souche)"},{"name":"cause_disparition","type":"text","label":null,"fill_pct":4.5,"filterable":true,"description":"Qualification de la disparition (arbre au statut mort ou souche) : \nListe des valeurs possibles : \nACCIDENT : Accident (véhicule, chantier...)\nACCIDENT_CLIMATIQUE_VENTS : Accident climatique dû aux vents: Chablis, volis...\nACCIDENT_CLIMATIQUE_AUTRE : Autre accident climatique (gel, secheresse...)\nCHANGEMENT_DE_DOMANIALITE : Changement de domanialité\nCHANGEMENT_DE_GESTION : Changement de gestion\nETAT_MECANIQUE : Etat mécanique\nETAT_PHYTOSANITAIRE : Etat phytosanitaire (maladie, pb physiologiques...)\nGESTION_DEDENSIFICATION : Gestion_dédensification\nPROJET : Projet\nVANDALISME : Vandalisme\nPOLLUTION : Pollution\nINCONNUE : Inconnue"},{"name":"age_approximatif","type":"int","label":null,"fill_pct":22.9,"filterable":true,"description":"Âge approximatif (ans)"},{"name":"statut_patrimonial","type":"text","label":null,"fill_pct":1.8,"filterable":true,"description":"Statut patrimonial : \nListe des valeurs possibles : \nAYANT_UNE_VALEUR_DACCOMPAGNEMENT : Ayant une valeur d'accompagnement\nCLASSE_COMME_MONUMENT_OU_SITE_PLU : Classé comme monument ou site (au PLU)\nDANS_UN_AMENAGEMENT_PAYSAGER : Dans un aménagement paysager (voirie, espace vert)\nREMARQUABLE_SYMBOLIQUE : Remarquable / symbolique\nSITUE_DANS_UN_JARDIN_OU_SITE_HISTORIQUE : Situé dans un jardin ou site historique\nENJEUX_ET_ESPECES_PROTEGEES : Enjeux et espèces protégées"},{"name":"typologie_espace","type":"text","label":null,"fill_pct":88.9,"filterable":true,"description":"Typologie d'espace : \nListe des valeurs possibles : \nAUCUNE : Aucune\nCIMETIERE : Cimetière\nESPACE_DACCOMPAGNEMENT_DE_VOIRIE : Espace d'accompagnement de voirie\nESPACE_DACCOMPAGNEMENT_RESIDENTIEL : Espace d'accompagnement résidentiel\nESPACE_PUBLIC_NON_AMENAGE : Espace public non aménagé\nESPACE_PUBLIC_VEGETALISE : Espace public végétalisé\nETABLISSEMENT_ADMINISTRATIF_ET_TECHNIQUE : Etablissement administratif et technique\nETABLISSEMENT_CULTUREL : Etablissement culturel\nETABLISSEMENT_SCOLAIRE_ET_PETITE_ENFANCE : Etablissement scolaire et petite enfance\nETABLISSEMENT_SOCIAL : Etablissement social\nETABLISSEMENT_SPORTIF : Etablissement sportif\nPARC_JARDIN_ET_SQUARE : Parc Jardin et Square\nAUTRE_DONT_PROPRIETE_PRIVEE_DE_LA_VILLE : Autre dont propriété privée de la Ville\nESPACE_BOISE : Espace boisé\nESPACE_NATUREL : Espace naturel\nESPACE_NATUREL_PROTEGE : Espace naturel protégé\nRIPISYLVE : Ripisylve\nZONE_HUMIDE : Zone humide"},{"name":"typologie_environ","type":"text","label":null,"fill_pct":65.8,"filterable":true,"description":"Typologie d'environnement : \nListe des valeurs possibles : \nBAC_BANQUETTE : Bac / Banquette\nCOURS_DECOLE : Cours d'école\nFOSSES_NOUES : Fosses / Noues\nJEUX_DENFANTS : Jeux d'enfants\nLIEU_DE_STATIONNEMENT : Lieu de stationnement\nPARKING : Parking"},{"name":"duree_de_maintien","type":"text","label":null,"fill_pct":52.4,"filterable":true,"description":"Durée de maintien : \nListe des valeurs possibles : \nA_REMPLACER : A remplacer\n1_5_ANS : 1-5 ans\n6_10_ANS : 6-10 ans\n11_15_ANS : 11-15 ans\n16_20_ANS : 16-20 ans\nSUP_20_ANS : &gt; à 20 ans"},{"name":"circonference_tronc","type":"double","label":null,"fill_pct":78.1,"filterable":true,"description":"Circonférence à 1m30 (en cm)"},{"name":"diametre_tronc","type":"double","label":null,"fill_pct":78.2,"filterable":true,"description":"Diamètre à 1m30 (en cm)"},{"name":"stade_developpement","type":"text","label":null,"fill_pct":68.6,"filterable":true,"description":"Stade de développement : \nListe des valeurs possibles : \nADULTE : Adulte\nSENESCENT : Sénescent\nMATURE : Mature\nJEUNE : Jeune"},{"name":"couverture_sol","type":"text","label":null,"fill_pct":65.9,"filterable":true,"description":"Couverture du sol : \nListe des valeurs possibles : \nAUTRE_REVETEMENT_DRAINANT : Autre revêtement drainant\nAUTRE_REVETEMENT_NON_DRAINANT : Autre revêtement non drainant\nGRAVE : Grave\nLITIERE_NATURELLE : Litière naturelle\nMASSIF_DARBUSTES : Massif d'arbustes\nPAILLAGE : Paillage\nPAVES_DALLES : Pavés / dalles\nPELOUSE : Pelouse\nREVETEMENT_TYPE_RESINE : Revêtement type résine\nTERRE_NUE : Terre nue\nVEGETALISE : Végétalisé"},{"name":"distribut_spatiale","type":"text","label":null,"fill_pct":60.2,"filterable":true,"description":"Distribution spatiale : \nListe des valeurs possibles : \nALIGNEMENT_MULTIPLE : Alignement multiple\nALIGNEMENT_SIMPLE : Alignement simple\nARBRE_ISOLE : Arbre isolé\nBOISE_FERME : Boisé fermé\nBOISE_OUVERT : Boisé ouvert\nSUP_5_ARBRES : Groupe d'arbres (&gt; 5)\n2_5_ARBRES : Groupe d'arbres (2 à 5)"},{"name":"nature_sol","type":"text","label":null,"fill_pct":7.2,"filterable":true,"description":"Nature du sol : \nListe des valeurs possibles : \nTERRE_VEGETALE : Terre végétale\nMELANGE_TERRE_PIERRE : Mélange terre-pierre\nTERRE_VEGETALE_AMENDEMENT : Terre végétale + amendement\nMELANGE_DRAINANT_GRANIT : Mélange drainant granit\nMELANGE_DRAINANT_POUZZOLANE : Mélange drainant pouzzolane\nTERRE_DU_SITE_AMENDEE : Terre du site amendée"},{"name":"forme","type":"text","label":null,"fill_pct":67.9,"filterable":true,"description":"Forme : \nListe des valeurs possibles : \nARCHITECTURE_EN_RIDEAU : Architecturé en rideau\nARCHITECTURE_ISSU_D_UNE_CONVERSION : Architecturé issu d'une conversion\nARCHITECTURE_SUR_MICRO_TETE_DE_CHAT : Architecturé sur Micro-tête de chat\nARCHITECTURE_SUR_TETE_DE_CHAT : Architecturé sur tête de chat\nAUTRES_FORMES_ARCHITECTUREES : Autres formes architecturées\nCHANDELLE_NICHE_ECOLOGIQUE : Chandelle ou Niche écologique\nCONTENU : Contenu\nDELAISSEE : Délaissée\nFORME_REDUITE_SECURITE : Forme réduite de sécurité\nLIBRE : Libre\nMIXTE : Mixte\nMIXTE_ISSU_D_UNE_CONVERSION : Mixte issu d'une conversion\nMUTILEE : Mutilée\nSEMI_LIBRE : Semi-libre\nSEMI_LIBRE_ISSU_D_UNE_CONVERSION : Semi-libre issu d'une conversion\nSEMI_LIBRE_UNILATERAL : Semi-libre unilatéral\nTETARD : Tétard"},{"name":"dimension_plantation","type":"text","label":null,"fill_pct":10.6,"filterable":true,"description":"Dimension à la plantation : \nListe des valeurs possibles : \nJEUNE_PLANT_INF_100 : Jeune plant &lt; 100\nINF_6_8 : Inférieur à 6/8\n6_8 : 6/8\n8_10 : 8/10\n10_12 : 10/12\n12_14 : 12/14\n14_16 : 14/16\n16_18 : 16/18\n18_20 : 18/20\n20_25 : 20/25\n25_30 : 25/30\n30_35 : 30/35\n35_40 : 35/40\n40_50 : 40/50\nSUP_50 : Supérieur à 50\n100_125 : 100/125\n125_150 : 125/150\n150_175 : 150/175\n175_200 : 175/200\n200_250 : 200/250\n250_300 : 250/300\n300_350 : 300/350\n350_400 : 350/400\n400_500 : 400/500\nSUP_500 : Plus de 500\nAUTRE : Autre"}],"field_count":42,"sample_records":[{"gid":229976,"nom":"Bordeaux","site":null,"carre":null,"cdate":"2026-03-04T16:53:11+00:00","cepee":false,"forme":null,"insee":"33063","mdate":null,"unite":"Bastide-Bordeaux Maritime","classe":"Feuillu","espece":"Celtis sinensis","geom_o":null,"numero":"14","statut":"VIVANT","famille":"Cannabaceae","hauteur":5,"station":"Jardin du Pertuis","vigueur":null,"fruitier":false,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5601191,44.8669522]},"properties":{}},"nature_sol":null,"geo_point_2d":{"lat":44.8669522,"lon":-0.5601191},"nom_francais":"Micocoulier de Chine","stock_carbone":71.64,"couverture_sol":null,"diametre_tronc":8,"date_plantation":"2022-03-28","diametre_souche":null,"age_approximatif":4,"date_disparition":null,"typologie_espace":"PARC_JARDIN_ET_SQUARE","cause_disparition":null,"diametre_couronne":null,"duree_de_maintien":null,"typologie_environ":null,"distribut_spatiale":null,"statut_patrimonial":null,"circonference_tronc":25,"stade_developpement":null,"dimension_plantation":null},{"gid":229980,"nom":"Bordeaux","site":null,"carre":null,"cdate":"2026-03-04T16:53:11+00:00","cepee":false,"forme":null,"insee":"33063","mdate":null,"unite":"Bastide-Bordeaux Maritime","classe":"Feuillu","espece":"Ulmus sp.","geom_o":null,"numero":"43","statut":"VIVANT","famille":"Ulmaceae","hauteur":5,"station":"Jardin du Pertuis","vigueur":null,"fruitier":false,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5595861,44.8671779]},"properties":{}},"nature_sol":null,"geo_point_2d":{"lat":44.8671779,"lon":-0.5595861},"nom_francais":"Orme","stock_carbone":71.64,"couverture_sol":null,"diametre_tronc":8,"date_plantation":"2022-03-28","diametre_souche":null,"age_approximatif":4,"date_disparition":null,"typologie_espace":"PARC_JARDIN_ET_SQUARE","cause_disparition":null,"diametre_couronne":null,"duree_de_maintien":null,"typologie_environ":null,"distribut_spatiale":null,"statut_patrimonial":null,"circonference_tronc":25,"stade_developpement":null,"dimension_plantation":null},{"gid":39362,"nom":"Bordeaux","site":null,"carre":null,"cdate":"2016-07-23T22:00:00+00:00","cepee":false,"forme":"SEMI_LIBRE","insee":"33063","mdate":"2026-02-21T03:57:08+00:00","unite":"Caudéran-Saint Augustin","classe":"Feuillu","espece":"Ligustrum japonicum","geom_o":null,"numero":"3","statut":"VIVANT","famille":"Oleaceae","hauteur":7,"station":"Association Saint Vincent de Paul","vigueur":"FAIBLE","fruitier":false,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.6196,44.8497295]},"properties":{}},"nature_sol":"TERRE_VEGETALE","geo_point_2d":{"lat":44.8497295,"lon":-0.6196},"nom_francais":"Troène du Japon","stock_carbone":1334.91,"couverture_sol":"GRAVE","diametre_tronc":27,"date_plantation":null,"diametre_souche":null,"age_approximatif":null,"date_disparition":null,"typologie_espace":"ETABLISSEMENT_SOCIAL","cause_disparition":null,"diametre_couronne":null,"duree_de_maintien":"6_10_ANS","typologie_environ":null,"distribut_spatiale":null,"statut_patrimonial":null,"circonference_tronc":85,"stade_developpement":"ADULTE","dimension_plantation":null},{"gid":45624,"nom":"Bordeaux","site":null,"carre":"A","cdate":"2024-01-22T23:00:00+00:00","cepee":false,"forme":null,"insee":"33063","mdate":"2026-02-21T03:57:08+00:00","unite":"Bastide-Bordeaux Maritime","classe":"Feuillu","espece":"Acer campestre","geom_o":null,"numero":"347","statut":"VIVANT","famille":"Sapindaceae","hauteur":4,"station":"Parc Denis et Eugène Bühler","vigueur":null,"fruitier":false,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5722252,44.8757355]},"properties":{}},"nature_sol":null,"geo_point_2d":{"lat":44.8757355,"lon":-0.5722252},"nom_francais":"Erable champêtre","stock_carbone":14.74,"couverture_sol":null,"diametre_tronc":4,"date_plantation":"2022-12-01","diametre_souche":null,"age_approximatif":4,"date_disparition":null,"typologie_espace":"PARC_JARDIN_ET_SQUARE","cause_disparition":null,"diametre_couronne":null,"duree_de_maintien":null,"typologie_environ":null,"distribut_spatiale":null,"statut_patrimonial":null,"circonference_tronc":13,"stade_developpement":null,"dimension_plantation":null},{"gid":11614,"nom":"Bordeaux","site":null,"carre":null,"cdate":"2010-10-09T22:00:00+00:00","cepee":false,"forme":"SEMI_LIBRE","insee":"33063","mdate":"2026-04-03T08:39:10+00:00","unite":"Bastide-Bordeaux Maritime","classe":"Feuillu","espece":"Carpinus betulus","geom_o":null,"numero":"4","statut":"VIVANT","famille":"Betulaceae","hauteur":6,"station":"René Magne (rue)","vigueur":"MOYENNE","fruitier":false,"geom_err":null,"geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5459519,44.8886601]},"properties":{}},"nature_sol":null,"geo_point_2d":{"lat":44.8886601,"lon":-0.5459519},"nom_francais":"Charme commun","stock_carbone":943.18,"couverture_sol":"VEGETALISE","diametre_tronc":24,"date_plantation":null,"diametre_souche":null,"age_approximatif":null,"date_disparition":null,"typologie_espace":"ESPACE_DACCOMPAGNEMENT_DE_VOIRIE","cause_disparition":null,"diametre_couronne":4,"duree_de_maintien":"SUP_20_ANS","typologie_environ":null,"distribut_spatiale":null,"statut_patrimonial":null,"circonference_tronc":75,"stade_developpement":"ADULTE","dimension_plantation":null}],"record_count":"80203","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p/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/ec_arbre_p/records?select=geo_point_2d%2Cgeo_shape%2Cgid&where=geom_o+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p/records?select=geo_point_2d%2Cgeo_shape%2Cgid&where=geom_o+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (geo_point_2d, geo_shape, gid) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/ec_arbre_p/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-09-02T20:22:44.132Z","run_id":"66fe8f21-28ad-4249-8624-6e6323af7402","created_at":"2026-07-25T23:53:56.141Z","updated_at":"2026-09-02T20:22:44.132Z","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,"personal_data":{"status":"named_subject_unknown","basis":"name_subject_not_stated","grain":"unknown","allowed":true,"columns":{"direct_identifiers":[],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":["nom"],"measures":[],"entity_identifiers":[]},"publication":null,"publication_evidence":null,"notice":"personal data: a NAME is cited and the schema does not say whose — nom carries the row's subject in the form that identifies it, and nothing else cited says whether that subject is a person or a thing; permitted under the owner ruling of 2026-08-25 (refusing every name column withholds trees and bus stops and protects nobody) and published as unstated rather than as “no person column”; columns — identifiers: none; names: none; names of an unstated subject: nom; attributes: none; measures: none; entity keys: none"}},"datasets":[],"limits":[{"id":"9089aee0-fd18-49ef-8409-94beb7eb2be3","entry_id":"4f9524be-8a7e-4d0b-8990-a122d2a111a8","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-09-02T20:22:45.759Z"}],"source_access":{"status":"accessed_despite_disallow","host":"opendata.bordeaux-metropole.fr","requested_path_prefix":"/api/explore/v2.1/catalog/datasets/","robots_url":"https://opendata.bordeaux-metropole.fr/robots.txt","user_agent_group":"*","robots_rule":"Disallow: /api/","robots_read_at":"2026-08-25T11:29:13.017Z","decision_ref":"owner decision 2026-08-22, recorded in docs/PROGRESS.md NEEDS-HUMAN: public-sector open-data portals whose purpose is machine access; the directive is an Opendatasoft vendor default reflecting no publisher intent. Concern raised and overruled; see the row.","note":"This answer is derived from a host whose robots.txt DISALLOWS the path Commodity requests, and Commodity requests it anyway under the decision named in `decision_ref`. The rule is quoted verbatim so you can read it yourself. Commodity does not send a user-agent it is not, so any `Allow` granted to a named crawler in that file is not claimed here."},"field_provenance_source_access":{"status":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THIS PLATFORM’S READING OF ITS OWN CONDUCT: that it requests a path this host forbids. No publisher asserts it and none was asked to","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"host":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"the host Commodity addressed, lowercased and stripped of scheme and port by this platform so that one host has one row and one reading","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"requested_path_prefix":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THE PATH THE VERDICT IS ABOUT, derived from the base URLs this platform stores for the host — not `/`, and not an assumed `/api/`. A verdict about a path we do not call would describe someone else’s traffic","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_url":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"where the file was fetched from — composed by this platform from the host, at the one location the protocol fixes, so it can be re-fetched and the reading disputed","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"user_agent_group":{"basis":"stored_sample","derived":false,"upstream_field":"the `User-agent` line the deciding rule sits under","transform":"the group heading that made the rule OURS, verbatim from the stored file. Where it is `*` the directive addresses everyone; a group naming another crawler was not applied, because Commodity does not send a user-agent it is not","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_rule":{"basis":"stored_sample","derived":false,"upstream_field":"the directive line of the matching group","transform":"THE PUBLISHER’S OWN LINE, QUOTED AND UNCUT, as read from robots.txt at the moment below and stored — not fetched for this request, and not part of this response’s payload. It is here so the verdict beside it can be checked rather than taken from us","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_read_at":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"OUR CLOCK when the file was read, never a `Date` header the origin sent. It bounds how stale this reading may be: a publisher can have changed the file since","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"decision_ref":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"WHO DECIDED TO CALL IT ANYWAY, AND WHEN. Recorded by this platform and required by the database before the exception may exist at all, so it can never be anonymous","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"note":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"this platform’s sentence explaining what the reader is holding. Written here, by us, and not a quotation of anybody","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}}},"manifest":{"answer_sha256":"4d5321dfa59db5f5039a3aa81d7df85e0f2e85a5af8bd5e3b0e07fd52f0e6ac8","answer_sha256_rule":"sha256 (hex, UTF-8) of JSON.stringify(this body) after deleting the keys listed in manifest.stamped_keys from manifest, and deleting manifest itself if it is then empty. The hash was computed before the stamp existed, so no field of the stamp is inside it.","stamped_keys":["answer_sha256","answer_sha256_rule","stamped_keys","row_count","row_count_basis","live","live_basis","created_at","created_at_basis","durable_citation"],"row_count":63,"row_count_basis":"Objects that are elements of a JSON array anywhere in this body, excluding manifest. Not a claim about which collection is the answer. Largest single collection: data_profile.fields[] (42 rows).","live":false,"live_basis":"This body was replayed from the worker edge cache (x-edge-cache: hit); the bytes, and therefore answer_sha256, are those of the execution that filled the cache.","created_at":"2026-09-09T09:08:12.412Z","created_at_basis":"When this response body was assembled, deliberately OUTSIDE the hashed bytes so the same answer hashes identically on every request. Not the upstream read time — that is provenance[].retrieved_at. A zone-cached replay carries the assembly time, not your receipt time.","durable_citation":"This manifest is produced at response time and is NOT stored. A durable, replayable citation is persisted only on an explicit cite: GET /api/v1/entries/{id-or-slug}/evidence, or the MCP cite_query tool. Both are entry-scoped, because evidence_manifests is entry-shaped; a domain answer spanning several sources has no single entry and cannot be persisted through that path."}}