izpis_h1_title_alt

Vzpostavitev prostorskega podatkovnega skladišča na primeru občine Bovec za potres 2004 : diplomska naloga
Šušteršič, Katja (Author), Podobnikar, Tomaž (Mentor) More about this mentor... This link opens in a new window, Kogoj, Dušan (Thesis defence commission member), Kosmatin Fras, Mojca (Thesis defence commission member), Šumrada, Radoš (Thesis defence commission member)

URLURL - Presentation file, Visit http://drugg.fgg.uni-lj.si/4101/ This link opens in a new window
.pdfPDF - Presentation file, Download (3,62 MB)
MD5: C6D4EC76BDBCE17FD9BFC192AC76DE63

Abstract
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 (m5)
Tipology:2.11 - Undergraduate Thesis
Organization:FGG - Faculty of Civil and Geodetic Engineering
Year:2012
Publisher:[K. Šušteršič]
Number of pages:XVI, 58 str.
Place:Ljubljana
UDC:550.34:681.3(1-22)(497.4Bovec)(043.2)
COBISS.SI-ID:6121569 This link opens in a new window
Views:1715
Downloads:398
Metadata:XML RDF-CHPDL DC-XML DC-RDF
 
Average score:(0 votes)
Your score:Voting is allowed only to logged in users.
:
Share:AddThis
AddThis uses cookies that require your consent. Edit consent...

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

Similar documents

Similar works from RUL:
Similar works from other Slovenian collections:

Comments

Leave comment

You have to log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back