-- phpMyAdmin SQL Dump -- version 2.11.9.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 26, 2009 at 04:12 PM -- Server version: 5.0.67 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `agstest_weather` -- -- -------------------------------------------------------- -- -- Table structure for table `CityNames` -- CREATE TABLE `CityNames` ( `city` varchar(55) NOT NULL, `state` char(2) NOT NULL, `lat` decimal(6,3) NOT NULL, `lon` decimal(6,3) NOT NULL, `level` tinyint(4) NOT NULL, `entered` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`lat`,`lon`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `CityNames` -- INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Nome', 'AK', '64.500', '-165.430', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Juneau', 'AK', '58.370', '-134.580', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fairbanks', 'AK', '64.820', '-147.870', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Barrow', 'AK', '71.300', '-156.780', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Anchorage', 'AK', '61.170', '-150.020', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Croix', 'VI', '17.700', '-64.900', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Thomas', 'VI', '18.340', '-64.960', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('San Juan', 'PR', '18.400', '-66.000', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Richmond', 'VA', '37.500', '-77.330', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Milwaukee', 'WI', '42.950', '-87.900', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Spokane', 'WA', '47.630', '-117.530', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Salt Lake City', 'UT', '40.780', '-111.970', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('San Antonio', 'TX', '29.530', '-98.470', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Houston', 'TX', '29.650', '-95.280', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Midland', 'TX', '32.000', '-102.080', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('ElPaso', 'TX', '31.800', '-106.400', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dallas', 'TX', '32.900', '-97.030', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Brownsville', 'TX', '25.900', '-97.430', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Austin', 'TX', '30.300', '-97.700', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Nashville', 'TN', '36.170', '-86.780', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sioux Falls', 'SD', '43.580', '-96.730', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hartford', 'CT', '41.730', '-72.650', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pittsburgh', 'PA', '40.350', '-79.930', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Philadelphia', 'PA', '39.880', '-75.250', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Erie', 'PA', '42.080', '-80.180', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Portland', 'OR', '45.600', '-122.600', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Toledo', 'OH', '41.600', '-83.800', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Columbus', 'OH', '40.000', '-82.880', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Cleveland', 'OH', '41.420', '-81.870', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Minot', 'ND', '48.270', '-101.280', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fargo', 'ND', '46.900', '-96.800', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bismarck', 'ND', '46.770', '-100.750', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('New York City', 'NY', '40.770', '-73.980', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Syracuse', 'NY', '43.120', '-76.120', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Buffalo', 'NY', '42.930', '-78.730', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Albany', 'NY', '42.750', '-73.800', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Albuquerque', 'NM', '35.050', '-106.600', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Las Vegas', 'NV', '36.080', '-115.170', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Elko', 'NV', '40.830', '-115.780', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Missoula', 'MT', '46.920', '-114.080', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Glasgow', 'MT', '48.220', '-106.620', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Butte', 'MT', '45.950', '-112.500', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Billings', 'MT', '45.800', '-108.530', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Louis', 'MO', '38.750', '-90.370', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tupelo', 'MS', '34.270', '-88.770', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Minneapolis', 'MN', '44.880', '-93.220', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Duluth', 'MN', '46.830', '-92.180', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Marquette', 'MI', '46.540', '-87.410', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Detroit', 'MI', '42.230', '-83.330', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Baltimore', 'MD', '39.180', '-76.670', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Portland', 'ME', '43.650', '-70.320', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Caribou', 'ME', '46.861', '-68.012', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bangor', 'ME', '44.801', '-68.778', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('New Orleans', 'LA', '30.030', '-90.030', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Paducah', 'KY', '37.070', '-88.770', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Goodland', 'KS', '39.370', '-101.700', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Springfield', 'IL', '39.850', '-89.670', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Chicago', 'IL', '41.980', '-87.900', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Boise', 'ID', '43.570', '-116.220', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tampa', 'FL', '27.970', '-82.530', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Orlando', 'FL', '28.550', '-81.330', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Miami Int''l', 'FL', '25.800', '-80.280', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Key West', 'FL', '24.580', '-81.750', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Washington', 'DC', '38.850', '-77.040', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Denver', 'CO', '39.750', '-104.870', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pueblo', 'CO', '38.290', '-104.520', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('San Diego', 'CA', '32.730', '-117.170', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Los Angeles', 'CA', '34.027', '-118.329', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Little Rock', 'AR', '35.220', '-92.380', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jackson', 'TN', '35.600', '-88.920', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tucson', 'AZ', '32.120', '-110.930', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Phoenix', 'AZ', '33.440', '-112.020', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Flagstaff', 'AZ', '35.130', '-111.670', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Reno', 'NV', '39.500', '-119.780', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Atlanta', 'GA', '33.650', '-84.420', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Knoxville', 'TN', '35.820', '-83.980', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tulsa', 'OK', '36.200', '-95.900', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Oklahoma City', 'OK', '35.400', '-97.600', 1, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Saipan', 'GU', '15.210', '145.720', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tinian', 'GU', '14.960', '145.650', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rota', 'GU', '14.160', '145.230', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Guam', 'GU', '13.480', '144.810', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Seward', 'AK', '60.180', '-149.750', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('McGrath', 'AK', '62.970', '-155.620', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ketchikan', 'AK', '55.350', '-131.700', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bettles', 'AK', '66.920', '-151.520', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Adak', 'AK', '51.880', '-176.650', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Kona', 'HI', '19.740', '-156.040', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Kahului', 'HI', '20.890', '-156.440', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lihue', 'HI', '21.980', '-159.340', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Honolulu', 'HI', '21.330', '-157.940', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hilo', 'HI', '19.720', '-155.060', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Vieques', 'PR', '18.120', '-65.450', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('San Jose', 'CA', '37.360', '-121.920', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Charlottesville', 'VA', '38.130', '-78.450', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Norfolk', 'VA', '36.900', '-76.200', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Riverton', 'WY', '43.030', '-108.410', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Yellowstone', 'WY', '44.550', '-110.420', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rawlins', 'WY', '41.780', '-107.220', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Douglas', 'WY', '42.740', '-105.390', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rhinelander', 'WI', '45.630', '-89.450', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Oshkosh', 'WI', '44.000', '-88.570', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Madison', 'WI', '43.130', '-89.330', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('LaCrosse', 'WI', '43.870', '-91.250', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Seattle', 'WA', '47.450', '-122.300', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Olympia', 'WA', '46.970', '-122.900', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Burlington', 'VT', '44.470', '-73.150', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rutland', 'VT', '43.540', '-72.950', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Waco', 'TX', '31.620', '-97.220', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('San Angelo', 'TX', '31.370', '-100.500', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lubbock', 'TX', '33.650', '-101.820', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Abilene', 'TX', '32.420', '-99.680', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Amarillo', 'TX', '35.230', '-101.700', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lufkin', 'TX', '31.330', '-94.720', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lewisburg', 'TN', '35.440', '-86.790', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Memphis', 'TN', '35.050', '-90.000', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Watertown', 'SD', '44.920', '-97.150', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rapid City', 'SD', '44.050', '-103.070', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pierre', 'SD', '44.380', '-100.280', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Aberdeen', 'SD', '45.450', '-98.430', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Columbia', 'SC', '33.950', '-81.140', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Florence', 'SC', '34.150', '-79.710', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Salem', 'OR', '44.920', '-123.000', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Roseburg', 'OR', '43.250', '-123.350', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pendleton', 'OR', '45.680', '-118.850', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dayton', 'OH', '39.900', '-84.200', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Cincinnati', 'OH', '39.046', '-84.662', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Grand Forks', 'ND', '47.950', '-97.180', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Raleigh-Durham', 'NC', '35.870', '-78.780', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('CapeHatteras', 'NC', '35.270', '-75.550', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Newport', 'NC', '34.780', '-76.880', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Greenville', 'NC', '35.630', '-77.300', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rochester', 'NY', '43.120', '-77.670', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Elmira', 'NY', '42.170', '-76.900', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Roswell', 'NM', '33.300', '-104.530', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Concord', 'MA', '43.200', '-71.500', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ely', 'NV', '39.280', '-114.850', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('North Platte', 'NE', '41.130', '-100.680', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hastings', 'NE', '40.600', '-98.430', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Kalispell', 'MT', '48.300', '-114.270', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Helena', 'MT', '46.600', '-112.000', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Havre', 'MT', '48.550', '-109.770', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Springfield', 'MO', '37.230', '-93.380', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Poplar Bluff', 'MO', '36.770', '-90.470', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Columbia', 'MO', '38.820', '-92.220', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jackson', 'MS', '32.320', '-90.080', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('International Falls', 'MN', '48.570', '-93.380', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sault St Marie', 'MI', '46.470', '-84.370', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Saginaw', 'MI', '43.530', '-84.080', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lansing', 'MI', '42.770', '-84.600', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ironwood', 'MI', '46.530', '-90.130', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Port Huron', 'MI', '42.920', '-82.530', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Alpena', 'MI', '45.070', '-83.570', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Worcester', 'MA', '42.270', '-71.870', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Millinocket', 'ME', '45.657', '-68.710', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Eastport', 'ME', '44.900', '-67.010', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rumford', 'ME', '44.880', '-70.880', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Shreveport', 'LA', '32.470', '-93.820', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lake Charles', 'LA', '30.120', '-93.220', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Baton Rouge', 'LA', '30.530', '-91.150', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Louisville', 'KY', '38.230', '-85.670', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Liberal', 'KS', '37.050', '-100.970', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dodge City', 'KS', '37.770', '-99.970', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Des Moines', 'IA', '41.530', '-93.650', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('South Bend', 'IN', '41.700', '-86.320', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Indianapolis', 'IN', '39.730', '-86.270', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lafayette', 'IN', '40.400', '-86.870', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fort Wayne', 'IN', '41.000', '-85.200', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Evansville', 'IN', '38.050', '-87.530', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Peoria', 'IL', '40.670', '-89.680', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Twin Falls', 'ID', '42.480', '-114.480', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Palm Beach', 'FL', '26.680', '-80.090', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ocala', 'FL', '29.173', '-82.224', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Grand Junction', 'CO', '39.120', '-108.530', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Durango', 'CO', '37.150', '-107.750', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fresno', 'CA', '36.770', '-119.720', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Texarkana', 'AR', '33.450', '-94.000', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jonesboro', 'AR', '35.830', '-90.650', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Yuma', 'AZ', '32.650', '-114.620', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Huntsville', 'AL', '34.650', '-86.770', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Birmingham', 'AL', '33.570', '-86.750', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Redding', 'CA', '40.560', '-122.360', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Augusta', 'GA', '33.370', '-81.960', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Macon', 'GA', '32.700', '-83.650', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Charlotte', 'NC', '35.198', '-80.835', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Roanoke', 'VA', '37.320', '-79.970', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Charleston', 'WV', '38.370', '-81.600', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Greenville', 'SC', '34.837', '-82.372', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wichita', 'KS', '37.650', '-97.430', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wichita Falls', 'TX', '33.900', '-98.500', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Topeka', 'KS', '39.070', '-95.620', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lincoln', 'NE', '40.850', '-96.750', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Kansas City', 'MO', '39.320', '-94.720', 2, '2009-01-05 17:22:57'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Massena', 'NY', '44.930', '-74.850', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Binghamton', 'NY', '42.220', '-75.980', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tucumcari', 'NM', '35.180', '-103.600', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Silver City', 'NM', '32.630', '-108.170', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sante Fe', 'NM', '35.620', '-106.080', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Las Cruces', 'NM', '32.300', '-106.770', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hobbs', 'NM', '32.680', '-103.200', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Gallup', 'NM', '35.520', '-108.780', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Clayton', 'NM', '36.450', '-103.150', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Carlsbad', 'NM', '32.330', '-104.270', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Trenton', 'NJ', '40.280', '-74.820', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Atlantic City', 'NJ', '39.450', '-74.570', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mt Washington', 'NH', '44.270', '-71.300', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Austin', 'NV', '39.830', '-117.130', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Norfolk', 'NE', '41.980', '-97.430', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Valentine', 'NE', '42.870', '-100.550', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Scottsbluff', 'NE', '41.870', '-103.600', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mccook', 'NE', '40.220', '-100.580', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Alliance', 'NE', '42.050', '-102.800', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sidney', 'MT', '47.720', '-104.180', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Miles City', 'MT', '46.430', '-105.870', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jordan', 'MT', '47.330', '-106.930', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Glendive', 'MT', '47.130', '-104.800', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wolf Point', 'MT', '48.100', '-105.580', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lewistown', 'MT', '47.050', '-109.450', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sun Valley', 'ID', '43.500', '-114.300', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Salmon', 'ID', '45.120', '-113.880', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Great Falls', 'MT', '47.480', '-111.370', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Baker', 'MT', '46.380', '-104.240', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Broadus', 'MT', '45.420', '-105.460', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Livingston', 'MT', '45.700', '-110.470', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Farmington', 'MO', '37.760', '-90.430', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Quincy', 'IN', '39.940', '-91.200', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Branson', 'MO', '36.560', '-93.190', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('West Plains', 'MO', '36.770', '-91.900', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rolla', 'MO', '37.890', '-91.770', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Osage Beach', 'MO', '38.130', '-92.600', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Nevada', 'MO', '37.830', '-94.370', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Joplin', 'MO', '37.140', '-94.520', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Meridian', 'MS', '32.330', '-88.750', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mccomb', 'MS', '31.180', '-90.470', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Gulfport', 'MS', '30.400', '-89.070', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Greenwood', 'MS', '33.500', '-90.080', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Cloud', 'MN', '45.550', '-94.070', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fergus Falls', 'MN', '46.300', '-96.070', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Traverse City', 'MI', '44.730', '-85.580', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Newberry', 'MI', '46.530', '-85.510', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Houghton', 'MI', '47.150', '-88.480', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Iron Mountain', 'MI', '45.820', '-88.060', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Holland', 'MI', '42.750', '-86.100', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Big Rapids', 'MI', '43.720', '-85.500', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ludington', 'WI', '43.960', '-86.410', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jackson', 'MI', '42.270', '-84.470', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('South Haven', 'MI', '42.410', '-86.350', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pentwater', 'MI', '43.780', '-86.490', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Kalamazoo', 'MI', '42.230', '-85.550', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Grand Rapids', 'MI', '42.880', '-85.520', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Escanaba', 'MI', '45.730', '-87.080', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bad Axe', 'MI', '43.790', '-82.990', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Flint', 'MI', '42.980', '-83.730', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Houghton Lake', 'MI', '44.380', '-84.680', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Otsego County Airport', 'MI', '45.020', '-84.680', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pellston', 'MI', '45.580', '-84.800', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pittsfield', 'MA', '42.450', '-73.250', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('New Philadelphia', 'OH', '40.490', '-81.440', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Zanesville', 'OH', '39.950', '-82.010', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mercer', 'PA', '41.230', '-80.240', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Butler', 'PA', '40.860', '-79.900', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Brookville', 'PA', '41.160', '-79.080', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Oakland', 'MD', '39.520', '-79.270', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Morgantown', 'WV', '39.630', '-79.950', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Nantucket', 'MA', '41.250', '-70.070', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Cape Cod', 'MA', '41.780', '-70.500', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Boston', 'MA', '42.370', '-71.030', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Salisbury', 'MD', '38.330', '-75.500', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Point of Rocks', 'MD', '39.276', '-77.530', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hagerstown', 'MD', '39.700', '-77.720', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Frenchville', 'ME', '47.281', '-68.380', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bar Harbor', 'ME', '44.388', '-68.204', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Clayton Lake', 'ME', '46.611', '-69.523', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Houlton', 'ME', '46.126', '-67.841', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Greenville', 'ME', '45.470', '-69.550', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Augusta', 'ME', '44.320', '-69.800', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fryeburg', 'VT', '43.980', '-70.950', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Monroe', 'LA', '32.520', '-92.050', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Alexandria', 'LA', '31.380', '-92.300', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('London', 'KY', '37.130', '-84.070', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Somerset', 'KY', '37.070', '-84.610', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hazard', 'KY', '37.250', '-83.190', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jackson', 'KY', '37.560', '-83.380', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mount Sterling', 'KY', '38.050', '-83.940', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Morehead', 'KY', '38.180', '-83.440', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bowling Green', 'KY', '36.970', '-86.430', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Burlington', 'CO', '39.150', '-102.170', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hill City', 'KS', '39.220', '-99.500', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Garden City', 'KS', '37.930', '-100.720', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Medicine Lodge', 'KS', '37.300', '-98.580', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hays', 'KS', '38.860', '-99.270', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Waterloo', 'IA', '42.550', '-92.400', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sioux City', 'IA', '42.400', '-96.380', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mason City', 'IA', '43.150', '-93.330', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dubuque', 'IA', '42.400', '-90.700', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ottumwa', 'IA', '41.010', '-92.420', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Creston', 'IA', '41.060', '-94.370', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fort Dodge', 'IA', '42.510', '-94.180', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Burlington', 'IA', '40.810', '-91.120', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Moline', 'IN', '41.500', '-90.520', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Cedar Rapids', 'IA', '41.880', '-91.700', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Terre Haute', 'IN', '39.450', '-87.300', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Muncie', 'IN', '40.190', '-85.380', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bloomington', 'IN', '39.160', '-86.520', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Greensburg', 'IN', '39.327', '-85.523', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Gary', 'IN', '41.620', '-87.420', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rockford', 'IL', '42.200', '-89.100', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mount Vernon', 'IL', '38.320', '-88.860', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pocatello', 'ID', '42.920', '-112.600', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lewiston', 'ID', '46.380', '-117.020', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Idaho Falls', 'ID', '43.520', '-112.070', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bonners Ferry', 'ID', '48.680', '-116.340', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wenatchee', 'WA', '47.400', '-120.200', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Moses Lake', 'WA', '47.200', '-119.320', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Burns', 'OR', '43.580', '-118.950', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('McCall', 'ID', '44.880', '-116.100', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Savannah', 'GA', '32.130', '-81.200', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Albany', 'GA', '31.530', '-84.180', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Cross City', 'FL', '29.640', '-83.120', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Valdosta', 'GA', '30.850', '-83.280', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tallahassee', 'FL', '30.380', '-84.370', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pensacola', 'FL', '30.470', '-87.200', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Panama City', 'FL', '30.200', '-85.680', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Naples', 'FL', '26.160', '-81.770', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Alma', 'GA', '31.536', '-82.507', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Simons Island', 'GA', '31.152', '-81.394', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Augustine', 'FL', '29.959', '-81.340', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jacksonville', 'FL', '30.494', '-81.688', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Gainesville', 'FL', '29.690', '-82.272', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Daytona Beach', 'FL', '29.180', '-81.050', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dover', 'DE', '39.130', '-75.470', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Steamboat Springs', 'CO', '40.480', '-106.820', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Trinidad', 'CO', '37.250', '-104.330', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ft Collins', 'CO', '40.580', '-105.080', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Colorado Springs', 'CO', '38.820', '-104.720', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lamar', 'CO', '38.070', '-102.680', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Leadville', 'CO', '39.220', '-106.320', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Alamosa', 'CO', '37.460', '-105.870', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bishop', 'CA', '37.600', '-118.600', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('San Luis Obispo', 'CA', '35.230', '-120.650', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Blue Canyon', 'CA', '39.260', '-120.710', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fairfield', 'CA', '38.250', '-122.040', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Stockton', 'CA', '37.960', '-121.310', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('San Francisco', 'CA', '37.760', '-122.430', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Needles', 'CA', '34.770', '-114.620', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bakersfield', 'CA', '35.430', '-119.050', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Union City', 'TN', '36.380', '-88.990', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Clarksdale', 'MS', '34.300', '-90.510', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pine Bluff', 'AR', '34.170', '-91.930', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Imperial', 'CA', '32.840', '-115.570', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Parker', 'AZ', '34.130', '-114.280', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Gila Bend', 'AZ', '32.890', '-112.720', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Globe', 'AZ', '33.380', '-110.770', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dothan', 'AL', '31.320', '-85.450', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Montgomery', 'AL', '32.300', '-86.400', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Evergreen', 'AL', '31.417', '-87.050', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Camden', 'AL', '31.990', '-87.290', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mobile', 'AL', '30.680', '-88.250', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Florence', 'AL', '34.830', '-87.660', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fort Payne', 'AL', '34.440', '-85.680', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lakeview', 'OR', '42.160', '-120.390', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Eureka', 'CA', '40.767', '-124.103', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Medford', 'OR', '42.370', '-122.870', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wendover', 'NV', '40.721', '-114.036', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Eureka', 'NV', '39.601', '-116.006', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Winnemuca', 'NV', '40.902', '-117.807', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sacramento', 'CA', '38.560', '-121.470', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lewisburg', 'WV', '37.870', '-80.400', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Snowshoe', 'WV', '38.420', '-79.980', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Columbus', 'GA', '32.520', '-84.930', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Athens', 'GA', '33.950', '-83.320', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bristol', 'TN', '36.480', '-82.400', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Chattanooga', 'TN', '35.030', '-85.200', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Hickory', 'NC', '35.750', '-81.380', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Farmville', 'VA', '37.350', '-78.430', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Elizabeth City', 'NC', '36.260', '-76.170', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Danville', 'VA', '36.570', '-79.330', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Middlesboro', 'KY', '36.613', '-83.722', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pikeville', 'KY', '37.480', '-82.520', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Beckley', 'WV', '37.780', '-81.120', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Clarksburg', 'WV', '39.280', '-80.230', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Elkins', 'WV', '38.880', '-79.850', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Huntington', 'WV', '38.370', '-82.550', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Asheville', 'NC', '35.574', '-82.549', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Spickard', 'MO', '40.250', '-93.720', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Chanute', 'KS', '37.670', '-95.480', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ardmore', 'OK', '34.300', '-97.020', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Salina', 'KS', '38.800', '-97.650', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Omaha', 'NE', '41.300', '-95.900', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Enid', 'OK', '36.380', '-97.800', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fort Smith', 'AR', '35.350', '-94.370', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fayetteville', 'AR', '36.000', '-94.170', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Joseph', 'MO', '40.280', '-95.530', 3, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lanai City', 'HI', '20.780', '-156.950', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Kaunankaki', 'HI', '21.150', '-157.100', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Culebra', 'PR', '18.310', '-65.280', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Roosevelt', 'PR', '18.250', '-65.630', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Ponce', 'PR', '18.010', '-66.560', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mayaguez', 'PR', '18.250', '-67.150', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Aquadilla', 'PR', '18.490', '-67.130', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Santa Rosa', 'CA', '38.520', '-122.820', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Monterey', 'CA', '36.580', '-121.850', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Livermore', 'CA', '37.690', '-121.810', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Palm Springs', 'CA', '33.830', '-116.500', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Blacksburg', 'VA', '37.230', '-80.420', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Worland', 'WY', '43.970', '-107.950', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jackson', 'WY', '43.600', '-110.730', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sheridan', 'WY', '44.770', '-106.970', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rock Springs', 'WY', '41.600', '-109.070', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Chadron', 'NE', '42.820', '-103.000', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Laramie', 'WY', '41.300', '-105.570', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sidney', 'WY', '41.130', '-102.960', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Cheyenne', 'WY', '41.150', '-104.820', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Casper', 'WY', '42.920', '-106.470', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Marshall', 'MN', '44.450', '-95.820', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Manitowoc', 'WI', '44.140', '-87.670', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sturgeon Bay', 'WI', '44.830', '-87.370', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wisconsin Rapids', 'WI', '44.360', '-89.830', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wausau', 'WI', '44.930', '-89.620', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Green Bay', 'WI', '44.480', '-88.130', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Eau Claire', 'WI', '44.870', '-91.480', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Omak', 'WA', '48.420', '-119.530', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bellingham', 'WA', '48.800', '-122.530', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Yakima', 'WA', '46.570', '-120.530', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Pasco', 'WA', '46.240', '-119.100', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('The Dalles', 'OR', '45.600', '-121.180', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('John Day', 'OR', '44.420', '-118.950', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Redmond', 'OR', '44.260', '-121.170', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Port Angeles', 'WA', '48.120', '-123.500', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Montpelier', 'VT', '44.200', '-72.570', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('St Johnsbury', 'VT', '44.420', '-72.020', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Springfield', 'VT', '43.340', '-72.520', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Saranac Lake', 'NY', '44.390', '-74.210', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Price', 'UT', '39.620', '-110.750', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Moab', 'UT', '38.770', '-109.750', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Logan', 'UT', '41.780', '-111.850', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Cedar City', 'UT', '37.700', '-113.100', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Sanderson', 'TX', '30.170', '-102.420', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Laredo', 'TX', '27.530', '-99.470', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Del Rio', 'TX', '29.370', '-100.920', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Tyler', 'TX', '32.370', '-95.400', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Paris', 'TX', '33.630', '-95.450', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Alpine', 'TX', '30.360', '-103.670', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Panther Junction', 'TX', '29.330', '-103.200', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wink', 'TX', '31.755', '-104.154', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Corpus Christi', 'TX', '27.770', '-97.500', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Altamont', 'TN', '35.420', '-85.730', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Crossville', 'TN', '35.940', '-85.030', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Gainesboro', 'TN', '36.360', '-85.650', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Waynesboro', 'TN', '35.320', '-87.750', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dover', 'TN', '36.470', '-87.840', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mobridge', 'SD', '45.540', '-100.410', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Walterboro', 'SC', '32.910', '-80.670', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Metter', 'GA', '32.400', '-82.060', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Beaufort', 'SC', '32.430', '-80.670', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Orangeburg', 'SC', '33.280', '-80.510', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Charleston', 'SC', '32.900', '-80.030', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Lumberton', 'SC', '34.630', '-79.040', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Myrtle Beach', 'SC', '33.700', '-78.890', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Providence', 'RI', '41.730', '-71.430', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bridgeport', 'CT', '41.170', '-73.130', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Reading', 'PA', '40.380', '-75.970', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Mt Pocono', 'PA', '41.140', '-75.380', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Allentown', 'PA', '40.650', '-75.430', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('State College', 'PA', '40.849', '-77.849', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Harrisburg', 'PA', '40.193', '-76.763', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Johnstown', 'PA', '40.316', '-78.833', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Williamsport', 'PA', '41.241', '-76.921', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Altoona', 'PA', '40.296', '-78.320', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bradford', 'PA', '41.803', '-78.640', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Alturas', 'CA', '41.480', '-120.570', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Yreka', 'CA', '41.740', '-122.580', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Klamath Falls', 'OR', '42.180', '-121.750', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Crater Lake', 'OR', '42.930', '-122.070', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Brookings', 'OR', '42.060', '-124.250', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Baker', 'OR', '44.830', '-117.820', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Clinton', 'OK', '35.350', '-99.200', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Maysville', 'OH', '38.687', '-83.787', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rensselaer', 'IN', '40.948', '-87.183', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Portsmouth', 'OH', '38.840', '-82.847', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bellefontaine', 'OH', '40.412', '-83.737', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Williston', 'ND', '48.180', '-103.630', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Bemidji', 'MN', '47.480', '-94.880', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Baudette', 'MN', '48.710', '-94.580', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Devil''s Lake', 'ND', '48.110', '-98.870', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Dickinson', 'ND', '46.780', '-102.800', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Jamestown', 'ND', '46.920', '-98.680', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Winston-Salem', 'NC', '36.130', '-80.230', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Wilmington', 'NC', '34.270', '-77.920', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('New Bern', 'NC', '35.080', '-77.040', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Roanoke Rapids', 'NC', '36.430', '-77.700', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Rocky Mount', 'NC', '35.850', '-77.870', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Fayetteville', 'NC', '34.980', '-78.880', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Newburgh', 'NY', '41.500', '-74.100', 4, '2009-01-05 17:22:58'); INSERT INTO `CityNames` (`city`, `state`, `lat`, `lon`, `level`, `entered`) VALUES('Southampton', 'NY', '40.887', '-72.476', 4, '2009-01-05 17:22:58');