DE-9IM

From HandWiki
DE-9IM-logoSmall.png

The Dimensionally Extended 9-Intersection Model (DE-9IM) is a topological model and a standard used to describe the spatial relations of two regions (two geometries in two-dimensions, R2), in geometry, point-set topology, geospatial topology, and fields related to computer spatial analysis. The spatial relations expressed by the model are invariant to rotation, translation and scaling transformations.

The matrix provides an approach for classifying geometry relations. Roughly speaking, with a true/false matrix domain, there are 512 possible 2D topologic relations, that can be grouped into binary classification schemes. The English language contains about 10 schemes (relations), such as "intersects", "touches" and "equals". When testing two geometries against a scheme, the result is a spatial predicate named by the scheme.

The model was developed by Clementini and others[1][2] based on the seminal works of Egenhofer and others.[3][4] It has been used as a basis for standards of queries and assertions in geographic information systems (GIS) and spatial databases.

Matrix model

The DE-9IM model is based on a 3×3 intersection matrix with the form:

[math]\displaystyle{ \operatorname{DE9IM}(a,b) = \begin{bmatrix} \dim(I(a) \cap I(b)) & \dim(I(a) \cap B(b)) & \dim(I(a) \cap E(b)) \\ \dim(B(a) \cap I(b)) & \dim(B(a) \cap B(b)) & \dim(B(a) \cap E(b))\\ \dim(E(a) \cap I(b)) & \dim(E(a) \cap B(b)) & \dim(E(a) \cap E(b)) \end{bmatrix} }[/math]

 

 

 

 

(1)

where [math]\displaystyle{ \dim }[/math] is the dimension of the intersection (∩) of the interior (I), boundary (B), and exterior (E) of geometries a and b.

The terms interior and boundary in this article are used in the sense used in algebraic topology and manifold theory, not in the sense used in general topology: for example, the interior of a line segment is the line segment without its endpoints, and its boundary is just the two endpoints (in general topology, the interior of a line segment in the plane is empty and the line segment is its own boundary).

In the notation of topological space operators, the matrix elements can be expressed also as

I(a)=ao    B(a)=∂a    E(a)=ae

 

 

 

 

(2)

The dimension of empty sets (∅) are denoted as −1 or F (false). The dimension of non-empty sets (¬∅) are denoted with the maximum number of dimensions of the intersection, specifically 0 for points, 1 for lines, 2 for areas. Then, the domain of the model is {0,1,2,F}.

A simplified version of [math]\displaystyle{ \dim(x) }[/math] values are obtained mapping the values {0,1,2} to T (true), so using the boolean domain {T,F}. The matrix, denoted with operators, can be expressed as

[math]\displaystyle{ \operatorname{bin}(\operatorname{DE9IM}(a,b)) = \operatorname{9IM}(a,b) = \begin{bmatrix} a^o \cap b^o \ne \emptyset & a^o \cap \partial{b} \ne \emptyset & a^o \cap b^e \ne \emptyset \\ \partial{a} \cap b^o\ne\emptyset & \partial{a} \cap \partial{b}\ne\emptyset & \partial{a} \cap b^e\ne\emptyset \\ a^e \cap b^o\ne\emptyset & a^e \cap \partial{b}\ne\emptyset & a^e \cap b^e\ne\emptyset \end{bmatrix} }[/math]

 

 

 

 

(3)

The elements of the matrix can be named as shown below:

[math]\displaystyle{ \begin{bmatrix} II & IB & IE \\ BI & BB & BE \\ EI & EB & EE \end{bmatrix} }[/math]

 

 

 

 

(4)

Both matrix forms, with dimensional and boolean domains, can be serialized as "DE-9IM string codes", which represent them in a single-line string pattern. Since 1999 the string codes have a standard[5] format.

For output checking or pattern analysis, a matrix value (or a string code) can be checked by a "mask": a desired output value with optional asterisk symbols as wildcards — that is, "*" indicating output positions that the designer does not care about (free values or "don't-care positions"). The domain of the mask elements is {0,1,2,F,*}, or {T,F,*} for the boolean form.

The simpler models 4-Intersection and 9-Intersection were proposed before DE-9IM for expressing spatial relations[6] (and originated the terms 4IM and 9IM). They can be used instead of the DE-9IM to optimize computation when input conditions satisfy specific constraints.

Illustration

Visually, for two overlapping polygonal geometries, the result of the function DE_9IM(a,b) looks like:[7]

