# phpMyAdmin MySQL-Dump
# version 2.3.0-rc1
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 03, 2002 at 05:22 PM
# Server version: 3.23.49
# PHP Version: 4.2.1
# Database : `xoopsdb`
# --------------------------------------------------------

#
# Table structure for table `city`
#

CREATE TABLE city (
  accid varchar(5) NOT NULL default '',
  city_title varchar(50) NOT NULL default '',
  subdiv_id int(4) NOT NULL default '0',
  PRIMARY KEY  (accid),
  KEY city_title (city_title)
) TYPE=MyISAM;

#
# Dumping data for table `city`
#

INSERT INTO city (accid, city_title, subdiv_id) VALUES ('CALA', 'Lafayette', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('CAMO', 'Moraga', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('CAOR', 'Orinda', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('CCR', 'Concord', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IL27', 'Monticello', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IL52', 'Taylorville', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ILG', 'Wilmington', 31);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ILM', 'Wilmington', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IMT', 'Iron Mountain', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IN03', 'Bluffton', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IN04', 'Boonville', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IN05', 'Brazil', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IN31', 'Lebanon', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IND', 'Indianapolis', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('INK', 'Wink', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('INL', 'International Falls', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('INT', 'Winston-Salem', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('INW', 'Winslow', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IOW', 'Iowa City', 52);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IPL', 'Imperial', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IPT', 'Williamsport', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IRK', 'Kirkville', 52);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ISN', 'Williston', 91);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ISO', 'Kinston', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ISP', 'Islip', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IST', 'Istanbul', 150);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ISW', 'Island Park', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ITH', 'Ithaca', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ITO', 'Hilo', 49);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('IWD', 'Ironwood', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JAC', 'Jackson', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JAN', 'Jackson', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JAX', 'Jacksonville', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JBK', 'Berkeley', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JBR', 'Jonesboro', 6);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JCT', 'Junction', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JDN', 'Jordan', 89);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JDY', 'Downey', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JEF', 'Jefferson City', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JFK', 'New York/JFK', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JHW', 'Jamestown', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JKL', 'Jackson', 71);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JLN', 'Joplin', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JMS', 'Jamestown', 91);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JNB', 'Johannesburg', 136);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JNU', 'Juneau', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JRS', 'Jerusalem', 62);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JSD', 'Stratford', 25);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JST', 'Johnstown', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JVL', 'Janesville', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('JXN', 'Jackson', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KCK', 'Kansas City', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KCO', 'Keystone', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KHI', 'Karachi', 114);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KIL', 'Killington', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KIN', 'Kingston', 65);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KKW', 'Kirkwood', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KLV', 'Killington', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KOA', 'Kailua', 49);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KTN', 'Ketchikan', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KUL', 'Kuala Lumpur', 77);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('KWI', 'Kuwait', 70);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('L09', 'Death Valley', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('L12', 'Redlands', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('L35', 'Big Bear', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('L66', 'Corona', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('L67', 'Rialto', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('L85', 'Lucerne Valley', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA05', 'Chalmette', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA08', 'Coushatta', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA16', 'Homer', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA18', 'Jonesboro', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA19', 'Lake Providence', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA24', 'New Roads', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA26', 'Opelousas', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA30', 'Rayville', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA31', 'Reserve', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA32', 'Simsboro', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA34', 'St. Francisville', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA35', 'St. Joseph', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LA37', 'Tallulah', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAF', 'Lafayette', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAH', 'Hanover', 98);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAL', 'Lakeland', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAM', 'Los Alamos', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAN', 'Lansing', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAP', 'La Paz', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAR', 'Laramie', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAS', 'Las Vegas', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LAX', 'Los Angeles Coast', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LBB', 'Lubbock', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LBE', 'Latrobe', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LBF', 'North Platte', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LBL', 'Liberal', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LCH', 'Lake Charles', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LCI', 'Laconia', 98);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LCK', 'Rickenbacker AFB', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LEB', 'Lebanon', 98);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LED', 'St. Petersburg', 126);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LEE', 'Leesville', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LEW', 'Lewiston', 82);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LEX', 'Lexington', 71);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LF01', 'Cape Corse', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LF02', 'Cape Sagro', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA0', 'Lons-Le-Saunier Aut', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA1', 'Beg Melen', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA2', 'Le Talut', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA3', 'Vannes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA4', 'Chateau-Chinon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA5', 'Langres', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA6', 'St. Sauveur', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA7', 'Pointe Des Baleines', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA8', 'Chassiron', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFA9', 'Mont St. Vincent', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFAT', 'Le Touquet', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBA', 'Agen', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBC', 'Cazaux Pond', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBD', 'Bordeaux', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBE', 'Bergerac', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBG', 'Cognac', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBH', 'La Rochelle', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBI', 'Poitiers', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBK', 'Montlucon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBL', 'Limoges', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBM', 'Mont-De-Marsan Fafb', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBN', 'Niort', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBO', 'Toulouse', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBP', 'Pont-Long-Uzein', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBS', 'Biscarosse', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBT', 'Tarbes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBV', 'Brive', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBX', 'Perigueux', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBY', 'Dax', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFBZ', 'Biarritz', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC0', 'Cape Cepet', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC1', 'Carpentras', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC2', 'Lus-La-Croix-Haute', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC3', 'Embrun', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC4', 'Briancon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC5', 'Socoa', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC6', 'Sete', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC7', 'Cape Pomegues', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC8', 'Cape Couronne', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFC9', 'Toulon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFCA', 'Cannes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFCG', 'St. Girons', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFCH', 'Chateauroux', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFCI', 'Albi', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFCL', 'Calais', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFCR', 'Rodez', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFCX', 'Chamoix', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFDH', 'Auch', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE0', 'Pertusato', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE1', 'Porquerolles', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE2', 'Cape Camarat', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE3', 'La Garoupe', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE4', 'Les Escaldes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE5', 'St. Leocadie', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE6', 'Cape Bear', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE7', 'La Parata', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE8', 'Ile Rousse', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFE9', 'La Chiappa', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF0', 'Ouessant Island', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF2', 'Dunkerque', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF3', 'Barfleur', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF4', 'La Hague', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF5', 'Vigite du Haumet', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF6', 'Port En Bessin', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF7', 'Carteret', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF8', 'Valognes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFF9', 'Dieppe', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFFS', 'Suippes Range', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFGR', 'Grenoble', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFGX', 'Boulogne', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFHP', 'Le Puy', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFI', 'Langley AFB', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFIG', 'Cassagnes-Begonhes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFJK', 'Ajaccio', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFJL', 'Metz-Nancy-Lorraine', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFK', 'Lufkin', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFKB', 'Bastia', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFKC', 'Calvi', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFKS', 'Solenzara', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLA', 'Auxerre', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLB', 'Chambery', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLC', 'Clermont', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLD', 'Bourges', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLH', 'Le Havre', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLM', 'Macon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLN', 'St. Yan', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLQ', 'Montelimar', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLV', 'Vichy', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLW', 'Aurillac', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLX', 'Lourdes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFLY', 'Lyon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMA', 'Aix Les Milles Fafb', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMC', 'Le Luc', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFME', 'Nimes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMH', 'St. Etienne', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMI', 'Istres', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMK', 'Carcassonne', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFML', 'Marseille', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMM', 'Monte Carlo', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMN', 'Nice', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMO', 'Orange', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMP', 'Perpignan', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMT', 'Montpellier', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMU', 'Beziers', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFMY', 'Salon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN0', 'Mount Aigoual', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN1', 'Morbier', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN2', 'La Coubre', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN3', 'Les Sauvages', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN4', 'Modane Avrieux', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN5', 'Bourg-St. Maurice', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN7', 'Gourdon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFN9', 'Millau', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFNB', 'Mende', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOA', 'Avord', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOB', 'Beauvais', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOC', 'Chateaudun', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOE', 'Evreux', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOF', 'Alencon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOI', 'Abbeville', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOJ', 'Orleans', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOK', 'Chalons', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOP', 'Rouen', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOR', 'Chartres', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOS', 'Vittefleur', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOT', 'Tours', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFOW', 'St. Quentin', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFPC', 'Creil', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFPG', 'Charles De Gaulle', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFPM', 'Melun', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFPN', 'Toussus Le Noble', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFPO', 'Paris', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFPV', 'Villacoublay', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFPW', 'Paris Met Center', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFQB', 'Troyes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFQG', 'Nevers', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFQH', 'Chatillon-Sur-Seine', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFQI', 'Cambrai', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFQQ', 'Lille', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFQV', 'Charleville', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR0', 'Penmarch', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR1', 'Pointe du Raz', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR2', 'Brignogan', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR3', 'Brehat Island', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR4', 'Grouin De Cancale', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR5', 'Pointe du Roc', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR6', 'Laval', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR7', 'Trappes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFR9', 'Epinal', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRA', 'Angers', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRB', 'Brest', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRC', 'Cherbourg', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRD', 'Dinard', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRH', 'Lorient', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRI', 'La Roche', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRJ', 'Landivisiau', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRK', 'Caen', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRL', 'Lanveoc', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRM', 'Le Mans', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRN', 'Rennes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRO', 'Lannion', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRQ', 'Quimper', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRS', 'Nantes', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRT', 'Saint-Brieuc Armor', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRU', 'Morlaix', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFRZ', 'St. Nazaire', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSA', 'Besancon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSB', 'Basel', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSC', 'Colmar', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSD', 'Dijon', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSF', 'Metz', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSI', 'St. Dizier', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSL', 'Toul', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSO', 'Nancy', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSQ', 'Belfort', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSR', 'Reims', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFST', 'Strasbourg', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFSX', 'Luxeuil', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFT', 'Lafayette', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFTH', 'Hyeres', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFTU', 'Frejus', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFVD', 'Val D-Isere', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFVX', 'Val d-Isere', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFXA', 'Amberieu', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFXI', 'Apt', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LFYR', 'Romorantin', 40);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LGA', 'New York City', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LGB', 'Long Beach', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LGU', 'Logan', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LHQ', 'Lancaster', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LHR', 'London', 154);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LHV', 'Lock Haven', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LHX', 'La Junta', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LIC', 'Limon', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LIH', 'Lihue', 49);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LIM', 'Lima', 117);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LIS', 'Lisbon', 120);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LIT', 'Little Rock', 6);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LIZ', 'Limestone/Loring AFB', 82);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LMT', 'Klamath Falls', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LND', 'Lander', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LNK', 'Lincoln', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LNN', 'Willoughby', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LNR', 'Lone Rock', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LNS', 'Lancaster', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LOL', 'Lovelock', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LOS', 'Lagos', 100);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LOZ', 'London', 71);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LPB', 'La Paz', 17);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LPL', 'Liverpool', 154);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LRD', 'Laredo', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LRF', 'Little Rock', 6);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LRU', 'Las Cruces', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LSE', 'La Crosse', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LSV', 'Nellis AFB', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LTA', 'South Lake Tahoe', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LTC', 'South Lake Tahoe', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LTS', 'Altus', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LUN', 'Lusaka', 169);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LVK', 'Livermore', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LVM', 'Livingston', 89);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LVS', 'Las Vegas', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LWM', 'Lawrence', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LWS', 'Lewiston', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LWT', 'Lewistown', 89);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LXV', 'Leadville', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('LYH', 'Lynchburg', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MA01', 'Dedham', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MA11', 'Belmont', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MA14', 'Danvers', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MA18', 'Reading', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MAD', 'Madrid', 137);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MAF', 'Midland', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MAN', 'Manchester', 154);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MAXX', 'Martinez', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MBL', 'Manistee', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MBS', 'Saginaw', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCA', 'Mammoth Mountain', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCB', 'McComb', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCG', 'McGrath', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCI', 'Kansas City', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCK', 'McCook', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCN', 'Macon', 41);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCO', 'Orlando', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MCW', 'Mason City', 52);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MDH', 'Carbondale', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MDT', 'Middletown', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MDW', 'Chicago/Midway', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MEC', 'Mecca', 128);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MEI', 'Meridian', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MEL', 'Melbourne', 158);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MEM', 'Memphis', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MER', 'Merced', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MEX', 'Mexico City', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MFD', 'Mansfield', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MFE', 'McAllen', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MFR', 'Medford', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MGA', 'Managua', 99);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MGE', 'Marietta', 41);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MGL', 'Monteagle', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MGM', 'Montgomery', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MGQ', 'Mogadishu', 135);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MGW', 'Morgantown', 165);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MHE', 'Mitchell', 130);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MHK', 'Manhattan', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MHR', 'Mather Afb', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MHS', 'Mount Shasta', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MHT', 'Manchester', 98);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MI06', 'Brevort', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MIA', 'Miami', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MIC', 'Crystal', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MID', 'Merida', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MIE', 'Muncie', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MIL', 'Milano', 63);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MIV', 'Millville', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MKE', 'Milwaukee', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MKG', 'Muskegon', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MKK', 'Kaunakakai', 49);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MKL', 'Jackson', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MKP', 'McKeesport', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MKT', 'Mankato', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MKV', 'Marksville', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLB', 'Melbourne', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLC', 'McAlester', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLD', 'Malad City', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLF', 'Milford', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLI', 'Moline', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLM', 'Morelia', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLS', 'Miles City', 89);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MLU', 'Monroe', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MMH', 'Mammoth Mountain', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MMI', 'Athens', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MML', 'Marshall', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MMO', 'Marseilles', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MMU', 'Morristown', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MN36', 'Luverne', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MN47', 'Pine City', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MNL', 'Manila', 118);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MNY', 'McNary', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO07', 'Bethany', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO10', 'Bowling Green', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO13', 'California', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO23', 'Doniphan', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO27', 'Fayette', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO35', 'Greenville', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO45', 'Keytesville', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO46', 'Kingston', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MO84', 'Savannah', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MOB', 'Mobile', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MOD', 'Modesto', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MOP', 'Mount Pleasant', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MOT', 'Minot', 91);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MOV', 'Monclova', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MPV', 'Barre-Montpelier', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MQT', 'Marquette', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MRB', 'Martinsburg', 165);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MRF', 'Marfa', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MRY', 'Monterey', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MS31', 'Picayune', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MS36', 'Raleigh', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MSL', 'Muscle Shoals', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MSN', 'Madison', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MSO', 'Missoula', 89);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MSP', 'Minneapolis', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MSS', 'Massena', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MSV', 'Monticello', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MSY', 'New Orleans', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MT02', 'Wolf Point', 89);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MTC', 'Mount Clemens', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MTJ', 'Montrose', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MTP', 'Montauk', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MTQ', 'Ottawa', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MUC', 'Munich', 43);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MUO', 'Mountain Home', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MVD', 'Montevideo', 155);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MVN', 'Mount Vernon', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MVT', 'Mount Snow', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MVY', 'Martha\'s Vineyard', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MWA', 'Marion', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MWI', 'Winona', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MWL', 'Mineral Wells', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MWN', 'Mount Washington', 98);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MWO', 'Middletown', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MWS', 'Mount Wilson', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MXF', 'Maxwell AFB', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MYF', 'Montgomery Field', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MYL', 'McCall', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MYR', 'North Myrtle Beach', 129);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('MZT', 'Mazatlan', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N05', 'Hackensack', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N13', 'Bloomsburg', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N21', 'Princeton', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N35', 'Punxsutawney', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N42', 'Shippensburg', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N66', 'Oneonta', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N80', 'Ocean City', 81);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('N97', 'Clearfield', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NAP', 'Naples', 63);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NAS', 'Nassau', 11);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NBC', 'Beaufort', 129);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NBO', 'Nairobi', 68);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NBU', 'Glenview', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NC10', 'Concord', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NC22', 'Hertford', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NC29', 'Louisburg', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NCA', 'Jacksonville', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NE02', 'Alma', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NEL', 'Lakehurst', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NFG', 'Camp Pendleton', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NFL', 'Fallon', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NGF', 'Kaneohe', 49);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NGZ', 'Alameda', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NHK', 'Patuxent River', 81);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NHZ', 'Brunswick', 82);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NIC', 'Nicosia', 28);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NIR', 'Chase Field', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NJK', 'El Centro', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NKT', 'Cherry Point', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NKX', 'Miramar', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NLC', 'Lemoore', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NM01', 'Ancho', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NM10', 'Sunspot', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NQI', 'Kingsville', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NRB', 'Mayport', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NRI', 'North Richland Hills', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NRS', 'Imperial Beach', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NSE', 'Whiting Field', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NTC', 'Tahoe City', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NTD', 'Point Mugu', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NTK', 'Tustin', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NTU', 'Oceana', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NUQ', 'Mountain View', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NUW', 'Whidbey Island', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NXX', 'Willow Grove', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NY34', 'Bay Shore', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NYC', 'New York - Central Park', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NYG', 'Quantico', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NZA', 'Auckland', 96);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NZC', 'Cecil Field', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NZJ', 'El Toro', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('NZW', 'South Weymouth', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('O43', 'Yerington', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('O57', 'Bridgeport', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('O62', 'Carmel', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OAK', 'Oakland', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OAX', 'Oaxaca', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OCF', 'Ocala', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ODS', 'Odessa', 152);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OFF', 'Omaha (Offutt)', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OFK', 'Norfolk', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OGA', 'Ogallala', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OGD', 'Ogden', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OGG', 'Kahului', 49);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OH08', 'Gallipolis', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OJC', 'Olathe', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK01', 'Ada', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK02', 'Alva', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK03', 'Anadarko', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK04', 'Antlers', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK06', 'Beaver', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK07', 'Buffalo', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK09', 'Cherokee', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK11', 'Chickasha', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK12', 'Claremore', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK14', 'Cordell', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK18', 'El Reno', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK19', 'Eufaula', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK22', 'Holdenville', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK23', 'Hollis', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK24', 'Hugo', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK25', 'Idabel', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK26', 'Kingfisher', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK28', 'Madill', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK31', 'Medford', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK32', 'Miami', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK56', 'Waurika', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK57', 'Wheeless', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OK60', 'Yukon', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OKC', 'Oklahoma City', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OKD', 'Oakdale', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OLE', 'Olean', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OLM', 'Olympia', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OLS', 'Nogales', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OMA', 'Omaha', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OME', 'Nome', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OMK', 'Omak', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ONA', 'Winona', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ONM', 'Socorro', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ONO', 'Ontario', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ONP', 'Newport', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ONT', 'Ontario', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OQU', 'Kingston', 125);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OR03', 'Salahaddin', 60);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OR04', 'Chamchamal', 60);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OR10', 'Rutbah', 60);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ORD', 'Chicago', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ORF', 'Norfolk', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ORH', 'Worcester', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ORT', 'Northway', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OSA', 'Osaka', 66);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OSC', 'Oscoda', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OSH', 'Oshkosh', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OSL', 'Oslo', 105);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OTG', 'Worthington', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OTH', 'North Bend', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OTM', 'Ottumwa', 52);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OTZ', 'Kotzebue', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OUN', 'Norman', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OVN', 'Omaha (North)', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OXR', 'Oxnard', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OYM', 'St. Mary\'s', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('OZR', 'Ozark', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('P04', 'Bisbee', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('P08', 'Coolidge', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('P13', 'Globe', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('P20', 'Parker', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('P32', 'Williams', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('P34', 'Window Rock', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('P52', 'Cottonwood', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PAE', 'Everett', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PAH', 'Paducah', 71);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PAM', 'Panama City', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PAO', 'Palo Alto', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PAP', 'Port au Prince', 48);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PAQ', 'Palmer', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PBF', 'Pine Bluff', 6);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PBG', 'Plattsburgh', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PBI', 'W Palm Beach', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PBM', 'Paramaribo', 140);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PBY', 'Peabody', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PDT', 'Pendleton', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PDX', 'Portland', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PEK', 'Beijing', 22);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PER', 'Perth', 163);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PGA', 'Page', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PGD', 'Punta Gorda', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PHL', 'Philadelphia', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PHN', 'Port Huron', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PHP', 'Philip', 130);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PHR', 'Phantom Ranch', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PHX', 'Phoenix', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PIA', 'Peoria', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PIE', 'St. Petersburg', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PIH', 'Pocatello', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PIR', 'Pierre', 130);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PIT', 'Pittsburgh', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PKB', 'Parkersburg', 165);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PKF', 'Park Falls', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PLHX', 'Pleasant Hill', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PLN', 'Pellston', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PLP', 'Phillipsburg', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PMD', 'Palmdale', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PMH', 'Portsmouth', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PMI', 'Palma De Mallorca', 137);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PMO', 'Palermo', 63);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PMP', 'Pompano Beach', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PNC', 'Ponca City', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PNS', 'Pensacola', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('POE', 'Fort Polk AAF', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('POM', 'Pomona', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('POS', 'Port Of Spain', 148);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('POU', 'Poughkeepsie', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PPF', 'Parsons', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PQI', 'Presque Isle', 82);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PRB', 'Paso Robles', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PRC', 'Prescott', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PRG', 'Prague', 29);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PSB', 'Philipsburg', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PSC', 'Pasco', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PSF', 'Pittsfield', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PSM', 'Portsmouth', 98);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PSP', 'Palm Springs', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PSX', 'Palacios', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PTK', 'Pontiac', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PTS', 'Pittsburg', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PTY', 'Panama', 115);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PUB', 'Pueblo', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PUC', 'Price', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PUT', 'Park City', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PUW', 'Pullman', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PVD', 'Providence', 125);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PVR', 'Puerto Vallar', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PVU', 'Provo', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PWA', 'Wily Post', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PWM', 'Portland', 82);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PWT', 'Bremerton', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('PYM', 'Plymouth', 76);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('Q35', 'Springerville', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('QUE', 'Queens', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RAP', 'Rapid City', 130);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RBG', 'Roseburg', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RBL', 'Red Bluff', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RDD', 'Redding', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RDG', 'Reading', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RDM', 'Redmond', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RDU', 'Raleigh', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('REE', 'Reese/Lubbock', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('REH', 'Rehoboth Beach', 31);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('REK', 'Reykjavik', 53);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RFD', 'Rockford', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RHI', 'Rhinelander', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RIC', 'Richmond', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RID', 'Richmond', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RIE', 'Rice Lake', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RIG', 'Riggins', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RIV', 'Riverside', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RIW', 'Riverton', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RIX', 'Riga', 73);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RKS', 'Rock Springs', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RME', 'Rome', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RMG', 'Rome', 41);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RND', 'Randolph AFB', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RNO', 'Reno', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ROA', 'Roanoke', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ROC', 'Rochester', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ROW', 'Roswell', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RSL', 'Russell', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RST', 'Rochester', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RTN', 'Raton', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RUI', 'Ruidoso', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RUT', 'Rutland', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RWF', 'Redwood Falls', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RWI', 'Rocky Mount', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('RWL', 'Rawlins', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('S07', 'Bend', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('S18', 'Forks', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('S19', 'Friday Harbor', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('S80', 'Grangeville', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAA', 'Saratoga', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAC', 'Sacramento', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAF', 'Santa Fe', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAL', 'San Salvador', 36);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAN', 'San Diego', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAO', 'Sao paulo', 18);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAT', 'San Antonio', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAV', 'Savannah', 41);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SAW', 'Sawyer AFB', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SBA', 'Santa Barbara', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SBD', 'San Bernardino', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SBN', 'South Bend', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SBP', 'San Luis Obispo', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SBS', 'Steamboat Springs', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SBV', 'Barre-Montpelier', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SBY', 'Salisbury', 81);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SCA', 'Tahoe Valley', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SCC', 'Prudhoe Bay', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SCK', 'Stockton', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SCL', 'Santiago', 21);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SCO', 'Steamboat Springs', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SD01', 'Alexandria', 130);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SDF', 'Louisville', 71);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SDL', 'Scottsdale', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SDM', 'Brownfield', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SDQ', 'Santo Domingo', 33);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SDY', 'Sidney', 89);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SEA', 'Seattle', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SEM', 'Selma', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SEP', 'Stephenville', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SEZ', 'Sedona', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SFO', 'San Francisco', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SFS', 'South San Francisco', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SFZ', 'Pawtucket', 125);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SGF', 'Springfield', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SGH', 'Springfield', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SGJ', 'St. Augustine', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SGU', 'St. George', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SGY', 'Skagway', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SHA', 'Shanghai', 22);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SHD', 'Staunton', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SHR', 'Sheridan', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SHV', 'Shreveport', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SII', 'Alturas', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SIL', 'Slidell', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SIN', 'Singapore', 133);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SIT', 'Sitka', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SJC', 'San Jose', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SJT', 'San Angelo', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SJU', 'San Juan', 122);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SKA', 'Fairchild', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SKF', 'Kelly AFB', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SKX', 'Taos', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SLC', 'Salt Lake City', 156);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SLE', 'Salem', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SLI', 'Seal Beach', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SLK', 'Saranac Lake', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SLN', 'Salina', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SLP', 'San Luis Potosi', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SLU', 'Castries', 139);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SMC', 'Aspen(base)', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SMF', 'Smithfield', 125);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SMN', 'Salmon', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SMO', 'Santa Monica', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SMP', 'Stampede Pass', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SMX', 'Santa Maria', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SNA', 'Santa Ana', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SNP', 'St. Paul Island', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SNS', 'Salinas', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SNY', 'Sidney', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SOP', 'Southern Pines', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SOW', 'Show Low', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SPI', 'Springfield', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SPS', 'Wichita Falls', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SRI', 'Lewiston', 82);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SRQ', 'Sarasota', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SRU', 'Santa Cruz', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SSC', 'Sumter', 129);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SSI', 'Brunswick', 41);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SSM', 'Sault Ste. Marie', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STC', 'St. Cloud', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STJ', 'St. Joseph', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STL', 'St. Louis', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STP', 'St. Paul', 85);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STR', 'Stuttgart', 43);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STS', 'Santa Rosa', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STT', 'St. Thomas', 160);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('STX', 'Stamford', 25);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SUN', 'Sun Valley', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SUU', 'Travis AFB', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SUX', 'Sioux City', 52);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SVC', 'Silver City', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SVE', 'Susanville', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SVI', 'Sun Valley', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SVN', 'Hailey', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SVT', 'Stowe Mountain', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SWD', 'Seward', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SWF', 'Stewart Field', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SWO', 'Stillwater', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SXT', 'Sexton Summit', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SYD', 'Sydney', 95);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SYR', 'Syracuse', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('SZL', 'Knob Noster', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TAD', 'Trinidad', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TAL', 'Tanana', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TBN', 'Fort Leonard', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TBW', 'Ruskin', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TCC', 'Tucumcari', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TCL', 'Tuscaloosa', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TCM', 'Tacoma', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TCO', 'Telluride', 23);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TCS', 'Truth or Consequence', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TEB', 'Teterboro', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TGE', 'Tuskegee', 2);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TGU', 'Tegucigalpa', 50);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TGZ', 'Tuxtla Guterrez', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('THP', 'Thermopolis', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('THR', 'Tehran', 59);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TIJ', 'Tijuana', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TIM', 'Tombouctou/Timbuktu', 78);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TIP', 'Tripoli', 75);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TKA', 'Talkeetna', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TKJ', 'Tok', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TLH', 'Tallahassee', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TLO', 'Government Camp', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TLV', 'Tel Aviv', 62);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TN14', 'Dover', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TN16', 'Elizabethton', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TN65', 'Tazewell', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TN69', 'Waverly', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TN77', 'Germantown', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TNK', 'Teaneck', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TNP', 'Twentynine Palms', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TOA', 'Torrance', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TOL', 'Toledo', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TOP', 'Topeka', 69);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TOR', 'Torrington', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TPA', 'Tampa', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TPE', 'Taipei', 144);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TPH', 'Tonopah', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TPL', 'Temple', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TRI', 'Bristol', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TRK', 'Truckee', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TRM', 'Thermal', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TRU', 'Trujillo', 117);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TTD', 'Troutdale', 112);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TTN', 'Trenton', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TTQ', 'Murphy', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TTS', 'Titusville', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TUL', 'Tulsa', 110);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TUN', 'Tunis', 149);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TUP', 'Tupelo', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TUS', 'Tucson', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TVC', 'Traverse City', 84);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TVL', 'Tahoe Valley', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TWF', 'Twin Falls', 54);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX04', 'Andrews', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX05', 'Anson', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX06', 'Archer City', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX07', 'Aspermont', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX09', 'Atlanta', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX10', 'Ballinger', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX11', 'Bandera', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX50', 'Cooper', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX56', 'Cuero', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX80', 'Gonzales', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TX81', 'Graham', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TXK', 'Texarkana', 6);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TYR', 'Tyler', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('TYS', 'Knoxville', 147);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UCA', 'Utica', 108);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UGN', 'Waukegan', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UIL', 'Quillayute', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UIN', 'Quincy', 55);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UIO', 'Quito', 34);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UKI', 'Ukiah', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UNV', 'State College', 113);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UOX', 'Oxford', 88);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('UPC', 'Upper Montclair', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VBG', 'Lompoc/Vandenberg AFB', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VCE', 'Venice', 63);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VCT', 'Victoria', 151);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VCV', 'Victorville', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VDZ', 'Valdez', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VER', 'Veracruz', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VES', 'Waukesha', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VIE', 'Vienna', 9);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VIH', 'Vichy', 86);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VIS', 'Visalia', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VLD', 'Valdosta', 41);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VNC', 'Venice', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VNY', 'Van Nuys', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VOK', 'Volk Field', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VPS', 'Valparaiso', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VPZ', 'Valparaiso', 56);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VRB', 'Vero beach', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VSA', 'Villa Hermosa', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VT05', 'Newport', 161);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VTN', 'Valentine', 92);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VTU', 'Ventura', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('VVV', 'Ha Noi', 159);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('W03', 'Wilson', 90);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WA03', 'Lakewood', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WA05', 'Burien', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WA07', 'Mercer Island', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WA09', 'Opportunity', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WA10', 'Parkland', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WA12', 'Richmond Highlands', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WA13', 'SeaTac', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAB', 'Trowbridge', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAC', 'Nitinat Lake', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAE', 'Whistler/Alta Lake', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAH', 'Amherst', 106);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAJ', 'Rondeau Harbor', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAL', 'Wallops Island', 157);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAN', 'Amphititrite Point', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAR', 'Warwick', 125);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WAW', 'Warsaw', 119);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WBA', 'Banff', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WBE', 'Killarney', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WCA', 'Cartwright', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WCH', 'Atikokan', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WDH', 'Daniels Harbor', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WDI', 'Badger', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WDO', 'Twillingate', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WDQ', 'La Tuque', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WEH', 'Eastend Cypress', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WEP', 'East Point', 121);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WHO', 'Hopedale', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WHP', 'Heath Point', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WI01', 'Alma', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WI05', 'Beaver Dam', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WI06', 'Berlin', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WI08', 'Chilton', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WI15', 'Elkhorn', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WI22', 'Kewaunee', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WI28', 'Medford', 164);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WIK', 'Broadview', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WJA', 'Jasper', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WJF', 'Lancaster', 20);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WKM', 'Komakuk Beach', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WLB', 'Lac la Biche', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WLG', 'Wellington', 96);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WMC', 'Winnemucca', 107);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WMD', 'Mould Bay', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WME', 'Cathedral Point', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WMH', 'Mary\'s Harbour', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WMN', 'Mount Forest', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WNC', 'Coburg', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WNN', 'Winnfield', 72);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WNZ', 'Nagagami', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WOB', 'Brevoort Island', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WOE', 'Onefour', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WOO', 'Woonsocket', 125);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WPC', 'Port Colborne', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WPK', 'Parent', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WPO', 'Pilot Mound', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WPS', 'Long Point', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WPU', 'Puntzi Mountain', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WRA', 'Cape Race', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WRG', 'Wrangell', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WRI', 'Wrightstown', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WRL', 'Worland', 166);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WRO', 'Rosa Spit', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WRY', 'Milk River', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WSA', 'Sable Island', 106);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WSS', 'St. Stephen', 94);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('WWD', 'Wildwood', 101);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('X06', 'Arcadia', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('X36', 'Englewood', 39);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('XLE', 'Fort Benning', 41);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YAK', 'Yakutat', 1);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YAM', 'Sault Ste. Marie', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YBC', 'Baie Comeau', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YBG', 'Bagotville', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YBK', 'Baker Lake', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YBL', 'Campbell River', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YBR', 'Brandon', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YBU', 'Nipawin', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YBW', 'Springbank', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCB', 'Cambridge Bay Arpt', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCD', 'Nanaimo', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCG', 'Castlegar', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCH', 'Chatham', 94);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCL', 'Charlo', 94);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCO', 'Coppermine Airport', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCP', 'Blue River', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCT', 'Coronation', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCU', 'Chibougamau', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YCY', 'Clyder River', 106);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YDA', 'Dawson City', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YDB', 'Burwash', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YDF', 'Deer Lake', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YDN', 'Dauphin', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YDP', 'Nain Airport', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YDQ', 'Dawson Creek', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YEG', 'Edmonton', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YEN', 'Estevan', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YET', 'Edson', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YEV', 'Inuvik', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YFB', 'Frobisher', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YFC', 'Fredericton', 94);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YFD', 'Brantford', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YFO', 'Flin Flon', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YFS', 'Fort Simpson Arpt', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGD', 'Goderich', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGK', 'Kingston', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGL', 'La Grande Riviere', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGM', 'Gimli', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGP', 'Gaspe', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGQ', 'Geraldton', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGR', 'Iles-de-la-Madeleine', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGV', 'Havre St.Pierre', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YGX', 'Gillam', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YHB', 'Hudson Bay', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YHD', 'Dryden', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YHE', 'Hope Airport', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YHM', 'Hamilton', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YHY', 'Hay River', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YHZ', 'Halifax', 106);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YIV', 'Island Lake', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YJT', 'Stephenville Arpt', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YKA', 'Kamloops', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YKF', 'Kitchener', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YKJ', 'Key Lake', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YKL', 'Schefferville Lake', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YKM', 'Yakima', 162);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YKN', 'Yankton', 130);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YKY', 'Kindersley', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YLI', 'Lindsay', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YLJ', 'Meadow Lake', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YLL', 'Lloyd Minster', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YLT', 'Alert', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YLW', 'Kelowna', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YMA', 'Mayo', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YMD', 'Edmundston', 94);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YMJ', 'Moose Jaw', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YMM', 'Fort Mcmurray', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YMN', 'Manning', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YMO', 'Moosonee', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YMT', 'Chibougamou', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YNA', 'Natashquan Airport', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YNE', 'Norway House Arpt', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YNG', 'Youngstown', 109);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YNM', 'Matagami', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YOD', 'Cold Lake', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YOJ', 'High Level', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YOW', 'Ottawa', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YPA', 'Prince Albert Arpt', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YPE', 'Peace River', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YPG', 'Portage', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YPL', 'Pickle Lake', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YPQ', 'Peterborough', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YPR', 'Prince Rupert', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YPY', 'Fort Chipeyan', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQA', 'Muskoka', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQB', 'Quebec', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQD', 'The Pas', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQF', 'Red Deer', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQG', 'Windsor', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQH', 'Watson Lake', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQI', 'Yarmouth', 106);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQK', 'Kenora', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQL', 'Lethbridge', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQM', 'Moncton', 94);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQQ', 'Comox', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQR', 'Regina', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQT', 'Thunder Bay', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQU', 'Grande Prairie', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQV', 'Yorkton', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQW', 'North Battleford', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQX', 'Gander', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQY', 'Sydney', 106);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YQZ', 'Quesnel Airport', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YRB', 'Mag North Pole', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YRJ', 'Roberval Airport', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YRL', 'Red Lake', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YRM', 'Rocky Mt House', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YRQ', 'Trois-Rivieres', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YRT', 'Rankin Inlet', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YRV', 'Revelstoke Airport', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSB', 'Sudbury', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSC', 'Sherbrooke', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSD', 'Suffield', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSF', 'Stony Plain', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSJ', 'St. John', 94);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSM', 'Fort Smith Airport', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSN', 'St. Catherines', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YSY', 'Sachs Harbour', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YTH', 'Thompson', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YTJ', 'Terrace Bay', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YTL', 'Big Trout Lake', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YTR', 'Trenton', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YTS', 'Timmins', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YTZ', 'Toronto Island', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YUB', 'Tuktoyaktuk', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YUJ', 'Lady Franklin Point', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YUL', 'Montreal', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YUM', 'Yuma', 10);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YUS', 'Shepherd Bay', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YUT', 'Repulse Bay', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YUX', 'Hall Beach', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVC', 'La Ronge', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVG', 'Vermilion', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVO', 'Val d\' Or', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVP', 'Kuujjuaq', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVQ', 'Norman Wells Arpt', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVR', 'Vancouver', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVT', 'Buffalo Narrows', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YVV', 'Owen Sound', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YWG', 'Winnipeg', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YWK', 'Wabash Lake', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YWL', 'Williams Lake', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YWM', 'Athabasca', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YWV', 'Wainwright', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXC', 'Cranbrook', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXD', 'Edmonton', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXE', 'Saskatoon', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXH', 'Medicine Hat', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXJ', 'Fort St. John', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXK', 'Rimouski', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXL', 'Sioux Lookout Arpt', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXQ', 'Beaver Creek', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXR', 'Earlton', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXS', 'Prince George', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXT', 'Terrace', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXU', 'London', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXX', 'Abbotsford', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YXY', 'Whitehorse', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYB', 'North Bay', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYC', 'Calgary', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYD', 'Smithers', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYE', 'Fort Nelson Airport', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYF', 'Penticton', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYG', 'Charlottetown', 121);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYJ', 'Victoria', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYL', 'Lynn Lake Airport', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYN', 'Swift Current', 127);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYQ', 'Churchill', 79);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYR', 'Goose Bay', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYT', 'St. Johns', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYU', 'Kapuskasing', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYY', 'Mount Joli', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YYZ', 'Toronto', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZE', 'Gore Bay Airport', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZF', 'Yellowknife', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZH', 'Slave Lake', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZP', 'Sandspit', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZR', 'Sarnia', 111);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZS', 'Coral Harbour Arpt', 104);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZT', 'Port Hardy', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZU', 'Whitecourt', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZV', 'Sept Isles', 123);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZW', 'Teslin', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZX', 'Greenwood', 106);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('YZY', 'Mackenzie Airport', 19);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ZDI', 'Churchill Falls', 97);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ZFA', 'Faro', 167);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ZHP', 'High Prairie', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ZJN', 'Swan Hills', 3);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ZLO', 'Manzanillo', 83);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ZUN', 'Zuni', 102);
INSERT INTO city (accid, city_title, subdiv_id) VALUES ('ZZV', 'Zanesville', 109);
# --------------------------------------------------------

