# Source-KPI Lineage Matrix Winerix Matrice de tracabilite source -> produits -> KPI -> exports -> caveats. ## Synthese - Sources reliees : 110 - Sources gouvernees : 90 - Sources catalogue uniquement : 20 - Produits couverts : 104 ## Table copiable | Source | Statut | Cadence | Produits | KPI slots | Action / caveat | |---|---|---|---|---|---| | reference_publication_gate | governed | daily | KPI Publication Certificates, Profile Publication Queue, User Need Navigator, Reference KPI Scorecard +13 | certificate_count, source_count, publication_status, badge_key, copy_receipt +68 | verifier api/get_reference_publication_gate.php?format=md | | reference_products | governed | weekly | Reference Copy Studio, User Need Navigator, Publishable Snippet Board, Reference KPI Scorecard +5 | persona, decision, metrics_to_pull, products, caveat +30 | verifier app/reference_product_catalog.php et /referentiels/produits | | datatourisme_oenotourism | governed | weekly | Reference Pack Winerix, Offre locale DATAtourisme, Oenotourism Demand Offer Pack, Insee Tourism Occupancy Pack +4 | reference_score, confidence_score, active_source_count, evidence_pack, offers +36 | php scripts/ingest_datatourisme_oenotourism.php file=sources/datatourisme-oenotourism-offers.csv min_relevance=55 | | reference_kpi_dictionary | governed | weekly | User Need Navigator, Publishable Snippet Board, Reference KPI Scorecard, Source-KPI Lineage Matrix +4 | route_count, persona, hero_kpis, product_keys, missing_product_count +28 | verifier api/get_reference_kpi_dictionary.php?format=md | | eambrosia_gi | governed | monthly | Reference Pack Winerix, Preuve réglementaire eAmbrosia, Produits SIQO INAO vin, Preuve appellation complète +2 | reference_score, confidence_score, active_source_count, evidence_pack, gi_count +23 | php scripts/ingest_eambrosia_gi.php file=sources/eambrosia-gi.csv | | insee_tourism_capacity_communes | governed | annual | Oenotourism Demand Offer Pack, Insee Tourism Occupancy Pack, Capacité touristique communale INSEE, Source Opportunity Radar +2 | pillar_count, source_count, score_recipe, copy_blocks, trust_badge_keys +25 | php scripts/ingest_insee_tourism_capacity_communes.php file=sources/insee-tourism-capacity-communes-2026.csv | | reference_kpi_scorecard | governed | weekly | Reference Dashboard Blueprint, Reference Narrative Deck, Reference Data Room Index, Reference Story Builder +2 | section_count, layout, kpi_slots, product_keys, visual_direction +22 | verifier api/get_reference_kpi_scorecard.php?format=md | | reference_source_fidelity | governed | weekly | Source Attribution Pack, Source Relationship Pack, Reference Normalization Runbook, Source Normalization Backlog +2 | source_count, license_count, odbl_source_count, attribution, publication_caveat +23 | verifier api/get_reference_source_fidelity.php?format=md | | reference_source_radar | governed | weekly | OpenAgenda Wine Event Signal, BNLC Carpooling Areas, Insee BPE Equipment, Merimee Heritage Monuments +2 | wine_event_signal, territory_activation_score, tourism_demand_context, wine_relevance_score, carpool_access_signal +19 | verifier api/get_reference_source_radar.php?format=md | | reference_territory_scorecard_public_bundle | governed | weekly | Source to Score Activation Queue, Activation Outputs Manifest, Territory KPI Score Table, Territory Pilot Profiles +2 | item_count, p1_count, normalize_next_count, publication_ready_count, output_count +7 | verifier api/get_reference_territory_scorecard_public_bundle.php?format=md | | inao_aoc_aop_commune_areas | governed | monthly | Reference Pack Winerix, Aires AOC/AOP INAO par commune, Produits SIQO INAO vin, Preuve appellation complète +1 | reference_score, confidence_score, active_source_count, evidence_pack, area_rows +19 | php scripts/ingest_inao_aoc_aop_communes.php file=sources/inao-aoc-aop-communes.csv | | kpi_pack | governed | weekly | Packs KPI par usage, Reference Copy Studio, Dictionnaire KPI Winerix, KPI Card Deck +1 | paste_ready, decision, next_action, persona, metrics_to_pull +13 | verifier app/kpi_pack.php et api/reference_export.php?type=kpi_pack | | reference_api_manifest | governed | weekly | Reference Launch Readiness, Reference Integration Guide, Reference Data Room Index, Reference Data Contracts +1 | check_count, required_count, recommended_count, artifact_available_count, artifact_missing_count +20 | verifier api/get_reference_api_manifest.php?format=md | | reference_claim_guard | governed | weekly | Territory Brief Composer, KPI Aggregation Rules, Source Attribution Pack, Public Footnote Pack +1 | score_count, source_count, badge_count, copy_blocks, source_stack +18 | verifier api/get_reference_claim_guard.php?format=md | | reference_territory_kpi_scorecard_pack | governed | weekly | Territory Scorecard Public Bundle, Source to Score Activation Queue, Activation Outputs Manifest, Territory Source Fact Table +1 | audience_count, block_count, package_count, checklist_count, scorecard_count +9 | verifier api/get_reference_territory_kpi_scorecards.php?format=md | | ban_address_reference | governed | weekly | BNSC Bike Parking Pack, Qualité adresse BAN, Source Opportunity Radar, Territory KPI Crosswalk | sampled_parkings, sample_commune_count, sample_capacity, sample_covered_count, sample_lit_count +16 | remplir sources/ban-address-quality-input.csv puis lancer scripts/normalize_ban_address_quality.php | | inao_siqo_products | governed | monthly | Reference Pack Winerix, Produits SIQO INAO vin, Preuve appellation complète, Reference Citation Kit | reference_score, confidence_score, active_source_count, evidence_pack, products +14 | php scripts/ingest_inao_siqo_products.php file=sources/inao-siqo-products.csv | | reference_citation_kit | governed | weekly | Source Attribution Pack, Reference Integration Guide, Reference Data Room Index, Reference Embed Kit | source_count, license_count, odbl_source_count, attribution, publication_caveat +15 | verifier api/get_reference_citation_kit.php?format=md | | reference_kpi_aggregation_rules | governed | weekly | KPI Publication Certificates, Territory Data Spine, User Need KPI Map, BNSC Bike Parking Pack | certificate_count, source_count, publication_status, badge_key, copy_receipt +13 | verifier api/get_reference_kpi_aggregation_rules.php?format=md | | reference_kpi_copy_pack | governed | weekly | Territory KPI Scorecards, Territory Scorecard Public Bundle, User Need KPI Map, Publishable Territory Page Pack | card_count, rule_count, layout_count, authority_source_count, spine_source_mapping_count +13 | verifier api/get_reference_kpi_copy_pack.php?format=md | | reference_live_kpi_board | governed | daily | Trust Badge Pack, Reference Claim Guard, Territory Share Pack, Territory Publication Bundle | badge_count, family, tone, html, copy_rule +11 | verifier api/get_reference_live_kpi_board.php?format=md | | reference_page_publication_kit | governed | weekly | Public Distribution Pack, User Feedback Pack, User Need KPI Map, Publishable Territory Page Pack | audience_count, bundle_count, page_kit_sections, source_relationship_count, copy_email +13 | verifier api/get_reference_page_publication_kit.php?format=md | | reference_public_footnotes | governed | weekly | Page Publication Kit, Public Distribution Pack, Territory Scorecard Public Bundle, KPI Copy Pack | section_count, checklist_count, certificate_count, footnote_count, copy_blocks +11 | verifier api/get_reference_public_footnotes.php?format=md | | reference_publishable_territory_page_pack | governed | weekly | Reference Authority Index, Territory KPI Scorecards, Territory Scorecard Public Bundle, Territory Pilot Profiles | source_count, average_authority_score, normalization_ready_count, copy_ready_count, pillar_count +12 | verifier api/get_reference_publishable_territory_page.php?format=md | | reference_source_relationships | governed | weekly | Public Distribution Pack, User Feedback Pack, Source Demand Backlog, Source Acquisition Sprint | audience_count, bundle_count, page_kit_sections, source_relationship_count, copy_email +12 | verifier api/get_reference_source_relationships.php?format=md | | reference_territory_kpi_formulas | governed | weekly | KPI Aggregation Rules, KPI Dependency Map, Territory Score Input Templates, Territory Score Calculator | territory_level_count, rule_count, recipe_count, territory_levels, rules +14 | verifier api/get_reference_territory_kpi_formulas.php?format=md | | reference_territory_page_kit | governed | weekly | Publishable Territory Page Pack, Territory Publication Bundle, Territory Score Calculator, Territory Reference Page | blueprint_count, section_count, cms_field_count, gate_count, copy_block_count +13 | verifier api/get_reference_territory_page_kit.php?format=md | | reference_trust_badges | governed | weekly | Territory Brief Composer, Territory Comparison Pack, KPI Publication Certificates, Agence Bio Organic Wine Pack | score_count, source_count, badge_count, copy_blocks, source_stack +13 | verifier api/get_reference_trust_badges.php?format=md | | reference_user_need_kpi_map | governed | weekly | Reference Source Radar, Reference Authority Index, Territory Data Spine, Publishable Territory Page Pack | candidate_count, p1_count, sample_now_count, fidelize_now_count, research_now_count +14 | verifier api/get_reference_user_need_kpi_map.php?format=md | | reference_visual_system | governed | weekly | Trust Badge Pack, Territory Page Kit, Reference Story Builder, Reference Embed Kit | badge_count, family, tone, html, copy_rule +15 | verifier api/get_reference_visual_system.php?format=md | | sirene_wine_establishments | governed | monthly | Agence Bio Organic Wine Pack, Source Opportunity Radar, Établissements vin SIRENE, Territory KPI Crosswalk | wine_related_operators, department_count, city_count, certifier_count, source_mode +15 | telecharger sources/sirene-stock-etablissements.csv puis lancer scripts/normalize_sirene_wine_establishments.php | | source_activation_status | governed | daily | Board maintenance sources, Reference Launch Readiness, Reference Release Notes, Publication Gate | publication_action, freshness_status, priority, copy_ticket, check_count +13 | verifier api/get_source_activation_status.php?format=md | | reference_authority_index | governed | weekly | Territory Data Spine, Territory KPI Scorecards, Source to Score Activation Queue | grain_count, source_mapping_count, aggregation_rule_count, output_table_count, card_count +8 | verifier api/get_reference_authority_index.php?format=md | | reference_dashboard_blueprint | governed | weekly | Reference Narrative Deck, Reference Launch Readiness, Reference Visual System | slide_count, kpi_slots, product_keys, speaker_note, caveat +10 | verifier api/get_reference_dashboard_blueprint.php?format=md | | reference_kpi_dependency_map | governed | weekly | Source Demand Backlog, Territory Publication Bundle, Score Hydration Board | item_count, research_now_count, source_demand_score, recommended_status, target_kpis +9 | verifier api/get_reference_kpi_dependency_map.php?format=md | | reference_kpi_publication_certificates | governed | weekly | Public Footnote Pack, Page Publication Kit, KPI Copy Pack | footnote_count, template_count, license_counts, short_footnote, full_footnote +7 | verifier api/get_reference_kpi_publication_certificates.php?format=md | | reference_normalization_runbook | governed | weekly | KPI Dependency Map, Normalization Quality Gates, Reference Normalization Readiness | score_count, component_dependency_count, unique_source_count, normalization_output_count, qa_ready_count +8 | verifier api/get_reference_normalization_runbook.php?format=md | | reference_publishable_snippets | governed | weekly | Reference Dashboard Blueprint, Reference Narrative Deck, Reference Visual System | section_count, layout, kpi_slots, product_keys, visual_direction +8 | verifier api/get_reference_publishable_snippets.php?format=md | | reference_source_attributions | governed | weekly | Public Footnote Pack, Source Relationship Pack, KPI Copy Pack | footnote_count, template_count, license_counts, short_footnote, full_footnote +9 | verifier api/get_reference_source_attributions.php?format=md | | reference_source_demand_backlog | governed | weekly | Source Acquisition Sprint, Reference Source Radar, KPI Copy Pack | phase_count, item_count, research_now_count, acceptance_gate_count, message_templates +7 | verifier api/get_reference_source_demand_backlog.php?format=md | | reference_source_lineage | governed | weekly | Reference API Manifest, Reference Launch Readiness, Reference Data Room Index | product_count, publish_count, complete_count, watch_count, endpoint_count +10 | verifier api/get_reference_source_lineage.php?format=md | | reference_territory_data_spine | governed | weekly | Territory KPI Scorecards, Source to Score Activation Queue, Territory Source Fact Table | card_count, rule_count, layout_count, authority_source_count, spine_source_mapping_count +7 | verifier api/get_reference_territory_data_spine.php?format=md | | reference_territory_kpi_crosswalk | governed | weekly | Territory KPI Formula Book, Territory Reference Page, Territory Page Kit | metric_count, normalization_rule_count, formula, weights, minimum_gate +9 | verifier api/get_reference_territory_kpi_crosswalk.php?format=md | | reference_territory_score_calculator | governed | weekly | Live KPI Board, Score Hydration Board, Territory Score Input Templates | live_count, partial_count, demo_count, blocked_count, display_mode +9 | verifier api/get_reference_territory_scores.php?format=md | | agreste_viticulture_territorial | governed | annual | Reference Pack Winerix, Cadrage Agreste viticulture | reference_score, confidence_score, active_source_count, evidence_pack, surface_vigne +2 | php scripts/ingest_macro_indicators.php kind=macro_wine file=sources/agreste-viticulture-territorial.csv source_key=agreste_viticulture_territorial | | atout_france_classified_accommodations | governed | monthly | Reference Pack Winerix, Hébergements touristiques classés | reference_score, confidence_score, active_source_count, evidence_pack, establishments +4 | php scripts/ingest_classified_accommodations.php file=sources/atout-france-classified-accommodations.csv | | hve_certified_estates | governed | annual | Exploitations certifiées HVE, Territory KPI Crosswalk | certified_estates, wine_related_estates, wine_related_rate, region_count, department_count +6 | lancer scripts/normalize_hve_certified_estates.php puis rapprocher domaines Winerix/Sirene/BAN | | insee_tourism_occupancy | governed | monthly | Oenotourism Demand Offer Pack, Insee Tourism Occupancy Pack | pillar_count, source_count, score_recipe, copy_blocks, trust_badge_keys +5 | rafraichir sources/insee-tourism-occupancy.zip puis lancer scripts/normalize_insee_tourism_occupancy.php | | qualite_tourisme_establishments | governed | monthly | Oenotourism Demand Offer Pack, Qualite Tourisme Establishments Pack | pillar_count, source_count, score_recipe, copy_blocks, trust_badge_keys +5 | rafraichir sources/qualite-tourisme-establishments.csv puis lancer scripts/normalize_qualite_tourisme_establishments.php | | reference_embed_kit | governed | weekly | Territory Page Kit, Reference Story Builder | section_count, layout_count, kpi_slots, source_stack, html_snippet +5 | verifier api/get_reference_embed_kit.php?format=md | | reference_launch_readiness | governed | daily | Reference Data Room Index, Reference Release Notes | collection_count, unique_product_count, markdown_export_count, product_keys, copy_order +3 | verifier api/get_reference_launch_readiness.php?format=md | | reference_normalization_quality_gates | governed | daily | Score Hydration Board, KPI Dependency Map | hydrated_ready_count, partially_hydratable_count, blocked_by_normalization_count, hydration_rate, score_count +3 | verifier api/get_reference_normalization_quality_gates.php?format=md | | reference_oenotourism_demand_offer | governed | weekly | Territory Brief Composer, Territory Comparison Pack | score_count, source_count, badge_count, copy_blocks, source_stack +4 | verifier api/get_reference_oenotourism_demand_offer.php?format=md | | reference_publishable_territory_profiles | governed | weekly | Profile Publication Queue, Profile Proof Cards | schema_count, status_count, output_count | lancer scripts/build_reference_territory_label_registry.php puis scripts/build_reference_publishable_territory_profiles.php | | reference_source_acquisition_sprint | governed | weekly | Reference Source Radar, User Need KPI Map | candidate_count, p1_count, sample_now_count, fidelize_now_count, research_now_count +4 | verifier api/get_reference_source_acquisition_sprint.php?format=md | | reference_source_normalization_backlog | governed | weekly | Reference Normalization Readiness, Reference Normalization Runbook | ready_to_run_count, normalized_file_available_count, missing_input_count, next_ready_source, step_count +4 | verifier api/get_reference_source_normalization_backlog.php?format=md | | reference_territory_brief | governed | weekly | Territory Comparison Pack, Page Publication Kit | territory_count, axis_count, row_count, copy_blocks, badge_keys +4 | verifier api/get_reference_territory_brief.php?format=md | | reference_territory_comparison | governed | weekly | KPI Aggregation Rules, Page Publication Kit | territory_level_count, rule_count, recipe_count, territory_levels, rules +5 | verifier api/get_reference_territory_comparison.php?format=md | | reference_territory_kpi_score_table | governed | weekly | Territory Pilot Profiles, Publishable Territory Profiles | schema_count, output_count, rule_count | lancer scripts/build_reference_territory_kpi_scores.php puis verifier api/get_reference_territory_kpi_scores.php?format=md | | reference_territory_publication_bundle | governed | daily | Publishable Territory Page Pack, Territory Share Pack | blueprint_count, section_count, cms_field_count, gate_count, copy_block_count +5 | verifier api/get_reference_territory_publication_bundle.php?format=md | | reference_territory_source_fact_table | governed | weekly | Territory KPI Score Table, Profile Proof Cards | schema_count, input_count, output_count, scorecard_count, status_count | lancer scripts/build_reference_territory_source_facts.php puis verifier api/get_reference_territory_source_facts.php?format=md | | reference_user_feedback | governed | weekly | Source Demand Backlog, Source Acquisition Sprint | item_count, research_now_count, source_demand_score, recommended_status, target_kpis +3 | verifier api/get_reference_user_feedback.php?format=md | | reference_user_need_navigator | governed | weekly | Publishable Snippet Board, Reference Story Builder | snippet_count, kpi_slots, product_keys, clipboard_block, segment_count +4 | verifier api/get_reference_user_need_navigator.php?format=md | | rpg_parcels | governed | annual | Reference Pack Winerix, Parcelles viticoles RPG | reference_score, confidence_score, active_source_count, evidence_pack, parcels +3 | 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 | | source_opportunity_radar | governed | monthly | Source Normalization Backlog, Source Fidelity Ledger | item_count, top_priority_source, status_counts, target_file, publication_gain +5 | verifier api/get_source_opportunity_radar.php?format=md | | tourisme_handicap_establishments | governed | monthly | Reference Pack Winerix, Établissements Tourisme & Handicap | reference_score, confidence_score, active_source_count, evidence_pack, establishments +4 | rafraichir sources/tourisme-handicap-establishments.csv puis lancer scripts/normalize_tourisme_handicap_establishments.php | | agencebio_organic_wine | governed | daily | Agence Bio Organic Wine Pack | wine_related_operators, department_count, city_count, certifier_count, source_mode | rafraichir sources/agencebio-professionnels-bio.csv puis verifier api/get_agencebio_organic_wine.php?format=md | | agreste_vineyard_land_values | governed | annual | Foncier viticole Agreste | normalized_rows, vineyard_rows, territory_count, average_price_eur_ha, price_min_eur_ha +1 | remplir sources/agreste-vineyard-land-values-input.csv puis lancer scripts/normalize_agreste_vineyard_land_values.php | | atout_france_vignobles_decouvertes_destinations | governed | monthly | Destinations Vignobles & Découvertes | destinations, wine_regions | php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/vignobles-decouvertes-destinations-sample.csv | | bnlc_carpooling_areas | governed | monthly | BNLC Carpooling Areas | carpool_access_signal, low_carbon_access_score, access_signal | mettre a jour sources/bnlc-carpooling-areas.csv puis normaliser scripts/normalize_bnlc_carpooling_areas.php | | bnsc_bike_parking | governed | weekly | BNSC Bike Parking Pack | sampled_parkings, sample_commune_count, sample_capacity, sample_covered_count, sample_lit_count | rafraichir sources/bnsc-bike-parking.zip puis lancer scripts/normalize_bnsc_bike_parking.php | | datatourisme_fidelity_monitor | governed | daily | Reference Authority Index | source_count, average_authority_score, normalization_ready_count, copy_ready_count, pillar_count | mettre a jour sources/datatourisme-datagouv.json et sources/datatourisme-resource-snapshot.csv puis lancer scripts/monitor_datatourisme_freshness.php | | dgddi_vitivinicole_stocks_harvests | governed | annual | Récoltes et stocks vitivinicoles DGDDI | harvest_resource_count, stock_resource_count, surface_ha_total, production_hl_total, stock_hl_total +1 | remplir sources/dgddi-vitivinicole-stocks-harvests-input.csv puis lancer scripts/normalize_dgddi_vitivinicole_supply.php | | franceagrimer_campagne_viticulture | governed | weekly | Prix vrac FranceAgriMer | series, campaigns, latest_price, avg_price, categories | remplir sources/franceagrimer-prices-input.csv puis lancer scripts/normalize_franceagrimer_bulk_prices.php | | kpi_evidence | governed | weekly | Reference Copy Studio | persona, decision, metrics_to_pull, products, caveat | verifier api/reference_export.php?type=kpi_evidence&format=md | | reference_activation_outputs_manifest | governed | weekly | Territory Source Fact Table | schema_count, input_count, output_count | verifier api/get_reference_activation_outputs_manifest.php?format=md | | reference_copy_studio | governed | weekly | Publication Gate | status, fail_count, warn_count, gates, activation_summary | verifier api/get_reference_copy_studio.php?format=md | | reference_data_room_index | governed | weekly | Reference Release Notes | section_count, unique_product_count, shareable_count, runtime_validation_count | verifier api/get_reference_data_room_index.php?format=md | | reference_integration_guide | governed | weekly | Reference Data Contracts | contract_count, catalog_linked_count, missing_product_count, required_fields, quality_gates | verifier api/get_reference_integration_guide.php?format=md | | reference_kpi_card_deck | governed | weekly | KPI Cards hydratées | value, hydrated, copy_sentence_hydrated, caveat | verifier api/get_reference_kpi_card_deck.php?format=md | | reference_normalization_readiness | governed | daily | Normalization Quality Gates | qa_ready_count, blocked_count, status_counts, missing_columns, row_count | verifier api/get_reference_normalization_readiness.php?format=md | | reference_product_catalog | governed | weekly | Data Product Index | product_count, stage_counts, source_count, kpi_count | verifier app/reference_product_catalog.php | | reference_profile_publication_queue | governed | weekly | Profile Proof Cards | schema_count, output_count, status_count | lancer scripts/build_reference_profile_publication_queue.php puis verifier api/get_reference_profile_publication_queue.php?format=md | | reference_public_distribution | governed | weekly | User Feedback Pack | segment_count, question_count, score_count, copy_ready_score, source_demand_score | verifier api/get_reference_public_distribution.php?format=md | | reference_score_hydration | governed | daily | Live KPI Board | live_count, partial_count, demo_count, blocked_count, display_mode | verifier api/get_reference_score_hydration.php?format=md | | reference_source_to_score_activation_queue | governed | weekly | Activation Outputs Manifest | output_count, activated_count, pending_heavy_count | verifier api/get_reference_source_to_score_activation_queue.php?format=md | | reference_story_builder | governed | weekly | Territory Page Kit | section_count, layout_count, kpi_slots, source_stack, html_snippet | verifier api/get_reference_story_builder.php?format=md | | reference_territory_pilot_profiles | governed | weekly | Publishable Territory Profiles | schema_count, output_count, rule_count | lancer scripts/build_reference_territory_pilot_profiles.php puis verifier api/get_reference_territory_pilot_profiles.php?format=md | | reference_territory_share_pack | governed | weekly | Reference Claim Guard | mode_count, source_state_count, channel_count, allowed_claims, forbidden_claims | verifier api/get_reference_territory_share_pack.php?format=md | | sirene_insee | governed | monthly | Établissements vin SIRENE | establishments, sirens, core_wine_establishments, communes, naf_codes | php scripts/ingest_sirene_insee.php | | source_refresh_policy | catalog_only | n/a | Evidence Pack KPI, Source Relationship Pack, DATAtourisme Fidelity Monitor, Politique de fraîcheur sources +7 | source_name, source_url, citation, caveat, source_count +40 | La preuve ne valide pas automatiquement la fraîcheur : vérifier les dates et gates. +10 | | source_registry | catalog_only | n/a | Reference Pack Winerix, KPI Pack central, Evidence Pack KPI, Statut activation sources | reference_score, confidence_score, active_source_count, evidence_pack, communes +11 | Synthèse de maturité : dépend des imports locaux et des caveats de chaque source. +3 | | appellations | catalog_only | n/a | Aires AOC/AOP INAO par commune, Preuve appellation complète, Contrôle écarts appellations/eAmbrosia | area_rows, areas, communes, matched_winerix_areas, departments +9 | AOC/AOP toutes familles : filtrer/croiser avec les appellations vin Winerix, COMAGRI ou eAmbrosia avant usage juridique. +2 | | reference_territory_scores | catalog_only | n/a | Territory Brief Composer, Territory Comparison Pack, KPI Publication Certificates | score_count, source_count, badge_count, copy_blocks, source_stack +8 | Brief de composition : ne remplace pas normalisation source, validation DB, revue metier ou Publication Gate. +2 | | vignobles_decouvertes | catalog_only | n/a | Oenotourism Demand Offer Pack, Insee Tourism Occupancy Pack, Qualite Tourisme Establishments Pack | pillar_count, source_count, score_recipe, copy_blocks, trust_badge_keys +10 | Pack de lecture : il clarifie les usages mais ne remplace pas normalisation, hydratation KPI ou Publication Gate. +2 | | tourism_handicap_establishments | catalog_only | n/a | Oenotourism Demand Offer Pack, Qualite Tourisme Establishments Pack | pillar_count, source_count, score_recipe, copy_blocks, trust_badge_keys +5 | Pack de lecture : il clarifie les usages mais ne remplace pas normalisation, hydratation KPI ou Publication Gate. +1 | | ban_address_quality | catalog_only | n/a | Agence Bio Organic Wine Pack | wine_related_operators, department_count, city_count, certifier_count, source_mode | Annuaire declaratif Agence Bio : publier d abord des agregats territoire ; le groupe culture VI de l historique communal inclut une faible part de raisin de table. | | ban_commune_status | catalog_only | n/a | Qualité adresse BAN | audit_rows, geocoded_rate, average_address_score, low_quality_rows, certified_address_rows +1 | La BAN qualifie adresse et coordonnees ; elle ne prouve ni ouverture au public, ni pertinence vin, ni frequentation. | | classified_accommodations | catalog_only | n/a | Qualite Tourisme Establishments Pack | sampled_establishments, wine_related_establishments, geocoded_rate, region_count, activity_count | Label qualite accueil : ne mesure pas frequentation ni preuve vin sans rapprochement DATAtourisme/V&D/commune viticole. | | comagri_ao_2025 | catalog_only | n/a | Aires AOC/AOP INAO par commune | area_rows, areas, communes, matched_winerix_areas, departments | AOC/AOP toutes familles : filtrer/croiser avec les appellations vin Winerix, COMAGRI ou eAmbrosia avant usage juridique. | | datatourisme_resources | catalog_only | n/a | DATAtourisme Fidelity Monitor | datatourisme_freshness_score, coverage_by_region, source_relationship_signal, regional_feed_watchlist | DATAtourisme : fraicheur ressource ne prouve pas exhaustivite ni qualite des POI territoriaux. | | estate_profiles | catalog_only | n/a | KPI Pack central | communes, appellations, estates, wines, confidence_score | Pack agrégé : ne remplace pas les fiches source ni les contrôles de publication. | | franceagrimer_bulk_wine_prices | catalog_only | n/a | Source Opportunity Radar | opportunity_score, priority, impact, effort, confidence_score | Radar de priorisation : les sources listées ne sont pas toutes encore importées ni validées métier. | | inao_aoc_aop_communes | catalog_only | n/a | Territory KPI Crosswalk | join_key_count, recipe_count, source_stack, kpi_slots, quality_gates | Plan de rapprochement : ne prouve pas que les jointures DB ont ete executees ou validees. | | inao_aoc_aop_igp_areas_products | catalog_only | n/a | Source Opportunity Radar | opportunity_score, priority, impact, effort, confidence_score | Radar de priorisation : les sources listées ne sont pas toutes encore importées ni validées métier. | | insee_bpe_2024 | catalog_only | n/a | Insee BPE Equipment | tourism_service_density, territory_readiness_score, culture_leisure_context, access_equipment_signal | BPE : presence d equipements, pas qualite, frequentation ou satisfaction visiteur. | | macro_oenotourism_indicators | catalog_only | n/a | KPI Pack central | communes, appellations, estates, wines, confidence_score | Pack agrégé : ne remplace pas les fiches source ni les contrôles de publication. | | macro_wine_indicators | catalog_only | n/a | KPI Pack central | communes, appellations, estates, wines, confidence_score | Pack agrégé : ne remplace pas les fiches source ni les contrôles de publication. | | merimee_monuments_historiques | catalog_only | n/a | Merimee Heritage Monuments | heritage_pull_signal, culture_wine_context_score, territory_story_proof, heritage_signal | Merimee : patrimoine protege, pas frequentation, ouverture au public ou impact oenotouristique direct. | | openagenda_public_events | catalog_only | n/a | OpenAgenda Wine Event Signal | wine_event_signal, territory_activation_score, tourism_demand_context, wine_relevance_score | OpenAgenda contributif : couverture non exhaustive, taxonomy variable, frequentation non mesuree. | ## Gaps gouvernance - source_refresh_policy : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - source_registry : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - appellations : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - reference_territory_scores : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - vignobles_decouvertes : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - tourism_handicap_establishments : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - ban_address_quality : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - ban_commune_status : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - classified_accommodations : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - comagri_ao_2025 : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - datatourisme_resources : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - estate_profiles : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - franceagrimer_bulk_wine_prices : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - inao_aoc_aop_communes : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - inao_aoc_aop_igp_areas_products : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - insee_bpe_2024 : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - macro_oenotourism_indicators : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - macro_wine_indicators : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - merimee_monuments_historiques : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne. - openagenda_public_events : ajouter une ligne dans `sources/source-refresh-policy.csv` ou confirmer que c'est un produit interne.