
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Honolulu", "Honolulu", "Honolulu", NULL, 1, 0, 1, NULL, "21.304547", "-157.855676"),
("Hilo CDP", "Hilo CDP", "Hilo CDP", NULL, 1, 0, 1, NULL, "19.7073734", "-155.08158"),
("Chula Vista", "Chula Vista", "Chula Vista", NULL, 1, 0, 1, NULL, "32.6400541", "-117.0841955"),
("El Cajon", "El Cajon", "El Cajon", NULL, 1, 0, 1, NULL, "32.7947731", "-116.962526"),
("San Diego", "San Diego", "San Diego", NULL, 1, 0, 1, NULL, "32.7174202", "-117.1627728"),
("Laguna Beach", "Laguna Beach", "Laguna Beach", NULL, 1, 0, 1, NULL, "33.5426975", "-117.785366"),
("Poway", "Poway", "Poway", NULL, 1, 0, 1, NULL, "32.9628234", "-117.035864"),
("Huntington Beach", "Huntington Beach", "Huntington Beach", NULL, 1, 0, 1, NULL, "33.6783336", "-118.0000166"),
("San Clemente", "San Clemente", "San Clemente", NULL, 1, 0, 1, NULL, "33.4270275", "-117.6124179"),
("Santa Ana", "Santa Ana", "Santa Ana", NULL, 1, 0, 1, NULL, "33.7494951", "-117.8732213"),
("Costa Mesa", "Costa Mesa", "Costa Mesa", NULL, 1, 0, 1, NULL, "33.6633386", "-117.903317"),
("Irvine", "Irvine", "Irvine", NULL, 1, 0, 1, NULL, "33.6856969", "-117.8259819"),
("Mission Viejo", "Mission Viejo", "Mission Viejo", NULL, 1, 0, 1, NULL, "33.5965685", "-117.659405"),
("Carlsbad", "Carlsbad", "Carlsbad", NULL, 1, 0, 1, NULL, "33.1580933", "-117.3505966"),
("Oceanside", "Oceanside", "Oceanside", NULL, 1, 0, 1, NULL, "33.1958696", "-117.3794834"),
("Escondido", "Escondido", "Escondido", NULL, 1, 0, 1, NULL, "33.1216751", "-117.0814849"),
("Vista", "Vista", "Vista", NULL, 1, 0, 1, NULL, "33.2000368", "-117.2425355"),
("Temecula", "Temecula", "Temecula", NULL, 1, 0, 1, NULL, "33.4946353", "-117.1473661"),
("El Centro", "El Centro", "El Centro", NULL, 1, 0, 1, NULL, "32.792", "-115.563051"),
("Indio", "Indio", "Indio", NULL, 1, 0, 1, NULL, "33.7192808", "-116.2188054"),
("Indio", "Indio", "Indio", NULL, 1, 0, 1, NULL, "33.7192808", "-116.2188054"),
("Eureka", "Eureka", "Eureka", NULL, 1, 0, 1, NULL, "40.7906871", "-124.1673746"),
("Soledad", "Soledad", "Soledad", NULL, 1, 0, 1, NULL, "36.4281798", "-121.32466432032"),
("Santa Barbara", "Santa Barbara", "Santa Barbara", NULL, 1, 0, 1, NULL, "34.4221319", "-119.702667"),
("Santa Maria", "Santa Maria", "Santa Maria", NULL, 1, 0, 1, NULL, "34.9531295", "-120.435857"),
("Ventura", "Ventura", "Ventura", NULL, 1, 0, 1, NULL, "34.3435092", "-119.29560423164"),
("Oxnard", "Oxnard", "Oxnard", NULL, 1, 0, 1, NULL, "34.1976308", "-119.1803818"),
("Ventura", "Ventura", "Ventura", NULL, 1, 0, 1, NULL, "34.2783355", "-119.293174"),
("Thousand Oaks", "Thousand Oaks", "Thousand Oaks", NULL, 1, 0, 1, NULL, "34.1705609", "-118.8375937"),
("Santa Monica", "Santa Monica", "Santa Monica", NULL, 1, 0, 1, NULL, "34.0194704", "-118.491227"),
("Torrance", "Torrance", "Torrance", NULL, 1, 0, 1, NULL, "33.8358492", "-118.3406288"),
("Inglewood", "Inglewood", "Inglewood", NULL, 1, 0, 1, NULL, "33.9562003", "-118.353132"),
("South Gate", "South Gate", "South Gate", NULL, 1, 0, 1, NULL, "33.9463456", "-118.200981"),
("Downey", "Downey", "Downey", NULL, 1, 0, 1, NULL, "33.9404441", "-118.1292846"),
("East Los Angeles", "East Los Angeles", "East Los Angeles", NULL, 1, 0, 1, NULL, "34.0239015", "-118.172015"),
("Los Angeles", "Los Angeles", "Los Angeles", NULL, 1, 0, 1, NULL, "34.0536909", "-118.242766"),
("Simi Valley", "Simi Valley", "Simi Valley", NULL, 1, 0, 1, NULL, "34.2677404", "-118.7538071"),
("Santa Clarita", "Santa Clarita", "Santa Clarita", NULL, 1, 0, 1, NULL, "34.4127963", "-118.5538088"),
("Burbank", "Burbank", "Burbank", NULL, 1, 0, 1, NULL, "34.1812089", "-118.307201"),
("Glendale", "Glendale", "Glendale", NULL, 1, 0, 1, NULL, "34.1469416", "-118.2478471"),
("Pasadena", "Pasadena", "Pasadena", NULL, 1, 0, 1, NULL, "34.1476452", "-118.1444779"),
("Lancaster", "Lancaster", "Lancaster", NULL, 1, 0, 1, NULL, "34.6981064", "-118.1366153"),
("San Luis Obispo", "San Luis Obispo", "San Luis Obispo", NULL, 1, 0, 1, NULL, "35.2827525", "-120.659615"),
("Bakersfield", "Bakersfield", "Bakersfield", NULL, 1, 0, 1, NULL, "35.3738712", "-119.0194639"),
("Hanford", "Hanford", "Hanford", NULL, 1, 0, 1, NULL, "36.3274502", "-119.6456844"),
("Porterville", "Porterville", "Porterville", NULL, 1, 0, 1, NULL, "36.06523", "-119.0167679"),
("Visalia", "Visalia", "Visalia", NULL, 1, 0, 1, NULL, "36.3302284", "-119.292058"),
("San Francisco", "San Francisco", "San Francisco", NULL, 1, 0, 1, NULL, "37.7790262", "-122.419906"),
("South San Francisco", "South San Francisco", "South San Francisco", NULL, 1, 0, 1, NULL, "37.6535403", "-122.4168664"),
("Daly City", "Daly City", "Daly City", NULL, 1, 0, 1, NULL, "37.6904826", "-122.47267"),
("Monterey", "Monterey", "Monterey", NULL, 1, 0, 1, NULL, "36.58444035", "-121.86680926916"),
("Monterey", "Monterey", "Monterey", NULL, 1, 0, 1, NULL, "36.600256", "-121.8946388"),
("Santa Cruz", "Santa Cruz", "Santa Cruz", NULL, 1, 0, 1, NULL, "36.9743626", "-122.0294673"),
("Salinas", "Salinas", "Salinas", NULL, 1, 0, 1, NULL, "36.6744117", "-121.655037"),
("Gilroy", "Gilroy", "Gilroy", NULL, 1, 0, 1, NULL, "37.0065078", "-121.5631723"),
("Stanford", "Stanford", "Stanford", NULL, 1, 0, 1, NULL, "37.4265407", "-122.17030545534"),
("Palo Alto", "Palo Alto", "Palo Alto", NULL, 1, 0, 1, NULL, "37.4443293", "-122.1598465"),
("Cupertino", "Cupertino", "Cupertino", NULL, 1, 0, 1, NULL, "37.3228934", "-122.0322895"),
("Mountain View", "Mountain View", "Mountain View", NULL, 1, 0, 1, NULL, "37.3893889", "-122.0832101"),
("Sunnyvale", "Sunnyvale", "Sunnyvale", NULL, 1, 0, 1, NULL, "37.3688301", "-122.036349"),
("San Mateo", "San Mateo", "San Mateo", NULL, 1, 0, 1, NULL, "37.5629997", "-122.3253265"),
("Redwood City", "Redwood City", "Redwood City", NULL, 1, 0, 1, NULL, "37.4863239", "-122.232523"),
("Milpitas", "Milpitas", "Milpitas", NULL, 1, 0, 1, NULL, "37.4332273", "-121.8989248"),
("Fremont", "Fremont", "Fremont", NULL, 1, 0, 1, NULL, "37.5482697", "-121.988571"),
("Santa Clara", "Santa Clara", "Santa Clara", NULL, 1, 0, 1, NULL, "37.3541132", "-121.955174"),
("Oakland", "Oakland", "Oakland", NULL, 1, 0, 1, NULL, "37.8044557", "-122.271356"),
("Hayward", "Hayward", "Hayward", NULL, 1, 0, 1, NULL, "37.6688205", "-122.080796"),
("San Jose", "San Jose", "San Jose", NULL, 1, 0, 1, NULL, "37.3361663", "-121.890591"),
("Berkeley", "Berkeley", "Berkeley", NULL, 1, 0, 1, NULL, "37.8708393", "-122.272863"),
("Richmond", "Richmond", "Richmond", NULL, 1, 0, 1, NULL, "37.9357576", "-122.347748"),
("Tracy", "Tracy", "Tracy", NULL, 1, 0, 1, NULL, "37.7385507", "-121.4201395"),
("Tracy", "Tracy", "Tracy", NULL, 1, 0, 1, NULL, "37.7385507", "-121.4201395"),
("Modesto", "Modesto", "Modesto", NULL, 1, 0, 1, NULL, "37.6390972", "-120.9968782"),
("Petaluma", "Petaluma", "Petaluma", NULL, 1, 0, 1, NULL, "38.2325829", "-122.636465"),
("Sebastopol", "Sebastopol", "Sebastopol", NULL, 1, 0, 1, NULL, "38.3845125", "-122.83325015837"),
("Santa Rosa", "Santa Rosa", "Santa Rosa", NULL, 1, 0, 1, NULL, "38.4404925", "-122.7141049"),
("Vallejo", "Vallejo", "Vallejo", NULL, 1, 0, 1, NULL, "38.1040864", "-122.2566367"),
("Concord", "Concord", "Concord", NULL, 1, 0, 1, NULL, "37.9768525", "-122.0335624"),
("Antioch", "Antioch", "Antioch", NULL, 1, 0, 1, NULL, "38.0049214", "-121.805789"),
("Napa", "Napa", "Napa", NULL, 1, 0, 1, NULL, "38.2971367", "-122.2855293"),
("Fairfield", "Fairfield", "Fairfield", NULL, 1, 0, 1, NULL, "38.2493581", "-122.039966"),
("Stockton", "Stockton", "Stockton", NULL, 1, 0, 1, NULL, "37.9577016", "-121.2907796"),
("Vacaville", "Vacaville", "Vacaville", NULL, 1, 0, 1, NULL, "38.3565773", "-121.9877444"),
("Galt", "Galt", "Galt", NULL, 1, 0, 1, NULL, "38.3012325", "-121.33103724662"),
("Yuba City", "Yuba City", "Yuba City", NULL, 1, 0, 1, NULL, "39.1404477", "-121.6169108"),
("Fresno", "Fresno", "Fresno", NULL, 1, 0, 1, NULL, "36.7295295", "-119.70886126076"),
("Madera", "Madera", "Madera", NULL, 1, 0, 1, NULL, "36.9622745", "-120.0594685"),
("Turlock", "Turlock", "Turlock", NULL, 1, 0, 1, NULL, "37.4946568", "-120.8465941"),
("Merced", "Merced", "Merced", NULL, 1, 0, 1, NULL, "37.3029568", "-120.4843269"),
("Fresno", "Fresno", "Fresno", NULL, 1, 0, 1, NULL, "36.7394421", "-119.7848307"),
("Garden Grove", "Garden Grove", "Garden Grove", NULL, 1, 0, 1, NULL, "33.7746292", "-117.9463717"),
("Stanton", "Stanton", "Stanton", NULL, 1, 0, 1, NULL, "33.79410005", "-117.99510059729"),
("Norwalk", "Norwalk", "Norwalk", NULL, 1, 0, 1, NULL, "33.9092802", "-118.0849169"),
("Anaheim", "Anaheim", "Anaheim", NULL, 1, 0, 1, NULL, "33.8347516", "-117.911732"),
("Fullerton", "Fullerton", "Fullerton", NULL, 1, 0, 1, NULL, "33.8708215", "-117.9294165"),
("Orange", "Orange", "Orange", NULL, 1, 0, 1, NULL, "33.7872568", "-117.850308"),
("West Covina", "West Covina", "West Covina", NULL, 1, 0, 1, NULL, "34.0686208", "-117.9389526"),
("Pomona", "Pomona", "Pomona", NULL, 1, 0, 1, NULL, "34.0553813", "-117.7517496"),
("Ontario", "Ontario", "Ontario", NULL, 1, 0, 1, NULL, "34.065846", "-117.6484304"),
("Fontana", "Fontana", "Fontana", NULL, 1, 0, 1, NULL, "34.0922335", "-117.435048"),
("Rancho Cucamonga", "Rancho Cucamonga", "Rancho Cucamonga", NULL, 1, 0, 1, NULL, "34.1033192", "-117.5751735"),
("Moreno Valley", "Moreno Valley", "Moreno Valley", NULL, 1, 0, 1, NULL, "33.937517", "-117.2305944"),
("San Bernardino", "San Bernardino", "San Bernardino", NULL, 1, 0, 1, NULL, "34.1081621", "-117.28946"),
("Palmdale", "Palmdale", "Palmdale", NULL, 1, 0, 1, NULL, "34.5793131", "-118.1171108"),
("Victorville", "Victorville", "Victorville", NULL, 1, 0, 1, NULL, "34.5361067", "-117.2911565"),
("Palm Springs", "Palm Springs", "Palm Springs", NULL, 1, 0, 1, NULL, "33.8246269", "-116.540303"),
("Barstow", "Barstow", "Barstow", NULL, 1, 0, 1, NULL, "34.8986215", "-117.0244313"),
("Boulder City", "Boulder City", "Boulder City", NULL, 1, 0, 1, NULL, "35.9787638", "-114.8337739"),
("Las Vegas", "Las Vegas", "Las Vegas", NULL, 1, 0, 1, NULL, "36.1672559", "-115.148516"),
("Kingman", "Kingman", "Kingman", NULL, 1, 0, 1, NULL, "35.189443", "-114.0530065"),
("Henderson", "Henderson", "Henderson", NULL, 1, 0, 1, NULL, "36.0301134", "-114.9826194"),
("Lake Havasu City", "Lake Havasu City", "Lake Havasu City", NULL, 1, 0, 1, NULL, "34.4838502", "-114.322449"),
("North Las Vegas", "North Las Vegas", "North Las Vegas", NULL, 1, 0, 1, NULL, "36.2005843", "-115.121584"),
("St. George", "St. George", "St. George", NULL, 1, 0, 1, NULL, "37.104153", "-113.5841313"),
("Cedar City", "Cedar City", "Cedar City", NULL, 1, 0, 1, NULL, "37.6774238", "-113.061827"),
("Ely", "Ely", "Ely", NULL, 1, 0, 1, NULL, "39.2480588", "-114.891718"),
("Redding", "Redding", "Redding", NULL, 1, 0, 1, NULL, "40.5863563", "-122.391675"),
("Chico", "Chico", "Chico", NULL, 1, 0, 1, NULL, "39.7284945", "-121.8374777"),
("Reno", "Reno", "Reno", NULL, 1, 0, 1, NULL, "39.5261206", "-119.8126581"),
("Sparks", "Sparks", "Sparks", NULL, 1, 0, 1, NULL, "39.5404679", "-119.7487235"),
("Winnemucca", "Winnemucca", "Winnemucca", NULL, 1, 0, 1, NULL, "40.972415", "-117.7347619"),
("Elko", "Elko", "Elko", NULL, 1, 0, 1, NULL, "40.83269", "-115.7630942"),
("Nampa", "Nampa", "Nampa", NULL, 1, 0, 1, NULL, "43.5737361", "-116.559631"),
("Meridian", "Meridian", "Meridian", NULL, 1, 0, 1, NULL, "43.6086295", "-116.392326"),
("Twin Falls", "Twin Falls", "Twin Falls", NULL, 1, 0, 1, NULL, "42.5704456", "-114.4602554"),
("Tucson", "Tucson", "Tucson", NULL, 1, 0, 1, NULL, "32.2228765", "-110.9748477"),
("Las Cruces", "Las Cruces", "Las Cruces", NULL, 1, 0, 1, NULL, "32.3140354", "-106.779807"),
("El Paso", "El Paso", "El Paso", NULL, 1, 0, 1, NULL, "31.7550511", "-106.4882345"),
("Carlsbad", "Carlsbad", "Carlsbad", NULL, 1, 0, 1, NULL, "32.4257456", "-104.237612"),
("Roswell", "Roswell", "Roswell", NULL, 1, 0, 1, NULL, "33.3943282", "-104.5229518"),
("Hobbs", "Hobbs", "Hobbs", NULL, 1, 0, 1, NULL, "32.707667", "-103.1311314"),
("Lubbock", "Lubbock", "Lubbock", NULL, 1, 0, 1, NULL, "33.5855677", "-101.8470215"),
("McAllen", "McAllen", "McAllen", NULL, 1, 0, 1, NULL, "26.204114", "-98.2300605"),
("Laredo", "Laredo", "Laredo", NULL, 1, 0, 1, NULL, "27.5030915", "-99.5075644"),
("Edinburg", "Edinburg", "Edinburg", NULL, 1, 0, 1, NULL, "26.3013982", "-98.1624501"),
("Brownsville", "Brownsville", "Brownsville", NULL, 1, 0, 1, NULL, "25.9140277", "-97.4890879"),
("Harlingen", "Harlingen", "Harlingen", NULL, 1, 0, 1, NULL, "26.1907543", "-97.6960599"),
("Eagle Pass", "Eagle Pass", "Eagle Pass", NULL, 1, 0, 1, NULL, "28.7099337", "-100.493813"),
("Del Rio", "Del Rio", "Del Rio", NULL, 1, 0, 1, NULL, "29.3655405", "-100.894698"),
("Victoria", "Victoria", "Victoria", NULL, 1, 0, 1, NULL, "28.7997547", "-97.0064246"),
("New Braunfels", "New Braunfels", "New Braunfels", NULL, 1, 0, 1, NULL, "29.7028266", "-98.1257348"),
("Round Rock", "Round Rock", "Round Rock", NULL, 1, 0, 1, NULL, "30.5085915", "-97.6788056"),
("Sugar Land", "Sugar Land", "Sugar Land", NULL, 1, 0, 1, NULL, "29.6196787", "-95.6349463"),
("San Angelo", "San Angelo", "San Angelo", NULL, 1, 0, 1, NULL, "31.4649685", "-100.4405094"),
("Killeen", "Killeen", "Killeen", NULL, 1, 0, 1, NULL, "31.1171441", "-97.727796"),
("Waco", "Waco", "Waco", NULL, 1, 0, 1, NULL, "31.5491899", "-97.1474628"),
("DeCordova", "DeCordova", "DeCordova", NULL, 1, 0, 1, NULL, "32.4246522", "-97.698221313129"),
("Fort Worth", "Fort Worth", "Fort Worth", NULL, 1, 0, 1, NULL, "32.753177", "-97.3327459"),
("Denton", "Denton", "Denton", NULL, 1, 0, 1, NULL, "33.2150386", "-97.1330516"),
("Grand Prairie", "Grand Prairie", "Grand Prairie", NULL, 1, 0, 1, NULL, "32.7459645", "-96.9977846"),
("Irving", "Irving", "Irving", NULL, 1, 0, 1, NULL, "32.8295183", "-96.9442177"),
("Lewisville", "Lewisville", "Lewisville", NULL, 1, 0, 1, NULL, "33.046233", "-96.994174"),
("Garland", "Garland", "Garland", NULL, 1, 0, 1, NULL, "32.912624", "-96.6388833"),
("Pasadena", "Pasadena", "Pasadena", NULL, 1, 0, 1, NULL, "29.6910753", "-95.2092076"),
("The Woodlands", "The Woodlands", "The Woodlands", NULL, 1, 0, 1, NULL, "30.1734194", "-95.504686"),
("Houston", "Houston", "Houston", NULL, 1, 0, 1, NULL, "29.7589382", "-95.3676974"),
("Beaumont", "Beaumont", "Beaumont", NULL, 1, 0, 1, NULL, "30.0860459", "-94.1018461"),
("Lake Charles", "Lake Charles", "Lake Charles", NULL, 1, 0, 1, NULL, "30.2305095", "-93.2169807"),
("Lafayette", "Lafayette", "Lafayette", NULL, 1, 0, 1, NULL, "30.2043259", "-92.0298813"),
("Baton Rouge", "Baton Rouge", "Baton Rouge", NULL, 1, 0, 1, NULL, "30.4494155", "-91.1869659"),
("Lufkin", "Lufkin", "Lufkin", NULL, 1, 0, 1, NULL, "31.3386242", "-94.7288558"),
("Tyler", "Tyler", "Tyler", NULL, 1, 0, 1, NULL, "32.3512601", "-95.3010624"),
("Longview", "Longview", "Longview", NULL, 1, 0, 1, NULL, "32.5007031", "-94.74049"),
("Shreveport", "Shreveport", "Shreveport", NULL, 1, 0, 1, NULL, "32.5135356", "-93.7477839"),
("Texarkana", "Texarkana", "Texarkana", NULL, 1, 0, 1, NULL, "33.44667445", "-94.07714830522"),
("Texarkana", "Texarkana", "Texarkana", NULL, 1, 0, 1, NULL, "33.4254259", "-94.0430937"),
("Alexandria", "Alexandria", "Alexandria", NULL, 1, 0, 1, NULL, "31.2909782", "-92.4616292"),
("Jackson", "Jackson", "Jackson", NULL, 1, 0, 1, NULL, "32.2998686", "-90.1830408"),
("Monroe", "Monroe", "Monroe", NULL, 1, 0, 1, NULL, "32.5102427", "-92.1032411"),
("Peoria", "Peoria", "Peoria", NULL, 1, 0, 1, NULL, "33.5806115", "-112.237294"),
("Winslow", "Winslow", "Winslow", NULL, 1, 0, 1, NULL, "35.0241984", "-110.6973463"),
("Flagstaff", "Flagstaff", "Flagstaff", NULL, 1, 0, 1, NULL, "35.1987522", "-111.651822"),
("Gallup", "Gallup", "Gallup", NULL, 1, 0, 1, NULL, "35.5283506", "-108.743907"),
("Farmington", "Farmington", "Farmington", NULL, 1, 0, 1, NULL, "36.7291152", "-108.205445"),
("Durango", "Durango", "Durango", NULL, 1, 0, 1, NULL, "37.2395367", "-107.82158179169"),
("Durango", "Durango", "Durango", NULL, 1, 0, 1, NULL, "37.2769484", "-107.8766"),
("Grand Junction", "Grand Junction", "Grand Junction", NULL, 1, 0, 1, NULL, "39.063956", "-108.5507317"),
("Rio Rancho", "Rio Rancho", "Rio Rancho", NULL, 1, 0, 1, NULL, "35.2702448", "-106.6329806"),
("Albuquerque", "Albuquerque", "Albuquerque", NULL, 1, 0, 1, NULL, "35.0841034", "-106.650985"),
("Santa Fe", "Santa Fe", "Santa Fe", NULL, 1, 0, 1, NULL, "35.6876096", "-105.938456"),
("Los Alamos", "Los Alamos", "Los Alamos", NULL, 1, 0, 1, NULL, "35.88137", "-106.298959"),
("Clovis", "Clovis", "Clovis", NULL, 1, 0, 1, NULL, "34.405472", "-103.2050709"),
("Pueblo", "Pueblo", "Pueblo", NULL, 1, 0, 1, NULL, "38.2544472", "-104.609141"),
("Colorado Springs", "Colorado Springs", "Colorado Springs", NULL, 1, 0, 1, NULL, "38.8339578", "-104.825348"),
("Lehi", "Lehi", "Lehi", NULL, 1, 0, 1, NULL, "40.3881114", "-111.8486019"),
("West Valley City", "West Valley City", "West Valley City", NULL, 1, 0, 1, NULL, "40.6967254", "-111.986821"),
("Sandy", "Sandy", "Sandy", NULL, 1, 0, 1, NULL, "40.5710454", "-111.8953815"),
("Provo", "Provo", "Provo", NULL, 1, 0, 1, NULL, "40.2337289", "-111.6587085"),
("Ogden", "Ogden", "Ogden", NULL, 1, 0, 1, NULL, "41.2230048", "-111.9738429"),
("Evanston", "Evanston", "Evanston", NULL, 1, 0, 1, NULL, "41.2682462", "-110.963758"),
("Rock Springs", "Rock Springs", "Rock Springs", NULL, 1, 0, 1, NULL, "41.5860557", "-109.2194544"),
("Pocatello", "Pocatello", "Pocatello", NULL, 1, 0, 1, NULL, "42.8620287", "-112.450627"),
("Idaho Falls", "Idaho Falls", "Idaho Falls", NULL, 1, 0, 1, NULL, "43.4887907", "-112.03628"),
("Riverton", "Riverton", "Riverton", NULL, 1, 0, 1, NULL, "43.0247245", "-108.380727"),
("Cody", "Cody", "Cody", NULL, 1, 0, 1, NULL, "44.5263107", "-109.056392"),
("Sheridan", "Sheridan", "Sheridan", NULL, 1, 0, 1, NULL, "44.797194", "-106.956179"),
("Lakewood", "Lakewood", "Lakewood", NULL, 1, 0, 1, NULL, "39.7085736", "-105.0846694"),
("Boulder", "Boulder", "Boulder", NULL, 1, 0, 1, NULL, "40.0149856", "-105.270545"),
("Westminster", "Westminster", "Westminster", NULL, 1, 0, 1, NULL, "39.8366528", "-105.0372046"),
("Thornton", "Thornton", "Thornton", NULL, 1, 0, 1, NULL, "39.8695516", "-104.985181"),
("Aurora", "Aurora", "Aurora", NULL, 1, 0, 1, NULL, "39.7405111", "-104.830994"),
("Fort Collins", "Fort Collins", "Fort Collins", NULL, 1, 0, 1, NULL, "40.5508527", "-105.0668085"),
("Greeley", "Greeley", "Greeley", NULL, 1, 0, 1, NULL, "40.4233142", "-104.7091322"),
("Laramie", "Laramie", "Laramie", NULL, 1, 0, 1, NULL, "41.311367", "-105.591101"),
("Torrington", "Torrington", "Torrington", NULL, 1, 0, 1, NULL, "42.062465", "-104.184394"),
("Cheyenne", "Cheyenne", "Cheyenne", NULL, 1, 0, 1, NULL, "41.139981", "-104.820246"),
("Scottsbluff", "Scottsbluff", "Scottsbluff", NULL, 1, 0, 1, NULL, "41.862302", "-103.6627088"),
("Casper", "Casper", "Casper", NULL, 1, 0, 1, NULL, "42.8501191", "-106.325138"),
("Gillette", "Gillette", "Gillette", NULL, 1, 0, 1, NULL, "44.290635", "-105.501876"),
("Spearfish", "Spearfish", "Spearfish", NULL, 1, 0, 1, NULL, "44.490817", "-103.85937"),
("Wichita Falls", "Wichita Falls", "Wichita Falls", NULL, 1, 0, 1, NULL, "33.9004572", "-98.5020777"),
("Lawton", "Lawton", "Lawton", NULL, 1, 0, 1, NULL, "34.6086854", "-98.3903305"),
("Norman", "Norman", "Norman", NULL, 1, 0, 1, NULL, "35.2225717", "-97.4394816"),
("Edmond", "Edmond", "Edmond", NULL, 1, 0, 1, NULL, "35.6571367", "-97.4649038"),
("Oklahoma City", "Oklahoma City", "Oklahoma City", NULL, 1, 0, 1, NULL, "35.4729886", "-97.5170536"),
("Enid", "Enid", "Enid", NULL, 1, 0, 1, NULL, "36.3967623", "-97.8791341"),
("Stillwater", "Stillwater", "Stillwater", NULL, 1, 0, 1, NULL, "36.1156306", "-97.0585717"),
("Tulsa", "Tulsa", "Tulsa", NULL, 1, 0, 1, NULL, "36.1563122", "-95.9927516"),
("Dodge City", "Dodge City", "Dodge City", NULL, 1, 0, 1, NULL, "37.7527982", "-100.0170787"),
("Garden City", "Garden City", "Garden City", NULL, 1, 0, 1, NULL, "37.9716898", "-100.8726618"),
("Wichita", "Wichita", "Wichita", NULL, 1, 0, 1, NULL, "37.6922361", "-97.3375448"),
("Bartlesville", "Bartlesville", "Bartlesville", NULL, 1, 0, 1, NULL, "36.7421089", "-95.9528877"),
("Hutchinson", "Hutchinson", "Hutchinson", NULL, 1, 0, 1, NULL, "38.0608444", "-97.9297743"),
("Salina", "Salina", "Salina", NULL, 1, 0, 1, NULL, "38.8402805", "-97.6114237"),
("Emporia", "Emporia", "Emporia", NULL, 1, 0, 1, NULL, "38.4040054", "-96.181623"),
("Manhattan", "Manhattan", "Manhattan", NULL, 1, 0, 1, NULL, "39.1836082", "-96.5716694"),
("Topeka", "Topeka", "Topeka", NULL, 1, 0, 1, NULL, "39.049011", "-95.677556"),
("Hot Springs", "Hot Springs", "Hot Springs", NULL, 1, 0, 1, NULL, "34.5038393", "-93.0552437"),
("Muskogee", "Muskogee", "Muskogee", NULL, 1, 0, 1, NULL, "35.7478769", "-95.3696909"),
("Fort Smith", "Fort Smith", "Fort Smith", NULL, 1, 0, 1, NULL, "35.3784666", "-94.3996456"),
("Wiederkehr Village", "Wiederkehr Village", "Wiederkehr Village", NULL, 1, 0, 1, NULL, "35.47856035", "-93.762040075522"),
("Springdale", "Springdale", "Springdale", NULL, 1, 0, 1, NULL, "36.1867442", "-94.1288142"),
("Fayetteville", "Fayetteville", "Fayetteville", NULL, 1, 0, 1, NULL, "36.0625843", "-94.1574328"),
("Bethel Heights", "Bethel Heights", "Bethel Heights", NULL, 1, 0, 1, NULL, "36.218113", "-94.1261119"),
("Pine Bluff", "Pine Bluff", "Pine Bluff", NULL, 1, 0, 1, NULL, "34.2157064", "-92.0140402"),
("Little Rock", "Little Rock", "Little Rock", NULL, 1, 0, 1, NULL, "34.7465071", "-92.2896267"),
("Jonesboro", "Jonesboro", "Jonesboro", NULL, 1, 0, 1, NULL, "35.8272257", "-90.6949871"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "37.1968298", "-93.2946576"),
("Lawrence", "Lawrence", "Lawrence", NULL, 1, 0, 1, NULL, "38.9719384", "-95.2359496"),
("Lenexa", "Lenexa", "Lenexa", NULL, 1, 0, 1, NULL, "38.9697458", "-94.7845837"),
("Olathe", "Olathe", "Olathe", NULL, 1, 0, 1, NULL, "38.8838856", "-94.81887"),
("Overland Park", "Overland Park", "Overland Park", NULL, 1, 0, 1, NULL, "38.9742502", "-94.6851702"),
("Belton", "Belton", "Belton", NULL, 1, 0, 1, NULL, "38.8108097", "-94.5313502"),
("Lee's Summit", "Lee's Summit", "Lee's Summit", NULL, 1, 0, 1, NULL, "38.9107156", "-94.3821295"),
("Kansas City", "Kansas City", "Kansas City", NULL, 1, 0, 1, NULL, "39.1134562", "-94.626497"),
("Blue Springs", "Blue Springs", "Blue Springs", NULL, 1, 0, 1, NULL, "39.017316", "-94.282265"),
("Kansas City", "Kansas City", "Kansas City", NULL, 1, 0, 1, NULL, "39.100105", "-94.5781416"),
("Independence", "Independence", "Independence", NULL, 1, 0, 1, NULL, "39.0924792", "-94.4137923"),
("Gladstone", "Gladstone", "Gladstone", NULL, 1, 0, 1, NULL, "39.2214765", "-94.5719748"),
("Liberty", "Liberty", "Liberty", NULL, 1, 0, 1, NULL, "39.246479", "-94.419079"),
("Warrensburg", "Warrensburg", "Warrensburg", NULL, 1, 0, 1, NULL, "38.7624373", "-93.7409596"),
("Sedalia", "Sedalia", "Sedalia", NULL, 1, 0, 1, NULL, "38.7098314", "-93.2295515"),
("Rolla", "Rolla", "Rolla", NULL, 1, 0, 1, NULL, "37.9509324", "-91.7708076"),
("Jefferson City", "Jefferson City", "Jefferson City", NULL, 1, 0, 1, NULL, "38.577359", "-92.1724265"),
("Columbia", "Columbia", "Columbia", NULL, 1, 0, 1, NULL, "38.951883", "-92.3337366"),
("O’Fallon", "O’Fallon", "O’Fallon", NULL, 1, 0, 1, NULL, "38.7902503", "-90.7033292"),
("Saint Charles", "Saint Charles", "Saint Charles", NULL, 1, 0, 1, NULL, "38.783855", "-90.481677"),
("Lexington", "Lexington", "Lexington", NULL, 1, 0, 1, NULL, "40.7788486", "-99.7414869"),
("Kearney", "Kearney", "Kearney", NULL, 1, 0, 1, NULL, "40.699478", "-99.081858"),
("North Platte", "North Platte", "North Platte", NULL, 1, 0, 1, NULL, "41.1238873", "-100.7654232"),
("Hastings", "Hastings", "Hastings", NULL, 1, 0, 1, NULL, "40.5861322", "-98.3898883"),
("Beatrice", "Beatrice", "Beatrice", NULL, 1, 0, 1, NULL, "40.266429", "-96.747369"),
("Grand Island", "Grand Island", "Grand Island", NULL, 1, 0, 1, NULL, "40.924271", "-98.338685"),
("Columbus", "Columbus", "Columbus", NULL, 1, 0, 1, NULL, "41.4292988", "-97.3581439"),
("Norfolk", "Norfolk", "Norfolk", NULL, 1, 0, 1, NULL, "42.0283379", "-97.4169964"),
("Lincoln", "Lincoln", "Lincoln", NULL, 1, 0, 1, NULL, "40.8088861", "-96.7077751"),
("Fremont", "Fremont", "Fremont", NULL, 1, 0, 1, NULL, "41.4338363", "-96.4960449"),
("Omaha", "Omaha", "Omaha", NULL, 1, 0, 1, NULL, "41.2587459", "-95.9383758"),
("Council Bluffs", "Council Bluffs", "Council Bluffs", NULL, 1, 0, 1, NULL, "41.258841", "-95.8519484"),
("Pierre", "Pierre", "Pierre", NULL, 1, 0, 1, NULL, "44.3683644", "-100.351136"),
("Yankton", "Yankton", "Yankton", NULL, 1, 0, 1, NULL, "42.8712938", "-97.3967011"),
("Sioux City", "Sioux City", "Sioux City", NULL, 1, 0, 1, NULL, "42.4966815", "-96.4058782"),
("Vermillion", "Vermillion", "Vermillion", NULL, 1, 0, 1, NULL, "42.7795273", "-96.929101"),
("Sioux Falls", "Sioux Falls", "Sioux Falls", NULL, 1, 0, 1, NULL, "43.5488256", "-96.7307737"),
("Mitchell", "Mitchell", "Mitchell", NULL, 1, 0, 1, NULL, "43.70953", "-98.025379"),
("Huron", "Huron", "Huron", NULL, 1, 0, 1, NULL, "44.36308", "-98.214388"),
("Watertown", "Watertown", "Watertown", NULL, 1, 0, 1, NULL, "44.899211", "-97.115289"),
("Brookings", "Brookings", "Brookings", NULL, 1, 0, 1, NULL, "44.311461", "-96.79844"),
("St. Joseph", "St. Joseph", "St. Joseph", NULL, 1, 0, 1, NULL, "39.7686055", "-94.8466322"),
("West Des Moines", "West Des Moines", "West Des Moines", NULL, 1, 0, 1, NULL, "41.5644476", "-93.7594059"),
("Des Moines", "Des Moines", "Des Moines", NULL, 1, 0, 1, NULL, "41.5910323", "-93.6046655"),
("Ames", "Ames", "Ames", NULL, 1, 0, 1, NULL, "42.0267567", "-93.6170448"),
("Hannibal", "Hannibal", "Hannibal", NULL, 1, 0, 1, NULL, "39.7082498", "-91.3587413"),
("Quincy", "Quincy", "Quincy", NULL, 1, 0, 1, NULL, "39.9356016", "-91.4098727"),
("Iowa City", "Iowa City", "Iowa City", NULL, 1, 0, 1, NULL, "41.6612561", "-91.5299106"),
("Cedar Rapids", "Cedar Rapids", "Cedar Rapids", NULL, 1, 0, 1, NULL, "41.9758872", "-91.6704053"),
("Burlington", "Burlington", "Burlington", NULL, 1, 0, 1, NULL, "40.8126922", "-91.1020205"),
("Galesburg", "Galesburg", "Galesburg", NULL, 1, 0, 1, NULL, "40.9475652", "-90.3712169"),
("Rock Island", "Rock Island", "Rock Island", NULL, 1, 0, 1, NULL, "41.5095446", "-90.5792031"),
("Moline", "Moline", "Moline", NULL, 1, 0, 1, NULL, "41.5058344", "-90.5136642"),
("Davenport", "Davenport", "Davenport", NULL, 1, 0, 1, NULL, "41.5235808", "-90.5770967"),
("Fort Dodge", "Fort Dodge", "Fort Dodge", NULL, 1, 0, 1, NULL, "42.5044017", "-94.1910044"),
("Mankato", "Mankato", "Mankato", NULL, 1, 0, 1, NULL, "44.1634663", "-93.9993505"),
("Minneapolis", "Minneapolis", "Minneapolis", NULL, 1, 0, 1, NULL, "44.9772995", "-93.2654692"),
("Saint Paul", "Saint Paul", "Saint Paul", NULL, 1, 0, 1, NULL, "44.9497487", "-93.0931028"),
("Waterloo", "Waterloo", "Waterloo", NULL, 1, 0, 1, NULL, "42.498275", "-92.3328743"),
("Cedar Falls", "Cedar Falls", "Cedar Falls", NULL, 1, 0, 1, NULL, "42.5361805", "-92.447758"),
("Dubuque", "Dubuque", "Dubuque", NULL, 1, 0, 1, NULL, "42.5006243", "-90.6647985"),
("Rochester", "Rochester", "Rochester", NULL, 1, 0, 1, NULL, "44.0234387", "-92.4630182"),
("La Crosse", "La Crosse", "La Crosse", NULL, 1, 0, 1, NULL, "43.8122836", "-91.2514355"),
("Nome", "Nome", "Nome", NULL, 1, 0, 1, NULL, "64.5011111", "-165.4063889"),
("St. Michael", "St. Michael", "St. Michael", NULL, 1, 0, 1, NULL, "63.46451", "-162.09896275266"),
("Soldotna", "Soldotna", "Soldotna", NULL, 1, 0, 1, NULL, "60.4847228", "-151.065349"),
("Seward", "Seward", "Seward", NULL, 1, 0, 1, NULL, "60.104202", "-149.442611"),
("Homer", "Homer", "Homer", NULL, 1, 0, 1, NULL, "59.6440876", "-151.5401477"),
("Kenai", "Kenai", "Kenai", NULL, 1, 0, 1, NULL, "60.5544444", "-151.258333"),
("Soldotna", "Soldotna", "Soldotna", NULL, 1, 0, 1, NULL, "60.4847228", "-151.065349"),
("Valdez", "Valdez", "Valdez", NULL, 1, 0, 1, NULL, "61.1299396", "-146.349363"),
("Fairbanks", "Fairbanks", "Fairbanks", NULL, 1, 0, 1, NULL, "64.837845", "-147.716675"),
("Nenana", "Nenana", "Nenana", NULL, 1, 0, 1, NULL, "64.5639068", "-149.093474"),
("Cordova", "Cordova", "Cordova", NULL, 1, 0, 1, NULL, "60.5439444", "-145.75891"),
("Wainwright", "Wainwright", "Wainwright", NULL, 1, 0, 1, NULL, "70.6369444", "-160.038333"),
("Point Hope", "Point Hope", "Point Hope", NULL, 1, 0, 1, NULL, "68.3498679", "-166.752609"),
("Utqiaġvik", "Utqiaġvik", "Utqiaġvik", NULL, 1, 0, 1, NULL, "71.2905556", "-156.788611"),
("Atqasuk", "Atqasuk", "Atqasuk", NULL, 1, 0, 1, NULL, "70.4811247", "-157.420841"),
("Anaktuvuk Pass", "Anaktuvuk Pass", "Anaktuvuk Pass", NULL, 1, 0, 1, NULL, "68.1413944", "-151.735979"),
("Kaktovik", "Kaktovik", "Kaktovik", NULL, 1, 0, 1, NULL, "70.1274505", "-143.6128656"),
("Aberdeen", "Aberdeen", "Aberdeen", NULL, 1, 0, 1, NULL, "46.975371", "-123.815722"),
("Ketchikan", "Ketchikan", "Ketchikan", NULL, 1, 0, 1, NULL, "55.3430696", "-131.6466819"),
("Olympia", "Olympia", "Olympia", NULL, 1, 0, 1, NULL, "47.0451022", "-122.8950075"),
("Bremerton", "Bremerton", "Bremerton", NULL, 1, 0, 1, NULL, "47.5653663", "-122.6246836"),
("Tacoma", "Tacoma", "Tacoma", NULL, 1, 0, 1, NULL, "47.2455013", "-122.438329"),
("Seattle", "Seattle", "Seattle", NULL, 1, 0, 1, NULL, "47.6038321", "-122.330062"),
("Bellevue", "Bellevue", "Bellevue", NULL, 1, 0, 1, NULL, "47.6144219", "-122.192337"),
("Pasco", "Pasco", "Pasco", NULL, 1, 0, 1, NULL, "46.2306739", "-119.0921"),
("Kennewick", "Kennewick", "Kennewick", NULL, 1, 0, 1, NULL, "46.2087066", "-119.119919"),
("Richland", "Richland", "Richland", NULL, 1, 0, 1, NULL, "46.2804298", "-119.275205"),
("Walla Walla", "Walla Walla", "Walla Walla", NULL, 1, 0, 1, NULL, "46.0667277", "-118.339345"),
("Yakima", "Yakima", "Yakima", NULL, 1, 0, 1, NULL, "46.601557", "-120.510842"),
("Wenatchee", "Wenatchee", "Wenatchee", NULL, 1, 0, 1, NULL, "47.4234599", "-120.310349"),
("Bellingham", "Bellingham", "Bellingham", NULL, 1, 0, 1, NULL, "48.7544012", "-122.478836"),
("Everett", "Everett", "Everett", NULL, 1, 0, 1, NULL, "47.9793437", "-122.2127011"),
("Lewiston", "Lewiston", "Lewiston", NULL, 1, 0, 1, NULL, "46.4195913", "-117.0216144"),
("Clarkston", "Clarkston", "Clarkston", NULL, 1, 0, 1, NULL, "46.4162724", "-117.045179"),
("Spokane", "Spokane", "Spokane", NULL, 1, 0, 1, NULL, "47.6571934", "-117.42351"),
("Coeur d'Alene", "Coeur d'Alene", "Coeur d'Alene", NULL, 1, 0, 1, NULL, "47.6742994", "-116.7811531"),
("Missoula", "Missoula", "Missoula", NULL, 1, 0, 1, NULL, "46.8701049", "-113.995267"),
("Kalispell", "Kalispell", "Kalispell", NULL, 1, 0, 1, NULL, "48.202158", "-114.315321"),
("Bozeman", "Bozeman", "Bozeman", NULL, 1, 0, 1, NULL, "45.6794293", "-111.044047"),
("Great Falls", "Great Falls", "Great Falls", NULL, 1, 0, 1, NULL, "47.5048851", "-111.29189"),
("Billings", "Billings", "Billings", NULL, 1, 0, 1, NULL, "45.7874957", "-108.49607"),
("Havre", "Havre", "Havre", NULL, 1, 0, 1, NULL, "48.5536972", "-109.677802"),
("Dickinson", "Dickinson", "Dickinson", NULL, 1, 0, 1, NULL, "46.8791756", "-102.7896242"),
("Williston", "Williston", "Williston", NULL, 1, 0, 1, NULL, "48.1465457", "-103.621814"),
("Minot", "Minot", "Minot", NULL, 1, 0, 1, NULL, "48.23251", "-101.296273"),
("Aberdeen", "Aberdeen", "Aberdeen", NULL, 1, 0, 1, NULL, "45.4649805", "-98.487813"),
("Bismarck", "Bismarck", "Bismarck", NULL, 1, 0, 1, NULL, "46.808327", "-100.783739"),
("Fargo", "Fargo", "Fargo", NULL, 1, 0, 1, NULL, "46.877229", "-96.789821"),
("Grand Forks", "Grand Forks", "Grand Forks", NULL, 1, 0, 1, NULL, "47.9078244", "-97.0592028"),
("St. Cloud", "St. Cloud", "St. Cloud", NULL, 1, 0, 1, NULL, "45.5616075", "-94.1642004"),
("Duluth", "Duluth", "Duluth", NULL, 1, 0, 1, NULL, "46.7729322", "-92.1251218"),
("International Falls", "International Falls", "International Falls", NULL, 1, 0, 1, NULL, "48.601033", "-93.4105904"),
("Cape Coral", "Cape Coral", "Cape Coral", NULL, 1, 0, 1, NULL, "26.6059432", "-81.9806771"),
("Fort Myers", "Fort Myers", "Fort Myers", NULL, 1, 0, 1, NULL, "26.640628", "-81.8723084"),
("North Port", "North Port", "North Port", NULL, 1, 0, 1, NULL, "27.044224", "-82.2359254"),
("Sarasota", "Sarasota", "Sarasota", NULL, 1, 0, 1, NULL, "27.3365805", "-82.5308545"),
("Saint Petersburg", "Saint Petersburg", "Saint Petersburg", NULL, 1, 0, 1, NULL, "27.7700475", "-82.6359078"),
("Bradenton", "Bradenton", "Bradenton", NULL, 1, 0, 1, NULL, "27.4989278", "-82.5748194"),
("Largo", "Largo", "Largo", NULL, 1, 0, 1, NULL, "27.9094665", "-82.7873244"),
("Tampa", "Tampa", "Tampa", NULL, 1, 0, 1, NULL, "27.9477595", "-82.458444"),
("Clearwater", "Clearwater", "Clearwater", NULL, 1, 0, 1, NULL, "27.9658533", "-82.8001026"),
("Lakeland", "Lakeland", "Lakeland", NULL, 1, 0, 1, NULL, "28.0394654", "-81.9498042"),
("Homestead", "Homestead", "Homestead", NULL, 1, 0, 1, NULL, "25.4718946", "-80.4759905"),
("Miami", "Miami", "Miami", NULL, 1, 0, 1, NULL, "25.7741728", "-80.19362"),
("Fort Lauderdale", "Fort Lauderdale", "Fort Lauderdale", NULL, 1, 0, 1, NULL, "26.1223084", "-80.1433786"),
("Pompano Beach", "Pompano Beach", "Pompano Beach", NULL, 1, 0, 1, NULL, "26.2378597", "-80.1247667"),
("Miami Beach", "Miami Beach", "Miami Beach", NULL, 1, 0, 1, NULL, "25.7929198", "-80.1353006"),
("Deerfield Beach", "Deerfield Beach", "Deerfield Beach", NULL, 1, 0, 1, NULL, "26.318342", "-80.0996306"),
("Boca Raton", "Boca Raton", "Boca Raton", NULL, 1, 0, 1, NULL, "26.3586885", "-80.0830984"),
("Port Saint Lucie", "Port Saint Lucie", "Port Saint Lucie", NULL, 1, 0, 1, NULL, "27.2939333", "-80.3503283"),
("Palm Bay", "Palm Bay", "Palm Bay", NULL, 1, 0, 1, NULL, "27.9946969", "-80.6366144"),
("West Palm Beach", "West Palm Beach", "West Palm Beach", NULL, 1, 0, 1, NULL, "26.715364", "-80.0532942"),
("Melbourne", "Melbourne", "Melbourne", NULL, 1, 0, 1, NULL, "28.106471", "-80.6371513"),
("New Orleans", "New Orleans", "New Orleans", NULL, 1, 0, 1, NULL, "29.9759983", "-90.0782127"),
("Gulfport", "Gulfport", "Gulfport", NULL, 1, 0, 1, NULL, "30.3674198", "-89.0928155"),
("Biloxi", "Biloxi", "Biloxi", NULL, 1, 0, 1, NULL, "30.4007626", "-88.8893818"),
("Mobile", "Mobile", "Mobile", NULL, 1, 0, 1, NULL, "30.6913462", "-88.0437509"),
("Pensacola", "Pensacola", "Pensacola", NULL, 1, 0, 1, NULL, "30.421309", "-87.2169149"),
("Hattiesburg", "Hattiesburg", "Hattiesburg", NULL, 1, 0, 1, NULL, "31.3271189", "-89.2903392"),
("Meridian", "Meridian", "Meridian", NULL, 1, 0, 1, NULL, "32.3643098", "-88.703656"),
("Tuscaloosa", "Tuscaloosa", "Tuscaloosa", NULL, 1, 0, 1, NULL, "33.2095614", "-87.5675258"),
("Dothan", "Dothan", "Dothan", NULL, 1, 0, 1, NULL, "31.2237434", "-85.3933906"),
("Montgomery", "Montgomery", "Montgomery", NULL, 1, 0, 1, NULL, "32.3669656", "-86.3006485"),
("Birmingham", "Birmingham", "Birmingham", NULL, 1, 0, 1, NULL, "33.5206824", "-86.8024326"),
("Auburn", "Auburn", "Auburn", NULL, 1, 0, 1, NULL, "32.6098566", "-85.4807825"),
("Columbus", "Columbus", "Columbus", NULL, 1, 0, 1, NULL, "32.4610708", "-84.9880449"),
("Ocala", "Ocala", "Ocala", NULL, 1, 0, 1, NULL, "29.1871986", "-82.1400923"),
("Tallahassee", "Tallahassee", "Tallahassee", NULL, 1, 0, 1, NULL, "30.4380832", "-84.2809332"),
("Gainesville", "Gainesville", "Gainesville", NULL, 1, 0, 1, NULL, "29.6519684", "-82.3249846"),
("Valdosta", "Valdosta", "Valdosta", NULL, 1, 0, 1, NULL, "30.8327022", "-83.2784851"),
("Jacksonville", "Jacksonville", "Jacksonville", NULL, 1, 0, 1, NULL, "30.3321838", "-81.655651"),
("Kissimmee", "Kissimmee", "Kissimmee", NULL, 1, 0, 1, NULL, "28.2918995", "-81.4075838"),
("Deltona", "Deltona", "Deltona", NULL, 1, 0, 1, NULL, "28.9005446", "-81.2636738"),
("Orlando", "Orlando", "Orlando", NULL, 1, 0, 1, NULL, "28.5421109", "-81.3790304"),
("Daytona Beach", "Daytona Beach", "Daytona Beach", NULL, 1, 0, 1, NULL, "29.2108147", "-81.0228331"),
("Palm Coast", "Palm Coast", "Palm Coast", NULL, 1, 0, 1, NULL, "29.5541432", "-81.2207673"),
("Albany", "Albany", "Albany", NULL, 1, 0, 1, NULL, "31.5782062", "-84.1556809"),
("Macon", "Macon", "Macon", NULL, 1, 0, 1, NULL, "32.8406946", "-83.6324022"),
("Warner Robins", "Warner Robins", "Warner Robins", NULL, 1, 0, 1, NULL, "32.6200973", "-83.606568"),
("Savannah", "Savannah", "Savannah", NULL, 1, 0, 1, NULL, "32.0790074", "-81.0921335"),
("Orangeburg", "Orangeburg", "Orangeburg", NULL, 1, 0, 1, NULL, "33.4918203", "-80.8556476"),
("Myrtle Beach", "Myrtle Beach", "Myrtle Beach", NULL, 1, 0, 1, NULL, "33.6956461", "-78.8900409"),
("Tupelo", "Tupelo", "Tupelo", NULL, 1, 0, 1, NULL, "34.2576067", "-88.7033859"),
("Southaven", "Southaven", "Southaven", NULL, 1, 0, 1, NULL, "34.9873822", "-90.0034862"),
("Memphis", "Memphis", "Memphis", NULL, 1, 0, 1, NULL, "35.1460249", "-90.0517638"),
("Charleston", "Charleston", "Charleston", NULL, 1, 0, 1, NULL, "32.7884363", "-79.9399309"),
("Jackson", "Jackson", "Jackson", NULL, 1, 0, 1, NULL, "35.6144446", "-88.8177418"),
("Dickson", "Dickson", "Dickson", NULL, 1, 0, 1, NULL, "36.0766534", "-87.3870096"),
("Clarksville", "Clarksville", "Clarksville", NULL, 1, 0, 1, NULL, "36.5277607", "-87.3588703"),
("Huntsville", "Huntsville", "Huntsville", NULL, 1, 0, 1, NULL, "34.729847", "-86.5859011"),
("Decatur", "Decatur", "Decatur", NULL, 1, 0, 1, NULL, "34.6060203", "-86.9838165"),
("Smyrna", "Smyrna", "Smyrna", NULL, 1, 0, 1, NULL, "33.883887", "-84.5147454"),
("Atlanta", "Atlanta", "Atlanta", NULL, 1, 0, 1, NULL, "33.7489924", "-84.3902644"),
("Marietta", "Marietta", "Marietta", NULL, 1, 0, 1, NULL, "33.9528472", "-84.5496148"),
("Dalton", "Dalton", "Dalton", NULL, 1, 0, 1, NULL, "34.7691867", "-84.9702475"),
("Chattanooga", "Chattanooga", "Chattanooga", NULL, 1, 0, 1, NULL, "35.0457219", "-85.3094883"),
("Franklin", "Franklin", "Franklin", NULL, 1, 0, 1, NULL, "35.925206", "-86.8689419"),
("Murfreesboro", "Murfreesboro", "Murfreesboro", NULL, 1, 0, 1, NULL, "35.8460396", "-86.3921096"),
("Cape Girardeau", "Cape Girardeau", "Cape Girardeau", NULL, 1, 0, 1, NULL, "37.3034933", "-89.5230357"),
("Paducah", "Paducah", "Paducah", NULL, 1, 0, 1, NULL, "37.0833893", "-88.6000478"),
("Hopkinsville", "Hopkinsville", "Hopkinsville", NULL, 1, 0, 1, NULL, "36.8657651", "-87.4889532"),
("Evansville", "Evansville", "Evansville", NULL, 1, 0, 1, NULL, "37.970495", "-87.5715641"),
("Bowling Green", "Bowling Green", "Bowling Green", NULL, 1, 0, 1, NULL, "36.9903199", "-86.4436018"),
("Owensboro", "Owensboro", "Owensboro", NULL, 1, 0, 1, NULL, "37.7742152", "-87.1133304"),
("Elizabethtown", "Elizabethtown", "Elizabethtown", NULL, 1, 0, 1, NULL, "37.693952", "-85.8591285"),
("Bloomington", "Bloomington", "Bloomington", NULL, 1, 0, 1, NULL, "39.1670396", "-86.5342881"),
("Frankfort", "Frankfort", "Frankfort", NULL, 1, 0, 1, NULL, "38.2009055", "-84.8732836"),
("Cincinnati", "Cincinnati", "Cincinnati", NULL, 1, 0, 1, NULL, "39.1014537", "-84.5124602"),
("Roswell", "Roswell", "Roswell", NULL, 1, 0, 1, NULL, "34.02332", "-84.360022"),
("Sandy Springs", "Sandy Springs", "Sandy Springs", NULL, 1, 0, 1, NULL, "33.9242688", "-84.3785379"),
("Johns Creek", "Johns Creek", "Johns Creek", NULL, 1, 0, 1, NULL, "34.0181557", "-84.190196"),
("Athens-Clarke County Unified Government", "Athens-Clarke County Unified Government", "Athens-Clarke County Unified Government", NULL, 1, 0, 1, NULL, "33.9597677", "-83.376398"),
("Anderson", "Anderson", "Anderson", NULL, 1, 0, 1, NULL, "34.5068601", "-82.6506264"),
("Greenville", "Greenville", "Greenville", NULL, 1, 0, 1, NULL, "34.851354", "-82.3984882"),
("Spartanburg", "Spartanburg", "Spartanburg", NULL, 1, 0, 1, NULL, "34.9498007", "-81.9320157"),
("Oak Ridge", "Oak Ridge", "Oak Ridge", NULL, 1, 0, 1, NULL, "36.0103562", "-84.2696449"),
("Morristown", "Morristown", "Morristown", NULL, 1, 0, 1, NULL, "36.2139814", "-83.2948923"),
("Asheville", "Asheville", "Asheville", NULL, 1, 0, 1, NULL, "35.595076", "-82.5528478"),
("Knoxville", "Knoxville", "Knoxville", NULL, 1, 0, 1, NULL, "35.9603948", "-83.9210261"),
("Kingsport", "Kingsport", "Kingsport", NULL, 1, 0, 1, NULL, "36.550238", "-82.5594293"),
("Boone", "Boone", "Boone", NULL, 1, 0, 1, NULL, "36.2165362", "-81.6746158"),
("Bristol", "Bristol", "Bristol", NULL, 1, 0, 1, NULL, "36.5945034", "-82.1885212"),
("Johnson City", "Johnson City", "Johnson City", NULL, 1, 0, 1, NULL, "36.3134398", "-82.3534728"),
("Columbia", "Columbia", "Columbia", NULL, 1, 0, 1, NULL, "34.0007493", "-81.0343313"),
("Monroe", "Monroe", "Monroe", NULL, 1, 0, 1, NULL, "34.9854275", "-80.5495112"),
("Florence", "Florence", "Florence", NULL, 1, 0, 1, NULL, "34.1984435", "-79.7671658"),
("Fayetteville", "Fayetteville", "Fayetteville", NULL, 1, 0, 1, NULL, "35.0525759", "-78.878292"),
("Gastonia", "Gastonia", "Gastonia", NULL, 1, 0, 1, NULL, "35.2622654", "-81.1838186"),
("Hickory", "Hickory", "Hickory", NULL, 1, 0, 1, NULL, "35.7333312", "-81.3442915"),
("Charlotte", "Charlotte", "Charlotte", NULL, 1, 0, 1, NULL, "35.2272086", "-80.8430827"),
("Statesville", "Statesville", "Statesville", NULL, 1, 0, 1, NULL, "35.7826363", "-80.8872959"),
("Concord", "Concord", "Concord", NULL, 1, 0, 1, NULL, "35.4094178", "-80.5800049"),
("Salisbury", "Salisbury", "Salisbury", NULL, 1, 0, 1, NULL, "35.6709727", "-80.4742261"),
("Lenoir", "Lenoir", "Lenoir", NULL, 1, 0, 1, NULL, "35.9140196", "-81.5389849"),
("Winston-Salem", "Winston-Salem", "Winston-Salem", NULL, 1, 0, 1, NULL, "36.0998131", "-80.2440518"),
("Cary", "Cary", "Cary", NULL, 1, 0, 1, NULL, "35.7882893", "-78.7812081"),
("High Point", "High Point", "High Point", NULL, 1, 0, 1, NULL, "35.9556924", "-80.0053176"),
("Burlington", "Burlington", "Burlington", NULL, 1, 0, 1, NULL, "36.0956918", "-79.4377991"),
("Greensboro", "Greensboro", "Greensboro", NULL, 1, 0, 1, NULL, "36.0726355", "-79.7919754"),
("Durham", "Durham", "Durham", NULL, 1, 0, 1, NULL, "35.996653", "-78.9018053"),
("Richmond", "Richmond", "Richmond", NULL, 1, 0, 1, NULL, "37.7478572", "-84.2946539"),
("Chillicothe", "Chillicothe", "Chillicothe", NULL, 1, 0, 1, NULL, "39.3331197", "-82.9824019"),
("Ashland", "Ashland", "Ashland", NULL, 1, 0, 1, NULL, "38.4784144", "-82.6379387"),
("Huntington", "Huntington", "Huntington", NULL, 1, 0, 1, NULL, "38.4192496", "-82.445154"),
("Charleston", "Charleston", "Charleston", NULL, 1, 0, 1, NULL, "38.3505995", "-81.6332812"),
("Blacksburg", "Blacksburg", "Blacksburg", NULL, 1, 0, 1, NULL, "37.2296566", "-80.4136767"),
("Roanoke", "Roanoke", "Roanoke", NULL, 1, 0, 1, NULL, "37.270973", "-79.9414313"),
("Lynchburg", "Lynchburg", "Lynchburg", NULL, 1, 0, 1, NULL, "37.4137536", "-79.1422464"),
("Parkersburg", "Parkersburg", "Parkersburg", NULL, 1, 0, 1, NULL, "39.2667309", "-81.5620755"),
("Harrisonburg", "Harrisonburg", "Harrisonburg", NULL, 1, 0, 1, NULL, "38.4493315", "-78.8688833"),
("Elkins", "Elkins", "Elkins", NULL, 1, 0, 1, NULL, "38.925927", "-79.8466552"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "39.7990175", "-89.6439575"),
("Decatur", "Decatur", "Decatur", NULL, 1, 0, 1, NULL, "39.8454163", "-88.9524151"),
("Peoria", "Peoria", "Peoria", NULL, 1, 0, 1, NULL, "40.6938609", "-89.5891008"),
("Bloomington", "Bloomington", "Bloomington", NULL, 1, 0, 1, NULL, "40.4797828", "-88.9939147"),
("Terre Haute", "Terre Haute", "Terre Haute", NULL, 1, 0, 1, NULL, "39.4667025", "-87.4139119"),
("Champaign", "Champaign", "Champaign", NULL, 1, 0, 1, NULL, "40.1164841", "-88.2430932"),
("Urbana", "Urbana", "Urbana", NULL, 1, 0, 1, NULL, "40.1117174", "-88.207301"),
("Aurora", "Aurora", "Aurora", NULL, 1, 0, 1, NULL, "41.7571701", "-88.3147539"),
("Joliet", "Joliet", "Joliet", NULL, 1, 0, 1, NULL, "41.5263603", "-88.0840212"),
("Naperville", "Naperville", "Naperville", NULL, 1, 0, 1, NULL, "41.7728699", "-88.1479278"),
("Elgin", "Elgin", "Elgin", NULL, 1, 0, 1, NULL, "42.03726", "-88.2810994"),
("Chicago", "Chicago", "Chicago", NULL, 1, 0, 1, NULL, "41.8755616", "-87.6244212"),
("Gary", "Gary", "Gary", NULL, 1, 0, 1, NULL, "41.6020962", "-87.3370647"),
("Fishers", "Fishers", "Fishers", NULL, 1, 0, 1, NULL, "39.9555928", "-86.0138729"),
("Lafayette", "Lafayette", "Lafayette", NULL, 1, 0, 1, NULL, "40.4167022", "-86.8752869"),
("Muncie", "Muncie", "Muncie", NULL, 1, 0, 1, NULL, "40.1936892", "-85.3865271"),
("South Bend", "South Bend", "South Bend", NULL, 1, 0, 1, NULL, "41.6833813", "-86.2500066"),
("Elkhart", "Elkhart", "Elkhart", NULL, 1, 0, 1, NULL, "41.6819935", "-85.9766671"),
("Fort Wayne", "Fort Wayne", "Fort Wayne", NULL, 1, 0, 1, NULL, "41.0799898", "-85.1386015"),
("Rockford", "Rockford", "Rockford", NULL, 1, 0, 1, NULL, "42.2713945", "-89.093966"),
("Kenosha", "Kenosha", "Kenosha", NULL, 1, 0, 1, NULL, "42.5846773", "-87.8212263"),
("Waukegan", "Waukegan", "Waukegan", NULL, 1, 0, 1, NULL, "42.3636331", "-87.8447938"),
("Racine", "Racine", "Racine", NULL, 1, 0, 1, NULL, "42.7260523", "-87.7825242"),
("Waukesha", "Waukesha", "Waukesha", NULL, 1, 0, 1, NULL, "43.0116784", "-88.2314813"),
("Wausau", "Wausau", "Wausau", NULL, 1, 0, 1, NULL, "44.9596017", "-89.6298239"),
("Stevens Point", "Stevens Point", "Stevens Point", NULL, 1, 0, 1, NULL, "44.5229223", "-89.574111"),
("Appleton", "Appleton", "Appleton", NULL, 1, 0, 1, NULL, "44.2613967", "-88.4069744"),
("Sheboygan", "Sheboygan", "Sheboygan", NULL, 1, 0, 1, NULL, "43.7508284", "-87.71453"),
("Green Bay", "Green Bay", "Green Bay", NULL, 1, 0, 1, NULL, "44.5126379", "-88.0125794"),
("Kalamazoo", "Kalamazoo", "Kalamazoo", NULL, 1, 0, 1, NULL, "42.291707", "-85.5872286"),
("Battle Creek", "Battle Creek", "Battle Creek", NULL, 1, 0, 1, NULL, "42.3192548", "-85.1824269"),
("Lansing", "Lansing", "Lansing", NULL, 1, 0, 1, NULL, "42.7337712", "-84.5553805"),
("Wyoming", "Wyoming", "Wyoming", NULL, 1, 0, 1, NULL, "42.9132581", "-85.7057035"),
("Grand Rapids", "Grand Rapids", "Grand Rapids", NULL, 1, 0, 1, NULL, "42.9632425", "-85.6678639"),
("Traverse City", "Traverse City", "Traverse City", NULL, 1, 0, 1, NULL, "44.7606441", "-85.6165301"),
("Dayton", "Dayton", "Dayton", NULL, 1, 0, 1, NULL, "39.7589478", "-84.1916069"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "39.9234046", "-83.810138"),
("Columbus", "Columbus", "Columbus", NULL, 1, 0, 1, NULL, "39.9622601", "-83.0007065"),
("Delaware", "Delaware", "Delaware", NULL, 1, 0, 1, NULL, "40.2986724", "-83.067965"),
("Mansfield", "Mansfield", "Mansfield", NULL, 1, 0, 1, NULL, "40.75839", "-82.5154471"),
("Findlay", "Findlay", "Findlay", NULL, 1, 0, 1, NULL, "41.0413873", "-83.6503982"),
("Toledo", "Toledo", "Toledo", NULL, 1, 0, 1, NULL, "41.6529143", "-83.5378173"),
("Sandusky", "Sandusky", "Sandusky", NULL, 1, 0, 1, NULL, "41.4561002", "-82.7115813"),
("Cleveland", "Cleveland", "Cleveland", NULL, 1, 0, 1, NULL, "41.4996574", "-81.6936772"),
("Pittsburgh", "Pittsburgh", "Pittsburgh", NULL, 1, 0, 1, NULL, "40.4416941", "-79.9900861"),
("Akron", "Akron", "Akron", NULL, 1, 0, 1, NULL, "41.083064", "-81.518485"),
("Canton", "Canton", "Canton", NULL, 1, 0, 1, NULL, "40.7985464", "-81.3749508"),
("Youngstown", "Youngstown", "Youngstown", NULL, 1, 0, 1, NULL, "41.1035786", "-80.6520161"),
("Niles", "Niles", "Niles", NULL, 1, 0, 1, NULL, "41.1828212", "-80.7651702"),
("Warren", "Warren", "Warren", NULL, 1, 0, 1, NULL, "41.2367955", "-80.8190423"),
("Ashtabula", "Ashtabula", "Ashtabula", NULL, 1, 0, 1, NULL, "41.865054", "-80.789809"),
("Erie", "Erie", "Erie", NULL, 1, 0, 1, NULL, "42.1294712", "-80.0852695"),
("Meadville", "Meadville", "Meadville", NULL, 1, 0, 1, NULL, "41.641445", "-80.151449"),
("Jamestown", "Jamestown", "Jamestown", NULL, 1, 0, 1, NULL, "42.0965167", "-79.2380322"),
("Ann Arbor", "Ann Arbor", "Ann Arbor", NULL, 1, 0, 1, NULL, "42.2681569", "-83.7312291"),
("Ypsilanti", "Ypsilanti", "Ypsilanti", NULL, 1, 0, 1, NULL, "42.2410562", "-83.613055"),
("Novi", "Novi", "Novi", NULL, 1, 0, 1, NULL, "42.48059", "-83.4754913"),
("Dearborn", "Dearborn", "Dearborn", NULL, 1, 0, 1, NULL, "42.3222599", "-83.1763145"),
("Detroit", "Detroit", "Detroit", NULL, 1, 0, 1, NULL, "42.3315509", "-83.0466403"),
("Warren", "Warren", "Warren", NULL, 1, 0, 1, NULL, "42.4932575", "-83.0062746"),
("Sterling Heights", "Sterling Heights", "Sterling Heights", NULL, 1, 0, 1, NULL, "42.5803122", "-83.0302033"),
("City of Saginaw", "City of Saginaw", "City of Saginaw", NULL, 1, 0, 1, NULL, "43.4200387", "-83.9490365"),
("Port Huron", "Port Huron", "Port Huron", NULL, 1, 0, 1, NULL, "42.9760854", "-82.4333742"),
("City of Dunkirk", "City of Dunkirk", "City of Dunkirk", NULL, 1, 0, 1, NULL, "42.479502", "-79.333932"),
("Buffalo", "Buffalo", "Buffalo", NULL, 1, 0, 1, NULL, "42.8867166", "-78.8783922"),
("City of North Tonawanda", "City of North Tonawanda", "City of North Tonawanda", NULL, 1, 0, 1, NULL, "43.0407742", "-78.8660527"),
("City of Tonawanda", "City of Tonawanda", "City of Tonawanda", NULL, 1, 0, 1, NULL, "43.020679", "-78.878383"),
("City of Niagara Falls", "City of Niagara Falls", "City of Niagara Falls", NULL, 1, 0, 1, NULL, "43.08436", "-79.0614686"),
("Wilmington", "Wilmington", "Wilmington", NULL, 1, 0, 1, NULL, "34.2257282", "-77.9447107"),
("Jacksonville", "Jacksonville", "Jacksonville", NULL, 1, 0, 1, NULL, "34.7494749", "-77.4208221"),
("Raleigh", "Raleigh", "Raleigh", NULL, 1, 0, 1, NULL, "35.7803977", "-78.6390989"),
("Richmond", "Richmond", "Richmond", NULL, 1, 0, 1, NULL, "37.5385087", "-77.43428"),
("Suffolk", "Suffolk", "Suffolk", NULL, 1, 0, 1, NULL, "36.7282096", "-76.5835703"),
("Chesapeake", "Chesapeake", "Chesapeake", NULL, 1, 0, 1, NULL, "36.7183708", "-76.2466798"),
("Virginia Beach", "Virginia Beach", "Virginia Beach", NULL, 1, 0, 1, NULL, "36.8529841", "-75.9774183"),
("Norfolk", "Norfolk", "Norfolk", NULL, 1, 0, 1, NULL, "36.8448348", "-76.2863999"),
("Hampton", "Hampton", "Hampton", NULL, 1, 0, 1, NULL, "37.0300969", "-76.3452057"),
("Charlottesville", "Charlottesville", "Charlottesville", NULL, 1, 0, 1, NULL, "38.029306", "-78.4766781"),
("Fredericksburg", "Fredericksburg", "Fredericksburg", NULL, 1, 0, 1, NULL, "38.3031837", "-77.4605399"),
("Winchester", "Winchester", "Winchester", NULL, 1, 0, 1, NULL, "39.1852184", "-78.1652404"),
("Leesburg", "Leesburg", "Leesburg", NULL, 1, 0, 1, NULL, "39.1154506", "-77.5645607"),
("Fairfax", "Fairfax", "Fairfax", NULL, 1, 0, 1, NULL, "38.8462236", "-77.3063733"),
("Alexandria", "Alexandria", "Alexandria", NULL, 1, 0, 1, NULL, "38.8051095", "-77.0470229"),
("Washington", "Washington", "Washington", NULL, 1, 0, 1, NULL, "38.8950368", "-77.0365427"),
("Bowie", "Bowie", "Bowie", NULL, 1, 0, 1, NULL, "38.9424464", "-76.7301718"),
("Laurel", "Laurel", "Laurel", NULL, 1, 0, 1, NULL, "39.0984317", "-76.8485094"),
("Rockville", "Rockville", "Rockville", NULL, 1, 0, 1, NULL, "39.0817985", "-77.1516844"),
("Salisbury", "Salisbury", "Salisbury", NULL, 1, 0, 1, NULL, "38.366027", "-75.6009964"),
("Frederick", "Frederick", "Frederick", NULL, 1, 0, 1, NULL, "39.415779", "-77.4127562"),
("Hagerstown", "Hagerstown", "Hagerstown", NULL, 1, 0, 1, NULL, "39.6430455", "-77.7191081"),
("Altoona", "Altoona", "Altoona", NULL, 1, 0, 1, NULL, "40.518681", "-78.394736"),
("York", "York", "York", NULL, 1, 0, 1, NULL, "39.9624624", "-76.727707"),
("Lancaster", "Lancaster", "Lancaster", NULL, 1, 0, 1, NULL, "40.03813", "-76.3056686"),
("Harrisburg", "Harrisburg", "Harrisburg", NULL, 1, 0, 1, NULL, "40.2663107", "-76.8861122"),
("Lebanon", "Lebanon", "Lebanon", NULL, 1, 0, 1, NULL, "40.3429683", "-76.4233816"),
("State College", "State College", "State College", NULL, 1, 0, 1, NULL, "40.7944504", "-77.8616386"),
("City of Olean", "City of Olean", "City of Olean", NULL, 1, 0, 1, NULL, "42.0775022", "-78.4298248"),
("Williamsport", "Williamsport", "Williamsport", NULL, 1, 0, 1, NULL, "41.2493292", "-77.0027671"),
("Hazleton", "Hazleton", "Hazleton", NULL, 1, 0, 1, NULL, "40.9646867", "-75.9852789"),
("Village of Horseheads", "Village of Horseheads", "Village of Horseheads", NULL, 1, 0, 1, NULL, "42.1669832", "-76.8202973"),
("Camden", "Camden", "Camden", NULL, 1, 0, 1, NULL, "39.9448402", "-75.1198911"),
("Philadelphia", "Philadelphia", "Philadelphia", NULL, 1, 0, 1, NULL, "39.9527237", "-75.1635262"),
("Reading", "Reading", "Reading", NULL, 1, 0, 1, NULL, "40.335345", "-75.9279495"),
("Bethlehem", "Bethlehem", "Bethlehem", NULL, 1, 0, 1, NULL, "40.6178915", "-75.3786521"),
("Allentown", "Allentown", "Allentown", NULL, 1, 0, 1, NULL, "40.6022059", "-75.4712794"),
("Easton", "Easton", "Easton", NULL, 1, 0, 1, NULL, "40.6916081", "-75.2099866"),
("Trenton", "Trenton", "Trenton", NULL, 1, 0, 1, NULL, "40.2205944", "-74.7597219"),
("Atlantic City", "Atlantic City", "Atlantic City", NULL, 1, 0, 1, NULL, "39.3642852", "-74.4229351"),
("Long Branch", "Long Branch", "Long Branch", NULL, 1, 0, 1, NULL, "40.3042778", "-73.9923596"),
("New Brunswick", "New Brunswick", "New Brunswick", NULL, 1, 0, 1, NULL, "40.4862174", "-74.4518173"),
("Elizabeth", "Elizabeth", "Elizabeth", NULL, 1, 0, 1, NULL, "40.6639916", "-74.2107006"),
("Newark", "Newark", "Newark", NULL, 1, 0, 1, NULL, "40.735657", "-74.1723667"),
("Jersey City", "Jersey City", "Jersey City", NULL, 1, 0, 1, NULL, "40.7215682", "-74.047455"),
("City of New York", "City of New York", "New York", NULL, 1, 0, 1, NULL, "40.7127281", "-74.0060152"),
("Village of Hempstead", "Village of Hempstead", "Village of Hempstead", NULL, 1, 0, 1, NULL, "40.7092836", "-73.6230362"),
("Wilkes-Barre", "Wilkes-Barre", "Wilkes-Barre", NULL, 1, 0, 1, NULL, "41.2464824", "-75.8817316"),
("Scranton", "Scranton", "Scranton", NULL, 1, 0, 1, NULL, "41.4086874", "-75.6621294"),
("City of Binghamton", "City of Binghamton", "City of Binghamton", NULL, 1, 0, 1, NULL, "42.098698", "-75.9125187"),
("Paterson", "Paterson", "Paterson", NULL, 1, 0, 1, NULL, "40.9167654", "-74.171811"),
("City of Yonkers", "City of Yonkers", "City of Yonkers", NULL, 1, 0, 1, NULL, "40.9312099", "-73.8987469"),
("City of Mount Vernon", "City of Mount Vernon", "City of Mount Vernon", NULL, 1, 0, 1, NULL, "40.9125085", "-73.8386504"),
("City of New Rochelle", "City of New Rochelle", "City of New Rochelle", NULL, 1, 0, 1, NULL, "40.9115386", "-73.7826363"),
("City of White Plains", "City of White Plains", "City of White Plains", NULL, 1, 0, 1, NULL, "41.0339862", "-73.7629097"),
("Stamford", "Stamford", "Stamford", NULL, 1, 0, 1, NULL, "41.0534302", "-73.5387341"),
("Stamford", "Stamford", "Stamford", NULL, 1, 0, 1, NULL, "41.0534302", "-73.5387341"),
("Norwalk", "Norwalk", "Norwalk", NULL, 1, 0, 1, NULL, "41.1175966", "-73.4078968"),
("Norwalk", "Norwalk", "Norwalk", NULL, 1, 0, 1, NULL, "41.1175966", "-73.4078968"),
("Bridgeport", "Bridgeport", "Bridgeport", NULL, 1, 0, 1, NULL, "41.1670412", "-73.2048348"),
("Danbury", "Danbury", "Danbury", NULL, 1, 0, 1, NULL, "41.394817", "-73.4540111"),
("Bridgeport", "Bridgeport", "Bridgeport", NULL, 1, 0, 1, NULL, "41.1670412", "-73.2048348"),
("Danbury", "Danbury", "Danbury", NULL, 1, 0, 1, NULL, "41.394817", "-73.4540111"),
("Torrington", "Torrington", "Torrington", NULL, 1, 0, 1, NULL, "41.8006523", "-73.1212214"),
("Torrington", "Torrington", "Torrington", NULL, 1, 0, 1, NULL, "41.8006523", "-73.1212214"),
("City of Lockport", "City of Lockport", "City of Lockport", NULL, 1, 0, 1, NULL, "43.1687104", "-78.696567"),
("City of Batavia", "City of Batavia", "City of Batavia", NULL, 1, 0, 1, NULL, "42.9980144", "-78.1875515"),
("City of Rochester", "City of Rochester", "City of Rochester", NULL, 1, 0, 1, NULL, "43.157285", "-77.615214"),
("Town of Canandaigua", "Town of Canandaigua", "Town of Canandaigua", NULL, 1, 0, 1, NULL, "42.850682", "-77.319145424883"),
("City of Canandaigua", "City of Canandaigua", "City of Canandaigua", NULL, 1, 0, 1, NULL, "42.8858579", "-77.2799761"),
("City of Ithaca", "City of Ithaca", "City of Ithaca", NULL, 1, 0, 1, NULL, "42.4396039", "-76.4968019"),
("City of Syracuse", "City of Syracuse", "City of Syracuse", NULL, 1, 0, 1, NULL, "43.0481221", "-76.1474244"),
("Town of Clay", "Town of Clay", "Town of Clay", NULL, 1, 0, 1, NULL, "43.186621", "-76.2065431"),
("City of Utica", "City of Utica", "City of Utica", NULL, 1, 0, 1, NULL, "43.1009031", "-75.2326641"),
("City of Schenectady", "City of Schenectady", "City of Schenectady", NULL, 1, 0, 1, NULL, "42.8142432", "-73.9395687"),
("City of Hudson", "City of Hudson", "City of Hudson", NULL, 1, 0, 1, NULL, "42.2528649", "-73.790959"),
("City of Albany", "City of Albany", "City of Albany", NULL, 1, 0, 1, NULL, "42.6511674", "-73.754968"),
("Pittsfield", "Pittsfield", "Pittsfield", NULL, 1, 0, 1, NULL, "42.451302", "-73.260018"),
("City of Troy", "City of Troy", "City of Troy", NULL, 1, 0, 1, NULL, "42.7284117", "-73.6917878"),
("City of Glens Falls", "City of Glens Falls", "City of Glens Falls", NULL, 1, 0, 1, NULL, "43.309941", "-73.644447"),
("City of Watertown", "City of Watertown", "City of Watertown", NULL, 1, 0, 1, NULL, "43.9747838", "-75.9107565"),
("City of Ogdensburg", "City of Ogdensburg", "City of Ogdensburg", NULL, 1, 0, 1, NULL, "44.694285", "-75.486374"),
("City of Plattsburgh", "City of Plattsburgh", "City of Plattsburgh", NULL, 1, 0, 1, NULL, "44.69282", "-73.45562"),
("Burlington", "Burlington", "Burlington", NULL, 1, 0, 1, NULL, "44.4761601", "-73.212906"),
("New Haven", "New Haven", "New Haven", NULL, 1, 0, 1, NULL, "41.3082138", "-72.9250518"),
("New Haven", "New Haven", "New Haven", NULL, 1, 0, 1, NULL, "41.3082138", "-72.9250518"),
("Ansonia", "Ansonia", "Ansonia", NULL, 1, 0, 1, NULL, "41.3429922", "-73.0787468"),
("Ansonia", "Ansonia", "Ansonia", NULL, 1, 0, 1, NULL, "41.3429922", "-73.0787468"),
("New London", "New London", "New London", NULL, 1, 0, 1, NULL, "41.3556187", "-72.0997804"),
("New London", "New London", "New London", NULL, 1, 0, 1, NULL, "41.3556187", "-72.0997804"),
("Waterbury", "Waterbury", "Waterbury", NULL, 1, 0, 1, NULL, "41.5538091", "-73.0438362"),
("Meriden", "Meriden", "Meriden", NULL, 1, 0, 1, NULL, "41.5381535", "-72.8070435"),
("Meriden", "Meriden", "Meriden", NULL, 1, 0, 1, NULL, "41.5381535", "-72.8070435"),
("Bristol", "Bristol", "Bristol", NULL, 1, 0, 1, NULL, "41.6735209", "-72.9464859"),
("Bristol", "Bristol", "Bristol", NULL, 1, 0, 1, NULL, "41.6735209", "-72.9464859"),
("New Britain", "New Britain", "New Britain", NULL, 1, 0, 1, NULL, "41.6612104", "-72.7795419"),
("New Britain", "New Britain", "New Britain", NULL, 1, 0, 1, NULL, "41.6612104", "-72.7795419"),
("Middletown", "Middletown", "Middletown", NULL, 1, 0, 1, NULL, "41.5623178", "-72.6509061"),
("Middletown", "Middletown", "Middletown", NULL, 1, 0, 1, NULL, "41.5623178", "-72.6509061"),
("Hartford", "Hartford", "Hartford", NULL, 1, 0, 1, NULL, "41.764582", "-72.6908547"),
("Hartford", "Hartford", "Hartford", NULL, 1, 0, 1, NULL, "41.764582", "-72.6908547"),
("Westfield", "Westfield", "Westfield", NULL, 1, 0, 1, NULL, "42.1205411", "-72.7489158"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "42.1018764", "-72.5886727"),
("Chicopee", "Chicopee", "Chicopee", NULL, 1, 0, 1, NULL, "42.1487691", "-72.6071119"),
("Norwich", "Norwich", "Norwich", NULL, 1, 0, 1, NULL, "41.5243537", "-72.0759008"),
("Norwich", "Norwich", "Norwich", NULL, 1, 0, 1, NULL, "41.5243537", "-72.0759008"),
("Providence", "Providence", "Providence", NULL, 1, 0, 1, NULL, "41.8239891", "-71.4128343"),
("Newport", "Newport", "Newport", NULL, 1, 0, 1, NULL, "41.4899827", "-71.3137707"),
("Woonsocket", "Woonsocket", "Woonsocket", NULL, 1, 0, 1, NULL, "42.0028761", "-71.5147839"),
("Holyoke", "Holyoke", "Holyoke", NULL, 1, 0, 1, NULL, "42.2071434", "-72.60765"),
("Easthampton", "Easthampton", "Easthampton", NULL, 1, 0, 1, NULL, "42.2708804", "-72.6719579"),
("Northampton", "Northampton", "Northampton", NULL, 1, 0, 1, NULL, "42.3178989", "-72.6311006"),
("Greenfield", "Greenfield", "Greenfield", NULL, 1, 0, 1, NULL, "42.5876342", "-72.6002068"),
("Worcester", "Worcester", "Worcester", NULL, 1, 0, 1, NULL, "42.2625621", "-71.8018877"),
("Leominster", "Leominster", "Leominster", NULL, 1, 0, 1, NULL, "42.5267443", "-71.7614891"),
("Gardner", "Gardner", "Gardner", NULL, 1, 0, 1, NULL, "42.5763523", "-71.9952737"),
("Fitchburg", "Fitchburg", "Fitchburg", NULL, 1, 0, 1, NULL, "42.5854371", "-71.8046023"),
("Marlborough", "Marlborough", "Marlborough", NULL, 1, 0, 1, NULL, "42.3459271", "-71.5522874"),
("Framingham", "Framingham", "Framingham", NULL, 1, 0, 1, NULL, "42.2773177", "-71.4165905"),
("Newton", "Newton", "Newton", NULL, 1, 0, 1, NULL, "42.3370414", "-71.2092214"),
("Waltham", "Waltham", "Waltham", NULL, 1, 0, 1, NULL, "42.3756401", "-71.2358004"),
("Cambridge", "Cambridge", "Cambridge", NULL, 1, 0, 1, NULL, "42.3655767", "-71.1040018"),
("Somerville", "Somerville", "Somerville", NULL, 1, 0, 1, NULL, "42.3875968", "-71.0994968"),
("Woburn", "Woburn", "Woburn", NULL, 1, 0, 1, NULL, "42.4792618", "-71.1522766"),
("Nashua", "Nashua", "Nashua", NULL, 1, 0, 1, NULL, "42.7656251", "-71.4677032"),
("Lowell", "Lowell", "Lowell", NULL, 1, 0, 1, NULL, "42.6414437", "-71.3085329"),
("Boston", "Boston", "Boston", NULL, 1, 0, 1, NULL, "42.3554334", "-71.060511"),
("Manchester", "Manchester", "Manchester", NULL, 1, 0, 1, NULL, "42.9956397", "-71.4547891"),
("Concord", "Concord", "Concord", NULL, 1, 0, 1, NULL, "43.207178", "-71.537476"),
("Franklin", "Franklin", "Franklin", NULL, 1, 0, 1, NULL, "43.4442432", "-71.6472988"),
("Dover", "Dover", "Dover", NULL, 1, 0, 1, NULL, "43.1981117", "-70.8739761"),
("Rochester", "Rochester", "Rochester", NULL, 1, 0, 1, NULL, "43.3050631", "-70.9753629"),
("Sanford", "Sanford", "Sanford", NULL, 1, 0, 1, NULL, "43.438878", "-70.7739832"),
("Biddeford", "Biddeford", "Biddeford", NULL, 1, 0, 1, NULL, "43.4925843", "-70.4533844"),
("Saco", "Saco", "Saco", NULL, 1, 0, 1, NULL, "43.5009176", "-70.4428286"),
("Barre City", "Barre City", "Barre City", NULL, 1, 0, 1, NULL, "44.1969042", "-72.5007458"),
("Montpelier", "Montpelier", "Montpelier", NULL, 1, 0, 1, NULL, "44.2602164", "-72.5751208"),
("Essex Junction", "Essex Junction", "Essex Junction", NULL, 1, 0, 1, NULL, "44.4906817", "-73.11136"),
("Lebanon", "Lebanon", "Lebanon", NULL, 1, 0, 1, NULL, "43.643032", "-72.251587"),
("Westbrook", "Westbrook", "Westbrook", NULL, 1, 0, 1, NULL, "43.6763036", "-70.3663874"),
("South Portland", "South Portland", "South Portland", NULL, 1, 0, 1, NULL, "43.6414716", "-70.2408811"),
("Portland", "Portland", "Portland", NULL, 1, 0, 1, NULL, "43.6592687", "-70.2572642"),
("Auburn", "Auburn", "Auburn", NULL, 1, 0, 1, NULL, "44.0972546", "-70.2254085"),
("Lewiston", "Lewiston", "Lewiston", NULL, 1, 0, 1, NULL, "44.0951078", "-70.2155454"),
("Augusta", "Augusta", "Augusta", NULL, 1, 0, 1, NULL, "44.3155295", "-69.7700241"),
("Waterville", "Waterville", "Waterville", NULL, 1, 0, 1, NULL, "44.5520105", "-69.6317121"),
("Bangor", "Bangor", "Bangor", NULL, 1, 0, 1, NULL, "44.8036159", "-68.7702127"),
("Marquette", "Marquette", "Marquette", NULL, 1, 0, 1, NULL, "46.5434914", "-87.396433"),
("Presque Isle", "Presque Isle", "Presque Isle", NULL, 1, 0, 1, NULL, "46.6832082", "-68.0141431"),
("Caribou", "Caribou", "Caribou", NULL, 1, 0, 1, NULL, "46.8605567", "-68.0119677"),
("Calais", "Calais", "Calais", NULL, 1, 0, 1, NULL, "45.1883938", "-67.2769294"),
("Derby", "Derby", "Derby", NULL, 1, 0, 1, NULL, "41.33028", "-73.0772546"),
("Derby", "Derby", "Derby", NULL, 1, 0, 1, NULL, "41.320166", "-73.040161"),
("Bridgeport", "Bridgeport", "Bridgeport", NULL, 1, 0, 1, NULL, "41.2281733", "-73.1995528"),
("Kapolei", "Kapolei", "Kapolei", NULL, 1, 0, 1, NULL, "21.3340079", "-158.077849"),
("Honolulu", "Honolulu", "Honolulu", NULL, 1, 0, 1, NULL, "21.304547", "-157.855676"),
("Waipahu", "Waipahu", "Waipahu", NULL, 1, 0, 1, NULL, "21.3866667", "-158.009166"),
("Pearl City", "Pearl City", "Pearl City", NULL, 1, 0, 1, NULL, "21.4001231", "-157.969428"),
("Aiea", "Aiea", "Aiea", NULL, 1, 0, 1, NULL, "21.3822222", "-157.9336111"),
("Kāneʻohe", "Kāneʻohe", "Kaneohe", NULL, 1, 0, 1, NULL, "21.418555", "-157.804184"),
("Kailua", "Kailua", "Kailua", NULL, 1, 0, 1, NULL, "21.393623", "-157.743759"),
("Mililani", "Mililani", "Mililani", NULL, 1, 0, 1, NULL, "21.4508308", "-158.0095783"),
("Hilo", "Hilo", "Hilo", NULL, 1, 0, 1, NULL, "19.7073734", "-155.08158"),
("Chula Vista", "Chula Vista", "Chula Vista", NULL, 1, 0, 1, NULL, "32.6400541", "-117.0841955"),
("San Diego", "San Diego", "San Diego", NULL, 1, 0, 1, NULL, "32.7174202", "-117.1627728"),
("El Cajon", "El Cajon", "El Cajon", NULL, 1, 0, 1, NULL, "32.7947731", "-116.962526"),
("Poway", "Poway", "Poway", NULL, 1, 0, 1, NULL, "32.9628234", "-117.035864"),
("Laguna Beach", "Laguna Beach", "Laguna Beach", NULL, 1, 0, 1, NULL, "33.5426975", "-117.785366"),
("Huntington Beach", "Huntington Beach", "Huntington Beach", NULL, 1, 0, 1, NULL, "33.6783336", "-118.0000166"),
("Costa Mesa", "Costa Mesa", "Costa Mesa", NULL, 1, 0, 1, NULL, "33.6633386", "-117.903317"),
("Irvine", "Irvine", "Irvine", NULL, 1, 0, 1, NULL, "33.6856969", "-117.8259819"),
("Santa Ana", "Santa Ana", "Santa Ana", NULL, 1, 0, 1, NULL, "33.7494951", "-117.8732213"),
("San Clemente", "San Clemente", "San Clemente", NULL, 1, 0, 1, NULL, "33.4270275", "-117.6124179"),
("Mission Viejo", "Mission Viejo", "Mission Viejo", NULL, 1, 0, 1, NULL, "33.5965685", "-117.659405"),
("Carlsbad", "Carlsbad", "Carlsbad", NULL, 1, 0, 1, NULL, "33.1580933", "-117.3505966"),
("Oceanside", "Oceanside", "Oceanside", NULL, 1, 0, 1, NULL, "33.1958696", "-117.3794834"),
("Escondido", "Escondido", "Escondido", NULL, 1, 0, 1, NULL, "33.1216751", "-117.0814849"),
("Vista", "Vista", "Vista", NULL, 1, 0, 1, NULL, "33.2000368", "-117.2425355"),
("Temecula", "Temecula", "Temecula", NULL, 1, 0, 1, NULL, "33.4946353", "-117.1473661"),
("Murrieta", "Murrieta", "Murrieta", NULL, 1, 0, 1, NULL, "33.560832", "-117.210656"),
("El Centro", "El Centro", "El Centro", NULL, 1, 0, 1, NULL, "32.792", "-115.563051"),
("Indio", "Indio", "Indio", NULL, 1, 0, 1, NULL, "33.7192808", "-116.2188054"),
("Yuma", "Yuma", "Yuma", NULL, 1, 0, 1, NULL, "32.6926543", "-114.6275386"),
("Eureka", "Eureka", "Eureka", NULL, 1, 0, 1, NULL, "40.7906871", "-124.1673746"),
("Santa Maria", "Santa Maria", "Santa Maria", NULL, 1, 0, 1, NULL, "34.9531295", "-120.435857"),
("Oxnard", "Oxnard", "Oxnard", NULL, 1, 0, 1, NULL, "34.1976308", "-119.1803818"),
("Ventura", "Ventura", "Ventura", NULL, 1, 0, 1, NULL, "34.2783355", "-119.293174"),
("Thousand Oaks", "Thousand Oaks", "Thousand Oaks", NULL, 1, 0, 1, NULL, "34.1705609", "-118.8375937"),
("Torrance", "Torrance", "Torrance", NULL, 1, 0, 1, NULL, "33.8358492", "-118.3406288"),
("Carson", "Carson", "Carson", NULL, 1, 0, 1, NULL, "33.8322043", "-118.2517547"),
("Long Beach", "Long Beach", "Long Beach", NULL, 1, 0, 1, NULL, "33.7690164", "-118.191604"),
("Inglewood", "Inglewood", "Inglewood", NULL, 1, 0, 1, NULL, "33.9562003", "-118.353132"),
("South Gate", "South Gate", "South Gate", NULL, 1, 0, 1, NULL, "33.9463456", "-118.200981"),
("Downey", "Downey", "Downey", NULL, 1, 0, 1, NULL, "33.9404441", "-118.1292846"),
("Los Angeles", "Los Angeles", "Los Angeles", NULL, 1, 0, 1, NULL, "34.0536909", "-118.242766"),
("Simi Valley", "Simi Valley", "Simi Valley", NULL, 1, 0, 1, NULL, "34.2677404", "-118.7538071"),
("Santa Clarita", "Santa Clarita", "Santa Clarita", NULL, 1, 0, 1, NULL, "34.4127963", "-118.5538088"),
("Burbank", "Burbank", "Burbank", NULL, 1, 0, 1, NULL, "34.1812089", "-118.307201"),
("Glendale", "Glendale", "Glendale", NULL, 1, 0, 1, NULL, "34.1469416", "-118.2478471"),
("Pasadena", "Pasadena", "Pasadena", NULL, 1, 0, 1, NULL, "34.1476452", "-118.1444779"),
("Lancaster", "Lancaster", "Lancaster", NULL, 1, 0, 1, NULL, "34.6981064", "-118.1366153"),
("Hanford", "Hanford", "Hanford", NULL, 1, 0, 1, NULL, "36.3274502", "-119.6456844"),
("Bakersfield", "Bakersfield", "Bakersfield", NULL, 1, 0, 1, NULL, "35.3738712", "-119.0194639"),
("Porterville", "Porterville", "Porterville", NULL, 1, 0, 1, NULL, "36.06523", "-119.0167679"),
("Visalia", "Visalia", "Visalia", NULL, 1, 0, 1, NULL, "36.3302284", "-119.292058"),
("Daly City", "Daly City", "Daly City", NULL, 1, 0, 1, NULL, "37.6904826", "-122.47267"),
("San Francisco", "San Francisco", "San Francisco", NULL, 1, 0, 1, NULL, "37.7790262", "-122.419906"),
("South San Francisco", "South San Francisco", "South San Francisco", NULL, 1, 0, 1, NULL, "37.6535403", "-122.4168664"),
("Richmond", "Richmond", "Richmond", NULL, 1, 0, 1, NULL, "37.9357576", "-122.347748"),
("Monterey", "Monterey", "Monterey", NULL, 1, 0, 1, NULL, "36.600256", "-121.8946388"),
("Salinas", "Salinas", "Salinas", NULL, 1, 0, 1, NULL, "36.6744117", "-121.655037"),
("Santa Cruz", "Santa Cruz", "Santa Cruz", NULL, 1, 0, 1, NULL, "36.9743626", "-122.0294673"),
("Gilroy", "Gilroy", "Gilroy", NULL, 1, 0, 1, NULL, "37.0065078", "-121.5631723"),
("Cupertino", "Cupertino", "Cupertino", NULL, 1, 0, 1, NULL, "37.3228934", "-122.0322895"),
("Mountain View", "Mountain View", "Mountain View", NULL, 1, 0, 1, NULL, "37.3893889", "-122.0832101"),
("Sunnyvale", "Sunnyvale", "Sunnyvale", NULL, 1, 0, 1, NULL, "37.3688301", "-122.036349"),
("San Mateo", "San Mateo", "San Mateo", NULL, 1, 0, 1, NULL, "37.5629997", "-122.3253265"),
("Palo Alto", "Palo Alto", "Palo Alto", NULL, 1, 0, 1, NULL, "37.4443293", "-122.1598465"),
("Redwood City", "Redwood City", "Redwood City", NULL, 1, 0, 1, NULL, "37.4863239", "-122.232523"),
("Santa Clara", "Santa Clara", "Santa Clara", NULL, 1, 0, 1, NULL, "37.3541132", "-121.955174"),
("San Jose", "San Jose", "San Jose", NULL, 1, 0, 1, NULL, "37.3361663", "-121.890591"),
("Milpitas", "Milpitas", "Milpitas", NULL, 1, 0, 1, NULL, "37.4332273", "-121.8989248"),
("Fremont", "Fremont", "Fremont", NULL, 1, 0, 1, NULL, "37.5482697", "-121.988571"),
("Hayward", "Hayward", "Hayward", NULL, 1, 0, 1, NULL, "37.6688205", "-122.080796"),
("Berkeley", "Berkeley", "Berkeley", NULL, 1, 0, 1, NULL, "37.8708393", "-122.272863"),
("Oakland", "Oakland", "Oakland", NULL, 1, 0, 1, NULL, "37.8044557", "-122.271356"),
("Tracy", "Tracy", "Tracy", NULL, 1, 0, 1, NULL, "37.7385507", "-121.4201395"),
("Stockton", "Stockton", "Stockton", NULL, 1, 0, 1, NULL, "37.9577016", "-121.2907796"),
("Modesto", "Modesto", "Modesto", NULL, 1, 0, 1, NULL, "37.6390972", "-120.9968782"),
("Manteca", "Manteca", "Manteca", NULL, 1, 0, 1, NULL, "37.7986184", "-121.2117148"),
("San Rafael", "San Rafael", "San Rafael", NULL, 1, 0, 1, NULL, "37.9747795", "-122.5316686"),
("Petaluma", "Petaluma", "Petaluma", NULL, 1, 0, 1, NULL, "38.2325829", "-122.636465"),
("Santa Rosa", "Santa Rosa", "Santa Rosa", NULL, 1, 0, 1, NULL, "38.4404925", "-122.7141049"),
("Vallejo", "Vallejo", "Vallejo", NULL, 1, 0, 1, NULL, "38.1040864", "-122.2566367"),
("Concord", "Concord", "Concord", NULL, 1, 0, 1, NULL, "37.9768525", "-122.0335624"),
("Napa", "Napa", "Napa", NULL, 1, 0, 1, NULL, "38.2971367", "-122.2855293"),
("Fairfield", "Fairfield", "Fairfield", NULL, 1, 0, 1, NULL, "38.2493581", "-122.039966"),
("Antioch", "Antioch", "Antioch", NULL, 1, 0, 1, NULL, "38.0049214", "-121.805789"),
("Vacaville", "Vacaville", "Vacaville", NULL, 1, 0, 1, NULL, "38.3565773", "-121.9877444"),
("Elk Grove", "Elk Grove", "Elk Grove", NULL, 1, 0, 1, NULL, "38.4087993", "-121.3716178"),
("Sacramento", "Sacramento", "Sacramento", NULL, 1, 0, 1, NULL, "38.5810606", "-121.493895"),
("Roseville", "Roseville", "Roseville", NULL, 1, 0, 1, NULL, "38.7521235", "-121.2880059"),
("Yuba City", "Yuba City", "Yuba City", NULL, 1, 0, 1, NULL, "39.1404477", "-121.6169108"),
("Fresno", "Fresno", "Fresno", NULL, 1, 0, 1, NULL, "36.7394421", "-119.7848307"),
("Madera", "Madera", "Madera", NULL, 1, 0, 1, NULL, "36.9622745", "-120.0594685"),
("Turlock", "Turlock", "Turlock", NULL, 1, 0, 1, NULL, "37.4946568", "-120.8465941"),
("Merced", "Merced", "Merced", NULL, 1, 0, 1, NULL, "37.3029568", "-120.4843269"),
("Carson City", "Carson City", "Carson City", NULL, 1, 0, 1, NULL, "39.1698022", "-119.7575628"),
("Norwalk", "Norwalk", "Norwalk", NULL, 1, 0, 1, NULL, "33.9092802", "-118.0849169"),
("Garden Grove", "Garden Grove", "Garden Grove", NULL, 1, 0, 1, NULL, "33.7746292", "-117.9463717"),
("Anaheim", "Anaheim", "Anaheim", NULL, 1, 0, 1, NULL, "33.8347516", "-117.911732"),
("Orange", "Orange", "Orange", NULL, 1, 0, 1, NULL, "33.7872568", "-117.850308"),
("Fullerton", "Fullerton", "Fullerton", NULL, 1, 0, 1, NULL, "33.8708215", "-117.9294165"),
("El Monte", "El Monte", "El Monte", NULL, 1, 0, 1, NULL, "34.0751571", "-118.036849"),
("West Covina", "West Covina", "West Covina", NULL, 1, 0, 1, NULL, "34.0686208", "-117.9389526"),
("Corona", "Corona", "Corona", NULL, 1, 0, 1, NULL, "33.8752945", "-117.5664449"),
("Pomona", "Pomona", "Pomona", NULL, 1, 0, 1, NULL, "34.0553813", "-117.7517496"),
("Ontario", "Ontario", "Ontario", NULL, 1, 0, 1, NULL, "34.065846", "-117.6484304"),
("Fontana", "Fontana", "Fontana", NULL, 1, 0, 1, NULL, "34.0922335", "-117.435048"),
("Rancho Cucamonga", "Rancho Cucamonga", "Rancho Cucamonga", NULL, 1, 0, 1, NULL, "34.1033192", "-117.5751735"),
("Riverside", "Riverside", "Riverside", NULL, 1, 0, 1, NULL, "33.9824949", "-117.3742389"),
("Moreno Valley", "Moreno Valley", "Moreno Valley", NULL, 1, 0, 1, NULL, "33.937517", "-117.2305944"),
("San Bernardino", "San Bernardino", "San Bernardino", NULL, 1, 0, 1, NULL, "34.1081621", "-117.28946"),
("Palmdale", "Palmdale", "Palmdale", NULL, 1, 0, 1, NULL, "34.5793131", "-118.1171108"),
("Victorville", "Victorville", "Victorville", NULL, 1, 0, 1, NULL, "34.5361067", "-117.2911565"),
("Barstow", "Barstow", "Barstow", NULL, 1, 0, 1, NULL, "34.8986215", "-117.0244313"),
("Palm Springs", "Palm Springs", "Palm Springs", NULL, 1, 0, 1, NULL, "33.8246269", "-116.540303"),
("Lake Havasu City", "Lake Havasu City", "Lake Havasu City", NULL, 1, 0, 1, NULL, "34.4838502", "-114.322449"),
("Kingman", "Kingman", "Kingman", NULL, 1, 0, 1, NULL, "35.189443", "-114.0530065"),
("Las Vegas", "Las Vegas", "Las Vegas", NULL, 1, 0, 1, NULL, "36.1672559", "-115.148516"),
("Henderson", "Henderson", "Henderson", NULL, 1, 0, 1, NULL, "36.0301134", "-114.9826194"),
("Boulder City", "Boulder City", "Boulder City", NULL, 1, 0, 1, NULL, "35.9787638", "-114.8337739"),
("St. George", "St. George", "St. George", NULL, 1, 0, 1, NULL, "37.104153", "-113.5841313"),
("Cedar City", "Cedar City", "Cedar City", NULL, 1, 0, 1, NULL, "37.6774238", "-113.061827"),
("Ely", "Ely", "Ely", NULL, 1, 0, 1, NULL, "39.2480588", "-114.891718"),
("Redding", "Redding", "Redding", NULL, 1, 0, 1, NULL, "40.5863563", "-122.391675"),
("Chico", "Chico", "Chico", NULL, 1, 0, 1, NULL, "39.7284945", "-121.8374777"),
("Reno", "Reno", "Reno", NULL, 1, 0, 1, NULL, "39.5261206", "-119.8126581"),
("Sparks", "Sparks", "Sparks", NULL, 1, 0, 1, NULL, "39.5404679", "-119.7487235"),
("Medford", "Medford", "Medford", NULL, 1, 0, 1, NULL, "42.3264181", "-122.8718605"),
("Eugene", "Eugene", "Eugene", NULL, 1, 0, 1, NULL, "44.0505054", "-123.0950506"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "44.0462362", "-123.0220289"),
("Corvallis", "Corvallis", "Corvallis", NULL, 1, 0, 1, NULL, "44.5645659", "-123.2620435"),
("Albany", "Albany", "Albany", NULL, 1, 0, 1, NULL, "44.6365071", "-123.1059324"),
("Salem", "Salem", "Salem", NULL, 1, 0, 1, NULL, "44.9391565", "-123.033121"),
("Bend", "Bend", "Bend", NULL, 1, 0, 1, NULL, "44.0581728", "-121.3153096"),
("Nampa", "Nampa", "Nampa", NULL, 1, 0, 1, NULL, "43.5737361", "-116.559631"),
("Meridian", "Meridian", "Meridian", NULL, 1, 0, 1, NULL, "43.6086295", "-116.392326"),
("Boise", "Boise", "Boise", NULL, 1, 0, 1, NULL, "43.6166163", "-116.200886"),
("Twin Falls", "Twin Falls", "Twin Falls", NULL, 1, 0, 1, NULL, "42.5704456", "-114.4602554"),
("Tucson", "Tucson", "Tucson", NULL, 1, 0, 1, NULL, "32.2228765", "-110.9748477"),
("Chandler", "Chandler", "Chandler", NULL, 1, 0, 1, NULL, "33.3062031", "-111.8411851"),
("Avondale", "Avondale", "Avondale", NULL, 1, 0, 1, NULL, "33.4355977", "-112.349602"),
("Surprise", "Surprise", "Surprise", NULL, 1, 0, 1, NULL, "33.629247", "-112.3681428"),
("Glendale", "Glendale", "Glendale", NULL, 1, 0, 1, NULL, "33.5386858", "-112.185994"),
("Peoria", "Peoria", "Peoria", NULL, 1, 0, 1, NULL, "33.5806115", "-112.237294"),
("Tempe", "Tempe", "Tempe", NULL, 1, 0, 1, NULL, "33.4255117", "-111.9400164"),
("Phoenix", "Phoenix", "Phoenix", NULL, 1, 0, 1, NULL, "33.4484367", "-112.074141"),
("Mesa", "Mesa", "Mesa", NULL, 1, 0, 1, NULL, "33.4151005", "-111.831455"),
("Scottsdale", "Scottsdale", "Scottsdale", NULL, 1, 0, 1, NULL, "33.4942189", "-111.926018"),
("Gilbert", "Gilbert", "Gilbert", NULL, 1, 0, 1, NULL, "33.3527632", "-111.789037"),
("El Paso", "El Paso", "El Paso", NULL, 1, 0, 1, NULL, "31.7550511", "-106.4882345"),
("Las Cruces", "Las Cruces", "Las Cruces", NULL, 1, 0, 1, NULL, "32.3140354", "-106.779807"),
("Alamogordo", "Alamogordo", "Alamogordo", NULL, 1, 0, 1, NULL, "32.8998822", "-105.9602081"),
("Carlsbad", "Carlsbad", "Carlsbad", NULL, 1, 0, 1, NULL, "32.4257456", "-104.237612"),
("Roswell", "Roswell", "Roswell", NULL, 1, 0, 1, NULL, "33.3943282", "-104.5229518"),
("Odessa", "Odessa", "Odessa", NULL, 1, 0, 1, NULL, "31.8457149", "-102.367687"),
("Midland", "Midland", "Midland", NULL, 1, 0, 1, NULL, "31.9973662", "-102.077948"),
("Hobbs", "Hobbs", "Hobbs", NULL, 1, 0, 1, NULL, "32.707667", "-103.1311314"),
("Lubbock", "Lubbock", "Lubbock", NULL, 1, 0, 1, NULL, "33.5855677", "-101.8470215"),
("Laredo", "Laredo", "Laredo", NULL, 1, 0, 1, NULL, "27.5030915", "-99.5075644"),
("Brownsville", "Brownsville", "Brownsville", NULL, 1, 0, 1, NULL, "25.9140277", "-97.4890879"),
("Edinburg", "Edinburg", "Edinburg", NULL, 1, 0, 1, NULL, "26.3013982", "-98.1624501"),
("Harlingen", "Harlingen", "Harlingen", NULL, 1, 0, 1, NULL, "26.1907543", "-97.6960599"),
("Corpus Christi", "Corpus Christi", "Corpus Christi", NULL, 1, 0, 1, NULL, "27.7635302", "-97.4033191"),
("Eagle Pass", "Eagle Pass", "Eagle Pass", NULL, 1, 0, 1, NULL, "28.7099337", "-100.493813"),
("Del Rio", "Del Rio", "Del Rio", NULL, 1, 0, 1, NULL, "29.3655405", "-100.894698"),
("San Antonio", "San Antonio", "San Antonio", NULL, 1, 0, 1, NULL, "29.4246002", "-98.4951405"),
("New Braunfels", "New Braunfels", "New Braunfels", NULL, 1, 0, 1, NULL, "29.7028266", "-98.1257348"),
("Austin", "Austin", "Austin", NULL, 1, 0, 1, NULL, "30.2711286", "-97.7436995"),
("Round Rock", "Round Rock", "Round Rock", NULL, 1, 0, 1, NULL, "30.5085915", "-97.6788056"),
("Sugar Land", "Sugar Land", "Sugar Land", NULL, 1, 0, 1, NULL, "29.6196787", "-95.6349463"),
("College Station", "College Station", "College Station", NULL, 1, 0, 1, NULL, "30.5955289", "-96.3071042"),
("San Angelo", "San Angelo", "San Angelo", NULL, 1, 0, 1, NULL, "31.4649685", "-100.4405094"),
("Abilene", "Abilene", "Abilene", NULL, 1, 0, 1, NULL, "32.44645", "-99.7475905"),
("Killeen", "Killeen", "Killeen", NULL, 1, 0, 1, NULL, "31.1171441", "-97.727796"),
("Waco", "Waco", "Waco", NULL, 1, 0, 1, NULL, "31.5491899", "-97.1474628"),
("Fort Worth", "Fort Worth", "Fort Worth", NULL, 1, 0, 1, NULL, "32.753177", "-97.3327459"),
("Arlington", "Arlington", "Arlington", NULL, 1, 0, 1, NULL, "32.7355816", "-97.1071186"),
("Denton", "Denton", "Denton", NULL, 1, 0, 1, NULL, "33.2150386", "-97.1330516"),
("Grand Prairie", "Grand Prairie", "Grand Prairie", NULL, 1, 0, 1, NULL, "32.7459645", "-96.9977846"),
("Irving", "Irving", "Irving", NULL, 1, 0, 1, NULL, "32.8295183", "-96.9442177"),
("Dallas", "Dallas", "Dallas", NULL, 1, 0, 1, NULL, "32.7762719", "-96.7968559"),
("Lewisville", "Lewisville", "Lewisville", NULL, 1, 0, 1, NULL, "33.046233", "-96.994174"),
("Richardson", "Richardson", "Richardson", NULL, 1, 0, 1, NULL, "32.9481789", "-96.7297206"),
("Plano", "Plano", "Plano", NULL, 1, 0, 1, NULL, "33.0136764", "-96.6925096"),
("Mesquite", "Mesquite", "Mesquite", NULL, 1, 0, 1, NULL, "32.7666103", "-96.599472"),
("Garland", "Garland", "Garland", NULL, 1, 0, 1, NULL, "32.912624", "-96.6388833"),
("Frisco", "Frisco", "Frisco", NULL, 1, 0, 1, NULL, "33.1505998", "-96.8238183"),
("McKinney", "McKinney", "McKinney", NULL, 1, 0, 1, NULL, "33.1976496", "-96.6154471"),
("Houston", "Houston", "Houston", NULL, 1, 0, 1, NULL, "29.7589382", "-95.3676974"),
("Pasadena", "Pasadena", "Pasadena", NULL, 1, 0, 1, NULL, "29.6910753", "-95.2092076"),
("The Woodlands", "The Woodlands", "The Woodlands", NULL, 1, 0, 1, NULL, "30.1734194", "-95.504686"),
("Beaumont", "Beaumont", "Beaumont", NULL, 1, 0, 1, NULL, "30.0860459", "-94.1018461"),
("Lafayette", "Lafayette", "Lafayette", NULL, 1, 0, 1, NULL, "30.2043259", "-92.0298813"),
("New Orleans", "New Orleans", "New Orleans", NULL, 1, 0, 1, NULL, "29.9759983", "-90.0782127"),
("Baton Rouge", "Baton Rouge", "Baton Rouge", NULL, 1, 0, 1, NULL, "30.4494155", "-91.1869659"),
("Shreveport", "Shreveport", "Shreveport", NULL, 1, 0, 1, NULL, "32.5135356", "-93.7477839"),
("Texarkana", "Texarkana", "Texarkana", NULL, 1, 0, 1, NULL, "33.4254259", "-94.0430937"),
("Alexandria", "Alexandria", "Alexandria", NULL, 1, 0, 1, NULL, "31.2909782", "-92.4616292"),
("Jackson", "Jackson", "Jackson", NULL, 1, 0, 1, NULL, "32.2998686", "-90.1830408"),
("Monroe", "Monroe", "Monroe", NULL, 1, 0, 1, NULL, "32.5102427", "-92.1032411"),
("Prescott", "Prescott", "Prescott", NULL, 1, 0, 1, NULL, "34.539984", "-112.468812"),
("Flagstaff", "Flagstaff", "Flagstaff", NULL, 1, 0, 1, NULL, "35.1987522", "-111.651822"),
("Gallup", "Gallup", "Gallup", NULL, 1, 0, 1, NULL, "35.5283506", "-108.743907"),
("Farmington", "Farmington", "Farmington", NULL, 1, 0, 1, NULL, "36.7291152", "-108.205445"),
("Grand Junction", "Grand Junction", "Grand Junction", NULL, 1, 0, 1, NULL, "39.063956", "-108.5507317"),
("Albuquerque", "Albuquerque", "Albuquerque", NULL, 1, 0, 1, NULL, "35.0841034", "-106.650985"),
("Rio Rancho", "Rio Rancho", "Rio Rancho", NULL, 1, 0, 1, NULL, "35.2702448", "-106.6329806"),
("Santa Fe", "Santa Fe", "Santa Fe", NULL, 1, 0, 1, NULL, "35.6876096", "-105.938456"),
("Los Alamos", "Los Alamos", "Los Alamos", NULL, 1, 0, 1, NULL, "35.88137", "-106.298959"),
("Clovis", "Clovis", "Clovis", NULL, 1, 0, 1, NULL, "34.405472", "-103.2050709"),
("Amarillo", "Amarillo", "Amarillo", NULL, 1, 0, 1, NULL, "35.2072185", "-101.833824"),
("Pueblo", "Pueblo", "Pueblo", NULL, 1, 0, 1, NULL, "38.2544472", "-104.609141"),
("Colorado Springs", "Colorado Springs", "Colorado Springs", NULL, 1, 0, 1, NULL, "38.8339578", "-104.825348"),
("Lehi", "Lehi", "Lehi", NULL, 1, 0, 1, NULL, "40.3881114", "-111.8486019"),
("Sandy", "Sandy", "Sandy", NULL, 1, 0, 1, NULL, "40.5710454", "-111.8953815"),
("West Valley City", "West Valley City", "West Valley City", NULL, 1, 0, 1, NULL, "40.6967254", "-111.986821"),
("Salt Lake City", "Salt Lake City", "Salt Lake City", NULL, 1, 0, 1, NULL, "40.7596198", "-111.886797"),
("Provo", "Provo", "Provo", NULL, 1, 0, 1, NULL, "40.2337289", "-111.6587085"),
("Ogden", "Ogden", "Ogden", NULL, 1, 0, 1, NULL, "41.2230048", "-111.9738429"),
("Evanston", "Evanston", "Evanston", NULL, 1, 0, 1, NULL, "41.2682462", "-110.963758"),
("Rock Springs", "Rock Springs", "Rock Springs", NULL, 1, 0, 1, NULL, "41.5860557", "-109.2194544"),
("Pocatello", "Pocatello", "Pocatello", NULL, 1, 0, 1, NULL, "42.8620287", "-112.450627"),
("Idaho Falls", "Idaho Falls", "Idaho Falls", NULL, 1, 0, 1, NULL, "43.4887907", "-112.03628"),
("Riverton", "Riverton", "Riverton", NULL, 1, 0, 1, NULL, "43.0247245", "-108.380727"),
("Cody", "Cody", "Cody", NULL, 1, 0, 1, NULL, "44.5263107", "-109.056392"),
("Sheridan", "Sheridan", "Sheridan", NULL, 1, 0, 1, NULL, "44.797194", "-106.956179"),
("Lakewood", "Lakewood", "Lakewood", NULL, 1, 0, 1, NULL, "39.7085736", "-105.0846694"),
("Centennial", "Centennial", "Centennial", NULL, 1, 0, 1, NULL, "39.579155", "-104.8769227"),
("Boulder", "Boulder", "Boulder", NULL, 1, 0, 1, NULL, "40.0149856", "-105.270545"),
("Denver", "Denver", "Denver", NULL, 1, 0, 1, NULL, "39.7392364", "-104.984862"),
("Westminster", "Westminster", "Westminster", NULL, 1, 0, 1, NULL, "39.8366528", "-105.0372046"),
("Thornton", "Thornton", "Thornton", NULL, 1, 0, 1, NULL, "39.8695516", "-104.985181"),
("Aurora", "Aurora", "Aurora", NULL, 1, 0, 1, NULL, "39.7405111", "-104.830994"),
("Fort Collins", "Fort Collins", "Fort Collins", NULL, 1, 0, 1, NULL, "40.5508527", "-105.0668085"),
("Greeley", "Greeley", "Greeley", NULL, 1, 0, 1, NULL, "40.4233142", "-104.7091322"),
("Laramie", "Laramie", "Laramie", NULL, 1, 0, 1, NULL, "41.311367", "-105.591101"),
("Cheyenne", "Cheyenne", "Cheyenne", NULL, 1, 0, 1, NULL, "41.139981", "-104.820246"),
("Torrington", "Torrington", "Torrington", NULL, 1, 0, 1, NULL, "42.062465", "-104.184394"),
("Scottsbluff", "Scottsbluff", "Scottsbluff", NULL, 1, 0, 1, NULL, "41.862302", "-103.6627088"),
("Casper", "Casper", "Casper", NULL, 1, 0, 1, NULL, "42.8501191", "-106.325138"),
("Gillette", "Gillette", "Gillette", NULL, 1, 0, 1, NULL, "44.290635", "-105.501876"),
("Rapid City", "Rapid City", "Rapid City", NULL, 1, 0, 1, NULL, "44.0806041", "-103.2280239"),
("Spearfish", "Spearfish", "Spearfish", NULL, 1, 0, 1, NULL, "44.490817", "-103.85937"),
("Wichita Falls", "Wichita Falls", "Wichita Falls", NULL, 1, 0, 1, NULL, "33.9004572", "-98.5020777"),
("Lawton", "Lawton", "Lawton", NULL, 1, 0, 1, NULL, "34.6086854", "-98.3903305"),
("Norman", "Norman", "Norman", NULL, 1, 0, 1, NULL, "35.2225717", "-97.4394816"),
("Oklahoma City", "Oklahoma City", "Oklahoma City", NULL, 1, 0, 1, NULL, "35.4729886", "-97.5170536"),
("Edmond", "Edmond", "Edmond", NULL, 1, 0, 1, NULL, "35.6571367", "-97.4649038"),
("Enid", "Enid", "Enid", NULL, 1, 0, 1, NULL, "36.3967623", "-97.8791341"),
("Stillwater", "Stillwater", "Stillwater", NULL, 1, 0, 1, NULL, "36.1156306", "-97.0585717"),
("Tulsa", "Tulsa", "Tulsa", NULL, 1, 0, 1, NULL, "36.1563122", "-95.9927516"),
("Dodge City", "Dodge City", "Dodge City", NULL, 1, 0, 1, NULL, "37.7527982", "-100.0170787"),
("Garden City", "Garden City", "Garden City", NULL, 1, 0, 1, NULL, "37.9716898", "-100.8726618"),
("Wichita", "Wichita", "Wichita", NULL, 1, 0, 1, NULL, "37.6922361", "-97.3375448"),
("Bartlesville", "Bartlesville", "Bartlesville", NULL, 1, 0, 1, NULL, "36.7421089", "-95.9528877"),
("Hutchinson", "Hutchinson", "Hutchinson", NULL, 1, 0, 1, NULL, "38.0608444", "-97.9297743"),
("Salina", "Salina", "Salina", NULL, 1, 0, 1, NULL, "38.8402805", "-97.6114237"),
("Emporia", "Emporia", "Emporia", NULL, 1, 0, 1, NULL, "38.4040054", "-96.181623"),
("Manhattan", "Manhattan", "Manhattan", NULL, 1, 0, 1, NULL, "39.1836082", "-96.5716694"),
("Topeka", "Topeka", "Topeka", NULL, 1, 0, 1, NULL, "39.049011", "-95.677556"),
("Hot Springs", "Hot Springs", "Hot Springs", NULL, 1, 0, 1, NULL, "34.5038393", "-93.0552437"),
("Fort Smith", "Fort Smith", "Fort Smith", NULL, 1, 0, 1, NULL, "35.3784666", "-94.3996456"),
("Fayetteville", "Fayetteville", "Fayetteville", NULL, 1, 0, 1, NULL, "36.0625843", "-94.1574328"),
("Springdale", "Springdale", "Springdale", NULL, 1, 0, 1, NULL, "36.1867442", "-94.1288142"),
("Pine Bluff", "Pine Bluff", "Pine Bluff", NULL, 1, 0, 1, NULL, "34.2157064", "-92.0140402"),
("Little Rock", "Little Rock", "Little Rock", NULL, 1, 0, 1, NULL, "34.7465071", "-92.2896267"),
("Southaven", "Southaven", "Southaven", NULL, 1, 0, 1, NULL, "34.9873822", "-90.0034862"),
("Memphis", "Memphis", "Memphis", NULL, 1, 0, 1, NULL, "35.1460249", "-90.0517638"),
("Jonesboro", "Jonesboro", "Jonesboro", NULL, 1, 0, 1, NULL, "35.8272257", "-90.6949871"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "37.1968298", "-93.2946576"),
("Lawrence", "Lawrence", "Lawrence", NULL, 1, 0, 1, NULL, "38.9719384", "-95.2359496"),
("Leavenworth", "Leavenworth", "Leavenworth", NULL, 1, 0, 1, NULL, "39.3113257", "-94.922759"),
("Olathe", "Olathe", "Olathe", NULL, 1, 0, 1, NULL, "38.8838856", "-94.81887"),
("Lenexa", "Lenexa", "Lenexa", NULL, 1, 0, 1, NULL, "38.9697458", "-94.7845837"),
("Overland Park", "Overland Park", "Overland Park", NULL, 1, 0, 1, NULL, "38.9742502", "-94.6851702"),
("Belton", "Belton", "Belton", NULL, 1, 0, 1, NULL, "38.8108097", "-94.5313502"),
("Lee's Summit", "Lee's Summit", "Lee's Summit", NULL, 1, 0, 1, NULL, "38.9107156", "-94.3821295"),
("Blue Springs", "Blue Springs", "Blue Springs", NULL, 1, 0, 1, NULL, "39.017316", "-94.282265"),
("Kansas City", "Kansas City", "Kansas City", NULL, 1, 0, 1, NULL, "39.100105", "-94.5781416"),
("Kansas City", "Kansas City", "Kansas City", NULL, 1, 0, 1, NULL, "39.1134562", "-94.626497"),
("Gladstone", "Gladstone", "Gladstone", NULL, 1, 0, 1, NULL, "39.2214765", "-94.5719748"),
("Independence", "Independence", "Independence", NULL, 1, 0, 1, NULL, "39.0924792", "-94.4137923"),
("Liberty", "Liberty", "Liberty", NULL, 1, 0, 1, NULL, "39.246479", "-94.419079"),
("Warrensburg", "Warrensburg", "Warrensburg", NULL, 1, 0, 1, NULL, "38.7624373", "-93.7409596"),
("Sedalia", "Sedalia", "Sedalia", NULL, 1, 0, 1, NULL, "38.7098314", "-93.2295515"),
("Rolla", "Rolla", "Rolla", NULL, 1, 0, 1, NULL, "37.9509324", "-91.7708076"),
("Jefferson City", "Jefferson City", "Jefferson City", NULL, 1, 0, 1, NULL, "38.577359", "-92.1724265"),
("Columbia", "Columbia", "Columbia", NULL, 1, 0, 1, NULL, "38.951883", "-92.3337366"),
("Saint Louis", "Saint Louis", "St. Louis", NULL, 1, 0, 1, NULL, "38.6280278", "-90.1910154"),
("Saint Charles", "Saint Charles", "Saint Charles", NULL, 1, 0, 1, NULL, "38.783855", "-90.481677"),
("Lexington", "Lexington", "Lexington", NULL, 1, 0, 1, NULL, "40.7788486", "-99.7414869"),
("Kearney", "Kearney", "Kearney", NULL, 1, 0, 1, NULL, "40.699478", "-99.081858"),
("North Platte", "North Platte", "North Platte", NULL, 1, 0, 1, NULL, "41.1238873", "-100.7654232"),
("Hastings", "Hastings", "Hastings", NULL, 1, 0, 1, NULL, "40.5861322", "-98.3898883"),
("Beatrice", "Beatrice", "Beatrice", NULL, 1, 0, 1, NULL, "40.266429", "-96.747369"),
("Grand Island", "Grand Island", "Grand Island", NULL, 1, 0, 1, NULL, "40.924271", "-98.338685"),
("Columbus", "Columbus", "Columbus", NULL, 1, 0, 1, NULL, "41.4292988", "-97.3581439"),
("Norfolk", "Norfolk", "Norfolk", NULL, 1, 0, 1, NULL, "42.0283379", "-97.4169964"),
("Lincoln", "Lincoln", "Lincoln", NULL, 1, 0, 1, NULL, "40.8088861", "-96.7077751"),
("Fremont", "Fremont", "Fremont", NULL, 1, 0, 1, NULL, "41.4338363", "-96.4960449"),
("Council Bluffs", "Council Bluffs", "Council Bluffs", NULL, 1, 0, 1, NULL, "41.258841", "-95.8519484"),
("Omaha", "Omaha", "Omaha", NULL, 1, 0, 1, NULL, "41.2587459", "-95.9383758"),
("Pierre", "Pierre", "Pierre", NULL, 1, 0, 1, NULL, "44.3683644", "-100.351136"),
("Yankton", "Yankton", "Yankton", NULL, 1, 0, 1, NULL, "42.8712938", "-97.3967011"),
("Sioux City", "Sioux City", "Sioux City", NULL, 1, 0, 1, NULL, "42.4966815", "-96.4058782"),
("Vermillion", "Vermillion", "Vermillion", NULL, 1, 0, 1, NULL, "42.7795273", "-96.929101"),
("Sioux Falls", "Sioux Falls", "Sioux Falls", NULL, 1, 0, 1, NULL, "43.5488256", "-96.7307737"),
("Mitchell", "Mitchell", "Mitchell", NULL, 1, 0, 1, NULL, "43.70953", "-98.025379"),
("Huron", "Huron", "Huron", NULL, 1, 0, 1, NULL, "44.36308", "-98.214388"),
("Watertown", "Watertown", "Watertown", NULL, 1, 0, 1, NULL, "44.899211", "-97.115289") ; 

INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES
("Brookings", "Brookings", "Brookings", NULL, 1, 0, 1, NULL, "44.311461", "-96.79844"),
("Saint Joseph", "Saint Joseph", "Saint Joseph", NULL, 1, 0, 1, NULL, "39.7686055", "-94.8466322"),
("Des Moines", "Des Moines", "Des Moines", NULL, 1, 0, 1, NULL, "41.5910323", "-93.6046655"),
("Ames", "Ames", "Ames", NULL, 1, 0, 1, NULL, "42.0267567", "-93.6170448"),
("Quincy", "Quincy", "Quincy", NULL, 1, 0, 1, NULL, "39.9356016", "-91.4098727"),
("Hannibal", "Hannibal", "Hannibal", NULL, 1, 0, 1, NULL, "39.7082498", "-91.3587413"),
("Iowa City", "Iowa City", "Iowa City", NULL, 1, 0, 1, NULL, "41.6612561", "-91.5299106"),
("Cedar Rapids", "Cedar Rapids", "Cedar Rapids", NULL, 1, 0, 1, NULL, "41.9758872", "-91.6704053"),
("Burlington", "Burlington", "Burlington", NULL, 1, 0, 1, NULL, "40.8126922", "-91.1020205"),
("Davenport", "Davenport", "Davenport", NULL, 1, 0, 1, NULL, "41.5235808", "-90.5770967"),
("Mankato", "Mankato", "Mankato", NULL, 1, 0, 1, NULL, "44.1634663", "-93.9993505"),
("Minneapolis", "Minneapolis", "Minneapolis", NULL, 1, 0, 1, NULL, "44.9772995", "-93.2654692"),
("Saint Paul", "Saint Paul", "Saint Paul", NULL, 1, 0, 1, NULL, "44.9497487", "-93.0931028"),
("Waterloo", "Waterloo", "Waterloo", NULL, 1, 0, 1, NULL, "42.498275", "-92.3328743"),
("Dubuque", "Dubuque", "Dubuque", NULL, 1, 0, 1, NULL, "42.5006243", "-90.6647985"),
("Rochester", "Rochester", "Rochester", NULL, 1, 0, 1, NULL, "44.0234387", "-92.4630182"),
("Eau Claire", "Eau Claire", "Eau Claire", NULL, 1, 0, 1, NULL, "44.811349", "-91.4984941"),
("La Crosse", "La Crosse", "La Crosse", NULL, 1, 0, 1, NULL, "43.8122836", "-91.2514355"),
("Nome", "Nome", "Nome", NULL, 1, 0, 1, NULL, "64.5011111", "-165.4063889"),
("Homer", "Homer", "Homer", NULL, 1, 0, 1, NULL, "59.6440876", "-151.5401477"),
("Seward", "Seward", "Seward", NULL, 1, 0, 1, NULL, "60.104202", "-149.442611"),
("Kenai", "Kenai", "Kenai", NULL, 1, 0, 1, NULL, "60.5544444", "-151.258333"),
("Soldotna", "Soldotna", "Soldotna", NULL, 1, 0, 1, NULL, "60.4847228", "-151.065349"),
("Anchorage", "Anchorage", "Anchorage", NULL, 1, 0, 1, NULL, "61.2163129", "-149.894852"),
("Valdez", "Valdez", "Valdez", NULL, 1, 0, 1, NULL, "61.1299396", "-146.349363"),
("Talkeetna", "Talkeetna", "Talkeetna", NULL, 1, 0, 1, NULL, "62.3238312", "-150.108881"),
("Fairbanks", "Fairbanks", "Fairbanks", NULL, 1, 0, 1, NULL, "64.837845", "-147.716675"),
("Sitka", "Sitka", "Sitka", NULL, 1, 0, 1, NULL, "57.0524973", "-135.337612"),
("Delta Junction", "Delta Junction", "Delta Junction", NULL, 1, 0, 1, NULL, "64.0373478", "-145.732157"),
("Point Hope", "Point Hope", "Point Hope", NULL, 1, 0, 1, NULL, "68.3498679", "-166.752609"),
("Point Lay", "Point Lay", "Point Lay", NULL, 1, 0, 1, NULL, "69.7430846", "-163.007648"),
("Wainwright", "Wainwright", "Wainwright", NULL, 1, 0, 1, NULL, "70.6369444", "-160.038333"),
("Utqiaġvik", "Utqiaġvik", "Utqiaġvik", NULL, 1, 0, 1, NULL, "71.2905556", "-156.788611"),
("Atqasuk", "Atqasuk", "Atqasuk", NULL, 1, 0, 1, NULL, "70.4811247", "-157.420841"),
("Anaktuvuk Pass", "Anaktuvuk Pass", "Anaktuvuk Pass", NULL, 1, 0, 1, NULL, "68.1413944", "-151.735979"),
("Kaktovik", "Kaktovik", "Kaktovik", NULL, 1, 0, 1, NULL, "70.1274505", "-143.6128656"),
("Aberdeen", "Aberdeen", "Aberdeen", NULL, 1, 0, 1, NULL, "46.975371", "-123.815722"),
("Ketchikan", "Ketchikan", "Ketchikan", NULL, 1, 0, 1, NULL, "55.3430696", "-131.6466819"),
("Hillsboro", "Hillsboro", "Hillsboro", NULL, 1, 0, 1, NULL, "45.5228939", "-122.989827"),
("Beaverton", "Beaverton", "Beaverton", NULL, 1, 0, 1, NULL, "45.4871723", "-122.80378"),
("Tigard", "Tigard", "Tigard", NULL, 1, 0, 1, NULL, "45.4307473", "-122.771933"),
("Lake Oswego", "Lake Oswego", "Lake Oswego", NULL, 1, 0, 1, NULL, "45.4206749", "-122.670649"),
("Portland", "Portland", "Portland", NULL, 1, 0, 1, NULL, "45.5202471", "-122.674194"),
("Gresham", "Gresham", "Gresham", NULL, 1, 0, 1, NULL, "45.4997475", "-122.4309766"),
("Vancouver", "Vancouver", "Vancouver", NULL, 1, 0, 1, NULL, "45.6306954", "-122.6744557"),
("Olympia", "Olympia", "Olympia", NULL, 1, 0, 1, NULL, "47.0451022", "-122.8950075"),
("Tacoma", "Tacoma", "Tacoma", NULL, 1, 0, 1, NULL, "47.2455013", "-122.438329"),
("Bremerton", "Bremerton", "Bremerton", NULL, 1, 0, 1, NULL, "47.5653663", "-122.6246836"),
("Seattle", "Seattle", "Seattle", NULL, 1, 0, 1, NULL, "47.6038321", "-122.330062"),
("Bellevue", "Bellevue", "Bellevue", NULL, 1, 0, 1, NULL, "47.6144219", "-122.192337"),
("Richland", "Richland", "Richland", NULL, 1, 0, 1, NULL, "46.2804298", "-119.275205"),
("Kennewick", "Kennewick", "Kennewick", NULL, 1, 0, 1, NULL, "46.2087066", "-119.119919"),
("Pasco", "Pasco", "Pasco", NULL, 1, 0, 1, NULL, "46.2306739", "-119.0921"),
("Walla Walla", "Walla Walla", "Walla Walla", NULL, 1, 0, 1, NULL, "46.0667277", "-118.339345"),
("Yakima", "Yakima", "Yakima", NULL, 1, 0, 1, NULL, "46.601557", "-120.510842"),
("Wenatchee", "Wenatchee", "Wenatchee", NULL, 1, 0, 1, NULL, "47.4234599", "-120.310349"),
("Bellingham", "Bellingham", "Bellingham", NULL, 1, 0, 1, NULL, "48.7544012", "-122.478836"),
("Everett", "Everett", "Everett", NULL, 1, 0, 1, NULL, "47.9793437", "-122.2127011"),
("Lewiston", "Lewiston", "Lewiston", NULL, 1, 0, 1, NULL, "46.4195913", "-117.0216144"),
("Clarkston", "Clarkston", "Clarkston", NULL, 1, 0, 1, NULL, "46.4162724", "-117.045179"),
("Spokane", "Spokane", "Spokane", NULL, 1, 0, 1, NULL, "47.6571934", "-117.42351"),
("Coeur d'Alene", "Coeur d'Alene", "Coeur d'Alene", NULL, 1, 0, 1, NULL, "47.6742994", "-116.7811531"),
("Butte", "Butte", "Butte", NULL, 1, 0, 1, NULL, "46.0131505", "-112.536508"),
("Missoula", "Missoula", "Missoula", NULL, 1, 0, 1, NULL, "46.8701049", "-113.995267"),
("Kalispell", "Kalispell", "Kalispell", NULL, 1, 0, 1, NULL, "48.202158", "-114.315321"),
("Juneau", "Juneau", "Juneau", NULL, 1, 0, 1, NULL, "58.3019496", "-134.419734"),
("Bozeman", "Bozeman", "Bozeman", NULL, 1, 0, 1, NULL, "45.6794293", "-111.044047"),
("Helena", "Helena", "Helena", NULL, 1, 0, 1, NULL, "46.5927425", "-112.036277"),
("Great Falls", "Great Falls", "Great Falls", NULL, 1, 0, 1, NULL, "47.5048851", "-111.29189"),
("Billings", "Billings", "Billings", NULL, 1, 0, 1, NULL, "45.7874957", "-108.49607"),
("Havre", "Havre", "Havre", NULL, 1, 0, 1, NULL, "48.5536972", "-109.677802"),
("Dickinson", "Dickinson", "Dickinson", NULL, 1, 0, 1, NULL, "46.8791756", "-102.7896242"),
("Williston", "Williston", "Williston", NULL, 1, 0, 1, NULL, "48.1465457", "-103.621814"),
("Minot", "Minot", "Minot", NULL, 1, 0, 1, NULL, "48.23251", "-101.296273"),
("Aberdeen", "Aberdeen", "Aberdeen", NULL, 1, 0, 1, NULL, "45.4649805", "-98.487813"),
("Bismarck", "Bismarck", "Bismarck", NULL, 1, 0, 1, NULL, "46.808327", "-100.783739"),
("Fargo", "Fargo", "Fargo", NULL, 1, 0, 1, NULL, "46.877229", "-96.789821"),
("Grand Forks", "Grand Forks", "Grand Forks", NULL, 1, 0, 1, NULL, "47.9078244", "-97.0592028"),
("Saint Cloud", "Saint Cloud", "Saint Cloud", NULL, 1, 0, 1, NULL, "45.5616075", "-94.1642004"),
("Duluth", "Duluth", "Duluth", NULL, 1, 0, 1, NULL, "46.7729322", "-92.1251218"),
("International Falls", "International Falls", "International Falls", NULL, 1, 0, 1, NULL, "48.601033", "-93.4105904"),
("Mayagüez", "Mayagüez", "Mayagüez", NULL, 1, 0, 1, NULL, "18.2011161", "-67.1391124"),
("San Juan", "San Juan", "San Juan", NULL, 1, 0, 1, NULL, "18.465299", "-66.116666"),
("Río Piedras", "Río Piedras", "Río Piedras", NULL, 1, 0, 1, NULL, "18.3974229", "-66.050111"),
("Cape Coral", "Cape Coral", "Cape Coral", NULL, 1, 0, 1, NULL, "26.6059432", "-81.9806771"),
("Fort Myers", "Fort Myers", "Fort Myers", NULL, 1, 0, 1, NULL, "26.640628", "-81.8723084"),
("Sarasota", "Sarasota", "Sarasota", NULL, 1, 0, 1, NULL, "27.3365805", "-82.5308545"),
("North Port", "North Port", "North Port", NULL, 1, 0, 1, NULL, "27.044224", "-82.2359254"),
("Port Charlotte", "Port Charlotte", "Port Charlotte", NULL, 1, 0, 1, NULL, "26.9761707", "-82.0906448"),
("Saint Petersburg", "Saint Petersburg", "Saint Petersburg", NULL, 1, 0, 1, NULL, "27.7700475", "-82.6359078"),
("Bradenton", "Bradenton", "Bradenton", NULL, 1, 0, 1, NULL, "27.4989278", "-82.5748194"),
("Pinellas Park", "Pinellas Park", "Pinellas Park", NULL, 1, 0, 1, NULL, "27.8428025", "-82.6995444"),
("Largo", "Largo", "Largo", NULL, 1, 0, 1, NULL, "27.9094665", "-82.7873244"),
("Clearwater", "Clearwater", "Clearwater", NULL, 1, 0, 1, NULL, "27.9658533", "-82.8001026"),
("Palm Harbor", "Palm Harbor", "Palm Harbor", NULL, 1, 0, 1, NULL, "28.0780718", "-82.7637127"),
("Tampa", "Tampa", "Tampa", NULL, 1, 0, 1, NULL, "27.9477595", "-82.458444"),
("Brandon", "Brandon", "Brandon", NULL, 1, 0, 1, NULL, "27.937801", "-82.2859247"),
("Lakeland", "Lakeland", "Lakeland", NULL, 1, 0, 1, NULL, "28.0394654", "-81.9498042"),
("Homestead", "Homestead", "Homestead", NULL, 1, 0, 1, NULL, "25.4718946", "-80.4759905"),
("Kendall", "Kendall", "Kendall", NULL, 1, 0, 1, NULL, "25.6792695", "-80.3172743"),
("Miami", "Miami", "Miami", NULL, 1, 0, 1, NULL, "25.7741728", "-80.19362"),
("Hialeah", "Hialeah", "Hialeah", NULL, 1, 0, 1, NULL, "25.8575963", "-80.2781057"),
("Pembroke Pines", "Pembroke Pines", "Pembroke Pines", NULL, 1, 0, 1, NULL, "26.0061943", "-80.2872086"),
("Miramar", "Miramar", "Miramar", NULL, 1, 0, 1, NULL, "25.9873137", "-80.2322706"),
("Coral Springs", "Coral Springs", "Coral Springs", NULL, 1, 0, 1, NULL, "26.271192", "-80.2706044"),
("Miami Beach", "Miami Beach", "Miami Beach", NULL, 1, 0, 1, NULL, "25.7929198", "-80.1353006"),
("Hollywood", "Hollywood", "Hollywood", NULL, 1, 0, 1, NULL, "26.0112014", "-80.1494901"),
("Fort Lauderdale", "Fort Lauderdale", "Fort Lauderdale", NULL, 1, 0, 1, NULL, "26.1223084", "-80.1433786"),
("Pompano Beach", "Pompano Beach", "Pompano Beach", NULL, 1, 0, 1, NULL, "26.2378597", "-80.1247667"),
("Deerfield Beach", "Deerfield Beach", "Deerfield Beach", NULL, 1, 0, 1, NULL, "26.318342", "-80.0996306"),
("Boca Raton", "Boca Raton", "Boca Raton", NULL, 1, 0, 1, NULL, "26.3586885", "-80.0830984"),
("West Palm Beach", "West Palm Beach", "West Palm Beach", NULL, 1, 0, 1, NULL, "26.715364", "-80.0532942"),
("Port Saint Lucie", "Port Saint Lucie", "Port Saint Lucie", NULL, 1, 0, 1, NULL, "27.2939333", "-80.3503283"),
("Palm Bay", "Palm Bay", "Palm Bay", NULL, 1, 0, 1, NULL, "27.9946969", "-80.6366144"),
("Melbourne", "Melbourne", "Melbourne", NULL, 1, 0, 1, NULL, "28.106471", "-80.6371513"),
("Riviera Beach", "Riviera Beach", "Riviera Beach", NULL, 1, 0, 1, NULL, "26.784343", "-80.0650293"),
("Gulfport", "Gulfport", "Gulfport", NULL, 1, 0, 1, NULL, "30.3674198", "-89.0928155"),
("Biloxi", "Biloxi", "Biloxi", NULL, 1, 0, 1, NULL, "30.4007626", "-88.8893818"),
("Mobile", "Mobile", "Mobile", NULL, 1, 0, 1, NULL, "30.6913462", "-88.0437509"),
("Pensacola", "Pensacola", "Pensacola", NULL, 1, 0, 1, NULL, "30.421309", "-87.2169149"),
("Hattiesburg", "Hattiesburg", "Hattiesburg", NULL, 1, 0, 1, NULL, "31.3271189", "-89.2903392"),
("Meridian", "Meridian", "Meridian", NULL, 1, 0, 1, NULL, "32.3643098", "-88.703656"),
("Tuscaloosa", "Tuscaloosa", "Tuscaloosa", NULL, 1, 0, 1, NULL, "33.2095614", "-87.5675258"),
("Dothan", "Dothan", "Dothan", NULL, 1, 0, 1, NULL, "31.2237434", "-85.3933906"),
("Montgomery", "Montgomery", "Montgomery", NULL, 1, 0, 1, NULL, "32.3669656", "-86.3006485"),
("Birmingham", "Birmingham", "Birmingham", NULL, 1, 0, 1, NULL, "33.5206824", "-86.8024326"),
("Auburn", "Auburn", "Auburn", NULL, 1, 0, 1, NULL, "32.6098566", "-85.4807825"),
("Columbus", "Columbus", "Columbus", NULL, 1, 0, 1, NULL, "32.4610708", "-84.9880449"),
("Atlanta", "Atlanta", "Atlanta", NULL, 1, 0, 1, NULL, "33.7489924", "-84.3902644"),
("Spring Hill", "Spring Hill", "Spring Hill", NULL, 1, 0, 1, NULL, "28.4635266", "-82.5363557"),
("The Villages", "The Villages", "The Villages", NULL, 1, 0, 1, NULL, "28.9269978", "-82.0041758"),
("Ocala", "Ocala", "Ocala", NULL, 1, 0, 1, NULL, "29.1871986", "-82.1400923"),
("Tallahassee", "Tallahassee", "Tallahassee", NULL, 1, 0, 1, NULL, "30.4380832", "-84.2809332"),
("Valdosta", "Valdosta", "Valdosta", NULL, 1, 0, 1, NULL, "30.8327022", "-83.2784851"),
("Gainesville", "Gainesville", "Gainesville", NULL, 1, 0, 1, NULL, "29.6519684", "-82.3249846"),
("Jacksonville", "Jacksonville", "Jacksonville", NULL, 1, 0, 1, NULL, "30.3321838", "-81.655651"),
("Kissimmee", "Kissimmee", "Kissimmee", NULL, 1, 0, 1, NULL, "28.2918995", "-81.4075838"),
("Orlando", "Orlando", "Orlando", NULL, 1, 0, 1, NULL, "28.5421109", "-81.3790304"),
("Apopka", "Apopka", "Apopka", NULL, 1, 0, 1, NULL, "28.678013", "-81.511398"),
("Deltona", "Deltona", "Deltona", NULL, 1, 0, 1, NULL, "28.9005446", "-81.2636738"),
("Daytona Beach", "Daytona Beach", "Daytona Beach", NULL, 1, 0, 1, NULL, "29.2108147", "-81.0228331"),
("Palm Coast", "Palm Coast", "Palm Coast", NULL, 1, 0, 1, NULL, "29.5541432", "-81.2207673"),
("Albany", "Albany", "Albany", NULL, 1, 0, 1, NULL, "31.5782062", "-84.1556809"),
("Warner Robins", "Warner Robins", "Warner Robins", NULL, 1, 0, 1, NULL, "32.6200973", "-83.606568"),
("Macon", "Macon", "Macon", NULL, 1, 0, 1, NULL, "32.8406946", "-83.6324022"),
("Augusta", "Augusta", "Augusta", NULL, 1, 0, 1, NULL, "33.4709714", "-81.9748429"),
("Savannah", "Savannah", "Savannah", NULL, 1, 0, 1, NULL, "32.0790074", "-81.0921335"),
("Charleston", "Charleston", "Charleston", NULL, 1, 0, 1, NULL, "32.7884363", "-79.9399309"),
("Myrtle Beach", "Myrtle Beach", "Myrtle Beach", NULL, 1, 0, 1, NULL, "33.6956461", "-78.8900409"),
("Tupelo", "Tupelo", "Tupelo", NULL, 1, 0, 1, NULL, "34.2576067", "-88.7033859"),
("Florence", "Florence", "Florence", NULL, 1, 0, 1, NULL, "34.79981", "-87.677251"),
("Jackson", "Jackson", "Jackson", NULL, 1, 0, 1, NULL, "35.6144446", "-88.8177418"),
("Dickson", "Dickson", "Dickson", NULL, 1, 0, 1, NULL, "36.0766534", "-87.3870096"),
("Clarksville", "Clarksville", "Clarksville", NULL, 1, 0, 1, NULL, "36.5277607", "-87.3588703"),
("Decatur", "Decatur", "Decatur", NULL, 1, 0, 1, NULL, "34.6060203", "-86.9838165"),
("Huntsville", "Huntsville", "Huntsville", NULL, 1, 0, 1, NULL, "34.729847", "-86.5859011"),
("Smyrna", "Smyrna", "Smyrna", NULL, 1, 0, 1, NULL, "33.883887", "-84.5147454"),
("Sandy Springs", "Sandy Springs", "Sandy Springs", NULL, 1, 0, 1, NULL, "33.9242688", "-84.3785379"),
("Marietta", "Marietta", "Marietta", NULL, 1, 0, 1, NULL, "33.9528472", "-84.5496148"),
("Chattanooga", "Chattanooga", "Chattanooga", NULL, 1, 0, 1, NULL, "35.0457219", "-85.3094883"),
("Dalton", "Dalton", "Dalton", NULL, 1, 0, 1, NULL, "34.7691867", "-84.9702475"),
("Murfreesboro", "Murfreesboro", "Murfreesboro", NULL, 1, 0, 1, NULL, "35.8460396", "-86.3921096"),
("Franklin", "Franklin", "Franklin", NULL, 1, 0, 1, NULL, "35.925206", "-86.8689419"),
("Nashville", "Nashville", "Nashville", NULL, 1, 0, 1, NULL, "36.1622767", "-86.7742984"),
("Paducah", "Paducah", "Paducah", NULL, 1, 0, 1, NULL, "37.0833893", "-88.6000478"),
("Cape Girardeau", "Cape Girardeau", "Cape Girardeau", NULL, 1, 0, 1, NULL, "37.3034933", "-89.5230357"),
("Hopkinsville", "Hopkinsville", "Hopkinsville", NULL, 1, 0, 1, NULL, "36.8657651", "-87.4889532"),
("Evansville", "Evansville", "Evansville", NULL, 1, 0, 1, NULL, "37.970495", "-87.5715641"),
("Bowling Green", "Bowling Green", "Bowling Green", NULL, 1, 0, 1, NULL, "36.9903199", "-86.4436018"),
("Owensboro", "Owensboro", "Owensboro", NULL, 1, 0, 1, NULL, "37.7742152", "-87.1133304"),
("Elizabethtown", "Elizabethtown", "Elizabethtown", NULL, 1, 0, 1, NULL, "37.693952", "-85.8591285"),
("Bloomington", "Bloomington", "Bloomington", NULL, 1, 0, 1, NULL, "39.1670396", "-86.5342881"),
("Louisville", "Louisville", "Louisville", NULL, 1, 0, 1, NULL, "38.2542376", "-85.759407"),
("Frankfort", "Frankfort", "Frankfort", NULL, 1, 0, 1, NULL, "38.2009055", "-84.8732836"),
("Lexington", "Lexington", "Lexington", NULL, 1, 0, 1, NULL, "38.0464066", "-84.4970393"),
("Cincinnati", "Cincinnati", "Cincinnati", NULL, 1, 0, 1, NULL, "39.1014537", "-84.5124602"),
("Roswell", "Roswell", "Roswell", NULL, 1, 0, 1, NULL, "34.02332", "-84.360022"),
("Johns Creek", "Johns Creek", "Johns Creek", NULL, 1, 0, 1, NULL, "34.0181557", "-84.190196"),
("Athens", "Athens", "Athens", NULL, 1, 0, 1, NULL, "33.9597677", "-83.376398"),
("Anderson", "Anderson", "Anderson", NULL, 1, 0, 1, NULL, "34.5068601", "-82.6506264"),
("Greenville", "Greenville", "Greenville", NULL, 1, 0, 1, NULL, "34.851354", "-82.3984882"),
("Spartanburg", "Spartanburg", "Spartanburg", NULL, 1, 0, 1, NULL, "34.9498007", "-81.9320157"),
("Oak Ridge", "Oak Ridge", "Oak Ridge", NULL, 1, 0, 1, NULL, "36.0103562", "-84.2696449"),
("Knoxville", "Knoxville", "Knoxville", NULL, 1, 0, 1, NULL, "35.9603948", "-83.9210261"),
("Morristown", "Morristown", "Morristown", NULL, 1, 0, 1, NULL, "36.2139814", "-83.2948923"),
("Asheville", "Asheville", "Asheville", NULL, 1, 0, 1, NULL, "35.595076", "-82.5528478"),
("Johnson City", "Johnson City", "Johnson City", NULL, 1, 0, 1, NULL, "36.3134398", "-82.3534728"),
("Kingsport", "Kingsport", "Kingsport", NULL, 1, 0, 1, NULL, "36.550238", "-82.5594293"),
("Boone", "Boone", "Boone", NULL, 1, 0, 1, NULL, "36.2165362", "-81.6746158"),
("Columbia", "Columbia", "Columbia", NULL, 1, 0, 1, NULL, "34.0007493", "-81.0343313"),
("Monroe", "Monroe", "Monroe", NULL, 1, 0, 1, NULL, "34.9854275", "-80.5495112"),
("Florence", "Florence", "Florence", NULL, 1, 0, 1, NULL, "34.1984435", "-79.7671658"),
("Fayetteville", "Fayetteville", "Fayetteville", NULL, 1, 0, 1, NULL, "35.0525759", "-78.878292"),
("Gastonia", "Gastonia", "Gastonia", NULL, 1, 0, 1, NULL, "35.2622654", "-81.1838186"),
("Hickory", "Hickory", "Hickory", NULL, 1, 0, 1, NULL, "35.7333312", "-81.3442915"),
("Statesville", "Statesville", "Statesville", NULL, 1, 0, 1, NULL, "35.7826363", "-80.8872959"),
("Charlotte", "Charlotte", "Charlotte", NULL, 1, 0, 1, NULL, "35.2272086", "-80.8430827"),
("Concord", "Concord", "Concord", NULL, 1, 0, 1, NULL, "35.4094178", "-80.5800049"),
("Kannapolis", "Kannapolis", "Kannapolis", NULL, 1, 0, 1, NULL, "35.4874708", "-80.621438"),
("Salisbury", "Salisbury", "Salisbury", NULL, 1, 0, 1, NULL, "35.6709727", "-80.4742261"),
("Lenoir", "Lenoir", "Lenoir", NULL, 1, 0, 1, NULL, "35.9140196", "-81.5389849"),
("Winston-Salem", "Winston-Salem", "Winston-Salem", NULL, 1, 0, 1, NULL, "36.0998131", "-80.2440518"),
("Cary", "Cary", "Cary", NULL, 1, 0, 1, NULL, "35.7882893", "-78.7812081"),
("High Point", "High Point", "High Point", NULL, 1, 0, 1, NULL, "35.9556924", "-80.0053176"),
("Greensboro", "Greensboro", "Greensboro", NULL, 1, 0, 1, NULL, "36.0726355", "-79.7919754"),
("Burlington", "Burlington", "Burlington", NULL, 1, 0, 1, NULL, "36.0956918", "-79.4377991"),
("Durham", "Durham", "Durham", NULL, 1, 0, 1, NULL, "35.996653", "-78.9018053"),
("Richmond", "Richmond", "Richmond", NULL, 1, 0, 1, NULL, "37.7478572", "-84.2946539"),
("Bristol", "Bristol", "Bristol", NULL, 1, 0, 1, NULL, "36.5945034", "-82.1885212"),
("Bristol", "Bristol", "Bristol", NULL, 1, 0, 1, NULL, "36.5959685", "-82.1885009"),
("Chillicothe", "Chillicothe", "Chillicothe", NULL, 1, 0, 1, NULL, "39.3331197", "-82.9824019"),
("Ashland", "Ashland", "Ashland", NULL, 1, 0, 1, NULL, "38.4784144", "-82.6379387"),
("Huntington", "Huntington", "Huntington", NULL, 1, 0, 1, NULL, "38.4192496", "-82.445154"),
("Charleston", "Charleston", "Charleston", NULL, 1, 0, 1, NULL, "38.3505995", "-81.6332812"),
("Roanoke", "Roanoke", "Roanoke", NULL, 1, 0, 1, NULL, "37.270973", "-79.9414313"),
("Lynchburg", "Lynchburg", "Lynchburg", NULL, 1, 0, 1, NULL, "37.4137536", "-79.1422464"),
("Parkersburg", "Parkersburg", "Parkersburg", NULL, 1, 0, 1, NULL, "39.2667309", "-81.5620755"),
("Harrisonburg", "Harrisonburg", "Harrisonburg", NULL, 1, 0, 1, NULL, "38.4493315", "-78.8688833"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "39.7990175", "-89.6439575"),
("Peoria", "Peoria", "Peoria", NULL, 1, 0, 1, NULL, "40.6938609", "-89.5891008"),
("Bloomington", "Bloomington", "Bloomington", NULL, 1, 0, 1, NULL, "40.4797828", "-88.9939147"),
("Terre Haute", "Terre Haute", "Terre Haute", NULL, 1, 0, 1, NULL, "39.4667025", "-87.4139119"),
("Champaign", "Champaign", "Champaign", NULL, 1, 0, 1, NULL, "40.1164841", "-88.2430932"),
("Urbana", "Urbana", "Urbana", NULL, 1, 0, 1, NULL, "40.1117174", "-88.207301"),
("Aurora", "Aurora", "Aurora", NULL, 1, 0, 1, NULL, "41.7571701", "-88.3147539"),
("Joliet", "Joliet", "Joliet", NULL, 1, 0, 1, NULL, "41.5263603", "-88.0840212"),
("Naperville", "Naperville", "Naperville", NULL, 1, 0, 1, NULL, "41.7728699", "-88.1479278"),
("Elgin", "Elgin", "Elgin", NULL, 1, 0, 1, NULL, "42.03726", "-88.2810994"),
("Gary", "Gary", "Gary", NULL, 1, 0, 1, NULL, "41.6020962", "-87.3370647"),
("Chicago", "Chicago", "Chicago", NULL, 1, 0, 1, NULL, "41.8755616", "-87.6244212"),
("Indianapolis", "Indianapolis", "Indianapolis", NULL, 1, 0, 1, NULL, "39.7683331", "-86.1583502"),
("Fishers", "Fishers", "Fishers", NULL, 1, 0, 1, NULL, "39.9555928", "-86.0138729"),
("Lafayette", "Lafayette", "Lafayette", NULL, 1, 0, 1, NULL, "40.4167022", "-86.8752869"),
("Muncie", "Muncie", "Muncie", NULL, 1, 0, 1, NULL, "40.1936892", "-85.3865271"),
("South Bend", "South Bend", "South Bend", NULL, 1, 0, 1, NULL, "41.6833813", "-86.2500066"),
("Elkhart", "Elkhart", "Elkhart", NULL, 1, 0, 1, NULL, "41.6819935", "-85.9766671"),
("Fort Wayne", "Fort Wayne", "Fort Wayne", NULL, 1, 0, 1, NULL, "41.0799898", "-85.1386015"),
("Rockford", "Rockford", "Rockford", NULL, 1, 0, 1, NULL, "42.2713945", "-89.093966"),
("Janesville", "Janesville", "Janesville", NULL, 1, 0, 1, NULL, "42.6829765", "-89.0226793"),
("Madison", "Madison", "Madison", NULL, 1, 0, 1, NULL, "43.074761", "-89.3837613"),
("Waukegan", "Waukegan", "Waukegan", NULL, 1, 0, 1, NULL, "42.3636331", "-87.8447938"),
("Kenosha", "Kenosha", "Kenosha", NULL, 1, 0, 1, NULL, "42.5846773", "-87.8212263"),
("Racine", "Racine", "Racine", NULL, 1, 0, 1, NULL, "42.7260523", "-87.7825242"),
("Milwaukee", "Milwaukee", "Milwaukee", NULL, 1, 0, 1, NULL, "43.0349931", "-87.922497"),
("Wausau", "Wausau", "Wausau", NULL, 1, 0, 1, NULL, "44.9596017", "-89.6298239"),
("Fond du Lac", "Fond du Lac", "Fond du Lac", NULL, 1, 0, 1, NULL, "43.7748763", "-88.4458033"),
("Oshkosh", "Oshkosh", "Oshkosh", NULL, 1, 0, 1, NULL, "44.0206919", "-88.5408574"),
("Appleton", "Appleton", "Appleton", NULL, 1, 0, 1, NULL, "44.2613967", "-88.4069744"),
("Sheboygan", "Sheboygan", "Sheboygan", NULL, 1, 0, 1, NULL, "43.7508284", "-87.71453"),
("Green Bay", "Green Bay", "Green Bay", NULL, 1, 0, 1, NULL, "44.5126379", "-88.0125794"),
("Kalamazoo", "Kalamazoo", "Kalamazoo", NULL, 1, 0, 1, NULL, "42.291707", "-85.5872286"),
("Battle Creek", "Battle Creek", "Battle Creek", NULL, 1, 0, 1, NULL, "42.3192548", "-85.1824269"),
("Lansing", "Lansing", "Lansing", NULL, 1, 0, 1, NULL, "42.7337712", "-84.5553805"),
("Grand Rapids", "Grand Rapids", "Grand Rapids", NULL, 1, 0, 1, NULL, "42.9632425", "-85.6678639"),
("Traverse City", "Traverse City", "Traverse City", NULL, 1, 0, 1, NULL, "44.7606441", "-85.6165301"),
("Dayton", "Dayton", "Dayton", NULL, 1, 0, 1, NULL, "39.7589478", "-84.1916069"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "39.9234046", "-83.810138"),
("Columbus", "Columbus", "Columbus", NULL, 1, 0, 1, NULL, "39.9622601", "-83.0007065"),
("Mansfield", "Mansfield", "Mansfield", NULL, 1, 0, 1, NULL, "40.75839", "-82.5154471"),
("Findlay", "Findlay", "Findlay", NULL, 1, 0, 1, NULL, "41.0413873", "-83.6503982"),
("Toledo", "Toledo", "Toledo", NULL, 1, 0, 1, NULL, "41.6529143", "-83.5378173"),
("Sandusky", "Sandusky", "Sandusky", NULL, 1, 0, 1, NULL, "41.4561002", "-82.7115813"),
("Cleveland", "Cleveland", "Cleveland", NULL, 1, 0, 1, NULL, "41.4996574", "-81.6936772"),
("Cumberland", "Cumberland", "Cumberland", NULL, 1, 0, 1, NULL, "39.6526498", "-78.762383"),
("Pittsburgh", "Pittsburgh", "Pittsburgh", NULL, 1, 0, 1, NULL, "40.4416941", "-79.9900861"),
("Canton", "Canton", "Canton", NULL, 1, 0, 1, NULL, "40.7985464", "-81.3749508"),
("Akron", "Akron", "Akron", NULL, 1, 0, 1, NULL, "41.083064", "-81.518485"),
("Youngstown", "Youngstown", "Youngstown", NULL, 1, 0, 1, NULL, "41.1035786", "-80.6520161"),
("New Castle", "New Castle", "New Castle", NULL, 1, 0, 1, NULL, "40.9999202", "-80.3471856"),
("Warren", "Warren", "Warren", NULL, 1, 0, 1, NULL, "41.2367955", "-80.8190423"),
("Ashtabula", "Ashtabula", "Ashtabula", NULL, 1, 0, 1, NULL, "41.865054", "-80.789809"),
("Meadville", "Meadville", "Meadville", NULL, 1, 0, 1, NULL, "41.641445", "-80.151449"),
("Erie", "Erie", "Erie", NULL, 1, 0, 1, NULL, "42.1294712", "-80.0852695"),
("Jamestown", "Jamestown", "Jamestown", NULL, 1, 0, 1, NULL, "42.0965167", "-79.2380322"),
("Ann Arbor", "Ann Arbor", "Ann Arbor", NULL, 1, 0, 1, NULL, "42.2681569", "-83.7312291"),
("Dearborn", "Dearborn", "Dearborn", NULL, 1, 0, 1, NULL, "42.3222599", "-83.1763145"),
("Detroit", "Detroit", "Detroit", NULL, 1, 0, 1, NULL, "42.3315509", "-83.0466403"),
("Warren", "Warren", "Warren", NULL, 1, 0, 1, NULL, "42.4932575", "-83.0062746"),
("Sterling Heights", "Sterling Heights", "Sterling Heights", NULL, 1, 0, 1, NULL, "42.5803122", "-83.0302033"),
("Flint", "Flint", "Flint", NULL, 1, 0, 1, NULL, "43.0161693", "-83.6900211"),
("Saginaw", "Saginaw", "Saginaw", NULL, 1, 0, 1, NULL, "43.4200387", "-83.9490365"),
("Buffalo", "Buffalo", "Buffalo", NULL, 1, 0, 1, NULL, "42.8867166", "-78.8783922"),
("Tonawanda", "Tonawanda", "Tonawanda", NULL, 1, 0, 1, NULL, "43.020679", "-78.878383"),
("Niagara Falls", "Niagara Falls", "Niagara Falls", NULL, 1, 0, 1, NULL, "43.08436", "-79.0614686"),
("Wilmington", "Wilmington", "Wilmington", NULL, 1, 0, 1, NULL, "34.2257282", "-77.9447107"),
("Jacksonville", "Jacksonville", "Jacksonville", NULL, 1, 0, 1, NULL, "34.7494749", "-77.4208221"),
("Raleigh", "Raleigh", "Raleigh", NULL, 1, 0, 1, NULL, "35.7803977", "-78.6390989"),
("Petersburg", "Petersburg", "Petersburg", NULL, 1, 0, 1, NULL, "37.227928", "-77.4019268"),
("Richmond", "Richmond", "Richmond", NULL, 1, 0, 1, NULL, "37.5385087", "-77.43428"),
("Suffolk", "Suffolk", "Suffolk", NULL, 1, 0, 1, NULL, "36.7282096", "-76.5835703"),
("Portsmouth", "Portsmouth", "Portsmouth", NULL, 1, 0, 1, NULL, "36.8320081", "-76.297699"),
("Chesapeake", "Chesapeake", "Chesapeake", NULL, 1, 0, 1, NULL, "36.7183708", "-76.2466798"),
("Norfolk", "Norfolk", "Norfolk", NULL, 1, 0, 1, NULL, "36.8448348", "-76.2863999"),
("Virginia Beach", "Virginia Beach", "Virginia Beach", NULL, 1, 0, 1, NULL, "36.8529841", "-75.9774183"),
("Newport News", "Newport News", "Newport News", NULL, 1, 0, 1, NULL, "36.9775016", "-76.42977"),
("Hampton", "Hampton", "Hampton", NULL, 1, 0, 1, NULL, "37.0300969", "-76.3452057"),
("Charlottesville", "Charlottesville", "Charlottesville", NULL, 1, 0, 1, NULL, "38.029306", "-78.4766781"),
("Fredericksburg", "Fredericksburg", "Fredericksburg", NULL, 1, 0, 1, NULL, "38.3031837", "-77.4605399"),
("Winchester", "Winchester", "Winchester", NULL, 1, 0, 1, NULL, "39.1852184", "-78.1652404"),
("Fairfax", "Fairfax", "Fairfax", NULL, 1, 0, 1, NULL, "38.8462236", "-77.3063733"),
("Alexandria", "Alexandria", "Alexandria", NULL, 1, 0, 1, NULL, "38.8051095", "-77.0470229"),
("Arlington", "Arlington", "Arlington", NULL, 1, 0, 1, NULL, "38.8903961", "-77.0841585"),
("Washington", "Washington", "Washington", NULL, 1, 0, 1, NULL, "38.8950368", "-77.0365427"),
("Bethesda", "Bethesda", "Bethesda", NULL, 1, 0, 1, NULL, "38.9814093", "-77.1178538"),
("Silver Spring", "Silver Spring", "Silver Spring", NULL, 1, 0, 1, NULL, "38.9959461", "-77.0276231"),
("Bowie", "Bowie", "Bowie", NULL, 1, 0, 1, NULL, "38.9424464", "-76.7301718"),
("Laurel", "Laurel", "Laurel", NULL, 1, 0, 1, NULL, "39.0984317", "-76.8485094"),
("Columbia", "Columbia", "Columbia", NULL, 1, 0, 1, NULL, "39.2156213", "-76.8582049"),
("Annapolis", "Annapolis", "Annapolis", NULL, 1, 0, 1, NULL, "38.9786401", "-76.492786"),
("Dundalk", "Dundalk", "Dundalk", NULL, 1, 0, 1, NULL, "39.2574114", "-76.5236745"),
("Baltimore", "Baltimore", "Baltimore", NULL, 1, 0, 1, NULL, "39.2908816", "-76.610759"),
("Salisbury", "Salisbury", "Salisbury", NULL, 1, 0, 1, NULL, "38.366027", "-75.6009964"),
("Dover", "Dover", "Dover", NULL, 1, 0, 1, NULL, "39.158168", "-75.5243682"),
("Atlantic City", "Atlantic City", "Atlantic City", NULL, 1, 0, 1, NULL, "39.3642852", "-74.4229351"),
("Hagerstown", "Hagerstown", "Hagerstown", NULL, 1, 0, 1, NULL, "39.6430455", "-77.7191081"),
("Frederick", "Frederick", "Frederick", NULL, 1, 0, 1, NULL, "39.415779", "-77.4127562"),
("Altoona", "Altoona", "Altoona", NULL, 1, 0, 1, NULL, "40.518681", "-78.394736"),
("York", "York", "York", NULL, 1, 0, 1, NULL, "39.9624624", "-76.727707"),
("Towson", "Towson", "Towson", NULL, 1, 0, 1, NULL, "39.4018513", "-76.6023803"),
("Lancaster", "Lancaster", "Lancaster", NULL, 1, 0, 1, NULL, "40.03813", "-76.3056686"),
("Harrisburg", "Harrisburg", "Harrisburg", NULL, 1, 0, 1, NULL, "40.2663107", "-76.8861122"),
("Lebanon", "Lebanon", "Lebanon", NULL, 1, 0, 1, NULL, "40.3429683", "-76.4233816"),
("State College", "State College", "State College", NULL, 1, 0, 1, NULL, "40.7944504", "-77.8616386"),
("Williamsport", "Williamsport", "Williamsport", NULL, 1, 0, 1, NULL, "41.2493292", "-77.0027671"),
("Hazleton", "Hazleton", "Hazleton", NULL, 1, 0, 1, NULL, "40.9646867", "-75.9852789"),
("Wilmington", "Wilmington", "Wilmington", NULL, 1, 0, 1, NULL, "39.7459468", "-75.546589"),
("Vineland", "Vineland", "Vineland", NULL, 1, 0, 1, NULL, "39.4862777", "-75.0254256"),
("Philadelphia", "Philadelphia", "Philadelphia", NULL, 1, 0, 1, NULL, "39.9527237", "-75.1635262"),
("Camden", "Camden", "Camden", NULL, 1, 0, 1, NULL, "39.9448402", "-75.1198911"),
("Reading", "Reading", "Reading", NULL, 1, 0, 1, NULL, "40.335345", "-75.9279495"),
("Allentown", "Allentown", "Allentown", NULL, 1, 0, 1, NULL, "40.6022059", "-75.4712794"),
("Bethlehem", "Bethlehem", "Bethlehem", NULL, 1, 0, 1, NULL, "40.6178915", "-75.3786521"),
("Trenton", "Trenton", "Trenton", NULL, 1, 0, 1, NULL, "40.2205944", "-74.7597219"),
("Easton", "Easton", "Easton", NULL, 1, 0, 1, NULL, "40.6916081", "-75.2099866"),
("Toms River", "Toms River", "Toms River", NULL, 1, 0, 1, NULL, "39.9526791", "-74.1968257"),
("Lakewood Township", "Lakewood Township", "Lakewood", NULL, 1, 0, 1, NULL, "40.0978929", "-74.2176435"),
("Long Branch", "Long Branch", "Long Branch", NULL, 1, 0, 1, NULL, "40.3042778", "-73.9923596"),
("New Brunswick", "New Brunswick", "New Brunswick", NULL, 1, 0, 1, NULL, "40.4862174", "-74.4518173"),
("Elizabeth", "Elizabeth", "Elizabeth", NULL, 1, 0, 1, NULL, "40.6639916", "-74.2107006"),
("Newark", "Newark", "Newark", NULL, 1, 0, 1, NULL, "40.735657", "-74.1723667"),
("New York", "New York", "New York", NULL, 1, 0, 1, NULL, "40.7127281", "-74.0060152"),
("Jersey City", "Jersey City", "Jersey City", NULL, 1, 0, 1, NULL, "40.7215682", "-74.047455"),
("Wilkes-Barre", "Wilkes-Barre", "Wilkes-Barre", NULL, 1, 0, 1, NULL, "41.2464824", "-75.8817316"),
("Scranton", "Scranton", "Scranton", NULL, 1, 0, 1, NULL, "41.4086874", "-75.6621294"),
("Binghamton", "Binghamton", "Binghamton", NULL, 1, 0, 1, NULL, "42.098698", "-75.9125187"),
("Paterson", "Paterson", "Paterson", NULL, 1, 0, 1, NULL, "40.9167654", "-74.171811"),
("Yonkers", "Yonkers", "Yonkers", NULL, 1, 0, 1, NULL, "40.9312099", "-73.8987469"),
("Stamford", "Stamford", "Stamford", NULL, 1, 0, 1, NULL, "41.0534302", "-73.5387341"),
("Norwalk", "Norwalk", "Norwalk", NULL, 1, 0, 1, NULL, "41.1175966", "-73.4078968"),
("Bridgeport", "Bridgeport", "Bridgeport", NULL, 1, 0, 1, NULL, "41.1670412", "-73.2048348"),
("Danbury", "Danbury", "Danbury", NULL, 1, 0, 1, NULL, "41.394817", "-73.4540111"),
("Rochester", "Rochester", "Rochester", NULL, 1, 0, 1, NULL, "43.157285", "-77.615214"),
("Ithaca", "Ithaca", "Ithaca", NULL, 1, 0, 1, NULL, "42.4396039", "-76.4968019"),
("Syracuse", "Syracuse", "Syracuse", NULL, 1, 0, 1, NULL, "43.0481221", "-76.1474244"),
("Utica", "Utica", "Utica", NULL, 1, 0, 1, NULL, "43.1009031", "-75.2326641"),
("Schenectady", "Schenectady", "Schenectady", NULL, 1, 0, 1, NULL, "42.8142432", "-73.9395687"),
("Albany", "Albany", "Albany", NULL, 1, 0, 1, NULL, "42.6511674", "-73.754968"),
("Troy", "Troy", "Troy", NULL, 1, 0, 1, NULL, "42.7284117", "-73.6917878"),
("Saratoga Springs", "Saratoga Springs", "Saratoga Springs", NULL, 1, 0, 1, NULL, "43.0821793", "-73.7853915"),
("Watertown", "Watertown", "Watertown", NULL, 1, 0, 1, NULL, "43.9747838", "-75.9107565"),
("Ogdensburg", "Ogdensburg", "Ogdensburg", NULL, 1, 0, 1, NULL, "44.694285", "-75.486374"),
("Burlington", "Burlington", "Burlington", NULL, 1, 0, 1, NULL, "44.4761601", "-73.212906"),
("Plattsburgh", "Plattsburgh", "Plattsburgh", NULL, 1, 0, 1, NULL, "44.69282", "-73.45562"),
("New Haven", "New Haven", "New Haven", NULL, 1, 0, 1, NULL, "41.3082138", "-72.9250518"),
("Ansonia", "Ansonia", "Ansonia", NULL, 1, 0, 1, NULL, "41.3429922", "-73.0787468"),
("New London", "New London", "New London", NULL, 1, 0, 1, NULL, "41.3556187", "-72.0997804"),
("Waterbury", "Waterbury", "Waterbury", NULL, 1, 0, 1, NULL, "41.5538091", "-73.0438362"),
("Meriden", "Meriden", "Meriden", NULL, 1, 0, 1, NULL, "41.5381535", "-72.8070435"),
("Torrington", "Torrington", "Torrington", NULL, 1, 0, 1, NULL, "41.8006523", "-73.1212214"),
("Bristol", "Bristol", "Bristol", NULL, 1, 0, 1, NULL, "41.6735209", "-72.9464859"),
("New Britain", "New Britain", "New Britain", NULL, 1, 0, 1, NULL, "41.6612104", "-72.7795419"),
("Middletown", "Middletown", "Middletown", NULL, 1, 0, 1, NULL, "41.5623178", "-72.6509061"),
("Hartford", "Hartford", "Hartford", NULL, 1, 0, 1, NULL, "41.764582", "-72.6908547"),
("Westfield", "Westfield", "Westfield", NULL, 1, 0, 1, NULL, "42.1205411", "-72.7489158"),
("Chicopee", "Chicopee", "Chicopee", NULL, 1, 0, 1, NULL, "42.1487691", "-72.6071119"),
("Springfield", "Springfield", "Springfield", NULL, 1, 0, 1, NULL, "42.1018764", "-72.5886727"),
("Norwich", "Norwich", "Norwich", NULL, 1, 0, 1, NULL, "41.5243537", "-72.0759008"),
("Providence", "Providence", "Providence", NULL, 1, 0, 1, NULL, "41.8239891", "-71.4128343"),
("Newport", "Newport", "Newport", NULL, 1, 0, 1, NULL, "41.4899827", "-71.3137707"),
("Fall River", "Fall River", "Fall River", NULL, 1, 0, 1, NULL, "41.7010642", "-71.1546367"),
("Woonsocket", "Woonsocket", "Woonsocket", NULL, 1, 0, 1, NULL, "42.0028761", "-71.5147839"),
("Attleboro", "Attleboro", "Attleboro", NULL, 1, 0, 1, NULL, "41.9438129", "-71.2806515"),
("Taunton", "Taunton", "Taunton", NULL, 1, 0, 1, NULL, "41.9019257", "-71.0931485"),
("Brockton", "Brockton", "Brockton", NULL, 1, 0, 1, NULL, "42.0834335", "-71.0183787"),
("New Bedford", "New Bedford", "New Bedford", NULL, 1, 0, 1, NULL, "41.6362152", "-70.934205"),
("Easthampton", "Easthampton", "Easthampton", NULL, 1, 0, 1, NULL, "42.2708804", "-72.6719579"),
("Holyoke", "Holyoke", "Holyoke", NULL, 1, 0, 1, NULL, "42.2071434", "-72.60765"),
("Northampton", "Northampton", "Northampton", NULL, 1, 0, 1, NULL, "42.3178989", "-72.6311006"),
("Greenfield", "Greenfield", "Greenfield", NULL, 1, 0, 1, NULL, "42.5876342", "-72.6002068"),
("Worcester", "Worcester", "Worcester", NULL, 1, 0, 1, NULL, "42.2625621", "-71.8018877"),
("Leominster", "Leominster", "Leominster", NULL, 1, 0, 1, NULL, "42.5267443", "-71.7614891"),
("Gardner", "Gardner", "Gardner", NULL, 1, 0, 1, NULL, "42.5763523", "-71.9952737"),
("Fitchburg", "Fitchburg", "Fitchburg", NULL, 1, 0, 1, NULL, "42.5854371", "-71.8046023"),
("Keene", "Keene", "Keene", NULL, 1, 0, 1, NULL, "42.933597", "-72.2784264"),
("Marlborough", "Marlborough", "Marlborough", NULL, 1, 0, 1, NULL, "42.3459271", "-71.5522874"),
("Framingham", "Framingham", "Framingham", NULL, 1, 0, 1, NULL, "42.2773177", "-71.4165905"),
("Newton", "Newton", "Newton", NULL, 1, 0, 1, NULL, "42.3370414", "-71.2092214"),
("Boston", "Boston", "Boston", NULL, 1, 0, 1, NULL, "42.3554334", "-71.060511"),
("Cambridge", "Cambridge", "Cambridge", NULL, 1, 0, 1, NULL, "42.3655767", "-71.1040018"),
("Somerville", "Somerville", "Somerville", NULL, 1, 0, 1, NULL, "42.3875968", "-71.0994968"),
("Chelsea", "Chelsea", "Chelsea", NULL, 1, 0, 1, NULL, "42.3917638", "-71.0328284"),
("Woburn", "Woburn", "Woburn", NULL, 1, 0, 1, NULL, "42.4792618", "-71.1522766"),
("Nashua", "Nashua", "Nashua", NULL, 1, 0, 1, NULL, "42.7656251", "-71.4677032"),
("Lowell", "Lowell", "Lowell", NULL, 1, 0, 1, NULL, "42.6414437", "-71.3085329"),
("Lawrence", "Lawrence", "Lawrence", NULL, 1, 0, 1, NULL, "42.7070354", "-71.1631137"),
("Methuen", "Methuen", "Methuen", NULL, 1, 0, 1, NULL, "42.7262016", "-71.1908924"),
("Haverhill", "Haverhill", "Haverhill", NULL, 1, 0, 1, NULL, "42.7777829", "-71.0767724"),
("Quincy", "Quincy", "Quincy", NULL, 1, 0, 1, NULL, "42.2509914", "-71.0037374"),
("Revere", "Revere", "Revere", NULL, 1, 0, 1, NULL, "42.4084302", "-71.0119948"),
("Lynn", "Lynn", "Lynn", NULL, 1, 0, 1, NULL, "42.466763", "-70.9494939"),
("Peabody", "Peabody", "Peabody", NULL, 1, 0, 1, NULL, "42.5278731", "-70.9286609"),
("Salem", "Salem", "Salem", NULL, 1, 0, 1, NULL, "42.5195292", "-70.8967226"),
("Beverly", "Beverly", "Beverly", NULL, 1, 0, 1, NULL, "42.5584284", "-70.8800491"),
("Amesbury", "Amesbury", "Amesbury", NULL, 1, 0, 1, NULL, "42.8579536", "-70.9300921"),
("Newburyport", "Newburyport", "Newburyport", NULL, 1, 0, 1, NULL, "42.8125913", "-70.8772751"),
("Gloucester", "Gloucester", "Gloucester", NULL, 1, 0, 1, NULL, "42.6159286", "-70.6619888"),
("Manchester", "Manchester", "Manchester", NULL, 1, 0, 1, NULL, "42.9956397", "-71.4547891"),
("Concord", "Concord", "Concord", NULL, 1, 0, 1, NULL, "43.207178", "-71.537476"),
("Franklin", "Franklin", "Franklin", NULL, 1, 0, 1, NULL, "43.4442432", "-71.6472988"),
("Laconia", "Laconia", "Laconia", NULL, 1, 0, 1, NULL, "43.5278546", "-71.470351"),
("Portsmouth", "Portsmouth", "Portsmouth", NULL, 1, 0, 1, NULL, "43.0702223", "-70.7548621"),
("Dover", "Dover", "Dover", NULL, 1, 0, 1, NULL, "43.1981117", "-70.8739761"),
("Rochester", "Rochester", "Rochester", NULL, 1, 0, 1, NULL, "43.3050631", "-70.9753629"),
("Sanford", "Sanford", "Sanford", NULL, 1, 0, 1, NULL, "43.438878", "-70.7739832"),
("Biddeford", "Biddeford", "Biddeford", NULL, 1, 0, 1, NULL, "43.4925843", "-70.4533844"),
("Saco", "Saco", "Saco", NULL, 1, 0, 1, NULL, "43.5009176", "-70.4428286"),
("Montpelier", "Montpelier", "Montpelier", NULL, 1, 0, 1, NULL, "44.2602164", "-72.5751208"),
("Lebanon", "Lebanon", "Lebanon", NULL, 1, 0, 1, NULL, "43.643032", "-72.251587"),
("Westbrook", "Westbrook", "Westbrook", NULL, 1, 0, 1, NULL, "43.6763036", "-70.3663874"),
("South Portland", "South Portland", "South Portland", NULL, 1, 0, 1, NULL, "43.6414716", "-70.2408811"),
("Portland", "Portland", "Portland", NULL, 1, 0, 1, NULL, "43.6592687", "-70.2572642"),
("Auburn", "Auburn", "Auburn", NULL, 1, 0, 1, NULL, "44.0972546", "-70.2254085"),
("Lewiston", "Lewiston", "Lewiston", NULL, 1, 0, 1, NULL, "44.0951078", "-70.2155454"),
("Augusta", "Augusta", "Augusta", NULL, 1, 0, 1, NULL, "44.3155295", "-69.7700241"),
("Waterville", "Waterville", "Waterville", NULL, 1, 0, 1, NULL, "44.5520105", "-69.6317121"),
("Bangor", "Bangor", "Bangor", NULL, 1, 0, 1, NULL, "44.8036159", "-68.7702127"),
("Marquette", "Marquette", "Marquette", NULL, 1, 0, 1, NULL, "46.5434914", "-87.396433"),
("Presque Isle", "Presque Isle", "Presque Isle", NULL, 1, 0, 1, NULL, "46.6832082", "-68.0141431"),
("Caribou", "Caribou", "Caribou", NULL, 1, 0, 1, NULL, "46.8605567", "-68.0119677"),
("Calais", "Calais", "Calais", NULL, 1, 0, 1, NULL, "45.1883938", "-67.2769294");