Training PostGIS: spatial database
PostGIS is a module for PostgreSQL, allowing to add spatial management, in terms of storing, handling and querying.
PostGIS is a solid, powerful and well-tested solution used 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.
Dates and locations
- Trainings can take place in our offices
- Private training sessions can also be organized across Europe upon request
- Here you can find the schedule of inter-company sessions for the current year and for 2022
Target audience and prerequisites
- GIS developers, SQL and DBA developers
- Good level in SQL 92
Goals
- Learn the features, characteristics and limitations of PostGIS
- Learn how to implement PostGIS as a spatial database in a GIS project
- Be autonomous in importing data and writing spatial queries
- Be aware of the performance issues of spatial queries
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
Presentation of PostGIS
Installation
Representation of spatial data
- Well Known Text (WKT)
- Well Known Binary (WKB)
Spatial Database Standards
Day 2
Spatial indexes
- Creation of GIST index
- Comparative bench on performances
Importing and exporting spatial data
Difference between operators and spatial functions
Using PostgreSQL clients
- Psql
- PgAdmin3
Basic spatial queries
- Buffer calculation, centroid, area, distance …
- Topological intersection and inclusion
Day 3
Advanced spatial queries
- Reprojection on-the-fly
- Using 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
Your Trainer:
Yves Jacolin
Contact and booking
Additional training
This training can be paired with the PostGIS advanced implementation and/or the Postgre SQL training.
Career
Interested in working in an inspiring environment and joining our motivated and multicultural teams?
- Senior Infrastructure Engineer (m/f/d) - Zurich/Olten
- ERP Consultant Odoo Smartcamp (m/f/d) - France
- IT Project Manager (m/f/d) - Zurich/Olten
- GIS Technical Consultant (m/f/d) - Zurich/Olten
- ERP Consultant Odoo Smartcamp (m/f/d) - Zurich/Olten
- Odoo Developer Internship (m/f/d) - Chambéry
- Odoo Developer (m/f/d) - Olten/Zurich/Munich
- ERP Project Manager (m/f/d) - France