ALMI-US 5.0 Update File Layouts

January 7, 2004

Pulled from July 9, 2003 *ALMI-US and MAGE 5.0 Data Definition SADD* and
October 3, 2003 *Addendum to ALMI, ALMI-US, and HTEdb Version 5.0 SADDs*
(internal HTE document).

Contents

[1 MAFUF 2](#mafuf)

[2 DSMDUF and CCA File 9](#dsmduf-and-cca-file)

[3 GQUF 14](#gquf)

[4 ATUF 18](#atuf)

[4.1 ATU1 20](#atu1)

[4.2 ATU1_Dup 24](#atu1_dup)

[4.3 ATU1G 25](#atu1g)

[4.4 ATU2 29](#atu2)

[4.5 ATU2G 30](#atu2g)

[4.6 ATU4 32](#atu4)

[4.7 ATU5 35](#atu5)

[4.8 ATU7 36](#atu7)

[4.9 ATU7_Dup 39](#atu7_dup)

[4.10 ATUBT 39](#atubt)

[5 Activity Code Information 41](#activity-code-information)

Tables

[Table 1 MAF Update File 2](#__RefHeading___Toc61233877)

[Table 2 DSMD Update File 9](#__RefHeading___Toc61233878)

[Table 3 GQ Update File -- Includes New Special Place State + ID
Specification 14](#__RefHeading___Toc61233879)

[Table 4 ATUF Version Numbers 18](#__RefHeading___Toc61233880)

[Table 5 ATU1 20](#__RefHeading___Toc61233881)

[Table 6 ATU1_Dup 24](#__RefHeading___Toc61233882)

[Table 7 ATU1G 25](#__RefHeading___Toc61233883)

[Table 8 ATU2 29](#__RefHeading___Toc61233884)

[Table 9 ATU2G 30](#__RefHeading___Toc61233885)

[Table 10 ATU4 33](#__RefHeading___Toc61233886)

[Table 11 ATU5 35](#__RefHeading___Toc61233887)

[Table 12 ATU7 36](#__RefHeading___Toc61233888)

[Table 13 ATU7_Dup 39](#__RefHeading___Toc61233889)

[Table 14 ALMI TIGER Update File ATUBT 39](#__RefHeading___Toc61233890)

[Table 15 Activity Codes 41](#__RefHeading___Toc61233891)

[Table 16 Activity Code Conversions for MAFUF, DSMDUF, GQUF, and ATU7
41](#__RefHeading___Toc61233892)

# MAFUF

Note:

-   The MAFUF contains only non-NHIS addresses. Therefore, the Data
    Source column refers exclusively to the Maf.dbf and Extmaf.dbf
    tables.

-   A city-style address consists of a house number and street name; it
    may also include a within-structure designation (for example,
    apartment number, or lot number in a trailer park).

-   A non city-style address consists of something other than a house
    number, street name, and within-structure designation, such as a
    rural route number and box number or a post office box number.

[]{#__RefHeading___Toc61233877 .anchor}Table 1 MAF Update File

+---------+-----+-----+---------------------+-------------------------+
| Field   | Po  | Len | Description         | Data Source             |
| Name    | sit | gth |                     |                         |
|         | ion |     |                     |                         |
+=========+=====+=====+=====================+=========================+
| MAF     | 1-1 | 1   | Activity/action     | Maf.ACTION_CD; Refer to |
| Action  |     |     | code: A, C, D, M,   | table [Activity Code    |
| Code    |     |     | N, V, W; Refer to   | Conversions for MAFUF,  |
|         |     |     | table [Activity     | DSMDUF, GQUF, and       |
|         |     |     | Codes](             | ATU7](#Activ            |
|         |     |     | #ActivityCodeTable) | ityCodeConversionTable) |
|         |     |     | for definitions     | for processing details  |
+---------+-----+-----+---------------------+-------------------------+
| MAF ID  | 2   | 13  | MAF identification  | Maf.MAF_ID; blank if    |
|         | -14 |     | code                | ACTION_CD = A           |
+---------+-----+-----+---------------------+-------------------------+
| Po      | 15  | 1   |                     | Y = Block number is     |
| tential | -15 |     |                     | approximate location    |
| Block   |     |     |                     |                         |
| Flag    |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Block   | 16  | 1   | 9 = 1990 Tabulation | Always set to T         |
| Number  | -16 |     |                     |                         |
| Type    |     |     | C = 2000 Collection |                         |
|         |     |     |                     |                         |
|         |     |     | Q = CQR             |                         |
|         |     |     |                     |                         |
|         |     |     | S = Special Census  |                         |
|         |     |     |                     |                         |
|         |     |     | T = 2000 Tabulation |                         |
|         |     |     |                     |                         |
|         |     |     | U = Current         |                         |
+---------+-----+-----+---------------------+-------------------------+
| FIPS    | 17  | 2   | Numeric, FIPS       | Maf.ST_CODE; if         |
| State   | -18 |     |                     | activity code = W,      |
|         |     |     |                     | populate from first two |
|         |     |     |                     | characters of           |
|         |     |     |                     | Extmaf.DATAVAL where    |
|         |     |     |                     | Extmaf.DATATYPE = "WCC" |
+---------+-----+-----+---------------------+-------------------------+
| FIPS    | 19  | 3   | Numeric, FIPS       | Maf.CNTY_CODE; if       |
| County  | -21 |     |                     | activity code = W,      |
|         |     |     |                     | populate from last      |
|         |     |     |                     | three characters of     |
|         |     |     |                     | Extmaf.DATAVAL where    |
|         |     |     |                     | Extmaf.DATATYPE = "WCC" |
+---------+-----+-----+---------------------+-------------------------+
| Census  | 22  | 4   | Tract number, basic | Maf.TRACTB; if activity |
| Tract   | -25 |     | part                | code = W, fill with     |
|         |     |     |                     | blanks                  |
+---------+-----+-----+---------------------+-------------------------+
| Census  | 26  | 2   | Tract number suffix | Maf.TRACTS; if activity |
| Tract   | -27 |     |                     | code = W, fill with     |
| Suffix  |     |     |                     | blanks                  |
+---------+-----+-----+---------------------+-------------------------+
| Block   | 28  | 5   | Block number, basic | Right-justify Maf.BLKB; |
|         | -32 |     | part                | if activity code = W,   |
|         |     |     |                     | fill with blank         |
+---------+-----+-----+---------------------+-------------------------+
| Block   | 33  | 1   | Block suffix, first | Maf.BLKS, first         |
| Suffix  | -33 |     | character           | character; always fill  |
| 1       |     |     |                     | with blank              |
+---------+-----+-----+---------------------+-------------------------+
| Block   | 34  | 1   | Block suffix,       | Maf.BLKS, second        |
| Suffix  | -34 |     | second character    | character; always fill  |
| 2       |     |     |                     | with blank              |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 35  | 2   | State where map     | Maf.ST_CODE; if         |
| Spot    | -36 |     | spot is geocoded    | activity code = W, fill |
| State   |     |     |                     | with blanks             |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 37  | 3   | County where map    | Maf.CNTY_CODE; if       |
| Spot    | -39 |     | spot is geocoded    | activity code = W, fill |
| County  |     |     |                     | with blanks             |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 40  | 4   | Tract number, basic | Maf.TRACTB; if activity |
| Spot    | -43 |     | part, where map     | code = W, fill with     |
| Tract   |     |     | spot is geocoded    | blanks                  |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 44  | 2   | Tract number suffix | Maf.TRACTS; if activity |
| Spot    | -45 |     | where map spot is   | code = W, fill with     |
| Tract   |     |     | geocoded            | blanks                  |
| Suffix  |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 46  | 5   | Block number, basic | Right-justify Maf.BLKB; |
| Spot    | -50 |     | part, where map     | if activity code = W,   |
| Block   |     |     | spot is geocoded    | fill with blanks        |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 51  | 1   | Block suffix where  | Maf.BLKS, first         |
| Spot    | -51 |     | map spot is         | character; if activity  |
| Block   |     |     | geocoded            | code = W, fill with     |
| Suffix  |     |     |                     | blanks                  |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 52  | 4   | Numeric             | Right-justify           |
| Spot    | -55 |     |                     | Maf.MAP_SPOTB; if       |
| Number  |     |     |                     | activity code = W, fill |
|         |     |     |                     | with blanks             |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 56  | 1   | Alphabetic          | Maf.MAP_SPOTS; if       |
| Spot    | -56 |     |                     | activity code = W, fill |
| Suffix  |     |     |                     | with blanks             |
+---------+-----+-----+---------------------+-------------------------+
| Non     | 57  | 1   | Indicates if non    | Maf.NCMAIL; if NCMAIL   |
| cit     | -57 |     | city-style address  | is not Y, set to N.     |
| y-style |     |     | is used for mailing |                         |
| Mail    |     |     | address;            |                         |
| Flag    |     |     |                     |                         |
|         |     |     | Y = NCS address is  |                         |
|         |     |     | used for delivering |                         |
|         |     |     | mail                |                         |
|         |     |     |                     |                         |
|         |     |     | N = NCS address is  |                         |
|         |     |     | used for location   |                         |
|         |     |     | address only, or    |                         |
|         |     |     | NCS address is      |                         |
|         |     |     | empty               |                         |
+---------+-----+-----+---------------------+-------------------------+
| Cit     | 58  | 1   | Indicates if        | Always set to Y because |
| y-style | -58 |     | city-style mailing  | city-style mailing      |
| Mailing |     |     | address is broken   | address is always       |
| Address |     |     | down into separate  | broken into three       |
| (CSMA)  |     |     | fields: house       | separate fields in      |
| Fielded |     |     | number, street      | MAFUF (next three       |
| Flag    |     |     | name,               | fields in layout)       |
|         |     |     | within-structure    |                         |
|         |     |     | designation         |                         |
+---------+-----+-----+---------------------+-------------------------+
| CSMA    | 59  | 10  |                     | Maf.HOUSE_NUMM + " " +  |
| House   | -68 |     |                     | HOUSE_SFXM              |
| Number  |     |     |                     |                         |
|         |     |     |                     | Trim blanks before      |
|         |     |     |                     | concatenating values.   |
+---------+-----+-----+---------------------+-------------------------+
| CSMA    | 69- | 43  |                     | Maf.DIR_PFXM + " " +    |
| Street  | 111 |     |                     | STR_TYPFXM + " " +      |
| Name    |     |     |                     | STR_NAMEM + " " +       |
|         |     |     |                     | STR_TYPEM + " " +       |
|         |     |     |                     | DIRM + " " + EXTM       |
|         |     |     |                     |                         |
|         |     |     |                     | Only insert space       |
|         |     |     |                     | between non-empty       |
|         |     |     |                     | fields.                 |
|         |     |     |                     |                         |
|         |     |     |                     | If Maf.STR_NAMEM =      |
|         |     |     |                     | "Unnamed", "(Unnamed)", |
|         |     |     |                     | or "Unrd", fill with    |
|         |     |     |                     | blanks                  |
+---------+-----+-----+---------------------+-------------------------+
| CSMA    | 1   | 16  | Unit designation,   | Maf.APT_UNITM           |
| Wi      | 12- |     | e.g., Apt 12, Ste   |                         |
| thin-st | 127 |     | 100                 |                         |
| ructure |     |     |                     |                         |
| Desi    |     |     |                     |                         |
| gnation |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| CSMA    | 1   | 5   |                     | Maf.ZIPM                |
| ZIP     | 28- |     |                     |                         |
|         | 132 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Cit     | 1   | 1   | Indicates if        | Always set to Y because |
| y-style | 33- |     | city-style location | city-style location     |
| L       | 133 |     | address is broken   | address is always       |
| ocation |     |     | down into separate  | broken into three       |
| Address |     |     | fields: house       | separate fields in      |
| (CSLA)  |     |     | number, street      | MAFUF (next three       |
| Fielded |     |     | name, within-       | fields in layout).      |
| Flag    |     |     | structure           |                         |
|         |     |     | designation         |                         |
+---------+-----+-----+---------------------+-------------------------+
| CSLA    | 1   | 10  |                     | Maf.HOUSE_NUM + " " +   |
| House   | 34- |     |                     | HOUSE_SFX               |
| Number  | 143 |     |                     |                         |
|         |     |     |                     | Trim blanks before      |
|         |     |     |                     | concatenating values.   |
+---------+-----+-----+---------------------+-------------------------+
| CSLA    | 1   | 43  |                     | Maf.DIR_PFX + " " +     |
| Street  | 44- |     |                     | STR_TYPFX + " " +       |
| Name    | 186 |     |                     | STR_NAME + " " +        |
|         |     |     |                     | STR_TYPE + " " + DIR +  |
|         |     |     |                     | " " + EXT               |
|         |     |     |                     |                         |
|         |     |     |                     | Insert space only       |
|         |     |     |                     | between non-empty       |
|         |     |     |                     | fields.                 |
|         |     |     |                     |                         |
|         |     |     |                     | If Extmaf.DATAVAL = 1   |
|         |     |     |                     | where Extmaf.DATATYPE = |
|         |     |     |                     | "LSU" or STR_NAME =     |
|         |     |     |                     | "Unnamed", "(Unnamed)", |
|         |     |     |                     | or "Unrd", fill with    |
|         |     |     |                     | blanks.                 |
+---------+-----+-----+---------------------+-------------------------+
| CSLA    | 1   | 16  | Unit designation,   | Maf.APT_UNIT            |
| Wi      | 87- |     | e.g., Apt 12, Ste   |                         |
| thin-st | 202 |     | 100                 |                         |
| ructure |     |     |                     |                         |
| Desi    |     |     |                     |                         |
| gnation |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| CSLA    | 2   | 5   |                     | Maf.ZIP                 |
| ZIP     | 03- |     |                     |                         |
|         | 207 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Non     | 2   | 27  |                     | Maf.RR_DESC + " " +     |
| cit     | 08- |     |                     | RR_ID + " " + BX_DESC + |
| y-style | 234 |     |                     | " " + BX_ID             |
| Address |     |     |                     |                         |
|         |     |     |                     | Trim values of blanks   |
|         |     |     |                     | before concatenating    |
|         |     |     |                     | them.                   |
|         |     |     |                     |                         |
|         |     |     |                     | Insert space only       |
|         |     |     |                     | between non-empty       |
|         |     |     |                     | fields.                 |
+---------+-----+-----+---------------------+-------------------------+
| Non     | 2   | 5   |                     | Maf.NCZIP_CODE          |
| cit     | 35- |     |                     |                         |
| y-style | 239 |     |                     |                         |
| ZIP     |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| L       | 2   | 100 | Physical location   | Maf.PHYS_LOC            |
| ocation | 40- |     | description of      |                         |
| Desc    | 339 |     | house/address       |                         |
| ription |     |     |                     |                         |
|         |     |     | Note: Maf.PHYS_LOC  |                         |
|         |     |     | is 99 characters    |                         |
|         |     |     | long, but MAFUF     |                         |
|         |     |     | Location            |                         |
|         |     |     | Description is 100  |                         |
|         |     |     | characters long.    |                         |
+---------+-----+-----+---------------------+-------------------------+
| Conso   | 3   | 4   |                     | Fill with blanks.       |
| lidated | 40- |     |                     |                         |
| City    | 343 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| FIPS    | 3   | 5   | FIPS place code     | Maf.PLACE               |
| Place   | 44- |     |                     |                         |
|         | 348 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| FIPS    | 3   | 5   | FIPS MCD code       | Maf.MCD                 |
| County  | 49- |     |                     |                         |
| Subd    | 353 |     |                     |                         |
| ivision |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| FIPS    | 3   | 5   | FIPS AIANNH code    | Maf.AIANA               |
| AIANNH  | 54- |     |                     |                         |
|         | 358 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Trust   | 3   | 1   | American Indian /   | Blank                   |
| Land    | 59- |     | Hawaiian Home Land  |                         |
|         | 359 |     | Trust Land          |                         |
|         |     |     | Indicator           |                         |
+---------+-----+-----+---------------------+-------------------------+
| O       | 3   | 20  | Householder name    | Maf.RES_NAME            |
| ccupant | 60- |     |                     |                         |
| Name    | 379 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Phone   | 3   | 10  | Householder phone   | Maf.RES_PHONE           |
| Number  | 80- |     | number              |                         |
|         | 389 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Phone   | 3   | 5   | Householder phone   | Blank                   |
| Number  | 90- |     | number extension    |                         |
| Ex      | 394 |     |                     |                         |
| tension |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| MAF     | 3   | 2   | Indicates the       | MAGE type code in MAGE  |
| Source  | 95- |     | operation during    | file name = MAF source  |
| Code    | 396 |     | which the address   | code:                   |
|         |     |     | record was updated  |                         |
|         |     |     |                     | A (ACS TOI) = 12        |
|         |     |     |                     |                         |
|         |     |     |                     | C (Listing Check) = 62  |
|         |     |     |                     |                         |
|         |     |     |                     | L (Listing) = 61        |
|         |     |     |                     |                         |
|         |     |     |                     | S (ALMI Standalone) =   |
|         |     |     |                     | 63                      |
+---------+-----+-----+---------------------+-------------------------+
| (Re     | 3   | 2   | (Reserved)          | Blank                   |
| served) | 97- |     |                     |                         |
|         | 398 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| M       | 3   | 1   | Indicates whether   | Refer to requirement    |
| ultiple | 99- |     | the tie-breaker     | ***HU-UF-COMMON-ADDR-1: |
| Tran    | 399 |     | rule was applied to | Include One Record per  |
| saction |     |     | this record; if two | MAF ID in the MAFUF,    |
| Tie-    |     |     | or more address     | DSMDUF, and GQUF*** in  |
| breaker |     |     | records have the    | the *Addendum to ALMI   |
| Rules   |     |     | same MAF ID, the    | and ALMI-US Version 5.0 |
| Applied |     |     | tie-breaker rules   | SRADs* for processing   |
| Flag    |     |     | may need to be      | details                 |
|         |     |     | applied             |                         |
|         |     |     |                     | Y = Tie-breaker rules   |
|         |     |     |                     | were applied            |
|         |     |     |                     |                         |
|         |     |     |                     | Blank = Tie-breaker     |
|         |     |     |                     | rules were not applied  |
+---------+-----+-----+---------------------+-------------------------+
| Unit    | 4   | 2   |                     | Maf.UNIT_STAT           |
| Status  | 00- |     |                     |                         |
|         | 401 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Resi    | 4   | 1   | Indicates whether   | Maf.LOC_TYPE =          |
| dential | 02- |     | address record is   | Residential Status:     |
| Status  | 402 |     | residential or      |                         |
|         |     |     | nonresidential      | N, S = 1 (residential)  |
|         |     |     |                     |                         |
|         |     |     |                     | C = 2 (nonresidential)  |
|         |     |     |                     |                         |
|         |     |     |                     | Other = 1 (residential) |
+---------+-----+-----+---------------------+-------------------------+
| GQ/HU   | 4   | 1   | Indicates whether   | Maf.LOC_TYPE = GQ/HU    |
| Flag    | 03- |     | address record is a | Flag:                   |
|         | 403 |     | group quarters or   |                         |
|         |     |     | housing unit        | C, N = 0 (housing unit) |
|         |     |     |                     |                         |
|         |     |     |                     | S = 2 (group quarters)  |
|         |     |     |                     |                         |
|         |     |     |                     | Other = 0 (housing      |
|         |     |     |                     | unit)                   |
+---------+-----+-----+---------------------+-------------------------+
| When    | 4   | 1   | Indicates whether   | Maf.YEAR_BUILT; if      |
| Built   | 04- |     | unit was built      | YEAR_BUILT = N, then    |
| Flag    | 404 |     | before or after the | blank, where N means    |
|         |     |     | last decennial      | not needed              |
|         |     |     | census              |                         |
+---------+-----+-----+---------------------+-------------------------+
| Housing | 4   | 1   | Indicates whether   | Maf.TRAILER             |
| Unit    | 05- |     | unit is a           |                         |
| Type    | 405 |     | trailer/mobile home |                         |
+---------+-----+-----+---------------------+-------------------------+
| C       | 4   | 13  | Temporary MAF ID    | Maf.MAF_ID when         |
| ustomer | 06- |     | for added unit      | ACTION_CD = A; else     |
| Pro     | 418 |     |                     | blank                   |
| cessing |     |     |                     |                         |
| ID      |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Su      | 4   | 13  | If address record   | First 13 characters of  |
| rviving | 19- |     | was flagged as a    | Extmaf.DATAVAL where    |
| MAF ID  | 431 |     | duplicate or merge, | Extmaf.DATATYPE = "SMD" |
|         |     |     | this is the         |                         |
|         |     |     | surviving unit that |                         |
|         |     |     | the address record  |                         |
|         |     |     | is linked to        |                         |
+---------+-----+-----+---------------------+-------------------------+
| Apt     | 4   | 60  | Building name       | Extmaf.DATAVAL where    |
| C       | 32- |     |                     | Extmaf.DATATYPE = "BCN" |
| omplex/ | 491 |     |                     |                         |
| Subdi   |     |     |                     |                         |
| vision/ |     |     |                     |                         |
| Mobile  |     |     |                     |                         |
| Home    |     |     |                     |                         |
| Park    |     |     |                     |                         |
| Name    |     |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 4   | 9   |                     | Blank if ACTION_CD = W  |
| Spot    | 92- |     |                     | or first character of   |
| L       | 500 |     |                     | LAT1 is a digit (i.e.,  |
| atitude |     |     |                     | not "+" or "-";         |
|         |     |     |                     | indicates non-spotted   |
|         |     |     |                     | unit); else Maf.LAT1    |
+---------+-----+-----+---------------------+-------------------------+
| Map     | 5   | 10  |                     | Blank if ACTION_CD = W  |
| Spot    | 01- |     |                     | or first character of   |
| Lo      | 510 |     |                     | LONG1 is a digit (i.e., |
| ngitude |     |     |                     | not "+" or "-";         |
|         |     |     |                     | indicates non-spotted   |
|         |     |     |                     | unit); else Maf.LONG1   |
+---------+-----+-----+---------------------+-------------------------+
| (Re     | 5   | 28  | Reserved for future | Blank                   |
| served) | 11- |     | use                 |                         |
|         | 538 |     |                     |                         |
+---------+-----+-----+---------------------+-------------------------+

# DSMDUF and CCA File

Note: The DSMDUF contains both NHIS and non-NHIS addresses. Therefore,
the Data Source column refers to the Address.dbf table, which implies
that data is retrieved from both the Maf.dbf and Nhis.dbf tables.

As in ALMI-US 4.x, the CCA file will use the same file layout as the
DSMDUF.

[]{#__RefHeading___Toc61233878 .anchor}Table 2 DSMD Update File

+-----------+-----+----+-------------+-------------------------------+
| Field     | Po  | Le | Description | Data Source                   |
| Name      | sit | ng |             |                               |
|           | ion | th |             |                               |
+===========+=====+====+=============+===============================+
| MAF ID    | 1   | 13 | MAF         | Address.MAF_ID; blank if      |
|           | -13 |    | ide         | ACTION_CD = A                 |
|           |     |    | ntification |                               |
|           |     |    | code        |                               |
+-----------+-----+----+-------------+-------------------------------+
| Temporary | 14  | 13 | Temporary   | Address.MAF_ID when ACTION_CD |
| MAF ID    | -26 |    | ID, created | = A; else blank               |
|           |     |    | by ALMI     |                               |
+-----------+-----+----+-------------+-------------------------------+
| MAF       | 27  | 2  | Indicates   | MAGE type code in MAGE file   |
| Source    | -28 |    | operation   | name = MAF source code:       |
| Code      |     |    | where unit  |                               |
|           |     |    | was         | A (ACS TOI) = 12 (N/A for     |
|           |     |    | modified    | DSMDUF)                       |
|           |     |    |             |                               |
|           |     |    |             | C (Listing Check) = 62        |
|           |     |    |             |                               |
|           |     |    |             | L (Listing) = 61              |
|           |     |    |             |                               |
|           |     |    |             | S (ALMI Standalone) = 63      |
+-----------+-----+----+-------------+-------------------------------+
| FIPS      | 29  | 2  | State where | Address.ST_CODE; if activity  |
| State     | -30 |    | ALMI user   | code = W, populate from first |
| Code      |     |    | believes    | two characters of             |
|           |     |    | unit is     | Extad.DATAVAL where           |
|           |     |    | geocoded    | Extad.DATATYPE = "WCC"        |
+-----------+-----+----+-------------+-------------------------------+
| FIPS      | 31  | 3  | County      | Address.CNTY_CODE; if         |
| County    | -33 |    | where ALMI  | activity code = W, populate   |
| Code      |     |    | user        | from last three characters of |
|           |     |    | believes    | Extad.DATAVAL where           |
|           |     |    | unit is     | Extad.DATATYPE = "WCC"        |
|           |     |    | geocoded    |                               |
+-----------+-----+----+-------------+-------------------------------+
| Tract     | 34  | 6  | Census      | Blank if ACTION_CD = W; else  |
|           | -39 |    | tract       | Address.TRACTB + TRACTS       |
|           |     |    | number,     |                               |
|           |     |    | basic       |                               |
|           |     |    | part +      |                               |
|           |     |    | suffix      |                               |
+-----------+-----+----+-------------+-------------------------------+
| Block     | 40  | 6  | Block       | Blank if ACTION_CD = W; else  |
|           | -45 |    | number,     | Address.BLKB + BLKS           |
|           |     |    | basic       |                               |
|           |     |    | part +      |                               |
|           |     |    | suffix      |                               |
+-----------+-----+----+-------------+-------------------------------+
| NHIS Flag | 46  | 1  | Indicates   | Address.ADDR_SRC              |
|           | -46 |    | whether     |                               |
|           |     |    | address is  |                               |
|           |     |    | NHIS        |                               |
+-----------+-----+----+-------------+-------------------------------+
| Latitude  | 47  | 9  | Latitude of | Blank if ACTION_CD = W or     |
|           | -55 |    | map spot    | first character of LAT1 is a  |
|           |     |    |             | digit (i.e., not "+" or "-";  |
|           |     |    |             | indicates non-spotted unit);  |
|           |     |    |             | else Address.LAT1             |
+-----------+-----+----+-------------+-------------------------------+
| Longitude | 56  | 10 | Longitude   | Blank if ACTION_CD = W or     |
|           | -65 |    | of map spot | first character of LONG1 is a |
|           |     |    |             | digit (i.e., not "+" or "-";  |
|           |     |    |             | indicates non-spotted unit);  |
|           |     |    |             | else Address.LONG1            |
+-----------+-----+----+-------------+-------------------------------+
| Map Spot  | 66  | 5  |             | Blank if ACTION_CD = W; else  |
| ID        | -70 |    |             | Address.MAP_SPOTB + MAP_SPOTS |
+-----------+-----+----+-------------+-------------------------------+
| House     | 71  | 10 | Location    | Address.HOUSE_NUM             |
| Number    | -80 |    | house       |                               |
|           |     |    | number      |                               |
+-----------+-----+----+-------------+-------------------------------+
| House     | 81  | 3  | Location    | Address.HOUSE_SFX             |
| Number    | -83 |    | house       |                               |
| Suffix    |     |    | number      |                               |
|           |     |    | suffix      |                               |
+-----------+-----+----+-------------+-------------------------------+
| Street    | 84  | 2  | Location    | Blank if Extmaf.DATAVAL = 1   |
| Type      | -85 |    | address     | where Extmaf.DATATYPE = "LSU" |
| Di        |     |    |             | or STR_NAME = "Unnamed",      |
| rectional |     |    |             | "(Unnamed)", or "Unrd"; else  |
| Prefix    |     |    |             | Address.DIR_PFX               |
+-----------+-----+----+-------------+-------------------------------+
| Street    | 86  | 4  | Location    | Blank if Extmaf.DATAVAL = 1   |
| Type      | -89 |    | address     | where Extmaf.DATATYPE = "LSU" |
| Prefix    |     |    |             | or STR_NAME = "Unnamed",      |
|           |     |    |             | "(Unnamed)", or "Unrd"; else  |
|           |     |    |             | Address.STR_TYPFX             |
+-----------+-----+----+-------------+-------------------------------+
| Street    | 90- | 28 | Location    | Blank if Extmaf.DATAVAL = 1   |
| Name      | 117 |    | address     | where Extmaf.DATATYPE = "LSU" |
|           |     |    |             | or STR_NAME = "Unnamed",      |
|           |     |    |             | "(Unnamed)", or "Unrd"; else  |
|           |     |    |             | Address.STR_NAME              |
+-----------+-----+----+-------------+-------------------------------+
| Street    | 1   | 4  | Location    | Blank if Extmaf.DATAVAL = 1   |
| Name      | 18- |    | address     | where Extmaf.DATATYPE = "LSU" |
| Suffix    | 121 |    |             | or STR_NAME = "Unnamed",      |
| Type      |     |    |             | "(Unnamed)", or "Unrd"; else  |
|           |     |    |             | Address.STR_TYPE              |
+-----------+-----+----+-------------+-------------------------------+
| Street    | 1   | 2  | Location    | Blank if Extmaf.DATAVAL = 1   |
| Name      | 22- |    | address     | where Extmaf.DATATYPE = "LSU" |
| Suffix    | 123 |    |             | or STR_NAME = "Unnamed",      |
| Direction |     |    |             | "(Unnamed)", or "Unrd"; else  |
|           |     |    |             | Address.DIR                   |
+-----------+-----+----+-------------+-------------------------------+
| Street    | 1   | 3  | Location    | Blank if Extmaf.DATAVAL = 1   |
| Name      | 24- |    | address     | where Extmaf.DATATYPE = "LSU" |
| Extension | 126 |    |             | or STR_NAME = "Unnamed",      |
|           |     |    |             | "(Unnamed)", or "Unrd"; else  |
|           |     |    |             | Address.EXT                   |
+-----------+-----+----+-------------+-------------------------------+
| Unit      | 1   | 16 | Location    | Address.APT_UNIT              |
| De        | 27- |    | address     |                               |
| signation | 142 |    | apartment   |                               |
|           |     |    | number      |                               |
+-----------+-----+----+-------------+-------------------------------+
| ZIP Code  | 1   | 5  | Location    | Address.ZIP                   |
|           | 43- |    | address ZIP |                               |
|           | 147 |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Rural     | 1   | 4  |             | Address.RR_ID                 |
| Route ID  | 48- |    |             |                               |
|           | 151 |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Rural     | 1   | 4  |             | Address.RR_DESC               |
| Route     | 52- |    |             |                               |
| D         | 155 |    |             |                               |
| escriptor |     |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Box/PO    | 1   | 6  |             | Address.BX_DESC               |
| Box       | 56- |    |             |                               |
| D         | 161 |    |             |                               |
| escriptor |     |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Box/PO    | 1   | 10 |             | Address.BX_ID                 |
| Box ID    | 62- |    |             |                               |
|           | 171 |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Physical  | 1   | 99 |             | Address.PHYS_LOC              |
| Location  | 72- |    |             |                               |
| De        | 270 |    |             |                               |
| scription |     |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Ho        | 2   | 20 |             | Address.RES_NAME              |
| useholder | 71- |    |             |                               |
| Name      | 290 |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Re        | 2   | 1  | Indicates   | Address.LOC_TYPE =            |
| sidential | 91- |    | whether     | Residential Status:           |
| Status    | 291 |    | unit is     |                               |
|           |     |    | residential | N, S = 1 (residential)        |
|           |     |    | or          |                               |
|           |     |    | non         | C = 2 (nonresidential)        |
|           |     |    | residential |                               |
|           |     |    |             | Other = blank                 |
+-----------+-----+----+-------------+-------------------------------+
| Unit      | 2   | 2  |             | Address.UNIT_STAT; Refer to   |
| Status    | 92- |    |             | table [Activity Code          |
|           | 293 |    |             | Conversions for MAFUF,        |
|           |     |    |             | DSMDUF, GQUF, and             |
|           |     |    |             | ATU7](                        |
|           |     |    |             | #ActivityCodeConversionTable) |
|           |     |    |             | for processing details        |
+-----------+-----+----+-------------+-------------------------------+
| GQ/HU     | 2   | 1  | Indicates   | Refer to requirement          |
| Flag      | 94- |    | whether     | *HU-UF-COMMON-ADDR-5:         |
| (         | 294 |    | unit *was*  | Populate GQ/HU Flag Fields*   |
| original) |     |    | a GQ or     | in *Addendum to ALMI and      |
|           |     |    | housing     | ALMI-US Version 5.0 SRADs*    |
|           |     |    | unit        | for processing details        |
+-----------+-----+----+-------------+-------------------------------+
| GQ/HU     | 2   | 1  | Indicates   | Refer to requirement          |
| Flag      | 95- |    | whether     | *HU-UF-COMMON-ADDR-5:         |
| (current) | 295 |    | unit *is* a | Populate GQ/HU Flag Fields*   |
|           |     |    | GQ or       | in *Addendum to ALMI and      |
|           |     |    | housing     | ALMI-US Version 5.0 SRADs*    |
|           |     |    | unit        | for processing details        |
+-----------+-----+----+-------------+-------------------------------+
| Year      | 2   | 1  | Indicates   | Address.YEAR_BUILT            |
| Built     | 96- |    | whether     |                               |
|           | 296 |    | unit was    |                               |
|           |     |    | built       |                               |
|           |     |    | before or   |                               |
|           |     |    | after April |                               |
|           |     |    | 1, 2000     |                               |
+-----------+-----+----+-------------+-------------------------------+
| Trailer   | 2   | 1  | Indicates   | Address.TRAILER               |
|           | 97- |    | whether     |                               |
|           | 297 |    | unit is a   |                               |
|           |     |    | trailer or  |                               |
|           |     |    | mobile home |                               |
+-----------+-----+----+-------------+-------------------------------+
| DSMDUF    | 2   | 1  |             | Address.ACTION_CD; Refer to   |
| Activity  | 98- |    |             | table [Activity Code          |
| Code      | 298 |    |             | Conversions for MAFUF,        |
|           |     |    |             | DSMDUF, GQUF, and             |
|           |     |    |             | ATU7](                        |
|           |     |    |             | #ActivityCodeConversionTable) |
|           |     |    |             | for processing details        |
+-----------+-----+----+-------------+-------------------------------+
| MAFUF     | 2   | 1  |             | Address.ACTION_CD; Refer to   |
| Activity  | 99- |    |             | table [Activity Code          |
| Code      | 299 |    |             | Conversions for MAFUF,        |
|           |     |    |             | DSMDUF, GQUF, and             |
|           |     |    |             | ATU7](                        |
|           |     |    |             | #ActivityCodeConversionTable) |
|           |     |    |             | for processing details        |
+-----------+-----+----+-------------+-------------------------------+
| Building  | 3   | 60 |             | Extad.DATAVAL where           |
| Name      | 00- |    |             | Extad.DATATYPE = "BCN"        |
|           | 359 |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+
| Special   | 3   | 1  |             | Extad.DATAVAL where           |
| Place     | 60- | 00 |             | Extad.DATATYPE = "SPN"; if    |
| Name      | 459 |    |             | Extad.DATAVAL = 1 where       |
|           |     |    |             | Extad.DATATYPE = "SPU", then  |
|           |     |    |             | blank                         |
+-----------+-----+----+-------------+-------------------------------+
| GQ Name   | 4   | 1  |             | Extad.DATAVAL where           |
|           | 60- | 00 |             | Extad.DATATYPE = "GQN"; if    |
|           | 559 |    |             | Extad.DATAVAL = 1 where       |
|           |     |    |             | Extad.DATATYPE = "GQU", then  |
|           |     |    |             | blank                         |
+-----------+-----+----+-------------+-------------------------------+
| GQ Type   | 5   | 3  |             | Address.GQ_CD                 |
|           | 60- |    |             |                               |
|           | 562 |    |             |                               |
+-----------+-----+----+-------------+-------------------------------+

# GQUF

[]{#__RefHeading___Toc61233879 .anchor}Table 3 GQ Update File --
Includes New Special Place State + ID Specification

  ------------------------------------------------------------------------------------------
  Field Name    Position   Length   Description        Data Source
  ------------- ---------- -------- ------------------ -------------------------------------
  Activity Code 1-1        1                           Maf.ACTION_CD; Refer to table
                                                       [Activity Code Conversions for MAFUF,
                                                       DSMDUF, GQUF, and
                                                       ATU7](#ActivityCodeConversionTable)
                                                       for processing details

  MAF ID        2-14       13       MAF identification Maf.MAF_ID; blank if ACTION_CD = A
                                    code               

  Temporary MAF 15-27      13       Temporary ID,      Maf.MAF_ID when ACTION_CD = A; else
  ID                                created by ALMI    blank

  Surviving MAF 28-40      13       If address record  First 13 characters of Extmaf.DATAVAL
  ID                                was flagged as a   where Extmaf.DATATYPE = "SMD"
                                    duplicate or       
                                    merge, this is the 
                                    surviving unit     
                                    that the address   
                                    record is linked   
                                    to.                

  State Code    41-42      2        State where ALMI   Maf.ST_CODE; if ACTION_CD = W, first
                                    user believes unit two characters of Extmaf.DATAVAL
                                    is geocoded        where Extmaf.DATATYPE = "WCC"

  County Code   43-45      3        County where ALMI  Maf.CNTY_CODE; if ACTION_CD = W, last
                                    user believes unit three characters of Extmaf.DATAVAL
                                    is geocoded        where Extmaf.DATATYPE = "WCC"

  Tract         46-51      6        Census tract       Blank if ACTION_CD = W; else
                                    number, basic      Maf.TRACTB + TRACTS
                                    part + suffix      

  Block Code    52-57      6        Block number,      Blank if ACTION_CD = W; else
                                    basic part +       Maf.BLKB + BLKS
                                    suffix             

  Map Spot      58-61      4                           Blank if ACTION_CD = W; else
  Number                                               Maf.MAP_SPOTB

  Map Spot      62-62      1                           Blank if ACTION_CD = W; else
  Suffix                                               Maf.MAP_SPOTS

  Map Spot      63-71      9                           Blank if ACTION_CD = W or first
  Latitude                                             character of LAT1 is a digit (i.e.,
                                                       not "+" or "-"; indicates non-spotted
                                                       unit); else Maf.LAT1

  Map Spot      72-81      10                          Blank if ACTION_CD = W or first
  Longitude                                            character of LONG1 is a digit (i.e.,
                                                       not "+" or "-"; indicates non-spotted
                                                       unit); else Maf.LONG1

  GQ/HU Flag    82-82      1        Indicates whether  Refer to requirement
  (original)                        unit *was* a GQ or *HU-UF-COMMON-ADDR-5: Populate GQ/HU
                                    housing unit       Flag Fields* in *Addendum to ALMI and
                                                       ALMI-US Version 5.0 SRADs* for
                                                       processing details.

  GQ/HU Flag    83-83      1        Indicates whether  Refer to requirement
  (current)                         unit *is* a GQ or  *HU-UF-COMMON-ADDR-5: Populate GQ/HU
                                    housing unit       Flag Fields* in *Addendum to ALMI and
                                                       ALMI-US Version 5.0 SRADs* for
                                                       processing details.

  GQ Name       84-183     100                         Extmaf.DATAVAL where Extmaf.DATATYPE
                                                       = "GQN"; if Extmaf.DATAVAL = 1 where
                                                       Extmaf.DATATYPE = "GQU", then blank

  GQ Type Code  184-186    3                           Maf.GQ_CD

  GQ ID         187-190    4                           Extmaf.DATAVAL where Extmaf.DATATYPE
                                                       = "GQI"

  Special Place 191-290    100                         Extmaf.DATAVAL where Extmaf.DATATYPE
  Name                                                 = "SPN"; if Extmaf.DATAVAL = 1 where
                                                       Extmaf.DATATYPE = "SPU", then blank

  Special Place 291-298    8                           Extmaf.DATAVAL where Extmaf.DATATYPE
  State + SP ID                                        = "SPI"

  House Number  299-308    10       Location house     Maf.HOUSE_NUM
                                    number             

  House Number  309-311    3        Location house     Maf.HOUSE_SFX
  Suffix                            number suffix      

  Street Name   312-313    2        Location address   Blank if Extmaf.DATAVAL = 1 where
  Prefix                                               Extmaf.DATATYPE = "LSU" or STR_NAME =
  Direction                                            "Unnamed", "(Unnamed)", or "Unrd";
                                                       else Maf.DIR_PFX

  Street Name   314-317    4        Location address   Blank if Extmaf.DATAVAL = 1 where
  Prefix Type                                          Extmaf.DATATYPE = "LSU" or STR_NAME =
                                                       "Unnamed", "(Unnamed)", or "Unrd";
                                                       else Maf.STR_TYPFX

  Street Name   318-345    28       Location address   Blank if Extmaf.DATAVAL = 1 where
                                                       Extmaf.DATATYPE = "LSU" or STR_NAME =
                                                       "Unnamed", "(Unnamed)", or "Unrd";
                                                       else Maf.STR_NAME

  Street Name   346-349    4        Location address   Blank if Extmaf.DATAVAL = 1 where
  Suffix Type                                          Extmaf.DATATYPE = "LSU" or STR_NAME =
                                                       "Unnamed", "(Unnamed)", or "Unrd";
                                                       else Maf.STR_TYPE

  Street Name   350-351    2        Location address   Blank if Extmaf.DATAVAL = 1 where
  Suffix                                               Extmaf.DATATYPE = "LSU" or STR_NAME =
  Direction                                            "Unnamed", "(Unnamed)", or "Unrd";
                                                       else Maf.DIR

  Street Name   352-354    3        Location address   Blank if Extmaf.DATAVAL = 1 where
  Extension                                            Extmaf.DATATYPE = "LSU" or STR_NAME =
                                                       "Unnamed", "(Unnamed)", or "Unrd";
                                                       else Maf.EXT

  Unit          355-370    16       Location address   Maf.APT_UNIT
  Designation                       apartment number   

  City-Style    371-375    5        Location address   Maf.ZIP
  Address ZIP                       ZIP                
  Code                                                 

  Rural Route   376-379    4                           Maf.RR_DESC
  Descriptor                                           

  Rural Route   380-383    4                           Maf.RR_ID
  ID                                                   

  Box/PO Box    384-389    6                           Maf.BX_DESC
  Descriptor                                           

  Box/PO Box ID 390-399    10                          Maf.BX_ID

  Non           400-404    5                           Maf.NCZIP_CODE
  City-Style                                           
  Address ZIP                                          
  Code                                                 

  Location      405-503    99                          Maf.PHYS_LOC
  Description                                          

  Building Name 504-563    60                          Extmaf.DATAVAL where Extmaf.DATATYPE
                                                       = "BCN"

  NHIS Flag     564-564    1        Indicates whether  Maf.ADDR_SRC
                                    address is NHIS    

  Unit Status   565-566    2                           Maf.UNIT_STAT; Refer to table
                                                       [Activity Code Conversions for MAFUF,
                                                       DSMDUF, GQUF, and
                                                       ATU7](#ActivityCodeConversionTable)
                                                       for processing details.
  ------------------------------------------------------------------------------------------

# ATUF

ATUFs will contain longitude, latitude, and CFCC data for street
features and map spots, and street name data for street features in a
county. The street features and map spots will be those that have been
added, edited, or deleted. Map spots that have been moved or verified
will also be included in the ATUF. The following version numbers are
used to indicate the type of action taken against the linear feature or
map spot.

Note: Temporary TLIDs will be alphanumeric; permanent TLIDs are numeric
only.

[]{#__RefHeading___Toc61233880 .anchor}Table 4 ATUF Version Numbers

  -----------------------------------------------------------------------
  Version code  Description
  ------------- ---------------------------------------------------------
  4999          Deleted TIGER linear feature

  5001          New linear feature

  5002          Linear feature whose attributes were corrected, i.e.,
                name, CFCC

  5003          Linear feature whose geometry was corrected, i.e., the
                street was moved or reshaped (not supported in ALMI 5.0)

  5004          Linear feature whose attributes *and* geometry were
                corrected (not supported in ALMI 5.0)

  5040          Linear feature that was split into multiple segments (not
                supported in ALMI 5.0)

  6001          New map spot, added manually (converted from activity
                code by ALMI-US)

  6003          Moved map spot (converted from activity code by ALMI-US)

  6004          Updated map spot = any data may have been changed,
                including, but not limited to, latitude and longitude
                coordinates and geocoding (converted from activity code
                by ALMI-US)

  6005          Verified map spot = no data has been changed (converted
                from activity code by ALMI-US)

  7001          New linear feature, added using GPS (converted from
                version number 5001 by ALMI-US)

  8001          New map spot, added using GPS (converted from activity
                code by ALMI-US)
  -----------------------------------------------------------------------

Each ATUF consists of a set of formatted ASCII files:

-   ATU1 -- Line information

-   ATU1_Dup -- Duplicate TLIDs in ATU1

-   ATU2 -- Shape coordinates for ATU1

-   ATU1G -- Line information for features created using GPS

-   ATU2G -- Shape coordinates for ATU1G

-   ATU7 -- Point Exchange File (map spots)

-   ATU7_Dup -- Duplicate map spot IDs in ATU7

-   ATUBT -- Block Transaction File

The description of the ATUF structure includes the source of the data
and the business rules used to populate the fields for each file. The
field or combination of fields from the MAGE tables typically identifies
the source. The values for some fields are calculated by ALMI-US; the
simple calculations are included in the Data Source column and the more
complex calculations are described in the *ALMI-US 5.0 SADD*.

Files ATU4 (index between TLIDs and alternate feature names) and ATU5
(alternate feature names) are always empty in ALMI-US 5.0, so they will
not be included in the ATUF for 5.0.

## ATU1

All records from Feature.dbf with Version numbers 4999, 5001, or 5002,
blank FRTSTAMP, and blank TOTSTAMP are included in the ATU1 file. The
records that meet these criteria are TIGER linear features that were
deleted or updated, and linear features that were added manually by the
ALMI user.

[]{#__RefHeading___Toc61233881 .anchor}Table 5 ATU1

+---------+-----+-----+---------------------------+-------------------+
| Field   | Po  | Len | Description               | Data Source       |
| Name    | sit | gth |                           |                   |
|         | ion |     |                           |                   |
+=========+=====+=====+===========================+===================+
| ATU1    | 1-1 | 1   | Indicates ATUF file type  | 1                 |
+---------+-----+-----+---------------------------+-------------------+
| VERSION | 2-5 | 4   | Transaction code (ATUF    | Feature.VERSION   |
|         |     |     | version number): 4999,    |                   |
|         |     |     | 5001, and 5002 are the    |                   |
|         |     |     | only supported codes for  |                   |
|         |     |     | TIGER features and        |                   |
|         |     |     | manually added streets in |                   |
|         |     |     | ALMI 5.0                  |                   |
+---------+-----+-----+---------------------------+-------------------+
| TLID    | 6   | 10  | Permanent TIGER/Line ID   | Feature.TLID      |
|         | -15 |     | or Temporary TIGER/Line   |                   |
|         |     |     | ID created by ALMI to     |                   |
|         |     |     | contain RO ID + FR ID     |                   |
+---------+-----+-----+---------------------------+-------------------+
| SIDE1   | 16  | 1   | Single Side Segment Code  | Blank             |
|         | -16 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SOURCE  | 17  | 1   | Linear Segment Source     | Blank             |
|         | -17 |     | Code                      |                   |
+---------+-----+-----+---------------------------+-------------------+
| FEDIRP  | 18  | 2   | Feature Direction, Prefix | Feature.FEDIRP    |
|         | -19 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FENAME  | 20  | 30  | Feature Name              | Feature.FENAME    |
|         | -49 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FETYPE  | 50  | 4   | Feature Type              | Feature.FETYPE    |
|         | -53 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FEDIRS  | 54  | 2   | Feature Direction, Suffix | Feature.FEDIRS    |
|         | -55 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| CFCC    | 56  | 3   | Census Feature            | Feature.CFCC      |
|         | -58 |     | Classification Code       |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRADDL  | 59  | 11  | Start Address, Left       | Feature.FRADDL    |
|         | -69 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOADDL  | 70  | 11  | End Address, Left         | Feature.TOADDL    |
|         | -80 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRADDR  | 81  | 11  | Start Address, Right      | Feature.FRADDR    |
|         | -91 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOADDR  | 92- | 11  | End Address, Right        | Feature.TOADDR    |
|         | 102 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRIADDL | 1   | 1   | Start Imputed Address     | Blank             |
|         | 03- |     | Flag, Left                |                   |
|         | 103 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOIADDL | 1   | 1   | End Imputed Address Flag, | Blank             |
|         | 04- |     | Left                      |                   |
|         | 104 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRIADDR | 1   | 1   | Start Imputed Address     | Blank             |
|         | 05- |     | Flag, Right               |                   |
|         | 105 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOIADDR | 1   | 1   | End Imputed Address Flag, | Blank             |
|         | 06- |     | Left                      |                   |
|         | 106 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| ZIPL    | 1   | 5   | ZIP Code, Left            | Feature.ZIPL      |
|         | 07- |     |                           |                   |
|         | 111 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| ZIPR    | 1   | 5   | ZIP Code, Right           | Feature.ZIPR      |
|         | 12- |     |                           |                   |
|         | 116 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIANNHL | 1   | 5   | FIPS 55 Code (AIANNH      | Feature.AIANAL    |
|         | 17- |     | area) Current, Left       |                   |
|         | 121 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIANNHR | 1   | 5   | FIPS 55 Code (AIANNH      | Feature.AIANAR    |
|         | 22- |     | area) Current, Right      |                   |
|         | 126 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIA     | 1   | 1   | AIANNH Trust Land Flag    | Blank             |
| NNHTLIL | 27- |     | Current, Left             |                   |
|         | 127 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIA     | 1   | 1   | AIANNH Trust Land Flag    | Blank             |
| NNHTLIR | 28- |     | Current, Right            |                   |
|         | 128 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SPATIAL | 1   | 1   | Indicates if a county has | Blank             |
|         | 29- |     | been spatially corrected  |                   |
|         | 129 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| OP      | 1   | 1   | Indicates the operation   | MAGE type code in |
| ERATION | 30- |     | during which the feature  | MAGE file name =  |
|         | 130 |     | was updated               | operation code:   |
|         |     |     |                           |                   |
|         |     |     |                           | C (Listing Check) |
|         |     |     |                           | = 1               |
|         |     |     |                           |                   |
|         |     |     |                           | L (Listing) = 2   |
|         |     |     |                           |                   |
|         |     |     |                           | S (ALMI           |
|         |     |     |                           | Standalone) = 3   |
|         |     |     |                           |                   |
|         |     |     |                           | A (ACS TOI) = 5   |
+---------+-----+-----+---------------------------+-------------------+
| STATEL  | 1   | 2   | FIPS State Code           | Feature.ST_CODEL  |
|         | 31- |     | Tabulation, Left          |                   |
|         | 132 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| STATER  | 1   | 2   | FIPS State Code           | Feature.ST_CODER  |
|         | 33- |     | Tabulation, Right         |                   |
|         | 134 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUNTYL | 1   | 3   | FIPS County Code          | F                 |
|         | 35- |     | Tabulation, Left          | eature.CNTY_CODEL |
|         | 137 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUNTYR | 1   | 3   | FIPS County Code          | F                 |
|         | 38- |     | Tabulation, Right         | eature.CNTY_CODER |
|         | 140 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUSUBL | 1   | 5   | FIPS 55 Code (MCD/CCD)    | Feature.MCDL      |
|         | 41- |     | Current, Left             |                   |
|         | 145 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUSUBR | 1   | 5   | FIPS 55 Code (MCD/CCD)    | Feature.MCDR      |
|         | 46- |     | Current, Right            |                   |
|         | 150 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SUBMCDL | 1   | 5   | FIPS 55 Code (Sub-MCD)    | Blank             |
|         | 51- |     | Current, Left             |                   |
|         | 155 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SUBMCDR | 1   | 5   | FIPS 55 Code (Sub-MCD)    | Blank             |
|         | 56- |     | Current, Right            |                   |
|         | 160 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| PLACEL  | 1   | 5   | FIPS 55 Code (Place/CDP)  | Feature.PLACEL    |
|         | 61- |     | Current, Left             |                   |
|         | 165 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| PLACER  | 1   | 5   | FIPS 55 Code (Place/CDP)  | Feature.PLACER    |
|         | 66- |     | Current, Right            |                   |
|         | 170 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TRACTL  | 1   | 6   | Census Tract Code         | Feature.TRACTBL + |
|         | 71- |     | Tabulation, Left          | TRACTSL           |
|         | 176 |     |                           |                   |
|         |     |     | Note: Feature.TRACTBL     |                   |
|         |     |     | data type is Varchar2(5), |                   |
|         |     |     | but is expected to        |                   |
|         |     |     | contain only four         |                   |
|         |     |     | non-blank characters.     |                   |
+---------+-----+-----+---------------------------+-------------------+
| TRACTR  | 1   | 6   | Census Tract Code         | Feature.TRACTBR + |
|         | 77- |     | Tabulation, Right         | TRACTSR           |
|         | 182 |     |                           |                   |
|         |     |     | Note: Feature.TRACTBR     |                   |
|         |     |     | data type is Varchar2(5), |                   |
|         |     |     | but is expected to        |                   |
|         |     |     | contain only four         |                   |
|         |     |     | non-blank characters.     |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLOCKL  | 1   | 4   | Census Block Number       | Feature.BLKBL     |
|         | 83- |     | Tabulation, Left          |                   |
|         | 186 |     |                           |                   |
|         |     |     | Note: Feature.BLKBL data  |                   |
|         |     |     | type is Varchar2(5), but  |                   |
|         |     |     | is expected to contain    |                   |
|         |     |     | only four non-blank       |                   |
|         |     |     | characters.               |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLKSUFL | 1   | 2   | Census Block Number       | Feature.BLKSL     |
|         | 87- |     | Suffix Tabulation, Left   |                   |
|         | 188 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLOCKR  | 1   | 4   | Census Block Number       | Feature.BLKBR     |
|         | 89- |     | Tabulation, Right         |                   |
|         | 192 |     |                           |                   |
|         |     |     | Note: Feature.BLKBR data  |                   |
|         |     |     | type is Varchar2(5), but  |                   |
|         |     |     | is expected to contain    |                   |
|         |     |     | only four non-blank       |                   |
|         |     |     | characters.               |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLKSUFR | 1   | 2   | Census Block Number       | Feature.BLKSR     |
|         | 93- |     | Suffix Tabulation, Right  |                   |
|         | 194 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRLONG  | 1   | 10  | Start Longitude           | Feature.FRLONG1   |
|         | 95- |     |                           |                   |
|         | 204 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRLAT   | 2   | 9   | Start Latitude            | Feature.FRLAT1    |
|         | 05- |     |                           |                   |
|         | 213 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOLONG  | 2   | 10  | End Longitude             | Feature.TOLONG1   |
|         | 14- |     |                           |                   |
|         | 223 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOLAT   | 2   | 9   | End Latitude              | Feature.TOLAT1    |
|         | 24- |     |                           |                   |
|         | 232 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| F       | 2   | 10  | From Node Snap TLID       | Snap.TLID_FROM    |
| NS_TLID | 33- |     |                           |                   |
|         | 242 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| T       | 2   | 10  | To Node Snap TLID         | Snap.TLID_TO      |
| NS_TLID | 43- |     |                           |                   |
|         | 252 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SNA     | 2   | 1   | Snap Type; snapped to:    | Snap.SNAPTYP_FR   |
| PTYPEFR | 53- |     |                           |                   |
|         | 253 |     | P = point                 |                   |
|         |     |     |                           |                   |
|         |     |     | L = line                  |                   |
|         |     |     |                           |                   |
|         |     |     | " " = nothing             |                   |
+---------+-----+-----+---------------------------+-------------------+
| SNA     | 2   | 1   | Snap Type (P, L, " ")     | Snap.SNAPTYP_TO   |
| PTYPETO | 54- |     |                           |                   |
|         | 254 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| ASS     | 2   | 2   | 01 = locate address       | Blank             |
| IGNMENT | 55- |     |                           |                   |
|         | 256 |     | 02 = update block         |                   |
|         |     |     | (current survey,          |                   |
|         |     |     | non-NHIS)                 |                   |
|         |     |     |                           |                   |
|         |     |     | 04 = update block (CAUS)  |                   |
|         |     |     |                           |                   |
|         |     |     | 06 = GEO update           |                   |
|         |     |     | multi-unit assignment     |                   |
|         |     |     | (future)                  |                   |
|         |     |     |                           |                   |
|         |     |     | 09 = ACS TOI              |                   |
|         |     |     |                           |                   |
|         |     |     | 11 = update block         |                   |
|         |     |     | (current surveys, NHIS)   |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRID    | 2   | 5   | Identifies the FR (or     | Metamage.txt file |
|         | 57- |     | other ALMI user) who      | from MAGE.        |
|         | 261 |     | updated the feature       | #RO_ID +          |
|         |     |     |                           | #LISTER_ID        |
+---------+-----+-----+---------------------------+-------------------+
| D       | 2   | 14  | Date and time record was  | Transaction       |
| ATETIME | 62- |     | last touched by the ALMI  | table, Date and   |
|         | 275 |     | user; format:             | time stamp        |
|         |     |     |                           |                   |
|         |     |     | YYYYMMDDHHMMSS            |                   |
+---------+-----+-----+---------------------------+-------------------+
| CTLID   | 2   | 10  | Child TLID, created when  | Blank (not        |
|         | 76- |     | parent TLID was split     | supported in ALMI |
|         | 285 |     | into multiple segments    | 5.0)              |
+---------+-----+-----+---------------------------+-------------------+

## ATU1_Dup

This file contains a list of TLIDs that appear more than once in the
ATU1 file. ALMI 5.0 will generate unique temporary TLIDs for newly added
streets, so there will never be duplicate TLIDs for added streets, but
multiple FRs may update the same TIGER street, which means the same
permanent TLID will appear multiple times in the same ATU1 file. These
duplicate permanent TLIDs will be listed in the ATU1_Dup file.

[]{#__RefHeading___Toc61233882 .anchor}Table 6 ATU1_Dup

  ------------------------------------------------------------------------------
  Field     Position   Length   Description                 Data Source
  Name                                                      
  --------- ---------- -------- --------------------------- --------------------
  TLID      1-10       10       Duplicate TLID              ATU1.TLID

  ------------------------------------------------------------------------------

## ATU1G

All records from Feature.dbf with Version number 5001, non-blank
FRTSTAMP or non-blank TOTSTAMP are included in ATU1G file. The records
that meet these criteria are street features that were added using GPS.
ALMI-US converts Version number 5001 to 7001 to indicate that this is a
new GPS-created feature.

Note: This file will always be empty in ALMI-US 5.0, because the
requirement to return GPS streets in ungeocoded MAGEs was deferred until
a later version of ALMI. The file layout and expected data sources are
included here for completeness.

[]{#__RefHeading___Toc61233883 .anchor}Table 7 ATU1G

+---------+-----+-----+---------------------------+-------------------+
| Field   | Po  | Len | Description               | Data Source       |
| Name    | sit | gth |                           |                   |
|         | ion |     |                           |                   |
+=========+=====+=====+===========================+===================+
| ATU1G   | 1-1 | 1   | Indicates ATUF file type  | 3                 |
+---------+-----+-----+---------------------------+-------------------+
| VERSION | 2-5 | 4   | Transaction code (ATUF    | 7001 if           |
|         |     |     | version number): 7001 is  | Feature.VERSION = |
|         |     |     | the only supported code   | 5001              |
|         |     |     | for GPS streets in ALMI   |                   |
|         |     |     | 5.0                       |                   |
+---------+-----+-----+---------------------------+-------------------+
| TLID    | 6   | 10  | Temporary TIGER/Line ID   | Feature.TLID      |
|         | -15 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SIDE1   | 16  | 1   | Single Side Segment Code  | Blank             |
|         | -16 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SOURCE  | 17  | 1   | Linear Segment Source     | Blank             |
|         | -17 |     | Code                      |                   |
+---------+-----+-----+---------------------------+-------------------+
| FEDIRP  | 18  | 2   | Feature Direction, Prefix | Feature.FEDIRP    |
|         | -19 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FENAME  | 20  | 30  | Feature Name              | Feature.FENAME    |
|         | -49 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FETYPE  | 50  | 4   | Feature Type              | Feature.FETYPE    |
|         | -53 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FEDIRS  | 54  | 2   | Feature Direction, Suffix | Feature.FEDIRS    |
|         | -55 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| CFCC    | 56  | 3   | Census Feature            | Feature.CFCC      |
|         | -58 |     | Classification Code       |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRADDL  | 59  | 11  | Start Address, Left       | Feature.FRADDL    |
|         | -69 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOADDL  | 70  | 11  | End Address, Left         | Feature.TOADDL    |
|         | -80 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRADDR  | 81  | 11  | Start Address, Right      | Feature.FRADDR    |
|         | -91 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TOADDR  | 92- | 11  | End Address, Right        | Feature.TOADDR    |
|         | 102 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| R       | 1   | 1   | Reserved for future use   | Blank             |
| ESERVED | 03- |     |                           |                   |
|         | 103 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| R       | 1   | 1   | Reserved for future use   | Blank             |
| ESERVED | 04- |     |                           |                   |
|         | 104 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| R       | 1   | 1   | Reserved for future use   | Blank             |
| ESERVED | 05- |     |                           |                   |
|         | 105 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| R       | 1   | 1   | Reserved for future use   | Blank             |
| ESERVED | 06- |     |                           |                   |
|         | 106 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| ZIPL    | 1   | 5   | ZIP Code, Left            | Feature.ZIPL      |
|         | 07- |     |                           |                   |
|         | 111 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| ZIPR    | 1   | 5   | ZIP Code, Right           | Feature.ZIPR      |
|         | 12- |     |                           |                   |
|         | 116 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIANNHL | 1   | 5   | FIPS 55 Code (AIANNH      | Feature.AIANAL    |
|         | 17- |     | area) Current, Left       |                   |
|         | 121 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIANNHR | 1   | 5   | FIPS 55 Code (AIANNH      | Feature.AIANAR    |
|         | 22- |     | area) Current, Right      |                   |
|         | 126 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIA     | 1   | 1   | AIANNH Trust Land Flag    | Blank             |
| NNHTLIL | 27- |     | Current, Left             |                   |
|         | 127 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| AIA     | 1   | 1   | AIANNH Trust Land Flag    | Blank             |
| NNHTLIR | 28- |     | Current, Right            |                   |
|         | 128 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SPATIAL | 1   | 1   | Indicates if a county has | Blank             |
|         | 29- |     | been spatially corrected  |                   |
|         | 129 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| OP      | 1   | 1   | Indicates the operation   | MAGE type code in |
| ERATION | 30- |     | during which the feature  | MAGE file name =  |
|         | 130 |     | was updated               | operation code:   |
|         |     |     |                           |                   |
|         |     |     |                           | C (Listing Check) |
|         |     |     |                           | = 1               |
|         |     |     |                           |                   |
|         |     |     |                           | L (Listing) = 2   |
|         |     |     |                           |                   |
|         |     |     |                           | S (ALMI           |
|         |     |     |                           | Standalone) = 3   |
|         |     |     |                           |                   |
|         |     |     |                           | A (ACS TOI) = 5   |
+---------+-----+-----+---------------------------+-------------------+
| STATEL  | 1   | 2   | FIPS State Code           | Feature.ST_CODEL  |
|         | 31- |     | Tabulation, Left          |                   |
|         | 132 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| STATER  | 1   | 2   | FIPS State Code           | Feature.ST_CODER  |
|         | 33- |     | Tabulation, Right         |                   |
|         | 134 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUNTYL | 1   | 3   | FIPS County Code          | F                 |
|         | 35- |     | Tabulation, Left          | eature.CNTY_CODEL |
|         | 137 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUNTYR | 1   | 3   | FIPS County Code          | F                 |
|         | 38- |     | Tabulation, Right         | eature.CNTY_CODER |
|         | 140 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUSUBL | 1   | 5   | FIPS 55 Code (MCD/CCD)    | Feature.MCDL      |
|         | 41- |     | Current, Left             |                   |
|         | 145 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| COUSUBR | 1   | 5   | FIPS 55 Code (MCD/CCD)    | Feature.MCDR      |
|         | 46- |     | Current, Right            |                   |
|         | 150 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SUBMCDL | 1   | 5   | FIPS 55 Code (Sub-MCD)    | Blank             |
|         | 51- |     | Current, Left             |                   |
|         | 155 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| SUBMCDR | 1   | 5   | FIPS 55 Code (Sub-MCD)    | Blank             |
|         | 56- |     | Current, Right            |                   |
|         | 160 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| PLACEL  | 1   | 5   | FIPS 55 Code (Place/CDP)  | Feature.PLACEL    |
|         | 61- |     | Current, Left             |                   |
|         | 165 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| PLACER  | 1   | 5   | FIPS 55 Code (Place/CDP)  | Feature.PLACER    |
|         | 66- |     | Current, Right            |                   |
|         | 170 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TRACTL  | 1   | 6   | Census Tract Code         | Feature.TRACTBL + |
|         | 71- |     | Tabulation, Left          | TRACTSL           |
|         | 176 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| TRACTR  | 1   | 6   | Census Tract Code         | Feature.TRACTBR + |
|         | 77- |     | Tabulation, Right         | TRACTSR           |
|         | 182 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLOCKL  | 1   | 4   | Census Block Number       | Feature.BLKBL     |
|         | 83- |     | Tabulation, Left          |                   |
|         | 186 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLKSUFL | 1   | 2   | Census Block Number       | Feature.BLKSL     |
|         | 87- |     | Suffix Tabulation, Left   |                   |
|         | 188 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLOCKR  | 1   | 4   | Census Block Number       | Feature.BLKBR     |
|         | 89- |     | Tabulation, Right         |                   |
|         | 192 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| BLKSUFR | 1   | 2   | Census Block Number       | Feature.BLKSR     |
|         | 93- |     | Suffix Tabulation, Right  |                   |
|         | 194 |     |                           |                   |
+---------+-----+-----+---------------------------+-------------------+
| GPS     | 1   | 10  | GPS From Node Snap TLID   | Snap.TLID_FROM    |
| FNSTLID | 95- |     |                           | (not supported in |
|         | 204 |     |                           | ALMI 5.0)         |
+---------+-----+-----+---------------------------+-------------------+
| GPS     | 2   | 10  | GPS To Node Snap TLID     | Snap.TLID_TO (not |
| TNSTLID | 05- |     |                           | supported in ALMI |
|         | 214 |     |                           | 5.0)              |
+---------+-----+-----+---------------------------+-------------------+
| ASS     | 2   | 2   | 01 = locate address       | Blank             |
| IGNMENT | 15- |     |                           |                   |
|         | 216 |     | 02 = update block         |                   |
|         |     |     | (current survey,          |                   |
|         |     |     | non-NHIS)                 |                   |
|         |     |     |                           |                   |
|         |     |     | 04 = update block (CAUS)  |                   |
|         |     |     |                           |                   |
|         |     |     | 06 = GEO update           |                   |
|         |     |     | multi-unit assignment     |                   |
|         |     |     | (future)                  |                   |
|         |     |     |                           |                   |
|         |     |     | 09 = ACS TOI              |                   |
|         |     |     |                           |                   |
|         |     |     | 11 = update block         |                   |
|         |     |     | (current surveys, NHIS)   |                   |
+---------+-----+-----+---------------------------+-------------------+
| FRID    | 2   | 5   | Identifies the FR (or     | Metamage.txt file |
|         | 17- |     | other ALMI user) who      | from MAGE.        |
|         | 221 |     | added the feature         | #RO_ID +          |
|         |     |     |                           | #LISTER_ID        |
+---------+-----+-----+---------------------------+-------------------+
| D       | 2   | 14  | Date and time record was  | Transaction       |
| ATETIME | 22- |     | last touched by the ALMI  | table, date and   |
|         | 235 |     | user; format:             | time stamp        |
|         |     |     |                           |                   |
|         |     |     | YYYYMMDDHHMMSS            |                   |
+---------+-----+-----+---------------------------+-------------------+
| SIGNAL  | 2   | 1   | Indicates the type of     | Blank (not        |
|         | 36- |     | signal used to capture    | supported in ALMI |
|         | 236 |     | GPS points:               | 5.0)              |
|         |     |     |                           |                   |
|         |     |     | W = WAAS                  |                   |
|         |     |     |                           |                   |
|         |     |     | C = Canadian DGPS         |                   |
|         |     |     |                           |                   |
|         |     |     | U = NDGPS                 |                   |
|         |     |     |                           |                   |
|         |     |     | G = GPS                   |                   |
+---------+-----+-----+---------------------------+-------------------+
| SNA     | 2   | 1   | Snap Type; snapped to:    | Snap.SNAPTYP_FR   |
| PTYPEFR | 37- |     |                           | (not supported in |
|         | 237 |     | P = point                 | ALMI 5.0)         |
|         |     |     |                           |                   |
|         |     |     | L = line                  |                   |
|         |     |     |                           |                   |
|         |     |     | " " = nothing             |                   |
+---------+-----+-----+---------------------------+-------------------+
| SNA     | 2   | 1   | Snap Type (P, L, " ")     | Snap.SNAPTYP_TO   |
| PTYPETO | 38- |     |                           | (not supported in |
|         | 238 |     |                           | ALMI 5.0)         |
+---------+-----+-----+---------------------------+-------------------+

## ATU2

All records from Shape.dbf, corresponding to records from ATU1 (linked
by TLID) are included in ATU2.

[]{#__RefHeading___Toc61233884 .anchor}Table 8 ATU2

  -----------------------------------------------------------------------------
  Field     Position   Length   Description     Data Source
  Name                                          
  --------- ---------- -------- --------------- -------------------------------
  ATU2      1-1        1        Indicates ATUF  2
                                file type       

  VERSION   2-5        4        Transaction     ATU1.Version
                                code (ATUF      
                                version         
                                number): 5001   
                                is the only     
                                supported code  
                                for shape       
                                points in ALMI  
                                5.0             

  TLID      6-15       10       Temporary       Shape.TLID
                                TIGER/Line ID   

  RTSQ      16-18      3        Record Sequence Shape.SQ, trimmed to three
                                Number          characters

  LONG1     19-28      10       Point 1,        Shape.LONG1 (from first Shape
                                Longitude       record with this TLID)

  LAT1      29-37      9        Point 1,        Shape.LAT1 (from first Shape
                                Latitude        record with this TLID)

  LONG2     38-47      10       Point 2,        Shape.LONG1 (from second
                                Longitude       record...)

  LAT2      48-56      9        Point 2,        Shape.LAT1 (from second
                                Latitude        record...)

  LONG3     57-66      10       Point 3,        Shape.LONG1 (from third
                                Longitude       record...)

  LAT3      67-75      9        Point 3,        Shape.LAT1 (from third
                                Latitude        record...)

  LONG4     76-85      10       Point 4,        Shape.LONG1 (from fourth
                                Longitude       record...)

  LAT4      86-94      9        Point 4,        Shape.LAT1 (from fourth
                                Latitude        record...)

  LONG5     95-104     10       Point 5,        Shape.LONG1 (from fifth
                                Longitude       record...)

  LAT5      105-113    9        Point 5,        Shape.LAT1 (from fifth
                                Latitude        record...)

  LONG6     114-123    10       Point 6,        Shape.LONG1 (from sixth
                                Longitude       record...)

  LAT6      124-132    9        Point 6,        Shape.LAT1 (from sixth
                                Latitude        record...)

  LONG7     133-142    10       Point 7,        Shape.LONG1 (from seventh
                                Longitude       record...)

  LAT7      143-151    9        Point 7,        Shape.LAT1 (from seventh
                                Latitude        record...)

  LONG8     152-161    10       Point 8,        Shape.LONG1 (from eighth
                                Longitude       record...)

  LAT8      162-170    9        Point 8,        Shape.LAT1 (from eighth
                                Latitude        record...)

  LONG9     171-180    10       Point 9,        Shape.LONG1 (from ninth
                                Longitude       record...)

  LAT9      181-189    9        Point 9,        Shape.LAT1 (from ninth
                                Latitude        record...)

  LONG10    190-199    10       Point 10,       Shape.LONG1 (from tenth
                                Longitude       record...)

  LAT10     200-208    9        Point 10,       Shape.LAT1 (from tenth
                                Latitude        record...)
  -----------------------------------------------------------------------------

## ATU2G

Note: This file will always be empty in ALMI-US 5.0, because the
requirement to return GPS streets in ungeocoded MAGEs was deferred until
a later version of ALMI. The file layout and expected data sources are
included here for completeness.

[]{#__RefHeading___Toc61233885 .anchor}Table 9 ATU2G

+--------+------+-------+-------------------+-------------------------+
| Field  | Posi | L     | Description       | Data Source             |
| Name   | tion | ength |                   |                         |
+========+======+=======+===================+=========================+
| ATU2G  | 1-1  | 1     | Indicates ATUF    | 4                       |
|        |      |       | file type         |                         |
+--------+------+-------+-------------------+-------------------------+
| V      | 2-5  | 4     | Transaction code  | ATU1G.Version           |
| ERSION |      |       | (ATUF version     |                         |
|        |      |       | number): 7001 is  |                         |
|        |      |       | the only          |                         |
|        |      |       | supported code    |                         |
|        |      |       | for GPS shape     |                         |
|        |      |       | points in ALMI    |                         |
|        |      |       | 5.0               |                         |
+--------+------+-------+-------------------+-------------------------+
| TLID   | 6-15 | 10    | Temporary         | Shape.TLID              |
|        |      |       | TIGER/Line ID     |                         |
+--------+------+-------+-------------------+-------------------------+
| RTSQ   | 1    | 3     | Record Sequence   | Shape.SQ, trimmed to    |
|        | 6-18 |       | Number            | three characters        |
+--------+------+-------+-------------------+-------------------------+
| LONG1  | 1    | 10    | Point 1,          | Shape.LONG1 (from first |
|        | 9-28 |       | Longitude         | Shape record with this  |
|        |      |       |                   | TLID)                   |
+--------+------+-------+-------------------+-------------------------+
| LAT1   | 2    | 9     | Point 1, Latitude | Shape.LAT1 (from first  |
|        | 9-37 |       |                   | Shape record with this  |
|        |      |       |                   | TLID)                   |
+--------+------+-------+-------------------+-------------------------+
| LONG2  | 3    | 10    | Point 2,          | Shape.LONG1 (from       |
|        | 8-47 |       | Longitude         | second record...)       |
+--------+------+-------+-------------------+-------------------------+
| LAT2   | 4    | 9     | Point 2, Latitude | Shape.LAT1 (from second |
|        | 8-56 |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LONG3  | 5    | 10    | Point 3,          | Shape.LONG1 (from third |
|        | 7-66 |       | Longitude         | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LAT3   | 6    | 9     | Point 3, Latitude | Shape.LAT1 (from third  |
|        | 7-75 |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LONG4  | 7    | 10    | Point 4,          | Shape.LONG1 (from       |
|        | 6-85 |       | Longitude         | fourth record...)       |
+--------+------+-------+-------------------+-------------------------+
| LAT4   | 8    | 9     | Point 4, Latitude | Shape.LAT1 (from fourth |
|        | 6-94 |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LONG5  | 95   | 10    | Point 5,          | Shape.LONG1 (from fifth |
|        | -104 |       | Longitude         | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LAT5   | 105  | 9     | Point 5, Latitude | Shape.LAT1 (from fifth  |
|        | -113 |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LONG6  | 114  | 10    | Point 6,          | Shape.LONG1 (from sixth |
|        | -123 |       | Longitude         | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LAT6   | 124  | 9     | Point 6, Latitude | Shape.LAT1 (from sixth  |
|        | -132 |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LONG7  | 133  | 10    | Point 7,          | Shape.LONG1 (from       |
|        | -142 |       | Longitude         | seventh record...)      |
+--------+------+-------+-------------------+-------------------------+
| LAT7   | 143  | 9     | Point 7, Latitude | Shape.LAT1 (from        |
|        | -151 |       |                   | seventh record...)      |
+--------+------+-------+-------------------+-------------------------+
| LONG8  | 152  | 10    | Point 8,          | Shape.LONG1 (from       |
|        | -161 |       | Longitude         | eighth record...)       |
+--------+------+-------+-------------------+-------------------------+
| LAT8   | 162  | 9     | Point 8, Latitude | Shape.LAT1 (from eighth |
|        | -170 |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LONG9  | 171  | 10    | Point 9,          | Shape.LONG1 (from ninth |
|        | -180 |       | Longitude         | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LAT9   | 181  | 9     | Point 9, Latitude | Shape.LAT1 (from ninth  |
|        | -189 |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LONG10 | 190  | 10    | Point 10,         | Shape.LONG1 (from tenth |
|        | -199 |       | Longitude         | record...)              |
+--------+------+-------+-------------------+-------------------------+
| LAT10  | 200  | 9     | Point 10,         | Shape.LAT1 (from tenth  |
|        | -208 |       | Latitude          | record...)              |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 209  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME1 | -222 |       | was collected;    | first Shape record with |
|        |      |       | format:           | this TLID)              |
|        |      |       |                   |                         |
|        |      |       | YYYYMMDDHHMMSS    |                         |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 223  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME2 | -236 |       | was collected     | second Shape record...) |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 237  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME3 | -250 |       | was collected     | third Shape record...)  |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 251  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME4 | -264 |       | was collected     | fourth Shape record...) |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 265  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME5 | -278 |       | was collected     | fifth Shape record...)  |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 279  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME6 | -292 |       | was collected     | sixth Shape record...)  |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 293  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME7 | -306 |       | was collected     | seventh Shape           |
|        |      |       |                   | record...)              |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 307  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME8 | -320 |       | was collected     | eighth Shape record...) |
+--------+------+-------+-------------------+-------------------------+
| DAT    | 321  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| ETIME9 | -334 |       | was collected     | ninth Shape record...)  |
+--------+------+-------+-------------------+-------------------------+
| DATE   | 335  | 14    | Date and time GPS | Shape.TSTAMP (from      |
| TIME10 | -348 |       | was collected     | tenth Shape record...)  |
+--------+------+-------+-------------------+-------------------------+

## ATU4

The ATU4 file contains all of the links between alternate feature names
and TLIDs in ATU1 and ATU1G. If a TLID is included in ATU1, all of its
alternate feature names are also included in the ATUF, even if the ALMI
user made no changes to the alternate feature names.

Note:

-   The VERSION\* and FEAT\* field names are intentionally numbered from
    2 to 9, rather than 1 to 8.

-   This file will always be empty in ALMI-US 5.0, because the
    requirement to allow FRs to add, edit, and delete alternate feature
    names was deferred until a later version of ALMI. Therefore, this
    file will not be included in the ATUF for 5.0. The file layout and
    expected data sources that had been designed prior to deferring
    these requirements are included here for completeness. The Data
    Source column refers to a VERSION field in the Altfeat table; this
    field does not exist in ALMI 5.0, but it will exist when a future
    version of ALMI allows users to edit alternate street names.

[]{#__RefHeading___Toc61233886 .anchor}Table 10 ATU4

+--------+------+-----+--------------------------+--------------------+
| Field  | Posi | Len | Description              | Data Source        |
| Name   | tion | gth |                          |                    |
+========+======+=====+==========================+====================+
| RT     | 1-1  | 1   | Indicates ATUF file type | 4                  |
+--------+------+-----+--------------------------+--------------------+
| VE     | 2-5  | 4   | Transaction code (ATUF   | Altfeat.VERSION    |
| RSION2 |      |     | version number): 4999    | (from first        |
|        |      |     | and 5001 are the only    | Altfeat record     |
|        |      |     | supported codes for      | with this TLID,    |
|        |      |     | deleting and adding      | where VERSION =    |
|        |      |     | alternate street names   | 5001 or \<MMYY\>)  |
|        |      |     | in ALMI 5.0              |                    |
|        |      |     |                          |                    |
|        |      |     | 4999 = deleted link      |                    |
|        |      |     | between TLID and         |                    |
|        |      |     | alternate feature name   |                    |
|        |      |     | (FEAT_ID)                |                    |
|        |      |     |                          |                    |
|        |      |     | 5001 = added link        |                    |
|        |      |     | between TLID and FEAT_ID |                    |
|        |      |     |                          |                    |
|        |      |     | \<MMYY\> = original      |                    |
|        |      |     | TIGER/Line transaction   |                    |
|        |      |     | code; no change to link  |                    |
+--------+------+-----+--------------------------+--------------------+
| VE     | 6-9  | 4   | Transaction code --      | Altfeat.VERSION    |
| RSION3 |      |     | added or unchanged link  | (from second       |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 5001 or \<MMYY\>)  |
+--------+------+-----+--------------------------+--------------------+
| VE     | 1    | 4   | Transaction code --      | Altfeat.VERSION    |
| RSION4 | 0-13 |     | added or unchanged link  | (from third        |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 5001 or \<MMYY\>)  |
+--------+------+-----+--------------------------+--------------------+
| VE     | 1    | 4   | Transaction code --      | Altfeat.VERSION    |
| RSION5 | 4-17 |     | added or unchanged link  | (from fourth       |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 5001 or \<MMYY\>)  |
+--------+------+-----+--------------------------+--------------------+
| VE     | 1    | 4   | Transaction code --      | Altfeat.VERSION    |
| RSION6 | 8-21 |     | deleted link             | (from first        |
|        |      |     |                          | Altfeat record     |
|        |      |     |                          | with this TLID,    |
|        |      |     |                          | where VERSION =    |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| VE     | 2    | 4   | Transaction code --      | Altfeat.VERSION    |
| RSION7 | 2-25 |     | deleted link             | (from second       |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| VE     | 2    | 4   | Transaction code --      | Altfeat.VERSION    |
| RSION8 | 6-29 |     | deleted link             | (from third        |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| VE     | 3    | 4   | Transaction code --      | Altfeat.VERSION    |
| RSION9 | 0-33 |     | deleted link             | (from fourth       |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| TLID   | 3    | 10  | TIGER/Line ID            | Altfeat.TLID       |
|        | 4-43 |     |                          |                    |
+--------+------+-----+--------------------------+--------------------+
| RTSQ   | 4    | 3   | Record sequence number   | Blank              |
|        | 4-46 |     |                          |                    |
+--------+------+-----+--------------------------+--------------------+
| FEAT2  | 4    | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | 7-54 |     | ID -- added or unchanged | (from first        |
|        |      |     | link                     | Altfeat record     |
|        |      |     |                          | with this TLID,    |
|        |      |     |                          | where VERSION =    |
|        |      |     |                          | 5001 or \<MMYY\>)  |
+--------+------+-----+--------------------------+--------------------+
| FEAT3  | 5    | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | 5-62 |     | ID -- added or unchanged | (from second       |
|        |      |     | link                     | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 5001 or \<MMYY\>)  |
+--------+------+-----+--------------------------+--------------------+
| FEAT4  | 6    | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | 3-70 |     | ID -- added or unchanged | (from third        |
|        |      |     | link                     | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 5001 or \<MMYY\>)  |
+--------+------+-----+--------------------------+--------------------+
| FEAT5  | 7    | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | 1-78 |     | ID -- added or unchanged | (from fourth       |
|        |      |     | link                     | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 5001 or \<MMYY\>)  |
+--------+------+-----+--------------------------+--------------------+
| FEAT6  | 7    | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | 9-86 |     | ID -- deleted link       | (from first        |
|        |      |     |                          | Altfeat record     |
|        |      |     |                          | with this TLID,    |
|        |      |     |                          | where VERSION =    |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| FEAT7  | 8    | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | 7-94 |     | ID -- deleted link       | (from second       |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| FEAT8  | 95   | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | -102 |     | ID -- deleted link       | (from third        |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| FEAT9  | 103  | 8   | Alternate feature name   | Altfeat.FEAT_ID    |
|        | -110 |     | ID -- deleted link       | (from fourth       |
|        |      |     |                          | Altfeat            |
|        |      |     |                          | record...VERSION = |
|        |      |     |                          | 4999)              |
+--------+------+-----+--------------------------+--------------------+
| FRID   | 111  | 5   | Identifies the FR (or    | Metamage.txt file  |
|        | -115 |     | other ALMI user) who     | from MAGE.         |
|        |      |     | last had the chance to   | #RO_ID +           |
|        |      |     | update the feature       | #LISTER_ID         |
+--------+------+-----+--------------------------+--------------------+

## ATU5

The ATU5 file contains all of the alternate feature names that are
linked to TLIDs in ATU1 and ATU1G. If a TLID is included in ATU1, all of
its alternate feature names are also included in the ATUF, even if the
ALMI user made no changes to the alternate feature names.

Note: This file will always be empty in ALMI-US 5.0, because the
requirement to allow FRs to add, edit, and delete alternate feature
names was deferred until a later version of ALMI Therefore, this file
will not be included in the ATUF for 5.0. The file layout and expected
data sources that had been designed prior to deferring these
requirements are included here for completeness.

[]{#__RefHeading___Toc61233887 .anchor}Table 11 ATU5

+--------+-----+-----+--------------------------+--------------------+
| Field  | Po  | Len | Description              | Data Source        |
| Name   | sit | gth |                          |                    |
|        | ion |     |                          |                    |
+========+=====+=====+==========================+====================+
| RT     | 1-1 | 1   | Indicates ATUF file type | 5                  |
+--------+-----+-----+--------------------------+--------------------+
| TLID   | 2   | 10  | TIGER/Line ID            | Altfeat.TLID       |
|        | -11 |     |                          |                    |
+--------+-----+-----+--------------------------+--------------------+
| FILE   | 12  | 5   | State and county codes   | State and county   |
|        | -16 |     |                          | codes from BMPF    |
+--------+-----+-----+--------------------------+--------------------+
| FEAT   | 17  | 8   | Alternate feature name   | Altname.FEAT_ID    |
|        | -24 |     | ID                       |                    |
+--------+-----+-----+--------------------------+--------------------+
| FEDIRP | 25  | 2   | Feature Direction,       | Altname.FEDIRP     |
|        | -26 |     | Prefix                   |                    |
+--------+-----+-----+--------------------------+--------------------+
| FENAME | 27  | 30  | Feature Name             | Altname.FENAME     |
|        | -56 |     |                          |                    |
+--------+-----+-----+--------------------------+--------------------+
| FETYPE | 57  | 4   | Feature Type             | Altname.FETYPE     |
|        | -60 |     |                          |                    |
+--------+-----+-----+--------------------------+--------------------+
| FEDIRS | 61  | 2   | Feature Direction,       | Altname.FEDIRS     |
|        | -62 |     | Suffix                   |                    |
+--------+-----+-----+--------------------------+--------------------+
| DA     | 63  | 14  | Date and time record was | Transaction table, |
| TETIME | -76 |     | last touched by the ALMI | date and time      |
|        |     |     | user; format:            | stamp              |
|        |     |     |                          |                    |
|        |     |     | YYYYMMDDHHMMSS           |                    |
+--------+-----+-----+--------------------------+--------------------+

## ATU7

ATU7 is the Point Exchange file. The ALMI-US converts mapping activity
codes in Address.dbf based on business rules provided for populating the
MAFUF. Refer to table [Activity Code Conversions for MAFUF, DSMDUF,
GQUF, and ATU7](#ActivityCodeConversionTable) for processing details.
Only records from Maf.dbf with non-blank converted activity codes and
valid latitude/longitude coordinates (the first character of LONG1 and
LAT1 is "+" or "-") are included in ATU7. The records that meet these
criteria are map spot addresses that were added, edited, marked for
deletion, or marked as verified. Addresses from Nhis.dbf are not
included in ATU7 because NHIS addresses are not part of the ATUF.

[]{#__RefHeading___Toc61233888 .anchor}Table 12 ATU7

+---------+-----+----+---------------------------+------------------+
| Field   | Po  | Le | Description               | Data Source      |
| Name    | sit | ng |                           |                  |
|         | ion | th |                           |                  |
+=========+=====+====+===========================+==================+
| ATU7    | 1-1 | 1  | Indicates ATUF file type  | 7                |
+---------+-----+----+---------------------------+------------------+
| VERSION | 2-5 | 5  | Transaction code (ATUF    | Refer to table   |
|         |     |    | version number): 6001,    | [Activity Code   |
|         |     |    | 6003, 6004, 6005, 6999    | Conversions for  |
|         |     |    | are the only supported    | MAFUF, DSMDUF,   |
|         |     |    | codes for updating map    | GQUF, and        |
|         |     |    | spots in ALMI 5.0         | ATU              |
|         |     |    |                           | 7](#ActivityCode |
|         |     |    |                           | ConversionTable) |
|         |     |    |                           | for processing   |
|         |     |    |                           | details.         |
+---------+-----+----+---------------------------+------------------+
| FRID    | 6   | 5  | Identifies the FR (or     | Metamage.txt     |
|         | -10 |    | other ALMI user) who      | file from MAGE.  |
|         |     |    | updated the map spot      | #RO_ID +         |
|         |     |    |                           | #LISTER_ID       |
+---------+-----+----+---------------------------+------------------+
| R       | 11  | 1  | Reserved for later use    | Blank            |
| ESERVED | -11 |    |                           |                  |
+---------+-----+----+---------------------------+------------------+
| T       | 12  | 10 | TLID of street feature    | Blank            |
| LIDLINK | -21 |    | that the map spot is      |                  |
|         |     |    | linked to (not supported  |                  |
|         |     |    | in ALMI 5.0)              |                  |
+---------+-----+----+---------------------------+------------------+
| OP      | 22  | 1  | Indicates the operation   | MAGE type code   |
| ERATION | -22 |    | during which the map spot | in MAGE file     |
|         |     |    | was updated               | name = operation |
|         |     |    |                           | code:            |
|         |     |    |                           |                  |
|         |     |    |                           | C (Listing       |
|         |     |    |                           | Check) = 1       |
|         |     |    |                           |                  |
|         |     |    |                           | L (Listing) = 2  |
|         |     |    |                           |                  |
|         |     |    |                           | S (ALMI          |
|         |     |    |                           | Standalone) = 3  |
|         |     |    |                           |                  |
|         |     |    |                           | A (ACS TOI) = 5  |
+---------+-----+----+---------------------------+------------------+
| CFCC    | 23  | 3  | Census Feature Class Code | Maf.CFCC         |
|         | -25 |    |                           |                  |
+---------+-----+----+---------------------------+------------------+
| SPOTST  | 26  | 2  | State where map spot is   | Maf.ST_CODE      |
|         | -27 |    | located                   |                  |
+---------+-----+----+---------------------------+------------------+
| SPOTCTY | 28  | 3  | County where map spot is  | Maf.CNTY_CODE    |
|         | -30 |    | located                   |                  |
+---------+-----+----+---------------------------+------------------+
| S       | 31  | 4  | Census tract where map    | Maf.TRACTB       |
| POTRACT | -34 |    | spot is located           |                  |
+---------+-----+----+---------------------------+------------------+
| SPOT    | 35  | 2  | Suffix of tract where map | Maf.TRACTS       |
| RACTSUF | -36 |    | spot is located           |                  |
+---------+-----+----+---------------------------+------------------+
| SP      | 37  | 5  | Block where map spot is   | Maf.BLKB         |
| OTBLOCK | -41 |    | located                   |                  |
+---------+-----+----+---------------------------+------------------+
| SPO     | 42  | 1  | Suffix of block where map | Maf.BLKS         |
| TBLOCKS | -42 |    | spot is located           |                  |
+---------+-----+----+---------------------------+------------------+
| SPO     | 43  | 4  | Map spot ID number        | Maf.MAP_SPOTB    |
| TNUMBER | -46 |    |                           |                  |
+---------+-----+----+---------------------------+------------------+
| SPO     | 47  | 1  | Map spot suffix           | Maf.MAP_SPOTS    |
| TSUFFIX | -47 |    |                           |                  |
+---------+-----+----+---------------------------+------------------+
| R       | 48  | 8  | Blank                     | Blank            |
| ESERVED | -55 |    |                           |                  |
+---------+-----+----+---------------------------+------------------+
| MANLONG | 56  | 10 | Longitude (Manual, TIGER, | Maf.LONG1 if     |
|         | -65 |    | Relative, etc.)           | TSTAMP is blank; |
|         |     |    |                           | else blank       |
+---------+-----+----+---------------------------+------------------+
| MANLAT  | 66  | 9  | Latitude (Manual, TIGER,  | Maf.LAT1 if      |
|         | -74 |    | Relative, etc.)           | TSTAMP is blank; |
|         |     |    |                           | else blank       |
+---------+-----+----+---------------------------+------------------+
| L       | 75  | 1  | Location where GPS point  | Blank            |
| OCATION | -75 |    | was collected:            |                  |
|         |     |    |                           |                  |
|         |     |    | D = Driveway              |                  |
|         |     |    |                           |                  |
|         |     |    | H = House                 |                  |
|         |     |    |                           |                  |
|         |     |    | G = Gate                  |                  |
|         |     |    |                           |                  |
|         |     |    | (not supported in ALMI    |                  |
|         |     |    | 5.0)                      |                  |
+---------+-----+----+---------------------------+------------------+
| GPSLONG | 76  | 10 | GPS longitude             | Maf.LONG1 if     |
|         | -85 |    |                           | TSTAMP is not    |
|         |     |    |                           | blank; else      |
|         |     |    |                           | ALT_LONG1        |
+---------+-----+----+---------------------------+------------------+
| GPSLAT  | 86  | 9  | GPS latitude              | Maf.LAT1 if      |
|         | -94 |    |                           | TSTAMP is not    |
|         |     |    |                           | blank; else      |
|         |     |    |                           | ALT_LAT1         |
+---------+-----+----+---------------------------+------------------+
| D       | 95- | 14 | Date and time when last   | Blank            |
| ATETIME | 108 |    | GPS point was collected   |                  |
|         |     |    | (applicable when ALMI     |                  |
|         |     |    | users can collect         |                  |
|         |     |    | multiple GPS points for   |                  |
|         |     |    | one map spot; not         |                  |
|         |     |    | supported in ALMI 5.0)    |                  |
+---------+-----+----+---------------------------+------------------+
| SIGNAL  | 1   | 1  | Indicates the type of     | Blank (not       |
|         | 09- |    | signal used to capture    | supported in     |
|         | 109 |    | GPS points:               | ALMI 5.0)        |
|         |     |    |                           |                  |
|         |     |    | W = WAAS                  |                  |
|         |     |    |                           |                  |
|         |     |    | C = Canadian DGPS         |                  |
|         |     |    |                           |                  |
|         |     |    | U = NDGPS                 |                  |
|         |     |    |                           |                  |
|         |     |    | G = GPS                   |                  |
+---------+-----+----+---------------------------+------------------+
| GPS4PT1 | 1   | 14 | Date and time when first  | Maf.TSTAMP if    |
|         | 10- |    | GPS point was collected   | TSTAMP is not    |
|         | 123 |    |                           | blank; else      |
|         |     |    |                           | ALT_TSTAMP       |
+---------+-----+----+---------------------------+------------------+

## ATU7_Dup

ATU7_Dup lists the map spot IDs (state, county, tract, block, map spot
number) that appear more than once in the ATU7 file.

[]{#__RefHeading___Toc61233889 .anchor}Table 13 ATU7_Dup

  -------------------------------------------------------------------------------
  Field Name    Position   Length   Description                Data Source
  ------------- ---------- -------- -------------------------- ------------------
  SPOTST        1-2        2        State where map spot is    ATU7.SPOTST
                                    located                    

  SPOTCTY       3-5        3        County where map spot is   ATU7.SPOTCTY
                                    located                    

  SPOTRACT      6-9        4        Census tract where map     ATU7.SPOTRACT
                                    spot is located            

  SPOTRACTSUF   10-11      2        Suffix of tract where map  ATU7.SPOTRACTSUF
                                    spot is located            

  SPOTBLOCK     12-16      5        Block where map spot is    ATU7.SPOTBLOCK
                                    located                    

  SPOTBLOCKS    17-17      1        Suffix of block where map  ATU7.SPOTBLOCKS
                                    spot is located            

  SPOTNUMBER    18-21      4        Map spot ID number         ATU7.SPOTNUMBER

  SPOTSUFFIX    22-22      1        Map spot suffix            ATU7.SPOTSUFFIX
  -------------------------------------------------------------------------------

## ATUBT

ALMI-US summarizes record counts for updated feature and map spot
information at the block level to create ATUBT.

[]{#__RefHeading___Toc61233890 .anchor}Table 14 ALMI TIGER Update File
ATUBT

+-----------+-----+-------+-----------------------+------------------+
| Field     | Po  | L     | Description           | Data Source      |
| Name      | sit | ength |                       |                  |
|           | ion |       |                       |                  |
+===========+=====+=======+=======================+==================+
| ATUBT     | 1-1 | 1     | Indicates ATUF file   | B                |
|           |     |       | type                  |                  |
+-----------+-----+-------+-----------------------+------------------+
| STATE     | 2-3 | 2     | FIPS State Code       | ATU1.STATEL,     |
|           |     |       |                       | STATER           |
+-----------+-----+-------+-----------------------+------------------+
| COUNTY    | 4-6 | 3     | FIPS County Code      | ATU1.COUNTYL,    |
|           |     |       |                       | COUNTYR          |
+-----------+-----+-------+-----------------------+------------------+
| TRACT     | 7   | 6     | Census Tract Code     | ATU1.TRACTL,     |
|           | -12 |       |                       | TRACTR           |
+-----------+-----+-------+-----------------------+------------------+
| BLOCK     | 13  | 4     | Census Block Number   | ATU1.BLOCKL,     |
|           | -16 |       |                       | BLOCKR           |
+-----------+-----+-------+-----------------------+------------------+
| BLKSUF    | 17  | 2     | Census Block Number   | ATU1.BLKSUFL,    |
|           | -18 |       | Suffix                | BLKSUFR          |
+-----------+-----+-------+-----------------------+------------------+
| GPS FILE  | 19  | 30    | Name of RINEX that    | Blank            |
| NAME      | -48 |       | contains GPS data for |                  |
|           |     |       | this block or county  |                  |
+-----------+-----+-------+-----------------------+------------------+
| ATU1      | 49  | 5     | Total ATU1            | Number of        |
|           | -53 |       | Transaction Records   | records in ATU1  |
|           |     |       |                       | (see note        |
|           |     |       |                       | following this   |
|           |     |       |                       | table)           |
+-----------+-----+-------+-----------------------+------------------+
| ATU2      | 54  | 5     | Total ATU2            | Number of        |
|           | -58 |       | Transaction Records   | records in ATU2  |
+-----------+-----+-------+-----------------------+------------------+
| ATU1G     | 59  | 5     | Total ATU1G           | Blank            |
|           | -63 |       | Transaction Records   |                  |
+-----------+-----+-------+-----------------------+------------------+
| ATU2G     | 64  | 5     | Total ATU2G           | Blank            |
|           | -68 |       | Transaction Records   |                  |
+-----------+-----+-------+-----------------------+------------------+
| ATU7      | 69  | 5     | Total ATU7            | Number of        |
|           | -73 |       | Transaction Records   | records in ATU7  |
+-----------+-----+-------+-----------------------+------------------+
| COMPLETE  | 74  | 1     | Indicates whether the | Blank (not       |
|           | -74 |       | block is complete:    | supported by     |
|           |     |       |                       | ALMI 5.0)        |
|           |     |       | 1 = Yes               |                  |
|           |     |       |                       |                  |
|           |     |       | 2 = No                |                  |
+-----------+-----+-------+-----------------------+------------------+
| TOTAL     | 75  | 10    | Total Updates         | ATUBT.ATU1 +     |
|           | -84 |       |                       | ATU2 + ATU1G +   |
|           |     |       |                       | ATU2G + ATU7     |
+-----------+-----+-------+-----------------------+------------------+

Note: Each record from ATU1 will be counted twice, once for the
geocoding on the left side of the feature, and once for the geocoding on
the right side of the feature.

# Activity Code Information

The MAFUF and DSMDUF will contain a record for every address that was
added, moved, marked as deleted, corrected, or verified. In addition to
what is contained in the MAFUF, the DSMDUF will also contain every
address that was marked as unable to verify. The GQUF will contain a
record for every record that used to be a GQ or is now a GQ, where that
record was added, moved, marked as deleted, corrected, verified, or
marked as unable to verify.

ALMI-US examines the address record's activity code to determine whether
to include it in a particular update file. The following table lists the
activity codes that can exist in the MAGE Address table.

[]{#__RefHeading___Toc61233891 .anchor}Table 15 []{#ActivityCodeTable
.anchor}Activity Codes

  -----------------------------------------------------------------------
  Activity code   Description
  --------------- -------------------------------------------------------
  A               Add

  C               Correction

  D               Delete

  M               Move

  N               Nonresidential

  P               Physical delete of previously added address (not seen
                  by ALMI users, excluded from update files)

  U               Unable to Verify

  V               Verify

  W               Wrong county
  -----------------------------------------------------------------------

The following table shows how certain activity codes are converted prior
to populating certain update files. If an activity code is converted to
blank, that address record is not included in the update file.

[]{#__RefHeading___Toc61233892 .anchor}Table 16
[]{#ActivityCodeConversionTable .anchor}Activity Code Conversions for
MAFUF, DSMDUF, GQUF, and ATU7

  ------------------------------------------------------------------------
  Activity code Unit status  Activity code  Activity code Version
  in Address    in Address   in MAFUF and   in DSMDUF     (transaction)
  table         table        GQUF                         code in ATU7
  ------------- ------------ -------------- ------------- ----------------
  A             N/A          A              A             6001 if
                                                          Address.TSTAMP
                                                          is blank; else
                                                          8001 (created by
                                                          GPS)

  C             N/A          C              C             6004

  D             29 Merged    C              D             6999

  D             7 Duplicate  C              D             6999

  D             2, 4, 11     D              D             6999

  M             N/A          M              M             6003

  N             N/A          N              N             6004

  P             N/A          Blank          Blank         Blank

  U             N/A          Blank          U             Blank

  V             N/A          V              V             6005

  W             N/A          W              W             6999
  ------------------------------------------------------------------------

Processing Change Note: ALMI-US 4.x identified non-spotted units by
looking for Address.LAT1 = "999999999" (9 nines) or Address.LONG1 =
"9999999999" (10 nines). ALMI-US 5.0 will look solely at the first
character of these two fields -- if the first character is a digit
(i.e., not "+" or "-"), then the unit is not spotted.