Project

General

Profile

« Previous | Next » 

Revision 345

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegX-VegBank.organisms.csv: Made stemCount default to 1

View differences:

test/accepted_output/SALVIAS.organisms.VegBIEN.xml
70 70 
                </userDefined_ID>
71 71 
                <definedValue>10</definedValue>
72 72 
            </definedValue>
73 
            <interpretationType>Author</interpretationType>
74 
            <originalInterpretation>true</originalInterpretation>
75 
            <currentInterpretation>false</currentInterpretation>
76 
            <interpretationDate>epoch</interpretationDate>
77 73 
            <plantConcept_ID>
78 74 
                <plantConcept>
79 
                    <reference_ID>
80 
                        <reference/>
81 
                    </reference_ID>
82 75 
                    <plantName_ID>
83 76 
                        <plantName>
84 77 
                            <plantName>Inga indet</plantName>
85 78 
                        </plantName>
86 79 
                    </plantName_ID>
80 
                    <reference_ID>
81 
                        <reference/>
82 
                    </reference_ID>
87 83 
                </plantConcept>
88 84 
            </plantConcept_ID>
85 
            <interpretationType>Author</interpretationType>
86 
            <originalInterpretation>true</originalInterpretation>
87 
            <currentInterpretation>false</currentInterpretation>
88 
            <interpretationDate>epoch</interpretationDate>
89 89 
            <party_ID>
90 90 
                <party/>
91 91 
            </party_ID>
......
332 332 
                </userDefined_ID>
333 333 
                <definedValue>100</definedValue>
334 334 
            </definedValue>
335 
            <interpretationType>Author</interpretationType>
336 
            <originalInterpretation>true</originalInterpretation>
337 
            <currentInterpretation>false</currentInterpretation>
338 
            <interpretationDate>epoch</interpretationDate>
339 335 
            <plantConcept_ID>
340 336 
                <plantConcept>
341 
                    <reference_ID>
342 
                        <reference/>
343 
                    </reference_ID>
344 337 
                    <plantName_ID>
345 338 
                        <plantName>
346 339 
                            <plantName>Virola pavonis</plantName>
347 340 
                        </plantName>
348 341 
                    </plantName_ID>
342 
                    <reference_ID>
343 
                        <reference/>
344 
                    </reference_ID>
349 345 
                </plantConcept>
350 346 
            </plantConcept_ID>
347 
            <interpretationType>Author</interpretationType>
348 
            <originalInterpretation>true</originalInterpretation>
349 
            <currentInterpretation>false</currentInterpretation>
350 
            <interpretationDate>epoch</interpretationDate>
351 351 
            <party_ID>
352 352 
                <party/>
353 353 
            </party_ID>
test/accepted_output/SALVIAS_db.organisms.VegBIEN.xml
63 63 
                </userDefined_ID>
64 64 
                <definedValue>1</definedValue>
65 65 
            </definedValue>
66 
            <interpretationType>Author</interpretationType>
67 
            <originalInterpretation>true</originalInterpretation>
68 
            <currentInterpretation>false</currentInterpretation>
69 
            <interpretationDate>epoch</interpretationDate>
70 66 
            <plantConcept_ID>
71 67 
                <plantConcept>
72 
                    <reference_ID>
73 
                        <reference/>
74 
                    </reference_ID>
75 68 
                    <plantName_ID>
76 69 
                        <plantName>
77 70 
                            <plantName>seleri</plantName>
78 71 
                        </plantName>
79 72 
                    </plantName_ID>
73 
                    <reference_ID>
74 
                        <reference/>
75 
                    </reference_ID>
80 76 
                </plantConcept>
81 77 
            </plantConcept_ID>
78 
            <interpretationType>Author</interpretationType>
79 
            <originalInterpretation>true</originalInterpretation>
80 
            <currentInterpretation>false</currentInterpretation>
81 
            <interpretationDate>epoch</interpretationDate>
82 82 
            <party_ID>
83 83 
                <party/>
84 84 
            </party_ID>
......
323 323 
                </userDefined_ID>
324 324 
                <definedValue>2</definedValue>
