INSERT INTO `us_zip` (`zip`, `lat`, `lng`, `city`, `state_id`, `state_name`, `zcta`, `parent_zcta`, `population`, `density`, `county_fips`, `county_name`, `all_county_weights`, `imprecise`, `military`, `timezone`) VALUES
(97423, '43.19488', '-124.17291', 'Coquille', 'OR', 'Oregon', 'TRUE', NULL, 6809, '20.7', 41011, 'Coos', '{\'41011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97424, '43.74446', '-123.05448', 'Cottage Grove', 'OR', 'Oregon', 'TRUE', NULL, 17594, '29.5', 41039, 'Lane', '{\'41019\':1.54,\'41039\':98.46}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97426, '43.89989', '-123.03670', 'Creswell', 'OR', 'Oregon', 'TRUE', NULL, 9716, '46.7', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97429, '42.96835', '-123.06351', 'Days Creek', 'OR', 'Oregon', 'TRUE', NULL, 684, '2.9', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97430, '44.17493', '-123.70523', 'Deadwood', 'OR', 'Oregon', 'TRUE', NULL, 385, '1.4', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97431, '43.87444', '-122.81868', 'Dexter', 'OR', 'Oregon', 'TRUE', NULL, 2335, '21.6', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97434, '43.66774', '-122.79332', 'Dorena', 'OR', 'Oregon', 'TRUE', NULL, 928, '3.3', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97435, '43.70037', '-123.33489', 'Drain', 'OR', 'Oregon', 'TRUE', NULL, 2349, '9.4', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97436, '43.64044', '-123.59206', 'Elkton', 'OR', 'Oregon', 'TRUE', NULL, 841, '3.3', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97437, '44.09688', '-123.38908', 'Elmira', 'OR', 'Oregon', 'TRUE', NULL, 2572, '44.8', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97438, '43.95088', '-122.68839', 'Fall Creek', 'OR', 'Oregon', 'TRUE', NULL, 1191, '4.4', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97439, '44.06609', '-124.03756', 'Florence', 'OR', 'Oregon', 'TRUE', NULL, 14343, '31.4', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97441, '43.75104', '-124.15651', 'Gardiner', 'OR', 'Oregon', 'TRUE', NULL, 260, '6.3', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97442, '42.77045', '-123.40467', 'Glendale', 'OR', 'Oregon', 'TRUE', NULL, 2232, '10.3', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97443, '43.24704', '-123.01074', 'Glide', 'OR', 'Oregon', 'TRUE', NULL, 2232, '11.4', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97444, '42.47967', '-124.34442', 'Gold Beach', 'OR', 'Oregon', 'TRUE', NULL, 5181, '12.2', 41015, 'Curry', '{\'41015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97446, '44.26785', '-123.05750', 'Harrisburg', 'OR', 'Oregon', 'TRUE', NULL, 4812, '15.3', 41043, 'Linn', '{\'41039\':0.39,\'41043\':99.61}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97447, '43.27539', '-122.51538', 'Idleyld Park', 'OR', 'Oregon', 'TRUE', NULL, 794, '2.6', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97448, '44.21054', '-123.28150', 'Junction City', 'OR', 'Oregon', 'TRUE', NULL, 12244, '33.2', 41039, 'Lane', '{\'41003\':2.12,\'41039\':97.88}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97449, '43.57609', '-124.08388', 'Lakeside', 'OR', 'Oregon', 'TRUE', NULL, 1959, '16.9', 41011, 'Coos', '{\'41011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97450, '42.90427', '-124.39744', 'Langlois', 'OR', 'Oregon', 'TRUE', NULL, 671, '3.1', 41015, 'Curry', '{\'41011\':0.89,\'41015\':99.11}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97451, '43.81519', '-123.26796', 'Lorane', 'OR', 'Oregon', 'TRUE', NULL, 387, '3.6', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97452, '43.88049', '-122.72122', 'Lowell', 'OR', 'Oregon', 'TRUE', NULL, 1420, '25.5', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97453, '43.99817', '-123.85948', 'Mapleton', 'OR', 'Oregon', 'TRUE', NULL, 897, '3.2', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97454, '44.22157', '-122.82168', 'Marcola', 'OR', 'Oregon', 'TRUE', NULL, 1337, '9.2', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97455, '43.96460', '-122.91732', 'Pleasant Hill', 'OR', 'Oregon', 'TRUE', NULL, 2538, '40.8', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97456, '44.34026', '-123.36052', 'Monroe', 'OR', 'Oregon', 'TRUE', NULL, 2985, '12.7', 41003, 'Benton', '{\'41003\':93.17,\'41039\':6.83}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97457, '43.05434', '-123.22019', 'Myrtle Creek', 'OR', 'Oregon', 'TRUE', NULL, 10208, '24.3', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97458, '43.05967', '-124.01850', 'Myrtle Point', 'OR', 'Oregon', 'TRUE', NULL, 4733, '4.8', 41011, 'Coos', '{\'41011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97459, '43.48361', '-124.17284', 'North Bend', 'OR', 'Oregon', 'TRUE', NULL, 14096, '53.3', 41011, 'Coos', '{\'41011\':99.47,\'41019\':0.53}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97461, '44.09769', '-123.48948', 'Noti', 'OR', 'Oregon', 'TRUE', NULL, 683, '6.2', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97462, '43.48633', '-123.38294', 'Oakland', 'OR', 'Oregon', 'TRUE', NULL, 3938, '7.4', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97463, '43.74773', '-122.40386', 'Oakridge', 'OR', 'Oregon', 'TRUE', NULL, 3877, '35.0', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97465, '42.75418', '-124.38224', 'Port Orford', 'OR', 'Oregon', 'TRUE', NULL, 2145, '9.0', 41015, 'Curry', '{\'41015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97466, '42.86681', '-124.07255', 'Powers', 'OR', 'Oregon', 'TRUE', NULL, 816, '7.5', 41011, 'Coos', '{\'41011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97467, '43.71022', '-123.95642', 'Reedsport', 'OR', 'Oregon', 'TRUE', NULL, 5339, '8.1', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97469, '42.92198', '-123.42469', 'Riddle', 'OR', 'Oregon', 'TRUE', NULL, 2596, '20.2', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97470, '43.22975', '-123.23433', 'Roseburg', 'OR', 'Oregon', 'TRUE', NULL, 19985, '44.6', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97471, '43.22015', '-123.47587', 'Roseburg', 'OR', 'Oregon', 'TRUE', NULL, 29100, '64.6', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97473, '43.67797', '-123.87375', 'Scottsburg', 'OR', 'Oregon', 'TRUE', NULL, 328, '2.5', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97476, '42.83551', '-124.41221', 'Sixes', 'OR', 'Oregon', 'TRUE', NULL, 217, '1.8', 41015, 'Curry', '{\'41015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97477, '44.05874', '-123.01121', 'Springfield', 'OR', 'Oregon', 'TRUE', NULL, 36874, '1141.4', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97478, '44.09093', '-122.85143', 'Springfield', 'OR', 'Oregon', 'TRUE', NULL, 37011, '87.7', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97479, '43.40239', '-123.19980', 'Sutherlin', 'OR', 'Oregon', 'TRUE', NULL, 9505, '57.7', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97480, '44.13581', '-123.83571', 'Swisshome', 'OR', 'Oregon', 'TRUE', NULL, 379, '2.1', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97481, '43.11386', '-123.55215', 'Tenmile', 'OR', 'Oregon', 'TRUE', NULL, 679, '35.4', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97484, '42.94004', '-122.85018', 'Tiller', 'OR', 'Oregon', 'TRUE', NULL, 235, '0.7', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97486, '43.38201', '-123.52857', 'Umpqua', 'OR', 'Oregon', 'TRUE', NULL, 714, '4.2', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97487, '43.98620', '-123.39092', 'Veneta', 'OR', 'Oregon', 'TRUE', NULL, 8449, '43.1', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97488, '44.12753', '-122.44518', 'Vida', 'OR', 'Oregon', 'TRUE', NULL, 1011, '3.8', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97489, '44.13709', '-122.64589', 'Walterville', 'OR', 'Oregon', 'TRUE', NULL, 868, '21.2', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97490, '44.00425', '-123.61199', 'Walton', 'OR', 'Oregon', 'TRUE', NULL, 326, '1.2', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97492, '43.72144', '-122.49534', 'Westfir', 'OR', 'Oregon', 'TRUE', NULL, 597, '10.2', 41039, 'Lane', '{\'41039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97493, '43.89788', '-124.01746', 'Westlake', 'OR', 'Oregon', 'TRUE', NULL, 323, '2.3', 41039, 'Lane', '{\'41019\':6.5,\'41039\':93.5}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97494, '43.33038', '-123.32797', 'Wilbur', 'OR', 'Oregon', 'TRUE', NULL, 49, '20.2', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97495, '43.28778', '-123.30540', 'Winchester', 'OR', 'Oregon', 'TRUE', NULL, 1450, '75.8', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97496, '43.05776', '-123.49007', 'Winston', 'OR', 'Oregon', 'TRUE', NULL, 7634, '33.8', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97497, '42.66677', '-123.39219', 'Wolf Creek', 'OR', 'Oregon', 'TRUE', NULL, 1523, '4.0', 41033, 'Josephine', '{\'41029\':0.66,\'41033\':99.34}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97498, '44.28485', '-124.02009', 'Yachats', 'OR', 'Oregon', 'TRUE', NULL, 1814, '7.1', 41041, 'Lincoln', '{\'41039\':5.46,\'41041\':94.54}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97499, '43.59278', '-123.25555', 'Yoncalla', 'OR', 'Oregon', 'TRUE', NULL, 1957, '5.7', 41019, 'Douglas', '{\'41019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97501, '42.28178', '-122.90541', 'Medford', 'OR', 'Oregon', 'TRUE', NULL, 42117, '306.2', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97502, '42.41722', '-122.95622', 'Central Point', 'OR', 'Oregon', 'TRUE', NULL, 27694, '112.9', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97503, '42.59042', '-122.92747', 'White City', 'OR', 'Oregon', 'TRUE', NULL, 10528, '48.7', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97504, '42.32693', '-122.79869', 'Medford', 'OR', 'Oregon', 'TRUE', NULL, 44444, '367.1', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97520, '42.15773', '-122.55131', 'Ashland', 'OR', 'Oregon', 'TRUE', NULL, 24469, '30.6', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97522, '42.58128', '-122.52832', 'Butte Falls', 'OR', 'Oregon', 'TRUE', NULL, 658, '2.8', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97523, '42.12095', '-123.57109', 'Cave Junction', 'OR', 'Oregon', 'TRUE', NULL, 6264, '14.3', 41033, 'Josephine', '{\'41033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97524, '42.45098', '-122.67703', 'Eagle Point', 'OR', 'Oregon', 'TRUE', NULL, 14459, '18.0', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97525, '42.44371', '-123.07480', 'Gold Hill', 'OR', 'Oregon', 'TRUE', NULL, 4601, '17.9', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97526, '42.51404', '-123.34021', 'Grants Pass', 'OR', 'Oregon', 'TRUE', NULL, 34205, '93.8', 41033, 'Josephine', '{\'41029\':0.52,\'41033\':99.48}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97527, '42.38227', '-123.40806', 'Grants Pass', 'OR', 'Oregon', 'TRUE', NULL, 33713, '54.9', 41033, 'Josephine', '{\'41029\':4.34,\'41033\':95.66}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97530, '42.15192', '-123.05757', 'Jacksonville', 'OR', 'Oregon', 'TRUE', NULL, 6916, '7.4', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97531, '42.20427', '-123.64943', 'Kerby', 'OR', 'Oregon', 'TRUE', NULL, 522, '78.8', 41033, 'Josephine', '{\'41033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97532, '42.57181', '-123.52212', 'Merlin', 'OR', 'Oregon', 'TRUE', NULL, 2378, '15.4', 41033, 'Josephine', '{\'41033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97534, '42.08424', '-123.75982', 'O Brien', 'OR', 'Oregon', 'TRUE', NULL, 756, '2.9', 41033, 'Josephine', '{\'41033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97535, '42.26775', '-122.81148', 'Phoenix', 'OR', 'Oregon', 'TRUE', NULL, 5047, '617.5', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97536, '42.78737', '-122.50562', 'Prospect', 'OR', 'Oregon', 'TRUE', NULL, 965, '5.5', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97537, '42.54648', '-123.14120', 'Rogue River', 'OR', 'Oregon', 'TRUE', NULL, 6918, '22.5', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97538, '42.27370', '-123.58169', 'Selma', 'OR', 'Oregon', 'TRUE', NULL, 2063, '5.6', 41033, 'Josephine', '{\'41033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97539, '42.60009', '-122.79042', 'Shady Cove', 'OR', 'Oregon', 'TRUE', NULL, 3329, '58.7', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97540, '42.19974', '-122.80855', 'Talent', 'OR', 'Oregon', 'TRUE', NULL, 7930, '73.3', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97541, '42.73849', '-122.75469', 'Trail', 'OR', 'Oregon', 'TRUE', NULL, 1478, '2.8', 41029, 'Jackson', '{\'41029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97543, '42.37506', '-123.56212', 'Wilderville', 'OR', 'Oregon', 'TRUE', NULL, 736, '6.3', 41033, 'Josephine', '{\'41033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97544, '42.13222', '-123.31332', 'Williams', 'OR', 'Oregon', 'TRUE', NULL, 2206, '5.2', 41033, 'Josephine', '{\'41033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97601, '42.44882', '-122.07471', 'Klamath Falls', 'OR', 'Oregon', 'TRUE', NULL, 22459, '15.6', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97603, '42.14085', '-121.68077', 'Klamath Falls', 'OR', 'Oregon', 'TRUE', NULL, 29525, '36.7', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97604, '42.94660', '-122.17721', 'Crater Lake', 'OR', 'Oregon', 'TRUE', NULL, 28, '0.1', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97620, '42.20629', '-119.78389', 'Adel', 'OR', 'Oregon', 'TRUE', NULL, 111, '0.1', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97621, '42.47655', '-121.28229', 'Beatty', 'OR', 'Oregon', 'TRUE', NULL, 320, '1.0', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97622, '42.41913', '-121.03403', 'Bly', 'OR', 'Oregon', 'TRUE', NULL, 558, '1.3', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97623, '42.18157', '-121.31967', 'Bonanza', 'OR', 'Oregon', 'TRUE', NULL, 2310, '2.4', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97624, '42.74173', '-121.70551', 'Chiloquin', 'OR', 'Oregon', 'TRUE', NULL, 3500, '3.0', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97625, '42.31487', '-121.58101', 'Dairy', 'OR', 'Oregon', 'TRUE', NULL, 199, '1.4', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97626, '42.66858', '-122.02784', 'Fort Klamath', 'OR', 'Oregon', 'TRUE', NULL, 88, '0.5', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97627, '42.12189', '-122.01889', 'Keno', 'OR', 'Oregon', 'TRUE', NULL, 780, '10.8', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97630, '42.31310', '-120.36643', 'Lakeview', 'OR', 'Oregon', 'TRUE', NULL, 5096, '2.4', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97632, '42.03210', '-121.42332', 'Malin', 'OR', 'Oregon', 'TRUE', NULL, 1466, '13.2', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97633, '42.03085', '-121.56338', 'Merrill', 'OR', 'Oregon', 'TRUE', NULL, 1361, '17.7', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97634, '42.12831', '-121.81494', 'Midland', 'OR', 'Oregon', 'TRUE', NULL, 212, '142.3', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97635, '41.93715', '-120.29869', 'New Pine Creek', 'OR', 'Oregon', 'TRUE', NULL, 289, '2.5', 6049, 'Modoc', '{\'06049\':57.09,\'41037\':42.91}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97636, '42.61087', '-120.52182', 'Paisley', 'OR', 'Oregon', 'TRUE', NULL, 387, '0.8', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97637, '42.52584', '-119.91401', 'Plush', 'OR', 'Oregon', 'TRUE', NULL, 76, '0.2', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97638, '43.13950', '-120.99836', 'Silver Lake', 'OR', 'Oregon', 'TRUE', NULL, 507, '0.4', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97639, '42.45145', '-121.43651', 'Sprague River', 'OR', 'Oregon', 'TRUE', NULL, 570, '2.7', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97640, '42.89020', '-120.67172', 'Summer Lake', 'OR', 'Oregon', 'TRUE', NULL, 99, '0.1', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97641, '43.26454', '-120.51876', 'Christmas Valley', 'OR', 'Oregon', 'TRUE', NULL, 1313, '0.8', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97701, '44.01483', '-121.33107', 'Bend', 'OR', 'Oregon', 'TRUE', NULL, 58993, '33.6', 41017, 'Deschutes', '{\'41013\':0.1,\'41017\':99.9}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97702, '43.99865', '-121.24359', 'Bend', 'OR', 'Oregon', 'TRUE', NULL, 40583, '191.2', 41017, 'Deschutes', '{\'41017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97707, '43.82581', '-121.49525', 'Bend', 'OR', 'Oregon', 'TRUE', NULL, 5814, '38.4', 41017, 'Deschutes', '{\'41017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97710, '42.18621', '-118.47568', 'Fields', 'OR', 'Oregon', 'TRUE', NULL, 120, '0.1', 41025, 'Harney', '{\'41025\':96.67,\'41045\':3.33}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97711, '44.72286', '-120.63173', 'Ashwood', 'OR', 'Oregon', 'TRUE', NULL, 61, '0.1', 41031, 'Jefferson', '{\'41031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97712, '43.78281', '-120.45307', 'Brothers', 'OR', 'Oregon', 'TRUE', NULL, 38, '0.1', 41017, 'Deschutes', '{\'41017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97720, '43.56859', '-118.84712', 'Burns', 'OR', 'Oregon', 'TRUE', NULL, 4530, '1.7', 41025, 'Harney', '{\'41025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97721, '42.90414', '-118.58292', 'Princeton', 'OR', 'Oregon', 'TRUE', NULL, 271, '0.1', 41025, 'Harney', '{\'41025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97722, '42.95083', '-118.69497', 'Diamond', 'OR', 'Oregon', 'TRUE', NULL, 91, '0.1', 41025, 'Harney', '{\'41025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97730, '44.50235', '-121.64713', 'Camp Sherman', 'OR', 'Oregon', 'TRUE', NULL, 252, '7.4', 41031, 'Jefferson', '{\'41031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97731, '43.14599', '-121.79748', 'Chemult', 'OR', 'Oregon', 'TRUE', NULL, 278, '2.2', 41035, 'Klamath', '{\'41019\':20.14,\'41035\':79.86}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97732, '43.39673', '-118.45323', 'Crane', 'OR', 'Oregon', 'TRUE', NULL, 139, '0.6', 41025, 'Harney', '{\'41025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97733, '43.37924', '-121.95668', 'Crescent', 'OR', 'Oregon', 'TRUE', NULL, 770, '0.8', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97734, '44.54036', '-121.33485', 'Culver', 'OR', 'Oregon', 'TRUE', NULL, 2786, '7.0', 41031, 'Jefferson', '{\'41031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97735, '43.41066', '-120.92597', 'Fort Rock', 'OR', 'Oregon', 'TRUE', NULL, 165, '0.2', 41037, 'Lake', '{\'41037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97736, '42.71475', '-119.00580', 'Frenchglen', 'OR', 'Oregon', 'TRUE', NULL, 73, '0.1', 41025, 'Harney', '{\'41025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97737, '43.50266', '-121.73122', 'Gilchrist', 'OR', 'Oregon', 'TRUE', NULL, 496, '7.4', 41035, 'Klamath', '{\'41035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97738, '43.52257', '-119.15177', 'Hines', 'OR', 'Oregon', 'TRUE', NULL, 1941, '10.2', 41025, 'Harney', '{\'41025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97739, '43.69960', '-121.46222', 'La Pine', 'OR', 'Oregon', 'TRUE', NULL, 11018, '20.5', 41017, 'Deschutes', '{\'41017\':86.3,\'41035\':13.7}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97741, '44.65180', '-121.05267', 'Madras', 'OR', 'Oregon', 'TRUE', NULL, 11912, '13.1', 41031, 'Jefferson', '{\'41031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97750, '44.63859', '-120.11651', 'Mitchell', 'OR', 'Oregon', 'TRUE', NULL, 386, '0.4', 41069, 'Wheeler', '{\'41069\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97751, '44.13755', '-119.87398', 'Paulina', 'OR', 'Oregon', 'TRUE', NULL, 129, '0.1', 41013, 'Crook', '{\'41013\':99.22,\'41025\':0.78}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97752, '44.13735', '-120.29784', 'Post', 'OR', 'Oregon', 'TRUE', NULL, 44, '0.1', 41013, 'Crook', '{\'41013\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97753, '44.23520', '-121.01555', 'Powell Butte', 'OR', 'Oregon', 'TRUE', NULL, 2016, '6.6', 41013, 'Crook', '{\'41013\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97754, '44.15223', '-120.57082', 'Prineville', 'OR', 'Oregon', 'TRUE', NULL, 18574, '5.9', 41013, 'Crook', '{\'41013\':99.94,\'41031\':0.06}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97756, '44.27851', '-121.21385', 'Redmond', 'OR', 'Oregon', 'TRUE', NULL, 33554, '114.5', 41017, 'Deschutes', '{\'41013\':0.11,\'41017\':99.89}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97758, '43.38844', '-119.88021', 'Riley', 'OR', 'Oregon', 'TRUE', NULL, 101, '0.1', 41025, 'Harney', '{\'41025\':83.17,\'41037\':16.83}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97759, '44.37716', '-121.78387', 'Sisters', 'OR', 'Oregon', 'TRUE', NULL, 6294, '6.3', 41017, 'Deschutes', '{\'41017\':99.3,\'41031\':0.44,\'41043\':0.25}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97760, '44.39092', '-121.23782', 'Terrebonne', 'OR', 'Oregon', 'TRUE', NULL, 6757, '27.0', 41031, 'Jefferson', '{\'41013\':1.95,\'41017\':45.72,\'41031\':52.33}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97761, '44.84165', '-121.29840', 'Warm Springs', 'OR', 'Oregon', 'TRUE', NULL, 3987, '4.1', 41031, 'Jefferson', '{\'41031\':78.58,\'41065\':21.42}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97801, '45.66820', '-118.81572', 'Pendleton', 'OR', 'Oregon', 'TRUE', NULL, 21521, '16.9', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97810, '45.71396', '-118.45812', 'Adams', 'OR', 'Oregon', 'TRUE', NULL, 815, '1.6', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97812, '45.55943', '-120.21621', 'Arlington', 'OR', 'Oregon', 'TRUE', NULL, 851, '0.7', 41021, 'Gilliam', '{\'41021\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97813, '45.85042', '-118.52813', 'Athena', 'OR', 'Oregon', 'TRUE', NULL, 1302, '9.2', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97814, '44.82653', '-117.76252', 'Baker City', 'OR', 'Oregon', 'TRUE', NULL, 12382, '6.3', 41001, 'Baker', '{\'41001\':99.41,\'41061\':0.59}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97817, '44.71379', '-118.64698', 'Bates', 'OR', 'Oregon', 'TRUE', NULL, 38, '0.1', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97818, '45.77478', '-119.87009', 'Boardman', 'OR', 'Oregon', 'TRUE', NULL, 4159, '20.3', 41049, 'Morrow', '{\'41049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97819, '44.48545', '-117.76039', 'Bridgeport', 'OR', 'Oregon', 'TRUE', NULL, 29, '0.2', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97820, '44.16877', '-119.19982', 'Canyon City', 'OR', 'Oregon', 'TRUE', NULL, 1095, '1.3', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97823, '45.24282', '-120.20568', 'Condon', 'OR', 'Oregon', 'TRUE', NULL, 948, '0.6', 41021, 'Gilliam', '{\'41021\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97824, '45.33993', '-117.75625', 'Cove', 'OR', 'Oregon', 'TRUE', NULL, 1661, '2.9', 41061, 'Union', '{\'41061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97825, '44.38530', '-119.51660', 'Dayville', 'OR', 'Oregon', 'TRUE', NULL, 244, '0.4', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97826, '45.65448', '-119.22662', 'Echo', 'OR', 'Oregon', 'TRUE', NULL, 1085, '1.3', 41059, 'Umatilla', '{\'41049\':2.95,\'41059\':97.05}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97827, '45.58792', '-117.84525', 'Elgin', 'OR', 'Oregon', 'TRUE', NULL, 2628, '4.9', 41061, 'Union', '{\'41061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97828, '45.70681', '-117.22862', 'Enterprise', 'OR', 'Oregon', 'TRUE', NULL, 3124, '1.6', 41063, 'Wallowa', '{\'41063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97830, '44.95020', '-120.18930', 'Fossil', 'OR', 'Oregon', 'TRUE', NULL, 748, '0.5', 41069, 'Wheeler', '{\'41021\':6.15,\'41069\':93.85}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97833, '44.92888', '-118.01494', 'Haines', 'OR', 'Oregon', 'TRUE', NULL, 895, '3.9', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97834, '44.96865', '-117.18919', 'Halfway', 'OR', 'Oregon', 'TRUE', NULL, 986, '1.8', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97835, '45.91001', '-118.78664', 'Helix', 'OR', 'Oregon', 'TRUE', NULL, 361, '0.7', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97836, '45.29389', '-119.50156', 'Heppner', 'OR', 'Oregon', 'TRUE', NULL, 1983, '0.8', 41049, 'Morrow', '{\'41049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97837, '44.51812', '-118.03638', 'Hereford', 'OR', 'Oregon', 'TRUE', NULL, 95, '0.3', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97838, '45.85295', '-119.28696', 'Hermiston', 'OR', 'Oregon', 'TRUE', NULL, 25346, '59.5', 41059, 'Umatilla', '{\'41049\':0.38,\'41059\':99.62}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97839, '45.59133', '-119.59276', 'Lexington', 'OR', 'Oregon', 'TRUE', NULL, 475, '0.9', 41049, 'Morrow', '{\'41049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97840, '44.90644', '-116.92710', 'Oxbow', 'OR', 'Oregon', 'TRUE', NULL, 98, '0.3', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97841, '45.46511', '-117.94489', 'Imbler', 'OR', 'Oregon', 'TRUE', NULL, 476, '9.6', 41061, 'Union', '{\'41061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97842, '45.46752', '-116.74865', 'Imnaha', 'OR', 'Oregon', 'TRUE', NULL, 153, '0.1', 41063, 'Wallowa', '{\'41063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97843, '45.50473', '-119.89787', 'Ione', 'OR', 'Oregon', 'TRUE', NULL, 647, '0.7', 41049, 'Morrow', '{\'41021\':4.02,\'41049\':95.98}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97844, '45.87422', '-119.55845', 'Irrigon', 'OR', 'Oregon', 'TRUE', NULL, 3806, '35.4', 41049, 'Morrow', '{\'41049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97845, '44.40179', '-118.90314', 'John Day', 'OR', 'Oregon', 'TRUE', NULL, 2652, '15.7', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97846, '45.46588', '-117.02962', 'Joseph', 'OR', 'Oregon', 'TRUE', NULL, 1891, '1.0', 41063, 'Wallowa', '{\'41063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97848, '44.67556', '-119.56605', 'Kimberly', 'OR', 'Oregon', 'TRUE', NULL, 195, '0.4', 41023, 'Grant', '{\'41023\':97.95,\'41069\':2.05}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97850, '45.30159', '-118.11669', 'La Grande', 'OR', 'Oregon', 'TRUE', NULL, 16955, '22.6', 41061, 'Union', '{\'41061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97856, '44.80653', '-119.12174', 'Long Creek', 'OR', 'Oregon', 'TRUE', NULL, 366, '0.3', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97857, '45.37812', '-117.50433', 'Lostine', 'OR', 'Oregon', 'TRUE', NULL, 457, '0.7', 41063, 'Wallowa', '{\'41063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97859, '45.52907', '-118.42136', 'Meacham', 'OR', 'Oregon', 'TRUE', NULL, 123, '0.6', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97862, '45.92342', '-118.31008', 'Milton Freewater', 'OR', 'Oregon', 'TRUE', NULL, 11666, '16.4', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97864, '44.84588', '-119.44529', 'Monument', 'OR', 'Oregon', 'TRUE', NULL, 262, '0.3', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97865, '44.44720', '-119.19104', 'Mount Vernon', 'OR', 'Oregon', 'TRUE', NULL, 1160, '1.2', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97867, '45.06904', '-117.99550', 'North Powder', 'OR', 'Oregon', 'TRUE', NULL, 763, '2.2', 41061, 'Union', '{\'41001\':15.47,\'41061\':84.53}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97868, '45.41176', '-118.87134', 'Pilot Rock', 'OR', 'Oregon', 'TRUE', NULL, 1991, '1.7', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97869, '44.40194', '-118.62057', 'Prairie City', 'OR', 'Oregon', 'TRUE', NULL, 1135, '1.3', 41023, 'Grant', '{\'41001\':0,\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97870, '44.78892', '-117.18786', 'Richland', 'OR', 'Oregon', 'TRUE', NULL, 573, '1.7', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97873, '44.13205', '-119.00287', 'Seneca', 'OR', 'Oregon', 'TRUE', NULL, 228, '1.2', 41023, 'Grant', '{\'41023\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97874, '44.77754', '-119.86744', 'Spray', 'OR', 'Oregon', 'TRUE', NULL, 349, '0.6', 41069, 'Wheeler', '{\'41069\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97875, '45.81938', '-119.13834', 'Stanfield', 'OR', 'Oregon', 'TRUE', NULL, 2610, '16.1', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97876, '45.51649', '-118.03553', 'Summerville', 'OR', 'Oregon', 'TRUE', NULL, 837, '5.1', 41061, 'Union', '{\'41061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97877, '44.79261', '-118.33936', 'Sumpter', 'OR', 'Oregon', 'TRUE', NULL, 283, '0.5', 41001, 'Baker', '{\'41001\':80.92,\'41023\':19.08}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97880, '45.08356', '-118.89413', 'Ukiah', 'OR', 'Oregon', 'TRUE', NULL, 272, '0.3', 41059, 'Umatilla', '{\'41023\':7.35,\'41059\':92.65}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97882, '45.89984', '-119.35524', 'Umatilla', 'OR', 'Oregon', 'TRUE', NULL, 7760, '127.2', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97883, '45.15518', '-117.61966', 'Union', 'OR', 'Oregon', 'TRUE', NULL, 2473, '3.6', 41061, 'Union', '{\'41061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97884, '44.45644', '-118.21821', 'Unity', 'OR', 'Oregon', 'TRUE', NULL, 157, '0.8', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97885, '45.65585', '-117.51176', 'Wallowa', 'OR', 'Oregon', 'TRUE', NULL, 1383, '1.8', 41063, 'Wallowa', '{\'41063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97886, '45.79871', '-118.23481', 'Weston', 'OR', 'Oregon', 'TRUE', NULL, 1140, '3.1', 41059, 'Umatilla', '{\'41059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97901, '43.62893', '-117.09006', 'Adrian', 'OR', 'Oregon', 'TRUE', NULL, 692, '2.7', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97903, '44.24869', '-117.62057', 'Brogan', 'OR', 'Oregon', 'TRUE', NULL, 109, '0.4', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97904, '43.88224', '-118.51066', 'Drewsey', 'OR', 'Oregon', 'TRUE', NULL, 176, '0.1', 41025, 'Harney', '{\'41025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97905, '44.57379', '-117.45957', 'Durkee', 'OR', 'Oregon', 'TRUE', NULL, 133, '0.2', 41001, 'Baker', '{\'41001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97906, '43.52608', '-117.77348', 'Harper', 'OR', 'Oregon', 'TRUE', NULL, 249, '0.1', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97907, '44.41020', '-117.34303', 'Huntington', 'OR', 'Oregon', 'TRUE', NULL, 560, '0.7', 41001, 'Baker', '{\'41001\':91.43,\'41045\':8.57}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(97908, '44.30927', '-117.93942', 'Ironside', 'OR', 'Oregon', 'TRUE', NULL, 56, '0.1', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97909, '44.24647', '-117.41896', 'Jamieson', 'OR', 'Oregon', 'TRUE', NULL, 51, '0.4', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97910, '42.73826', '-117.50534', 'Jordan Valley', 'OR', 'Oregon', 'TRUE', NULL, 641, '0.0', 41045, 'Malheur', '{\'16073\':10.61,\'41045\':89.39}', 'FALSE', 'FALSE', 'America/Boise'),
(97911, '43.75426', '-118.05701', 'Juntura', 'OR', 'Oregon', 'TRUE', NULL, 109, '0.1', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97913, '43.61127', '-117.32014', 'Nyssa', 'OR', 'Oregon', 'TRUE', NULL, 5531, '3.1', 41045, 'Malheur', '{\'16075\':0.07,\'41045\':99.93}', 'FALSE', 'FALSE', 'America/Boise'),
(97914, '44.11322', '-117.08407', 'Ontario', 'OR', 'Oregon', 'TRUE', NULL, 19205, '29.0', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97918, '44.04161', '-117.36115', 'Vale', 'OR', 'Oregon', 'TRUE', NULL, 4537, '4.1', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(97920, '44.07268', '-117.84645', 'Westfall', 'OR', 'Oregon', 'TRUE', NULL, 60, '0.0', 41045, 'Malheur', '{\'41045\':100}', 'FALSE', 'FALSE', 'America/Boise'),
(98001, '47.30998', '-122.26521', 'Auburn', 'WA', 'Washington', 'TRUE', NULL, 31911, '662.3', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98002, '47.30836', '-122.21639', 'Auburn', 'WA', 'Washington', 'TRUE', NULL, 31647, '1699.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98003, '47.30513', '-122.31508', 'Federal Way', 'WA', 'Washington', 'TRUE', NULL, 44151, '1465.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98004, '47.61884', '-122.20595', 'Bellevue', 'WA', 'Washington', 'TRUE', NULL, 27946, '1532.4', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98005, '47.61478', '-122.16862', 'Bellevue', 'WA', 'Washington', 'TRUE', NULL, 17714, '910.2', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98006, '47.55748', '-122.15081', 'Bellevue', 'WA', 'Washington', 'TRUE', NULL, 36364, '1311.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98007, '47.61446', '-122.14381', 'Bellevue', 'WA', 'Washington', 'TRUE', NULL, 24889, '2190.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98008, '47.60527', '-122.11098', 'Bellevue', 'WA', 'Washington', 'TRUE', NULL, 24411, '1706.5', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98010, '47.31308', '-122.00054', 'Black Diamond', 'WA', 'Washington', 'TRUE', NULL, 5025, '129.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98011, '47.75337', '-122.20191', 'Bothell', 'WA', 'Washington', 'TRUE', NULL, 29212, '1375.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98012, '47.84151', '-122.19909', 'Bothell', 'WA', 'Washington', 'TRUE', NULL, 51136, '1289.5', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98014, '47.66122', '-121.89445', 'Carnation', 'WA', 'Washington', 'TRUE', NULL, 6765, '57.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98019, '47.73961', '-121.84941', 'Duvall', 'WA', 'Washington', 'TRUE', NULL, 10725, '54.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98020, '47.80022', '-122.37266', 'Edmonds', 'WA', 'Washington', 'TRUE', NULL, 18304, '1364.5', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98021, '47.79257', '-122.20818', 'Bothell', 'WA', 'Washington', 'TRUE', NULL, 26722, '1020.6', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98022, '47.15033', '-121.65485', 'Enumclaw', 'WA', 'Washington', 'TRUE', NULL, 20987, '20.0', 53033, 'King', '{\'53033\':98.3,\'53053\':1.7}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98023, '47.30877', '-122.36270', 'Federal Way', 'WA', 'Washington', 'TRUE', NULL, 47510, '1775.4', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98024, '47.57493', '-121.90112', 'Fall City', 'WA', 'Washington', 'TRUE', NULL, 5650, '91.2', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98026, '47.83546', '-122.33172', 'Edmonds', 'WA', 'Washington', 'TRUE', NULL, 35921, '1489.9', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98027, '47.50139', '-121.99933', 'Issaquah', 'WA', 'Washington', 'TRUE', NULL, 26141, '180.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98028, '47.75423', '-122.24755', 'Kenmore', 'WA', 'Washington', 'TRUE', NULL, 20419, '1399.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98029, '47.55848', '-122.00546', 'Issaquah', 'WA', 'Washington', 'TRUE', NULL, 24348, '1050.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98030, '47.36821', '-122.19736', 'Kent', 'WA', 'Washington', 'TRUE', NULL, 33769, '1828.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98031, '47.40492', '-122.19562', 'Kent', 'WA', 'Washington', 'TRUE', NULL, 36581, '1882.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98032, '47.39234', '-122.25871', 'Kent', 'WA', 'Washington', 'TRUE', NULL, 33853, '780.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98033, '47.67613', '-122.19232', 'Kirkland', 'WA', 'Washington', 'TRUE', NULL, 34338, '1439.5', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98034, '47.71578', '-122.21582', 'Kirkland', 'WA', 'Washington', 'TRUE', NULL, 40407, '1722.4', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98036, '47.81113', '-122.28162', 'Lynnwood', 'WA', 'Washington', 'TRUE', NULL, 36000, '1437.2', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98037, '47.83922', '-122.28541', 'Lynnwood', 'WA', 'Washington', 'TRUE', NULL, 26889, '1802.7', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98038, '47.41741', '-121.95374', 'Maple Valley', 'WA', 'Washington', 'TRUE', NULL, 31171, '181.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98039, '47.63306', '-122.23962', 'Medina', 'WA', 'Washington', 'TRUE', NULL, 2971, '795.3', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98040, '47.56612', '-122.23198', 'Mercer Island', 'WA', 'Washington', 'TRUE', NULL, 22699, '1373.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98042, '47.36624', '-122.11716', 'Kent', 'WA', 'Washington', 'TRUE', NULL, 43673, '592.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98043, '47.79200', '-122.30742', 'Mountlake Terrace', 'WA', 'Washington', 'TRUE', NULL, 19943, '1882.8', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98045, '47.39159', '-121.63471', 'North Bend', 'WA', 'Washington', 'TRUE', NULL, 13888, '15.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98047, '47.26208', '-122.24756', 'Pacific', 'WA', 'Washington', 'TRUE', NULL, 6339, '1013.5', 53033, 'King', '{\'53033\':98.34,\'53053\':1.66}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98050, '47.54399', '-121.94041', 'Preston', 'WA', 'Washington', 'TRUE', NULL, 322, '37.6', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98051, '47.34073', '-121.88743', 'Ravensdale', 'WA', 'Washington', 'TRUE', NULL, 3270, '24.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98052, '47.68131', '-122.12031', 'Redmond', 'WA', 'Washington', 'TRUE', NULL, 58442, '1121.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98053, '47.66565', '-122.01947', 'Redmond', 'WA', 'Washington', 'TRUE', NULL, 18784, '255.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98055, '47.44696', '-122.20142', 'Renton', 'WA', 'Washington', 'TRUE', NULL, 21904, '1765.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98056, '47.51287', '-122.18958', 'Renton', 'WA', 'Washington', 'TRUE', NULL, 32489, '1665.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98057, '47.47142', '-122.22032', 'Renton', 'WA', 'Washington', 'TRUE', NULL, 10613, '671.5', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98058, '47.44184', '-122.12440', 'Renton', 'WA', 'Washington', 'TRUE', NULL, 41938, '854.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98059, '47.50222', '-122.12100', 'Renton', 'WA', 'Washington', 'TRUE', NULL, 34463, '666.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98065, '47.58460', '-121.79163', 'Snoqualmie', 'WA', 'Washington', 'TRUE', NULL, 12699, '66.2', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98068, '47.44077', '-121.34972', 'Snoqualmie Pass', 'WA', 'Washington', 'TRUE', NULL, 403, '0.6', 53037, 'Kittitas', '{\'53033\':19.6,\'53037\':80.4}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98070, '47.41219', '-122.47260', 'Vashon', 'WA', 'Washington', 'TRUE', NULL, 10624, '111.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98072, '47.76117', '-122.13214', 'Woodinville', 'WA', 'Washington', 'TRUE', NULL, 22312, '475.2', 53033, 'King', '{\'53033\':86.67,\'53061\':13.33}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98074, '47.62268', '-122.04325', 'Sammamish', 'WA', 'Washington', 'TRUE', NULL, 25748, '931.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98075, '47.58655', '-122.03848', 'Sammamish', 'WA', 'Washington', 'TRUE', NULL, 20715, '843.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98077, '47.75292', '-122.05826', 'Woodinville', 'WA', 'Washington', 'TRUE', NULL, 13585, '302.7', 53033, 'King', '{\'53033\':93.18,\'53061\':6.82}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98087, '47.86298', '-122.26638', 'Lynnwood', 'WA', 'Washington', 'TRUE', NULL, 29976, '2078.9', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98092, '47.28765', '-122.12877', 'Auburn', 'WA', 'Washington', 'TRUE', NULL, 39816, '345.6', 53033, 'King', '{\'53033\':82.57,\'53053\':17.43}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98101, '47.61129', '-122.33454', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 10238, '7613.3', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98102, '47.63632', '-122.32213', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 20756, '6228.4', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98103, '47.67332', '-122.34254', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 45911, '3815.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98104, '47.60169', '-122.32849', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 13095, '6533.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98105, '47.66068', '-122.28403', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 43924, '4108.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98106, '47.54349', '-122.35434', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 22873, '1603.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98107, '47.66764', '-122.37800', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 21147, '3716.4', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98108, '47.54126', '-122.31295', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 22374, '1153.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98109, '47.63159', '-122.34417', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 20715, '4011.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98110, '47.64469', '-122.54353', 'Bainbridge Island', 'WA', 'Washington', 'TRUE', NULL, 23025, '321.9', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98112, '47.63394', '-122.28885', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 21077, '2575.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98115, '47.68500', '-122.28216', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 46206, '2708.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98116, '47.57397', '-122.39507', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 22241, '2903.3', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98117, '47.68820', '-122.38148', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 31365, '3142.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98118, '47.54249', '-122.26883', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 42731, '2639.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98119, '47.63995', '-122.37005', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 21039, '3332.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98121, '47.61541', '-122.34669', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 12628, '10981.3', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98122, '47.61151', '-122.29180', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 31454, '5250.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98125, '47.71636', '-122.29815', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 37081, '2653.4', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98126, '47.54768', '-122.37442', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 20698, '2610.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98133, '47.73995', '-122.34421', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 44555, '2424.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98134, '47.57783', '-122.33743', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 644, '73.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98136, '47.53676', '-122.38986', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 14770, '2480.6', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98144, '47.58596', '-122.29237', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 26881, '3053.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98146, '47.50009', '-122.35752', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 25922, '2148.4', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98148, '47.44374', '-122.32507', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 10010, '1254.8', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98154, '47.60641', '-122.33372', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 0, '0.0', 53033, 'King', '{\'53033\':0}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98155, '47.75593', '-122.30025', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 32778, '1675.2', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98158, '47.45013', '-122.30790', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 0, '0.0', 53033, 'King', '{\'53033\':0}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98164, '47.60596', '-122.33203', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 141, '15384.6', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98166, '47.45281', '-122.35010', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 20301, '1386.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98168, '47.48887', '-122.30123', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 33734, '1464.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98174, '47.60457', '-122.33536', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 0, '0.0', 53033, 'King', '{\'53033\':0}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98177, '47.74226', '-122.37079', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 19030, '1296.9', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98178, '47.49930', '-122.24708', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 24092, '1919.5', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98188, '47.44823', '-122.27314', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 23111, '1185.0', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98195, '47.64925', '-122.30919', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 0, '0.0', 53033, 'King', '{\'53033\':0}', 'FALSE', 'FALSE', 'America/Los_Angeles');
INSERT INTO `us_zip` (`zip`, `lat`, `lng`, `city`, `state_id`, `state_name`, `zcta`, `parent_zcta`, `population`, `density`, `county_fips`, `county_name`, `all_county_weights`, `imprecise`, `military`, `timezone`) VALUES
(98198, '47.39462', '-122.31121', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 34584, '1732.1', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98199, '47.65142', '-122.40270', 'Seattle', 'WA', 'Washington', 'TRUE', NULL, 19686, '1814.7', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98201, '47.99334', '-122.21327', 'Everett', 'WA', 'Washington', 'TRUE', NULL, 29582, '1527.9', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98203, '47.94354', '-122.23321', 'Everett', 'WA', 'Washington', 'TRUE', NULL, 34354, '1239.2', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98204, '47.90132', '-122.26091', 'Everett', 'WA', 'Washington', 'TRUE', NULL, 39380, '1893.9', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98207, '47.98805', '-122.22294', 'Everett', 'WA', 'Washington', 'TRUE', NULL, 758, '1338.3', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98208, '47.90179', '-122.18651', 'Everett', 'WA', 'Washington', 'TRUE', NULL, 51802, '1235.7', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98220, '48.68497', '-122.19692', 'Acme', 'WA', 'Washington', 'TRUE', NULL, 634, '12.0', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98221, '48.50321', '-122.65492', 'Anacortes', 'WA', 'Washington', 'TRUE', NULL, 20429, '148.6', 53057, 'Skagit', '{\'53055\':0.47,\'53057\':99.53}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98222, '48.56085', '-122.80263', 'Blakely Island', 'WA', 'Washington', 'TRUE', NULL, 33, '1.9', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98223, '48.21049', '-121.95174', 'Arlington', 'WA', 'Washington', 'TRUE', NULL, 40815, '49.3', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98224, '47.66382', '-121.51300', 'Baring', 'WA', 'Washington', 'TRUE', NULL, 294, '0.6', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98225, '48.75309', '-122.50149', 'Bellingham', 'WA', 'Washington', 'TRUE', NULL, 46172, '1410.9', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98226, '48.80060', '-122.42745', 'Bellingham', 'WA', 'Washington', 'TRUE', NULL, 41235, '148.4', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98229, '48.69551', '-122.41048', 'Bellingham', 'WA', 'Washington', 'TRUE', NULL, 30321, '238.6', 53073, 'Whatcom', '{\'53057\':0.99,\'53073\':99.01}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98230, '48.95409', '-122.71063', 'Blaine', 'WA', 'Washington', 'TRUE', NULL, 15710, '138.8', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98232, '48.56535', '-122.41566', 'Bow', 'WA', 'Washington', 'TRUE', NULL, 3920, '28.3', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98233, '48.50395', '-122.35082', 'Burlington', 'WA', 'Washington', 'TRUE', NULL, 14871, '169.5', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98235, '48.46475', '-122.23332', 'Clearlake', 'WA', 'Washington', 'TRUE', NULL, 103, '1297.1', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98236, '47.95814', '-122.40474', 'Clinton', 'WA', 'Washington', 'TRUE', NULL, 5635, '95.1', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98237, '48.59328', '-121.68519', 'Concrete', 'WA', 'Washington', 'TRUE', NULL, 4025, '4.9', 53057, 'Skagit', '{\'53057\':99.98,\'53073\':0.02}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98238, '48.33518', '-122.34461', 'Conway', 'WA', 'Washington', 'TRUE', NULL, 85, '150.9', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98239, '48.19161', '-122.66085', 'Coupeville', 'WA', 'Washington', 'TRUE', NULL, 6646, '87.7', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98240, '48.94729', '-122.62131', 'Custer', 'WA', 'Washington', 'TRUE', NULL, 3061, '57.1', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98241, '48.22367', '-121.32776', 'Darrington', 'WA', 'Washington', 'TRUE', NULL, 2129, '2.0', 53061, 'Snohomish', '{\'53057\':14.94,\'53061\':85.06}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98243, '48.62096', '-123.00504', 'Deer Harbor', 'WA', 'Washington', 'TRUE', NULL, 507, '38.1', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98244, '48.80006', '-121.95440', 'Deming', 'WA', 'Washington', 'TRUE', NULL, 3001, '2.4', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98245, '48.66637', '-122.91024', 'Eastsound', 'WA', 'Washington', 'TRUE', NULL, 3651, '44.1', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98247, '48.90799', '-122.32248', 'Everson', 'WA', 'Washington', 'TRUE', NULL, 9072, '55.0', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98248, '48.86590', '-122.62000', 'Ferndale', 'WA', 'Washington', 'TRUE', NULL, 22361, '121.9', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98249, '48.01818', '-122.53910', 'Freeland', 'WA', 'Washington', 'TRUE', NULL, 4561, '110.5', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98250, '48.55815', '-123.09150', 'Friday Harbor', 'WA', 'Washington', 'TRUE', NULL, 7664, '47.6', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98251, '47.90265', '-121.54531', 'Gold Bar', 'WA', 'Washington', 'TRUE', NULL, 4567, '11.6', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98252, '48.07307', '-121.68950', 'Granite Falls', 'WA', 'Washington', 'TRUE', NULL, 8777, '12.7', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98253, '48.08535', '-122.57687', 'Greenbank', 'WA', 'Washington', 'TRUE', NULL, 1837, '57.2', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98255, '48.52207', '-121.98930', 'Hamilton', 'WA', 'Washington', 'TRUE', NULL, 245, '183.5', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98256, '47.82999', '-121.43037', 'Index', 'WA', 'Washington', 'TRUE', NULL, 420, '1.9', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98257, '48.41605', '-122.50950', 'La Conner', 'WA', 'Washington', 'TRUE', NULL, 4134, '87.0', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98258, '48.04240', '-122.06897', 'Lake Stevens', 'WA', 'Washington', 'TRUE', NULL, 30524, '408.4', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98260, '48.03069', '-122.45086', 'Langley', 'WA', 'Washington', 'TRUE', NULL, 5278, '77.1', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98261, '48.48381', '-122.88303', 'Lopez Island', 'WA', 'Washington', 'TRUE', NULL, 2383, '30.9', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98262, '48.69276', '-122.66380', 'Lummi Island', 'WA', 'Washington', 'TRUE', NULL, 964, '40.3', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98263, '48.52191', '-122.06700', 'Lyman', 'WA', 'Washington', 'TRUE', NULL, 76, '180.5', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98264, '48.95015', '-122.46035', 'Lynden', 'WA', 'Washington', 'TRUE', NULL, 18893, '127.9', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98266, '48.95329', '-122.12835', 'Maple Falls', 'WA', 'Washington', 'TRUE', NULL, 3642, '58.7', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98267, '48.44343', '-121.31629', 'Marblemount', 'WA', 'Washington', 'TRUE', NULL, 534, '0.6', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98270, '48.05957', '-122.14452', 'Marysville', 'WA', 'Washington', 'TRUE', NULL, 45899, '1238.2', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98271, '48.09415', '-122.23446', 'Marysville', 'WA', 'Washington', 'TRUE', NULL, 27184, '225.3', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98272, '47.84930', '-121.88519', 'Monroe', 'WA', 'Washington', 'TRUE', NULL, 27942, '98.8', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98273, '48.40394', '-122.36933', 'Mount Vernon', 'WA', 'Washington', 'TRUE', NULL, 28717, '131.8', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98274, '48.35936', '-122.14553', 'Mount Vernon', 'WA', 'Washington', 'TRUE', NULL, 16613, '45.4', 53057, 'Skagit', '{\'53057\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98275, '47.91321', '-122.29926', 'Mukilteo', 'WA', 'Washington', 'TRUE', NULL, 20256, '1031.1', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98276, '48.92702', '-122.32606', 'Nooksack', 'WA', 'Washington', 'TRUE', NULL, 450, '851.1', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98277, '48.31625', '-122.63161', 'Oak Harbor', 'WA', 'Washington', 'TRUE', NULL, 37823, '258.6', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98278, '48.34131', '-122.66288', 'Oak Harbor', 'WA', 'Washington', 'TRUE', NULL, 1065, '78.1', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98279, '48.64471', '-122.80830', 'Olga', 'WA', 'Washington', 'TRUE', NULL, 608, '16.7', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98280, '48.60693', '-122.90961', 'Orcas', 'WA', 'Washington', 'TRUE', NULL, 480, '26.0', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98281, '48.98817', '-123.05767', 'Point Roberts', 'WA', 'Washington', 'TRUE', NULL, 1314, '103.9', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98282, '48.18657', '-122.47075', 'Camano Island', 'WA', 'Washington', 'TRUE', NULL, 15661, '152.1', 53029, 'Island', '{\'53029\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98283, '48.80272', '-121.25819', 'Rockport', 'WA', 'Washington', 'TRUE', NULL, 434, '0.3', 53057, 'Skagit', '{\'53057\':81.8,\'53073\':18.2}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98284, '48.55308', '-122.12046', 'Sedro Woolley', 'WA', 'Washington', 'TRUE', NULL, 24331, '33.3', 53057, 'Skagit', '{\'53057\':91.29,\'53073\':8.71}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98286, '48.57262', '-122.95712', 'Shaw Island', 'WA', 'Washington', 'TRUE', NULL, 240, '12.0', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98288, '47.66600', '-121.27534', 'Skykomish', 'WA', 'Washington', 'TRUE', NULL, 333, '0.6', 53033, 'King', '{\'53033\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98290, '47.95101', '-121.98023', 'Snohomish', 'WA', 'Washington', 'TRUE', NULL, 32714, '106.6', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98292, '48.22340', '-122.30731', 'Stanwood', 'WA', 'Washington', 'TRUE', NULL, 20987, '108.7', 53061, 'Snohomish', '{\'53057\':0.3,\'53061\':99.7}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98294, '47.87618', '-121.74479', 'Sultan', 'WA', 'Washington', 'TRUE', NULL, 6595, '42.6', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98295, '48.97181', '-122.22851', 'Sumas', 'WA', 'Washington', 'TRUE', NULL, 2409, '32.2', 53073, 'Whatcom', '{\'53073\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98296, '47.84066', '-122.10166', 'Snohomish', 'WA', 'Washington', 'TRUE', NULL, 27956, '317.0', 53061, 'Snohomish', '{\'53061\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98297, '48.70050', '-123.02834', 'Waldron', 'WA', 'Washington', 'TRUE', NULL, 106, '9.1', 53055, 'San Juan', '{\'53055\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98303, '47.15783', '-122.70387', 'Anderson Island', 'WA', 'Washington', 'TRUE', NULL, 1037, '51.5', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98304, '46.86799', '-121.75176', 'Ashford', 'WA', 'Washington', 'TRUE', NULL, 759, '0.9', 53053, 'Pierce', '{\'53041\':24.37,\'53053\':75.63}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98305, '48.06030', '-124.43012', 'Beaver', 'WA', 'Washington', 'TRUE', NULL, 358, '1.2', 53009, 'Clallam', '{\'53009\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98310, '47.59269', '-122.62300', 'Bremerton', 'WA', 'Washington', 'TRUE', NULL, 18703, '1211.5', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98311, '47.63019', '-122.63698', 'Bremerton', 'WA', 'Washington', 'TRUE', NULL, 25880, '920.6', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98312, '47.57326', '-122.76008', 'Bremerton', 'WA', 'Washington', 'TRUE', NULL, 30203, '189.6', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98314, '47.55594', '-122.63870', 'Bremerton', 'WA', 'Washington', 'TRUE', NULL, 3329, '2183.7', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98315, '47.72289', '-122.71459', 'Silverdale', 'WA', 'Washington', 'TRUE', NULL, 6054, '210.5', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98320, '47.72074', '-122.99144', 'Brinnon', 'WA', 'Washington', 'TRUE', NULL, 1250, '4.9', 53031, 'Jefferson', '{\'53031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98321, '47.15286', '-122.06432', 'Buckley', 'WA', 'Washington', 'TRUE', NULL, 15152, '162.9', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98323, '47.04062', '-121.88815', 'Carbonado', 'WA', 'Washington', 'TRUE', NULL, 702, '1.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98325, '47.96585', '-122.77841', 'Chimacum', 'WA', 'Washington', 'TRUE', NULL, 1848, '23.7', 53031, 'Jefferson', '{\'53031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98326, '48.16779', '-124.38897', 'Clallam Bay', 'WA', 'Washington', 'TRUE', NULL, 1412, '1.9', 53009, 'Clallam', '{\'53009\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98327, '47.10125', '-122.66073', 'Dupont', 'WA', 'Washington', 'TRUE', NULL, 8267, '466.2', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98328, '46.86580', '-122.17374', 'Eatonville', 'WA', 'Washington', 'TRUE', NULL, 10433, '19.0', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98329, '47.37783', '-122.72547', 'Gig Harbor', 'WA', 'Washington', 'TRUE', NULL, 10545, '158.1', 53053, 'Pierce', '{\'53035\':1.36,\'53053\':98.64}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98330, '46.77244', '-122.16878', 'Elbe', 'WA', 'Washington', 'TRUE', NULL, 149, '8.8', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98331, '47.78438', '-124.18511', 'Forks', 'WA', 'Washington', 'TRUE', NULL, 6261, '3.1', 53009, 'Clallam', '{\'53009\':85.93,\'53031\':14.07}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98332, '47.36500', '-122.59887', 'Gig Harbor', 'WA', 'Washington', 'TRUE', NULL, 15855, '294.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98333, '47.24771', '-122.62561', 'Fox Island', 'WA', 'Washington', 'TRUE', NULL, 3633, '270.4', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98335, '47.29895', '-122.61892', 'Gig Harbor', 'WA', 'Washington', 'TRUE', NULL, 24925, '436.3', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98336, '46.56449', '-122.11248', 'Glenoma', 'WA', 'Washington', 'TRUE', NULL, 970, '5.4', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98337, '47.56862', '-122.63090', 'Bremerton', 'WA', 'Washington', 'TRUE', NULL, 6697, '2491.4', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98338, '47.02052', '-122.28324', 'Graham', 'WA', 'Washington', 'TRUE', NULL, 24098, '173.0', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98339, '48.01877', '-122.74952', 'Port Hadlock', 'WA', 'Washington', 'TRUE', NULL, 3326, '223.2', 53031, 'Jefferson', '{\'53031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98340, '47.90230', '-122.56348', 'Hansville', 'WA', 'Washington', 'TRUE', NULL, 2537, '112.7', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98342, '47.75387', '-122.51789', 'Indianola', 'WA', 'Washington', 'TRUE', NULL, 1370, '220.5', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98345, '47.69921', '-122.62351', 'Keyport', 'WA', 'Washington', 'TRUE', NULL, 554, '423.7', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98346, '47.81850', '-122.53234', 'Kingston', 'WA', 'Washington', 'TRUE', NULL, 9297, '130.3', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98349, '47.26623', '-122.77273', 'Lakebay', 'WA', 'Washington', 'TRUE', NULL, 4614, '83.7', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98350, '47.90531', '-124.61396', 'La Push', 'WA', 'Washington', 'TRUE', NULL, 460, '56.1', 53009, 'Clallam', '{\'53009\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98351, '47.20301', '-122.76869', 'Longbranch', 'WA', 'Washington', 'TRUE', NULL, 1115, '50.4', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98353, '47.53885', '-122.49294', 'Manchester', 'WA', 'Washington', 'TRUE', NULL, 4, '1.9', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98354, '47.25027', '-122.31469', 'Milton', 'WA', 'Washington', 'TRUE', NULL, 6976, '1122.8', 53053, 'Pierce', '{\'53033\':11.84,\'53053\':88.16}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98355, '46.68689', '-122.05558', 'Mineral', 'WA', 'Washington', 'TRUE', NULL, 628, '1.3', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98356, '46.56342', '-122.29219', 'Morton', 'WA', 'Washington', 'TRUE', NULL, 2149, '8.3', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98357, '48.33199', '-124.62847', 'Neah Bay', 'WA', 'Washington', 'TRUE', NULL, 1414, '12.9', 53009, 'Clallam', '{\'53009\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98358, '48.05569', '-122.70762', 'Nordland', 'WA', 'Washington', 'TRUE', NULL, 897, '32.4', 53031, 'Jefferson', '{\'53031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98359, '47.43045', '-122.57661', 'Olalla', 'WA', 'Washington', 'TRUE', NULL, 4887, '135.0', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98360, '47.03026', '-122.15928', 'Orting', 'WA', 'Washington', 'TRUE', NULL, 12221, '67.9', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98361, '46.58875', '-121.59128', 'Packwood', 'WA', 'Washington', 'TRUE', NULL, 1158, '1.0', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98362, '47.98420', '-123.36164', 'Port Angeles', 'WA', 'Washington', 'TRUE', NULL, 22230, '39.2', 53009, 'Clallam', '{\'53009\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98363, '48.01057', '-123.87551', 'Port Angeles', 'WA', 'Washington', 'TRUE', NULL, 13343, '8.1', 53009, 'Clallam', '{\'53009\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98364, '47.84697', '-122.58839', 'Port Gamble', 'WA', 'Washington', 'TRUE', NULL, 45, '57.4', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98365, '47.89514', '-122.70283', 'Port Ludlow', 'WA', 'Washington', 'TRUE', NULL, 4528, '47.1', 53031, 'Jefferson', '{\'53031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98366, '47.53715', '-122.58652', 'Port Orchard', 'WA', 'Washington', 'TRUE', NULL, 34258, '571.0', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98367, '47.46508', '-122.68313', 'Port Orchard', 'WA', 'Washington', 'TRUE', NULL, 27693, '132.7', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98368, '48.04272', '-122.84534', 'Port Townsend', 'WA', 'Washington', 'TRUE', NULL, 14724, '107.0', 53031, 'Jefferson', '{\'53031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98370, '47.75101', '-122.62291', 'Poulsbo', 'WA', 'Washington', 'TRUE', NULL, 29528, '201.4', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98371, '47.19955', '-122.32218', 'Puyallup', 'WA', 'Washington', 'TRUE', NULL, 20468, '685.7', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98372, '47.20602', '-122.26691', 'Puyallup', 'WA', 'Washington', 'TRUE', NULL, 22475, '636.4', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98373, '47.14760', '-122.32519', 'Puyallup', 'WA', 'Washington', 'TRUE', NULL, 22246, '913.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98374, '47.12996', '-122.26195', 'Puyallup', 'WA', 'Washington', 'TRUE', NULL, 37360, '909.6', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98375, '47.10367', '-122.32344', 'Puyallup', 'WA', 'Washington', 'TRUE', NULL, 26863, '1067.3', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98376, '47.85120', '-122.86207', 'Quilcene', 'WA', 'Washington', 'TRUE', NULL, 1998, '6.6', 53031, 'Jefferson', '{\'53031\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98377, '46.52518', '-121.89480', 'Randle', 'WA', 'Washington', 'TRUE', NULL, 1922, '3.5', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98380, '47.57555', '-122.90221', 'Seabeck', 'WA', 'Washington', 'TRUE', NULL, 4173, '38.4', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98381, '48.27373', '-124.47476', 'Sekiu', 'WA', 'Washington', 'TRUE', NULL, 371, '2.1', 53009, 'Clallam', '{\'53009\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98382, '48.02748', '-123.07862', 'Sequim', 'WA', 'Washington', 'TRUE', NULL, 26856, '60.4', 53009, 'Clallam', '{\'53009\':98.44,\'53031\':1.56}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98383, '47.66207', '-122.71793', 'Silverdale', 'WA', 'Washington', 'TRUE', NULL, 19727, '423.8', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98385, '47.13752', '-122.09189', 'South Prairie', 'WA', 'Washington', 'TRUE', NULL, 459, '374.6', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98387, '47.05699', '-122.39543', 'Spanaway', 'WA', 'Washington', 'TRUE', NULL, 43173, '587.5', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98388, '47.19890', '-122.66267', 'Steilacoom', 'WA', 'Washington', 'TRUE', NULL, 7508, '327.9', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98390, '47.20995', '-122.22800', 'Sumner', 'WA', 'Washington', 'TRUE', NULL, 10461, '416.9', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98391, '47.17717', '-122.17228', 'Bonney Lake', 'WA', 'Washington', 'TRUE', NULL, 44309, '444.0', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98392, '47.73296', '-122.56290', 'Suquamish', 'WA', 'Washington', 'TRUE', NULL, 2994, '703.6', 53035, 'Kitsap', '{\'53035\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98394, '47.31910', '-122.77666', 'Vaughn', 'WA', 'Washington', 'TRUE', NULL, 1107, '77.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98396, '47.09851', '-122.00985', 'Wilkeson', 'WA', 'Washington', 'TRUE', NULL, 662, '18.6', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98402, '47.24859', '-122.43869', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 6356, '2606.3', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98403, '47.26595', '-122.45850', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 7713, '2713.6', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98404, '47.20975', '-122.41008', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 32086, '1628.9', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98405, '47.24581', '-122.47200', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 22851, '2136.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98406, '47.26211', '-122.50901', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 21610, '1954.7', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98407, '47.28861', '-122.51131', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 19885, '1368.6', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98408, '47.19802', '-122.44646', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 18830, '2150.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98409, '47.21115', '-122.48203', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 22989, '1249.2', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98416, '47.26253', '-122.48119', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 1014, '3758.2', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98418, '47.22323', '-122.44647', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 10069, '2309.6', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98421, '47.25919', '-122.39953', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 1308, '75.5', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98422, '47.28962', '-122.39176', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 20151, '1167.6', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98424, '47.23427', '-122.35189', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 10140, '620.8', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98430, '47.11732', '-122.56915', 'Camp Murray', 'WA', 'Washington', 'TRUE', NULL, 13, '13.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98433, '47.11130', '-122.58723', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 14584, '286.1', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98438, '47.13163', '-122.49706', 'Mcchord Afb', 'WA', 'Washington', 'TRUE', NULL, 366, '167.3', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98439, '47.12392', '-122.50163', 'Lakewood', 'WA', 'Washington', 'TRUE', NULL, 4839, '214.0', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98443, '47.20462', '-122.37412', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 5371, '405.9', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98444, '47.15286', '-122.44896', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 33956, '1949.8', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98445, '47.13981', '-122.40989', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 29661, '1097.5', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98446, '47.12970', '-122.37423', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 10173, '357.4', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98447, '47.14432', '-122.44353', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 842, '5622.7', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98465, '47.24823', '-122.52908', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 6340, '1472.5', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98466, '47.22779', '-122.53573', 'Tacoma', 'WA', 'Washington', 'TRUE', NULL, 26944, '1756.7', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98467, '47.20409', '-122.54635', 'University Place', 'WA', 'Washington', 'TRUE', NULL, 14728, '1248.4', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98498, '47.16232', '-122.55456', 'Lakewood', 'WA', 'Washington', 'TRUE', NULL, 27546, '1261.8', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98499, '47.16670', '-122.50703', 'Lakewood', 'WA', 'Washington', 'TRUE', NULL, 29750, '1243.8', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98501, '46.97901', '-122.87089', 'Olympia', 'WA', 'Washington', 'TRUE', NULL, 38133, '427.5', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98502, '47.09052', '-123.01238', 'Olympia', 'WA', 'Washington', 'TRUE', NULL, 30491, '216.5', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98503, '47.02578', '-122.79819', 'Lacey', 'WA', 'Washington', 'TRUE', NULL, 36611, '1251.8', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98506, '47.10283', '-122.87324', 'Olympia', 'WA', 'Washington', 'TRUE', NULL, 18199, '314.0', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98512, '46.95652', '-123.04843', 'Olympia', 'WA', 'Washington', 'TRUE', NULL, 28130, '72.1', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98513, '46.98331', '-122.73478', 'Olympia', 'WA', 'Washington', 'TRUE', NULL, 31975, '209.0', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98516, '47.09657', '-122.78360', 'Olympia', 'WA', 'Washington', 'TRUE', NULL, 20166, '271.8', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98520, '47.04348', '-123.80637', 'Aberdeen', 'WA', 'Washington', 'TRUE', NULL, 23814, '38.5', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98524, '47.35771', '-122.86367', 'Allyn', 'WA', 'Washington', 'TRUE', NULL, 3232, '87.3', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98526, '47.46144', '-123.97576', 'Amanda Park', 'WA', 'Washington', 'TRUE', NULL, 398, '1.8', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98527, '46.58623', '-123.89756', 'Bay Center', 'WA', 'Washington', 'TRUE', NULL, 324, '12.5', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98528, '47.44215', '-122.89180', 'Belfair', 'WA', 'Washington', 'TRUE', NULL, 9983, '52.8', 53045, 'Mason', '{\'53035\':0.32,\'53045\':99.68}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98530, '46.78803', '-122.82344', 'Bucoda', 'WA', 'Washington', 'TRUE', NULL, 565, '43.8', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98531, '46.73497', '-122.92104', 'Centralia', 'WA', 'Washington', 'TRUE', NULL, 24121, '68.1', 53041, 'Lewis', '{\'53041\':91.79,\'53067\':8.21}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98532, '46.63121', '-123.04085', 'Chehalis', 'WA', 'Washington', 'TRUE', NULL, 23596, '28.2', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98533, '46.67120', '-122.43414', 'Cinebar', 'WA', 'Washington', 'TRUE', NULL, 609, '2.0', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98535, '47.10660', '-124.13390', 'Copalis Beach', 'WA', 'Washington', 'TRUE', NULL, 445, '16.8', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98536, '47.20063', '-124.09948', 'Copalis Crossing', 'WA', 'Washington', 'TRUE', NULL, 211, '1.3', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98537, '46.83010', '-123.60263', 'Cosmopolis', 'WA', 'Washington', 'TRUE', NULL, 2129, '4.2', 53027, 'Grays Harbor', '{\'53027\':96.15,\'53049\':3.85}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98538, '46.47751', '-123.15264', 'Curtis', 'WA', 'Washington', 'TRUE', NULL, 304, '1.1', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98541, '47.06043', '-123.39134', 'Elma', 'WA', 'Washington', 'TRUE', NULL, 10101, '18.4', 53027, 'Grays Harbor', '{\'53027\':86.28,\'53045\':13.72}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98542, '46.52460', '-122.71865', 'Ethel', 'WA', 'Washington', 'TRUE', NULL, 656, '18.6', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98544, '46.73890', '-123.02693', 'Galvin', 'WA', 'Washington', 'TRUE', NULL, 73, '280.5', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98546, '47.31681', '-122.93543', 'Grapeview', 'WA', 'Washington', 'TRUE', NULL, 2909, '42.4', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98547, '46.78634', '-124.01991', 'Grayland', 'WA', 'Washington', 'TRUE', NULL, 1436, '9.1', 53027, 'Grays Harbor', '{\'53027\':61,\'53049\':39}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98548, '47.43004', '-123.33219', 'Hoodsport', 'WA', 'Washington', 'TRUE', NULL, 2193, '6.2', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98550, '47.10384', '-123.93670', 'Hoquiam', 'WA', 'Washington', 'TRUE', NULL, 11382, '20.5', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98552, '47.30462', '-123.91934', 'Humptulips', 'WA', 'Washington', 'TRUE', NULL, 508, '2.1', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98555, '47.53578', '-123.06229', 'Lilliwaup', 'WA', 'Washington', 'TRUE', NULL, 599, '11.3', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98557, '47.04403', '-123.26785', 'Mccleary', 'WA', 'Washington', 'TRUE', NULL, 3225, '34.6', 53027, 'Grays Harbor', '{\'53027\':98.02,\'53045\':1.98}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98558, '46.93391', '-122.55628', 'Mckenna', 'WA', 'Washington', 'TRUE', NULL, 192, '586.5', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98559, '46.95880', '-123.32716', 'Malone', 'WA', 'Washington', 'TRUE', NULL, 93, '2289.2', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98560, '47.30752', '-123.41887', 'Matlock', 'WA', 'Washington', 'TRUE', NULL, 142, '1.0', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98562, '47.23854', '-124.20363', 'Moclips', 'WA', 'Washington', 'TRUE', NULL, 195, '76.7', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98563, '47.20857', '-123.60305', 'Montesano', 'WA', 'Washington', 'TRUE', NULL, 8001, '8.5', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98564, '46.45637', '-122.43293', 'Mossyrock', 'WA', 'Washington', 'TRUE', NULL, 2459, '6.8', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98565, '46.57833', '-122.90201', 'Napavine', 'WA', 'Washington', 'TRUE', NULL, 618, '385.3', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98568, '46.85481', '-123.31392', 'Oakville', 'WA', 'Washington', 'TRUE', NULL, 2519, '6.5', 53027, 'Grays Harbor', '{\'53027\':98.17,\'53041\':1.83}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98569, '47.00630', '-124.15122', 'Ocean Shores', 'WA', 'Washington', 'TRUE', NULL, 5784, '152.5', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98570, '46.63828', '-122.63650', 'Onalaska', 'WA', 'Washington', 'TRUE', NULL, 3889, '12.6', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98571, '47.19444', '-124.17240', 'Pacific Beach', 'WA', 'Washington', 'TRUE', NULL, 483, '21.3', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98572, '46.55120', '-123.32437', 'Pe Ell', 'WA', 'Washington', 'TRUE', NULL, 797, '8.9', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98575, '47.41774', '-123.79556', 'Quinault', 'WA', 'Washington', 'TRUE', NULL, 228, '0.9', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98576, '46.83742', '-122.63545', 'Rainier', 'WA', 'Washington', 'TRUE', NULL, 4667, '25.5', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98577, '46.64218', '-123.60769', 'Raymond', 'WA', 'Washington', 'TRUE', NULL, 6338, '6.4', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98579, '46.79805', '-123.11924', 'Rochester', 'WA', 'Washington', 'TRUE', NULL, 12870, '54.9', 53067, 'Thurston', '{\'53041\':3.11,\'53067\':96.89}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98580, '46.99630', '-122.51612', 'Roy', 'WA', 'Washington', 'TRUE', NULL, 11099, '30.4', 53053, 'Pierce', '{\'53053\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98581, '46.35778', '-123.06724', 'Ryderwood', 'WA', 'Washington', 'TRUE', NULL, 424, '5.6', 53015, 'Cowlitz', '{\'53015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98582, '46.52150', '-122.62382', 'Salkum', 'WA', 'Washington', 'TRUE', NULL, 611, '33.2', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98583, '47.00116', '-123.48746', 'Satsop', 'WA', 'Washington', 'TRUE', NULL, 124, '437.1', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98584, '47.24236', '-123.15514', 'Shelton', 'WA', 'Washington', 'TRUE', NULL, 36630, '41.5', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98585, '46.55493', '-122.49575', 'Silver Creek', 'WA', 'Washington', 'TRUE', NULL, 655, '11.4', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98586, '46.54490', '-123.81370', 'South Bend', 'WA', 'Washington', 'TRUE', NULL, 1944, '5.5', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98587, '47.30875', '-124.21419', 'Taholah', 'WA', 'Washington', 'TRUE', NULL, 942, '12.7', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98588, '47.44458', '-123.02331', 'Tahuya', 'WA', 'Washington', 'TRUE', NULL, 1829, '14.5', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98589, '46.83933', '-122.81146', 'Tenino', 'WA', 'Washington', 'TRUE', NULL, 7320, '30.7', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98590, '46.71866', '-124.00252', 'Tokeland', 'WA', 'Washington', 'TRUE', NULL, 356, '44.5', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98591, '46.44268', '-122.74286', 'Toledo', 'WA', 'Washington', 'TRUE', NULL, 3952, '13.2', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98592, '47.32587', '-123.08023', 'Union', 'WA', 'Washington', 'TRUE', NULL, 1764, '38.6', 53045, 'Mason', '{\'53045\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98593, '46.40794', '-123.00550', 'Vader', 'WA', 'Washington', 'TRUE', NULL, 1113, '32.1', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98595, '46.88234', '-124.10849', 'Westport', 'WA', 'Washington', 'TRUE', NULL, 2917, '206.3', 53027, 'Grays Harbor', '{\'53027\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98596, '46.49566', '-122.95320', 'Winlock', 'WA', 'Washington', 'TRUE', NULL, 6524, '28.2', 53041, 'Lewis', '{\'53041\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98597, '46.85142', '-122.49235', 'Yelm', 'WA', 'Washington', 'TRUE', NULL, 21557, '74.6', 53067, 'Thurston', '{\'53067\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98601, '45.95630', '-122.36118', 'Amboy', 'WA', 'Washington', 'TRUE', NULL, 2982, '16.9', 53011, 'Clark', '{\'53011\':95.61,\'53015\':4.39}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98602, '45.86717', '-121.26546', 'Appleton', 'WA', 'Washington', 'TRUE', NULL, 200, '1.4', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98603, '46.04080', '-122.42018', 'Ariel', 'WA', 'Washington', 'TRUE', NULL, 1017, '3.4', 53015, 'Cowlitz', '{\'53015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98604, '45.80017', '-122.50506', 'Battle Ground', 'WA', 'Washington', 'TRUE', NULL, 34232, '182.7', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98605, '45.77509', '-121.63281', 'Bingen', 'WA', 'Washington', 'TRUE', NULL, 1225, '10.9', 53039, 'Klickitat', '{\'53039\':62.53,\'53059\':37.47}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98606, '45.72975', '-122.45641', 'Brush Prairie', 'WA', 'Washington', 'TRUE', NULL, 9027, '93.2', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98607, '45.64341', '-122.38204', 'Camas', 'WA', 'Washington', 'TRUE', NULL, 27899, '229.5', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98610, '45.86735', '-122.07070', 'Carson', 'WA', 'Washington', 'TRUE', NULL, 2871, '3.0', 53059, 'Skamania', '{\'53059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98611, '46.30811', '-122.89526', 'Castle Rock', 'WA', 'Washington', 'TRUE', NULL, 9133, '28.3', 53015, 'Cowlitz', '{\'53015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98612, '46.21775', '-123.32548', 'Cathlamet', 'WA', 'Washington', 'TRUE', NULL, 2704, '13.8', 53069, 'Wahkiakum', '{\'53069\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98613, '45.73673', '-120.96565', 'Centerville', 'WA', 'Washington', 'TRUE', NULL, 400, '1.7', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98614, '46.29717', '-123.90149', 'Chinook', 'WA', 'Washington', 'TRUE', NULL, 353, '4.8', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98616, '46.19705', '-122.14161', 'Cougar', 'WA', 'Washington', 'TRUE', NULL, 150, '0.3', 53015, 'Cowlitz', '{\'53015\':74.67,\'53059\':25.33}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98617, '45.64391', '-121.15643', 'Dallesport', 'WA', 'Washington', 'TRUE', NULL, 1042, '36.2', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98619, '45.97502', '-121.27212', 'Glenwood', 'WA', 'Washington', 'TRUE', NULL, 457, '1.2', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98620, '45.87203', '-120.77467', 'Goldendale', 'WA', 'Washington', 'TRUE', NULL, 7123, '5.7', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98621, '46.37784', '-123.54961', 'Grays River', 'WA', 'Washington', 'TRUE', NULL, 276, '2.5', 53069, 'Wahkiakum', '{\'53049\':3.26,\'53069\':96.74}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98624, '46.36952', '-123.97141', 'Ilwaco', 'WA', 'Washington', 'TRUE', NULL, 1532, '17.5', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98625, '46.04237', '-122.72782', 'Kalama', 'WA', 'Washington', 'TRUE', NULL, 6133, '29.4', 53015, 'Cowlitz', '{\'53015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98626, '46.15463', '-122.78639', 'Kelso', 'WA', 'Washington', 'TRUE', NULL, 24523, '69.3', 53015, 'Cowlitz', '{\'53015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98628, '45.85918', '-121.09076', 'Klickitat', 'WA', 'Washington', 'TRUE', NULL, 385, '16.9', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98629, '45.88169', '-122.61413', 'La Center', 'WA', 'Washington', 'TRUE', NULL, 8364, '83.5', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98631, '46.38881', '-124.03699', 'Long Beach', 'WA', 'Washington', 'TRUE', NULL, 3243, '80.6', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98632, '46.21685', '-123.06853', 'Longview', 'WA', 'Washington', 'TRUE', NULL, 49205, '146.9', 53015, 'Cowlitz', '{\'53015\':99.92,\'53069\':0.08}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98635, '45.74258', '-121.20390', 'Lyle', 'WA', 'Washington', 'TRUE', NULL, 1735, '5.2', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98638, '46.38955', '-123.74334', 'Naselle', 'WA', 'Washington', 'TRUE', NULL, 1525, '3.5', 53049, 'Pacific', '{\'53049\':86.62,\'53069\':13.38}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98639, '45.66291', '-121.98952', 'North Bonneville', 'WA', 'Washington', 'TRUE', NULL, 847, '25.6', 53059, 'Skamania', '{\'53059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98640, '46.54782', '-124.04610', 'Ocean Park', 'WA', 'Washington', 'TRUE', NULL, 4380, '83.4', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98641, '46.54638', '-124.02992', 'Oysterville', 'WA', 'Washington', 'TRUE', NULL, 5, '46.9', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98642, '45.80251', '-122.70164', 'Ridgefield', 'WA', 'Washington', 'TRUE', NULL, 15696, '106.1', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98643, '46.30135', '-123.61472', 'Rosburg', 'WA', 'Washington', 'TRUE', NULL, 362, '3.8', 53069, 'Wahkiakum', '{\'53069\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98644, '46.32964', '-124.05628', 'Seaview', 'WA', 'Washington', 'TRUE', NULL, 473, '259.4', 53049, 'Pacific', '{\'53049\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98645, '46.32644', '-122.78194', 'Silverlake', 'WA', 'Washington', 'TRUE', NULL, 1429, '37.0', 53015, 'Cowlitz', '{\'53015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98647, '46.31840', '-123.43535', 'Skamokawa', 'WA', 'Washington', 'TRUE', NULL, 404, '2.5', 53069, 'Wahkiakum', '{\'53069\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98648, '45.70806', '-121.95488', 'Stevenson', 'WA', 'Washington', 'TRUE', NULL, 3100, '9.7', 53059, 'Skamania', '{\'53059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98649, '46.31417', '-122.53538', 'Toutle', 'WA', 'Washington', 'TRUE', NULL, 895, '1.7', 53015, 'Cowlitz', '{\'53015\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98650, '45.97293', '-121.52874', 'Trout Lake', 'WA', 'Washington', 'TRUE', NULL, 959, '4.5', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98651, '45.74276', '-121.58400', 'Underwood', 'WA', 'Washington', 'TRUE', NULL, 939, '20.3', 53059, 'Skamania', '{\'53059\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98660, '45.68773', '-122.73188', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 11858, '306.5', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98661, '45.63918', '-122.62576', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 41740, '1517.0', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98662, '45.68850', '-122.57784', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 31644, '949.0', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98663, '45.65398', '-122.66257', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 14115, '1264.9', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98664, '45.61981', '-122.57752', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 21771, '1597.8', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98665, '45.67977', '-122.65933', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 24057, '1152.8', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98670, '45.85885', '-121.14079', 'Wahkiacus', 'WA', 'Washington', 'TRUE', NULL, 113, '1.7', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98671, '45.61329', '-122.24223', 'Washougal', 'WA', 'Washington', 'TRUE', NULL, 21220, '94.9', 53011, 'Clark', '{\'53011\':87.26,\'53059\':12.74}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98672, '45.81842', '-121.46299', 'White Salmon', 'WA', 'Washington', 'TRUE', NULL, 6146, '16.3', 53039, 'Klickitat', '{\'53039\':98.23,\'53059\':1.77}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98673, '45.65212', '-121.03609', 'Wishram', 'WA', 'Washington', 'TRUE', NULL, 404, '12.0', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98674, '45.94333', '-122.66499', 'Woodland', 'WA', 'Washington', 'TRUE', NULL, 12029, '56.0', 53015, 'Cowlitz', '{\'53011\':21.48,\'53015\':78.52}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98675, '45.82700', '-122.34443', 'Yacolt', 'WA', 'Washington', 'TRUE', NULL, 6713, '22.0', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98682, '45.67319', '-122.48171', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 52893, '677.1', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98683, '45.60301', '-122.51023', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 30832, '1640.1', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98684, '45.63073', '-122.51644', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 26968, '1493.2', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98685, '45.71621', '-122.68992', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 26217, '1040.3', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98686, '45.72415', '-122.62335', 'Vancouver', 'WA', 'Washington', 'TRUE', NULL, 17385, '583.6', 53011, 'Clark', '{\'53011\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98801, '47.42334', '-120.33780', 'Wenatchee', 'WA', 'Washington', 'TRUE', NULL, 40977, '97.4', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98802, '47.49059', '-120.16774', 'East Wenatchee', 'WA', 'Washington', 'TRUE', NULL, 28719, '61.8', 53017, 'Douglas', '{\'53017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98811, '47.71388', '-120.37621', 'Ardenvoir', 'WA', 'Washington', 'TRUE', NULL, 71, '5.3', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98812, '48.14450', '-119.75287', 'Brewster', 'WA', 'Washington', 'TRUE', NULL, 4899, '7.1', 53047, 'Okanogan', '{\'53017\':12.49,\'53047\':87.51}', 'FALSE', 'FALSE', 'America/Los_Angeles');
INSERT INTO `us_zip` (`zip`, `lat`, `lng`, `city`, `state_id`, `state_name`, `zcta`, `parent_zcta`, `population`, `density`, `county_fips`, `county_name`, `all_county_weights`, `imprecise`, `military`, `timezone`) VALUES
(98813, '48.01417', '-119.60655', 'Bridgeport', 'WA', 'Washington', 'TRUE', NULL, 3176, '10.4', 53017, 'Douglas', '{\'53017\':95.59,\'53047\':4.41}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98814, '48.20685', '-120.15826', 'Carlton', 'WA', 'Washington', 'TRUE', NULL, 466, '1.2', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98815, '47.48374', '-120.47432', 'Cashmere', 'WA', 'Washington', 'TRUE', NULL, 7233, '23.5', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98816, '47.99847', '-120.32949', 'Chelan', 'WA', 'Washington', 'TRUE', NULL, 6394, '6.2', 53007, 'Chelan', '{\'53007\':99.72,\'53017\':0.28}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98817, '47.79153', '-119.99527', 'Chelan Falls', 'WA', 'Washington', 'TRUE', NULL, 366, '143.8', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98819, '48.61684', '-119.81462', 'Conconully', 'WA', 'Washington', 'TRUE', NULL, 258, '0.8', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98821, '47.55177', '-120.55942', 'Dryden', 'WA', 'Washington', 'TRUE', NULL, 519, '108.9', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98822, '47.86645', '-120.47564', 'Entiat', 'WA', 'Washington', 'TRUE', NULL, 1953, '1.7', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98823, '47.32197', '-119.63358', 'Ephrata', 'WA', 'Washington', 'TRUE', NULL, 11055, '14.3', 53025, 'Grant', '{\'53017\':0.46,\'53025\':99.54}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98824, '47.07759', '-119.85889', 'George', 'WA', 'Washington', 'TRUE', NULL, 181, '183.3', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98826, '47.78749', '-120.85452', 'Leavenworth', 'WA', 'Washington', 'TRUE', NULL, 6504, '2.5', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98827, '48.86486', '-119.76695', 'Loomis', 'WA', 'Washington', 'TRUE', NULL, 312, '0.4', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98828, '47.30565', '-120.17610', 'Malaga', 'WA', 'Washington', 'TRUE', NULL, 2146, '14.6', 53007, 'Chelan', '{\'53007\':99.63,\'53037\':0.37}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98829, '48.31242', '-119.80893', 'Malott', 'WA', 'Washington', 'TRUE', NULL, 564, '3.2', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98830, '47.89516', '-119.51456', 'Mansfield', 'WA', 'Washington', 'TRUE', NULL, 494, '0.4', 53017, 'Douglas', '{\'53017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98831, '47.93460', '-120.13010', 'Manson', 'WA', 'Washington', 'TRUE', NULL, 3708, '30.5', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98832, '47.37195', '-119.01776', 'Marlin', 'WA', 'Washington', 'TRUE', NULL, 320, '0.6', 53025, 'Grant', '{\'53025\':91.88,\'53043\':8.13}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98833, '48.68820', '-120.61131', 'Mazama', 'WA', 'Washington', 'TRUE', NULL, 150, '0.3', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98834, '48.11708', '-120.08911', 'Methow', 'WA', 'Washington', 'TRUE', NULL, 239, '1.2', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98836, '47.47528', '-120.42757', 'Monitor', 'WA', 'Washington', 'TRUE', NULL, 584, '29.5', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98837, '47.14978', '-119.30456', 'Moses Lake', 'WA', 'Washington', 'TRUE', NULL, 39722, '31.8', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98840, '48.31466', '-119.56659', 'Okanogan', 'WA', 'Washington', 'TRUE', NULL, 4851, '4.5', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98841, '48.35883', '-119.26949', 'Omak', 'WA', 'Washington', 'TRUE', NULL, 9197, '9.3', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98843, '47.75201', '-120.05985', 'Orondo', 'WA', 'Washington', 'TRUE', NULL, 1817, '10.7', 53017, 'Douglas', '{\'53017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98844, '48.91594', '-119.24436', 'Oroville', 'WA', 'Washington', 'TRUE', NULL, 4740, '5.5', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98845, '47.41840', '-119.92731', 'Palisades', 'WA', 'Washington', 'TRUE', NULL, 128, '0.7', 53017, 'Douglas', '{\'53017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98846, '48.03405', '-119.97863', 'Pateros', 'WA', 'Washington', 'TRUE', NULL, 1173, '5.1', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98847, '47.44050', '-120.64670', 'Peshastin', 'WA', 'Washington', 'TRUE', NULL, 1920, '4.6', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98848, '47.17237', '-119.84329', 'Quincy', 'WA', 'Washington', 'TRUE', NULL, 11518, '9.9', 53025, 'Grant', '{\'53017\':0.44,\'53025\':99.56}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98849, '48.53820', '-119.40391', 'Riverside', 'WA', 'Washington', 'TRUE', NULL, 1078, '2.7', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98850, '47.30760', '-120.07755', 'Rock Island', 'WA', 'Washington', 'TRUE', NULL, 1543, '26.2', 53017, 'Douglas', '{\'53017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98851, '47.42069', '-119.42515', 'Soap Lake', 'WA', 'Washington', 'TRUE', NULL, 4014, '9.8', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98852, '48.25281', '-120.55118', 'Stehekin', 'WA', 'Washington', 'TRUE', NULL, 104, '0.2', 53007, 'Chelan', '{\'53007\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98853, '47.46200', '-119.26026', 'Stratford', 'WA', 'Washington', 'TRUE', NULL, 23, '1.1', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98855, '48.67535', '-119.27048', 'Tonasket', 'WA', 'Washington', 'TRUE', NULL, 5863, '3.5', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98856, '48.37294', '-120.25318', 'Twisp', 'WA', 'Washington', 'TRUE', NULL, 2464, '2.1', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98857, '46.98565', '-119.05068', 'Warden', 'WA', 'Washington', 'TRUE', NULL, 4082, '9.7', 53025, 'Grant', '{\'53001\':3.67,\'53025\':96.33}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98858, '47.64654', '-119.90885', 'Waterville', 'WA', 'Washington', 'TRUE', NULL, 1521, '1.5', 53017, 'Douglas', '{\'53017\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98859, '48.80235', '-118.91409', 'Wauconda', 'WA', 'Washington', 'TRUE', NULL, 238, '0.7', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98860, '47.46882', '-119.16392', 'Wilson Creek', 'WA', 'Washington', 'TRUE', NULL, 259, '1.3', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98862, '48.58163', '-120.28825', 'Winthrop', 'WA', 'Washington', 'TRUE', NULL, 2218, '1.9', 53047, 'Okanogan', '{\'53047\':100,\'53073\':0}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98901, '46.69318', '-120.41528', 'Yakima', 'WA', 'Washington', 'TRUE', NULL, 30169, '99.9', 53077, 'Yakima', '{\'53037\':0.2,\'53077\':99.8}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98902, '46.59666', '-120.53373', 'Yakima', 'WA', 'Washington', 'TRUE', NULL, 46322, '1980.1', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98903, '46.53887', '-121.02664', 'Yakima', 'WA', 'Washington', 'TRUE', NULL, 14517, '19.4', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98908, '46.61654', '-120.70942', 'Yakima', 'WA', 'Washington', 'TRUE', NULL, 35240, '137.7', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98921, '46.43107', '-120.31878', 'Buena', 'WA', 'Washington', 'TRUE', NULL, 516, '1585.4', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98922, '47.26932', '-120.88143', 'Cle Elum', 'WA', 'Washington', 'TRUE', NULL, 5468, '4.7', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98923, '46.66635', '-120.71762', 'Cowiche', 'WA', 'Washington', 'TRUE', NULL, 1434, '91.8', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98925, '47.25806', '-121.28081', 'Easton', 'WA', 'Washington', 'TRUE', NULL, 689, '2.1', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98926, '47.01295', '-120.46296', 'Ellensburg', 'WA', 'Washington', 'TRUE', NULL, 30239, '20.2', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98930, '46.27047', '-119.89355', 'Grandview', 'WA', 'Washington', 'TRUE', NULL, 15252, '123.9', 53077, 'Yakima', '{\'53005\':5.85,\'53077\':94.15}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98932, '46.33243', '-120.16119', 'Granger', 'WA', 'Washington', 'TRUE', NULL, 5032, '57.6', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98933, '46.40224', '-120.63128', 'Harrah', 'WA', 'Washington', 'TRUE', NULL, 1267, '20.3', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98934, '46.98178', '-120.41491', 'Kittitas', 'WA', 'Washington', 'TRUE', NULL, 1117, '508.1', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98935, '46.13140', '-120.08635', 'Mabton', 'WA', 'Washington', 'TRUE', NULL, 4190, '6.0', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98936, '46.53597', '-120.14412', 'Moxee', 'WA', 'Washington', 'TRUE', NULL, 5872, '16.0', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98937, '46.80801', '-121.16104', 'Naches', 'WA', 'Washington', 'TRUE', NULL, 4112, '2.0', 53077, 'Yakima', '{\'53037\':0,\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98938, '46.38829', '-120.09412', 'Outlook', 'WA', 'Washington', 'TRUE', NULL, 2177, '22.7', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98939, '46.49687', '-120.46581', 'Parker', 'WA', 'Washington', 'TRUE', NULL, 167, '226.1', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98940, '47.40467', '-121.07331', 'Ronald', 'WA', 'Washington', 'TRUE', NULL, 760, '2.7', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98941, '47.22327', '-120.98199', 'Roslyn', 'WA', 'Washington', 'TRUE', NULL, 919, '73.1', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98942, '46.80184', '-120.67506', 'Selah', 'WA', 'Washington', 'TRUE', NULL, 16973, '34.7', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98943, '47.18563', '-120.95844', 'South Cle Elum', 'WA', 'Washington', 'TRUE', NULL, 660, '296.7', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98944, '46.49322', '-119.64732', 'Sunnyside', 'WA', 'Washington', 'TRUE', NULL, 22014, '14.7', 53077, 'Yakima', '{\'53005\':0.2,\'53077\':99.8}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98946, '47.07912', '-120.72166', 'Thorp', 'WA', 'Washington', 'TRUE', NULL, 495, '10.5', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98947, '46.68748', '-120.80156', 'Tieton', 'WA', 'Washington', 'TRUE', NULL, 2902, '27.2', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98948, '46.28524', '-120.32837', 'Toppenish', 'WA', 'Washington', 'TRUE', NULL, 13225, '23.4', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98950, '46.89747', '-119.99058', 'Vantage', 'WA', 'Washington', 'TRUE', NULL, 177, '2.9', 53037, 'Kittitas', '{\'53037\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98951, '46.45978', '-120.51615', 'Wapato', 'WA', 'Washington', 'TRUE', NULL, 13739, '35.3', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98952, '46.35435', '-120.76140', 'White Swan', 'WA', 'Washington', 'TRUE', NULL, 2330, '4.4', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(98953, '46.44227', '-120.22679', 'Zillah', 'WA', 'Washington', 'TRUE', NULL, 6681, '40.9', 53077, 'Yakima', '{\'53077\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99001, '47.63652', '-117.58632', 'Airway Heights', 'WA', 'Washington', 'TRUE', NULL, 6151, '334.3', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99003, '47.91839', '-117.28467', 'Chattaroy', 'WA', 'Washington', 'TRUE', NULL, 4848, '26.7', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99004, '47.41112', '-117.63772', 'Cheney', 'WA', 'Washington', 'TRUE', NULL, 18376, '21.1', 53063, 'Spokane', '{\'53063\':99.94,\'53075\':0.06}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99005, '47.84425', '-117.36622', 'Colbert', 'WA', 'Washington', 'TRUE', NULL, 8574, '83.4', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99006, '47.98297', '-117.50226', 'Deer Park', 'WA', 'Washington', 'TRUE', NULL, 11946, '25.1', 53063, 'Spokane', '{\'53051\':0.76,\'53063\':84.09,\'53065\':15.15}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99008, '47.50803', '-117.92448', 'Edwall', 'WA', 'Washington', 'TRUE', NULL, 641, '1.9', 53043, 'Lincoln', '{\'53043\':55.69,\'53063\':44.31}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99009, '48.01865', '-117.25440', 'Elk', 'WA', 'Washington', 'TRUE', NULL, 3947, '19.0', 53063, 'Spokane', '{\'53051\':20.52,\'53063\':79.48}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99011, '47.61883', '-117.64812', 'Fairchild Air Force Base', 'WA', 'Washington', 'TRUE', NULL, 2776, '163.8', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99012, '47.38209', '-117.19286', 'Fairfield', 'WA', 'Washington', 'TRUE', NULL, 1064, '4.3', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99013, '47.89235', '-117.83446', 'Ford', 'WA', 'Washington', 'TRUE', NULL, 1785, '6.7', 53065, 'Stevens', '{\'53043\':10.2,\'53063\':7.06,\'53065\':82.75}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99016, '47.62121', '-117.14625', 'Greenacres', 'WA', 'Washington', 'TRUE', NULL, 12480, '191.2', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99017, '47.18882', '-117.87558', 'Lamont', 'WA', 'Washington', 'TRUE', NULL, 161, '0.7', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99018, '47.28982', '-117.15485', 'Latah', 'WA', 'Washington', 'TRUE', NULL, 282, '3.1', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99019, '47.64278', '-117.07643', 'Liberty Lake', 'WA', 'Washington', 'TRUE', NULL, 9502, '167.5', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99020, '47.56242', '-117.49663', 'Marshall', 'WA', 'Washington', 'TRUE', NULL, 82, '352.2', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99021, '47.84825', '-117.18952', 'Mead', 'WA', 'Washington', 'TRUE', NULL, 9174, '42.1', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99022, '47.60156', '-117.71131', 'Medical Lake', 'WA', 'Washington', 'TRUE', NULL, 8820, '49.4', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99023, '47.56108', '-117.17178', 'Mica', 'WA', 'Washington', 'TRUE', NULL, 529, '15.0', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99025, '47.78991', '-117.08595', 'Newman Lake', 'WA', 'Washington', 'TRUE', NULL, 5232, '45.3', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99026, '47.81145', '-117.62775', 'Nine Mile Falls', 'WA', 'Washington', 'TRUE', NULL, 9042, '49.2', 53065, 'Stevens', '{\'53063\':36.2,\'53065\':63.8}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99027, '47.71042', '-117.12621', 'Otis Orchards', 'WA', 'Washington', 'TRUE', NULL, 6101, '156.1', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99029, '47.69764', '-117.82934', 'Reardan', 'WA', 'Washington', 'TRUE', NULL, 1289, '4.2', 53043, 'Lincoln', '{\'53043\':75.1,\'53063\':24.9}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99030, '47.48410', '-117.11024', 'Rockford', 'WA', 'Washington', 'TRUE', NULL, 1032, '5.1', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99031, '47.42351', '-117.36247', 'Spangle', 'WA', 'Washington', 'TRUE', NULL, 1137, '6.2', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99032, '47.31738', '-118.02806', 'Sprague', 'WA', 'Washington', 'TRUE', NULL, 691, '1.2', 53043, 'Lincoln', '{\'53001\':2.32,\'53043\':97.68}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99033, '47.23235', '-117.09926', 'Tekoa', 'WA', 'Washington', 'TRUE', NULL, 895, '9.2', 53075, 'Whitman', '{\'53063\':1.23,\'53075\':98.77}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99034, '47.88562', '-117.74864', 'Tumtum', 'WA', 'Washington', 'TRUE', NULL, 209, '4.7', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99036, '47.52532', '-117.27588', 'Valleyford', 'WA', 'Washington', 'TRUE', NULL, 1448, '13.7', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99037, '47.63640', '-117.19720', 'Veradale', 'WA', 'Washington', 'TRUE', NULL, 12973, '774.6', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99039, '47.34466', '-117.26560', 'Waverly', 'WA', 'Washington', 'TRUE', NULL, 87, '7.5', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99040, '47.90086', '-118.00526', 'Wellpinit', 'WA', 'Washington', 'TRUE', NULL, 734, '2.7', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99101, '48.32727', '-117.92516', 'Addy', 'WA', 'Washington', 'TRUE', NULL, 1453, '5.1', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99102, '46.79207', '-117.24997', 'Albion', 'WA', 'Washington', 'TRUE', NULL, 500, '833.0', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99103, '47.73715', '-118.93696', 'Almira', 'WA', 'Washington', 'TRUE', NULL, 497, '0.8', 53043, 'Lincoln', '{\'53025\':7.44,\'53043\':92.56}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99105, '46.90340', '-118.10475', 'Benge', 'WA', 'Washington', 'TRUE', NULL, 61, '0.2', 53001, 'Adams', '{\'53001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99109, '48.28537', '-117.70139', 'Chewelah', 'WA', 'Washington', 'TRUE', NULL, 5109, '7.0', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99110, '48.01216', '-117.57637', 'Clayton', 'WA', 'Washington', 'TRUE', NULL, 1667, '17.1', 53065, 'Stevens', '{\'53063\':9.9,\'53065\':90.1}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99111, '46.85372', '-117.42452', 'Colfax', 'WA', 'Washington', 'TRUE', NULL, 4047, '5.4', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99113, '46.59411', '-117.19147', 'Colton', 'WA', 'Washington', 'TRUE', NULL, 761, '3.1', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99114, '48.65405', '-117.73960', 'Colville', 'WA', 'Washington', 'TRUE', NULL, 12018, '6.4', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99115, '47.64719', '-119.42388', 'Coulee City', 'WA', 'Washington', 'TRUE', NULL, 1143, '1.1', 53025, 'Grant', '{\'53017\':13.74,\'53025\':86.26}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99116, '48.01600', '-118.92859', 'Coulee Dam', 'WA', 'Washington', 'TRUE', NULL, 1439, '11.8', 53047, 'Okanogan', '{\'53017\':13,\'53025\':0,\'53047\':87}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99117, '47.72401', '-118.52076', 'Creston', 'WA', 'Washington', 'TRUE', NULL, 485, '1.0', 53043, 'Lincoln', '{\'53043\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99118, '48.89658', '-118.63900', 'Curlew', 'WA', 'Washington', 'TRUE', NULL, 931, '1.8', 53019, 'Ferry', '{\'53019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99119, '48.50390', '-117.28854', 'Cusick', 'WA', 'Washington', 'TRUE', NULL, 1204, '1.1', 53051, 'Pend Oreille', '{\'53051\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99121, '48.94794', '-118.46514', 'Danville', 'WA', 'Washington', 'TRUE', NULL, 145, '1.0', 53019, 'Ferry', '{\'53019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99122, '47.67761', '-118.20799', 'Davenport', 'WA', 'Washington', 'TRUE', NULL, 3773, '2.6', 53043, 'Lincoln', '{\'53043\':99.31,\'53065\':0.69}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99123, '47.84584', '-119.14296', 'Electric City', 'WA', 'Washington', 'TRUE', NULL, 1058, '9.4', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99124, '48.00013', '-118.95250', 'Elmer City', 'WA', 'Washington', 'TRUE', NULL, 240, '484.3', 53047, 'Okanogan', '{\'53047\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99125, '46.94300', '-117.77858', 'Endicott', 'WA', 'Washington', 'TRUE', NULL, 527, '0.9', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99126, '48.73963', '-117.97195', 'Evans', 'WA', 'Washington', 'TRUE', NULL, 877, '6.5', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99128, '47.09933', '-117.07292', 'Farmington', 'WA', 'Washington', 'TRUE', NULL, 321, '1.5', 53075, 'Whitman', '{\'16057\':13.4,\'53075\':86.6}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99129, '48.00522', '-118.19271', 'Fruitland', 'WA', 'Washington', 'TRUE', NULL, 793, '2.0', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99130, '46.99732', '-117.18410', 'Garfield', 'WA', 'Washington', 'TRUE', NULL, 828, '4.1', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99131, '48.27906', '-118.12320', 'Gifford', 'WA', 'Washington', 'TRUE', NULL, 170, '2.5', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99133, '48.01489', '-119.07685', 'Grand Coulee', 'WA', 'Washington', 'TRUE', NULL, 1493, '3.9', 53025, 'Grant', '{\'53017\':6.5,\'53025\':77.43,\'53043\':16.08}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99134, '47.43010', '-118.31124', 'Harrington', 'WA', 'Washington', 'TRUE', NULL, 643, '1.2', 53043, 'Lincoln', '{\'53043\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99135, '47.66121', '-119.09739', 'Hartline', 'WA', 'Washington', 'TRUE', NULL, 255, '0.6', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99136, '46.67467', '-117.95548', 'Hay', 'WA', 'Washington', 'TRUE', NULL, 29, '0.6', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99137, '48.16826', '-118.09022', 'Hunters', 'WA', 'Washington', 'TRUE', NULL, 343, '1.6', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99138, '48.22235', '-118.37873', 'Inchelium', 'WA', 'Washington', 'TRUE', NULL, 1209, '0.9', 53019, 'Ferry', '{\'53019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99139, '48.73459', '-117.40668', 'Ione', 'WA', 'Washington', 'TRUE', NULL, 1301, '2.5', 53051, 'Pend Oreille', '{\'53051\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99140, '48.11156', '-118.67673', 'Keller', 'WA', 'Washington', 'TRUE', NULL, 475, '0.5', 53019, 'Ferry', '{\'53019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99141, '48.73766', '-118.14452', 'Kettle Falls', 'WA', 'Washington', 'TRUE', NULL, 5240, '3.8', 53065, 'Stevens', '{\'53019\':19.54,\'53065\':80.46}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99143, '46.73948', '-117.85624', 'Lacrosse', 'WA', 'Washington', 'TRUE', NULL, 650, '0.8', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99144, '47.37774', '-118.50435', 'Lamona', 'WA', 'Washington', 'TRUE', NULL, 43, '0.5', 53043, 'Lincoln', '{\'53043\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99146, '48.95760', '-118.29754', 'Laurier', 'WA', 'Washington', 'TRUE', NULL, 56, '0.5', 53019, 'Ferry', '{\'53019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99147, '47.83950', '-118.44258', 'Lincoln', 'WA', 'Washington', 'TRUE', NULL, 190, '9.0', 53043, 'Lincoln', '{\'53043\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99148, '48.10271', '-117.59821', 'Loon Lake', 'WA', 'Washington', 'TRUE', NULL, 2106, '14.0', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99149, '47.21717', '-117.46393', 'Malden', 'WA', 'Washington', 'TRUE', NULL, 208, '30.9', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99150, '48.79435', '-118.58298', 'Malo', 'WA', 'Washington', 'TRUE', NULL, 380, '2.6', 53019, 'Ferry', '{\'53019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99151, '48.66448', '-118.06368', 'Marcus', 'WA', 'Washington', 'TRUE', NULL, 164, '518.3', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99152, '48.84959', '-117.39626', 'Metaline', 'WA', 'Washington', 'TRUE', NULL, 197, '16.3', 53051, 'Pend Oreille', '{\'53051\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99153, '48.85150', '-117.21270', 'Metaline Falls', 'WA', 'Washington', 'TRUE', NULL, 467, '0.5', 53051, 'Pend Oreille', '{\'53051\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99154, '47.38973', '-118.36596', 'Mohler', 'WA', 'Washington', 'TRUE', NULL, 20, '0.4', 53043, 'Lincoln', '{\'53043\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99155, '48.25567', '-118.95348', 'Nespelem', 'WA', 'Washington', 'TRUE', NULL, 1350, '1.7', 53047, 'Okanogan', '{\'53019\':1.26,\'53047\':98.74}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99156, '48.18480', '-117.19076', 'Newport', 'WA', 'Washington', 'TRUE', NULL, 8114, '9.6', 53051, 'Pend Oreille', '{\'53051\':98.5,\'53063\':1.5}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99157, '48.92468', '-117.81576', 'Northport', 'WA', 'Washington', 'TRUE', NULL, 697, '3.7', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99158, '47.13032', '-117.24736', 'Oakesdale', 'WA', 'Washington', 'TRUE', NULL, 603, '2.6', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99159, '47.32943', '-118.74249', 'Odessa', 'WA', 'Washington', 'TRUE', NULL, 1375, '1.1', 53043, 'Lincoln', '{\'53001\':12.58,\'53043\':87.42}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99160, '48.83874', '-118.30631', 'Orient', 'WA', 'Washington', 'TRUE', NULL, 149, '0.6', 53019, 'Ferry', '{\'53019\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99161, '46.89820', '-117.13047', 'Palouse', 'WA', 'Washington', 'TRUE', NULL, 1400, '7.3', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99163, '46.72892', '-117.21485', 'Pullman', 'WA', 'Washington', 'TRUE', NULL, 31404, '58.6', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99164, '46.73104', '-117.15220', 'Pullman', 'WA', 'Washington', 'TRUE', NULL, 0, '0.0', 53075, 'Whitman', '{\'53075\':0}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99166, '48.57168', '-118.64454', 'Republic', 'WA', 'Washington', 'TRUE', NULL, 3222, '2.1', 53019, 'Ferry', '{\'53019\':98.23,\'53047\':1.77}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99167, '48.41724', '-118.11899', 'Rice', 'WA', 'Washington', 'TRUE', NULL, 625, '3.9', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99169, '47.11200', '-118.35873', 'Ritzville', 'WA', 'Washington', 'TRUE', NULL, 2459, '1.3', 53001, 'Adams', '{\'53001\':98.5,\'53043\':1.5}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99170, '47.24762', '-117.40218', 'Rosalia', 'WA', 'Washington', 'TRUE', NULL, 1072, '2.3', 53075, 'Whitman', '{\'53063\':20.9,\'53075\':79.1}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99171, '47.10444', '-117.65624', 'Saint John', 'WA', 'Washington', 'TRUE', NULL, 959, '1.4', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99173, '48.03694', '-117.86308', 'Springdale', 'WA', 'Washington', 'TRUE', NULL, 1532, '4.5', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99174, '47.01069', '-117.35878', 'Steptoe', 'WA', 'Washington', 'TRUE', NULL, 44, '126.4', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99176, '47.08093', '-117.42386', 'Thornton', 'WA', 'Washington', 'TRUE', NULL, 145, '1.5', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99179, '46.49006', '-117.11896', 'Uniontown', 'WA', 'Washington', 'TRUE', NULL, 437, '2.4', 53075, 'Whitman', '{\'53075\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99180, '48.29579', '-117.32850', 'Usk', 'WA', 'Washington', 'TRUE', NULL, 939, '3.6', 53051, 'Pend Oreille', '{\'53051\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99181, '48.14332', '-117.76933', 'Valley', 'WA', 'Washington', 'TRUE', NULL, 1901, '7.4', 53065, 'Stevens', '{\'53065\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99185, '47.74593', '-118.71950', 'Wilbur', 'WA', 'Washington', 'TRUE', NULL, 1295, '1.9', 53043, 'Lincoln', '{\'53043\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99201, '47.66272', '-117.43617', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 13342, '1716.3', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99202, '47.65743', '-117.37908', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 21580, '1356.7', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99203, '47.62910', '-117.40327', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 20192, '1666.0', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99204, '47.64564', '-117.42712', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 6681, '2288.0', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99205, '47.69665', '-117.44624', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 42137, '1817.8', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99206, '47.62902', '-117.25488', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 34802, '574.1', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99207, '47.68896', '-117.38785', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 30854, '2186.9', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99208, '47.77992', '-117.46278', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 49193, '386.8', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99212, '47.66523', '-117.30916', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 19197, '610.6', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99216, '47.68000', '-117.20946', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 24362, '704.4', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99217, '47.73993', '-117.25678', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 17423, '131.8', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99218, '47.75954', '-117.40845', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 15531, '818.5', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99223, '47.59132', '-117.34475', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 29273, '394.8', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99224, '47.64882', '-117.53683', 'Spokane', 'WA', 'Washington', 'TRUE', NULL, 18289, '60.3', 53063, 'Spokane', '{\'53063\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99301, '46.38445', '-118.94383', 'Pasco', 'WA', 'Washington', 'TRUE', NULL, 68191, '56.7', 53021, 'Franklin', '{\'53021\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99320, '46.26522', '-119.48767', 'Benton City', 'WA', 'Washington', 'TRUE', NULL, 9201, '25.6', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99321, '46.87464', '-119.89278', 'Beverly', 'WA', 'Washington', 'TRUE', NULL, 531, '5.5', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99322, '45.94406', '-120.18079', 'Bickleton', 'WA', 'Washington', 'TRUE', NULL, 217, '0.3', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99323, '46.19237', '-118.84285', 'Burbank', 'WA', 'Washington', 'TRUE', NULL, 3684, '11.3', 53071, 'Walla Walla', '{\'53071\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99324, '46.04264', '-118.38662', 'College Place', 'WA', 'Washington', 'TRUE', NULL, 9202, '1163.2', 53071, 'Walla Walla', '{\'53071\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99326, '46.64978', '-118.85220', 'Connell', 'WA', 'Washington', 'TRUE', NULL, 4956, '7.0', 53021, 'Franklin', '{\'53001\':0.46,\'53021\':99.54}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99328, '46.25660', '-117.86548', 'Dayton', 'WA', 'Washington', 'TRUE', NULL, 3733, '2.2', 53013, 'Columbia', '{\'53013\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99329, '46.15643', '-118.14528', 'Dixie', 'WA', 'Washington', 'TRUE', NULL, 160, '33.8', 53071, 'Walla Walla', '{\'53071\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99330, '46.48973', '-119.04310', 'Eltopia', 'WA', 'Washington', 'TRUE', NULL, 907, '4.5', 53021, 'Franklin', '{\'53021\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99333, '46.69268', '-118.15021', 'Hooper', 'WA', 'Washington', 'TRUE', NULL, 50, '0.2', 53075, 'Whitman', '{\'53001\':32,\'53075\':68}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99335, '46.65368', '-118.47453', 'Kahlotus', 'WA', 'Washington', 'TRUE', NULL, 340, '0.8', 53021, 'Franklin', '{\'53021\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99336, '46.21377', '-119.17886', 'Kennewick', 'WA', 'Washington', 'TRUE', NULL, 48753, '1411.6', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99337, '46.07461', '-119.08614', 'Kennewick', 'WA', 'Washington', 'TRUE', NULL, 29845, '73.3', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99338, '46.14795', '-119.27355', 'Kennewick', 'WA', 'Washington', 'TRUE', NULL, 11555, '67.1', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99341, '46.91288', '-118.65310', 'Lind', 'WA', 'Washington', 'TRUE', NULL, 884, '0.9', 53001, 'Adams', '{\'53001\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99343, '46.59175', '-119.17942', 'Mesa', 'WA', 'Washington', 'TRUE', NULL, 3040, '7.1', 53021, 'Franklin', '{\'53021\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99344, '46.81646', '-119.17787', 'Othello', 'WA', 'Washington', 'TRUE', NULL, 16817, '14.3', 53001, 'Adams', '{\'53001\':87.27,\'53021\':4.44,\'53025\':8.3}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99345, '45.95266', '-119.68965', 'Paterson', 'WA', 'Washington', 'TRUE', NULL, 213, '0.5', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99346, '45.99828', '-119.30492', 'Plymouth', 'WA', 'Washington', 'TRUE', NULL, 352, '1.1', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99347, '46.42781', '-117.56645', 'Pomeroy', 'WA', 'Washington', 'TRUE', NULL, 2293, '1.2', 53023, 'Garfield', '{\'53013\':3.58,\'53023\':95.64,\'53075\':0.78}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99348, '46.38967', '-118.45180', 'Prescott', 'WA', 'Washington', 'TRUE', NULL, 1364, '1.0', 53071, 'Walla Walla', '{\'53013\':1.25,\'53071\':98.75}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99349, '46.73155', '-119.70123', 'Mattawa', 'WA', 'Washington', 'TRUE', NULL, 8483, '12.2', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99350, '46.18027', '-119.70515', 'Prosser', 'WA', 'Washington', 'TRUE', NULL, 12979, '8.8', 53005, 'Benton', '{\'53005\':97.83,\'53039\':1.43,\'53077\':0.73}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99352, '46.25224', '-119.28784', 'Richland', 'WA', 'Washington', 'TRUE', NULL, 26975, '494.1', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99353, '46.31671', '-119.37926', 'West Richland', 'WA', 'Washington', 'TRUE', NULL, 13306, '197.1', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99354, '46.32566', '-119.30670', 'Richland', 'WA', 'Washington', 'TRUE', NULL, 21343, '406.4', 53005, 'Benton', '{\'53005\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99356, '45.82125', '-120.31507', 'Roosevelt', 'WA', 'Washington', 'TRUE', NULL, 294, '0.5', 53039, 'Klickitat', '{\'53039\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99357, '46.89138', '-119.66058', 'Royal City', 'WA', 'Washington', 'TRUE', NULL, 4323, '7.2', 53025, 'Grant', '{\'53025\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99359, '46.52731', '-118.11118', 'Starbuck', 'WA', 'Washington', 'TRUE', NULL, 158, '0.7', 53013, 'Columbia', '{\'53013\':98.73,\'53021\':1.27}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99360, '46.09017', '-118.66293', 'Touchet', 'WA', 'Washington', 'TRUE', NULL, 1350, '3.3', 53071, 'Walla Walla', '{\'53071\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99361, '46.23672', '-118.14391', 'Waitsburg', 'WA', 'Washington', 'TRUE', NULL, 1902, '3.3', 53071, 'Walla Walla', '{\'53013\':4.73,\'53071\':95.27}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99362, '46.08931', '-118.30735', 'Walla Walla', 'WA', 'Washington', 'TRUE', NULL, 41056, '49.4', 53071, 'Walla Walla', '{\'41059\':0.11,\'53071\':99.89}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99363, '46.06652', '-118.88846', 'Wallula', 'WA', 'Washington', 'TRUE', NULL, 216, '1.9', 53071, 'Walla Walla', '{\'53071\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99371, '46.80678', '-118.31679', 'Washtucna', 'WA', 'Washington', 'TRUE', NULL, 311, '0.6', 53001, 'Adams', '{\'53001\':98.71,\'53021\':1.29}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99401, '46.08744', '-117.25143', 'Anatone', 'WA', 'Washington', 'TRUE', NULL, 273, '0.5', 53003, 'Asotin', '{\'53003\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99402, '46.19394', '-117.14740', 'Asotin', 'WA', 'Washington', 'TRUE', NULL, 1875, '2.5', 53003, 'Asotin', '{\'53003\':100}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99403, '46.37243', '-117.25274', 'Clarkston', 'WA', 'Washington', 'TRUE', NULL, 19548, '49.4', 53003, 'Asotin', '{\'53003\':99.63,\'53023\':0.37}', 'FALSE', 'FALSE', 'America/Los_Angeles'),
(99501, '61.22034', '-149.85703', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 17603, '979.2', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99502, '61.16330', '-149.98644', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 24168, '529.2', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99503, '61.90800', '-156.85739', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 14563, '271.9', 2020, 'Anchorage', '{\'02020\':99.93,\'02050\':0.07}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99504, '61.20399', '-149.74703', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 40914, '2480.1', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99505, '61.26576', '-149.63177', 'Jber', 'AK', 'Alaska', 'TRUE', NULL, 6174, '104.2', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99506, '61.26310', '-149.80534', 'Jber', 'AK', 'Alaska', 'TRUE', NULL, 7749, '168.9', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99507, '61.14974', '-149.77594', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 37850, '666.4', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99508, '61.20070', '-149.81447', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 35857, '1994.5', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99510, '70.13850', '-149.95982', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 353, '0.1', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99513, '61.21477', '-149.88566', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 0, '0.0', 2020, 'Anchorage', '{\'02020\':0}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99515, '61.11739', '-149.88889', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 22441, '818.8', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99516, '61.07142', '-149.71838', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 20095, '180.5', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99517, '61.19019', '-149.93710', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 16645, '1961.8', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99518, '61.15958', '-149.88479', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 10225, '1044.5', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99519, '68.93806', '-146.32364', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 1316, '0.0', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99540, '60.98606', '-149.43042', 'Indian', 'AK', 'Alaska', 'TRUE', NULL, 320, '2.4', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99546, '51.84287', '-176.63139', 'Adak', 'AK', 'Alaska', 'TRUE', NULL, 326, '9.2', 2016, 'Aleutians West', '{\'02016\':100}', 'FALSE', 'FALSE', 'America/Adak'),
(99547, '52.22953', '-174.20969', 'Atka', 'AK', 'Alaska', 'TRUE', NULL, 61, '2.8', 2016, 'Aleutians West', '{\'02016\':100}', 'FALSE', 'FALSE', 'America/Adak'),
(99548, '56.24475', '-158.75781', 'Chignik Lake', 'AK', 'Alaska', 'TRUE', NULL, 73, '3.2', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99549, '56.94163', '-158.60007', 'Port Heiden', 'AK', 'Alaska', 'TRUE', NULL, 102, '0.8', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99550, '57.90188', '-153.02841', 'Port Lions', 'AK', 'Alaska', 'TRUE', NULL, 197, '0.8', 2150, 'Kodiak Island', '{\'02150\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99551, '60.90924', '-161.42028', 'Akiachak', 'AK', 'Alaska', 'TRUE', NULL, 627, '133.2', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99552, '60.90988', '-161.22672', 'Akiak', 'AK', 'Alaska', 'TRUE', NULL, 346, '148.5', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99553, '54.12863', '-165.80591', 'Akutan', 'AK', 'Alaska', 'TRUE', NULL, 1027, '28.6', 2013, 'Aleutians East', '{\'02013\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99554, '62.69434', '-164.64753', 'Alakanuk', 'AK', 'Alaska', 'TRUE', NULL, 677, '11.7', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99555, '59.26833', '-158.62828', 'Aleknagik', 'AK', 'Alaska', 'TRUE', NULL, 221, '4.6', 2070, 'Dillingham', '{\'02070\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99556, '59.86781', '-151.49527', 'Anchor Point', 'AK', 'Alaska', 'TRUE', NULL, 2510, '2.7', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99557, '61.44112', '-156.01863', 'Aniak', 'AK', 'Alaska', 'TRUE', NULL, 726, '0.0', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99558, '62.63815', '-160.21788', 'Anvik', 'AK', 'Alaska', 'TRUE', NULL, 85, '4.6', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99559, '60.65431', '-161.90549', 'Bethel', 'AK', 'Alaska', 'TRUE', NULL, 7632, '50.9', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99561, '60.15138', '-164.25201', 'Chefornak', 'AK', 'Alaska', 'TRUE', NULL, 418, '30.1', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99563, '61.52910', '-165.59080', 'Chevak', 'AK', 'Alaska', 'TRUE', NULL, 938, '374.1', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99564, '56.29679', '-158.41292', 'Chignik', 'AK', 'Alaska', 'TRUE', NULL, 91, '3.1', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99565, '56.30376', '-158.52926', 'Chignik Lagoon', 'AK', 'Alaska', 'TRUE', NULL, 78, '2.2', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99566, '61.28097', '-142.78996', 'Chitina', 'AK', 'Alaska', 'TRUE', NULL, 192, '0.0', 2261, 'Valdez-Cordova', '{\'02261\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99567, '61.28823', '-148.89429', 'Chugiak', 'AK', 'Alaska', 'TRUE', NULL, 9211, '5.8', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99568, '60.21181', '-151.39605', 'Clam Gulch', 'AK', 'Alaska', 'TRUE', NULL, 279, '5.6', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99569, '58.81726', '-158.52852', 'Clarks Point', 'AK', 'Alaska', 'TRUE', NULL, 64, '3.3', 2070, 'Dillingham', '{\'02070\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99571, '55.38514', '-162.44829', 'Cold Bay', 'AK', 'Alaska', 'TRUE', NULL, 160, '2.1', 2013, 'Aleutians East', '{\'02013\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99572, '60.50805', '-149.93757', 'Cooper Landing', 'AK', 'Alaska', 'TRUE', NULL, 296, '0.8', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99573, '61.62257', '-145.99906', 'Copper Center', 'AK', 'Alaska', 'TRUE', NULL, 1115, '0.1', 2261, 'Valdez-Cordova', '{\'02261\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99574, '60.63146', '-146.04067', 'Cordova', 'AK', 'Alaska', 'TRUE', NULL, 2348, '0.4', 2261, 'Valdez-Cordova', '{\'02261\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99575, '61.84390', '-158.10825', 'Crooked Creek', 'AK', 'Alaska', 'TRUE', NULL, 105, '0.4', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99576, '59.99005', '-158.39443', 'Dillingham', 'AK', 'Alaska', 'TRUE', NULL, 2603, '0.1', 2070, 'Dillingham', '{\'02070\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99577, '61.19692', '-149.24656', 'Eagle River', 'AK', 'Alaska', 'TRUE', NULL, 25771, '46.3', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99578, '60.21584', '-162.03133', 'Eek', 'AK', 'Alaska', 'TRUE', NULL, 296, '128.0', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99579, '58.20677', '-157.37340', 'Egegik', 'AK', 'Alaska', 'TRUE', NULL, 109, '1.6', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99580, '59.36499', '-157.49239', 'Ekwok', 'AK', 'Alaska', 'TRUE', NULL, 115, '4.7', 2070, 'Dillingham', '{\'02070\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99581, '62.78176', '-164.53346', 'Emmonak', 'AK', 'Alaska', 'TRUE', NULL, 762, '46.3', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99583, '54.84751', '-163.40253', 'False Pass', 'AK', 'Alaska', 'TRUE', NULL, 35, '1.1', 2013, 'Aleutians East', '{\'02013\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99585, '61.92870', '-162.26797', 'Marshall', 'AK', 'Alaska', 'TRUE', NULL, 417, '3.3', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99586, '62.66800', '-144.11187', 'Gakona', 'AK', 'Alaska', 'TRUE', NULL, 605, '0.1', 2261, 'Valdez-Cordova', '{\'02261\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99587, '60.92414', '-148.92413', 'Girdwood', 'AK', 'Alaska', 'TRUE', NULL, 2250, '3.6', 2020, 'Anchorage', '{\'02020\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99588, '62.33380', '-146.72325', 'Glennallen', 'AK', 'Alaska', 'TRUE', NULL, 980, '0.2', 2261, 'Valdez-Cordova', '{\'02170\':8.78,\'02261\':91.22}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99589, '59.12749', '-161.56873', 'Goodnews Bay', 'AK', 'Alaska', 'TRUE', NULL, 243, '31.7', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99590, '62.89943', '-160.10725', 'Grayling', 'AK', 'Alaska', 'TRUE', NULL, 194, '6.8', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99591, '56.58095', '-169.61540', 'Saint George Island', 'AK', 'Alaska', 'TRUE', NULL, 102, '1.1', 2016, 'Aleutians West', '{\'02016\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99602, '62.18469', '-159.84468', 'Holy Cross', 'AK', 'Alaska', 'TRUE', NULL, 178, '2.7', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99603, '59.52457', '-151.22871', 'Homer', 'AK', 'Alaska', 'TRUE', NULL, 9840, '3.5', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99604, '61.52785', '-166.11506', 'Hooper Bay', 'AK', 'Alaska', 'TRUE', NULL, 1093, '53.1', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99605, '60.79358', '-149.54918', 'Hope', 'AK', 'Alaska', 'TRUE', NULL, 211, '0.3', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99606, '59.79423', '-154.64428', 'Iliamna', 'AK', 'Alaska', 'TRUE', NULL, 469, '0.9', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99607, '61.75722', '-159.78569', 'Kalskag', 'AK', 'Alaska', 'TRUE', NULL, 216, '0.1', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99609, '60.87848', '-162.52724', 'Kasigluk', 'AK', 'Alaska', 'TRUE', NULL, 569, '18.6', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99610, '60.24933', '-150.42907', 'Kasilof', 'AK', 'Alaska', 'TRUE', NULL, 2167, '0.9', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99611, '60.71832', '-150.98582', 'Kenai', 'AK', 'Alaska', 'TRUE', NULL, 15122, '17.9', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99612, '55.06330', '-162.28780', 'King Cove', 'AK', 'Alaska', 'TRUE', NULL, 938, '30.9', 2013, 'Aleutians East', '{\'02013\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99613, '58.98854', '-155.56022', 'King Salmon', 'AK', 'Alaska', 'TRUE', NULL, 434, '0.0', 2060, 'Bristol Bay', '{\'02060\':86.18,\'02164\':13.82}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99614, '59.93632', '-164.06128', 'Kipnuk', 'AK', 'Alaska', 'TRUE', NULL, 639, '12.3', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome');
INSERT INTO `us_zip` (`zip`, `lat`, `lng`, `city`, `state_id`, `state_name`, `zcta`, `parent_zcta`, `population`, `density`, `county_fips`, `county_name`, `all_county_weights`, `imprecise`, `military`, `timezone`) VALUES
(99615, '57.58324', '-153.40115', 'Kodiak', 'AK', 'Alaska', 'TRUE', NULL, 12899, '1.2', 2150, 'Kodiak Island', '{\'02150\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99620, '63.02925', '-163.54615', 'Kotlik', 'AK', 'Alaska', 'TRUE', NULL, 577, '96.8', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99621, '60.79512', '-161.40056', 'Kwethluk', 'AK', 'Alaska', 'TRUE', NULL, 723, '29.4', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99622, '59.87422', '-163.20433', 'Kwigillingok', 'AK', 'Alaska', 'TRUE', NULL, 321, '8.0', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99624, '57.50398', '-153.90700', 'Larsen Bay', 'AK', 'Alaska', 'TRUE', NULL, 90, '2.3', 2150, 'Kodiak Island', '{\'02150\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99625, '59.28919', '-156.65062', 'Levelock', 'AK', 'Alaska', 'TRUE', NULL, 72, '0.0', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99626, '61.51701', '-160.36464', 'Lower Kalskag', 'AK', 'Alaska', 'TRUE', NULL, 282, '118.0', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99627, '63.53162', '-154.62939', 'Mc Grath', 'AK', 'Alaska', 'TRUE', NULL, 406, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99628, '58.95135', '-159.17597', 'Manokotak', 'AK', 'Alaska', 'TRUE', NULL, 443, '0.1', 2070, 'Dillingham', '{\'02070\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99630, '60.37195', '-166.26384', 'Mekoryuk', 'AK', 'Alaska', 'TRUE', NULL, 191, '11.6', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99631, '60.61490', '-149.40537', 'Moose Pass', 'AK', 'Alaska', 'TRUE', NULL, 228, '0.2', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99632, '62.11233', '-163.66455', 'Mountain Village', 'AK', 'Alaska', 'TRUE', NULL, 813, '12.5', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99633, '58.78297', '-156.89840', 'Naknek', 'AK', 'Alaska', 'TRUE', NULL, 544, '2.6', 2060, 'Bristol Bay', '{\'02060\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99634, '60.68819', '-161.99029', 'Napakiak', 'AK', 'Alaska', 'TRUE', NULL, 354, '35.0', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99636, '59.48829', '-157.29135', 'New Stuyahok', 'AK', 'Alaska', 'TRUE', NULL, 510, '9.0', 2070, 'Dillingham', '{\'02070\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99637, '60.54299', '-165.14307', 'Toksook Bay', 'AK', 'Alaska', 'TRUE', NULL, 590, '7.5', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99638, '52.89995', '-168.93738', 'Nikolski', 'AK', 'Alaska', 'TRUE', NULL, 18, '0.4', 2016, 'Aleutians West', '{\'02016\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99639, '60.06779', '-151.40405', 'Ninilchik', 'AK', 'Alaska', 'TRUE', NULL, 1131, '2.0', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99640, '60.30969', '-155.22854', 'Nondalton', 'AK', 'Alaska', 'TRUE', NULL, 174, '0.0', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99641, '60.88727', '-162.46287', 'Nunapitchuk', 'AK', 'Alaska', 'TRUE', NULL, 496, '41.6', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99643, '57.21752', '-153.34435', 'Old Harbor', 'AK', 'Alaska', 'TRUE', NULL, 218, '4.2', 2150, 'Kodiak Island', '{\'02150\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99644, '57.92410', '-152.42219', 'Ouzinkie', 'AK', 'Alaska', 'TRUE', NULL, 175, '4.1', 2150, 'Kodiak Island', '{\'02150\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99645, '61.63030', '-148.98707', 'Palmer', 'AK', 'Alaska', 'TRUE', NULL, 25176, '22.0', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99647, '59.86805', '-154.07572', 'Pedro Bay', 'AK', 'Alaska', 'TRUE', NULL, 44, '0.1', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99648, '55.93061', '-159.15742', 'Perryville', 'AK', 'Alaska', 'TRUE', NULL, 113, '3.9', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99649, '57.50950', '-157.32223', 'Pilot Point', 'AK', 'Alaska', 'TRUE', NULL, 80, '0.3', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99650, '61.94218', '-162.88560', 'Pilot Station', 'AK', 'Alaska', 'TRUE', NULL, 568, '130.9', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99651, '59.00959', '-161.71179', 'Platinum', 'AK', 'Alaska', 'TRUE', NULL, 61, '1.1', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99652, '61.53464', '-149.97231', 'Big Lake', 'AK', 'Alaska', 'TRUE', NULL, 3703, '12.3', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99653, '60.19559', '-154.32566', 'Port Alsworth', 'AK', 'Alaska', 'TRUE', NULL, 159, '2.7', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99654, '61.45483', '-149.90045', 'Wasilla', 'AK', 'Alaska', 'TRUE', NULL, 52168, '40.4', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99655, '59.74740', '-161.88903', 'Quinhagak', 'AK', 'Alaska', 'TRUE', NULL, 669, '96.6', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99656, '61.85726', '-157.54480', 'Red Devil', 'AK', 'Alaska', 'TRUE', NULL, 25, '0.1', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99657, '61.77418', '-161.39437', 'Russian Mission', 'AK', 'Alaska', 'TRUE', NULL, 329, '0.2', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99658, '62.07635', '-163.28388', 'Saint Marys', 'AK', 'Alaska', 'TRUE', NULL, 616, '5.6', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99659, '63.47380', '-162.12295', 'Saint Michael', 'AK', 'Alaska', 'TRUE', NULL, 401, '8.3', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99660, '57.18133', '-170.28475', 'Saint Paul Island', 'AK', 'Alaska', 'TRUE', NULL, 479, '4.6', 2016, 'Aleutians West', '{\'02016\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99661, '55.27154', '-160.67506', 'Sand Point', 'AK', 'Alaska', 'TRUE', NULL, 978, '2.1', 2013, 'Aleutians East', '{\'02013\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99662, '61.79180', '-165.96119', 'Scammon Bay', 'AK', 'Alaska', 'TRUE', NULL, 480, '25.9', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99663, '59.39411', '-151.62731', 'Seldovia', 'AK', 'Alaska', 'TRUE', NULL, 414, '1.4', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99664, '60.10788', '-149.48482', 'Seward', 'AK', 'Alaska', 'TRUE', NULL, 4932, '0.7', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99665, '62.64631', '-159.52727', 'Shageluk', 'AK', 'Alaska', 'TRUE', NULL, 83, '16.6', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99666, '62.45302', '-165.09876', 'Nunam Iqua', 'AK', 'Alaska', 'TRUE', NULL, 189, '0.9', 2270, 'Wade Hampton', '{\'02270\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99667, '61.82397', '-151.78291', 'Skwentna', 'AK', 'Alaska', 'TRUE', NULL, 65, '0.0', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99668, '61.68735', '-157.13723', 'Sleetmute', 'AK', 'Alaska', 'TRUE', NULL, 86, '2.3', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99669, '60.41451', '-151.00342', 'Soldotna', 'AK', 'Alaska', 'TRUE', NULL, 14191, '22.6', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99670, '58.66586', '-156.97213', 'South Naknek', 'AK', 'Alaska', 'TRUE', NULL, 79, '0.3', 2060, 'Bristol Bay', '{\'02060\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99671, '63.48177', '-162.25364', 'Stebbins', 'AK', 'Alaska', 'TRUE', NULL, 556, '8.4', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99672, '60.73292', '-150.72816', 'Sterling', 'AK', 'Alaska', 'TRUE', NULL, 3704, '5.0', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99674, '61.70957', '-148.16000', 'Sutton', 'AK', 'Alaska', 'TRUE', NULL, 1444, '0.5', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99676, '62.45787', '-149.70390', 'Talkeetna', 'AK', 'Alaska', 'TRUE', NULL, 1546, '0.6', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99677, '60.89214', '-146.67253', 'Tatitlek', 'AK', 'Alaska', 'TRUE', NULL, 88, '4.7', 2261, 'Valdez-Cordova', '{\'02261\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99678, '59.33282', '-160.10847', 'Togiak', 'AK', 'Alaska', 'TRUE', NULL, 891, '0.2', 2070, 'Dillingham', '{\'02070\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99679, '61.10122', '-160.94445', 'Tuluksak', 'AK', 'Alaska', 'TRUE', NULL, 373, '93.9', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99680, '60.38433', '-162.68383', 'Tuntutuliak', 'AK', 'Alaska', 'TRUE', NULL, 408, '1.4', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99681, '60.60681', '-165.12855', 'Tununak', 'AK', 'Alaska', 'TRUE', NULL, 325, '3.8', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99682, '60.62609', '-152.78508', 'Tyonek', 'AK', 'Alaska', 'TRUE', NULL, 373, '0.0', 2122, 'Kenai Peninsula', '{\'02122\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99683, '62.50180', '-151.00456', 'Trapper Creek', 'AK', 'Alaska', 'TRUE', NULL, 524, '0.1', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99684, '64.08944', '-160.33049', 'Unalakleet', 'AK', 'Alaska', 'TRUE', NULL, 688, '0.4', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99685, '53.87601', '-166.47449', 'Unalaska', 'AK', 'Alaska', 'TRUE', NULL, 4224, '27.5', 2016, 'Aleutians West', '{\'02016\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99686, '61.12201', '-146.82103', 'Valdez', 'AK', 'Alaska', 'TRUE', NULL, 4005, '0.5', 2261, 'Valdez-Cordova', '{\'02261\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99688, '61.90932', '-150.03683', 'Willow', 'AK', 'Alaska', 'TRUE', NULL, 2759, '0.7', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99689, '59.52058', '-139.48834', 'Yakutat', 'AK', 'Alaska', 'TRUE', NULL, 662, '1.2', 2282, 'Yakutat', '{\'02282\':100}', 'FALSE', 'FALSE', 'America/Yakutat'),
(99690, '60.48717', '-164.81892', 'Nightmute', 'AK', 'Alaska', 'TRUE', NULL, 280, '1.1', 2050, 'Bethel', '{\'02050\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99691, '62.86380', '-153.66045', 'Nikolai', 'AK', 'Alaska', 'TRUE', NULL, 95, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99692, '53.88553', '-166.53864', 'Dutch Harbor', 'AK', 'Alaska', 'TRUE', NULL, 152, '217.7', 2016, 'Aleutians West', '{\'02016\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99693, '61.38199', '-148.52105', 'Whittier', 'AK', 'Alaska', 'TRUE', NULL, 248, '0.8', 2261, 'Valdez-Cordova', '{\'02170\':0,\'02261\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99694, '61.62109', '-149.79624', 'Houston', 'AK', 'Alaska', 'TRUE', NULL, 1512, '29.0', 2170, 'Matanuska-Susitna', '{\'02170\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99695, '55.91828', '-159.49335', 'Anchorage', 'AK', 'Alaska', 'TRUE', NULL, 7, '0.6', 2164, 'Lake and Peninsula', '{\'02164\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99701, '67.16977', '-149.56917', 'Fairbanks', 'AK', 'Alaska', 'TRUE', NULL, 19019, '1.7', 2090, 'Fairbanks North Star', '{\'02090\':99.72,\'02290\':0.28}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99702, '64.64824', '-147.04901', 'Eielson Afb', 'AK', 'Alaska', 'TRUE', NULL, 2647, '63.3', 2090, 'Fairbanks North Star', '{\'02090\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99703, '64.83280', '-147.62322', 'Fort Wainwright', 'AK', 'Alaska', 'TRUE', NULL, 7065, '311.4', 2090, 'Fairbanks North Star', '{\'02090\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99704, '64.29661', '-149.16065', 'Clear', 'AK', 'Alaska', 'TRUE', NULL, 24, '9.6', 2068, 'Denali', '{\'02068\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99705, '64.76238', '-147.31214', 'North Pole', 'AK', 'Alaska', 'TRUE', NULL, 22544, '81.3', 2090, 'Fairbanks North Star', '{\'02090\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99706, '64.02799', '-144.63394', 'Fairbanks', 'AK', 'Alaska', 'TRUE', NULL, 13, '0.1', 2240, 'Southeast Fairbanks', '{\'02240\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99709, '64.87812', '-148.21562', 'Fairbanks', 'AK', 'Alaska', 'TRUE', NULL, 29830, '22.6', 2090, 'Fairbanks North Star', '{\'02090\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99712, '64.99325', '-146.14966', 'Fairbanks', 'AK', 'Alaska', 'TRUE', NULL, 13866, '1.5', 2090, 'Fairbanks North Star', '{\'02090\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99714, '64.43270', '-146.67126', 'Salcha', 'AK', 'Alaska', 'TRUE', NULL, 1385, '1.5', 2090, 'Fairbanks North Star', '{\'02090\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99720, '66.56354', '-152.77604', 'Allakaket', 'AK', 'Alaska', 'TRUE', NULL, 208, '1.8', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99721, '68.15449', '-151.70963', 'Anaktuvuk Pass', 'AK', 'Alaska', 'TRUE', NULL, 324, '25.9', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99722, '68.09545', '-145.61021', 'Arctic Village', 'AK', 'Alaska', 'TRUE', NULL, 152, '5.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99723, '71.27374', '-156.74527', 'Barrow', 'AK', 'Alaska', 'TRUE', NULL, 4213, '78.2', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99724, '66.38310', '-147.32171', 'Beaver', 'AK', 'Alaska', 'TRUE', NULL, 84, '1.6', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99726, '67.11836', '-152.15662', 'Bettles Field', 'AK', 'Alaska', 'TRUE', NULL, 30, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99727, '65.97593', '-161.13864', 'Buckland', 'AK', 'Alaska', 'TRUE', NULL, 416, '290.5', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99729, '63.18324', '-148.50252', 'Cantwell', 'AK', 'Alaska', 'TRUE', NULL, 231, '0.1', 2068, 'Denali', '{\'02068\':94.81,\'02170\':5.19}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99730, '65.61511', '-145.25129', 'Central', 'AK', 'Alaska', 'TRUE', NULL, 144, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99732, '64.07170', '-142.00646', 'Chicken', 'AK', 'Alaska', 'TRUE', NULL, 10, '0.0', 2240, 'Southeast Fairbanks', '{\'02240\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99733, '65.79284', '-144.18282', 'Circle', 'AK', 'Alaska', 'TRUE', NULL, 104, '0.4', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99734, '70.36853', '-148.99198', 'Prudhoe Bay', 'AK', 'Alaska', 'TRUE', NULL, 845, '1.6', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99736, '66.08489', '-162.76104', 'Deering', 'AK', 'Alaska', 'TRUE', NULL, 122, '28.6', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99737, '63.79602', '-145.07328', 'Delta Junction', 'AK', 'Alaska', 'TRUE', NULL, 5011, '0.5', 2240, 'Southeast Fairbanks', '{\'02240\':99.14,\'02261\':0.86}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99738, '65.20895', '-142.18305', 'Eagle', 'AK', 'Alaska', 'TRUE', NULL, 187, '0.0', 2240, 'Southeast Fairbanks', '{\'02240\':100,\'02290\':0}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99739, '64.96744', '-162.54858', 'Elim', 'AK', 'Alaska', 'TRUE', NULL, 330, '0.1', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99740, '67.53438', '-143.74520', 'Fort Yukon', 'AK', 'Alaska', 'TRUE', NULL, 585, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99741, '64.73878', '-156.85877', 'Galena', 'AK', 'Alaska', 'TRUE', NULL, 470, '10.2', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99742, '63.75233', '-171.68815', 'Gambell', 'AK', 'Alaska', 'TRUE', NULL, 681, '24.1', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99743, '63.78380', '-150.12793', 'Healy', 'AK', 'Alaska', 'TRUE', NULL, 1069, '0.1', 2068, 'Denali', '{\'02068\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99744, '64.30629', '-149.18013', 'Anderson', 'AK', 'Alaska', 'TRUE', NULL, 226, '2.7', 2068, 'Denali', '{\'02068\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99745, '66.04305', '-154.24774', 'Hughes', 'AK', 'Alaska', 'TRUE', NULL, 78, '7.4', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99746, '65.57287', '-158.11930', 'Huslia', 'AK', 'Alaska', 'TRUE', NULL, 277, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99747, '70.11849', '-143.66337', 'Kaktovik', 'AK', 'Alaska', 'TRUE', NULL, 239, '15.4', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99748, '64.32645', '-158.76757', 'Kaltag', 'AK', 'Alaska', 'TRUE', NULL, 190, '4.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99749, '66.97844', '-160.43177', 'Kiana', 'AK', 'Alaska', 'TRUE', NULL, 363, '126.7', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99750, '67.73197', '-164.55110', 'Kivalina', 'AK', 'Alaska', 'TRUE', NULL, 374, '775.6', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99751, '66.91926', '-156.87003', 'Kobuk', 'AK', 'Alaska', 'TRUE', NULL, 151, '10.2', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99752, '67.29139', '-161.98517', 'Kotzebue', 'AK', 'Alaska', 'TRUE', NULL, 3553, '0.3', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99753, '64.93968', '-161.15126', 'Koyuk', 'AK', 'Alaska', 'TRUE', NULL, 332, '26.9', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99754, '64.90102', '-157.69469', 'Koyukuk', 'AK', 'Alaska', 'TRUE', NULL, 96, '6.4', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99755, '63.69990', '-148.62166', 'Denali National Park', 'AK', 'Alaska', 'TRUE', NULL, 217, '0.2', 2068, 'Denali', '{\'02068\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99756, '64.58632', '-151.84676', 'Manley Hot Springs', 'AK', 'Alaska', 'TRUE', NULL, 119, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99757, '63.75100', '-152.75093', 'Lake Minchumina', 'AK', 'Alaska', 'TRUE', NULL, 17, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99758, '65.15174', '-149.37233', 'Minto', 'AK', 'Alaska', 'TRUE', NULL, 210, '26.8', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99759, '69.73125', '-162.89793', 'Point Lay', 'AK', 'Alaska', 'TRUE', NULL, 189, '2.8', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99760, '64.21368', '-148.23073', 'Nenana', 'AK', 'Alaska', 'TRUE', NULL, 785, '0.1', 2068, 'Denali', '{\'02068\':9.04,\'02090\':3.57,\'02290\':87.39}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99761, '67.60041', '-163.03459', 'Noatak', 'AK', 'Alaska', 'TRUE', NULL, 514, '12.5', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99762, '64.84572', '-164.46635', 'Nome', 'AK', 'Alaska', 'TRUE', NULL, 4038, '0.7', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99763, '66.82849', '-161.03645', 'Noorvik', 'AK', 'Alaska', 'TRUE', NULL, 668, '302.8', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99764, '63.38147', '-141.51133', 'Northway', 'AK', 'Alaska', 'TRUE', NULL, 290, '0.0', 2240, 'Southeast Fairbanks', '{\'02240\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99765, '64.72925', '-158.13237', 'Nulato', 'AK', 'Alaska', 'TRUE', NULL, 264, '14.9', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99766, '68.65065', '-164.95842', 'Point Hope', 'AK', 'Alaska', 'TRUE', NULL, 678, '0.1', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99767, '65.50221', '-150.15119', 'Rampart', 'AK', 'Alaska', 'TRUE', NULL, 24, '4.8', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99768, '65.11676', '-154.87990', 'Ruby', 'AK', 'Alaska', 'TRUE', NULL, 175, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99769, '63.67959', '-170.48517', 'Savoonga', 'AK', 'Alaska', 'TRUE', NULL, 671, '45.1', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99770, '66.76682', '-159.47864', 'Selawik', 'AK', 'Alaska', 'TRUE', NULL, 841, '0.4', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99771, '64.36188', '-161.20628', 'Shaktoolik', 'AK', 'Alaska', 'TRUE', NULL, 251, '100.1', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99772, '65.98303', '-165.79795', 'Shishmaref', 'AK', 'Alaska', 'TRUE', NULL, 567, '0.1', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99773, '66.88754', '-157.16496', 'Shungnak', 'AK', 'Alaska', 'TRUE', NULL, 262, '16.9', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99774, '66.01943', '-149.07688', 'Stevens Village', 'AK', 'Alaska', 'TRUE', NULL, 78, '2.5', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99775, '64.85821', '-147.82482', 'Fairbanks', 'AK', 'Alaska', 'TRUE', NULL, 1251, '4142.4', 2090, 'Fairbanks North Star', '{\'02090\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99776, '63.38825', '-143.41140', 'Tanacross', 'AK', 'Alaska', 'TRUE', NULL, 124, '2.3', 2240, 'Southeast Fairbanks', '{\'02240\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99777, '65.20884', '-152.05621', 'Tanana', 'AK', 'Alaska', 'TRUE', NULL, 246, '3.9', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99778, '65.15448', '-166.29711', 'Teller', 'AK', 'Alaska', 'TRUE', NULL, 254, '0.3', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99780, '63.19467', '-143.07798', 'Tok', 'AK', 'Alaska', 'TRUE', NULL, 1535, '0.5', 2240, 'Southeast Fairbanks', '{\'02240\':93.62,\'02261\':6.38}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99781, '67.47706', '-146.01946', 'Venetie', 'AK', 'Alaska', 'TRUE', NULL, 167, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99782, '70.64066', '-159.93042', 'Wainwright', 'AK', 'Alaska', 'TRUE', NULL, 556, '12.0', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99783, '65.66335', '-168.02324', 'Wales', 'AK', 'Alaska', 'TRUE', NULL, 145, '2.3', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99784, '64.68209', '-163.40586', 'White Mountain', 'AK', 'Alaska', 'TRUE', NULL, 190, '105.0', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99785, '65.34195', '-166.49262', 'Brevig Mission', 'AK', 'Alaska', 'TRUE', NULL, 388, '60.5', 2180, 'Nome', '{\'02180\':100}', 'FALSE', 'FALSE', 'America/Nome'),
(99786, '67.17316', '-155.95418', 'Ambler', 'AK', 'Alaska', 'TRUE', NULL, 259, '0.0', 2188, 'Northwest Arctic', '{\'02188\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99788, '66.64632', '-143.78140', 'Chalkyitsik', 'AK', 'Alaska', 'TRUE', NULL, 69, '3.1', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99789, '70.02976', '-151.86118', 'Nuiqsut', 'AK', 'Alaska', 'TRUE', NULL, 402, '0.2', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99790, '65.42128', '-148.28801', 'Fairbanks', 'AK', 'Alaska', 'TRUE', NULL, 20, '0.0', 2290, 'Yukon-Koyukuk', '{\'02290\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99791, '70.56099', '-156.63867', 'Atqasuk', 'AK', 'Alaska', 'TRUE', NULL, 237, '0.1', 2185, 'North Slope', '{\'02185\':100}', 'FALSE', 'FALSE', 'America/Anchorage'),
(99801, '58.39768', '-134.05518', 'Juneau', 'AK', 'Alaska', 'TRUE', NULL, 29164, '5.1', 2110, 'Juneau', '{\'02110\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99820, '57.43987', '-134.19674', 'Angoon', 'AK', 'Alaska', 'TRUE', NULL, 479, '0.2', 2105, 'Hoonah-Angoon', '{\'02105\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99824, '58.27235', '-134.40083', 'Douglas', 'AK', 'Alaska', 'TRUE', NULL, 2111, '472.0', 2110, 'Juneau', '{\'02110\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99825, '58.13599', '-135.87267', 'Elfin Cove', 'AK', 'Alaska', 'TRUE', NULL, 120, '0.1', 2105, 'Hoonah-Angoon', '{\'02105\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99826, '58.75176', '-136.56804', 'Gustavus', 'AK', 'Alaska', 'TRUE', NULL, 442, '0.1', 2105, 'Hoonah-Angoon', '{\'02105\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99827, '59.12421', '-135.70688', 'Haines', 'AK', 'Alaska', 'TRUE', NULL, 2602, '0.6', 2100, 'Haines', '{\'02100\':96.35,\'02105\':3.65}', 'FALSE', 'FALSE', 'America/Juneau'),
(99829, '58.10737', '-135.42584', 'Hoonah', 'AK', 'Alaska', 'TRUE', NULL, 777, '40.3', 2105, 'Hoonah-Angoon', '{\'02105\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99830, '56.77902', '-134.16028', 'Kake', 'AK', 'Alaska', 'TRUE', NULL, 561, '0.8', 2195, 'Petersburg', '{\'02195\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99832, '58.01535', '-136.17832', 'Pelican', 'AK', 'Alaska', 'TRUE', NULL, 104, '0.2', 2105, 'Hoonah-Angoon', '{\'02105\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99833, '56.88522', '-133.08514', 'Petersburg', 'AK', 'Alaska', 'TRUE', NULL, 3202, '0.5', 2195, 'Petersburg', '{\'02195\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99835, '56.96056', '-135.05446', 'Sitka', 'AK', 'Alaska', 'TRUE', NULL, 8880, '2.1', 2220, 'Sitka', '{\'02220\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99836, '56.23551', '-134.65334', 'Port Alexander', 'AK', 'Alaska', 'TRUE', NULL, 52, '5.7', 2195, 'Petersburg', '{\'02195\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99840, '59.56292', '-135.33619', 'Skagway', 'AK', 'Alaska', 'TRUE', NULL, 968, '0.9', 2230, 'Skagway', '{\'02230\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99841, '57.79433', '-135.18487', 'Tenakee Springs', 'AK', 'Alaska', 'TRUE', NULL, 133, '3.6', 2105, 'Hoonah-Angoon', '{\'02105\':100}', 'FALSE', 'FALSE', 'America/Juneau'),
(99901, '55.56908', '-131.01272', 'Ketchikan', 'AK', 'Alaska', 'TRUE', NULL, 13508, '1.1', 2130, 'Ketchikan Gateway', '{\'02130\':99.76,\'02198\':0.24}', 'FALSE', 'FALSE', 'America/Sitka'),
(99903, '55.82123', '-132.05943', 'Meyers Chuck', 'AK', 'Alaska', 'TRUE', NULL, 31, '0.1', 2275, 'Wrangell', '{\'02275\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99918, '55.94573', '-132.74167', 'Coffman Cove', 'AK', 'Alaska', 'TRUE', NULL, 231, '2.5', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99919, '55.65107', '-132.50368', 'Thorne Bay', 'AK', 'Alaska', 'TRUE', NULL, 531, '4.2', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99921, '55.45479', '-132.77209', 'Craig', 'AK', 'Alaska', 'TRUE', NULL, 1920, '0.4', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99922, '55.30211', '-133.03248', 'Hydaburg', 'AK', 'Alaska', 'TRUE', NULL, 384, '1.3', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99923, '55.97796', '-130.03671', 'Hyder', 'AK', 'Alaska', 'TRUE', NULL, 87, '2.1', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99925, '55.55767', '-132.97627', 'Klawock', 'AK', 'Alaska', 'TRUE', NULL, 819, '5.7', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99926, '55.12617', '-131.48928', 'Metlakatla', 'AK', 'Alaska', 'TRUE', NULL, 1460, '4.2', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Metlakatla'),
(99927, '56.25100', '-133.37571', 'Point Baker', 'AK', 'Alaska', 'TRUE', NULL, 94, '0.2', 2198, 'Prince of Wales-Hyder', '{\'02198\':100}', 'FALSE', 'FALSE', 'America/Sitka'),
(99929, '56.36950', '-131.93648', 'Wrangell', 'AK', 'Alaska', 'TRUE', NULL, 2338, '0.4', 2275, 'Wrangell', '{\'02275\':100}', 'FALSE', 'FALSE', 'America/Sitka');

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

--
-- Table structure for table `vendor`
--

CREATE TABLE `vendor` (
  `vendor_id` int(11) NOT NULL,
  `vendor_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_company` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_address` text COLLATE utf8_unicode_ci,
  `vendor_county` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_zip` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendor_is_delete` int(1) DEFAULT NULL,
  `is_approve` int(1) DEFAULT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `alert_id` int(11) DEFAULT NULL,
  `approve_time` datetime DEFAULT NULL,
  `vendor_time` datetime NOT NULL,
  `is_list` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `vendor_pay`
--

CREATE TABLE `vendor_pay` (
  `id` int(11) NOT NULL,
  `pay_date` datetime NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `pay_amount` decimal(8,2) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `time` datetime NOT NULL,
  `is_delete` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `vendor_pay_settle`
--

CREATE TABLE `vendor_pay_settle` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `ref_no` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `pay_date` datetime NOT NULL,
  `create_time` datetime NOT NULL,
  `status` int(1) NOT NULL,
  `transact_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `instrument_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_alert`
--
ALTER TABLE `admin_alert`
  ADD PRIMARY KEY (`admin_alert_id`);

--
-- Indexes for table `audit_upload_details`
--
ALTER TABLE `audit_upload_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bid`
--
ALTER TABLE `bid`
  ADD PRIMARY KEY (`bid_id`);

--
-- Indexes for table `bid_actual_image`
--
ALTER TABLE `bid_actual_image`
  ADD PRIMARY KEY (`image_id`);

--
-- Indexes for table `bid_item`
--
ALTER TABLE `bid_item`
  ADD PRIMARY KEY (`bid_item_id`);

--
-- Indexes for table `bid_item_uom_value`
--
ALTER TABLE `bid_item_uom_value`
  ADD PRIMARY KEY (`bid_item_uom_value_id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`cat_id`);

--
-- Indexes for table `change_log`
--
ALTER TABLE `change_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `client`
--
ALTER TABLE `client`
  ADD PRIMARY KEY (`client_id`);

--
-- Indexes for table `client_email_pay_settle_fail`
--
ALTER TABLE `client_email_pay_settle_fail`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `client_pay_fetch_inbox`
--
ALTER TABLE `client_pay_fetch_inbox`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `client_pay_mail_cron_status`
--
ALTER TABLE `client_pay_mail_cron_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `client_pay_settle`
--
ALTER TABLE `client_pay_settle`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `client_pay_settle_email`
--
ALTER TABLE `client_pay_settle_email`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_parsed`
--
ALTER TABLE `email_parsed`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`invoice_id`);

--
-- Indexes for table `invoice_actual_image`
--
ALTER TABLE `invoice_actual_image`
  ADD PRIMARY KEY (`image_id`);

--
-- Indexes for table `invoice_item`
--
ALTER TABLE `invoice_item`
  ADD PRIMARY KEY (`invoice_item_id`);

--
-- Indexes for table `invoice_item_uom_value`
--
ALTER TABLE `invoice_item_uom_value`
  ADD PRIMARY KEY (`invoice_item_uom_value_id`);

--
-- Indexes for table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`log_id`);

--
-- Indexes for table `maps`
--
ALTER TABLE `maps`
  ADD PRIMARY KEY (`maps_id`);

--
-- Indexes for table `maps_group`
--
ALTER TABLE `maps_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `maps_uom_value`
--
ALTER TABLE `maps_uom_value`
  ADD PRIMARY KEY (`maps_uom_value_id`);

--
-- Indexes for table `pdf_admin_data`
--
ALTER TABLE `pdf_admin_data`
  ADD PRIMARY KEY (`pdf_admin_id`);

--
-- Indexes for table `property`
--
ALTER TABLE `property`
  ADD PRIMARY KEY (`prop_id`);

--
-- Indexes for table `prop_assign`
--
ALTER TABLE `prop_assign`
  ADD PRIMARY KEY (`propr_assign_id`);

--
-- Indexes for table `staff_pay`
--
ALTER TABLE `staff_pay`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `uom`
--
ALTER TABLE `uom`
  ADD PRIMARY KEY (`uom_id`);

--
-- Indexes for table `uom_field`
--
ALTER TABLE `uom_field`
  ADD PRIMARY KEY (`uom_field_id`);

--
-- Indexes for table `us_zip`
--
ALTER TABLE `us_zip`
  ADD PRIMARY KEY (`zip`);

--
-- Indexes for table `vendor`
--
ALTER TABLE `vendor`
  ADD PRIMARY KEY (`vendor_id`);

--
-- Indexes for table `vendor_pay`
--
ALTER TABLE `vendor_pay`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vendor_pay_settle`
--
ALTER TABLE `vendor_pay_settle`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_alert`
--
ALTER TABLE `admin_alert`
  MODIFY `admin_alert_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `audit_upload_details`
--
ALTER TABLE `audit_upload_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bid`
--
ALTER TABLE `bid`
  MODIFY `bid_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `bid_actual_image`
--
ALTER TABLE `bid_actual_image`
  MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bid_item`
--
ALTER TABLE `bid_item`
  MODIFY `bid_item_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bid_item_uom_value`
--
ALTER TABLE `bid_item_uom_value`
  MODIFY `bid_item_uom_value_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `change_log`
--
ALTER TABLE `change_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `client`
--
ALTER TABLE `client`
  MODIFY `client_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `client_email_pay_settle_fail`
--
ALTER TABLE `client_email_pay_settle_fail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `client_pay_fetch_inbox`
--
ALTER TABLE `client_pay_fetch_inbox`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `client_pay_mail_cron_status`
--
ALTER TABLE `client_pay_mail_cron_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10466;

--
-- AUTO_INCREMENT for table `client_pay_settle`
--
ALTER TABLE `client_pay_settle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `client_pay_settle_email`
--
ALTER TABLE `client_pay_settle_email`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `email_parsed`
--
ALTER TABLE `email_parsed`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
  MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `invoice_actual_image`
--
ALTER TABLE `invoice_actual_image`
  MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_item`
--
ALTER TABLE `invoice_item`
  MODIFY `invoice_item_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_item_uom_value`
--
ALTER TABLE `invoice_item_uom_value`
  MODIFY `invoice_item_uom_value_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `log_id` int(25) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `maps`
--
ALTER TABLE `maps`
  MODIFY `maps_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5860;

--
-- AUTO_INCREMENT for table `maps_group`
--
ALTER TABLE `maps_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `maps_uom_value`
--
ALTER TABLE `maps_uom_value`
  MODIFY `maps_uom_value_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3929;

--
-- AUTO_INCREMENT for table `pdf_admin_data`
--
ALTER TABLE `pdf_admin_data`
  MODIFY `pdf_admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `property`
--
ALTER TABLE `property`
  MODIFY `prop_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `prop_assign`
--
ALTER TABLE `prop_assign`
  MODIFY `propr_assign_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `staff_pay`
--
ALTER TABLE `staff_pay`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `uom`
--
ALTER TABLE `uom`
  MODIFY `uom_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `uom_field`
--
ALTER TABLE `uom_field`
  MODIFY `uom_field_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `vendor`
--
ALTER TABLE `vendor`
  MODIFY `vendor_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_pay`
--
ALTER TABLE `vendor_pay`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_pay_settle`
--
ALTER TABLE `vendor_pay_settle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

