French Towns, Departments and Regions (January 2018)

A few weeks ago, a project I was working on needed a list of French towns, sorted by department and by region. So I went looking into the official data, and I found a list of towns with names, postal codes, gps coordinates, departments, but no regions. And a list of departments. And another list of regions, with their corresponding departments. A few hours later, I compiled all this (non developer friendly) lists into three big SQL insert queries, corresponding to the following schema :


town (id, name, postalCode, department_id #)
department (id, name, postalCode, region_id #)
region (id, name, code)

Here are the links to the SQL queries (create table and insert values) :


Region :

Department :

Town : (Please be patient with this one, it contains almost 40K lines 😉 )

Indexes and constraints :


I hope this is will be useful to some developer out there who hates long, uncorrelated lists 😉


Notes :
These are the new French regions, with their new official names, taking into account the new 2016 schema.
Only metropolitan France is included, without the overseas regions and territories.
Corsica is included.
Monaco is not included.

One thought to “French Towns, Departments and Regions (January 2018)”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.