I have a Multilinestring layer and I have noticed that in some of my geometries there are unwanted Linestrings. They are composed of two points (start and end) but both are the exact same points. That is wreaking havoc when i try to read this layer from SQLServer.
Example of one geometry:
"MULTILINESTRING((-3.00712325415935 43.3437538570123,-3.00711888681593 43.3437506773148), (-3.00693096810649 43.34361446115,-3.00692660078307 43.3436112814451), (-3.00692660078307 43.3436112814451,-3.00692660078307 43.3436112814451), (-3.00692660078307 43.3436112814451,-3.0068846515836 43.3436419720614), (-3.00692660078307 43.3436112814451,-3.0069222334601 43.34360810174), (-3.00691127288165 43.3436001834041,-3.00690690556026 43.3435970036984))"
Notice third Linestring that has the same start and end points. How could I remove these unwanted Linestrings from my geometries?
One approach could be to remove the linestrings which st_length=0 but I don't know how to build the query. I suppose I need to use st_linemerge first to split the multi geometry into single parts?
I need some expert help on this...