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.
Syntax
.ReorientObject (geography)
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
geography
Is another geography instance on which ReorientObject()
is invoked.
Return Value
SQL Server return type: geography
CLR return type: SqlGeography
Remarks
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.
Examples
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for