Atos: French National Addresses

Certified repository of French addresses and localities recognized by the administration


The BAN dataset (National Address Database) contains 2 addresses and localities views containing the complete addresses of all the municipalities of the metropolitan and the overseas french departments. This data will allow you to correct or update your data based on a single repository, recognized by the French administration.

Views Included:
– v_ADDRESSES: All the complete addresses of the communes of France and Overseas France
– v_LIEUX_DITS: All the addresses of localities of France and Overseas France

Fields Included:
– id_fantoir : FANTOIR identifier
– numero : Street number
– rep : index associated with the street number
– nom_voie : Name of the street in lower case
– code_postal : Postal code
– code_insee: INSEE code of the current municipality based on the official geographic
– code_departement: INSEE code of the department
– libelle_departement : Department name
– code_region: INSEE code of the region
– libelle_region: Region name
– nom_commune: Official name of the municipality
– code_insee_ancienne : INSEE code of the former commune where the address is located
– nom_ancienne_commune : Name of the former commune where the address is located
– x : Map coordinates in legal projection
– y : Map coordinates in legal projection
– lon : Longitude in WGS-84
– lat: Latitude in WGS-84
– libelle_acheminement : Name of the routing commune
– nom_afnor : Name of the route according to the postal standard
– source_position: Source of the geographical position. Possible values (municipality, cadastre, arcep, laposte, insee, sdis, unknown)
– source_nom_voie: Source of the name of the lane. Possible values (municipality, cadastre, arcep, laposte, insee, sdis, unknown)

Additional Information:
Original data downloaded from


About the Provider:

Atos is the global leader in secure and decarbonized digital with a range of market-leading digital solutions along with consultancy services, digital security and decarbonization offerings; an end-to-end partnership approach.

Atos operates under the brands Atos and Atos|Syntel and is an SE (Societas Europaea), listed on the CAC40 Paris stock index.

As part of the free redistribution license granted by etalab.gouv, ATOS collects, prepare and share “”Open Data License”” datasets to Snowflake customers. This free and open license provides the necessary legal certainty for producers and users of public data.

Atos has developed the mechanisms for loading and regularly updating these open data in Snowflake and we wish to make more and more data available over the time. If you need an open data set which is not already available do not hesitate to contact us and we will see to add it in the marketplace!

Get access to the Atos: French National Addresses Listing in Snowflake


Already a Snowflake customer?
Access this listing directly from your Snowflake account.