WIXLIB

2015SURFACE TRANSPORTATION BOARDCARLOAD WAYBILL SAMPLEREFERENCE GUIDESeptember 1, 2017Business Services

TABLE OF CONTENTSSECTION 1Summary of 2015 Waybill Processing. 1Waybills of US, Canadian & Mexican Origin . 4Waybills of US Origin. 9Waybills of Canadian Origin . 14Waybills of Mexican Origin . 19SECTION 2Error Analysis and Corrective Action . 242015 Reporting Railroads . 33Proxy Equipment Types for the 2015 Carload Waybill Sample . 34SECTION 3Data Exceptions . 35Railinc Waybill Correction Process . 35Railroad-Wide Corrections. 36Contract Rate Flag . 37TTX Train Assignments . 37SECTION 42015 Waybill Record Layouts and Waybill References . 38900-Byte STB Waybill File Record Layout . 39900-byte STB Waybill Data Element Descriptions . 44Surface Transportation Board (STB) Codes . 79Surface Transportation Codes (BEA County Listing) . 812015 Surface Transportation Board Public Use Waybill 247-Byte Record Layout . 992015 Surface Transportation Board Public Use Waybill 247-Byte Record Data Element Descriptions. 101STCC Headers . 112Surface Transportation Board Car Types . 164Umler Field Descriptions—Data Layout Detail . 165AAR Equipment Type Code . 169CS54 Group Codes . 174SECTION 52015 Waybill Miling Methodology . 175Overview . 176Step 1: Match Waybill Data to Railinc Event Repository Data . 177Step 2: Utilize Waybill Pattern Matching. 181Step 3: Utilize Enhanced Waybill Routing Logic . 182Step 4: Final Processing . 182Step 5: Apply Shortline Miles to the Final File . 183Appendix A: The Carload Waybill Statistics: Usefulness For Economic Analysis* . 185The Carload Waybill Statistics: Usefulness For Economic Analysis . 185Appendix B: Train II . 198Appendix C. 199References. 204LIST OF TABLES AND FIGURESTable 1-1. Standard Transportation Commodity Code Major Industry Group Numbers . 3Table 1-2. 2015 Waybill Sample—US, Canada & Mexico (Carloads, Revenue, and Tonnage by STCC Code) . 4Table 1-3. Carload 3-Year History from Waybill Samples—US, Canada & Mexico (by STCC Code) . 5Table 1-4. Revenue 3-Year History from Waybill Samples—US, Canada & Mexico (by STCC Code) . 6Table 1-5. Tonnage 3-Year History from Waybill Samples—US, Canada & Mexico (by STCC Code) . 7Figure 1-1. Top Six Commodity Groups and All Others—for US, Canada, & Mexico (3-Year History by Carloads,Revenue, and Tonnage) . 8Table 1-6. US Origin 2015 Waybill Sample—Carloads, Revenue, and Tonnage (by STCC Code) . 9iBusiness Services Division

