12-04, 14:30–15:00 (America/Belem), Room I
The field of speleology is dependent upon the accurate mapping and analysis of data to gain an understanding of subterranean environments. Free and open-source software (FOSS) has facilitated advancements in spatial data management, offering robust tools for data collection, analysis, and fieldwork. Software solutions such as PostgreSQL with PostGIS, QGIS, GRASS, and QField facilitate efficient geospatial data management and data collection. The accurate location determination of caves is of paramount importance, given their significant ecological, historical, and cultural value. In Brazil, the implementation of rigorous environmental legislation has resulted in the establishment of a 250-meter buffer zone surrounding caves. This regulatory measure is designed to ensure the protection of these vulnerable ecosystems and to regulate activities within their vicinity. The radius may be modified based on the findings of environmental studies, thereby ensuring the preservation of caves while facilitating socio-economic development. This study presents EspeleoVale, a software as a service (SaaS) solution hosted on AWS. It employs open source scripting languages and frameworks, including AngularJS, PostgreSQL with PostGIS, and MapStore2 integrated with Geoserver, to effectively manage and visualize speleological data for a mining company in Brazil. By employing SQL queries and spatial functions, users can visualize cave locations and their restricted areas, thereby facilitating the assessment of project impacts on these geomorphological features. In this study, examples of visualization and spatial analysis are presented for five hypothetical caves and a hypothetical project, returning intersections, differences and merged areas, which are vital for the environmental protection of cavities and for knowing project restrictions. Thus, the integration of an RDBMS for spatial analysis and FOSS tools for data visualization fosters new developments and promotes more efficient speleology data management.
Bachelor's degree in Environmental Engineering from the Universidade Federal de Minas Gerais (UFMG), with part of my undergraduate studies done in the United States at Wayne State University. I am a Data Science specialist from PUC-Minas and hold a master's degree in Sanitation, Environment, and Water Resources from UFMG. Since 2016, I have been working in the environmental field, with a focus on GIS, remote sensing, and programming.
I work on developing customized solutions for clients in the private and public sectors, actively engaging with key stakeholders and supervising teams to ensure quality and meet expectations.
I have extensive experience in Python and integrating it with Geographic Information System (GIS) software using PyQGIS, Arcpy, and Google Earth Engine API libraries. I am proficient in using QGIS, ArcGIS, and Google Earth Pro software. Additionally, I have knowledge in database management (PostgreSQL) and web development (HTML, CSS, Geoserver, Django, Flask, Requests, WFS, and WMS services).