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?
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.
Article ID:000005317
- ArcMap 8 x
- Legacy Products
Get help from ArcGIS experts
Download the Esri Support App
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback