VERIFIED SOLUTION i
X

How to use SQL to detect and report invalid geometry in Confirm

UPDATED: March 30, 2017


SQL is required to produce the co ordinates of the geometric errors in Confirm. The following query should detect and report the Invalid geometry

DECLARE @g geometry; 
SET @g = geometry::STGeomFromText('<Place the geometry to be tested here>', 4326);--Self-intersection at or near point 0 0 
select @g.STIsValid(); 
SELECT @g.ToString(); 
SET @g = @g.MakeValid();  
select @g.STIsValid();  -- Rectified geometry
SELECT @g.ToString();  

Environment Details

Product Feature: Mapping, Ad-hoc Reporting
 

Downloads

  • No Downloads