-- phpMyAdmin SQL Dump
-- version 4.4.13.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 31, 2018 at 04:04 PM
-- Server version: 5.7.14
-- PHP Version: 5.6.12

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `geonames`
--

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`country_id`, `country_name`, `country_abbr`, `slug`) VALUES
(110, 'Netherlands', 'NL', 'netherlands');
SET FOREIGN_KEY_CHECKS=1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`state_id`, `state_name`, `state_abbr`, `slug`, `country_abbr`, `country_id`) VALUES
(326, 'Drenthe', 'DR', 'drenthe', 'NL', 110),
(327, 'Flevoland', 'FL', 'flevoland', 'NL', 110),
(328, 'Gelderland', 'GE', 'gelderland', 'NL', 110),
(329, 'Groningen', 'GR', 'groningen', 'NL', 110),
(330, 'Limburg', 'LI', 'limburg', 'NL', 110),
(331, 'Noord-Brabant', 'NB', 'noord-brabant', 'NL', 110),
(332, 'Noord-Holland', 'NH', 'noord-holland', 'NL', 110),
(333, 'Overijssel', 'OV', 'overijssel', 'NL', 110),
(334, 'Utrecht', 'UT', 'utrecht', 'NL', 110),
(335, 'Zeeland', 'ZE', 'zeeland', 'NL', 110),
(336, 'Zuid-Holland', 'ZH', 'zuid-holland', 'NL', 110);


