Training PostGIS: advanced implementation

This session, geared for experienced PostGIS users, will allow to become more experienced in the use, optimization and administration of this spatial database; it will help you maximize the power of the spatial functions of the tool, to rewrite queries, to optimize performance significantly, and to administer a PostGIS database in production.

Dates and locations

Trainings can take place in our offices. Please contact us.

Private training sessions can also be organized across Europe upon request

Target audience and prerequisites

GIS Developers, DBA
Very good knowledge of SQL 92 and relational model, Good level using PostGIS, Good knowledge of database administration, Mastery of a programming language

Goals

Be able to use advanced spatial features
Know how to use the main mechanisms and optimization methods
Know the specifics of the administration of a spatial database

Price

Public training in France or Switzerland: please contact us
Private training: please contact us
From 700 € or 900 CHF / day / trainee (for other currency, please contact us)

Camptocamp curriculum

Lecture content/Topics

Day 1

Complex spatial analysis

Advanced spatial queries
Complex topological tools (ST_RELATE)
Validation and topological clean-up of geographical data
Pl/PgSQL programming basis

Low-level PostGIS architecture

liblwgeom, lwgeom, GEOS
Spatial data structures

Day 2

Optimization of spatial queries

Understand the plan of an SQL query with PostgreSQL
Analysis of performances of SQL queries
Configuration of PostgreSQL: postgresql.conf file
Optimization of spatial queries
Advanced use of spatial indexes
Optimization of physical storing

Relational model

Specificities of the data relational model of PostgreSQL (inheritance, scheme, etc.)
Verification of spatial data
Dynamic creation of tables or spatial views