{ "ok": true, "generated_at": "2026-07-06T17:57:16+00:00", "summary": "Tableau d hydratation des scores Winerix : combine dependances KPI et Quality Gates pour savoir quels scores territoire peuvent etre calcules avec des donnees normalisees.", "hydration_summary": { "score_count": 7, "hydrated_ready_count": 0, "partially_hydratable_count": 6, "blocked_by_normalization_count": 1, "status_counts": { "partially_hydratable": 6, "blocked_by_normalization": 1 }, "next_ready_score": null, "top_blocked_score": "supply_market_context_score" }, "rows": [ { "score_key": "territory_reference_score", "score_label": "Territory Reference Score", "status": "partially_hydratable", "component_count": 3, "ready_component_count": 2, "partial_component_count": 0, "hydration_rate": 66.7, "components": [ { "component": "regulatory_proof", "status": "ready", "ready_output_count": 2, "output_count": 2, "sources": [ "inao_aoc_aop_communes", "inao_siqo_products", "eambrosia_gi" ], "outputs": [ { "output": "sources/inao-aoc-aop-communes.csv", "status": "available_unmanaged", "tracked_by_quality_gates": false, "ready": true, "next_action": "Raccorder ce fichier aux Quality Gates si le score depend fortement de lui." }, { "output": "sources/inao-siqo-products.csv", "status": "available_unmanaged", "tracked_by_quality_gates": false, "ready": true, "next_action": "Raccorder ce fichier aux Quality Gates si le score depend fortement de lui." } ], "gate": "Preuves INAO/eAmbrosia visibles et caveat juridique conserve.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." }, { "component": "source_fidelity", "status": "ready", "ready_output_count": 1, "output_count": 1, "sources": [ "reference_source_fidelity", "source_refresh_policy" ], "outputs": [ { "output": "sources/source-refresh-policy.csv", "status": "available_unmanaged", "tracked_by_quality_gates": false, "ready": true, "next_action": "Raccorder ce fichier aux Quality Gates si le score depend fortement de lui." } ], "gate": "Source Fidelity Ledger et politique de fraicheur disponibles.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." }, { "component": "vineyard_footprint", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "rpg_parcels", "agreste_viticulture_territorial" ], "outputs": [ { "output": "sources/rpg-vineyard-parcels.csv", "status": "not_tracked_or_missing", "tracked_by_quality_gates": false, "ready": false, "next_action": "Produire ou declarer ce fichier dans le runbook de normalisation." } ], "gate": "RPG vigne filtre et surface territoriale relue.", "next_action": "Produire les outputs de normalisation requis avant hydratation." } ], "next_action": "Hydrater les composants prets et afficher les autres comme pipeline." }, { "score_key": "oenotourism_readiness_score", "score_label": "Oenotourism Readiness Score", "status": "partially_hydratable", "component_count": 7, "ready_component_count": 1, "partial_component_count": 2, "hydration_rate": 14.3, "components": [ { "component": "wine_offer_density", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "datatourisme_oenotourism" ], "outputs": [ { "output": "sources/datatourisme-oenotourism.csv", "status": "not_tracked_or_missing", "tracked_by_quality_gates": false, "ready": false, "next_action": "Produire ou declarer ce fichier dans le runbook de normalisation." } ], "gate": "Offres vin filtrees et faux positifs controles.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "accommodation_capacity", "status": "partial", "ready_output_count": 1, "output_count": 2, "sources": [ "insee_tourism_capacity_communes", "atout_france_classified_accommodations" ], "outputs": [ { "output": "sources/insee-tourism-capacity-communes-2026.csv", "status": "not_tracked_or_missing", "tracked_by_quality_gates": false, "ready": false, "next_action": "Produire ou declarer ce fichier dans le runbook de normalisation." }, { "output": "sources/atout-france-classified-accommodations.csv", "status": "available_unmanaged", "tracked_by_quality_gates": false, "ready": true, "next_action": "Raccorder ce fichier aux Quality Gates si le score depend fortement de lui." } ], "gate": "Capacite communale presente et rattachee au territoire.", "next_action": "Completer les outputs manquants ou non QA avant publication." }, { "component": "tourism_demand_signal", "status": "blocked", "ready_output_count": 0, "output_count": 2, "sources": [ "insee_tourism_occupancy", "insee_tourism_capacity_communes" ], "outputs": [ { "output": "sources/insee-tourism-occupancy-normalized.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." }, { "output": "sources/insee-tourism-capacity-communes-2026.csv", "status": "not_tracked_or_missing", "tracked_by_quality_gates": false, "ready": false, "next_action": "Produire ou declarer ce fichier dans le runbook de normalisation." } ], "gate": "Frequentation Insee normalisee et interpretee comme demande touristique generale, pas frequentation vin.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "quality_reception_signal", "status": "partial", "ready_output_count": 1, "output_count": 2, "sources": [ "qualite_tourisme_establishments", "datatourisme_oenotourism", "vignobles_decouvertes" ], "outputs": [ { "output": "sources/qualite-tourisme-establishments-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." }, { "output": "sources/datatourisme-oenotourism.csv", "status": "not_tracked_or_missing", "tracked_by_quality_gates": false, "ready": false, "next_action": "Produire ou declarer ce fichier dans le runbook de normalisation." } ], "gate": "Qualite Tourisme normalise et rapproche avec offres vin ou communes viticoles avant publication forte.", "next_action": "Completer les outputs manquants ou non QA avant publication." }, { "component": "bike_access_signal", "status": "blocked", "ready_output_count": 0, "output_count": 2, "sources": [ "bnsc_bike_parking", "ban_address_reference" ], "outputs": [ { "output": "sources/bnsc-bike-parking-normalized.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." }, { "output": "sources/ban-address-quality.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "Stationnements cyclables normalises, agreges par commune et attribues OSM/ODbL.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "accessibility_signal", "status": "ready", "ready_output_count": 1, "output_count": 1, "sources": [ "tourisme_handicap_establishments" ], "outputs": [ { "output": "sources/tourisme-handicap-establishments.csv", "status": "available_unmanaged", "tracked_by_quality_gates": false, "ready": true, "next_action": "Raccorder ce fichier aux Quality Gates si le score depend fortement de lui." } ], "gate": "Label accessibilite actif et caveat conserve.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." }, { "component": "address_quality", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "ban_address_reference" ], "outputs": [ { "output": "sources/ban-address-quality.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "BAN Quality Gates au moins review/map_ready pour les lieux affiches.", "next_action": "Produire les outputs de normalisation requis avant hydratation." } ], "next_action": "Hydrater les composants prets et afficher les autres comme pipeline." }, { "score_key": "wine_business_density_score", "score_label": "Wine Business Density Score", "status": "partially_hydratable", "component_count": 3, "ready_component_count": 1, "partial_component_count": 1, "hydration_rate": 33.3, "components": [ { "component": "active_wine_establishment_density", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "sirene_wine_establishments" ], "outputs": [ { "output": "sources/sirene-wine-establishments-normalized.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "Sirene normalise, actifs filtres et publication en agregat par defaut.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "core_naf_share", "status": "partial", "ready_output_count": 1, "output_count": 2, "sources": [ "sirene_wine_establishments", "wine_naf_codes" ], "outputs": [ { "output": "sources/wine-naf-codes.csv", "status": "available_unmanaged", "tracked_by_quality_gates": false, "ready": true, "next_action": "Raccorder ce fichier aux Quality Gates si le score depend fortement de lui." }, { "output": "sources/sirene-wine-establishments-normalized.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "Codes NAF coeur/adjacent relus avant score.", "next_action": "Completer les outputs manquants ou non QA avant publication." }, { "component": "sustainability_signal", "status": "ready", "ready_output_count": 2, "output_count": 2, "sources": [ "hve_certified_estates", "agencebio_organic_wine" ], "outputs": [ { "output": "sources/hve-certified-estates-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." }, { "output": "sources/agencebio-organic-wine-operators-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." } ], "gate": "HVE et Agence Bio normalises avec filtrage vin relu et publication en agregat.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." } ], "next_action": "Hydrater les composants prets et afficher les autres comme pipeline." }, { "score_key": "sustainable_wine_signal", "score_label": "Sustainable Wine Signal", "status": "partially_hydratable", "component_count": 4, "ready_component_count": 2, "partial_component_count": 1, "hydration_rate": 50, "components": [ { "component": "hve_wine_related_density", "status": "ready", "ready_output_count": 1, "output_count": 1, "sources": [ "hve_certified_estates" ], "outputs": [ { "output": "sources/hve-certified-estates-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." } ], "gate": "Annuaire HVE volontaire et signal vin textuel visibles dans le caveat.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." }, { "component": "organic_wine_operator_density", "status": "partial", "ready_output_count": 1, "output_count": 2, "sources": [ "agencebio_organic_wine" ], "outputs": [ { "output": "sources/agencebio-organic-wine-operators-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." }, { "output": "sources/agencebio-organic-viticulture-surfaces-normalized.csv", "status": "missing_publication_columns", "tracked_by_quality_gates": true, "ready": false, "next_action": "Ajouter source_key et caveat avant import/publication." } ], "gate": "Operateurs bio vin et surfaces VI normalises puis publies en agregat territoire.", "next_action": "Completer les outputs manquants ou non QA avant publication." }, { "component": "siqo_product_signal", "status": "ready", "ready_output_count": 1, "output_count": 1, "sources": [ "inao_siqo_products" ], "outputs": [ { "output": "sources/inao-siqo-products.csv", "status": "available_unmanaged", "tracked_by_quality_gates": false, "ready": true, "next_action": "Raccorder ce fichier aux Quality Gates si le score depend fortement de lui." } ], "gate": "Produits SIQO vin filtres et statuts controles.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." }, { "component": "vineyard_surface_context", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "rpg_parcels", "agreste_viticulture_territorial" ], "outputs": [ { "output": "sources/rpg-vineyard-parcels.csv", "status": "not_tracked_or_missing", "tracked_by_quality_gates": false, "ready": false, "next_action": "Produire ou declarer ce fichier dans le runbook de normalisation." } ], "gate": "Surface viticole rattachee au bon perimetre.", "next_action": "Produire les outputs de normalisation requis avant hydratation." } ], "next_action": "Hydrater les composants prets et afficher les autres comme pipeline." }, { "score_key": "organic_wine_sustainability_score", "score_label": "Organic Wine Sustainability Score", "status": "partially_hydratable", "component_count": 4, "ready_component_count": 2, "partial_component_count": 1, "hydration_rate": 50, "components": [ { "component": "organic_operator_density", "status": "ready", "ready_output_count": 1, "output_count": 1, "sources": [ "agencebio_organic_wine" ], "outputs": [ { "output": "sources/agencebio-organic-wine-operators-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." } ], "gate": "Operateurs bio lies au vin normalises et agreges par territoire.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." }, { "component": "organic_viticulture_surface_context", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "agencebio_organic_wine" ], "outputs": [ { "output": "sources/agencebio-organic-viticulture-surfaces-normalized.csv", "status": "missing_publication_columns", "tracked_by_quality_gates": true, "ready": false, "next_action": "Ajouter source_key et caveat avant import/publication." } ], "gate": "Surfaces bio viticoles communales filtrees code_groupe=VI et agregees au bon territoire.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "certifier_diversity_signal", "status": "ready", "ready_output_count": 1, "output_count": 1, "sources": [ "agencebio_organic_wine" ], "outputs": [ { "output": "sources/agencebio-organic-wine-operators-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." } ], "gate": "Certificateurs presents et relus avant comparaison territoriale.", "next_action": "Composant hydratable ; passer au calcul et a la revue metier." }, { "component": "hve_complement_signal", "status": "partial", "ready_output_count": 2, "output_count": 3, "sources": [ "hve_certified_estates", "agencebio_organic_wine" ], "outputs": [ { "output": "sources/hve-certified-estates-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." }, { "output": "sources/agencebio-organic-wine-operators-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." }, { "output": "sources/agencebio-organic-viticulture-surfaces-normalized.csv", "status": "missing_publication_columns", "tracked_by_quality_gates": true, "ready": false, "next_action": "Ajouter source_key et caveat avant import/publication." } ], "gate": "Ne pas confondre Bio et HVE ; afficher deux badges source distincts et agreger les surfaces VI.", "next_action": "Completer les outputs manquants ou non QA avant publication." } ], "next_action": "Hydrater les composants prets et afficher les autres comme pipeline." }, { "score_key": "supply_market_context_score", "score_label": "Supply & Market Context Score", "status": "blocked_by_normalization", "component_count": 3, "ready_component_count": 0, "partial_component_count": 0, "hydration_rate": 0, "components": [ { "component": "production_context", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "dgddi_vitivinicole_stocks_harvests" ], "outputs": [ { "output": "sources/dgddi-vitivinicole-stocks-harvests.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "DGDDI normalise et caveat DataDouane visible.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "land_value_context", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "agreste_vineyard_land_values" ], "outputs": [ { "output": "sources/agreste-vineyard-land-values.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "Prix vignes EUR/ha relus, caveat SAFER conserve.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "bulk_price_context", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "franceagrimer_bulk_prices" ], "outputs": [ { "output": "sources/franceagrimer-prices.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "FranceAgriMer normalise comme contexte marche, pas prix local.", "next_action": "Produire les outputs de normalisation requis avant hydratation." } ], "next_action": "Executer les normalisations sources requises avant hydratation." }, { "score_key": "map_publication_readiness", "score_label": "Map Publication Readiness", "status": "partially_hydratable", "component_count": 3, "ready_component_count": 0, "partial_component_count": 1, "hydration_rate": 0, "components": [ { "component": "geocoded_rate", "status": "blocked", "ready_output_count": 0, "output_count": 1, "sources": [ "ban_address_reference" ], "outputs": [ { "output": "sources/ban-address-quality.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "Coordonnees presentes et statut map_ready/review explicite.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "source_type_clarity", "status": "blocked", "ready_output_count": 0, "output_count": 2, "sources": [ "datatourisme_oenotourism", "sirene_wine_establishments", "atout_france_classified_accommodations" ], "outputs": [ { "output": "sources/datatourisme-oenotourism.csv", "status": "not_tracked_or_missing", "tracked_by_quality_gates": false, "ready": false, "next_action": "Produire ou declarer ce fichier dans le runbook de normalisation." }, { "output": "sources/sirene-wine-establishments-normalized.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." } ], "gate": "Famille de lieu explicite avant affichage public.", "next_action": "Produire les outputs de normalisation requis avant hydratation." }, { "component": "privacy_gate", "status": "partial", "ready_output_count": 1, "output_count": 2, "sources": [ "sirene_wine_establishments", "hve_certified_estates" ], "outputs": [ { "output": "sources/sirene-wine-establishments-normalized.csv", "status": "missing_output", "tracked_by_quality_gates": true, "ready": false, "next_action": "Executer la normalisation pour produire le CSV cible." }, { "output": "sources/hve-certified-estates-normalized.csv", "status": "qa_ready", "tracked_by_quality_gates": true, "ready": true, "next_action": "Passer a la revue metier puis import ou hydratation KPI." } ], "gate": "Agregats avant nominatif et revue RGPD/metier.", "next_action": "Completer les outputs manquants ou non QA avant publication." } ], "next_action": "Hydrater les composants prets et afficher les autres comme pipeline." } ], "copy_markdown": "# Reference Score Hydration Board\n\nTableau d hydratation des scores Winerix : combine dependances KPI et Quality Gates pour savoir quels scores territoire peuvent etre calcules avec des donnees normalisees.\n\n## Synthese\n- Scores : 7\n- Hydratables : 0\n- Partiels : 6\n- Bloques normalisation : 1\n- Prochain score pret : n/a\n- Premier score bloque : supply_market_context_score\n\n## Scores\n\n### Territory Reference Score\n- Statut : `partially_hydratable`\n- Hydratation : 66.7 %\n- Composants prets : 2 / 3\n- Prochaine action : Hydrater les composants prets et afficher les autres comme pipeline.\n- `regulatory_proof` : ready (2/2 outputs)\n- `source_fidelity` : ready (1/1 outputs)\n- `vineyard_footprint` : blocked (0/1 outputs)\n\n### Oenotourism Readiness Score\n- Statut : `partially_hydratable`\n- Hydratation : 14.3 %\n- Composants prets : 1 / 7\n- Prochaine action : Hydrater les composants prets et afficher les autres comme pipeline.\n- `wine_offer_density` : blocked (0/1 outputs)\n- `accommodation_capacity` : partial (1/2 outputs)\n- `tourism_demand_signal` : blocked (0/2 outputs)\n- `quality_reception_signal` : partial (1/2 outputs)\n- `bike_access_signal` : blocked (0/2 outputs)\n- `accessibility_signal` : ready (1/1 outputs)\n- `address_quality` : blocked (0/1 outputs)\n\n### Wine Business Density Score\n- Statut : `partially_hydratable`\n- Hydratation : 33.3 %\n- Composants prets : 1 / 3\n- Prochaine action : Hydrater les composants prets et afficher les autres comme pipeline.\n- `active_wine_establishment_density` : blocked (0/1 outputs)\n- `core_naf_share` : partial (1/2 outputs)\n- `sustainability_signal` : ready (2/2 outputs)\n\n### Sustainable Wine Signal\n- Statut : `partially_hydratable`\n- Hydratation : 50 %\n- Composants prets : 2 / 4\n- Prochaine action : Hydrater les composants prets et afficher les autres comme pipeline.\n- `hve_wine_related_density` : ready (1/1 outputs)\n- `organic_wine_operator_density` : partial (1/2 outputs)\n- `siqo_product_signal` : ready (1/1 outputs)\n- `vineyard_surface_context` : blocked (0/1 outputs)\n\n### Organic Wine Sustainability Score\n- Statut : `partially_hydratable`\n- Hydratation : 50 %\n- Composants prets : 2 / 4\n- Prochaine action : Hydrater les composants prets et afficher les autres comme pipeline.\n- `organic_operator_density` : ready (1/1 outputs)\n- `organic_viticulture_surface_context` : blocked (0/1 outputs)\n- `certifier_diversity_signal` : ready (1/1 outputs)\n- `hve_complement_signal` : partial (2/3 outputs)\n\n### Supply & Market Context Score\n- Statut : `blocked_by_normalization`\n- Hydratation : 0 %\n- Composants prets : 0 / 3\n- Prochaine action : Executer les normalisations sources requises avant hydratation.\n- `production_context` : blocked (0/1 outputs)\n- `land_value_context` : blocked (0/1 outputs)\n- `bulk_price_context` : blocked (0/1 outputs)\n\n### Map Publication Readiness\n- Statut : `partially_hydratable`\n- Hydratation : 0 %\n- Composants prets : 0 / 3\n- Prochaine action : Hydrater les composants prets et afficher les autres comme pipeline.\n- `geocoded_rate` : blocked (0/1 outputs)\n- `source_type_clarity` : blocked (0/2 outputs)\n- `privacy_gate` : partial (1/2 outputs)\n" }