English

Problem: TIGERTOOL does not convert U.S. Census Bureau 2000 TIGER UA data correctly

Description

The ArcInfo Workstation command TIGERTOOL, which can also be run from the 'Tiger to Coverage Wizard' in ArcToolBox, does not convert U.S. Census Bureau 2000 TIGER UA data correctly.

Cause

The U.S. Census Bureau has changed the definition for certain items in the Record Type A, Tgrxxxxx.rta and the Record Type S, Tgrxxxxx.rts tables that pertain to the TIGER 2000 UA data files.

These files can be downloaded from the U.S. Census Bureau at:
http://www.census.gov/geo/www/tiger/tigerua/

Solution or Workaround

Follow the steps below to update the items which the U.S. Census Bureau has redefined in the tigera_1999.def and in the tigers_1999.def files.

1. In ArcCatalog, navigate to \arcgis\arcexeXX\template\headers directory and make backup copies of the following files:

tigera_1999.def
tigers_1999.def

2. In ArcCatalog, open the Properties of the tigera_1999.def file and select the Items tab. Delete the following items:

UA90
UR90
RS5
STATE90
COUNTY90
AIANHH90

3. Select the item TAZ and click the Add button. Add the following items with the following item definitions:


NAME TYPE INPUT_WIDTH OUTPUT_WIDTH
UA INTEGER 5 5
UA90 INTEGER 4 4
STATE90 INTEGER 2 2
COUNTY90 INTEGER 3 3
AIANHHCE90 INTEGER 4 4

Why are the new items defined as integer?

When the JOIN option is specified during the conversion process, the TYPES table is joined to the polygon attribute table. In the TYPES table, the UR and UR90 items are defined as 1 1 C and are populated with values of 'U' or 'R' (Urban or Rural). These were the old classifications used by the U.S. Census Bureau to differentiate between Urban and Rural areas.

For the 2000 TIGER UA data, the U.S. Census Bureau expanded the definitions of urban and rural areas to allow for more differentiation beween these two classifications.

The new items UA and UA90 are defined respectively in the TYPEA table as:

UA 5 5 Integer
UA90 4 4 Integer

To access these item values via the PAT of the coverage, use the JOINITEM command, with the following syntax:

JOINITEM <in_info_file> <join_info_file> <out_info_file> <relate_item> {start_item} {LINEAR | ORDERED | LINK}

Note that the relate item used to establish the link between the two tables is CENPOLID. The <in_info_file> is the coverage PAT, the <join_info_file> is the coverage TYPEA table, and the <out_info_file> will be the coverage PAT file.

When JOINITEM is completed, you will have the UR, UR90, as well as the UA and UA90 items included in the polygon attribute table.


4. In ArcCatalog, open the Properties of the tigers_1999.def file and select the Items tab. Delete the item:

RS8

5. Select the item ZCTA5 and click the Add button. Add the following items with the following item definitions:


NAME TYPE INPUT_WIDTH OUTPUT_WIDTH
UR CHARACTER 1 1
UR90 CHARACTER 1 1

Note:
An alternative to editing the tables with the above procedure is to download a ZIP archive that contains E00 interchange files of the two templates. This file is called "2000 Urban Area Census Header Definitions" and is provided in the Related Information below.

Before unzipping the archive, be sure to:

A. Rename the existing tigera_1999.def and tigers_1999.def files before installing the updated files. The new definition files will NOT correctly convert older tiger files from the Census Bureau.

B. Uncheck the “TAR file smart CR/LF conversion” box, found in WinZip. This check box is found under the Options > Configuration > Miscellaneous tab in WinZip. Having this box checked when the files are extracted may corrupt the files. For more information, see Related Information: "Improper WinZip configuration may corrupt data".

Note:
On Unix, read-write-execute (dwrxr) permissions for both the Headers folder, and the INFO folder within it are necessary to edit the tigera_1999.def and tigers_1999.def files.

Related Information