Skip to main content

[en] US ZIP9 Coder Tool Icon US ZIP9 Coder Tool

[en] Use US ZIP9 Coder to associate geographic coordinates with input ZIP9 (also known as ZIP+4) codes in an address file. This enables you to carry out geography-based analyses. The US ZIP9 Coder appends latitude and longitude, county and state FIPS code, and census tract and block number.

[en] The US ZIP9 Coder tool requires a separate installation located on the Core Data Bundle installation disk.

[en] Configure the Tool

[en] ZIP Field: Select the column containing ZIP code data.

  • [en] If the column contains 9-digit ZIP code, ZIP9 code should be formatted as ZIP5ZIP4: 928661406. Deselect Plus4 in Separate Field.

  • [en] If the column contains 5-digit ZIP code, ZIP5 code should be formatted as ZIP5: 92866

    • [en] Verify that Plus4 in Separate Field is selected.

    • [en] Use the dropdown to select the column containing the 4 digit ZIP code appendage.

  • [en] ZIP4 code should be formatted as ZIP4: 1406.

[en] Output Fields: Select fields to add to the output data stream.

  • [en] Z9_Census_BLOCK: Appends the Census Block ID that the ZIP9 falls in. The Census block group code is the first digit of the Census block code.

  • [en] Z9_Census_ID: Depending on the Match Code the record was coded to, the CensusID will go to that level of granularity. Census Block Code being the most granular level.

  • [en] Z9_Census_TRACT: Appends the Census Tract ID that the ZIP9 falls in.

  • [en] Z9_County_FIPS: Appends the County FIPS ID that the ZIP9 falls in.

  • [en] Z9_Latitude: Assigns the Latitude (Y) coordinate to the ZIP9.

  • [en] Z9_Longitude: Assigns the Longitude (X) coordinate to the ZIP9.

  • [en] Z9_Match_Code: The ZIP level the record was coded to.

[en] Z9_Match_Code

[en] Description

9

[en] ZIP 9 Level Coding

7

[en] ZIP 7 Level Coding

5

[en] ZIP5 Level Coding

0

[en] Coding Failure

  • [en] Z9_Point: The spatial object of the ZIP9

  • [en] Z9_Record_Type: describes the type of facility the ZIP9 code represents.

[en] Type

[en] Description

H

[en] High-rise

F

[en] Firm

S

[en] Street Delivery

R

[en] Rural Route/Highway Contract

P

[en] Post Office

G

[en] General Delivery

Z

[en] TeleAtlas designated 5-digit ZIP

  • [en] Z9_State_FIPS: Appends the State FIPS ID that the ZIP9 falls in.

注意

[en] The ZIP9 Coder only appends the above information to existing ZIP9 or ZIP+4 codes. It does not determine the correct ZIP9 or ZIP+4 code for the input address. The input data must already contain the correct ZIP9 or ZIP+4 codes.

[en] If you use the CASS tool to determine the correct ZIP5 and ZIP+4 codes for the input address, you can then use the ZIP 9 Coder to assign a point object to the results.

: