REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('BS', 'Bahamas', 'Bahamas', 'bahamas', '+1-242', 'BSD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6571493, 'BS', 'San Salvador', 1, 'san-salvador'),
(6571629, 'BS', 'Ragged Island', 1, 'ragged-island'),
(6571809, 'BS', 'Berry Islands', 1, 'berry-islands'),
(6571815, 'BS', 'New Providence', 1, 'new-providence'),
(6571894, 'BS', 'Mayaguana', 1, 'mayaguana'),
(6572005, 'BS', 'Long Island', 1, 'long-island'),
(6572154, 'BS', 'Inagua', 1, 'inagua'),
(6572238, 'BS', 'Harbour Island', 1, 'harbour-island'),
(6572374, 'BS', 'Freeport', 1, 'freeport'),
(6572427, 'BS', 'Exuma', 1, 'exuma'),
(6572678, 'BS', 'Cat Island', 1, 'cat-island'),
(6572807, 'BS', 'Bimini', 1, 'bimini'),
(6572937, 'BS', 'Acklins', 1, 'acklins'),
(11030541, 'BS', 'Black Point', 1, 'black-point'),
(11030542, 'BS', 'Central Abaco', 1, 'central-abaco'),
(11030543, 'BS', 'Central Andros', 1, 'central-andros'),
(11030544, 'BS', 'Central Eleuthera', 1, 'central-eleuthera'),
(11030545, 'BS', 'Crooked Island and Long Cay', 1, 'crooked-island-and-long-cay'),
(11030546, 'BS', 'East Grand Bahama', 1, 'east-grand-bahama'),
(11030547, 'BS', 'Grand Cay', 1, 'grand-cay'),
(11030548, 'BS', 'Hope Town', 1, 'hope-town'),
(11030549, 'BS', 'Mangrove Cay', 1, 'mangrove-cay'),
(11030550, 'BS', 'Moore’s Island', 1, 'moore-s-island'),
(11030551, 'BS', 'North Abaco', 1, 'north-abaco'),
(11030552, 'BS', 'North Andros', 1, 'north-andros'),
(11030553, 'BS', 'North Eleuthera', 1, 'north-eleuthera'),
(11030554, 'BS', 'Rum Cay', 1, 'rum-cay'),
(11030555, 'BS', 'South Abaco', 1, 'south-abaco'),
(11030556, 'BS', 'South Andros', 1, 'south-andros'),
(11030557, 'BS', 'South Eleuthera', 1, 'south-eleuthera'),
(11030558, 'BS', 'Spanish Wells', 1, 'spanish-wells'),
(11030559, 'BS', 'West Grand Bahama', 1, 'west-grand-bahama');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(6571157, 6572678, 'BS', 'Zonicles', 1, 'zonicles', 24.15357, -75.36243),
(6571158, 6572678, 'BS', 'Zion Hill', 1, 'zion-hill', 24.61667, -75.65),
(6571163, 6571815, 'BS', 'Yamacraw Beach Estate', 1, 'yamacraw-beach-estate', 25.03333, -77.28333),
(6571170, 11030551, 'BS', 'Wood Cay', 1, 'wood-cay', 26.9, -77.73333),
(6571179, 6571815, 'BS', 'Winton', 1, 'winton', 25.05, -77.28333),
(6571186, 11030542, 'BS', 'Wilson City', 1, 'wilson-city', 26.36667, -77.03333),
(6571189, 6572374, 'BS', 'Williams Town', 1, 'williams-town', 26.48333, -78.66667),
(6571190, 6572427, 'BS', 'William’s Town', 1, 'william-s-town', 23.42595, -75.55892),
(6571197, 6572005, 'BS', 'Whitehouse', 1, 'whitehouse', 23.4, -75.16667),
(6571224, 11030559, 'BS', 'West End', 1, 'west-end', 26.68711, -78.97702),
(6571230, 11030557, 'BS', 'Wemyss Bight', 1, 'wemyss-bight', 24.75, -76.25),
(6571231, 6571815, 'BS', 'Wemyss Bight', 1, 'wemyss-bight', 24.70855, -76.21323),
(6571233, 6572005, 'BS', 'Wemyss', 1, 'wemyss', 23.41667, -75.18333),
(6571241, 6571815, 'BS', 'Waterloo', 1, 'waterloo', 25.03333, -77.53333),
(6571242, 11030557, 'BS', 'Waterford', 1, 'waterford', 24.75, -76.23333),
(6571246, 11030559, 'BS', 'Water Cay', 1, 'water-cay', 26.75, -78.5),
(6571259, 11030559, 'BS', 'Vincent Town', 1, 'vincent-town', 26.66667, -78.95),
(6571262, 6572005, 'BS', 'Victoria Village', 1, 'victoria-village', 23.08333, -74.95),
(6571264, 6571493, 'BS', 'Victoria Hill', 1, 'victoria-hill', 24.0935, -74.52338),
(6571275, 11030553, 'BS', 'Upper Bogue', 1, 'upper-bogue', 25.45, -76.66667),
(6571276, 6571493, 'BS', 'United Estates', 1, 'united-estates', 24.1, -74.45),
(6571280, 11030552, 'BS', 'Twin Lakes', 1, 'twin-lakes', 24.7258, -77.99798),
(6571282, 6571815, 'BS', 'Tusculum', 1, 'tusculum', 25.06667, -77.48333),
(6571290, 6572005, 'BS', 'Turnbull', 1, 'turnbull', 23.08333, -75.01667),
(6571292, 6572937, 'BS', 'True Blue', 1, 'true-blue', 22.06667, -74.06667),
(6571294, 6571493, 'BS', 'Trial Farm', 1, 'trial-farm', 23.96667, -74.48333),
(6571304, 6572678, 'BS', 'Thurston Hill', 1, 'thurston-hill', 24.53333, -75.63333),
(6571310, 11030559, 'BS', 'Thomas Town', 1, 'thomas-town', 26.65, -78.96667),
(6571314, 6572678, 'BS', 'The Village', 1, 'the-village', 24.25, -75.4),
(6571315, 6572678, 'BS', 'The Lot', 1, 'the-lot', 24.63333, -75.68333),
(6571316, 6572427, 'BS', 'The Ferry Settlement', 1, 'the-ferry-settlement', 23.45, -75.56667),
(6571318, 11030553, 'BS', 'The Bluff', 1, 'the-bluff', 25.49907, -76.72337),
(6571319, 11030556, 'BS', 'The Bluff', 1, 'the-bluff', 24.11667, -77.55),
(6571320, 11030550, 'BS', 'The Bight', 1, 'the-bight', 26.3, -77.55),
(6571321, 6572678, 'BS', 'The Bight', 1, 'the-bight', 24.28961, -75.41522),
(6571327, 6572678, 'BS', 'Tea Bay', 1, 'tea-bay', 24.4, -75.51667),
(6571329, 6572005, 'BS', 'Tatnall', 1, 'tatnall', 23.48333, -75.2),
(6571332, 11030557, 'BS', 'Tarpum Bay', 1, 'tarpum-bay', 24.97, -76.18157),
(6571334, 6572005, 'BS', 'Taits', 1, 'taits', 22.98333, -74.88333),
(6571336, 11030542, 'BS', 'Sweetings Village', 1, 'sweetings-village', 26.35, -77.03333),
(6571338, 11030546, 'BS', 'Sweeting Cay', 1, 'sweeting-cay', 26.61334, -77.86931),
(6571342, 6571493, 'BS', 'Sugar Loaf', 1, 'sugar-loaf', 23.65, -74.51667),
(6571345, 6572427, 'BS', 'Stuart Manor', 1, 'stuart-manor', 23.63333, -76),
(6571354, 6572427, 'BS', 'Steventon', 1, 'steventon', 23.64265, -75.9448),
(6571355, 6572005, 'BS', 'Stevens', 1, 'stevens', 23.08333, -75.01667),
(6571356, 6572678, 'BS', 'Stephenson', 1, 'stephenson', 24.4442, -75.54202),
(6571357, 6572005, 'BS', 'Stella Maris', 1, 'stella-maris', 23.59199, -75.2651),
(6571365, 11030552, 'BS', 'Staniard Creek', 1, 'staniard-creek', 24.83141, -77.88762),
(6571366, 11030552, 'BS', 'Stafford Creek', 1, 'stafford-creek', 24.90594, -77.93668),
(6571370, 6572937, 'BS', 'Spring Point', 1, 'spring-point', 22.45883, -73.96057),
(6571372, 11030542, 'BS', 'Spring City Settlement', 1, 'spring-city-settlement', 26.47465, -77.08913),
(6571375, 11030558, 'BS', 'Spanish Wells', 1, 'spanish-wells', 25.54717, -76.76405),
(6571381, 11030559, 'BS', 'Southwest Point', 1, 'southwest-point', 26.49139, -78.74999),
(6571387, 6571493, 'BS', 'South Victoria Hill', 1, 'south-victoria-hill', 24, -74.46667),
(6571396, 11030544, 'BS', 'South Palmetto Point', 1, 'south-palmetto-point', 25.15, -76.18333),
(6571426, 6572937, 'BS', 'Snug Corner', 1, 'snug-corner', 22.55501, -73.87829),
(6571430, 11030542, 'BS', 'Snake Cay', 1, 'snake-cay', 26.45678, -77.0482),
(6571433, 11030556, 'BS', 'Smith’s Hill', 1, 'smith-s-hill', 24.05, -77.53333),
(6571434, 6572374, 'BS', 'Smith Point', 1, 'smith-point', 26.5, -78.61667),
(6571436, 6572678, 'BS', 'Smith Bay', 1, 'smith-bay', 24.34378, -75.47732),
(6571448, 6572005, 'BS', 'Simms', 1, 'simms', 23.47922, -75.23597),
(6571464, 6572005, 'BS', 'Seymour’s', 1, 'seymour-s', 23.65619, -75.31136),
(6571467, 11030552, 'BS', 'Seminets', 1, 'seminets', 24.86667, -77.93333),
(6571468, 11030545, 'BS', 'Seaview Settlement', 1, 'seaview-settlement', 22.81667, -74.28333),
(6571471, 11030559, 'BS', 'Sea Grape', 1, 'sea-grape', 26.53333, -78.81667),
(6571473, 6572005, 'BS', 'Scrub Hill', 1, 'scrub-hill', 23.48333, -75.23333),
(6571485, 11030544, 'BS', 'Savannah Sound', 1, 'savannah-sound', 25.08416, -76.13714),
(6571500, 11030555, 'BS', 'Sandy Point', 1, 'sandy-point', 26.02052, -77.39),
(6571520, 6571815, 'BS', 'Sandilands Village', 1, 'sandilands-village', 25.05, -77.31667),
(6571523, 11030552, 'BS', 'San Andros', 1, 'san-andros', 25.06667, -78.05),
(6571528, 6572005, 'BS', 'Sam McKinnons', 1, 'sam-mckinnons', 23.4, -75.18333),
(6571535, 6572005, 'BS', 'Salt Pond', 1, 'salt-pond', 23.34594, -75.12311),
(6571543, 6572937, 'BS', 'Salina Point', 1, 'salina-point', 22.20478, -74.2435),
(6571571, 6572005, 'BS', 'Roses', 1, 'roses', 22.98333, -74.88429),
(6571577, 6572427, 'BS', 'Rolleville', 1, 'rolleville', 23.67332, -75.98484),
(6571578, 6572427, 'BS', 'Rolletown', 1, 'rolletown', 23.46312, -75.70421),
(6571579, 6572427, 'BS', 'Rokers Point Settlement', 1, 'rokers-point-settlement', 23.61667, -75.91667),
(6571581, 6572678, 'BS', 'Roakers', 1, 'roakers', 24.51922, -75.58333),
(6571597, 11030559, 'BS', 'Roberts Town', 1, 'roberts-town', 26.66667, -78.95),
(6571604, 6572427, 'BS', 'Richmond Hill', 1, 'richmond-hill', 23.60676, -75.99432),
(6571605, 11030545, 'BS', 'Richmond', 1, 'richmond', 22.8, -74.33333),
(6571615, 11030552, 'BS', 'Red Bay Settlement', 1, 'red-bay-settlement', 25.13782, -78.19544),
(6571617, 6571493, 'BS', 'Reckley Hill', 1, 'reckley-hill', 24.1, -74.45),
(6571625, 6572427, 'BS', 'Ramsey', 1, 'ramsey', 23.56667, -75.86667),
(6571636, 6571493, 'BS', 'Quarters', 1, 'quarters', 24.10382, -74.51899),
(6571639, 11030556, 'BS', 'Pure Gold', 1, 'pure-gold', 23.96667, -77.53333),
(6571650, 11030554, 'BS', 'Port Nelson', 1, 'port-nelson', 23.64967, -74.84157),
(6571652, 6572678, 'BS', 'Port Howe', 1, 'port-howe', 24.15848, -75.33861),
(6571653, 11030554, 'BS', 'Port Boyd', 1, 'port-boyd', 23.70354, -74.82068),
(6571661, 6572937, 'BS', 'Pompey Bay', 1, 'pompey-bay', 22.41143, -73.99381),
(6571663, 6571493, 'BS', 'Polly Hill', 1, 'polly-hill', 24.08333, -74.43333),
(6571670, 6571894, 'BS', 'Pirates Well', 1, 'pirates-well', 22.43071, -73.09457),
(6571675, 11030559, 'BS', 'Pine Ridge', 1, 'pine-ridge', 26.55, -78.73333),
(6571677, 6572937, 'BS', 'Pinefield', 1, 'pinefield', 22.65, -73.86667),
(6571680, 6572374, 'BS', 'Pinders Point', 1, 'pinders-point', 26.48333, -78.68333),
(6571681, 6572005, 'BS', 'Pinders', 1, 'pinders', 23.28333, -75.1),
(6571706, 11030546, 'BS', 'Pelican Point', 1, 'pelican-point', 26.65, -78.08333),
(6571725, 11030544, 'BS', 'Palmetto Point', 1, 'palmetto-point', 25.16667, -76.16667),
(6571729, 11030552, 'BS', 'Owens Town', 1, 'owens-town', 24.87762, -78.03575),
(6571733, 6571815, 'BS', 'Orange Hill', 1, 'orange-hill', 25.06667, -77.48333),
(6571735, 6572678, 'BS', 'Orange Creek', 1, 'orange-creek', 24.65, -75.71667),
(6571737, 6572005, 'BS', 'O’Neils', 1, 'o-neils', 23.5, -75.21667),
(6571739, 6571493, 'BS', 'Old Place', 1, 'old-place', 23.96667, -74.48333),
(6571742, 6572005, 'BS', 'Old Grays', 1, 'old-grays', 23.21667, -75.08333),
(6571747, 6572678, 'BS', 'Old Bight', 1, 'old-bight', 24.23037, -75.3796),
(6571775, 11030544, 'BS', 'North Palmetto Point', 1, 'north-palmetto-point', 25.16667, -76.18333),
(6571803, 11030551, 'BS', 'Normans Castle', 1, 'normans-castle', 26.71907, -77.4438),
(6571810, 11030552, 'BS', 'Nicholls Town', 1, 'nicholls-town', 25.14534, -78.0016),
(6571818, 6572678, 'BS', 'New Bight', 1, 'new-bight', 24.32078, -75.47002),
(6571823, 6571815, 'BS', 'Nassau Estate', 1, 'nassau-estate', 25.03333, -77.28333),
(6571824, 6571815, 'BS', 'Nassau', 1, 'nassau', 25.05823, -77.34306),
(6571828, 11030542, 'BS', 'Murphy Town', 1, 'murphy-town', 26.55261, -77.09585),
(6571834, 11030549, 'BS', 'Moxey Town', 1, 'moxey-town', 24.2954, -77.67995),
(6571837, 6572427, 'BS', 'Mount Thompson', 1, 'mount-thompson', 23.58333, -75.88333),
(6571839, 6571815, 'BS', 'Mount Pleasant', 1, 'mount-pleasant', 25.01667, -77.51667),
(6571840, 11030551, 'BS', 'Mount Hope', 1, 'mount-hope', 26.9, -77.76667),
(6571842, 6572678, 'BS', 'Moss Town', 1, 'moss-town', 24.24618, -75.38681),
(6571843, 6572427, 'BS', 'Moss Town', 1, 'moss-town', 23.54675, -75.85571),
(6571844, 11030545, 'BS', 'Moss Town', 1, 'moss-town', 22.8, -74.25),
(6571847, 6572005, 'BS', 'Mortimers', 1, 'mortimers', 22.90621, -74.87432),
(6571850, 11030552, 'BS', 'Morgan’s Bluff', 1, 'morgan-s-bluff', 25.16667, -78.03333),
(6571851, 6572937, 'BS', 'Morant Bay', 1, 'morant-bay', 22.4, -74.03333),
(6571855, 6571493, 'BS', 'Montreal', 1, 'montreal', 23.95637, -74.49443),
(6571865, 11030552, 'BS', 'Minns', 1, 'minns', 24.7, -77.76667),
(6571866, 6572005, 'BS', 'Millerton', 1, 'millerton', 23.55, -75.25),
(6571867, 11030552, 'BS', 'Millers Hill', 1, 'millers-hill', 25.11667, -77.98333),
(6571868, 6572005, 'BS', 'Millers', 1, 'millers', 23.4, -75.16667),
(6571871, 6571815, 'BS', 'Millars', 1, 'millars', 24.98485, -77.43039),
(6571881, 6572427, 'BS', 'Michelson', 1, 'michelson', 23.49052, -75.7658),
(6571885, 6572678, 'BS', 'McQueens', 1, 'mcqueens', 24.17791, -75.47081),
(6571886, 11030546, 'BS', 'McLeans Town', 1, 'mcleans-town', 26.65798, -77.99191),
(6571887, 6572005, 'BS', 'McKenzie', 1, 'mckenzie', 23.13333, -75.06667),
(6571890, 6572005, 'BS', 'McKanns', 1, 'mckanns', 23.36667, -75.16667),
(6571898, 6572154, 'BS', 'Matthew Town', 1, 'matthew-town', 20.94982, -73.67346),
(6571899, 11030559, 'BS', 'Mather Town', 1, 'mather-town', 26.55, -78.58333),
(6571904, 11030552, 'BS', 'Mastic Point', 1, 'mastic-point', 25.06729, -77.96937),
(6571911, 11030559, 'BS', 'Martin Town', 1, 'martin-town', 26.53333, -78.8),
(6571913, 11030542, 'BS', 'Marsh Harbour', 1, 'marsh-harbour', 26.54124, -77.0636),
(6571915, 11030556, 'BS', 'Mars Bay', 1, 'mars-bay', 23.8671, -77.51581),
(6571926, 11030543, 'BS', 'Man of War Sound', 1, 'man-of-war-sound', 24.55, -77.75),
(6571930, 11030548, 'BS', 'Man of War Cay Settlement', 1, 'man-of-war-cay-settlement', 26.59536, -77.00077),
(6571944, 11030549, 'BS', 'Mangrove Cay', 1, 'mangrove-cay', 24.26035, -77.66287),
(6571950, 6572005, 'BS', 'Mangrove Bush', 1, 'mangrove-bush', 23.13333, -75.06667),
(6571954, 11030545, 'BS', 'Majors', 1, 'majors', 22.72677, -74.15616),
(6571964, 6571815, 'BS', 'Macbride', 1, 'macbride', 25.06667, -77.46667),
(6571971, 6572374, 'BS', 'Lucaya', 1, 'lucaya', 26.53333, -78.66667),
(6571980, 11030552, 'BS', 'Lowe Sound Settlement', 1, 'lowe-sound-settlement', 25.14891, -78.0917),
(6571982, 6572005, 'BS', 'Lower Deadman’s Cay', 1, 'lower-deadman-s-cay', 23.1664, -75.09602),
(6571985, 11030553, 'BS', 'Lower Bogue', 1, 'lower-bogue', 25.46667, -76.71667),
(6571990, 6572937, 'BS', 'Lovely Bay', 1, 'lovely-bay', 22.69135, -73.98199),
(6571992, 11030552, 'BS', 'Love Hill', 1, 'love-hill', 24.75, -77.85),
(6571994, 6571815, 'BS', 'Love', 1, 'love', 25.06667, -77.5),
(6571995, 6572807, 'BS', 'Louis Town', 1, 'louis-town', 25.55253, -79.27854),
(6572016, 6571493, 'BS', 'Long Bay', 1, 'long-bay', 24.01151, -74.52542),
(6572057, 11030541, 'BS', 'Little Farmers Cay', 1, 'little-farmers-cay', 23.95, -76.31667),
(6572062, 11030556, 'BS', 'Little Creek', 1, 'little-creek', 23.94674, -77.52248),
(6572071, 11030553, 'BS', 'Little Bay Settlement', 1, 'little-bay-settlement', 25.33333, -76.83333),
(6572072, 11030555, 'BS', 'Little Bay', 1, 'little-bay', 25.83333, -77.16667),
(6572076, 11030549, 'BS', 'Lisbon Creek', 1, 'lisbon-creek', 24.21397, -77.63751),
(6572099, 11030545, 'BS', 'Landrail Point', 1, 'landrail-point', 22.80353, -74.33731),
(6572102, 6572678, 'BS', 'Knowles Village', 1, 'knowles-village', 24.36727, -75.4999),
(6572106, 6571815, 'BS', 'Killarney', 1, 'killarney', 25.05, -77.41667),
(6572110, 11030556, 'BS', 'Kemps Bay', 1, 'kemps-bay', 24.027, -77.53343),
(6572122, 6571815, 'BS', 'John Millars', 1, 'john-millars', 24.68984, -76.20255),
(6572130, 6572427, 'BS', 'Jimmy Hill', 1, 'jimmy-hill', 23.56667, -75.86667),
(6572135, 11030553, 'BS', 'James Cistern', 1, 'james-cistern', 25.32566, -76.36181),
(6572149, 6572678, 'BS', 'Industrious Hill', 1, 'industrious-hill', 24.45, -75.55),
(6572160, 11030559, 'BS', 'Hunters', 1, 'hunters', 26.48333, -78.71667),
(6572166, 11030559, 'BS', 'Hope Estate', 1, 'hope-estate', 26.66667, -78.93333),
(6572167, 11030559, 'BS', 'Holmes Rock', 1, 'holmes-rock', 26.55, -78.83333),
(6572171, 6571493, 'BS', 'Holdiday Track', 1, 'holdiday-track', 24.01667, -74.45),
(6572189, 11030546, 'BS', 'High Rock', 1, 'high-rock', 26.60999, -78.27863),
(6572190, 11030556, 'BS', 'High Rock', 1, 'high-rock', 24.16667, -77.58333),
(6572204, 6572427, 'BS', 'Hermitage', 1, 'hermitage', 23.51667, -75.83333),
(6572214, 6572678, 'BS', 'Hawks Nest', 1, 'hawks-nest', 24.15881, -75.50938),
(6572221, 11030559, 'BS', 'Hawksbill', 1, 'hawksbill', 26.5, -78.73333),
(6572228, 6572427, 'BS', 'Hartswell', 1, 'hartswell', 23.43333, -75.66667),
(6572229, 6572678, 'BS', 'Harts Bay Hill', 1, 'harts-bay-hill', 24.41667, -75.53333),
(6572232, 6572937, 'BS', 'Hard Hill', 1, 'hard-hill', 22.60179, -73.87764),
(6572234, 11030552, 'BS', 'Hard Bargain', 1, 'hard-bargain', 24.75535, -77.79751),
(6572235, 6571493, 'BS', 'Hard Bargain', 1, 'hard-bargain', 24.06667, -74.45),
(6572236, 6572005, 'BS', 'Hard Bargain', 1, 'hard-bargain', 23.01848, -74.89245),
(6572240, 6571493, 'BS', 'Harbour Estate', 1, 'harbour-estate', 24.1, -74.51667),
(6572244, 6571493, 'BS', 'Halls Landing', 1, 'halls-landing', 24, -74.51667),
(6572269, 11030553, 'BS', 'Gregory Town', 1, 'gregory-town', 25.39086, -76.55715),
(6572270, 11030551, 'BS', 'Green Turtle Village', 1, 'green-turtle-village', 26.81667, -77.45),
(6572272, 11030548, 'BS', 'Green Turtle Cay', 1, 'green-turtle-cay', 26.75818, -77.32482),
(6572279, 11030557, 'BS', 'Green Castle', 1, 'green-castle', 24.79834, -76.27378),
(6572293, 11030548, 'BS', 'Great Guana Cay', 1, 'great-guana-cay', 26.6666, -77.10782),
(6572299, 6572005, 'BS', 'Grays', 1, 'grays', 23.25293, -75.10293),
(6572317, 6572005, 'BS', 'Gordon’s', 1, 'gordon-s', 22.86667, -74.85),
(6572323, 6572937, 'BS', 'Goodwill', 1, 'goodwill', 22.53678, -73.87533),
(6572333, 11030546, 'BS', 'Golden Grove', 1, 'golden-grove', 26.6, -78.33333),
(6572334, 6572937, 'BS', 'Golden Grove', 1, 'golden-grove', 22.46667, -73.9),
(6572339, 6572005, 'BS', 'Glintons', 1, 'glintons', 23.63333, -75.3),
(6572346, 6572427, 'BS', 'Gilbert Grant', 1, 'gilbert-grant', 23.6, -75.91667),
(6572349, 6572427, 'BS', 'George Town', 1, 'george-town', 23.51616, -75.78665),
(6572355, 6571815, 'BS', 'Gambier Village', 1, 'gambier-village', 25.06667, -77.5),
(6572356, 6572005, 'BS', 'Galloway Landing', 1, 'galloway-landing', 23.06231, -74.97146),
(6572362, 6572678, 'BS', 'Gaitor’s', 1, 'gaitor-s', 24.46667, -75.55),
(6572366, 11030545, 'BS', 'French Wells', 1, 'french-wells', 22.68333, -74.3),
(6572370, 11030551, 'BS', 'Freetown', 1, 'freetown', 26.56667, -78.45),
(6572371, 6572678, 'BS', 'Freetown', 1, 'freetown', 24.3033, -75.43058),
(6572375, 6572374, 'BS', 'Freeport', 1, 'freeport', 26.53333, -78.7),
(6572378, 11030551, 'BS', 'Fox Town', 1, 'fox-town', 26.91767, -77.7998),
(6572382, 6571493, 'BS', 'Fortune Hill', 1, 'fortune-hill', 24.01667, -74.45),
(6572383, 6572427, 'BS', 'Forest', 1, 'forest', 23.58697, -75.91443),
(6572384, 6572005, 'BS', 'Ford', 1, 'ford', 22.91667, -74.86667),
(6572385, 6572427, 'BS', 'Forbes Hill', 1, 'forbes-hill', 23.46001, -75.64732),
(6572406, 11030551, 'BS', 'Fire Road Village', 1, 'fire-road-village', 26.86164, -77.50077),
(6572417, 6571493, 'BS', 'Farquharson', 1, 'farquharson', 24, -74.46667),
(6572418, 6572427, 'BS', 'Farmer’s Hill', 1, 'farmer-s-hill', 23.6, -75.9),
(6572423, 11030545, 'BS', 'Fairfield', 1, 'fairfield', 22.78333, -74.21667),
(6572443, 11030559, 'BS', 'Eight Mile Rock', 1, 'eight-mile-rock', 26.51667, -78.78333),
(6572462, 6572238, 'BS', 'Dunmore Town', 1, 'dunmore-town', 25.50216, -76.63633),
(6572463, 6572005, 'BS', 'Dunmore', 1, 'dunmore', 23.04769, -74.9055),
(6572465, 11030542, 'BS', 'Dundas Town', 1, 'dundas-town', 26.54638, -77.07978),
(6572467, 6571629, 'BS', 'Duncan Town', 1, 'duncan-town', 22.19083, -75.72583),
(6572470, 6572678, 'BS', 'Dumfries', 1, 'dumfries', 24.60081, -75.64669),
(6572475, 11030556, 'BS', 'Driggs Hill', 1, 'driggs-hill', 24.20864, -77.59949),
(6572480, 6572678, 'BS', 'Douds', 1, 'douds', 24.28006, -75.40741),
(6572493, 6572005, 'BS', 'Doctor’s Creek', 1, 'doctor-s-creek', 23.46667, -75.21667),
(6572494, 6571493, 'BS', 'Dixons', 1, 'dixons', 24.1, -74.45),
(6572505, 6572678, 'BS', 'Devil’s Point', 1, 'devil-s-point', 24.11667, -75.46667),
(6572507, 6572937, 'BS', 'Delectable Point', 1, 'delectable-point', 22.42006, -73.99215),
(6572511, 11030557, 'BS', 'Delancey Town', 1, 'delancey-town', 24.76667, -76.26667),
(6572514, 11030557, 'BS', 'Deep Creek', 1, 'deep-creek', 24.77333, -76.26959),
(6572515, 11030556, 'BS', 'Deep Creek', 1, 'deep-creek', 24, -77.55),
(6572523, 6572005, 'BS', 'Deadman\'s Cay', 1, 'deadman-s-cay', 23.17919, -75.1131),
(6572538, 6572427, 'BS', 'Curtis', 1, 'curtis', 23.63333, -75.96667),
(6572541, 11030553, 'BS', 'Current Island Settlement', 1, 'current-island-settlement', 25.34494, -76.81622),
(6572544, 11030553, 'BS', 'Current', 1, 'current', 25.408, -76.78397),
(6572548, 6571815, 'BS', 'Cunningham', 1, 'cunningham', 25.08333, -77.43333),
(6572553, 11030551, 'BS', 'Crown Haven', 1, 'crown-haven', 26.9, -77.81667),
(6572556, 11030555, 'BS', 'Crossing Rocks', 1, 'crossing-rocks', 26.13333, -77.18333),
(6572570, 11030545, 'BS', 'Cripple Hill', 1, 'cripple-hill', 22.78333, -74.23333),
(6572571, 6571815, 'BS', 'Creek Village', 1, 'creek-village', 25.06667, -77.3),
(6572585, 6572678, 'BS', 'Cove', 1, 'cove', 24.41667, -75.53333),
(6572592, 11030551, 'BS', 'Cornishtown', 1, 'cornishtown', 26.86289, -77.52717),
(6572598, 6571815, 'BS', 'Coral Heights', 1, 'coral-heights', 24.9982, -77.45555),
(6572599, 6571815, 'BS', 'Coral Harbour', 1, 'coral-harbour', 24.98176, -77.46534),
(6572601, 11030551, 'BS', 'Cooper’s Town', 1, 'cooper-s-town', 26.87137, -77.51131),
(6572603, 11030556, 'BS', 'Congo Town', 1, 'congo-town', 24.16614, -77.58425),
(6572606, 11030552, 'BS', 'Conch Sound Settlement', 1, 'conch-sound-settlement', 25.12188, -77.99571),
(6572620, 11030545, 'BS', 'Colonel Hill', 1, 'colonel-hill', 22.7545, -74.20415),
(6572627, 6571493, 'BS', 'Cockburn Town', 1, 'cockburn-town', 24.05179, -74.53138),
(6572631, 11030552, 'BS', 'Coakley Town', 1, 'coakley-town', 24.72625, -77.79488),
(6572636, 6571815, 'BS', 'Clifton', 1, 'clifton', 25.01667, -77.56667),
(6572640, 6572005, 'BS', 'Clarence Town', 1, 'clarence-town', 23.1, -74.98333),
(6572647, 11030545, 'BS', 'Church Grove', 1, 'church-grove', 22.75, -74.21667),
(6572651, 6571809, 'BS', 'Chub Cay', 1, 'chub-cay', 25.41254, -77.90264),
(6572656, 6572937, 'BS', 'Chesters', 1, 'chesters', 22.70657, -73.9179),
(6572658, 11030542, 'BS', 'Cherokee Sound', 1, 'cherokee-sound', 26.28333, -77.03333),
(6572669, 11030551, 'BS', 'Cedar Harbour', 1, 'cedar-harbour', 26.89532, -77.65198),
(6572687, 6572005, 'BS', 'Cartwright', 1, 'cartwright', 23.13333, -75.06667),
(6572690, 6571815, 'BS', 'Carmichael Village', 1, 'carmichael-village', 25.01667, -77.43333),
(6572692, 11030543, 'BS', 'Cargill Creek', 1, 'cargill-creek', 24.49863, -77.71995),
(6572696, 6571815, 'BS', 'Camperdown', 1, 'camperdown', 25.05, -77.26667),
(6572698, 6572427, 'BS', 'Calvin Hill', 1, 'calvin-hill', 23.6, -75.96667),
(6572703, 11030552, 'BS', 'Calabash Bay', 1, 'calabash-bay', 24.73333, -77.8),
(6572704, 6572678, 'BS', 'Cairey’s', 1, 'cairey-s', 24.48333, -75.56667),
(6572708, 6572005, 'BS', 'Cabbage Point', 1, 'cabbage-point', 22.93279, -74.88568),
(6572709, 11030545, 'BS', 'Cabbage Hill', 1, 'cabbage-hill', 22.76376, -74.21994),
(6572713, 6572005, 'BS', 'Burnt Ground', 1, 'burnt-ground', 23.61126, -75.28682),
(6572716, 6571809, 'BS', 'Bullocks Harbour', 1, 'bullocks-harbour', 25.75205, -77.86895),
(6572720, 6572005, 'BS', 'Buckleys', 1, 'buckleys', 23.15, -75.08333),
(6572728, 11030545, 'BS', 'Browns', 1, 'browns', 22.72917, -74.06036),
(6572740, 11030559, 'BS', 'Braudies Point', 1, 'braudies-point', 26.53333, -78.73333),
(6572742, 6571493, 'BS', 'Brandy Hill', 1, 'brandy-hill', 24.08333, -74.43333),
(6572743, 6571815, 'BS', 'Bradford', 1, 'bradford', 25.06667, -77.51667),
(6572745, 6572005, 'BS', 'Bowers', 1, 'bowers', 23.25, -75.08333),
(6572746, 11030543, 'BS', 'Bowen Sound', 1, 'bowen-sound', 24.58333, -77.73333),
(6572772, 6572807, 'BS', 'Bluff', 1, 'bluff', 25.78333, -79.31667),
(6572773, 6572678, 'BS', 'Bluff Settlement', 1, 'bluff-settlement', 24.52271, -75.59193),
(6572778, 11030552, 'BS', 'Blanket Sound', 1, 'blanket-sound', 24.85, -77.9),
(6572780, 11030551, 'BS', 'Blackwood Village', 1, 'blackwood-village', 26.81393, -77.43928),
(6572797, 11030541, 'BS', 'Black Point', 1, 'black-point', 23.98333, -77.55),
(6572804, 6572937, 'BS', 'Binnacle Hill', 1, 'binnacle-hill', 22.32116, -74.13847),
(6572840, 11030546, 'BS', 'Bevans Town', 1, 'bevans-town', 26.6, -78.31667),
(6572841, 6571894, 'BS', 'Betsy Bay', 1, 'betsy-bay', 22.41862, -73.13409),
(6572844, 6572005, 'BS', 'Berrys', 1, 'berrys', 22.9543, -74.88286),
(6572847, 6572678, 'BS', 'Bennetts Harbor', 1, 'bennetts-harbor', 24.56347, -75.63989),
(6572851, 11030543, 'BS', 'Behring Point', 1, 'behring-point', 24.48004, -77.72355),
(6572856, 11030549, 'BS', 'Bastian Point', 1, 'bastian-point', 24.23461, -77.62529),
(6572869, 6572427, 'BS', 'Baraterre', 1, 'baraterre', 23.69573, -76.04125),
(6572873, 6571815, 'BS', 'Bannerman Town', 1, 'bannerman-town', 24.66055, -76.18396),
(6572879, 6572678, 'BS', 'Bain Town', 1, 'bain-town', 24.1502, -75.38353),
(6572880, 11030559, 'BS', 'Bain Town', 1, 'bain-town', 26.51667, -78.78333),
(6572883, 6572005, 'BS', 'Bains', 1, 'bains', 23.45, -75.21667),
(6572884, 6572807, 'BS', 'Bailey Town', 1, 'bailey-town', 25.7437, -79.2861),
(6572885, 6572678, 'BS', 'Bailey Town', 1, 'bailey-town', 24.15249, -75.31667),
(6572891, 11030552, 'BS', 'August Town', 1, 'august-town', 25.03333, -77.98333),
(6572897, 6572678, 'BS', 'Arthur’s Town', 1, 'arthur-s-town', 24.6224, -75.67151),
(6572901, 6572427, 'BS', 'Anne’s Tract Settlement', 1, 'anne-s-tract-settlement', 23.68333, -76.05),
(6572906, 11030552, 'BS', 'Andros Town', 1, 'andros-town', 24.70502, -77.76912),
(6572910, 6572005, 'BS', 'Andersons', 1, 'andersons', 23.21667, -75.08333),
(6572912, 6572005, 'BS', 'Anderson', 1, 'anderson', 23.53333, -75.23333),
(6572913, 6572937, 'BS', 'Anderson', 1, 'anderson', 22.61667, -73.86667),
(6572920, 6572005, 'BS', 'Alligator Bay Settlement', 1, 'alligator-bay-settlement', 23.45, -75.21667),
(6572922, 6571493, 'BS', 'Allen', 1, 'allen', 23.95, -74.51667),
(6572924, 6572807, 'BS', 'Alice Town', 1, 'alice-town', 25.728, -79.29721),
(6572925, 11030553, 'BS', 'Alice Town', 1, 'alice-town', 25.34604, -76.48531),
(6572927, 6572427, 'BS', 'Alexander', 1, 'alexander', 23.65, -76.01667),
(6572930, 6572937, 'BS', 'Albert Town', 1, 'albert-town', 22.60091, -74.34687),
(6572933, 6571815, 'BS', 'Adelaide', 1, 'adelaide', 25.0022, -77.49052),
(6572934, 6572005, 'BS', 'Adderly', 1, 'adderly', 23.58059, -75.2542),
(6572940, 6571894, 'BS', 'Abraham’s Bay', 1, 'abraham-s-bay', 22.36667, -72.96667),
(6572946, 6572937, 'BS', 'Abercorn', 1, 'abercorn', 22.36667, -73.95),
(6739568, 11030559, 'BS', 'Russell Town', 1, 'russell-town', 26.51667, -78.7),
(6830930, 11030552, 'BS', 'New Town', 1, 'new-town', 25.0526, -77.98499),
(6830932, 11030543, 'BS', 'Markey', 1, 'markey', 24.48806, -77.72111),
(6830951, 11030557, 'BS', 'Kemps Point', 1, 'kemps-point', 24.90698, -76.18216),
(6830953, 11030557, 'BS', 'Davis Harbor', 1, 'davis-harbor', 24.73095, -76.22016),
(13626569, 6572807, 'BS', 'Port Royal', 1, 'port-royal', 25.70078, -79.30254),
(14265466, 6572427, 'BS', 'Pigeon Cay', 1, 'pigeon-cay', 23.4299, -75.67808),
(14694815, 11030547, 'BS', 'Grand Cay', 1, 'grand-cay', 27.21983, -78.32771),
(14694817, 11030547, 'BS', 'Walker Cay', 1, 'walker-cay', 27.25993, -78.40243);