MI Geocoding problem
Hi all - I don't understand what is happening (no I am NOT blonde!). I just added a new site to my master table of my California CUC sites. I added the site name, address, zip code - however when I re-geocoded the table it only locates it to the Z1 - the zip centroid. I checked my MapMarker Plus Streets CD and found the street name. Anybody have any insite why isn't it finding it when it geocodes? For that matter I have about 12 sites that geocode to the Z1 when the street name exits. PS to John Hoffmann - I LOVED your Friday Humor! ;))) Sarah Myers Blessed are they who can laugh at themselves for they shall never cease to be amused. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI Geocoding problem
Sarah, First of all, look at the fallback. Might say to ZIP only. 2nd, look at the georesult. Might say N or ND for no data. Either the wrong CD, or not unlocked property (happens). 3rd, try geocoding in interactive mode. This will allow you to see how the columns are matched, etc. Good luck. Dan Munson CDS Business Mapping - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 25, 2000 2:01 PM Subject: MI Geocoding problem Hi all - I don't understand what is happening (no I am NOT blonde!). I just added a new site to my master table of my California CUC sites. I added the site name, address, zip code - however when I re-geocoded the table it only locates it to the Z1 - the zip centroid. I checked my MapMarker Plus Streets CD and found the street name. Anybody have any insite why isn't it finding it when it geocodes? For that matter I have about 12 sites that geocode to the Z1 when the street name exits. PS to John Hoffmann - I LOVED your Friday Humor! ;))) Sarah Myers Blessed are they who can laugh at themselves for they shall never cease to be amused. -- 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]
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]
RE: MI geocoding problem
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]