Standard implementation of object-relational topographic databases with 3d complex model
Standard implementation of object-relational topographic databases with 3d complex model
Anno Pubblicazione  
2010 Proceeding  

Atti di: INSPIRE Conference 2010, 22-25 giugno Krakow, Poland

Autori: Corongiu M., T. De Filippis, L. Rocchi, L. Bottai

Abstract

Spatial information dissemination and sharing, according to the interoperability paradigm, is the core concept of Spatial Data Infrastructure. It is very important to structure geographic information according to specific standards and to guarantee easy updating to meet innovations in Information Technology. The use of geographical standards and technological platforms in Information System development is the main goal of this study in order to allow general purpose geographic database management and/or specific applications.
This paper presents the preliminary results of the AR.DI.TO.(DIgital TOpographic ARchives for sustainable mobility) research project, funded by Tuscany Regional Government in the framework of the strategic “Regional Planning for mobility and logistic” where the geographic infrastructure and information system have been identify as key elements for an integrated mobility.
AR.DI.TO.’s overall objectives are to investigate a geographical data reference infrastructure able to build integrated communication support for others specific territorial application.
The real capability of geographic standard implementation ISO TC/211 (IS 19101, 2002; TS 19103, 2005; IS 19109, 2005; IS 19118, 2005; IS 19136, 2007; HMMG, 2009) Open Geospatial Consortium (OGC, 2002) and INSPIRE Implementing Rules (INSPIRE, 2009), are tested on Siena municipality Topographic DataBase (TDB) (Corongiu et al., 2006). Siena TDB is based on TDB IntesaGIS Italian Specification implementation. The choice of a real dataset is focused on study in depth complex and 3D spatial feature adoption within an object-relational database where the high level of detail is framed in the national/regional SDIs.
The main activities have been addressed to UML modeling and to apply UML-GML transformation for Application Schemas compliant with INSPIRE Drafting Team Specification and Theme contents (INSPIRE, 2009). According to ISO/TC 211 and INSPIRE recommended environments, we have adopted Enterprise Architect (EA) as case modeler, than Siena TDB model has been carry out in relation with the HMMG ISO TC/211 (ISO TC/211, 2009) schemas. After that the UGAS ShapeChange tool (UGAS, 2008) has been used from UML to GML schema transformation. At this level the main problem was to describe the 3D data and the no simple feature spatial components of DB objects. About the 3D data model, we have a more simple structure than a Boundary-Representation model (B-Rep). The approach has been addressed to solve the 3D data description in an object-relational DB. The advantage is the capability to model 3D components for possible B-Rep evolution and at the same time to manage a DB not only for representation task like 3D City model.
During the physical database implementation main steps have been:
- Definition of Siena TDB UML model and export XMI schema using EA.
- GML schema generation from the former XMI using ShapeChange Java application.
- Development of a specific Java procedure to generate the physical database schema from GML3 file.
- Development of an ad hoc Java application to re-mapping data from original Siena TDB to new INSPIRE compliant TDB.
Moreover the Siena TDB and INSPIRE data models have been compared in order to evaluate the mapping translation process.
The preliminary results using Open Source solutions as PostgreSQL/PostGIS for spatial data management and customized procedures in Java language, suggest the feasibility of both the physical database implementation and the INSPIRE model migration compliant with standard geographic approach.