1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
Relationship tests - POINTs identical
:memory: #use in-memory database
SELECT Equals(geom1, geom2), Intersects(geom1, geom2), Disjoint(geom1, geom2), Overlaps(geom1, geom2), Crosses(geom1, geom2), Touches(geom1, geom2), Within(geom1, geom2), Contains(geom1, geom2) FROM (SELECT GeomFromText('POINT(1 2)') as geom1, GeomFromText('POINT(1 2)') as geom2) dummy;
1 # rows (not including the header row)
8 # columns
Equals(geom1, geom2)
Intersects(geom1, geom2)
Disjoint(geom1, geom2)
Overlaps(geom1, geom2)
Crosses(geom1, geom2)
Touches(geom1, geom2)
Within(geom1, geom2)
Contains(geom1, geom2)
1
1
0
0
0
0
1
1
|
