REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('CA', 'Canada', 'canada', '1', 'Canada', 'CAD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000872, 'CA', 'Alberta', 1, 'alberta');

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 
(1016151, 1000872, 'CA', 'Airdrie', 1, 'airdrie', 51.30011000, -114.03528000),
(1016178, 1000872, 'CA', 'Athabasca', 1, 'athabasca', 54.71687000, -113.28537000),
(1016190, 1000872, 'CA', 'Banff', 1, 'banff', 51.17622000, -115.56982000),
(1016192, 1000872, 'CA', 'Barrhead', 1, 'barrhead', 54.13345000, -114.40211000),
(1016196, 1000872, 'CA', 'Bassano', 1, 'bassano', 50.78342000, -112.46854000),
(1016204, 1000872, 'CA', 'Beaumont', 1, 'beaumont', 53.35013000, -113.41871000),
(1016207, 1000872, 'CA', 'Beaverlodge', 1, 'beaverlodge', 55.21664000, -119.43605000),
(1016219, 1000872, 'CA', 'Black Diamond', 1, 'black-diamond', 50.70011000, -114.23530000),
(1016220, 1000872, 'CA', 'Blackfalds', 1, 'blackfalds', 52.38342000, -113.78530000),
(1016226, 1000872, 'CA', 'Bon Accord', 1, 'bon-accord', 53.83345000, -113.41872000),
(1016229, 1000872, 'CA', 'Bonnyville', 1, 'bonnyville', 54.26684000, -110.73505000),
(1016234, 1000872, 'CA', 'Bow Island', 1, 'bow-island', 49.86676000, -111.36843000),
(1016245, 1000872, 'CA', 'Brooks', 1, 'brooks', 50.58341000, -111.88509000),
(1016259, 1000872, 'CA', 'Calgary', 1, 'calgary', 51.05011000, -114.08529000),
(1016260, 1000872, 'CA', 'Calmar', 1, 'calmar', 53.26683000, -113.81874000),
(1016265, 1000872, 'CA', 'Camrose', 1, 'camrose', 53.01684000, -112.83525000),
(1016267, 1000872, 'CA', 'Canmore', 1, 'canmore', 51.08335000, -115.35206000),
(1016277, 1000872, 'CA', 'Cardston', 1, 'cardston', 49.19998000, -113.30190000),
(1016284, 1000872, 'CA', 'Carstairs', 1, 'carstairs', 51.56681000, -114.10200000),
(1016305, 1000872, 'CA', 'Chestermere', 1, 'chestermere', 51.03341000, -113.81867000),
(1016314, 1000872, 'CA', 'Claresholm', 1, 'claresholm', 50.03332000, -113.58524000),
(1016316, 1000872, 'CA', 'Coaldale', 1, 'coaldale', 49.71670000, -112.61854000),
(1016317, 1000872, 'CA', 'Coalhurst', 1, 'coalhurst', 49.74640000, -112.93246000),
(1016320, 1000872, 'CA', 'Cochrane', 1, 'cochrane', 51.18341000, -114.46871000),
(1016323, 1000872, 'CA', 'Cold Lake', 1, 'cold-lake', 54.46525000, -110.18154000),
(1016349, 1000872, 'CA', 'Crossfield', 1, 'crossfield', 51.43341000, -114.03528000),
(1016371, 1000872, 'CA', 'Devon', 1, 'devon', 53.36683000, -113.73533000),
(1016372, 1000872, 'CA', 'Didsbury', 1, 'didsbury', 51.66681000, -114.13529000),
(1016383, 1000872, 'CA', 'Drayton Valley', 1, 'drayton-valley', 53.21682000, -114.98544000),
(1016396, 1000872, 'CA', 'Edmonton', 1, 'edmonton', 53.55014000, -113.46871000),
(1016398, 1000872, 'CA', 'Edson', 1, 'edson', 53.58345000, -116.43559000),
(1016399, 1000872, 'CA', 'Elk Point', 1, 'elk-point', 53.90017000, -110.90170000),
(1016413, 1000872, 'CA', 'Fairview', 1, 'fairview', 56.06675000, -118.38606000),
(1016415, 1000872, 'CA', 'Falher', 1, 'falher', 55.73339000, -117.20262000),
(1016429, 1000872, 'CA', 'Fort Macleod', 1, 'fort-macleod', 49.71671000, -113.41857000),
(1016430, 1000872, 'CA', 'Fort McMurray', 1, 'fort-mcmurray', 56.72676000, -111.38103000),
(1016433, 1000872, 'CA', 'Fort Saskatchewan', 1, 'fort-saskatchewan', 53.71684000, -113.21870000),
(1016438, 1000872, 'CA', 'Fox Creek', 1, 'fox-creek', 54.40007000, -116.80238000),
(1016450, 1000872, 'CA', 'Gibbons', 1, 'gibbons', 53.83345000, -113.33531000),
(1016463, 1000872, 'CA', 'Grand Centre', 1, 'grand-centre', 54.41628000, -110.21304000),
(1016466, 1000872, 'CA', 'Grande Cache', 1, 'grande-cache', 53.88335000, -119.13585000),
(1016467, 1000872, 'CA', 'Grande Prairie', 1, 'grande-prairie', 55.16667000, -118.80271000),
(1016476, 1000872, 'CA', 'Grimshaw', 1, 'grimshaw', 56.18339000, -117.60270000),
(1016488, 1000872, 'CA', 'Hanna', 1, 'hanna', 51.63343000, -111.90181000),
(1016502, 1000872, 'CA', 'Heritage Pointe', 1, 'heritage-pointe', 50.84213000, -114.00493000),
(1016503, 1000872, 'CA', 'High Level', 1, 'high-level', 58.51688000, -117.13605000),
(1016504, 1000872, 'CA', 'High Prairie', 1, 'high-prairie', 55.43340000, -116.48580000),
(1016505, 1000872, 'CA', 'High River', 1, 'high-river', 50.58341000, -113.86867000),
(1016506, 1000872, 'CA', 'Hinton', 1, 'hinton', 53.40009000, -117.58567000),
(1016526, 1000872, 'CA', 'Irricana', 1, 'irricana', 51.32372000, -113.60475000),
(1016528, 1000872, 'CA', 'Jasper Park Lodge', 1, 'jasper-park-lodge', 52.88633000, -118.05625000),
(1016543, 1000872, 'CA', 'Killam', 1, 'killam', 52.78344000, -111.85175000),
(1016575, 1000872, 'CA', 'Lac La Biche', 1, 'lac-la-biche', 54.76690000, -111.96861000),
(1016585, 1000872, 'CA', 'Lacombe', 1, 'lacombe', 52.46681000, -113.73530000),
(1016592, 1000872, 'CA', 'Lamont', 1, 'lamont', 53.76686000, -112.80195000),
(1016602, 1000872, 'CA', 'Larkspur', 1, 'larkspur', 53.47942000, -113.38142000),
(1016603, 1000872, 'CA', 'Laurel', 1, 'laurel', 53.44667000, -113.38197000),
(1016610, 1000872, 'CA', 'Leduc', 1, 'leduc', 53.26682000, -113.55201000),
(1016614, 1000872, 'CA', 'Lethbridge', 1, 'lethbridge', 49.69999000, -112.81856000),
(1016625, 1000872, 'CA', 'Lloydminster', 1, 'lloydminster', 53.27237000, -110.02256000),
(1016645, 1000872, 'CA', 'Magrath', 1, 'magrath', 49.41668000, -112.86856000),
(1016653, 1000872, 'CA', 'Manning', 1, 'manning', 56.91683000, -117.61945000),
(1016654, 1000872, 'CA', 'Mannville', 1, 'mannville', 53.33764000, -111.17750000),
(1016657, 1000872, 'CA', 'Maple Ridge', 1, 'maple-ridge', 53.50172000, -113.36274000),
(1016671, 1000872, 'CA', 'Mayerthorpe', 1, 'mayerthorpe', 53.95015000, -115.13547000),
(1016675, 1000872, 'CA', 'Medicine Hat', 1, 'medicine-hat', 50.03928000, -110.67661000),
(1016689, 1000872, 'CA', 'Mill Woods Town Centre', 1, 'mill-woods-town-centre', 53.45639000, -113.42751000),
(1016691, 1000872, 'CA', 'Millet', 1, 'millet', 53.10013000, -113.46870000),
(1016719, 1000872, 'CA', 'Morinville', 1, 'morinville', 53.80014000, -113.65203000),
(1016729, 1000872, 'CA', 'Nanton', 1, 'nanton', 50.35008000, -113.76866000),
(1016774, 1000872, 'CA', 'Okotoks', 1, 'okotoks', 50.72885000, -113.98281000),
(1016775, 1000872, 'CA', 'Olds', 1, 'olds', 51.78341000, -114.10199000),
(1016803, 1000872, 'CA', 'Peace River', 1, 'peace-river', 56.23715000, -117.29176000),
(1016810, 1000872, 'CA', 'Penhold', 1, 'penhold', 52.13342000, -113.86870000),
(1016820, 1000872, 'CA', 'Picture Butte', 1, 'picture-butte', 49.88330000, -112.78516000),
(1016824, 1000872, 'CA', 'Pincher Creek', 1, 'pincher-creek', 49.48328000, -113.95195000),
(1016834, 1000872, 'CA', 'Ponoka', 1, 'ponoka', 52.67680000, -113.58147000),
(1016861, 1000872, 'CA', 'Provost', 1, 'provost', 52.35014000, -110.26828000),
(1016871, 1000872, 'CA', 'Raymond', 1, 'raymond', 49.44998000, -112.65185000),
(1016873, 1000872, 'CA', 'Red Deer', 1, 'red-deer', 52.26682000, -113.80200000),
(1016889, 1000872, 'CA', 'Rideau Park', 1, 'rideau-park', 53.47899000, -113.50470000),
(1016892, 1000872, 'CA', 'Rimbey', 1, 'rimbey', 52.63340000, -114.23532000),
(1016901, 1000872, 'CA', 'Rocky Mountain House', 1, 'rocky-mountain-house', 52.36683000, -114.91880000),
(1017029, 1000872, 'CA', 'Sexsmith', 1, 'sexsmith', 55.34998000, -118.78602000),
(1017040, 1000872, 'CA', 'Sherwood Park', 1, 'sherwood-park', 53.51684000, -113.31870000),
(1017044, 1000872, 'CA', 'Silver Berry', 1, 'silver-berry', 53.45787000, -113.38170000),
(1017049, 1000872, 'CA', 'Slave Lake', 1, 'slave-lake', 55.28344000, -114.76896000),
(1017052, 1000872, 'CA', 'Smoky Lake', 1, 'smoky-lake', 54.11687000, -112.46863000),
(1017061, 1000872, 'CA', 'Spirit River', 1, 'spirit-river', 55.78327000, -118.83607000),
(1017062, 1000872, 'CA', 'Springbrook', 1, 'springbrook', 52.17920000, -113.87981000),
(1017065, 1000872, 'CA', 'Spruce Grove', 1, 'spruce-grove', 53.53344000, -113.91874000),
(1017068, 1000872, 'CA', 'St. Albert', 1, 'st-albert', 53.63344000, -113.63533000),
(1017078, 1000872, 'CA', 'Stettler', 1, 'stettler', 52.31683000, -112.71861000),
(1017082, 1000872, 'CA', 'Stony Plain', 1, 'stony-plain', 53.53343000, -114.00205000),
(1017084, 1000872, 'CA', 'Strathmore', 1, 'strathmore', 51.05011000, -113.38523000),
(1017088, 1000872, 'CA', 'Sundre', 1, 'sundre', 51.80010000, -114.63532000),
(1017092, 1000872, 'CA', 'Swan Hills', 1, 'swan-hills', 54.71681000, -115.40226000),
(1017097, 1000872, 'CA', 'Sylvan Lake', 1, 'sylvan-lake', 52.31100000, -114.08375000),
(1017098, 1000872, 'CA', 'Taber', 1, 'taber', 49.78703000, -112.14603000),
(1017099, 1000872, 'CA', 'Tamarack', 1, 'tamarack', 53.46441000, -113.36235000),
(1017110, 1000872, 'CA', 'Three Hills', 1, 'three-hills', 51.70012000, -113.26863000),
(1017118, 1000872, 'CA', 'Tofield', 1, 'tofield', 53.36684000, -112.66862000),
(1017131, 1000872, 'CA', 'Two Hills', 1, 'two-hills', 53.71686000, -111.75181000),
(1017143, 1000872, 'CA', 'Valleyview', 1, 'valleyview', 55.06673000, -117.28585000),
(1017151, 1000872, 'CA', 'Vegreville', 1, 'vegreville', 53.50015000, -112.05182000),
(1017154, 1000872, 'CA', 'Vermilion', 1, 'vermilion', 53.35409000, -110.85849000),
(1017158, 1000872, 'CA', 'Viking', 1, 'viking', 53.10014000, -111.76844000),
(1017163, 1000872, 'CA', 'Vulcan', 1, 'vulcan', 50.40008000, -113.25189000),
(1017166, 1000872, 'CA', 'Wainwright', 1, 'wainwright', 52.83482000, -110.85342000),
(1017187, 1000872, 'CA', 'Wembley', 1, 'wembley', 55.14995000, -119.13602000),
(1017194, 1000872, 'CA', 'Westlake', 1, 'westlake', 55.22228000, -118.80415000),
(1017195, 1000872, 'CA', 'Westlock', 1, 'westlock', 54.15016000, -113.86876000),
(1017197, 1000872, 'CA', 'Wetaskiwin', 1, 'wetaskiwin', 52.96683000, -113.36869000),
(1017203, 1000872, 'CA', 'Whitecourt', 1, 'whitecourt', 54.15015000, -115.68548000),
(1017205, 1000872, 'CA', 'Wild Rose', 1, 'wild-rose', 53.47080000, -113.38119000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000875, 'CA', 'British Columbia', 1, 'british-columbia');

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 
(1016146, 1000875, 'CA', 'Abbotsford', 1, 'abbotsford', 49.05798000, -122.25257000),
(1016150, 1000875, 'CA', 'Agassiz', 1, 'agassiz', 49.23298000, -121.76926000),
(1016155, 1000875, 'CA', 'Aldergrove', 1, 'aldergrove', 49.05801000, -122.47087000),
(1016156, 1000875, 'CA', 'Aldergrove East', 1, 'aldergrove-east', 49.05593000, -122.42299000),
(1016169, 1000875, 'CA', 'Anmore', 1, 'anmore', 49.31637000, -122.85263000),
(1016172, 1000875, 'CA', 'Arbutus Ridge', 1, 'arbutus-ridge', 49.24966000, -123.16934000),
(1016173, 1000875, 'CA', 'Armstrong', 1, 'armstrong', 50.44979000, -119.20235000),
(1016176, 1000875, 'CA', 'Ashcroft', 1, 'ashcroft', 50.72372000, -121.28207000),
(1016194, 1000875, 'CA', 'Barrière', 1, 'barriere', 51.18308000, -120.11920000),
(1016235, 1000875, 'CA', 'Bowen Island', 1, 'bowen-island', 49.38470000, -123.33622000),
(1016253, 1000875, 'CA', 'Burnaby', 1, 'burnaby', 49.26636000, -122.95263000),
(1016254, 1000875, 'CA', 'Burns Lake', 1, 'burns-lake', 54.22972000, -125.76084000),
(1016257, 1000875, 'CA', 'Cache Creek', 1, 'cache-creek', 50.81011000, -121.32460000),
(1016263, 1000875, 'CA', 'Campbell River', 1, 'campbell-river', 50.01634000, -125.24459000),
(1016286, 1000875, 'CA', 'Castlegar', 1, 'castlegar', 49.32317000, -117.65831000),
(1016288, 1000875, 'CA', 'Cedar', 1, 'cedar', 49.11633000, -123.85270000),
(1016289, 1000875, 'CA', 'Central Coast Regional District', 1, 'central-coast-regional-district', 52.16638000, -127.00323000),
(1016298, 1000875, 'CA', 'Chase', 1, 'chase', 50.81650000, -119.68571000),
(1016302, 1000875, 'CA', 'Chemainus', 1, 'chemainus', 48.91633000, -123.71937000),
(1016306, 1000875, 'CA', 'Chetwynd', 1, 'chetwynd', 55.69988000, -121.63627000),
(1016308, 1000875, 'CA', 'Chilliwack', 1, 'chilliwack', 49.16638000, -121.95257000),
(1016326, 1000875, 'CA', 'Colwood', 1, 'colwood', 48.43293000, -123.48591000),
(1016334, 1000875, 'CA', 'Coombs', 1, 'coombs', 49.29963000, -124.41946000),
(1016335, 1000875, 'CA', 'Coquitlam', 1, 'coquitlam', 49.28460000, -122.78217000),
(1016341, 1000875, 'CA', 'Courtenay', 1, 'courtenay', 49.68657000, -124.99360000),
(1016344, 1000875, 'CA', 'Cowichan Bay', 1, 'cowichan-bay', 48.73366000, -123.61739000),
(1016346, 1000875, 'CA', 'Cranbrook', 1, 'cranbrook', 49.49991000, -115.76879000),
(1016347, 1000875, 'CA', 'Creston', 1, 'creston', 49.09987000, -116.50211000),
(1016350, 1000875, 'CA', 'Cumberland', 1, 'cumberland', 49.61634000, -125.03613000),
(1016359, 1000875, 'CA', 'Dawson Creek', 1, 'dawson-creek', 55.75984000, -120.24030000),
(1016366, 1000875, 'CA', 'Delta', 1, 'delta', 49.14399000, -122.90680000),
(1016367, 1000875, 'CA', 'Denman Island', 1, 'denman-island', 49.53294000, -124.81950000),
(1016368, 1000875, 'CA', 'Denman Island Trust Area', 1, 'denman-island-trust-area', 49.55189000, -124.79881000),
(1016386, 1000875, 'CA', 'Duck Lake', 1, 'duck-lake', 50.00880000, -119.39672000),
(1016387, 1000875, 'CA', 'Duncan', 1, 'duncan', 48.78293000, -123.70266000),
(1016394, 1000875, 'CA', 'East Wellington', 1, 'east-wellington', 49.17385000, -124.01745000),
(1016400, 1000875, 'CA', 'Elkford', 1, 'elkford', 50.05007000, -114.88540000),
(1016402, 1000875, 'CA', 'Ellison', 1, 'ellison', 49.93307000, -119.36907000),
(1016404, 1000875, 'CA', 'Enderby', 1, 'enderby', 50.54980000, -119.15234000),
(1016414, 1000875, 'CA', 'Fairwinds', 1, 'fairwinds', 49.27588000, -124.12782000),
(1016421, 1000875, 'CA', 'Fernie', 1, 'fernie', 49.49996000, -115.06871000),
(1016432, 1000875, 'CA', 'Fort Nelson', 1, 'fort-nelson', 58.80533000, -122.70020000),
(1016435, 1000875, 'CA', 'Fort St. John', 1, 'fort-st-john', 56.24988000, -120.85292000),
(1016440, 1000875, 'CA', 'Fraser Valley Regional District', 1, 'fraser-valley-regional-district', 49.58299000, -121.83587000),
(1016442, 1000875, 'CA', 'French Creek', 1, 'french-creek', 49.34123000, -124.35541000),
(1016443, 1000875, 'CA', 'Fruitvale', 1, 'fruitvale', 49.11654000, -117.55222000),
(1016451, 1000875, 'CA', 'Gibsons', 1, 'gibsons', 49.39539000, -123.50555000),
(1016458, 1000875, 'CA', 'Golden', 1, 'golden', 51.29995000, -116.96890000),
(1016465, 1000875, 'CA', 'Grand Forks', 1, 'grand-forks', 49.03309000, -118.43560000),
(1016487, 1000875, 'CA', 'Hanceville', 1, 'hanceville', 51.91922000, -123.04458000),
(1016507, 1000875, 'CA', 'Hope', 1, 'hope', 49.38299000, -121.44144000),
(1016508, 1000875, 'CA', 'Hornby Island', 1, 'hornby-island', 49.53448000, -124.66923000),
(1016510, 1000875, 'CA', 'Houston', 1, 'houston', 54.39976000, -126.67008000),
(1016523, 1000875, 'CA', 'Invermere', 1, 'invermere', 50.51666000, -116.03538000),
(1016531, 1000875, 'CA', 'Kamloops', 1, 'kamloops', 50.66648000, -120.31920000),
(1016536, 1000875, 'CA', 'Kelowna', 1, 'kelowna', 49.88307000, -119.48568000),
(1016545, 1000875, 'CA', 'Kimberley', 1, 'kimberley', 49.67071000, -115.97760000),
(1016554, 1000875, 'CA', 'Kitimat', 1, 'kitimat', 54.05244000, -128.65342000),
(1016586, 1000875, 'CA', 'Ladner', 1, 'ladner', 49.08938000, -123.08241000),
(1016587, 1000875, 'CA', 'Ladysmith', 1, 'ladysmith', 48.99016000, -123.81699000),
(1016588, 1000875, 'CA', 'Lake Cowichan', 1, 'lake-cowichan', 48.82495000, -124.05461000),
(1016595, 1000875, 'CA', 'Langford', 1, 'langford', 48.44963000, -123.50261000),
(1016597, 1000875, 'CA', 'Langley', 1, 'langley', 49.10107000, -122.65883000),
(1016616, 1000875, 'CA', 'Lillooet', 1, 'lillooet', 50.68560000, -121.94200000),
(1016621, 1000875, 'CA', 'Lions Bay', 1, 'lions-bay', 49.45218000, -123.23760000),
(1016626, 1000875, 'CA', 'Logan Lake', 1, 'logan-lake', 50.49976000, -120.80253000),
(1016635, 1000875, 'CA', 'Lumby', 1, 'lumby', 50.24979000, -118.96904000),
(1016641, 1000875, 'CA', 'Mackenzie', 1, 'mackenzie', 55.33637000, -123.09374000),
(1016656, 1000875, 'CA', 'Maple Ridge', 1, 'maple-ridge', 49.21939000, -122.60193000),
(1016681, 1000875, 'CA', 'Merritt', 1, 'merritt', 50.11225000, -120.79420000),
(1016684, 1000875, 'CA', 'Metchosin', 1, 'metchosin', 48.38293000, -123.53591000),
(1016685, 1000875, 'CA', 'Metro Vancouver Regional District', 1, 'metro-vancouver-regional-district', 49.33296000, -123.00264000),
(1016696, 1000875, 'CA', 'Mission', 1, 'mission', 49.13298000, -122.30258000),
(1016727, 1000875, 'CA', 'Nakusp', 1, 'nakusp', 50.24987000, -117.80226000),
(1016728, 1000875, 'CA', 'Nanaimo', 1, 'nanaimo', 49.16638000, -123.94003000),
(1016735, 1000875, 'CA', 'Nelson', 1, 'nelson', 49.49985000, -117.28553000),
(1016742, 1000875, 'CA', 'New Westminster', 1, 'new-westminster', 49.20678000, -122.91092000),
(1016757, 1000875, 'CA', 'North Cowichan', 1, 'north-cowichan', 48.84133000, -123.68596000),
(1016758, 1000875, 'CA', 'North Oyster/Yellow Point', 1, 'north-oyster-yellow-point', 49.04807000, -123.83395000),
(1016760, 1000875, 'CA', 'North Saanich', 1, 'north-saanich', 48.66634000, -123.41933000),
(1016761, 1000875, 'CA', 'North Vancouver', 1, 'north-vancouver', 49.31636000, -123.06934000),
(1016769, 1000875, 'CA', 'Oak Bay', 1, 'oak-bay', 48.44964000, -123.30260000),
(1016772, 1000875, 'CA', 'Okanagan', 1, 'okanagan', 50.36386000, -119.34997000),
(1016773, 1000875, 'CA', 'Okanagan Falls', 1, 'okanagan-falls', 49.35000000, -119.56667000),
(1016776, 1000875, 'CA', 'Oliver', 1, 'oliver', 49.18306000, -119.55240000),
(1016784, 1000875, 'CA', 'Osoyoos', 1, 'osoyoos', 49.03306000, -119.45237000),
(1016798, 1000875, 'CA', 'Parksville', 1, 'parksville', 49.31947000, -124.31575000),
(1016804, 1000875, 'CA', 'Peace River Regional District', 1, 'peace-river-regional-district', 56.66650000, -122.75302000),
(1016805, 1000875, 'CA', 'Peachland', 1, 'peachland', 49.76647000, -119.73568000),
(1016808, 1000875, 'CA', 'Pemberton', 1, 'pemberton', 50.31641000, -122.80273000),
(1016811, 1000875, 'CA', 'Penticton', 1, 'penticton', 49.48062000, -119.58584000),
(1016826, 1000875, 'CA', 'Pitt Meadows', 1, 'pitt-meadows', 49.22119000, -122.68965000),
(1016837, 1000875, 'CA', 'Port Alberni', 1, 'port-alberni', 49.24133000, -124.80280000),
(1016839, 1000875, 'CA', 'Port Coquitlam', 1, 'port-coquitlam', 49.26637000, -122.76932000),
(1016842, 1000875, 'CA', 'Port McNeill', 1, 'port-mcneill', 50.58716000, -127.08053000),
(1016843, 1000875, 'CA', 'Port Moody', 1, 'port-moody', 49.28124000, -122.82457000),
(1016851, 1000875, 'CA', 'Powell River', 1, 'powell-river', 49.83278000, -124.52368000),
(1016856, 1000875, 'CA', 'Prince George', 1, 'prince-george', 53.91660000, -122.75301000),
(1016857, 1000875, 'CA', 'Prince Rupert', 1, 'prince-rupert', 54.31507000, -130.32098000),
(1016858, 1000875, 'CA', 'Princeton', 1, 'princeton', 49.45802000, -120.51076000),
(1016863, 1000875, 'CA', 'Puntledge', 1, 'puntledge', 49.66168000, -125.05686000),
(1016865, 1000875, 'CA', 'Quesnel', 1, 'quesnel', 52.97842000, -122.49310000),
(1016877, 1000875, 'CA', 'Regional District of Alberni-Clayoquot', 1, 'regional-district-of-alberni-clayoquot', 49.24962000, -125.33615000),
(1016878, 1000875, 'CA', 'Regional District of Central Okanagan', 1, 'regional-district-of-central-okanagan', 49.99978000, -119.41908000),
(1016882, 1000875, 'CA', 'Revelstoke', 1, 'revelstoke', 50.99712000, -118.19530000),
(1016885, 1000875, 'CA', 'Richmond', 1, 'richmond', 49.17003000, -123.13683000),
(1016904, 1000875, 'CA', 'Rossland', 1, 'rossland', 49.08313000, -117.80224000),
(1016908, 1000875, 'CA', 'Royston', 1, 'royston', 49.64703000, -124.94670000),
(1017016, 1000875, 'CA', 'Salmo', 1, 'salmo', 49.19986000, -117.26890000),
(1017017, 1000875, 'CA', 'Salmon Arm', 1, 'salmon-arm', 50.69980000, -119.30237000),
(1017018, 1000875, 'CA', 'Salt Spring Island', 1, 'salt-spring-island', 48.81852000, -123.49061000),
(1017019, 1000875, 'CA', 'Saltair', 1, 'saltair', 48.94963000, -123.76939000),
(1017025, 1000875, 'CA', 'Sechelt', 1, 'sechelt', 49.47512000, -123.75903000),
(1017043, 1000875, 'CA', 'Sicamous', 1, 'sicamous', 50.83312000, -118.98565000),
(1017047, 1000875, 'CA', 'Six Mile', 1, 'six-mile', 48.45767000, -123.46088000),
(1017050, 1000875, 'CA', 'Smithers', 1, 'smithers', 54.78036000, -127.17428000),
(1017053, 1000875, 'CA', 'Sooke', 1, 'sooke', 48.37463000, -123.72762000),
(1017058, 1000875, 'CA', 'South Pender Harbour', 1, 'south-pender-harbour', 49.62202000, -124.02484000),
(1017060, 1000875, 'CA', 'Sparwood', 1, 'sparwood', 49.73332000, -114.88532000),
(1017086, 1000875, 'CA', 'Summerland', 1, 'summerland', 49.59977000, -119.66911000),
(1017089, 1000875, 'CA', 'Surrey', 1, 'surrey', 49.10635000, -122.82509000),
(1017102, 1000875, 'CA', 'Terrace', 1, 'terrace', 54.51634000, -128.60345000),
(1017119, 1000875, 'CA', 'Tofino', 1, 'tofino', 49.15314000, -125.90744000),
(1017125, 1000875, 'CA', 'Trail', 1, 'trail', 49.09983000, -117.70223000),
(1017128, 1000875, 'CA', 'Tsawwassen', 1, 'tsawwassen', 49.01667000, -123.08333000),
(1017129, 1000875, 'CA', 'Tumbler Ridge', 1, 'tumbler-ridge', 55.13027000, -120.99415000),
(1017133, 1000875, 'CA', 'Ucluelet', 1, 'ucluelet', 48.94153000, -125.54635000),
(1017145, 1000875, 'CA', 'Vancouver', 1, 'vancouver', 49.24966000, -123.11934000),
(1017146, 1000875, 'CA', 'Vanderhoof', 1, 'vanderhoof', 54.01657000, -124.01982000),
(1017155, 1000875, 'CA', 'Vernon', 1, 'vernon', 50.26729000, -119.27337000),
(1017156, 1000875, 'CA', 'Victoria', 1, 'victoria', 48.43590000, -123.35155000),
(1017168, 1000875, 'CA', 'Walnut Grove', 1, 'walnut-grove', 49.16473000, -122.64042000),
(1017183, 1000875, 'CA', 'Welcome Beach', 1, 'welcome-beach', 49.47959000, -123.89239000),
(1017189, 1000875, 'CA', 'West End', 1, 'west-end', 49.28333000, -123.13333000),
(1017190, 1000875, 'CA', 'West Kelowna', 1, 'west-kelowna', 49.86250000, -119.58333000),
(1017193, 1000875, 'CA', 'West Vancouver', 1, 'west-vancouver', 49.36672000, -123.16652000),
(1017200, 1000875, 'CA', 'Whistler', 1, 'whistler', 50.11817000, -122.95396000),
(1017202, 1000875, 'CA', 'White Rock', 1, 'white-rock', 49.01636000, -122.80260000),
(1017207, 1000875, 'CA', 'Williams Lake', 1, 'williams-lake', 52.14153000, -122.14451000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000867, 'CA', 'Manitoba', 1, 'manitoba');

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 
(1016160, 1000867, 'CA', 'Altona', 1, 'altona', 49.10469000, -97.55961000),
(1016206, 1000867, 'CA', 'Beausejour', 1, 'beausejour', 50.06220000, -96.51669000),
(1016225, 1000867, 'CA', 'Boissevain', 1, 'boissevain', 49.23062000, -100.05586000),
(1016238, 1000867, 'CA', 'Brandon', 1, 'brandon', 49.84692000, -99.95306000),
(1016275, 1000867, 'CA', 'Carberry', 1, 'carberry', 49.86893000, -99.36021000),
(1016283, 1000867, 'CA', 'Carman', 1, 'carman', 49.49920000, -98.00156000),
(1016348, 1000867, 'CA', 'Cross Lake 19A', 1, 'cross-lake-19a', 54.65135000, -97.76848000),
(1016356, 1000867, 'CA', 'Dauphin', 1, 'dauphin', 51.14941000, -100.05023000),
(1016360, 1000867, 'CA', 'De Salaberry', 1, 'de-salaberry', 49.39999000, -97.00894000),
(1016364, 1000867, 'CA', 'Deloraine', 1, 'deloraine', 49.19082000, -100.49477000),
(1016422, 1000867, 'CA', 'Flin Flon', 1, 'flin-flon', 54.76703000, -101.87433000),
(1016452, 1000867, 'CA', 'Gimli', 1, 'gimli', 50.63362000, -96.99066000),
(1016477, 1000867, 'CA', 'Grunthal', 1, 'grunthal', 49.40668000, -96.85873000),
(1016500, 1000867, 'CA', 'Headingley', 1, 'headingley', 49.87530000, -97.40896000),
(1016518, 1000867, 'CA', 'Ile des Chênes', 1, 'ile-des-chenes', 49.71060000, -96.98893000),
(1016544, 1000867, 'CA', 'Killarney', 1, 'killarney', 49.18332000, -99.66364000),
(1016563, 1000867, 'CA', 'La Broquerie', 1, 'la-broquerie', 49.51688000, -96.50029000),
(1016576, 1000867, 'CA', 'Lac du Bonnet', 1, 'lac-du-bonnet', 50.25360000, -96.06116000),
(1016593, 1000867, 'CA', 'Landmark', 1, 'landmark', 49.67169000, -96.82232000),
(1016629, 1000867, 'CA', 'Lorette', 1, 'lorette', 49.73919000, -96.87232000),
(1016677, 1000867, 'CA', 'Melita', 1, 'melita', 49.26811000, -100.99669000),
(1016693, 1000867, 'CA', 'Minnedosa', 1, 'minnedosa', 50.24532000, -99.84364000),
(1016714, 1000867, 'CA', 'Moose Lake', 1, 'moose-lake', 49.20559000, -95.30629000),
(1016717, 1000867, 'CA', 'Morden', 1, 'morden', 49.19190000, -98.10136000),
(1016720, 1000867, 'CA', 'Morris', 1, 'morris', 49.35499000, -97.36567000),
(1016734, 1000867, 'CA', 'Neepawa', 1, 'neepawa', 50.22892000, -99.46642000),
(1016749, 1000867, 'CA', 'Niverville', 1, 'niverville', 49.60559000, -97.04234000),
(1016848, 1000867, 'CA', 'Portage la Prairie', 1, 'portage-la-prairie', 49.97282000, -98.29263000),
(1016894, 1000867, 'CA', 'Rivers', 1, 'rivers', 50.03081000, -100.24029000),
(1016898, 1000867, 'CA', 'Roblin', 1, 'roblin', 51.22999000, -101.35650000),
(1017026, 1000867, 'CA', 'Selkirk', 1, 'selkirk', 50.14360000, -96.88452000),
(1017041, 1000867, 'CA', 'Shilo', 1, 'shilo', 49.80509000, -99.63175000),
(1017056, 1000867, 'CA', 'Souris', 1, 'souris', 49.61720000, -100.26120000),
(1017067, 1000867, 'CA', 'St. Adolphe', 1, 'st-adolphe', 49.67440000, -97.11124000),
(1017075, 1000867, 'CA', 'Steinbach', 1, 'steinbach', 49.52579000, -96.68451000),
(1017080, 1000867, 'CA', 'Stonewall', 1, 'stonewall', 50.13441000, -97.32676000),
(1017093, 1000867, 'CA', 'Swan River', 1, 'swan-river', 52.10580000, -101.26759000),
(1017105, 1000867, 'CA', 'The Pas', 1, 'the-pas', 53.82509000, -101.25413000),
(1017108, 1000867, 'CA', 'Thompson', 1, 'thompson', 55.74350000, -97.85579000),
(1017161, 1000867, 'CA', 'Virden', 1, 'virden', 49.85080000, -100.93262000),
(1017192, 1000867, 'CA', 'West St. Paul', 1, 'west-st-paul', 49.99940000, -97.16284000),
(1017214, 1000867, 'CA', 'Winkler', 1, 'winkler', 49.18170000, -97.94104000),
(1017215, 1000867, 'CA', 'Winnipeg', 1, 'winnipeg', 49.88440000, -97.14704000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000868, 'CA', 'New Brunswick', 1, 'new-brunswick');

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 
(1016184, 1000868, 'CA', 'Baie Ste. Anne', 1, 'baie-ste-anne', 47.05231000, -64.95355000),
(1016198, 1000868, 'CA', 'Bathurst', 1, 'bathurst', 47.61814000, -65.65112000),
(1016232, 1000868, 'CA', 'Bouctouche', 1, 'bouctouche', 46.46844000, -64.73905000),
(1016264, 1000868, 'CA', 'Campbellton', 1, 'campbellton', 48.00751000, -66.67272000),
(1016373, 1000868, 'CA', 'Dieppe', 1, 'dieppe', 46.07844000, -64.68735000),
(1016397, 1000868, 'CA', 'Edmundston', 1, 'edmundston', 47.37370000, -68.32512000),
(1016423, 1000868, 'CA', 'Florenceville-Bristol', 1, 'florenceville-bristol', 46.44353000, -67.61536000),
(1016441, 1000868, 'CA', 'Fredericton', 1, 'fredericton', 45.94541000, -66.66558000),
(1016444, 1000868, 'CA', 'Fundy Bay', 1, 'fundy-bay', 44.74100000, -66.76041000),
(1016468, 1000868, 'CA', 'Grande-Digue', 1, 'grande-digue', 46.30014000, -64.56546000),
(1016471, 1000868, 'CA', 'Greater Lakeburn', 1, 'greater-lakeburn', 46.07651000, -64.66818000),
(1016486, 1000868, 'CA', 'Hampton', 1, 'hampton', 45.52876000, -65.85354000),
(1016493, 1000868, 'CA', 'Harrison Brook', 1, 'harrison-brook', 47.21304000, -67.92847000),
(1016542, 1000868, 'CA', 'Keswick Ridge', 1, 'keswick-ridge', 46.00011000, -66.88218000),
(1016618, 1000868, 'CA', 'Lincoln', 1, 'lincoln', 45.90012000, -66.58218000),
(1016638, 1000868, 'CA', 'Lutes Mountain', 1, 'lutes-mountain', 46.13544000, -64.90504000),
(1016672, 1000868, 'CA', 'McEwen', 1, 'mcewen', 46.14520000, -64.78615000),
(1016695, 1000868, 'CA', 'Miramichi', 1, 'miramichi', 47.02895000, -65.50186000),
(1016700, 1000868, 'CA', 'Moncton', 1, 'moncton', 46.09454000, -64.79650000),
(1016726, 1000868, 'CA', 'Nackawic', 1, 'nackawic', 45.99666000, -67.24028000),
(1016741, 1000868, 'CA', 'New Maryland', 1, 'new-maryland', 45.87932000, -66.66828000),
(1016750, 1000868, 'CA', 'Noonan', 1, 'noonan', 45.96682000, -66.53218000),
(1016781, 1000868, 'CA', 'Oromocto', 1, 'oromocto', 45.83512000, -66.47917000),
(1016884, 1000868, 'CA', 'Richibucto', 1, 'richibucto', 46.68073000, -64.88044000),
(1016910, 1000868, 'CA', 'Sackville', 1, 'sackville', 45.91875000, -64.38455000),
(1016913, 1000868, 'CA', 'Saint Andrews', 1, 'saint-andrews', 45.07370000, -67.05312000),
(1016914, 1000868, 'CA', 'Saint John', 1, 'saint-john', 45.27271000, -66.06766000),
(1016921, 1000868, 'CA', 'Saint-Antoine', 1, 'saint-antoine', 46.36294000, -64.74985000),
(1016967, 1000868, 'CA', 'Saint-Léonard', 1, 'saint-leonard', 47.16317000, -67.92460000),
(1017014, 1000868, 'CA', 'Salisbury', 1, 'salisbury', 46.03905000, -65.04628000),
(1017034, 1000868, 'CA', 'Shediac', 1, 'shediac', 46.21981000, -64.54107000),
(1017035, 1000868, 'CA', 'Shediac Bridge-Shediac River', 1, 'shediac-bridge-shediac-river', 46.26886000, -64.60047000),
(1017042, 1000868, 'CA', 'Shippagan', 1, 'shippagan', 47.74424000, -64.70804000),
(1017074, 1000868, 'CA', 'Starlight Village', 1, 'starlight-village', 45.88308000, -66.76905000),
(1017090, 1000868, 'CA', 'Sussex', 1, 'sussex', 45.72266000, -65.50663000),
(1017124, 1000868, 'CA', 'Tracadie-Sheila', 1, 'tracadie-sheila', 47.51444000, -64.91806000),
(1017186, 1000868, 'CA', 'Wells', 1, 'wells', 45.39274000, -65.92313000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000877, 'CA', 'Newfoundland and Labrador', 1, 'newfoundland-and-labrador');

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 
(1016199, 1000877, 'CA', 'Bay Roberts', 1, 'bay-roberts', 47.59989000, -53.26478000),
(1016200, 1000877, 'CA', 'Bay St. George South', 1, 'bay-st-george-south', 48.22781000, -58.84162000),
(1016228, 1000877, 'CA', 'Bonavista', 1, 'bonavista', 48.64989000, -53.11474000),
(1016230, 1000877, 'CA', 'Botwood', 1, 'botwood', 49.14994000, -55.34819000),
(1016251, 1000877, 'CA', 'Burgeo', 1, 'burgeo', 47.61668000, -57.61516000),
(1016276, 1000877, 'CA', 'Carbonear', 1, 'carbonear', 47.73319000, -53.21478000),
(1016287, 1000877, 'CA', 'Catalina', 1, 'catalina', 48.51659000, -53.08135000),
(1016294, 1000877, 'CA', 'Channel-Port aux Basques', 1, 'channel-port-aux-basques', 47.57286000, -59.13808000),
(1016313, 1000877, 'CA', 'Clarenville-Shoal Harbour', 1, 'clarenville-shoal-harbour', 48.18050000, -53.96982000),
(1016327, 1000877, 'CA', 'Conception Bay South', 1, 'conception-bay-south', 47.49989000, -52.99806000),
(1016336, 1000877, 'CA', 'Corner Brook', 1, 'corner-brook', 48.95001000, -57.95202000),
(1016362, 1000877, 'CA', 'Deer Lake', 1, 'deer-lake', 49.16671000, -57.43163000),
(1016425, 1000877, 'CA', 'Fogo Island', 1, 'fogo-island', 49.71649000, -54.16981000),
(1016445, 1000877, 'CA', 'Gambo', 1, 'gambo', 48.78320000, -54.21482000),
(1016460, 1000877, 'CA', 'Goulds', 1, 'goulds', 47.45532000, -52.77552000),
(1016462, 1000877, 'CA', 'Grand Bank', 1, 'grand-bank', 47.09995000, -55.76504000),
(1016464, 1000877, 'CA', 'Grand Falls-Windsor', 1, 'grand-falls-windsor', 48.93324000, -55.66492000),
(1016491, 1000877, 'CA', 'Happy Valley-Goose Bay', 1, 'happy-valley-goose-bay', 53.30380000, -60.32576000),
(1016492, 1000877, 'CA', 'Harbour Breton', 1, 'harbour-breton', 47.48325000, -55.79833000),
(1016574, 1000877, 'CA', 'Labrador City', 1, 'labrador-city', 52.94626000, -66.91137000),
(1016615, 1000877, 'CA', 'Lewisporte', 1, 'lewisporte', 49.24993000, -55.04816000),
(1016664, 1000877, 'CA', 'Marystown', 1, 'marystown', 47.16663000, -55.14829000),
(1016724, 1000877, 'CA', 'Mount Pearl', 1, 'mount-pearl', 47.51659000, -52.78135000),
(1016802, 1000877, 'CA', 'Pasadena', 1, 'pasadena', 49.01671000, -57.59837000),
(1017063, 1000877, 'CA', 'Springdale', 1, 'springdale', 49.49995000, -56.06492000),
(1017069, 1000877, 'CA', 'St. Anthony', 1, 'st-anthony', 51.37039000, -55.59743000),
(1017072, 1000877, 'CA', 'St. John\'s', 1, 'st-john-s', 47.56494000, -52.70931000),
(1017076, 1000877, 'CA', 'Stephenville', 1, 'stephenville', 48.55001000, -58.58180000),
(1017077, 1000877, 'CA', 'Stephenville Crossing', 1, 'stephenville-crossing', 48.50001000, -58.43180000),
(1017120, 1000877, 'CA', 'Torbay', 1, 'torbay', 47.66659000, -52.73135000),
(1017135, 1000877, 'CA', 'Upper Island Cove', 1, 'upper-island-cove', 47.64989000, -53.21478000),
(1017164, 1000877, 'CA', 'Wabana', 1, 'wabana', 47.63319000, -52.94806000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000878, 'CA', 'Northwest Territories', 1, 'northwest-territories');

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 
(1016209, 1000878, 'CA', 'Behchokǫ̀', 1, 'behchoko', 62.80250000, -116.04639000),
(1016431, 1000878, 'CA', 'Fort McPherson', 1, 'fort-mcpherson', 67.43863000, -134.88543000),
(1016434, 1000878, 'CA', 'Fort Smith', 1, 'fort-smith', 60.00439000, -111.88871000),
(1016498, 1000878, 'CA', 'Hay River', 1, 'hay-river', 60.81555000, -115.79993000),
(1016522, 1000878, 'CA', 'Inuvik', 1, 'inuvik', 68.34986000, -133.72181000),
(1016753, 1000878, 'CA', 'Norman Wells', 1, 'norman-wells', 65.28201000, -126.83290000),
(1017221, 1000878, 'CA', 'Yellowknife', 1, 'yellowknife', 62.45411000, -114.37248000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000874, 'CA', 'Nova Scotia', 1, 'nova-scotia');

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 
(1016161, 1000874, 'CA', 'Amherst', 1, 'amherst', 45.83345000, -64.19874000),
(1016170, 1000874, 'CA', 'Annapolis County', 1, 'annapolis-county', 44.58345000, -65.16551000),
(1016171, 1000874, 'CA', 'Antigonish', 1, 'antigonish', 45.61685000, -61.99858000),
(1016216, 1000874, 'CA', 'Berwick', 1, 'berwick', 45.05015000, -64.73208000),
(1016242, 1000874, 'CA', 'Bridgewater', 1, 'bridgewater', 44.37856000, -64.51882000),
(1016272, 1000874, 'CA', 'Cape Breton County', 1, 'cape-breton-county', 46.00014000, -60.31516000),
(1016304, 1000874, 'CA', 'Chester', 1, 'chester', 44.54225000, -64.23891000),
(1016322, 1000874, 'CA', 'Colchester', 1, 'colchester', 45.33345000, -63.24868000),
(1016324, 1000874, 'CA', 'Cole Harbour', 1, 'cole-harbour', 44.67244000, -63.47506000),
(1016342, 1000874, 'CA', 'Cow Bay', 1, 'cow-bay', 44.63141000, -63.43218000),
(1016355, 1000874, 'CA', 'Dartmouth', 1, 'dartmouth', 44.67134000, -63.57719000),
(1016374, 1000874, 'CA', 'Digby', 1, 'digby', 44.62188000, -65.75860000),
(1016375, 1000874, 'CA', 'Digby County', 1, 'digby-county', 44.36685000, -65.69884000),
(1016406, 1000874, 'CA', 'English Corner', 1, 'english-corner', 44.73345000, -63.78201000),
(1016407, 1000874, 'CA', 'Eskasoni 3', 1, 'eskasoni-3', 45.94522000, -60.61617000),
(1016416, 1000874, 'CA', 'Fall River', 1, 'fall-river', 44.81685000, -63.61540000),
(1016454, 1000874, 'CA', 'Glace Bay', 1, 'glace-bay', 46.19695000, -59.95698000),
(1016475, 1000874, 'CA', 'Greenwood', 1, 'greenwood', 44.97413000, -64.93169000),
(1016482, 1000874, 'CA', 'Halifax', 1, 'halifax', 44.64533000, -63.57239000),
(1016490, 1000874, 'CA', 'Hantsport', 1, 'hantsport', 45.06685000, -64.16544000),
(1016499, 1000874, 'CA', 'Hayes Subdivision', 1, 'hayes-subdivision', 45.05519000, -64.58795000),
(1016539, 1000874, 'CA', 'Kentville', 1, 'kentville', 45.07710000, -64.49605000),
(1016589, 1000874, 'CA', 'Lake Echo', 1, 'lake-echo', 44.73345000, -63.38198000),
(1016600, 1000874, 'CA', 'Lantz', 1, 'lantz', 44.98345000, -63.48199000),
(1016632, 1000874, 'CA', 'Lower Sackville', 1, 'lower-sackville', 44.77599000, -63.67865000),
(1016637, 1000874, 'CA', 'Lunenburg', 1, 'lunenburg', 44.37847000, -64.31658000),
(1016686, 1000874, 'CA', 'Middleton', 1, 'middleton', 44.94284000, -65.07022000),
(1016739, 1000874, 'CA', 'New Glasgow', 1, 'new-glasgow', 45.58344000, -62.64863000),
(1016791, 1000874, 'CA', 'Oxford', 1, 'oxford', 45.73345000, -63.86542000),
(1016799, 1000874, 'CA', 'Parrsboro', 1, 'parrsboro', 45.40567000, -64.32585000),
(1016818, 1000874, 'CA', 'Pictou', 1, 'pictou', 45.67875000, -62.70936000),
(1016819, 1000874, 'CA', 'Pictou County', 1, 'pictou-county', 45.50015000, -62.58193000),
(1016840, 1000874, 'CA', 'Port Hawkesbury', 1, 'port-hawkesbury', 45.61685000, -61.34853000),
(1016846, 1000874, 'CA', 'Port Williams', 1, 'port-williams', 45.10015000, -64.41546000),
(1016859, 1000874, 'CA', 'Princeville', 1, 'princeville', 45.76684000, -61.29853000),
(1017037, 1000874, 'CA', 'Shelburne', 1, 'shelburne', 43.76325000, -65.32355000),
(1017064, 1000874, 'CA', 'Springhill', 1, 'springhill', 45.65015000, -64.04873000),
(1017095, 1000874, 'CA', 'Sydney', 1, 'sydney', 46.13510000, -60.18310000),
(1017096, 1000874, 'CA', 'Sydney Mines', 1, 'sydney-mines', 46.23669000, -60.21767000),
(1017127, 1000874, 'CA', 'Truro', 1, 'truro', 45.36685000, -63.26538000),
(1017211, 1000874, 'CA', 'Windsor', 1, 'windsor', 44.98345000, -64.13204000),
(1017216, 1000874, 'CA', 'Wolfville', 1, 'wolfville', 45.08345000, -64.36546000),
(1017220, 1000874, 'CA', 'Yarmouth', 1, 'yarmouth', 43.83345000, -66.11557000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000876, 'CA', 'Nunavut', 1, 'nunavut');

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 
(1016315, 1000876, 'CA', 'Clyde River', 1, 'clyde-river', 70.47233000, -68.58987000),
(1016453, 1000876, 'CA', 'Gjoa Haven', 1, 'gjoa-haven', 68.62602000, -95.87836000),
(1016524, 1000876, 'CA', 'Iqaluit', 1, 'iqaluit', 63.74697000, -68.51727000),
(1016555, 1000876, 'CA', 'Kugluktuk', 1, 'kugluktuk', 67.82743000, -115.09649000),
(1016793, 1000876, 'CA', 'Pangnirtung', 1, 'pangnirtung', 66.14642000, -65.69996000),
(1016869, 1000876, 'CA', 'Rankin Inlet', 1, 'rankin-inlet', 62.80906000, -92.08534000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000866, 'CA', 'Ontario', 1, 'ontario');

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 
(1016152, 1000866, 'CA', 'Ajax', 1, 'ajax', 43.85012000, -79.03288000),
(1016157, 1000866, 'CA', 'Algoma', 1, 'algoma', 47.88364000, -84.42406000),
(1016158, 1000866, 'CA', 'Alliston', 1, 'alliston', 44.15011000, -79.86635000),
(1016162, 1000866, 'CA', 'Amherstburg', 1, 'amherstburg', 42.10009000, -83.09985000),
(1016163, 1000866, 'CA', 'Amigo Beach', 1, 'amigo-beach', 44.70011000, -79.39963000),
(1016166, 1000866, 'CA', 'Ancaster', 1, 'ancaster', 43.21806000, -79.98716000),
(1016168, 1000866, 'CA', 'Angus', 1, 'angus', 44.31681000, -79.88295000),
(1016174, 1000866, 'CA', 'Arnprior', 1, 'arnprior', 45.43341000, -76.34939000),
(1016179, 1000866, 'CA', 'Atikokan', 1, 'atikokan', 48.75667000, -91.62409000),
(1016180, 1000866, 'CA', 'Attawapiskat', 1, 'attawapiskat', 52.92774000, -82.41669000),
(1016181, 1000866, 'CA', 'Aurora', 1, 'aurora', 44.00011000, -79.46632000),
(1016182, 1000866, 'CA', 'Aylmer', 1, 'aylmer', 42.76679000, -80.98302000),
(1016183, 1000866, 'CA', 'Azilda', 1, 'azilda', 46.55008000, -81.09975000),
(1016188, 1000866, 'CA', 'Ballantrae', 1, 'ballantrae', 44.03342000, -79.29960000),
(1016189, 1000866, 'CA', 'Bancroft', 1, 'bancroft', 45.05752000, -77.85702000),
(1016193, 1000866, 'CA', 'Barrie', 1, 'barrie', 44.40011000, -79.66634000),
(1016197, 1000866, 'CA', 'Bath', 1, 'bath', 44.18342000, -76.78273000),
(1016211, 1000866, 'CA', 'Belleville', 1, 'belleville', 44.16682000, -77.38277000),
(1016212, 1000866, 'CA', 'Bells Corners', 1, 'bells-corners', 45.31588000, -75.83012000),
(1016213, 1000866, 'CA', 'Belmont', 1, 'belmont', 42.88339000, -81.08303000),
(1016218, 1000866, 'CA', 'Binbrook', 1, 'binbrook', 43.12135000, -79.81104000),
(1016222, 1000866, 'CA', 'Bluewater', 1, 'bluewater', 43.46679000, -81.59977000),
(1016233, 1000866, 'CA', 'Bourget', 1, 'bourget', 45.43340000, -75.14930000),
(1016236, 1000866, 'CA', 'Bracebridge', 1, 'bracebridge', 45.03341000, -79.31633000),
(1016237, 1000866, 'CA', 'Brampton', 1, 'brampton', 43.68341000, -79.76633000),
(1016239, 1000866, 'CA', 'Brant', 1, 'brant', 43.13340000, -80.34967000),
(1016240, 1000866, 'CA', 'Brantford', 1, 'brantford', 43.13340000, -80.26636000),
(1016243, 1000866, 'CA', 'Brockville', 1, 'brockville', 44.59132000, -75.68705000),
(1016248, 1000866, 'CA', 'Brussels', 1, 'brussels', 43.73339000, -81.24975000),
(1016250, 1000866, 'CA', 'Burford', 1, 'burford', 43.10292000, -80.42869000),
(1016252, 1000866, 'CA', 'Burlington', 1, 'burlington', 43.38621000, -79.83713000),
(1016261, 1000866, 'CA', 'Cambridge', 1, 'cambridge', 43.36010000, -80.31269000),
(1016262, 1000866, 'CA', 'Camlachie', 1, 'camlachie', 43.03596000, -82.16160000),
(1016274, 1000866, 'CA', 'Capreol', 1, 'capreol', 46.70626000, -80.92109000),
(1016280, 1000866, 'CA', 'Carleton Place', 1, 'carleton-place', 45.13341000, -76.14938000),
(1016285, 1000866, 'CA', 'Casselman', 1, 'casselman', 45.31680000, -75.08260000),
(1016299, 1000866, 'CA', 'Chatham', 1, 'chatham', 42.41224000, -82.18494000),
(1016300, 1000866, 'CA', 'Chatham-Kent', 1, 'chatham-kent', 42.40009000, -82.18310000),
(1016312, 1000866, 'CA', 'Clarence-Rockland', 1, 'clarence-rockland', 45.55010000, -75.29101000),
(1016319, 1000866, 'CA', 'Cobourg', 1, 'cobourg', 43.95977000, -78.16515000),
(1016321, 1000866, 'CA', 'Cochrane District', 1, 'cochrane-district', 50.00022000, -82.99979000),
(1016325, 1000866, 'CA', 'Collingwood', 1, 'collingwood', 44.48340000, -80.21638000),
(1016328, 1000866, 'CA', 'Concord', 1, 'concord', 43.80011000, -79.48291000),
(1016329, 1000866, 'CA', 'Constance Bay', 1, 'constance-bay', 45.50011000, -76.08267000),
(1016333, 1000866, 'CA', 'Cookstown', 1, 'cookstown', 44.18341000, -79.69964000),
(1016337, 1000866, 'CA', 'Cornwall', 1, 'cornwall', 45.01809000, -74.72815000),
(1016339, 1000866, 'CA', 'Corunna', 1, 'corunna', 42.88338000, -82.43313000),
(1016361, 1000866, 'CA', 'Deep River', 1, 'deep-river', 46.10012000, -77.49949000),
(1016363, 1000866, 'CA', 'Delaware', 1, 'delaware', 42.91679000, -81.41646000),
(1016369, 1000866, 'CA', 'Deseronto', 1, 'deseronto', 44.20012000, -77.04944000),
(1016380, 1000866, 'CA', 'Dorchester', 1, 'dorchester', 42.98339000, -81.06643000),
(1016382, 1000866, 'CA', 'Dowling', 1, 'dowling', 46.59111000, -81.33917000),
(1016385, 1000866, 'CA', 'Dryden', 1, 'dryden', 49.78334000, -92.75032000),
(1016389, 1000866, 'CA', 'Durham', 1, 'durham', 44.20012000, -78.99957000),
(1016390, 1000866, 'CA', 'Ear Falls', 1, 'ear-falls', 50.63955000, -93.23526000),
(1016393, 1000866, 'CA', 'East Gwillimbury', 1, 'east-gwillimbury', 44.10087000, -79.43785000),
(1016395, 1000866, 'CA', 'East York', 1, 'east-york', 43.69053000, -79.32794000),
(1016401, 1000866, 'CA', 'Elliot Lake', 1, 'elliot-lake', 46.38336000, -82.63315000),
(1016403, 1000866, 'CA', 'Elmvale', 1, 'elmvale', 44.58340000, -79.86636000),
(1016405, 1000866, 'CA', 'Englehart', 1, 'englehart', 47.81686000, -79.86640000),
(1016408, 1000866, 'CA', 'Espanola', 1, 'espanola', 46.25837000, -81.76649000),
(1016409, 1000866, 'CA', 'Essex', 1, 'essex', 42.17509000, -82.82483000),
(1016412, 1000866, 'CA', 'Etobicoke', 1, 'etobicoke', 43.65421000, -79.56711000),
(1016427, 1000866, 'CA', 'Fort Erie', 1, 'fort-erie', 42.90012000, -78.93286000),
(1016428, 1000866, 'CA', 'Fort Frances', 1, 'fort-frances', 48.61667000, -93.40030000),
(1016446, 1000866, 'CA', 'Gananoque', 1, 'gananoque', 44.33342000, -76.16607000),
(1016455, 1000866, 'CA', 'Glencoe', 1, 'glencoe', 42.75009000, -81.71648000),
(1016457, 1000866, 'CA', 'Goderich', 1, 'goderich', 43.74171000, -81.71339000),
(1016459, 1000866, 'CA', 'Golden', 1, 'golden', 51.05917000, -93.73568000),
(1016470, 1000866, 'CA', 'Gravenhurst', 1, 'gravenhurst', 44.91681000, -79.36633000),
(1016472, 1000866, 'CA', 'Greater Napanee', 1, 'greater-napanee', 44.25012000, -76.94944000),
(1016473, 1000866, 'CA', 'Greater Sudbury', 1, 'greater-sudbury', 46.49000000, -80.99001000),
(1016474, 1000866, 'CA', 'Greenstone', 1, 'greenstone', 49.73343000, -87.16668000),
(1016478, 1000866, 'CA', 'Guelph', 1, 'guelph', 43.54594000, -80.25599000),
(1016480, 1000866, 'CA', 'Haldimand County', 1, 'haldimand-county', 42.98341000, -79.86633000),
(1016481, 1000866, 'CA', 'Haliburton Village', 1, 'haliburton-village', 45.05154000, -78.52245000),
(1016483, 1000866, 'CA', 'Halton', 1, 'halton', 43.50011000, -79.88294000),
(1016484, 1000866, 'CA', 'Hamilton', 1, 'hamilton', 43.25011000, -79.84963000),
(1016489, 1000866, 'CA', 'Hanover', 1, 'hanover', 44.15009000, -81.03303000),
(1016494, 1000866, 'CA', 'Harriston', 1, 'harriston', 43.90009000, -80.88302000),
(1016497, 1000866, 'CA', 'Hawkesbury', 1, 'hawkesbury', 45.60009000, -74.61595000),
(1016501, 1000866, 'CA', 'Hearst', 1, 'hearst', 49.68351000, -83.66654000),
(1016509, 1000866, 'CA', 'Hornepayne', 1, 'hornepayne', 49.21451000, -84.77617000),
(1016515, 1000866, 'CA', 'Huntsville', 1, 'huntsville', 45.33341000, -79.21632000),
(1016516, 1000866, 'CA', 'Huron East', 1, 'huron-east', 43.61679000, -81.29975000),
(1016520, 1000866, 'CA', 'Ingersoll', 1, 'ingersoll', 43.03339000, -80.88302000),
(1016521, 1000866, 'CA', 'Innisfil', 1, 'innisfil', 44.30011000, -79.64964000),
(1016525, 1000866, 'CA', 'Iroquois Falls', 1, 'iroquois-falls', 48.76688000, -80.68307000),
(1016527, 1000866, 'CA', 'Jarvis', 1, 'jarvis', 42.88341000, -80.09965000),
(1016533, 1000866, 'CA', 'Kanata', 1, 'kanata', 45.30010000, -75.91606000),
(1016534, 1000866, 'CA', 'Kapuskasing', 1, 'kapuskasing', 49.41694000, -82.43308000),
(1016535, 1000866, 'CA', 'Kawartha Lakes', 1, 'kawartha-lakes', 44.58342000, -78.83288000),
(1016537, 1000866, 'CA', 'Kenora', 1, 'kenora', 49.76741000, -94.48985000),
(1016541, 1000866, 'CA', 'Keswick', 1, 'keswick', 44.25011000, -79.46632000),
(1016546, 1000866, 'CA', 'Kincardine', 1, 'kincardine', 44.18339000, -81.63307000),
(1016548, 1000866, 'CA', 'King', 1, 'king', 43.96514000, -79.59011000),
(1016550, 1000866, 'CA', 'Kingston', 1, 'kingston', 44.22976000, -76.48098000),
(1016552, 1000866, 'CA', 'Kirkland Lake', 1, 'kirkland-lake', 48.14461000, -80.03767000),
(1016553, 1000866, 'CA', 'Kitchener', 1, 'kitchener', 43.42537000, -80.51120000),
(1016560, 1000866, 'CA', 'L\'Orignal', 1, 'l-orignal', 45.61980000, -74.69150000),
(1016590, 1000866, 'CA', 'Lakefield', 1, 'lakefield', 44.43342000, -78.26623000),
(1016591, 1000866, 'CA', 'Lambton Shores', 1, 'lambton-shores', 43.16678000, -81.93309000),
(1016601, 1000866, 'CA', 'Lappe', 1, 'lappe', 48.56680000, -89.35013000),
(1016607, 1000866, 'CA', 'Leamington', 1, 'leamington', 42.05009000, -82.59981000),
(1016617, 1000866, 'CA', 'Limoges', 1, 'limoges', 45.33340000, -75.24931000),
(1016619, 1000866, 'CA', 'Lindsay', 1, 'lindsay', 44.35012000, -78.73286000),
(1016622, 1000866, 'CA', 'Listowel', 1, 'listowel', 43.73340000, -80.94973000),
(1016623, 1000866, 'CA', 'Little Current', 1, 'little-current', 45.97927000, -81.92480000),
(1016624, 1000866, 'CA', 'Lively', 1, 'lively', 46.43338000, -81.14975000),
(1016627, 1000866, 'CA', 'London', 1, 'london', 42.98339000, -81.23304000),
(1016633, 1000866, 'CA', 'Lucan', 1, 'lucan', 43.18339000, -81.39976000),
(1016643, 1000866, 'CA', 'Madoc', 1, 'madoc', 44.50842000, -77.47448000),
(1016650, 1000866, 'CA', 'Manitoulin District', 1, 'manitoulin-district', 45.75007000, -82.49985000),
(1016651, 1000866, 'CA', 'Manitouwadge', 1, 'manitouwadge', 49.12152000, -85.84030000),
(1016658, 1000866, 'CA', 'Marathon', 1, 'marathon', 48.75010000, -86.43322000),
(1016661, 1000866, 'CA', 'Markdale', 1, 'markdale', 44.31680000, -80.64971000),
(1016662, 1000866, 'CA', 'Markham', 1, 'markham', 43.86682000, -79.26630000),
(1016669, 1000866, 'CA', 'Mattawa', 1, 'mattawa', 46.31681000, -78.69957000),
(1016674, 1000866, 'CA', 'Meaford', 1, 'meaford', 44.60725000, -80.61081000),
(1016683, 1000866, 'CA', 'Metcalfe', 1, 'metcalfe', 45.23340000, -75.46603000),
(1016687, 1000866, 'CA', 'Midland', 1, 'midland', 44.75010000, -79.88296000),
(1016688, 1000866, 'CA', 'Mildmay', 1, 'mildmay', 44.05009000, -81.11644000),
(1016690, 1000866, 'CA', 'Millbrook', 1, 'millbrook', 44.15012000, -78.44954000),
(1016692, 1000866, 'CA', 'Milton', 1, 'milton', 43.51681000, -79.88294000),
(1016697, 1000866, 'CA', 'Mississauga', 1, 'mississauga', 43.57890000, -79.65830000),
(1016698, 1000866, 'CA', 'Mississauga Beach', 1, 'mississauga-beach', 43.26682000, -79.08287000),
(1016712, 1000866, 'CA', 'Moose Factory', 1, 'moose-factory', 51.26689000, -80.61624000),
(1016716, 1000866, 'CA', 'Moosonee', 1, 'moosonee', 51.27931000, -80.63450000),
(1016721, 1000866, 'CA', 'Morrisburg', 1, 'morrisburg', 44.90010000, -75.18261000),
(1016722, 1000866, 'CA', 'Mount Albert', 1, 'mount-albert', 44.13341000, -79.31630000),
(1016723, 1000866, 'CA', 'Mount Brydges', 1, 'mount-brydges', 42.90009000, -81.48306000),
(1016730, 1000866, 'CA', 'Napanee', 1, 'napanee', 44.25012000, -76.94944000),
(1016731, 1000866, 'CA', 'Napanee Downtown', 1, 'napanee-downtown', 44.24832000, -76.95069000),
(1016733, 1000866, 'CA', 'Neebing', 1, 'neebing', 48.16680000, -89.41683000),
(1016736, 1000866, 'CA', 'Nepean', 1, 'nepean', 45.35215000, -75.73975000),
(1016740, 1000866, 'CA', 'New Hamburg', 1, 'new-hamburg', 43.38339000, -80.69970000),
(1016744, 1000866, 'CA', 'Newmarket', 1, 'newmarket', 44.05011000, -79.46631000),
(1016745, 1000866, 'CA', 'Niagara Falls', 1, 'niagara-falls', 43.10012000, -79.06627000),
(1016748, 1000866, 'CA', 'Nipissing District', 1, 'nipissing-district', 46.00010000, -78.99959000),
(1016752, 1000866, 'CA', 'Norfolk County', 1, 'norfolk-county', 42.83340000, -80.38297000),
(1016756, 1000866, 'CA', 'North Bay', 1, 'north-bay', 46.31680000, -79.46633000),
(1016759, 1000866, 'CA', 'North Perth', 1, 'north-perth', 43.72510000, -80.96723000),
(1016762, 1000866, 'CA', 'North York', 1, 'north-york', 43.76681000, -79.41630000),
(1016763, 1000866, 'CA', 'Norwood', 1, 'norwood', 44.38342000, -77.98281000),
(1016770, 1000866, 'CA', 'Oakville', 1, 'oakville', 43.45011000, -79.68292000),
(1016777, 1000866, 'CA', 'Omemee', 1, 'omemee', 44.29897000, -78.55989000),
(1016778, 1000866, 'CA', 'Orangeville', 1, 'orangeville', 43.91680000, -80.09967000),
(1016779, 1000866, 'CA', 'Orillia', 1, 'orillia', 44.60868000, -79.42068000),
(1016782, 1000866, 'CA', 'Osgoode', 1, 'osgoode', 45.14887000, -75.59778000),
(1016783, 1000866, 'CA', 'Oshawa', 1, 'oshawa', 43.90012000, -78.84957000),
(1016785, 1000866, 'CA', 'Ottawa', 1, 'ottawa', 45.41117000, -75.69812000),
(1016789, 1000866, 'CA', 'Owen Sound', 1, 'owen-sound', 44.56717000, -80.94349000),
(1016792, 1000866, 'CA', 'Paisley', 1, 'paisley', 44.30641000, -81.27265000),
(1016796, 1000866, 'CA', 'Paris', 1, 'paris', 43.20000000, -80.38333000),
(1016797, 1000866, 'CA', 'Parkhill', 1, 'parkhill', 43.15993000, -81.68464000),
(1016800, 1000866, 'CA', 'Parry Sound', 1, 'parry-sound', 45.34732000, -80.03527000),
(1016801, 1000866, 'CA', 'Parry Sound District', 1, 'parry-sound-district', 45.75011000, -79.83297000),
(1016806, 1000866, 'CA', 'Peel', 1, 'peel', 43.75011000, -79.78293000),
(1016809, 1000866, 'CA', 'Pembroke', 1, 'pembroke', 45.81681000, -77.11616000),
(1016812, 1000866, 'CA', 'Perth', 1, 'perth', 44.90011000, -76.24939000),
(1016813, 1000866, 'CA', 'Petawawa', 1, 'petawawa', 45.89452000, -77.28007000),
(1016814, 1000866, 'CA', 'Peterborough', 1, 'peterborough', 44.30012000, -78.31623000),
(1016815, 1000866, 'CA', 'Petrolia', 1, 'petrolia', 42.86678000, -82.14981000),
(1016816, 1000866, 'CA', 'Pickering', 1, 'pickering', 43.90012000, -79.13289000),
(1016817, 1000866, 'CA', 'Picton', 1, 'picton', 44.00012000, -77.13275000),
(1016827, 1000866, 'CA', 'Plantagenet', 1, 'plantagenet', 45.53260000, -74.99369000),
(1016828, 1000866, 'CA', 'Plattsville', 1, 'plattsville', 43.30010000, -80.61639000),
(1016838, 1000866, 'CA', 'Port Colborne', 1, 'port-colborne', 42.90012000, -79.23288000),
(1016841, 1000866, 'CA', 'Port Hope', 1, 'port-hope', 44.01682000, -78.39953000),
(1016844, 1000866, 'CA', 'Port Rowan', 1, 'port-rowan', 42.61680000, -80.46638000),
(1016845, 1000866, 'CA', 'Port Stanley', 1, 'port-stanley', 42.66679000, -81.21644000),
(1016850, 1000866, 'CA', 'Powassan', 1, 'powassan', 46.03340000, -79.34961000),
(1016853, 1000866, 'CA', 'Prescott', 1, 'prescott', 44.71681000, -75.51604000),
(1016855, 1000866, 'CA', 'Prince Edward', 1, 'prince-edward', 44.00012000, -77.24946000),
(1016864, 1000866, 'CA', 'Queenswood Heights', 1, 'queenswood-heights', 45.47083000, -75.50556000),
(1016866, 1000866, 'CA', 'Quinte West', 1, 'quinte-west', 44.18342000, -77.56618000),
(1016868, 1000866, 'CA', 'Rainy River District', 1, 'rainy-river-district', 48.49981000, -92.50031000),
(1016872, 1000866, 'CA', 'Rayside-Balfour', 1, 'rayside-balfour', 46.60873000, -81.20763000),
(1016874, 1000866, 'CA', 'Red Lake', 1, 'red-lake', 51.01678000, -93.82736000),
(1016879, 1000866, 'CA', 'Regional Municipality of Waterloo', 1, 'regional-municipality-of-waterloo', 43.50010000, -80.49969000),
(1016880, 1000866, 'CA', 'Renfrew', 1, 'renfrew', 45.46681000, -76.68272000),
(1016887, 1000866, 'CA', 'Richmond', 1, 'richmond', 45.18340000, -75.83266000),
(1016888, 1000866, 'CA', 'Richmond Hill', 1, 'richmond-hill', 43.87111000, -79.43725000),
(1016890, 1000866, 'CA', 'Ridgetown', 1, 'ridgetown', 42.43339000, -81.89978000),
(1016900, 1000866, 'CA', 'Rockwood', 1, 'rockwood', 43.61899000, -80.14441000),
(1016909, 1000866, 'CA', 'Russell', 1, 'russell', 45.25010000, -75.36602000),
(1017020, 1000866, 'CA', 'Sarnia', 1, 'sarnia', 42.97866000, -82.40407000),
(1017022, 1000866, 'CA', 'Sault Ste. Marie', 1, 'sault-ste-marie', 46.51677000, -84.33325000),
(1017023, 1000866, 'CA', 'Scarborough', 1, 'scarborough', 43.77223000, -79.25666000),
(1017024, 1000866, 'CA', 'Seaforth', 1, 'seaforth', 43.55009000, -81.39976000),
(1017036, 1000866, 'CA', 'Shelburne', 1, 'shelburne', 44.07870000, -80.20408000),
(1017045, 1000866, 'CA', 'Simcoe', 1, 'simcoe', 42.83340000, -80.29967000),
(1017046, 1000866, 'CA', 'Sioux Lookout', 1, 'sioux-lookout', 50.06676000, -91.98358000),
(1017048, 1000866, 'CA', 'Skatepark', 1, 'skatepark', 44.25122000, -76.94424000),
(1017051, 1000866, 'CA', 'Smiths Falls', 1, 'smiths-falls', 44.90452000, -76.02333000),
(1017057, 1000866, 'CA', 'South Huron', 1, 'south-huron', 43.31679000, -81.51647000),
(1017059, 1000866, 'CA', 'South River', 1, 'south-river', 45.83340000, -79.38293000),
(1017070, 1000866, 'CA', 'St. Catharines', 1, 'st-catharines', 43.17126000, -79.24267000),
(1017071, 1000866, 'CA', 'St. George', 1, 'st-george', 43.24495000, -80.25144000),
(1017073, 1000866, 'CA', 'St. Thomas', 1, 'st-thomas', 42.77361000, -81.18038000),
(1017079, 1000866, 'CA', 'Stirling', 1, 'stirling', 44.30012000, -77.54948000),
(1017081, 1000866, 'CA', 'Stoney Point', 1, 'stoney-point', 44.26681000, -79.53292000),
(1017083, 1000866, 'CA', 'Stratford', 1, 'stratford', 43.36679000, -80.94972000),
(1017085, 1000866, 'CA', 'Sudbury', 1, 'sudbury', 47.16679000, -81.99980000),
(1017100, 1000866, 'CA', 'Tavistock', 1, 'tavistock', 43.31679000, -80.83302000),
(1017101, 1000866, 'CA', 'Temiskaming Shores', 1, 'temiskaming-shores', 47.49376000, -79.71529000),
(1017106, 1000866, 'CA', 'Thessalon', 1, 'thessalon', 46.25006000, -83.56660000),
(1017109, 1000866, 'CA', 'Thorold', 1, 'thorold', 43.11682000, -79.19958000),
(1017111, 1000866, 'CA', 'Thunder Bay', 1, 'thunder-bay', 48.38202000, -89.25018000),
(1017112, 1000866, 'CA', 'Thunder Bay District', 1, 'thunder-bay-district', 49.50011000, -88.50004000),
(1017114, 1000866, 'CA', 'Timiskaming District', 1, 'timiskaming-district', 47.75016000, -80.33303000),
(1017115, 1000866, 'CA', 'Timmins', 1, 'timmins', 48.46686000, -81.33312000),
(1017117, 1000866, 'CA', 'Tobermory', 1, 'tobermory', 45.25007000, -81.66647000),
(1017121, 1000866, 'CA', 'Toronto', 1, 'toronto', 43.70011000, -79.41630000),
(1017122, 1000866, 'CA', 'Toronto county', 1, 'toronto-county', 43.69655000, -79.42909000),
(1017123, 1000866, 'CA', 'Tottenham', 1, 'tottenham', 44.02437000, -79.80553000),
(1017130, 1000866, 'CA', 'Tweed', 1, 'tweed', 44.47512000, -77.31616000),
(1017136, 1000866, 'CA', 'Uxbridge', 1, 'uxbridge', 44.10012000, -79.11628000),
(1017142, 1000866, 'CA', 'Valley East', 1, 'valley-east', 46.66773000, -81.00028000),
(1017147, 1000866, 'CA', 'Vanier', 1, 'vanier', 45.43990000, -75.66498000),
(1017150, 1000866, 'CA', 'Vaughan', 1, 'vaughan', 43.83610000, -79.49827000),
(1017160, 1000866, 'CA', 'Vineland', 1, 'vineland', 43.15012000, -79.39960000),
(1017162, 1000866, 'CA', 'Virgil', 1, 'virgil', 43.21682000, -79.13288000),
(1017169, 1000866, 'CA', 'Walpole Island', 1, 'walpole-island', 42.61520000, -82.51398000),
(1017172, 1000866, 'CA', 'Wasaga Beach', 1, 'wasaga-beach', 44.51680000, -80.01637000),
(1017175, 1000866, 'CA', 'Waterford', 1, 'waterford', 42.93340000, -80.28296000),
(1017176, 1000866, 'CA', 'Waterloo', 1, 'waterloo', 43.46680000, -80.51639000),
(1017178, 1000866, 'CA', 'Watford', 1, 'watford', 42.95008000, -81.88309000),
(1017181, 1000866, 'CA', 'Wawa', 1, 'wawa', 47.98877000, -84.77411000),
(1017184, 1000866, 'CA', 'Welland', 1, 'welland', 42.98342000, -79.24958000),
(1017185, 1000866, 'CA', 'Wellesley', 1, 'wellesley', 43.47691000, -80.76209000),
(1017188, 1000866, 'CA', 'Wendover', 1, 'wendover', 45.57275000, -75.12757000),
(1017191, 1000866, 'CA', 'West Lorne', 1, 'west-lorne', 42.60009000, -81.59976000),
(1017208, 1000866, 'CA', 'Willowdale', 1, 'willowdale', 43.76672000, -79.39909000),
(1017209, 1000866, 'CA', 'Winchester', 1, 'winchester', 45.08340000, -75.34933000),
(1017212, 1000866, 'CA', 'Windsor', 1, 'windsor', 42.30008000, -83.01654000),
(1017213, 1000866, 'CA', 'Wingham', 1, 'wingham', 43.88793000, -81.31145000),
(1017217, 1000866, 'CA', 'Woodstock', 1, 'woodstock', 43.13339000, -80.74970000),
(1017222, 1000866, 'CA', 'York', 1, 'york', 44.00011000, -79.46632000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000871, 'CA', 'Prince Edward Island', 1, 'prince-edward-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 
(1016154, 1000871, 'CA', 'Alberton', 1, 'alberton', 46.81685000, -64.06542000),
(1016210, 1000871, 'CA', 'Belfast', 1, 'belfast', 46.08341000, -62.88197000),
(1016297, 1000871, 'CA', 'Charlottetown', 1, 'charlottetown', 46.23899000, -63.13414000),
(1016338, 1000871, 'CA', 'Cornwall', 1, 'cornwall', 46.22652000, -63.21809000),
(1016417, 1000871, 'CA', 'Fallingbrook', 1, 'fallingbrook', 45.47558000, -75.48401000),
(1016538, 1000871, 'CA', 'Kensington', 1, 'kensington', 46.43343000, -63.64871000),
(1016707, 1000871, 'CA', 'Montague', 1, 'montague', 46.16681000, -62.64866000),
(1017055, 1000871, 'CA', 'Souris', 1, 'souris', 46.35010000, -62.24862000),
(1017087, 1000871, 'CA', 'Summerside', 1, 'summerside', 46.39593000, -63.78762000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000873, 'CA', 'Quebec', 1, 'quebec');

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 
(1016147, 1000873, 'CA', 'Abitibi-Témiscamingue', 1, 'abitibi-temiscamingue', 48.10018000, -77.78280000),
(1016148, 1000873, 'CA', 'Acton Vale', 1, 'acton-vale', 45.65007000, -72.56582000),
(1016149, 1000873, 'CA', 'Adstock', 1, 'adstock', 46.05007000, -71.08235000),
(1016153, 1000873, 'CA', 'Albanel', 1, 'albanel', 48.88324000, -72.44867000),
(1016159, 1000873, 'CA', 'Alma', 1, 'alma', 48.55009000, -71.64910000),
(1016164, 1000873, 'CA', 'Amos', 1, 'amos', 48.56688000, -78.11624000),
(1016165, 1000873, 'CA', 'Amqui', 1, 'amqui', 48.46382000, -67.43134000),
(1016167, 1000873, 'CA', 'Ange-Gardien', 1, 'ange-gardien', 45.35008000, -72.93244000),
(1016175, 1000873, 'CA', 'Asbestos', 1, 'asbestos', 45.76678000, -71.93240000),
(1016185, 1000873, 'CA', 'Baie-Comeau', 1, 'baie-comeau', 49.21679000, -68.14894000),
(1016186, 1000873, 'CA', 'Baie-D\'Urfé', 1, 'baie-d-urfe', 45.41397000, -73.91586000),
(1016187, 1000873, 'CA', 'Baie-Saint-Paul', 1, 'baie-saint-paul', 47.44109000, -70.49858000),
(1016191, 1000873, 'CA', 'Barraute', 1, 'barraute', 48.43349000, -77.63279000),
(1016195, 1000873, 'CA', 'Bas-Saint-Laurent', 1, 'bas-saint-laurent', 48.05030000, -68.02266000),
(1016201, 1000873, 'CA', 'Beaconsfield', 1, 'beaconsfield', 45.43341000, -73.86586000),
(1016202, 1000873, 'CA', 'Beauceville', 1, 'beauceville', 46.21785000, -70.77873000),
(1016203, 1000873, 'CA', 'Beauharnois', 1, 'beauharnois', 45.31341000, -73.87250000),
(1016205, 1000873, 'CA', 'Beaupré', 1, 'beaupre', 47.04428000, -70.89529000),
(1016255, 1000873, 'CA', 'Bécancour', 1, 'becancour', 46.34106000, -72.43224000),
(1016208, 1000873, 'CA', 'Bedford', 1, 'bedford', 45.11678000, -72.98244000),
(1016214, 1000873, 'CA', 'Beloeil', 1, 'beloeil', 45.56839000, -73.20568000),
(1016215, 1000873, 'CA', 'Berthierville', 1, 'berthierville', 46.08336000, -73.18245000),
(1016221, 1000873, 'CA', 'Blainville', 1, 'blainville', 45.66678000, -73.88249000),
(1016223, 1000873, 'CA', 'Bois-des-Filion', 1, 'bois-des-filion', 45.66678000, -73.74918000),
(1016224, 1000873, 'CA', 'Boisbriand', 1, 'boisbriand', 45.61678000, -73.83249000),
(1016227, 1000873, 'CA', 'Bonaventure', 1, 'bonaventure', 48.04573000, -65.49259000),
(1016231, 1000873, 'CA', 'Boucherville', 1, 'boucherville', 45.59104000, -73.43605000),
(1016241, 1000873, 'CA', 'Breakeyville', 1, 'breakeyville', 46.68037000, -71.22327000),
(1016244, 1000873, 'CA', 'Bromont', 1, 'bromont', 45.31678000, -72.64912000),
(1016246, 1000873, 'CA', 'Brossard', 1, 'brossard', 45.45008000, -73.46583000),
(1016247, 1000873, 'CA', 'Brownsburg-Chatham', 1, 'brownsburg-chatham', 45.68342000, -74.41590000),
(1016249, 1000873, 'CA', 'Buckingham', 1, 'buckingham', 45.58563000, -75.42080000),
(1016256, 1000873, 'CA', 'Cabano', 1, 'cabano', 47.68065000, -68.87810000),
(1016258, 1000873, 'CA', 'Cacouna', 1, 'cacouna', 47.91657000, -69.50054000),
(1016266, 1000873, 'CA', 'Candiac', 1, 'candiac', 45.38338000, -73.51587000),
(1016269, 1000873, 'CA', 'Cantley', 1, 'cantley', 45.56680000, -75.78265000),
(1016270, 1000873, 'CA', 'Cap-Chat', 1, 'cap-chat', 49.10009000, -66.68212000),
(1016271, 1000873, 'CA', 'Cap-Santé', 1, 'cap-sante', 46.67159000, -71.78812000),
(1016273, 1000873, 'CA', 'Capitale-Nationale', 1, 'capitale-nationale', 47.37600000, -71.12337000),
(1016278, 1000873, 'CA', 'Carignan', 1, 'carignan', 45.45008000, -73.29916000),
(1016279, 1000873, 'CA', 'Carleton', 1, 'carleton', 48.09838000, -66.10036000),
(1016281, 1000873, 'CA', 'Carleton-sur-Mer', 1, 'carleton-sur-mer', 48.10749000, -66.12800000),
(1016290, 1000873, 'CA', 'Centre-du-Québec', 1, 'centre-du-quebec', 46.01985000, -71.98242000),
(1016291, 1000873, 'CA', 'Chambly', 1, 'chambly', 45.45008000, -73.28246000),
(1016292, 1000873, 'CA', 'Chambord', 1, 'chambord', 48.43339000, -72.06583000),
(1016293, 1000873, 'CA', 'Chandler', 1, 'chandler', 48.34935000, -64.67926000),
(1016295, 1000873, 'CA', 'Chapais', 1, 'chapais', 49.78344000, -74.84919000),
(1016296, 1000873, 'CA', 'Charlemagne', 1, 'charlemagne', 45.71678000, -73.48247000),
(1016310, 1000873, 'CA', 'Château-Richer', 1, 'chateau-richer', 46.96031000, -71.03219000),
(1016311, 1000873, 'CA', 'Châteauguay', 1, 'chateauguay', 45.38338000, -73.74919000),
(1016301, 1000873, 'CA', 'Chaudière-Appalaches', 1, 'chaudiere-appalaches', 46.55500000, -70.83080000),
(1016303, 1000873, 'CA', 'Chertsey', 1, 'chertsey', 46.07109000, -73.89095000),
(1016307, 1000873, 'CA', 'Chibougamau', 1, 'chibougamau', 49.91684000, -74.36586000),
(1016309, 1000873, 'CA', 'Chute-aux-Outardes', 1, 'chute-aux-outardes', 49.11679000, -68.39896000),
(1016318, 1000873, 'CA', 'Coaticook', 1, 'coaticook', 45.13339000, -71.79907000),
(1016330, 1000873, 'CA', 'Contrecoeur', 1, 'contrecoeur', 45.85008000, -73.23245000),
(1016331, 1000873, 'CA', 'Cookshire', 1, 'cookshire', 45.41536000, -71.62962000),
(1016332, 1000873, 'CA', 'Cookshire-Eaton', 1, 'cookshire-eaton', 45.41675000, -71.63240000),
(1016351, 1000873, 'CA', 'Côte-Nord', 1, 'cote-nord', 50.86683000, -65.81541000),
(1016352, 1000873, 'CA', 'Côte-Saint-Luc', 1, 'cote-saint-luc', 45.46536000, -73.66585000),
(1016340, 1000873, 'CA', 'Coteau-du-Lac', 1, 'coteau-du-lac', 45.30008000, -74.18253000),
(1016343, 1000873, 'CA', 'Cowansville', 1, 'cowansville', 45.20008000, -72.74913000),
(1016345, 1000873, 'CA', 'Crabtree', 1, 'crabtree', 45.96677000, -73.46586000),
(1016354, 1000873, 'CA', 'Danville', 1, 'danville', 45.78337000, -72.01580000),
(1016357, 1000873, 'CA', 'Daveluyville', 1, 'daveluyville', 46.20006000, -72.13239000),
(1016365, 1000873, 'CA', 'Delson', 1, 'delson', 45.36678000, -73.54917000),
(1016370, 1000873, 'CA', 'Deux-Montagnes', 1, 'deux-montagnes', 45.53455000, -73.90168000),
(1016376, 1000873, 'CA', 'Disraeli', 1, 'disraeli', 45.90007000, -71.34907000),
(1016377, 1000873, 'CA', 'Dolbeau-Mistassini', 1, 'dolbeau-mistassini', 48.87860000, -72.23142000),
(1016378, 1000873, 'CA', 'Dollard-Des Ormeaux', 1, 'dollard-des-ormeaux', 45.49452000, -73.82419000),
(1016379, 1000873, 'CA', 'Donnacona', 1, 'donnacona', 46.68042000, -71.72390000),
(1016381, 1000873, 'CA', 'Dorval', 1, 'dorval', 45.44730000, -73.75335000),
(1016384, 1000873, 'CA', 'Drummondville', 1, 'drummondville', 45.88336000, -72.48241000),
(1016388, 1000873, 'CA', 'Dunham', 1, 'dunham', 45.13338000, -72.79913000),
(1016391, 1000873, 'CA', 'East Angus', 1, 'east-angus', 45.48338000, -71.66577000),
(1016392, 1000873, 'CA', 'East Broughton', 1, 'east-broughton', 46.21358000, -71.07674000),
(1016418, 1000873, 'CA', 'Farnham', 1, 'farnham', 45.28338000, -72.98244000),
(1016419, 1000873, 'CA', 'Ferme-Neuve', 1, 'ferme-neuve', 46.70011000, -75.44929000),
(1016420, 1000873, 'CA', 'Fermont', 1, 'fermont', 52.78345000, -67.08204000),
(1016426, 1000873, 'CA', 'Forestville', 1, 'forestville', 48.73808000, -69.08478000),
(1016436, 1000873, 'CA', 'Fort-Coulonge', 1, 'fort-coulonge', 45.85011000, -76.73272000),
(1016437, 1000873, 'CA', 'Fossambault-sur-le-Lac', 1, 'fossambault-sur-le-lac', 46.87662000, -71.61541000),
(1016439, 1000873, 'CA', 'Franklin', 1, 'franklin', 45.03338000, -73.91591000),
(1016447, 1000873, 'CA', 'Gaspé', 1, 'gaspe', 48.83341000, -64.48194000),
(1016448, 1000873, 'CA', 'Gaspésie-Îles-de-la-Madeleine', 1, 'gaspesie-iles-de-la-madeleine', 48.87555000, -65.40710000),
(1016449, 1000873, 'CA', 'Gatineau', 1, 'gatineau', 45.47723000, -75.70164000),
(1016456, 1000873, 'CA', 'Godefroy', 1, 'godefroy', 51.75012000, -68.08213000),
(1016461, 1000873, 'CA', 'Granby', 1, 'granby', 45.40008000, -72.73243000),
(1016485, 1000873, 'CA', 'Hampstead', 1, 'hampstead', 45.48064000, -73.66307000),
(1016495, 1000873, 'CA', 'Hauterive', 1, 'hauterive', 49.19572000, -68.25813000),
(1016496, 1000873, 'CA', 'Havre-Saint-Pierre', 1, 'havre-saint-pierre', 50.24342000, -63.60264000),
(1016517, 1000873, 'CA', 'Hérouxville', 1, 'herouxville', 46.66617000, -72.62512000),
(1016511, 1000873, 'CA', 'Hudson', 1, 'hudson', 45.45008000, -74.14922000),
(1016514, 1000873, 'CA', 'Huntingdon', 1, 'huntingdon', 45.08339000, -74.16593000),
(1016529, 1000873, 'CA', 'Joliette', 1, 'joliette', 46.01640000, -73.42360000),
(1016530, 1000873, 'CA', 'Jonquière', 1, 'jonquiere', 48.41648000, -71.24884000),
(1016549, 1000873, 'CA', 'Kingsey Falls', 1, 'kingsey-falls', 45.85007000, -72.06580000),
(1016551, 1000873, 'CA', 'Kirkland', 1, 'kirkland', 45.45008000, -73.86586000),
(1016556, 1000873, 'CA', 'L\'Ancienne-Lorette', 1, 'l-ancienne-lorette', 46.79392000, -71.35191000),
(1016557, 1000873, 'CA', 'L\'Ange-Gardien', 1, 'l-ange-gardien', 46.91976000, -71.08253000),
(1016558, 1000873, 'CA', 'L\'Ascension-de-Notre-Seigneur', 1, 'l-ascension-de-notre-seigneur', 48.68339000, -71.66580000),
(1016559, 1000873, 'CA', 'L\'Assomption', 1, 'l-assomption', 45.82318000, -73.42940000),
(1016561, 1000873, 'CA', 'L\'Épiphanie', 1, 'l-epiphanie', 45.85008000, -73.48246000),
(1016562, 1000873, 'CA', 'L\'Île-Perrot', 1, 'l-ile-perrot', 45.38338000, -73.94920000),
(1016564, 1000873, 'CA', 'La Conception', 1, 'la-conception', 46.15009000, -74.69925000),
(1016565, 1000873, 'CA', 'La Haute-Saint-Charles', 1, 'la-haute-saint-charles', 46.89028000, -71.37222000),
(1016566, 1000873, 'CA', 'La Malbaie', 1, 'la-malbaie', 47.65400000, -70.15268000),
(1016567, 1000873, 'CA', 'La Minerve', 1, 'la-minerve', 46.25009000, -74.93257000),
(1016568, 1000873, 'CA', 'La Pocatière', 1, 'la-pocatiere', 47.36733000, -70.03484000),
(1016569, 1000873, 'CA', 'La Prairie', 1, 'la-prairie', 45.41678000, -73.49917000),
(1016571, 1000873, 'CA', 'La Sarre', 1, 'la-sarre', 48.80019000, -79.19964000),
(1016572, 1000873, 'CA', 'La Tuque', 1, 'la-tuque', 47.43337000, -72.78240000),
(1016573, 1000873, 'CA', 'Labelle', 1, 'labelle', 46.28339000, -74.73255000),
(1016577, 1000873, 'CA', 'Lac-Alouette', 1, 'lac-alouette', 45.81698000, -73.95920000),
(1016578, 1000873, 'CA', 'Lac-Brome', 1, 'lac-brome', 45.21678000, -72.51581000),
(1016579, 1000873, 'CA', 'Lac-Connelly', 1, 'lac-connelly', 45.89788000, -73.97230000),
(1016580, 1000873, 'CA', 'Lac-Lapierre', 1, 'lac-lapierre', 45.89837000, -73.77308000),
(1016581, 1000873, 'CA', 'Lac-Mégantic', 1, 'lac-megantic', 45.58338000, -70.88234000),
(1016582, 1000873, 'CA', 'Lac-Simon', 1, 'lac-simon', 46.15699000, -74.74129000),
(1016583, 1000873, 'CA', 'Lachute', 1, 'lachute', 45.65008000, -74.33253000),
(1016584, 1000873, 'CA', 'Lacolle', 1, 'lacolle', 45.08338000, -73.36585000),
(1016599, 1000873, 'CA', 'Lanoraie', 1, 'lanoraie', 45.96677000, -73.21585000),
(1016604, 1000873, 'CA', 'Laval', 1, 'laval', 45.56995000, -73.69200000),
(1016605, 1000873, 'CA', 'Lavaltrie', 1, 'lavaltrie', 45.88338000, -73.28245000),
(1016606, 1000873, 'CA', 'Le Bic', 1, 'le-bic', 48.37549000, -68.69415000),
(1017224, 1000873, 'CA', 'le Plateau', 1, 'le-plateau', 45.43514000, -75.78030000),
(1016608, 1000873, 'CA', 'Lebel-sur-Quévillon', 1, 'lebel-sur-quevillon', 49.05018000, -76.98273000),
(1016609, 1000873, 'CA', 'Leblanc', 1, 'leblanc', 48.26683000, -74.34914000),
(1016612, 1000873, 'CA', 'Les Cèdres', 1, 'les-cedres', 45.30008000, -74.04922000),
(1016611, 1000873, 'CA', 'Les Coteaux', 1, 'les-coteaux', 45.28338000, -74.23254000),
(1016613, 1000873, 'CA', 'Les Escoumins', 1, 'les-escoumins', 48.35191000, -69.40724000),
(1016639, 1000873, 'CA', 'Lévis', 1, 'levis', 46.80326000, -71.17793000),
(1016620, 1000873, 'CA', 'Linière', 1, 'liniere', 46.00007000, -70.41572000),
(1016628, 1000873, 'CA', 'Longueuil', 1, 'longueuil', 45.53121000, -73.51806000),
(1016630, 1000873, 'CA', 'Lorraine', 1, 'lorraine', 45.68338000, -73.78249000),
(1016631, 1000873, 'CA', 'Louiseville', 1, 'louiseville', 46.25594000, -72.94145000),
(1016634, 1000873, 'CA', 'Luceville', 1, 'luceville', 48.54498000, -68.39658000),
(1016640, 1000873, 'CA', 'Macamic', 1, 'macamic', 48.75018000, -78.99962000),
(1016644, 1000873, 'CA', 'Magog', 1, 'magog', 45.26678000, -72.14909000),
(1016646, 1000873, 'CA', 'Malartic', 1, 'malartic', 48.13348000, -78.13283000),
(1016647, 1000873, 'CA', 'Maliotenam', 1, 'maliotenam', 50.21119000, -66.18164000),
(1016648, 1000873, 'CA', 'Manawan', 1, 'manawan', 47.22029000, -74.38606000),
(1016649, 1000873, 'CA', 'Mandeville', 1, 'mandeville', 46.36677000, -73.34915000),
(1016652, 1000873, 'CA', 'Maniwaki', 1, 'maniwaki', 46.38341000, -75.96605000),
(1016659, 1000873, 'CA', 'Maria', 1, 'maria', 48.17490000, -65.98595000),
(1016660, 1000873, 'CA', 'Marieville', 1, 'marieville', 45.43338000, -73.16585000),
(1016665, 1000873, 'CA', 'Mascouche', 1, 'mascouche', 45.74965000, -73.59956000),
(1016666, 1000873, 'CA', 'Maskinongé', 1, 'maskinonge', 46.22860000, -73.01917000),
(1016667, 1000873, 'CA', 'Matagami', 1, 'matagami', 49.75018000, -77.63277000),
(1016668, 1000873, 'CA', 'Matane', 1, 'matane', 48.82857000, -67.52197000),
(1016670, 1000873, 'CA', 'Mauricie', 1, 'mauricie', 47.55009000, -73.41583000),
(1016678, 1000873, 'CA', 'Melocheville', 1, 'melocheville', 45.31726000, -73.93710000),
(1016680, 1000873, 'CA', 'Mercier', 1, 'mercier', 45.31678000, -73.74919000),
(1016725, 1000873, 'CA', 'Métabetchouan', 1, 'metabetchouan', 48.36679000, -72.01583000),
(1016682, 1000873, 'CA', 'Metabetchouan-Lac-a-la-Croix', 1, 'metabetchouan-lac-a-la-croix', 48.41000000, -71.78000000),
(1016694, 1000873, 'CA', 'Mirabel', 1, 'mirabel', 45.65008000, -74.08251000),
(1016699, 1000873, 'CA', 'Mistissini', 1, 'mistissini', 50.41667000, -73.88333000),
(1016701, 1000873, 'CA', 'Mont-Joli', 1, 'mont-joli', 48.58388000, -68.19214000),
(1016702, 1000873, 'CA', 'Mont-Laurier', 1, 'mont-laurier', 46.55011000, -75.49930000),
(1016703, 1000873, 'CA', 'Mont-Royal', 1, 'mont-royal', 45.51675000, -73.64918000),
(1016704, 1000873, 'CA', 'Mont-Saint-Grégoire', 1, 'mont-saint-gregoire', 45.33338000, -73.16585000),
(1016705, 1000873, 'CA', 'Mont-Saint-Hilaire', 1, 'mont-saint-hilaire', 45.56515000, -73.18680000),
(1016706, 1000873, 'CA', 'Mont-Tremblant', 1, 'mont-tremblant', 46.21274000, -74.58438000),
(1016708, 1000873, 'CA', 'Montmagny', 1, 'montmagny', 46.98043000, -70.55493000),
(1016709, 1000873, 'CA', 'Montréal', 1, 'montreal', 45.50008000, -73.68248000),
(1016710, 1000873, 'CA', 'Montréal-Est', 1, 'montreal-est', 45.63202000, -73.50750000),
(1016711, 1000873, 'CA', 'Montréal-Ouest', 1, 'montreal-ouest', 45.45286000, -73.64918000),
(1016718, 1000873, 'CA', 'Morin-Heights', 1, 'morin-heights', 45.90009000, -74.24922000),
(1016732, 1000873, 'CA', 'Napierville', 1, 'napierville', 45.18648000, -73.40468000),
(1016737, 1000873, 'CA', 'Neuville', 1, 'neuville', 46.69823000, -71.58275000),
(1016738, 1000873, 'CA', 'New Carlisle', 1, 'new-carlisle', 48.00956000, -65.33621000),
(1016743, 1000873, 'CA', 'New-Richmond', 1, 'new-richmond', 48.16059000, -65.85823000),
(1016746, 1000873, 'CA', 'Nicolet', 1, 'nicolet', 46.21676000, -72.61582000),
(1016751, 1000873, 'CA', 'Nord-du-Québec', 1, 'nord-du-quebec', 51.96200000, -74.89610000),
(1016754, 1000873, 'CA', 'Normandin', 1, 'normandin', 48.83328000, -72.53209000),
(1016764, 1000873, 'CA', 'Notre-Dame-de-Grâce', 1, 'notre-dame-de-grace', 45.47675000, -73.61432000),
(1016765, 1000873, 'CA', 'Notre-Dame-de-l\'Île-Perrot', 1, 'notre-dame-de-l-ile-perrot', 45.36678000, -73.93250000),
(1016766, 1000873, 'CA', 'Notre-Dame-des-Prairies', 1, 'notre-dame-des-prairies', 46.05007000, -73.43245000),
(1016767, 1000873, 'CA', 'Notre-Dame-du-Lac', 1, 'notre-dame-du-lac', 46.75012000, -79.04961000),
(1016768, 1000873, 'CA', 'Notre-Dame-du-Mont-Carmel', 1, 'notre-dame-du-mont-carmel', 46.01680000, -75.08259000),
(1016771, 1000873, 'CA', 'Oka', 1, 'oka', 45.46489000, -74.08892000),
(1016780, 1000873, 'CA', 'Ormstown', 1, 'ormstown', 45.13338000, -73.99922000),
(1016786, 1000873, 'CA', 'Otterburn Park', 1, 'otterburn-park', 45.53338000, -73.21585000),
(1016787, 1000873, 'CA', 'Outaouais', 1, 'outaouais', 46.26681000, -76.31606000),
(1016794, 1000873, 'CA', 'Papineauville', 1, 'papineauville', 45.61680000, -75.01599000),
(1016795, 1000873, 'CA', 'Parc-Boutin', 1, 'parc-boutin', 45.29209000, -73.26154000),
(1016821, 1000873, 'CA', 'Piedmont', 1, 'piedmont', 45.90008000, -74.13251000),
(1016822, 1000873, 'CA', 'Pierreville', 1, 'pierreville', 46.07034000, -72.81125000),
(1016825, 1000873, 'CA', 'Pincourt', 1, 'pincourt', 45.38338000, -73.98250000),
(1016829, 1000873, 'CA', 'Plessisville', 1, 'plessisville', 46.21856000, -71.76201000),
(1016830, 1000873, 'CA', 'Pohénégamook', 1, 'pohenegamook', 47.46315000, -69.22666000),
(1016831, 1000873, 'CA', 'Pointe-Calumet', 1, 'pointe-calumet', 45.50008000, -73.96590000),
(1016832, 1000873, 'CA', 'Pointe-Claire', 1, 'pointe-claire', 45.44868000, -73.81669000),
(1016833, 1000873, 'CA', 'Pointe-du-Lac', 1, 'pointe-du-lac', 48.50009000, -71.78241000),
(1016835, 1000873, 'CA', 'Pont Rouge', 1, 'pont-rouge', 48.88332000, -72.08247000),
(1016836, 1000873, 'CA', 'Pont-Rouge', 1, 'pont-rouge', 46.75468000, -71.69566000),
(1016847, 1000873, 'CA', 'Port-Cartier', 1, 'port-cartier', 50.03339000, -66.86545000),
(1016849, 1000873, 'CA', 'Portneuf', 1, 'portneuf', 46.69058000, -71.89011000),
(1016862, 1000873, 'CA', 'Prévost', 1, 'prevost', 45.86678000, -74.08251000),
(1016860, 1000873, 'CA', 'Princeville', 1, 'princeville', 46.17163000, -71.87462000),
(1016867, 1000873, 'CA', 'Québec', 1, 'quebec', 46.81228000, -71.21454000),
(1016870, 1000873, 'CA', 'Rawdon', 1, 'rawdon', 46.05007000, -73.71587000),
(1016881, 1000873, 'CA', 'Repentigny', 1, 'repentigny', 45.74222000, -73.45008000),
(1016883, 1000873, 'CA', 'Richelieu', 1, 'richelieu', 45.44336000, -73.24602000),
(1016886, 1000873, 'CA', 'Richmond', 1, 'richmond', 45.66677000, -72.14910000),
(1016891, 1000873, 'CA', 'Rigaud', 1, 'rigaud', 45.47927000, -74.30238000),
(1016893, 1000873, 'CA', 'Rimouski', 1, 'rimouski', 48.44879000, -68.52396000),
(1016896, 1000873, 'CA', 'Rivière-du-Loup', 1, 'riviere-du-loup', 47.82699000, -69.54243000),
(1016895, 1000873, 'CA', 'Rivière-Rouge', 1, 'riviere-rouge', 46.41679000, -74.86596000),
(1016897, 1000873, 'CA', 'Roberval', 1, 'roberval', 48.51680000, -72.23244000),
(1016899, 1000873, 'CA', 'Rock Forest', 1, 'rock-forest', 45.35699000, -71.99676000),
(1016902, 1000873, 'CA', 'Rosemère', 1, 'rosemere', 45.63338000, -73.79919000),
(1016906, 1000873, 'CA', 'Rougemont', 1, 'rougemont', 45.43338000, -73.04914000),
(1016907, 1000873, 'CA', 'Rouyn-Noranda', 1, 'rouyn-noranda', 48.23656000, -79.02311000),
(1016911, 1000873, 'CA', 'Sacré-Coeur', 1, 'sacre-coeur', 48.22970000, -69.80061000),
(1016912, 1000873, 'CA', 'Saguenay', 1, 'saguenay', 48.41675000, -71.06573000),
(1016915, 1000873, 'CA', 'Saint-Adolphe-d\'Howard', 1, 'saint-adolphe-d-howard', 45.96679000, -74.33253000),
(1016916, 1000873, 'CA', 'Saint-Alexandre', 1, 'saint-alexandre', 45.50010000, -75.74935000),
(1016917, 1000873, 'CA', 'Saint-Amable', 1, 'saint-amable', 45.65008000, -73.29916000),
(1016918, 1000873, 'CA', 'Saint-Ambroise', 1, 'saint-ambroise', 48.55009000, -71.33238000),
(1016919, 1000873, 'CA', 'Saint-André-Avellin', 1, 'saint-andre-avellin', 45.71680000, -75.06599000),
(1016920, 1000873, 'CA', 'Saint-Anselme', 1, 'saint-anselme', 46.62922000, -70.97340000),
(1016922, 1000873, 'CA', 'Saint-Antoine-de-Tilly', 1, 'saint-antoine-de-tilly', 46.66346000, -71.57335000),
(1016923, 1000873, 'CA', 'Saint-Augustin', 1, 'saint-augustin', 51.22602000, -58.65017000),
(1016924, 1000873, 'CA', 'Saint-Augustin-de-Desmaures', 1, 'saint-augustin-de-desmaures', 46.74064000, -71.45131000),
(1016925, 1000873, 'CA', 'Saint-Barnabé-Sud', 1, 'saint-barnabe-sud', 45.72977000, -72.92244000),
(1016926, 1000873, 'CA', 'Saint-Basile-le-Grand', 1, 'saint-basile-le-grand', 45.53338000, -73.28246000),
(1016927, 1000873, 'CA', 'Saint-Boniface', 1, 'saint-boniface', 46.50011000, -75.98264000),
(1016928, 1000873, 'CA', 'Saint-Bruno', 1, 'saint-bruno', 48.46679000, -71.64910000),
(1016929, 1000873, 'CA', 'Saint-Bruno-de-Guigues', 1, 'saint-bruno-de-guigues', 47.46685000, -79.43296000),
(1016930, 1000873, 'CA', 'Saint-Bruno-de-Montarville', 1, 'saint-bruno-de-montarville', 45.53341000, -73.34916000),
(1016931, 1000873, 'CA', 'Saint-Canut', 1, 'saint-canut', 45.71502000, -74.08376000),
(1016935, 1000873, 'CA', 'Saint-Césaire', 1, 'saint-cesaire', 45.41678000, -72.99914000),
(1016932, 1000873, 'CA', 'Saint-Charles', 1, 'saint-charles', 45.70288000, -73.55417000),
(1016936, 1000873, 'CA', 'Saint-Côme--Linière', 1, 'saint-come-liniere', 46.06677000, -70.51573000),
(1016933, 1000873, 'CA', 'Saint-Constant', 1, 'saint-constant', 45.36678000, -73.56588000),
(1016934, 1000873, 'CA', 'Saint-Cyrille-de-Wendover', 1, 'saint-cyrille-de-wendover', 45.93336000, -72.43241000),
(1016937, 1000873, 'CA', 'Saint-Damase', 1, 'saint-damase', 45.53341000, -72.99914000),
(1016938, 1000873, 'CA', 'Saint-Denis-sur-Richelieu', 1, 'saint-denis-sur-richelieu', 45.78338000, -73.14915000),
(1016939, 1000873, 'CA', 'Saint-Donat-de-Montcalm', 1, 'saint-donat-de-montcalm', 46.31868000, -74.22171000),
(1016992, 1000873, 'CA', 'Saint-Édouard', 1, 'saint-edouard', 45.23338000, -73.51588000),
(1016940, 1000873, 'CA', 'Saint-Elzéar', 1, 'saint-elzear', 45.60338000, -73.72698000),
(1016993, 1000873, 'CA', 'Saint-Éphrem-de-Beauce', 1, 'saint-ephrem-de-beauce', 46.06677000, -70.94905000),
(1016941, 1000873, 'CA', 'Saint-Eustache', 1, 'saint-eustache', 45.56500000, -73.90554000),
(1016942, 1000873, 'CA', 'Saint-Félicien', 1, 'saint-felicien', 48.65007000, -72.44906000),
(1016943, 1000873, 'CA', 'Saint-Félix-de-Valois', 1, 'saint-felix-de-valois', 46.16977000, -73.42525000),
(1016944, 1000873, 'CA', 'Saint-Gabriel', 1, 'saint-gabriel', 46.30007000, -73.38245000),
(1016947, 1000873, 'CA', 'Saint-Gédéon', 1, 'saint-gedeon', 48.50009000, -71.76581000),
(1016945, 1000873, 'CA', 'Saint-Georges', 1, 'saint-georges', 46.11353000, -70.66526000),
(1016946, 1000873, 'CA', 'Saint-Germain-de-Grantham', 1, 'saint-germain-de-grantham', 45.83337000, -72.56582000),
(1016948, 1000873, 'CA', 'Saint-Henri', 1, 'saint-henri', 46.69314000, -71.06927000),
(1016949, 1000873, 'CA', 'Saint-Hippolyte', 1, 'saint-hippolyte', 45.93338000, -74.01590000),
(1016950, 1000873, 'CA', 'Saint-Honoré', 1, 'saint-honore', 48.53338000, -71.08236000),
(1016951, 1000873, 'CA', 'Saint-Hyacinthe', 1, 'saint-hyacinthe', 45.63076000, -72.95699000),
(1016952, 1000873, 'CA', 'Saint-Isidore', 1, 'saint-isidore', 47.43345000, -79.29965000),
(1016953, 1000873, 'CA', 'Saint-Jacques-le-Mineur', 1, 'saint-jacques-le-mineur', 45.28338000, -73.41587000),
(1016954, 1000873, 'CA', 'Saint-Jean-Baptiste', 1, 'saint-jean-baptiste', 45.38060000, -74.01210000),
(1016955, 1000873, 'CA', 'Saint-Jean-sur-Richelieu', 1, 'saint-jean-sur-richelieu', 45.30713000, -73.26259000),
(1016960, 1000873, 'CA', 'Saint-Jérôme', 1, 'saint-jerome', 45.78036000, -74.00365000),
(1016956, 1000873, 'CA', 'Saint-Joseph', 1, 'saint-joseph', 45.95817000, -73.22025000),
(1016957, 1000873, 'CA', 'Saint-Joseph-de-Beauce', 1, 'saint-joseph-de-beauce', 46.30000000, -70.86667000),
(1016958, 1000873, 'CA', 'Saint-Joseph-de-Coleraine', 1, 'saint-joseph-de-coleraine', 45.96677000, -71.36577000),
(1016959, 1000873, 'CA', 'Saint-Joseph-du-Lac', 1, 'saint-joseph-du-lac', 45.53338000, -73.99920000),
(1016961, 1000873, 'CA', 'Saint-Lambert-de-Lauzon', 1, 'saint-lambert-de-lauzon', 46.58624000, -71.20892000),
(1016962, 1000873, 'CA', 'Saint-Laurent', 1, 'saint-laurent', 45.50008000, -73.66585000),
(1016963, 1000873, 'CA', 'Saint-Lazare', 1, 'saint-lazare', 45.40008000, -74.13256000),
(1016966, 1000873, 'CA', 'Saint-Léonard', 1, 'saint-leonard', 45.58773000, -73.59501000),
(1016968, 1000873, 'CA', 'Saint-Léonard-d\'Aston', 1, 'saint-leonard-d-aston', 46.10006000, -72.36580000),
(1016964, 1000873, 'CA', 'Saint-Liboire', 1, 'saint-liboire', 45.65068000, -72.76348000),
(1016965, 1000873, 'CA', 'Saint-Lin-Laurentides', 1, 'saint-lin-laurentides', 45.85008000, -73.76588000),
(1016969, 1000873, 'CA', 'Saint-Marc-des-Carrières', 1, 'saint-marc-des-carrieres', 46.68335000, -72.04910000),
(1016970, 1000873, 'CA', 'Saint-Mathieu', 1, 'saint-mathieu', 45.31678000, -73.51587000),
(1016971, 1000873, 'CA', 'Saint-Michel', 1, 'saint-michel', 45.56758000, -73.62168000),
(1016972, 1000873, 'CA', 'Saint-Michel-des-Saints', 1, 'saint-michel-des-saints', 46.67702000, -73.91881000),
(1016973, 1000873, 'CA', 'Saint-Nazaire', 1, 'saint-nazaire', 48.58944000, -71.55247000),
(1016974, 1000873, 'CA', 'Saint-Norbert', 1, 'saint-norbert', 46.16949000, -73.31494000),
(1016975, 1000873, 'CA', 'Saint-Pacôme', 1, 'saint-pacome', 47.40457000, -69.95025000),
(1016976, 1000873, 'CA', 'Saint-Pascal', 1, 'saint-pascal', 47.51813000, -69.80301000),
(1016977, 1000873, 'CA', 'Saint-Philippe-de-La Prairie', 1, 'saint-philippe-de-la-prairie', 45.35723000, -73.47706000),
(1016978, 1000873, 'CA', 'Saint-Pie', 1, 'saint-pie', 45.50277000, -72.90890000),
(1016979, 1000873, 'CA', 'Saint-Pierre-les-Becquets', 1, 'saint-pierre-les-becquets', 46.50005000, -72.19910000),
(1016980, 1000873, 'CA', 'Saint-Prime', 1, 'saint-prime', 48.58339000, -72.33244000),
(1016981, 1000873, 'CA', 'Saint-Raphaël', 1, 'saint-raphael', 46.25011000, -76.01605000),
(1016982, 1000873, 'CA', 'Saint-Raymond', 1, 'saint-raymond', 45.46698000, -73.60948000),
(1016983, 1000873, 'CA', 'Saint-Rémi', 1, 'saint-remi', 45.26678000, -73.61588000),
(1016984, 1000873, 'CA', 'Saint-Rémi-de-Tingwick', 1, 'saint-remi-de-tingwick', 45.86677000, -71.81581000),
(1016985, 1000873, 'CA', 'Saint-Sauveur', 1, 'saint-sauveur', 45.88686000, -74.17943000),
(1016986, 1000873, 'CA', 'Saint-Sauveur-des-Monts', 1, 'saint-sauveur-des-monts', 45.90008000, -74.16591000),
(1016987, 1000873, 'CA', 'Saint-Siméon', 1, 'saint-simeon', 47.84431000, -69.87837000),
(1016988, 1000873, 'CA', 'Saint-Thomas', 1, 'saint-thomas', 46.01677000, -73.34915000),
(1016989, 1000873, 'CA', 'Saint-Tite', 1, 'saint-tite', 46.73336000, -72.56581000),
(1016990, 1000873, 'CA', 'Saint-Victor', 1, 'saint-victor', 45.61118000, -73.51527000),
(1016991, 1000873, 'CA', 'Saint-Zotique', 1, 'saint-zotique', 45.25009000, -74.24924000),
(1016994, 1000873, 'CA', 'Sainte Catherine de la Jacques Cartier', 1, 'sainte-catherine-de-la-jacques-cartier', 46.85244000, -71.62056000),
(1016995, 1000873, 'CA', 'Sainte-Adèle', 1, 'sainte-adele', 45.95008000, -74.13251000),
(1016996, 1000873, 'CA', 'Sainte-Agathe-des-Monts', 1, 'sainte-agathe-des-monts', 46.05009000, -74.28252000),
(1016997, 1000873, 'CA', 'Sainte-Anne-de-Bellevue', 1, 'sainte-anne-de-bellevue', 45.40618000, -73.94560000),
(1016998, 1000873, 'CA', 'Sainte-Anne-des-Monts', 1, 'sainte-anne-des-monts', 49.12402000, -66.49243000),
(1016999, 1000873, 'CA', 'Sainte-Anne-des-Plaines', 1, 'sainte-anne-des-plaines', 45.76468000, -73.81156000),
(1017000, 1000873, 'CA', 'Sainte-Béatrix', 1, 'sainte-beatrix', 46.20007000, -73.61587000),
(1017001, 1000873, 'CA', 'Sainte-Catherine', 1, 'sainte-catherine', 45.40008000, -73.58248000),
(1017002, 1000873, 'CA', 'Sainte-Croix', 1, 'sainte-croix', 45.13368000, -72.80083000),
(1017012, 1000873, 'CA', 'Sainte-Élisabeth', 1, 'sainte-elisabeth', 46.09502000, -73.35176000),
(1017003, 1000873, 'CA', 'Sainte-Julie', 1, 'sainte-julie', 45.58338000, -73.33246000),
(1017004, 1000873, 'CA', 'Sainte-Julienne', 1, 'sainte-julienne', 45.96677000, -73.71587000),
(1017005, 1000873, 'CA', 'Sainte-Madeleine', 1, 'sainte-madeleine', 45.60008000, -73.09914000),
(1017006, 1000873, 'CA', 'Sainte-Marie', 1, 'sainte-marie', 46.43401000, -71.01168000),
(1017007, 1000873, 'CA', 'Sainte-Marthe-sur-le-Lac', 1, 'sainte-marthe-sur-le-lac', 45.53338000, -73.93250000),
(1017008, 1000873, 'CA', 'Sainte-Martine', 1, 'sainte-martine', 45.25008000, -73.79919000),
(1017009, 1000873, 'CA', 'Sainte-Sophie', 1, 'sainte-sophie', 45.81678000, -73.89919000),
(1017010, 1000873, 'CA', 'Sainte-Thècle', 1, 'sainte-thecle', 46.81676000, -72.49911000),
(1017011, 1000873, 'CA', 'Sainte-Thérèse', 1, 'sainte-therese', 45.63922000, -73.82757000),
(1017013, 1000873, 'CA', 'Salaberry-de-Valleyfield', 1, 'salaberry-de-valleyfield', 45.25008000, -74.13253000),
(1017015, 1000873, 'CA', 'Salluit', 1, 'salluit', 62.20411000, -75.64344000),
(1017027, 1000873, 'CA', 'Senneterre', 1, 'senneterre', 48.39302000, -77.23951000),
(1017028, 1000873, 'CA', 'Sept-Îles', 1, 'sept-iles', 50.20011000, -66.38208000),
(1017030, 1000873, 'CA', 'Shannon', 1, 'shannon', 46.88026000, -71.51464000),
(1017032, 1000873, 'CA', 'Shawinigan', 1, 'shawinigan', 46.56675000, -72.74913000),
(1017033, 1000873, 'CA', 'Shawville', 1, 'shawville', 45.60011000, -76.48270000),
(1017039, 1000873, 'CA', 'Sherbrooke', 1, 'sherbrooke', 45.40008000, -71.89908000),
(1017054, 1000873, 'CA', 'Sorel-Tracy', 1, 'sorel-tracy', 46.04178000, -73.11358000),
(1017066, 1000873, 'CA', 'St-Jean-Port-Joli', 1, 'st-jean-port-joli', 47.21418000, -70.26969000),
(1017091, 1000873, 'CA', 'Sutton', 1, 'sutton', 45.10008000, -72.61582000),
(1017132, 1000873, 'CA', 'Témiscaming', 1, 'temiscaming', 46.72122000, -79.09712000),
(1017103, 1000873, 'CA', 'Terrasse-des-Pins', 1, 'terrasse-des-pins', 45.86449000, -74.06627000),
(1017104, 1000873, 'CA', 'Terrebonne', 1, 'terrebonne', 45.70004000, -73.64732000),
(1017107, 1000873, 'CA', 'Thetford-Mines', 1, 'thetford-mines', 46.09371000, -71.30539000),
(1017113, 1000873, 'CA', 'Thurso', 1, 'thurso', 45.60010000, -75.24931000),
(1017126, 1000873, 'CA', 'Trois-Rivières', 1, 'trois-rivieres', 46.34515000, -72.54770000),
(1017139, 1000873, 'CA', 'Val-d\'Or', 1, 'val-d-or', 48.09740000, -77.79737000),
(1017137, 1000873, 'CA', 'Val-David', 1, 'val-david', 46.03338000, -74.21592000),
(1017140, 1000873, 'CA', 'Val-des-Monts', 1, 'val-des-monts', 45.65010000, -75.66604000),
(1017138, 1000873, 'CA', 'Val-Morin', 1, 'val-morin', 46.00008000, -74.18251000),
(1017141, 1000873, 'CA', 'Valcourt', 1, 'valcourt', 45.50008000, -72.31581000),
(1017144, 1000873, 'CA', 'Vallée-Jonction', 1, 'vallee-jonction', 46.37441000, -70.91881000),
(1017148, 1000873, 'CA', 'Varennes', 1, 'varennes', 45.68338000, -73.43246000),
(1017149, 1000873, 'CA', 'Vaudreuil-Dorion', 1, 'vaudreuil-dorion', 45.40008000, -74.03251000),
(1017152, 1000873, 'CA', 'Venise-en-Québec', 1, 'venise-en-quebec', 45.08338000, -73.13245000),
(1017153, 1000873, 'CA', 'Verchères', 1, 'vercheres', 45.78338000, -73.34916000),
(1017157, 1000873, 'CA', 'Victoriaville', 1, 'victoriaville', 46.05007000, -71.96579000),
(1017159, 1000873, 'CA', 'Ville-Marie', 1, 'ville-marie', 47.33345000, -79.43297000),
(1017167, 1000873, 'CA', 'Wakefield', 1, 'wakefield', 45.66680000, -75.83265000),
(1017171, 1000873, 'CA', 'Warwick', 1, 'warwick', 45.95007000, -71.98240000),
(1017173, 1000873, 'CA', 'Waskaganish', 1, 'waskaganish', 51.48333000, -78.75000000),
(1017174, 1000873, 'CA', 'Waswanipi', 1, 'waswanipi', 49.73346000, -76.16604000),
(1017177, 1000873, 'CA', 'Waterloo', 1, 'waterloo', 45.35008000, -72.51582000),
(1017182, 1000873, 'CA', 'Weedon Centre', 1, 'weedon-centre', 45.70802000, -71.45986000),
(1017196, 1000873, 'CA', 'Westmount', 1, 'westmount', 45.48341000, -73.59918000),
(1017199, 1000873, 'CA', 'Weymontachie', 1, 'weymontachie', 47.89940000, -73.77720000),
(1017210, 1000873, 'CA', 'Windsor', 1, 'windsor', 45.56678000, -71.99909000),
(1017219, 1000873, 'CA', 'Yamachiche', 1, 'yamachiche', 46.26676000, -72.83243000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000870, 'CA', 'Saskatchewan', 1, 'saskatchewan');

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 
(1016177, 1000870, 'CA', 'Assiniboia', 1, 'assiniboia', 49.63336000, -105.98446000),
(1016217, 1000870, 'CA', 'Biggar', 1, 'biggar', 52.06680000, -108.00135000),
(1016268, 1000870, 'CA', 'Canora', 1, 'canora', 51.63328000, -102.43425000),
(1016282, 1000870, 'CA', 'Carlyle', 1, 'carlyle', 49.63334000, -102.26765000),
(1016353, 1000870, 'CA', 'Dalmeny', 1, 'dalmeny', 52.33339000, -106.76792000),
(1016410, 1000870, 'CA', 'Esterhazy', 1, 'esterhazy', 50.65001000, -102.08426000),
(1016411, 1000870, 'CA', 'Estevan', 1, 'estevan', 49.13337000, -102.98422000),
(1016424, 1000870, 'CA', 'Foam Lake', 1, 'foam-lake', 51.65001000, -103.53431000),
(1016469, 1000870, 'CA', 'Gravelbourg', 1, 'gravelbourg', 49.88336000, -106.55122000),
(1016512, 1000870, 'CA', 'Hudson Bay', 1, 'hudson-bay', 52.85003000, -102.38425000),
(1016513, 1000870, 'CA', 'Humboldt', 1, 'humboldt', 52.20005000, -105.12550000),
(1016519, 1000870, 'CA', 'Indian Head', 1, 'indian-head', 50.53336000, -103.66775000),
(1016532, 1000870, 'CA', 'Kamsack', 1, 'kamsack', 51.56668000, -101.90093000),
(1016540, 1000870, 'CA', 'Kerrobert', 1, 'kerrobert', 51.91682000, -109.13479000),
(1016547, 1000870, 'CA', 'Kindersley', 1, 'kindersley', 51.46681000, -109.16818000),
(1016570, 1000870, 'CA', 'La Ronge', 1, 'la-ronge', 55.10013000, -105.28422000),
(1016594, 1000870, 'CA', 'Langenburg', 1, 'langenburg', 50.84999000, -101.71763000),
(1016596, 1000870, 'CA', 'Langham', 1, 'langham', 52.36680000, -106.96793000),
(1016598, 1000870, 'CA', 'Lanigan', 1, 'lanigan', 51.85006000, -105.03443000),
(1016636, 1000870, 'CA', 'Lumsden', 1, 'lumsden', 50.65009000, -104.86783000),
(1016642, 1000870, 'CA', 'Macklin', 1, 'macklin', 52.33344000, -109.93484000),
(1016655, 1000870, 'CA', 'Maple Creek', 1, 'maple-creek', 49.91678000, -109.48481000),
(1016663, 1000870, 'CA', 'Martensville', 1, 'martensville', 52.28339000, -106.66792000),
(1016673, 1000870, 'CA', 'Meadow Lake', 1, 'meadow-lake', 54.13348000, -108.43471000),
(1016676, 1000870, 'CA', 'Melfort', 1, 'melfort', 52.86673000, -104.61768000),
(1016679, 1000870, 'CA', 'Melville', 1, 'melville', 50.91671000, -102.80099000),
(1016713, 1000870, 'CA', 'Moose Jaw', 1, 'moose-jaw', 50.40005000, -105.53445000),
(1016715, 1000870, 'CA', 'Moosomin', 1, 'moosomin', 50.13332000, -101.66766000),
(1016747, 1000870, 'CA', 'Nipawin', 1, 'nipawin', 53.36678000, -104.00092000),
(1016755, 1000870, 'CA', 'North Battleford', 1, 'north-battleford', 52.77972000, -108.29670000),
(1016788, 1000870, 'CA', 'Outlook', 1, 'outlook', 51.50008000, -107.05128000),
(1016790, 1000870, 'CA', 'Oxbow', 1, 'oxbow', 49.23335000, -102.16760000),
(1016807, 1000870, 'CA', 'Pelican Narrows', 1, 'pelican-narrows', 55.16685000, -102.93410000),
(1016823, 1000870, 'CA', 'Pilot Butte', 1, 'pilot-butte', 50.46678000, -104.41778000),
(1016852, 1000870, 'CA', 'Preeceville', 1, 'preeceville', 51.94998000, -102.66766000),
(1016854, 1000870, 'CA', 'Prince Albert', 1, 'prince-albert', 53.20008000, -105.76772000),
(1016875, 1000870, 'CA', 'Regina', 1, 'regina', 50.45008000, -104.61780000),
(1016876, 1000870, 'CA', 'Regina Beach', 1, 'regina-beach', 50.78338000, -105.00112000),
(1016903, 1000870, 'CA', 'Rosetown', 1, 'rosetown', 51.55010000, -108.00136000),
(1016905, 1000870, 'CA', 'Rosthern', 1, 'rosthern', 52.66679000, -106.33446000),
(1017021, 1000870, 'CA', 'Saskatoon', 1, 'saskatoon', 52.13238000, -106.66892000),
(1017031, 1000870, 'CA', 'Shaunavon', 1, 'shaunavon', 49.65005000, -108.41810000),
(1017038, 1000870, 'CA', 'Shellbrook', 1, 'shellbrook', 53.21679000, -106.40109000),
(1017094, 1000870, 'CA', 'Swift Current', 1, 'swift-current', 50.28337000, -107.80135000),
(1017116, 1000870, 'CA', 'Tisdale', 1, 'tisdale', 52.85002000, -104.05096000),
(1017134, 1000870, 'CA', 'Unity', 1, 'unity', 52.45014000, -109.16816000),
(1017165, 1000870, 'CA', 'Wadena', 1, 'wadena', 51.94999000, -103.80102000),
(1017170, 1000870, 'CA', 'Warman', 1, 'warman', 52.31679000, -106.56791000),
(1017179, 1000870, 'CA', 'Watrous', 1, 'watrous', 51.66677000, -105.46788000),
(1017198, 1000870, 'CA', 'Weyburn', 1, 'weyburn', 49.66675000, -103.85109000),
(1017201, 1000870, 'CA', 'White City', 1, 'white-city', 50.43338000, -104.36778000),
(1017206, 1000870, 'CA', 'Wilkie', 1, 'wilkie', 52.41683000, -108.70142000),
(1017218, 1000870, 'CA', 'Wynyard', 1, 'wynyard', 51.76674000, -104.18436000),
(1017223, 1000870, 'CA', 'Yorkton', 1, 'yorkton', 51.21670000, -102.46766000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000869, 'CA', 'Yukon', 1, 'yukon');

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 
(1016358, 1000869, 'CA', 'Dawson City', 1, 'dawson-city', 64.06013000, -139.43328000),
(1016479, 1000869, 'CA', 'Haines Junction', 1, 'haines-junction', 60.75216000, -137.51082000),
(1017180, 1000869, 'CA', 'Watson Lake', 1, 'watson-lake', 60.06349000, -128.70893000),
(1017204, 1000869, 'CA', 'Whitehorse', 1, 'whitehorse', 60.71611000, -135.05375000);

