Our primary PostGIS trainer is Ian Turton (@ijturton).
Ian is a founder and code committer for the GeoTools java library which provides the underpinning spatial tools for GeoServer
Ian has extensive experience working with Open Source software (PostGIS, GeoServer, QGIS and others) spanning over 25 years.
Ian is a charter member of the OSGeo Foundation.
Astun offers two PostGIS courses; a two-day introduction to the essentials, for which prior attendance on the QGIS Essentials course or equivalent GIS experience, is a pre-requisite and knowledge of databases and SQL is desirable. The one-day PostGIS DBA (DataBase Administration) Essentials course, attendees must have first completed the PostGIS Essentials course.
PostGIS Essentials (2 days) - 8 CPD points
The course runs from 9.30am to 5pm each day.
1. Introduction and getting started
Introduction to PostgreSQL, PostGIS, pgAdminIII, servers, databases and database objects. Includes best practice and a practical exercise aimed at getting started on interacting with databases through pgAdmin.
2. Loading, exporting and using spatial data
Use different methods for loading data and exporting data into and from PostGIS. Includes the shapefile loader and GIS as well as 'Loader' for importing OS MasterMap. Explores use of copy command for importing non-spatial data. The module looks in more detail into the characteristics of spatial data in PostGIS including the Geometry Columns table.
3. Basic Structured Query Language (SQL)
An introduction in using SQL in PostGIS covering practical use of SELECT, WHERE, COUNT, ORDER BY, GROUP BY, operators, use of quotes and wild cards.
4. Further SQL
Builds on module 3 introducing the practical use of joins, views, creating tables, updates, inserts and deletes. The module will also start to make use of sub-queries as well as guidance for working with multiple tables.
5. Geometry accessors and measurements
Introduces the use of spatial functions in PostGIS and explores key functions for understanding geometry. These include WKB Geometries, WKT Geometries, validity of geometry, functions for breaking down geometries and Transforming Spatial Reference Systems.
The modules demonstrate the use of spatial and geometric measurement functions.
7. Spatial relationships and joins
Looks at the use of spatial functions for determining the relationships between geometry, for example the st_intersect and st_within functions. Through use of real life examples the module uses these relationships to create spatial joins.
8. Geoprocessing functions
Advanced use of the spatial functions provides a strong practical element in incorporating buffers as well as other functions for spatial aggregation.
PostGIS DBA Essentials (1 day) - 4 CPD points
This course is a basic introduction to the administration tasks required for a PostGIS database.
It covers basic administration tasks as well as a step-by-step guide for PostgreSQL and PostGIS installation in the Windows environment.
The course runs from 9.30am to 5pm.
The course explores the different elements of user access including connecting from a remote server and provides guidance and practical examples on roles and role groups for managing security on the PostgreSQL server.
- Accessing the Server and User Management
- Administration and Monitoring
- Configuration Controls and Performance Tuning
- Database Administration Tasks
- Maintenance Tasks
- Backup and Recovery
- Issues and Further Considerations