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 ...
أكثر...
أكثر...