Project

General

Profile

« Previous | Next » 

Revision 10950

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/FIA/occurrence_all/: renamed to taxon_observation.** to clarify what an occurrence is. taxon_observation has the same meaning as in VegCore, where each taxon_determination is considered a separate taxon_observation of the associated specimen or vouchered plant (vegpath.org/VegCore/ERD/). (note that having multiple taxon_determinations only makes sense when there is something to reobserve.) the .** is SQL dotpath syntax (wiki.vegpath.org/SQL_dotpaths) for the recursive expansion of all tables to which taxon_observation has forward fkeys (i.e. "the left-join").

View differences:

inputs/FIA/occurrence_all/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>FIA.new</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <parent_id>
11 
                            <location>
12 
                                <authorlocationcode>$locationName</authorlocationcode>
13 
                                <sourceaccessioncode>$locationID</sourceaccessioncode>
14 
                            </location>
15 
                        </parent_id>
16 
                        <authorlocationcode>$subplot</authorlocationcode>
17 
                        <locationevent>
18 
                            <parent_id>
19 
                                <locationevent>
20 
                                    <location_id>
21 
                                        <location>
22 
                                            <authorlocationcode>
23 
                                                <_if name="if subplot">
24 
                                                    <cond>$subplotID</cond>
25 
                                                    <then>$locationName</then>
26 
                                                </_if>
27 
                                            </authorlocationcode>
28 
                                            <sourceaccessioncode>
29 
                                                <_if name="if subplot">
30 
                                                    <cond>$subplotID</cond>
31 
                                                    <then>$locationID</then>
32 
                                                </_if>
33 
                                            </sourceaccessioncode>
34 
                                        </location>
35 
                                    </location_id>
36 
                                    <authoreventcode>$authorEventCode</authoreventcode>
37 
                                </locationevent>
38 
                            </parent_id>
39 
                            <commclass>
40 
                                <commdetermination>
41 
                                    <commconcept_id>
42 
                                        <commconcept>
43 
                                            <commname_id><commname><commname>$communityID</commname></commname></commname_id>
44 
                                            <commdescription>$communityName</commdescription>
45 
                                        </commconcept>
46 
                                    </commconcept_id>
47 
                                </commdetermination>
48 
                            </commclass>
49 
                            <taxonoccurrence>
50 
                                <aggregateoccurrence>
51 
                                    <plantobservation>
52 
                                        <authorplantcode>$individualCode</authorplantcode>
53 
                                        <sourceaccessioncode>$individualObservationID</sourceaccessioncode>
54 
                                        <stemobservation>
55 
                                            <diameterbreastheight_m><_in_to_m><value>$diameterBreastHeight_in</value></_in_to_m></diameterbreastheight_m>
56 
                                            <height_m><_ft_to_m><value>$height_ft</value></_ft_to_m></height_m>
57 
                                        </stemobservation>
58 
                                    </plantobservation>
59 
                                </aggregateoccurrence>
60 
                                <authortaxoncode>$individualCode</authortaxoncode>
61 
                                <iscultivated>$cultivated</iscultivated>
62 
                                <sourceaccessioncode>$individualObservationID</sourceaccessioncode>
63 
                                <taxondetermination>
64 
                                    <taxonverbatim_id>
65 
                                        <taxonverbatim>
66 
                                            <taxonlabel_id>
67 
                                                <taxonlabel>
68 
                                                    <parent_id>
69 
                                                        <taxonlabel>
70 
                                                            <parent_id>
71 
                                                                <taxonlabel>
72 
                                                                    <rank>cultivar</rank>
73 
                                                                    <parent_id>
74 
                                                                        <taxonlabel>
75 
                                                                            <rank>forma</rank>
76 
                                                                            <taxonepithet>$forma</taxonepithet>
77 
                                                                            <parent_id>
78 
                                                                                <taxonlabel>
79 
                                                                                    <rank>variety</rank>
80 
                                                                                    <taxonepithet>$variety</taxonepithet>
81 
                                                                                    <parent_id>
82 
                                                                                        <taxonlabel>
83 
                                                                                            <rank>subspecies</rank>
84 
                                                                                            <taxonepithet>$subspecies</taxonepithet>
85 
                                                                                            <parent_id>
86 
                                                                                                <taxonlabel>
87 
                                                                                                    <rank>species</rank>
88 
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
89 
                                                                                                    <parent_id>
90 
                                                                                                        <taxonlabel>
91 
                                                                                                            <rank>genus</rank>
92 
                                                                                                            <taxonepithet>$genus</taxonepithet>
93 
                                                                                                            <parent_id>
94 
                                                                                                                <taxonlabel>
95 
                                                                                                                    <rank>family</rank>
96 
                                                                                                                    <taxonepithet>$family</taxonepithet>
97 
                                                                                                                </taxonlabel>
98 
                                                                                                            </parent_id>
99 
                                                                                                        </taxonlabel>
100 
                                                                                                    </parent_id>
101 
                                                                                                </taxonlabel>
102 
                                                                                            </parent_id>
103 
                                                                                        </taxonlabel>
104 
                                                                                    </parent_id>
105 
                                                                                </taxonlabel>
106 
                                                                            </parent_id>
107 
                                                                        </taxonlabel>
108 
                                                                    </parent_id>
109 
                                                                </taxonlabel>
110 
                                                            </parent_id>
111 
                                                        </taxonlabel>
112 
                                                    </parent_id>
113 
                                                    <taxonomicname>
114 
                                                        <_merge_prefix>
115 
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
116 
                                                            <value>
117 
                                                                <_alt>
118 
                                                                    <1>$scientificName</1>
119 
                                                                    <2>
120 
                                                                        <_alt>
121 
                                                                            <1>$taxonName</1>
122 
                                                                            <2>
123 
                                                                                <_join_words>
124 
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>
125 
                                                                                    <3>$specificEpithet</3>
126 
                                                                                    <4>$subspecies</4>
127 
                                                                                    <6>
128 
                                                                                        <_join_words>
129 
                                                                                            <1>var. </1>
130 
                                                                                            <2>$variety</2>
131 
                                                                                        </_join_words>
132 
                                                                                    </6>
133 
                                                                                    <7>
134 
                                                                                        <_join_words>
135 
                                                                                            <1>fm. </1>
136 
                                                                                            <2>$forma</2>
137 
                                                                                        </_join_words>
138 
                                                                                    </7>
139 
                                                                                </_join_words>
140 
                                                                            </2>
141 
                                                                        </_alt>
142 
                                                                    </2>
143 
                                                                </_alt>
144 
                                                            </value>
145 
                                                        </_merge_prefix>
146 
                                                    </taxonomicname>
147 
                                                </taxonlabel>
148 
                                            </taxonlabel_id>
149 
                                            <family>$family</family>
150 
                                            <genus>$genus</genus>
151 
                                            <specific_epithet>$specificEpithet</specific_epithet>
152 
                                            <taxonname>$taxonName</taxonname>
153 
                                            <taxonomicname>$scientificName</taxonomicname>
154 
                                        </taxonverbatim>
155 
                                    </taxonverbatim_id>
156 
                                </taxondetermination>
157 
                            </taxonoccurrence>
158 
                        </locationevent>
159 
                        <locationplace>
160 
                            <place_id>
161 
                                <place>
162 
                                    <coordinates_id>
163 
                                        <coordinates>
164 
                                            <latitude_deg>
165 
                                                <_nullIf>
166 
                                                    <null>0</null>
167 
                                                    <type>float</type>
168 
                                                    <value>$decimalLatitude</value>
169 
                                                </_nullIf>
170 
                                            </latitude_deg>
171 
                                            <longitude_deg>
172 
                                                <_nullIf>
173 
                                                    <null>0</null>
174 
                                                    <type>float</type>
175 
                                                    <value>$decimalLongitude</value>
176 
                                                </_nullIf>
177 
                                            </longitude_deg>
178 
                                        </coordinates>
179 
                                    </coordinates_id>
180 
                                    <county>$county</county>
181 
                                    <matched_place_id>
182 
                                        <place>
183 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
184 
                                            <coordinates_id>
185 
                                                <coordinates>
186 
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
187 
                                                    <latitude_deg>
188 
                                                        <_nullIf>
189 
                                                            <null>0</null>
190 
                                                            <type>float</type>
191 
                                                            <value>$decimalLatitude</value>
192 
                                                        </_nullIf>
193 
                                                    </latitude_deg>
194 
                                                    <longitude_deg>
195 
                                                        <_nullIf>
196 
                                                            <null>0</null>
197 
                                                            <type>float</type>
198 
                                                            <value>$decimalLongitude</value>
199 
                                                        </_nullIf>
200 
                                                    </longitude_deg>
201 
                                                </coordinates>
202 
                                            </coordinates_id>
203 
                                            <county>$county</county>
204 
                                            <stateprovince>$stateProvince</stateprovince>
205 
                                        </place>
206 
                                    </matched_place_id>
207 
                                    <stateprovince>$stateProvince</stateprovince>
208 
                                </place>
209 
                            </place_id>
210 
                        </locationplace>
211 
                        <slopeaspect_deg><_compass><value>$slopeAspect</value></_compass></slopeaspect_deg>
212 
                        <slopegradient_fraction>$slopeGradient</slopegradient_fraction>
213 
                        <sourceaccessioncode>$subplotID</sourceaccessioncode>
214 
                    </location>
215 
                </path>
216 
            </_simplifyPath>
217 
        </path>
218 
    </_setDefault>
