for attr_idx in xrange(self.attributes.length):

        for i in reversed(xrange(len(tree))):

            elem = tree[i]

                try: elem.name = before+tree[i+offset].name+after

    for try_num in xrange(2):

        line = re.sub(r'(?i)(\w+)(?=\w*(?:->/[^/]*)?/\1\b)', r'*', line)

        line = re.sub(r'(?i)((\w+)->/[^/]*/[^/]*\[)\2', r'\1*', line)

    for i in xrange(len(configs)):

        for i in xrange(len(configs)): row[i] = configs[i]['root']+row[i]

            if not row[1].startswith(configs[1]['prefix']):

                raise SystemExit('Map error: Root "'+configs[1]['prefix']

                    +'" is not contained in output mapping: '+row[1])

            for i in xrange(len(configs)):

head -$n NYSpecimenDataAmericas.csv|../map \

../../mappings/NYBG-VegX.organisms.csv >NYSpecimenDataAmericas.test.xml

"VegX/*s/individualOrganismObservation/","VegBank/taxonObservation/"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName"

"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber"

"*ID->/*s/individualOrganism/identificationLabel","taxonImportance/stemCount/stemLocation/stemCode"

"*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","*_ID/observation/soilObs/soilPH"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","*_ID/observation/soilObs/soilClay"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","*_ID/observation/soilObs/soilOrganic"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","*_ID/observation/soilObs/soilSand"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","*_ID/observation/soilObs/soilSilt"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"

"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","*_ID/observation/soilObs/soilTexture"

"*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value","taxonImportance/*/stemCount"

"*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","*_ID/observation/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName"

"*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription"

