SQL Server 2008 Spatial Data

[Bassam Saoud]

Hi All, I am struggeling finding an effectient way to find a distance between a Point that intersects a polygon and the border of that polygon. I was able to use the STDistance comparing the point to every point that made up the polygon but that is taking a lot of time. Using SPatial indexe wasn't much helpful because the STDistance is not part of any constraint and even when I did put the constraint, the index didnt help much. I appreciate any feedback. Thanks

[Peter_in_2780]

Looks like you might have to write some code. For the basics, google "distance point line". Once you have that, you just need to find the minimum of the distances to the edges of the polygon. Calculation should be O(n) for an n-gon.

Software rusts. Simon Stephenson, ca 1994.

[Bassam Saoud]

Thats what I am doing but its freakin slow. After a lot of research I found an excelent blog describing an efficient way to do this: Nearest neighbors[^]