Geodatabase with QGIS and PostGIS
The Geodatabases course is aimed at those who need to learn how to manage a
geodatabase of complex geographic data. The course also covers the use of PostGIS
many database functions that allow for complex geoprocessing to be carried out
within the database and displayed in real-time.
Upon completion of the course, trainees will dispose of a fully featured
virtual PostGIS server, ready to be uploaded to any virtualised environment
provider.
It is suggested to have basic knowledge of the SQL language.
Course outline
- Short introduction to Free and Open Source GIS
- Advantages of using a database for GIS
- Introduction to
PostgreSQL <https://www.postgresql.org/>
__
- Initial database configuration: configuration files, server management
- PostgreSQL optimisation
- Introduction to PostGIS (Open Geospatial Consortium standard)
- Geodatabases: structure and format of the data
- Command line administration: psql
- The graphical front-ends: QGIS, phpPgAdmin, pgAdmin III, OpenOffice, etc.
- Administration of the database and access to the data: role, user, group, permissions
- Schemas, Tables, Views, and Functions
- Creation of a geodatabase and the use of the GIS template
-
PostGIS and QGIS
- Properties, import/export, conversion between formats
- digitizing
- queries, advanced plugins, versioning, etc.
- SQL spatial analyses: practical exercises, basic and advanced
- Spatial indexes
- Benchmarking
- Advanced geodatabase functions
- Spatial reference systems, conversions
- PostGIS rasters
- Topology support
- Backing up (dumping and restoring)
Length
Three days, full time