219 
</VegBIEN>
220 
Inserted 27 new rows into database
inputs/FIA/occurrence_all/VegBIEN.csv
1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
3 
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists",
4 
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
5 
locationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
6 
authorEventCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
7 
locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
8 
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
9 
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
10 
subplot,/location/authorlocationcode,
11 
individualObservationID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
12 
cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_first/1",
13 
oldGrowth,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_first/2/_not/value",
14 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
15 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
16 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
17 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
18 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/1",
19 
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2",
20 
locationName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
21 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/1",
22 
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",
23 
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
24 
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",
25 
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
26 
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
27 
individualCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,
28 
individualObservationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/1,
29 
diameterBreastHeight_in,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_in_to_m/value,
30 
height_ft,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m/_ft_to_m/value,
31 
authorEventCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
32 
locationID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
33 
locationName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
34 
individualObservationID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",
35 
individualCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",
36 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
37 
taxonName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
38 
individualObservationID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
39 
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_first/1",
40 
oldGrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_first/2/_not/value",
41 
individualObservationID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/1",
42 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet",
43 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet",
44 
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
45 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
46 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
47 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
48 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,
49 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,
50 
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
51 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,
52 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
53 
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4,
54 
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
55 
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
56 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
57 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
58 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
59 
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
60 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,
61 
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
62 
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
63 
county,/location/locationplace/*_id/place/county,
64 
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
65 
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
66 
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
67 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
68 
stateProvince,/location/locationplace/*_id/place/stateprovince,
69 
slopeAspect,/location/slopeaspect_deg/_alt/1/_compass/value,
70 
slopeGradient,/location/slopegradient_fraction/_alt/1,
71 
subplotID,/location/sourceaccessioncode/_first/1,
72 
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
73 
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
74 
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
75 
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
76 
*BOLEHT,,** No join mapping for *BOLEHT **
77 
*COND-ADFORCD,,** No join mapping for *COND-ADFORCD **
78 
*COND-ADMIN_WITHDRAWN_CD,,** No join mapping for *COND-ADMIN_WITHDRAWN_CD **
79 
*COND-ALSTK,,** No join mapping for *COND-ALSTK **
80 
*COND-ALSTKCD,,** No join mapping for *COND-ALSTKCD **
81 
*COND-BALIVE,,** No join mapping for *COND-BALIVE **
82 
*COND-CANOPY_CVR_SAMPLE_METHOD_CD,,** No join mapping for *COND-CANOPY_CVR_SAMPLE_METHOD_CD **
83 
*COND-CARBON_DOWN_DEAD,,** No join mapping for *COND-CARBON_DOWN_DEAD **
84 
*COND-CARBON_LITTER,,** No join mapping for *COND-CARBON_LITTER **
85 
*COND-CARBON_SOIL_ORG,,** No join mapping for *COND-CARBON_SOIL_ORG **
86 
*COND-CARBON_STANDING_DEAD,,** No join mapping for *COND-CARBON_STANDING_DEAD **
87 
*COND-CARBON_UNDERSTORY_AG,,** No join mapping for *COND-CARBON_UNDERSTORY_AG **
88 
*COND-CARBON_UNDERSTORY_BG,,** No join mapping for *COND-CARBON_UNDERSTORY_BG **
89 
*COND-CN,,** No join mapping for *COND-CN **
90 
*COND-CONDPROP_UNADJ,,** No join mapping for *COND-CONDPROP_UNADJ **
91 
*COND-COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND-COND_NONSAMPLE_REASN_CD **
92 
*COND-COND_STATUS_CD,,** No join mapping for *COND-COND_STATUS_CD **
93 
*COND-CREATED_BY,,** No join mapping for *COND-CREATED_BY **
94 
*COND-CREATED_DATE,,** No join mapping for *COND-CREATED_DATE **
95 
*COND-CREATED_IN_INSTANCE,,** No join mapping for *COND-CREATED_IN_INSTANCE **
96 
*COND-CYCLE,,** No join mapping for *COND-CYCLE **
97 
*COND-DSTRBCD1,,** No join mapping for *COND-DSTRBCD1 **
98 
*COND-DSTRBCD2,,** No join mapping for *COND-DSTRBCD2 **
99 
*COND-DSTRBCD3,,** No join mapping for *COND-DSTRBCD3 **
100 
*COND-DSTRBYR1,,** No join mapping for *COND-DSTRBYR1 **
101 
*COND-DSTRBYR2,,** No join mapping for *COND-DSTRBYR2 **
102 
*COND-DSTRBYR3,,** No join mapping for *COND-DSTRBYR3 **
103 
*COND-FIRE_SRS,,** No join mapping for *COND-FIRE_SRS **
104 
*COND-FLDAGE,,** No join mapping for *COND-FLDAGE **
105 
*COND-FLDSZCD,,** No join mapping for *COND-FLDSZCD **
106 
*COND-FLDTYPCD,,** No join mapping for *COND-FLDTYPCD **
107 
*COND-FORINDCD,,** No join mapping for *COND-FORINDCD **
108 
*COND-FORTYPCD,,** No join mapping for *COND-FORTYPCD **
109 
*COND-FORTYPCDCALC,,** No join mapping for *COND-FORTYPCDCALC **
110 
*COND-GRAZING_SRS,,** No join mapping for *COND-GRAZING_SRS **
111 
*COND-GROUND_LAND_CLASS_PNW,,** No join mapping for *COND-GROUND_LAND_CLASS_PNW **
112 
*COND-GSSTK,,** No join mapping for *COND-GSSTK **
113 
*COND-GSSTKCD,,** No join mapping for *COND-GSSTKCD **
114 
*COND-HABTYPCD1_DESCR_PUB_CD,,** No join mapping for *COND-HABTYPCD1_DESCR_PUB_CD **
115 
*COND-HABTYPCD2,,** No join mapping for *COND-HABTYPCD2 **
116 
*COND-HABTYPCD2_DESCR_PUB_CD,,** No join mapping for *COND-HABTYPCD2_DESCR_PUB_CD **
117 
*COND-HABTYPCD2_PUB_CD,,** No join mapping for *COND-HABTYPCD2_PUB_CD **
118 
*COND-HARVEST_TYPE1_SRS,,** No join mapping for *COND-HARVEST_TYPE1_SRS **
119 
*COND-HARVEST_TYPE2_SRS,,** No join mapping for *COND-HARVEST_TYPE2_SRS **
120 
*COND-HARVEST_TYPE3_SRS,,** No join mapping for *COND-HARVEST_TYPE3_SRS **
121 
*COND-INDUSTRIALCD_FIADB,,** No join mapping for *COND-INDUSTRIALCD_FIADB **
122 
*COND-LAND_USE_SRS,,** No join mapping for *COND-LAND_USE_SRS **
123 
*COND-LIVE_CANOPY_CVR_PCT,,** No join mapping for *COND-LIVE_CANOPY_CVR_PCT **
124 
*COND-LIVE_MISSING_CANOPY_CVR_PCT,,** No join mapping for *COND-LIVE_MISSING_CANOPY_CVR_PCT **
125 
*COND-MACRPROP_UNADJ,,** No join mapping for *COND-MACRPROP_UNADJ **
126 
*COND-MAPDEN,,** No join mapping for *COND-MAPDEN **
127 
*COND-MICRPROP_UNADJ,,** No join mapping for *COND-MICRPROP_UNADJ **
128 
*COND-MIXEDCONFCD,,** No join mapping for *COND-MIXEDCONFCD **
129 
*COND-MODIFIED_BY,,** No join mapping for *COND-MODIFIED_BY **
130 
*COND-MODIFIED_DATE,,** No join mapping for *COND-MODIFIED_DATE **
131 
*COND-MODIFIED_IN_INSTANCE,,** No join mapping for *COND-MODIFIED_IN_INSTANCE **
132 
*COND-NBR_LIVE_STEMS,,** No join mapping for *COND-NBR_LIVE_STEMS **
133 
*COND-NF_COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND-NF_COND_NONSAMPLE_REASN_CD **
134 
*COND-NF_COND_STATUS_CD,,** No join mapping for *COND-NF_COND_STATUS_CD **
135 
*COND-OPERABILITY_SRS,,** No join mapping for *COND-OPERABILITY_SRS **
136 
*COND-OWNCD,,** No join mapping for *COND-OWNCD **
137 
*COND-OWNGRPCD,,** No join mapping for *COND-OWNGRPCD **
138 
*COND-OWNSUBCD,,** No join mapping for *COND-OWNSUBCD **
139 
*COND-PHYSCLCD,,** No join mapping for *COND-PHYSCLCD **
140 
*COND-PLANT_STOCKABILITY_FACTOR_PNW,,** No join mapping for *COND-PLANT_STOCKABILITY_FACTOR_PNW **
141 
*COND-PLT_CN,,** No join mapping for *COND-PLT_CN **
142 
*COND-PRESNFCD,,** No join mapping for *COND-PRESNFCD **
143 
*COND-PROP_BASIS,,** No join mapping for *COND-PROP_BASIS **
144 
*COND-RESERVCD,,** No join mapping for *COND-RESERVCD **
145 
*COND-RESERVCD_FLD,,** No join mapping for *COND-RESERVCD_FLD **
146 
*COND-SIBASE,,** No join mapping for *COND-SIBASE **
147 
*COND-SICOND,,** No join mapping for *COND-SICOND **
148 
*COND-SISP,,** No join mapping for *COND-SISP **
149 
*COND-SITECLCD,,** No join mapping for *COND-SITECLCD **
150 
*COND-SITECLCDEST,,** No join mapping for *COND-SITECLCDEST **
151 
*COND-SITECL_METHOD,,** No join mapping for *COND-SITECL_METHOD **
152 
*COND-SITETREE_TREE,,** No join mapping for *COND-SITETREE_TREE **
153 
*COND-SOIL_ROOTING_DEPTH_PNW,,** No join mapping for *COND-SOIL_ROOTING_DEPTH_PNW **
154 
*COND-STAND_STRUCTURE_SRS,,** No join mapping for *COND-STAND_STRUCTURE_SRS **
155 
*COND-STDAGE,,** No join mapping for *COND-STDAGE **
156 
*COND-STDORGCD,,** No join mapping for *COND-STDORGCD **
157 
*COND-STDORGSP,,** No join mapping for *COND-STDORGSP **
158 
*COND-STDSZCD,,** No join mapping for *COND-STDSZCD **
159 
*COND-STND_COND_CD_PNWRS,,** No join mapping for *COND-STND_COND_CD_PNWRS **
160 
*COND-STND_STRUC_CD_PNWRS,,** No join mapping for *COND-STND_STRUC_CD_PNWRS **
161 
*COND-STUMP_CD_PNWRS,,** No join mapping for *COND-STUMP_CD_PNWRS **
162 
*COND-SUBCYCLE,,** No join mapping for *COND-SUBCYCLE **
163 
*COND-SUBPPROP_UNADJ,,** No join mapping for *COND-SUBPPROP_UNADJ **
164 
*COND-TRTCD1,,** No join mapping for *COND-TRTCD1 **
165 
*COND-TRTCD2,,** No join mapping for *COND-TRTCD2 **
166 
*COND-TRTCD3,,** No join mapping for *COND-TRTCD3 **
167 
*COND-TRTYR1,,** No join mapping for *COND-TRTYR1 **
168 
*COND-TRTYR2,,** No join mapping for *COND-TRTYR2 **
169 
*COND-TRTYR3,,** No join mapping for *COND-TRTYR3 **
170 
*COND-VOL_LOC_GRP,,** No join mapping for *COND-VOL_LOC_GRP **
171 
*COND-row_num,,** No join mapping for *COND-row_num **
172 
*COUNTY-CN,,** No join mapping for *COUNTY-CN **
173 
*COUNTY-CREATED_BY,,** No join mapping for *COUNTY-CREATED_BY **
174 
*COUNTY-CREATED_DATE,,** No join mapping for *COUNTY-CREATED_DATE **
175 
*COUNTY-CREATED_IN_INSTANCE,,** No join mapping for *COUNTY-CREATED_IN_INSTANCE **
176 
*COUNTY-MODIFIED_BY,,** No join mapping for *COUNTY-MODIFIED_BY **
177 
*COUNTY-MODIFIED_DATE,,** No join mapping for *COUNTY-MODIFIED_DATE **
178 
*COUNTY-MODIFIED_IN_INSTANCE,,** No join mapping for *COUNTY-MODIFIED_IN_INSTANCE **
179 
*COUNTY-row_num,,** No join mapping for *COUNTY-row_num **
180 
*COUNTYCD,,** No join mapping for *COUNTYCD **
181 
*F_PREFIX,,** No join mapping for *F_PREFIX **
182 
*GENERA_BINOMIAL_AUTHOR,,** No join mapping for *GENERA_BINOMIAL_AUTHOR **
183 
*HABTYPCD,,** No join mapping for *HABTYPCD **
184 
*HABTYP_PUB_CD,,** No join mapping for *HABTYP_PUB_CD **
185 
*INVYR,,** No join mapping for *INVYR **
186 
*PLANT_SYMBOL,,** No join mapping for *PLANT_SYMBOL **
187 
*PLANT_SYMBOL_TYPE,,** No join mapping for *PLANT_SYMBOL_TYPE **
188 
*PLOT-CONGCD,,** No join mapping for *PLOT-CONGCD **
189 
*PLOT-CREATED_BY,,** No join mapping for *PLOT-CREATED_BY **
190 
*PLOT-CREATED_DATE,,** No join mapping for *PLOT-CREATED_DATE **
191 
*PLOT-CREATED_IN_INSTANCE,,** No join mapping for *PLOT-CREATED_IN_INSTANCE **
192 
*PLOT-CTY_CN,,** No join mapping for *PLOT-CTY_CN **
193 
*PLOT-CYCLE,,** No join mapping for *PLOT-CYCLE **
194 
*PLOT-DECLINATION,,** No join mapping for *PLOT-DECLINATION **
195 
*PLOT-DESIGNCD,,** No join mapping for *PLOT-DESIGNCD **
196 
*PLOT-DESIGNCD_P2A,,** No join mapping for *PLOT-DESIGNCD_P2A **
197 
*PLOT-ECOSUBCD,,** No join mapping for *PLOT-ECOSUBCD **
198 
*PLOT-ECO_UNIT_PNW,,** No join mapping for *PLOT-ECO_UNIT_PNW **
199 
*PLOT-EMAP_HEX,,** No join mapping for *PLOT-EMAP_HEX **
200 
*PLOT-GROW_TYP_CD,,** No join mapping for *PLOT-GROW_TYP_CD **
201 
*PLOT-INTENSITY,,** No join mapping for *PLOT-INTENSITY **
202 
*PLOT-INVASIVE_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-INVASIVE_SAMPLING_STATUS_CD **
203 
*PLOT-INVASIVE_SPECIMEN_RULE_CD,,** No join mapping for *PLOT-INVASIVE_SPECIMEN_RULE_CD **
204 
*PLOT-KINDCD,,** No join mapping for *PLOT-KINDCD **
205 
*PLOT-KINDCD_NC,,** No join mapping for *PLOT-KINDCD_NC **
206 
*PLOT-MACRO_BREAKPOINT_DIA,,** No join mapping for *PLOT-MACRO_BREAKPOINT_DIA **
207 
*PLOT-MANUAL,,** No join mapping for *PLOT-MANUAL **
208 
*PLOT-MICROPLOT_LOC,,** No join mapping for *PLOT-MICROPLOT_LOC **
209 
*PLOT-MODIFIED_BY,,** No join mapping for *PLOT-MODIFIED_BY **
210 
*PLOT-MODIFIED_DATE,,** No join mapping for *PLOT-MODIFIED_DATE **
211 
*PLOT-MODIFIED_IN_INSTANCE,,** No join mapping for *PLOT-MODIFIED_IN_INSTANCE **
212 
*PLOT-MORT_TYP_CD,,** No join mapping for *PLOT-MORT_TYP_CD **
213 
*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,,** No join mapping for *PLOT-NF_PLOT_NONSAMPLE_REASN_CD **
214 
*PLOT-NF_PLOT_STATUS_CD,,** No join mapping for *PLOT-NF_PLOT_STATUS_CD **
215 
*PLOT-NF_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-NF_SAMPLING_STATUS_CD **
216 
*PLOT-P2PANEL,,** No join mapping for *PLOT-P2PANEL **
217 
*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,,** No join mapping for *PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD **
218 
*PLOT-P2VEG_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-P2VEG_SAMPLING_STATUS_CD **
219 
*PLOT-P3PANEL,,** No join mapping for *PLOT-P3PANEL **
220 
*PLOT-PLOT_NONSAMPLE_REASN_CD,,** No join mapping for *PLOT-PLOT_NONSAMPLE_REASN_CD **
221 
*PLOT-PLOT_STATUS_CD,,** No join mapping for *PLOT-PLOT_STATUS_CD **
222 
*PLOT-PREV_PLT_CN,,** No join mapping for *PLOT-PREV_PLT_CN **
223 
*PLOT-QA_STATUS,,** No join mapping for *PLOT-QA_STATUS **
224 
*PLOT-RDDISTCD,,** No join mapping for *PLOT-RDDISTCD **
225 
*PLOT-REMPER,,** No join mapping for *PLOT-REMPER **
226 
*PLOT-SAMP_METHOD_CD,,** No join mapping for *PLOT-SAMP_METHOD_CD **
227 
*PLOT-SRV_CN,,** No join mapping for *PLOT-SRV_CN **
228 
*PLOT-SUBCYCLE,,** No join mapping for *PLOT-SUBCYCLE **
229 
*PLOT-SUBPANEL,,** No join mapping for *PLOT-SUBPANEL **
230 
*PLOT-SUBP_EXAMINE_CD,,** No join mapping for *PLOT-SUBP_EXAMINE_CD **
231 
*PLOT-TOPO_POSITION_PNW,,** No join mapping for *PLOT-TOPO_POSITION_PNW **
232 
*PLOT-WATERCD,,** No join mapping for *PLOT-WATERCD **
233 
*PLOT-row_num,,** No join mapping for *PLOT-row_num **
234 
*QUADRINOMIAL_AUTHOR,,** No join mapping for *QUADRINOMIAL_AUTHOR **
235 
*REF_HABTYP_DESCRIPTION-CREATED_BY,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_BY **
236 
*REF_HABTYP_DESCRIPTION-CREATED_DATE,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_DATE **
237 
*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE **
238 
*REF_HABTYP_DESCRIPTION-MODIFIED_BY,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_BY **
239 
*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_DATE **
240 
*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE **
241 
*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,,** No join mapping for *REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME **
242 
*REF_HABTYP_DESCRIPTION-VALID,,** No join mapping for *REF_HABTYP_DESCRIPTION-VALID **
243 
*REF_HABTYP_DESCRIPTION-row_num,,** No join mapping for *REF_HABTYP_DESCRIPTION-row_num **
244 
*REF_PLANT_DICTIONARY-CATEGORY,,** No join mapping for *REF_PLANT_DICTIONARY-CATEGORY **
245 
*REF_PLANT_DICTIONARY-CN,,** No join mapping for *REF_PLANT_DICTIONARY-CN **
246 
*REF_PLANT_DICTIONARY-CREATED_BY,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_BY **
247 
*REF_PLANT_DICTIONARY-CREATED_DATE,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_DATE **
248 
*REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE **
249 
*REF_PLANT_DICTIONARY-DURATION,,** No join mapping for *REF_PLANT_DICTIONARY-DURATION **
250 
*REF_PLANT_DICTIONARY-MODIFIED_BY,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_BY **
251 
*REF_PLANT_DICTIONARY-MODIFIED_DATE,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_DATE **
252 
*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE **
253 
*REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME,,** No join mapping for *REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME **
254 
*REF_PLANT_DICTIONARY-NEW_SYMBOL,,** No join mapping for *REF_PLANT_DICTIONARY-NEW_SYMBOL **
255 
*REF_PLANT_DICTIONARY-NOTES,,** No join mapping for *REF_PLANT_DICTIONARY-NOTES **
256 
*REF_PLANT_DICTIONARY-STATE_AND_PROVINCE,,** No join mapping for *REF_PLANT_DICTIONARY-STATE_AND_PROVINCE **
257 
*REF_PLANT_DICTIONARY-STATE_DISTRIBUTION,,** No join mapping for *REF_PLANT_DICTIONARY-STATE_DISTRIBUTION **
258 
*REF_PLANT_DICTIONARY-US_NATIVITY,,** No join mapping for *REF_PLANT_DICTIONARY-US_NATIVITY **
259 
*REF_PLANT_DICTIONARY-row_num,,** No join mapping for *REF_PLANT_DICTIONARY-row_num **
260 
*REF_RESEARCH_STATION-CREATED_BY,,** No join mapping for *REF_RESEARCH_STATION-CREATED_BY **
261 
*REF_RESEARCH_STATION-CREATED_DATE,,** No join mapping for *REF_RESEARCH_STATION-CREATED_DATE **
262 
*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,,** No join mapping for *REF_RESEARCH_STATION-CREATED_IN_INSTANCE **
263 
*REF_RESEARCH_STATION-MODIFIED_BY,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_BY **
264 
*REF_RESEARCH_STATION-MODIFIED_DATE,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_DATE **
265 
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE **
266 
*REF_RESEARCH_STATION-RS,,** No join mapping for *REF_RESEARCH_STATION-RS **
267 
*REF_RESEARCH_STATION-RSCD,,** No join mapping for *REF_RESEARCH_STATION-RSCD **
268 
*REF_RESEARCH_STATION-STATE_ABBR,,** No join mapping for *REF_RESEARCH_STATION-STATE_ABBR **
269 
*REF_RESEARCH_STATION-row_num,,** No join mapping for *REF_RESEARCH_STATION-row_num **
270 
*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT,,** No join mapping for *REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT **
271 
*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT **
272 
*REF_SPECIES-BARK_VOL_PCT,,** No join mapping for *REF_SPECIES-BARK_VOL_PCT **
273 
*REF_SPECIES-BARK_VOL_PCT_CIT,,** No join mapping for *REF_SPECIES-BARK_VOL_PCT_CIT **
274 
*REF_SPECIES-CARIBBEAN,,** No join mapping for *REF_SPECIES-CARIBBEAN **
275 
*REF_SPECIES-COMMON_NAME,,** No join mapping for *REF_SPECIES-COMMON_NAME **
276 
*REF_SPECIES-CORE,,** No join mapping for *REF_SPECIES-CORE **
277 
*REF_SPECIES-CREATED_BY,,** No join mapping for *REF_SPECIES-CREATED_BY **
278 
*REF_SPECIES-CREATED_DATE,,** No join mapping for *REF_SPECIES-CREATED_DATE **
279 
*REF_SPECIES-CREATED_IN_INSTANCE,,** No join mapping for *REF_SPECIES-CREATED_IN_INSTANCE **
280 
*REF_SPECIES-CWD_DECAY_RATIO1,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO1 **
281 
*REF_SPECIES-CWD_DECAY_RATIO2,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO2 **
282 
*REF_SPECIES-CWD_DECAY_RATIO3,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO3 **
283 
*REF_SPECIES-CWD_DECAY_RATIO4,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO4 **
284 
*REF_SPECIES-CWD_DECAY_RATIO5,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO5 **
285 
*REF_SPECIES-C_SPGRPCD,,** No join mapping for *REF_SPECIES-C_SPGRPCD **
286 
*REF_SPECIES-DWM_CARBON_RATIO,,** No join mapping for *REF_SPECIES-DWM_CARBON_RATIO **
287 
*REF_SPECIES-EAST,,** No join mapping for *REF_SPECIES-EAST **
288 
*REF_SPECIES-EXISTS_IN_NCRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_NCRS **
289 
*REF_SPECIES-EXISTS_IN_NERS,,** No join mapping for *REF_SPECIES-EXISTS_IN_NERS **
290 
*REF_SPECIES-EXISTS_IN_PNWRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_PNWRS **
291 
*REF_SPECIES-EXISTS_IN_RMRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_RMRS **
292 
*REF_SPECIES-EXISTS_IN_SRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_SRS **
293 
*REF_SPECIES-E_SPGRPCD,,** No join mapping for *REF_SPECIES-E_SPGRPCD **
294 
*REF_SPECIES-FOREST_TYPE_SPGRPCD,,** No join mapping for *REF_SPECIES-FOREST_TYPE_SPGRPCD **
295 
*REF_SPECIES-GENUS,,** No join mapping for *REF_SPECIES-GENUS **
296 
*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1 **
297 
*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2 **
298 
*REF_SPECIES-JENKINS_ROOT_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_ROOT_RATIO_B1 **
299 
*REF_SPECIES-JENKINS_ROOT_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_ROOT_RATIO_B2 **
300 
*REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT,,** No join mapping for *REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT **
301 
*REF_SPECIES-JENKINS_SPGRPCD,,** No join mapping for *REF_SPECIES-JENKINS_SPGRPCD **
302 
*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1 **
303 
*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2 **
304 
*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1 **
305 
*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2 **
306 
*REF_SPECIES-JENKINS_TOTAL_B1,,** No join mapping for *REF_SPECIES-JENKINS_TOTAL_B1 **
307 
*REF_SPECIES-JENKINS_TOTAL_B2,,** No join mapping for *REF_SPECIES-JENKINS_TOTAL_B2 **
308 
*REF_SPECIES-MAJOR_SPGRPCD,,** No join mapping for *REF_SPECIES-MAJOR_SPGRPCD **
309 
*REF_SPECIES-MANUAL_END,,** No join mapping for *REF_SPECIES-MANUAL_END **
310 
*REF_SPECIES-MANUAL_START,,** No join mapping for *REF_SPECIES-MANUAL_START **
311 
*REF_SPECIES-MC_PCT_GREEN_BARK,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_BARK **
312 
*REF_SPECIES-MC_PCT_GREEN_BARK_CIT,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_BARK_CIT **
313 
*REF_SPECIES-MC_PCT_GREEN_WOOD,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_WOOD **
314 
*REF_SPECIES-MC_PCT_GREEN_WOOD_CIT,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_WOOD_CIT **
315 
*REF_SPECIES-MODIFIED_BY,,** No join mapping for *REF_SPECIES-MODIFIED_BY **
316 
*REF_SPECIES-MODIFIED_DATE,,** No join mapping for *REF_SPECIES-MODIFIED_DATE **
317 
*REF_SPECIES-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_SPECIES-MODIFIED_IN_INSTANCE **
318 
*REF_SPECIES-PACIFIC,,** No join mapping for *REF_SPECIES-PACIFIC **
319 
*REF_SPECIES-P_SPGRPCD,,** No join mapping for *REF_SPECIES-P_SPGRPCD **
320 
*REF_SPECIES-RAILE_STUMP_DIB_B1,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DIB_B1 **
321 
*REF_SPECIES-RAILE_STUMP_DIB_B2,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DIB_B2 **
322 
*REF_SPECIES-RAILE_STUMP_DOB_B1,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DOB_B1 **
323 
*REF_SPECIES-SFTWD_HRDWD,,** No join mapping for *REF_SPECIES-SFTWD_HRDWD **
324 
*REF_SPECIES-SITETREE,,** No join mapping for *REF_SPECIES-SITETREE **
325 
*REF_SPECIES-SPECIES,,** No join mapping for *REF_SPECIES-SPECIES **
326 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO1,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO1 **
327 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO2,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO2 **
328 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO3,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO3 **
329 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO4,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO4 **
330 
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO5,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO5 **
331 
*REF_SPECIES-STOCKING_SPGRPCD,,** No join mapping for *REF_SPECIES-STOCKING_SPGRPCD **
332 
*REF_SPECIES-ST_EXISTS_IN_NCRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_NCRS **
333 
*REF_SPECIES-ST_EXISTS_IN_NERS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_NERS **
334 
*REF_SPECIES-ST_EXISTS_IN_PNWRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_PNWRS **
335 
*REF_SPECIES-ST_EXISTS_IN_RMRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_RMRS **
336 
*REF_SPECIES-ST_EXISTS_IN_SRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_SRS **
337 
*REF_SPECIES-SUBSPECIES,,** No join mapping for *REF_SPECIES-SUBSPECIES **
338 
*REF_SPECIES-VARIETY,,** No join mapping for *REF_SPECIES-VARIETY **
339 
*REF_SPECIES-WEST,,** No join mapping for *REF_SPECIES-WEST **
340 
*REF_SPECIES-WOODLAND,,** No join mapping for *REF_SPECIES-WOODLAND **
341 
*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT **
342 
*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT **
343 
*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT **
344 
*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT **
345 
*REF_SPECIES-W_SPGRPCD,,** No join mapping for *REF_SPECIES-W_SPGRPCD **
346 
*REF_SPECIES-row_num,,** No join mapping for *REF_SPECIES-row_num **
347 
*REF_UNIT-CREATED_BY,,** No join mapping for *REF_UNIT-CREATED_BY **
348 
*REF_UNIT-CREATED_DATE,,** No join mapping for *REF_UNIT-CREATED_DATE **
349 
*REF_UNIT-CREATED_IN_INSTANCE,,** No join mapping for *REF_UNIT-CREATED_IN_INSTANCE **
350 
*REF_UNIT-MEANING,,** No join mapping for *REF_UNIT-MEANING **
351 
*REF_UNIT-MODIFIED_BY,,** No join mapping for *REF_UNIT-MODIFIED_BY **
352 
*REF_UNIT-MODIFIED_DATE,,** No join mapping for *REF_UNIT-MODIFIED_DATE **
353 
*REF_UNIT-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_UNIT-MODIFIED_IN_INSTANCE **
354 
*REF_UNIT-row_num,,** No join mapping for *REF_UNIT-row_num **
355 
*SPCD,,** No join mapping for *SPCD **
356 
*SSP_PREFIX,,** No join mapping for *SSP_PREFIX **
357 
*STATECD,,** No join mapping for *STATECD **
358 
*SUBPLOT-ASPECT,,** No join mapping for *SUBPLOT-ASPECT **
359 
*SUBPLOT-CONDLIST,,** No join mapping for *SUBPLOT-CONDLIST **
360 
*SUBPLOT-CREATED_BY,,** No join mapping for *SUBPLOT-CREATED_BY **
361 
*SUBPLOT-CREATED_DATE,,** No join mapping for *SUBPLOT-CREATED_DATE **
362 
*SUBPLOT-CREATED_IN_INSTANCE,,** No join mapping for *SUBPLOT-CREATED_IN_INSTANCE **
363 
*SUBPLOT-CYCLE,,** No join mapping for *SUBPLOT-CYCLE **
364 
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD **
365 
*SUBPLOT-INVASIVE_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-INVASIVE_SUBP_STATUS_CD **
366 
*SUBPLOT-MACRCOND,,** No join mapping for *SUBPLOT-MACRCOND **
367 
*SUBPLOT-MICRCOND,,** No join mapping for *SUBPLOT-MICRCOND **
368 
*SUBPLOT-MODIFIED_BY,,** No join mapping for *SUBPLOT-MODIFIED_BY **
369 
*SUBPLOT-MODIFIED_DATE,,** No join mapping for *SUBPLOT-MODIFIED_DATE **
370 
*SUBPLOT-MODIFIED_IN_INSTANCE,,** No join mapping for *SUBPLOT-MODIFIED_IN_INSTANCE **
371 
*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD **
372 
*SUBPLOT-NF_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-NF_SUBP_STATUS_CD **
373 
*SUBPLOT-P2A_GRM_FLG,,** No join mapping for *SUBPLOT-P2A_GRM_FLG **
374 
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD **
375 
*SUBPLOT-P2VEG_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-P2VEG_SUBP_STATUS_CD **
376 
*SUBPLOT-PLT_CN,,** No join mapping for *SUBPLOT-PLT_CN **
377 
*SUBPLOT-POINT_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-POINT_NONSAMPLE_REASN_CD **
378 
*SUBPLOT-PREV_SBP_CN,,** No join mapping for *SUBPLOT-PREV_SBP_CN **
379 
*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,,** No join mapping for *SUBPLOT-ROOT_DIS_SEV_CD_PNWRS **
380 
*SUBPLOT-SLOPE,,** No join mapping for *SUBPLOT-SLOPE **
381 
*SUBPLOT-SUBCYCLE,,** No join mapping for *SUBPLOT-SUBCYCLE **
382 
*SUBPLOT-SUBPCOND,,** No join mapping for *SUBPLOT-SUBPCOND **
383 
*SUBPLOT-SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-SUBP_STATUS_CD **
384 
*SUBPLOT-WATERDEP,,** No join mapping for *SUBPLOT-WATERDEP **
385 
*SUBPLOT-row_num,,** No join mapping for *SUBPLOT-row_num **
386 
*SUBVAR,,** No join mapping for *SUBVAR **
387 
*SUBVARIETY,,** No join mapping for *SUBVARIETY **
388 
*TREE-ACTUALHT,,** No join mapping for *TREE-ACTUALHT **
389 
*TREE-AGENTCD,,** No join mapping for *TREE-AGENTCD **
390 
*TREE-AZIMUTH,,** No join mapping for *TREE-AZIMUTH **
391 
*TREE-BFSND,,** No join mapping for *TREE-BFSND **
392 
*TREE-BHAGE,,** No join mapping for *TREE-BHAGE **
393 
*TREE-BORED_CD_PNWRS,,** No join mapping for *TREE-BORED_CD_PNWRS **
394 
*TREE-CARBON_AG,,** No join mapping for *TREE-CARBON_AG **
395 
*TREE-CARBON_BG,,** No join mapping for *TREE-CARBON_BG **
396 
*TREE-CCLCD,,** No join mapping for *TREE-CCLCD **
397 
*TREE-CDENCD,,** No join mapping for *TREE-CDENCD **
398 
*TREE-CDIEBKCD,,** No join mapping for *TREE-CDIEBKCD **
399 
*TREE-CFSND,,** No join mapping for *TREE-CFSND **
400 
*TREE-CLIGHTCD,,** No join mapping for *TREE-CLIGHTCD **
401 
*TREE-CPOSCD,,** No join mapping for *TREE-CPOSCD **
402 
*TREE-CR,,** No join mapping for *TREE-CR **
403 
*TREE-CREATED_BY,,** No join mapping for *TREE-CREATED_BY **
404 
*TREE-CREATED_DATE,,** No join mapping for *TREE-CREATED_DATE **
405 
*TREE-CREATED_IN_INSTANCE,,** No join mapping for *TREE-CREATED_IN_INSTANCE **
406 
*TREE-CULL,,** No join mapping for *TREE-CULL **
407 
*TREE-CULLBF,,** No join mapping for *TREE-CULLBF **
408 
*TREE-CULLCF,,** No join mapping for *TREE-CULLCF **
409 
*TREE-CULLDEAD,,** No join mapping for *TREE-CULLDEAD **
410 
*TREE-CULLFORM,,** No join mapping for *TREE-CULLFORM **
411 
*TREE-CULLMSTOP,,** No join mapping for *TREE-CULLMSTOP **
412 
*TREE-CULL_FLD,,** No join mapping for *TREE-CULL_FLD **
413 
*TREE-CVIGORCD,,** No join mapping for *TREE-CVIGORCD **
414 
*TREE-CYCLE,,** No join mapping for *TREE-CYCLE **
415 
*TREE-DAMLOC1,,** No join mapping for *TREE-DAMLOC1 **
416 
*TREE-DAMLOC1_PNWRS,,** No join mapping for *TREE-DAMLOC1_PNWRS **
417 
*TREE-DAMLOC2,,** No join mapping for *TREE-DAMLOC2 **
418 
*TREE-DAMLOC2_PNWRS,,** No join mapping for *TREE-DAMLOC2_PNWRS **
419 
*TREE-DAMSEV1,,** No join mapping for *TREE-DAMSEV1 **
420 
*TREE-DAMSEV2,,** No join mapping for *TREE-DAMSEV2 **
421 
*TREE-DAMTYP1,,** No join mapping for *TREE-DAMTYP1 **
422 
*TREE-DAMTYP2,,** No join mapping for *TREE-DAMTYP2 **
423 
*TREE-DECAYCD,,** No join mapping for *TREE-DECAYCD **
424 
*TREE-DIACALC,,** No join mapping for *TREE-DIACALC **
425 
*TREE-DIACHECK,,** No join mapping for *TREE-DIACHECK **
426 
*TREE-DIACHECK_PNWRS,,** No join mapping for *TREE-DIACHECK_PNWRS **
427 
*TREE-DIAHTCD,,** No join mapping for *TREE-DIAHTCD **
428 
*TREE-DIEBACK_SEVERITY_SRS,,** No join mapping for *TREE-DIEBACK_SEVERITY_SRS **
429 
*TREE-DISEASE_SRS,,** No join mapping for *TREE-DISEASE_SRS **
430 
*TREE-DIST,,** No join mapping for *TREE-DIST **
431 
*TREE-DMG_AGENT1_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT1_CD_PNWRS **
432 
*TREE-DMG_AGENT2_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT2_CD_PNWRS **
433 
*TREE-DMG_AGENT3_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT3_CD_PNWRS **
434 
*TREE-DRYBIO_BG,,** No join mapping for *TREE-DRYBIO_BG **
435 
*TREE-DRYBIO_BOLE,,** No join mapping for *TREE-DRYBIO_BOLE **
436 
*TREE-DRYBIO_SAPLING,,** No join mapping for *TREE-DRYBIO_SAPLING **
437 
*TREE-DRYBIO_STUMP,,** No join mapping for *TREE-DRYBIO_STUMP **
438 
*TREE-DRYBIO_TOP,,** No join mapping for *TREE-DRYBIO_TOP **
439 
*TREE-DRYBIO_WDLD_SPP,,** No join mapping for *TREE-DRYBIO_WDLD_SPP **
440 
*TREE-FGROWBFSL,,** No join mapping for *TREE-FGROWBFSL **
441 
*TREE-FGROWCFAL,,** No join mapping for *TREE-FGROWCFAL **
442 
*TREE-FGROWCFGS,,** No join mapping for *TREE-FGROWCFGS **
443 
*TREE-FMORTBFSL,,** No join mapping for *TREE-FMORTBFSL **
444 
*TREE-FMORTCFAL,,** No join mapping for *TREE-FMORTCFAL **
445 
*TREE-FMORTCFGS,,** No join mapping for *TREE-FMORTCFGS **
446 
*TREE-FORMCL,,** No join mapping for *TREE-FORMCL **
447 
*TREE-FREMVBFSL,,** No join mapping for *TREE-FREMVBFSL **
448 
*TREE-FREMVCFAL,,** No join mapping for *TREE-FREMVCFAL **
449 
*TREE-FREMVCFGS,,** No join mapping for *TREE-FREMVCFGS **
450 
*TREE-GROWBFSL,,** No join mapping for *TREE-GROWBFSL **
451 
*TREE-GROWCFAL,,** No join mapping for *TREE-GROWCFAL **
452 
*TREE-GROWCFGS,,** No join mapping for *TREE-GROWCFGS **
453 
*TREE-HRDWD_CLUMP_CD,,** No join mapping for *TREE-HRDWD_CLUMP_CD **
454 
*TREE-HTCALC,,** No join mapping for *TREE-HTCALC **
455 
*TREE-HTCD,,** No join mapping for *TREE-HTCD **
456 
*TREE-HTDMP,,** No join mapping for *TREE-HTDMP **
457 
*TREE-MIST_CL_CD,,** No join mapping for *TREE-MIST_CL_CD **
458 
*TREE-MIST_CL_CD_PNWRS,,** No join mapping for *TREE-MIST_CL_CD_PNWRS **
459 
*TREE-MODIFIED_BY,,** No join mapping for *TREE-MODIFIED_BY **
460 
*TREE-MODIFIED_DATE,,** No join mapping for *TREE-MODIFIED_DATE **
461 
*TREE-MODIFIED_IN_INSTANCE,,** No join mapping for *TREE-MODIFIED_IN_INSTANCE **
462 
*TREE-MORTBFSL,,** No join mapping for *TREE-MORTBFSL **
463 
*TREE-MORTCD,,** No join mapping for *TREE-MORTCD **
464 
*TREE-MORTCFAL,,** No join mapping for *TREE-MORTCFAL **
465 
*TREE-MORTCFGS,,** No join mapping for *TREE-MORTCFGS **
466 
*TREE-MORTYR,,** No join mapping for *TREE-MORTYR **
467 
*TREE-P2A_GRM_FLG,,** No join mapping for *TREE-P2A_GRM_FLG **
468 
*TREE-PLT_CN,,** No join mapping for *TREE-PLT_CN **
469 
*TREE-PREVCOND,,** No join mapping for *TREE-PREVCOND **
470 
*TREE-PREVDIA,,** No join mapping for *TREE-PREVDIA **
471 
*TREE-PREV_PNTN_SRS,,** No join mapping for *TREE-PREV_PNTN_SRS **
472 
*TREE-PREV_STATUS_CD,,** No join mapping for *TREE-PREV_STATUS_CD **
473 
*TREE-PREV_TRE_CN,,** No join mapping for *TREE-PREV_TRE_CN **
474 
*TREE-PREV_WDLDSTEM,,** No join mapping for *TREE-PREV_WDLDSTEM **
475 
*TREE-RECONCILECD,,** No join mapping for *TREE-RECONCILECD **
476 
*TREE-REMVBFSL,,** No join mapping for *TREE-REMVBFSL **
477 
*TREE-REMVCFAL,,** No join mapping for *TREE-REMVCFAL **
478 
*TREE-REMVCFGS,,** No join mapping for *TREE-REMVCFGS **
479 
*TREE-ROUGHCULL,,** No join mapping for *TREE-ROUGHCULL **
480 
*TREE-SALVCD,,** No join mapping for *TREE-SALVCD **
481 
*TREE-SAWHT,,** No join mapping for *TREE-SAWHT **
482 
*TREE-SEVERITY1A_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1A_CD_PNWRS **
483 
*TREE-SEVERITY1B_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1B_CD_PNWRS **
484 
*TREE-SEVERITY1_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1_CD_PNWRS **
485 
*TREE-SEVERITY2A_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2A_CD_PNWRS **
486 
*TREE-SEVERITY2B_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2B_CD_PNWRS **
487 
*TREE-SEVERITY2_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2_CD_PNWRS **
488 
*TREE-SEVERITY3_CD_PNWRS,,** No join mapping for *TREE-SEVERITY3_CD_PNWRS **
489 
*TREE-SITREE,,** No join mapping for *TREE-SITREE **
490 
*TREE-SPGRPCD,,** No join mapping for *TREE-SPGRPCD **
491 
*TREE-STANDING_DEAD_CD,,** No join mapping for *TREE-STANDING_DEAD_CD **
492 
*TREE-STATUSCD,,** No join mapping for *TREE-STATUSCD **
493 
*TREE-STOCKING,,** No join mapping for *TREE-STOCKING **
494 
*TREE-SUBCYCLE,,** No join mapping for *TREE-SUBCYCLE **
495 
*TREE-TOTAGE,,** No join mapping for *TREE-TOTAGE **
496 
*TREE-TPAGROW_UNADJ,,** No join mapping for *TREE-TPAGROW_UNADJ **
497 
*TREE-TPAMORT_UNADJ,,** No join mapping for *TREE-TPAMORT_UNADJ **
498 
*TREE-TPAREMV_UNADJ,,** No join mapping for *TREE-TPAREMV_UNADJ **
499 
*TREE-TPA_UNADJ,,** No join mapping for *TREE-TPA_UNADJ **
500 
*TREE-TRANSCD,,** No join mapping for *TREE-TRANSCD **
501 
*TREE-TREECLCD,,** No join mapping for *TREE-TREECLCD **
502 
*TREE-TREECLCD_NCRS,,** No join mapping for *TREE-TREECLCD_NCRS **
503 
*TREE-TREECLCD_NERS,,** No join mapping for *TREE-TREECLCD_NERS **
504 
*TREE-TREECLCD_RMRS,,** No join mapping for *TREE-TREECLCD_RMRS **
505 
*TREE-TREECLCD_SRS,,** No join mapping for *TREE-TREECLCD_SRS **
506 
*TREE-TREEGRCD,,** No join mapping for *TREE-TREEGRCD **
507 
*TREE-TREEHISTCD,,** No join mapping for *TREE-TREEHISTCD **
508 
*TREE-UNCRCD,,** No join mapping for *TREE-UNCRCD **
509 
*TREE-UNKNOWN_DAMTYP1_PNWRS,,** No join mapping for *TREE-UNKNOWN_DAMTYP1_PNWRS **
510 
*TREE-UNKNOWN_DAMTYP2_PNWRS,,** No join mapping for *TREE-UNKNOWN_DAMTYP2_PNWRS **
511 
*TREE-VOLBFGRS,,** No join mapping for *TREE-VOLBFGRS **
512 
*TREE-VOLBFNET,,** No join mapping for *TREE-VOLBFNET **
513 
*TREE-VOLCFGRS,,** No join mapping for *TREE-VOLCFGRS **
514 
*TREE-VOLCFNET,,** No join mapping for *TREE-VOLCFNET **
515 
*TREE-VOLCFSND,,** No join mapping for *TREE-VOLCFSND **
516 
*TREE-VOLCSGRS,,** No join mapping for *TREE-VOLCSGRS **
517 
*TREE-VOLCSNET,,** No join mapping for *TREE-VOLCSNET **
518 
*TREE-WDLDSTEM,,** No join mapping for *TREE-WDLDSTEM **
519 
*TREE-row_num,,** No join mapping for *TREE-row_num **
520 
*TRINOMIAL_AUTHOR,,** No join mapping for *TRINOMIAL_AUTHOR **
521 
*UNITCD,,** No join mapping for *UNITCD **
522 
*VAR_PREFIX,,** No join mapping for *VAR_PREFIX **
523 
*XGENUS,,** No join mapping for *XGENUS **
524 
*XSPECIES,,** No join mapping for *XSPECIES **
525 
*XSUBSPECIES,,** No join mapping for *XSUBSPECIES **
526 
*XVARIETY,,** No join mapping for *XVARIETY **
527 
day,,** No join mapping for day **
528 
elevation_ft,,** No join mapping for elevation_ft **
529 
month,,** No join mapping for month **
530 
occurrence_all-row_num,,** No join mapping for occurrence_all-row_num **
531 
taxonGrowthForm,,** No join mapping for taxonGrowthForm **
532 
vernacularName,,** No join mapping for vernacularName **
533 
year,,** No join mapping for year **
inputs/FIA/occurrence_all/unmapped_terms.csv
1 
row_num
2 
*STATECD
3 
*UNITCD
4 
*COUNTYCD
5 
*INVYR
6 
*HABTYPCD
7 
*HABTYP_PUB_CD
8 
*PLANT_SYMBOL
9 
*PLANT_SYMBOL_TYPE
10 
*SPCD
11 
*TREE--row_num
12 
*TREE--PLT_CN
13 
*TREE--PREV_TRE_CN
14 
*TREE--AZIMUTH
15 
*TREE--DIST
16 
*TREE--PREVCOND
17 
*TREE--STATUSCD
18 
*TREE--SPGRPCD
19 
*TREE--DIAHTCD
20 
*TREE--HTCD
21 
*TREE--ACTUALHT
22 
*TREE--TREECLCD
23 
*TREE--CR
24 
*TREE--CCLCD
25 
*TREE--TREEGRCD
26 
*TREE--AGENTCD
27 
*TREE--CULL
28 
*TREE--DAMLOC1
29 
*TREE--DAMTYP1
30 
*TREE--DAMSEV1
31 
*TREE--DAMLOC2
32 
*TREE--DAMTYP2
33 
*TREE--DAMSEV2
34 
*TREE--DECAYCD
35 
*TREE--STOCKING
36 
*TREE--WDLDSTEM
37 
*TREE--VOLCFNET
38 
*TREE--VOLCFGRS
39 
*TREE--VOLCSNET
40 
*TREE--VOLCSGRS
41 
*TREE--VOLBFNET
42 
*TREE--VOLBFGRS
43 
*TREE--VOLCFSND
44 
*TREE--GROWCFGS
45 
*TREE--GROWBFSL
46 
*TREE--GROWCFAL
47 
*TREE--MORTCFGS
48 
*TREE--MORTBFSL
49 
*TREE--MORTCFAL
50 
*TREE--REMVCFGS
51 
*TREE--REMVBFSL
52 
*TREE--REMVCFAL
53 
*TREE--DIACHECK
54 
*TREE--MORTYR
55 
*TREE--SALVCD
56 
*TREE--UNCRCD
57 
*TREE--CPOSCD
58 
*TREE--CLIGHTCD
59 
*TREE--CVIGORCD
60 
*TREE--CDENCD
61 
*TREE--CDIEBKCD
62 
*TREE--TRANSCD
63 
*TREE--TREEHISTCD
64 
*TREE--DIACALC
65 
*TREE--BHAGE
66 
*TREE--TOTAGE
67 
*TREE--CULLDEAD
68 
*TREE--CULLFORM
69 
*TREE--CULLMSTOP
70 
*TREE--CULLBF
71 
*TREE--CULLCF
72 
*TREE--BFSND
73 
*TREE--CFSND
74 
*TREE--SAWHT
75 
*BOLEHT
76 
*TREE--FORMCL
77 
*TREE--HTCALC
78 
*TREE--HRDWD_CLUMP_CD
79 
*TREE--SITREE
80 
*TREE--CREATED_BY
81 
*TREE--CREATED_DATE
82 
*TREE--CREATED_IN_INSTANCE
83 
*TREE--MODIFIED_BY
84 
*TREE--MODIFIED_DATE
85 
*TREE--MODIFIED_IN_INSTANCE
86 
*TREE--MORTCD
87 
*TREE--HTDMP
88 
*TREE--ROUGHCULL
89 
*TREE--MIST_CL_CD
90 
*TREE--CULL_FLD
91 
*TREE--RECONCILECD
92 
*TREE--PREVDIA
93 
*TREE--FGROWCFGS
94 
*TREE--FGROWBFSL
95 
*TREE--FGROWCFAL
96 
*TREE--FMORTCFGS
97 
*TREE--FMORTBFSL
98 
*TREE--FMORTCFAL
99 
*TREE--FREMVCFGS
100 
*TREE--FREMVBFSL
101 
*TREE--FREMVCFAL
102 
*TREE--P2A_GRM_FLG
103 
*TREE--TREECLCD_NERS
104 
*TREE--TREECLCD_SRS
105 
*TREE--TREECLCD_NCRS
106 
*TREE--TREECLCD_RMRS
107 
*TREE--STANDING_DEAD_CD
108 
*TREE--PREV_STATUS_CD
109 
*TREE--PREV_WDLDSTEM
110 
*TREE--TPA_UNADJ
111 
*TREE--TPAMORT_UNADJ
112 
*TREE--TPAREMV_UNADJ
113 
*TREE--TPAGROW_UNADJ
114 
*TREE--DRYBIO_BOLE
115 
*TREE--DRYBIO_TOP
116 
*TREE--DRYBIO_STUMP
117 
*TREE--DRYBIO_SAPLING
118 
*TREE--DRYBIO_WDLD_SPP
119 
*TREE--DRYBIO_BG
120 
*TREE--CARBON_AG
121 
*TREE--CARBON_BG
122 
*TREE--CYCLE
123 
*TREE--SUBCYCLE
124 
*TREE--BORED_CD_PNWRS
125 
*TREE--DAMLOC1_PNWRS
126 
*TREE--DAMLOC2_PNWRS
127 
*TREE--DIACHECK_PNWRS
128 
*TREE--DMG_AGENT1_CD_PNWRS
129 
*TREE--DMG_AGENT2_CD_PNWRS
130 
*TREE--DMG_AGENT3_CD_PNWRS
131 
*TREE--MIST_CL_CD_PNWRS
132 
*TREE--SEVERITY1_CD_PNWRS
133 
*TREE--SEVERITY1A_CD_PNWRS
134 
*TREE--SEVERITY1B_CD_PNWRS
135 
*TREE--SEVERITY2_CD_PNWRS
136 
*TREE--SEVERITY2A_CD_PNWRS
137 
*TREE--SEVERITY2B_CD_PNWRS
138 
*TREE--SEVERITY3_CD_PNWRS
139 
*TREE--UNKNOWN_DAMTYP1_PNWRS
140 
*TREE--UNKNOWN_DAMTYP2_PNWRS
141 
*TREE--PREV_PNTN_SRS
142 
*TREE--DISEASE_SRS
143 
*TREE--DIEBACK_SEVERITY_SRS
144 
*REF_SPECIES--row_num
145 
*REF_SPECIES--COMMON_NAME
146 
*REF_SPECIES--GENUS
147 
*REF_SPECIES--SPECIES
148 
*REF_SPECIES--VARIETY
149 
*REF_SPECIES--SUBSPECIES
150 
*REF_SPECIES--E_SPGRPCD
151 
*REF_SPECIES--W_SPGRPCD
152 
*REF_SPECIES--C_SPGRPCD
153 
*REF_SPECIES--P_SPGRPCD
154 
*REF_SPECIES--MAJOR_SPGRPCD
155 
*REF_SPECIES--STOCKING_SPGRPCD
156 
*REF_SPECIES--FOREST_TYPE_SPGRPCD
157 
*REF_SPECIES--EXISTS_IN_NCRS
158 
*REF_SPECIES--EXISTS_IN_NERS
159 
*REF_SPECIES--EXISTS_IN_PNWRS
160 
*REF_SPECIES--EXISTS_IN_RMRS
161 
*REF_SPECIES--EXISTS_IN_SRS
162 
*REF_SPECIES--SITETREE
163 
*REF_SPECIES--SFTWD_HRDWD
164 
*REF_SPECIES--ST_EXISTS_IN_NCRS
165 
*REF_SPECIES--ST_EXISTS_IN_NERS
166 
*REF_SPECIES--ST_EXISTS_IN_PNWRS
167 
*REF_SPECIES--ST_EXISTS_IN_RMRS
168 
*REF_SPECIES--ST_EXISTS_IN_SRS
169 
*REF_SPECIES--CORE
170 
*REF_SPECIES--EAST
171 
*REF_SPECIES--WEST
172 
*REF_SPECIES--CARIBBEAN
173 
*REF_SPECIES--PACIFIC
174 
*REF_SPECIES--WOODLAND
175 
*REF_SPECIES--MANUAL_START
176 
*REF_SPECIES--MANUAL_END
177 
*REF_SPECIES--JENKINS_SPGRPCD
178 
*REF_SPECIES--JENKINS_TOTAL_B1
179 
*REF_SPECIES--JENKINS_TOTAL_B2
180 
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B1
181 
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B2
182 
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B1
183 
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B2
184 
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B1
185 
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B2
186 
*REF_SPECIES--JENKINS_ROOT_RATIO_B1
187 
*REF_SPECIES--JENKINS_ROOT_RATIO_B2
188 
*REF_SPECIES--JENKINS_SAPLING_ADJUSTMENT
189 
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT
190 
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT_CIT
191 
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT
192 
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT_CIT
193 
*REF_SPECIES--MC_PCT_GREEN_BARK
194 
*REF_SPECIES--MC_PCT_GREEN_BARK_CIT
195 
*REF_SPECIES--MC_PCT_GREEN_WOOD
196 
*REF_SPECIES--MC_PCT_GREEN_WOOD_CIT
197 
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT
198 
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT_CIT
199 
*REF_SPECIES--BARK_VOL_PCT
200 
*REF_SPECIES--BARK_VOL_PCT_CIT
201 
*REF_SPECIES--RAILE_STUMP_DOB_B1
202 
*REF_SPECIES--RAILE_STUMP_DIB_B1
203 
*REF_SPECIES--RAILE_STUMP_DIB_B2
204 
*REF_SPECIES--CWD_DECAY_RATIO1
205 
*REF_SPECIES--CWD_DECAY_RATIO2
206 
*REF_SPECIES--CWD_DECAY_RATIO3
207 
*REF_SPECIES--CWD_DECAY_RATIO4
208 
*REF_SPECIES--CWD_DECAY_RATIO5
209 
*REF_SPECIES--DWM_CARBON_RATIO
210 
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO1
211 
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO2
212 
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO3
213 
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO4
214 
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO5
215 
*REF_SPECIES--CREATED_BY
216 
*REF_SPECIES--CREATED_DATE
217 
*REF_SPECIES--CREATED_IN_INSTANCE
218 
*REF_SPECIES--MODIFIED_BY
219 
*REF_SPECIES--MODIFIED_DATE
220 
*REF_SPECIES--MODIFIED_IN_INSTANCE
221 
*REF_PLANT_DICTIONARY--row_num
222 
*REF_PLANT_DICTIONARY--CN
223 
*REF_PLANT_DICTIONARY--NEW_SYMBOL
224 
*REF_PLANT_DICTIONARY--NEW_SCIENTIFIC_NAME
225 
vernacularName
226 
*REF_PLANT_DICTIONARY--CATEGORY
227 
taxonGrowthForm
228 
*REF_PLANT_DICTIONARY--DURATION
229 
*REF_PLANT_DICTIONARY--US_NATIVITY
230 
*REF_PLANT_DICTIONARY--STATE_DISTRIBUTION
231 
*REF_PLANT_DICTIONARY--STATE_AND_PROVINCE
232 
*GENERA_BINOMIAL_AUTHOR
233 
*TRINOMIAL_AUTHOR
234 
*QUADRINOMIAL_AUTHOR
235 
*XGENUS
236 
*XSPECIES
237 
*SSP_PREFIX
238 
*XSUBSPECIES
239 
*VAR_PREFIX
240 
*XVARIETY
241 
*SUBVAR
242 
*SUBVARIETY
243 
*F_PREFIX
244 
*REF_PLANT_DICTIONARY--NOTES
245 
*REF_PLANT_DICTIONARY--CREATED_BY
246 
*REF_PLANT_DICTIONARY--CREATED_DATE
247 
*REF_PLANT_DICTIONARY--CREATED_IN_INSTANCE
248 
*REF_PLANT_DICTIONARY--MODIFIED_BY
249 
*REF_PLANT_DICTIONARY--MODIFIED_DATE
250 
*REF_PLANT_DICTIONARY--MODIFIED_IN_INSTANCE
251 
*SUBPLOT--row_num
252 
*SUBPLOT--PLT_CN
253 
*SUBPLOT--PREV_SBP_CN
254 
*SUBPLOT--SUBP_STATUS_CD
255 
*SUBPLOT--POINT_NONSAMPLE_REASN_CD
256 
*SUBPLOT--MICRCOND
257 
*SUBPLOT--SUBPCOND
258 
*SUBPLOT--MACRCOND
259 
*SUBPLOT--CONDLIST
260 
*SUBPLOT--SLOPE
261 
*SUBPLOT--ASPECT
262 
*SUBPLOT--WATERDEP
263 
*SUBPLOT--P2A_GRM_FLG
264 
*SUBPLOT--CREATED_BY
265 
*SUBPLOT--CREATED_DATE
266 
*SUBPLOT--CREATED_IN_INSTANCE
267 
*SUBPLOT--MODIFIED_BY
268 
*SUBPLOT--MODIFIED_DATE
269 
*SUBPLOT--MODIFIED_IN_INSTANCE
270 
*SUBPLOT--CYCLE
271 
*SUBPLOT--SUBCYCLE
272 
*SUBPLOT--ROOT_DIS_SEV_CD_PNWRS
273 
*SUBPLOT--NF_SUBP_STATUS_CD
274 
*SUBPLOT--NF_SUBP_NONSAMPLE_REASN_CD
275 
*SUBPLOT--P2VEG_SUBP_STATUS_CD
276 
*SUBPLOT--P2VEG_SUBP_NONSAMPLE_REASN_CD
277 
*SUBPLOT--INVASIVE_SUBP_STATUS_CD
278 
*SUBPLOT--INVASIVE_NONSAMPLE_REASN_CD
279 
*COND--row_num
280 
*COND--CN
281 
*COND--PLT_CN
282 
*COND--COND_STATUS_CD
283 
*COND--COND_NONSAMPLE_REASN_CD
284 
*COND--RESERVCD
285 
*COND--OWNCD
286 
*COND--OWNGRPCD
287 
*COND--FORINDCD
288 
*COND--ADFORCD
289 
*COND--FORTYPCD
290 
*COND--FLDTYPCD
291 
*COND--MAPDEN
292 
*COND--STDAGE
293 
*COND--STDSZCD
294 
*COND--FLDSZCD
295 
*COND--SITECLCD
296 
*COND--SICOND
297 
*COND--SIBASE
298 
*COND--SISP
299 
*COND--STDORGCD
300 
*COND--STDORGSP
301 
*COND--PROP_BASIS
302 
*COND--CONDPROP_UNADJ
303 
*COND--MICRPROP_UNADJ
304 
*COND--SUBPPROP_UNADJ
305 
*COND--MACRPROP_UNADJ
306 
*COND--PHYSCLCD
307 
*COND--GSSTKCD
308 
*COND--ALSTKCD
309 
*COND--DSTRBCD1
310 
*COND--DSTRBYR1
311 
*COND--DSTRBCD2
312 
*COND--DSTRBYR2
313 
*COND--DSTRBCD3
314 
*COND--DSTRBYR3
315 
*COND--TRTCD1
316 
*COND--TRTYR1
317 
*COND--TRTCD2
318 
*COND--TRTYR2
319 
*COND--TRTCD3
320 
*COND--TRTYR3
321 
*COND--PRESNFCD
322 
*COND--BALIVE
323 
*COND--FLDAGE
324 
*COND--ALSTK
325 
*COND--GSSTK
326 
*COND--FORTYPCDCALC
327 
*COND--HABTYPCD1_DESCR_PUB_CD
328 
*COND--HABTYPCD2
329 
*COND--HABTYPCD2_PUB_CD
330 
*COND--HABTYPCD2_DESCR_PUB_CD
331 
*COND--MIXEDCONFCD
332 
*COND--VOL_LOC_GRP
333 
*COND--SITECLCDEST
334 
*COND--SITETREE_TREE
335 
*COND--SITECL_METHOD
336 
*COND--CARBON_DOWN_DEAD
337 
*COND--CARBON_LITTER
338 
*COND--CARBON_SOIL_ORG
339 
*COND--CARBON_STANDING_DEAD
340 
*COND--CARBON_UNDERSTORY_AG
341 
*COND--CARBON_UNDERSTORY_BG
342 
*COND--CREATED_BY
343 
*COND--CREATED_DATE
344 
*COND--CREATED_IN_INSTANCE
345 
*COND--MODIFIED_BY
346 
*COND--MODIFIED_DATE
347 
*COND--MODIFIED_IN_INSTANCE
348 
*COND--CYCLE
349 
*COND--SUBCYCLE
350 
*COND--SOIL_ROOTING_DEPTH_PNW
351 
*COND--GROUND_LAND_CLASS_PNW
352 
*COND--PLANT_STOCKABILITY_FACTOR_PNW
353 
*COND--STND_COND_CD_PNWRS
354 
*COND--STND_STRUC_CD_PNWRS
355 
*COND--STUMP_CD_PNWRS
356 
*COND--FIRE_SRS
357 
*COND--GRAZING_SRS
358 
*COND--HARVEST_TYPE1_SRS
359 
*COND--HARVEST_TYPE2_SRS
360 
*COND--HARVEST_TYPE3_SRS
361 
*COND--LAND_USE_SRS
362 
*COND--OPERABILITY_SRS
363 
*COND--STAND_STRUCTURE_SRS
364 
*COND--NF_COND_STATUS_CD
365 
*COND--NF_COND_NONSAMPLE_REASN_CD
366 
*COND--CANOPY_CVR_SAMPLE_METHOD_CD
367 
*COND--LIVE_CANOPY_CVR_PCT
368 
*COND--LIVE_MISSING_CANOPY_CVR_PCT
369 
*COND--NBR_LIVE_STEMS
370 
*COND--OWNSUBCD
371 
*COND--INDUSTRIALCD_FIADB
372 
*COND--RESERVCD_FLD
373 
*COND--ADMIN_WITHDRAWN_CD
374 
*REF_HABTYP_DESCRIPTION--row_num
375 
*REF_HABTYP_DESCRIPTION--SCIENTIFIC_NAME
376 
*REF_HABTYP_DESCRIPTION--VALID
377 
*REF_HABTYP_DESCRIPTION--CREATED_BY
378 
*REF_HABTYP_DESCRIPTION--CREATED_DATE
379 
*REF_HABTYP_DESCRIPTION--CREATED_IN_INSTANCE
380 
*REF_HABTYP_DESCRIPTION--MODIFIED_BY
381 
*REF_HABTYP_DESCRIPTION--MODIFIED_DATE
382 
*REF_HABTYP_DESCRIPTION--MODIFIED_IN_INSTANCE
383 
*PLOT--row_num
384 
*PLOT--SRV_CN
385 
*PLOT--CTY_CN
386 
*PLOT--PREV_PLT_CN
387 
*PLOT--PLOT_STATUS_CD
388 
*PLOT--PLOT_NONSAMPLE_REASN_CD
389 
year
390 
month
391 
day
392 
*PLOT--REMPER
393 
*PLOT--KINDCD
394 
*PLOT--DESIGNCD
395 
*PLOT--RDDISTCD
396 
*PLOT--WATERCD
397 
elevation_ft
398 
*PLOT--GROW_TYP_CD
399 
*PLOT--MORT_TYP_CD
400 
*PLOT--P2PANEL
401 
*PLOT--P3PANEL
402 
*PLOT--ECOSUBCD
403 
*PLOT--CONGCD
404 
*PLOT--MANUAL
405 
*PLOT--SUBPANEL
406 
*PLOT--KINDCD_NC
407 
*PLOT--QA_STATUS
408 
*PLOT--CREATED_BY
409 
*PLOT--CREATED_DATE
410 
*PLOT--CREATED_IN_INSTANCE
411 
*PLOT--MODIFIED_BY
412 
*PLOT--MODIFIED_DATE
413 
*PLOT--MODIFIED_IN_INSTANCE
414 
*PLOT--MICROPLOT_LOC
415 
*PLOT--DECLINATION
416 
*PLOT--EMAP_HEX
417 
*PLOT--SAMP_METHOD_CD
418 
*PLOT--SUBP_EXAMINE_CD
419 
*PLOT--MACRO_BREAKPOINT_DIA
420 
*PLOT--INTENSITY
421 
*PLOT--CYCLE
422 
*PLOT--SUBCYCLE
423 
*PLOT--ECO_UNIT_PNW
424 
*PLOT--TOPO_POSITION_PNW
425 
*PLOT--NF_SAMPLING_STATUS_CD
426 
*PLOT--NF_PLOT_STATUS_CD
427 
*PLOT--NF_PLOT_NONSAMPLE_REASN_CD
428 
*PLOT--P2VEG_SAMPLING_STATUS_CD
429 
*PLOT--P2VEG_SAMPLING_LEVEL_DETAIL_CD
430 
*PLOT--INVASIVE_SAMPLING_STATUS_CD
431 
*PLOT--INVASIVE_SPECIMEN_RULE_CD
432 
*PLOT--DESIGNCD_P2A
433 
*COUNTY--row_num
434 
*COUNTY--CN
435 
*COUNTY--CREATED_BY
436 
*COUNTY--CREATED_DATE
437 
*COUNTY--CREATED_IN_INSTANCE
438 
*COUNTY--MODIFIED_BY
439 
*COUNTY--MODIFIED_DATE
440 
*COUNTY--MODIFIED_IN_INSTANCE
441 
*REF_UNIT--row_num
442 
*REF_UNIT--MEANING
443 
*REF_UNIT--CREATED_BY
444 
*REF_UNIT--CREATED_DATE
445 
*REF_UNIT--CREATED_IN_INSTANCE
446 
*REF_UNIT--MODIFIED_BY
447 
*REF_UNIT--MODIFIED_DATE
448 
*REF_UNIT--MODIFIED_IN_INSTANCE
449 
*REF_RESEARCH_STATION--row_num
450 
*REF_RESEARCH_STATION--RSCD
451 
*REF_RESEARCH_STATION--RS
452 
*REF_RESEARCH_STATION--STATE_ABBR
453 
*REF_RESEARCH_STATION--CREATED_BY
454 
*REF_RESEARCH_STATION--CREATED_DATE
455 
*REF_RESEARCH_STATION--CREATED_IN_INSTANCE
456 
*REF_RESEARCH_STATION--MODIFIED_BY
457 
*REF_RESEARCH_STATION--MODIFIED_DATE
458 
*REF_RESEARCH_STATION--MODIFIED_IN_INSTANCE
inputs/FIA/occurrence_all/header.csv
1 
row_num,*STATECD,*UNITCD,*COUNTYCD,*INVYR,locationName,*HABTYPCD,*HABTYP_PUB_CD,authorEventCode,subplot,*PLANT_SYMBOL,*PLANT_SYMBOL_TYPE,*SPCD,*TREE--row_num,individualObservationID,*TREE--PLT_CN,*TREE--PREV_TRE_CN,individualCode,*TREE--AZIMUTH,*TREE--DIST,*TREE--PREVCOND,*TREE--STATUSCD,*TREE--SPGRPCD,diameterBreastHeight_in,*TREE--DIAHTCD,height_ft,*TREE--HTCD,*TREE--ACTUALHT,*TREE--TREECLCD,*TREE--CR,*TREE--CCLCD,*TREE--TREEGRCD,*TREE--AGENTCD,*TREE--CULL,*TREE--DAMLOC1,*TREE--DAMTYP1,*TREE--DAMSEV1,*TREE--DAMLOC2,*TREE--DAMTYP2,*TREE--DAMSEV2,*TREE--DECAYCD,*TREE--STOCKING,*TREE--WDLDSTEM,*TREE--VOLCFNET,*TREE--VOLCFGRS,*TREE--VOLCSNET,*TREE--VOLCSGRS,*TREE--VOLBFNET,*TREE--VOLBFGRS,*TREE--VOLCFSND,*TREE--GROWCFGS,*TREE--GROWBFSL,*TREE--GROWCFAL,*TREE--MORTCFGS,*TREE--MORTBFSL,*TREE--MORTCFAL,*TREE--REMVCFGS,*TREE--REMVBFSL,*TREE--REMVCFAL,*TREE--DIACHECK,*TREE--MORTYR,*TREE--SALVCD,*TREE--UNCRCD,*TREE--CPOSCD,*TREE--CLIGHTCD,*TREE--CVIGORCD,*TREE--CDENCD,*TREE--CDIEBKCD,*TREE--TRANSCD,*TREE--TREEHISTCD,*TREE--DIACALC,*TREE--BHAGE,*TREE--TOTAGE,*TREE--CULLDEAD,*TREE--CULLFORM,*TREE--CULLMSTOP,*TREE--CULLBF,*TREE--CULLCF,*TREE--BFSND,*TREE--CFSND,*TREE--SAWHT,*BOLEHT,*TREE--FORMCL,*TREE--HTCALC,*TREE--HRDWD_CLUMP_CD,*TREE--SITREE,*TREE--CREATED_BY,*TREE--CREATED_DATE,*TREE--CREATED_IN_INSTANCE,*TREE--MODIFIED_BY,*TREE--MODIFIED_DATE,*TREE--MODIFIED_IN_INSTANCE,*TREE--MORTCD,*TREE--HTDMP,*TREE--ROUGHCULL,*TREE--MIST_CL_CD,*TREE--CULL_FLD,*TREE--RECONCILECD,*TREE--PREVDIA,*TREE--FGROWCFGS,*TREE--FGROWBFSL,*TREE--FGROWCFAL,*TREE--FMORTCFGS,*TREE--FMORTBFSL,*TREE--FMORTCFAL,*TREE--FREMVCFGS,*TREE--FREMVBFSL,*TREE--FREMVCFAL,*TREE--P2A_GRM_FLG,*TREE--TREECLCD_NERS,*TREE--TREECLCD_SRS,*TREE--TREECLCD_NCRS,*TREE--TREECLCD_RMRS,*TREE--STANDING_DEAD_CD,*TREE--PREV_STATUS_CD,*TREE--PREV_WDLDSTEM,*TREE--TPA_UNADJ,*TREE--TPAMORT_UNADJ,*TREE--TPAREMV_UNADJ,*TREE--TPAGROW_UNADJ,*TREE--DRYBIO_BOLE,*TREE--DRYBIO_TOP,*TREE--DRYBIO_STUMP,*TREE--DRYBIO_SAPLING,*TREE--DRYBIO_WDLD_SPP,*TREE--DRYBIO_BG,*TREE--CARBON_AG,*TREE--CARBON_BG,*TREE--CYCLE,*TREE--SUBCYCLE,*TREE--BORED_CD_PNWRS,*TREE--DAMLOC1_PNWRS,*TREE--DAMLOC2_PNWRS,*TREE--DIACHECK_PNWRS,*TREE--DMG_AGENT1_CD_PNWRS,*TREE--DMG_AGENT2_CD_PNWRS,*TREE--DMG_AGENT3_CD_PNWRS,*TREE--MIST_CL_CD_PNWRS,*TREE--SEVERITY1_CD_PNWRS,*TREE--SEVERITY1A_CD_PNWRS,*TREE--SEVERITY1B_CD_PNWRS,*TREE--SEVERITY2_CD_PNWRS,*TREE--SEVERITY2A_CD_PNWRS,*TREE--SEVERITY2B_CD_PNWRS,*TREE--SEVERITY3_CD_PNWRS,*TREE--UNKNOWN_DAMTYP1_PNWRS,*TREE--UNKNOWN_DAMTYP2_PNWRS,*TREE--PREV_PNTN_SRS,*TREE--DISEASE_SRS,*TREE--DIEBACK_SEVERITY_SRS,*REF_SPECIES--row_num,*REF_SPECIES--COMMON_NAME,*REF_SPECIES--GENUS,*REF_SPECIES--SPECIES,*REF_SPECIES--VARIETY,*REF_SPECIES--SUBSPECIES,*REF_SPECIES--E_SPGRPCD,*REF_SPECIES--W_SPGRPCD,*REF_SPECIES--C_SPGRPCD,*REF_SPECIES--P_SPGRPCD,*REF_SPECIES--MAJOR_SPGRPCD,*REF_SPECIES--STOCKING_SPGRPCD,*REF_SPECIES--FOREST_TYPE_SPGRPCD,*REF_SPECIES--EXISTS_IN_NCRS,*REF_SPECIES--EXISTS_IN_NERS,*REF_SPECIES--EXISTS_IN_PNWRS,*REF_SPECIES--EXISTS_IN_RMRS,*REF_SPECIES--EXISTS_IN_SRS,*REF_SPECIES--SITETREE,*REF_SPECIES--SFTWD_HRDWD,*REF_SPECIES--ST_EXISTS_IN_NCRS,*REF_SPECIES--ST_EXISTS_IN_NERS,*REF_SPECIES--ST_EXISTS_IN_PNWRS,*REF_SPECIES--ST_EXISTS_IN_RMRS,*REF_SPECIES--ST_EXISTS_IN_SRS,*REF_SPECIES--CORE,*REF_SPECIES--EAST,*REF_SPECIES--WEST,*REF_SPECIES--CARIBBEAN,*REF_SPECIES--PACIFIC,*REF_SPECIES--WOODLAND,*REF_SPECIES--MANUAL_START,*REF_SPECIES--MANUAL_END,*REF_SPECIES--JENKINS_SPGRPCD,*REF_SPECIES--JENKINS_TOTAL_B1,*REF_SPECIES--JENKINS_TOTAL_B2,*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B1,*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B2,*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B1,*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B2,*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B1,*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B2,*REF_SPECIES--JENKINS_ROOT_RATIO_B1,*REF_SPECIES--JENKINS_ROOT_RATIO_B2,*REF_SPECIES--JENKINS_SAPLING_ADJUSTMENT,*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT,*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT,*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES--MC_PCT_GREEN_BARK,*REF_SPECIES--MC_PCT_GREEN_BARK_CIT,*REF_SPECIES--MC_PCT_GREEN_WOOD,*REF_SPECIES--MC_PCT_GREEN_WOOD_CIT,*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT,*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT_CIT,*REF_SPECIES--BARK_VOL_PCT,*REF_SPECIES--BARK_VOL_PCT_CIT,*REF_SPECIES--RAILE_STUMP_DOB_B1,*REF_SPECIES--RAILE_STUMP_DIB_B1,*REF_SPECIES--RAILE_STUMP_DIB_B2,*REF_SPECIES--CWD_DECAY_RATIO1,*REF_SPECIES--CWD_DECAY_RATIO2,*REF_SPECIES--CWD_DECAY_RATIO3,*REF_SPECIES--CWD_DECAY_RATIO4,*REF_SPECIES--CWD_DECAY_RATIO5,*REF_SPECIES--DWM_CARBON_RATIO,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO1,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO2,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO3,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO4,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO5,*REF_SPECIES--CREATED_BY,*REF_SPECIES--CREATED_DATE,*REF_SPECIES--CREATED_IN_INSTANCE,*REF_SPECIES--MODIFIED_BY,*REF_SPECIES--MODIFIED_DATE,*REF_SPECIES--MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY--row_num,*REF_PLANT_DICTIONARY--CN,taxonName,*REF_PLANT_DICTIONARY--NEW_SYMBOL,*REF_PLANT_DICTIONARY--NEW_SCIENTIFIC_NAME,vernacularName,*REF_PLANT_DICTIONARY--CATEGORY,family,taxonGrowthForm,*REF_PLANT_DICTIONARY--DURATION,*REF_PLANT_DICTIONARY--US_NATIVITY,*REF_PLANT_DICTIONARY--STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY--STATE_AND_PROVINCE,scientificName,*GENERA_BINOMIAL_AUTHOR,*TRINOMIAL_AUTHOR,*QUADRINOMIAL_AUTHOR,*XGENUS,genus,*XSPECIES,specificEpithet,*SSP_PREFIX,*XSUBSPECIES,subspecies,*VAR_PREFIX,*XVARIETY,variety,*SUBVAR,*SUBVARIETY,*F_PREFIX,forma,*REF_PLANT_DICTIONARY--NOTES,*REF_PLANT_DICTIONARY--CREATED_BY,*REF_PLANT_DICTIONARY--CREATED_DATE,*REF_PLANT_DICTIONARY--CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY--MODIFIED_BY,*REF_PLANT_DICTIONARY--MODIFIED_DATE,*REF_PLANT_DICTIONARY--MODIFIED_IN_INSTANCE,*SUBPLOT--row_num,subplotID,*SUBPLOT--PLT_CN,*SUBPLOT--PREV_SBP_CN,*SUBPLOT--SUBP_STATUS_CD,*SUBPLOT--POINT_NONSAMPLE_REASN_CD,*SUBPLOT--MICRCOND,*SUBPLOT--SUBPCOND,*SUBPLOT--MACRCOND,*SUBPLOT--CONDLIST,*SUBPLOT--SLOPE,*SUBPLOT--ASPECT,*SUBPLOT--WATERDEP,*SUBPLOT--P2A_GRM_FLG,*SUBPLOT--CREATED_BY,*SUBPLOT--CREATED_DATE,*SUBPLOT--CREATED_IN_INSTANCE,*SUBPLOT--MODIFIED_BY,*SUBPLOT--MODIFIED_DATE,*SUBPLOT--MODIFIED_IN_INSTANCE,*SUBPLOT--CYCLE,*SUBPLOT--SUBCYCLE,*SUBPLOT--ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT--NF_SUBP_STATUS_CD,*SUBPLOT--NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT--P2VEG_SUBP_STATUS_CD,*SUBPLOT--P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT--INVASIVE_SUBP_STATUS_CD,*SUBPLOT--INVASIVE_NONSAMPLE_REASN_CD,*COND--row_num,*COND--CN,*COND--PLT_CN,*COND--COND_STATUS_CD,*COND--COND_NONSAMPLE_REASN_CD,*COND--RESERVCD,*COND--OWNCD,*COND--OWNGRPCD,*COND--FORINDCD,*COND--ADFORCD,*COND--FORTYPCD,*COND--FLDTYPCD,*COND--MAPDEN,*COND--STDAGE,*COND--STDSZCD,*COND--FLDSZCD,*COND--SITECLCD,*COND--SICOND,*COND--SIBASE,*COND--SISP,*COND--STDORGCD,*COND--STDORGSP,*COND--PROP_BASIS,*COND--CONDPROP_UNADJ,*COND--MICRPROP_UNADJ,*COND--SUBPPROP_UNADJ,*COND--MACRPROP_UNADJ,slopeGradient,slopeAspect,*COND--PHYSCLCD,*COND--GSSTKCD,*COND--ALSTKCD,*COND--DSTRBCD1,*COND--DSTRBYR1,*COND--DSTRBCD2,*COND--DSTRBYR2,*COND--DSTRBCD3,*COND--DSTRBYR3,*COND--TRTCD1,*COND--TRTYR1,*COND--TRTCD2,*COND--TRTYR2,*COND--TRTCD3,*COND--TRTYR3,*COND--PRESNFCD,*COND--BALIVE,*COND--FLDAGE,*COND--ALSTK,*COND--GSSTK,*COND--FORTYPCDCALC,*COND--HABTYPCD1_DESCR_PUB_CD,*COND--HABTYPCD2,*COND--HABTYPCD2_PUB_CD,*COND--HABTYPCD2_DESCR_PUB_CD,*COND--MIXEDCONFCD,*COND--VOL_LOC_GRP,*COND--SITECLCDEST,*COND--SITETREE_TREE,*COND--SITECL_METHOD,*COND--CARBON_DOWN_DEAD,*COND--CARBON_LITTER,*COND--CARBON_SOIL_ORG,*COND--CARBON_STANDING_DEAD,*COND--CARBON_UNDERSTORY_AG,*COND--CARBON_UNDERSTORY_BG,*COND--CREATED_BY,*COND--CREATED_DATE,*COND--CREATED_IN_INSTANCE,*COND--MODIFIED_BY,*COND--MODIFIED_DATE,*COND--MODIFIED_IN_INSTANCE,*COND--CYCLE,*COND--SUBCYCLE,*COND--SOIL_ROOTING_DEPTH_PNW,*COND--GROUND_LAND_CLASS_PNW,*COND--PLANT_STOCKABILITY_FACTOR_PNW,*COND--STND_COND_CD_PNWRS,*COND--STND_STRUC_CD_PNWRS,*COND--STUMP_CD_PNWRS,*COND--FIRE_SRS,*COND--GRAZING_SRS,*COND--HARVEST_TYPE1_SRS,*COND--HARVEST_TYPE2_SRS,*COND--HARVEST_TYPE3_SRS,*COND--LAND_USE_SRS,*COND--OPERABILITY_SRS,*COND--STAND_STRUCTURE_SRS,*COND--NF_COND_STATUS_CD,*COND--NF_COND_NONSAMPLE_REASN_CD,*COND--CANOPY_CVR_SAMPLE_METHOD_CD,*COND--LIVE_CANOPY_CVR_PCT,*COND--LIVE_MISSING_CANOPY_CVR_PCT,*COND--NBR_LIVE_STEMS,*COND--OWNSUBCD,*COND--INDUSTRIALCD_FIADB,*COND--RESERVCD_FLD,*COND--ADMIN_WITHDRAWN_CD,oldGrowth,cultivated,*REF_HABTYP_DESCRIPTION--row_num,communityID,*REF_HABTYP_DESCRIPTION--SCIENTIFIC_NAME,communityName,*REF_HABTYP_DESCRIPTION--VALID,*REF_HABTYP_DESCRIPTION--CREATED_BY,*REF_HABTYP_DESCRIPTION--CREATED_DATE,*REF_HABTYP_DESCRIPTION--CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION--MODIFIED_BY,*REF_HABTYP_DESCRIPTION--MODIFIED_DATE,*REF_HABTYP_DESCRIPTION--MODIFIED_IN_INSTANCE,*PLOT--row_num,locationID,*PLOT--SRV_CN,*PLOT--CTY_CN,*PLOT--PREV_PLT_CN,*PLOT--PLOT_STATUS_CD,*PLOT--PLOT_NONSAMPLE_REASN_CD,year,month,day,*PLOT--REMPER,*PLOT--KINDCD,*PLOT--DESIGNCD,*PLOT--RDDISTCD,*PLOT--WATERCD,decimalLatitude,decimalLongitude,elevation_ft,*PLOT--GROW_TYP_CD,*PLOT--MORT_TYP_CD,*PLOT--P2PANEL,*PLOT--P3PANEL,*PLOT--ECOSUBCD,*PLOT--CONGCD,*PLOT--MANUAL,*PLOT--SUBPANEL,*PLOT--KINDCD_NC,*PLOT--QA_STATUS,*PLOT--CREATED_BY,*PLOT--CREATED_DATE,*PLOT--CREATED_IN_INSTANCE,*PLOT--MODIFIED_BY,*PLOT--MODIFIED_DATE,*PLOT--MODIFIED_IN_INSTANCE,*PLOT--MICROPLOT_LOC,*PLOT--DECLINATION,*PLOT--EMAP_HEX,*PLOT--SAMP_METHOD_CD,*PLOT--SUBP_EXAMINE_CD,*PLOT--MACRO_BREAKPOINT_DIA,*PLOT--INTENSITY,*PLOT--CYCLE,*PLOT--SUBCYCLE,*PLOT--ECO_UNIT_PNW,*PLOT--TOPO_POSITION_PNW,*PLOT--NF_SAMPLING_STATUS_CD,*PLOT--NF_PLOT_STATUS_CD,*PLOT--NF_PLOT_NONSAMPLE_REASN_CD,*PLOT--P2VEG_SAMPLING_STATUS_CD,*PLOT--P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT--INVASIVE_SAMPLING_STATUS_CD,*PLOT--INVASIVE_SPECIMEN_RULE_CD,*PLOT--DESIGNCD_P2A,*COUNTY--row_num,county,*COUNTY--CN,*COUNTY--CREATED_BY,*COUNTY--CREATED_DATE,*COUNTY--CREATED_IN_INSTANCE,*COUNTY--MODIFIED_BY,*COUNTY--MODIFIED_DATE,*COUNTY--MODIFIED_IN_INSTANCE,*REF_UNIT--row_num,*REF_UNIT--MEANING,*REF_UNIT--CREATED_BY,*REF_UNIT--CREATED_DATE,*REF_UNIT--CREATED_IN_INSTANCE,*REF_UNIT--MODIFIED_BY,*REF_UNIT--MODIFIED_DATE,*REF_UNIT--MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION--row_num,*REF_RESEARCH_STATION--RSCD,*REF_RESEARCH_STATION--RS,stateProvince,*REF_RESEARCH_STATION--STATE_ABBR,*REF_RESEARCH_STATION--CREATED_BY,*REF_RESEARCH_STATION--CREATED_DATE,*REF_RESEARCH_STATION--CREATED_IN_INSTANCE,*REF_RESEARCH_STATION--MODIFIED_BY,*REF_RESEARCH_STATION--MODIFIED_DATE,*REF_RESEARCH_STATION--MODIFIED_IN_INSTANCE
inputs/FIA/occurrence_all/postprocess.sql
1 
SELECT util.search_path_append('util');
2 

  		




  3
  
  
    
SELECT force_update_view(:table_str, $$


  		




  4
  
  
    
SELECT "*TREE--row_num" AS "row_num", *


  		




  5
  
  
    
/* directional joins ensure that the PostgreSQL query planner always joins


  		




  6
  
  
    
starting with the TREE table */


  		




  7
  
  
    
