Database of French departments (SQL, CSV, XML)

It can be useful in an IT project to have a list of French departments. This article presents the list of 101 French departments, including the DOM-TOM.
Database of French departments
Contents of the list
The departments SQL database contains the following data:
- Department code
- Department name
- Department name in uppercase
- Department name purified to be used in a URL
- SOUNDEX () value of the department name. Useful so that users can find a department even if there has been a mispronunciation
Utility
A department database can be useful for web projects, mobile projects or any other IT application. Here is a small list of application ideas:
- Associate the department with any French city (see the list of cities in France)
- Associate the name of the departments with an SVG, Flash, jQuery map, etc.
- To be able to classify the customers or users of an application by department