number of errors=795
number of warnings=0
country=US
Group=chkGrpShp
select geonameid,name,countrycode,admincode1,admincode2,admincode3 from geoname where countrycode='US' and featurecode='ADM3' and not exists (select 1 from geoname_shape where level=4 and geoname_shape.countrycode=geoname.countrycode and geoname_shape.admincode1=geoname.admincode1 and geoname_shape.admincode2=geoname.admincode2 and geoname_shape.admincode3=geoname.admincode3)
geonameid name countrycode admincode1 admincode2 admincode3 11788359 City of Angoon US AK 105 11788359 11789045 City of Kachemak US AK 122 11789045 11788352 City of Ouzinkie US AK 150 11788352 11788380 City of Old Harbor US AK 150 11788380 11788989 City of Port Alexander US AK 198 11788989 11789031 City of Kake US AK 198 11789031 11788654 City of Jackson US AL 025 11788654 11788627 City of Rainbow City US AL 055 11788627 11788399 City of Tarrant US AL 073 11788399 11788851 City of Birmingham US AL 073 11788851 11788721 City of Semmes US AL 097 11788721 11788468 City of Pell City US AL 115 11788468 11789008 City of Saint Johns US AZ 001 11789008 11788341 City of Sierra Vista US AZ 003 11788341 11788377 City of Benson US AZ 003 11788377 11788496 City of Tombstone US AZ 003 11788496 11788504 City of Bisbee US AZ 003 11788504 11788917 City of Willcox US AZ 003 11788917 11788400 City of Flagstaff US AZ 005 11788400 11788969 City of Globe US AZ 007 11788969 11788708 City of Safford US AZ 009 11788708 11788571 City of Glendale US AZ 013 11788571 11788692 City of Phoenix US AZ 013 11788692 11788744 City of Avondale US AZ 013 11788744 11788514 City of Bullhead City US AZ 015 11788514 11788823 City of Lake Havasu City US AZ 015 11788823 11788880 City of Kingman US AZ 015 11788880 11788806 City of Winslow US AZ 017 11788806 11789037 City of Show Low US AZ 017 11789037 11789042 City of Holbrook US AZ 017 11789042 11789060 City of Somerton US AZ 027 11789060 11788327 City of Hayward US CA 001 11788327 11788339 City of Pleasanton US CA 001 11788339 11788367 City of Albany US CA 001 11788367 11788444 City of Oakland US CA 001 11788444 11788465 City of Piedmont US CA 001 11788465 11788562 City of Alameda US CA 001 11788562 11788567 City of Dublin US CA 001 11788567 11788711 City of Emeryville US CA 001 11788711 11788855 City of Livermore US CA 001 11788855 11788901 City of Union City US CA 001 11788901 11788954 City of Berkeley US CA 001 11788954 11788523 City of Plymouth US CA 005 11788523 11788737 City of Amador City US CA 005 11788737 11788959 City of Sutter Creek US CA 005 11788959 11788993 City of Ione US CA 005 11788993 11788331 City of Biggs US CA 007 11788331 11788527 City of Gridley US CA 007 11788527 11788688 City of Chico US CA 007 11788688 11788955 City of Oroville US CA 007 11788955 11788418 City of Angels US CA 009 11788418 11788718 City of Williams US CA 011 11788718 11788344 City of Martinez US CA 013 11788344 11788357 City of Walnut Creek US CA 013 11788357 11788384 City of Pleasant Hill US CA 013 11788384 11788428 City of Hercules US CA 013 11788428 11788558 City of Brentwood US CA 013 11788558 11788719 City of El Cerrito US CA 013 11788719 11788779 City of Clayton US CA 013 11788779 11788797 City of Oakley US CA 013 11788797 11788927 City of Concord US CA 013 11788927 11788939 City of Pittsburg US CA 013 11788939 11789036 City of Antioch US CA 013 11789036 11789038 City of Richmond US CA 013 11789038 11788520 City of Crescent City US CA 015 11788520 11788700 City of Placerville US CA 017 11788700 11788310 City of Fresno US CA 019 11788310 11788315 City of Parlier US CA 019 11788315 11788333 City of Coalinga US CA 019 11788333 11788388 City of Mendota US CA 019 11788388 11788414 City of Kerman US CA 019 11788414 11788429 City of Orange Cove US CA 019 11788429 11788435 City of Kingsburg US CA 019 11788435 11788441 City of Reedley US CA 019 11788441 11788507 City of Firebaugh US CA 019 11788507 11788518 City of San Joaquin US CA 019 11788518 11788596 City of Huron US CA 019 11788596 11788620 City of Selma US CA 019 11788620 11789005 City of Fowler US CA 019 11789005 11788332 City of Orland US CA 021 11788332 11788510 City of Willows US CA 021 11788510 11788551 City of Ferndale US CA 023 11788551 11788609 City of Eureka US CA 023 11788609 11788709 City of Arcata US CA 023 11788709 11788888 City of Blue Lake US CA 023 11788888 11788645 City of Holtville US CA 025 11788645 11788788 City of El Centro US CA 025 11788788 11788796 City of Westmorland US CA 025 11788796 11788934 City of Brawley US CA 025 11788934 11788940 City of Calipatria US CA 025 11788940 11788944 City of Calexico US CA 025 11788944 11788960 City of Imperial US CA 025 11788960 11788469 City of Bishop US CA 027 11788469 11788306 City of Wasco US CA 029 11788306 11788326 City of McFarland US CA 029 11788326 11788460 City of Taft US CA 029 11788460 11788587 City of Bakersfield US CA 029 11788587 11788597 City of Arvin US CA 029 11788597 11788750 City of Tehachapi US CA 029 11788750 11788881 City of Ridgecrest US CA 029 11788881 11788921 City of Maricopa US CA 029 11788921 11788533 City of Lemoore US CA 031 11788533 11788723 City of Avenal US CA 031 11788723 11788792 City of Hanford US CA 031 11788792 11789069 City of Corcoran US CA 031 11789069 11788362 City of Clearlake US CA 033 11788362 11788907 City of Lakeport US CA 033 11788907 11788886 City of Susanville US CA 035 11788886 11788289 City of El Segundo US CA 037 11788289 11788299 City of South Gate US CA 037 11788299 11788304 City of Palmdale US CA 037 11788304 11788320 City of Glendale US CA 037 11788320 11788366 City of Carson US CA 037 11788366 11788374 City of Cudahy US CA 037 11788374 11788375 City of Maywood US CA 037 11788375 11788391 City of Downey US CA 037 11788391 11788401 City of Huntington Park US CA 037 11788401 11788419 City of Arcadia US CA 037 11788419 11788426 City of Santa Monica US CA 037 11788426 11788427 City of Hawthorne US CA 037 11788427 11788458 City of Bellflower US CA 037 11788458 11788480 City of Bradbury US CA 037 11788480 11788483 City of Glendora US CA 037 11788483 11788487 City of Lawndale US CA 037 11788487 11788499 City of Sierra Madre US CA 037 11788499 11788500 City of Beverly Hills US CA 037 11788500 11788509 City of Pico Rivera US CA 037 11788509 11788531 City of Industry US CA 037 11788531 11788534 City of Norwalk US CA 037 11788534 11788545 City of San Fernando US CA 037 11788545 11788554 City of Irwindale US CA 037 11788554 11788560 City of Walnut US CA 037 11788560 11788561 City of Cerritos US CA 037 11788561 11788576 City of Agoura Hills US CA 037 11788576 11788581 City of Burbank US CA 037 11788581 11788583 City of Pomona US CA 037 11788583 11788589 City of Temple City US CA 037 11788589 11788599 City of San Dimas US CA 037 11788599 11788606 City of Manhattan Beach US CA 037 11788606 11788608 City of Montebello US CA 037 11788608 11788630 City of Hawaiian Gardens US CA 037 11788630 11788632 City of San Marino US CA 037 11788632 11788641 City of Alhambra US CA 037 11788641 11788647 City of Gardena US CA 037 11788647 11788653 City of Culver City US CA 037 11788653 11788680 City of Hermosa Beach US CA 037 11788680 11788690 City of Baldwin Park US CA 037 11788690 11788713 City of Pasadena US CA 037 11788713 11788760 City of Lynwood US CA 037 11788760 11788780 City of Redondo Beach US CA 037 11788780 11788798 City of Signal Hill US CA 037 11788798 11788813 City of Palos Verdes Estates US CA 037 11788813 11788819 City of Lancaster US CA 037 11788819 11788820 City of La Verne US CA 037 11788820 11788829 City of Long Beach US CA 037 11788829 11788852 City of Bell Gardens US CA 037 11788852 11788860 City of Covina US CA 037 11788860 11788874 City of Whittier US CA 037 11788874 11788877 City of Commerce US CA 037 11788877 11788892 City of Monterey Park US CA 037 11788892 11788904 City of Claremont US CA 037 11788904 11788913 City of Bell US CA 037 11788913 11788930 City of Torrance US CA 037 11788930 11788935 City of La Mirada US CA 037 11788935 11788943 City of Vernon US CA 037 11788943 11788947 City of South Pasadena US CA 037 11788947 11788977 City of Inglewood US CA 037 11788977 11788983 City of Lakewood US CA 037 11788983 11788994 City of Duarte US CA 037 11788994 11789012 City of Monrovia US CA 037 11789012 11789027 City of Hidden Hills US CA 037 11789027 11789032 City of Lomita US CA 037 11789032 11789046 City of Paramount US CA 037 11789046 11789061 City of West Covina US CA 037 11789061 11788423 City of Madera US CA 039 11788423 11788825 City of Chowchilla US CA 039 11788825 11788356 City of Mill Valley US CA 041 11788356 11788433 City of San Rafael US CA 041 11788433 11788948 City of Sausalito US CA 041 11788948 11788965 City of Larkspur US CA 041 11788965 11789058 City of Belvedere US CA 041 11789058 11788329 City of Fort Bragg US CA 045 11788329 11788854 City of Willits US CA 045 11788854 11788962 City of Ukiah US CA 045 11788962 11788524 City of Los Banos US CA 047 11788524 11788715 City of Merced US CA 047 11788715 11788736 City of Atwater US CA 047 11788736 11788740 City of Dos Palos US CA 047 11788740 11788771 City of Livingston US CA 047 11788771 11788350 City of Pacific Grove US CA 053 11788350 11788383 City of King City US CA 053 11788383 11788494 City of Seaside US CA 053 11788494 11788498 City of Salinas US CA 053 11788498 11788508 City of Greenfield US CA 053 11788508 11788644 City of Del Rey Oaks US CA 053 11788644 11788681 City of Gonzales US CA 053 11788681 11788761 City of Marina US CA 053 11788761 11789013 City of Sand City US CA 053 11789013 11789047 City of Monterey US CA 053 11789047 11788347 City of Calistoga US CA 055 11788347 11788453 City of Yountville US CA 055 11788453 11788517 City of Saint Helena US CA 055 11788517 11788614 City of Grass Valley US CA 057 11788614 11789055 City of Nevada City US CA 057 11789055 11788290 City of Fullerton US CA 059 11788290 11788307 City of Seal Beach US CA 059 11788307 11788346 City of La Habra US CA 059 11788346 11788425 City of Newport Beach US CA 059 11788425 11788486 City of Santa Ana US CA 059 11788486 11788490 City of Brea US CA 059 11788490 11788610 City of San Clemente US CA 059 11788610 11788613 City of Cypress US CA 059 11788613 11788629 City of Laguna Beach US CA 059 11788629 11788634 City of Fountain Valley US CA 059 11788634 11788663 City of Villa Park US CA 059 11788663 11788682 City of Huntington Beach US CA 059 11788682 11788730 City of Orange US CA 059 11788730 11788805 City of Yorba Linda US CA 059 11788805 11788826 City of Garden Grove US CA 059 11788826 11788911 City of Placentia US CA 059 11788911 11789000 City of Stanton US CA 059 11789000 11789019 City of Westminster US CA 059 11789019 11788392 City of Lincoln US CA 061 11788392 11788783 City of Roseville US CA 061 11788783 11788872 City of Auburn US CA 061 11788872 11788605 City of Portola US CA 063 11788605 11788467 City of Coachella US CA 065 11788467 11788471 City of Desert Hot Springs US CA 065 11788471 11788497 City of Palm Desert US CA 065 11788497 11788501 City of Norco US CA 065 11788501 11788592 City of Lake Elsinore US CA 065 11788592 11788598 City of Moreno Valley US CA 065 11788598 11788602 City of Canyon Lake US CA 065 11788602 11788640 City of Beaumont US CA 065 11788640 11788652 City of La Quinta US CA 065 11788652 11788691 City of Perris US CA 065 11788691 11788698 City of Cathedral City US CA 065 11788698 11788758 City of Palm Springs US CA 065 11788758 11788808 City of Eastvale US CA 065 11788808 11788900 City of Riverside US CA 065 11788900 11788966 City of San Jacinto US CA 065 11788966 11788995 City of Jurupa Valley US CA 065 11788995 11789039 City of Indian Wells US CA 065 11789039 11789044 City of Rancho Mirage US CA 065 11789044 11788300 City of Sacramento US CA 067 11788300 11788481 City of Rancho Cordova US CA 067 11788481 11788770 City of Citrus Heights US CA 067 11788770 11788850 City of Elk Grove US CA 067 11788850 11788920 City of Folsom US CA 067 11788920 11788936 City of Galt US CA 067 11788936 11788946 City of Isleton US CA 067 11788946 11788361 City of Hollister US CA 069 11788361 11788869 City of San Juan Bautista US CA 069 11788869 11788287 City of Fontana US CA 071 11788287 11788398 City of Upland US CA 071 11788398 11788411 City of Yucaipa US CA 071 11788411 11788439 City of Hesperia US CA 071 11788439 11788505 City of Highland US CA 071 11788505 11788665 City of Barstow US CA 071 11788665 11788671 City of Montclair US CA 071 11788671 11788793 City of Redlands US CA 071 11788793 11788865 City of Ontario US CA 071 11788865 11788292 City of Coronado US CA 073 11788292 11788324 City of Escondido US CA 073 11788324 11788553 City of Vista US CA 073 11788553 11788573 City of San Diego US CA 073 11788573 11788586 City of San Marcos US CA 073 11788586 11788635 City of Lemon Grove US CA 073 11788635 11788728 City of Encinitas US CA 073 11788728 11788776 City of Carlsbad US CA 073 11788776 11788789 City of Oceanside US CA 073 11788789 11788849 City of National City US CA 073 11788849 11788864 City of Imperial Beach US CA 073 11788864 11788974 City of Solana Beach US CA 073 11788974 11789034 City of Santee US CA 073 11789034 11788447 City of Tracy US CA 077 11788447 11788492 City of Manteca US CA 077 11788492 11788544 City of Lathrop US CA 077 11788544 11788667 City of Stockton US CA 077 11788667 11788752 City of Ripon US CA 077 11788752 11788987 City of Lodi US CA 077 11788987 11788633 City of Grover Beach US CA 079 11788633 11788985 City of Morro Bay US CA 079 11788985 11789043 City of San Luis Obispo US CA 079 11789043 11789052 City of Pismo Beach US CA 079 11789052 11788313 City of Redwood City US CA 081 11788313 11788395 City of South San Francisco US CA 081 11788395 11788539 City of East Palo Alto US CA 081 11788539 11788664 City of San Bruno US CA 081 11788664 11788703 City of Belmont US CA 081 11788703 11788747 City of Daly City US CA 081 11788747 11788784 City of Foster City US CA 081 11788784 11788840 City of Menlo Park US CA 081 11788840 11788842 City of Millbrae US CA 081 11788842 11788953 City of San Carlos US CA 081 11788953 11788548 City of Carpinteria US CA 083 11788548 11788282 City of Campbell US CA 085 11788282 11788420 City of Santa Clara US CA 085 11788420 11788438 City of Cupertino US CA 085 11788438 11788454 City of Sunnyvale US CA 085 11788454 11788546 City of Monte Sereno US CA 085 11788546 11788716 City of Morgan Hill US CA 085 11788716 11788729 City of Gilroy US CA 085 11788729 11788735 City of Palo Alto US CA 085 11788735 11788857 City of Los Altos US CA 085 11788857 11789001 City of San Jose US CA 085 11789001 11789048 City of Saratoga US CA 085 11789048 11788650 City of Scotts Valley US CA 087 11788650 11788775 City of Santa Cruz US CA 087 11788775 11788951 City of Capitola US CA 087 11788951 11788574 City of Redding US CA 089 11788574 11788746 City of Anderson US CA 089 11788746 11788463 City of Loyalton US CA 091 11788463 11788314 City of Tulelake US CA 093 11788314 11788365 City of Montague US CA 093 11788365 11788593 City of Mount Shasta US CA 093 11788593 11788769 City of Fort Jones US CA 093 11788769 11788843 City of Dorris US CA 093 11788843 11788941 City of Yreka US CA 093 11788941 11789014 City of Etna US CA 093 11789014 11789018 City of Weed US CA 093 11789018 11788448 City of Suisun City US CA 095 11788448 11788519 City of Benicia US CA 095 11788519 11788526 City of Rio Vista US CA 095 11788526 11788824 City of Vacaville US CA 095 11788824 11788863 City of Dixon US CA 095 11788863 11788945 City of Fairfield US CA 095 11788945 11789020 City of Vallejo US CA 095 11789020 11788482 City of Cotati US CA 097 11788482 11788550 City of Sebastopol US CA 097 11788550 11788687 City of Cloverdale US CA 097 11788687 11788696 City of Sonoma US CA 097 11788696 11788768 City of Healdsburg US CA 097 11788768 11788827 City of Rohnert Park US CA 097 11788827 11788859 City of Santa Rosa US CA 097 11788859 11788312 City of Oakdale US CA 099 11788312 11788382 City of Patterson US CA 099 11788382 11788475 City of Riverbank US CA 099 11788475 11788673 City of Modesto US CA 099 11788673 11788841 City of Hughson US CA 099 11788841 11788910 City of Ceres US CA 099 11788910 11788992 City of Turlock US CA 099 11788992 11788967 City of Yuba City US CA 101 11788967 11788421 City of Red Bluff US CA 103 11788421 11788600 City of Corning US CA 103 11788600 11788417 City of Visalia US CA 107 11788417 11788528 City of Farmersville US CA 107 11788528 11788625 City of Porterville US CA 107 11788625 11788712 City of Exeter US CA 107 11788712 11788738 City of Lindsay US CA 107 11788738 11788882 City of Dinuba US CA 107 11788882 11788895 City of Woodlake US CA 107 11788895 11788555 City of Sonora US CA 109 11788555 11788330 City of Fillmore US CA 111 11788330 11788390 City of Simi Valley US CA 111 11788390 11788631 City of Oxnard US CA 111 11788631 11788774 City of Camarillo US CA 111 11788774 11788845 City of Santa Paula US CA 111 11788845 11789004 City of Moorpark US CA 111 11789004 11788636 City of West Sacramento US CA 113 11788636 11788759 City of Winters US CA 113 11788759 11788809 City of Woodland US CA 113 11788809 11788364 City of Marysville US CA 115 11788364 11788594 City of Wheatland US CA 115 11788594 11788303 City of Cherry Hills Village US CO 005 11788303 11788621 City of Englewood US CO 005 11788621 11788781 City of Littleton US CO 005 11788781 11788536 City of Boulder US CO 013 11788536 11788815 City of Lafayette US CO 013 11788815 11789033 City of Louisville US CO 013 11789033 11788731 City of Broomfield US CO 014 11788731 11788668 City of Denver US CO 031 11788668 11788739 City of Colorado Springs US CO 041 11788739 11788385 City of Cañon City US CO 043 11788385 11788839 City of Florence US CO 043 11788839 11788847 City of Central City US CO 047 11788847 11788922 City of Walsenburg US CO 055 11788922 11788318 City of Golden US CO 059 11788318 11788403 City of Arvada US CO 059 11788403 11788568 City of Wheat Ridge US CO 059 11788568 11788834 City of Lakewood US CO 059 11788834 11788986 City of Westminster US CO 059 11788986 11788694 City of Durango US CO 067 11788694 11788807 City of Trinidad US CO 071 11788807 11788803 City of Cortez US CO 083 11788803 11788296 City of Montrose US CO 085 11788296 11788778 City of Rocky Ford US CO 089 11788778 11789041 City of Monte Vista US CO 105 11789041 11789030 City of Washington US DC 001 11789030 11788563 City of Gainesville US FL 001 11788563 11608478 City of Fort Lauderdale US FL 011 11608478 11788604 City of Coral Springs US FL 011 11788604 11788889 City of Cooper City US FL 011 11788889 11788975 City of Everglades US FL 021 11788975 11789040 City of Brooksville US FL 053 11789040 11788343 City of Plant City US FL 057 11788343 11788376 City of Eustis US FL 069 11788376 11788643 City of Chiefland US FL 075 11788643 11788488 City of Belleview US FL 083 11788488 11788529 City of Ocala US FL 083 11788529 11788316 City of Haines City US FL 105 11788316 11788440 City of Webster US FL 119 11788440 11788477 City of Wildwood US FL 119 11788477 11789064 City of Fitzgerald US GA 017 11789064 11788811 City of Ray City US GA 019 11788811 11788952 City of Garden City US GA 051 11788952 11788311 City of Adel US GA 075 11788311 11788443 City of Brookhaven US GA 089 11788443 11788707 City of Tucker US GA 089 11788707 11788932 City of Rincon US GA 103 11788932 11788748 City of Fayetteville US GA 113 11788748 11788288 City of East Point US GA 121 11788288 11788370 City of Alpharetta US GA 121 11788370 11788535 City of Peachtree Corners US GA 135 11788535 11788305 City of Sylvester US GA 321 11788305 5855598 Hanalei (CDP) US HI 007 5855598 11788446 City of Davenport US IA 163 11788446 11788456 City of Garden City US ID 001 11788456 11788906 City of Boise City US ID 001 11788906 11788976 City of Atomic City US ID 011 11788976 11788766 City of Idaho City US ID 015 11788766 11788899 City of Butte City US ID 023 11788899 11788353 City of Nampa US ID 027 11788353 11789065 City of Hagerman US ID 047 11789065 11788459 City of Jerome US ID 053 11788459 11788297 City of Harrison US ID 055 11788297 11788360 City of Coeur d'Alene US ID 055 11788360 11788675 City of Moscow US ID 057 11788675 11788866 City of Sugar City US ID 065 11788866 11789022 City of Rexburg US ID 065 11789022 11788489 City of Malad City US ID 071 11788489 11788340 City of Buhl US ID 083 11788340 11788474 City of Castleford US ID 083 11788474 11788710 City of Twin Falls US ID 083 11788710 11788765 City of Kimberly US ID 083 11788765 11788919 City of Hansen US ID 083 11788919 11788617 City of Johnston City US IL 199 11788617 11788732 City of Bossier City US LA 015 11788732 11788472 City of Central US LA 033 11788472 11788949 City of Havre de Grace US MD 025 11788949 11788676 City of Bowie US MD 033 11788676 11788449 City of Pocomoke City US MD 047 11788449 4989148 Charter Township of Clinton US MI 099 4989148 11788569 City of Diamondhead US MS 045 11788569 11788437 City of Dillon US MT 001 11788437 11788991 City of Fort Benton US MT 015 11788991 11789017 City of Miles City US MT 017 11789017 11788794 City of Baker US MT 025 11788794 11788928 City of Lewistown US MT 027 11788928 11788725 City of Whitefish US MT 029 11788725 11788890 City of Kalispell US MT 029 11788890 11788733 City of Havre US MT 041 11788733 11788693 City of Polson US MT 047 11788693 11788801 City of Ronan US MT 047 11788801 11788430 City of Helena US MT 049 11788430 11788742 City of Troy US MT 053 11788742 11788705 City of White Sulphur Springs US MT 059 11788705 11788590 City of Missoula US MT 063 11788590 11788982 City of Roundup US MT 065 11788982 11788559 City of Malta US MT 071 11788559 11788584 City of Conrad US MT 073 11788584 11788412 City of Deer Lodge US MT 077 11788412 11788450 City of Poplar US MT 085 11788450 11788565 City of Shelby US MT 101 11788565 11788754 City of Glasgow US MT 105 11788754 11788861 City of Charlotte US NC 119 11788861 11788381 City of Albion US NE 011 11788381 11789007 City of Lincoln US NE 109 11789007 11788981 City of Seward US NE 159 11788981 11788846 City of Albuquerque US NM 001 11788846 11788512 City of Anthony US NM 013 11788512 11789057 City of Las Cruces US NM 013 11789057 11788293 City of Artesia US NM 015 11788293 11788830 City of Deming US NM 029 11788830 11788575 City of Farmington US NM 045 11788575 11788912 City of Las Vegas US NM 047 11788912 11788286 City of Santa Fe US NM 049 11788286 11788727 City of Rio Communities US NM 061 11788727 11788923 City of Fallon US NV 001 11788923 11788782 City of Henderson US NV 003 11788782 11788836 City of North Las Vegas US NV 003 11788836 11788873 City of Wells US NV 007 11788873 11788493 City of Winnemucca US NV 013 11788493 11788648 City of Caliente US NV 017 11788648 11788924 City of Ely US NV 033 11788924 5169921 Township of Saint Marys US OH 011 5169921 5160045 Township of Lagrange US OH 093 5160045 11788679 City of Elk City US OK 009 11788679 11788677 City of Boise City US OK 025 11788677 11788678 City of Moore US OK 027 11788678 11789002 City of Coalgate US OK 029 11789002 11788607 City of Holdenville US OK 063 11788607 11788979 City of Altus US OK 065 11788979 11788457 City of Kaw City US OK 071 11788457 11788762 City of Ponca City US OK 071 11788762 11788763 City of Broken Bow US OK 089 11788763 11788926 City of Madill US OK 095 11788926 11788397 City of Midwest City US OK 109 11788397 11788883 City of Del City US OK 109 11788883 11788838 City of Pawnee US OK 117 11788838 11788422 City of Ada US OK 123 11788422 11788669 City of Baker City US OR 001 11788669 11788566 City of Oregon City US OR 005 11788566 11788685 City of Rivergrove US OR 005 11788685 11788714 City of Johnson City US OR 005 11788714 11788929 City of Happy Valley US OR 005 11788929 11788637 City of Clatskanie US OR 009 11788637 11788699 City of Vernonia US OR 009 11788699 11788884 City of Columbia City US OR 009 11788884 11788379 City of North Bend US OR 011 11788379 11788656 City of Powers US OR 011 11788656 11788386 City of Sisters US OR 017 11788386 11788875 City of Redmond US OR 017 11788875 11788358 City of Roseburg US OR 019 11788358 11788833 City of Sutherlin US OR 019 11788833 11789015 City of Condon US OR 021 11789015 11788821 City of Prairie City US OR 023 11788821 11788908 City of Burns US OR 025 11788908 11788956 City of Hines US OR 025 11788956 11788540 City of Culver US OR 031 11788540 11788319 City of Dunes City US OR 039 11788319 11788556 City of Springfield US OR 039 11788556 11788795 City of Junction City US OR 039 11788795 11788970 City of Eugene US OR 039 11788970 11788301 City of Lincoln City US OR 041 11788301 11788990 City of Depoe Bay US OR 041 11788990 11789063 City of Toledo US OR 041 11789063 11788424 City of Sweet Home US OR 043 11788424 11788695 City of Mill City US OR 043 11788695 11788790 City of Salem US OR 047 11788790 11788532 City of Ione US OR 049 11788532 11788335 City of Portland US OR 051 11788335 11789028 City of Fairview US OR 051 11789028 11788393 City of Dallas US OR 053 11788393 11788626 City of Falls City US OR 053 11788626 11788321 City of Wasco US OR 055 11788321 11788756 City of Grass Valley US OR 055 11788756 11788980 City of Moro US OR 055 11788980 11788336 City of Manzanita US OR 057 11788336 11788337 City of Bay City US OR 057 11788337 11788582 City of Tillamook US OR 057 11788582 11788831 City of Nehalem US OR 057 11788831 11789066 City of Rockaway Beach US OR 057 11789066 11788416 City of Adams US OR 059 11788416 11788751 City of Athena US OR 059 11788751 11788887 City of Umatilla US OR 059 11788887 11788291 City of Union US OR 061 11788291 11788835 City of Island City US OR 061 11788835 11788354 City of Cornelius US OR 067 11788354 11788603 City of Durham US OR 067 11788603 11788704 City of King City US OR 067 11788704 11788325 City of McMinnville US OR 071 11788325 11788506 City of Yamhill US OR 071 11788506 11788814 City of Sheridan US OR 071 11788814 5222928 Town of Johnston US RI 007 5222928 5223683 Town of North Providence US RI 007 5223683 11788764 City of Anderson US SC 007 11788764 11788773 City of Belton US SC 007 11788773 11788810 City of Denmark US SC 009 11788810 11788410 City of North Charleston US SC 019 11788410 11788542 City of Charleston US SC 019 11788542 11788622 City of Isle of Palms US SC 019 11788622 11788407 City of Lake City US SC 041 11788407 11788611 City of Florence US SC 041 11788611 11788745 City of Georgetown US SC 043 11788745 11788338 City of Conway US SC 051 11788338 11789056 City of Myrtle Beach US SC 051 11789056 11788295 City of Camden US SC 055 11788295 11788802 City of Rocky Top US TN 001 11788802 11788591 City of Madisonville US TN 123 11788591 11788368 City of Bellville US TX 015 11788368 11788683 City of Muleshoe US TX 017 11788683 11788701 City of Seymour US TX 023 11788701 11789029 City of Beeville US TX 025 11789029 11788720 City of Temple US TX 027 11788720 11788896 City of Killeen US TX 027 11788896 11788323 City of Kirby US TX 029 11788323 11788371 City of Live Oak US TX 029 11788371 11788402 City of Converse US TX 029 11788402 11788451 City of Alamo Heights US TX 029 11788451 11788452 City of Olmos Park US TX 029 11788452 11788461 City of Balcones Heights US TX 029 11788461 11788511 City of Universal City US TX 029 11788511 11788595 City of Windcrest US TX 029 11788595 11788734 City of Sandy Oaks US TX 029 11788734 11788800 City of Terrell Hills US TX 029 11788800 11788957 City of San Antonio US TX 029 11788957 11788832 City of Johnson City US TX 031 11788832 11788915 City of Blanco US TX 031 11788915 11788389 City of Clute US TX 039 11788389 11788933 City of Sandy Point US TX 039 11788933 11788372 City of Early US TX 049 11788372 11788476 City of Brownwood US TX 049 11788476 11788464 City of Marble Falls US TX 053 11788464 11788998 City of Lockhart US TX 055 11788998 11788342 City of Harlingen US TX 061 11788342 11788816 City of San Benito US TX 061 11788816 11789024 City of Port Isabel US TX 061 11789024 11788638 City of Queen City US TX 067 11788638 11788755 City of Atlanta US TX 067 11788755 11788684 City of Byers US TX 077 11788684 11788984 City of Henrietta US TX 077 11788984 11788961 City of Novice US TX 083 11788961 11789023 City of Coleman US TX 083 11789023 11788697 City of Copperas Cove US TX 099 11788697 11789051 City of Gatesville US TX 099 11789051 11788413 City of Garland US TX 113 11788413 11788470 City of Cuero US TX 123 11788470 11788406 City of Horizon City US TX 141 11788406 11788572 City of San Elizario US TX 141 11788572 11789070 City of Stephenville US TX 143 11789070 11788434 City of Marlin US TX 145 11788434 11788538 City of Rosebud US TX 145 11788538 11788767 City of Honey Grove US TX 147 11788767 11788844 City of Bonham US TX 147 11788844 11788964 City of Crowell US TX 155 11788964 11788302 City of Richmond US TX 157 11788302 11788905 City of Missouri City US TX 157 11788905 11788963 City of Teague US TX 161 11788963 11788455 City of Dilley US TX 163 11788455 11788615 City of League City US TX 167 11788615 11788618 City of Friendswood US TX 167 11788618 11788876 City of Pampa US TX 179 11788876 11788885 City of White Oak US TX 183 11788885 11788914 City of Clarksville City US TX 183 11788914 11789006 City of Warren City US TX 183 11789006 11788916 City of Staples US TX 187 11788916 11788378 City of Plainview US TX 189 11788378 11789009 City of Quanah US TX 197 11789009 11788285 City of Houston US TX 201 11788285 11788309 City of Katy US TX 201 11788309 11788351 City of Humble US TX 201 11788351 11788408 City of Galena Park US TX 201 11788408 11789062 City of South Houston US TX 201 11789062 11788503 City of Marshall US TX 203 11788503 11788445 City of San Marcos US TX 209 11788445 11788616 City of Mountain City US TX 209 11788616 11788812 City of Gun Barrel City US TX 213 11788812 11788903 City of Trinidad US TX 213 11788903 11789035 City of Athens US TX 213 11789035 11788628 City of San Juan US TX 215 11788628 11788743 City of Weslaco US TX 215 11788743 11788958 City of Sullivan City US TX 215 11788958 11788543 City of Hillsboro US TX 217 11788543 11788891 City of Levelland US TX 219 11788891 11788804 City of Dell City US TX 229 11788804 11788530 City of Caddo Mills US TX 231 11788530 11789067 City of Wolfe City US TX 231 11789067 11789068 City of La Ward US TX 239 11789068 11788373 City of Groves US TX 245 11788373 11788404 City of Coyote Flats US TX 251 11788404 11788491 City of Falls City US TX 255 11788491 11788642 City of Karnes City US TX 255 11788642 11789016 City of Kenedy US TX 255 11789016 11788772 City of Terrell US TX 257 11788772 11788871 City of Boerne US TX 259 11788871 11788612 City of Jayton US TX 263 11788612 11788322 City of Kerrville US TX 265 11788322 11788348 City of Hallettsville US TX 285 11788348 11789011 City of Yoakum US TX 285 11789011 11788741 City of Mexia US TX 293 11788741 11788515 City of Madisonville US TX 313 11788515 11788999 City of Bay City US TX 321 11788999 11788537 City of Hondo US TX 325 11788537 11788856 City of Devine US TX 325 11788856 11788879 City of Midland US TX 329 11788879 11788334 City of Colorado City US TX 335 11788334 11788547 City of Dumas US TX 341 11788547 11788950 City of Kerens US TX 349 11788950 11788938 City of Port Aransas US TX 355 11788938 11788971 City of Bishop US TX 355 11788971 11788405 City of Bridge City US TX 361 11788405 11788363 City of Gordon US TX 363 11788363 11789003 City of Iraan US TX 371 11789003 11789050 City of Fort Stockton US TX 371 11789050 11788349 City of Canyon US TX 381 11788349 11788298 City of Royse City US TX 397 11788298 11789021 City of Mobile City US TX 397 11789021 11788484 City of Ballinger US TX 399 11788484 11788672 City of San Augustine US TX 405 11788672 11788799 City of Taft US TX 409 11788799 11789026 City of Moran US TX 417 11789026 11788909 City of Rio Grande City US TX 427 11788909 11788473 City of Sterling City US TX 431 11788473 11788749 City of Tulia US TX 437 11788749 11788658 City of Azle US TX 439 11788658 11788686 City of Fort Worth US TX 439 11788686 11788717 City of White Settlement US TX 439 11788717 11788848 City of North Richland Hills US TX 439 11788848 11788853 City of Mansfield US TX 439 11788853 11788870 City of Richland Hills US TX 439 11788870 11788902 City of Haltom City US TX 439 11788902 11788988 City of Colleyville US TX 439 11788988 11789059 City of Talco US TX 449 11789059 11789010 City of San Angelo US TX 451 11789010 11788623 City of Austin US TX 453 11788623 11788661 City of Ivanhoe North US TX 457 11788661 11788726 City of Ivanhoe US TX 457 11788726 11788786 City of Ore City US TX 459 11788786 11788898 City of Sabinal US TX 463 11788898 11788828 City of Canton US TX 467 11788828 11788867 City of Grand Saline US TX 467 11788867 11788785 City of Victoria US TX 469 11788785 11788415 City of Wichita Falls US TX 485 11788415 11788478 City of Electra US TX 485 11788478 11788525 City of Vernon US TX 487 11788525 11788283 City of Coupland US TX 491 11788283 11788651 City of Kermit US TX 495 11788651 11788639 City of Crystal City US TX 507 11788639 11788466 City of Beaver US UT 001 11788466 11788624 City of Milford US UT 001 11788624 11788284 City of Willard US UT 003 11788284 11788442 City of Bear River City US UT 003 11788442 11788657 City of Brigham City US UT 003 11788657 11788387 City of Hyrum US UT 005 11788387 11788396 City of Millville US UT 005 11788396 11788502 City of Richmond US UT 005 11788502 11788522 City of Smithfield US UT 005 11788522 11788619 City of Lewiston US UT 005 11788619 11788689 City of Mendon US UT 005 11788689 11788308 City of East Carbon-Sunnyside US UT 007 11788308 11788601 City of East Carbon US UT 007 11788601 11788787 City of Wellington US UT 007 11788787 11789049 City of Price US UT 007 11789049 11788432 City of North Salt Lake US UT 011 11788432 11788578 City of West Point US UT 011 11788578 11788858 City of Layton US UT 011 11788858 11788894 City of Farmington US UT 011 11788894 11788925 City of Clearfield US UT 011 11788925 11788431 City of Duchesne US UT 013 11788431 11788897 City of Myton US UT 013 11788897 11788931 City of Roosevelt US UT 013 11788931 11788317 City of Castle Dale US UT 015 11788317 11788577 City of Huntington US UT 015 11788577 11788702 City of Ferron US UT 015 11788702 11788549 City of Panguitch US UT 017 11788549 11789054 City of Moab US UT 019 11789054 11788579 City of Parowan US UT 021 11788579 11788972 City of Cedar City US UT 021 11788972 11788662 City of Nephi US UT 023 11788662 11788516 City of Kanab US UT 025 11788516 11788706 City of Delta US UT 027 11788706 11788479 City of Murray US UT 035 11788479 11788485 City of Midvale US UT 035 11788485 11788570 City of Riverton US UT 035 11788570 11788585 City of South Salt Lake US UT 035 11788585 11788791 City of Bluffdale US UT 035 11788791 11788837 City of Draper US UT 035 11788837 11788878 City of West Valley City US UT 035 11788878 11788893 City of Salt Lake City US UT 035 11788893 11788973 City of West Jordan US UT 035 11788973 11789053 City of Sandy US UT 035 11789053 11788777 City of Monticello US UT 037 11788777 11788978 City of Blanding US UT 037 11788978 11788394 City of Moroni US UT 039 11788394 11788564 City of Spring City US UT 039 11788564 11788660 City of Mount Pleasant US UT 039 11788660 11788753 City of Monroe US UT 041 11788753 11788822 City of Richfield US UT 041 11788822 11788862 City of Salina US UT 041 11788862 11788541 City of Park City US UT 043 11788541 11788655 City of Tooele US UT 045 11788655 11789025 City of Grantsville US UT 045 11789025 11788328 City of Salem US UT 049 11788328 11788369 City of Pleasant Grove US UT 049 11788369 11788495 City of Spanish Fork US UT 049 11788495 11788552 City of Santaquin US UT 049 11788552 11788588 City of Provo US UT 049 11788588 11788674 City of Payson US UT 049 11788674 11788817 City of Springville US UT 049 11788817 11788521 City of Heber US UT 051 11788521 11788722 City of Midway US UT 051 11788722 11788659 City of Washington US UT 053 11788659 11788724 City of Saint George US UT 053 11788724 11788757 City of Santa Clara US UT 053 11788757 11788818 City of Enterprise US UT 053 11788818 11788937 City of Hurricane US UT 053 11788937 11788409 City of North Ogden US UT 057 11788409 11788462 City of Roy US UT 057 11788462 11788968 City of Ogden US UT 057 11788968 11788997 City of Plain City US UT 057 11788997 11788436 City of Connell US WA 021 11788436 11788666 City of Royal City US WA 025 11788666 11788670 City of Electric City US WA 025 11788670 11788918 City of Issaquah US WA 033 11788918 11788942 City of Medina US WA 033 11788942 11788355 City of South Bend US WA 049 11788355 11788649 City of Everett US WA 061 11788649 11788345 City of Chewelah US WA 065 11788345 11788996 City of Moxee US WA 077 11788996 11788513 City of Salem US WV 033 11788513 11788557 City of Charleston US WV 039 11788557 11788646 City of Moundsville US WV 051 11788646 11788868 City of Thomas US WV 093 11788868 11788580 City of Paden City US WV 103 11788580