Office of Operations
21st Century Operations Using 21st Century Technologies

Freight and Land Use Travel Demand Evaluation: Final Report

Section 3
Topic D: Public and Private Data Sources

Key initiatives under this topic include the following:

  • Update the current listing of best data sources from NCFRP 25, Freight Trip Generation and Land Use, by building on the work done in SHRP2 C20 projects and filling gaps identified in that research.
  • Develop a national strategic plan for freight data-sharing to leverage private sector decisionmaking resources and make these more readily available to the public sector.
  • Facilitate understanding within the community of practice (including both public and private sector practitioners) of the increasingly disparate time horizons affecting goods movement decisionmaking. Explore how the private and public sectors respond to that demand with policies, pricing, and traditional and innovative approaches to increasing supply chain capacities.

Topic D also provides additional resources for consideration.

Current Listing of Best Data Sources

NCFRP Report 25 provides guidelines for sharing freight data, primarily between public and private freight stakeholders. The report recognizes the difficulties in obtaining data from private entities as well as the significant costs associated with data collection, and provides examples of how to overcome these barriers. Additionally, the report highlights 18 different public and commercial data sources that can be assessed by practitioners without restrictions (see Table 3). It should also be presented in the context of the value of blending public and private data sources as described elsewhere throughout Topic D.

Table 3: Summary of Freight Data Sources as of 2013
Database Source and URL
Airline Traffic, Airfare, and Airline On-time Data USDOT Bureau of Transportation Statistics (BTS)
Publicly available at https://www.bts.gov
Border Crossing Data USDOT BTS
Publicly available at https://www.bts.gov
Commodity Flow Survey (CFS) USDOT BTS
Publicly available at https://www.bts.gov
Freight Analysis Framework (FAF-3) USDOT FHWA
Publicly available at https://ops.fhwa.dot.gov/freight/freight_analysis/faf/faf3/netwkdbflow
Industry Trade Data and Analysis U.S. Department of Commerce International Trade Administration
Publicly available at https://www.trade.gov/data.asp
Intermodal Data and Statistics Intermodal Association of North America - Multiple report and products — some for a fee.
See https://www.intermodal.org/resource-center/data-statistics
Maritime Statistics Reports and Survey Series and Fleet Statistics USDOT Maritime Administration
Publicly available at https://www.marad.dot.gov/resources/data-statistics/
Port/Import/Export Reporting Service (PIERS) Available for a fee from Journal of Commerce at https://ihsmarkit.com/products/piers.html
Rail Waybill Sample Surface Transportation Board Publicly available at https://www.stb.gov/stb/industry/econ_waybill.html
Rail Industry Operating Statistics Association of American Railroads
https://www.aar.org/data-center/ - Multiple products — some publicly available and some only available to members
Rail Industry Reference Files RAILINC Corporation multiple products, some publicly available and some available to subscribers only at https://www.railinc.com/
State of the Trucking Industry American Trucking Associations - Only available to the subscribers.
See https://www.trucking.org/StateIndustry/Pages/default.aspx
Ton Miles of Truck Shipments by State USDOT FHWA
Publicly available at https://ops.fhwa.dot.gov/freight/freight_analysis/nat_freight_stats/docs/09factsfigures/
Transborder Surface Freight Data USDOT BTS
Publicly available at https://www.bts.gov
TRANSEARCH IHS Global Insight - Available for a fee at http://www.ihsglobalinsight.com/ProductsServices/ProductDetail838.htm
TranStats - The Intermodal Transportation Database USDOT BTS
Publicly available at https://www.transtats.bts.gov
Waterborne Commerce of the U.S. U.S. Army Corps of Engineers - Publicly available at https://www.iwr.usace.army.mil/about/technical-centers/wcsc-waterborne-commerce-statistics-center/

Source: NCFRP Report 25

Strategic Plan for Freight Shipping Data Development and Sharing

Data confidentiality is a concern voiced by shippers and carriers. Given small margins on typical freight transportation services, shippers and carriers are often cautious about giving away their competitive advantage if competing firms have access to their data. At the national level, regulations such as Title 13 of the U.S. Code directing private firm participation in the Economic Census helps ensure the relevance of the CFS. As data interests become more fine-grained, however, balancing private and public sector interests becomes more challenging. For example, the SHRP2 C20 project team working in the Albany, NY, region was able to collect data after developing a non-disclosure agreement (NDA) with each participating firm. The process of developing and executing the NDA took substantial time and effort before data collection could begin.