FROM              "TREE"


  		




  8
  
  
    
NATURAL LEFT JOIN "REF_SPECIES"


  		




  9
  
  
    
NATURAL LEFT JOIN "REF_PLANT_DICTIONARY"


  		




  10
  
  
    
NATURAL LEFT JOIN "SUBPLOT"


  		




  11
  
  
    
NATURAL LEFT JOIN "COND"


  		




  12
  
  
    
NATURAL LEFT JOIN "REF_HABTYP_DESCRIPTION"


  		




  13
  
  
    
NATURAL LEFT JOIN "PLOT"


  		




  14
  
  
    
NATURAL LEFT JOIN "COUNTY"


  		




  15
  
  
    
NATURAL LEFT JOIN "REF_UNIT"


  		




  16
  
  
    
NATURAL LEFT JOIN "REF_RESEARCH_STATION"


  		




  17
  
  
    
$$);


  		




  18
  
  
    

  		




  19
  
  
    
SELECT mk_subset_by_row_num_func(:table_str, 'row_num');


  		












  

    
      inputs/FIA/occurrence_all/run
    
  





  1
  
  
    
#!/bin/bash -e


  		




  2
  
  
    
. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/runscripts/view.run


  		




  3
  0
  
    

  		












  

    
      inputs/FIA/occurrence_all/map.csv
    
  





  1
  
  
    
FIA,VegCore,Filter,Comments


  		




  2
  
  
    
row_num,row_num,,


  		




  3
  
  
    
*STATECD,*STATECD,,


  		




  4
  
  
    
*UNITCD,*UNITCD,,


  		




  5
  
  
    
*COUNTYCD,*COUNTYCD,,


  		




  6
  
  
    
*INVYR,*INVYR,,


  		




  7
  
  
    
locationName,locationName,,


  		




  8
  
  
    
*HABTYPCD,*HABTYPCD,,


  		




  9
  
  
    
*HABTYP_PUB_CD,*HABTYP_PUB_CD,,


  		




  10
  
  
    
authorEventCode,authorEventCode,,


  		




  11
  
  
    
subplot,subplot,,


  		




  12
  
  
    
*PLANT_SYMBOL,*PLANT_SYMBOL,,


  		




  13
  
  
    
*PLANT_SYMBOL_TYPE,*PLANT_SYMBOL_TYPE,,


  		




  14
  
  
    
*SPCD,*SPCD,,


  		




  15
  
  
    
*TREE--row_num,*TREE--row_num,,


  		




  16
  
  
    
individualObservationID,individualObservationID,,


  		




  17
  
  
    
*TREE--PLT_CN,*TREE--PLT_CN,,


  		




  18
  
  
    
