Concept

PostGIS

Related lectures (6)

Creating Test Databases

Covers the creation of test databases for SQL queries using Spatialite and Postgis with QGIS.

Setup of the test databases

Covers the setup of test databases for SQL queries and using Spatialite and Postgis databases with QGIS.

Geometric Spatial Queries

Explores using SQL queries in QGIS for selecting spatial objects and extracting properties from geometries.

Geometric spatial queries: summary

Explores spatial queries in QGIS, selecting objects based on conditions and extracting properties of geometries stored in a database.

Vector-Vector Data Layer Interactions

Covers interactions between vector layers in GIS, including geometric properties, spatial arrangement, autocorrelation, altitude models, and SQL equivalents.

Case Study: Pollution of Ebrie Lagoon

Explores GIS through a case study on Ebrie Lagoon pollution and the methodology to assess and address environmental issues.