PostgreSQL trainings and workshops can be held online or also at your location – and anywhere else in the world. We also offer every training as an online training. Please contact us for details. Contact >>

This GIS course enables participants to identify potentials of spatial data and to put them to use.

Theoretical essentials in geoinformatics form the foundation, in order to gain a broad understanding of the subject matter. The second part brings import, visualisation and analysis of geodata, using OpenSource-tools, into focus. The used data will primarily come from OpenStreetMap.

Applications

What is spatial data and how can you use it?
Getting started with the world of geoinformatics and its applications

Spatial modelling

• Coordinate systems – what are they good for and what do you need to keep in mind when it comes to data acquisition?
  An overview of geographical and projected coordinate systems
• Topology
• Vector versus raster data

Spatial indexing
Spatial data should also be indexed, in order to ensure data quality and performance. Spatial indexing algorithms will be presented.

Spatial analysis

Which analyses can be made, and which questions can be answered by use of GIS?

GIS-tools
How is spatial data processed?
An overview of popular tools, focusing on OpenSource.

GIS-Services
What kind of spatial services do exist and are of special interest for companies?

• Mapping
• Routing
• Geocoding

Preparation
Setup PostgreSQL with PostGIS as a spatial database
Setup QGIS

Data acquisition
Downloading OSM-data for further processing

Data import
Import using QGIS, osm2pgsql, ogr2ogr, osmosis

Data visualisation
Simple visualisation with the help of QGIS

Data analysis
Data analysis with QGIS and PostGIS in comparison

Data export
Data transfer and -backup with GQIS and database-tools