Differences

This shows you the differences between two versions of the page.

--- sdg_africa:start [2023/11/14 14:17] – clein_alexander.sarmiento_castrillon
+++ sdg_africa:start [2023/11/14 15:24] (current) – clein_alexander.sarmiento_castrillon
@@ Line 60: / Line 60: @@
   - create the gdf and give them the previous notebook as parallel.
   - Instructions on how to change the visibility and display the labels on QGIS. Maybe add a clipping operation or an intersection.
+===== 2023-11-10 =====
+  - Selenium as alternative for webscrapping
+  - Letting the driver install by itself when needed
+  - Database fundamentals with Anup
+  - Exercise on creating own database in postgresql and pgadmin4
+  - Exercise on creating own tables
+  - Exercise on creating primary key and foreign key
+  - Exercise on populating database
 ===== 2023-11-13 =====
@@ Line 69: / Line 79: @@
   - Get started in QGIS. Baruch college tutorial. Getting started
   - CRS Theory, but also a practical. Using 4 different files as example for the CRS practical. Divide the data by regions or so. (maybe its more helpful if they are geographically close instead of overlaying)
-  - Geopandas 0130: Creating a polygon layer
+  - Geopandas 0130: Creating a polygon layer. Scrapping data with Beatiful soup. To create the generalized polygon vector (DTMs)
-Scrapping data with Beatiful soup. To create the generalized polygon vector (DTMs)
 WMS, WFS and WCS
   - Introduction to DTM (Remote Sensing) Airborne laser scanner. Gdal translate from XYZ to TIF. Import layer in QGIS Hillshade model Merging layers
-  - Warming stripes (merging and average calculation) (python)
+  - Warming stripes (merging and average calculation) (python) -> Change by precipitation instead To show temporal controller
   - Altitude Vs Temperature (python)
   - Georeferencing (digitizing)
-  - Database management systems (installing Postgresql)
+  - Database management systems (installing Postgresql). Database Setup. Create users and databases. Create example relations. Create tables. Relational Algebra
-Database Setup
-Create users and databases
-Create example relations
-Create tables
-Relational Algebra
   - Database normalization. Examples and 1NF, 2NF and 3NF
-  - Groundwater Lanuv: Reading the data from Lanuv
+  - Groundwater Lanuv: Reading the data from Lanuv. Problem with data obfuscation. PostGIS: using geopandas. Time series. SQL
-Problem with data obfuscation
-PostGIS: using geopandas
-Time series
-SQL
   - Time Series management (generating videos and co.)
   - Satellite imagery (NDVI and so on)
@@ Line 94: / Line 94: @@
 **
-Lecture 1 introduction to RS
+  - Lecture 1 introduction to RS
-Lecture 2 and 3 Remote Sensing
+  - Lecture 2 RS
-Photogrametry -> Drones
+  - Lecture 3 Remote Sensing
-Lecture 5  and 6 Introduction to GIS -> Data acquisition, input…
+  - Lecture 4 Photogrametry -> Drones
-If time allows DBMS. Joins primary key, foreign key…
+  - Lecture 5  Introduction to GIS -> Data acquisition, input… GIS functions
-Spatial Reference Systems (CRS)
+  - Lecture 6 If time allows DBMS. Joins primary key, foreign key…. Spatial Reference Systems (CRS)
+Practicals:
-Practical 1) GIS Divided in 3 sessions.
+  - Practical GIS Divided in 3 sessions. Input data, Working with CRS,
-Input data, Working with CRS,
+  - Querying by attribute and by location (Geospatial). Data Visualizations and treating different data types. Creating layers. Summarizing data from Att Table. Creating maps.
+  - GPS own data creation.  Digitize of maps
-)
-Querying by attribute and by location (Geospatial)
-Data Visualizations and treating different data types
-Creating layers
-Summarizing data from Att Table
-Creating maps.
-)
-GPS own data creation
-Digitize of maps
 Practical Remote Sensing:
@@ Line 122: / Line 114: @@
 Accuracy assessment (how to use cancilliary data)
 Change detection
+Flood risk mapping.
+Interpolation and suitability analysis