Visibility and Viewshed Analysis
![](https://www.donike.net/wp-content/uploads/viewshed_poster.png)
In this project, an imaginary high-rise hotel building proposal is analysed regarding it’s visual impact on the city of Salzburg. Viewshed analysis and Line-of-Sight Analysis are performed.
Managing Roles in PostgreSQL
![](https://www.donike.net/wp-content/uploads/Ambox_padlock_gray.png)
In this exercise, some role managing and security operations are performed. Roles are created, given permissions and view queries created that allow managing the restriction of information within a database.
Surface Runoff Analysis
![](https://www.donike.net/wp-content/uploads/2020-12-16-00_09_28-Window.png)
In this post, the Neubach catchment area is analyzed again, this time focusing on surface runoff parameters such as flow lengths, flow accumulations and runoff times.
SQL for Spatial Queries
![](https://www.donike.net/wp-content/uploads/postgres_4-1.png)
In this exercise, some basic GIS functionalities are performed with SQL/PostGIS commands, such as Union, Intersect and Buffer.
Terrain Analysis
![](https://www.donike.net/wp-content/uploads/hillshade_catchment.png)
This Post focuses on analyzing a river catchment area, producing slope and curvature statistics and visualizations.
Google Earth Engine – Charts
![](https://www.donike.net/wp-content/uploads/ee-chart.png)
This post shows both the code and the result from Google Earth Engine’s reduced Charts by region for 4 selected mountaintops around the world.
PostgreSQL & PostGIS – First Steps
![](https://www.donike.net/wp-content/uploads/postgres_6-e1606255319445.png)
The DBMS PostgreSQL and the geospatial extension PostGIS are used to load Shapefiles into QGIS and perform SQL querries.
Interpolation – IDW
![](https://www.donike.net/wp-content/uploads/idw_4.png)
This exercise deals mainly with the IDW method and its parameters, calculating the temperature gradient across Fenoscandia. Also, IDW quality measures are discussed.
UAV Photogrammetry
![](https://www.donike.net/wp-content/uploads/UAV_scr_1.png)
In this Assignment, a workflow is followed that creates a dense point cloud, Orthoimage and DEM from UAV data in Munich, Germany.
Network Analysis – Story Map
![](https://www.donike.net/wp-content/uploads/network_analysis_featured_image-e1606216185534.png)
This ESRI ArcOnline Story Map shows the result of the “Network Analysis” assignment of the Methods in Spatial Analysis class.