Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

SqlGeography.IsValidDetailed Method

Returns a message to help identify validity issues with a spatial object.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public string IsValidDetailed()

Return Value

Type: String
A message indicating whether the spatial object is valid or not valid, and if not valid, why not.

If data is not valid for multiple reasons, only one will be returned. Each message will have a unique ID, so the process of detecting validity and fixing it can be automated. An object can be automatically validated by calling the MakeValid method.

Indexing values for sub-objects will start counting each curve from 1. The invalid curve could be accessed with the STCurveN(Int32) method with the given value. The same is true for STRingN, passed index for rings matched value used for STRingN to get the same ring.

Community Additions

Show:
© 2015 Microsoft