Introduction to PostGIS

This is an intermediate-level course.
Geospatial Data in PostGIS

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.

CPD: 1 point (category 1b)

2 days:  R3000 (excl VAT)

Price includes, teas and lunches, a DVD with software, course material and data and a certificate of attendance.

T&Cs apply