-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathdepartements_data.sql
115 lines (113 loc) · 3.46 KB
/
departements_data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `departements_data` (
`region` int(2) DEFAULT NULL,
`dep` int(3) DEFAULT NULL,
`cheflieu` varchar(5) DEFAULT NULL,
`nom_dep` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `departements_data` (`region`, `dep`, `cheflieu`, `nom_dep`) VALUES
(82, 01, 01053, 'Ain'),
(22, 02, 02408, 'Aisne'),
(83, 03, 03190, 'Allier'),
(93, 04, 04070, 'Alpes-de-Haute-Provence'),
(93, 05, 05061, 'Hautes-Alpes'),
(93, 06, 06088, 'Alpes-Maritimes'),
(82, 07, 07186, 'Ardèche'),
(21, 08, 08105, 'Ardennes'),
(73, 09, 09122, 'Ariège'),
(21, 10, 10387, 'Aube'),
(91, 11, 11069, 'Aude'),
(73, 12, 12202, 'Aveyron'),
(93, 13, 13055, 'Bouches-du-Rhône'),
(25, 14, 14118, 'Calvados'),
(83, 15, 15014, 'Cantal'),
(54, 16, 16015, 'Charente'),
(54, 17, 17300, 'Charente-Maritime'),
(24, 18, 18033, 'Cher'),
(74, 19, 19272, 'Corrèze'),
(94, 20, '2A004', 'Corse-du-Sud'),
(26, 21, 21231, 'Côte-d''Or'),
(53, 22, 22278, 'Côtes-d''Armor'),
(74, 23, 23096, 'Creuse'),
(72, 24, 24322, 'Dordogne'),
(43, 25, 25056, 'Doubs'),
(82, 26, 26362, 'Drôme'),
(23, 27, 27229, 'Eure'),
(24, 28, 28085, 'Eure-et-Loir'),
(53, 29, 29232, 'Finistère'),
(91, 30, 30189, 'Gard'),
(73, 31, 31555, 'Haute-Garonne'),
(73, 32, 32013, 'Gers'),
(72, 33, 33063, 'Gironde'),
(91, 34, 34172, 'Hérault'),
(53, 35, 35238, 'Ille-et-Vilaine'),
(24, 36, 36044, 'Indre'),
(24, 37, 37261, 'Indre-et-Loire'),
(82, 38, 38185, 'Isère'),
(43, 39, 39300, 'Jura'),
(72, 40, 40192, 'Landes'),
(24, 41, 41018, 'Loir-et-Cher'),
(82, 42, 42218, 'Loire'),
(83, 43, 43157, 'Haute-Loire'),
(52, 44, 44109, 'Loire-Atlantique'),
(24, 45, 45234, 'Loiret'),
(73, 46, 46042, 'Lot'),
(72, 47, 47001, 'Lot-et-Garonne'),
(91, 48, 48095, 'Lozère'),
(52, 49, 49007, 'Maine-et-Loire'),
(25, 50, 50502, 'Manche'),
(21, 51, 51108, 'Marne'),
(21, 52, 52121, 'Haute-Marne'),
(52, 53, 53130, 'Mayenne'),
(41, 54, 54395, 'Meurthe-et-Moselle'),
(41, 55, 55029, 'Meuse'),
(53, 56, 56260, 'Morbihan'),
(41, 57, 57463, 'Moselle'),
(26, 58, 58194, 'Nièvre'),
(31, 59, 59350, 'Nord'),
(22, 60, 60057, 'Oise'),
(25, 61, 61001, 'Orne'),
(31, 62, 62041, 'Pas-de-Calais'),
(83, 63, 63113, 'Puy-de-Dôme'),
(72, 64, 64445, 'Pyrénées-Atlantiques'),
(73, 65, 65440, 'Hautes-Pyrénées'),
(91, 66, 66136, 'Pyrénées-Orientales'),
(42, 67, 67482, 'Bas-Rhin'),
(42, 68, 68066, 'Haut-Rhin'),
(82, 69, 69123, 'Rhône'),
(43, 70, 70550, 'Haute-Saône'),
(26, 71, 71270, 'Saône-et-Loire'),
(52, 72, 72181, 'Sarthe'),
(82, 73, 73065, 'Savoie'),
(82, 74, 74010, 'Haute-Savoie'),
(11, 75, 75056, 'Paris'),
(23, 76, 76540, 'Seine-Maritime'),
(11, 77, 77288, 'Seine-et-Marne'),
(11, 78, 78646, 'Yvelines'),
(54, 79, 79191, 'Deux-Sèvres'),
(22, 80, 80021, 'Somme'),
(73, 81, 81004, 'Tarn'),
(73, 82, 82121, 'Tarn-et-Garonne'),
(93, 83, 83137, 'Var'),
(93, 84, 84007, 'Vaucluse'),
(52, 85, 85191, 'Vendée'),
(54, 86, 86194, 'Vienne'),
(74, 87, 87085, 'Haute-Vienne'),
(41, 88, 88160, 'Vosges'),
(26, 89, 89024, 'Yonne'),
(43, 90, 90010, 'Territoire de Belfort'),
(11, 91, 91228, 'Essonne'),
(11, 92, 92050, 'Hauts-de-Seine'),
(11, 93, 93008, 'Seine-Saint-Denis'),
(11, 94, 94028, 'Val-de-Marne'),
(11, 95, 95500, 'Val-d''Oise'),
(01, 971, 97105, 'Guadeloupe'),
(02, 972, 97209, 'Martinique'),
(03, 973, 97302, 'Guyane'),
(04, 974, 97411, 'La Réunion'),
(00, 975, 0, 'St-Pierre-et-Miquelon'),
(00, 976, 0, 'Mayotte'),
(00, 986, 0, 'Wallis et Futuna'),
(00, 987, 0, 'Polynésie Française'),
(00, 988, 0, 'Nouvelle Calédonie');