ReorientObject (geography Data Type)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

Returns a geography instance with interchanged interior regions and exterior regions.

This geography data type method supports FullGlobe instances or spatial instances that are larger than a hemisphere.


.ReorientObject (geography)  


To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.


Is another geography instance on which ReorientObject() is invoked.

Return Value

SQL Server return type: geography

CLR return type: SqlGeography


This method changes the ring orientation of all Polygons in a GeometryCollection but doesn't remove or change any Points or LineStrings in the given collection.

If you pass a GeometryCollection to this method, each instance in the collection reorients as a result, but the whole collection doesn't reorient.


DECLARE @R GEOGRAPHY = GEOGRAPHY::Parse('Polygon((-10 -10, -10 10, 10 10, 10 -10, -10 -10))');  
SELECT @R.ReorientObject().STAsText();  
--Result: POLYGON ((10 10, -10 10, -10 -10, 10 -10, 10 10))  

See Also

Extended Methods on Geography Instances