If you are running on Windows, or have access to a system running Windows, you can use the Auxiliary File Editor to create a User Auxiliary file. The editor comes on separate installation media with your GeoTAX shipment. For more information on using the Auxiliary File Editor, see the Auxiliary File Editor User's Guide.
If you do not have an available system running Windows, you need to use your own editor to create a file in the proper layout.
The following table describes the User Auxiliary file layout. Sort records in ascending order for the ZIP Code, street name, street type, directional, and low house range; and descending order for high house range. This sorting minimizes the time required for street-level matching. The User Auxiliary file has a block size of 8K, a key length of 47 bytes, and a record length of 800 bytes. There is a sample file SEQAUX in your GeoTAX data directory created when you installed GeoTAX.
Copy the User Auxiliary file to %G1GTX%\data\. The filename needs to be SEQAUX.ASC. If you use a different name, you will need to edit %G1GTX%\bin\MAKEAUX.BAT and change the filename. Note, if GeoTAX is reinstalled, this change will be lost.
|
Position |
Field Name |
Description |
Length |
|---|---|---|---|
|
Input Key Area (Must be unique) |
|||
|
1-5 |
G1GTAUX-ZIP-CODE |
ZIP Code. |
5 |
|
6-35 |
G1GTAUX-STREET-NAME |
Street name. |
30 |
|
36-39 |
G1GTAUX-STREET-TYPE |
Street type. |
4 |
|
40-41 |
G1GTAUX-PRE-DIR |
Pre-directional. |
2 |
|
42-43 |
G1GTAUX-POST-DIR |
Post-directional. |
2 |
|
44-47 |
G1GTAUX-SEQ |
Sequence number. Range is 0001 - 9999. When there is a change in the data in columns 1-43, the sequence number should restart at 0001. |
4 |
|
Output Area |
|||
|
48-58 |
G1GTAUX-OUTPUT-RANGE-FROM |
First number in the house number range (right adjusted, blank-filled). |
11 |
|
59-69 |
G1GTAUX-OUTPUT-RANGE-TO |
Last number in the house number range (right adjusted, blank-filled). |
11 |
|
70 |
G1GTAUX-OUTPUT-ODD-EVEN |
Odd/Even switch. O Odd E Even |
1 |
|
71 |
G1GTAUX-OUTPUT-ASC-DESC |
Ascending or descending order. A Ascending D Descending |
1 |
|
72 |
Reserved |
|
|
|
73-74 |
G1GTAUX-STATE-CODE |
FIPS State code. |
2 |
|
75-77 |
G1GTAUX-COUNTY-CODE |
FIPS County code. |
3 |
|
78-83 |
G1GTAUX-CENSUS-TRACT |
6-digit Census Tract number. |
6 |
|
84 |
G1GTAUX-BLOCK-GROUP |
1-digit Block Group. |
1 |
|
85-92 |
Reserved |
|
8 |
|
93-94 |
G1GTAUX-STATE-ABBV |
USPS state abbreviation. |
2 |
|
95-119 |
G1GTAUX-COUNTY-NAME |
County name. |
25 |
|
120-124 |
G1GTAUX-MCD-CODE |
5-digit MCD code. |
5 |
|
125-164 |
G1GTAUX-MCD-NAME |
MCD name. |
40 |
|
165-168 |
G1GTAUX-MSA-CODE |
4-digit MSA Code. |
4 |
|
169-218 |
G1GTAUX-MSA-NAME |
MSA Name. |
50 |
|
219-223 |
G1GTAUX-PLACE-CODE |
5-digit Place Code. |
5 |
|
224-263 |
G1GTAUX-PLACE-NAME |
Place name. |
40 |
|
264-265 |
G1GTAUX-PLACE-CLASS-CODE |
2-digit Place Class Code |
2 |
|
266 |
G1GTAUX-PLACE-INC-FLAG |
Place incorporation flag: 0 Unincorporated 1 Incorporated |
1 |
|
267-273 |
G1GTAUX-PLACE-LASTANNEXED |
Place last annexed date, in the format MM/YYYY. |
7 |
|
274-280 |
G1GTAUX-PLACE-LASTUPDATED |
Place last updated date, in the format MM/YYYY. |
7 |
|
281-287 |
G1GTAUX-LASTVERIFIED |
Place last verified date, in the format MM/YYYY. |
7 |
|
288-296 |
G1GTAUX-PLACE-GNIS |
GNIS code. |
9 |
|
297-500 |
Reserved |
|
204 |
|
501-800 |
G1GTAUX-AUX-AREA |
User-defined data. |
300 |
To complete the remaining steps necessary to match to the User Auxiliary, see User Auxiliary File.