ST_LocateAlong — Returns the point(s) on a geometry that match a measure value.
geometry ST_LocateAlong(
geometry geom_with_measure, float8 measure, float8 offset = 0)
;
Returns the location(s) along a measured geometry that have the given measure values. The result is a Point or MultiPoint. Polygonal inputs are not supported.
If offset
is provided, the result is offset to the left or right of the input line by the specified distance. A positive offset will be to the left, and a negative one to the right.
Use this function only for linear geometries with an M component |
The semantic is specified by the ISO/IEC 13249-3 SQL/MM Spatial standard.
1.1.0 버전부터 예전 명칭인 ST_Locate_Along_Measure로 사용할 수 있습니다.
변경 사항: 2.0.0 미만 버전에서는 ST_Locate_Along_Measure라는 명칭이었습니다. 예전 명칭은 더 지원되지 않고 곧 삭제될 예정이지만, 아직은 사용할 수 있습니다.
This function supports M coordinates.
This method implements the SQL/MM specification. SQL-MM IEC 13249-3: 5.1.13
SELECT ST_AsText( ST_LocateAlong( 'MULTILINESTRINGM((1 2 3, 3 4 2, 9 4 3),(1 2 3, 5 4 5))'::geometry, 3 )); ---------------------------------- MULTIPOINT M ((1 2 3),(9 4 3),(1 2 3))