-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: May 26, 2016 at 02:03 PM
-- Server version: 5.5.42
-- PHP Version: 7.0.0

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

--
-- Database: `laraclassified`
--

-- --------------------------------------------------------


--
-- Dumping data for table `subadmin1`
--

INSERT INTO `subadmin1` (`id`, `code`, `name`, `asciiname`, `active`) VALUES
(446, 'CA.01', 'Alberta', 'Alberta', NULL),
(447, 'CA.02', 'British Columbia', 'British Columbia', NULL),
(448, 'CA.03', 'Manitoba', 'Manitoba', NULL),
(449, 'CA.04', 'New Brunswick', 'New Brunswick', NULL),
(450, 'CA.05', 'Newfoundland and Labrador', 'Newfoundland and Labrador', NULL),
(451, 'CA.07', 'Nova Scotia', 'Nova Scotia', NULL),
(452, 'CA.08', 'Ontario', 'Ontario', NULL),
(453, 'CA.09', 'Prince Edward Island', 'Prince Edward Island', NULL),
(454, 'CA.10', 'Quebec', 'Quebec', NULL),
(455, 'CA.11', 'Saskatchewan', 'Saskatchewan', NULL),
(456, 'CA.12', 'Yukon', 'Yukon', NULL),
(457, 'CA.13', 'Northwest Territories', 'Northwest Territories', NULL),
(458, 'CA.14', 'Nunavut', 'Nunavut', NULL);



--
-- Dumping data for table `subadmin2`
--

INSERT INTO `subadmin2` (`id`, `code`, `name`, `asciiname`, `active`) VALUES
(8399, 'CA.01.6184011', 'Wood Buffalo', 'Wood Buffalo', NULL),
(8400, 'CA.02.5901', 'Regional District of East Kootenay', 'Regional District of East Kootenay', NULL),
(8401, 'CA.02.5903', 'Regional District of Central Kootenay', 'Regional District of Central Kootenay', NULL),
(8402, 'CA.02.5905', 'Regional District of Kootenay-Boundary', 'Regional District of Kootenay-Boundary', NULL),
(8403, 'CA.02.5907', 'Regional District of Okanagan-Similkameen', 'Regional District of Okanagan-Similkameen', NULL),
(8404, 'CA.02.5909', 'Fraser Valley Regional District', 'Fraser Valley Regional District', NULL),
(8405, 'CA.02.5915', 'Greater Vancouver Regional District', 'Greater Vancouver Regional District', NULL),
(8406, 'CA.02.5917', 'Capital Regional District', 'Capital Regional District', NULL),
(8407, 'CA.02.5919', 'Cowichan Valley Regional District', 'Cowichan Valley Regional District', NULL),
(8408, 'CA.02.5921', 'Regional District of Nanaimo', 'Regional District of Nanaimo', NULL),
(8409, 'CA.02.5923', 'Regional District of Alberni-Clayoquot', 'Regional District of Alberni-Clayoquot', NULL),
(8410, 'CA.02.5924', 'Strathcona Regional District', 'Strathcona Regional District', NULL),
(8411, 'CA.02.5926', 'Comox Valley Regional District', 'Comox Valley Regional District', NULL),
(8412, 'CA.02.5927', 'Powell River Regional District', 'Powell River Regional District', NULL),
(8413, 'CA.02.5929', 'Sunshine Coast Regional District', 'Sunshine Coast Regional District', NULL),
(8414, 'CA.02.5931', 'Squamish-Lillooet Regional District', 'Squamish-Lillooet Regional District', NULL),
(8415, 'CA.02.5933', 'Thompson-Nicola Regional District', 'Thompson-Nicola Regional District', NULL),
(8416, 'CA.02.5935', 'Regional District of Central Okanagan', 'Regional District of Central Okanagan', NULL),
(8417, 'CA.02.5937', 'Regional District of North Okanagan', 'Regional District of North Okanagan', NULL),
(8418, 'CA.02.5939', 'Columbia-Shuswap Regional District', 'Columbia-Shuswap Regional District', NULL),
(8419, 'CA.02.5941', 'Cariboo Regional District', 'Cariboo Regional District', NULL),
(8420, 'CA.02.5943', 'Regional District of Mount Waddington', 'Regional District of Mount Waddington', NULL),
(8421, 'CA.02.5945', 'Central Coast Regional District', 'Central Coast Regional District', NULL),
(8422, 'CA.02.5947', 'Skeena-Queen Charlotte Regional District', 'Skeena-Queen Charlotte Regional District', NULL),
(8423, 'CA.02.5949', 'Regional District of Kitimat-Stikine', 'Regional District of Kitimat-Stikine', NULL),
(8424, 'CA.02.5951', 'Regional District of Bulkley-Nechako', 'Regional District of Bulkley-Nechako', NULL),
(8425, 'CA.02.5953', 'Regional District of Fraser-Fort George', 'Regional District of Fraser-Fort George', NULL),
(8426, 'CA.02.5955', 'Peace River Regional District', 'Peace River Regional District', NULL),
(8427, 'CA.02.5957', 'Stikine Region', 'Stikine Region', NULL),
(8428, 'CA.02.5959', 'Northern Rockies Regional Municipality', 'Northern Rockies Regional Municipality', NULL),
(8429, 'CA.04.1301', 'Saint John County', 'Saint John County', NULL),
(8430, 'CA.04.1302', 'Charlotte County', 'Charlotte County', NULL),
(8431, 'CA.04.1303', 'Sunbury County', 'Sunbury County', NULL),
(8432, 'CA.04.1304', 'Queens County', 'Queens County', NULL),
(8433, 'CA.04.1305', 'Kings County', 'Kings County', NULL),
(8434, 'CA.04.1306', 'Albert County', 'Albert County', NULL),
(8435, 'CA.04.1307', 'Westmorland County', 'Westmorland County', NULL),
(8436, 'CA.04.1308', 'Kent County', 'Kent County', NULL),
(8437, 'CA.04.1309', 'Northumberland County', 'Northumberland County', NULL),
(8438, 'CA.04.1310', 'York County', 'York County', NULL),
(8439, 'CA.04.1311', 'Carleton County', 'Carleton County', NULL),
(8440, 'CA.04.1312', 'Victoria County', 'Victoria County', NULL),
(8441, 'CA.04.1313', 'Madawaska County', 'Madawaska County', NULL),
(8442, 'CA.04.1314', 'Restigouche', 'Restigouche', NULL),
(8443, 'CA.04.1315', 'Gloucester County', 'Gloucester County', NULL),
(8444, 'CA.07.1205', 'Annapolis County', 'Annapolis County', NULL),
(8445, 'CA.07.1207', 'Kings County', 'Kings County', NULL),
(8446, 'CA.07.1210', 'Colchester', 'Colchester', NULL),
(8447, 'CA.07.1211', 'Cumberland County', 'Cumberland County', NULL),
(8448, 'CA.07.1212', 'Pictou County', 'Pictou County', NULL),
(8449, 'CA.07.1214', 'Antigonish County', 'Antigonish County', NULL),
(8450, 'CA.07.1215', 'Inverness County', 'Inverness County', NULL),
(8451, 'CA.07.1216', 'Richmond County', 'Richmond County', NULL),
(8452, 'CA.07.1218', 'Victoria County', 'Victoria County', NULL),
(8453, 'CA.07.5939237', 'Digby County', 'Digby County', NULL),
(8454, 'CA.07.5968620', 'Guysborough County', 'Guysborough County', NULL),
(8455, 'CA.07.5969424', 'Halifax County', 'Halifax County', NULL),
(8456, 'CA.07.6062070', 'Lunenburg County', 'Lunenburg County', NULL),
(8457, 'CA.07.6115099', 'Queens County', 'Queens County', NULL),
(8458, 'CA.07.6145888', 'Shelburne County', 'Shelburne County', NULL),
(8459, 'CA.07.6185218', 'Yarmouth County', 'Yarmouth County', NULL),
(8460, 'CA.08.5883638', 'Algoma', 'Algoma', NULL),
(8461, 'CA.08.5907982', 'Brant', 'Brant', NULL),
(8462, 'CA.08.5910071', 'Bruce County', 'Bruce County', NULL),
(8463, 'CA.08.5920450', 'Chatham-Kent', 'Chatham-Kent', NULL),
(8464, 'CA.08.5924616', 'Cochrane District', 'Cochrane District', NULL),
(8465, 'CA.08.5943542', 'Dufferin County', 'Dufferin County', NULL),
(8466, 'CA.08.5944369', 'Durham', 'Durham', NULL),
(8467, 'CA.08.5947587', 'Elgin County', 'Elgin County', NULL),
(8468, 'CA.08.5949533', 'Essex County', 'Essex County', NULL),
(8469, 'CA.08.5958506', 'Frontenac County', 'Frontenac County', NULL),
(8470, 'CA.08.5966925', 'Grey County', 'Grey County', NULL),
(8471, 'CA.08.5969093', 'Haldimand County', 'Haldimand County', NULL),
(8472, 'CA.08.5969392', 'Haliburton County', 'Haliburton County', NULL),
(8473, 'CA.08.5969719', 'Halton', 'Halton', NULL),
(8474, 'CA.08.5969784', 'Hamilton', 'Hamilton', NULL),
(8475, 'CA.08.5971841', 'Hastings County', 'Hastings County', NULL),
(8476, 'CA.08.5978829', 'Huron County', 'Huron County', NULL),
(8477, 'CA.08.5989818', 'Kawartha Lakes', 'Kawartha Lakes', NULL),
(8478, 'CA.08.5991054', 'Kenora District', 'Kenora District', NULL),
(8479, 'CA.08.6049019', 'Lambton County', 'Lambton County', NULL),
(8480, 'CA.08.6049130', 'Lanark County', 'Lanark County', NULL),
(8481, 'CA.08.6052311', 'Lennox and Addington County', 'Lennox and Addington County', NULL),
(8482, 'CA.08.6065217', 'Manitoulin District', 'Manitoulin District', NULL),
(8483, 'CA.08.6073256', 'Middlesex County', 'Middlesex County', NULL),
(8484, 'CA.08.6084939', 'District Municipality of Muskoka', 'District Municipality of Muskoka', NULL),
(8485, 'CA.08.6087883', 'Regional Municipality of Niagara', 'Regional Municipality of Niagara', NULL),
(8486, 'CA.08.6088501', 'Nipissing District', 'Nipissing District', NULL),
(8487, 'CA.08.6090772', 'Northumberland County', 'Northumberland County', NULL),
(8488, 'CA.08.6095780', 'Oxford County', 'Oxford County', NULL),
(8489, 'CA.08.6098746', 'Parry Sound District', 'Parry Sound District', NULL),
(8490, 'CA.08.6100475', 'Peel', 'Peel', NULL),
(8491, 'CA.08.6101545', 'Perth County', 'Perth County', NULL),
(8492, 'CA.08.6101646', 'Peterborough County', 'Peterborough County', NULL),
(8493, 'CA.08.6113354', 'Prince Edward County', 'Prince Edward County', NULL),
(8494, 'CA.08.6116135', 'Rainy River District', 'Rainy River District', NULL),
(8495, 'CA.08.6119449', 'Renfrew County', 'Renfrew County', NULL),
(8496, 'CA.08.6147963', 'Simcoe County', 'Simcoe County', NULL),
(8497, 'CA.08.6158840', 'Sudbury', 'Sudbury', NULL),
(8498, 'CA.08.6158841', 'Sudbury', 'Sudbury', NULL),
(8499, 'CA.08.6166139', 'Thunder Bay District', 'Thunder Bay District', NULL),
(8500, 'CA.08.6166724', 'Timiskaming District', 'Timiskaming District', NULL),
(8501, 'CA.08.6172001', 'United Counties of Leeds and Grenville', 'United Counties of Leeds and Grenville', NULL),
(8502, 'CA.08.6172002', 'Comtés unis de Prescott et Russell', 'Comtes unis de Prescott et Russell', NULL),
(8503, 'CA.08.6172003', 'United Counties of Stormont, Dundas and Glengarry', 'United Counties of Stormont, Dundas and Glengarry', NULL),
(8504, 'CA.08.6176824', 'Regional Municipality of Waterloo', 'Regional Municipality of Waterloo', NULL),
(8505, 'CA.08.6177913', 'Wellington County', 'Wellington County', NULL),
(8506, 'CA.08.6185560', 'York', 'York', NULL),
(8507, 'CA.08.8133394', 'Toronto county', 'Toronto county', NULL),
(8508, 'CA.08.8581623', 'Ottawa', 'Ottawa', NULL),
(8509, 'CA.09.1101', 'Kings County', 'Kings County', NULL),
(8510, 'CA.09.1102', 'Queens County', 'Queens County', NULL),
(8511, 'CA.09.1103', 'Prince County', 'Prince County', NULL),
(8512, 'CA.10.01', 'Bas-Saint-Laurent', 'Bas-Saint-Laurent', NULL),
(8513, 'CA.10.02', 'Saguenay/Lac-Saint-Jean', 'Saguenay/Lac-Saint-Jean', NULL),
(8514, 'CA.10.03', 'Capitale-Nationale', 'Capitale-Nationale', NULL),
(8515, 'CA.10.04', 'Mauricie', 'Mauricie', NULL),
(8516, 'CA.10.05', 'Estrie', 'Estrie', NULL),
(8517, 'CA.10.06', 'Montréal', 'Montreal', NULL),
(8518, 'CA.10.07', 'Outaouais', 'Outaouais', NULL),
(8519, 'CA.10.08', 'Abitibi-Témiscamingue', 'Abitibi-Temiscamingue', NULL),
(8520, 'CA.10.09', 'Côte-Nord', 'Cote-Nord', NULL),
(8521, 'CA.10.10', 'Nord-du-Québec', 'Nord-du-Quebec', NULL),
(8522, 'CA.10.11', 'Gaspésie-Îles-de-la-Madeleine', 'Gaspesie-Iles-de-la-Madeleine', NULL),
(8523, 'CA.10.12', 'Chaudière-Appalaches', 'Chaudiere-Appalaches', NULL),
(8524, 'CA.10.13', 'Laval', 'Laval', NULL),
(8525, 'CA.10.14', 'Lanaudière', 'Lanaudiere', NULL),
(8526, 'CA.10.15', 'Laurentides', 'Laurentides', NULL),
(8527, 'CA.10.16', 'Montérégie', 'Monteregie', NULL),
(8528, 'CA.10.17', 'Centre-du-Québec', 'Centre-du-Quebec', NULL),
(8529, 'CA.10.6074643', 'Minganie', 'Minganie', NULL);



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

