BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2024//talk//E33UYZ
BEGIN:VTIMEZONE
TZID:-03
BEGIN:STANDARD
DTSTART:20000101T000000
RRULE:FREQ=YEARLY;BYMONTH=1
TZNAME:-03
TZOFFSETFROM:-0300
TZOFFSETTO:-0300
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-foss4g-2024-E33UYZ@talks.staging.osgeo.org
DTSTART;TZID=-03:20241206T111500
DTEND;TZID=-03:20241206T120000
DESCRIPTION:The purpose of this work is to show the benefits and difficulti
 es of using scripts\, whether in Python or SQL.\nThe work is the result of
  the author's experience in developing sophisticated Python scripts to bui
 ld a thematic model for the heat spot data from the “BD Queimada program
 ” of Brazil's National Institute for Space Research.\nThe thematic model
  consists of generating tables in the database (Postgres) that represent t
 he themes with the heat spot data. The themes are represented by area of i
 nterest\, such as Conservation Units\, Indigenous Lands\, Settlements\, Bi
 omes\, ...\nThe aim of the work was to import the heat spot data and gener
 ate aggregated tables with themes in an automated way\, making it easy to 
 add new themes.\nAfter 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.\nBy 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 auto
 mate the thematic model with hotspots.\nThe script is being used to help m
 onitor forest fires in the main areas of operation of The National Center 
 to Prevent and Combat Forest fires.
DTSTAMP:20260513T014937Z
LOCATION:Room Auditorio
SUMMARY:Script for database: SQL or Python - Luiz Motta
URL:https://talks.staging.osgeo.org/foss4g-2024/talk/E33UYZ/
END:VEVENT
END:VCALENDAR