Class #6

25 Fevereiro 2021, 11:00 • Maria da Graça Corte-Real Mira da Silva Abrantes

SQL in GIS

• SELECT BY EXPRESSION
• SELECT BY LOCATION

Quiz

Slides: Organizing Data in GIS (slides #21 to #29)

2 Zoom rooms:

GIS beginners - exercise  LearningByExample - basic QGIS tools and elementary spatial operations (reviewing and summarizing)
Other students - Linking spatial objects (NUTs) to geographic data indirectly georreferenced (from providers of geographic information such as INE, PORDATA, Eurostat, ...)

Class #5

22 Fevereiro 2021, 11:00 • Maria da Graça Corte-Real Mira da Silva Abrantes

Relational Database Normalization - the 3^rd Normal Form

Slides: Organizing Data in GIS (slides #12 to #20)

2 Zoom rooms:

GIS beginners - exercise LearningByExample1-2.pdf - basic QGIS tools and elementary spatial operations (examples)
Other students - Normalizing CAOP2021 and creating portuguese NUTs (exercice) - linking spatial objects (NUTs) to geographic data indirectly georreferenced (from oficial providers of geographic information)

Class #4

18 Fevereiro 2021, 11:00 • Maria da Graça Corte-Real Mira da Silva Abrantes

2 Zoom rooms:

GIS beginners - Information Systems and Geographic Information Systems. Organizing Data in GIS - the relational database model.Slides:  IS and GIS,  Organizing Data in GIS (slides #2 to #11)
Other students - Reviewing and applying the 3rd NF of the relational database model (exercice)

Class #3

15 Fevereiro 2021, 11:00 • Maria da Graça Corte-Real Mira da Silva Abrantes

2 Zoom rooms:

Class #2

11 Fevereiro 2021, 11:00 • Maria da Graça Corte-Real Mira da Silva Abrantes

Introduction to the QGIS interface (slides 1 to 20 - GIS beginners).