Hi Ian,
This seems to ring a bell from the distant past (about five years ago when
we first got MapInfo).
I think this is caused by the file mapinfow.abb (in the same directory as
mapinfow.exe), which is a look-up table, set up by default to translate full
names to standard abbreviations (eg AVENUE to AVE): what I think is
happening is that the house number is somehow getting translated to a name
(eg 1 to 1st), which is causing the problem.
There are two fixes you could try: either get rid of most or all of
mapinfow.abb to stop the substitutions, or set up the geocoding preferences
to "house number after street name", and modify your address field
accordingly. (You might find you have preferences set up like this already,
in which case, ignore the rubbish above, because this will be the cause!).
Hope this helps - and I hope I've remembered right.
---------------------------------------------
David Booth
Senior GIS Officer
Merseyside Information Service
> -----Original Message-----
> From: Straus, Ian [SMTP:[EMAIL PROTECTED]]
> Sent: 18 April 2001 14:40
> To: '[EMAIL PROTECTED]'
> Subject: MI-L Geocoding: address ranges do not display
>
> I could really use some help preparing files for geocoding by address.
> I'm about ready to ask for Arcview, which another department here has, and
> forget about Mapinfo.
>
> I use Mapinfo 5.5.
> I have a street segment file, Bexrdsl.TAB, which is mappable (works just
> fine as a map layer, I can also make street labels appear, etc.).
> BUT I never have managed to geocode with it and get more than a scattering
> of hits.
> This thing is inherited from another department, who got it from the
> Council
> of Governments...
>
> The file I want to geocode contains addresses. This is survey data in
> file
> "WITR" for short. Field Q17 is the home address field.
>
> At first I thought my problem was that:
> Bexrdsl.TAB did not have the Street column and ToLeft, ToLeft, FromRight,
> ToRight fields set up with the prescribed field names and sequence of
> fields.
> That sequence is explained in Mapinfo Products Knowledge Base item
> question
> "When geocoding, no address ranges are visible?" which is at
> http://testdrive.mapinfo.com/techsupp/miprod.nsf/5c41496d5951a49c852562b50
> 04
> f3a44/605ee801f7dcb80085256755004e9f78?OpenDocument
> and that on-line item references the 5.0 "reference manual" at a page
> which
> is NOT the same in the 5.5 "users guide".
>
> Instead the appropriate columns were in a different sequence with
> different
> names.
>
> So I modified the file to be set up in accord with the Knowledge Base
> article.
> First try, with field name "streetname". Second try, with field name
> "street". [The reference shows it both ways in different paragraphs. Who
> knows which is right? The 5.5 Users Guide doesn't show the prescribed
> fields at all.] I indexed the "streetname" field, and re-indexed it after
> changing it to "street".
>
> Geocoding still doesn't work right! One match out of 434 in automatic
> mode
> (matched two null lines). No more matches in interactive mode, and the
> street numbers still don't display!
> Mapinfo tries to match the house number (left characters of the address)
> to
> the street name:
>
> The geocoding dialog box has:
> Geocode tabe WITR
> Using column Q17
> Boundary column blank
> Search table Bexrdsl
> For objects in column Street
>
> In interactive mode, the WITR file entry "1500 Mission Road" gets streets
> displayed beginning
>
> "10th"
> "10th"
> "10th"
> "12th"
> "12th"
>
> I have verified that "Fromleft" and "Toleft", "FromRight" and "Toright"
> in
> the Bexrdsl file are populated with integers.
>
> This result does not change when I check or uncheck the options to try
> substitutions or to use the closest address number.
>
> It seems obvious to me that there are more undocumented specifications
> necessary to make geocoding by address work.
>
> Do the prescribed fields in Bexrdsl (Street, FromLeft, etc) have to be at
> the left of the table?
> Do I have to separate the house number and the street name in the table to
> be geocoded (table WITR in my case)? If so, what is the required format
> of
> that table? (It must have some specific requirements since the dialog box
> for geocoding does not include an option to designate a house number
> field.)
>
> Is there a magic reference in the 5.5 "reference"? If so, to hell with
> it;
> I had to buy my own users guide since IT here was not responsive.
>
> Ian Straus
> Market Research Specialist
> VIA Metropolitan Transit
> San Antonio, Texas
>
>
>
> ~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~
> Digital GEO data for 125 countries
> LAND INFO International produces digital geographic data for over 125
> countries. DEMs, satellite imagery, topo maps, vector map layers,
> flood maps, and more. Visit http://www.landinfo.com/indexdm1.htm and let
> our specialists find the right solution.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> _______________________________________________________________________
> 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.
~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~
Digital GEO data for 125 countries
LAND INFO International produces digital geographic data for over 125
countries. DEMs, satellite imagery, topo maps, vector map layers,
flood maps, and more. Visit http://www.landinfo.com/indexdm1.htm and let
our specialists find the right solution.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________________________________
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.