A national strategic plan for freight shipping data would help standardize the development of more localized yet transferable metadata. This effort would require a public-private partnership (at least in the informal sense of the term) to balance the costs (of both fiscal and proprietary natures) and benefits (in terms of smoother goods movement policy and project implementation). Conceptual elements could borrow from both institutional frameworks such as NAICS code evolution as well as industry self-promotion techniques, such as Leadership in Environmental and Energy Design certification, to find an appropriate balance between incentivizing and compelling private sector participation. This strategic plan would also need to anticipate and incorporate technological and societal changes that would keep the database sufficiently nimble over time, a subject explored further in topic matrix D.

Aligning Private Sector Shipping Needs with Public Sector Policies and Investments

Investment decisions in transportation infrastructure and services have long benefitted from robust data collection, compilation, and analysis. For the past several decades, this process has generally been led and managed by the public sector. Examples include demographic data such as those provided by the U.S. Census Bureau; travel flow information from traffic counts (both permanent stations and temporary project-level observations) and traveler surveys; and performance measures such as level of service and cost-benefit ratios. The public sector has also defined the rules and regulations for transportation system investments, ranging from National Environmental Policy Act (NEPA) impact analysis to best practices by agencies such as the American Association of State Highway and Transportation Officials, ITE, and TRB guidance. Major transportation system investments might have a useful life of several decades, so the process by which investment decisions are made has similarly valued analysis attributes such as authority, reliability, and transferability over attributes such as innovation and speed.

The information explosion discussed earlier in this report has shifted the data analytics paradigm. Recent advancements in transportation data collection have led to improved data quality, greater temporal coverage, wider geographical coverage, and differing population characteristics. New data sources, such as probe vehicles, GPS, crowd-sourced data (e.g., INRIX, HERE, Google, TomTom, Waze, etc.), Bluetooth, cellular data, and other emerging data sources could generate conventional performance measures needed for both traditional analytic methods as well as new measures for gauging factors such as reliability and resilience.

The information explosion has also illuminated the differences in evaluation timelines between transportation system providers and transportation system users. Other important factors to consider on this topic include:

Major transportation system infrastructure investments such as new roads, rail lines, and ports still have a useful life of 30 or 40 years and high capital costs that are supported in part by that lengthy amortization period.

Rolling stock such as trucks and railcars still have a useful life of 10 to 20 years, in part due to the certainty of the investment in the infrastructure they use.

Unlike infrastructure and rolling stock, the shelf life of data-intensive technologies driving market demand such as product innovations, supply chain management, product information distribution and customer feedback methods, and purchase transactions is continually shrinking and might best be measured in weeks or months rather than years.

The discrepancies between the relatively stable shelf life of the transportation system and rolling stock and that of the economic markets creates a challenge in aligning private shipper needs with public sector policies and investments. Market economies creating and using data are focused on near-term rates of return on investment; the state of the practice in the private sector today is almost certain to be obsolete in five to ten years.

Additional challenges associated with private sector data include cost, limited availability with strict use policies and NDAs, and privacy concerns. The public sector must also ensure that new and innovative data sources meet acceptable quality criteria; these include timelines, coverage, accuracy, continuity, and provenance. Despite the myriad challenges, transportation agencies negotiate with private vendors to obtain consistent, timely, quality data for planning purposes. Practitioners are bombarded with information; for example, the National Performance Management Research Data Set (NPMRDS) provides an important data resource and many State DOTs and MPOs purchase their own freight databases. However, in many cases these efforts are still insufficient to support decisionmaking on data spending.

NCHRP 49-14, Methods to Acquire Proprietary Data for Transportation Applications, will develop a synthesis of the benefits and limitations of non-traditional data for transportation applications. The project will identify available data sources at various levels (private and public sector), consider methods and tools such as data fusion techniques to apply innovative data sources to more traditional performance measure evaluation, and summarize how agencies might integrate new data sources to either complement or replace existing transportation data sets.

Truck Data Collection Survey Instruments

Additional materials for truck data collection include the development of automated data collection and interview techniques. These are described in more detail below.

Automated Vehicle Locator Resources
The Florida DOT SHRP2 C20 project on petroleum flows in southeast Florida included a summary of the strengths and weaknesses of vehicle detection technology characteristics associated with tanker truck identification. Table 4 provides excerpts from this summary to identify vehicle detection technology characteristics. A number of these methods could potentially be used to collect data on truck and freight movements.

