SQL 2012 - How can I convert MultiLineString to Geography?

Question

I have a Geometry LineString that I wish to convert to Geography. Since the Geometry isn't valid , When I use MakeValid on it, SQL convert it to MultiLineString and than the Geography creation is failing with error : The specified input does not represent a valid geography instance. Use MakeValid to convert the instance to a valid instance. Note that MakeValid may cause the points of a spatial instance to shift slightly. What can I do in order to convert the Geometry to Geography ? Geometry text : http://pastebin.com/Ly8ex41U Geometry text after MakeValid : http://pastebin.com/HGNFKnS3

Answer 1

I suggest you try one of the following:

a- Use STIsValidReason(YourGeometry) to indenitfy what is causing the invalid error and fix accordingly.

b- Split into Valid LineStrings:

1-Use STSplit(YourGeometry) to create separate valid LineStrings.

2-Apply MakeValid to each valid LineString, and convert to Geography instances.

3-use STUnion() to merge the individual Geography instances.