b   DE9IM b.svg
a
DE9IM a.svg
Interior Boundary Exterior
Interior DE9IM II.svg

  [math]\displaystyle{ \dim[I(a){\color{red}\cap}I(b)] = 2 }[/math]  

DE9IM IB.svg

  [math]\displaystyle{ \dim[I(a){\color{red}\cap}B(b)] = 1 }[/math]  

DE9IM IE.svg

  [math]\displaystyle{ \dim[I(a){\color{red}\cap}E(b)] = 2 }[/math]  

Boundary
DE9IM BI.svg

  [math]\displaystyle{ \dim[B(a){\color{red}\cap}I(b)] = 1 }[/math]  

DE9IM BB.svg

  [math]\displaystyle{ \dim[B(a){\color{red}\cap}B(b)] = 0 }[/math]  

DE9IM BE.svg

  [math]\displaystyle{ \dim[B(a){\color{red}\cap}E(b)] = 1 }[/math]  

Exterior
DE9IM EI.svg

  [math]\displaystyle{ \dim[E(a){\color{red}\cap}I(b)] = 2 }[/math]  

DE9IM EB.svg

  [math]\displaystyle{ \dim[E(a){\color{red}\cap}B(b)] = 1 }[/math]  

DE9IM EE.svg

  [math]\displaystyle{ \dim[E(a){\color{red}\cap}E(b)] = 2 }[/math]  

This matrix can be serialized. Reading from left-to-right and top-to-bottom, the result is [math]\displaystyle{ II=2,\,IB=1,\,IE=2,\,BI=1,\,BB=0,\,BE=1,\,EI=2,\,EB=1,\,EE=2 }[/math].  So, in a compact representation as string code is '212101212'.

Spatial predicates

Any topological property based on a DE-9IM binary spatial relation is a spatial predicate. For ease of use "named spatial predicates" have been defined for some common relations, which later became standard predicates. The spatial predicate functions that can be derived from DE-9IM include:[4] [8]

Predicates defined with masks of domain {T,F,*}:
Name (synonym) Intersection matrix and mask code string
(boolean OR between matrices)
Meaning and definition[4] Equivalent
Equals [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{F}\\ \mathrm{F}&\mathrm{F}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math]

II ∧ ~IE ∧ ~BE ∧ ~EI ∧ ~EB

 

 

 

 

(5)

a and b are topologically equal. "Two geometries are topologically equal if their interiors intersect and no part of the interior or boundary of one geometry intersects the exterior of the other".[9]
Within & Contains
T*F**FFF*
Disjoint [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{F}&\mathrm{F}&\mathrm{*}\\ \mathrm{F}&\mathrm{F}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math]

~II ∧ ~IB ∧ ~BI ∧ ~BB

 

 

 

 

(6)

a and b are disjoint: they have no point in common. They form a set of disconnected geometries.
not Intersects
FF*FF****
Touches
(meets)
[math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{F}&\mathrm{T}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{F}&\mathrm{*}&\mathrm{*}\\ \mathrm{T}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{F}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{T}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math]

~II ∧ (IBBIBB)

 

 

 

 

(7)

a touches b: they have at least one point in common, but their interiors do not intersect.
FT******* F**T***** F***T****
Contains [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{F}&\mathrm{F}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math]

II ∧ ~EI ∧ ~EB

 

 

 

 

(8)

a contains b: geometry b lies in a, and the interiors intersect. Another definition: "a contains b iff no points of b lie in the exterior of a, and at least one point of the interior of b lies in the interior of a".[10]
Within(b,a)
T*****FF*
Covers [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{F}&\mathrm{F}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{T}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{F}&\mathrm{F}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{T}&\mathrm{*}&\mathrm{*}\\ \mathrm{F}&\mathrm{F}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{T}&\mathrm{*}\\ \mathrm{F}&\mathrm{F}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math]

(IIIBBIBB) ∧ ~EI ∧ ~EB

 

 

 

 

(9)

a covers b: geometry b lies in a. Other definitions: "At least one point of b lies in a, and no point of b lies in the exterior of a", or "Every point of b is a point of (the interior or boundary of) a".
CoveredBy(b,a)
T*****FF* *T****FF* ***T**FF* ****T*FF*
Predicates that can be obtained from the above by logical negation or parameter inversion (matrix transposition), as indicated by the last column:
Intersects [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{T}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{T}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{T}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] a intersects b: geometries a and b have at least one point in common. not Disjoint
T******** *T******* ***T***** ****T****
Within
(inside)
[math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] a is within b: a lies in the interior of b. Contains(b,a)
T*F**F***
CoveredBy [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{T}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{*}&\mathrm{F}\\ \mathrm{T}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{*}&\mathrm{*}&\mathrm{F}\\ \mathrm{*}&\mathrm{T}&\mathrm{F}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] a is covered by b (extends Within): geometry a lies in b. Other definitions: "At least one point of a lies in b, and no point of a lies in the exterior of b", or "Every point of a is a point of (the interior or boundary of) b". Covers(b,a)
T*F**F*** *TF**F*** **FT*F*** **F*TF***
Predicates that utilize the input dimensions, and are defined with masks of domain {0,1,T,*}:
Crosses
[math]\displaystyle{ \dim(a)\ne\dim(b) }[/math] or
dim(any) = 1
[math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{T}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{T}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{0}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{*}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] a crosses b: they have some but not all interior points in common, and the dimension of the intersection is less than that of at least one of them. The following mask selection rules must only be checked when [math]\displaystyle{ \dim(a)\ne\dim(b) }[/math] (except for line / line inputs, which are allowed), otherwise the predicate is false:[11]

(II=0) for lines,   (IIIE) when [math]\displaystyle{ \dim(a)\lt \dim(b) }[/math],   (IIEI) when [math]\displaystyle{ \dim(a)\gt \dim(b) }[/math]

 

 

 

 

(10)

T*T******
[math]\displaystyle{ \dim(a)\lt \dim(b) }[/math]
T*****T**
[math]\displaystyle{ \dim(a)\gt \dim(b) }[/math]
0********
dim(any) = 1
Overlaps
[math]\displaystyle{ \dim(a)=\dim(b) }[/math]
[math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{T}&\mathrm{*}&\mathrm{T}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{T}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] [math]\displaystyle{ \Bigl[\begin{smallmatrix} \mathrm{1}&\mathrm{*}&\mathrm{T}\\ \mathrm{*}&\mathrm{*}&\mathrm{*}\\ \mathrm{T}&\mathrm{*}&\mathrm{*} \end{smallmatrix}\Bigr] }[/math] a overlaps b: they have some but not all points in common, they have the same dimension, and the intersection of the interiors of the two geometries has the same dimension as the geometries themselves. The following mask selection rules must only be checked when [math]\displaystyle{ \dim(a)=\dim(b) }[/math], otherwise the predicate is false:

(IIIEEI) for points or surfaces,   (II=1 ∧ IEEI) for lines

 

 

 

 

(11)

T*T***T**
dim = 0 or 2
1*T***T**
dim = 1

Notice that:

  • The topologically equal definition does not imply that they have the same points or even that they are of the same class.
  • The output of [math]\displaystyle{ \operatorname{DE-9IM}(a,b) }[/math] have the information contained in a list of all interpretable predicates about geometries a and b.
  • All predicates are computed by masks. Only Crosses and Overlaps have additional conditions about [math]\displaystyle{ \dim(a) }[/math] and [math]\displaystyle{ \dim(b) }[/math].
  • All mask string codes end with *. This is because EE is trivially true, and thus provides no useful information.
  • The Equals mask, T*F**FFF*, is the "merge" of Contains (T*****FF*) and Within (T*F**F***): (II ∧ ~EI ∧ ~EB) ∧ (II ∧ ~IE ∧ ~BE).
  • The mask T*****FF* occurs in the definition of both Contains and Covers. Covers is a more inclusive relation. In particular, unlike Contains it does not distinguish between points in the boundary and in the interior of geometries. For most situations, Covers should be used in preference to Contains.
  • Similarly, the mask T*F**F*** occurs in the definition of both Within and CoveredBy. For most situations, CoveredBy should be used in preference to Within.
  • Historically, other terms and other formal approaches have been used to express spatial predicates; for example region connection calculus was introduced in 1992 by[12] Randell, Cohn and Cohn.

Properties

The spatial predicates have the following properties of binary relations:

Interpretation

Examples of spatial relations.

The choice of terminology and semantics for the spatial predicates is based on reasonable conventions and the tradition of topological studies.[4] Relationships such as Intersects, Disjoint, Touches, Within, Equals (between two geometries a and b) have an obvious semantic:[10][13]

Equals
a = b that is (ab = a) ∧ (ab = b)
Within
ab = a
Intersects
ab ≠ ∅
Touches
(ab ≠ ∅) ∧ (aοbο = ∅)

The predicates Contains and Within have subtle aspects to their definition which are contrary to intuition. For example,[10] a line L which is completely contained in the boundary of a polygon P is not considered to be contained in P. This quirk can be expressed as "Polygons do not contain their boundary". This issue is caused by the final clause of the Contains definition above: "at least one point of the interior of B lies in the interior of A". For this case, the predicate Covers has more intuitive semantics (see definition), avoiding boundary considerations.

For better understanding, the dimensionality of inputs can be used as justification for a gradual introduction of semantic complexity:

Relations between Appropriate predicates Semantic added
point/point Equals, Disjoint Other valid predicates collapses into Equals.
point/line adds Intersects Intersects is a refinement of Equals: "some equal point at the line".
line/line adds Touches, Crosses, ... Touches is a refinement of Intersects, about "boundaries" only. Crosses is about "only one point".

Coverage on possible matrix results

The number of possible results in a boolean 9IM matrix is 29=512, and in a DE-9IM matrix is 39=6561. The percentage of these results that satisfy a specific predicate is determined as following,

ProbabilityName
93.7%Intersects
43.8%Touches
25%Crosses (for valid inputs, 0% otherwise)
23.4%Covers and CoveredBy
12.5%Contains, Overlaps (for valid inputs, 0% otherwise) and Within
6.3%Disjoint
3.1%Equals

On usual applications the geometries intersects a priori, and the other relations are checked.

The composite predicates "Intersects OR Disjoint" and "Equals OR Different" have the sum 100% (always true predicates), but "Covers OR CoveredBy" have 41%, that is not the sum, because they are neither logical complements or independent relations; similarly "Contains OR Within", have 21%. The sum 25 % + 12.5 % = 37.5 % is obtained when ignoring overlapping lines in "Crosses OR Overlaps", because the valid input sets are disjoint.

Queries and assertions

The DE-9IM offers a full descriptive assertion about the two input geometries. It is a mathematical function that represents a complete set of all possible relations about two entities, like a Truth table, the Three-way comparison, a Karnaugh map or a Venn diagram. Each output value is like a truth table line, that represent relations of specific inputs.

As illustrated above, the output '212101212' resulted from DE-9IM(a,b) is a complete description of all topologic relations between specific geometries a and b. It says to us that [math]\displaystyle{ II=2,\,IB=1,\,IE=2,\,BI=1,\,BB=0,\,BE=1,\,EI=2,\,EB=1,\,EE=2 }[/math].

