Baza podataka geotehničkog laboratorija

master's thesis

• Title (english): Geotechnical laboratory database
• Author: Tomislav Ostroški
• Mentor: Mario Gazdek (mentor)
• Mentor: Nikola Kranjčić (komentor)
• Committee member: Sanja Kovač (predsjednik povjerenstva)
• Committee member: Mario Gazdek (član povjerenstva)
• Committee member: Nikola Kranjčić (član povjerenstva)
• Committee member: Mirna Amadori (član povjerenstva)
• Granter: University of Zagreb; Faculty of Geotechnical Engineering; Varaždin
• Defense date and country: 2021-09-20, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Interdisciplinary Technical Sciences; Environmental Engineering

Abstract

Rad opisuje konstrukciju .ags datoteke koja se koristi kod transfera
geotehničkih i geoekoloških podataka, stvaranje baze podataka pomoću
softverskog rješenja MySQL i gereferenciranje istražnih bušotina vezanih
za uzorke koje geotehnički laboratorij zaprima na kojima se vrši neko
ispitivanje. Detaljno je opisan svaki korak u stvaranju .ags datoteke, svaki
korak u stvaranju baze podataka i način stvaranja i povezivanja QGIS
slojeva s bazom podataka. Prikazan je rad takve baze podataka od
zaprimanja .ags datoteke do unosa podataka u bazu, te njihov izvoz
ponovno u .ags datoteku koja se prosljeđuje sljedećoj osobi (pravnoj,
fizičkoj) koja sudjeluje u nekom projektu. U radu je također istaknuta
vrijednost nacionalnih baza podataka, te što takva baza podataka može
osigurati.

Abstract (english)

The paper describesthe construction of .ags file which is used for the
transfer of geotechnical and geoecological data, the creation of a database
with a MySQL database solution software and georeferencing of boreholes
from which samples originate and are used for some type of testing in a
geotechnical laboratory. Each step in creating .ags file and a database is
explained in detail as well as creation of layers and linking database with
QGIS. The way the system works from receiving .ags file to filling the
database with received information and exporting those information from
the database to .ags file and forwarding to a legal or a physical person that
are part of a project is shown. The paper also presents the value the
national database gives and what itcan provide.

• Keywords: AGS; Baza podataka; MySQL; QGis; Geotehnički laboratorij
• Keywords (english): AGS; Database; MySQL; QGIS; Geotechnical laboratory
• Language: croatian
• URN:NBN: urn:nbn:hr:130:995676
• Study programme: Title: Geoenvironmental Engineering; specializations in: Geoenvironmental Engineering, Environmental Management, Water Management; Course: Geoenvironmental Engineering; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/ inženjerka inženjerstva okoliša (magistar/magistra inženjer/ inženjerka inženjerstva okoliša)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Open access; Embargo expiration date: 2022-01-08
• Created on: 2021-10-28 09:17:19