Camptocamp – Schulungen

PostGIS: spatial database

PostGIS is a module for PostgreSQL, allowing to add the spatial management, in terms of storing, handling and querying.

PostGIS is a solid, powerful and tested solution in many GIS projects.

PostGIS implements the SFS norm (Simple Feature for SQL) 1.1 of the OGC (Open Geospatial Consortium), while proposing numerous additional features as well.

Goals

  • Know the features, characteristics and limitations of PostGIS
  • Know how to implement PostGIS as a spatial database in a GIS project
  • Be autonomous in importing data and in writing spatial queries
  • Be aware of the performance issues of spatial queries

Duration

  • 3 days

Targeted audience

  • GIS developers
  • SQL and DBA developers

Prerequisites

  • Good level in SQL 92

Program

  • Presentation of PostGIS
  • Installation
  • Representation of spatial data
    • Well Known Text (WKT)
    • Well Known Binary (WKB)
  • Standards of spatial database
  • Spatial indexes
    • Creation of GIST index
    • Comparative bench on performances
  • Import and export of spatial data
  • Difference between operators and spatial functions
  • Use of clients for PostgreSQL
    • Psql
    • PgAdmin3
  • Basic spatial queries
    • Buffer calculation, centroid, area, distance …
    • Topological intersection and inclusion
  • Advanced spatial queries
    • Reprojection on-the-fly
    • Use of joins or sub-queries
    • Linear interpolation (road or hydrology data)
  • Creation and manipulation of geometries on-the-fly
  • Coupling with QGIS to visualize query results
  • Introduction to PostGIS 2.0 (option)
    • Topology
    • Raster
  • Related resources available

References

  • Communauté de communes de Moselle et Madon
  • Rennes Métropole (FR)
  • CG 48 (FR)
  • GIRtec (FR)
  • AGORAH (FR)
  • ATEN (FR)
  • CREN (FR)
  • Lyonnaise des Eaux (FR)
  • Ville de Sallanches (FR)
  • Pully (CH)

Dates

  • Contact us

Additional dates can be scheduled upon request (Lausanne, Paris, Toulouse or Chambéry)

Fee

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

Reservation and contact

formation@camptocamp.com