Back to Bearstech Forge

Geo-Data (France)


This is a compilation of simple administrative and geographic informations for France, up to the city and district level:

  • 32,856 cities with their official zipcode and préfecture flag. Paris, Lyon and Marseille are split into arrondissements.
  • 96 départements, 6 DOM and 3 TOM (within the same hierarchical level). Proper keying is used (ie. 2A for Corse du Sud, no "20" or "97" shortcuts).
  • 22 régions, with two supplementary to classify départements from DOM and TOM.

Redundant data in all tables help make you sure you can fetch all information in a single SELECT lookup:

  • asking for a département gives its région
  • asking for a city also gives its corresponding département and région

Note: the city database might be incomplete since our source was not properly time stamped.


This compilation of PHP and SQL code was extracted from a production real-estate web site, which uses extensively this geographical data to search, filter and match people wishes with other's desires.

The data was collected from various public french sources and meticulously, patiently reworked and modified by Bearstech according to professionnals and users feedback while using the data.

The PHP sample code and the SQL dump data is copyright (c) 2005 Bearstech and available under the GPL v2 licensing terms (see the "GPL" file).

Note: although compiled from public data and considered as being in the public domain, sources did not clearly mentioned this fact.

Last modified 12 years ago Last modified on Oct 9, 2008, 4:23:52 PM

Attachments (1)

Download all attachments as: .zip