VERIFIED SOLUTION i

MapMarker:How to format tables to be used for geocoding Intersections

Products affected: MapMarker™
Intersection Geocoding

MapMarker can geocode to street intersections in two ways. The method chosen depends on how the street and cross street information will be stored in the table.

Intersection addresses stored in one column.

With this method of intersection geocoding, MapMarker reads input street addresses that contain intersection tokens (such as "&&") between the street and the cross street. If that information is not in the table, create a column that contains the street and the cross street.

Street 1 and Street 2 names can be separated by one of the following intersection tokens: "and",  "at",  "&",  "&&".

For example, to specify the intersection of Main Street and Washington Avenue, the column input address could look like:

Main Street && Washington Avenue
Main St & Washington Ave.
Main St at Washington Ave
Main St and Washington Ave

It is possible to Omit spaces between the token and the street name, but the space is required for the "and" separator.

To use this single-column method to geocode to street intersections, do the following:
1.    Open the table to geocode.
2.    In the Select input columns from your table dialog, specify the columns that have the appropriate address components. Map the column that contains the intersection information to the Address box.
3.    Click Next. In the Select output columns from your table dialog, select the columns in which will store the output
4.    Click Finish.
5.    If the Geocode dialog does not display automatically, select Table > Geocode.
6.    Click Geocode.
Intersection addresses stored in separate columns.

In this method of intersection geocoding, the street and cross street are stored in separate columns. An option in the Select input columns from your table dialog allows which column to use as the cross street. To use this method to geocode to street intersections, do the following:

1.    Open the table to geocode.
2.    In the Select input columns from your table dialog, specify the columns from the table that have the appropriate address components. Map the columns that have the street and cross street information to the Address and Address2 boxes.
3.    Select the Use Address2 Column as Intersection Cross Street check box.
4.    Click Next. In the Select output columns from your table dialog, select the columns to store the output.
5.    Click Finish.
6.    If the Geocode dialog does not display automatically select Table > Geocode.
7.    Click Geocode.

 
UPDATED:  July 22, 2019