schema.sql

USE spins;
DROP TABLE IF EXISTS registrations;
DROP TABLE IF EXISTS ministries;
DROP TABLE IF EXISTS milestones;
DROP TABLE IF EXISTS cities;
DROP TABLE IF EXISTS user_roles;
DROP TABLE IF EXISTS roles;
DROP TABLE IF EXISTS users;
USE spins;


CREATE TABLE milestones (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


CREATE TABLE cities (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    role VARCHAR(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE ministries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    initials VARCHAR(10) NULL,
    retroactive VARCHAR(10) NULL,
    shipping_method VARCHAR(10) NULL,
    bulk_shipping_address TEXT NULL,
    contact_name VARCHAR(255) NULL,
    contact_email VARCHAR(255) NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE registrations (
    id INT AUTO_INCREMENT PRIMARY KEY,
    created DATETIME,
    modified DATETIME,

    user_idir VARCHAR(16),
    user_guid VARCHAR(128),

    employee_number INT,
    first_name VARCHAR(255),
    last_name VARCHAR(255),
    ministry_id INT,
    department VARCHAR(255),

    milestone INT,
    retro_years TEXT,

    admin_notes TEXT,

    office_careof VARCHAR(255),
    office_address VARCHAR(255),
    office_suite VARCHAR(16),
    office_city_id INT,
    office_province VARCHAR(2),
    office_postal_code VARCHAR(10),
    office_po_box VARCHAR(10),
    work_phone VARCHAR(15),
    work_extension VARCHAR(4),
    preferred_email VARCHAR(255),

    supervisor_first_name VARCHAR(255),
    supervisor_last_name VARCHAR(255),
    supervisor_careof VARCHAR(255),
    supervisor_address VARCHAR(255),
    supervisor_suite VARCHAR(16),
    supervisor_city_id INT,
    supervisor_province VARCHAR(2),
    supervisor_postal_code VARCHAR(10),
    supervisor_email VARCHAR(255),
    supervisor_work_phone VARCHAR(15),
    supervisor_work_extension VARCHAR(4),

    FOREIGN KEY ministry_key (ministry_id) REFERENCES ministries(id),
    FOREIGN KEY office_city_key (office_city_id) REFERENCES cities(id),
    FOREIGN KEY supervisor_city_key (supervisor_city_id) REFERENCES cities(id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE roles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE user_roles (
	id INT AUTO_INCREMENT PRIMARY KEY,
    idir VARCHAR(16),
    guid varchar(128) DEFAULT '',
    role_id INT,
    ministry_id INT DEFAULT 0,
    FOREIGN KEY role_key (role_id) REFERENCES roles(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE registration_periods (
    id INT AUTO_INCREMENT PRIMARY KEY,
    award_year INT,
    open_registration DATETIME,
    close_registration DATETIME
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Finance', 'FIN');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Transportation & Infrastructure', 'TRAN');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Citizens Services', 'CITZ');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Agriculture', 'AGRI');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Attorney General', 'AG');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Advanced Education, Skills & Training', 'AEST');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Education', 'EDUC');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Energy, Mines & Petroleum Resources', 'EMPR');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Environment & Climate Change Strategy', 'ENV');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Forests, Lands, Natural Resource Operations & Rural Development', 'FLNR');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Health', 'HLTH');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Indigenous Relations & Reconciliation', 'IRR');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Jobs, Trade & Technology', 'JTT');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Labour', 'LBR');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Mental Health & Addictions', 'MMHA');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Municipal Affairs & Housing', 'MAH');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Public Safety & Solicitor General & Emergency B.C.', 'PSSG');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Social Development & Poverty Reduction', 'SDPR');
INSERT INTO `ministries` (`name`, `initials`) VALUES ('Tourism, Arts & Culture', 'TAC');
 */

