Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Lecture

Topological spatial queries

Description

This lecture introduces topological spatial queries in Geographic Information Systems, covering SQL queries to explore spatial relations, calculate distances, and create new objects through intersection, difference, and more. It also explains SQL functions for spatial operators like Intersection, Difference, Union, SymDifference, Buffer, and ConvexHull.

In MOOC

Geographical Information Systems 1

Official source

Related concepts (32)

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.

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).

Geographic information system

A geographic information system (GIS) consists of integrated computer hardware and software that store, manage, analyze, edit, output, and visualize geographic data. Much of this often happens within a spatial database, however, this is not essential to meet the definition of a GIS. In a broader sense, one may consider such a system also to include human users and support staff, procedures and workflows, the body of knowledge of relevant concepts and methods, and institutional organizations.

Geographic information science

Geographic information science (GIScience, GISc) or geoinformation science is a scientific discipline at the crossroads of computational science, social science, and natural science that studies geographic information, including how it represents phenomena in the real world, how it represents the way humans understand the world, and how it can be captured, organized, and analyzed. It is a sub-field of geography, specifically part of technical geography.

Geographic data and information

Geographic data and information is defined in the ISO/TC 211 series of standards as data and information having an implicit or explicit association with a location relative to Earth (a geographic location or geographic position). It is also called geospatial data and information, georeferenced data and information, as well as geodata and geoinformation. Approximately 90% of government sourced data has a location component. Location information (known by the many names mentioned here) is stored in a geographic information system (GIS).

Related lectures (49)

Bush fires in the Sahelian area MOOC: Geographical Information Systems 1

Explores the causes and consequences of bush fires in the Sahelian area, emphasizing the role of Geographic Information Systems.

Geometric spatial queries MOOC: Geographical Information Systems 1

Covers SQL queries for exploring spatial geometries and their properties in a database.

Digitization of Vector Objects MOOC: Geographical Information Systems 1

Covers the digitization of vector objects in GIS, including creation, editing, and topology management.

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.

Creating Test Databases MOOC: Geographical Information Systems 1