Database Details
Postcodes of France
Postcode Database France
Details (Data of: 2024)
The France postcode database includes all French postcodes, as well as the corresponding city, region, and latitude/longitude.
The postcode data does change from time to time.
Buy your postcode database at ZIPCodeSoft, and we will keep your postcode data up-to-date. Just pay a one-off price! No further costs! Unlimited in time. Unprecedented!
Database content
Régions | 22 |
Departements | 106 |
Arrondissements | 365 |
Villes | 36.846 |
Codes postaux | 20.952 |
Code postal géocodé | 100 % |
Quantité des données | 51.722 |
Available Formats:
Comma-separated values (CSV) ~400 KB ZIP compressed
Easy to import into all popular database management systems:
MySQL
MS SQL
Oracle
Postgre SQL
Microsoft Access
DB Structure
pays | varchar(2) |
codepostal | varchar(5) |
cedex | varchar(5) |
ville | varchar(48) |
region | varchar(48) |
departement | varchar(48) |
arrondissement | varchar(48) |
latitude | decimal(13, 9) |
longitude | decimal(13, 9) |
Delivery
Online Download
Programming
Having a database of localities with their latitudes and longitudes enables you to locate the closest locations to a set point (or within a radius of X miles/km).To help you implement a postcode radius/distance search, we offer free access to sample code in scripting and programming languages like ASP and PHP.
To achieve the highest accuracy, the formulas in our example scripts take the earth's curvature into consideration.
Check out a working example of how to calculate all French postcodes within a given radius
Check out a working example of how to calculate road / beeline distance between 2 French postcodes
All these scripts are available for our database customers for free download. (PHP / ASP)
More information about the programming...
Data Sample
FR;33000;;Bordeaux;Aquitaine;Gironde;Arrondissement de Bordeaux;44,83740657;-0,57614046
FR;33100;;Bordeaux;Aquitaine;Gironde;Arrondissement de Bordeaux;44,83744684;-0,57614098
FR;33110;;Le Bouscat;Aquitaine;Gironde;Arrondissement de Bordeaux;44,86563232;-0,60022096
FR;33112;;Saint-Laurent-Médoc;Aquitaine;Gironde;Arrondissement de Lesparre-Médoc;45,15038780;-0,82196086
FR;33113;;Bourideys;Aquitaine;Gironde;Arrondissement de Langon;44,36806514;-0,45382055
FR;33113;;Cazalis;Aquitaine;Gironde;Arrondissement de Langon;44,34194324;-0,37972045
FR;33113;;Origne;Aquitaine;Gironde;Arrondissement de Langon;44,49242131;-0,50218035
FR;33113;;Saint-Léger-de-Balson;Aquitaine;Gironde;Arrondissement de Langon;44,43276594;-0,46656048
FR;33113;;Saint-Symphorien;Aquitaine;Gironde;Arrondissement de Langon;44,42764033;-0,49027043
FR;33114;;Le Barp;Aquitaine;Gironde;Arrondissement d'Arcachon;44,60671456;-0,76968059
FR;33115;;Bordeaux;Aquitaine;Gironde;Arrondissement de Bordeaux;44,83331309;-0,56670016
FR;33116;CEDEX;Le Barp;Aquitaine;Gironde;Arrondissement d'Arcachon;44,60563401;-0,77062919
FR;33120;;Arcachon;Aquitaine;Gironde;Arrondissement d'Arcachon;44,65483389;-1,14993138
FR;33121;;Carcans;Aquitaine;Gironde;Arrondissement de Lesparre-Médoc;45,07854370;-1,04608054
FR;33123;;Le Verdon-sur-Mer;Aquitaine;Gironde;Arrondissement de Lesparre-Médoc;45,54312777;-1,06374064
FR;33124;;Aillas;Aquitaine;Gironde;Arrondissement de Langon;44,47413745;-0,07382009
FR;33124;;Auros;Aquitaine;Gironde;Arrondissement de Langon;44,49639043;-0,14982009
FR;33124;;Berthez;Aquitaine;Gironde;Arrondissement de Langon;44,48478998;-0,13669011
FR;33124;;Brannens;Aquitaine;Gironde;Arrondissement de Langon;44,52079674;-0,15294015
FR;33124;;Brouqueyran;Aquitaine;Gironde;Arrondissement de Langon;44,48349022;-0,17478023
FR;33124;;Lados;Aquitaine;Gironde;Arrondissement de Langon;44,46878703;-0,14724008
FR;33124;;Savignac;Aquitaine;Gironde;Arrondissement de Langon;44,52258156;-0,10786014
FR;33125;;Hostens;Aquitaine;Gironde;Arrondissement de Langon;44,49282717;-0,63962038
FR;33125;;Le Tuzan;Aquitaine;Gironde;Arrondissement de Langon;44,45000453;-0,57653044
FR;33125;;Louchats;Aquitaine;Gironde;Arrondissement de Langon;44,51231883;-0,56702036
FR;33125;;Saint-Magne;Aquitaine;Gironde;Arrondissement d'Arcachon;44,52658361;-0,65644049
FR;33126;;Fronsac;Aquitaine;Gironde;Arrondissement de Libourne;44,92410980;-0,27320011
FR;33126;;La Rivière;Aquitaine;Gironde;Arrondissement de Libourne;44,93672825;-0,31214033
FR;33126;;Saint-Aignan;Aquitaine;Gironde;Arrondissement de Libourne;44,94877942;-0,29843052
FR;33126;;Saint-Michel-de-Fronsac;Aquitaine;Gironde;Arrondissement de Libourne;44,92647335;-0,30162048
FR;33127;;Martignas-sur-Jalle;Aquitaine;Gironde;Arrondissement de Bordeaux;44,84049514;-0,77547060
FR;33127;;Saint-Jean-d'Illac;Aquitaine;Gironde;Arrondissement de Bordeaux;44,81178483;-0,78038025
FR;33130;;Bègles;Aquitaine;Gironde;Arrondissement de Bordeaux;44,80755214;-0,54883075
FR;33133;;Galgon;Aquitaine;Gironde;Arrondissement de Libourne;44,99418869;-0,27424047
FR;33138;;Lanton;Aquitaine;Gironde;Arrondissement d'Arcachon;44,70168136;-1,03313048
FR;33140;;Cadaujac;Aquitaine;Gironde;Arrondissement de Bordeaux;44,75571769;-0,52992091
FR;33140;;Villenave-d'Ornon;Aquitaine;Gironde;Arrondissement de Bordeaux;44,77234266;-0,54002051
FR;33100;;Bordeaux;Aquitaine;Gironde;Arrondissement de Bordeaux;44,83744684;-0,57614098
FR;33110;;Le Bouscat;Aquitaine;Gironde;Arrondissement de Bordeaux;44,86563232;-0,60022096
FR;33112;;Saint-Laurent-Médoc;Aquitaine;Gironde;Arrondissement de Lesparre-Médoc;45,15038780;-0,82196086
FR;33113;;Bourideys;Aquitaine;Gironde;Arrondissement de Langon;44,36806514;-0,45382055
FR;33113;;Cazalis;Aquitaine;Gironde;Arrondissement de Langon;44,34194324;-0,37972045
FR;33113;;Origne;Aquitaine;Gironde;Arrondissement de Langon;44,49242131;-0,50218035
FR;33113;;Saint-Léger-de-Balson;Aquitaine;Gironde;Arrondissement de Langon;44,43276594;-0,46656048
FR;33113;;Saint-Symphorien;Aquitaine;Gironde;Arrondissement de Langon;44,42764033;-0,49027043
FR;33114;;Le Barp;Aquitaine;Gironde;Arrondissement d'Arcachon;44,60671456;-0,76968059
FR;33115;;Bordeaux;Aquitaine;Gironde;Arrondissement de Bordeaux;44,83331309;-0,56670016
FR;33116;CEDEX;Le Barp;Aquitaine;Gironde;Arrondissement d'Arcachon;44,60563401;-0,77062919
FR;33120;;Arcachon;Aquitaine;Gironde;Arrondissement d'Arcachon;44,65483389;-1,14993138
FR;33121;;Carcans;Aquitaine;Gironde;Arrondissement de Lesparre-Médoc;45,07854370;-1,04608054
FR;33123;;Le Verdon-sur-Mer;Aquitaine;Gironde;Arrondissement de Lesparre-Médoc;45,54312777;-1,06374064
FR;33124;;Aillas;Aquitaine;Gironde;Arrondissement de Langon;44,47413745;-0,07382009
FR;33124;;Auros;Aquitaine;Gironde;Arrondissement de Langon;44,49639043;-0,14982009
FR;33124;;Berthez;Aquitaine;Gironde;Arrondissement de Langon;44,48478998;-0,13669011
FR;33124;;Brannens;Aquitaine;Gironde;Arrondissement de Langon;44,52079674;-0,15294015
FR;33124;;Brouqueyran;Aquitaine;Gironde;Arrondissement de Langon;44,48349022;-0,17478023
FR;33124;;Lados;Aquitaine;Gironde;Arrondissement de Langon;44,46878703;-0,14724008
FR;33124;;Savignac;Aquitaine;Gironde;Arrondissement de Langon;44,52258156;-0,10786014
FR;33125;;Hostens;Aquitaine;Gironde;Arrondissement de Langon;44,49282717;-0,63962038
FR;33125;;Le Tuzan;Aquitaine;Gironde;Arrondissement de Langon;44,45000453;-0,57653044
FR;33125;;Louchats;Aquitaine;Gironde;Arrondissement de Langon;44,51231883;-0,56702036
FR;33125;;Saint-Magne;Aquitaine;Gironde;Arrondissement d'Arcachon;44,52658361;-0,65644049
FR;33126;;Fronsac;Aquitaine;Gironde;Arrondissement de Libourne;44,92410980;-0,27320011
FR;33126;;La Rivière;Aquitaine;Gironde;Arrondissement de Libourne;44,93672825;-0,31214033
FR;33126;;Saint-Aignan;Aquitaine;Gironde;Arrondissement de Libourne;44,94877942;-0,29843052
FR;33126;;Saint-Michel-de-Fronsac;Aquitaine;Gironde;Arrondissement de Libourne;44,92647335;-0,30162048
FR;33127;;Martignas-sur-Jalle;Aquitaine;Gironde;Arrondissement de Bordeaux;44,84049514;-0,77547060
FR;33127;;Saint-Jean-d'Illac;Aquitaine;Gironde;Arrondissement de Bordeaux;44,81178483;-0,78038025
FR;33130;;Bègles;Aquitaine;Gironde;Arrondissement de Bordeaux;44,80755214;-0,54883075
FR;33133;;Galgon;Aquitaine;Gironde;Arrondissement de Libourne;44,99418869;-0,27424047
FR;33138;;Lanton;Aquitaine;Gironde;Arrondissement d'Arcachon;44,70168136;-1,03313048
FR;33140;;Cadaujac;Aquitaine;Gironde;Arrondissement de Bordeaux;44,75571769;-0,52992091
FR;33140;;Villenave-d'Ornon;Aquitaine;Gironde;Arrondissement de Bordeaux;44,77234266;-0,54002051