Operations Special Interest Group Rick Stern's ATSF, working the Ice Dock at Oxnard (Reefer Madness)
The Operations Special Interest Group
Focused on Realistic Prototype Operation
HomeJoin Us!About OPSIGDispatcher's Office
Our Quarterly Journal
Online ResourcesFAQs (Primer)Ops 101BibliographyBooksIndustry DatabaseInternet ResourcesOps VideosComing EventsMembers OnlyOPSIG ClothingRead the DO Article of the Quarter now!

Industry Database

Operations SIG is compiling a list of industries throughout North America for use in creating waybills for traffic moving to, from or via model railroads.

Some operators feel that offline origin/destination information is unnecessary or a distraction for crews "in the heat of" an operating session. These persons are excused at this point. If you would like to add offline, customer or commodity information to the waybills or switchlists you use to move model traffic, read on.

Currently there are about 40,000 industries in our directory (still being accumulated). Industries are predominantly actual companies located on prototype railroads, but we also include some industries on model railroads because some users enjoy including them in their routings. These are specifically identified, however, so those who prefer to exclude them can do so.

We welcome submissions of industry data from more model railroads. Ideally data can be sent by email, or single-file attachments to email, to IndustryDB@OpSIG.org (Please include "OpSIG" in the subject line). Best formats are MS Works, Excel, or Lotus 1-2-3 up to 5.0, but "text" is acceptable.

The files contain the following data for each industry ("industries" are not just factories but also grain elevators, mines, etc -- customers -- but omit freight stations, team tracks, icing facilities, etc which are "everywhere"):

1Era or approx date of facility observation (eg 50 for year 1950) - > means "after"
2Industry/company name
3City
4State (2 characters, capitalized eg OH) or province (MX=Mexico)
5Serving railroad initials; if model railroad, follow with "*"
Railroads are, to extent possible, 1950s era.

Where more than one RR serves a town and we do not know which serves the plant, all (or several) are shown prefixed by "*" Our assumption is that the industry is open to reciprocal switching. Shortlines are listed with their (Class I connections) in parentheses.

6S=ships, R=receives (predominant type of shipment) - "blank" means either S=ships or else "not sure whether S or R"

We assume inputs received may be inferred from the product produced. For example, paper mills receive pulpwood, chemicals, woodpulp, fuel, kaolin, etc. The file InputOutput.txt provides suggestions for such relationships. For paper in particular, see also PaperChemicals.txt.

7Commodity (principal product[s] shipped or received)
8STCC (commodity grouping code) if available
9where shown, "yes" means open to reciprocal switching, "no" means not open
10Source of data (from whom received)

Files are text format with tabs separating columns and should be readily downloaded and read by MS Works, Lotus, probably Excel, and word processing programs and should be easily modifiable for various waybill programs.

The following information is provided for industries on model railroads, so users know how to route traffic to/from their own lines. This is compiled in OfficialGuide.txt:

1model RR initials followed by "*"
2line number (see fields 9 & 10 below)
3railroad name - if portion of a prototype RR, fields 7-10 not needed, refer to prototype Official Guide
4owner name
5owner's location city & state
6owner email address (or phone)
7for ENTIRE railroad, extreme north or east location (eg Chicago IL)
8for ENTIRE railroad, extreme south or west location (eg Memphis TN)
9principal connecting PROTOTYPE railroads (eg SOU) - one per line, use field 2 line numbering, as many lines as needed, other data need not be repeated
10junction city for field 9 railroad (eg Carbondale)
11description of portion of 7-8 MODELED (eg Champaign IL - Carbondale IL)
12comments (eg "Dec 95 and Apr 00 MR" or "connects with all Chgo and Memphis lines")

The database consists of four files of approximately 10,000 records each. The files and states contained are as follows:

OpSigEST.txt - ME NH VT MA CT RI NY NJ PA DE MD DC MI
OpSigMWC.txt - OH IN IL WI MN ND SD NE IA
OpSigSTH.txt - VA NC SC GA FL AL MS KY TN WV MO AR LA TX OK KS plus Mexico. Some Kansas City industries show state=MK
OpSigWST.txt - WA OR ID MT WY AK CO NM UT AZ NV CA plus all Canada

We have begun an update of the text files above, and the first two files are available in Excel format:
These files have additions, but are otherwise unchanged from the original data:
OpSigCANADA.xls
OpSigWEST.xls

Dave Husman of the Yahoo! Group has made the data 'database friendly', in his words:
"I made three passes through it changing all the years to 4 digit years, identifying commodities with multiple listings, separating the listings into individual records, adding a few alternative listings and finally correcting and normalizing commodity names."
DHCanada.xls
DHWest.xls

Peter White, owner of Shenandoah Software (ShenWare), has created the freeware program IndMan which can be used to read, sort, and select from the OpSig files (after you download them) in order to customize an industries database for your own railroad. We suggest you also download OfficialGuide.txt and InputOutput.txt as IndMan can display these files. You will notice that ShenWare also offers demos of its very useful programs Waybills (which uses these or your industry files for the obvious purpose) and MiTrains, which can be used to inventory your freight cars (and other things) and generate car cards.

We welcome corrections and additions, especially industries on other operating model railroads. Note that this is only an exchange of information and we are not planning or offering any physical exchange of cars. I look forward to hearing from you.

IndustryDB@OpSIG.org
Operations SIG

PS -- For in-depth source of Appalachian coal mines, see http://www.spikesys.com/Trains/app_coal.html

For details including photos of thousands of grain elevators on contemporary BNSF see http://www.bnsf.com/markets/agricultural/elevator/

A list of "all" current UP shortline connections is at http://www.uprr.com/customers/shortline/lines/ Each one has a description, many including specific customer names.

Current UP industries at reciprocal switching locations are listed at http://www.uprr.com/customers/shortline/recipswitch.shtml


Page updated: 2010 June 11
To Top of Page Copyright 2014, OPSIG Contact Us