I have a polygon geometry in SqlServer and i want to split that single polygon into two features via a line that i draw through it. How can i do that with sql? I don't want to lose ANY portion of the original polygon. So buffering the line and doing a difference is not going to get it done. Unless there is a way i can "put back" the lost edges from the diff.
SqlGeometry splitLineGeom = SqlGeometry.STGeomFromText(new SqlChars(splitLineWKT.ToCharArray()), Srid); // buffer line and get the difference from the input SqlGeometry bufferedSplitLine = splitLineGeom.STBuffer(0.001); SqlGeometry resultGeom = inputGeom.STDifference(bufferedSplitLine);