The Data Items tab shows all the data items you are licensed to append to your file. The left column shows the available items, and the right column shows the items you have selected. Please note that Basic Variables and Tapestry Variables must be listed above any other add-on data items.
Tapestry items require an additional Tapestry license. Without an additional license, these variables will not appear in your list of available items.
Up to 15-digit string showing the census geography for the current record. The geocode is in the following format:
1–2 State FIPS Code
3–5 County FIPS Code
6–11 Census Tract/BNA
12 Block Group
- Geocode Match Level (GEOLEVEL)
- Latitude/Longitude/Match Code (MATCH_CODE)
A centroid indicating the latitude and longitude position of the address. The accuracy of this point is based on the value for the Minimum Quality of Geocodes option on the Miscellaneous tab.
Match codes (MATCH_CODE) detail the known qualities about the geocode. A location code has 5 characters. The first character indicates whether some part of the address was matched into one of four locator files (one of five locator files if the ZIP+4 option is used). The second character indicates which of the locator files the address was matched to. The third through fifth characters indicate how well the address match into the locator specified by the character in position 2.
1st Character (Status)
M—Record was matched to a locator file.
U—No match was possible.
2nd Character (Location Name)
A—Address Points Locator: Indicates a match to the Tele Atlas Address Points database. Census Block ID and latitude/longitude coordinates are accurate to the address level.
S—Street Address Locator: Indicates a match to the street address. Census Block ID and latitude/longitude coordinates are accurate to the street level.
4—ZIP+4 Locator: Where Zip4 type = 1: Indicates a match to the ZIP+4 centroid. Census Block ID and latitude/longitude coordinates represent the centroid of the ZIP+4.
N—Street Name Locator: Indicates a match to the street name. Census Block ID and latitude-longitude coordinates are accurate to the midpoint of the street segment.
2 —ZIP+4 Locator: Where Zip4 type = 2: Indicates a match to the ZIP+2 centroid. No Census Block ID is available for this location. Latitude and longitude coordinates represent the centroid of the ZIP+2.
Z—ZIP Code Locator: Indicates a match to the 5-digit ZIP Code. No Census Block ID is available for this location. Latitude and longitude coordinates represent the centroid of the 5-digit ZIP Code.
C—City Locator: Indicates a match to just the city. No Census Block ID is available for this location. Latitude and longitude coordinates represent the centroid of the city.
X—Indicates a record that could not be matched by any of the locators.
Characters 3-5 (Score)
000–100: The score is a value assigned to all potential candidates of an address match. The match score is based on how well the locations found in the reference data match the address data being searched. A score can range from 0 to 100, with 100 being a perfect match.
- Locator Name
Description of the locator used for this address, for example, Address_points, Street_Address, Zipcode, or Zip4 (if available).
- ZIP+4 Type (if available)
Append ZIP+4 Locator Type used to identify the given ZIP+4, usually 1 or 2.
- 1—Indicates a ZIP+4 centroid
- 2—Indicates a ZIP+2 centroid
- Complete Address Line
Address Coder will append the standardized address information.
- Complete Last Line (City, State and ZIP Code)
Address Coder will append the standardized city, state, and ZIP Code information.
(Requires additional license and cost) This check box is not checked by default. A 2-digit alphanumeric code representing 1 of 66 consumer segments is added. If this check box is checked, the Customer Tapestry Profile will be produced. The program will prompt you for the base to use on your report. You have the option of appending the 2-character Tapestry Code, the full 30-character description, or both. Additionally, you can create a .csv file that will contain the Tapestry information found on the 2nd Tapestry Report page. You may also display this file in Notepad once processing is complete.
- Match Level (Requires additional license and cost)
X—No Tapestry code applied
Additional options in Address Coder, which employ Esri's Tapestry Segmentation data, can help organizations find the types of consumers who would be most interested in their products and services. You can use this information to craft different messages for various audiences based on the codes appended to each address record. Knowing who to target and what to target can cut marketing costs and improve response rates.
The Address Coder Tapestry add-on allows you to append Esri Tapestry Segmentation codes to address records at the block group level of geography. The Tapestry add-on at the block group level is ideal for doing customer and market area analysis and is less expensive to purchase.
- Calculate Similarity Index for these Geographies
When you append Tapestry codes to your file, you have the option to calculate a Similarity Index. This is a way of locating other areas (states, CBSAs, counties, or ZIP Codes) with a similar Tapestry makeup to your profile. A high index indicates the presence of your top Tapestry types. So if the highest Tapestry Index on your report is 250, areas that are 100 percent of this type will get an SI of 250.
- CBSA Code (CBSA Name)
Append a 5-digit CBSA code indicating the Core Based Statistical Area in which the address lies. Current definitions are from the latest revisions released in 2010. In order to append the code to all possible records, it is required that the GeoFix check box be checked.
- State FIPS Code
The state's 2-digit FIPS Code will be appended to each record.
- County FIPS Code
Append the county's 5-digit FIPS Code.
- Census Tract (SSCCCTTTTTT)
Append the 11-character census tract code (state FIPS/county FIPS/tract with no decimal point).
- Census Block Group
A block group is a collection of blocks and a subdivision of a Census Tract. In general, a block group is comprised of approximately 1,300 residents. There are over 200,000 block groups in the United States.
- Census Block
Census blocks are the smallest areas for which data is reported from a decennial census. They are commonly delimited on all sides by physical features such as streets, railroad tracks, or rivers. However, the tabulation blocks for which data are reported may also be delimited by invisible features such as county lines. Tabulation blocks don't cross the boundaries of any area for which decennial census data is reported. They are numbered uniquely within census tracts by a 4-digit code. Census blocks in sparsely settled areas may contain many square miles of territory.
- Tapestry LifeMode Code/Description
Append the 2 or 3 character LifeMode code or its long descriptive name.
- Tapestry Urbanization Code/Description
Append the 2 character Urbanization code or its long descriptive name.
A code indicating whether the address was matched. This attribute has values of M for matched addresses, U for unmatched addresses, and T (tied) for addresses for which there was more than one candidate with the best match score.
The match score of the candidate to which the address was matched.
The side of the street to which an address was matched—if the address locator that was used to match the table contains address information for both sides of the street. This attribute has values of L for the left side of the street, R for the right side of the street, or nothing if the address locator could not determine the side of the street.
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 will contain 123 Main St NW as the actual address that was matched.