*TREE--PREV_TRE_CN,*TREE--PREV_TRE_CN,,


  		




  19
  
  
    
individualCode,individualCode,,


  		




  20
  
  
    
*TREE--AZIMUTH,*TREE--AZIMUTH,,


  		




  21
  
  
    
*TREE--DIST,*TREE--DIST,,


  		




  22
  
  
    
*TREE--PREVCOND,*TREE--PREVCOND,,


  		




  23
  
  
    
*TREE--STATUSCD,*TREE--STATUSCD,,


  		




  24
  
  
    
*TREE--SPGRPCD,*TREE--SPGRPCD,,


  		




  25
  
  
    
diameterBreastHeight_in,diameterBreastHeight_in,,


  		




  26
  
  
    
*TREE--DIAHTCD,*TREE--DIAHTCD,,


  		




  27
  
  
    
height_ft,height_ft,,


  		




  28
  
  
    
*TREE--HTCD,*TREE--HTCD,,


  		




  29
  
  
    
*TREE--ACTUALHT,*TREE--ACTUALHT,,


  		




  30
  
  
    
*TREE--TREECLCD,*TREE--TREECLCD,,


  		




  31
  
  
    
*TREE--CR,*TREE--CR,,


  		




  32
  
  
    
*TREE--CCLCD,*TREE--CCLCD,,


  		




  33
  
  
    
