Project

General

Profile

« Previous | Next » 

Revision 8216

Added by Aaron Marcuse-Kubitza almost 12 years ago

Removed unused inputs/FIA/COND_unique/. Use COND instead.

View differences:

inputs/FIA/COND_unique/map.csv
1 
FIA,VegCore,Filter,Comments
2 
row_num,row_num,,
3 
CN,CN,,
4 
PLT_CN,locationID,,
5 
INVYR,INVYR,,
6 
STATECD,STATECD,,
7 
UNITCD,UNITCD,,
8 
COUNTYCD,COUNTYCD,,
9 
PLOT,locationName,,
10 
CONDID,authorEventCode,,
11 
COND_STATUS_CD,COND_STATUS_CD,,
12 
COND_NONSAMPLE_REASN_CD,COND_NONSAMPLE_REASN_CD,,
13 
RESERVCD,RESERVCD,,
14 
OWNCD,OWNCD,,
15 
OWNGRPCD,OWNGRPCD,,
16 
FORINDCD,FORINDCD,,
17 
ADFORCD,ADFORCD,,
18 
FORTYPCD,FORTYPCD,,
19 
FLDTYPCD,FLDTYPCD,,
20 
MAPDEN,MAPDEN,,
21 
STDAGE,STDAGE,,
22 
STDSZCD,STDSZCD,,
23 
FLDSZCD,FLDSZCD,,
24 
SITECLCD,SITECLCD,,
25 
SICOND,SICOND,,
26 
SIBASE,SIBASE,,
27 
SISP,SISP,,
28 
STDORGCD,STDORGCD,,
29 
STDORGSP,STDORGSP,,
30 
PROP_BASIS,PROP_BASIS,,
31 
CONDPROP_UNADJ,CONDPROP_UNADJ,,
32 
MICRPROP_UNADJ,MICRPROP_UNADJ,,
33 
SUBPPROP_UNADJ,SUBPPROP_UNADJ,,
34 
MACRPROP_UNADJ,MACRPROP_UNADJ,,
35 
SLOPE,SLOPE,,
36 
ASPECT,ASPECT,,
37 
PHYSCLCD,PHYSCLCD,,
38 
GSSTKCD,GSSTKCD,,
39 
ALSTKCD,ALSTKCD,,
40 
DSTRBCD1,DSTRBCD1,,
41 
DSTRBYR1,DSTRBYR1,,
42 
DSTRBCD2,DSTRBCD2,,
43 
DSTRBYR2,DSTRBYR2,,
44 
DSTRBCD3,DSTRBCD3,,
45 
DSTRBYR3,DSTRBYR3,,
46 
TRTCD1,TRTCD1,,
47 
TRTYR1,TRTYR1,,
48 
TRTCD2,TRTCD2,,
49 
TRTYR2,TRTYR2,,
50 
TRTCD3,TRTCD3,,
51 
TRTYR3,TRTYR3,,
52 
PRESNFCD,PRESNFCD,,
53 
BALIVE,BALIVE,,
54 
FLDAGE,FLDAGE,,
55 
ALSTK,ALSTK,,
56 
GSSTK,GSSTK,,
57 
FORTYPCDCALC,FORTYPCDCALC,,
58 
HABTYPCD1,HABTYPCD1,,
59 
HABTYPCD1_PUB_CD,HABTYPCD1_PUB_CD,,
60 
HABTYPCD1_DESCR_PUB_CD,HABTYPCD1_DESCR_PUB_CD,,
61 
HABTYPCD2,HABTYPCD2,,
62 
HABTYPCD2_PUB_CD,HABTYPCD2_PUB_CD,,
63 
HABTYPCD2_DESCR_PUB_CD,HABTYPCD2_DESCR_PUB_CD,,
64 
MIXEDCONFCD,MIXEDCONFCD,,
65 
VOL_LOC_GRP,VOL_LOC_GRP,,
66 
SITECLCDEST,SITECLCDEST,,
67 
SITETREE_TREE,SITETREE_TREE,,
68 
SITECL_METHOD,SITECL_METHOD,,
69 
CARBON_DOWN_DEAD,CARBON_DOWN_DEAD,,
70 
CARBON_LITTER,CARBON_LITTER,,
71 
CARBON_SOIL_ORG,CARBON_SOIL_ORG,,
72 
CARBON_STANDING_DEAD,CARBON_STANDING_DEAD,,
73 
CARBON_UNDERSTORY_AG,CARBON_UNDERSTORY_AG,,
74 
CARBON_UNDERSTORY_BG,CARBON_UNDERSTORY_BG,,
75 
CREATED_BY,CREATED_BY,,
76 
CREATED_DATE,CREATED_DATE,,
77 
CREATED_IN_INSTANCE,CREATED_IN_INSTANCE,,
78 
MODIFIED_BY,MODIFIED_BY,,
79 
MODIFIED_DATE,MODIFIED_DATE,,
80 
MODIFIED_IN_INSTANCE,MODIFIED_IN_INSTANCE,,
81 
CYCLE,CYCLE,,
82 
SUBCYCLE,SUBCYCLE,,
83 
SOIL_ROOTING_DEPTH_PNW,SOIL_ROOTING_DEPTH_PNW,,
84 
GROUND_LAND_CLASS_PNW,GROUND_LAND_CLASS_PNW,,
85 
PLANT_STOCKABILITY_FACTOR_PNW,PLANT_STOCKABILITY_FACTOR_PNW,,
86 
STND_COND_CD_PNWRS,STND_COND_CD_PNWRS,,
87 
STND_STRUC_CD_PNWRS,STND_STRUC_CD_PNWRS,,
88 
STUMP_CD_PNWRS,STUMP_CD_PNWRS,,
89 
FIRE_SRS,FIRE_SRS,,
90 
GRAZING_SRS,GRAZING_SRS,,
91 
HARVEST_TYPE1_SRS,HARVEST_TYPE1_SRS,,
92 
HARVEST_TYPE2_SRS,HARVEST_TYPE2_SRS,,
93 
HARVEST_TYPE3_SRS,HARVEST_TYPE3_SRS,,
94 
LAND_USE_SRS,LAND_USE_SRS,,
95 
OPERABILITY_SRS,OPERABILITY_SRS,,
96 
STAND_STRUCTURE_SRS,STAND_STRUCTURE_SRS,,
97 
NF_COND_STATUS_CD,NF_COND_STATUS_CD,,
98 
NF_COND_NONSAMPLE_REASN_CD,NF_COND_NONSAMPLE_REASN_CD,,
99 
CANOPY_CVR_SAMPLE_METHOD_CD,CANOPY_CVR_SAMPLE_METHOD_CD,,
100 
LIVE_CANOPY_CVR_PCT,LIVE_CANOPY_CVR_PCT,,
101 
LIVE_MISSING_CANOPY_CVR_PCT,LIVE_MISSING_CANOPY_CVR_PCT,,
102 
NBR_LIVE_STEMS,NBR_LIVE_STEMS,,
103 
OWNSUBCD,OWNSUBCD,,
104 
INDUSTRIALCD_FIADB,INDUSTRIALCD_FIADB,,
105 
RESERVCD_FLD,RESERVCD_FLD,,
106 
ADMIN_WITHDRAWN_CD,ADMIN_WITHDRAWN_CD,,
107 
oldgrowth,oldGrowth,,
inputs/FIA/COND_unique/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <sourceaccessioncode>$PLT_CN</sourceaccessioncode>
11 
                        <iscultivated><_not><value>$oldgrowth</value></_not></iscultivated>
