Have a question?

CONTACT US

PostGIS

PostgreSQL       PostGIS

Our PostGIS training courses are aimed at businesses looking to take full advantage of this powerful geodatabase. Courses allow delegates to quickly get to grips with PostGIS both as a user and database administrator. Delegates will learn how to install and configure PostgreSQL/PostGIS, how to import geographic information through a variety of methods, how to manage access to their data through roles and permissions and how to use PostGIS’ many database functions to perform complex on-the-fly geoprocessing. A detailed course outline can be found below.

It is assumed that delegates have a solid understanding of GIS concepts but do not have any prior knowledge of the Structured Query Language (SQL).

All of our training courses combine presentations with practical exercises, allowing delegates to practice the techniques and concepts being taught. Delegates are supplied with a hard-copy course manual containing all exercises and presentation materials.

Delegates are encouraged to bring any datasets they may find useful during Open Sessions, held at the end of each day where tutors aim to solve any relevant GIS queries or problems.

Suitable for those who wish to:

  • Populate, view and edit PostGIS layers in a GIS environment
  • Write their own SQL queries to make use of PostGIS’ geoprocessing and spatial query functions
  • Install, configure and administer a PostGIS server within their organisation
  • Write their own database functions and automate database tasks
    • (When combining this course with our PostGIS for Developers training course)

How we run our courses

Lutra Consulting specialise in running customised training courses for organisations. That means that you get to choose the course content that best meets your requirements and we’ll send one of our knowledgeable and experienced tutors to you, with everything required to run your course, anywhere in the UK or Ireland.

Please see our main training page for more information about how we run our courses.

Course structure and registration

Our PostGIS training course is usually taken as a two day course and covers the topics listed below in green (day 1) and blue (day 2). Those interested in writing their own database functions or automating database tasks often add our PostGIS for Developers training course as a third day.

Those looking for a tailored PostGIS training course for multiple staff may pick and choose content from below and from our other courses. Please contact Peter Wells on 01444 848012 or training@lutraconsulting.co.uk to book a course or to discuss your requirements in detail.


Topic Level
An introduction to PostgreSQL and PostGISIntermediate
The advantages of geodatabases
Installing PostgreSQL and PostGIS for WindowsIntermediate
Administering PostGIS with pgAdminIIIIntermediate
Creating new spatial databasesIntermediate
Creating databases from templates
The structure of a PostGIS databaseIntermediate
Tables
Schemas
Importing existing data into PostGISIntermediate
The PostGIS Shapefile Import/Export Manager
Viewing and editing PostGIS layers in a GIS environmentIntermediate
Creating a PostGIS connection in QGIS
Viewing and editing PostGIS layers in QGIS
Filtering loaded features using an SQL WHERE clause
The anatomy of a PostGIS layerIntermediate
Supported spatial data typesIntermediate
Exporting data from PostGISIntermediate
The PostGIS Shapefile Import/Export Manager
Exporting features directly from QGIS
Limitations of exporting to Shapefile
Making your PostGIS layers portable with SpatiaLite
Creating new PostGIS layersIntermediate
Deleting PostGIS layersIntermediate
Working efficiently with spatial indicesIntermediate
How to create a spatial index
Where to use indices
VACUUM ANALYZE
Backing up and restoring your PostGIS dataIntermediate
Controlling database accessIntermediate
Users, groups and permissions
Access granularity
Limiting access based on IP address
Performance tips: Getting the most out of PostGISIntermediate
PostGIS data typesAdvanced
Numeric types
Character types
The binary type
Date / time types
The boolean type
Arrays
Comparison with Shapefile types
Getting started with SQLAdvanced
Entering SQL commands
Creating a table and importing data
SELECT
LIMIT
ORDER BY
DELETE
INSERT
UPDATE
Intermediate SQL operationsAdvanced
The DISTINCT clause
Aliasing
Querying multiple tables using Joins
PostGIS functionsAdvanced
What is a function?
Spatial measurement functions
Spatial relationship functions
Geometry processing functions
Performing and visualising advanced queriesAdvanced
Visualising query results in QGIS
The DB Manager plugin
Exercise: Advanced Spatial QueriesAdvanced
PostGIS Raster / WKTRasterAdvanced
How is raster data stored?
Available functions
Querying raster values
PostGIS raster performance tips
Raster table constraints and catalogs
Exercise: Attaching raster values to vector points (point inspection)Advanced
Alternative methods of loading dataAdvanced
ogr2ogr
Exercise: Importing Ordnance Survey (OS) MasterMap into PostGISAdvanced
Finding the shortest route using pgRoutingAdvanced
What can pgRouting do?
Installing pgRouting under Windows
Preparing network data for pgRouting
Exercise: Using pgRouting with OS Integrated Transport Network (ITN)Advanced
Using Views to save complex queries for re-useAdvanced
Coordinate system transforms (reprojection)Advanced
Writing pl/pgSQL functionsDeveloper
See our PostGIS for Developers training course
Automating SQL tasks using PythonDeveloper
See our PostGIS for Developers training course