BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2022//speaker//ZMQDDJ
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-EBQARM@talks.staging.osgeo.org
DTSTART;TZID=CET:20220825T090000
DTEND;TZID=CET:20220825T093000
DESCRIPTION:In this talk we will look at how PostGIS and Uber's H3 index ca
 n be used for aggregating large amounts of data\, in our case property ins
 urance risk\, in real-time.  We will explore a number of different techniq
 ues from the H3 PostGIS extension generating GeoJSON\, to generating MVTs 
 from the database to pre-caching the H3 index and painting a vector tile l
 ayer client side.  For our client side layer will use a React JS interface
 \, Maplibre and will also look at Deck.GL for more advanced use cases.  We
  will discuss how the stack can be deployed using a serverless architectur
 e running on AWS Lambda and Aurora Serverless Postgres.\n\nThis talk requi
 res no prior knowledge however some experience with PostGIS and vector til
 es will be useful.  You will learn techniques which can be applied to any 
 problem domain where there is the need to work with data volumes where pro
 cessing individual points would not be practical.
DTSTAMP:20260405T122050Z
LOCATION:Room 9
SUMMARY:Aggregating risk with H3 and PostGIS - Mark Varley
URL:https://talks.staging.osgeo.org/foss4g-2022/talk/EBQARM/
END:VEVENT
END:VCALENDAR