"*ID->/*s/plotObservation/*ID->/*s/project/title","*_ID/observation/*_ID/project/projectName"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area","*_ID/observation/*_ID/plot/area"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters","*_ID/observation/*_ID/plot/locationAccuracy"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","*_ID/observation/*_ID/plot/realLatitude"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","*_ID/observation/*_ID/plot/realLongitude"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT","*_ID/observation/*_ID/plot/dsgpoly"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","*_ID/observation/waterDepth/max"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","*_ID/observation/waterDepth/min"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","*_ID/observation/*_ID/plot/elevation"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","*_ID/observation/*_ID/plot/authorPlotCode"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","*_ID/observation/*_ID/plot/slopeAspect"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","*_ID/observation/*_ID/plot/slopeGradient"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName"

"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName"

"*ID->/*s/plotObservation/obsEndDate","*_ID/observation/obsEndDate"

"*ID->/*s/plotObservation/obsStartDate","*_ID/observation/obsStartDate"

"*ID->/*s/plotObservation/obsStartDate/_date/day","*_ID/observation/obsStartDate/_date/day"

"*ID->/*s/plotObservation/obsStartDate/_date/month","*_ID/observation/obsStartDate/_date/month"

"*ID->/*s/plotObservation/obsStartDate/_date/year","*_ID/observation/obsStartDate/_date/year"

"*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","*_ID/observation/methodNarrative"

"*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"

"*ID->/*s/plotObservation/temperature","*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"

"diameterBaseDistance[baseDistance=0]/diameter","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"

"diameterBaseDistance[baseDistance=1.37]/diameter","taxonImportance/stemCount/stemDiameter"

"height","taxonImportance/stemCount/stemHeight"

"simpleUserdefined[name=censusNo]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"

"simpleUserdefined[name=coverPercent]/value","taxonImportance/cover"

"simpleUserdefined[name=habit]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"

"simpleUserdefined[name=habitat]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"

"simpleUserdefined[name=htFirstBranchM]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"

"simpleUserdefined[name=individualCode]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"

"simpleUserdefined[name=interceptCm]/value","taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"

"simpleUserdefined[name=plantFungusDescription]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"

"simpleUserdefined[name=stemCanopyForm]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"

"simpleUserdefined[name=stemCanopyPosition]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"

"simpleUserdefined[name=stemHeightFirstBranchM]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"

"simpleUserdefined[name=stemHeightM]/value","taxonImportance/stemCount/stemHeight"

"simpleUserdefined[name=stemLianaInfestation]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"

"simpleUserdefined[name=substrate]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"

"simpleUserdefined[name=vegetation]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"

"simpleUserdefined[name=xPosition]/value","taxonImportance/stemCount/stemLocation/stemXPosition"

"simpleUserdefined[name=yPosition]/value","taxonImportance/stemCount/stemLocation/stemYPosition"

"NYBG","VegX/*s/individualOrganismObservation/"

"key",

"DateLastModified",

"InstitutionCode","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName"

"CollectionCode","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName"

"CatalogNumber","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"

"ScientificName","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"

"BasisOfRecord",

"Kingdom","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"

"Phylum","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"

"Class","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"

"Order","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"

"Family","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"

"Genus","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"

"Species","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"

"Subspecies","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"

"ScientificNameAuthor","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"

"IdentifiedBy","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}"

"YearIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year"

"MonthIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month"

"DayIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day"

"TypeStatus",

"CollectorNumber",

"FieldNumber","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"

"Collector","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}"

"YearCollected","*ID->/*s/plotObservation/obsStartDate/_date/year"

"MonthCollected","*ID->/*s/plotObservation/obsStartDate/_date/month"

"DayCollected","*ID->/*s/plotObservation/obsStartDate/_date/day"

"JulianDay",

"TimeOfDay",

"ContinentOcean",

"Country","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country"

"StateProvince","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state"

"County","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county"

"Locality","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value"

"Longitude","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"

"Latitude","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"

"CoordinatePrecision","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters"

"BoundingBox","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT"

"MinimumElevation","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"

"MaximumElevation","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"

"MinimumDepth","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters"

"MaximumDepth","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters"

"Sex","*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value"

"PreparationType",

"IndividualCount",

"PreviousCatalogNumber",

"RelationshipType",

"RelatedCatalogItem",

"Notes","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"

"Habitat","simpleUserdefined[name=habitat]/value"

"PlantFungusDescription","simpleUserdefined[name=plantFungusDescription]/value"

"Substrate","simpleUserdefined[name=substrate]/value"

"Vegetation","simpleUserdefined[name=vegetation]/value"

"UniqueNYInternalRecordNumber",

NYBG,VegBank/taxonObservation/

InstitutionCode,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName

CollectionCode,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName

CatalogNumber,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber

ScientificName,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName

Kingdom,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName

Phylum,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName

Class,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName

Order,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName

Family,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName

Genus,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName

Species,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName

Subspecies,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName

ScientificNameAuthor,"taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"

IdentifiedBy,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}"

YearIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year

MonthIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month

DayIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day

FieldNumber,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber

Collector,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}"

YearCollected,*_ID/observation/obsStartDate/_date/year

MonthCollected,*_ID/observation/obsStartDate/_date/month

DayCollected,*_ID/observation/obsStartDate/_date/day

Country,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName

StateProvince,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName

County,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName

Locality,*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription

Longitude,*_ID/observation/*_ID/plot/realLongitude

Latitude,*_ID/observation/*_ID/plot/realLatitude

CoordinatePrecision,*_ID/observation/*_ID/plot/locationAccuracy

BoundingBox,*_ID/observation/*_ID/plot/dsgpoly

MinimumElevation,"*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}"

MaximumElevation,"*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}"

MinimumDepth,*_ID/observation/waterDepth/min

MaximumDepth,*_ID/observation/waterDepth/max

Sex,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"

Notes,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes

Habitat,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"

PlantFungusDescription,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"

Substrate,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"

Vegetation,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"

SALVIAS,VegBank/observation/

project,*_ID/project/projectName

plot_code,"{*_ID/plot/authorPlotCode,authorObsCode}"

major_geo,*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName

country,*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName

pol1,*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName

pol2,*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName

locality_description,*_ID/plot/place/*_ID/namedPlace/placeDescription

lat_decimal,*_ID/plot/realLatitude

long_decimal,*_ID/plot/realLongitude

elev_m,*_ID/plot/elevation

elev_max_m,"*_ID/plot/{elevation/max,elevationRange/to}"

elev_min_m,"*_ID/plot/{elevation/min,elevationRange/from}"

temp_c,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=tempC]]/definedValue"

precip_mm,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipMm]]/definedValue"

slope_aspect,*_ID/plot/slopeAspect

slope_gradient,*_ID/plot/slopeGradient

plot_methodology,methodNarrative

plot_area_ha,*_ID/plot/area

date_start,obsStartDate

date_finish,obsEndDate

SALVIAS,VegBank/taxonObservation/

OBSERVATION_ID,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber

plot_code,*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode

census_no,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"

census_date,*_ID/observation/obsStartDate

subplot,"*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"

individual_code,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"

tag1,taxonImportance/stemCount/stemLocation/stemCode

tag2,taxonImportance/stemCount/stemLocation/stemCode

x_position,taxonImportance/stemCount/stemLocation/stemXPosition

y_position,taxonImportance/stemCount/stemLocation/stemYPosition

voucher_string,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber

coll_number,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber

coll_lastname,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName

coll_firstname,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName

det_type,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"

family,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName

genus,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName

specific_epithet,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName

specific_authority,"taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}"

infra_rank_1,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank

infra_ep_1,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet

cf_aff,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"

habit,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"

no_of_individuals,taxonImportance/*/stemCount

