{"ok":true,"generated_at":"2026-07-08T01:08:58+02:00","root":"/home/clients/2eda93a6270ebcde17a930322d4078e0/sites/winerix.com","summary":{"db_ready":true,"missing_env_keys":[],"sources":13,"ready_to_run":9,"required_missing_files":1,"optional_missing_files":3,"fresh_sources":8,"stale_sources":0,"critical_sources":0,"actions":{"import_ready":9,"collect_required_file":1,"collect_optional_file":3},"activation_command":"php scripts/activate_reference_sources.php","status_command":"php scripts/source_activation_status.php"},"sources":[{"source_key":"source_registry","label":"Registre des sources","required":true,"file":null,"file_present":true,"file_size_bytes":null,"file_modified_at":null,"file_age_days":null,"freshness_status":"unknown","stale_after_days":null,"critical_after_days":null,"recommended_cadence":"","db_ready":true,"ready_to_run":true,"command":"php scripts/seed_source_registry.php","why":"Base de gouvernance : provenance, licence, santé, refresh et priorités.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"inao_siqo_products","label":"INAO produits SIQO vin","required":true,"file":"sources/inao-siqo-products.csv","file_present":true,"file_size_bytes":1114747,"file_modified_at":"2026-07-06T11:41:57+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":45,"critical_after_days":90,"recommended_cadence":"monthly","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_inao_siqo_products.php file=sources/inao-siqo-products.csv","why":"Filtre officiel produit vin avant publication appellation.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"inao_aoc_aop_commune_areas","label":"INAO aires AOC/AOP communes","required":true,"file":"sources/inao-aoc-aop-communes.csv","file_present":true,"file_size_bytes":3632054,"file_modified_at":"2026-07-06T11:41:57+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":45,"critical_after_days":90,"recommended_cadence":"monthly","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_inao_aoc_aop_communes.php file=sources/inao-aoc-aop-communes.csv","why":"Preuve territoriale communale des aires officielles.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"atout_france_oenotourisme","label":"Atout France oenotourisme macro","required":true,"file":"sources/atout-france-oenotourisme-indicators.csv","file_present":true,"file_size_bytes":2099,"file_modified_at":"2026-07-06T11:41:51+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":120,"critical_after_days":240,"recommended_cadence":"quarterly","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/atout-france-oenotourisme-indicators.csv","why":"Cadrage macro visiteurs, recettes, caves et signaux B2B.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"vignobles_decouvertes_destinations","label":"Vignobles & Découvertes","required":true,"file":"sources/vignobles-decouvertes-destinations-sample.csv","file_present":true,"file_size_bytes":20710,"file_modified_at":"2026-07-06T11:42:05+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":null,"critical_after_days":null,"recommended_cadence":"","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/vignobles-decouvertes-destinations-sample.csv","why":"Label destination et structuration oenotouristique.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"insee_hebergements_touristiques","label":"INSEE hébergements touristiques","required":true,"file":"sources/insee-hebergements-touristiques-2024.csv","file_present":true,"file_size_bytes":1947,"file_modified_at":"2026-07-06T11:41:58+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":120,"critical_after_days":240,"recommended_cadence":"quarterly","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/insee-hebergements-touristiques-2024.csv","why":"Demande touristique hébergée et taux d’occupation.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"tourisme_handicap","label":"Tourisme & Handicap macro","required":true,"file":"sources/tourisme-handicap-indicators.csv","file_present":true,"file_size_bytes":691,"file_modified_at":"2026-07-06T11:42:05+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":120,"critical_after_days":240,"recommended_cadence":"quarterly","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/tourisme-handicap-indicators.csv","why":"Cadre national accessibilité et familles couvertes.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"tourisme_handicap_establishments","label":"Tourisme & Handicap établissements","required":true,"file":"sources/tourisme-handicap-establishments.csv","file_present":true,"file_size_bytes":2287880,"file_modified_at":"2026-07-06T11:42:05+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":45,"critical_after_days":90,"recommended_cadence":"monthly","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_tourism_handicap_establishments.php file=sources/tourisme-handicap-establishments.csv","why":"Preuve locale établissement, familles de handicap et géographie.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"agreste_viticulture_territorial","label":"Agreste viticulture","required":true,"file":"sources/agreste-viticulture-territorial.csv","file_present":false,"file_size_bytes":null,"file_modified_at":null,"file_age_days":null,"freshness_status":"unknown","stale_after_days":400,"critical_after_days":760,"recommended_cadence":"annual","db_ready":true,"ready_to_run":false,"command":"php scripts/ingest_macro_indicators.php kind=macro_wine file=sources/agreste-viticulture-territorial.csv source_key=agreste_viticulture_territorial","why":"Surface, production et exploitations viticoles.","status":"missing_file","publication_action":"collect_required_file","publication_action_label":"Récupérer le fichier obligatoire."},{"source_key":"atout_france_classified_accommodations","label":"Hébergements classés Atout France","required":true,"file":"sources/atout-france-classified-accommodations.csv","file_present":true,"file_size_bytes":3687126,"file_modified_at":"2026-07-06T11:41:52+02:00","file_age_days":1,"freshness_status":"fresh","stale_after_days":45,"critical_after_days":120,"recommended_cadence":"monthly","db_ready":true,"ready_to_run":true,"command":"php scripts/ingest_classified_accommodations.php file=sources/atout-france-classified-accommodations.csv","why":"Capacité d’accueil officielle : établissements, chambres, lits, étoiles.","status":"ready","publication_action":"import_ready","publication_action_label":"Importer ou réimporter maintenant."},{"source_key":"eambrosia_gi","label":"eAmbrosia GI","required":false,"file":"sources/eambrosia-gi.csv","file_present":false,"file_size_bytes":null,"file_modified_at":null,"file_age_days":null,"freshness_status":"unknown","stale_after_days":45,"critical_after_days":90,"recommended_cadence":"monthly","db_ready":true,"ready_to_run":false,"command":"php scripts/ingest_eambrosia_gi.php file=sources/eambrosia-gi.csv","why":"Preuve réglementaire européenne et cahiers des charges.","status":"missing_file","publication_action":"collect_optional_file","publication_action_label":"Récupérer le fichier optionnel si le produit dépend de cette source."},{"source_key":"datatourisme_oenotourism","label":"DATAtourisme offres vin","required":false,"file":"sources/datatourisme-oenotourism-offers.csv","file_present":false,"file_size_bytes":null,"file_modified_at":null,"file_age_days":null,"freshness_status":"unknown","stale_after_days":14,"critical_after_days":30,"recommended_cadence":"weekly","db_ready":true,"ready_to_run":false,"command":"php scripts/ingest_datatourisme_oenotourism.php file=sources/datatourisme-oenotourism-offers.csv min_relevance=55","why":"Offre locale : lieux, expériences, itinéraires et événements.","status":"missing_file","publication_action":"collect_optional_file","publication_action_label":"Récupérer le fichier optionnel si le produit dépend de cette source."},{"source_key":"rpg_parcels","label":"RPG parcelles viticoles","required":false,"file":"sources/rpg-vineyard-parcels.csv","file_present":false,"file_size_bytes":null,"file_modified_at":null,"file_age_days":null,"freshness_status":"unknown","stale_after_days":400,"critical_after_days":760,"recommended_cadence":"annual","db_ready":true,"ready_to_run":false,"command":"php scripts/ingest_rpg_vineyard_parcels.php file=sources/rpg-vineyard-parcels.csv year=2024","why":"Empreinte parcellaire déclarative PAC.","status":"missing_file","publication_action":"collect_optional_file","publication_action_label":"Récupérer le fichier optionnel si le produit dépend de cette source."}],"copy_markdown":"# Winerix Source Activation Status\n\n- DB prête : oui\n- Sources prêtes à lancer : 9 / 13\n- Fichiers obligatoires manquants : 1\n- Fichiers optionnels manquants : 3\n- Fraîcheur : fresh 8 · stale 0 · critical 0\n\n## Commandes\n\n- Statut : `php scripts/source_activation_status.php`\n- Activation complète : `php scripts/activate_reference_sources.php`\n\n## Sources\n\n- [ready · unknown · import_ready] source_registry (age n/a) : php scripts/seed_source_registry.php\n- [ready · fresh · import_ready] inao_siqo_products (1j) : php scripts/ingest_inao_siqo_products.php file=sources/inao-siqo-products.csv\n- [ready · fresh · import_ready] inao_aoc_aop_commune_areas (1j) : php scripts/ingest_inao_aoc_aop_communes.php file=sources/inao-aoc-aop-communes.csv\n- [ready · fresh · import_ready] atout_france_oenotourisme (1j) : php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/atout-france-oenotourisme-indicators.csv\n- [ready · fresh · import_ready] vignobles_decouvertes_destinations (1j) : php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/vignobles-decouvertes-destinations-sample.csv\n- [ready · fresh · import_ready] insee_hebergements_touristiques (1j) : php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/insee-hebergements-touristiques-2024.csv\n- [ready · fresh · import_ready] tourisme_handicap (1j) : php scripts/ingest_macro_indicators.php kind=oenotourism file=sources/tourisme-handicap-indicators.csv\n- [ready · fresh · import_ready] tourisme_handicap_establishments (1j) : php scripts/ingest_tourism_handicap_establishments.php file=sources/tourisme-handicap-establishments.csv\n- [missing_file · unknown · collect_required_file] agreste_viticulture_territorial (age n/a) : php scripts/ingest_macro_indicators.php kind=macro_wine file=sources/agreste-viticulture-territorial.csv source_key=agreste_viticulture_territorial\n- [ready · fresh · import_ready] atout_france_classified_accommodations (1j) : php scripts/ingest_classified_accommodations.php file=sources/atout-france-classified-accommodations.csv\n- [missing_file · unknown · collect_optional_file] eambrosia_gi (age n/a) : php scripts/ingest_eambrosia_gi.php file=sources/eambrosia-gi.csv\n- [missing_file · unknown · collect_optional_file] datatourisme_oenotourism (age n/a) : php scripts/ingest_datatourisme_oenotourism.php file=sources/datatourisme-oenotourism-offers.csv min_relevance=55\n- [missing_file · unknown · collect_optional_file] rpg_parcels (age n/a) : php scripts/ingest_rpg_vineyard_parcels.php file=sources/rpg-vineyard-parcels.csv year=2024\n"}