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:14] – 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 65: | Line 75: | ||
**Material for HSRW divided in possible lecture days:** | **Material for HSRW divided in possible lecture days:** | ||
- | 1) Introduction to Geodata. Spatio-temporal data. First approach to python (getting familiar with Notebooks and downloading the material). Installing all the dependencies. (could be replaced by JupyterHub) | + | - Introduction to Geodata. Spatio-temporal data. First approach to python (getting familiar with Notebooks and downloading the material). Installing all the dependencies. (could be replaced by JupyterHub) |
- | 2) DWD_NRW: Using python to download data. Using the ftp server. Using os.makedirs. Data wrangling (“working with data in other languages”). Saving csv data. Importing csv data into QGIS. Import vector data (the admin. Boundaries). Mapping | + | |
- | 3) Get started in QGIS. Baruch college tutorial. Getting started | + | |
- | 4) 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) | + | |
- | 5) Geopandas 0130: Creating a polygon layer | + | |
- | Scrapping data with Beatiful soup. To create the generalized polygon vector (DTMs) | + | |
WMS, WFS and WCS | WMS, WFS and WCS | ||
- | 6) 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. | + | |
- | Import layer in QGIS | + | |
- | Hillshade model | + | |
- | Merging layers | + | |
- | 7) Warming stripes (merging and average calculation) (python) | + | |
- | 8) Altitude Vs Temperature (python) | + | |
- | 9) Georeferencing (digitizing) | + | |
- | 10) Database management systems (installing Postgresql) | + | |
- | Database Setup | + | |
- | Create users and databases | + | |
- | Create example relations | + | |
- | Create tables | + | |
- | Relational Algebra | + | |
- | 11) Database normalization. Examples and 1NF, 2NF and 3NF | + | |
- | 12) Groundwater Lanuv: Reading the data from Lanuv | + | |
- | Problem with data obfuscation | + | |
- | PostGIS: using geopandas | + | |
- | Time series | + | |
- | SQL | + | |
- | 13) Time Series management (generating videos and co.) | + | |
- | 14) Satellite imagery (NDVI and so on) | + | |
**Material from Makerere University: Course GIS and Remote Sensing in Natural Resource Management | **Material from Makerere University: Course GIS and Remote Sensing in Natural Resource Management | ||
** | ** | ||
- | 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.1699967669.txt.gz · Last modified: 2023/11/14 14:14 by clein_alexander.sarmiento_castrillon