Tools for 3-dimensional geological layers models generated in spatial database using CGAL library

• Autorzy: Lisowski P. , Lupa M. , Kniotek M. , Piórkowski A.
• Konferencja: XVth International Conference of Young Geologists Her'lany 2014 : Międzybrodzie Żywieckie, Poland, May, 8th-10th 2014
• Języki publikacji: EN

Abstrakty

EN

Spatial databases are commonly used to generate 2-dimensional (2D) and 3-dimensional (3D) topographic models. Mentioned models sometimes also contain information about geological layers. In that case, analysing data provides extra benefits and facilities that are desirable in presentation of complex and multilayer data (Chrobak 2009, Gotlib 2009). The possibility of storing and processing the geometry, which is saved in a standardized vector form, is the greatest advantage of spatial databases. The standards (technical documents that detail interfaces or encodings) were presented by Open Geospatial Consortium (OGC) (Open Geospatial Consortium 2014). Geometry of the objects is presented as points, lines, polygons and theirs collections. The standards also include specification about 3D data representation.Those data could be used to describe and create geological models. Another advantage of spatial databases is the possibility of adding own extensions without recompilation of all database source code. The extensions are added as a compiled library with functions, which could be written in a selected programming language (Bac-Bronowicz 2010, Lupa 2012, Lisowski et al. 2013). This paper focuses on the possibility to extend PostgreSQL database using functions that are written on the base of open source Computational Geometry Algorithms Libary (CGAL) project (Aptekorz et al. 2012, CGAL 2014). The extension library contains algorithms that are used in computer graphic and visualization of geometric data. The library was written in C++ language according to the objective-programming paradigm. Presented solution adds function of Delaunay triangulation, which is not implemented in PostGIS (Lisowski et al. 2013). This tool allows to generate Triangulated Irregular Network (TIN) surfaces of geological layers in a simple and functional way. 3D terrain model is created using information from spatial database (2D and 3D objects). In the next step, TIN model is generated, which approximates the modelled geological layers by a network of the triangles (tangent edges). Interoperability and unified data edition was achieved due to using of triangles (represented by triangles which are polygon type, vanished points and lines objects). Nevertheless, generating of 3D models from 2D data with parameter, which would properly represent a surface and terrain layers, is not a trivial task.

Słowa kluczowe

EN

topographic model; OGC; Open Geospatial Consortium

• Wydawca: Wydawnictwa AGH
• Czasopismo: Geology, Geophysics and Environment
• Rocznik: 2014
• Tom: Vol. 40, no. 1
• Strony: 98--99
• Opis fizyczny: Bibliogr. 8 poz.

Twórcy

autor

Lisowski P.

• AGH University of Science and Technology, Faculty of Geology, Geophysics and Environmental Protection; al. Mickiewicza 30, 30-059 Krakow, Poland

autor

Lupa M.

• AGH University of Science and Technology, Faculty of Geology, Geophysics and Environmental Protection; al. Mickiewicza 30, 30-059 Krakow, Poland

autor

Kniotek M.

• AGH University of Science and Technology, Faculty of Geology, Geophysics and Environmental Protection; al. Mickiewicza 30, 30-059 Krakow, Poland

autor

Piórkowski A.

• AGH University of Science and Technology, Faculty of Geology, Geophysics and Environmental Protection; al. Mickiewicza 30, 30-059 Krakow, Poland

Bibliografia

• 1. Aptekorz M., Szostek K. & Młynarczuk M., 2012. Możliwości akceleracji przestrzennych baz danych na podstawie procesorów kart graficznych oraz funkcji użytkownika. Studia Informatica , 33, 2B (106).
• 2. Bac-Bronowicz J., 2010. Accurancy of the existing geo-information sources related to point data used in digital cartographic models. Geoinformatica Polonica , 10, 7–21.
• 3. CGAL, http://cgal.org 2014.
• 4. Chrobak T., 2009. Wielorozdzielcze/wieloreprezentacyjne bazy danych w kartografii. [in:] Żyszkowska W. & Spallek W. (red.), Bazy danych w topografii: Główne problemy współczesnej kartografii 2009 , Wrocław, 7–19.
• 5. Gotlib D., 2009. Baza danych jako podstawa produkcji map topograficznych. [in:] Żyszkowska W. & Spallek W. (red.), Bazy danych w topografii: Główne problemy współczesnej kartografii 2009, Wrocław.
• 6. Lisowski P., Piórkowski A. & Porzycka-Strzelczyk S., 2013. Rozszerzenie możliwości systemu PostGIS o metodę triangulacji Delaunay, przy wykorzystaniu biblioteki CGAL. Studia Informatica, 34, 2B, 37–46.
• 7. Lupa M. & Piórkowski A., 2012. Regułowa optymalizacja zapytań w bazach danych przestrzennych. Studia Informatica, 33, 2B, 105–115.
• 8. Open Geospatial Consortium, http://www.opengeospatial.org 2014.