Split a linestring by distance every x meters using PostGIS

Question

I'm looking to split a linestring every x meters. I don't know which way to start, and I'm going in circles! I can find a point at 20 % from the start with ST_LineInterpolatePoint, but not at 20 m. The idea is to determine the set of points at 20, 40, 60 m and use ST_LineSubstring then. Does that seem correct to you?

My answer here has a function implementation that does exactly what you need. — geozelot, Dec 30 '19 at 14:11
Also you can have a look at https://postgis.net/docs/ST_Segmentize.html You can split the input each 20m — milad, Jan 02 '20 at 18:44
See the solution using ST_LineSubstring in this answer: https://gis.stackexchange.com/a/334305/14766 — dr_jts, Aug 21 '21 at 23:21

Sreejith V · Answer 1 · 2022-03-01T07:14:13.933

This can be achieved using PostGIS query itself. Use ST_LineSubstring and generate_series.

Please use below query:

WITH data(id, geom) AS (VALUES
    ( 'A', 'LINESTRING( 0 0, 200 0)'::geometry ),
    ( 'B', 'LINESTRING( 0 100, 350 100)'::geometry ),
    ( 'C', 'LINESTRING( 0 200, 50 200)'::geometry )
)SELECT id, i,
   ST_AsText( ST_LineSubstring( geom, startfrac, LEAST( endfrac, 1 )) ) AS geom FROM (
SELECT id, geom, ST_Length(geom) len, 100 sublen FROM data
) AS d CROSS JOIN LATERAL (
SELECT i, (sublen * i) / len AS startfrac,
          (sublen * (i+1)) / len AS endfrac
FROM generate_series(0, floor( len / sublen )::integer ) AS t(i)
-- skip last i if line length is exact multiple of sublen
WHERE (sublen * i) / len <> 1.0
) AS d2;

Ref: http://postgis.net/docs/ST_LineSubstring.html

Split a linestring by distance every x meters using PostGIS

1 Answers1