OPSIG industry DB

The OPSIG is a special interest group focusing on railroad operations, especially as they apply to model railroads. They maintain a database of real world and fictional industries, including localities, serving railroads, and what was shipped and received. It has tens of thousands of entries, split across four text files. Doing it in this way is a great idea, as these are easy to reuse (as opposed to locking them in some proprietary format). I ran a few scripts to clean them up (convert things like B&M, BM to be BM, have four digit years), pruned out non-real-world industries, and put it in Google Fusion Tables. This allows automatic geocoding (converting "Dover, NH" to a latitude and longitude) to put industries on the map and also allows filtering. Results can be viewed as a table or a map. You can filter for just industries served by the B&M (table or map), for all industries dealing with paper, or even combined things, like all auto-related industries served by UP in California (here).

The main page for the database is here.

Note that there are some weirdnesses. Some of the geocoding is off (a few Arizona localities are placed in Mexico), some of the raw data just seems wrong (like a railroad being given an industry in a weird part of the country for that line). Points in the same locality (New York, NY) overlap each other, so it looks like each place has one or zero industries (though don't forget about filtering). Overall, though, it should be pretty useful. I made it because I wanted to look at some of the industries served by the B&M in various towns, but then I figured, why not just do the general solution, as the data are already there?

The credit for this goes to the members of the OPSIG who created and maintain this amazing database, as well as Google for its free Google Fusion Tables tool. Remember that while the database is a product of the OPSIG, this particular use of it isn't, so the blame for any oddness should go to me, not them. They are still accepting new data. I'm not going to spend a lot of time keeping this up (my hobby is model railroading, not database creation) but there are ways to add collaborators to the document to make changes.