Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Returns a message that can help to identify problems with a spatial object that is not valid. When the object is not valid, only the first error is returned. When the object is valid, a value of 24400 is returned.
Syntax
.IsValidDetailed()
Return Types
SQL Server return type: nvarchar(max)
CLR return type: string
Remarks
The following table contains possible return values:
Return value |
Description |
|---|---|
24400 |
Valid |
24401 |
Not valid, reason unknown. |
24402 |
Not valid because point {0} is an isolated point, which is not valid in this type of object. |
24403 |
Not valid because some pair of polygon edges overlap. |
24404 |
Not valid because polygon ring {0} intersects itself or some other ring. |
24405 |
Not valid because some polygon ring intersects itself or some other ring. |
24406 |
Not valid because curve {0} degenerates to a point. |
24407 |
Not valid because polygon ring {0} collapses to a line at point {1}. |
24408 |
Not valid because polygon ring {0} is not closed. |
24409 |
Not valid because some portion of polygon ring {0} lies in the interior of a polygon. |
24410 |
Not valid because ring {0} is the first ring in a polygon of which it is not the exterior ring. |
24411 |
Not valid because ring {0} lies outside the exterior ring {1} of its polygon. |
24412 |
Not valid because the interior of a polygon with rings {0} and {1} is not connected. |
24413 |
Not valid because of two overlapping edges in curve {0}. |
24414 |
Not valid because an edge of curve {0} overlaps an edge of curve {1}. |
24415 |
Not valid some polygon has an invalid ring structure. |
24416 |
Not valid because in curve {0} the edge that starts at point {1} is either a line or a degenerate arc with antipodal endpoints. |
Examples
The following example of an invalid spatial object illustrates how the IsValidDetailed() methods behaves.
DECLARE @p GEOMETRY = 'Polygon((2 2, 4 4, 4 2, 2 4, 2 2))'
SELECT @p.IsValidDetailed()
--Returns: 24404: Not valid because polygon ring (1) intersects itself or some other ring.