Project

General

Profile

« Previous | Next » 

Revision 98

Added by Aaron Marcuse-Kubitza about 13 years ago

Further refinements to mappings to support database constraints

View differences:

scripts/util/NYSpecimenDataAmericas.xml
73 73 
    <taxonDeterminations>
74 74 
        <taxonDetermination>
75 75 
            <taxonNameUsageConceptID>0</taxonNameUsageConceptID>
76 
            <partyWithRole>
77 
                <role>identifier</role>
78 
            </partyWithRole>
76 79 
            <taxonRelationshipAssertions>
77 80 
                <taxonRelationshipAssertion>
78 81 
                    <assertion>
......
105 108 
                    </assertion>
106 109 
                </taxonRelationshipAssertion>
107 110 
            </taxonRelationshipAssertions>
111 
        </taxonDetermination>
112 
        <taxonDetermination>
113 
            <taxonNameUsageConceptID>0</taxonNameUsageConceptID>
108 114 
            <partyWithRole>
109 115 
                <role>collector</role>
110 116 
                <partyID>1</partyID>
......
112 118 
        </taxonDetermination>
113 119 
        <taxonDetermination>
114 120 
            <taxonNameUsageConceptID>1</taxonNameUsageConceptID>
121 
            <partyWithRole>
122 
                <role>identifier</role>
123 
            </partyWithRole>
115 124 
            <taxonRelationshipAssertions>
116 125 
                <taxonRelationshipAssertion>
117 126 
                    <assertion>
......
134 143 
                    </assertion>
135 144 
                </taxonRelationshipAssertion>
136 145 
            </taxonRelationshipAssertions>
146 
        </taxonDetermination>
147 
        <taxonDetermination>
148 
            <taxonNameUsageConceptID>1</taxonNameUsageConceptID>
137 149 
            <partyWithRole>
138 150 
                <role>collector</role>
139 151 
                <partyID>3</partyID>
