I am using spatialite and it does not contains the method ST_dumppoints and ST_dump. I want to divide several linestring into smaller parts. I also have points that I combined and that resulted in a linestrings. Now I want to divide these linestring into several parts.
I have tried using ST_line_substring and ST_line_locate_point but nothing is working.
Is there a way to divide linestring into smaller segments say 100m in spatialite?
What I have done is:
select ASText(ST_Line_Substring(linearea.geometry,0, ST_Line_Locate_Point(linearea.geometry, Transform(setsrid(pointarea.geometry,4326),3857)))) AS Geometry from LineArea linearea,PointArea pointarea PontArea is Area which I combined to make LineArea using MakeLine(ST_point(long,lat))