PostGIS spatially enables geographic objects in the PostgreSQL object relational database. It adds support for geographic objects allowing location queries to be run in SQL.

PostGIS provides the following benefits:

  • Open Geospatial Consortium (OGC) standards compliance
  • Feature rich spatial implementation
  • Industry leading query performance
  • Efficient and high performance data storage
  • Support for major spatial vendors including ESRI, Mapinfo, Autodesk, FME – as well as being the core spatial database format used by the Geospatial Open Source stack of software

Delegates Learn: The Spatially Enabled with PostGIS course covers the breadth of the PostGIS API, including modelling the physical world as geographic objects, importing, creation and manipulation of these objects, and complex analysis and generation of derived data sets.

Target Audience: Database Scientists, Geoscientists, Spatial Data Coordinators, Spatial Operations Managers, Metadata Managers, Enterprise Architects.

Prerequisites: Completion of PostgreSQL Administration Course and familiarity with spatial data and concepts.

Course outline:

  • Introduction to PostGIS
  • PostGIS Case Studies
  • Basic Tools
  • Datatabase Basics
  • Overview of the Data
  • Representing Geometries
  • Formatting your Output
  • PostGIS Metadata
  • Geographic Objects and Geometry Accessors
  • Visualising Data
  • Importing Data
  • Projection Overview
  • Projecting Data
  • Measurement Functions
  • Spatial Joins
  • Indexing Tablespaces
  • Tuning the Database
  • Optimising Query Plans
  • Clustering
  • Equality and Validity
  • Aggregate Functions
  • Set Returning Functions
  • Pointset Operations