Project

General

Profile

« Previous | Next » 

Revision 6318

Added by Aaron Marcuse-Kubitza about 12 years ago

Added inputs/FIA/FIA_COND_unique/, which contains the oldgrowth flag

View differences:

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

Also available in: Unified diff