BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.osgeo.org//foss4g-europe-2026//speaker//U73UCM
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-RPPKRR@talks.osgeo.org
DTSTART;TZID=EET:20260630T143000
DTEND;TZID=EET:20260630T150000
DESCRIPTION:Subsea cable damage accounts for over 80% of insurance claims i
 n offshore wind\, making cable burial design a critical and high-risk deci
 sion. Despite this\, traditional 2-dimensional cable burial risk assessmen
 t (CBRA) methods were largely non-spatial\, relying on spreadsheets\, manu
 al interpolation\, and expert judgement. These approaches are difficult to
  reproduce\, error-prone\, and inefficient when route changes occur.\nThis
  talk presents a fully geospatial CBRA workflow built using PostGIS\, tran
 sforming a historically linear and manual process into a scalable\, data-d
 riven pipeline. We demonstrate how Automatic Identification System (AIS) v
 essel data is processed from raw point observations into tracklines and de
 nsity rasters\, and how post-construction rerouting scenarios can be model
 led to estimate shifts in marine traffic patterns.\nThese spatial outputs 
 are integrated with geological ground models and seabed levels to determin
 e cable burial depth requirements along subsea cable routes. Using core Po
 stGIS capabilities such as spatial indexing (GiST)\, relational predicates
  (ST_Intersects) and geometric analysis (e.g. ST_HausdorffDistance)\, we c
 reate a reproducible workflow that supports rapid iteration as new data be
 comes available.\nThe approach reduces duplicated effort\, improves consis
 tency\, and enables more transparent decision-making in a high-cost engine
 ering context. It has already been applied to multiple offshore wind devel
 opments\, including the floating offshore wind farm\, Green Volt.\nThe tal
 k will explore how this workflow extends into 3-dimensional modelling thro
 ugh voxel generation\, highlighting opportunities for further integration 
 with netCDF outputs and open geospatial ecosystems. Attendees will gain in
 sight into how PostGIS can be used to modernise risk modelling workflows\,
  where data availability can be variable. \nWe conclude by addressing that
  while the analytical pipeline contains as many open source elements as pr
 acticable\, the results are currently shared using the Esri JavaScript sof
 tware development kit (SDK) to support wider stakeholder engagement. Both 
 the benefits and remaining challenges in transitioning fully to open-sourc
 e solutions will be discussed\, with invitation to collaboration on bridgi
 ng these gaps.
DTSTAMP:20260605T011258Z
LOCATION:A02
SUMMARY:Reducing Subsea Cable Risk with PostGIS: A CBRA Workflow for Offsho
 re Wind - Hannah Jukes
URL:https://talks.osgeo.org/foss4g-europe-2026/talk/RPPKRR/
END:VEVENT
END:VCALENDAR