[Manifold-l] Minimum distance betw. lines and points

[Robert Sanson]

Hi Martin
 
This query will create a new table holding the Point ID, the River ID of the nearest stream and the distance in m between them: 
 
INSERT INTO [Point_Dist]
SELECT [PointID], (SELECT TOP 1 [RiverID], Distance([Rivers Drawing].[ID], [Points Drawing].[ID], "m") as Dist_m
  FROM [Rivers Drawing] 
  ORDER BY Distance([Rivers Drawing].[ID], [Points Drawing].[ID])) 
FROM [Rivers Drawing];
 
Cheers,
 
Robert Sanson
 
Robert Sanson, BVSc, MACVSc, PhD
GeoSpatial Services
AgriQuality Limited
PO Box 585, Palmerston North
NEW ZEALAND
 
Phone: +64 6 351-7990
Fax: +64 6 351-7919
Mobile: 021 448-472
E-mail: sansonr at agriquality.com

>>> "M Roseveare" <m.roseveare at archaeophysica.co.uk> 21/03/2007 6:05 a.m. >>>

Dear all,

I'm researching a spatial analysis problem and am wondering whether anyone
can shed any light?

I have a set of points representing observation locations and a set of lines
representing streams. For each point I need to calculate the minimum
distance to a stream.

Because my streams are lines I can't use network methods to calc. shortest
paths and as I'm after a minimum value I can't just replace the streams with
lines of points.

Can anyone suggest anything? It seems to be an easy concept in theory but
not in practice!

Thanks,

Martin


Martin Roseveare
Senior Geophysicist


Web: www.archaeophysica.co.uk
Phone: +44 (0) 1989 730 564
Fax: +44 (0) 7050 369 790

This e-mail and any attachment may contain proprietary or confidential
material and be subject to legal privilege. If you have received it in error
please promptly erase it from your system and inform the sender.
It should not be copied, disclosed to, retained or used in any way by any
other party.

Nothing in this e-mail should be regarded as representing a binding contract
unless explicitly stated otherwise. All opinions are those of the sender and
not necessarily ArchaeoPhysica Ltd.


_______________________________________________
Manifold-l mailing list
Manifold-l at lists.directionsmedia.net
http://www.directionsmedia.net/mailman/listinfo/manifold-l



------------------------------------------------------------------
FROM FARM TO FORK. GLOBAL EXCELLENCE IN FOOD SAFETY AND BIOSECURITY.
www.agriquality.com / www.agriquality.co.nz / www.agriquality.com.au

The contents of this email are confidential to AgriQuality.
If you have received this communication in error please notify
the sender immediately and delete the message and any attachments.
The opinions expressed in this email are not necessarily those of
AgriQuality.

This message has been scanned for known viruses before delivery.
------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.directionsmedia.net/pipermail/manifold-l/attachments/20070321/3a0abd01/attachment.htm