BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2022//talk//A3TBBA
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-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:20260403T192125Z
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