12 
                    </location>
13 
                </path>
14 
            </_simplifyPath>
15 
        </path>
16 
    </_setDefault>
17 
</VegBIEN>
18 
Inserted 3 new rows into database
inputs/FIA/COND_unique/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
PLT_CN,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 
PLT_CN,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
4 
PLT_CN,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
5 
oldgrowth,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/1/_not/value",
6 
PLT_CN,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
7 
PLT_CN,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
8 
oldgrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/1/_not/value",
9 
PLT_CN,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
10 
PLT_CN,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
11 
ADFORCD,,** No join mapping for *ADFORCD **
12 
ADMIN_WITHDRAWN_CD,,** No join mapping for *ADMIN_WITHDRAWN_CD **
13 
ALSTK,,** No join mapping for *ALSTK **
14 
ALSTKCD,,** No join mapping for *ALSTKCD **
15 
ASPECT,,** No join mapping for *ASPECT **
16 
BALIVE,,** No join mapping for *BALIVE **
17 
CANOPY_CVR_SAMPLE_METHOD_CD,,** No join mapping for *CANOPY_CVR_SAMPLE_METHOD_CD **
18 
CARBON_DOWN_DEAD,,** No join mapping for *CARBON_DOWN_DEAD **
19 
CARBON_LITTER,,** No join mapping for *CARBON_LITTER **
20 
CARBON_SOIL_ORG,,** No join mapping for *CARBON_SOIL_ORG **
21 
CARBON_STANDING_DEAD,,** No join mapping for *CARBON_STANDING_DEAD **
22 
CARBON_UNDERSTORY_AG,,** No join mapping for *CARBON_UNDERSTORY_AG **
23 
CARBON_UNDERSTORY_BG,,** No join mapping for *CARBON_UNDERSTORY_BG **
24 
CN,,** No join mapping for *CN **
25 
CONDID,,** No join mapping for *CONDID **
26 
CONDPROP_UNADJ,,** No join mapping for *CONDPROP_UNADJ **
27 
COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND_NONSAMPLE_REASN_CD **
28 
COND_STATUS_CD,,** No join mapping for *COND_STATUS_CD **
29 
COUNTYCD,,** No join mapping for *COUNTYCD **
30 
CREATED_BY,,** No join mapping for *CREATED_BY **
31 
CREATED_DATE,,** No join mapping for *CREATED_DATE **
32 
CREATED_IN_INSTANCE,,** No join mapping for *CREATED_IN_INSTANCE **
33 
CYCLE,,** No join mapping for *CYCLE **
34 
DSTRBCD1,,** No join mapping for *DSTRBCD1 **
35 
DSTRBCD2,,** No join mapping for *DSTRBCD2 **
36 
DSTRBCD3,,** No join mapping for *DSTRBCD3 **
37 
DSTRBYR1,,** No join mapping for *DSTRBYR1 **
38 
DSTRBYR2,,** No join mapping for *DSTRBYR2 **
39 
DSTRBYR3,,** No join mapping for *DSTRBYR3 **
40 
FIRE_SRS,,** No join mapping for *FIRE_SRS **
41 
FLDAGE,,** No join mapping for *FLDAGE **
42 
FLDSZCD,,** No join mapping for *FLDSZCD **
43 
FLDTYPCD,,** No join mapping for *FLDTYPCD **
44 
FORINDCD,,** No join mapping for *FORINDCD **
45 
FORTYPCD,,** No join mapping for *FORTYPCD **
46 
FORTYPCDCALC,,** No join mapping for *FORTYPCDCALC **
47 
GRAZING_SRS,,** No join mapping for *GRAZING_SRS **
48 
GROUND_LAND_CLASS_PNW,,** No join mapping for *GROUND_LAND_CLASS_PNW **
49 
GSSTK,,** No join mapping for *GSSTK **
50 
GSSTKCD,,** No join mapping for *GSSTKCD **
51 
HABTYPCD1,,** No join mapping for *HABTYPCD1 **
52 
HABTYPCD1_DESCR_PUB_CD,,** No join mapping for *HABTYPCD1_DESCR_PUB_CD **
53 
HABTYPCD1_PUB_CD,,** No join mapping for *HABTYPCD1_PUB_CD **
54 
HABTYPCD2,,** No join mapping for *HABTYPCD2 **
55 
HABTYPCD2_DESCR_PUB_CD,,** No join mapping for *HABTYPCD2_DESCR_PUB_CD **
56 
HABTYPCD2_PUB_CD,,** No join mapping for *HABTYPCD2_PUB_CD **
57 
HARVEST_TYPE1_SRS,,** No join mapping for *HARVEST_TYPE1_SRS **
58 
HARVEST_TYPE2_SRS,,** No join mapping for *HARVEST_TYPE2_SRS **
59 
HARVEST_TYPE3_SRS,,** No join mapping for *HARVEST_TYPE3_SRS **
60 
INDUSTRIALCD_FIADB,,** No join mapping for *INDUSTRIALCD_FIADB **
61 
INVYR,,** No join mapping for *INVYR **
62 
LAND_USE_SRS,,** No join mapping for *LAND_USE_SRS **
63 
LIVE_CANOPY_CVR_PCT,,** No join mapping for *LIVE_CANOPY_CVR_PCT **
64 
LIVE_MISSING_CANOPY_CVR_PCT,,** No join mapping for *LIVE_MISSING_CANOPY_CVR_PCT **
65 
MACRPROP_UNADJ,,** No join mapping for *MACRPROP_UNADJ **
66 
MAPDEN,,** No join mapping for *MAPDEN **
67 
MICRPROP_UNADJ,,** No join mapping for *MICRPROP_UNADJ **
68 
MIXEDCONFCD,,** No join mapping for *MIXEDCONFCD **
69 
MODIFIED_BY,,** No join mapping for *MODIFIED_BY **
70 
MODIFIED_DATE,,** No join mapping for *MODIFIED_DATE **
71 
MODIFIED_IN_INSTANCE,,** No join mapping for *MODIFIED_IN_INSTANCE **
72 
NBR_LIVE_STEMS,,** No join mapping for *NBR_LIVE_STEMS **
73 
NF_COND_NONSAMPLE_REASN_CD,,** No join mapping for *NF_COND_NONSAMPLE_REASN_CD **
74 
NF_COND_STATUS_CD,,** No join mapping for *NF_COND_STATUS_CD **
75 
OPERABILITY_SRS,,** No join mapping for *OPERABILITY_SRS **
76 
OWNCD,,** No join mapping for *OWNCD **
77 
OWNGRPCD,,** No join mapping for *OWNGRPCD **
78 
OWNSUBCD,,** No join mapping for *OWNSUBCD **
79 
PHYSCLCD,,** No join mapping for *PHYSCLCD **
80 
PLANT_STOCKABILITY_FACTOR_PNW,,** No join mapping for *PLANT_STOCKABILITY_FACTOR_PNW **
81 
PLOT,,** No join mapping for *PLOT **
82 
PRESNFCD,,** No join mapping for *PRESNFCD **
83 
PROP_BASIS,,** No join mapping for *PROP_BASIS **
84 
RESERVCD,,** No join mapping for *RESERVCD **
85 
RESERVCD_FLD,,** No join mapping for *RESERVCD_FLD **
86 
SIBASE,,** No join mapping for *SIBASE **
87 
SICOND,,** No join mapping for *SICOND **
88 
SISP,,** No join mapping for *SISP **
89 
SITECLCD,,** No join mapping for *SITECLCD **
90 
SITECLCDEST,,** No join mapping for *SITECLCDEST **
91 
SITECL_METHOD,,** No join mapping for *SITECL_METHOD **
92 
SITETREE_TREE,,** No join mapping for *SITETREE_TREE **
93 
SLOPE,,** No join mapping for *SLOPE **
94 
SOIL_ROOTING_DEPTH_PNW,,** No join mapping for *SOIL_ROOTING_DEPTH_PNW **
95 
STAND_STRUCTURE_SRS,,** No join mapping for *STAND_STRUCTURE_SRS **
96 
STATECD,,** No join mapping for *STATECD **
97 
STDAGE,,** No join mapping for *STDAGE **
98 
STDORGCD,,** No join mapping for *STDORGCD **
99 
STDORGSP,,** No join mapping for *STDORGSP **
100 
STDSZCD,,** No join mapping for *STDSZCD **
101 
STND_COND_CD_PNWRS,,** No join mapping for *STND_COND_CD_PNWRS **
102 
STND_STRUC_CD_PNWRS,,** No join mapping for *STND_STRUC_CD_PNWRS **
103 
STUMP_CD_PNWRS,,** No join mapping for *STUMP_CD_PNWRS **
104 
SUBCYCLE,,** No join mapping for *SUBCYCLE **
105 
SUBPPROP_UNADJ,,** No join mapping for *SUBPPROP_UNADJ **
106 
TRTCD1,,** No join mapping for *TRTCD1 **
107 
TRTCD2,,** No join mapping for *TRTCD2 **
108 
TRTCD3,,** No join mapping for *TRTCD3 **
109 
TRTYR1,,** No join mapping for *TRTYR1 **
110 
TRTYR2,,** No join mapping for *TRTYR2 **
111 
TRTYR3,,** No join mapping for *TRTYR3 **
112 
UNITCD,,** No join mapping for *UNITCD **
113 
VOL_LOC_GRP,,** No join mapping for *VOL_LOC_GRP **
114 
row_num,,** No join mapping for *row_num **
inputs/FIA/COND_unique/new_terms.csv
1 
PLT_CN,locationID,,
2 
PLOT,locationName,,
3 
CONDID,authorEventCode,,
inputs/FIA/COND_unique/unmapped_terms.csv
1 
*row_num
2 
*CN
3 
*INVYR
4 
*STATECD
5 
*UNITCD
6 
*COUNTYCD
7 
*COND_STATUS_CD
8 
*COND_NONSAMPLE_REASN_CD
9 
*RESERVCD
10 
*OWNCD
11 
*OWNGRPCD
12 
*FORINDCD
13 
*ADFORCD
14 
*FORTYPCD
15 
*FLDTYPCD
16 
*MAPDEN
17 
*STDAGE
18 
*STDSZCD
19 
*FLDSZCD
20 
*SITECLCD
21 
*SICOND
22 
*SIBASE
23 
*SISP
24 
*STDORGCD
25 
*STDORGSP
26 
*PROP_BASIS
27 
*CONDPROP_UNADJ
28 
*MICRPROP_UNADJ
29 
*SUBPPROP_UNADJ
30 
*MACRPROP_UNADJ
31 
*SLOPE
32 
*ASPECT
33 
*PHYSCLCD
34 
*GSSTKCD
35 
*ALSTKCD
36 
*DSTRBCD1
37 
*DSTRBYR1
38 
*DSTRBCD2
39 
*DSTRBYR2
40 
*DSTRBCD3
41 
*DSTRBYR3
42 
*TRTCD1
43 
*TRTYR1
44 
*TRTCD2
45 
*TRTYR2
46 
*TRTCD3
47 
*TRTYR3
48 
*PRESNFCD
49 
*BALIVE
50 
*FLDAGE
51 
*ALSTK
52 
*GSSTK
53 
*FORTYPCDCALC
54 
*HABTYPCD1
55 
*HABTYPCD1_PUB_CD
56 
*HABTYPCD1_DESCR_PUB_CD
57 
*HABTYPCD2
58 
*HABTYPCD2_PUB_CD
59 
*HABTYPCD2_DESCR_PUB_CD
60 
*MIXEDCONFCD
61 
*VOL_LOC_GRP
62 
*SITECLCDEST
63 
*SITETREE_TREE
64 
*SITECL_METHOD
65 
*CARBON_DOWN_DEAD
66 
*CARBON_LITTER
67 
*CARBON_SOIL_ORG
68 
*CARBON_STANDING_DEAD
69 
*CARBON_UNDERSTORY_AG
70 
*CARBON_UNDERSTORY_BG
71 
*CREATED_BY
72 
*CREATED_DATE
73 
*CREATED_IN_INSTANCE
74 
*MODIFIED_BY
75 
*MODIFIED_DATE
76 
*MODIFIED_IN_INSTANCE
77 
*CYCLE
78 
*SUBCYCLE
79 
*SOIL_ROOTING_DEPTH_PNW
80 
*GROUND_LAND_CLASS_PNW
81 
*PLANT_STOCKABILITY_FACTOR_PNW
82 
*STND_COND_CD_PNWRS
83 
*STND_STRUC_CD_PNWRS
84 
*STUMP_CD_PNWRS
85 
*FIRE_SRS
86 
*GRAZING_SRS
87 
*HARVEST_TYPE1_SRS
88 
*HARVEST_TYPE2_SRS
89 
*HARVEST_TYPE3_SRS
90 
*LAND_USE_SRS
91 
*OPERABILITY_SRS
92 
*STAND_STRUCTURE_SRS
93 
*NF_COND_STATUS_CD
94 
*NF_COND_NONSAMPLE_REASN_CD
95 
*CANOPY_CVR_SAMPLE_METHOD_CD
96 
*LIVE_CANOPY_CVR_PCT
97 
*LIVE_MISSING_CANOPY_CVR_PCT
98 
*NBR_LIVE_STEMS
99 
*OWNSUBCD
100 
*INDUSTRIALCD_FIADB
101 
*RESERVCD_FLD
102 
*ADMIN_WITHDRAWN_CD
inputs/FIA/COND_unique/create.sql
1 
SELECT
2 
DISTINCT ON ("PLT_CN")
3 
*
4 
,
5 
    (
6 
        "STDAGE"::integer>80
7 
        AND ("TRTCD1"='0' OR "TRTCD1" IS NULL)
8 
        AND (("DSTRBCD1"<>'30' AND "DSTRBCD1"<>'31' AND "DSTRBCD1"<>'32' AND "DSTRBCD1"<>'80') OR "DSTRBCD1" IS NULL)
9 
        AND ("STUMP_CD_PNWRS"='N' OR "STUMP_CD_PNWRS" IS NULL)
10 
        AND "HARVEST_TYPE1_SRS" IS NULL
11 
        AND "PRESNFCD" IS NULL
12 
        AND ("STDORGCD"='0' OR "STDORGCD" IS NULL)
13 
    )
