We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Mending Spatial Data with PostGIS

23
 Cite
 Share
 Related Material
 Download
 Purchase
No logo availableFOSS4G
Logo of Open Source Geospatial Foundation (OSGeo)Open Source Geospatial Foundation (OSGeo)
 HSU, LEO

Formal Metadata

Title
Mending Spatial Data with PostGIS
Title of Series
Number of Parts
188
Author
License
CC Attribution 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language
Production Year2014
Production PlacePortland, Oregon, United States of America

Content Metadata

Subject Area
Genre
Abstract
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 data2) How to merge multilinestrings into single linestrings.3) Fill in gaps, snapping, reducing resolution4) Consolidating geometries with aggregate functions ST_Union, ST_MakeLine, ST_Collect based on both spatial and non-spatial attributes
Keywords