325 325 
            </definedValue>
326 
            <interpretationType>Author</interpretationType>
327 
            <originalInterpretation>true</originalInterpretation>
328 
            <currentInterpretation>false</currentInterpretation>
329 
            <interpretationDate>epoch</interpretationDate>
330 326 
            <plantConcept_ID>
331 327 
                <plantConcept>
332 
                    <reference_ID>
333 
                        <reference/>
334 
                    </reference_ID>
335 328 
                    <plantName_ID>
336 329 
                        <plantName>
337 330 
                            <plantName>allenii</plantName>
338 331 
                        </plantName>
339 332 
                    </plantName_ID>
333 
                    <reference_ID>
334 
                        <reference/>
335 
                    </reference_ID>
340 336 
                </plantConcept>
341 337 
            </plantConcept_ID>
338 
            <interpretationType>Author</interpretationType>
339 
            <originalInterpretation>true</originalInterpretation>
340 
            <currentInterpretation>false</currentInterpretation>
341 
            <interpretationDate>epoch</interpretationDate>
342 342 
            <party_ID>
343 343 
                <party/>
344 344 
            </party_ID>
test/accepted_output/NYBG.organisms.VegBIEN.xml
87 87 
                    <OrganizationName>NY Herbarium</OrganizationName>
88 88 
                </party>
89 89 
            </museum_ID>
90 
            <interpretationType>Author</interpretationType>
91 
            <originalInterpretation>true</originalInterpretation>
92 
            <currentInterpretation>false</currentInterpretation>
93 
            <interpretationDate>epoch</interpretationDate>
94 90 
            <plantConcept_ID>
95 91 
                <plantConcept>
96 92 
                    <reference_ID>
......
103 99 
                    </plantName_ID>
104 100 
                </plantConcept>
105 101 
            </plantConcept_ID>
102 
            <interpretationType>Author</interpretationType>
103 
            <originalInterpretation>true</originalInterpretation>
104 
            <currentInterpretation>false</currentInterpretation>
105 
            <interpretationDate>epoch</interpretationDate>
106 106 
            <party_ID>
107 107 
                <party/>
108 108 
            </party_ID>
......
371 371 
                    <OrganizationName>NY Herbarium</OrganizationName>
372 372 
                </party>
373 373 
            </museum_ID>
374 
            <interpretationType>Author</interpretationType>
375 
            <originalInterpretation>true</originalInterpretation>
376 
            <currentInterpretation>false</currentInterpretation>
377 
            <interpretationDate>epoch</interpretationDate>
378 374 
            <plantConcept_ID>
379 375 
                <plantConcept>
380 376 
                    <reference_ID>
......
387 383 
                    </plantName_ID>
388 384 
                </plantConcept>
389 385 
            </plantConcept_ID>
386 
            <interpretationType>Author</interpretationType>
387 
            <originalInterpretation>true</originalInterpretation>
388 
            <currentInterpretation>false</currentInterpretation>
389 
            <interpretationDate>epoch</interpretationDate>
390 390 
            <party_ID>
391 391 
                <party/>
392 392 
            </party_ID>
