Please login first
Improving management of spatial data through spatial database
* 1 , 2 , 1 , 1
1  Faculty of Geotechnical Engineering, University of Zagreb, Hallerova aleja 7, 42000 Varaždin
2  Department of Civil Engineering, University North, 42000 Varaždin

Abstract:

Entering the European Union Republic of Croatia took over INSPIRE directive called National spatial data infrastructure. Large amount of spatial data can be found through National spatial data infrastructure Geoportal. Data is available for view or download via different services, such as web mapping service or web feature service. Although different spatial data is available, it is hard to access useful information through Geoportal. Aim of this paper is to prepare spatial database which will gather different spatial data related to environmental engineering and present different queries and visualisation of the results. Main data used is related to protected areas in Republic of Croatia, register of environmental pollutants, air quality, exploitation and research fields of mineral resources, waste management, water management etc. Alongside National spatial data, Copernicus Land monitoring service EU-DEM, digital elevation model, is used. Classification of Sentinel-2 MSI data is used to provide land cover. Remotely sensed data are used in queries where aspect, slope and land cover affect the results. Two predefined SQL queries are discussed. First query is discussing danger of landslides and second query is discussing threats from illegal landfills and affect it has on environment. Predefined SQL queries enables users to quickly access needed data, even when original data is updated. All data, database, visualization and results are presented in open access software.

Keywords: INSPIRE directive; Copernicus mission; spatial database; predifined queries; environmental engineering
Top