In this paper we will discuss early progress to unify all dredging data from various USACE archival systems, along with supporting data from USGS and NOAA, to produce a single operational overview of USACE historical dredging activity.
In order to study scalability of integration and visualization of dredging data the team unified all dredging related data for the Galveston Bay and Houston shipping channel using Python libraries: Pandas, Matplotlib and Jupyter Notebooks. This pilot study showed the value of unifying all related data as the impact of major hurricane and flooding events was evident in dredging surveys, but also showed scaling problems as processing and visualization slowed dramatically as more data was considered.
In order to approach integration and visualization of all dredging data for coastal and inland river United States a more scalable solution was needed. After the case study the team moved to code that utilized automated parallelization and chunking with Dask, plotting using Geoviews, a part of the Pyviz family of Bokeh extensions, and Datashader, a python library that samples huge out of memory datasets to produce a view-optimized heat map. With this scalable compute and visualization architecture the team was able to unify more than half a billion data items into a single comprehensive view of USACE dredging activity.