Re: MI-L Help with Geocoding?

Tue, 19 Dec 2000 18:12:16 -0800

Hello,
 
Not sure of your data, but I will assume that you do not have a *fully qualifed* address for your customers.
From a *data entry* stand point, number, dir, street, suffix, post dir, apt makes sense but not to MI,
which want *100 E Main St* ONLY, and ripping that apart is a *data* nightmare.
 
Since you didn't mention what fields you are working with it appears that GeoCoding has the Option *Use Closest*
set on so the *closest match* to 400 [what your geocoding] is 40th St.
You need a field called *Address* and put it all together with several queries and update table command via the
MapBasic Window or a MapBasic program to *Make Address*.
 
Add *Address* to the end of your fields
 
Here's the queries and updates for the MBWindow
''' copy the code and paste
''' you'll have to change the field names and table name
'' the starting is that if there is no number then street level geocoding is not needed and would
result in a *regional* error as it may be nowhere near the intended area......also select the blank
addresses and give them back to *data entry* to clean up
 
Select * from Cust where Number > "" into work
update Work Set Address=Number
 
Select * from Work where PreDir > "" into Work2
Update work2 set Address=Address+" "+PreDir
 
Update Work Set Address=Address+" "+Street
 
Select * from Work Where Suffix>"" into work2
Update work2 set Address=Address+" "+Suffix
 
Select * From work where PostDir>"" into work2
Update Work2 set Address=Address+" "+PostDir
 
Select * from work where Apt>"" into Work2
Update Work2 set Address=Address+" #"+Apt
 
You can drop the suffix/post dir/apt if you dont have them --- number & street only & maybe apt/suite/etc
The # in front of apt will tell MI to drop everything after and including it, but this makes the *fully qualified* address
that can be used for mailing labels, cross-referencing, etc.
 
Now GeoCode using Cust and Address against the MapInfo Street File.
 
Been doing this to telephone company records for 911 for 8 years.................
 
 
 
 
 
------------------------------------------------
 
To ME or not to ME, that is the question.
For some it will be to Whistle
and indure the thorns and thistle.
For me it is not to ME, but to NT,
The OS for ME !
----- Original Message -----
From: Allen Lee
Sent: Tuesday, 19 December, 2000 12:33
Subject: MI-L Help with Geocoding?

I am a fairly new MI user (version 5.5), I am following the Geocoding procedures outlined on page 109-113 of the User's Guide, but "something strange is happening here..."

I have a table of about 9000 customer ID numbers, street addresses, zip codes, that I am trying to geocode using the "FLD.TAB" table that came with MapInfo Street Pro. When I attempt to geocode, the MI program tries to match the street address (e.g. 400 PICKENS AVE) with a street name (40th Ave). It does the same thing for all the addresses in my table (630 Denton Blvd with 63 St, etc.)

I do not have a problem geocoding this table using Zip Codes, just street addresses. I would appreciate any suggestions or comments, thanks to all!


_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to