Project

General

Profile

« Previous | Next » 

Revision 96

Changed mappings to use keys vs. attrs

View differences:

scripts/util/NYSpecimenDataAmericas.xml
2 2
<VegX>
3 3
    <individualOrganismObservations>
4 4
        <individualOrganismObservation id="0">
5
            <plotObservationID>0</plotObservationID>
6 5
            <simpleUserdefined>
7 6
                <name>count</name>
8 7
                <value>1</value>
9 8
            </simpleUserdefined>
10 9
            <individualOrganismID>0</individualOrganismID>
10
            <plotObservationID>0</plotObservationID>
11 11
            <simpleUserdefined>
12 12
                <name>habitat</name>
13 13
                <value>Floodplain forest</value>
......
18 18
            </simpleUserdefined>
19 19
        </individualOrganismObservation>
20 20
        <individualOrganismObservation id="1">
21
            <plotObservationID>1</plotObservationID>
22 21
            <simpleUserdefined>
23 22
                <name>count</name>
24 23
                <value>1</value>
25 24
            </simpleUserdefined>
26 25
            <individualOrganismID>1</individualOrganismID>
26
            <plotObservationID>1</plotObservationID>
27 27
        </individualOrganismObservation>
28 28
    </individualOrganismObservations>
29
    <plotObservations>
30
        <plotObservation id="0">
31
            <plotUniqueIdentifierID>0</plotUniqueIdentifierID>
32
            <obsStartDate>1984-8-20</obsStartDate>
33
        </plotObservation>
34
        <plotObservation id="1">
35
            <plotUniqueIdentifierID>1</plotUniqueIdentifierID>
36
            <obsStartDate>1994-1-17</obsStartDate>
37
        </plotObservation>
38
    </plotObservations>
39
    <plots>
40
        <plot id="0">
41
            <simpleUserdefined>
42
                <name>confidentialityStatus</name>
43
                <value>0</value>
44
            </simpleUserdefined>
45
            <country>Peru</country>
46
            <state>Madre de Dios</state>
47
            <county>Man&#250;</county>
48
            <simpleUserdefined>
49
                <name>locality</name>
50
                <value>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</value>
51
            </simpleUserdefined>
52
            <geospatial>
53
                <DecimalLongitude>-71.40</DecimalLongitude>
54
                <DecimalLatitude>-11.80</DecimalLatitude>
55
                <minimumElevationInMeters>350</minimumElevationInMeters>
56
                <maximumElevationInMeters>350</maximumElevationInMeters>
57
            </geospatial>
58
        </plot>
59
        <plot id="1">
60
            <simpleUserdefined>
61
                <name>confidentialityStatus</name>
62
                <value>0</value>
63
            </simpleUserdefined>
64
            <country>Belize</country>
65
            <state>Belize District</state>
66
            <simpleUserdefined>
67
                <name>locality</name>
68
                <value>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</value>
69
            </simpleUserdefined>
70
            <geospatial>
71
                <DecimalLongitude>-88.50</DecimalLongitude>
72
                <DecimalLatitude>17.40</DecimalLatitude>
73
                <minimumElevationInMeters>15</minimumElevationInMeters>
74
                <maximumElevationInMeters>15</maximumElevationInMeters>
75
            </geospatial>
76
        </plot>
77
    </plots>
78 29
    <individualOrganisms>
79 30
        <individualOrganism id="0">
80 31
            <taxonNameUsageConceptsID>0</taxonNameUsageConceptsID>
......
234 185
            <Name>Scrophulariaceae</Name>
235 186
        </taxonConcept>
236 187
    </taxonConcepts>
188
    <plotObservations>
189
        <plotObservation id="0">
190
            <obsStartDate>1984-8-20</obsStartDate>
191
            <plotUniqueIdentifierID>0</plotUniqueIdentifierID>
192
        </plotObservation>
193
        <plotObservation id="1">
194
            <obsStartDate>1994-1-17</obsStartDate>
195
            <plotUniqueIdentifierID>1</plotUniqueIdentifierID>
196
        </plotObservation>
197
    </plotObservations>
198
    <plots>
199
        <plot id="0">