14 
    OR "STND_COND_CD_PNWRS"='7'
15 
    AS oldgrowth
16 
FROM "COND"
17 
;
18 

  		




  19
  
  
    
ALTER TABLE :table ADD PRIMARY KEY ("PLT_CN");


  		












  

    
      inputs/FIA/COND_unique/header.csv
    
  





  1
  
  
    
row_num,CN,PLT_CN,INVYR,STATECD,UNITCD,COUNTYCD,PLOT,CONDID,COND_STATUS_CD,COND_NONSAMPLE_REASN_CD,RESERVCD,OWNCD,OWNGRPCD,FORINDCD,ADFORCD,FORTYPCD,FLDTYPCD,MAPDEN,STDAGE,STDSZCD,FLDSZCD,SITECLCD,SICOND,SIBASE,SISP,STDORGCD,STDORGSP,PROP_BASIS,CONDPROP_UNADJ,MICRPROP_UNADJ,SUBPPROP_UNADJ,MACRPROP_UNADJ,SLOPE,ASPECT,PHYSCLCD,GSSTKCD,ALSTKCD,DSTRBCD1,DSTRBYR1,DSTRBCD2,DSTRBYR2,DSTRBCD3,DSTRBYR3,TRTCD1,TRTYR1,TRTCD2,TRTYR2,TRTCD3,TRTYR3,PRESNFCD,BALIVE,FLDAGE,ALSTK,GSSTK,FORTYPCDCALC,HABTYPCD1,HABTYPCD1_PUB_CD,HABTYPCD1_DESCR_PUB_CD,HABTYPCD2,HABTYPCD2_PUB_CD,HABTYPCD2_DESCR_PUB_CD,MIXEDCONFCD,VOL_LOC_GRP,SITECLCDEST,SITETREE_TREE,SITECL_METHOD,CARBON_DOWN_DEAD,CARBON_LITTER,CARBON_SOIL_ORG,CARBON_STANDING_DEAD,CARBON_UNDERSTORY_AG,CARBON_UNDERSTORY_BG,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE,CYCLE,SUBCYCLE,SOIL_ROOTING_DEPTH_PNW,GROUND_LAND_CLASS_PNW,PLANT_STOCKABILITY_FACTOR_PNW,STND_COND_CD_PNWRS,STND_STRUC_CD_PNWRS,STUMP_CD_PNWRS,FIRE_SRS,GRAZING_SRS,HARVEST_TYPE1_SRS,HARVEST_TYPE2_SRS,HARVEST_TYPE3_SRS,LAND_USE_SRS,OPERABILITY_SRS,STAND_STRUCTURE_SRS,NF_COND_STATUS_CD,NF_COND_NONSAMPLE_REASN_CD,CANOPY_CVR_SAMPLE_METHOD_CD,LIVE_CANOPY_CVR_PCT,LIVE_MISSING_CANOPY_CVR_PCT,NBR_LIVE_STEMS,OWNSUBCD,INDUSTRIALCD_FIADB,RESERVCD_FLD,ADMIN_WITHDRAWN_CD,oldgrowth


  		












Also available in:  Unified diff