1
2
3
4
5
6
7
|
interpolate equidistant points - basic line
:memory: #use in-memory database
SELECT AsText(Line_Interpolate_Equidistant_Points(GeomFromText('LINESTRING(0 0, 10 6)'), 0.5))
1 # rows (not including the header row)
1 # columns
AsText(Line_Interpolate_Equidistant_Points(GeomFromText('LINESTRING(0 0, 10 6)'), 0.5))
MULTIPOINT M(0.428746 0.257248 0.5, 0.857493 0.514496 1, 1.286239 0.771744 1.5, 1.714986 1.028992 2, 2.143732 1.286239 2.5, 2.572479 1.543487 3, 3.001225 1.800735 3.5, 3.429972 2.057983 4, 3.858718 2.315231 4.5, 4.287465 2.572479 5, 4.716211 2.829727 5.5, 5.144958 3.086975 6, 5.573704 3.344222 6.5, 6.00245 3.60147 7, 6.431197 3.858718 7.5, 6.859943 4.115966 8, 7.28869 4.373214 8.5, 7.717436 4.630462 9, 8.146183 4.88771 9.5, 8.574929 5.144958 10, 9.003676 5.402205 10.5, 9.432422 5.659453 11, 9.861169 5.916701 11.5)
|
