# Territory Source Fact Table

Table de faits unifiee pour hydrater les scorecards territoire depuis les sorties source activees.

## Outputs
- **fact_table** : `sources/reference-territory-source-facts.csv` - Unified territory/source/KPI fact table.
- **summary** : `sources/reference-territory-source-facts-summary.csv` - Source-level status and fact counts.

## Inputs
- **datatourisme_fidelity_monitor** : `sources/datatourisme-fidelity-monitor.csv` -> Freshness and regional coverage facts by country or region.
- **openagenda_wine_events** : `sources/openagenda-wine-events-normalized.csv` -> Wine event facts by commune when rows pass relevance threshold.
- **bnlc_carpooling_areas** : `sources/bnlc-carpooling-areas-normalized.csv` -> Carpool access facts by commune.
- **merimee_heritage_monuments** : `sources/merimee-monuments-normalized.csv` -> Heritage signal facts by commune.
- **insee_bpe_equipment** : `sources/insee-bpe-2024-equipment-normalized.csv` -> Aggregated equipment facts by territory grain and KPI family.

## Schema
- `territory_key` : Cle territoire canonique, par exemple commune:33063 ou region:naq.
- `territory_grain` : Maille de la valeur : commune, dep, reg, country, etc.
- `source_key` : Source normalisee ou monitoring source.
- `entity_key` : Identifiant entite source ou agregat.
- `kpi_family` : Famille de KPI Winerix.
- `kpi_key` : KPI activable dans les scorecards.
- `value` : Valeur source ou agregat.
- `unit` : Unite : score_0_100, facility_count, presence.
- `time_period` : Annee, date ou periode source.
- `confidence_hint` : Indice de qualite ou statut issu de la source.
- `source_url` : URL source publique.
- `caveat` : Limite source a conserver dans la publication.
- `normalized_at` : Horodatage de construction de la table faits.

## Build
`php scripts/build_reference_territory_source_facts.php sources/reference-territory-source-facts.csv sources/reference-territory-source-facts-summary.csv`

_Genere le 2026-07-06T17:05:34+00:00._