geometry STIntersection returns the shared shape rather than only an intersection flag. I inspect its type and emptiness alongside its area. A shared edge has zero area but still contains points.
geometry STEquals: Equal Shapes Can Have Different Text
geometry STEquals compares the represented point set, which can stay the same when its text representation changes. I separate that question from byte-for-byte text identity. Reversing a line does not necessarily change the places it occupies.
SQL SERVER – Spatial Database Definition and Research Documents
What is a spatial database? It is about lines, points, polygons and their features, and SQL Server was not one. My simple answer plus research documents.