*TREE--TREEGRCD,*TREE--TREEGRCD,,


  		




  34
  
  
    
*TREE--AGENTCD,*TREE--AGENTCD,,


  		




  35
  
  
    
*TREE--CULL,*TREE--CULL,,


  		




  36
  
  
    
*TREE--DAMLOC1,*TREE--DAMLOC1,,


  		




  37
  
  
    
*TREE--DAMTYP1,*TREE--DAMTYP1,,


  		




  38
  
  
    
*TREE--DAMSEV1,*TREE--DAMSEV1,,


  		




  39
  
  
    
*TREE--DAMLOC2,*TREE--DAMLOC2,,


  		




  40
  
  
    
*TREE--DAMTYP2,*TREE--DAMTYP2,,


  		




  41
  
  
    
*TREE--DAMSEV2,*TREE--DAMSEV2,,


  		




  42
  
  
    
*TREE--DECAYCD,*TREE--DECAYCD,,


  		




  43
  
  
    
*TREE--STOCKING,*TREE--STOCKING,,


  		




  44
  
  
    
*TREE--WDLDSTEM,*TREE--WDLDSTEM,,


  		




  45
  
  
    
*TREE--VOLCFNET,*TREE--VOLCFNET,,


  		




  46
  
  
    
*TREE--VOLCFGRS,*TREE--VOLCFGRS,,


  		




  47
  
  
    
