User Auxiliary file layout - GeoTAX_Premium - 7 - 7.7

GeoTAX Premium for Windows, UNIX/Linux, and z/OS

Product type
Software
Portfolio
Verify
Product family
Geo Addressing
Product
GeoTAX Premium
Version
7.7
Language
English
Product name
GeoTAX Premium
Title
GeoTAX Premium for Windows, UNIX/Linux, and z/OS
Copyright
2023
First publish date
1998
ft:lastEdition
2023-10-19
ft:lastPublication
2023-10-19T16:49:54.924301

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.