Spatial relationships

A primary function of a GIS is to determine the spatial relationships between features: Do they overlap? Is one contained by the other? Does one cross the other?

Geometries can be spatially related in different ways. The following are examples of how one geometry can be spatially related to another:

To determine whether these relationships exist or not, execute spatial relationship functions. These functions compare the following properties of the geometries you specify in your query:

When you construct a spatial relationship query, specify the type of spatial relationship you are looking for and the geometries you want to compare. The queries return as either true or false; either the geometries participate with one another in the specified spatial relationship or they do not. In most cases, you would use a spatial relationship query to filter a result set by placing it in the WHERE clause.

For example, if you have a table that stores the locations of proposed development sites and another table that stores the location of archaeologically significant sites, you might want to make sure that the features in the development sites table do not intersect the archaeological sites. You could issue a query to make sure none of the development sites intersect archaeology sites and, if any do, return the ID of those proposed developments. In this example, the ST_Disjoint function is used.

SELECT d.projname,a.siteid
FROM dev d, archsites a
WHERE sde.st_disjoint(d.shape,a.shape)= 'f' 

projname        siteid

bow wow chow    A1009

This query returns the name of the development and the ID of the archaeological site that are not disjoint—in other words, the sites that intersect one another. It returns one development project, Bow Wow Chow, which intersects archaeological site A1009.

For information on ST_Geometry functions that test spatial relationships in Oracle or PostgreSQL, see Spatial relationship functions for ST_Geometry. For information on spatial relationship functions used with IBM DB2, IBM Informix, Oracle Spatial, PostGIS, or Microsoft SQL Server spatial types, see the documentation for those database management systems.

Related Topics