![]() |
||
|
Geocoding with MapInfo Pro and MapMarker Presented at the Puget Sound MapInfo User Group May 6, 2003 Laurel Griffin, Schlosser Geographic Systems, Inc. (SGSI) Note: This presentation was updated in 2008. For a more up-to-date Geocoding discussion... |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Overview: What is GeocodingGeocoding:
A practical definition
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name | Address | Zip |
| Bill Smith | 123 Orca St | 98000 |
After geocoding:

The process of matching records in two databases: your address database (without map position information) and a reference street map or other "address dictionary".
Geocoding software (e.g., MapInfo Pro or MapMarker) links records in the two databases by matching street names and address numbers.
When your database records are successfully matched to a reference street map database, your records are tagged with the correct map positions, typically lat-lon coordinates.
Thereafter, your data table carries its own position information and can be mapped without the reference street map or address dictionary.
MapInfo Pro, by default, hides the map coordinates: i.e., it does not list the Lat-Lon values in the tables. But it uses the coordinates, nevertheless, behind the scenes.
Before geocoding:
| Name | Address | Zip | XCoord | YCoord |
| Bill Smith | 123 Orca St | 98000 | Blank | Blank |
After geocoding:
| Name | Address | Zip | XCoord | YCoord |
| Bill Smith | 123 Orca St | 98000 | -122.345678 | 47.234567 |
To see location patterns more clearly
You can map addresses by zip code, of course, without geocoding at the street level. This produces a very coarse picture compared to a address-level point map.
After geocoding by zip code After geocoding by address
To summarize data by any region
Which district office should handle the new client? Geocode client addresses by street address and see which territory region they fall within.
Are capital improvement projects benefiting all legislative districts equally? Find out by geocoding the street addresses of the capital projects then overlaying the legislative districts.
Banks and insurance companies often report statistics by census tract. To determine the census tract for a loan or depositor, geocode the street addresses, overlay the tract map, then use Query > SQL Select to summarize by tract.
To target more precisely
We may make assumptions about households based on the characteristics of the neighborhoods where they live. If geocoded by street address, we can associate household records with smaller, more homogenous areas such as block groups. This results in more accuracy.
As shown below, the demographics of block group areas can be dramatically different than the demographics of zip codes.
| Higher income zip codes | Higher income block groups | ||
![]() |
![]() |
Geocoding: Part of modern corporate customer information systems
More and more Fortune 1000 corporations are geocoding all their customer addresses as a standard practice. By making map position part of their overall corporate information system design, all areas of the organization can take advantage of spatial analysis techniques.
MapInfo Pro: The original street-level geocoder
The original way to geocode used MapInfo's built-in geocoding engine along with a street map. MapInfo Corp pioneered this technique for PCs, releasing MapInfo (for DOS) in 1987. MapInfo for Windows, released in 1992, also offered street level geocoding using displayable and user-editable street maps.
Geocoding is accessible via the MapInfo menu option Table > Geocode ... Just add street map data.
Requires a street map with street names & address ranges: e.g., "StreetPro", "StreetInfo" or comparable.
Uses an "abbreviation file" (e.g., mapinfow.abb) to standardize some address components: e.g., "Street", "Str", and "St".
Can use a City or Zip code boundary map to distinguish addresses that occur in more than one place in a county.
Advantages of MapInfo Pro
Can be cheaper than MapMarker, if all addresses are in a single or few counties, especially if local government street data is available.
Street address information in street tables is completely editable. Missing a street? Just draw it and fill in the street name and address fields. You can match against this new street immediately..
Can easily use new street map information generated by local governments.
Suitable for use in Mexico & other countries for which MapMarker versions may not (quite yet) be available.
Can be used for reverse-geocoding (EAL version only): ie., look up nearest address based on lat-lon.
MapMarker: Single-purpose stand-alone geocoder
MapMarker is a standalone geocoder software program, introduced by MapInfo Corp. in 1996 and now at Revision 8.3. It can run independent of MapInfo Pro and is optimized to do one thing: geocode quickly.
It is a combined software and data product: i.e., it comes with its own street address reference data files (aka "address dictionary"), and regular data updates.
It is available in three versions, each with different pricing and different levels of precision: MapMarker Zip4, MapMarker, & MapMarker Plus.
Advantages of MapMarker
Cheaper, except for single-county applications.
One-step geocoding, even if addresses are in many different counties across the US.
Cleans or standardizes addresses, zip codes, zip+4 codes on the fly. Can produce USPS "CASS-certified" mailing lists. [CASS-certified means lower postage rates for bulk mailers.]
Includes Zip+4 reference files and can automatically compute the Zip+4 code and geocode to the Zip+4 location as a fallback, if it cannot match to exact street address.
Very fast: SGSI has processed 1,000,000 records in under 2 hours.
Adds census tract, block group, and block codes to the address record as part of its single-pass processing. No separate SQL processing required.
Friendly, straightforward user-interface. Easy to use.
Is engineered as a true client-server application and can be used as the geocoding engine for a web server, for example.
More sophisticated "rule based" matching algorithms are better than those in MapInfo. Offers a better set of "close-match" candidates than MapInfo.
Can geocode address lists stored in a remote server database (Oracle, Informix, etc)
Address and street data is not directly user-editable. However, power users can build & compile their own custom MapMarker-format databases and use them to supplement MapMarker's standard databases.
Can process sets of address files, running in "batch" mode.
| MapInfo+Streets | MapMarker Plus | ||
| 1 County | $650 StreetPro EAL (no Zip+4 data) |
Not available by county except for local government. | |
| 1 State |
$3100 StreetPro EAL, Zip code map. Annual updates. No Zip+4 data included. |
$1400 (as of
1/2004) Quarterly updates, including new Zip+4 information. |
|
| USA | $22,575 StreetPro EAL, Zip code map. Annual updates. Add $10,000 for separate USA Zip+4 database, if desired. |
$10,500 (as of
1/2004) Quarterly updates, including new Zip+4 information. |
Note: Except for the "County" option, StreetPro, Zip code, and MapMarker Plus costs are ballpark annual costs for a one-user desktop license, payable at the beginning of each year and assume a 3-year subscription. Web server usage costs more. The cost of MapInfo Pro is not included.
MapInfo Pro:
"Chapter 8: Geocoding"
MapInfo 7.0 User Guide,
pp. 138ff.
"Appendix B: Advanced Geocoding"
pp. 577ff
MapInfo Pro 7.0 User Guide
MapMarker Plus
MapMarker User Manual, 400 pp. plus short "Getting Started".
Terms of use | Trademarks & copyrights
| SGSI Home | Top of page
Email | Map to Seattle office (pdf) http://www.sgsi.com/
Schlosser Geographic Systems, Inc. (SGSI)
Seattle: 206-224-0800
Anchorage: 907-746-6867
Honolulu: 808-585-1100
Portland: 503-224-0400