Comparison of two datasets on buildings in the Republic of Croatia

Abstract

Cilj ovog rada bio je analizirati kvalitetu i razlike između dvaju izvora podataka o zgradama –službene Temeljne topografske baze (TTB) i otvorenih podataka iz OpenStreetMap-a (OSM). U radu se prikazuje važnost geoprostornih podataka i baze podataka u kojima se nalaze, s posebnim naglaskom na primjenu u prostornim analizama i upravljanju. Naglašena je uloga geoprostornih baza poput SpatiaLite-a, te važnost prostornog indeksiranja u SQL upitima. Analiza je provedena po županijama u Republici Hrvatskoj, pri čemu su uspoređeni položaji, obuhvat i geometrijska preciznost objekata u oba skupa podataka. Pritom je korišten niz GIS alata za obradu i usporedbu, uključujući prostorno preklapanje i izračun razlika površina. Identificirane su razlike između dva izvora i koji su uzroci tim razlikama. Također se raspravlja o primjeni i izazovima rezultata, a na kraju rada se iznose zaključci doneseni na osnovu dobivenih rezultata programskog zadatka.The aim of this paper was to analyze the quality and differences between two sources of building data – the official Topographical Database (TTB) and open data from OpenStreetMap (OSM). The paper presents the importance of geospatial data and the databases in which they are located, with a special emphasis on their application in spatial analysis and management. The role of geospatial databases such as SpatiaLite is emphasized, as well as the importance of spatial indexing in SQL queries. The analysis was conducted by counties in the Republic of Croatia, comparing the positions, coverage and geometric precision of objects in both data sets. A number of GIS tools were used for processing and comparison, including spatial overlap and calculation of area differences. The differences between the two sources and the causes of these differences were identified. The application and challenges of the results are also discussed, and at the end of the paper, conclusions drawn based on the results of the program task are presented