Project

General

Profile

« Previous | Next » 

Revision 509

Added by Aaron Marcuse-Kubitza almost 13 years ago

Filled in SALVIAS stems mappings. make test2's stems test fails because we don't wrap the import transaction around all the tests so that organisms are already in the database when stems are imported.

View differences:

inputs/SALVIAS/maps/VegBIEN.stems.csv
1 
SALVIAS:stems,VegBIEN:/stemobservation,Comments
1 
SALVIAS:stems,VegBIEN:/stem,Comments
2 
PlotObsID,/*_id/individualplant/authorcode,
3 
stem_tag2,/authorcode/_alt/1,
4 
stem_tag1,/authorcode/_alt/2,
5 
basal_diam,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
6 
NoInd,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=count]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
7 
gentry_dbh,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
8 
stem_notes,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
9 
stem_canopy_form,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
10 
stem_canopy_position,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
11 
stem_height_first_branch_m,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
12 
stem_liana_infestation,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",
13 
stem_dbh,/diameter,
14 
stem_height_m,/height,
inputs/SALVIAS/maps/VegX.stems.csv
7 7 
"stem_dbh","/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter",
8 8 
"gentry_dbh","/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter",
9 9 
"stem_notes","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text",
10 
"stem_tag1","/*ID->/*s/individualOrganism/identificationLabel",
11 
"stem_tag2","/*ID->/*s/individualOrganism/identificationLabel",
10 
"stem_tag1","/*ID->/*s/individualOrganism/identificationLabel/_alt/2",
11 
"stem_tag2","/*ID->/*s/individualOrganism/identificationLabel/_alt/1",
12 12 
"stem_height_m","/simpleUserdefined[name=stemHeightM]/value",
13 13 
"stem_height_first_branch_m","/simpleUserdefined[name=stemHeightFirstBranchM]/value",
14 14 
"stem_canopy_form","/simpleUserdefined[name=stemCanopyForm]/value",
mappings/VegX-VegBIEN.organisms.csv
62 62 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/aggregateoccurrence/individualplant/specimen:[*_id/reference]/collector_id/party/{givenname/_namePart/first,middlename/_namePart/last}"
63 63 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/aggregateoccurrence/individualplant/specimen:[*_id/reference]/collector_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
64 64 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/aggregateoccurrence/individualplant/specimen:[*_id/reference]/collector_id/party/{surname}
65 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,/aggregateoccurrence/individualplant/stem
66 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/individualplant/stem
67 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/individualplant/stem
68 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,/aggregateoccurrence/individualplant/stem
69 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter,/aggregateoccurrence/individualplant/stem
70 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,/aggregateoccurrence/individualplant/stem
71 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/relatedItem[relationshipType=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,/aggregateoccurrence/individualplant/stem
72 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=count]/value,/aggregateoccurrence/individualplant/stem
73 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,/aggregateoccurrence/individualplant/stem
74 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,/aggregateoccurrence/individualplant/stem
75 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,/aggregateoccurrence/individualplant/stem
76 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,/aggregateoccurrence/individualplant/stem
77 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,/aggregateoccurrence/individualplant/stem
65 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/relatedItem[relationshipType=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,/aggregateoccurrence/individualplant/stem/*_id/individualplant/authorcode
66 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/individualplant/stem/authorcode
78 67 
/*ID->/*s/individualOrganism/identificationLabel,/aggregateoccurrence/individualplant/stem/authorcode
68 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/aggregateoccurrence/individualplant/stem/authorcode/_alt/1
79 69 
/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/aggregateoccurrence/individualplant/stem/authorcode/_alt/1
70 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/aggregateoccurrence/individualplant/stem/authorcode/_alt/2
80 71 
/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/aggregateoccurrence/individualplant/stem/authorcode/_alt/2
72 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
81 73 
/diameterBaseDistance[baseDistance/value=0]/diameter,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
82 74 
/simpleUserdefined[name=stemCanopyForm]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyForm]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
83 75 
/simpleUserdefined[name=stemCanopyPosition]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyPosition]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
76 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=count]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=count]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
77 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
84 78 
/simpleUserdefined[name=habitat]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=habitat]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
85 79 
/simpleUserdefined[name=htFirstBranchM]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
86 80 
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
87 81 
/simpleUserdefined[name=stemLianaInfestation]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=lianaInfestation]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
82 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
88 83 
/simpleUserdefined[name=plantFungusDescription]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
84 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
85 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
86 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
87 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
89 88 
/simpleUserdefined[name=substrate]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
90 89 
/simpleUserdefined[name=vegetation]/value,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
90 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter,/aggregateoccurrence/individualplant/stem/diameter
91 
->/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,/aggregateoccurrence/individualplant/stem/height
91 92 
/simpleUserdefined[name=xPosition]/value,/aggregateoccurrence/individualplant/stem/xposition
92 93 
/simpleUserdefined[name=yPosition]/value,/aggregateoccurrence/individualplant/stem/yposition
93 94 
/simpleUserdefined[name=censusNo]/value,"/taxondetermination[role_id/aux_role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=censusNo]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
mappings/for_review/VegX-VegBIEN.organisms.csv
62 62 
//individualName/givenName,"/aggregateoccurrence/individualplant/specimen/collector_id/party/{givenname/_namePart/first,middlename/_namePart/last}"
63 63 
"//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/aggregateoccurrence/individualplant/specimen/collector_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
64 64 
//individualName/surName,/aggregateoccurrence/individualplant/specimen/collector_id/party/{surname}
65 
//note/text,//individualplant/stem
66 
//individualOrganism/identificationLabel,//individualplant/stem
67 
//individualOrganism/identificationLabel,//individualplant/stem
68 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[value=0]/diameter,//individualplant/stem
69 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,//individualplant/stem
70 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[method=Gentry]/value=1.37]/diameter,//individualplant/stem
71 
//taxonNameUsageConcept/voucher,//individualplant/stem
72 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=count]/value,//individualplant/stem
73 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,//individualplant/stem
74 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,//individualplant/stem
75 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,//individualplant/stem
76 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,//individualplant/stem
77 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,//individualplant/stem
65 
//taxonNameUsageConcept/voucher,//individualplant/authorcode
78 66 
//individualOrganism/identificationLabel,//stem/authorcode
67 
//individualOrganism/identificationLabel,//stem/authorcode
79 68 
//individualOrganism/identificationLabel/_alt/1,//stem/authorcode/_alt/1
69 
//individualOrganism/identificationLabel/_alt/1,//stem/authorcode/_alt/1
80 70 
//individualOrganism/identificationLabel/_alt/2,//stem/authorcode/_alt/2
71 
//individualOrganism/identificationLabel/_alt/2,//stem/authorcode/_alt/2
72 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[value=0]/diameter,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]/definedvalue"
81 73 
/diameterBaseDistance[value=0]/diameter,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]]/definedvalue"
82 74 
/simpleUserdefined[name=stemCanopyForm]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyForm]]/definedvalue"
83 75 
/simpleUserdefined[name=stemCanopyPosition]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=canopyPosition]]/definedvalue"
76 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=count]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=count]]/definedvalue"
77 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[method=Gentry]/value=1.37]/diameter,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]]/definedvalue"
84 78 
/simpleUserdefined[name=habitat]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=habitat]]/definedvalue"
85 79 
/simpleUserdefined[name=htFirstBranchM]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]/definedvalue"
86 80 
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=heightFirstBranchM]]/definedvalue"
87 81 
/simpleUserdefined[name=stemLianaInfestation]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=lianaInfestation]]/definedvalue"
82 
//note/text,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]]/definedvalue"
88 83 
/simpleUserdefined[name=plantFungusDescription]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]/definedvalue"
84 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyForm]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]]/definedvalue"
85 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemCanopyPosition]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]]/definedvalue"
86 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]]/definedvalue"
87 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemLianaInfestation]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]]/definedvalue"
89 88 
/simpleUserdefined[name=substrate]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]/definedvalue"
90 89 
/simpleUserdefined[name=vegetation]/value,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]/definedvalue"
90 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,//stem/diameter
91 
//*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID]/simpleUserdefined[name=stemHeightM]/value,//stem/height
91 92 
/simpleUserdefined[name=xPosition]/value,//stem/xposition
92 93 
/simpleUserdefined[name=yPosition]/value,//stem/yposition
93 94 
/simpleUserdefined[name=censusNo]/value,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=censusNo]]/definedvalue"
mappings/VegX-VegBIEN.stems.csv
1 
VegX:/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID],VegBIEN:/stemobservation
2 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,
3 
/*ID->/*s/individualOrganism/identificationLabel,
4 
/*ID->/*s/individualOrganism/identificationLabel,
5 
/diameterBaseDistance[baseDistance/value=0]/diameter,
6 
/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter,
7 
/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,
8 
/relatedItem[relationshipType=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,
9 
/simpleUserdefined[name=count]/value,
10 
/simpleUserdefined[name=stemCanopyForm]/value,
11 
/simpleUserdefined[name=stemCanopyPosition]/value,
12 
/simpleUserdefined[name=stemHeightFirstBranchM]/value,
13 
/simpleUserdefined[name=stemHeightM]/value,
14 
/simpleUserdefined[name=stemLianaInfestation]/value,
1 
VegX:/*s/individualOrganismObservation[relatedItem[relationshipType=stemParent]/relatedItemID],VegBIEN:/stem
2 
/relatedItem[relationshipType=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,/*_id/individualplant/authorcode
3 
/*ID->/*s/individualOrganism/identificationLabel,/authorcode
4 
/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/authorcode/_alt/1
5 
/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/authorcode/_alt/2
6 
/diameterBaseDistance[baseDistance/value=0]/diameter,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=basalDiameter]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
7 
/simpleUserdefined[name=count]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=count]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
8 
/diameterBaseDistance[baseDistance[complexUserDefined/method=Gentry]/value=1.37]/diameter,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=gentryDiameter]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
9 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=notes]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
10 
/simpleUserdefined[name=stemCanopyForm]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyForm]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
11 
/simpleUserdefined[name=stemCanopyPosition]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemCanopyPosition]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
12 
/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemHeightFirstBranchM]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
13 
/simpleUserdefined[name=stemLianaInfestation]/value,"/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=stemLianaInfestation]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue"
14 
/diameterBaseDistance[baseDistance[!complexUserDefined/method]/value=1.37]/diameter,/diameter
15 
/simpleUserdefined[name=stemHeightM]/value,/height

Also available in: Unified diff