Camptocamp – 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.

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

Duration

2 days

Targeted audience

  • GIS Developers
  • DBA

Prerequisites

  • Very good knowledge of SQL 92 and relational model
  • Good level using PostGIS
  • Good knowledge of database administration
  • Mastery of a programming language

Program

  • 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
  • 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

References

  • INRA (FR)

Dates

Upon request

Price

  • Upon request
  • Tax exempt if training is part of a convention

Reservation and contact

formation@camptocamp.com