cover_percent,taxonImportance/cover

intercept_cm,"taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"

height_m,taxonImportance/stemCount/stemHeight

ht_first_branch_m,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"

stem_tag1,taxonImportance/stemCount/stemLocation/stemCode

stem_tag2,taxonImportance/stemCount/stemLocation/stemCode

stem_dbh,taxonImportance/stemCount/stemDiameter

basal_diam,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"

stem_height_m,taxonImportance/stemCount/stemHeight

stem_height_first_branch_m,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"

stem_canopy_form,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"

stem_canopy_position,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"

stem_liana_infestation,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"

notes,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes

"SALVIAS","VegX/*s/plotObservation/"

"project","*ID->/*s/project/title"

"PLOT_ID",

"plot_code","*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"

"major_geo","*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value"

"country","*UniqueIdentifierID->/*s/plot/country"

"pol1","*UniqueIdentifierID->/*s/plot/state"

"pol2","*UniqueIdentifierID->/*s/plot/county"

"locality_description","*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value"

"lat_decimal","*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"

"long_decimal","*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"

"elev_m","*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation"

"elev_max_m","*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"

"elev_min_m","*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"

"temp_c","temperature"

"precip_mm","simpleUserdefined[name=precipMm]/value"

"slope_aspect","*UniqueIdentifierID->/*s/plot/slopeAspect"

"slope_gradient","*UniqueIdentifierID->/*s/plot/slopeGradient"

"clay_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value"

"silt_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value"

"sand_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value"

"organic_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value"

"pH","/*s/plotObservation->/*s/abioticObservation[*ID]/ph"

"soil_N","/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen"

"soil_P","/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus"

"soil_C","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value"

"soil_K","/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium"

"soil_Mg","/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium"

"soil_Ca","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value"

"soil_Na","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value"

"soil_acidity","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value"

"soil_base","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value"

"soil_cation_cap","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value"

"soil_conductivity","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value"

"soil_texture","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value"

"holdridge_life_zone","/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name"

"life_zone_code","/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName"

"observation_type",

"plot_methodology","simpleUserdefined[name=plotMethodology]/value"

"plot_area_ha","*UniqueIdentifierID->/*s/plot/area"

"recensused",

"date_start","obsStartDate"

"date_finish","obsEndDate"

"SALVIAS","VegX/*s/individualOrganismObservation/"

"OBSERVATION_ID","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"

"PLOT_ID",

"plot_code","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier"

"census_no","simpleUserdefined[name=censusNo]/value"

"census_date","*ID->/*s/plotObservation/obsStartDate"

"subplot","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"

"individual_code","simpleUserdefined[name=individualCode]/value"

"ind_id",

"tag1","*ID->/*s/individualOrganism/identificationLabel"

"tag2","*ID->/*s/individualOrganism/identificationLabel"

