Tous les codes postaux et villes de belgique

Soyez le premier à donner votre avis sur cette source.

Vue 43 091 fois - Téléchargée 777 fois

Description

C'est pas vraiment un code, mais la structure d'une table et son contenu.
Il s'agit de tous les codes postaux et villes existants en Belgique.
Vous pouvez par exemple vous en servir pour demander le code postal dans un formulaire et afficher automatiquement un select(html) avec les villes associées à ce code postal....

Source / Exemple :


#
# Structure de la table `cp_ville`
#

CREATE TABLE cp_ville (
  vil_id smallint(6) NOT NULL auto_increment,
  vil_cp smallint(4) NOT NULL default '0',
  vil_nom varchar(80) NOT NULL default '',
  PRIMARY KEY  (vil_id)
) TYPE=MyISAM;

#
# Contenu de la table `cp_ville`
#

INSERT INTO cp_ville VALUES (1, 1000, 'Brussel');
INSERT INTO cp_ville VALUES (2, 1000, 'Bruxelles');
INSERT INTO cp_ville VALUES (3, 1005, 'Ass. Réun. Com. Communau. Commune');
INSERT INTO cp_ville VALUES (4, 1005, 'Brusselse Hoofdstedelijke Raad');
INSERT INTO cp_ville VALUES (5, 1005, 'Conseil Region Bruxelles-Capitale');
INSERT INTO cp_ville VALUES (6, 1005, 'Ver.Verg.Gemeensch.Gemeensch.Comm.');
INSERT INTO cp_ville VALUES (7, 1006, 'Raad Vlaamse Gemeenschapscommissie');
INSERT INTO cp_ville VALUES (8, 1007, 'Ass. Commiss. Communau. française');
INSERT INTO cp_ville VALUES (9, 1008, 'Chambre des Représentants');
INSERT INTO cp_ville VALUES (10, 1008, 'Kamer van Volksvertegenwoordigers');
INSERT INTO cp_ville VALUES (11, 1009, 'Belgische Senaat');
INSERT INTO cp_ville VALUES (12, 1009, 'Senat de Belgique');
INSERT INTO cp_ville VALUES (13, 1010, 'Cité Administrative de l\'Etat');
INSERT INTO cp_ville VALUES (14, 1010, 'Rijksadministratief Centrum');
INSERT INTO cp_ville VALUES (15, 1011, 'Vlaamse Raad - Vlaams Parlement');
INSERT INTO cp_ville VALUES (16, 1012, 'Parlement de la Communauté française');
INSERT INTO cp_ville VALUES (17, 1020, 'Brussel (Laken)');
INSERT INTO cp_ville VALUES (18, 1020, 'Bruxelles (Laeken)');
INSERT INTO cp_ville VALUES (19, 1020, 'Laeken (Bruxelles)');
INSERT INTO cp_ville VALUES (20, 1020, 'Laken (Brussel)');
INSERT INTO cp_ville VALUES (21, 1030, 'Brussel (Schaarbeek)');
INSERT INTO cp_ville VALUES (22, 1030, 'Bruxelles (Schaerbeek)');
INSERT INTO cp_ville VALUES (23, 1030, 'Schaarbeek');
INSERT INTO cp_ville VALUES (24, 1030, 'Schaerbeek');
INSERT INTO cp_ville VALUES (25, 1031, 'Christelijke Sociale Organisaties');
INSERT INTO cp_ville VALUES (26, 1031, 'Organisations Sociales Chrétiennes');
INSERT INTO cp_ville VALUES (27, 1040, 'Brussel (Etterbeek)');
INSERT INTO cp_ville VALUES (28, 1040, 'Bruxelles (Etterbeek)');
INSERT INTO cp_ville VALUES (29, 1040, 'Etterbeek');
INSERT INTO cp_ville VALUES (30, 1041, 'International Press Center');
INSERT INTO cp_ville VALUES (31, 1043, 'VRT');
INSERT INTO cp_ville VALUES (32, 1044, 'RTBF');
INSERT INTO cp_ville VALUES (33, 1045, 'D.I.V.');
INSERT INTO cp_ville VALUES (34, 1047, 'Europees Parlement');
INSERT INTO cp_ville VALUES (35, 1047, 'Parlement Européen');
INSERT INTO cp_ville VALUES (36, 1048, 'E.U.-Raad');
INSERT INTO cp_ville VALUES (37, 1048, 'U.E.-Conseil');
INSERT INTO cp_ville VALUES (38, 1049, 'E.U.-Commissie');
INSERT INTO cp_ville VALUES (39, 1049, 'U.E.-Commission');
INSERT INTO cp_ville VALUES (40, 1050, 'Brussel (Elsene)');
INSERT INTO cp_ville VALUES (41, 1050, 'Bruxelles (Ixelles)');
INSERT INTO cp_ville VALUES (42, 1050, 'Elsene');
INSERT INTO cp_ville VALUES (43, 1050, 'Ixelles');
INSERT INTO cp_ville VALUES (44, 1060, 'Brussel (Sint-Gillis)');
INSERT INTO cp_ville VALUES (45, 1060, 'Bruxelles (Saint-Gilles)');
INSERT INTO cp_ville VALUES (46, 1060, 'Saint-Gilles');
INSERT INTO cp_ville VALUES (47, 1060, 'Sint-Gillis');
INSERT INTO cp_ville VALUES (48, 1070, 'Anderlecht');
INSERT INTO cp_ville VALUES (49, 1070, 'Brussel (Anderlecht)');
INSERT INTO cp_ville VALUES (50, 1070, 'Bruxelles (Anderlecht)');
INSERT INTO cp_ville VALUES (51, 1080, 'Brussel (Sint-Jans-Molenbeek)');
INSERT INTO cp_ville VALUES (52, 1080, 'Bruxelles (Molenbeek-Saint-Jean)');
INSERT INTO cp_ville VALUES (53, 1080, 'Molenbeek-Saint-Jean');
INSERT INTO cp_ville VALUES (54, 1080, 'Sint-Jans-Molenbeek');
INSERT INTO cp_ville VALUES (55, 1081, 'Brussel (Koekelberg)');
INSERT INTO cp_ville VALUES (56, 1081, 'Bruxelles (Koekelberg)');
INSERT INTO cp_ville VALUES (57, 1081, 'Koekelberg');
INSERT INTO cp_ville VALUES (58, 1082, 'Berchem-Sainte-Agathe');
INSERT INTO cp_ville VALUES (59, 1082, 'Brussel (Sint-Agatha-Berchem)');
INSERT INTO cp_ville VALUES (60, 1082, 'Bruxelles (Berchem-Sainte-Agathe)');
INSERT INTO cp_ville VALUES (61, 1082, 'Sint-Agatha-Berchem');
INSERT INTO cp_ville VALUES (62, 1083, 'Brussel (Ganshoren)');
INSERT INTO cp_ville VALUES (63, 1083, 'Bruxelles (Ganshoren)');
INSERT INTO cp_ville VALUES (64, 1083, 'Ganshoren');
INSERT INTO cp_ville VALUES (65, 1090, 'Brussel (Jette)');
INSERT INTO cp_ville VALUES (66, 1090, 'Bruxelles (Jette)');
INSERT INTO cp_ville VALUES (67, 1090, 'Jette');
INSERT INTO cp_ville VALUES (68, 1100, 'Postcheque');
INSERT INTO cp_ville VALUES (69, 1105, 'SOC');
INSERT INTO cp_ville VALUES (70, 1110, 'NAVO - NATO');
INSERT INTO cp_ville VALUES (71, 1110, 'OTAN - NATO');
INSERT INTO cp_ville VALUES (72, 1120, 'Brussel (Neder-Over-Heembeek)');
INSERT INTO cp_ville VALUES (73, 1120, 'Bruxelles (Neder-Over-Heembeek)');
INSERT INTO cp_ville VALUES (74, 1120, 'Neder-Over-Heembeek (Bru.)');
INSERT INTO cp_ville VALUES (75, 1130, 'Brussel (Haren)');
INSERT INTO cp_ville VALUES (76, 1130, 'Bruxelles (Haeren)');
INSERT INTO cp_ville VALUES (77, 1130, 'Haren (Bruxelles)');
INSERT INTO cp_ville VALUES (78, 1130, 'Haren (Brussel)');
INSERT INTO cp_ville VALUES (79, 1140, 'Brussel (Evere)');
INSERT INTO cp_ville VALUES (80, 1140, 'Bruxelles (Evere)');
INSERT INTO cp_ville VALUES (81, 1140, 'Evere');
INSERT INTO cp_ville VALUES (82, 1150, 'Brussel (Sint-Pieters-Woluwe)');
INSERT INTO cp_ville VALUES (83, 1150, 'Bruxelles (Woluwe-Saint-Pierre)');
INSERT INTO cp_ville VALUES (84, 1150, 'Sint-Pieters-Woluwe');
INSERT INTO cp_ville VALUES (85, 1150, 'Woluwe-Saint-Pierre');
INSERT INTO cp_ville VALUES (86, 1160, 'Auderghem');
INSERT INTO cp_ville VALUES (87, 1160, 'Brussel (Oudergem)');
INSERT INTO cp_ville VALUES (88, 1160, 'Bruxelles (Auderghem)');
INSERT INTO cp_ville VALUES (89, 1160, 'Oudergem');
INSERT INTO cp_ville VALUES (90, 1170, 'Brussel (Watermaal-Bosvoorde)');
INSERT INTO cp_ville VALUES (91, 1170, 'Bruxelles (Watermael-Boitsfort)');
INSERT INTO cp_ville VALUES (92, 1170, 'Watermaal-Bosvoorde');
INSERT INTO cp_ville VALUES (93, 1170, 'Watermael-Boitsfort');
INSERT INTO cp_ville VALUES (94, 1180, 'Brussel (Ukkel)');
INSERT INTO cp_ville VALUES (95, 1180, 'Bruxelles (Uccle)');
INSERT INTO cp_ville VALUES (96, 1180, 'Uccle');
INSERT INTO cp_ville VALUES (97, 1180, 'Ukkel');
INSERT INTO cp_ville VALUES (98, 1190, 'Brussel (Vorst)');
INSERT INTO cp_ville VALUES (99, 1190, 'Bruxelles (Forest)');
INSERT INTO cp_ville VALUES (100, 1190, 'Forest');
INSERT INTO cp_ville VALUES (101, 1190, 'Vorst');
INSERT INTO cp_ville VALUES (102, 1200, 'Brussel (Sint-Lambrechts-Woluwe)');
INSERT INTO cp_ville VALUES (103, 1200, 'Bruxelles (Woluwe-Saint-Lambert)');
INSERT INTO cp_ville VALUES (104, 1200, 'Sint-Lambrechts-Woluwe');
INSERT INTO cp_ville VALUES (105, 1200, 'Woluwe-Saint-Lambert');
INSERT INTO cp_ville VALUES (106, 1201, 'R.T.L. - T.V.I.');
INSERT INTO cp_ville VALUES (107, 1210, 'Brussel (Sint-Joost-ten-Node)');
INSERT INTO cp_ville VALUES (108, 1210, 'Bruxelles (Saint-Josse-ten-Noode)');
INSERT INTO cp_ville VALUES (109, 1210, 'Saint-Josse-ten-Noode');
INSERT INTO cp_ville VALUES (110, 1210, 'Sint-Joost-ten-Node');
INSERT INTO cp_ville VALUES (111, 1300, 'Limal');
INSERT INTO cp_ville VALUES (112, 1300, 'Wavre');
INSERT INTO cp_ville VALUES (113, 1301, 'Bierges');
INSERT INTO cp_ville VALUES (114, 1310, 'La Hulpe');
INSERT INTO cp_ville VALUES (115, 1315, 'Glimes');
INSERT INTO cp_ville VALUES (116, 1315, 'Incourt');
INSERT INTO cp_ville VALUES (117, 1315, 'Opprebais');
INSERT INTO cp_ville VALUES (118, 1315, 'Piètrebais');
INSERT INTO cp_ville VALUES (119, 1315, 'Roux-Miroir');
INSERT INTO cp_ville VALUES (120, 1320, 'Beauvechain');
INSERT INTO cp_ville VALUES (121, 1320, 'Hamme-Mille');
INSERT INTO cp_ville VALUES (122, 1320, 'l\'Ecluse');
INSERT INTO cp_ville VALUES (123, 1320, 'Nodebais');
INSERT INTO cp_ville VALUES (124, 1320, 'Tourinnes-la-Grosse');
INSERT INTO cp_ville VALUES (125, 1325, 'Bonlez');
INSERT INTO cp_ville VALUES (126, 1325, 'Chaumont-Gistoux');
INSERT INTO cp_ville VALUES (127, 1325, 'Corroy-le-Grand');
INSERT INTO cp_ville VALUES (128, 1325, 'Dion-Valmont');
INSERT INTO cp_ville VALUES (129, 1325, 'Longueville');
INSERT INTO cp_ville VALUES (130, 1330, 'Rixensart');
INSERT INTO cp_ville VALUES (131, 1331, 'Rosières');
INSERT INTO cp_ville VALUES (132, 1332, 'Genval');
INSERT INTO cp_ville VALUES (133, 1340, 'Ottignies');
INSERT INTO cp_ville VALUES (134, 1340, 'Ottignies-Louvain-la-Neuve');
INSERT INTO cp_ville VALUES (135, 1341, 'Céroux-Mousty');
INSERT INTO cp_ville VALUES (136, 1342, 'Limelette');
INSERT INTO cp_ville VALUES (137, 1348, 'Louvain-la-Neuve');
INSERT INTO cp_ville VALUES (138, 1350, 'Enines');
INSERT INTO cp_ville VALUES (139, 1350, 'Folx-les-Caves');
INSERT INTO cp_ville VALUES (140, 1350, 'Jandrain-Jandrenouille');
INSERT INTO cp_ville VALUES (141, 1350, 'Jauche');
INSERT INTO cp_ville VALUES (142, 1350, 'Marilles');
INSERT INTO cp_ville VALUES (143, 1350, 'Noduwez');
INSERT INTO cp_ville VALUES (144, 1350, 'Orp-Jauche');
INSERT INTO cp_ville VALUES (145, 1350, 'Orp-le-Grand');
INSERT INTO cp_ville VALUES (146, 1357, 'Hélécine');
INSERT INTO cp_ville VALUES (147, 1357, 'Linsmeau');
INSERT INTO cp_ville VALUES (148, 1357, 'Neerheylissem');
INSERT INTO cp_ville VALUES (149, 1357, 'Opheylissem');
INSERT INTO cp_ville VALUES (150, 1360, 'Malèves-Sainte-Marie-Wastines');
INSERT INTO cp_ville VALUES (151, 1360, 'Orbais');
INSERT INTO cp_ville VALUES (152, 1360, 'Perwez');
INSERT INTO cp_ville VALUES (153, 1360, 'Thorembais-les-Béguines');
INSERT INTO cp_ville VALUES (154, 1360, 'Thorembais-Saint-Trond');
INSERT INTO cp_ville VALUES (155, 1367, 'Autre-Eglise');
INSERT INTO cp_ville VALUES (156, 1367, 'Bomal (Bt.)');
INSERT INTO cp_ville VALUES (157, 1367, 'Geest-Gérompont-Petit-Rosière');
INSERT INTO cp_ville VALUES (158, 1367, 'Gérompont');
INSERT INTO cp_ville VALUES (159, 1367, 'Grand-Rosière-Hottomont');
INSERT INTO cp_ville VALUES (160, 1367, 'Huppaye');
INSERT INTO cp_ville VALUES (161, 1367, 'Mont-Saint-André');
INSERT INTO cp_ville VALUES (162, 1367, 'Ramillies');
INSERT INTO cp_ville VALUES (163, 1370, 'Dongelberg');
INSERT INTO cp_ville VALUES (164, 1370, 'Jauchelette');
INSERT INTO cp_ville VALUES (165, 1370, 'Jodoigne');
INSERT INTO cp_ville VALUES (166, 1370, 'Jodoigne-Souveraine');
INSERT INTO cp_ville VALUES (167, 1370, 'Lathuy');
INSERT INTO cp_ville VALUES (168, 1370, 'Mélin');
INSERT INTO cp_ville VALUES (169, 1370, 'Piétrain');
INSERT INTO cp_ville VALUES (170, 1370, 'Saint-Jean-Geest');
INSERT INTO cp_ville VALUES (171, 1370, 'Saint-Remy-Geest');
INSERT INTO cp_ville VALUES (172, 1370, 'Zétrud-Lumay');
INSERT INTO cp_ville VALUES (173, 1380, 'Couture-Saint-Germain');
INSERT INTO cp_ville VALUES (174, 1380, 'Lasne');
INSERT INTO cp_ville VALUES (175, 1380, 'Lasne-Chapelle-Saint-Lambert');
INSERT INTO cp_ville VALUES (176, 1380, 'Maransart');
INSERT INTO cp_ville VALUES (177, 1380, 'Ohain');
INSERT INTO cp_ville VALUES (178, 1380, 'Plancenoit');
INSERT INTO cp_ville VALUES (179, 1390, 'Archennes');
INSERT INTO cp_ville VALUES (180, 1390, 'Biez');
INSERT INTO cp_ville VALUES (181, 1390, 'Bossut-Gottechain');
INSERT INTO cp_ville VALUES (182, 1390, 'Grez-Doiceau');
INSERT INTO cp_ville VALUES (183, 1390, 'Nethen');
INSERT INTO cp_ville VALUES (184, 1400, 'Monstreux');
INSERT INTO cp_ville VALUES (185, 1400, 'Nivelles');
INSERT INTO cp_ville VALUES (186, 1401, 'Baulers');
INSERT INTO cp_ville VALUES (187, 1402, 'Thines');
INSERT INTO cp_ville VALUES (188, 1404, 'Bornival');
INSERT INTO cp_ville VALUES (189, 1410, 'Waterloo');
INSERT INTO cp_ville VALUES (190, 1414, 'Promo-Control');
INSERT INTO cp_ville VALUES (191, 1420, 'Braine-l\'Alleud');
INSERT INTO cp_ville VALUES (192, 1421, 'Ophain-Bois-Seigneur-Isaac');
INSERT INTO cp_ville VALUES (193, 1428, 'Lillois-Witterzée');
INSERT INTO cp_ville VALUES (194, 1430, 'Bierghes');
INSERT INTO cp_ville VALUES (195, 1430, 'Quenast');
INSERT INTO cp_ville VALUES (196, 1430, 'Rebecq');
INSERT INTO cp_ville VALUES (197, 1430, 'Rebecq-Rognon');
INSERT INTO cp_ville VALUES (198, 1435, 'Corbais');
INSERT INTO cp_ville VALUES (199, 1435, 'Hévillers');
INSERT INTO cp_ville VALUES (200, 1435, 'Mont-Saint-Guibert');
INSERT INTO cp_ville VALUES (201, 1440, 'Braine-le-Château');
INSERT INTO cp_ville VALUES (202, 1440, 'Wauthier-Braine');
INSERT INTO cp_ville VALUES (203, 1450, 'Chastre');
INSERT INTO cp_ville VALUES (204, 1450, 'Chastre-Villeroux-Blanmont');
INSERT INTO cp_ville VALUES (205, 1450, 'Cortil-Noirmont');
INSERT INTO cp_ville VALUES (206, 1450, 'Gentinnes');
INSERT INTO cp_ville VALUES (207, 1450, 'Saint-Géry');
INSERT INTO cp_ville VALUES (208, 1457, 'Nil-Saint-Vincent-Saint-Martin');
INSERT INTO cp_ville VALUES (209, 1457, 'Tourinnes-Saint-Lambert');
INSERT INTO cp_ville VALUES (210, 1457, 'Walhain');
INSERT INTO cp_ville VALUES (211, 1457, 'Walhain-Saint-Paul');
INSERT INTO cp_ville VALUES (212, 1460, 'Ittre');
INSERT INTO cp_ville VALUES (213, 1460, 'Virginal-Samme');
INSERT INTO cp_ville VALUES (214, 1461, 'Haut-Ittre');
INSERT INTO cp_ville VALUES (215, 1470, 'Baisy-Thy');
INSERT INTO cp_ville VALUES (216, 1470, 'Bousval');
INSERT INTO cp_ville VALUES (217, 1470, 'Genappe');
INSERT INTO cp_ville VALUES (218, 1471, 'Loupoigne');
INSERT INTO cp_ville VALUES (219, 1472, 'Vieux-Genappe');
INSERT INTO cp_ville VALUES (220, 1473, 'Glabais');
INSERT INTO cp_ville VALUES (221, 1474, 'Ways');
INSERT INTO cp_ville VALUES (222, 1476, 'Houtain-le-Val');
INSERT INTO cp_ville VALUES (223, 1480, 'Clabecq');
INSERT INTO cp_ville VALUES (224, 1480, 'Oisquercq');
INSERT INTO cp_ville VALUES (225, 1480, 'Saintes');
INSERT INTO cp_ville VALUES (226, 1480, 'Tubize');
INSERT INTO cp_ville VALUES (227, 1490, 'Court-Saint-Etienne');
INSERT INTO cp_ville VALUES (228, 1495, 'Marbais (Bt.)');
INSERT INTO cp_ville VALUES (229, 1495, 'Mellery');
INSERT INTO cp_ville VALUES (230, 1495, 'Sart-Dames-Avelines');
INSERT INTO cp_ville VALUES (231, 1495, 'Tilly');
INSERT INTO cp_ville VALUES (232, 1495, 'Villers-la-Ville');
INSERT INTO cp_ville VALUES (233, 1500, 'Halle');
INSERT INTO cp_ville VALUES (234, 1501, 'Buizingen');
INSERT INTO cp_ville VALUES (235, 1502, 'Lembeek');
INSERT INTO cp_ville VALUES (236, 1540, 'Herfelingen');
INSERT INTO cp_ville VALUES (237, 1540, 'Herne');
INSERT INTO cp_ville VALUES (238, 1541, 'Sint-Pieters-Kapelle (Bt.)');
INSERT INTO cp_ville VALUES (239, 1547, 'Bever');
INSERT INTO cp_ville VALUES (240, 1547, 'Bievene');
INSERT INTO cp_ville VALUES (241, 1560, 'Hoeilaart');
INSERT INTO cp_ville VALUES (242, 1570, 'Galmaarden');
INSERT INTO cp_ville VALUES (243, 1570, 'Tollembeek');
INSERT INTO cp_ville VALUES (244, 1570, 'Vollezele');
INSERT INTO cp_ville VALUES (245, 1600, 'Oudenaken');
INSERT INTO cp_ville VALUES (246, 1600, 'Sint-Laureins-Berchem');
INSERT INTO cp_ville VALUES (247, 1600, 'Sint-Pieters-Leeuw');
INSERT INTO cp_ville VALUES (248, 1601, 'Ruisbroek (Bt.)');
INSERT INTO cp_ville VALUES (249, 1602, 'Vlezenbeek');
INSERT INTO cp_ville VALUES (250, 1620, 'Drogenbos');
INSERT INTO cp_ville VALUES (251, 1630, 'Linkebeek');
INSERT INTO cp_ville VALUES (252, 1640, 'Rhode-Saint-Genese');
INSERT INTO cp_ville VALUES (253, 1640, 'Sint-Genesius-Rode');
INSERT INTO cp_ville VALUES (254, 1650, 'Beersel');
INSERT INTO cp_ville VALUES (255, 1651, 'Lot');
INSERT INTO cp_ville VALUES (256, 1652, 'Alsemberg');
INSERT INTO cp_ville VALUES (257, 1653, 'Dworp');
INSERT INTO cp_ville VALUES (258, 1654, 'Huizingen');
INSERT INTO cp_ville VALUES (259, 1670, 'Bogaarden');
INSERT INTO cp_ville VALUES (260, 1670, 'Heikruis');
INSERT INTO cp_ville VALUES (261, 1670, 'Pepingen');
INSERT INTO cp_ville VALUES (262, 1671, 'Elingen');
INSERT INTO cp_ville VALUES (263, 1673, 'Beert');
INSERT INTO cp_ville VALUES (264, 1674, 'Bellingen');
INSERT INTO cp_ville VALUES (265, 1700, 'Dilbeek');
INSERT INTO cp_ville VALUES (266, 1700, 'Sint-Martens-Bodegem');
INSERT INTO cp_ville VALUES (267, 1700, 'Sint-Ulriks-Kapelle');
INSERT INTO cp_ville VALUES (268, 1701, 'Itterbeek');
INSERT INTO cp_ville VALUES (269, 1702, 'Groot-Bijgaarden');
INSERT INTO cp_ville VALUES (270, 1703, 'Schepdaal');
INSERT INTO cp_ville VALUES (271, 1730, 'Asse');
INSERT INTO cp_ville VALUES (272, 1730, 'Bekkerzeel');
INSERT INTO cp_ville VALUES (273, 1730, 'Kobbegem');
INSERT INTO cp_ville VALUES (274, 1730, 'Mollem');
INSERT INTO cp_ville VALUES (275, 1731, 'Relegem');
INSERT INTO cp_ville VALUES (276, 1731, 'Zellik');
INSERT INTO cp_ville VALUES (277, 1740, 'Ternat');
INSERT INTO cp_ville VALUES (278, 1741, 'Wambeek');
INSERT INTO cp_ville VALUES (279, 1742, 'Sint-Katherina-Lombeek');
INSERT INTO cp_ville VALUES (280, 1745, 'Mazenzele');
INSERT INTO cp_ville VALUES (281, 1745, 'Opwijk');
INSERT INTO cp_ville VALUES (282, 1750, 'Gaasbeek');
INSERT INTO cp_ville VALUES (283, 1750, 'Lennik');
INSERT INTO cp_ville VALUES (284, 1750, 'Sint-Kwintens-Lennik');
INSERT INTO cp_ville VALUES (285, 1750, 'Sint-Martens-Lennik');
INSERT INTO cp_ville VALUES (286, 1755, 'Gooik');
INSERT INTO cp_ville VALUES (287, 1755, 'Kester');
INSERT INTO cp_ville VALUES (288, 1755, 'Leerbeek');
INSERT INTO cp_ville VALUES (289, 1755, 'Oetingen');
INSERT INTO cp_ville VALUES (290, 1760, 'Onze-Lieve-Vrouw-Lombeek');
INSERT INTO cp_ville VALUES (291, 1760, 'Pamel');
INSERT INTO cp_ville VALUES (292, 1760, 'Roosdaal');
INSERT INTO cp_ville VALUES (293, 1760, 'Strijtem');
INSERT INTO cp_ville VALUES (294, 1761, 'Borchtlombeek');
INSERT INTO cp_ville VALUES (295, 1770, 'Liedekerke');
INSERT INTO cp_ville VALUES (296, 1780, 'Wemmel');
INSERT INTO cp_ville VALUES (297, 1785, 'Brussegem');
INSERT INTO cp_ville VALUES (298, 1785, 'Hamme (Bt.)');
INSERT INTO cp_ville VALUES (299, 1785, 'Merchtem');
INSERT INTO cp_ville VALUES (300, 1790, 'Affligem');
INSERT INTO cp_ville VALUES (301, 1790, 'Essene');
INSERT INTO cp_ville VALUES (302, 1790, 'Hekelgem');
INSERT INTO cp_ville VALUES (303, 1790, 'Teralfene');
INSERT INTO cp_ville VALUES (304, 1800, 'Peutie');
INSERT INTO cp_ville VALUES (305, 1800, 'Vilvoorde');
INSERT INTO cp_ville VALUES (306, 1804, 'Cargovil');
INSERT INTO cp_ville VALUES (307, 1818, 'VTM');
INSERT INTO cp_ville VALUES (308, 1820, 'Melsbroek');
INSERT INTO cp_ville VALUES (309, 1820, 'Perk');
INSERT INTO cp_ville VALUES (310, 1820, 'Steenokkerzeel');
INSERT INTO cp_ville VALUES (311, 1830, 'Machelen (Bt.)');
INSERT INTO cp_ville VALUES (312, 1831, 'Diegem');
INSERT INTO cp_ville VALUES (313, 1840, 'Londerzeel');
INSERT INTO cp_ville VALUES (314, 1840, 'Malderen');
INSERT INTO cp_ville VALUES (315, 1840, 'Steenhuffel');
INSERT INTO cp_ville VALUES (316, 1850, 'Grimbergen');
INSERT INTO cp_ville VALUES (317, 1851, 'Humbeek');
INSERT INTO cp_ville VALUES (318, 1852, 'Beigem');
INSERT INTO cp_ville VALUES (319, 1853, 'Strombeek-Bever');
INSERT INTO cp_ville VALUES (320, 1860, 'Meise');
INSERT INTO cp_ville VALUES (321, 1861, 'Wolvertem');
INSERT INTO cp_ville VALUES (322, 1880, 'Kapelle-op-den-Bos');
INSERT INTO cp_ville VALUES (323, 1880, 'Nieuwenrode');
INSERT INTO cp_ville VALUES (324, 1880, 'Ramsdonk');
INSERT INTO cp_ville VALUES (325, 1910, 'Berg (Bt.)');
INSERT INTO cp_ville VALUES (326, 1910, 'Buken');
INSERT INTO cp_ville VALUES (327, 1910, 'Kampenhout');
INSERT INTO cp_ville VALUES (328, 1910, 'Nederokkerzeel');
INSERT INTO cp_ville VALUES (329, 1930, 'Nossegem');
INSERT INTO cp_ville VALUES (330, 1930, 'Zaventem');
INSERT INTO cp_ville VALUES (331, 1931, 'Brucargo');
INSERT INTO cp_ville VALUES (332, 1932, 'Sint-Stevens-Woluwe');
INSERT INTO cp_ville VALUES (333, 1933, 'Sterrebeek');
INSERT INTO cp_ville VALUES (334, 1934, 'Brussel X-Luchthaven Remailing');
INSERT INTO cp_ville VALUES (335, 1934, 'Bruxelles X-Aeroport Remailing');
INSERT INTO cp_ville VALUES (336, 1950, 'Kraainem');
INSERT INTO cp_ville VALUES (337, 1970, 'Wezembeek-Oppem');
INSERT INTO cp_ville VALUES (338, 1980, 'Eppegem');
INSERT INTO cp_ville VALUES (339, 1980, 'Zemst');
INSERT INTO cp_ville VALUES (340, 1981, 'Hofstade (Bt.)');
INSERT INTO cp_ville VALUES (341, 1982, 'Elewijt');
INSERT INTO cp_ville VALUES (342, 1982, 'Weerde');
INSERT INTO cp_ville VALUES (343, 2000, 'Antwerpen');
INSERT INTO cp_ville VALUES (344, 2018, 'Antwerpen');
INSERT INTO cp_ville VALUES (345, 2020, 'Antwerpen');
INSERT INTO cp_ville VALUES (346, 2030, 'Antwerpen');
INSERT INTO cp_ville VALUES (347, 2040, 'Antwerpen');
INSERT INTO cp_ville VALUES (348, 2040, 'Berendrecht');
INSERT INTO cp_ville VALUES (349, 2040, 'Lillo');
INSERT INTO cp_ville VALUES (350, 2040, 'Zandvliet');
INSERT INTO cp_ville VALUES (351, 2050, 'Antwerpen');
INSERT INTO cp_ville VALUES (352, 2060, 'Antwerpen');
INSERT INTO cp_ville VALUES (353, 2070, 'Burcht');
INSERT INTO cp_ville VALUES (354, 2070, 'Zwijndrecht');
INSERT INTO cp_ville VALUES (355, 2100, 'Deurne (Antwerpen)');
INSERT INTO cp_ville VALUES (356, 2110, 'Wijnegem');
INSERT INTO cp_ville VALUES (357, 2140, 'Borgerhout (Antwerpen)');
INSERT INTO cp_ville VALUES (358, 2150, 'Borsbeek (Antw.)');
INSERT INTO cp_ville VALUES (359, 2160, 'Wommelgem');
INSERT INTO cp_ville VALUES (360, 2170, 'Merksem (Antwerpen)');
INSERT INTO cp_ville VALUES (361, 2180, 'Ekeren (Antwerpen)');
INSERT INTO cp_ville VALUES (362, 2200, 'Herentals');
INSERT INTO cp_ville VALUES (363, 2200, 'Morkhoven');
INSERT INTO cp_ville VALUES (364, 2200, 'Noorderwijk');
INSERT INTO cp_ville VALUES (365, 2220, 'Hallaar');
INSERT INTO cp_ville VALUES (366, 2220, 'Heist-op-den-Berg');
INSERT INTO cp_ville VALUES (367, 2221, 'Booischot');
INSERT INTO cp_ville VALUES (368, 2222, 'Itegem');
INSERT INTO cp_ville VALUES (369, 2222, 'Wiekevorst');
INSERT INTO cp_ville VALUES (370, 2223, 'Schriek');
INSERT INTO cp_ville VALUES (371, 2230, 'Herselt');
INSERT INTO cp_ville VALUES (372, 2230, 'Ramsel');
INSERT INTO cp_ville VALUES (373, 2235, 'Houtvenne');
INSERT INTO cp_ville VALUES (374, 2235, 'Hulshout');
INSERT INTO cp_ville VALUES (375, 2235, 'Westmeerbeek');
INSERT INTO cp_ville VALUES (376, 2240, 'Massenhoven');
INSERT INTO cp_ville VALUES (377, 2240, 'Viersel');
INSERT INTO cp_ville VALUES (378, 2240, 'Zandhoven');
INSERT INTO cp_ville VALUES (379, 2242, 'Pulderbos');
INSERT INTO cp_ville VALUES (380, 2243, 'Pulle');
INSERT INTO cp_ville VALUES (381, 2250, 'Olen');
INSERT INTO cp_ville VALUES (382, 2260, 'Oevel');
INSERT INTO cp_ville VALUES (383, 2260, 'Tongerlo (Antw.)');
INSERT INTO cp_ville VALUES (384, 2260, 'Westerlo');
INSERT INTO cp_ville VALUES (385, 2260, 'Zoerle-Parwijs');
INSERT INTO cp_ville VALUES (386, 2270, 'Herenthout');
INSERT INTO cp_ville VALUES (387, 2275, 'Gierle');
INSERT INTO cp_ville VALUES (388, 2275, 'Lille');
INSERT INTO cp_ville VALUES (389, 2275, 'Poederlee');
INSERT INTO cp_ville VALUES (390, 2275, 'Wechelderzande');
INSERT INTO cp_ville VALUES (391, 2280, 'Grobbendonk');
INSERT INTO cp_ville VALUES (392, 2288, 'Bouwel');
INSERT INTO cp_ville VALUES (393, 2290, 'Vorselaar');
INSERT INTO cp_ville VALUES (394, 2300, 'Turnhout');
INSERT INTO cp_ville VALUES (395, 2310, 'Rijkevorsel');
INSERT INTO cp_ville VALUES (396, 2320, 'Hoogstraten');
INSERT INTO cp_ville VALUES (397, 2321, 'Meer');
INSERT INTO cp_ville VALUES (398, 2322, 'Minderhout');
INSERT INTO cp_ville VALUES (399, 2323, 'Wortel');
INSERT INTO cp_ville VALUES (400, 2328, 'Meerle');
INSERT INTO cp_ville VALUES (401, 2330, 'Merksplas');
INSERT INTO cp_ville VALUES (402, 2340, 'Beerse');
INSERT INTO cp_ville VALUES (403, 2340, 'Vlimmeren');
INSERT INTO cp_ville VALUES (404, 2350, 'Vosselaar');
INSERT INTO cp_ville VALUES (405, 2360, 'Oud-Turnhout');
INSERT INTO cp_ville VALUES (406, 2370, 'Arendonk');
INSERT INTO cp_ville VALUES (407, 2380, 'Ravels');
INSERT INTO cp_ville VALUES (408, 2381, 'Weelde');
INSERT INTO cp_ville VALUES (409, 2382, 'Poppel');
INSERT INTO cp_ville VALUES (410, 2387, 'Baarle-Hertog');
INSERT INTO cp_ville VALUES (411, 2390, 'Malle');
INSERT INTO cp_ville VALUES (412, 2390, 'Oostmalle');
INSERT INTO cp_ville VALUES (413, 2390, 'Westmalle');
INSERT INTO cp_ville VALUES (414, 2400, 'Mol');
INSERT INTO cp_ville VALUES (415, 2430, 'Eindhout');
INSERT INTO cp_ville VALUES (416, 2430, 'Laakdal');
INSERT INTO cp_ville VALUES (417, 2430, 'Vorst (Kempen)');
INSERT INTO cp_ville VALUES (418, 2431, 'Varendonk');
INSERT INTO cp_ville VALUES (419, 2431, 'Veerle');
INSERT INTO cp_ville VALUES (420, 2440, 'Geel');
INSERT INTO cp_ville VALUES (421, 2450, 'Meerhout');
INSERT INTO cp_ville VALUES (422, 2460, 'Kasterlee');
INSERT INTO cp_ville VALUES (423, 2460, 'Lichtaart');
INSERT INTO cp_ville VALUES (424, 2460, 'Tielen');
INSERT INTO cp_ville VALUES (425, 2470, 'Retie');
INSERT INTO cp_ville VALUES (426, 2480, 'Dessel');
INSERT INTO cp_ville VALUES (427, 2490, 'Balen');
INSERT INTO cp_ville VALUES (428, 2491, 'Olmen');
INSERT INTO cp_ville VALUES (429, 2500, 'Koningshooikt');
INSERT INTO cp_ville VALUES (430, 2500, 'Lier');
INSERT INTO cp_ville VALUES (431, 2520, 'Broechem');
INSERT INTO cp_ville VALUES (432, 2520, 'Emblem');
INSERT INTO cp_ville VALUES (433, 2520, 'Oelegem');
INSERT INTO cp_ville VALUES (434, 2520, 'Ranst');
INSERT INTO cp_ville VALUES (435, 2530, 'Boechout');
INSERT INTO cp_ville VALUES (436, 2531, 'Vremde');
INSERT INTO cp_ville VALUES (437, 2540, 'Hove');
INSERT INTO cp_ville VALUES (438, 2547, 'Lint');
INSERT INTO cp_ville VALUES (439, 2550, 'Kontich');
INSERT INTO cp_ville VALUES (440, 2550, 'Waarloos');
INSERT INTO cp_ville VALUES (441, 2560, 'Bevel');
INSERT INTO cp_ville VALUES (442, 2560, 'Kessel');
INSERT INTO cp_ville VALUES (443, 2560, 'Nijlen');
INSERT INTO cp_ville VALUES (444, 2570, 'Duffel');
INSERT INTO cp_ville VALUES (445, 2580, 'Beerzel');
INSERT INTO cp_ville VALUES (446, 2580, 'Putte');
INSERT INTO cp_ville VALUES (447, 2590, 'Berlaar');
INSERT INTO cp_ville VALUES (448, 2590, 'Gestel');
INSERT INTO cp_ville VALUES (449, 2600, 'Berchem (Antwerpen)');
INSERT INTO cp_ville VALUES (450, 2610, 'Wilrijk (Antwerpen)');
INSERT INTO cp_ville VALUES (451, 2620, 'Hemiksem');
INSERT INTO cp_ville VALUES (452, 2627, 'Schelle');
INSERT INTO cp_ville VALUES (453, 2630, 'Aartselaar');
INSERT INTO cp_ville VALUES (454, 2640, 'Mortsel');
INSERT INTO cp_ville VALUES (455, 2650, 'Edegem');
INSERT INTO cp_ville VALUES (456, 2660, 'Hoboken (Antwerpen)');
INSERT INTO cp_ville VALUES (457, 2800, 'Mechelen');
INSERT INTO cp_ville VALUES (458, 2800, 'Walem');
INSERT INTO cp_ville VALUES (459, 2801, 'Heffen');
INSERT INTO cp_ville VALUES (460, 2811, 'Hombeek');
INSERT INTO cp_ville VALUES (461, 2811, 'Leest');
INSERT INTO cp_ville VALUES (462, 2812, 'Muizen (Mechelen)');
INSERT INTO cp_ville VALUES (463, 2820, 'Bonheiden');
INSERT INTO cp_ville VALUES (464, 2820, 'Rijmenam');
INSERT INTO cp_ville VALUES (465, 2830, 'Blaasveld');
INSERT INTO cp_ville VALUES (466, 2830, 'Heindonk');
INSERT INTO cp_ville VALUES (467, 2830, 'Tisselt');
INSERT INTO cp_ville VALUES (468, 2830, 'Willebroek');
INSERT INTO cp_ville VALUES (469, 2840, 'Reet');
INSERT INTO cp_ville VALUES (470, 2840, 'Rumst');
INSERT INTO cp_ville VALUES (471, 2840, 'Terhagen');
INSERT INTO cp_ville VALUES (472, 2845, 'Niel');
INSERT INTO cp_ville VALUES (473, 2850, 'Boom');
INSERT INTO cp_ville VALUES (474, 2860, 'Sint-Katelijne-Waver');
INSERT INTO cp_ville VALUES (475, 2861, 'Onze-Lieve-Vrouw-Waver');
INSERT INTO cp_ville VALUES (476, 2870, 'Breendonk');
INSERT INTO cp_ville VALUES (477, 2870, 'Liezele');
INSERT INTO cp_ville VALUES (478, 2870, 'Puurs');
INSERT INTO cp_ville VALUES (479, 2870, 'Ruisbroek (Antw.)');
INSERT INTO cp_ville VALUES (480, 2880, 'Bornem');
INSERT INTO cp_ville VALUES (481, 2880, 'Hingene');
INSERT INTO cp_ville VALUES (482, 2880, 'Mariekerke (Bornem)');
INSERT INTO cp_ville VALUES (483, 2880, 'Weert');
INSERT INTO cp_ville VALUES (484, 2890, 'Lippelo');
INSERT INTO cp_ville VALUES (485, 2890, 'Oppuurs');
INSERT INTO cp_ville VALUES (486, 2890, 'Sint-Amands');
INSERT INTO cp_ville VALUES (487, 2900, 'Schoten');
INSERT INTO cp_ville VALUES (488, 2910, 'Essen');
INSERT INTO cp_ville VALUES (489, 2920, 'Kalmthout');
INSERT INTO cp_ville VALUES (490, 2930, 'Brasschaat');
INSERT INTO cp_ville VALUES (491, 2940, 'Hoevenen');
INSERT INTO cp_ville VALUES (492, 2940, 'Stabroek');
INSERT INTO cp_ville VALUES (493, 2950, 'Kapellen (Antw.)');
INSERT INTO cp_ville VALUES (494, 2960, 'Brecht');
INSERT INTO cp_ville VALUES (495, 2960, 'Sint-Job-in-\'t-Goor');
INSERT INTO cp_ville VALUES (496, 2960, 'Sint-Lenaarts');
INSERT INTO cp_ville VALUES (497, 2970, 's Gravenwezel');
INSERT INTO cp_ville VALUES (498, 2970, 'Schilde');
INSERT INTO cp_ville VALUES (499, 2980, 'Halle (Kempen)');
INSERT INTO cp_ville VALUES (500, 2980, 'Zoersel');
INSERT INTO cp_ville VALUES (501, 2990, 'Loenhout');
INSERT INTO cp_ville VALUES (502, 2990, 'Wuustwezel');
INSERT INTO cp_ville VALUES (503, 3000, 'Leuven');
INSERT INTO cp_ville VALUES (504, 3001, 'Heverlee');
INSERT INTO cp_ville VALUES (505, 3010, 'Kessel-Lo (Leuven)');
INSERT INTO cp_ville VALUES (506, 3012, 'Wilsele');
INSERT INTO cp_ville VALUES (507, 3018, 'Wijgmaal (Brabant)');
INSERT INTO cp_ville VALUES (508, 3020, 'Herent');
INSERT INTO cp_ville VALUES (509, 3020, 'Veltem-Beisem');
INSERT INTO cp_ville VALUES (510, 3020, 'Winksele');
INSERT INTO cp_ville VALUES (511, 3040, 'Huldenberg');
INSERT INTO cp_ville VALUES (512, 3040, 'Loonbeek');
INSERT INTO cp_ville VALUES (513, 3040, 'Neerijse');
INSERT INTO cp_ville VALUES (514, 3040, 'Ottenburg');
INSERT INTO cp_ville VALUES (515, 3040, 'Sint-Agatha-Rode');
INSERT INTO cp_ville VALUES (516, 3050, 'Oud-Heverlee');
INSERT INTO cp_ville VALUES (517, 3051, 'Sint-Joris-Weert');
INSERT INTO cp_ville VALUES (518, 3052, 'Blanden');
INSERT INTO cp_ville VALUES (519, 3053, 'Haasrode');
INSERT INTO cp_ville VALUES (520, 3054, 'Vaalbeek');
INSERT INTO cp_ville VALUES (521, 3060, 'Bertem');
INSERT INTO cp_ville VALUES (522, 3060, 'Korbeek-Dijle');
INSERT INTO cp_ville VALUES (523, 3061, 'Leefdaal');
INSERT INTO cp_ville VALUES (524, 3070, 'Kortenberg');
INSERT INTO cp_ville VALUES (525, 3071, 'Erps-Kwerps');
INSERT INTO cp_ville VALUES (526, 3078, 'Everberg');
INSERT INTO cp_ville VALUES (527, 3078, 'Meerbeek');
INSERT INTO cp_ville VALUES (528, 3080, 'Duisburg');
INSERT INTO cp_ville VALUES (529, 3080, 'Tervuren');
INSERT INTO cp_ville VALUES (530, 3080, 'Vossem');
INSERT INTO cp_ville VALUES (531, 3090, 'Overijse');
INSERT INTO cp_ville VALUES (532, 3110, 'Rotselaar');
INSERT INTO cp_ville VALUES (533, 3111, 'Wezemaal');
INSERT INTO cp_ville VALUES (534, 3118, 'Werchter');
INSERT INTO cp_ville VALUES (535, 3120, 'Tremelo');
INSERT INTO cp_ville VALUES (536, 3128, 'Baal');
INSERT INTO cp_ville VALUES (537, 3130, 'Begijnendijk');
INSERT INTO cp_ville VALUES (538, 3130, 'Betekom');
INSERT INTO cp_ville VALUES (539, 3140, 'Keerbergen');
INSERT INTO cp_ville VALUES (540, 3150, 'Haacht');
INSERT INTO cp_ville VALUES (541, 3150, 'Tildonk');
INSERT INTO cp_ville VALUES (542, 3150, 'Wespelaar');
INSERT INTO cp_ville VALUES (543, 3190, 'Boortmeerbeek');
INSERT INTO cp_ville VALUES (544, 3191, 'Hever');
INSERT INTO cp_ville VALUES (545, 3200, 'Aarschot');
INSERT INTO cp_ville VALUES (546, 3200, 'Gelrode');
INSERT INTO cp_ville VALUES (547, 3201, 'Langdorp');
INSERT INTO cp_ville VALUES (548, 3202, 'Rillaar');
INSERT INTO cp_ville VALUES (549, 3210, 'Linden');
INSERT INTO cp_ville VALUES (550, 3210, 'Lubbeek');
INSERT INTO cp_ville VALUES (551, 3211, 'Binkom');
INSERT INTO cp_ville VALUES (552, 3212, 'Pellenberg');
INSERT INTO cp_ville VALUES (553, 3220, 'Holsbeek');
INSERT INTO cp_ville VALUES (554, 3220, 'Kortrijk-Dutsel');
INSERT INTO cp_ville VALUES (555, 3220, 'Sint-Pieters-Rode');
INSERT INTO cp_ville VALUES (556, 3221, 'Nieuwrode');
INSERT INTO cp_ville VALUES (557, 3270, 'Scherpenheuvel');
INSERT INTO cp_ville VALUES (558, 3270, 'Scherpenheuvel-Zichem');
INSERT INTO cp_ville VALUES (559, 3271, 'Averbode');
INSERT INTO cp_ville VALUES (560, 3271, 'Zichem');
INSERT INTO cp_ville VALUES (561, 3272, 'Messelbroek');
INSERT INTO cp_ville VALUES (562, 3272, 'Testelt');
INSERT INTO cp_ville VALUES (563, 3290, 'Deurne (Bt.)');
INSERT INTO cp_ville VALUES (564, 3290, 'Diest');
INSERT INTO cp_ville VALUES (565, 3290, 'Schaffen');
INSERT INTO cp_ville VALUES (566, 3290, 'Webbekom');
INSERT INTO cp_ville VALUES (567, 3293, 'Kaggevinne');
INSERT INTO cp_ville VALUES (568, 3294, 'Molenstede');
INSERT INTO cp_ville VALUES (569, 3300, 'Bost');
INSERT INTO cp_ville VALUES (570, 3300, 'Goetsenhoven');
INSERT INTO cp_ville VALUES (571, 3300, 'Hakendover');
INSERT INTO cp_ville VALUES (572, 3300, 'Kumtich');
INSERT INTO cp_ville VALUES (573, 3300, 'Oorbeek');
INSERT INTO cp_ville VALUES (574, 3300, 'Oplinter');
INSERT INTO cp_ville VALUES (575, 3300, 'Sint-Margriete-Houtem (Tienen)');
INSERT INTO cp_ville VALUES (576, 3300, 'Tienen');
INSERT INTO cp_ville VALUES (577, 3300, 'Vissenaken');
INSERT INTO cp_ville VALUES (578, 3320, 'Hoegaarden');
INSERT INTO cp_ville VALUES (579, 3320, 'Meldert (Bt.)');
INSERT INTO cp_ville VALUES (580, 3321, 'Outgaarden');
INSERT INTO cp_ville VALUES (581, 3350, 'Drieslinter');
INSERT INTO cp_ville VALUES (582, 3350, 'Linter');
INSERT INTO cp_ville VALUES (583, 3350, 'Melkwezer');
INSERT INTO cp_ville VALUES (584, 3350, 'Neerhespen');
INSERT INTO cp_ville VALUES (585, 3350, 'Neerlinter');
INSERT INTO cp_ville VALUES (586, 3350, 'Orsmaal-Gussenhoven');
INSERT INTO cp_ville VALUES (587, 3350, 'Overhespen');
INSERT INTO cp_ville VALUES (588, 3350, 'Wommersom');
INSERT INTO cp_ville VALUES (589, 3360, 'Bierbeek');
INSERT INTO cp_ville VALUES (590, 3360, 'Korbeek-Lo');
INSERT INTO cp_ville VALUES (591, 3360, 'Lovenjoel');
INSERT INTO cp_ville VALUES (592, 3360, 'Opvelp');
INSERT INTO cp_ville VALUES (593, 3370, 'Boutersem');
INSERT INTO cp_ville VALUES (594, 3370, 'Kerkom');
INSERT INTO cp_ville VALUES (595, 3370, 'Neervelp');
INSERT INTO cp_ville VALUES (596, 3370, 'Roosbeek');
INSERT INTO cp_ville VALUES (597, 3370, 'Vertrijk');
INSERT INTO cp_ville VALUES (598, 3370, 'Willebringen');
INSERT INTO cp_ville VALUES (599, 3380, 'Bunsbeek');
INSERT INTO cp_ville VALUES (600, 3380, 'Glabbeek-Zuurbemde');
INSERT INTO cp_ville VALUES (601, 3381, 'Kapellen (Bt.)');
INSERT INTO cp_ville VALUES (602, 3384, 'Attenrode');
INSERT INTO cp_ville VALUES (603, 3390, 'Houwaart');
INSERT INTO cp_ville VALUES (604, 3390, 'Sint-Joris-Winge');
INSERT INTO cp_ville VALUES (605, 3390, 'Tielt (Bt.)');
INSERT INTO cp_ville VALUES (606, 3390, 'Tielt-Winge');
INSERT INTO cp_ville VALUES (607, 3391, 'Meensel-Kiezegem');
INSERT INTO cp_ville VALUES (608, 3400, 'Eliksem');
INSERT INTO cp_ville VALUES (609, 3400, 'Ezemaal');
INSERT INTO cp_ville VALUES (610, 3400, 'Laar');
INSERT INTO cp_ville VALUES (611, 3400, 'Landen');
INSERT INTO cp_ville VALUES (612, 3400, 'Neerwinden');
INSERT INTO cp_ville VALUES (613, 3400, 'Overwinden');
INSERT INTO cp_ville VALUES (614, 3400, 'Rumsdorp');
INSERT INTO cp_ville VALUES (615, 3400, 'Wange');
INSERT INTO cp_ville VALUES (616, 3401, 'Waasmont');
INSERT INTO cp_ville VALUES (617, 3401, 'Walsbets');
INSERT INTO cp_ville VALUES (618, 3401, 'Walshoutem');
INSERT INTO cp_ville VALUES (619, 3401, 'Wezeren');
INSERT INTO cp_ville VALUES (620, 3404, 'Attenhoven');
INSERT INTO cp_ville VALUES (621, 3404, 'Neerlanden');
INSERT INTO cp_ville VALUES (622, 3440, 'Budingen');
INSERT INTO cp_ville VALUES (623, 3440, 'Dormaal');
INSERT INTO cp_ville VALUES (624, 3440, 'Halle-Booienhoven');
INSERT INTO cp_ville VALUES (625, 3440, 'Helen-Bos');
INSERT INTO cp_ville VALUES (626, 3440, 'Zoutleeuw');
INSERT INTO cp_ville VALUES (627, 3450, 'Geetbets');
INSERT INTO cp_ville VALUES (628, 3450, 'Grazen');
INSERT INTO cp_ville VALUES (629, 3454, 'Rummen');
INSERT INTO cp_ville VALUES (630, 3460, 'Assent');
INSERT INTO cp_ville VALUES (631, 3460, 'Bekkevoort');
INSERT INTO cp_ville VALUES (632, 3461, 'Molenbeek-Wersbeek');
INSERT INTO cp_ville VALUES (633, 3470, 'Kortenaken');
INSERT INTO cp_ville VALUES (634, 3470, 'Ransberg');
INSERT INTO cp_ville VALUES (635, 3471, 'Hoeleden');
INSERT INTO cp_ville VALUES (636, 3472, 'Kersbeek-Miskom');
INSERT INTO cp_ville VALUES (637, 3473, 'Waanrode');
INSERT INTO cp_ville VALUES (638, 3500, 'Hasselt');
INSERT INTO cp_ville VALUES (639, 3500, 'Sint-Lambrechts-Herk');
INSERT INTO cp_ville VALUES (640, 3501, 'Wimmertingen');
INSERT INTO cp_ville VALUES (641, 3510, 'Kermt (Hasselt)');
INSERT INTO cp_ville VALUES (642, 3510, 'Spalbeek');
INSERT INTO cp_ville VALUES (643, 3511, 'Kuringen');
INSERT INTO cp_ville VALUES (644, 3511, 'Stokrooie');
INSERT INTO cp_ville VALUES (645, 3512, 'Stevoort');
INSERT INTO cp_ville VALUES (646, 3520, 'Zonhoven');
INSERT INTO cp_ville VALUES (647, 3530, 'Helchteren');
INSERT INTO cp_ville VALUES (648, 3530, 'Houthalen');
INSERT INTO cp_ville VALUES (649, 3530, 'Houthalen-Helchteren');
INSERT INTO cp_ville VALUES (650, 3540, 'Berbroek');
INSERT INTO cp_ville VALUES (651, 3540, 'Donk');
INSERT INTO cp_ville VALUES (652, 3540, 'Herk-de-Stad');
INSERT INTO cp_ville VALUES (653, 3540, 'Schulen');
INSERT INTO cp_ville VALUES (654, 3545, 'Halen');
INSERT INTO cp_ville VALUES (655, 3545, 'Loksbergen');
INSERT INTO cp_ville VALUES (656, 3545, 'Zelem');
INSERT INTO cp_ville VALUES (657, 3550, 'Heusden (Limb.)');
INSERT INTO cp_ville VALUES (658, 3550, 'Heusden-Zolder');
INSERT INTO cp_ville VALUES (659, 3550, 'Zolder');
INSERT INTO cp_ville VALUES (660, 3560, 'Linkhout');
INSERT INTO cp_ville VALUES (661, 3560, 'Lummen');
INSERT INTO cp_ville VALUES (662, 3560, 'Meldert (Limb.)');
INSERT INTO cp_ville VALUES (663, 3570, 'Alken');
INSERT INTO cp_ville VALUES (664, 3580, 'Beringen');
INSERT INTO cp_ville VALUES (665, 3581, 'Beverlo');
INSERT INTO cp_ville VALUES (666, 3582, 'Koersel');
INSERT INTO cp_ville VALUES (667, 3583, 'Paal');
INSERT INTO cp_ville VALUES (668, 3590, 'Diepenbeek');
INSERT INTO cp_ville VALUES (669, 3600, 'Genk');
INSERT INTO cp_ville VALUES (670, 3620, 'Gellik');
INSERT INTO cp_ville VALUES (671, 3620, 'Lanaken');
INSERT INTO cp_ville VALUES (672, 3620, 'Neerharen');
INSERT INTO cp_ville VALUES (673, 3620, 'Veldwezelt');
INSERT INTO cp_ville VALUES (674, 3621, 'Rekem');
INSERT INTO cp_ville VALUES (675, 3630, 'Eisden');
INSERT INTO cp_ville VALUES (676, 3630, 'Leut');
INSERT INTO cp_ville VALUES (677, 3630, 'Maasmechelen');
INSERT INTO cp_ville VALUES (678, 3630, 'Mechelen-aan-de-Maas');
INSERT INTO cp_ville VALUES (679, 3630, 'Meeswijk');
INSERT INTO cp_ville VALUES (680, 3630, 'Opgrimbie');
INSERT INTO cp_ville VALUES (681, 3630, 'Vucht');
INSERT INTO cp_ville VALUES (682, 3631, 'Boorsem');
INSERT INTO cp_ville VALUES (683, 3631, 'Uikhoven');
INSERT INTO cp_ville VALUES (684, 3640, 'Kessenich');
INSERT INTO cp_ville VALUES (685, 3640, 'Kinrooi');
INSERT INTO cp_ville VALUES (686, 3640, 'Molenbeersel');
INSERT INTO cp_ville VALUES (687, 3640, 'Ophoven');
INSERT INTO cp_ville VALUES (688, 3650, 'Dilsen-Stokkem');
INSERT INTO cp_ville VALUES (689, 3650, 'Elen');
INSERT INTO cp_ville VALUES (690, 3650, 'Lanklaar');
INSERT INTO cp_ville VALUES (691, 3650, 'Rotem');
INSERT INTO cp_ville VALUES (692, 3650, 'Stokkem');
INSERT INTO cp_ville VALUES (693, 3660, 'Opglabbeek');
INSERT INTO cp_ville VALUES (694, 3665, 'As');
INSERT INTO cp_ville VALUES (695, 3668, 'Niel-bij-As');
INSERT INTO cp_ville VALUES (696, 3670, 'Ellikom');
INSERT INTO cp_ville VALUES (697, 3670, 'Gruitrode');
INSERT INTO cp_ville VALUES (698, 3670, 'Meeuwen');
INSERT INTO cp_ville VALUES (699, 3670, 'Meeuwen-Gruitrode');
INSERT INTO cp_ville VALUES (700, 3670, 'Neerglabbeek');
INSERT INTO cp_ville VALUES (701, 3670, 'Wijshagen');
INSERT INTO cp_ville VALUES (702, 3680, 'Maaseik');
INSERT INTO cp_ville VALUES (703, 3680, 'Neeroeteren');
INSERT INTO cp_ville VALUES (704, 3680, 'Opoeteren');
INSERT INTO cp_ville VALUES (705, 3690, 'Zutendaal');
INSERT INTO cp_ville VALUES (706, 3700, 'Berg (Limb.)');
INSERT INTO cp_ville VALUES (707, 3700, 'Diets-Heur');
INSERT INTO cp_ville VALUES (708, 3700, 'Haren (Tongeren)');
INSERT INTO cp_ville VALUES (709, 3700, 'Henis');
INSERT INTO cp_ville VALUES (710, 3700, 'Kolmont (Tongeren)');
INSERT INTO cp_ville VALUES (711, 3700, 'Koninksem');
INSERT INTO cp_ville VALUES (712, 3700, 'Lauw');
INSERT INTO cp_ville VALUES (713, 3700, 'Mal');
INSERT INTO cp_ville VALUES (714, 3700, 'Neerrepen');
INSERT INTO cp_ville VALUES (715, 3700, 'Nerem');
INSERT INTO cp_ville VALUES (716, 3700, 'Overrepen (Kolmont)');
INSERT INTO cp_ville VALUES (717, 3700, 'Piringen (Haren)');
INSERT INTO cp_ville VALUES (718, 3700, 'Riksingen');
INSERT INTO cp_ville VALUES (719, 3700, 'Rutten');
INSERT INTO cp_ville VALUES (720, 3700, 's Herenelderen');
INSERT INTO cp_ville VALUES (721, 3700, 'Sluizen');
INSERT INTO cp_ville VALUES (722, 3700, 'Tongeren');
INSERT INTO cp_ville VALUES (723, 3700, 'Vreren');
INSERT INTO cp_ville VALUES (724, 3700, 'Widooie (Haren)');
INSERT INTO cp_ville VALUES (725, 3717, 'Herstappe');
INSERT INTO cp_ville VALUES (726, 3720, 'Kortessem');
INSERT INTO cp_ville VALUES (727, 3721, 'Vliermaalroot');
INSERT INTO cp_ville VALUES (728, 3722, 'Wintershoven');
INSERT INTO cp_ville VALUES (729, 3723, 'Guigoven');
INSERT INTO cp_ville VALUES (730, 3724, 'Vliermaal');
INSERT INTO cp_ville VALUES (731, 3730, 'Hoeselt');
INSERT INTO cp_ville VALUES (732, 3730, 'Romershoven');
INSERT INTO cp_ville VALUES (733, 3730, 'Sint-Huibrechts-Hern');
INSERT INTO cp_ville VALUES (734, 3730, 'Werm');
INSERT INTO cp_ville VALUES (735, 3732, 'Schalkhoven');
INSERT INTO cp_ville VALUES (736, 3740, 'Beverst');
INSERT INTO cp_ville VALUES (737, 3740, 'Bilzen');
INSERT INTO cp_ville VALUES (738, 3740, 'Eigenbilzen');
INSERT INTO cp_ville VALUES (739, 3740, 'Grote-Spouwen');
INSERT INTO cp_ville VALUES (740, 3740, 'Hees');
INSERT INTO cp_ville VALUES (741, 3740, 'Kleine-Spouwen');
INSERT INTO cp_ville VALUES (742, 3740, 'Mopertingen');
INSERT INTO cp_ville VALUES (743, 3740, 'Munsterbilzen');
INSERT INTO cp_ville VALUES (744, 3740, 'Rijkhoven');
INSERT INTO cp_ville VALUES (745, 3740, 'Rosmeer');
INSERT INTO cp_ville VALUES (746, 3740, 'Spouwen');
INSERT INTO cp_ville VALUES (747, 3740, 'Waltwilder');
INSERT INTO cp_ville VALUES (748, 3742, 'Martenslinde');
INSERT INTO cp_ville VALUES (749, 3746, 'Hoelbeek');
INSERT INTO cp_ville VALUES (750, 3770, 'Genoelselderen');
INSERT INTO cp_ville VALUES (751, 3770, 'Herderen');
INSERT INTO cp_ville VALUES (752, 3770, 'Kanne');
INSERT INTO cp_ville VALUES (753, 3770, 'Membruggen');
INSERT INTO cp_ville VALUES (754, 3770, 'Millen');
INSERT INTO cp_ville VALUES (755, 3770, 'Riemst');
INSERT INTO cp_ville VALUES (756, 3770, 'Val-Meer');
INSERT INTO cp_ville VALUES (757, 3770, 'Vlijtingen');
INSERT INTO cp_ville VALUES (758, 3770, 'Vroenhoven');
INSERT INTO cp_ville VALUES (759, 3770, 'Zichen-Zussen-Bolder');
INSERT INTO cp_ville VALUES (760, 3790, 'Fourons');
INSERT INTO cp_ville VALUES (761, 3790, 'Fouron-Saint-Martin');
INSERT INTO cp_ville VALUES (762, 3790, 'Moelingen');
INSERT INTO cp_ville VALUES (763, 3790, 'Mouland');
INSERT INTO cp_ville VALUES (764, 3790, 'Sint-Martens-Voeren');
INSERT INTO cp_ville VALUES (765, 3790, 'Voeren');
INSERT INTO cp_ville VALUES (766, 3791, 'Remersdaal');
INSERT INTO cp_ville VALUES (767, 3792, 'Fouron-Saint-Pierre');
INSERT INTO cp_ville VALUES (768, 3792, 'Sint-Pieters-Voeren');
INSERT INTO cp_ville VALUES (769, 3793, 'Teuven');
INSERT INTO cp_ville VALUES (770, 3798, 'Fouron-le-Comte');
INSERT INTO cp_ville VALUES (771, 3798, 's Gravenvoeren');
INSERT INTO cp_ville VALUES (772, 3800, 'Aalst (Limb.)');
INSERT INTO cp_ville VALUES (773, 3800, 'Brustem');
INSERT INTO cp_ville VALUES (774, 3800, 'Engelmanshoven');
INSERT INTO cp_ville VALUES (775, 3800, 'Gelinden');
INSERT INTO cp_ville VALUES (776, 3800, 'Groot-Gelmen');
INSERT INTO cp_ville VALUES (777, 3800, 'Halmaal');
INSERT INTO cp_ville VALUES (778, 3800, 'Kerkom-bij-Sint-Truiden');
INSERT INTO cp_ville VALUES (779, 3800, 'Ordingen');
INSERT INTO cp_ville VALUES (780, 3800, 'Sint-Truiden');
INSERT INTO cp_ville VALUES (781, 3800, 'Zepperen');
INSERT INTO cp_ville VALUES (782, 3803, 'Duras');
INSERT INTO cp_ville VALUES (783, 3803, 'Gorsem');
INSERT INTO cp_ville VALUES (784, 3803, 'Runkelen');
INSERT INTO cp_ville VALUES (785, 3803, 'Wilderen');
INSERT INTO cp_ville VALUES (786, 3806, 'Velm');
INSERT INTO cp_ville VALUES (787, 3830, 'Berlingen');
INSERT INTO cp_ville VALUES (788, 3830, 'Wellen');
INSERT INTO cp_ville VALUES (789, 3831, 'Herten');
INSERT INTO cp_ville VALUES (790, 3832, 'Ulbeek');
INSERT INTO cp_ville VALUES (791, 3840, 'Bommershoven (Haren)');
INSERT INTO cp_ville VALUES (792, 3840, 'Borgloon');
INSERT INTO cp_ville VALUES (793, 3840, 'Broekom');
INSERT INTO cp_ville VALUES (794, 3840, 'Gors-Opleeuw');
INSERT INTO cp_ville VALUES (795, 3840, 'Gotem');
INSERT INTO cp_ville VALUES (796, 3840, 'Groot-Loon');
INSERT INTO cp_ville VALUES (797, 3840, 'Haren (Borgloon)');
INSERT INTO cp_ville VALUES (798, 3840, 'Hendrieken');
INSERT INTO cp_ville VALUES (799, 3840, 'Hoepertingen');
INSERT INTO cp_ville VALUES (800, 3840, 'Jesseren (Kolmont)');
INSERT INTO cp_ville VALUES (801, 3840, 'Kerniel');
INSERT INTO cp_ville VALUES (802, 3840, 'Kolmont (Borgloon)');
INSERT INTO cp_ville VALUES (803, 3840, 'Kuttekoven');
INSERT INTO cp_ville VALUES (804, 3840, 'Rijkel');
INSERT INTO cp_ville VALUES (805, 3840, 'Voort');
INSERT INTO cp_ville VALUES (806, 3850, 'Binderveld');
INSERT INTO cp_ville VALUES (807, 3850, 'Kozen');
INSERT INTO cp_ville VALUES (808, 3850, 'Nieuwerkerken (Limb.)');
INSERT INTO cp_ville VALUES (809, 3850, 'Wijer');
INSERT INTO cp_ville VALUES (810, 3870, 'Batsheers');
INSERT INTO cp_ville VALUES (811, 3870, 'Bovelingen');
INSERT INTO cp_ville VALUES (812, 3870, 'Gutschoven');
INSERT INTO cp_ville VALUES (813, 3870, 'Heers');
INSERT INTO cp_ville VALUES (814, 3870, 'Heks');
INSERT INTO cp_ville VALUES (815, 3870, 'Horpmaal');
INSERT INTO cp_ville VALUES (816, 3870, 'Klein-Gelmen');
INSERT INTO cp_ville VALUES (817, 3870, 'Mechelen-Bovelingen');
INSERT INTO cp_ville VALUES (818, 3870, 'Mettekoven');
INSERT INTO cp_ville VALUES (819, 3870, 'Opheers');
INSERT INTO cp_ville VALUES (820, 3870, 'Rukkelingen-Loon');
INSERT INTO cp_ville VALUES (821, 3870, 'Vechmaal');
INSERT INTO cp_ville VALUES (822, 3870, 'Veulen');
INSERT INTO cp_ville VALUES (823, 3890, 'Boekhout');
INSERT INTO cp_ville VALUES (824, 3890, 'Gingelom');
INSERT INTO cp_ville VALUES (825, 3890, 'Jeuk');
INSERT INTO cp_ville VALUES (826, 3890, 'Kortijs');
INSERT INTO cp_ville VALUES (827, 3890, 'Montenaken');
INSERT INTO cp_ville VALUES (828, 3890, 'Niel-bij-Sint-Truiden');
INSERT INTO cp_ville VALUES (829, 3890, 'Vorsen');
INSERT INTO cp_ville VALUES (830, 3891, 'Borlo');
INSERT INTO cp_ville VALUES (831, 3891, 'Buvingen');
INSERT INTO cp_ville VALUES (832, 3891, 'Mielen-Boven-Aalst');
INSERT INTO cp_ville VALUES (833, 3891, 'Muizen (Limb.)');
INSERT INTO cp_ville VALUES (834, 3900, 'Overpelt');
INSERT INTO cp_ville VALUES (835, 3910, 'Neerpelt');
INSERT INTO cp_ville VALUES (836, 3910, 'Sint-Huibrechts-Lille');
INSERT INTO cp_ville VALUES (837, 3920, 'Lommel');
INSERT INTO cp_ville VALUES (838, 3930, 'Achel');
INSERT INTO cp_ville VALUES (839, 3930, 'Hamont');
INSERT INTO cp_ville VALUES (840, 3930, 'Hamont-Achel');
INSERT INTO cp_ville VALUES (841, 3940, 'Hechtel');
INSERT INTO cp_ville VALUES (842, 3940, 'Hechtel-Eksel');
INSERT INTO cp_ville VALUES (843, 3941, 'Eksel');
INSERT INTO cp_ville VALUES (844, 3945, 'Ham');
INSERT INTO cp_ville VALUES (845, 3945, 'Kwaadmechelen');
INSERT INTO cp_ville VALUES (846, 3945, 'Oostham');
INSERT INTO cp_ville VALUES (847, 3950, 'Bocholt');
INSERT INTO cp_ville VALUES (848, 3950, 'Kaulille');
INSERT INTO cp_ville VALUES (849, 3950, 'Reppel');
INSERT INTO cp_ville VALUES (850, 3960, 'Beek');
INSERT INTO cp_ville VALUES (851, 3960, 'Bree');
INSERT INTO cp_ville VALUES (852, 3960, 'Gerdingen');
INSERT INTO cp_ville VALUES (853, 3960, 'Opitter');
INSERT INTO cp_ville VALUES (854, 3960, 'Tongerlo (Limb.)');
INSERT INTO cp_ville VALUES (855, 3970, 'Leopoldsburg');
INSERT INTO cp_ville VALUES (856, 3971, 'Heppen');
INSERT INTO cp_ville VALUES (857, 3980, 'Tessenderlo');
INSERT INTO cp_ville VALUES (858, 3990, 'Grote-Brogel');
INSERT INTO cp_ville VALUES (859, 3990, 'Kleine-Brogel');
INSERT INTO cp_ville VALUES (860, 3990, 'Peer');
INSERT INTO cp_ville VALUES (861, 3990, 'Wijchmaal');
INSERT INTO cp_ville VALUES (862, 4000, 'Glain');
INSERT INTO cp_ville VALUES (863, 4000, 'Liège');
INSERT INTO cp_ville VALUES (864, 4000, 'Rocourt');
INSERT INTO cp_ville VALUES (865, 4020, 'Bressoux');
INSERT INTO cp_ville VALUES (866, 4020, 'Jupille-sur-Meuse');
INSERT INTO cp_ville VALUES (867, 4020, 'Liège');
INSERT INTO cp_ville VALUES (868, 4020, 'Wandre');
INSERT INTO cp_ville VALUES (869, 4030, 'Grivegnée');
INSERT INTO cp_ville VALUES (870, 4030, 'Liège');
INSERT INTO cp_ville VALUES (871, 4031, 'Angleur');
INSERT INTO cp_ville VALUES (872, 4032, 'Chênée');
INSERT INTO cp_ville VALUES (873, 4040, 'Herstal');
INSERT INTO cp_ville VALUES (874, 4041, 'Milmort');
INSERT INTO cp_ville VALUES (875, 4041, 'Vottem');
INSERT INTO cp_ville VALUES (876, 4042, 'Liers');
INSERT INTO cp_ville VALUES (877, 4050, 'Chaudfontaine');
INSERT INTO cp_ville VALUES (878, 4051, 'Vaux-sous-Chèvremont');
INSERT INTO cp_ville VALUES (879, 4052, 'Beaufays');
INSERT INTO cp_ville VALUES (880, 4053, 'Embourg');
INSERT INTO cp_ville VALUES (881, 4090, 'B.S.D. (Belg. Strijdkr. Duitsland)');
INSERT INTO cp_ville VALUES (882, 4090, 'F.B.A. (Forces Belges en Allemagne)');
INSERT INTO cp_ville VALUES (883, 4100, 'Boncelles');
INSERT INTO cp_ville VALUES (884, 4100, 'Seraing');
INSERT INTO cp_ville VALUES (885, 4101, 'Jemeppe-sur-Meuse');
INSERT INTO cp_ville VALUES (886, 4102, 'Ougrée');
INSERT INTO cp_ville VALUES (887, 4120, 'Ehein');
INSERT INTO cp_ville VALUES (888, 4120, 'Neupré');
INSERT INTO cp_ville VALUES (889, 4120, 'Rotheux-Rimière');
INSERT INTO cp_ville VALUES (890, 4121, 'Neuville-en-Condroz');
INSERT INTO cp_ville VALUES (891, 4122, 'Plainevaux');
INSERT INTO cp_ville VALUES (892, 4130, 'Esneux');
INSERT INTO cp_ville VALUES (893, 4130, 'Tilff');
INSERT INTO cp_ville VALUES (894, 4140, 'Dolembreux');
INSERT INTO cp_ville VALUES (895, 4140, 'Gomzé-Andoumont');
INSERT INTO cp_ville VALUES (896, 4140, 'Rouvreux');
INSERT INTO cp_ville VALUES (897, 4140, 'Sprimont');
INSERT INTO cp_ville VALUES (898, 4141, 'Louveigné');
INSERT INTO cp_ville VALUES (899, 4160, 'Anthisnes');
INSERT INTO cp_ville VALUES (900, 4161, 'Villers-aux-Tours');
INSERT INTO cp_ville VALUES (901, 4162, 'Hody');
INSERT INTO cp_ville VALUES (902, 4163, 'Tavier');
INSERT INTO cp_ville VALUES (903, 4170, 'Comblain-au-Pont');
INSERT INTO cp_ville VALUES (904, 4171, 'Poulseur');
INSERT INTO cp_ville VALUES (905, 4180, 'Comblain-Fairon');
INSERT INTO cp_ville VALUES (906, 4180, 'Comblain-la-Tour');
INSERT INTO cp_ville VALUES (907, 4180, 'Hamoir');
INSERT INTO cp_ville VALUES (908, 4181, 'Filot');
INSERT INTO cp_ville VALUES (909, 4190, 'Ferrières');
INSERT INTO cp_ville VALUES (910, 4190, 'My');
INSERT INTO cp_ville VALUES (911, 4190, 'Vieuxville');
INSERT INTO cp_ville VALUES (912, 4190, 'Werbomont');
INSERT INTO cp_ville VALUES (913, 4190, 'Xhoris');
INSERT INTO cp_ville VALUES (914, 4210, 'Burdinne');
INSERT INTO cp_ville VALUES (915, 4210, 'Hannêche');
INSERT INTO cp_ville VALUES (916, 4210, 'Lamontzée');
INSERT INTO cp_ville VALUES (917, 4210, 'Marneffe');
INSERT INTO cp_ville VALUES (918, 4210, 'Oteppe');
INSERT INTO cp_ville VALUES (919, 4217, 'Héron');
INSERT INTO cp_ville VALUES (920, 4217, 'Lavoir');
INSERT INTO cp_ville VALUES (921, 4217, 'Waret-l\'Evêque');
INSERT INTO cp_ville VALUES (922, 4218, 'Couthuin');
INSERT INTO cp_ville VALUES (923, 4219, 'Acosse');
INSERT INTO cp_ville VALUES (924, 4219, 'Ambresin');
INSERT INTO cp_ville VALUES (925, 4219, 'Meeffe');
INSERT INTO cp_ville VALUES (926, 4219, 'Wasseiges');
INSERT INTO cp_ville VALUES (927, 4250, 'Boëlhe');
INSERT INTO cp_ville VALUES (928, 4250, 'Geer');
INSERT INTO cp_ville VALUES (929, 4250, 'Hollogne-sur-Geer');
INSERT INTO cp_ville VALUES (930, 4250, 'Lens-Saint-Servais');
INSERT INTO cp_ville VALUES (931, 4252, 'Omal');
INSERT INTO cp_ville VALUES (932, 4253, 'Darion');
INSERT INTO cp_ville VALUES (933, 4254, 'Ligney');
INSERT INTO cp_ville VALUES (934, 4257, 'Berloz');
INSERT INTO cp_ville VALUES (935, 4257, 'Corswarem');
INSERT INTO cp_ville VALUES (936, 4257, 'Rosoux-Crenwick');
INSERT INTO cp_ville VALUES (937, 4260, 'Avennes');
INSERT INTO cp_ville VALUES (938, 4260, 'Braives');
INSERT INTO cp_ville VALUES (939, 4260, 'Ciplet');
INSERT INTO cp_ville VALUES (940, 4260, 'Fallais');
INSERT INTO cp_ville VALUES (941, 4260, 'Fumal');
INSERT INTO cp_ville VALUES (942, 4260, 'Ville-en-Hesbaye');
INSERT INTO cp_ville VALUES (943, 4261, 'Latinne');
INSERT INTO cp_ville VALUES (944, 4263, 'Tourinne (Lg.)');
INSERT INTO cp_ville VALUES (945, 4280, 'Abolens');
INSERT INTO cp_ville VALUES (946, 4280, 'Avernas-le-Bauduin');
INSERT INTO cp_ville VALUES (947, 4280, 'Avin');
INSERT INTO cp_ville VALUES (948, 4280, 'Bertrée');
INSERT INTO cp_ville VALUES (949, 4280, 'Blehen');
INSERT INTO cp_ville VALUES (950, 4280, 'Cras-Avernas');
INSERT INTO cp_ville VALUES (951, 4280, 'Crehen');
INSERT INTO cp_ville VALUES (952, 4280, 'Grand-Hallet');
INSERT INTO cp_ville VALUES (953, 4280, 'Hannut');
INSERT INTO cp_ville VALUES (954, 4280, 'Lens-Saint-Remy');
INSERT INTO cp_ville VALUES (955, 4280, 'Merdorp');
INSERT INTO cp_ville VALUES (956, 4280, 'Moxhe');
INSERT INTO cp_ville VALUES (957, 4280, 'Petit-Hallet');
INSERT INTO cp_ville VALUES (958, 4280, 'Poucet');
INSERT INTO cp_ville VALUES (959, 4280, 'Thisnes');
INSERT INTO cp_ville VALUES (960, 4280, 'Trognée');
INSERT INTO cp_ville VALUES (961, 4280, 'Villers-le-Peuplier');
INSERT INTO cp_ville VALUES (962, 4280, 'Wansin');
INSERT INTO cp_ville VALUES (963, 4287, 'Lincent');
INSERT INTO cp_ville VALUES (964, 4287, 'Pellaines');
INSERT INTO cp_ville VALUES (965, 4287, 'Racour');
INSERT INTO cp_ville VALUES (966, 4300, 'Bettincourt');
INSERT INTO cp_ville VALUES (967, 4300, 'Bleret');
INSERT INTO cp_ville VALUES (968, 4300, 'Bovenistier');
INSERT INTO cp_ville VALUES (969, 4300, 'Grand-Axhe');
INSERT INTO cp_ville VALUES (970, 4300, 'Lantremange');
INSERT INTO cp_ville VALUES (971, 4300, 'Oleye');
INSERT INTO cp_ville VALUES (972, 4300, 'Waremme');
INSERT INTO cp_ville VALUES (973, 4317, 'Aineffe');
INSERT INTO cp_ville VALUES (974, 4317, 'Borlez');
INSERT INTO cp_ville VALUES (975, 4317, 'Celles (Lg.)');
INSERT INTO cp_ville VALUES (976, 4317, 'Faimes');
INSERT INTO cp_ville VALUES (977, 4317, 'Les Waleffes');
INSERT INTO cp_ville VALUES (978, 4317, 'Viemme');
INSERT INTO cp_ville VALUES (979, 4340, 'Awans');
INSERT INTO cp_ville VALUES (980, 4340, 'Fooz');
INSERT INTO cp_ville VALUES (981, 4340, 'Othée');
INSERT INTO cp_ville VALUES (982, 4340, 'Villers-l\'Evêque');
INSERT INTO cp_ville VALUES (983, 4342, 'Hognoul');
INSERT INTO cp_ville VALUES (984, 4347, 'Fexhe-le-Haut-Clocher');
INSERT INTO cp_ville VALUES (985, 4347, 'Freloux');
INSERT INTO cp_ville VALUES (986, 4347, 'Noville (Lg.)');
INSERT INTO cp_ville VALUES (987, 4347, 'Roloux');
INSERT INTO cp_ville VALUES (988, 4347, 'Voroux-Goreux');
INSERT INTO cp_ville VALUES (989, 4350, 'Lamine');
INSERT INTO cp_ville VALUES (990, 4350, 'Momalle');
INSERT INTO cp_ville VALUES (991, 4350, 'Pousset');
INSERT INTO cp_ville VALUES (992, 4350, 'Remicourt');
INSERT INTO cp_ville VALUES (993, 4351, 'Hodeige');
INSERT INTO cp_ville VALUES (994, 4357, 'Donceel');
INSERT INTO cp_ville VALUES (995, 4357, 'Haneffe');
INSERT INTO cp_ville VALUES (996, 4357, 'Jeneffe (Lg.)');
INSERT INTO cp_ville VALUES (997, 4357, 'Limont');
INSERT INTO cp_ville VALUES (998, 4360, 'Bergilers');
INSERT INTO cp_ville VALUES (999, 4360, 'Grandville');
INSERT INTO cp_ville VALUES (1000, 4360, 'Lens-sur-Geer');
INSERT INTO cp_ville VALUES (1001, 4360, 'Oreye');
INSERT INTO cp_ville VALUES (1002, 4360, 'Otrange');
INSERT INTO cp_ville VALUES (1003, 4367, 'Crisnée');
INSERT INTO cp_ville VALUES (1004, 4367, 'Fize-le-Marsal');
INSERT INTO cp_ville VALUES (1005, 4367, 'Kemexhe');
INSERT INTO cp_ville VALUES (1006, 4367, 'Odeur');
INSERT INTO cp_ville VALUES (1007, 4367, 'Thys');
INSERT INTO cp_ville VALUES (1008, 4400, 'Awirs');
INSERT INTO cp_ville VALUES (1009, 4400, 'Chokier');
INSERT INTO cp_ville VALUES (1010, 4400, 'Flémalle');
INSERT INTO cp_ville VALUES (1011, 4400, 'Flémalle-Grande');
INSERT INTO cp_ville VALUES (1012, 4400, 'Flémalle-Haute');
INSERT INTO cp_ville VALUES (1013, 4400, 'Gleixhe');
INSERT INTO cp_ville VALUES (1014, 4400, 'Ivoz-Ramet');
INSERT INTO cp_ville VALUES (1015, 4400, 'Mons-lez-Liège');
INSERT INTO cp_ville VALUES (1016, 4420, 'Montegnée');
INSERT INTO cp_ville VALUES (1017, 4420, 'Saint-Nicolas (Lg.)');
INSERT INTO cp_ville VALUES (1018, 4420, 'Tilleur');
INSERT INTO cp_ville VALUES (1019, 4430, 'Ans');
INSERT INTO cp_ville VALUES (1020, 4431, 'Loncin');
INSERT INTO cp_ville VALUES (1021, 4432, 'Alleur');
INSERT INTO cp_ville VALUES (1022, 4432, 'Xhendremael');
INSERT INTO cp_ville VALUES (1023, 4450, 'Juprelle');
INSERT INTO cp_ville VALUES (1024, 4450, 'Lantin');
INSERT INTO cp_ville VALUES (1025, 4450, 'Slins');
INSERT INTO cp_ville VALUES (1026, 4451, 'Voroux-lez-Liers');
INSERT INTO cp_ville VALUES (1027, 4452, 'Paifve');
INSERT INTO cp_ville VALUES (1028, 4452, 'Wihogne');
INSERT INTO cp_ville VALUES (1029, 4453, 'Villers-Saint-Siméon');
INSERT INTO cp_ville VALUES (1030, 4458, 'Fexhe-Slins');
INSERT INTO cp_ville VALUES (1031, 4460, 'Bierset');
INSERT INTO cp_ville VALUES (1032, 4460, 'Grâce-Berleur');
INSERT INTO cp_ville VALUES (1033, 4460, 'Grâce-Hollogne');
INSERT INTO cp_ville VALUES (1034, 4460, 'Hollogne-aux-Pierres');
INSERT INTO cp_ville VALUES (1035, 4460, 'Horion-Hozémont');
INSERT INTO cp_ville VALUES (1036, 4460, 'Velroux');
INSERT INTO cp_ville VALUES (1037, 4470, 'Saint-Georges-sur-Meuse');
INSERT INTO cp_ville VALUES (1038, 4480, 'Clermont-sous-Huy');
INSERT INTO cp_ville VALUES (1039, 4480, 'Engis');
INSERT INTO cp_ville VALUES (1040, 4480, 'Hermalle-sous-Huy');
INSERT INTO cp_ville VALUES (1041, 4500, 'Ben-Ahin');
INSERT INTO cp_ville VALUES (1042, 4500, 'Huy');
INSERT INTO cp_ville VALUES (1043, 4500, 'Tihange');
INSERT INTO cp_ville VALUES (1044, 4520, 'Antheit');
INSERT INTO cp_ville VALUES (1045, 4520, 'Bas-Oha');
INSERT INTO cp_ville VALUES (1046, 4520, 'Huccorgne');
INSERT INTO cp_ville VALUES (1047, 4520, 'Moha');
INSERT INTO cp_ville VALUES (1048, 4520, 'Vinalmont');
INSERT INTO cp_ville VALUES (1049, 4520, 'Wanze');
INSERT INTO cp_ville VALUES (1050, 4530, 'Fize-Fontaine');
INSERT INTO cp_ville VALUES (1051, 4530, 'Vaux-et-Borset');
INSERT INTO cp_ville VALUES (1052, 4530, 'Vieux-Waleffe');
INSERT INTO cp_ville VALUES (1053, 4530, 'Villers-le-Bouillet');
INSERT INTO cp_ville VALUES (1054, 4530, 'Warnant-Dreye');
INSERT INTO cp_ville VALUES (1055, 4537, 'Chapon-Seraing');
INSERT INTO cp_ville VALUES (1056, 4537, 'Seraing-le-Château');
INSERT INTO cp_ville VALUES (1057, 4537, 'Verlaine');
INSERT INTO cp_ville VALUES (1058, 4540, 'Amay');
INSERT INTO cp_ville VALUES (1059, 4540, 'Ampsin');
INSERT INTO cp_ville VALUES (1060, 4540, 'Flône');
INSERT INTO cp_ville VALUES (1061, 4540, 'Jehay');
INSERT INTO cp_ville VALUES (1062, 4540, 'Ombret');
INSERT INTO cp_ville VALUES (1063, 4550, 'Nandrin');
INSERT INTO cp_ville VALUES (1064, 4550, 'Saint-Séverin');
INSERT INTO cp_ville VALUES (1065, 4550, 'Villers-le-Temple');
INSERT INTO cp_ville VALUES (1066, 4550, 'Yernée-Fraineux');
INSERT INTO cp_ville VALUES (1067, 4557, 'Abée');
INSERT INTO cp_ville VALUES (1068, 4557, 'Fraiture');
INSERT INTO cp_ville VALUES (1069, 4557, 'Ramelot');
INSERT INTO cp_ville VALUES (1070, 4557, 'Seny');
INSERT INTO cp_ville VALUES (1071, 4557, 'Soheit-Tinlot');
INSERT INTO cp_ville VALUES (1072, 4557, 'Tinlot');
INSERT INTO cp_ville VALUES (1073, 4560, 'Bois-et-Borsu');
INSERT INTO cp_ville VALUES (1074, 4560, 'Clavier');
INSERT INTO cp_ville VALUES (1075, 4560, 'Les Avins');
INSERT INTO cp_ville VALUES (1076, 4560, 'Ocquier');
INSERT INTO cp_ville VALUES (1077, 4560, 'Pailhe');
INSERT INTO cp_ville VALUES (1078, 4560, 'Terwagne');
INSERT INTO cp_ville VALUES (1079, 4570, 'Marchin');
INSERT INTO cp_ville VALUES (1080, 4570, 'Vyle-et-Tharoul');
INSERT INTO cp_ville VALUES (1081, 4577, 'Modave');
INSERT INTO cp_ville VALUES (1082, 4577, 'Outrelouxhe');
INSERT INTO cp_ville VALUES (1083, 4577, 'Strée-lez-Huy');
INSERT INTO cp_ville VALUES (1084, 4577, 'Vierset-Barse');
INSERT INTO cp_ville VALUES (1085, 4590, 'Ellemelle');
INSERT INTO cp_ville VALUES (1086, 4590, 'Ouffet');
INSERT INTO cp_ville VALUES (1087, 4590, 'Warzée');
INSERT INTO cp_ville VALUES (1088, 4600, 'Lanaye');
INSERT INTO cp_ville VALUES (1089, 4600, 'Lixhe');
INSERT INTO cp_ville VALUES (1090, 4600, 'Richelle');
INSERT INTO cp_ville VALUES (1091, 4600, 'Visé');
INSERT INTO cp_ville VALUES (1092, 4601, 'Argenteau');
INSERT INTO cp_ville VALUES (1093, 4602, 'Cheratte');
INSERT INTO cp_ville VALUES (1094, 4606, 'Saint-André');
INSERT INTO cp_ville VALUES (1095, 4607, 'Berneau');
INSERT INTO cp_ville VALUES (1096, 4607, 'Bombaye');
INSERT INTO cp_ville VALUES (1097, 4607, 'Dalhem');
INSERT INTO cp_ville VALUES (1098, 4607, 'Feneur');
INSERT INTO cp_ville VALUES (1099, 4607, 'Mortroux');
INSERT INTO cp_ville VALUES (1100, 4608, 'Neufchâteau (Lg.)');
INSERT INTO cp_ville VALUES (1101, 4608, 'Warsage');
INSERT INTO cp_ville VALUES (1102, 4610, 'Bellaire');
INSERT INTO cp_ville VALUES (1103, 4610, 'Beyne-Heusay');
INSERT INTO cp_ville VALUES (1104, 4610, 'Queue-du-Bois');
INSERT INTO cp_ville VALUES (1105, 4620, 'Fléron');
INSERT INTO cp_ville VALUES (1106, 4621, 'Retinne');
INSERT INTO cp_ville VALUES (1107, 4623, 'Magnée');
INSERT INTO cp_ville VALUES (1108, 4624, 'Romsée');
INSERT INTO cp_ville VALUES (1109, 4630, 'Ayeneux');
INSERT INTO cp_ville VALUES (1110, 4630, 'Micheroux');
INSERT INTO cp_ville VALUES (1111, 4630, 'Soumagne');
INSERT INTO cp_ville VALUES (1112, 4630, 'Tignée');
INSERT INTO cp_ville VALUES (1113, 4631, 'Evegnée');
INSERT INTO cp_ville VALUES (1114, 4632, 'Cérexhe-Heuseux');
INSERT INTO cp_ville VALUES (1115, 4633, 'Melen');
INSERT INTO cp_ville VALUES (1116, 4650, 'Chaineux');
INSERT INTO cp_ville VALUES (1117, 4650, 'Grand-Rechain');
INSERT INTO cp_ville VALUES (1118, 4650, 'Herve');
INSERT INTO cp_ville VALUES (1119, 4650, 'Julémont');
INSERT INTO cp_ville VALUES (1120, 4651, 'Battice');
INSERT INTO cp_ville VALUES (1121, 4652, 'Xhendelesse');
INSERT INTO cp_ville VALUES (1122, 4653, 'Bolland');
INSERT INTO cp_ville VALUES (1123, 4654, 'Charneux');
INSERT INTO cp_ville VALUES (1124, 4670, 'Blégny');
INSERT INTO cp_ville VALUES (1125, 4670, 'Mortier');
INSERT INTO cp_ville VALUES (1126, 4670, 'Trembleur');
INSERT INTO cp_ville VALUES (1127, 4671, 'Barchon');
INSERT INTO cp_ville VALUES (1128, 4671, 'Housse');
INSERT INTO cp_ville VALUES (1129, 4671, 'Saive');
INSERT INTO cp_ville VALUES (1130, 4672, 'Saint-Remy (Lg.)');
INSERT INTO cp_ville VALUES (1131, 4680, 'Hermée');
INSERT INTO cp_ville VALUES (1132, 4680, 'Oupeye');
INSERT INTO cp_ville VALUES (1133, 4681, 'Hermalle-sous-Argenteau');
INSERT INTO cp_ville VALUES (1134, 4682, 'Heure-le-Romain');
INSERT INTO cp_ville VALUES (1135, 4682, 'Houtain-Saint-Siméon');
INSERT INTO cp_ville VALUES (1136, 4683, 'Vivegnis');
INSERT INTO cp_ville VALUES (1137, 4684, 'Haccourt');
INSERT INTO cp_ville VALUES (1138, 4690, 'Bassenge');
INSERT INTO cp_ville VALUES (1139, 4690, 'Boirs');
INSERT INTO cp_ville VALUES (1140, 4690, 'Eben-Emael');
INSERT INTO cp_ville VALUES (1141, 4690, 'Glons');
INSERT INTO cp_ville VALUES (1142, 4690, 'Roclenge-sur-Geer');
INSERT INTO cp_ville VALUES (1143, 4690, 'Wonck');
INSERT INTO cp_ville VALUES (1144, 4700, 'Eupen');
INSERT INTO cp_ville VALUES (1145, 4701, 'Kettenis');
INSERT INTO cp_ville VALUES (1146, 4710, 'Lontzen');
INSERT INTO cp_ville VALUES (1147, 4711, 'Walhorn');
INSERT INTO cp_ville VALUES (1148, 4720, 'Kelmis');
INSERT INTO cp_ville VALUES (1149, 4720, 'La Calamine');
INSERT INTO cp_ville VALUES (1150, 4721, 'Neu-Moresnet');
INSERT INTO cp_ville VALUES (1151, 4728, 'Hergenrath');
INSERT INTO cp_ville VALUES (1152, 4730, 'Hauset');
INSERT INTO cp_ville VALUES (1153, 4730, 'Raeren');
INSERT INTO cp_ville VALUES (1154, 4731, 'Eynatten');
INSERT INTO cp_ville VALUES (1155, 4750, 'Bütgenbach');
INSERT INTO cp_ville VALUES (1156, 4750, 'Butgenbach');
INSERT INTO cp_ville VALUES (1157, 4750, 'Elsenborn');
INSERT INTO cp_ville VALUES (1158, 4760, 'Bullange');
INSERT INTO cp_ville VALUES (1159, 4760, 'Büllingen');
INSERT INTO cp_ville VALUES (1160, 4760, 'Manderfeld');
INSERT INTO cp_ville VALUES (1161, 4761, 'Rocherath');
INSERT INTO cp_ville VALUES (1162, 4770, 'Amblève');
INSERT INTO cp_ville VALUES (1163, 4770, 'Amel');
INSERT INTO cp_ville VALUES (1164, 4770, 'Meyerode');
INSERT INTO cp_ville VALUES (1165, 4771, 'Heppenbach');
INSERT INTO cp_ville VALUES (1166, 4780, 'Recht');
INSERT INTO cp_ville VALUES (1167, 4780, 'Saint-Vith');
INSERT INTO cp_ville VALUES (1168, 4780, 'Sankt Vith');
INSERT INTO cp_ville VALUES (1169, 4782, 'Schoenberg');
INSERT INTO cp_ville VALUES (1170, 4782, 'Schönberg');
INSERT INTO cp_ville VALUES (1171, 4783, 'Lommersweiler');
INSERT INTO cp_ville VALUES (1172, 4784, 'Crombach');
INSERT INTO cp_ville VALUES (1173, 4790, 'Burg-Reuland');
INSERT INTO cp_ville VALUES (1174, 4790, 'Reuland');
INSERT INTO cp_ville VALUES (1175, 4791, 'Thommen');
INSERT INTO cp_ville VALUES (1176, 4800, 'Ensival');
INSERT INTO cp_ville VALUES (1177, 4800, 'Lambermont');
INSERT INTO cp_ville VALUES (1178, 4800, 'Petit-Rechain');
INSERT INTO cp_ville VALUES (1179, 4800, 'Verviers');
INSERT INTO cp_ville VALUES (1180, 4801, 'Stembert');
INSERT INTO cp_ville VALUES (1181, 4802, 'Heusy');
INSERT INTO cp_ville VALUES (1182, 4820, 'Dison');
INSERT INTO cp_ville VALUES (1183, 4821, 'Andrimont');
INSERT INTO cp_ville VALUES (1184, 4830, 'Limbourg');
INSERT INTO cp_ville VALUES (1185, 4831, 'Bilstain');
INSERT INTO cp_ville VALUES (1186, 4834, 'Goé');
INSERT INTO cp_ville VALUES (1187, 4837, 'Baelen (Lg.)');
INSERT INTO cp_ville VALUES (1188, 4837, 'Membach');
INSERT INTO cp_ville VALUES (1189, 4840, 'Welkenraedt');
INSERT INTO cp_ville VALUES (1190, 4841, 'Henri-Chapelle');
INSERT INTO cp_ville VALUES (1191, 4845, 'Jalhay');
INSERT INTO cp_ville VALUES (1192, 4845, 'Sart-lez-Spa');
INSERT INTO cp_ville VALUES (1193, 4850, 'Montzen');
INSERT INTO cp_ville VALUES (1194, 4850, 'Moresnet');
INSERT INTO cp_ville VALUES (1195, 4850, 'Plombières');
INSERT INTO cp_ville VALUES (1196, 4851, 'Gemmenich');
INSERT INTO cp_ville VALUES (1197, 4851, 'Sippenaeken');
INSERT INTO cp_ville VALUES (1198, 4852, 'Hombourg');
INSERT INTO cp_ville VALUES (1199, 4860, 'Cornesse');
INSERT INTO cp_ville VALUES (1200, 4860, 'Pepinster');
INSERT INTO cp_ville VALUES (1201, 4860, 'Wegnez');
INSERT INTO cp_ville VALUES (1202, 4861, 'Soiron');
INSERT INTO cp_ville VALUES (1203, 4870, 'Forêt');
INSERT INTO cp_ville VALUES (1204, 4870, 'Fraipont');
INSERT INTO cp_ville VALUES (1205, 4870, 'Nessonvaux');
INSERT INTO cp_ville VALUES (1206, 4870, 'Trooz');
INSERT INTO cp_ville VALUES (1207, 4877, 'Olne');
INSERT INTO cp_ville VALUES (1208, 4880, 'Aubel');
INSERT INTO cp_ville VALUES (1209, 4890, 'Clermont (Lg.)');
INSERT INTO cp_ville VALUES (1210, 4890, 'Thimister');
INSERT INTO cp_ville VALUES (1211, 4890, 'Thimister-Clermont');
INSERT INTO cp_ville VALUES (1212, 4900, 'Spa');
INSERT INTO cp_ville VALUES (1213, 4910, 'La Reid');
INSERT INTO cp_ville VALUES (1214, 4910, 'Polleur');
INSERT INTO cp_ville VALUES (1215, 4910, 'Theux');
INSERT INTO cp_ville VALUES (1216, 4920, 'Aywaille');
INSERT INTO cp_ville VALUES (1217, 4920, 'Ernonheid');
INSERT INTO cp_ville VALUES (1218, 4920, 'Harzé');
INSERT INTO cp_ville VALUES (1219, 4920, 'Sougné-Remouchamps');
INSERT INTO cp_ville VALUES (1220, 4950, 'Faymonville');
INSERT INTO cp_ville VALUES (1221, 4950, 'Robertville');
INSERT INTO cp_ville VALUES (1222, 4950, 'Sourbrodt');
INSERT INTO cp_ville VALUES (1223, 4950, 'Waimes');
INSERT INTO cp_ville VALUES (1224, 4950, 'Weismes');
INSERT INTO cp_ville VALUES (1225, 4960, 'Bellevaux-Ligneuville');
INSERT INTO cp_ville VALUES (1226, 4960, 'Bevercé');
INSERT INTO cp_ville VALUES (1227, 4960, 'Malmedy');
INSERT INTO cp_ville VALUES (1228, 4970, 'Francorchamps');
INSERT INTO cp_ville VALUES (1229, 4970, 'Stavelot');
INSERT INTO cp_ville VALUES (1230, 4980, 'Fosse (Lg.)');
INSERT INTO cp_ville VALUES (1231, 4980, 'Trois-Ponts');
INSERT INTO cp_ville VALUES (1232, 4980, 'Wanne');
INSERT INTO cp_ville VALUES (1233, 4983, 'Basse-Bodeux');
INSERT INTO cp_ville VALUES (1234, 4987, 'Chevron');
INSERT INTO cp_ville VALUES (1235, 4987, 'La Gleize');
INSERT INTO cp_ville VALUES (1236, 4987, 'Lorcé');
INSERT INTO cp_ville VALUES (1237, 4987, 'Rahier');
INSERT INTO cp_ville VALUES (1238, 4987, 'Stoumont');
INSERT INTO cp_ville VALUES (1239, 4990, 'Arbrefontaine');
INSERT INTO cp_ville VALUES (1240, 4990, 'Bra');
INSERT INTO cp_ville VALUES (1241, 4990, 'Lierneux');
INSERT INTO cp_ville VALUES (1242, 5000, 'Beez');
INSERT INTO cp_ville VALUES (1243, 5000, 'Namur');
INSERT INTO cp_ville VALUES (1244, 5001, 'Belgrade');
INSERT INTO cp_ville VALUES (1245, 5002, 'Saint-Servais');
INSERT INTO cp_ville VALUES (1246, 5003, 'Saint-Marc');
INSERT INTO cp_ville VALUES (1247, 5004, 'Bouge');
INSERT INTO cp_ville VALUES (1248, 5020, 'Champion');
INSERT INTO cp_ville VALUES (1249, 5020, 'Daussoulx');
INSERT INTO cp_ville VALUES (1250, 5020, 'Flawinne');
INSERT INTO cp_ville VALUES (1251, 5020, 'Malonne');
INSERT INTO cp_ville VALUES (1252, 5020, 'Suarlée');
INSERT INTO cp_ville VALUES (1253, 5020, 'Temploux');
INSERT INTO cp_ville VALUES (1254, 5020, 'Vedrin');
INSERT INTO cp_ville VALUES (1255, 5021, 'Boninne');
INSERT INTO cp_ville VALUES (1256, 5022, 'Cognelée');
INSERT INTO cp_ville VALUES (1257, 5024, 'Gelbressée');
INSERT INTO cp_ville VALUES (1258, 5024, 'Marche-les-Dames');
INSERT INTO cp_ville VALUES (1259, 5030, 'Beuzet');
INSERT INTO cp_ville VALUES (1260, 5030, 'Ernage');
INSERT INTO cp_ville VALUES (1261, 5030, 'Gembloux');
INSERT INTO cp_ville VALUES (1262, 5030, 'Grand-Manil');
INSERT INTO cp_ville VALUES (1263, 5030, 'Lonzée');
INSERT INTO cp_ville VALUES (1264, 5030, 'Sauvenière');
INSERT INTO cp_ville VALUES (1265, 5031, 'Grand-Leez');
INSERT INTO cp_ville VALUES (1266, 5032, 'Bossière');
INSERT INTO cp_ville VALUES (1267, 5032, 'Bothey');
INSERT INTO cp_ville VALUES (1268, 5032, 'Corroy-le-Château');
INSERT INTO cp_ville VALUES (1269, 5032, 'Isnes');
INSERT INTO cp_ville VALUES (1270, 5032, 'Mazy');
INSERT INTO cp_ville VALUES (1271, 5060, 'Arsimont');
INSERT INTO cp_ville VALUES (1272, 5060, 'Auvelais');
INSERT INTO cp_ville VALUES (1273, 5060, 'Falisolle');
INSERT INTO cp_ville VALUES (1274, 5060, 'Keumiée');
INSERT INTO cp_ville VALUES (1275, 5060, 'Moignelée');
INSERT INTO cp_ville VALUES (1276, 5060, 'Sambreville');
INSERT INTO cp_ville VALUES (1277, 5060, 'Tamines');
INSERT INTO cp_ville VALUES (1278, 5060, 'Velaine-sur-Sambre');
INSERT INTO cp_ville VALUES (1279, 5070, 'Aisemont');
INSERT INTO cp_ville VALUES (1280, 5070, 'Fosses-la-Ville');
INSERT INTO cp_ville VALUES (1281, 5070, 'Le Roux');
INSERT INTO cp_ville VALUES (1282, 5070, 'Sart-Eustache');
INSERT INTO cp_ville VALUES (1283, 5070, 'Sart-Saint-Laurent');
INSERT INTO cp_ville VALUES (1284, 5070, 'Vitrival');
INSERT INTO cp_ville VALUES (1285, 5080, 'Emines');
INSERT INTO cp_ville VALUES (1286, 5080, 'La Bruyère');
INSERT INTO cp_ville VALUES (1287, 5080, 'Rhisnes');
INSERT INTO cp_ville VALUES (1288, 5080, 'Villers-lez-Heest');
INSERT INTO cp_ville VALUES (1289, 5080, 'Warisoulx');
INSERT INTO cp_ville VALUES (1290, 5081, 'Bovesse');
INSERT INTO cp_ville VALUES (1291, 5081, 'Meux');
INSERT INTO cp_ville VALUES (1292, 5081, 'Saint-Denis-Bovesse');
INSERT INTO cp_ville VALUES (1293, 5100, 'Dave');
INSERT INTO cp_ville VALUES (1294, 5100, 'Jambes (Namur)');
INSERT INTO cp_ville VALUES (1295, 5100, 'Naninne');
INSERT INTO cp_ville VALUES (1296, 5100, 'Wépion');
INSERT INTO cp_ville VALUES (1297, 5100, 'Wierde');
INSERT INTO cp_ville VALUES (1298, 5101, 'Erpent');
INSERT INTO cp_ville VALUES (1299, 5101, 'Lives-sur-Meuse');
INSERT INTO cp_ville VALUES (1300, 5101, 'Loyers');
INSERT INTO cp_ville VALUES (1301, 5140, 'Boignée');
INSERT INTO cp_ville VALUES (1302, 5140, 'Ligny');
INSERT INTO cp_ville VALUES (1303, 5140, 'Sombreffe');
INSERT INTO cp_ville VALUES (1304, 5140, 'Tongrinne');
INSERT INTO cp_ville VALUES (1305, 5150, 'Floreffe');
INSERT INTO cp_ville VALUES (1306, 5150, 'Floriffoux');
INSERT INTO cp_ville VALUES (1307, 5150, 'Franière');
INSERT INTO cp_ville VALUES (1308, 5150, 'Soye (Nam.)');
INSERT INTO cp_ville VALUES (1309, 5170, 'Arbre (Nam.)');
INSERT INTO cp_ville VALUES (1310, 5170, 'Bois-de-Villers');
INSERT INTO cp_ville VALUES (1311, 5170, 'Lesve');
INSERT INTO cp_ville VALUES (1312, 5170, 'Lustin');
INSERT INTO cp_ville VALUES (1313, 5170, 'Profondeville');
INSERT INTO cp_ville VALUES (1314, 5170, 'Rivière');
INSERT INTO cp_ville VALUES (1315, 5190, 'Balâtre');
INSERT INTO cp_ville VALUES (1316, 5190, 'Ham-sur-Sambre');
INSERT INTO cp_ville VALUES (1317, 5190, 'Jemeppe-sur-Sambre');
INSERT INTO cp_ville VALUES (1318, 5190, 'Mornimont');
INSERT INTO cp_ville VALUES (1319, 5190, 'Moustier-sur-Sambre');
INSERT INTO cp_ville VALUES (1320, 5190, 'Onoz');
INSERT INTO cp_ville VALUES (1321, 5190, 'Saint-Martin');
INSERT INTO cp_ville VALUES (1322, 5190, 'Spy');
INSERT INTO cp_ville VALUES (1323, 5300, 'Andenne');
INSERT INTO cp_ville VALUES (1324, 5300, 'Bonneville');
INSERT INTO cp_ville VALUES (1325, 5300, 'Coutisse');
INSERT INTO cp_ville VALUES (1326, 5300, 'Landenne');
INSERT INTO cp_ville VALUES (1327, 5300, 'Maizeret');
INSERT INTO cp_ville VALUES (1328, 5300, 'Namêche');
INSERT INTO cp_ville VALUES (1329, 5300, 'Sclayn');
INSERT INTO cp_ville VALUES (1330, 5300, 'Seilles');
INSERT INTO cp_ville VALUES (1331, 5300, 'Thon');
INSERT INTO cp_ville VALUES (1332, 5300, 'Vezin');
INSERT INTO cp_ville VALUES (1333, 5310, 'Aische-en-Refail');
INSERT INTO cp_ville VALUES (1334, 5310, 'Bolinne');
INSERT INTO cp_ville VALUES (1335, 5310, 'Boneffe');
INSERT INTO cp_ville VALUES (1336, 5310, 'Branchon');
INSERT INTO cp_ville VALUES (1337, 5310, 'Dhuy');
INSERT INTO cp_ville VALUES (1338, 5310, 'Eghezée');
INSERT INTO cp_ville VALUES (1339, 5310, 'Hanret');
INSERT INTO cp_ville VALUES (1340, 5310, 'Leuze (Nam.)');
INSERT INTO cp_ville VALUES (1341, 5310, 'Liernu');
INSERT INTO cp_ville VALUES (1342, 5310, 'Longchamps (Nam.)');
INSERT INTO cp_ville VALUES (1343, 5310, 'Mehaigne');
INSERT INTO cp_ville VALUES (1344, 5310, 'Noville-sur-Méhaigne');
INSERT INTO cp_ville VALUES (1345, 5310, 'Saint-Germain');
INSERT INTO cp_ville VALUES (1346, 5310, 'Taviers (Nam.)');
INSERT INTO cp_ville VALUES (1347, 5310, 'Upigny');
INSERT INTO cp_ville VALUES (1348, 5310, 'Waret-la-Chaussée');
INSERT INTO cp_ville VALUES (1349, 5330, 'Assesse');
INSERT INTO cp_ville VALUES (1350, 5330, 'Maillen');
INSERT INTO cp_ville VALUES (1351, 5330, 'Sart-Bernard');
INSERT INTO cp_ville VALUES (1352, 5332, 'Crupet');
INSERT INTO cp_ville VALUES (1353, 5333, 'Sorinne-la-Longue');
INSERT INTO cp_ville VALUES (1354, 5334, 'Florée');
INSERT INTO cp_ville VALUES (1355, 5336, 'Courrière');
INSERT INTO cp_ville VALUES (1356, 5340, 'Faulx-les-Tombes');
INSERT INTO cp_ville VALUES (1357, 5340, 'Gesves');
INSERT INTO cp_ville VALUES (1358, 5340, 'Haltinne');
INSERT INTO cp_ville VALUES (1359, 5340, 'Mozet');
INSERT INTO cp_ville VALUES (1360, 5340, 'Sorée');
INSERT INTO cp_ville VALUES (1361, 5350, 'Evelette');
INSERT INTO cp_ville VALUES (1362, 5350, 'Ohey');
INSERT INTO cp_ville VALUES (1363, 5351, 'Haillot');
INSERT INTO cp_ville VALUES (1364, 5352, 'Perwez-Haillot');
INSERT INTO cp_ville VALUES (1365, 5353, 'Goesnes');
INSERT INTO cp_ville VALUES (1366, 5354, 'Jallet');
INSERT INTO cp_ville VALUES (1367, 5360, 'Hamois');
INSERT INTO cp_ville VALUES (1368, 5360, 'Natoye');
INSERT INTO cp_ville VALUES (1369, 5361, 'Mohiville');
INSERT INTO cp_ville VALUES (1370, 5361, 'Scy');
INSERT INTO cp_ville VALUES (1371, 5362, 'Achet');
INSERT INTO cp_ville VALUES (1372, 5363, 'Emptinne');
INSERT INTO cp_ville VALUES (1373, 5364, 'Schaltin');
INSERT INTO cp_ville VALUES (1374, 5370, 'Barvaux-Condroz');
INSERT INTO cp_ville VALUES (1375, 5370, 'Flostoy');
INSERT INTO cp_ville VALUES (1376, 5370, 'Havelange');
INSERT INTO cp_ville VALUES (1377, 5370, 'Jeneffe (Nam.)');
INSERT INTO cp_ville VALUES (1378, 5370, 'Porcheresse (Nam.)');
INSERT INTO cp_ville VALUES (1379, 5370, 'Verlée');
INSERT INTO cp_ville VALUES (1380, 5372, 'Méan');
INSERT INTO cp_ville VALUES (1381, 5374, 'Maffe');
INSERT INTO cp_ville VALUES (1382, 5376, 'Miécret');
INSERT INTO cp_ville VALUES (1383, 5377, 'Baillonville');
INSERT INTO cp_ville VALUES (1384, 5377, 'Bonsin');
INSERT INTO cp_ville VALUES (1385, 5377, 'Heure (Nam.)');
INSERT INTO cp_ville VALUES (1386, 5377, 'Hogne');
INSERT INTO cp_ville VALUES (1387, 5377, 'Nettinne');
INSERT INTO cp_ville VALUES (1388, 5377, 'Noiseux');
INSERT INTO cp_ville VALUES (1389, 5377, 'Sinsin');
INSERT INTO cp_ville VALUES (1390, 5377, 'Somme-Leuze');
INSERT INTO cp_ville VALUES (1391, 5377, 'Waillet');
INSERT INTO cp_ville VALUES (1392, 5380, 'Bierwart');
INSERT INTO cp_ville VALUES (1393, 5380, 'Cortil-Wodon');
INSERT INTO cp_ville VALUES (1394, 5380, 'Fernelmont');
INSERT INTO cp_ville VALUES (1395, 5380, 'Forville');
INSERT INTO cp_ville VALUES (1396, 5380, 'Franc-Waret');
INSERT INTO cp_ville VALUES (1397, 5380, 'Hemptinne (Fernelmont)');
INSERT INTO cp_ville VALUES (1398, 5380, 'Hingeon');
INSERT INTO cp_ville VALUES (1399, 5380, 'Marchovelette');
INSERT INTO cp_ville VALUES (1400, 5380, 'Noville-les-Bois');
INSERT INTO cp_ville VALUES (1401, 5380, 'Pontillas');
INSERT INTO cp_ville VALUES (1402, 5380, 'Tillier');
INSERT INTO cp_ville VALUES (1403, 5500, 'Anseremme');
INSERT INTO cp_ville VALUES (1404, 5500, 'Bouvignes-sur-Meuse');
INSERT INTO cp_ville VALUES (1405, 5500, 'Dinant');
INSERT INTO cp_ville VALUES (1406, 5500, 'Dréhance');
INSERT INTO cp_ville VALUES (1407, 5500, 'Falmagne');
INSERT INTO cp_ville VALUES (1408, 5500, 'Falmignoul');
INSERT INTO cp_ville VALUES (1409, 5500, 'Furfooz');
INSERT INTO cp_ville VALUES (1410, 5501, 'Lisogne');
INSERT INTO cp_ville VALUES (1411, 5502, 'Thynes');
INSERT INTO cp_ville VALUES (1412, 5503, 'Sorinnes');
INSERT INTO cp_ville VALUES (1413, 5504, 'Foy-Notre-Dame');
INSERT INTO cp_ville VALUES (1414, 5520, 'Anthée');
INSERT INTO cp_ville VALUES (1415, 5520, 'Onhaye');
INSERT INTO cp_ville VALUES (1416, 5521, 'Serville');
INSERT INTO cp_ville VALUES (1417, 5522, 'Falaën');
INSERT INTO cp_ville VALUES (1418, 5523, 'Sommière');
INSERT INTO cp_ville VALUES (1419, 5523, 'Weillen');
INSERT INTO cp_ville VALUES (1420, 5524, 'Gerin');
INSERT INTO cp_ville VALUES (1421, 5530, 'Dorinne');
INSERT INTO cp_ville VALUES (1422, 5530, 'Durnal');
INSERT INTO cp_ville VALUES (1423, 5530, 'Evrehailles');
INSERT INTO cp_ville VALUES (1424, 5530, 'Godinne');
INSERT INTO cp_ville VALUES (1425, 5530, 'Houx');
INSERT INTO cp_ville VALUES (1426, 5530, 'Mont (Nam.)');
INSERT INTO cp_ville VALUES (1427, 5530, 'Purnode');
INSERT INTO cp_ville VALUES (1428, 5530, 'Spontin');
INSERT INTO cp_ville VALUES (1429, 5530, 'Yvoir');
INSERT INTO cp_ville VALUES (1430, 5537, 'Anhée');
INSERT INTO cp_ville VALUES (1431, 5537, 'Annevoie-Rouillon');
INSERT INTO cp_ville VALUES (1432, 5537, 'Bioul');
INSERT INTO cp_ville VALUES (1433, 5537, 'Denée');
INSERT INTO cp_ville VALUES (1434, 5537, 'Haut-le-Wastia');
INSERT INTO cp_ville VALUES (1435, 5537, 'Sosoye');
INSERT INTO cp_ville VALUES (1436, 5537, 'Warnant');
INSERT INTO cp_ville VALUES (1437, 5540, 'Hastière');
INSERT INTO cp_ville VALUES (1438, 5540, 'Hastière-Lavaux');
INSERT INTO cp_ville VALUES (1439, 5540, 'Hermeton-sur-Meuse');
INSERT INTO cp_ville VALUES (1440, 5540, 'Waulsort');
INSERT INTO cp_ville VALUES (1441, 5541, 'Hastière-par-Delà');
INSERT INTO cp_ville VALUES (1442, 5542, 'Blaimont');
INSERT INTO cp_ville VALUES (1443, 5543, 'Heer');
INSERT INTO cp_ville VALUES (1444, 5544, 'Agimont');
INSERT INTO cp_ville VALUES (1445, 5550, 'Alle');
INSERT INTO cp_ville VALUES (1446, 5550, 'Bagimont');
INSERT INTO cp_ville VALUES (1447, 5550, 'Bohan');
INSERT INTO cp_ville VALUES (1448, 5550, 'Chairière');
INSERT INTO cp_ville VALUES (1449, 5550, 'Laforêt');
INSERT INTO cp_ville VALUES (1450, 5550, 'Membre');
INSERT INTO cp_ville VALUES (1451, 5550, 'Mouzaive');
INSERT INTO cp_ville VALUES (1452, 5550, 'Nafraiture');
INSERT INTO cp_ville VALUES (1453, 5550, 'Orchimont');
INSERT INTO cp_ville VALUES (1454, 5550, 'Pussemange');
INSERT INTO cp_ville VALUES (1455, 5550, 'Sugny');
INSERT INTO cp_ville VALUES (1456, 5550, 'Vresse-sur-Semois');
INSERT INTO cp_ville VALUES (1457, 5555, 'Baillamont');
INSERT INTO cp_ville VALUES (1458, 5555, 'Bellefontaine (Nam.)');
INSERT INTO cp_ville VALUES (1459, 5555, 'Bievre');
INSERT INTO cp_ville VALUES (1460, 5555, 'Cornimont');
INSERT INTO cp_ville VALUES (1461, 5555, 'Graide');
INSERT INTO cp_ville VALUES (1462, 5555, 'Gros-Fays');
INSERT INTO cp_ville VALUES (1463, 5555, 'Monceau-en-Ardenne');
INSERT INTO cp_ville VALUES (1464, 5555, 'Naomé');
INSERT INTO cp_ville VALUES (1465, 5555, 'Oizy');
INSERT INTO cp_ville VALUES (1466, 5555, 'Petit-Fays');
INSERT INTO cp_ville VALUES (1467, 5560, 'Ciergnon');
INSERT INTO cp_ville VALUES (1468, 5560, 'Finnevaux');
INSERT INTO cp_ville VALUES (1469, 5560, 'Houyet');
INSERT INTO cp_ville VALUES (1470, 5560, 'Hulsonniaux');
INSERT INTO cp_ville VALUES (1471, 5560, 'Mesnil-Eglise');
INSERT INTO cp_ville VALUES (1472, 5560, 'Mesnil-Saint-Blaise');
INSERT INTO cp_ville VALUES (1473, 5561, 'Celles (Nam.)');
INSERT INTO cp_ville VALUES (1474, 5562, 'Custinne');
INSERT INTO cp_ville VALUES (1475, 5563, 'Hour');
INSERT INTO cp_ville VALUES (1476, 5564, 'Wanlin');
INSERT INTO cp_ville VALUES (1477, 5570, 'Baronville');
INSERT INTO cp_ville VALUES (1478, 5570, 'Beauraing');
INSERT INTO cp_ville VALUES (1479, 5570, 'Dion');
INSERT INTO cp_ville VALUES (1480, 5570, 'Felenne');
INSERT INTO cp_ville VALUES (1481, 5570, 'Feschaux');
INSERT INTO cp_ville VALUES (1482, 5570, 'Honnay');
INSERT INTO cp_ville VALUES (1483, 5570, 'Javingue');
INSERT INTO cp_ville VALUES (1484, 5570, 'Vonêche');
INSERT INTO cp_ville VALUES (1485, 5570, 'Wancennes');
INSERT INTO cp_ville VALUES (1486, 5570, 'Winenne');
INSERT INTO cp_ville VALUES (1487, 5571, 'Wiesme');
INSERT INTO cp_ville VALUES (1488, 5572, 'Focant');
INSERT INTO cp_ville VALUES (1489, 5573, 'Martouzin-Neuville');
INSERT INTO cp_ville VALUES (1490, 5574, 'Pondrôme');
INSERT INTO cp_ville VALUES (1491, 5575, 'Bourseigne-Neuve');
INSERT INTO cp_ville VALUES (1492, 5575, 'Bourseigne-Vieille');
INSERT INTO cp_ville VALUES (1493, 5575, 'Gedinne');
INSERT INTO cp_ville VALUES (1494, 5575, 'Houdremont');
INSERT INTO cp_ville VALUES (1495, 5575, 'Louette-Saint-Denis');
INSERT INTO cp_ville VALUES (1496, 5575, 'Louette-Saint-Pierre');
INSERT INTO cp_ville VALUES (1497, 5575, 'Malvoisin');
INSERT INTO cp_ville VALUES (1498, 5575, 'Patignies');
INSERT INTO cp_ville VALUES (1499, 5575, 'Rienne');
INSERT INTO cp_ville VALUES (1500, 5575, 'Sart-Custinne');
INSERT INTO cp_ville VALUES (1501, 5575, 'Vencimont');
INSERT INTO cp_ville VALUES (1502, 5575, 'Willerzie');
INSERT INTO cp_ville VALUES (1503, 5576, 'Froidfontaine');
INSERT INTO cp_ville VALUES (1504, 5580, 'Ave-et-Auffe');
INSERT INTO cp_ville VALUES (1505, 5580, 'Buissonville');
INSERT INTO cp_ville VALUES (1506, 5580, 'Eprave');
INSERT INTO cp_ville VALUES (1507, 5580, 'Han-sur-Lesse');
INSERT INTO cp_ville VALUES (1508, 5580, 'Jemelle');
INSERT INTO cp_ville VALUES (1509, 5580, 'Lavaux-Sainte-Anne');
INSERT INTO cp_ville VALUES (1510, 5580, 'Lessive');
INSERT INTO cp_ville VALUES (1511, 5580, 'Mont-Gauthier');
INSERT INTO cp_ville VALUES (1512, 5580, 'Rochefort');
INSERT INTO cp_ville VALUES (1513, 5580, 'Villers-sur-Lesse');
INSERT INTO cp_ville VALUES (1514, 5580, 'Wavreille');
INSERT INTO cp_ville VALUES (1515, 5590, 'Achêne');
INSERT INTO cp_ville VALUES (1516, 5590, 'Braibant');
INSERT INTO cp_ville VALUES (1517, 5590, 'Chevetogne');
INSERT INTO cp_ville VALUES (1518, 5590, 'Ciney');
INSERT INTO cp_ville VALUES (1519, 5590, 'Conneux');
INSERT INTO cp_ville VALUES (1520, 5590, 'Haversin');
INSERT INTO cp_ville VALUES (1521, 5590, 'Leignon');
INSERT INTO cp_ville VALUES (1522, 5590, 'Pessoux');
INSERT INTO cp_ville VALUES (1523, 5590, 'Serinchamps');
INSERT INTO cp_ville VALUES (1524, 5590, 'Sovet');
INSERT INTO cp_ville VALUES (1525, 5600, 'Fagnolle');
INSERT INTO cp_ville VALUES (1526, 5600, 'Franchimont');
INSERT INTO cp_ville VALUES (1527, 5600, 'Jamagne');
INSERT INTO cp_ville VALUES (1528, 5600, 'Jamiolle');
INSERT INTO cp_ville VALUES (1529, 5600, 'Merlemont');
INSERT INTO cp_ville VALUES (1530, 5600, 'Neuville (Philippeville)');
INSERT INTO cp_ville VALUES (1531, 5600, 'Omezée');
INSERT INTO cp_ville VALUES (1532, 5600, 'Philippeville');
INSERT INTO cp_ville VALUES (1533, 5600, 'Roly');
INSERT INTO cp_ville VALUES (1534, 5600, 'Romedenne');
INSERT INTO cp_ville VALUES (1535, 5600, 'Samart');
INSERT INTO cp_ville VALUES (1536, 5600, 'Sart-en-Fagne');
INSERT INTO cp_ville VALUES (1537, 5600, 'Sautour');
INSERT INTO cp_ville VALUES (1538, 5600, 'Surice');
INSERT INTO cp_ville VALUES (1539, 5600, 'Villers-en-Fagne');
INSERT INTO cp_ville VALUES (1540, 5600, 'Villers-le-Gambon');
INSERT INTO cp_ville VALUES (1541, 5600, 'Vodecée');
INSERT INTO cp_ville VALUES (1542, 5620, 'Corenne');
INSERT INTO cp_ville VALUES (1543, 5620, 'Flavion');
INSERT INTO cp_ville VALUES (1544, 5620, 'Florennes');
INSERT INTO cp_ville VALUES (1545, 5620, 'Hemptinne-lez-Florennes');
INSERT INTO cp_ville VALUES (1546, 5620, 'Morville');
INSERT INTO cp_ville VALUES (1547, 5620, 'Rosée');
INSERT INTO cp_ville VALUES (1548, 5620, 'Saint-Aubin');
INSERT INTO cp_ville VALUES (1549, 5621, 'Hanzinelle');
INSERT INTO cp_ville VALUES (1550, 5621, 'Hanzinne');
INSERT INTO cp_ville VALUES (1551, 5621, 'Morialmé');
INSERT INTO cp_ville VALUES (1552, 5621, 'Thy-le-Bauduin');
INSERT INTO cp_ville VALUES (1553, 5630, 'Cerfontaine');
INSERT INTO cp_ville VALUES (1554, 5630, 'Daussois');
INSERT INTO cp_ville VALUES (1555, 5630, 'Senzeille');
INSERT INTO cp_ville VALUES (1556, 5630, 'Silenrieux');
INSERT INTO cp_ville VALUES (1557, 5630, 'Soumoy');
INSERT INTO cp_ville VALUES (1558, 5630, 'Villers-Deux-Eglises');
INSERT INTO cp_ville VALUES (1559, 5640, 'Biesme');
INSERT INTO cp_ville VALUES (1560, 5640, 'Biesmerée');
INSERT INTO cp_ville VALUES (1561, 5640, 'Graux');
INSERT INTO cp_ville VALUES (1562, 5640, 'Mettet');
INSERT INTO cp_ville VALUES (1563, 5640, 'Oret');
INSERT INTO cp_ville VALUES (1564, 5640, 'Saint-Gérard');
INSERT INTO cp_ville VALUES (1565, 5641, 'Furnaux');
INSERT INTO cp_ville VALUES (1566, 5644, 'Ermeton-sur-Biert');
INSERT INTO cp_ville VALUES (1567, 5646, 'Stave');
INSERT INTO cp_ville VALUES (1568, 5650, 'Castillon');
INSERT INTO cp_ville VALUES (1569, 5650, 'Chastrès');
INSERT INTO cp_ville VALUES (1570, 5650, 'Clermont (Nam.)');
INSERT INTO cp_ville VALUES (1571, 5650, 'Fontenelle');
INSERT INTO cp_ville VALUES (1572, 5650, 'Fraire');
INSERT INTO cp_ville VALUES (1573, 5650, 'Pry');
INSERT INTO cp_ville VALUES (1574, 5650, 'Vogenée');
INSERT INTO cp_ville VALUES (1575, 5650, 'Walcourt');
INSERT INTO cp_ville VALUES (1576, 5650, 'Yves-Gomezée');
INSERT INTO cp_ville VALUES (1577, 5651, 'Berzée');
INSERT INTO cp_ville VALUES (1578, 5651, 'Gourdinne');
INSERT INTO cp_ville VALUES (1579, 5651, 'Laneffe');
INSERT INTO cp_ville VALUES (1580, 5651, 'Rognée');
INSERT INTO cp_ville VALUES (1581, 5651, 'Somzée');
INSERT INTO cp_ville VALUES (1582, 5651, 'Tarcienne');
INSERT INTO cp_ville VALUES (1583, 5651, 'Thy-le-Château');
INSERT INTO cp_ville VALUES (1584, 5660, 'Aublain');
INSERT INTO cp_ville VALUES (1585, 5660, 'Boussu-en-Fagne');
INSERT INTO cp_ville VALUES (1586, 5660, 'Brûly');
INSERT INTO cp_ville VALUES (1587, 5660, 'Brûly-de-Pesche');
INSERT INTO cp_ville VALUES (1588, 5660, 'Couvin');
INSERT INTO cp_ville VALUES (1589, 5660, 'Cul-des-Sarts');
INSERT INTO cp_ville VALUES (1590, 5660, 'Dailly');
INSERT INTO cp_ville VALUES (1591, 5660, 'Frasnes (Nam.)');
INSERT INTO cp_ville VALUES (1592, 5660, 'Gonrieux');
INSERT INTO cp_ville VALUES (1593, 5660, 'Mariembourg');
INSERT INTO cp_ville VALUES (1594, 5660, 'Pesche');
INSERT INTO cp_ville VALUES (1595, 5660, 'Petigny');
INSERT INTO cp_ville VALUES (1596, 5660, 'Petite-Chapelle');
INSERT INTO cp_ville VALUES (1597, 5660, 'Presgaux');
INSERT INTO cp_ville VALUES (1598, 5670, 'Dourbes');
INSERT INTO cp_ville VALUES (1599, 5670, 'Le Mesnil');
INSERT INTO cp_ville VALUES (1600, 5670, 'Mazée');
INSERT INTO cp_ville VALUES (1601, 5670, 'Nismes');
INSERT INTO cp_ville VALUES (1602, 5670, 'Oignies-en-Thiérache');
INSERT INTO cp_ville VALUES (1603, 5670, 'Olloy-sur-Viroin');
INSERT INTO cp_ville VALUES (1604, 5670, 'Treignes');
INSERT INTO cp_ville VALUES (1605, 5670, 'Vierves-sur-Viroin');
INSERT INTO cp_ville VALUES (1606, 5670, 'Viroinval');
INSERT INTO cp_ville VALUES (1607, 5680, 'Doische');
INSERT INTO cp_ville VALUES (1608, 5680, 'Gimnée');
INSERT INTO cp_ville VALUES (1609, 5680, 'Gochenée');
INSERT INTO cp_ville VALUES (1610, 5680, 'Matagne-la-Grande');
INSERT INTO cp_ville VALUES (1611, 5680, 'Matagne-la-Petite');
INSERT INTO cp_ville VALUES (1612, 5680, 'Niverlée');
INSERT INTO cp_ville VALUES (1613, 5680, 'Romerée');
INSERT INTO cp_ville VALUES (1614, 5680, 'Soulme');
INSERT INTO cp_ville VALUES (1615, 5680, 'Vaucelles');
INSERT INTO cp_ville VALUES (1616, 5680, 'Vodelée');
INSERT INTO cp_ville VALUES (1617, 6000, 'Charleroi');
INSERT INTO cp_ville VALUES (1618, 6001, 'Marcinelle');
INSERT INTO cp_ville VALUES (1619, 6010, 'Couillet');
INSERT INTO cp_ville VALUES (1620, 6020, 'Dampremy');
INSERT INTO cp_ville VALUES (1621, 6030, 'Goutroux');
INSERT INTO cp_ville VALUES (1622, 6030, 'Marchienne-au-Pont');
INSERT INTO cp_ville VALUES (1623, 6031, 'Monceau-sur-Sambre');
INSERT INTO cp_ville VALUES (1624, 6032, 'Mont-sur-Marchienne');
INSERT INTO cp_ville VALUES (1625, 6040, 'Jumet (Charleroi)');
INSERT INTO cp_ville VALUES (1626, 6041, 'Gosselies');
INSERT INTO cp_ville VALUES (1627, 6042, 'Lodelinsart');
INSERT INTO cp_ville VALUES (1628, 6043, 'Ransart');
INSERT INTO cp_ville VALUES (1629, 6044, 'Roux');
INSERT INTO cp_ville VALUES (1630, 6060, 'Gilly (Charleroi)');
INSERT INTO cp_ville VALUES (1631, 6061, 'Montignies-sur-Sambre');
INSERT INTO cp_ville VALUES (1632, 6110, 'Montigny-le-Tilleul');
INSERT INTO cp_ville VALUES (1633, 6111, 'Landelies');
INSERT INTO cp_ville VALUES (1634, 6120, 'Cour-sur-Heure');
INSERT INTO cp_ville VALUES (1635, 6120, 'Ham-sur-Heure');
INSERT INTO cp_ville VALUES (1636, 6120, 'Ham-sur-Heure-Nalinnes');
INSERT INTO cp_ville VALUES (1637, 6120, 'Jamioulx');
INSERT INTO cp_ville VALUES (1638, 6120, 'Marbaix (Ht.)');
INSERT INTO cp_ville VALUES (1639, 6120, 'Nalinnes');
INSERT INTO cp_ville VALUES (1640, 6140, 'Fontaine-l\'Evêque');
INSERT INTO cp_ville VALUES (1641, 6141, 'Forchies-la-Marche');
INSERT INTO cp_ville VALUES (1642, 6142, 'Leernes');
INSERT INTO cp_ville VALUES (1643, 6150, 'Anderlues');
INSERT INTO cp_ville VALUES (1644, 6180, 'Courcelles');
INSERT INTO cp_ville VALUES (1645, 6181, 'Gouy-lez-Piéton');
INSERT INTO cp_ville VALUES (1646, 6182, 'Souvret');
INSERT INTO cp_ville VALUES (1647, 6183, 'Trazegnies');
INSERT INTO cp_ville VALUES (1648, 6200, 'Bouffioulx');
INSERT INTO cp_ville VALUES (1649, 6200, 'Châtelet');
INSERT INTO cp_ville VALUES (1650, 6200, 'Châtelineau');
INSERT INTO cp_ville VALUES (1651, 6210, 'Frasnes-lez-Gosselies');
INSERT INTO cp_ville VALUES (1652, 6210, 'Les Bons Villers');
INSERT INTO cp_ville VALUES (1653, 6210, 'Rèves');
INSERT INTO cp_ville VALUES (1654, 6210, 'Villers-Perwin');
INSERT INTO cp_ville VALUES (1655, 6210, 'Wayaux');
INSERT INTO cp_ville VALUES (1656, 6211, 'Mellet');
INSERT INTO cp_ville VALUES (1657, 6220, 'Fleurus');
INSERT INTO cp_ville VALUES (1658, 6220, 'Heppignies');
INSERT INTO cp_ville VALUES (1659, 6220, 'Lambusart');
INSERT INTO cp_ville VALUES (1660, 6220, 'Wangenies');
INSERT INTO cp_ville VALUES (1661, 6221, 'Saint-Amand');
INSERT INTO cp_ville VALUES (1662, 6222, 'Brye');
INSERT INTO cp_ville VALUES (1663, 6223, 'Wagnelée');
INSERT INTO cp_ville VALUES (1664, 6224, 'Wanfercée-Baulet');
INSERT INTO cp_ville VALUES (1665, 6230, 'Buzet');
INSERT INTO cp_ville VALUES (1666, 6230, 'Obaix');
INSERT INTO cp_ville VALUES (1667, 6230, 'Pont-à-Celles');
INSERT INTO cp_ville VALUES (1668, 6230, 'Thiméon');
INSERT INTO cp_ville VALUES (1669, 6230, 'Viesville');
INSERT INTO cp_ville VALUES (1670, 6238, 'Liberchies');
INSERT INTO cp_ville VALUES (1671, 6238, 'Luttre');
INSERT INTO cp_ville VALUES (1672, 6240, 'Farciennes');
INSERT INTO cp_ville VALUES (1673, 6240, 'Pironchamps');
INSERT INTO cp_ville VALUES (1674, 6250, 'Aiseau');
INSERT INTO cp_ville VALUES (1675, 6250, 'Aiseau-Presles');
INSERT INTO cp_ville VALUES (1676, 6250, 'Pont-de-Loup');
INSERT INTO cp_ville VALUES (1677, 6250, 'Presles');
INSERT INTO cp_ville VALUES (1678, 6250, 'Roselies');
INSERT INTO cp_ville VALUES (1679, 6280, 'Acoz');
INSERT INTO cp_ville VALUES (1680, 6280, 'Gerpinnes');
INSERT INTO cp_ville VALUES (1681, 6280, 'Gougnies');
INSERT INTO cp_ville VALUES (1682, 6280, 'Joncret');
INSERT INTO cp_ville VALUES (1683, 6280, 'Loverval');
INSERT INTO cp_ville VALUES (1684, 6280, 'Villers-Poterie');
INSERT INTO cp_ville VALUES (1685, 6440, 'Boussu-lez-Walcourt');
INSERT INTO cp_ville VALUES (1686, 6440, 'Fourbechies');
INSERT INTO cp_ville VALUES (1687, 6440, 'Froidchapelle');
INSERT INTO cp_ville VALUES (1688, 6440, 'Vergnies');
INSERT INTO cp_ville VALUES (1689, 6441, 'Erpion');
INSERT INTO cp_ville VALUES (1690, 6460, 'Bailièvre');
INSERT INTO cp_ville VALUES (1691, 6460, 'Chimay');
INSERT INTO cp_ville VALUES (1692, 6460, 'Robechies');
INSERT INTO cp_ville VALUES (1693, 6460, 'Saint-Remy (Ht.)');
INSERT INTO cp_ville VALUES (1694, 6460, 'Salles');
INSERT INTO cp_ville VALUES (1695, 6460, 'Villers-la-Tour');
INSERT INTO cp_ville VALUES (1696, 6461, 'Virelles');
INSERT INTO cp_ville VALUES (1697, 6462, 'Vaulx-lez-Chimay');
INSERT INTO cp_ville VALUES (1698, 6463, 'Lompret');
INSERT INTO cp_ville VALUES (1699, 6464, 'Baileux');
INSERT INTO cp_ville VALUES (1700, 6464, 'Bourlers');
INSERT INTO cp_ville VALUES (1701, 6464, 'Forges');
INSERT INTO cp_ville VALUES (1702, 6464, 'l\'Escaillère');
INSERT INTO cp_ville VALUES (1703, 6464, 'Rièzes');
INSERT INTO cp_ville VALUES (1704, 6470, 'Grandrieu');
INSERT INTO cp_ville VALUES (1705, 6470, 'Montbliart');
INSERT INTO cp_ville VALUES (1706, 6470, 'Rance');
INSERT INTO cp_ville VALUES (1707, 6470, 'Sautin');
INSERT INTO cp_ville VALUES (1708, 6470, 'Sivry');
INSERT INTO cp_ville VALUES (1709, 6470, 'Sivry-Rance');
INSERT INTO cp_ville VALUES (1710, 6500, 'Barbençon');
INSERT INTO cp_ville VALUES (1711, 6500, 'Beaumont');
INSERT INTO cp_ville VALUES (1712, 6500, 'Leugnies');
INSERT INTO cp_ville VALUES (1713, 6500, 'Leval-Chaudeville');
INSERT INTO cp_ville VALUES (1714, 6500, 'Renlies');
INSERT INTO cp_ville VALUES (1715, 6500, 'Solre-Saint-Géry');
INSERT INTO cp_ville VALUES (1716, 6500, 'Thirimont');
INSERT INTO cp_ville VALUES (1717, 6511, 'Strée (Ht.)');
INSERT INTO cp_ville VALUES (1718, 6530, 'Leers-et-Fosteau');
INSERT INTO cp_ville VALUES (1719, 6530, 'Thuin');
INSERT INTO cp_ville VALUES (1720, 6531, 'Biesme-sous-Thuin');
INSERT INTO cp_ville VALUES (1721, 6532, 'Ragnies');
INSERT INTO cp_ville VALUES (1722, 6533, 'Biercée');
INSERT INTO cp_ville VALUES (1723, 6534, 'Gozée');
INSERT INTO cp_ville VALUES (1724, 6536, 'Donstiennes');
INSERT INTO cp_ville VALUES (1725, 6536, 'Thuillies');
INSERT INTO cp_ville VALUES (1726, 6540, 'Lobbes');
INSERT INTO cp_ville VALUES (1727, 6540, 'Mont-Sainte-Geneviève');
INSERT INTO cp_ville VALUES (1728, 6542, 'Sars-la-Buissière');
INSERT INTO cp_ville VALUES (1729, 6543, 'Bienne-lez-Happart');
INSERT INTO cp_ville VALUES (1730, 6560, 'Bersillies-l\'Abbaye');
INSERT INTO cp_ville VALUES (1731, 6560, 'Erquelinnes');
INSERT INTO cp_ville VALUES (1732, 6560, 'Grand-Reng');
INSERT INTO cp_ville VALUES (1733, 6560, 'Hantes-Wihéries');
INSERT INTO cp_ville VALUES (1734, 6560, 'Montignies-Saint-Christophe');
INSERT INTO cp_ville VALUES (1735, 6560, 'Solre-sur-Sambre');
INSERT INTO cp_ville VALUES (1736, 6567, 'Fontaine-Valmont');
INSERT INTO cp_ville VALUES (1737, 6567, 'Labuissière');
INSERT INTO cp_ville VALUES (1738, 6567, 'Merbes-le-Château');
INSERT INTO cp_ville VALUES (1739, 6567, 'Merbes-Sainte-Marie');
INSERT INTO cp_ville VALUES (1740, 6590, 'Momignies');
INSERT INTO cp_ville VALUES (1741, 6591, 'Macon');
INSERT INTO cp_ville VALUES (1742, 6592, 'Monceau-Imbrechies');
INSERT INTO cp_ville VALUES (1743, 6593, 'Macquenoise');
INSERT INTO cp_ville VALUES (1744, 6594, 'Beauwelz');
INSERT INTO cp_ville VALUES (1745, 6596, 'Forge-Philippe');
INSERT INTO cp_ville VALUES (1746, 6596, 'Seloignes');
INSERT INTO cp_ville VALUES (1747, 6600, 'Bastogne');
INSERT INTO cp_ville VALUES (1748, 6600, 'Longvilly');
INSERT INTO cp_ville VALUES (1749, 6600, 'Noville (Lux.)');
INSERT INTO cp_ville VALUES (1750, 6600, 'Villers-la-Bonne-Eau');
INSERT INTO cp_ville VALUES (1751, 6600, 'Wardin');
INSERT INTO cp_ville VALUES (1752, 6630, 'Martelange');
INSERT INTO cp_ville VALUES (1753, 6637, 'Fauvillers');
INSERT INTO cp_ville VALUES (1754, 6637, 'Hollange');
INSERT INTO cp_ville VALUES (1755, 6637, 'Tintange');
INSERT INTO cp_ville VALUES (1756, 6640, 'Hompré');
INSERT INTO cp_ville VALUES (1757, 6640, 'Morhet');
INSERT INTO cp_ville VALUES (1758, 6640, 'Nives');
INSERT INTO cp_ville VALUES (1759, 6640, 'Sibret');
INSERT INTO cp_ville VALUES (1760, 6640, 'Vaux-lez-Rosières');
INSERT INTO cp_ville VALUES (1761, 6640, 'Vaux-sur-Sure');
INSERT INTO cp_ville VALUES (1762, 6642, 'Juseret');
INSERT INTO cp_ville VALUES (1763, 6660, 'Houffalize');
INSERT INTO cp_ville VALUES (1764, 6660, 'Nadrin');
INSERT INTO cp_ville VALUES (1765, 6661, 'Mont (Lux.)');
INSERT INTO cp_ville VALUES (1766, 6661, 'Tailles');
INSERT INTO cp_ville VALUES (1767, 6662, 'Tavigny');
INSERT INTO cp_ville VALUES (1768, 6663, 'Mabompré');
INSERT INTO cp_ville VALUES (1769, 6666, 'Wibrin');
INSERT INTO cp_ville VALUES (1770, 6670, 'Gouvy');
INSERT INTO cp_ville VALUES (1771, 6670, 'Limerlé');
INSERT INTO cp_ville VALUES (1772, 6671, 'Bovigny');
INSERT INTO cp_ville VALUES (1773, 6672, 'Beho');
INSERT INTO cp_ville VALUES (1774, 6673, 'Cherain');
INSERT INTO cp_ville VALUES (1775, 6674, 'Montleban');
INSERT INTO cp_ville VALUES (1776, 6680, 'Amberloup');
INSERT INTO cp_ville VALUES (1777, 6680, 'Sainte-Ode');
INSERT INTO cp_ville VALUES (1778, 6680, 'Tillet');
INSERT INTO cp_ville VALUES (1779, 6681, 'Lavacherie');
INSERT INTO cp_ville VALUES (1780, 6686, 'Flamierge');
INSERT INTO cp_ville VALUES (1781, 6687, 'Bertogne');
INSERT INTO cp_ville VALUES (1782, 6688, 'Longchamps (Lux.)');
INSERT INTO cp_ville VALUES (1783, 6690, 'Bihain');
INSERT INTO cp_ville VALUES (1784, 6690, 'Vielsalm');
INSERT INTO cp_ville VALUES (1785, 6692, 'Petit-Thier');
INSERT INTO cp_ville VALUES (1786, 6698, 'Grand-Halleux');
INSERT INTO cp_ville VALUES (1787, 6700, 'Arlon');
INSERT INTO cp_ville VALUES (1788, 6700, 'Bonnert');
INSERT INTO cp_ville VALUES (1789, 6700, 'Heinsch');
INSERT INTO cp_ville VALUES (1790, 6700, 'Toernich');
INSERT INTO cp_ville VALUES (1791, 6704, 'Guirsch');
INSERT INTO cp_ville VALUES (1792, 6706, 'Autelbas');
INSERT INTO cp_ville VALUES (1793, 6717, 'Attert');
INSERT INTO cp_ville VALUES (1794, 6717, 'Nobressart');
INSERT INTO cp_ville VALUES (1795, 6717, 'Nothomb');
INSERT INTO cp_ville VALUES (1796, 6717, 'Thiaumont');
INSERT INTO cp_ville VALUES (1797, 6717, 'Tontelange');
INSERT INTO cp_ville VALUES (1798, 6720, 'Habay');
INSERT INTO cp_ville VALUES (1799, 6720, 'Habay-la-Neuve');
INSERT INTO cp_ville VALUES (1800, 6720, 'Hachy');
INSERT INTO cp_ville VALUES (1801, 6721, 'Anlier');
INSERT INTO cp_ville VALUES (1802, 6723, 'Habay-la-Vieille');
INSERT INTO cp_ville VALUES (1803, 6724, 'Houdemont');
INSERT INTO cp_ville VALUES (1804, 6724, 'Marbehan');
INSERT INTO cp_ville VALUES (1805, 6724, 'Rulles');
INSERT INTO cp_ville VALUES (1806, 6730, 'Bellefontaine (Lux.)');
INSERT INTO cp_ville VALUES (1807, 6730, 'Rossignol');
INSERT INTO cp_ville VALUES (1808, 6730, 'Saint-Vincent');
INSERT INTO cp_ville VALUES (1809, 6730, 'Tintigny');
INSERT INTO cp_ville VALUES (1810, 6740, 'Etalle');
INSERT INTO cp_ville VALUES (1811, 6740, 'Sainte-Marie-sur-Semois');
INSERT INTO cp_ville VALUES (1812, 6740, 'Villers-sur-Semois');
INSERT INTO cp_ville VALUES (1813, 6741, 'Vance');
INSERT INTO cp_ville VALUES (1814, 6742, 'Chantemelle');
INSERT INTO cp_ville VALUES (1815, 6743, 'Buzenol');
INSERT INTO cp_ville VALUES (1816, 6747, 'Châtillon');
INSERT INTO cp_ville VALUES (1817, 6747, 'Meix-le-Tige');
INSERT INTO cp_ville VALUES (1818, 6747, 'Saint-Léger (Lux.)');
INSERT INTO cp_ville VALUES (1819, 6750, 'Musson');
INSERT INTO cp_ville VALUES (1820, 6750, 'Mussy-la-Ville');
INSERT INTO cp_ville VALUES (1821, 6750, 'Signeulx');
INSERT INTO cp_ville VALUES (1822, 6760, 'Bleid');
INSERT INTO cp_ville VALUES (1823, 6760, 'Ethe');
INSERT INTO cp_ville VALUES (1824, 6760, 'Ruette');
INSERT INTO cp_ville VALUES (1825, 6760, 'Virton');
INSERT INTO cp_ville VALUES (1826, 6761, 'Latour');
INSERT INTO cp_ville VALUES (1827, 6762, 'Saint-Mard');
INSERT INTO cp_ville VALUES (1828, 6767, 'Dampicourt');
INSERT INTO cp_ville VALUES (1829, 6767, 'Harnoncourt');
INSERT INTO cp_ville VALUES (1830, 6767, 'Lamorteau');
INSERT INTO cp_ville VALUES (1831, 6767, 'Rouvroy');
INSERT INTO cp_ville VALUES (1832, 6767, 'Torgny');
INSERT INTO cp_ville VALUES (1833, 6769, 'Gérouville');
INSERT INTO cp_ville VALUES (1834, 6769, 'Meix-Devant-Virton');
INSERT INTO cp_ville VALUES (1835, 6769, 'Robelmont');
INSERT INTO cp_ville VALUES (1836, 6769, 'Sommethonne');
INSERT INTO cp_ville VALUES (1837, 6769, 'Villers-la-Loue');
INSERT INTO cp_ville VALUES (1838, 6780, 'Hondelange');
INSERT INTO cp_ville VALUES (1839, 6780, 'Messancy');
INSERT INTO cp_ville VALUES (1840, 6780, 'Wolkrange');
INSERT INTO cp_ville VALUES (1841, 6781, 'Sélange');
INSERT INTO cp_ville VALUES (1842, 6782, 'Habergy');
INSERT INTO cp_ville VALUES (1843, 6790, 'Aubange');
INSERT INTO cp_ville VALUES (1844, 6791, 'Athus');
INSERT INTO cp_ville VALUES (1845, 6792, 'Halanzy');
INSERT INTO cp_ville VALUES (1846, 6792, 'Rachecourt');
INSERT INTO cp_ville VALUES (1847, 6800, 'Bras');
INSERT INTO cp_ville VALUES (1848, 6800, 'Freux');
INSERT INTO cp_ville VALUES (1849, 6800, 'Libramont-Chevigny');
INSERT INTO cp_ville VALUES (1850, 6800, 'Moircy');
INSERT INTO cp_ville VALUES (1851, 6800, 'Recogne');
INSERT INTO cp_ville VALUES (1852, 6800, 'Remagne');
INSERT INTO cp_ville VALUES (1853, 6800, 'Sainte-Marie-Chevigny');
INSERT INTO cp_ville VALUES (1854, 6800, 'Saint-Pierre');
INSERT INTO cp_ville VALUES (1855, 6810, 'Chiny');
INSERT INTO cp_ville VALUES (1856, 6810, 'Izel');
INSERT INTO cp_ville VALUES (1857, 6810, 'Jamoigne');
INSERT INTO cp_ville VALUES (1858, 6811, 'Les Bulles');
INSERT INTO cp_ville VALUES (1859, 6812, 'Suxy');
INSERT INTO cp_ville VALUES (1860, 6813, 'Termes');
INSERT INTO cp_ville VALUES (1861, 6820, 'Florenville');
INSERT INTO cp_ville VALUES (1862, 6820, 'Fontenoille');
INSERT INTO cp_ville VALUES (1863, 6820, 'Muno');
INSERT INTO cp_ville VALUES (1864, 6820, 'Sainte-Cécile');
INSERT INTO cp_ville VALUES (1865, 6821, 'Lacuisine');
INSERT INTO cp_ville VALUES (1866, 6823, 'Villers-Devant-Orval');
INSERT INTO cp_ville VALUES (1867, 6824, 'Chassepierre');
INSERT INTO cp_ville VALUES (1868, 6830, 'Bouillon');
INSERT INTO cp_ville VALUES (1869, 6830, 'Les Hayons');
INSERT INTO cp_ville VALUES (1870, 6830, 'Poupehan');
INSERT INTO cp_ville VALUES (1871, 6830, 'Rochehaut');
INSERT INTO cp_ville VALUES (1872, 6831, 'Noirefontaine');
INSERT INTO cp_ville VALUES (1873, 6832, 'Sensenruth');
INSERT INTO cp_ville VALUES (1874, 6833, 'Ucimont');
INSERT INTO cp_ville VALUES (1875, 6833, 'Vivy');
INSERT INTO cp_ville VALUES (1876, 6834, 'Bellevaux');
INSERT INTO cp_ville VALUES (1877, 6836, 'Dohan');
INSERT INTO cp_ville VALUES (1878, 6838, 'Corbion');
INSERT INTO cp_ville VALUES (1879, 6840, 'Grandvoir');
INSERT INTO cp_ville VALUES (1880, 6840, 'Grapfontaine');
INSERT INTO cp_ville VALUES (1881, 6840, 'Hamipré');
INSERT INTO cp_ville VALUES (1882, 6840, 'Longlier');
INSERT INTO cp_ville VALUES (1883, 6840, 'Neufchâteau');
INSERT INTO cp_ville VALUES (1884, 6840, 'Tournay');
INSERT INTO cp_ville VALUES (1885, 6850, 'Carlsbourg');
INSERT INTO cp_ville VALUES (1886, 6850, 'Offagne');
INSERT INTO cp_ville VALUES (1887, 6850, 'Paliseul');
INSERT INTO cp_ville VALUES (1888, 6851, 'Nollevaux');
INSERT INTO cp_ville VALUES (1889, 6852, 'Maissin');
INSERT INTO cp_ville VALUES (1890, 6852, 'Opont');
INSERT INTO cp_ville VALUES (1891, 6853, 'Framont');
INSERT INTO cp_ville VALUES (1892, 6856, 'Fays-les-Veneurs');
INSERT INTO cp_ville VALUES (1893, 6860, 'Assenois');
INSERT INTO cp_ville VALUES (1894, 6860, 'Ebly');
INSERT INTO cp_ville VALUES (1895, 6860, 'Léglise');
INSERT INTO cp_ville VALUES (1896, 6860, 'Mellier');
INSERT INTO cp_ville VALUES (1897, 6860, 'Witry');
INSERT INTO cp_ville VALUES (1898, 6870, 'Arville');
INSERT INTO cp_ville VALUES (1899, 6870, 'Awenne');
INSERT INTO cp_ville VALUES (1900, 6870, 'Hatrival');
INSERT INTO cp_ville VALUES (1901, 6870, 'Mirwart');
INSERT INTO cp_ville VALUES (1902, 6870, 'Saint-Hubert');
INSERT INTO cp_ville VALUES (1903, 6870, 'Vesqueville');
INSERT INTO cp_ville VALUES (1904, 6880, 'Auby-sur-Semois');
INSERT INTO cp_ville VALUES (1905, 6880, 'Bertrix');
INSERT INTO cp_ville VALUES (1906, 6880, 'Cugnon');
INSERT INTO cp_ville VALUES (1907, 6880, 'Jehonville');
INSERT INTO cp_ville VALUES (1908, 6880, 'Orgeo');
INSERT INTO cp_ville VALUES (1909, 6887, 'Herbeumont');
INSERT INTO cp_ville VALUES (1910, 6887, 'Saint-Médard');
INSERT INTO cp_ville VALUES (1911, 6887, 'Straimont');
INSERT INTO cp_ville VALUES (1912, 6890, 'Anloy');
INSERT INTO cp_ville VALUES (1913, 6890, 'Libin');
INSERT INTO cp_ville VALUES (1914, 6890, 'Ochamps');
INSERT INTO cp_ville VALUES (1915, 6890, 'Redu');
INSERT INTO cp_ville VALUES (1916, 6890, 'Smuid');
INSERT INTO cp_ville VALUES (1917, 6890, 'Transinne');
INSERT INTO cp_ville VALUES (1918, 6890, 'Villance');
INSERT INTO cp_ville VALUES (1919, 6900, 'Aye');
INSERT INTO cp_ville VALUES (1920, 6900, 'Hargimont');
INSERT INTO cp_ville VALUES (1921, 6900, 'Humain');
INSERT INTO cp_ville VALUES (1922, 6900, 'Marche-en-Famenne');
INSERT INTO cp_ville VALUES (1923, 6900, 'On');
INSERT INTO cp_ville VALUES (1924, 6900, 'Roy');
INSERT INTO cp_ville VALUES (1925, 6900, 'Waha');
INSERT INTO cp_ville VALUES (1926, 6920, 'Sohier');
INSERT INTO cp_ville VALUES (1927, 6920, 'Wellin');
INSERT INTO cp_ville VALUES (1928, 6921, 'Chanly');
INSERT INTO cp_ville VALUES (1929, 6922, 'Halma');
INSERT INTO cp_ville VALUES (1930, 6924, 'Lomprez');
INSERT INTO cp_ville VALUES (1931, 6927, 'Bure');
INSERT INTO cp_ville VALUES (1932, 6927, 'Grupont');
INSERT INTO cp_ville VALUES (1933, 6927, 'Resteigne');
INSERT INTO cp_ville VALUES (1934, 6927, 'Tellin');
INSERT INTO cp_ville VALUES (1935, 6929, 'Daverdisse');
INSERT INTO cp_ville VALUES (1936, 6929, 'Gembes');
INSERT INTO cp_ville VALUES (1937, 6929, 'Haut-Fays');
INSERT INTO cp_ville VALUES (1938, 6929, 'Porcheresse (Lux.)');
INSERT INTO cp_ville VALUES (1939, 6940, 'Barvaux-sur-Ourthe');
INSERT INTO cp_ville VALUES (1940, 6940, 'Durbuy');
INSERT INTO cp_ville VALUES (1941, 6940, 'Grandhan');
INSERT INTO cp_ville VALUES (1942, 6940, 'Septon');
INSERT INTO cp_ville VALUES (1943, 6940, 'Wéris');
INSERT INTO cp_ville VALUES (1944, 6941, 'Bende');
INSERT INTO cp_ville VALUES (1945, 6941, 'Bomal-sur-Ourthe');
INSERT INTO cp_ville VALUES (1946, 6941, 'Borlon');
INSERT INTO cp_ville VALUES (1947, 6941, 'Heyd');
INSERT INTO cp_ville VALUES (1948, 6941, 'Izier');
INSERT INTO cp_ville VALUES (1949, 6941, 'Tohogne');
INSERT INTO cp_ville VALUES (1950, 6941, 'Villers-Sainte-Gertrude');
INSERT INTO cp_ville VALUES (1951, 6950, 'Harsin');
INSERT INTO cp_ville VALUES (1952, 6950, 'Nassogne');
INSERT INTO cp_ville VALUES (1953, 6951, 'Bande');
INSERT INTO cp_ville VALUES (1954, 6952, 'Grune');
INSERT INTO cp_ville VALUES (1955, 6953, 'Ambly');
INSERT INTO cp_ville VALUES (1956, 6953, 'Forrières');
INSERT INTO cp_ville VALUES (1957, 6953, 'Lesterny');
INSERT INTO cp_ville VALUES (1958, 6953, 'Masbourg');
INSERT INTO cp_ville VALUES (1959, 6960, 'Dochamps');
INSERT INTO cp_ville VALUES (1960, 6960, 'Grandmenil');
INSERT INTO cp_ville VALUES (1961, 6960, 'Harre');
INSERT INTO cp_ville VALUES (1962, 6960, 'Malempré');
INSERT INTO cp_ville VALUES (1963, 6960, 'Manhay');
INSERT INTO cp_ville VALUES (1964, 6960, 'Odeigne');
INSERT INTO cp_ville VALUES (1965, 6960, 'Vaux-Chavanne');
INSERT INTO cp_ville VALUES (1966, 6970, 'Tenneville');
INSERT INTO cp_ville VALUES (1967, 6971, 'Champlon');
INSERT INTO cp_ville VALUES (1968, 6972, 'Erneuville');
INSERT INTO cp_ville VALUES (1969, 6980, 'Beausaint');
INSERT INTO cp_ville VALUES (1970, 6980, 'La Roche-en-Ardenne');
INSERT INTO cp_ville VALUES (1971, 6982, 'Samrée');
INSERT INTO cp_ville VALUES (1972, 6983, 'Ortho');
INSERT INTO cp_ville VALUES (1973, 6984, 'Hives');
INSERT INTO cp_ville VALUES (1974, 6986, 'Halleux');
INSERT INTO cp_ville VALUES (1975, 6987, 'Beffe');
INSERT INTO cp_ville VALUES (1976, 6987, 'Hodister');
INSERT INTO cp_ville VALUES (1977, 6987, 'Marcourt');
INSERT INTO cp_ville VALUES (1978, 6987, 'Rendeux');
INSERT INTO cp_ville VALUES (1979, 6990, 'Fronville');
INSERT INTO cp_ville VALUES (1980, 6990, 'Hampteau');
INSERT INTO cp_ville VALUES (1981, 6990, 'Hotton');
INSERT INTO cp_ville VALUES (1982, 6990, 'Marenne');
INSERT INTO cp_ville VALUES (1983, 6997, 'Amonines');
INSERT INTO cp_ville VALUES (1984, 6997, 'Erezée');
INSERT INTO cp_ville VALUES (1985, 6997, 'Mormont');
INSERT INTO cp_ville VALUES (1986, 6997, 'Soy');
INSERT INTO cp_ville VALUES (1987, 7000, 'Mons');
INSERT INTO cp_ville VALUES (1988, 7010, 'S.H.A.P.E. België');
INSERT INTO cp_ville VALUES (1989, 7010, 'S.H.A.P.E. Belgique');
INSERT INTO cp_ville VALUES (1990, 7011, 'Ghlin');
INSERT INTO cp_ville VALUES (1991, 7012, 'Flénu');
INSERT INTO cp_ville VALUES (1992, 7012, 'Jemappes');
INSERT INTO cp_ville VALUES (1993, 7020, 'Maisières');
INSERT INTO cp_ville VALUES (1994, 7020, 'Nimy');
INSERT INTO cp_ville VALUES (1995, 7021, 'Havré');
INSERT INTO cp_ville VALUES (1996, 7022, 'Harmignies');
INSERT INTO cp_ville VALUES (1997, 7022, 'Harveng');
INSERT INTO cp_ville VALUES (1998, 7022, 'Hyon');
INSERT INTO cp_ville VALUES (1999, 7022, 'Mesvin');
INSERT INTO cp_ville VALUES (2000, 7022, 'Nouvelles');
INSERT INTO cp_ville VALUES (2001, 7024, 'Ciply');
INSERT INTO cp_ville VALUES (2002, 7030, 'Saint-Symphorien');
INSERT INTO cp_ville VALUES (2003, 7031, 'Villers-Saint-Ghislain');
INSERT INTO cp_ville VALUES (2004, 7032, 'Spiennes');
INSERT INTO cp_ville VALUES (2005, 7033, 'Cuesmes');
INSERT INTO cp_ville VALUES (2006, 7034, 'Obourg');
INSERT INTO cp_ville VALUES (2007, 7034, 'Saint-Denis (Ht.)');
INSERT INTO cp_ville VALUES (2008, 7040, 'Asquillies');
INSERT INTO cp_ville VALUES (2009, 7040, 'Aulnois');
INSERT INTO cp_ville VALUES (2010, 7040, 'Blaregnies');
INSERT INTO cp_ville VALUES (2011, 7040, 'Bougnies');
INSERT INTO cp_ville VALUES (2012, 7040, 'Genly');
INSERT INTO cp_ville VALUES (2013, 7040, 'Goegnies-Chaussée');
INSERT INTO cp_ville VALUES (2014, 7040, 'Quévy');
INSERT INTO cp_ville VALUES (2015, 7040, 'Quévy-le-Grand');
INSERT INTO cp_ville VALUES (2016, 7040, 'Quévy-le-Petit');
INSERT INTO cp_ville VALUES (2017, 7041, 'Givry');
INSERT INTO cp_ville VALUES (2018, 7041, 'Havay');
INSERT INTO cp_ville VALUES (2019, 7050, 'Erbaut');
INSERT INTO cp_ville VALUES (2020, 7050, 'Erbisoeul');
INSERT INTO cp_ville VALUES (2021, 7050, 'Herchies');
INSERT INTO cp_ville VALUES (2022, 7050, 'Jurbise');
INSERT INTO cp_ville VALUES (2023, 7050, 'Masnuy-Saint-Jean (Jurbise)');
INSERT INTO cp_ville VALUES (2024, 7050, 'Masnuy-Saint-Pierre');
INSERT INTO cp_ville VALUES (2025, 7060, 'Horrues');
INSERT INTO cp_ville VALUES (2026, 7060, 'Soignies');
INSERT INTO cp_ville VALUES (2027, 7061, 'Casteau (Soignies)');
INSERT INTO cp_ville VALUES (2028, 7061, 'Thieusies');
INSERT INTO cp_ville VALUES (2029, 7062, 'Naast');
INSERT INTO cp_ville VALUES (2030, 7063, 'Chaussée-Notre-Dame-Louvignies');
INSERT INTO cp_ville VALUES (2031, 7063, 'Neufvilles');
INSERT INTO cp_ville VALUES (2032, 7070, 'Gottignies');
INSERT INTO cp_ville VALUES (2033, 7070, 'Le Roeulx');
INSERT INTO cp_ville VALUES (2034, 7070, 'Mignault');
INSERT INTO cp_ville VALUES (2035, 7070, 'Thieu');
INSERT INTO cp_ville VALUES (2036, 7070, 'Ville-sur-Haine (Le Roeulx)');
INSERT INTO cp_ville VALUES (2037, 7080, 'Eugies (Frameries)');
INSERT INTO cp_ville VALUES (2038, 7080, 'Frameries');
INSERT INTO cp_ville VALUES (2039, 7080, 'La Bouverie');
INSERT INTO cp_ville VALUES (2040, 7080, 'Noirchain');
INSERT INTO cp_ville VALUES (2041, 7080, 'Sars-la-Bruyère');
INSERT INTO cp_ville VALUES (2042, 7090, 'Braine-le-Comte');
INSERT INTO cp_ville VALUES (2043, 7090, 'Hennuyères');
INSERT INTO cp_ville VALUES (2044, 7090, 'Henripont');
INSERT INTO cp_ville VALUES (2045, 7090, 'Petit-Roeulx-lez-Braine');
INSERT INTO cp_ville VALUES (2046, 7090, 'Ronquières');
INSERT INTO cp_ville VALUES (2047, 7090, 'Steenkerque (Ht.)');
INSERT INTO cp_ville VALUES (2048, 7100, 'Haine-Saint-Paul');
INSERT INTO cp_ville VALUES (2049, 7100, 'Haine-Saint-Pierre');
INSERT INTO cp_ville VALUES (2050, 7100, 'La Louvière');
INSERT INTO cp_ville VALUES (2051, 7100, 'Saint-Vaast');
INSERT INTO cp_ville VALUES (2052, 7100, 'Trivières');
INSERT INTO cp_ville VALUES (2053, 7110, 'Boussoit');
INSERT INTO cp_ville VALUES (2054, 7110, 'Houdeng-Aimeries');
INSERT INTO cp_ville VALUES (2055, 7110, 'Houdeng-Goegnies (La Louvière)');
INSERT INTO cp_ville VALUES (2056, 7110, 'Maurage');
INSERT INTO cp_ville VALUES (2057, 7110, 'Strépy-Bracquegnies');
INSERT INTO cp_ville VALUES (2058, 7120, 'Croix-lez-Rouveroy');
INSERT INTO cp_ville VALUES (2059, 7120, 'Estinnes');
INSERT INTO cp_ville VALUES (2060, 7120, 'Estinnes-au-Mont');
INSERT INTO cp_ville VALUES (2061, 7120, 'Estinnes-au-Val');
INSERT INTO cp_ville VALUES (2062, 7120, 'Fauroeulx');
INSERT INTO cp_ville VALUES (2063, 7120, 'Haulchin');
INSERT INTO cp_ville VALUES (2064, 7120, 'Peissant');
INSERT INTO cp_ville VALUES (2065, 7120, 'Rouveroy (Ht.)');
INSERT INTO cp_ville VALUES (2066, 7120, 'Vellereille-les-Brayeux');
INSERT INTO cp_ville VALUES (2067, 7120, 'Vellereille-le-Sec');
INSERT INTO cp_ville VALUES (2068, 7130, 'Battignies');
INSERT INTO cp_ville VALUES (2069, 7130, 'Binche');
INSERT INTO cp_ville VALUES (2070, 7130, 'Bray');
INSERT INTO cp_ville VALUES (2071, 7131, 'Waudrez');
INSERT INTO cp_ville VALUES (2072, 7133, 'Buvrinnes');
INSERT INTO cp_ville VALUES (2073, 7134, 'Epinois');
INSERT INTO cp_ville VALUES (2074, 7134, 'Leval-Trahegnies');
INSERT INTO cp_ville VALUES (2075, 7134, 'Péronnes-lez-Binche');
INSERT INTO cp_ville VALUES (2076, 7134, 'Ressaix');
INSERT INTO cp_ville VALUES (2077, 7140, 'Morlanwelz');
INSERT INTO cp_ville VALUES (2078, 7140, 'Morlanwelz-Mariemont');
INSERT INTO cp_ville VALUES (2079, 7141, 'Carnières');
INSERT INTO cp_ville VALUES (2080, 7141, 'Mont-Sainte-Aldegonde');
INSERT INTO cp_ville VALUES (2081, 7160, 'Chapelle-lez-Herlaimont');
INSERT INTO cp_ville VALUES (2082, 7160, 'Godarville');
INSERT INTO cp_ville VALUES (2083, 7160, 'Piéton');
INSERT INTO cp_ville VALUES (2084, 7170, 'Bellecourt');
INSERT INTO cp_ville VALUES (2085, 7170, 'Bois-d\'Haine');
INSERT INTO cp_ville VALUES (2086, 7170, 'Fayt-lez-Manage');
INSERT INTO cp_ville VALUES (2087, 7170, 'La Hestre');
INSERT INTO cp_ville VALUES (2088, 7170, 'Manage');
INSERT INTO cp_ville VALUES (2089, 7180, 'Seneffe');
INSERT INTO cp_ville VALUES (2090, 7181, 'Arquennes');
INSERT INTO cp_ville VALUES (2091, 7181, 'Familleureux');
INSERT INTO cp_ville VALUES (2092, 7181, 'Feluy');
INSERT INTO cp_ville VALUES (2093, 7181, 'Petit-Roeulx-lez-Nivelles');
INSERT INTO cp_ville VALUES (2094, 7190, 'Ecaussinnes');
INSERT INTO cp_ville VALUES (2095, 7190, 'Ecaussinnes-d\'Enghien');
INSERT INTO cp_ville VALUES (2096, 7190, 'Marche-lez-Ecaussinnes');
INSERT INTO cp_ville VALUES (2097, 7191, 'Ecaussinnes-Lalaing');
INSERT INTO cp_ville VALUES (2098, 7300, 'Boussu');
INSERT INTO cp_ville VALUES (2099, 7301, 'Hornu');
INSERT INTO cp_ville VALUES (2100, 7320, 'Bernissart');
INSERT INTO cp_ville VALUES (2101, 7321, 'Blaton');
INSERT INTO cp_ville VALUES (2102, 7321, 'Harchies');
INSERT INTO cp_ville VALUES (2103, 7322, 'Pommeroeul');
INSERT INTO cp_ville VALUES (2104, 7322, 'Ville-Pommeroeul');
INSERT INTO cp_ville VALUES (2105, 7330, 'Saint-Ghislain');
INSERT INTO cp_ville VALUES (2106, 7331, 'Baudour');
INSERT INTO cp_ville VALUES (2107, 7332, 'Neufmaison');
INSERT INTO cp_ville VALUES (2108, 7332, 'Sirault');
INSERT INTO cp_ville VALUES (2109, 7333, 'Tertre');
INSERT INTO cp_ville VALUES (2110, 7334, 'Hautrage');
INSERT INTO cp_ville VALUES (2111, 7334, 'Villerot');
INSERT INTO cp_ville VALUES (2112, 7340, 'Colfontaine');
INSERT INTO cp_ville VALUES (2113, 7340, 'Paturages');
INSERT INTO cp_ville VALUES (2114, 7340, 'Warquignies');
INSERT INTO cp_ville VALUES (2115, 7340, 'Wasmes');
INSERT INTO cp_ville VALUES (2116, 7350, 'Hainin');
INSERT INTO cp_ville VALUES (2117, 7350, 'Hensies');
INSERT INTO cp_ville VALUES (2118, 7350, 'Montroeul-sur-Haine');
INSERT INTO cp_ville VALUES (2119, 7350, 'Thulin');
INSERT INTO cp_ville VALUES (2120, 7370, 'Blaugies');
INSERT INTO cp_ville VALUES (2121, 7370, 'Dour');
INSERT INTO cp_ville VALUES (2122, 7370, 'Elouges');
INSERT INTO cp_ville VALUES (2123, 7370, 'Wihéries');
INSERT INTO cp_ville VALUES (2124, 7380, 'Baisieux');
INSERT INTO cp_ville VALUES (2125, 7380, 'Quiévrain');
INSERT INTO cp_ville VALUES (2126, 7382, 'Audregnies');
INSERT INTO cp_ville VALUES (2127, 7387, 'Angre');
INSERT INTO cp_ville VALUES (2128, 7387, 'Angreau');
INSERT INTO cp_ville VALUES (2129, 7387, 'Athis');
INSERT INTO cp_ville VALUES (2130, 7387, 'Autreppe');
INSERT INTO cp_ville VALUES (2131, 7387, 'Erquennes');
INSERT INTO cp_ville VALUES (2132, 7387, 'Fayt-le-Franc');
INSERT INTO cp_ville VALUES (2133, 7387, 'Honnelles');
INSERT INTO cp_ville VALUES (2134, 7387, 'Marchipont');
INSERT INTO cp_ville VALUES (2135, 7387, 'Montignies-sur-Roc');
INSERT INTO cp_ville VALUES (2136, 7387, 'Onnezies');
INSERT INTO cp_ville VALUES (2137, 7387, 'Roisin');
INSERT INTO cp_ville VALUES (2138, 7390, 'Quaregnon');
INSERT INTO cp_ville VALUES (2139, 7390, 'Wasmuel');
INSERT INTO cp_ville VALUES (2140, 7500, 'Ere');
INSERT INTO cp_ville VALUES (2141, 7500, 'Saint-Maur');
INSERT INTO cp_ville VALUES (2142, 7500, 'Tournai');
INSERT INTO cp_ville VALUES (2143, 7501, 'Orcq');
INSERT INTO cp_ville VALUES (2144, 7502, 'Esplechin');
INSERT INTO cp_ville VALUES (2145, 7503, 'Froyennes');
INSERT INTO cp_ville VALUES (2146, 7504, 'Froidmont');
INSERT INTO cp_ville VALUES (2147, 7506, 'Willemeau');
INSERT INTO cp_ville VALUES (2148, 7520, 'Ramegnies-Chin');
INSERT INTO cp_ville VALUES (2149, 7520, 'Templeuve');
INSERT INTO cp_ville VALUES (2150, 7521, 'Chercq');
INSERT INTO cp_ville VALUES (2151, 7522, 'Blandain');
INSERT INTO cp_ville VALUES (2152, 7522, 'Hertain');
INSERT INTO cp_ville VALUES (2153, 7522, 'Lamain');
INSERT INTO cp_ville VALUES (2154, 7522, 'Marquain');
INSERT INTO cp_ville VALUES (2155, 7530, 'Gaurain-Ramecroix (Tournai)');
INSERT INTO cp_ville VALUES (2156, 7531, 'Havinnes');
INSERT INTO cp_ville VALUES (2157, 7532, 'Beclers');
INSERT INTO cp_ville VALUES (2158, 7533, 'Thimougies');
INSERT INTO cp_ville VALUES (2159, 7534, 'Barry');
INSERT INTO cp_ville VALUES (2160, 7534, 'Maulde');
INSERT INTO cp_ville VALUES (2161, 7536, 'Vaulx (Tournai)');
INSERT INTO cp_ville VALUES (2162, 7538, 'Vezon');
INSERT INTO cp_ville VALUES (2163, 7540, 'Kain');
INSERT INTO cp_ville VALUES (2164, 7540, 'Melles');
INSERT INTO cp_ville VALUES (2165, 7540, 'Quartes');
INSERT INTO cp_ville VALUES (2166, 7540, 'Rumillies');
INSERT INTO cp_ville VALUES (2167, 7542, 'Mont-Saint-Aubert');
INSERT INTO cp_ville VALUES (2168, 7543, 'Mourcourt');
INSERT INTO cp_ville VALUES (2169, 7548, 'Warchin');
INSERT INTO cp_ville VALUES (2170, 7600, 'Péruwelz');
INSERT INTO cp_ville VALUES (2171, 7601, 'Roucourt');
INSERT INTO cp_ville VALUES (2172, 7602, 'Bury');
INSERT INTO cp_ville VALUES (2173, 7603, 'Bon-Secours');
INSERT INTO cp_ville VALUES (2174, 7604, 'Baugnies');
INSERT INTO cp_ville VALUES (2175, 7604, 'Braffe');
INSERT INTO cp_ville VALUES (2176, 7604, 'Brasmenil');
INSERT INTO cp_ville VALUES (2177, 7604, 'Callenelle');
INSERT INTO cp_ville VALUES (2178, 7604, 'Wasmes-Audemez-Briffoeil');
INSERT INTO cp_ville VALUES (2179, 7608, 'Wiers');
INSERT INTO cp_ville VALUES (2180, 7610, 'Rumes');
INSERT INTO cp_ville VALUES (2181, 7611, 'La Glanerie');
INSERT INTO cp_ville VALUES (2182, 7618, 'Taintignies');
INSERT INTO cp_ville VALUES (2183, 7620, 'Bléharies');
INSERT INTO cp_ville VALUES (2184, 7620, 'Brunehaut');
INSERT INTO cp_ville VALUES (2185, 7620, 'Guignies');
INSERT INTO cp_ville VALUES (2186, 7620, 'Hollain');
INSERT INTO cp_ville VALUES (2187, 7620, 'Jollain-Merlin');
INSERT INTO cp_ville VALUES (2188, 7620, 'Wez-Velvain');
INSERT INTO cp_ville VALUES (2189, 7621, 'Lesdain');
INSERT INTO cp_ville VALUES (2190, 7622, 'Laplaigne');
INSERT INTO cp_ville VALUES (2191, 7623, 'Rongy');
INSERT INTO cp_ville VALUES (2192, 7624, 'Howardries');
INSERT INTO cp_ville VALUES (2193, 7640, 'Antoing');
INSERT INTO cp_ville VALUES (2194, 7640, 'Maubray');
INSERT INTO cp_ville VALUES (2195, 7640, 'Péronnes-lez-Antoing');
INSERT INTO cp_ville VALUES (2196, 7641, 'Bruyelle');
INSERT INTO cp_ville VALUES (2197, 7642, 'Calonne');
INSERT INTO cp_ville VALUES (2198, 7643, 'Fontenoy');
INSERT INTO cp_ville VALUES (2199, 7700, 'Luingne');
INSERT INTO cp_ville VALUES (2200, 7700, 'Moeskroen');
INSERT INTO cp_ville VALUES (2201, 7700, 'Mouscron');
INSERT INTO cp_ville VALUES (2202, 7711, 'Dottenijs');
INSERT INTO cp_ville VALUES (2203, 7711, 'Dottignies');
INSERT INTO cp_ville VALUES (2204, 7712, 'Herseaux');
INSERT INTO cp_ville VALUES (2205, 7730, 'Bailleul');
INSERT INTO cp_ville VALUES (2206, 7730, 'Estaimbourg');
INSERT INTO cp_ville VALUES (2207, 7730, 'Estaimpuis');
INSERT INTO cp_ville VALUES (2208, 7730, 'Evregnies');
INSERT INTO cp_ville VALUES (2209, 7730, 'Leers-Nord');
INSERT INTO cp_ville VALUES (2210, 7730, 'Néchin');
INSERT INTO cp_ville VALUES (2211, 7730, 'Saint-Léger (Ht.)');
INSERT INTO cp_ville VALUES (2212, 7740, 'Pecq');
INSERT INTO cp_ville VALUES (2213, 7740, 'Warcoing');
INSERT INTO cp_ville VALUES (2214, 7742, 'Hérinnes-lez-Pecq');
INSERT INTO cp_ville VALUES (2215, 7743, 'Esquelmes');
INSERT INTO cp_ville VALUES (2216, 7743, 'Obigies');
INSERT INTO cp_ville VALUES (2217, 7750, 'Amougies');
INSERT INTO cp_ville VALUES (2218, 7750, 'Anseroeul');
INSERT INTO cp_ville VALUES (2219, 7750, 'Mont-de-l\'Enclus');
INSERT INTO cp_ville VALUES (2220, 7750, 'Orroir');
INSERT INTO cp_ville VALUES (2221, 7750, 'Russeignies');
INSERT INTO cp_ville VALUES (2222, 7760, 'Celles (Ht.)');
INSERT INTO cp_ville VALUES (2223, 7760, 'Escanaffles');
INSERT INTO cp_ville VALUES (2224, 7760, 'Molenbaix');
INSERT INTO cp_ville VALUES (2225, 7760, 'Popuelles');
INSERT INTO cp_ville VALUES (2226, 7760, 'Pottes');
INSERT INTO cp_ville VALUES (2227, 7760, 'Velaines');
INSERT INTO cp_ville VALUES (2228, 7780, 'Comines');
INSERT INTO cp_ville VALUES (2229, 7780, 'Comines-Warneton');
INSERT INTO cp_ville VALUES (2230, 7780, 'Komen');
INSERT INTO cp_ville VALUES (2231, 7780, 'Komen-Waasten');
INSERT INTO cp_ville VALUES (2232, 7781, 'Houthem (Comines)');
INSERT INTO cp_ville VALUES (2233, 7782, 'Ploegsteert');
INSERT INTO cp_ville VALUES (2234, 7783, 'Bizet');
INSERT INTO cp_ville VALUES (2235, 7784, 'Bas-Warneton');
INSERT INTO cp_ville VALUES (2236, 7784, 'Neerwaasten');
INSERT INTO cp_ville VALUES (2237, 7784, 'Waasten');
INSERT INTO cp_ville VALUES (2238, 7784, 'Warneton');
INSERT INTO cp_ville VALUES (2239, 7800, 'Ath');
INSERT INTO cp_ville VALUES (2240, 7800, 'Lanquesaint');
INSERT INTO cp_ville VALUES (2241, 7801, 'Irchonwelz');
INSERT INTO cp_ville VALUES (2242, 7802, 'Ormeignies');
INSERT INTO cp_ville VALUES (2243, 7803, 'Bouvignies');
INSERT INTO cp_ville VALUES (2244, 7804, 'Ostiches');
INSERT INTO cp_ville VALUES (2245, 7804, 'Rebaix');
INSERT INTO cp_ville VALUES (2246, 7810, 'Maffle');
INSERT INTO cp_ville VALUES (2247, 7811, 'Arbre (Ht.)');
INSERT INTO cp_ville VALUES (2248, 7812, 'Houtaing');
INSERT INTO cp_ville VALUES (2249, 7812, 'Ligne');
INSERT INTO cp_ville VALUES (2250, 7812, 'Mainvault');
INSERT INTO cp_ville VALUES (2251, 7812, 'Moulbaix');
INSERT INTO cp_ville VALUES (2252, 7812, 'Villers-Notre-Dame');
INSERT INTO cp_ville VALUES (2253, 7812, 'Villers-Saint-Amand');
INSERT INTO cp_ville VALUES (2254, 7822, 'Ghislenghien');
INSERT INTO cp_ville VALUES (2255, 7822, 'Isières');
INSERT INTO cp_ville VALUES (2256, 7822, 'Meslin-l\'Evêque');
INSERT INTO cp_ville VALUES (2257, 7823, 'Gibecq');
INSERT INTO cp_ville VALUES (2258, 7830, 'Bassilly');
INSERT INTO cp_ville VALUES (2259, 7830, 'Fouleng');
INSERT INTO cp_ville VALUES (2260, 7830, 'Gondregnies');
INSERT INTO cp_ville VALUES (2261, 7830, 'Graty');
INSERT INTO cp_ville VALUES (2262, 7830, 'Hellebecq');
INSERT INTO cp_ville VALUES (2263, 7830, 'Hoves (Ht.)');
INSERT INTO cp_ville VALUES (2264, 7830, 'Silly');
INSERT INTO cp_ville VALUES (2265, 7830, 'Thoricourt');
INSERT INTO cp_ville VALUES (2266, 7850, 'Edingen');
INSERT INTO cp_ville VALUES (2267, 7850, 'Enghien');
INSERT INTO cp_ville VALUES (2268, 7850, 'Lettelingen');
INSERT INTO cp_ville VALUES (2269, 7850, 'Marcq');
INSERT INTO cp_ville VALUES (2270, 7850, 'Mark');
INSERT INTO cp_ville VALUES (2271, 7850, 'Petit-Enghien');
INSERT INTO cp_ville VALUES (2272, 7860, 'Lessines');
INSERT INTO cp_ville VALUES (2273, 7861, 'Papignies');
INSERT INTO cp_ville VALUES (2274, 7861, 'Wannebecq');
INSERT INTO cp_ville VALUES (2275, 7862, 'Ogy');
INSERT INTO cp_ville VALUES (2276, 7863, 'Ghoy');
INSERT INTO cp_ville VALUES (2277, 7864, 'Deux-Acren');
INSERT INTO cp_ville VALUES (2278, 7866, 'Bois-de-Lessines');
INSERT INTO cp_ville VALUES (2279, 7866, 'Ollignies');
INSERT INTO cp_ville VALUES (2280, 7870, 'Bauffe');
INSERT INTO cp_ville VALUES (2281, 7870, 'Cambron-Saint-Vincent');
INSERT INTO cp_ville VALUES (2282, 7870, 'Lens');
INSERT INTO cp_ville VALUES (2283, 7870, 'Lombise');
INSERT INTO cp_ville VALUES (2284, 7870, 'Montignies-lez-Lens');
INSERT INTO cp_ville VALUES (2285, 7880, 'Flobecq');
INSERT INTO cp_ville VALUES (2286, 7880, 'Vloesberg');
INSERT INTO cp_ville VALUES (2287, 7890, 'Ellezelles');
INSERT INTO cp_ville VALUES (2288, 7890, 'Lahamaide');
INSERT INTO cp_ville VALUES (2289, 7890, 'Wodecq');
INSERT INTO cp_ville VALUES (2290, 7900, 'Grandmetz');
INSERT INTO cp_ville VALUES (2291, 7900, 'Leuze-en-Hainaut');
INSERT INTO cp_ville VALUES (2292, 7901, 'Thieulain');
INSERT INTO cp_ville VALUES (2293, 7903, 'Blicquy');
INSERT INTO cp_ville VALUES (2294, 7903, 'Chapelle-à-Oie');
INSERT INTO cp_ville VALUES (2295, 7903, 'Chapelle-à-Wattines');
INSERT INTO cp_ville VALUES (2296, 7904, 'Pipaix');
INSERT INTO cp_ville VALUES (2297, 7904, 'Tourpes');
INSERT INTO cp_ville VALUES (2298, 7904, 'Willaupuis');
INSERT INTO cp_ville VALUES (2299, 7906, 'Gallaix');
INSERT INTO cp_ville VALUES (2300, 7910, 'Anvaing');
INSERT INTO cp_ville VALUES (2301, 7910, 'Arc-Ainières');
INSERT INTO cp_ville VALUES (2302, 7910, 'Arc-Wattripont');
INSERT INTO cp_ville VALUES (2303, 7910, 'Cordes');
INSERT INTO cp_ville VALUES (2304, 7910, 'Ellignies-lez-Frasnes');
INSERT INTO cp_ville VALUES (2305, 7910, 'Forest (Ht.)');
INSERT INTO cp_ville VALUES (2306, 7910, 'Frasnes-lez-Anvaing');
INSERT INTO cp_ville VALUES (2307, 7910, 'Wattripont');
INSERT INTO cp_ville VALUES (2308, 7911, 'Buissenal');
INSERT INTO cp_ville VALUES (2309, 7911, 'Frasnes-lez-Buissenal');
INSERT INTO cp_ville VALUES (2310, 7911, 'Hacquegnies');
INSERT INTO cp_ville VALUES (2311, 7911, 'Herquegies');
INSERT INTO cp_ville VALUES (2312, 7911, 'Montroeul-au-Bois');
INSERT INTO cp_ville VALUES (2313, 7911, 'Moustier (Ht.)');
INSERT INTO cp_ville VALUES (2314, 7911, 'Oeudeghien');
INSERT INTO cp_ville VALUES (2315, 7912, 'Dergneau');
INSERT INTO cp_ville VALUES (2316, 7912, 'Saint-Sauveur');
INSERT INTO cp_ville VALUES (2317, 7940, 'Brugelette');
INSERT INTO cp_ville VALUES (2318, 7940, 'Cambron-Casteau');
INSERT INTO cp_ville VALUES (2319, 7941, 'Attre');
INSERT INTO cp_ville VALUES (2320, 7942, 'Mévergnies-lez-Lens');
INSERT INTO cp_ville VALUES (2321, 7943, 'Gages');
INSERT INTO cp_ville VALUES (2322, 7950, 'Chièvres');
INSERT INTO cp_ville VALUES (2323, 7950, 'Grosage');
INSERT INTO cp_ville VALUES (2324, 7950, 'Huissignies');
INSERT INTO cp_ville VALUES (2325, 7950, 'Ladeuze');
INSERT INTO cp_ville VALUES (2326, 7950, 'Tongre-Saint-Martin');
INSERT INTO cp_ville VALUES (2327, 7951, 'Tongre-Notre-Dame');
INSERT INTO cp_ville VALUES (2328, 7970, 'Beloeil');
INSERT INTO cp_ville VALUES (2329, 7971, 'Basècles');
INSERT INTO cp_ville VALUES (2330, 7971, 'Ramegnies');
INSERT INTO cp_ville VALUES (2331, 7971, 'Thumaide');
INSERT INTO cp_ville VALUES (2332, 7971, 'Wadelincourt');
INSERT INTO cp_ville VALUES (2333, 7972, 'Aubechies');
INSERT INTO cp_ville VALUES (2334, 7972, 'Ellignies-Sainte-Anne');
INSERT INTO cp_ville VALUES (2335, 7972, 'Quevaucamps');
INSERT INTO cp_ville VALUES (2336, 7973, 'Grandglise');
INSERT INTO cp_ville VALUES (2337, 7973, 'Stambruges');
INSERT INTO cp_ville VALUES (2338, 8000, 'Brugge');
INSERT INTO cp_ville VALUES (2339, 8000, 'Koolkerke');
INSERT INTO cp_ville VALUES (2340, 8020, 'Hertsberge');
INSERT INTO cp_ville VALUES (2341, 8020, 'Oostkamp');
INSERT INTO cp_ville VALUES (2342, 8020, 'Ruddervoorde');
INSERT INTO cp_ville VALUES (2343, 8020, 'Waardamme');
INSERT INTO cp_ville VALUES (2344, 8200, 'Sint-Andries');
INSERT INTO cp_ville VALUES (2345, 8200, 'Sint-Michiels');
INSERT INTO cp_ville VALUES (2346, 8210, 'Loppem');
INSERT INTO cp_ville VALUES (2347, 8210, 'Veldegem');
INSERT INTO cp_ville VALUES (2348, 8210, 'Zedelgem');
INSERT INTO cp_ville VALUES (2349, 8211, 'Aartrijke');
INSERT INTO cp_ville VALUES (2350, 8300, 'Knokke');
INSERT INTO cp_ville VALUES (2351, 8300, 'Knokke-Heist');
INSERT INTO cp_ville VALUES (2352, 8300, 'Westkapelle');
INSERT INTO cp_ville VALUES (2353, 8301, 'Heist-aan-Zee');
INSERT INTO cp_ville VALUES (2354, 8301, 'Ramskapelle (Knokke-Heist)');
INSERT INTO cp_ville VALUES (2355, 8310, 'Assebroek');
INSERT INTO cp_ville VALUES (2356, 8310, 'Sint-Kruis (Brugge)');
INSERT INTO cp_ville VALUES (2357, 8340, 'Damme');
INSERT INTO cp_ville VALUES (2358, 8340, 'Hoeke');
INSERT INTO cp_ville VALUES (2359, 8340, 'Lapscheure');
INSERT INTO cp_ville VALUES (2360, 8340, 'Moerkerke');
INSERT INTO cp_ville VALUES (2361, 8340, 'Oostkerke (Damme)');
INSERT INTO cp_ville VALUES (2362, 8340, 'Sijsele');
INSERT INTO cp_ville VALUES (2363, 8370, 'Blankenberge');
INSERT INTO cp_ville VALUES (2364, 8370, 'Uitkerke');
INSERT INTO cp_ville VALUES (2365, 8377, 'Houtave');
INSERT INTO cp_ville VALUES (2366, 8377, 'Meetkerke');
INSERT INTO cp_ville VALUES (2367, 8377, 'Nieuwmunster');
INSERT INTO cp_ville VALUES (2368, 8377, 'Zuienkerke');
INSERT INTO cp_ville VALUES (2369, 8380, 'Dudzele');
INSERT INTO cp_ville VALUES (2370, 8380, 'Lissewege');
INSERT INTO cp_ville VALUES (2371, 8380, 'Zeebrugge (Brugge)');
INSERT INTO cp_ville VALUES (2372, 8400, 'Oostende');
INSERT INTO cp_ville VALUES (2373, 8400, 'Stene');
INSERT INTO cp_ville VALUES (2374, 8400, 'Zandvoorde (Oostende)');
INSERT INTO cp_ville VALUES (2375, 8420, 'De Haan');
INSERT INTO cp_ville VALUES (2376, 8420, 'Klemskerke');
INSERT INTO cp_ville VALUES (2377, 8420, 'Wenduine');
INSERT INTO cp_ville VALUES (2378, 8421, 'Vlissegem');
INSERT INTO cp_ville VALUES (2379, 8430, 'Middelkerke');
INSERT INTO cp_ville VALUES (2380, 8431, 'Wilskerke');
INSERT INTO cp_ville VALUES (2381, 8432, 'Leffinge');
INSERT INTO cp_ville VALUES (2382, 8433, 'Mannekensvere');
INSERT INTO cp_ville VALUES (2383, 8433, 'Schore');
INSERT INTO cp_ville VALUES (2384, 8433, 'Sint-Pieters-Kapelle (W.-Vl.)');
INSERT INTO cp_ville VALUES (2385, 8433, 'Slijpe');
INSERT INTO cp_ville VALUES (2386, 8433, 'Spermalie');
INSERT INTO cp_ville VALUES (2387, 8434, 'Lombardsijde');
INSERT INTO cp_ville VALUES (2388, 8434, 'Westende');
INSERT INTO cp_ville VALUES (2389, 8450, 'Bredene');
INSERT INTO cp_ville VALUES (2390, 8460, 'Ettelgem');
INSERT INTO cp_ville VALUES (2391, 8460, 'Oudenburg');
INSERT INTO cp_ville VALUES (2392, 8460, 'Roksem');
INSERT INTO cp_ville VALUES (2393, 8460, 'Westkerke');
INSERT INTO cp_ville VALUES (2394, 8470, 'Gistel');
INSERT INTO cp_ville VALUES (2395, 8470, 'Moere');
INSERT INTO cp_ville VALUES (2396, 8470, 'Snaaskerke');
INSERT INTO cp_ville VALUES (2397, 8470, 'Zevekote');
INSERT INTO cp_ville VALUES (2398, 8480, 'Bekegem');
INSERT INTO cp_ville VALUES (2399, 8480, 'Eernegem');
INSERT INTO cp_ville VALUES (2400, 8480, 'Ichtegem');
INSERT INTO cp_ville VALUES (2401, 8490, 'Jabbeke');
INSERT INTO cp_ville VALUES (2402, 8490, 'Snellegem');
INSERT INTO cp_ville VALUES (2403, 8490, 'Stalhille');
INSERT INTO cp_ville VALUES (2404, 8490, 'Varsenare');
INSERT INTO cp_ville VALUES (2405, 8490, 'Zerkegem');
INSERT INTO cp_ville VALUES (2406, 8500, 'Kortrijk');
INSERT INTO cp_ville VALUES (2407, 8501, 'Bissegem');
INSERT INTO cp_ville VALUES (2408, 8501, 'Heule');
INSERT INTO cp_ville VALUES (2409, 8510, 'Bellegem');
INSERT INTO cp_ville VALUES (2410, 8510, 'Kooigem');
INSERT INTO cp_ville VALUES (2411, 8510, 'Marke (Kortrijk)');
INSERT INTO cp_ville VALUES (2412, 8510, 'Rollegem');
INSERT INTO cp_ville VALUES (2413, 8511, 'Aalbeke');
INSERT INTO cp_ville VALUES (2414, 8520, 'Kuurne');
INSERT INTO cp_ville VALUES (2415, 8530, 'Harelbeke');
INSERT INTO cp_ville VALUES (2416, 8531, 'Bavikhove');
INSERT INTO cp_ville VALUES (2417, 8531, 'Hulste');
INSERT INTO cp_ville VALUES (2418, 8540, 'Deerlijk');
INSERT INTO cp_ville VALUES (2419, 8550, 'Zwevegem');
INSERT INTO cp_ville VALUES (2420, 8551, 'Heestert');
INSERT INTO cp_ville VALUES (2421, 8552, 'Moen');
INSERT INTO cp_ville VALUES (2422, 8553, 'Otegem');
INSERT INTO cp_ville VALUES (2423, 8554, 'Sint-Denijs');
INSERT INTO cp_ville VALUES (2424, 8560, 'Gullegem');
INSERT INTO cp_ville VALUES (2425, 8560, 'Moorsele');
INSERT INTO cp_ville VALUES (2426, 8560, 'Wevelgem');
INSERT INTO cp_ville VALUES (2427, 8570, 'Anzegem');
INSERT INTO cp_ville VALUES (2428, 8570, 'Gijzelbrechtegem');
INSERT INTO cp_ville VALUES (2429, 8570, 'Ingooigem');
INSERT INTO cp_ville VALUES (2430, 8570, 'Vichte');
INSERT INTO cp_ville VALUES (2431, 8572, 'Kaster');
INSERT INTO cp_ville VALUES (2432, 8573, 'Tiegem');
INSERT INTO cp_ville VALUES (2433, 8580, 'Avelgem');
INSERT INTO cp_ville VALUES (2434, 8581, 'Kerkhove');
INSERT INTO cp_ville VALUES (2435, 8581, 'Waarmaarde');
INSERT INTO cp_ville VALUES (2436, 8582, 'Outrijve');
INSERT INTO cp_ville VALUES (2437, 8583, 'Bossuit');
INSERT INTO cp_ville VALUES (2438, 8587, 'Espierres');
INSERT INTO cp_ville VALUES (2439, 8587, 'Espierres-Helchin');
INSERT INTO cp_ville VALUES (2440, 8587, 'Helchin');
INSERT INTO cp_ville VALUES (2441, 8587, 'Helkijn');
INSERT INTO cp_ville VALUES (2442, 8587, 'Spiere');
INSERT INTO cp_ville VALUES (2443, 8587, 'Spiere-Helkijn');
INSERT INTO cp_ville VALUES (2444, 8600, 'Beerst');
INSERT INTO cp_ville VALUES (2445, 8600, 'Diksmuide');
INSERT INTO cp_ville VALUES (2446, 8600, 'Driekapellen');
INSERT INTO cp_ville VALUES (2447, 8600, 'Esen');
INSERT INTO cp_ville VALUES (2448, 8600, 'Kaaskerke');
INSERT INTO cp_ville VALUES (2449, 8600, 'Keiem');
INSERT INTO cp_ville VALUES (2450, 8600, 'Lampernisse');
INSERT INTO cp_ville VALUES (2451, 8600, 'Leke');
INSERT INTO cp_ville VALUES (2452, 8600, 'Nieuwkapelle');
INSERT INTO cp_ville VALUES (2453, 8600, 'Oostkerke (Diksmuide)');
INSERT INTO cp_ville VALUES (2454, 8600, 'Oudekapelle');
INSERT INTO cp_ville VALUES (2455, 8600, 'Pervijze');
INSERT INTO cp_ville VALUES (2456, 8600, 'Sint-Jacobs-Kapelle');
INSERT INTO cp_ville VALUES (2457, 8600, 'Stuivekenskerke');
INSERT INTO cp_ville VALUES (2458, 8600, 'Vladslo');
INSERT INTO cp_ville VALUES (2459, 8600, 'Woumen');
INSERT INTO cp_ville VALUES (2460, 8610, 'Handzame');
INSERT INTO cp_ville VALUES (2461, 8610, 'Kortemark');
INSERT INTO cp_ville VALUES (2462, 8610, 'Werken');
INSERT INTO cp_ville VALUES (2463, 8610, 'Zarren');
INSERT INTO cp_ville VALUES (2464, 8620, 'Nieuwpoort');
INSERT INTO cp_ville VALUES (2465, 8620, 'Ramskapelle (Nieuwpoort)');
INSERT INTO cp_ville VALUES (2466, 8620, 'Sint-Joris (Nieuwpoort)');
INSERT INTO cp_ville VALUES (2467, 8630, 'Avekapelle');
INSERT INTO cp_ville VALUES (2468, 8630, 'Beauvoorde');
INSERT INTO cp_ville VALUES (2469, 8630, 'Booitshoeke');
INSERT INTO cp_ville VALUES (2470, 8630, 'Bulskamp');
INSERT INTO cp_ville VALUES (2471, 8630, 'De Moeren');
INSERT INTO cp_ville VALUES (2472, 8630, 'Eggewaartskapelle');
INSERT INTO cp_ville VALUES (2473, 8630, 'Houtem (W.-Vl.)');
INSERT INTO cp_ville VALUES (2474, 8630, 'Steenkerke (W.-Vl.)');
INSERT INTO cp_ville VALUES (2475, 8630, 'Veurne');
INSERT INTO cp_ville VALUES (2476, 8630, 'Vinkem');
INSERT INTO cp_ville VALUES (2477, 8630, 'Wulveringem');
INSERT INTO cp_ville VALUES (2478, 8630, 'Zoutenaaie');
INSERT INTO cp_ville VALUES (2479, 8640, 'Oostvleteren');
INSERT INTO cp_ville VALUES (2480, 8640, 'Vleteren');
INSERT INTO cp_ville VALUES (2481, 8640, 'Westvleteren');
INSERT INTO cp_ville VALUES (2482, 8640, 'Woesten');
INSERT INTO cp_ville VALUES (2483, 8647, 'Lo');
INSERT INTO cp_ville VALUES (2484, 8647, 'Lo-Reninge');
INSERT INTO cp_ville VALUES (2485, 8647, 'Noordschote');
INSERT INTO cp_ville VALUES (2486, 8647, 'Pollinkhove');
INSERT INTO cp_ville VALUES (2487, 8647, 'Reninge');
INSERT INTO cp_ville VALUES (2488, 8650, 'Houthulst');
INSERT INTO cp_ville VALUES (2489, 8650, 'Klerken');
INSERT INTO cp_ville VALUES (2490, 8650, 'Merkem');
INSERT INTO cp_ville VALUES (2491, 8660, 'Adinkerke');
INSERT INTO cp_ville VALUES (2492, 8660, 'De Panne');
INSERT INTO cp_ville VALUES (2493, 8670, 'Koksijde');
INSERT INTO cp_ville VALUES (2494, 8670, 'Oostduinkerke');
INSERT INTO cp_ville VALUES (2495, 8670, 'Wulpen');
INSERT INTO cp_ville VALUES (2496, 8680, 'Bovekerke');
INSERT INTO cp_ville VALUES (2497, 8680, 'Koekelare');
INSERT INTO cp_ville VALUES (2498, 8680, 'Zande');
INSERT INTO cp_ville VALUES (2499, 8690, 'Alveringem');
INSERT INTO cp_ville VALUES (2500, 8690, 'Hoogstade');
INSERT INTO cp_ville VALUES (2501, 8690, 'Oeren');
INSERT INTO cp_ville VALUES (2502, 8690, 'Sint-Rijkers');
INSERT INTO cp_ville VALUES (2503, 8691, 'Beveren-aan-den-Ijzer');
INSERT INTO cp_ville VALUES (2504, 8691, 'Gijverinkhove');
INSERT INTO cp_ville VALUES (2505, 8691, 'Izenberge');
INSERT INTO cp_ville VALUES (2506, 8691, 'Leisele');
INSERT INTO cp_ville VALUES (2507, 8691, 'Stavele');
INSERT INTO cp_ville VALUES (2508, 8700, 'Aarsele');
INSERT INTO cp_ville VALUES (2509, 8700, 'Kanegem');
INSERT INTO cp_ville VALUES (2510, 8700, 'Schuiferskapelle');
INSERT INTO cp_ville VALUES (2511, 8700, 'Tielt');
INSERT INTO cp_ville VALUES (2512, 8710, 'Ooigem');
INSERT INTO cp_ville VALUES (2513, 8710, 'Sint-Baafs-Vijve');
INSERT INTO cp_ville VALUES (2514, 8710, 'Wielsbeke');
INSERT INTO cp_ville VALUES (2515, 8720, 'Dentergem');
INSERT INTO cp_ville VALUES (2516, 8720, 'Markegem');
INSERT INTO cp_ville VALUES (2517, 8720, 'Oeselgem');
INSERT INTO cp_ville VALUES (2518, 8720, 'Wakken');
INSERT INTO cp_ville VALUES (2519, 8730, 'Beernem');
INSERT INTO cp_ville VALUES (2520, 8730, 'Oedelem');
INSERT INTO cp_ville VALUES (2521, 8730, 'Sint-Joris (Beernem)');
INSERT INTO cp_ville VALUES (2522, 8740, 'Egem');
INSERT INTO cp_ville VALUES (2523, 8740, 'Pittem');
INSERT INTO cp_ville VALUES (2524, 8750, 'Wingene');
INSERT INTO cp_ville VALUES (2525, 8750, 'Zwevezele');
INSERT INTO cp_ville VALUES (2526, 8755, 'Ruiselede');
INSERT INTO cp_ville VALUES (2527, 8760, 'Meulebeke');
INSERT INTO cp_ville VALUES (2528, 8770, 'Ingelmunster');
INSERT INTO cp_ville VALUES (2529, 8780, 'Oostrozebeke');
INSERT INTO cp_ville VALUES (2530, 8790, 'Waregem');
INSERT INTO cp_ville VALUES (2531, 8791, 'Beveren (Leie)');
INSERT INTO cp_ville VALUES (2532, 8792, 'Desselgem');
INSERT INTO cp_ville VALUES (2533, 8793, 'Sint-Eloois-Vijve');
INSERT INTO cp_ville VALUES (2534, 8800, 'Beveren (Roeselare)');
INSERT INTO cp_ville VALUES (2535, 8800, 'Oekene');
INSERT INTO cp_ville VALUES (2536, 8800, 'Roeselare');
INSERT INTO cp_ville VALUES (2537, 8800, 'Rumbeke');
INSERT INTO cp_ville VALUES (2538, 8810, 'Lichtervelde');
INSERT INTO cp_ville VALUES (2539, 8820, 'Torhout');
INSERT INTO cp_ville VALUES (2540, 8830, 'Gits');
INSERT INTO cp_ville VALUES (2541, 8830, 'Hooglede');
INSERT INTO cp_ville VALUES (2542, 8840, 'Oostnieuwkerke');
INSERT INTO cp_ville VALUES (2543, 8840, 'Staden');
INSERT INTO cp_ville VALUES (2544, 8840, 'Westrozebeke');
INSERT INTO cp_ville VALUES (2545, 8850, 'Ardooie');
INSERT INTO cp_ville VALUES (2546, 8851, 'Koolskamp');
INSERT INTO cp_ville VALUES (2547, 8860, 'Lendelede');
INSERT INTO cp_ville VALUES (2548, 8870, 'Emelgem');
INSERT INTO cp_ville VALUES (2549, 8870, 'Izegem');
INSERT INTO cp_ville VALUES (2550, 8870, 'Kachtem');
INSERT INTO cp_ville VALUES (2551, 8880, 'Ledegem');
INSERT INTO cp_ville VALUES (2552, 8880, 'Rollegem-Kapelle');
INSERT INTO cp_ville VALUES (2553, 8880, 'Sint-Eloois-Winkel');
INSERT INTO cp_ville VALUES (2554, 8890, 'Dadizele');
INSERT INTO cp_ville VALUES (2555, 8890, 'Moorslede');
INSERT INTO cp_ville VALUES (2556, 8900, 'Brielen');
INSERT INTO cp_ville VALUES (2557, 8900, 'Dikkebus');
INSERT INTO cp_ville VALUES (2558, 8900, 'Ieper');
INSERT INTO cp_ville VALUES (2559, 8900, 'Sint-Jan');
INSERT INTO cp_ville VALUES (2560, 8902, 'Hollebeke');
INSERT INTO cp_ville VALUES (2561, 8902, 'Voormezele');
INSERT INTO cp_ville VALUES (2562, 8902, 'Zillebeke');
INSERT INTO cp_ville VALUES (2563, 8904, 'Boezinge');
INSERT INTO cp_ville VALUES (2564, 8904, 'Zuidschote');
INSERT INTO cp_ville VALUES (2565, 8906, 'Elverdinge');
INSERT INTO cp_ville VALUES (2566, 8908, 'Vlamertinge');
INSERT INTO cp_ville VALUES (2567, 8920, 'Bikschote');
INSERT INTO cp_ville VALUES (2568, 8920, 'Langemark');
INSERT INTO cp_ville VALUES (2569, 8920, 'Langemark-Poelkapelle');
INSERT INTO cp_ville VALUES (2570, 8920, 'Poelkapelle');
INSERT INTO cp_ville VALUES (2571, 8930, 'Lauwe');
INSERT INTO cp_ville VALUES (2572, 8930, 'Menen');
INSERT INTO cp_ville VALUES (2573, 8930, 'Rekkem');
INSERT INTO cp_ville VALUES (2574, 8940, 'Geluwe');
INSERT INTO cp_ville VALUES (2575, 8940, 'Wervik');
INSERT INTO cp_ville VALUES (2576, 8950, 'Heuvelland');
INSERT INTO cp_ville VALUES (2577, 8950, 'Nieuwkerke');
INSERT INTO cp_ville VALUES (2578, 8951, 'Dranouter');
INSERT INTO cp_ville VALUES (2579, 8952, 'Wulvergem');
INSERT INTO cp_ville VALUES (2580, 8953, 'Wijtschate');
INSERT INTO cp_ville VALUES (2581, 8954, 'Westouter');
INSERT INTO cp_ville VALUES (2582, 8956, 'Kemmel');
INSERT INTO cp_ville VALUES (2583, 8957, 'Mesen');
INSERT INTO cp_ville VALUES (2584, 8957, 'Messines');
INSERT INTO cp_ville VALUES (2585, 8958, 'Loker');
INSERT INTO cp_ville VALUES (2586, 8970, 'Poperinge');
INSERT INTO cp_ville VALUES (2587, 8970, 'Reningelst');
INSERT INTO cp_ville VALUES (2588, 8972, 'Krombeke');
INSERT INTO cp_ville VALUES (2589, 8972, 'Proven');
INSERT INTO cp_ville VALUES (2590, 8972, 'Roesbrugge-Haringe');
INSERT INTO cp_ville VALUES (2591, 8978, 'Watou');
INSERT INTO cp_ville VALUES (2592, 8980, 'Beselare');
INSERT INTO cp_ville VALUES (2593, 8980, 'Geluveld');
INSERT INTO cp_ville VALUES (2594, 8980, 'Passendale');
INSERT INTO cp_ville VALUES (2595, 8980, 'Zandvoorde (Zonnebeke)');
INSERT INTO cp_ville VALUES (2596, 8980, 'Zonnebeke');
INSERT INTO cp_ville VALUES (2597, 9000, 'Gent');
INSERT INTO cp_ville VALUES (2598, 9030, 'Mariakerke (Gent)');
INSERT INTO cp_ville VALUES (2599, 9031, 'Drongen');
INSERT INTO cp_ville VALUES (2600, 9032, 'Wondelgem');
INSERT INTO cp_ville VALUES (2601, 9040, 'Sint-Amandsberg (Gent)');
INSERT INTO cp_ville VALUES (2602, 9041, 'Oostakker');
INSERT INTO cp_ville VALUES (2603, 9042, 'Desteldonk');
INSERT INTO cp_ville VALUES (2604, 9042, 'Mendonk');
INSERT INTO cp_ville VALUES (2605, 9042, 'Sint-Kruis-Winkel');
INSERT INTO cp_ville VALUES (2606, 9050, 'Gentbrugge');
INSERT INTO cp_ville VALUES (2607, 9050, 'Ledeberg (Gent)');
INSERT INTO cp_ville VALUES (2608, 9051, 'Afsnee');
INSERT INTO cp_ville VALUES (2609, 9051, 'Sint-Denijs-Westrem');
INSERT INTO cp_ville VALUES (2610, 9052, 'Zwijnaarde');
INSERT INTO cp_ville VALUES (2611, 9060, 'Zelzate');
INSERT INTO cp_ville VALUES (2612, 9070, 'Destelbergen');
INSERT INTO cp_ville VALUES (2613, 9070, 'Heusden (O.-Vl.)');
INSERT INTO cp_ville VALUES (2614, 9080, 'Beervelde');
INSERT INTO cp_ville VALUES (2615, 9080, 'Lochristi');
INSERT INTO cp_ville VALUES (2616, 9080, 'Zaffelare');
INSERT INTO cp_ville VALUES (2617, 9080, 'Zeveneken');
INSERT INTO cp_ville VALUES (2618, 9090, 'Gontrode');
INSERT INTO cp_ville VALUES (2619, 9090, 'Melle');
INSERT INTO cp_ville VALUES (2620, 9100, 'Nieuwkerken-Waas');
INSERT INTO cp_ville VALUES (2621, 9100, 'Sint-Niklaas');
INSERT INTO cp_ville VALUES (2622, 9111, 'Belsele (Sint-Niklaas)');
INSERT INTO cp_ville VALUES (2623, 9112, 'Sinaai-Waas');
INSERT INTO cp_ville VALUES (2624, 9120, 'Beveren-Waas');
INSERT INTO cp_ville VALUES (2625, 9120, 'Haasdonk');
INSERT INTO cp_ville VALUES (2626, 9120, 'Kallo (Beveren-Waas)');
INSERT INTO cp_ville VALUES (2627, 9120, 'Melsele');
INSERT INTO cp_ville VALUES (2628, 9120, 'Vrasene');
INSERT INTO cp_ville VALUES (2629, 9130, 'Doel');
INSERT INTO cp_ville VALUES (2630, 9130, 'Kallo (Kieldrecht)');
INSERT INTO cp_ville VALUES (2631, 9130, 'Kieldrecht (Beveren)');
INSERT INTO cp_ville VALUES (2632, 9130, 'Verrebroek');
INSERT INTO cp_ville VALUES (2633, 9140, 'Elversele');
INSERT INTO cp_ville VALUES (2634, 9140, 'Steendorp');
INSERT INTO cp_ville VALUES (2635, 9140, 'Temse');
INSERT INTO cp_ville VALUES (2636, 9140, 'Tielrode');
INSERT INTO cp_ville VALUES (2637, 9150, 'Bazel');
INSERT INTO cp_ville VALUES (2638, 9150, 'Kruibeke');
INSERT INTO cp_ville VALUES (2639, 9150, 'Rupelmonde');
INSERT INTO cp_ville VALUES (2640, 9160, 'Daknam');
INSERT INTO cp_ville VALUES (2641, 9160, 'Eksaarde');
INSERT INTO cp_ville VALUES (2642, 9160, 'Lokeren');
INSERT INTO cp_ville VALUES (2643, 9170, 'De Klinge');
INSERT INTO cp_ville VALUES (2644, 9170, 'Meerdonk');
INSERT INTO cp_ville VALUES (2645, 9170, 'Sint-Gillis-Waas');
INSERT INTO cp_ville VALUES (2646, 9170, 'Sint-Pauwels');
INSERT INTO cp_ville VALUES (2647, 9180, 'Moerbeke-Waas');
INSERT INTO cp_ville VALUES (2648, 9185, 'Wachtebeke');
INSERT INTO cp_ville VALUES (2649, 9190, 'Kemzeke');
INSERT INTO cp_ville VALUES (2650, 9190, 'Stekene');
INSERT INTO cp_ville VALUES (2651, 9200, 'Appels');
INSERT INTO cp_ville VALUES (2652, 9200, 'Baasrode');
INSERT INTO cp_ville VALUES (2653, 9200, 'Dendermonde');
INSERT INTO cp_ville VALUES (2654, 9200, 'Grembergen');
INSERT INTO cp_ville VALUES (2655, 9200, 'Mespelare');
INSERT INTO cp_ville VALUES (2656, 9200, 'Oudegem');
INSERT INTO cp_ville VALUES (2657, 9200, 'Schoonaarde');
INSERT INTO cp_ville VALUES (2658, 9200, 'Sint-Gillis-bij-Dendermonde');
INSERT INTO cp_ville VALUES (2659, 9220, 'Hamme (O.-Vl.)');
INSERT INTO cp_ville VALUES (2660, 9220, 'Moerzeke');
INSERT INTO cp_ville VALUES (2661, 9230, 'Massemen');
INSERT INTO cp_ville VALUES (2662, 9230, 'Westrem');
INSERT INTO cp_ville VALUES (2663, 9230, 'Wetteren');
INSERT INTO cp_ville VALUES (2664, 9240, 'Zele');
INSERT INTO cp_ville VALUES (2665, 9250, 'Waasmunster');
INSERT INTO cp_ville VALUES (2666, 9255, 'Buggenhout');
INSERT INTO cp_ville VALUES (2667, 9255, 'Opdorp');
INSERT INTO cp_ville VALUES (2668, 9260, 'Schellebelle');
INSERT INTO cp_ville VALUES (2669, 9260, 'Serskamp');
INSERT INTO cp_ville VALUES (2670, 9260, 'Wichelen');
INSERT INTO cp_ville VALUES (2671, 9270, 'Kalken');
INSERT INTO cp_ville VALUES (2672, 9270, 'Laarne');
INSERT INTO cp_ville VALUES (2673, 9280, 'Denderbelle');
INSERT INTO cp_ville VALUES (2674, 9280, 'Lebbeke');
INSERT INTO cp_ville VALUES (2675, 9280, 'Wieze');
INSERT INTO cp_ville VALUES (2676, 9290, 'Berlare');
INSERT INTO cp_ville VALUES (2677, 9290, 'Overmere');
INSERT INTO cp_ville VALUES (2678, 9290, 'Uitbergen');
INSERT INTO cp_ville VALUES (2679, 9300, 'Aalst');
INSERT INTO cp_ville VALUES (2680, 9308, 'Gijzegem');
INSERT INTO cp_ville VALUES (2681, 9308, 'Hofstade (O.-Vl.)');
INSERT INTO cp_ville VALUES (2682, 9310, 'Baardegem');
INSERT INTO cp_ville VALUES (2683, 9310, 'Herdersem');
INSERT INTO cp_ville VALUES (2684, 9310, 'Meldert (O.-Vl.)');
INSERT INTO cp_ville VALUES (2685, 9310, 'Moorsel');
INSERT INTO cp_ville VALUES (2686, 9320, 'Erembodegem (Aalst)');
INSERT INTO cp_ville VALUES (2687, 9320, 'Nieuwerkerken (Aalst)');
INSERT INTO cp_ville VALUES (2688, 9340, 'Impe');
INSERT INTO cp_ville VALUES (2689, 9340, 'Lede');
INSERT INTO cp_ville VALUES (2690, 9340, 'Oordegem');
INSERT INTO cp_ville VALUES (2691, 9340, 'Smetlede');
INSERT INTO cp_ville VALUES (2692, 9340, 'Wanzele');
INSERT INTO cp_ville VALUES (2693, 9400, 'Appelterre-Eichem');
INSERT INTO cp_ville VALUES (2694, 9400, 'Denderwindeke');
INSERT INTO cp_ville VALUES (2695, 9400, 'Lieferinge');
INSERT INTO cp_ville VALUES (2696, 9400, 'Nederhasselt');
INSERT INTO cp_ville VALUES (2697, 9400, 'Ninove');
INSERT INTO cp_ville VALUES (2698, 9400, 'Okegem');
INSERT INTO cp_ville VALUES (2699, 9400, 'Voorde');
INSERT INTO cp_ville VALUES (2700, 9401, 'Pollare');
INSERT INTO cp_ville VALUES (2701, 9402, 'Meerbeke');
INSERT INTO cp_ville VALUES (2702, 9403, 'Neigem');
INSERT INTO cp_ville VALUES (2703, 9404, 'Aspelare');
INSERT INTO cp_ville VALUES (2704, 9406, 'Outer');
INSERT INTO cp_ville VALUES (2705, 9420, 'Aaigem');
INSERT INTO cp_ville VALUES (2706, 9420, 'Bambrugge');
INSERT INTO cp_ville VALUES (2707, 9420, 'Burst');
INSERT INTO cp_ville VALUES (2708, 9420, 'Erondegem');
INSERT INTO cp_ville VALUES (2709, 9420, 'Erpe');
INSERT INTO cp_ville VALUES (2710, 9420, 'Erpe-Mere');
INSERT INTO cp_ville VALUES (2711, 9420, 'Mere');
INSERT INTO cp_ville VALUES (2712, 9420, 'Ottergem');
INSERT INTO cp_ville VALUES (2713, 9420, 'Vlekkem');
INSERT INTO cp_ville VALUES (2714, 9450, 'Denderhoutem');
INSERT INTO cp_ville VALUES (2715, 9450, 'Haaltert');
INSERT INTO cp_ville VALUES (2716, 9450, 'Heldergem');
INSERT INTO cp_ville VALUES (2717, 9451, 'Kerksken');
INSERT INTO cp_ville VALUES (2718, 9470, 'Denderleeuw');
INSERT INTO cp_ville VALUES (2719, 9472, 'Iddergem');
INSERT INTO cp_ville VALUES (2720, 9473, 'Welle');
INSERT INTO cp_ville VALUES (2721, 9500, 'Geraardsbergen');
INSERT INTO cp_ville VALUES (2722, 9500, 'Goeferdinge');
INSERT INTO cp_ville VALUES (2723, 9500, 'Moerbeke');
INSERT INTO cp_ville VALUES (2724, 9500, 'Nederboelare');
INSERT INTO cp_ville VALUES (2725, 9500, 'Onkerzele');
INSERT INTO cp_ville VALUES (2726, 9500, 'Ophasselt');
INSERT INTO cp_ville VALUES (2727, 9500, 'Overboelare');
INSERT INTO cp_ville VALUES (2728, 9500, 'Viane');
INSERT INTO cp_ville VALUES (2729, 9500, 'Zarlardinge');
INSERT INTO cp_ville VALUES (2730, 9506, 'Grimminge');
INSERT INTO cp_ville VALUES (2731, 9506, 'Idegem');
INSERT INTO cp_ville VALUES (2732, 9506, 'Nieuwenhove');
INSERT INTO cp_ville VALUES (2733, 9506, 'Schendelbeke');
INSERT INTO cp_ville VALUES (2734, 9506, 'Smeerebbe-Vloerzegem');
INSERT INTO cp_ville VALUES (2735, 9506, 'Waarbeke');
INSERT INTO cp_ville VALUES (2736, 9506, 'Zandbergen');
INSERT INTO cp_ville VALUES (2737, 9520, 'Bavegem');
INSERT INTO cp_ville VALUES (2738, 9520, 'Sint-Lievens-Houtem');
INSERT INTO cp_ville VALUES (2739, 9520, 'Vlierzele');
INSERT INTO cp_ville VALUES (2740, 9520, 'Zonnegem');
INSERT INTO cp_ville VALUES (2741, 9521, 'Letterhoutem');
INSERT INTO cp_ville VALUES (2742, 9550, 'Herzele');
INSERT INTO cp_ville VALUES (2743, 9550, 'Hillegem');
INSERT INTO cp_ville VALUES (2744, 9550, 'Sint-Antelinks');
INSERT INTO cp_ville VALUES (2745, 9550, 'Sint-Lievens-Esse');
INSERT INTO cp_ville VALUES (2746, 9550, 'Steenhuize-Wijnhuize');
INSERT INTO cp_ville VALUES (2747, 9550, 'Woubrechtegem');
INSERT INTO cp_ville VALUES (2748, 9551, 'Ressegem');
INSERT INTO cp_ville VALUES (2749, 9552, 'Borsbeke');
INSERT INTO cp_ville VALUES (2750, 9570, 'Deftinge');
INSERT INTO cp_ville VALUES (2751, 9570, 'Lierde');
INSERT INTO cp_ville VALUES (2752, 9570, 'Sint-Maria-Lierde');
INSERT INTO cp_ville VALUES (2753, 9571, 'Hemelveerdegem');
INSERT INTO cp_ville VALUES (2754, 9572, 'Sint-Martens-Lierde');
INSERT INTO cp_ville VALUES (2755, 9600, 'Renaix');
INSERT INTO cp_ville VALUES (2756, 9600, 'Ronse');
INSERT INTO cp_ville VALUES (2757, 9620, 'Elene');
INSERT INTO cp_ville VALUES (2758, 9620, 'Erwetegem');
INSERT INTO cp_ville VALUES (2759, 9620, 'Godveerdegem');
INSERT INTO cp_ville VALUES (2760, 9620, 'Grotenberge');
INSERT INTO cp_ville VALUES (2761, 9620, 'Leeuwergem');
INSERT INTO cp_ville VALUES (2762, 9620, 'Oombergen (Zottegem)');
INSERT INTO cp_ville VALUES (2763, 9620, 'Sint-Goriks-Oudenhove');
INSERT INTO cp_ville VALUES (2764, 9620, 'Sint-Maria-Oudenhove (Zottegem)');
INSERT INTO cp_ville VALUES (2765, 9620, 'Strijpen');
INSERT INTO cp_ville VALUES (2766, 9620, 'Velzeke-Ruddershove');
INSERT INTO cp_ville VALUES (2767, 9620, 'Zottegem');
INSERT INTO cp_ville VALUES (2768, 9630, 'Beerlegem');
INSERT INTO cp_ville VALUES (2769, 9630, 'Dikkele');
INSERT INTO cp_ville VALUES (2770, 9630, 'Hundelgem');
INSERT INTO cp_ville VALUES (2771, 9630, 'Meilegem');
INSERT INTO cp_ville VALUES (2772, 9630, 'Munkzwalm');
INSERT INTO cp_ville VALUES (2773, 9630, 'Paulatem');
INSERT INTO cp_ville VALUES (2774, 9630, 'Roborst');
INSERT INTO cp_ville VALUES (2775, 9630, 'Rozebeke');
INSERT INTO cp_ville VALUES (2776, 9630, 'Sint-Blasius-Boekel');
INSERT INTO cp_ville VALUES (2777, 9630, 'Sint-Denijs-Boekel');
INSERT INTO cp_ville VALUES (2778, 9630, 'Sint-Maria-Latem');
INSERT INTO cp_ville VALUES (2779, 9630, 'Zwalm');
INSERT INTO cp_ville VALUES (2780, 9636, 'Nederzwalm-Hermelgem');
INSERT INTO cp_ville VALUES (2781, 9660, 'Brakel');
INSERT INTO cp_ville VALUES (2782, 9660, 'Elst');
INSERT INTO cp_ville VALUES (2783, 9660, 'Everbeek');
INSERT INTO cp_ville VALUES (2784, 9660, 'Michelbeke');
INSERT INTO cp_ville VALUES (2785, 9660, 'Nederbrakel');
INSERT INTO cp_ville VALUES (2786, 9660, 'Opbrakel');
INSERT INTO cp_ville VALUES (2787, 9660, 'Zegelsem');
INSERT INTO cp_ville VALUES (2788, 9661, 'Parike');
INSERT INTO cp_ville VALUES (2789, 9667, 'Horebeke');
INSERT INTO cp_ville VALUES (2790, 9667, 'Sint-Kornelis-Horebeke');
INSERT INTO cp_ville VALUES (2791, 9667, 'Sint-Maria-Horebeke');
INSERT INTO cp_ville VALUES (2792, 9680, 'Etikhove');
INSERT INTO cp_ville VALUES (2793, 9680, 'Maarkedal');
INSERT INTO cp_ville VALUES (2794, 9680, 'Maarke-Kerkem');
INSERT INTO cp_ville VALUES (2795, 9681, 'Nukerke');
INSERT INTO cp_ville VALUES (2796, 9688, 'Schorisse');
INSERT INTO cp_ville VALUES (2797, 9690, 'Berchem (O.-Vl.)');
INSERT INTO cp_ville VALUES (2798, 9690, 'Kluisbergen');
INSERT INTO cp_ville VALUES (2799, 9690, 'Kwaremont');
INSERT INTO cp_ville VALUES (2800, 9690, 'Ruien');
INSERT INTO cp_ville VALUES (2801, 9690, 'Zulzeke');
INSERT INTO cp_ville VALUES (2802, 9700, 'Bevere');
INSERT INTO cp_ville VALUES (2803, 9700, 'Edelare');
INSERT INTO cp_ville VALUES (2804, 9700, 'Eine');
INSERT INTO cp_ville VALUES (2805, 9700, 'Ename');
INSERT INTO cp_ville VALUES (2806, 9700, 'Heurne');
INSERT INTO cp_ville VALUES (2807, 9700, 'Leupegem');
INSERT INTO cp_ville VALUES (2808, 9700, 'Mater');
INSERT INTO cp_ville VALUES (2809, 9700, 'Melden');
INSERT INTO cp_ville VALUES (2810, 9700, 'Mullem');
INSERT INTO cp_ville VALUES (2811, 9700, 'Nederename');
INSERT INTO cp_ville VALUES (2812, 9700, 'Oudenaarde');
INSERT INTO cp_ville VALUES (2813, 9700, 'Volkegem');
INSERT INTO cp_ville VALUES (2814, 9700, 'Welden');
INSERT INTO cp_ville VALUES (2815, 9750, 'Huise');
INSERT INTO cp_ville VALUES (2816, 9750, 'Ouwegem');
INSERT INTO cp_ville VALUES (2817, 9750, 'Zingem');
INSERT INTO cp_ville VALUES (2818, 9770, 'Kruishoutem');
INSERT INTO cp_ville VALUES (2819, 9771, 'Nokere');
INSERT INTO cp_ville VALUES (2820, 9772, 'Wannegem-Lede');
INSERT INTO cp_ville VALUES (2821, 9790, 'Elsegem');
INSERT INTO cp_ville VALUES (2822, 9790, 'Moregem');
INSERT INTO cp_ville VALUES (2823, 9790, 'Ooike (Wortegem-Petegem)');
INSERT INTO cp_ville VALUES (2824, 9790, 'Petegem-aan-de-Schelde');
INSERT INTO cp_ville VALUES (2825, 9790, 'Wortegem');
INSERT INTO cp_ville VALUES (2826, 9790, 'Wortegem-Petegem');
INSERT INTO cp_ville VALUES (2827, 9800, 'Astene');
INSERT INTO cp_ville VALUES (2828, 9800, 'Bachte-Maria-Leerne');
INSERT INTO cp_ville VALUES (2829, 9800, 'Deinze');
INSERT INTO cp_ville VALUES (2830, 9800, 'Gottem');
INSERT INTO cp_ville VALUES (2831, 9800, 'Grammene');
INSERT INTO cp_ville VALUES (2832, 9800, 'Meigem');
INSERT INTO cp_ville VALUES (2833, 9800, 'Petegem-aan-de-Leie');
INSERT INTO cp_ville VALUES (2834, 9800, 'Sint-Martens-Leerne');
INSERT INTO cp_ville VALUES (2835, 9800, 'Vinkt');
INSERT INTO cp_ville VALUES (2836, 9800, 'Wontergem');
INSERT INTO cp_ville VALUES (2837, 9800, 'Zeveren');
INSERT INTO cp_ville VALUES (2838, 9810, 'Eke');
INSERT INTO cp_ville VALUES (2839, 9810, 'Nazareth');
INSERT INTO cp_ville VALUES (2840, 9820, 'Bottelare');
INSERT INTO cp_ville VALUES (2841, 9820, 'Lemberge');
INSERT INTO cp_ville VALUES (2842, 9820, 'Melsen');
INSERT INTO cp_ville VALUES (2843, 9820, 'Merelbeke');
INSERT INTO cp_ville VALUES (2844, 9820, 'Munte');
INSERT INTO cp_ville VALUES (2845, 9820, 'Schelderode');
INSERT INTO cp_ville VALUES (2846, 9830, 'Sint-Martens-Latem');
INSERT INTO cp_ville VALUES (2847, 9831, 'Deurle');
INSERT INTO cp_ville VALUES (2848, 9840, 'De Pinte');
INSERT INTO cp_ville VALUES (2849, 9840, 'Zevergem');
INSERT INTO cp_ville VALUES (2850, 9850, 'Hansbeke');
INSERT INTO cp_ville VALUES (2851, 9850, 'Landegem');
INSERT INTO cp_ville VALUES (2852, 9850, 'Merendree');
INSERT INTO cp_ville VALUES (2853, 9850, 'Nevele');
INSERT INTO cp_ville VALUES (2854, 9850, 'Poesele');
INSERT INTO cp_ville VALUES (2855, 9850, 'Vosselare');
INSERT INTO cp_ville VALUES (2856, 9860, 'Balegem');
INSERT INTO cp_ville VALUES (2857, 9860, 'Gijzenzele');
INSERT INTO cp_ville VALUES (2858, 9860, 'Landskouter');
INSERT INTO cp_ville VALUES (2859, 9860, 'Moortsele');
INSERT INTO cp_ville VALUES (2860, 9860, 'Oosterzele');
INSERT INTO cp_ville VALUES (2861, 9860, 'Scheldewindeke');
INSERT INTO cp_ville VALUES (2862, 9870, 'Machelen (O.-Vl.)');
INSERT INTO cp_ville VALUES (2863, 9870, 'Olsene');
INSERT INTO cp_ville VALUES (2864, 9870, 'Zulte');
INSERT INTO cp_ville VALUES (2865, 9880, 'Aalter');
INSERT INTO cp_ville VALUES (2866, 9880, 'Lotenhulle');
INSERT INTO cp_ville VALUES (2867, 9880, 'Poeke');
INSERT INTO cp_ville VALUES (2868, 9881, 'Bellem');
INSERT INTO cp_ville VALUES (2869, 9890, 'Asper');
INSERT INTO cp_ville VALUES (2870, 9890, 'Baaigem');
INSERT INTO cp_ville VALUES (2871, 9890, 'Dikkelvenne');
INSERT INTO cp_ville VALUES (2872, 9890, 'Gavere');
INSERT INTO cp_ville VALUES (2873, 9890, 'Semmerzake');
INSERT INTO cp_ville VALUES (2874, 9890, 'Vurste');
INSERT INTO cp_ville VALUES (2875, 9900, 'Eeklo');
INSERT INTO cp_ville VALUES (2876, 9910, 'Knesselare');
INSERT INTO cp_ville VALUES (2877, 9910, 'Ursel');
INSERT INTO cp_ville VALUES (2878, 9920, 'Lovendegem');
INSERT INTO cp_ville VALUES (2879, 9921, 'Vinderhoute');
INSERT INTO cp_ville VALUES (2880, 9930, 'Zomergem');
INSERT INTO cp_ville VALUES (2881, 9931, 'Oostwinkel');
INSERT INTO cp_ville VALUES (2882, 9932, 'Ronsele');
INSERT INTO cp_ville VALUES (2883, 9940, 'Ertvelde');
INSERT INTO cp_ville VALUES (2884, 9940, 'Evergem');
INSERT INTO cp_ville VALUES (2885, 9940, 'Kluizen');
INSERT INTO cp_ville VALUES (2886, 9940, 'Sleidinge');
INSERT INTO cp_ville VALUES (2887, 9950, 'Waarschoot');
INSERT INTO cp_ville VALUES (2888, 9960, 'Assenede');
INSERT INTO cp_ville VALUES (2889, 9961, 'Boekhoute');
INSERT INTO cp_ville VALUES (2890, 9968, 'Bassevelde');
INSERT INTO cp_ville VALUES (2891, 9968, 'Oosteeklo');
INSERT INTO cp_ville VALUES (2892, 9970, 'Kaprijke');
INSERT INTO cp_ville VALUES (2893, 9971, 'Lembeke');
INSERT INTO cp_ville VALUES (2894, 9980, 'Sint-Laureins');
INSERT INTO cp_ville VALUES (2895, 9981, 'Sint-Margriete');
INSERT INTO cp_ville VALUES (2896, 9982, 'Sint-Jan-in-Eremo');
INSERT INTO cp_ville VALUES (2897, 9988, 'Waterland-Oudeman');
INSERT INTO cp_ville VALUES (2898, 9988, 'Watervliet');
INSERT INTO cp_ville VALUES (2899, 9990, 'Maldegem');
INSERT INTO cp_ville VALUES (2900, 9991, 'Adegem');
INSERT INTO cp_ville VALUES (2901, 9992, 'Middelburg');

