Project

General

Profile

« Previous | Next » 

Revision 7218

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/Madidi/: Refreshed. Note that new export has a completely new schema.

View differences:

inputs/Madidi/IndividualObservation/map.csv
1 
Madidi,VegCore,Filter,Comments
2 
PlotID,locationID,,
3 
PlotName,locationName,,
4 
OrientationXDegrees,*OrientationXDegrees,,
5 
OrientationYDegrees,*OrientationYDegrees,,
6 
Sequence,subplot,,
7 
SubplotX,subplotX,,
8 
SubplotY,subplotY,,
9 
PlotInventoryName,fieldNumber,,
10 
Tree,individualCode,,
11 
Trunk,authorStemCode,,
12 
Tag,tag,,
13 
WasCollected,*WasCollected,,
14 
SpecimenID,catalogNumber,,
15 
SeniorCollector,recordedBy,/_first/1/_merge/1,
16 
CollectorString,recordedBy,/_first/1/_merge/2,
17 
CollectorStringShortened,recordedBy,/_first/2,
18 
CollectionNumber,*CollectionNumber,,
19 
Institutions,institutionCode,,
20 
InstitutionString,*InstitutionString,,
21 
CollectorAbbrev,recordedBy,/_first/3,
22 
CurrentDet,scientificName,,
23 
CurrentDetRank,taxonRank,,
24 
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
25 
CurrentDetQualifier,identificationQualifier,,
26 
RepresentativeSpecimenID,*RepresentativeSpecimenID,,
27 
RepresentativeSpecimenSeniorCollector,*RepresentativeSpecimenSeniorCollector,,
28 
RepresentativeCollectionNumber,*RepresentativeCollectionNumber,,
29 
RepresentativeSpecimenCollectorAbbreviation,*RepresentativeSpecimenCollectorAbbreviation,,
30 
FieldFamilyFullName,originalFamily,,
31 
FieldFamilyFullName,family,,
32 
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
33 
FieldNameFullName,originalTaxonName,,
34 
FieldNameAuthors,originalScientificNameAuthorship,,
35 
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
36 
MorphoSpeciesName,morphoname,,
37 
CommonName,*CommonName,,
38 
Circumference,*Circumference,,
39 
Diameter,diameterBreastHeight_cm,,
40 
TotalHeight,height_m,,
41 
BoleHeight,*BoleHeight,,
42 
Phenology1,*Phenology1,,
43 
Phenology2,*Phenology2,,
44 
Phenology3,*Phenology3,,
45 
Phenology4,*Phenology4,,
46 
CrownPositionName,*CrownPositionName,,
47 
CrownShapeName,*CrownShapeName,,
48 
LianaPresenceName,*LianaPresenceName,,
49 
SubplotX2,*SubplotX2,,
50 
SubplotY2,*SubplotY2,,
51 
HabitName,growthForm,,
52 
TreeNotes,fieldNotes,,
53 
DNASample,*DNASample,,
54 
IsAlive,*IsAlive,,
55 
CompoundLeaf,UNUSED,,
56 
CompoundLeafID,UNUSED,,
57 
NumberFolioles1,UNUSED,,
58 
NumberFolioles2,UNUSED,,
59 
NumberFolioles3,UNUSED,,
60 
NumberFolioles4,UNUSED,,
61 
NumberFolioles5,UNUSED,,
62 
SLAArea1,UNUSED,,
63 
SLAArea2,UNUSED,,
64 
SLAArea3,UNUSED,,
65 
SLAArea4,UNUSED,,
66 
SLAArea5,UNUSED,,
67 
SLAArea6,UNUSED,,
68 
SLAArea7,UNUSED,,
69 
SLAArea8,UNUSED,,
70 
SLAArea9,UNUSED,,
71 
SLAArea10,UNUSED,,
72 
SLAArea11,UNUSED,,
73 
SLAArea12,UNUSED,,
74 
SLAArea13,UNUSED,,
75 
SLAArea14,UNUSED,,
76 
SLAArea15,UNUSED,,
77 
NumberFoliolules1,UNUSED,,
78 
NumberFoliolules2,UNUSED,,
79 
NumberFoliolules3,UNUSED,,
80 
NumberFoliolules4,UNUSED,,
81 
NumberFoliolules5,UNUSED,,
82 
TotArea1,UNUSED,,
83 
TotArea2,UNUSED,,
84 
TotArea3,UNUSED,,
85 
TotArea4,UNUSED,,
86 
TotArea5,UNUSED,,
87 
TotArea6,UNUSED,,
88 
TotArea7,UNUSED,,
89 
TotArea8,UNUSED,,
90 
TotArea9,UNUSED,,
91 
TotArea10,UNUSED,,
92 
TotArea11,UNUSED,,
93 
TotArea12,UNUSED,,
94 
TotArea13,UNUSED,,
95 
TotArea14,UNUSED,,
96 
TotArea15,UNUSED,,
97 
Weight1,UNUSED,,
98 
Weight2,UNUSED,,
99 
Weight3,UNUSED,,
100 
Weight4,UNUSED,,
101 
Weight5,UNUSED,,
102 
Weight6,UNUSED,,
103 
Weight7,UNUSED,,
104 
Weight8,UNUSED,,
105 
Weight9,UNUSED,,
106 
Weight10,UNUSED,,
107 
Weight11,UNUSED,,
108 
Weight12,UNUSED,,
109 
Weight13,UNUSED,,
110 
Weight14,UNUSED,,
111 
Weight15,UNUSED,,
112 
Thickness1,UNUSED,,
113 
Thickness2,UNUSED,,
114 
Thickness3,UNUSED,,
115 
Thickness4,UNUSED,,
116 
Thickness5,UNUSED,,
117 
Thickness6,UNUSED,,
118 
Thickness7,UNUSED,,
119 
Thickness8,UNUSED,,
120 
Thickness9,UNUSED,,
121 
Thickness10,UNUSED,,
122 
Thickness11,UNUSED,,
123 
Thickness12,UNUSED,,
124 
Thickness13,UNUSED,,
125 
Thickness14,UNUSED,,
126 
Thickness15,UNUSED,,
127 
LeafPhoto1,UNUSED,,
128 
LeafPhoto2,UNUSED,,
129 
LeafPhoto3,UNUSED,,
130 
LeafPhoto4,UNUSED,,
131 
LeafPhoto5,UNUSED,,
132 
NitrogenContent,UNUSED,,
133 
TreeLeaf3Notes,UNUSED,,
134 
AreaRachis1,UNUSED,,
135 
AreaRachis2,UNUSED,,
136 
AreaRachis3,UNUSED,,
137 
AreaRachis4,UNUSED,,
138 
AreaRachis5,UNUSED,,
139 
WeightRachis1,UNUSED,,
140 
WeightRachis2,UNUSED,,
141 
WeightRachis3,UNUSED,,
142 
WeightRachis4,UNUSED,,
143 
WeightRachis5,UNUSED,,
144 
RachisPhoto1,UNUSED,,
145 
RachisPhoto2,UNUSED,,
146 
RachisPhoto3,UNUSED,,
147 
RachisPhoto4,UNUSED,,
148 
RachisPhoto5,UNUSED,,
149 
DiameterWithBark,UNUSED,,
150 
DiameterWithoutBark,UNUSED,,
151 
Volume1,UNUSED,,
152 
Volume2,UNUSED,,
153 
DryWeight,UNUSED,,
154 
VesselNumber,UNUSED,,
155 
VesselArea,UNUSED,,
156 
NumberOfLeaves,UNUSED,,
157 
WeightOfBranch,UNUSED,,
158 
AreaRachilla1,UNUSED,,
159 
AreaRachilla2,UNUSED,,
160 
AreaRachilla3,UNUSED,,
161 
AreaRachilla4,UNUSED,,
162 
AreaRachilla5,UNUSED,,
163 
WeightRachilla1,UNUSED,,
164 
WeightRachilla2,UNUSED,,
165 
WeightRachilla3,UNUSED,,
166 
WeightRachilla4,UNUSED,,
167 
WeightRachilla5,UNUSED,,
168 
TreeTrunkNotes,UNUSED,,
169 
RemainingTrunkHeight,UNUSED,,
170 
HeightButtresses,UNUSED,,
171 
WidthButtresses,UNUSED,,
172 
DirectionOfFall,UNUSED,,
173 
MortalityType,UNUSED,,
174 
CauseOfDeath1,UNUSED,,
175 
CauseOfDeath2,UNUSED,,
176 
CauseOfDeath3,UNUSED,,
177 
CauseOfDeath4,UNUSED,,
178 
CauseOfDeath5,UNUSED,,
179 
Decomposition,UNUSED,,
180 
MultipleFalls,UNUSED,,
181 
TreeMortalityNotes,UNUSED,,
inputs/Madidi/IndividualObservation/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>Madidi</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <parent_id>
11 
                            <location>