mappings/VegX-VegBank.organisms.csv
1 
"VegX:/*s/individualOrganismObservation","VegBank:/taxonObservation"
2 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1"
3 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area","/*_ID/observation/*_ID/plot/area"
4 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT","/*_ID/observation/*_ID/plot/dsgpoly"
5 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","/*_ID/observation/*_ID/plot/elevation"
6 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters","/*_ID/observation/*_ID/plot/locationAccuracy"
7 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""area|country|territory""])/placeName"
8 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName"
9 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName"
10 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName"
11 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
12 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
13 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","/*_ID/observation/*_ID/plot/realLatitude"
14 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","/*_ID/observation/*_ID/plot/realLongitude"
15 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","/*_ID/observation/*_ID/plot/slopeAspect"
16 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","/*_ID/observation/*_ID/plot/slopeGradient"
17 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","/*_ID/observation/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19 
"/*ID->/*s/plotObservation/*ID->/*s/project/title","/*_ID/observation/*_ID/project/projectName"
20 
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName"
21 
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription"
22 
"/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
23 
"/*ID->/*s/plotObservation/temperature","/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
24 
"/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","/*_ID/observation/methodNarrative"
25 
"/*ID->/*s/plotObservation/obsEndDate","/*_ID/observation/obsEndDate"
26 
"/*ID->/*s/plotObservation/obsEndDate/_date/date","/*_ID/observation/obsEndDate/_date/date"
27 
"/*ID->/*s/plotObservation/obsStartDate","/*_ID/observation/obsStartDate"
28 
"/*ID->/*s/plotObservation/obsStartDate/_date/date","/*_ID/observation/obsStartDate/_date/date"
29 
"/*ID->/*s/plotObservation/obsStartDate/_date/day","/*_ID/observation/obsStartDate/_date/day"
30 
"/*ID->/*s/plotObservation/obsStartDate/_date/month","/*_ID/observation/obsStartDate/_date/month"
31 
"/*ID->/*s/plotObservation/obsStartDate/_date/year","/*_ID/observation/obsStartDate/_date/year"
32 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilClay"
44 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilOrganic"
45 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilPH"
46 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilSand"
47 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilSilt"
48 
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/*_ID/observation/soilObs:[soilHorizon=unknown]/soilTexture"
49 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","/*_ID/observation/waterDepth/max"
50 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","/*_ID/observation/waterDepth/min"
51 
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
52 
"/simpleUserdefined[name=count]/value","/taxonImportance/*/stemCount"
53 
"/simpleUserdefined[name=coverPercent]/value","/taxonImportance/cover"
54 
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
55 
"/diameterBaseDistance[baseDistance=1.37]/diameter","/taxonImportance/stemCount/stemDiameter"
56 
"/height","/taxonImportance/stemCount/stemHeight"
57 
"/simpleUserdefined[name=stemHeightM]/value","/taxonImportance/stemCount/stemHeight"
58 
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
59 
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
60 
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
61 
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
62 
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
63 
"/simpleUserdefined[name=stemCanopyPosition]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
64 
"/simpleUserdefined[name=stemHeightFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
65 
"/simpleUserdefined[name=stemLianaInfestation]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
66 
"/simpleUserdefined[name=substrate]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
67 
"/simpleUserdefined[name=vegetation]/value","/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
68 
"/*ID->/*s/individualOrganism/identificationLabel","/taxonImportance/stemCount/stemLocation/stemCode"
69 
"/*ID->/*s/individualOrganism/identificationLabel/_alt/1","/taxonImportance/stemCount/stemLocation/stemCode/_alt/1"
70 
"/*ID->/*s/individualOrganism/identificationLabel/_alt/2","/taxonImportance/stemCount/stemLocation/stemCode/_alt/2"
71 
"/simpleUserdefined[name=xPosition]/value","/taxonImportance/stemCount/stemLocation/stemXPosition"
72 
"/simpleUserdefined[name=yPosition]/value","/taxonImportance/stemCount/stemLocation/stemYPosition"
73 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber"
74 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
75 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
76 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{surName}"
77 
"/simpleUserdefined[name=censusNo]/value","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
78 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
79 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
80 
"/simpleUserdefined[name=habit]/value","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
81 
"/simpleUserdefined[name=individualCode]/value","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
82 
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
83 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName"
84 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first"
85 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last"
86 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes"
87 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/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"
88 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/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"
89 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
90 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/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"
91 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/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"
92 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/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"
93 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day"
94 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month"
95 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year"
96 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
97 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/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"
98 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/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"
99 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/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"
100 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/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"
101 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/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"
102 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
103 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/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"
104 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/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"
105 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"
106 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName/_alt/1}"
107 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
1 
VegX:/*s/individualOrganismObservation,VegBank:/taxonObservation
2 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_ID/observation/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1
3 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area,/*_ID/observation/*_ID/plot/area
4 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_ID/observation/*_ID/plot/dsgpoly
5 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_ID/observation/*_ID/plot/elevation
6 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_ID/observation/*_ID/plot/locationAccuracy
7 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country,"/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""area|country|territory""])/placeName"
8 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state,"/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=""region|state|province""])/placeName"
9 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
10 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
11 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription
12 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription
13 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_ID/observation/*_ID/plot/realLatitude
14 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_ID/observation/*_ID/plot/realLongitude
15 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_ID/observation/*_ID/plot/slopeAspect
16 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_ID/observation/*_ID/plot/slopeGradient
17 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_ID/observation/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
18 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/observation/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
19 
/*ID->/*s/plotObservation/*ID->/*s/project/title,/*_ID/observation/*_ID/project/projectName
20 
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
21 
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription
22 
/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,"/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
23 
/*ID->/*s/plotObservation/temperature,"/*_ID/observation/definedValue[*_ID/userDefined[tableName=observation,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
24 
/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_ID/observation/methodNarrative
25 
/*ID->/*s/plotObservation/obsEndDate,/*_ID/observation/obsEndDate
26 
/*ID->/*s/plotObservation/obsEndDate/_date/date,/*_ID/observation/obsEndDate/_date/date
27 
/*ID->/*s/plotObservation/obsStartDate,/*_ID/observation/obsStartDate
28 
/*ID->/*s/plotObservation/obsStartDate/_date/date,/*_ID/observation/obsStartDate/_date/date
29 
/*ID->/*s/plotObservation/obsStartDate/_date/day,/*_ID/observation/obsStartDate/_date/day
30 
/*ID->/*s/plotObservation/obsStartDate/_date/month,/*_ID/observation/obsStartDate/_date/month
31 
/*ID->/*s/plotObservation/obsStartDate/_date/year,/*_ID/observation/obsStartDate/_date/year
32 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilAcidity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
33 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilBase]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
34 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCalcium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
35 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCarbon]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
36 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilCationCap]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
37 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilConductivity]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
38 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
39 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
40 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
41 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilPotassium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
42 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/*_ID/observation/soilObs:[soilHorizon=unknown]/definedValue[*_ID/userDefined[tableName=soilObs,userDefinedName=soilSodium]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
43 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/*_ID/observation/soilObs:[soilHorizon=unknown]/soilClay
44 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/*_ID/observation/soilObs:[soilHorizon=unknown]/soilOrganic
45 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph,/*_ID/observation/soilObs:[soilHorizon=unknown]/soilPH
46 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/*_ID/observation/soilObs:[soilHorizon=unknown]/soilSand
47 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/*_ID/observation/soilObs:[soilHorizon=unknown]/soilSilt
48 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_ID/observation/soilObs:[soilHorizon=unknown]/soilTexture
49 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/*_ID/observation/waterDepth/max
50 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/*_ID/observation/waterDepth/min
51 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
52 
/simpleUserdefined[name=count]/value,/taxonImportance/*/stemCount/_alt/1
53 
/simpleUserdefined[name=coverPercent]/value,/taxonImportance/cover
54 
/simpleUserdefined[name=interceptCm]/value,"/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
55 
/diameterBaseDistance[baseDistance=1.37]/diameter,/taxonImportance/stemCount/stemDiameter
56 
/height,/taxonImportance/stemCount/stemHeight
57 
/simpleUserdefined[name=stemHeightM]/value,/taxonImportance/stemCount/stemHeight
58 
/simpleUserdefined[name=habitat]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
59 
/simpleUserdefined[name=htFirstBranchM]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
60 
/simpleUserdefined[name=plantFungusDescription]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
61 
/diameterBaseDistance[baseDistance=0]/diameter,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
62 
/simpleUserdefined[name=stemCanopyForm]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
63 
/simpleUserdefined[name=stemCanopyPosition]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
64 
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
65 
/simpleUserdefined[name=stemLianaInfestation]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
66 
/simpleUserdefined[name=substrate]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
67 
/simpleUserdefined[name=vegetation]/value,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
68 
/*ID->/*s/individualOrganism/identificationLabel,/taxonImportance/stemCount/stemLocation/stemCode
69 
/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/taxonImportance/stemCount/stemLocation/stemCode/_alt/1
70 
/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/taxonImportance/stemCount/stemLocation/stemCode/_alt/2
71 
/simpleUserdefined[name=xPosition]/value,/taxonImportance/stemCount/stemLocation/stemXPosition
72 
/simpleUserdefined[name=yPosition]/value,/taxonImportance/stemCount/stemLocation/stemYPosition
73 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber
74 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
75 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
76 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{surName}
77 
/simpleUserdefined[name=censusNo]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
78 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
79 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
80 
/simpleUserdefined[name=habit]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=habit]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
81 
/simpleUserdefined[name=individualCode]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
82 
/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/definedValue[*_ID/userDefined[tableName=taxonInterpretation,userDefinedName=sex]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
83 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName
84 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/first
85 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/museum_ID/party/OrganizationName/_name/last
86 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,/taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/notes
87 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/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"
88 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/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"
89 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/plantName/reference_ID/reference/shortName"
90 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/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"
91 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/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"
92 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/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"
93 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/day"
94 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month"
95 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year"
96 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
97 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/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"
98 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/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"
99 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/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"
100 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/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"
101 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/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"
102 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
103 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/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"
104 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/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"
105 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName/_alt/1}"
106 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
107 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[taxonImportance/*/stemCount/_alt/2=1]/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"
mappings/SALVIAS_db-VegBIEN.organisms.csv
1 1 
SALVIAS:plotObservations,VegBIEN:/taxonoccurrence,Comments
2 2 
census_date,/*_ID/plotevent/obsStartDate/_date/year,
3 3 
PlotCode,"/*_ID/plotevent/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}","Brad: Same as plotCode, above"
4 
NoInd,/collectiveobs/*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
4 
NoInd,/collectiveobs/*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 5 
cover_percent,/collectiveobs/cover,
6 6 
intercept_cm,"/collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
7 7 
ht_first_branch_m,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
......
27 27 
infra_rank_1,"/taxondetermination[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",
28 28 
infra_ep_1,"/taxondetermination[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",
29 29 
OrigFamily,"/taxondetermination[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",Brad: OMIT
30 
PlotObsID,"/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
31 30 
OrigSpecies,"/{taxondetermination[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,taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
31 
PlotObsID,":[collectiveobs/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/VegX-VegBIEN.organisms.csv
49 49 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/*_ID/plotevent/waterDepth/max
50 50 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/*_ID/plotevent/waterDepth/min
51 51 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_ID/plotevent/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}"
52 
/simpleUserdefined[name=count]/value,/collectiveobs/*/stemCount
52 
/simpleUserdefined[name=count]/value,/collectiveobs/*/stemCount/_alt/1
53 53 
/simpleUserdefined[name=coverPercent]/value,/collectiveobs/cover
54 54 
/simpleUserdefined[name=interceptCm]/value,"/collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
55 55 
/simpleUserdefined[name=habitat]/value,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
......
102 102 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
103 103 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[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"
104 104 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
105 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,"/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"
106 105 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/{taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName/_alt/1}"
107 106 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/{taxondetermination[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,taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
107 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[collectiveobs/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"
mappings/NYBG-VegBank.organisms.csv
14 14 
YearCollected,/*_ID/observation/obsStartDate/_date/year,
15 15 
MaximumDepth,/*_ID/observation/waterDepth/max,
16 16 
MinimumDepth,/*_ID/observation/waterDepth/min,
17 
:1,/taxonImportance/*/stemCount,
17 
:1,/taxonImportance/*/stemCount/_alt/1,
18 18 
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
19 19 
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB, also possibly to VX;  this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
20 20 
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
......
37 37 
ScientificNameAuthor,"/taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author"
38 38 
Phylum,"/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",
39 39 
Subspecies,"/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",
40 
UniqueNYInternalRecordNumber,"/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
41 40 
ScientificName,"/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
42 41 
Species,"/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",
42 
UniqueNYInternalRecordNumber,":[taxonImportance/*/stemCount/_alt/2=1]/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
mappings/for_review/VegX-VegBank.organisms.csv
49 49 
//geospatial/maximumDepthInMeters,//waterDepth/max
50 50 
//geospatial/minimumDepthInMeters,//waterDepth/min
51 51 
//plot/plotUniqueIdentifier,"/*_ID/observation/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}"
52 
/simpleUserdefined[name=count]/value,//*/stemCount
52 
/simpleUserdefined[name=count]/value,//*/stemCount/_alt/1
53 53 
/simpleUserdefined[name=coverPercent]/value,//taxonImportance/cover
54 54 
/simpleUserdefined[name=interceptCm]/value,"//taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
55 55 
/diameterBaseDistance[baseDistance=1.37]/diameter,//stemCount/stemDiameter
......
102 102 
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
103 103 
//*s/taxonConcept[@code=phyl_div]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName"
104 104 
//*s/taxonConcept[@code=ssp]/Name,"/taxonInterpretation[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName"
105 
//taxonNameUsageConcept/voucher,"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}"
106 105 
//taxonName/Simple,"/{taxonInterpretation[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}"
107 106 
//*s/taxonConcept[@code=sp]/Name,"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
107 
//taxonNameUsageConcept/voucher,"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}"
mappings/for_review/SALVIAS_db-VegBIEN.organisms.csv
1 1 
SALVIAS:plotObservations,VegBIEN:/taxonoccurrence,Comments
2 2 
census_date,//plotevent/obsStartDate/_date/year,
3 3 
PlotCode,"/*_ID/plotevent/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}","Brad: Same as plotCode, above"
4 
NoInd,//*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
4 
NoInd,//*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 5 
cover_percent,//collectiveobs/cover,
6 6 
intercept_cm,"//collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
7 7 
ht_first_branch_m,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
......
27 27 
infra_rank_1,"/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first",
28 28 
infra_ep_1,"/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last",
29 29 
OrigFamily,"/taxondetermination[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName",Brad: OMIT
30 
OrigSpecies,"/{taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
30 31 
PlotObsID,"/{taxondetermination[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
31 
OrigSpecies,"/{taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
mappings/for_review/VegX-VegBIEN.organisms.csv
49 49 
//geospatial/maximumDepthInMeters,//waterDepth/max
50 50 
//geospatial/minimumDepthInMeters,//waterDepth/min
51 51 
//plot/plotUniqueIdentifier,"/*_ID/plotevent/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}"
52 
/simpleUserdefined[name=count]/value,//*/stemCount
52 
/simpleUserdefined[name=count]/value,//*/stemCount/_alt/1
53 53 
/simpleUserdefined[name=coverPercent]/value,//collectiveobs/cover
54 54 
/simpleUserdefined[name=interceptCm]/value,"//collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]]/definedValue"
55 55 
/simpleUserdefined[name=habitat]/value,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]]/definedValue"
......
102 102 
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
103 103 
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName"
104 104 
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName"
105 
//taxonNameUsageConcept/voucher,"/{taxondetermination[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}"
106 105 
//taxonName/Simple,"/{taxondetermination[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}"
107 106 
//*s/taxonConcept[@code=sp]/Name,"/{taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}"
107 
//taxonNameUsageConcept/voucher,"/{taxondetermination[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}"
mappings/for_review/NYBG-VegBank.organisms.csv
14 14 
YearCollected,//observation/obsStartDate/_date/year,
15 15 
MaximumDepth,//waterDepth/max,
16 16 
MinimumDepth,//waterDepth/min,
17 
:1,//*/stemCount,
17 
:1,//*/stemCount/_alt/1,
18 18 
Habitat,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
19 19 
PlantFungusDescription,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue","Brad: Incorrect mapping to VB, also possibly to VX;  this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
20 20 
Substrate,"//stemLocation/definedValue[*_ID/userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
......
37 37 
ScientificNameAuthor,"/taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author"
38 38 
Phylum,"/taxonInterpretation[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName",
39 39 
Subspecies,"/taxonInterpretation[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName",
40 
UniqueNYInternalRecordNumber,"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
41 40 
ScientificName,"/{taxonInterpretation[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
42 41 
Species,"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",
42 
UniqueNYInternalRecordNumber,"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
mappings/for_review/NYBG-VegBIEN.organisms.csv
14 14 
YearCollected,//plotevent/obsStartDate/_date/year,
15 15 
MaximumDepth,//waterDepth/max,
16 16 
MinimumDepth,//waterDepth/min,
17 
:1,//*/stemCount,
17 
:1,//*/stemCount/_alt/1,
18 18 
Habitat,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
19 19 
PlantFungusDescription,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=plantFungusDescription]]/definedValue","Brad: Incorrect mapping to VB, also possibly to VX;  this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
20 20 
Substrate,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=substrate]]/definedValue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
......
37 37 
ScientificNameAuthor,"/taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author"
38 38 
Phylum,"/taxondetermination[roleCode=identifier,plantLevel=Subkingdom]/*_ID/plantConcept/*_ID/*/plantName",
39 39 
Subspecies,"/taxondetermination[roleCode=identifier,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName",
40 
UniqueNYInternalRecordNumber,"/{taxondetermination[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
41 40 
ScientificName,"/{taxondetermination[roleCode=identifier]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
42 41 
Species,"/{taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",
42 
UniqueNYInternalRecordNumber,"/{taxondetermination[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
mappings/for_review/SALVIAS-VegBank.organisms.csv
2 2 
plot_code,//plot/authorPlotCode/_alt/1,"Brad: Same as plotCode, above"
3 3 
census_date,//observation/obsStartDate/_date/year,
4 4 
subplot,"/*_ID/observation/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}",
5 
no_of_individuals,//*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 
no_of_individuals,//*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
6 6 
cover_percent,//taxonImportance/cover,
7 7 
intercept_cm,"//taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
8 8 
stem_dbh,//stemCount/stemDiameter,
......
36 36 
infra_rank_1,"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first",
37 37 
infra_ep_1,"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last",
38 38 
orig_family,"/taxonInterpretation[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName",Brad: OMIT
39 
orig_species,"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
39 40 
OBSERVATION_ID,"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
40 
orig_species,"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
mappings/for_review/SALVIAS-VegBIEN.organisms.csv
2 2 
plot_code,//plot/authorPlotCode/_alt/1,"Brad: Same as plotCode, above"
3 3 
census_date,//plotevent/obsStartDate/_date/year,
4 4 
subplot,"/*_ID/plotevent/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}",
5 
no_of_individuals,//*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 
no_of_individuals,//*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
6 6 
cover_percent,//collectiveobs/cover,
7 7 
intercept_cm,"//collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
8 8 
ht_first_branch_m,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
......
36 36 
infra_rank_1,"/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first",
37 37 
infra_ep_1,"/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last",
38 38 
orig_family,"/taxondetermination[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName",Brad: OMIT
39 
orig_species,"/{taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
39 40 
OBSERVATION_ID,"/{taxondetermination[roleCode=collector]/museumAccessionNumber,*_ID/plotevent/*_ID/plot/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
40 
orig_species,"/{taxondetermination[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxondetermination[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
mappings/for_review/SALVIAS_db-VegBank.organisms.csv
1 1 
SALVIAS:plotObservations,VegBank:/taxonObservation,Comments
2 2 
census_date,//observation/obsStartDate/_date/year,
3 3 
PlotCode,"/*_ID/observation/{*_ID/plot/authorPlotCode/_alt/2,authorObsCode}","Brad: Same as plotCode, above"
4 
NoInd,//*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
4 
NoInd,//*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 5 
cover_percent,//taxonImportance/cover,
6 6 
intercept_cm,"//taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
7 7 
temp_dbh,//stemCount/stemDiameter,
......
27 27 
infra_rank_1,"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first",
28 28 
infra_ep_1,"/taxonInterpretation[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last",
29 29 
OrigFamily,"/taxonInterpretation[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName",Brad: OMIT
30 
OrigSpecies,"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
30 31 
PlotObsID,"/{taxonInterpretation[roleCode=collector]/museumAccessionNumber,*_ID/observation/*_ID/plot/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
31 
OrigSpecies,"/{taxonInterpretation[roleCode=identifier,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName,taxonInterpretation[roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
mappings/NYBG-VegBIEN.organisms.csv
14 14 
YearCollected,/*_ID/plotevent/obsStartDate/_date/year,
15 15 
MaximumDepth,/*_ID/plotevent/waterDepth/max,
16 16 
MinimumDepth,/*_ID/plotevent/waterDepth/min,
17 
:1,/collectiveobs/*/stemCount,
17 
:1,/collectiveobs/*/stemCount/_alt/1,
18 18 
Habitat,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
19 19 
PlantFungusDescription,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB, also possibly to VX;  this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"
20 20 
Substrate,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"
......
37 37 
ScientificNameAuthor,"/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]/*_ID/plantConcept/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author"
38 38 
Phylum,"/taxondetermination[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",
39 39 
Subspecies,"/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",
40 
UniqueNYInternalRecordNumber,"/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
41 40 
ScientificName,"/{taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
42 41 
Species,"/{taxondetermination[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,taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",
42 
UniqueNYInternalRecordNumber,":[collectiveobs/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
mappings/SALVIAS-VegBank.organisms.csv
2 2 
plot_code,/*_ID/observation/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1,"Brad: Same as plotCode, above"
3 3 
census_date,/*_ID/observation/obsStartDate/_date/year,
4 4 
subplot,"/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}",
5 
no_of_individuals,/taxonImportance/*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 
no_of_individuals,/taxonImportance/*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
6 6 
cover_percent,/taxonImportance/cover,
7 7 
intercept_cm,"/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
8 8 
stem_dbh,/taxonImportance/stemCount/stemDiameter,
......
36 36 
infra_rank_1,"/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",
37 37 
infra_ep_1,"/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",
38 38 
orig_family,"/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",Brad: OMIT
39 
OBSERVATION_ID,"/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
40 39 
orig_species,"/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
40 
OBSERVATION_ID,":[taxonImportance/*/stemCount/_alt/2=1]/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/SALVIAS-VegBIEN.organisms.csv
2 2 
plot_code,/*_ID/plotevent/*_ID/plot/PARENT_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/1,"Brad: Same as plotCode, above"
3 3 
census_date,/*_ID/plotevent/obsStartDate/_date/year,
4 4 
subplot,"/*_ID/plotevent/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}",
5 
no_of_individuals,/collectiveobs/*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 
no_of_individuals,/collectiveobs/*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
6 6 
cover_percent,/collectiveobs/cover,
7 7 
intercept_cm,"/collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
8 8 
ht_first_branch_m,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
......
36 36 
infra_rank_1,"/taxondetermination[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",
37 37 
infra_ep_1,"/taxondetermination[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",
38 38 
orig_family,"/taxondetermination[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",Brad: OMIT
39 
OBSERVATION_ID,"/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
40 39 
orig_species,"/{taxondetermination[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,taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
40 
OBSERVATION_ID,":[collectiveobs/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/SALVIAS_db-VegBank.organisms.csv
1 1 
SALVIAS:plotObservations,VegBank:/taxonObservation,Comments
2 2 
census_date,/*_ID/observation/obsStartDate/_date/year,
3 3 
PlotCode,"/*_ID/observation/{*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/2,authorObsCode}","Brad: Same as plotCode, above"
4 
NoInd,/taxonImportance/*/stemCount,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
4 
NoInd,/taxonImportance/*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
5 5 
cover_percent,/taxonImportance/cover,
6 6 
intercept_cm,"/taxonImportance/definedValue[*_ID/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
7 7 
temp_dbh,/taxonImportance/stemCount/stemDiameter,
......
27 27 
infra_rank_1,"/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",
28 28 
infra_ep_1,"/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",
29 29 
OrigFamily,"/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",Brad: OMIT
30 
PlotObsID,"/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
31 30 
OrigSpecies,"/{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,taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept/*_ID/*/plantName/_alt/2}",Brad: OMIT
31 
PlotObsID,":[taxonImportance/*/stemCount/_alt/2=1]/{taxonInterpretation[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/observation/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."

Also available in: Unified diff