Codes Sources

A voir également

Ajouter un commentaire

Commentaires

Choumoumou
Messages postés
162
Date d'inscription
jeudi 30 septembre 2004
Statut
Membre
Dernière intervention
17 novembre 2010
-
Oulaaa !! T'aurai pu faire un systeme de recherche sur Internet, si t'enregitre déjà toutes les ville, ton prog est vachement lourd !!!
cs_Oziris
Messages postés
70
Date d'inscription
samedi 15 février 2003
Statut
Membre
Dernière intervention
30 décembre 2015
-
lu,
je trouve que c'est un travail de titan qu'il vien d'accomplir là ! mais felicitation pour ton travail
celui qui cherche une base de donnees sur les ville et les code postal de belgique a sont travail de deja fait ;)
markachat
Messages postés
17
Date d'inscription
jeudi 12 juin 2003
Statut
Membre
Dernière intervention
13 avril 2005
-
Salut,

Choumoumou, je ne charge pas l'entièreté de la table dans mon script php, en fait je crée un select html reprenant tous les cp de la table, dès que l'utilisateur en sélectionne un je recharge la page qui fait alors le select sur les villes et fait apparaître un deuxième select html à côté de celui des cp.

Oziris,
Je vais avoué que je n'ai pas grand mérite, ce code a été réalisé en moins de 5 minutes grâce à un logiciel et à mon éditeur de texte. Cette liste est distribuée par la poste belge sous forme d'un fichier excell, donc première étape, trois clic dans un logiciel qui transforme l'excell en xml, et seconde étape dans l'éditeur, lancer la procédure qui remplace une chaîne de caractères (ici balise xml) en une autre chaîne de caractères (instruction sql). Et voilà, le fichier est là....

Merci quand même du compliment.
@plus

Mike
Maitrepylos
Messages postés
2
Date d'inscription
mercredi 11 décembre 2002
Statut
Membre
Dernière intervention
6 avril 2005
-
Bonjour Markachat, j'ai fais le même boulot que toi, mais en ajoutant les communes et les localités.
si ça t'intèresse?

Je me demandais, vu que je débute, si tu ne pouvais pas me refiler les codes qui créent les select.

D'avance merci.

MaitrePylos
Maitrepylos
Messages postés
2
Date d'inscription
mercredi 11 décembre 2002
Statut
Membre
Dernière intervention
6 avril 2005
-
Bonjour Markachat, j'ai fais le même boulot que toi, mais en ajoutant les communes et les localités.
si ça t'intèresse?

Je me demandais, vu que je débute, si tu ne pouvais pas me refiler les codes qui créent les select.

D'avance merci.

MaitrePylos

Vous n'êtes pas encore membre ?

inscrivez-vous, c'est gratuit et ça prend moins d'une minute !

Les membres obtiennent plus de réponses que les utilisateurs anonymes.

Le fait d'être membre vous permet d'avoir un suivi détaillé de vos demandes et codes sources.

Le fait d'être membre vous permet d'avoir des options supplémentaires.