Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft