BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.osgeo.org//foss4g-europe-2026//talk//Z7QGGL
BEGIN:VTIMEZONE
TZID:EET
BEGIN:STANDARD
DTSTART:20001029T050000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
TZNAME:EET
TZOFFSETFROM:+0300
TZOFFSETTO:+0200
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000326T040000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
TZNAME:EEST
TZOFFSETFROM:+0200
TZOFFSETTO:+0300
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-foss4g-europe-2026-Z7QGGL@talks.osgeo.org
DTSTART;TZID=EET:20260630T120000
DTEND;TZID=EET:20260630T123000
DESCRIPTION:Modern Enterprise GIS is nowadays built with FOSS4G softwares. 
 Many organizations are in the middle of transition to build EntrepriseGIS 
 and some organizations are still planning to move from old fashioned close
 d source software implementations to open source solutions. FOSS4G based E
 nterprise GIS is commonly built with PostGIS based GIS database\, QGIS des
 ktop software\, mobile applications (like QField and Mergin Maps) and web 
 applications servers (like QGIS Server\, Geoserver). The most crucial and 
 enduring component of an Enterprise GIS solution is the database. This pre
 sentation will cover how to design\, build and maintain a GIS database for
  Enterprise usage. The presentation also includes best practices and recom
 mendation of tools for Enterprise GIS database management.\n\nEnterprise G
 IS is an organization-wide suite of interoperable GIS software used to man
 age and process geospatial information. Following the basic principles of 
 enterprise architecture\, its structure is based on three distinct layers:
  the User Interface\, the Application Server\, and Data Storage. This pres
 entation will focus on how to build a robust and efficient Data Storage la
 yer with PostGIS database.\n\nThis presentation will cover the following t
 opics:\n- GIS database design and modelling with open source solutions\n- 
 Best practices for GIS data modelling and versioning of data models\n- Org
 anise and manage the Enterprise GIS database in PostgreSQL cluster\n- Best
  practices for access privileges in Enterprise GIS database\n- QGIS relate
 d data storage to PostGIS\n- Manage database connections and credentials i
 n QGIS\n\nThis presentation is essential for GIS database managers\, GIS m
 anagers\, and all users of Enterprise GIS solutions. Attendees will be equ
 ipped with the fundamental knowledge and practical best practices — incl
 uding valuable tips-and-tricks — required to effectively build and maint
 ain a robust Enterprise GIS database.
DTSTAMP:20260605T093400Z
LOCATION:A11
SUMMARY:Enterprise GIS: Building and Maintaining the Database - Pekka Sarko
 la
URL:https://talks.osgeo.org/foss4g-europe-2026/talk/Z7QGGL/
END:VEVENT
END:VCALENDAR