GIS ESSENTIALS – “Getting spatially enabled”
Dates
PostgreSQL trainings and workshops can be held online or also at your location – and anywhere else in the world. Please contact us for details. Contact >>
Target audience
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.
Theoretical part
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
Practise part
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
Other courses that might interest you
We offer these services
High availability with Patroni
Patroni is an Open Source Cluster-Technology, which takes care of automatic failover and high availability of your PostgreSQL database. Furthermore, Patroni is simple – the Patroni-Clusters are very easy to set up and to use. Ensure high availability of your database with Patroni!
PostgreSQL Product- and 3rd Level Support
Are you using PostgreSQL as database backend for your product? Then we have the ideal solution to save you and your customers from database problems. PostgreSQL is increasingly being used as database for software and hardware solutions. Once they are sold to the customer, you are often left with the question how to offer a […]
PostgreSQL performance tuning
Is your PostgreSQL database slow? Do you see high latency, many slow query entries and are customers already complaining? If you are looking for a performance tuning because you simply want a fast, reliable database, you are on the right website. PostgreSQL Storage Tuning One part of performance tuning is storage tuning. A good storage […]