Tous les codes postaux et villes de belgique

Soyez le premier à donner votre avis sur cette source.

Vue 43 821 fois - Téléchargée 834 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

Messages postés
17
Date d'inscription
jeudi 12 juin 2003
Statut
Membre
Dernière intervention
13 avril 2005

Pour MaîtrePylos et qui veux....

Je viens de vite refaire ça, sorry si y a un bug....

Markachat



<?php
$param=$_GET["param"];

if ($con=mysql_connect($host,$user,$pwd))
{
//selection de la db
if (mysql_select_db($database,$con))
{
$result=mysql_query("SELECT * FROM sys_membres WHERE mem_login='$login';");
$numRows=mysql_num_rows($result);
}
else
{
die ("Echec sélection DB.");
}
}
else
{
die ("Problème de connexion au serveur DB.");
}
?>

<html>
<head>
<script>
function recharge (ao_cp)
{
var ls_url="cs.php?param=";
if (ao_cp.value != "rien")
{
ls_url=ls_url+String(ao_cp.value);
document.location=ls_url;
}
}

function suite (ao_form)
{
if (ao_form[0].value != "rien" && ao_form[1].value != "rien")
{
ao_form.submit();
}
}
</script>
</head>


<form action="paga.php" method="post">
<select name="cp" onchange="recharge(this);">
<option value="rien">Code postal</option>

<?php
if (isset($param))
{
for ($i=0;$i<$numRows;$i++)
{
if ($param == mysql_result($resul,$i,"vil_cp"))
{
echo "<option value='".mysql_result($result,$i,"vil_cp")."' selected>'".mysql_result($result,$i,"vil_cp")."'</option>";
}
else
{
echo "<option value='".mysql_result($result,$i,"vil_cp")."'>'".mysql_result($result,$i,"vil_cp")."'</option>";
}
}
echo "</select>";
echo "<select name='ville' onchange='suite(document.forms[0]);'>";
echo "<option value='rien'>Localité</option>";
$result=mysql_query("SELECT * FROM sys_membres WHERE mem_login='$login';");
$numRows=mysql_num_rows($result);
for ($i=0;$i<$numRows;$i++)
{
echo "<option value='".mysql_result($result,$i,"vil_cp")."'>'".mysql_result($result,$i,"vil_cp")."'</option>";
}

}
else
{
for ($i=0;$i<$numRows;$i++)
{
echo "<option value='".mysql_result($result,$i,"vil_nom")."'>'".mysql_result($result,$i,"vil_nom")."'</option>";
}
}
?>
</select>
</form>

</html>
Messages postés
4
Date d'inscription
jeudi 11 novembre 2004
Statut
Membre
Dernière intervention
27 mai 2005

merciiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii Markachat
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
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
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
Afficher les 7 commentaires

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.