{"ok":true,"generated_at":"2026-07-08T00:14:29+02:00","source_count":10,"summary":{"priority_counts":{"P1":7,"P2":2,"P3":1,"P4":0},"domain_counts":{"durabilite_vin":1,"economie_vin":3,"foncier_viticole":1,"geocodage":2,"oenotourisme":1,"reglementaire_vin":1,"tourisme_territoire":1},"top_priority":[{"source_key":"insee_tourism_capacity_communes","label":"Capacites communales d'hebergement touristique","producer":"Insee","domain":"oenotourisme","official_url":"https://www.insee.fr/fr/statistiques/2021703","access_mode":"csv_insee","granularity":"commune, EPCI, departement, region, type hebergement","refresh_signal":"Parution annuelle 2026 disponible","user_need":"Qualifier le potentiel d'accueil autour d'une appellation ou destination","primary_kpis":"hotels, chambres, campings, emplacements, autres_hebergements","candidate_exports":"tourism_capacity_pack, destination_capacity_card","impact":"5","access_score":"5","granularity_score":"5","freshness_score":"5","effort_score":"2","confidence_score":"5","next_action":"Importer le CSV 2026 telecharge puis croiser par communes INAO/DATAtourisme.","caveat":"La capacite touristique n'identifie pas directement les offres oenotouristiques.","opportunity_score":48,"priority":"P1","primary_kpis_list":["hotels","chambres","campings","emplacements","autres_hebergements"],"candidate_exports_list":["tourism_capacity_pack","destination_capacity_card"],"copy_sentence":"Capacites communales d'hebergement touristique : Qualifier le potentiel d'accueil autour d'une appellation ou destination. Action : Importer le CSV 2026 telecharge puis croiser par communes INAO/DATAtourisme."},{"source_key":"inao_aoc_aop_igp_areas_products","label":"Aires et produits AOC/AOP et IGP","producer":"INAO","domain":"reglementaire_vin","official_url":"https://www.data.gouv.fr/datasets/aires-et-produits-aoc-aop-et-igp","access_mode":"files_data_gouv","granularity":"aire geographique, produit, signe, commune potentielle","refresh_signal":"Mis a jour en 2025","user_need":"Completer les preuves appellation avec les IGP et liens produit-territoire","primary_kpis":"area_product_count, igp_count, aoc_aop_count","candidate_exports":"appellation_product_scope_pack, igp_gap_card","impact":"5","access_score":"4","granularity_score":"5","freshness_score":"4","effort_score":"2","confidence_score":"5","next_action":"Comparer avec les imports INAO existants puis ajouter les IGP manquantes.","caveat":"Risque de doublon avec les sources INAO deja integrees : necessite une table de correspondance.","opportunity_score":45,"priority":"P1","primary_kpis_list":["area_product_count","igp_count","aoc_aop_count"],"candidate_exports_list":["appellation_product_scope_pack","igp_gap_card"],"copy_sentence":"Aires et produits AOC/AOP et IGP : Completer les preuves appellation avec les IGP et liens produit-territoire. Action : Comparer avec les imports INAO existants puis ajouter les IGP manquantes."},{"source_key":"ban_address_reference","label":"Base Adresse Nationale","producer":"Base Adresse Nationale / IGN","domain":"geocodage","official_url":"https://www.data.gouv.fr/datasets/base-adresse-nationale","access_mode":"metadata_api_files_flux","granularity":"adresse, commune, coordonnees, statut commune","refresh_signal":"Metadata data.gouv recuperee le 2026-07-05","user_need":"Verifier, normaliser et geocoder les adresses de domaines, caves et offres touristiques","primary_kpis":"address_score, lon, lat, citycode, certified_address, geocoded_rate","candidate_exports":"address_quality_pack, offer_geocoding_card","impact":"4","access_score":"5","granularity_score":"5","freshness_score":"5","effort_score":"3","confidence_score":"5","next_action":"Metadata BAN et etat commune recuperees","caveat":"produire sources/ban-address-quality.csv depuis les lieux Winerix.","opportunity_score":44,"priority":"P1","primary_kpis_list":["address_score","lon","lat","citycode","certified_address","geocoded_rate"],"candidate_exports_list":["address_quality_pack","offer_geocoding_card"],"copy_sentence":"Base Adresse Nationale : Verifier, normaliser et geocoder les adresses de domaines, caves et offres touristiques. Action : Metadata BAN et etat commune recuperees"},{"source_key":"sirene_wine_establishments","label":"Etablissements vin via Sirene","producer":"Insee","domain":"economie_vin","official_url":"https://www.data.gouv.fr/datasets/base-sirene-des-entreprises-et-de-leurs-etablissements-siren-siret","access_mode":"zip_csv_parquet_api","granularity":"etablissement, activite NAF, commune, unite legale","refresh_signal":"Stock mensuel et API","user_need":"Identifier producteurs, negociants, caves, commerces et acteurs de l'ecosysteme vin","primary_kpis":"establishments_active, naf_code, commune, legal_unit","candidate_exports":"wine_establishment_directory, business_density_card","impact":"5","access_score":"4","granularity_score":"5","freshness_score":"5","effort_score":"4","confidence_score":"4","next_action":"Telecharger le stock etablissement, importer via sources/wine-naf-codes.csv, publier d'abord les agregats.","caveat":"Donnees personnelles et obligations RGPD a cadrer avant publication nominative.","opportunity_score":42,"priority":"P1","primary_kpis_list":["establishments_active","naf_code","commune","legal_unit"],"candidate_exports_list":["wine_establishment_directory","business_density_card"],"copy_sentence":"Etablissements vin via Sirene : Identifier producteurs, negociants, caves, commerces et acteurs de l'ecosysteme vin. Action : Telecharger le stock etablissement, importer via sources/wine-naf-codes.csv, publier d'abord les agregats."},{"source_key":"sirene_geolocation","label":"Geolocalisation des etablissements Sirene","producer":"Insee","domain":"geocodage","official_url":"https://www.data.gouv.fr/datasets/geolocalisation-des-etablissements-du-repertoire-sirene-pour-les-etudes-statistiques","access_mode":"parquet_csv","granularity":"SIRET, coordonnees, commune, qualite geocodage, IRIS","refresh_signal":"Mensuel","user_need":"Positionner les etablissements vin et detecter les zones de concentration","primary_kpis":"geocoded_siret, quality, iris, commune","candidate_exports":"wine_business_map_layer, geocoding_quality_card","impact":"4","access_score":"4","granularity_score":"5","freshness_score":"5","effort_score":"3","confidence_score":"4","next_action":"Preparer une jointure SIRET avec le filtrage Sirene vin.","caveat":"Le CSV sera arrete au profit du parquet dans le courant du second semestre 2027.","opportunity_score":40,"priority":"P1","primary_kpis_list":["geocoded_siret","quality","iris","commune"],"candidate_exports_list":["wine_business_map_layer","geocoding_quality_card"],"copy_sentence":"Geolocalisation des etablissements Sirene : Positionner les etablissements vin et detecter les zones de concentration. Action : Preparer une jointure SIRET avec le filtrage Sirene vin."}]},"sources":[{"source_key":"insee_tourism_capacity_communes","label":"Capacites communales d'hebergement touristique","producer":"Insee","domain":"oenotourisme","official_url":"https://www.insee.fr/fr/statistiques/2021703","access_mode":"csv_insee","granularity":"commune, EPCI, departement, region, type hebergement","refresh_signal":"Parution annuelle 2026 disponible","user_need":"Qualifier le potentiel d'accueil autour d'une appellation ou destination","primary_kpis":"hotels, chambres, campings, emplacements, autres_hebergements","candidate_exports":"tourism_capacity_pack, destination_capacity_card","impact":"5","access_score":"5","granularity_score":"5","freshness_score":"5","effort_score":"2","confidence_score":"5","next_action":"Importer le CSV 2026 telecharge puis croiser par communes INAO/DATAtourisme.","caveat":"La capacite touristique n'identifie pas directement les offres oenotouristiques.","opportunity_score":48,"priority":"P1","primary_kpis_list":["hotels","chambres","campings","emplacements","autres_hebergements"],"candidate_exports_list":["tourism_capacity_pack","destination_capacity_card"],"copy_sentence":"Capacites communales d'hebergement touristique : Qualifier le potentiel d'accueil autour d'une appellation ou destination. Action : Importer le CSV 2026 telecharge puis croiser par communes INAO/DATAtourisme."},{"source_key":"inao_aoc_aop_igp_areas_products","label":"Aires et produits AOC/AOP et IGP","producer":"INAO","domain":"reglementaire_vin","official_url":"https://www.data.gouv.fr/datasets/aires-et-produits-aoc-aop-et-igp","access_mode":"files_data_gouv","granularity":"aire geographique, produit, signe, commune potentielle","refresh_signal":"Mis a jour en 2025","user_need":"Completer les preuves appellation avec les IGP et liens produit-territoire","primary_kpis":"area_product_count, igp_count, aoc_aop_count","candidate_exports":"appellation_product_scope_pack, igp_gap_card","impact":"5","access_score":"4","granularity_score":"5","freshness_score":"4","effort_score":"2","confidence_score":"5","next_action":"Comparer avec les imports INAO existants puis ajouter les IGP manquantes.","caveat":"Risque de doublon avec les sources INAO deja integrees : necessite une table de correspondance.","opportunity_score":45,"priority":"P1","primary_kpis_list":["area_product_count","igp_count","aoc_aop_count"],"candidate_exports_list":["appellation_product_scope_pack","igp_gap_card"],"copy_sentence":"Aires et produits AOC/AOP et IGP : Completer les preuves appellation avec les IGP et liens produit-territoire. Action : Comparer avec les imports INAO existants puis ajouter les IGP manquantes."},{"source_key":"ban_address_reference","label":"Base Adresse Nationale","producer":"Base Adresse Nationale / IGN","domain":"geocodage","official_url":"https://www.data.gouv.fr/datasets/base-adresse-nationale","access_mode":"metadata_api_files_flux","granularity":"adresse, commune, coordonnees, statut commune","refresh_signal":"Metadata data.gouv recuperee le 2026-07-05","user_need":"Verifier, normaliser et geocoder les adresses de domaines, caves et offres touristiques","primary_kpis":"address_score, lon, lat, citycode, certified_address, geocoded_rate","candidate_exports":"address_quality_pack, offer_geocoding_card","impact":"4","access_score":"5","granularity_score":"5","freshness_score":"5","effort_score":"3","confidence_score":"5","next_action":"Metadata BAN et etat commune recuperees","caveat":"produire sources/ban-address-quality.csv depuis les lieux Winerix.","opportunity_score":44,"priority":"P1","primary_kpis_list":["address_score","lon","lat","citycode","certified_address","geocoded_rate"],"candidate_exports_list":["address_quality_pack","offer_geocoding_card"],"copy_sentence":"Base Adresse Nationale : Verifier, normaliser et geocoder les adresses de domaines, caves et offres touristiques. Action : Metadata BAN et etat commune recuperees"},{"source_key":"sirene_wine_establishments","label":"Etablissements vin via Sirene","producer":"Insee","domain":"economie_vin","official_url":"https://www.data.gouv.fr/datasets/base-sirene-des-entreprises-et-de-leurs-etablissements-siren-siret","access_mode":"zip_csv_parquet_api","granularity":"etablissement, activite NAF, commune, unite legale","refresh_signal":"Stock mensuel et API","user_need":"Identifier producteurs, negociants, caves, commerces et acteurs de l'ecosysteme vin","primary_kpis":"establishments_active, naf_code, commune, legal_unit","candidate_exports":"wine_establishment_directory, business_density_card","impact":"5","access_score":"4","granularity_score":"5","freshness_score":"5","effort_score":"4","confidence_score":"4","next_action":"Telecharger le stock etablissement, importer via sources/wine-naf-codes.csv, publier d'abord les agregats.","caveat":"Donnees personnelles et obligations RGPD a cadrer avant publication nominative.","opportunity_score":42,"priority":"P1","primary_kpis_list":["establishments_active","naf_code","commune","legal_unit"],"candidate_exports_list":["wine_establishment_directory","business_density_card"],"copy_sentence":"Etablissements vin via Sirene : Identifier producteurs, negociants, caves, commerces et acteurs de l'ecosysteme vin. Action : Telecharger le stock etablissement, importer via sources/wine-naf-codes.csv, publier d'abord les agregats."},{"source_key":"sirene_geolocation","label":"Geolocalisation des etablissements Sirene","producer":"Insee","domain":"geocodage","official_url":"https://www.data.gouv.fr/datasets/geolocalisation-des-etablissements-du-repertoire-sirene-pour-les-etudes-statistiques","access_mode":"parquet_csv","granularity":"SIRET, coordonnees, commune, qualite geocodage, IRIS","refresh_signal":"Mensuel","user_need":"Positionner les etablissements vin et detecter les zones de concentration","primary_kpis":"geocoded_siret, quality, iris, commune","candidate_exports":"wine_business_map_layer, geocoding_quality_card","impact":"4","access_score":"4","granularity_score":"5","freshness_score":"5","effort_score":"3","confidence_score":"4","next_action":"Preparer une jointure SIRET avec le filtrage Sirene vin.","caveat":"Le CSV sera arrete au profit du parquet dans le courant du second semestre 2027.","opportunity_score":40,"priority":"P1","primary_kpis_list":["geocoded_siret","quality","iris","commune"],"candidate_exports_list":["wine_business_map_layer","geocoding_quality_card"],"copy_sentence":"Geolocalisation des etablissements Sirene : Positionner les etablissements vin et detecter les zones de concentration. Action : Preparer une jointure SIRET avec le filtrage Sirene vin."},{"source_key":"hve_certified_estates","label":"Annuaire exploitations certifiees HVE","producer":"Ministere Agriculture","domain":"durabilite_vin","official_url":"https://www.data.gouv.fr/datasets/annuaire-des-exploitations-certifiees-haute-valeur-environnementale","access_mode":"csv_xlsx_data_gouv","granularity":"exploitation, commune, departement, region, certification","refresh_signal":"CSV officiel au 2025-06-01 recupere","user_need":"Qualifier les territoires et domaines avec un signal environnemental officiel","primary_kpis":"certified_estates, wine_related_estates, wine_related_rate, commune_count","candidate_exports":"hve_sustainability_card, territory_sustainability_pack","impact":"4","access_score":"4","granularity_score":"4","freshness_score":"4","effort_score":"3","confidence_score":"4","next_action":"CSV officiel recupere dans sources/hve-certified-estates.csv","caveat":"rapprocher domaines Winerix/Sirene/BAN.","opportunity_score":37,"priority":"P1","primary_kpis_list":["certified_estates","wine_related_estates","wine_related_rate","commune_count"],"candidate_exports_list":["hve_sustainability_card","territory_sustainability_pack"],"copy_sentence":"Annuaire exploitations certifiees HVE : Qualifier les territoires et domaines avec un signal environnemental officiel. Action : CSV officiel recupere dans sources/hve-certified-estates.csv"},{"source_key":"franceagrimer_bulk_wine_prices","label":"Prix moyens vrac VSIG et IGP","producer":"FranceAgriMer","domain":"economie_vin","official_url":"https://www.data.gouv.fr/datasets/historique-des-prix-moyens-vrac-vsig-et-igp-depuis-2000","access_mode":"html_remote_plus_csv_template","granularity":"France entiere, semaine, campagne","refresh_signal":"Mis a jour en 2026","user_need":"Suivre la tension marche et donner un benchmark prix vin vrac","primary_kpis":"prix_moyen_hebdomadaire, campagne, categorie, couleur","candidate_exports":"bulk_price_index, market_tension_card","impact":"5","access_score":"3","granularity_score":"3","freshness_score":"5","effort_score":"3","confidence_score":"4","next_action":"Normaliser la ressource Visionet dans sources/franceagrimer-prices.csv puis lancer l'import bulk_prices.","caveat":"Donnees France entiere et ressource source en HTML distant : pas de granularite appellation ou commune.","opportunity_score":37,"priority":"P1","primary_kpis_list":["prix_moyen_hebdomadaire","campagne","categorie","couleur"],"candidate_exports_list":["bulk_price_index","market_tension_card"],"copy_sentence":"Prix moyens vrac VSIG et IGP : Suivre la tension marche et donner un benchmark prix vin vrac. Action : Normaliser la ressource Visionet dans sources/franceagrimer-prices.csv puis lancer l'import bulk_prices."},{"source_key":"agreste_vineyard_land_values","label":"Valeur venale des terres et vignes","producer":"Agreste / Ministere Agriculture","domain":"foncier_viticole","official_url":"https://www.data.gouv.fr/datasets/agreste-valeur-venale-des-terres","access_mode":"metadata_plus_url_resources","granularity":"region, departement, petite region agricole","refresh_signal":"Mis a jour le 2025-09-25 dans data.gouv","user_need":"Donner un indicateur foncier viticole pour attractivite, rarete et investissement","primary_kpis":"prix_moyen, prix_min, prix_max, evolution","candidate_exports":"vineyard_land_value_card, investment_context_pack","impact":"4","access_score":"3","granularity_score":"4","freshness_score":"4","effort_score":"3","confidence_score":"4","next_action":"Metadata officielle recuperee dans sources/agreste-vineyard-land-values-datagouv.json","caveat":"normaliser ensuite le CSV prix vignes.","opportunity_score":35,"priority":"P2","primary_kpis_list":["prix_moyen","prix_min","prix_max","evolution"],"candidate_exports_list":["vineyard_land_value_card","investment_context_pack"],"copy_sentence":"Valeur venale des terres et vignes : Donner un indicateur foncier viticole pour attractivite, rarete et investissement. Action : Metadata officielle recuperee dans sources/agreste-vineyard-land-values-datagouv.json"},{"source_key":"dgddi_vitivinicole_stocks_harvests","label":"Stocks et recoltes viti-vinicoles depuis 2009","producer":"DGDDI / Ministeres economiques","domain":"economie_vin","official_url":"https://www.data.gouv.fr/datasets/statistiques-viti-vinicoles-releves-annuels-des-stocks-et-des-recoltes-depuis-2009","access_mode":"metadata_plus_xls_resources","granularity":"departement, categorie, couleur, campagne","refresh_signal":"Metadata data.gouv recuperee, derniere maj 2018-12-13","user_need":"Ajouter production, recolte et stocks pour contextualiser les territoires viticoles","primary_kpis":"surface_production, recolte, stocks, declarations, stock_to_production_ratio","candidate_exports":"harvest_stock_pack, territory_supply_card","impact":"4","access_score":"3","granularity_score":"4","freshness_score":"2","effort_score":"3","confidence_score":"3","next_action":"Metadata et ressources XLS recuperees","caveat":"normaliser CSV puis verifier source DataDouane pour chiffres recents.","opportunity_score":31,"priority":"P2","primary_kpis_list":["surface_production","recolte","stocks","declarations","stock_to_production_ratio"],"candidate_exports_list":["harvest_stock_pack","territory_supply_card"],"copy_sentence":"Stocks et recoltes viti-vinicoles depuis 2009 : Ajouter production, recolte et stocks pour contextualiser les territoires viticoles. Action : Metadata et ressources XLS recuperees"},{"source_key":"bpe_tourism_transport","label":"Equipements tourisme et transport BPE","producer":"Insee / donnees territoriales","domain":"tourisme_territoire","official_url":"https://www.data.gouv.fr/datasets/les-equipements-dans-le-domaine-du-tourisme-et-du-transport-base-permanente-des-equipements-idf","access_mode":"csv_json_xls","granularity":"commune, type equipement tourisme/transport","refresh_signal":"Mis a jour en 2026 pour l'exemple IDF","user_need":"Mesurer l'accessibilite touristique autour des territoires viticoles","primary_kpis":"hotels, chambres, campings, emplacements, information_touristique","candidate_exports":"accessibility_context_card, tourism_equipment_pack","impact":"3","access_score":"3","granularity_score":"4","freshness_score":"3","effort_score":"3","confidence_score":"3","next_action":"Chercher la version nationale BPE ou documenter un usage regional temoin.","caveat":"La fiche identifie un jeu regional IDF, pas encore la version nationale complete.","opportunity_score":29,"priority":"P3","primary_kpis_list":["hotels","chambres","campings","emplacements","information_touristique"],"candidate_exports_list":["accessibility_context_card","tourism_equipment_pack"],"copy_sentence":"Equipements tourisme et transport BPE : Mesurer l'accessibilite touristique autour des territoires viticoles. Action : Chercher la version nationale BPE ou documenter un usage regional temoin."}],"copy_markdown":"# Source Opportunity Radar Winerix\n\nSources officielles a integrer ensuite pour renforcer les KPI vin, oenotourisme, economie et geocodage.\n\n## Synthese\n\n- Sources candidates : 10\n- P1 : 7\n- P2 : 2\n- P3/P4 : 1\n\n## Top picks\n\n- P1 score 48 - Capacites communales d'hebergement touristique : Importer le CSV 2026 telecharge puis croiser par communes INAO/DATAtourisme.\n- P1 score 45 - Aires et produits AOC/AOP et IGP : Comparer avec les imports INAO existants puis ajouter les IGP manquantes.\n- P1 score 44 - Base Adresse Nationale : Metadata BAN et etat commune recuperees\n- P1 score 42 - Etablissements vin via Sirene : Telecharger le stock etablissement, importer via sources/wine-naf-codes.csv, publier d'abord les agregats.\n- P1 score 40 - Geolocalisation des etablissements Sirene : Preparer une jointure SIRET avec le filtrage Sirene vin.\n\n## Board copiable\n\n| Priorite | Score | Source | Domaine | Producteur | KPI vises | Action | Caveat |\n|---|---:|---|---|---|---|---|---|\n| P1 | 48 | Capacites communales d'hebergement touristique | oenotourisme | Insee | hotels, chambres, campings, emplacements, autres_hebergements | Importer le CSV 2026 telecharge puis croiser par communes INAO/DATAtourisme. | La capacite touristique n'identifie pas directement les offres oenotouristiques. |\n| P1 | 45 | Aires et produits AOC/AOP et IGP | reglementaire_vin | INAO | area_product_count, igp_count, aoc_aop_count | Comparer avec les imports INAO existants puis ajouter les IGP manquantes. | Risque de doublon avec les sources INAO deja integrees : necessite une table de correspondance. |\n| P1 | 44 | Base Adresse Nationale | geocodage | Base Adresse Nationale / IGN | address_score, lon, lat, citycode, certified_address, geocoded_rate | Metadata BAN et etat commune recuperees | produire sources/ban-address-quality.csv depuis les lieux Winerix. |\n| P1 | 42 | Etablissements vin via Sirene | economie_vin | Insee | establishments_active, naf_code, commune, legal_unit | Telecharger le stock etablissement, importer via sources/wine-naf-codes.csv, publier d'abord les agregats. | Donnees personnelles et obligations RGPD a cadrer avant publication nominative. |\n| P1 | 40 | Geolocalisation des etablissements Sirene | geocodage | Insee | geocoded_siret, quality, iris, commune | Preparer une jointure SIRET avec le filtrage Sirene vin. | Le CSV sera arrete au profit du parquet dans le courant du second semestre 2027. |\n| P1 | 37 | Annuaire exploitations certifiees HVE | durabilite_vin | Ministere Agriculture | certified_estates, wine_related_estates, wine_related_rate, commune_count | CSV officiel recupere dans sources/hve-certified-estates.csv | rapprocher domaines Winerix/Sirene/BAN. |\n| P1 | 37 | Prix moyens vrac VSIG et IGP | economie_vin | FranceAgriMer | prix_moyen_hebdomadaire, campagne, categorie, couleur | Normaliser la ressource Visionet dans sources/franceagrimer-prices.csv puis lancer l'import bulk_prices. | Donnees France entiere et ressource source en HTML distant : pas de granularite appellation ou commune. |\n| P2 | 35 | Valeur venale des terres et vignes | foncier_viticole | Agreste / Ministere Agriculture | prix_moyen, prix_min, prix_max, evolution | Metadata officielle recuperee dans sources/agreste-vineyard-land-values-datagouv.json | normaliser ensuite le CSV prix vignes. |\n| P2 | 31 | Stocks et recoltes viti-vinicoles depuis 2009 | economie_vin | DGDDI / Ministeres economiques | surface_production, recolte, stocks, declarations, stock_to_production_ratio | Metadata et ressources XLS recuperees | normaliser CSV puis verifier source DataDouane pour chiffres recents. |\n| P3 | 29 | Equipements tourisme et transport BPE | tourisme_territoire | Insee / donnees territoriales | hotels, chambres, campings, emplacements, information_touristique | Chercher la version nationale BPE ou documenter un usage regional temoin. | La fiche identifie un jeu regional IDF, pas encore la version nationale complete. |\n"}