Table 4: Excerpt of Vehicle Detection Technology Characteristics from Florida DOT SHRP2 Analysis
Technology
Definition and Operation Theory
Vehicle Classification Detecting Methods
Potential for Tanker Truck Detection
Video Image Processing Video image processor systems detect vehicles by interpreting video image and convert signals into traffic flow data. Video image processing can be trained to recognize vehicles' classification and identification based on the digital imagery that is presented. Analyze video images: can classify vehicle by length, edges, and combinations of features and sizes. High
Laser Scanner/LiDAR A transmitted pulsed or continuous light which is used to image objects, utilized three dimensional (3D) data which extracts road data from classification. Create 3D images: can classify vehicles by length, edges, shapes, features, and sizes. High
License Plate Recognition Captures photographic video or images of license plates, which are processed through a series of algorithms to capture and identify the license plate image. Analyze license plates photos or images: detect vehicle classification based on registration information. High
Transponders Detects vehicles and collect data when they pass through transponder stations. Analyze vehicle registration database: detect vehicle classification based on registration information. High
Inductive Loop A sensor capable of detecting vehicle passage and presence. There are two basic undercarriage loop classifier technologies. One uses the "signature" from existing loops to determine classification by matching the shape of that loop to expected profiles. The other uses specific types of loops to detect changes in inductance associated with wheels, and uses that information to detect and measure axles. Analyze complex information: can classify vehicles by length, axles, and loop signatures. Low
Weigh-in-Motion Detects vehicle by presence of an axle as well as the pressure put on the device. Classify vehicles by axles and weight. Low
Microwave Doppler The constant frequency signal (with respect to time) allows vehicle speed to be measured using the Doppler principle. Accordingly, the frequency of the received signal is decreased by a vehicle moving away from the radar and increased by a vehicle moving toward the radar. Vehicle passage or count is denoted by the presence of the frequency shift. Classify vehicles by length Low
Microwave Radar Vehicle detection devices that transmit electromagnetic energy from an antenna towards vehicles traveling the roadway. When a vehicle passes through the antenna beam, a portion of the transmitted energy is reflected back towards the antenna. The energy then enters a receiver where the detection is made and traffic flow data, such as volume, speed, and vehicle length are calculated. Classify vehicles by length Low
Magnetometer (two-axis fluxgate magnetometer) Passive devices that detect the presence of a ferrous metal object through the perturbation (known as a magnetic anomaly) it causes in the Earth's magnetic field. Its output is connected to an electronics unit. Classify vehicles by length Low
Piezo/Quartz Sensor An axle detection sensor embedded in the roadway, which produces a signal when an axle/tire comes across it. Classify vehicles by axles Low
Passive infrared A device whose infrared-sensitive element detects and converts the reflected and emitted energy from vehicles, road surfaces, and other objects into electrical signals. Classify vehicles by axles Low
Magnetic Detector (induction or search coil magnetometer) A device that detects changes in the Earth's magnetic field caused by the movement of a ferrous metal vehicle in or near its detection area. It is placed under or in the roadway to detect the passage of a vehicle over the sensor. These sensors generally detect only moving vehicles. Their output is connected to an electronics unit. Cannot classify vehicles N/A
Air switch/Road tube A tube installed perpendicular to traffic, in which a burst of air pressure produces an electrical signal as a vehicle's tires pass over the tube. Cannot classify vehicles N/A
Ultrasonic Transmits pressure waves of sound energy at a frequency between 25 and 50 kHz, which is above the human audible range. Most ultrasonic sensors operate with pulse waveforms and provide vehicle count, presence, and occupancy information. Cannot classify vehicles N/A
Passive Acoustic Array Sensors Measures vehicle passage, presence, and speed by detecting acoustic energy or audible sounds produced by vehicular traffic from a variety of sources within each vehicle and from the interaction of a vehicle's tires with the road. Cannot classify vehicles N/A

Source: SHRP2

Truck Data Collection Survey Techniques

The ITE Trip Generation Handbook is one of the foundational resources for this project. As described in the annotated bibliography, the ITE Trip Generation Handbook is a best practice that is periodically updated and adopted by ITE through a rigorous peer-review process. The third edition of the ITE Trip Generation Handbook covers a wide range of topics beyond goods movement. Thomas, Yarbrouh, Anderson, Harris, and Harrison (Transportation Research Record 2160, 2010, p. 163) recommended to ITE an application for a truck data collection survey. The Winston-Salem MPO SHRP2 C20 implementation assistance project in the Piedmont Triad applied this type of survey and provides a current example that would be appropriate for inclusion in the QRFM as a case study.

2017 CFS

