tel_email.jpg twitter.jpg youtube.jpg linkedin.jpg

postgis_logo_square.jpgPostGIS - User

Learn how to load and manage spatial data within the PostgreSQL spatial extension PostGIS with this hands-on training course.  This course focuses on topics including accessing geometries, projections, spatial querying and visualisation of the data. 

Attending this course entitles delegates to receive 4 CPD points towards their continual Professional Development under the Association for Geographic Information (AGI) Chartered Geographer scheme.  

This course is most suitable for:

  • Those who wish to load and manage spatial data with the PostGreSQL spatial extension PostGIS.

Course Outline

Module 1: PostGIS Introduction

  • PostgreSQL
  • PostGIS

Module 2: Overview of SQL

  • Using SQL within PostgreSQL
  • Practical exercises in the use of SELECT, INSERT, UPDATE, and DELETE queries.

Module 3: Introduction to Spatial Databases

  • Spatial databases
  • Spatial data types
  • Spatial projections (within PostGIS)

Module 4: Spatial Data Loading Tools

  • Shapefile Loader (shp2gsql)
  • ogr2ogr
  • loading data with QGIS (an open source GIS application).

Module 5: Spatial Data in PostGIS

  • Spatial data geometry
  • Geometry validation
  • Spatial indexing

Module 6: Spatial Querying

  • st_area
  • st_length
  • st_within (buffering)
  • st_intersects
  • st_distance

Module 7: Visualising PostGIS Data

  • Display
  • Symbolising data
  • Analysing data using QGIS 

Cost: £450 (exc VAT)

Duration: 1 day

Course Dates Stirling: 

  • 21st May 2018
  • 9th August 2018
  • 13th November 2018

Course Dates Manchester:  

  • September

CPD Points: 4

Book Your Place


What's On


What Our Clients Say...

"Nothing seemed impossible to my trainer - when I asked about a feature she hadn't used before within minutes she talked me through how to do it - brilliant!"

Performance & Information Officer

Clackmannanshire Council



Contact Us

Glendevon House
Castle Business Park

Telephone: +44 (0)1786 476060

> Enquiries

Find Us

Our office is located in the
City of Stirling with convenient
motorway and rail links.

> View location map

thinkWhere Ltd. is registered in
Scotland: SC315349