Skip To Content

About geocoding a table of addresses

This topic shows a high-level overview of geocoding a table of addresses, including the contexts in which you might require this functionality and a look at the tools available in ArcGIS Pro.

Many organizations manage records of information containing locational coordinates, place-names, addresses of customers, businesses, patients, or homeowners in databases. Converting the records into features that contain the location and spatial geometry can be done by matching the table of addresses in ArcGIS Pro using the Geocode Table pane or a geoprocessing tool. When you geocode a table of addresses, you use a locator to create point features that represent the locations of the addresses.

Geocoding a table of addresses

After a table of addresses is geocoded, the output feature class contains a copy of the address fields from the address table. One purpose of carrying over the address fields is for rematching. The names of this set of address fields are prefixed with IN_, and the original fields from your table are prefixed with USER_ so that they are easy to differentiate. When an address is modified during rematching, the new address is saved in the IN_ fields rather than overwriting the original USER_ fields.

The following additional output fields in the geocoding results are dependent on the geocode service or locator used:

  • Loc_name—The name of the participating locator used for matching the address. This field is available only if the locator used for matching the table is a composite locator.
  • Status—A code indicating whether the address was matched. This attribute has values as follows:
    • M—Matched. The address is matched.
    • U—Unmatched. The address is not matched.
    • T—Tied. The address has more than one candidate with the same best match score but at different locations.
  • Score—The match score of the candidate to which the address was matched. The score can be in a range of 0 to 100, where 100 indicates the candidate is a perfect match.
  • Match_type—A code showing how an address was matched. You can group the results based on this attribute to show how the addresses were matched or use the grouping to select records for rematching.
    • A—Automatically matched or rematched.
    • M—Manually matched or unmatched. If the geocoded feature class is rematched, the field may have the code M when you manually match or unmatch.
    • PP—Pick by Point. The address was matched to the click point chosen by the user during the rematch process.
  • Match_addr—The address where the matched location actually resides based on the information of the matched candidate. For example, an input address of 123 Main St N is matched to a candidate with the suffix direction NW, and all other components matched correctly. The Match_addr field contains 123 Main St NW as the actual address that was matched.
  • LongLabel—A longer version of the Match_addr containing more administrative information.
  • ShortLabel—A shortened version of the Match_addr.
  • Addr_type—The geocoded address type. This attribute indicates the match level to which the address matched. You can study the accuracy of the matched addresses and pattern of the matches based on the values. Supported match levels vary in different countries. Possible values include the following:
    • SubAddress—A street address based on points that represent house and building subaddress locations. The subaddress elements of unit type and unit identifier help to distinguish one subaddress within or between structures from another when several occur within the same feature or PointAddress location. Reference data contains address points or polygons with associated house numbers, street names, and subaddress elements, along with administrative divisions and optional postal code, for example, 3836 Emerald Ave, Suite C, La Verne, CA, 91750 . It's usually a precise location of the address.
    • PointAddress—A street address based on points that represent house and building locations. Typically, this is the most spatially accurate match level. Reference data contains address points with associated house numbers and street names, along with administrative divisions and optional postal code. The X and Y and geometry output values for a PointAddress match represent the street entry location for the address; this is the location used for routing operations. The DisplayX and DisplayY values represent the rooftop or actual location of the address, for example, 380 New York St, Redlands, CA, 92373.
    • StreetAddress—A street address that differs from PointAddress because the house number is interpolated from a range of numbers. Reference data contains street centerlines with house number ranges, along with administrative divisions and optional postal code information, for example, 647 Haight St, San Francisco, CA, 94117.
    • StreetInt—A street address consisting of a street intersection along with city and optional state and postal code information. This is derived from StreetAddress reference data, for example, Redlands Blvd & New York St, Redlands, CA, 92373.
    • StreetName—Similar to a street address but without the house number. Reference data contains street centerlines with associated street names (no numbered address ranges), along with administrative divisions and optional postal code, for example, W Olive Ave, Redlands, CA, 92373.
    • Locality—A place-name representing a populated place. This typically represents an administrative division: Block, Sector, Neighborhood, District, City, MetroArea, Subregion, County, Region, State, Territory, or Country.
    • PostalLoc—A combination of postal code and city name. Reference data is typically a union of postal boundaries and administrative (locality) boundaries, for example, 7132 Frauenkirchen.
    • PostalExt—A postal code with an additional extension, such as the United States Postal Service ZIP+4. Reference data is postal code points with extensions, for example, 90210-3841.
    • Postal—Postal code. Reference data is postal code points, for example, 90210 USA.
    • POI—Points of interest. Reference data consists of administrative division, place-names, businesses, landmarks, and geographic features, for example, Starbucks.
    • SingleField—Any unique feature represented in a feature class, such as place-names, points of interest, tax parcels, census tracts, meters, or alphanumeric strings used to identify locations, such as N1N115.
    • LatLong—An x,y coordinate pair. The LatLong addr_type is returned when an x,y coordinate pair, such as 117.155579,32.703761, is the search input.
    • Coordinates—Geographic coordinates, such as -84.392, 32.722.
    • SpatialOperator—The location that contains an offset distance from the found address, for example, 30 yards South from 342 Main St.
    • MGRS—A Military Grid Reference System (MGRS) location, such as 46VFM5319397841.
  • Type—The feature type for results returned by a search. As an example, for Starbucks, Type = "Coffee Shop".
  • PlaceName—The formal name of a geocode match candidate. This is only returned for findAddressCandidates requests, for example, "Paris" or "Starbucks".
  • Place_addr—The full street address of a place, including street, city, and region. This is only returned for POI searches. The field is returned but empty for address, intersection, and postal searches, for example, "275 Columbus Ave, New York, New York".
  • Phone—The primary phone number of a place. For other searches, such as address, intersection, and postal code, the field is empty, for example, Knott's Berry Farm, Phone = "(714)220-5200".
  • URL—The URL of the primary website for a place. For other searches, such as address, intersection, and postal code, the field is empty, for example, the University of Georgia, URL = "http://www.uga.edu/ ".
  • Rank—A numerical text value indicating the importance of a result relative to other results with the same name. For example, there are cities in France and Texas named Paris. Paris, France, has a greater population than Paris, Texas, so it has a higher rank. Rank is used to sort results for ambiguous queries such as "Lincoln", where no additional information (state) is available. Rank values are based on population or feature type. Note that Rank is not used with all features, so some responses will contain a blank Rank value. This value is returned for Locality, City, and POI matches only.
  • AddBldg—The name of a building, for example, Empire State Building.
  • AddNum—The alphanumeric value that represents the portion of an address typically known as a house number or building number, for example, in the address "380 New York Street", AddNum = 380. This value is returned for PointAddress and StreetAddress matches only.
  • AddNumFrom—A value representing the beginning number of a street address range. It is relative to direction of feature digitization and is not always the smallest number in the range. This value is provided for StreetAddress match results.
  • AddNumTo—A value representing the ending number of a street address range. It is relative to direction of feature digitization and is not always the largest number in the range. This value is provided for StreetAddress match results.
  • AddRange— The full address number range for the street segment that an address lies on, in the format "AddNumFrom-AddNumTo". For instance, the AddRange value for street address "123 Main St" may be "101-199."
  • Side—The side of the street where an address resides relative to the direction of feature digitization. This value is not relative to the direction of travel along the street. This attribute can have one of the following values:
    • L—The address is matched to the left side of the street.
    • R—The address is matched to the right side of the street.
    • No value—The address is not matched, or the locator could not determine the side of the street.
  • StPreDir—An address element defining the direction of a street, which occurs before the primary street name, for example, "North" in "North Main Street".
  • StPreType—An address element defining the leading type of a street, for example, the Spanish term "Avenida" in Avenida Central or the French term "Rue"in Rue Lapin.
  • StName—An address element defining the primary name of a street, for example, "Main" in North Main Street.
  • StType—An address element defining the trailing type of a street, for example, "Street" in Main Street.
  • StDir—An address element defining the direction of a street, which occurs after the primary street name, for example, "North" in "Main Street North".
  • BldgName—The name or number of a building subunit. For example, A in "building A".
  • BldgType—The classification of a building subunit. Examples are building, hangar, and tower.
  • LevelType—The classification of a floor subunit. Examples are floor, level, department, and wing.
  • LevelName—The name or number of a floor subunit. For example, 3 in "level 3".
  • UnitType—The classification of a unit subunit. Examples are unit, apartment, flat, office, suite.
  • UnitName—The name or number of a unit subunit. For example, 2B in "apartment 2B".
  • SubAddr—The Subaddress, a subset of PointAddress, that represents a house or building subaddress location, such as an apartment unit, floor, or individual building within a complex. The UnitName, UnitType, LevelName, LevelType, BldgName, and BldgType field values help to distinguish subaddresses that may be associated with the same PointAddress. Reference data consists of point features with associated house number, street name, and subaddress elements, along with administrative divisions and optional postal code; for example, 3836 Emerald Ave, Suite C, La Verne, CA, 91750.
  • SubAddressType—The classification of a unit subunit. Examples are unit, apartment, flat, office, and suite.
  • SubAddressUnit—The name or number of a unit subunit. For example, 2B in "apartment 2B".
  • StAddr—The street address of a place without a zone, such as city or state, for example, "275 Columbus Ave".
  • Block—Block is the smallest administrative area for a country. It can be described as a subdivision of sector or neighborhood or a named city block. Not commonly used.
  • Sector—Sector is a subdivision of neighborhood, district, or a collection of blocks. Not commonly used.
  • Nbrhd—A neighborhood or subsection of a city or district.
  • District—District name. Subdivision of city.
  • City—The next smallest administrative area for a country, typically a city or municipality.
  • MetroArea—Metropolitan area name. An urban area consisting of a large city and the smaller cities surrounding it. Can potentially intersect multiple subregions or regions. An example is the Kolkata Metropolitan Area in India.
  • Subregion—A secondary administrative area for a country, typically a county or region.
  • County—A secondary administrative area for a country, such as a county within a state.
  • Region—The largest administrative area for a country, typically a state or province.
  • RegionAbbr—Abbreviated region name. The RegionAbbr value for California is CA.
  • State—The largest administrative area for a country, typically a region or province.
  • StateAbbr—Abbreviated state name. The StateAbbr value for California is CA.
  • Territory—Territory name. Subdivision of a country. Not commonly used. The Sudeste macroregion of Brazil, which encompasses the states of Espírito Santo, Minas Gerais, Rio de Janeiro, and São Paulo, is an example.
  • Postal—An alphanumeric address element defining the primary postal code, for example, "V7M 2B4" for a Canadian postal code and "92374" for a USA postal code.
  • Zip—An alphanumeric address element defining the primary postal code, for example, "V7M 2B4" for a Canadian postal code and "92374" for a USA postal code.
  • PostalExt—An alphanumeric address element defining the postal code extension, for example, "8100" in USA postal code 92373-8110.
  • Zip4—An alphanumeric address element defining the postal code extension, for example, "8100" in USA postal code 92373-8110.
  • Zip4Low—An alphanumeric value representing the beginning number of a postal code extension range. This value is provided for PostalExt match results.
  • Zip4High—An alphanumeric value representing the ending number of a postal code extension range. This value is provided for PostalExt match results.
  • Country—A 3-digit ISO 3166-1 code for a country, for example, United States of America = "USA". A list of supported countries is available in Geocode coverage for the World Geocoding Service.
  • LangCode—A 3-digit MARC language code, representing the language of the address, for Example, "ENG" = English. See a list of codes.
  • Distance—The physical distance in meters from a candidate to a specified location. The Distance output value is calculated for each candidate when the Location input parameter is passed in a request using the findAddressCandidates REST operation. If the Location parameter is not passed in a request, the value of Distance is zero.
  • X—The primary x-coordinate of the matched address in the spatial reference of the locator. The x-coordinate is returned in spatial reference WGS84 (WKID 4326) by the World Geocoding Service.
  • Y—The primary y-coordinate of the matched address in the spatial reference of the locator. The y-coordinate is returned in spatial reference WGS84 (WKID 4326) by the World Geocoding Service.
  • DisplayX—The display x-coordinate of an address returned in the spatial reference of the locator. The display x-coordinate is returned in spatial reference WGS84 (WKID 4326) by the World Geocoding Service. For PointAddress locators, this value represents the actual location of the address (that is, the building or parcel centroid). It differs from the x-value, which is derived from a location along the street or the street entry for an address. For all other locators, this value is equal to the x-value.
  • DisplayY—The display y-coordinate of an address returned in the spatial reference of the locator. The display y-coordinate is returned in spatial reference WGS84 (WKID 4326) by the World Geocoding Service. For PointAddress locators, this value represents the actual location of the address (that is, the building or parcel centroid). It differs from the y-value, which is derived from a location along the street or the street entry for an address. For all other locators, this value is equal to the y-value.
  • Xmin—The minimum x-coordinate for the display extent of a feature returned by the locator. The Xmin, Xmax, Ymin, and Ymax values can be combined to set the map extent for displaying a geocode result. The extent coordinates use the spatial reference of the locator but in spatial reference WGS84 (WKID 4326) by the World Geocoding Service.
  • Xmax—The maximum x-coordinate for the display extent of a feature returned by the locator. The Xmin, Xmax, Ymin, and Ymax values can be combined to set the map extent for displaying a geocode result. The extent coordinates use the spatial reference of the locator but in spatial reference WGS84 (WKID 4326) by the World Geocoding Service.
  • Ymin—The minimum y-coordinate for the display extent of a feature returned by the locator. The Xmin, Xmax, Ymin, and Ymax values can be combined to set the map extent for displaying a geocode result. The extent coordinates use the spatial reference of the locator but in spatial reference WGS84 (WKID 4326) by the World Geocoding Service.
  • Ymax—The maximum y-coordinate for the display extent of a feature returned by the locator. The Xmin, Xmax, Ymin, and Ymax values can be combined to set the map extent for displaying a geocode result. The extent coordinates use the spatial reference of the locator but in spatial reference WGS84 (WKID 4326) by the World Geocoding Service.

The following are optional fields that are returned if the Output Fields options were checked in the address locator's properties before geocoding:

  • Pct_along—For address locators that use feature classes with polyline geometry as reference data, Pct_along (percent along) specifies where the matched address is located along the reference feature as a percentage of the feature's total length. The percentage is measured along the digitized direction of the line feature.
  • Ref_ID—The reference ID of the matched feature.
  • StreetID—StreetID can be used to associate a Single House feature to a specific street segment. There are situations where the rooftop location of a Single House match may be closer to another street segment that it is not associated with or would not be correct when routing to it.
  • Stan_addr—The standardized address.

Practice geocoding a table of addresses with a tutorial