BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.osgeo.org//qgis-uc2026//talk//VX79JY
BEGIN:VTIMEZONE
TZID:CET
BEGIN:STANDARD
DTSTART:20001029T040000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
TZNAME:CET
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000326T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
TZNAME:CEST
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-qgis-uc2026-VX79JY@talks.osgeo.org
DTSTART;TZID=CET:20261005T143000
DTEND;TZID=CET:20261005T150000
DESCRIPTION:On GIS projects it is often required to populate certain fields
  in various layers automatically with data\, either from current values\, 
 like date and time or user\, or fields from other layers\, including onlin
 e and cloud resources. These fields can be populated with some of the proc
 essing tools\, especially\, when a large number of rows need to be updated
 \, or with the expression builder when a new record is added or an existin
 g one updated. Both processes can involve simple calculations\, like addit
 ions\, subtractions\, multiplications\, divisions or any other mathematica
 l formulas\, or complex (spatial) queries of data in other layers or onlin
 e and cloud resources like digital elevation models or WMS/WMTS\, WFS\, RE
 ST layers hosted on the Internet. While it might be quite easy to automati
 cally update a date field with the integrated “now” function\, or a te
 xt field with the Plus Code\, or a field for the current user with the QGI
 S variables\, it is not a lot more difficult to share data between joined 
 layers\, although joins in large QGIS projects could become quite slow. A 
 bit more challenging automated field updates can become between related la
 yers and spatially overlapping or nearby layers\, but querying WMS or othe
 r online layers can have their own challenges altogether. In some cases da
 tabase triggers are the most effective way of dealing with field updates\,
  but these need to be configured depending on the database used.\n\nThis p
 resentation will provide a short overview of what is possible and demonstr
 ate live field updates directly in QGIS using complex attribute forms and 
 several layers related to each other. The querying of online layers (WMS\,
  WFS and cloud-based DEM) will also be shown and the use of triggers for u
 pdating fields explained.
DTSTAMP:20260724T234927Z
LOCATION:Bridge 2
SUMMARY:Automating the population of layer fields with the power of QGIS - 
 Immo Blecher
URL:https://talks.osgeo.org/qgis-uc2026/talk/VX79JY/
END:VEVENT
END:VCALENDAR