200
            <country>Peru</country>
201
            <state>Madre de Dios</state>
202
            <county>Man&#250;</county>
203
            <simpleUserdefined>
204
                <name>locality</name>
205
                <value>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</value>
206
            </simpleUserdefined>
207
            <geospatial>
208
                <DecimalLongitude>-71.40</DecimalLongitude>
209
                <DecimalLatitude>-11.80</DecimalLatitude>
210
                <minimumElevationInMeters>350</minimumElevationInMeters>
211
                <maximumElevationInMeters>350</maximumElevationInMeters>
212
            </geospatial>
213
        </plot>
214
        <plot id="1">
215
            <country>Belize</country>
216
            <state>Belize District</state>
217
            <simpleUserdefined>
218
                <name>locality</name>
219
                <value>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</value>
220
            </simpleUserdefined>
221
            <geospatial>
222
                <DecimalLongitude>-88.50</DecimalLongitude>
223
                <DecimalLatitude>17.40</DecimalLatitude>
224
                <minimumElevationInMeters>15</minimumElevationInMeters>
225
                <maximumElevationInMeters>15</maximumElevationInMeters>
226
            </geospatial>
227
        </plot>
228
    </plots>
237 229
</VegX>
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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subspecies,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/epithet"
3
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/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[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/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[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Family,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Genus,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subspecies,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/rank"
11
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Class,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Family,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Genus,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Order,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subkingdom,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Kingdom,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,plantConceptStatus=accepted,startDate=epoch,*_ID/party]])/*_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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,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[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subspecies,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[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/*_ID/plantConcept[plantStatus[plantLevel=Species,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[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/interpretationDate/_date/day"
23
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/interpretationDate/_date/month"
24
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/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[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/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[interpretationType=Author,ROLE_ID/aux_Role/roleCode=identifier,*_ID/party]/*_ID/party/{givenName,middleName,surName}"
27
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/collectionNumber"
28
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/notes"
29
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/museum_ID/party/OrganizationName/_name/first"
30
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/museum_ID/party/OrganizationName/_name/last"
31
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/{taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode}"
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}"
27
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber"
28
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes"
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
"/*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}"
32 32
"/*ID->/*s/individualOrganism/identificationLabel","/taxonImportance/stemCount/stemLocation/stemCode"
33
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
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 34
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
35 35
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
36 36
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs/soilPH"
......
64 64
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","/*_ID/observation/waterDepth/min"
65 65
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","/*_ID/observation/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
66 66
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","/*_ID/observation/*_ID/plot/elevation"
67
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/authorPlotCode"
68
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"
69
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode"
70
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=confidentialityStatus]/value","/*_ID/observation/*_ID/plot/confidentialityStatus"
67
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode,authorObsCode}"
68
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode"
71 69
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
72 70
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
73 71
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName"
......
86 84
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
87 85
"/diameterBaseDistance[baseDistance=1.37]/diameter","/taxonImportance/stemCount/stemDiameter"
88 86
"/height","/taxonImportance/stemCount/stemHeight"
89
"/simpleUserdefined[name=censusNo]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/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[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
90 88
"/simpleUserdefined[name=count]/value","/taxonImportance/*/stemCount"
91 89
"/simpleUserdefined[name=coverPercent]/value","/taxonImportance/cover"
92
"/simpleUserdefined[name=habit]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
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"
93 91
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
94 92
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
95
"/simpleUserdefined[name=individualCode]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/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"
96 94
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
97 95
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
98 96
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
mappings/NYBG-VegX.organisms.csv
1 1
"NYBG","VegX:/*s/individualOrganismObservation"
2
":0","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=confidentialityStatus]/value"
3 2
":1","/simpleUserdefined[name=count]/value"
4 3
"key",
5 4
"DateLastModified",
mappings/joins/NYBG-VegBank.organisms.csv
1 1
NYBG,VegBank:/taxonObservation
2
:0,/*_ID/observation/*_ID/plot/confidentialityStatus
3 2
:1,/taxonImportance/*/stemCount
4
InstitutionCode,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/museum_ID/party/OrganizationName/_name/first"
5
CollectionCode,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/museum_ID/party/OrganizationName/_name/last"
6
ScientificName,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/*_ID/plantConcept[plantStatus[plantLevel=Species,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
7
Kingdom,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Kingdom,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
8
Phylum,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subkingdom,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
9
Class,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Class,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
10
Order,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Order,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
11
Family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Family,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
12
Genus,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Genus,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
13
Species,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
14
Subspecies,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subspecies,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
15
ScientificNameAuthor,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,plantConceptStatus=accepted,startDate=epoch,*_ID/party]])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
16
IdentifiedBy,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=identifier,*_ID/party]/*_ID/party/{givenName,middleName,surName}"
17
YearIdentified,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/interpretationDate/_date/year"
18
MonthIdentified,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/interpretationDate/_date/month"
19
DayIdentified,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/interpretationDate/_date/day"
20
FieldNumber,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/collectionNumber"
21
Collector,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/collector_ID/party/{givenName,middleName,surName}"
3
InstitutionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first
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
19
FieldNumber,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber
20
Collector,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName,middleName,surName}"
22 21
YearCollected,/*_ID/observation/obsStartDate/_date/year
23 22
MonthCollected,/*_ID/observation/obsStartDate/_date/month
24 23
DayCollected,/*_ID/observation/obsStartDate/_date/day
......
34 33
MaximumElevation,"/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
35 34
MinimumDepth,/*_ID/observation/waterDepth/min
36 35
MaximumDepth,/*_ID/observation/waterDepth/max
37
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
38
Notes,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/notes"
36
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
37
Notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes
39 38
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
40 39
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
41 40
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
42 41
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
43
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode}"
42
UniqueNYInternalRecordNumber,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
mappings/joins/SALVIAS-VegBank.plots.csv
1 1
SALVIAS,VegBank:/observation
2 2
project,/*_ID/project/projectName
3
plot_code,"/{*_ID/plot/authorPlotCode,authorObsCode}"
3
plot_code,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode,authorObsCode}"
4 4
major_geo,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
5 5
country,"/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""area|country|territory""])/placeName"
6 6
pol1,"/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName"
mappings/joins/SALVIAS-VegBank.organisms.csv
1 1
SALVIAS,VegBank:/taxonObservation
2
OBSERVATION_ID,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode}"
3
plot_code,/*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode
4
census_no,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
2
OBSERVATION_ID,"/{taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode}"
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"
5 5
census_date,/*_ID/observation/obsStartDate
6
subplot,"/*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"
7
individual_code,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
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"
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
coll_number,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/collectionNumber"
13
coll_lastname,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/collector_ID->/party/surName"
14
coll_firstname,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/collector_ID->/party/givenName"
15
det_type,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"
16
family,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Family,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
17
genus,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Genus,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
18
specific_epithet,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName"
19
specific_authority,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Species,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}"
20
infra_rank_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subspecies,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/rank"
21
infra_ep_1,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=""Computer (automated)"",ROLE_ID/aux_Role/roleCode=computer,*_ID/party](/*_ID/plantConcept[plantStatus[plantLevel=Subspecies,plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference])/*_ID/*/plantName/epithet"
22
cf_aff,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"
23
habit,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
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"
24 24
no_of_individuals,/taxonImportance/*/stemCount
25 25
cover_percent,/taxonImportance/cover
26 26
intercept_cm,"/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
......
35 35
stem_canopy_form,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
36 36
stem_canopy_position,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
37 37
stem_liana_infestation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
38
notes,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[interpretationType=Author,ROLE_ID/aux_Role/roleCode=collector,*_ID/party]/notes"
38
notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes
mappings/VegX-VegBank.plots.csv
32 32
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterDepth/min
33 33
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
34 34
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_ID/plot/elevation
35
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/authorPlotCode
36
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{*_ID/plot/authorPlotCode,authorObsCode}"
37
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode
38
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=confidentialityStatus]/value,/*_ID/plot/confidentialityStatus
35
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode,authorObsCode}"
36
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode
39 37
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription
40 38
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription
41 39
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName

Also available in: Unified diff