INSERT INTO `zip` (`zip`, `city_id`, `population`, `lat`, `lng`) VALUES
('93433', 2475, 12755, 35.120450, -120.618940),
('93434', 2514, 8272, 34.940860, -120.611300),
('93436', 2515, 55591, 34.608880, -120.400200),
('93437', 2515, 3681, 34.760490, -120.511020),
('93440', 2516, 846, 34.746060, -120.252920),
('93441', 2517, 1085, 34.732960, -120.097210),
('93442', 2477, 11399, 35.400000, -120.804950),
('93444', 2478, 22079, 35.035530, -120.502930),
('93445', 2479, 6912, 35.033190, -120.620020),
('93446', 2480, 45720, 35.658610, -120.718880),
('93449', 2481, 8050, 35.158030, -120.650400),
('93450', 2157, 830, 36.057910, -120.828940),
('93451', 2159, 4751, 35.893980, -120.567330),
('93452', 2483, 307, 35.710780, -121.203960),
('93453', 2484, 2096, 35.313390, -120.165500),
('93454', 2520, 41110, 34.948340, -120.234250),
('93455', 2520, 44186, 34.841950, -120.455220),
('93458', 2520, 59789, 34.954770, -120.490420),
('93460', 2521, 6280, 34.662140, -119.900910),
('93461', 2485, 1369, 35.635190, -120.269510),
('93463', 2522, 8059, 34.606880, -120.134950),
('93465', 2486, 9829, 35.542670, -120.734170),
('93501', 1852, 5404, 35.041100, -118.229220),
('93505', 1837, 14952, 35.157080, -117.909340),
('93510', 1903, 7397, 34.456270, -118.210900),
('93512', 2130, 313, 37.873790, -118.534550),
('93513', 1822, 1649, 37.184010, -118.171290),
('93514', 2131, 14692, 37.494700, -118.385140),
('93516', 1834, 2583, 35.008100, -117.642680),
('93517', 2132, 587, 38.270910, -119.273720),
('93518', 1836, 894, 35.376750, -118.473140),
('93519', 1838, 0, 35.317100, -117.955960),
('93522', 1823, 86, 36.298360, -117.596810),
('93523', 1841, 3867, 34.997880, -117.883080),
('93524', 1841, 93, 34.909930, -117.850070),
('93526', 1825, 855, 36.859410, -118.253780),
('93527', 2714, 1734, 35.802940, -117.985040),
('93528', 1844, 94, 35.371940, -117.641930),
('93529', 2134, 302, 37.783200, -119.137500),
('93530', 1826, 28, 36.484580, -117.872010),
('93531', 1845, 425, 35.229370, -118.607810),
('93532', 1949, 2768, 34.685710, -118.559140),
('93534', 1951, 42515, 34.717590, -118.150790),
('93535', 1951, 80905, 34.699080, -117.896130),
('93536', 1951, 72131, 34.752670, -118.388900),
('93541', 2135, 817, 37.996780, -119.018470),
('93543', 1953, 12745, 34.479160, -117.973570),
('93544', 1954, 1427, 34.490630, -117.755050),
('93545', 1827, 1342, 36.604600, -118.027210),
('93546', 2136, 8689, 37.605730, -118.852190),
('93549', 1828, 254, 36.277280, -117.960160),
('93550', 1976, 81501, 34.383050, -118.049260),
('93551', 1976, 54478, 34.594040, -118.226340),
('93552', 1976, 43371, 34.584120, -118.023860),
('93553', 1981, 1136, 34.445150, -117.896110),
('93554', 1855, 65, 35.369140, -117.758760),
('93555', 1856, 33490, 35.585960, -117.684460),
('93558', 2385, 17, 35.339450, -117.585170),
('93560', 1857, 21300, 34.871160, -118.325940),
('93561', 1860, 31060, 35.109040, -118.520160),
('93562', 2393, 1867, 35.706670, -117.342630),
('93563', 2019, 222, 34.386620, -117.836460),
('93581', 1860, 3611, 35.112880, -118.570350),
('93591', 1976, 7340, 34.596560, -117.809550),
('93601', 2032, 1206, 37.393950, -119.737020),
('93602', 1732, 3038, 37.064400, -119.374840),
('93603', 2704, 249, 36.551180, -118.996070),
('93604', 2033, 366, 37.371700, -119.522150),
('93605', 1733, 97, 37.176220, -119.249530),
('93606', 1734, 1129, 36.798710, -120.016250),
('93608', 1735, 1018, 36.505500, -120.341800),
('93609', 1736, 4889, 36.526160, -119.863880),
('93610', 2034, 23795, 37.090470, -120.290360),
('93611', 1737, 46620, 36.825520, -119.681150),
('93612', 1737, 37138, 36.815480, -119.710760),
('93614', 2035, 11760, 37.212820, -119.726590),
('93615', 2707, 5767, 36.503740, -119.283850),
('93616', 1739, 2163, 36.654680, -119.594370),
('93618', 2708, 32334, 36.522130, -119.386610),
('93619', 1737, 50848, 36.916560, -119.573720),
('93620', 2107, 9363, 37.044800, -120.622300),
('93621', 1740, 173, 36.806700, -119.136020),
('93622', 1741, 9419, 36.792830, -120.624340),
('93623', 2072, 4, 37.474780, -119.660710),
('93624', 1742, 892, 36.372580, -120.121250),
('93625', 1743, 8396, 36.624230, -119.671730),
('93626', 2036, 2583, 37.032780, -119.686010),
('93627', 1745, 196, 36.515680, -120.106350),
('93628', 1746, 310, 36.781490, -118.838390),
('93630', 1748, 20272, 36.718310, -120.129120),
('93631', 2719, 16588, 36.476530, -119.521310),
('93633', 2718, 26, 36.729120, -118.956270),
('93634', 1749, 29, 37.205830, -118.936520),
('93635', 2113, 47683, 37.016000, -120.882940),
('93636', 2037, 13447, 36.981710, -119.877060),
('93637', 2037, 41324, 36.910990, -120.192200),
('93638', 2037, 51724, 37.042400, -120.038160),
('93640', 1751, 14162, 36.672150, -120.437780),
('93641', 1752, 216, 36.704810, -119.021670),
('93643', 2038, 3115, 37.271550, -119.450040),
('93644', 2039, 7169, 37.412450, -119.594310),
('93645', 2040, 897, 37.164100, -119.618240),
('93646', 2722, 10157, 36.632180, -119.289380),
('93647', 2723, 11828, 36.584490, -119.177730),
('93648', 1753, 15370, 36.620600, -119.520620),
('93650', 1744, 2844, 36.840260, -119.800380),
('93651', 1754, 1580, 37.002960, -119.521000),
('93652', 1755, 378, 36.595020, -119.904580),
('93653', 2041, 1378, 37.247690, -119.918820),
('93654', 1756, 30476, 36.657470, -119.402000),
('93656', 1757, 6249, 36.451730, -119.936150),
('93657', 1759, 36053, 36.788530, -119.437800),
('93660', 1758, 3921, 36.609320, -120.165140),
('93662', 1760, 30191, 36.539630, -119.642870),
('93664', 1761, 288, 37.056710, -119.179810),
('93665', 2117, 386, 36.963340, -120.650340),
('93666', 2731, 704, 36.546230, -119.336290),
('93667', 1763, 1909, 36.965850, -119.315110),
('93668', 1764, 1025, 36.656630, -120.289970),
('93669', 2042, 324, 37.283340, -119.542970),
('93670', 2739, 108, 36.485640, -119.254420),
('93673', 2735, 378, 36.452290, -119.482320),
('93675', 1762, 4891, 36.732510, -119.192850),
('93701', 1744, 10602, 36.749550, -119.787720),
('93702', 1744, 45248, 36.739420, -119.754220),
('93703', 1744, 32603, 36.768840, -119.762490),
('93704', 1744, 29502, 36.800120, -119.802020),
('93705', 1744, 38777, 36.786670, -119.828510),
('93706', 1744, 41523, 36.653440, -119.902160),
('93710', 1744, 32730, 36.823350, -119.762510),
('93711', 1744, 39963, 36.835080, -119.833090),
('93720', 1744, 48597, 36.860600, -119.762280),
('93721', 1744, 8004, 36.732820, -119.783830),
('93722', 1744, 86387, 36.800030, -119.877910),
('93723', 1744, 13174, 36.786930, -119.952710),
('93725', 1744, 26568, 36.626670, -119.735010),
('93726', 1744, 44790, 36.793740, -119.761610),
('93727', 1744, 82176, 36.751190, -119.697360),
('93728', 1744, 17892, 36.757290, -119.818160),
('93730', 1744, 12461, 36.903540, -119.755120),
('93737', 1744, 6624, 36.753580, -119.645600),
('93740', 1744, 1174, 36.816380, -119.746130),
('93741', 1744, 77, 36.767420, -119.796020),
('93901', 2156, 29498, 36.647940, -121.630440),
('93905', 2156, 63121, 36.684900, -121.605620),
('93906', 2156, 66883, 36.722580, -121.632180),
('93907', 2156, 25124, 36.766430, -121.668160),
('93908', 2156, 12983, 36.621530, -121.600480),
('93920', 2139, 1790, 36.031640, -121.525920),
('93921', 2142, 2469, 36.553590, -121.922590),
('93923', 2141, 12630, 36.403940, -121.798670),
('93924', 2143, 6563, 36.394890, -121.634060),
('93925', 2145, 1352, 36.602090, -121.425260),
('93926', 2146, 8941, 36.525670, -121.399100),
('93927', 2147, 19983, 36.269780, -121.380180),
('93928', 2148, 1040, 36.064840, -121.381020),
('93930', 2149, 16807, 36.199240, -121.072820),
('93932', 2150, 370, 36.001430, -121.057570),
('93933', 2151, 27197, 36.675660, -121.782370),
('93940', 2152, 31513, 36.452940, -121.849800),
('93943', 2152, 12, 36.597360, -121.873320),
('93944', 2152, 2605, 36.600580, -121.918580),
('93950', 2154, 15098, 36.618990, -121.925750),
('93953', 2155, 3416, 36.585660, -121.943290),
('93954', 2158, 501, 36.164340, -120.924410),
('93955', 2160, 32610, 36.621530, -121.795620),
('93960', 2161, 26037, 36.404890, -121.321210),
('93962', 2162, 198, 36.624720, -121.646490),
('94002', 2488, 27893, 37.513660, -122.298530),
('94005', 2489, 4756, 37.688200, -122.408730),
('94010', 2490, 43458, 37.573060, -122.378280),
('94014', 2491, 46331, 37.690700, -122.447690),
('94015', 2491, 65125, 37.681210, -122.480740),
('94018', 2492, 3423, 37.506030, -122.473210),
('94019', 2493, 15275, 37.448260, -122.402300),
('94020', 2494, 2030, 37.284730, -122.219690),
('94021', 2495, 123, 37.250280, -122.249580),
('94022', 2529, 20052, 37.355340, -122.144940),
('94024', 2529, 24041, 37.350370, -122.098630),
('94025', 2496, 41017, 37.450870, -122.182900),
('94027', 2487, 7142, 37.453990, -122.203130),
('94028', 2502, 6888, 37.374920, -122.211360),
('94030', 2497, 22825, 37.599690, -122.403430),
('94037', 2498, 2649, 37.553270, -122.495840),
('94038', 2499, 3165, 37.529460, -122.484900),
('94040', 2534, 35667, 37.380340, -122.085310),
('94041', 2534, 15222, 37.388220, -122.075290),
('94043', 2534, 32670, 37.411880, -122.068920),
('94044', 2500, 38061, 37.605440, -122.479930),
('94060', 2501, 1312, 37.222970, -122.335720),
('94061', 2503, 37539, 37.461360, -122.237310),
('94062', 2503, 26531, 37.425620, -122.296530),
('94063', 2503, 34807, 37.493670, -122.208230),
('94065', 2503, 11588, 37.535040, -122.246830),
('94066', 2504, 43369, 37.625390, -122.432290),
('94070', 2505, 31312, 37.497390, -122.270210),
('94074', 2507, 151, 37.328170, -122.341640),
('94080', 2509, 66262, 37.655410, -122.420830),
('94085', 2541, 22996, 37.388620, -122.017930),
('94086', 2541, 49217, 37.371640, -122.023160),
('94087', 2541, 58913, 37.351640, -122.036690),
('94089', 2541, 23447, 37.411920, -122.014410),
('94102', 2453, 34077, 37.779560, -122.419310),
('94103', 2453, 32400, 37.772990, -122.411360),
('94104', 2453, 557, 37.791440, -122.402110),
('94105', 2453, 13722, 37.792390, -122.397070),
('94107', 2453, 30340, 37.764730, -122.395080),
('94108', 2453, 12070, 37.791890, -122.408540),
('94109', 2453, 56333, 37.793340, -122.421380),
('94110', 2453, 69679, 37.749750, -122.415280),
('94111', 2453, 4468, 37.798470, -122.399800),
('94112', 2453, 80880, 37.720600, -122.443110),
('94114', 2453, 33858, 37.758140, -122.435470),
('94115', 2453, 33299, 37.786080, -122.437420),
('94116', 2453, 43903, 37.744570, -122.486110),
('94117', 2453, 39496, 37.770020, -122.444250),
('94118', 2453, 40108, 37.780100, -122.461850),
('94121', 2453, 43304, 37.778490, -122.495480),
('94122', 2453, 59453, 37.761130, -122.484330),
('94123', 2453, 24721, 37.801120, -122.436450),
('94124', 2453, 37347, 37.732040, -122.385800),
('94127', 2453, 21184, 37.736420, -122.459610),
('94128', 2506, 0, 37.621970, -122.383880),
('94129', 2453, 3952, 37.797430, -122.466620),
('94130', 2453, 3136, 37.819750, -122.368980),
('94131', 2453, 28705, 37.745690, -122.442430),
('94132', 2453, 27641, 37.722190, -122.484750),
('94133', 2453, 25460, 37.801930, -122.410920),
('94134', 2453, 40738, 37.718870, -122.411240),
('94158', 2453, 10205, 37.771160, -122.391530),
('94188', 2453, 0, 37.740700, -122.380910),
('94301', 2535, 17259, 37.444240, -122.149920),
('94303', 2535, 47989, 37.450640, -122.119280),
('94304', 2535, 4489, 37.397440, -122.166990),
('94305', 2540, 17279, 37.416230, -122.170690),
('94306', 2535, 27785, 37.416270, -122.130880),
('94401', 2508, 35392, 37.574450, -122.319420),
('94402', 2508, 26150, 37.540350, -122.333880),
('94403', 2508, 43858, 37.538440, -122.304540),
('94404', 2508, 36397, 37.556200, -122.269050),
('94501', 1603, 63340, 37.775250, -122.274930),
('94502', 1603, 14225, 37.736860, -122.241140),
('94503', 2163, 21791, 38.194540, -122.230420),
('94505', 1686, 15445, 37.866380, -121.586800),
('94506', 1684, 26947, 37.808620, -121.904980),
('94507', 1674, 14503, 37.854290, -122.006640),
('94508', 2164, 3406, 38.579090, -122.444510),
('94509', 1675, 70889, 37.992140, -121.814200),
('94510', 2607, 27223, 38.097560, -122.131890),
('94511', 1677, 1993, 38.028830, -121.640390),
('94512', 2608, 57, 38.126300, -121.837930),
('94513', 1678, 67580, 37.925410, -121.684520),
('94514', 1679, 2023, 37.830710, -121.633920),
('94515', 2620, 7024, 38.624490, -122.625030),
('94516', 1680, 212, 37.827480, -122.166290),
('94517', 1681, 12349, 37.892600, -121.882520),
('94518', 1682, 28287, 37.950520, -122.022090),
('94519', 1682, 20162, 37.988810, -122.012750),
('94520', 1682, 36699, 37.993440, -122.035320),
('94521', 1682, 41092, 37.952930, -121.969710),
('94523', 1698, 34964, 37.954030, -122.076080),
('94525', 1683, 3599, 38.048110, -122.229200),
('94526', 1684, 33396, 37.814720, -121.984510),
('94528', 1685, 726, 37.841490, -121.958190),
('94530', 1687, 26483, 37.920760, -122.300680),
('94531', 1675, 44115, 37.956650, -121.777770),
('94533', 2611, 78129, 38.281320, -122.006930),
('94534', 2611, 41395, 38.241120, -122.121420),
('94535', 2614, 3873, 38.270480, -121.938510),
('94536', 1609, 71445, 37.570720, -121.985550),
('94538', 1609, 66215, 37.506530, -121.963610),
('94539', 1609, 53464, 37.516350, -121.911900),
('94541', 1610, 67401, 37.673760, -122.087070),
('94542', 1610, 16188, 37.655300, -122.025840),
('94544', 1610, 77712, 37.633520, -122.056780),
('94545', 1610, 33700, 37.629570, -122.120480),
('94546', 1606, 45761, 37.734410, -122.090560),
('94547', 1689, 26041, 38.006370, -122.261170),
('94548', 1690, 598, 37.974810, -121.652650),
('94549', 1691, 28456, 37.901330, -122.119330),
('94550', 1611, 49463, 37.517460, -121.594060),
('94551', 1611, 40025, 37.759020, -121.760260),
('94552', 1606, 14948, 37.704560, -122.013590),
('94553', 1692, 49062, 37.979990, -122.153680),
('94555', 1609, 37671, 37.550830, -122.080430),
('94556', 1693, 15959, 37.831020, -122.104250),
('94558', 2166, 65084, 38.508460, -122.264970),
('94559', 2166, 28224, 38.252380, -122.293820),
('94560', 1612, 47470, 37.507710, -122.025230),
('94561', 1694, 44546, 37.993110, -121.691720),
('94562', 2167, 0, 38.430710, -122.408740),
('94563', 1695, 19416, 37.881960, -122.194190),
('94564', 1696, 18946, 37.988960, -122.270180),
('94565', 1697, 100826, 38.009260, -121.928860),
('94566', 1614, 45145, 37.650320, -121.858810),
('94567', 2168, 719, 38.663420, -122.434900),
('94568', 1607, 71068, 37.715960, -121.901130),
('94569', 1699, 251, 38.044110, -122.192010),
('94571', 2612, 10514, 38.156600, -121.748200),
('94572', 1701, 9309, 38.023920, -122.232850),
('94573', 2169, 107, 38.457260, -122.423480),
('94574', 2170, 7827, 38.527420, -122.392610),
('94575', 1693, 1048, 37.842350, -122.110120),
('94576', 2165, 171, 38.549320, -122.475810),
('94577', 1615, 47937, 37.715950, -122.166150),
('94578', 1615, 42350, 37.706750, -122.125600),
('94579', 1615, 20272, 37.686560, -122.157090),
('94580', 1616, 29377, 37.678030, -122.133340),
('94582', 1703, 47338, 37.763570, -121.914690),
('94583', 1703, 39758, 37.772450, -121.991570),
('94585', 2613, 29401, 38.190610, -121.942160),
('94586', 1617, 964, 37.573270, -121.854720),
('94587', 1619, 69502, 37.591420, -122.069930),
('94588', 1614, 35162, 37.738010, -121.881780),
('94589', 2616, 29959, 38.141620, -122.245960),
('94590', 2616, 37991, 38.095460, -122.249860),
('94591', 2616, 59026, 38.127020, -122.196350),
('94592', 2616, 1020, 38.120090, -122.311700),
('94595', 1704, 17341, 37.872060, -122.068920),
('94596', 1704, 23795, 37.889020, -122.036760),
('94597', 1704, 23654, 37.917680, -122.071800),
('94598', 1704, 26346, 37.892380, -121.982830),
('94599', 2171, 3428, 38.410120, -122.373650),
('94601', 1613, 52102, 37.776840, -122.218220),
('94602', 1613, 31104, 37.805170, -122.204220),
('94603', 1613, 37042, 37.739230, -122.175540),
('94605', 1613, 44477, 37.760620, -122.149030),
('94606', 1613, 38459, 37.791790, -122.244550),
('94607', 1613, 27019, 37.807210, -122.300240),
('94608', 1608, 34083, 37.836110, -122.286210),
('94609', 1613, 25175, 37.834760, -122.264200),
('94610', 1613, 32404, 37.812290, -122.240480),
('94611', 1613, 39780, 37.831910, -122.215920),
('94612', 1613, 17742, 37.807890, -122.266200),
('94613', 1613, 612, 37.780750, -122.183080),
('94618', 1613, 17285, 37.844200, -122.238680),
('94619', 1613, 27018, 37.792620, -122.160010),
('94621', 1613, 34911, 37.737900, -122.207940),
('94702', 1605, 17473, 37.866190, -122.286340),
('94703', 1605, 20404, 37.863970, -122.275730),
('94704', 1605, 25711, 37.866400, -122.260880),
('94705', 1605, 14508, 37.865230, -122.238400),
('94706', 1604, 20860, 37.889690, -122.295810),
('94707', 1605, 12596, 37.898430, -122.279170),
('94708', 1676, 11810, 37.902760, -122.262020),
('94709', 1605, 12200, 37.878350, -122.266130),
('94710', 1605, 8471, 37.867050, -122.303000),
('94720', 1605, 5322, 37.871850, -122.252260),
('94801', 1700, 32759, 37.952170, -122.380250),
('94803', 1688, 27171, 37.956830, -122.282350),
('94804', 1700, 44387, 37.920740, -122.342040),
('94805', 1700, 14790, 37.942150, -122.323640),
('94806', 1702, 63730, 37.978110, -122.336180),
('949', 22221, 68031, 18.431660, -66.213490),
('94901', 2064, 40927, 37.980530, -122.502490),
('94903', 2064, 31582, 38.024850, -122.552200),
('94904', 2049, 13132, 37.948410, -122.552880),
('94920', 2043, 12906, 37.887320, -122.465490),
('94922', 2618, 509, 38.356830, -122.950980),
('94923', 2619, 1390, 38.335880, -123.026470),
('94924', 2044, 1342, 37.954110, -122.731710),
('94925', 2045, 10155, 37.923860, -122.513200),
('94928', 2641, 46231, 38.345900, -122.693500),
('94929', 2046, 442, 38.254440, -122.962430),
('94930', 2047, 8748, 37.970480, -122.611080),
('94931', 2624, 8945, 38.322290, -122.714970),
('94933', 2048, 1284, 38.017530, -122.688140),
('94937', 2050, 938, 38.094660, -122.927190),
('94938', 2051, 428, 38.030240, -122.729530),
('94939', 2052, 7488, 37.937250, -122.535180),
('94940', 2053, 260, 38.157540, -122.863760),
('94941', 2054, 32190, 37.925620, -122.600830),
('94945', 2056, 17309, 38.125800, -122.554430),
('94946', 2055, 673, 38.071760, -122.687850),
('94947', 2056, 25183, 38.107050, -122.628130),
('94949', 2056, 18545, 38.065760, -122.531720),
('94950', 2057, 23, 38.021220, -122.761870),
('94951', 2638, 3574, 38.322520, -122.644920),
('94952', 2058, 33519, 38.230070, -122.763380),
('94954', 2639, 38201, 38.246240, -122.566270),
('94956', 2059, 1189, 38.047600, -122.810460),
('94957', 2060, 2081, 37.963430, -122.561740),
('94960', 2061, 16028, 37.997070, -122.578380),
('94963', 2062, 462, 38.007650, -122.664840),
('94964', 2063, 2054, 37.942350, -122.492440),
('94965', 2065, 12044, 37.852630, -122.526990),
('94970', 2066, 400, 37.916940, -122.655530),
('94971', 2067, 364, 38.237240, -122.890060),
('94972', 2647, 153, 38.336650, -122.939340),
('94973', 2068, 1438, 38.012590, -122.639470),
('950', 22168, 0, 18.462010, -66.239170),
('95002', 2524, 1920, 37.440750, -122.000470),
('95003', 2542, 24977, 37.008900, -121.877750),
('95004', 2138, 3902, 36.868180, -121.632370),
('95005', 2543, 7552, 37.098350, -122.089310),
('95006', 2544, 8802, 37.171290, -122.151000),
('95007', 2545, 359, 37.110190, -122.114340),
('95008', 2525, 48746, 37.279770, -121.954810),
('95010', 2546, 9243, 36.977210, -121.954660),
('95012', 2144, 10528, 36.783730, -121.741640),
('95013', 2526, 53, 37.215310, -121.739620),
('95014', 2527, 61414, 37.308270, -122.079810),
('95017', 2547, 907, 37.105290, -122.229130),
('95018', 2548, 6055, 37.080270, -122.058240),
('95019', 2549, 5891, 36.935750, -121.784580),
('95020', 2528, 68365, 37.014610, -121.557180),
('95023', 2331, 57367, 36.921130, -121.361170),
('95030', 2530, 13373, 37.221680, -121.983260),
('95032', 2530, 27678, 37.208590, -121.923590),
('95033', 2550, 9853, 37.157010, -121.977710),
('95035', 2531, 79393, 37.443190, -121.876320),
('95037', 2532, 51867, 37.132130, -121.678860),
('95039', 2153, 1427, 36.815150, -121.777900),
('95041', 2551, 803, 37.050520, -122.058280),
('95043', 2332, 669, 36.516520, -120.976770),
('95045', 2333, 4063, 36.832810, -121.525760),
('95046', 2537, 5801, 37.095760, -121.596490),
('95050', 2538, 39905, 37.350400, -121.952380),
('95051', 2538, 60499, 37.348300, -121.984440),
('95053', 2538, 3317, 37.348480, -121.937370),
('95054', 2538, 24444, 37.393080, -121.964830),
('95060', 2552, 46527, 37.013520, -122.101760),
('95062', 2552, 36369, 36.972790, -121.990080),
('95064', 2552, 9832, 36.991580, -122.058860),
('95065', 2552, 8125, 37.032290, -121.984440),
('95066', 2553, 15233, 37.067200, -122.014530),
('95070', 2539, 31688, 37.256240, -122.051510),
('95073', 2554, 11408, 37.040680, -121.931740),
('95075', 2334, 566, 36.801120, -121.192580),
('95076', 2555, 83716, 36.940290, -121.750890),
('951', 22221, 298, 18.431750, -66.256280),
('95110', 2536, 20314, 37.346560, -121.909700),
('95111', 2536, 59761, 37.284010, -121.827310),
('95112', 2536, 58775, 37.344610, -121.883460),
('95113', 2536, 2161, 37.333900, -121.890500),
('95116', 2536, 50436, 37.350430, -121.852550),
('95117', 2536, 28663, 37.310080, -121.962250),
('95118', 2536, 32827, 37.255890, -121.889910),
('95119', 2536, 10461, 37.227560, -121.790770),
('95120', 2536, 38003, 37.184280, -121.836580),
('95121', 2536, 36657, 37.304630, -121.809810),
('95122', 2536, 52555, 37.329250, -121.834810),
('95123', 2536, 70952, 37.244790, -121.833060),
('95124', 2536, 51803, 37.256840, -121.922860),
('95125', 2536, 53333, 37.295540, -121.894080),
('95126', 2536, 36996, 37.326870, -121.916770),
('95127', 2536, 62269, 37.374530, -121.787330),
('95128', 2536, 33653, 37.315790, -121.936470),
('95129', 2536, 39797, 37.305970, -122.000720),
('95130', 2536, 13376, 37.288030, -121.981460),
('95131', 2536, 31335, 37.387290, -121.897930),
('95132', 2536, 40981, 37.419940, -121.790590),
('95133', 2536, 28749, 37.371710, -121.860570),
('95134', 2536, 30916, 37.430030, -121.945280),
('95135', 2536, 21402, 37.222850, -121.559130),
('95136', 2536, 47294, 37.271920, -121.852370),
('95138', 2536, 19420, 37.246200, -121.732870),
('95139', 2536, 7232, 37.224890, -121.763930),
('95140', 2533, 91, 37.348300, -121.640850),
('95148', 2536, 45688, 37.332520, -121.781420),
('952', 22220, 8168, 18.428740, -66.188970),
('95202', 2464, 6000, 37.959680, -121.287720),
('95203', 2464, 16237, 37.952370, -121.330980),
('95204', 2464, 30406, 37.974030, -121.319060),
('95205', 2464, 40128, 37.964250, -121.259550),
('95206', 2464, 68031, 37.896100, -121.410510),
('95207', 2464, 52877, 38.002420, -121.325000),
('95209', 2464, 46756, 38.047170, -121.351210),
('95210', 2464, 42654, 38.032150, -121.297820),
('95211', 2464, 1676, 37.980780, -121.311980),
('95212', 2464, 27848, 38.048970, -121.226840),
('95215', 2464, 25647, 37.944400, -121.152760),
('95219', 2464, 30165, 38.020700, -121.515840),
('95220', 2454, 8244, 38.197790, -121.236030),
('95221', 1650, 398, 38.072400, -120.548520),
('95222', 1651, 5236, 38.061270, -120.617910),
('95223', 1620, 2470, 38.464400, -119.859390),
('95224', 1652, 311, 38.227060, -120.325620),
('95225', 1653, 1019, 38.203990, -120.864880),
('95226', 1654, 0, 38.233770, -120.862320),
('95227', 2455, 1180, 38.206780, -121.046150),
('95228', 1655, 4648, 37.946690, -120.680670),
('95230', 2654, 513, 37.973610, -120.864920),
('95231', 2457, 4865, 37.873310, -121.292720),
('95232', 1656, 202, 38.360510, -120.577220),
('95233', 1657, 233, 38.186220, -120.368590),
('95236', 2459, 4518, 38.042180, -121.031760),
('95237', 2460, 3992, 38.159530, -121.148450),
('95240', 2461, 50245, 38.117700, -121.162700),
('95242', 2461, 27433, 38.132040, -121.388750),
('95245', 1658, 2813, 38.301890, -120.619750),
('95246', 1659, 1548, 38.236620, -120.495890),
('95247', 1660, 4022, 38.142640, -120.443590),
('95248', 1661, 106, 38.324330, -120.460510),
('95249', 1662, 4908, 38.189860, -120.617840),
('95251', 1663, 521, 38.080240, -120.457690),
('95252', 1664, 14622, 38.158710, -120.842140),
('95253', 2467, 504, 38.147250, -121.195250),
('95254', 1665, 350, 38.203230, -120.958570),
('95255', 1666, 1787, 38.420550, -120.475060),
('95257', 1667, 398, 38.380680, -120.452550),
('95258', 2468, 3885, 38.168110, -121.310110),
('953', 22219, 66079, 18.363190, -66.247640),
('95301', 2103, 41660, 37.306340, -120.651190),
('95303', 2104, 891, 37.471400, -120.677440),
('95304', 2466, 15235, 37.677300, -121.394800),
('95305', 2740, 158, 37.830600, -120.348210),
('95306', 2069, 784, 37.360150, -120.115810),
('95307', 2650, 47978, 37.555820, -120.953850),
('95309', 2741, 0, 37.871540, -120.432990),
('95310', 2742, 1849, 38.099440, -120.361710),
('95311', 2070, 2182, 37.704430, -120.083440),
('95312', 2105, 284, 37.421070, -120.652950),
('95313', 2651, 860, 37.435110, -121.037690),
('95315', 2106, 13317, 37.422430, -120.773300),
('95316', 2652, 7154, 37.546130, -120.692120),
('95317', 2108, 948, 37.129470, -120.507400),
('95318', 2071, 522, 37.666180, -119.806400),
('95319', 2653, 1651, 37.630900, -120.877280),
('95320', 2456, 12385, 37.824530, -121.015450),
('95321', 2743, 4068, 37.977190, -119.750120),
('95322', 2109, 9392, 37.176220, -121.018610),
('95323', 2655, 1516, 37.608810, -120.684640),
('95324', 2110, 8763, 37.394520, -120.896050),
('95325', 2073, 44, 37.480580, -120.242080),
('95326', 2656, 10672, 37.589980, -120.853100),
('95327', 2744, 8788, 37.849120, -120.485800),
('95328', 2657, 3856, 37.557970, -120.909320),
('95329', 2745, 2394, 37.677260, -120.413630),
('95330', 2458, 30051, 37.811700, -121.313310),
('95333', 2111, 3157, 37.244700, -120.242770),
('95334', 2112, 17302, 37.347560, -120.746240),
('95335', 2746, 58, 38.118940, -120.092390),
('95336', 2462, 49145, 37.833510, -121.198800),
('95337', 2462, 44192, 37.741710, -121.238340),
('95338', 2074, 10102, 37.509110, -119.986590),
('95340', 2114, 36833, 37.341280, -120.406580),
('95341', 2114, 34541, 37.230370, -120.507150),
('95345', 2075, 528, 37.587840, -119.964080),
('95346', 2747, 1041, 38.070450, -120.172910),
('95348', 2114, 35853, 37.415250, -120.497900),
('95350', 2658, 55368, 37.671750, -121.007320),
('95351', 2658, 48134, 37.623600, -120.998280),
('95354', 2658, 25100, 37.638490, -120.964280),
('95355', 2658, 60338, 37.672700, -120.947170),
('95356', 2658, 33033, 37.719450, -121.027860),
('95357', 2658, 14403, 37.669850, -120.879240),
('95358', 2658, 31268, 37.615780, -121.100590),
('95360', 2659, 13781, 37.329180, -121.038270),
('95361', 2660, 35107, 37.793420, -120.776540),
('95363', 2661, 29784, 37.372510, -121.271920),
('95364', 2748, 0, 38.229080, -119.791740),
('95365', 2115, 3882, 37.301200, -120.331520),
('95366', 2463, 18500, 37.762230, -121.125740),
('95367', 2662, 25162, 37.730890, -120.946690),
('95368', 2663, 14849, 37.715440, -121.090470),
('95369', 2116, 778, 37.524350, -120.413010),
('95370', 2749, 28548, 37.984840, -120.345150),
('95372', 2750, 1639, 37.989270, -120.262720),
('95374', 2118, 1581, 37.316360, -120.856830),
('95375', 2751, 64, 38.214930, -119.970310),
('95376', 2466, 55038, 37.736780, -121.434040),
('95377', 2466, 35001, 37.652930, -121.495980),
('95379', 2752, 3828, 37.961740, -120.216350),
('95380', 2664, 44204, 37.472260, -120.869780),
('95382', 2664, 38727, 37.528310, -120.852140),
('95383', 2753, 3415, 38.095340, -120.226020),
('95385', 2665, 531, 37.612000, -121.247730),
('95386', 2666, 10387, 37.673910, -120.630450),
('95387', 2667, 1215, 37.554290, -121.245100),
('95388', 2119, 13518, 37.421710, -120.597150),
('95389', 2076, 1963, 37.737840, -119.525560),
('95391', 1618, 23696, 37.769520, -121.591200),
('95401', 2642, 36905, 38.449220, -122.793070),
('95403', 2642, 44677, 38.503260, -122.753580),
('95404', 2642, 37437, 38.464880, -122.657090),
('95405', 2642, 23748, 38.439260, -122.669080),
('95407', 2642, 42138, 38.394650, -122.745910),
('95409', 2642, 26158, 38.461160, -122.604250),
('95410', 2077, 797, 39.216160, -123.700120),
('95412', 2617, 271, 38.711680, -123.319670),
('95415', 2078, 1383, 39.020500, -123.367510),
('95417', 2079, 211, 39.687910, -123.650750),
('95419', 2621, 169, 38.423360, -122.958200),
('95420', 2080, 351, 39.356380, -123.768320),
('95421', 2622, 1679, 38.582760, -123.180370),
('95422', 1873, 16998, 38.978290, -122.642300),
('95423', 1874, 3322, 39.067490, -122.627530),
('95425', 2623, 11331, 38.817920, -123.025660),
('95426', 1875, 1178, 38.834490, -122.736100),
('95427', 2081, 589, 39.253260, -123.569320),
('95428', 2082, 2775, 39.824890, -123.181260),
('95429', 2083, 118, 39.732920, -123.348410),
('95430', 2625, 0, 38.462790, -123.044760),
('95431', 2626, 76, 38.348970, -122.516250),
('95432', 2084, 614, 39.108300, -123.638290),
('95435', 1876, 347, 39.003150, -122.874800),
('95436', 2627, 6008, 38.491080, -122.914250),
('95437', 2085, 14865, 39.445350, -123.694020),
('95439', 2628, 782, 38.490550, -122.775910),
('95441', 2629, 1819, 38.737750, -123.035400),
('95442', 2630, 2592, 38.378500, -122.515490),
('95443', 1877, 190, 39.050130, -122.739620),
('95444', 2631, 516, 38.432610, -122.869220),
('95445', 2086, 2012, 38.837620, -123.494040),
('95446', 2632, 4709, 38.525250, -123.004230),
('95448', 2633, 16745, 38.623090, -122.890890),
('95449', 2087, 1785, 38.943310, -123.096530),
('95450', 2634, 272, 38.522900, -123.215080),
('95451', 1879, 12957, 38.938800, -122.804840),
('95452', 2635, 1240, 38.429690, -122.536200),
('95453', 1880, 11254, 39.043460, -122.939180),
('95454', 2088, 1714, 39.780630, -123.516310),
('95456', 2090, 775, 39.258510, -123.745850),
('95457', 1881, 3252, 38.879670, -122.527530),
('95458', 1882, 3303, 39.116670, -122.782040),
('95459', 2091, 853, 38.990680, -123.626270),
('95460', 2092, 2349, 39.303860, -123.737370),
('95461', 1883, 3909, 38.762000, -122.593140),
('95462', 2636, 1091, 38.472630, -123.020640),
('95463', 2093, 88, 39.189570, -123.580590),
('95464', 1884, 2466, 39.127360, -122.847330),
('95465', 2637, 1251, 38.405560, -123.019630),
('95466', 2094, 880, 39.088680, -123.510580),
('95467', 1878, 5795, 38.804530, -122.549480),
('95468', 2096, 1822, 38.909400, -123.603720),
('95469', 2097, 1323, 39.388530, -123.059720),
('95470', 2098, 6068, 39.300190, -123.229840),
('95471', 2640, 780, 38.532180, -122.973620),
('95472', 2643, 28443, 38.397380, -122.866680),
('95476', 2644, 36386, 38.255310, -122.460550),
('95480', 2645, 6, 38.684630, -123.368020),
('95482', 2099, 34183, 39.161800, -123.239250),
('95485', 1885, 2909, 39.208280, -122.925900),
('95486', 2648, 27, 38.474100, -123.024030),
('95488', 2100, 366, 39.736790, -123.771990),
('95490', 2101, 14360, 39.488300, -123.347250),
('95492', 2649, 28096, 38.530520, -122.812540),
('95493', 1886, 144, 39.202410, -122.979480),
('95494', 2102, 151, 38.896460, -123.343240),
('95497', 2646, 1224, 38.719760, -123.456010),
('95501', 1780, 23706, 40.804350, -124.140340),
('95503', 1780, 24072, 40.724060, -124.091780),
('95511', 1773, 102, 40.169750, -123.595390),
('95514', 1776, 117, 40.291510, -123.671190),
('95519', 1791, 18781, 40.958330, -124.049830),
('95521', 1774, 21712, 40.845860, -124.047450),
('95524', 1775, 1700, 40.823460, -124.052710),
('95525', 1777, 1358, 40.948450, -123.826290),
('95526', 1778, 638, 40.447050, -123.662800),
('95527', 2691, 701, 40.935930, -123.419660),
('95528', 1779, 1555, 40.493600, -123.923930),
('95531', 1705, 23029, 41.792880, -124.004730),
('95536', 1781, 3258, 40.510690, -124.265470),
('95537', 1782, 629, 40.745000, -124.214720),
('95538', 1706, 1022, 41.868330, -124.154330),
('95540', 1783, 14415, 40.566710, -124.126510),
('95542', 1784, 2862, 40.080740, -123.773690),
('95543', 1707, 376, 41.888470, -123.802380),
('95545', 1785, 492, 40.261590, -124.085990),
('95546', 1786, 2666, 41.187770, -123.745350),
('95547', 1787, 1121, 40.569520, -124.077510),
('95548', 1708, 1034, 41.586330, -124.058590),
('95549', 1788, 1140, 40.658380, -123.894850),
('95550', 1789, 213, 40.776950, -123.829510),
('95551', 1790, 1789, 40.669770, -124.219610),
('95552', 2697, 423, 40.348990, -123.422480),
('95553', 1792, 1037, 40.229810, -123.871330),
('95554', 1793, 313, 40.275730, -123.784140),
('95555', 1794, 370, 41.295190, -123.977740),
('95556', 1795, 692, 41.314440, -123.590430),
('95558', 1796, 246, 40.326730, -124.240170),
('95559', 1797, 0, 40.189770, -123.751200),
('95560', 1799, 1337, 40.146060, -123.838160),
('95562', 1800, 3396, 40.458080, -124.107200),
('95563', 2699, 911, 40.842480, -123.512250),
('95564', 1801, 564, 40.790230, -124.203120),
('95565', 1802, 860, 40.457230, -124.010990),
('95567', 1709, 2001, 41.949800, -124.111800),
('95568', 2604, 224, 41.484540, -123.485430),
('95569', 1798, 91, 40.360780, -123.858180),
('95570', 1803, 2523, 41.113750, -124.080370),
('95571', 1804, 30, 40.364950, -123.941570),
('95573', 1806, 1417, 40.895670, -123.658730),
('95585', 2089, 545, 39.858720, -123.666190),
('95587', 2095, 0, 39.969690, -123.755370),
('95589', 1805, 1153, 40.079270, -123.985960),
('95595', 2702, 143, 40.110740, -123.266420),
('956', 22151, 65841, 18.321210, -66.171850),
('95601', 1623, 352, 38.427130, -120.829970),
('95602', 2225, 18610, 38.990390, -121.109910),
('95603', 2225, 28366, 38.911670, -121.085590),
('95604', 2225, 34, 38.911200, -121.098200),
('95605', 2785, 14291, 38.592890, -121.539290),
('95606', 2775, 185, 38.756040, -122.193870),
('95607', 2776, 235, 38.789900, -122.125850),
('95608', 2308, 63715, 38.626110, -121.328860),
('95610', 2309, 46219, 38.694940, -121.272190),
('95612', 2777, 1462, 38.386440, -121.581180),
('95613', 1711, 0, 38.812720, -120.891730),
('95614', 1712, 4479, 38.886490, -120.988960),
('95615', 2310, 1147, 38.311130, -121.545950),
('95616', 2778, 52090, 38.558190, -121.800440),
('95618', 2778, 26946, 38.543480, -121.691700),
('95619', 1713, 6414, 38.682180, -120.814010),
('95620', 2609, 22004, 38.405990, -121.756890),
('95621', 2309, 42089, 38.695510, -121.308620),
('95623', 1715, 4488, 38.607500, -120.848730),
('95624', 2311, 67915, 38.432030, -121.305060),
('95625', 2610, 88, 38.357280, -121.908610),
('95626', 2312, 5845, 38.733780, -121.488980),
('95627', 2780, 4137, 38.729360, -122.009590),
('95628', 2313, 44256, 38.652120, -121.254300),
('95629', 1625, 747, 38.512770, -120.687500),
('95630', 2314, 76599, 38.665580, -121.141000),
('95631', 2230, 6244, 39.054530, -120.753650),
('95632', 2315, 31217, 38.277050, -121.261280),
('95633', 1717, 3305, 38.849190, -120.823280),
('95634', 1718, 3878, 38.912300, -120.694430),
('95635', 1719, 948, 38.911110, -120.900430),
('95636', 1720, 1374, 38.627400, -120.518520),
('95637', 2781, 276, 38.852830, -122.272900),
('95638', 2316, 2246, 38.339690, -121.114810),
('95639', 2317, 314, 38.392020, -121.495990),
('95640', 1626, 12518, 38.339220, -120.940240),
('95641', 2318, 1517, 38.150460, -121.602710),
('95642', 1627, 7152, 38.343400, -120.763980),
('95645', 2782, 1162, 38.890250, -121.799920),
('95646', 1621, 249, 38.638280, -120.018130),
('95648', 2235, 55350, 38.926430, -121.311010),
('95650', 2236, 14098, 38.813390, -121.168310),
('95651', 1722, 738, 38.820880, -120.935150),
('95652', 2320, 1193, 38.662650, -121.400790),
('95653', 2783, 455, 38.691510, -121.977230),
('95655', 2319, 4954, 38.549760, -121.278980),
('95658', 2238, 5974, 38.879380, -121.151730),
('95659', 2670, 790, 38.845940, -121.576790),
('95660', 2321, 35458, 38.678830, -121.380500),
('95661', 2242, 32827, 38.741290, -121.249250),
('95662', 2322, 32436, 38.689170, -121.219880),
('95663', 2240, 2659, 38.857390, -121.182510),
('95664', 1723, 1133, 38.797550, -121.051360),
('95665', 1628, 4693, 38.395870, -120.652380),
('95666', 1629, 5885, 38.541130, -120.330760),
('95667', 1724, 36084, 38.734070, -120.792160),
('95668', 2671, 507, 38.827080, -121.493780),
('95669', 1630, 2514, 38.495220, -120.891570),
('95670', 2323, 59449, 38.604610, -121.279630),
('95671', 2324, 4478, 38.695290, -121.156710),
('95672', 1726, 5744, 38.726640, -120.996380),
('95673', 2325, 16665, 38.690290, -121.466030),
('95674', 2672, 859, 38.953960, -121.481870),
('95675', 1631, 487, 38.545480, -120.742770),
('95676', 2673, 113, 38.872240, -121.716640),
('95677', 2241, 28591, 38.792980, -121.231330),
('95678', 2242, 45210, 38.765360, -121.288470),
('95679', 2784, 131, 38.905240, -122.267270),
('95680', 2326, 9, 38.241420, -121.578160),
('95681', 2243, 1370, 38.998090, -121.354220),
('95682', 1727, 29750, 38.605370, -120.961750),
('95683', 2328, 6330, 38.510180, -121.098940),
('95684', 1728, 2913, 38.590980, -120.550660),
('95685', 1632, 4703, 38.427160, -120.766980),
('95686', 2465, 1194, 38.190390, -121.485430),
('95687', 2615, 68996, 38.334400, -121.917650),
('95688', 2615, 40147, 38.419010, -122.025710),
('95689', 1633, 1498, 38.470880, -120.615660),
('95690', 2329, 1621, 38.234290, -121.586720),
('95691', 2785, 39961, 38.623940, -121.582720),
('95692', 2801, 4887, 39.046990, -121.404710),
('95693', 2330, 7624, 38.398510, -121.219560),
('95694', 2786, 9600, 38.561630, -122.006090),
('95695', 2787, 39892, 38.688470, -121.856660),
('95697', 2788, 281, 38.732840, -121.807010),
('95698', 2789, 196, 38.818700, -121.910120),
('95699', 1624, 60, 38.440740, -120.857020),
('957', 22151, 41009, 18.366960, -66.188570),
('95701', 2223, 1045, 39.226330, -120.767410),
('95703', 2224, 1955, 38.991560, -120.986400),
('95709', 1710, 6103, 38.748860, -120.681340),
('95713', 2227, 10280, 39.084770, -120.927880),
('95714', 2228, 411, 39.201300, -120.836770),
('95715', 2229, 110, 39.274950, -120.643880),
('95717', 2231, 129, 39.142580, -120.842680),
('95720', 1721, 107, 38.845360, -120.260210),
('95721', 1714, 0, 38.823410, -120.093790),
('95722', 2237, 4829, 39.004670, -121.028910),
('95726', 1725, 7974, 38.754180, -120.419890),
('95728', 2244, 549, 39.296730, -120.403580),
('95735', 1731, 51, 38.829860, -120.179360),
('95736', 2247, 131, 39.039050, -120.977380),
('95742', 2323, 14883, 38.573500, -121.198540),
('95746', 2232, 22743, 38.750090, -121.167120),
('95747', 2242, 75681, 38.779630, -121.367980),
('95757', 2311, 53232, 38.338860, -121.436430),
('95758', 2311, 66153, 38.429320, -121.446030),
('95762', 1716, 45842, 38.676940, -121.057550),
('95765', 2241, 43059, 38.819820, -121.277720),
('95776', 2787, 26352, 38.688890, -121.707760),
('95811', 2327, 8456, 38.587610, -121.490770),
('95814', 2327, 12248, 38.580640, -121.494880),
('95815', 2327, 26523, 38.605440, -121.444970),
('95816', 2327, 18334, 38.575550, -121.465430),
('95817', 2327, 14513, 38.550570, -121.457130),
('95818', 2327, 23062, 38.555790, -121.496690),
('95819', 2327, 19806, 38.568160, -121.437720),
('95820', 2327, 36024, 38.534910, -121.444200),
('95821', 2327, 37436, 38.625410, -121.384790),
('95822', 2327, 46413, 38.512730, -121.495560),
('95823', 2327, 82983, 38.474730, -121.442660),
('95824', 2327, 30556, 38.517460, -121.441470),
('95825', 2327, 37310, 38.590100, -121.406440),
('95826', 2327, 40205, 38.545540, -121.378850),
('95827', 2327, 21084, 38.551510, -121.325300),
('95828', 2327, 60850, 38.489430, -121.395980),
('95829', 2327, 31297, 38.487590, -121.333260),
('95830', 2327, 746, 38.494150, -121.272290),
('95831', 2327, 44450, 38.495990, -121.529480),
('95832', 2327, 13116, 38.439790, -121.498880),
('95833', 2327, 40908, 38.615290, -121.515580),
('95834', 2327, 34892, 38.642070, -121.519670),
('95835', 2327, 40957, 38.670880, -121.524640),
('95837', 2327, 306, 38.689250, -121.595370),
('95838', 2327, 41311, 38.647080, -121.443120),
('95841', 2327, 21542, 38.660310, -121.348120),
('95842', 2327, 34775, 38.687000, -121.348890),
('95843', 2307, 47195, 38.715320, -121.363660),
('95864', 2327, 25728, 38.585120, -121.376550),
('959', 22151, 47721, 18.385200, -66.155830),
('95901', 2796, 36119, 39.222500, -121.488550),
('95903', 2790, 1868, 39.113370, -121.371920),
('95910', 2578, 148, 39.467420, -120.831580),
('95912', 1668, 4908, 39.001600, -122.074620),
('95913', 1765, 313, 39.628990, -122.192150),
('95914', 1634, 450, 39.407560, -121.378780),
('95915', 2249, 0, 39.979260, -121.214920),
('95916', 1635, 965, 39.659450, -121.373750),
('95917', 1636, 4091, 39.423920, -121.771780),
('95918', 2791, 1807, 39.301000, -121.345470),
('95919', 2792, 1183, 39.434450, -121.265540),
('95920', 1766, 164, 39.460710, -121.937020),
('95922', 2793, 593, 39.470330, -121.077360),
('95923', 2251, 43, 40.183850, -121.136720),
('95925', 2794, 188, 39.467980, -121.180060),
('95926', 1637, 42362, 39.745730, -121.843960),
('95928', 1637, 38412, 39.683170, -121.835280),
('95929', 1637, 0, 39.725780, -121.850220),
('95930', 1638, 417, 39.546790, -121.160600),
('95932', 1669, 7789, 39.268390, -122.004260),
('95934', 2255, 33, 40.074630, -120.931080),
('95935', 2795, 465, 39.373690, -121.196150),
('95936', 2580, 121, 39.563360, -120.792790),
('95937', 2779, 1145, 38.884030, -121.998470),
('95938', 1639, 4451, 39.605040, -121.797080),
('95939', 1767, 376, 39.567550, -122.602240),
('95941', 1640, 396, 39.558800, -121.241570),
('95942', 1641, 1786, 39.989540, -121.588720),
('95943', 1768, 670, 39.576920, -122.036700),
('95944', 2581, 65, 39.534820, -120.861590),
('95945', 2173, 27388, 39.194260, -120.981990),
('95946', 2175, 9049, 39.210520, -121.204670),
('95947', 2256, 1407, 40.159420, -120.844090),
('95948', 1642, 11456, 39.342890, -121.758180),
('95949', 2173, 21232, 39.102000, -121.133430),
('95950', 1670, 442, 39.051440, -121.921960),
('95951', 1769, 2522, 39.714730, -122.001970),
('95953', 2668, 11201, 39.250180, -121.773090),
('95954', 1643, 10163, 39.949160, -121.540880),
('95955', 1671, 1413, 39.296570, -122.204540),
('95956', 2257, 458, 39.875100, -121.122090),
('95957', 2669, 752, 39.053660, -121.823790),
('95958', 1644, 0, 39.564170, -121.798040),
('95959', 2174, 18244, 39.345090, -120.867970),
('95960', 2583, 594, 39.391210, -121.058300),
('95961', 2797, 32663, 39.033430, -121.557540),
('95962', 2798, 1136, 39.326690, -121.268760),
('95963', 1770, 16485, 39.736820, -122.303290),
('95965', 1645, 20835, 39.591690, -121.590340),
('95966', 1645, 30108, 39.473320, -121.432840),
('95968', 1646, 1366, 39.435140, -121.551790),
('95969', 1647, 7564, 39.721780, -121.633880),
('95970', 1771, 466, 39.411590, -122.051760),
('95971', 2259, 5931, 39.928950, -120.916080),
('95972', 2799, 142, 39.429550, -121.336240),
('95973', 1637, 38323, 39.880990, -121.851600),
('95974', 1648, 65, 39.497300, -121.755690),
('95975', 2176, 1628, 39.224360, -121.153670),
('95977', 2800, 1822, 39.179670, -121.290070),
('95978', 1649, 98, 39.908260, -121.529410),
('95979', 1672, 374, 39.297710, -122.479130),
('95981', 2260, 52, 39.652370, -121.034470),
('95982', 2674, 3084, 39.180510, -121.807460),
('95983', 2261, 395, 40.058270, -120.738970),
('95984', 2262, 177, 39.996540, -121.119510),
('95986', 2178, 104, 39.361490, -120.765200),
('95987', 1673, 6504, 39.102990, -122.272600),
('95988', 1772, 8748, 39.498250, -122.286980),
('95991', 2675, 43978, 39.022050, -121.613170),
('95993', 2675, 37222, 39.081710, -121.687980),
('960', 22151, 3405, 18.416740, -66.143650),
('96001', 2572, 34721, 40.577310, -122.454430),
('96002', 2572, 34634, 40.529900, -122.316790),
('96003', 2572, 43945, 40.666640, -122.315640),
('96006', 1887, 587, 41.155750, -120.839520),
('96007', 2556, 24849, 40.455070, -122.304680),
('96008', 2557, 1123, 40.735590, -122.110910),
('96009', 1888, 247, 41.061830, -121.044340),
('96010', 2690, 28, 40.897350, -123.243650),
('96011', 2558, 232, 41.057620, -121.891570),
('96013', 2559, 4212, 40.974950, -121.683160),
('96014', 2586, 173, 41.357900, -122.773050),
('96015', 2121, 560, 41.496720, -120.871620),
('96016', 2560, 319, 40.906750, -121.520320),
('96017', 2561, 143, 41.107760, -122.307510),
('96019', 2575, 10466, 40.687290, -122.399270),
('96020', 2252, 2593, 40.300890, -121.262860),
('96021', 2676, 15746, 39.918710, -122.268130),
('96022', 2677, 14751, 40.342320, -122.448140),
('96023', 2587, 1189, 41.921080, -121.975920),
('96024', 2692, 1105, 40.587670, -122.901430),
('96025', 2588, 2247, 41.204090, -122.325230),
('96027', 2589, 1907, 41.365580, -123.077990),
('96028', 2562, 1805, 41.007610, -121.457310),
('96029', 2678, 120, 39.940030, -122.487430),
('96031', 2590, 66, 41.172620, -123.180290),
('96032', 2591, 2606, 41.585030, -122.982910),
('96033', 2563, 321, 40.750760, -122.600040),
('96034', 2592, 345, 41.441770, -122.607720),
('96035', 2679, 4097, 40.041680, -122.182540),
('96037', 2593, 131, 41.543680, -122.931770),
('96038', 2594, 499, 41.608270, -122.545760),
('96039', 2595, 726, 41.663760, -123.377110),
('96040', 2564, 71, 40.793930, -121.473970),
('96041', 2693, 3511, 40.520590, -123.199910),
('96044', 2596, 1215, 41.953840, -122.648530),
('96046', 2694, 328, 40.611180, -123.431510),
('96047', 2565, 843, 40.476950, -122.698890),
('96048', 2695, 1283, 40.826130, -123.055940),
('96050', 2597, 400, 41.853890, -122.956890),
('96051', 2566, 1067, 40.901120, -122.356640),
('96052', 2696, 2538, 40.685150, -122.803420),
('96054', 2128, 269, 41.266650, -121.106330),
('96055', 2680, 3760, 40.102490, -122.032130),
('96056', 1894, 1318, 41.071780, -121.326070),
('96057', 2599, 1158, 41.261440, -122.011800),
('96058', 2598, 809, 41.745360, -121.933700),
('96059', 2681, 323, 40.429470, -121.834650),
('96061', 2682, 0, 40.344070, -121.487670),
('96062', 2567, 1002, 40.563730, -122.066460),
('96063', 2683, 77, 40.357080, -121.602360),
('96064', 2600, 4690, 41.763710, -122.364330),
('96065', 2568, 364, 40.880560, -121.954330),
('96067', 2601, 7321, 41.316640, -122.317360),
('96068', 1896, 125, 41.105250, -121.204550),
('96069', 2569, 1390, 40.682260, -122.023410),
('96071', 2570, 7, 40.681340, -121.452750),
('96073', 2571, 5648, 40.590470, -122.205370),
('96074', 2684, 183, 39.871960, -122.585990),
('96075', 2685, 341, 40.355820, -121.871960),
('96076', 2698, 152, 40.375470, -122.929960),
('96078', 2686, 135, 40.082450, -122.176070),
('96080', 2687, 31190, 40.163860, -122.391710),
('96084', 2573, 664, 40.793950, -121.915190),
('96085', 2602, 38, 41.732450, -123.051450),
('96086', 2603, 268, 41.874070, -123.230120),
('96087', 2574, 824, 40.632960, -122.580670),
('96088', 2576, 4703, 40.509830, -121.888480),
('96090', 2688, 421, 40.006810, -122.121420),
('96091', 2700, 693, 41.045670, -122.780530),
('96092', 2689, 402, 39.973440, -121.973420),
('96093', 2701, 3959, 40.772370, -122.943290),
('96094', 2605, 6985, 41.512140, -122.362530),
('96096', 2577, 784, 40.637380, -121.875520),
('96097', 2606, 10154, 41.762340, -122.659210),
('961', 22151, 29271, 18.409870, -66.164150),
('96101', 2120, 4824, 41.458030, -120.504300),
('96103', 2250, 1340, 39.784460, -120.669690),
('96104', 2122, 962, 41.482480, -120.127250),
('96105', 2253, 429, 39.824780, -120.182100),
('96106', 2254, 465, 39.735520, -120.543880),
('96107', 2133, 868, 38.452150, -119.514210),
('96108', 2123, 149, 41.776870, -120.423510),
('96109', 1889, 1297, 39.997470, -120.095210),
('96110', 2124, 37, 41.266370, -120.107630),
('96111', 2172, 23, 39.415710, -120.016480),
('96112', 2125, 172, 41.837200, -120.094030),
('96113', 1890, 2164, 40.185770, -120.146090),
('96114', 1891, 2927, 40.294500, -120.493590),
('96115', 2126, 122, 41.707530, -120.140470),
('96116', 2127, 19, 41.260300, -120.448410),
('96117', 1892, 288, 40.545560, -120.239780),
('96118', 2582, 1581, 39.648230, -120.253920),
('96119', 1893, 31, 41.033530, -120.552640),
('96120', 1622, 1209, 38.745000, -119.824850),
('96121', 1895, 145, 40.169380, -120.376590),
('96122', 2258, 4121, 39.820820, -120.476520),
('96123', 1897, 62, 40.803920, -120.307990),
('96124', 2579, 320, 39.639180, -120.461940),
('96125', 2584, 234, 39.615260, -120.604930),
('96126', 2585, 227, 39.547640, -120.389990),
('96128', 1898, 600, 40.349480, -120.401980),
('96129', 2248, 640, 39.818480, -120.353460),
('96130', 1899, 21460, 40.549920, -120.630640),
('96132', 1900, 17, 40.893710, -120.538900),
('96133', 2137, 188, 38.631810, -119.504230),
('96134', 2129, 2236, 41.844400, -121.412310),
('96135', 2263, 106, 39.813030, -120.209270),
('96136', 1901, 40, 40.312630, -120.124250),
('96137', 1902, 2949, 40.385540, -121.124780),
('96140', 2226, 1219, 39.232440, -120.103640),
('96141', 2233, 592, 39.102970, -120.198720),
('96142', 1730, 946, 39.013800, -120.095920),
('96143', 2234, 3130, 39.261740, -120.028170),
('96145', 2245, 3081, 39.182030, -120.151430),
('96146', 2239, 1147, 39.225560, -120.236810),
('96148', 2246, 630, 39.249780, -120.057670),
('96150', 1729, 29457, 38.889710, -120.044090),
('96155', 1729, 0, 38.752940, -120.092220),
('96161', 2177, 19146, 39.348480, -120.226030),
('962', 22158, 19614, 18.435140, -66.139490),
('965', 22177, 5148, 18.428530, -66.111750),
('966', 22177, 16451, 18.397840, -66.113940),
('96701', 4613, 41560, 21.403680, -157.898750),
('96703', 4638, 3133, 22.134900, -159.371520),
('96704', 4585, 8543, 19.306120, -155.838840),
('96705', 4639, 2299, 21.899730, -159.562520),
('96706', 4614, 82504, 21.340330, -158.017040),
('96707', 4624, 49623, 21.364550, -158.081410),
('96708', 4654, 11511, 20.880830, -156.237630),
('96710', 4586, 267, 19.855160, -155.217840),
('96712', 4616, 8359, 21.626000, -158.035340),
('96713', 4655, 902, 20.736840, -156.115900),
('96714', 4640, 1278, 22.157340, -159.544720),
('96716', 4641, 2284, 21.911670, -159.601340),
('96717', 4617, 4555, 21.555560, -157.896050),
('96719', 4587, 1318, 20.240050, -155.833440),
('96720', 4588, 50453, 19.670220, -155.217180),
('96722', 4652, 2141, 22.166890, -159.458260),
('96725', 4589, 4610, 19.612430, -155.882400),
('96726', 4590, 32, 19.421470, -155.810940),
('96727', 4591, 4721, 20.008030, -155.548420),
('96728', 4592, 413, 19.859910, -155.133390),
('96729', 4656, 1436, 21.172140, -157.117220),
('96730', 4620, 1463, 21.546150, -157.851120),
('96731', 4621, 2742, 21.684880, -157.969990),
('96732', 4657, 25902, 20.875930, -156.460920),
('96734', 4622, 51966, 21.390020, -157.753870),
('96737', 4603, 3556, 19.107350, -155.780620),
('96738', 4612, 7797, 19.903410, -155.793920),
('96740', 4593, 40886, 19.744220, -155.899510),
('96741', 4642, 6231, 21.949860, -159.518470),
('96742', 4637, 50, 21.170890, -156.947530),
('96743', 4594, 13589, 20.026190, -155.722660),
('96744', 4623, 55888, 21.442700, -157.833280),
('96746', 4643, 20473, 22.091670, -159.349510),
('96747', 4644, 1498, 21.916900, -159.627880),
('96748', 4658, 4827, 21.113800, -156.879400),
('96749', 4596, 18482, 19.610310, -155.002810),
('96750', 4597, 3557, 19.524040, -155.914630),
('96751', 4645, 155, 22.106680, -159.305160),
('96752', 4646, 3221, 22.078230, -159.720770),
('96753', 4659, 28909, 20.731700, -156.436060),
('96754', 4647, 4397, 22.185370, -159.402460),
('96755', 4595, 3386, 20.196020, -155.781580),
('96756', 4648, 5804, 21.908500, -159.453680),
('96757', 4660, 739, 21.155360, -156.995130),
('96759', 4625, 277, 21.460150, -158.059950),
('96760', 4598, 3908, 19.552340, -155.054830),
('96761', 4662, 23214, 20.909610, -156.622260),
('96762', 4626, 5774, 21.624680, -157.942010),
('96763', 4663, 3218, 20.835120, -156.927170),
('96764', 4599, 495, 19.977660, -155.239850),
('96765', 4649, 733, 21.926080, -159.498310),
('96766', 4650, 17604, 22.005560, -159.419310),
('96768', 4664, 18662, 20.832310, -156.297870),
('96769', 4651, 309, 21.955010, -159.616550),
('96770', 4665, 465, 21.134650, -157.203540),
('96771', 4600, 7238, 19.533480, -155.135730),
('96772', 4601, 2716, 19.068300, -155.660770),
('96773', 4602, 154, 19.906770, -155.252180),
('96774', 4604, 294, 19.968710, -155.315030),
('96776', 4605, 1507, 20.001560, -155.387770),
('96777', 4606, 1949, 19.231370, -155.470500),
('96778', 4607, 14310, 19.452210, -154.986240),
('96779', 4666, 2489, 20.905340, -156.382080),
('96780', 4608, 459, 19.965920, -155.225000),
('96781', 4609, 1629, 19.800660, -155.181940),
('96782', 4629, 38674, 21.434710, -157.946940),
('96783', 4610, 1674, 19.842930, -155.107400),
('96785', 4611, 4220, 19.478180, -155.230170),
('96786', 4632, 42778, 21.537330, -158.023310),
('96789', 4628, 54362, 21.478230, -157.972640),
('96790', 4661, 9077, 20.697500, -156.311210),
('96791', 4633, 6419, 21.550720, -158.158570),
('96792', 4634, 51367, 21.463110, -158.164180),
('96793', 4667, 33414, 20.889980, -156.532150),
('96795', 4635, 10307, 21.339340, -157.716430),
('96796', 4653, 1951, 21.965120, -159.667930),
('96797', 4636, 72605, 21.407340, -158.016580),
('96799', 765, 0, -14.219840, -170.370050),
('968', 22177, 3554, 18.406090, -66.101230),
('96813', 4618, 25957, 21.316280, -157.843590),
('96814', 4618, 22723, 21.294050, -157.846370),
('96815', 4618, 27010, 21.273750, -157.821080),
('96816', 4618, 50793, 21.293790, -157.790090),
('96817', 4618, 55316, 21.340160, -157.837490),
('96818', 4618, 57938, 21.346370, -157.937040),
('96819', 4618, 52328, 21.349680, -157.875270);
INSERT INTO `zip` (`zip`, `city_id`, `population`, `lat`, `lng`) VALUES
('96820', 4618, 0, 21.336330, -157.920710),
('96821', 4618, 18802, 21.299520, -157.750040),
('96822', 4618, 45038, 21.320460, -157.810370),
('96825', 4618, 30444, 21.295750, -157.692340),
('96826', 4618, 30068, 21.291710, -157.826980),
('96848', 4618, 467, 21.301310, -157.814190),
('96850', 4618, 0, 21.303850, -157.862580),
('96853', 4619, 522, 21.335000, -157.940320),
('96857', 4630, 4620, 21.487980, -158.052930),
('96858', 4615, 312, 21.344590, -157.883420),
('96859', 4631, 0, 21.359870, -157.889850),
('96860', 4619, 4009, 21.356870, -157.948290),
('96863', 4627, 2530, 21.435100, -157.750020),
('969', 22177, 41784, 18.366960, -66.110000),
('96910', 4580, 0, 13.454720, 144.751280),
('96913', 4579, 0, 13.478250, 144.815190),
('96915', 4583, 0, 13.375260, 144.707140),
('96916', 4582, 0, 13.265930, 144.689150),
('96917', 4581, 0, 13.284690, 144.739910),
('96928', 4578, 0, 13.356260, 144.657310),
('96929', 4584, 0, 13.565210, 144.876370),
('96950', 18531, 0, 15.188880, 145.753490),
('96951', 18530, 0, 14.157330, 145.214500),
('96952', 18532, 0, 15.013110, 145.631490),
('97001', 20455, 386, 44.933280, -120.641690),
('97002', 20376, 6305, 45.237740, -122.800300),
('97003', 20464, 28639, 45.503720, -122.864820),
('97004', 20140, 4352, 45.250680, -122.453990),
('97005', 20464, 27543, 45.491440, -122.803970),
('97006', 20464, 45090, 45.525980, -122.855910),
('97007', 20464, 48524, 45.442820, -122.871120),
('97008', 20464, 29832, 45.460440, -122.802520),
('97009', 20141, 8538, 45.424090, -122.339620),
('97011', 20142, 903, 45.387380, -122.036710),
('97013', 20143, 24815, 45.217990, -122.672770),
('97014', 20247, 1491, 45.613540, -121.874050),
('97015', 20144, 23996, 45.414770, -122.537670),
('97016', 20169, 6551, 46.055730, -123.270320),
('97017', 20145, 3563, 45.170170, -122.376760),
('97018', 20170, 1773, 45.895700, -122.811650),
('97019', 20401, 2864, 45.494000, -122.188850),
('97020', 20378, 1151, 45.222670, -122.838870),
('97021', 20456, 1386, 45.390480, -121.134250),
('97022', 20147, 3213, 45.345620, -122.330600),
('97023', 20148, 11279, 45.191470, -122.205010),
('97024', 20402, 11488, 45.545760, -122.441420),
('97026', 20380, 3487, 45.104090, -122.942510),
('97027', 20149, 12442, 45.386970, -122.592710),
('97028', 20150, 190, 45.282250, -121.752740),
('97029', 20412, 390, 45.299010, -120.810030),
('97030', 20403, 38947, 45.508960, -122.431350),
('97031', 20248, 19376, 45.611930, -121.610940),
('97032', 20381, 4736, 45.179490, -122.785590),
('97033', 20413, 132, 45.233610, -120.587600),
('97034', 20152, 20930, 45.409500, -122.684670),
('97035', 20152, 26179, 45.412910, -122.726160),
('97037', 20457, 839, 45.065670, -121.031410),
('97038', 20153, 16423, 45.085750, -122.552880),
('97039', 20414, 464, 45.472260, -120.624280),
('97040', 20458, 1701, 45.626480, -121.384760),
('97041', 20249, 3171, 45.416550, -121.596170),
('97042', 20154, 3009, 45.206790, -122.532470),
('97045', 20155, 57575, 45.328340, -122.530580),
('97048', 20172, 7283, 46.039050, -122.994830),
('97049', 20157, 1956, 45.359310, -121.868290),
('97050', 20415, 220, 45.682560, -120.772700),
('97051', 20173, 17543, 45.889020, -122.920110),
('97053', 20176, 3662, 45.826950, -122.884010),
('97054', 20171, 1313, 45.954060, -122.929950),
('97055', 20158, 19621, 45.359750, -122.153960),
('97056', 20174, 12645, 45.789350, -122.969410),
('97057', 20459, 18, 45.004220, -120.751600),
('97058', 20460, 20855, 45.542390, -121.154470),
('97060', 20405, 22145, 45.534200, -122.369890),
('97062', 20476, 28845, 45.368210, -122.761690),
('97063', 20461, 862, 45.223190, -121.283060),
('97064', 20175, 3462, 45.872760, -123.230900),
('97065', 20416, 694, 45.598030, -120.656960),
('97067', 20159, 1805, 45.313020, -121.977330),
('97068', 20160, 30336, 45.351950, -122.668760),
('97070', 20161, 26001, 45.308000, -122.770590),
('97071', 20394, 31534, 45.135880, -122.823440),
('97078', 20464, 24790, 45.476280, -122.890880),
('97080', 20403, 47168, 45.478480, -122.390010),
('97086', 20151, 32537, 45.445310, -122.527930),
('97089', 20146, 14503, 45.425600, -122.443420),
('971', 22177, 26430, 18.320670, -66.117510),
('97101', 20480, 3890, 45.092250, -123.215570),
('97102', 20162, 420, 45.793400, -123.947930),
('97103', 20163, 17914, 46.133270, -123.696480),
('97106', 20463, 4770, 45.654190, -123.134170),
('97107', 20417, 2377, 45.561720, -123.882910),
('97108', 20418, 759, 45.274230, -123.675440),
('97109', 20465, 553, 45.737770, -123.194600),
('97110', 20164, 1185, 45.891860, -123.951280),
('97111', 20481, 4131, 45.290120, -123.198550),
('97112', 20419, 2110, 45.262180, -123.866290),
('97113', 20466, 14984, 45.507460, -123.045440),
('97114', 20482, 4999, 45.183810, -123.071720),
('97115', 20483, 3937, 45.275730, -123.026820),
('97116', 20467, 29182, 45.590540, -123.188760),
('97117', 20468, 866, 45.621890, -123.311320),
('97118', 20420, 716, 45.556970, -123.916190),
('97119', 20469, 5398, 45.471700, -123.207810),
('97121', 20165, 1714, 46.193470, -123.971410),
('97122', 20421, 373, 45.173310, -123.816400),
('97123', 20470, 48218, 45.443530, -122.980480),
('97124', 20470, 54493, 45.570880, -122.945840),
('97125', 20471, 88, 45.662430, -123.211170),
('97127', 20485, 4391, 45.246290, -123.111590),
('97128', 20486, 38272, 45.198140, -123.258120),
('97130', 20422, 718, 45.715920, -123.933180),
('97131', 20423, 2587, 45.714950, -123.810700),
('97132', 20487, 31289, 45.322720, -122.988540),
('97133', 20472, 5708, 45.687190, -123.028610),
('97134', 20425, 144, 45.455870, -123.965130),
('97135', 20426, 1593, 45.187490, -123.954940),
('97136', 20427, 2170, 45.634100, -123.913530),
('97137', 20387, 1152, 45.210280, -122.963500),
('97138', 20166, 11260, 45.909460, -123.700360),
('97140', 20474, 28438, 45.353590, -122.863390),
('97141', 20428, 12795, 45.471420, -123.737910),
('97144', 20475, 111, 45.743490, -123.303050),
('97145', 20167, 224, 45.843570, -123.951600),
('97146', 20168, 7438, 46.118490, -123.913990),
('97147', 20429, 429, 45.687100, -123.887300),
('97148', 20490, 2966, 45.359880, -123.265530),
('97149', 20424, 549, 45.099570, -123.944550),
('97201', 20404, 17508, 45.507960, -122.689590),
('97202', 20404, 43687, 45.482320, -122.643650),
('97203', 20404, 33327, 45.607640, -122.749230),
('97204', 20404, 1008, 45.518300, -122.673780),
('97205', 20404, 8861, 45.519240, -122.701270),
('97206', 20404, 51062, 45.481730, -122.598800),
('97208', 20404, 0, 45.528660, -122.678980),
('97209', 20404, 20445, 45.530930, -122.684290),
('97210', 20404, 12007, 45.549540, -122.735490),
('97211', 20404, 34376, 45.581740, -122.635480),
('97212', 20404, 27902, 45.544280, -122.643220),
('97213', 20404, 31810, 45.537760, -122.599570),
('97214', 20404, 28656, 45.513950, -122.644240),
('97215', 20404, 17780, 45.514360, -122.599230),
('97216', 20404, 17449, 45.513930, -122.558500),
('97217', 20404, 34884, 45.596860, -122.697170),
('97218', 20404, 15094, 45.575900, -122.600230),
('97219', 20404, 44074, 45.454130, -122.699720),
('97220', 20404, 28041, 45.551070, -122.559150),
('97221', 20404, 13154, 45.497990, -122.727490),
('97222', 20156, 37058, 45.441140, -122.616820),
('97223', 20473, 50027, 45.440230, -122.778380),
('97224', 20473, 36591, 45.405680, -122.795800),
('97225', 20473, 26139, 45.502000, -122.769940),
('97227', 20404, 6199, 45.544320, -122.677210),
('97229', 20473, 74755, 45.550320, -122.810260),
('97230', 20404, 41799, 45.558200, -122.506000),
('97231', 20404, 3835, 45.681970, -122.826870),
('97232', 20404, 14941, 45.529200, -122.643760),
('97233', 20404, 37625, 45.513910, -122.498870),
('97236', 20404, 39033, 45.484740, -122.510550),
('97239', 20404, 18337, 45.488930, -122.690530),
('97266', 20404, 35719, 45.482680, -122.558380),
('97267', 20156, 31130, 45.407440, -122.614720),
('97301', 20388, 55386, 44.949480, -123.004390),
('97302', 20388, 41382, 44.901910, -123.067190),
('97303', 20388, 41143, 45.030360, -123.024490),
('97304', 20411, 34148, 45.007800, -123.107800),
('97305', 20388, 44994, 45.015730, -122.929090),
('97306', 20388, 34946, 44.845850, -123.079720),
('97310', 20388, 1099, 44.900480, -122.974360),
('97317', 20388, 25884, 44.902420, -122.906280),
('97321', 20346, 29970, 44.649940, -123.134740),
('97322', 20346, 37008, 44.625240, -123.019750),
('97324', 20136, 1273, 44.343450, -123.630420),
('97325', 20375, 6943, 44.831410, -122.851950),
('97326', 20330, 865, 44.627940, -123.615730),
('97327', 20347, 3020, 44.375670, -122.947830),
('97329', 20348, 68, 44.395600, -122.336980),
('97330', 20137, 44744, 44.637960, -123.278140),
('97331', 20137, 3533, 44.563430, -123.281130),
('97333', 20137, 23028, 44.473500, -123.306700),
('97335', 20349, 249, 44.637760, -122.880450),
('97336', 20350, 78, 44.356690, -122.850920),
('97338', 20406, 23201, 44.936540, -123.338680),
('97341', 20331, 3315, 44.815250, -124.045130),
('97342', 20377, 116, 44.733820, -121.945240),
('97343', 20332, 484, 44.569340, -123.730910),
('97344', 20407, 1605, 44.868870, -123.465960),
('97345', 20351, 434, 44.412600, -122.576440),
('97346', 20379, 1031, 44.769480, -122.378570),
('97347', 20484, 1457, 45.078360, -123.659430),
('97348', 20352, 1986, 44.387680, -123.125820),
('97350', 20354, 141, 44.647860, -121.961460),
('97351', 20408, 11144, 44.838570, -123.174490),
('97352', 20382, 6488, 44.750090, -123.024190),
('97355', 20355, 32777, 44.531500, -122.817010),
('97357', 20335, 163, 44.739340, -123.815920),
('97358', 20383, 2417, 44.806810, -122.407020),
('97360', 20356, 2183, 44.751500, -122.485290),
('97361', 20409, 13557, 44.772510, -123.329990),
('97362', 20385, 4107, 45.069030, -122.769200),
('97364', 20336, 498, 44.998890, -123.987030),
('97365', 20337, 10866, 44.671130, -124.018250),
('97366', 20342, 1979, 44.582880, -124.047480),
('97367', 20334, 11230, 44.912200, -123.969140),
('97368', 20338, 3012, 45.007300, -123.891550),
('97369', 20339, 274, 44.760150, -124.056760),
('97370', 20139, 9193, 44.579010, -123.469070),
('97371', 20410, 607, 44.989850, -123.199400),
('97373', 20386, 172, 45.058190, -122.776770),
('97374', 20357, 4364, 44.692850, -122.773790),
('97375', 20389, 1336, 44.979220, -122.602100),
('97376', 20340, 1097, 44.508540, -123.976800),
('97377', 20358, 581, 44.464030, -123.101560),
('97378', 20488, 10523, 45.080580, -123.431270),
('97380', 20341, 2297, 44.772680, -123.942020),
('97381', 20390, 15526, 44.970140, -122.747490),
('97383', 20391, 9992, 44.800140, -122.718360),
('97384', 20384, 86, 44.791090, -122.620070),
('97385', 20392, 3913, 44.866330, -122.729240),
('97386', 20360, 15437, 44.360620, -122.750760),
('97388', 20333, 920, 44.874180, -124.011690),
('97389', 20361, 1658, 44.532690, -123.090280),
('97390', 20343, 515, 44.337810, -123.857170),
('97391', 20344, 6076, 44.595930, -123.881600),
('97392', 20393, 6584, 44.790960, -122.941300),
('97394', 20345, 5355, 44.406070, -124.002580),
('97396', 20489, 3349, 45.115280, -123.527500),
('97401', 20310, 48214, 44.068030, -123.081710),
('97402', 20310, 52925, 44.051930, -123.230220),
('97403', 20310, 15303, 44.035410, -123.052470),
('97404', 20310, 34338, 44.105180, -123.133150),
('97405', 20310, 46695, 43.955280, -123.167000),
('97406', 20189, 303, 42.626380, -123.998670),
('97408', 20310, 14767, 44.144350, -123.054520),
('97410', 20200, 436, 42.801590, -123.119310),
('97411', 20177, 7328, 43.075570, -124.362400),
('97412', 20301, 633, 44.196250, -123.561060),
('97413', 20302, 892, 44.096330, -122.015130),
('97414', 20178, 272, 42.966530, -124.150260),
('97415', 20190, 14372, 42.139770, -124.135060),
('97416', 20201, 1250, 43.035240, -123.691230),
('97417', 20202, 2415, 42.940140, -123.218020),
('97419', 20303, 759, 44.179300, -123.407190),
('97420', 20179, 28178, 43.348390, -124.108250),
('97423', 20180, 5945, 43.191370, -124.171770),
('97424', 20304, 18382, 43.747120, -123.054960),
('97426', 20305, 10209, 43.903130, -123.027810),
('97429', 20203, 821, 42.967780, -123.054420),
('97430', 20306, 374, 44.155070, -123.711750),
('97431', 20307, 2446, 43.871350, -122.815760),
('97432', 20204, 187, 43.104450, -123.429400),
('97434', 20308, 817, 43.665530, -122.782110),
('97435', 20205, 2594, 43.701600, -123.338390),
('97436', 20206, 703, 43.639580, -123.582560),
('97437', 20309, 2483, 44.097340, -123.387310),
('97438', 20311, 1296, 43.960680, -122.655460),
('97439', 20312, 15636, 44.065730, -124.037050),
('97441', 20207, 278, 43.776590, -124.144140),
('97442', 20208, 1954, 42.769820, -123.403650),
('97443', 20209, 3253, 43.250140, -123.002550),
('97444', 20191, 5888, 42.444530, -124.332230),
('97446', 20353, 5405, 44.268040, -123.055480),
('97447', 20210, 581, 43.284090, -122.498070),
('97448', 20313, 14618, 44.210500, -123.278820),
('97449', 20181, 2115, 43.575710, -124.085810),
('97450', 20192, 765, 42.910260, -124.373980),
('97451', 20314, 561, 43.839980, -123.313830),
('97452', 20315, 1674, 43.885640, -122.722590),
('97453', 20316, 845, 43.994220, -123.863440),
('97454', 20317, 1076, 44.218060, -122.819100),
('97455', 20320, 2252, 43.962120, -122.914930),
('97456', 20138, 3190, 44.340360, -123.358930),
('97457', 20211, 9632, 43.054840, -123.222900),
('97458', 20182, 4754, 43.063720, -124.012870),
('97459', 20183, 15054, 43.474440, -124.182160),
('97461', 20318, 981, 44.097890, -123.489930),
('97462', 20212, 4251, 43.490470, -123.388280),
('97463', 20319, 3957, 43.739510, -122.405910),
('97465', 20193, 1804, 42.737600, -124.379500),
('97466', 20184, 1255, 42.864590, -124.086320),
('97467', 20213, 5425, 43.735570, -123.904420),
('97469', 20214, 2788, 42.919940, -123.414590),
('97470', 20215, 19064, 43.232880, -123.231110),
('97471', 20215, 32182, 43.222150, -123.474860),
('97473', 20216, 315, 43.677300, -123.872600),
('97476', 20194, 302, 42.840750, -124.438060),
('97477', 20321, 38105, 44.058610, -123.011260),
('97478', 20321, 39268, 44.087810, -122.844780),
('97479', 20217, 10265, 43.401940, -123.194260),
('97480', 20322, 328, 44.130300, -123.832130),
('97481', 20218, 781, 43.113760, -123.552370),
('97484', 20219, 225, 42.933730, -122.845850),
('97486', 20220, 688, 43.377780, -123.535100),
('97487', 20323, 8809, 43.994410, -123.393030),
('97488', 20324, 893, 44.130770, -122.411980),
('97489', 20325, 972, 44.109860, -122.619620),
('97490', 20326, 499, 44.007950, -123.605220),
('97492', 20327, 1043, 43.771680, -122.498680),
('97493', 20328, 324, 43.902560, -124.016020),
('97494', 20221, 28, 43.330590, -123.327790),
('97495', 20222, 1798, 43.287650, -123.304630),
('97496', 20223, 7289, 43.052610, -123.499920),
('97497', 20276, 1283, 42.660150, -123.409290),
('97498', 20329, 2044, 44.277280, -124.019010),
('97499', 20224, 1782, 43.594950, -123.233560),
('97501', 20256, 45900, 42.285600, -122.894590),
('97502', 20252, 29271, 42.409270, -122.947180),
('97503', 20263, 14539, 42.583600, -122.927210),
('97504', 20256, 49426, 42.327570, -122.800680),
('97520', 20250, 26556, 42.154720, -122.531680),
('97522', 20251, 585, 42.565940, -122.468860),
('97523', 20268, 6436, 42.113490, -123.629610),
('97524', 20253, 15693, 42.462710, -122.663270),
('97525', 20254, 4981, 42.435570, -123.076060),
('97526', 20269, 35742, 42.512750, -123.339640),
('97527', 20269, 37051, 42.376150, -123.382880),
('97530', 20255, 8544, 42.137780, -123.105070),
('97531', 20270, 321, 42.207390, -123.643910),
('97532', 20271, 2580, 42.561420, -123.585860),
('97534', 20272, 668, 42.036160, -123.716410),
('97535', 20257, 4863, 42.267990, -122.812380),
('97536', 20258, 1165, 42.784550, -122.508020),
('97537', 20259, 6725, 42.550410, -123.133570),
('97538', 20273, 2113, 42.296230, -123.657230),
('97539', 20260, 3213, 42.599990, -122.790240),
('97540', 20261, 8641, 42.186150, -122.800270),
('97541', 20262, 1593, 42.729830, -122.753590),
('97543', 20274, 594, 42.377240, -123.560310),
('97544', 20275, 2115, 42.207000, -123.300060),
('976', 22222, 61638, 18.339030, -65.992860),
('97601', 20288, 22302, 42.444040, -122.067410),
('97603', 20288, 32376, 42.137040, -121.677660),
('97604', 20282, 0, 42.977780, -122.206740),
('97620', 20293, 39, 42.223000, -119.896770),
('97621', 20277, 239, 42.515040, -121.288100),
('97622', 20278, 223, 42.396670, -121.010320),
('97623', 20279, 2705, 42.199050, -121.310160),
('97624', 20281, 3643, 42.721210, -121.694150),
('97625', 20284, 124, 42.315070, -121.584020),
('97626', 20285, 223, 42.724880, -122.020110),
('97627', 20287, 654, 42.080360, -122.057960),
('97630', 20296, 5285, 42.298320, -120.391660),
('97632', 20289, 1608, 42.041750, -121.405970),
('97633', 20290, 1526, 42.030140, -121.563280),
('97634', 20291, 445, 42.127470, -121.803480),
('97635', 20395, 345, 41.931730, -120.299740),
('97636', 20297, 396, 42.687750, -120.567460),
('97637', 20298, 115, 42.461420, -119.924860),
('97638', 20299, 427, 43.145800, -121.011560),
('97639', 20292, 33, 42.434350, -121.498450),
('97640', 20300, 130, 42.907420, -120.653810),
('97641', 20294, 1410, 43.287420, -120.538090),
('97701', 20195, 41577, 44.000650, -121.032890),
('97702', 20195, 52420, 43.983360, -121.210830),
('97703', 20195, 33279, 44.072810, -121.519710),
('97707', 20195, 6326, 43.830310, -121.493650),
('97709', 20195, 0, 43.893380, -121.856270),
('97710', 20242, 68, 42.150950, -118.539020),
('97711', 20264, 38, 44.723900, -120.634890),
('97712', 20196, 58, 43.778250, -120.428660),
('97720', 20238, 4406, 43.587990, -118.858060),
('97721', 20245, 220, 42.887720, -118.526350),
('97722', 20240, 33, 42.957330, -118.692410),
('97730', 20265, 321, 44.522650, -121.645350),
('97731', 20280, 273, 43.131500, -121.920890),
('97732', 20239, 142, 43.413690, -118.402650),
('97733', 20283, 468, 43.384410, -121.947780),
('97734', 20266, 3746, 44.535020, -121.333950),
('97735', 20295, 157, 43.390140, -120.992240),
('97736', 20243, 112, 42.666550, -118.920580),
('97737', 20286, 492, 43.508970, -121.719170),
('97738', 20244, 2226, 43.512180, -119.250780),
('97739', 20197, 13490, 43.672590, -121.486930),
('97741', 20267, 13390, 44.657710, -121.042910),
('97750', 20478, 402, 44.670370, -120.127040),
('97751', 20185, 118, 44.148560, -119.819450),
('97752', 20186, 0, 44.140940, -120.205840),
('97753', 20187, 3174, 44.226250, -120.999960),
('97754', 20188, 21552, 44.135770, -120.528480),
('97756', 20198, 43545, 44.280790, -121.193350),
('97758', 20246, 67, 43.414490, -119.748590),
('97759', 20359, 7687, 44.444280, -121.768230),
('97760', 20199, 7825, 44.386620, -121.233230),
('97761', 20462, 3229, 44.843300, -121.298070),
('97801', 20437, 21748, 45.673170, -118.833620),
('97810', 20430, 1047, 45.672500, -118.396420),
('97812', 20225, 883, 45.581380, -120.219070),
('97813', 20431, 1468, 45.853050, -118.528020),
('97814', 20126, 12636, 44.800750, -117.770340),
('97817', 20227, 37, 44.655500, -118.608160),
('97818', 20396, 5252, 45.756700, -119.784440),
('97819', 20127, 18, 44.486030, -117.763170),
('97820', 20228, 1137, 44.163270, -119.214360),
('97823', 20226, 1060, 45.243340, -120.190970),
('97824', 20443, 1965, 45.349920, -117.755060),
('97825', 20229, 407, 44.388040, -119.518520),
('97826', 20432, 1185, 45.655080, -119.225860),
('97827', 20444, 2599, 45.608540, -117.858860),
('97828', 20450, 3301, 45.713820, -117.259710),
('97830', 20477, 635, 44.977900, -120.171650),
('97833', 20129, 644, 44.934710, -118.059510),
('97834', 20130, 1431, 44.972510, -117.205090),
('97835', 20433, 488, 45.899200, -118.772000),
('97836', 20397, 2176, 45.291660, -119.501440),
('97837', 20131, 50, 44.511270, -118.048300),
('97838', 20434, 27713, 45.852660, -119.288780),
('97839', 20400, 294, 45.582720, -119.600050),
('97840', 20133, 82, 44.902180, -116.936080),
('97841', 20445, 491, 45.468230, -117.940350),
('97842', 20451, 85, 45.572230, -116.823840),
('97843', 20398, 790, 45.504790, -119.880660),
('97844', 20399, 3633, 45.878670, -119.546760),
('97845', 20230, 2300, 44.414450, -118.903720),
('97846', 20452, 2062, 45.274650, -117.109560),
('97848', 20231, 215, 44.697610, -119.573360),
('97850', 20446, 16646, 45.306890, -118.132650),
('97856', 20232, 498, 44.784260, -119.129760),
('97857', 20453, 649, 45.372730, -117.504180),
('97859', 20435, 235, 45.525800, -118.432090),
('97862', 20436, 12460, 45.927120, -118.317970),
('97864', 20233, 295, 44.838420, -119.454710),
('97865', 20234, 1133, 44.429490, -119.191920),
('97867', 20447, 1001, 45.062700, -117.997000),
('97868', 20438, 1594, 45.408150, -118.869640),
('97869', 20235, 938, 44.379930, -118.614250),
('97870', 20134, 580, 44.794340, -117.190330),
('97873', 20236, 167, 44.128370, -118.995050),
('97874', 20479, 366, 44.757830, -119.848280),
('97875', 20439, 2608, 45.814810, -119.148980),
('97876', 20448, 1085, 45.522370, -118.028110),
('97877', 20237, 319, 44.806620, -118.387660),
('97880', 20440, 348, 45.086310, -118.892690),
('97882', 20441, 8081, 45.907410, -119.349440),
('97883', 20449, 2575, 45.142640, -117.640470),
('97884', 20135, 122, 44.449750, -118.218950),
('97885', 20454, 1342, 45.650730, -117.509720),
('97886', 20442, 948, 45.796040, -118.249240),
('979', 22157, 16890, 18.437340, -66.008900),
('97901', 20362, 676, 43.599600, -117.096020),
('97902', 20363, 27, 42.913320, -117.494120),
('97903', 20364, 24, 44.277720, -117.597750),
('97904', 20241, 222, 43.891360, -118.505810),
('97905', 20128, 104, 44.581830, -117.465400),
('97906', 20365, 322, 43.460490, -117.817830),
('97907', 20132, 761, 44.418930, -117.355680),
('97908', 20366, 25, 44.256790, -117.948280),
('97909', 20367, 22, 44.210960, -117.379090),
('97910', 20368, 627, 42.857330, -117.509090),
('97911', 20369, 52, 43.855470, -118.026050),
('97913', 20370, 5475, 43.646880, -117.281310),
('97914', 20371, 19802, 44.110850, -117.073830),
('97917', 20372, 41, 43.541500, -118.116510),
('97918', 20373, 4389, 43.962550, -117.380730),
('97920', 20374, 28, 44.065950, -117.759970),
('98001', 26354, 35842, 47.309190, -122.264260),
('98002', 26354, 36812, 47.308200, -122.215670),
('98003', 26363, 51329, 47.305960, -122.314650),
('98004', 26356, 39161, 47.618650, -122.205480),
('98005', 26356, 22030, 47.614940, -122.168140),
('98006', 26356, 39753, 47.557720, -122.149570),
('98007', 26356, 27571, 47.613920, -122.143780),
('98008', 26356, 27060, 47.605510, -122.112190),
('98010', 26357, 6128, 47.311730, -122.003260),
('98011', 26358, 27573, 47.757360, -122.198710),
('98012', 26560, 75555, 47.842050, -122.198130),
('98014', 26359, 7626, 47.696640, -121.840240),
('98019', 26360, 11281, 47.740830, -121.934940),
('98020', 26562, 19323, 47.800150, -122.372670),
('98021', 26560, 34993, 47.792570, -122.208460),
('98022', 26361, 22163, 47.171400, -121.679580),
('98023', 26363, 50778, 47.308810, -122.361980),
('98024', 26362, 5066, 47.573010, -121.902190),
('98025', 26364, 0, 47.434410, -121.952400),
('98026', 26562, 39035, 47.835550, -122.331600),
('98027', 26365, 27915, 47.503870, -122.001760),
('98028', 26366, 23611, 47.751620, -122.248920),
('98029', 26365, 31227, 47.557600, -122.009100),
('98030', 26367, 38798, 47.368170, -122.197490),
('98031', 26367, 41615, 47.405500, -122.194300),
('98032', 26367, 39126, 47.392200, -122.258190),
('98033', 26368, 40425, 47.676160, -122.192670),
('98034', 26368, 52636, 47.716120, -122.213320),
('98036', 26568, 42164, 47.810940, -122.281550),
('98037', 26568, 29720, 47.838730, -122.284630),
('98038', 26369, 37877, 47.418610, -121.955890),
('98039', 26370, 2923, 47.633080, -122.239630),
('98040', 26371, 25464, 47.566110, -122.232000),
('98042', 26367, 49338, 47.365080, -122.116230),
('98043', 26571, 21347, 47.792100, -122.307580),
('98045', 26372, 15412, 47.482760, -121.656780),
('98047', 26373, 7014, 47.260790, -122.248220),
('98050', 26374, 73, 47.547640, -121.936630),
('98051', 26375, 3827, 47.339600, -121.890490),
('98052', 26376, 77324, 47.681480, -122.120300),
('98053', 26376, 22765, 47.664910, -122.020710),
('98055', 26377, 24429, 47.447750, -122.202050),
('98056', 26377, 36116, 47.512810, -122.189230),
('98057', 26377, 12774, 47.471880, -122.219610),
('98058', 26377, 42046, 47.440820, -122.125030),
('98059', 26377, 41619, 47.495630, -122.124740),
('98065', 26381, 15960, 47.592340, -121.789310),
('98068', 26404, 528, 47.451540, -121.357950),
('98070', 26382, 10939, 47.412190, -122.472600),
('98072', 26383, 25034, 47.761510, -122.131530),
('98074', 26378, 31026, 47.622060, -122.044370),
('98075', 26378, 25202, 47.586830, -122.037960),
('98077', 26383, 14287, 47.752630, -122.057540),
('98087', 26568, 41849, 47.862400, -122.266400),
('98092', 26354, 50679, 47.288510, -122.131230),
('98101', 26379, 16302, 47.611190, -122.334540),
('98102', 26379, 25827, 47.636270, -122.323370),
('98103', 26379, 51878, 47.673200, -122.342580),
('98104', 26379, 15052, 47.600440, -122.330040),
('98105', 26379, 50302, 47.660940, -122.283210),
('98106', 26379, 28243, 47.543390, -122.353660),
('98107', 26379, 28170, 47.667570, -122.377890),
('98108', 26379, 23762, 47.541130, -122.312600),
('98109', 26379, 32251, 47.631280, -122.344860),
('98110', 26384, 24681, 47.643890, -122.543350),
('98112', 26379, 23456, 47.632420, -122.287320),
('98115', 26379, 54457, 47.685470, -122.282340),
('98116', 26379, 27871, 47.573990, -122.395030),
('98117', 26379, 36115, 47.688200, -122.381570),
('98118', 26379, 48874, 47.542350, -122.268720),
('98119', 26379, 25906, 47.639430, -122.369320),
('98121', 26379, 20562, 47.615480, -122.346680),
('98122', 26379, 41268, 47.609850, -122.295690),
('98125', 26379, 43993, 47.717060, -122.299690),
('98126', 26379, 21102, 47.547320, -122.374540),
('98133', 26379, 50921, 47.739900, -122.344320),
('98134', 26379, 852, 47.576910, -122.336860),
('98136', 26379, 17420, 47.536860, -122.389920),
('98144', 26379, 32540, 47.585820, -122.292050),
('98146', 26379, 28088, 47.500080, -122.357680),
('98148', 26379, 10652, 47.444940, -122.325870),
('98154', 26379, 0, 47.606210, -122.333790),
('98155', 26379, 35550, 47.756090, -122.300390),
('98158', 26379, 0, 47.450430, -122.308050),
('98164', 26379, 239, 47.605960, -122.332030),
('98166', 26379, 22418, 47.452560, -122.349780),
('98168', 26379, 35050, 47.488980, -122.301750),
('98174', 26379, 0, 47.604770, -122.335280),
('98177', 26379, 21114, 47.742370, -122.370850),
('98178', 26379, 26760, 47.499210, -122.247350),
('98188', 26379, 27523, 47.447540, -122.273980),
('98195', 26379, 2398, 47.654660, -122.307520),
('98198', 26379, 38942, 47.394690, -122.311110),
('98199', 26379, 22359, 47.651390, -122.402230),
('982', 22157, 13876, 18.409610, -65.991430),
('98201', 26563, 30587, 47.993730, -122.185630),
('98203', 26563, 36448, 47.942360, -122.236510),
('98204', 26563, 41709, 47.901050, -122.258600),
('98207', 26563, 1143, 47.987930, -122.222900),
('98208', 26563, 60723, 47.900720, -122.188520),
('98220', 26637, 577, 48.685260, -122.196780),
('98221', 26541, 22969, 48.504010, -122.654350),
('98222', 26532, 117, 48.560850, -122.802630),
('98223', 26559, 46117, 48.209940, -121.950810),
('98224', 26355, 220, 47.735700, -121.568590),
('98225', 26638, 49667, 48.754610, -122.503070),
('98226', 26638, 45703, 48.800640, -122.422990),
('98229', 26638, 34157, 48.696150, -122.409790),
('98230', 26639, 18605, 48.956880, -122.708400),
('98232', 26542, 3939, 48.565310, -122.414980),
('98233', 26543, 16952, 48.503090, -122.351020),
('98235', 26544, 570, 48.460200, -122.228460),
('98236', 26340, 6790, 47.958040, -122.404680),
('98237', 26545, 4979, 48.532720, -121.697480),
('98238', 26546, 45, 48.335630, -122.344440),
('98239', 26341, 7634, 48.189260, -122.657560),
('98240', 26640, 3426, 48.947110, -122.620610),
('98241', 26561, 2150, 48.214250, -121.332190),
('98243', 26533, 297, 48.615120, -122.998820),
('98244', 26641, 3284, 48.794230, -121.935570),
('98245', 26534, 4088, 48.662410, -122.916160),
('98247', 26642, 8468, 48.904590, -122.317320),
('98248', 26643, 27147, 48.864940, -122.622110),
('98249', 26342, 4372, 48.018880, -122.539470),
('98250', 26535, 8953, 48.552640, -123.096310),
('98251', 26564, 4703, 47.898120, -121.557520),
('98252', 26565, 9905, 48.061730, -121.709390),
('98253', 26343, 2106, 48.079000, -122.575680),
('98255', 26547, 312, 48.523530, -121.992030),
('98256', 26566, 318, 47.828830, -121.414640),
('98257', 26548, 4484, 48.415000, -122.508790),
('98258', 26567, 50582, 48.032520, -122.077620),
('98260', 26344, 5434, 48.030740, -122.451060),
('98261', 26536, 3112, 48.483810, -122.883020),
('98262', 26644, 965, 48.693170, -122.664060),
('98263', 26549, 178, 48.522810, -122.065700),
('98264', 26645, 22334, 48.949720, -122.456720),
('98266', 26646, 3983, 48.957600, -122.061890),
('98267', 26550, 160, 48.437560, -121.308410),
('98270', 26569, 52794, 48.059520, -122.144300),
('98271', 26569, 30262, 48.093730, -122.235590),
('98272', 26570, 31866, 47.858340, -121.884570),
('98273', 26551, 30430, 48.405220, -122.368410),
('98274', 26551, 18360, 48.360130, -122.143460),
('98275', 26572, 21365, 47.909940, -122.301130),
('98276', 26647, 1564, 48.927650, -122.320960),
('98277', 26345, 40181, 48.316880, -122.631520),
('98278', 26345, 2351, 48.343880, -122.664910),
('98279', 26537, 614, 48.644740, -122.806020),
('98280', 26538, 398, 48.608660, -122.905540),
('98281', 26648, 1249, 48.988170, -123.057670),
('98282', 26339, 17642, 48.187190, -122.469660),
('98283', 26649, 466, 48.801370, -121.299970),
('98284', 26552, 27688, 48.552110, -122.117630),
('98286', 26539, 158, 48.572620, -122.957120),
('98288', 26380, 180, 47.652040, -121.357400),
('98290', 26573, 39873, 47.951410, -121.984210),
('98292', 26574, 25757, 48.224550, -122.303200),
('98294', 26575, 7516, 47.844310, -121.758220),
('98295', 26650, 3033, 48.971630, -122.221300),
('98296', 26573, 27436, 47.842660, -122.101990),
('98297', 26540, 55, 48.700500, -123.028340),
('983', 22157, 31816, 18.417880, -65.981040),
('98303', 26502, 1621, 47.157830, -122.703870),
('98304', 26503, 925, 46.870360, -121.739850),
('98305', 26253, 258, 48.031480, -124.229340),
('98310', 26385, 21692, 47.589390, -122.617500),
('98311', 26385, 27527, 47.628290, -122.637930),
('98312', 26385, 32288, 47.564350, -122.757060),
('98314', 26385, 1565, 47.562430, -122.638930),
('98315', 26396, 6045, 47.722630, -122.714440),
('98320', 26346, 1483, 47.698610, -123.017420),
('98321', 26505, 16936, 47.155640, -122.065760),
('98323', 26507, 655, 46.980590, -122.006000),
('98325', 26347, 1481, 47.960930, -122.779110),
('98326', 26254, 1066, 48.173640, -124.452780),
('98327', 26508, 9955, 47.102030, -122.660610),
('98328', 26509, 10451, 46.860550, -122.172270),
('98329', 26513, 11223, 47.377310, -122.725230),
('98330', 26510, 24, 46.758740, -122.158940),
('98331', 26348, 5671, 47.772920, -124.127300),
('98332', 26513, 19708, 47.365140, -122.598580),
('98333', 26512, 3644, 47.247710, -122.625610),
('98335', 26513, 28002, 47.299090, -122.619110),
('98336', 26429, 594, 46.563820, -122.109390),
('98337', 26385, 8785, 47.563450, -122.634050),
('98338', 26514, 32522, 47.019270, -122.283470),
('98339', 26350, 3295, 48.029910, -122.743640),
('98340', 26386, 2692, 47.906220, -122.564060),
('98342', 26387, 1362, 47.754750, -122.519520),
('98345', 26388, 284, 47.699720, -122.623660),
('98346', 26389, 9973, 47.820050, -122.533990),
('98349', 26515, 5050, 47.265830, -122.773660),
('98350', 26255, 352, 47.906830, -124.625090),
('98351', 26517, 1119, 47.203530, -122.767730),
('98353', 26390, 14, 47.538850, -122.492940),
('98354', 26520, 8146, 47.251130, -122.315570),
('98355', 26430, 749, 46.691790, -122.039780),
('98356', 26431, 2367, 46.579430, -122.269130),
('98357', 26256, 1550, 48.331880, -124.628160),
('98358', 26349, 882, 48.057960, -122.700080),
('98359', 26391, 4889, 47.430470, -122.576310),
('98360', 26521, 14976, 47.032460, -122.157500),
('98361', 26435, 420, 46.627860, -121.563850),
('98362', 26257, 24544, 48.016390, -123.319510),
('98363', 26257, 14284, 48.034770, -123.769520),
('98364', 26392, 57, 47.854550, -122.586380),
('98365', 26351, 5259, 47.895450, -122.702710),
('98366', 26393, 37437, 47.537320, -122.586470),
('98367', 26393, 31186, 47.461410, -122.676620),
('98368', 26352, 17046, 48.038790, -122.844060),
('98370', 26394, 32862, 47.751140, -122.623730),
('98371', 26522, 22983, 47.199570, -122.321910),
('98372', 26522, 26470, 47.206400, -122.266890),
('98373', 26522, 30096, 47.147610, -122.325060),
('98374', 26522, 45555, 47.129040, -122.261560),
('98375', 26522, 32595, 47.103940, -122.323830),
('98376', 26353, 2109, 47.845500, -122.859160),
('98377', 26437, 2392, 46.505860, -121.819120),
('98380', 26395, 5582, 47.574300, -122.902870),
('98381', 26258, 282, 48.288630, -124.456810),
('98382', 26259, 30777, 48.013100, -123.074370),
('98383', 26396, 22764, 47.662120, -122.716520),
('98385', 26524, 464, 47.137910, -122.094690),
('98387', 26525, 51384, 47.056200, -122.391110),
('98388', 26526, 7051, 47.198920, -122.662680),
('98390', 26527, 11482, 47.211950, -122.228940),
('98391', 26504, 56646, 47.176540, -122.173620),
('98392', 26397, 3203, 47.734250, -122.563100),
('98394', 26530, 1244, 47.320110, -122.777910),
('98396', 26531, 643, 47.106690, -122.010520),
('98402', 26528, 7088, 47.250210, -122.440560),
('98403', 26528, 8613, 47.265810, -122.459210),
('98404', 26528, 36025, 47.209270, -122.411390),
('98405', 26528, 24264, 47.245990, -122.472220),
('98406', 26528, 22994, 47.262830, -122.508570),
('98407', 26528, 21050, 47.288890, -122.511100),
('98408', 26528, 21438, 47.198110, -122.446380),
('98409', 26528, 28645, 47.210840, -122.481970),
('98416', 26528, 830, 47.262710, -122.481960),
('98418', 26528, 10082, 47.223250, -122.446420),
('98421', 26528, 790, 47.258190, -122.401070),
('98422', 26528, 22066, 47.289070, -122.391230),
('98424', 26511, 12026, 47.234300, -122.352300),
('98430', 26506, 580, 47.117330, -122.568960),
('98433', 26528, 20342, 47.091210, -122.607720),
('98438', 26518, 560, 47.135140, -122.492110),
('98439', 26516, 5679, 47.131640, -122.496030),
('98443', 26528, 5899, 47.205220, -122.375920),
('98444', 26528, 35366, 47.152280, -122.448870),
('98445', 26528, 33252, 47.139850, -122.409650),
('98446', 26528, 13821, 47.129350, -122.374240),
('98447', 26528, 1067, 47.145310, -122.443920),
('98465', 26528, 7528, 47.248680, -122.530430),
('98466', 26528, 30405, 47.228420, -122.534790),
('98467', 26529, 15140, 47.203800, -122.544700),
('98498', 26516, 28256, 47.160010, -122.559710),
('98499', 26516, 34207, 47.166620, -122.506240),
('985', 22157, 32265, 18.406280, -65.947670),
('98501', 26621, 46796, 46.978300, -122.869890),
('98502', 26621, 35551, 47.084660, -123.029580),
('98503', 26619, 42263, 47.025280, -122.799000),
('98505', 26621, 403, 47.073210, -122.973580),
('98506', 26621, 18968, 47.102860, -122.873070),
('98512', 26621, 30784, 46.953260, -123.042590),
('98513', 26621, 36988, 46.990740, -122.732980),
('98516', 26621, 27212, 47.096470, -122.782650),
('98520', 26319, 24989, 46.994780, -123.810540),
('98524', 26455, 4226, 47.367030, -122.845480),
('98526', 26320, 175, 47.477490, -123.992270),
('98527', 26483, 244, 46.589170, -123.909390),
('98528', 26456, 12393, 47.446050, -122.896180),
('98530', 26618, 558, 46.805190, -122.868040),
('98531', 26422, 26931, 46.736460, -122.913640),
('98532', 26423, 26624, 46.636280, -123.034440),
('98533', 26424, 630, 46.673040, -122.431150),
('98535', 26321, 322, 47.099400, -124.119730),
('98536', 26322, 0, 47.189390, -124.111000),
('98537', 26323, 3008, 46.817190, -123.597680),
('98538', 26425, 397, 46.474220, -123.158840),
('98539', 26426, 159, 46.637720, -123.273150),
('98541', 26324, 10004, 47.068770, -123.404590),
('98542', 26427, 708, 46.529300, -122.731550),
('98544', 26428, 7, 46.739120, -123.027120),
('98546', 26457, 2965, 47.324390, -122.923620),
('98547', 26485, 1240, 46.786220, -124.019560),
('98548', 26458, 2593, 47.470640, -123.292730),
('98550', 26325, 12254, 47.140810, -123.901220),
('98552', 26326, 248, 47.313600, -123.944400),
('98555', 26459, 238, 47.546340, -123.063690),
('98556', 26620, 448, 46.885650, -123.140900),
('98557', 26328, 4144, 47.043320, -123.268100),
('98558', 26519, 60, 46.935790, -122.559980),
('98559', 26327, 0, 46.958840, -123.327490),
('98560', 26460, 76, 47.305770, -123.439480),
('98562', 26329, 78, 47.238770, -124.203360),
('98563', 26330, 7611, 47.206400, -123.608240),
('98564', 26432, 3106, 46.456660, -122.436270),
('98565', 26433, 432, 46.578380, -122.906930),
('98566', 26331, 282, 47.396160, -123.959760),
('98568', 26332, 2643, 46.864670, -123.302350),
('98569', 26333, 6945, 47.002060, -124.154790),
('98570', 26434, 4417, 46.635560, -122.635340),
('98571', 26334, 76, 47.203560, -124.195320),
('98572', 26436, 778, 46.552560, -123.324290),
('98575', 26335, 134, 47.436070, -123.798480),
('98576', 26622, 5099, 46.844170, -122.646870),
('98577', 26492, 7371, 46.641800, -123.600310),
('98579', 26623, 14259, 46.794060, -123.119520),
('98580', 26523, 11455, 46.991800, -122.501010),
('98581', 26277, 425, 46.358750, -123.068650),
('98582', 26438, 236, 46.516860, -122.626930),
('98583', 26336, 144, 47.001220, -123.487500),
('98584', 26461, 38615, 47.246080, -123.162090),
('98585', 26439, 580, 46.554360, -122.502200),
('98586', 26494, 1924, 46.559090, -123.839100),
('98587', 26337, 959, 47.320390, -124.156200),
('98588', 26462, 1564, 47.435550, -123.022610),
('98589', 26624, 7448, 46.841330, -122.820870),
('98590', 26495, 396, 46.718820, -124.002720),
('98591', 26440, 3667, 46.442240, -122.746710),
('98592', 26463, 1848, 47.328950, -123.079070),
('98593', 26441, 1449, 46.407670, -123.008070),
('98595', 26338, 2814, 46.883020, -124.108800),
('98596', 26442, 7483, 46.495560, -122.953640),
('98597', 26625, 25982, 46.852410, -122.492120),
('98601', 26260, 2952, 45.934390, -122.438570),
('98602', 26408, 124, 45.869300, -121.279660),
('98603', 26271, 1192, 46.042230, -122.420010),
('98604', 26261, 37212, 45.800130, -122.505400),
('98605', 26553, 1373, 45.778460, -121.639300),
('98606', 26262, 9528, 45.729210, -122.456150),
('98607', 26263, 34877, 45.643950, -122.382420),
('98609', 26272, 0, 46.071700, -122.865690),
('98610', 26554, 2846, 45.777650, -122.014010),
('98611', 26273, 9341, 46.306420, -122.904790),
('98612', 26626, 3283, 46.234620, -123.311940),
('98613', 26410, 602, 45.754200, -120.972350),
('98614', 26484, 532, 46.294590, -123.903400),
('98616', 26555, 79, 46.062270, -122.145990),
('98617', 26411, 1039, 45.642830, -121.142290),
('98619', 26412, 659, 45.976930, -121.265680),
('98620', 26413, 7584, 45.870960, -120.778460),
('98621', 26486, 257, 46.400600, -123.544280),
('98623', 26414, 36, 45.799560, -121.493470),
('98624', 26487, 1706, 46.357800, -123.940940),
('98625', 26274, 6827, 46.108710, -122.560930),
('98626', 26275, 27000, 46.153170, -122.785640),
('98628', 26415, 393, 45.850150, -121.098870),
('98629', 26264, 9783, 45.881090, -122.614800),
('98631', 26488, 3387, 46.379880, -124.022410),
('98632', 26276, 50837, 46.212230, -123.068550),
('98635', 26416, 1975, 45.743640, -121.209150),
('98638', 26489, 1561, 46.404700, -123.735880),
('98639', 26556, 1146, 45.643640, -121.962880),
('98640', 26490, 4944, 46.542900, -124.049380),
('98641', 26491, 55, 46.564840, -124.039320),
('98642', 26265, 25005, 45.802620, -122.701900),
('98643', 26627, 482, 46.303260, -123.621170),
('98644', 26493, 657, 46.328610, -124.040090),
('98645', 26278, 2044, 46.325090, -122.779930),
('98647', 26628, 272, 46.321370, -123.435400),
('98648', 26557, 3488, 45.705630, -121.948900),
('98649', 26279, 849, 46.315040, -122.534150),
('98650', 26418, 1216, 45.971170, -121.527320),
('98651', 26558, 944, 45.734190, -121.587180),
('98660', 26266, 13146, 45.686600, -122.731520),
('98661', 26266, 49910, 45.639350, -122.625860),
('98662', 26266, 37064, 45.689110, -122.577420),
('98663', 26266, 15365, 45.654490, -122.662280),
('98664', 26266, 23395, 45.619660, -122.577380),
('98665', 26266, 27947, 45.681550, -122.654170),
('98670', 26419, 61, 45.863720, -121.145990),
('98671', 26267, 23871, 45.611430, -122.249550),
('98672', 26420, 6997, 45.812690, -121.473930),
('98673', 26421, 502, 45.673670, -120.981290),
('98674', 26280, 15679, 45.946720, -122.655680),
('98675', 26268, 7198, 45.863490, -122.331040),
('98682', 26266, 66821, 45.672960, -122.483270),
('98683', 26266, 31504, 45.602700, -122.509840),
('98684', 26266, 36931, 45.630800, -122.516150),
('98685', 26266, 30534, 45.715960, -122.691050),
('98686', 26266, 20518, 45.723900, -122.623050),
('987', 22157, 54109, 18.341150, -65.942570),
('98801', 26252, 44801, 47.431830, -120.343560),
('98802', 26283, 31801, 47.493080, -120.164930),
('98811', 26240, 120, 47.734250, -120.373790),
('98812', 26464, 5422, 48.131190, -119.806870),
('98813', 26281, 3191, 48.011070, -119.610630),
('98814', 26465, 688, 48.210010, -120.228840),
('98815', 26241, 7562, 47.528930, -120.484590),
('98816', 26242, 6901, 48.022900, -120.343610),
('98817', 26243, 143, 47.790490, -119.995880),
('98819', 26466, 205, 48.597970, -119.823270),
('98821', 26244, 646, 47.551990, -120.561550),
('98822', 26245, 1983, 47.865090, -120.476940),
('98823', 26307, 12638, 47.338530, -119.635360),
('98824', 26308, 231, 47.068570, -119.866530),
('98826', 26246, 7689, 47.787720, -120.854540),
('98827', 26469, 479, 48.863590, -119.767260),
('98828', 26247, 2075, 47.307410, -120.183300),
('98829', 26470, 638, 48.311030, -119.808220),
('98830', 26285, 562, 47.887020, -119.522780),
('98831', 26248, 3814, 47.934510, -120.129980),
('98832', 26310, 153, 47.346690, -119.020330),
('98833', 26471, 153, 48.771990, -120.494470),
('98834', 26472, 245, 48.117120, -120.089350),
('98836', 26249, 883, 47.476150, -120.429090),
('98837', 26312, 46959, 47.148090, -119.316300),
('98840', 26474, 4775, 48.273950, -119.518380),
('98841', 26475, 9218, 48.376020, -119.298170),
('98843', 26286, 2243, 47.736880, -120.086180),
('98844', 26476, 4348, 48.916180, -119.247670),
('98845', 26287, 199, 47.430390, -119.909230),
('98846', 26477, 1381, 48.034810, -119.975280),
('98847', 26250, 2481, 47.422360, -120.621520),
('98848', 26313, 12959, 47.171820, -119.841090),
('98849', 26478, 1098, 48.548210, -119.407890),
('98850', 26288, 1749, 47.400480, -120.034590),
('98851', 26315, 5196, 47.420020, -119.434620),
('98852', 26251, 32, 48.321690, -120.638810),
('98853', 26316, 0, 47.446550, -119.280610),
('98855', 26479, 5806, 48.676410, -119.256340),
('98856', 26480, 2497, 48.370650, -120.227620),
('98857', 26317, 3545, 46.986560, -119.036980),
('98858', 26289, 1850, 47.679380, -119.879740),
('98859', 26481, 353, 48.811810, -118.908710),
('98860', 26318, 229, 47.468990, -119.123910),
('98862', 26482, 3075, 48.584910, -120.227920),
('98901', 26686, 33106, 46.669350, -120.338160),
('98902', 26686, 45929, 46.597780, -120.533930),
('98903', 26686, 17590, 46.548070, -120.902260),
('98908', 26686, 38671, 46.623450, -120.705820),
('98921', 26671, 0, 46.430820, -120.317190),
('98922', 26398, 7577, 47.250560, -120.882100),
('98923', 26672, 990, 46.666080, -120.717230),
('98925', 26399, 533, 47.287930, -121.280890),
('98926', 26400, 32327, 46.990540, -120.349020),
('98930', 26673, 15089, 46.269030, -119.895300),
('98932', 26674, 4868, 46.332170, -120.160910),
('98933', 26675, 1195, 46.402900, -120.637560),
('98934', 26401, 1033, 46.980670, -120.419410),
('98935', 26676, 4378, 46.134170, -120.068770),
('98936', 26677, 7787, 46.535970, -120.153910),
('98937', 26678, 4598, 46.775230, -121.178080),
('98938', 26679, 1946, 46.388420, -120.096620),
('98939', 26680, 90, 46.501050, -120.470770),
('98940', 26402, 409, 47.396820, -121.066830),
('98941', 26403, 827, 47.224640, -121.000210),
('98942', 26681, 18047, 46.803220, -120.674540),
('98943', 26405, 715, 47.184610, -120.960890),
('98944', 26238, 25176, 46.499980, -119.665330),
('98946', 26406, 363, 47.065150, -120.765120),
('98947', 26682, 2786, 46.687590, -120.809160),
('98948', 26683, 13015, 46.230670, -120.371680),
('98950', 26407, 54, 46.846420, -119.987700),
('98951', 26684, 13145, 46.460460, -120.515510),
('98952', 26685, 1724, 46.349910, -120.815610),
('98953', 26687, 7043, 46.441490, -120.232840),
('99001', 26576, 8684, 47.638740, -117.585820),
('99003', 26577, 4413, 47.919970, -117.276080),
('99004', 26578, 22210, 47.408690, -117.635750),
('99005', 26579, 10457, 47.844050, -117.363460),
('99006', 26580, 13888, 47.952080, -117.510160),
('99008', 26446, 439, 47.504490, -117.935330),
('99009', 26581, 4868, 48.025300, -117.249930),
('99011', 26582, 3184, 47.618670, -117.648390),
('99012', 26583, 1111, 47.381370, -117.191450),
('99013', 26606, 1507, 47.884980, -117.834950),
('99014', 26584, 0, 47.561110, -117.596660),
('99016', 26585, 19620, 47.621700, -117.146230),
('99017', 26660, 226, 47.182900, -117.876110),
('99018', 26586, 264, 47.291700, -117.152120),
('99019', 26587, 12245, 47.642220, -117.076880),
('99020', 26588, 15, 47.563140, -117.497020),
('99021', 26589, 10058, 47.849510, -117.187210),
('99022', 26590, 9012, 47.600840, -117.708690),
('99023', 26591, 964, 47.564740, -117.144660),
('99025', 26592, 5668, 47.789630, -117.087510),
('99026', 26593, 8828, 47.803750, -117.625000),
('99027', 26594, 5973, 47.711070, -117.127950),
('99029', 26452, 1747, 47.706390, -117.824060),
('99030', 26595, 592, 47.477820, -117.113020),
('99031', 26596, 1110, 47.419730, -117.359910),
('99032', 26453, 982, 47.324050, -118.046130),
('99033', 26668, 790, 47.230610, -117.097820),
('99034', 26615, 215, 47.886200, -117.762450),
('99036', 26598, 1546, 47.520050, -117.271970),
('99037', 26599, 15464, 47.637340, -117.197560),
('99039', 26600, 171, 47.338080, -117.231310),
('99040', 26617, 643, 47.903550, -117.998850),
('99101', 26601, 1635, 48.318890, -117.948300),
('99102', 26651, 509, 46.792180, -117.250290),
('99103', 26443, 603, 47.730410, -118.931710),
('99105', 26224, 31, 46.921300, -118.082640),
('99109', 26602, 4894, 48.297870, -117.698520),
('99110', 26603, 1465, 48.008300, -117.581120),
('99111', 26652, 4012, 46.862810, -117.441320),
('99113', 26653, 555, 46.586280, -117.193500),
('99114', 26604, 12948, 48.660670, -117.743330),
('99115', 26282, 1224, 47.673260, -119.389650),
('99116', 26467, 1538, 48.014290, -118.930630),
('99117', 26444, 568, 47.728180, -118.501080),
('99118', 26290, 997, 48.897460, -118.637970),
('99119', 26496, 1514, 48.509460, -117.299940),
('99121', 26291, 332, 48.943820, -118.455680),
('99122', 26445, 4037, 47.676150, -118.217740),
('99123', 26306, 852, 47.897380, -119.040170),
('99124', 26468, 270, 48.002840, -118.952430),
('99125', 26654, 626, 46.952230, -117.785560),
('99126', 26605, 952, 48.735740, -117.974470),
('99128', 26655, 289, 47.100450, -117.085230),
('99129', 26607, 690, 48.002810, -118.183420),
('99130', 26656, 833, 46.999170, -117.185560),
('99131', 26608, 122, 48.295110, -118.117310),
('99133', 26284, 1377, 48.006700, -119.106130),
('99134', 26447, 572, 47.437930, -118.323470),
('99135', 26309, 452, 47.656580, -119.096080),
('99136', 26657, 17, 46.674700, -117.948890),
('99137', 26609, 399, 48.165900, -118.099920),
('99138', 26292, 1103, 48.230930, -118.388760),
('99139', 26497, 800, 48.731610, -117.313710),
('99140', 26293, 568, 48.135000, -118.687220),
('99141', 26294, 6160, 48.725710, -118.175090),
('99143', 26659, 691, 46.746270, -117.858690),
('99144', 26448, 19, 47.368100, -118.490410),
('99146', 26295, 59, 48.957660, -118.297680),
('99147', 26449, 152, 47.836040, -118.436750),
('99148', 26610, 2358, 48.108740, -117.575140),
('99149', 26661, 194, 47.225000, -117.467940),
('99150', 26296, 281, 48.806220, -118.610710),
('99151', 26611, 182, 48.664430, -118.061250),
('99152', 26498, 144, 48.850660, -117.397480),
('99153', 26499, 432, 48.909510, -117.252290),
('99154', 26450, 38, 47.391320, -118.355760),
('99155', 26473, 977, 48.277370, -118.961800),
('99156', 26500, 9132, 48.162110, -117.188260),
('99157', 26612, 655, 48.930070, -117.817530),
('99158', 26662, 619, 47.133050, -117.240080),
('99159', 26451, 1186, 47.328720, -118.743380),
('99160', 26297, 47, 48.868950, -118.301220),
('99161', 26663, 1366, 46.894960, -117.131690),
('99163', 26664, 33829, 46.727980, -117.216540),
('99166', 26298, 2936, 48.610330, -118.671500),
('99167', 26613, 720, 48.413070, -118.117330),
('99169', 26227, 2494, 47.118750, -118.374240),
('99170', 26665, 955, 47.251320, -117.402030),
('99171', 26666, 969, 47.104850, -117.649500),
('99173', 26614, 1898, 48.037020, -117.857080),
('99174', 26667, 32, 47.007190, -117.356820),
('99176', 26669, 136, 47.092210, -117.412240),
('99179', 26670, 568, 46.492390, -117.107620),
('99180', 26501, 741, 48.309250, -117.306630),
('99181', 26616, 1928, 48.145600, -117.765260),
('99185', 26454, 1385, 47.740140, -118.716970),
('99201', 26597, 14246, 47.662710, -117.436090),
('99202', 26597, 20829, 47.657090, -117.378540),
('99203', 26597, 21984, 47.629450, -117.402910),
('99204', 26597, 7189, 47.647260, -117.426650),
('99205', 26597, 44216, 47.696570, -117.446090),
('99206', 26597, 42850, 47.627550, -117.254480),
('99207', 26597, 32219, 47.689410, -117.389110),
('99208', 26597, 58172, 47.780710, -117.461350),
('99212', 26597, 21013, 47.665040, -117.309140),
('99216', 26597, 27302, 47.681420, -117.208260),
('99217', 26597, 19533, 47.740600, -117.262410),
('99218', 26597, 16305, 47.758940, -117.408700),
('99223', 26597, 34868, 47.588760, -117.334000),
('99224', 26597, 24455, 47.647290, -117.535520),
('99251', 26597, 1056, 47.753850, -117.417970),
('99258', 26597, 502, 47.666120, -117.402460),
('99301', 26303, 85210, 46.391840, -118.935090),
('99320', 26232, 10023, 46.327060, -119.524830),
('99321', 26305, 851, 46.865760, -119.889250),
('99322', 26409, 406, 45.931760, -120.140830),
('99323', 26629, 4219, 46.186770, -118.850610),
('99324', 26630, 10076, 46.043760, -118.385420),
('99326', 26299, 5900, 46.667050, -118.837690),
('99328', 26269, 3669, 46.269370, -117.879560),
('99329', 26631, 156, 46.139430, -118.147320),
('99330', 26300, 876, 46.494470, -119.030210),
('99333', 26658, 91, 46.681120, -118.152620),
('99335', 26301, 171, 46.655440, -118.476860),
('99336', 26233, 51329, 46.213020, -119.179540),
('99337', 26233, 32581, 46.062350, -119.091270),
('99338', 26233, 18312, 46.173620, -119.274030),
('99341', 26225, 736, 46.906630, -118.642240),
('99343', 26302, 3522, 46.591880, -119.170650),
('99344', 26226, 19630, 46.822230, -119.172210),
('99345', 26234, 164, 45.936230, -119.659190),
('99346', 26235, 372, 46.026850, -119.306000),
('99347', 26304, 2429, 46.425310, -117.571280),
('99348', 26632, 1590, 46.386810, -118.447310),
('99349', 26311, 7531, 46.730780, -119.699600),
('99350', 26236, 14287, 46.144770, -119.709440),
('99352', 26237, 35618, 46.241990, -119.290670),
('99353', 26239, 18264, 46.317470, -119.379420),
('99354', 26237, 25676, 46.331530, -119.301060),
('99356', 26417, 331, 45.834590, -120.362580),
('99357', 26314, 3973, 46.892950, -119.679020),
('99359', 26270, 100, 46.533250, -118.156970),
('99360', 26633, 1400, 46.090440, -118.667450),
('99361', 26634, 1668, 46.236910, -118.143330),
('99362', 26635, 43028, 46.087270, -118.312690),
('99363', 26636, 96, 46.048210, -118.895750),
('99371', 26228, 309, 46.791440, -118.306140),
('99401', 26229, 383, 46.090410, -117.273360),
('99402', 26230, 1594, 46.186800, -117.149220),
('99403', 26231, 20425, 46.381140, -117.259740),
('99501', 548, 16500, 61.220050, -149.858720),
('99502', 548, 26257, 61.163230, -149.986440),
('99503', 556, 12620, 61.907440, -156.852030),
('99504', 548, 40938, 61.191950, -149.642550),
('99505', 553, 5703, 61.275120, -149.651970),
('99506', 553, 6991, 61.265050, -149.800670),
('99507', 548, 35708, 61.133360, -149.690010),
('99508', 548, 38142, 61.201450, -149.814600),
('99513', 548, 0, 61.214770, -149.885660),
('99515', 548, 21629, 61.117330, -149.888940),
('99516', 548, 21788, 61.072600, -149.718120),
('99517', 548, 16347, 61.190180, -149.936760),
('99518', 548, 10351, 61.159490, -149.884790),
('99519', 691, 1910, 70.100600, -150.000140),
('99530', 548, 0, 61.184650, -149.983560),
('99540', 552, 322, 61.014640, -149.368590),
('99546', 541, 248, 51.881450, -176.629620),
('99547', 542, 28, 52.228880, -174.206130),
('99548', 655, 30, 56.254680, -158.760040),
('99549', 665, 63, 56.942530, -158.604740),
('99550', 639, 124, 57.875800, -152.873700),
('99551', 554, 415, 60.921010, -161.402120),
('99552', 555, 298, 60.906140, -161.212230),
('99553', 536, 911, 54.147500, -165.836870),
('99554', 640, 1138, 62.690180, -164.630540),
('99555', 595, 121, 59.288590, -158.679960);
INSERT INTO `zip` (`zip`, `city_id`, `population`, `lat`, `lng`) VALUES
('99556', 618, 2759, 59.829550, -151.642980),
('99557', 557, 715, 61.441420, -155.902170),
('99558', 735, 74, 62.654110, -160.213960),
('99559', 558, 7465, 60.764870, -161.906710),
('99561', 559, 476, 60.155040, -164.254950),
('99563', 641, 432, 61.550090, -165.358130),
('99564', 653, 54, 56.300320, -158.413150),
('99565', 654, 39, 56.304150, -158.500390),
('99566', 587, 73, 61.281760, -142.793380),
('99567', 549, 7382, 61.266250, -148.869330),
('99568', 619, 487, 60.249520, -150.385010),
('99569', 596, 31, 58.817140, -158.529140),
('99571', 537, 237, 55.296610, -162.586340),
('99572', 620, 234, 60.493480, -150.056700),
('99573', 588, 843, 61.600360, -145.924460),
('99574', 583, 2616, 60.739270, -146.406100),
('99575', 560, 28, 61.843910, -158.108250),
('99576', 597, 2577, 59.773390, -158.693090),
('99577', 550, 28124, 61.182400, -149.292290),
('99578', 561, 475, 60.216440, -162.033110),
('99579', 656, 46, 58.218130, -157.403640),
('99580', 598, 51, 59.346190, -157.486070),
('99581', 642, 1293, 62.824760, -164.686920),
('99583', 538, 103, 54.843050, -163.399450),
('99585', 645, 215, 61.875320, -162.048730),
('99586', 589, 379, 62.674630, -144.138840),
('99587', 551, 1889, 60.910300, -148.844660),
('99588', 590, 1167, 62.421920, -146.481300),
('99589', 562, 118, 59.211860, -161.701230),
('99590', 745, 210, 62.899780, -160.107820),
('99591', 545, 57, 56.580750, -169.615990),
('99602', 746, 277, 62.186800, -159.819800),
('99603', 621, 11234, 59.523640, -151.228550),
('99604', 643, 801, 61.526130, -166.114580),
('99605', 622, 147, 60.832860, -149.447970),
('99606', 657, 235, 59.668030, -154.833620),
('99607', 563, 253, 61.541600, -160.333700),
('99608', 634, 27, 57.584540, -154.325450),
('99609', 564, 389, 60.878480, -162.527250),
('99610', 623, 1895, 60.291720, -151.271670),
('99611', 624, 15188, 60.747770, -150.890000),
('99612', 539, 1108, 55.085870, -162.297800),
('99613', 658, 452, 59.134960, -155.426960),
('99614', 565, 572, 59.937300, -164.061580),
('99615', 635, 12618, 57.577050, -153.391190),
('99620', 644, 1272, 63.030470, -163.553000),
('99621', 566, 561, 60.797810, -161.414690),
('99622', 567, 589, 59.876670, -163.171540),
('99623', 674, 22466, 61.429190, -149.912260),
('99624', 636, 46, 57.448660, -153.858110),
('99625', 659, 28, 59.068300, -156.900930),
('99626', 568, 261, 61.516330, -160.355640),
('99627', 753, 226, 63.186570, -154.756090),
('99628', 599, 629, 58.903300, -158.908670),
('99630', 569, 315, 60.370410, -166.267200),
('99631', 625, 216, 60.606730, -149.580710),
('99632', 646, 884, 62.112320, -163.664550),
('99633', 581, 418, 58.782970, -156.898400),
('99634', 570, 843, 60.686820, -162.007370),
('99635', 626, 114, 60.806200, -152.677340),
('99636', 600, 603, 59.476180, -157.270990),
('99637', 577, 914, 60.533300, -165.155700),
('99638', 544, 12, 53.013290, -168.753590),
('99639', 627, 1234, 59.996020, -151.361770),
('99640', 660, 68, 60.298130, -155.405180),
('99641', 572, 827, 60.877220, -162.461520),
('99643', 637, 155, 57.216690, -153.326580),
('99644', 638, 95, 57.925120, -152.423100),
('99645', 669, 30849, 61.607630, -148.903940),
('99647', 661, 13, 59.864110, -154.015110),
('99648', 662, 85, 55.931370, -159.155980),
('99649', 663, 72, 57.515010, -157.310760),
('99650', 648, 380, 61.942550, -162.884670),
('99651', 573, 23, 58.978030, -161.718530),
('99652', 666, 4028, 61.526210, -149.961600),
('99653', 664, 158, 60.168840, -154.323280),
('99654', 674, 43606, 61.607000, -149.414430),
('99655', 574, 1079, 59.749030, -161.894370),
('99656', 575, 12, 61.863090, -157.417590),
('99657', 649, 95, 61.789160, -161.426980),
('99658', 650, 1231, 62.076100, -163.281110),
('99659', 681, 308, 63.473800, -162.122950),
('99660', 546, 349, 57.179930, -170.279140),
('99661', 540, 1048, 55.271310, -160.674310),
('99662', 651, 506, 61.841970, -165.583290),
('99663', 628, 401, 59.394880, -151.627290),
('99664', 629, 4197, 60.137140, -149.471230),
('99665', 760, 65, 62.668430, -159.562980),
('99666', 647, 59, 62.454980, -165.094920),
('99667', 670, 119, 61.854470, -151.820560),
('99668', 576, 73, 61.651580, -157.125080),
('99669', 630, 17382, 60.414970, -151.002070),
('99670', 582, 53, 58.665410, -156.988310),
('99671', 685, 654, 63.470480, -162.259930),
('99672', 631, 3473, 60.550260, -150.779070),
('99674', 671, 1342, 61.691660, -147.819970),
('99675', 762, 58, 62.982680, -156.083830),
('99676', 672, 1748, 62.497920, -149.658480),
('99677', 584, 40, 60.892170, -146.672490),
('99678', 601, 842, 59.207380, -160.526220),
('99679', 578, 456, 61.105090, -160.948650),
('99680', 579, 820, 60.344470, -162.663670),
('99681', 580, 450, 60.579020, -165.207670),
('99682', 632, 274, 61.171450, -151.167970),
('99683', 673, 382, 62.451650, -150.425000),
('99684', 687, 752, 64.099380, -160.327760),
('99685', 547, 3576, 53.878690, -166.471250),
('99686', 585, 3953, 61.048860, -146.190380),
('99688', 675, 2782, 61.894120, -150.047490),
('99689', 733, 564, 59.518190, -139.486900),
('99690', 571, 70, 60.487380, -164.819530),
('99691', 756, 91, 62.743850, -153.842930),
('99692', 543, 766, 53.883930, -166.544980),
('99693', 586, 391, 60.837380, -148.150240),
('99694', 668, 1339, 61.618540, -149.825500),
('99695', 652, 0, 55.918280, -159.493350),
('99701', 742, 18295, 67.254350, -149.877540),
('99702', 602, 3149, 64.648350, -147.038790),
('99703', 605, 8807, 64.835420, -147.626120),
('99704', 592, 49, 64.290230, -149.204230),
('99705', 606, 22872, 64.773560, -147.270550),
('99706', 727, 26, 64.028100, -144.633100),
('99707', 604, 0, 65.155100, -146.252380),
('99709', 604, 28343, 64.874020, -148.224580),
('99712', 604, 12683, 64.983110, -146.139460),
('99714', 607, 974, 64.436800, -146.696890),
('99720', 734, 256, 66.563950, -152.763950),
('99721', 690, 222, 68.149990, -151.716160),
('99722', 736, 199, 68.142080, -145.495570),
('99723', 693, 4879, 71.274340, -156.753940),
('99724', 737, 87, 66.322180, -146.966360),
('99725', 603, 562, 64.861200, -148.023870),
('99726', 738, 27, 66.736150, -151.477570),
('99727', 701, 644, 65.976540, -161.139180),
('99729', 667, 117, 63.226860, -148.101220),
('99730', 739, 108, 65.678070, -145.540550),
('99732', 724, 8, 64.079450, -141.970390),
('99733', 741, 45, 65.792840, -144.182820),
('99734', 698, 1423, 70.362010, -149.002100),
('99736', 702, 189, 66.072220, -162.743490),
('99737', 725, 4547, 63.627170, -145.075390),
('99738', 726, 174, 65.149530, -142.433070),
('99739', 677, 293, 64.976260, -162.839700),
('99740', 743, 476, 67.707590, -143.951320),
('99741', 744, 627, 64.738080, -156.863510),
('99742', 678, 426, 63.753750, -171.688110),
('99743', 594, 812, 63.909550, -149.917360),
('99744', 591, 124, 64.313610, -149.132170),
('99745', 747, 34, 66.047200, -154.240960),
('99746', 748, 182, 65.700130, -156.338560),
('99747', 694, 201, 70.118820, -143.670290),
('99748', 749, 197, 64.322290, -158.743560),
('99749', 703, 424, 66.978600, -160.431780),
('99750', 704, 769, 67.732990, -164.521220),
('99751', 705, 133, 66.931030, -156.893860),
('99752', 706, 3255, 67.293160, -161.917440),
('99753', 679, 300, 64.941120, -161.145360),
('99754', 750, 74, 64.900800, -157.694620),
('99755', 593, 893, 63.688490, -148.887420),
('99756', 752, 17, 64.936450, -150.666540),
('99757', 751, 14, 63.832080, -152.494810),
('99758', 754, 113, 65.151750, -149.372400),
('99759', 697, 172, 69.737230, -162.837410),
('99760', 755, 761, 64.370350, -149.175130),
('99761', 707, 536, 67.600400, -163.034590),
('99762', 680, 4150, 64.850780, -164.802610),
('99763', 708, 654, 66.828010, -161.037350),
('99764', 728, 430, 62.766640, -141.674470),
('99765', 757, 249, 64.730660, -158.131080),
('99766', 696, 649, 68.291040, -166.042570),
('99767', 758, 41, 65.496640, -150.143930),
('99768', 759, 194, 65.386350, -153.538260),
('99769', 682, 823, 63.679650, -170.483090),
('99770', 709, 557, 66.607080, -160.071360),
('99771', 683, 312, 64.357640, -161.198900),
('99772', 684, 568, 65.948110, -165.801220),
('99773', 710, 244, 66.880530, -157.149930),
('99774', 761, 9, 66.023200, -149.079820),
('99775', 604, 903, 64.857440, -147.834830),
('99776', 729, 136, 63.352320, -143.431810),
('99777', 763, 214, 65.183920, -152.066730),
('99778', 686, 279, 65.253090, -166.342000),
('99780', 730, 1719, 63.462950, -142.170100),
('99781', 764, 109, 67.320730, -145.988350),
('99782', 699, 621, 70.638040, -159.971210),
('99783', 688, 294, 65.611910, -168.077320),
('99784', 689, 194, 64.682000, -163.406700),
('99785', 676, 625, 65.341510, -166.494200),
('99786', 700, 277, 67.089710, -157.872530),
('99788', 740, 95, 66.646290, -143.781370),
('99789', 695, 564, 70.213480, -150.989660),
('99790', 742, 13, 65.426420, -148.187380),
('99791', 692, 119, 70.481010, -157.383500),
('99801', 617, 29933, 58.397850, -134.054720),
('99820', 610, 419, 57.435520, -134.289260),
('99824', 616, 2169, 58.272340, -134.400820),
('99825', 611, 16, 58.128640, -136.195070),
('99826', 612, 710, 58.398160, -135.834560),
('99827', 608, 2146, 59.026590, -135.884830),
('99829', 613, 896, 58.035020, -135.338560),
('99830', 716, 473, 56.783050, -134.166880),
('99832', 614, 85, 57.966110, -136.082650),
('99833', 711, 3374, 56.829520, -133.179860),
('99835', 722, 8457, 57.238910, -135.263300),
('99836', 720, 39, 56.235580, -134.653330),
('99840', 723, 1303, 59.562970, -135.336260),
('99841', 615, 136, 58.008660, -135.573970),
('99850', 609, 0, 58.488210, -135.484320),
('99901', 633, 13913, 55.622700, -131.671570),
('99903', 731, 1, 55.734140, -132.106690),
('99918', 712, 241, 55.946050, -132.742330),
('99919', 721, 564, 55.649830, -132.503370),
('99921', 713, 1727, 55.519890, -132.816560),
('99922', 714, 328, 55.302180, -133.032640),
('99923', 715, 25, 55.980430, -130.038030),
('99925', 717, 920, 55.553980, -132.962760),
('99926', 718, 1465, 55.126170, -131.489280),
('99927', 719, 14, 56.333050, -133.600440),
('99929', 732, 2133, 56.360890, -132.006350);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `admins1`
--
ALTER TABLE `admins1`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `city`
--
ALTER TABLE `city`
  ADD PRIMARY KEY (`id`),
  ADD KEY `county_id` (`county_id`);

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

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

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

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

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

