查询一条线某个距离的缓冲区范围内的所有管。。
DECLARE @g3 geometry SET @g3 = geometry::STGeomFromText('LINESTRING(x1 y1,x2 y2)',4326); select * from LightWeightPipe.dbo.xxxx_xxx_xx_xxx_EVW a where @g3.STBuffer(0.000001).STIntersects(a.Shape)=1
查询一条线某个距离的缓冲区范围内的所有管。。
DECLARE @g3 geometry SET @g3 = geometry::STGeomFromText('LINESTRING(x1 y1,x2 y2)',4326); select * from LightWeightPipe.dbo.xxxx_xxx_xx_xxx_EVW a where @g3.STBuffer(0.000001).STIntersects(a.Shape)=1