Changes between Version 4 and Version 5 of UsersWikiLinearRefFunctions


Ignore:
Timestamp:
Aug 5, 2020, 2:41:18 PM (16 months ago)
Author:
mdavis
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiLinearRefFunctions

    v4 v5  
    5050loc AS (
    5151  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 )
    5453)
    55 SELECT id, ST_AsText( ST_AddPoint( line, pt, index ) )
    56   FROM loc;
     54SELECT id, ST_AsText( ST_AddPoint( line, pt, index ) ) FROM loc;
    5755}}}
    5856