INSERT INTO `cities` (`id`, `country_code`, `name`, `asciiname`, `latitude`, `longitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES
(5881791, 'CA', 'Abbotsford', 'Abbotsford', -122.253, 49.058, 'P', 'PPL', '02', '5957659', 151683, 'America/Vancouver', 1, NULL, NULL),
(5882142, 'CA', 'Acton Vale', 'Acton Vale', -72.5658, 45.6501, 'P', 'PPL', '10', '16', 5135, 'America/Toronto', 1, NULL, NULL),
(5882799, 'CA', 'Airdrie', 'Airdrie', -114.035, 51.3001, 'P', 'PPL', '01', '', 24673, 'America/Edmonton', 1, NULL, NULL),
(5882873, 'CA', 'Ajax', 'Ajax', -79.0329, 43.8501, 'P', 'PPL', '08', '', 90167, 'America/Toronto', 1, NULL, NULL),
(5884083, 'CA', 'Alma', 'Alma', -71.6491, 48.5501, 'P', 'PPL', '10', '02', 29526, 'America/Toronto', 1, NULL, NULL),
(5884467, 'CA', 'Amherst', 'Amherst', -64.1987, 45.8335, 'P', 'PPL', '07', '', 9336, 'America/Halifax', 1, NULL, NULL),
(5884473, 'CA', 'Amherstburg', 'Amherstburg', -83.0499, 42.1168, 'P', 'PPL', '08', '', 11459, 'America/Toronto', 1, NULL, NULL),
(5884588, 'CA', 'Amos', 'Amos', -78.1162, 48.5669, 'P', 'PPL', '10', '08', 17918, 'America/Toronto', 1, NULL, NULL),
(5885280, 'CA', 'Angus', 'Angus', -79.8829, 44.3168, 'P', 'PPLL', '08', '', 10269, 'America/Toronto', 1, NULL, NULL),
(5885383, 'CA', 'Anmore', 'Anmore', -122.853, 49.3164, 'P', 'PPL', '02', '5915', 126456, 'America/Vancouver', 1, NULL, NULL),
(5886182, 'CA', 'Antigonish', 'Antigonish', -61.9986, 45.6169, 'P', 'PPL', '07', '', 5003, 'America/Halifax', 1, NULL, NULL),
(5887214, 'CA', 'Arnprior', 'Arnprior', -76.3494, 45.4334, 'P', 'PPL', '08', '', 9607, 'America/Toronto', 1, NULL, NULL),
(5887470, 'CA', 'Asbestos', 'Asbestos', -71.9324, 45.7668, 'P', 'PPL', '10', '05', 7190, 'America/Toronto', 1, NULL, NULL),
(5888716, 'CA', 'Aylmer', 'Aylmer', -80.983, 42.7668, 'P', 'PPL', '08', '', 7527, 'America/Toronto', 1, NULL, NULL),
(5889745, 'CA', 'Baie-Comeau', 'Baie-Comeau', -68.1489, 49.2168, 'P', 'PPL', '10', '09', 29808, 'America/Toronto', 1, NULL, NULL),
(5892532, 'CA', 'Banff', 'Banff', -115.57, 51.1762, 'P', 'PPL', '01', '', 7502, 'America/Edmonton', 1, NULL, NULL),
(5894171, 'CA', 'Barrie', 'Barrie', -79.6663, 44.4001, 'P', 'PPL', '08', '', 182041, 'America/Toronto', 1, NULL, NULL),
(5895424, 'CA', 'Bay Roberts', 'Bay Roberts', -53.2648, 47.5999, 'P', 'PPL', '05', '', 13737, 'America/St_Johns', 1, NULL, NULL),
(5895650, 'CA', 'Beaconsfield', 'Beaconsfield', -73.8659, 45.4334, 'P', 'PPL', '10', '', 19194, 'America/Toronto', 1, NULL, NULL),
(5896495, 'CA', 'Beauharnois', 'Beauharnois', -73.8725, 45.3134, 'P', 'PPL', '10', '16', 11918, 'America/Toronto', 1, NULL, NULL),
(5896522, 'CA', 'Beaumont', 'Beaumont', -113.419, 53.3501, 'P', 'PPL', '01', '', 7366, 'America/Edmonton', 1, NULL, NULL),
(5897209, 'CA', 'Bécancour', 'Becancour', -72.4324, 46.3334, 'P', 'PPL', '10', '04', 11134, 'America/Toronto', 1, NULL, NULL),
(5897884, 'CA', 'Belleville', 'Belleville', -77.3828, 44.1668, 'P', 'PPL', '08', '', 49454, 'America/Toronto', 1, NULL, NULL),
(5898070, 'CA', 'Bells Corners', 'Bells Corners', -75.8301, 45.3159, 'P', 'PPL', '08', '', 9977, 'America/Toronto', 1, NULL, NULL),
(5898138, 'CA', 'Beloeil', 'Beloeil', -73.1992, 45.5668, 'P', 'PPL', '10', '16', 18927, 'America/Toronto', 1, NULL, NULL),
(5903510, 'CA', 'Blainville', 'Blainville', -73.8825, 45.6668, 'P', 'PPL', '10', '15', 46493, 'America/Toronto', 1, NULL, NULL),
(5904501, 'CA', 'Bluewater', 'Bluewater', -81.5998, 43.4668, 'P', 'PPL', '08', '', 7044, 'America/Toronto', 1, NULL, NULL),
(5905132, 'CA', 'Boisbriand', 'Boisbriand', -73.8325, 45.6168, 'P', 'PPL', '10', '15', 26483, 'America/Toronto', 1, NULL, NULL),
(5905152, 'CA', 'Bois-des-Filion', 'Bois-des-Filion', -73.7492, 45.6668, 'P', 'PPL', '10', '', 8383, 'America/Toronto', 1, NULL, NULL),
(5905616, 'CA', 'Bonnyville', 'Bonnyville', -110.735, 54.2668, 'P', 'PPL', '01', '', 6003, 'America/Edmonton', 1, NULL, NULL),
(5906267, 'CA', 'Boucherville', 'Boucherville', -73.4361, 45.591, 'P', 'PPL', '10', '16', 39062, 'America/Toronto', 1, NULL, NULL),
(5907092, 'CA', 'Bracebridge', 'Bracebridge', -79.3163, 45.0334, 'P', 'PPL', '08', '', 8238, 'America/Toronto', 1, NULL, NULL),
(5907180, 'CA', 'Bradford West Gwillimbury', 'Bradford West Gwillimbury', -79.6163, 44.1168, 'P', 'PPL', '08', '', 18811, 'America/Toronto', 1, NULL, NULL),
(5907364, 'CA', 'Brampton', 'Brampton', -79.7663, 43.6834, 'P', 'PPL', '08', '', 433806, 'America/Toronto', 1, NULL, NULL),
(5907896, 'CA', 'Brandon', 'Brandon', -99.9531, 49.8469, 'P', 'PPL', '03', '', 26234, 'America/Winnipeg', 1, NULL, NULL),
(5907983, 'CA', 'Brant', 'Brant', -80.3497, 43.1334, 'P', 'PPL', '08', '', 34415, 'America/Toronto', 1, NULL, NULL),
(5907990, 'CA', 'Brantford', 'Brantford', -80.2664, 43.1334, 'P', 'PPL', '08', '', 87759, 'America/Toronto', 1, NULL, NULL),
(5908723, 'CA', 'Bridgewater', 'Bridgewater', -64.5188, 44.3786, 'P', 'PPL', '07', '', 8070, 'America/Halifax', 1, NULL, NULL),
(5909294, 'CA', 'Brockville', 'Brockville', -75.687, 44.5913, 'P', 'PPL', '08', '', 23886, 'America/Toronto', 1, NULL, NULL),
(5909403, 'CA', 'Bromont', 'Bromont', -72.6491, 45.3168, 'P', 'PPL', '10', '16', 6049, 'America/Toronto', 1, NULL, NULL),
(5909514, 'CA', 'Brooks', 'Brooks', -111.885, 50.5834, 'P', 'PPL', '01', '', 12744, 'America/Edmonton', 1, NULL, NULL),
(5909629, 'CA', 'Brossard', 'Brossard', -73.4658, 45.4501, 'P', 'PPL', '10', '16', 69575, 'America/Toronto', 1, NULL, NULL),
(5909969, 'CA', 'Brownsburg-Chatham', 'Brownsburg-Chatham', -74.4159, 45.6834, 'P', 'PPL', '10', '15', 6664, 'America/Toronto', 1, NULL, NULL),
(5911592, 'CA', 'Burlington', 'Burlington', -79.8371, 43.3862, 'P', 'PPL', '08', '', 164415, 'America/Toronto', 1, NULL, NULL),
(5911606, 'CA', 'Burnaby', 'Burnaby', -122.953, 49.2664, 'P', 'PPL', '02', '', 202799, 'America/Vancouver', 1, NULL, NULL),
(5913490, 'CA', 'Calgary', 'Calgary', -114.085, 51.0501, 'P', 'PPL', '01', '', 1019942, 'America/Edmonton', 1, NULL, NULL),
(5913695, 'CA', 'Cambridge', 'Cambridge', -80.3127, 43.3601, 'P', 'PPL', '08', '', 120372, 'America/Toronto', 1, NULL, NULL),
(5913934, 'CA', 'Camlachie', 'Camlachie', -82.1616, 43.036, 'P', 'PPL', '08', '', 7506, 'America/Toronto', 1, NULL, NULL),
(5914132, 'CA', 'Campbell River', 'Campbell River', -125.245, 50.0163, 'P', 'PPL', '02', '', 33430, 'America/Vancouver', 1, NULL, NULL),
(5914653, 'CA', 'Camrose', 'Camrose', -112.835, 53.0168, 'P', 'PPL', '01', '', 15686, 'America/Edmonton', 1, NULL, NULL),
(5914826, 'CA', 'Candiac', 'Candiac', -73.5159, 45.3834, 'P', 'PPL', '10', '16', 15947, 'America/Toronto', 1, NULL, NULL),
(5914894, 'CA', 'Canmore', 'Canmore', -115.352, 51.0834, 'P', 'PPL', '01', '', 12288, 'America/Edmonton', 1, NULL, NULL),
(5916722, 'CA', 'Carbonear', 'Carbonear', -53.2148, 47.7332, 'P', 'PPL', '05', '', 6814, 'America/St_Johns', 1, NULL, NULL),
(5917117, 'CA', 'Carignan', 'Carignan', -73.2992, 45.4501, 'P', 'PPL', '10', '16', 7426, 'America/Toronto', 1, NULL, NULL),
(5917158, 'CA', 'Carleton Place', 'Carleton Place', -76.1494, 45.1334, 'P', 'PPL', '08', '', 9743, 'America/Toronto', 1, NULL, NULL),
(5918118, 'CA', 'Castlegar', 'Castlegar', -117.669, 49.2998, 'P', 'PPL', '02', '', 8715, 'America/Vancouver', 1, NULL, NULL),
(5919566, 'CA', 'Chambly', 'Chambly', -73.2825, 45.4501, 'P', 'PPL', '10', '16', 22608, 'America/Toronto', 1, NULL, NULL),
(5920089, 'CA', 'Charlemagne', 'Charlemagne', -73.4825, 45.7168, 'P', 'PPL', '10', '14', 5594, 'America/Toronto', 1, NULL, NULL),
(5920288, 'CA', 'Charlottetown', 'Charlottetown', -63.1267, 46.2352, 'P', 'PPLA', '09', '', 42402, 'America/Halifax', 1, NULL, NULL),
(5920433, 'CA', 'Châteauguay', 'Chateauguay', -73.7492, 45.3834, 'P', 'PPL', '10', '16', 42786, 'America/Toronto', 1, NULL, NULL),
(5921147, 'CA', 'Chibougamau', 'Chibougamau', -74.3659, 49.9168, 'P', 'PPL', '10', '10', 7563, 'America/Toronto', 1, NULL, NULL),
(5921356, 'CA', 'Chilliwack', 'Chilliwack', -121.953, 49.1664, 'P', 'PPLA2', '02', '5909', 77000, 'America/Vancouver', 1, NULL, NULL),
(5923101, 'CA', 'Clarence-Rockland', 'Clarence-Rockland', -75.291, 45.5501, 'P', 'PPL', '08', '', 20790, 'America/Toronto', 1, NULL, NULL),
(5924417, 'CA', 'Coaldale', 'Coaldale', -112.619, 49.7167, 'P', 'PPL', '01', '', 6317, 'America/Edmonton', 1, NULL, NULL),
(5924500, 'CA', 'Coaticook', 'Coaticook', -71.7991, 45.1334, 'P', 'PPL', '10', '05', 7021, 'America/Toronto', 1, NULL, NULL),
(5924579, 'CA', 'Cobourg', 'Cobourg', -78.1652, 43.9598, 'P', 'PPL', '08', '', 18099, 'America/Toronto', 1, NULL, NULL),
(5924618, 'CA', 'Cochrane', 'Cochrane', -114.469, 51.1834, 'P', 'PPL', '01', '', 16365, 'America/Edmonton', 1, NULL, NULL),
(5925024, 'CA', 'Cold Lake', 'Cold Lake', -110.182, 54.4652, 'P', 'PPL', '01', '', 11595, 'America/Edmonton', 1, NULL, NULL),
(5925975, 'CA', 'Collingwood', 'Collingwood', -80.2164, 44.4834, 'P', 'PPL', '08', '', 15809, 'America/Toronto', 1, NULL, NULL),
(5926268, 'CA', 'Colwood', 'Colwood', -123.486, 48.4329, 'P', 'PPL', '02', '', 14687, 'America/Vancouver', 1, NULL, NULL),
(5926511, 'CA', 'Conception Bay South', 'Conception Bay South', -52.9981, 47.4999, 'P', 'PPL', '05', '', 17087, 'America/St_Johns', 1, NULL, NULL),
(5926526, 'CA', 'Concord', 'Concord', -79.4829, 43.8001, 'P', 'PPL', '08', '', 8255, 'America/Toronto', 1, NULL, NULL),
(5927689, 'CA', 'Coquitlam', 'Coquitlam', -122.753, 49.283, 'P', 'PPL', '02', '', 114565, 'America/Vancouver', 1, NULL, NULL),
(5927969, 'CA', 'Corner Brook', 'Corner Brook', -57.952, 48.95, 'P', 'PPL', '05', '', 18693, 'America/St_Johns', 1, NULL, NULL),
(5928065, 'CA', 'Cornwall', 'Cornwall', -74.7281, 45.0181, 'P', 'PPL', '08', '', 48821, 'America/Toronto', 1, NULL, NULL),
(5928488, 'CA', 'Côte-Saint-Luc', 'Cote-Saint-Luc', -73.6658, 45.4654, 'P', 'PPL', '10', '', 31395, 'America/Toronto', 1, NULL, NULL),
(5930890, 'CA', 'Courtenay', 'Courtenay', -124.994, 49.6866, 'P', 'PPL', '02', '', 32793, 'America/Vancouver', 1, NULL, NULL),
(5931074, 'CA', 'Cowansville', 'Cowansville', -72.7491, 45.2001, 'P', 'PPL', '10', '16', 10887, 'America/Toronto', 1, NULL, NULL),
(5931800, 'CA', 'Cranbrook', 'Cranbrook', -115.769, 49.4999, 'P', 'PPL', '02', '', 18610, 'America/Edmonton', 1, NULL, NULL),
(5935277, 'CA', 'Dartmouth', 'Dartmouth', -63.5772, 44.6713, 'P', 'PPL', '07', '', 101343, 'America/Halifax', 1, NULL, NULL),
(5935341, 'CA', 'Dauphin', 'Dauphin', -100.05, 51.1494, 'P', 'PPL', '03', '', 8418, 'America/Winnipeg', 1, NULL, NULL),
(5935804, 'CA', 'Dawson Creek', 'Dawson Creek', -120.24, 55.7598, 'P', 'PPL', '02', '5955', 10802, 'America/Dawson_Creek', 1, NULL, NULL),
(5937612, 'CA', 'Delson', 'Delson', -73.5492, 45.3668, 'P', 'PPL', '10', '16', 7322, 'America/Toronto', 1, NULL, NULL),
(5937615, 'CA', 'Delta', 'Delta', -122.907, 49.144, 'P', 'PPL', '02', '', 101668, 'America/Vancouver', 1, NULL, NULL),
(5938513, 'CA', 'Deux-Montagnes', 'Deux-Montagnes', -73.9017, 45.5345, 'P', 'PPL', '10', '15', 17402, 'America/Toronto', 1, NULL, NULL),
(5938801, 'CA', 'Devon', 'Devon', -113.735, 53.3668, 'P', 'PPL', '01', '', 5225, 'America/Edmonton', 1, NULL, NULL),
(5939219, 'CA', 'Dieppe', 'Dieppe', -64.6873, 46.0784, 'P', 'PPL', '04', '', 18565, 'America/Moncton', 1, NULL, NULL),
(5940934, 'CA', 'Dolbeau-Mistassini', 'Dolbeau-Mistassini', -72.2314, 48.8786, 'P', 'PPL', '10', '02', 12916, 'America/Toronto', 1, NULL, NULL),
(5940956, 'CA', 'Dollard-Des Ormeaux', 'Dollard-Des Ormeaux', -73.8242, 45.4945, 'P', 'PPL', '10', '', 48930, 'America/Toronto', 1, NULL, NULL),
(5941761, 'CA', 'Dorchester', 'Dorchester', -81.0664, 42.9834, 'P', 'PPL', '08', '', 9329, 'America/Toronto', 1, NULL, NULL),
(5941925, 'CA', 'Dorval', 'Dorval', -73.7533, 45.4473, 'P', 'PPL', '10', '', 18088, 'America/Toronto', 1, NULL, NULL),
(5942547, 'CA', 'Drayton Valley', 'Drayton Valley', -114.985, 53.2168, 'P', 'PPL', '01', '', 6099, 'America/Edmonton', 1, NULL, NULL),
(5942845, 'CA', 'Drummondville', 'Drummondville', -72.4824, 45.8834, 'P', 'PPL', '10', '17', 59489, 'America/Toronto', 1, NULL, NULL),
(5942913, 'CA', 'Dryden', 'Dryden', -92.7503, 49.7833, 'P', 'PPL', '08', '', 8195, 'America/Winnipeg', 1, NULL, NULL),
(5943865, 'CA', 'Duncan', 'Duncan', -123.703, 48.7829, 'P', 'PPL', '02', '', 22199, 'America/Vancouver', 1, NULL, NULL),
(5946768, 'CA', 'Edmonton', 'Edmonton', -113.469, 53.5501, 'P', 'PPLA', '01', '', 712391, 'America/Edmonton', 1, NULL, NULL),
(5946820, 'CA', 'Edson', 'Edson', -116.436, 53.5835, 'P', 'PPL', '01', '', 7975, 'America/Edmonton', 1, NULL, NULL),
(5947866, 'CA', 'Elliot Lake', 'Elliot Lake', -82.6331, 46.3834, 'P', 'PPL', '08', '', 12508, 'America/Toronto', 1, NULL, NULL),
(5949568, 'CA', 'Estevan', 'Estevan', -102.984, 49.1334, 'P', 'PPL', '11', '', 9904, 'America/Regina', 1, NULL, NULL),
(5950267, 'CA', 'Etobicoke', 'Etobicoke', -79.5671, 43.6542, 'P', 'PPL', '08', '', 347948, 'America/Toronto', 1, NULL, NULL),
(5951644, 'CA', 'Farnham', 'Farnham', -72.9824, 45.2834, 'P', 'PPL', '10', '16', 6061, 'America/Toronto', 1, NULL, NULL),
(5952370, 'CA', 'Fernie', 'Fernie', -115.069, 49.5, 'P', 'PPL', '02', '', 5019, 'America/Edmonton', 1, NULL, NULL),
(5954718, 'CA', 'Flin Flon', 'Flin Flon', -101.865, 54.7682, 'P', 'PPL', '03', '', 6002, 'America/Winnipeg', 1, NULL, NULL),
(5955815, 'CA', 'Fort Erie', 'Fort Erie', -78.9329, 42.9001, 'P', 'PPL', '08', '', 15953, 'America/Toronto', 1, NULL, NULL),
(5955826, 'CA', 'Fort Frances', 'Fort Frances', -93.4003, 48.5999, 'P', 'PPL', '08', '', 7931, 'America/Winnipeg', 1, NULL, NULL),
(5955895, 'CA', 'Fort McMurray', 'Fort McMurray', -111.381, 56.7268, 'P', 'PPL', '01', '', 76000, 'America/Edmonton', 1, NULL, NULL),
(5955948, 'CA', 'Fort Saskatchewan', 'Fort Saskatchewan', -113.219, 53.7168, 'P', 'PPL', '01', '', 14957, 'America/Edmonton', 1, NULL, NULL),
(5955960, 'CA', 'Fort St. John', 'Fort St. John', -120.853, 56.2499, 'P', 'PPL', '02', '', 17402, 'America/Dawson_Creek', 1, NULL, NULL),
(5957776, 'CA', 'Fredericton', 'Fredericton', -66.6656, 45.9454, 'P', 'PPLA', '04', '', 52337, 'America/Moncton', 1, NULL, NULL),
(5959326, 'CA', 'Gananoque', 'Gananoque', -76.1661, 44.3334, 'P', 'PPL', '08', '', 5458, 'America/Toronto', 1, NULL, NULL),
(5959878, 'CA', 'Gaspé', 'Gaspe', -64.4819, 48.8334, 'P', 'PPL', '10', '11', 14819, 'America/Toronto', 1, NULL, NULL),
(5959974, 'CA', 'Gatineau', 'Gatineau', -75.7016, 45.4772, 'P', 'PPL', '10', '07', 242124, 'America/Toronto', 1, NULL, NULL),
(5960971, 'CA', 'Gibsons', 'Gibsons', -123.506, 49.3954, 'P', 'PPL', '02', '5929', 6821, 'America/Vancouver', 1, NULL, NULL),
(5961564, 'CA', 'Glace Bay', 'Glace Bay', -59.957, 46.1969, 'P', 'PPL', '07', '', 19968, 'America/Glace_Bay', 1, NULL, NULL),
(5962442, 'CA', 'Goderich', 'Goderich', -81.7165, 43.7501, 'P', 'PPL', '08', '', 8032, 'America/Toronto', 1, NULL, NULL),
(5964215, 'CA', 'Granby', 'Granby', -72.7324, 45.4001, 'P', 'PPL', '10', '16', 53979, 'America/Toronto', 1, NULL, NULL),
(5964347, 'CA', 'Grande Prairie', 'Grande Prairie', -118.803, 55.1667, 'P', 'PPL', '01', '', 41462, 'America/Edmonton', 1, NULL, NULL),
(5964378, 'CA', 'Grand Falls-Windsor', 'Grand Falls-Windsor', -55.6649, 48.9332, 'P', 'PPL', '05', '', 12076, 'America/St_Johns', 1, NULL, NULL),
(5964700, 'CA', 'Greater Sudbury', 'Greater Sudbury', -80.99, 46.49, 'P', 'PPL', '08', '', 157857, 'America/Toronto', 1, NULL, NULL),
(5965546, 'CA', 'Gravenhurst', 'Gravenhurst', -79.3663, 44.9168, 'P', 'PPL', '08', '', 5839, 'America/Toronto', 1, NULL, NULL),
(5965812, 'CA', 'Greater Napanee', 'Greater Napanee', -76.9494, 44.2501, 'P', 'PPL', '08', '', 15132, 'America/Toronto', 1, NULL, NULL),
(5966689, 'CA', 'Greenwood', 'Greenwood', -64.9317, 44.9741, 'P', 'PPL', '07', '', 6915, 'America/Halifax', 1, NULL, NULL),
(5967629, 'CA', 'Guelph', 'Guelph', -80.256, 43.5459, 'P', 'PPL', '08', '6177913', 115760, 'America/Toronto', 1, NULL, NULL),
(5969782, 'CA', 'Hamilton', 'Hamilton', -79.8496, 43.2501, 'P', 'PPL', '08', '', 519949, 'America/Toronto', 1, NULL, NULL),
(5970014, 'CA', 'Hampstead', 'Hampstead', -73.6631, 45.4806, 'P', 'PPL', '10', '', 6996, 'America/Toronto', 1, NULL, NULL),
(5970063, 'CA', 'Hanceville', 'Hanceville', -123.045, 51.9192, 'P', 'PPLL', '02', '', 10000, 'America/Vancouver', 1, NULL, NULL),
(5970301, 'CA', 'Hanover', 'Hanover', -81.033, 44.1501, 'P', 'PPL', '08', '', 7255, 'America/Toronto', 1, NULL, NULL),
(5970458, 'CA', 'Happy Valley-Goose Bay', 'Happy Valley-Goose Bay', -60.3315, 53.3168, 'P', 'PPL', '05', '', 7572, 'America/Goose_Bay', 1, NULL, NULL),
(5972360, 'CA', 'Hawkesbury', 'Hawkesbury', -74.616, 45.6001, 'P', 'PPL', '08', '', 12283, 'America/Toronto', 1, NULL, NULL),
(5975038, 'CA', 'High River', 'High River', -113.869, 50.5834, 'P', 'PPL', '01', '', 9826, 'America/Edmonton', 1, NULL, NULL),
(5975503, 'CA', 'Hinton', 'Hinton', -117.586, 53.4001, 'P', 'PPL', '01', '', 9889, 'America/Edmonton', 1, NULL, NULL),
(5978126, 'CA', 'Hudson', 'Hudson', -74.1492, 45.4501, 'P', 'PPL', '10', '16', 5088, 'America/Toronto', 1, NULL, NULL),
(5978765, 'CA', 'Huntsville', 'Huntsville', -79.2163, 45.3334, 'P', 'PPL', '08', '', 19579, 'America/Toronto', 1, NULL, NULL),
(5978831, 'CA', 'Huron East', 'Huron East', -81.2998, 43.6168, 'P', 'PPL', '08', '', 9264, 'America/Toronto', 1, NULL, NULL),
(5983175, 'CA', 'Ingersoll', 'Ingersoll', -80.883, 43.0334, 'P', 'PPL', '08', '', 11874, 'America/Toronto', 1, NULL, NULL),
(5983433, 'CA', 'Innisfil', 'Innisfil', -79.6496, 44.3001, 'P', 'PPL', '08', '', 7345, 'America/Toronto', 1, NULL, NULL),
(5983720, 'CA', 'Iqaluit', 'Iqaluit', -68.5173, 63.747, 'P', 'PPLA', '14', '', 6124, 'America/Iqaluit', 1, NULL, NULL),
(5987650, 'CA', 'Joliette', 'Joliette', -73.4492, 46.0168, 'P', 'PPL', '10', '14', 34772, 'America/Toronto', 1, NULL, NULL),
(5989045, 'CA', 'Kamloops', 'Kamloops', -120.319, 50.6665, 'P', 'PPL', '02', '', 68714, 'America/Vancouver', 1, NULL, NULL),
(5989403, 'CA', 'Kapuskasing', 'Kapuskasing', -82.4331, 49.4169, 'P', 'PPL', '08', '', 9240, 'America/Toronto', 1, NULL, NULL),
(5990579, 'CA', 'Kelowna', 'Kelowna', -119.486, 49.8831, 'P', 'PPL', '02', '', 125109, 'America/Vancouver', 1, NULL, NULL),
(5991148, 'CA', 'Kentville', 'Kentville', -64.496, 45.0771, 'P', 'PPL', '07', '1207', 12636, 'America/Halifax', 1, NULL, NULL),
(5991370, 'CA', 'Keswick', 'Keswick', -79.4663, 44.2501, 'P', 'PPLX', '08', '', 21000, 'America/Toronto', 1, NULL, NULL),
(5992059, 'CA', 'Kimberley', 'Kimberley', -115.978, 49.6707, 'P', 'PPL', '02', '5901', 6513, 'America/Edmonton', 1, NULL, NULL),
(5992500, 'CA', 'Kingston', 'Kingston', -76.481, 44.2298, 'P', 'PPL', '08', '', 114195, 'America/Toronto', 1, NULL, NULL),
(5992830, 'CA', 'Kirkland', 'Kirkland', -73.8659, 45.4501, 'P', 'PPL', '10', '', 20491, 'America/Toronto', 1, NULL, NULL),
(5992836, 'CA', 'Kirkland Lake', 'Kirkland Lake', -80.0377, 48.1446, 'P', 'PPL', '08', '', 7775, 'America/Toronto', 1, NULL, NULL),
(5992996, 'CA', 'Kitchener', 'Kitchener', -80.5112, 43.4254, 'P', 'PPL', '08', '', 233700, 'America/Toronto', 1, NULL, NULL),
(5993072, 'CA', 'Kitimat', 'Kitimat', -128.653, 54.0524, 'P', 'PPL', '02', '', 8987, 'America/Vancouver', 1, NULL, NULL),
(5994839, 'CA', 'Labrador City', 'Labrador City', -66.9114, 52.9463, 'P', 'PPL', '05', '', 10313, 'America/Goose_Bay', 1, NULL, NULL),
(6002133, 'CA', 'Lac-Brome', 'Lac-Brome', -72.5158, 45.2168, 'P', 'PPL', '10', '16', 5629, 'America/Toronto', 1, NULL, NULL),
(6024829, 'CA', 'Lachute', 'Lachute', -74.3325, 45.6501, 'P', 'PPL', '10', '15', 9562, 'America/Toronto', 1, NULL, NULL),
(6035615, 'CA', 'Lacombe', 'Lacombe', -113.735, 52.4668, 'P', 'PPL', '01', '', 10059, 'America/Edmonton', 1, NULL, NULL),
(6047817, 'CA', 'Ladysmith', 'Ladysmith', -123.817, 48.9902, 'P', 'PPL', '02', '5919', 8740, 'America/Vancouver', 1, NULL, NULL),
(6049024, 'CA', 'Lambton Shores', 'Lambton Shores', -81.9331, 43.1668, 'P', 'PPL', '08', '', 10656, 'America/Toronto', 1, NULL, NULL),
(6049388, 'CA', 'Langford', 'Langford', -123.503, 48.4496, 'P', 'PPL', '02', '', 22459, 'America/Vancouver', 1, NULL, NULL),
(6049429, 'CA', 'Langley', 'Langley', -122.659, 49.1011, 'P', 'PPL', '02', '', 23606, 'America/Vancouver', 1, NULL, NULL),
(6049430, 'CA', 'Langley', 'Langley', -122.586, 49.083, 'P', 'PPL', '02', '', 93726, 'America/Vancouver', 1, NULL, NULL),
(6049863, 'CA', 'La Prairie', 'La Prairie', -73.4992, 45.4168, 'P', 'PPL', '10', '16', 21763, 'America/Toronto', 1, NULL, NULL),
(6050194, 'CA', 'La Sarre', 'La Sarre', -79.1996, 48.8002, 'P', 'PPL', '10', '08', 7206, 'America/Toronto', 1, NULL, NULL),
(6050263, 'CA', 'L''Assomption', 'L''Assomption', -73.4294, 45.8232, 'P', 'PPL', '10', '14', 16738, 'America/Toronto', 1, NULL, NULL),
(6050416, 'CA', 'La Tuque', 'La Tuque', -72.7824, 47.4334, 'P', 'PPL', '10', '04', 9503, 'America/Toronto', 1, NULL, NULL),
(6050610, 'CA', 'Laval', 'Laval', -73.692, 45.57, 'P', 'PPL', '10', '13', 376845, 'America/Toronto', 1, NULL, NULL),
(6050650, 'CA', 'Lavaltrie', 'Lavaltrie', -73.2824, 45.8834, 'P', 'PPL', '10', '14', 8762, 'America/Toronto', 1, NULL, NULL),
(6051562, 'CA', 'Leduc', 'Leduc', -113.552, 53.2668, 'P', 'PPL', '01', '', 15561, 'America/Edmonton', 1, NULL, NULL),
(6052788, 'CA', 'Les Coteaux', 'Les Coteaux', -74.2325, 45.2834, 'P', 'PPL', '10', '16', 10622, 'America/Toronto', 1, NULL, NULL),
(6053154, 'CA', 'Lethbridge', 'Lethbridge', -112.819, 49.7, 'P', 'PPL', '01', '', 70617, 'America/Edmonton', 1, NULL, NULL),
(6053877, 'CA', 'L''Île-Perrot', 'L''Ile-Perrot', -73.9492, 45.3834, 'P', 'PPL', '10', '16', 9927, 'America/Toronto', 1, NULL, NULL),
(6058024, 'CA', 'Lloydminster', 'Lloydminster', -110.002, 53.2835, 'P', 'PPL', '11', '', 15910, 'America/Edmonton', 1, NULL, NULL),
(6058560, 'CA', 'London', 'London', -81.233, 42.9834, 'P', 'PPL', '08', '', 346765, 'America/Toronto', 1, NULL, NULL),
(6059891, 'CA', 'Longueuil', 'Longueuil', -73.5181, 45.5312, 'P', 'PPL', '10', '16', 229330, 'America/Toronto', 1, NULL, NULL),
(6060407, 'CA', 'Lorraine', 'Lorraine', -73.7825, 45.6834, 'P', 'PPL', '10', '14', 9613, 'America/Toronto', 1, NULL, NULL),
(6060839, 'CA', 'Louiseville', 'Louiseville', -72.9415, 46.2559, 'P', 'PPL', '10', '04', 5819, 'America/Toronto', 1, NULL, NULL),
(6064180, 'CA', 'Magog', 'Magog', -72.1491, 45.2668, 'P', 'PPL', '10', '05', 15550, 'America/Toronto', 1, NULL, NULL),
(6065686, 'CA', 'Maple Ridge', 'Maple Ridge', -122.602, 49.2194, 'P', 'PPL', '02', '', 70000, 'America/Vancouver', 1, NULL, NULL),
(6066350, 'CA', 'Marieville', 'Marieville', -73.1658, 45.4334, 'P', 'PPL', '10', '16', 5600, 'America/Toronto', 1, NULL, NULL),
(6066513, 'CA', 'Markham', 'Markham', -79.2663, 43.8668, 'P', 'PPL', '08', '', 261573, 'America/Toronto', 1, NULL, NULL),
(6067494, 'CA', 'Mascouche', 'Mascouche', -73.5996, 45.7496, 'P', 'PPL', '10', '14', 34626, 'America/Toronto', 1, NULL, NULL),
(6071618, 'CA', 'Medicine Hat', 'Medicine Hat', -110.668, 50.0501, 'P', 'PPL', '01', '', 63138, 'America/Edmonton', 1, NULL, NULL),
(6071876, 'CA', 'Melfort', 'Melfort', -104.618, 52.8667, 'P', 'PPL', '11', '', 5410, 'America/Regina', 1, NULL, NULL),
(6072206, 'CA', 'Mercier', 'Mercier', -73.7492, 45.3168, 'P', 'PPL', '10', '16', 10121, 'America/Toronto', 1, NULL, NULL),
(6072350, 'CA', 'Merritt', 'Merritt', -120.794, 50.1123, 'P', 'PPL', '02', '', 7179, 'America/Vancouver', 1, NULL, NULL),
(6073363, 'CA', 'Midland', 'Midland', -79.883, 44.7501, 'P', 'PPL', '08', '', 31502, 'America/Toronto', 1, NULL, NULL),
(6074377, 'CA', 'Milton', 'Milton', -79.8829, 43.5168, 'P', 'PPLA2', '08', '5969719', 84362, 'America/Toronto', 1, NULL, NULL),
(6075061, 'CA', 'Mirabel', 'Mirabel', -74.0825, 45.6501, 'P', 'PPL', '10', '15', 34626, 'America/Toronto', 1, NULL, NULL),
(6075081, 'CA', 'Miramichi', 'Miramichi', -65.5019, 47.0289, 'P', 'PPL', '04', '1309', 18129, 'America/Moncton', 1, NULL, NULL),
(6075357, 'CA', 'Mississauga', 'Mississauga', -79.6583, 43.5789, 'P', 'PPL', '08', '', 668549, 'America/Toronto', 1, NULL, NULL),
(6076211, 'CA', 'Moncton', 'Moncton', -64.7965, 46.0945, 'P', 'PPL', '04', '1307', 87467, 'America/Moncton', 1, NULL, NULL),
(6077128, 'CA', 'Mont-Laurier', 'Mont-Laurier', -75.4993, 46.5501, 'P', 'PPL', '10', '15', 13405, 'America/Toronto', 1, NULL, NULL),
(6077243, 'CA', 'Montréal', 'Montreal', -73.5878, 45.5088, 'P', 'PPLA2', '10', '06', 1600000, 'America/Toronto', 1, NULL, NULL),
(6077265, 'CA', 'Montréal-Ouest', 'Montreal-Ouest', -73.6492, 45.4529, 'P', 'PPL', '10', '', 5184, 'America/Toronto', 1, NULL, NULL),
(6077315, 'CA', 'Mont-Royal', 'Mont-Royal', -73.6492, 45.5168, 'P', 'PPL', '10', '', 18933, 'America/Toronto', 1, NULL, NULL),
(6077340, 'CA', 'Mont-Saint-Hilaire', 'Mont-Saint-Hilaire', -73.1992, 45.5668, 'P', 'PPL', '10', '16', 15720, 'America/Toronto', 1, NULL, NULL),
(6077445, 'CA', 'Mont-Tremblant', 'Mont-Tremblant', -74.5844, 46.2127, 'P', 'PPL', '10', '15', 8892, 'America/Toronto', 1, NULL, NULL),
(6078112, 'CA', 'Moose Jaw', 'Moose Jaw', -105.534, 50.4001, 'P', 'PPL', '11', '', 32166, 'America/Regina', 1, NULL, NULL),
(6078447, 'CA', 'Morden', 'Morden', -98.1014, 49.1919, 'P', 'PPL', '03', '', 6395, 'America/Winnipeg', 1, NULL, NULL),
(6078636, 'CA', 'Morinville', 'Morinville', -113.652, 53.8001, 'P', 'PPL', '01', '', 8108, 'America/Edmonton', 1, NULL, NULL),
(6082231, 'CA', 'Mount Pearl', 'Mount Pearl', -52.7813, 47.5166, 'P', 'PPL', '05', '', 24671, 'America/St_Johns', 1, NULL, NULL),
(6085772, 'CA', 'Nanaimo', 'Nanaimo', -123.94, 49.1664, 'P', 'PPL', '02', '', 84905, 'America/Vancouver', 1, NULL, NULL),
(6086871, 'CA', 'Nelson', 'Nelson', -117.286, 49.4999, 'P', 'PPL', '02', '', 9813, 'America/Vancouver', 1, NULL, NULL),
(6087579, 'CA', 'New Glasgow', 'New Glasgow', -62.6486, 45.5834, 'P', 'PPL', '07', '', 20322, 'America/Halifax', 1, NULL, NULL),
(6087701, 'CA', 'Newmarket', 'Newmarket', -79.4663, 44.0501, 'P', 'PPL', '08', '', 74295, 'America/Toronto', 1, NULL, NULL),
(6087844, 'CA', 'New Westminster', 'New Westminster', -122.911, 49.2068, 'P', 'PPL', '02', '', 58549, 'America/Vancouver', 1, NULL, NULL),
(6087892, 'CA', 'Niagara Falls', 'Niagara Falls', -79.0663, 43.1001, 'P', 'PPL', '08', '', 82000, 'America/Toronto', 1, NULL, NULL),
(6088132, 'CA', 'Nicolet', 'Nicolet', -72.6158, 46.2168, 'P', 'PPL', '10', '04', 5257, 'America/Toronto', 1, NULL, NULL),
(6089125, 'CA', 'Norfolk County', 'Norfolk County', -80.383, 42.8334, 'P', 'PPL', '08', '', 60847, 'America/Toronto', 1, NULL, NULL),
(6089404, 'CA', 'North Battleford', 'North Battleford', -108.297, 52.7797, 'P', 'PPL', '11', '', 19440, 'America/Regina', 1, NULL, NULL),
(6089426, 'CA', 'North Bay', 'North Bay', -79.4663, 46.3168, 'P', 'PPL', '08', '6088501', 50170, 'America/Toronto', 1, NULL, NULL),
(6089661, 'CA', 'North Cowichan', 'North Cowichan', -123.686, 48.8413, 'P', 'PPL', '02', '', 32272, 'America/Vancouver', 1, NULL, NULL),
(6090405, 'CA', 'North Perth', 'North Perth', -80.9672, 43.7251, 'P', 'PPL', '08', '', 12254, 'America/Toronto', 1, NULL, NULL),
(6090579, 'CA', 'North Saanich', 'North Saanich', -123.419, 48.6663, 'P', 'PPL', '02', '', 11089, 'America/Vancouver', 1, NULL, NULL),
(6090785, 'CA', 'North Vancouver', 'North Vancouver', -123.069, 49.3164, 'P', 'PPL', '02', '5909', 48000, 'America/Vancouver', 1, NULL, NULL),
(6091104, 'CA', 'North York', 'North York', -79.4163, 43.7668, 'P', 'PPL', '08', '', 636000, 'America/Toronto', 1, NULL, NULL),
(6091369, 'CA', 'Notre-Dame-de-l''Île-Perrot', 'Notre-Dame-de-l''Ile-Perrot', -73.9325, 45.3668, 'P', 'PPL', '10', '16', 9885, 'America/Toronto', 1, NULL, NULL),
(6091422, 'CA', 'Notre-Dame-des-Prairies', 'Notre-Dame-des-Prairies', -73.4324, 46.0501, 'P', 'PPL', '10', '14', 8230, 'America/Toronto', 1, NULL, NULL),
(6091919, 'CA', 'Oak Bay', 'Oak Bay', -123.303, 48.4496, 'P', 'PPL', '02', '', 18015, 'America/Vancouver', 1, NULL, NULL),
(6092122, 'CA', 'Oakville', 'Oakville', -79.6829, 43.4501, 'P', 'PPL', '08', '', 165697, 'America/Toronto', 1, NULL, NULL),
(6093010, 'CA', 'Okotoks', 'Okotoks', -113.983, 50.7289, 'P', 'PPL', '01', '', 14826, 'America/Edmonton', 1, NULL, NULL),
(6093347, 'CA', 'Olds', 'Olds', -114.102, 51.7834, 'P', 'PPL', '01', '', 6947, 'America/Edmonton', 1, NULL, NULL),
(6094201, 'CA', 'Orangeville', 'Orangeville', -80.0997, 43.9168, 'P', 'PPL', '08', '', 32640, 'America/Toronto', 1, NULL, NULL),
(6094325, 'CA', 'Orillia', 'Orillia', -79.4207, 44.6087, 'P', 'PPL', '08', '', 30178, 'America/Toronto', 1, NULL, NULL),
(6094407, 'CA', 'Oromocto', 'Oromocto', -66.4792, 45.8351, 'P', 'PPL', '04', '', 8998, 'America/Moncton', 1, NULL, NULL),
(6094578, 'CA', 'Oshawa', 'Oshawa', -78.8496, 43.9001, 'P', 'PPL', '08', '', 247989, 'America/Toronto', 1, NULL, NULL),
(6094817, 'CA', 'Ottawa', 'Ottawa', -75.6981, 45.4112, 'P', 'PPLC', '08', '8581623', 812129, 'America/Toronto', 1, NULL, '2016-05-25 12:30:41'),
(6094884, 'CA', 'Otterburn Park', 'Otterburn Park', -73.2159, 45.5334, 'P', 'PPL', '10', '16', 8464, 'America/Toronto', 1, NULL, NULL),
(6095645, 'CA', 'Owen Sound', 'Owen Sound', -80.9435, 44.5672, 'P', 'PPL', '08', '', 22625, 'America/Toronto', 1, NULL, NULL),
(6098642, 'CA', 'Parksville', 'Parksville', -124.316, 49.3195, 'P', 'PPL', '02', '5921', 21150, 'America/Vancouver', 1, NULL, NULL),
(6098747, 'CA', 'Parry Sound', 'Parry Sound', -80.0353, 45.3473, 'P', 'PPL', '08', '6098746', 6469, 'America/Toronto', 1, NULL, NULL),
(6100069, 'CA', 'Peace River', 'Peace River', -117.286, 56.2501, 'P', 'PPL', '01', '', 5340, 'America/Edmonton', 1, NULL, NULL),
(6100832, 'CA', 'Pembroke', 'Pembroke', -77.1162, 45.8168, 'P', 'PPL', '08', '', 15551, 'America/Toronto', 1, NULL, NULL),
(6101141, 'CA', 'Penticton', 'Penticton', -119.586, 49.4806, 'P', 'PPL', '02', '', 37721, 'America/Vancouver', 1, NULL, NULL),
(6101546, 'CA', 'Perth', 'Perth', -76.2494, 44.9001, 'P', 'PPL', '08', '', 6481, 'America/Toronto', 1, NULL, NULL),
(6101606, 'CA', 'Petawawa', 'Petawawa', -77.2801, 45.8945, 'P', 'PPL', '08', '', 15988, 'America/Toronto', 1, NULL, NULL),
(6101645, 'CA', 'Peterborough', 'Peterborough', -78.3162, 44.3001, 'P', 'PPL', '08', '', 75877, 'America/Toronto', 1, NULL, NULL),
(6103581, 'CA', 'Petrolia', 'Petrolia', -82.1498, 42.8668, 'P', 'PPL', '08', '', 5453, 'America/Toronto', 1, NULL, NULL),
(6104111, 'CA', 'Pickering', 'Pickering', -79.1329, 43.9001, 'P', 'PPL', '08', '', 87838, 'America/Toronto', 1, NULL, NULL),
(6104876, 'CA', 'Pincourt', 'Pincourt', -73.9825, 45.3834, 'P', 'PPL', '10', '16', 11197, 'America/Toronto', 1, NULL, NULL),
(6105815, 'CA', 'Pitt Meadows', 'Pitt Meadows', -122.69, 49.2212, 'P', 'PPL', '02', '', 17410, 'America/Vancouver', 1, NULL, NULL),
(6107325, 'CA', 'Pointe-Claire', 'Pointe-Claire', -73.8167, 45.4487, 'P', 'PPL', '10', '06', 30161, 'America/Toronto', 1, NULL, NULL),
(6109273, 'CA', 'Ponoka', 'Ponoka', -113.581, 52.6768, 'P', 'PPL', '01', '', 6656, 'America/Edmonton', 1, NULL, NULL),
(6110611, 'CA', 'Pont Rouge', 'Pont Rouge', -72.0825, 48.8833, 'P', 'PPL', '10', '', 7518, 'America/Toronto', 1, NULL, NULL),
(6111529, 'CA', 'Portage la Prairie', 'Portage la Prairie', -98.2926, 49.9728, 'P', 'PPL', '03', '', 12957, 'America/Winnipeg', 1, NULL, NULL),
(6111632, 'CA', 'Port Alberni', 'Port Alberni', -124.803, 49.2413, 'P', 'PPL', '02', '', 21282, 'America/Vancouver', 1, NULL, NULL),
(6111696, 'CA', 'Port-Cartier', 'Port-Cartier', -66.8654, 50.0334, 'P', 'PPL', '10', '09', 5851, 'America/Toronto', 1, NULL, NULL),
(6111704, 'CA', 'Port Colborne', 'Port Colborne', -79.2329, 42.9001, 'P', 'PPL', '08', '', 18599, 'America/Toronto', 1, NULL, NULL),
(6111962, 'CA', 'Port Moody', 'Port Moody', -122.853, 49.283, 'P', 'PPL', '02', '', 27512, 'America/Vancouver', 1, NULL, NULL),
(6112608, 'CA', 'Powell River', 'Powell River', -124.549, 49.8702, 'P', 'PPL', '02', '5927', 12779, 'America/Vancouver', 1, NULL, NULL),
(6113198, 'CA', 'Prévost', 'Prevost', -74.0825, 45.8668, 'P', 'PPL', '10', '15', 10132, 'America/Toronto', 1, NULL, NULL),
(6113335, 'CA', 'Prince Albert', 'Prince Albert', -105.768, 53.2001, 'P', 'PPL', '11', '', 34609, 'America/Regina', 1, NULL, NULL),
(6113355, 'CA', 'Prince Edward', 'Prince Edward', -77.2495, 44.0001, 'P', 'PPL', '08', '', 25496, 'America/Toronto', 1, NULL, NULL),
(6113365, 'CA', 'Prince George', 'Prince George', -122.753, 53.9166, 'P', 'PPL', '02', '', 65558, 'America/Vancouver', 1, NULL, NULL),
(6113406, 'CA', 'Prince Rupert', 'Prince Rupert', -130.321, 54.3151, 'P', 'PPL', '02', '5947', 14708, 'America/Vancouver', 1, NULL, NULL),
(6113466, 'CA', 'Princeville', 'Princeville', -61.2985, 45.7668, 'P', 'PPL', '07', '', 5571, 'America/Halifax', 1, NULL, NULL),
(6115187, 'CA', 'Quesnel', 'Quesnel', -122.493, 52.9784, 'P', 'PPL', '02', '', 13788, 'America/Vancouver', 1, NULL, NULL),
(6115355, 'CA', 'Quinte West', 'Quinte West', -77.5662, 44.1834, 'P', 'PPL', '08', '', 42697, 'America/Toronto', 1, NULL, NULL),
(6117611, 'CA', 'Rawdon', 'Rawdon', -73.7159, 46.0501, 'P', 'PPL', '10', '14', 10400, 'America/Toronto', 1, NULL, NULL),
(6117731, 'CA', 'Rayside-Balfour', 'Rayside-Balfour', -81.2076, 46.6087, 'P', 'PPL', '08', '', 16050, 'America/Toronto', 1, NULL, NULL),
(6118158, 'CA', 'Red Deer', 'Red Deer', -113.802, 52.2668, 'P', 'PPL', '01', '', 73593, 'America/Edmonton', 1, NULL, NULL),
(6119109, 'CA', 'Regina', 'Regina', -104.618, 50.4501, 'P', 'PPLA', '11', '', 176183, 'America/Regina', 1, NULL, NULL),
(6119448, 'CA', 'Renfrew', 'Renfrew', -76.6827, 45.4668, 'P', 'PPL', '08', '', 8018, 'America/Toronto', 1, NULL, NULL),
(6119518, 'CA', 'Repentigny', 'Repentigny', -73.4501, 45.7422, 'P', 'PPL', '10', '14', 76237, 'America/Toronto', 1, NULL, NULL),
(6121621, 'CA', 'Revelstoke', 'Revelstoke', -118.202, 50.9832, 'P', 'PPL', '02', '', 7533, 'America/Vancouver', 1, NULL, NULL),
(6122037, 'CA', 'Richelieu', 'Richelieu', -73.246, 45.4434, 'P', 'PPL', '10', '16', 5208, 'America/Toronto', 1, NULL, NULL),
(6122085, 'CA', 'Richmond', 'Richmond', -123.137, 49.17, 'P', 'PPL', '02', '', 182000, 'America/Vancouver', 1, NULL, NULL),
(6122091, 'CA', 'Richmond Hill', 'Richmond Hill', -79.4372, 43.8711, 'P', 'PPL', '08', '6185560', 185541, 'America/Toronto', 1, NULL, NULL),
(6125653, 'CA', 'Roberval', 'Roberval', -72.2324, 48.5168, 'P', 'PPL', '10', '02', 9287, 'America/Toronto', 1, NULL, NULL),
(6126749, 'CA', 'Rocky Mountain House', 'Rocky Mountain House', -114.919, 52.3668, 'P', 'PPL', '01', '', 6527, 'America/Edmonton', 1, NULL, NULL),
(6127681, 'CA', 'Rosemère', 'Rosemere', -73.7992, 45.6334, 'P', 'PPL', '10', '15', 14173, 'America/Toronto', 1, NULL, NULL),
(6128577, 'CA', 'Rouyn-Noranda', 'Rouyn-Noranda', -79.0231, 48.2366, 'P', 'PPL', '10', '08', 24023, 'America/Toronto', 1, NULL, NULL),
(6137063, 'CA', 'Sackville', 'Sackville', -64.3846, 45.9188, 'P', 'PPL', '04', '', 5411, 'America/Moncton', 1, NULL, NULL),
(6137270, 'CA', 'Saguenay', 'Saguenay', -71.0657, 48.4168, 'P', 'PPL', '10', '02', 143692, 'America/Toronto', 1, NULL, NULL),
(6137489, 'CA', 'Saint-Basile-le-Grand', 'Saint-Basile-le-Grand', -73.2825, 45.5334, 'P', 'PPL', '10', '16', 15605, 'America/Toronto', 1, NULL, NULL),
(6137540, 'CA', 'Saint-Bruno-de-Montarville', 'Saint-Bruno-de-Montarville', -73.3492, 45.5334, 'P', 'PPL', '10', '', 24388, 'America/Toronto', 1, NULL, NULL),
(6137633, 'CA', 'Saint-Constant', 'Saint-Constant', -73.5659, 45.3668, 'P', 'PPL', '10', '16', 23957, 'America/Toronto', 1, NULL, NULL),
(6137696, 'CA', 'Sainte-Adèle', 'Sainte-Adele', -74.1325, 45.9501, 'P', 'PPL', '10', '15', 10634, 'America/Toronto', 1, NULL, NULL),
(6137702, 'CA', 'Sainte-Agathe-des-Monts', 'Sainte-Agathe-des-Monts', -74.2825, 46.0501, 'P', 'PPL', '10', '15', 5706, 'America/Toronto', 1, NULL, NULL),
(6137733, 'CA', 'Sainte-Anne-de-Bellevue', 'Sainte-Anne-de-Bellevue', -73.9456, 45.4062, 'P', 'PPL', '10', '', 5197, 'America/Toronto', 1, NULL, NULL),
(6137749, 'CA', 'Sainte-Anne-des-Monts', 'Sainte-Anne-des-Monts', -66.4924, 49.124, 'P', 'PPL', '10', '11', 5602, 'America/Toronto', 1, NULL, NULL),
(6137753, 'CA', 'Sainte-Anne-des-Plaines', 'Sainte-Anne-des-Plaines', -73.8116, 45.7647, 'P', 'PPL', '10', '15', 10680, 'America/Toronto', 1, NULL, NULL),
(6137781, 'CA', 'Sainte-Catherine', 'Sainte-Catherine', -72.5663, 46.3184, 'P', 'PPL', '10', '', 16211, 'America/Toronto', 1, NULL, NULL),
(6137941, 'CA', 'Sainte-Julie', 'Sainte-Julie', -73.3325, 45.5834, 'P', 'PPL', '10', '16', 29019, 'America/Toronto', 1, NULL, NULL),
(6138032, 'CA', 'Sainte-Marthe-sur-le-Lac', 'Sainte-Marthe-sur-le-Lac', -73.9325, 45.5334, 'P', 'PPL', '10', '15', 11311, 'America/Toronto', 1, NULL, NULL),
(6138121, 'CA', 'Sainte-Thérèse', 'Sainte-Therese', -73.8276, 45.6392, 'P', 'PPL', '10', '15', 25224, 'America/Toronto', 1, NULL, NULL),
(6138175, 'CA', 'Saint-Eustache', 'Saint-Eustache', -73.9055, 45.565, 'P', 'PPL', '10', '15', 42062, 'America/Toronto', 1, NULL, NULL),
(6138201, 'CA', 'Saint-Félicien', 'Saint-Felicien', -72.4491, 48.6501, 'P', 'PPL', '10', '02', 8088, 'America/Toronto', 1, NULL, NULL),
(6138374, 'CA', 'Saint-Hyacinthe', 'Saint-Hyacinthe', -72.957, 45.6308, 'P', 'PPL', '10', '16', 50326, 'America/Toronto', 1, NULL, NULL),
(6138495, 'CA', 'Saint-Jean-sur-Richelieu', 'Saint-Jean-sur-Richelieu', -73.2626, 45.3071, 'P', 'PPL', '10', '16', 71613, 'America/Toronto', 1, NULL, NULL),
(6138501, 'CA', 'Saint-Jérôme', 'Saint-Jerome', -74.0036, 45.7804, 'P', 'PPL', '10', '15', 54948, 'America/Toronto', 1, NULL, NULL),
(6138517, 'CA', 'Saint John', 'Saint John', -66.0677, 45.2727, 'P', 'PPL', '04', '', 87857, 'America/Moncton', 1, NULL, NULL),
(6138610, 'CA', 'Saint-Laurent', 'Saint-Laurent', -73.6658, 45.5001, 'P', 'PPLX', '10', '', 77391, 'America/Toronto', 1, NULL, NULL),
(6138617, 'CA', 'Saint-Lazare', 'Saint-Lazare', -74.1326, 45.4001, 'P', 'PPL', '10', '16', 17016, 'America/Toronto', 1, NULL, NULL),
(6138625, 'CA', 'Saint-Léonard', 'Saint-Leonard', -73.595, 45.5877, 'P', 'PPLX', '10', '06', 73423, 'America/Toronto', 1, NULL, NULL),
(6138643, 'CA', 'Saint-Lin-Laurentides', 'Saint-Lin-Laurentides', -73.7659, 45.8501, 'P', 'PPL', '10', '14', 14159, 'America/Toronto', 1, NULL, NULL),
(6138980, 'CA', 'Saint-Raymond', 'Saint-Raymond', -73.6095, 45.467, 'P', 'PPL', '10', '', 9273, 'America/Toronto', 1, NULL, NULL),
(6139045, 'CA', 'Saint-Sauveur', 'Saint-Sauveur', -74.1794, 45.8869, 'P', 'PPL', '10', '15', 9191, 'America/Toronto', 1, NULL, NULL),
(6139289, 'CA', 'Salaberry-de-Valleyfield', 'Salaberry-de-Valleyfield', -74.1325, 45.2501, 'P', 'PPL', '10', '16', 38662, 'America/Toronto', 1, NULL, NULL),
(6139416, 'CA', 'Salmon Arm', 'Salmon Arm', -119.302, 50.6998, 'P', 'PPL', '02', '', 16205, 'America/Vancouver', 1, NULL, NULL),
(6141190, 'CA', 'Sarnia', 'Sarnia', -82.4041, 42.9787, 'P', 'PPL', '08', '6049019', 82998, 'America/Toronto', 1, NULL, NULL),
(6141256, 'CA', 'Saskatoon', 'Saskatoon', -106.635, 52.1168, 'P', 'PPL', '11', '', 198958, 'America/Regina', 1, NULL, NULL),
(6141439, 'CA', 'Sault Ste. Marie', 'Sault Ste. Marie', -84.3333, 46.5168, 'P', 'PPLA2', '08', '5883638', 74948, 'America/Toronto', 1, NULL, NULL),
(6143367, 'CA', 'Sechelt', 'Sechelt', -123.759, 49.4751, 'P', 'PPL', '02', '5929', 5977, 'America/Vancouver', 1, NULL, NULL),
(6144054, 'CA', 'Selkirk', 'Selkirk', -96.8845, 50.1436, 'P', 'PPL', '03', '', 9653, 'America/Winnipeg', 1, NULL, NULL),
(6144312, 'CA', 'Sept-Îles', 'Sept-Iles', -66.3821, 50.2001, 'P', 'PPL', '10', '09', 22582, 'America/Toronto', 1, NULL, NULL),
(6145489, 'CA', 'Shawinigan', 'Shawinigan', -72.7491, 46.5667, 'P', 'PPL', '10', '04', 49161, 'America/Toronto', 1, NULL, NULL),
(6146143, 'CA', 'Sherbrooke', 'Sherbrooke', -71.8991, 45.4001, 'P', 'PPL', '10', '05', 129447, 'America/Toronto', 1, NULL, NULL),
(6146279, 'CA', 'Sherwood Park', 'Sherwood Park', -113.319, 53.5168, 'P', 'PPL', '01', '', 55063, 'America/Edmonton', 1, NULL, NULL),
(6149374, 'CA', 'Slave Lake', 'Slave Lake', -114.769, 55.2834, 'P', 'PPL', '01', '', 7661, 'America/Edmonton', 1, NULL, NULL),
(6149996, 'CA', 'Smithers', 'Smithers', -127.174, 54.7804, 'P', 'PPL', '02', '', 5438, 'America/Vancouver', 1, NULL, NULL),
(6150174, 'CA', 'Smiths Falls', 'Smiths Falls', -76.0233, 44.9045, 'P', 'PPL', '08', '6049130', 10553, 'America/Toronto', 1, NULL, NULL),
(6151264, 'CA', 'Sooke', 'Sooke', -123.728, 48.3746, 'P', 'PPL', '02', '', 6145, 'America/Vancouver', 1, NULL, NULL),
(6151352, 'CA', 'Sorel-Tracy', 'Sorel-Tracy', -73.1159, 46.0334, 'P', 'PPL', '10', '16', 33591, 'America/Toronto', 1, NULL, NULL),
(6152244, 'CA', 'South Huron', 'South Huron', -81.5165, 43.3168, 'P', 'PPL', '08', '', 9982, 'America/Toronto', 1, NULL, NULL),
(6154383, 'CA', 'Spruce Grove', 'Spruce Grove', -113.919, 53.5334, 'P', 'PPL', '01', '', 17767, 'America/Edmonton', 1, NULL, NULL),
(6155033, 'CA', 'St. Albert', 'St. Albert', -113.635, 53.6334, 'P', 'PPL', '01', '', 57719, 'America/Edmonton', 1, NULL, NULL),
(6155721, 'CA', 'St. Catharines', 'St. Catharines', -79.2427, 43.1713, 'P', 'PPL', '08', '6087883', 131989, 'America/Toronto', 1, NULL, NULL),
(6156102, 'CA', 'Steinbach', 'Steinbach', -96.6845, 49.5258, 'P', 'PPL', '03', '', 9607, 'America/Winnipeg', 1, NULL, NULL),
(6156244, 'CA', 'Stephenville', 'Stephenville', -58.5818, 48.55, 'P', 'PPL', '05', '', 6278, 'America/St_Johns', 1, NULL, NULL),
(6156307, 'CA', 'Stettler', 'Stettler', -112.719, 52.3168, 'P', 'PPL', '01', '', 5494, 'America/Edmonton', 1, NULL, NULL),
(6157536, 'CA', 'Stony Plain', 'Stony Plain', -114.002, 53.5334, 'P', 'PPL', '01', '', 8939, 'America/Edmonton', 1, NULL, NULL),
(6157977, 'CA', 'Stratford', 'Stratford', -80.9497, 43.3668, 'P', 'PPL', '08', '', 30233, 'America/Toronto', 1, NULL, NULL),
(6158023, 'CA', 'Strathmore', 'Strathmore', -113.385, 51.0501, 'P', 'PPL', '01', '', 10009, 'America/Edmonton', 1, NULL, NULL),
(6158357, 'CA', 'St. Thomas', 'St. Thomas', -81.1804, 42.7736, 'P', 'PPL', '08', '', 36110, 'America/Toronto', 1, NULL, NULL),
(6159232, 'CA', 'Summerland', 'Summerland', -119.669, 49.5998, 'P', 'PPL', '02', '', 6292, 'America/Vancouver', 1, NULL, NULL),
(6159244, 'CA', 'Summerside', 'Summerside', -63.7876, 46.3959, 'P', 'PPL', '09', '', 14808, 'America/Halifax', 1, NULL, NULL),
(6159905, 'CA', 'Surrey', 'Surrey', -122.825, 49.1063, 'P', 'PPL', '02', '', 394976, 'America/Vancouver', 1, NULL, NULL),
(6160603, 'CA', 'Swift Current', 'Swift Current', -107.801, 50.2834, 'P', 'PPL', '11', '', 14703, 'America/Swift_Current', 1, NULL, NULL),
(6160806, 'CA', 'Sylvan Lake', 'Sylvan Lake', -114.085, 52.3168, 'P', 'PPL', '01', '', 10518, 'America/Edmonton', 1, NULL, NULL),
(6160919, 'CA', 'Taber', 'Taber', -112.146, 49.787, 'P', 'PPL', '01', '', 8163, 'America/Edmonton', 1, NULL, NULL),
(6162659, 'CA', 'Temiskaming Shores', 'Temiskaming Shores', -79.7153, 47.4938, 'P', 'PPL', '08', '', 10442, 'America/Toronto', 1, NULL, NULL),
(6162949, 'CA', 'Terrace', 'Terrace', -128.603, 54.5163, 'P', 'PPL', '02', '', 19443, 'America/Vancouver', 1, NULL, NULL),
(6163012, 'CA', 'Terrebonne', 'Terrebonne', -73.6473, 45.7, 'P', 'PPL', '10', '14', 94703, 'America/Toronto', 1, NULL, NULL),
(6164499, 'CA', 'The Pas', 'The Pas', -101.254, 53.8251, 'P', 'PPL', '03', '', 6055, 'America/Winnipeg', 1, NULL, NULL),
(6165406, 'CA', 'Thompson', 'Thompson', -97.8558, 55.7435, 'P', 'PPL', '03', '', 12467, 'America/Winnipeg', 1, NULL, NULL),
(6165719, 'CA', 'Thorold', 'Thorold', -79.1996, 43.1168, 'P', 'PPL', '08', '', 18224, 'America/Toronto', 1, NULL, NULL),
(6166142, 'CA', 'Thunder Bay', 'Thunder Bay', -89.2502, 48.382, 'P', 'PPL', '08', '6166139', 99334, 'America/Thunder_Bay', 1, NULL, NULL),
(6166739, 'CA', 'Timmins', 'Timmins', -81.3331, 48.4669, 'P', 'PPL', '08', '', 42997, 'America/Toronto', 1, NULL, NULL),
(6167865, 'CA', 'Toronto', 'Toronto', -79.4163, 43.7001, 'P', 'PPLA', '08', '8133394', 2600000, 'America/Toronto', 1, NULL, '2016-05-25 12:40:19'),
(6168326, 'CA', 'Trail', 'Trail', -117.702, 49.0998, 'P', 'PPL', '02', '', 9707, 'America/Vancouver', 1, NULL, NULL),
(6169141, 'CA', 'Trois-Rivières', 'Trois-Rivieres', -72.5477, 46.3451, 'P', 'PPL', '10', '04', 119693, 'America/Toronto', 1, NULL, NULL),
(6169587, 'CA', 'Truro', 'Truro', -63.2654, 45.3669, 'P', 'PPL', '07', '', 20650, 'America/Halifax', 1, NULL, NULL),
(6172932, 'CA', 'Uxbridge', 'Uxbridge', -79.1163, 44.1001, 'P', 'PPL', '08', '', 11531, 'America/Toronto', 1, NULL, NULL),
(6173012, 'CA', 'Val-des-Monts', 'Val-des-Monts', -75.666, 45.6501, 'P', 'PPL', '10', '07', 9539, 'America/Toronto', 1, NULL, NULL),
(6173017, 'CA', 'Val-d''Or', 'Val-d''Or', -77.7974, 48.0974, 'P', 'PPL', '10', '08', 31123, 'America/Toronto', 1, NULL, NULL),
(6173331, 'CA', 'Vancouver', 'Vancouver', -123.119, 49.2497, 'P', 'PPL', '02', '', 600000, 'America/Vancouver', 1, NULL, NULL),
(6173508, 'CA', 'Varennes', 'Varennes', -73.4325, 45.6834, 'P', 'PPL', '10', '16', 20950, 'America/Toronto', 1, NULL, NULL),
(6173570, 'CA', 'Vaudreuil-Dorion', 'Vaudreuil-Dorion', -74.0325, 45.4001, 'P', 'PPL', '10', '16', 25789, 'America/Toronto', 1, NULL, NULL),
(6173577, 'CA', 'Vaughan', 'Vaughan', -79.4983, 43.8361, 'P', 'PPL', '08', '', 238866, 'America/Toronto', 1, NULL, NULL),
(6173635, 'CA', 'Vegreville', 'Vegreville', -112.052, 53.5001, 'P', 'PPL', '01', '', 5678, 'America/Edmonton', 1, NULL, NULL),
(6173864, 'CA', 'Vernon', 'Vernon', -119.273, 50.2673, 'P', 'PPL', '02', '5937', 47274, 'America/Vancouver', 1, NULL, NULL),
(6174041, 'CA', 'Victoria', 'Victoria', -123.369, 48.4329, 'P', 'PPLA', '02', '', 289625, 'America/Vancouver', 1, NULL, NULL),
(6174151, 'CA', 'Victoriaville', 'Victoriaville', -71.9658, 46.0501, 'P', 'PPL', '10', '04', 34426, 'America/Toronto', 1, NULL, NULL),
(6175059, 'CA', 'Wainwright', 'Wainwright', -110.857, 52.839, 'P', 'PPL', '01', '', 5380, 'America/Edmonton', 1, NULL, NULL),
(6176421, 'CA', 'Wasaga Beach', 'Wasaga Beach', -80.0164, 44.5168, 'P', 'PPL', '08', '', 7567, 'America/Toronto', 1, NULL, NULL),
(6176823, 'CA', 'Waterloo', 'Waterloo', -80.5164, 43.4668, 'P', 'PPL', '08', '', 97475, 'America/Toronto', 1, NULL, NULL),
(6177869, 'CA', 'Welland', 'Welland', -79.2496, 42.9834, 'P', 'PPL', '08', '', 50331, 'America/Toronto', 1, NULL, NULL),
(6178582, 'CA', 'West End', 'West End', -123.133, 49.2833, 'P', 'PPL', '02', '', 44560, 'America/Vancouver', 1, NULL, NULL),
(6179138, 'CA', 'Westlock', 'Westlock', -113.869, 54.1502, 'P', 'PPL', '01', '', 5067, 'America/Edmonton', 1, NULL, NULL),
(6179226, 'CA', 'Westmount', 'Westmount', -73.5992, 45.4834, 'P', 'PPL', '10', '', 20494, 'America/Toronto', 1, NULL, NULL),
(6179602, 'CA', 'Wetaskiwin', 'Wetaskiwin', -113.369, 52.9668, 'P', 'PPL', '01', '', 11302, 'America/Edmonton', 1, NULL, NULL),
(6179652, 'CA', 'Weyburn', 'Weyburn', -103.851, 49.6668, 'P', 'PPL', '11', '', 9362, 'America/Regina', 1, NULL, NULL),
(6180144, 'CA', 'Whistler', 'Whistler', -122.969, 50.1164, 'P', 'PPL', '02', '', 10600, 'America/Vancouver', 1, NULL, NULL),
(6180285, 'CA', 'Whitecourt', 'Whitecourt', -115.685, 54.1502, 'P', 'PPL', '01', '', 8763, 'America/Edmonton', 1, NULL, NULL),
(6180550, 'CA', 'Whitehorse', 'Whitehorse', -135.054, 60.7161, 'P', 'PPLA', '12', '', 23272, 'America/Whitehorse', 1, NULL, NULL),
(6180961, 'CA', 'White Rock', 'White Rock', -122.803, 49.0164, 'P', 'PPL', '02', '5915', 66450, 'America/Vancouver', 1, NULL, NULL),
(6182212, 'CA', 'Williams Lake', 'Williams Lake', -122.145, 52.1415, 'P', 'PPL', '02', '', 14168, 'America/Vancouver', 1, NULL, NULL),
(6182959, 'CA', 'Windsor', 'Windsor', -71.9991, 45.5668, 'P', 'PPL', '10', '05', 5408, 'America/Toronto', 1, NULL, NULL),
(6182962, 'CA', 'Windsor', 'Windsor', -83.0165, 42.3001, 'P', 'PPL', '08', '', 278013, 'America/Toronto', 1, NULL, NULL),
(6183204, 'CA', 'Winkler', 'Winkler', -97.941, 49.1817, 'P', 'PPL', '03', '', 8270, 'America/Winnipeg', 1, NULL, NULL),
(6183235, 'CA', 'Winnipeg', 'Winnipeg', -97.147, 49.8844, 'P', 'PPLA', '03', '', 632063, 'America/Winnipeg', 1, NULL, NULL),
(6184365, 'CA', 'Woodstock', 'Woodstock', -80.7497, 43.1334, 'P', 'PPLA2', '08', '6095780', 33892, 'America/Toronto', 1, NULL, NULL),
(6185217, 'CA', 'Yarmouth', 'Yarmouth', -66.1156, 43.8335, 'P', 'PPL', '07', '', 7500, 'America/Halifax', 1, NULL, NULL),
(6185377, 'CA', 'Yellowknife', 'Yellowknife', -114.353, 62.456, 'P', 'PPLA', '13', '', 15865, 'America/Yellowknife', 1, NULL, NULL),
(6185607, 'CA', 'Yorkton', 'Yorkton', -102.468, 51.2167, 'P', 'PPL', '11', '', 15669, 'America/Regina', 1, NULL, NULL),
(6295855, 'CA', 'Beauceville', 'Beauceville', -70.7787, 46.2178, 'P', 'PPL', '10', '12', 6226, 'America/Toronto', 1, NULL, NULL),
(6324729, 'CA', 'Halifax', 'Halifax', -63.5724, 44.6453, 'P', 'PPLA', '07', '', 359111, 'America/Halifax', 1, NULL, NULL),
(6324733, 'CA', 'St. John''s', 'St. John''s', -52.7093, 47.5649, 'P', 'PPLA', '05', '', 99182, 'America/St_Johns', 1, NULL, NULL),
(6325494, 'CA', 'Québec', 'Quebec', -71.2145, 46.8123, 'P', 'PPLA', '10', '', 528595, 'America/Toronto', 1, NULL, NULL),
(6325521, 'CA', 'Lévis', 'Levis', -71.1779, 46.8033, 'P', 'PPL', '10', '12', 126396, 'America/Blanc-Sablon', 1, NULL, NULL),
(6325529, 'CA', 'Montmagny', 'Montmagny', -70.5549, 46.9804, 'P', 'PPL', '10', '12', 11724, 'America/Toronto', 1, NULL, NULL),
(6354895, 'CA', 'Rimouski', 'Rimouski', -68.524, 48.4488, 'P', 'PPL', '10', '01', 42240, 'America/Toronto', 1, NULL, NULL),
(6354897, 'CA', 'Rivière-du-Loup', 'Riviere-du-Loup', -69.5424, 47.827, 'P', 'PPL', '10', '01', 18586, 'America/Toronto', 1, NULL, NULL),
(6354908, 'CA', 'Sydney', 'Sydney', -60.1831, 46.1351, 'P', 'PPL', '07', '', 105968, 'America/Glace_Bay', 1, NULL, NULL),
(6534203, 'CA', 'L''Ancienne-Lorette', 'L''Ancienne-Lorette', -71.3519, 46.7939, 'P', 'PPL', '10', '', 16516, 'America/Toronto', 1, NULL, NULL),
(6545023, 'CA', 'Edmundston', 'Edmundston', -68.3251, 47.3737, 'P', 'PPL', '04', '', 16643, 'America/Moncton', 1, NULL, NULL),
(6639619, 'CA', 'Sainte Catherine de la Jacques Cartier', 'Sainte Catherine de la Jacques Cartier', -71.6206, 46.8524, 'P', 'PPL', '10', '03', 5021, 'America/Toronto', 1, NULL, NULL),
(6690232, 'CA', 'Baie-Saint-Paul', 'Baie-Saint-Paul', -70.4986, 47.4411, 'P', 'PPL', '10', '03', 7288, 'America/Toronto', 1, NULL, NULL),
(6696258, 'CA', 'Campbellton', 'Campbellton', -66.6727, 48.0075, 'P', 'PPL', '04', '11', 7384, 'America/Moncton', 1, NULL, NULL),
(6696259, 'CA', 'Bathurst', 'Bathurst', -65.6511, 47.6181, 'P', 'PPL', '04', '', 12714, 'America/Moncton', 1, NULL, NULL),
(6696260, 'CA', 'Matane', 'Matane', -67.522, 48.8286, 'P', 'PPL', '10', '01', 14812, 'America/Toronto', 1, NULL, NULL),
(6942553, 'CA', 'Paris', 'Paris', -80.3833, 43.2, 'P', 'PPL', '08', '', 11177, 'America/Toronto', 1, NULL, NULL),
(6943488, 'CA', 'Amqui', 'Amqui', -67.4313, 48.4638, 'P', 'PPL', '10', '01', 6261, 'America/Toronto', 1, NULL, NULL),
(6943811, 'CA', 'Chandler', 'Chandler', -64.6793, 48.3493, 'P', 'PPL', '10', '11', 7914, 'America/Toronto', 1, NULL, NULL);
INSERT INTO `cities` (`id`, `country_code`, `name`, `asciiname`, `latitude`, `longitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES
(6943827, 'CA', 'Thetford-Mines', 'Thetford-Mines', -71.3054, 46.0937, 'P', 'PPL', '10', '12', 25704, 'America/Toronto', 1, NULL, NULL),
(6944113, 'CA', 'Mont-Joli', 'Mont-Joli', -68.1921, 48.5839, 'P', 'PPL', '10', '01', 6568, 'America/Toronto', 1, NULL, NULL),
(6945986, 'CA', 'La Malbaie', 'La Malbaie', -70.1527, 47.654, 'P', 'PPL', '10', '03', 8959, 'America/Toronto', 1, NULL, NULL),
(6945989, 'CA', 'Sainte-Marie', 'Sainte-Marie', -71.0117, 46.434, 'P', 'PPL', '10', '12', 11584, 'America/Toronto', 1, NULL, NULL),
(6945991, 'CA', 'Plessisville', 'Plessisville', -71.762, 46.2186, 'P', 'PPL', '10', '04', 6677, 'America/Toronto', 1, NULL, NULL),
(6948711, 'CA', 'Scarborough', 'Scarborough', -79.2567, 43.7722, 'P', 'PPL', '08', '', 600000, 'America/Toronto', 1, NULL, NULL),
(7280414, 'CA', 'Cole Harbour', 'Cole Harbour', -63.4751, 44.6724, 'P', 'PPLX', '07', '', 20000, 'America/Halifax', 1, NULL, NULL),
(7281931, 'CA', 'Okanagan', 'Okanagan', -119.35, 50.3639, 'P', 'PPLQ', '02', '', 297601, 'America/Vancouver', 1, NULL, NULL),
(7281936, 'CA', 'West Kelowna', 'West Kelowna', -119.583, 49.8625, 'P', 'PPL', '02', '', 28793, 'America/Vancouver', 1, NULL, NULL),
(7302647, 'CA', 'Bellechasse Regional County Municipality', 'Bellechasse Regional County Municipality', -70.7167, 46.6667, 'P', 'PPL', '10', '12', 29570, 'America/Toronto', 1, NULL, NULL),
(7303783, 'CA', 'Sydney Mines', 'Sydney Mines', -60.2177, 46.2367, 'P', 'PPL', '07', '', 7312, 'America/Glace_Bay', 1, NULL, NULL),
(7303786, 'CA', 'Jonquière', 'Jonquiere', -71.2488, 48.4165, 'P', 'PPL', '10', '02', 54842, 'America/Toronto', 1, NULL, NULL),
(7535681, 'CA', 'Saint-Augustin-de-Desmaures', 'Saint-Augustin-de-Desmaures', -71.4513, 46.7406, 'P', 'PPL', '10', '03', 17281, 'America/Toronto', 1, NULL, NULL),
(7535690, 'CA', 'Donnacona', 'Donnacona', -71.7239, 46.6804, 'P', 'PPL', '10', '03', 5564, 'America/Toronto', 1, NULL, NULL),
(7602078, 'CA', 'Ladner', 'Ladner', -123.082, 49.0894, 'P', 'PPL', '02', '', 200000, 'America/Vancouver', 1, NULL, NULL),
(7669012, 'CA', 'Walnut Grove', 'Walnut Grove', -122.64, 49.1647, 'P', 'PPLX', '02', '', 25683, 'America/Vancouver', 1, NULL, NULL),
(7669018, 'CA', 'Aldergrove', 'Aldergrove', -122.471, 49.058, 'P', 'PPLX', '02', '', 12363, 'America/Vancouver', 1, NULL, NULL),
(8285452, 'CA', 'Ancaster', 'Ancaster', -79.9872, 43.2181, 'P', 'PPL', '08', '', 33232, 'America/Toronto', 1, NULL, NULL),
(8354533, 'CA', 'Shannon', 'Shannon', -71.5146, 46.8803, 'P', 'PPL', '10', '03', 5086, 'America/Toronto', 1, NULL, NULL),
(8354586, 'CA', 'Saint-Henri', 'Saint-Henri', -71.0693, 46.6931, 'P', 'PPL', '10', '12', 5023, 'America/Toronto', 1, NULL, NULL),
(8354587, 'CA', 'Saint-Lambert-de-Lauzon', 'Saint-Lambert-de-Lauzon', -71.2089, 46.5862, 'P', 'PPL', '10', '12', 6177, 'America/Toronto', 1, NULL, NULL),
(8379100, 'CA', 'Pont-Rouge', 'Pont-Rouge', -71.6957, 46.7547, 'P', 'PPL', '10', '03', 8723, 'America/Toronto', 1, NULL, NULL),
(8379101, 'CA', 'Princeville', 'Princeville', -71.8746, 46.1716, 'P', 'PPL', '10', '04', 5693, 'America/Toronto', 1, NULL, NULL),
(8533869, 'CA', 'West Vancouver', 'West Vancouver', -123.167, 49.3667, 'P', 'PPLL', '02', '', 42694, 'America/Vancouver', 1, NULL, NULL),
(8558534, 'CA', 'Willowdale', 'Willowdale', -79.3991, 43.7667, 'P', 'PPLL', '08', '', 79440, 'America/Toronto', 1, NULL, NULL),
(10287505, 'CA', 'Lower Sacvkille', 'Lower Sacvkille', -63.6786, 44.776, 'P', 'PPL', '07', '', 21379, 'America/Halifax', 1, NULL, NULL),
(10627796, 'CA', 'le Plateau', 'le Plateau', -75.7803, 45.4351, 'P', 'PPL', '10', '07', 15000, 'America/Toronto', 1, NULL, NULL);

