Mending Spatial Data with PostGIS

LEO HSU, PARAGON CORPORATION
Friday 13:30 - 13:55
Session 2, Track 1, Slot 2

This presentation demonstrates common techniques to clean-up spatial data from a real-world data source.

I will start with raw OSM data.

Topics I’ll cover:
1) Getting OSM data
2) How to merge multilinestrings into single linestrings.
3) Fill in gaps, snapping, reducing resolution
4) Consolidating geometries with aggregate functions ST_Union, ST_MakeLine, ST_Collect based on both spatial and non-spatial attributes