Utilizing Arc Marine concepts for designing a geospatially enabled database to support rapid environmental assessment

PDF

Authors
  1. Isenor, A.W.
  2. Spears, T.W.
Corporate Authors
Defence R&D Canada - Atlantic, Dartmouth NS (CAN);FISHERIES AND OCEANS CANADA, QUEBEC QUE (CAN);BEDFORD INST OF OCEANOGRAPHY, DARTMOUTH NS (CAN)
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 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.

Il y a un résumé en français ici.

Keywords
rapid environmental assessment;data modelling;Arc Marine;PostgreSQL;geographic metadata;geographic information system;GIS;PostGIS;ISO 19115
Report Number
DRDC-ATLANTIC-TM-2009-061 — Technical Memorandum
Date of publication
03 Jul 2009
Number of Pages
178
DSTKIM No
CA032823
CANDIS No
532043
Format(s):
Electronic Document(PDF)

Permanent link

Document 1 of 1

Date modified: