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

  • O = Odd
  • E = Even

1

71

G1GTAUX-OUTPUTASC-DESC

  • A = Ascending
  • D = Descending

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

  • U - Unincorporated
  • I - 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-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