FOSS4G 2023 Prizren

The presentation discusses the utilization of Postgis Topology for updating land resource maps in Norway, particularly the AR5 map. The ease of use and security provided by Postgis Topology are highlighted, with focus on advantages like traceability and data security. The talk also delves into a related project involving ST_Intersection and ST_Diff operations on extensive Simple Feature layers covering Norway. Despite facing issues with Topology exceptions and performance using other tools like JTS OverlayNG, transitioning to Postgis Topology shows promising results. The presentation emphasizes how a Postgis Topology database model improves data normalization and comparison to Simple Feature models is drawn, likening the latter to using a spreadsheet model without foreign keys.

The speaker explains the benefits of employing Postgis Topology in enhancing userfriendly and secure tools for updating land resource maps. Additionally, the challenges faced in previous projects involving spatial operations and their resolution through adopting Postgis Topology are discussed. The presentation underscores the advantages of normalized data storage and highlights how Postgis Topology offers a more efficient and effective approach compared to conventional methods like Simple Feature models.