BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2022//speaker//HYERQZ
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-YU8XVH@talks.staging.osgeo.org
DTSTART;TZID=CET:20220824T171500
DTEND;TZID=CET:20220824T172000
DESCRIPTION:**"Géocommun"** `[ʒeokɔmɛ̃]` : is it the latest buzzword i
 n France or a large movement towards more openness in the geospatial realm
  ?\n\nThe French National Geographical Institute (IGNF) recently started c
 ommunicating its vision towards the development of Geo-commons. This sound
 s like a strategical change in the way the institute apprehends geo-data a
 nd geo-software production.\n\nIn this presentation\, we first try to give
  a definition of what a "geocommon" is. Then we review the initiatives cur
 rently being deployed by various actors in France to transform this word i
 nto a reality.\n\nWe study the roots of these actions and their links to o
 pendata\, opensource and opengov movements.\n\nWe also try to provide a mi
 ndmap of involved actors\, and how they interact together : administration
 s\, data-oriented communities or software-oriented communities.\n\nThen we
  anticipate the impact on free and opensource software for geomatics\, and
  how it could affect technologies and communities in this area.
DTSTAMP:20260405T070824Z
LOCATION:Room 9
SUMMARY:Geo-commons in France : review of current initiatives - Vincent Pic
 avet\, Julien MOURA
URL:https://talks.staging.osgeo.org/foss4g-2022/talk/YU8XVH/
END:VEVENT
BEGIN:VEVENT
UID:pretalx-foss4g-2022-QEHLM7@talks.staging.osgeo.org
DTSTART;TZID=CET:20220825T113000
DTEND;TZID=CET:20220825T120000
DESCRIPTION:PostgreSQL is the most advanced opensource RDBMS. As GIS folks\
 , you most probably use it in combination with PostGIS\, its Geospatial pl
 ugin.\n\nWhen dealing with Geospatial data\, we usually focus on geometrie
 s. But most of feature attributes are text data. Of course\, filtering on 
 these text data with standard SQL capabilities is a day-to-day operation f
 or database users.\n\nBut PostgreSQL provides much more capabilities when 
 it comes down to text data management. In this presentation\, we will go t
 hrough a few of them.\n\nAfter a quick look at standard text functions in 
 PostgreSQL\, we will discover the lesser known fuzzy matching modules : \n
 - `pg_trgm` extension allows for string searches using trigraphs to determ
 ine a similarity rank between text items\n- `fuzzystrmatch` extension prov
 ides fuzzy matching functions like soundex\, Levenshtein\, metaphone\n\nTh
 en\, we will explore **Full Text Search ( FTS )** PostgreSQL capabilities.
 \n\nLast but not least\, we will peek inside PostgreSQL collation concept\
 , which has nothing to do with your lunch. Collations are a powerful featu
 re in PostgreSQL allowing to adapt the way you deal with text data accordi
 ng to the localization. Like trying to answer this - apparently - obvious 
 question : is '12' before or after '2' ?\n\nAnd\, because we can\, display
  all of this on a map :-)
DTSTAMP:20260405T070824Z
LOCATION:Room Limonaia
SUMMARY:Manipulating text with PostgreSQL - lesser known PG jewels - Vincen
 t Picavet
URL:https://talks.staging.osgeo.org/foss4g-2022/talk/QEHLM7/
END:VEVENT
END:VCALENDAR