1
2
3
4
5
6
7
|
ST_Locate_Along_Measure - Alternate name
:memory: #use in-memory database
SELECT AsText(ST_LocateAlong(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.1, 6 1 106 2.1)'), 2.1));
1 # rows (not including the header row)
1 # columns
AsText(ST_LocateAlong(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.1, 6 1 106 2.1)'), 2.1))
GEOMETRYCOLLECTION ZM(POINT ZM(0 1 100 2.1), POINT ZM(2 1 102 2.1), LINESTRING ZM(5 0 105 2.1, 6 1 106 2.1))
|
