BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2022//speaker//GBGVME
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-VC8WX9@talks.staging.osgeo.org
DTSTART;TZID=CET:20220825T113000
DTEND;TZID=CET:20220825T120000
DESCRIPTION:With our Lizmap hosting service\, we provide and monitor severa
 l hundred of QGIS servers. These QGIS Servers receive and process 3.5 mill
 ion requests per week\, including 3 million WMS GetMap requests.\n\nWe do 
 not control the content of these QGIS projects\, which are sent by our cus
 tomers on our servers. Therefore\, we need to deal with projects having so
 me various kind of issues. Some QGIS projects can have very heavy SQL view
 s which are slow to load. Our infrastructure may host projects having hund
 reds of layers with complex symbology. Users can publish QGIS PDF layouts 
 (A4 and A3) with custom logos etc. This can lead to memory problems.\n\nGI
 S technicians can add different data sources : vector and raster files\, P
 ostgreSQL / PostGIS database\, OGC WMS\, WFS and WMTS web services into th
 ese QGIS projects. We need to ensure that QGIS Server is working properly\
 , for all customers\, to execute incoming requests when some external Web 
 Services providers are too slow to respond or are temporarily offline.\n\n
 We need to take care of possible errors propagated by these projects. In s
 ome circumstances\, we have about 10 thousand errors per week coming from 
 QGIS server.\n\nThe goal of this presentation is to give an overview of wh
 at QGIS Server can experience into the wild and what we need to do to make
  the Lizmap user experience the best possible: monitoring\, proxy\, cachin
 g.
DTSTAMP:20260411T105425Z
LOCATION:Room Onice
SUMMARY:QGIS Server into the wild - Etienne Trimaille\, René-Luc Dhont
URL:https://talks.staging.osgeo.org/foss4g-2022/talk/VC8WX9/
END:VEVENT
BEGIN:VEVENT
UID:pretalx-foss4g-2022-A3TBBA@talks.staging.osgeo.org
DTSTART;TZID=CET:20220825T120000
DTEND;TZID=CET:20220825T123000
DESCRIPTION:PgMetadata is made for people using QGIS as their main GIS appl
 ication\, and PostgreSQL as their main vector data storage.\n\nThe layers 
 metadata are stored inside your PostgreSQL database\, in a dedicated schem
 a. Classical fields are supported\, such as the title\, description\, cate
 gories\, themes\, links\, and the spatial properties of your data.\n\nPgMe
 tadata is not designed as a catalog application which lets you search amon
 g datasets and then download the data. It is designed to ease the use of t
 he metadata inside QGIS\, allowing to search for a data and open the corre
 sponding layer\, or to view the metadata of the already loaded PostgreSQL 
 layers.\n\nBy storing the metadata of the vector and raster tables inside 
 the database:\n\n* QGIS can read the metadata easily by using the layer Po
 stgreSQL connection: a dock panel shows the metadata for the active layer 
 when the plugin detects metadata exists for this QGIS layer.\n* QGIS can r
 un SQL queries: you can use the QGIS locator search bar to search for a la
 yer\, and load it easily in your project.\n\nThe administrator in charge o
 f editing the metadata will also benefit from the PostgreSQL storage:\n\n*
  PostgreSQL/PostGIS functions are used to automatically update some fields
  based on the table data (the layer extent\, geometry type\, feature count
 \, projection\, etc.).\n* The metadata is saved with your data anytime you
  backup the database\n* You do not need to share XML files across the netw
 ork or install a new catalog application to manage your metadata and allow
  the users to get it.\n\nThe plugin contains some processing algorithms to
  help the administrator. For example:\n\n* a script helps to create or upd
 ate the needed "pgmetadata" PostgreSQL schema and tables in your database\
 n* a algorithm creates a QGIS project suitable for the metadata editing. T
 his project uses the power of QGIS to create a rich user interface allowin
 g to edit your metadata easily (forms\, relations). Why use another interf
 ace when QGIS rocks ?\n\nMore PgMetadata features will be shown during the
  presentation:\n\n* Modification of the template to tune the displayed met
 adata\n* Export a metadata dataset to PDF\, HTML or DCAT\n* Publish the me
 tadata as a DCAT catalog with Lizmap Web Client module for PgMetadata. It 
 can then be harvested by external applications (Geonetwork\, CKAN)\n* The 
 data model is very close to the QGIS metadata storage and the DCAT vocabul
 ary for compatibility.\n\nWe will also show the last features such as the 
 new support of the PostgreSQL rasters
DTSTAMP:20260411T105425Z
LOCATION:Room Onice
SUMMARY:PgMetadata - A QGIS plugin to store the metadata of PostgreSQL laye
 rs inside the database\, and use them inside QGIS - Etienne Trimaille
URL:https://talks.staging.osgeo.org/foss4g-2022/talk/A3TBBA/
END:VEVENT
END:VCALENDAR