A Geo-database for Potentially Polluting Marine Sites and Associated Risk Index
|Title||A Geo-database for Potentially Polluting Marine Sites and Associated Risk Index|
|Degree and Program||Master of Science in Ocean Engineering with an Ocean Mapping Option|
|Number of Pages||284|
|University||University of New Hampshire|
|Location||Durham, NH, USA|
|Keywords||GML Application, IHO S-100 Data Model, PPMS, Quality Symbol, Risk Index, Shipwrecks|
The increasing availability of geospatial marine data provides an opportunity for hydrographic offices to contribute to the identification of “Potentially Polluting Marine Sites” (PPMS).
To adequately manage these sites, a PPMS Geospatial Database (GeoDB) application was developed to collect and store relevant information suitable for site inventory and geo-spatial analysis. The benefits of structuring the data to conform to the Universal Hydrographic Data Model (IHO S-100) and to use the Geographic Mark-Up Language (GML) for encoding are presented. A storage solution is proposed using a GML-enabled spatial relational database management system (RDBMS). In addition, an example of a risk index methodology is provided based on the defined data structure. The implementation of this example was performed using scripts containing SQL statements.
These procedures were implemented using a cross-platform C++ application based on open-source libraries and called PPMS GeoDB Manager.