mappings/VegX-VegBank.organisms.csv
1 1 
"VegX:/*s/individualOrganismObservation","VegBank:/taxonObservation"
2 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subspecies]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/_name/last"
3 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"
4 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID->/party/givenName"
5 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID->/party/surName"
6 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Family]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
7 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Genus]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
8 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}"
9 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Species]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
10 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subspecies]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/_name/first"
11 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"
12 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Class]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
13 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Family]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
14 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Genus]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
15 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Order]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
16 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
17 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Kingdom]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
18 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
19 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,*_ID/party](/*_ID/plantConcept[plantStatus/plantLevel=Species]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
20 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subspecies]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
21 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,*_ID/party]/*_ID/plantConcept[plantStatus/plantLevel=Species]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
22 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/interpretationDate/_date/day"
23 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/interpretationDate/_date/month"
24 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/interpretationDate/_date/year"
25 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName,middleName,surName}"
26 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName,middleName,surName}"
2 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/last"
3 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]:[@fkey=tableRecord_ID]/definedValue"
4 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/givenName"
5 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/surName"
6 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
7 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
8 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
9 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
10 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/first"
11 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]:[@fkey=tableRecord_ID]/definedValue"
12 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Class]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
13 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
14 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
15 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Order]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
16 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subkingdom]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
17 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Kingdom]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
18 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
19 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
20 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
21 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxonImportance/stemCount/stemLocation/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName}"
22 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day"
23 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month"
24 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year"
25 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName,middleName,surName}"
26 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/partyWithRole/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName,middleName,surName}"
27 27 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber"
28 28 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes"
29 29 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first"
30 30 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last"
31 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
31 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
32 32 
"/*ID->/*s/individualOrganism/identificationLabel","/taxonImportance/stemCount/stemLocation/stemCode"
33 
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
34 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
35 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
33 
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=sex]]:[@fkey=tableRecord_ID]/definedValue"
34 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]:[@fkey=tableRecord_ID]/definedValue"
35 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]:[@fkey=tableRecord_ID]/definedValue"
36 36 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs/soilPH"
37 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
38 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
39 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
40 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
41 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
42 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
43 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
37 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]:[@fkey=tableRecord_ID]/definedValue"
38 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPotassium]]:[@fkey=tableRecord_ID]/definedValue"
39 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilAcidity]]:[@fkey=tableRecord_ID]/definedValue"
40 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilBase]]:[@fkey=tableRecord_ID]/definedValue"
41 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCalcium]]:[@fkey=tableRecord_ID]/definedValue"
42 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCarbon]]:[@fkey=tableRecord_ID]/definedValue"
43 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCationCap]]:[@fkey=tableRecord_ID]/definedValue"
44 44 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/*_ID/observation/soilObs/soilClay"
45 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
45 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilConductivity]]:[@fkey=tableRecord_ID]/definedValue"
46 46 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/*_ID/observation/soilObs/soilOrganic"
47 47 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/*_ID/observation/soilObs/soilSand"
48 48 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/*_ID/observation/soilObs/soilSilt"
49 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
49 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilSodium]]:[@fkey=tableRecord_ID]/definedValue"
50 50 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/*_ID/observation/soilObs/soilTexture"
51 51 
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","/*_ID/observation/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName"
52 52 
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription"
......
79 79 
"/*ID->/*s/plotObservation/obsStartDate/_date/month","/*_ID/observation/obsStartDate/_date/month"
80 80 
"/*ID->/*s/plotObservation/obsStartDate/_date/year","/*_ID/observation/obsStartDate/_date/year"
81 81 
"/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","/*_ID/observation/methodNarrative"
82 
"/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
83 
"/*ID->/*s/plotObservation/temperature","/*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
84 
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
82 
"/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/*_ID/observation/definedValue[userDefined[tableName=observation,userDefinedName=precipitationMm]]:[@fkey=tableRecord_ID]/definedValue"
83 
"/*ID->/*s/plotObservation/temperature","/*_ID/observation/definedValue[userDefined[tableName=observation,userDefinedName=temperatureC]]:[@fkey=tableRecord_ID]/definedValue"
84 
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]:[@fkey=tableRecord_ID]/definedValue"
85 85 
"/diameterBaseDistance[baseDistance=1.37]/diameter","/taxonImportance/stemCount/stemDiameter"
86 86 
"/height","/taxonImportance/stemCount/stemHeight"
87 
"/simpleUserdefined[name=censusNo]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
87 
"/simpleUserdefined[name=censusNo]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]:[@fkey=tableRecord_ID]/definedValue"
88 88 
"/simpleUserdefined[name=count]/value","/taxonImportance/*/stemCount"
89 89 
"/simpleUserdefined[name=coverPercent]/value","/taxonImportance/cover"
90 
"/simpleUserdefined[name=habit]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
91 
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
92 
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
93 
"/simpleUserdefined[name=individualCode]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
94 
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
95 
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
96 
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
97 
"/simpleUserdefined[name=stemCanopyPosition]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
98 
"/simpleUserdefined[name=stemHeightFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
90 
"/simpleUserdefined[name=habit]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=habit]]:[@fkey=tableRecord_ID]/definedValue"
91 
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=habitat]]:[@fkey=tableRecord_ID]/definedValue"
92 
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
93 
"/simpleUserdefined[name=individualCode]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]:[@fkey=tableRecord_ID]/definedValue"
94 
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]:[@fkey=tableRecord_ID]/definedValue"
95 
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedValue"
96 
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedValue"
97 
"/simpleUserdefined[name=stemCanopyPosition]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedValue"
98 
"/simpleUserdefined[name=stemHeightFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
99 99 
"/simpleUserdefined[name=stemHeightM]/value","/taxonImportance/stemCount/stemHeight"
100 
"/simpleUserdefined[name=stemLianaInfestation]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
101 
"/simpleUserdefined[name=substrate]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
102 
"/simpleUserdefined[name=vegetation]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
100 
"/simpleUserdefined[name=stemLianaInfestation]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedValue"
101 
"/simpleUserdefined[name=substrate]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=substrate]]:[@fkey=tableRecord_ID]/definedValue"
102 
"/simpleUserdefined[name=vegetation]/value","/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=vegetation]]:[@fkey=tableRecord_ID]/definedValue"
103 103 
"/simpleUserdefined[name=xPosition]/value","/taxonImportance/stemCount/stemLocation/stemXPosition"
104 104 
"/simpleUserdefined[name=yPosition]/value","/taxonImportance/stemCount/stemLocation/stemYPosition"
mappings/NYBG-VegX.organisms.csv
5 5 
"InstitutionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first"
6 6 
"CollectionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last"
7 7 
"CatalogNumber",
8 
"ScientificName","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
8 
"ScientificName","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
9 9 
"BasisOfRecord",
10 
"Kingdom","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
11 
"Phylum","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"
12 
"Class","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"
13 
"Order","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"
14 
"Family","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
15 
"Genus","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
16 
"Species","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
17 
"Subspecies","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"
18 
"ScientificNameAuthor","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
19 
"IdentifiedBy","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}"
20 
"YearIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year"
21 
"MonthIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month"
22 
"DayIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day"
10 
"Kingdom","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
11 
"Phylum","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"
12 
"Class","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"
13 
"Order","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"
14 
"Family","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
15 
"Genus","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
16 
"Species","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
17 
"Subspecies","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"
18 
"ScientificNameAuthor","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
19 
"IdentifiedBy","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/partyWithRole/*ID->/parties/party/individualName/{givenName,surName}"
20 
"YearIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year"
21 
"MonthIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month"
22 
"DayIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day"
23 23 
"TypeStatus",
24 24 
"CollectorNumber",
25 25 
"FieldNumber","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
26 
"Collector","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}"
26 
"Collector","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName,surName}"
27 27 
"YearCollected","/*ID->/*s/plotObservation/obsStartDate/_date/year"
28 28 
"MonthCollected","/*ID->/*s/plotObservation/obsStartDate/_date/month"
29 29 
"DayCollected","/*ID->/*s/plotObservation/obsStartDate/_date/day"
mappings/joins/NYBG-VegBank.organisms.csv
2 2 
:1,/taxonImportance/*/stemCount
3 3 
InstitutionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first
4 4 
CollectionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last
5 
ScientificName,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,*_ID/party]/*_ID/plantConcept[plantStatus/plantLevel=Species]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
6 
Kingdom,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Kingdom]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
7 
Phylum,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
8 
Class,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Class]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
9 
Order,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Order]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
10 
Family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Family]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
11 
Genus,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Genus]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
12 
Species,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,*_ID/party](/*_ID/plantConcept[plantStatus/plantLevel=Species]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
13 
Subspecies,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subspecies]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
14 
ScientificNameAuthor,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
15 
IdentifiedBy,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName,middleName,surName}"
16 
YearIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/interpretationDate/_date/year
17 
MonthIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/interpretationDate/_date/month
18 
DayIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/interpretationDate/_date/day
5 
ScientificName,"/taxonImportance/stemCount/stemLocation/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName}"
6 
Kingdom,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Kingdom]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
7 
Phylum,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subkingdom]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
8 
Class,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Class]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
9 
Order,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Order]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
10 
Family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
11 
Genus,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
12 
Species,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
13 
Subspecies,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
14 
ScientificNameAuthor,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
15 
IdentifiedBy,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName,middleName,surName}"
16 
YearIdentified,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year"
17 
MonthIdentified,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month"
18 
DayIdentified,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day"
19 19 
FieldNumber,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber
20 20 
Collector,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName,middleName,surName}"
21 21 
YearCollected,/*_ID/observation/obsStartDate/_date/year
......
33 33 
MaximumElevation,"/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
34 34 
MinimumDepth,/*_ID/observation/waterDepth/min
35 35 
MaximumDepth,/*_ID/observation/waterDepth/max
36 
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
36 
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=sex]]:[@fkey=tableRecord_ID]/definedValue"
37 37 
Notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes
38 
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
39 
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
40 
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
41 
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
42 
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
38 
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=habitat]]:[@fkey=tableRecord_ID]/definedValue"
39 
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]:[@fkey=tableRecord_ID]/definedValue"
40 
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=substrate]]:[@fkey=tableRecord_ID]/definedValue"
41 
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=vegetation]]:[@fkey=tableRecord_ID]/definedValue"
42 
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
mappings/joins/SALVIAS-VegBank.plots.csv
11 11 
elev_m,/*_ID/plot/elevation
12 12 
elev_max_m,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
13 13 
elev_min_m,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
14 
temp_c,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
15 
precip_mm,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
14 
temp_c,"/definedValue[userDefined[tableName=observation,userDefinedName=temperatureC]]:[@fkey=tableRecord_ID]/definedValue"
15 
precip_mm,"/definedValue[userDefined[tableName=observation,userDefinedName=precipitationMm]]:[@fkey=tableRecord_ID]/definedValue"
16 16 
slope_aspect,/*_ID/plot/slopeAspect
17 17 
slope_gradient,/*_ID/plot/slopeGradient
18 18 
clay_percent,/soilObs/soilClay
......
20 20 
sand_percent,/soilObs/soilSand
21 21 
organic_percent,/soilObs/soilOrganic
22 22 
pH,/soilObs/soilPH
23 
soil_N,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
24 
soil_P,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
25 
soil_C,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
26 
soil_K,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
27 
soil_Mg,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
28 
soil_Ca,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
29 
soil_Na,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
30 
soil_acidity,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
31 
soil_base,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
32 
soil_cation_cap,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
33 
soil_conductivity,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
23 
soil_N,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]:[@fkey=tableRecord_ID]/definedValue"
24 
soil_P,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]:[@fkey=tableRecord_ID]/definedValue"
25 
soil_C,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCarbon]]:[@fkey=tableRecord_ID]/definedValue"
26 
soil_K,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPotassium]]:[@fkey=tableRecord_ID]/definedValue"
27 
soil_Mg,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]:[@fkey=tableRecord_ID]/definedValue"
28 
soil_Ca,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCalcium]]:[@fkey=tableRecord_ID]/definedValue"
29 
soil_Na,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilSodium]]:[@fkey=tableRecord_ID]/definedValue"
30 
soil_acidity,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilAcidity]]:[@fkey=tableRecord_ID]/definedValue"
31 
soil_base,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilBase]]:[@fkey=tableRecord_ID]/definedValue"
32 
soil_cation_cap,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCationCap]]:[@fkey=tableRecord_ID]/definedValue"
33 
soil_conductivity,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilConductivity]]:[@fkey=tableRecord_ID]/definedValue"
34 34 
soil_texture,/soilObs/soilTexture
35 35 
holdridge_life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription
36 36 
life_zone_code,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
mappings/joins/SALVIAS-VegBank.organisms.csv
1 1 
SALVIAS,VegBank:/taxonObservation
2 
OBSERVATION_ID,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
2 
OBSERVATION_ID,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
3 3 
plot_code,/*_ID/observation/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode
4 
census_no,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
4 
census_no,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]:[@fkey=tableRecord_ID]/definedValue"
5 5 
census_date,/*_ID/observation/obsStartDate
6 6 
subplot,"/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode,authorObsCode}"
7 
individual_code,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
7 
individual_code,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]:[@fkey=tableRecord_ID]/definedValue"
8 8 
tag1,/taxonImportance/stemCount/stemLocation/stemCode
9 9 
tag2,/taxonImportance/stemCount/stemLocation/stemCode
10 10 
x_position,/taxonImportance/stemCount/stemLocation/stemXPosition
11 11 
y_position,/taxonImportance/stemCount/stemLocation/stemYPosition
12 12 
coll_number,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber
13 
coll_lastname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID->/party/surName
14 
coll_firstname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID->/party/givenName
15 
det_type,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"
16 
family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Family]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
17 
genus,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Genus]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
18 
specific_epithet,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Species]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
19 
specific_authority,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}"
20 
infra_rank_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subspecies]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/_name/first"
21 
infra_ep_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer](/*_ID/plantConcept[plantStatus/plantLevel=Subspecies]:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/_name/last"
22 
cf_aff,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"
23 
habit,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
13 
coll_lastname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/surName
14 
coll_firstname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/givenName
15 
det_type,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]:[@fkey=tableRecord_ID]/definedValue"
16 
family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
17 
genus,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
18 
specific_epithet,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
19 
specific_authority,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
20 
infra_rank_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/first"
21 
infra_ep_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/last"
22 
cf_aff,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]:[@fkey=tableRecord_ID]/definedValue"
23 
habit,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[userDefined[tableName=taxonInterpretation,userDefinedName=habit]]:[@fkey=tableRecord_ID]/definedValue"
24 24 
no_of_individuals,/taxonImportance/*/stemCount
25 25 
cover_percent,/taxonImportance/cover
26 
intercept_cm,"/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
26 
intercept_cm,"/taxonImportance/definedValue[userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]:[@fkey=tableRecord_ID]/definedValue"
27 27 
height_m,/taxonImportance/stemCount/stemHeight
28 
ht_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
28 
ht_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
29 29 
stem_tag1,/taxonImportance/stemCount/stemLocation/stemCode
30 30 
stem_tag2,/taxonImportance/stemCount/stemLocation/stemCode
31 31 
stem_dbh,/taxonImportance/stemCount/stemDiameter
32 
basal_diam,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
32 
basal_diam,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]:[@fkey=tableRecord_ID]/definedValue"
33 33 
stem_height_m,/taxonImportance/stemCount/stemHeight
34 
stem_height_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
35 
stem_canopy_form,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
36 
stem_canopy_position,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
37 
stem_liana_infestation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
34 
stem_height_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]:[@fkey=tableRecord_ID]/definedValue"
35 
stem_canopy_form,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]:[@fkey=tableRecord_ID]/definedValue"
36 
stem_canopy_position,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]:[@fkey=tableRecord_ID]/definedValue"
37 
stem_liana_infestation,"/taxonImportance/stemCount/stemLocation/definedValue[userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]:[@fkey=tableRecord_ID]/definedValue"
38 38 
notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes
39 
orig_family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
40 
orig_species,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
mappings/SALVIAS-VegX.organisms.csv
44 44 
"stem_canopy_position","/simpleUserdefined[name=stemCanopyPosition]/value"
45 45 
"stem_liana_infestation","/simpleUserdefined[name=stemLianaInfestation]/value"
46 46 
"notes","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
47 
"orig_family",
48 
"orig_species",
47 
"orig_family","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
48 
"orig_species","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
mappings/VegX-VegBank.plots.csv
1 1 
VegX:/*s/plotObservation,VegBank:/observation
2 
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
3 
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
2 
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]:[@fkey=tableRecord_ID]/definedValue"
3 
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]:[@fkey=tableRecord_ID]/definedValue"
4 4 
->/*s/abioticObservation[*ID]/ph,/soilObs/soilPH
5 
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
6 
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
7 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
8 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
9 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
10 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
11 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
5 
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]:[@fkey=tableRecord_ID]/definedValue"
6 
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilPotassium]]:[@fkey=tableRecord_ID]/definedValue"
7 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilAcidity]]:[@fkey=tableRecord_ID]/definedValue"
8 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilBase]]:[@fkey=tableRecord_ID]/definedValue"
9 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCalcium]]:[@fkey=tableRecord_ID]/definedValue"
10 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCarbon]]:[@fkey=tableRecord_ID]/definedValue"
11 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilCationCap]]:[@fkey=tableRecord_ID]/definedValue"
12 12 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs/soilClay
13 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
13 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilConductivity]]:[@fkey=tableRecord_ID]/definedValue"
14 14 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs/soilOrganic
15 15 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs/soilSand
16 16 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs/soilSilt
17 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
17 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[userDefined[tableName=soilObs,userDefinedName=soilSodium]]:[@fkey=tableRecord_ID]/definedValue"
18 18 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs/soilTexture
19 19 
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
20 20 
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commInterpretation/*_ID/commConcept/commDescription
......
47 47 
/obsStartDate/_date/month,/obsStartDate/_date/month
48 48 
/obsStartDate/_date/year,/obsStartDate/_date/year
49 49 
/simpleUserdefined[name=plotMethodology]/value,/methodNarrative
50 
/simpleUserdefined[name=precipMm]/value,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
51 
/temperature,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
50 
/simpleUserdefined[name=precipMm]/value,"/definedValue[userDefined[tableName=observation,userDefinedName=precipitationMm]]:[@fkey=tableRecord_ID]/definedValue"
51 
/temperature,"/definedValue[userDefined[tableName=observation,userDefinedName=temperatureC]]:[@fkey=tableRecord_ID]/definedValue"

Also available in: Unified diff