The CFS is undertaken through a partnership between the U.S. Census Bureau and BTS. The CFS was initiated in 1993 and is conducted every five years (years ending in "2" and "7") as part of the Economic Census. The CFS produces data on the movement of goods in the United States. It provides information on commodities shipped, their value, weight, and mode of transportation, as well as the origin and destination of shipments of commodities from manufacturing, mining, wholesale, and selected retail and services establishments. The continued application of a steady approach provides both a snapshot of relatively current conditions as well as a baseline for longitudinal trendline analysis.

The CFS captures data on shipments originating from selected types of business establishments located in the 50 States and the District of Columbia. The establishments are asked to provide shipment information about a sample of their individual outbound shipments during a pre-specified, one-week period. For shipments that include more than one commodity, respondents are instructed to report the commodity that makes up the greatest percentage of the shipment's weight.

The current QRFM summarized the results of the 2002 CFS, noting that the coarse aggregation of the CFS database (the national data is aggregated into 114 zones) limits application CFS data. Since then, the CFS has been substantially disaggregated; the 2012 CFS included 3,143 zones. The 2017 CFS results are expected to be published in 2019. The content of the QRFM should be broadening to incorporate more explanatory materials. These materials would help decisionmakers and practitioners gain a more holistic perspective of the range of tools available.

Review of Freight Data Sets

Freight data collection is often fragmented and uncoordinated, and is often not well defined. Data standards can vary greatly across freight data sources, making it difficult to integrate available data. Further, Federal agencies have recently made national freight datasets available to the public; the data are typically not available on the sub-regional scale needed for effective local freight planning.

As part of the SHRP2 C20 program, the Capital District Transportation Committee (CDTC), the MPO for the greater Albany-Schenectady-Troy New York area, assembled a project team and developed a process to effectively collect, integrate, and maintain freight-related data from multiple sources, including innovative, easily obtainable private data and commonly used public databases. The project team identified existing freight data at the national, State, and local levels, and it designed and conducted data collection activities to obtain new freight data for the CDTC region. Figure 11 provides freight dataset characteristics from the Capital District study that facilitate data mining for local freight planning purposes.

Table 27: Variables Included in the Databases
No.
Database
Parameter
Industry
Frequency
Mode
Aggregation
Policy
Freight trips
Freight generation
Ton-miles
Value
Service trips
NAICS
SCTG
STCC
5 years
Yearly
Quarterly
Hourly
Types of trucks
Trucks
Rail
Water
Air
Pipeline
Multi-modal
Import/
Exports
State
County
Zip code
Census tract
Along highways
Weight limit
Landuse/
Demographic
Network
Traffic
Toll
Crashes
Publicly available data
1 Commodity Flow Survey (CFS) no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
2 FAF3 Origin-Destination no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
3 Smart location data no value no value no value no value no value no value no value 2nd version no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
4 Employment data no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
Need to be obtained from different agencies
1 511 NY data feed no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
2 Capital Region updated network no value no value no value no value no value no value no value no value 2006-2007 no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
3 Commercial Census data no value no value no value no value no value no value Periodically no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
4 HERE speed data no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
5 MIST speed and volume data no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
6 TRANSEARCH commodity flow no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
7 Economic data (in GIS format) no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
8 E-ZPass data no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
9 Oversize/overweight permitting no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
10 TRANSMIT data no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
11 Truck crash data no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
12 Truck traffic counts no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
13 Weight-In-Motion (WIM) no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
New datasets
1 GPS no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
2 In-Depth-Interviews no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value
3 FTG, FG, STA models no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value no value

Figure 11: The Capital District Study Examined Freight Data Set Characteristics that Facilitate Data Mining for Local Freight Planning Purposes

Source: CDTC

The Capital District study focused on creating a dynamic freight database that would allow for aggregation of data at the local level. The study characterizes a comprehensive list of potential freight datasets, sources, processes for obtaining data, compatibility with research, level of disaggregation, advantages, and limitations.

The study included publicly available information as well as data from shippers and carriers in the region, as well as survey and in-depth interview responses. Together, this information helped CDTC understand freight shipment patterns in the region and provided insight into the decisionmaking processes by these businesses. A major positive outcome of this project was identifying the availability of processed data that will readily support any level of aggregation. For example, the project showed that the CFS and FAF can support national-level analyses; EZ-Pass or truck count data can model interstate flows; and freight trip generation, freight generation, and service trip models can support ZIP code-level analyses. In addition to obtaining and preparing the database, the project team calibrated models to estimate the freight flows (trips, generation, and services) at the ZIP code level.

You may need the Adobe® Reader® to view the PDFs on this page.

Office of Operations