12 
                                <authorlocationcode>$PlotName</authorlocationcode>
13 
                                <sourceaccessioncode>$PlotID</sourceaccessioncode>
14 
                            </location>
15 
                        </parent_id>
16 
                        <authorlocationcode>$Sequence</authorlocationcode>
17 
                        <locationevent>
18 
                            <parent_id>
19 
                                <locationevent>
20 
                                    <location_id>
21 
                                        <location>
22 
                                            <authorlocationcode>
23 
                                                <_if name="if subplot">
24 
                                                    <cond>$Sequence</cond>
25 
                                                    <then>$PlotName</then>
26 
                                                </_if>
27 
                                            </authorlocationcode>
28 
                                            <sourceaccessioncode>
29 
                                                <_if name="if subplot">
30 
                                                    <cond>$Sequence</cond>
31 
                                                    <then>$PlotID</then>
32 
                                                </_if>
33 
                                            </sourceaccessioncode>
34 
                                        </location>
35 
                                    </location_id>
36 
                                    <authoreventcode>$PlotInventoryName</authoreventcode>
37 
                                </locationevent>
38 
                            </parent_id>
39 
                            <taxonoccurrence>
40 
                                <aggregateoccurrence>
41 
                                    <notes>$TreeNotes</notes>
42 
                                    <plantobservation>
43 
                                        <authorplantcode>$Tree</authorplantcode>
44 
                                        <specimenreplicate>
45 
                                            <catalognumber_dwc>$SpecimenID</catalognumber_dwc>
46 
                                            <institution_id>
47 
                                                <sourcelist>
48 
                                                    <name>$Institutions</name>
49 
                                                    <sourcename>
50 
                                                        <name>
51 
                                                            <_split>
52 
                                                                <separator>, </separator>
53 
                                                                <value>$Institutions</value>
54 
                                                            </_split>
55 
                                                        </name>
56 
                                                    </sourcename>
57 
                                                </sourcelist>
58 
                                            </institution_id>
59 
                                        </specimenreplicate>
60 
                                        <stemobservation>
61 
                                            <authorstemcode>$Trunk</authorstemcode>
62 
                                            <diameterbreastheight_m><_cm_to_m><value>$Diameter</value></_cm_to_m></diameterbreastheight_m>
63 
                                            <height_m>$TotalHeight</height_m>
64 
                                            <tag>$Tag</tag>
65 
                                        </stemobservation>
66 
                                    </plantobservation>
67 
                                </aggregateoccurrence>
68 
                                <authortaxoncode>$Tree</authortaxoncode>
69 
                                <collector_id>
70 
                                    <party>
71 
                                        <fullname>
72 
                                            <_merge>
73 
                                                <1>$SeniorCollector</1>
74 
                                                <2>$CollectorString</2>
75 
                                            </_merge>
76 
                                        </fullname>
77 
                                    </party>
78 
                                </collector_id>
79 
                                <growthform>$HabitName</growthform>
80 
                                <taxondetermination>
81 
                                    <taxonverbatim_id>
82 
                                        <taxonverbatim>
83 
                                            <taxonlabel_id>
84 
                                                <taxonlabel>
85 
                                                    <parent_id>
86 
                                                        <taxonlabel>
87 
                                                            <rank>$CurrentDetRank</rank>
88 
                                                            <parent_id>
89 
                                                                <taxonlabel>
90 
                                                                    <rank>cultivar</rank>
91 
                                                                    <parent_id>
92 
                                                                        <taxonlabel>
93 
                                                                            <rank>forma</rank>
94 
                                                                            <parent_id>
95 
                                                                                <taxonlabel>
96 
                                                                                    <rank>variety</rank>
97 
                                                                                    <parent_id>
98 
                                                                                        <taxonlabel>
99 
                                                                                            <rank>subspecies</rank>
100 
                                                                                            <parent_id>
101 
                                                                                                <taxonlabel>
102 
                                                                                                    <rank>species</rank>
103 
                                                                                                    <parent_id>
104 
                                                                                                        <taxonlabel>
105 
                                                                                                            <rank>genus</rank>
106 
                                                                                                            <parent_id>
107 
                                                                                                                <taxonlabel>
108 
                                                                                                                    <rank>family</rank>
109 
                                                                                                                    <taxonepithet>$FieldFamilyFullName</taxonepithet>
110 
                                                                                                                </taxonlabel>
111 
                                                                                                            </parent_id>
112 
                                                                                                        </taxonlabel>
113 
                                                                                                    </parent_id>
114 
                                                                                                </taxonlabel>
115 
                                                                                            </parent_id>
116 
                                                                                        </taxonlabel>
117 
                                                                                    </parent_id>
118 
                                                                                </taxonlabel>
119 
                                                                            </parent_id>
120 
                                                                        </taxonlabel>
121 
                                                                    </parent_id>
122 
                                                                </taxonlabel>
123 
                                                            </parent_id>
124 
                                                        </taxonlabel>
125 
                                                    </parent_id>
126 
                                                    <rank>$CurrentDetRank</rank>
127 
                                                    <taxonomicname>
