{"storage":"flat-v1","fields":[{"name":"source_id","sourceHeader":"ID","type":"string","storage":{"table":"v","column":"id"},"description":"Alias de id : identifiant de la même ville.","label":"source_id","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"name","sourceHeader":"name","type":"string","storage":{"table":"v","column":"name","localized":{"en":{"table":"v","column":"name_en"},"de":{"table":"v","column":"name_de"},"es":{"table":"v","column":"name_es"},"it":{"table":"v","column":"name_it"},"pt":{"table":"v","column":"name_pt"},"nl":{"table":"v","column":"name_nl"},"pl":{"table":"v","column":"name_pl"},"tr":{"table":"v","column":"name_tr"}}},"description":"Nom dans la langue demandée par lang ; repli français si cette variante manque.","label":"name","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"historical_name","sourceHeader":"nom historique","type":"string","storage":{"table":"x","column":"historical_name"},"description":"Nom original conservé dans la colonne source « nom historique » ; il ne désigne pas nécessairement un ancien toponyme.","label":"historical_name","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"local_names","sourceHeader":"nom local","type":"json","storage":{"table":"x","column":"local_names"},"description":"Variantes locales documentées, au format JSON.","label":"local_names","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"english_name","sourceHeader":"nom anglais","type":"string","storage":{"table":"x","column":"english_name"},"description":"Nom anglais documenté.","label":"english_name","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"population","sourceHeader":"[population]","type":"number","storage":{"table":"v","column":"population"},"description":"Nombre d'habitants documenté (cellule vide si inconnu, jamais 0 par défaut). Source : INSEE (populations municipales 2023), Wikidata (P1082) ou GeoNames selon [population_source].","label":"population","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"longitude","sourceHeader":"[longitude]","type":"number","storage":{"table":"v","column":"longitude"},"description":"Longitude GPS en degrés décimaux (WGS84), précision maximale locale conservée. Source : OpenStreetMap (ODbL) et rapprochement GeoNames compatible.","label":"longitude","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"latitude","sourceHeader":"[latitude]","type":"number","storage":{"table":"v","column":"latitude"},"description":"Latitude GPS en degrés décimaux (WGS84), précision maximale locale conservée. Source : OpenStreetMap (ODbL) et rapprochement GeoNames compatible.","label":"latitude","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"coordinate_match_distance_km","sourceHeader":"[coordinate_match_distance_km]","type":"number","storage":{"table":"x","column":"coordinate_match_distance_km"},"description":"Distance en kilomètres entre la coordonnée source et le lieu GeoNames rapproché. Source : Calcul géodésique (formule de Haversine) lors du rapprochement.","label":"coordinate_match_distance_km","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"coordinate_match_status","sourceHeader":"[coordinate_match_status]","type":"string","storage":{"table":"x","column":"coordinate_match_status"},"description":"Statut de confiance du rapprochement par coordonnées (name_agrees, coordinates_unique, coordinates_guess, geonames_direct). Source : Pipeline de contrôle géographique AffectionPlus.","label":"coordinate_match_status","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"postcode","sourceHeader":"[postcode]","type":"string","storage":{"table":"x","column":"postcode"},"description":"Un ou plusieurs codes postaux séparés par point-virgule (;), zéros initiaux préservés. Source : API Géo / La Poste (France), GeoNames Postal Codes, Wikidata ou fichier initial.","label":"postcode","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"name_local_phonetic","sourceHeader":"[name_local_phonetic]","type":"string","storage":{"table":"x","column":"name_local_phonetic"},"description":"Aide de lecture en alphabet latin pour les noms en écritures non latines. Source : Variantes latines GeoNames et nom anglais de repli.","label":"name_local_phonetic","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"alternate_names","sourceHeader":"[alternate_names]","type":"json","storage":{"table":"x","column":"alternate_names"},"description":"Liste JSON des variantes orthographiques, exonymes et translittérations connus. Source : GeoNames alternateNamesV2 et données initiales.","label":"alternate_names","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"country_code","sourceHeader":"[country_code]","type":"string","storage":{"table":"v","column":"country"},"description":"Code pays ou territoire ISO 3166-1 alpha-2 (ex. FR, GB, DK, GL). Source : GeoNames et contexte national vérifié.","label":"country_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1","sourceHeader":"[admin1]","type":"string","storage":{"table":"v","column":"admin1"},"description":"Nom de la division administrative de 1er niveau (région, État, Land, province). Source : GeoNames admin1CodesASCII et API Géo / INSEE (France).","label":"admin1","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_en","sourceHeader":"[admin1_en]","type":"string","storage":{"table":"p","column":"admin1_en"},"description":"Nom de la division administrative de premier niveau en anglais.","label":"admin1_en","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_fr","sourceHeader":"[admin1_fr]","type":"string","storage":{"table":"p","column":"admin1_fr"},"description":"Nom de la division administrative de premier niveau en français.","label":"admin1_fr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2","sourceHeader":"[admin2]","type":"string","storage":{"table":"v","column":"admin2"},"description":"Nom de la division administrative de 2e niveau (département, comté, district). Source : GeoNames admin2Codes et API Géo / INSEE (France).","label":"admin2","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_en","sourceHeader":"[admin2_en]","type":"string","storage":{"table":"p","column":"admin2_en"},"description":"Nom de la division administrative de deuxième niveau en anglais.","label":"admin2_en","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_fr","sourceHeader":"[admin2_fr]","type":"string","storage":{"table":"p","column":"admin2_fr"},"description":"Nom de la division administrative de deuxième niveau en français.","label":"admin2_fr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_code","sourceHeader":"[admin1_code]","type":"string","storage":{"table":"v","column":"admin1_code"},"description":"Code administratif composite de niveau 1 (GeoNames ou préfixe INSEE:). Source : GeoNames / INSEE.","label":"admin1_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_code","sourceHeader":"[admin2_code]","type":"string","storage":{"table":"v","column":"admin2_code"},"description":"Code administratif composite de niveau 2 (GeoNames ou préfixe INSEE:). Source : GeoNames / INSEE.","label":"admin2_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"municipality_code","sourceHeader":"[municipality_code]","type":"string","storage":{"table":"x","column":"municipality_code"},"description":"Code officiel de la commune (notamment code INSEE en France). Source : API Géo / INSEE.","label":"municipality_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"timezone","sourceHeader":"[timezone]","type":"string","storage":{"table":"p","column":"timezone"},"description":"Identifiant du fuseau horaire IANA (ex. Europe/Paris, America/New_York). Source : GeoNames.","label":"timezone","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"feature_code","sourceHeader":"[feature_code]","type":"string","storage":{"table":"p","column":"feature_code"},"description":"Code de classification GeoNames du lieu habité (PPLC, PPLA, PPLA2, PPL…). Source : GeoNames.","label":"feature_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role","sourceHeader":"[administrative_role]","type":"string","storage":{"table":"p","column":"administrative_role"},"description":"Rôle administratif normalisé (national_capital, admin1_seat, admin2_seat…). Source : Déduit du feature_code GeoNames.","label":"administrative_role","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_en","sourceHeader":"[administrative_role_en]","type":"string","storage":{"table":"p","column":"administrative_role_en"},"description":"Libellé du rôle administratif en anglais.","label":"administrative_role_en","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_fr","sourceHeader":"[administrative_role_fr]","type":"string","storage":{"table":"p","column":"administrative_role_fr"},"description":"Libellé du rôle administratif en français.","label":"administrative_role_fr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"elevation_m","sourceHeader":"[elevation_m]","type":"number","storage":{"table":"x","column":"elevation_m"},"description":"Altitude en mètres (uniquement lorsqu'une mesure explicite est fournie). Source : GeoNames.","label":"elevation_m","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"population_year","sourceHeader":"[population_year]","type":"string","storage":{"table":"x","column":"population_year"},"description":"Année de référence du recensement ou de l'estimation de population. Source : INSEE (2023) ou qualificatif point in time (P585) de Wikidata.","label":"population_year","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"population_source","sourceHeader":"[population_source]","type":"string","storage":{"table":"x","column":"population_source"},"description":"Source exacte du chiffre de population (insee-2023, wd:<QID>, gn:<id>, original_unverified). Source : Traçabilité du pipeline d'enrichissement.","label":"population_source","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"population_scope","sourceHeader":"[population_scope]","type":"string","storage":{"table":"x","column":"population_scope"},"description":"Périmètre géographique de la population (commune, wikidata_entity, geonames_place). Source : Traçabilité du pipeline d'enrichissement.","label":"population_scope","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"languages_official","sourceHeader":"[languages_official]","type":"json","storage":{"table":"p","column":"languages_official"},"description":"Liste JSON des codes de langues officielles applicables. Source : Wikidata (P37) et GeoNames countryInfo.txt.","label":"languages_official","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"languages_spoken","sourceHeader":"[languages_spoken]","type":"json","storage":{"table":"p","column":"languages_spoken"},"description":"Liste JSON des langues parlées ou utilisées documentées. Source : Wikidata (P2936) et GeoNames countryInfo.txt.","label":"languages_spoken","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"languages_scope","sourceHeader":"[languages_scope]","type":"json","storage":{"table":"p","column":"languages_scope"},"description":"Objet JSON précisant si les langues relèvent de la ville (city) ou du pays (country). Source : Métadonnée de portée linguistique.","label":"languages_scope","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"languages_source","sourceHeader":"[languages_source]","type":"json","storage":{"table":"p","column":"languages_source"},"description":"Objet JSON indiquant la source des langues officielles et parlées. Source : Wikidata et GeoNames countryInfo.","label":"languages_source","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"languages_year","sourceHeader":"[languages_year]","type":"string","storage":{"table":"p","column":"languages_year"},"description":"Année de référence des données linguistiques lorsque datée. Source : Wikidata.","label":"languages_year","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"area_km2","sourceHeader":"[area_km2]","type":"number","storage":{"table":"x","column":"area_km2"},"description":"Superficie en kilomètres carrés (km²). Source : API Géo / INSEE (hectares convertis en km²) et Wikidata (P2046).","label":"area_km2","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"area_scope","sourceHeader":"[area_scope]","type":"string","storage":{"table":"x","column":"area_scope"},"description":"Entité exacte couverte par la superficie (commune:<INSEE> ou wikidata_entity:<QID>). Source : API Géo / Wikidata.","label":"area_scope","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"area_source","sourceHeader":"[area_source]","type":"string","storage":{"table":"x","column":"area_source"},"description":"Référentiel ayant fourni la superficie (geo-fr:<INSEE> ou wd:<QID>). Source : API Géo / Wikidata.","label":"area_source","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"density_km2","sourceHeader":"[density_km2]","type":"number","storage":{"table":"x","column":"density_km2"},"description":"Densité d'habitants par km² (calculée uniquement si population datée et superficie ont le même périmètre). Source : Calcul vérifié sur [population] / [area_km2].","label":"density_km2","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"demonym_en","sourceHeader":"[demonym_en]","type":"string","storage":{"table":"x","column":"demonym_en"},"description":"Gentilé attesté en anglais.","label":"demonym_en","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_fr","sourceHeader":"[demonym_fr]","type":"string","storage":{"table":"x","column":"demonym_fr"},"description":"Gentilé attesté en français. Source : Wikidata P1549.","label":"demonym_fr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonyms_local","sourceHeader":"[demonyms_local]","type":"json","storage":{"table":"x","column":"demonyms_local"},"description":"Objet JSON de toutes les formes de gentilés attestées par code de langue. Source : Wikidata (P1549).","label":"demonyms_local","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"demonym_source","sourceHeader":"[demonym_source]","type":"string","storage":{"table":"x","column":"demonym_source"},"description":"Identifiant de l'entité Wikidata source du gentilé. Source : Wikidata.","label":"demonym_source","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_scope","sourceHeader":"[demonym_scope]","type":"string","storage":{"table":"x","column":"demonym_scope"},"description":"Périmètre d'application du gentilé (ville ou commune). Source : Wikidata / INSEE.","label":"demonym_scope","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"geonames_id","sourceHeader":"[geonames_id]","type":"string","storage":{"table":"x","column":"geonames_id"},"description":"Identifiant numérique GeoNames du lieu. Source : GeoNames.","label":"geonames_id","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"wikidata_id","sourceHeader":"[wikidata_id]","type":"string","storage":{"table":"x","column":"wikidata_id"},"description":"Identifiant d'entité Wikidata (ex. Q90 pour Paris). Source : Wikidata (via propriété P1566 GeoNames ID ou P374 INSEE).","label":"wikidata_id","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"official_website","sourceHeader":"[official_website]","type":"string","storage":{"table":"x","column":"official_website"},"description":"Site web officiel de la municipalité ou localité. Source : Wikidata (P856).","label":"official_website","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"wikipedia_url","sourceHeader":"[wikipedia_url]","type":"string","storage":{"table":"x","column":"wikipedia_url"},"description":"Lien Wikipédia conservé de la source retenue. La langue du lien est indiquée par wikipedia_language ; ce lien ne change pas avec le paramètre lang.","label":"wikipedia_url","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"postcode_source","sourceHeader":"[postcode_source]","type":"string","storage":{"table":"x","column":"postcode_source"},"description":"Source des codes postaux (geo-fr, gn-postal, wd, original_unverified). Source : Traçabilité postale.","label":"postcode_source","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"postcode_status","sourceHeader":"[postcode_status]","type":"string","storage":{"table":"x","column":"postcode_status"},"description":"Qualité de couverture postale (commune_codes, documented_not_exhaustive, partial_codes, original_unverified). Source : Diagnostic de couverture postale.","label":"postcode_status","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"data_sources","sourceHeader":"[data_sources]","type":"string","storage":{"table":"x","column":"data_sources"},"description":"Liste séparée par ';' de toutes les sources mobilisées pour construire la ligne. Source : Journal de provenance par ligne (osm, gn, wd, insee-2023, geo-fr, cldr, un-m49, iso-3166-2).","label":"data_sources","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"updated_at","sourceHeader":"[updated_at]","type":"string","storage":{"table":"x","column":"updated_at"},"description":"Date du dernier traitement d'enrichissement ou de vérification de la ligne (AAAA-MM-JJ). Source : Pipeline AffectionPlus.","label":"updated_at","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"enrichment_status","sourceHeader":"[enrichment_status]","type":"string","storage":{"table":"p","column":"enrichment_status"},"description":"Résultat global du rapprochement (name_coordinates, unmatched, coordinates_guess, geonames_direct…). Source : Pipeline AffectionPlus.","label":"enrichment_status","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"country_name","sourceHeader":"[country_name]","type":"string","storage":{"table":"v","column":"country_name","localized":{"en":{"table":"v","column":"country_name_en"},"de":{"table":"v","column":"country_name_de"},"es":{"table":"v","column":"country_name_es"},"it":{"table":"v","column":"country_name_it"},"pt":{"table":"v","column":"country_name_pt"},"nl":{"table":"v","column":"country_name_nl"},"pl":{"table":"v","column":"country_name_pl"},"tr":{"table":"v","column":"country_name_tr"}}},"description":"Nom du pays dans la langue demandée par lang ; repli français. Source : CLDR / Babel.","label":"country_name","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_geonames_id","sourceHeader":"[admin1_geonames_id]","type":"string","storage":{"table":"p","column":"admin1_geonames_id"},"description":"Identifiant GeoNames propre à la région / division de 1er niveau. Source : GeoNames admin1CodesASCII.","label":"admin1_geonames_id","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_geonames_id","sourceHeader":"[admin2_geonames_id]","type":"string","storage":{"table":"p","column":"admin2_geonames_id"},"description":"Identifiant GeoNames propre au département / division de 2e niveau. Source : GeoNames admin2Codes.","label":"admin2_geonames_id","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"wikipedia_language","sourceHeader":"[wikipedia_language]","type":"string","storage":{"table":"x","column":"wikipedia_language"},"description":"Code de langue de l'URL Wikipédia fournie (ex. fr, en, de). Source : Extrait du sous-domaine de [wikipedia_url].","label":"wikipedia_language","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"country_code_iso3","sourceHeader":"[country_code_iso3]","type":"string","storage":{"table":"p","column":"country_code_iso3"},"description":"Code pays normalisé ISO 3166-1 alpha-3 à trois lettres (ex. FRA, GBR, DNK). Source : GeoNames countryInfo.txt.","label":"country_code_iso3","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"continent_code","sourceHeader":"[continent_code]","type":"string","storage":{"table":"p","column":"continent_code"},"description":"Code du continent à deux lettres (EU, AS, AF, NA, SA, OC, AN). Source : GeoNames countryInfo.txt.","label":"continent_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"continent","sourceHeader":"[continent]","type":"string","storage":{"table":"p","column":"continent","localized":{"en":{"table":"p","column":"continent_en"},"de":{"table":"p","column":"continent_de"},"es":{"table":"p","column":"continent_es"},"it":{"table":"p","column":"continent_it"},"pt":{"table":"p","column":"continent_pt"},"nl":{"table":"p","column":"continent_nl"},"pl":{"table":"p","column":"continent_pl"},"tr":{"table":"p","column":"continent_tr"}}},"description":"Nom du continent dans la langue demandée par lang ; repli français. Source : ONU M49 / CLDR.","label":"continent","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"name_ascii","sourceHeader":"[name_ascii]","type":"string","storage":{"table":"x","column":"name_ascii"},"description":"Nom de la ville en caractères ASCII purs (sans accents), idéal pour l'indexation et la recherche. Source : GeoNames asciiname.","label":"name_ascii","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"duplicate_name_in_country","sourceHeader":"[duplicate_name_in_country]","type":"boolean","storage":{"table":"p","column":"duplicate_name_in_country"},"description":"Booléen (true / false) signalant si plusieurs villes du même pays portent le même nom ASCII. Source : Calcul sur l'ensemble des identifiants GeoNames du pays.","label":"duplicate_name_in_country","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull"]},{"name":"coordinate_source","sourceHeader":"[coordinate_source]","type":"string","storage":{"table":"p","column":"coordinate_source"},"description":"Source des coordonnées GPS : OpenStreetMap lorsque longitude et latitude sont renseignées. Source : OpenStreetMap (sous licence ODbL).","label":"coordinate_source","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"subregion_code_m49","sourceHeader":"[subregion_code_m49]","type":"string","storage":{"table":"p","column":"subregion_code_m49"},"description":"Code numérique officiel M49 des Nations Unies pour la sous-région géographique (ex. 155, 039). Source : Nations Unies — Classification statistique M49.","label":"subregion_code_m49","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"subregion_m49","sourceHeader":"[subregion_m49]","type":"string","storage":{"table":"p","column":"subregion_m49","localized":{"en":{"table":"p","column":"subregion_m49_en"},"de":{"table":"p","column":"subregion_m49_de"},"es":{"table":"p","column":"subregion_m49_es"},"it":{"table":"p","column":"subregion_m49_it"},"pt":{"table":"p","column":"subregion_m49_pt"},"nl":{"table":"p","column":"subregion_m49_nl"},"pl":{"table":"p","column":"subregion_m49_pl"},"tr":{"table":"p","column":"subregion_m49_tr"}}},"description":"Nom de la sous-région ONU M49 dans la langue demandée par lang ; repli français.","label":"subregion_m49","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_iso_code","sourceHeader":"[admin1_iso_code]","type":"string","storage":{"table":"p","column":"admin1_iso_code"},"description":"Code officiel ISO 3166-2 de la région ou de l'État fédéré (ex. FR-ARA, US-CA, DE-BY). Source : Wikidata (propriété P300 associée au GeoNames ID de la région).","label":"admin1_iso_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"importance_tier","sourceHeader":"[importance_tier]","type":"number","storage":{"table":"x","column":"importance_tier"},"description":"Indice hiérarchique de 1 à 5 (1 = capitale nationale ou ≥ 1 M hab. ; 2 = capitale régionale ou ≥ 200 k ; 3 = chef-lieu ou ≥ 50 k ; 4 = ≥ 10 k ; 5 = localité). Source : Calcul algorithmique sur [administrative_role], [feature_code] et [population].","label":"importance_tier","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"currency_code","sourceHeader":"[currency_code]","type":"string","storage":{"table":"p","column":"currency_code"},"description":"Code devise officiel ISO 4217 du pays ou territoire (ex. EUR, USD, GBP, DKK). Source : GeoNames countryInfo.txt.","label":"currency_code","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"phone_prefix","sourceHeader":"[phone_prefix]","type":"string","storage":{"table":"p","column":"phone_prefix"},"description":"Indicatif téléphonique international du pays ou territoire (ex. +33, +44, +1). Source : GeoNames countryInfo.txt.","label":"phone_prefix","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"postal_code_format","sourceHeader":"[postal_code_format]","type":"string","storage":{"table":"p","column":"postal_code_format"},"description":"Format / masque officiel des codes postaux du pays (ex. ##### en France). Source : GeoNames countryInfo.txt.","label":"postal_code_format","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"country_tld","sourceHeader":"[country_tld]","type":"string","storage":{"table":"p","column":"country_tld"},"description":"Domaine Internet national de premier niveau ccTLD (ex. .fr, .uk, .dk). Source : GeoNames countryInfo.txt.","label":"country_tld","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"population_proper","sourceHeader":"[population_proper]","type":"number","storage":{"table":"x","column":"population_proper"},"description":"Population municipale stricte (dans les limites administratives de la commune / localité). Source : INSEE (populations municipales 2023), Wikidata (P1082 municipal) ou GeoNames.","label":"population_proper","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"population_urban","sourceHeader":"[population_urban]","type":"number","storage":{"table":"x","column":"population_urban"},"description":"Population de l'agglomération / aire urbaine / métropole rattachée à la ville. Source : Wikidata (aires urbaines et métropolitaines P1082) et calcul d'agglomération spatiale GeoNames (hors sous-quartiers PPLX).","label":"population_urban","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","gt","gte","lt","lte","between"]},{"name":"population_urban_source","sourceHeader":"[population_urban_source]","type":"string","storage":{"table":"x","column":"population_urban_source"},"description":"Source de la population urbaine (wd:<QID>, gn_agglomeration ou proper_only). Source : Traçabilité de l'agglomération urbaine AffectionPlus.","label":"population_urban_source","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_de","sourceHeader":"[admin1_de]","type":"string","storage":{"table":"p","column":"admin1_de"},"description":"Nom de la division administrative de premier niveau en allemand.","label":"admin1_de","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_de","sourceHeader":"[admin2_de]","type":"string","storage":{"table":"p","column":"admin2_de"},"description":"Nom de la division administrative de deuxième niveau en allemand.","label":"admin2_de","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_de","sourceHeader":"[administrative_role_de]","type":"string","storage":{"table":"p","column":"administrative_role_de"},"description":"Libellé du rôle administratif en allemand.","label":"administrative_role_de","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_de","sourceHeader":"[demonym_de]","type":"string","storage":{"table":"x","column":"demonym_de"},"description":"Gentilé attesté en allemand.","label":"demonym_de","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_es","sourceHeader":"[admin1_es]","type":"string","storage":{"table":"p","column":"admin1_es"},"description":"Nom de la division administrative de premier niveau en espagnol.","label":"admin1_es","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_es","sourceHeader":"[admin2_es]","type":"string","storage":{"table":"p","column":"admin2_es"},"description":"Nom de la division administrative de deuxième niveau en espagnol.","label":"admin2_es","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_es","sourceHeader":"[administrative_role_es]","type":"string","storage":{"table":"p","column":"administrative_role_es"},"description":"Libellé du rôle administratif en espagnol.","label":"administrative_role_es","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_es","sourceHeader":"[demonym_es]","type":"string","storage":{"table":"x","column":"demonym_es"},"description":"Gentilé attesté en espagnol.","label":"demonym_es","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_it","sourceHeader":"[admin1_it]","type":"string","storage":{"table":"p","column":"admin1_it"},"description":"Nom de la division administrative de premier niveau en italien.","label":"admin1_it","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_it","sourceHeader":"[admin2_it]","type":"string","storage":{"table":"p","column":"admin2_it"},"description":"Nom de la division administrative de deuxième niveau en italien.","label":"admin2_it","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_it","sourceHeader":"[administrative_role_it]","type":"string","storage":{"table":"p","column":"administrative_role_it"},"description":"Libellé du rôle administratif en italien.","label":"administrative_role_it","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_it","sourceHeader":"[demonym_it]","type":"string","storage":{"table":"x","column":"demonym_it"},"description":"Gentilé attesté en italien.","label":"demonym_it","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_pt","sourceHeader":"[admin1_pt]","type":"string","storage":{"table":"p","column":"admin1_pt"},"description":"Nom de la division administrative de premier niveau en portugais.","label":"admin1_pt","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_pt","sourceHeader":"[admin2_pt]","type":"string","storage":{"table":"p","column":"admin2_pt"},"description":"Nom de la division administrative de deuxième niveau en portugais.","label":"admin2_pt","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_pt","sourceHeader":"[administrative_role_pt]","type":"string","storage":{"table":"p","column":"administrative_role_pt"},"description":"Libellé du rôle administratif en portugais.","label":"administrative_role_pt","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_pt","sourceHeader":"[demonym_pt]","type":"string","storage":{"table":"x","column":"demonym_pt"},"description":"Gentilé attesté en portugais.","label":"demonym_pt","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_nl","sourceHeader":"[admin1_nl]","type":"string","storage":{"table":"p","column":"admin1_nl"},"description":"Nom de la division administrative de premier niveau en néerlandais.","label":"admin1_nl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_nl","sourceHeader":"[admin2_nl]","type":"string","storage":{"table":"p","column":"admin2_nl"},"description":"Nom de la division administrative de deuxième niveau en néerlandais.","label":"admin2_nl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_nl","sourceHeader":"[administrative_role_nl]","type":"string","storage":{"table":"p","column":"administrative_role_nl"},"description":"Libellé du rôle administratif en néerlandais.","label":"administrative_role_nl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_nl","sourceHeader":"[demonym_nl]","type":"string","storage":{"table":"x","column":"demonym_nl"},"description":"Gentilé attesté en néerlandais.","label":"demonym_nl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_pl","sourceHeader":"[admin1_pl]","type":"string","storage":{"table":"p","column":"admin1_pl"},"description":"Nom de la division administrative de premier niveau en polonais.","label":"admin1_pl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_pl","sourceHeader":"[admin2_pl]","type":"string","storage":{"table":"p","column":"admin2_pl"},"description":"Nom de la division administrative de deuxième niveau en polonais.","label":"admin2_pl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_pl","sourceHeader":"[administrative_role_pl]","type":"string","storage":{"table":"p","column":"administrative_role_pl"},"description":"Libellé du rôle administratif en polonais.","label":"administrative_role_pl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_pl","sourceHeader":"[demonym_pl]","type":"string","storage":{"table":"x","column":"demonym_pl"},"description":"Gentilé attesté en polonais.","label":"demonym_pl","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin1_tr","sourceHeader":"[admin1_tr]","type":"string","storage":{"table":"p","column":"admin1_tr"},"description":"Nom de la division administrative de premier niveau en turc.","label":"admin1_tr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"admin2_tr","sourceHeader":"[admin2_tr]","type":"string","storage":{"table":"p","column":"admin2_tr"},"description":"Nom de la division administrative de deuxième niveau en turc.","label":"admin2_tr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"administrative_role_tr","sourceHeader":"[administrative_role_tr]","type":"string","storage":{"table":"p","column":"administrative_role_tr"},"description":"Libellé du rôle administratif en turc.","label":"administrative_role_tr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"demonym_tr","sourceHeader":"[demonym_tr]","type":"string","storage":{"table":"x","column":"demonym_tr"},"description":"Gentilé attesté en turc.","label":"demonym_tr","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"id","sourceHeader":"ID","type":"string","storage":{"table":"v","column":"id"},"description":"Identifiant unique et stable de la ville, conservé en texte, indépendant du pays.","label":"id","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"country","sourceHeader":"[country_code]","type":"string","storage":{"table":"v","column":"country"},"description":"Alias de country_code : code ISO 3166-1 alpha-2 du pays ou territoire.","label":"country","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"region","sourceHeader":"[admin1]","type":"string","storage":{"table":"v","column":"admin1","localized":{"en":{"table":"p","column":"admin1_en"},"de":{"table":"p","column":"admin1_de"},"es":{"table":"p","column":"admin1_es"},"it":{"table":"p","column":"admin1_it"},"pt":{"table":"p","column":"admin1_pt"},"nl":{"table":"p","column":"admin1_nl"},"pl":{"table":"p","column":"admin1_pl"},"tr":{"table":"p","column":"admin1_tr"}}},"description":"Nom de la division administrative de premier niveau dans la langue demandée ; repli sur admin1.","label":"region","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"department","sourceHeader":"[admin2]","type":"string","storage":{"table":"v","column":"admin2","localized":{"en":{"table":"p","column":"admin2_en"},"de":{"table":"p","column":"admin2_de"},"es":{"table":"p","column":"admin2_es"},"it":{"table":"p","column":"admin2_it"},"pt":{"table":"p","column":"admin2_pt"},"nl":{"table":"p","column":"admin2_nl"},"pl":{"table":"p","column":"admin2_pl"},"tr":{"table":"p","column":"admin2_tr"}}},"description":"Nom de la division administrative de deuxième niveau dans la langue demandée ; repli sur admin2.","label":"department","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]},{"name":"name_language","type":"string","sourceHeader":"langue attestée","storage":{"computed":"language"},"description":"Langue attestée du nom retourné ; fr lorsque la variante demandée manque.","label":"name_language","sortable":true,"availability":["public","subscriber"],"operators":["eq","ne","in","isnull","contains","startswith"]}],"languages":["fr","en","de","es","it","pt","nl","pl","tr"],"publicLimit":5000,"identity":"Identifiant source indépendant du pays ; alias GeoNames confirmés fusionnés. Pas de fusion par nom seul ou proximité.","conflicts":"Valeur de la source la mieux renseignée ; sources et conflits conservés hors base.","sharedProfiles":true}