1
2
3
4
5
6
7
|
ST_Locate_Between_Measures - LinestringZM
:memory: #use in-memory database
SELECT AsText(ST_Locate_Between_Measures(GeomFromText('LINESTRINGZM(0 1 100 2.1, 1 0 101 1, 2 1 102 2.1, 3 0 103 2.2, 4 1 104 4, 5 0 105 2.5)'), 2, 3));
1 # rows (not including the header row)
1 # columns
AsText(ST_Locate_Between_Measures(GeomFromText('LINESTRINGZM(0 1 100 2.1, 1 0 101 1, 2 1 102 2.1, 3 0 103 2.2, 4 1 104 4, 5 0 105 2.5)'), 2, 3))
GEOMETRYCOLLECTION ZM(POINT ZM(0 1 100 2.1), POINT ZM(5 0 105 2.5), LINESTRING ZM(2 1 102 2.1, 3 0 103 2.2))
|
