Search Results

Search Constraints

Start Over
Filtering by: Creator Sugrue, Dennis P. Remove constraint Creator: Sugrue, Dennis P.

Search Results

  • Data Fusion of AIS and LPMS data on the Great Lakes used to assess Maritime Transport Efficiency

    work
    Creator:
    Sugrue, Dennis P.
    Description:
    This data was collected and processed as part of ongoing research to characterize waterway infrastructure performance in the Great Lakes. These dataset enable researchers to evaluate both travel time and vessel carrying capacity in the waterway., I assembled AIS data from the MarineCadastre website for UTM Zones 15-18 for the years 2015-2017 available in csv format. I combined files for Navigation Seasons, defined as March to January and clipped data for a set of predefined features using a python code (AIS Data Processor.ipynb). The code writes the appended and clipped files to csv for a single Navigation Year. The written files are submitted here: Trimmed_NY2015_new.csv (n=13,228,824); Trimmed_NY2016_new.csv (n=18,782,779); Trimmed_NY2017_new.csv (n=16,816,603), Data fusion of AIS and LPMS used the following algorithm for a subset of 30 vessels on the waterway. Let A be the original AIS data and let B be the subset of records for vessel i within geographic feature j. The script for this analysis is attached (Maritime Data Fusion.ipynb), For Connecting Channels and select segments of the Great Lakes: 1. Subset A for vessel i. Let B_i⊆A | 2. Subset B_i in geographic feature, Gj. Let B_ij⊆B_i | 3. Select tmin for each unique date or any consecutive dates, record as vessel i arrival to feature j, b_ijt | 4. IF feature j is a harbor or lock, select tmax for each unique date or any consecutive dates, record as departure from feature j, b_ijt | 5. Calculate time elapsed between features for each vessel, For vessel passage through the Soo Locks: 1. Subset A for vessel i. Let B_i⊆A | 2. Subset B_i in geographic boundaries (46.5<Lat<46.6, -84.4<Lon<-84.3). Let C_(i,lock)⊆B_i | 3. Select tmin for each unique date or any consecutive dates, record as arrival to Soo Locks | 4. Select tmax for each unique date or any consecutive dates, record as departure to Soo Locks | 5. Calculate time delta between arrival and departure times, and The merged dataset is included here along with the raw LPMS data: Merged_Data_new.csv (n=42,021), LPMS obscured.csv (n=55,342). VesselNames have been obscured in these datasets to protect proprietary information for shipping companies.
    Keyword:
    Maritime Transportation Efficiency, Data Fusion, Waterway Performance
    Citation to related publication:
    Sugrue, D., Adriaens, P. (in review) Multi-dimensional Data Fusion to Evaluate Waterway Performance: Maritime Transport Efficiency of Iron Ore on the Great Lakes. Water Resources Research.
    Discipline:
    Engineering

  • Supply Chain data for iron ore to finished good in the U.S.

    work
    Creator:
    Sugrue, Dennis P.
    Description:
    Our work seeks to better understand the financial risks to corporate operations as a basis for exploring alternative public-private investment strategies. We applied network analysis to model financial relationships within this sector and its connectedness to primary commodities transported on the Great Lakes. The financial network maps were used to quantitatively analyze the industry risk exposure using corporate financial metrics and to query the financial interdependencies of companies relative to the Great Lakes waterway. Results demonstrate that inventory turnover ratio is a robust proxy to quantify weighted financial risks of water dependency across the entire supply chain network. All data was manually collected from the Bloomberg Terminal and FactSet which are licensed by the University of Michigan. The SPLC module in the Terminal restricts data download and information must be captured manually. All data was collected from September-November 2018.
    Keyword:
    Iron Ore, Supply Chain, Bloomberg Terminal, and Great Lakes
    Citation to related publication:
    Sugrue, Dennis, Abigail Martin, and Peter Adriaens. (under review). “Financial Network Analysis to Inform Infrastructure Investment: Great Lakes Waterway and the Steel Supply Chain.” Journal of Infrastructure Systems, American Society of Civil Engineers.
    Discipline:
    Engineering