BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-europe-2025//speaker//MV
 ZQAF
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-europe-2025-BXBM8A@talks.staging.osgeo.org
DTSTART;TZID=CET:20250716T170000
DTEND;TZID=CET:20250716T173000
DESCRIPTION:When handling massive LiDAR datasets on the web\, is the tradit
 ional gazillion-of-tiles approach still the best choice? Or can structured
  file storage like **SQLite**\, **DuckDB**\, and **Parquet** deliver a fas
 ter\, more scalable format? Solutions for managing massive LiDAR datasets 
 already exist\, some even attempt to package **3D Tiles** into databases t
 o reduce fragmentation. However\, some of these approaches come with limit
 ations: they are often proprietary or lack flexibility for large-scale dat
 asets.\n\nFaced with **1.3 trillion LiDAR points** from Croatia’s nation
 wide airborne LiDAR mapping project\, we needed a way to efficiently store
 \, process\, and visualise this immense dataset. For web visualisation\, C
 esium and 3D Tiles offered powerful rendering\, but converting raw LiDAR d
 ata into millions of tiny files led to a storage and performance nightmare
 . File fragmentation overwhelmed the filesystem\, causing sluggish read/wr
 ite operations\, unreliable backups\, and some request overhead when servi
 ng tiles online.\n\nTo overcome these challenges\, we explored alternative
  structured file storage solutions. \nSQLite\, a compact embedded database
 \, reduced fragmentation while enabling fast spatial queries. DuckDB\, an 
 analytical database optimized for large-scale data\, delivered high-speed 
 querying and processing power. \nParquet\, a columnar storage format used 
 in big data\, provided strong compression and rapid sequential access\, ma
 king it a promising alternative to millions of fragmented 3D Tiles.\n\nIn 
 this presentation\, we will share our experience\, comparing fragmented 3D
  Tiles with structured file storage formats. Whether you’re working with
  3D Tiles\, small raster and vector tiles\, or other massive spatial datas
 ets\, this session will provide you with insight to a practical alternativ
 e of the millions-of-files problem.
DTSTAMP:20260527T015038Z
LOCATION:SA01
SUMMARY:Structured File Storage vs. Millions of 3D Tiles: Who Wins? - Vikto
 r Mihoković\, Mario Miler
URL:https://talks.staging.osgeo.org/foss4g-europe-2025/talk/BXBM8A/
END:VEVENT
END:VCALENDAR