Alex,
If you have a road dataset that includes the zipcode as an attribute and you
have the zip code in the addresses perhaps you could do a series of
geocoding zipcode by zipcode eg
1) - get list of all zip codes (eg select zipcode from streettab group by
zipcode)
2) - select all roads with the first zipcodes (eg select * from streettab
where zipcode = "ABC" into touse_road)
3) - select all address with the same zipcode (eg select * from address
where zipcode = "ABC" into todo_add)
4) set your geocoding preference to use just the selected datasets eg
Find Using touse_road(add_col)
5) geocode the todo_add table
6) get the next zipcode and repeat from 2)..
this code be relatively straight forward in mapbasic but if you are doing it
manually may be a bit combersome.
Also record the return value from the Find statement so that you can check
the accuracy of the match at a later time.
Cheers
Martin
==================================
Martin Roundill
GIS Manager
Waitakere City Council
Private Bag 93109
Henderson
Waitakere City
New Zealand
-----Original Message-----
From: Alex Chen [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 January 2000 09:17
To: [EMAIL PROTECTED]
Subject: MI geocoding problem
Hi- we have 40,000 addresses that we would like to automatically geocode. We
have the street address, which are not always accurate, as well as it
zipcode, which we are comfortable with. The problem is that sometimes the
address is incomplete, e.g. 100 winchester rather than 100 n winchester.
Automatic geocoding doesnt pick up winchester, further there is a 100 n
winchester and a 100 s winchester, and we are uncomfortable with arbitrarily
picking south or north. My question is, Is there a way to take advantage of
the zip code we have, i.e. if we know the zipcode, we know the general area,
and can exclude parts of winchester - something like that. we are using 5.0
(but can install 5.5). we use mapinfo streetpro. thanks for any ideas
suggestions.
----------------------------------------------------------------------
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]
