U de C - logo

SPATIAL DATABASES

diicc - logo

Logical Data Models and Languages > Relational Model > Query language

A query language is connected to the operations of a spatial algebra (including predicates for spatial relationships). Fundamental spatial algebra operators are: Spatial selection: It returns those objects that satisfy a spatial predicate with the query object. Spatial join: A join which compares any two joined objects based on a predicate on their spatial attribute values.

SELECT r.rname, c.cname
FROM r in rivers, c in cities
WHERE r.route->intersect(Castilla.area) and r.route->dist(c.area) < 50

Valid HTML 4.0! Valid CSS!