Spatial query

Jump to: navigation, search

A spatial query is a special type of database query supported by geodatabases. The queries differ from SQL queries in several important ways. Two of the most important are that they allow for the use of geometry data types such as points, lines and polygons and that these queries consider the spatial relationship between these geometries.

Types of queries

The function names for queries differ across geodatabases. The following list contains commonly used functions built into PostGIS, a free geodatabase which is a PostgreSQL extension (the term 'geometry' refers to a point, line, box or other two or three dimensional shape):

Function prototype: functionName (parameter(s)) : return type

  • Distance(geometry, geometry) : number
  • Equals(geometry, geometry) : boolean
  • Disjoint(geometry, geometry) : boolean
  • Intersects(geometry, geometry) : boolean
  • Touches(geometry, geometry) : boolean
  • Crosses(geometry, geometry) : boolean
  • Overlaps(geometry, geometry) : boolean
  • Contains(geometry, geometry) : boolean
  • Intersects(geometry, geometry) : boolean
  • Length(geometry) : number
  • Area(geometry) : number
  • Centroid(geometry) : geometry

For another definition of Spatial Query consult A to Z GIS: An Illustrated Dictionary of Geographic Information Systems from ESRI Press

See also