REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('VI', 'U.S. Virgin Islands', 'United States Virgin Islands', 'u-s-virgin-islands', '+1-340', 'USD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(10267902, 'VI', 'Saint Croix Island', 1, 'saint-croix-island'),
(10267903, 'VI', 'Saint John Island', 1, 'saint-john-island'),
(10267904, 'VI', 'Saint Thomas Island', 1, 'saint-thomas-island');

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 
(7046956, 10267902, 'VI', 'Upper Bethlehem', 1, 'upper-bethlehem', 17.71553, -64.79209),
(7795160, 10267904, 'VI', 'Adelphi', 1, 'adelphi', 18.34829, -64.98348),
(7795163, 10267903, 'VI', 'Adrian', 1, 'adrian', 18.34134, -64.76847),
(7795183, 10267902, 'VI', 'Allandale', 1, 'allandale', 17.72803, -64.84015),
(7795185, 10267902, 'VI', 'Altona', 1, 'altona', 17.7447, -64.69403),
(7795186, 10267904, 'VI', 'Altona', 1, 'altona', 18.33885, -64.94876),
(7795201, 10267902, 'VI', 'Anguilla', 1, 'anguilla', 17.70664, -64.77987),
(7795205, 10267902, 'VI', 'Annaberg', 1, 'annaberg', 17.71164, -64.77431),
(7795206, 10267903, 'VI', 'Annaberg', 1, 'annaberg', 18.36301, -64.73014),
(7795216, 10267902, 'VI', 'Annaly', 1, 'annaly', 17.7497, -64.85431),
(7795222, 10267902, 'VI', 'Annas Hope', 1, 'annas-hope', 17.72831, -64.72875),
(7795241, 10267904, 'VI', 'Barrett', 1, 'barrett', 18.36523, -64.94598),
(7795248, 10267902, 'VI', 'Beck Grove', 1, 'beck-grove', 17.72525, -64.85015),
(7795251, 10267902, 'VI', 'Beeston Hill', 1, 'beeston-hill', 17.7381, -64.72462),
(7795254, 10267902, 'VI', 'Bellevue', 1, 'bellevue', 17.74775, -64.73348),
(7795255, 10267904, 'VI', 'Bellevue', 1, 'bellevue', 18.32523, -64.92042),
(7795257, 10267902, 'VI', 'Belvedere', 1, 'belvedere', 17.77636, -64.79876),
(7795261, 10267904, 'VI', 'Benner', 1, 'benner', 18.32218, -64.86181),
(7795267, 10267903, 'VI', 'Bethany', 1, 'bethany', 18.33107, -64.78292),
(7795274, 10267902, 'VI', 'Bethlehem Old Work', 1, 'bethlehem-old-work', 17.73136, -64.79376),
(7795276, 10267902, 'VI', 'Bettys Hope', 1, 'bettys-hope', 17.6922, -64.81653),
(7795278, 10267902, 'VI', 'Betzys Jewell', 1, 'betzys-jewell', 17.75942, -64.7957),
(7795290, 10267902, 'VI', 'Blessing', 1, 'blessing', 17.71386, -64.76459),
(7795301, 10267902, 'VI', 'Bodkin', 1, 'bodkin', 17.75136, -64.84153),
(7795308, 10267904, 'VI', 'Bolongo', 1, 'bolongo', 18.31745, -64.8982),
(7795313, 10267902, 'VI', 'Bonne Esperance', 1, 'bonne-esperance', 17.74331, -64.76931),
(7795314, 10267904, 'VI', 'Bonne Esperance', 1, 'bonne-esperance', 18.3544, -64.98709),
(7795320, 10267903, 'VI', 'Bordeaux', 1, 'bordeaux', 18.33523, -64.72097),
(7795338, 10267904, 'VI', 'Bovoni', 1, 'bovoni', 18.31468, -64.89209),
(7795368, 10267902, 'VI', 'Bugbyhole', 1, 'bugbyhole', 17.72581, -64.70403),
(7795376, 10267902, 'VI', 'Bulows Minde', 1, 'bulows-minde', 17.74025, -64.7282),
(7795380, 10267902, 'VI', 'Butler Bay', 1, 'butler-bay', 17.74858, -64.89154),
(7795383, 10267902, 'VI', 'Butzberg', 1, 'butzberg', 17.74664, -64.67736),
(7795390, 10267903, 'VI', 'Calabash Boom', 1, 'calabash-boom', 18.32773, -64.70319),
(7795398, 10267902, 'VI', 'Camporico', 1, 'camporico', 17.69359, -64.86848),
(7795400, 10267902, 'VI', 'Canaan', 1, 'canaan', 17.76025, -64.79653),
(7795401, 10267904, 'VI', 'Canaan', 1, 'canaan', 18.35718, -64.9207),
(7795403, 10267902, 'VI', 'Cane', 1, 'cane', 17.70498, -64.84542),
(7795410, 10267902, 'VI', 'Cane Valley', 1, 'cane-valley', 17.71942, -64.84653),
(7795411, 10267902, 'VI', 'Canebay', 1, 'canebay', 17.77164, -64.81015),
(7795427, 10267902, 'VI', 'Carden', 1, 'carden', 17.75886, -64.6407),
(7795432, 10267904, 'VI', 'Caret Bay Estate', 1, 'caret-bay-estate', 18.36384, -64.97598),
(7795437, 10267902, 'VI', 'Carlton', 1, 'carlton', 17.70275, -64.84987),
(7795443, 10267903, 'VI', 'Carolina', 1, 'carolina', 18.34718, -64.72153),
(7795454, 10267902, 'VI', 'Castle Coakley', 1, 'castle-coakley', 17.72331, -64.74542),
(7795456, 10267902, 'VI', 'Catharinas Hope', 1, 'catharinas-hope', 17.74803, -64.61625),
(7795459, 10267902, 'VI', 'Cathrines Rest', 1, 'cathrines-rest', 17.72273, -64.71758),
(7795467, 10267904, 'VI', 'Charlotte Amalie', 1, 'charlotte-amalie', 18.3419, -64.9307),
(7795479, 10267902, 'VI', 'Christiansted', 1, 'christiansted', 17.74681, -64.70557),
(7795503, 10267902, 'VI', 'Clairmont', 1, 'clairmont', 17.77525, -64.77959),
(7795505, 10267902, 'VI', 'Clifton Hill', 1, 'clifton-hill', 17.72581, -64.77515),
(7795524, 10267902, 'VI', 'Concordia', 1, 'concordia', 17.68609, -64.87348),
(7795527, 10267903, 'VI', 'Concordia', 1, 'concordia', 18.31051, -64.70652),
(7795539, 10267903, 'VI', 'Contant', 1, 'contant', 18.32551, -64.79236),
(7795540, 10267904, 'VI', 'Contant', 1, 'contant', 18.3419, -64.95598),
(7795544, 10267902, 'VI', 'Contentment', 1, 'contentment', 17.73608, -64.71292),
(7795547, 10267902, 'VI', 'Cooper', 1, 'cooper', 17.6947, -64.80987),
(7795549, 10267903, 'VI', 'Coral Bay', 1, 'coral-bay', 18.34801, -64.71319),
(7795558, 10267902, 'VI', 'Cotton Grove', 1, 'cotton-grove', 17.7322, -64.63653),
(7795560, 10267902, 'VI', 'Cotton Valley', 1, 'cotton-valley', 17.75053, -64.61986),
(7795577, 10267903, 'VI', 'Cruz Bay', 1, 'cruz-bay', 18.33134, -64.79375),
(7795604, 10267902, 'VI', 'Diamond', 1, 'diamond', 17.70331, -64.82542),
(7795608, 10267902, 'VI', 'Diamond Keturah', 1, 'diamond-keturah', 17.7047, -64.71376),
(7795621, 10267904, 'VI', 'Donoe', 1, 'donoe', 18.33662, -64.89764),
(7795623, 10267904, 'VI', 'Dorothea', 1, 'dorothea', 18.35857, -64.96181),
(7795642, 10267903, 'VI', 'East End', 1, 'east-end', 18.33968, -64.67458),
(7795664, 10267903, 'VI', 'Emmaus', 1, 'emmaus', 18.34801, -64.71791),
(7795671, 10267903, 'VI', 'Enighed', 1, 'enighed', 18.32829, -64.79153),
(7795672, 10267904, 'VI', 'Enighed', 1, 'enighed', 18.36329, -64.92264),
(7795676, 10267904, 'VI', 'Ensomned', 1, 'ensomned', 18.36801, -64.95237),
(7795677, 10267902, 'VI', 'Envy', 1, 'envy', 17.69942, -64.80292),
(7795682, 10267904, 'VI', 'Estate Thomas', 1, 'estate-thomas', 18.33968, -64.91098),
(7795696, 10267902, 'VI', 'Fareham', 1, 'fareham', 17.71553, -64.67042),
(7795703, 10267903, 'VI', 'Fish Bay', 1, 'fish-bay', 18.32218, -64.76625),
(7795706, 10267902, 'VI', 'Coble', 1, 'coble', 17.74025, -64.80681),
(7795731, 10267902, 'VI', 'Fort Frederick', 1, 'fort-frederick', 17.71525, -64.88292),
(7795745, 10267902, 'VI', 'Fountain', 1, 'fountain', 17.74997, -64.82765),
(7795751, 10267902, 'VI', 'Fredensborg', 1, 'fredensborg', 17.73497, -64.78153),
(7795754, 10267902, 'VI', 'Fredensdal', 1, 'fredensdal', 17.73997, -64.71209),
(7795758, 10267902, 'VI', 'Frederiks Haab', 1, 'frederiks-haab', 17.71275, -64.86348),
(7795761, 10267902, 'VI', 'Frederiksted', 1, 'frederiksted', 17.71233, -64.88179),
(7795767, 10267903, 'VI', 'Fredriksdal', 1, 'fredriksdal', 18.35968, -64.73625),
(7795773, 10267904, 'VI', 'Frenchtown', 1, 'frenchtown', 18.33829, -64.94209),
(7795774, 10267902, 'VI', 'Friedensfeld', 1, 'friedensfeld', 17.74608, -64.78042),
(7795781, 10267904, 'VI', 'Frydendal', 1, 'frydendal', 18.34579, -64.87236),
(7795795, 10267902, 'VI', 'Glynn', 1, 'glynn', 17.74831, -64.77459),
(7795797, 10267902, 'VI', 'Golden Grove', 1, 'golden-grove', 17.71553, -64.80098),
(7795802, 10267902, 'VI', 'Good Hope', 1, 'good-hope', 17.69359, -64.84848),
(7795812, 10267902, 'VI', 'Granard', 1, 'granard', 17.71303, -64.7157),
(7795815, 10267902, 'VI', 'Grange', 1, 'grange', 17.73123, -64.72243),
(7795831, 10267902, 'VI', 'Great Pond', 1, 'great-pond', 17.72442, -64.64875),
(7795839, 10267902, 'VI', 'Green Kay', 1, 'green-kay', 17.75858, -64.65403),
(7795845, 10267902, 'VI', 'Grove Place', 1, 'grove-place', 17.72553, -64.82265),
(7795857, 10267902, 'VI', 'Hams Bay', 1, 'hams-bay', 17.76553, -64.8807),
(7795868, 10267902, 'VI', 'Hard Labour', 1, 'hard-labour', 17.74108, -64.82653),
(7795897, 10267902, 'VI', 'Hermitage', 1, 'hermitage', 17.74942, -64.80459),
(7795898, 10267903, 'VI', 'Hermitage', 1, 'hermitage', 18.35634, -64.70014),
(7795902, 10267902, 'VI', 'Hesselberg', 1, 'hesselberg', 17.69748, -64.87987),
(7795903, 10267904, 'VI', 'Hoffman', 1, 'hoffman', 18.33357, -64.89486),
(7795905, 10267902, 'VI', 'Hogensborg', 1, 'hogensborg', 17.70942, -64.84681),
(7795914, 10267902, 'VI', 'Hope', 1, 'hope', 17.7147, -64.75792),
(7795928, 10267902, 'VI', 'Humbug', 1, 'humbug', 17.7122, -64.7307),
(7795943, 10267902, 'VI', 'Jealousy', 1, 'jealousy', 17.73553, -64.80376),
(7795946, 10267902, 'VI', 'Jerusalem and Figtree Hill', 1, 'jerusalem-and-figtree-hill', 17.71247, -64.75042),
(7795950, 10267904, 'VI', 'John Oley', 1, 'john-oley', 18.35968, -64.99709),
(7795952, 10267903, 'VI', 'Johns Folly', 1, 'johns-folly', 18.3194, -64.70347),
(7795958, 10267902, 'VI', 'Jolly Hill', 1, 'jolly-hill', 17.7322, -64.86126),
(7795976, 10267902, 'VI', 'Kingshill', 1, 'kingshill', 17.72303, -64.78292),
(7795986, 10267902, 'VI', 'Knight', 1, 'knight', 17.75525, -64.59403),
(7795997, 10267903, 'VI', 'L\'Esperance', 1, 'l-esperance', 18.34023, -64.7593),
(7795999, 10267902, 'VI', 'La Grande Princesse', 1, 'la-grande-princesse', 17.75747, -64.73625),
(7796000, 10267902, 'VI', 'La Grange', 1, 'la-grange', 17.71914, -64.87848),
(7796002, 10267902, 'VI', 'La Reine', 1, 'la-reine', 17.73275, -64.77348),
(7796004, 10267902, 'VI', 'La Vallee', 1, 'la-vallee', 17.77778, -64.80306),
(7796008, 10267903, 'VI', 'Lameshur', 1, 'lameshur', 18.32051, -64.72458),
(7796016, 10267902, 'VI', 'Laprey Valley', 1, 'laprey-valley', 17.72636, -64.68625),
(7796025, 10267903, 'VI', 'Leinster Bay', 1, 'leinster-bay', 18.36329, -64.72041),
(7796031, 10267904, 'VI', 'Lerkenlund', 1, 'lerkenlund', 18.36023, -64.94015),
(7796035, 10267902, 'VI', 'Libanon Hill', 1, 'libanon-hill', 17.75442, -64.78542),
(7796039, 10267904, 'VI', 'Lilliendahl', 1, 'lilliendahl', 18.3544, -64.95209),
(7796042, 10267902, 'VI', 'Limetree', 1, 'limetree', 17.73692, -64.76431),
(7796063, 10267902, 'VI', 'Little Fountain', 1, 'little-fountain', 17.75164, -64.79376),
(7796095, 10267902, 'VI', 'Longford', 1, 'longford', 17.71609, -64.69487),
(7796102, 10267904, 'VI', 'Louisenhoj', 1, 'louisenhoj', 18.35107, -64.92487),
(7796105, 10267904, 'VI', 'Lovenlund', 1, 'lovenlund', 18.35912, -64.91098),
(7796108, 10267902, 'VI', 'Lower Love', 1, 'lower-love', 17.7222, -64.80765),
(7796109, 10267902, 'VI', 'Lowrys Hill', 1, 'lowrys-hill', 17.73914, -64.67236),
(7796112, 10267902, 'VI', 'Madame Carty', 1, 'madame-carty', 17.73608, -64.61708),
(7796115, 10267904, 'VI', 'Mafolie', 1, 'mafolie', 18.35246, -64.93153),
(7796132, 10267903, 'VI', 'Mandal', 1, 'mandal', 18.31329, -64.71152),
(7796133, 10267904, 'VI', 'Mandal', 1, 'mandal', 18.35551, -64.89848),
(7796147, 10267904, 'VI', 'Mariendal', 1, 'mariendal', 18.32773, -64.88153),
(7796161, 10267903, 'VI', 'Mary Point', 1, 'mary-point', 18.36523, -64.7418),
(7796180, 10267904, 'VI', 'Misgen', 1, 'misgen', 18.3544, -64.93181),
(7796182, 10267903, 'VI', 'Mollendal', 1, 'mollendal', 18.32912, -64.75153),
(7796184, 10267902, 'VI', 'Mon Bijou', 1, 'mon-bijou', 17.74831, -64.78876),
(7796195, 10267903, 'VI', 'Monte', 1, 'monte', 18.32079, -64.77625),
(7796197, 10267902, 'VI', 'Montpellier', 1, 'montpellier', 17.73886, -64.84237),
(7796204, 10267902, 'VI', 'Morningstar', 1, 'morningstar', 17.75831, -64.76126),
(7796221, 10267902, 'VI', 'Mount Pleasant', 1, 'mount-pleasant', 17.74581, -64.8007),
(7796222, 10267903, 'VI', 'Mount Pleasant', 1, 'mount-pleasant', 18.35579, -64.73653),
(7796249, 10267902, 'VI', 'Munster', 1, 'munster', 17.72303, -64.68792),
(7796252, 10267904, 'VI', 'Nadir', 1, 'nadir', 18.32218, -64.8782),
(7796263, 10267904, 'VI', 'Nazareth', 1, 'nazareth', 18.32079, -64.85486),
(7796267, 10267902, 'VI', 'Negro Bay', 1, 'negro-bay', 17.70803, -64.80737),
(7796271, 10267904, 'VI', 'Neltjeberg', 1, 'neltjeberg', 18.36607, -64.97292),
(7796278, 10267902, 'VI', 'Nicholas', 1, 'nicholas', 17.75303, -64.87209),
(7796285, 10267902, 'VI', 'North Side', 1, 'north-side', 17.75858, -64.8882),
(7796286, 10267902, 'VI', 'North Star', 1, 'north-star', 17.76803, -64.81848),
(7796291, 10267902, 'VI', 'Nugent', 1, 'nugent', 17.7172, -64.67736),
(7796303, 10267902, 'VI', 'Orange Grove', 1, 'orange-grove', 17.74553, -64.71931),
(7796306, 10267902, 'VI', 'Orangegrove', 1, 'orangegrove', 17.7372, -64.85209),
(7796312, 10267902, 'VI', 'Oxford', 1, 'oxford', 17.73914, -64.86098),
(7796318, 10267903, 'VI', 'Palestina', 1, 'palestina', 18.34884, -64.7068),
(7796321, 10267902, 'VI', 'Paradise', 1, 'paradise', 17.70442, -64.81487),
(7796325, 10267902, 'VI', 'Parasol', 1, 'parasol', 17.75386, -64.81709),
(7796338, 10267902, 'VI', 'Pearl', 1, 'pearl', 17.71636, -64.73376),
(7796340, 10267904, 'VI', 'Pearson Gardens', 1, 'pearson-gardens', 18.34023, -64.9182),
(7796357, 10267904, 'VI', 'Peterborg', 1, 'peterborg', 18.37162, -64.92542),
(7796362, 10267902, 'VI', 'Peters Rest', 1, 'peters-rest', 17.72551, -64.74054),
(7796366, 10267902, 'VI', 'Petronella', 1, 'petronella', 17.72747, -64.66792),
(7796377, 10267902, 'VI', 'Pleasant Vale', 1, 'pleasant-vale', 17.74914, -64.86126),
(7796381, 10267902, 'VI', 'Plessen', 1, 'plessen', 17.71664, -64.82042),
(7796399, 10267902, 'VI', 'Profit', 1, 'profit', 17.7172, -64.78042),
(7796406, 10267902, 'VI', 'Prosperity', 1, 'prosperity', 17.72609, -64.88209),
(7796416, 10267902, 'VI', 'Punch', 1, 'punch', 17.7422, -64.8682),
(7796430, 10267904, 'VI', 'Raphune', 1, 'raphune', 18.3344, -64.90903),
(7796433, 10267902, 'VI', 'Rattan and Belvedere', 1, 'rattan-and-belvedere', 17.75192, -64.75264),
(7796434, 10267902, 'VI', 'Recovery Hill', 1, 'recovery-hill', 17.73636, -64.69792),
(7796449, 10267903, 'VI', 'Reef Bay', 1, 'reef-bay', 18.3294, -64.73791),
(7796465, 10267904, 'VI', 'Resolution', 1, 'resolution', 18.3544, -64.95654),
(7796469, 10267902, 'VI', 'Richmond', 1, 'richmond', 17.74525, -64.71598),
(7796475, 10267902, 'VI', 'Robe Hill', 1, 'robe-hill', 17.71497, -64.85126),
(7796484, 10267904, 'VI', 'Rosendal', 1, 'rosendal', 18.35218, -64.91209),
(7796493, 10267902, 'VI', 'Ruan Bay', 1, 'ruan-bay', 17.69164, -64.8432),
(7796494, 10267902, 'VI', 'Ruby', 1, 'ruby', 17.73692, -64.75487),
(7796504, 10267902, 'VI', 'Ryan', 1, 'ryan', 17.72803, -64.68292),
(7796512, 10267902, 'VI', 'Saint Croix', 1, 'saint-croix', 17.72751, -64.74698),
(7796526, 10267902, 'VI', 'Saint John', 1, 'saint-john', 17.76358, -64.74709),
(7796527, 10267903, 'VI', 'Saint John', 1, 'saint-john', 18.33968, -64.74958),
(7796542, 10267902, 'VI', 'Saint Peter', 1, 'saint-peter', 17.74192, -64.69264),
(7796557, 10267902, 'VI', 'Sallys Fancy', 1, 'sallys-fancy', 17.73581, -64.66681),
(7796581, 10267902, 'VI', 'Sandy Point', 1, 'sandy-point', 17.69192, -64.88042),
(7796587, 10267904, 'VI', 'Santa Maria Estate', 1, 'santa-maria-estate', 18.35857, -64.9782),
(7796602, 10267902, 'VI', 'Seven Hills', 1, 'seven-hills', 17.74581, -64.65125),
(7796609, 10267902, 'VI', 'Shoys', 1, 'shoys', 17.75525, -64.68236),
(7796612, 10267903, 'VI', 'Sieben', 1, 'sieben', 18.33079, -64.76042),
(7796618, 10267902, 'VI', 'Sion Farm', 1, 'sion-farm', 17.73247, -64.7432),
(7796619, 10267902, 'VI', 'Sion Hill', 1, 'sion-hill', 17.74108, -64.74709),
(7796621, 10267902, 'VI', 'Slob', 1, 'slob', 17.73081, -64.78042),
(7796628, 10267902, 'VI', 'Smithfield', 1, 'smithfield', 17.6997, -64.88042),
(7796630, 10267904, 'VI', 'Solberg', 1, 'solberg', 18.34746, -64.94181),
(7796633, 10267902, 'VI', 'Solitude', 1, 'solitude', 17.75608, -64.63125),
(7796638, 10267904, 'VI', 'Sorgenfri', 1, 'sorgenfri', 18.36551, -64.98292),
(7796640, 10267902, 'VI', 'Southgate', 1, 'southgate', 17.75775, -64.60069),
(7796646, 10267902, 'VI', 'Spanish Town', 1, 'spanish-town', 17.7172, -64.77292),
(7796651, 10267902, 'VI', 'Sprat Hall Beach', 1, 'sprat-hall-beach', 17.74247, -64.89209),
(7796660, 10267902, 'VI', 'Springfield', 1, 'springfield', 17.73109, -64.83209),
(7796676, 10267902, 'VI', 'Strawberry Hill', 1, 'strawberry-hill', 17.7322, -64.76098),
(7796687, 10267902, 'VI', 'Sunny Isle', 1, 'sunny-isle', 17.72692, -64.74848),
(7796693, 10267903, 'VI', 'Susannaberg', 1, 'susannaberg', 18.34134, -64.77292),
(7796702, 10267902, 'VI', 'Teagues Bay', 1, 'teagues-bay', 17.75192, -64.60486),
(7796706, 10267902, 'VI', 'Testman', 1, 'testman', 17.75525, -64.66959),
(7796736, 10267904, 'VI', 'Tutu', 1, 'tutu', 18.33884, -64.88653),
(7796742, 10267902, 'VI', 'Two Brothers', 1, 'two-brothers', 17.70636, -64.87931),
(7796757, 10267902, 'VI', 'Upper Love', 1, 'upper-love', 17.73109, -64.81542),
(7796809, 10267902, 'VI', 'Waldberggaard', 1, 'waldberggaard', 17.71664, -64.84431),
(7796843, 10267902, 'VI', 'Wheel of Fortune', 1, 'wheel-of-fortune', 17.7122, -64.87098),
(7796845, 10267902, 'VI', 'Whim', 1, 'whim', 17.69998, -64.86209),
(7796851, 10267902, 'VI', 'Whites Bay', 1, 'whites-bay', 17.68831, -64.87376),
(7796854, 10267902, 'VI', 'William', 1, 'william', 17.73442, -64.88876),
(7796857, 10267902, 'VI', 'Williams Delight', 1, 'williams-delight', 17.69998, -64.83542),
(7796861, 10267903, 'VI', 'Windberg', 1, 'windberg', 18.3569, -64.74041),
(7796862, 10267902, 'VI', 'Windsor', 1, 'windsor', 17.75858, -64.77376),
(7796876, 10267904, 'VI', 'Zambee', 1, 'zambee', 18.35607, -64.97654),
(14205169, 10267904, 'VI', 'Sapphire Village', 1, 'sapphire-village', 18.33465, -64.85045);