I have two datasets of linestring features, both of which are from the same source and nearly identical but with minor changes. One of the changes that I need to identify is when one line feature is split into multiple separate features, but with otherwise identical geometry.
So the original line, we'll call it B, is defined as the following sequence of points:
[V, W, X, Y, Z]
Line A is defined as:
[V, W, X]
How can I write a SQL query that will return True if line A is a subset of B ? I thought the ST_Covers function would work since every point in A is in B, in the same order, but the function seems to only work with polygons and has strange behavior around edges