Naslov
Improving management of spatial data through spatial database

Autori
Kranjčić, Nikola ; Đurin, Bojan ; Dogančić, Dragana ; Plantak, Lucija

Vrsta, podvrsta i kategorija rada
Radovi u zbornicima skupova, cjeloviti rad (in extenso), znanstveni

Izvornik
Environmental Sciences Proceedings / - , 2021, 1-6

Skup
3rd International Electronic Conference on Geosciences (IECG 2020)

Mjesto i datum
Basel, Švicarska, 07.12.2020. - 13.12.2020

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
INSPIRE directive ; Copernicus mission ; spatial database ; predifined queries ; environmental engineering

Sažetak
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.

Izvorni jezik
Engleski

Znanstvena područja
Geodezija, Interdisciplinarne tehničke znanosti, Informacijske i komunikacijske znanosti

POVEZANOST RADA