Project

General

Profile

« Previous | Next » 

Revision 2013

mappings/VegX-VegBIEN.stems.csv: Added _collapse around subtrees that need to be removed if they are created around a NULL value

View differences:

inputs/SALVIAS-CSV/test/VegBIEN.plots.xml.ref
33 33
            </location>
34 34
        </location_id>
35 35
        <method_id><method><name>1 ha, stems &gt;= 10 cm dbh</name></method></method_id>
36
        <obsstartdate>1990-11-16</obsstartdate>
36 37
        <project_id>
37 38
            <project>
38 39
                <datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id>
39 40
                <projectname>RAINFOR - 1 ha Peru</projectname>
40 41
            </project>
41 42
        </project_id>
42
        <obsstartdate>1990-11-16</obsstartdate>
43 43
        <datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id>
44 44
        <authorlocationcode>ALP-11</authorlocationcode>
45 45
        <sourceaccessioncode>26102</sourceaccessioncode>
......
77 77
            </location>
78 78
        </location_id>
79 79
        <method_id><method><name>1 ha, stems &gt;= 10 cm dbh</name></method></method_id>
80
        <obsstartdate>1990-11-16</obsstartdate>
80 81
        <project_id>
81 82
            <project>
82 83
                <datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id>
83 84
                <projectname>RAINFOR - 1 ha Peru</projectname>
84 85
            </project>
85 86
        </project_id>
86
        <obsstartdate>1990-11-16</obsstartdate>
87 87
        <datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id>
88 88
        <authorlocationcode>ALP-12</authorlocationcode>
89 89
        <sourceaccessioncode>26103</sourceaccessioncode>
inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv
12 12
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value",
13 13
lat_decimal,"/*_id/location/{locationdetermination/latitude,centerlatitude}",
14 14
long_decimal,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
15
plot_methodology,/*_id/method/name,
16
project,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
17
holdridge_life_zone,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
18
life_zone_code,/commclass/commdetermination/*_id/commconcept/commdescription,
15
holdridge_life_zone,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
16
life_zone_code,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
17
plot_methodology,/method_id/_collapse:[require=name]/value/method/name,
19 18
date_finish,/obsenddate/_*/date,
20 19
date_start,/obsstartdate/_*/date,
21 20
precip_mm,/precipitation,
21
project,/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
22 22
soil_acidity,"/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
23 23
soil_base,"/soilobs/basesaturation/_units:[default=""%"",to=]/value",
24 24
soil_Ca,"/soilobs/calcium/_units:[default=""%"",to=]/value",
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
26 26
height_m,/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
27 27
stem_height_m,/overallheight,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."
28 28
OBSERVATION_ID,/sourceaccessioncode,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
29
tag1,"/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag/_alt/1","Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once.; Quotes sort it before tag2"
30
stem_tag1,"/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag/_alt/2","Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems.; Quotes sort it before tag2"
31
tag2,/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
32
stem_tag2,/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag/_alt/2,Brad: see above
29
tag1,"/stemobservation/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag/_alt/1","Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once.; Quotes sort it before tag2"
30
stem_tag1,"/stemobservation/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag/_alt/2","Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems.; Quotes sort it before tag2"
31
tag2,/stemobservation/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
32
stem_tag2,/stemobservation/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag/_alt/2,Brad: see above
33 33
x_position,/stemobservation/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
34 34
y_position,/stemobservation/yposition,Brad: See comment above for x_position
35 35
basal_diam,,** No join mapping for /diameterBaseDistance[baseDistance/value=0]/diameter ** 
inputs/CTFS/maps/VegBIEN.organisms.csv
15 15
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value",
16 16
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
17 17
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
18
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name,
19
/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
20
/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
21
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
22
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
18
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
19
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
20
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/method_id/_collapse:[require=name]/value/method/name,
23 21
/*ID->/*s/plotObservation/obsEndDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsenddate,
24 22
/*ID->/*s/plotObservation/obsStartDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,
25 23
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent/authorlocationcode,
26 24
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
27 25
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
28 26
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/precipitation,
27
/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
28
/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
29 29
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/acidity,
30 30
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/basesaturation,
31 31
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/calcium,
......
44 44
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/sodium,
45 45
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/texture,
46 46
/*ID->/*s/plotObservation/temperature,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/temperature,
47
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max/_units:[default=m,to=m,to=]/value",
48
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min/_units:[default=m,to=m,to=]/value",
47
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",
48
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",
49 49
/*ID->/*s/plotObservation/plotUniqueIdentifierID->/*s/plot[plotUniqueIdentifier]/plotName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
50 50
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
51 51
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
......
87 87
/height,/overallheight,
88 88
/simpleUserdefined[name=height]/value,/overallheight,
89 89
:[*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/sourceaccessioncode,
90
/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
91
/*ID->/*s/individualOrganism/identificationLabel[@id=2],/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
90
/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/stemobservation/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag",Quotes sort it before tag2
91
/*ID->/*s/individualOrganism/identificationLabel[@id=2],/stemobservation/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag,
92 92
/relativePlotPosition/relativeX,/stemobservation/xposition,
93 93
/relativePlotPosition/relativeY,/stemobservation/yposition,
94 94
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/*/relatedPlot[plotRelationship=Quadrat]/relatedPlotID,,** No input mapping for /*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/*/relatedPlot[plotRelationship=Quadrat]/relatedPlotID ** 
inputs/SALVIAS/test/VegBIEN.plots.xml.ref
25 25
                <centerlongitude>-78.3667</centerlongitude>
