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

Nearest distance from points to line segmenst

From	"Harry B." <bongoplayer@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Nearest distance from points to line segmenst
Date	2011-10-04 11:41 -0700
Organization	http://groups.google.com
Message-ID	<165d17b5-8db3-4564-9553-049a021d05b3@dm9g2000vbb.googlegroups.com> (permalink)

Show all headers | View raw

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?

TIA,
Harry B.

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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