Are you interested in various methods of data clustering, managing geospatial 3D data in databases or optimizing SQL efficiency? And how on earth can one analyze Big Data in practice? Advanced geospatial SQL enables various ways to manage, analyze, and process humongous GIS datamasses efficiently. In this course the student learns advanced SQL queries and how to use them when analyzing and processing vast spatial data in PostGIS. This course focuses on especially in spatial relations (joins, nearest neighbour...), data clustering and interpolation, and geometric and topologic validations.
The course and the course materials are in english (if there are only finnish speking students, the course can be held in finnish but materials are still in english). The course consists of lectures and exercises (license CC-BY-ND 4.0). The course will be held in two three hour-long sessions within two workdays (2 x 3 hours).
This course is for those, who have basic GIS and PostGIS skills and craves for more. The course is especially beneficial to those, who have large spatial datasets which need efficient managing, processing and analyzing in a spatial database.
The course will be held with Gispo's online tools (which usually means Google Meet) and it is divided into three hour-long sessions. In Gispo's online courses the student can ask questions and if needed, share their screen.
After the course you get GispoHelp support service for two months! You can get personal support when using the software through the support service.
If you can not participate this course, you can send someone else instead of you. If cancellation is done less than 14 days before the course start, we will charge 50% of the price. In case of no show without any cancellation, we will charge the whole price. Cancellation fee will also be charged in case of illness.