Duration: 1 day

Cost: £500 ex VAT

PostGIS is an open source spatial database built on top of the enterprise level PostgreSQL database. PostGIS adds standards compliant support for geographic objects to the PostgreSQL object-relational database allowing it to be used as a spatial database for geographic information systems (GIS).

This hands-on training course is designed to help you get started with PostGIS, covering the installation, configuration, management and use of a spatial database. Delegates will learn how to create spatial databases, load data from a number of different sources, perform queries and connect via common GIS tools.

The course is aimed at those who are interested in learning more about spatial databases, and while no formal pre-requisites are required, familiarity with basic GIS concepts is preferred.

Course description

The full course description is available to download. In summary it includes the following sessions:

• Introduction to open software, standards and data
• Installation and configuration
• Creating spatial database schemas
• Loading data via shp2pgsql
• PostGIS metadata tables
• PostGIS spatial functions
• Connecting to data via a desktop GIS
• Logging and error reporting
• Vacuuming data
• Adding and removing tables
• Adding, removing and managing users

The course is aimed at new users so there are no prerequisite skills required to attend this course. However, it is preferable that you have some familiarity with basic GIS concepts. Customers who attend this course may also benefit from GeoServer training.

Next steps

A full course description is available for this course.

View the training schedule or, if you know which course dates you would like to reserve, book online now to guarantee your place.

Should you wish to discuss your training requirements, please contact our Training Co-ordinator, Craig Dean, on 01527 556920 or email training@dottedeyes.com.

Accreditation

This course has been submitted to the AGI for accreditation as part of the Chartered Geographer Scheme and will be allocated points in due course. Visit the AGI website or the Royal Geographical Society website for more information about the Chartered Geographer scheme.

What our delegates say about our open source training

"The training we received from Dotted Eyes has allowed us to replace our heavily-utilised mapping solution with an open source alternative within tight timescales. In the short-term we have seen considerable functional and performance benefits, while the year-on-year cost savings are very welcome in the current financial climate."

Tim Needham, West Midlands Fire Service

Summer 2010