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

[jburn_gis at cogeco.ca]

Not sure if anyone responded to you, but I would suggest you look into using spatial SQL.  For example, a simple query
like:

select [Inspections].[ID], [UInspID], [Observation],
	(select top 1 [Civic_Name_Label]
	from [Parcels]
	order by Distance([Inspections].[ID], [Parcels].[ID]))
into new_table
from [Inspections]

will fine the closes label to a line (in my case), so you should be able to alter this (there's another example in the
help documentation - search for "distance") so that you can find both the closest stream and distance "as the crow
flies" to it.

Cheers.

>
> 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

--------------
James Burn AScT