sdg_africa:start
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| sdg_africa:start [2023/11/14 14:16] – 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. | - 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. | - 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 ===== | ===== 2023-11-13 ===== | ||
| Line 69: | Line 79: | ||
| - Get started in QGIS. Baruch college tutorial. Getting started | - 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) | - 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 | WMS, WFS and WCS | ||
| - | - Introduction to DTM (Remote Sensing) Airborne laser scanner. | + | - Introduction to DTM (Remote Sensing) Airborne laser scanner. Gdal translate from XYZ to TIF. Import layer in QGIS Hillshade model Merging layers |
| - | Gdal translate from XYZ to TIF. | + | - Warming stripes (merging and average calculation) (python) |
| - | Import layer in QGIS | + | |
| - | Hillshade model | + | |
| - | Merging layers | + | |
| - | - Warming stripes (merging and average calculation) (python) | + | |
| - Altitude Vs Temperature (python) | - Altitude Vs Temperature (python) | ||
| - Georeferencing (digitizing) | - 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 | - 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.) | - Time Series management (generating videos and co.) | ||
| - Satellite imagery (NDVI and so on) | - Satellite imagery (NDVI and so on) | ||
| Line 98: | Line 94: | ||
| ** | ** | ||
| - | Lecture 1 introduction to RS | + | - Lecture 1 introduction to RS |
| - | Lecture 2 and 3 Remote Sensing | + | |
| - | 4 Photogrametry -> Drones | + | - Lecture |
| - | Lecture 5 | + | - Lecture |
| - | If time allows DBMS. Joins primary key, foreign key… | + | |
| - | Spatial Reference Systems (CRS) | + | - Lecture 6 If time allows DBMS. Joins primary key, foreign key…. Spatial Reference Systems (CRS) |
| + | Practicals: | ||
| - | Practical | + | - Practical GIS Divided in 3 sessions. Input data, Working with CRS, |
| - | Input data, Working with CRS, | + | |
| - | + | | |
| - | 2) | + | |
| - | Querying by attribute and by location (Geospatial) | + | |
| - | Data Visualizations and treating different data types | + | |
| - | Creating layers | + | |
| - | Summarizing data from Att Table | + | |
| - | Creating maps. | + | |
| - | 3) | + | |
| - | GPS own data creation | + | |
| - | Digitize of maps | + | |
| Practical Remote Sensing: | Practical Remote Sensing: | ||
| Line 126: | Line 114: | ||
| Accuracy assessment (how to use cancilliary data) | Accuracy assessment (how to use cancilliary data) | ||
| Change detection | Change detection | ||
| + | |||
| + | Flood risk mapping. | ||
| + | Interpolation and suitability analysis | ||
sdg_africa/start.1699967788.txt.gz · Last modified: 2023/11/14 14:16 by clein_alexander.sarmiento_castrillon