BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2022//speaker//ZRRLEF
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-foss4g-2022-XAFBUK@talks.staging.osgeo.org
DTSTART;TZID=CET:20220824T113000
DTEND;TZID=CET:20220824T120000
DESCRIPTION:When using QGIS as a user interface for a PostgreSQL- & PostGIS
 -based registry database\, user experience plays a high role. The data sch
 emas of a registry database can hold a complex set of relations and databa
 se objects which can be hard to set up within QGIS. This was the case with
  a waste soil transportation registry that we developed for the City of Ta
 mpere\, Finland. The main goal of the registry is to optimize soil transpo
 rtation from construction sites by communicating and making it visible wha
 t soil categories are available and needed where and when. The registry en
 ables significant savings in transportation costs as well as substantial r
 eductions in climate emissions.\n\nWhen the relational data model gets com
 plex\, you can deploy different strategies for setting up the workflows wi
 thin QGIS. One possible solution is to use editable views and triggers for
  enabling user-friendly workflows in QGIS. This was the case in our soil r
 egistry project. The data model\, as it was\, would have forced the user t
 o create multiple new features to the database tables when he/she just wan
 ted to add a single soil transfer from one construction site to another. T
 his was seen as too tedious when repeated constantly. The solution was to 
 make a database view that the user could edit in QGIS\, in addition to dep
 loying database triggers for creating the right database features\, with t
 he proper data into the correct database tables.\n\nThis presentation seek
 s to show how the strategy was deployed and what challenges we met during 
 the development.
DTSTAMP:20260404T005621Z
LOCATION:Room Limonaia
SUMMARY:Streamlining QGIS workflows with PostgreSQL editable views and trig
 gers - Lauri Kajan
URL:https://talks.staging.osgeo.org/foss4g-2022/talk/XAFBUK/
END:VEVENT
END:VCALENDAR