Please use this identifier to cite or link to this item:
Authors: Charneca, N.
Issue Date: Oct-2007
Series/Report no.: RELATÓRIO 314/2007 – NTI
Abstract: The major goals of this traineeship was the development and implementation of a centralized, spatially continuous geospatial database structure to store, manage, edit and distribute the geographic reference data of Article 3 of the Water Framework Directive (WFD-Art3). Based on the ISO 191034, ISO191105, and OGC-GML6 specifications, a Feature Catalogue and a Conceptual Data Model (CDM) were developed to describe all object classes, attributes and relationships that were presented in previously established database. The CDM was created with a CASE-tool, where UML class diagrams were developed to describe all features (geographic and non-geographic). Next, the CDM was translated to an Esri’s geodatabase model, specifying the UML classes according with this specification. Tagged values were used to define class parameters, and domains of values were established to help data validation. Finally, the resulting Logical Data Model (LDM) was used to create the physical model of the geospatial database. For testing the implementation of the physical data model, a MS Access database, an ESRI file geodatabase, and an Oracle Spatial database, were used. The document is structured into nine sections, with the aim to explain in detail both the knowledge and technology behind a geospatial data model design and implementation. It starts with an introduction describing the context on which this work was developed. The second, third, fourth, and fifth sections summarize the theoretic and technological aspects that support the geospatial data modelling process. The sixth section is one of the most important and describes the geospatial database construction process regarding technical and technological aspects that should be taking into account to construct and implement a geospatial data model. The seventh section is dedicated to database platforms and database management systems where the implementation of the geospatial database structure was tested. The eighth section is dedicated to the data loading tests made in several database platforms. After these sections some final remarks and future developments are presented and described, as well as the bibliography. The document is also complemented with fourteen annexes and a CD-Rom containing all files used and produced in the context of this work.
Description: Este registo pertence ao Repositório Científico do LNEC
Appears in Collections:DHA/GTI - Relatórios Científicos

Files in This Item:
File Description SizeFormat 
Rel314_07.pdf2.52 MBAdobe PDFView/Open

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.