128 
                                                        <_merge_prefix>
129 
                                                            <prefix><_taxon_family_require_std><family>$FieldFamilyFullName</family></_taxon_family_require_std></prefix>
130 
                                                            <value>$CurrentDet</value>
131 
                                                        </_merge_prefix>
132 
                                                    </taxonomicname>
133 
                                                </taxonlabel>
134 
                                            </taxonlabel_id>
135 
                                            <family>$FieldFamilyFullName</family>
136 
                                            <taxonomicname>$CurrentDet</taxonomicname>
137 
                                            <verbatimrank>$CurrentDetRank</verbatimrank>
138 
                                        </taxonverbatim>
139 
                                    </taxonverbatim_id>
140 
                                    <taxonfit>$CurrentDetQualifier</taxonfit>
141 
                                </taxondetermination>
142 
                                <taxondetermination>
143 
                                    <isoriginal>true</isoriginal>
144 
                                    <taxonverbatim_id>
145 
                                        <taxonverbatim>
146 
                                            <author>$FieldNameAuthors</author>
147 
                                            <family>$FieldFamilyFullName</family>
148 
                                            <morphoname>$MorphoSpeciesName</morphoname>
149 
                                            <taxonname>$FieldNameFullName</taxonname>
150 
                                        </taxonverbatim>
151 
                                    </taxonverbatim_id>
152 
                                </taxondetermination>
153 
                            </taxonoccurrence>
154 
                        </locationevent>
155 
                        <sourceaccessioncode>
156 
                            <_join>
157 
                                <1>$PlotID</1>
158 
                                <2>$Sequence</2>
159 
                            </_join>
160 
                        </sourceaccessioncode>
161 
                        <sublocationxposition_m>$SubplotX</sublocationxposition_m>
162 
                        <sublocationyposition_m>$SubplotY</sublocationyposition_m>
163 
                    </location>
164 
                </path>
165 
            </_simplifyPath>
166 
        </path>
167 
    </_setDefault>
