My cartographic file parser is working the way I want it to now. There are four total files that describe states and counties for all 50 states, and two files for each state that describe cities and two files for each state that describe zip codes. I've parsed all of the state and county data, and have parsed 13 states worth of cities and zip codes. Those 14 states include Minnesota, Wisconsin, Michigan, North Dakota, South Dakota, Iowa, Montana, Idaho, Washington, Illinois, Missouri, Indiana, Ohio, and Nebraska.
Some interesting stats so far:
- 21,018 unique boundaries have been imported (a state, city, county, or zip code)
- 2,737,277 individual latitude and longitude points have been imported
- Alaska has the greatest number of total points (13,756)
- Washington County in Oregon has the second greatest number of total points (10,436)
- The city with the geratest number of points is Columbus, OH (2,393)
Greatest number of points by state:
- Alaska (13,756)
- Texas (6913)
- Michigan (5254)
- Minnesota (5192)
- West Virginia (4929)
Fewest number of points by state:
- Wyoming (522)
- Utah (570)
- Delaware (589)
- Colorado (601)
- Rhode Island (688)
Greatest number of points by city:
- Columbus, OH(2393)
- Joliet, IL (1326)
- Springfield, IL (1261)
- Dayton, OH (1168)
- Decatur, IL (1052)
I guess either the data collector who did Illinois and Ohio was very detail oriented, or cities in those states just have complex boundaries :)
Fewest number of points by city:
- Lithium, MO (5)
- McGrath, MN (6)
- Urbank, MN (6)
- Cordova, NE (6)
- 19 others tied at 6
Other notables:
- Madison, WI (986)
- Rochester, MN (554)
- Minneapolis, MN (235)
- Duluth, MN (264)
- Hennepin County (473)