This topic has not yet been rated - Rate this topic

ReorientObject (geography Data Type)

SQL Server 2012

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)

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 does not remove or change any Points or Linestrings in the given collection.

If a GeometryCollection is passed to this method, each instance in the collection is reoriented, but the collection as a whole is not reoriented.

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))

Other Resources

Extended Methods on Geography Instances

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD