You are here

Utilizing Arc Marine Concepts for Designing a Geospatially Enabled Database to Support Rapid Environmental Assessment

TitleUtilizing Arc Marine Concepts for Designing a Geospatially Enabled Database to Support Rapid Environmental Assessment
Publication TypeReport
Year of Publication2009
AuthorsIsenor, AW, Spears, TW
Tertiary AuthorsAtlantic, DR&DCanada
Document NumberDRDC Atlantic TM 2009-061
Pagination178
Date PublishedJuly 2009
InstitutionDefence R&D Canada - Atlantic
CityDartmouth, Nova Scotia
TypeTechnical Report
ISBN NumberDRDC Atlantic TM 2009-061
KeywordsArc Marine, ARc Marine data model, oceanographic data, GIS and oceanography, rapid environmental assessment, data modelling, geographic, geographic information system, GIS, ISO 19115, metadata, PostGIS, PostgreSQL
Abstract

The design of the rapid environmental assessment (REA) database version 1 was completed
under contract. The database was constructed in PostgreSQL, an open-source database
management system. The REA database was primarily used for the storage of DRDC Atlantic
environmental data. However, additional data sets from external sources were added for
bathymetry and geological data. As use of the REA database increased, it became desirable to
redesign the database to better serve the user community within DRDC Atlantic. The redesign
effort focused on the use of widely used standards and specifications for oceanographic data and
metadata management. The redesign created a complete data model in the ERwin data
modelling software for a production level database. The data model is fully documented in
terms of data type, comment fields and relationships between entities. The redesign effort also
fully documented the mapping of data from the existing REA database to the redesigned
production data model, thereby providing developers with a clear and concise progression plan.
The redesign effort also identified considerable data in the existing REA database that is not
required in the production database. Finally, a designed data classification scheme is used to
develop a user exit strategy for accessing the external data sets. This negates the need to store
external data sets within the redesigned database.

Short TitleUtilizing Arc Marine Concepts for Designing a Geospatially Enabled Database to Support Rapid Environmental Assessment
Alternate TitleUtilizing Arc Marine Concepts for Designing a Geospatially Enabled Database to Support Rapid Environmental Assessment