12-06, 11:15–12:00 (America/Belem), Room Auditorio
The purpose of this work is to show the benefits and difficulties of using scripts, whether in Python or SQL.
The work is the result of the author's experience in developing sophisticated Python scripts to build a thematic model for the heat spot data from the “BD Queimada program” of Brazil's National Institute for Space Research.
The thematic model consists of generating tables in the database (Postgres) that represent the themes with the heat spot data. The themes are represented by area of interest, such as Conservation Units, Indigenous Lands, Settlements, Biomes, ...
The aim of the work was to import the heat spot data and generate aggregated tables with themes in an automated way, making it easy to add new themes.
After the script went into production, it was necessary to add another theme, and although I made an effort in the script to make it easy to add a new theme, things didn't work out the way I wanted them to.
By writing the script in SQL, and putting it into production, the author can observe the details of when we should use Python or SQL to automate the thematic model with hotspots.
The script is being used to help monitor forest fires in the main areas of operation of The National Center to Prevent and Combat Forest fires.
Luiz Motta has been involved with information technology from an early age, having completed a technical course in data processing in 1984 at the age of 17 in the city of Rio de Janeiro. In his adolescence, his passion was nature, with a strong connection to the beaches and mountains of his city. Due to this passion, he decided to pursue Forestry Engineering, and during his undergraduate studies at the Federal University of Viçosa in the state of Minas Gerais, he developed computer programs in his research projects. These projects later resulted in a master's thesis, one of the first theses in the field of Geographic Information Systems (GIS), titled "Use of a Geographic Information System in the Optimization of Forest Transportation" (1995).
After leaving academia, he worked with GIS in a research center (Embrapa, 1996), public companies (IEF-MG, 2001), environmental consulting firms, and finally, in 2003, he fulfilled his lifelong dream by joining the career of Environmental Analyst at Brazilian Institute of the Environment and Renewable Natural Resources (Ibama). In Ibama, his workplace was in the Amazon, where he could see how the occupation of the Amazon region was carried out. Later, he was transferred to the Ibama headquarters in Brasília (the capital of Brazil), where he dedicated himself to the development of Geoprocessing in the institution. His work had a global reach, as his GIS software plugins and scripts were shared on the Internet.
His expertise in GIS development, especially in QGIS, where he was a contributor (with more than 10 plugins), provided experiences beyond Ibama, such as participating in the Planet Explorer program (2015) and the MapBiomas project (2019). In these projects, QGIS plugins were developed to access the data. His desire to help people in the Geoprocessing field has always marked his professional trajectory, serving as an instructor for various courses and providing assistance to other GIS users. Currently, Luiz Motta is with Prevfogo (National Center for Prevention and Combat of Forest Fires), being part of the Sisfogo (Fire Management System) development team. In addition to his environmental work, he is passionate about off-road adventures and is a member of the "Endurance Without Destination Motorcycle" Club.