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

Maintaining topological consistency of simple features with QGIS tools & PostGIS SQL rules

Formale Metadaten

Titel
Maintaining topological consistency of simple features with QGIS tools & PostGIS SQL rules
Serientitel
Anzahl der Teile
156
Autor
Mitwirkende
Lizenz
CC-Namensnennung 3.0 Unported:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache

Inhaltliche Metadaten

Fachgebiet
Genre
Abstract
This talk presents use of QGIS tools in topological editing of multiple simple features together and shows a SQL-based approach to checking the data in a PostGIS database to conform with given topological rules between multiple tables. When using simple features in a PostGIS database, topological relations are not handled with the data model, data is duplicated on shared segments and thus may contain differences on segments which should be shared and equal between all features on that egde, and in QGIS each modification must also consider the topological vertices and possibly make changes to other features as well. QGIS has built-in tools to handle some topological editing cases, this talk shows use cases for those and shows additional plugins available for making for example topological reshapes for shared segments, as if the segment was an edge in a topological data model. This talk also discusses SQL-based methods for checking the topological consistency. Simple checks shown include the built-in PostGIS functions like intersects or contains. More advanced cases show use of relate-checks for allowing certain types of intersections, or distance-based exists checks for requiring either connected or clearly separate features for topographic data modeling. These kind of SQL checks also allow maintaining complex topological relation checks based on attributes of the features, and for example a shoreline-lake relation can be checked fully inside state boundaries, and gaps are allowed on those parts of lakes outside of state boundaries.
Schlagwörter