|
|
Support for Spatial Data in Oracle
Volf, Tomáš ; Chmelař, Petr (referee) ; Zendulka, Jaroslav (advisor)
This work acquaints with support for working with spatial data and mentions the possibility for spatio-temporal data in the Oracle database server 11g. On the basis of acquaintance with support for spatial data was designed sample application that uses this support. The sample application provides to display spatial data, which are stored in the database, graphically and also displays information about spatial objects. Finally, there are reviewed achievements and the possibilities how to continue in the project.
|
|
|
Automatic detection of driving lanes geometry based on aerial images and existing spatial data
Růžička, Jakub
The aim of the thesis is to develop a method to identify driving lanes based on aerial images and existing spatial data. The proposed method uses up to date available data in which it identifies road surface marking (RSM). Polygons classified as RSM are further processed to obtain their vector line representation as the first partial result. While processing RSM vectors further, borders of driving lanes are modelled as the second partial result. Furthermore, attempts were done to be able to automatically distinguish between solid and broken lines for a higher amount of information contained in the resulting dataset. Proposed algorithms were tested in 20 case study areas and results are presented further in this thesis. The overall correctness as well as the positional accuracy proves effectivity of the method. However, several shortcomings were identified and are discussed as well as possible solutions for them are suggested. The text is accompanied by more than 70 figures to offer a clear perspective on the topic. The thesis is organised as follows: First, Introduction and Literature review are presented including the problem background, author's motivation, state of the art and contribution of the thesis. Secondly, technical and legal requirements of RSM are presented as well as theoretical concepts and...
|
|
|
Design of a dendrochronological database
Majer, Hugo-Miroslav ; Brůha, Lukáš (advisor) ; Brodský, Lukáš (referee)
The bachelor thesis focuses on the design of a spatial database of tree-ring chronologies. The theoretical part of the thesis describes database systems and the storage of spatial data in relational databases. It also reviews existing databases of tree-ring chronologies and the basics of dendrochronology. The next section describes provided dendrochronological data, which are used in methodical section of the thesis. The methodical section describes the data requirements for the created database, the process of its design and implementation within PostgreSQL/PostGIS. Subsequently, it deals with the creation of functions developed in procedural extension of SQL. The stored functions are used to improve import of data. Afterwards, the design of a data filter in the form of SQL statement is mentioned. The main result of the thesis is a spatial database that meets both data and functional requirements, contains provided data and is connectable to GIS. The thesis concludes with a summary of the achieved results and contributions to the ongoing scientific project. Keywords: spatial database, database design, tree-ring chronologies, PostgreSQL/PostGIS, Procedural Language/PostgreSQL
|
|
|
Automatic detection of driving lanes geometry based on aerial images and existing spatial data
Růžička, Jakub ; Brůha, Lukáš (advisor) ; Brodský, Lukáš (referee)
The aim of the thesis is to develop a method to identify driving lanes based on aerial images and existing spatial data. The proposed method uses up to date available data in which it identifies road surface marking (RSM). Polygons classified as RSM are further processed to obtain their vector line representation as the first partial result. While processing RSM vectors further, borders of driving lanes are modelled as the second partial result. Furthermore, attempts were done to be able to automatically distinguish between solid and broken lines for a higher amount of information contained in the resulting dataset. Proposed algorithms were tested in 20 case study areas and results are presented further in this thesis. The overall correctness as well as the positional accuracy proves effectivity of the method. However, several shortcomings were identified and are discussed as well as possible solutions for them are suggested. The text is accompanied by more than 70 figures to offer a clear perspective on the topic. The thesis is organised as follows: First, Introduction and Literature review are presented including the problem background, author's motivation, state of the art and contribution of the thesis. Secondly, technical and legal requirements of RSM are presented as well as theoretical concepts and...
|
|
|
Support for Spatial Data in Oracle
Volf, Tomáš ; Chmelař, Petr (referee) ; Zendulka, Jaroslav (advisor)
This work acquaints with support for working with spatial data and mentions the possibility for spatio-temporal data in the Oracle database server 11g. On the basis of acquaintance with support for spatial data was designed sample application that uses this support. The sample application provides to display spatial data, which are stored in the database, graphically and also displays information about spatial objects. Finally, there are reviewed achievements and the possibilities how to continue in the project.
|
|
|
GEO Information System for Passportization and Visualization of Wide Computer Networks
Fibich, Ondřej ; Burget, Radek (referee) ; Kolář, Dušan (advisor)
The thesis is focused on the problem of the passportization and the visualization of wide computer networks with the usage of geographic information systems. It discusses principals and properties of geographic information systems and spatial databases that are frequently used as data carriers for geographic information systems. The main part of the thesis is dedicated to the passportization of computer networks with focusing on the physical network structure. After the definition of the passport format the thesis continues with the analysis, the proposal, the implementation and the testing of the geographic information system for managing and visualization of the passport in this format. The thesis is ended by a case study that demonstrates the passportization process of an access computer network in the implemented system.
|
guest ::