"x_position","simpleUserdefined[name=xPosition]/value"

"y_position","simpleUserdefined[name=yPosition]/value"

"voucher_string","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"

"coll_number","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"

"collector_code",

"coll_lastname","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName"

"coll_firstname","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName"

"det_type","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType"

"fam_status",

"gen_status",

"species_status",

"family","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"

"genus","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"

"specific_epithet","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"

"specific_authority","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"

"infra_rank_1","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank"

"infra_ep_1","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name"

"cf_aff","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note"

"comments",

"habit","simpleUserdefined[name=habit]/value"

"no_of_individuals","*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value"

"cover_percent","simpleUserdefined[name=coverPercent]/value"

"intercept_cm","simpleUserdefined[name=interceptCm]/value"

"height_m","height"

"ht_first_branch_m","simpleUserdefined[name=htFirstBranchM]/value"

"stem_tag1","*ID->/*s/individualOrganism/identificationLabel"

"stem_tag2","*ID->/*s/individualOrganism/identificationLabel"

"stem_dbh","diameterBaseDistance[baseDistance=1.37]/diameter"

"basal_diam","diameterBaseDistance[baseDistance=0]/diameter"

"stem_height_m","simpleUserdefined[name=stemHeightM]/value"

"stem_height_first_branch_m","simpleUserdefined[name=stemHeightFirstBranchM]/value"

"stem_canopy_form","simpleUserdefined[name=stemCanopyForm]/value"

"stem_canopy_position","simpleUserdefined[name=stemCanopyPosition]/value"

"stem_liana_infestation","simpleUserdefined[name=stemLianaInfestation]/value"

"notes","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"

"orig_family",

"orig_species",

#!/bin/bash

# Joins all *-VegX.csv to VegX-VegBank.csv

selfDir="$(dirname -- "$0")"

cd "$selfDir"

for map in *-VegX.*.csv; do

    type="${map%.csv}" # remove extension

    type="${type#*.}" # remove up to last "."

    ../scripts/util/join_maps "VegX-VegBank.$type.csv" <"$map" \

    >"joins/${map/VegX/VegBank}"

done

right_in_root='/taxonObservation/*_ID/observation/' \

right_out_root='/observation/'

VegX/*s/plotObservation/,VegBank/observation/

*ID->/*s/project/title,*_ID/project/projectName

*UniqueIdentifierID->/*s/plot/area,*_ID/plot/area

*UniqueIdentifierID->/*s/plot/country,*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName

*UniqueIdentifierID->/*s/plot/county,*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName

*UniqueIdentifierID->/*s/plot/county,*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName

*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,*_ID/plot/locationAccuracy

*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,*_ID/plot/realLatitude

*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,*_ID/plot/realLongitude

*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,*_ID/plot/dsgpoly

*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,waterDepth/max

*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"*_ID/plot/{elevation/max,elevationRange/to}"

*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,waterDepth/min

*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"*_ID/plot/{elevation/min,elevationRange/from}"

*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,*_ID/plot/elevation

*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,*_ID/plot/authorPlotCode

*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"{*_ID/plot/authorPlotCode,authorObsCode}"

*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode

*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,*_ID/plot/place/*_ID/namedPlace/placeDescription

*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,*_ID/plot/place/*_ID/namedPlace/placeDescription

*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName

*UniqueIdentifierID->/*s/plot/slopeAspect,*_ID/plot/slopeAspect

*UniqueIdentifierID->/*s/plot/slopeGradient,*_ID/plot/slopeGradient

*UniqueIdentifierID->/*s/plot/state,*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName

*UniqueIdentifierID->/*s/plot/state,*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName

obsEndDate,obsEndDate

obsStartDate,obsStartDate

obsStartDate/_date/day,obsStartDate/_date/day

obsStartDate/_date/month,obsStartDate/_date/month

obsStartDate/_date/year,obsStartDate/_date/year

simpleUserdefined[name=plotMethodology]/value,methodNarrative

simpleUserdefined[name=precipMm]/value,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipMm]]/definedValue"

temperature,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=tempC]]/definedValue"