#
# Table structure for table `country`
#

CREATE TABLE country (
  country_title varchar(50) default NULL,
  country_id int(4) NOT NULL auto_increment,
  region_id int(4) NOT NULL default '0',
  PRIMARY KEY  (country_id),
  KEY country_title (country_title)
) TYPE=MyISAM;

#
# Dumping data for table `country`
#

INSERT INTO country (country_title, country_id, region_id) VALUES ('Algeria', 1, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Antigua', 2, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Argentina', 3, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Aruba', 4, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Australia', 5, 3);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Austria', 6, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Bahamas', 7, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Baharain', 8, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Barbados', 9, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Belgium', 10, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Belize', 11, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Bermuda', 12, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Bolivia', 13, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Brazil', 14, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Canada', 15, 4);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Chile', 16, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('China', 17, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Colombia', 18, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Cuba', 19, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Curacao', 20, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Cyprus', 21, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Czech Republic', 22, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Denmark', 23, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Dominican Republic', 24, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Ecuador', 25, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Egypt', 26, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('El Salvador', 27, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Ethiopia', 28, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Finland', 29, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('France', 30, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Georgia', 31, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Germany', 32, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Greece', 33, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Guadaloupe', 34, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Guatemala', 35, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Guyana', 36, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Haiti', 37, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Honduras', 38, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Hungary', 39, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Iceland', 40, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('India', 41, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Indonesia', 42, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Iran', 43, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Iraq', 44, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Ireland', 45, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Israel', 46, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Italy', 47, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Ivory Coast', 48, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Jamaica', 49, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Japan', 50, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Jordan', 51, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Kenya', 52, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Kuwait', 53, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Latvia', 54, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Lebanon', 55, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Libya', 56, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Malaysia', 57, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Mali', 58, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Martinique', 59, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Mexico', 60, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Morocco', 61, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Netherlands', 62, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('New Zealand', 63, 3);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Nicaragua', 64, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Nigeria', 65, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Norway', 66, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Pakistan', 67, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Panama', 68, 6);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Paraguay', 69, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Peru', 70, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Philippines', 71, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Poland', 72, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Portugal', 73, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Puerto Rico', 74, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Russia', 75, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Saudi Arabia', 76, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Senegal', 77, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Serbia', 78, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Singapore', 79, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Slovakia', 80, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Somalia', 81, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('South Africa', 82, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Spain', 83, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Sri Lanka', 84, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('St. Lucia', 85, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Suriname', 86, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Sweden', 87, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Switzerland', 88, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Syria', 89, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Taiwan', 90, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Tanzania', 91, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Trinidad and Tobago', 92, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Tunisia', 93, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Turkey', 94, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Ukraine', 95, 7);
INSERT INTO country (country_title, country_id, region_id) VALUES ('United Arab Emirates', 96, 8);
INSERT INTO country (country_title, country_id, region_id) VALUES ('United Kingdom', 97, 11);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Uruguay', 98, 9);
INSERT INTO country (country_title, country_id, region_id) VALUES ('USA', 99, 10);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Vietnam', 100, 2);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Virgin Islands (U.S.)', 101, 5);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Zaire', 102, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Zambia', 103, 1);
INSERT INTO country (country_title, country_id, region_id) VALUES ('Zimbabwe', 104, 1);
# --------------------------------------------------------

