Přejít k obsahu


Using Oracle Spatial towards the effective handling of spatial data of cadastre

Citace: [] JANEČKA, K. Using Oracle Spatial towards the effective handling of spatial data of cadastre. 2010., ISBN: 978-80-248-2171-9,
Druh: Zaniklé typy
Jazyk publikace: eng
Anglický název: Using Oracle Spatial towards the effective handling of spatial data of cadastre
Rok vydání: 2010
Autoři: Ing. Karel Janečka Ph.D.
Abstrakt EN: The aim of the article is to show the possible usage of Oracle Spatial for storing of spatial data, concretely the digital cadastral map, towards the effective spatial data handling. Digital cadastral map is stored in the Cadastral Information System which is maintained by the Czech Office for Surveying, Mapping and Cadastre in Prague (COSMC). As it was already shown the actual physical data model of the Cadastral Information System for storing of vector spatial data has some important shortcomings. These shortcomings do not allow the using of the stored data in some types of web applications, e.g. in applications when we prefer a fast retrieving and the visualization of all requested data. On this account I tried to find out whether the use of Oracle Spatial data structures would be more appropriate. Concretely I tested the object-relational data model (which uses the SDO_GEOMETRY object data type for storing the geometry) and the winged-edge structure (which uses the SDO_TOPO_GEOMETRY data type). The software for transformation of spatial data was created. This software allows transform source data coming from the Cadastral Information System to the mentioned Oracle Spatial data structures. After importing of transformed data into Oracle database the time needed for selecting of spatial data by query window was measured. Also the space for storing of spatial data was monitored. In article is shown that if we have data stored by using of the SDO_GEOMETRY object data type that the data are selected from the database much faster than if we use for storing of spatial data SDO_TOPO_GEOMETRY data type. As well a less of disc space is required in the case of storing digital cadastral map by using of the SDO_GEOMETRY data type. Due to the INSPIRE initiative there is a strong demand on the effective way of storing and retrieving of mentioned spatial cadastral data in a web environment. Mainly for the purpose of accessing cadastral data via WFS or WMS so called Publication database has been created at COSMC. The creation of the Publication database has been based on the results mentioned in this paper which means that the spatial data are stored through the use of the SDO_GEOMETRY object data type.
Klíčová slova

Zpět

Patička