By other hand, if we check predicates like Intersects(a,b) or Touches(a,b) — for the same example we have "Intersects=true and Touches=true" — it is an incomplete description of "all topologic relations". Predicates also do not say any thing about the dimensionality of the geometries (it doesn't matter if a and b are lines, areas or points).

This independence of geometry-type and the lack of completeness, on predicates, are useful for general queries about two geometries:

interior/boundary/exterior semantic usual semantic
Assertions more descriptive
" a and b have DE-9IM(a,b)='212101212' "
less descriptive
" a Touches b "
Queries more restrictive
" Show all pair of geometries where DE-9IM(a,b)='212101212' "
more general
" Show all pair of geometries where Touches(a,b) "

For usual applications, the use of spatial predicates also is justified by being more human-readable than DE-9IM descriptions: a typical user have better intuition about predicates (than a set of interiors/border/exterior intersections).

Predicates have useful semantic into usual applications, so it is useful the translation of a DE-9IM description into a list of all associated predicates,[14][15] that is like a casting process between the two different semantic types. Examples:

  • The string codes "0F1F00102" and "0F1FF0102" have the semantic of "Intersects & Crosses & Overlaps".
  • The string code "1FFF0FFF2" have the semantic of "Equals".
  • The string codes "F01FF0102", "FF10F0102", "FF1F00102", "F01FFF102", and "FF1F0F1F2" have the semantic of "Intersects & Touches".

Standards

The Open Geospatial Consortium (OGC) has standardized the typical spatial predicates (Contains, Crosses, Intersects, Touches, etc.) as boolean functions, and the DE-9IM model,[16] as a function that returns a string (the DE-9IM code), with domain of {0,1,2,F}, meaning 0=point, 1=line, 2=area, and F="empty set". This DE-9IM string code is a standardized format for data interchange.

The Simple Feature Access (ISO 19125) standard,[17] in the chapter 7.2.8, "SQL routines on type Geometry", recommends as supported routines the SQL/MM Spatial[18] (ISO 13249-3 Part 3: Spatial) ST_Dimension, ST_GeometryType, ST_IsEmpty, ST_IsSimple, ST_Boundary for all Geometry Types. The same standard, consistent with the definitions of relations in "Part 1, Clause 6.1.2.3" of the SQL/MM, recommends (shall be supported) the function labels: ST_Equals, ST_Disjoint, ST_Intersects, ST_Touches, ST_Crosses, ST_Within, ST_Contains, ST_Overlaps and ST_Relate.

The DE-9IM in the OGC standards use the following definitions of Interior and Boundary, for the main OGC standard geometry types:[19]

Subtypes Dim Interior (I) boundary (B)
Point, MultiPoint 0 Point, Points Empty
LineString, Line 1 Points that are left when the boundary points are removed. Two end points.
LinearRing 1 All points along the geometry. Empty.
MultilineString 1 Points that are left when the boundary points are removed. Those points that are in the boundaries of an odd number of its elements (curves).
Polygon 2 Points within the rings. Set of rings.
MultiPolygon 2 Points within the rings. Set of rings of its elements (polygons).
NOTICE: exterior points (E) are points p not in the interior or boundary, so not need extra interpretation, E(p)=not(I(p) or B(p)).

Implementation and practical use

Most spatial databases, such as PostGIS, implements the DE-9IM() model by the standard functions:[20] ST_Relate, ST_Equals, ST_Intersects, etc. The function ST_Relate(a,b) outputs the standard OGC's DE-9IM string code.

Examples: two geometries, a and b, that intersects and touches with a point (for instance with [math]\displaystyle{ \dim(B(a)\cap I(b))=0 }[/math] and [math]\displaystyle{ \dim(I(a)\cap I(b))=F }[/math]), can be ST_Relate(a,b)='FF1F0F1F2' or ST_Relate(a,b)='FF10F0102' or ST_Relate(a,b)='FF1F0F1F2'. It also satisfies ST_Intersects(a,b)=true and ST_Touches(a,b)=true. When ST_Relate(a,b)='0FFFFF212', the returned DE-9IM code have the semantic of "Intersects(a,b) & Crosses(a,b) & Within(a,b) & CoveredBy(a,b)", that is, returns true on the boolean expression ST_Intersects(a,b) AND ST_Crosses(a,b) AND ST_Within(a,b) AND ST_Coveredby(a,b).

The use of ST_Relate() is faster than direct computing of a set of correspondent predicates.[7] There are cases where using ST_Relate() is the only way to compute a complex predicate — see the example of the code 0FFFFF0F2,[21] of a point that not "crosses" a multipoint (a object that is a set of points), but predicate Crosses (when defined by a mask) returns true.

It is usual to overload the ST_Relate() by adding a mask parameter, or use a returned ST_Relate(a,b) string into the ST_RelateMatch() function.[22] When using ST_Relate(a,b,mask), it returns a boolean. Examples:

  • ST_Relate(a,b,'*FF*FF212') returns true when ST_Relate(a,b) is 0FFFFF212 or 01FFFF212, and returns false when 01FFFF122 or 0FF1FFFFF.
  • ST_RelateMatch('0FFFFF212','*FF*FF212') and ST_RelateMatch('01FFFF212','TTF*FF212') are true, ST_RelateMatch('01FFFF122','*FF*FF212') is false.

Synonyms

  • "Egenhofer-Matrix" is a synonym for the 9IM 3x3 matrix of boolean domain.[23]
  • "Clementini-Matrix" is a synonym for the DE-9IM 3x3 matrix of {0,1,2,F} domain.[23]
  • "Egenhofer operators" and "Clementini operators" are sometimes a reference to matrix elements as II, IE, etc. that can be used in boolean operations. Example: the predicate "G1 contains G2" can be expressed by "G1| II ∧ ~EI ∧ ~EB |G1", that can be translated to mask syntax, T*****FF*.
  • Predicates "meets" is a synonym for touches; "inside" is a synonym for within
  • Oracle's[15] "ANYINTERACT" is a synonym for intersects and "OVERLAPBDYINTERSECT" is a synonym for overlaps. Its "OVERLAPBDYDISJOINT" does not have a corresponding named predicate.
  • In Region connection calculus operators offer some synonyms for predicates: disjoint is DC (disconnected), touches is EC (externally connected), equals is EQ. Other, like Overlaps as PO (partially overlapping), need context analysis or composition.[24][25]

See also

Standards:       Software:       Related topics:

References

  1. Clementini, Eliseo; Di Felice, Paolino; van Oosterom, Peter (1993). "A small set of formal topological relationships suitable for end-user interaction". in Abel, David; Ooi, Beng Chin. Advances in Spatial Databases: Third International Symposium, SSD '93 Singapore, June 23–25, 1993 Proceedings. Lecture Notes in Computer Science. 692/1993. Springer. pp. 277–295. doi:10.1007/3-540-56869-7_16. ISBN 978-3-540-56869-8. http://resolver.tudelft.nl/uuid:a2db9ae8-f768-4bff-ada3-966a6c8e9db6. 
  2. Clementini, Eliseo; Sharma, Jayant; Egenhofer, Max J. (1994). "Modelling topological spatial relations: Strategies for query processing". Computers & Graphics 18 (6): 815–822. doi:10.1016/0097-8493(94)90007-8. 
  3. Egenhofer, M.J.; Franzosa, R.D. (1991). "Point-set topological spatial relations". Int. J. GIS 5 (2): 161–174. doi:10.1080/02693799108927841. 
  4. 4.0 4.1 4.2 4.3 Egenhofer, M.J.; Herring, J.R. (1990). "A Mathematical Framework for the Definition of Topological Relationships". http://www.spatial.maine.edu/~max/MJEJRH-SDH1990.pdf. 
  5. The "OpenGIS Simple Features Specification For SQL", Revision 1.1, was released at May 5, 1999. It was the first international standard to establish the format conventions for DE-9IM string codes, and the names of the "Named Spatial Relationship predicates based on the DE-9IM" (see section with this title).
  6. M. J. Egenhofer, J. Sharma, and D. Mark (1993) "A Critical Comparison of the 4-Intersection and 9-Intersection Models for Spatial Relations: Formal Analysis ", In: Auto-Carto XI .
  7. 7.0 7.1 Chapter 4. Using PostGIS: Data Management and Queries
  8. JTS: Class IntersectionMatrix, Vivid Solutions, Inc., http://www.vividsolutions.com/jts/javadoc/com/vividsolutions/jts/geom/IntersectionMatrix.html 
  9. JTS Technical Specifications of 2003.
  10. 10.0 10.1 10.2 M. Davis (2007), "Quirks of the 'Contains' Spatial Predicate".
  11. ST_Crosses
  12. Randell, D.A.; Cui, Z; Cohn, A.G. (1992). "A spatial logic based on regions and connection". Morgan Kaufmann. pp. 165–176. 
  13. Câmara, G.; Freitas, U. M.; Casanova, M. A. (1995). Fields and Objects Algebras for GIS Operations. 
  14. A DE-9IM translator, of all associated predicates of a spatial relation.
  15. 15.0 15.1 Note. The Oracle's spatial funcion SDO_RELATE() do only a partial translation, internally, offering to user a mask for a or-list of predicates to be checked, instead the DE-9IM string.
  16. "OpenGIS Implementation Specification for Geographic information - Simple feature access - Part 2: SQL option", OGC, http://www.opengeospatial.org/standards/sfs
  17. Open Geospatial Consortium Inc. (2007), "OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 2: SQL option", OGC document 06-104r4 version 1.2.1 (review of 2010-08-04).
  18. ISO 13249-3 Part 3: Spatial, summarized in SQL Multimedia and Application Packages (SQL/MM) .
  19. "Encyclopedia of GIS", edited by Shashi Shekhar and Hui Xiong. SpringerScience 2008. pg. 242
  20. ST_Relate() PostGIS function online documentation.
  21. JTS test case of "point A within one of B points", http://www.vividsolutions.com/jts/tests/Run1Case4.html
  22. ST_RelateMatch() PostGIS function online documentation.
  23. 23.0 23.1 "Encyclopedia of GIS", S. Shekhar, H. Xiong. ISBN:978-0-387-35975-5.
  24. "Multidimensional Region Connection Calculus" (2017), http://qrg.northwestern.edu/qr2017/papers/QR2017_paper_8.pdf
  25. Sabharwal, Chaman L.; Leopold, Jennifer L. (2013). "Identification of Relations in Region Connection Calculus: 9-Intersection Reduced to 3 + -Intersection Predicates". Advances in Soft Computing and Its Applications. Lecture Notes in Computer Science. 8266. pp. 362–375. doi:10.1007/978-3-642-45111-9_32. ISBN 978-3-642-45110-2. 

External links