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