Arc: info INFO EXCHANGE CALL 24/06/1994 10:31:30 INFO 9.42 11/11/86 52.74.63* COPYRIGHT 1986 HENCO SOFTWARE, INC. PROPRIETARY TO HENCO SOFTWARE, INC. US GOVT AGENCIES SEE USAGE RESTRICTIONS IN HELP FILES (HELP RESTRICTIONS) ENTER USER NAME>ARC
Remember to press the caps lock key so that everything is in capitals. Select our solution info file. At the INFO prompt type :
ENTER COMMAND >SELECT FINAL.PAT
15 RECORD(S) SELECTED
Now look at the ITEMS of this file.
ENTER COMMAND >ITEMS
DATAFILE NAME: FINAL.PAT 06/24/1994
10 ITEMS: STARTING IN POSITION 1
COL ITEM NAME WDTH OPUT TYP N.DEC ALTERNATE NAME
1 AREA 8 18 F 5
9 PERIMETER 8 18 F 5
17 FINAL# 4 5 B -
21 FINAL-ID 4 5 B -
25 FORESTPOLY# 4 5 B -
29 FORESTPOLY-ID 4 5 B -
33 GRID-CODE 4 8 B -
37 SOLF# 4 5 B -
41 SOLF-ID 4 5 B -
45 INSIDE 4 5 B -
Now select only the records that have forests , i.e. those areas with a grid code of 5 or 10, we do this for example choosing those areas with a grid code greater than 4.
ENTER COMMAND >RESELECT GRID-CODE > 4
14 RECORD(S) SELECTED
Now look at the area and tree types of the records selected.
ENTER COMMAND >LIST AREA,GRID-CODE
$RECNO AREA GRID-CODE
2 177,538,373.84919 10
3 2,833,466.95617 5
4 35,441,885.35774 5
5 185,316,929.93687 5
6 41,903.16372 5
7 19,080,584.42137 5
8 584,434.84816 5
9 16,356.30546 5
10 2,880.41905 5
11 92,777.05537 5
12 17,243,313.39498 5
13 56.13216 5
14 355,231.77168 5
15 277,401,397.42758 10
OK we have the areas of each of the logging polygons and their associated tree-types. We need some way of connecting the tree type with the cost per 100m squared of forest and also some way of converting the AREA which is meters squared into units of 100m squared. Finally we need to multiply the area in our units by the value of the timber to get the expected revenue. First let's get the value of the timber into INFO.
It would also be handy to have a field to put the total value of the timber in each polygon so we will add this in now as well.
We use the DEFINE command to tell INFO what items we want in the new file. At the INFO prompt type :
ENTER COMMAND >DEFINE COST.DAT
ITEM NAME,WIDTH [,OUTPUT WIDTH] ,TYPE [,DECIMAL PLACES] [,PROT.LEVEL]
1
ITEM NAME>GRID-CODE,4,8,B
5
ITEM NAME>COST,4,4,I
9
ITEM NAME>VALUE,8,18,F,2
17
ITEM NAME>
Okay now just hit the return key to close the new file. Note item GRID-CODE is the same as in FINAL.PAT.
ENTER COMMAND >SELECT COST.DAT
0 RECORD(S) SELECTED
Now add some records using the ADD command . Remember the yield for PINE is 100 dollars and OAK 200 dollars per 100 meters squared of forest. Notice we are just putting zeros in the VALUE field , don't worry about this for the moment, we will use this field later.
ENTER COMMAND >ADD
1
GRID-CODE>5
COST>200
VALUE>0
2
GRID-CODE>10
COST>100
VALUE>0
3
GRID-CODE>
Okay we now have the cost of oak and pine , just hit the return key to quit out of the ADD command , you should see :
2 RECORD(S) ADDED
Now to exit from INFO type :
ENTER COMMAND > Q STOP
Arc: joinitem
Usage: JOINITEM <in_info_file> <join_info_file> <out_info_file> <relate_item> <start_item> {LINEAR | ORDERED | LINK}
Arc: joinitem final.pat cost.dat final.pat grid-code inside
Joining final.pat and cost.dat to create final.pat
** Item "GRID-CODE" duplicated, Join File version dropped **
Arc:
COST.DAT contains two costs - 200 dollars for wood type 5 (OAK) and 100 dollars for wood type 10 (PINE) . During the join two new items COST and VALUE are added to the FINAL.PAT file. Everywhere in the FINAL.PAT file that had a GRID-CODE of 5 a COST of 20 and a VALUE of zero is added. Everywhere in the FINAL.PAT file that had a GRID-CODE of 10 a COST of 10 and a VALUE of zero is added. Look at the new FINAL.PAT:
Arc: items final.pat
COLUMN ITEM NAME WIDTH OUTPUT TYPE N.DEC
1 AREA 8 18 F 5
9 PERIMETER 8 18 F 5
17 FINAL# 4 5 B -
21 FINAL-ID 4 5 B -
25 FORESTPOLY# 4 5 B -
29 FORESTPOLY-ID 4 5 B -
33 GRID-CODE 4 8 B -
37 SOLF# 4 5 B -
41 SOLF-ID 4 5 B -
45 INSIDE 4 5 B -
49 COST 4 4 I -
53 VALUE 8 18 F 2
Arc: info INFO EXCHANGE CALL 24/06/1994 10:50:21 INFO 9.42 11/11/86 52.74.63* COPYRIGHT 1986 HENCO SOFTWARE, INC. PROPRIETARY TO HENCO SOFTWARE, INC. US GOVT AGENCIES SEE USAGE RESTRICTIONS IN HELP FILES (HELP RESTRICTIONS) ENTER USER NAME> INVALID USER NAME - MUST BE 3-8 CHARACTERS LONG ENTER USER NAME>ARC
Our values of timber is per 100 meters by 100 meters area, but our AREA field in FINAL.PAT is in square meters so firstly we need to calculate the area of each polygon in 100m X 100m units. To do this we use the CALCULATE.We will store this value for the moment in the VALUE field which is empty at the moment (remember the zeros typed in). At INFO type :
ENTER COMMAND >CALCULATE VALUE = AREA /10000
Now look at the result. Type :
ENTER COMMAND >LIST VALUE $RECNO VALUE 1 -715,949.5 2 177,538.3 3 2,833.4 4 3,5441.8 5 185,316.9 6 41.9 7 19,080.6 8 584.4 9 16.3 10 2.9 11 92.7 12 17,243.3 13 0.1 14 355.2 15 277,401.4
All we have to do now is multiply these 100m x 100m unit areas by the value of the timber for each area which is stored in the COST field , so type :
ENTER COMMAND >CALCULATE VALUE = VALUE * COST
Now look at the result.
ENTER COMMAND >LIST VALUE
$RECNO VALUE
1 00.0
2 1,775,383.7
3 5,6,669.3
4 708,837.7
5 3,706,338.6
6 838.1
7 381,611.7
8 11,688.7
9 327.1
10 57.6
11 1,855.5
12 34,4866.3
13 1.1
14 7,104.6
15 2,774,014.0
If we add these all up we get the total return on the logging operation to be nearly 10 million dollars. You have now finished your GIS course : CONGRATULATIONS !
Shane Murnion sdm@sfc.keio.ac.jp
go back
go home
A word from the author