think-where-logo.png
tel_email.jpg twitter.jpg youtube.jpg linkedin.jpg
banner_training1.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. 

 


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: 

  • 15th February 2018
  • 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

 

line.jpg

Contact Us

thinkWhere
Glendevon House
Castle Business Park
Stirling
FK9 4TZ

Telephone: +44 (0)1786 476060
Email: info@thinkwhere.com

> 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