This presentation demonstrates common techniques to clean-up spatial data from a real-world data source. It will start with raw OSM data. Topics it’ll cover: Getting OSM data How to merge multilinestrings into single linestrings. Fill in gaps, snapping, reducing resolution Consolidating geometries with aggregate functions ST_Union, ST_MakeLine, ST_Collect based on both spatial and non-spatial attributes
أكثر...
أكثر...