You are here: Tools > All Tools > Street Geocoder

Street Geocoder Tool

Geocoding associates geographic coordinates with input addresses, letting you pinpoint locations and carry out geography-based analyses. The Street Geocoder tool places a point object based on address interpolation by converting a multi-line address into a normalized form, with latitude and longitude, spatial object, and additional fields specific to the coding process. The full list of available fields is listed below.

The Street Geocoder tool requires a separate installation located on the Core Data Bundle installation Disk.

Even though the Street Geocoder tool performs a type of address standardization, the results are not CASS certified. If you require CASS certification, consider licensing Alteryx's CASS tool. Or use the Geocoder Suite US - This macro CASS certifies and Geocodes a number of different ways to ensure the best possible match.

Configuration Properties

  1. Select A Geocoder: From the dropdown menu, select a geocoder.  All Alteryx Geocoders or Alteryx-supported geocoders will be selectable from this list.

  2. Input Field Names: From the dropdown menu, select the appropriate field from your file for the following inputs:

  3. The fields listed above are optional, but any missing fields or missing data within those fields will have a negative impact on the score of the geocode.

  4. When there is a multiple match: Specify how the geocoder should handle multiple matches. This setting only applies to geocoders that support multiple matches.

back to top

Output Fields

Check the boxes next to the appropriate fields to append to the geocoded data table. Options on the right allow to Select All, Select Defaults (in green text below), or to Clear All.

The output variables available depend on the geocoder product the Alteryx geocoder tool uses. Output variables for Alteryx Explorer are explained in detail below. Third party geocoders will output similar variables.

The Alteryx Geocoder can produce any or all of the following output variables (Defaults in green):

Field Name

Description

Example

MatchStatus

The type of match the record was assigned to.

Exact means the geocoder found an exact match. It does NOT mean this match is an ACTUAL location, however. The exact match could be matching to a zip code for instance (consult GeoLevel to see what the Exact match was).

None means the geocoder could NOT find a geography to match the record to.

Multiple means the geocoder found multiple match possibilities. When the geocoder comes to a record where it finds multiple possibilities to match the record to, a dialog displays asking the user to interactively select the appropriate match.

 

Score

 

A 1-100 value is appended based on the confidence of the match level.

Score of 0.0 is returned for the Canadian Geocoder and Centroid Coder.

 

SpatialObj

 

The spatial (point) object to the assigned to the address record. This is the physical location of the geocoded address.

 

 

Latitude

 

The Latitude (Y) coordinate of the assigned point for the address record.

 

 

Longitude

 

The Longitude (X) coordinate of the assigned point for the address record.

 

 

FirstLine

 

The address # along with the street name are concatenated into a single field.

 

 

LastLine

 

The city, state and ZIP Code values are concatenated into a single field.

 

 

City

 

Assigns the City of the address record.

 

 

Province

 

Assigns the Province (State) of the address record.

 

 

PostalCode

 

Assigns the postal code (ZIP Code) of the address record.

 

 

GeoLevel

 

The geography level the record was geocoded to.

In order of ideal match:

Street: Address is assigned to its interpolated street location.

Intersection: Address is assigned to the intersection of multiple streets.

Extrapolate: When an input address is out of range, the Geocoder assigns the address to the closest known valid street segment.

Example: Main street has valid addresses in the range 1-100. The input address is 127 main street.  Its not a valid address, but it would get assigned somewhere near 100 main street and the resulting GeoLevel==Extrapolate.

Zip 5: Address is assigned to the ZIP Code centroid.

When Geocoding a PO Box, a ZIP 5 centroid is the best match possible. The ZIP code that gets matched is, in most cases, the point location of the Post Office building.

NULL:The input address failed to Geocode.

 

HouseNumber

 

Parses out the house number into its own field.  In the case of an intersection, the first street name’s house number will be listed here.

Example. 123 N King St

StreetPreDir

Parses out the street direction of the address when it appears at the beginning of the address before the geocode process (i.e. N, S, E, W).  In the case of an intersection, the first streetname’s pre direction will be listed here.

Example. 123 N King St

 

Streetname

 

Parses out the street name of the addressduring the geocode process.  In the case of an intersection, the first street’s name will be listed here.

Example.  123 King St N

StreetPostType

Parses out the street type of the address when it appears after the street name.  In the case of an intersection, the first street name’s post type will be listed here.

Example.  123 King St N

StreetPostDir

Parses out the street direction of the address when it appears at the end of the address during the geocode process (i.e. N, S, E, W).  In the case of an intersection, the first street name’s post direction will be listed here.

Example. 123 King St N

 

UnitDesignator

 

Parses out the Unit designator: BOX, #, BLDG, etc.

Example. 123 King St N, #2B

 

UnitNumber

 

Parses out the Unit number (following the designator)

Example. 123 King St N, #2B

 

StateAbbrev

 

Assigns the 2 or 3 character state/province abbreviation.

 

CensusID

