Theoretical part
Introduction
- Setup and maintenance of PostGIS
- Tooling (Import, Export, ETL)
- Storage and management of spatial data
Spatial data types and indices
- Spatial data types
- Spatial index
Spatial functions
- Core functions
- Output
- Construction
- Accessor and setter
- Measurement functions
- Composition functions
- Decomposition functions
- Simplification functions
- Topological functions
- Bounding boxes
- Equality
- Relations
- Spatial joins
- Special Functions for processing and analysis
- Spatial aggregation
- Clipping, splitting, tesselation
- Segmentation
- Translation, scaling and rotation
Practical part
Introducing the dataset & Exercises
- Import/Export spatial data
- Validating and fixing spatial data
- Analyzing spatial data
- Visualizing spatial data