{ "product": "reference_source_to_score_activation_queue", "status": "activation_ready", "generated_at": "2026-07-07T23:12:55+00:00", "input_template": "sources/reference-source-to-score-activation-queue-template.csv", "lanes": [ { "key": "source_retrieved", "label": "Source retrieved", "definition": "La source brute ou le snapshot metadata est present dans `sources/`.", "exit_gate": "Input file, source URL, licence/caveat and owner are documented." }, { "key": "normalize_next", "label": "Normalize next", "definition": "Le script de normalisation existe mais la sortie normalisee n est pas encore declaree comme disponible.", "exit_gate": "Normalized CSV produced, schema aligned and caveat carried forward." }, { "key": "score_hydration", "label": "Score hydration", "definition": "La source normalisee peut alimenter une scorecard territoire via la spine.", "exit_gate": "KPI input mapped to scorecard, grain and period explicit." }, { "key": "publication_ready", "label": "Publication ready", "definition": "Le score peut etre expose dans un bundle public avec source, date, maille and caveat.", "exit_gate": "Public block, source note, method note and trust badge available." }, { "key": "feedback_loop", "label": "Feedback loop", "definition": "Les limites et demandes utilisateur alimentent le backlog source.", "exit_gate": "Next source action tracked with producer, sample and decision rule." } ], "items": [ { "key": "datatourisme_fidelity_monitor", "source_key": "datatourisme_fidelity_monitor", "lane": "source_retrieved", "priority": 1, "input_files": [ "sources/datatourisme-datagouv.json", "sources/datatourisme-resource-snapshot.csv" ], "script": "scripts/monitor_datatourisme_freshness.php", "expected_output": "sources/datatourisme-fidelity-monitor.csv", "output_kpis": [ "datatourisme_freshness_score", "coverage_by_region", "source_relationship_signal" ], "scorecards": [ "data_trust", "publication_readiness" ], "public_bundle": "source_note", "run_command": "php scripts/monitor_datatourisme_freshness.php sources/datatourisme-resource-snapshot.csv sources/datatourisme-fidelity-monitor.csv", "gate": "Freshness score and watch status available for regional feeds.", "risk": "Resource freshness does not prove POI quality or coverage.", "next_action": "Run monitor, then expose oldest critical source in publication notes." }, { "key": "openagenda_wine_events", "source_key": "openagenda_wine_events", "lane": "normalize_next", "priority": 1, "input_files": [ "sources/openagenda-wine-events-sample.json" ], "script": "scripts/normalize_openagenda_wine_events.php", "expected_output": "sources/openagenda-wine-events-normalized.csv", "output_kpis": [ "wine_event_signal", "territory_activation_score", "tourism_demand_context" ], "scorecards": [ "market_pull" ], "public_bundle": "proof_strip", "run_command": "php scripts/normalize_openagenda_wine_events.php sources/openagenda-wine-events-sample.json sources/openagenda-wine-events-normalized.csv 35", "gate": "Events filtered by wine relevance, location and period retained.", "risk": "Contributive event coverage and keyword false positives.", "next_action": "Expand sample by region and period before publishing territory rankings." }, { "key": "bnlc_carpooling_areas", "source_key": "bnlc_carpooling_areas", "lane": "normalize_next", "priority": 1, "input_files": [ "sources/bnlc-carpooling-areas.csv" ], "script": "scripts/normalize_bnlc_carpooling_areas.php", "expected_output": "sources/bnlc-carpooling-areas-normalized.csv", "output_kpis": [ "carpool_access_signal", "low_carbon_access_score" ], "scorecards": [ "low_carbon_access" ], "public_bundle": "scorecard_grid", "run_command": "php scripts/normalize_bnlc_carpooling_areas.php sources/bnlc-carpooling-areas.csv sources/bnlc-carpooling-areas-normalized.csv", "gate": "Open status, coordinates, INSEE and capacity mapped.", "risk": "Infrastructure presence does not prove usage or final access to estates.", "next_action": "Normalize and aggregate open places by commune, then join to destination spine." }, { "key": "insee_bpe_equipment", "source_key": "insee_bpe_equipment", "lane": "normalize_next", "priority": 1, "input_files": [ "sources/insee-bpe-2024-counts.zip", "sources/insee-bpe-2024-table-passage.csv" ], "script": "scripts/normalize_insee_bpe_equipment.php", "expected_output": "sources/insee-bpe-2024-equipment-normalized.csv", "output_kpis": [ "tourism_service_density", "territory_readiness_score", "culture_leisure_context", "access_equipment_signal" ], "scorecards": [ "experience_readiness", "culture_story", "low_carbon_access" ], "public_bundle": "scorecard_grid", "run_command": "php scripts/normalize_insee_bpe_equipment.php sources/insee-bpe-2024-counts.zip sources/insee-bpe-2024-table-passage.csv sources/insee-bpe-2024-equipment-normalized.csv", "gate": "BPE domains A/B/E/F/G retained with year and grain explicit.", "risk": "Equipment counts are not quality, satisfaction or usage metrics.", "next_action": "Normalize, then compute density at compatible territory grains." }, { "key": "merimee_heritage_monuments", "source_key": "merimee_heritage_monuments", "lane": "normalize_next", "priority": 1, "input_files": [ "sources/merimee-monuments.csv" ], "script": "scripts/normalize_merimee_heritage_monuments.php", "expected_output": "sources/merimee-monuments-normalized.csv", "output_kpis": [ "heritage_pull_signal", "culture_wine_context_score", "territory_story_proof" ], "scorecards": [ "culture_story" ], "public_bundle": "proof_strip", "run_command": "php scripts/normalize_merimee_heritage_monuments.php sources/merimee-monuments.csv sources/merimee-monuments-normalized.csv", "gate": "Monument reference, commune, protection and coordinates retained.", "risk": "Protected heritage does not prove public opening or tourism demand.", "next_action": "Normalize and deduplicate by monument reference before joining to BPE culture." }, { "key": "agencebio_organic_wine", "source_key": "agencebio_organic_wine", "lane": "score_hydration", "priority": 2, "input_files": [ "sources/agencebio-professionnels-bio.csv" ], "script": "scripts/normalize_agencebio_organic_wine.php", "expected_output": "sources/agencebio-organic-wine-normalized.csv", "output_kpis": [ "organic_wine_signal", "organic_viticulture_surface_signal" ], "scorecards": [ "wine_identity" ], "public_bundle": "scorecard_grid", "run_command": "php scripts/normalize_agencebio_organic_wine.php", "gate": "Organic operators and surfaces kept distinct with year and grain.", "risk": "Territory signal is not individual estate certification proof.", "next_action": "Hydrate Wine Identity once grain and vintage are explicit." }, { "key": "territory_public_bundle", "source_key": "reference_territory_scorecard_public_bundle", "lane": "publication_ready", "priority": 1, "input_files": [ "sources/reference-territory-scorecard-public-bundle-template.csv" ], "script": "", "expected_output": "public page/deck/citation copy blocks", "output_kpis": [ "publication_readiness_score", "data_trust_score" ], "scorecards": [ "publication_readiness", "data_trust" ], "public_bundle": "one_page_public_profile", "run_command": "no command: inject certified values before publication", "gate": "No placeholder replaced by guessed value; source, date, grain and caveat visible.", "risk": "Copy may look ready before data values are certified.", "next_action": "Select first pilot territory and replace placeholders only with certified values." } ], "metrics": { "item_count": 7, "p1_count": 6, "normalize_next_count": 4, "publication_ready_count": 1, "lane_counts": { "source_retrieved": 1, "normalize_next": 4, "score_hydration": 1, "publication_ready": 1 } }, "source_products": [ "reference_authority_index", "reference_territory_data_spine", "reference_territory_kpi_scorecard_pack", "reference_territory_scorecard_public_bundle" ], "publication_caveat": "Cette file prepare l execution source vers score. Elle ne prouve pas que les scripts ont ete lances, que les sorties existent ou que les valeurs sont certifiees." }