Lecture

Geometric Spatial Queries

Graph Chat

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.

Description

This lecture covers the use of the built-in query tool in QGIS to select spatial objects based on conditional SQL-like queries. It also explores how SQL functions can be used in databases like SpatiaLite and PostGIS to extract properties and features of geometries. The lecture delves into functions for selecting geometric objects, extracting reference system codes, converting formats, retrieving spatial objects graphically, and extracting various characteristics and numerical features of spatial objects.

In MOOC

Geographical Information Systems 1

In this first part of the course, we will focus on the digitization and the storage of geodata. In particular, you will learn:

To characterize spatial objects and/or phenomena (territory modeling) with respect to their position in space (through coordinate systems, projections, and spatial relationships) and according to their intrinsic nature (object/vector mode vs. Image/raster mode);
About the different means used to acquire spatial data; including direct measurement, georeferencing images, digitiza

Official source

Related concepts (6)

Spatial database

A spatial database is a general-purpose database (usually a relational database) that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data. Most spatial databases allow the representation of simple geometric objects such as points, lines and polygons. Some spatial databases handle more complex structures such as 3D objects, topological coverages, linear networks, and triangulated irregular networks (TINs).

QGIS

QGIS is a free and open-source cross-platform desktop geographic information system (GIS) application that supports viewing, editing, printing, and analysis of geospatial data. QGIS functions as geographic information system (GIS) software, allowing users to analyze and edit spatial information, in addition to composing and exporting graphical maps. QGIS supports raster, vector and mesh layers. Vector data is stored as either point, line, or polygon features. Multiple formats of raster images are supported, and the software can georeference images.

PostGIS

PostGIS (ˈpoʊstdʒɪs ) is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). Technically PostGIS was implemented as a PostgreSQL external extension. Geometry types for Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons, GeometryCollections, 3D types TINS and polyhedral surfaces, including solids.

Geospatial topology

Geospatial topology is the study and application of qualitative spatial relationships between geographic features, or between representations of such features in geographic information, such as in geographic information systems (GIS). For example, the fact that two regions overlap or that one contains the other are examples of topological relationships. It is thus the application of the mathematics of topology to GIS, and is distinct from, but complementary to the many aspects of geographic information that are based on quantitative spatial measurements through coordinate geometry.

SQLite

SQLite (ˌɛsˌkjuːˌɛlˈaɪt, ˈsiːkwə,laɪt) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most widely deployed database engine, as it is used by several of the top web browsers, operating systems, mobile phones, and other embedded systems. Many programming languages have bindings to the SQLite library.

Related lectures (18)

Vector-Vector Data Layer Interactions MOOC: Geographical Information Systems 2

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

Raster - Vector Integration MOOC: Geographical Information Systems 2

Covers the integration of raster and vector data in GIS using QGIS.

Creating Test Databases MOOC: Geographical Information Systems 1

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

Introduction to QGIS MOOC: Geographical Information Systems 1

Covers the basics of QGIS, including project management, data manipulation, and map production.

Setup of the test databases MOOC: Geographical Information Systems 1