Introduction to PostGIS

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
  • Geometry
  • Geography
• Spatial index
  • GIST
  • SP-GIST
  • BRIN

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