Table 1-7. US Origin Carload 3-Year History from Waybill Samples (by STCC Code) . 10Table 1-8. US Origin Revenue 3-Year History from Waybill Samples (by STCC Code) . 11Table 1-9. US Origin Tonnage 3-Year History from Waybill Samples (by STCC Code) . 12Figure 1-2. US Origin Top Six Commodity Groups and All Others (3-Year History by Carloads, Revenue, andTonnage) . 13Table 1-10. Canadian Origin 2015 Waybill Sample (Carloads, Revenue, and Tonnage by STCC Code) . 14Table 1-11. Canadian Origin Carload 3-Year History from Waybill Samples (by STCC Code) . 15Table 1-12. Canadian Origin Revenue 3-Year History from Waybill Samples (by STCC Code) . 16Table 1-13. Canadian Origin Tonnage 3-Year History from Waybill Samples (by STCC Code) . 17Figure 1-3. Canadian Origin Top Six Commodity Groups and All Others (3-Year History by Carloads, Revenue, andTonnage) . 18Table 1-14. Mexican Origin 2015 Waybill Sample (Carloads, Revenue, and Tonnage by STCC Code) . 19Table 1-15. Mexican Origin Carload 3-Year History from Waybill Samples (by STCC Code) . 20Table 1-16. Mexican Origin Revenue 3-Year History from Waybill Samples (by STCC Code) . 21Table 1-17. Mexican Origin Tonnage 3-Year History from Waybill Samples (by STCC Code) . 22Figure 1-4. Mexican Origin Top Six Commodity Groups and All Others (3-Year History by Carloads, Revenue, andTonnage) . 23Table 2-1. Umler Error Codes and Messages . 25Table 2-2. Proxy Equipment Types—2015 Carload Waybill Sample . 34Table 4-1. 900-Byte STB Waybill File Record Layout . 39Table 4-2. 900-Byte Waybill File Record Data Element Descriptions . 44Table 4-3. Revised Intermodal Service Plan Code Reporting . 45Table 4-4. STB BEA Codes. 79Table 4-5. Surface Transportation Codes (BEA County Listing) . 81Table 4-6. 247-Byte STB Public Use Waybill File Record Layout. 99Table 4-7. 247-Byte STB Public Use Waybill Data Element Descriptions . 101Table 4-8. Revised Intermodal Service Plan Code Reporting . 102Table 4-9. STB Car Types . 164Table 4-10. Umler Field Descriptions–Data Layout Detail . 165Figure 4-1. U.S. Census Bureau Regions . 170Figure 4-2. U.S. Census Bureau Region Map . 171Table 5-1. Three Step Methodology . 176Table 5-2. A Summary of the SOT and EOT Match Types . 178Table 5-3. Waybill Route vs. Event Route . 179Table 5-4. Example with Mileage Assignment. 180iiBusiness Services Division

SECTION 1SUMMARY OF 2015 WAYBILL PROCESSINGRailinc has collected and processed 666,406 waybills for inclusion in the 2015 Carload WaybillSample. Of this total, 666,406 (100 percent) were submitted electronically. This 2015 figure is12 waybills higher than 2014 levels.As of the June 1, 2016 cutoff date for processing the 2015 Sample, there were no latereporting roads.*Table 1-2 provides a detailed breakdown of the total 2015 Waybill Statistics by two-digitStandard Transportation Commodity Code (STCC). Both raw and factored-to-population data forcarloads, tonnage, and line-haul revenue are provided, in addition to a count of the number of waybillsfrom which the data was derived.Table 1-3 provides a Three Year (2013–2015) Carload History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC).US, Canadian and Mexican Origins.*Table 1-4 provides a Three Year (2013–2015) Revenue History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC).US, Canadian and Mexican Origins.Table 1-5 provides a Three Year (2013–2015) Tonnage History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC).US, Canadian and Mexican Origins.Figure 1-1provides graphical views of the three-year history of the top six commodity groups and all others.Trending per STCC can be seen across those years.*Table 1-6 provides a breakdown similar to that of Table 1-2, for 2015 Waybills withUnited States origins only. U.S. origins accounted for 631,574 originated waybills (94.8%percent of those sampled).Table 1-7 provides a Three Year (2013–2015) Carload History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC). US Origins Only.*Table 1-8 provides a Three Year (2013–2015) Revenue History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC). US Origins Only.Table 1-9 provides a Three Year (2013–2015) Tonnage History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC). US Origins Only.Figure 1-2 provides graphical views of the three-year history of the top six commodity groupsand all others. US origins only. Trending per STCC can be seen across those years.*Table 1-10 provides a breakdown similar to that of Table 1-2, for 2015 Waybill trafficfor Canadian originations only. Canadian originations were a smaller percent of the total samplethan in 2014, accounting for 32,561 originated waybills, 4.89% of the total sample.Table 1-11 provides a Three Year (2013–2015) Carload History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC). Canadian Origins Only.*Table 1-12 provides a Three Year (2013–2015) Revenue History from Waybill Statistics by1Business Services Division

