Vzpostavitev prostorskega podatkovnega skladišča na primeru občine Bovec za potres 2004 : diplomska naloga

Šušteršič, Katja (author), Podobnikar, Tomaž (mentor)

Poznavanje zmožnosti prostorskih podatkov vodi do uspešnega poslovanja organizacij. Pri naravnih nesrečah, kot je potres, je potreba po hitrem in učinkovitem medsebojnem delovanju različnih deležnikov. Po potresih leta 1998 in 2004 je v Občini Bovec prihajalo do neusklajenosti med cenilci, kar je povzročilo dodatno delo pri obdelavi podatkov. Podpora rešitvi v takšnih primerih je uvedba usklajenega podatkovnega skladišča. Izvedbo polnjenja podatkovnega skladišča omogoča postopek ETL (angl. extract, transform, load), ki obsega aktivnost izbora, preoblikovanja in dostave podatkov. Bistvo prostorskega ETL-orodja je v izmenjavi prostorskih podatkov v geografskih informacijskih sistemih (GIS) med različnimi uporabniki in lastnost, da lahko dane podatke pregledno uporabljamo. Takšno podatkovno skladišče lahko uporabnikom nudi pregled nad časovnimi spremembami za posamezne stavbe, prostorskim načrtovalcem pa podlago za načrtovanje občinskih prostorskih načrtov. V diplomski nalogi izvedemo poenotenje nehomogenih podatkovnih skladišč, zbranih iz različnih institucij po metodi ETL. Uporabili smo prostorsko ETL-orodje FME Desktop v ArcGIS-u, ki omogoča vnos podatkov različnih formatov v programsko okolje, vsebuje bogato zbirko pretvornikov, ki omogočajo preoblikovanje podatkov in njihovo dostavo v končno podatkovno skladišče. Uporabnost novonastalega podatkovnega skladišča smo preverili za potres na Bovškem leta 2004. Uporabili smo analitična orodja ArcGIS za ugotavljanje vpliva geološke podlage na poškodovanost stavb. Poizvedovali smo po opisnih in lokacijskih atributih ter analizirali primernost tal za gradnjo. S to študijo na primeru smo pokazali fleksibilnost prostorskega ETL, ki se je izkazalo tudi za močno orodje pri urejanju in analizi prostorskih podatkov. Na podatkih poškodovanosti stavb in drugih dejavnikov (npr. leto izgradnje in material stavbe) za en sam potres, smo z relativno majhno zanesljivostjo potrdili vpliv geološke podlage na višino ocenjene škode.

• Language: Slovenian
• Keywords: geodezija, diplomska dela, UNI, podatkovno skladišče, postopek ETL, GIS, medopravilnost, potres, geološka podlaga, prostorske analize
• Work type: Undergraduate thesis
• Typology: 2.11 - Undergraduate Thesis
• Organization: FGG - Faculty of Civil and Geodetic Engineering
• Place of publishing: Ljubljana
• Publisher: [K. Šušteršič]
• Year: 2012
• Number of pages: XVI, 58 str.
• PID: 20.500.12556/RUL-32693
• UDC: 550.34:681.3(1-22)(497.4Bovec)(043.2)
• COBISS.SI-ID: 6121569
• Publication date in RUL: 10.07.2015

Secondary language

• Language: English
• Title: Building a spatial data warehouse concerning the 2004 Bovec municipality earthquake

Abstract

Good knowledge of spatial data applications leads to successful business organizations. In the event of natural disasters such as earthquakes, interoperability between different organizations is necessary for fast and efficient action of different stakeholders. There were many occurrences of discrepancies amongst appraisers’ damage evaluations after the 1998 and 2004 Bovec municipality earthquakes, which consequently led to additional work in data processing. In such cases, building a coordinated data warehouse can greatly assist solving these problems. Implementing a data warehouse is made possible by the ETL process, which extracts, transforms and loads data. The basic functions of the spatial ETL tool are exchanging information in the geographical information system (GIS) between different users, and the ability to transparently use the given data. A newly made data warehouse also provides users an overview of the chronological developments for each building, and offers land planners the basis for the design of municipal spatial plans. In this thesis, a unification of non-homogenous data warehouses, collected from various institutions with the ETL process, is accomplished. To achieve this, the spatial ETL tool FME Desktop is used in ArcGIS, which allows entry of different data formats into the software environment and contains a rich collection of converters that enable the transformation of data and their delivery to the final data warehouse. The applicability of the newly made data warehouse concerning the 2004 Bovec earthquake is then examined. ArcGIS analytical tools are used to assess the impact and effect geological basis have on the damage done buildings. An inquiry trough descriptive and locational attributes and an analysis of the suitability of soil for construction are made. The flexibility of the spatial ETL tool is demonstrated in this study, which also turns out to be a strong tool for editing and analyzing spatial data. The effect the geological basis has on the amount of the estimated damage is, in view of the data regarding the damage to buildings and in respect of other factors (such as the year of construction and building materials used) taken into account only for the aforementioned earthquake, therefore, confirmed with relatively low reliability.

• Keywords: graduation thesis, geodesy, data warehouse, ETL process, spatial ETL, interoperability