INSERT INTO `cities` (`name`) VALUES ("'Ksan");
INSERT INTO `cities` (`name`) VALUES ("12 Mile");
INSERT INTO `cities` (`name`) VALUES ("40 Mile Flats");
INSERT INTO `cities` (`name`) VALUES ("70 Mile");
INSERT INTO `cities` (`name`) VALUES ("70 Mile House");
INSERT INTO `cities` (`name`) VALUES ("93 Mile");
INSERT INTO `cities` (`name`) VALUES ("100 Mile House");
INSERT INTO `cities` (`name`) VALUES ("105 Mile House");
INSERT INTO `cities` (`name`) VALUES ("108 Mile Ranch");
INSERT INTO `cities` (`name`) VALUES ("111 Mile House");
INSERT INTO `cities` (`name`) VALUES ("114 Mile House");
INSERT INTO `cities` (`name`) VALUES ("122 Mile House");
INSERT INTO `cities` (`name`) VALUES ("127 Mile House");
INSERT INTO `cities` (`name`) VALUES ("141 Mile House");
INSERT INTO `cities` (`name`) VALUES ("150 Mile House");
INSERT INTO `cities` (`name`) VALUES ("A:mai");
INSERT INTO `cities` (`name`) VALUES ("Aa-at-sow-is");
INSERT INTO `cities` (`name`) VALUES ("Abbotsford");
INSERT INTO `cities` (`name`) VALUES ("Aberdeen");
INSERT INTO `cities` (`name`) VALUES ("Acous");
INSERT INTO `cities` (`name`) VALUES ("Adams Lake");
INSERT INTO `cities` (`name`) VALUES ("Agassiz");
INSERT INTO `cities` (`name`) VALUES ("Agate");
INSERT INTO `cities` (`name`) VALUES ("Ah:tliish");
INSERT INTO `cities` (`name`) VALUES ("Ahbau");
INSERT INTO `cities` (`name`) VALUES ("Ahousat");
INSERT INTO `cities` (`name`) VALUES ("Ainsworth Hot Springs");
INSERT INTO `cities` (`name`) VALUES ("Aiyansh");
INSERT INTO `cities` (`name`) VALUES ("Ak:tiis");
INSERT INTO `cities` (`name`) VALUES ("Alamo");
INSERT INTO `cities` (`name`) VALUES ("Albas");
INSERT INTO `cities` (`name`) VALUES ("Alberni");
INSERT INTO `cities` (`name`) VALUES ("Albert Canyon");
INSERT INTO `cities` (`name`) VALUES ("Albert Head");
INSERT INTO `cities` (`name`) VALUES ("Albion");
INSERT INTO `cities` (`name`) VALUES ("Albreda");
INSERT INTO `cities` (`name`) VALUES ("Alder Creek");
INSERT INTO `cities` (`name`) VALUES ("Aldergrove");
INSERT INTO `cities` (`name`) VALUES ("Alert Bay");
INSERT INTO `cities` (`name`) VALUES ("Alexandria");
INSERT INTO `cities` (`name`) VALUES ("Alexis Creek");
INSERT INTO `cities` (`name`) VALUES ("Aleza Lake");
INSERT INTO `cities` (`name`) VALUES ("Alice Arm");
INSERT INTO `cities` (`name`) VALUES ("Alice Siding");
INSERT INTO `cities` (`name`) VALUES ("Alkali Lake");
INSERT INTO `cities` (`name`) VALUES ("Allenby");
INSERT INTO `cities` (`name`) VALUES ("Alliford Bay");
INSERT INTO `cities` (`name`) VALUES ("Allison Lake");
INSERT INTO `cities` (`name`) VALUES ("Almond Gardens");
INSERT INTO `cities` (`name`) VALUES ("Alpine Meadows");
INSERT INTO `cities` (`name`) VALUES ("Alta Lake");
INSERT INTO `cities` (`name`) VALUES ("Altamont");
INSERT INTO `cities` (`name`) VALUES ("Altona");
INSERT INTO `cities` (`name`) VALUES ("Alvin");
INSERT INTO `cities` (`name`) VALUES ("Ambleside");
INSERT INTO `cities` (`name`) VALUES ("Amsbury");
INSERT INTO `cities` (`name`) VALUES ("Anaconda");
INSERT INTO `cities` (`name`) VALUES ("Anahim Lake");
INSERT INTO `cities` (`name`) VALUES ("Anaqtl'a");
INSERT INTO `cities` (`name`) VALUES ("Anderson");
INSERT INTO `cities` (`name`) VALUES ("Andimaul");
INSERT INTO `cities` (`name`) VALUES ("Anglemont");
INSERT INTO `cities` (`name`) VALUES ("Angusmac");
INSERT INTO `cities` (`name`) VALUES ("Anmore");
INSERT INTO `cities` (`name`) VALUES ("Annacis");
INSERT INTO `cities` (`name`) VALUES ("Anniedale");
INSERT INTO `cities` (`name`) VALUES ("Annis");
INSERT INTO `cities` (`name`) VALUES ("Anvil Island");
INSERT INTO `cities` (`name`) VALUES ("Anyox");
INSERT INTO `cities` (`name`) VALUES ("Anzac");
INSERT INTO `cities` (`name`) VALUES ("Apex Mountain");
INSERT INTO `cities` (`name`) VALUES ("Appledale");
INSERT INTO `cities` (`name`) VALUES ("Applegrove");
INSERT INTO `cities` (`name`) VALUES ("Arbutus Ridge");
INSERT INTO `cities` (`name`) VALUES ("Arden Park");
INSERT INTO `cities` (`name`) VALUES ("Ardmore");
INSERT INTO `cities` (`name`) VALUES ("Argenta");
INSERT INTO `cities` (`name`) VALUES ("Armstrong");
INSERT INTO `cities` (`name`) VALUES ("Armstrong Junction");
INSERT INTO `cities` (`name`) VALUES ("Arnold");
INSERT INTO `cities` (`name`) VALUES ("Arras");
INSERT INTO `cities` (`name`) VALUES ("Arrow Creek");
INSERT INTO `cities` (`name`) VALUES ("Arrow Park");
INSERT INTO `cities` (`name`) VALUES ("Arrowhead");
INSERT INTO `cities` (`name`) VALUES ("Arrowsmith");
INSERT INTO `cities` (`name`) VALUES ("Arrowview Heights");
INSERT INTO `cities` (`name`) VALUES ("Ashcroft");
INSERT INTO `cities` (`name`) VALUES ("Ashton Creek");
INSERT INTO `cities` (`name`) VALUES ("Aspen Grove");
INSERT INTO `cities` (`name`) VALUES ("Atbara");
INSERT INTO `cities` (`name`) VALUES ("Atchelitz");
INSERT INTO `cities` (`name`) VALUES ("Athalmer");
INSERT INTO `cities` (`name`) VALUES ("Atlin");
INSERT INTO `cities` (`name`) VALUES ("Atluck");
INSERT INTO `cities` (`name`) VALUES ("Atnarko");
INSERT INTO `cities` (`name`) VALUES ("Attachie");
INSERT INTO `cities` (`name`) VALUES ("Austin Heights");
INSERT INTO `cities` (`name`) VALUES ("Australian");
INSERT INTO `cities` (`name`) VALUES ("Avola");
INSERT INTO `cities` (`name`) VALUES ("Azouzetta");
INSERT INTO `cities` (`name`) VALUES ("Azu Ski Village");
INSERT INTO `cities` (`name`) VALUES ("Baker");
INSERT INTO `cities` (`name`) VALUES ("Baker Creek");
INSERT INTO `cities` (`name`) VALUES ("Baldonnel");
INSERT INTO `cities` (`name`) VALUES ("Baldy Hughes");
INSERT INTO `cities` (`name`) VALUES ("Balfour");
INSERT INTO `cities` (`name`) VALUES ("Balmoral");
INSERT INTO `cities` (`name`) VALUES ("Balmoral Beach");
INSERT INTO `cities` (`name`) VALUES ("Bamberton");
INSERT INTO `cities` (`name`) VALUES ("Bamfield");
INSERT INTO `cities` (`name`) VALUES ("Bankeir");
INSERT INTO `cities` (`name`) VALUES ("Barkerville");
INSERT INTO `cities` (`name`) VALUES ("Barlow");
INSERT INTO `cities` (`name`) VALUES ("Barlow Creek");
INSERT INTO `cities` (`name`) VALUES ("Barnet");
INSERT INTO `cities` (`name`) VALUES ("Barnhartvale");
INSERT INTO `cities` (`name`) VALUES ("Barnston Island");
INSERT INTO `cities` (`name`) VALUES ("Barrett");
INSERT INTO `cities` (`name`) VALUES ("Barrett Lake");
INSERT INTO `cities` (`name`) VALUES ("Barriere");
INSERT INTO `cities` (`name`) VALUES ("Barrowtown");
INSERT INTO `cities` (`name`) VALUES ("Basford");
INSERT INTO `cities` (`name`) VALUES ("Basque");
INSERT INTO `cities` (`name`) VALUES ("Bastion Bay");
INSERT INTO `cities` (`name`) VALUES ("Batchelor Hills");
INSERT INTO `cities` (`name`) VALUES ("Baynes Lake");
INSERT INTO `cities` (`name`) VALUES ("Beach Grove");
INSERT INTO `cities` (`name`) VALUES ("Beachcomber Bay");
INSERT INTO `cities` (`name`) VALUES ("Bear Camp");
INSERT INTO `cities` (`name`) VALUES ("Bear Creek");
INSERT INTO `cities` (`name`) VALUES ("Bear Flat");
INSERT INTO `cities` (`name`) VALUES ("Bear Lake");
INSERT INTO `cities` (`name`) VALUES ("Bear Mountain");
INSERT INTO `cities` (`name`) VALUES ("Beasley");
INSERT INTO `cities` (`name`) VALUES ("Beaton");
INSERT INTO `cities` (`name`) VALUES ("Beatton");
INSERT INTO `cities` (`name`) VALUES ("Beatton Ranch");
INSERT INTO `cities` (`name`) VALUES ("Beaver Cove");
INSERT INTO `cities` (`name`) VALUES ("Beaver Creek");
INSERT INTO `cities` (`name`) VALUES ("Beaver Falls");
INSERT INTO `cities` (`name`) VALUES ("Beaver Lake");
INSERT INTO `cities` (`name`) VALUES ("Beaver Pass House");
INSERT INTO `cities` (`name`) VALUES ("Beaver Point");
INSERT INTO `cities` (`name`) VALUES ("Beaverdell");
INSERT INTO `cities` (`name`) VALUES ("Beaverley");
INSERT INTO `cities` (`name`) VALUES ("Beavermouth");
INSERT INTO `cities` (`name`) VALUES ("Becher House");
INSERT INTO `cities` (`name`) VALUES ("Bedwell Harbour");
INSERT INTO `cities` (`name`) VALUES ("Belcarra");
INSERT INTO `cities` (`name`) VALUES ("Bell II");
INSERT INTO `cities` (`name`) VALUES ("Bella Bella");
INSERT INTO `cities` (`name`) VALUES ("Bella Coola");
INSERT INTO `cities` (`name`) VALUES ("Belleview");
INSERT INTO `cities` (`name`) VALUES ("Bellos");
INSERT INTO `cities` (`name`) VALUES ("Belmont Park");
INSERT INTO `cities` (`name`) VALUES ("Belvedere");
INSERT INTO `cities` (`name`) VALUES ("Ben-My-Chree");
INSERT INTO `cities` (`name`) VALUES ("Bend");
INSERT INTO `cities` (`name`) VALUES ("Benledi");
INSERT INTO `cities` (`name`) VALUES ("Bennett");
INSERT INTO `cities` (`name`) VALUES ("Benson Lake");
INSERT INTO `cities` (`name`) VALUES ("Benvoulin");
INSERT INTO `cities` (`name`) VALUES ("Beresford");
INSERT INTO `cities` (`name`) VALUES ("Bergs");
INSERT INTO `cities` (`name`) VALUES ("Beryl Prairie");
INSERT INTO `cities` (`name`) VALUES ("Bessborough");
INSERT INTO `cities` (`name`) VALUES ("Bestwick");
INSERT INTO `cities` (`name`) VALUES ("Bevan");
INSERT INTO `cities` (`name`) VALUES ("Big Bar Creek");
INSERT INTO `cities` (`name`) VALUES ("Big Bay");
INSERT INTO `cities` (`name`) VALUES ("Big Creek");
INSERT INTO `cities` (`name`) VALUES ("Big Eddy");
INSERT INTO `cities` (`name`) VALUES ("Big Lake Ranch");
INSERT INTO `cities` (`name`) VALUES ("Big White");
INSERT INTO `cities` (`name`) VALUES ("Billings");
INSERT INTO `cities` (`name`) VALUES ("Billings Bay");
INSERT INTO `cities` (`name`) VALUES ("Birch Island");
INSERT INTO `cities` (`name`) VALUES ("Birchbank");
INSERT INTO `cities` (`name`) VALUES ("Birchdale");
INSERT INTO `cities` (`name`) VALUES ("Birchland Manor");
INSERT INTO `cities` (`name`) VALUES ("Birken");
INSERT INTO `cities` (`name`) VALUES ("Black Creek");
INSERT INTO `cities` (`name`) VALUES ("Black Pines");
INSERT INTO `cities` (`name`) VALUES ("Blackcomb");
INSERT INTO `cities` (`name`) VALUES ("Blackloam");
INSERT INTO `cities` (`name`) VALUES ("Blackpool");
INSERT INTO `cities` (`name`) VALUES ("Blackwater");
INSERT INTO `cities` (`name`) VALUES ("Blaeberry");
INSERT INTO `cities` (`name`) VALUES ("Blake");
INSERT INTO `cities` (`name`) VALUES ("Blakeburn");
INSERT INTO `cities` (`name`) VALUES ("Blewett");
INSERT INTO `cities` (`name`) VALUES ("Blind Bay");
INSERT INTO `cities` (`name`) VALUES ("Blind Channel");
INSERT INTO `cities` (`name`) VALUES ("Bliss Landing");
INSERT INTO `cities` (`name`) VALUES ("Bloedel");
INSERT INTO `cities` (`name`) VALUES ("Blowhole");
INSERT INTO `cities` (`name`) VALUES ("Blubber Bay");
INSERT INTO `cities` (`name`) VALUES ("Blucher Hall");
INSERT INTO `cities` (`name`) VALUES ("Blue Hills");
INSERT INTO `cities` (`name`) VALUES ("Blue River");
INSERT INTO `cities` (`name`) VALUES ("Blue River East");
INSERT INTO `cities` (`name`) VALUES ("Blue River West");
INSERT INTO `cities` (`name`) VALUES ("Blue Springs");
INSERT INTO `cities` (`name`) VALUES ("Blueberry Creek");
INSERT INTO `cities` (`name`) VALUES ("Blueridge");
INSERT INTO `cities` (`name`) VALUES ("Boat Basin");
INSERT INTO `cities` (`name`) VALUES ("Boat Harbour");
INSERT INTO `cities` (`name`) VALUES ("Bob Quinn Lake");
INSERT INTO `cities` (`name`) VALUES ("Bold Point");
INSERT INTO `cities` (`name`) VALUES ("Bond");
INSERT INTO `cities` (`name`) VALUES ("Bonnet Hill");
INSERT INTO `cities` (`name`) VALUES ("Bonnington Falls");
INSERT INTO `cities` (`name`) VALUES ("Boothroyd");
INSERT INTO `cities` (`name`) VALUES ("Boring Ranch");
INSERT INTO `cities` (`name`) VALUES ("Boston Bar");
INSERT INTO `cities` (`name`) VALUES ("Boston Flats");
INSERT INTO `cities` (`name`) VALUES ("Boswell");
INSERT INTO `cities` (`name`) VALUES ("Bouchie Lake");
INSERT INTO `cities` (`name`) VALUES ("Boulder");
INSERT INTO `cities` (`name`) VALUES ("Boulder City");
INSERT INTO `cities` (`name`) VALUES ("Boundary Bay");
INSERT INTO `cities` (`name`) VALUES ("Boundary Falls");
INSERT INTO `cities` (`name`) VALUES ("Boundary Road");
INSERT INTO `cities` (`name`) VALUES ("Bowen Bay");
INSERT INTO `cities` (`name`) VALUES ("Bowen Island");
INSERT INTO `cities` (`name`) VALUES ("Bowser");
INSERT INTO `cities` (`name`) VALUES ("Box Lake");
INSERT INTO `cities` (`name`) VALUES ("Brackendale");
INSERT INTO `cities` (`name`) VALUES ("Bradner");
INSERT INTO `cities` (`name`) VALUES ("Brady Ranch");
INSERT INTO `cities` (`name`) VALUES ("Braeloch");
INSERT INTO `cities` (`name`) VALUES ("Braemar Heights");
INSERT INTO `cities` (`name`) VALUES ("Braeside");
INSERT INTO `cities` (`name`) VALUES ("Bralorne");
INSERT INTO `cities` (`name`) VALUES ("Brandon");
INSERT INTO `cities` (`name`) VALUES ("Brandywine");
INSERT INTO `cities` (`name`) VALUES ("Brem River");
INSERT INTO `cities` (`name`) VALUES ("Brentwood Bay");
INSERT INTO `cities` (`name`) VALUES ("Brentwood Park");
INSERT INTO `cities` (`name`) VALUES ("Brew Bay");
INSERT INTO `cities` (`name`) VALUES ("Brexton");
INSERT INTO `cities` (`name`) VALUES ("Briar Ridge");
INSERT INTO `cities` (`name`) VALUES ("Bridal Falls");
INSERT INTO `cities` (`name`) VALUES ("Bridesville");
INSERT INTO `cities` (`name`) VALUES ("Bridge");
INSERT INTO `cities` (`name`) VALUES ("Bridge Lake");
INSERT INTO `cities` (`name`) VALUES ("Bridgeport");
INSERT INTO `cities` (`name`) VALUES ("Bridgeview");
INSERT INTO `cities` (`name`) VALUES ("Brigade Lake");
INSERT INTO `cities` (`name`) VALUES ("Brighouse");
INSERT INTO `cities` (`name`) VALUES ("Brighton Beach");
INSERT INTO `cities` (`name`) VALUES ("Brilliant");
INSERT INTO `cities` (`name`) VALUES ("Brisco");
INSERT INTO `cities` (`name`) VALUES ("Britannia Beach");
INSERT INTO `cities` (`name`) VALUES ("British Properties");
INSERT INTO `cities` (`name`) VALUES ("Broadmoor");
INSERT INTO `cities` (`name`) VALUES ("Broadview");
INSERT INTO `cities` (`name`) VALUES ("Brocklehurst");
INSERT INTO `cities` (`name`) VALUES ("Broman Lake");
INSERT INTO `cities` (`name`) VALUES ("Brookmere");
INSERT INTO `cities` (`name`) VALUES ("Brookswood");
INSERT INTO `cities` (`name`) VALUES ("Brouse");
INSERT INTO `cities` (`name`) VALUES ("Brownsville");
INSERT INTO `cities` (`name`) VALUES ("Brunette Creek");
INSERT INTO `cities` (`name`) VALUES ("Brunswick");
INSERT INTO `cities` (`name`) VALUES ("Brunswick Beach");
INSERT INTO `cities` (`name`) VALUES ("Bryn");
INSERT INTO `cities` (`name`) VALUES ("Buccaneer Bay");
INSERT INTO `cities` (`name`) VALUES ("Buckhorn");
INSERT INTO `cities` (`name`) VALUES ("Buckingham Heights");
INSERT INTO `cities` (`name`) VALUES ("Buckinghorse River");
INSERT INTO `cities` (`name`) VALUES ("Buckley Bay");
INSERT INTO `cities` (`name`) VALUES ("Buffalo Creek");
INSERT INTO `cities` (`name`) VALUES ("Buick");
INSERT INTO `cities` (`name`) VALUES ("Bulkley Canyon");
INSERT INTO `cities` (`name`) VALUES ("Bulkley House");
INSERT INTO `cities` (`name`) VALUES ("Bull Harbour");
INSERT INTO `cities` (`name`) VALUES ("Bull River");
INSERT INTO `cities` (`name`) VALUES ("Bungalow G");
INSERT INTO `cities` (`name`) VALUES ("Buntzen Bay");
INSERT INTO `cities` (`name`) VALUES ("Burke Road");
INSERT INTO `cities` (`name`) VALUES ("Burkeville");
INSERT INTO `cities` (`name`) VALUES ("Burnaby");
INSERT INTO `cities` (`name`) VALUES ("Burnaby Heights");
INSERT INTO `cities` (`name`) VALUES ("Burns Lake");
INSERT INTO `cities` (`name`) VALUES ("Burquitlam");
INSERT INTO `cities` (`name`) VALUES ("Burton");
INSERT INTO `cities` (`name`) VALUES ("Butedale");
INSERT INTO `cities` (`name`) VALUES ("Cache Creek");
INSERT INTO `cities` (`name`) VALUES ("Cadboro Bay");
INSERT INTO `cities` (`name`) VALUES ("Caesars");
INSERT INTO `cities` (`name`) VALUES ("Cahilty");
INSERT INTO `cities` (`name`) VALUES ("Caithness");
INSERT INTO `cities` (`name`) VALUES ("Cale");
INSERT INTO `cities` (`name`) VALUES ("Callison Ranch");
INSERT INTO `cities` (`name`) VALUES ("Cambie");
INSERT INTO `cities` (`name`) VALUES ("Camborne");
INSERT INTO `cities` (`name`) VALUES ("Cameron Heights");
INSERT INTO `cities` (`name`) VALUES ("Cameron Lake");
INSERT INTO `cities` (`name`) VALUES ("Camp Artaban");
INSERT INTO `cities` (`name`) VALUES ("Camp McKinney");
INSERT INTO `cities` (`name`) VALUES ("Campbell Creek");
INSERT INTO `cities` (`name`) VALUES ("Campbell Island");
INSERT INTO `cities` (`name`) VALUES ("Campbell River");
INSERT INTO `cities` (`name`) VALUES ("Campbellton");
INSERT INTO `cities` (`name`) VALUES ("Canal Flats");
INSERT INTO `cities` (`name`) VALUES ("Canford");
INSERT INTO `cities` (`name`) VALUES ("Canim");
INSERT INTO `cities` (`name`) VALUES ("Canim Lake");
INSERT INTO `cities` (`name`) VALUES ("Canoe");
INSERT INTO `cities` (`name`) VALUES ("Canoe River");
INSERT INTO `cities` (`name`) VALUES ("Canyon");
INSERT INTO `cities` (`name`) VALUES ("Canyon Alpine");
INSERT INTO `cities` (`name`) VALUES ("Canyon Heights");
INSERT INTO `cities` (`name`) VALUES ("Canyon Hot Springs");
INSERT INTO `cities` (`name`) VALUES ("Capilano Highlands");
INSERT INTO `cities` (`name`) VALUES ("Capitol Hill");
INSERT INTO `cities` (`name`) VALUES ("Cariboo");
INSERT INTO `cities` (`name`) VALUES ("Cariboo Meadows");
INSERT INTO `cities` (`name`) VALUES ("Carlin");
INSERT INTO `cities` (`name`) VALUES ("Carlson");
INSERT INTO `cities` (`name`) VALUES ("Carmi");
INSERT INTO `cities` (`name`) VALUES ("Carnaby");
INSERT INTO `cities` (`name`) VALUES ("Carp");
INSERT INTO `cities` (`name`) VALUES ("Carraholly");
INSERT INTO `cities` (`name`) VALUES ("Carrolls Landing");
INSERT INTO `cities` (`name`) VALUES ("Carrs");
INSERT INTO `cities` (`name`) VALUES ("Carson");
INSERT INTO `cities` (`name`) VALUES ("Cascade");
INSERT INTO `cities` (`name`) VALUES ("Cascade Heights");
INSERT INTO `cities` (`name`) VALUES ("Casino");
INSERT INTO `cities` (`name`) VALUES ("Cassiar");
INSERT INTO `cities` (`name`) VALUES ("Cassidy");
INSERT INTO `cities` (`name`) VALUES ("Cassin");
INSERT INTO `cities` (`name`) VALUES ("Castle Rock");
INSERT INTO `cities` (`name`) VALUES ("Castledale");
INSERT INTO `cities` (`name`) VALUES ("Castlegar");
INSERT INTO `cities` (`name`) VALUES ("Caswell");
INSERT INTO `cities` (`name`) VALUES ("Cathedral");
INSERT INTO `cities` (`name`) VALUES ("Caulfeild");
INSERT INTO `cities` (`name`) VALUES ("Cawston");
INSERT INTO `cities` (`name`) VALUES ("Caycuse");
INSERT INTO `cities` (`name`) VALUES ("Cecil Lake");
INSERT INTO `cities` (`name`) VALUES ("Cedar");
INSERT INTO `cities` (`name`) VALUES ("Cedar Grove");
INSERT INTO `cities` (`name`) VALUES ("Cedardale");
INSERT INTO `cities` (`name`) VALUES ("Cedarside");
INSERT INTO `cities` (`name`) VALUES ("Cedarvale");
INSERT INTO `cities` (`name`) VALUES ("Ceepeecee");
INSERT INTO `cities` (`name`) VALUES ("Celista");
INSERT INTO `cities` (`name`) VALUES ("Central Saanich");
INSERT INTO `cities` (`name`) VALUES ("Centreville");
INSERT INTO `cities` (`name`) VALUES ("CFB Chilliwack");
INSERT INTO `cities` (`name`) VALUES ("Cha cha tsi tsi us");
INSERT INTO `cities` (`name`) VALUES ("Chaatl");
INSERT INTO `cities` (`name`) VALUES ("Chamiss Bay");
INSERT INTO `cities` (`name`) VALUES ("Chap-is");
INSERT INTO `cities` (`name`) VALUES ("Chapman Camp");
INSERT INTO `cities` (`name`) VALUES ("Chapmans");
INSERT INTO `cities` (`name`) VALUES ("Charella Garden");
INSERT INTO `cities` (`name`) VALUES ("Charles");
INSERT INTO `cities` (`name`) VALUES ("Charlie Lake");
INSERT INTO `cities` (`name`) VALUES ("Charlotte Lake");
INSERT INTO `cities` (`name`) VALUES ("Chase");
INSERT INTO `cities` (`name`) VALUES ("Chase River");
INSERT INTO `cities` (`name`) VALUES ("Chasm");
INSERT INTO `cities` (`name`) VALUES ("Chaumox");
INSERT INTO `cities` (`name`) VALUES ("Cheakamus");
INSERT INTO `cities` (`name`) VALUES ("Cheam View");
INSERT INTO `cities` (`name`) VALUES ("Cheekye");
INSERT INTO `cities` (`name`) VALUES ("Chemainus");
INSERT INTO `cities` (`name`) VALUES ("Chenatha");
INSERT INTO `cities` (`name`) VALUES ("Chequis");
INSERT INTO `cities` (`name`) VALUES ("Cherry Creek");
INSERT INTO `cities` (`name`) VALUES ("Cherryville");
INSERT INTO `cities` (`name`) VALUES ("Cheslatta");
INSERT INTO `cities` (`name`) VALUES ("Chetarpe");
INSERT INTO `cities` (`name`) VALUES ("Chetwynd");
INSERT INTO `cities` (`name`) VALUES ("Chezacut");
INSERT INTO `cities` (`name`) VALUES ("Chilanko Forks");
INSERT INTO `cities` (`name`) VALUES ("Chilcotin Forest");
INSERT INTO `cities` (`name`) VALUES ("Chilliwack");
INSERT INTO `cities` (`name`) VALUES ("China Bar");
INSERT INTO `cities` (`name`) VALUES ("Chineside");
INSERT INTO `cities` (`name`) VALUES ("Chinook Cove");
INSERT INTO `cities` (`name`) VALUES ("Choate");
INSERT INTO `cities` (`name`) VALUES ("Chopaka");
INSERT INTO `cities` (`name`) VALUES ("Christian Valley");
INSERT INTO `cities` (`name`) VALUES ("Christina Lake");
INSERT INTO `cities` (`name`) VALUES ("Chu Chua");
INSERT INTO `cities` (`name`) VALUES ("Chumata");
INSERT INTO `cities` (`name`) VALUES ("Church House");
INSERT INTO `cities` (`name`) VALUES ("Chute Lake");
INSERT INTO `cities` (`name`) VALUES ("Cinema");
INSERT INTO `cities` (`name`) VALUES ("Cinnabar Valley");
INSERT INTO `cities` (`name`) VALUES ("Cisco");
INSERT INTO `cities` (`name`) VALUES ("Clairmont");
INSERT INTO `cities` (`name`) VALUES ("Clanwilliam");
INSERT INTO `cities` (`name`) VALUES ("Clapperton");
INSERT INTO `cities` (`name`) VALUES ("Clayburn");
INSERT INTO `cities` (`name`) VALUES ("Clayhurst");
INSERT INTO `cities` (`name`) VALUES ("Clayoquot");
INSERT INTO `cities` (`name`) VALUES ("Clearbrook");
INSERT INTO `cities` (`name`) VALUES ("Clearwater");
INSERT INTO `cities` (`name`) VALUES ("Clemina East");
INSERT INTO `cities` (`name`) VALUES ("Clemina West");
INSERT INTO `cities` (`name`) VALUES ("Clemretta");
INSERT INTO `cities` (`name`) VALUES ("Cleveland Park");
INSERT INTO `cities` (`name`) VALUES ("Cliffside");
INSERT INTO `cities` (`name`) VALUES ("Clinton");
INSERT INTO `cities` (`name`) VALUES ("Clo-oose");
INSERT INTO `cities` (`name`) VALUES ("Clode");
INSERT INTO `cities` (`name`) VALUES ("Cloverdale");
INSERT INTO `cities` (`name`) VALUES ("Clutus");
INSERT INTO `cities` (`name`) VALUES ("Coal Harbour");
INSERT INTO `cities` (`name`) VALUES ("Coal River");
INSERT INTO `cities` (`name`) VALUES ("Coalmont");
INSERT INTO `cities` (`name`) VALUES ("Cobble Hill");
INSERT INTO `cities` (`name`) VALUES ("Cody");
INSERT INTO `cities` (`name`) VALUES ("Cokato");
INSERT INTO `cities` (`name`) VALUES ("Coldspring House");
INSERT INTO `cities` (`name`) VALUES ("Coldstream");
INSERT INTO `cities` (`name`) VALUES ("Coldwell Beach");
INSERT INTO `cities` (`name`) VALUES ("Colebank");
INSERT INTO `cities` (`name`) VALUES ("Colebrook");
INSERT INTO `cities` (`name`) VALUES ("College Heights");
INSERT INTO `cities` (`name`) VALUES ("Collettville");
INSERT INTO `cities` (`name`) VALUES ("Colleymount");
INSERT INTO `cities` (`name`) VALUES ("Colquitz");
INSERT INTO `cities` (`name`) VALUES ("Columbia Gardens");
INSERT INTO `cities` (`name`) VALUES ("Colvalli");
INSERT INTO `cities` (`name`) VALUES ("Colwood");
INSERT INTO `cities` (`name`) VALUES ("Comer");
INSERT INTO `cities` (`name`) VALUES ("Commodore Heights");
INSERT INTO `cities` (`name`) VALUES ("Comox");
INSERT INTO `cities` (`name`) VALUES ("Connaught Heights");
INSERT INTO `cities` (`name`) VALUES ("Conrad");
INSERT INTO `cities` (`name`) VALUES ("Coombe");
INSERT INTO `cities` (`name`) VALUES ("Coombs");
INSERT INTO `cities` (`name`) VALUES ("Cooper Creek");
INSERT INTO `cities` (`name`) VALUES ("Copper Creek");
INSERT INTO `cities` (`name`) VALUES ("Copper Mountain");
INSERT INTO `cities` (`name`) VALUES ("Coquitlam");
INSERT INTO `cities` (`name`) VALUES ("Corbin");
INSERT INTO `cities` (`name`) VALUES ("Cordova Bay");
INSERT INTO `cities` (`name`) VALUES ("Corra Linn");
INSERT INTO `cities` (`name`) VALUES ("Cortes Bay");
INSERT INTO `cities` (`name`) VALUES ("Cosy Cove");
INSERT INTO `cities` (`name`) VALUES ("Cottonwood");
INSERT INTO `cities` (`name`) VALUES ("Cotwood");
INSERT INTO `cities` (`name`) VALUES ("Courtenay");
INSERT INTO `cities` (`name`) VALUES ("Coutlee");
INSERT INTO `cities` (`name`) VALUES ("Cove Cliff");
INSERT INTO `cities` (`name`) VALUES ("Cowans Point");
INSERT INTO `cities` (`name`) VALUES ("Cowichan Bay");
INSERT INTO `cities` (`name`) VALUES ("Cowichan Station");
INSERT INTO `cities` (`name`) VALUES ("Coykendahl");
INSERT INTO `cities` (`name`) VALUES ("Coyle");
INSERT INTO `cities` (`name`) VALUES ("Cracroft");
INSERT INTO `cities` (`name`) VALUES ("Craigellachie");
INSERT INTO `cities` (`name`) VALUES ("Cranberry");
INSERT INTO `cities` (`name`) VALUES ("Cranberry Junction");
INSERT INTO `cities` (`name`) VALUES ("Cranbrook");
INSERT INTO `cities` (`name`) VALUES ("Crawford Bay");
INSERT INTO `cities` (`name`) VALUES ("Creekside");
INSERT INTO `cities` (`name`) VALUES ("Creighton Valley");
INSERT INTO `cities` (`name`) VALUES ("Crescent");
INSERT INTO `cities` (`name`) VALUES ("Crescent Bay");
INSERT INTO `cities` (`name`) VALUES ("Crescent Beach");
INSERT INTO `cities` (`name`) VALUES ("Crescent Spur");
INSERT INTO `cities` (`name`) VALUES ("Crescent Valley");
INSERT INTO `cities` (`name`) VALUES ("Creston");
INSERT INTO `cities` (`name`) VALUES ("Criss Creek");
INSERT INTO `cities` (`name`) VALUES ("Crofton");
INSERT INTO `cities` (`name`) VALUES ("Crowsnest");
INSERT INTO `cities` (`name`) VALUES ("Croydon");
INSERT INTO `cities` (`name`) VALUES ("Crysdale");
INSERT INTO `cities` (`name`) VALUES ("Cultus Lake");
INSERT INTO `cities` (`name`) VALUES ("Cumberland");
INSERT INTO `cities` (`name`) VALUES ("Cumshewa");
INSERT INTO `cities` (`name`) VALUES ("Curzon");
INSERT INTO `cities` (`name`) VALUES ("Cypress Park");
INSERT INTO `cities` (`name`) VALUES ("D'Arcy");
INSERT INTO `cities` (`name`) VALUES ("Dadens");
INSERT INTO `cities` (`name`) VALUES ("Dallas");
INSERT INTO `cities` (`name`) VALUES ("Danskin");
INSERT INTO `cities` (`name`) VALUES ("Darfield");
INSERT INTO `cities` (`name`) VALUES ("Darrell Bay");
INSERT INTO `cities` (`name`) VALUES ("Dartmoor");
INSERT INTO `cities` (`name`) VALUES ("Dashwood");
INSERT INTO `cities` (`name`) VALUES ("Davidson");
INSERT INTO `cities` (`name`) VALUES ("Davis Bay");
INSERT INTO `cities` (`name`) VALUES ("Dawson Creek");
INSERT INTO `cities` (`name`) VALUES ("Dawsons Landing");
INSERT INTO `cities` (`name`) VALUES ("Days Ranch");
INSERT INTO `cities` (`name`) VALUES ("Deadwood");
INSERT INTO `cities` (`name`) VALUES ("Dease Lake");
INSERT INTO `cities` (`name`) VALUES ("Decker Lake");
INSERT INTO `cities` (`name`) VALUES ("Deekyakus");
INSERT INTO `cities` (`name`) VALUES ("Deep Bay");
INSERT INTO `cities` (`name`) VALUES ("Deep Cove");
INSERT INTO `cities` (`name`) VALUES ("Deep Creek");
INSERT INTO `cities` (`name`) VALUES ("Deer Park");
INSERT INTO `cities` (`name`) VALUES ("Deerholme");
INSERT INTO `cities` (`name`) VALUES ("Defot");
INSERT INTO `cities` (`name`) VALUES ("Deka Lake");
INSERT INTO `cities` (`name`) VALUES ("Delbrook");
INSERT INTO `cities` (`name`) VALUES ("Delkatla");
INSERT INTO `cities` (`name`) VALUES ("Delta");
INSERT INTO `cities` (`name`) VALUES ("Demean");
INSERT INTO `cities` (`name`) VALUES ("Denman Island");
INSERT INTO `cities` (`name`) VALUES ("Dentville");
INSERT INTO `cities` (`name`) VALUES ("Departure Bay");
INSERT INTO `cities` (`name`) VALUES ("Deroche");
INSERT INTO `cities` (`name`) VALUES ("Devine");
INSERT INTO `cities` (`name`) VALUES ("Dewdney");
INSERT INTO `cities` (`name`) VALUES ("Dewey");
INSERT INTO `cities` (`name`) VALUES ("Digby Island");
INSERT INTO `cities` (`name`) VALUES ("Dochsupple");
INSERT INTO `cities` (`name`) VALUES ("Dodge Cove");
INSERT INTO `cities` (`name`) VALUES ("Doe River");
INSERT INTO `cities` (`name`) VALUES ("Dog Creek");
INSERT INTO `cities` (`name`) VALUES ("Dogwood Valley");
INSERT INTO `cities` (`name`) VALUES ("Doig River");
INSERT INTO `cities` (`name`) VALUES ("Dokie");
INSERT INTO `cities` (`name`) VALUES ("Dokie Siding");
INSERT INTO `cities` (`name`) VALUES ("Dollarton");
INSERT INTO `cities` (`name`) VALUES ("Dolphin Beach");
INSERT INTO `cities` (`name`) VALUES ("Dome Creek");
INSERT INTO `cities` (`name`) VALUES ("Donald");
INSERT INTO `cities` (`name`) VALUES ("Donald Landing");
INSERT INTO `cities` (`name`) VALUES ("Donnely Landing");
INSERT INTO `cities` (`name`) VALUES ("Dookqua");
INSERT INTO `cities` (`name`) VALUES ("Doriston");
INSERT INTO `cities` (`name`) VALUES ("Dorreen");
INSERT INTO `cities` (`name`) VALUES ("Dot");
INSERT INTO `cities` (`name`) VALUES ("Douglas");
INSERT INTO `cities` (`name`) VALUES ("Douglas Lake");
INSERT INTO `cities` (`name`) VALUES ("Downie");
INSERT INTO `cities` (`name`) VALUES ("Dragon");
INSERT INTO `cities` (`name`) VALUES ("Drewry");
INSERT INTO `cities` (`name`) VALUES ("Driftwood Creek");
INSERT INTO `cities` (`name`) VALUES ("Dry Gulch");
INSERT INTO `cities` (`name`) VALUES ("Drynoch");
INSERT INTO `cities` (`name`) VALUES ("DuBose");
INSERT INTO `cities` (`name`) VALUES ("Duck Range");
INSERT INTO `cities` (`name`) VALUES ("Dufferin");
INSERT INTO `cities` (`name`) VALUES ("Dugan Lake");
INSERT INTO `cities` (`name`) VALUES ("Dunbar-Southlands");
INSERT INTO `cities` (`name`) VALUES ("Duncan");
INSERT INTO `cities` (`name`) VALUES ("Duncan Bay");
INSERT INTO `cities` (`name`) VALUES ("Duncanby Landing");
INSERT INTO `cities` (`name`) VALUES ("Dundarave");
INSERT INTO `cities` (`name`) VALUES ("Dunkley");
INSERT INTO `cities` (`name`) VALUES ("Dunsmuir");
INSERT INTO `cities` (`name`) VALUES ("Dunster");
INSERT INTO `cities` (`name`) VALUES ("Durieu");
INSERT INTO `cities` (`name`) VALUES ("Eagle Bay");
INSERT INTO `cities` (`name`) VALUES ("Eagle Bluff");
INSERT INTO `cities` (`name`) VALUES ("Eagle Creek");
INSERT INTO `cities` (`name`) VALUES ("Eagle Harbour");
INSERT INTO `cities` (`name`) VALUES ("Eagle Heights");
INSERT INTO `cities` (`name`) VALUES ("Eagle Ridge");
INSERT INTO `cities` (`name`) VALUES ("Eagle Run");
INSERT INTO `cities` (`name`) VALUES ("Earls Cove");
INSERT INTO `cities` (`name`) VALUES ("East Arrow Park");
INSERT INTO `cities` (`name`) VALUES ("East Gate");
INSERT INTO `cities` (`name`) VALUES ("East Kelowna");
INSERT INTO `cities` (`name`) VALUES ("East Osoyoos");
INSERT INTO `cities` (`name`) VALUES ("East Pine");
INSERT INTO `cities` (`name`) VALUES ("East Sooke");
INSERT INTO `cities` (`name`) VALUES ("East Trail");
INSERT INTO `cities` (`name`) VALUES ("East Wellington");
INSERT INTO `cities` (`name`) VALUES ("Eastbourne");
INSERT INTO `cities` (`name`) VALUES ("Eastburn");
INSERT INTO `cities` (`name`) VALUES ("Eastgate");
INSERT INTO `cities` (`name`) VALUES ("Echo Bay");
INSERT INTO `cities` (`name`) VALUES ("Ecoole");
INSERT INTO `cities` (`name`) VALUES ("Eddontenajon");
INSERT INTO `cities` (`name`) VALUES ("Eddy");
INSERT INTO `cities` (`name`) VALUES ("Edelweiss");
INSERT INTO `cities` (`name`) VALUES ("Edgewater");
INSERT INTO `cities` (`name`) VALUES ("Edgewood");
INSERT INTO `cities` (`name`) VALUES ("Egmont");
INSERT INTO `cities` (`name`) VALUES ("Ehatisaht");
INSERT INTO `cities` (`name`) VALUES ("Eholt");
INSERT INTO `cities` (`name`) VALUES ("Ekins Point");
INSERT INTO `cities` (`name`) VALUES ("Ekwan");
INSERT INTO `cities` (`name`) VALUES ("Elephant Crossing");
INSERT INTO `cities` (`name`) VALUES ("Elgin");
INSERT INTO `cities` (`name`) VALUES ("Elk Bay");
INSERT INTO `cities` (`name`) VALUES ("Elk Prairie");
INSERT INTO `cities` (`name`) VALUES ("Elkford");
INSERT INTO `cities` (`name`) VALUES ("Elko");
INSERT INTO `cities` (`name`) VALUES ("Elkview");
INSERT INTO `cities` (`name`) VALUES ("Elleh");
INSERT INTO `cities` (`name`) VALUES ("Ellison");
INSERT INTO `cities` (`name`) VALUES ("Elphinstone");
INSERT INTO `cities` (`name`) VALUES ("Encombe");
INSERT INTO `cities` (`name`) VALUES ("Endako");
INSERT INTO `cities` (`name`) VALUES ("Engen");
INSERT INTO `cities` (`name`) VALUES ("Engineer");
INSERT INTO `cities` (`name`) VALUES ("Enterprise");
INSERT INTO `cities` (`name`) VALUES ("Erickson");
INSERT INTO `cities` (`name`) VALUES ("Erie");
INSERT INTO `cities` (`name`) VALUES ("Errington");
INSERT INTO `cities` (`name`) VALUES ("Esler");
INSERT INTO `cities` (`name`) VALUES ("Esperanza");
INSERT INTO `cities` (`name`) VALUES ("Esquimalt");
INSERT INTO `cities` (`name`) VALUES ("Essondale");
INSERT INTO `cities` (`name`) VALUES ("Estevan Point");
INSERT INTO `cities` (`name`) VALUES ("Evans");
INSERT INTO `cities` (`name`) VALUES ("Evelyn");
INSERT INTO `cities` (`name`) VALUES ("Ewing");
INSERT INTO `cities` (`name`) VALUES ("Exeter");
INSERT INTO `cities` (`name`) VALUES ("Exlou");
INSERT INTO `cities` (`name`) VALUES ("Exstew");
INSERT INTO `cities` (`name`) VALUES ("Extension");
INSERT INTO `cities` (`name`) VALUES ("Fair Harbour");
INSERT INTO `cities` (`name`) VALUES ("Fairbridge");
INSERT INTO `cities` (`name`) VALUES ("Fairfield");
INSERT INTO `cities` (`name`) VALUES ("Fairmont");
INSERT INTO `cities` (`name`) VALUES ("Fairmont Hot Springs");
INSERT INTO `cities` (`name`) VALUES ("Fairview");
INSERT INTO `cities` (`name`) VALUES ("Falkland");
INSERT INTO `cities` (`name`) VALUES ("Falls");
INSERT INTO `cities` (`name`) VALUES ("Falls Creek");
INSERT INTO `cities` (`name`) VALUES ("False Bay");
INSERT INTO `cities` (`name`) VALUES ("Fanny Bay");
INSERT INTO `cities` (`name`) VALUES ("Farmington");
INSERT INTO `cities` (`name`) VALUES ("Farrell Creek");
INSERT INTO `cities` (`name`) VALUES ("Farron");
INSERT INTO `cities` (`name`) VALUES ("Faulder");
INSERT INTO `cities` (`name`) VALUES ("Fauquier");
INSERT INTO `cities` (`name`) VALUES ("Federal Ranch");
INSERT INTO `cities` (`name`) VALUES ("Fellers Heights");
INSERT INTO `cities` (`name`) VALUES ("Fenwick");
INSERT INTO `cities` (`name`) VALUES ("Ferguson");
INSERT INTO `cities` (`name`) VALUES ("Fern Ridge");
INSERT INTO `cities` (`name`) VALUES ("Ferndale");
INSERT INTO `cities` (`name`) VALUES ("Fernie");
INSERT INTO `cities` (`name`) VALUES ("Fernlee");
INSERT INTO `cities` (`name`) VALUES ("Fernwood");
INSERT INTO `cities` (`name`) VALUES ("Field");
INSERT INTO `cities` (`name`) VALUES ("Fife");
INSERT INTO `cities` (`name`) VALUES ("Fifth Cabin");
INSERT INTO `cities` (`name`) VALUES ("Fill");
INSERT INTO `cities` (`name`) VALUES ("Finmoore");
INSERT INTO `cities` (`name`) VALUES ("Fintry");
INSERT INTO `cities` (`name`) VALUES ("Fireside");
INSERT INTO `cities` (`name`) VALUES ("Firvale");
INSERT INTO `cities` (`name`) VALUES ("Fitzwilliam");
INSERT INTO `cities` (`name`) VALUES ("Five Mile");
INSERT INTO `cities` (`name`) VALUES ("Flat Creek");
INSERT INTO `cities` (`name`) VALUES ("Flathead");
INSERT INTO `cities` (`name`) VALUES ("Flatrock");
INSERT INTO `cities` (`name`) VALUES ("Fleetwood");
INSERT INTO `cities` (`name`) VALUES ("Fleming");
INSERT INTO `cities` (`name`) VALUES ("Floods");
INSERT INTO `cities` (`name`) VALUES ("Flying U");
INSERT INTO `cities` (`name`) VALUES ("Fontas");
INSERT INTO `cities` (`name`) VALUES ("Forde");
INSERT INTO `cities` (`name`) VALUES ("Fording");
INSERT INTO `cities` (`name`) VALUES ("Foreman");
INSERT INTO `cities` (`name`) VALUES ("Forest Grove");
INSERT INTO `cities` (`name`) VALUES ("Forest Hills");
INSERT INTO `cities` (`name`) VALUES ("Forest Knolls");
INSERT INTO `cities` (`name`) VALUES ("Forestdale");
INSERT INTO `cities` (`name`) VALUES ("Fort Babine");
INSERT INTO `cities` (`name`) VALUES ("Fort Fraser");
INSERT INTO `cities` (`name`) VALUES ("Fort Langley");
INSERT INTO `cities` (`name`) VALUES ("Fort Nelson");
INSERT INTO `cities` (`name`) VALUES ("Fort Rupert");
INSERT INTO `cities` (`name`) VALUES ("Fort St. James");
INSERT INTO `cities` (`name`) VALUES ("Fort St. John");
INSERT INTO `cities` (`name`) VALUES ("Fort Steele");
INSERT INTO `cities` (`name`) VALUES ("Fort Ware");
INSERT INTO `cities` (`name`) VALUES ("Foss");
INSERT INTO `cities` (`name`) VALUES ("Foster");
INSERT INTO `cities` (`name`) VALUES ("Fosthall");
INSERT INTO `cities` (`name`) VALUES ("Fountain");
INSERT INTO `cities` (`name`) VALUES ("Fountain Valley");
INSERT INTO `cities` (`name`) VALUES ("Fourth Cabin");
INSERT INTO `cities` (`name`) VALUES ("Fowler");
INSERT INTO `cities` (`name`) VALUES ("Fraine");
INSERT INTO `cities` (`name`) VALUES ("Frames");
INSERT INTO `cities` (`name`) VALUES ("Franklin Camp");
INSERT INTO `cities` (`name`) VALUES ("François Lake");
INSERT INTO `cities` (`name`) VALUES ("Fraser");
INSERT INTO `cities` (`name`) VALUES ("Fraser Heights");
INSERT INTO `cities` (`name`) VALUES ("Fraser Lake");
INSERT INTO `cities` (`name`) VALUES ("Fraser Mills");
INSERT INTO `cities` (`name`) VALUES ("Fraser River Junction");
INSERT INTO `cities` (`name`) VALUES ("Fraserview");
INSERT INTO `cities` (`name`) VALUES ("Frederick");
INSERT INTO `cities` (`name`) VALUES ("French Creek");
INSERT INTO `cities` (`name`) VALUES ("Fruitvale");
INSERT INTO `cities` (`name`) VALUES ("Fry Creek");
INSERT INTO `cities` (`name`) VALUES ("Fulford Harbour");
INSERT INTO `cities` (`name`) VALUES ("Furry Creek");
INSERT INTO `cities` (`name`) VALUES ("Gabriola");
INSERT INTO `cities` (`name`) VALUES ("Galena");
INSERT INTO `cities` (`name`) VALUES ("Galena Bay");
INSERT INTO `cities` (`name`) VALUES ("Galiano");
INSERT INTO `cities` (`name`) VALUES ("Galloway");
INSERT INTO `cities` (`name`) VALUES ("Gambier Harbour");
INSERT INTO `cities` (`name`) VALUES ("Gang Ranch");
INSERT INTO `cities` (`name`) VALUES ("Ganges");
INSERT INTO `cities` (`name`) VALUES ("Garbitt");
INSERT INTO `cities` (`name`) VALUES ("Garden Bay");
INSERT INTO `cities` (`name`) VALUES ("Garden Village");
INSERT INTO `cities` (`name`) VALUES ("Garibaldi");
INSERT INTO `cities` (`name`) VALUES ("Garibaldi Estates");
INSERT INTO `cities` (`name`) VALUES ("Garibaldi Highlands");
INSERT INTO `cities` (`name`) VALUES ("Garnet Valley");
INSERT INTO `cities` (`name`) VALUES ("Gates");
INSERT INTO `cities` (`name`) VALUES ("Gateway");
INSERT INTO `cities` (`name`) VALUES ("Gellatly");
INSERT INTO `cities` (`name`) VALUES ("Genelle");
INSERT INTO `cities` (`name`) VALUES ("Genoa Bay");
INSERT INTO `cities` (`name`) VALUES ("George River");
INSERT INTO `cities` (`name`) VALUES ("Georgetown Mills");
INSERT INTO `cities` (`name`) VALUES ("Germansen Landing");
INSERT INTO `cities` (`name`) VALUES ("Gerrard");
INSERT INTO `cities` (`name`) VALUES ("Gibbs");
INSERT INTO `cities` (`name`) VALUES ("Gibraltar");
INSERT INTO `cities` (`name`) VALUES ("Gibson Creek");
INSERT INTO `cities` (`name`) VALUES ("Gibsons");
INSERT INTO `cities` (`name`) VALUES ("Gifford");
INSERT INTO `cities` (`name`) VALUES ("Gillies Bay");
INSERT INTO `cities` (`name`) VALUES ("Gilpin");
INSERT INTO `cities` (`name`) VALUES ("Gingolx");
INSERT INTO `cities` (`name`) VALUES ("Giscome");
INSERT INTO `cities` (`name`) VALUES ("Gitanyow");
INSERT INTO `cities` (`name`) VALUES ("Gitlaxksiip");
INSERT INTO `cities` (`name`) VALUES ("Gitwinksihlkw");
INSERT INTO `cities` (`name`) VALUES ("Glacier");
INSERT INTO `cities` (`name`) VALUES ("Glade");
INSERT INTO `cities` (`name`) VALUES ("Gladwin");
INSERT INTO `cities` (`name`) VALUES ("Gleam");
INSERT INTO `cities` (`name`) VALUES ("Glen Fraser");
INSERT INTO `cities` (`name`) VALUES ("Glen Lake");
INSERT INTO `cities` (`name`) VALUES ("Glen Valley");
INSERT INTO `cities` (`name`) VALUES ("Glen Vowell");
INSERT INTO `cities` (`name`) VALUES ("Glenannan");
INSERT INTO `cities` (`name`) VALUES ("Glenbank");
INSERT INTO `cities` (`name`) VALUES ("Glenbrooke North");
INSERT INTO `cities` (`name`) VALUES ("Glendale");
INSERT INTO `cities` (`name`) VALUES ("Gleneagles");
INSERT INTO `cities` (`name`) VALUES ("Gleneden");
INSERT INTO `cities` (`name`) VALUES ("Glenemma");
INSERT INTO `cities` (`name`) VALUES ("Glenlily");
INSERT INTO `cities` (`name`) VALUES ("Glenmerry");
INSERT INTO `cities` (`name`) VALUES ("Glenmore");
INSERT INTO `cities` (`name`) VALUES ("Glenogle");
INSERT INTO `cities` (`name`) VALUES ("Glenora");
INSERT INTO `cities` (`name`) VALUES ("Glenrosa");
INSERT INTO `cities` (`name`) VALUES ("Glentanna");
INSERT INTO `cities` (`name`) VALUES ("Goat River");
INSERT INTO `cities` (`name`) VALUES ("Goatfell");
INSERT INTO `cities` (`name`) VALUES ("Gold Bridge");
INSERT INTO `cities` (`name`) VALUES ("Gold River");
INSERT INTO `cities` (`name`) VALUES ("Golden");
INSERT INTO `cities` (`name`) VALUES ("Goldstream");
INSERT INTO `cities` (`name`) VALUES ("Good Hope");
INSERT INTO `cities` (`name`) VALUES ("Good Hope Lake");
INSERT INTO `cities` (`name`) VALUES ("Goodlow");
INSERT INTO `cities` (`name`) VALUES ("Goose Bay");
INSERT INTO `cities` (`name`) VALUES ("Gordon Head");
INSERT INTO `cities` (`name`) VALUES ("Gordon River");
INSERT INTO `cities` (`name`) VALUES ("Gosnell");
INSERT INTO `cities` (`name`) VALUES ("Graham");
INSERT INTO `cities` (`name`) VALUES ("Gramsons");
INSERT INTO `cities` (`name`) VALUES ("Grand Forks");
INSERT INTO `cities` (`name`) VALUES ("Grand Haven");
INSERT INTO `cities` (`name`) VALUES ("Grand Rapids");
INSERT INTO `cities` (`name`) VALUES ("Grand Trunk");
INSERT INTO `cities` (`name`) VALUES ("Granduc");
INSERT INTO `cities` (`name`) VALUES ("Grandview");
INSERT INTO `cities` (`name`) VALUES ("Grandview Bench");
INSERT INTO `cities` (`name`) VALUES ("Grandview-Woodlands");
INSERT INTO `cities` (`name`) VALUES ("Granisle");
INSERT INTO `cities` (`name`) VALUES ("Granite");
INSERT INTO `cities` (`name`) VALUES ("Granite Bay");
INSERT INTO `cities` (`name`) VALUES ("Granite Falls");
INSERT INTO `cities` (`name`) VALUES ("Grant Brook");
INSERT INTO `cities` (`name`) VALUES ("Grantham");
INSERT INTO `cities` (`name`) VALUES ("Granthams Landing");
INSERT INTO `cities` (`name`) VALUES ("Grasmere");
INSERT INTO `cities` (`name`) VALUES ("Grassy Plains");
INSERT INTO `cities` (`name`) VALUES ("Gravelle Ferry");
INSERT INTO `cities` (`name`) VALUES ("Gray Creek");
INSERT INTO `cities` (`name`) VALUES ("Great Central");
INSERT INTO `cities` (`name`) VALUES ("Greata");
INSERT INTO `cities` (`name`) VALUES ("Greeley");
INSERT INTO `cities` (`name`) VALUES ("Green Cove");
INSERT INTO `cities` (`name`) VALUES ("Green River");
INSERT INTO `cities` (`name`) VALUES ("Greendale");
INSERT INTO `cities` (`name`) VALUES ("Greenhills");
INSERT INTO `cities` (`name`) VALUES ("Greening");
INSERT INTO `cities` (`name`) VALUES ("Greenwood");
INSERT INTO `cities` (`name`) VALUES ("Griffith");
INSERT INTO `cities` (`name`) VALUES ("Grindrod");
INSERT INTO `cities` (`name`) VALUES ("Groundbirch");
INSERT INTO `cities` (`name`) VALUES ("Guildford");
INSERT INTO `cities` (`name`) VALUES ("Gundy");
INSERT INTO `cities` (`name`) VALUES ("Gutah");
INSERT INTO `cities` (`name`) VALUES ("Gyproc");
INSERT INTO `cities` (`name`) VALUES ("Hagensborg");
INSERT INTO `cities` (`name`) VALUES ("Hagwilget");
INSERT INTO `cities` (`name`) VALUES ("Haig");
INSERT INTO `cities` (`name`) VALUES ("Haina");
INSERT INTO `cities` (`name`) VALUES ("Haisla");
INSERT INTO `cities` (`name`) VALUES ("Halfmoon Bay");
INSERT INTO `cities` (`name`) VALUES ("Halfway Ranch");
INSERT INTO `cities` (`name`) VALUES ("Hall");
INSERT INTO `cities` (`name`) VALUES ("Halliday");
INSERT INTO `cities` (`name`) VALUES ("Hanceville");
INSERT INTO `cities` (`name`) VALUES ("Haney");
INSERT INTO `cities` (`name`) VALUES ("Hansard");
INSERT INTO `cities` (`name`) VALUES ("Happy Valley");
INSERT INTO `cities` (`name`) VALUES ("Harbour Chines");
INSERT INTO `cities` (`name`) VALUES ("Harbour Village");
INSERT INTO `cities` (`name`) VALUES ("Hardwicke Island");
INSERT INTO `cities` (`name`) VALUES ("Harmac");
INSERT INTO `cities` (`name`) VALUES ("Harmer");
INSERT INTO `cities` (`name`) VALUES ("Harrison Hot Springs");
INSERT INTO `cities` (`name`) VALUES ("Harrison Mills");
INSERT INTO `cities` (`name`) VALUES ("Harrogate");
INSERT INTO `cities` (`name`) VALUES ("Harrop");
INSERT INTO `cities` (`name`) VALUES ("Hart");
INSERT INTO `cities` (`name`) VALUES ("Hart Highlands");
INSERT INTO `cities` (`name`) VALUES ("Hartley Bay");
INSERT INTO `cities` (`name`) VALUES ("Harvey");
INSERT INTO `cities` (`name`) VALUES ("Hasler Flat");
INSERT INTO `cities` (`name`) VALUES ("Hastings-Sunrise");
INSERT INTO `cities` (`name`) VALUES ("Hatzic");
INSERT INTO `cities` (`name`) VALUES ("Hawks");
INSERT INTO `cities` (`name`) VALUES ("Haysport");
INSERT INTO `cities` (`name`) VALUES ("Hayward");
INSERT INTO `cities` (`name`) VALUES ("Hazelmere");
INSERT INTO `cities` (`name`) VALUES ("Hazelton");
INSERT INTO `cities` (`name`) VALUES ("Headquarters");
INSERT INTO `cities` (`name`) VALUES ("Health Bay");
INSERT INTO `cities` (`name`) VALUES ("Hecate");
INSERT INTO `cities` (`name`) VALUES ("Hector");
INSERT INTO `cities` (`name`) VALUES ("Hedley");
INSERT INTO `cities` (`name`) VALUES ("Heffley Creek");
INSERT INTO `cities` (`name`) VALUES ("Hells Gate");
INSERT INTO `cities` (`name`) VALUES ("Hemlock Valley");
INSERT INTO `cities` (`name`) VALUES ("Hendrix Lake");
INSERT INTO `cities` (`name`) VALUES ("Heriot Bay");
INSERT INTO `cities` (`name`) VALUES ("Hesquiat");
INSERT INTO `cities` (`name`) VALUES ("Heydon Bay");
INSERT INTO `cities` (`name`) VALUES ("Hi'tatis");
INSERT INTO `cities` (`name`) VALUES ("Hickethier Ranch");
INSERT INTO `cities` (`name`) VALUES ("Hicks");
INSERT INTO `cities` (`name`) VALUES ("Highlands");
INSERT INTO `cities` (`name`) VALUES ("Hiina'is");
INSERT INTO `cities` (`name`) VALUES ("Hillbank");
INSERT INTO `cities` (`name`) VALUES ("Hillcrest");
INSERT INTO `cities` (`name`) VALUES ("Hilliers");
INSERT INTO `cities` (`name`) VALUES ("Hills");
INSERT INTO `cities` (`name`) VALUES ("Hilltop");
INSERT INTO `cities` (`name`) VALUES ("Hippa");
INSERT INTO `cities` (`name`) VALUES ("Hisnit");
INSERT INTO `cities` (`name`) VALUES ("Hitacu");
INSERT INTO `cities` (`name`) VALUES ("Hiusta Meadow");
INSERT INTO `cities` (`name`) VALUES ("Hixon");
INSERT INTO `cities` (`name`) VALUES ("Hkusam");
INSERT INTO `cities` (`name`) VALUES ("Hodda");
INSERT INTO `cities` (`name`) VALUES ("Holberg");
INSERT INTO `cities` (`name`) VALUES ("Hollyburn");
INSERT INTO `cities` (`name`) VALUES ("Holmwood");
INSERT INTO `cities` (`name`) VALUES ("Homfray Creek");
INSERT INTO `cities` (`name`) VALUES ("Honeymoon Bay");
INSERT INTO `cities` (`name`) VALUES ("Hoo-ii");
INSERT INTO `cities` (`name`) VALUES ("Hope");
INSERT INTO `cities` (`name`) VALUES ("Hope Bay");
INSERT INTO `cities` (`name`) VALUES ("Hopetown");
INSERT INTO `cities` (`name`) VALUES ("Hopington");
INSERT INTO `cities` (`name`) VALUES ("Hopkins Landing");
INSERT INTO `cities` (`name`) VALUES ("Hornby Island");
INSERT INTO `cities` (`name`) VALUES ("Horse Creek");
INSERT INTO `cities` (`name`) VALUES ("Horsefly");
INSERT INTO `cities` (`name`) VALUES ("Horseshoe Bay");
INSERT INTO `cities` (`name`) VALUES ("Hosmatqts'os");
INSERT INTO `cities` (`name`) VALUES ("Hosmer");
INSERT INTO `cities` (`name`) VALUES ("Hospital Hill");
INSERT INTO `cities` (`name`) VALUES ("Hot Springs Cove");
INSERT INTO `cities` (`name`) VALUES ("Houpsitas");
INSERT INTO `cities` (`name`) VALUES ("Houston");
INSERT INTO `cities` (`name`) VALUES ("Howser");
INSERT INTO `cities` (`name`) VALUES ("Hu'ul");
INSERT INTO `cities` (`name`) VALUES ("Huble");
INSERT INTO `cities` (`name`) VALUES ("Hudson's Hope");
INSERT INTO `cities` (`name`) VALUES ("Hulatt");
INSERT INTO `cities` (`name`) VALUES ("Hulcross");
INSERT INTO `cities` (`name`) VALUES ("Hullcar");
INSERT INTO `cities` (`name`) VALUES ("Huntingdon");
INSERT INTO `cities` (`name`) VALUES ("Huntington");
INSERT INTO `cities` (`name`) VALUES ("Hunts Inlet");
INSERT INTO `cities` (`name`) VALUES ("Hupel");
INSERT INTO `cities` (`name`) VALUES ("Huscroft");
INSERT INTO `cities` (`name`) VALUES ("Hutchison");
INSERT INTO `cities` (`name`) VALUES ("Hutton");
INSERT INTO `cities` (`name`) VALUES ("Hyde Creek");
INSERT INTO `cities` (`name`) VALUES ("Hydraulic");
INSERT INTO `cities` (`name`) VALUES ("Hydro");
INSERT INTO `cities` (`name`) VALUES ("Hyland Post");
INSERT INTO `cities` (`name`) VALUES ("Hyland Ranch");
INSERT INTO `cities` (`name`) VALUES ("Illecillewaet");
INSERT INTO `cities` (`name`) VALUES ("Ingenika Mine");
INSERT INTO `cities` (`name`) VALUES ("Inkaneep");
INSERT INTO `cities` (`name`) VALUES ("Inkitsaph");
INSERT INTO `cities` (`name`) VALUES ("Invermere");
INSERT INTO `cities` (`name`) VALUES ("Ioco");
INSERT INTO `cities` (`name`) VALUES ("Iracard");
INSERT INTO `cities` (`name`) VALUES ("Iron Bay");
INSERT INTO `cities` (`name`) VALUES ("Irvine");
INSERT INTO `cities` (`name`) VALUES ("Irvines Landing");
INSERT INTO `cities` (`name`) VALUES ("Iskut");
INSERT INTO `cities` (`name`) VALUES ("Island Cache");
INSERT INTO `cities` (`name`) VALUES ("Isle Pierre");
INSERT INTO `cities` (`name`) VALUES ("Jackman");
INSERT INTO `cities` (`name`) VALUES ("Jackson Bay");
INSERT INTO `cities` (`name`) VALUES ("Jacksons");
INSERT INTO `cities` (`name`) VALUES ("Jade City");
INSERT INTO `cities` (`name`) VALUES ("Jaffray");
INSERT INTO `cities` (`name`) VALUES ("Jaleslie");
INSERT INTO `cities` (`name`) VALUES ("James Bay");
INSERT INTO `cities` (`name`) VALUES ("Jayem");
INSERT INTO `cities` (`name`) VALUES ("Jedway");
INSERT INTO `cities` (`name`) VALUES ("Jellicoe");
INSERT INTO `cities` (`name`) VALUES ("Jersey");
INSERT INTO `cities` (`name`) VALUES ("Jesmond");
INSERT INTO `cities` (`name`) VALUES ("Jeune Landing");
INSERT INTO `cities` (`name`) VALUES ("Johnson");
INSERT INTO `cities` (`name`) VALUES ("Johnson Heights");
INSERT INTO `cities` (`name`) VALUES ("Johnsons Landing");
INSERT INTO `cities` (`name`) VALUES ("Jumbo Glacier");
INSERT INTO `cities` (`name`) VALUES ("Juniper Ridge");
INSERT INTO `cities` (`name`) VALUES ("Jura");
INSERT INTO `cities` (`name`) VALUES ("Juskatla");
INSERT INTO `cities` (`name`) VALUES ("K'i Deldel");
INSERT INTO `cities` (`name`) VALUES ("K'oxsinqii");
INSERT INTO `cities` (`name`) VALUES ("Ka-x-shiitl");
INSERT INTO `cities` (`name`) VALUES ("Ka:ook");
INSERT INTO `cities` (`name`) VALUES ("Ka:oop:insh");
INSERT INTO `cities` (`name`) VALUES ("Ka:youk");
INSERT INTO `cities` (`name`) VALUES ("Kahkeeky");
INSERT INTO `cities` (`name`) VALUES ("Kahntah");
INSERT INTO `cities` (`name`) VALUES ("Kaisun");
INSERT INTO `cities` (`name`) VALUES ("Kakawis");
INSERT INTO `cities` (`name`) VALUES ("Kalamalka");
INSERT INTO `cities` (`name`) VALUES ("Kaleden");
INSERT INTO `cities` (`name`) VALUES ("Kallum");
INSERT INTO `cities` (`name`) VALUES ("Kamloops");
INSERT INTO `cities` (`name`) VALUES ("Kamloops Junction");
INSERT INTO `cities` (`name`) VALUES ("Kanaka");
INSERT INTO `cities` (`name`) VALUES ("Kanaka Bar");
INSERT INTO `cities` (`name`) VALUES ("Karlukwees");
INSERT INTO `cities` (`name`) VALUES ("Kaslo");
INSERT INTO `cities` (`name`) VALUES ("Katz");
INSERT INTO `cities` (`name`) VALUES ("Keating");
INSERT INTO `cities` (`name`) VALUES ("Keats Island");
INSERT INTO `cities` (`name`) VALUES ("Kedleston");
INSERT INTO `cities` (`name`) VALUES ("Keefers");
INSERT INTO `cities` (`name`) VALUES ("Keith-Lynn");
INSERT INTO `cities` (`name`) VALUES ("Keithley Creek");
INSERT INTO `cities` (`name`) VALUES ("Kelly Lake");
INSERT INTO `cities` (`name`) VALUES ("Kelowna");
INSERT INTO `cities` (`name`) VALUES ("Kelvin");
INSERT INTO `cities` (`name`) VALUES ("Kemano");
INSERT INTO `cities` (`name`) VALUES ("Kemano Beach");
INSERT INTO `cities` (`name`) VALUES ("Kendrick Camp");
INSERT INTO `cities` (`name`) VALUES ("Kennedy");
INSERT INTO `cities` (`name`) VALUES ("Kensington-Cedar Cottage");
INSERT INTO `cities` (`name`) VALUES ("Kent");
INSERT INTO `cities` (`name`) VALUES ("Keremeos");
INSERT INTO `cities` (`name`) VALUES ("Kerr Creek");
INSERT INTO `cities` (`name`) VALUES ("Kerrisdale");
INSERT INTO `cities` (`name`) VALUES ("Kersley");
INSERT INTO `cities` (`name`) VALUES ("Kettle Valley");
INSERT INTO `cities` (`name`) VALUES ("Kicking Horse");
INSERT INTO `cities` (`name`) VALUES ("Kidd");
INSERT INTO `cities` (`name`) VALUES ("Kiikiixink'ok");
INSERT INTO `cities` (`name`) VALUES ("Kiix aa");
INSERT INTO `cities` (`name`) VALUES ("Kiix-in");
INSERT INTO `cities` (`name`) VALUES ("Kilbella Bay");
INSERT INTO `cities` (`name`) VALUES ("Kildala Arm");
INSERT INTO `cities` (`name`) VALUES ("Kildonan");
INSERT INTO `cities` (`name`) VALUES ("Kilgard");
INSERT INTO `cities` (`name`) VALUES ("Kilkerran");
INSERT INTO `cities` (`name`) VALUES ("Killarney");
INSERT INTO `cities` (`name`) VALUES ("Killiney Beach");
INSERT INTO `cities` (`name`) VALUES ("Killy");
INSERT INTO `cities` (`name`) VALUES ("Kimberley");
INSERT INTO `cities` (`name`) VALUES ("Kimsquit");
INSERT INTO `cities` (`name`) VALUES ("Kingcome");
INSERT INTO `cities` (`name`) VALUES ("Kingcome Inlet");
INSERT INTO `cities` (`name`) VALUES ("Kingfisher");
INSERT INTO `cities` (`name`) VALUES ("Kingsgate");
INSERT INTO `cities` (`name`) VALUES ("Kingsvale");
INSERT INTO `cities` (`name`) VALUES ("Kinnaird");
INSERT INTO `cities` (`name`) VALUES ("Kiskatinaw");
INSERT INTO `cities` (`name`) VALUES ("Kispiox");
INSERT INTO `cities` (`name`) VALUES ("Kissick");
INSERT INTO `cities` (`name`) VALUES ("Kitamaat Village");
INSERT INTO `cities` (`name`) VALUES ("Kitchener");
INSERT INTO `cities` (`name`) VALUES ("Kitimat");
INSERT INTO `cities` (`name`) VALUES ("Kitkatla");
INSERT INTO `cities` (`name`) VALUES ("Kitsault");
INSERT INTO `cities` (`name`) VALUES ("Kitseguecla");
INSERT INTO `cities` (`name`) VALUES ("Kitselas");
INSERT INTO `cities` (`name`) VALUES ("Kitsilano");
INSERT INTO `cities` (`name`) VALUES ("Kitsumkalum");
INSERT INTO `cities` (`name`) VALUES ("Kitwanga");
INSERT INTO `cities` (`name`) VALUES ("Kiusta");
INSERT INTO `cities` (`name`) VALUES ("Kleecoot");
INSERT INTO `cities` (`name`) VALUES ("Kleena Kleene");
INSERT INTO `cities` (`name`) VALUES ("Kleindale");
INSERT INTO `cities` (`name`) VALUES ("Klemtu");
INSERT INTO `cities` (`name`) VALUES ("Kliikliihuwis");
INSERT INTO `cities` (`name`) VALUES ("Klit-kle-mah-ah");
INSERT INTO `cities` (`name`) VALUES ("Klua");
INSERT INTO `cities` (`name`) VALUES ("Knockholt");
INSERT INTO `cities` (`name`) VALUES ("Knutsford");
INSERT INTO `cities` (`name`) VALUES ("Kobes");
INSERT INTO `cities` (`name`) VALUES ("Kokish");
INSERT INTO `cities` (`name`) VALUES ("Koksilah");
INSERT INTO `cities` (`name`) VALUES ("Komo");
INSERT INTO `cities` (`name`) VALUES ("Kookswees");
INSERT INTO `cities` (`name`) VALUES ("Kootenay Bay");
INSERT INTO `cities` (`name`) VALUES ("Kootenay Crossing");
INSERT INTO `cities` (`name`) VALUES ("Kootenay Landing");
INSERT INTO `cities` (`name`) VALUES ("Koster");
INSERT INTO `cities` (`name`) VALUES ("Kragmont");
INSERT INTO `cities` (`name`) VALUES ("Krestova");
INSERT INTO `cities` (`name`) VALUES ("Kuldo");
INSERT INTO `cities` (`name`) VALUES ("Kung");
INSERT INTO `cities` (`name`) VALUES ("Kuskonook");
INSERT INTO `cities` (`name`) VALUES ("Kwinaquth");
INSERT INTO `cities` (`name`) VALUES ("Kwinitsa");
INSERT INTO `cities` (`name`) VALUES ("Kwisitis");
INSERT INTO `cities` (`name`) VALUES ("Kyuquot");
INSERT INTO `cities` (`name`) VALUES ("Lac la Hache");
INSERT INTO `cities` (`name`) VALUES ("Lac Le Jeune");
INSERT INTO `cities` (`name`) VALUES ("Ladner");
INSERT INTO `cities` (`name`) VALUES ("Ladysmith");
INSERT INTO `cities` (`name`) VALUES ("Lafferty");
INSERT INTO `cities` (`name`) VALUES ("Laidlaw");
INSERT INTO `cities` (`name`) VALUES ("Lake Buntzen");
INSERT INTO `cities` (`name`) VALUES ("Lake Country");
INSERT INTO `cities` (`name`) VALUES ("Lake Cowichan");
INSERT INTO `cities` (`name`) VALUES ("Lake Errock");
INSERT INTO `cities` (`name`) VALUES ("Lake Hill");
INSERT INTO `cities` (`name`) VALUES ("Lake Kathlyn");
INSERT INTO `cities` (`name`) VALUES ("Lakelse");
INSERT INTO `cities` (`name`) VALUES ("Lakelse Lake");
INSERT INTO `cities` (`name`) VALUES ("Laketon");
INSERT INTO `cities` (`name`) VALUES ("Lakeview Heights");
INSERT INTO `cities` (`name`) VALUES ("Lamming Mills");
INSERT INTO `cities` (`name`) VALUES ("Lang Bay");
INSERT INTO `cities` (`name`) VALUES ("Langdale");
INSERT INTO `cities` (`name`) VALUES ("Langford");
INSERT INTO `cities` (`name`) VALUES ("Langley");
INSERT INTO `cities` (`name`) VALUES ("Lantzville");
INSERT INTO `cities` (`name`) VALUES ("Lardeau");
INSERT INTO `cities` (`name`) VALUES ("Larkin");
INSERT INTO `cities` (`name`) VALUES ("Larsons Landing");
INSERT INTO `cities` (`name`) VALUES ("Lasha");
INSERT INTO `cities` (`name`) VALUES ("Lasqueti");
INSERT INTO `cities` (`name`) VALUES ("Laurentian Belaire");
INSERT INTO `cities` (`name`) VALUES ("Lauretta");
INSERT INTO `cities` (`name`) VALUES ("Lavington");
INSERT INTO `cities` (`name`) VALUES ("Lawnhill");
INSERT INTO `cities` (`name`) VALUES ("Lax Kw'alaams");
INSERT INTO `cities` (`name`) VALUES ("Laxgalts'ap");
INSERT INTO `cities` (`name`) VALUES ("Lazo");
INSERT INTO `cities` (`name`) VALUES ("Leanchoil");
INSERT INTO `cities` (`name`) VALUES ("Lebahdo");
INSERT INTO `cities` (`name`) VALUES ("Lee Creek");
INSERT INTO `cities` (`name`) VALUES ("Leechtown");
INSERT INTO `cities` (`name`) VALUES ("Lees Corner");
INSERT INTO `cities` (`name`) VALUES ("Legrand");
INSERT INTO `cities` (`name`) VALUES ("Lejac");
INSERT INTO `cities` (`name`) VALUES ("Lemon Creek");
INSERT INTO `cities` (`name`) VALUES ("Lemoray");
INSERT INTO `cities` (`name`) VALUES ("Lempriere");
INSERT INTO `cities` (`name`) VALUES ("Leo Creek");
INSERT INTO `cities` (`name`) VALUES ("Lexau Ranch");
INSERT INTO `cities` (`name`) VALUES ("Liard River");
INSERT INTO `cities` (`name`) VALUES ("Liersch");
INSERT INTO `cities` (`name`) VALUES ("Lighthouse Point");
INSERT INTO `cities` (`name`) VALUES ("Likely");
INSERT INTO `cities` (`name`) VALUES ("Lillooet");
INSERT INTO `cities` (`name`) VALUES ("Lily Lake");
INSERT INTO `cities` (`name`) VALUES ("Lime");
INSERT INTO `cities` (`name`) VALUES ("Lincoln Park");
INSERT INTO `cities` (`name`) VALUES ("Lindell");
INSERT INTO `cities` (`name`) VALUES ("Lindell Beach");
INSERT INTO `cities` (`name`) VALUES ("Lindeman");
INSERT INTO `cities` (`name`) VALUES ("Line Creek");
INSERT INTO `cities` (`name`) VALUES ("Lions Bay");
INSERT INTO `cities` (`name`) VALUES ("Lister");
INSERT INTO `cities` (`name`) VALUES ("Little Fort");
INSERT INTO `cities` (`name`) VALUES ("Little River");
INSERT INTO `cities` (`name`) VALUES ("Livingstone");
INSERT INTO `cities` (`name`) VALUES ("Lockeport");
INSERT INTO `cities` (`name`) VALUES ("Log Cabin");
INSERT INTO `cities` (`name`) VALUES ("Logan Lake");
INSERT INTO `cities` (`name`) VALUES ("Lone Butte");
INSERT INTO `cities` (`name`) VALUES ("Lone Prairie");
INSERT INTO `cities` (`name`) VALUES ("Long Harbour");
INSERT INTO `cities` (`name`) VALUES ("Longbeach");
INSERT INTO `cities` (`name`) VALUES ("Longworth");
INSERT INTO `cities` (`name`) VALUES ("Loon Lake");
INSERT INTO `cities` (`name`) VALUES ("Loos");
INSERT INTO `cities` (`name`) VALUES ("Louis Creek");
INSERT INTO `cities` (`name`) VALUES ("Lower China Creek");
INSERT INTO `cities` (`name`) VALUES ("Lower Lonsdale");
INSERT INTO `cities` (`name`) VALUES ("Lower Nicola");
INSERT INTO `cities` (`name`) VALUES ("Lower Post");
INSERT INTO `cities` (`name`) VALUES ("Lubin");
INSERT INTO `cities` (`name`) VALUES ("Lucas");
INSERT INTO `cities` (`name`) VALUES ("Lucerne");
INSERT INTO `cities` (`name`) VALUES ("Lumberton");
INSERT INTO `cities` (`name`) VALUES ("Lumby");
INSERT INTO `cities` (`name`) VALUES ("Lumby Junction");
INSERT INTO `cities` (`name`) VALUES ("Lund");
INSERT INTO `cities` (`name`) VALUES ("Lust Subdivision");
INSERT INTO `cities` (`name`) VALUES ("Luxor");
INSERT INTO `cities` (`name`) VALUES ("Luxton");
INSERT INTO `cities` (`name`) VALUES ("Lynn Valley");
INSERT INTO `cities` (`name`) VALUES ("Lynnmour");
INSERT INTO `cities` (`name`) VALUES ("Lynx Creek");
INSERT INTO `cities` (`name`) VALUES ("Lytton");
INSERT INTO `cities` (`name`) VALUES ("Maalth-sit");
INSERT INTO `cities` (`name`) VALUES ("Mabel Lake");
INSERT INTO `cities` (`name`) VALUES ("Macalister");
INSERT INTO `cities` (`name`) VALUES ("Macdonald");
INSERT INTO `cities` (`name`) VALUES ("Mackenzie");
INSERT INTO `cities` (`name`) VALUES ("Mackin");
INSERT INTO `cities` (`name`) VALUES ("MacNeill");
INSERT INTO `cities` (`name`) VALUES ("Macoah");
INSERT INTO `cities` (`name`) VALUES ("Madeira Park");
INSERT INTO `cities` (`name`) VALUES ("Magna Bay");
INSERT INTO `cities` (`name`) VALUES ("Magnum Mine");
INSERT INTO `cities` (`name`) VALUES ("Mah:kiit");
INSERT INTO `cities` (`name`) VALUES ("Mahatta River");
INSERT INTO `cities` (`name`) VALUES ("Mahood Falls");
INSERT INTO `cities` (`name`) VALUES ("Mahope");
INSERT INTO `cities` (`name`) VALUES ("Maht'ii'as");
INSERT INTO `cities` (`name`) VALUES ("Maillardville");
INSERT INTO `cities` (`name`) VALUES ("Makinson");
INSERT INTO `cities` (`name`) VALUES ("Malahat");
INSERT INTO `cities` (`name`) VALUES ("Malakwa");
INSERT INTO `cities` (`name`) VALUES ("Malibu");
INSERT INTO `cities` (`name`) VALUES ("Manning");
INSERT INTO `cities` (`name`) VALUES ("Manning Park");
INSERT INTO `cities` (`name`) VALUES ("Manson Creek");
INSERT INTO `cities` (`name`) VALUES ("Mansons Landing");
INSERT INTO `cities` (`name`) VALUES ("Mapes");
INSERT INTO `cities` (`name`) VALUES ("Maple Bay");
INSERT INTO `cities` (`name`) VALUES ("Maple Ridge");
INSERT INTO `cities` (`name`) VALUES ("Maplewood");
INSERT INTO `cities` (`name`) VALUES ("Maq:cup");
INSERT INTO `cities` (`name`) VALUES ("Mara");
INSERT INTO `cities` (`name`) VALUES ("Marblehead");
INSERT INTO `cities` (`name`) VALUES ("Margaret Bay");
INSERT INTO `cities` (`name`) VALUES ("Marguerite");
INSERT INTO `cities` (`name`) VALUES ("Marigold");
INSERT INTO `cities` (`name`) VALUES ("Marilla");
INSERT INTO `cities` (`name`) VALUES ("Marktosis");
INSERT INTO `cities` (`name`) VALUES ("Marne");
INSERT INTO `cities` (`name`) VALUES ("Marpole");
INSERT INTO `cities` (`name`) VALUES ("Marron Valley");
INSERT INTO `cities` (`name`) VALUES ("Marshall School Junction");
INSERT INTO `cities` (`name`) VALUES ("Martel");
INSERT INTO `cities` (`name`) VALUES ("Marten Lake");
INSERT INTO `cities` (`name`) VALUES ("Martin Prairie");
INSERT INTO `cities` (`name`) VALUES ("Martinson");
INSERT INTO `cities` (`name`) VALUES ("Mary Hill");
INSERT INTO `cities` (`name`) VALUES ("Marysville");
INSERT INTO `cities` (`name`) VALUES ("Mason Creek");
INSERT INTO `cities` (`name`) VALUES ("Masset");
INSERT INTO `cities` (`name`) VALUES ("Matilpi");
INSERT INTO `cities` (`name`) VALUES ("Matsqui");
INSERT INTO `cities` (`name`) VALUES ("Mayfair");
INSERT INTO `cities` (`name`) VALUES ("Mayne Island");
INSERT INTO `cities` (`name`) VALUES ("Mayook");
INSERT INTO `cities` (`name`) VALUES ("McAbee");
INSERT INTO `cities` (`name`) VALUES ("McBride");
INSERT INTO `cities` (`name`) VALUES ("McCabe");
INSERT INTO `cities` (`name`) VALUES ("McCall");
INSERT INTO `cities` (`name`) VALUES ("McCalls Landing");
INSERT INTO `cities` (`name`) VALUES ("McConnel");
INSERT INTO `cities` (`name`) VALUES ("McCracken");
INSERT INTO `cities` (`name`) VALUES ("McCulloch");
INSERT INTO `cities` (`name`) VALUES ("McDame");
INSERT INTO `cities` (`name`) VALUES ("McDonalds Landing");
INSERT INTO `cities` (`name`) VALUES ("McGillivray");
INSERT INTO `cities` (`name`) VALUES ("McGregor");
INSERT INTO `cities` (`name`) VALUES ("McGuire");
INSERT INTO `cities` (`name`) VALUES ("McKearney Ranch");
INSERT INTO `cities` (`name`) VALUES ("McKinley Landing");
INSERT INTO `cities` (`name`) VALUES ("McLean Ranch");
INSERT INTO `cities` (`name`) VALUES ("McLeese Lake");
INSERT INTO `cities` (`name`) VALUES ("McLeod");
INSERT INTO `cities` (`name`) VALUES ("McLeod Lake");
INSERT INTO `cities` (`name`) VALUES ("McLure");
INSERT INTO `cities` (`name`) VALUES ("McMurdo");
INSERT INTO `cities` (`name`) VALUES ("McMurphy");
INSERT INTO `cities` (`name`) VALUES ("McNab Creek");
INSERT INTO `cities` (`name`) VALUES ("Meachen");
INSERT INTO `cities` (`name`) VALUES ("Meadow Creek");
INSERT INTO `cities` (`name`) VALUES ("Meadowbrook");
INSERT INTO `cities` (`name`) VALUES ("Meadows");
INSERT INTO `cities` (`name`) VALUES ("Meem Quam Leese");
INSERT INTO `cities` (`name`) VALUES ("Meldrum");
INSERT INTO `cities` (`name`) VALUES ("Meldrum Creek");
INSERT INTO `cities` (`name`) VALUES ("Merritt");
INSERT INTO `cities` (`name`) VALUES ("Merton");
INSERT INTO `cities` (`name`) VALUES ("Merville");
INSERT INTO `cities` (`name`) VALUES ("Mesachie Lake");
INSERT INTO `cities` (`name`) VALUES ("Messiter");
INSERT INTO `cities` (`name`) VALUES ("Metchosin");
INSERT INTO `cities` (`name`) VALUES ("Metlakatla");
INSERT INTO `cities` (`name`) VALUES ("Metrotown");
INSERT INTO `cities` (`name`) VALUES ("Meziadin Junction");
INSERT INTO `cities` (`name`) VALUES ("Mica Creek");
INSERT INTO `cities` (`name`) VALUES ("Middle River");
INSERT INTO `cities` (`name`) VALUES ("Middlegate");
INSERT INTO `cities` (`name`) VALUES ("Midway");
INSERT INTO `cities` (`name`) VALUES ("Mile 62 1/2");
INSERT INTO `cities` (`name`) VALUES ("Mill Bay");
INSERT INTO `cities` (`name`) VALUES ("Millers Landing");
INSERT INTO `cities` (`name`) VALUES ("Millstream");
INSERT INTO `cities` (`name`) VALUES ("Milner");
INSERT INTO `cities` (`name`) VALUES ("Milnes Landing");
INSERT INTO `cities` (`name`) VALUES ("Minaty Bay");
INSERT INTO `cities` (`name`) VALUES ("Minstrel Island");
INSERT INTO `cities` (`name`) VALUES ("Minto Landing");
INSERT INTO `cities` (`name`) VALUES ("Miocene");
INSERT INTO `cities` (`name`) VALUES ("Miracle Valley");
INSERT INTO `cities` (`name`) VALUES ("Mirror Lake");
INSERT INTO `cities` (`name`) VALUES ("Mission");
INSERT INTO `cities` (`name`) VALUES ("Mitchell Bay");
INSERT INTO `cities` (`name`) VALUES ("Miworth");
INSERT INTO `cities` (`name`) VALUES ("Moberly");
INSERT INTO `cities` (`name`) VALUES ("Moberly Lake");
INSERT INTO `cities` (`name`) VALUES ("Moffat");
INSERT INTO `cities` (`name`) VALUES ("Moha");
INSERT INTO `cities` (`name`) VALUES ("Monias");
INSERT INTO `cities` (`name`) VALUES ("Mons");
INSERT INTO `cities` (`name`) VALUES ("Montague Harbour");
INSERT INTO `cities` (`name`) VALUES ("Monte Creek");
INSERT INTO `cities` (`name`) VALUES ("Monte Lake");
INSERT INTO `cities` (`name`) VALUES ("Montney");
INSERT INTO `cities` (`name`) VALUES ("Montrose");
INSERT INTO `cities` (`name`) VALUES ("Moose Heights");
INSERT INTO `cities` (`name`) VALUES ("Mooyah Bay");
INSERT INTO `cities` (`name`) VALUES ("Moran");
INSERT INTO `cities` (`name`) VALUES ("Moresby Camp");
INSERT INTO `cities` (`name`) VALUES ("Morey");
INSERT INTO `cities` (`name`) VALUES ("Moricetown");
INSERT INTO `cities` (`name`) VALUES ("Morrissey");
INSERT INTO `cities` (`name`) VALUES ("Mount Baldy");
INSERT INTO `cities` (`name`) VALUES ("Mount Currie");
INSERT INTO `cities` (`name`) VALUES ("Mount Gardner");
INSERT INTO `cities` (`name`) VALUES ("Mount Lehman");
INSERT INTO `cities` (`name`) VALUES ("Mount Pleasant");
INSERT INTO `cities` (`name`) VALUES ("Mount Robson");
INSERT INTO `cities` (`name`) VALUES ("Mount Washington");
INSERT INTO `cities` (`name`) VALUES ("Mountain Station");
INSERT INTO `cities` (`name`) VALUES ("Moyie");
INSERT INTO `cities` (`name`) VALUES ("Mud Bay");
INSERT INTO `cities` (`name`) VALUES ("Mud River");
INSERT INTO `cities` (`name`) VALUES ("Muncho Lake");
INSERT INTO `cities` (`name`) VALUES ("Munro");
INSERT INTO `cities` (`name`) VALUES ("Munroe");
INSERT INTO `cities` (`name`) VALUES ("Murdale");
INSERT INTO `cities` (`name`) VALUES ("Murrayville");
INSERT INTO `cities` (`name`) VALUES ("Musgrave Landing");
INSERT INTO `cities` (`name`) VALUES ("Muskwa");
INSERT INTO `cities` (`name`) VALUES ("Myra");
INSERT INTO `cities` (`name`) VALUES ("Myrtle Point");
INSERT INTO `cities` (`name`) VALUES ("Nahmint");
INSERT INTO `cities` (`name`) VALUES ("Nahun");
INSERT INTO `cities` (`name`) VALUES ("Nakusp");
INSERT INTO `cities` (`name`) VALUES ("Nalos Landing");
INSERT INTO `cities` (`name`) VALUES ("Namu");
INSERT INTO `cities` (`name`) VALUES ("Nanaimo");
INSERT INTO `cities` (`name`) VALUES ("Nanoose Bay");
INSERT INTO `cities` (`name`) VALUES ("Naramata");
INSERT INTO `cities` (`name`) VALUES ("Narcosli Creek");
INSERT INTO `cities` (`name`) VALUES ("Nass Camp");
INSERT INTO `cities` (`name`) VALUES ("Natal");
INSERT INTO `cities` (`name`) VALUES ("Nazko");
INSERT INTO `cities` (`name`) VALUES ("Nechako");
INSERT INTO `cities` (`name`) VALUES ("Needles");
INSERT INTO `cities` (`name`) VALUES ("Needley");
INSERT INTO `cities` (`name`) VALUES ("Nelson");
INSERT INTO `cities` (`name`) VALUES ("Nelson Forks");
INSERT INTO `cities` (`name`) VALUES ("Nelway");
INSERT INTO `cities` (`name`) VALUES ("Nemaiah Valley");
INSERT INTO `cities` (`name`) VALUES ("Nesters");
INSERT INTO `cities` (`name`) VALUES ("New Aiyansh");
INSERT INTO `cities` (`name`) VALUES ("New Brighton");
INSERT INTO `cities` (`name`) VALUES ("New Clew");
INSERT INTO `cities` (`name`) VALUES ("New Denver");
INSERT INTO `cities` (`name`) VALUES ("New Hazelton");
INSERT INTO `cities` (`name`) VALUES ("New Settlement");
INSERT INTO `cities` (`name`) VALUES ("New Westminster");
INSERT INTO `cities` (`name`) VALUES ("Newcastle");
INSERT INTO `cities` (`name`) VALUES ("Newgate");
INSERT INTO `cities` (`name`) VALUES ("Newlands");
INSERT INTO `cities` (`name`) VALUES ("Newton");
INSERT INTO `cities` (`name`) VALUES ("Niagara");
INSERT INTO `cities` (`name`) VALUES ("Nichol");
INSERT INTO `cities` (`name`) VALUES ("Nichols");
INSERT INTO `cities` (`name`) VALUES ("Nicholson");
INSERT INTO `cities` (`name`) VALUES ("Nicola");
INSERT INTO `cities` (`name`) VALUES ("Nicomen");
INSERT INTO `cities` (`name`) VALUES ("Nig");
INSERT INTO `cities` (`name`) VALUES ("Nimpkish");
INSERT INTO `cities` (`name`) VALUES ("Nimpkish Heights");
INSERT INTO `cities` (`name`) VALUES ("Nimpo Lake");
INSERT INTO `cities` (`name`) VALUES ("Ninstints");
INSERT INTO `cities` (`name`) VALUES ("Niteal");
INSERT INTO `cities` (`name`) VALUES ("Nootka");
INSERT INTO `cities` (`name`) VALUES ("Noralee");
INSERT INTO `cities` (`name`) VALUES ("Norgate");
INSERT INTO `cities` (`name`) VALUES ("Norlake");
INSERT INTO `cities` (`name`) VALUES ("North Bend");
INSERT INTO `cities` (`name`) VALUES ("North Bonaparte");
INSERT INTO `cities` (`name`) VALUES ("North Bulkley");
INSERT INTO `cities` (`name`) VALUES ("North Campbell River");
INSERT INTO `cities` (`name`) VALUES ("North Cowichan");
INSERT INTO `cities` (`name`) VALUES ("North Delta");
INSERT INTO `cities` (`name`) VALUES ("North Galiano");
INSERT INTO `cities` (`name`) VALUES ("North Kamloops");
INSERT INTO `cities` (`name`) VALUES ("North Lonsdale");
INSERT INTO `cities` (`name`) VALUES ("North Nechako");
INSERT INTO `cities` (`name`) VALUES ("North Pine");
INSERT INTO `cities` (`name`) VALUES ("North Poplar");
INSERT INTO `cities` (`name`) VALUES ("North Saanich");
INSERT INTO `cities` (`name`) VALUES ("North Star");
INSERT INTO `cities` (`name`) VALUES ("North Vancouver");
INSERT INTO `cities` (`name`) VALUES ("North Woodlands");
INSERT INTO `cities` (`name`) VALUES ("Northern Rockies Regional Municipality");
INSERT INTO `cities` (`name`) VALUES ("Northfield");
INSERT INTO `cities` (`name`) VALUES ("Northridge");
INSERT INTO `cities` (`name`) VALUES ("Norton");
INSERT INTO `cities` (`name`) VALUES ("Notch Hill");
INSERT INTO `cities` (`name`) VALUES ("Nuchaquis");
INSERT INTO `cities` (`name`) VALUES ("Nuchatlitz");
INSERT INTO `cities` (`name`) VALUES ("Nukko Lake");
INSERT INTO `cities` (`name`) VALUES ("Nulki");
INSERT INTO `cities` (`name`) VALUES ("Nursery");
INSERT INTO `cities` (`name`) VALUES ("Nuumaqimyis");
INSERT INTO `cities` (`name`) VALUES ("Ná:mint");
INSERT INTO `cities` (`name`) VALUES ("O'Dell");
INSERT INTO `cities` (`name`) VALUES ("O'Keefe");
INSERT INTO `cities` (`name`) VALUES ("Oak Bay");
INSERT INTO `cities` (`name`) VALUES ("Oak Hills");
INSERT INTO `cities` (`name`) VALUES ("Oakridge");
INSERT INTO `cities` (`name`) VALUES ("Oasis");
INSERT INTO `cities` (`name`) VALUES ("Ocean Falls");
INSERT INTO `cities` (`name`) VALUES ("Ocean Grove");
INSERT INTO `cities` (`name`) VALUES ("Ocean Park");
INSERT INTO `cities` (`name`) VALUES ("Ogden");
INSERT INTO `cities` (`name`) VALUES ("Okanagan Centre");
INSERT INTO `cities` (`name`) VALUES ("Okanagan Falls");
INSERT INTO `cities` (`name`) VALUES ("Okanagan Landing");
INSERT INTO `cities` (`name`) VALUES ("Okanagan Mission");
INSERT INTO `cities` (`name`) VALUES ("Olalla");
INSERT INTO `cities` (`name`) VALUES ("Old Bella Bella");
INSERT INTO `cities` (`name`) VALUES ("Old Fort");
INSERT INTO `cities` (`name`) VALUES ("Old Fort Nelson");
INSERT INTO `cities` (`name`) VALUES ("Old Hogem");
INSERT INTO `cities` (`name`) VALUES ("Old Massett");
INSERT INTO `cities` (`name`) VALUES ("Old Remo");
INSERT INTO `cities` (`name`) VALUES ("Old Town");
INSERT INTO `cities` (`name`) VALUES ("Oliver");
INSERT INTO `cities` (`name`) VALUES ("Oliver's Landing");
INSERT INTO `cities` (`name`) VALUES ("Olson");
INSERT INTO `cities` (`name`) VALUES ("Onward");
INSERT INTO `cities` (`name`) VALUES ("Oona River");
INSERT INTO `cities` (`name`) VALUES ("Ootischenia");
INSERT INTO `cities` (`name`) VALUES ("Ootsa Lake");
INSERT INTO `cities` (`name`) VALUES ("Opitsat");
INSERT INTO `cities` (`name`) VALUES ("Orlomah Beach");
INSERT INTO `cities` (`name`) VALUES ("Osborn");
INSERT INTO `cities` (`name`) VALUES ("Osborn Bay");
INSERT INTO `cities` (`name`) VALUES ("Osland");
INSERT INTO `cities` (`name`) VALUES ("Osoyoos");
INSERT INTO `cities` (`name`) VALUES ("Osprey Lake");
INSERT INTO `cities` (`name`) VALUES ("Othello");
INSERT INTO `cities` (`name`) VALUES ("Ots'oo-a");
INSERT INTO `cities` (`name`) VALUES ("Otter Bay");
INSERT INTO `cities` (`name`) VALUES ("Ottertail");
INSERT INTO `cities` (`name`) VALUES ("Otway");
INSERT INTO `cities` (`name`) VALUES ("Ououkinsh");
INSERT INTO `cities` (`name`) VALUES ("Oweekeno");
INSERT INTO `cities` (`name`) VALUES ("Owen Bay");
INSERT INTO `cities` (`name`) VALUES ("Owl Creek");
INSERT INTO `cities` (`name`) VALUES ("Oxford Heights");
INSERT INTO `cities` (`name`) VALUES ("Oyama");
INSERT INTO `cities` (`name`) VALUES ("Oyster River");
INSERT INTO `cities` (`name`) VALUES ("Pacific");
INSERT INTO `cities` (`name`) VALUES ("Pahkeeahjim");
INSERT INTO `cities` (`name`) VALUES ("Paldi");
INSERT INTO `cities` (`name`) VALUES ("Palling");
INSERT INTO `cities` (`name`) VALUES ("Palliser");
INSERT INTO `cities` (`name`) VALUES ("Palmer");
INSERT INTO `cities` (`name`) VALUES ("Panorama");
INSERT INTO `cities` (`name`) VALUES ("Panorama Ridge");
INSERT INTO `cities` (`name`) VALUES ("Paradise Point");
INSERT INTO `cities` (`name`) VALUES ("Paradise Valley");
INSERT INTO `cities` (`name`) VALUES ("Park Royal");
INSERT INTO `cities` (`name`) VALUES ("Park Siding");
INSERT INTO `cities` (`name`) VALUES ("Parkdale Gardens");
INSERT INTO `cities` (`name`) VALUES ("Parkland");
INSERT INTO `cities` (`name`) VALUES ("Parksville");
INSERT INTO `cities` (`name`) VALUES ("Parson");
INSERT INTO `cities` (`name`) VALUES ("Pasley Island");
INSERT INTO `cities` (`name`) VALUES ("Pass Creek");
INSERT INTO `cities` (`name`) VALUES ("Passmore");
INSERT INTO `cities` (`name`) VALUES ("Paterson");
INSERT INTO `cities` (`name`) VALUES ("Paulson");
INSERT INTO `cities` (`name`) VALUES ("Pavey");
INSERT INTO `cities` (`name`) VALUES ("Pavilion");
INSERT INTO `cities` (`name`) VALUES ("Peachland");
INSERT INTO `cities` (`name`) VALUES ("Peejay");
INSERT INTO `cities` (`name`) VALUES ("Pemberton");
INSERT INTO `cities` (`name`) VALUES ("Pemberton Heights");
INSERT INTO `cities` (`name`) VALUES ("Pemberton Meadows");
INSERT INTO `cities` (`name`) VALUES ("Pender Island");
INSERT INTO `cities` (`name`) VALUES ("Pendleton Bay");
INSERT INTO `cities` (`name`) VALUES ("Pennington");
INSERT INTO `cities` (`name`) VALUES ("Penny");
INSERT INTO `cities` (`name`) VALUES ("Penticton");
INSERT INTO `cities` (`name`) VALUES ("Perow");
INSERT INTO `cities` (`name`) VALUES ("Perrys");
INSERT INTO `cities` (`name`) VALUES ("Peterson");
INSERT INTO `cities` (`name`) VALUES ("Phelan");
INSERT INTO `cities` (`name`) VALUES ("Phillips Arm");
INSERT INTO `cities` (`name`) VALUES ("Phoenix");
INSERT INTO `cities` (`name`) VALUES ("Pinantan Lake");
INSERT INTO `cities` (`name`) VALUES ("Pinchi");
INSERT INTO `cities` (`name`) VALUES ("Pinchi Lake");
INSERT INTO `cities` (`name`) VALUES ("Pine Valley");
INSERT INTO `cities` (`name`) VALUES ("Pinegrove");
INSERT INTO `cities` (`name`) VALUES ("Pinesul");
INSERT INTO `cities` (`name`) VALUES ("Pineview");
INSERT INTO `cities` (`name`) VALUES ("Pink Mountain");
INSERT INTO `cities` (`name`) VALUES ("Pioneer Mine");
INSERT INTO `cities` (`name`) VALUES ("Pitman");
INSERT INTO `cities` (`name`) VALUES ("Pitquah");
INSERT INTO `cities` (`name`) VALUES ("Pitt Meadows");
INSERT INTO `cities` (`name`) VALUES ("Pixie Beach");
INSERT INTO `cities` (`name`) VALUES ("Playmor Junction");
INSERT INTO `cities` (`name`) VALUES ("Pleasant Camp");
INSERT INTO `cities` (`name`) VALUES ("Pleasantside");
INSERT INTO `cities` (`name`) VALUES ("Plumper Harbour");
INSERT INTO `cities` (`name`) VALUES ("Polley");
INSERT INTO `cities` (`name`) VALUES ("Pope Landing");
INSERT INTO `cities` (`name`) VALUES ("Popkum");
INSERT INTO `cities` (`name`) VALUES ("Poplar Creek");
INSERT INTO `cities` (`name`) VALUES ("Poplar Grove");
INSERT INTO `cities` (`name`) VALUES ("Porcher Island");
INSERT INTO `cities` (`name`) VALUES ("Port Alberni");
INSERT INTO `cities` (`name`) VALUES ("Port Albion");
INSERT INTO `cities` (`name`) VALUES ("Port Alice");
INSERT INTO `cities` (`name`) VALUES ("Port Clements");
INSERT INTO `cities` (`name`) VALUES ("Port Coquitlam");
INSERT INTO `cities` (`name`) VALUES ("Port Desire");
INSERT INTO `cities` (`name`) VALUES ("Port Douglas");
INSERT INTO `cities` (`name`) VALUES ("Port Edward");
INSERT INTO `cities` (`name`) VALUES ("Port Essington");
INSERT INTO `cities` (`name`) VALUES ("Port Guichon");
INSERT INTO `cities` (`name`) VALUES ("Port Hammond");
INSERT INTO `cities` (`name`) VALUES ("Port Hardy");
INSERT INTO `cities` (`name`) VALUES ("Port Kells");
INSERT INTO `cities` (`name`) VALUES ("Port Mann");
INSERT INTO `cities` (`name`) VALUES ("Port McNeill");
INSERT INTO `cities` (`name`) VALUES ("Port Mellon");
INSERT INTO `cities` (`name`) VALUES ("Port Moody");
INSERT INTO `cities` (`name`) VALUES ("Port Neville");
INSERT INTO `cities` (`name`) VALUES ("Port Renfrew");
INSERT INTO `cities` (`name`) VALUES ("Port Washington");
INSERT INTO `cities` (`name`) VALUES ("Porteau");
INSERT INTO `cities` (`name`) VALUES ("Porteous");
INSERT INTO `cities` (`name`) VALUES ("Porter Landing");
INSERT INTO `cities` (`name`) VALUES ("Porto Rico");
INSERT INTO `cities` (`name`) VALUES ("Poser");
INSERT INTO `cities` (`name`) VALUES ("Postill");
INSERT INTO `cities` (`name`) VALUES ("Potter");
INSERT INTO `cities` (`name`) VALUES ("Pouce Coupe");
INSERT INTO `cities` (`name`) VALUES ("Poupore");
INSERT INTO `cities` (`name`) VALUES ("Powell River");
INSERT INTO `cities` (`name`) VALUES ("Powers Addition");
INSERT INTO `cities` (`name`) VALUES ("Prairie Valley");
INSERT INTO `cities` (`name`) VALUES ("Prairiedale");
INSERT INTO `cities` (`name`) VALUES ("Pratt");
INSERT INTO `cities` (`name`) VALUES ("Premier");
INSERT INTO `cities` (`name`) VALUES ("Premier Lake");
INSERT INTO `cities` (`name`) VALUES ("Prespatou");
INSERT INTO `cities` (`name`) VALUES ("Prince George");
INSERT INTO `cities` (`name`) VALUES ("Prince Rupert");
INSERT INTO `cities` (`name`) VALUES ("Princeton");
INSERT INTO `cities` (`name`) VALUES ("Pritchard");
INSERT INTO `cities` (`name`) VALUES ("Procter");
INSERT INTO `cities` (`name`) VALUES ("Progress");
INSERT INTO `cities` (`name`) VALUES ("Promontory");
INSERT INTO `cities` (`name`) VALUES ("Prophet River");
INSERT INTO `cities` (`name`) VALUES ("Prospect Lake");
INSERT INTO `cities` (`name`) VALUES ("Punchaw");
INSERT INTO `cities` (`name`) VALUES ("Puntledge");
INSERT INTO `cities` (`name`) VALUES ("Pyramid");
INSERT INTO `cities` (`name`) VALUES ("Qualicum Bay");
INSERT INTO `cities` (`name`) VALUES ("Qualicum Beach");
INSERT INTO `cities` (`name`) VALUES ("Quathiaski Cove");
INSERT INTO `cities` (`name`) VALUES ("Quatsino");
INSERT INTO `cities` (`name`) VALUES ("Quaw");
INSERT INTO `cities` (`name`) VALUES ("Queen Charlotte");
INSERT INTO `cities` (`name`) VALUES ("Queen Charlotte, Village of");
INSERT INTO `cities` (`name`) VALUES ("Queens Bay");
INSERT INTO `cities` (`name`) VALUES ("Queens Cove");
INSERT INTO `cities` (`name`) VALUES ("Queens Park");
INSERT INTO `cities` (`name`) VALUES ("Queensborough");
INSERT INTO `cities` (`name`) VALUES ("Quesnel");
INSERT INTO `cities` (`name`) VALUES ("Quesnel Forks");
INSERT INTO `cities` (`name`) VALUES ("Quesnel View");
INSERT INTO `cities` (`name`) VALUES ("Quick");
INSERT INTO `cities` (`name`) VALUES ("Quilchena");
INSERT INTO `cities` (`name`) VALUES ("Quin-e-ex");
INSERT INTO `cities` (`name`) VALUES ("Quinsam");
INSERT INTO `cities` (`name`) VALUES ("Radium");
INSERT INTO `cities` (`name`) VALUES ("Radium Hot Springs");
INSERT INTO `cities` (`name`) VALUES ("Rainy Hollow");
INSERT INTO `cities` (`name`) VALUES ("Ranch Park");
INSERT INTO `cities` (`name`) VALUES ("Ranchero");
INSERT INTO `cities` (`name`) VALUES ("Raspberry");
INSERT INTO `cities` (`name`) VALUES ("Raush Valley");
INSERT INTO `cities` (`name`) VALUES ("Rawlison");
INSERT INTO `cities` (`name`) VALUES ("Rayleigh");
INSERT INTO `cities` (`name`) VALUES ("Read Island");
INSERT INTO `cities` (`name`) VALUES ("Reclaim");
INSERT INTO `cities` (`name`) VALUES ("Red Bluff");
INSERT INTO `cities` (`name`) VALUES ("Red Pass");
INSERT INTO `cities` (`name`) VALUES ("Red Rock");
INSERT INTO `cities` (`name`) VALUES ("Red Rose");
INSERT INTO `cities` (`name`) VALUES ("Redgrave");
INSERT INTO `cities` (`name`) VALUES ("Redroofs");
INSERT INTO `cities` (`name`) VALUES ("Redstone");
INSERT INTO `cities` (`name`) VALUES ("Refuge Cove");
INSERT INTO `cities` (`name`) VALUES ("Reid Lake");
INSERT INTO `cities` (`name`) VALUES ("Remac");
INSERT INTO `cities` (`name`) VALUES ("Remo");
INSERT INTO `cities` (`name`) VALUES ("Renata");
INSERT INTO `cities` (`name`) VALUES ("Renfrew-Collingwood");
INSERT INTO `cities` (`name`) VALUES ("Retallack");
INSERT INTO `cities` (`name`) VALUES ("Retaskit");
INSERT INTO `cities` (`name`) VALUES ("Revelstoke");
INSERT INTO `cities` (`name`) VALUES ("Rhone");
INSERT INTO `cities` (`name`) VALUES ("Rich Bar");
INSERT INTO `cities` (`name`) VALUES ("Richmond");
INSERT INTO `cities` (`name`) VALUES ("Rider");
INSERT INTO `cities` (`name`) VALUES ("Ridgedale");
INSERT INTO `cities` (`name`) VALUES ("Ridley");
INSERT INTO `cities` (`name`) VALUES ("Riley");
INSERT INTO `cities` (`name`) VALUES ("Riley Park");
INSERT INTO `cities` (`name`) VALUES ("Riondel");
INSERT INTO `cities` (`name`) VALUES ("Riske Creek");
INSERT INTO `cities` (`name`) VALUES ("Ritchie");
INSERT INTO `cities` (`name`) VALUES ("River Jordan");
INSERT INTO `cities` (`name`) VALUES ("River Springs");
INSERT INTO `cities` (`name`) VALUES ("Rivers Inlet");
INSERT INTO `cities` (`name`) VALUES ("Riverside");
INSERT INTO `cities` (`name`) VALUES ("Rivervale");
INSERT INTO `cities` (`name`) VALUES ("Roberts Creek");
INSERT INTO `cities` (`name`) VALUES ("Robin Creek");
INSERT INTO `cities` (`name`) VALUES ("Robson");
INSERT INTO `cities` (`name`) VALUES ("Robson West");
INSERT INTO `cities` (`name`) VALUES ("Rock Bay");
INSERT INTO `cities` (`name`) VALUES ("Rock Creek");
INSERT INTO `cities` (`name`) VALUES ("Rockyview");
INSERT INTO `cities` (`name`) VALUES ("Roe Lake");
INSERT INTO `cities` (`name`) VALUES ("Rogers");
INSERT INTO `cities` (`name`) VALUES ("Rogers Pass");
INSERT INTO `cities` (`name`) VALUES ("Rolla");
INSERT INTO `cities` (`name`) VALUES ("Roosville");
INSERT INTO `cities` (`name`) VALUES ("Rose Harbour");
INSERT INTO `cities` (`name`) VALUES ("Rose Lake");
INSERT INTO `cities` (`name`) VALUES ("Rose Prairie");
INSERT INTO `cities` (`name`) VALUES ("Rosebery");
INSERT INTO `cities` (`name`) VALUES ("Rosedale");
INSERT INTO `cities` (`name`) VALUES ("Ross Peak");
INSERT INTO `cities` (`name`) VALUES ("Ross Spur");
INSERT INTO `cities` (`name`) VALUES ("Rossland");
INSERT INTO `cities` (`name`) VALUES ("Rosswood");
INSERT INTO `cities` (`name`) VALUES ("Round Lake");
INSERT INTO `cities` (`name`) VALUES ("Round Prairie");
INSERT INTO `cities` (`name`) VALUES ("Roy");
INSERT INTO `cities` (`name`) VALUES ("Royal Oak");
INSERT INTO `cities` (`name`) VALUES ("Royston");
INSERT INTO `cities` (`name`) VALUES ("Ruby Creek");
INSERT INTO `cities` (`name`) VALUES ("Rumble Beach");
INSERT INTO `cities` (`name`) VALUES ("Rupert");
INSERT INTO `cities` (`name`) VALUES ("Rushmere");
INSERT INTO `cities` (`name`) VALUES ("Ruskin");
INSERT INTO `cities` (`name`) VALUES ("Rutland");
INSERT INTO `cities` (`name`) VALUES ("Ryan");
INSERT INTO `cities` (`name`) VALUES ("Ryder Lake");
INSERT INTO `cities` (`name`) VALUES ("Rykerts");
INSERT INTO `cities` (`name`) VALUES ("Saanich");
INSERT INTO `cities` (`name`) VALUES ("Saanichton");
INSERT INTO `cities` (`name`) VALUES ("Sachawil");
INSERT INTO `cities` (`name`) VALUES ("Sachsa");
INSERT INTO `cities` (`name`) VALUES ("Saddle Rock");
INSERT INTO `cities` (`name`) VALUES ("Sahali");
INSERT INTO `cities` (`name`) VALUES ("Sahara Heights");
INSERT INTO `cities` (`name`) VALUES ("Sahtlam");
INSERT INTO `cities` (`name`) VALUES ("Salmo");
INSERT INTO `cities` (`name`) VALUES ("Salmon Arm");
INSERT INTO `cities` (`name`) VALUES ("Salmon Beach");
INSERT INTO `cities` (`name`) VALUES ("Salmon Valley");
INSERT INTO `cities` (`name`) VALUES ("Saloon");
INSERT INTO `cities` (`name`) VALUES ("Saltair");
INSERT INTO `cities` (`name`) VALUES ("Saltery Bay");
INSERT INTO `cities` (`name`) VALUES ("Salvus");
INSERT INTO `cities` (`name`) VALUES ("San Josef");
INSERT INTO `cities` (`name`) VALUES ("Sanca");
INSERT INTO `cities` (`name`) VALUES ("Sandon");
INSERT INTO `cities` (`name`) VALUES ("Sandspit");
INSERT INTO `cities` (`name`) VALUES ("Sandwick");
INSERT INTO `cities` (`name`) VALUES ("Sandy Cove");
INSERT INTO `cities` (`name`) VALUES ("Sapperton");
INSERT INTO `cities` (`name`) VALUES ("Saratoga Beach");
INSERT INTO `cities` (`name`) VALUES ("Sardis");
INSERT INTO `cities` (`name`) VALUES ("Sarita");
INSERT INTO `cities` (`name`) VALUES ("Saseenos");
INSERT INTO `cities` (`name`) VALUES ("Saturna");
INSERT INTO `cities` (`name`) VALUES ("Savona");
INSERT INTO `cities` (`name`) VALUES ("Savory");
INSERT INTO `cities` (`name`) VALUES ("Sayward");
INSERT INTO `cities` (`name`) VALUES ("Scotch Creek");
INSERT INTO `cities` (`name`) VALUES ("Scotia Bay");
INSERT INTO `cities` (`name`) VALUES ("Scott Cove");
INSERT INTO `cities` (`name`) VALUES ("Seafair");
INSERT INTO `cities` (`name`) VALUES ("Seaford");
INSERT INTO `cities` (`name`) VALUES ("Seaside Park");
INSERT INTO `cities` (`name`) VALUES ("Sechelt");
INSERT INTO `cities` (`name`) VALUES ("Secret Cove");
INSERT INTO `cities` (`name`) VALUES ("Seddall");
INSERT INTO `cities` (`name`) VALUES ("Seeney");
INSERT INTO `cities` (`name`) VALUES ("Selma Park");
INSERT INTO `cities` (`name`) VALUES ("Semlin");
INSERT INTO `cities` (`name`) VALUES ("Sentinel Hill");
INSERT INTO `cities` (`name`) VALUES ("Septimus");
INSERT INTO `cities` (`name`) VALUES ("Seton");
INSERT INTO `cities` (`name`) VALUES ("Seton Portage");
INSERT INTO `cities` (`name`) VALUES ("Seven Mile Corner");
INSERT INTO `cities` (`name`) VALUES ("Sevenoaks");
INSERT INTO `cities` (`name`) VALUES ("Sewall");
INSERT INTO `cities` (`name`) VALUES ("Sewell Inlet");
INSERT INTO `cities` (`name`) VALUES ("Seymour Arm");
INSERT INTO `cities` (`name`) VALUES ("Seymour Heights");
INSERT INTO `cities` (`name`) VALUES ("Seymour Lake");
INSERT INTO `cities` (`name`) VALUES ("Seymour Landing");
INSERT INTO `cities` (`name`) VALUES ("Sha:wiis");
INSERT INTO `cities` (`name`) VALUES ("Shady Valley");
INSERT INTO `cities` (`name`) VALUES ("Shalalth");
INSERT INTO `cities` (`name`) VALUES ("Shames");
INSERT INTO `cities` (`name`) VALUES ("Shannon");
INSERT INTO `cities` (`name`) VALUES ("Shannon Bay");
INSERT INTO `cities` (`name`) VALUES ("Shaughnessy");
INSERT INTO `cities` (`name`) VALUES ("Shawl Bay");
INSERT INTO `cities` (`name`) VALUES ("Shawnigan");
INSERT INTO `cities` (`name`) VALUES ("Shawnigan Lake");
INSERT INTO `cities` (`name`) VALUES ("Shearer Dale");
INSERT INTO `cities` (`name`) VALUES ("Shearwater");
INSERT INTO `cities` (`name`) VALUES ("Shelley");
INSERT INTO `cities` (`name`) VALUES ("Shelter Bay");
INSERT INTO `cities` (`name`) VALUES ("Shelter Point");
INSERT INTO `cities` (`name`) VALUES ("Sheraton");
INSERT INTO `cities` (`name`) VALUES ("Shere");
INSERT INTO `cities` (`name`) VALUES ("Sheridan Lake");
INSERT INTO `cities` (`name`) VALUES ("Sheslay");
INSERT INTO `cities` (`name`) VALUES ("Shingle Creek");
INSERT INTO `cities` (`name`) VALUES ("Shirley");
INSERT INTO `cities` (`name`) VALUES ("Shitlthmaq-is");
INSERT INTO `cities` (`name`) VALUES ("Shops");
INSERT INTO `cities` (`name`) VALUES ("Shoreacres");
INSERT INTO `cities` (`name`) VALUES ("Shoreholme");
INSERT INTO `cities` (`name`) VALUES ("Shulus");
INSERT INTO `cities` (`name`) VALUES ("Shushartie");
INSERT INTO `cities` (`name`) VALUES ("Shuswap");
INSERT INTO `cities` (`name`) VALUES ("Shuswap Falls");
INSERT INTO `cities` (`name`) VALUES ("Shutty Bench");
INSERT INTO `cities` (`name`) VALUES ("Sicamous");
INSERT INTO `cities` (`name`) VALUES ("Sidney");
INSERT INTO `cities` (`name`) VALUES ("Sikanni");
INSERT INTO `cities` (`name`) VALUES ("Sikanni Chief");
INSERT INTO `cities` (`name`) VALUES ("Silica");
INSERT INTO `cities` (`name`) VALUES ("Silver Creek");
INSERT INTO `cities` (`name`) VALUES ("Silver Lake");
INSERT INTO `cities` (`name`) VALUES ("Silver River");
INSERT INTO `cities` (`name`) VALUES ("Silver Star");
INSERT INTO `cities` (`name`) VALUES ("Silver Valley");
INSERT INTO `cities` (`name`) VALUES ("Silverdale");
INSERT INTO `cities` (`name`) VALUES ("Silverhill");
INSERT INTO `cities` (`name`) VALUES ("Silverton");
INSERT INTO `cities` (`name`) VALUES ("Simoom Sound");
INSERT INTO `cities` (`name`) VALUES ("Simpson Ranch");
INSERT INTO `cities` (`name`) VALUES ("Sinclair Mills");
INSERT INTO `cities` (`name`) VALUES ("Sinkut River");
INSERT INTO `cities` (`name`) VALUES ("Sirdar");
INSERT INTO `cities` (`name`) VALUES ("Six Mile Point");
INSERT INTO `cities` (`name`) VALUES ("Six Mile Ranch");
INSERT INTO `cities` (`name`) VALUES ("Skedans");
INSERT INTO `cities` (`name`) VALUES ("Skeena");
INSERT INTO `cities` (`name`) VALUES ("Skeena Crossing");
INSERT INTO `cities` (`name`) VALUES ("Skidegate");
INSERT INTO `cities` (`name`) VALUES ("Skidegate Landing");
INSERT INTO `cities` (`name`) VALUES ("Skooks Landing");
INSERT INTO `cities` (`name`) VALUES ("Skookumchuck");
INSERT INTO `cities` (`name`) VALUES ("Skoonka");
INSERT INTO `cities` (`name`) VALUES ("Slesse Park");
INSERT INTO `cities` (`name`) VALUES ("Slocan");
INSERT INTO `cities` (`name`) VALUES ("Slocan City");
INSERT INTO `cities` (`name`) VALUES ("Slocan Park");
INSERT INTO `cities` (`name`) VALUES ("Smith River");
INSERT INTO `cities` (`name`) VALUES ("Smithers");
INSERT INTO `cities` (`name`) VALUES ("Smithers Landing");
INSERT INTO `cities` (`name`) VALUES ("Snake River");
INSERT INTO `cities` (`name`) VALUES ("Snug Cove");
INSERT INTO `cities` (`name`) VALUES ("Snyder");
INSERT INTO `cities` (`name`) VALUES ("Sockeye");
INSERT INTO `cities` (`name`) VALUES ("Soda Creek");
INSERT INTO `cities` (`name`) VALUES ("Sointula");
INSERT INTO `cities` (`name`) VALUES ("Solsqua");
INSERT INTO `cities` (`name`) VALUES ("Somenos");
INSERT INTO `cities` (`name`) VALUES ("Sooke");
INSERT INTO `cities` (`name`) VALUES ("Sorrento");
INSERT INTO `cities` (`name`) VALUES ("South Bentinck");
INSERT INTO `cities` (`name`) VALUES ("South Cambie");
INSERT INTO `cities` (`name`) VALUES ("South Canoe");
INSERT INTO `cities` (`name`) VALUES ("South Dawson");
INSERT INTO `cities` (`name`) VALUES ("South Fort George");
INSERT INTO `cities` (`name`) VALUES ("South Hazelton");
INSERT INTO `cities` (`name`) VALUES ("South Lakeside");
INSERT INTO `cities` (`name`) VALUES ("South Poplar");
INSERT INTO `cities` (`name`) VALUES ("South Shalalth");
INSERT INTO `cities` (`name`) VALUES ("South Slocan");
INSERT INTO `cities` (`name`) VALUES ("South Slope");
INSERT INTO `cities` (`name`) VALUES ("South Sumas");
INSERT INTO `cities` (`name`) VALUES ("South Surrey");
INSERT INTO `cities` (`name`) VALUES ("South Taylor");
INSERT INTO `cities` (`name`) VALUES ("South Wellington");
INSERT INTO `cities` (`name`) VALUES ("Southarm");
INSERT INTO `cities` (`name`) VALUES ("Southbank");
INSERT INTO `cities` (`name`) VALUES ("Spallumcheen");
INSERT INTO `cities` (`name`) VALUES ("Sparwood");
INSERT INTO `cities` (`name`) VALUES ("Spatsum");
INSERT INTO `cities` (`name`) VALUES ("Spences Bridge");
INSERT INTO `cities` (`name`) VALUES ("Sperling");
INSERT INTO `cities` (`name`) VALUES ("Spicer");
INSERT INTO `cities` (`name`) VALUES ("Spillimacheen");
INSERT INTO `cities` (`name`) VALUES ("Springfield Ranch");
INSERT INTO `cities` (`name`) VALUES ("Springhouse");
INSERT INTO `cities` (`name`) VALUES ("Sproat Lake");
INSERT INTO `cities` (`name`) VALUES ("Sproatt");
INSERT INTO `cities` (`name`) VALUES ("Spuzzum");
INSERT INTO `cities` (`name`) VALUES ("Squamish");
INSERT INTO `cities` (`name`) VALUES ("Squeah");
INSERT INTO `cities` (`name`) VALUES ("Squilax");
INSERT INTO `cities` (`name`) VALUES ("Squirrel Cove");
INSERT INTO `cities` (`name`) VALUES ("St. Eugene Mission");
INSERT INTO `cities` (`name`) VALUES ("St. Ives");
INSERT INTO `cities` (`name`) VALUES ("St. Joseph Mission");
INSERT INTO `cities` (`name`) VALUES ("Stanley");
INSERT INTO `cities` (`name`) VALUES ("Starks");
INSERT INTO `cities` (`name`) VALUES ("Stave Falls");
INSERT INTO `cities` (`name`) VALUES ("Steamboat");
INSERT INTO `cities` (`name`) VALUES ("Steelhead");
INSERT INTO `cities` (`name`) VALUES ("Stellako");
INSERT INTO `cities` (`name`) VALUES ("Stephen");
INSERT INTO `cities` (`name`) VALUES ("Steveston");
INSERT INTO `cities` (`name`) VALUES ("Stewardson Inlet");
INSERT INTO `cities` (`name`) VALUES ("Stewart");
INSERT INTO `cities` (`name`) VALUES ("Stikine");
INSERT INTO `cities` (`name`) VALUES ("Still Creek");
INSERT INTO `cities` (`name`) VALUES ("Stillwater");
INSERT INTO `cities` (`name`) VALUES ("Stockett");
INSERT INTO `cities` (`name`) VALUES ("Stoner");
INSERT INTO `cities` (`name`) VALUES ("Stoney Creek");
INSERT INTO `cities` (`name`) VALUES ("Stories Beach");
INSERT INTO `cities` (`name`) VALUES ("Stout");
INSERT INTO `cities` (`name`) VALUES ("Strachan Creek");
INSERT INTO `cities` (`name`) VALUES ("Straiton");
INSERT INTO `cities` (`name`) VALUES ("Strathcona");
INSERT INTO `cities` (`name`) VALUES ("Strathcona Lodge");
INSERT INTO `cities` (`name`) VALUES ("Strathnaver");
INSERT INTO `cities` (`name`) VALUES ("Strawberry Hill");
INSERT INTO `cities` (`name`) VALUES ("Strawberry Vale");
INSERT INTO `cities` (`name`) VALUES ("Streatham");
INSERT INTO `cities` (`name`) VALUES ("Stuart Island");
INSERT INTO `cities` (`name`) VALUES ("Stuie");
INSERT INTO `cities` (`name`) VALUES ("Stump Lake");
INSERT INTO `cities` (`name`) VALUES ("Sturdies Bay");
INSERT INTO `cities` (`name`) VALUES ("Sugarcane");
INSERT INTO `cities` (`name`) VALUES ("Sullivan");
INSERT INTO `cities` (`name`) VALUES ("Sullivan Bay");
INSERT INTO `cities` (`name`) VALUES ("Sullivan Heights");
INSERT INTO `cities` (`name`) VALUES ("Summerland");
INSERT INTO `cities` (`name`) VALUES ("Summit Lake");
INSERT INTO `cities` (`name`) VALUES ("Sun Peaks");
INSERT INTO `cities` (`name`) VALUES ("Sun Valley");
INSERT INTO `cities` (`name`) VALUES ("Sunbury");
INSERT INTO `cities` (`name`) VALUES ("Suncrest");
INSERT INTO `cities` (`name`) VALUES ("Sundance");
INSERT INTO `cities` (`name`) VALUES ("Sunningdale");
INSERT INTO `cities` (`name`) VALUES ("Sunnybrae");
INSERT INTO `cities` (`name`) VALUES ("Sunnyside");
INSERT INTO `cities` (`name`) VALUES ("Sunrise Valley");
INSERT INTO `cities` (`name`) VALUES ("Sunset");
INSERT INTO `cities` (`name`) VALUES ("Sunset Beach");
INSERT INTO `cities` (`name`) VALUES ("Sunset Prairie");
INSERT INTO `cities` (`name`) VALUES ("Sunshine");
INSERT INTO `cities` (`name`) VALUES ("Sunshine Bay");
INSERT INTO `cities` (`name`) VALUES ("Sunshine Hills");
INSERT INTO `cities` (`name`) VALUES ("Sunshine Valley");
INSERT INTO `cities` (`name`) VALUES ("Suquash");
INSERT INTO `cities` (`name`) VALUES ("Surge Narrows");
INSERT INTO `cities` (`name`) VALUES ("Surprise");
INSERT INTO `cities` (`name`) VALUES ("Surrey");
INSERT INTO `cities` (`name`) VALUES ("Surrey Centre");
INSERT INTO `cities` (`name`) VALUES ("Swansea");
INSERT INTO `cities` (`name`) VALUES ("Swartz Bay");
INSERT INTO `cities` (`name`) VALUES ("Sweetsbridge");
INSERT INTO `cities` (`name`) VALUES ("Sweetwater");
INSERT INTO `cities` (`name`) VALUES ("Swift");
INSERT INTO `cities` (`name`) VALUES ("Swiftwater");
INSERT INTO `cities` (`name`) VALUES ("Ta Ta Creek");
INSERT INTO `cities` (`name`) VALUES ("Ta:shiis");
INSERT INTO `cities` (`name`) VALUES ("Tabor");
INSERT INTO `cities` (`name`) VALUES ("Tacheeda");
INSERT INTO `cities` (`name`) VALUES ("Tachie");
INSERT INTO `cities` (`name`) VALUES ("Tadanac");
INSERT INTO `cities` (`name`) VALUES ("Taft");
INSERT INTO `cities` (`name`) VALUES ("Taghum");
INSERT INTO `cities` (`name`) VALUES ("Tahltan");
INSERT INTO `cities` (`name`) VALUES ("Tahsis");
INSERT INTO `cities` (`name`) VALUES ("Takla Landing");
INSERT INTO `cities` (`name`) VALUES ("Taku");
INSERT INTO `cities` (`name`) VALUES ("Takysie Lake");
INSERT INTO `cities` (`name`) VALUES ("Tallheo");
INSERT INTO `cities` (`name`) VALUES ("Tamarack");
INSERT INTO `cities` (`name`) VALUES ("Tamarisk");
INSERT INTO `cities` (`name`) VALUES ("Tanu");
INSERT INTO `cities` (`name`) VALUES ("Tappen");
INSERT INTO `cities` (`name`) VALUES ("Tarrys");
INSERT INTO `cities` (`name`) VALUES ("Tasu");
INSERT INTO `cities` (`name`) VALUES ("Tatalrose");
INSERT INTO `cities` (`name`) VALUES ("Tatla Lake");
INSERT INTO `cities` (`name`) VALUES ("Tatlayoko Lake");
INSERT INTO `cities` (`name`) VALUES ("Tatlow");
INSERT INTO `cities` (`name`) VALUES ("Tatogga");
INSERT INTO `cities` (`name`) VALUES ("Tatton");
INSERT INTO `cities` (`name`) VALUES ("Taverna");
INSERT INTO `cities` (`name`) VALUES ("Taylor");
INSERT INTO `cities` (`name`) VALUES ("Tchesinkut Lake");
INSERT INTO `cities` (`name`) VALUES ("Teakerne Arm");
INSERT INTO `cities` (`name`) VALUES ("Teeshohsum");
INSERT INTO `cities` (`name`) VALUES ("Teko");
INSERT INTO `cities` (`name`) VALUES ("Telachick");
INSERT INTO `cities` (`name`) VALUES ("Telegraph Cove");
INSERT INTO `cities` (`name`) VALUES ("Telegraph Creek");
INSERT INTO `cities` (`name`) VALUES ("Telkwa");
INSERT INTO `cities` (`name`) VALUES ("Ten Mile Lake");
INSERT INTO `cities` (`name`) VALUES ("Terrace");
INSERT INTO `cities` (`name`) VALUES ("Tetachuk");
INSERT INTO `cities` (`name`) VALUES ("Theodosia Arm");
INSERT INTO `cities` (`name`) VALUES ("Thetis Island");
INSERT INTO `cities` (`name`) VALUES ("Thompson");
INSERT INTO `cities` (`name`) VALUES ("Thompson Sound");
INSERT INTO `cities` (`name`) VALUES ("Thornhill");
INSERT INTO `cities` (`name`) VALUES ("Thornton Yard");
INSERT INTO `cities` (`name`) VALUES ("Three Forks");
INSERT INTO `cities` (`name`) VALUES ("Three Valley");
INSERT INTO `cities` (`name`) VALUES ("Thrums");
INSERT INTO `cities` (`name`) VALUES ("Thunder River");
INSERT INTO `cities` (`name`) VALUES ("Thunderbird");
INSERT INTO `cities` (`name`) VALUES ("Thurlow");
INSERT INTO `cities` (`name`) VALUES ("Thurston Harbour");
INSERT INTO `cities` (`name`) VALUES ("Thwaytes");
INSERT INTO `cities` (`name`) VALUES ("Tibbets");
INSERT INTO `cities` (`name`) VALUES ("Tiili Landing");
INSERT INTO `cities` (`name`) VALUES ("Tilbury");
INSERT INTO `cities` (`name`) VALUES ("Tillicum");
INSERT INTO `cities` (`name`) VALUES ("Tintagel");
INSERT INTO `cities` (`name`) VALUES ("Tipella");
INSERT INTO `cities` (`name`) VALUES ("Tisdall");
INSERT INTO `cities` (`name`) VALUES ("Tl'aaniiwa'a");
INSERT INTO `cities` (`name`) VALUES ("Tl'esqox");
INSERT INTO `cities` (`name`) VALUES ("Tl'etinqox");
INSERT INTO `cities` (`name`) VALUES ("Tl'isnachis");
INSERT INTO `cities` (`name`) VALUES ("Tl'itsnit");
INSERT INTO `cities` (`name`) VALUES ("Tlakmaqis");
INSERT INTO `cities` (`name`) VALUES ("Tlell");
INSERT INTO `cities` (`name`) VALUES ("Tloohat-a");
INSERT INTO `cities` (`name`) VALUES ("Toad River");
INSERT INTO `cities` (`name`) VALUES ("Tobiano");
INSERT INTO `cities` (`name`) VALUES ("Toby Creek");
INSERT INTO `cities` (`name`) VALUES ("Tochty");
INSERT INTO `cities` (`name`) VALUES ("Tofino");
INSERT INTO `cities` (`name`) VALUES ("Tohkwonon");
INSERT INTO `cities` (`name`) VALUES ("Toketic");
INSERT INTO `cities` (`name`) VALUES ("Tomslake");
INSERT INTO `cities` (`name`) VALUES ("Topley");
INSERT INTO `cities` (`name`) VALUES ("Topley Landing");
INSERT INTO `cities` (`name`) VALUES ("Torrent");
INSERT INTO `cities` (`name`) VALUES ("Towdystan");
INSERT INTO `cities` (`name`) VALUES ("Tower Lake");
INSERT INTO `cities` (`name`) VALUES ("Townsend");
INSERT INTO `cities` (`name`) VALUES ("Traders Cove");
INSERT INTO `cities` (`name`) VALUES ("Trafalgar");
INSERT INTO `cities` (`name`) VALUES ("Trail");
INSERT INTO `cities` (`name`) VALUES ("Tranquille");
INSERT INTO `cities` (`name`) VALUES ("Tremblay");
INSERT INTO `cities` (`name`) VALUES ("Trembleur");
INSERT INTO `cities` (`name`) VALUES ("Trinity Valley");
INSERT INTO `cities` (`name`) VALUES ("Troup");
INSERT INTO `cities` (`name`) VALUES ("Trout Creek");
INSERT INTO `cities` (`name`) VALUES ("Trout Lake");
INSERT INTO `cities` (`name`) VALUES ("Trutch");
INSERT INTO `cities` (`name`) VALUES ("Trépanier");
INSERT INTO `cities` (`name`) VALUES ("Ts'axq'oo-is");
INSERT INTO `cities` (`name`) VALUES ("Ts'iispoo-a");
INSERT INTO `cities` (`name`) VALUES ("Tsawwassen");
INSERT INTO `cities` (`name`) VALUES ("Tsawwassen Beach");
INSERT INTO `cities` (`name`) VALUES ("Tsay Keh Dene");
INSERT INTO `cities` (`name`) VALUES ("Tŝideldel");
INSERT INTO `cities` (`name`) VALUES ("Tucks");
INSERT INTO `cities` (`name`) VALUES ("Tulameen");
INSERT INTO `cities` (`name`) VALUES ("Tulsequah");
INSERT INTO `cities` (`name`) VALUES ("Tumbler Ridge");
INSERT INTO `cities` (`name`) VALUES ("Tupper");
INSERT INTO `cities` (`name`) VALUES ("Turtle Valley");
INSERT INTO `cities` (`name`) VALUES ("Tuwanek");
INSERT INTO `cities` (`name`) VALUES ("Tuxwnech");
INSERT INTO `cities` (`name`) VALUES ("Twidwell Bend");
INSERT INTO `cities` (`name`) VALUES ("Twin Butte");
INSERT INTO `cities` (`name`) VALUES ("Twin Creeks");
INSERT INTO `cities` (`name`) VALUES ("Twin Islands");
INSERT INTO `cities` (`name`) VALUES ("Two Mile");
INSERT INTO `cities` (`name`) VALUES ("Two Rivers");
INSERT INTO `cities` (`name`) VALUES ("Tye");
INSERT INTO `cities` (`name`) VALUES ("Tyee");
INSERT INTO `cities` (`name`) VALUES ("Tynehead");
INSERT INTO `cities` (`name`) VALUES ("Tzouhalem");
INSERT INTO `cities` (`name`) VALUES ("Tête Jaune");
INSERT INTO `cities` (`name`) VALUES ("Tête Jaune Cache");
INSERT INTO `cities` (`name`) VALUES ("Ucluelet");
INSERT INTO `cities` (`name`) VALUES ("Ulkatcho");
INSERT INTO `cities` (`name`) VALUES ("Union Bay");
INSERT INTO `cities` (`name`) VALUES ("University Hill");
INSERT INTO `cities` (`name`) VALUES ("Upper China Creek");
INSERT INTO `cities` (`name`) VALUES ("Upper Cutbank");
INSERT INTO `cities` (`name`) VALUES ("Upper Fraser");
INSERT INTO `cities` (`name`) VALUES ("Upper Halfway");
INSERT INTO `cities` (`name`) VALUES ("Upper Lynn");
INSERT INTO `cities` (`name`) VALUES ("Upsowis");
INSERT INTO `cities` (`name`) VALUES ("Urling");
INSERT INTO `cities` (`name`) VALUES ("Urquhart");
INSERT INTO `cities` (`name`) VALUES ("Usk");
INSERT INTO `cities` (`name`) VALUES ("Uuts");
INSERT INTO `cities` (`name`) VALUES ("Valemount");
INSERT INTO `cities` (`name`) VALUES ("Valley View");
INSERT INTO `cities` (`name`) VALUES ("Valleycliffe");
INSERT INTO `cities` (`name`) VALUES ("Valleyview");
INSERT INTO `cities` (`name`) VALUES ("Vallican");
INSERT INTO `cities` (`name`) VALUES ("Van Anda");
INSERT INTO `cities` (`name`) VALUES ("Vancouver");
INSERT INTO `cities` (`name`) VALUES ("Vanderhoof");
INSERT INTO `cities` (`name`) VALUES ("Vanway");
INSERT INTO `cities` (`name`) VALUES ("Vaucroft Beach");
INSERT INTO `cities` (`name`) VALUES ("Vavenby");
INSERT INTO `cities` (`name`) VALUES ("Vedder Crossing");
INSERT INTO `cities` (`name`) VALUES ("Vermilion Crossing");
INSERT INTO `cities` (`name`) VALUES ("Vernon");
INSERT INTO `cities` (`name`) VALUES ("Vesuvius");
INSERT INTO `cities` (`name`) VALUES ("Victoria");
INSERT INTO `cities` (`name`) VALUES ("Victoria-Fraserview");
INSERT INTO `cities` (`name`) VALUES ("Vidette");
INSERT INTO `cities` (`name`) VALUES ("View Royal");
INSERT INTO `cities` (`name`) VALUES ("Village Bay");
INSERT INTO `cities` (`name`) VALUES ("Vinsulla");
INSERT INTO `cities` (`name`) VALUES ("Von Zuben");
INSERT INTO `cities` (`name`) VALUES ("Vye");
INSERT INTO `cities` (`name`) VALUES ("W'aayi");
INSERT INTO `cities` (`name`) VALUES ("Wabi");
INSERT INTO `cities` (`name`) VALUES ("Wabron");
INSERT INTO `cities` (`name`) VALUES ("Wadhams");
INSERT INTO `cities` (`name`) VALUES ("Waglisla");
INSERT INTO `cities` (`name`) VALUES ("Wagner Ranch");
INSERT INTO `cities` (`name`) VALUES ("Wakely");
INSERT INTO `cities` (`name`) VALUES ("Walhachin");
INSERT INTO `cities` (`name`) VALUES ("Walker");
INSERT INTO `cities` (`name`) VALUES ("Walkers");
INSERT INTO `cities` (`name`) VALUES ("Walnut Grove");
INSERT INTO `cities` (`name`) VALUES ("Waneta");
INSERT INTO `cities` (`name`) VALUES ("Waneta Junction");
INSERT INTO `cities` (`name`) VALUES ("Wanklyn");
INSERT INTO `cities` (`name`) VALUES ("Wardner");
INSERT INTO `cities` (`name`) VALUES ("Ware");
INSERT INTO `cities` (`name`) VALUES ("Warfield");
INSERT INTO `cities` (`name`) VALUES ("Warner Bay");
INSERT INTO `cities` (`name`) VALUES ("Wasa");
INSERT INTO `cities` (`name`) VALUES ("Watson");
INSERT INTO `cities` (`name`) VALUES ("Watson Island");
INSERT INTO `cities` (`name`) VALUES ("Websters Corners");
INSERT INTO `cities` (`name`) VALUES ("Wedeene");
INSERT INTO `cities` (`name`) VALUES ("Wedge");
INSERT INTO `cities` (`name`) VALUES ("Wedgwood");
INSERT INTO `cities` (`name`) VALUES ("Weewanie");
INSERT INTO `cities` (`name`) VALUES ("Welcome Beach");
INSERT INTO `cities` (`name`) VALUES ("Wellington");
INSERT INTO `cities` (`name`) VALUES ("Wells");
INSERT INTO `cities` (`name`) VALUES ("Weneez");
INSERT INTO `cities` (`name`) VALUES ("West Bay");
INSERT INTO `cities` (`name`) VALUES ("West Bench");
INSERT INTO `cities` (`name`) VALUES ("West End");
INSERT INTO `cities` (`name`) VALUES ("West Heights");
INSERT INTO `cities` (`name`) VALUES ("West Kelowna, City of");
INSERT INTO `cities` (`name`) VALUES ("West Landing");
INSERT INTO `cities` (`name`) VALUES ("West Lynn");
INSERT INTO `cities` (`name`) VALUES ("West Midway");
INSERT INTO `cities` (`name`) VALUES ("West Point Grey");
INSERT INTO `cities` (`name`) VALUES ("West Trail");
INSERT INTO `cities` (`name`) VALUES ("West Vancouver");
INSERT INTO `cities` (`name`) VALUES ("Westbank");
INSERT INTO `cities` (`name`) VALUES ("Westbridge");
INSERT INTO `cities` (`name`) VALUES ("Westholme");
INSERT INTO `cities` (`name`) VALUES ("Westley");
INSERT INTO `cities` (`name`) VALUES ("Westmount");
INSERT INTO `cities` (`name`) VALUES ("Westply");
INSERT INTO `cities` (`name`) VALUES ("Westridge");
INSERT INTO `cities` (`name`) VALUES ("Westside");
INSERT INTO `cities` (`name`) VALUES ("Westsyde");
INSERT INTO `cities` (`name`) VALUES ("Westview");
INSERT INTO `cities` (`name`) VALUES ("Westwold");
INSERT INTO `cities` (`name`) VALUES ("Wet'suwet'en Village");
INSERT INTO `cities` (`name`) VALUES ("Whaletown");
INSERT INTO `cities` (`name`) VALUES ("Whalley");
INSERT INTO `cities` (`name`) VALUES ("Whisky Creek");
INSERT INTO `cities` (`name`) VALUES ("Whistler");
INSERT INTO `cities` (`name`) VALUES ("Whistler Creek");
INSERT INTO `cities` (`name`) VALUES ("White Lake");
INSERT INTO `cities` (`name`) VALUES ("White Pass");
INSERT INTO `cities` (`name`) VALUES ("White Rock");
INSERT INTO `cities` (`name`) VALUES ("Whonnock");
INSERT INTO `cities` (`name`) VALUES ("Whyac");
INSERT INTO `cities` (`name`) VALUES ("Whytecliff");
INSERT INTO `cities` (`name`) VALUES ("Wigwam Inn");
INSERT INTO `cities` (`name`) VALUES ("Wihat'a");
INSERT INTO `cities` (`name`) VALUES ("Wii Lax K'ap");
INSERT INTO `cities` (`name`) VALUES ("Wildwood");
INSERT INTO `cities` (`name`) VALUES ("Wiley");
INSERT INTO `cities` (`name`) VALUES ("Williams Beach");
INSERT INTO `cities` (`name`) VALUES ("Williams Lake");
INSERT INTO `cities` (`name`) VALUES ("Williams Landing");
INSERT INTO `cities` (`name`) VALUES ("Williamsons Landing");
INSERT INTO `cities` (`name`) VALUES ("Willingdon Heights");
INSERT INTO `cities` (`name`) VALUES ("Willow Point");
INSERT INTO `cities` (`name`) VALUES ("Willow River");
INSERT INTO `cities` (`name`) VALUES ("Willow Valley");
INSERT INTO `cities` (`name`) VALUES ("Willowbrook");
INSERT INTO `cities` (`name`) VALUES ("Willowvale");
INSERT INTO `cities` (`name`) VALUES ("Wilmer");
INSERT INTO `cities` (`name`) VALUES ("Wilson Creek");
INSERT INTO `cities` (`name`) VALUES ("Wilson Landing");
INSERT INTO `cities` (`name`) VALUES ("Windermere");
INSERT INTO `cities` (`name`) VALUES ("Windsor Park");
INSERT INTO `cities` (`name`) VALUES ("Windy");
INSERT INTO `cities` (`name`) VALUES ("Winfield");
INSERT INTO `cities` (`name`) VALUES ("Wingdam");
INSERT INTO `cities` (`name`) VALUES ("Winlaw");
INSERT INTO `cities` (`name`) VALUES ("Winter Harbour");
INSERT INTO `cities` (`name`) VALUES ("Wistaria");
INSERT INTO `cities` (`name`) VALUES ("Wolfenden");
INSERT INTO `cities` (`name`) VALUES ("Wolverine");
INSERT INTO `cities` (`name`) VALUES ("Wonowon");
INSERT INTO `cities` (`name`) VALUES ("Woodcock");
INSERT INTO `cities` (`name`) VALUES ("Woodfibre");
INSERT INTO `cities` (`name`) VALUES ("Woodhaven");
INSERT INTO `cities` (`name`) VALUES ("Woodlands");
INSERT INTO `cities` (`name`) VALUES ("Woodmere");
INSERT INTO `cities` (`name`) VALUES ("Woodpecker");
INSERT INTO `cities` (`name`) VALUES ("Woods Landing");
INSERT INTO `cities` (`name`) VALUES ("Woodsdale");
INSERT INTO `cities` (`name`) VALUES ("Woodwards Landing");
INSERT INTO `cities` (`name`) VALUES ("Worth");
INSERT INTO `cities` (`name`) VALUES ("Woss");
INSERT INTO `cities` (`name`) VALUES ("Wright");
INSERT INTO `cities` (`name`) VALUES ("Wycliffe");
INSERT INTO `cities` (`name`) VALUES ("Wyman");
INSERT INTO `cities` (`name`) VALUES ("Wynndel");
INSERT INTO `cities` (`name`) VALUES ("Xeni");
INSERT INTO `cities` (`name`) VALUES ("Ya:kats");
INSERT INTO `cities` (`name`) VALUES ("Yaashitquo-a");
INSERT INTO `cities` (`name`) VALUES ("Yaculta");
INSERT INTO `cities` (`name`) VALUES ("Yahk");
INSERT INTO `cities` (`name`) VALUES ("Yaku");
INSERT INTO `cities` (`name`) VALUES ("Yale");
INSERT INTO `cities` (`name`) VALUES ("Yankee Flats");
INSERT INTO `cities` (`name`) VALUES ("Yarksis");
INSERT INTO `cities` (`name`) VALUES ("Yarrow");
INSERT INTO `cities` (`name`) VALUES ("Yekooche");
INSERT INTO `cities` (`name`) VALUES ("Yellowhead");
INSERT INTO `cities` (`name`) VALUES ("Yennadon");
INSERT INTO `cities` (`name`) VALUES ("Ymir");
INSERT INTO `cities` (`name`) VALUES ("Yoho");
INSERT INTO `cities` (`name`) VALUES ("Youbou");
INSERT INTO `cities` (`name`) VALUES ("Yreka");
INSERT INTO `cities` (`name`) VALUES ("Yuneŝit'in");
INSERT INTO `cities` (`name`) VALUES ("Yuquot");
INSERT INTO `cities` (`name`) VALUES ("Yuuhluth");
INSERT INTO `cities` (`name`) VALUES ("Zamora");
INSERT INTO `cities` (`name`) VALUES ("Zeballos");
INSERT INTO `cities` (`name`) VALUES ("Zeke");
INSERT INTO `cities` (`name`) VALUES ("Zincton");
INSERT INTO `cities` (`name`) VALUES ("ʔEsdilagh");