Changes between Version 4 and Version 5 of UsersWikiLinearRefFunctions
- Timestamp:
- Aug 5, 2020, 2:41:18 PM (4 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiLinearRefFunctions
v4 v5 50 50 loc AS ( 51 51 SELECT id, line, index, geom AS pt 52 FROM data 53 JOIN LATERAL ST_LineLocateSegment( data.line, 'POINT(15 15.1)'::geometry ) AS lls ON true 52 FROM data CROSS JOIN ST_LineLocateSegment( data.line, 'POINT(15 15.1)'::geometry ) 54 53 ) 55 SELECT id, ST_AsText( ST_AddPoint( line, pt, index ) ) 56 FROM loc; 54 SELECT id, ST_AsText( ST_AddPoint( line, pt, index ) ) FROM loc; 57 55 }}} 58 56