Implementation of the rapid environmental assessment production database

PDF

Authors
  1. Mayrand, M.
Corporate Authors
Defence R&D Canada - Atlantic, Dartmouth NS (CAN);OODA Technologies Inc., Montreal, QUE. (CAN)
Abstract
This contract deals with the construction of the redesigned Rapid Environmental Assessment (REA) database. The data model, as described in the report Utilizing Arc Marine concepts for designing a geospatially enabled database to support rapid environmental assessment [1] was implemented. SQL scripts were constructed for porting the data from the initial READBv3b to the new REA Production database. A user interface for executing these SQL scripts was also created. Functionality to validate the porting process was also included. A user-exit was created for accessing the ETOPO2 bathymetric data located in an external NetCDF file. This report contains the details of the porting process, all the instructions for using the user interface, the SQL scripts code, and finally a list of recommendations and possible tasks for future improvements.

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

Keywords
Database;PostgreSQL;Rapid Environmental Assessment;REA
Report Number
DRDC-ATLANTIC-CR-2010-123 — Contract Report
Date of publication
01 Oct 2010
Number of Pages
132
DSTKIM No
CA046325
CANDIS No
806712
Format(s):
Electronic Document(PDF)

Permanent link

Document 1 of 1

Date modified: