Project

General

Profile

« Previous | Next » 

Revision 8177

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/*/map.csv: Replaced . between table and column name with newline, so that table viewers like pgAdmin will display both the table and column name at the left edge of the header cell, rather than displaying only the table name because the column name doesn't fit. This fixes the problem of seeing a bunch of columns whose names all start with a table name, and not knowing what each of them is. It also preserves the ability to see at a glance which table a column is in, which helps in navigating wide tables. Removed * before unmapped terms, because whether a term is mapped is generally obvious from the table name itself.

View differences:

inputs/FIA/SUBPLOT/new_terms.csv
1 
row_num,*SUBPLOT.row_num,,
1 
row_num,"SUBPLOT
2 
row_num",,
2 3 
CN,subplotID,,
3 
PLT_CN,*SUBPLOT.PLT_CN,,
4 
PREV_SBP_CN,*SUBPLOT.PREV_SBP_CN,,
4 
PLT_CN,"SUBPLOT
5 
PLT_CN",,
6 
PREV_SBP_CN,"SUBPLOT
7 
PREV_SBP_CN",,
5 8 
PLOT,locationName,,
6 9 
SUBP,subplot,,
7 
SUBP_STATUS_CD,*SUBPLOT.SUBP_STATUS_CD,,
8 
POINT_NONSAMPLE_REASN_CD,*SUBPLOT.POINT_NONSAMPLE_REASN_CD,,
9 
MICRCOND,*SUBPLOT.MICRCOND,,
10 
SUBPCOND,*SUBPLOT.SUBPCOND,,
11 
MACRCOND,*SUBPLOT.MACRCOND,,
12 
CONDLIST,*SUBPLOT.CONDLIST,,
13 
SLOPE,*SUBPLOT.SLOPE,,
14 
ASPECT,*SUBPLOT.ASPECT,,
15 
WATERDEP,*SUBPLOT.WATERDEP,,
16 
P2A_GRM_FLG,*SUBPLOT.P2A_GRM_FLG,,
17 
CREATED_BY,*SUBPLOT.CREATED_BY,,
18 
CREATED_DATE,*SUBPLOT.CREATED_DATE,,
19 
CREATED_IN_INSTANCE,*SUBPLOT.CREATED_IN_INSTANCE,,
20 
MODIFIED_BY,*SUBPLOT.MODIFIED_BY,,
21 
MODIFIED_DATE,*SUBPLOT.MODIFIED_DATE,,
22 
MODIFIED_IN_INSTANCE,*SUBPLOT.MODIFIED_IN_INSTANCE,,
23 
CYCLE,*SUBPLOT.CYCLE,,
24 
SUBCYCLE,*SUBPLOT.SUBCYCLE,,
25 
ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT.ROOT_DIS_SEV_CD_PNWRS,,
26 
NF_SUBP_STATUS_CD,*SUBPLOT.NF_SUBP_STATUS_CD,,
27 
NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT.NF_SUBP_NONSAMPLE_REASN_CD,,
28 
P2VEG_SUBP_STATUS_CD,*SUBPLOT.P2VEG_SUBP_STATUS_CD,,
29 
P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT.P2VEG_SUBP_NONSAMPLE_REASN_CD,,
30 
INVASIVE_SUBP_STATUS_CD,*SUBPLOT.INVASIVE_SUBP_STATUS_CD,,
31 
INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT.INVASIVE_NONSAMPLE_REASN_CD,,
10 
SUBP_STATUS_CD,"SUBPLOT
11 
SUBP_STATUS_CD",,
12 
POINT_NONSAMPLE_REASN_CD,"SUBPLOT
13 
POINT_NONSAMPLE_REASN_CD",,
14 
MICRCOND,"SUBPLOT
15 
MICRCOND",,
16 
SUBPCOND,"SUBPLOT
17 
SUBPCOND",,
18 
MACRCOND,"SUBPLOT
19 
MACRCOND",,
20 
CONDLIST,"SUBPLOT
21 
CONDLIST",,
22 
SLOPE,"SUBPLOT
23 
SLOPE",,
24 
ASPECT,"SUBPLOT
25 
ASPECT",,
26 
WATERDEP,"SUBPLOT
27 
WATERDEP",,
28 
P2A_GRM_FLG,"SUBPLOT
29 
P2A_GRM_FLG",,
30 
CREATED_BY,"SUBPLOT
31 
CREATED_BY",,
32 
CREATED_DATE,"SUBPLOT
33 
CREATED_DATE",,
34 
CREATED_IN_INSTANCE,"SUBPLOT
35 
CREATED_IN_INSTANCE",,
36 
MODIFIED_BY,"SUBPLOT
37 
MODIFIED_BY",,
38 
MODIFIED_DATE,"SUBPLOT
39 
MODIFIED_DATE",,
40 
MODIFIED_IN_INSTANCE,"SUBPLOT
41 
MODIFIED_IN_INSTANCE",,
42 
CYCLE,"SUBPLOT
43 
CYCLE",,
44 
SUBCYCLE,"SUBPLOT
45 
SUBCYCLE",,
46 
ROOT_DIS_SEV_CD_PNWRS,"SUBPLOT
47 
ROOT_DIS_SEV_CD_PNWRS",,
48 
NF_SUBP_STATUS_CD,"SUBPLOT
49 
NF_SUBP_STATUS_CD",,
50 
NF_SUBP_NONSAMPLE_REASN_CD,"SUBPLOT
51 
NF_SUBP_NONSAMPLE_REASN_CD",,
52 
P2VEG_SUBP_STATUS_CD,"SUBPLOT
53 
P2VEG_SUBP_STATUS_CD",,
54 
P2VEG_SUBP_NONSAMPLE_REASN_CD,"SUBPLOT
55 
P2VEG_SUBP_NONSAMPLE_REASN_CD",,
56 
INVASIVE_SUBP_STATUS_CD,"SUBPLOT
57 
INVASIVE_SUBP_STATUS_CD",,
58 
INVASIVE_NONSAMPLE_REASN_CD,"SUBPLOT
59 
INVASIVE_NONSAMPLE_REASN_CD",,
inputs/FIA/REF_RESEARCH_STATION/new_terms.csv
1 
row_num,*REF_RESEARCH_STATION.row_num,,
2 
RSCD,*REF_RESEARCH_STATION.RSCD,,
3 
RS,*REF_RESEARCH_STATION.RS,,
1 
row_num,"REF_RESEARCH_STATION
2 
row_num",,
3 
RSCD,"REF_RESEARCH_STATION
4 
RSCD",,
5 
RS,"REF_RESEARCH_STATION
6 
RS",,
4 7 
STATE_NAME,stateProvince,,
5 
STATE_ABBR,*REF_RESEARCH_STATION.STATE_ABBR,,
6 
CREATED_BY,*REF_RESEARCH_STATION.CREATED_BY,,
7 
CREATED_DATE,*REF_RESEARCH_STATION.CREATED_DATE,,
8 
CREATED_IN_INSTANCE,*REF_RESEARCH_STATION.CREATED_IN_INSTANCE,,
9 
MODIFIED_BY,*REF_RESEARCH_STATION.MODIFIED_BY,,
10 
MODIFIED_DATE,*REF_RESEARCH_STATION.MODIFIED_DATE,,
11 
MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION.MODIFIED_IN_INSTANCE,,
8 
STATE_ABBR,"REF_RESEARCH_STATION
9 
STATE_ABBR",,
10 
CREATED_BY,"REF_RESEARCH_STATION
11 
CREATED_BY",,
12 
CREATED_DATE,"REF_RESEARCH_STATION
13 
CREATED_DATE",,
14 
CREATED_IN_INSTANCE,"REF_RESEARCH_STATION
15 
CREATED_IN_INSTANCE",,
16 
MODIFIED_BY,"REF_RESEARCH_STATION
17 
MODIFIED_BY",,
18 
MODIFIED_DATE,"REF_RESEARCH_STATION
19 
MODIFIED_DATE",,
20 
MODIFIED_IN_INSTANCE,"REF_RESEARCH_STATION
21 
MODIFIED_IN_INSTANCE",,
inputs/FIA/PLOT/map.csv
1 1 
FIA,VegCore,Filter,Comments
2 
row_num,*PLOT.row_num,,
2 
row_num,"PLOT
3 
row_num",,
3 4 
CN,locationID,,
4 
SRV_CN,*PLOT.SRV_CN,,
5 
CTY_CN,*PLOT.CTY_CN,,
6 
PREV_PLT_CN,*PLOT.PREV_PLT_CN,,
5 
SRV_CN,"PLOT
6 
SRV_CN",,
7 
CTY_CN,"PLOT
8 
CTY_CN",,
9 
PREV_PLT_CN,"PLOT
10 
PREV_PLT_CN",,
7 11 
INVYR,INVYR,,
8 12 
STATECD,STATECD,,
9 13 
UNITCD,UNITCD,,
10 14 
COUNTYCD,COUNTYCD,,
11 15 
PLOT,locationName,,
12 
PLOT_STATUS_CD,*PLOT.PLOT_STATUS_CD,,
13 
PLOT_NONSAMPLE_REASN_CD,*PLOT.PLOT_NONSAMPLE_REASN_CD,,
16 
PLOT_STATUS_CD,"PLOT
17 
PLOT_STATUS_CD",,
18 
PLOT_NONSAMPLE_REASN_CD,"PLOT
19 
PLOT_NONSAMPLE_REASN_CD",,
14 20 
MEASYEAR,year,,
15 21 
MEASMON,month,,
16 22 
MEASDAY,day,,
17 
REMPER,*PLOT.REMPER,,
18 
KINDCD,*PLOT.KINDCD,,
19 
DESIGNCD,*PLOT.DESIGNCD,,
20 
RDDISTCD,*PLOT.RDDISTCD,,
21 
WATERCD,*PLOT.WATERCD,,
23 
REMPER,"PLOT
24 
REMPER",,
25 
KINDCD,"PLOT
26 
KINDCD",,
27 
DESIGNCD,"PLOT
28 
DESIGNCD",,
29 
RDDISTCD,"PLOT
30 
RDDISTCD",,
31 
WATERCD,"PLOT
32 
WATERCD",,
22 33 
LAT,decimalLatitude,,
23 34 
LON,decimalLongitude,,
24 35 
ELEV,elevationInMeters,,Assuming units based on the range and precision of values
25 
GROW_TYP_CD,*PLOT.GROW_TYP_CD,,
26 
MORT_TYP_CD,*PLOT.MORT_TYP_CD,,
27 
P2PANEL,*PLOT.P2PANEL,,
28 
P3PANEL,*PLOT.P3PANEL,,
29 
ECOSUBCD,*PLOT.ECOSUBCD,,
30 
CONGCD,*PLOT.CONGCD,,
31 
MANUAL,*PLOT.MANUAL,,
32 
SUBPANEL,*PLOT.SUBPANEL,,
33 
KINDCD_NC,*PLOT.KINDCD_NC,,
34 
QA_STATUS,*PLOT.QA_STATUS,,
35 
CREATED_BY,*PLOT.CREATED_BY,,
36 
CREATED_DATE,*PLOT.CREATED_DATE,,
37 
CREATED_IN_INSTANCE,*PLOT.CREATED_IN_INSTANCE,,
38 
MODIFIED_BY,*PLOT.MODIFIED_BY,,
39 
MODIFIED_DATE,*PLOT.MODIFIED_DATE,,
40 
MODIFIED_IN_INSTANCE,*PLOT.MODIFIED_IN_INSTANCE,,
41 
MICROPLOT_LOC,*PLOT.MICROPLOT_LOC,,
42 
DECLINATION,*PLOT.DECLINATION,,
43 
EMAP_HEX,*PLOT.EMAP_HEX,,
44 
SAMP_METHOD_CD,*PLOT.SAMP_METHOD_CD,,
45 
SUBP_EXAMINE_CD,*PLOT.SUBP_EXAMINE_CD,,
46 
MACRO_BREAKPOINT_DIA,*PLOT.MACRO_BREAKPOINT_DIA,,
47 
INTENSITY,*PLOT.INTENSITY,,
48 
CYCLE,*PLOT.CYCLE,,
49 
SUBCYCLE,*PLOT.SUBCYCLE,,
50 
ECO_UNIT_PNW,*PLOT.ECO_UNIT_PNW,,
51 
TOPO_POSITION_PNW,*PLOT.TOPO_POSITION_PNW,,
52 
NF_SAMPLING_STATUS_CD,*PLOT.NF_SAMPLING_STATUS_CD,,
53 
NF_PLOT_STATUS_CD,*PLOT.NF_PLOT_STATUS_CD,,
54 
NF_PLOT_NONSAMPLE_REASN_CD,*PLOT.NF_PLOT_NONSAMPLE_REASN_CD,,
55 
P2VEG_SAMPLING_STATUS_CD,*PLOT.P2VEG_SAMPLING_STATUS_CD,,
56 
P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD,,
57 
INVASIVE_SAMPLING_STATUS_CD,*PLOT.INVASIVE_SAMPLING_STATUS_CD,,
58 
INVASIVE_SPECIMEN_RULE_CD,*PLOT.INVASIVE_SPECIMEN_RULE_CD,,
59 
DESIGNCD_P2A,*PLOT.DESIGNCD_P2A,,
36 
GROW_TYP_CD,"PLOT
37 
GROW_TYP_CD",,
38 
MORT_TYP_CD,"PLOT
39 
MORT_TYP_CD",,
40 
P2PANEL,"PLOT
41 
P2PANEL",,
42 
P3PANEL,"PLOT
43 
P3PANEL",,
44 
ECOSUBCD,"PLOT
45 
ECOSUBCD",,
46 
CONGCD,"PLOT
47 
CONGCD",,
48 
MANUAL,"PLOT
49 
MANUAL",,
50 
SUBPANEL,"PLOT
51 
SUBPANEL",,
52 
KINDCD_NC,"PLOT
53 
KINDCD_NC",,
54 
QA_STATUS,"PLOT
55 
QA_STATUS",,
56 
CREATED_BY,"PLOT
57 
CREATED_BY",,
58 
CREATED_DATE,"PLOT
59 
CREATED_DATE",,
60 
CREATED_IN_INSTANCE,"PLOT
61 
CREATED_IN_INSTANCE",,
62 
MODIFIED_BY,"PLOT
63 
MODIFIED_BY",,
64 
MODIFIED_DATE,"PLOT
65 
MODIFIED_DATE",,
66 
MODIFIED_IN_INSTANCE,"PLOT
67 
MODIFIED_IN_INSTANCE",,
68 
MICROPLOT_LOC,"PLOT
69 
MICROPLOT_LOC",,
70 
DECLINATION,"PLOT
71 
DECLINATION",,
72 
EMAP_HEX,"PLOT
73 
EMAP_HEX",,
74 
SAMP_METHOD_CD,"PLOT
75 
SAMP_METHOD_CD",,
76 
SUBP_EXAMINE_CD,"PLOT
77 
SUBP_EXAMINE_CD",,
78 
MACRO_BREAKPOINT_DIA,"PLOT
79 
MACRO_BREAKPOINT_DIA",,
80 
INTENSITY,"PLOT
81 
INTENSITY",,
82 
CYCLE,"PLOT
83 
CYCLE",,
84 
SUBCYCLE,"PLOT
85 
SUBCYCLE",,
86 
ECO_UNIT_PNW,"PLOT
87 
ECO_UNIT_PNW",,
88 
TOPO_POSITION_PNW,"PLOT
89 
TOPO_POSITION_PNW",,
90 
NF_SAMPLING_STATUS_CD,"PLOT
91 
NF_SAMPLING_STATUS_CD",,
92 
NF_PLOT_STATUS_CD,"PLOT
93 
NF_PLOT_STATUS_CD",,
94 
NF_PLOT_NONSAMPLE_REASN_CD,"PLOT
95 
NF_PLOT_NONSAMPLE_REASN_CD",,
96 
P2VEG_SAMPLING_STATUS_CD,"PLOT
97 
P2VEG_SAMPLING_STATUS_CD",,
98 
P2VEG_SAMPLING_LEVEL_DETAIL_CD,"PLOT
99 
P2VEG_SAMPLING_LEVEL_DETAIL_CD",,
100 
INVASIVE_SAMPLING_STATUS_CD,"PLOT
101 
INVASIVE_SAMPLING_STATUS_CD",,
102 
INVASIVE_SPECIMEN_RULE_CD,"PLOT
103 
INVASIVE_SPECIMEN_RULE_CD",,
104 
DESIGNCD_P2A,"PLOT
105 
DESIGNCD_P2A",,
inputs/FIA/PLOT/new_terms.csv
1 
row_num,*PLOT.row_num,,
1 
row_num,"PLOT
2 
row_num",,
2 3 
CN,locationID,,
3 
SRV_CN,*PLOT.SRV_CN,,
4 
CTY_CN,*PLOT.CTY_CN,,
5 
PREV_PLT_CN,*PLOT.PREV_PLT_CN,,
4 
SRV_CN,"PLOT
5 
SRV_CN",,
6 
CTY_CN,"PLOT
7 
CTY_CN",,
8 
PREV_PLT_CN,"PLOT
9 
PREV_PLT_CN",,
6 10 
PLOT,locationName,,
7 
PLOT_STATUS_CD,*PLOT.PLOT_STATUS_CD,,
8 
PLOT_NONSAMPLE_REASN_CD,*PLOT.PLOT_NONSAMPLE_REASN_CD,,
11 
PLOT_STATUS_CD,"PLOT
12 
PLOT_STATUS_CD",,
13 
PLOT_NONSAMPLE_REASN_CD,"PLOT
14 
PLOT_NONSAMPLE_REASN_CD",,
9 15 
MEASYEAR,year,,
10 16 
MEASMON,month,,
11 17 
MEASDAY,day,,
12 
REMPER,*PLOT.REMPER,,
13 
KINDCD,*PLOT.KINDCD,,
14 
DESIGNCD,*PLOT.DESIGNCD,,
15 
RDDISTCD,*PLOT.RDDISTCD,,
16 
WATERCD,*PLOT.WATERCD,,
18 
REMPER,"PLOT
19 
REMPER",,
20 
KINDCD,"PLOT
21 
KINDCD",,
22 
DESIGNCD,"PLOT
23 
DESIGNCD",,
24 
RDDISTCD,"PLOT
25 
RDDISTCD",,
26 
WATERCD,"PLOT
27 
WATERCD",,
17 28 
LAT,decimalLatitude,,
18 29 
LON,decimalLongitude,,
19 30 
ELEV,elevationInMeters,,Assuming units based on the range and precision of values
20 
GROW_TYP_CD,*PLOT.GROW_TYP_CD,,
21 
MORT_TYP_CD,*PLOT.MORT_TYP_CD,,
22 
P2PANEL,*PLOT.P2PANEL,,
23 
P3PANEL,*PLOT.P3PANEL,,
24 
ECOSUBCD,*PLOT.ECOSUBCD,,
25 
CONGCD,*PLOT.CONGCD,,
26 
MANUAL,*PLOT.MANUAL,,
27 
SUBPANEL,*PLOT.SUBPANEL,,
28 
KINDCD_NC,*PLOT.KINDCD_NC,,
29 
QA_STATUS,*PLOT.QA_STATUS,,
30 
CREATED_BY,*PLOT.CREATED_BY,,
31 
CREATED_DATE,*PLOT.CREATED_DATE,,
32 
CREATED_IN_INSTANCE,*PLOT.CREATED_IN_INSTANCE,,
33 
MODIFIED_BY,*PLOT.MODIFIED_BY,,
34 
MODIFIED_DATE,*PLOT.MODIFIED_DATE,,
35 
MODIFIED_IN_INSTANCE,*PLOT.MODIFIED_IN_INSTANCE,,
36 
MICROPLOT_LOC,*PLOT.MICROPLOT_LOC,,
37 
DECLINATION,*PLOT.DECLINATION,,
38 
EMAP_HEX,*PLOT.EMAP_HEX,,
39 
SAMP_METHOD_CD,*PLOT.SAMP_METHOD_CD,,
40 
SUBP_EXAMINE_CD,*PLOT.SUBP_EXAMINE_CD,,
41 
MACRO_BREAKPOINT_DIA,*PLOT.MACRO_BREAKPOINT_DIA,,
42 
INTENSITY,*PLOT.INTENSITY,,
43 
CYCLE,*PLOT.CYCLE,,
44 
SUBCYCLE,*PLOT.SUBCYCLE,,
45 
ECO_UNIT_PNW,*PLOT.ECO_UNIT_PNW,,
46 
TOPO_POSITION_PNW,*PLOT.TOPO_POSITION_PNW,,
47 
NF_SAMPLING_STATUS_CD,*PLOT.NF_SAMPLING_STATUS_CD,,
48 
NF_PLOT_STATUS_CD,*PLOT.NF_PLOT_STATUS_CD,,
49 
NF_PLOT_NONSAMPLE_REASN_CD,*PLOT.NF_PLOT_NONSAMPLE_REASN_CD,,
50 
P2VEG_SAMPLING_STATUS_CD,*PLOT.P2VEG_SAMPLING_STATUS_CD,,
51 
P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD,,
52 
INVASIVE_SAMPLING_STATUS_CD,*PLOT.INVASIVE_SAMPLING_STATUS_CD,,
53 
INVASIVE_SPECIMEN_RULE_CD,*PLOT.INVASIVE_SPECIMEN_RULE_CD,,
54 
DESIGNCD_P2A,*PLOT.DESIGNCD_P2A,,
31 
GROW_TYP_CD,"PLOT
32 
GROW_TYP_CD",,
33 
MORT_TYP_CD,"PLOT
34 
MORT_TYP_CD",,
35 
P2PANEL,"PLOT
36 
P2PANEL",,
37 
P3PANEL,"PLOT
38 
P3PANEL",,
39 
ECOSUBCD,"PLOT
40 
ECOSUBCD",,
41 
CONGCD,"PLOT
42 
CONGCD",,
43 
MANUAL,"PLOT
44 
MANUAL",,
45 
SUBPANEL,"PLOT
46 
SUBPANEL",,
47 
KINDCD_NC,"PLOT
48 
KINDCD_NC",,
49 
QA_STATUS,"PLOT
50 
QA_STATUS",,
51 
CREATED_BY,"PLOT
52 
CREATED_BY",,
53 
CREATED_DATE,"PLOT
54 
CREATED_DATE",,
55 
CREATED_IN_INSTANCE,"PLOT
56 
CREATED_IN_INSTANCE",,
57 
MODIFIED_BY,"PLOT
58 
MODIFIED_BY",,
59 
MODIFIED_DATE,"PLOT
60 
MODIFIED_DATE",,
61 
MODIFIED_IN_INSTANCE,"PLOT
62 
MODIFIED_IN_INSTANCE",,
63 
MICROPLOT_LOC,"PLOT
64 
MICROPLOT_LOC",,
65 
DECLINATION,"PLOT
66 
DECLINATION",,
67 
EMAP_HEX,"PLOT
68 
EMAP_HEX",,
69 
SAMP_METHOD_CD,"PLOT
70 
SAMP_METHOD_CD",,
71 
SUBP_EXAMINE_CD,"PLOT
72 
SUBP_EXAMINE_CD",,
73 
MACRO_BREAKPOINT_DIA,"PLOT
74 
MACRO_BREAKPOINT_DIA",,
75 
INTENSITY,"PLOT
76 
INTENSITY",,
77 
CYCLE,"PLOT
78 
CYCLE",,
79 
SUBCYCLE,"PLOT
80 
SUBCYCLE",,
81 
ECO_UNIT_PNW,"PLOT
82 
ECO_UNIT_PNW",,
83 
TOPO_POSITION_PNW,"PLOT
84 
TOPO_POSITION_PNW",,
85 
NF_SAMPLING_STATUS_CD,"PLOT
86 
NF_SAMPLING_STATUS_CD",,
87 
NF_PLOT_STATUS_CD,"PLOT
88 
NF_PLOT_STATUS_CD",,
89 
NF_PLOT_NONSAMPLE_REASN_CD,"PLOT
90 
NF_PLOT_NONSAMPLE_REASN_CD",,
91 
P2VEG_SAMPLING_STATUS_CD,"PLOT
92 
P2VEG_SAMPLING_STATUS_CD",,
93 
P2VEG_SAMPLING_LEVEL_DETAIL_CD,"PLOT
94 
P2VEG_SAMPLING_LEVEL_DETAIL_CD",,
95 
INVASIVE_SAMPLING_STATUS_CD,"PLOT
96 
INVASIVE_SAMPLING_STATUS_CD",,
97 
INVASIVE_SPECIMEN_RULE_CD,"PLOT
98 
INVASIVE_SPECIMEN_RULE_CD",,
99 
DESIGNCD_P2A,"PLOT
100 
DESIGNCD_P2A",,
inputs/FIA/PLOT/unmapped_terms.csv
1 
*PLOT.row_num
2 
*PLOT.SRV_CN
3 
*PLOT.CTY_CN
4 
*PLOT.PREV_PLT_CN
1 
"PLOT
2 
row_num"
3 
"PLOT
4 
SRV_CN"
5 
"PLOT
6 
CTY_CN"
7 
"PLOT
8 
PREV_PLT_CN"
5 9 
INVYR
6 10 
STATECD
7 11 
UNITCD
8 12 
COUNTYCD
9 
*PLOT.PLOT_STATUS_CD
10 
*PLOT.PLOT_NONSAMPLE_REASN_CD
13 
"PLOT
14 
PLOT_STATUS_CD"
15 
"PLOT
16 
PLOT_NONSAMPLE_REASN_CD"
11 17 
year
12 18 
month
13 19 
day
14 
*PLOT.REMPER
15 
*PLOT.KINDCD
16 
*PLOT.DESIGNCD
17 
*PLOT.RDDISTCD
18 
*PLOT.WATERCD
19 
*PLOT.GROW_TYP_CD
20 
*PLOT.MORT_TYP_CD
21 
*PLOT.P2PANEL
22 
*PLOT.P3PANEL
23 
*PLOT.ECOSUBCD
24 
*PLOT.CONGCD
25 
*PLOT.MANUAL
26 
*PLOT.SUBPANEL
27 
*PLOT.KINDCD_NC
28 
*PLOT.QA_STATUS
29 
*PLOT.CREATED_BY
30 
*PLOT.CREATED_DATE
31 
*PLOT.CREATED_IN_INSTANCE
32 
*PLOT.MODIFIED_BY
33 
*PLOT.MODIFIED_DATE
34 
*PLOT.MODIFIED_IN_INSTANCE
35 
*PLOT.MICROPLOT_LOC
36 
*PLOT.DECLINATION
37 
*PLOT.EMAP_HEX
38 
*PLOT.SAMP_METHOD_CD
39 
*PLOT.SUBP_EXAMINE_CD
40 
*PLOT.MACRO_BREAKPOINT_DIA
41 
*PLOT.INTENSITY
42 
*PLOT.CYCLE
43 
*PLOT.SUBCYCLE
44 
*PLOT.ECO_UNIT_PNW
45 
*PLOT.TOPO_POSITION_PNW
46 
*PLOT.NF_SAMPLING_STATUS_CD
47 
*PLOT.NF_PLOT_STATUS_CD
48 
*PLOT.NF_PLOT_NONSAMPLE_REASN_CD
49 
*PLOT.P2VEG_SAMPLING_STATUS_CD
50 
*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD
51 
*PLOT.INVASIVE_SAMPLING_STATUS_CD
52 
*PLOT.INVASIVE_SPECIMEN_RULE_CD
53 
*PLOT.DESIGNCD_P2A
20 
"PLOT
21 
REMPER"
22 
"PLOT
23 
KINDCD"
24 
"PLOT
25 
DESIGNCD"
26 
"PLOT
27 
RDDISTCD"
28 
"PLOT
29 
WATERCD"
30 
"PLOT
31 
GROW_TYP_CD"
32 
"PLOT
33 
MORT_TYP_CD"
34 
"PLOT
35 
P2PANEL"
36 
"PLOT
37 
P3PANEL"
38 
"PLOT
39 
ECOSUBCD"
40 
"PLOT
41 
CONGCD"
42 
"PLOT
43 
MANUAL"
44 
"PLOT
45 
SUBPANEL"
46 
"PLOT
47 
KINDCD_NC"
48 
"PLOT
49 
QA_STATUS"
50 
"PLOT
51 
CREATED_BY"
52 
"PLOT
53 
CREATED_DATE"
54 
"PLOT
55 
CREATED_IN_INSTANCE"
56 
"PLOT
57 
MODIFIED_BY"
58 
"PLOT
59 
MODIFIED_DATE"
60 
"PLOT
61 
MODIFIED_IN_INSTANCE"
62 
"PLOT
63 
MICROPLOT_LOC"
64 
"PLOT
65 
DECLINATION"
66 
"PLOT
67 
EMAP_HEX"
68 
"PLOT
69 
SAMP_METHOD_CD"
70 
"PLOT
71 
SUBP_EXAMINE_CD"
72 
"PLOT
73 
MACRO_BREAKPOINT_DIA"
74 
"PLOT
75 
INTENSITY"
76 
"PLOT
77 
CYCLE"
78 
"PLOT
79 
SUBCYCLE"
80 
"PLOT
81 
ECO_UNIT_PNW"
82 
"PLOT
83 
TOPO_POSITION_PNW"
84 
"PLOT
85 
NF_SAMPLING_STATUS_CD"
86 
"PLOT
87 
NF_PLOT_STATUS_CD"
88 
"PLOT
89 
NF_PLOT_NONSAMPLE_REASN_CD"
90 
"PLOT
91 
P2VEG_SAMPLING_STATUS_CD"
92 
"PLOT
93 
P2VEG_SAMPLING_LEVEL_DETAIL_CD"
94 
"PLOT
95 
INVASIVE_SAMPLING_STATUS_CD"
96 
"PLOT
97 
INVASIVE_SPECIMEN_RULE_CD"
98 
"PLOT
99 
DESIGNCD_P2A"
inputs/FIA/Organism/map.csv
11 11 
StateProvince,stateProvince,,
12 12 
County,county,,
13 13 
DBH,diameterBreastHeight_in,,Assuming units based on the range and precision of values and location inside the U.S.
14 
HOM,*HOM,,
14 
HOM,HOM,,
15 15 
BasalDiameter,basalDiameter_in,,Assuming units are the same as for DBH because the values are similar and they measure the same dimension
16 16 
Height,height_ft,,"Assuming units based on the range of values, the height of the tallest tree [1], and location inside the U.S.
17 17 

  		












  

    
      inputs/FIA/COUNTY/map.csv
    
  





  1
  1
  
    
FIA,VegCore,Filter,Comments


  		




  2
  
  
    
row_num,*COUNTY.row_num,,


  		




  
  2
  
    
row_num,"COUNTY


  		




  
  3
  
    
row_num",,


  		




  3
  4
  
    
STATECD,STATECD,,


  		




  4
  5
  
    
UNITCD,UNITCD,,


  		




  5
  6
  
    
COUNTYCD,COUNTYCD,,


  		




  6
  7
  
    
COUNTYNM,county,,


  		




  7
  
  
    
CN,*COUNTY.CN,,


  		




  8
  
  
    
CREATED_BY,*COUNTY.CREATED_BY,,


  		




  9
  
  
    
CREATED_DATE,*COUNTY.CREATED_DATE,,


  		




  10
  
  
    
CREATED_IN_INSTANCE,*COUNTY.CREATED_IN_INSTANCE,,


  		




  11
  
  
    
MODIFIED_BY,*COUNTY.MODIFIED_BY,,


  		




  12
  
  
    
MODIFIED_DATE,*COUNTY.MODIFIED_DATE,,


  		




  13
  
  
    
MODIFIED_IN_INSTANCE,*COUNTY.MODIFIED_IN_INSTANCE,,


  		




  
  8
  
    
CN,"COUNTY


  		




  
  9
  
    
CN",,


  		




  
  10
  
    
CREATED_BY,"COUNTY


  		




  
  11
  
    
CREATED_BY",,


  		




  
  12
  
    
CREATED_DATE,"COUNTY


  		




  
  13
  
    
CREATED_DATE",,


  		




  
  14
  
    
CREATED_IN_INSTANCE,"COUNTY


  		




  
  15
  
    
CREATED_IN_INSTANCE",,


  		




  
  16
  
    
MODIFIED_BY,"COUNTY


  		




  
  17
  
    
MODIFIED_BY",,


  		




  
  18
  
    
MODIFIED_DATE,"COUNTY


  		




  
  19
  
    
MODIFIED_DATE",,


  		




  
  20
  
    
MODIFIED_IN_INSTANCE,"COUNTY


  		




  
  21
  
    
MODIFIED_IN_INSTANCE",,


  		












  

    
      inputs/FIA/COUNTY/import
    
  





  11
  11
  
    
, ('COUNTYCD', 'integer')


  		




  12
  12
  
    
]::functions.col_cast[]);


  		




  13
  13
  
    

  		




  14
  
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID"     UNIQUE ("*COUNTY.CN")$$);


  		




  
  14
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID"     UNIQUE ("COUNTY


  		




  
  15
  
    
CN")$$);


  		




  15
  16
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD")$$);


  		












  

    
      inputs/FIA/COUNTY/new_terms.csv
    
  





  1
  
  
    
row_num,*COUNTY.row_num,,


  		




  
  1
  
    
row_num,"COUNTY


  		




  
  2
  
    
row_num",,


  		




  2
  3
  
    
COUNTYNM,county,,


  		




  3
  
  
    
CN,*COUNTY.CN,,


  		




  4
  
  
    
CREATED_BY,*COUNTY.CREATED_BY,,


  		




  5
  
  
    
CREATED_DATE,*COUNTY.CREATED_DATE,,


  		




  6
  
  
    
CREATED_IN_INSTANCE,*COUNTY.CREATED_IN_INSTANCE,,


  		




  7
  
  
    
MODIFIED_BY,*COUNTY.MODIFIED_BY,,


  		




  8
  
  
    
MODIFIED_DATE,*COUNTY.MODIFIED_DATE,,


  		




  9
  
  
    
MODIFIED_IN_INSTANCE,*COUNTY.MODIFIED_IN_INSTANCE,,


  		




  
  4
  
    
CN,"COUNTY


  		




  
  5
  
    
CN",,


  		




  
  6
  
    
CREATED_BY,"COUNTY


  		




  
  7
  
    
CREATED_BY",,


  		




  
  8
  
    
CREATED_DATE,"COUNTY


  		




  
  9
  
    
CREATED_DATE",,


  		




  
  10
  
    
CREATED_IN_INSTANCE,"COUNTY


  		




  
  11
  
    
CREATED_IN_INSTANCE",,


  		




  
  12
  
    
MODIFIED_BY,"COUNTY


  		




  
  13
  
    
MODIFIED_BY",,


  		




  
  14
  
    
MODIFIED_DATE,"COUNTY


  		




  
  15
  
    
MODIFIED_DATE",,


  		




  
  16
  
    
MODIFIED_IN_INSTANCE,"COUNTY


  		




  
  17
  
    
MODIFIED_IN_INSTANCE",,


  		












  

    
      inputs/FIA/COUNTY/unmapped_terms.csv
    
  





  1
  
  
    
*COUNTY.row_num


  		




  
  1
  
    
"COUNTY


  		




  
  2
  
    
row_num"


  		




  2
  3
  
    
STATECD


  		




  3
  4
  
    
UNITCD


  		




  4
  5
  
    
COUNTYCD


  		




  5
  
  
    
*COUNTY.CN


  		




  6
  
  
    
*COUNTY.CREATED_BY


  		




  7
  
  
    
*COUNTY.CREATED_DATE


  		




  8
  
  
    
*COUNTY.CREATED_IN_INSTANCE


  		




  9
  
  
    
*COUNTY.MODIFIED_BY


  		




  10
  
  
    
*COUNTY.MODIFIED_DATE


  		




  11
  
  
    
*COUNTY.MODIFIED_IN_INSTANCE


  		




  
  6
  
    
"COUNTY


  		




  
  7
  
    
CN"


  		




  
  8
  
    
"COUNTY


  		




  
  9
  
    
CREATED_BY"


  		




  
  10
  
    
"COUNTY


  		




  
  11
  
    
CREATED_DATE"


  		




  
  12
  
    
"COUNTY


  		




  
  13
  
    
CREATED_IN_INSTANCE"


  		




  
  14
  
    
"COUNTY


  		




  
  15
  
    
MODIFIED_BY"


  		




  
  16
  
    
"COUNTY


  		




  
  17
  
    
MODIFIED_DATE"


  		




  
  18
  
    
"COUNTY


  		




  
  19
  
    
MODIFIED_IN_INSTANCE"


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/map.csv
    
  





  1
  1
  
    
FIA,VegCore,Filter,Comments


  		




  2
  
  
    
row_num,*REF_PLANT_DICTIONARY.row_num,,


  		




  3
  
  
    
CN,*REF_PLANT_DICTIONARY.CN,,


  		




  
  2
  
    
row_num,"REF_PLANT_DICTIONARY


  		




  
  3
  
    
row_num",,


  		




  
  4
  
    
CN,"REF_PLANT_DICTIONARY


  		




  
  5
  
    
CN",,


  		




  4
  6
  
    
SYMBOL_TYPE,PLANT_SYMBOL_TYPE,,


  		




  5
  7
  
    
SYMBOL,PLANT_SYMBOL,,


  		




  6
  8
  
    
SCIENTIFIC_NAME,taxonName,,


  		




  7
  
  
    
NEW_SYMBOL,*REF_PLANT_DICTIONARY.NEW_SYMBOL,,


  		




  8
  
  
    
NEW_SCIENTIFIC_NAME,*REF_PLANT_DICTIONARY.NEW_SCIENTIFIC_NAME,,


  		




  
  9
  
    
NEW_SYMBOL,"REF_PLANT_DICTIONARY


  		




  
  10
  
    
NEW_SYMBOL",,


  		




  
  11
  
    
NEW_SCIENTIFIC_NAME,"REF_PLANT_DICTIONARY


  		




  
  12
  
    
NEW_SCIENTIFIC_NAME",,


  		




  9
  13
  
    
COMMON_NAME,COMMON_NAME,,


  		




  10
  
  
    
CATEGORY,*REF_PLANT_DICTIONARY.CATEGORY,,


  		




  
  14
  
    
CATEGORY,"REF_PLANT_DICTIONARY


  		




  
  15
  
    
CATEGORY",,


  		




  11
  16
  
    
FAMILY,family,,


  		




  12
  17
  
    
GROWTH_HABIT,taxonGrowthForm,,


  		




  13
  
  
    
DURATION,*REF_PLANT_DICTIONARY.DURATION,,


  		




  14
  
  
    
US_NATIVITY,*REF_PLANT_DICTIONARY.US_NATIVITY,,


  		




  15
  
  
    
STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY.STATE_DISTRIBUTION,,


  		




  16
  
  
    
STATE_AND_PROVINCE,*REF_PLANT_DICTIONARY.STATE_AND_PROVINCE,,


  		




  
  18
  
    
DURATION,"REF_PLANT_DICTIONARY


  		




  
  19
  
    
DURATION",,


  		




  
  20
  
    
US_NATIVITY,"REF_PLANT_DICTIONARY


  		




  
  21
  
    
US_NATIVITY",,


  		




  
  22
  
    
STATE_DISTRIBUTION,"REF_PLANT_DICTIONARY


  		




  
  23
  
    
STATE_DISTRIBUTION",,


  		




  
  24
  
    
STATE_AND_PROVINCE,"REF_PLANT_DICTIONARY


  		




  
  25
  
    
STATE_AND_PROVINCE",,


  		




  17
  26
  
    
SCIENTIFIC_NAME_W_AUTHOR,scientificName,,


  		




  18
  27
  
    
GENERA_BINOMIAL_AUTHOR,GENERA_BINOMIAL_AUTHOR,,


  		




  19
  28
  
    
TRINOMIAL_AUTHOR,TRINOMIAL_AUTHOR,,


  		




  ......




  32
  41
  
    
SUBVARIETY,SUBVARIETY,,


  		




  33
  42
  
    
F,F_PREFIX,,


  		




  34
  43
  
    
FORMA,forma,,


  		




  35
  
  
    
NOTES,*REF_PLANT_DICTIONARY.NOTES,,


  		




  36
  
  
    
CREATED_BY,*REF_PLANT_DICTIONARY.CREATED_BY,,


  		




  37
  
  
    
CREATED_DATE,*REF_PLANT_DICTIONARY.CREATED_DATE,,


  		




  38
  
  
    
CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY.CREATED_IN_INSTANCE,,


  		




  39
  
  
    
MODIFIED_BY,*REF_PLANT_DICTIONARY.MODIFIED_BY,,


  		




  40
  
  
    
MODIFIED_DATE,*REF_PLANT_DICTIONARY.MODIFIED_DATE,,


  		




  41
  
  
    
MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY.MODIFIED_IN_INSTANCE,,


  		




  
  44
  
    
NOTES,"REF_PLANT_DICTIONARY


  		




  
  45
  
    
NOTES",,


  		




  
  46
  
    
CREATED_BY,"REF_PLANT_DICTIONARY


  		




  
  47
  
    
CREATED_BY",,


  		




  
  48
  
    
CREATED_DATE,"REF_PLANT_DICTIONARY


  		




  
  49
  
    
CREATED_DATE",,


  		




  
  50
  
    
CREATED_IN_INSTANCE,"REF_PLANT_DICTIONARY


  		




  
  51
  
    
CREATED_IN_INSTANCE",,


  		




  
  52
  
    
MODIFIED_BY,"REF_PLANT_DICTIONARY


  		




  
  53
  
    
MODIFIED_BY",,


  		




  
  54
  
    
MODIFIED_DATE,"REF_PLANT_DICTIONARY


  		




  
  55
  
    
MODIFIED_DATE",,


  		




  
  56
  
    
MODIFIED_IN_INSTANCE,"REF_PLANT_DICTIONARY


  		




  
  57
  
    
MODIFIED_IN_INSTANCE",,


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/new_terms.csv
    
  





  1
  
  
    
row_num,*REF_PLANT_DICTIONARY.row_num,,


  		




  2
  
  
    
CN,*REF_PLANT_DICTIONARY.CN,,


  		




  
  1
  
    
row_num,"REF_PLANT_DICTIONARY


  		




  
  2
  
    
row_num",,


  		




  
  3
  
    
CN,"REF_PLANT_DICTIONARY


  		




  
  4
  
    
CN",,


  		




  3
  5
  
    
SYMBOL_TYPE,PLANT_SYMBOL_TYPE,,


  		




  4
  6
  
    
SYMBOL,PLANT_SYMBOL,,


  		




  5
  
  
    
NEW_SYMBOL,*REF_PLANT_DICTIONARY.NEW_SYMBOL,,


  		




  6
  
  
    
NEW_SCIENTIFIC_NAME,*REF_PLANT_DICTIONARY.NEW_SCIENTIFIC_NAME,,


  		




  7
  
  
    
CATEGORY,*REF_PLANT_DICTIONARY.CATEGORY,,


  		




  
  7
  
    
NEW_SYMBOL,"REF_PLANT_DICTIONARY


  		




  
  8
  
    
NEW_SYMBOL",,


  		




  
  9
  
    
NEW_SCIENTIFIC_NAME,"REF_PLANT_DICTIONARY


  		




  
  10
  
    
NEW_SCIENTIFIC_NAME",,


  		




  
  11
  
    
CATEGORY,"REF_PLANT_DICTIONARY


  		




  
  12
  
    
CATEGORY",,


  		




  8
  13
  
    
GROWTH_HABIT,taxonGrowthForm,,


  		




  9
  
  
    
DURATION,*REF_PLANT_DICTIONARY.DURATION,,


  		




  10
  
  
    
US_NATIVITY,*REF_PLANT_DICTIONARY.US_NATIVITY,,


  		




  11
  
  
    
STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY.STATE_DISTRIBUTION,,


  		




  12
  
  
    
STATE_AND_PROVINCE,*REF_PLANT_DICTIONARY.STATE_AND_PROVINCE,,


  		




  
  14
  
    
DURATION,"REF_PLANT_DICTIONARY


  		




  
  15
  
    
DURATION",,


  		




  
  16
  
    
US_NATIVITY,"REF_PLANT_DICTIONARY


  		




  
  17
  
    
US_NATIVITY",,


  		




  
  18
  
    
STATE_DISTRIBUTION,"REF_PLANT_DICTIONARY


  		




  
  19
  
    
STATE_DISTRIBUTION",,


  		




  
  20
  
    
STATE_AND_PROVINCE,"REF_PLANT_DICTIONARY


  		




  
  21
  
    
STATE_AND_PROVINCE",,


  		




  13
  22
  
    
SCIENTIFIC_NAME_W_AUTHOR,scientificName,,


  		




  14
  23
  
    
F,F_PREFIX,,


  		




  15
  
  
    
CREATED_BY,*REF_PLANT_DICTIONARY.CREATED_BY,,


  		




  16
  
  
    
CREATED_DATE,*REF_PLANT_DICTIONARY.CREATED_DATE,,


  		




  17
  
  
    
CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY.CREATED_IN_INSTANCE,,


  		




  18
  
  
    
MODIFIED_BY,*REF_PLANT_DICTIONARY.MODIFIED_BY,,


  		




  19
  
  
    
MODIFIED_DATE,*REF_PLANT_DICTIONARY.MODIFIED_DATE,,


  		




  20
  
  
    
MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY.MODIFIED_IN_INSTANCE,,


  		




  
  24
  
    
CREATED_BY,"REF_PLANT_DICTIONARY


  		




  
  25
  
    
CREATED_BY",,


  		




  
  26
  
    
CREATED_DATE,"REF_PLANT_DICTIONARY


  		




  
  27
  
    
CREATED_DATE",,


  		




  
  28
  
    
CREATED_IN_INSTANCE,"REF_PLANT_DICTIONARY


  		




  
  29
  
    
CREATED_IN_INSTANCE",,


  		




  
  30
  
    
MODIFIED_BY,"REF_PLANT_DICTIONARY


  		




  
  31
  
    
MODIFIED_BY",,


  		




  
  32
  
    
MODIFIED_DATE,"REF_PLANT_DICTIONARY


  		




  
  33
  
    
MODIFIED_DATE",,


  		




  
  34
  
    
MODIFIED_IN_INSTANCE,"REF_PLANT_DICTIONARY


  		




  
  35
  
    
MODIFIED_IN_INSTANCE",,


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/unmapped_terms.csv
    
  





  1
  
  
    
*REF_PLANT_DICTIONARY.row_num


  		




  2
  
  
    
*REF_PLANT_DICTIONARY.CN


  		




  
  1
  
    
"REF_PLANT_DICTIONARY


  		




  
  2
  
    
row_num"


  		




  
  3
  
    
"REF_PLANT_DICTIONARY


  		




  
  4
  
    
CN"


  		




  3
  5
  
    
PLANT_SYMBOL_TYPE


  		




  4
  6
  
    
PLANT_SYMBOL


  		




  5
  
  
    
*REF_PLANT_DICTIONARY.NEW_SYMBOL


  		




  6
  
  
    
*REF_PLANT_DICTIONARY.NEW_SCIENTIFIC_NAME


  		




  
  7
  
    
"REF_PLANT_DICTIONARY


  		




  
  8
  
    
NEW_SYMBOL"


  		




  
  9
  
    
"REF_PLANT_DICTIONARY


  		




  
  10
  
    
NEW_SCIENTIFIC_NAME"


  		




  7
  11
  
    
COMMON_NAME


  		




  8
  
  
    
*REF_PLANT_DICTIONARY.CATEGORY


  		




  
  12
  
    
"REF_PLANT_DICTIONARY


  		




  
  13
  
    
CATEGORY"


  		




  9
  14
  
    
taxonGrowthForm


  		




  10
  
  
    
*REF_PLANT_DICTIONARY.DURATION


  		




  11
  
  
    
*REF_PLANT_DICTIONARY.US_NATIVITY


  		




  12
  
  
    
*REF_PLANT_DICTIONARY.STATE_DISTRIBUTION


  		




  13
  
  
    
*REF_PLANT_DICTIONARY.STATE_AND_PROVINCE


  		




  
  15
  
    
"REF_PLANT_DICTIONARY


  		




  
  16
  
    
DURATION"


  		




  
  17
  
    
"REF_PLANT_DICTIONARY


  		




  
  18
  
    
US_NATIVITY"


  		




  
  19
  
    
"REF_PLANT_DICTIONARY


  		




  
  20
  
    
STATE_DISTRIBUTION"


  		




  
  21
  
    
"REF_PLANT_DICTIONARY


  		




  
  22
  
    
STATE_AND_PROVINCE"


  		




  14
  23
  
    
GENERA_BINOMIAL_AUTHOR


  		




  15
  24
  
    
TRINOMIAL_AUTHOR


  		




  16
  25
  
    
QUADRINOMIAL_AUTHOR


  		




  ......




  23
  32
  
    
SUBVAR


  		




  24
  33
  
    
SUBVARIETY


  		




  25
  34
  
    
F_PREFIX


  		




  26
  
  
    
*REF_PLANT_DICTIONARY.NOTES


  		




  27
  
  
    
*REF_PLANT_DICTIONARY.CREATED_BY


  		




  28
  
  
    
*REF_PLANT_DICTIONARY.CREATED_DATE


  		




  29
  
  
    
*REF_PLANT_DICTIONARY.CREATED_IN_INSTANCE


  		




  30
  
  
    
*REF_PLANT_DICTIONARY.MODIFIED_BY


  		




  31
  
  
    
*REF_PLANT_DICTIONARY.MODIFIED_DATE


  		




  32
  
  
    
*REF_PLANT_DICTIONARY.MODIFIED_IN_INSTANCE


  		




  
  35
  
    
"REF_PLANT_DICTIONARY


  		




  
  36
  
    
NOTES"


  		




  
  37
  
    
"REF_PLANT_DICTIONARY


  		




  
  38
  
    
CREATED_BY"


  		




  
  39
  
    
"REF_PLANT_DICTIONARY


  		




  
  40
  
    
CREATED_DATE"


  		




  
  41
  
    
"REF_PLANT_DICTIONARY


  		




  
  42
  
    
CREATED_IN_INSTANCE"


  		




  
  43
  
    
"REF_PLANT_DICTIONARY


  		




  
  44
  
    
MODIFIED_BY"


  		




  
  45
  
    
"REF_PLANT_DICTIONARY


  		




  
  46
  
    
MODIFIED_DATE"


  		




  
  47
  
    
"REF_PLANT_DICTIONARY


  		




  
  48
  
    
MODIFIED_IN_INSTANCE"


  		












  

    
      inputs/FIA/REF_UNIT/map.csv
    
  





  1
  1
  
    
FIA,VegCore,Filter,Comments


  		




  2
  
  
    
row_num,*REF_UNIT.row_num,,


  		




  
  2
  
    
row_num,"REF_UNIT


  		




  
  3
  
    
row_num",,


  		




  3
  4
  
    
STATECD,STATECD,,


  		




  4
  5
  
    
VALUE,UNITCD,,


  		




  5
  
  
    
MEANING,*REF_UNIT.MEANING,,


  		




  6
  
  
    
CREATED_BY,*REF_UNIT.CREATED_BY,,


  		




  7
  
  
    
CREATED_DATE,*REF_UNIT.CREATED_DATE,,


  		




  8
  
  
    
CREATED_IN_INSTANCE,*REF_UNIT.CREATED_IN_INSTANCE,,


  		




  9
  
  
    
MODIFIED_BY,*REF_UNIT.MODIFIED_BY,,


  		




  10
  
  
    
MODIFIED_DATE,*REF_UNIT.MODIFIED_DATE,,


  		




  11
  
  
    
MODIFIED_IN_INSTANCE,*REF_UNIT.MODIFIED_IN_INSTANCE,,


  		




  
  6
  
    
MEANING,"REF_UNIT


  		




  
  7
  
    
MEANING",,


  		




  
  8
  
    
CREATED_BY,"REF_UNIT


  		




  
  9
  
    
CREATED_BY",,


  		




  
  10
  
    
CREATED_DATE,"REF_UNIT


  		




  
  11
  
    
CREATED_DATE",,


  		




  
  12
  
    
CREATED_IN_INSTANCE,"REF_UNIT


  		




  
  13
  
    
CREATED_IN_INSTANCE",,


  		




  
  14
  
    
MODIFIED_BY,"REF_UNIT


  		




  
  15
  
    
MODIFIED_BY",,


  		




  
  16
  
    
MODIFIED_DATE,"REF_UNIT


  		




  
  17
  
    
MODIFIED_DATE",,


  		




  
  18
  
    
MODIFIED_IN_INSTANCE,"REF_UNIT


  		




  
  19
  
    
MODIFIED_IN_INSTANCE",,


  		












  

    
      inputs/FIA/REF_UNIT/new_terms.csv
    
  





  1
  
  
    
row_num,*REF_UNIT.row_num,,


  		




  
  1
  
    
row_num,"REF_UNIT


  		




  
  2
  
    
row_num",,


  		




  2
  3
  
    
VALUE,UNITCD,,


  		




  3
  
  
    
MEANING,*REF_UNIT.MEANING,,


  		




  4
  
  
    
CREATED_BY,*REF_UNIT.CREATED_BY,,


  		




  5
  
  
    
CREATED_DATE,*REF_UNIT.CREATED_DATE,,


  		




  6
  
  
    
CREATED_IN_INSTANCE,*REF_UNIT.CREATED_IN_INSTANCE,,


  		




  7
  
  
    
MODIFIED_BY,*REF_UNIT.MODIFIED_BY,,


  		




  8
  
  
    
MODIFIED_DATE,*REF_UNIT.MODIFIED_DATE,,


  		




  9
  
  
    
MODIFIED_IN_INSTANCE,*REF_UNIT.MODIFIED_IN_INSTANCE,,


  		




  
  4
  
    
MEANING,"REF_UNIT


  		




  
  5
  
    
MEANING",,


  		




  
  6
  
    
CREATED_BY,"REF_UNIT


  		




  
  7
  
    
CREATED_BY",,


  		




  
  8
  
    
CREATED_DATE,"REF_UNIT


  		




  
  9
  
    
CREATED_DATE",,


  		




  
  10
  
    
CREATED_IN_INSTANCE,"REF_UNIT


  		




  
  11
  
    
CREATED_IN_INSTANCE",,


  		




  
  12
  
    
MODIFIED_BY,"REF_UNIT


  		




  
  13
  
    
MODIFIED_BY",,


  		




  
  14
  
    
MODIFIED_DATE,"REF_UNIT


  		




  
  15
  
    
MODIFIED_DATE",,


  		




  
  16
  
    
MODIFIED_IN_INSTANCE,"REF_UNIT


  		




  
  17
  
    
MODIFIED_IN_INSTANCE",,


  		












  

    
      inputs/FIA/REF_UNIT/unmapped_terms.csv
    
  





  1
  
  
    
*REF_UNIT.row_num


  		




  
  1
  
    
"REF_UNIT


  		




  
  2
  
    
row_num"


  		




  2
  3
  
    
STATECD


  		




  3
  4
  
    
UNITCD


  		




  4
  
  
    
*REF_UNIT.MEANING


  		




  5
  
  
    
*REF_UNIT.CREATED_BY


  		




  6
  
  
    
*REF_UNIT.CREATED_DATE


  		




  7
  
  
    
*REF_UNIT.CREATED_IN_INSTANCE


  		




  8
  
  
    
*REF_UNIT.MODIFIED_BY


  		




  9
  
  
    
*REF_UNIT.MODIFIED_DATE


  		




  10
  
  
    
*REF_UNIT.MODIFIED_IN_INSTANCE


  		




  
  5
  
    
"REF_UNIT


  		




  
  6
  
    
MEANING"


  		




  
  7
  
    
"REF_UNIT


  		




  
  8
  
    
CREATED_BY"


  		




  
  9
  
    
"REF_UNIT


  		




  
  10
  
    
CREATED_DATE"


  		




  
  11
  
    
"REF_UNIT


  		




  
  12
  
    
CREATED_IN_INSTANCE"


  		




  
  13
  
    
"REF_UNIT


  		




  
  14
  
    
MODIFIED_BY"


  		




  
  15
  
    
"REF_UNIT


  		




  
  16
  
    
MODIFIED_DATE"


  		




  
  17
  
    
"REF_UNIT


  		




  
  18
  
    
MODIFIED_IN_INSTANCE"


  		












  

    
      inputs/FIA/COND/map.csv
    
  





  1
  1
  
    
FIA,VegCore,Filter,Comments


  		




  2
  
  
    
row_num,*COND.row_num,,


  		




  3
  
  
    
CN,*COND.CN,,


  		




  4
  
  
    
PLT_CN,*COND.PLT_CN,,


  		




  
  2
  
    
row_num,"COND


  		




  
  3
  
    
row_num",,


  		




  
  4
  
    
CN,"COND


  		




  
  5
  
    
CN",,


  		




  
  6
  
    
PLT_CN,"COND


  		




  
  7
  
    
PLT_CN",,


  		




  5
  8
  
    
INVYR,INVYR,,


  		




  6
  9
  
    
STATECD,STATECD,,


  		




  7
  10
  
    
UNITCD,UNITCD,,


  		




  8
  11
  
    
COUNTYCD,COUNTYCD,,


  		




  9
  12
  
    
PLOT,locationName,,


  		




  10
  13
  
    
CONDID,authorEventCode,,


  		




  11
  
  
    
COND_STATUS_CD,*COND.COND_STATUS_CD,,


  		




  12
  
  
    
COND_NONSAMPLE_REASN_CD,*COND.COND_NONSAMPLE_REASN_CD,,


  		




  13
  
  
    
RESERVCD,*COND.RESERVCD,,


  		




  14
  
  
    
OWNCD,*COND.OWNCD,,


  		




  15
  
  
    
OWNGRPCD,*COND.OWNGRPCD,,


  		




  16
  
  
    
FORINDCD,*COND.FORINDCD,,


  		




  17
  
  
    
ADFORCD,*COND.ADFORCD,,


  		




  18
  
  
    
FORTYPCD,*COND.FORTYPCD,,


  		




  19
  
  
    
FLDTYPCD,*COND.FLDTYPCD,,


  		




  20
  
  
    
MAPDEN,*COND.MAPDEN,,


  		




  21
  
  
    
STDAGE,*COND.STDAGE,,


  		




  22
  
  
    
STDSZCD,*COND.STDSZCD,,


  		




  23
  
  
    
FLDSZCD,*COND.FLDSZCD,,


  		




  24
  
  
    
SITECLCD,*COND.SITECLCD,,


  		




  25
  
  
    
SICOND,*COND.SICOND,,


  		




  26
  
  
    
SIBASE,*COND.SIBASE,,


  		




  27
  
  
    
SISP,*COND.SISP,,


  		




  28
  
  
    
STDORGCD,*COND.STDORGCD,,


  		




  29
  
  
    
STDORGSP,*COND.STDORGSP,,


  		




  30
  
  
    
PROP_BASIS,*COND.PROP_BASIS,,


  		




  31
  
  
    
CONDPROP_UNADJ,*COND.CONDPROP_UNADJ,,


  		




  32
  
  
    
MICRPROP_UNADJ,*COND.MICRPROP_UNADJ,,


  		




  33
  
  
    
SUBPPROP_UNADJ,*COND.SUBPPROP_UNADJ,,


  		




  34
  
  
    
MACRPROP_UNADJ,*COND.MACRPROP_UNADJ,,


  		




  
  14
  
    
COND_STATUS_CD,"COND


  		




  
  15
  
    
COND_STATUS_CD",,


  		




  
  16
  
    
COND_NONSAMPLE_REASN_CD,"COND


  		




  
  17
  
    
COND_NONSAMPLE_REASN_CD",,


  		




  
  18
  
    
RESERVCD,"COND


  		




  
  19
  
    
RESERVCD",,


  		




  
  20
  
    
OWNCD,"COND


  		




  
  21
  
    
OWNCD",,


  		




  
  22
  
    
OWNGRPCD,"COND


  		




  
  23
  
    
OWNGRPCD",,


  		




  
  24
  
    
FORINDCD,"COND


  		




  
  25
  
    
FORINDCD",,


  		




  
  26
  
    
ADFORCD,"COND


  		




  
  27
  
    
ADFORCD",,


  		




  
  28
  
    
FORTYPCD,"COND


  		




  
  29
  
    
FORTYPCD",,


  		




  
  30
  
    
FLDTYPCD,"COND


  		




  
  31
  
    
FLDTYPCD",,


  		




  
  32
  
    
MAPDEN,"COND


  		




  
  33
  
    
MAPDEN",,


  		




  
  34
  
    
STDAGE,"COND


  		




  
  35
  
    
STDAGE",,


  		




  
  36
  
    
STDSZCD,"COND


  		




  
  37
  
    
STDSZCD",,


  		




  
  38
  
    
FLDSZCD,"COND


  		




  
  39
  
    
FLDSZCD",,


  		




  
  40
  
    
SITECLCD,"COND


  		




  
  41
  
    
SITECLCD",,


  		




  
  42
  
    
SICOND,"COND


  		




  
  43
  
    
SICOND",,


  		




  
  44
  
    
SIBASE,"COND


  		




  
  45
  
    
SIBASE",,


  		




  
  46
  
    
SISP,"COND


  		




  
  47
  
    
SISP",,


  		




  
  48
  
    
STDORGCD,"COND


  		




  
  49
  
    
STDORGCD",,


  		




  
  50
  
    
STDORGSP,"COND


  		




  
  51
  
    
STDORGSP",,


  		




  
  52
  
    
PROP_BASIS,"COND


  		




  
  53
  
    
PROP_BASIS",,


  		




  
  54
  
    
CONDPROP_UNADJ,"COND


  		




  
  55
  
    
CONDPROP_UNADJ",,


  		




  
  56
  
    
MICRPROP_UNADJ,"COND


  		




  
  57
  
    
MICRPROP_UNADJ",,


  		




  
  58
  
    
SUBPPROP_UNADJ,"COND


  		




  
  59
  
    
SUBPPROP_UNADJ",,


  		




  
  60
  
    
MACRPROP_UNADJ,"COND


  		




  
  61
  
    
MACRPROP_UNADJ",,


  		




  35
  62
  
    
SLOPE,SLOPE,,


  		




  36
  63
  
    
ASPECT,ASPECT,,


  		




  37
  
  
    
PHYSCLCD,*COND.PHYSCLCD,,


  		




  38
  
  
    
GSSTKCD,*COND.GSSTKCD,,


  		




  39
  
  
    
ALSTKCD,*COND.ALSTKCD,,


  		




  40
  
  
    
DSTRBCD1,*COND.DSTRBCD1,,


  		




  41
  
  
    
DSTRBYR1,*COND.DSTRBYR1,,


  		




  42
  
  
    
DSTRBCD2,*COND.DSTRBCD2,,


  		




  43
  
  
    
DSTRBYR2,*COND.DSTRBYR2,,


  		




  44
  
  
    
DSTRBCD3,*COND.DSTRBCD3,,


  		




  45
  
  
    
DSTRBYR3,*COND.DSTRBYR3,,


  		




  46
  
  
    
TRTCD1,*COND.TRTCD1,,


  		




  47
  
  
    
TRTYR1,*COND.TRTYR1,,


  		




  48
  
  
    
TRTCD2,*COND.TRTCD2,,


  		




  49
  
  
    
TRTYR2,*COND.TRTYR2,,


  		




  50
  
  
    
TRTCD3,*COND.TRTCD3,,


  		




  51
  
  
    
TRTYR3,*COND.TRTYR3,,


  		




  52
  
  
    
PRESNFCD,*COND.PRESNFCD,,


  		




  53
  
  
    
BALIVE,*COND.BALIVE,,


  		




  54
  
  
    
FLDAGE,*COND.FLDAGE,,


  		




  55
  
  
    
ALSTK,*COND.ALSTK,,


  		




  56
  
  
    
GSSTK,*COND.GSSTK,,


  		




  57
  
  
    
FORTYPCDCALC,*COND.FORTYPCDCALC,,


  		




  
  64
  
    
PHYSCLCD,"COND


  		




  
  65
  
    
PHYSCLCD",,


  		




  
  66
  
    
GSSTKCD,"COND


  		




  
  67
  
    
GSSTKCD",,


  		




  
  68
  
    
ALSTKCD,"COND


  		




  
  69
  
    
ALSTKCD",,


  		




  
  70
  
    
DSTRBCD1,"COND


  		




  
  71
  
    
DSTRBCD1",,


  		




  
  72
  
    
DSTRBYR1,"COND


  		




  
  73
  
    
DSTRBYR1",,


  		




  
  74
  
    
DSTRBCD2,"COND


  		




  
  75
  
    
DSTRBCD2",,


  		




  
  76
  
    
DSTRBYR2,"COND


  		




  
  77
  
    
DSTRBYR2",,


  		




  
  78
  
    
DSTRBCD3,"COND


  		




  
  79
  
    
DSTRBCD3",,


  		




  
  80
  
    
DSTRBYR3,"COND


  		




  
  81
  
    
DSTRBYR3",,


  		




  
  82
  
    
TRTCD1,"COND


  		




  
  83
  
    
TRTCD1",,


  		




  
  84
  
    
TRTYR1,"COND


  		




  
  85
  
    
TRTYR1",,


  		




  
  86
  
    
TRTCD2,"COND


  		




  
  87
  
    
TRTCD2",,


  		




  
  88
  
    
TRTYR2,"COND


  		




  
  89
  
    
TRTYR2",,


  		




  
  90
  
    
TRTCD3,"COND


  		




  
  91
  
    
TRTCD3",,


  		




  
  92
  
    
TRTYR3,"COND


  		




  
  93
  
    
TRTYR3",,


  		




  
  94
  
    
PRESNFCD,"COND


  		




  
  95
  
    
PRESNFCD",,


  		




  
  96
  
    
BALIVE,"COND


  		




  
  97
  
    
BALIVE",,


  		




  
  98
  
    
FLDAGE,"COND


  		




  
  99
  
    
FLDAGE",,


  		




  
  100
  
    
ALSTK,"COND


  		




  
  101
  
    
ALSTK",,


  		




  
  102
  
    
GSSTK,"COND


  		




  
  103
  
    
GSSTK",,


  		




  
  104
  
    
FORTYPCDCALC,"COND


  		




  
  105
  
    
FORTYPCDCALC",,


  		




  58
  106
  
    
HABTYPCD1,HABTYPCD,,


  		




  59
  107
  
    
HABTYPCD1_PUB_CD,HABTYP_PUB_CD,,


  		




  60
  
  
    
HABTYPCD1_DESCR_PUB_CD,*COND.HABTYPCD1_DESCR_PUB_CD,,


  		




  61
  
  
    
HABTYPCD2,*COND.HABTYPCD2,,


  		




  62
  
  
    
HABTYPCD2_PUB_CD,*COND.HABTYPCD2_PUB_CD,,


  		




  63
  
  
    
HABTYPCD2_DESCR_PUB_CD,*COND.HABTYPCD2_DESCR_PUB_CD,,


  		




  64
  
  
    
MIXEDCONFCD,*COND.MIXEDCONFCD,,


  		




  65
  
  
    
VOL_LOC_GRP,*COND.VOL_LOC_GRP,,


  		




  66
  
  
    
SITECLCDEST,*COND.SITECLCDEST,,


  		




  67
  
  
    
SITETREE_TREE,*COND.SITETREE_TREE,,


  		




  68
  
  
    
SITECL_METHOD,*COND.SITECL_METHOD,,


  		




  69
  
  
    
CARBON_DOWN_DEAD,*COND.CARBON_DOWN_DEAD,,


  		




  70
  
  
    
CARBON_LITTER,*COND.CARBON_LITTER,,


  		




  71
  
  
    
CARBON_SOIL_ORG,*COND.CARBON_SOIL_ORG,,


  		




  72
  
  
    
CARBON_STANDING_DEAD,*COND.CARBON_STANDING_DEAD,,


  		




  73
  
  
    
CARBON_UNDERSTORY_AG,*COND.CARBON_UNDERSTORY_AG,,


  		




  74
  
  
    
CARBON_UNDERSTORY_BG,*COND.CARBON_UNDERSTORY_BG,,


  		




  75
  
  
    
CREATED_BY,*COND.CREATED_BY,,


  		




  76
  
  
    
CREATED_DATE,*COND.CREATED_DATE,,


  		




  77
  
  
    
CREATED_IN_INSTANCE,*COND.CREATED_IN_INSTANCE,,


  		




  78
  
  
    
MODIFIED_BY,*COND.MODIFIED_BY,,


  		




  79
  
  
    
MODIFIED_DATE,*COND.MODIFIED_DATE,,


  		




  80
  
  
    
MODIFIED_IN_INSTANCE,*COND.MODIFIED_IN_INSTANCE,,


  		




  81
  
  
    
CYCLE,*COND.CYCLE,,


  		




  82
  
  
    
SUBCYCLE,*COND.SUBCYCLE,,


  		




  83
  
  
    
SOIL_ROOTING_DEPTH_PNW,*COND.SOIL_ROOTING_DEPTH_PNW,,


  		




  84
  
  
    
GROUND_LAND_CLASS_PNW,*COND.GROUND_LAND_CLASS_PNW,,


  		




  85
  
  
    
PLANT_STOCKABILITY_FACTOR_PNW,*COND.PLANT_STOCKABILITY_FACTOR_PNW,,


  		




  86
  
  
    
STND_COND_CD_PNWRS,*COND.STND_COND_CD_PNWRS,,


  		




  87
  
  
    
STND_STRUC_CD_PNWRS,*COND.STND_STRUC_CD_PNWRS,,


  		




  88
  
  
    
STUMP_CD_PNWRS,*COND.STUMP_CD_PNWRS,,


  		




  89
  
  
    
FIRE_SRS,*COND.FIRE_SRS,,


  		




  90
  
  
    
GRAZING_SRS,*COND.GRAZING_SRS,,


  		




  91
  
  
    
HARVEST_TYPE1_SRS,*COND.HARVEST_TYPE1_SRS,,


  		




  92
  
  
    
HARVEST_TYPE2_SRS,*COND.HARVEST_TYPE2_SRS,,


  		




  93
  
  
    
HARVEST_TYPE3_SRS,*COND.HARVEST_TYPE3_SRS,,


  		




  94
  
  
    
LAND_USE_SRS,*COND.LAND_USE_SRS,,


  		




  95
  
  
    
OPERABILITY_SRS,*COND.OPERABILITY_SRS,,


  		




  96
  
  
    
STAND_STRUCTURE_SRS,*COND.STAND_STRUCTURE_SRS,,


  		




  97
  
  
    
NF_COND_STATUS_CD,*COND.NF_COND_STATUS_CD,,


  		




  98
  
  
    
NF_COND_NONSAMPLE_REASN_CD,*COND.NF_COND_NONSAMPLE_REASN_CD,,


  		




  99
  
  
    
CANOPY_CVR_SAMPLE_METHOD_CD,*COND.CANOPY_CVR_SAMPLE_METHOD_CD,,


  		




  100
  
  
    
LIVE_CANOPY_CVR_PCT,*COND.LIVE_CANOPY_CVR_PCT,,


  		




  101
  
  
    
LIVE_MISSING_CANOPY_CVR_PCT,*COND.LIVE_MISSING_CANOPY_CVR_PCT,,


  		




  102
  
  
    
NBR_LIVE_STEMS,*COND.NBR_LIVE_STEMS,,


  		




  103
  
  
    
OWNSUBCD,*COND.OWNSUBCD,,


  		




  104
  
  
    
INDUSTRIALCD_FIADB,*COND.INDUSTRIALCD_FIADB,,


  		




  105
  
  
    
RESERVCD_FLD,*COND.RESERVCD_FLD,,


  		




  106
  
  
    
ADMIN_WITHDRAWN_CD,*COND.ADMIN_WITHDRAWN_CD,,


  		




  
  108
  
    
HABTYPCD1_DESCR_PUB_CD,"COND


  		




  
  109
  
    
HABTYPCD1_DESCR_PUB_CD",,


  		




  
  110
  
    
HABTYPCD2,"COND


  		




  
  111
  
    
HABTYPCD2",,


  		




  
  112
  
    
HABTYPCD2_PUB_CD,"COND


  		




  
  113
  
    
HABTYPCD2_PUB_CD",,


  		




  
  114
  
    
HABTYPCD2_DESCR_PUB_CD,"COND


  		




  
  115
  
    
HABTYPCD2_DESCR_PUB_CD",,


  		




  
  116
  
    
MIXEDCONFCD,"COND


  		




  
  117
  
    
MIXEDCONFCD",,


  		




  
  118
  
    
VOL_LOC_GRP,"COND


  		




  
  119
  
    
VOL_LOC_GRP",,


  		




  
  120
  
    
SITECLCDEST,"COND


  		




  
  121
  
    
SITECLCDEST",,


  		




  
  122
  
    
SITETREE_TREE,"COND


  		




  
  123
  
    
SITETREE_TREE",,


  		




  
  124
  
    
SITECL_METHOD,"COND


  		




  
  125
  
    
SITECL_METHOD",,


  		




  
  126
  
    
CARBON_DOWN_DEAD,"COND


  		




  
  127
  
    
CARBON_DOWN_DEAD",,


  		




  
  128
  
    
CARBON_LITTER,"COND


  		




  
  129
  
    
CARBON_LITTER",,


  		




  
  130
  
    
CARBON_SOIL_ORG,"COND


  		




  
  131
  
    
CARBON_SOIL_ORG",,


  		




  
  132
  
    
CARBON_STANDING_DEAD,"COND


  		




  
  133
  
    
CARBON_STANDING_DEAD",,


  		




  
  134
  
    
CARBON_UNDERSTORY_AG,"COND


  		




  
  135
  
    
CARBON_UNDERSTORY_AG",,


  		




  
  136
  
    
CARBON_UNDERSTORY_BG,"COND


  		




  
  137
  
    
CARBON_UNDERSTORY_BG",,


  		




  
  138
  
    
CREATED_BY,"COND


  		




  
  139
  
    
CREATED_BY",,


  		




  
  140
  
    
CREATED_DATE,"COND


  		




  
  141
  
    
CREATED_DATE",,


  		




  
  142
  
    
CREATED_IN_INSTANCE,"COND


  		




  
  143
  
    
CREATED_IN_INSTANCE",,


  		




  
  144
  
    
MODIFIED_BY,"COND


  		




  
  145
  
    
MODIFIED_BY",,


  		




  
  146
  
    
MODIFIED_DATE,"COND


  		




  
  147
  
    
MODIFIED_DATE",,


  		




  
  148
  
    
MODIFIED_IN_INSTANCE,"COND


  		




  
  149
  
    
MODIFIED_IN_INSTANCE",,


  		




  
  150
  
    
CYCLE,"COND


  		




  
  151
  
    
CYCLE",,


  		




  
  152
  
    
SUBCYCLE,"COND


  		




  
  153
  
    
SUBCYCLE",,


  		




  
  154
  
    
SOIL_ROOTING_DEPTH_PNW,"COND


  		




  
  155
  
    
SOIL_ROOTING_DEPTH_PNW",,


  		




  
  156
  
    
GROUND_LAND_CLASS_PNW,"COND


  		




  
  157
  
    
GROUND_LAND_CLASS_PNW",,


  		




  
  158
  
    
PLANT_STOCKABILITY_FACTOR_PNW,"COND


  		




  
  159
  
    
PLANT_STOCKABILITY_FACTOR_PNW",,


  		




  
  160
  
    
STND_COND_CD_PNWRS,"COND


  		




  
  161
  
    
STND_COND_CD_PNWRS",,


  		




  
  162
  
    
STND_STRUC_CD_PNWRS,"COND


  		




  
  163
  
    
STND_STRUC_CD_PNWRS",,


  		




  
  164
  
    
STUMP_CD_PNWRS,"COND


  		




  
  165
  
    
STUMP_CD_PNWRS",,


  		




  
  166
  
    
FIRE_SRS,"COND


  		




  
  167
  
    
FIRE_SRS",,


  		




  
  168
  
    
GRAZING_SRS,"COND


  		




  
  169
  
    
GRAZING_SRS",,


  		




  
  170
  
    
HARVEST_TYPE1_SRS,"COND


  		




  
  171
  
    
HARVEST_TYPE1_SRS",,


  		




  
  172
  
    
HARVEST_TYPE2_SRS,"COND


  		




  
  173
  
    
HARVEST_TYPE2_SRS",,


  		




  
  174
  
    
HARVEST_TYPE3_SRS,"COND


  		




  
  175
  
    
HARVEST_TYPE3_SRS",,


  		




  
  176
  
    
LAND_USE_SRS,"COND


  		




  
  177
  
    
LAND_USE_SRS",,


  		




  
  178
  
    
OPERABILITY_SRS,"COND


  		




  
  179
  
    
OPERABILITY_SRS",,


  		




  
  180
  
    
STAND_STRUCTURE_SRS,"COND


  		




  
  181
  
    
STAND_STRUCTURE_SRS",,


  		




  
  182
  
    
NF_COND_STATUS_CD,"COND


  		




  
  183
  
    
NF_COND_STATUS_CD",,


  		




  
  184
  
    
NF_COND_NONSAMPLE_REASN_CD,"COND


  		




  
  185
  
    
NF_COND_NONSAMPLE_REASN_CD",,


  		




  
  186
  
    
CANOPY_CVR_SAMPLE_METHOD_CD,"COND


  		




  
  187
  
    
CANOPY_CVR_SAMPLE_METHOD_CD",,


  		




  
  188
  
    
LIVE_CANOPY_CVR_PCT,"COND


  		




  
  189
  
    
LIVE_CANOPY_CVR_PCT",,


  		




  
  190
  
    
LIVE_MISSING_CANOPY_CVR_PCT,"COND


  		




  
  191
  
    
LIVE_MISSING_CANOPY_CVR_PCT",,


  		




  
  192
  
    
NBR_LIVE_STEMS,"COND


  		




  
  193
  
    
NBR_LIVE_STEMS",,


  		




  
  194
  
    
OWNSUBCD,"COND


  		




  
  195
  
    
OWNSUBCD",,


  		




  
  196
  
    
INDUSTRIALCD_FIADB,"COND


  		




  
  197
  
    
INDUSTRIALCD_FIADB",,


  		




  
  198
  
    
RESERVCD_FLD,"COND


  		




  
  199
  
    
RESERVCD_FLD",,


  		




  
  200
  
    
ADMIN_WITHDRAWN_CD,"COND


  		




  
  201
  
    
ADMIN_WITHDRAWN_CD",,


  		












  

    
      inputs/FIA/COND/import
    
  





  30
  30
  
    
;


  		




  31
  31
  
    
$$);


  		




  32
  32
  
    

  		




  33
  
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.ID"     UNIQUE ("*COND.CN")$$);


  		




  
  33
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.ID"     UNIQUE ("COND


  		




  
  34
  
    
CN")$$);


  		




  34
  35
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "locationName", "INVYR", "authorEventCode")$$);


  		




  35
  36
  
    
SELECT functions.cluster_once('"COND"', '"COND.unique"');


  		












  

    
      inputs/FIA/COND/new_terms.csv
    
  





  1
  
  
    
row_num,*COND.row_num,,


  		




  2
  
  
    
CN,*COND.CN,,


  		




  3
  
  
    
PLT_CN,*COND.PLT_CN,,


  		




  
  1
  
    
row_num,"COND


  		




  
  2
  
    
row_num",,


  		




  
  3
  
    
CN,"COND


  		




  
  4
  
    
CN",,


  		




  
  5
  
    
PLT_CN,"COND


  		




  
  6
  
    
PLT_CN",,


  		




  4
  7
  
    
PLOT,locationName,,


  		




  5
  8
  
    
CONDID,authorEventCode,,


  		




  6
  
  
    
COND_STATUS_CD,*COND.COND_STATUS_CD,,


  		




  7
  
  
    
COND_NONSAMPLE_REASN_CD,*COND.COND_NONSAMPLE_REASN_CD,,


  		




  8
  
  
    
RESERVCD,*COND.RESERVCD,,


  		




  9
  
  
    
OWNCD,*COND.OWNCD,,


  		




  10
  
  
    
OWNGRPCD,*COND.OWNGRPCD,,


  		




  11
  
  
    
FORINDCD,*COND.FORINDCD,,


  		




  12
  
  
    
ADFORCD,*COND.ADFORCD,,


  		




  13
  
  
    
FORTYPCD,*COND.FORTYPCD,,


  		




  14
  
  
    
FLDTYPCD,*COND.FLDTYPCD,,


  		




  15
  
  
    
MAPDEN,*COND.MAPDEN,,


  		




  16
  
  
    
STDAGE,*COND.STDAGE,,


  		




  17
  
  
    
STDSZCD,*COND.STDSZCD,,


  		




  18
  
  
    
FLDSZCD,*COND.FLDSZCD,,


  		




  19
  
  
    
SITECLCD,*COND.SITECLCD,,


  		




  20
  
  
    
SICOND,*COND.SICOND,,


  		




  21
  
  
    
SIBASE,*COND.SIBASE,,


  		




  22
  
  
    
SISP,*COND.SISP,,


  		




  23
  
  
    
STDORGCD,*COND.STDORGCD,,


  		




  24
  
  
    
STDORGSP,*COND.STDORGSP,,


  		




  25
  
  
    
PROP_BASIS,*COND.PROP_BASIS,,


  		




  26
  
  
    
CONDPROP_UNADJ,*COND.CONDPROP_UNADJ,,


  		




  27
  
  
    
MICRPROP_UNADJ,*COND.MICRPROP_UNADJ,,


  		




  28
  
  
    
SUBPPROP_UNADJ,*COND.SUBPPROP_UNADJ,,


  		




  29
  
  
    
MACRPROP_UNADJ,*COND.MACRPROP_UNADJ,,


  		




  30
  
  
    
PHYSCLCD,*COND.PHYSCLCD,,


  		




  31
  
  
    
GSSTKCD,*COND.GSSTKCD,,


  		




  32
  
  
    
ALSTKCD,*COND.ALSTKCD,,


  		




  33
  
  
    
DSTRBCD1,*COND.DSTRBCD1,,


  		




  34
  
  
    
DSTRBYR1,*COND.DSTRBYR1,,


  		




  35
  
  
    
DSTRBCD2,*COND.DSTRBCD2,,


  		




  36
  
  
    
DSTRBYR2,*COND.DSTRBYR2,,


  		




  37
  
  
    
DSTRBCD3,*COND.DSTRBCD3,,


  		




  38
  
  
    
DSTRBYR3,*COND.DSTRBYR3,,


  		




  39
  
  
    
TRTCD1,*COND.TRTCD1,,


  		




  40
  
  
    
TRTYR1,*COND.TRTYR1,,


  		




  41
  
  
    
TRTCD2,*COND.TRTCD2,,


  		




  42
  
  
    
TRTYR2,*COND.TRTYR2,,


  		




  43
  
  
    
TRTCD3,*COND.TRTCD3,,


  		




  44
  
  
    
TRTYR3,*COND.TRTYR3,,


  		




  45
  
  
    
PRESNFCD,*COND.PRESNFCD,,


  		




  46
  
  
    
BALIVE,*COND.BALIVE,,


  		




  47
  
  
    
FLDAGE,*COND.FLDAGE,,


  		




  48
  
  
    
ALSTK,*COND.ALSTK,,


  		




  49
  
  
    
GSSTK,*COND.GSSTK,,


  		




  50
  
  
    
FORTYPCDCALC,*COND.FORTYPCDCALC,,


  		




  
  9
  
    
COND_STATUS_CD,"COND


  		




  
  10
  
    
COND_STATUS_CD",,


  		




  
  11
  
    
COND_NONSAMPLE_REASN_CD,"COND


  		




  
  12
  
    
COND_NONSAMPLE_REASN_CD",,


  		




  
  13
  
    
RESERVCD,"COND


  		




  
  14
  
    
RESERVCD",,


  		




  
  15
  
    
OWNCD,"COND


  		




  
  16
  
    
OWNCD",,


  		




  
  17
  
    
OWNGRPCD,"COND


  		




  
  18
  
    
OWNGRPCD",,


  		




  
  19
  
    
FORINDCD,"COND


  		




  
  20
  
    
FORINDCD",,


  		




  
  21
  
    
ADFORCD,"COND


  		




  
  22
  
    
ADFORCD",,


  		




  
  23
  
    
FORTYPCD,"COND


  		




  
  24
  
    
FORTYPCD",,


  		




  
  25
  
    
FLDTYPCD,"COND


  		




  
  26
  
    
FLDTYPCD",,


  		




  
  27
  
    
MAPDEN,"COND


  		




  
  28
  
    
MAPDEN",,


  		




  
  29
  
    
STDAGE,"COND


  		




  
  30
  
    
STDAGE",,


  		




  
  31
  
    
STDSZCD,"COND


  		




  
  32
  
    
STDSZCD",,


  		




  
  33
  
    
FLDSZCD,"COND


  		




  
  34
  
    
FLDSZCD",,


  		




  
  35
  
    
SITECLCD,"COND


  		




  
  36
  
    
SITECLCD",,


  		




  
  37
  
    
SICOND,"COND


  		




  
  38
  
    
SICOND",,


  		




  
  39
  
    
SIBASE,"COND


  		




  
  40
  
    
SIBASE",,


  		




  
  41
  
    
SISP,"COND


  		




  
  42
  
    
SISP",,


  		




  
  43
  
    
STDORGCD,"COND


  		




  
  44
  
    
STDORGCD",,


  		




  
  45
  
    
STDORGSP,"COND


  		




  
  46
  
    
STDORGSP",,


  		




  
  47
  
    
PROP_BASIS,"COND


  		




  
  48
  
    
PROP_BASIS",,


  		




  
  49
  
    
CONDPROP_UNADJ,"COND


  		




  
  50
  
    
CONDPROP_UNADJ",,


  		




  
  51
  
    
MICRPROP_UNADJ,"COND


  		




  
  52
  
    
MICRPROP_UNADJ",,


  		




  
  53
  
    
SUBPPROP_UNADJ,"COND


  		




  
  54
  
    
SUBPPROP_UNADJ",,


  		




  
  55
  
    
MACRPROP_UNADJ,"COND


  		




  
  56
  
    
MACRPROP_UNADJ",,


  		




  
  57
  
    
PHYSCLCD,"COND


  		




  
  58
  
    
PHYSCLCD",,


  		




  
  59
  
    
GSSTKCD,"COND


  		




  
  60
  
    
GSSTKCD",,


  		




  
  61
  
    
ALSTKCD,"COND


  		




  
  62
  
    
ALSTKCD",,


  		




  
  63
  
    
DSTRBCD1,"COND


  		




  
  64
  
    
DSTRBCD1",,


  		




  
  65
  
    
DSTRBYR1,"COND


  		




  
  66
  
    
DSTRBYR1",,


  		




  
  67
  
    
DSTRBCD2,"COND


  		




  
  68
  
    
DSTRBCD2",,


  		




  
  69
  
    
DSTRBYR2,"COND


  		




  
  70
  
    
DSTRBYR2",,


  		




  
  71
  
    
DSTRBCD3,"COND


  		




  
  72
  
    
DSTRBCD3",,


  		




  
  73
  
    
DSTRBYR3,"COND


  		




  
  74
  
    
DSTRBYR3",,


  		




  
  75
  
    
TRTCD1,"COND


  		




  
  76
  
    
TRTCD1",,


  		




  
  77
  
    
TRTYR1,"COND


  		




  
  78
  
    
TRTYR1",,


  		




  
  79
  
    
TRTCD2,"COND


  		




  
  80
  
    
TRTCD2",,


  		




  
  81
  
    
TRTYR2,"COND


  		




  
  82
  
    
TRTYR2",,


  		




  
  83
  
    
TRTCD3,"COND


  		




  
  84
  
    
TRTCD3",,


  		




  
  85
  
    
TRTYR3,"COND


  		




  
  86
  
    
TRTYR3",,


  		




  
  87
  
    
PRESNFCD,"COND


  		




  
  88
  
    
PRESNFCD",,


  		




  
  89
  
    
BALIVE,"COND


  		




  
  90
  
    
BALIVE",,


  		




  
  91
  
    
FLDAGE,"COND


  		




  
  92
  
    
FLDAGE",,


  		




  
  93
  
    
ALSTK,"COND


  		




  
  94
  
    
ALSTK",,


  		




  
  95
  
    
GSSTK,"COND


  		




  
  96
  
    
GSSTK",,


  		




  
  97
  
    
FORTYPCDCALC,"COND


  		




  
  98
  
    
FORTYPCDCALC",,


  		




  51
  99
  
    
HABTYPCD1,HABTYPCD,,


  		




  52
  100
  
    
HABTYPCD1_PUB_CD,HABTYP_PUB_CD,,


  		




  53
  
  
    
HABTYPCD1_DESCR_PUB_CD,*COND.HABTYPCD1_DESCR_PUB_CD,,


  		




  54
  
  
    
HABTYPCD2,*COND.HABTYPCD2,,


  		




  55
  
  
    
HABTYPCD2_PUB_CD,*COND.HABTYPCD2_PUB_CD,,


  		




  56
  
  
    
HABTYPCD2_DESCR_PUB_CD,*COND.HABTYPCD2_DESCR_PUB_CD,,


  		




  57
  
  
    
MIXEDCONFCD,*COND.MIXEDCONFCD,,


  		




  58
  
  
    
VOL_LOC_GRP,*COND.VOL_LOC_GRP,,


  		




  59
  
  
    
SITECLCDEST,*COND.SITECLCDEST,,


  		




  60
  
  
    
SITETREE_TREE,*COND.SITETREE_TREE,,


  		




  61
  
  
    
SITECL_METHOD,*COND.SITECL_METHOD,,


  		




  62
  
  
    
CARBON_DOWN_DEAD,*COND.CARBON_DOWN_DEAD,,


  		




  63
  
  
    
CARBON_LITTER,*COND.CARBON_LITTER,,


  		




  64
  
  
    
CARBON_SOIL_ORG,*COND.CARBON_SOIL_ORG,,


  		




  65
  
  
    
CARBON_STANDING_DEAD,*COND.CARBON_STANDING_DEAD,,


  		




  66
  
  
    
CARBON_UNDERSTORY_AG,*COND.CARBON_UNDERSTORY_AG,,


  		




  67
  
  
    
CARBON_UNDERSTORY_BG,*COND.CARBON_UNDERSTORY_BG,,


  		




  68
  
  
    
CREATED_BY,*COND.CREATED_BY,,


  		




  69
  
  
    
CREATED_DATE,*COND.CREATED_DATE,,


  		




  70
  
  
    
CREATED_IN_INSTANCE,*COND.CREATED_IN_INSTANCE,,


  		




  71
  
  
    
MODIFIED_BY,*COND.MODIFIED_BY,,


  		




  72
  
  
    
MODIFIED_DATE,*COND.MODIFIED_DATE,,


  		




  73
  
  
    
MODIFIED_IN_INSTANCE,*COND.MODIFIED_IN_INSTANCE,,


  		




  74
  
  
    
CYCLE,*COND.CYCLE,,


  		




  75
  
  
    
SUBCYCLE,*COND.SUBCYCLE,,


  		




  76
  
  
    
SOIL_ROOTING_DEPTH_PNW,*COND.SOIL_ROOTING_DEPTH_PNW,,


  		




  77
  
  
    
GROUND_LAND_CLASS_PNW,*COND.GROUND_LAND_CLASS_PNW,,


  		




  78
  
  
    
PLANT_STOCKABILITY_FACTOR_PNW,*COND.PLANT_STOCKABILITY_FACTOR_PNW,,


  		




  79
  
  
    
STND_COND_CD_PNWRS,*COND.STND_COND_CD_PNWRS,,


  		




  80
  
  
    
STND_STRUC_CD_PNWRS,*COND.STND_STRUC_CD_PNWRS,,


  		




  81
  
  
    
STUMP_CD_PNWRS,*COND.STUMP_CD_PNWRS,,


  		




  82
  
  
    
FIRE_SRS,*COND.FIRE_SRS,,


  		




  83
  
  
    
GRAZING_SRS,*COND.GRAZING_SRS,,


  		




  84
  
  
    
HARVEST_TYPE1_SRS,*COND.HARVEST_TYPE1_SRS,,


  		




  85
  
  
    
HARVEST_TYPE2_SRS,*COND.HARVEST_TYPE2_SRS,,


  		




  86
  
  
    
HARVEST_TYPE3_SRS,*COND.HARVEST_TYPE3_SRS,,


  		




  87
  
  
    
LAND_USE_SRS,*COND.LAND_USE_SRS,,


  		




  88
  
  
    
OPERABILITY_SRS,*COND.OPERABILITY_SRS,,


  		




  89
  
  
    
STAND_STRUCTURE_SRS,*COND.STAND_STRUCTURE_SRS,,


  		




  90
  
  
    
NF_COND_STATUS_CD,*COND.NF_COND_STATUS_CD,,


  		




  91
  
  
    
NF_COND_NONSAMPLE_REASN_CD,*COND.NF_COND_NONSAMPLE_REASN_CD,,


  		




  92
  
  
    
CANOPY_CVR_SAMPLE_METHOD_CD,*COND.CANOPY_CVR_SAMPLE_METHOD_CD,,


  		




  93
  
  
    
LIVE_CANOPY_CVR_PCT,*COND.LIVE_CANOPY_CVR_PCT,,


  		




  94
  
  
    
LIVE_MISSING_CANOPY_CVR_PCT,*COND.LIVE_MISSING_CANOPY_CVR_PCT,,


  		




  95
  
  
    
NBR_LIVE_STEMS,*COND.NBR_LIVE_STEMS,,


  		




  96
  
  
    
OWNSUBCD,*COND.OWNSUBCD,,


  		




  97
  
  
    
INDUSTRIALCD_FIADB,*COND.INDUSTRIALCD_FIADB,,


  		




  98
  
  
    
RESERVCD_FLD,*COND.RESERVCD_FLD,,


  		




  99
  
  
    
ADMIN_WITHDRAWN_CD,*COND.ADMIN_WITHDRAWN_CD,,


  		




  
  101
  
    
HABTYPCD1_DESCR_PUB_CD,"COND


  		








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



Also available in:  Unified diff