*TREE--VOLCSNET,*TREE--VOLCSNET,,


  		




  48
  
  
    
*TREE--VOLCSGRS,*TREE--VOLCSGRS,,


  		




  49
  
  
    
*TREE--VOLBFNET,*TREE--VOLBFNET,,


  		




  50
  
  
    
*TREE--VOLBFGRS,*TREE--VOLBFGRS,,


  		




  51
  
  
    
*TREE--VOLCFSND,*TREE--VOLCFSND,,


  		




  52
  
  
    
*TREE--GROWCFGS,*TREE--GROWCFGS,,


  		




  53
  
  
    
*TREE--GROWBFSL,*TREE--GROWBFSL,,


  		




  54
  
  
    
*TREE--GROWCFAL,*TREE--GROWCFAL,,


  		




  55
  
  
    
*TREE--MORTCFGS,*TREE--MORTCFGS,,


  		




  56
  
  
    
*TREE--MORTBFSL,*TREE--MORTBFSL,,


  		




  57
  
  
    
*TREE--MORTCFAL,*TREE--MORTCFAL,,


  		




  58
  
  
    
*TREE--REMVCFGS,*TREE--REMVCFGS,,


  		




  59
  
  
    
*TREE--REMVBFSL,*TREE--REMVBFSL,,


  		




  60
  
  
    
*TREE--REMVCFAL,*TREE--REMVCFAL,,


  		




  61
  
  
    
*TREE--DIACHECK,*TREE--DIACHECK,,


  		




  62
  
  
    
*TREE--MORTYR,*TREE--MORTYR,,


  		




  63
  
  
    
*TREE--SALVCD,*TREE--SALVCD,,


  		




  64
  
  
    
*TREE--UNCRCD,*TREE--UNCRCD,,


  		




  65
  
  
    
*TREE--CPOSCD,*TREE--CPOSCD,,


  		




  66
  
  
    
*TREE--CLIGHTCD,*TREE--CLIGHTCD,,


  		




  67
  
  
    
*TREE--CVIGORCD,*TREE--CVIGORCD,,


  		




  68
  
  
    
*TREE--CDENCD,*TREE--CDENCD,,


  		




  69
  
  
    
*TREE--CDIEBKCD,*TREE--CDIEBKCD,,


  		




  70
  
  
    
*TREE--TRANSCD,*TREE--TRANSCD,,


  		




  71
  
  
    
*TREE--TREEHISTCD,*TREE--TREEHISTCD,,


  		




  72
  
  
    
*TREE--DIACALC,*TREE--DIACALC,,


  		




  73
  
  
    
*TREE--BHAGE,*TREE--BHAGE,,


  		




  74
  
  
    
*TREE--TOTAGE,*TREE--TOTAGE,,


  		




  75
  
  
    
*TREE--CULLDEAD,*TREE--CULLDEAD,,


  		




  76
  
  
    
*TREE--CULLFORM,*TREE--CULLFORM,,


  		




  77
  
  
    
*TREE--CULLMSTOP,*TREE--CULLMSTOP,,


  		




  78
  
  
    
*TREE--CULLBF,*TREE--CULLBF,,


  		




  79
  
  
    
*TREE--CULLCF,*TREE--CULLCF,,


  		




  80
  
  
    
*TREE--BFSND,*TREE--BFSND,,


  		




  81
  
  
    
*TREE--CFSND,*TREE--CFSND,,


  		




  82
  
  
    
*TREE--SAWHT,*TREE--SAWHT,,


  		




  83
  
  
    
*BOLEHT,*BOLEHT,,


  		




  84
  
  
    
*TREE--FORMCL,*TREE--FORMCL,,


  		




  85
  
  
    
*TREE--HTCALC,*TREE--HTCALC,,


  		




  86
  
  
    
*TREE--HRDWD_CLUMP_CD,*TREE--HRDWD_CLUMP_CD,,


  		




  87
  
  
    
*TREE--SITREE,*TREE--SITREE,,


  		




  88
  
  
    
*TREE--CREATED_BY,*TREE--CREATED_BY,,


  		




  89
  
  
    
*TREE--CREATED_DATE,*TREE--CREATED_DATE,,


  		




  90
  
  
    
*TREE--CREATED_IN_INSTANCE,*TREE--CREATED_IN_INSTANCE,,


  		




  91
  
  
    
*TREE--MODIFIED_BY,*TREE--MODIFIED_BY,,


  		




  92
  
  
    
