{"ok":true,"count":16,"summary":{"active":7,"candidate":10,"paused":0,"blocked":0},"health_summary":{"ok":1,"warning":14,"error":1,"unknown":0},"source_value_summary":{"avg_score":79,"industrialize":7,"connect_soon":9},"governance_summary":{"cite_with_attribution":5,"review_before_export":9,"internal_only":2,"blocked":0,"review_required":11,"risk_high":2,"risk_medium":9,"risk_low":5},"refresh_policy_summary":{"with_policy":8,"without_policy":8,"critical":7,"due":9,"watch":0,"ok":0},"filters":{"status":null,"category":null,"q":null,"sort":"registry","min_value":68,"value_label":null,"reuse_status":null,"due_level":null,"policy_family":null,"review_required":null,"has_refresh_policy":null,"limit":100},"results":[{"source_key":"local_wine_catalog","name":"Catalogue vins local","provider":"importData / référentiel LWIN local","category":"catalogue","status":"active","priority":10,"trust_score":"82.00","coverage_scope":"Vins, producteurs, régions, classifications, couleurs et millésimes disponibles localement.","refresh_frequency":"Batch interne via scripts/ingest_import_profiles.php","license_label":"À documenter","license_url":null,"source_url":null,"ingestion_script":"scripts/ingest_import_profiles.php","local_tables":["wine_catalog","estate_wine_links","estate_profiles"],"merge_keys":["lwin","post_id","producer_name","wine_name","region","sub_region"],"report_uses":["rapport château","rapport appellation","rapport millésime","rapport catalogue"],"quality_notes":"Très structurant pour Winerix, mais la provenance amont, la licence et les droits de réutilisation doivent être explicités avant diffusion large.","next_step":"Documenter la provenance exacte du catalogue et créer un score de complétude par domaine.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"Etat d'ingestion absent (state_key: local_wine_catalog)","data_freshness":"missing","local_row_count":290112,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:47","covered_tables":["wine_catalog","estate_wine_links","estate_profiles"],"source_value_score":85.7,"source_value_label":"à industrialiser","source_value_action":"Ajouter cette source aux rapports et surveiller sa fraîcheur.","source_value_dimensions":{"use_case":100,"trust":82,"priority":100,"status":100,"local_readiness":100,"health":60,"freshness":15,"governance":60},"governance":{"source_family":"internal_or_imported","reuse_status":"internal_only","attribution_required":true,"commercial_reuse":"blocked_until_clarified","redistribution_risk":"high","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : importData / référentiel LWIN local, Catalogue vins local, À documenter","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"internal_only","redistribution_risk":"high","review_required":true,"has_refresh_policy":true,"refresh_policy":{"source_family":"internal_or_imported","recommended_cadence":"monthly","stale_after_days":45,"critical_after_days":90,"evidence_required":"provenance amont, nombre lignes, date import","primary_action":"php scripts/ingest_import_profiles.php","fallback_action":"garder les chiffres comme signal Winerix interne"},"policy_source_family":"internal_or_imported","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":45,"critical_after_days":90,"evidence_required":"provenance amont, nombre lignes, date import","fallback_action":"garder les chiffres comme signal Winerix interne","due_level":"critical","due_reason":"donnée locale absente","age_days":0,"next_command":"php scripts/ingest_import_profiles.php"},{"source_key":"local_business_profiles","name":"Profils business domaines","provider":"import_business_details / source locale","category":"domaines","status":"active","priority":12,"trust_score":"76.00","coverage_scope":"Présence web, téléphone, avis, accessibilité, géolocalisation et signaux B2B des domaines.","refresh_frequency":"Batch interne via scripts/ingest_import_profiles.php","license_label":"À documenter","license_url":null,"source_url":null,"ingestion_script":"scripts/ingest_import_profiles.php","local_tables":["estate_profiles","estate_commune_links","estate_signal_scores"],"merge_keys":["post_id","business_id","google_place_id","insee_code","zipcode"],"report_uses":["rapport château","rapport œnotourisme","rapport prospection B2B"],"quality_notes":"Très utile pour les signaux opérationnels, mais les conditions de réutilisation de certains attributs doivent être clarifiées.","next_step":"Ajouter des indicateurs de fraîcheur et séparer les preuves observées des inférences de score.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"Etat d'ingestion absent (state_key: local_business_profiles)","data_freshness":"missing","local_row_count":67837,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:47","covered_tables":["estate_profiles","estate_commune_links","estate_signal_scores"],"source_value_score":83.6,"source_value_label":"à industrialiser","source_value_action":"Ajouter cette source aux rapports et surveiller sa fraîcheur.","source_value_dimensions":{"use_case":97,"trust":76,"priority":98,"status":100,"local_readiness":100,"health":60,"freshness":15,"governance":60},"governance":{"source_family":"internal_or_imported","reuse_status":"internal_only","attribution_required":true,"commercial_reuse":"blocked_until_clarified","redistribution_risk":"high","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : import_business_details / source locale, Profils business domaines, À documenter","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"internal_only","redistribution_risk":"high","review_required":true,"has_refresh_policy":true,"refresh_policy":{"source_family":"internal_or_imported","recommended_cadence":"monthly","stale_after_days":45,"critical_after_days":90,"evidence_required":"provenance, champs enrichis, date import","primary_action":"php scripts/ingest_import_profiles.php","fallback_action":"ne pas exposer les attributs non gouvernes"},"policy_source_family":"internal_or_imported","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":45,"critical_after_days":90,"evidence_required":"provenance, champs enrichis, date import","fallback_action":"ne pas exposer les attributs non gouvernes","due_level":"critical","due_reason":"donnée locale absente","age_days":0,"next_command":"php scripts/ingest_import_profiles.php"},{"source_key":"inao_denominations","name":"Dénominations viticoles INAO","provider":"INAO","category":"appellations","status":"active","priority":15,"trust_score":"93.00","coverage_scope":"Appellations, catégories, types IG et rattachements communaux issus de sources locales INAO.","refresh_frequency":"Manuel, à vérifier lors des mises à jour INAO.","license_label":"Open data public, à confirmer fichier par fichier","license_url":"https://www.data.gouv.fr/fr/licences","source_url":"sources/denominations.csv","ingestion_script":"scripts/seed_communes.php, scripts/seed_appellations.php","local_tables":["communes","appellations"],"merge_keys":["insee_code","appellation_name","id_app_inao","type_ig"],"report_uses":["rapport territoire","rapport appellation","rapport château","rapport opportunité"],"quality_notes":"Source pivot pour les croisements territoriaux ; attention aux communes fusionnées, déléguées ou renommées.","next_step":"Ajouter une date de millésime de source et un contrôle de dérive avec COMAGRI/eAmbrosia.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"Etat d'ingestion absent (state_key: inao_denominations)","data_freshness":"missing","local_row_count":28447,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:47","covered_tables":["communes","appellations"],"source_value_score":88.2,"source_value_label":"à industrialiser","source_value_action":"Ajouter cette source aux rapports et surveiller sa fraîcheur.","source_value_dimensions":{"use_case":100,"trust":93,"priority":95,"status":100,"local_readiness":100,"health":60,"freshness":15,"governance":75},"governance":{"source_family":"open_data_licence_ouverte","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : INAO, Dénominations viticoles INAO, Open data public, à confirmer fichier par fichier — sources/denominations.csv","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"quotidien","cadence_days":2,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"critical","due_reason":"donnée locale absente","age_days":0,"next_command":"php scripts/seed_communes.php, scripts/seed_appellations.php"},{"source_key":"comagri_ao_2025","name":"COMAGRI aires AO 2025","provider":"INAO / Ministère de l’Agriculture","category":"appellations","status":"active","priority":18,"trust_score":"90.00","coverage_scope":"Aires géographiques et produits officiels filtrés sur les produits viticoles.","refresh_frequency":"Manuel lors des nouveaux fichiers COMAGRI.","license_label":"Open data public, à confirmer fichier par fichier","license_url":"https://www.data.gouv.fr/fr/licences","source_url":"sources/2025-03-10-comagri-aires-produits.csv + sources/2025-10-09-comagri-communes-aires-ao.csv","ingestion_script":"scripts/seed_comagri.php","local_tables":["appellations"],"merge_keys":["insee_code","appellation_name","id_app_inao"],"report_uses":["rapport appellation","rapport territoire","contrôle qualité INAO"],"quality_notes":"Bon complément officiel, avec encodage ISO-8859-1 traité au seed ; le filtrage par mots-clés vin doit rester contrôlé.","next_step":"Comparer les libellés avec denominations.csv et marquer les divergences par appellation.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"Etat d'ingestion absent (state_key: comagri_ao_2025)","data_freshness":"missing","local_row_count":21948,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:47","covered_tables":["appellations"],"source_value_score":87.2,"source_value_label":"à industrialiser","source_value_action":"Ajouter cette source aux rapports et surveiller sa fraîcheur.","source_value_dimensions":{"use_case":100,"trust":90,"priority":92,"status":100,"local_readiness":100,"health":60,"freshness":15,"governance":75},"governance":{"source_family":"open_data_licence_ouverte","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : INAO / Ministère de l’Agriculture, COMAGRI aires AO 2025, Open data public, à confirmer fichier par fichier — sources/2025-03-10-comagri-aires-produits.csv + sources/2025-10-09-comagri-communes-aires-ao.csv","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"semestriel","cadence_days":180,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"critical","due_reason":"donnée locale absente","age_days":0,"next_command":"php scripts/seed_comagri.php"},{"source_key":"agence_bio","name":"Professionnels engagés en bio","provider":"Agence Bio","category":"durabilité","status":"active","priority":20,"trust_score":"89.00","coverage_scope":"Opérateurs bio, SIRET, numéro bio, statut, certificat et date d’engagement.","refresh_frequency":"Batch paginé via API Agence Bio.","license_label":"Licence ouverte Etalab","license_url":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","source_url":"https://opendata.agencebio.org/api/gouv/operateurs/","ingestion_script":"scripts/ingest_bio.php","local_tables":["bio_certifications"],"merge_keys":["siret","insee_code","estate_name","numero_bio"],"report_uses":["rapport bio","rapport territoire","rapport sourcing durable"],"quality_notes":"Donnée publique solide, mais localisée au siège ou à l’adresse déclarée ; ne prouve pas toujours la parcelle viticole exacte.","next_step":"Ajouter un rapprochement SIRENE et distinguer producteurs viticoles, négociants et autres opérateurs.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"Etat d'ingestion absent (state_key: agence_bio)","data_freshness":"missing","local_row_count":7415,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:47","covered_tables":["bio_certifications"],"source_value_score":86.2,"source_value_label":"à industrialiser","source_value_action":"Ajouter cette source aux rapports et surveiller sa fraîcheur.","source_value_dimensions":{"use_case":93,"trust":89,"priority":90,"status":100,"local_readiness":100,"health":60,"freshness":15,"governance":90},"governance":{"source_family":"open_data_licence_ouverte","reuse_status":"cite_with_attribution","attribution_required":true,"commercial_reuse":"allowed_with_attribution","redistribution_risk":"low","review_required":false,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : Agence Bio, Professionnels engagés en bio, Licence ouverte Etalab — https://opendata.agencebio.org/api/gouv/operateurs/","warning":"Citation autorisée avec producteur, licence, URL et millésime/date de mise à jour."},"reuse_status":"cite_with_attribution","redistribution_risk":"low","review_required":false,"has_refresh_policy":true,"refresh_policy":{"source_family":"open_data_licence_ouverte","recommended_cadence":"monthly","stale_after_days":45,"critical_after_days":90,"evidence_required":"date API, numero bio, SIRET, statut certificat","primary_action":"php scripts/ingest_bio.php","fallback_action":"ne pas presenter comme preuve parcellaire"},"policy_source_family":"open_data_licence_ouverte","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":45,"critical_after_days":90,"evidence_required":"date API, numero bio, SIRET, statut certificat","fallback_action":"ne pas presenter comme preuve parcellaire","due_level":"critical","due_reason":"donnée locale absente","age_days":0,"next_command":"php scripts/ingest_bio.php"},{"source_key":"open_meteo_archive","name":"Historique météo Open-Meteo","provider":"Open-Meteo","category":"météo","status":"active","priority":22,"trust_score":"86.00","coverage_scope":"Températures, pluie, soleil, évapotranspiration, gel et chaleur par grille météo.","refresh_frequency":"Batch par grille et année via archive API.","license_label":"Voir conditions Open-Meteo","license_url":"https://open-meteo.com/en/license","source_url":"https://open-meteo.com/en/docs/historical-weather-api","ingestion_script":"scripts/ingest_climate_grid.php","local_tables":["climate_grid","climate_weekly"],"merge_keys":["grid_id","lat","lng","year","week_num"],"report_uses":["rapport millésime","rapport risque climatique","rapport territoire"],"quality_notes":"Excellent pour comparer les profils climatiques ; les résultats restent des réanalyses/grilles et non des mesures station domaine.","next_step":"Créer des normales 10 ans et anomalies par région/appellation.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"Etat d'ingestion absent (state_key: open_meteo_archive)","data_freshness":"missing","local_row_count":32839,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:47","covered_tables":["climate_grid","climate_weekly"],"source_value_score":84.9,"source_value_label":"à industrialiser","source_value_action":"Ajouter cette source aux rapports et surveiller sa fraîcheur.","source_value_dimensions":{"use_case":91,"trust":86,"priority":88,"status":100,"local_readiness":100,"health":60,"freshness":15,"governance":90},"governance":{"source_family":"third_party_api","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : Open-Meteo, Historique météo Open-Meteo, Voir conditions Open-Meteo — https://open-meteo.com/en/docs/historical-weather-api","warning":"Conserver conditions API, quota, licence et snapshot de requête."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"annuel","cadence_days":430,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"critical","due_reason":"donnée locale absente","age_days":0,"next_command":"php scripts/ingest_climate_grid.php"},{"source_key":"weather_reference_api","name":"API météo consolidée Winerix","provider":"meteo.sprb.fr","category":"météo","status":"active","priority":24,"trust_score":"80.00","coverage_scope":"Disponibilité, statistiques et tuiles cartographiques météo utilisées par le référentiel météo public.","refresh_frequency":"Lecture API avec cache fichier Winerix de 7 jours.","license_label":"À documenter","license_url":null,"source_url":"https://meteo.sprb.fr","ingestion_script":"app/includes/site_engine.php","local_tables":[],"merge_keys":["lat","lng","date","variable","source"],"report_uses":["rapport millésime","cartographie météo","comparaison territoire"],"quality_notes":"La donnée est pratique pour l’affichage ; il faut documenter les modèles sous-jacents avant citation analytique externe.","next_step":"Ajouter une page interne de statut API et figer les sources météo incluses dans chaque snapshot de rapport.","last_reviewed_on":"2026-07-03","health_status":"error","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:49","covered_tables":[],"source_value_score":74.6,"source_value_label":"à connecter vite","source_value_action":"Résoudre le blocage avant de publier les KPI associés.","source_value_dimensions":{"use_case":91,"trust":80,"priority":86,"status":100,"local_readiness":55,"health":10,"freshness":55,"governance":75},"governance":{"source_family":"third_party_api","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : meteo.sprb.fr, API météo consolidée Winerix, À documenter — https://meteo.sprb.fr","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"quotidien","cadence_days":2,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"critical","due_reason":"blocage ou erreur santé source","age_days":0,"next_command":"app/includes/site_engine.php"},{"source_key":"datatourisme","name":"DATAtourisme","provider":"ADN Tourisme","category":"œnotourisme","status":"candidate","priority":28,"trust_score":"84.00","coverage_scope":"Points d’intérêt touristiques, dégustations, caveaux, accueil groupe et capacités potentielles.","refresh_frequency":"À activer via compte diffuseur/API.","license_label":"Open data avec conditions diffuseur","license_url":"https://www.datatourisme.fr/utiliser-les-donnees/","source_url":"https://www.datatourisme.fr/utiliser-les-donnees/","ingestion_script":"scripts/ingest_datatourisme.php","local_tables":["b2b_logistics"],"merge_keys":["datatourisme_id","insee_code","estate_name","zipcode"],"report_uses":["rapport œnotourisme","score B2B logistique","rapport territoire"],"quality_notes":"Très aligné avec la promesse Winerix, mais nécessite configuration du flux et contrôle de couverture locale.","next_step":"Obtenir/paramétrer l’accès diffuseur puis remplacer le script prototype par une ingestion paginée réelle.","last_reviewed_on":"2026-07-03","health_status":"ok","health_message":"Table sans lignes: b2b_logistics | Aucune ligne locale","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:49","covered_tables":["b2b_logistics"],"source_value_score":85.2,"source_value_label":"à industrialiser","source_value_action":"Lancer un premier import d’échantillon puis évaluer la couverture.","source_value_dimensions":{"use_case":99,"trust":84,"priority":82,"status":68,"local_readiness":85,"health":100,"freshness":55,"governance":90},"governance":{"source_family":"institutional_publication","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : ADN Tourisme, DATAtourisme, Open data avec conditions diffuseur — https://www.datatourisme.fr/utiliser-les-donnees/","warning":"Contrôler les conditions de réutilisation avant export commercial automatisé."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"trimestriel","cadence_days":90,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"php scripts/ingest_datatourisme.php"},{"source_key":"sirene_insee","name":"Base Sirene","provider":"INSEE","category":"entreprises","status":"candidate","priority":30,"trust_score":"95.00","coverage_scope":"Identité légale des entreprises et établissements : SIREN, SIRET, activité, adresse, état administratif.","refresh_frequency":"API ou fichier stock mensuel.","license_label":"Licence ouverte Etalab","license_url":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","source_url":"https://www.data.gouv.fr/dataservices/api-sirene-open-data","ingestion_script":null,"local_tables":[],"merge_keys":["siret","siren","raison_sociale","code_naf","zipcode","insee_code"],"report_uses":["fiabilisation domaines","rapport prospection","contrôle bio","scoring activité"],"quality_notes":"Référence légale incontournable pour solidifier les domaines et rapprocher Bio/DATAtourisme/business profiles.","next_step":"Créer un enrichissement SIRET/SIREN par domaine et par opérateur bio.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:50","covered_tables":[],"source_value_score":76.7,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":98,"trust":95,"priority":80,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":90},"governance":{"source_family":"open_data_licence_ouverte","reuse_status":"cite_with_attribution","attribution_required":true,"commercial_reuse":"allowed_with_attribution","redistribution_risk":"low","review_required":false,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : INSEE, Base Sirene, Licence ouverte Etalab — https://www.data.gouv.fr/dataservices/api-sirene-open-data","warning":"Citation autorisée avec producteur, licence, URL et millésime/date de mise à jour."},"reuse_status":"cite_with_attribution","redistribution_risk":"low","review_required":false,"has_refresh_policy":true,"refresh_policy":{"source_family":"open_data_licence_ouverte","recommended_cadence":"monthly","stale_after_days":45,"critical_after_days":90,"evidence_required":"SIREN/SIRET, date unite legale, adresse","primary_action":"php scripts/ingest_sirene_insee.php","fallback_action":"laisser les rattachements entreprise en revue"},"policy_source_family":"open_data_licence_ouverte","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":45,"critical_after_days":90,"evidence_required":"SIREN/SIRET, date unite legale, adresse","fallback_action":"laisser les rattachements entreprise en revue","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"php scripts/ingest_sirene_insee.php"},{"source_key":"ban_ign_geocoding","name":"Géocodage BAN / IGN","provider":"IGN / Base Adresse Nationale","category":"géographie","status":"candidate","priority":32,"trust_score":"90.00","coverage_scope":"Normalisation et géocodage des adresses, lieux-dits et coordonnées.","refresh_frequency":"À la demande lors des enrichissements adresse.","license_label":"Open data public, selon service IGN/BAN","license_url":"https://adresse.data.gouv.fr","source_url":"https://geoservices.ign.fr/documentation/services/services-geoplateforme/geocodage","ingestion_script":null,"local_tables":[],"merge_keys":["full_address","zipcode","city","insee_code","latitude","longitude"],"report_uses":["fiabilisation géographique","distance œnotourisme","cartographie"],"quality_notes":"Indispensable pour réduire les faux rattachements commune/domaine et fiabiliser les distances.","next_step":"Créer une file de géocodage pour les domaines sans coordonnées fiables ou matches faibles.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:50","covered_tables":[],"source_value_score":73.9,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":91,"trust":90,"priority":78,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":90},"governance":{"source_family":"open_data_licence_ouverte","reuse_status":"cite_with_attribution","attribution_required":true,"commercial_reuse":"allowed_with_attribution","redistribution_risk":"low","review_required":false,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : IGN / Base Adresse Nationale, Géocodage BAN / IGN, Open data public, selon service IGN/BAN — https://geoservices.ign.fr/documentation/services/services-geoplateforme/geocodage","warning":"Citation autorisée avec producteur, licence, URL et millésime/date de mise à jour."},"reuse_status":"cite_with_attribution","redistribution_risk":"low","review_required":false,"has_refresh_policy":true,"refresh_policy":{"source_family":"third_party_api","recommended_cadence":"monthly","stale_after_days":45,"critical_after_days":90,"evidence_required":"adresse normalisee, score geocodage, source BAN","primary_action":"php scripts/ingest_ban_geocode.php","fallback_action":"masquer les distances/cartes si geocodage faible"},"policy_source_family":"third_party_api","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":45,"critical_after_days":90,"evidence_required":"adresse normalisee, score geocodage, source BAN","fallback_action":"masquer les distances/cartes si geocodage faible","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"php scripts/ingest_ban_geocode.php"},{"source_key":"douanes_trade","name":"Commerce extérieur des vins","provider":"Douanes françaises / data.gouv.fr","category":"économie","status":"candidate","priority":35,"trust_score":"92.00","coverage_scope":"Flux export/import par produit, pays, période, valeur et volume.","refresh_frequency":"Mensuel ou selon publication Douanes.","license_label":"Licence ouverte Etalab","license_url":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","source_url":"https://www.data.gouv.fr/datasets/statistiques-nationales-du-commerce-exterieur","ingestion_script":null,"local_tables":[],"merge_keys":["period","country","product_code","flow","value_eur","volume"],"report_uses":["rapport export","opportunité pays","benchmark macro"],"quality_notes":"Source publique forte, mais il faut mapper proprement les nomenclatures produits vers styles/appellations Winerix.","next_step":"Définir les codes douaniers vin à suivre et créer une table mensuelle agrégée.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:51","covered_tables":[],"source_value_score":75.3,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":97,"trust":92,"priority":75,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":90},"governance":{"source_family":"open_data_licence_ouverte","reuse_status":"cite_with_attribution","attribution_required":true,"commercial_reuse":"allowed_with_attribution","redistribution_risk":"low","review_required":false,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : Douanes françaises / data.gouv.fr, Commerce extérieur des vins, Licence ouverte Etalab — https://www.data.gouv.fr/datasets/statistiques-nationales-du-commerce-exterieur","warning":"Citation autorisée avec producteur, licence, URL et millésime/date de mise à jour."},"reuse_status":"cite_with_attribution","redistribution_risk":"low","review_required":false,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"Définir une procédure d’import avant industrialisation."},{"source_key":"franceagrimer_vitivinicole","name":"Conjoncture viti-vinicole","provider":"FranceAgriMer","category":"économie","status":"candidate","priority":38,"trust_score":"88.00","coverage_scope":"Prix, consommation, échanges et indicateurs de marché français.","refresh_frequency":"Mensuel, hors périodes sans publication.","license_label":"À confirmer selon publication","license_url":null,"source_url":"https://www.franceagrimer.fr/chiffre-et-analyses-economiques/note-de-conjoncture-mensuelle-sur-la-filiere-viti-vinicole","ingestion_script":null,"local_tables":[],"merge_keys":["period","segment","price","volume","market_channel"],"report_uses":["rapport marché France","rapport prix","brief exécutif"],"quality_notes":"Très utile pour contextualiser les signaux locaux, mais souvent publié en notes/PDF à parser avec prudence.","next_step":"Commencer par une extraction semi-manuelle des séries clés avant automatisation.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:51","covered_tables":[],"source_value_score":73.2,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":97,"trust":88,"priority":72,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":75},"governance":{"source_family":"institutional_publication","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : FranceAgriMer, Conjoncture viti-vinicole, À confirmer selon publication — https://www.franceagrimer.fr/chiffre-et-analyses-economiques/note-de-conjoncture-mensuelle-sur-la-filiere-viti-vinicole","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"Définir une procédure d’import avant industrialisation."},{"source_key":"oiv_world_wine_sector","name":"State of the World Wine Sector","provider":"OIV","category":"macro","status":"candidate","priority":40,"trust_score":"95.00","coverage_scope":"Surface viticole, production, consommation et commerce international du vin.","refresh_frequency":"Annuel.","license_label":"Publication OIV, droits à vérifier pour réutilisation détaillée","license_url":null,"source_url":"https://www.oiv.int/what-we-do/statistics","ingestion_script":null,"local_tables":[],"merge_keys":["year","country","indicator","value","unit"],"report_uses":["rapport macro","benchmark pays","contexte marché"],"quality_notes":"Référence mondiale ; parfait pour cadrer les rapports, moins granulaire pour les décisions locales.","next_step":"Créer une table d’indicateurs macro pays/année et importer les chiffres clés 2025.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:51","covered_tables":[],"source_value_score":73.5,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":89,"trust":95,"priority":70,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":90},"governance":{"source_family":"institutional_publication","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : OIV, State of the World Wine Sector, Publication OIV, droits à vérifier pour réutilisation détaillée — https://www.oiv.int/what-we-do/statistics","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":true,"refresh_policy":{"source_family":"institutional_publication","recommended_cadence":"annual","stale_after_days":400,"critical_after_days":760,"evidence_required":"rapport OIV, annee, indicateur, unite","primary_action":"php scripts/ingest_macro_indicators.php kind=macro_wine file=sources/oiv.csv source_key=oiv_world_wine_sector","fallback_action":"conserver uniquement comme contexte historique"},"policy_source_family":"institutional_publication","recommended_cadence":"annuel","cadence_days":400,"stale_after_days":400,"critical_after_days":760,"evidence_required":"rapport OIV, annee, indicateur, unite","fallback_action":"conserver uniquement comme contexte historique","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"php scripts/ingest_macro_indicators.php kind=macro_wine file=sources/oiv.csv source_key=oiv_world_wine_sector"},{"source_key":"eu_agridata_wine","name":"EU Agri-food Data Portal - Wine","provider":"Commission européenne","category":"macro","status":"candidate","priority":42,"trust_score":"90.00","coverage_scope":"Production, stocks, surfaces, disponibilités et catégories qualité au niveau UE/États membres.","refresh_frequency":"Selon publication européenne.","license_label":"Données Commission européenne, conditions à vérifier","license_url":null,"source_url":"https://agridata.ec.europa.eu/extensions/DataPortal/wine.html","ingestion_script":null,"local_tables":[],"merge_keys":["marketing_year","member_state","wine_type","colour","indicator"],"report_uses":["rapport Europe","benchmark production","rapport stock/disponibilité"],"quality_notes":"Très bon complément macro européen ; nécessite normalisation des campagnes viticoles.","next_step":"Lister les séries API disponibles et choisir les 5 indicateurs utiles aux rapports Winerix.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:51","covered_tables":[],"source_value_score":72.3,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":89,"trust":90,"priority":68,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":90},"governance":{"source_family":"institutional_publication","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : Commission européenne, EU Agri-food Data Portal - Wine, Données Commission européenne, conditions à vérifier — https://agridata.ec.europa.eu/extensions/DataPortal/wine.html","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":false,"refresh_policy":null,"policy_source_family":"","recommended_cadence":"trimestriel","cadence_days":90,"stale_after_days":null,"critical_after_days":null,"evidence_required":"","fallback_action":"","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"Définir une procédure d’import avant industrialisation."},{"source_key":"eambrosia_gi","name":"eAmbrosia GI Register","provider":"Commission européenne","category":"appellations","status":"candidate","priority":45,"trust_score":"92.00","coverage_scope":"Registre légal européen des indications géographiques et liens vers cahiers des charges.","refresh_frequency":"À surveiller lors des changements réglementaires.","license_label":"Registre public UE, conditions à vérifier","license_url":null,"source_url":"https://ec.europa.eu/agriculture/eambrosia/geographical-indications-register/","ingestion_script":null,"local_tables":[],"merge_keys":["gi_name","country","status","product_category","specification_url"],"report_uses":["rapport appellation","preuve réglementaire","cahiers des charges"],"quality_notes":"Source juridique majeure pour les rapports appellation ; l’automatisation peut demander un connecteur spécifique.","next_step":"Tester l’extraction des fiches GI françaises et stocker les liens de cahier des charges.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:51","covered_tables":[],"source_value_score":74.8,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":100,"trust":92,"priority":65,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":90},"governance":{"source_family":"institutional_publication","reuse_status":"review_before_export","attribution_required":true,"commercial_reuse":"review","redistribution_risk":"medium","review_required":true,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : Commission européenne, eAmbrosia GI Register, Registre public UE, conditions à vérifier — https://ec.europa.eu/agriculture/eambrosia/geographical-indications-register/","warning":"Licence incomplète ou à confirmer : revue requise avant publication forte."},"reuse_status":"review_before_export","redistribution_risk":"medium","review_required":true,"has_refresh_policy":true,"refresh_policy":{"source_family":"institutional_publication","recommended_cadence":"monthly","stale_after_days":45,"critical_after_days":90,"evidence_required":"snapshot registre, statut GI, URL cahier des charges","primary_action":"php scripts/ingest_eambrosia_gi.php file=sources/eambrosia-gi.csv","fallback_action":"exporter la file de revue via api/reference_export.php?type=appellation_regulatory_gaps"},"policy_source_family":"institutional_publication","recommended_cadence":"mensuel","cadence_days":45,"stale_after_days":45,"critical_after_days":90,"evidence_required":"snapshot registre, statut GI, URL cahier des charges","fallback_action":"exporter la file de revue via api/reference_export.php?type=appellation_regulatory_gaps","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"php scripts/ingest_eambrosia_gi.php file=sources/eambrosia-gi.csv"},{"source_key":"rpg_parcels","name":"Registre parcellaire graphique","provider":"ASP / data.gouv.fr","category":"foncier","status":"candidate","priority":55,"trust_score":"86.00","coverage_scope":"Parcelles agricoles déclarées PAC, cultures et surfaces.","refresh_frequency":"Annuel.","license_label":"Licence ouverte Etalab","license_url":"https://www.etalab.gouv.fr/licence-ouverte-open-licence","source_url":"https://www.data.gouv.fr/datasets/rpg","ingestion_script":null,"local_tables":[],"merge_keys":["year","insee_code","parcel_id","crop_code","surface_ha"],"report_uses":["rapport foncier","densité viticole","risque climatique parcellaire"],"quality_notes":"Très puissant mais volumineux ; demande une stratégie géospatiale avant ingestion.","next_step":"Faire un POC sur une région viticole limitée avant ingestion nationale.","last_reviewed_on":"2026-07-03","health_status":"warning","health_message":"HTTP request failed","data_freshness":"stale","local_row_count":0,"missing_tables":[],"last_checked_at":"2026-07-06 17:31:47","created_at":"2026-07-03 14:31:10","updated_at":"2026-07-06 17:31:51","covered_tables":[],"source_value_score":69.1,"source_value_label":"à connecter vite","source_value_action":"Définir un connecteur ou une procédure semi-manuelle d’import.","source_value_dimensions":{"use_case":85,"trust":86,"priority":55,"status":68,"local_readiness":35,"health":60,"freshness":55,"governance":90},"governance":{"source_family":"open_data_licence_ouverte","reuse_status":"cite_with_attribution","attribution_required":true,"commercial_reuse":"allowed_with_attribution","redistribution_risk":"low","review_required":false,"citation_requirements":["producer","source_name","license","source_url","source_year_or_observed_on","caveat"],"attribution_text":"Source : ASP / data.gouv.fr, Registre parcellaire graphique, Licence ouverte Etalab — https://www.data.gouv.fr/datasets/rpg","warning":"Citation autorisée avec producteur, licence, URL et millésime/date de mise à jour."},"reuse_status":"cite_with_attribution","redistribution_risk":"low","review_required":false,"has_refresh_policy":true,"refresh_policy":{"source_family":"open_data_licence_ouverte","recommended_cadence":"annual","stale_after_days":400,"critical_after_days":760,"evidence_required":"metadata RPG data.gouv, referentiel cultures 2024, code culture vigne, WFS parcelles, puis surface ha uniquement apres import agrege","primary_action":"php scripts/fetch_rpg_vineyard_reference.php sources/rpg-dataset-metadata.json sources/rpg-cultures-2024.csv sources/rpg-vineyard-reference-fetch-summary.csv && php scripts/normalize_rpg_vineyard_reference.php sources/rpg-cultures-2024.csv sources/rpg-dataset-metadata.json sources/rpg-vineyard-culture-codes.csv sources/rpg-vineyard-reference-summary.csv && php scripts/build_reference_public_rpg_vineyard_activation_board.php sources/reference-public-rpg-vineyard-activation-board.csv sources/reference-public-rpg-vineyard-activation-board.html sources/reference-public-rpg-vineyard-activation-board.md sources/reference-public-rpg-vineyard-activation-board-summary.csv sources/rpg-vineyard-reference-summary.csv sources/rpg-vineyard-culture-codes.csv","fallback_action":"activation gardee: ne pas publier surface RPG, propriete domaine ou exhaustivite vigne sans import parcellaire, agregation territoriale et audit"},"policy_source_family":"open_data_licence_ouverte","recommended_cadence":"annuel","cadence_days":400,"stale_after_days":400,"critical_after_days":760,"evidence_required":"metadata RPG data.gouv, referentiel cultures 2024, code culture vigne, WFS parcelles, puis surface ha uniquement apres import agrege","fallback_action":"activation gardee: ne pas publier surface RPG, propriete domaine ou exhaustivite vigne sans import parcellaire, agregation territoriale et audit","due_level":"due","due_reason":"fraîcheur obsolète","age_days":0,"next_command":"php scripts/fetch_rpg_vineyard_reference.php sources/rpg-dataset-metadata.json sources/rpg-cultures-2024.csv sources/rpg-vineyard-reference-fetch-summary.csv && php scripts/normalize_rpg_vineyard_reference.php sources/rpg-cultures-2024.csv sources/rpg-dataset-metadata.json sources/rpg-vineyard-culture-codes.csv sources/rpg-vineyard-reference-summary.csv && php scripts/build_reference_public_rpg_vineyard_activation_board.php sources/reference-public-rpg-vineyard-activation-board.csv sources/reference-public-rpg-vineyard-activation-board.html sources/reference-public-rpg-vineyard-activation-board.md sources/reference-public-rpg-vineyard-activation-board-summary.csv sources/rpg-vineyard-reference-summary.csv sources/rpg-vineyard-culture-codes.csv"}]}