I am new on gis and How can i do break line and convert it into multiline? I have converted geometry to multiline by this code:
st_astext(st_multi(st_linemerge(st_union(j.shape)))) as multiLine
but there is just one line as a
MULTILINESTRING.it is like
MULTILINESTRING((xx yy , aa rr)).How can i do break for example by distance between two points and creation date time for breaking line?
Is it possible?