Dear List
I geocoded 8000+ addresses and then did a join to count the number of
addresses on each
city block. The total number of addresses reported under sum when doing a
query calculate--
statistics was 29 addresses larger than it should have been.
I eventually found the first of these addresses that had been counted
twice. It was counted
once in the correct block which was on the left-hand side of the street and
once
in the block on
the right-hand side of the street which was incorrect. Unfortunately, it
was
the second address in
the file. The default offset of 12 survey feet was never altered while
geocoding or at any other
time. I have never had this happen before.
Has anyone else encountered this problem with MapInfo 7.0 or 6.0?
I had to iteratively re-gecode the addresses using smaller and smaller
numbers of
addresses until I found that the second address in the file was the first
address that was doubled.
Does anyone know why this problem has occurred?
Is there a way to avoid this happening again?
Is there an efficient way to find which addresses have been tallied
more
than once?
Doing a "reverse"-join with the address that had been doubled in which
I
join this address
with the block file and assign the block number of the block that contains
this
address to the
address resulted in only one block being assigned to this address that was
doubled and it was the
wrong one.
I greatly appreciate any help on this.
Rebecca Murray
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9576