generate … using
| Specify the columns to be used for standardized address fields and from which
column each standardized address should be extracted. Either new columns may
be automatically created or existing columns may be used.
|
Address
| Column to be used for the standard field that contains the building number and
street name. Choosing [New Column] will add a new column to the table called Address.
|
City
| Column to be used for the standard field that contains the city name. Choosing [New Column] will add a new column to the table called City.
|
State
| Column to be used for the standard field that contains the state name.
Choosing [New Column] will add a new column to the table called State.
|
Zip
| Column to be used for the standard field that contains the five-digit postal
ZIP code. Choosing [New Column] will add a new column to the table called Zip.
|
Country
| Optional column for country name. The Manifold Geocoding engine recognizes
typical variations of country names ("US," "USA," "United States," "The United States of America," and so on).
|
Status
| If desired, add a column that reports the status of a particular record after
processing. [None] does not report status, [New Column] will add a new column to the table called Status.
|
Fail on
| Criterion to be used to declare a particular record to be unmatched.
|
Normalize addresses
| Convert address nomenclature into standardized abbreviations, such as "Rd" for
"Road," state names into official postal abbreviations. etc.
|
Skip completed records
| Do not process records that already have values in the designated Address, City, State and Zip fields.
|
any error
| Does not process record unless it is a perfect match in all fields. Equivalent
to setting an "unknown building" error.
|
unknown street name, possible misspelling
| Matches to Zip and City and does not process record unless the street name is an exact match.
|
unknown street name, no similar names
| Matches to Zip and City, and attempts to match to similar street names if an exact match to the
street name cannot be found. Uses "Soundex" and similar algorithms to attempt to
find the right street in case of a street name misspelling. This is the default
setting.
|
unknown zip
| Do not process record if the zip code cannot be found.
|
critical error
| Stop processing only on problems with an incomplete geocoding database or on
hardware failure.
|
ok
| No errors in processing record.
|
unknown building
| The geocoder was able to locate the zip code and the street name, but the
street does not appear to contain an address of the given number.
|
unknown street name, possible misspelling
| The geocoder was able to locate the zip code but not the street name; however,
the zip code does contain some streets with names similar to the street name.
|
unknown street name, no similar names
| The geocoder was able to locate the zip code but not the street name. The zip
code does contain any streets with names similar to the street name.
|
unknown zip code
| The geocoder could not locate the zip code.
|
critical error
| The geocoder could not function due to an incomplete geocoding database, a
problem accessing the database or a hardware failure.
|
generate … using
| Specify the columns to be used for Longitude and Latitude, Status and Match type fields, and which columns in the table should be used for the standardized Address, City, State, and Zip fields.
|
Longitude
| Table column to be used for the longitude of geocoded record. Contains 0 if the record was not geocoded. Use [New Column] to automatically create a new column called Longitude.
|
Latitude
| Table column to be used for the latitude of geocoded record. Contains 0 if the record was not geocoded. Use [New Column] to automatically create a new column called Latitude.
|
Status
| If desired, add a column that reports the status of a particular record after
processing. [None] does not report status, [New Column] will add a new column to the table called Status.
|
Match type
| If desired, add a column that reports the geocoding match type of a particular
record after processing. [None] does not report match type, [New Column] will add a new column to the table called Match type.
|
Fail on
| Criterion to be used to declare a particular record to be unmatched.
|
Offset Locations by
| Offset the location for each geocoded record by the given number of units from
the street line, to the left or right side of the street based on whether the
address was found in the left or right range.
|
Skip completed records
| Do not process records that already have values in the designated Address, City, State and Zip fields.
|
any error
| Does not process record unless it is a perfect match in all fields.
Equivalent to setting an "unknown building" error.
|
unknown street name, possible misspelling
| Matches to Zip and City and does not process record unless the street name is an exact match.
|
unknown street name, no similar names
| Matches to Zip and City, and attempts to match to similar street names if an exact match to the
street name cannot be found. Uses "Soundex" and similar algorithms to attempt to
find the right street in case of a street name misspelling. This is the default
setting.
|
unknown zip
| Do not process record if the zip code cannot be found.
|
critical error
| Stop processing only on problems with an incomplete geocoding database or on
hardware failure.
|
Record
| Current record as it has been read from the table. A read-only edit box that
can be used with Copy.
|
Address
| Address value now in use.
|
City
| City value now in use.
|
State
| State value now in use.
|
Zip
| Zip value now in use.
|
(result)
| Result of last Look Up operation.
|
Found pane
| A list of possible matches found in the geocoding database. Clicking on one of
the matches will load it into the edit boxes. Double-clicking on one of the
matches will load it and immediately Accept it as well and move on to the next record.
|
Accept
| Accept the current values in the edit boxes. Click on one of the choices in
the Found pane and then choose Accept. This updates the table with specified values, replacing the current values
of the record.
|
Look Up
| Look up the current address in the edit boxes in the geocoding database. When
used with Standardize, this checks the possible validity of the address. When used with Geocode, this looks up the location of the address.
|
Previous
| Reload the previous values for this address into the edit box. Enabled if the
address has been edited, either by choosing a possible match in the Found pane or by manually editing the address.
|
Skip
| Skip this record and continue with other unmatched records.
|
Close
| Skip this and all remaining unmatched records. Note that any Accept commands that have been issued for any unmatched records before a Close command will have already updated the table. Close is not the same as a Cancel of all changes made in this session with the Unmatched Records dialog.
|