Adiel Batson (28067), Daphne Larose (27571), Kshama Gauri (27628)
This repository utilizes various software to extract, format, display and analyze geo-spatial data derived from opendata.dwd.de. As students of Environment & Energy BSc it is a great gift to be able learn to understand how the world works around us. This project is interesting because the student moves from understanding how observations are made to engineering observational solutions in geo-termporal frameworks and other illustrative/predictive software. This learnable ability is amazing.
As a team we attempt to fulfill all the tasks predetermined in the file located here https://github.com/rolfbecker/EE_3.07_Geodata_WS2021/tree/main/gdms0000_Final_Assignment.
The Task Folders above contain all necessary data imports and exports to which each author specialized. An annotated workflow (walkthrough) is also provided. Shared outputs eg. Task 4 and Presentation & Video Presentation are combined efforts.
- QGIS Geographical Information System: http://qgis.org/en/site/
- PostgreSQL Database Management System: https://www.postgresql.org/
- PostGIS Spatial Database Extension for PostgreSQL: http://postgis.net/
- Anaconda Python distribution: https://www.anaconda.com/
- notepad++ Text Editor (for Windows users only): https://notepad-plus-plus.org/
- FileZilla Free FTP, FTP over TLS, ans SFTP client: https://filezilla-project.org/
- WinSCP Free FTP, SFTP, SCP client for Windows: https://winscp.net/
- pandas
- geopandas
- shapely
- fiona
- pyproj
- rasterio
- sqlalchemy
- psycopg2
- ftplib
- ipython-sql # SQL magic function
- sk.learn
- point sampling tool
- Profile tool
- GDAL Georeferncer
- QGIS Tile Downloader from https://github.com/khaymanr/qgis_tile_downloader
Professor Rolf Becker - https://github.com/rolfbecker/EE_3.07_Geodata_WS2021.git.
The open source dataset of dwd.de is a primary source of data for teh project (found here https://opendata.dwd.de/climate_environment/CDC/observations_germany/climate/annual/climate_indices/kl/historical/).
Furthermore, within each Task folder references for other used data are recorded and linked.