The Find routine in MapBasic returns a result code that can be queries by CommandInfo(CMD_INFO_FIND_RC). This result code has 3 digits and if the last digit is 3 there wasn't a perfect match, that is the address was found several times. If you in your source code figure out that there wasn't a perfect match you could try selecting all the records that match the address you are looking for at then see if there is another difference in these or if they all point to the same real world address. If the later is the case you might just use one of these.
Alternatively you could have a table where each address only appears a single time, and then you could link your names to these addresses by a unique id: ADDRESSES: Id Address City St. ZIP Longitude Latitude NAMES AId Telephone Number Name HTH, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Rug�rdsvej 55 DK-5000 Odense Denmark Tel +45 6313 5013 Direct +45 6313 5008 Mob +45 5156 1045 Fax +45 6313 5090 E-mail [EMAIL PROTECTED] http://www.cowi.dk COWI GIS konference afvikles i dagene d. 2.-3. september. Se yderligere oplysninger p� www.cowi.dk/Div04/Profiles/nyheder.asp > -----Original Message----- > From: Tom Halbrook [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 2:52 PM > To: [EMAIL PROTECTED] > Subject: MI-L MapInfo Geocoder > > > > I have geocoded a telephone customer database for assistance > in dispatching trouble repair people to customer locations. > The database is geocoded by Lat/Lon location of each > customer. The data fields I am including in the database are > Telephone Number, Name, Address, City, St. ZIP, Longitude, & > Latitude. > > The only constant information in the database is the Address, > City, ZIP and Lat/Lon. Phone numbers and names change over > time as people change residences. > > To keep from making manual changes in the MapInfo table each > time a customer moves to another address I am using a current > database from our customer tracking system to up-date my > Mapinfo table. > > I do this by geocoding the new file to the address field in > the MapInfo table. I have tested this process and it works > well if there is only one line entry for that address. ie, > the customer only has one telephone number. But if there are > multiple instances in either database it won't geocode that > entry. EXAMPLE: If a customer has 3 telephone numbers the > database lists each phone number in a separate line showing > the same address in each line. > > Does anyone know if there is way to make the geocoder > recognize multiple occurrences of the address field. > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7394
