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