开发者

SQL Spatial DWithin

开发者 https://www.devze.com 2023-02-24 23:43 出处:网络
Is there a SQL Server 2008 SQL Spatial equivalent to PostGIS DWithin? I have two linestrings that appear to come together at a single point, but it must be that they are just 开发者_运维问答off becaus

Is there a SQL Server 2008 SQL Spatial equivalent to PostGIS DWithin? I have two linestrings that appear to come together at a single point, but it must be that they are just 开发者_运维问答off because STIntersect says they do not intersect.


From http://postgis.refractions.net/documentation/manual-1.3/ch06.html: "ST_DWithin(geometry, geometry, float) Returns true if geometries are within the specified distance of one another. Uses indexes if available."

The equivalent SQL Server method for: ST_DWithin(geomA, geomB, d)

would therefore be: geomA.STDistance(geomB) < d

0

精彩评论

暂无评论...
验证码 换一张
取 消