Process for selecting a certain set of items from a SSURGO info table.

This example illustrates:
    a. how to obtain the items CLNIRR and CLIRR from the COMP info tables of each county of the WRB
    b. how to combine them as one table (wrbcomp)
    c. how to attach the items to the polyginal information of the SSURGO dataset (ssurgo.pat).

1. copy COMP info files for each county to workspace

Arc: |> copyinfo /ise3/soils/ssurgo/wrbssurgo/linncomp linncomp <|
Copied /ise3/soils/ssurgo/wrbssurgo/linncomp to linncomp

2. use ALTER in TABLES to change item definitions to match those of the 'certified' tables:

ITEM NAME WIDTH OUTPUT TYPE N.DEC ALTERNATE NAME
CLNIRR 1 1 C -

Arc: |> tables <|
Enter Command: |> sel maricomp <|
Enter Command: |> alter clnirr:c clnirr 1 C <|
COLUMN   ITEM NAME        WIDTH OUTPUT TYPE N.DEC ALTERNATE NAME
      204          CLNIRR:C               1                1              I      -
Alternate Item Name: |><|
COLUMN   ITEM NAME        WIDTH OUTPUT TYPE N.DEC ALTERNATE NAME
      204            CLNIRR                 1                1             C      -

NOTE:
* ALTER will not change the WIDTH definition
* if the WIDTH definition of the orginal item does not agree with that of the 'certified' definition, a
new item with the proper definition must be added.

Arc: |> additem <|
Usage: ADDITEM <in_info_file> <out_info_file> <item_name> <item_width>
<output_width> <item_type> {decimal_places} {start_item}
Arc: |> additem maricomp maricomp muid 9 9 C <|
Adding muid to maricomp to produce maricomp.

* use CALC in TABLES to populate the new item with the correct data

Enter Command: |> sel maricomp <|
101 Records Selected.
Enter Command: |> calc <|
Usage: CALCULATE <target_item> = <arithmetic_expression>
Enter Command: |> calc muid = muid:c <|

* use DROPITEM to delete unwanted item with incorrect definitions

Enter Command: |> dropitem <|
Usage: DROPITEM <info_file> <item...item>
Enter Command: |> sel <|
File MARICOMP is now closed.
Enter Command: |> dropitem maricomp muid:c <|

*** if the Item TYPE do not agree, first alter the TYPE to the correct definition, then ADDITEM, CALC
DROPITEM.

3. use PULLITEMS in ARC to create a COMP file for each county that only contains the properly defined
items to be used and MUID.

Arc: |> pullitems maricomp maricomp <|
Enter item names (type END or a blank line when done):
======================================================
Enter the 1st item: |> clnirr <|
Enter the 2nd item: |> clirr <|
Enter the 3rd item: |> muid <|
Enter the 4th item: |> end <|

4. combine all counties COMP info tables into one: WRBCOMP, by merging the lookup tables.:

a. Arc: |> copyinfo /ise3/soils/ssurgo/wrbssurgo/linncomp wrbcomp <|

     Copied /ise3/soils/ssurgo/wrbssurgo/linncomp to wrbcomp
b. Arc: |> info
     ENTER USER NAME>arc
     ENTER COMMAND > SEL LANECOMP
     ENTER COMMAND > MERGE INTO WRBCOMP MUID
     ENTER COMMAND > Q STOP

5. use JOINITEM in ARC to join WRBCOMP to SSURGO.PAT, with MUID as the JOINITEM.