I am new to PostGIS.
I have a set of (thousands) of Linestrings and associated multiple points along the line, expressed as fractions along each linestring using ST_LineLocatePoint. I am looking for a wrapper of sorts to take in a Linestring and a list of fractions, and return the geometry collection of all of the created Substrings.
Example input:
LINESTRING=example_line, FRACTIONS=(0.25,0.835,0.9)
Example Output:
GEOMETRYCOLLECTION(
ST_Line_Substring(example_line, 0, 0.25),
ST_Line_Substring(example_line, 0.25, 0.835),
ST_Line_Substring(example_line, 0.835, 0.9),
ST_Line_Substring(example_line, 0.9, 1)
)
Does this kind of thing exist in PostGIS?