26 26
            </location>
27 27
        </location_id>
28
        <method_id><method><name>0.1 ha  transect, stems &gt;= 2.5 cm dbh</name></method></method_id>
29
        <project_id>
30
            <project>
31
                <datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id>
32
                <projectname>1</projectname>
33
            </project>
34
        </project_id>
35 28
        <commclass>
36 29
            <commdetermination>
37 30
                <commconcept_id>
......
42 35
                </commconcept_id>
43 36
            </commdetermination>
44 37
        </commclass>
38
        <method_id><method><name>0.1 ha  transect, stems &gt;= 2.5 cm dbh</name></method></method_id>
45 39
        <precipitation>2500.0</precipitation>
40
        <project_id>
41
            <project>
42
                <datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id>
43
                <projectname>1</projectname>
44
            </project>
45
        </project_id>
46 46
        <datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id>
47 47
        <authorlocationcode>ACHUPALL</authorlocationcode>
48 48
        <sourceaccessioncode>1</sourceaccessioncode>
......
72 72
                <centerlongitude>11.5</centerlongitude>
73 73
            </location>
74 74
        </location_id>
75
        <method_id><method><name>0.1 ha  transect, stems &gt;= 2.5 cm dbh</name></method></method_id>
76
        <project_id>
77
            <project>
78
                <datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id>
79
                <projectname>1</projectname>
80
            </project>
81
        </project_id>
82 75
        <commclass>
83 76
            <commdetermination>
84 77
                <commconcept_id>
......
89 82
                </commconcept_id>
90 83
            </commdetermination>
91 84
        </commclass>
85
        <method_id><method><name>0.1 ha  transect, stems &gt;= 2.5 cm dbh</name></method></method_id>
92 86
        <precipitation>866.0</precipitation>
87
        <project_id>
88
            <project>
89
                <datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id>
90
                <projectname>1</projectname>
91
            </project>
92
        </project_id>
93 93
        <temperature>7.4</temperature>
94 94
        <datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id>
95 95
        <authorlocationcode>ALLACHER</authorlocationcode>
inputs/SALVIAS/maps/VegBIEN.stems.csv
1 1
SALVIAS:stems,VegBIEN:/stemobservation,Comments
2 2
PlotObsID,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left=$../../../_ignore/voucherType,right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc",
3 3
NoInd,/*_id/plantobservation/stemcount,
4
stem_tag1,"/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag",Quotes sort it before tag2
5
stem_tag2,/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag,
4 6
basal_diam,/basaldiameter,
5 7
stem_canopy_form,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
6 8
stem_canopy_position,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
......
10 12
stem_dbh,/diameterbreastheight,
11 13
stem_height_m,/height,
12 14
stem_height_first_branch_m,/heightfirstbranch,
13
stem_tag1,"/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
14
stem_tag2,/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
15 15
origrecord_id_stems,,** No input mapping for origrecord_id_stems ** 
16 16
stem_id,,** No input mapping for stem_id ** 
17 17
tmp_del,,** No input mapping for tmp_del ** 
inputs/SALVIAS/maps/VegBIEN.plots.csv
12 12
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value",
13 13
LatDec,"/*_id/location/{locationdetermination/latitude,centerlatitude}",
14 14
LongDec,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
15
PlotMethod,/*_id/method/name,
16
project_id,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
17
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
18
life_zone,/commclass/commdetermination/*_id/commconcept/commdescription,
15
life_zone_code,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
16
life_zone,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
17
PlotMethod,/method_id/_collapse:[require=name]/value/method/name,
19 18
date_finish,/obsenddate/_*/date,
20 19
date_start,/obsstartdate/_*/date,
21 20
Precip,/precipitation,
21
project_id,/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
22 22
soil_acidity,"/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
23 23
soil_base,"/soilobs/basesaturation/_units:[default=""%"",to=]/value",
24 24
soil_Ca,"/soilobs/calcium/_units:[default=""%"",to=]/value",
inputs/SALVIAS/maps/VegBIEN.organisms.csv
26 26
Ind,/authorplantcode,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
27 27
height_m,/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
28 28
PlotObsID,/sourceaccessioncode,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
29
tag1,"/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag","Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once.; Quotes sort it before tag2"
30
tag2,/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
29
tag1,"/stemobservation/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag","Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once.; Quotes sort it before tag2"
30
tag2,/stemobservation/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
31 31
x_position,/stemobservation/xposition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
32 32
y_position,/stemobservation/yposition,Brad: See comment above for x_position
33 33
GenAuth,,** No input mapping for GenAuth ** 
mappings/VegX-VegBIEN.plots.csv
14 14
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value",
15 15
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/*_id/location/{locationdetermination/latitude,centerlatitude}",
16 16
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
17
/simpleUserdefined[name=method]/*ID/method/name,/*_id/method/name,
18
/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
19
/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
20
->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
21
->/*s/communityDetermination[*ID]/*s/communityConcept/name,/commclass/commdetermination/*_id/commconcept/commdescription,
17
->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
18
->/*s/communityDetermination[*ID]/*s/communityConcept/name,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
19
/simpleUserdefined[name=method]/*ID/method/name,/method_id/_collapse:[require=name]/value/method/name,
22 20
/obsEndDate,/obsenddate,
23 21
/obsStartDate,/obsstartdate,
24 22
/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/parent_id/locationevent/authorlocationcode,
25 23
/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
26 24
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
27 25
/simpleUserdefined[name=precipitation]/value,/precipitation,
26
/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
27
/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
28 28
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/soilobs/acidity,
29 29
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/soilobs/basesaturation,
30 30
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/soilobs/calcium,
......
43 43
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/soilobs/sodium,
44 44
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilobs/texture,
45 45
/temperature,/temperature,
46
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/waterdepth/max/_units:[default=m,to=m,to=]/value",
47
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/waterdepth/min/_units:[default=m,to=m,to=]/value",
46
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",
47
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",
48 48
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
49 49
/partyWithRole/*ID->/parties/party/organizationName,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
50 50
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
mappings/VegX-VegBIEN.organisms.csv
15 15
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value",
16 16
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
17 17
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
18
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name,
19
/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
20
/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
21
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
22
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
18
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
19
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
20
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/method_id/_collapse:[require=name]/value/method/name,
23 21
/*ID->/*s/plotObservation/obsEndDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsenddate,
24 22
/*ID->/*s/plotObservation/obsStartDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,
25 23
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent/authorlocationcode,
26 24
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
27 25
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
28 26
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/precipitation,
27
/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
28
/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
29 29
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/acidity,
30 30
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/basesaturation,
31 31
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/calcium,
......
44 44
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/sodium,
45 45
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/texture,
46 46
/*ID->/*s/plotObservation/temperature,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/temperature,
47
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max/_units:[default=m,to=m,to=]/value",
48
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min/_units:[default=m,to=m,to=]/value",
47
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",
48
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",
49 49
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
50 50
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
51 51
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
......
81 81
/height,/overallheight,
82 82
/simpleUserdefined[name=height]/value,/overallheight,
83 83
:[*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/sourceaccessioncode,
84
/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
85
/*ID->/*s/individualOrganism/identificationLabel[@id=2],/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
84
/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/stemobservation/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag",Quotes sort it before tag2
85
/*ID->/*s/individualOrganism/identificationLabel[@id=2],/stemobservation/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag,
86 86
/relativePlotPosition/relativeX,/stemobservation/xposition,
87 87
/relativePlotPosition/relativeY,/stemobservation/yposition,
mappings/for_review/VegX-VegBIEN.plots.csv
14 14
//geospatial/minimumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units/value",
15 15
//geospatial/DecimalLatitude,"/*_id/location/{locationdetermination/latitude,centerlatitude}",
16 16
//geospatial/DecimalLongitude,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
17
/simpleUserdefined[name=method]/*ID/method/name,//method/name,
18
//project/personnel[role=metadataProvider]/organizationName,//party/organizationname/_alt/1,
19
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,//project/projectname,
20
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname,
21
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription,
17
//*s/communityDetermination/*s/communityConcept/commonName,/_collapse/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
18
//*s/communityDetermination/*s/communityConcept/name,/_collapse/value/commclass/commdetermination/*_id/commconcept/commdescription,
19
/simpleUserdefined[name=method]/*ID/method/name,/method_id/_collapse/value/method/name,
22 20
/obsEndDate,/obsenddate,
23 21
/obsStartDate,/obsstartdate,
24 22
//plot/plotName,//locationevent/authorlocationcode,
25 23
//party/organizationName,//party/organizationname/_alt/1,
26 24
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
27 25
/simpleUserdefined[name=precipitation]/value,/precipitation,
26
//project/personnel[role=metadataProvider]/organizationName,/project_id/_collapse/value/project/datasource_id/party/organizationname/_alt/1,
27
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/project_id/_collapse/value/project/projectname,
28 28
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,//soilobs/acidity,
29 29
//*s/abioticObservation/simpleUserdefined[name=base]/value,//soilobs/basesaturation,
30 30
//*s/abioticObservation/simpleUserdefined[name=calcium]/value,//soilobs/calcium,
......
43 43
//*s/abioticObservation/simpleUserdefined[name=sodium]/value,//soilobs/sodium,
44 44
//*s/abioticObservation/simpleUserdefined[name=texture]/value,//soilobs/texture,
45 45
/temperature,/temperature,
46
//geospatial/maximumDepthInMeters,//waterdepth/max/_units/value,
47
//geospatial/minimumDepthInMeters,//waterdepth/min/_units/value,
46
//geospatial/maximumDepthInMeters,/waterdepth/_avg/max/_units/value,
47
//geospatial/minimumDepthInMeters,/waterdepth/_avg/min/_units/value,
48 48
//plot/plotName,/authorlocationcode,
49 49
//party/organizationName,//party/organizationname/_alt/1,
50 50
//plot/plotUniqueIdentifier,/sourceaccessioncode,
mappings/for_review/VegX-VegBIEN.organisms.csv
15 15
//geospatial/minimumElevationInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units/value",
16 16
//geospatial/DecimalLatitude,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
17 17
//geospatial/DecimalLongitude,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
18
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//method/name,
19
//project/personnel[role=metadataProvider]/organizationName,//party/organizationname/_alt/1,
20
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,//project/projectname,
21
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname,
22
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription,
18
//*s/communityDetermination/*s/communityConcept/commonName,//*_id/locationevent/_collapse/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
19
//*s/communityDetermination/*s/communityConcept/name,//*_id/locationevent/_collapse/value/commclass/commdetermination/*_id/commconcept/commdescription,
20
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//locationevent/method_id/_collapse/value/method/name,
23 21
//plotObservation/obsEndDate,//locationevent/obsenddate,
24 22
//plotObservation/obsStartDate,//locationevent/obsstartdate,
25 23
//plot/plotName,//locationevent/authorlocationcode,
26 24
//party/organizationName,//party/organizationname/_alt/1,
27 25
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
28 26
//plotObservation/simpleUserdefined[name=precipitation]/value,//locationevent/precipitation,
27
//project/personnel[role=metadataProvider]/organizationName,//locationevent/project_id/_collapse/value/project/datasource_id/party/organizationname/_alt/1,
28
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,//locationevent/project_id/_collapse/value/project/projectname,
29 29
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,//soilobs/acidity,
30 30
//*s/abioticObservation/simpleUserdefined[name=base]/value,//soilobs/basesaturation,
31 31
//*s/abioticObservation/simpleUserdefined[name=calcium]/value,//soilobs/calcium,
......
44 44
//*s/abioticObservation/simpleUserdefined[name=sodium]/value,//soilobs/sodium,
45 45
//*s/abioticObservation/simpleUserdefined[name=texture]/value,//soilobs/texture,
46 46
//plotObservation/temperature,//locationevent/temperature,
47
//geospatial/maximumDepthInMeters,//waterdepth/max/_units/value,
48
//geospatial/minimumDepthInMeters,//waterdepth/min/_units/value,
47
//geospatial/maximumDepthInMeters,//locationevent/waterdepth/_avg/max/_units/value,
48
//geospatial/minimumDepthInMeters,//locationevent/waterdepth/_avg/min/_units/value,
49 49
//plot/plotName,//locationevent/authorlocationcode,
50 50
//party/organizationName,//party/organizationname/_alt/1,
51 51
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
......
81 81
/height,/overallheight,
82 82
/simpleUserdefined[name=height]/value,/overallheight,
83 83
/simpleUserdefined[name=sourceAccessionCode]/value,/sourceaccessioncode,
84
//individualOrganism/identificationLabel[@id=1],"//stemobservation/stemtag[""""/2=true]/tag",Quotes sort it before tag2
85
//individualOrganism/identificationLabel[@id=2],//stemobservation/stemtag[iscurrent=true]:[../stemtag?[2=true]/1=false]/tag,
84
//individualOrganism/identificationLabel[@id=1],"/stemobservation/_collapse/value/stemtag[""""/2=true]/tag",Quotes sort it before tag2
85
//individualOrganism/identificationLabel[@id=2],/stemobservation/_collapse/value/stemtag[iscurrent=true]:[../../../_collapse?/value/stemtag[2=true]/1=false]/tag,
86 86
//relativePlotPosition/relativeX,//stemobservation/xposition,
87 87
//relativePlotPosition/relativeY,//stemobservation/yposition,
mappings/for_review/VegX-VegBIEN.stems.csv
15 15
//geospatial/minimumElevationInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units/value",
16 16
//geospatial/DecimalLatitude,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
17 17
//geospatial/DecimalLongitude,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
18
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//method/name,
19
//project/personnel[role=metadataProvider]/organizationName,//party/organizationname/_alt/1,
20
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,//project/projectname,
21
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname,
22
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription,
18
//*s/communityDetermination/*s/communityConcept/commonName,//*_id/locationevent/_collapse/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
19
//*s/communityDetermination/*s/communityConcept/name,//*_id/locationevent/_collapse/value/commclass/commdetermination/*_id/commconcept/commdescription,
20
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//locationevent/method_id/_collapse/value/method/name,
23 21
//plotObservation/obsEndDate,//locationevent/obsenddate,
24 22
//plotObservation/obsStartDate,//locationevent/obsstartdate,
25 23
//plot/plotName,//locationevent/authorlocationcode,
26 24
//party/organizationName,//party/organizationname/_alt/1,
27 25
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
28 26
//plotObservation/simpleUserdefined[name=precipitation]/value,//locationevent/precipitation,
27
//project/personnel[role=metadataProvider]/organizationName,//locationevent/project_id/_collapse/value/project/datasource_id/party/organizationname/_alt/1,
28
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,//locationevent/project_id/_collapse/value/project/projectname,
29 29
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,//soilobs/acidity,
30 30
//*s/abioticObservation/simpleUserdefined[name=base]/value,//soilobs/basesaturation,
31 31
//*s/abioticObservation/simpleUserdefined[name=calcium]/value,//soilobs/calcium,
......
44 44
//*s/abioticObservation/simpleUserdefined[name=sodium]/value,//soilobs/sodium,
45 45
//*s/abioticObservation/simpleUserdefined[name=texture]/value,//soilobs/texture,
46 46
//plotObservation/temperature,//locationevent/temperature,
47
//geospatial/maximumDepthInMeters,//waterdepth/max/_units/value,
48
//geospatial/minimumDepthInMeters,//waterdepth/min/_units/value,
47
//geospatial/maximumDepthInMeters,//locationevent/waterdepth/_avg/max/_units/value,
48
//geospatial/minimumDepthInMeters,//locationevent/waterdepth/_avg/min/_units/value,
49 49
//plot/plotName,//locationevent/authorlocationcode,
50 50
//party/organizationName,//party/organizationname/_alt/1,
51 51
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
......
82 82
//individualOrganismObservation/simpleUserdefined[name=height]/value,//plantobservation/overallheight,
83 83
//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,//plantobservation/sourceaccessioncode,
84 84
//*s/aggregateOrganismObservation/*/aggregateValue/value,//plantobservation/stemcount,
85
//individualOrganism/identificationLabel[@id=1],"//stemobservation/stemtag[""""/2=true]/tag",Quotes sort it before tag2
86
//individualOrganism/identificationLabel[@id=2],//stemobservation/stemtag[iscurrent=true]:[../stemtag?[2=true]/1=false]/tag,
85
//individualOrganism/identificationLabel[@id=1],"//plantobservation/stemobservation/_collapse/value/stemtag[""""/2=true]/tag",Quotes sort it before tag2
86
//individualOrganism/identificationLabel[@id=2],//plantobservation/stemobservation/_collapse/value/stemtag[iscurrent=true]:[../../../_collapse?/value/stemtag[2=true]/1=false]/tag,
87 87
//relativePlotPosition/relativeX,//stemobservation/xposition,
88 88
//relativePlotPosition/relativeY,//stemobservation/yposition,
89
//individualOrganism/identificationLabel[@id=1],"/_collapse/value/stemtag[""""/2=true]/tag",Quotes sort it before tag2
90
//individualOrganism/identificationLabel[@id=2],/_collapse/value/stemtag[iscurrent=true]:[../../../_collapse?/value/stemtag[2=true]/1=false]/tag,
89 91
/diameterBaseDistance[value=0]/diameter,/basaldiameter,
90 92
/simpleUserdefined[name=canopyForm]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]/definedvalue",
91 93
/simpleUserdefined[name=canopyPosition]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]/definedvalue",
......
95 97
/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,/diameterbreastheight,
96 98
/simpleUserdefined[name=height]/value,/height,
97 99
/simpleUserdefined[name=heightFirstBranch]/value,/heightfirstbranch,
98
//individualOrganism/identificationLabel[@id=1],"/stemtag[""""/2=true]/tag",Quotes sort it before tag2
99
//individualOrganism/identificationLabel[@id=2],/stemtag[iscurrent=true]:[../stemtag?[2=true]/1=false]/tag,
100 100
//relativePlotPosition/relativeX,/xposition,
101 101
//relativePlotPosition/relativeY,/yposition,
mappings/VegX-VegBIEN.stems.csv
15 15
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value",
16 16
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
17 17
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
18
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name,
19
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
20
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
21
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
22
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
18
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
19
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
20
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/method_id/_collapse:[require=name]/value/method/name,
23 21
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsEndDate,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsenddate,
24 22
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,
25 23
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent/authorlocationcode,
26 24
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
27 25
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
28 26
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/precipitation,
27
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
28
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/project_id/_collapse:[require=projectname]/value/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname,
29 29
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/acidity,
30 30
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/basesaturation,
31 31
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/calcium,
......
44 44
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/sodium,
45 45
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/soilobs/texture,
46 46
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/temperature,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/temperature,
47
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max/_units:[default=m,to=m,to=]/value",
48
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min/_units:[default=m,to=m,to=]/value",
47
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",
48
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",
49 49
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
50 50
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
51 51
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
......
82 82
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/simpleUserdefined[name=height]/value,/*_id/plantobservation/overallheight,
83 83
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation:[*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*_id/plantobservation/sourceaccessioncode,
84 84
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/*_id/plantobservation/stemcount,
85
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/*_id/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
86
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel[@id=2],/*_id/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
85
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/*_id/plantobservation/stemobservation/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag",Quotes sort it before tag2
86
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel[@id=2],/*_id/plantobservation/stemobservation/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag,
87 87
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/relativePlotPosition/relativeX,/*_id/plantobservation/stemobservation/xposition,
88 88
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/relativePlotPosition/relativeY,/*_id/plantobservation/stemobservation/yposition,
89
/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/_collapse:[require=tag](/value/stemtag[""""/iscurrent/_alt/2=true])/tag",Quotes sort it before tag2
90
/*ID->/*s/individualOrganism/identificationLabel[@id=2],/_collapse:[require=tag](/value/stemtag[iscurrent=true]:[../../../_collapse?(/value/stemtag[iscurrent/_alt/2=true])/iscurrent/_alt/1=false])/tag,
89 91
/diameterBaseDistance[baseDistance/value=0]/diameter,/basaldiameter,
90 92
/simpleUserdefined[name=canopyForm]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
91 93
/simpleUserdefined[name=canopyPosition]/value,"/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
......
95 97
/diameterBaseDistance[baseDistance[!attributeID]/value=1.37]/diameter,/diameterbreastheight,
96 98
/simpleUserdefined[name=height]/value,/height,
97 99
/simpleUserdefined[name=heightFirstBranch]/value,/heightfirstbranch,
98
/*ID->/*s/individualOrganism/identificationLabel[@id=1],"/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
99
/*ID->/*s/individualOrganism/identificationLabel[@id=2],/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
100 100
/relativePlotPosition/relativeX,/xposition,
101 101
/relativePlotPosition/relativeY,/yposition,

Also available in: Unified diff