Project

General

Profile

« Previous | Next » 

Revision 8206

mappings/VegCore-VegBIEN.csv: subplotID,subplot -> location.sourceaccessioncode: Fixed bug where need /_first to handle the case where both subplotID and subplot are provided

View differences:

inputs/TEAM/VL/VegBIEN.csv
39 39
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
40 40
Latitude,"/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"
41 41
Longitude,"/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"
42
Subplot Number,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
43
Subplot Number,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
42
Subplot Number,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
43
Subplot Number,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
44 44
Comments,,** No join mapping for *Comments ** 
45 45
Condition Codes,,** No join mapping for *Condition Codes ** 
46 46
Data Level,,** No join mapping for *Data Level ** 
inputs/TEAM/VT/VegBIEN.csv
39 39
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
40 40
Latitude,"/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"
41 41
Longitude,"/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"
42
Subplot Number,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
43
Subplot Number,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
42
Subplot Number,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
43
Subplot Number,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
44 44
Comments,,** No join mapping for *Comments ** 
45 45
Condition Codes,,** No join mapping for *Condition Codes ** 
46 46
Data Level,,** No join mapping for *Data Level ** 
inputs/SALVIAS/plotObservations/VegBIEN.csv
124 124
DetType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
125 125
coll_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1",Brad: Map instead as for voucher_string
126 126
SourceVoucher,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
127
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
128
Line,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
129
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
130
Line,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
127
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
128
Line,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
129
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
130
Line,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
131 131
GenAuth,,** No join mapping for *GenAuth ** 
132 132
IsMorpho,,** No join mapping for *IsMorpho ** 
133 133
OrigAuth,,** No join mapping for *OrigAuth ** 
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
66 66
PolDiv1,/location/locationplace/*_id/place/stateprovince,Brad: No; pol1=stateProvince
67 67
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value,
68 68
slope_gradient,/location/slopegradient_fraction/_alt/1,
69
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
70
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
69
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
70
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
71 71
ElevSource,,** No join mapping for *ElevSource ** 
72 72
MethodCode,,** No non-empty join mapping for OMIT ** Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
73 73
PrecipSource,,** No join mapping for *PrecipSource ** 
inputs/Madidi/IndividualObservation/VegBIEN.csv
66 66
FieldNameFullName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname,
67 67
SpecimenID,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
68 68
CollectionNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
69
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
70
Sequence,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
71
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
72
Sequence,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
69
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
70
Sequence,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
71
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
72
Sequence,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
73 73
SubplotX,/location/sublocationxposition_m,
74 74
SubplotY,/location/sublocationyposition_m,
75 75
AreaRachilla1,,** No non-empty join mapping for UNUSED ** 
inputs/Madidi/LocationObservation/VegBIEN.csv
46 46
LatitudeDecDeg,"/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"
47 47
LongitudeDecDeg,"/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"
48 48
Slope,/location/slopegradient_fraction/_alt/1,
49
PlotName,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists/_first/1",
50
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists/_first/2",
51
PlotName,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1/_first/1",
52
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1/_first/2",
49
PlotName,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists/_first/1",
50
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists/_first/2",
51
PlotName,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1/_first/1",
52
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1/_first/2",
53 53
Collaborators,,** No join mapping for *Collaborators ** 
54 54
Collaborators (OLD),,** No join mapping for *Collaborators (OLD) ** 
55 55
Funding agency,,** No join mapping for *Funding agency ** 
inputs/Madidi/Location/VegBIEN.csv
25 25
LowerName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
26 26
UpperName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
27 27
UpperName,/location/locationplace/*_id/place/stateprovince,
28
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
29
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
28
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
29
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
30 30
FirstSurveyDate,,** No join mapping for *FirstSurveyDate ** 
31 31
OrientationXDegrees,,** No join mapping for *OrientationXDegrees ** 
32 32
OrientationYDegrees,,** No join mapping for *OrientationYDegrees ** 
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
127 127
det_type,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
128 128
coll_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1",Brad: Map instead as for voucher_string
129 129
voucher_string,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
130
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
131
subplot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
132
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
133
subplot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
130
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
131
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
132
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
133
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
134 134
collector_code,,** No join mapping for *collector_code ** Brad: OMIT
135 135
comments,,** No join mapping for *comments ** Brad: OMIT
136 136
fam_status,,** No join mapping for *fam_status ** Brad: OMIT. This will be determined later by using TNRS.
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
57 57
pol1,/location/locationplace/*_id/place/stateprovince,Brad: No; pol1=stateProvince
58 58
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value,
59 59
slope_gradient,/location/slopegradient_fraction/_alt/1,
60
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
61
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
60
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
61
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
62 62
recensused,,"** No join mapping for *recensused ** Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/CVS/observation_/VegBIEN.csv
29 29
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
30 30
PLOT_ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
31 31
authorObsCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
32
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
33
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
32
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
33
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
34 34
COVERMETHOD_ID,,** No join mapping for *COVERMETHOD_ID ** 
35 35
PREVIOUSOBS_ID,,** No join mapping for *PREVIOUSOBS_ID ** 
36 36
SOILOBS_ID,,** No join mapping for *SOILOBS_ID ** 
inputs/CVS/plot_/VegBIEN.csv
41 41
slopeGradient,/location/slopegradient_fraction/_alt/1,
42 42
minSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/1,
43 43
maxSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/2,
44
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
45
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
44
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
45
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
46 46
Geographic Name,,** No join mapping for *Geographic Name ** 
47 47
REPLACEMENTPLOT_ID,,** No join mapping for *REPLACEMENTPLOT_ID ** 
48 48
River Basin,,** No join mapping for *River Basin ** 
inputs/FIA/Organism/VegBIEN.csv
28 28
County,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
29 29
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
30 30
StateProvince,/location/locationplace/*_id/place/stateprovince,
31
PlotCD,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
32
PlotCD,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
31
PlotCD,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
32
PlotCD,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
33 33
HOM,,** No join mapping for *HOM ** 
inputs/FIA/FIA_COND_unique/VegBIEN.csv
15 15
PLOT,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
16 16
PLT_CN,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
17 17
oldgrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/1/_not/value",
18
PLT_CN,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
19
PLT_CN,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
18
PLT_CN,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
19
PLT_CN,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
20 20
ADFORCD,,** No join mapping for *ADFORCD ** 
21 21
ALSTK,,** No join mapping for *ALSTK ** 
22 22
ALSTKCD,,** No join mapping for *ALSTKCD ** 
inputs/NVS/AggregateOccurrence/VegBIEN.csv
17 17
Species Name,/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,
18 18
Species Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
19 19
Taxon Obs Note,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
20
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
20
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
22 22
Category,,** No join mapping for *Category ** 
23 23
Category Description,,** No join mapping for *Category Description ** 
24 24
Method Name,,** No join mapping for *Method Name ** 
inputs/NVS/TaxonOccurrence.Understory/VegBIEN.csv
17 17
Species Name,/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,
18 18
Species Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
19 19
Taxon Obs Note,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
20
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
20
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
22 22
Method Name,,** No join mapping for *Method Name ** 
23 23
Parent Plot Obs ID,,** No join mapping for *Parent Plot Obs ID ** 
24 24
Sample Method ID,,** No join mapping for *Sample Method ID ** 
inputs/NVS/TaxonOccurrence/VegBIEN.csv
17 17
Species Name,/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,
18 18
Species Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
19 19
Taxon Obs Note,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
20
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
20
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
22 22
Herbivore,,** No join mapping for *Herbivore ** 
23 23
Method Name,,** No join mapping for *Method Name ** 
24 24
Severity,,** No join mapping for *Severity ** 
inputs/NVS/StemObservation/VegBIEN.csv
29 29
Species Name,"/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",
30 30
Species Name,/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,
31 31
Species Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
32
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
33
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
32
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
33
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
34 34
Alive State,,** No join mapping for *Alive State ** 
35 35
Association,,** No join mapping for *Association ** 
36 36
Association No,,** No join mapping for *Association No ** 
inputs/NVS/Plot/VegBIEN.csv
16 16
Sub Plot,"/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",
17 17
Plot,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
18 18
Slope,/location/slopeaspect_deg/_alt/1/_compass/value,
19
Plot ID,/location/sourceaccessioncode,
20
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
19
Plot ID,/location/sourceaccessioncode/_first/1,
20
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
21
Sub Plot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
22 22
Altitude Units,,** No join mapping for *Altitude Units ** 
23 23
Area Units,,** No join mapping for *Area Units ** 
24 24
Aspect,,** No join mapping for *Aspect ** 
inputs/VegBank/observation_/VegBIEN.csv
29 29
authorobscode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
30 30
observation_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
31 31
plot_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
32
plot_id,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
33
plot_id,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
32
plot_id,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
33
plot_id,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
34 34
accessioncode,,** No join mapping for *accessioncode ** 
35 35
autotaxoncover,,** No join mapping for *autotaxoncover ** 
36 36
basalarea,,** No join mapping for *basalarea ** 
inputs/VegBank/plot_/VegBIEN.csv
39 39
slopegradient,/location/slopegradient_fraction/_alt/1,
40 40
minslopegradient,/location/slopegradient_fraction/_alt/2/_avg/1,
41 41
maxslopegradient,/location/slopegradient_fraction/_alt/2/_avg/2,
42
plot_id,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
43
plot_id,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
42
plot_id,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
43
plot_id,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
44 44
Geographic Name,,** No join mapping for *Geographic Name ** 
45 45
accessioncode,,** No join mapping for *accessioncode ** 
46 46
authordatum,,** No join mapping for *authordatum ** 
mappings/VegCore-VegBIEN.csv
381 381
slopeGradient,/location/slopegradient_fraction/_alt/1,
382 382
minSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/1,
383 383
maxSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/2,
384
subplotID,/location/sourceaccessioncode,
385
locationID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
386
subplot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
387
locationID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
388
subplot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
384
subplotID,/location/sourceaccessioncode/_first/1,
385
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
386
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
387
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
388
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
389 389
subplotX,/location/sublocationxposition_m,
390 390
subplotY,/location/sublocationyposition_m,
391 391
verbatimElevation,/location/verbatimelevation,

Also available in: Unified diff