{"id":"58fedc76-03ec-4d58-bbf6-297df24095fe","type":"API","name":"Projet alimentaire territorial","slug":"projet-alimentaire-territorial","description":"Dictionnaire Public Ce jeu de données recense les points de vente des produits locaux et durable présents sur la Métropole. Il informe sur les horaires et les produits disponibles dans ces points de vente. Ce jeu de données est disponible dans un format additionnel : Téléchargement au format Auto...","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/de_pat_p/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/de_pat_p/","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/de_pat_p/","extraction_confidence":"0.00","created_at":"2026-07-25T18:59:16.916Z","updated_at":"2026-07-25T20:18:59.048Z","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":"'additionnel':47B,98B 'alimentair':2A 'alimentaire':53A 'au':49B,100B 'auto':51B,102B 'ce':6B,38B,57B,89B 'ces':34B,85B 'dan':33B,44B 'dans':84B,95B 'de':8B,13B,36B,40B,59B,64B,87B,91B 'des':15B,66B 'dictionnair':4B 'dictionnaire':55B 'dispon':32B,43B 'disponible':94B 'disponibles':83B 'donnees':60B,92B 'donné':9B,41B 'durabl':19B 'durable':70B 'est':42B,93B 'et':18B,29B,69B,80B 'format':46B,50B,97B,101B 'horair':28B 'horaires':79B 'il':24B,75B 'inform':25B 'informe':76B 'jeu':7B,39B,58B,90B 'la':22B,73B 'les':11B,27B,30B,62B,78B,81B 'locaux':17B,68B 'metropole':74B 'métropol':23B 'point':12B,35B 'points':63B,86B 'presents':71B 'produit':16B,31B 'produits':67B,82B 'projet':1A,52A 'présent':20B 'public':5B,56B 'recens':10B 'recense':61B 'sur':21B,26B,72B,77B 'telechargement':99B 'territori':3A 'territorial':54A 'téléchargement':48B 'un':45B,96B 'vent':14B,37B 'vente':65B,88B","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-26T09:36:47.865Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":13.75,"access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/de_pat_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/de_pat_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/de_pat_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/de_pat_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":"API base URL","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/de_pat_p","source":"base_url","runnable":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/de_pat_p/","source":"docs","runnable":false}],"formats":["CSV"]},"api_details":{"id":"44e05bd8-9f0b-4ba7-a6ed-b7f8b9ce96c4","entry_id":"58fedc76-03ec-4d58-bbf6-297df24095fe","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/de_pat_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/de_pat_p","created_at":"2026-07-25T18:59:17.081Z","updated_at":"2026-07-25T18:59:17.081Z"},"dataset_details":{"id":"22e6d961-bc05-4bf8-b1f8-4d36f587faf5","entry_id":"58fedc76-03ec-4d58-bbf6-297df24095fe","upstream_issued":null,"upstream_modified":"2026-07-25T04:20:25.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-25T18:59:40.838Z","updated_at":"2026-07-25T18:59:40.838Z","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"},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","latest_check":null,"data_profile":{"id":"c67f9dc6-6c25-4101-a0d0-69cff09f572e","entry_id":"58fedc76-03ec-4d58-bbf6-297df24095fe","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"de_pat_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":"adresse","type":"text","label":null,"filterable":true,"description":"Adresse"},{"name":"insee","type":"text","label":null,"filterable":true,"description":"Code INSEE : \nListe des valeurs possibles : \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":"telephone","type":"text","label":null,"filterable":true,"description":"Téléphone"},{"name":"email","type":"text","label":null,"filterable":true,"description":"Email"},{"name":"cdate","type":"datetime","label":null,"filterable":true,"description":"Date de création"},{"name":"mdate","type":"datetime","label":null,"fill_pct":100,"filterable":true,"description":"Date de modification"},{"name":"categorie","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Catégorie : \nListe des valeurs possibles : \nVENTE_DIRECTE_PRODUCTEUR : Vente directe producteur\nCASIER : Casier\nMARCHE : Marché\nCLICK_COLLECT_AVEC_ADHESION : Click & collect avec adhésion\nCLICK_COLLECT_SANS_ADHESION : Click & collect sans adhésion\nMAGASIN_DE_PRODUCTEURS : Magasin de producteurs\nPOINT_VENTE_DE_PRODUITS_LOCAUX : Point de vente de produits locaux\nAMAP : Association pour le maintien de l'agriculture paysanne"},{"name":"mode_de_vente","type":"text","label":null,"fill_pct":15.5,"filterable":true,"description":"Autre(s) mode(s) de vente : \nListe des valeurs possibles : \nLIVRAISON_A_DOMICILE : Livraison à domicile\nCLICK_COLLECT : Click & collect"},{"name":"libelle","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Libellé de la structure"},{"name":"produits_a_la_vente","type":"text","label":null,"fill_pct":738.2,"filterable":true,"description":"Produits à la vente : \nListe des valeurs possibles : \nFRUITS_ET_LEGUMES : Fruits et légumes\nPRODUITS_LAITIERS : Produits laitiers\nPRODUITS_CARNES : Produits carnés\nPRODUITS_DE_LA_MER : Produits de la mer\nOEUFS : Oeufs\nMIEL_ET_PRODUITS_DE_LA_RUCHE : Miel et produits de la ruche\nPRODUITS_SECS : Produits secs\nBOULANGERIE : Boulangerie\nEPICERIE_SUCREE : Epicerie sucrée\nEPICERIE_SALEE : Epicerie salée\nBOISSONS_ALCOOLISES : Boissons alcoolisés\nBOISSONS_NON_ALCOOLISES : Boissons non alcoolisés"},{"name":"localisation","type":"text","label":null,"fill_pct":60.4,"filterable":true,"description":"Information(s) complémentaire(s)"},{"name":"ouverture","type":"text","label":null,"fill_pct":98.6,"filterable":true,"description":"Horaire(s)"},{"name":"site_web","type":"text","label":null,"fill_pct":87.4,"filterable":true,"description":"Site internet"},{"name":"lien_facebook","type":"text","label":null,"fill_pct":34.8,"filterable":true,"description":"Lien FaceBook"},{"name":"lien_instagram","type":"text","label":null,"fill_pct":17.9,"filterable":true,"description":"Lien Instagram"},{"name":"lien_linkedin","type":"text","label":null,"fill_pct":1.4,"filterable":true,"description":"Lien Linkedin"},{"name":"label_bio","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Label BIO : \nListe des valeurs possibles : \n100_POUR_CENT_PRODUITS_AB : 100 % des produits issus de l'Agriculture Biologique\nUN_POUR_CENT_PRODUITS_AB : Une part des produits est issue de l'Agriculture Biologique\nNON : Non"}],"field_count":22,"sample_records":[{"gid":70,"cdate":"2024-10-10T12:50:17+00:00","email":"RuchePeyBerland@gmail.com","insee":"33063","mdate":"2025-01-31T09:39:44+00:00","geom_o":"0","adresse":"9 Rue de la Porte Basse, 33000 Bordeaux","libelle":"La Ruche qui dit Oui ! - Pey Berland","geom_err":null,"site_web":"https://laruchequiditoui.fr/fr/assemblies/10904","categorie":"CLICK_COLLECT_SANS_ADHESION","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5755298,44.8370636]},"properties":{}},"label_bio":"UN_POUR_CENT_PRODUITS_AB","ouverture":"Le mercredi de 17:30 à 19:30","telephone":["0783970817"],"geo_point_2d":{"lat":44.8370636,"lon":-0.5755298},"localisation":null,"lien_facebook":"https://www.facebook.com/RuchePeyBerland/","lien_linkedin":null,"mode_de_vente":["LIVRAISON_A_DOMICILE"],"lien_instagram":"https://www.instagram.com/ruchepeyberland/","produits_a_la_vente":["FRUITS_ET_LEGUMES","PRODUITS_LAITIERS","PRODUITS_CARNES","PRODUITS_DE_LA_MER","OEUFS","MIEL_ET_PRODUITS_DE_LA_RUCHE","PRODUITS_SECS","BOULANGERIE","EPICERIE_SUCREE","EPICERIE_SALEE","BOISSONS_ALCOOLISES","BOISSONS_NON_ALCOOLISES"]},{"gid":71,"cdate":"2024-10-10T12:50:17+00:00","email":null,"insee":"33063","mdate":"2025-01-31T09:39:44+00:00","geom_o":"0","adresse":"20 Rue de Châteauneuf, 33100 Bordeaux","libelle":"La Ruche qui dit Oui ! - Bastide","geom_err":null,"site_web":"https://laruchequiditoui.fr/fr/assemblies/2055","categorie":"CLICK_COLLECT_SANS_ADHESION","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5531458,44.8414371]},"properties":{}},"label_bio":"UN_POUR_CENT_PRODUITS_AB","ouverture":"Le vendredi de 18:00 à 19:00","telephone":["0769184350"],"geo_point_2d":{"lat":44.8414371,"lon":-0.5531458},"localisation":null,"lien_facebook":null,"lien_linkedin":null,"mode_de_vente":null,"lien_instagram":null,"produits_a_la_vente":["FRUITS_ET_LEGUMES","PRODUITS_LAITIERS","PRODUITS_CARNES","PRODUITS_DE_LA_MER","OEUFS","MIEL_ET_PRODUITS_DE_LA_RUCHE","PRODUITS_SECS","BOULANGERIE","EPICERIE_SUCREE","EPICERIE_SALEE","BOISSONS_ALCOOLISES","BOISSONS_NON_ALCOOLISES"]},{"gid":73,"cdate":"2024-10-10T12:50:17+00:00","email":"rucheelevagemonchany@gmail.com","insee":"33449","mdate":"2025-01-31T09:39:44+00:00","geom_o":"0","adresse":"3 Rue Jean Henri Fabre, 33160 Saint-Médard-en-Jalles","libelle":"La Ruche qui dit Oui ! - Saint-Médard-en-Jallles-Magudas","geom_err":null,"site_web":"https://laruchequiditoui.fr/fr/assemblies/12199","categorie":"CLICK_COLLECT_SANS_ADHESION","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.7330949,44.8658919]},"properties":{}},"label_bio":"UN_POUR_CENT_PRODUITS_AB","ouverture":"Le vendredi de 17:30 à 19:00","telephone":["0783970817"],"geo_point_2d":{"lat":44.8658919,"lon":-0.7330949},"localisation":null,"lien_facebook":"https://www.facebook.com/ruchemagudas/","lien_linkedin":null,"mode_de_vente":null,"lien_instagram":null,"produits_a_la_vente":["FRUITS_ET_LEGUMES","PRODUITS_LAITIERS","PRODUITS_CARNES","PRODUITS_DE_LA_MER","OEUFS","MIEL_ET_PRODUITS_DE_LA_RUCHE","PRODUITS_SECS","BOULANGERIE","EPICERIE_SUCREE","EPICERIE_SALEE","BOISSONS_ALCOOLISES","BOISSONS_NON_ALCOOLISES"]},{"gid":75,"cdate":"2024-10-10T12:50:17+00:00","email":null,"insee":"33318","mdate":"2025-01-31T09:39:44+00:00","geom_o":"0","adresse":"7 Rue des Bouleaux, 33600 Pessac","libelle":"La Ruche qui dit Oui ! - Pessac","geom_err":null,"site_web":"https://laruchequiditoui.fr/fr/assemblies/11067","categorie":"CLICK_COLLECT_SANS_ADHESION","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.685906,44.7989717]},"properties":{}},"label_bio":"UN_POUR_CENT_PRODUITS_AB","ouverture":"Le mercredi de 16:00 à 21:00","telephone":null,"geo_point_2d":{"lat":44.7989717,"lon":-0.685906},"localisation":null,"lien_facebook":null,"lien_linkedin":null,"mode_de_vente":["LIVRAISON_A_DOMICILE"],"lien_instagram":null,"produits_a_la_vente":["FRUITS_ET_LEGUMES","PRODUITS_LAITIERS","PRODUITS_CARNES","PRODUITS_DE_LA_MER","OEUFS","MIEL_ET_PRODUITS_DE_LA_RUCHE","PRODUITS_SECS","BOULANGERIE","EPICERIE_SUCREE","EPICERIE_SALEE","BOISSONS_ALCOOLISES","BOISSONS_NON_ALCOOLISES"]},{"gid":77,"cdate":"2024-10-10T12:50:17+00:00","email":"alicia-bordeaux@vrac-asso.org","insee":"33063","mdate":"2025-01-31T09:39:44+00:00","geom_o":"0","adresse":"139 Rue Joseph Brunet, 33300 Bordeaux","libelle":"VRAC Bacalan","geom_err":null,"site_web":"https://epicerie.vrac-asso.org/group/2017/","categorie":"CLICK_COLLECT_AVEC_ADHESION","geo_shape":{"type":"Feature","geometry":{"type":"Point","coordinates":[-0.5436481,44.8794782]},"properties":{}},"label_bio":"UN_POUR_CENT_PRODUITS_AB","ouverture":"Le mercredi soir","telephone":["0744596574"],"geo_point_2d":{"lat":44.8794782,"lon":-0.5436481},"localisation":"Centre d'animation Bacalan","lien_facebook":null,"lien_linkedin":null,"mode_de_vente":null,"lien_instagram":null,"produits_a_la_vente":["FRUITS_ET_LEGUMES","OEUFS","MIEL_ET_PRODUITS_DE_LA_RUCHE","PRODUITS_SECS","BOULANGERIE","EPICERIE_SUCREE","EPICERIE_SALEE","BOISSONS_NON_ALCOOLISES"]}],"record_count":"207","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/de_pat_p/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/de_pat_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/de_pat_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/de_pat_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/de_pat_p/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/de_pat_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-07-25T18:59:40.178Z","run_id":"dd9ad555-4a27-416d-a97a-1e8a34506e05","created_at":"2026-07-25T18:59:40.178Z","updated_at":"2026-07-25T18:59:40.178Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","license_id":"lo-2.0","previewable":true},"datasets":[],"limits":[{"id":"96653630-4ea1-48d3-b0ec-30428f355450","entry_id":"58fedc76-03ec-4d58-bbf6-297df24095fe","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-25T18:59:40.997Z"}]}