two-digit Standard Transportation Commodity Code (STCC). Canadian Origins Only.Table 1-13 provides a Three Year (2013–2015) Tonnage History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC). Canadian Origins Only.Figure 1-3 provides graphical views of the three-year history of the top six commodity groupsand all others. Canadian origins only. Trending per STCC can be seen across those years.*Table 1-14 provides a breakdown similar to that of Table 1-2, for 2015 Waybill traffic forMexican originations only. Mexican originations were a slightly larger percent of the total sample than in2014, accounting for 2,269 originated waybills, 0.3% of the total sample.Table 1-15 provides a Three Year (2013–2015) Carload History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC). Mexican Origins Only.*Table 1-16 provides a Three Year (2013–2015) Revenue History from Waybill Statistics bytwo-digit Standard Transportation Commodity Code (STCC). Mexican Origins Only.Table 1-17 provides a Three Year (2013–2015) Tonnage History from Waybill Statistics by twodigit Standard Transportation Commodity Code (STCC). Mexican Origins Only.Figure 1-4 provides graphical views of the three-year history of the top six commodity groupsand all others. Mexican Origins Only. Trending per STCC can be seen across those years.*Railroads are permitted to “mask” contract revenue with a calculated figure.Because these figures may not represent actual revenue, use of this revenue data in any typeof comparison may lead to wrong or misleading results.2Business Services Division

Table 1-1. Standard Transportation Commodity Code Major Industry Group NFarm ProductsForest ProductsFresh Fish or Other Marine ProductsMetallic OresCoalCrude Petroleum, Natural Gas or GasolineNonmetallic Minerals; except FuelsOrdnance or AccessoriesFood or Kindred ProductsTobacco Products; except Insecticides—see Major Industry Group 28Textile Mill ProductsApparel, or Other Finished Textile Products or Knit ApparelLumber or Wood Products; except Furniture—see Major Industry Group 25Furniture or FixturesPulp, Paper or Allied ProductsPrinted MatterChemicals or Allied ProductsPetroleum or Coal ProductsRubber or Miscellaneous Plastics ProductsLeather or Leather ProductsClay, Concrete, Glass or Stone ProductsPrimary Metal Products, including Galvanized; except Coating or other Allied Processing—seeMajor Industry Group 34Fabricated Metal Products; except Ordnance—see Major Industry Groups 19, 35, 36 or 37Machinery; except Electrical—see Major Industry Group 36Electrical Machinery, Equipment or SuppliesTransportation EquipmentInstruments, Photographic Goods, Optical Goods, Watches or ClocksMiscellaneous Products of ManufacturingWaste or Scrap Materials Not Identified by Producing IndustryMiscellaneous Freight ShipmentsContainers, Carriers or Devices, Shipping, Returned EmptyMail, Express or Other Contract TrafficFreight Forwarder TrafficShipper Association or Similar TrafficMiscellaneous Mixed ShipmentsSmall Packaged Freight ShipmentsHazardous WastesHazardous MaterialsBulk Commodity Shipments in Boxcars3Business Services Division

Waybills of US, Canadian & Mexican OriginTable 1-2. 2015 Waybill Sample—US, Canada & Mexico (Carloads, Revenue, and Tonnage by STCC Code)2015Estimates for Total Population2-Digit ,084,427Percent 6.4%0.4%0.1%8.4%0.0%100.0%Total 65,083,88092,872,78212,501,825,2870 88,740,165,1864Percent ofPopulationTotal ,076,565,480Percent .2%0.1%0.1%10.5%0.0%100.0%Business Services Division

Table 1-3. Carload 3-Year History from Waybill Samples—US, Canada & Mexico (by STCC Code)Carload Estimates for Total Population2-Digit 35363738394041424344454647484950TOTALS2015Total 18,3553,015,78436,084,4272014Percent 6.4%0.4%0.1%8.4%0.0%100.0%Total 27,5702,969,03820036,697,6305Percent 5.9%0.4%0.1%8.1%0.0%100.0%2013Total 6027,5522,697,95224035,044,923Percent 6.1%0.4%0.1%7.7%0.0%100.0%Business Services Division