data expansion efforts in the great lakes maritime information delivery system peter s. lindquist...
TRANSCRIPT
![Page 1: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/1.jpg)
Data Expansion Efforts in the Great Lakes Maritime Information Delivery System
Peter S. Lindquist
GLMRI Affiliates Meeting
September 23, 2010
INTERMODALTRANSPORTATION INSTITUTE
![Page 2: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/2.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
CURRENT PROJECT GOALS
To increase the volume of data in the GLMIDS Repository
To enhance network databases with new connections, attributes
To acquire, store and manage data acquired by automated methods (AIS, USACE MD+, etc.)
To furnish prepared information on project web site
To develop a new, improveddata delivery system to replace Midwest FreightView
To focus on specific com-modity movements in theregion (e.g., Coal)
![Page 3: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/3.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
CURRENT PROJECT GOALS, continued
To continue managing this comprehensive database relating: Economic activity among all sectors Regional population patterns Import and export flows Intra-regional flows System capacity among all modes Intermodal connectivity
To continue towards the development of a regional database that can support freight modeling efforts.
![Page 4: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/4.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Data Residing in Repository to DateNetwork Data:
ORNL CTA North American Highway Network
NHPN (FAF) Highway Network
Integrated Highway Network
Updated ORNL CTA North American Rail Network
North American Transportation Atlas Data (NORTAD)
BTS Intermodal Terminals (Enhanced), Ports, Airports
USACE Dock Data (Master Docks Plus Database)
USACE lock performance data (U.S. side)
FAF Zones and Centroids
Weather station data (NOAA, to approx. 60 Miles Inland)
![Page 5: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/5.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Data Residing in Repository to DateEconomic/Population Data:
US Census of Agriculture / NASS Data (County-Level)
Demographics Plus 2003 Business Counts—Tract+
US Census 2000 Long Form Database—Tract +
Geographic Data: Counties, Census Tracts, ZIP Code Areas, Congressional Districts, MSAs, Urban Areas
County-Level Employment by 3-Digit NAICS classification (Sources: BLS ES/202, County Business Patterns, supplemented with Minnesota IMPLAN Group, Inc. data)
Satellite imagery / aerial photography of dock facilities
![Page 6: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/6.jpg)
Establishments and employment by 2-6 Digit NAICS classification among counties, MSAs (Minnesota IMPLAN
Group, Inc.
Individual Establishments in 10-State MVFC study region (Dun and Bradstreet/Harris InfoSearch)
BEA gross domestic product by metropolitan area and by sector and by Year
BEA regions in ESRI Shapefile format
Coal Mine Database (Keystone, etc.)
Power Plant Database (eGRID, etc.)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Data Residing in Repository to DateEconomic/Population Data:
![Page 7: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/7.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Data Residing in Repository to Date O/D Flow Data: Import/Export Flows (GTIS), 1999+, by State, Customs Gateway FAF 2002 OD Flows (National Scale) FAF2 2007 Provisional OD Flows (National Scale)Flows across international boundaries MARAD international vessel movements & USACE Vessel
Entrances and ClearancesUSACE Waterborne Commerce Database Part III (Great Lakes) National County Commodity Flow Data
Delivery System (UIC)
![Page 8: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/8.jpg)
Data Residing in Repository to Date Traffic Flows by Link: Highway Truck Traffic Volume (AADTT) Air Freight Flows Waterborne Traffic Volumes by
Commodity (Great Lakes) Railroad Traffic Volumes
Class I Links (Public Waybill)
Transportation Facilities: Intermodal Terminals Ports Airports Rail Yards
Weigh Stations Toll Facilities Customs Stations
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Documentation
Metadata Data Dictionary Technical Documentation User Guides / Manuals
![Page 9: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/9.jpg)
Improving the documentation of existing information on the Toledoproject web page:
Manuals and related documentation for use of the system.
Formalized documentation of the contents of the database including
detailed inventory of the database
metadatatechnical appendices
Furnish secure direct access to the MWFV data viewer.
Data Delivery System: Documentation
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
![Page 10: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/10.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Project Web Site
Access at: http://maritime.utoledo.edu
![Page 11: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/11.jpg)
![Page 12: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/12.jpg)
![Page 13: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/13.jpg)
![Page 14: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/14.jpg)
![Page 15: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/15.jpg)
![Page 16: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/16.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
The Atlas of Great Lakes Maritime Commerce
![Page 17: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/17.jpg)
![Page 18: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/18.jpg)
![Page 19: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/19.jpg)
![Page 20: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/20.jpg)
![Page 21: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/21.jpg)
![Page 22: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/22.jpg)
![Page 23: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/23.jpg)
![Page 24: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/24.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Current Work in GLMIDS:Additions to the Database in Progress
Integrated Network—Great Lakes Waterway, Highway, Raillinked to Commercial Docks, Locks
Updated US Highway Network Speed / Estimated Travel Times
Toll gates / weigh stations Add ESRI Traffic Counts to integrated highway network Add ATRI Travel Time Data (by time of day, day of week) Link highways to Rail Network through Intermodal Sites
Link BEA Regions/BEA GDP Data to Public Rail Waybill Data
Encode EPA eGRID Power Plant Database, Keystone Coal MineDatabase; linkages to Rail and Waterway Networks
![Page 25: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/25.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Current Work in GLMIDS:Additions to the Database in ProgressAssign USACE Foreign Traffic Vessel Entrances and Clearances
to Network
Assign USACE Waterborne Commerce Data to Network
County-to-County Mileage and Impedance Tables: Highway Rail Water
Useful for Analytical Tools—Accessibility, Location Analysis, etc.
Automated Data Collection: AIS collection in cooperation with BoatNerd USACE Master Docks Plus Data Exchange Agreement
![Page 26: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/26.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Current Work in GLMIDS:Parallel Projects Impacting GLMIDS
FINDE: Federal Integrated Navigation Data Enhancement Automated Data Gathering for Port Calls Development of GIS Database at Docks, NPIs AIS-Data Acquisition referenced to GIS Dock Locations Joint Project with USACE, US Customs, IRS, BTS US
Coast Guard
Development of New Data Viewer to Replace ArcViewStreamlined Data ViewerUser Friendly Query FunctionsExample: National County Commodity Flow Data
Delivery System
![Page 27: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/27.jpg)
National County Commodity Flow Data Delivery System (UIC / UT Partnership)
Contents of the database consist of 43 2-digit SCTG (Standard Classification of Transported Goods) Categories
Data managed in the following formats
County-level inflow tonnage totals (kton)--all modes
County-level outflow tonnage totals (kton)—all modes
County-level combined inflow/outflow volumes
County -to-County OD flow tonnage (trucks only)
Access to the site by permission only: User Ids, Passwords, issued by University of Illinois Chicago Research Team
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
![Page 28: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/28.jpg)
National County Commodity Flow Data Delivery System
Query / Data Retrieval Functions
Data retrieved by selections on pull-down menus
Users select SCTG Codes, Inflows, Outflows, Counties
Generate Data Tables for Inflows, Outflows, OD Flows
Data tables in CSV format for import into Spreadsheets or database software
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
![Page 29: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/29.jpg)
Access provided at Web Portal http://midwestfreightdata.utoledo.edu
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
![Page 30: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/30.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
![Page 31: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/31.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
![Page 32: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/32.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
![Page 33: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/33.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Conclusions Emphasis on continued acquisition of data
Value Added within existing databases through data enhancement
Continued efforts to acquire data through automated methods
Replacement of Midwest FreightView with streamlined acquisitionsystem that provides download and basic viewing capabilities
Development of more comprehensive Atlas function on ProjectWeb Page: Maps, Enhanced Port Image Displays, Graphics, Tables
Increased focus on specific commodity movements in theregion (e.g., Coal)
Emphasis on the development of a regional database that can support freight modeling efforts
![Page 34: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/34.jpg)
GREAT LAKESMARITIME INFORMATION
DELIVERY SYSTEM
Thank you
INTERMODALTRANSPORTATION INSTITUTE
![Page 35: Data Expansion Efforts in the Great Lakes Maritime Information Delivery System Peter S. Lindquist GLMRI Affiliates Meeting September 23, 2010 INTERMODAL](https://reader037.vdocuments.us/reader037/viewer/2022110402/56649e4c5503460f94b41d1f/html5/thumbnails/35.jpg)