Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #733

Re: Nearest distance from points to line segmenst

Show all headers | View raw

Harry B. (bongoplayer@gmail.com) writes:
> I'm new to the spatial functionality of MS SQL Server 2008.
> 
> I have a table tblPoints with about 3000 point coorodinates and
> another table tblLines with about 100000 polygon coordinates. Each
> polygons is made of various numbers of line segments.
> 
> How looks the sql statement to get the nearest polygon or line segment
> to each point?
 
I recommend that you post your question to 
http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/threads

No matter how much like newsgroups over forum, the spatial stuff goes
completely over my head, so I can't help.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Nearest distance from points to line segmenst "Harry B." <bongoplayer@gmail.com> - 2011-10-04 11:41 -0700
  Re: Nearest distance from points to line segmenst Erland Sommarskog <esquel@sommarskog.se> - 2011-10-04 23:06 +0200

csiph-web