Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ST_AsText(ST_MakeLine(start_point,end_point)) as geom FROM
- (
- SELECT
- ST_Pointn(geom, generate_series(1, ST_NumPoints(geom)-1)) as start_point,
- ST_Pointn(geom, generate_series(2, ST_NumPoints(geom))) as end_point
- FROM (
- SELECT ST_Segmentize(ST_GeomFromText('LINESTRING(0 0,0 50)'),5) as geom
- ) as line
- ) as tmp;
- SELECT ST_AsText(ST_MakeLine(start_point,end_point)) as geom FROM
- (
- SELECT
- ST_Pointn(geom, generate_series(1, ST_NumPoints(geom)-1)) as start_point,
- ST_Pointn(geom, generate_series(2, ST_NumPoints(geom))) as end_point
- FROM (
- SELECT ST_Segmentize(ST_GeomFromText(
- 'LINESTRING(8.53011977325458 47.4525557235204,8.53683231588295 47.4527692267847)'
- ),5) as geom
- ) as line
- ) as tmp;
Add Comment
Please, Sign In to add comment