168 
</VegBIEN>
169 
Inserted 28 new rows into database
inputs/Madidi/IndividualObservation/VegBIEN.csv
1 
Madidi,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
SpecimenID,"/_if[@name=""if specimen""]/cond/_exists",
3 
Institutions,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",
4 
Sequence,"/location/_if[@name=""if subplot""]/cond/_exists",
5 
PlotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
6 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
7 
PlotInventoryName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
8 
SpecimenID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
9 
SpecimenID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
10 
Institutions,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",
11 
SpecimenID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
12 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
13 
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
14 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
15 
Sequence,/location/authorlocationcode,
16 
Sequence,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
17 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
18 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
19 
Sequence,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2",
20 
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
21 
Sequence,"/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",
22 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
23 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",
24 
TreeNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
25 
Tree,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,
26 
SpecimenID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
27 
SpecimenID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
28 
Institutions,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
29 
Institutions,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
30 
Trunk,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
31 
Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,
32 
TotalHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,
33 
Tag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,
34 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
35 
PlotInventoryName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
36 
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
37 
Tree,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",
38 
Tag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
39 
FieldNameFullName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/1",
40 
CurrentDet,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
41 
SeniorCollector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_first/1/_merge/1,
42 
CollectorString,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_first/1/_merge/2,
43 
CollectorStringShortened,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_first/2,
44 
CollectorAbbrev,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_first/3,
45 
HabitName,/location/locationevent/taxonoccurrence/growthform,
46 
CurrentDetRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
47 
FieldFamilyFullName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
48 
FieldFamilyFullName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
49 
CurrentDetRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
50 
CurrentDetRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",
51 
FieldFamilyFullName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,
52 
CurrentDet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,
53 
CurrentDetRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
54 
FieldFamilyFullName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
55 
CurrentDet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,
56 
CurrentDetRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
57 
CurrentDetQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
58 
FieldNameAuthors,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/author,
59 
FieldFamilyFullName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family,
60 
MorphoSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/morphoname,
61 
FieldNameFullName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname,
62 
SpecimenID,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
63 
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
64 
Sequence,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
65 
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
66 
Sequence,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
67 
SubplotX,/location/sublocationxposition_m,
68 
SubplotY,/location/sublocationyposition_m,
69 
AreaRachilla1,,** No non-empty join mapping for UNUSED **
70 
AreaRachilla2,,** No non-empty join mapping for UNUSED **
71 
AreaRachilla3,,** No non-empty join mapping for UNUSED **
72 
AreaRachilla4,,** No non-empty join mapping for UNUSED **
73 
AreaRachilla5,,** No non-empty join mapping for UNUSED **
74 
AreaRachis1,,** No non-empty join mapping for UNUSED **
75 
AreaRachis2,,** No non-empty join mapping for UNUSED **
76 
AreaRachis3,,** No non-empty join mapping for UNUSED **
77 
AreaRachis4,,** No non-empty join mapping for UNUSED **
78 
AreaRachis5,,** No non-empty join mapping for UNUSED **
79 
BoleHeight,,** No join mapping for *BoleHeight **
80 
CauseOfDeath1,,** No non-empty join mapping for UNUSED **
81 
CauseOfDeath2,,** No non-empty join mapping for UNUSED **
82 
CauseOfDeath3,,** No non-empty join mapping for UNUSED **
83 
CauseOfDeath4,,** No non-empty join mapping for UNUSED **
84 
CauseOfDeath5,,** No non-empty join mapping for UNUSED **
85 
Circumference,,** No join mapping for *Circumference **
86 
CollectionNumber,,** No join mapping for *CollectionNumber **
87 
CommonName,,** No join mapping for *CommonName **
88 
CompoundLeaf,,** No non-empty join mapping for UNUSED **
89 
CompoundLeafID,,** No non-empty join mapping for UNUSED **
90 
CrownPositionName,,** No join mapping for *CrownPositionName **
91 
CrownShapeName,,** No join mapping for *CrownShapeName **
92 
CurrentDetFamily,,"** No non-empty join mapping for OMIT ** Omitted because includes *family* author, which TNRS can’t handle"
93 
DNASample,,** No join mapping for *DNASample **
94 
Decomposition,,** No non-empty join mapping for UNUSED **
95 
DiameterWithBark,,** No non-empty join mapping for UNUSED **
96 
DiameterWithoutBark,,** No non-empty join mapping for UNUSED **
97 
DirectionOfFall,,** No non-empty join mapping for UNUSED **
98 
DryWeight,,** No non-empty join mapping for UNUSED **
99 
FieldFamilyHTML,,"** No non-empty join mapping for OMIT ** Omitted because includes *family* author, which TNRS can’t handle"
100 
FieldNameHTML,,** No non-empty join mapping for OMIT ** Adds HTML formatting to FieldNameFullName+FieldNameAuthors
101 
HeightButtresses,,** No non-empty join mapping for UNUSED **
102 
InstitutionString,,** No join mapping for *InstitutionString **
103 
IsAlive,,** No join mapping for *IsAlive **
104 
LeafPhoto1,,** No non-empty join mapping for UNUSED **
105 
LeafPhoto2,,** No non-empty join mapping for UNUSED **
106 
LeafPhoto3,,** No non-empty join mapping for UNUSED **
107 
LeafPhoto4,,** No non-empty join mapping for UNUSED **
108 
LeafPhoto5,,** No non-empty join mapping for UNUSED **
109 
LianaPresenceName,,** No join mapping for *LianaPresenceName **
110 
MortalityType,,** No non-empty join mapping for UNUSED **
111 
MultipleFalls,,** No non-empty join mapping for UNUSED **
112 
NitrogenContent,,** No non-empty join mapping for UNUSED **
113 
NumberFolioles1,,** No non-empty join mapping for UNUSED **
114 
NumberFolioles2,,** No non-empty join mapping for UNUSED **
115 
NumberFolioles3,,** No non-empty join mapping for UNUSED **
116 
NumberFolioles4,,** No non-empty join mapping for UNUSED **
117 
NumberFolioles5,,** No non-empty join mapping for UNUSED **
118 
NumberFoliolules1,,** No non-empty join mapping for UNUSED **
119 
NumberFoliolules2,,** No non-empty join mapping for UNUSED **
120 
NumberFoliolules3,,** No non-empty join mapping for UNUSED **
121 
NumberFoliolules4,,** No non-empty join mapping for UNUSED **
122 
NumberFoliolules5,,** No non-empty join mapping for UNUSED **
123 
NumberOfLeaves,,** No non-empty join mapping for UNUSED **
124 
OrientationXDegrees,,** No join mapping for *OrientationXDegrees **
125 
OrientationYDegrees,,** No join mapping for *OrientationYDegrees **
126 
Phenology1,,** No join mapping for *Phenology1 **
127 
Phenology2,,** No join mapping for *Phenology2 **
128 
Phenology3,,** No join mapping for *Phenology3 **
129 
Phenology4,,** No join mapping for *Phenology4 **
130 
RachisPhoto1,,** No non-empty join mapping for UNUSED **
131 
RachisPhoto2,,** No non-empty join mapping for UNUSED **
132 
RachisPhoto3,,** No non-empty join mapping for UNUSED **
133 
RachisPhoto4,,** No non-empty join mapping for UNUSED **
134 
RachisPhoto5,,** No non-empty join mapping for UNUSED **
135 
RemainingTrunkHeight,,** No non-empty join mapping for UNUSED **
136 
RepresentativeCollectionNumber,,** No join mapping for *RepresentativeCollectionNumber **
137 
RepresentativeSpecimenCollectorAbbreviation,,** No join mapping for *RepresentativeSpecimenCollectorAbbreviation **
138 
RepresentativeSpecimenID,,** No join mapping for *RepresentativeSpecimenID **
139 
RepresentativeSpecimenSeniorCollector,,** No join mapping for *RepresentativeSpecimenSeniorCollector **
140 
SLAArea1,,** No non-empty join mapping for UNUSED **
141 
SLAArea10,,** No non-empty join mapping for UNUSED **
142 
SLAArea11,,** No non-empty join mapping for UNUSED **
143 
SLAArea12,,** No non-empty join mapping for UNUSED **
144 
SLAArea13,,** No non-empty join mapping for UNUSED **
145 
SLAArea14,,** No non-empty join mapping for UNUSED **
146 
SLAArea15,,** No non-empty join mapping for UNUSED **
147 
SLAArea2,,** No non-empty join mapping for UNUSED **
148 
SLAArea3,,** No non-empty join mapping for UNUSED **
149 
SLAArea4,,** No non-empty join mapping for UNUSED **
150 
SLAArea5,,** No non-empty join mapping for UNUSED **
151 
SLAArea6,,** No non-empty join mapping for UNUSED **
152 
SLAArea7,,** No non-empty join mapping for UNUSED **
153 
SLAArea8,,** No non-empty join mapping for UNUSED **
154 
SLAArea9,,** No non-empty join mapping for UNUSED **
155 
SubplotX2,,** No join mapping for *SubplotX2 **
156 
SubplotY2,,** No join mapping for *SubplotY2 **
157 
Thickness1,,** No non-empty join mapping for UNUSED **
158 
Thickness10,,** No non-empty join mapping for UNUSED **
159 
Thickness11,,** No non-empty join mapping for UNUSED **
160 
Thickness12,,** No non-empty join mapping for UNUSED **
161 
Thickness13,,** No non-empty join mapping for UNUSED **
162 
Thickness14,,** No non-empty join mapping for UNUSED **
163 
Thickness15,,** No non-empty join mapping for UNUSED **
164 
Thickness2,,** No non-empty join mapping for UNUSED **
165 
Thickness3,,** No non-empty join mapping for UNUSED **
166 
Thickness4,,** No non-empty join mapping for UNUSED **
167 
Thickness5,,** No non-empty join mapping for UNUSED **
168 
Thickness6,,** No non-empty join mapping for UNUSED **
169 
Thickness7,,** No non-empty join mapping for UNUSED **
170 
Thickness8,,** No non-empty join mapping for UNUSED **
171 
Thickness9,,** No non-empty join mapping for UNUSED **
172 
TotArea1,,** No non-empty join mapping for UNUSED **
173 
TotArea10,,** No non-empty join mapping for UNUSED **
174 
TotArea11,,** No non-empty join mapping for UNUSED **
175 
TotArea12,,** No non-empty join mapping for UNUSED **
176 
TotArea13,,** No non-empty join mapping for UNUSED **
177 
TotArea14,,** No non-empty join mapping for UNUSED **
178 
TotArea15,,** No non-empty join mapping for UNUSED **
179 
TotArea2,,** No non-empty join mapping for UNUSED **
180 
TotArea3,,** No non-empty join mapping for UNUSED **
181 
TotArea4,,** No non-empty join mapping for UNUSED **
182 
TotArea5,,** No non-empty join mapping for UNUSED **
183 
TotArea6,,** No non-empty join mapping for UNUSED **
184 
TotArea7,,** No non-empty join mapping for UNUSED **
185 
TotArea8,,** No non-empty join mapping for UNUSED **
186 
TotArea9,,** No non-empty join mapping for UNUSED **
187 
TreeLeaf3Notes,,** No non-empty join mapping for UNUSED **
188 
TreeMortalityNotes,,** No non-empty join mapping for UNUSED **
189 
TreeTrunkNotes,,** No non-empty join mapping for UNUSED **
190 
VesselArea,,** No non-empty join mapping for UNUSED **
191 
VesselNumber,,** No non-empty join mapping for UNUSED **
192 
Volume1,,** No non-empty join mapping for UNUSED **
193 
Volume2,,** No non-empty join mapping for UNUSED **
194 
WasCollected,,** No join mapping for *WasCollected **
195 
Weight1,,** No non-empty join mapping for UNUSED **
196 
Weight10,,** No non-empty join mapping for UNUSED **
197 
Weight11,,** No non-empty join mapping for UNUSED **
198 
Weight12,,** No non-empty join mapping for UNUSED **
199 
Weight13,,** No non-empty join mapping for UNUSED **
200 
Weight14,,** No non-empty join mapping for UNUSED **
201 
Weight15,,** No non-empty join mapping for UNUSED **
202 
Weight2,,** No non-empty join mapping for UNUSED **
203 
Weight3,,** No non-empty join mapping for UNUSED **
204 
Weight4,,** No non-empty join mapping for UNUSED **
205 
Weight5,,** No non-empty join mapping for UNUSED **
206 
Weight6,,** No non-empty join mapping for UNUSED **
207 
Weight7,,** No non-empty join mapping for UNUSED **
208 
Weight8,,** No non-empty join mapping for UNUSED **
209 
Weight9,,** No non-empty join mapping for UNUSED **
210 
WeightOfBranch,,** No non-empty join mapping for UNUSED **
211 
WeightRachilla1,,** No non-empty join mapping for UNUSED **
212 
WeightRachilla2,,** No non-empty join mapping for UNUSED **
213 
WeightRachilla3,,** No non-empty join mapping for UNUSED **
214 
WeightRachilla4,,** No non-empty join mapping for UNUSED **
215 
WeightRachilla5,,** No non-empty join mapping for UNUSED **
216 
WeightRachis1,,** No non-empty join mapping for UNUSED **
217 
WeightRachis2,,** No non-empty join mapping for UNUSED **
218 
WeightRachis3,,** No non-empty join mapping for UNUSED **
219 
WeightRachis4,,** No non-empty join mapping for UNUSED **
220 
WeightRachis5,,** No non-empty join mapping for UNUSED **
221 
WidthButtresses,,** No non-empty join mapping for UNUSED **
inputs/Madidi/IndividualObservation/+header.dat
1 
!PlotID	PlotName	OrientationXDegrees	OrientationYDegrees	Sequence	SubplotX	SubplotY	PlotInventoryName	Tree	Trunk	Tag	WasCollected	SpecimenID	SeniorCollector	CollectorString	CollectorStringShortened	CollectionNumber	Institutions	InstitutionString	CollectorAbbrev	CurrentDet	CurrentDetRank	CurrentDetFamily	CurrentDetQualifier	RepresentativeSpecimenID	RepresentativeSpecimenSeniorCollector	RepresentativeCollectionNumber	RepresentativeSpecimenCollectorAbbreviation	FieldFamilyFullName	FieldFamilyHTML	FieldNameFullName	FieldNameAuthors	FieldNameHTML	MorphoSpeciesName	CommonName	Circumference	Diameter	TotalHeight	BoleHeight	Phenology1	Phenology2	Phenology3	Phenology4	CrownPositionName	CrownShapeName	LianaPresenceName	SubplotX2	SubplotY2	HabitName	TreeNotes	DNASample	IsAlive	CompoundLeaf	CompoundLeafID	NumberFolioles1	NumberFolioles2	NumberFolioles3	NumberFolioles4	NumberFolioles5	SLAArea1	SLAArea2	SLAArea3	SLAArea4	SLAArea5	SLAArea6	SLAArea7	SLAArea8	SLAArea9	SLAArea10	SLAArea11	SLAArea12	SLAArea13	SLAArea14	SLAArea15	NumberFoliolules1	NumberFoliolules2	NumberFoliolules3	NumberFoliolules4	NumberFoliolules5	TotArea1	TotArea2	TotArea3	TotArea4	TotArea5	TotArea6	TotArea7	TotArea8	TotArea9	TotArea10	TotArea11	TotArea12	TotArea13	TotArea14	TotArea15	Weight1	Weight2	Weight3	Weight4	Weight5	Weight6	Weight7	Weight8	Weight9	Weight10	Weight11	Weight12	Weight13	Weight14	Weight15	Thickness1	Thickness2	Thickness3	Thickness4	Thickness5	Thickness6	Thickness7	Thickness8	Thickness9	Thickness10	Thickness11	Thickness12	Thickness13	Thickness14	Thickness15	LeafPhoto1	LeafPhoto2	LeafPhoto3	LeafPhoto4	LeafPhoto5	NitrogenContent	TreeLeaf3Notes	AreaRachis1	AreaRachis2	AreaRachis3	AreaRachis4	AreaRachis5	WeightRachis1	WeightRachis2	WeightRachis3	WeightRachis4	WeightRachis5	RachisPhoto1	RachisPhoto2	RachisPhoto3	RachisPhoto4	RachisPhoto5	DiameterWithBark	DiameterWithoutBark	Volume1	Volume2	DryWeight	VesselNumber	VesselArea	NumberOfLeaves	WeightOfBranch	AreaRachilla1	AreaRachilla2	AreaRachilla3	AreaRachilla4	AreaRachilla5	WeightRachilla1	WeightRachilla2	WeightRachilla3	WeightRachilla4	WeightRachilla5	TreeTrunkNotes	RemainingTrunkHeight	HeightButtresses	WidthButtresses	DirectionOfFall	MortalityType	CauseOfDeath1	CauseOfDeath2	CauseOfDeath3	CauseOfDeath4	CauseOfDeath5	Decomposition	MultipleFalls	TreeMortalityNotes
inputs/Madidi/IndividualObservation/unmapped_terms.csv
1 
*OrientationXDegrees
2 
*OrientationYDegrees
3 
*WasCollected
4 
*CollectionNumber
5 
*InstitutionString
6 
*RepresentativeSpecimenID
7 
*RepresentativeSpecimenSeniorCollector
8 
*RepresentativeCollectionNumber
9 
*RepresentativeSpecimenCollectorAbbreviation
10 
*CommonName
11 
*Circumference
12 
*BoleHeight
13 
*Phenology1
14 
*Phenology2
15 
*Phenology3
16 
*Phenology4
17 
*CrownPositionName
18 
*CrownShapeName
19 
*LianaPresenceName
20 
*SubplotX2
21 
*SubplotY2
22 
*DNASample
23 
*IsAlive
inputs/Madidi/IndividualObservation/new_terms.csv
1 
Sequence,subplot,,
2 
PlotInventoryName,fieldNumber,,
3 
Tree,individualCode,,
4 
Trunk,authorStemCode,,
5 
SpecimenID,catalogNumber,,
6 
SeniorCollector,recordedBy,/_first/1/_merge/1,
7 
CollectorString,recordedBy,/_first/1/_merge/2,
8 
CollectorStringShortened,recordedBy,/_first/2,
9 
Institutions,institutionCode,,
10 
CollectorAbbrev,recordedBy,/_first/3,
11 
CurrentDet,scientificName,,
12 
CurrentDetRank,taxonRank,,
13 
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
14 
CurrentDetQualifier,identificationQualifier,,
15 
FieldFamilyFullName,originalFamily,,
16 
FieldFamilyFullName,family,,
17 
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
18 
FieldNameFullName,originalTaxonName,,
19 
FieldNameAuthors,originalScientificNameAuthorship,,
20 
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
21 
MorphoSpeciesName,morphoname,,
22 
Diameter,diameterBreastHeight_cm,,
23 
TotalHeight,height_m,,
24 
HabitName,growthForm,,
25 
TreeNotes,fieldNotes,,
inputs/Madidi/LocationObservation/map.csv
1 
Madidi,VegCore,Filter,Comments
2 
PlotID,locationID,/_first/2,
3 
PlotName,locationID,/_first/1,
4 
PlotInventoryName,fieldNumber,,
5 
LatitudeDecDeg,decimalLatitude,,
6 
LongitudeDecDeg,decimalLongitude,,
7 
Total Nitrogen,nitrogen_percent,,Assuming units are % based on the range of values
8 
Organic Carbon,carbon_percent,,Assuming units are % based on the range of values
9 
Organic material,organic_percent,,Assuming units are % based on the range of values
10 
Available Phosphor,phosphorus_percent,,Assuming units are % based on the range of values
11 
Interchangeable Sodium,sodium_percent,,Assuming units are % based on the range of values
12 
Interchangeable Potassium,potassium_percent,,Assuming units are % based on the range of values
13 
Interchangable Calcium,calcium_percent,,Assuming units are % based on the range of values
14 
Electric conductivity,conductivity,,
15 
pH disolved,ph,,
16 
Other epilocs,*Other epilocs,,
17 
Political Location,*Political Location,,
18 
Slope,slopeGradient,,
19 
Plot Compass Direction,*Plot Compass Direction,,
20 
Locality Description,*Locality Description,,
21 
Locality,locality,,
22 
Topographic location,*Topographic location,,
23 
Vegetation Type,communityID,,
24 
Number of Trunks,*Number of Trunks,,
25 
Number of Trees,*Number of Trees,,
26 
Other Epilocs (OLD),*Other Epilocs (OLD),,
27 
Collaborators (OLD),*Collaborators (OLD),,
28 
Installed and evaluated by (OLD),*Installed and evaluated by (OLD),,
29 
Plot Name,locationName,,
30 
Local Plot Number,*Local Plot Number,,
31 
Expedition Name,projectName,,
32 
Expedition Number,projectID,,
33 
Funding agency,*Funding agency,,
34 
Collaborators,*Collaborators,,
35 
Installed and evaluated by,*Installed and evaluated by,,
36 
Notes,plotNotes,,
37 
Interchangeable Magnesium,magnesium_percent,,Assuming units are % based on the range of values
38 
Interchangeable Acidity,acidity_percent,,Assuming units are % based on the range of values
39 
CIC,cationExchangeCapacity_cmol_kg,,
40 
Sand,sand_percent,,Assuming units are % based on the range of values
41 
Silt,silt_percent,,Assuming units are % based on the range of values
42 
Clay,clay_percent,,Assuming units are % based on the range of values
43 
Textural Class,texture,,
44 
Notes 2,plotNotes,,
45 
Textural Class (select),*Textural Class (select),,
46 
Qualifier Available Phosphor,*Qualifier Available Phosphor,,
47 
Qualifier Interchangeable Calcium,*Qualifier Interchangeable Calcium,,
48 
Qualifier Interchangeable Acidity,*Qualifier Interchangeable Acidity,,
inputs/Madidi/LocationObservation/VegBIEN.csv
1 
Madidi,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
Plot Name,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 
PlotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists/_first/1",
4 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists/_first/2",
5 
PlotInventoryName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
6 
PlotName,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else/_first/1",
7 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else/_first/2",
8 
Plot Name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
9 
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode/_first/1",
10 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode/_first/2",
11 
Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
12 
Expedition Name,/location/locationevent/*_id/project/projectname,
13 
Expedition Number,/location/locationevent/*_id/project/sourceaccessioncode,
14 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
15 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
16 
Plot Name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
17 
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then/_first/1",
18 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then/_first/2",
19 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",
20 
Vegetation Type,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
21 
Interchangeable Acidity,/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
22 
Interchangable Calcium,/location/locationevent/soilsample/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
23 
Organic Carbon,/location/locationevent/soilsample/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
24 
CIC,/location/locationevent/soilsample/cationexchangecapacity_cmol_kg,
25 
Clay,/location/locationevent/soilsample/clay_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
26 
Electric conductivity,/location/locationevent/soilsample/conductivity,
27 
Interchangeable Magnesium,/location/locationevent/soilsample/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
28 
Total Nitrogen,/location/locationevent/soilsample/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
29 
Organic material,/location/locationevent/soilsample/organic_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
30 
pH disolved,/location/locationevent/soilsample/ph,
31 
Available Phosphor,/location/locationevent/soilsample/phosphorus_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
32 
Interchangeable Potassium,/location/locationevent/soilsample/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
33 
Sand,/location/locationevent/soilsample/sand_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
34 
Silt,/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
35 
Interchangeable Sodium,/location/locationevent/soilsample/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
36 
Textural Class,/location/locationevent/soilsample/texture,
37 
Plot Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
38 
PlotInventoryName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
39 
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists/_first/1",
40 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists/_first/2",
41 
Locality,/location/locationnarrative/_merge/1,
42 
LatitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
43 
LongitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
44 
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"
45 
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"
46 
Notes,/location/notespublic,
47 
Notes 2,/location/notespublic,
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",
53 
Collaborators,,** No join mapping for *Collaborators **
54 
Collaborators (OLD),,** No join mapping for *Collaborators (OLD) **
55 
Funding agency,,** No join mapping for *Funding agency **
56 
Installed and evaluated by,,** No join mapping for *Installed and evaluated by **
57 
Installed and evaluated by (OLD),,** No join mapping for *Installed and evaluated by (OLD) **
58 
Local Plot Number,,** No join mapping for *Local Plot Number **
59 
Locality Description,,** No join mapping for *Locality Description **
60 
Number of Trees,,** No join mapping for *Number of Trees **
61 
Number of Trunks,,** No join mapping for *Number of Trunks **
62 
Other Epilocs (OLD),,** No join mapping for *Other Epilocs (OLD) **
63 
Other epilocs,,** No join mapping for *Other epilocs **
64 
Plot Compass Direction,,** No join mapping for *Plot Compass Direction **
65 
Political Location,,** No join mapping for *Political Location **
66 
Qualifier Available Phosphor,,** No join mapping for *Qualifier Available Phosphor **
67 
Qualifier Interchangeable Acidity,,** No join mapping for *Qualifier Interchangeable Acidity **
68 
Qualifier Interchangeable Calcium,,** No join mapping for *Qualifier Interchangeable Calcium **
69 
Textural Class (select),,** No join mapping for *Textural Class (select) **
70 
Topographic location,,** No join mapping for *Topographic location **
inputs/Madidi/LocationObservation/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>Madidi</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <authorlocationcode>$Plot Name</authorlocationcode>
11 
                        <sourceaccessioncode>$PlotName</sourceaccessioncode>
12 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$Locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
13 
                        <locationevent>
14 
                            <project_id>
15 
                                <project>
16 
                                    <projectname>$Expedition Name</projectname>
17 
                                    <sourceaccessioncode>$Expedition Number</sourceaccessioncode>
18 
                                </project>
19 
                            </project_id>
20 
                            <authoreventcode>$PlotInventoryName</authoreventcode>
21 
                            <commclass><commdetermination><commconcept_id><commconcept><commname_id><commname><commname>$Vegetation Type</commname></commname></commname_id></commconcept></commconcept_id></commdetermination></commclass>
22 
                            <soilsample>
23 
                                <acidity_fraction><_percent_to_fraction><value>$Interchangeable Acidity</value></_percent_to_fraction></acidity_fraction>
24 
                                <calcium_fraction><_percent_to_fraction><value>$Interchangable Calcium</value></_percent_to_fraction></calcium_fraction>
25 
                                <carbon_fraction><_percent_to_fraction><value>$Organic Carbon</value></_percent_to_fraction></carbon_fraction>
26 
                                <cationexchangecapacity_cmol_kg>$CIC</cationexchangecapacity_cmol_kg>
27 
                                <clay_fraction><_percent_to_fraction><value>$Clay</value></_percent_to_fraction></clay_fraction>
28 
                                <conductivity>$Electric conductivity</conductivity>
29 
                                <magnesium_fraction><_percent_to_fraction><value>$Interchangeable Magnesium</value></_percent_to_fraction></magnesium_fraction>
30 
                                <nitrogen_fraction><_percent_to_fraction><value>$Total Nitrogen</value></_percent_to_fraction></nitrogen_fraction>
31 
                                <organic_fraction><_percent_to_fraction><value>$Organic material</value></_percent_to_fraction></organic_fraction>
32 
                                <ph>$pH disolved</ph>
33 
                                <phosphorus_fraction><_percent_to_fraction><value>$Available Phosphor</value></_percent_to_fraction></phosphorus_fraction>
34 
                                <potassium_fraction><_percent_to_fraction><value>$Interchangeable Potassium</value></_percent_to_fraction></potassium_fraction>
35 
                                <sand_fraction><_percent_to_fraction><value>$Sand</value></_percent_to_fraction></sand_fraction>
36 
                                <silt_fraction><_percent_to_fraction><value>$Silt</value></_percent_to_fraction></silt_fraction>
37 
                                <sodium_fraction><_percent_to_fraction><value>$Interchangeable Sodium</value></_percent_to_fraction></sodium_fraction>
38 
                                <texture>$Textural Class</texture>
39 
                            </soilsample>
40 
                        </locationevent>
41 
                        <locationnarrative>$Locality</locationnarrative>
42 
                        <locationplace>
43 
                            <place_id>
44 
                                <place>
45 
                                    <coordinates_id>
46 
                                        <coordinates>
47 
                                            <latitude_deg>
48 
                                                <_nullIf>
49 
                                                    <null>0</null>
50 
                                                    <type>float</type>
51 
                                                    <value>$LatitudeDecDeg</value>
52 
                                                </_nullIf>
53 
                                            </latitude_deg>
54 
                                            <longitude_deg>
55 
                                                <_nullIf>
56 
                                                    <null>0</null>
57 
                                                    <type>float</type>
58 
                                                    <value>$LongitudeDecDeg</value>
59 
                                                </_nullIf>
60 
                                            </longitude_deg>
61 
                                        </coordinates>
62 
                                    </coordinates_id>
63 
                                    <matched_place_id>
64 
                                        <place>
65 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
66 
                                            <coordinates_id>
67 
                                                <coordinates>
68 
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
69 
                                                    <latitude_deg>
70 
                                                        <_nullIf>
71 
                                                            <null>0</null>
72 
                                                            <type>float</type>
73 
                                                            <value>$LatitudeDecDeg</value>
74 
                                                        </_nullIf>
75 
                                                    </latitude_deg>
76 
                                                    <longitude_deg>
77 
                                                        <_nullIf>
78 
                                                            <null>0</null>
79 
                                                            <type>float</type>
80 
                                                            <value>$LongitudeDecDeg</value>
81 
                                                        </_nullIf>
82 
                                                    </longitude_deg>
83 
                                                </coordinates>
84 
                                            </coordinates_id>
85 
                                        </place>
86 
                                    </matched_place_id>
87 
                                </place>
88 
                            </place_id>
89 
                        </locationplace>
90 
                        <notespublic>
91 
                            <_alt>
92 
                                <0>$Notes</0>
93 
                                <1>$Notes 2</1>
94 
                            </_alt>
95 
                        </notespublic>
96 
                        <slopegradient_fraction>$Slope</slopegradient_fraction>
97 
                    </location>
98 
                </path>
99 
            </_simplifyPath>
100 
        </path>
101 
    </_setDefault>
102 
</VegBIEN>
103 
Inserted 28 new rows into database
inputs/Madidi/LocationObservation/+header.dat
1 
!"PlotID"	"PlotName"	"PlotInventoryName"	"LatitudeDecDeg"	"LongitudeDecDeg"	"Total Nitrogen"	"Organic Carbon"	"Organic material"	"Available Phosphor"	"Interchangeable Sodium"	"Interchangeable Potassium"	"Interchangable Calcium"	"Electric conductivity"	"pH disolved"	"Other epilocs"	"Political Location"	"Slope"	"Plot Compass Direction"	"Locality Description"	"Locality"	"Topographic location"	"Vegetation Type"	"Number of Trunks"	"Number of Trees"	"Other Epilocs (OLD)"	"Collaborators (OLD)"	"Installed and evaluated by (OLD)"	"Plot Name"	"Local Plot Number"	"Expedition Name"	"Expedition Number"	"Funding agency"	"Collaborators"	"Installed and evaluated by"	"Notes"	"Interchangeable Magnesium"	"Interchangeable Acidity"	"CIC"	"Sand"	"Silt"	"Clay"	"Textural Class"	"Notes 2"	"Textural Class (select)"	"Qualifier Available Phosphor"	"Qualifier Interchangeable Calcium"	"Qualifier Interchangeable Acidity"
inputs/Madidi/LocationObservation/new_terms.csv
1 
PlotInventoryName,fieldNumber,,
2 
LatitudeDecDeg,decimalLatitude,,
3 
LongitudeDecDeg,decimalLongitude,,
4 
Total Nitrogen,nitrogen_percent,,Assuming units are % based on the range of values
5 
Organic Carbon,carbon_percent,,Assuming units are % based on the range of values
6 
Organic material,organic_percent,,Assuming units are % based on the range of values
7 
Available Phosphor,phosphorus_percent,,Assuming units are % based on the range of values
8 
Interchangeable Sodium,sodium_percent,,Assuming units are % based on the range of values
9 
Interchangeable Potassium,potassium_percent,,Assuming units are % based on the range of values
10 
Interchangable Calcium,calcium_percent,,Assuming units are % based on the range of values
11 
Electric conductivity,conductivity,,
12 
pH disolved,ph,,
13 
Slope,slopeGradient,,
14 
Vegetation Type,communityID,,
15 
Expedition Name,projectName,,
16 
Expedition Number,projectID,,
17 
Interchangeable Magnesium,magnesium_percent,,Assuming units are % based on the range of values
18 
Interchangeable Acidity,acidity_percent,,Assuming units are % based on the range of values
19 
CIC,cationExchangeCapacity_cmol_kg,,
20 
Textural Class,texture,,
21 
Notes 2,plotNotes,,
inputs/Madidi/LocationObservation/unmapped_terms.csv
1 
*Other epilocs
2 
*Political Location
3 
*Plot Compass Direction
4 
*Locality Description
5 
*Topographic location
6 
*Number of Trunks
7 
*Number of Trees
8 
*Other Epilocs (OLD)
9 
*Collaborators (OLD)
10 
*Installed and evaluated by (OLD)
11 
*Local Plot Number
12 
*Funding agency
13 
*Collaborators
14 
*Installed and evaluated by
15 
*Textural Class (select)
16 
*Qualifier Available Phosphor
17 
*Qualifier Interchangeable Calcium
18 
*Qualifier Interchangeable Acidity
inputs/Madidi/Location/map.csv
1 
Madidi,VegCore,Filter,Comments
2 
PlotID,locationID,,
3 
PlotName,locationName,,
4 
Area,plotArea_ha,,
5 
LatitudeDecDeg,decimalLatitude,,
6 
LongitudeDecDeg,decimalLongitude,,
7 
CountryName,country,,
8 
UpperName,stateProvince,,
9 
LowerName,county,,
10 
MinimumElevationMeters,minimumElevationInMeters,,
11 
MaximumElevationMeters,maximumElevationInMeters,,
12 
OrientationXDegrees,*OrientationXDegrees,,
13 
OrientationYDegrees,*OrientationYDegrees,,
14 
FirstSurveyDate,*FirstSurveyDate,,
15 
Topography,landform,,
16 
LocalityDescription,locality,,
17 
Note,plotNotes,,
inputs/Madidi/Location/VegBIEN.csv
1 
Madidi,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
PlotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
5 
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7 
Area,/location/area_m2/_ha_to_m2/value,
8 
MaximumElevationMeters,/location/elevation_m/_alt/2/_avg/max,
9 
MinimumElevationMeters,/location/elevation_m/_alt/2/_avg/min,
10 
LocalityDescription,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
11 
Topography,/location/landform,
12 
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
13 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
14 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
15 
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
16 
LocalityDescription,/location/locationnarrative/_merge/1,
17 
LatitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
18 
LongitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
19 
CountryName,/location/locationplace/*_id/place/country,
20 
LowerName,/location/locationplace/*_id/place/county,
21 
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"
22 
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"
23 
CountryName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2,
24 
LowerName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
25 
UpperName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
26 
UpperName,/location/locationplace/*_id/place/stateprovince,
27 
Note,/location/notespublic,
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",
30 
FirstSurveyDate,,** No join mapping for *FirstSurveyDate **
31 
OrientationXDegrees,,** No join mapping for *OrientationXDegrees **
32 
OrientationYDegrees,,** No join mapping for *OrientationYDegrees **
inputs/Madidi/Location/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>Madidi</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <authorlocationcode>$PlotName</authorlocationcode>
11 
                        <sourceaccessioncode>$PlotID</sourceaccessioncode>
12 
                        <area_m2><_ha_to_m2><value>$Area</value></_ha_to_m2></area_m2>
13 
                        <elevation_m>
14 
                            <_avg>
15 
                                <max>$MaximumElevationMeters</max>
16 
                                <min>$MinimumElevationMeters</min>
17 
                            </_avg>
18 
                        </elevation_m>
19 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$LocalityDescription</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
20 
                        <landform>$Topography</landform>
21 
                        <locationnarrative>$LocalityDescription</locationnarrative>
22 
                        <locationplace>
23 
                            <place_id>
24 
                                <place>
25 
                                    <coordinates_id>
26 
                                        <coordinates>
27 
                                            <latitude_deg>
28 
                                                <_nullIf>
29 
                                                    <null>0</null>
30 
                                                    <type>float</type>
31 
                                                    <value>$LatitudeDecDeg</value>
32 
                                                </_nullIf>
33 
                                            </latitude_deg>
34 
                                            <longitude_deg>
35 
                                                <_nullIf>
36 
                                                    <null>0</null>
37 
                                                    <type>float</type>
38 
                                                    <value>$LongitudeDecDeg</value>
39 
                                                </_nullIf>
40 
                                            </longitude_deg>
41 
                                        </coordinates>
42 
                                    </coordinates_id>
43 
                                    <country>$CountryName</country>
44 
                                    <county>$LowerName</county>
45 
                                    <matched_place_id>
46 
                                        <place>
47 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
48 
                                            <coordinates_id>
49 
                                                <coordinates>
50 
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
51 
                                                    <latitude_deg>
52 
                                                        <_nullIf>
53 
                                                            <null>0</null>
54 
                                                            <type>float</type>
55 
                                                            <value>$LatitudeDecDeg</value>
56 
                                                        </_nullIf>
57 
                                                    </latitude_deg>
58 
                                                    <longitude_deg>
59 
                                                        <_nullIf>
60 
                                                            <null>0</null>
61 
                                                            <type>float</type>
62 
                                                            <value>$LongitudeDecDeg</value>
63 
                                                        </_nullIf>
64 
                                                    </longitude_deg>
65 
                                                </coordinates>
66 
                                            </coordinates_id>
67 
                                            <country>$CountryName</country>
68 
                                            <county>$LowerName</county>
69 
                                            <stateprovince>$UpperName</stateprovince>
70 
                                        </place>
71 
                                    </matched_place_id>
72 
                                    <stateprovince>$UpperName</stateprovince>
73 
                                </place>
74 
                            </place_id>
75 
                        </locationplace>
76 
                        <notespublic>$Note</notespublic>
77 
                    </location>
78 
                </path>
79 
            </_simplifyPath>
80 
        </path>
81 
    </_setDefault>
82 
</VegBIEN>
83 
Inserted 14 new rows into database
inputs/Madidi/Location/unmapped_terms.csv
1 
*OrientationXDegrees
2 
*OrientationYDegrees
3 
*FirstSurveyDate
inputs/Madidi/Location/new_terms.csv
1 
Area,plotArea_ha,,
2 
LatitudeDecDeg,decimalLatitude,,
3 
LongitudeDecDeg,decimalLongitude,,
4 
UpperName,stateProvince,,
5 
LowerName,county,,
6 
MinimumElevationMeters,minimumElevationInMeters,,
7 
MaximumElevationMeters,maximumElevationInMeters,,
8 
Topography,landform,,
9 
LocalityDescription,locality,,
10 
Note,plotNotes,,

Also available in: Unified diff