-- Requêtes SQL pour insérer les départements de France
-- Basé sur les données GeoNames

INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('78', 'Yvelines', 'FRA-11', 48.80546, 1.85696);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('89', 'Yonne', 'FRA-27', 47.91667, 3.75);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('88', 'Vosges', 'FRA-44', 48.19161, 6.40533);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('75', 'Paris', 'FRA-11', 48.8534, 2.3486);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('86', 'Vienne', 'FRA-75', 46.53528, 0.45201);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('85', 'Vendée', 'FRA-52', 46.64169, -1.30407);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('84', 'Département du Vaucluse', 'FRA-93', 44, 5.16667);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('83', 'Var', 'FRA-93', 43.4586, 6.29145);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('95', 'Val d''Oise', 'FRA-11', 49.07891, 2.17673);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('94', 'Val-de-Marne', 'FRA-11', 48.78149, 2.49331);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('82', 'Tarn-et-Garonne', 'FRA-76', 44, 1.16667);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('81', 'Tarn', 'FRA-76', 43.7817, 2.16317);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('80', 'Somme', 'FRA-32', 49.93141, 2.27639);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('93', 'Seine-Saint-Denis', 'FRA-11', 48.91421, 2.47604);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('76', 'Seine-Maritime', 'FRA-28', 49.67278, 1.12519);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('77', 'Seine-et-Marne', 'FRA-11', 48.64599, 2.95905);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('73', 'Savoie', 'FRA-84', 45.46805, 6.48547);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('72', 'Sarthe', 'FRA-52', 48.00493, 0.26516);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('71', 'Saône-et-Loire', 'FRA-27', 46.63646, 4.58819);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('66', 'Pyrénées-Orientales', 'FRA-76', 42.60075, 2.58889);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('64', 'Pyrénées-Atlantiques', 'FRA-75', 43.23587, -0.81642);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('63', 'Puy-de-Dôme', 'FRA-84', 45.70549, 3.146);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('69', 'Rhône', 'FRA-84', 45.89126, 4.53039);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('62', 'Pas-de-Calais', 'FRA-32', 50.4828, 2.28664);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('61', 'Orne', 'FRA-28', 48.66667, 0.08333);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('60', 'Oise', 'FRA-32', 49.5, 2.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('59', 'Département du Nord', 'FRA-32', 50.33333, 3.36197);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('58', 'Nièvre', 'FRA-27', 47.11695, 3.49192);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('57', 'Moselle', 'FRA-44', 49.04177, 6.58355);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('56', 'Morbihan', 'FRA-53', 47.84765, -2.7776);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('55', 'Meuse', 'FRA-44', 48.97176, 5.36371);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('54', 'Meurthe et Moselle', 'FRA-44', 48.65082, 6.1566);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('53', 'Mayenne', 'FRA-52', 48.13494, -0.66667);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('51', 'Marne', 'FRA-44', 48.99116, 4.25966);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('50', 'Manche', 'FRA-28', 49.03822, -1.31865);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('49', 'Maine-et-Loire', 'FRA-52', 47.38911, -0.49984);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('48', 'Lozère', 'FRA-76', 44.5, 3.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('47', 'Lot-et-Garonne', 'FRA-75', 44.33333, 0.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('46', 'Lot', 'FRA-76', 44.62703, 1.63461);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('41', 'Loire-et-Cher', 'FRA-24', 47.5, 1.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('45', 'Loiret', 'FRA-24', 47.93598, 2.30173);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('44', 'Loire-Atlantique', 'FRA-52', 47.32863, -1.65764);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('42', 'Loire', 'FRA-84', 45.47169, 4.43298);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('40', 'Landes', 'FRA-75', 43.97543, -0.74241);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('39', 'Jura', 'FRA-27', 46.73431, 5.72349);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('38', 'Isère', 'FRA-84', 45.16667, 5.83333);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('37', 'Indre-et-Loire', 'FRA-24', 47.25, 0.75);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('36', 'Indre', 'FRA-24', 46.83333, 1.66667);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('35', 'Ille-et-Vilaine', 'FRA-53', 48.16667, -1.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('34', 'Hérault', 'FRA-76', 43.66667, 3.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('92', 'Hauts-de-Seine', 'FRA-11', 48.85, 2.19293);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('68', 'Haut-Rhin', 'FRA-44', 47.87603, 7.2719);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('87', 'Haute-Vienne', 'FRA-75', 45.88341, 1.21781);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('65', 'Hautes-Pyrénées', 'FRA-76', 43.03686, 0.18632);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('74', 'Haute-Savoie', 'FRA-84', 46.06143, 6.45374);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('70', 'Haute-Saône', 'FRA-27', 47.67625, 6.10066);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('05', 'Hautes-Alpes', 'FRA-93', 44.68055, 6.28969);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('52', 'Haute-Marne', 'FRA-44', 48.12019, 5.24038);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('43', 'Haute-Loire', 'FRA-84', 45.11001, 3.8394);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('31', 'Upper Garonne', 'FRA-76', 43.38724, 1.22191);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('2B', 'Upper Corsica', 'FRA-94', 42.41667, 9.16667);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('33', 'Gironde', 'FRA-75', 44.69306, -0.414);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('32', 'Gers', 'FRA-76', 43.71731, 0.45422);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('30', 'Gard', 'FRA-76', 44.0179, 4.28751);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('29', 'Finistère', 'FRA-53', 48.25224, -3.99263);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('28', 'Eure-et-Loir', 'FRA-24', 48.5, 1.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('27', 'Eure', 'FRA-28', 49.16667, 1);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('91', 'Essonne', 'FRA-11', 48.5, 2.25);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('26', 'Drôme', 'FRA-84', 44.69971, 5.16521);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('25', 'Doubs', 'FRA-27', 47.19967, 6.43487);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('24', 'Dordogne', 'FRA-75', 45.12735, 0.73504);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('79', 'Deux-Sèvres', 'FRA-75', 46.53918, -0.30838);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('23', 'Creuse', 'FRA-75', 46.07523, 2.05476);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('22', 'Côtes-d''Armor', 'FRA-53', 48.34295, -2.78216);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('21', 'Cote d''Or', 'FRA-27', 47.5, 4.83333);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('2A', 'South Corsica', 'FRA-94', 41.91667, 9.16667);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('19', 'Corrèze', 'FRA-75', 45.34754, 1.87319);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('18', 'Cher', 'FRA-24', 47.11304, 2.50983);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('17', 'Charente-Maritime', 'FRA-75', 45.75556, -0.71314);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('16', 'Charente', 'FRA-75', 45.70598, 0.18162);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('15', 'Cantal', 'FRA-84', 45.13985, 2.64947);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('14', 'Calvados', 'FRA-28', 49.09011, -0.30608);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('13', 'Bouches-du-Rhône', 'FRA-93', 43.52366, 5.4245);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('90', 'Territoire de Belfort', 'FRA-27', 47.63578, 6.88843);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('67', 'Bas-Rhin', 'FRA-44', 48.65693, 7.56346);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('12', 'Aveyron', 'FRA-76', 44.25, 2.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('11', 'Aude', 'FRA-76', 43.08333, 2.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('10', 'Aube', 'FRA-44', 48.25, 4.08333);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('09', 'Ariège', 'FRA-76', 43, 1.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('08', 'Ardennes', 'FRA-44', 49.63202, 4.65369);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('07', 'Ardèche', 'FRA-84', 44.66667, 4.33333);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('06', 'Alpes-Maritimes', 'FRA-93', 43.91307, 7.20436);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('04', 'Alpes-de-Haute-Provence', 'FRA-93', 44.09829, 6.26537);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('03', 'Allier', 'FRA-84', 46.5, 3);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('02', 'Aisne', 'FRA-32', 49.5, 3.5);
INSERT INTO departments (department_code, department_name, region_code, latitude, longitude) VALUES
('01', 'Ain', 'FRA-84', 46.16667, 5.33333);