--
-- Indexes for table `county`
--
ALTER TABLE `county`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_id` (`state_id`);

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

--
-- Indexes for table `currency_countries`
--
ALTER TABLE `currency_countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

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

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

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `state`
--
ALTER TABLE `state`
  ADD PRIMARY KEY (`state_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `additional_information`
--
ALTER TABLE `additional_information`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `admins1`
--
ALTER TABLE `admins1`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `aminities`
--
ALTER TABLE `aminities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `appointment_schedules`
--
ALTER TABLE `appointment_schedules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_payments`
--
ALTER TABLE `bank_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banner_images`
--
ALTER TABLE `banner_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `breadcrumb_images`
--
ALTER TABLE `breadcrumb_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cinet_pays`
--
ALTER TABLE `cinet_pays`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `compares`
--
ALTER TABLE `compares`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contact_pages`
--
ALTER TABLE `contact_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `counters`
--
ALTER TABLE `counters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- AUTO_INCREMENT for table `currency_countries`
--
ALTER TABLE `currency_countries`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250;

--
-- AUTO_INCREMENT for table `custom_pages`
--
ALTER TABLE `custom_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_paginations`
--
ALTER TABLE `custom_paginations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `email_configurations`
--
ALTER TABLE `email_configurations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `error_pages`
--
ALTER TABLE `error_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `facebook_comments`
--
ALTER TABLE `facebook_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flutterwaves`
--
ALTER TABLE `flutterwaves`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `footer_links`
--
ALTER TABLE `footer_links`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `footer_social_links`
--
ALTER TABLE `footer_social_links`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `google_analytics`
--
ALTER TABLE `google_analytics`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `google_recaptchas`
--
ALTER TABLE `google_recaptchas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `how_it_works`
--
ALTER TABLE `how_it_works`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `instamojo_payments`
--
ALTER TABLE `instamojo_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kyc_information`
--
ALTER TABLE `kyc_information`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kyc_types`
--
ALTER TABLE `kyc_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_visibilities`
--
ALTER TABLE `menu_visibilities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `message_documents`
--
ALTER TABLE `message_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=271;

--
-- AUTO_INCREMENT for table `mobile_apps`
--
ALTER TABLE `mobile_apps`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mobile_sliders`
--
ALTER TABLE `mobile_sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nearest_locations`
--
ALTER TABLE `nearest_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `paypal_payments`
--
ALTER TABLE `paypal_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `paystack_and_mollies`
--
ALTER TABLE `paystack_and_mollies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `popular_posts`
--
ALTER TABLE `popular_posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `popular_tags`
--
ALTER TABLE `popular_tags`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_aminities`
--
ALTER TABLE `property_aminities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=569;

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

--
-- AUTO_INCREMENT for table `property_nearest_locations`
--
ALTER TABLE `property_nearest_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;

--
-- AUTO_INCREMENT for table `property_plans`
--
ALTER TABLE `property_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `property_sliders`
--
ALTER TABLE `property_sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=162;

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

--
-- AUTO_INCREMENT for table `purpose`
--
ALTER TABLE `purpose`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `pusher_credentails`
--
ALTER TABLE `pusher_credentails`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `received_wants`
--
ALTER TABLE `received_wants`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `schedules`
--
ALTER TABLE `schedules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `section_contents`
--
ALTER TABLE `section_contents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `section_controls`
--
ALTER TABLE `section_controls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `seo_settings`
--
ALTER TABLE `seo_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stripe_payments`
--
ALTER TABLE `stripe_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `terms_and_conditions`
--
ALTER TABLE `terms_and_conditions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `wants`
--
ALTER TABLE `wants`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `why_choose_us`
--
ALTER TABLE `why_choose_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wishlists`
--
ALTER TABLE `wishlists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `city`
--
ALTER TABLE `city`
  ADD CONSTRAINT `city_ibfk_1` FOREIGN KEY (`county_id`) REFERENCES `county` (`id`);

--
-- Constraints for table `county`
--
ALTER TABLE `county`
  ADD CONSTRAINT `county_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `state` (`state_id`);

--
-- Constraints for table `zip`
--
ALTER TABLE `zip`
  ADD CONSTRAINT `zip_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`);
COMMIT;