Depending on the GeoLevel the record was geocoded to, the CensusID will go to that level of granularity. Census Block Code being the most granular level.

GeoLevel

CensusID Description

Street Census Block
Intersection Census Block

Extrapolate

Census Block

ZIP5 County

CensusID is not returned from the Canadian Centroid coder.

ClusterLevelID

Depending on the GeoLevel the record was geocoded to, the ClusterLevelID will go to that level of granularity. Census Block Code being the most granular level. In all US instances this is the same as the CensusID.

 

 

IntersectingHouseNumber  

 

Parses out the house number of the second street in the intersection into its own field. 

Returned by the US Geocoder only.

 

IntersectingStreetPreDir

 

Appends the intersecting street direction information (i.e. N, S, E, W) before the geocoding process.

Returned by the US Geocoder only.

 

IntersectingStreetName

 

Appends the intersecting street information (where .applicable, else NULL) after the geocoding process

Returned by the US Geocoder only.

 

IntersectingStreetPostType

 

Appends the intersecting street type after the geocoding process (i.e. ST, AVE, BLVD).

Returned by the US Geocoder only.

 

IntersectingPostDir

 

Appends the intersecting street direction after the geocoding process.

Returned by the US Geocoder only.

 

MFPreDirChanged

 

Boolean Match Flag field indicating the input data, Pre-Directional changed in the Geocoding process to assign a match. The matched value will be in the Firstline and Lastline fields.

Returned by the US Geocoder only.

 

MFStreetNameChanged 

 

Boolean Match Flag field indicating the input data, Street Name changed in the Geocoding process to assign a match. The matched value will be in the Firstline field.

Returned by the US Geocoder only.

 

MFStreetPreChanged

 

Boolean Match Flag field indicating the input data, the Street Prefix changed in the Geocoding process to assign a match. The matched value will be in the Firstline field.

Returned by the US Geocoder only.

 

MFStreetPostChanged 

 

Boolean Match Flag field indicating the input data, the Street Suffix changed in the Geocoding process to assign a match. The matched value will be in the Firstline field.

Returned by the US Geocoder only.

 

MFPostDirChanged 

 

Boolean Match Flag field indicating the input data, the Post-Directional changed in the Geocoding process to assign a match. The matched value will be in the Firstline field.

Returned by the US Geocoder only.

 

MFUnitDesAssumed

 

 Boolean Match Flag field indicating an assumption was made with respect to the input data. A Separate Number/Letter with no Unit Descriptor was assumed to be a Unit Number in the Geocoding process to assign a match.

Returned by the US Geocoder only.

 

MFAddNumberOutOfRange 

 

Boolean Match Flag field indicating a problem with the input data, the Address Number is out of range.

Returned by the US Geocoder only.

 

MFAddLetterMovedToUnitNum 

 

Boolean Match Flag field indicating an assumption was made with respect to the input data. A letter in Address Number moved to Unit Number. The matched value will be in the Firstline field.

Returned by the US Geocoder only.

 

MFEvenOddAddDiffer 

 

Boolean Match Flag field indicating that Address number in the input data was different than expected. The Geocoder was expecting the number be even when it was odd, or vice versa.

Returned by the US Geocoder only.

 

MFSuppliedCity

 

Boolean Match Flag field indicating missing input data was supplied by the Geocoder, a City was supplied; The supplied value will be in the Lastline field.

Returned by the US Geocoder only.

 

MFSuppliedState

 

Boolean Match Flag field indicating missing input datawas supplied by the Geocoder, a State was supplied; The supplied value will be in the Lastline field.

Returned by the US Geocoder only.

 

MFSuppliedPostCode 

 

Boolean Match Flag field indicating missing input data was supplied by the Geocoder, a Postal Code was supplied; The supplied value will be in the Lastline field.

Returned by the US Geocoder only.

 

MFCityChanged

 

Boolean Match Flag field indicating the input data, the City was changed in the Geocoding process to assign a match. The matched value will be in the Lastline field.

Returned by the US Geocoder only.

 

MFStateChanged 

 

Boolean Match Flag field indicating the input data, the State was changed in the Geocoding process to assign a match. The matched value will be in the Lastline field.

Returned by the US Geocoder only.

 

MFPostCodeChanged 

 

Boolean Match Flag field indicating the input data, the Postal Code was changed in the Geocoding process to assign a match. The matched value will be in the Lastline field.

Returned by the US Geocoder only.

 

MFUsedCityAlias 

 

Boolean Match Flag field indicating the input data, a City Alias was used in the Geocoding process to assign a match. The matched value will be in the Lastline field.

Returned by the US Geocoder only.

FSA

 

Forward Sortation Area: a geographical region in which all postal codes start with the same three characters.

 

Returned by the Canadian Geocoder only.

LDU

 

Local Delivery Unit: the last 3 characters of a postal code which denotes a specific address or range of addresses.

 

Returned by the Canadian Geocoder only.