#
# Table structure for table `region`
#

CREATE TABLE region (
  region_title varchar(50) default NULL,
  region_id int(4) NOT NULL auto_increment,
  PRIMARY KEY  (region_id)
) TYPE=MyISAM;

#
# Dumping data for table `region`
#

INSERT INTO region (region_title, region_id) VALUES ('Africa', 1);
INSERT INTO region (region_title, region_id) VALUES ('Asia', 2);
INSERT INTO region (region_title, region_id) VALUES ('Australia/New Zeland', 3);
INSERT INTO region (region_title, region_id) VALUES ('Canada', 4);
INSERT INTO region (region_title, region_id) VALUES ('Caribbean', 5);
INSERT INTO region (region_title, region_id) VALUES ('Central America', 6);
INSERT INTO region (region_title, region_id) VALUES ('Eastern Europe', 7);
INSERT INTO region (region_title, region_id) VALUES ('Orient', 8);
INSERT INTO region (region_title, region_id) VALUES ('South America', 9);
INSERT INTO region (region_title, region_id) VALUES ('United States', 10);
INSERT INTO region (region_title, region_id) VALUES ('Western Europe', 11);
# --------------------------------------------------------

#
# Table structure for table `subdiv`
#

CREATE TABLE subdiv (
  subdiv_title varchar(50) default NULL,
  subdiv_id int(4) NOT NULL auto_increment,
  country_id int(4) NOT NULL default '0',
  PRIMARY KEY  (subdiv_id)
) TYPE=MyISAM;