--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`city_name`, `state`, `state_id`, `slug`, `lat`, `lng`) VALUES
('''s Gravenmoer', 'NB', 331, 's-gravenmoer-331', '51.65820000', '4.94380000'),
('''s-Graveland', 'NH', 332, 's-graveland-332', '52.24020000', '5.12320000'),
('''s-Gravendeel', 'ZH', 336, 's-gravendeel-336', '51.77710000', '4.61350000'),
('''s-Gravenhage', 'ZH', 336, 's-gravenhage-336', '52.06890000', '4.38860000'),
('''s-Gravenpolder', 'ZE', 335, 's-gravenpolder-335', '51.45940000', '3.90360000'),
('''s-Gravenzande', 'ZH', 336, 's-gravenzande-336', '51.99800000', '4.16660000'),
('''s-Heer Abtskerke', 'ZE', 335, 's-heer-abtskerke-335', '51.47140000', '3.87470000'),
('''s-Heer Arendskerke', 'ZE', 335, 's-heer-arendskerke-335', '51.49430000', '3.81820000'),
('''s-Heer Hendrikskinderen', 'ZE', 335, 's-heer-hendrikskinderen-335', '51.50470000', '3.84580000'),
('''s-Heerenberg', 'GE', 328, 's-heerenberg-328', '51.87740000', '6.25290000'),
('''s-Heerenbroek', 'OV', 333, 's-heerenbroek-333', '52.53620000', '6.01280000'),
('''s-Heerenhoek', 'ZE', 335, 's-heerenhoek-335', '51.45400000', '3.77080000'),
('''s-Hertogenbosch', 'NB', 331, 's-hertogenbosch-331', '51.68940000', '5.30350000'),
('''t Goy', 'UT', 334, 't-goy-334', '52.00290000', '5.21810000'),
('''t Haantje', 'DR', 326, 't-haantje-326', '52.81430000', '6.82550000'),
('''t Harde', 'GE', 328, 't-harde-328', '52.41410000', '5.87910000'),
('''t Loo Oldebroek', 'GE', 328, 't-loo-oldebroek-328', '52.44270000', '5.95130000'),
('''t Veld', 'NH', 332, 't-veld-332', '52.74040000', '4.85600000'),
('''t Waar', 'GR', 329, 't-waar-329', '53.22370000', '6.94820000'),
('''t Zand', 'NH', 332, 't-zand-332', '52.83610000', '4.75660000'),
('''t Zandt', 'GR', 329, 't-zandt-329', '53.36800000', '6.77490000'),
('1e Exloërmond', 'DR', 326, '1e-exloermond-326', '52.93400000', '6.94880000'),
('2e Exloërmond', 'DR', 326, '2e-exloermond-326', '52.90730000', '6.93510000'),
('2e Valthermond', 'DR', 326, '2e-valthermond-326', '52.88870000', '7.01680000'),
('Aadorp', 'OV', 333, 'aadorp-333', '52.37750000', '6.62860000'),
('Aagtekerke', 'ZE', 335, 'aagtekerke-335', '51.54570000', '3.50750000'),
('Aalden', 'DR', 326, 'aalden-326', '52.79350000', '6.71390000'),
('Aalsmeer', 'NH', 332, 'aalsmeer-332', '52.26280000', '4.75690000'),
('Aalsmeerderbrug', 'NH', 332, 'aalsmeerderbrug-332', '52.27410000', '4.75310000'),
('Aalst', 'GE', 328, 'aalst-328', '51.78230000', '5.12970000'),
('Aalsum', '', NULL, 'aalsum-', '53.34120000', '6.00520000'),
('Aalten', 'GE', 328, 'aalten-328', '51.92570000', '6.59090000'),
('Aardenburg', 'ZE', 335, 'aardenburg-335', '51.27480000', '3.44380000'),
('Aarlanderveen', 'ZH', 336, 'aarlanderveen-336', '52.14110000', '4.72720000'),
('Aarle-Rixtel', 'NB', 331, 'aarle-rixtel-331', '51.50980000', '5.63950000'),
('Aartswoud', 'NH', 332, 'aartswoud-332', '52.74700000', '4.95490000'),
('Abbega', '', NULL, 'abbega-', '53.02000000', '5.57170000'),
('Abbekerk', 'NH', 332, 'abbekerk-332', '52.73070000', '5.01730000'),
('Abbenbroek', 'ZH', 336, 'abbenbroek-336', '51.84680000', '4.24070000'),
('Abbenes', 'NH', 332, 'abbenes-332', '52.23260000', '4.59260000'),
('Abcoude', 'UT', 334, 'abcoude-334', '52.27290000', '4.97190000'),
('Achlum', '', NULL, 'achlum-', '53.14910000', '5.48660000'),
('Achterveld', 'GE', 328, 'achterveld-328', '52.13900000', '5.51570000'),
('Achterveld', 'UT', 334, 'achterveld-334', '52.13730000', '5.49400000'),
('Achthuizen', 'ZH', 336, 'achthuizen-336', '51.68550000', '4.27990000'),
('Achtmaal', 'NB', 331, 'achtmaal-331', '51.45290000', '4.58210000'),
('Acquoy', 'GE', 328, 'acquoy-328', '51.88520000', '5.13370000'),
('Adorp', 'GR', 329, 'adorp-329', '53.27530000', '6.53410000'),
('Aduard', 'GR', 329, 'aduard-329', '53.25590000', '6.46060000'),
('Aerdenhout', 'NH', 332, 'aerdenhout-332', '52.36410000', '4.59520000'),
('Aerdt', 'GE', 328, 'aerdt-328', '51.89230000', '6.08200000'),
('Afferden', 'GE', 328, 'afferden-328', '51.88020000', '5.63300000'),
('Afferden L', 'LI', 330, 'afferden-l-330', '51.63540000', '6.01600000'),
('Agelo', 'OV', 333, 'agelo-333', '52.39080000', '6.89000000'),
('Akersloot', 'NH', 332, 'akersloot-332', '52.56160000', '4.73290000'),
('Akkrum', '', NULL, 'akkrum-', '53.05040000', '5.83770000'),
('Akmarijp', '', NULL, 'akmarijp-', '53.00200000', '5.78920000'),
('Albergen', 'OV', 333, 'albergen-333', '52.36860000', '6.75880000'),
('Alblasserdam', 'ZH', 336, 'alblasserdam-336', '51.86560000', '4.66300000'),
('Alde Leie', '', NULL, 'alde-leie-', '53.28830000', '5.72820000'),
('Aldeboarn', '', NULL, 'aldeboarn-', '53.04920000', '5.89440000'),
('Aldtsjerk', '', NULL, 'aldtsjerk-', '53.26460000', '5.88930000'),
('Alem', 'GE', 328, 'alem-328', '51.78670000', '5.34450000'),
('Alkmaar', 'NH', 332, 'alkmaar-332', '52.63090000', '4.74870000'),
('Allingawier', '', NULL, 'allingawier-', '53.04350000', '5.44760000'),
('Almelo', 'OV', 333, 'almelo-333', '52.34560000', '6.67080000'),
('Almen', 'GE', 328, 'almen-328', '52.16170000', '6.29860000'),
('Almere', 'FL', 327, 'almere-327', '52.39870000', '5.20210000'),
('Almkerk', 'NB', 331, 'almkerk-331', '51.77260000', '4.95830000'),
('Alphen', 'GE', 328, 'alphen-328', '51.82460000', '5.47150000'),
('Alphen', 'NB', 331, 'alphen-331', '51.48320000', '4.95830000'),
('Alphen aan den Rijn', 'ZH', 336, 'alphen-aan-den-rijn-336', '52.15110000', '4.65350000'),
('Alteveer', 'DR', 326, 'alteveer-326', '52.67750000', '6.48480000'),
('Alteveer', 'GR', 329, 'alteveer-329', '53.04860000', '7.00180000'),
('Alteveer gem Hoogeveen', 'DR', 326, 'alteveer-gem-hoogeveen-326', '52.67980000', '6.49990000'),
('Altforst', 'GE', 328, 'altforst-328', '51.85040000', '5.56230000'),
('Ambt Delden', 'OV', 333, 'ambt-delden-333', '52.26070000', '6.66790000'),
('Ameide', 'ZH', 336, 'ameide-336', '51.95410000', '4.96390000'),
('Amen', 'DR', 326, 'amen-326', '52.94140000', '6.60830000'),
('America', 'LI', 330, 'america-330', '51.44570000', '5.96530000'),
('Amerongen', 'UT', 334, 'amerongen-334', '52.00210000', '5.45930000'),
('Amersfoort', 'UT', 334, 'amersfoort-334', '52.15570000', '5.38830000'),
('Ammerstol', 'ZH', 336, 'ammerstol-336', '51.92780000', '4.80880000'),
('Ammerzoden', 'GE', 328, 'ammerzoden-328', '51.74970000', '5.21990000'),
('Amstelhoek', 'UT', 334, 'amstelhoek-334', '52.23130000', '4.83360000'),
('Amstelveen', 'NH', 332, 'amstelveen-332', '52.30990000', '4.86290000'),
('Amstenrade', 'LI', 330, 'amstenrade-330', '50.93930000', '5.92200000'),
('Amsterdam', 'NH', 332, 'amsterdam-332', '52.37100000', '4.90410000'),
('Amsterdam-Duivendrecht', 'NH', 332, 'amsterdam-duivendrecht-332', '52.32790000', '4.92720000'),
('Andel', 'NB', 331, 'andel-331', '51.78230000', '5.05730000'),
('Andelst', 'GE', 328, 'andelst-328', '51.90910000', '5.72670000'),
('Anderen', 'DR', 326, 'anderen-326', '52.99990000', '6.68590000'),
('Andijk', 'NH', 332, 'andijk-332', '52.74420000', '5.21040000'),
('Ane', 'OV', 333, 'ane-333', '52.61350000', '6.64120000'),
('Anerveen', 'OV', 333, 'anerveen-333', '52.63060000', '6.65270000'),
('Anevelde', 'OV', 333, 'anevelde-333', '52.59780000', '6.64760000'),
('Angeren', 'GE', 328, 'angeren-328', '51.91470000', '5.95500000'),
('Angerlo', 'GE', 328, 'angerlo-328', '51.99460000', '6.13360000'),
('Anjum', '', NULL, 'anjum-', '53.37700000', '6.14330000'),
('Ankeveen', 'NH', 332, 'ankeveen-332', '52.26050000', '5.10630000'),
('Anloo', 'DR', 326, 'anloo-326', '53.04730000', '6.70400000'),
('Anna Paulowna', 'NH', 332, 'anna-paulowna-332', '52.86220000', '4.82430000'),
('Annen', 'DR', 326, 'annen-326', '53.05750000', '6.71960000'),
('Annerveenschekanaal', 'DR', 326, 'annerveenschekanaal-326', '53.07880000', '6.80010000'),
('Ansen', 'DR', 326, 'ansen-326', '52.78290000', '6.33320000'),
('Apeldoorn', 'GE', 328, 'apeldoorn-328', '52.21300000', '5.96090000'),
('Appelscha', '', NULL, 'appelscha-', '52.95160000', '6.35160000'),
('Appeltern', 'GE', 328, 'appeltern-328', '51.83380000', '5.58190000'),
('Appingedam', 'GR', 329, 'appingedam-329', '53.32270000', '6.85610000'),
('Arcen', 'LI', 330, 'arcen-330', '51.48320000', '6.19030000'),
('Arkel', 'ZH', 336, 'arkel-336', '51.86370000', '4.99340000'),
('Arnemuiden', 'ZE', 335, 'arnemuiden-335', '51.50430000', '3.67640000'),
('Arnhem', 'GE', 328, 'arnhem-328', '51.98140000', '5.90630000'),
('Arriën', 'OV', 333, 'arrien-333', '52.53970000', '6.46160000'),
('Arum', '', NULL, 'arum-', '53.12920000', '5.47770000'),
('Asch', 'GE', 328, 'asch-328', '51.93050000', '5.31500000'),
('Asperen', 'GE', 328, 'asperen-328', '51.88140000', '5.10850000'),
('Assen', 'DR', 326, 'assen-326', '52.99360000', '6.56210000'),
('Assendelft', 'NH', 332, 'assendelft-332', '52.47300000', '4.74800000'),
('Asten', 'NB', 331, 'asten-331', '51.40450000', '5.75120000'),
('Augsbuurt', '', NULL, 'augsbuurt-', '53.26910000', '6.18000000'),
('Augustinusga', '', NULL, 'augustinusga-', '53.21670000', '6.16110000'),
('Austerlitz', 'UT', 334, 'austerlitz-334', '52.07980000', '5.31350000'),
('Avenhorn', 'NH', 332, 'avenhorn-332', '52.62020000', '4.95350000'),
('Axel', 'ZE', 335, 'axel-335', '51.26830000', '3.90960000'),
('Azewijn', 'GE', 328, 'azewijn-328', '51.88700000', '6.30420000'),
('Baaiduinen', '', NULL, 'baaiduinen-', '53.37790000', '5.27560000'),
('Baaium', '', NULL, 'baaium-', '53.16460000', '5.63330000'),
('Baak', 'GE', 328, 'baak-328', '52.07290000', '6.23140000'),
('Baambrugge', 'UT', 334, 'baambrugge-334', '52.24680000', '4.99040000'),
('Baard', '', NULL, 'baard-', '53.14230000', '5.66920000'),
('Baarland', 'ZE', 335, 'baarland-335', '51.40590000', '3.88750000'),
('Baarle-Nassau', 'NB', 331, 'baarle-nassau-331', '51.43970000', '4.93240000'),
('Baarlo', 'LI', 330, 'baarlo-330', '51.33190000', '6.08170000'),
('Baarlo', 'OV', 333, 'baarlo-333', '52.73630000', '5.94670000'),
('Baarn', 'UT', 334, 'baarn-334', '52.21750000', '5.28560000'),
('Baars', 'OV', 333, 'baars-333', '52.81440000', '6.09700000'),
('Babberich', 'GE', 328, 'babberich-328', '51.90680000', '6.11810000'),
('Babyloniënbroek', 'NB', 331, 'babylonienbroek-331', '51.74460000', '5.02060000'),
('Bad Nieuweschans', 'GR', 329, 'bad-nieuweschans-329', '53.18170000', '7.20810000'),
('Badhoevedorp', 'NH', 332, 'badhoevedorp-332', '52.33870000', '4.78300000'),
('Baexem', 'LI', 330, 'baexem-330', '51.22670000', '5.88100000'),
('Baflo', 'GR', 329, 'baflo-329', '53.36140000', '6.51490000'),
('Bakel', 'NB', 331, 'bakel-331', '51.50280000', '5.73590000'),
('Bakhuizen', '', NULL, 'bakhuizen-', '52.86870000', '5.45800000'),
('Bakkeveen', '', NULL, 'bakkeveen-', '53.08040000', '6.26220000'),
('Balgoij', 'GE', 328, 'balgoij-328', '51.78160000', '5.71530000'),
('Balinge', 'DR', 326, 'balinge-326', '52.81080000', '6.62860000'),
('Balk', '', NULL, 'balk-', '52.89790000', '5.58210000'),
('Balkbrug', 'OV', 333, 'balkbrug-333', '52.60340000', '6.38210000'),
('Balloërveld', 'DR', 326, 'balloerveld-326', '53.02310000', '6.63600000'),
('Balloo', 'DR', 326, 'balloo-326', '52.99490000', '6.63070000'),
('Ballum', '', NULL, 'ballum-', '53.44630000', '5.69180000'),
('Baneheide', 'LI', 330, 'baneheide-330', '50.81850000', '5.97350000'),
('Banholt', 'LI', 330, 'banholt-330', '50.79020000', '5.80850000'),
('Bant', 'FL', 327, 'bant-327', '52.77000000', '5.75340000'),
('Bantega', '', NULL, 'bantega-', '52.84110000', '5.79610000'),
('Barchem', 'GE', 328, 'barchem-328', '52.12400000', '6.44110000'),
('Barendrecht', 'ZH', 336, 'barendrecht-336', '51.85190000', '4.54600000'),
('Barger-Compascuum', 'DR', 326, 'barger-compascuum-326', '52.75530000', '7.04400000'),
('Barneveld', 'GE', 328, 'barneveld-328', '52.14670000', '5.58730000'),
('Barsingerhorn', 'NH', 332, 'barsingerhorn-332', '52.78730000', '4.85660000'),
('Basse', 'OV', 333, 'basse-333', '52.80560000', '6.03280000'),
('Batenburg', 'GE', 328, 'batenburg-328', '51.82410000', '5.63000000'),
('Bathmen', 'OV', 333, 'bathmen-333', '52.24930000', '6.29530000'),
('Bavel', 'NB', 331, 'bavel-331', '51.54920000', '4.82310000'),
('Bavel AC', 'NB', 331, 'bavel-ac-331', '51.55220000', '4.85530000'),
('Bears', '', NULL, 'bears-', '53.15760000', '5.73800000'),
('Bedum', 'GR', 329, 'bedum-329', '53.30040000', '6.60170000'),
('Beegden', 'LI', 330, 'beegden-330', '51.19010000', '5.91740000'),
('Beek', 'GE', 328, 'beek-328', '51.82890000', '5.92850000'),
('Beek', 'LI', 330, 'beek-330', '50.94110000', '5.80160000'),
('Beek en Donk', 'NB', 331, 'beek-en-donk-331', '51.53410000', '5.62910000'),
('Beekbergen', 'GE', 328, 'beekbergen-328', '52.15110000', '5.97970000'),
('Beemte Broekland', 'GE', 328, 'beemte-broekland-328', '52.25440000', '6.00760000'),
('Beers NB', 'NB', 331, 'beers-nb-331', '51.72320000', '5.84520000'),
('Beerta', 'GR', 329, 'beerta-329', '53.17440000', '7.09370000'),
('Beerze', 'OV', 333, 'beerze-333', '52.51100000', '6.54410000'),
('Beerzerveld', 'OV', 333, 'beerzerveld-333', '52.49560000', '6.57210000'),
('Beesd', 'GE', 328, 'beesd-328', '51.88950000', '5.19190000'),
('Beesel', 'LI', 330, 'beesel-330', '51.26740000', '6.04230000'),
('Beets', 'NH', 332, 'beets-332', '52.58760000', '4.97590000'),
('Beetsterzwaag', '', NULL, 'beetsterzwaag-', '53.06090000', '6.07820000'),
('Beilen', 'DR', 326, 'beilen-326', '52.86070000', '6.51150000'),
('Beinsdorp', 'NH', 332, 'beinsdorp-332', '52.28680000', '4.59570000'),
('Belfeld', 'LI', 330, 'belfeld-330', '51.31130000', '6.11830000'),
('Bellingwolde', 'GR', 329, 'bellingwolde-329', '53.10870000', '7.16420000'),
('Belt-Schutsloot', 'OV', 333, 'belt-schutsloot-333', '52.67080000', '6.06220000'),
('Beltrum', 'GE', 328, 'beltrum-328', '52.08520000', '6.58670000'),
('Bemelen', 'LI', 330, 'bemelen-330', '50.84550000', '5.77010000'),
('Bemmel', 'GE', 328, 'bemmel-328', '51.89330000', '5.89950000'),
('Beneden-Leeuwen', 'GE', 328, 'beneden-leeuwen-328', '51.88100000', '5.51540000'),
('Bennebroek', 'NH', 332, 'bennebroek-332', '52.32120000', '4.59760000'),
('Bennekom', 'GE', 328, 'bennekom-328', '52.00260000', '5.67400000'),
('Benneveld', 'DR', 326, 'benneveld-326', '52.77540000', '6.74740000'),
('Benningbroek', 'NH', 332, 'benningbroek-332', '52.70290000', '5.02660000'),
('Benschop', 'UT', 334, 'benschop-334', '52.00690000', '4.97730000'),
('Bentelo', 'OV', 333, 'bentelo-333', '52.22310000', '6.68590000'),
('Benthuizen', 'ZH', 336, 'benthuizen-336', '52.07690000', '4.54700000'),
('Bentveld', 'NH', 332, 'bentveld-332', '52.36540000', '4.57160000'),
('Berg en Dal', 'GE', 328, 'berg-en-dal-328', '51.82310000', '5.91210000'),
('Berg en Terblijt', 'LI', 330, 'berg-en-terblijt-330', '50.86090000', '5.78870000'),
('Bergambacht', 'ZH', 336, 'bergambacht-336', '51.93360000', '4.78610000'),
('Bergeijk', 'NB', 331, 'bergeijk-331', '51.31790000', '5.35040000'),
('Bergen ', 'NH', 332, 'bergen-nh-332', '52.66700000', '4.70020000'),
('Bergen aan Zee', 'NH', 332, 'bergen-aan-zee-332', '52.66150000', '4.63190000'),
('Bergen L', 'LI', 330, 'bergen-l-330', '51.60280000', '6.05240000'),
('Bergen op Zoom', 'NB', 331, 'bergen-op-zoom-331', '51.49490000', '4.28610000'),
('Bergentheim', 'OV', 333, 'bergentheim-333', '52.52510000', '6.61500000'),
('Bergharen', 'GE', 328, 'bergharen-328', '51.85260000', '5.66630000'),
('Berghem', 'NB', 331, 'berghem-331', '51.76920000', '5.57340000'),
('Bergschenhoek', 'ZH', 336, 'bergschenhoek-336', '51.98900000', '4.50330000'),
('Beringe', 'LI', 330, 'beringe-330', '51.33660000', '5.94300000'),
('Berkel en Rodenrijs', 'ZH', 336, 'berkel-en-rodenrijs-336', '51.99430000', '4.47600000'),
('Berkel-Enschot', 'NB', 331, 'berkel-enschot-331', '51.58460000', '5.14250000'),
('Berkenwoude', 'ZH', 336, 'berkenwoude-336', '51.94900000', '4.70620000'),
('Berkhout', 'NH', 332, 'berkhout-332', '52.64140000', '4.99910000'),
('Berlicum', 'NB', 331, 'berlicum-331', '51.67690000', '5.40440000'),
('Berltsum', '', NULL, 'berltsum-', '53.24220000', '5.64970000'),
('Bern', 'GE', 328, 'bern-328', '51.74840000', '5.16880000'),
('Best', 'NB', 331, 'best-331', '51.51860000', '5.40940000'),
('Beugen', 'NB', 331, 'beugen-331', '51.67300000', '5.93430000'),
('Beuningen', 'OV', 333, 'beuningen-333', '52.35520000', '7.00290000'),
('Beuningen Gld', 'GE', 328, 'beuningen-gld-328', '51.86050000', '5.76750000'),
('Beusichem', 'GE', 328, 'beusichem-328', '51.95010000', '5.28950000'),
('Beutenaken', 'LI', 330, 'beutenaken-330', '50.78210000', '5.85560000'),
('Beverwijk', 'NH', 332, 'beverwijk-332', '52.48310000', '4.65800000'),
('Biddinghuizen', 'FL', 327, 'biddinghuizen-327', '52.44290000', '5.69950000'),
('Bierum', 'GR', 329, 'bierum-329', '53.38230000', '6.86070000'),
('Biervliet', 'ZE', 335, 'biervliet-335', '51.33000000', '3.68490000'),
('Biest-Houtakker', 'NB', 331, 'biest-houtakker-331', '51.50820000', '5.15650000'),
('Biezenmortel', 'NB', 331, 'biezenmortel-331', '51.62180000', '5.18060000'),
('Biggekerke', 'ZE', 335, 'biggekerke-335', '51.49690000', '3.52350000'),
('Bilthoven', 'UT', 334, 'bilthoven-334', '52.12140000', '5.18730000'),
('Bingelrade', 'LI', 330, 'bingelrade-330', '50.97020000', '5.93700000'),
('Bitgum', '', NULL, 'bitgum-', '53.23600000', '5.68830000'),
('Bitgummole', '', NULL, 'bitgummole-', '53.23530000', '5.70640000'),
('Bladel', 'NB', 331, 'bladel-331', '51.36850000', '5.21760000'),
('Blankenham', 'OV', 333, 'blankenham-333', '52.76700000', '5.89660000'),
('Blaricum', 'NH', 332, 'blaricum-332', '52.28030000', '5.25740000'),
('Blauwestad', 'GR', 329, 'blauwestad-329', '53.17220000', '7.04860000'),
('Blauwhuis', '', NULL, 'blauwhuis-', '53.02280000', '5.53190000'),
('Bleiswijk', 'ZH', 336, 'bleiswijk-336', '52.00290000', '4.50710000'),
('Blesdijke', '', NULL, 'blesdijke-', '52.83080000', '6.01740000'),
('Bleskensgraaf ca', 'ZH', 336, 'bleskensgraaf-ca-336', '51.87120000', '4.77910000'),
('Blessum', '', NULL, 'blessum-', '53.18160000', '5.71230000'),
('Blije', '', NULL, 'blije-', '53.35160000', '5.86390000'),
('Blijham', 'GR', 329, 'blijham-329', '53.10760000', '7.07510000'),
('Blitterswijck', 'LI', 330, 'blitterswijck-330', '51.52890000', '6.10800000'),
('Bloemendaal', 'NH', 332, 'bloemendaal-332', '52.40760000', '4.62070000'),
('Blokker', 'NH', 332, 'blokker-332', '52.66150000', '5.08610000'),
('Blokzijl', 'OV', 333, 'blokzijl-333', '52.72540000', '5.96330000'),
('Boazum', '', NULL, 'boazum-', '53.08900000', '5.69610000'),
('Bocholtz', 'LI', 330, 'bocholtz-330', '50.81850000', '6.00510000'),
('Bodegraven', 'ZH', 336, 'bodegraven-336', '52.08220000', '4.74990000'),
('Boekel', 'NB', 331, 'boekel-331', '51.60290000', '5.67790000'),
('Boelenslaan', '', NULL, 'boelenslaan-', '53.16070000', '6.13950000'),
('Boer', '', NULL, 'boer-', '53.21480000', '5.56350000'),
('Boerakker', 'GR', 329, 'boerakker-329', '53.19690000', '6.33780000'),
('Boesingheliede', 'NH', 332, 'boesingheliede-332', '52.35980000', '4.72460000'),
('Boijl', '', NULL, 'boijl-', '52.91050000', '6.20140000'),
('Boksum', '', NULL, 'boksum-', '53.17770000', '5.72950000'),
('Bolsward', '', NULL, 'bolsward-', '53.06390000', '5.52410000'),
('Bontebok', '', NULL, 'bontebok-', '52.96160000', '6.03410000'),
('Boornbergum', '', NULL, 'boornbergum-', '53.08510000', '6.04450000'),
('Boornzwaag', '', NULL, 'boornzwaag-', '52.96210000', '5.74130000'),
('Borculo', 'GE', 328, 'borculo-328', '52.11570000', '6.51970000'),
('Borger', 'DR', 326, 'borger-326', '52.92300000', '6.79160000'),
('Borgercompagnie', 'GR', 329, 'borgercompagnie-329', '53.11050000', '6.82410000'),
('Borgsweer', 'GR', 329, 'borgsweer-329', '53.29700000', '7.01610000'),
('Born', 'LI', 330, 'born-330', '51.03350000', '5.80990000'),
('Borne', 'OV', 333, 'borne-333', '52.29710000', '6.74280000'),
('Bornerbroek', 'OV', 333, 'bornerbroek-333', '52.31190000', '6.65720000'),
('Bornwird', '', NULL, 'bornwird-', '53.33260000', '5.96120000'),
('Borssele', 'ZE', 335, 'borssele-335', '51.42380000', '3.73870000'),
('Bosch en Duin', 'UT', 334, 'bosch-en-duin-334', '52.12210000', '5.24050000'),
('Boschoord', 'DR', 326, 'boschoord-326', '52.89230000', '6.21950000'),
('Boskoop', 'ZH', 336, 'boskoop-336', '52.07440000', '4.65630000'),
('Bosschenhoofd', 'NB', 331, 'bosschenhoofd-331', '51.56160000', '4.54220000'),
('Botlek Rotterdam', 'ZH', 336, 'botlek-rotterdam-336', '51.87910000', '4.27390000'),
('Bourtange', 'GR', 329, 'bourtange-329', '53.00840000', '7.18640000'),
('Boven-Leeuwen', 'GE', 328, 'boven-leeuwen-328', '51.88380000', '5.54940000'),
('Bovenkarspel', 'NH', 332, 'bovenkarspel-332', '52.69470000', '5.24410000'),
('Bovensmilde', 'DR', 326, 'bovensmilde-326', '52.97750000', '6.47990000'),
('Boxmeer', 'NB', 331, 'boxmeer-331', '51.64830000', '5.94560000'),
('Boxtel', 'NB', 331, 'boxtel-331', '51.58580000', '5.32070000'),
('Braamt', 'GE', 328, 'braamt-328', '51.92560000', '6.26380000'),
('Brakel', 'GE', 328, 'brakel-328', '51.81660000', '5.09120000'),
('Brandwijk', 'ZH', 336, 'brandwijk-336', '51.88140000', '4.82300000'),
('Brantgum', '', NULL, 'brantgum-', '53.35280000', '5.93210000'),
('Breda', 'NB', 331, 'breda-331', '51.58810000', '4.77550000'),
('Bredevoort', 'GE', 328, 'bredevoort-328', '51.94260000', '6.62050000'),
('Breedenbroek', 'GE', 328, 'breedenbroek-328', '51.88110000', '6.46360000'),
('Breezand', 'NH', 332, 'breezand-332', '52.88850000', '4.80910000'),
('Breezanddijk', '', NULL, 'breezanddijk-', '53.01930000', '5.20730000'),
('Breskens', 'ZE', 335, 'breskens-335', '51.39570000', '3.55230000'),
('Breukelen', 'UT', 334, 'breukelen-334', '52.17410000', '5.00310000'),
('Breukeleveen', 'NH', 332, 'breukeleveen-332', '52.17610000', '5.06910000'),
('Brielle', 'ZH', 336, 'brielle-336', '51.90500000', '4.16580000'),
('Briltil', 'GR', 329, 'briltil-329', '53.24070000', '6.39050000'),
('Britsum', '', NULL, 'britsum-', '53.25240000', '5.78500000'),
('Britswert', '', NULL, 'britswert-', '53.11320000', '5.67410000'),
('Broek', '', NULL, 'broek-', '52.98130000', '5.77370000'),
('Broek in Waterland', 'NH', 332, 'broek-in-waterland-332', '52.43290000', '4.99700000'),
('Broek op Langedijk', 'NH', 332, 'broek-op-langedijk-332', '52.67920000', '4.80330000'),
('Broekhuizen', 'DR', 326, 'broekhuizen-326', '52.69740000', '6.26240000'),
('Broekhuizen', 'LI', 330, 'broekhuizen-330', '51.48440000', '6.16040000'),
('Broekhuizenvorst', 'LI', 330, 'broekhuizenvorst-330', '51.49590000', '6.15700000'),
('Broekland', 'OV', 333, 'broekland-333', '52.36400000', '6.20750000'),
('Broeksterwâld', '', NULL, 'broeksterwald-', '53.27290000', '5.99370000'),
('Bronkhorst', 'GE', 328, 'bronkhorst-328', '52.07710000', '6.18290000'),
('Bronneger', 'DR', 326, 'bronneger-326', '52.94760000', '6.81770000'),
('Bronnegerveen', 'DR', 326, 'bronnegerveen-326', '52.95550000', '6.83460000'),
('Brouwershaven', 'ZE', 335, 'brouwershaven-335', '51.73200000', '3.90090000'),
('Bruchem', 'GE', 328, 'bruchem-328', '51.78610000', '5.23740000'),
('Brucht', 'OV', 333, 'brucht-333', '52.54760000', '6.61900000'),
('Bruchterveld', 'OV', 333, 'bruchterveld-333', '52.53360000', '6.66210000'),
('Bruinehaar', 'OV', 333, 'bruinehaar-333', '52.46790000', '6.70180000'),
('Bruinisse', 'ZE', 335, 'bruinisse-335', '51.66380000', '4.08730000'),
('Brummen', 'GE', 328, 'brummen-328', '52.09420000', '6.15520000'),
('Brunssum', 'LI', 330, 'brunssum-330', '50.94990000', '5.96640000'),
('Bruntinge', 'DR', 326, 'bruntinge-326', '52.81900000', '6.58410000'),
('Buchten', 'LI', 330, 'buchten-330', '51.04230000', '5.81060000'),
('Budel', 'NB', 331, 'budel-331', '51.27180000', '5.57590000'),
('Budel-Dorplein', 'NB', 331, 'budel-dorplein-331', '51.23810000', '5.57820000'),
('Budel-Schoot', 'NB', 331, 'budel-schoot-331', '51.25070000', '5.56700000'),
('Buggenum', 'LI', 330, 'buggenum-330', '51.23340000', '5.97760000'),
('Buinen', 'DR', 326, 'buinen-326', '52.93160000', '6.83580000'),
('Buinerveen', 'DR', 326, 'buinerveen-326', '52.93510000', '6.88090000'),
('Buitenkaag', 'NH', 332, 'buitenkaag-332', '52.22090000', '4.55990000'),
('Buitenpost', '', NULL, 'buitenpost-', '53.25030000', '6.14610000'),
('Bunde', 'LI', 330, 'bunde-330', '50.89650000', '5.73300000'),
('Bunne', 'DR', 326, 'bunne-326', '53.11390000', '6.52520000'),
('Bunnik', 'UT', 334, 'bunnik-334', '52.06710000', '5.19750000'),
('Bunschoten-Spakenburg', 'UT', 334, 'bunschoten-spakenburg-334', '52.24270000', '5.37890000'),
('Burdaard', '', NULL, 'burdaard-', '53.29570000', '5.87740000'),
('Buren', '', NULL, 'buren-', '53.45230000', '5.80090000'),
('Buren', 'GE', 328, 'buren-328', '51.91070000', '5.33400000'),
('Burgerbrug', 'NH', 332, 'burgerbrug-332', '52.75150000', '4.69520000'),
('Burgerveen', 'NH', 332, 'burgerveen-332', '52.24030000', '4.68190000'),
('Burgh-Haamstede', 'ZE', 335, 'burgh-haamstede-335', '51.69360000', '3.72800000'),
('Burgum', '', NULL, 'burgum-', '53.19450000', '5.99300000'),
('Burgwerd', '', NULL, 'burgwerd-', '53.08830000', '5.54370000'),
('Burum', '', NULL, 'burum-', '53.27430000', '6.22970000'),
('Bussum', 'NH', 332, 'bussum-332', '52.26010000', '5.16620000'),
('Buurmalsen', 'GE', 328, 'buurmalsen-328', '51.90230000', '5.30300000'),
('Cadier en Keer', 'LI', 330, 'cadier-en-keer-330', '50.82990000', '5.76450000'),
('Cadzand', 'ZE', 335, 'cadzand-335', '51.37570000', '3.39530000'),
('Callantsoog', 'NH', 332, 'callantsoog-332', '52.84380000', '4.70540000'),
('Capelle aan den IJssel', 'ZH', 336, 'capelle-aan-den-ijssel-336', '51.91700000', '4.56510000'),
('Castelre', 'NB', 331, 'castelre-331', '51.41930000', '4.78670000'),
('Castenray', 'LI', 330, 'castenray-330', '51.49010000', '6.03310000'),
('Casteren', 'NB', 331, 'casteren-331', '51.39730000', '5.23890000'),
('Castricum', 'NH', 332, 'castricum-332', '52.55280000', '4.66370000'),
('Chaam', 'NB', 331, 'chaam-331', '51.50600000', '4.86370000'),
('Clinge', 'ZE', 335, 'clinge-335', '51.26910000', '4.08910000'),
('Coevorden', 'DR', 326, 'coevorden-326', '52.66660000', '6.73510000'),
('Colijnsplaat', 'ZE', 335, 'colijnsplaat-335', '51.59850000', '3.84650000'),
('Collendoorn', 'OV', 333, 'collendoorn-333', '52.59390000', '6.59470000'),
('Colmschate', 'OV', 333, 'colmschate-333', '52.24910000', '6.22210000'),
('Cornwerd', '', NULL, 'cornwerd-', '53.08330000', '5.39120000'),
('Cothen', 'UT', 334, 'cothen-334', '51.99570000', '5.30630000'),
('Creil', 'FL', 327, 'creil-327', '52.76500000', '5.65830000'),
('Cromvoirt', 'NB', 331, 'cromvoirt-331', '51.66050000', '5.23350000'),
('Cruquius', 'NH', 332, 'cruquius-332', '52.33430000', '4.63770000'),
('Cuijk', 'NB', 331, 'cuijk-331', '51.72770000', '5.87880000'),
('Culemborg', 'GE', 328, 'culemborg-328', '51.95700000', '5.22980000'),
('Daarle', 'OV', 333, 'daarle-333', '52.42860000', '6.53900000'),
('Daarlerveen', 'OV', 333, 'daarlerveen-333', '52.44180000', '6.57880000'),
('Dalem', 'ZH', 336, 'dalem-336', '51.82720000', '5.01020000'),
('Dalen', 'DR', 326, 'dalen-326', '52.69270000', '6.75740000'),
('Dalerpeel', 'DR', 326, 'dalerpeel-326', '52.68120000', '6.66120000'),
('Dalerveen', 'DR', 326, 'dalerveen-326', '52.69380000', '6.80860000'),
('Dalfsen', 'OV', 333, 'dalfsen-333', '52.51090000', '6.25720000'),
('Dalmsholte', 'OV', 333, 'dalmsholte-333', '52.46850000', '6.36630000'),
('Damwâld', '', NULL, 'damwald-', '53.28940000', '5.99540000'),
('Darp', 'DR', 326, 'darp-326', '52.77460000', '6.20500000'),
('De Bilt', 'UT', 334, 'de-bilt-334', '52.10910000', '5.17560000'),
('De Blesse', '', NULL, 'de-blesse-', '52.84270000', '6.04300000'),
('De Bult', 'OV', 333, 'de-bult-333', '52.81420000', '6.11930000'),
('De Cocksdorp', 'NH', 332, 'de-cocksdorp-332', '53.14600000', '4.84790000'),
('De Falom', '', NULL, 'de-falom-', '53.26510000', '6.00640000'),
('De Glind', 'GE', 328, 'de-glind-328', '52.12000000', '5.51050000'),
('De Goorn', 'NH', 332, 'de-goorn-332', '52.62850000', '4.94960000'),
('De Groeve', 'DR', 326, 'de-groeve-326', '53.11420000', '6.71670000'),
('De Heen', 'NB', 331, 'de-heen-331', '51.60450000', '4.26300000'),
('De Heurne', 'GE', 328, 'de-heurne-328', '51.89020000', '6.49670000'),
('de Hoef', 'UT', 334, 'de-hoef-334', '52.20810000', '4.81720000'),
('De Hoeve', '', NULL, 'de-hoeve-', '52.88920000', '6.09210000'),
('De Kiel', 'DR', 326, 'de-kiel-326', '52.86250000', '6.74440000'),
('De Klomp', 'GE', 328, 'de-klomp-328', '52.04330000', '5.57860000'),
('De Knipe', '', NULL, 'de-knipe-', '52.96780000', '5.97730000'),
('De Koog', 'NH', 332, 'de-koog-332', '53.09160000', '4.76500000'),
('De Krim', 'OV', 333, 'de-krim-333', '52.64290000', '6.59330000'),
('De Kwakel', 'NH', 332, 'de-kwakel-332', '52.23890000', '4.78830000'),
('De Lier', 'ZH', 336, 'de-lier-336', '51.97650000', '4.24840000'),
('de Lutte', 'OV', 333, 'de-lutte-333', '52.31330000', '6.99280000'),
('De Meern', 'UT', 334, 'de-meern-334', '52.09090000', '5.03350000'),
('De Moer', 'NB', 331, 'de-moer-331', '51.62540000', '5.01140000'),
('De Mortel', 'NB', 331, 'de-mortel-331', '51.54000000', '5.71290000'),
('De Pol', 'OV', 333, 'de-pol-333', '52.82330000', '6.08110000'),
('De Punt', 'DR', 326, 'de-punt-326', '53.11200000', '6.60520000'),
('De Rijp', 'NH', 332, 'de-rijp-332', '52.55620000', '4.84550000'),
('De Rips', 'NB', 331, 'de-rips-331', '51.54900000', '5.81360000'),
('De Schiphorst', 'DR', 326, 'de-schiphorst-326', '52.67830000', '6.25830000'),
('De Steeg', 'GE', 328, 'de-steeg-328', '52.01880000', '6.06320000'),
('De Tike', '', NULL, 'de-tike-', '53.15110000', '6.03440000'),
('De Veenhoop', '', NULL, 'de-veenhoop-', '53.09290000', '5.95870000'),
('De Waal', 'NH', 332, 'de-waal-332', '53.07720000', '4.82220000'),
('De Weere', 'NH', 332, 'de-weere-332', '52.73400000', '4.98550000'),
('De Westereen', '', NULL, 'de-westereen-', '53.25540000', '6.03530000'),
('de Wijk', 'DR', 326, 'de-wijk-326', '52.67290000', '6.29250000'),
('De Wilgen', '', NULL, 'de-wilgen-', '53.10060000', '6.03350000'),
('De Wilp', 'GR', 329, 'de-wilp-329', '53.11840000', '6.25910000'),
('de Woude', 'NH', 332, 'de-woude-332', '52.54640000', '4.77520000'),
('De Zilk', 'ZH', 336, 'de-zilk-336', '52.30210000', '4.54390000'),
('Dearsum', '', NULL, 'dearsum-', '53.08680000', '5.71660000'),
('Dedemsvaart', 'OV', 333, 'dedemsvaart-333', '52.59990000', '6.46250000'),
('Dedgum', '', NULL, 'dedgum-', '53.02310000', '5.49210000'),
('Deelen', 'GE', 328, 'deelen-328', '52.07910000', '5.90350000'),
('Deest', 'GE', 328, 'deest-328', '51.88800000', '5.66710000'),
('Deil', 'GE', 328, 'deil-328', '51.88380000', '5.24140000'),
('Deinum', '', NULL, 'deinum-', '53.19170000', '5.72520000'),
('Delden', 'OV', 333, 'delden-333', '52.25850000', '6.71140000'),
('Delfgauw', 'ZH', 336, 'delfgauw-336', '52.00440000', '4.39480000'),
('Delfstrahuizen', '', NULL, 'delfstrahuizen-', '52.87660000', '5.83130000'),
('Delft', 'ZH', 336, 'delft-336', '52.01200000', '4.35980000'),
('Delfzijl', 'GR', 329, 'delfzijl-329', '53.33480000', '6.90210000'),
('Delwijnen', 'GE', 328, 'delwijnen-328', '51.77110000', '5.18660000'),
('Demen', 'NB', 331, 'demen-331', '51.81460000', '5.62960000'),
('Den Andel', 'GR', 329, 'den-andel-329', '53.39270000', '6.51310000'),
('Den Bommel', 'ZH', 336, 'den-bommel-336', '51.71300000', '4.28180000'),
('Den Burg', 'NH', 332, 'den-burg-332', '53.05660000', '4.79440000'),
('Den Dolder', 'UT', 334, 'den-dolder-334', '52.14090000', '5.23920000'),
('Den Dungen', 'NB', 331, 'den-dungen-331', '51.66360000', '5.36800000'),
('Den Ham', 'GR', 329, 'den-ham-329', '53.27040000', '6.44400000'),
('Den Ham', 'OV', 333, 'den-ham-333', '52.46430000', '6.49920000'),
('Den Helder', 'NH', 332, 'den-helder-332', '52.95630000', '4.76790000'),
('Den Hoorn', 'NH', 332, 'den-hoorn-332', '53.02400000', '4.76230000'),
('Den Hoorn', 'ZH', 336, 'den-hoorn-336', '52.00240000', '4.32850000'),
('Den Horn', 'GR', 329, 'den-horn-329', '53.22660000', '6.45200000'),
('Den Hout', 'NB', 331, 'den-hout-331', '51.65690000', '4.81200000'),
('Den Ilp', 'NH', 332, 'den-ilp-332', '52.45460000', '4.90930000'),
('Den Oever', 'NH', 332, 'den-oever-332', '52.93290000', '5.02680000'),
('Den Velde', 'OV', 333, 'den-velde-333', '52.59520000', '6.69790000'),
('Denekamp', 'OV', 333, 'denekamp-333', '52.38090000', '7.00940000'),
('Deurne', 'NB', 331, 'deurne-331', '51.46130000', '5.79490000'),
('Deurningen', 'OV', 333, 'deurningen-333', '52.30220000', '6.87830000'),
('Deursen-Dennenburg', 'NB', 331, 'deursen-dennenburg-331', '51.80140000', '5.62680000'),
('Deurze', 'DR', 326, 'deurze-326', '52.98290000', '6.60940000'),
('Deventer', 'OV', 333, 'deventer-333', '52.25250000', '6.15930000'),
('Didam', 'GE', 328, 'didam-328', '51.94730000', '6.12940000'),
('Dieden', 'NB', 331, 'dieden-331', '51.81860000', '5.61150000'),
('Diemen', 'NH', 332, 'diemen-332', '52.34370000', '4.96670000'),
('Diepenheim', 'OV', 333, 'diepenheim-333', '52.19800000', '6.56130000'),
('Diepenveen', 'OV', 333, 'diepenveen-333', '52.28900000', '6.15100000'),
('Dieren', 'GE', 328, 'dieren-328', '52.05580000', '6.09870000'),
('Diessen', 'NB', 331, 'diessen-331', '51.47090000', '5.17870000'),
('Diever', 'DR', 326, 'diever-326', '52.85700000', '6.31960000'),
('Dieverbrug', 'DR', 326, 'dieverbrug-326', '52.84730000', '6.33740000'),
('Diffelen', 'OV', 333, 'diffelen-333', '52.52820000', '6.55670000'),
('Dijken', '', NULL, 'dijken-', '52.95470000', '5.70870000'),
('Dinteloord', 'NB', 331, 'dinteloord-331', '51.63400000', '4.36810000'),
('Dinxperlo', 'GE', 328, 'dinxperlo-328', '51.86450000', '6.48700000'),
('Diphoorn', 'DR', 326, 'diphoorn-326', '52.77060000', '6.81830000'),
('Dirkshorn', 'NH', 332, 'dirkshorn-332', '52.74690000', '4.77800000'),
('Dirksland', 'ZH', 336, 'dirksland-336', '51.74750000', '4.10000000'),
('Dodewaard', 'GE', 328, 'dodewaard-328', '51.91180000', '5.65770000'),
('Doenrade', 'LI', 330, 'doenrade-330', '50.96710000', '5.90820000'),
('Doesburg', 'GE', 328, 'doesburg-328', '52.01390000', '6.13840000'),
('Doetinchem', 'GE', 328, 'doetinchem-328', '51.96620000', '6.29130000'),
('Doeveren', 'NB', 331, 'doeveren-331', '51.72200000', '5.09130000'),
('Doezum', 'GR', 329, 'doezum-329', '53.20030000', '6.24760000'),
('Dokkum', '', NULL, 'dokkum-', '53.32500000', '6.00070000'),
('Doldersum', 'DR', 326, 'doldersum-326', '52.88840000', '6.25280000'),
('Domburg', 'ZE', 335, 'domburg-335', '51.56160000', '3.49700000'),
('Donderen', 'DR', 326, 'donderen-326', '53.09540000', '6.54520000'),
('Dongen', 'NB', 331, 'dongen-331', '51.62610000', '4.92550000'),
('Dongjum', '', NULL, 'dongjum-', '53.20870000', '5.54380000'),
('Doniaga', '', NULL, 'doniaga-', '52.90270000', '5.74600000'),
('Donkerbroek', '', NULL, 'donkerbroek-', '53.01930000', '6.23750000'),
('Doorn', 'UT', 334, 'doorn-334', '52.03860000', '5.33610000'),
('Doornenburg', 'GE', 328, 'doornenburg-328', '51.89120000', '5.99870000'),
('Doornspijk', 'GE', 328, 'doornspijk-328', '52.41410000', '5.82510000'),
('Doorwerth', 'GE', 328, 'doorwerth-328', '51.97920000', '5.79540000'),
('Dordrecht', 'ZH', 336, 'dordrecht-336', '51.81390000', '4.66860000'),
('Dorst', 'NB', 331, 'dorst-331', '51.59420000', '4.86230000'),
('Drachten', '', NULL, 'drachten-', '53.11380000', '6.09480000'),
('Drachten-Azeven', '', NULL, 'drachten-azeven-', '53.09890000', '6.13330000'),
('Drachtstercompagnie', '', NULL, 'drachtstercompagnie-', '53.13390000', '6.14530000'),
('Dreischor', 'ZE', 335, 'dreischor-335', '51.68970000', '3.98250000'),
('Drempt', 'GE', 328, 'drempt-328', '52.01350000', '6.17890000'),
('Dreumel', 'GE', 328, 'dreumel-328', '51.84880000', '5.43250000'),
('Driebergen-Rijsenburg', 'UT', 334, 'driebergen-rijsenburg-334', '52.05720000', '5.28770000'),
('Drieborg', 'GR', 329, 'drieborg-329', '53.20920000', '7.18190000'),
('Driebruggen', 'ZH', 336, 'driebruggen-336', '52.04280000', '4.79940000'),
('Driehuis NH', 'NH', 332, 'driehuis-nh-332', '52.44660000', '4.63840000'),
('Driehuizen', 'NH', 332, 'driehuizen-332', '52.58080000', '4.80820000'),
('Driel', 'GE', 328, 'driel-328', '51.95850000', '5.81310000'),
('Driewegen', 'ZE', 335, 'driewegen-335', '51.41940000', '3.80420000'),
('Driezum', '', NULL, 'driezum-', '53.29730000', '6.04780000'),
('Drijber', 'DR', 326, 'drijber-326', '52.78800000', '6.55540000'),
('Drimmelen', 'NB', 331, 'drimmelen-331', '51.70880000', '4.80480000'),
('Drogeham', '', NULL, 'drogeham-', '53.20100000', '6.11450000'),
('Drogteropslagen', 'DR', 326, 'drogteropslagen-326', '52.62190000', '6.49900000'),
('Drongelen', 'NB', 331, 'drongelen-331', '51.71690000', '5.04730000'),
('Dronryp', '', NULL, 'dronryp-', '53.19400000', '5.64510000'),
('Dronten', 'FL', 327, 'dronten-327', '52.52240000', '5.72650000'),
('Drouwen', 'DR', 326, 'drouwen-326', '52.95390000', '6.79070000'),
('Drouwenermond', 'DR', 326, 'drouwenermond-326', '52.98100000', '6.91160000'),
('Drouwenerveen', 'DR', 326, 'drouwenerveen-326', '52.96710000', '6.85600000'),
('Drunen', 'NB', 331, 'drunen-331', '51.68580000', '5.13580000'),
('Druten', 'GE', 328, 'druten-328', '51.88820000', '5.60290000'),
('Duiven', 'GE', 328, 'duiven-328', '51.94970000', '6.01910000'),
('Duivendrecht', 'NH', 332, 'duivendrecht-332', '52.33150000', '4.93860000'),
('Duizel', 'NB', 331, 'duizel-331', '51.36920000', '5.29560000'),
('Dussen', 'NB', 331, 'dussen-331', '51.73280000', '4.96340000'),
('Dwingeloo', 'DR', 326, 'dwingeloo-326', '52.84710000', '6.42590000'),
('Eagum', '', NULL, 'eagum-', '53.13020000', '5.82730000'),
('Earnewâld', '', NULL, 'earnewald-', '53.13060000', '5.94590000'),
('Easterein', '', NULL, 'easterein-', '53.09730000', '5.61870000'),
('Easterlittens', '', NULL, 'easterlittens-', '53.13520000', '5.65030000'),
('Eastermar', '', NULL, 'eastermar-', '53.17830000', '6.06670000'),
('Easterwierrum', '', NULL, 'easterwierrum-', '53.11050000', '5.73210000'),
('Echt', 'LI', 330, 'echt-330', '51.10560000', '5.87430000'),
('Echteld', 'GE', 328, 'echteld-328', '51.91020000', '5.49250000'),
('Echten', '', NULL, 'echten-', '52.87080000', '5.79740000'),
('Echten', 'DR', 326, 'echten-326', '52.70750000', '6.38400000'),
('Echtenerbrug', '', NULL, 'echtenerbrug-', '52.87110000', '5.81930000'),
('Eck en Wiel', 'GE', 328, 'eck-en-wiel-328', '51.96930000', '5.45510000'),
('Eckelrade', 'LI', 330, 'eckelrade-330', '50.80710000', '5.76610000'),
('Edam', 'NH', 332, 'edam-332', '52.51140000', '5.05220000'),
('Ede', 'GE', 328, 'ede-328', '52.04160000', '5.67450000'),
('Ederveen', 'GE', 328, 'ederveen-328', '52.06040000', '5.58100000'),
('Ee', '', NULL, 'ee-', '53.33150000', '6.10110000'),
('Eede', 'ZE', 335, 'eede-335', '51.24800000', '3.45220000'),
('Eefde', 'GE', 328, 'eefde-328', '52.16840000', '6.22690000'),
('Eelde', 'DR', 326, 'eelde-326', '53.13670000', '6.56310000'),
('Eelderwolde', 'DR', 326, 'eelderwolde-326', '53.17910000', '6.53890000'),
('Eemdijk', 'UT', 334, 'eemdijk-334', '52.25380000', '5.32870000'),
('Eemnes', 'UT', 334, 'eemnes-334', '52.25230000', '5.25870000'),
('Eemshaven', 'GR', 329, 'eemshaven-329', '53.44330000', '6.83040000'),
('Een', 'DR', 326, 'een-326', '53.08110000', '6.38370000'),
('Een-West', 'DR', 326, 'een-west-326', '53.08270000', '6.33440000'),
('Eenrum', 'GR', 329, 'eenrum-329', '53.36320000', '6.45990000'),
('Eenum', 'GR', 329, 'eenum-329', '53.33880000', '6.78120000'),
('Eerbeek', 'GE', 328, 'eerbeek-328', '52.10410000', '6.05660000'),
('Eersel', 'NB', 331, 'eersel-331', '51.35630000', '5.31610000'),
('Ees', 'DR', 326, 'ees-326', '52.90830000', '6.81360000'),
('Eesergroen', 'DR', 326, 'eesergroen-326', '52.89020000', '6.78260000'),
('Eeserveen', 'DR', 326, 'eeserveen-326', '52.87330000', '6.76930000'),
('Eesterga', '', NULL, 'eesterga-', '52.86560000', '5.72700000'),
('Eesveen', 'OV', 333, 'eesveen-333', '52.82420000', '6.13580000'),
('Eethen', 'NB', 331, 'eethen-331', '51.73130000', '5.05320000'),
('Eext', 'DR', 326, 'eext-326', '53.02010000', '6.73660000'),
('Eexterveen', 'DR', 326, 'eexterveen-326', '53.05220000', '6.80350000'),
('Eexterveenschekanaal', 'DR', 326, 'eexterveenschekanaal-326', '53.05820000', '6.83280000'),
('Eexterzandvoort', 'DR', 326, 'eexterzandvoort-326', '53.03430000', '6.78460000'),
('Egchel', 'LI', 330, 'egchel-330', '51.31400000', '5.97140000'),
('Egmond aan den Hoef', 'NH', 332, 'egmond-aan-den-hoef-332', '52.62150000', '4.64100000'),
('Egmond aan Zee', 'NH', 332, 'egmond-aan-zee-332', '52.61820000', '4.62590000'),
('Egmond-Binnen', 'NH', 332, 'egmond-binnen-332', '52.61180000', '4.66600000'),
('Eibergen', 'GE', 328, 'eibergen-328', '52.09940000', '6.64130000'),
('Eijsden', 'LI', 330, 'eijsden-330', '50.77900000', '5.71300000'),
('Eindhoven', 'NB', 331, 'eindhoven-331', '51.43670000', '5.48010000'),
('Einighausen', 'LI', 330, 'einighausen-330', '51.00040000', '5.82740000'),
('Ekehaar', 'DR', 326, 'ekehaar-326', '52.95280000', '6.60140000'),
('Elahuizen', '', NULL, 'elahuizen-', '52.92520000', '5.54110000'),
('Elburg', 'GE', 328, 'elburg-328', '52.44820000', '5.84650000'),
('Eldersloo', 'DR', 326, 'eldersloo-326', '52.96430000', '6.61550000'),
('Eleveld', 'DR', 326, 'eleveld-326', '52.95770000', '6.58290000'),
('Elim', 'DR', 326, 'elim-326', '52.68110000', '6.57740000'),
('Elkenrade', 'LI', 330, 'elkenrade-330', '50.84120000', '5.91930000'),
('Ell', 'LI', 330, 'ell-330', '51.21920000', '5.79480000'),
('Ellecom', 'GE', 328, 'ellecom-328', '52.03140000', '6.08880000'),
('Ellemeet', 'ZE', 335, 'ellemeet-335', '51.72710000', '3.81800000'),
('Ellertshaar', 'DR', 326, 'ellertshaar-326', '52.89480000', '6.73780000'),
('Ellewoutsdijk', 'ZE', 335, 'ellewoutsdijk-335', '51.39160000', '3.81660000'),
('Elp', 'DR', 326, 'elp-326', '52.88200000', '6.64350000'),
('Elsendorp', 'NB', 331, 'elsendorp-331', '51.58030000', '5.77110000'),
('Elshout', 'NB', 331, 'elshout-331', '51.70010000', '5.13980000'),
('Elsloo', '', NULL, 'elsloo-', '52.94230000', '6.23960000'),
('Elsloo', 'LI', 330, 'elsloo-330', '50.95050000', '5.76810000'),
('Elspeet', 'GE', 328, 'elspeet-328', '52.29280000', '5.78120000'),
('Elst', 'GE', 328, 'elst-328', '51.92280000', '5.84920000'),
('Elst Ut', 'UT', 334, 'elst-ut-334', '51.98610000', '5.50130000'),
('Emmeloord', 'FL', 327, 'emmeloord-327', '52.70850000', '5.75660000'),
('Emmen', 'DR', 326, 'emmen-326', '52.78280000', '6.89550000'),
('Emmer-Compascuum', 'DR', 326, 'emmer-compascuum-326', '52.80890000', '7.03430000'),
('Empe', 'GE', 328, 'empe-328', '52.15150000', '6.13160000'),
('Emst', 'GE', 328, 'emst-328', '52.31730000', '5.96410000'),
('Engwierum', '', NULL, 'engwierum-', '53.32090000', '6.14100000'),
('Enkhuizen', 'NH', 332, 'enkhuizen-332', '52.70270000', '5.28490000'),
('Ens', 'FL', 327, 'ens-327', '52.63880000', '5.82650000'),
('Enschede', 'OV', 333, 'enschede-333', '52.22000000', '6.90090000'),
('Enspijk', 'GE', 328, 'enspijk-328', '51.88120000', '5.21180000'),
('Enter', 'OV', 333, 'enter-333', '52.29480000', '6.57760000'),
('Enumatil', 'GR', 329, 'enumatil-329', '53.21560000', '6.41000000'),
('Epe', 'GE', 328, 'epe-328', '52.34730000', '5.99220000'),
('Epen', 'LI', 330, 'epen-330', '50.77260000', '5.91040000'),
('Eppenhuizen', 'GR', 329, 'eppenhuizen-329', '53.37960000', '6.69590000'),
('Epse', 'GE', 328, 'epse-328', '52.22470000', '6.20590000'),
('Erica', 'DR', 326, 'erica-326', '52.71170000', '6.92500000'),
('Erichem', 'GE', 328, 'erichem-328', '51.89870000', '5.35050000'),
('Erlecom', 'GE', 328, 'erlecom-328', '51.84970000', '5.95850000'),
('Erm', 'DR', 326, 'erm-326', '52.74840000', '6.80840000'),
('Ermelo', 'GE', 328, 'ermelo-328', '52.29850000', '5.62090000'),
('Erp', 'NB', 331, 'erp-331', '51.59410000', '5.60580000'),
('Esbeek', 'NB', 331, 'esbeek-331', '51.45980000', '5.13760000'),
('Esch', 'NB', 331, 'esch-331', '51.61170000', '5.29180000'),
('Escharen', 'NB', 331, 'escharen-331', '51.74050000', '5.74560000'),
('Espel', 'FL', 327, 'espel-327', '52.72420000', '5.64310000'),
('Est', 'GE', 328, 'est-328', '51.85180000', '5.31530000'),
('Etten', 'GE', 328, 'etten-328', '51.91610000', '6.33420000'),
('Etten-Leur', 'NB', 331, 'etten-leur-331', '51.58580000', '4.65130000'),
('Europoort Rotterdam', 'ZH', 336, 'europoort-rotterdam-336', '51.93240000', '4.15770000'),
('Eursinge', 'DR', 326, 'eursinge-326', '52.77730000', '6.44110000'),
('Everdingen', 'UT', 334, 'everdingen-334', '51.96130000', '5.15500000'),
('Evertsoord', 'LI', 330, 'evertsoord-330', '51.40200000', '5.95090000'),
('Ewijk', 'GE', 328, 'ewijk-328', '51.86660000', '5.73280000'),
('Exloërveen', 'DR', 326, 'exloerveen-326', '52.90270000', '6.90130000'),
('Exloo', 'DR', 326, 'exloo-326', '52.87810000', '6.86670000'),
('Exmorra', '', NULL, 'exmorra-', '53.05610000', '5.46350000'),
('Eygelshoven', 'LI', 330, 'eygelshoven-330', '50.89320000', '6.05890000'),
('Eys', 'LI', 330, 'eys-330', '50.82680000', '5.94040000'),
('Ezinge', 'GR', 329, 'ezinge-329', '53.30870000', '6.44320000'),
('Farmsum', 'GR', 329, 'farmsum-329', '53.31980000', '6.93030000'),
('Feanwâlden', '', NULL, 'feanwalden-', '53.23920000', '5.99010000'),
('Feerwerd', 'GR', 329, 'feerwerd-329', '53.30470000', '6.46860000'),
('Feinsum', '', NULL, 'feinsum-', '53.27940000', '5.75660000'),
('Ferwert', '', NULL, 'ferwert-', '53.33810000', '5.82550000'),
('Ferwoude', '', NULL, 'ferwoude-', '52.98820000', '5.43000000'),
('Fijnaart', 'NB', 331, 'fijnaart-331', '51.63830000', '4.47030000'),
('Finsterwolde', 'GR', 329, 'finsterwolde-329', '53.19650000', '7.09080000'),
('Firdgum', '', NULL, 'firdgum-', '53.25080000', '5.55830000'),
('Fleringen', 'OV', 333, 'fleringen-333', '52.38030000', '6.80400000'),
('Fluitenberg', 'DR', 326, 'fluitenberg-326', '52.74020000', '6.45490000'),
('Fochteloo', '', NULL, 'fochteloo-', '52.98970000', '6.34050000'),
('Follega', '', NULL, 'follega-', '52.88490000', '5.73630000'),
('Folsgare', '', NULL, 'folsgare-', '53.03700000', '5.60450000'),
('Formerum', '', NULL, 'formerum-', '53.39150000', '5.30780000'),
('Foudgum', '', NULL, 'foudgum-', '53.34550000', '5.94360000'),
('Foxhol', 'GR', 329, 'foxhol-329', '53.16850000', '6.72020000'),
('Foxwolde', 'DR', 326, 'foxwolde-326', '53.15600000', '6.45310000'),
('Franeker', '', NULL, 'franeker-', '53.18630000', '5.54250000'),
('Frederiksoord', 'DR', 326, 'frederiksoord-326', '52.84550000', '6.18340000'),
('Friens', '', NULL, 'friens-', '53.09730000', '5.79820000'),
('Frieschepalen', '', NULL, 'frieschepalen-', '53.10810000', '6.20590000'),
('Froombosch', 'GR', 329, 'froombosch-329', '53.19320000', '6.77940000'),
('Gaanderen', 'GE', 328, 'gaanderen-328', '51.93160000', '6.34990000'),
('Gaast', '', NULL, 'gaast-', '53.01760000', '5.41380000'),
('Gaastmeer', '', NULL, 'gaastmeer-', '52.96610000', '5.53970000'),
('Galder', 'NB', 331, 'galder-331', '51.51450000', '4.77380000'),
('Gameren', 'GE', 328, 'gameren-328', '51.80040000', '5.20250000'),
('Gapinge', 'ZE', 335, 'gapinge-335', '51.54440000', '3.62580000'),
('Garderen', 'GE', 328, 'garderen-328', '52.23680000', '5.70230000'),
('Garmerwolde', 'GR', 329, 'garmerwolde-329', '53.24740000', '6.65330000'),
('Garminge', 'DR', 326, 'garminge-326', '52.82020000', '6.62370000'),
('Garnwerd', 'GR', 329, 'garnwerd-329', '53.30070000', '6.49280000'),
('Garrelsweer', 'GR', 329, 'garrelsweer-329', '53.31310000', '6.75220000'),
('Garsthuizen', 'GR', 329, 'garsthuizen-329', '53.36900000', '6.71660000'),
('Garyp', '', NULL, 'garyp-', '53.16500000', '5.97100000'),
('Gassel', 'NB', 331, 'gassel-331', '51.73950000', '5.77930000'),
('Gasselte', 'DR', 326, 'gasselte-326', '52.97510000', '6.78940000'),
('Gasselternijveen', 'DR', 326, 'gasselternijveen-326', '52.98730000', '6.85050000'),
('Gasselternijveenschemond', 'DR', 326, 'gasselternijveenschemond-326', '52.99720000', '6.90690000'),
('Gastel', 'NB', 331, 'gastel-331', '51.28560000', '5.55440000'),
('Gasteren', 'DR', 326, 'gasteren-326', '53.03630000', '6.66400000'),
('Gauw', '', NULL, 'gauw-', '53.05840000', '5.71410000'),
('Geelbroek', 'DR', 326, 'geelbroek-326', '52.95120000', '6.57200000'),
('Geerdijk', 'OV', 333, 'geerdijk-333', '52.47740000', '6.56740000'),
('Geersdijk', 'ZE', 335, 'geersdijk-335', '51.56590000', '3.77080000'),
('Geertruidenberg', 'NB', 331, 'geertruidenberg-331', '51.70180000', '4.85440000'),
('Geervliet', 'ZH', 336, 'geervliet-336', '51.86100000', '4.26190000'),
('Gees', 'DR', 326, 'gees-326', '52.74850000', '6.68920000'),
('Geesbrug', 'DR', 326, 'geesbrug-326', '52.72900000', '6.62780000'),
('Geesteren', 'GE', 328, 'geesteren-328', '52.13900000', '6.52190000'),
('Geesteren', 'OV', 333, 'geesteren-333', '52.42210000', '6.73050000'),
('Geeuwenbrug', 'DR', 326, 'geeuwenbrug-326', '52.87370000', '6.36690000'),
('Geffen', 'NB', 331, 'geffen-331', '51.73970000', '5.46600000'),
('Geijsteren', 'LI', 330, 'geijsteren-330', '51.55060000', '6.04850000'),
('Geldermalsen', 'GE', 328, 'geldermalsen-328', '51.88110000', '5.29440000'),
('Gelderswoude', 'ZH', 336, 'gelderswoude-336', '52.09080000', '4.53000000'),
('Geldrop', 'NB', 331, 'geldrop-331', '51.40900000', '5.55110000'),
('Geleen', 'LI', 330, 'geleen-330', '50.96760000', '5.82350000'),
('Gellicum', 'GE', 328, 'gellicum-328', '51.87580000', '5.15350000'),
('Gelselaar', 'GE', 328, 'gelselaar-328', '52.17000000', '6.52600000'),
('Gemert', 'NB', 331, 'gemert-331', '51.55670000', '5.68950000'),
('Gemonde', 'NB', 331, 'gemonde-331', '51.62690000', '5.36850000'),
('Genderen', 'NB', 331, 'genderen-331', '51.73620000', '5.08620000'),
('Gendringen', 'GE', 328, 'gendringen-328', '51.87270000', '6.37500000'),
('Gendt', 'GE', 328, 'gendt-328', '51.87840000', '5.96780000'),
('Genemuiden', 'OV', 333, 'genemuiden-333', '52.62070000', '6.03990000'),
('Gennep', 'LI', 330, 'gennep-330', '51.69540000', '5.97710000'),
('Gerkesklooster', '', NULL, 'gerkesklooster-', '53.24070000', '6.20600000'),
('Gersloot', '', NULL, 'gersloot-', '53.01710000', '5.96360000'),
('Geulle', 'LI', 330, 'geulle-330', '50.92250000', '5.75020000'),
('Giesbeek', 'GE', 328, 'giesbeek-328', '51.99400000', '6.06770000'),
('Giessen', 'NB', 331, 'giessen-331', '51.78730000', '5.03180000'),
('Giessenburg', 'ZH', 336, 'giessenburg-336', '51.84920000', '4.88520000'),
('Gieten', 'DR', 326, 'gieten-326', '53.00270000', '6.76670000'),
('Gieterveen', 'DR', 326, 'gieterveen-326', '53.02520000', '6.83800000'),
('Giethmen', 'OV', 333, 'giethmen-333', '52.49060000', '6.38950000'),
('Giethoorn', 'OV', 333, 'giethoorn-333', '52.72910000', '6.07600000'),
('Gilze', 'NB', 331, 'gilze-331', '51.54350000', '4.93910000'),
('Ginnum', '', NULL, 'ginnum-', '53.32400000', '5.87450000'),
('Glane', 'OV', 333, 'glane-333', '52.23070000', '6.99400000'),
('Glimmen', 'GR', 329, 'glimmen-329', '53.13980000', '6.62980000'),
('Godlinze', 'GR', 329, 'godlinze-329', '53.37260000', '6.81380000'),
('Goedereede', 'ZH', 336, 'goedereede-336', '51.82090000', '3.98330000'),
('Goënga', '', NULL, 'goenga-', '53.05420000', '5.69530000'),
('Goëngahuizen', '', NULL, 'goengahuizen-', '53.08760000', '5.90080000'),
('Goes', 'ZE', 335, 'goes-335', '51.50380000', '3.89210000'),
('Goingarijp', '', NULL, 'goingarijp-', '53.01190000', '5.77240000'),
('Goirle', 'NB', 331, 'goirle-331', '51.52220000', '5.06390000'),
('Goor', 'OV', 333, 'goor-333', '52.23630000', '6.58360000'),
('Gorinchem', 'ZH', 336, 'gorinchem-336', '51.83010000', '4.97500000'),
('Gorredijk', '', NULL, 'gorredijk-', '53.00450000', '6.06800000'),
('Gorssel', 'GE', 328, 'gorssel-328', '52.20090000', '6.20320000'),
('Gouda', 'ZH', 336, 'gouda-336', '52.01180000', '4.70800000'),
('Gouderak', 'ZH', 336, 'gouderak-336', '51.98520000', '4.67850000'),
('Goudriaan', 'ZH', 336, 'goudriaan-336', '51.90360000', '4.89760000'),
('Goudswaard', 'ZH', 336, 'goudswaard-336', '51.78870000', '4.28210000'),
('Goutum', '', NULL, 'goutum-', '53.17860000', '5.80420000'),
('Graauw', 'ZE', 335, 'graauw-335', '51.32940000', '4.10230000'),
('Grafhorst', 'OV', 333, 'grafhorst-333', '52.58350000', '5.93500000'),
('Graft', 'NH', 332, 'graft-332', '52.56080000', '4.83420000'),
('Gramsbergen', 'OV', 333, 'gramsbergen-333', '52.60770000', '6.67210000'),
('Grashoek', 'LI', 330, 'grashoek-330', '51.36210000', '5.94030000');
INSERT INTO `cities` (`city_name`, `state`, `state_id`, `slug`, `lat`, `lng`) VALUES
('Grathem', 'LI', 330, 'grathem-330', '51.19490000', '5.85790000'),
('Grave', 'NB', 331, 'grave-331', '51.75570000', '5.73850000'),
('Greonterp', '', NULL, 'greonterp-', '53.01430000', '5.51850000'),
('Grevenbicht', 'LI', 330, 'grevenbicht-330', '51.04010000', '5.77380000'),
('Griendtsveen', 'LI', 330, 'griendtsveen-330', '51.44340000', '5.88450000'),
('Grijpskerk', 'GR', 329, 'grijpskerk-329', '53.26210000', '6.30620000'),
('Grijpskerke', 'ZE', 335, 'grijpskerke-335', '51.53290000', '3.56250000'),
('Groede', 'ZE', 335, 'groede-335', '51.37960000', '3.50850000'),
('Groenekan', 'UT', 334, 'groenekan-334', '52.12600000', '5.15500000'),
('Groeningen', 'NB', 331, 'groeningen-331', '51.60480000', '5.99940000'),
('Groenlo', 'GE', 328, 'groenlo-328', '52.04120000', '6.61160000'),
('Groesbeek', 'GE', 328, 'groesbeek-328', '51.78380000', '5.92930000'),
('Groessen', 'GE', 328, 'groessen-328', '51.92990000', '6.02590000'),
('Groet', 'NH', 332, 'groet-332', '52.72230000', '4.66780000'),
('Grolloo', 'DR', 326, 'grolloo-326', '52.93430000', '6.67160000'),
('Groningen', 'GR', 329, 'groningen-329', '53.21660000', '6.56950000'),
('Gronsveld', 'LI', 330, 'gronsveld-330', '50.80730000', '5.72950000'),
('Groot-Ammers', 'ZH', 336, 'groot-ammers-336', '51.92520000', '4.82960000'),
('Grootebroek', 'NH', 332, 'grootebroek-332', '52.69420000', '5.22470000'),
('Grootegast', 'GR', 329, 'grootegast-329', '53.21220000', '6.27480000'),
('Grootschermer', 'NH', 332, 'grootschermer-332', '52.58250000', '4.84750000'),
('Grou', '', NULL, 'grou-', '53.09300000', '5.83730000'),
('Grubbenvorst', 'LI', 330, 'grubbenvorst-330', '51.41980000', '6.14060000'),
('Gulpen', 'LI', 330, 'gulpen-330', '50.81370000', '5.88810000'),
('Guttecoven', 'LI', 330, 'guttecoven-330', '51.01430000', '5.81890000'),
('Gytsjerk', '', NULL, 'gytsjerk-', '53.24130000', '5.89030000'),
('Haaften', 'GE', 328, 'haaften-328', '51.81850000', '5.21150000'),
('Haaksbergen', 'OV', 333, 'haaksbergen-333', '52.15350000', '6.75280000'),
('Haalderen', 'GE', 328, 'haalderen-328', '51.88750000', '5.92910000'),
('Haaren', 'NB', 331, 'haaren-331', '51.60330000', '5.22670000'),
('Haarle', 'OV', 333, 'haarle-333', '52.36370000', '6.38540000'),
('Haarlem', 'NH', 332, 'haarlem-332', '52.38120000', '4.63610000'),
('Haarlemmerliede', 'NH', 332, 'haarlemmerliede-332', '52.38870000', '4.68470000'),
('Haarlo', 'GE', 328, 'haarlo-328', '52.11040000', '6.57690000'),
('Haarsteeg', 'NB', 331, 'haarsteeg-331', '51.71020000', '5.19740000'),
('Haarzuilens', 'UT', 334, 'haarzuilens-334', '52.11580000', '4.98450000'),
('Haastrecht', 'ZH', 336, 'haastrecht-336', '51.99170000', '4.74990000'),
('Haelen', 'LI', 330, 'haelen-330', '51.23410000', '5.95470000'),
('Hagestein', 'UT', 334, 'hagestein-334', '51.97980000', '5.12540000'),
('Haghorst', 'NB', 331, 'haghorst-331', '51.49700000', '5.20780000'),
('Haler', 'LI', 330, 'haler-330', '51.18920000', '5.78040000'),
('Halfweg', 'NH', 332, 'halfweg-332', '52.38460000', '4.75050000'),
('Hall', 'GE', 328, 'hall-328', '52.10970000', '6.09700000'),
('Halle', 'GE', 328, 'halle-328', '51.99590000', '6.42680000'),
('Hallum', '', NULL, 'hallum-', '53.30510000', '5.78420000'),
('Halsteren', 'NB', 331, 'halsteren-331', '51.52790000', '4.27730000'),
('Handel', 'NB', 331, 'handel-331', '51.57930000', '5.71430000'),
('Hank', 'NB', 331, 'hank-331', '51.73440000', '4.89570000'),
('Hansweert', 'ZE', 335, 'hansweert-335', '51.45010000', '4.00350000'),
('Hantum', '', NULL, 'hantum-', '53.36270000', '5.96580000'),
('Hantumeruitburen', '', NULL, 'hantumeruitburen-', '53.35800000', '6.00560000'),
('Hantumhuizen', '', NULL, 'hantumhuizen-', '53.37090000', '5.99430000'),
('Hapert', 'NB', 331, 'hapert-331', '51.36380000', '5.25560000'),
('Haps', 'NB', 331, 'haps-331', '51.71120000', '5.85090000'),
('Harbrinkhoek', 'OV', 333, 'harbrinkhoek-333', '52.38430000', '6.71800000'),
('Hardenberg', 'OV', 333, 'hardenberg-333', '52.56900000', '6.60500000'),
('Harderwijk', 'GE', 328, 'harderwijk-328', '52.34950000', '5.62250000'),
('Hardinxveld-Giessendam', 'ZH', 336, 'hardinxveld-giessendam-336', '51.82590000', '4.83280000'),
('Haren', 'NB', 331, 'haren-331', '51.80160000', '5.58360000'),
('Haren Gn', 'GR', 329, 'haren-gn-329', '53.17330000', '6.61120000'),
('Harfsen', 'GE', 328, 'harfsen-328', '52.19980000', '6.29170000'),
('Harich', '', NULL, 'harich-', '52.89580000', '5.55280000'),
('Haringhuizen', 'NH', 332, 'haringhuizen-332', '52.77130000', '4.82930000'),
('Harkema', '', NULL, 'harkema-', '53.18560000', '6.13470000'),
('Harkstede', 'GR', 329, 'harkstede-329', '53.21200000', '6.69870000'),
('Harkstede GN', 'GR', 329, 'harkstede-gn-329', '53.21560000', '6.66560000'),
('Harlingen', '', NULL, 'harlingen-', '53.17520000', '5.42630000'),
('Harmelen', 'UT', 334, 'harmelen-334', '52.09080000', '4.96000000'),
('Harreveld', 'GE', 328, 'harreveld-328', '51.97900000', '6.51430000'),
('Harskamp', 'GE', 328, 'harskamp-328', '52.13070000', '5.74850000'),
('Hartwerd', '', NULL, 'hartwerd-', '53.06970000', '5.57020000'),
('Haskerdijken', '', NULL, 'haskerdijken-', '52.99870000', '5.87670000'),
('Haskerhorne', '', NULL, 'haskerhorne-', '52.95330000', '5.82940000'),
('Hasselt', 'OV', 333, 'hasselt-333', '52.59100000', '6.09960000'),
('Hattem', 'GE', 328, 'hattem-328', '52.47240000', '6.06080000'),
('Hattemerbroek', 'GE', 328, 'hattemerbroek-328', '52.47290000', '6.02010000'),
('Haule', '', NULL, 'haule-', '53.03860000', '6.30850000'),
('Haulerwijk', '', NULL, 'haulerwijk-', '53.06530000', '6.33430000'),
('Hauwert', 'NH', 332, 'hauwert-332', '52.70680000', '5.09890000'),
('Havelte', 'DR', 326, 'havelte-326', '52.77410000', '6.23710000'),
('Havelterberg', 'DR', 326, 'havelterberg-326', '52.77470000', '6.18410000'),
('Hazerswoude-Dorp', 'ZH', 336, 'hazerswoude-dorp-336', '52.09470000', '4.59330000'),
('Hazerswoude-Rijndijk', 'ZH', 336, 'hazerswoude-rijndijk-336', '52.12830000', '4.58910000'),
('Hedel', 'GE', 328, 'hedel-328', '51.74830000', '5.25960000'),
('Hedikhuizen', 'NB', 331, 'hedikhuizen-331', '51.73250000', '5.18700000'),
('Hee', '', NULL, 'hee-', '53.37780000', '5.25500000'),
('Heeg', '', NULL, 'heeg-', '52.97050000', '5.60980000'),
('Heel', 'LI', 330, 'heel-330', '51.18220000', '5.89140000'),
('Heelsum', 'GE', 328, 'heelsum-328', '51.98150000', '5.75250000'),
('Heelweg', 'GE', 328, 'heelweg-328', '51.96270000', '6.47910000'),
('Heemserveen', 'OV', 333, 'heemserveen-333', '52.58110000', '6.57410000'),
('Heemskerk', 'NH', 332, 'heemskerk-332', '52.51120000', '4.67070000'),
('Heemstede', 'NH', 332, 'heemstede-332', '52.35240000', '4.61920000'),
('Heenvliet', 'ZH', 336, 'heenvliet-336', '51.86530000', '4.24010000'),
('Heerde', 'GE', 328, 'heerde-328', '52.38880000', '6.03850000'),
('Heerenveen', '', NULL, 'heerenveen-', '52.96500000', '5.91790000'),
('Heerewaarden', 'GE', 328, 'heerewaarden-328', '51.81750000', '5.39280000'),
('Heerhugowaard', 'NH', 332, 'heerhugowaard-332', '52.67330000', '4.85040000'),
('Heerjansdam', 'ZH', 336, 'heerjansdam-336', '51.83480000', '4.56610000'),
('Heerle', 'NB', 331, 'heerle-331', '51.51700000', '4.37650000'),
('Heerlen', 'LI', 330, 'heerlen-330', '50.88750000', '5.97500000'),
('Heesbeen', 'NB', 331, 'heesbeen-331', '51.73230000', '5.12210000'),
('Heesch', 'NB', 331, 'heesch-331', '51.73090000', '5.52790000'),
('Heesselt', 'GE', 328, 'heesselt-328', '51.81570000', '5.35120000'),
('Heeswijk-Dinther', 'NB', 331, 'heeswijk-dinther-331', '51.66950000', '5.47600000'),
('Heeten', 'OV', 333, 'heeten-333', '52.33010000', '6.27940000'),
('Heeze', 'NB', 331, 'heeze-331', '51.38160000', '5.57220000'),
('Hegebeintum', '', NULL, 'hegebeintum-', '53.33340000', '5.85300000'),
('Hegelsom', 'LI', 330, 'hegelsom-330', '51.43710000', '6.03900000'),
('Hei- en Boeicop', 'ZH', 336, 'hei-en-boeicop-336', '51.94510000', '5.07490000'),
('Heibloem', 'LI', 330, 'heibloem-330', '51.29910000', '5.89750000'),
('Heide', 'LI', 330, 'heide-330', '51.50530000', '5.94750000'),
('Heijen', 'LI', 330, 'heijen-330', '51.67290000', '5.99110000'),
('Heijenrath', 'LI', 330, 'heijenrath-330', '50.77540000', '5.87570000'),
('Heijningen', 'NB', 331, 'heijningen-331', '51.65180000', '4.37870000'),
('Heikant', 'ZE', 335, 'heikant-335', '51.24980000', '4.02390000'),
('Heilig Landstichting', 'GE', 328, 'heilig-landstichting-328', '51.81760000', '5.88520000'),
('Heiligerlee', 'GR', 329, 'heiligerlee-329', '53.15670000', '7.01060000'),
('Heiloo', 'NH', 332, 'heiloo-332', '52.59780000', '4.71070000'),
('Heinenoord', 'ZH', 336, 'heinenoord-336', '51.81630000', '4.46210000'),
('Heinkenszand', 'ZE', 335, 'heinkenszand-335', '51.47350000', '3.81180000'),
('Heino', 'OV', 333, 'heino-333', '52.43790000', '6.23580000'),
('Hekelingen', 'ZH', 336, 'hekelingen-336', '51.82650000', '4.36480000'),
('Hekendorp', 'UT', 334, 'hekendorp-334', '52.01670000', '4.81730000'),
('Helden', 'LI', 330, 'helden-330', '51.32200000', '5.99850000'),
('Helenaveen', 'NB', 331, 'helenaveen-331', '51.39110000', '5.91380000'),
('Hellendoorn', 'OV', 333, 'hellendoorn-333', '52.39770000', '6.44960000'),
('Hellevoetsluis', 'ZH', 336, 'hellevoetsluis-336', '51.83100000', '4.12490000'),
('Hellouw', 'GE', 328, 'hellouw-328', '51.82760000', '5.17710000'),
('Hellum', 'GR', 329, 'hellum-329', '53.24030000', '6.83950000'),
('Helmond', 'NB', 331, 'helmond-331', '51.48110000', '5.66460000'),
('Helvoirt', 'NB', 331, 'helvoirt-331', '51.63410000', '5.22670000'),
('Hem', 'NH', 332, 'hem-332', '52.66010000', '5.18640000'),
('Hemelum', '', NULL, 'hemelum-', '52.88100000', '5.45930000'),
('Hemmen', 'GE', 328, 'hemmen-328', '51.93290000', '5.69880000'),
('Hempens', '', NULL, 'hempens-', '53.17730000', '5.83880000'),
('Hemrik', '', NULL, 'hemrik-', '53.03320000', '6.14020000'),
('Hendrik-Ido-Ambacht', 'ZH', 336, 'hendrik-ido-ambacht-336', '51.84620000', '4.64650000'),
('Hengelo ', 'GE', 328, 'hengelo-gld-328', '52.05150000', '6.31790000'),
('Hengelo', 'OV', 333, 'hengelo-333', '52.26580000', '6.79230000'),
('Hengevelde', 'OV', 333, 'hengevelde-333', '52.20010000', '6.63660000'),
('Hengstdijk', 'ZE', 335, 'hengstdijk-335', '51.34130000', '3.99600000'),
('Hensbroek', 'NH', 332, 'hensbroek-332', '52.65710000', '4.88210000'),
('Herbaijum', '', NULL, 'herbaijum-', '53.18530000', '5.49540000'),
('Herkenbosch', 'LI', 330, 'herkenbosch-330', '51.15570000', '6.06900000'),
('Herkingen', 'ZH', 336, 'herkingen-336', '51.71820000', '4.08540000'),
('Hernen', 'GE', 328, 'hernen-328', '51.83320000', '5.68140000'),
('Herpen', 'NB', 331, 'herpen-331', '51.76090000', '5.58880000'),
('Herpt', 'NB', 331, 'herpt-331', '51.72950000', '5.15680000'),
('Herten', 'LI', 330, 'herten-330', '51.16910000', '5.96010000'),
('Hertme', 'OV', 333, 'hertme-333', '52.31890000', '6.76380000'),
('Herveld', 'GE', 328, 'herveld-328', '51.90850000', '5.74060000'),
('Herwen', 'GE', 328, 'herwen-328', '51.88300000', '6.10220000'),
('Herwijnen', 'GE', 328, 'herwijnen-328', '51.82690000', '5.13160000'),
('Heteren', 'GE', 328, 'heteren-328', '51.95570000', '5.75470000'),
('Heukelom', 'NB', 331, 'heukelom-331', '51.57400000', '5.15600000'),
('Heukelum', 'GE', 328, 'heukelum-328', '51.87080000', '5.07270000'),
('Heumen', 'GE', 328, 'heumen-328', '51.76730000', '5.84310000'),
('Heusden', 'NB', 331, 'heusden-331', '51.38020000', '5.76840000'),
('Heveadorp', 'GE', 328, 'heveadorp-328', '51.97460000', '5.81120000'),
('Heythuysen', 'LI', 330, 'heythuysen-330', '51.25140000', '5.89320000'),
('Hezingen', 'OV', 333, 'hezingen-333', '52.43820000', '6.88110000'),
('Hiaure', '', NULL, 'hiaure-', '53.34880000', '5.97260000'),
('Hichtum', '', NULL, 'hichtum-', '53.08200000', '5.52400000'),
('Hidaard', '', NULL, 'hidaard-', '53.07780000', '5.60290000'),
('Hierden', 'GE', 328, 'hierden-328', '52.35300000', '5.67880000'),
('Hieslum', '', NULL, 'hieslum-', '53.00590000', '5.48920000'),
('Hijken', 'DR', 326, 'hijken-326', '52.89560000', '6.49050000'),
('Hijum', '', NULL, 'hijum-', '53.29060000', '5.76600000'),
('Hilaard', '', NULL, 'hilaard-', '53.16620000', '5.70650000'),
('Hillegom', 'ZH', 336, 'hillegom-336', '52.29530000', '4.58700000'),
('Hilvarenbeek', 'NB', 331, 'hilvarenbeek-331', '51.49030000', '5.13460000'),
('Hilversum', 'NH', 332, 'hilversum-332', '52.22350000', '5.17520000'),
('Hindeloopen', '', NULL, 'hindeloopen-', '52.94120000', '5.40280000'),
('Hinnaard', '', NULL, 'hinnaard-', '53.11590000', '5.63270000'),
('Hippolytushoef', 'NH', 332, 'hippolytushoef-332', '52.90890000', '4.96440000'),
('Hitzum', '', NULL, 'hitzum-', '53.16560000', '5.51790000'),
('Hobrede', 'NH', 332, 'hobrede-332', '52.54580000', '4.97940000'),
('Hoedekenskerke', 'ZE', 335, 'hoedekenskerke-335', '51.42590000', '3.91100000'),
('Hoef en Haag', 'UT', 334, 'hoef-en-haag-334', '51.98690000', '5.11980000'),
('Hoek', 'ZE', 335, 'hoek-335', '51.31190000', '3.77760000'),
('Hoek van Holland', 'ZH', 336, 'hoek-van-holland-336', '51.98150000', '4.13340000'),
('Hoenderloo', 'GE', 328, 'hoenderloo-328', '52.12240000', '5.89680000'),
('Hoensbroek', 'LI', 330, 'hoensbroek-330', '50.92570000', '5.93060000'),
('Hoenzadriel', 'GE', 328, 'hoenzadriel-328', '51.75620000', '5.33100000'),
('Hoevelaken', 'GE', 328, 'hoevelaken-328', '52.17480000', '5.46050000'),
('Hoeven', 'NB', 331, 'hoeven-331', '51.59730000', '4.54840000'),
('Hoge Hexel', 'OV', 333, 'hoge-hexel-333', '52.38190000', '6.58150000'),
('Hollandsche Rading', 'UT', 334, 'hollandsche-rading-334', '52.17540000', '5.17510000'),
('Hollandscheveld', 'DR', 326, 'hollandscheveld-326', '52.70290000', '6.54070000'),
('Hollum', '', NULL, 'hollum-', '53.44370000', '5.63860000'),
('Holsloot', 'DR', 326, 'holsloot-326', '52.72250000', '6.80540000'),
('Holten', 'OV', 333, 'holten-333', '52.28050000', '6.42120000'),
('Holthees', 'NB', 331, 'holthees-331', '51.57490000', '6.00670000'),
('Holtheme', 'OV', 333, 'holtheme-333', '52.61270000', '6.70560000'),
('Holthone', 'OV', 333, 'holthone-333', '52.63750000', '6.68300000'),
('Holtum', 'LI', 330, 'holtum-330', '51.04770000', '5.82130000'),
('Holwerd', '', NULL, 'holwerd-', '53.36830000', '5.90300000'),
('Holwierde', 'GR', 329, 'holwierde-329', '53.35850000', '6.87380000'),
('Hommerts', '', NULL, 'hommerts-', '52.97900000', '5.64980000'),
('Homoet', 'GE', 328, 'homoet-328', '51.93450000', '5.78760000'),
('Honselersdijk', 'ZH', 336, 'honselersdijk-336', '52.00770000', '4.23110000'),
('Hoofddorp', 'NH', 332, 'hoofddorp-332', '52.30790000', '4.68420000'),
('Hoofdplaat', 'ZE', 335, 'hoofdplaat-335', '51.37160000', '3.65090000'),
('Hoog Soeren', 'GE', 328, 'hoog-soeren-328', '52.21820000', '5.87080000'),
('Hoog-Keppel', 'GE', 328, 'hoog-keppel-328', '52.00480000', '6.20280000'),
('Hoogblokland', 'ZH', 336, 'hoogblokland-336', '51.87740000', '4.97680000'),
('Hooge Mierde', 'NB', 331, 'hooge-mierde-331', '51.38750000', '5.12640000'),
('Hooge Zwaluwe', 'NB', 331, 'hooge-zwaluwe-331', '51.68380000', '4.74720000'),
('Hoogeloon', 'NB', 331, 'hoogeloon-331', '51.39660000', '5.27070000'),
('Hoogenweg', 'OV', 333, 'hoogenweg-333', '52.56750000', '6.65940000'),
('Hoogerheide', 'NB', 331, 'hoogerheide-331', '51.42720000', '4.32780000'),
('Hoogersmilde', 'DR', 326, 'hoogersmilde-326', '52.90980000', '6.36850000'),
('Hoogeveen', 'DR', 326, 'hoogeveen-326', '52.72620000', '6.47340000'),
('Hoogezand', 'GR', 329, 'hoogezand-329', '53.16430000', '6.75900000'),
('Hooghalen', 'DR', 326, 'hooghalen-326', '52.92150000', '6.54110000'),
('Hoogkarspel', 'NH', 332, 'hoogkarspel-332', '52.69450000', '5.17800000'),
('Hoogland', 'UT', 334, 'hoogland-334', '52.18640000', '5.37510000'),
('Hooglanderveen', 'UT', 334, 'hooglanderveen-334', '52.18350000', '5.43270000'),
('Hoogmade', 'ZH', 336, 'hoogmade-336', '52.16970000', '4.58150000'),
('Hoogvliet Rotterdam', 'ZH', 336, 'hoogvliet-rotterdam-336', '51.86140000', '4.36620000'),
('Hoogwoud', 'NH', 332, 'hoogwoud-332', '52.71690000', '4.93810000'),
('Hoorn', '', NULL, 'hoorn-', '53.39720000', '5.34230000'),
('Hoorn', 'NH', 332, 'hoorn-332', '52.64040000', '5.05980000'),
('Hoornaar', 'ZH', 336, 'hoornaar-336', '51.87760000', '4.94530000'),
('Hoornsterzwaag', '', NULL, 'hoornsterzwaag-', '53.00370000', '6.16310000'),
('Horn', 'LI', 330, 'horn-330', '51.21140000', '5.94250000'),
('Hornhuizen', 'GR', 329, 'hornhuizen-329', '53.38700000', '6.35350000'),
('Horssen', 'GE', 328, 'horssen-328', '51.85510000', '5.61050000'),
('Horst', 'LI', 330, 'horst-330', '51.45440000', '6.05240000'),
('Houten', 'UT', 334, 'houten-334', '52.02200000', '5.16520000'),
('Houtigehage', '', NULL, 'houtigehage-', '53.15170000', '6.14260000'),
('Houwerzijl', 'GR', 329, 'houwerzijl-329', '53.33650000', '6.34080000'),
('Huijbergen', 'NB', 331, 'huijbergen-331', '51.43210000', '4.37580000'),
('Huis ter Heide', 'DR', 326, 'huis-ter-heide-326', '53.01720000', '6.48010000'),
('Huis ter Heide', 'UT', 334, 'huis-ter-heide-334', '52.11170000', '5.25240000'),
('Huisduinen', 'NH', 332, 'huisduinen-332', '52.95280000', '4.72750000'),
('Huisseling', 'NB', 331, 'huisseling-331', '51.78770000', '5.64110000'),
('Huissen', 'GE', 328, 'huissen-328', '51.93190000', '5.93530000'),
('Huizen', 'NH', 332, 'huizen-332', '52.29960000', '5.23800000'),
('Huizinge', 'GR', 329, 'huizinge-329', '53.34660000', '6.67470000'),
('Hulsberg', 'LI', 330, 'hulsberg-330', '50.88970000', '5.85380000'),
('Hulsel', 'NB', 331, 'hulsel-331', '51.38900000', '5.17880000'),
('Hulshorst', 'GE', 328, 'hulshorst-328', '52.36590000', '5.72430000'),
('Hulst', 'ZE', 335, 'hulst-335', '51.28450000', '4.05380000'),
('Hulten', 'NB', 331, 'hulten-331', '51.57520000', '4.95690000'),
('Hummelo', 'GE', 328, 'hummelo-328', '52.00430000', '6.23860000'),
('Húns', '', NULL, 'huns-', '53.16070000', '5.66680000'),
('Hunsel', 'LI', 330, 'hunsel-330', '51.19010000', '5.81130000'),
('Hurdegaryp', '', NULL, 'hurdegaryp-', '53.21520000', '5.94220000'),
('Hurwenen', 'GE', 328, 'hurwenen-328', '51.80990000', '5.31540000'),
('Idaerd', '', NULL, 'idaerd-', '53.11970000', '5.81210000'),
('Idsegahuizum', '', NULL, 'idsegahuizum-', '53.04420000', '5.41890000'),
('Idskenhuizen', '', NULL, 'idskenhuizen-', '52.92880000', '5.71250000'),
('Idzega', '', NULL, 'idzega-', '52.97970000', '5.55430000'),
('Iens', '', NULL, 'iens-', '53.12560000', '5.61330000'),
('IJhorst', 'OV', 333, 'ijhorst-333', '52.65740000', '6.29790000'),
('IJlst', '', NULL, 'ijlst-', '53.01060000', '5.62200000'),
('IJmuiden', 'NH', 332, 'ijmuiden-332', '52.45790000', '4.62490000'),
('IJsselham', 'OV', 333, 'ijsselham-333', '52.81090000', '5.96010000'),
('IJsselmuiden', 'OV', 333, 'ijsselmuiden-333', '52.56580000', '5.93670000'),
('IJsselstein', 'UT', 334, 'ijsselstein-334', '52.02140000', '5.04000000'),
('IJzendijke', 'ZE', 335, 'ijzendijke-335', '51.32120000', '3.61710000'),
('IJzendoorn', 'GE', 328, 'ijzendoorn-328', '51.90840000', '5.53340000'),
('Ilpendam', 'NH', 332, 'ilpendam-332', '52.46550000', '4.95320000'),
('Indijk', '', NULL, 'indijk-', '52.96020000', '5.62910000'),
('Ingber', 'LI', 330, 'ingber-330', '50.81760000', '5.85960000'),
('Ingelum', '', NULL, 'ingelum-', '53.22620000', '5.71680000'),
('Ingen', 'GE', 328, 'ingen-328', '51.96220000', '5.48570000'),
('It Heidenskip', '', NULL, 'it-heidenskip-', '52.95230000', '5.49210000'),
('Itens', '', NULL, 'itens-', '53.10090000', '5.64490000'),
('Ittervoort', 'LI', 330, 'ittervoort-330', '51.17230000', '5.82170000'),
('Jaarsveld', 'UT', 334, 'jaarsveld-334', '51.96960000', '4.97600000'),
('Jabeek', 'LI', 330, 'jabeek-330', '50.98000000', '5.94110000'),
('Jannum', '', NULL, 'jannum-', '53.31310000', '5.91280000'),
('Jellum', '', NULL, 'jellum-', '53.16540000', '5.74120000'),
('Jelsum', '', NULL, 'jelsum-', '53.23320000', '5.78470000'),
('Jirnsum', '', NULL, 'jirnsum-', '53.07820000', '5.79260000'),
('Jislum', '', NULL, 'jislum-', '53.30920000', '5.87450000'),
('Jisp', 'NH', 332, 'jisp-332', '52.50730000', '4.85170000'),
('Jistrum', '', NULL, 'jistrum-', '53.21250000', '6.06450000'),
('Jonkerslân', '', NULL, 'jonkerslan-', '52.97780000', '6.03900000'),
('Jonkersvaart', 'GR', 329, 'jonkersvaart-329', '53.13070000', '6.31050000'),
('Joppe', 'GE', 328, 'joppe-328', '52.20630000', '6.23650000'),
('Jorwert', '', NULL, 'jorwert-', '53.14520000', '5.71190000'),
('Joure', '', NULL, 'joure-', '52.96460000', '5.80050000'),
('Jouswier', '', NULL, 'jouswier-', '53.34760000', '6.07530000'),
('Jubbega', '', NULL, 'jubbega-', '52.99510000', '6.12180000'),
('Julianadorp', 'NH', 332, 'julianadorp-332', '52.89670000', '4.73600000'),
('Jutrijp', '', NULL, 'jutrijp-', '52.99590000', '5.64880000'),
('Kaag', 'ZH', 336, 'kaag-336', '52.21320000', '4.56080000'),
('Kaard', '', NULL, 'kaard-', '53.37680000', '5.26920000'),
('Kaatsheuvel', 'NB', 331, 'kaatsheuvel-331', '51.65810000', '5.03270000'),
('Kalenberg', 'OV', 333, 'kalenberg-333', '52.77840000', '5.95700000'),
('Kallenkote', 'OV', 333, 'kallenkote-333', '52.79440000', '6.16880000'),
('Kamerik', 'UT', 334, 'kamerik-334', '52.11610000', '4.89390000'),
('Kampen', 'OV', 333, 'kampen-333', '52.55700000', '5.91670000'),
('Kamperland', 'ZE', 335, 'kamperland-335', '51.57730000', '3.69050000'),
('Kamperveen', 'OV', 333, 'kamperveen-333', '52.51940000', '5.86760000'),
('Kantens', 'GR', 329, 'kantens-329', '53.36520000', '6.63370000'),
('Kapel Avezaath', 'GE', 328, 'kapel-avezaath-328', '51.88310000', '5.38050000'),
('Kapel-Avezaath', 'GE', 328, 'kapel-avezaath-328', '51.88520000', '5.35690000'),
('Kapelle', 'ZE', 335, 'kapelle-335', '51.48290000', '3.96080000'),
('Kapellebrug', 'ZE', 335, 'kapellebrug-335', '51.25390000', '4.06370000'),
('Katlijk', '', NULL, 'katlijk-', '52.94600000', '6.01950000'),
('Kats', 'ZE', 335, 'kats-335', '51.56800000', '3.88190000'),
('Kattendijke', 'ZE', 335, 'kattendijke-335', '51.52140000', '3.94420000'),
('Katwijk', 'ZH', 336, 'katwijk-336', '52.20880000', '4.42010000'),
('Katwijk NB', 'NB', 331, 'katwijk-nb-331', '51.74280000', '5.87620000'),
('Katwoude', 'NH', 332, 'katwoude-332', '52.47340000', '5.03990000'),
('Kedichem', 'ZH', 336, 'kedichem-336', '51.86290000', '5.04840000'),
('Keent', 'NB', 331, 'keent-331', '51.77250000', '5.69370000'),
('Keijenborg', 'GE', 328, 'keijenborg-328', '52.03010000', '6.29530000'),
('Kekerdom', 'GE', 328, 'kekerdom-328', '51.86320000', '6.01040000'),
('Kelpen-Oler', 'LI', 330, 'kelpen-oler-330', '51.22150000', '5.82590000'),
('Kerk Avezaath', 'GE', 328, 'kerk-avezaath-328', '51.88700000', '5.39640000'),
('Kerk-Avezaath', 'GE', 328, 'kerk-avezaath-328', '51.89880000', '5.37960000'),
('Kerkdriel', 'GE', 328, 'kerkdriel-328', '51.77160000', '5.33320000'),
('Kerkenveld', 'DR', 326, 'kerkenveld-326', '52.66580000', '6.50010000'),
('Kerkrade', 'LI', 330, 'kerkrade-330', '50.86420000', '6.06790000'),
('Kerkwerve', 'ZE', 335, 'kerkwerve-335', '51.68730000', '3.89090000'),
('Kerkwijk', 'GE', 328, 'kerkwijk-328', '51.77530000', '5.21770000'),
('Kessel', 'LI', 330, 'kessel-330', '51.29200000', '6.04760000'),
('Kesteren', 'GE', 328, 'kesteren-328', '51.93300000', '5.57110000'),
('Kiel-Windeweer', 'GR', 329, 'kiel-windeweer-329', '53.11430000', '6.77700000'),
('Kilder', 'GE', 328, 'kilder-328', '51.93780000', '6.23380000'),
('Kimswerd', '', NULL, 'kimswerd-', '53.14090000', '5.43550000'),
('Kinderdijk', 'ZH', 336, 'kinderdijk-336', '51.88650000', '4.63230000'),
('Kinnum', '', NULL, 'kinnum-', '53.37500000', '5.27510000'),
('Klaaswaal', 'ZH', 336, 'klaaswaal-336', '51.77070000', '4.44660000'),
('Klarenbeek', 'GE', 328, 'klarenbeek-328', '52.16760000', '6.04530000'),
('Klazienaveen', 'DR', 326, 'klazienaveen-326', '52.72370000', '6.98830000'),
('Klazienaveen-Noord', 'DR', 326, 'klazienaveen-noord-326', '52.76640000', '7.00210000'),
('Klein Zundert', 'NB', 331, 'klein-zundert-331', '51.48390000', '4.65020000'),
('Klijndijk', 'DR', 326, 'klijndijk-326', '52.83180000', '6.85800000'),
('Klimmen', 'LI', 330, 'klimmen-330', '50.87770000', '5.88550000'),
('Kloetinge', 'ZE', 335, 'kloetinge-335', '51.49780000', '3.90790000'),
('Klooster Lidlum', '', NULL, 'klooster-lidlum-', '53.22710000', '5.52620000'),
('Kloosterburen', 'GR', 329, 'kloosterburen-329', '53.38780000', '6.38940000'),
('Kloosterhaar', 'OV', 333, 'kloosterhaar-333', '52.49930000', '6.67230000'),
('Kloosterzande', 'ZE', 335, 'kloosterzande-335', '51.36900000', '4.01780000'),
('Klundert', 'NB', 331, 'klundert-331', '51.66500000', '4.53430000'),
('Knegsel', 'NB', 331, 'knegsel-331', '51.38920000', '5.37300000'),
('Koarnjum', '', NULL, 'koarnjum-', '53.24380000', '5.77920000'),
('Kockengen', 'UT', 334, 'kockengen-334', '52.15070000', '4.95230000'),
('Koedijk', 'NH', 332, 'koedijk-332', '52.67300000', '4.75380000'),
('Koekange', 'DR', 326, 'koekange-326', '52.70340000', '6.32430000'),
('Koewacht', 'ZE', 335, 'koewacht-335', '51.23180000', '3.96570000'),
('Kolderwolde', '', NULL, 'kolderwolde-', '52.89460000', '5.50320000'),
('Kolham', 'GR', 329, 'kolham-329', '53.17920000', '6.74180000'),
('Kolhorn', 'NH', 332, 'kolhorn-332', '52.79320000', '4.89090000'),
('Kollum', '', NULL, 'kollum-', '53.28040000', '6.14910000'),
('Kollumerpomp', '', NULL, 'kollumerpomp-', '53.31320000', '6.18840000'),
('Kollumerzwaag', '', NULL, 'kollumerzwaag-', '53.26160000', '6.08020000'),
('Kommerzijl', 'GR', 329, 'kommerzijl-329', '53.28680000', '6.32110000'),
('Koningsbosch', 'LI', 330, 'koningsbosch-330', '51.05340000', '5.95220000'),
('Koningslust', 'LI', 330, 'koningslust-330', '51.35780000', '5.99450000'),
('Koog aan de Zaan', 'NH', 332, 'koog-aan-de-zaan-332', '52.46060000', '4.80350000'),
('Kootstertille', '', NULL, 'kootstertille-', '53.21560000', '6.09460000'),
('Kootwijk', 'GE', 328, 'kootwijk-328', '52.18720000', '5.78390000'),
('Kootwijkerbroek', 'GE', 328, 'kootwijkerbroek-328', '52.15230000', '5.67200000'),
('Kornhorn', 'GR', 329, 'kornhorn-329', '53.18140000', '6.24420000'),
('Kornwerderzand', '', NULL, 'kornwerderzand-', '53.07270000', '5.33720000'),
('Kortehemmen', '', NULL, 'kortehemmen-', '53.08260000', '6.06740000'),
('Kortenhoef', 'NH', 332, 'kortenhoef-332', '52.23830000', '5.11230000'),
('Kortgene', 'ZE', 335, 'kortgene-335', '51.55710000', '3.80540000'),
('Koudekerk aan den Rijn', 'ZH', 336, 'koudekerk-aan-den-rijn-336', '52.13340000', '4.60200000'),
('Koudekerke', 'ZE', 335, 'koudekerke-335', '51.48500000', '3.56090000'),
('Koudum', '', NULL, 'koudum-', '52.91430000', '5.45010000'),
('Koufurderrige', '', NULL, 'koufurderrige-', '52.95050000', '5.65790000'),
('Krabbendijke', 'ZE', 335, 'krabbendijke-335', '51.43160000', '4.11220000'),
('Kraggenburg', 'FL', 327, 'kraggenburg-327', '52.65980000', '5.90240000'),
('Kreileroord', 'NH', 332, 'kreileroord-332', '52.84170000', '5.08260000'),
('Krewerd', 'GR', 329, 'krewerd-329', '53.35360000', '6.84690000'),
('Krimpen aan de Lek', 'ZH', 336, 'krimpen-aan-de-lek-336', '51.89650000', '4.62620000'),
('Krimpen aan den IJssel', 'ZH', 336, 'krimpen-aan-den-ijssel-336', '51.91080000', '4.58370000'),
('Kring van Dorth', 'GE', 328, 'kring-van-dorth-328', '52.22690000', '6.31720000'),
('Krommenie', 'NH', 332, 'krommenie-332', '52.50040000', '4.76610000'),
('Kronenberg', 'LI', 330, 'kronenberg-330', '51.41570000', '5.99930000'),
('Kropswolde', 'GR', 329, 'kropswolde-329', '53.14320000', '6.71450000'),
('Kruiningen', 'ZE', 335, 'kruiningen-335', '51.44900000', '4.03340000'),
('Kruisland', 'NB', 331, 'kruisland-331', '51.56940000', '4.40830000'),
('Kûbaard', '', NULL, 'kubaard-', '53.11990000', '5.56990000'),
('Kudelstaart', 'NH', 332, 'kudelstaart-332', '52.23500000', '4.75110000'),
('Kuinre', 'OV', 333, 'kuinre-333', '52.79000000', '5.84140000'),
('Kuitaart', 'ZE', 335, 'kuitaart-335', '51.33600000', '4.03810000'),
('Kwadendamme', 'ZE', 335, 'kwadendamme-335', '51.43440000', '3.87840000'),
('Kwadijk', 'NH', 332, 'kwadijk-332', '52.52710000', '4.98320000'),
('Kwintsheul', 'ZH', 336, 'kwintsheul-336', '52.01450000', '4.25630000'),
('Laag Zuthem', 'OV', 333, 'laag-zuthem-333', '52.45930000', '6.17980000'),
('Laag-Keppel', 'GE', 328, 'laag-keppel-328', '51.99550000', '6.21650000'),
('Laag-Soeren', 'GE', 328, 'laag-soeren-328', '52.07870000', '6.07430000'),
('Lage Mierde', 'NB', 331, 'lage-mierde-331', '51.40850000', '5.14890000'),
('Lage Vuursche', 'UT', 334, 'lage-vuursche-334', '52.18060000', '5.22180000'),
('Lage Zwaluwe', 'NB', 331, 'lage-zwaluwe-331', '51.70900000', '4.70040000'),
('Lageland', 'GR', 329, 'lageland-329', '53.24020000', '6.71530000'),
('Lageland GN', 'GR', 329, 'lageland-gn-329', '53.24070000', '6.67240000'),
('Lambertschaag', 'NH', 332, 'lambertschaag-332', '52.74780000', '5.01790000'),
('Lamswaarde', 'ZE', 335, 'lamswaarde-335', '51.34230000', '4.05590000'),
('Landerum', '', NULL, 'landerum-', '53.38650000', '5.29920000'),
('Landgraaf', 'LI', 330, 'landgraaf-330', '50.90130000', '6.01590000'),
('Landhorst', 'NB', 331, 'landhorst-331', '51.61880000', '5.78580000'),
('Landsmeer', 'NH', 332, 'landsmeer-332', '52.43050000', '4.91440000'),
('Langbroek', 'UT', 334, 'langbroek-334', '52.01050000', '5.33360000'),
('Langedijke', '', NULL, 'langedijke-', '52.96430000', '6.28480000'),
('Langelille', '', NULL, 'langelille-', '52.84460000', '5.84340000'),
('Langelo', 'DR', 326, 'langelo-326', '53.09290000', '6.44380000'),
('Langenboom', 'NB', 331, 'langenboom-331', '51.70350000', '5.73030000'),
('Langerak', 'ZH', 336, 'langerak-336', '51.93380000', '4.88400000'),
('Langeveen', 'OV', 333, 'langeveen-333', '52.46190000', '6.71960000'),
('Langeweg', 'NB', 331, 'langeweg-331', '51.64800000', '4.65990000'),
('Langezwaag', '', NULL, 'langezwaag-', '52.98510000', '6.00700000'),
('Langweer', '', NULL, 'langweer-', '52.95890000', '5.72190000'),
('Laren', 'GE', 328, 'laren-328', '52.19710000', '6.37240000'),
('Laren', 'NH', 332, 'laren-332', '52.25400000', '5.22880000'),
('Lathum', 'GE', 328, 'lathum-328', '51.99020000', '6.03450000'),
('Lattrop-Breklenkamp', 'OV', 333, 'lattrop-breklenkamp-333', '52.42860000', '6.97880000'),
('Lauwersoog', 'GR', 329, 'lauwersoog-329', '53.39750000', '6.21380000'),
('Lauwerzijl', 'GR', 329, 'lauwerzijl-329', '53.31280000', '6.30470000'),
('Ledeacker', 'NB', 331, 'ledeacker-331', '51.63570000', '5.87140000'),
('Leek', 'GR', 329, 'leek-329', '53.16080000', '6.37730000'),
('Leende', 'NB', 331, 'leende-331', '51.34870000', '5.55160000'),
('Leens', 'GR', 329, 'leens-329', '53.35940000', '6.38000000'),
('Leerbroek', 'ZH', 336, 'leerbroek-336', '51.91270000', '5.04770000'),
('Leerdam', 'ZH', 336, 'leerdam-336', '51.89200000', '5.09750000'),
('Leermens', 'GR', 329, 'leermens-329', '53.34700000', '6.79850000'),
('Leersum', 'UT', 334, 'leersum-334', '52.01380000', '5.42730000'),
('Leeuwarden', '', NULL, 'leeuwarden-', '53.20190000', '5.79720000'),
('Legemeer', '', NULL, 'legemeer-', '52.93800000', '5.72770000'),
('Leiden', 'ZH', 336, 'leiden-336', '52.15640000', '4.48970000'),
('Leiderdorp', 'ZH', 336, 'leiderdorp-336', '52.14740000', '4.53070000'),
('Leidschendam', 'ZH', 336, 'leidschendam-336', '52.09680000', '4.38940000'),
('Leimuiden', 'ZH', 336, 'leimuiden-336', '52.22250000', '4.67050000'),
('Leimuiderbrug', 'NH', 332, 'leimuiderbrug-332', '52.23220000', '4.67100000'),
('Lekkerkerk', 'ZH', 336, 'lekkerkerk-336', '51.89400000', '4.64390000'),
('Lekkum', '', NULL, 'lekkum-', '53.22520000', '5.82000000'),
('Lellens', 'GR', 329, 'lellens-329', '53.30130000', '6.70960000'),
('Lelystad', 'FL', 327, 'lelystad-327', '52.53650000', '5.51380000'),
('Lemele', 'OV', 333, 'lemele-333', '52.45190000', '6.41060000'),
('Lemelerveld', 'OV', 333, 'lemelerveld-333', '52.44580000', '6.34950000'),
('Lemiers', 'LI', 330, 'lemiers-330', '50.78470000', '5.99040000'),
('Lemmer', '', NULL, 'lemmer-', '52.84870000', '5.70410000'),
('Lengel', 'GE', 328, 'lengel-328', '51.88380000', '6.26600000'),
('Lent', 'GE', 328, 'lent-328', '51.87920000', '5.86260000'),
('Leons', '', NULL, 'leons-', '53.15200000', '5.67920000'),
('Lepelstraat', 'NB', 331, 'lepelstraat-331', '51.54980000', '4.27560000'),
('Lettelbert', 'GR', 329, 'lettelbert-329', '53.19280000', '6.41560000'),
('Lettele', 'OV', 333, 'lettele-333', '52.27730000', '6.27380000'),
('Leunen', 'LI', 330, 'leunen-330', '51.50790000', '5.97870000'),
('Leur', 'GE', 328, 'leur-328', '51.82270000', '5.69850000'),
('Leusden', 'UT', 334, 'leusden-334', '52.13570000', '5.43540000'),
('Leuth', 'GE', 328, 'leuth-328', '51.83930000', '5.99230000'),
('Leutingewolde', 'DR', 326, 'leutingewolde-326', '53.15450000', '6.42730000'),
('Leuvenheim', 'GE', 328, 'leuvenheim-328', '52.07520000', '6.13890000'),
('Leveroy', 'LI', 330, 'leveroy-330', '51.24970000', '5.83620000'),
('Lewedorp', 'ZE', 335, 'lewedorp-335', '51.49370000', '3.75000000'),
('Lexmond', 'ZH', 336, 'lexmond-336', '51.96120000', '5.03280000'),
('Lichtaard', '', NULL, 'lichtaard-', '53.32650000', '5.91460000'),
('Lichtenvoorde', 'GE', 328, 'lichtenvoorde-328', '51.98740000', '6.56950000'),
('Liempde', 'NB', 331, 'liempde-331', '51.56980000', '5.37020000'),
('Lienden', 'GE', 328, 'lienden-328', '51.94310000', '5.51610000'),
('Lierderholthuis', 'OV', 333, 'lierderholthuis-333', '52.43670000', '6.19270000'),
('Lieren', 'GE', 328, 'lieren-328', '52.16100000', '5.99710000'),
('Lierop', 'NB', 331, 'lierop-331', '51.42120000', '5.67980000'),
('Lies', '', NULL, 'lies-', '53.39470000', '5.32700000'),
('Lieshout', 'NB', 331, 'lieshout-331', '51.51810000', '5.59260000'),
('Liessel', 'NB', 331, 'liessel-331', '51.41420000', '5.82310000'),
('Lievelde', 'GE', 328, 'lievelde-328', '52.01130000', '6.59540000'),
('Lieveren', 'DR', 326, 'lieveren-326', '53.11500000', '6.45770000'),
('Lijnden', 'NH', 332, 'lijnden-332', '52.35080000', '4.75840000'),
('Limbricht', 'LI', 330, 'limbricht-330', '51.01190000', '5.83760000'),
('Limmen', 'NH', 332, 'limmen-332', '52.57180000', '4.69470000'),
('Linde', 'DR', 326, 'linde-326', '52.63560000', '6.46340000'),
('Linden', 'NB', 331, 'linden-331', '51.74890000', '5.82990000'),
('Linne', 'LI', 330, 'linne-330', '51.15490000', '5.93840000'),
('Linschoten', 'UT', 334, 'linschoten-334', '52.06320000', '4.91670000'),
('Lioessens', '', NULL, 'lioessens-', '53.38170000', '6.08950000'),
('Lippenhuizen', '', NULL, 'lippenhuizen-', '53.01720000', '6.09540000'),
('Lisse', 'ZH', 336, 'lisse-336', '52.25710000', '4.55580000'),
('Lisserbroek', 'NH', 332, 'lisserbroek-332', '52.25600000', '4.57360000'),
('Lith', 'NB', 331, 'lith-331', '51.80590000', '5.43630000'),
('Lithoijen', 'NB', 331, 'lithoijen-331', '51.79960000', '5.46360000'),
('Lobith', 'GE', 328, 'lobith-328', '51.87140000', '6.10830000'),
('Lochem', 'GE', 328, 'lochem-328', '52.13860000', '6.37920000'),
('Loenen', 'GE', 328, 'loenen-328', '52.11910000', '6.02490000'),
('Loenen aan de Vecht', 'UT', 334, 'loenen-aan-de-vecht-334', '52.21180000', '5.02160000'),
('Loenersloot', 'UT', 334, 'loenersloot-334', '52.22820000', '5.00080000'),
('Loënga', '', NULL, 'loenga-', '53.05190000', '5.66850000'),
('Loerbeek', 'GE', 328, 'loerbeek-328', '51.92750000', '6.19980000'),
('Lollum', '', NULL, 'lollum-', '53.12620000', '5.53070000'),
('Lomm', 'LI', 330, 'lomm-330', '51.44770000', '6.17320000'),
('Longerhouw', '', NULL, 'longerhouw-', '53.07010000', '5.47820000'),
('Loo Gld', 'GE', 328, 'loo-gld-328', '51.93050000', '5.98600000'),
('Loon', 'DR', 326, 'loon-326', '53.01310000', '6.61180000'),
('Loon op Zand', 'NB', 331, 'loon-op-zand-331', '51.64300000', '5.03830000'),
('Loosbroek', 'NB', 331, 'loosbroek-331', '51.68050000', '5.50950000'),
('Loosdrecht', 'NH', 332, 'loosdrecht-332', '52.19970000', '5.11380000'),
('Loozen', 'OV', 333, 'loozen-333', '52.58870000', '6.67270000'),
('Lopik', 'UT', 334, 'lopik-334', '51.97290000', '4.94390000'),
('Lopikerkapel', 'UT', 334, 'lopikerkapel-334', '51.98780000', '5.03700000'),
('Loppersum', 'GR', 329, 'loppersum-329', '53.31160000', '6.74340000'),
('Losdorp', 'GR', 329, 'losdorp-329', '53.37520000', '6.83530000'),
('Losser', 'OV', 333, 'losser-333', '52.26430000', '7.00650000'),
('Lottum', 'LI', 330, 'lottum-330', '51.45900000', '6.15400000'),
('Lucaswolde', 'GR', 329, 'lucaswolde-329', '53.18420000', '6.29620000'),
('Luddeweer', 'GR', 329, 'luddeweer-329', '53.25060000', '6.73900000'),
('Luinjeberd', '', NULL, 'luinjeberd-', '52.99400000', '5.92460000'),
('Lunteren', 'GE', 328, 'lunteren-328', '52.09070000', '5.62140000'),
('Lutjebroek', 'NH', 332, 'lutjebroek-332', '52.69800000', '5.20500000'),
('Lutjegast', 'GR', 329, 'lutjegast-329', '53.23480000', '6.25870000'),
('Lutjewinkel', 'NH', 332, 'lutjewinkel-332', '52.76930000', '4.88190000'),
('Luttelgeest', 'FL', 327, 'luttelgeest-327', '52.75050000', '5.84470000'),
('Lutten', 'OV', 333, 'lutten-333', '52.61390000', '6.57700000'),
('Luttenberg', 'OV', 333, 'luttenberg-333', '52.40500000', '6.36550000'),
('Luxwoude', '', NULL, 'luxwoude-', '52.99550000', '5.98130000'),
('Luyksgestel', 'NB', 331, 'luyksgestel-331', '51.28910000', '5.32100000'),
('Lytsewierrum', '', NULL, 'lytsewierrum-', '53.08390000', '5.66440000'),
('Maarheeze', 'NB', 331, 'maarheeze-331', '51.31120000', '5.61890000'),
('Maarn', 'UT', 334, 'maarn-334', '52.06560000', '5.37210000'),
('Maarsbergen', 'UT', 334, 'maarsbergen-334', '52.05510000', '5.41110000'),
('Maarssen', 'UT', 334, 'maarssen-334', '52.14480000', '5.04340000'),
('Maartensdijk', 'UT', 334, 'maartensdijk-334', '52.15550000', '5.17620000'),
('Maasbommel', 'GE', 328, 'maasbommel-328', '51.83980000', '5.50060000'),
('Maasbracht', 'LI', 330, 'maasbracht-330', '51.14330000', '5.89110000'),
('Maasbree', 'LI', 330, 'maasbree-330', '51.39230000', '6.06510000'),
('Maasdam', 'ZH', 336, 'maasdam-336', '51.79060000', '4.58230000'),
('Maasdijk', 'ZH', 336, 'maasdijk-336', '51.95770000', '4.21600000'),
('Maashees', 'NB', 331, 'maashees-331', '51.57050000', '6.03260000'),
('Maasland', 'ZH', 336, 'maasland-336', '51.93630000', '4.27180000'),
('Maassluis', 'ZH', 336, 'maassluis-336', '51.92010000', '4.26260000'),
('Maastricht', 'LI', 330, 'maastricht-330', '50.85010000', '5.68820000'),
('Maastricht-Airport', 'LI', 330, 'maastricht-airport-330', '50.92140000', '5.77760000'),
('Maasvlakte Rotterdam', 'ZH', 336, 'maasvlakte-rotterdam-336', '51.94460000', '4.03770000'),
('Macharen', 'NB', 331, 'macharen-331', '51.80470000', '5.54360000'),
('Made', 'NB', 331, 'made-331', '51.67670000', '4.79270000'),
('Makkinga', '', NULL, 'makkinga-', '52.97840000', '6.22090000'),
('Makkum', '', NULL, 'makkum-', '53.05570000', '5.40060000'),
('Malden', 'GE', 328, 'malden-328', '51.78210000', '5.85470000'),
('Mander', 'OV', 333, 'mander-333', '52.44200000', '6.82010000'),
('Manderveen', 'OV', 333, 'manderveen-333', '52.44700000', '6.77960000'),
('Mantgum', '', NULL, 'mantgum-', '53.12990000', '5.71890000'),
('Mantinge', 'DR', 326, 'mantinge-326', '52.79850000', '6.61240000'),
('Maren-Kessel', 'NB', 331, 'maren-kessel-331', '51.79090000', '5.38940000'),
('Margraten', 'LI', 330, 'margraten-330', '50.82150000', '5.82160000'),
('Maria Hoop', 'LI', 330, 'maria-hoop-330', '51.08790000', '5.96860000'),
('Mariahout', 'NB', 331, 'mariahout-331', '51.54110000', '5.57130000'),
('Mariaparochie', 'OV', 333, 'mariaparochie-333', '52.38100000', '6.70710000'),
('Mariënberg', 'OV', 333, 'marienberg-333', '52.51080000', '6.57680000'),
('Mariënheem', 'OV', 333, 'marienheem-333', '52.38290000', '6.32210000'),
('Mariënvelde', 'GE', 328, 'marienvelde-328', '52.01140000', '6.47520000'),
('Marijenkampen', 'OV', 333, 'marijenkampen-333', '52.81510000', '6.05760000'),
('Markelo', 'OV', 333, 'markelo-333', '52.23660000', '6.50530000'),
('Marken', 'NH', 332, 'marken-332', '52.45960000', '5.10600000'),
('Markenbinnen', 'NH', 332, 'markenbinnen-332', '52.53010000', '4.78110000'),
('Marknesse', 'FL', 327, 'marknesse-327', '52.70870000', '5.86840000'),
('Marle', 'OV', 333, 'marle-333', '52.41180000', '6.12460000'),
('Marrum', '', NULL, 'marrum-', '53.32320000', '5.80060000'),
('Marsum', '', NULL, 'marsum-', '53.21120000', '5.72720000'),
('Marum', 'GR', 329, 'marum-329', '53.14340000', '6.26370000'),
('Marwijksoord', 'DR', 326, 'marwijksoord-326', '52.96430000', '6.65610000'),
('Mastenbroek', 'OV', 333, 'mastenbroek-333', '52.56730000', '6.00560000'),
('Matsloot', 'DR', 326, 'matsloot-326', '53.19370000', '6.45050000'),
('Maurik', 'GE', 328, 'maurik-328', '51.96160000', '5.42270000'),
('Mechelen', 'LI', 330, 'mechelen-330', '50.79330000', '5.92520000'),
('Medemblik', 'NH', 332, 'medemblik-332', '52.76680000', '5.10480000'),
('Meeden', 'GR', 329, 'meeden-329', '53.13720000', '6.92390000'),
('Meedhuizen', 'GR', 329, 'meedhuizen-329', '53.28800000', '6.91330000'),
('Meerkerk', 'ZH', 336, 'meerkerk-336', '51.91890000', '4.99440000'),
('Meerlo', 'LI', 330, 'meerlo-330', '51.51220000', '6.08570000'),
('Meerssen', 'LI', 330, 'meerssen-330', '50.88480000', '5.74940000'),
('Meerstad', 'GR', 329, 'meerstad-329', '53.22400000', '6.65090000'),
('Meeuwen', 'NB', 331, 'meeuwen-331', '51.72770000', '5.01140000'),
('Megchelen', 'GE', 328, 'megchelen-328', '51.84080000', '6.39030000'),
('Megen', 'NB', 331, 'megen-331', '51.82050000', '5.56220000'),
('Meijel', 'LI', 330, 'meijel-330', '51.34320000', '5.88290000'),
('Melderslo', 'LI', 330, 'melderslo-330', '51.46150000', '6.08610000'),
('Melick', 'LI', 330, 'melick-330', '51.16000000', '6.01700000'),
('Meliskerke', 'ZE', 335, 'meliskerke-335', '51.51590000', '3.51300000'),
('Melissant', 'ZH', 336, 'melissant-336', '51.76730000', '4.09010000'),
('Menaam', '', NULL, 'menaam-', '53.21530000', '5.66130000'),
('Mensingeweer', 'GR', 329, 'mensingeweer-329', '53.34940000', '6.46480000'),
('Meppel', 'DR', 326, 'meppel-326', '52.69610000', '6.19100000'),
('Meppen', 'DR', 326, 'meppen-326', '52.78220000', '6.69110000'),
('Merkelbeek', 'LI', 330, 'merkelbeek-330', '50.95510000', '5.93540000'),
('Merselo', 'LI', 330, 'merselo-330', '51.53030000', '5.92790000'),
('Meteren', 'GE', 328, 'meteren-328', '51.86930000', '5.28380000'),
('Meterik', 'LI', 330, 'meterik-330', '51.45350000', '6.02230000'),
('Metslawier', '', NULL, 'metslawier-', '53.35980000', '6.06590000'),
('Mheer', 'LI', 330, 'mheer-330', '50.78160000', '5.79340000'),
('Middelaar', 'LI', 330, 'middelaar-330', '51.72660000', '5.91450000'),
('Middelburg', 'ZE', 335, 'middelburg-335', '51.49950000', '3.61440000'),
('Middelharnis', 'ZH', 336, 'middelharnis-336', '51.75830000', '4.16820000'),
('Middelie', 'NH', 332, 'middelie-332', '52.53480000', '5.01550000'),
('Middelstum', 'GR', 329, 'middelstum-329', '53.34570000', '6.64230000'),
('Middenbeemster', 'NH', 332, 'middenbeemster-332', '52.54890000', '4.91490000'),
('Middenmeer', 'NH', 332, 'middenmeer-332', '52.80570000', '4.99930000'),
('Midlaren', 'DR', 326, 'midlaren-326', '53.11260000', '6.67750000'),
('Midlum', '', NULL, 'midlum-', '53.18330000', '5.46740000'),
('Midsland', '', NULL, 'midsland-', '53.38850000', '5.28570000'),
('Midwolda', 'GR', 329, 'midwolda-329', '53.19230000', '7.01290000'),
('Midwolde', 'GR', 329, 'midwolde-329', '53.19030000', '6.38670000'),
('Midwoud', 'NH', 332, 'midwoud-332', '52.71680000', '5.07330000'),
('Miedum', '', NULL, 'miedum-', '53.23580000', '5.83220000'),
('Mierlo', 'NB', 331, 'mierlo-331', '51.44100000', '5.61820000'),
('Mijdrecht', 'UT', 334, 'mijdrecht-334', '52.20610000', '4.86160000'),
('Mijnsheerenland', 'ZH', 336, 'mijnsheerenland-336', '51.79830000', '4.48580000'),
('Mildam', '', NULL, 'mildam-', '52.93740000', '5.99930000'),
('Milheeze', 'NB', 331, 'milheeze-331', '51.50430000', '5.78210000'),
('Mill', 'NB', 331, 'mill-331', '51.68800000', '5.77690000'),
('Millingen aan de Rijn', 'GE', 328, 'millingen-aan-de-rijn-328', '51.86290000', '6.04640000'),
('Milsbeek', 'LI', 330, 'milsbeek-330', '51.72640000', '5.94810000'),
('Minnertsga', '', NULL, 'minnertsga-', '53.25140000', '5.59490000'),
('Mirns', '', NULL, 'mirns-', '52.85790000', '5.46350000'),
('Moddergat', '', NULL, 'moddergat-', '53.40360000', '6.07880000'),
('Moerdijk', 'NB', 331, 'moerdijk-331', '51.70200000', '4.62860000'),
('Moergestel', 'NB', 331, 'moergestel-331', '51.54330000', '5.18230000'),
('Moerkapelle', 'ZH', 336, 'moerkapelle-336', '52.04520000', '4.57810000'),
('Moerstraten', 'NB', 331, 'moerstraten-331', '51.53900000', '4.36880000'),
('Molenaarsgraaf', 'ZH', 336, 'molenaarsgraaf-336', '51.87570000', '4.82420000'),
('Molenhoek', 'LI', 330, 'molenhoek-330', '51.76800000', '5.87450000'),
('Molenschot', 'NB', 331, 'molenschot-331', '51.56930000', '4.88640000'),
('Molkwerum', '', NULL, 'molkwerum-', '52.89880000', '5.40380000'),
('Monnickendam', 'NH', 332, 'monnickendam-332', '52.45370000', '5.03650000'),
('Monster', 'ZH', 336, 'monster-336', '52.02560000', '4.17620000'),
('Montfoort', 'UT', 334, 'montfoort-334', '52.04380000', '4.95220000'),
('Montfort', 'LI', 330, 'montfort-330', '51.12750000', '5.94800000'),
('Mook', 'LI', 330, 'mook-330', '51.75250000', '5.88510000'),
('Mookhoek', 'ZH', 336, 'mookhoek-336', '51.74430000', '4.59430000'),
('Moordrecht', 'ZH', 336, 'moordrecht-336', '51.99370000', '4.68010000'),
('Moorveld', 'LI', 330, 'moorveld-330', '50.91700000', '5.76900000'),
('Morra', '', NULL, 'morra-', '53.37100000', '6.08900000'),
('Muiden', 'NH', 332, 'muiden-332', '52.32990000', '5.06690000'),
('Muiderberg', 'NH', 332, 'muiderberg-332', '52.32460000', '5.11930000'),
('Mûnein', '', NULL, 'munein-', '53.25220000', '5.91750000'),
('Munnekeburen', '', NULL, 'munnekeburen-', '52.84770000', '5.88180000'),
('Munnekezijl', '', NULL, 'munnekezijl-', '53.30460000', '6.26950000'),
('Munstergeleen', 'LI', 330, 'munstergeleen-330', '50.97460000', '5.86410000'),
('Muntendam', 'GR', 329, 'muntendam-329', '53.13390000', '6.86890000'),
('Mussel', 'GR', 329, 'mussel-329', '52.95800000', '7.04340000'),
('Musselkanaal', 'GR', 329, 'musselkanaal-329', '52.93770000', '7.00910000'),
('Naaldwijk', 'ZH', 336, 'naaldwijk-336', '51.99350000', '4.20690000'),
('Naarden', 'NH', 332, 'naarden-332', '52.29660000', '5.15850000'),
('Nagele', 'FL', 327, 'nagele-327', '52.64090000', '5.72430000'),
('Nederasselt', 'GE', 328, 'nederasselt-328', '51.77220000', '5.74700000'),
('Nederhemert', 'GE', 328, 'nederhemert-328', '51.76440000', '5.16370000'),
('Nederhorst den Berg', 'NH', 332, 'nederhorst-den-berg-332', '52.25860000', '5.05030000'),
('Nederland', 'OV', 333, 'nederland-333', '52.75380000', '5.96430000'),
('Nederweert', 'LI', 330, 'nederweert-330', '51.28550000', '5.74760000'),
('Nederweert-Eind', 'LI', 330, 'nederweert-eind-330', '51.27720000', '5.78330000'),
('Neede', 'GE', 328, 'neede-328', '52.13680000', '6.60890000'),
('Neer', 'LI', 330, 'neer-330', '51.26280000', '5.98780000'),
('Neerijnen', 'GE', 328, 'neerijnen-328', '51.84510000', '5.27070000'),
('Neeritter', 'LI', 330, 'neeritter-330', '51.16510000', '5.80190000'),
('Neerkant', 'NB', 331, 'neerkant-331', '51.36940000', '5.86620000'),
('Neerlangel', 'NB', 331, 'neerlangel-331', '51.80490000', '5.64580000'),
('Neerloon', 'NB', 331, 'neerloon-331', '51.78810000', '5.67610000'),
('Nes', '', NULL, 'nes-', '53.39630000', '6.04750000'),
('Netersel', 'NB', 331, 'netersel-331', '51.40450000', '5.20810000'),
('Netterden', 'GE', 328, 'netterden-328', '51.85530000', '6.31460000'),
('Niawier', '', NULL, 'niawier-', '53.36270000', '6.04700000'),
('Nibbixwoud', 'NH', 332, 'nibbixwoud-332', '52.69240000', '5.05600000'),
('Niebert', 'GR', 329, 'niebert-329', '53.15710000', '6.32660000'),
('Niehove', 'GR', 329, 'niehove-329', '53.28920000', '6.36220000'),
('Niekerk', 'GR', 329, 'niekerk-329', '53.22580000', '6.35520000'),
('Nietap', 'DR', 326, 'nietap-326', '53.15850000', '6.39740000'),
('Nieuw Annerveen', 'DR', 326, 'nieuw-annerveen-326', '53.07000000', '6.77370000'),
('Nieuw Beerta', 'GR', 329, 'nieuw-beerta-329', '53.18990000', '7.16210000'),
('Nieuw Heeten', 'OV', 333, 'nieuw-heeten-333', '52.32130000', '6.34260000'),
('Nieuw Namen', 'ZE', 335, 'nieuw-namen-335', '51.29860000', '4.16200000'),
('Nieuw Scheemda', 'GR', 329, 'nieuw-scheemda-329', '53.21070000', '6.94220000'),
('Nieuw- en Sint Joosland', 'ZE', 335, 'nieuw-en-sint-joosland-335', '51.48280000', '3.65970000'),
('Nieuw-Amsterdam', 'DR', 326, 'nieuw-amsterdam-326', '52.71240000', '6.85990000'),
('Nieuw-Balinge', 'DR', 326, 'nieuw-balinge-326', '52.76730000', '6.60410000'),
('Nieuw-Beijerland', 'ZH', 336, 'nieuw-beijerland-336', '51.80950000', '4.34500000'),
('Nieuw-Buinen', 'DR', 326, 'nieuw-buinen-326', '52.96430000', '6.94320000'),
('Nieuw-Dordrecht', 'DR', 326, 'nieuw-dordrecht-326', '52.74930000', '6.93700000'),
('Nieuw-Lekkerland', 'ZH', 336, 'nieuw-lekkerland-336', '51.88670000', '4.67770000'),
('Nieuw-Roden', 'DR', 326, 'nieuw-roden-326', '53.13050000', '6.39480000'),
('Nieuw-Schoonebeek', 'DR', 326, 'nieuw-schoonebeek-326', '52.64770000', '6.98940000'),
('Nieuw-Vennep', 'NH', 332, 'nieuw-vennep-332', '52.26660000', '4.61700000'),
('Nieuw-Vossemeer', 'NB', 331, 'nieuw-vossemeer-331', '51.58940000', '4.22010000'),
('Nieuw-Weerdinge', 'DR', 326, 'nieuw-weerdinge-326', '52.85260000', '6.98010000'),
('Nieuwaal', 'GE', 328, 'nieuwaal-328', '51.80830000', '5.17700000'),
('Nieuwdorp', 'ZE', 335, 'nieuwdorp-335', '51.46890000', '3.73880000'),
('Nieuwe Niedorp', 'NH', 332, 'nieuwe-niedorp-332', '52.74080000', '4.89820000'),
('Nieuwe Pekela', 'GR', 329, 'nieuwe-pekela-329', '53.05600000', '6.99400000'),
('Nieuwe Wetering', 'ZH', 336, 'nieuwe-wetering-336', '52.20840000', '4.61750000'),
('Nieuwe-Tonge', 'ZH', 336, 'nieuwe-tonge-336', '51.71410000', '4.16440000'),
('Nieuwebrug', '', NULL, 'nieuwebrug-', '52.99030000', '5.88460000'),
('Nieuwediep', 'DR', 326, 'nieuwediep-326', '53.04880000', '6.84430000'),
('Nieuwegein', 'UT', 334, 'nieuwegein-334', '52.03230000', '5.08380000'),
('Nieuwehorne', '', NULL, 'nieuwehorne-', '52.95060000', '6.06020000'),
('Nieuwendijk', 'NB', 331, 'nieuwendijk-331', '51.77420000', '4.91980000'),
('Nieuwer Ter Aa', 'UT', 334, 'nieuwer-ter-aa-334', '52.19510000', '4.97920000'),
('Nieuwerbrug aan den Rijn', 'ZH', 336, 'nieuwerbrug-aan-den-rijn-336', '52.07830000', '4.81430000'),
('Nieuwerkerk', 'ZE', 335, 'nieuwerkerk-335', '51.64990000', '4.00070000'),
('Nieuwerkerk aan den IJssel', 'ZH', 336, 'nieuwerkerk-aan-den-ijssel-336', '51.96010000', '4.61930000'),
('Nieuweroord', 'DR', 326, 'nieuweroord-326', '52.72060000', '6.57040000'),
('Nieuwersluis', 'UT', 334, 'nieuwersluis-334', '52.19590000', '5.00760000'),
('Nieuweschoot', '', NULL, 'nieuweschoot-', '52.93240000', '5.92790000'),
('Nieuwkoop', 'ZH', 336, 'nieuwkoop-336', '52.14940000', '4.77390000'),
('Nieuwkuijk', 'NB', 331, 'nieuwkuijk-331', '51.69210000', '5.18040000'),
('Nieuwland', 'ZH', 336, 'nieuwland-336', '51.89890000', '5.02030000'),
('Nieuwlande', 'DR', 326, 'nieuwlande-326', '52.69410000', '6.61260000'),
('Nieuwlande Coevorden', 'DR', 326, 'nieuwlande-coevorden-326', '52.70030000', '6.63410000'),
('Nieuwleusen', 'OV', 333, 'nieuwleusen-333', '52.58070000', '6.27910000'),
('Nieuwolda', 'GR', 329, 'nieuwolda-329', '53.24420000', '6.98070000'),
('Nieuwpoort', 'ZH', 336, 'nieuwpoort-336', '51.93170000', '4.87090000'),
('Nieuwstadt', 'LI', 330, 'nieuwstadt-330', '51.03720000', '5.86210000'),
('Nieuwveen', 'ZH', 336, 'nieuwveen-336', '52.19720000', '4.75600000'),
('Nieuwvliet', 'ZE', 335, 'nieuwvliet-335', '51.38210000', '3.45590000'),
('Niezijl', 'GR', 329, 'niezijl-329', '53.26760000', '6.34670000'),
('Niftrik', 'GE', 328, 'niftrik-328', '51.79770000', '5.67510000'),
('Nigtevecht', 'UT', 334, 'nigtevecht-334', '52.27440000', '5.02960000'),
('Nij Altoenae', '', NULL, 'nij-altoenae-', '53.29600000', '5.65320000'),
('Nij Beets', '', NULL, 'nij-beets-', '53.06790000', '5.99990000'),
('Nijbroek', 'GE', 328, 'nijbroek-328', '52.29560000', '6.05750000'),
('Nijeberkoop', '', NULL, 'nijeberkoop-', '52.96020000', '6.18310000');
INSERT INTO `cities` (`city_name`, `state`, `state_id`, `slug`, `lat`, `lng`) VALUES
('Nijega', '', NULL, 'nijega-', '53.13710000', '6.02860000'),
('Nijehaske', '', NULL, 'nijehaske-', '52.96070000', '5.89590000'),
('Nijeholtpade', '', NULL, 'nijeholtpade-', '52.91420000', '6.08020000'),
('Nijeholtwolde', '', NULL, 'nijeholtwolde-', '52.89810000', '5.98770000'),
('Nijelamer', '', NULL, 'nijelamer-', '52.89030000', '5.95640000'),
('Nijemirdum', '', NULL, 'nijemirdum-', '52.85770000', '5.56830000'),
('Nijensleek', 'DR', 326, 'nijensleek-326', '52.83870000', '6.16480000'),
('Nijetrijne', '', NULL, 'nijetrijne-', '52.84100000', '5.91140000'),
('Nijeveen', 'DR', 326, 'nijeveen-326', '52.73410000', '6.16630000'),
('Nijhuizum', '', NULL, 'nijhuizum-', '52.98220000', '5.48670000'),
('Nijkerk', 'GE', 328, 'nijkerk-328', '52.22640000', '5.47670000'),
('Nijkerkerveen', 'GE', 328, 'nijkerkerveen-328', '52.19520000', '5.46540000'),
('Nijland', '', NULL, 'nijland-', '53.05120000', '5.57700000'),
('Nijlande', 'DR', 326, 'nijlande-326', '52.97380000', '6.62450000'),
('Nijmegen', 'GE', 328, 'nijmegen-328', '51.84630000', '5.86260000'),
('Nijverdal', 'OV', 333, 'nijverdal-333', '52.36010000', '6.45750000'),
('Nispen', 'NB', 331, 'nispen-331', '51.48370000', '4.45880000'),
('Nisse', 'ZE', 335, 'nisse-335', '51.45290000', '3.85160000'),
('Nistelrode', 'NB', 331, 'nistelrode-331', '51.70410000', '5.56190000'),
('Noardburgum', '', NULL, 'noardburgum-', '53.22320000', '6.00510000'),
('Nooitgedacht', 'DR', 326, 'nooitgedacht-326', '52.96680000', '6.67220000'),
('Noorbeek', 'LI', 330, 'noorbeek-330', '50.77200000', '5.81940000'),
('Noord-Scharwoude', 'NH', 332, 'noord-scharwoude-332', '52.69510000', '4.79640000'),
('Noord-Sleen', 'DR', 326, 'noord-sleen-326', '52.79140000', '6.80210000'),
('Noordbeemster', 'NH', 332, 'noordbeemster-332', '52.58620000', '4.93590000'),
('Noordbroek', 'GR', 329, 'noordbroek-329', '53.19510000', '6.87000000'),
('Noordeinde', 'NH', 332, 'noordeinde-332', '52.57180000', '4.83460000'),
('Noordeinde Gld', 'GE', 328, 'noordeinde-gld-328', '52.51250000', '5.87790000'),
('Noordeloos', 'ZH', 336, 'noordeloos-336', '51.90130000', '4.94180000'),
('Noorden', 'ZH', 336, 'noorden-336', '52.16580000', '4.82790000'),
('Noordgouwe', 'ZE', 335, 'noordgouwe-335', '51.68620000', '3.93910000'),
('Noordhoek', 'NB', 331, 'noordhoek-331', '51.64250000', '4.53090000'),
('Noordhorn', 'GR', 329, 'noordhorn-329', '53.26070000', '6.39570000'),
('Noordlaren', 'GR', 329, 'noordlaren-329', '53.12270000', '6.66260000'),
('Noordscheschut', 'DR', 326, 'noordscheschut-326', '52.72790000', '6.54530000'),
('Noordwelle', 'ZE', 335, 'noordwelle-335', '51.73220000', '3.79910000'),
('Noordwijk', 'GR', 329, 'noordwijk-329', '53.16840000', '6.25530000'),
('Noordwijk', 'ZH', 336, 'noordwijk-336', '52.23220000', '4.44450000'),
('Noordwijkerhout', 'ZH', 336, 'noordwijkerhout-336', '52.28960000', '4.53320000'),
('Noordwolde', '', NULL, 'noordwolde-', '52.88780000', '6.14310000'),
('Noordwolde', 'GR', 329, 'noordwolde-329', '53.27510000', '6.58670000'),
('Nootdorp', 'ZH', 336, 'nootdorp-336', '52.04400000', '4.39600000'),
('Norg', 'DR', 326, 'norg-326', '53.06880000', '6.45700000'),
('Notter', 'OV', 333, 'notter-333', '52.33530000', '6.52270000'),
('Nuenen', 'NB', 331, 'nuenen-331', '51.47460000', '5.54740000'),
('Nuis', 'GR', 329, 'nuis-329', '53.15100000', '6.30300000'),
('Nuland', 'NB', 331, 'nuland-331', '51.72610000', '5.43650000'),
('Numansdorp', 'ZH', 336, 'numansdorp-336', '51.72370000', '4.44050000'),
('Nunhem', 'LI', 330, 'nunhem-330', '51.24490000', '5.96220000'),
('Nunspeet', 'GE', 328, 'nunspeet-328', '52.37770000', '5.77660000'),
('Nuth', 'LI', 330, 'nuth-330', '50.91820000', '5.88650000'),
('Nutter', 'OV', 333, 'nutter-333', '52.42060000', '6.87120000'),
('Obbicht', 'LI', 330, 'obbicht-330', '51.02800000', '5.78110000'),
('Obdam', 'NH', 332, 'obdam-332', '52.68430000', '4.87740000'),
('Ochten', 'GE', 328, 'ochten-328', '51.91130000', '5.57070000'),
('Odijk', 'UT', 334, 'odijk-334', '52.05200000', '5.23440000'),
('Odiliapeel', 'NB', 331, 'odiliapeel-331', '51.64290000', '5.70850000'),
('Odoorn', 'DR', 326, 'odoorn-326', '52.84950000', '6.85120000'),
('Odoornerveen', 'DR', 326, 'odoornerveen-326', '52.84220000', '6.79410000'),
('Oeffelt', 'NB', 331, 'oeffelt-331', '51.69810000', '5.93260000'),
('Oegstgeest', 'ZH', 336, 'oegstgeest-336', '52.18110000', '4.47500000'),
('Oene', 'GE', 328, 'oene-328', '52.34490000', '6.04700000'),
('Oentsjerk', '', NULL, 'oentsjerk-', '53.25130000', '5.89960000'),
('Offingawier', '', NULL, 'offingawier-', '53.03000000', '5.71880000'),
('Ohé en Laak', 'LI', 330, 'ohe-en-laak-330', '51.11290000', '5.83090000'),
('Oijen', 'NB', 331, 'oijen-331', '51.82130000', '5.50440000'),
('Oirlo', 'LI', 330, 'oirlo-330', '51.50950000', '6.03380000'),
('Oirsbeek', 'LI', 330, 'oirsbeek-330', '50.94930000', '5.91080000'),
('Oirschot', 'NB', 331, 'oirschot-331', '51.50660000', '5.31180000'),
('Oisterwijk', 'NB', 331, 'oisterwijk-331', '51.58060000', '5.18730000'),
('Okkenbroek', 'OV', 333, 'okkenbroek-333', '52.29360000', '6.31920000'),
('Olburgen', 'GE', 328, 'olburgen-328', '52.04420000', '6.12750000'),
('Oldeberkoop', '', NULL, 'oldeberkoop-', '52.93830000', '6.13060000'),
('Oldebroek', 'GE', 328, 'oldebroek-328', '52.44280000', '5.92840000'),
('Oldeholtpade', '', NULL, 'oldeholtpade-', '52.89240000', '6.04710000'),
('Oldeholtwolde', '', NULL, 'oldeholtwolde-', '52.91200000', '5.99310000'),
('Oldehove', 'GR', 329, 'oldehove-329', '53.30210000', '6.39390000'),
('Oldekerk', 'GR', 329, 'oldekerk-329', '53.22220000', '6.33630000'),
('Oldelamer', '', NULL, 'oldelamer-', '52.87190000', '5.92160000'),
('Oldemarkt', 'OV', 333, 'oldemarkt-333', '52.82070000', '5.97400000'),
('Oldenzaal', 'OV', 333, 'oldenzaal-333', '52.28380000', '6.92880000'),
('Oldenzijl', 'GR', 329, 'oldenzijl-329', '53.39330000', '6.71940000'),
('Oldeouwer', '', NULL, 'oldeouwer-', '52.92050000', '5.80080000'),
('Oldetrijne', '', NULL, 'oldetrijne-', '52.85930000', '5.94830000'),
('Olst', 'OV', 333, 'olst-333', '52.33740000', '6.11750000'),
('Olterterp', '', NULL, 'olterterp-', '53.06790000', '6.10680000'),
('Ommel', 'NB', 331, 'ommel-331', '51.42470000', '5.74340000'),
('Ommen', 'OV', 333, 'ommen-333', '52.52380000', '6.42190000'),
('Ommeren', 'GE', 328, 'ommeren-328', '51.94210000', '5.48720000'),
('Onderdendam', 'GR', 329, 'onderdendam-329', '53.33410000', '6.58720000'),
('Onna', 'OV', 333, 'onna-333', '52.77450000', '6.15570000'),
('Onnen', 'GR', 329, 'onnen-329', '53.15520000', '6.64230000'),
('Onstwedde', 'GR', 329, 'onstwedde-329', '53.03420000', '7.04120000'),
('Ooij', 'GE', 328, 'ooij-328', '51.85680000', '5.93570000'),
('Ooltgensplaat', 'ZH', 336, 'ooltgensplaat-336', '51.68280000', '4.34740000'),
('Oost West en Middelbeers', 'NB', 331, 'oost-west-en-middelbeers-331', '51.47260000', '5.25070000'),
('Oost-Graftdijk', 'NH', 332, 'oost-graftdijk-332', '52.54840000', '4.81180000'),
('Oost-Souburg', 'ZE', 335, 'oost-souburg-335', '51.46560000', '3.60370000'),
('Oostburg', 'ZE', 335, 'oostburg-335', '51.32720000', '3.49210000'),
('Oostdijk', 'ZE', 335, 'oostdijk-335', '51.44340000', '4.07760000'),
('Oosteind', 'NB', 331, 'oosteind-331', '51.64560000', '4.90620000'),
('Oosterbeek', 'GE', 328, 'oosterbeek-328', '51.99070000', '5.83940000'),
('Oosterbierum', '', NULL, 'oosterbierum-', '53.23570000', '5.51220000'),
('Oosterblokker', 'NH', 332, 'oosterblokker-332', '52.66860000', '5.11590000'),
('Oosterend', '', NULL, 'oosterend-', '53.40420000', '5.37710000'),
('Oosterend', 'NH', 332, 'oosterend-332', '53.09040000', '4.87710000'),
('Oosterhesselen', 'DR', 326, 'oosterhesselen-326', '52.75470000', '6.72210000'),
('Oosterhout', 'GE', 328, 'oosterhout-328', '51.87940000', '5.82580000'),
('Oosterhout', 'NB', 331, 'oosterhout-331', '51.64610000', '4.86190000'),
('Oosterland', 'ZE', 335, 'oosterland-335', '51.65060000', '4.03700000'),
('Oosterleek', 'NH', 332, 'oosterleek-332', '52.63940000', '5.19640000'),
('Oosternieland', 'GR', 329, 'oosternieland-329', '53.40250000', '6.75200000'),
('Oosternijkerk', '', NULL, 'oosternijkerk-', '53.37940000', '6.05210000'),
('Oosterstreek', '', NULL, 'oosterstreek-', '52.89620000', '6.16630000'),
('Oosterwijk', 'ZH', 336, 'oosterwijk-336', '51.87770000', '5.07160000'),
('Oosterwijtwerd', 'GR', 329, 'oosterwijtwerd-329', '53.33700000', '6.81510000'),
('Oosterwolde', '', NULL, 'oosterwolde-', '52.99060000', '6.29210000'),
('Oosterwolde Gld', 'GE', 328, 'oosterwolde-gld-328', '52.46640000', '5.89510000'),
('Oosterzee', '', NULL, 'oosterzee-', '52.87230000', '5.76970000'),
('Oosthem', '', NULL, 'oosthem-', '53.01480000', '5.60100000'),
('Oosthuizen', 'NH', 332, 'oosthuizen-332', '52.57210000', '4.99750000'),
('Oostkapelle', 'ZE', 335, 'oostkapelle-335', '51.57070000', '3.54880000'),
('Oostknollendam', 'NH', 332, 'oostknollendam-332', '52.51710000', '4.79190000'),
('Oostrum', '', NULL, 'oostrum-', '53.32960000', '6.05350000'),
('Oostrum', 'LI', 330, 'oostrum-330', '51.52790000', '6.01850000'),
('Oostvoorne', 'ZH', 336, 'oostvoorne-336', '51.91210000', '4.10210000'),
('Oostwold', 'GR', 329, 'oostwold-329', '53.20250000', '6.44260000'),
('Oostwoud', 'NH', 332, 'oostwoud-332', '52.72540000', '5.08990000'),
('Oostzaan', 'NH', 332, 'oostzaan-332', '52.43960000', '4.87530000'),
('Ootmarsum', 'OV', 333, 'ootmarsum-333', '52.40750000', '6.90120000'),
('Opeinde', '', NULL, 'opeinde-', '53.13310000', '6.05860000'),
('Opende', 'GR', 329, 'opende-329', '53.16930000', '6.20050000'),
('Ophemert', 'GE', 328, 'ophemert-328', '51.84560000', '5.38210000'),
('Opheusden', 'GE', 328, 'opheusden-328', '51.93140000', '5.62900000'),
('Opijnen', 'GE', 328, 'opijnen-328', '51.82890000', '5.30070000'),
('Oploo', 'NB', 331, 'oploo-331', '51.60340000', '5.86290000'),
('Opmeer', 'NH', 332, 'opmeer-332', '52.70550000', '4.94560000'),
('Oppenhuizen', '', NULL, 'oppenhuizen-', '53.01160000', '5.69590000'),
('Opperdoes', 'NH', 332, 'opperdoes-332', '52.75870000', '5.07650000'),
('Oranje', 'DR', 326, 'oranje-326', '52.91000000', '6.44760000'),
('Oranjewoud', '', NULL, 'oranjewoud-', '52.94830000', '5.95460000'),
('Orvelte', 'DR', 326, 'orvelte-326', '52.84730000', '6.67210000'),
('Ospel', 'LI', 330, 'ospel-330', '51.30300000', '5.78940000'),
('Oss', 'NB', 331, 'oss-331', '51.76790000', '5.52060000'),
('Ossendrecht', 'NB', 331, 'ossendrecht-331', '51.39530000', '4.33110000'),
('Ossenisse', 'ZE', 335, 'ossenisse-335', '51.38870000', '3.97700000'),
('Ossenwaard', 'UT', 334, 'ossenwaard-334', '51.99210000', '5.13850000'),
('Ossenzijl', 'OV', 333, 'ossenzijl-333', '52.80750000', '5.92050000'),
('Oterleek', 'NH', 332, 'oterleek-332', '52.63420000', '4.83540000'),
('Otterlo', 'GE', 328, 'otterlo-328', '52.09960000', '5.77060000'),
('Ottersum', 'LI', 330, 'ottersum-330', '51.70480000', '5.98740000'),
('Ottoland', 'ZH', 336, 'ottoland-336', '51.89000000', '4.86400000'),
('Oud Ade', 'ZH', 336, 'oud-ade-336', '52.18470000', '4.55740000'),
('Oud Annerveen', 'DR', 326, 'oud-annerveen-326', '53.08700000', '6.76340000'),
('Oud Gastel', 'NB', 331, 'oud-gastel-331', '51.58700000', '4.46400000'),
('Oud Ootmarsum', 'OV', 333, 'oud-ootmarsum-333', '52.42170000', '6.91150000'),
('Oud Zuilen', 'UT', 334, 'oud-zuilen-334', '52.12870000', '5.06770000'),
('Oud-Alblas', 'ZH', 336, 'oud-alblas-336', '51.85810000', '4.70530000'),
('Oud-Beijerland', 'ZH', 336, 'oud-beijerland-336', '51.82060000', '4.42590000'),
('Oud-Vossemeer', 'ZE', 335, 'oud-vossemeer-335', '51.57080000', '4.19870000'),
('Ouddorp', 'ZH', 336, 'ouddorp-336', '51.80440000', '3.91480000'),
('Oude Meer', 'NH', 332, 'oude-meer-332', '52.28730000', '4.78350000'),
('Oude Niedorp', 'NH', 332, 'oude-niedorp-332', '52.71850000', '4.87640000'),
('Oude Pekela', 'GR', 329, 'oude-pekela-329', '53.10390000', '7.00810000'),
('Oude Wetering', 'ZH', 336, 'oude-wetering-336', '52.21180000', '4.64290000'),
('Oude Willem', 'DR', 326, 'oude-willem-326', '52.89330000', '6.31120000'),
('Oude-Tonge', 'ZH', 336, 'oude-tonge-336', '51.69130000', '4.21200000'),
('Oudebildtzijl', '', NULL, 'oudebildtzijl-', '53.30360000', '5.71390000'),
('Oudega', '', NULL, 'oudega-', '53.12390000', '5.99090000'),
('Oudehaske', '', NULL, 'oudehaske-', '52.95600000', '5.87240000'),
('Oudehorne', '', NULL, 'oudehorne-', '52.96300000', '6.08230000'),
('Oudelande', 'ZE', 335, 'oudelande-335', '51.40960000', '3.85100000'),
('Oudemirdum', '', NULL, 'oudemirdum-', '52.85130000', '5.53320000'),
('Oudemolen', 'DR', 326, 'oudemolen-326', '53.05110000', '6.63880000'),
('Oudemolen', 'NB', 331, 'oudemolen-331', '51.66020000', '4.45660000'),
('Oudenbosch', 'NB', 331, 'oudenbosch-331', '51.58930000', '4.53260000'),
('Oudendijk', 'NH', 332, 'oudendijk-332', '52.60220000', '4.97170000'),
('Oudenhoorn', 'ZH', 336, 'oudenhoorn-336', '51.82670000', '4.19130000'),
('Ouderkerk aan de Amstel', 'NH', 332, 'ouderkerk-aan-de-amstel-332', '52.29460000', '4.91180000'),
('Ouderkerk aan den IJssel', 'ZH', 336, 'ouderkerk-aan-den-ijssel-336', '51.93970000', '4.63880000'),
('Oudeschans', 'GR', 329, 'oudeschans-329', '53.14410000', '7.14220000'),
('Oudeschild', 'NH', 332, 'oudeschild-332', '53.03980000', '4.84600000'),
('Oudeschip', 'GR', 329, 'oudeschip-329', '53.43020000', '6.81630000'),
('Oudeschoot', '', NULL, 'oudeschoot-', '52.93550000', '5.95620000'),
('Oudesluis', 'NH', 332, 'oudesluis-332', '52.83150000', '4.80660000'),
('Oudewater', 'UT', 334, 'oudewater-334', '52.02560000', '4.86860000'),
('Oudezijl', 'GR', 329, 'oudezijl-329', '53.18810000', '7.20090000'),
('Oudheusden', 'NB', 331, 'oudheusden-331', '51.72330000', '5.13770000'),
('Oudkarspel', 'NH', 332, 'oudkarspel-332', '52.71190000', '4.80510000'),
('Oudorp', 'NH', 332, 'oudorp-332', '52.63320000', '4.77620000'),
('Oudwoude', '', NULL, 'oudwoude-', '53.28280000', '6.11540000'),
('Ouwerkerk', 'ZE', 335, 'ouwerkerk-335', '51.62700000', '3.98630000'),
('Ouwster-Nijega', '', NULL, 'ouwster-nijega-', '52.92980000', '5.80860000'),
('Ouwsterhaule', '', NULL, 'ouwsterhaule-', '52.93760000', '5.81450000'),
('Overasselt', 'GE', 328, 'overasselt-328', '51.76210000', '5.78820000'),
('Overberg', 'UT', 334, 'overberg-334', '52.03260000', '5.49800000'),
('Overdinkel', 'OV', 333, 'overdinkel-333', '52.23690000', '7.03610000'),
('Overlangel', 'NB', 331, 'overlangel-331', '51.77570000', '5.67150000'),
('Overloon', 'NB', 331, 'overloon-331', '51.57120000', '5.94580000'),
('Overschild', 'GR', 329, 'overschild-329', '53.27640000', '6.77950000'),
('Overslag', 'ZE', 335, 'overslag-335', '51.20700000', '3.89410000'),
('Overveen', 'NH', 332, 'overveen-332', '52.39410000', '4.62230000'),
('Ovezande', 'ZE', 335, 'ovezande-335', '51.43050000', '3.81800000'),
('Paasloo', 'OV', 333, 'paasloo-333', '52.81250000', '6.00440000'),
('Paesens', '', NULL, 'paesens-', '53.40090000', '6.08680000'),
('Pannerden', 'GE', 328, 'pannerden-328', '51.89090000', '6.03900000'),
('Panningen', 'LI', 330, 'panningen-330', '51.32750000', '5.97960000'),
('Papekop', 'UT', 334, 'papekop-334', '52.04780000', '4.85600000'),
('Papendrecht', 'ZH', 336, 'papendrecht-336', '51.83120000', '4.68090000'),
('Papenhoven', 'LI', 330, 'papenhoven-330', '51.04180000', '5.78400000'),
('Papenvoort', 'DR', 326, 'papenvoort-326', '52.94600000', '6.71340000'),
('Parrega', '', NULL, 'parrega-', '53.01570000', '5.47650000'),
('Paterswolde', 'DR', 326, 'paterswolde-326', '53.14820000', '6.56230000'),
('Peest', 'DR', 326, 'peest-326', '53.05850000', '6.49700000'),
('Peins', '', NULL, 'peins-', '53.20580000', '5.59500000'),
('Peize', 'DR', 326, 'peize-326', '53.14590000', '6.49650000'),
('Peperga', '', NULL, 'peperga-', '52.84760000', '6.05250000'),
('Pernis Rotterdam', 'ZH', 336, 'pernis-rotterdam-336', '51.88920000', '4.38850000'),
('Persingen', 'GE', 328, 'persingen-328', '51.84190000', '5.93770000'),
('Pesse', 'DR', 326, 'pesse-326', '52.77460000', '6.45610000'),
('Petten', 'NH', 332, 'petten-332', '52.76680000', '4.66140000'),
('Philippine', 'ZE', 335, 'philippine-335', '51.28290000', '3.75690000'),
('Piaam', '', NULL, 'piaam-', '53.03660000', '5.41000000'),
('Piershil', 'ZH', 336, 'piershil-336', '51.79410000', '4.31680000'),
('Pieterburen', 'GR', 329, 'pieterburen-329', '53.39990000', '6.44750000'),
('Pietersbierum', '', NULL, 'pietersbierum-', '53.21340000', '5.46860000'),
('Pieterzijl', 'GR', 329, 'pieterzijl-329', '53.28270000', '6.26990000'),
('Pijnacker', 'ZH', 336, 'pijnacker-336', '52.01890000', '4.43390000'),
('Pingjum', '', NULL, 'pingjum-', '53.11600000', '5.43800000'),
('Plasmolen', 'LI', 330, 'plasmolen-330', '51.73700000', '5.92000000'),
('Poederoijen', 'GE', 328, 'poederoijen-328', '51.78840000', '5.07790000'),
('Poeldijk', 'ZH', 336, 'poeldijk-336', '52.02460000', '4.22070000'),
('Polsbroek', 'UT', 334, 'polsbroek-334', '51.98210000', '4.86420000'),
('Poortugaal', 'ZH', 336, 'poortugaal-336', '51.85600000', '4.39530000'),
('Poortvliet', 'ZE', 335, 'poortvliet-335', '51.54570000', '4.14280000'),
('Poppenwier', '', NULL, 'poppenwier-', '53.08330000', '5.74820000'),
('Posterholt', 'LI', 330, 'posterholt-330', '51.12220000', '6.03110000'),
('Prinsenbeek', 'NB', 331, 'prinsenbeek-331', '51.59960000', '4.71150000'),
('Puiflijk', 'GE', 328, 'puiflijk-328', '51.88520000', '5.58530000'),
('Punthorst', 'OV', 333, 'punthorst-333', '52.60560000', '6.26510000'),
('Purmer', 'NH', 332, 'purmer-332', '52.50390000', '5.02280000'),
('Purmerend', 'NH', 332, 'purmerend-332', '52.50210000', '4.95240000'),
('Purmerland', 'NH', 332, 'purmerland-332', '52.47960000', '4.92440000'),
('Puth', 'LI', 330, 'puth-330', '50.95380000', '5.87240000'),
('Putte', 'NB', 331, 'putte-331', '51.36260000', '4.39610000'),
('Putten', 'GE', 328, 'putten-328', '52.25090000', '5.61530000'),
('Puttershoek', 'ZH', 336, 'puttershoek-336', '51.80370000', '4.56500000'),
('Raalte', 'OV', 333, 'raalte-333', '52.38250000', '6.26350000'),
('Raamsdonk', 'NB', 331, 'raamsdonk-331', '51.68880000', '4.90810000'),
('Raamsdonksveer', 'NB', 331, 'raamsdonksveer-331', '51.69690000', '4.87470000'),
('Raard', '', NULL, 'raard-', '53.32570000', '5.94460000'),
('Radewijk', 'OV', 333, 'radewijk-333', '52.57200000', '6.71290000'),
('Radio Kootwijk', 'GE', 328, 'radio-kootwijk-328', '52.17540000', '5.83060000'),
('Raerd', '', NULL, 'raerd-', '53.09830000', '5.75880000'),
('Randwijk', 'GE', 328, 'randwijk-328', '51.95090000', '5.70730000'),
('Ransdaal', 'LI', 330, 'ransdaal-330', '50.86450000', '5.89110000'),
('Rasquert', 'GR', 329, 'rasquert-329', '53.36860000', '6.51810000'),
('Ravenstein', 'NB', 331, 'ravenstein-331', '51.79370000', '5.64890000'),
('Ravenswaaij', 'GE', 328, 'ravenswaaij-328', '51.94930000', '5.32950000'),
('Ravenswoud', '', NULL, 'ravenswoud-', '52.96580000', '6.38040000'),
('Readtsjerk', '', NULL, 'readtsjerk-', '53.26190000', '5.91530000'),
('Reahûs', '', NULL, 'reahus-', '53.07680000', '5.63540000'),
('Reduzum', '', NULL, 'reduzum-', '53.11730000', '5.78520000'),
('Reek', 'NB', 331, 'reek-331', '51.74430000', '5.68240000'),
('Reeuwijk', 'ZH', 336, 'reeuwijk-336', '52.04680000', '4.72200000'),
('Reijmerstok', 'LI', 330, 'reijmerstok-330', '50.79970000', '5.83860000'),
('Reitsum', '', NULL, 'reitsum-', '53.32150000', '5.89000000'),
('Rekken', 'GE', 328, 'rekken-328', '52.09620000', '6.72420000'),
('Renesse', 'ZE', 335, 'renesse-335', '51.73120000', '3.76790000'),
('Renkum', 'GE', 328, 'renkum-328', '51.97750000', '5.74590000'),
('Renswoude', 'UT', 334, 'renswoude-334', '52.07350000', '5.53900000'),
('Ressen', 'GE', 328, 'ressen-328', '51.89050000', '5.86940000'),
('Retranchement', 'ZE', 335, 'retranchement-335', '51.35520000', '3.38360000'),
('Reusel', 'NB', 331, 'reusel-331', '51.36110000', '5.16420000'),
('Reutum', 'OV', 333, 'reutum-333', '52.38460000', '6.84310000'),
('Reuver', 'LI', 330, 'reuver-330', '51.28290000', '6.07890000'),
('Rha', 'GE', 328, 'rha-328', '52.05360000', '6.14900000'),
('Rheden', 'GE', 328, 'rheden-328', '52.00540000', '6.02920000'),
('Rhee', 'DR', 326, 'rhee-326', '53.03360000', '6.57100000'),
('Rheeze', 'OV', 333, 'rheeze-333', '52.54730000', '6.57740000'),
('Rheezerveen', 'OV', 333, 'rheezerveen-333', '52.57300000', '6.53930000'),
('Rhenen', 'UT', 334, 'rhenen-334', '51.96550000', '5.57070000'),
('Rhenoy', 'GE', 328, 'rhenoy-328', '51.88650000', '5.15210000'),
('Rhoon', 'ZH', 336, 'rhoon-336', '51.85640000', '4.42430000'),
('Ridderkerk', 'ZH', 336, 'ridderkerk-336', '51.86810000', '4.59620000'),
('Ried', '', NULL, 'ried-', '53.22300000', '5.59160000'),
('Riel', 'NB', 331, 'riel-331', '51.51130000', '5.02140000'),
('Rien', '', NULL, 'rien-', '53.09540000', '5.65790000'),
('Riethoven', 'NB', 331, 'riethoven-331', '51.35550000', '5.38420000'),
('Rietmolen', 'GE', 328, 'rietmolen-328', '52.14430000', '6.65840000'),
('Rijen', 'NB', 331, 'rijen-331', '51.58860000', '4.91820000'),
('Rijkevoort', 'NB', 331, 'rijkevoort-331', '51.65830000', '5.88670000'),
('Rijkevoort-De Walsert', 'NB', 331, 'rijkevoort-de-walsert-331', '51.65060000', '5.85960000'),
('Rijnsaterwoude', 'ZH', 336, 'rijnsaterwoude-336', '52.19540000', '4.67080000'),
('Rijnsburg', 'ZH', 336, 'rijnsburg-336', '52.19060000', '4.44050000'),
('Rijpwetering', 'ZH', 336, 'rijpwetering-336', '52.19360000', '4.58360000'),
('Rijs', '', NULL, 'rijs-', '52.86560000', '5.49620000'),
('Rijsbergen', 'NB', 331, 'rijsbergen-331', '51.51650000', '4.69790000'),
('Rijsenhout', 'NH', 332, 'rijsenhout-332', '52.25960000', '4.71240000'),
('Rijssen', 'OV', 333, 'rijssen-333', '52.30660000', '6.52500000'),
('Rijswijk ', 'GE', 328, 'rijswijk-gld-328', '51.95650000', '5.35800000'),
('Rijswijk ', 'NB', 331, 'rijswijk-nb-331', '51.79790000', '5.02320000'),
('Rijswijk', 'ZH', 336, 'rijswijk-336', '52.05770000', '4.34110000'),
('Rilland', 'ZE', 335, 'rilland-335', '51.41680000', '4.18350000'),
('Rinsumageast', '', NULL, 'rinsumageast-', '53.29600000', '5.94710000'),
('Ritthem', 'ZE', 335, 'ritthem-335', '51.45690000', '3.64670000'),
('Rockanje', 'ZH', 336, 'rockanje-336', '51.87430000', '4.07190000'),
('Roden', 'DR', 326, 'roden-326', '53.13800000', '6.42230000'),
('Roderesch', 'DR', 326, 'roderesch-326', '53.11430000', '6.42130000'),
('Roderwolde', 'DR', 326, 'roderwolde-326', '53.16980000', '6.46890000'),
('Roelofarendsveen', 'ZH', 336, 'roelofarendsveen-336', '52.20090000', '4.63030000'),
('Roermond', 'LI', 330, 'roermond-330', '51.19360000', '5.98640000'),
('Rogat', 'DR', 326, 'rogat-326', '52.68780000', '6.26740000'),
('Roggel', 'LI', 330, 'roggel-330', '51.26620000', '5.92580000'),
('Rohel', '', NULL, 'rohel-', '52.92240000', '5.82560000'),
('Rolde', 'DR', 326, 'rolde-326', '52.98300000', '6.65180000'),
('Roodeschool', 'GR', 329, 'roodeschool-329', '53.41930000', '6.77080000'),
('Roosendaal', 'NB', 331, 'roosendaal-331', '51.53310000', '4.45910000'),
('Roosteren', 'LI', 330, 'roosteren-330', '51.08110000', '5.81640000'),
('Rosmalen', 'NB', 331, 'rosmalen-331', '51.74820000', '5.37510000'),
('Rossum', 'GE', 328, 'rossum-328', '51.80060000', '5.32950000'),
('Rossum', 'OV', 333, 'rossum-333', '52.35270000', '6.92530000'),
('Roswinkel', 'DR', 326, 'roswinkel-326', '52.83990000', '7.03100000'),
('Rotstergaast', '', NULL, 'rotstergaast-', '52.91140000', '5.90840000'),
('Rotsterhaule', '', NULL, 'rotsterhaule-', '52.92670000', '5.84920000'),
('Rotterdam', 'ZH', 336, 'rotterdam-336', '51.91970000', '4.48750000'),
('Rotterdam-Albrandswaard', 'ZH', 336, 'rotterdam-albrandswaard-336', '51.86980000', '4.41800000'),
('Rottevalle', '', NULL, 'rottevalle-', '53.14540000', '6.10350000'),
('Rottum', '', NULL, 'rottum-', '52.93570000', '5.89530000'),
('Rottum', 'GR', 329, 'rottum-329', '53.38250000', '6.62080000'),
('Rouveen', 'OV', 333, 'rouveen-333', '52.61460000', '6.18290000'),
('Rozenburg', 'NH', 332, 'rozenburg-332', '52.28060000', '4.73680000'),
('Rozenburg', 'ZH', 336, 'rozenburg-336', '51.90460000', '4.24610000'),
('Rozendaal', 'GE', 328, 'rozendaal-328', '52.00370000', '5.96120000'),
('Rucphen', 'NB', 331, 'rucphen-331', '51.53140000', '4.55560000'),
('Ruigahuizen', '', NULL, 'ruigahuizen-', '52.88480000', '5.57250000'),
('Ruinen', 'DR', 326, 'ruinen-326', '52.76150000', '6.36130000'),
('Ruinerwold', 'DR', 326, 'ruinerwold-326', '52.72570000', '6.25860000'),
('Rumpt', 'GE', 328, 'rumpt-328', '51.88170000', '5.17790000'),
('Rutten', 'FL', 327, 'rutten-327', '52.80800000', '5.70280000'),
('Ruurlo', 'GE', 328, 'ruurlo-328', '52.08270000', '6.45230000'),
('Ryptsjerk', '', NULL, 'ryptsjerk-', '53.22540000', '5.91410000'),
('Saaksum', 'GR', 329, 'saaksum-329', '53.31440000', '6.41880000'),
('Saasveld', 'OV', 333, 'saasveld-333', '52.33400000', '6.80450000'),
('Saaxumhuizen', 'GR', 329, 'saaxumhuizen-329', '53.38150000', '6.48570000'),
('Sambeek', 'NB', 331, 'sambeek-331', '51.63490000', '5.96470000'),
('Sandfirden', '', NULL, 'sandfirden-', '52.98820000', '5.51880000'),
('Santpoort-Noord', 'NH', 332, 'santpoort-noord-332', '52.43390000', '4.64180000'),
('Santpoort-Zuid', 'NH', 332, 'santpoort-zuid-332', '52.41890000', '4.63050000'),
('Sappemeer', 'GR', 329, 'sappemeer-329', '53.16370000', '6.78750000'),
('Sas van Gent', 'ZE', 335, 'sas-van-gent-335', '51.23290000', '3.79650000'),
('Sassenheim', 'ZH', 336, 'sassenheim-336', '52.22360000', '4.51630000'),
('Sauwerd', 'GR', 329, 'sauwerd-329', '53.29350000', '6.53550000'),
('Schagen', 'NH', 332, 'schagen-332', '52.79110000', '4.80070000'),
('Schagerbrug', 'NH', 332, 'schagerbrug-332', '52.80370000', '4.75610000'),
('Schaijk', 'NB', 331, 'schaijk-331', '51.74350000', '5.63270000'),
('Schalkhaar', 'OV', 333, 'schalkhaar-333', '52.27030000', '6.19820000'),
('Schalkwijk', 'UT', 334, 'schalkwijk-334', '51.99120000', '5.19090000'),
('Schalsum', '', NULL, 'schalsum-', '53.19730000', '5.57390000'),
('Schardam', 'NH', 332, 'schardam-332', '52.59720000', '5.01600000'),
('Scharendijke', 'ZE', 335, 'scharendijke-335', '51.73450000', '3.84540000'),
('Scharmer', 'GR', 329, 'scharmer-329', '53.19810000', '6.70660000'),
('Scharnegoutum', '', NULL, 'scharnegoutum-', '53.06170000', '5.67810000'),
('Scharsterbrug', '', NULL, 'scharsterbrug-', '52.94440000', '5.78090000'),
('Scharwoude', 'NH', 332, 'scharwoude-332', '52.62180000', '5.01290000'),
('Scheemda', 'GR', 329, 'scheemda-329', '53.17360000', '6.97390000'),
('Scheerwolde', 'OV', 333, 'scheerwolde-333', '52.76060000', '6.01860000'),
('Schellinkhout', 'NH', 332, 'schellinkhout-332', '52.63700000', '5.12240000'),
('Schelluinen', 'ZH', 336, 'schelluinen-336', '51.84470000', '4.92570000'),
('Schermerhorn', 'NH', 332, 'schermerhorn-332', '52.60060000', '4.88890000'),
('Scherpenisse', 'ZE', 335, 'scherpenisse-335', '51.54470000', '4.10080000'),
('Scherpenzeel', '', NULL, 'scherpenzeel-', '52.83040000', '5.87200000'),
('Scherpenzeel', 'GE', 328, 'scherpenzeel-328', '52.08060000', '5.48870000'),
('Schettens', '', NULL, 'schettens-', '53.08160000', '5.48250000'),
('Scheulder', 'LI', 330, 'scheulder-330', '50.82890000', '5.84410000'),
('Schiedam', 'ZH', 336, 'schiedam-336', '51.91620000', '4.39910000'),
('Schiermonnikoog', '', NULL, 'schiermonnikoog-', '53.48060000', '6.16230000'),
('Schijf', 'NB', 331, 'schijf-331', '51.49770000', '4.55360000'),
('Schijndel', 'NB', 331, 'schijndel-331', '51.61890000', '5.42730000'),
('Schildwolde', 'GR', 329, 'schildwolde-329', '53.22150000', '6.80520000'),
('Schimmert', 'LI', 330, 'schimmert-330', '50.90360000', '5.82130000'),
('Schin op Geul', 'LI', 330, 'schin-op-geul-330', '50.85220000', '5.86870000'),
('Schinnen', 'LI', 330, 'schinnen-330', '50.94110000', '5.88240000'),
('Schinveld', 'LI', 330, 'schinveld-330', '50.96860000', '5.98150000'),
('Schipborg', 'DR', 326, 'schipborg-326', '53.07320000', '6.67140000'),
('Schiphol', 'NH', 332, 'schiphol-332', '52.31080000', '4.80950000'),
('Schiphol-Rijk', 'NH', 332, 'schiphol-rijk-332', '52.27970000', '4.75510000'),
('Schipluiden', 'ZH', 336, 'schipluiden-336', '51.97490000', '4.31800000'),
('Schokland', 'FL', 327, 'schokland-327', '52.64440000', '5.77540000'),
('Schoondijke', 'ZE', 335, 'schoondijke-335', '51.35490000', '3.55580000'),
('Schoonebeek', 'DR', 326, 'schoonebeek-326', '52.66460000', '6.88320000'),
('Schoonhoven', 'ZH', 336, 'schoonhoven-336', '51.94870000', '4.84890000'),
('Schoonloo', 'DR', 326, 'schoonloo-326', '52.90980000', '6.70840000'),
('Schoonoord', 'DR', 326, 'schoonoord-326', '52.84420000', '6.75660000'),
('Schoonrewoerd', 'ZH', 336, 'schoonrewoerd-336', '51.92280000', '5.11770000'),
('Schoorl', 'NH', 332, 'schoorl-332', '52.70590000', '4.69390000'),
('Schore', 'ZE', 335, 'schore-335', '51.46260000', '3.99790000'),
('Schouwerzijl', 'GR', 329, 'schouwerzijl-329', '53.33130000', '6.44910000'),
('Schraard', '', NULL, 'schraard-', '53.08020000', '5.45220000'),
('Schuinesloot', 'OV', 333, 'schuinesloot-333', '52.64650000', '6.55390000'),
('Sebaldeburen', 'GR', 329, 'sebaldeburen-329', '53.22090000', '6.30760000'),
('Sellingen', 'GR', 329, 'sellingen-329', '52.94970000', '7.13720000'),
('Serooskerke', 'ZE', 335, 'serooskerke-335', '51.54890000', '3.59550000'),
('Sevenum', 'LI', 330, 'sevenum-330', '51.40850000', '6.03270000'),
('Sexbierum', '', NULL, 'sexbierum-', '53.21750000', '5.48490000'),
('Sibculo', 'OV', 333, 'sibculo-333', '52.48090000', '6.63550000'),
('Sibrandabuorren', '', NULL, 'sibrandabuorren-', '53.06710000', '5.72050000'),
('Sibrandahûs', '', NULL, 'sibrandahus-', '53.31470000', '5.95070000'),
('Siddeburen', 'GR', 329, 'siddeburen-329', '53.24870000', '6.86810000'),
('Siebengewald', 'LI', 330, 'siebengewald-330', '51.65050000', '6.09810000'),
('Siegerswoude', '', NULL, 'siegerswoude-', '53.10180000', '6.24360000'),
('Sijbekarspel', 'NH', 332, 'sijbekarspel-332', '52.70510000', '5.00360000'),
('Silvolde', 'GE', 328, 'silvolde-328', '51.90940000', '6.38770000'),
('Simonshaven', 'ZH', 336, 'simonshaven-336', '51.82390000', '4.28270000'),
('Simpelveld', 'LI', 330, 'simpelveld-330', '50.83550000', '5.98040000'),
('Sinderen', 'GE', 328, 'sinderen-328', '51.91610000', '6.45160000'),
('Sint Agatha', 'NB', 331, 'sint-agatha-331', '51.71160000', '5.90910000'),
('Sint Annen', 'GR', 329, 'sint-annen-329', '53.29780000', '6.66480000'),
('Sint Anthonis', 'NB', 331, 'sint-anthonis-331', '51.62560000', '5.88100000'),
('Sint Geertruid', 'LI', 330, 'sint-geertruid-330', '50.79540000', '5.76970000'),
('Sint Hubert', 'NB', 331, 'sint-hubert-331', '51.67740000', '5.80800000'),
('Sint Jansklooster', 'OV', 333, 'sint-jansklooster-333', '52.67460000', '6.00440000'),
('Sint Jansteen', 'ZE', 335, 'sint-jansteen-335', '51.26240000', '4.05030000'),
('Sint Joost', 'LI', 330, 'sint-joost-330', '51.11440000', '5.90040000'),
('Sint Kruis', 'ZE', 335, 'sint-kruis-335', '51.27930000', '3.50440000'),
('Sint Maarten', 'NH', 332, 'sint-maarten-332', '52.76510000', '4.74960000'),
('Sint Maartensbrug', 'NH', 332, 'sint-maartensbrug-332', '52.78230000', '4.72110000'),
('Sint Maartensvlotbrug', 'NH', 332, 'sint-maartensvlotbrug-332', '52.78920000', '4.69710000'),
('Sint Nicolaasga', '', NULL, 'sint-nicolaasga-', '52.92510000', '5.74240000'),
('Sint Odiliënberg', 'LI', 330, 'sint-odilienberg-330', '51.14240000', '6.00100000'),
('Sint Pancras', 'NH', 332, 'sint-pancras-332', '52.66000000', '4.78600000'),
('Sint Philipsland', 'ZE', 335, 'sint-philipsland-335', '51.62160000', '4.15780000'),
('Sint-Annaland', 'ZE', 335, 'sint-annaland-335', '51.59980000', '4.10090000'),
('Sint-Maartensdijk', 'ZE', 335, 'sint-maartensdijk-335', '51.55000000', '4.07570000'),
('Sint-Michielsgestel', 'NB', 331, 'sint-michielsgestel-331', '51.64430000', '5.35090000'),
('Sint-Oedenrode', 'NB', 331, 'sint-oedenrode-331', '51.57150000', '5.46030000'),
('Sintjohannesga', '', NULL, 'sintjohannesga-', '52.93220000', '5.85990000'),
('Sirjansland', 'ZE', 335, 'sirjansland-335', '51.67560000', '4.03410000'),
('Sittard', 'LI', 330, 'sittard-330', '50.99860000', '5.86620000'),
('Skingen', '', NULL, 'skingen-', '53.20220000', '5.61790000'),
('Slagharen', 'OV', 333, 'slagharen-333', '52.62790000', '6.55470000'),
('Slappeterp', '', NULL, 'slappeterp-', '53.21630000', '5.62280000'),
('Sleen', 'DR', 326, 'sleen-326', '52.76960000', '6.80180000'),
('Sleeuwijk', 'NB', 331, 'sleeuwijk-331', '51.81540000', '4.95000000'),
('Slenaken', 'LI', 330, 'slenaken-330', '50.76910000', '5.85870000'),
('Sliedrecht', 'ZH', 336, 'sliedrecht-336', '51.82010000', '4.77220000'),
('Slijk-Ewijk', 'GE', 328, 'slijk-ewijk-328', '51.88710000', '5.78820000'),
('Slijkenburg', '', NULL, 'slijkenburg-', '52.80630000', '5.84440000'),
('Slochteren', 'GR', 329, 'slochteren-329', '53.21610000', '6.79840000'),
('Slootdorp', 'NH', 332, 'slootdorp-332', '52.84720000', '4.97020000'),
('Sloten', '', NULL, 'sloten-', '52.89490000', '5.64780000'),
('Sluis', 'ZE', 335, 'sluis-335', '51.30690000', '3.38770000'),
('Sluiskil', 'ZE', 335, 'sluiskil-335', '51.27930000', '3.83400000'),
('Smakt', 'LI', 330, 'smakt-330', '51.56410000', '6.00370000'),
('Smalle Ee', '', NULL, 'smalle-ee-', '53.10330000', '6.01570000'),
('Smallebrugge', '', NULL, 'smallebrugge-', '52.96040000', '5.63550000'),
('Smilde', 'DR', 326, 'smilde-326', '52.94740000', '6.44810000'),
('Snakkerburen', '', NULL, 'snakkerburen-', '53.22020000', '5.80960000'),
('Sneek', '', NULL, 'sneek-', '53.03230000', '5.65160000'),
('Snelrewaard', 'UT', 334, 'snelrewaard-334', '52.02950000', '4.88790000'),
('Snikzwaag', '', NULL, 'snikzwaag-', '52.98650000', '5.78820000'),
('Soerendonk', 'NB', 331, 'soerendonk-331', '51.30210000', '5.57590000'),
('Soest', 'UT', 334, 'soest-334', '52.18690000', '5.29080000'),
('Soesterberg', 'UT', 334, 'soesterberg-334', '52.11860000', '5.29020000'),
('Someren', 'NB', 331, 'someren-331', '51.38630000', '5.71540000'),
('Sommelsdijk', 'ZH', 336, 'sommelsdijk-336', '51.75650000', '4.15110000'),
('Son en Breugel', 'NB', 331, 'son-en-breugel-331', '51.52770000', '5.43210000'),
('Sondel', '', NULL, 'sondel-', '52.87100000', '5.59650000'),
('Sonnega', '', NULL, 'sonnega-', '52.86840000', '5.97250000'),
('Spaarndam', 'NH', 332, 'spaarndam-332', '52.41250000', '4.68860000'),
('Spaarndam gem. Haarlem', 'NH', 332, 'spaarndam-gem-haarlem-332', '52.41410000', '4.67750000'),
('Spanbroek', 'NH', 332, 'spanbroek-332', '52.69930000', '4.95220000'),
('Spanga', '', NULL, 'spanga-', '52.81840000', '5.87550000'),
('Spankeren', 'GE', 328, 'spankeren-328', '52.05810000', '6.11190000'),
('Spannum', '', NULL, 'spannum-', '53.14190000', '5.60660000'),
('Spaubeek', 'LI', 330, 'spaubeek-330', '50.94000000', '5.83910000'),
('Spier', 'DR', 326, 'spier-326', '52.81780000', '6.45920000'),
('Spierdijk', 'NH', 332, 'spierdijk-332', '52.64760000', '4.94000000'),
('Spijk', 'GE', 328, 'spijk-328', '51.84970000', '6.10730000'),
('Spijk Gn', 'GR', 329, 'spijk-gn-329', '53.39140000', '6.83900000'),
('Spijkenisse', 'ZH', 336, 'spijkenisse-336', '51.84850000', '4.32890000'),
('Spijkerboor', 'DR', 326, 'spijkerboor-326', '53.07740000', '6.76580000'),
('Spijkerboor', 'NH', 332, 'spijkerboor-332', '52.53080000', '4.84060000'),
('Sprang-Capelle', 'NB', 331, 'sprang-capelle-331', '51.67460000', '5.01870000'),
('Sprundel', 'NB', 331, 'sprundel-331', '51.53670000', '4.59980000'),
('Spui', 'ZE', 335, 'spui-335', '51.29750000', '3.87630000'),
('St. Willebrord', 'NB', 331, 'st-willebrord-331', '51.54950000', '4.58900000'),
('St.-Annaparochie', '', NULL, 'st-annaparochie-', '53.27730000', '5.65890000'),
('St.-Jacobiparochie', '', NULL, 'st-jacobiparochie-', '53.27680000', '5.60870000'),
('Stad aan ''t Haringvliet', 'ZH', 336, 'stad-aan-t-haringvliet-336', '51.73730000', '4.24000000'),
('Stadskanaal', 'GR', 329, 'stadskanaal-329', '52.99390000', '6.94950000'),
('Stampersgat', 'NB', 331, 'stampersgat-331', '51.61260000', '4.44160000'),
('Standdaarbuiten', 'NB', 331, 'standdaarbuiten-331', '51.61460000', '4.51430000'),
('Staphorst', 'OV', 333, 'staphorst-333', '52.64630000', '6.21140000'),
('Starnmeer', 'NH', 332, 'starnmeer-332', '52.54240000', '4.79840000'),
('Startenhuizen', 'GR', 329, 'startenhuizen-329', '53.36900000', '6.70980000'),
('Stavenisse', 'ZE', 335, 'stavenisse-335', '51.58680000', '4.01380000'),
('Stavoren', '', NULL, 'stavoren-', '52.88290000', '5.36400000'),
('Stedum', 'GR', 329, 'stedum-329', '53.32240000', '6.69460000'),
('Steenbergen', 'DR', 326, 'steenbergen-326', '53.10040000', '6.40530000'),
('Steenbergen', 'NB', 331, 'steenbergen-331', '51.58340000', '4.31970000'),
('Steendam', 'GR', 329, 'steendam-329', '53.27220000', '6.84080000'),
('Steenderen', 'GE', 328, 'steenderen-328', '52.06450000', '6.18730000'),
('Steenenkamer', 'GE', 328, 'steenenkamer-328', '52.24540000', '6.14790000'),
('Steensel', 'NB', 331, 'steensel-331', '51.37670000', '5.35430000'),
('Steenwijk', 'OV', 333, 'steenwijk-333', '52.78540000', '6.11750000'),
('Steenwijkerwold', 'OV', 333, 'steenwijkerwold-333', '52.80300000', '6.06220000'),
('Stegeren', 'OV', 333, 'stegeren-333', '52.54790000', '6.50040000'),
('Steggerda', '', NULL, 'steggerda-', '52.85560000', '6.07780000'),
('Stein', 'LI', 330, 'stein-330', '50.96860000', '5.76760000'),
('Stellendam', 'ZH', 336, 'stellendam-336', '51.80650000', '4.02650000'),
('Sterksel', 'NB', 331, 'sterksel-331', '51.35190000', '5.61630000'),
('Stevensbeek', 'NB', 331, 'stevensbeek-331', '51.60380000', '5.91740000'),
('Stevensweert', 'LI', 330, 'stevensweert-330', '51.13060000', '5.84970000'),
('Steyl', 'LI', 330, 'steyl-330', '51.33380000', '6.12780000'),
('Stieltjeskanaal', 'DR', 326, 'stieltjeskanaal-326', '52.67470000', '6.81230000'),
('Stiens', '', NULL, 'stiens-', '53.26110000', '5.76490000'),
('Stitswerd', 'GR', 329, 'stitswerd-329', '53.36080000', '6.59800000'),
('Stokkum', 'GE', 328, 'stokkum-328', '51.87870000', '6.22260000'),
('Stolwijk', 'ZH', 336, 'stolwijk-336', '51.97250000', '4.76860000'),
('Stompetoren', 'NH', 332, 'stompetoren-332', '52.60430000', '4.85800000'),
('Stoutenburg', 'UT', 334, 'stoutenburg-334', '52.15300000', '5.43590000'),
('Stoutenburg Noord', 'UT', 334, 'stoutenburg-noord-334', '52.16120000', '5.46430000'),
('Stramproy', 'LI', 330, 'stramproy-330', '51.19400000', '5.71540000'),
('Streefkerk', 'ZH', 336, 'streefkerk-336', '51.90140000', '4.74950000'),
('Striep', '', NULL, 'striep-', '53.37790000', '5.29240000'),
('Strijbeek', 'NB', 331, 'strijbeek-331', '51.51020000', '4.79650000'),
('Strijen', 'ZH', 336, 'strijen-336', '51.74410000', '4.55090000'),
('Strijensas', 'ZH', 336, 'strijensas-336', '51.71670000', '4.58360000'),
('Stroe', 'GE', 328, 'stroe-328', '52.18810000', '5.68690000'),
('Stroobos', '', NULL, 'stroobos-', '53.23880000', '6.21530000'),
('Stuifzand', 'DR', 326, 'stuifzand-326', '52.75180000', '6.50230000'),
('Sumar', '', NULL, 'sumar-', '53.17570000', '6.00620000'),
('Surhuisterveen', '', NULL, 'surhuisterveen-', '53.18100000', '6.16850000'),
('Surhuizum', '', NULL, 'surhuizum-', '53.20510000', '6.18330000'),
('Susteren', 'LI', 330, 'susteren-330', '51.06640000', '5.85950000'),
('Suwâld', '', NULL, 'suwald-', '53.17940000', '5.92440000'),
('Swalmen', 'LI', 330, 'swalmen-330', '51.23430000', '6.03280000'),
('Sweikhuizen', 'LI', 330, 'sweikhuizen-330', '50.95360000', '5.84820000'),
('Swichum', '', NULL, 'swichum-', '53.15310000', '5.82120000'),
('Swifterbant', 'FL', 327, 'swifterbant-327', '52.56710000', '5.64210000'),
('Swolgen', 'LI', 330, 'swolgen-330', '51.49310000', '6.11930000'),
('Taarlo', 'DR', 326, 'taarlo-326', '53.03370000', '6.62170000'),
('Teeffelen', 'NB', 331, 'teeffelen-331', '51.79770000', '5.49430000'),
('Teerns', '', NULL, 'teerns-', '53.18030000', '5.83420000'),
('Tegelen', 'LI', 330, 'tegelen-330', '51.34410000', '6.14030000'),
('Ten Boer', 'GR', 329, 'ten-boer-329', '53.27680000', '6.69560000'),
('Ten Post', 'GR', 329, 'ten-post-329', '53.29590000', '6.73030000'),
('Ter Aar', 'ZH', 336, 'ter-aar-336', '52.17740000', '4.71180000'),
('Ter Aard', 'DR', 326, 'ter-aard-326', '53.02710000', '6.54460000'),
('Ter Apel', 'GR', 329, 'ter-apel-329', '52.87700000', '7.05940000'),
('Ter Apelkanaal', 'GR', 329, 'ter-apelkanaal-329', '52.91460000', '7.04880000'),
('Ter Heijde', 'ZH', 336, 'ter-heijde-336', '52.03020000', '4.16850000'),
('Ter Idzard', '', NULL, 'ter-idzard-', '52.90510000', '6.03250000'),
('Terband', '', NULL, 'terband-', '52.98990000', '5.91130000'),
('Terborg', 'GE', 328, 'terborg-328', '51.93780000', '6.30860000'),
('Terheijden', 'NB', 331, 'terheijden-331', '51.64340000', '4.75400000'),
('Terherne', '', NULL, 'terherne-', '53.04030000', '5.78020000'),
('Terhole', 'ZE', 335, 'terhole-335', '51.31560000', '4.04110000'),
('Terkaple', '', NULL, 'terkaple-', '53.01270000', '5.78610000'),
('Termunten', 'GR', 329, 'termunten-329', '53.29550000', '7.04570000'),
('Termunterzijl', 'GR', 329, 'termunterzijl-329', '53.29990000', '7.03400000'),
('Ternaard', '', NULL, 'ternaard-', '53.38170000', '5.96530000'),
('Terneuzen', 'ZE', 335, 'terneuzen-335', '51.33640000', '3.82800000'),
('Teroele', '', NULL, 'teroele-', '52.93680000', '5.69450000'),
('Terschuur', 'GE', 328, 'terschuur-328', '52.16360000', '5.52080000'),
('Tersoal', '', NULL, 'tersoal-', '53.07400000', '5.73810000'),
('Terwispel', '', NULL, 'terwispel-', '53.02000000', '6.04390000'),
('Terwolde', 'GE', 328, 'terwolde-328', '52.27960000', '6.09170000'),
('Teteringen', 'NB', 331, 'teteringen-331', '51.61000000', '4.82200000'),
('Teuge', 'GE', 328, 'teuge-328', '52.23700000', '6.04760000'),
('Thesinge', 'GR', 329, 'thesinge-329', '53.26870000', '6.65130000'),
('Tholen', 'ZE', 335, 'tholen-335', '51.53430000', '4.21620000'),
('Thorn', 'LI', 330, 'thorn-330', '51.16390000', '5.84110000'),
('Tiel', 'GE', 328, 'tiel-328', '51.88650000', '5.43130000'),
('Tiendeveen', 'DR', 326, 'tiendeveen-326', '52.74910000', '6.54380000'),
('Tienhoven', 'UT', 334, 'tienhoven-334', '52.15140000', '5.08950000'),
('Tienhoven', 'ZH', 336, 'tienhoven-336', '51.95720000', '4.95090000'),
('Tienray', 'LI', 330, 'tienray-330', '51.49450000', '6.09430000'),
('Tijnje', '', NULL, 'tijnje-', '53.03280000', '5.98790000'),
('Tilburg', 'NB', 331, 'tilburg-331', '51.58550000', '5.08620000'),
('Tilligte', 'OV', 333, 'tilligte-333', '52.40520000', '6.95090000'),
('Tinallinge', 'GR', 329, 'tinallinge-329', '53.35500000', '6.54040000'),
('Tinte', 'ZH', 336, 'tinte-336', '51.89050000', '4.13460000'),
('Tirns', '', NULL, 'tirns-', '53.05950000', '5.62660000'),
('Tjalhuizum', '', NULL, 'tjalhuizum-', '53.04800000', '5.60970000'),
('Tjalleberd', '', NULL, 'tjalleberd-', '52.99860000', '5.94540000'),
('Tjerkgaast', '', NULL, 'tjerkgaast-', '52.90690000', '5.68040000'),
('Tjerkwerd', '', NULL, 'tjerkwerd-', '53.04110000', '5.50250000'),
('Tjuchem', 'GR', 329, 'tjuchem-329', '53.27810000', '6.88010000'),
('Tolbert', 'GR', 329, 'tolbert-329', '53.16650000', '6.36220000'),
('Toldijk', 'GE', 328, 'toldijk-328', '52.04810000', '6.22580000'),
('Tolkamer', 'GE', 328, 'tolkamer-328', '51.85490000', '6.10310000'),
('Tollebeek', 'FL', 327, 'tollebeek-327', '52.67870000', '5.66930000'),
('Tonden', 'GE', 328, 'tonden-328', '52.13520000', '6.12810000'),
('Toornwerd', 'GR', 329, 'toornwerd-329', '53.35400000', '6.63810000'),
('Tricht', 'GE', 328, 'tricht-328', '51.89140000', '5.26670000'),
('Triemen', '', NULL, 'triemen-', '53.27720000', '6.08950000'),
('Tripscompagnie', 'GR', 329, 'tripscompagnie-329', '53.14310000', '6.82510000'),
('Tubbergen', 'OV', 333, 'tubbergen-333', '52.40770000', '6.78550000'),
('Tuil', 'GE', 328, 'tuil-328', '51.82470000', '5.23990000'),
('Tuitjenhorn', 'NH', 332, 'tuitjenhorn-332', '52.73710000', '4.75280000'),
('Tuk', 'OV', 333, 'tuk-333', '52.79760000', '6.09400000'),
('Tull en ''t Waal', 'UT', 334, 'tull-en-t-waal-334', '51.99750000', '5.14110000'),
('Twello', 'GE', 328, 'twello-328', '52.24440000', '6.14290000'),
('Twijzel', '', NULL, 'twijzel-', '53.23570000', '6.09270000'),
('Twijzelerheide', '', NULL, 'twijzelerheide-', '53.24060000', '6.04860000'),
('Twisk', 'NH', 332, 'twisk-332', '52.74130000', '5.05500000'),
('Tynaarlo', 'DR', 326, 'tynaarlo-326', '53.07940000', '6.61570000'),
('Tytsjerk', '', NULL, 'tytsjerk-', '53.21040000', '5.91170000'),
('Tzum', '', NULL, 'tzum-', '53.15670000', '5.56430000'),
('Tzummarum', '', NULL, 'tzummarum-', '53.23750000', '5.54740000'),
('Ubbena', 'DR', 326, 'ubbena-326', '53.04960000', '6.57950000'),
('Ubbergen', 'GE', 328, 'ubbergen-328', '51.83580000', '5.90270000'),
('Uddel', 'GE', 328, 'uddel-328', '52.24750000', '5.77970000'),
('Uden', 'NB', 331, 'uden-331', '51.65930000', '5.61060000'),
('Udenhout', 'NB', 331, 'udenhout-331', '51.60970000', '5.14390000'),
('Uffelte', 'DR', 326, 'uffelte-326', '52.79020000', '6.28110000'),
('Ugchelen', 'GE', 328, 'ugchelen-328', '52.18460000', '5.93760000'),
('Uitdam', 'NH', 332, 'uitdam-332', '52.42540000', '5.07250000'),
('Uitgeest', 'NH', 332, 'uitgeest-332', '52.52530000', '4.70840000'),
('Uithoorn', 'NH', 332, 'uithoorn-332', '52.23900000', '4.82300000'),
('Uithuizen', 'GR', 329, 'uithuizen-329', '53.40790000', '6.67310000'),
('Uithuizermeeden', 'GR', 329, 'uithuizermeeden-329', '53.41570000', '6.72720000'),
('Uitwellingerga', '', NULL, 'uitwellingerga-', '53.00250000', '5.70780000'),
('Uitwijk', 'NB', 331, 'uitwijk-331', '51.78650000', '5.00760000'),
('Ulestraten', 'LI', 330, 'ulestraten-330', '50.90640000', '5.78350000'),
('Ulft', 'GE', 328, 'ulft-328', '51.89170000', '6.37710000'),
('Ulicoten', 'NB', 331, 'ulicoten-331', '51.45530000', '4.86100000'),
('Ulrum', 'GR', 329, 'ulrum-329', '53.35910000', '6.33470000'),
('Ulvenhout', 'NB', 331, 'ulvenhout-331', '51.54810000', '4.80090000'),
('Ulvenhout AC', 'NB', 331, 'ulvenhout-ac-331', '51.53780000', '4.81780000'),
('Ureterp', '', NULL, 'ureterp-', '53.09550000', '6.16890000'),
('Urk', 'FL', 327, 'urk-327', '52.66330000', '5.60900000'),
('Urmond', 'LI', 330, 'urmond-330', '50.99600000', '5.77230000'),
('Ursem', 'NH', 332, 'ursem-332', '52.62790000', '4.90190000'),
('Ursem gem. S', 'NH', 332, 'ursem-gem-s-332', '52.61610000', '4.86480000'),
('Usquert', 'GR', 329, 'usquert-329', '53.40390000', '6.61190000'),
('Utrecht', 'UT', 334, 'utrecht-334', '52.07930000', '5.06100000'),
('Vaals', 'LI', 330, 'vaals-330', '50.77200000', '6.01510000'),
('Vaassen', 'GE', 328, 'vaassen-328', '52.28950000', '5.97300000'),
('Valburg', 'GE', 328, 'valburg-328', '51.91190000', '5.78940000'),
('Valkenburg', 'LI', 330, 'valkenburg-330', '50.86500000', '5.82660000'),
('Valkenburg', 'ZH', 336, 'valkenburg-336', '52.17780000', '4.43650000'),
('Valkenswaard', 'NB', 331, 'valkenswaard-331', '51.35600000', '5.43060000'),
('Valthe', 'DR', 326, 'valthe-326', '52.84540000', '6.89230000'),
('Valthermond', 'DR', 326, 'valthermond-326', '52.88130000', '6.96040000'),
('Varik', 'GE', 328, 'varik-328', '51.82490000', '5.37000000'),
('Varsselder', 'GE', 328, 'varsselder-328', '51.88740000', '6.35720000'),
('Varsseveld', 'GE', 328, 'varsseveld-328', '51.94360000', '6.45840000'),
('Vasse', 'OV', 333, 'vasse-333', '52.43280000', '6.83050000'),
('Veelerveen', 'GR', 329, 'veelerveen-329', '53.05390000', '7.12940000'),
('Veen', 'NB', 331, 'veen-331', '51.77830000', '5.10310000'),
('Veendam', 'GR', 329, 'veendam-329', '53.10440000', '6.87690000'),
('Veenendaal', 'UT', 334, 'veenendaal-334', '52.02430000', '5.55720000'),
('Veenhuizen', 'DR', 326, 'veenhuizen-326', '53.01100000', '6.43790000'),
('Veeningen', 'DR', 326, 'veeningen-326', '52.66350000', '6.37590000'),
('Veenklooster', '', NULL, 'veenklooster-', '53.26440000', '6.10740000'),
('Veenoord', 'DR', 326, 'veenoord-326', '52.71100000', '6.84790000'),
('Veere', 'ZE', 335, 'veere-335', '51.54370000', '3.66110000'),
('Veessen', 'GE', 328, 'veessen-328', '52.37800000', '6.09250000'),
('Vegelinsoord', '', NULL, 'vegelinsoord-', '53.00080000', '5.85680000'),
('Veghel', 'NB', 331, 'veghel-331', '51.61930000', '5.54480000'),
('Velddriel', 'GE', 328, 'velddriel-328', '51.76850000', '5.30340000'),
('Velden', 'LI', 330, 'velden-330', '51.41450000', '6.16870000'),
('Veldhoven', 'NB', 331, 'veldhoven-331', '51.42030000', '5.40250000'),
('Velp', 'GE', 328, 'velp-328', '51.99820000', '5.97270000'),
('Velp', 'NB', 331, 'velp-331', '51.74970000', '5.71940000'),
('Velsen-Noord', 'NH', 332, 'velsen-noord-332', '52.47340000', '4.64140000'),
('Velsen-Zuid', 'NH', 332, 'velsen-zuid-332', '52.45350000', '4.65720000'),
('Velserbroek', 'NH', 332, 'velserbroek-332', '52.43320000', '4.65970000'),
('Ven-Zelderheide', 'LI', 330, 'ven-zelderheide-330', '51.71340000', '6.02150000'),
('Venebrugge', 'OV', 333, 'venebrugge-333', '52.55870000', '6.67550000'),
('Venhorst', 'NB', 331, 'venhorst-331', '51.60900000', '5.73580000'),
('Venhuizen', 'NH', 332, 'venhuizen-332', '52.66630000', '5.21120000'),
('Venlo', 'LI', 330, 'venlo-330', '51.37110000', '6.17170000'),
('Venray', 'LI', 330, 'venray-330', '51.52360000', '5.96790000'),
('Vessem', 'NB', 331, 'vessem-331', '51.42150000', '5.28580000'),
('Vethuizen', 'GE', 328, 'vethuizen-328', '51.91250000', '6.29930000'),
('Veulen', 'LI', 330, 'veulen-330', '51.48160000', '5.95710000'),
('Vianen', 'UT', 334, 'vianen-334', '51.99170000', '5.10200000'),
('Vianen NB', 'NB', 331, 'vianen-nb-331', '51.71760000', '5.85630000'),
('Vierakker', 'GE', 328, 'vierakker-328', '52.10280000', '6.24440000'),
('Vierhouten', 'GE', 328, 'vierhouten-328', '52.33490000', '5.82250000'),
('Vierhuizen', 'GR', 329, 'vierhuizen-329', '53.36210000', '6.29440000'),
('Vierlingsbeek', 'NB', 331, 'vierlingsbeek-331', '51.59550000', '6.00710000'),
('Vierpolders', 'ZH', 336, 'vierpolders-336', '51.90350000', '4.17380000'),
('Vijfhuizen', 'NH', 332, 'vijfhuizen-332', '52.35520000', '4.68070000'),
('Vijlen', 'LI', 330, 'vijlen-330', '50.78550000', '5.96140000'),
('Vilsteren', 'OV', 333, 'vilsteren-333', '52.50630000', '6.36870000'),
('Vinkega', '', NULL, 'vinkega-', '52.87150000', '6.12080000'),
('Vinkel', 'NB', 331, 'vinkel-331', '51.70960000', '5.46500000'),
('Vinkenbuurt', 'OV', 333, 'vinkenbuurt-333', '52.58220000', '6.36170000'),
('Vinkeveen', 'UT', 334, 'vinkeveen-334', '52.22020000', '4.93450000'),
('Visvliet', 'GR', 329, 'visvliet-329', '53.26510000', '6.24960000'),
('Vlaardingen', 'ZH', 336, 'vlaardingen-336', '51.90940000', '4.33790000'),
('Vlagtwedde', 'GR', 329, 'vlagtwedde-329', '53.02640000', '7.11460000'),
('Vledder', 'DR', 326, 'vledder-326', '52.85550000', '6.20760000'),
('Vledderveen', 'DR', 326, 'vledderveen-326', '52.87550000', '6.18720000'),
('Vledderveen', 'GR', 329, 'vledderveen-329', '52.98070000', '7.01120000'),
('Vleuten', 'UT', 334, 'vleuten-334', '52.10570000', '5.01330000'),
('Vlieland', '', NULL, 'vlieland-', '53.29860000', '5.06630000'),
('Vlierden', 'NB', 331, 'vlierden-331', '51.44610000', '5.75720000'),
('Vlijmen', 'NB', 331, 'vlijmen-331', '51.69480000', '5.21150000'),
('Vlissingen', 'ZE', 335, 'vlissingen-335', '51.44490000', '3.57510000'),
('Vlist', 'ZH', 336, 'vlist-336', '51.97630000', '4.82130000'),
('Vlodrop', 'LI', 330, 'vlodrop-330', '51.13570000', '6.08320000'),
('Voerendaal', 'LI', 330, 'voerendaal-330', '50.87390000', '5.93320000'),
('Vogelenzang', 'NH', 332, 'vogelenzang-332', '52.32050000', '4.57740000'),
('Vogelwaarde', 'ZE', 335, 'vogelwaarde-335', '51.32470000', '3.97710000'),
('Volendam', 'NH', 332, 'volendam-332', '52.49800000', '5.07070000'),
('Volkel', 'NB', 331, 'volkel-331', '51.64590000', '5.66140000'),
('Vollenhove', 'OV', 333, 'vollenhove-333', '52.67890000', '5.95600000'),
('Vondelingenplaat Rotterdam', 'ZH', 336, 'vondelingenplaat-rotterdam-336', '51.87230000', '4.33460000'),
('Voorburg', 'ZH', 336, 'voorburg-336', '52.07200000', '4.36900000'),
('Voorhout', 'ZH', 336, 'voorhout-336', '52.22460000', '4.48890000'),
('Voorschoten', 'ZH', 336, 'voorschoten-336', '52.12370000', '4.45190000'),
('Voorst', 'GE', 328, 'voorst-328', '52.17200000', '6.13720000');
INSERT INTO `cities` (`city_name`, `state`, `state_id`, `slug`, `lat`, `lng`) VALUES
('Voorthuizen', 'GE', 328, 'voorthuizen-328', '52.19480000', '5.66870000'),
('Vorchten', 'GE', 328, 'vorchten-328', '52.39640000', '6.10950000'),
('Vorden', 'GE', 328, 'vorden-328', '52.10460000', '6.31770000'),
('Vorstenbosch', 'NB', 331, 'vorstenbosch-331', '51.65490000', '5.55200000'),
('Vortum-Mullem', 'NB', 331, 'vortum-mullem-331', '51.61870000', '5.97560000'),
('Vragender', 'GE', 328, 'vragender-328', '51.98610000', '6.61260000'),
('Vredenheim', 'DR', 326, 'vredenheim-326', '52.94630000', '6.65460000'),
('Vredepeel', 'LI', 330, 'vredepeel-330', '51.54760000', '5.86630000'),
('Vreeland', 'UT', 334, 'vreeland-334', '52.23210000', '5.03280000'),
('Vries', 'DR', 326, 'vries-326', '53.07260000', '6.57680000'),
('Vriescheloo', 'GR', 329, 'vriescheloo-329', '53.07420000', '7.12610000'),
('Vriezenveen', 'OV', 333, 'vriezenveen-333', '52.40930000', '6.62140000'),
('Vroomshoop', 'OV', 333, 'vroomshoop-333', '52.46010000', '6.56640000'),
('Vrouwenakker', 'ZH', 336, 'vrouwenakker-336', '52.22730000', '4.78660000'),
('Vrouwenparochie', '', NULL, 'vrouwenparochie-', '53.27830000', '5.70410000'),
('Vrouwenpolder', 'ZE', 335, 'vrouwenpolder-335', '51.57950000', '3.61460000'),
('Vught', 'NB', 331, 'vught-331', '51.65740000', '5.29610000'),
('Vuren', 'GE', 328, 'vuren-328', '51.82720000', '5.05180000'),
('Waaksens', '', NULL, 'waaksens-', '53.10950000', '5.53830000'),
('Waal', 'ZH', 336, 'waal-336', '51.93870000', '4.89980000'),
('Waalre', 'NB', 331, 'waalre-331', '51.38890000', '5.44350000'),
('Waalwijk', 'NB', 331, 'waalwijk-331', '51.68730000', '5.05810000'),
('Waarde', 'ZE', 335, 'waarde-335', '51.41890000', '4.07180000'),
('Waardenburg', 'GE', 328, 'waardenburg-328', '51.83420000', '5.25520000'),
('Waarder', 'ZH', 336, 'waarder-336', '52.06020000', '4.82200000'),
('Waardhuizen', 'NB', 331, 'waardhuizen-331', '51.77700000', '5.00630000'),
('Waarland', 'NH', 332, 'waarland-332', '52.72750000', '4.82980000'),
('Waaxens', '', NULL, 'waaxens-', '53.35700000', '5.91960000'),
('Wachtum', 'DR', 326, 'wachtum-326', '52.72500000', '6.74790000'),
('Waddinxveen', 'ZH', 336, 'waddinxveen-336', '52.04520000', '4.65570000'),
('Wadenoijen', 'GE', 328, 'wadenoijen-328', '51.87130000', '5.36710000'),
('Wagenberg', 'NB', 331, 'wagenberg-331', '51.66450000', '4.74920000'),
('Wagenborgen', 'GR', 329, 'wagenborgen-329', '53.25490000', '6.93310000'),
('Wageningen', 'GE', 328, 'wageningen-328', '51.96560000', '5.66430000'),
('Walem', 'LI', 330, 'walem-330', '50.86390000', '5.87010000'),
('Walsoorden', 'ZE', 335, 'walsoorden-335', '51.38610000', '4.01830000'),
('Wâlterswâld', '', NULL, 'walterswald-', '53.29470000', '6.02910000'),
('Wamel', 'GE', 328, 'wamel-328', '51.84760000', '5.48230000'),
('Wanneperveen', 'OV', 333, 'wanneperveen-333', '52.69990000', '6.10750000'),
('Wanroij', 'NB', 331, 'wanroij-331', '51.65660000', '5.81930000'),
('Wanssum', 'LI', 330, 'wanssum-330', '51.53560000', '6.07570000'),
('Wânswert', '', NULL, 'wanswert-', '53.29740000', '5.84780000'),
('Wapenveld', 'GE', 328, 'wapenveld-328', '52.42070000', '6.08360000'),
('Wapse', 'DR', 326, 'wapse-326', '52.85810000', '6.26400000'),
('Wapserveen', 'DR', 326, 'wapserveen-326', '52.82370000', '6.22050000'),
('Warder', 'NH', 332, 'warder-332', '52.56320000', '5.02720000'),
('Warffum', 'GR', 329, 'warffum-329', '53.39200000', '6.55770000'),
('Warfhuizen', 'GR', 329, 'warfhuizen-329', '53.33910000', '6.42450000'),
('Warfstermolen', '', NULL, 'warfstermolen-', '53.29610000', '6.23470000'),
('Warmenhuizen', 'NH', 332, 'warmenhuizen-332', '52.72070000', '4.73430000'),
('Warmond', 'ZH', 336, 'warmond-336', '52.21490000', '4.51440000'),
('Warns', '', NULL, 'warns-', '52.87700000', '5.40760000'),
('Warnsveld', 'GE', 328, 'warnsveld-328', '52.13840000', '6.23180000'),
('Warstiens', '', NULL, 'warstiens-', '53.16220000', '5.86490000'),
('Warten', '', NULL, 'warten-', '53.14670000', '5.90020000'),
('Waskemeer', '', NULL, 'waskemeer-', '53.05510000', '6.28020000'),
('Waspik', 'NB', 331, 'waspik-331', '51.68480000', '4.94790000'),
('Wassenaar', 'ZH', 336, 'wassenaar-336', '52.14750000', '4.40890000'),
('Wateren', 'DR', 326, 'wateren-326', '52.91640000', '6.27260000'),
('Watergang', 'NH', 332, 'watergang-332', '52.43220000', '4.95400000'),
('Waterhuizen', 'GR', 329, 'waterhuizen-329', '53.18660000', '6.64830000'),
('Wateringen', 'ZH', 336, 'wateringen-336', '52.02390000', '4.27590000'),
('Waterlandkerkje', 'ZE', 335, 'waterlandkerkje-335', '51.31520000', '3.55440000'),
('Waverveen', 'UT', 334, 'waverveen-334', '52.23390000', '4.89580000'),
('Wedde', 'GR', 329, 'wedde-329', '53.07400000', '7.07720000'),
('Weerselo', 'OV', 333, 'weerselo-333', '52.35020000', '6.85910000'),
('Weert', 'LI', 330, 'weert-330', '51.25390000', '5.70650000'),
('Weesp', 'NH', 332, 'weesp-332', '52.30440000', '5.04510000'),
('Wehe-den Hoorn', 'GR', 329, 'wehe-den-hoorn-329', '53.35900000', '6.41980000'),
('Wehl', 'GE', 328, 'wehl-328', '51.96080000', '6.20600000'),
('Weidum', '', NULL, 'weidum-', '53.14660000', '5.74330000'),
('Weiteveen', 'DR', 326, 'weiteveen-326', '52.67210000', '6.98970000'),
('Wekerom', 'GE', 328, 'wekerom-328', '52.10980000', '5.71480000'),
('Well', 'GE', 328, 'well-328', '51.75030000', '5.19750000'),
('Well L', 'LI', 330, 'well-l-330', '51.55820000', '6.08970000'),
('Wellerlooi', 'LI', 330, 'wellerlooi-330', '51.53530000', '6.14300000'),
('Welsum', 'OV', 333, 'welsum-333', '52.33100000', '6.08860000'),
('Wemeldinge', 'ZE', 335, 'wemeldinge-335', '51.51740000', '3.99580000'),
('Wenum Wiesel', 'GE', 328, 'wenum-wiesel-328', '52.25500000', '5.95490000'),
('Wergea', '', NULL, 'wergea-', '53.15010000', '5.84520000'),
('Werkendam', 'NB', 331, 'werkendam-331', '51.80790000', '4.89300000'),
('Werkhoven', 'UT', 334, 'werkhoven-334', '52.02340000', '5.24350000'),
('Wernhout', 'NB', 331, 'wernhout-331', '51.46160000', '4.65710000'),
('Wervershoof', 'NH', 332, 'wervershoof-332', '52.73480000', '5.14780000'),
('Wesepe', 'OV', 333, 'wesepe-333', '52.33180000', '6.20760000'),
('Wessem', 'LI', 330, 'wessem-330', '51.16190000', '5.88010000'),
('West-Graftdijk', 'NH', 332, 'west-graftdijk-332', '52.55450000', '4.79610000'),
('West-Terschelling', '', NULL, 'west-terschelling-', '53.36660000', '5.22150000'),
('Westbeemster', 'NH', 332, 'westbeemster-332', '52.55940000', '4.88020000'),
('Westbroek', 'UT', 334, 'westbroek-334', '52.15090000', '5.12390000'),
('Westdorp', 'DR', 326, 'westdorp-326', '52.90610000', '6.76170000'),
('Westdorpe', 'ZE', 335, 'westdorpe-335', '51.23350000', '3.82930000'),
('Westendorp', 'GE', 328, 'westendorp-328', '51.95030000', '6.41690000'),
('Westerbeek', 'NB', 331, 'westerbeek-331', '51.58090000', '5.86430000'),
('Westerbork', 'DR', 326, 'westerbork-326', '52.85400000', '6.60750000'),
('Westerbroek', 'GR', 329, 'westerbroek-329', '53.18420000', '6.68420000'),
('Westeremden', 'GR', 329, 'westeremden-329', '53.34500000', '6.71040000'),
('Westergeest', '', NULL, 'westergeest-', '53.29340000', '6.08550000'),
('Westerhaar-Vriezenveensewijk', 'OV', 333, 'westerhaar-vriezenveensewijk-333', '52.45790000', '6.62220000'),
('Westerhoven', 'NB', 331, 'westerhoven-331', '51.33050000', '5.40790000'),
('Westerland', 'NH', 332, 'westerland-332', '52.89230000', '4.92950000'),
('Westerlee', 'GR', 329, 'westerlee-329', '53.14620000', '6.98830000'),
('Westernieland', 'GR', 329, 'westernieland-329', '53.40250000', '6.48150000'),
('Westervelde', 'DR', 326, 'westervelde-326', '53.05400000', '6.43970000'),
('Westervoort', 'GE', 328, 'westervoort-328', '51.95890000', '5.97030000'),
('Westerwijtwerd', 'GR', 329, 'westerwijtwerd-329', '53.33270000', '6.64580000'),
('Westhem', '', NULL, 'westhem-', '53.01610000', '5.54770000'),
('Westhoek', '', NULL, 'westhoek-', '53.27850000', '5.57600000'),
('Westkapelle', 'ZE', 335, 'westkapelle-335', '51.52760000', '3.44460000'),
('Westknollendam', 'NH', 332, 'westknollendam-332', '52.51820000', '4.78180000'),
('Westmaas', 'ZH', 336, 'westmaas-336', '51.78690000', '4.47280000'),
('Westwoud', 'NH', 332, 'westwoud-332', '52.68460000', '5.13340000'),
('Westzaan', 'NH', 332, 'westzaan-332', '52.45360000', '4.77460000'),
('Wetering', 'OV', 333, 'wetering-333', '52.76250000', '5.99080000'),
('Weteringbrug', 'NH', 332, 'weteringbrug-332', '52.22210000', '4.64510000'),
('Wetsens', '', NULL, 'wetsens-', '53.35000000', '6.03360000'),
('Wetsinge', 'GR', 329, 'wetsinge-329', '53.30300000', '6.53120000'),
('Weurt', 'GE', 328, 'weurt-328', '51.85550000', '5.81320000'),
('Wezep', 'GE', 328, 'wezep-328', '52.46250000', '5.99960000'),
('Wezup', 'DR', 326, 'wezup-326', '52.81450000', '6.71870000'),
('Wezuperbrug', 'DR', 326, 'wezuperbrug-326', '52.84060000', '6.72560000'),
('Wichmond', 'GE', 328, 'wichmond-328', '52.08790000', '6.26180000'),
('Wier', '', NULL, 'wier-', '53.25140000', '5.62430000'),
('Wierden', 'OV', 333, 'wierden-333', '52.36380000', '6.59690000'),
('Wieringerwaard', 'NH', 332, 'wieringerwaard-332', '52.83490000', '4.86430000'),
('Wieringerwerf', 'NH', 332, 'wieringerwerf-332', '52.85060000', '5.03340000'),
('Wierum', '', NULL, 'wierum-', '53.40040000', '6.01400000'),
('Wijchen', 'GE', 328, 'wijchen-328', '51.81380000', '5.72060000'),
('Wijckel', '', NULL, 'wijckel-', '52.88890000', '5.61500000'),
('Wijdenes', 'NH', 332, 'wijdenes-332', '52.64060000', '5.15940000'),
('Wijdewormer', 'NH', 332, 'wijdewormer-332', '52.50200000', '4.90500000'),
('Wijhe', 'OV', 333, 'wijhe-333', '52.38770000', '6.14470000'),
('Wijk aan Zee', 'NH', 332, 'wijk-aan-zee-332', '52.49330000', '4.59480000'),
('Wijk bij Duurstede', 'UT', 334, 'wijk-bij-duurstede-334', '51.97290000', '5.33140000'),
('Wijk en Aalburg', 'NB', 331, 'wijk-en-aalburg-331', '51.75830000', '5.12610000'),
('Wijlre', 'LI', 330, 'wijlre-330', '50.83600000', '5.89200000'),
('Wijnaldum', '', NULL, 'wijnaldum-', '53.19640000', '5.45900000'),
('Wijnandsrade', 'LI', 330, 'wijnandsrade-330', '50.90580000', '5.88650000'),
('Wijnbergen', 'GE', 328, 'wijnbergen-328', '51.93400000', '6.28040000'),
('Wijngaarden', 'ZH', 336, 'wijngaarden-336', '51.84500000', '4.76430000'),
('Wijnjewoude', '', NULL, 'wijnjewoude-', '53.05350000', '6.20180000'),
('Wijster', 'DR', 326, 'wijster-326', '52.81440000', '6.51770000'),
('Wilbertoord', 'NB', 331, 'wilbertoord-331', '51.65600000', '5.77360000'),
('Wildervank', 'GR', 329, 'wildervank-329', '53.07890000', '6.86090000'),
('Wilhelminadorp', 'ZE', 335, 'wilhelminadorp-335', '51.52920000', '3.89590000'),
('Wilhelminaoord', 'DR', 326, 'wilhelminaoord-326', '52.85720000', '6.16190000'),
('Willemsoord', 'OV', 333, 'willemsoord-333', '52.82540000', '6.06220000'),
('Willemstad', 'NB', 331, 'willemstad-331', '51.68600000', '4.43980000'),
('Wilnis', 'UT', 334, 'wilnis-334', '52.19740000', '4.89310000'),
('Wilp', 'GE', 328, 'wilp-328', '52.21560000', '6.11970000'),
('Wilsum', 'OV', 333, 'wilsum-333', '52.52910000', '5.96670000'),
('Winde', 'DR', 326, 'winde-326', '53.12740000', '6.52430000'),
('Windraak', 'LI', 330, 'windraak-330', '50.97270000', '5.88690000'),
('Winkel', 'NH', 332, 'winkel-332', '52.75410000', '4.90300000'),
('Winneweer', 'GR', 329, 'winneweer-329', '53.31020000', '6.74430000'),
('Winschoten', 'GR', 329, 'winschoten-329', '53.14340000', '7.03440000'),
('Winssen', 'GE', 328, 'winssen-328', '51.88000000', '5.70490000'),
('Winsum', '', NULL, 'winsum-', '53.15130000', '5.63190000'),
('Winsum', 'GR', 329, 'winsum-329', '53.33110000', '6.52150000'),
('Wintelre', 'NB', 331, 'wintelre-331', '51.44570000', '5.33950000'),
('Winterswijk', 'GE', 328, 'winterswijk-328', '51.97120000', '6.72340000'),
('Winterswijk Brinkheurne', 'GE', 328, 'winterswijk-brinkheurne-328', '51.95240000', '6.74930000'),
('Winterswijk Corle', 'GE', 328, 'winterswijk-corle-328', '51.96630000', '6.66050000'),
('Winterswijk Henxel', 'GE', 328, 'winterswijk-henxel-328', '51.98390000', '6.76160000'),
('Winterswijk Huppel', 'GE', 328, 'winterswijk-huppel-328', '52.00070000', '6.75610000'),
('Winterswijk Kotten', 'GE', 328, 'winterswijk-kotten-328', '51.94020000', '6.77150000'),
('Winterswijk Meddo', 'GE', 328, 'winterswijk-meddo-328', '52.01070000', '6.70280000'),
('Winterswijk Miste', 'GE', 328, 'winterswijk-miste-328', '51.94340000', '6.66570000'),
('Winterswijk Ratum', 'GE', 328, 'winterswijk-ratum-328', '51.97960000', '6.80460000'),
('Winterswijk Woold', 'GE', 328, 'winterswijk-woold-328', '51.92960000', '6.71560000'),
('Wirdum', '', NULL, 'wirdum-', '53.15010000', '5.80270000'),
('Wirdum Gn', 'GR', 329, 'wirdum-gn-329', '53.31830000', '6.78750000'),
('Wissenkerke', 'ZE', 335, 'wissenkerke-335', '51.58360000', '3.74820000'),
('Witharen', 'OV', 333, 'witharen-333', '52.56290000', '6.38900000'),
('Witmarsum', '', NULL, 'witmarsum-', '53.10150000', '5.46860000'),
('Witte Paarden', 'OV', 333, 'witte-paarden-333', '52.80900000', '6.07890000'),
('Wittelte', 'DR', 326, 'wittelte-326', '52.83060000', '6.29670000'),
('Wittem', 'LI', 330, 'wittem-330', '50.80950000', '5.93770000'),
('Witteveen', 'DR', 326, 'witteveen-326', '52.82370000', '6.66010000'),
('Wiuwert', '', NULL, 'wiuwert-', '53.10850000', '5.69190000'),
('Wjelsryp', '', NULL, 'wjelsryp-', '53.16680000', '5.60460000'),
('Woensdrecht', 'NB', 331, 'woensdrecht-331', '51.42950000', '4.30370000'),
('Woerden', 'UT', 334, 'woerden-334', '52.08590000', '4.88470000'),
('Woerdense Verlaat', 'ZH', 336, 'woerdense-verlaat-336', '52.14940000', '4.85570000'),
('Wognum', 'NH', 332, 'wognum-332', '52.68270000', '5.02070000'),
('Woldendorp', 'GR', 329, 'woldendorp-329', '53.27220000', '7.03060000'),
('Wolfheze', 'GE', 328, 'wolfheze-328', '52.00660000', '5.79230000'),
('Wolphaartsdijk', 'ZE', 335, 'wolphaartsdijk-335', '51.50870000', '3.78800000'),
('Wolsum', '', NULL, 'wolsum-', '53.03820000', '5.54890000'),
('Woltersum', 'GR', 329, 'woltersum-329', '53.27200000', '6.73160000'),
('Wolvega', '', NULL, 'wolvega-', '52.87390000', '5.99760000'),
('Wommels', '', NULL, 'wommels-', '53.10820000', '5.58840000'),
('Wons', '', NULL, 'wons-', '53.08390000', '5.42280000'),
('Workum', '', NULL, 'workum-', '52.97670000', '5.44450000'),
('Wormer', 'NH', 332, 'wormer-332', '52.49660000', '4.81010000'),
('Wormerveer', 'NH', 332, 'wormerveer-332', '52.49500000', '4.79080000'),
('Woubrugge', 'ZH', 336, 'woubrugge-336', '52.17010000', '4.63480000'),
('Woudbloem', 'GR', 329, 'woudbloem-329', '53.21910000', '6.73990000'),
('Woudenberg', 'UT', 334, 'woudenberg-334', '52.08110000', '5.42180000'),
('Woudrichem', 'NB', 331, 'woudrichem-331', '51.81260000', '4.99720000'),
('Woudsend', '', NULL, 'woudsend-', '52.94230000', '5.62940000'),
('Wouw', 'NB', 331, 'wouw-331', '51.52240000', '4.39010000'),
('Wouwse Plantage', 'NB', 331, 'wouwse-plantage-331', '51.48420000', '4.39430000'),
('Wyns', '', NULL, 'wyns-', '53.26270000', '5.83820000'),
('Wytgaard', '', NULL, 'wytgaard-', '53.13970000', '5.78240000'),
('Yde', 'DR', 326, 'yde-326', '53.11480000', '6.59030000'),
('Yerseke', 'ZE', 335, 'yerseke-335', '51.49260000', '4.04660000'),
('Ypecolsga', '', NULL, 'ypecolsga-', '52.93540000', '5.61070000'),
('Ysbrechtum', '', NULL, 'ysbrechtum-', '53.04210000', '5.63240000'),
('Ysselsteyn', 'LI', 330, 'ysselsteyn-330', '51.48800000', '5.89790000'),
('Zaamslag', 'ZE', 335, 'zaamslag-335', '51.31630000', '3.91530000'),
('Zaandam', 'NH', 332, 'zaandam-332', '52.43760000', '4.83270000'),
('Zaandijk', 'NH', 332, 'zaandijk-332', '52.46990000', '4.80210000'),
('Zalk', 'OV', 333, 'zalk-333', '52.51800000', '6.00340000'),
('Zaltbommel', 'GE', 328, 'zaltbommel-328', '51.80700000', '5.24660000'),
('Zandberg', 'DR', 326, 'zandberg-326', '52.91790000', '7.02910000'),
('Zandeweer', 'GR', 329, 'zandeweer-329', '53.38750000', '6.67980000'),
('Zandhuizen', '', NULL, 'zandhuizen-', '52.91150000', '6.15070000'),
('Zandpol', 'DR', 326, 'zandpol-326', '52.69390000', '6.86420000'),
('Zandvoort', 'NH', 332, 'zandvoort-332', '52.37890000', '4.54020000'),
('Zeddam', 'GE', 328, 'zeddam-328', '51.90330000', '6.26010000'),
('Zeegse', 'DR', 326, 'zeegse-326', '53.06840000', '6.65060000'),
('Zeeland', 'NB', 331, 'zeeland-331', '51.69580000', '5.67720000'),
('Zeerijp', 'GR', 329, 'zeerijp-329', '53.35430000', '6.78700000'),
('Zeewolde', 'FL', 327, 'zeewolde-327', '52.33320000', '5.53760000'),
('Zegge', 'NB', 331, 'zegge-331', '51.55690000', '4.51650000'),
('Zegveld', 'UT', 334, 'zegveld-334', '52.13260000', '4.86560000'),
('Zeijen', 'DR', 326, 'zeijen-326', '53.04730000', '6.54480000'),
('Zeijerveen', 'DR', 326, 'zeijerveen-326', '53.01350000', '6.52100000'),
('Zeijerveld', 'DR', 326, 'zeijerveld-326', '53.03360000', '6.51930000'),
('Zeist', 'UT', 334, 'zeist-334', '52.08640000', '5.24400000'),
('Zelhem', 'GE', 328, 'zelhem-328', '52.00770000', '6.34650000'),
('Zenderen', 'OV', 333, 'zenderen-333', '52.31220000', '6.70880000'),
('Zennewijnen', 'GE', 328, 'zennewijnen-328', '51.85960000', '5.40790000'),
('Zetten', 'GE', 328, 'zetten-328', '51.92750000', '5.71360000'),
('Zevenaar', 'GE', 328, 'zevenaar-328', '51.92930000', '6.07710000'),
('Zevenbergen', 'NB', 331, 'zevenbergen-331', '51.64580000', '4.59840000'),
('Zevenbergschen Hoek', 'NB', 331, 'zevenbergschen-hoek-331', '51.67270000', '4.67630000'),
('Zevenhoven', 'ZH', 336, 'zevenhoven-336', '52.18440000', '4.79340000'),
('Zevenhuizen', 'GR', 329, 'zevenhuizen-329', '53.12200000', '6.34380000'),
('Zevenhuizen', 'ZH', 336, 'zevenhuizen-336', '52.00880000', '4.58240000'),
('Zierikzee', 'ZE', 335, 'zierikzee-335', '51.65030000', '3.91650000'),
('Zieuwent', 'GE', 328, 'zieuwent-328', '52.00640000', '6.51870000'),
('Zijderveld', 'UT', 334, 'zijderveld-334', '51.94230000', '5.13700000'),
('Zijdewind', 'NH', 332, 'zijdewind-332', '52.74140000', '4.83910000'),
('Zijldijk', 'GR', 329, 'zijldijk-329', '53.39390000', '6.75860000'),
('Zoelen', 'GE', 328, 'zoelen-328', '51.91670000', '5.40820000'),
('Zoelmond', 'GE', 328, 'zoelmond-328', '51.94190000', '5.30930000'),
('Zoetermeer', 'ZH', 336, 'zoetermeer-336', '52.06160000', '4.49270000'),
('Zoeterwoude', 'ZH', 336, 'zoeterwoude-336', '52.11920000', '4.49840000'),
('Zonnemaire', 'ZE', 335, 'zonnemaire-335', '51.71370000', '3.94980000'),
('Zorgvlied', 'DR', 326, 'zorgvlied-326', '52.92080000', '6.25360000'),
('Zoutelande', 'ZE', 335, 'zoutelande-335', '51.50140000', '3.48070000'),
('Zoutkamp', 'GR', 329, 'zoutkamp-329', '53.33850000', '6.30410000'),
('Zuid-Beijerland', 'ZH', 336, 'zuid-beijerland-336', '51.75280000', '4.36320000'),
('Zuid-Scharwoude', 'NH', 332, 'zuid-scharwoude-332', '52.69160000', '4.80890000'),
('Zuidbroek', 'GR', 329, 'zuidbroek-329', '53.16490000', '6.86180000'),
('Zuiddorpe', 'ZE', 335, 'zuiddorpe-335', '51.24900000', '3.91200000'),
('Zuidermeer', 'NH', 332, 'zuidermeer-332', '52.66450000', '4.97690000'),
('Zuiderwoude', 'NH', 332, 'zuiderwoude-332', '52.43170000', '5.03760000'),
('Zuidhorn', 'GR', 329, 'zuidhorn-329', '53.24600000', '6.40160000'),
('Zuidlaarderveen', 'DR', 326, 'zuidlaarderveen-326', '53.10210000', '6.75010000'),
('Zuidland', 'ZH', 336, 'zuidland-336', '51.82180000', '4.25650000'),
('Zuidlaren', 'DR', 326, 'zuidlaren-326', '53.09200000', '6.67490000'),
('Zuidoostbeemster', 'NH', 332, 'zuidoostbeemster-332', '52.51950000', '4.94060000'),
('Zuidschermer', 'NH', 332, 'zuidschermer-332', '52.59450000', '4.81800000'),
('Zuidveen', 'OV', 333, 'zuidveen-333', '52.77660000', '6.11170000'),
('Zuidveld', 'DR', 326, 'zuidveld-326', '52.86590000', '6.63590000'),
('Zuidvelde', 'DR', 326, 'zuidvelde-326', '53.03930000', '6.46130000'),
('Zuidwolde', 'DR', 326, 'zuidwolde-326', '52.67070000', '6.42660000'),
('Zuidwolde', 'GR', 329, 'zuidwolde-329', '53.26180000', '6.59300000'),
('Zuidzande', 'ZE', 335, 'zuidzande-335', '51.34130000', '3.44990000'),
('Zuilichem', 'GE', 328, 'zuilichem-328', '51.80680000', '5.13390000'),
('Zuna', 'OV', 333, 'zuna-333', '52.33210000', '6.49760000'),
('Zundert', 'NB', 331, 'zundert-331', '51.47030000', '4.65960000'),
('Zurich', '', NULL, 'zurich-', '53.11090000', '5.39420000'),
('Zutphen', 'GE', 328, 'zutphen-328', '52.14100000', '6.19780000'),
('Zuurdijk', 'GR', 329, 'zuurdijk-329', '53.31470000', '6.35580000'),
('Zwaag', 'NH', 332, 'zwaag-332', '52.66810000', '5.06570000'),
('Zwaagdijk-Oost', 'NH', 332, 'zwaagdijk-oost-332', '52.70460000', '5.14810000'),
('Zwaagdijk-West', 'NH', 332, 'zwaagdijk-west-332', '52.67600000', '5.06080000'),
('Zwaanshoek', 'NH', 332, 'zwaanshoek-332', '52.31350000', '4.61830000'),
('Zwagerbosch', '', NULL, 'zwagerbosch-', '53.24650000', '6.04810000'),
('Zwammerdam', 'ZH', 336, 'zwammerdam-336', '52.10560000', '4.72670000'),
('Zwanenburg', 'NH', 332, 'zwanenburg-332', '52.37880000', '4.74370000'),
('Zwartebroek', 'GE', 328, 'zwartebroek-328', '52.17870000', '5.50540000'),
('Zwartemeer', 'DR', 326, 'zwartemeer-326', '52.71900000', '7.04230000'),
('Zwartewaal', 'ZH', 336, 'zwartewaal-336', '51.86290000', '4.18520000'),
('Zwartsluis', 'OV', 333, 'zwartsluis-333', '52.64170000', '6.07270000'),
('Zweeloo', 'DR', 326, 'zweeloo-326', '52.79740000', '6.73270000'),
('Zweins', '', NULL, 'zweins-', '53.18920000', '5.60430000'),
('Zwiggelte', 'DR', 326, 'zwiggelte-326', '52.88240000', '6.59390000'),
('Zwijndrecht', 'ZH', 336, 'zwijndrecht-336', '51.81900000', '4.64180000'),
('Zwinderen', 'DR', 326, 'zwinderen-326', '52.72350000', '6.67350000'),
('Zwolle', 'OV', 333, 'zwolle-333', '52.51150000', '6.09230000');
SET FOREIGN_KEY_CHECKS=1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
