I’m trying to gather some information about places in the US. I want to see how many places are called Springfield for example. It doesn’t matter if it’s a large city, town or even just a place. I do have an older mapping program that will do this, and my Garmen GPS will as well. However, neither are all that great nor up to date.
I have 30-40 different place names so looking through an atlas, while it would work, would take forever. It seems that Wiki will do it, but it may not be complete and has a lot of extra stuff to go along with it. It would be nice if there was a program so if I typed in Springfield, a list came up, this is how my mapping program works.
Google seems to do it, but it also seems that I would have to type in every state to see if what I’m looking for exists.
I did this on a whim once when I had a job that required uploading zip code files to an enterprise database on a regular basis. I don’t recall the exact numbers but Springfield was one of the most common place names and found in most states. Hiowever, it wasn’t the top one. IIRC Franklin was number one and found in almost all states followed by Clinton.
According to the database, there are 806 features with “Springfield” in the name, including churches, cemetaries, streams, and schools. You can filter by feature class, and if you set it to just look for Populated Places, there are 129. If you filter by actual named political divisions (aka "civil), you get 62.
A search for “Springfield” (with feature class “populated place”) returns 129 such places. (There are only fifteen listed per page by default; click on “view & print all” to see the rest). Do not be alarmed that some of the hits aren’t listed as “Springfield.” If you click on Ellet, Ohio, for example, you’ll see ythat Springfield is a variant name.
I thought the USGS would have something like that. FTR I was using Springfield as an example as I had looked at a couple of places and it didn’t come up with the one in WV.
