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

3 Days

Location & Date

Currently there is no date and time available for this certain training, if you are interested please contact us.
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