REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('JM', 'Jamaica', 'jamaica', '+1-876', 'Jamaica', 'JMD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003753, 'JM', 'Clarendon Parish', 1, 'clarendon-parish');

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 
(1062295, 1003753, 'JM', 'Aenon Town', 1, 'aenon-town', 18.21027000, -77.39851000),
(1062302, 1003753, 'JM', 'Alley', 1, 'alley', 17.79036000, -77.27085000),
(1062307, 1003753, 'JM', 'Alston', 1, 'alston', 18.17639000, -77.43468000),
(1062319, 1003753, 'JM', 'Ashley', 1, 'ashley', 18.01440000, -77.34019000),
(1062331, 1003753, 'JM', 'Banks', 1, 'banks', 17.83222000, -77.30731000),
(1062344, 1003753, 'JM', 'Beckford Kraal', 1, 'beckford-kraal', 18.08545000, -77.32399000),
(1062387, 1003753, 'JM', 'Brandon Hill', 1, 'brandon-hill', 18.15110000, -77.23663000),
(1062391, 1003753, 'JM', 'Brixton Hill', 1, 'brixton-hill', 18.02039000, -77.31744000),
(1062397, 1003753, 'JM', 'Bucknor', 1, 'bucknor', 18.00619000, -77.23749000),
(1062398, 1003753, 'JM', 'Bucks Common', 1, 'bucks-common', 17.98228000, -77.23846000),
(1062406, 1003753, 'JM', 'Bushy Park', 1, 'bushy-park', 17.98243000, -77.25135000),
(1062446, 1003753, 'JM', 'Chapelton', 1, 'chapelton', 18.08333000, -77.26667000),
(1062449, 1003753, 'JM', 'Chateau', 1, 'chateau', 17.98972000, -77.18737000),
(1062462, 1003753, 'JM', 'Cockpit', 1, 'cockpit', 17.88872000, -77.15835000),
(1062463, 1003753, 'JM', 'Coffee Piece', 1, 'coffee-piece', 18.13835000, -77.40648000),
(1062466, 1003753, 'JM', 'Colonels Ridge', 1, 'colonels-ridge', 18.13525000, -77.25550000),
(1062485, 1003753, 'JM', 'Coxswain', 1, 'coxswain', 18.10272000, -77.23444000),
(1062489, 1003753, 'JM', 'Crofts Hill', 1, 'crofts-hill', 18.13268000, -77.20507000),
(1062491, 1003753, 'JM', 'Crooked River', 1, 'crooked-river', 18.14289000, -77.30000000),
(1062496, 1003753, 'JM', 'Cumberland', 1, 'cumberland', 18.10522000, -77.41617000),
(1062497, 1003753, 'JM', 'Curatoe Hill', 1, 'curatoe-hill', 17.93982000, -77.24836000),
(1062504, 1003753, 'JM', 'Dawkins', 1, 'dawkins', 18.05540000, -77.33303000),
(1062533, 1003753, 'JM', 'Effortville', 1, 'effortville', 17.99270000, -77.21860000),
(1062565, 1003753, 'JM', 'Four Paths', 1, 'four-paths', 17.97089000, -77.29599000),
(1062566, 1003753, 'JM', 'Frankfield', 1, 'frankfield', 18.14971000, -77.36498000),
(1062570, 1003753, 'JM', 'Freetown', 1, 'freetown', 17.92192000, -77.14781000),
(1062585, 1003753, 'JM', 'Gimme-me-bit', 1, 'gimme-me-bit', 17.88946000, -77.28469000),
(1062590, 1003753, 'JM', 'Glenmuir', 1, 'glenmuir', 17.96801000, -77.25394000),
(1062602, 1003753, 'JM', 'Grantham', 1, 'grantham', 18.15839000, -77.39643000),
(1062606, 1003753, 'JM', 'Gravel Hill', 1, 'gravel-hill', 17.90968000, -77.33354000),
(1062638, 1003753, 'JM', 'Hayes', 1, 'hayes', 17.87569000, -77.23711000),
(1062640, 1003753, 'JM', 'Hazard', 1, 'hazard', 17.95382000, -77.23147000),
(1062661, 1003753, 'JM', 'Inverness', 1, 'inverness', 17.91195000, -77.19032000),
(1062670, 1003753, 'JM', 'James Hill', 1, 'james-hill', 18.18750000, -77.33700000),
(1062676, 1003753, 'JM', 'Johns Hall', 1, 'johns-hall', 18.18876000, -77.38063000),
(1062683, 1003753, 'JM', 'Kellits', 1, 'kellits', 18.16184000, -77.27049000),
(1062712, 1003753, 'JM', 'Limit', 1, 'limit', 18.15287000, -77.47121000),
(1062715, 1003753, 'JM', 'Lionel Town', 1, 'lionel-town', 17.81007000, -77.24061000),
(1062727, 1003753, 'JM', 'Longville Park', 1, 'longville-park', 17.91188000, -77.15983000),
(1062728, 1003753, 'JM', 'Longwood', 1, 'longwood', 17.80754000, -77.28728000),
(1062764, 1003753, 'JM', 'May Pen', 1, 'may-pen', 17.96454000, -77.24515000),
(1062765, 1003753, 'JM', 'May Pen Proper', 1, 'may-pen-proper', 17.97034000, -77.23911000),
(1062776, 1003753, 'JM', 'Milk River', 1, 'milk-river', 17.87560000, -77.35139000),
(1062777, 1003753, 'JM', 'Mineral Heights', 1, 'mineral-heights', 17.94183000, -77.23276000),
(1062778, 1003753, 'JM', 'Mitchell Town', 1, 'mitchell-town', 17.81281000, -77.20531000),
(1062788, 1003753, 'JM', 'Moores', 1, 'moores', 18.02926000, -77.18540000),
(1062790, 1003753, 'JM', 'Morgans Forest', 1, 'morgans-forest', 18.19088000, -77.41021000),
(1062791, 1003753, 'JM', 'Morgans Pass', 1, 'morgans-pass', 18.12123000, -77.27493000),
(1062793, 1003753, 'JM', 'Mount Airy', 1, 'mount-airy', 18.01843000, -77.36357000),
(1062812, 1003753, 'JM', 'New Denbigh', 1, 'new-denbigh', 17.98563000, -77.27104000),
(1062817, 1003753, 'JM', 'New Longsville', 1, 'new-longsville', 18.03072000, -77.23048000),
(1062836, 1003753, 'JM', 'Old Denbigh', 1, 'old-denbigh', 17.96116000, -77.26701000),
(1062846, 1003753, 'JM', 'Orange Hill', 1, 'orange-hill', 18.11788000, -77.35942000),
(1062847, 1003753, 'JM', 'Osbourne Store', 1, 'osbourne-store', 17.95892000, -77.32827000),
(1062848, 1003753, 'JM', 'Paisley', 1, 'paisley', 17.96293000, -77.22368000),
(1062849, 1003753, 'JM', 'Palmers Cross', 1, 'palmers-cross', 17.95000000, -77.20338000),
(1062858, 1003753, 'JM', 'Part of Banana Ground', 1, 'part-of-banana-ground', 18.08022000, -77.40971000),
(1062859, 1003753, 'JM', 'Part of Douglas Castle', 1, 'part-of-douglas-castle', 18.18703000, -77.27538000),
(1062861, 1003753, 'JM', 'Part of Kellits', 1, 'part-of-kellits', 18.17159000, -77.25120000),
(1062871, 1003753, 'JM', 'Peckham', 1, 'peckham', 18.17147000, -77.39766000),
(1062875, 1003753, 'JM', 'Pennants', 1, 'pennants', 18.11025000, -77.31306000),
(1062886, 1003753, 'JM', 'Pleasant Valley', 1, 'pleasant-valley', 18.01101000, -77.29027000),
(1062897, 1003753, 'JM', 'Portland Cottage', 1, 'portland-cottage', 17.74620000, -77.18772000),
(1062901, 1003753, 'JM', 'Porus', 1, 'porus', 18.05202000, -77.40007000),
(1062910, 1003753, 'JM', 'Race Course', 1, 'race-course', 17.84019000, -77.28223000),
(1062930, 1003753, 'JM', 'Richmond Park', 1, 'richmond-park', 18.05172000, -77.37642000),
(1062934, 1003753, 'JM', 'Ritchies', 1, 'ritchies', 18.13904000, -77.42893000),
(1062942, 1003753, 'JM', 'Rock', 1, 'rock', 17.99122000, -77.33702000),
(1062944, 1003753, 'JM', 'Rock River', 1, 'rock-river', 18.06548000, -77.19707000),
(1062946, 1003753, 'JM', 'Rocky Point', 1, 'rocky-point', 17.77695000, -77.24816000),
(1062964, 1003753, 'JM', 'Salt River', 1, 'salt-river', 17.84143000, -77.17413000),
(1062969, 1003753, 'JM', 'Sandy Bay', 1, 'sandy-bay', 17.95105000, -77.16225000),
(1062970, 1003753, 'JM', 'Sanguinetti', 1, 'sanguinetti', 18.15585000, -77.42938000),
(1062984, 1003753, 'JM', 'Sedgepond', 1, 'sedgepond', 17.84753000, -77.32638000),
(1062992, 1003753, 'JM', 'Silent Hill', 1, 'silent-hill', 18.19152000, -77.45918000),
(1062998, 1003753, 'JM', 'Smithville', 1, 'smithville', 18.11977000, -77.38561000),
(1063006, 1003753, 'JM', 'Spaldings', 1, 'spaldings', 18.16875000, -77.45798000),
(1063040, 1003753, 'JM', 'Summerfield', 1, 'summerfield', 18.09433000, -77.28429000),
(1063048, 1003753, 'JM', 'Thompson Town', 1, 'thompson-town', 18.08968000, -77.37186000),
(1063053, 1003753, 'JM', 'Tollgate', 1, 'tollgate', 17.97195000, -77.36566000),
(1063061, 1003753, 'JM', 'Treadlight', 1, 'treadlight', 17.99264000, -77.25531000),
(1063067, 1003753, 'JM', 'Trout Hall', 1, 'trout-hall', 18.13779000, -77.33299000),
(1063071, 1003753, 'JM', 'Turners', 1, 'turners', 18.06647000, -77.23523000),
(1063087, 1003753, 'JM', 'Water Lane', 1, 'water-lane', 17.82452000, -77.25946000),
(1063119, 1003753, 'JM', 'Woodhall', 1, 'woodhall', 18.04757000, -77.27575000),
(1063127, 1003753, 'JM', 'York Town', 1, 'york-town', 17.92515000, -77.30002000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003749, 'JM', 'Hanover Parish', 1, 'hanover-parish');

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 
(1062322, 1003749, 'JM', 'Askenish', 1, 'askenish', 18.38492000, -78.14910000),
(1062409, 1003749, 'JM', 'Cacoon', 1, 'cacoon', 18.41642000, -78.20730000),
(1062410, 1003749, 'JM', 'Cacoon Castle', 1, 'cacoon-castle', 18.40247000, -78.01336000),
(1062422, 1003749, 'JM', 'Cascade', 1, 'cascade', 18.39747000, -78.10337000),
(1062425, 1003749, 'JM', 'Cash Hill', 1, 'cash-hill', 18.36920000, -78.10938000),
(1062432, 1003749, 'JM', 'Cauldwell', 1, 'cauldwell', 18.38583000, -78.24110000),
(1062443, 1003749, 'JM', 'Chambers Pen', 1, 'chambers-pen', 18.40520000, -78.15975000),
(1062452, 1003749, 'JM', 'Chester Castle', 1, 'chester-castle', 18.33822000, -77.94722000),
(1062479, 1003749, 'JM', 'Copse', 1, 'copse', 18.39466000, -77.97678000),
(1062484, 1003749, 'JM', 'Cousins Cove', 1, 'cousins-cove', 18.42425000, -78.23752000),
(1062512, 1003749, 'JM', 'Dias', 1, 'dias', 18.39379000, -78.18562000),
(1062608, 1003749, 'JM', 'Great Valley', 1, 'great-valley', 18.41169000, -78.05023000),
(1062610, 1003749, 'JM', 'Green Island', 1, 'green-island', 18.38399000, -78.27015000),
(1062620, 1003749, 'JM', 'Haddington', 1, 'haddington', 18.42043000, -78.00383000),
(1062657, 1003749, 'JM', 'Hopewell', 1, 'hopewell', 18.44321000, -78.02636000),
(1062672, 1003749, 'JM', 'Jericho', 1, 'jericho', 18.43744000, -78.13028000),
(1062685, 1003749, 'JM', 'Kendal', 1, 'kendal', 18.36287000, -78.22720000),
(1062693, 1003749, 'JM', 'Kingsvale', 1, 'kingsvale', 18.38087000, -78.20523000),
(1062702, 1003749, 'JM', 'Lances Bay', 1, 'lances-bay', 18.43819000, -78.21442000),
(1062723, 1003749, 'JM', 'Logwood', 1, 'logwood', 18.34878000, -78.29620000),
(1062731, 1003749, 'JM', 'Lucea', 1, 'lucea', 18.45095000, -78.17356000),
(1062732, 1003749, 'JM', 'Lucea East', 1, 'lucea-east', 18.42198000, -78.16675000),
(1062733, 1003749, 'JM', 'Lucea West', 1, 'lucea-west', 18.44238000, -78.18663000),
(1062752, 1003749, 'JM', 'March Town', 1, 'march-town', 18.32951000, -78.27656000),
(1062758, 1003749, 'JM', 'Maryland', 1, 'maryland', 18.38679000, -78.12825000),
(1062799, 1003749, 'JM', 'Mount Peto', 1, 'mount-peto', 18.35747000, -78.02289000),
(1062844, 1003749, 'JM', 'Orange Bay', 1, 'orange-bay', 18.34266000, -78.32005000),
(1062873, 1003749, 'JM', 'Pell River', 1, 'pell-river', 18.37886000, -78.21904000),
(1062890, 1003749, 'JM', 'Pondside', 1, 'pondside', 18.40222000, -78.07344000),
(1062913, 1003749, 'JM', 'Ramble', 1, 'ramble', 18.34674000, -77.98802000),
(1062945, 1003749, 'JM', 'Rock Spring', 1, 'rock-spring', 18.34797000, -78.24392000),
(1062968, 1003749, 'JM', 'Sandy Bay', 1, 'sandy-bay', 18.43750000, -78.08383000),
(1062972, 1003749, 'JM', 'Santoy', 1, 'santoy', 18.35875000, -78.28386000),
(1063038, 1003749, 'JM', 'Success', 1, 'success', 18.37729000, -78.05105000),
(1063120, 1003749, 'JM', 'Woodlands', 1, 'woodlands', 18.44555000, -77.99963000),
(1063123, 1003749, 'JM', 'Woodsville', 1, 'woodsville', 18.36950000, -78.07217000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003748, 'JM', 'Kingston Parish', 1, 'kingston-parish');

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 
(1062305, 1003748, 'JM', 'Allman Town', 1, 'allman-town', 17.98297000, -76.78685000),
(1062380, 1003748, 'JM', 'Bournemouth Gardens', 1, 'bournemouth-gardens', 17.97009000, -76.76266000),
(1062416, 1003748, 'JM', 'Campbell Town', 1, 'campbell-town', 17.97914000, -76.78134000),
(1062439, 1003748, 'JM', 'Central Down Town', 1, 'central-down-town', 17.96958000, -76.79264000),
(1062498, 1003748, 'JM', 'D\'Aguilar Town/ Rennock Lodge', 1, 'd-aguilar-town-rennock-lodge', 17.97001000, -76.73701000),
(1062509, 1003748, 'JM', 'Denham Town', 1, 'denham-town', 17.97812000, -76.79984000),
(1062530, 1003748, 'JM', 'East Down Town', 1, 'east-down-town', 17.97197000, -76.78471000),
(1062558, 1003748, 'JM', 'Fletchers Land', 1, 'fletchers-land', 17.97968000, -76.79100000),
(1062567, 1003748, 'JM', 'Franklyn Town', 1, 'franklyn-town', 17.97787000, -76.77339000),
(1062629, 1003748, 'JM', 'Hannah Town/ Craig Town', 1, 'hannah-town-craig-town', 17.97998000, -76.79430000),
(1062679, 1003748, 'JM', 'Johnson Town', 1, 'johnson-town', 17.97771000, -76.75593000),
(1062691, 1003748, 'JM', 'Kingston', 1, 'kingston', 17.99702000, -76.79358000),
(1062692, 1003748, 'JM', 'Kingston Gardens', 1, 'kingston-gardens', 17.97836000, -76.78681000),
(1062748, 1003748, 'JM', 'Manley Meadows', 1, 'manley-meadows', 17.96907000, -76.77116000),
(1062825, 1003748, 'JM', 'Newport East', 1, 'newport-east', 17.97421000, -76.80663000),
(1062827, 1003748, 'JM', 'Newton Square', 1, 'newton-square', 17.97352000, -76.77207000),
(1062831, 1003748, 'JM', 'Norman Gardens', 1, 'norman-gardens', 17.97803000, -76.75940000),
(1062866, 1003748, 'JM', 'Passmore Town', 1, 'passmore-town', 17.97301000, -76.77650000),
(1062895, 1003748, 'JM', 'Port Royal', 1, 'port-royal', 17.93738000, -76.84062000),
(1062911, 1003748, 'JM', 'Rae Town', 1, 'rae-town', 17.96773000, -76.77965000),
(1062949, 1003748, 'JM', 'Rollington Town', 1, 'rollington-town', 17.97687000, -76.76523000),
(1063005, 1003748, 'JM', 'Southside', 1, 'southside', 17.96569000, -76.78624000),
(1063016, 1003748, 'JM', 'Springfield', 1, 'springfield', 17.97117000, -76.75607000),
(1063052, 1003748, 'JM', 'Tivoli Gardens', 1, 'tivoli-gardens', 17.97326000, -76.80090000),
(1063096, 1003748, 'JM', 'West Down Town', 1, 'west-down-town', 17.97294000, -76.79704000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003754, 'JM', 'Manchester Parish', 1, 'manchester-parish');

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 
(1062304, 1003754, 'JM', 'Alligator Pond', 1, 'alligator-pond', 17.88369000, -77.56068000),
(1062321, 1003754, 'JM', 'Asia/Pratville', 1, 'asia-pratville', 17.91584000, -77.41563000),
(1062323, 1003754, 'JM', 'Auchtembeddie', 1, 'auchtembeddie', 18.22543000, -77.60361000),
(1062349, 1003754, 'JM', 'Bellefield', 1, 'bellefield', 18.09266000, -77.44004000),
(1062354, 1003754, 'JM', 'Bethany', 1, 'bethany', 18.15373000, -77.55032000),
(1062366, 1003754, 'JM', 'Blue Mountain', 1, 'blue-mountain', 18.07095000, -77.42840000),
(1062374, 1003754, 'JM', 'Bombay', 1, 'bombay', 18.11780000, -77.44940000),
(1062407, 1003754, 'JM', 'Butt-Up', 1, 'butt-up', 17.97313000, -77.57777000),
(1062437, 1003754, 'JM', 'Cedar Grove', 1, 'cedar-grove', 18.01225000, -77.49630000),
(1062444, 1003754, 'JM', 'Chantilly', 1, 'chantilly', 18.10447000, -77.46625000),
(1062453, 1003754, 'JM', 'Christiana', 1, 'christiana', 18.18015000, -77.49045000),
(1062454, 1003754, 'JM', 'Chudleigh', 1, 'chudleigh', 18.15148000, -77.50707000),
(1062460, 1003754, 'JM', 'Cobbla', 1, 'cobbla', 18.14060000, -77.46998000),
(1062465, 1003754, 'JM', 'Coleyville', 1, 'coleyville', 18.19993000, -77.51924000),
(1062467, 1003754, 'JM', 'Comfort', 1, 'comfort', 18.05390000, -77.42477000),
(1062470, 1003754, 'JM', 'Comfort Hall', 1, 'comfort-hall', 18.18789000, -77.61041000),
(1062474, 1003754, 'JM', 'Content', 1, 'content', 18.07444000, -77.45116000),
(1062486, 1003754, 'JM', 'Craig Head', 1, 'craig-head', 18.23658000, -77.56295000),
(1062492, 1003754, 'JM', 'Cross Keys', 1, 'cross-keys', 17.90727000, -77.50111000),
(1062510, 1003754, 'JM', 'Devon', 1, 'devon', 18.16595000, -77.52507000),
(1062517, 1003754, 'JM', 'Downs', 1, 'downs', 17.95004000, -77.57313000),
(1062536, 1003754, 'JM', 'Ellen Street', 1, 'ellen-street', 17.96796000, -77.43931000),
(1062543, 1003754, 'JM', 'Evergreen', 1, 'evergreen', 18.15096000, -77.59965000),
(1062547, 1003754, 'JM', 'Fairfield', 1, 'fairfield', 18.03117000, -77.57535000),
(1062571, 1003754, 'JM', 'French Park', 1, 'french-park', 17.95572000, -77.54471000),
(1062581, 1003754, 'JM', 'George\'s Valley', 1, 'george-s-valley', 18.03172000, -77.48081000),
(1062595, 1003754, 'JM', 'Good Intent', 1, 'good-intent', 18.20806000, -77.57086000),
(1062613, 1003754, 'JM', 'Greenvale', 1, 'greenvale', 18.03928000, -77.53239000),
(1062617, 1003754, 'JM', 'Grove Place', 1, 'grove-place', 18.10467000, -77.52923000),
(1062618, 1003754, 'JM', 'Grove Town', 1, 'grove-town', 17.88606000, -77.45882000),
(1062633, 1003754, 'JM', 'Harmons', 1, 'harmons', 17.98171000, -77.41208000),
(1062635, 1003754, 'JM', 'Harry Watch', 1, 'harry-watch', 18.17314000, -77.57611000),
(1062636, 1003754, 'JM', 'Hatfield', 1, 'hatfield', 18.01557000, -77.54009000),
(1062641, 1003754, 'JM', 'Heartease', 1, 'heartease', 18.04878000, -77.48238000),
(1062646, 1003754, 'JM', 'Hibernia', 1, 'hibernia', 18.17575000, -77.54830000),
(1062659, 1003754, 'JM', 'Huntley', 1, 'huntley', 18.06647000, -77.58171000),
(1062686, 1003754, 'JM', 'Kendal', 1, 'kendal', 18.08318000, -77.50320000),
(1062697, 1003754, 'JM', 'Knockpatrick', 1, 'knockpatrick', 17.99027000, -77.49270000),
(1062701, 1003754, 'JM', 'Lancaster', 1, 'lancaster', 17.93603000, -77.46134000),
(1062716, 1003754, 'JM', 'Litchfield', 1, 'litchfield', 18.13502000, -77.52448000),
(1062740, 1003754, 'JM', 'Maidstone', 1, 'maidstone', 18.10165000, -77.57284000),
(1062745, 1003754, 'JM', 'Mandeville', 1, 'mandeville', 18.04168000, -77.50714000),
(1062746, 1003754, 'JM', 'Mandeville Proper', 1, 'mandeville-proper', 18.04453000, -77.50574000),
(1062753, 1003754, 'JM', 'Marlie Hill', 1, 'marlie-hill', 17.86692000, -77.50835000),
(1062763, 1003754, 'JM', 'May Day', 1, 'may-day', 18.00951000, -77.47606000),
(1062769, 1003754, 'JM', 'Medina', 1, 'medina', 18.12236000, -77.59643000),
(1062773, 1003754, 'JM', 'Mike Town', 1, 'mike-town', 18.04253000, -77.55490000),
(1062775, 1003754, 'JM', 'Mile Gully', 1, 'mile-gully', 18.13395000, -77.56556000),
(1062813, 1003754, 'JM', 'New Forest', 1, 'new-forest', 17.92010000, -77.55867000),
(1062814, 1003754, 'JM', 'New Green', 1, 'new-green', 18.07663000, -77.52569000),
(1062824, 1003754, 'JM', 'Newport', 1, 'newport', 17.96293000, -77.50486000),
(1062837, 1003754, 'JM', 'Old England', 1, 'old-england', 17.98503000, -77.46017000),
(1062856, 1003754, 'JM', 'Part Of Banana Ground', 1, 'part-of-banana-ground', 18.07912000, -77.42134000),
(1062857, 1003754, 'JM', 'Part Of Gutters', 1, 'part-of-gutters', 18.00642000, -77.57903000),
(1062864, 1003754, 'JM', 'Part of Spaldings', 1, 'part-of-spaldings', 18.15819000, -77.46627000),
(1062882, 1003754, 'JM', 'Pike', 1, 'pike', 18.23229000, -77.53790000),
(1062887, 1003754, 'JM', 'Plowden', 1, 'plowden', 17.89178000, -77.53846000),
(1062900, 1003754, 'JM', 'Porus', 1, 'porus', 18.03535000, -77.41166000),
(1062905, 1003754, 'JM', 'Prospect', 1, 'prospect', 17.98244000, -77.56775000),
(1062929, 1003754, 'JM', 'Richmond', 1, 'richmond', 18.02560000, -77.46337000),
(1062941, 1003754, 'JM', 'Robins Hall', 1, 'robins-hall', 18.20405000, -77.55007000),
(1062953, 1003754, 'JM', 'Rose Hill', 1, 'rose-hill', 17.92471000, -77.52340000),
(1062958, 1003754, 'JM', 'Royal Flat', 1, 'royal-flat', 18.04965000, -77.46830000),
(1062978, 1003754, 'JM', 'Scotts Pass', 1, 'scotts-pass', 17.99920000, -77.39820000),
(1063000, 1003754, 'JM', 'Snowdon', 1, 'snowdon', 17.94198000, -77.49137000),
(1063002, 1003754, 'JM', 'Somerset', 1, 'somerset', 18.08036000, -77.54306000),
(1063014, 1003754, 'JM', 'Spring Ground', 1, 'spring-ground', 18.16233000, -77.47977000),
(1063018, 1003754, 'JM', 'Spur Tree', 1, 'spur-tree', 18.00650000, -77.55664000),
(1063025, 1003754, 'JM', 'St. Paul\'s', 1, 'st-paul-s', 18.13144000, -77.61200000),
(1063043, 1003754, 'JM', 'Swaby\'s Hope', 1, 'swaby-s-hope', 17.98608000, -77.53326000),
(1063055, 1003754, 'JM', 'Top Hill', 1, 'top-hill', 18.11622000, -77.50344000),
(1063076, 1003754, 'JM', 'Victoria Town', 1, 'victoria-town', 17.90472000, -77.37795000),
(1063080, 1003754, 'JM', 'Walderston', 1, 'walderston', 18.11637000, -77.48614000),
(1063092, 1003754, 'JM', 'Watham', 1, 'watham', 18.00675000, -77.51873000),
(1063107, 1003754, 'JM', 'Williamsfield', 1, 'williamsfield', 18.06664000, -77.46582000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003752, 'JM', 'Portland Parish', 1, 'portland-parish');

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 
(1062327, 1003752, 'JM', 'Balcarres', 1, 'balcarres', 18.16735000, -76.72061000),
(1062330, 1003752, 'JM', 'Bangor Ridge', 1, 'bangor-ridge', 18.13637000, -76.68903000),
(1062351, 1003752, 'JM', 'Belvedere', 1, 'belvedere', 18.20772000, -76.69671000),
(1062362, 1003752, 'JM', 'Black Hill', 1, 'black-hill', 18.21786000, -76.59758000),
(1062378, 1003752, 'JM', 'Boundbrook', 1, 'boundbrook', 18.17573000, -76.47079000),
(1062388, 1003752, 'JM', 'Breastworks', 1, 'breastworks', 18.16000000, -76.46612000),
(1062399, 1003752, 'JM', 'Buff Bay', 1, 'buff-bay', 18.23287000, -76.66118000),
(1062408, 1003752, 'JM', 'Bybrook', 1, 'bybrook', 18.14641000, -76.65726000),
(1062423, 1003752, 'JM', 'Cascade', 1, 'cascade', 18.09377000, -76.71223000),
(1062427, 1003752, 'JM', 'Castle Comfort', 1, 'castle-comfort', 18.14217000, -76.34634000),
(1062440, 1003752, 'JM', 'Central Port Antonio', 1, 'central-port-antonio', 18.18763000, -76.45343000),
(1062447, 1003752, 'JM', 'Charles Town', 1, 'charles-town', 18.20526000, -76.66390000),
(1062458, 1003752, 'JM', 'Claverty Cottage', 1, 'claverty-cottage', 18.14876000, -76.63923000),
(1062468, 1003752, 'JM', 'Comfort Castle', 1, 'comfort-castle', 18.04833000, -76.41614000),
(1062518, 1003752, 'JM', 'Drapers', 1, 'drapers', 18.17121000, -76.40612000),
(1062528, 1003752, 'JM', 'Durham', 1, 'durham', 18.08566000, -76.51562000),
(1062548, 1003752, 'JM', 'Fairy Hill', 1, 'fairy-hill', 18.16508000, -76.36595000),
(1062552, 1003752, 'JM', 'Fellowship', 1, 'fellowship', 18.12783000, -76.47202000),
(1062575, 1003752, 'JM', 'Fruitfulvale', 1, 'fruitfulvale', 18.10891000, -76.58617000),
(1062642, 1003752, 'JM', 'Hectors River', 1, 'hectors-river', 18.00089000, -76.27055000),
(1062652, 1003752, 'JM', 'Hope Bay', 1, 'hope-bay', 18.18754000, -76.57579000),
(1062687, 1003752, 'JM', 'Kensington', 1, 'kensington', 18.06765000, -76.30053000),
(1062724, 1003752, 'JM', 'Long Bay', 1, 'long-bay', 18.08581000, -76.32515000),
(1062726, 1003752, 'JM', 'Long Road', 1, 'long-road', 18.00864000, -76.29482000),
(1062744, 1003752, 'JM', 'Manchioneal', 1, 'manchioneal', 18.04444000, -76.27735000),
(1062787, 1003752, 'JM', 'Moore Town', 1, 'moore-town', 18.07767000, -76.42577000),
(1062800, 1003752, 'JM', 'Mount Pleasant', 1, 'mount-pleasant', 18.16325000, -76.50472000),
(1062829, 1003752, 'JM', 'Nonsuch', 1, 'nonsuch', 18.13819000, -76.40467000),
(1062832, 1003752, 'JM', 'Norwich', 1, 'norwich', 18.18819000, -76.47705000),
(1062843, 1003752, 'JM', 'Orange Bay', 1, 'orange-bay', 18.20306000, -76.62250000),
(1062892, 1003752, 'JM', 'Port Antonio', 1, 'port-antonio', 18.17615000, -76.45090000),
(1062904, 1003752, 'JM', 'Prospect', 1, 'prospect', 18.17481000, -76.43550000),
(1062943, 1003752, 'JM', 'Rock Hall', 1, 'rock-hall', 18.16170000, -76.53050000),
(1062989, 1003752, 'JM', 'Sherwood Forest', 1, 'sherwood-forest', 18.15428000, -76.37821000),
(1062990, 1003752, 'JM', 'Shirley Castle', 1, 'shirley-castle', 18.15657000, -76.61112000),
(1062994, 1003752, 'JM', 'Skibo', 1, 'skibo', 18.17318000, -76.62752000),
(1062999, 1003752, 'JM', 'Snow Hill', 1, 'snow-hill', 18.19474000, -76.49350000),
(1063015, 1003752, 'JM', 'Spring Hill', 1, 'spring-hill', 18.12591000, -76.72909000),
(1063024, 1003752, 'JM', 'St. Margaret\'s Bay', 1, 'st-margaret-s-bay', 18.19084000, -76.52888000),
(1063045, 1003752, 'JM', 'Swift River', 1, 'swift-river', 18.15770000, -76.57869000),
(1063060, 1003752, 'JM', 'Tranquility', 1, 'tranquility', 18.18028000, -76.68150000),
(1063113, 1003752, 'JM', 'Windsor', 1, 'windsor', 18.10673000, -76.44631000),
(1063114, 1003752, 'JM', 'Windsor Castle', 1, 'windsor-castle', 18.24888000, -76.69029000),
(1063115, 1003752, 'JM', 'Windsor Forest', 1, 'windsor-forest', 18.12057000, -76.33876000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003751, 'JM', 'Saint Andrew', 1, 'saint-andrew');

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 
(1062316, 1003751, 'JM', 'Arcadia', 1, 'arcadia', 18.03737000, -76.78201000),
(1062317, 1003751, 'JM', 'Arlene Gardens', 1, 'arlene-gardens', 18.03713000, -76.81791000),
(1062318, 1003751, 'JM', 'Arnett Gardens', 1, 'arnett-gardens', 17.99150000, -76.79829000),
(1062324, 1003751, 'JM', 'August Town', 1, 'august-town', 17.99556000, -76.73673000),
(1062334, 1003751, 'JM', 'Barbican', 1, 'barbican', 18.03549000, -76.76987000),
(1062357, 1003751, 'JM', 'Beverley Hills', 1, 'beverley-hills', 18.00833000, -76.76208000),
(1062361, 1003751, 'JM', 'Bito', 1, 'bito', 17.97363000, -76.66625000),
(1062365, 1003751, 'JM', 'Bloxborough', 1, 'bloxborough', 17.99581000, -76.64767000),
(1062377, 1003751, 'JM', 'Boucher Park', 1, 'boucher-park', 18.00344000, -76.81257000),
(1062385, 1003751, 'JM', 'Brandon Hill', 1, 'brandon-hill', 18.14822000, -76.80513000),
(1062400, 1003751, 'JM', 'Bull Bay/ Seven Mile', 1, 'bull-bay-seven-mile', 17.95247000, -76.68404000),
(1062417, 1003751, 'JM', 'Cane River', 1, 'cane-river', 17.98098000, -76.68624000),
(1062426, 1003751, 'JM', 'Cassia Park', 1, 'cassia-park', 18.02047000, -76.80665000),
(1062433, 1003751, 'JM', 'Cavaliers', 1, 'cavaliers', 18.09677000, -76.84321000),
(1062450, 1003751, 'JM', 'Cherry Gardens', 1, 'cherry-gardens', 18.04963000, -76.77867000),
(1062461, 1003751, 'JM', 'Cockburn Gardens', 1, 'cockburn-gardens', 18.00357000, -76.82435000),
(1062471, 1003751, 'JM', 'Constant Spring', 1, 'constant-spring', 18.05078000, -76.79372000),
(1062472, 1003751, 'JM', 'Constant Spring Gardens', 1, 'constant-spring-gardens', 18.02942000, -76.79956000),
(1062473, 1003751, 'JM', 'Constitution Hill', 1, 'constitution-hill', 18.01488000, -76.70515000),
(1062476, 1003751, 'JM', 'Content Gap', 1, 'content-gap', 18.04082000, -76.69070000),
(1062478, 1003751, 'JM', 'Cooreville Gardens', 1, 'cooreville-gardens', 18.02244000, -76.84852000),
(1062493, 1003751, 'JM', 'Cross Roads', 1, 'cross-roads', 17.99454000, -76.78810000),
(1062499, 1003751, 'JM', 'Dallas', 1, 'dallas', 17.98463000, -76.71256000),
(1062506, 1003751, 'JM', 'Delacree Park/ Union Gardens', 1, 'delacree-park-union-gardens', 17.99210000, -76.82240000),
(1062507, 1003751, 'JM', 'Delacree Pen', 1, 'delacree-pen', 17.99579000, -76.81709000),
(1062519, 1003751, 'JM', 'Drewsland', 1, 'drewsland', 18.02381000, -76.82626000),
(1062520, 1003751, 'JM', 'Drumblair', 1, 'drumblair', 18.02354000, -76.78759000),
(1062523, 1003751, 'JM', 'Duhaney Park', 1, 'duhaney-park', 18.03086000, -76.84617000),
(1062531, 1003751, 'JM', 'Eastwood Park Gardens', 1, 'eastwood-park-gardens', 18.01891000, -76.80072000),
(1062537, 1003751, 'JM', 'Elleston Flats/ Mona Commons', 1, 'elleston-flats-mona-commons', 18.00945000, -76.74034000),
(1062554, 1003751, 'JM', 'Ferry', 1, 'ferry', 18.02771000, -76.86720000),
(1062562, 1003751, 'JM', 'Forest Hills Gardens', 1, 'forest-hills-gardens', 18.03848000, -76.82868000),
(1062563, 1003751, 'JM', 'Forest Hills/ Plantation Height', 1, 'forest-hills-plantation-height', 18.04300000, -76.85140000),
(1062594, 1003751, 'JM', 'Golden Spring', 1, 'golden-spring', 18.09446000, -76.79727000),
(1062598, 1003751, 'JM', 'Gordon Town', 1, 'gordon-town', 18.03762000, -76.72353000),
(1062603, 1003751, 'JM', 'Grants Pen', 1, 'grants-pen', 18.03258000, -76.78887000),
(1062614, 1003751, 'JM', 'Greenwich Town/ Newport West', 1, 'greenwich-town-newport-west', 17.98438000, -76.82559000),
(1062623, 1003751, 'JM', 'Half Way Tree', 1, 'half-way-tree', 18.01248000, -76.79928000),
(1062624, 1003751, 'JM', 'Half-Way-Tree', 1, 'half-way-tree', 18.01259000, -76.79582000),
(1062630, 1003751, 'JM', 'Harbour View', 1, 'harbour-view', 17.95146000, -76.71662000),
(1062637, 1003751, 'JM', 'Havendale', 1, 'havendale', 18.05429000, -76.80870000),
(1062644, 1003751, 'JM', 'Hermitage', 1, 'hermitage', 17.98351000, -76.74102000),
(1062653, 1003751, 'JM', 'Hope Pastures/ UTECH', 1, 'hope-pastures-utech', 18.02306000, -76.74987000),
(1062654, 1003751, 'JM', 'Hope Tavern', 1, 'hope-tavern', 18.01233000, -76.73202000),
(1062658, 1003751, 'JM', 'Hughenden', 1, 'hughenden', 18.03037000, -76.81728000),
(1062663, 1003751, 'JM', 'Irish Town', 1, 'irish-town', 18.06234000, -76.70262000),
(1062667, 1003751, 'JM', 'Jacks Hill', 1, 'jacks-hill', 18.03872000, -76.74892000),
(1062681, 1003751, 'JM', 'Jones Town', 1, 'jones-town', 17.98422000, -76.79691000),
(1062684, 1003751, 'JM', 'Kencot', 1, 'kencot', 18.00041000, -76.79835000),
(1062695, 1003751, 'JM', 'Kintyre', 1, 'kintyre', 18.02133000, -76.72688000),
(1062703, 1003751, 'JM', 'Lawrence Tavern', 1, 'lawrence-tavern', 18.13742000, -76.84736000),
(1062708, 1003751, 'JM', 'Liguanea', 1, 'liguanea', 18.02097000, -76.76827000),
(1062741, 1003751, 'JM', 'Majestic Gardens', 1, 'majestic-gardens', 18.00023000, -76.83295000),
(1062749, 1003751, 'JM', 'Mannings Hill', 1, 'mannings-hill', 18.07052000, -76.81288000),
(1062750, 1003751, 'JM', 'Mannings Hill (Rural)', 1, 'mannings-hill-rural', 18.08169000, -76.82328000),
(1062757, 1003751, 'JM', 'Marverley', 1, 'marverley', 18.02676000, -76.82652000),
(1062759, 1003751, 'JM', 'Maryland', 1, 'maryland', 18.05166000, -76.74320000),
(1062761, 1003751, 'JM', 'Mavis Bank', 1, 'mavis-bank', 18.03333000, -76.66667000),
(1062762, 1003751, 'JM', 'Maxfield Park', 1, 'maxfield-park', 17.99937000, -76.80800000),
(1062766, 1003751, 'JM', 'Meadowbrook', 1, 'meadowbrook', 18.04708000, -76.81553000),
(1062767, 1003751, 'JM', 'Meadowbrook Estate', 1, 'meadowbrook-estate', 18.03738000, -76.82964000),
(1062780, 1003751, 'JM', 'Molynes Four Roads', 1, 'molynes-four-roads', 18.01035000, -76.81112000),
(1062781, 1003751, 'JM', 'Molynes Gardens', 1, 'molynes-gardens', 18.01980000, -76.81621000),
(1062782, 1003751, 'JM', 'Mona Heights', 1, 'mona-heights', 18.01331000, -76.75086000),
(1062796, 1003751, 'JM', 'Mount James', 1, 'mount-james', 18.12069000, -76.77394000),
(1062804, 1003751, 'JM', 'Mountain View Gardens', 1, 'mountain-view-gardens', 17.99186000, -76.76070000),
(1062810, 1003751, 'JM', 'Nannyville', 1, 'nannyville', 17.99677000, -76.76949000),
(1062815, 1003751, 'JM', 'New Haven', 1, 'new-haven', 18.02953000, -76.85425000),
(1062816, 1003751, 'JM', 'New Kingston', 1, 'new-kingston', 18.00747000, -76.78319000),
(1062830, 1003751, 'JM', 'Norbrook', 1, 'norbrook', 18.05483000, -76.78498000),
(1062834, 1003751, 'JM', 'Oaklands', 1, 'oaklands', 18.03558000, -76.79563000),
(1062851, 1003751, 'JM', 'Papine', 1, 'papine', 18.01536000, -76.73868000),
(1062853, 1003751, 'JM', 'Parks Road', 1, 'parks-road', 18.09802000, -76.85941000),
(1062867, 1003751, 'JM', 'Patrick City', 1, 'patrick-city', 18.03185000, -76.83774000),
(1062874, 1003751, 'JM', 'Pembroke Hall', 1, 'pembroke-hall', 18.03113000, -76.83003000),
(1062876, 1003751, 'JM', 'Penwood', 1, 'penwood', 18.01952000, -76.83094000),
(1062908, 1003751, 'JM', 'Queensborough/ Tunbridge', 1, 'queensborough-tunbridge', 18.04289000, -76.82119000),
(1062917, 1003751, 'JM', 'Red Hills (Rural)', 1, 'red-hills-rural', 18.06777000, -76.86093000),
(1062918, 1003751, 'JM', 'Red Hills Gardens', 1, 'red-hills-gardens', 18.03000000, -76.80994000),
(1062919, 1003751, 'JM', 'Red Hills/ Sterling Castle', 1, 'red-hills-sterling-castle', 18.05946000, -76.84028000),
(1062931, 1003751, 'JM', 'Richmond Park', 1, 'richmond-park', 18.00560000, -76.80464000),
(1062938, 1003751, 'JM', 'Riverton City', 1, 'riverton-city', 18.01443000, -76.84897000),
(1062947, 1003751, 'JM', 'Roehampton', 1, 'roehampton', 18.04320000, -76.80841000),
(1062955, 1003751, 'JM', 'Rose Town', 1, 'rose-town', 17.98697000, -76.80726000),
(1062982, 1003751, 'JM', 'Seaview Gardens', 1, 'seaview-gardens', 18.00619000, -76.84106000),
(1062983, 1003751, 'JM', 'Seaward Pen', 1, 'seaward-pen', 18.01900000, -76.82368000),
(1062986, 1003751, 'JM', 'Seymour Lands', 1, 'seymour-lands', 18.01291000, -76.77706000),
(1063026, 1003751, 'JM', 'St. Peter\'s', 1, 'st-peter-s', 18.07881000, -76.67202000),
(1063028, 1003751, 'JM', 'Stadium Gardens', 1, 'stadium-gardens', 17.99501000, -76.77644000),
(1063033, 1003751, 'JM', 'Stony Hill', 1, 'stony-hill', 18.07916000, -76.78473000),
(1063044, 1003751, 'JM', 'Swallowfield', 1, 'swallowfield', 18.00486000, -76.77439000),
(1063047, 1003751, 'JM', 'Temple Hall', 1, 'temple-hall', 18.10471000, -76.81818000),
(1063051, 1003751, 'JM', 'Three Oaks/ Glendale', 1, 'three-oaks-glendale', 18.03128000, -76.82447000),
(1063056, 1003751, 'JM', 'Tower Hill', 1, 'tower-hill', 18.01183000, -76.82807000),
(1063059, 1003751, 'JM', 'Trafalgar Park', 1, 'trafalgar-park', 18.01280000, -76.78465000),
(1063063, 1003751, 'JM', 'Trench Town', 1, 'trench-town', 17.98743000, -76.80118000),
(1063074, 1003751, 'JM', 'University', 1, 'university', 18.00094000, -76.74769000),
(1063077, 1003751, 'JM', 'Vineyard Town', 1, 'vineyard-town', 17.98690000, -76.77059000),
(1063082, 1003751, 'JM', 'Waltham Gardens', 1, 'waltham-gardens', 18.01085000, -76.82049000),
(1063085, 1003751, 'JM', 'Washington Gardens', 1, 'washington-gardens', 18.02174000, -76.84020000),
(1063090, 1003751, 'JM', 'Waterhouse', 1, 'waterhouse', 18.01231000, -76.83505000),
(1063102, 1003751, 'JM', 'Whitehall', 1, 'whitehall', 18.03838000, -76.80583000),
(1063104, 1003751, 'JM', 'Whitfield Town', 1, 'whitfield-town', 17.99212000, -76.80910000),
(1063111, 1003751, 'JM', 'Wilton Gardens/ Rema', 1, 'wilton-gardens-rema', 17.98287000, -76.80422000),
(1063117, 1003751, 'JM', 'Woodford', 1, 'woodford', 18.07362000, -76.74632000),
(1063118, 1003751, 'JM', 'Woodford Park', 1, 'woodford-park', 17.98712000, -76.78117000),
(1063128, 1003751, 'JM', 'Zaidie Gardens', 1, 'zaidie-gardens', 18.02566000, -76.80978000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003744, 'JM', 'Saint Ann Parish', 1, 'saint-ann-parish');

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 
(1062291, 1003744, 'JM', 'Aboukir', 1, 'aboukir', 18.25090000, -77.34327000),
(1062300, 1003744, 'JM', 'Alderton', 1, 'alderton', 18.28706000, -77.20832000),
(1062301, 1003744, 'JM', 'Alexandria', 1, 'alexandria', 18.30411000, -77.35311000),
(1062308, 1003744, 'JM', 'Alva', 1, 'alva', 18.29679000, -77.31717000),
(1062329, 1003744, 'JM', 'Bamboo', 1, 'bamboo', 18.39216000, -77.26429000),
(1062345, 1003744, 'JM', 'Beecher Town', 1, 'beecher-town', 18.38465000, -77.11617000),
(1062352, 1003744, 'JM', 'Bensonton', 1, 'bensonton', 18.22315000, -77.20861000),
(1062364, 1003744, 'JM', 'Blackstonedge', 1, 'blackstonedge', 18.27357000, -77.04254000),
(1062373, 1003744, 'JM', 'Bohemia', 1, 'bohemia', 18.21239000, -77.46954000),
(1062376, 1003744, 'JM', 'Borobridge', 1, 'borobridge', 18.19779000, -77.42755000),
(1062396, 1003744, 'JM', 'Browns Town', 1, 'browns-town', 18.38464000, -77.35286000),
(1062412, 1003744, 'JM', 'Calderwood', 1, 'calderwood', 18.25641000, -77.27144000),
(1062424, 1003744, 'JM', 'Cascade', 1, 'cascade', 18.23209000, -77.46255000),
(1062435, 1003744, 'JM', 'Cave Valley', 1, 'cave-valley', 18.23268000, -77.36337000),
(1062442, 1003744, 'JM', 'Chalky Hill', 1, 'chalky-hill', 18.37964000, -77.17520000),
(1062451, 1003744, 'JM', 'Chester', 1, 'chester', 18.44786000, -77.26503000),
(1062456, 1003744, 'JM', 'Claremont', 1, 'claremont', 18.32556000, -77.20643000),
(1062464, 1003744, 'JM', 'Cole Gate', 1, 'cole-gate', 18.37967000, -77.08518000),
(1062477, 1003744, 'JM', 'Content Garden', 1, 'content-garden', 18.40977000, -77.07540000),
(1062494, 1003744, 'JM', 'Cuffie Ridge', 1, 'cuffie-ridge', 18.22793000, -77.42054000),
(1062514, 1003744, 'JM', 'Discovery Bay', 1, 'discovery-bay', 18.43725000, -77.41815000),
(1062542, 1003744, 'JM', 'Epworth', 1, 'epworth', 18.36083000, -77.13342000),
(1062545, 1003744, 'JM', 'Exchange', 1, 'exchange', 18.37265000, -77.06572000),
(1062549, 1003744, 'JM', 'Faith\'s Pen', 1, 'faith-s-pen', 18.22963000, -77.08804000),
(1062583, 1003744, 'JM', 'Gibraltar', 1, 'gibraltar', 18.35079000, -77.42142000),
(1062593, 1003744, 'JM', 'Golden Grove', 1, 'golden-grove', 18.32956000, -77.12256000),
(1062607, 1003744, 'JM', 'Great Pond', 1, 'great-pond', 18.40227000, -77.08511000),
(1062647, 1003744, 'JM', 'Higgin Land', 1, 'higgin-land', 18.34119000, -77.27072000),
(1062650, 1003744, 'JM', 'Hinds Town', 1, 'hinds-town', 18.35425000, -77.09812000),
(1062662, 1003744, 'JM', 'Inverness', 1, 'inverness', 18.27531000, -77.36862000),
(1062710, 1003744, 'JM', 'Lime Hall', 1, 'lime-hall', 18.39742000, -77.21051000),
(1062711, 1003744, 'JM', 'Lime Tree Gardens', 1, 'lime-tree-gardens', 18.34545000, -77.38645000),
(1062714, 1003744, 'JM', 'Linton Park', 1, 'linton-park', 18.26081000, -77.42221000),
(1062737, 1003744, 'JM', 'Macknie', 1, 'macknie', 18.21191000, -77.28016000),
(1062738, 1003744, 'JM', 'Madras', 1, 'madras', 18.29112000, -77.44875000),
(1062751, 1003744, 'JM', 'Mansfield', 1, 'mansfield', 18.40265000, -77.09488000),
(1062783, 1003744, 'JM', 'Moneague', 1, 'moneague', 18.28307000, -77.13855000),
(1062798, 1003744, 'JM', 'Mount Moriah', 1, 'mount-moriah', 18.20617000, -77.44094000),
(1062803, 1003744, 'JM', 'Mount Zion', 1, 'mount-zion', 18.43377000, -77.28028000),
(1062835, 1003744, 'JM', 'Ocho Rios', 1, 'ocho-rios', 18.40760000, -77.10312000),
(1062855, 1003744, 'JM', 'Parry Town', 1, 'parry-town', 18.38359000, -77.10345000),
(1062881, 1003744, 'JM', 'Philadelphia', 1, 'philadelphia', 18.40005000, -77.32735000),
(1062883, 1003744, 'JM', 'Pimento Walk', 1, 'pimento-walk', 18.39578000, -77.11383000),
(1062903, 1003744, 'JM', 'Priory', 1, 'priory', 18.43660000, -77.24551000),
(1062935, 1003744, 'JM', 'River Head', 1, 'river-head', 18.26030000, -77.07782000),
(1062959, 1003744, 'JM', 'Runaway Bay', 1, 'runaway-bay', 18.45962000, -77.33570000),
(1062962, 1003744, 'JM', 'Saint Ann’s Bay', 1, 'saint-ann-s-bay', 18.43581000, -77.20098000),
(1063019, 1003744, 'JM', 'St. Ann\'s Bay', 1, 'st-ann-s-bay', 18.42989000, -77.20775000),
(1063020, 1003744, 'JM', 'St. D\'Acre', 1, 'st-d-acre', 18.33300000, -77.36297000),
(1063029, 1003744, 'JM', 'Steer Town', 1, 'steer-town', 18.42852000, -77.17101000),
(1063037, 1003744, 'JM', 'Sturge Town', 1, 'sturge-town', 18.41631000, -77.31988000),
(1063081, 1003744, 'JM', 'Walkers Wood', 1, 'walkers-wood', 18.31939000, -77.07082000),
(1063093, 1003744, 'JM', 'Watt Town', 1, 'watt-town', 18.29427000, -77.41466000),
(1063126, 1003744, 'JM', 'York Castle', 1, 'york-castle', 18.27515000, -77.22923000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003746, 'JM', 'Saint Catherine Parish', 1, 'saint-catherine-parish');

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 
(1062292, 1003746, 'JM', 'Above Rocks', 1, 'above-rocks', 18.11432000, -76.87590000),
(1062338, 1003746, 'JM', 'Bartons', 1, 'bartons', 18.02895000, -77.13322000),
(1062348, 1003746, 'JM', 'Bellas Gate', 1, 'bellas-gate', 18.04715000, -77.14906000),
(1062369, 1003746, 'JM', 'Bog Walk', 1, 'bog-walk', 18.10205000, -77.00541000),
(1062372, 1003746, 'JM', 'Bogwalk', 1, 'bogwalk', 18.10468000, -76.98792000),
(1062382, 1003746, 'JM', 'Braeton', 1, 'braeton', 17.94174000, -76.88635000),
(1062389, 1003746, 'JM', 'Bridgeport', 1, 'bridgeport', 17.96264000, -76.87809000),
(1062395, 1003746, 'JM', 'Browns Hill', 1, 'browns-hill', 18.05358000, -77.11855000),
(1062436, 1003746, 'JM', 'Caymanas', 1, 'caymanas', 18.03824000, -76.89833000),
(1062441, 1003746, 'JM', 'Central Village', 1, 'central-village', 17.99992000, -76.92393000),
(1062488, 1003746, 'JM', 'Crescent', 1, 'crescent', 18.03621000, -76.97626000),
(1062490, 1003746, 'JM', 'Cromarty', 1, 'cromarty', 17.95840000, -76.98457000),
(1062495, 1003746, 'JM', 'Cumberland', 1, 'cumberland', 17.97650000, -76.88208000),
(1062532, 1003746, 'JM', 'Edgewater', 1, 'edgewater', 17.96448000, -76.86547000),
(1062540, 1003746, 'JM', 'Ensom', 1, 'ensom', 18.01778000, -76.96221000),
(1062544, 1003746, 'JM', 'Ewarton', 1, 'ewarton', 18.18333000, -77.08536000),
(1062587, 1003746, 'JM', 'Ginger Ridge', 1, 'ginger-ridge', 18.07688000, -77.16865000),
(1062589, 1003746, 'JM', 'Glengoffe', 1, 'glengoffe', 18.15214000, -76.89057000),
(1062591, 1003746, 'JM', 'Golden Acres', 1, 'golden-acres', 18.01950000, -76.98040000),
(1062609, 1003746, 'JM', 'Greater Portmore', 1, 'greater-portmore', 17.95228000, -76.91133000),
(1062612, 1003746, 'JM', 'Greendale', 1, 'greendale', 18.01251000, -76.94831000),
(1062616, 1003746, 'JM', 'Gregory Park', 1, 'gregory-park', 17.99490000, -76.88302000),
(1062628, 1003746, 'JM', 'Hampton Green', 1, 'hampton-green', 18.00544000, -76.96818000),
(1062631, 1003746, 'JM', 'Harewood', 1, 'harewood', 18.17277000, -76.94395000),
(1062632, 1003746, 'JM', 'Harkers Hall', 1, 'harkers-hall', 18.13149000, -76.91350000),
(1062643, 1003746, 'JM', 'Hellshire', 1, 'hellshire', 17.89669000, -76.96187000),
(1062660, 1003746, 'JM', 'Independence City', 1, 'independence-city', 17.97783000, -76.87498000),
(1062689, 1003746, 'JM', 'Keystone', 1, 'keystone', 18.01652000, -76.93525000),
(1062696, 1003746, 'JM', 'Kitson Town', 1, 'kitson-town', 18.03487000, -77.04028000),
(1062713, 1003746, 'JM', 'Linstead', 1, 'linstead', 18.13683000, -77.03171000),
(1062722, 1003746, 'JM', 'Lluidas Vale', 1, 'lluidas-vale', 18.14977000, -77.16853000),
(1062808, 1003746, 'JM', 'Naggo Head', 1, 'naggo-head', 17.96415000, -76.88820000),
(1062838, 1003746, 'JM', 'Old Harbour', 1, 'old-harbour', 17.94144000, -77.10898000),
(1062839, 1003746, 'JM', 'Old Harbour Bay', 1, 'old-harbour-bay', 17.90918000, -77.09718000),
(1062840, 1003746, 'JM', 'Old Harbour Road', 1, 'old-harbour-road', 17.95797000, -77.02730000),
(1062860, 1003746, 'JM', 'Part of Guys Hill', 1, 'part-of-guys-hill', 18.24525000, -76.99081000),
(1062862, 1003746, 'JM', 'Part of Keystone', 1, 'part-of-keystone', 18.03965000, -76.95113000),
(1062863, 1003746, 'JM', 'Part of Rock Hall', 1, 'part-of-rock-hall', 18.09119000, -76.88804000),
(1062865, 1003746, 'JM', 'Passage Fort', 1, 'passage-fort', 17.97788000, -76.86793000),
(1062870, 1003746, 'JM', 'Pear Tree Grove', 1, 'pear-tree-grove', 18.22515000, -76.95293000),
(1062888, 1003746, 'JM', 'Point Hill', 1, 'point-hill', 18.09361000, -77.10480000),
(1062898, 1003746, 'JM', 'Portmore', 1, 'portmore', 17.95032000, -76.88215000),
(1062920, 1003746, 'JM', 'Redwood', 1, 'redwood', 18.21026000, -76.98536000),
(1062937, 1003746, 'JM', 'Riversdale', 1, 'riversdale', 18.17802000, -76.96636000),
(1062995, 1003746, 'JM', 'Sligoville', 1, 'sligoville', 18.08203000, -76.93991000),
(1063007, 1003746, 'JM', 'Spanish Town', 1, 'spanish-town', 17.99107000, -76.95742000),
(1063008, 1003746, 'JM', 'Spanish Town Central', 1, 'spanish-town-central', 17.98014000, -76.92294000),
(1063021, 1003746, 'JM', 'St. John\'s East', 1, 'st-john-s-east', 18.00090000, -76.97466000),
(1063022, 1003746, 'JM', 'St. John\'s West', 1, 'st-john-s-west', 18.00539000, -77.00755000),
(1063066, 1003746, 'JM', 'Troja', 1, 'troja', 18.20485000, -76.93196000),
(1063089, 1003746, 'JM', 'Waterford', 1, 'waterford', 17.99340000, -76.86090000),
(1063091, 1003746, 'JM', 'Watermount', 1, 'watermount', 18.06686000, -77.09112000),
(1063095, 1003746, 'JM', 'West Cumberland', 1, 'west-cumberland', 17.97890000, -76.88662000),
(1063108, 1003746, 'JM', 'Willowdene', 1, 'willowdene', 17.99189000, -76.98199000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003743, 'JM', 'Saint Elizabeth Parish', 1, 'saint-elizabeth-parish');

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 
(1062290, 1003743, 'JM', 'Aberdeen', 1, 'aberdeen', 18.20508000, -77.67932000),
(1062293, 1003743, 'JM', 'Accompong', 1, 'accompong', 18.22985000, -77.74816000),
(1062303, 1003743, 'JM', 'Alligator Pond', 1, 'alligator-pond', 17.86932000, -77.56769000),
(1062326, 1003743, 'JM', 'Balaclava', 1, 'balaclava', 18.17228000, -77.64375000),
(1062328, 1003743, 'JM', 'Ballards  Valley', 1, 'ballards-valley', 17.87949000, -77.63086000),
(1062333, 1003743, 'JM', 'Barbary Hall', 1, 'barbary-hall', 17.96800000, -77.77961000),
(1062360, 1003743, 'JM', 'Bigwoods', 1, 'bigwoods', 17.93338000, -77.71897000),
(1062363, 1003743, 'JM', 'Black River', 1, 'black-river', 18.02636000, -77.84873000),
(1062371, 1003743, 'JM', 'Bogue', 1, 'bogue', 18.13619000, -77.66970000),
(1062381, 1003743, 'JM', 'Braes River', 1, 'braes-river', 18.09351000, -77.66487000),
(1062390, 1003743, 'JM', 'Brighton', 1, 'brighton', 18.14836000, -77.85604000),
(1062393, 1003743, 'JM', 'Brompton', 1, 'brompton', 18.06795000, -77.88821000),
(1062401, 1003743, 'JM', 'Bull Savanna', 1, 'bull-savanna', 17.88678000, -77.59022000),
(1062402, 1003743, 'JM', 'Bull Savannah', 1, 'bull-savannah', 17.88056000, -77.59000000),
(1062405, 1003743, 'JM', 'Burnt Savannah', 1, 'burnt-savannah', 18.03177000, -77.74936000),
(1062419, 1003743, 'JM', 'Carisbrook', 1, 'carisbrook', 18.14742000, -77.77367000),
(1062483, 1003743, 'JM', 'Cotterwood', 1, 'cotterwood', 18.09492000, -77.91553000),
(1062487, 1003743, 'JM', 'Crawford', 1, 'crawford', 18.05060000, -77.91596000),
(1062534, 1003743, 'JM', 'Elderslie', 1, 'elderslie', 18.22416000, -77.79381000),
(1062577, 1003743, 'JM', 'Fullerswood', 1, 'fullerswood', 18.01527000, -77.77572000),
(1062584, 1003743, 'JM', 'Giddy Hall', 1, 'giddy-hall', 18.09702000, -77.86764000),
(1062586, 1003743, 'JM', 'Ginger Hill', 1, 'ginger-hill', 18.19180000, -77.84867000),
(1062599, 1003743, 'JM', 'Goshen', 1, 'goshen', 18.04964000, -77.64136000),
(1062651, 1003743, 'JM', 'Holland', 1, 'holland', 18.10358000, -77.80164000),
(1062655, 1003743, 'JM', 'Hopeton', 1, 'hopeton', 17.95626000, -77.66239000),
(1062682, 1003743, 'JM', 'Junction', 1, 'junction', 17.91467000, -77.59894000),
(1062699, 1003743, 'JM', 'Lacovia', 1, 'lacovia', 18.08844000, -77.75350000),
(1062705, 1003743, 'JM', 'Leeds', 1, 'leeds', 18.01399000, -77.68374000),
(1062717, 1003743, 'JM', 'Lititz', 1, 'lititz', 17.94033000, -77.59511000),
(1062739, 1003743, 'JM', 'Maggotty', 1, 'maggotty', 18.17343000, -77.76681000),
(1062743, 1003743, 'JM', 'Malvern', 1, 'malvern', 17.96667000, -77.70000000),
(1062770, 1003743, 'JM', 'Merrywood', 1, 'merrywood', 18.21793000, -77.83773000),
(1062771, 1003743, 'JM', 'Middle Quarters', 1, 'middle-quarters', 18.11455000, -77.83808000),
(1062805, 1003743, 'JM', 'Mountainside', 1, 'mountainside', 17.98077000, -77.74786000),
(1062806, 1003743, 'JM', 'Mulgrave', 1, 'mulgrave', 18.21164000, -77.82018000),
(1062807, 1003743, 'JM', 'Myersville', 1, 'myersville', 17.99699000, -77.62425000),
(1062809, 1003743, 'JM', 'Nain', 1, 'nain', 17.96526000, -77.60528000),
(1062818, 1003743, 'JM', 'New Market', 1, 'new-market', 18.15362000, -77.90962000),
(1062823, 1003743, 'JM', 'Newell', 1, 'newell', 17.92103000, -77.74653000),
(1062826, 1003743, 'JM', 'Newton', 1, 'newton', 18.11095000, -77.72352000),
(1062854, 1003743, 'JM', 'Parottee', 1, 'parottee', 17.96174000, -77.81774000),
(1062872, 1003743, 'JM', 'Pedro Plains', 1, 'pedro-plains', 17.88569000, -77.71337000),
(1062877, 1003743, 'JM', 'Pepper', 1, 'pepper', 18.02105000, -77.61284000),
(1062884, 1003743, 'JM', 'Pisgah', 1, 'pisgah', 18.19605000, -77.88671000),
(1062889, 1003743, 'JM', 'Pondside', 1, 'pondside', 17.98153000, -77.79450000),
(1062902, 1003743, 'JM', 'Potsdam', 1, 'potsdam', 17.91872000, -77.66869000),
(1062909, 1003743, 'JM', 'Quick Step', 1, 'quick-step', 18.23281000, -77.67831000),
(1062915, 1003743, 'JM', 'Red Bank', 1, 'red-bank', 17.93776000, -77.62585000),
(1062923, 1003743, 'JM', 'Retirement', 1, 'retirement', 18.20740000, -77.76698000),
(1062951, 1003743, 'JM', 'Rose Hall', 1, 'rose-hall', 17.92654000, -77.64153000),
(1062960, 1003743, 'JM', 'Russels', 1, 'russels', 17.98638000, -77.65065000),
(1062971, 1003743, 'JM', 'Santa Cruz', 1, 'santa-cruz', 18.05336000, -77.69836000),
(1062976, 1003743, 'JM', 'Scholefield', 1, 'scholefield', 18.02375000, -77.71884000),
(1062993, 1003743, 'JM', 'Siloah', 1, 'siloah', 18.16334000, -77.71061000),
(1062996, 1003743, 'JM', 'Slipe', 1, 'slipe', 18.05740000, -77.79687000),
(1063004, 1003743, 'JM', 'Southfield', 1, 'southfield', 17.88212000, -77.66988000),
(1063017, 1003743, 'JM', 'Springfield', 1, 'springfield', 18.17662000, -77.87392000),
(1063049, 1003743, 'JM', 'Thornton', 1, 'thornton', 18.19564000, -77.72246000),
(1063054, 1003743, 'JM', 'Top Hill', 1, 'top-hill', 17.89317000, -77.63793000),
(1063062, 1003743, 'JM', 'Treasure Beach', 1, 'treasure-beach', 17.89550000, -77.76051000),
(1063083, 1003743, 'JM', 'Warminister', 1, 'warminister', 17.96238000, -77.63956000),
(1063086, 1003743, 'JM', 'Watchwell', 1, 'watchwell', 17.93876000, -77.77250000),
(1063100, 1003743, 'JM', 'White Hill', 1, 'white-hill', 18.15646000, -77.81067000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003745, 'JM', 'Saint James Parish', 1, 'saint-james-parish');

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 
(1062294, 1003745, 'JM', 'Adelphi', 1, 'adelphi', 18.45060000, -77.78590000),
(1062298, 1003745, 'JM', 'Albion', 1, 'albion', 18.48471000, -77.91408000),
(1062312, 1003745, 'JM', 'Anchovy', 1, 'anchovy', 18.41030000, -77.93166000),
(1062315, 1003745, 'JM', 'Arcadia', 1, 'arcadia', 18.24993000, -77.79228000),
(1062337, 1003745, 'JM', 'Barrett Town', 1, 'barrett-town', 18.50871000, -77.79625000),
(1062358, 1003745, 'JM', 'Bickersteth', 1, 'bickersteth', 18.36335000, -77.93651000),
(1062370, 1003745, 'JM', 'Bogue', 1, 'bogue', 18.43722000, -77.92022000),
(1062386, 1003745, 'JM', 'Brandon Hill', 1, 'brandon-hill', 18.47767000, -77.91117000),
(1062415, 1003745, 'JM', 'Cambridge', 1, 'cambridge', 18.31308000, -77.89546000),
(1062418, 1003745, 'JM', 'Canterbury', 1, 'canterbury', 18.47919000, -77.91655000),
(1062429, 1003745, 'JM', 'Catadupa', 1, 'catadupa', 18.28052000, -77.86579000),
(1062430, 1003745, 'JM', 'Catherine Hall', 1, 'catherine-hall', 18.46258000, -77.92286000),
(1062431, 1003745, 'JM', 'Catherine Mount', 1, 'catherine-mount', 18.45672000, -77.89691000),
(1062469, 1003745, 'JM', 'Comfort Hall', 1, 'comfort-hall', 18.41270000, -77.91814000),
(1062480, 1003745, 'JM', 'Coral Gardens', 1, 'coral-gardens', 18.50791000, -77.88034000),
(1062481, 1003745, 'JM', 'Cornwall', 1, 'cornwall', 18.48930000, -77.81016000),
(1062516, 1003745, 'JM', 'Down Town Montego Bay', 1, 'down-town-montego-bay', 18.47726000, -77.92031000),
(1062525, 1003745, 'JM', 'Dumfries', 1, 'dumfries', 18.42973000, -77.75593000),
(1062546, 1003745, 'JM', 'Fairfield', 1, 'fairfield', 18.45079000, -77.91235000),
(1062551, 1003745, 'JM', 'Farm Heights', 1, 'farm-heights', 18.46869000, -77.87760000),
(1062555, 1003745, 'JM', 'Flagstaff', 1, 'flagstaff', 18.35412000, -77.77132000),
(1062556, 1003745, 'JM', 'Flamstead', 1, 'flamstead', 18.31409000, -77.81316000),
(1062557, 1003745, 'JM', 'Flankers', 1, 'flankers', 18.50265000, -77.90831000),
(1062560, 1003745, 'JM', 'Flower Hill', 1, 'flower-hill', 18.48426000, -77.83913000),
(1062572, 1003745, 'JM', 'Friendship', 1, 'friendship', 18.44590000, -77.86242000),
(1062579, 1003745, 'JM', 'Garlands', 1, 'garlands', 18.27811000, -77.78908000),
(1062588, 1003745, 'JM', 'Glendevon', 1, 'glendevon', 18.48488000, -77.89710000),
(1062597, 1003745, 'JM', 'Goodwill', 1, 'goodwill', 18.46950000, -77.75646000),
(1062604, 1003745, 'JM', 'Granville', 1, 'granville', 18.44191000, -77.89402000),
(1062611, 1003745, 'JM', 'Green Pond', 1, 'green-pond', 18.47361000, -77.87779000),
(1062615, 1003745, 'JM', 'Greenwood', 1, 'greenwood', 18.49768000, -77.75243000),
(1062656, 1003745, 'JM', 'Hopeton', 1, 'hopeton', 18.39858000, -77.86826000),
(1062664, 1003745, 'JM', 'Ironshore', 1, 'ironshore', 18.51323000, -77.85108000),
(1062665, 1003745, 'JM', 'Irwin', 1, 'irwin', 18.44949000, -77.87722000),
(1062675, 1003745, 'JM', 'John\'s Hall', 1, 'john-s-hall', 18.42849000, -77.85010000),
(1062709, 1003745, 'JM', 'Lilliput', 1, 'lilliput', 18.50591000, -77.77686000),
(1062730, 1003745, 'JM', 'Lottery', 1, 'lottery', 18.41499000, -77.80696000),
(1062742, 1003745, 'JM', 'Maldon', 1, 'maldon', 18.33831000, -77.80998000),
(1062754, 1003745, 'JM', 'Maroon Town', 1, 'maroon-town', 18.34464000, -77.79544000),
(1062779, 1003745, 'JM', 'Mocho', 1, 'mocho', 18.29135000, -77.82580000),
(1062784, 1003745, 'JM', 'Montego Bay', 1, 'montego-bay', 18.47116000, -77.91883000),
(1062785, 1003745, 'JM', 'Montego Hill', 1, 'montego-hill', 18.48038000, -77.88150000),
(1062786, 1003745, 'JM', 'Montpelier', 1, 'montpelier', 18.37612000, -77.91357000),
(1062794, 1003745, 'JM', 'Mount Carey', 1, 'mount-carey', 18.38888000, -77.94374000),
(1062795, 1003745, 'JM', 'Mount Horeb', 1, 'mount-horeb', 18.33322000, -77.86675000),
(1062801, 1003745, 'JM', 'Mount Salem', 1, 'mount-salem', 18.46601000, -77.90793000),
(1062828, 1003745, 'JM', 'Niagara', 1, 'niagara', 18.26534000, -77.81879000),
(1062833, 1003745, 'JM', 'Norwood', 1, 'norwood', 18.49217000, -77.88634000),
(1062842, 1003745, 'JM', 'Orange', 1, 'orange', 18.45395000, -77.82779000),
(1062852, 1003745, 'JM', 'Paradise', 1, 'paradise', 18.49401000, -77.90982000),
(1062885, 1003745, 'JM', 'Pitfour', 1, 'pitfour', 18.43206000, -77.89007000),
(1062899, 1003745, 'JM', 'Porto Bello', 1, 'porto-bello', 18.46607000, -77.86989000),
(1062914, 1003745, 'JM', 'Reading', 1, 'reading', 18.43723000, -77.94730000),
(1062922, 1003745, 'JM', 'Retirement', 1, 'retirement', 18.43742000, -77.88004000),
(1062926, 1003745, 'JM', 'Retrieve', 1, 'retrieve', 18.28901000, -77.90081000),
(1062948, 1003745, 'JM', 'Roehampton', 1, 'roehampton', 18.39897000, -77.89926000),
(1062950, 1003745, 'JM', 'Rose Hall', 1, 'rose-hall', 18.51228000, -77.81833000),
(1062952, 1003745, 'JM', 'Rose Heights', 1, 'rose-heights', 18.46945000, -77.89533000),
(1062954, 1003745, 'JM', 'Rose Mount Garden', 1, 'rose-mount-garden', 18.46394000, -77.89397000),
(1062956, 1003745, 'JM', 'Rosemount', 1, 'rosemount', 18.47484000, -77.89216000),
(1062965, 1003745, 'JM', 'Salt Spring', 1, 'salt-spring', 18.48687000, -77.86554000),
(1062985, 1003745, 'JM', 'Seven Rivers', 1, 'seven-rivers', 18.34702000, -77.91378000),
(1063003, 1003745, 'JM', 'Somerton', 1, 'somerton', 18.40496000, -77.77071000),
(1063010, 1003745, 'JM', 'Spot Valley', 1, 'spot-valley', 18.47869000, -77.79106000),
(1063032, 1003745, 'JM', 'Stonehenge', 1, 'stonehenge', 18.24231000, -77.85042000),
(1063039, 1003745, 'JM', 'Summer Hill', 1, 'summer-hill', 18.37360000, -77.79350000),
(1063041, 1003745, 'JM', 'Sunderland', 1, 'sunderland', 18.39794000, -77.82734000),
(1063046, 1003745, 'JM', 'Tangle River', 1, 'tangle-river', 18.34337000, -77.83621000),
(1063057, 1003745, 'JM', 'Tower Hill/Moy Hall', 1, 'tower-hill-moy-hall', 18.44044000, -77.96022000),
(1063070, 1003745, 'JM', 'Tucker', 1, 'tucker', 18.44900000, -77.89438000),
(1063073, 1003745, 'JM', 'Unity Hall', 1, 'unity-hall', 18.43304000, -77.97684000),
(1063075, 1003745, 'JM', 'Vaughnsfield', 1, 'vaughnsfield', 18.32135000, -77.78051000),
(1063094, 1003745, 'JM', 'Welcome Hall', 1, 'welcome-hall', 18.36898000, -77.83673000),
(1063097, 1003745, 'JM', 'West Green', 1, 'west-green', 18.46244000, -77.91757000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003747, 'JM', 'Saint Mary Parish', 1, 'saint-mary-parish');

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 
(1062309, 1003747, 'JM', 'Amiel Town', 1, 'amiel-town', 18.34027000, -76.97612000),
(1062313, 1003747, 'JM', 'Annotto Bay', 1, 'annotto-bay', 18.27170000, -76.76523000),
(1062325, 1003747, 'JM', 'Baileys Vale', 1, 'baileys-vale', 18.34527000, -76.92593000),
(1062342, 1003747, 'JM', 'Baxter Mountain', 1, 'baxter-mountain', 18.20405000, -76.77198000),
(1062347, 1003747, 'JM', 'Belfield', 1, 'belfield', 18.27347000, -76.83574000),
(1062375, 1003747, 'JM', 'Bonnygate', 1, 'bonnygate', 18.32869000, -76.94606000),
(1062383, 1003747, 'JM', 'Brainerd', 1, 'brainerd', 18.16988000, -76.86890000),
(1062392, 1003747, 'JM', 'Broadgate', 1, 'broadgate', 18.22847000, -76.80788000),
(1062414, 1003747, 'JM', 'Camberwell', 1, 'camberwell', 18.23930000, -76.78088000),
(1062421, 1003747, 'JM', 'Carron Hall', 1, 'carron-hall', 18.27797000, -76.95246000),
(1062428, 1003747, 'JM', 'Castleton', 1, 'castleton', 18.17618000, -76.78340000),
(1062448, 1003747, 'JM', 'Charles Town', 1, 'charles-town', 18.38918000, -77.03978000),
(1062459, 1003747, 'JM', 'Clonmel', 1, 'clonmel', 18.24281000, -76.83137000),
(1062511, 1003747, 'JM', 'Devon Pen', 1, 'devon-pen', 18.21561000, -76.82440000),
(1062515, 1003747, 'JM', 'Dover', 1, 'dover', 18.25534000, -76.70811000),
(1062539, 1003747, 'JM', 'Enfield', 1, 'enfield', 18.22036000, -76.73745000),
(1062541, 1003747, 'JM', 'Epson', 1, 'epson', 18.25220000, -76.72641000),
(1062559, 1003747, 'JM', 'Flint River', 1, 'flint-river', 18.23790000, -76.92173000),
(1062568, 1003747, 'JM', 'Free Hill', 1, 'free-hill', 18.35439000, -76.94317000),
(1062573, 1003747, 'JM', 'Friendship Gap', 1, 'friendship-gap', 18.19719000, -76.81960000),
(1062578, 1003747, 'JM', 'Galina', 1, 'galina', 18.40265000, -76.90041000),
(1062580, 1003747, 'JM', 'Gayle', 1, 'gayle', 18.34278000, -77.00211000),
(1062619, 1003747, 'JM', 'Guys Hill', 1, 'guys-hill', 18.26243000, -76.99561000),
(1062626, 1003747, 'JM', 'Hampstead', 1, 'hampstead', 18.32051000, -76.90477000),
(1062648, 1003747, 'JM', 'Highgate', 1, 'highgate', 18.27739000, -76.89554000),
(1062666, 1003747, 'JM', 'Islington', 1, 'islington', 18.32160000, -76.84102000),
(1062668, 1003747, 'JM', 'Jacks River', 1, 'jacks-river', 18.37220000, -76.94101000),
(1062671, 1003747, 'JM', 'Jeffery Town', 1, 'jeffery-town', 18.28956000, -77.00343000),
(1062698, 1003747, 'JM', 'Labyrinth', 1, 'labyrinth', 18.34419000, -77.03227000),
(1062725, 1003747, 'JM', 'Long Road', 1, 'long-road', 18.21337000, -76.75009000),
(1062734, 1003747, 'JM', 'Lucky Hill', 1, 'lucky-hill', 18.30252000, -77.01678000),
(1062747, 1003747, 'JM', 'Mango Valley', 1, 'mango-valley', 18.37481000, -76.97694000),
(1062756, 1003747, 'JM', 'Martin', 1, 'martin', 18.30118000, -76.87257000),
(1062760, 1003747, 'JM', 'Mason Hall', 1, 'mason-hall', 18.39662000, -76.92063000),
(1062774, 1003747, 'JM', 'Mile Gully', 1, 'mile-gully', 18.31801000, -76.96051000),
(1062841, 1003747, 'JM', 'Oracabessa', 1, 'oracabessa', 18.40319000, -76.94641000),
(1062893, 1003747, 'JM', 'Port Maria', 1, 'port-maria', 18.36849000, -76.88946000),
(1062906, 1003747, 'JM', 'Prospect', 1, 'prospect', 18.41273000, -77.04119000),
(1062924, 1003747, 'JM', 'Retreat', 1, 'retreat', 18.37865000, -77.01590000),
(1062928, 1003747, 'JM', 'Richmond', 1, 'richmond', 18.21113000, -76.88301000),
(1062940, 1003747, 'JM', 'Robins Bay', 1, 'robins-bay', 18.31236000, -76.81783000),
(1062967, 1003747, 'JM', 'Sandside', 1, 'sandside', 18.33888000, -76.89551000),
(1062977, 1003747, 'JM', 'Scotts Hall', 1, 'scotts-hall', 18.19083000, -76.83942000),
(1063121, 1003747, 'JM', 'Woodpark', 1, 'woodpark', 18.29734000, -76.98114000),
(1063122, 1003747, 'JM', 'Woodside', 1, 'woodside', 18.25258000, -76.92679000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003750, 'JM', 'Saint Thomas Parish', 1, 'saint-thomas-parish');

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 
(1062296, 1003750, 'JM', 'Airy Castle', 1, 'airy-castle', 17.92506000, -76.34216000),
(1062299, 1003750, 'JM', 'Albion', 1, 'albion', 17.90119000, -76.60761000),
(1062311, 1003750, 'JM', 'Amity Hall', 1, 'amity-hall', 17.96759000, -76.25698000),
(1062314, 1003750, 'JM', 'Arcadia', 1, 'arcadia', 17.92230000, -76.30030000),
(1062332, 1003750, 'JM', 'Baptist', 1, 'baptist', 17.87666000, -76.57837000),
(1062335, 1003750, 'JM', 'Barking Lodge', 1, 'barking-lodge', 17.89279000, -76.28922000),
(1062339, 1003750, 'JM', 'Bath', 1, 'bath', 17.94820000, -76.34916000),
(1062355, 1003750, 'JM', 'Bethel', 1, 'bethel', 17.98527000, -76.58050000),
(1062438, 1003750, 'JM', 'Cedar Valley', 1, 'cedar-valley', 18.02815000, -76.59556000),
(1062455, 1003750, 'JM', 'Church Corner', 1, 'church-corner', 17.88718000, -76.41898000),
(1062500, 1003750, 'JM', 'Dalvey', 1, 'dalvey', 17.90241000, -76.25001000),
(1062502, 1003750, 'JM', 'Danvers Pen', 1, 'danvers-pen', 17.92880000, -76.47586000),
(1062522, 1003750, 'JM', 'Duckenfield', 1, 'duckenfield', 17.92205000, -76.22657000),
(1062524, 1003750, 'JM', 'Duhaney Pen', 1, 'duhaney-pen', 17.89402000, -76.43193000),
(1062529, 1003750, 'JM', 'Easington', 1, 'easington', 17.92397000, -76.58824000),
(1062535, 1003750, 'JM', 'Eleven Miles', 1, 'eleven-miles', 17.93745000, -76.64337000),
(1062561, 1003750, 'JM', 'Font Hill', 1, 'font-hill', 17.94055000, -76.51169000),
(1062592, 1003750, 'JM', 'Golden Grove', 1, 'golden-grove', 17.93361000, -76.27254000),
(1062622, 1003750, 'JM', 'Hagley Gap', 1, 'hagley-gap', 18.04845000, -76.62777000),
(1062627, 1003750, 'JM', 'Hampton Court', 1, 'hampton-court', 17.91782000, -76.26131000),
(1062639, 1003750, 'JM', 'Hayfield', 1, 'hayfield', 17.98199000, -76.36841000),
(1062649, 1003750, 'JM', 'Hillside', 1, 'hillside', 17.99619000, -76.49082000),
(1062677, 1003750, 'JM', 'Johns Town', 1, 'johns-town', 17.89659000, -76.36136000),
(1062678, 1003750, 'JM', 'Johnson Mountain', 1, 'johnson-mountain', 17.98091000, -76.31986000),
(1062680, 1003750, 'JM', 'Jones Pen', 1, 'jones-pen', 17.95068000, -76.54775000),
(1062706, 1003750, 'JM', 'Leith Hall', 1, 'leith-hall', 17.87973000, -76.34331000),
(1062719, 1003750, 'JM', 'Llandewey', 1, 'llandewey', 17.94477000, -76.62245000),
(1062721, 1003750, 'JM', 'Lloyds', 1, 'lloyds', 17.91504000, -76.54085000),
(1062735, 1003750, 'JM', 'Lyssons', 1, 'lyssons', 17.88708000, -76.37961000),
(1062772, 1003750, 'JM', 'Middleton', 1, 'middleton', 17.93971000, -76.43558000),
(1062789, 1003750, 'JM', 'Morant Bay', 1, 'morant-bay', 17.88145000, -76.40927000),
(1062797, 1003750, 'JM', 'Mount Lebanus', 1, 'mount-lebanus', 17.97544000, -76.53891000),
(1062820, 1003750, 'JM', 'New Monkland', 1, 'new-monkland', 17.99158000, -76.57333000),
(1062850, 1003750, 'JM', 'Pamphret', 1, 'pamphret', 17.87570000, -76.51736000),
(1062869, 1003750, 'JM', 'Pear Tree', 1, 'pear-tree', 17.91162000, -76.31676000),
(1062891, 1003750, 'JM', 'Poormans Corner', 1, 'poormans-corner', 17.89152000, -76.58351000),
(1062894, 1003750, 'JM', 'Port Morant', 1, 'port-morant', 17.89947000, -76.34286000),
(1062907, 1003750, 'JM', 'Prospect', 1, 'prospect', 17.87404000, -76.34956000),
(1062912, 1003750, 'JM', 'Ramble', 1, 'ramble', 17.96791000, -76.62630000),
(1062925, 1003750, 'JM', 'Retreat', 1, 'retreat', 17.87760000, -76.36795000),
(1062932, 1003750, 'JM', 'Richmond Vale', 1, 'richmond-vale', 17.97435000, -76.59044000),
(1062936, 1003750, 'JM', 'River Head', 1, 'river-head', 17.99237000, -76.61082000),
(1062957, 1003750, 'JM', 'Rowlandsfield', 1, 'rowlandsfield', 17.97355000, -76.28781000),
(1062980, 1003750, 'JM', 'Seaforth', 1, 'seaforth', 17.94421000, -76.45661000),
(1063001, 1003750, 'JM', 'Somerset', 1, 'somerset', 18.00976000, -76.54595000),
(1063011, 1003750, 'JM', 'Spring Bank', 1, 'spring-bank', 17.95995000, -76.32596000),
(1063012, 1003750, 'JM', 'Spring Garden', 1, 'spring-garden', 17.91749000, -76.42978000),
(1063042, 1003750, 'JM', 'Sunning Hill', 1, 'sunning-hill', 17.95612000, -76.40931000),
(1063064, 1003750, 'JM', 'Trinity Ville', 1, 'trinity-ville', 17.96076000, -76.51427000),
(1063065, 1003750, 'JM', 'Trinityville', 1, 'trinityville', 17.95720000, -76.49420000),
(1063098, 1003750, 'JM', 'Wheelerfield', 1, 'wheelerfield', 17.95874000, -76.29623000),
(1063099, 1003750, 'JM', 'White Hall', 1, 'white-hall', 17.99805000, -76.43105000),
(1063101, 1003750, 'JM', 'White Horses', 1, 'white-horses', 17.89620000, -76.47076000),
(1063109, 1003750, 'JM', 'Wilmington', 1, 'wilmington', 17.92856000, -76.38962000),
(1063112, 1003750, 'JM', 'Winchester', 1, 'winchester', 17.94177000, -76.29823000),
(1063124, 1003750, 'JM', 'Yallahs', 1, 'yallahs', 17.87480000, -76.56245000),
(1063125, 1003750, 'JM', 'York', 1, 'york', 17.92849000, -76.43983000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003755, 'JM', 'Trelawny Parish', 1, 'trelawny-parish');

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 
(1062297, 1003755, 'JM', 'Albert Town', 1, 'albert-town', 18.29434000, -77.54239000),
(1062306, 1003755, 'JM', 'Alps', 1, 'alps', 18.35498000, -77.50897000),
(1062379, 1003755, 'JM', 'Bounty Hall', 1, 'bounty-hall', 18.45801000, -77.71663000),
(1062384, 1003755, 'JM', 'Brampton', 1, 'brampton', 18.44262000, -77.46424000),
(1062403, 1003755, 'JM', 'Bunkers Hill', 1, 'bunkers-hill', 18.36198000, -77.68612000),
(1062457, 1003755, 'JM', 'Clarks Town', 1, 'clarks-town', 18.42244000, -77.53328000),
(1062501, 1003755, 'JM', 'Daniel Town', 1, 'daniel-town', 18.46395000, -77.61592000),
(1062505, 1003755, 'JM', 'Deeside', 1, 'deeside', 18.35976000, -77.73721000),
(1062521, 1003755, 'JM', 'Duanvale', 1, 'duanvale', 18.40267000, -77.59615000),
(1062526, 1003755, 'JM', 'Duncans', 1, 'duncans', 18.46800000, -77.53633000),
(1062550, 1003755, 'JM', 'Falmouth', 1, 'falmouth', 18.49358000, -77.65587000),
(1062569, 1003755, 'JM', 'Freemans Hall', 1, 'freemans-hall', 18.28384000, -77.50180000),
(1062605, 1003755, 'JM', 'Granville', 1, 'granville', 18.45053000, -77.68847000),
(1062625, 1003755, 'JM', 'Hampden', 1, 'hampden', 18.44217000, -77.73203000),
(1062669, 1003755, 'JM', 'Jackson Town', 1, 'jackson-town', 18.41781000, -77.48458000),
(1062674, 1003755, 'JM', 'Joe Hut', 1, 'joe-hut', 18.26742000, -77.49616000),
(1062694, 1003755, 'JM', 'Kinloss', 1, 'kinloss', 18.39641000, -77.56968000),
(1062729, 1003755, 'JM', 'Lorrimers', 1, 'lorrimers', 18.23026000, -77.49207000),
(1062755, 1003755, 'JM', 'Martha Brae', 1, 'martha-brae', 18.46960000, -77.65909000),
(1062878, 1003755, 'JM', 'Perth Town', 1, 'perth-town', 18.43106000, -77.62583000),
(1062921, 1003755, 'JM', 'Refuge', 1, 'refuge', 18.45101000, -77.57751000),
(1062933, 1003755, 'JM', 'Rio Bueno', 1, 'rio-bueno', 18.46406000, -77.48042000),
(1062963, 1003755, 'JM', 'Salt Marsh', 1, 'salt-marsh', 18.48423000, -77.71184000),
(1062966, 1003755, 'JM', 'Samuels Prospect', 1, 'samuels-prospect', 18.45103000, -77.51440000),
(1062975, 1003755, 'JM', 'Sawyers', 1, 'sawyers', 18.37880000, -77.49689000),
(1062988, 1003755, 'JM', 'Sherwood Content', 1, 'sherwood-content', 18.38227000, -77.63643000),
(1063009, 1003755, 'JM', 'Spicy Hill', 1, 'spicy-hill', 18.45763000, -77.54751000),
(1063013, 1003755, 'JM', 'Spring Garden', 1, 'spring-garden', 18.29368000, -77.56698000),
(1063027, 1003755, 'JM', 'St. Vincent', 1, 'st-vincent', 18.33424000, -77.54790000),
(1063030, 1003755, 'JM', 'Stettin', 1, 'stettin', 18.28224000, -77.54095000),
(1063031, 1003755, 'JM', 'Stewart Town', 1, 'stewart-town', 18.39887000, -77.45187000),
(1063068, 1003755, 'JM', 'Troy', 1, 'troy', 18.24924000, -77.60978000),
(1063072, 1003755, 'JM', 'Ulster Spring', 1, 'ulster-spring', 18.32113000, -77.49681000),
(1063078, 1003755, 'JM', 'Wait-A-Bit', 1, 'wait-a-bit', 18.25332000, -77.50837000),
(1063079, 1003755, 'JM', 'Wakefield', 1, 'wakefield', 18.41460000, -77.70908000),
(1063084, 1003755, 'JM', 'Warsop', 1, 'warsop', 18.26178000, -77.56774000),
(1063110, 1003755, 'JM', 'Wilson\'s Run', 1, 'wilson-s-run', 18.28468000, -77.69323000),
(1063116, 1003755, 'JM', 'Wirefence', 1, 'wirefence', 18.25310000, -77.53276000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003742, 'JM', 'Westmoreland Parish', 1, 'westmoreland-parish');

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 
(1062289, 1003742, 'JM', '12th Street', 1, '12th-street', 18.21097000, -78.13603000),
(1062310, 1003742, 'JM', 'Amity', 1, 'amity', 18.27361000, -77.89805000),
(1062320, 1003742, 'JM', 'Ashton', 1, 'ashton', 18.23139000, -77.92074000),
(1062336, 1003742, 'JM', 'Barneyside', 1, 'barneyside', 18.27670000, -77.96964000),
(1062340, 1003742, 'JM', 'Bath', 1, 'bath', 18.25734000, -78.11751000),
(1062341, 1003742, 'JM', 'Bath Mountain', 1, 'bath-mountain', 18.34428000, -78.09928000),
(1062343, 1003742, 'JM', 'Beaufort', 1, 'beaufort', 18.23417000, -77.95007000),
(1062346, 1003742, 'JM', 'Beeston Spring', 1, 'beeston-spring', 18.16012000, -77.97545000),
(1062350, 1003742, 'JM', 'Belvedere', 1, 'belvedere', 18.25219000, -77.93208000),
(1062353, 1003742, 'JM', 'Berkshire', 1, 'berkshire', 18.21293000, -77.90373000),
(1062356, 1003742, 'JM', 'Bethel Town', 1, 'bethel-town', 18.29503000, -77.95112000),
(1062359, 1003742, 'JM', 'Big Bridge', 1, 'big-bridge', 18.23318000, -78.16717000),
(1062367, 1003742, 'JM', 'Bluefields', 1, 'bluefields', 18.16602000, -78.02702000),
(1062368, 1003742, 'JM', 'Bog', 1, 'bog', 18.15631000, -77.94364000),
(1062394, 1003742, 'JM', 'Broughton', 1, 'broughton', 18.21747000, -78.22894000),
(1062404, 1003742, 'JM', 'Burnt Savannah', 1, 'burnt-savannah', 18.31676000, -78.12628000),
(1062411, 1003742, 'JM', 'Cairn Curran', 1, 'cairn-curran', 18.22840000, -78.01130000),
(1062413, 1003742, 'JM', 'Caledonia', 1, 'caledonia', 18.25866000, -78.01173000),
(1062420, 1003742, 'JM', 'Carmel', 1, 'carmel', 18.17326000, -77.93929000),
(1062434, 1003742, 'JM', 'Cave', 1, 'cave', 18.21019000, -78.04070000),
(1062445, 1003742, 'JM', 'Chantilly', 1, 'chantilly', 18.23059000, -78.12462000),
(1062475, 1003742, 'JM', 'Content', 1, 'content', 18.18288000, -77.99915000),
(1062482, 1003742, 'JM', 'Cornwall Mountian', 1, 'cornwall-mountian', 18.28722000, -77.98674000),
(1062503, 1003742, 'JM', 'Darliston', 1, 'darliston', 18.23731000, -77.97626000),
(1062508, 1003742, 'JM', 'Delveland', 1, 'delveland', 18.29709000, -78.23962000),
(1062513, 1003742, 'JM', 'Dillion Bigwoods', 1, 'dillion-bigwoods', 18.20944000, -77.99078000),
(1062527, 1003742, 'JM', 'Dundee', 1, 'dundee', 18.23679000, -77.88698000),
(1062538, 1003742, 'JM', 'Enfield', 1, 'enfield', 18.21404000, -77.95270000),
(1062553, 1003742, 'JM', 'Ferris', 1, 'ferris', 18.22265000, -78.05588000),
(1062564, 1003742, 'JM', 'Fort Williams', 1, 'fort-williams', 18.29834000, -78.06331000),
(1062574, 1003742, 'JM', 'Frome', 1, 'frome', 18.27974000, -78.14903000),
(1062576, 1003742, 'JM', 'Fullersfield', 1, 'fullersfield', 18.29890000, -78.19976000),
(1062582, 1003742, 'JM', 'Georges Plain', 1, 'georges-plain', 18.27650000, -78.13118000),
(1062596, 1003742, 'JM', 'Gooden\'s River', 1, 'gooden-s-river', 18.24223000, -78.12840000),
(1062600, 1003742, 'JM', 'Grange', 1, 'grange', 18.33161000, -78.08036000),
(1062601, 1003742, 'JM', 'Grange Hill', 1, 'grange-hill', 18.33083000, -78.18398000),
(1062621, 1003742, 'JM', 'Haddo', 1, 'haddo', 18.28606000, -78.01893000),
(1062634, 1003742, 'JM', 'Harmony Town', 1, 'harmony-town', 18.21987000, -78.13687000),
(1062645, 1003742, 'JM', 'Hertford', 1, 'hertford', 18.27181000, -78.09078000),
(1062673, 1003742, 'JM', 'Jerusalem', 1, 'jerusalem', 18.32458000, -78.21563000),
(1062688, 1003742, 'JM', 'Kentucky', 1, 'kentucky', 18.19931000, -78.01767000),
(1062690, 1003742, 'JM', 'Kilmarnoch', 1, 'kilmarnoch', 18.12407000, -77.92774000),
(1062700, 1003742, 'JM', 'Lambs River', 1, 'lambs-river', 18.26823000, -77.91414000),
(1062704, 1003742, 'JM', 'Leamington', 1, 'leamington', 18.21352000, -77.92743000),
(1062707, 1003742, 'JM', 'Lenox Bigwoods', 1, 'lenox-bigwoods', 18.21392000, -77.97214000),
(1062718, 1003742, 'JM', 'Little London', 1, 'little-london', 18.24523000, -78.22653000),
(1062720, 1003742, 'JM', 'Llandilo', 1, 'llandilo', 18.23439000, -78.13895000),
(1062736, 1003742, 'JM', 'Mackfield', 1, 'mackfield', 18.31163000, -78.02471000),
(1062768, 1003742, 'JM', 'Mearnsville', 1, 'mearnsville', 18.18856000, -78.02870000),
(1062792, 1003742, 'JM', 'Mount Airy', 1, 'mount-airy', 18.24738000, -78.32279000),
(1062802, 1003742, 'JM', 'Mount Stewart', 1, 'mount-stewart', 18.30411000, -77.99274000),
(1062811, 1003742, 'JM', 'Negril', 1, 'negril', 18.26844000, -78.34810000),
(1062819, 1003742, 'JM', 'New Market Oval', 1, 'new-market-oval', 18.21370000, -78.13813000),
(1062821, 1003742, 'JM', 'New Roads', 1, 'new-roads', 18.19124000, -77.93608000),
(1062822, 1003742, 'JM', 'New Works', 1, 'new-works', 18.17248000, -77.96645000),
(1062845, 1003742, 'JM', 'Orange Hill', 1, 'orange-hill', 18.23418000, -78.30277000),
(1062868, 1003742, 'JM', 'Paul Island', 1, 'paul-island', 18.27200000, -78.18614000),
(1062879, 1003742, 'JM', 'Petersfield', 1, 'petersfield', 18.26588000, -78.05755000),
(1062880, 1003742, 'JM', 'Petersville', 1, 'petersville', 18.13700000, -77.95046000),
(1062896, 1003742, 'JM', 'Porters Mountain', 1, 'porters-mountain', 18.32909000, -78.04910000),
(1062916, 1003742, 'JM', 'Red Hills', 1, 'red-hills', 18.30550000, -78.11280000),
(1062927, 1003742, 'JM', 'Revival', 1, 'revival', 18.24255000, -78.28437000),
(1062939, 1003742, 'JM', 'Roaring River', 1, 'roaring-river', 18.30118000, -78.04324000),
(1062961, 1003742, 'JM', 'Russia', 1, 'russia', 18.21649000, -78.12361000),
(1062973, 1003742, 'JM', 'Savanna-la-Mar', 1, 'savanna-la-mar', 18.21895000, -78.13320000),
(1062974, 1003742, 'JM', 'Savannah-la-mar Business Dist.', 1, 'savannah-la-mar-business-dist', 18.21962000, -78.13034000),
(1062979, 1003742, 'JM', 'Seaford Town', 1, 'seaford-town', 18.24339000, -77.90504000),
(1062981, 1003742, 'JM', 'Seaton Crescent', 1, 'seaton-crescent', 18.21675000, -78.13603000),
(1062987, 1003742, 'JM', 'Shefield', 1, 'shefield', 18.28412000, -78.29169000),
(1062991, 1003742, 'JM', 'Shoalin Grotto', 1, 'shoalin-grotto', 18.22059000, -78.14019000),
(1062997, 1003742, 'JM', 'Smithfield', 1, 'smithfield', 18.22275000, -78.08785000),
(1063023, 1003742, 'JM', 'St. Leonards', 1, 'st-leonards', 18.25533000, -77.88889000),
(1063034, 1003742, 'JM', 'Strathbogie', 1, 'strathbogie', 18.23855000, -78.11714000),
(1063035, 1003742, 'JM', 'Strawberry', 1, 'strawberry', 18.30676000, -78.08945000),
(1063036, 1003742, 'JM', 'Struie', 1, 'struie', 18.25317000, -77.95656000),
(1063050, 1003742, 'JM', 'Three Mile River', 1, 'three-mile-river', 18.25706000, -78.14275000),
(1063058, 1003742, 'JM', 'Town Head', 1, 'town-head', 18.33898000, -78.13569000),
(1063069, 1003742, 'JM', 'Truro', 1, 'truro', 18.31301000, -78.15489000),
(1063088, 1003742, 'JM', 'Water Works', 1, 'water-works', 18.23319000, -78.04296000),
(1063103, 1003742, 'JM', 'Whitehouse', 1, 'whitehouse', 18.10275000, -77.95697000),
(1063105, 1003742, 'JM', 'Whithorn', 1, 'whithorn', 18.27111000, -78.03811000),
(1063106, 1003742, 'JM', 'Williamsfield', 1, 'williamsfield', 18.33393000, -78.06957000);

