CYBERTEC Logo

Introduction to PostGIS

LEVEL: Intermediate
Basic experience with PostgreSQL is required.
Book Now

Course Topics

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

Course INFO

Level Intermediate

Knowledge needed.

Language

English or German

Duration

Location & Date

Contact us
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram