Unavailable

Making the most of PostGIS Spatial Databases for QGIS

Event Information

Share this event

Date and Time

Location

Location

Old Fire Station Enterprise Centre

2 Salt Lane

Salisbury

SP1 1DU

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

Prices for 2 full day training course

Early bird ticket price £325 +VAT

Full ticket price £375 +VAT

If you would prefer to pay by Purchase Order or bank transfer, please contact us at +44(0)7720 290821 or training@geoascent.com to complete your booking.

The course fee include all course material including a USB stick, refreshments and lunch each day

Outline

This concise course is aimed at the GIS user who would like to build their knowledge and skills of working with spatial databases. The course uses PostgreSQL/ PostGIS spatial database although the theory is applicable to other compatible database systems including MS SQL Server and Oracle. There are both taught and practical elements during the two days with the opportunity to use the available opensource tools to carry out crafted exercises.

The two day course will have provided the delegate the opportunity to learn and practice using PostGIS as a data repository for QGIS. The delegate will have understood the basics of PostgreSQL / PostGIS and have had practical experience in its use; including writing queries and building functions and triggers. They will have developed their skills to carry GIS tasks more efficiently while enhancing data management and data security.

Content

1. Introduction to PostGIS

  • Setting up PostgreSQL / PostGIS
  • PostgreSQL architecture
  • Geographical elements

2. Interacting with databases in QGIS

  • Loading tables as layers
  • Using plugins

3. Basic SQL & how to use spatial functions

  • SQL the basics
  • Key spatial functions (including intersect, buffers and distance)

4. Building a relational database and interface using QGIS forms.

  • Designing a relational database
  • Keys
  • QGIS forms

5. Building simple triggers and functions

  • Overview of functions and triggers
  • Practical exercise to create a trigger function to semi-automate a GIS task.

6. Managing your Spatial Data Warehouse

  • Schemas
  • Users and roles
  • Permissions
  • Metadata in QGIS
  • Database backups

Note that the course content is subject to change

Pre-requisites

Delegates should be IT literate and have some working knowledge in the use of GIS. Basic knowledge of Structured Query Language (SQL) would be an advantage, although not essential.

Delegates will need to bring a laptop with them to use for the training. This ideally will be a Windows laptop that will be able to run software from a USB drive. If there is any doubt we can provide the drive in advance for testing. There is no need to have the software installed in advance unless you are using Linux or Apple, then please could you have installed QGIS 2.18 and PostgreSQL 9.5 / PostGIS 2.0 or later. It is also possible to hire laptops please contact us at training@geoascent.com to arrange this.

See course page for more details

Share with friends

Date and Time

Location

Old Fire Station Enterprise Centre

2 Salt Lane

Salisbury

SP1 1DU

United Kingdom

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved