Project

General

Profile

« Previous | Next » 

Revision 72

Fixed ch_map_root to support subpaths which follow the root by -> rather than /. Changed spreadsheet syntax to have : between label and root.

View differences:

scripts/map
43 43
        map_reader = csv.reader(map_stream)
44 44
        src, dest = map_reader.next()[:2]
45 45
        def split_col_name(name):
46
            name, sep, root = name.partition('/')
47
            return name, sep != '', sep+root
46
            name, sep, root = name.partition(':')
47
            return name, sep != '', root
48 48
        src, in_is_xml, src_root = split_col_name(src)
49 49
        dest, out_is_xml, dest_root = split_col_name(dest)
50 50
        assert out_is_xml
scripts/util/ch_map_root
3 3

  
4 4
import csv
5 5
import os.path
6
import re
6 7
import sys
7 8

  
8 9
sys.path.append(os.path.dirname(__file__)+"/../lib")
......
27 28
    cols = reader.next()
28 29
    for i in xrange(len(configs)):
29 30
        config = configs[i]
30
        config['root'] = cols[i]
31
        label = cols[i].partition('/')[0]
32
        config['prefix'] = label+config['in_root']
33
        config['prefix_len'] = len(config['prefix'])
34
        cols[i] = label+config['out_root']
31
        label, sep, config['root'] = cols[i].partition(':')
32
        cols[i] = label+sep+config['out_root']
33
        config['in_root_re'] = r'^'+re.escape(config['in_root'])+r'\b'
35 34
    writer.writerow(cols)
36 35
    for row in reader:
37 36
        for i in xrange(len(configs)): row[i] = configs[i]['root']+row[i]
38
        if row[0].startswith(configs[0]['prefix']):
39
            if not row[1].startswith(configs[1]['prefix']):
40
                raise SystemExit('Map error: Root "'+configs[1]['prefix']
41
                    +'" is not contained in output mapping: '+row[1])
42
            for i in xrange(len(configs)):
43
                row[i] = row[i][configs[i]['prefix_len']:]
37
        def sub(i):
38
            row[i], n = re.subn(configs[i]['in_root_re'], r'', row[i])
39
            return n > 0
40
        if sub(0):
41
            if not sub(1): raise SystemExit('Map error: Root "'
42
                +configs[1]['in_root']+'" is not contained in output mapping: '
43
                +row[1])
44 44
            writer.writerow(row)
45 45

  
46 46
main()
mappings/VegX-VegBank.organisms.csv
1
"VegX/*s/individualOrganismObservation/","VegBank/taxonObservation/"
2
"*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"
3
"*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"
4
"*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"
5
"*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"
6
"*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}"
7
"*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"
8
"*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"
9
"*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"
10
"*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"
11
"*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"
12
"*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"
13
"*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"
14
"*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"
15
"*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"
16
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName"
17
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName"
18
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
19
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName"
20
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName"
21
"*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"
22
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day"
23
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month"
24
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year"
25
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}"
26
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}"
27
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber"
28
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes"
29
"*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"
30
"*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"
31
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber"
32
"*ID->/*s/individualOrganism/identificationLabel","taxonImportance/stemCount/stemLocation/stemCode"
33
"*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
34
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
35
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
36
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","*_ID/observation/soilObs/soilPH"
37
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
38
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
39
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
40
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
41
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
42
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
43
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
44
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","*_ID/observation/soilObs/soilClay"
45
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
46
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","*_ID/observation/soilObs/soilOrganic"
47
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","*_ID/observation/soilObs/soilSand"
48
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","*_ID/observation/soilObs/soilSilt"
49
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
50
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","*_ID/observation/soilObs/soilTexture"
51
"*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value","taxonImportance/*/stemCount"
52
"*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","*_ID/observation/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName"
53
"*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription"
54
"*ID->/*s/plotObservation/*ID->/*s/project/title","*_ID/observation/*_ID/project/projectName"
55
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area","*_ID/observation/*_ID/plot/area"
56
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName"
57
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName"
58
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName"
59
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters","*_ID/observation/*_ID/plot/locationAccuracy"
60
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","*_ID/observation/*_ID/plot/realLatitude"
61
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","*_ID/observation/*_ID/plot/realLongitude"
62
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT","*_ID/observation/*_ID/plot/dsgpoly"
63
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","*_ID/observation/waterDepth/max"
64
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}"
65
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","*_ID/observation/waterDepth/min"
66
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}"
67
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","*_ID/observation/*_ID/plot/elevation"
68
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","*_ID/observation/*_ID/plot/authorPlotCode"
69
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"
70
"*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"
71
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
72
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
73
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName"
74
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","*_ID/observation/*_ID/plot/slopeAspect"
75
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","*_ID/observation/*_ID/plot/slopeGradient"
76
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName"
77
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName"
78
"*ID->/*s/plotObservation/obsEndDate","*_ID/observation/obsEndDate"
79
"*ID->/*s/plotObservation/obsStartDate","*_ID/observation/obsStartDate"
80
"*ID->/*s/plotObservation/obsStartDate/_date/day","*_ID/observation/obsStartDate/_date/day"
81
"*ID->/*s/plotObservation/obsStartDate/_date/month","*_ID/observation/obsStartDate/_date/month"
82
"*ID->/*s/plotObservation/obsStartDate/_date/year","*_ID/observation/obsStartDate/_date/year"
83
"*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","*_ID/observation/methodNarrative"
84
"*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
85
"*ID->/*s/plotObservation/temperature","*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
86
"diameterBaseDistance[baseDistance=0]/diameter","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
87
"diameterBaseDistance[baseDistance=1.37]/diameter","taxonImportance/stemCount/stemDiameter"
88
"height","taxonImportance/stemCount/stemHeight"
89
"simpleUserdefined[name=censusNo]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
90
"simpleUserdefined[name=coverPercent]/value","taxonImportance/cover"
91
"simpleUserdefined[name=habit]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
92
"simpleUserdefined[name=habitat]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
93
"simpleUserdefined[name=htFirstBranchM]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
94
"simpleUserdefined[name=individualCode]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
95
"simpleUserdefined[name=interceptCm]/value","taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
96
"simpleUserdefined[name=plantFungusDescription]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
97
"simpleUserdefined[name=stemCanopyForm]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
98
"simpleUserdefined[name=stemCanopyPosition]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
99
"simpleUserdefined[name=stemHeightFirstBranchM]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
100
"simpleUserdefined[name=stemHeightM]/value","taxonImportance/stemCount/stemHeight"
101
"simpleUserdefined[name=stemLianaInfestation]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
102
"simpleUserdefined[name=substrate]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
103
"simpleUserdefined[name=vegetation]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
104
"simpleUserdefined[name=xPosition]/value","taxonImportance/stemCount/stemLocation/stemXPosition"
105
"simpleUserdefined[name=yPosition]/value","taxonImportance/stemCount/stemLocation/stemYPosition"
1
"VegX:/*s/individualOrganismObservation","VegBank:/taxonObservation"
2
"/*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"
3
"/*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"
4
"/*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"
5
"/*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"
6
"/*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"
7
"/*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"
8
"/*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}"
9
"/*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"
10
"/*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"
11
"/*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"
12
"/*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"
13
"/*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"
14
"/*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"
15
"/*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"
16
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName"
17
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName"
18
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
19
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName"
20
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName"
21
"/*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"
22
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day"
23
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month"
24
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year"
25
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}"
26
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}"
27
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber"
28
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes"
29
"/*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"
30
"/*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"
31
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber"
32
"/*ID->/*s/individualOrganism/identificationLabel","/taxonImportance/stemCount/stemLocation/stemCode"
33
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
34
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
35
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
36
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs/soilPH"
37
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
38
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
39
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
40
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
41
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
42
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
43
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
44
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/*_ID/observation/soilObs/soilClay"
45
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
46
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/*_ID/observation/soilObs/soilOrganic"
47
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/*_ID/observation/soilObs/soilSand"
48
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/*_ID/observation/soilObs/soilSilt"
49
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
50
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/*_ID/observation/soilObs/soilTexture"
51
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","/*_ID/observation/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName"
52
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription"
53
"/*ID->/*s/plotObservation/*ID->/*s/project/title","/*_ID/observation/*_ID/project/projectName"
54
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area","/*_ID/observation/*_ID/plot/area"
55
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName"
56
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName"
57
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName"
58
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters","/*_ID/observation/*_ID/plot/locationAccuracy"
59
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","/*_ID/observation/*_ID/plot/realLatitude"
60
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","/*_ID/observation/*_ID/plot/realLongitude"
61
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT","/*_ID/observation/*_ID/plot/dsgpoly"
62
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","/*_ID/observation/waterDepth/max"
63
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","/*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}"
64
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","/*_ID/observation/waterDepth/min"
65
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","/*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}"
66
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","/*_ID/observation/*_ID/plot/elevation"
67
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/authorPlotCode"
68
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"
69
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode"
70
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
71
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription"
72
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName"
73
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","/*_ID/observation/*_ID/plot/slopeAspect"
74
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","/*_ID/observation/*_ID/plot/slopeGradient"
75
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName"
76
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName"
77
"/*ID->/*s/plotObservation/obsEndDate","/*_ID/observation/obsEndDate"
78
"/*ID->/*s/plotObservation/obsStartDate","/*_ID/observation/obsStartDate"
79
"/*ID->/*s/plotObservation/obsStartDate/_date/day","/*_ID/observation/obsStartDate/_date/day"
80
"/*ID->/*s/plotObservation/obsStartDate/_date/month","/*_ID/observation/obsStartDate/_date/month"
81
"/*ID->/*s/plotObservation/obsStartDate/_date/year","/*_ID/observation/obsStartDate/_date/year"
82
"/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","/*_ID/observation/methodNarrative"
83
"/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
84
"/*ID->/*s/plotObservation/temperature","/*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
85
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
86
"/diameterBaseDistance[baseDistance=1.37]/diameter","/taxonImportance/stemCount/stemDiameter"
87
"/height","/taxonImportance/stemCount/stemHeight"
88
"/simpleUserdefined[name=censusNo]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
89
"/simpleUserdefined[name=count]/value","/taxonImportance/*/stemCount"
90
"/simpleUserdefined[name=coverPercent]/value","/taxonImportance/cover"
91
"/simpleUserdefined[name=habit]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
92
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
93
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
94
"/simpleUserdefined[name=individualCode]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
95
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
96
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
97
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
98
"/simpleUserdefined[name=stemCanopyPosition]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
99
"/simpleUserdefined[name=stemHeightFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
100
"/simpleUserdefined[name=stemHeightM]/value","/taxonImportance/stemCount/stemHeight"
101
"/simpleUserdefined[name=stemLianaInfestation]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
102
"/simpleUserdefined[name=substrate]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
103
"/simpleUserdefined[name=vegetation]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
104
"/simpleUserdefined[name=xPosition]/value","/taxonImportance/stemCount/stemLocation/stemXPosition"
105
"/simpleUserdefined[name=yPosition]/value","/taxonImportance/stemCount/stemLocation/stemYPosition"
mappings/NYBG-VegX.organisms.csv
1
"NYBG","VegX/*s/individualOrganismObservation/"
1
"NYBG","VegX:/*s/individualOrganismObservation"
2 2
"key",
3 3
"DateLastModified",
4
"InstitutionCode","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName"
5
"CollectionCode","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName"
6
"CatalogNumber","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
7
"ScientificName","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
4
"InstitutionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName"
5
"CollectionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName"
6
"CatalogNumber","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
7
"ScientificName","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
8 8
"BasisOfRecord",
9
"Kingdom","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
10
"Phylum","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"
11
"Class","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"
12
"Order","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"
13
"Family","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
14
"Genus","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
15
"Species","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
16
"Subspecies","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"
17
"ScientificNameAuthor","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
18
"IdentifiedBy","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}"
19
"YearIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year"
20
"MonthIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month"
21
"DayIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day"
9
"Kingdom","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
10
"Phylum","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"
11
"Class","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"
12
"Order","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"
13
"Family","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
14
"Genus","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
15
"Species","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
16
"Subspecies","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"
17
"ScientificNameAuthor","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
18
"IdentifiedBy","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}"
19
"YearIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year"
20
"MonthIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month"
21
"DayIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day"
22 22
"TypeStatus",
23 23
"CollectorNumber",
24
"FieldNumber","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
25
"Collector","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}"
26
"YearCollected","*ID->/*s/plotObservation/obsStartDate/_date/year"
27
"MonthCollected","*ID->/*s/plotObservation/obsStartDate/_date/month"
28
"DayCollected","*ID->/*s/plotObservation/obsStartDate/_date/day"
24
"FieldNumber","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
25
"Collector","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}"
26
"YearCollected","/*ID->/*s/plotObservation/obsStartDate/_date/year"
27
"MonthCollected","/*ID->/*s/plotObservation/obsStartDate/_date/month"
28
"DayCollected","/*ID->/*s/plotObservation/obsStartDate/_date/day"
29 29
"JulianDay",
30 30
"TimeOfDay",
31 31
"ContinentOcean",
32
"Country","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country"
33
"StateProvince","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state"
34
"County","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county"
35
"Locality","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value"
36
"Longitude","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
37
"Latitude","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
38
"CoordinatePrecision","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters"
39
"BoundingBox","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT"
40
"MinimumElevation","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
41
"MaximumElevation","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
42
"MinimumDepth","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters"
43
"MaximumDepth","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters"
44
"Sex","*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value"
32
"Country","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country"
33
"StateProvince","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state"
34
"County","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county"
35
"Locality","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value"
36
"Longitude","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
37
"Latitude","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
38
"CoordinatePrecision","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters"
39
"BoundingBox","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT"
40
"MinimumElevation","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
41
"MaximumElevation","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
42
"MinimumDepth","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters"
43
"MaximumDepth","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters"
44
"Sex","/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value"
45 45
"PreparationType",
46 46
"IndividualCount",
47 47
"PreviousCatalogNumber",
48 48
"RelationshipType",
49 49
"RelatedCatalogItem",
50
"Notes","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
51
"Habitat","simpleUserdefined[name=habitat]/value"
52
"PlantFungusDescription","simpleUserdefined[name=plantFungusDescription]/value"
53
"Substrate","simpleUserdefined[name=substrate]/value"
54
"Vegetation","simpleUserdefined[name=vegetation]/value"
50
"Notes","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
51
"Habitat","/simpleUserdefined[name=habitat]/value"
52
"PlantFungusDescription","/simpleUserdefined[name=plantFungusDescription]/value"
53
"Substrate","/simpleUserdefined[name=substrate]/value"
54
"Vegetation","/simpleUserdefined[name=vegetation]/value"
55 55
"UniqueNYInternalRecordNumber",
mappings/joins/NYBG-VegBank.organisms.csv
1
NYBG,VegBank/taxonObservation/
2
InstitutionCode,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName
3
CollectionCode,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName
4
CatalogNumber,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber
5
ScientificName,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName
6
Kingdom,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName
7
Phylum,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName
8
Class,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName
9
Order,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName
10
Family,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName
11
Genus,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName
12
Species,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName
13
Subspecies,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName
14
ScientificNameAuthor,"taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
15
IdentifiedBy,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}"
16
YearIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year
17
MonthIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month
18
DayIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day
19
FieldNumber,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber
20
Collector,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}"
21
YearCollected,*_ID/observation/obsStartDate/_date/year
22
MonthCollected,*_ID/observation/obsStartDate/_date/month
23
DayCollected,*_ID/observation/obsStartDate/_date/day
24
Country,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName
25
StateProvince,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName
26
County,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
27
Locality,*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription
28
Longitude,*_ID/observation/*_ID/plot/realLongitude
29
Latitude,*_ID/observation/*_ID/plot/realLatitude
30
CoordinatePrecision,*_ID/observation/*_ID/plot/locationAccuracy
31
BoundingBox,*_ID/observation/*_ID/plot/dsgpoly
32
MinimumElevation,"*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}"
33
MaximumElevation,"*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}"
34
MinimumDepth,*_ID/observation/waterDepth/min
35
MaximumDepth,*_ID/observation/waterDepth/max
36
Sex,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
37
Notes,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes
38
Habitat,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
39
PlantFungusDescription,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
40
Substrate,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
41
Vegetation,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
1
NYBG,VegBank:/taxonObservation
2
InstitutionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName
3
CollectionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName
4
CatalogNumber,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber
5
ScientificName,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName
6
Kingdom,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName
7
Phylum,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName
8
Class,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName
9
Order,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName
10
Family,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName
11
Genus,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName
12
Species,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName
13
Subspecies,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName
14
ScientificNameAuthor,"/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}"
15
IdentifiedBy,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}"
16
YearIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year
17
MonthIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month
18
DayIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day
19
FieldNumber,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber
20
Collector,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}"
21
YearCollected,/*_ID/observation/obsStartDate/_date/year
22
MonthCollected,/*_ID/observation/obsStartDate/_date/month
23
DayCollected,/*_ID/observation/obsStartDate/_date/day
24
Country,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName
25
StateProvince,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName
26
County,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
27
Locality,/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription
28
Longitude,/*_ID/observation/*_ID/plot/realLongitude
29
Latitude,/*_ID/observation/*_ID/plot/realLatitude
30
CoordinatePrecision,/*_ID/observation/*_ID/plot/locationAccuracy
31
BoundingBox,/*_ID/observation/*_ID/plot/dsgpoly
32
MinimumElevation,"/*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}"
33
MaximumElevation,"/*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}"
34
MinimumDepth,/*_ID/observation/waterDepth/min
35
MaximumDepth,/*_ID/observation/waterDepth/max
36
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue"
37
Notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes
38
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue"
39
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue"
40
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue"
41
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue"
mappings/joins/SALVIAS-VegBank.plots.csv
1
SALVIAS,VegBank/observation/
2
project,*_ID/project/projectName
3
plot_code,"{*_ID/plot/authorPlotCode,authorObsCode}"
4
major_geo,*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
5
country,*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName
6
pol1,*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName
7
pol2,*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
8
locality_description,*_ID/plot/place/*_ID/namedPlace/placeDescription
9
lat_decimal,*_ID/plot/realLatitude
10
long_decimal,*_ID/plot/realLongitude
11
elev_m,*_ID/plot/elevation
12
elev_max_m,"*_ID/plot/{elevation/max,elevationRange/to}"
13
elev_min_m,"*_ID/plot/{elevation/min,elevationRange/from}"
14
temp_c,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
15
precip_mm,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
16
slope_aspect,*_ID/plot/slopeAspect
17
slope_gradient,*_ID/plot/slopeGradient
18
plot_methodology,methodNarrative
19
plot_area_ha,*_ID/plot/area
20
date_start,obsStartDate
21
date_finish,obsEndDate
1
SALVIAS,VegBank:/observation
2
project,/*_ID/project/projectName
3
plot_code,"/{*_ID/plot/authorPlotCode,authorObsCode}"
4
major_geo,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
5
country,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName
6
pol1,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName
7
pol2,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
8
locality_description,/*_ID/plot/place/*_ID/namedPlace/placeDescription
9
lat_decimal,/*_ID/plot/realLatitude
10
long_decimal,/*_ID/plot/realLongitude
11
elev_m,/*_ID/plot/elevation
12
elev_max_m,"/*_ID/plot/{elevation/max,elevationRange/to}"
13
elev_min_m,"/*_ID/plot/{elevation/min,elevationRange/from}"
14
temp_c,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
15
precip_mm,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
16
slope_aspect,/*_ID/plot/slopeAspect
17
slope_gradient,/*_ID/plot/slopeGradient
18
clay_percent,/soilObs/soilClay
19
silt_percent,/soilObs/soilSilt
20
sand_percent,/soilObs/soilSand
21
organic_percent,/soilObs/soilOrganic
22
pH,/soilObs/soilPH
23
soil_N,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
24
soil_P,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
25
soil_C,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
26
soil_K,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
27
soil_Mg,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
28
soil_Ca,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
29
soil_Na,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
30
soil_acidity,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
31
soil_base,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
32
soil_cation_cap,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
33
soil_conductivity,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
34
soil_texture,/soilObs/soilTexture
35
holdridge_life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription
36
life_zone_code,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
37
plot_methodology,/methodNarrative
38
plot_area_ha,/*_ID/plot/area
39
date_start,/obsStartDate
40
date_finish,/obsEndDate
mappings/joins/SALVIAS-VegBank.organisms.csv
1
SALVIAS,VegBank/taxonObservation/
2
OBSERVATION_ID,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber
3
plot_code,*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode
4
census_no,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
5
census_date,*_ID/observation/obsStartDate
6
subplot,"*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"
7
individual_code,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
8
tag1,taxonImportance/stemCount/stemLocation/stemCode
9
tag2,taxonImportance/stemCount/stemLocation/stemCode
10
x_position,taxonImportance/stemCount/stemLocation/stemXPosition
11
y_position,taxonImportance/stemCount/stemLocation/stemYPosition
12
voucher_string,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber
13
coll_number,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber
14
coll_lastname,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName
15
coll_firstname,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName
16
det_type,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"
17
family,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName
18
genus,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName
19
specific_epithet,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName
20
specific_authority,"taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}"
21
infra_rank_1,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank
22
infra_ep_1,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet
23
cf_aff,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"
24
habit,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
25
no_of_individuals,taxonImportance/*/stemCount
26
cover_percent,taxonImportance/cover
27
intercept_cm,"taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
28
height_m,taxonImportance/stemCount/stemHeight
29
ht_first_branch_m,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
30
stem_tag1,taxonImportance/stemCount/stemLocation/stemCode
31
stem_tag2,taxonImportance/stemCount/stemLocation/stemCode
32
stem_dbh,taxonImportance/stemCount/stemDiameter
33
basal_diam,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
34
stem_height_m,taxonImportance/stemCount/stemHeight
35
stem_height_first_branch_m,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
36
stem_canopy_form,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
37
stem_canopy_position,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
38
stem_liana_infestation,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
39
notes,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes
1
SALVIAS,VegBank:/taxonObservation
2
OBSERVATION_ID,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber
3
plot_code,/*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode
4
census_no,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue"
5
census_date,/*_ID/observation/obsStartDate
6
subplot,"/*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}"
7
individual_code,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue"
8
tag1,/taxonImportance/stemCount/stemLocation/stemCode
9
tag2,/taxonImportance/stemCount/stemLocation/stemCode
10
x_position,/taxonImportance/stemCount/stemLocation/stemXPosition
11
y_position,/taxonImportance/stemCount/stemLocation/stemYPosition
12
voucher_string,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber
13
coll_number,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber
14
coll_lastname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName
15
coll_firstname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName
16
det_type,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue"
17
family,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName
18
genus,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName
19
specific_epithet,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName
20
specific_authority,"/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}"
21
infra_rank_1,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank
22
infra_ep_1,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet
23
cf_aff,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue"
24
habit,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue"
25
no_of_individuals,/taxonImportance/*/stemCount
26
cover_percent,/taxonImportance/cover
27
intercept_cm,"/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue"
28
height_m,/taxonImportance/stemCount/stemHeight
29
ht_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue"
30
stem_tag1,/taxonImportance/stemCount/stemLocation/stemCode
31
stem_tag2,/taxonImportance/stemCount/stemLocation/stemCode
32
stem_dbh,/taxonImportance/stemCount/stemDiameter
33
basal_diam,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue"
34
stem_height_m,/taxonImportance/stemCount/stemHeight
35
stem_height_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue"
36
stem_canopy_form,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue"
37
stem_canopy_position,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue"
38
stem_liana_infestation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue"
39
notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes
mappings/SALVIAS-VegX.plots.csv
1
"SALVIAS","VegX/*s/plotObservation/"
2
"project","*ID->/*s/project/title"
1
"SALVIAS","VegX:/*s/plotObservation"
2
"project","/*ID->/*s/project/title"
3 3
"PLOT_ID",
4
"plot_code","*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
5
"major_geo","*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value"
6
"country","*UniqueIdentifierID->/*s/plot/country"
7
"pol1","*UniqueIdentifierID->/*s/plot/state"
8
"pol2","*UniqueIdentifierID->/*s/plot/county"
9
"locality_description","*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value"
10
"lat_decimal","*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
11
"long_decimal","*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
12
"elev_m","*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation"
13
"elev_max_m","*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
14
"elev_min_m","*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
15
"temp_c","temperature"
16
"precip_mm","simpleUserdefined[name=precipMm]/value"
17
"slope_aspect","*UniqueIdentifierID->/*s/plot/slopeAspect"
18
"slope_gradient","*UniqueIdentifierID->/*s/plot/slopeGradient"
19
"clay_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value"
20
"silt_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value"
21
"sand_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value"
22
"organic_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value"
23
"pH","/*s/plotObservation->/*s/abioticObservation[*ID]/ph"
24
"soil_N","/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen"
25
"soil_P","/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus"
26
"soil_C","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value"
27
"soil_K","/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium"
28
"soil_Mg","/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium"
29
"soil_Ca","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value"
30
"soil_Na","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value"
31
"soil_acidity","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value"
32
"soil_base","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value"
33
"soil_cation_cap","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value"
34
"soil_conductivity","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value"
35
"soil_texture","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value"
36
"holdridge_life_zone","/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name"
37
"life_zone_code","/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName"
4
"plot_code","/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
5
"major_geo","/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value"
6
"country","/*UniqueIdentifierID->/*s/plot/country"
7
"pol1","/*UniqueIdentifierID->/*s/plot/state"
8
"pol2","/*UniqueIdentifierID->/*s/plot/county"
9
"locality_description","/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value"
10
"lat_decimal","/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
11
"long_decimal","/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
12
"elev_m","/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation"
13
"elev_max_m","/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
14
"elev_min_m","/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
15
"temp_c","/temperature"
16
"precip_mm","/simpleUserdefined[name=precipMm]/value"
17
"slope_aspect","/*UniqueIdentifierID->/*s/plot/slopeAspect"
18
"slope_gradient","/*UniqueIdentifierID->/*s/plot/slopeGradient"
19
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value"
20
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value"
21
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value"
22
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value"
23
"pH","->/*s/abioticObservation[*ID]/ph"
24
"soil_N","->/*s/abioticObservation[*ID]/nitrogen"
25
"soil_P","->/*s/abioticObservation[*ID]/phosphorus"
26
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value"
27
"soil_K","->/*s/abioticObservation[*ID]/pottasium"
28
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium"
29
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value"
30
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value"
31
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value"
32
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value"
33
"soil_cation_cap","->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value"
34
"soil_conductivity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value"
35
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value"
36
"holdridge_life_zone","->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name"
37
"life_zone_code","->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName"
38 38
"observation_type",
39
"plot_methodology","simpleUserdefined[name=plotMethodology]/value"
40
"plot_area_ha","*UniqueIdentifierID->/*s/plot/area"
39
"plot_methodology","/simpleUserdefined[name=plotMethodology]/value"
40
"plot_area_ha","/*UniqueIdentifierID->/*s/plot/area"
41 41
"recensused",
42
"date_start","obsStartDate"
43
"date_finish","obsEndDate"
42
"date_start","/obsStartDate"
43
"date_finish","/obsEndDate"
mappings/SALVIAS-VegX.organisms.csv
1
"SALVIAS","VegX/*s/individualOrganismObservation/"
2
"OBSERVATION_ID","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
1
"SALVIAS","VegX:/*s/individualOrganismObservation"
2
"OBSERVATION_ID","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
3 3
"PLOT_ID",
4
"plot_code","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier"
5
"census_no","simpleUserdefined[name=censusNo]/value"
6
"census_date","*ID->/*s/plotObservation/obsStartDate"
7
"subplot","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
8
"individual_code","simpleUserdefined[name=individualCode]/value"
4
"plot_code","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier"
5
"census_no","/simpleUserdefined[name=censusNo]/value"
6
"census_date","/*ID->/*s/plotObservation/obsStartDate"
7
"subplot","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
8
"individual_code","/simpleUserdefined[name=individualCode]/value"
9 9
"ind_id",
10
"tag1","*ID->/*s/individualOrganism/identificationLabel"
11
"tag2","*ID->/*s/individualOrganism/identificationLabel"
12
"x_position","simpleUserdefined[name=xPosition]/value"
13
"y_position","simpleUserdefined[name=yPosition]/value"
14
"voucher_string","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
15
"coll_number","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
10
"tag1","/*ID->/*s/individualOrganism/identificationLabel"
11
"tag2","/*ID->/*s/individualOrganism/identificationLabel"
12
"x_position","/simpleUserdefined[name=xPosition]/value"
13
"y_position","/simpleUserdefined[name=yPosition]/value"
14
"voucher_string","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
15
"coll_number","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
16 16
"collector_code",
17
"coll_lastname","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName"
18
"coll_firstname","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName"
19
"det_type","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType"
17
"coll_lastname","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName"
18
"coll_firstname","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName"
19
"det_type","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType"
20 20
"fam_status",
21 21
"gen_status",
22 22
"species_status",
23
"family","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
24
"genus","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
25
"specific_epithet","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
26
"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"
27
"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"
28
"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"
29
"cf_aff","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note"
23
"family","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
24
"genus","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
25
"specific_epithet","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
26
"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"
27
"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"
28
"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"
29
"cf_aff","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note"
30 30
"comments",
31
"habit","simpleUserdefined[name=habit]/value"
32
"no_of_individuals","*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value"
33
"cover_percent","simpleUserdefined[name=coverPercent]/value"
34
"intercept_cm","simpleUserdefined[name=interceptCm]/value"
35
"height_m","height"
36
"ht_first_branch_m","simpleUserdefined[name=htFirstBranchM]/value"
37
"stem_tag1","*ID->/*s/individualOrganism/identificationLabel"
38
"stem_tag2","*ID->/*s/individualOrganism/identificationLabel"
39
"stem_dbh","diameterBaseDistance[baseDistance=1.37]/diameter"
40
"basal_diam","diameterBaseDistance[baseDistance=0]/diameter"
41
"stem_height_m","simpleUserdefined[name=stemHeightM]/value"
42
"stem_height_first_branch_m","simpleUserdefined[name=stemHeightFirstBranchM]/value"
43
"stem_canopy_form","simpleUserdefined[name=stemCanopyForm]/value"
44
"stem_canopy_position","simpleUserdefined[name=stemCanopyPosition]/value"
45
"stem_liana_infestation","simpleUserdefined[name=stemLianaInfestation]/value"
46
"notes","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
31
"habit","/simpleUserdefined[name=habit]/value"
32
"no_of_individuals","/simpleUserdefined[name=count]/value"
33
"cover_percent","/simpleUserdefined[name=coverPercent]/value"
34
"intercept_cm","/simpleUserdefined[name=interceptCm]/value"
35
"height_m","/height"
36
"ht_first_branch_m","/simpleUserdefined[name=htFirstBranchM]/value"
37
"stem_tag1","/*ID->/*s/individualOrganism/identificationLabel"
38
"stem_tag2","/*ID->/*s/individualOrganism/identificationLabel"
39
"stem_dbh","/diameterBaseDistance[baseDistance=1.37]/diameter"
40
"basal_diam","/diameterBaseDistance[baseDistance=0]/diameter"
41
"stem_height_m","/simpleUserdefined[name=stemHeightM]/value"
42
"stem_height_first_branch_m","/simpleUserdefined[name=stemHeightFirstBranchM]/value"
43
"stem_canopy_form","/simpleUserdefined[name=stemCanopyForm]/value"
44
"stem_canopy_position","/simpleUserdefined[name=stemCanopyPosition]/value"
45
"stem_liana_infestation","/simpleUserdefined[name=stemLianaInfestation]/value"
46
"notes","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
47 47
"orig_family",
48 48
"orig_species",
mappings/extract_plot_map
5 5
cd "$selfDir"
6 6

  
7 7
export \
8
left_in_root='/*s/individualOrganismObservation/*ID->/*s/plotObservation/' \
9
left_out_root='/*s/plotObservation/' \
10
right_in_root='/taxonObservation/*_ID/observation/' \
11
right_out_root='/observation/'
8
left_in_root='/*s/individualOrganismObservation/*ID->/*s/plotObservation' \
9
left_out_root='/*s/plotObservation' \
10
right_in_root='/taxonObservation/*_ID/observation' \
11
right_out_root='/observation'
12 12

  
13 13
../scripts/util/ch_map_root <VegX-VegBank.organisms.csv >VegX-VegBank.plots.csv
mappings/VegX-VegBank.plots.csv
1
VegX/*s/plotObservation/,VegBank/observation/
2
*ID->/*s/project/title,*_ID/project/projectName
3
*UniqueIdentifierID->/*s/plot/area,*_ID/plot/area
4
*UniqueIdentifierID->/*s/plot/country,*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName
5
*UniqueIdentifierID->/*s/plot/county,*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName
6
*UniqueIdentifierID->/*s/plot/county,*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
7
*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,*_ID/plot/locationAccuracy
8
*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,*_ID/plot/realLatitude
9
*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,*_ID/plot/realLongitude
10
*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,*_ID/plot/dsgpoly
11
*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,waterDepth/max
12
*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"*_ID/plot/{elevation/max,elevationRange/to}"
13
*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,waterDepth/min
14
*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"*_ID/plot/{elevation/min,elevationRange/from}"
15
*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,*_ID/plot/elevation
16
*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,*_ID/plot/authorPlotCode
17
*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"{*_ID/plot/authorPlotCode,authorObsCode}"
18
*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode
19
*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,*_ID/plot/place/*_ID/namedPlace/placeDescription
20
*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,*_ID/plot/place/*_ID/namedPlace/placeDescription
21
*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
22
*UniqueIdentifierID->/*s/plot/slopeAspect,*_ID/plot/slopeAspect
23
*UniqueIdentifierID->/*s/plot/slopeGradient,*_ID/plot/slopeGradient
24
*UniqueIdentifierID->/*s/plot/state,*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName
25
*UniqueIdentifierID->/*s/plot/state,*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName
26
obsEndDate,obsEndDate
27
obsStartDate,obsStartDate
28
obsStartDate/_date/day,obsStartDate/_date/day
29
obsStartDate/_date/month,obsStartDate/_date/month
30
obsStartDate/_date/year,obsStartDate/_date/year
31
simpleUserdefined[name=plotMethodology]/value,methodNarrative
32
simpleUserdefined[name=precipMm]/value,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
33
temperature,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"
1
VegX:/*s/plotObservation,VegBank:/observation
2
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue"
3
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue"
4
->/*s/abioticObservation[*ID]/ph,/soilObs/soilPH
5
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue"
6
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue"
7
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue"
8
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue"
9
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue"
10
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue"
11
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue"
12
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs/soilClay
13
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue"
14
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs/soilOrganic
15
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs/soilSand
16
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs/soilSilt
17
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue"
18
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs/soilTexture
19
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
20
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commInterpretation/*_ID/commConcept/commDescription
21
/*ID->/*s/project/title,/*_ID/project/projectName
22
/*UniqueIdentifierID->/*s/plot/area,/*_ID/plot/area
23
/*UniqueIdentifierID->/*s/plot/country,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName
24
/*UniqueIdentifierID->/*s/plot/county,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName
25
/*UniqueIdentifierID->/*s/plot/county,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName
26
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_ID/plot/locationAccuracy
27
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_ID/plot/realLatitude
28
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_ID/plot/realLongitude
29
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_ID/plot/dsgpoly
30
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/waterDepth/max
31
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_ID/plot/{elevation/max,elevationRange/to}"
32
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterDepth/min
33
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/plot/{elevation/min,elevationRange/from}"
34
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_ID/plot/elevation
35
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/authorPlotCode
36
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{*_ID/plot/authorPlotCode,authorObsCode}"
37
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode
38
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription
39
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription
40
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName
41
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_ID/plot/slopeAspect
42
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_ID/plot/slopeGradient
43
/*UniqueIdentifierID->/*s/plot/state,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName
44
/*UniqueIdentifierID->/*s/plot/state,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName
45
/obsEndDate,/obsEndDate
46
/obsStartDate,/obsStartDate
47
/obsStartDate/_date/day,/obsStartDate/_date/day
48
/obsStartDate/_date/month,/obsStartDate/_date/month
49
/obsStartDate/_date/year,/obsStartDate/_date/year
50
/simpleUserdefined[name=plotMethodology]/value,/methodNarrative
51
/simpleUserdefined[name=precipMm]/value,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue"
52
/temperature,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue"

Also available in: Unified diff