Creating a User-Defined Auxiliary File
To enter data in a user-defined auxiliary file, you can use your own editor or data entry program. If you are running on Windows, you can use the Auxiliary File Editor available on the GeoTAX Utilities CD. The GeoTAX Utilities CD can be downloaded from the www.g1.com/Support web site. Select the GeoTAX product page; the utilities download and document links are provided on the Subcomponents panel.
Sort the records by ascending ZIP Code, street name, street type, directional, low house range, and descending high house range to minimize the time required to street-level match.
The auxiliary file has a block size of 8K, key length of 47 bytes, and record length of 800 bytes. The sample file SEQAUX illustrates the layout of the file.
The following table describes the layout of the auxiliary file. After you create a file with this layout, install the file using Spectrum Enterprise Tax database load utility. For instructions, see the Spectrum Technology Platform Installation Guide.
|
Position |
Field Name |
Description |
Length |
|---|---|---|---|
|
Input Key Area (Must be Unique) |
|||
|
1-5 |
G1GTAUX-ZIP-CODE |
ZIP Code |
5 |
|
6-35 |
G1GTAUX-STREETNAME |
Street name |
30 |
|
36-39 |
G1GTAUX-STREET-TYPE |
Street type |
4 |
|
40-41 |
G1GTAUX-PRE-DIR |
Predirectional |
2 |
|
42-43 |
G1GTAUX-POST-DIR |
Postdirectional |
2 |
|
44-47 |
G1GTAUX-SEQ |
Sequence number, from 0001-9999 |
4 |
|
Output Area |
|||
|
48-58 |
G1GTAUX-OUTPUTRANGE-FROM |
First number in the house number range (right adjusted, blankfilled) |
11 |
|
59-69 |
G1GTAUX-OUTPUTRANGE-TO |
Last number in the house number range (right adjusted, blankfilled) |
11 |
|
70 |
G1GTAUX-OUTPUTODD-EVEN |
|
1 |
|
71 |
G1GTAUX-OUTPUTASC-DESC |
|
1 |
|
72 |
Reserved |
||
|
73-74 |
G1GTAUX-STATE-CODE |
FIPS State Code |
2,0 |
|
75-77 |
G1GTAUX-COUNTYCODE |
FIPS County Code |
3,0 |
|
78-83 |
G1GTAUX-CENSUSTRACT |
6-digit Census Tract number |
6,0 |
|
84 |
G1GTAUX-BLOCKGROUP |
1-digit Block Group |
1 |
|
85-92 |
Reserved |
8 |
|
|
93-94 |
G1GTAUX-STATE-ABBV |
USPS state abbreviation |
2 |
|
95-119 |
G1GTAUX-COUNTYNAME |
County name |
25 |
|
120-124 |
G1GTAUX-MCD-CODE |
5-digit MCD Code |
5,0 |
|
125-164 |
G1GTAUX-MCD-NAME |
MCD Name |
40 |
|
165-168 |
G1GTAUX-MSA-CODE |
4-digit MSA Code |
4,0 |
|
169-218 |
G1GTAUX-MSA-NAME |
MSA Name |
50 |
|
219-223 |
G1GTAUX-PLACE-CODE |
5-digit Place Code |
5,0 |
|
224-263 |
G1GTAUX-PLACENAME |
Place Name |
40 |
|
264-265 |
G1GTAUX-PLACECLASS-CODE |
2-digit Place Class Code |
2 |
|
266 |
G1GTAUX-PLACE-INCFLAG |
|
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-PLACE-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 |