This is an intermediate-level course.
PostGIS is a spatial database that is more than just a spatial data store. With PostGIS, users, web map servers and other applications can all run off the same database. And beware! Doing spatial analysis in PostGIS can become addictive.
PostGIS and PostgreSQL provide a powerful, enterprise ready geospatial relational database management system. With PostGIS you can insert geometries into a database and then perform spatial queries and analysis on that data. We will show you how to import and export data into PostGIS, manipulate that data using SQL queries and of course visualise the resulting datasets with QGIS. Note that the content in this module will be technical in nature but no basic working knowledge of database systems (tables, fields, primary and foreign keys etc.) is assumed, so we are 'starting from scratch'. We will also look at how PostGIS is used in the context of rolling out an integrated FOSS-based GIS enterprise solution, as well as how it can work in a mixed environment. PostGIS is the cornerstone providing an enterprise platform from which to carry out desktop GIS, in-database analysis and data processing, web mapping and the provision of OGC compliant web services.
Assessment is based on successful completion of the exercises interspersed among the teaching modules.
QGIS is used extensively throughout the course to visualise results, as a SQL client (via the DB Manager) and to load data into PostGIS. pgAdmin and other clients are also introduced. SQL commands written during the course are saved by the student as a reference and so they can review or re-use the queries back at home or work.
We encourage students to bring their own data so that if they have the time and capability during the course, they can implement on their own data the skills they learn in the course and even go back to the office with a ready-to use spatial database.
This course is based to a large extent on the open BoundlessGeo course at http://workshops.boundlessgeo.com/postgis-intro/, with modifications and extensions by Kartoza.
The use of personal Laptops are required for this course.
One or more of the following;
1 point (category 1b)
Price includes VAT, teas and lunches, software, course material and data and a certificate of attendance.