#
# Dumping data for table `subdiv`
#

INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('AK', 1, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('AL', 2, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Alberta', 3, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Algeria', 4, 1);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Antigua', 5, 2);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('AR', 6, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Argentina', 7, 3);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Aruba', 8, 4);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Austria', 9, 6);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('AZ', 10, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Bahamas', 11, 7);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Baharain', 12, 8);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Barbados', 13, 9);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Belgium', 14, 10);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Belize', 15, 11);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Bermuda', 16, 12);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Bolivia', 17, 13);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Brazil', 18, 14);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('British Columbia', 19, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('CA', 20, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Chile', 21, 16);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('China', 22, 17);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('CO', 23, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Colombia', 24, 18);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('CT', 25, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Cuba', 26, 19);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Curacao', 27, 20);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Cyprus', 28, 21);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Czech Republic', 29, 22);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('DC', 30, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('DE', 31, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Denmark', 32, 23);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Dominican Republic', 33, 24);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Ecuador', 34, 25);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Egypt', 35, 26);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('El Salvador', 36, 27);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Ethiopia', 37, 28);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Finland', 38, 29);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('FL', 39, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('France', 40, 30);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('GA', 41, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Georgia', 42, 31);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Germany', 43, 32);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Greece', 44, 33);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Guadaloupe', 45, 34);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Guatemala', 46, 35);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Guyana', 47, 36);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Haiti', 48, 37);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('HI', 49, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Honduras', 50, 38);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Hungary', 51, 39);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('IA', 52, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Iceland', 53, 40);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('ID', 54, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('IL', 55, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('IN', 56, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('India', 57, 41);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Indonesia', 58, 42);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Iran', 59, 43);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Iraq', 60, 44);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Ireland', 61, 45);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Israel', 62, 46);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Italy', 63, 47);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Ivory Coast', 64, 48);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Jamaica', 65, 49);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Japan', 66, 50);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Jordan', 67, 51);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Kenya', 68, 52);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('KS', 69, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Kuwait', 70, 53);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('KY', 71, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('LA', 72, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Latvia', 73, 54);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Lebanon', 74, 55);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Libya', 75, 56);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('MA', 76, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Malaysia', 77, 57);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Mali', 78, 58);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Manitoba', 79, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Martinique', 80, 59);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('MD', 81, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('ME', 82, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Mexico', 83, 60);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('MI', 84, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('MN', 85, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('MO', 86, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Morocco', 87, 61);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('MS', 88, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('MT', 89, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('NC', 90, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('ND', 91, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('NE', 92, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Netherlands', 93, 62);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('New Brunswick', 94, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('New South Wales', 95, 5);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('New Zealand', 96, 63);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Newfoundland', 97, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('NH', 98, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Nicaragua', 99, 64);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Nigeria', 100, 65);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('NJ', 101, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('NM', 102, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Northern Territory', 103, 5);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Northwest Territories', 104, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Norway', 105, 66);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Nova Scotia', 106, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('NV', 107, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('NY', 108, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('OH', 109, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('OK', 110, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Ontario', 111, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('OR', 112, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('PA', 113, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Pakistan', 114, 67);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Panama', 115, 68);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Paraguay', 116, 69);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Peru', 117, 70);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Philippines', 118, 71);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Poland', 119, 72);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Portugal', 120, 73);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Prince Edward Island', 121, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Puerto Rico', 122, 74);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Quebec', 123, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Queensland', 124, 5);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('RI', 125, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Russia', 126, 75);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Saskatchewan', 127, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Saudi Arabia', 128, 76);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('SC', 129, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('SD', 130, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Senegal', 131, 77);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Serbia', 132, 78);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Singapore', 133, 79);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Slovakia', 134, 80);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Somalia', 135, 81);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('South Africa', 136, 82);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Spain', 137, 83);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Sri Lanka', 138, 84);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('St. Lucia', 139, 85);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Suriname', 140, 86);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Sweden', 141, 87);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Switzerland', 142, 88);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Syria', 143, 89);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Taiwan', 144, 90);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Tanzania', 145, 91);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Tasmania', 146, 5);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('TN', 147, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Trinidad and Tobago', 148, 92);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Tunisia', 149, 93);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Turkey', 150, 94);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('TX', 151, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Ukraine', 152, 95);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('United Arab Emirates', 153, 96);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('United Kingdom', 154, 97);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Uruguay', 155, 98);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('UT', 156, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('VA', 157, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Victoria', 158, 5);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Vietnam', 159, 100);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Virgin Islands (U.S.)', 160, 101);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('VT', 161, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('WA', 162, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Western Australia', 163, 5);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('WI', 164, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('WV', 165, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('WY', 166, 99);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Yukon Territories', 167, 15);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Zaire', 168, 102);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Zambia', 169, 103);
INSERT INTO subdiv (subdiv_title, subdiv_id, country_id) VALUES ('Zimbabwe', 170, 104);
# --------------------------------------------------------

#
# Table structure for table `userweather`
#

CREATE TABLE userweather (
  userid int(11) NOT NULL default '0',
  accid varchar(5) NOT NULL default '',
  tpc tinyint(1) NOT NULL default '1',
  tps tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (userid)
) TYPE=MyISAM;

#
# Dumping data for table `userweather`
#

INSERT INTO userweather (userid, accid, tpc, tps) VALUES (0, 'SFO', 1, 1);
