intermodal transportation institute … freight movement in ohio urban areas: ... intermodal...
TRANSCRIPT
Measuring Freight Movement in
Ohio Urban Areas:
Available Data Sources
Peter S. Lindquist
University of Toledo
September 14, 2010
INTERMODAL TRANSPORTATION INSTITUTE
Midwest FreightView
Great Lakes Maritime Information Delivery System
l Provides a centralized repository for regional freight data with convenient secure access
l Management of a comprehensive database relating: m Economic activity among all sectors m Regional population patterns m Import and export flows m Intra-regional flows m Intermodal connectivity
l Comprehensive, seamless, spatially registered and current data repository in a GIS framework
l Internet-Based Delivery: CITRIX MetaFrame Environment
INTERMODAL TRANSPORTATION INSTITUTE
Midwest FreightView
Great Lakes Maritime Information Delivery System
l Assembly of a regional database that can support freight modeling efforts
l Data support functions for freight analysts, public officials and policy analysts
l Projected users: m Federal, state, and local governments
m Metropolitan planning organizations (MPOs)
m Transportation Trade Groups
m University research centers
m Other public stakeholders
INTERMODAL TRANSPORTATION INSTITUTE
http://midwestfreightdata.utoledo.edu
http://maritime.utoledo.edu
Pull down menu
AADTT 2010
Iron and Steel Mills (IMPLAN) & Downbound
Crude Material Tonnage (USACE)
Midwest FreightView l Contents of Online Database
l Contents of Data Repository
l Future Additions to Repository and Online Database
INTERMODAL TRANSPORTATION INSTITUTE
Midwest FreightView Online Data
Current Network Data:
l ORNL CTA North American Highway Network
l NHPN (FAF) Highway Network
l Integrated Highway Network
l Updated ORNL CTA North American Rail Network
l North American Transportation Atlas Data (NORTAD)
l BTS Intermodal Terminals, Ports, Airports
l USACE Dock Data (Master Docks Plus Database)
l FAF Zones and Centroids
l FAF 2002 OD Flows (National Scale)
l FAF2 2007 Provisional OD Flows (National Scale)
INTERMODAL TRANSPORTATION INSTITUTE
l US Census of Agriculture / NASS Data (County-Level)
l Demographics Plus 2003 Business Counts—Tract+
l US Census 2000 Long Form Database—Tract +
l Geographic Data: Counties, Census Tracts, ZIP Code Areas,
Congressional Districts, MSAs, Urban Areas
l County-Level Employment by 3-Digit NAICS classification (Sources:
BLS ES/202, County Business Patterns, supplemented with
Minnesota IMPLAN Group, Inc. data)
l Satellite imagery / aerial photography of dock facilities
Midwest FreightView Online Data, Continued
Economic/Population Data:
INTERMODAL TRANSPORTATION INSTITUTE
l Import/Export Flows (GTIS), 1999+, by State, Customs Gateway
l Dock equipment, lock performance data—U.S. side only
l Establishments and employment by 2-6 Digit NAICS classification
among counties, MSAs and individual Establishments in 10-State
MVFC study region (Sources: Minnesota IMPLAN Group, Inc.,
Dun and Bradstreet/Harris InfoSearch)
l BEA gross domestic product by metropolitan area and
by sector and by Year
l BEA regions in ESRI Shapefile format
Data Repository Contents
Data Residing in Repository outside of MWFV
INTERMODAL TRANSPORTATION INSTITUTE
l Air Freight Flow Network (by market & month)
l Air Freight Data (T-100 1997-2008)
l MARAD international vessel movements & USACE Vessel
Entrances and Clearances
l USACE Waterborne Commerce Database Part III (Great Lakes)
l ESRI Traffic Volumes
Data Repository Contents , Continued
Data Residing in Repository outside of MWFV
INTERMODAL TRANSPORTATION INSTITUTE
l ORNL CTA North American Rail Interlining Network
l Integrated Network—Great Lakes Waterway, Highway, Rail
linked to Commercial Docks, Locks (USACE)
l Updated US Highway Network
m Speed / Estimated Travel Times
m Toll gates / weigh stations
m Add ESRI Traffic Counts to integrated highway network
m Add ATRI Travel Time Data (by time of day, day of week)
m Link highways to Rail Network through Intermodal Sites
l Link BEA Regions/BEA GDP Data to Public Rail Waybill Data
Looking Ahead: Updates, Additions, Improvements
Data Currently Being Added to Database:
INTERMODAL TRANSPORTATION INSTITUTE
l Add T100 Air Flows between Airports (by month, year)
l USACE Foreign Traffic Vessel Entrances and Clearances
l USACE Waterborne Commerce Data
l County-to-County Mileage and Impedance Tables:
m Highway
m Rail
m Water
Useful for Analytical Tools—Accessibility, Location Analysis, etc.
l Updated County Business Patterns
Looking Ahead: Updates, Additions, Improvements
Data Currently Being Added to Database:
INTERMODAL TRANSPORTATION INSTITUTE
Looking Ahead: Updates, Additions, Improvements
Data Currently Being Added to Database:
l Continue development of integrated network:
m Highway Performance Indicators
m Time-Dependent Vehicle Routing on Highway Network
l Development of New Data Viewer to Replace ArcView
m Streamlined Data Viewer
m User Friendly Query Functions
m Example: National County Commodity Flow Data Delivery System
INTERMODAL TRANSPORTATION INSTITUTE
INTERMODAL TRANSPORTATION INSTITUTE
National County Commodity Flow Data Delivery System (UIC / UT Partnership)
l Contents of the database consist of 43 2-digit SCTG
(Standard Classification of Transported Goods) Categories
l Data managed in the following formats
m County-level inflow tonnage totals (kton)--all modes
m County-level outflow tonnage totals (kton)—all modes
m County-level combined inflow/outflow volumes
m County -to-County OD flow tonnage (trucks only)
l Access to the site by permission only: User Ids, Passwords,
issued by University of Illinois Chicago Research Team
INTERMODAL TRANSPORTATION INSTITUTE
INTERMODAL TRANSPORTATION INSTITUTE
National County Commodity Flow Data Delivery System
Query / Data Retrieval Functions
l Data retrieved by selections on pull-down menus
l Users select SCTG Codes, Inflows, Outflows, Counties
l Generate Data Tables for Inflows, Outflows, OD Flows
l Data tables in CSV format for import into Spreadsheets
or database software
Access provided at Web Portal http://midwestfreightdata.utoledo.edu
INTERMODAL TRANSPORTATION INSTITUTE
INTERMODAL TRANSPORTATION INSTITUTE
INTERMODAL TRANSPORTATION INSTITUTE
INTERMODAL TRANSPORTATION INSTITUTE
Thank You
INTERMODAL TRANSPORTATION INSTITUTE