Hi Tom,
Have you got access or visual basic? if the data is in Access tables you
could do the coding there.
as you know, you've got to do a pythag calculation for every flooding source
to every addresspoint (should be fun) and store the id of the nearest one.
This is simple to code;
for x = 1 to addresspoint_record_total
pythag_distance(addresspointx,addresspointy,sewersourcex,sewersourcey)
if stored_distance > pythag_distance then
storedid = addresspoint(x).idnumber
end if
end
something like that anyway. You need to write a pythag_distance function,
and somewhere to store the stored addresspoint id. As you may have guessed
this is psuedo-code and probably nothing near MapBasic, but then i would
predominantly use VB for everything and use MapBasic for when i require a
hefty headache.
----- Original Message -----
From: Tom Manson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 20, 1999 6:21 PM
Subject: MI - finding nearest point
> Dear List,
>
> I have 2 tables, one containing address point data, the other
> incidence of flooding along sewers. What I wish to do is 'link' a
> flooding record to the nearest property, and then update a column in
> my address table with a flooding ID. I would have thought that there
> is some sort of MapBasic code to create concentric rings around the
> flooding objects until it comes across a property, and then attach
> itself to the first one it comes across. It there any code that makes
> this possible?
>
> I know that a few weeks ago some wanted to snap points to a road
> centre-line, which is similar, but I doubt will serve my purposes. Do
> any of you have any ideas.
>
> Many thanks in advance,
>
>
>
> Tom
>
>
> ps Will SUM.
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