*TREE--MODIFIED_DATE,*TREE--MODIFIED_DATE,,


  		




  93
  
  
    
*TREE--MODIFIED_IN_INSTANCE,*TREE--MODIFIED_IN_INSTANCE,,


  		




  94
  
  
    
*TREE--MORTCD,*TREE--MORTCD,,


  		




  95
  
  
    
*TREE--HTDMP,*TREE--HTDMP,,


  		




  96
  
  
    
*TREE--ROUGHCULL,*TREE--ROUGHCULL,,


  		




  97
  
  
    
*TREE--MIST_CL_CD,*TREE--MIST_CL_CD,,


  		




  98
  
  
    
*TREE--CULL_FLD,*TREE--CULL_FLD,,


  		




  99
  
  
    
*TREE--RECONCILECD,*TREE--RECONCILECD,,


  		




  100
  
  
    
*TREE--PREVDIA,*TREE--PREVDIA,,


  		




  101
  
  
    
*TREE--FGROWCFGS,*TREE--FGROWCFGS,,


  		




  102
  
  
    
*TREE--FGROWBFSL,*TREE--FGROWBFSL,,


  		




  103
  
  
    
*TREE--FGROWCFAL,*TREE--FGROWCFAL,,


  		




  104
  
  
    
*TREE--FMORTCFGS,*TREE--FMORTCFGS,,


  		




  105
  
  
    
*TREE--FMORTBFSL,*TREE--FMORTBFSL,,


  		




  106
  
  
    
*TREE--FMORTCFAL,*TREE--FMORTCFAL,,


  		




  107
  
  
    
*TREE--FREMVCFGS,*TREE--FREMVCFGS,,


  		




  108
  
  
    
*TREE--FREMVBFSL,*TREE--FREMVBFSL,,


  		




  109
  
  
    
*TREE--FREMVCFAL,*TREE--FREMVCFAL,,


  		




  110
  
  
    
*TREE--P2A_GRM_FLG,*TREE--P2A_GRM_FLG,,


  		




  111
  
  
    
*TREE--TREECLCD_NERS,*TREE--TREECLCD_NERS,,


  		




  112
  
  
    
*TREE--TREECLCD_SRS,*TREE--TREECLCD_SRS,,


  		




  113
  
  
    
*TREE--TREECLCD_NCRS,*TREE--TREECLCD_NCRS,,


  		




  114
  
  
    
*TREE--TREECLCD_RMRS,*TREE--TREECLCD_RMRS,,


  		




  115
  
  
    
*TREE--STANDING_DEAD_CD,*TREE--STANDING_DEAD_CD,,


  		




  116
  
  
    
*TREE--PREV_STATUS_CD,*TREE--PREV_STATUS_CD,,


  		




  117
  
  
    
*TREE--PREV_WDLDSTEM,*TREE--PREV_WDLDSTEM,,


  		




  118
  
  
    
*TREE--TPA_UNADJ,*TREE--TPA_UNADJ,,


  		




  119
  
  
    
*TREE--TPAMORT_UNADJ,*TREE--TPAMORT_UNADJ,,


  		




  120
  
  
    
*TREE--TPAREMV_UNADJ,*TREE--TPAREMV_UNADJ,,


  		




  121
  
  
    
*TREE--TPAGROW_UNADJ,*TREE--TPAGROW_UNADJ,,


  		




  122
  
  
    
*TREE--DRYBIO_BOLE,*TREE--DRYBIO_BOLE,,


  		




  123
  
  
    
*TREE--DRYBIO_TOP,*TREE--DRYBIO_TOP,,


  		




  124
  
  
    
*TREE--DRYBIO_STUMP,*TREE--DRYBIO_STUMP,,


  		




  125
  
  
    
*TREE--DRYBIO_SAPLING,*TREE--DRYBIO_SAPLING,,


  		




  126
  
  
    
*TREE--DRYBIO_WDLD_SPP,*TREE--DRYBIO_WDLD_SPP,,


  		




  127
  
  
    
*TREE--DRYBIO_BG,*TREE--DRYBIO_BG,,


  		




  128
  
  
    
*TREE--CARBON_AG,*TREE--CARBON_AG,,


  		




  129
  
  
    
*TREE--CARBON_BG,*TREE--CARBON_BG,,


  		




  130
  
  
    
*TREE--CYCLE,*TREE--CYCLE,,


  		




  131
  
  
    
*TREE--SUBCYCLE,*TREE--SUBCYCLE,,


  		




  132
  
  
    
*TREE--BORED_CD_PNWRS,*TREE--BORED_CD_PNWRS,,


  		




  133
  
  
    
*TREE--DAMLOC1_PNWRS,*TREE--DAMLOC1_PNWRS,,


  		




  134
  
  
    
*TREE--DAMLOC2_PNWRS,*TREE--DAMLOC2_PNWRS,,


  		




  135
  
  
    
*TREE--DIACHECK_PNWRS,*TREE--DIACHECK_PNWRS,,


  		




  136
  
  
    
*TREE--DMG_AGENT1_CD_PNWRS,*TREE--DMG_AGENT1_CD_PNWRS,,


  		




  137
  
  
    
*TREE--DMG_AGENT2_CD_PNWRS,*TREE--DMG_AGENT2_CD_PNWRS,,


  		




  138
  
  
    
*TREE--DMG_AGENT3_CD_PNWRS,*TREE--DMG_AGENT3_CD_PNWRS,,


  		




  139
  
  
    
*TREE--MIST_CL_CD_PNWRS,*TREE--MIST_CL_CD_PNWRS,,


  		




  140
  
  
    
*TREE--SEVERITY1_CD_PNWRS,*TREE--SEVERITY1_CD_PNWRS,,


  		




  141
  
  
    
*TREE--SEVERITY1A_CD_PNWRS,*TREE--SEVERITY1A_CD_PNWRS,,


  		




  142
  
  
    
*TREE--SEVERITY1B_CD_PNWRS,*TREE--SEVERITY1B_CD_PNWRS,,


  		




  143
  
  
    
*TREE--SEVERITY2_CD_PNWRS,*TREE--SEVERITY2_CD_PNWRS,,


  		




  144
  
  
    
*TREE--SEVERITY2A_CD_PNWRS,*TREE--SEVERITY2A_CD_PNWRS,,


  		




  145
  
  
    
*TREE--SEVERITY2B_CD_PNWRS,*TREE--SEVERITY2B_CD_PNWRS,,


  		




  146
  
  
    
*TREE--SEVERITY3_CD_PNWRS,*TREE--SEVERITY3_CD_PNWRS,,


  		




  147
  
  
    
*TREE--UNKNOWN_DAMTYP1_PNWRS,*TREE--UNKNOWN_DAMTYP1_PNWRS,,


  		




  148
  
  
    
*TREE--UNKNOWN_DAMTYP2_PNWRS,*TREE--UNKNOWN_DAMTYP2_PNWRS,,


  		




  149
  
  
    
*TREE--PREV_PNTN_SRS,*TREE--PREV_PNTN_SRS,,


  		




  150
  
  
    
*TREE--DISEASE_SRS,*TREE--DISEASE_SRS,,


  		




  151
  
  
    
*TREE--DIEBACK_SEVERITY_SRS,*TREE--DIEBACK_SEVERITY_SRS,,


  		




  152
  
  
    
*REF_SPECIES--row_num,*REF_SPECIES--row_num,,


  		




  153
  
  
    
*REF_SPECIES--COMMON_NAME,*REF_SPECIES--COMMON_NAME,,


  		




  154
  
  
    
*REF_SPECIES--GENUS,*REF_SPECIES--GENUS,,


  		




  155
  
  
    
*REF_SPECIES--SPECIES,*REF_SPECIES--SPECIES,,


  		




  156
  
  
    
*REF_SPECIES--VARIETY,*REF_SPECIES--VARIETY,,


  		




  157
  
  
    
*REF_SPECIES--SUBSPECIES,*REF_SPECIES--SUBSPECIES,,


  		




  158
  
  
    
*REF_SPECIES--E_SPGRPCD,*REF_SPECIES--E_SPGRPCD,,


  		




  159
  
  
    
*REF_SPECIES--W_SPGRPCD,*REF_SPECIES--W_SPGRPCD,,


  		




  160
  
  
    
*REF_SPECIES--C_SPGRPCD,*REF_SPECIES--C_SPGRPCD,,


  		




  161
  
  
    
*REF_SPECIES--P_SPGRPCD,*REF_SPECIES--P_SPGRPCD,,


  		




  162
  
  
    
*REF_SPECIES--MAJOR_SPGRPCD,*REF_SPECIES--MAJOR_SPGRPCD,,


  		




  163
  
  
    
*REF_SPECIES--STOCKING_SPGRPCD,*REF_SPECIES--STOCKING_SPGRPCD,,


  		




  164
  
  
    
*REF_SPECIES--FOREST_TYPE_SPGRPCD,*REF_SPECIES--FOREST_TYPE_SPGRPCD,,


  		




  165
  
  
    
*REF_SPECIES--EXISTS_IN_NCRS,*REF_SPECIES--EXISTS_IN_NCRS,,


  		




  166
  
  
    
*REF_SPECIES--EXISTS_IN_NERS,*REF_SPECIES--EXISTS_IN_NERS,,


  		




  167
  
  
    
*REF_SPECIES--EXISTS_IN_PNWRS,*REF_SPECIES--EXISTS_IN_PNWRS,,


  		




  168
  
  
    
*REF_SPECIES--EXISTS_IN_RMRS,*REF_SPECIES--EXISTS_IN_RMRS,,


  		




  169
  
  
    
*REF_SPECIES--EXISTS_IN_SRS,*REF_SPECIES--EXISTS_IN_SRS,,


  		




  170
  
  
    
*REF_SPECIES--SITETREE,*REF_SPECIES--SITETREE,,


  		




  171
  
  
    
*REF_SPECIES--SFTWD_HRDWD,*REF_SPECIES--SFTWD_HRDWD,,


  		




  172
  
  
    
*REF_SPECIES--ST_EXISTS_IN_NCRS,*REF_SPECIES--ST_EXISTS_IN_NCRS,,


  		




  173
  
  
    
*REF_SPECIES--ST_EXISTS_IN_NERS,*REF_SPECIES--ST_EXISTS_IN_NERS,,


  		




  174
  
  
    
*REF_SPECIES--ST_EXISTS_IN_PNWRS,*REF_SPECIES--ST_EXISTS_IN_PNWRS,,


  		




  175
  
  
    
*REF_SPECIES--ST_EXISTS_IN_RMRS,*REF_SPECIES--ST_EXISTS_IN_RMRS,,


  		




  176
  
  
    
*REF_SPECIES--ST_EXISTS_IN_SRS,*REF_SPECIES--ST_EXISTS_IN_SRS,,


  		




  177
  
  
    
*REF_SPECIES--CORE,*REF_SPECIES--CORE,,


  		




  178
  
  
    
*REF_SPECIES--EAST,*REF_SPECIES--EAST,,


  		




  179
  
  
    
*REF_SPECIES--WEST,*REF_SPECIES--WEST,,


  		




  180
  
  
    
*REF_SPECIES--CARIBBEAN,*REF_SPECIES--CARIBBEAN,,


  		




  181
  
  
    
*REF_SPECIES--PACIFIC,*REF_SPECIES--PACIFIC,,


  		




  182
  
  
    
*REF_SPECIES--WOODLAND,*REF_SPECIES--WOODLAND,,


  		




  183
  
  
    
*REF_SPECIES--MANUAL_START,*REF_SPECIES--MANUAL_START,,


  		




  184
  
  
    
*REF_SPECIES--MANUAL_END,*REF_SPECIES--MANUAL_END,,


  		




  185
  
  
    
*REF_SPECIES--JENKINS_SPGRPCD,*REF_SPECIES--JENKINS_SPGRPCD,,


  		




  186
  
  
    
*REF_SPECIES--JENKINS_TOTAL_B1,*REF_SPECIES--JENKINS_TOTAL_B1,,


  		




  187
  
  
    
*REF_SPECIES--JENKINS_TOTAL_B2,*REF_SPECIES--JENKINS_TOTAL_B2,,


  		




  188
  
  
    
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B1,*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B1,,


  		




  189
  
  
    
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B2,*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B2,,


  		




  190
  
  
    
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B1,*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B1,,


  		




  191
  
  
    
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B2,*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B2,,


  		




  192
  
  
    
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B1,*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B1,,


  		




  193
  
  
    
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B2,*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B2,,


  		




  194
  
  
    
*REF_SPECIES--JENKINS_ROOT_RATIO_B1,*REF_SPECIES--JENKINS_ROOT_RATIO_B1,,


  		




  195
  
  
    
*REF_SPECIES--JENKINS_ROOT_RATIO_B2,*REF_SPECIES--JENKINS_ROOT_RATIO_B2,,


  		




  196
  
  
    
*REF_SPECIES--JENKINS_SAPLING_ADJUSTMENT,*REF_SPECIES--JENKINS_SAPLING_ADJUSTMENT,,


  		




  197
  
  
    
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT,*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT,,


  		




  198
  
  
    
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT_CIT,,


  		




  199
  
  
    
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT,*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT,,


  		




  200
  
  
    
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT_CIT,,


  		




  201
  
  
    
*REF_SPECIES--MC_PCT_GREEN_BARK,*REF_SPECIES--MC_PCT_GREEN_BARK,,


  		




  202
  
  
    
*REF_SPECIES--MC_PCT_GREEN_BARK_CIT,*REF_SPECIES--MC_PCT_GREEN_BARK_CIT,,


  		




  203
  
  
    
*REF_SPECIES--MC_PCT_GREEN_WOOD,*REF_SPECIES--MC_PCT_GREEN_WOOD,,


  		




  204
  
  
    
*REF_SPECIES--MC_PCT_GREEN_WOOD_CIT,*REF_SPECIES--MC_PCT_GREEN_WOOD_CIT,,


  		




  205
  
  
    
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT,*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT,,


  		




  206
  
  
    
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT_CIT,*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT_CIT,,


  		




  207
  
  
    
*REF_SPECIES--BARK_VOL_PCT,*REF_SPECIES--BARK_VOL_PCT,,


  		




  208
  
  
    
*REF_SPECIES--BARK_VOL_PCT_CIT,*REF_SPECIES--BARK_VOL_PCT_CIT,,


  		




  209
  
  
    
*REF_SPECIES--RAILE_STUMP_DOB_B1,*REF_SPECIES--RAILE_STUMP_DOB_B1,,


  		




  210
  
  
    
*REF_SPECIES--RAILE_STUMP_DIB_B1,*REF_SPECIES--RAILE_STUMP_DIB_B1,,


  		




  211
  
  
    
*REF_SPECIES--RAILE_STUMP_DIB_B2,*REF_SPECIES--RAILE_STUMP_DIB_B2,,


  		




  212
  
  
    
*REF_SPECIES--CWD_DECAY_RATIO1,*REF_SPECIES--CWD_DECAY_RATIO1,,


  		




  213
  
  
    
*REF_SPECIES--CWD_DECAY_RATIO2,*REF_SPECIES--CWD_DECAY_RATIO2,,


  		




  214
  
  
    
*REF_SPECIES--CWD_DECAY_RATIO3,*REF_SPECIES--CWD_DECAY_RATIO3,,


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff