How to correct Polygon Ring Orientation using C# Entity Framework 5 DbGeography Spatial Data

Question

I'm working with the new Entity-Framework 5 using the Spatial data type DbGeography as part of my model for storing in one instance, a POINT and in another instance a POLYGON.

When setting the value of my POLYGON all saves with no error however this is only the case if I draw the Polygon on the map in a clockwise order. If I draw the POLGON in an anti-clockwise direction I get an error the the sql level indicating that the data is an invalid geography type.

Now after doing my own research into the problem, it appears to stem from the geography data type being quite strict in terms of a Polygons ring orientation. The most common solution appears to be creating the Polygon as a geometry and then converting it to a geography type.

I am looking for a solution in C# that can be applied to the data before it gets sent to sql. Basically something that will auto correct the ring orientation of an array of coordinates.

I have tried catching the error and then rebuilding the string by reversing the array. This works in some cases but firstly it's not reliable and secondly catching the error is to big a performance hit.

Thanks Chris

Answer 1

Hi I had the same problem and solved it by using

var sqlGeography = SqlGeography.STGeomFromText().MakeValid()
var invertedSqlGeography = sqlGeography.ReorientObject();

For more details see here

Answer 2

I've had the order issue my self, and I solved it using the MakeValidGeographyFromText function from SQLSpatialTools I used it the following way inside a SP:

SET @ge = dbo.MakeValidGeographyFromText(
    'POLYGON((' + @pois + '))', 4326);

Where @pois is a string containing the coordinates in a valid format, but wrong rotation.

I'm not sure how easy this is to integrate with EF-5, but I see two ways:

1. Use the function directly from C#, before calling EF with the correct polygon.
2. Install sqlspatialtools on the SQL server, and do the processing there.