Data Items Tab

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.

• Geocode

  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

  13–15 Block

• Geocode Match Level (GEOLEVEL)

  B—Block

  G—Block Group

  T—Tract

  X—No geocode

• 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.

• Tapestry

  (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.

• Census Blocks instead of BGs where available

  Append a 15-character census block instead of the 12-character block group.

• Match Level (Requires additional license and cost)

  B—Block Group

  4—ZIP+4

  T—Census Tract

  Z—ZIP Code

  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.

  Address Coder has two add-ons available: Tapestry and Tapestry ZIP+4. Both allow you to append Esri Tapestry Segmentation codes to address records: the first at the block group level of geography and the second at the ZIP+4 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. The Tapestry ZIP+4 add-on, is specifically geared toward profiling prospects or customers for a direct mail campaign. A ZIP+4 system is designed to improve targeting power and help you take advantage of postal discounts.

  注意:

  A ZIP+4 must be on your input file; Address Coder currently will not add a ZIP+4 to an address.

• 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-character LifeMode code or its long descriptive name.

• Tapestry Urbanization Code/Description

  Append the 2-character Urbanization code or its long descriptive name.

• Status

  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.

• Score

  The match score of the candidate to which the address was matched.

• Side

  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.

• 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 will contain 123 Main St NW as the actual address that was matched.

• Block, BlockL, BlockR

  Similar to geocode, Block is returned by the Address_Points locator, and BlockL and BlockR are returned by the Street_Address Locator.

注意:

Some options and data variables may vary based on the locator being used.