【SQLServer】SQLServer空间字段图形重复检查

函数 STContains

作用: 是否有包含的空间关系

DECLARE @g geometry;  
DECLARE @h geometry;  
SET @g = geometry::STGeomFromText('POLYGON ((105.28647000000007 28.164760000000058,105.28647000000007 32.20336000000003,110.19387000000006 32.20336000000003,110.19387000000006 28.164760000000058,105.28647000000007 28.164760000000058))', 4326)
SET @h =  (select shape from table1 where gb like '500110')
SELECT @g.STContains(@h); 

注意:这个函数被包含的图形应该作为STContains的参数来使用

函数 STOverlaps

作用: 是否有相交的空间关系

DECLARE @g geometry;  
DECLARE @h geometry;  
SET @g = geometry::STGeomFromText('POLYGON ((105.28647000000007 28.164760000000058,105.28647000000007 32.20336000000003,110.19387000000006 32.20336000000003,110.19387000000006 28.164760000000058,105.28647000000007 28.164760000000058))', 4326)
SET @h =  (select shape from table1 where gb like '500110')
SELECT @g.STOverlaps(@h);