Project

General

Profile

« Previous | Next » 

Revision 3905

inputs/SALVIAS/maps/VegX.organisms.csv: Map organism notes to different place than stem notes, because these are separate fields

View differences:

inputs/SALVIAS/test/import.organisms.xml.ref
39 39
                                        </_alt>
40 40
                                    </catalognumber_dwc>
41 41
                                    <collectiondate><_date><date>$census_date</date></_date></collectiondate>
42
                                    <description><_merge><1>$Notes</1></_merge></description>
42 43
                                </specimenreplicate>
43 44
                            </specimenreplicate_id>
44 45
                        </voucher>
......
54 55
                                        </_alt>
55 56
                                    </catalognumber_dwc>
56 57
                                    <collectiondate><_date><date>$census_date</date></_date></collectiondate>
58
                                    <description><_merge><1>$Notes</1></_merge></description>
57 59
                                </specimenreplicate>
58 60
                            </plantobservation>
59 61
                        </aggregateoccurrence>
......
104 106
                                </userdefined_id>
105 107
                                <definedvalue>$liana_infestation</definedvalue>
106 108
                            </definedvalue>
107
                            <definedvalue fkey="tablerecord_id">
108
                                <userdefined_id>
109
                                    <userdefined>
110
                                        <tablename>stemobservation</tablename>
111
                                        <userdefinedname>notes</userdefinedname>
112
                                    </userdefined>
113
                                </userdefined_id>
114
                                <definedvalue>$Notes</definedvalue>
115
                            </definedvalue>
116 109
                            <diameterbreastheight>$temp_dbh</diameterbreastheight>
117 110
                            <heightfirstbranch>$ht_first_branch_m</heightfirstbranch>
118 111
                            <stemtag>
......
299 292
        </sourceaccessioncode>
300 293
    </location>
301 294
</VegBIEN>
302
Inserted 50 new rows into database
295
Inserted 47 new rows into database
inputs/SALVIAS/maps/VegX.organisms.csv
57 57
canopy_position,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyPosition]/value,Brad: Should also be userDefined for VegBank. 
58 58
canopy_form,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyForm]/value,Brad: Should also be userDefined for VegBank. 
59 59
liana_infestation,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=lianaInfestation]/value,Brad: Should also be userDefined for VegBank. 
60
Notes,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,
60
Notes,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,
61 61
temp_dbh,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!attributeID]/value=1.37]/diameter,
62 62
temp_liandbh,,
63 63
tmp_del,,
inputs/SALVIAS/maps/VegX.organisms.full.csv
1 1
SALVIAS,VegX:,Comments
2
Notes,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,
2
Notes,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,
3 3
temp_dbh,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!attributeID]/value=1.37]/diameter,
4 4
canopy_form,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyForm]/value,Brad: Should also be userDefined for VegBank. 
5 5
canopy_position,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyPosition]/value,Brad: Should also be userDefined for VegBank. 
inputs/SALVIAS/maps/VegBIEN.organisms.csv
8 8
coll_number,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc/_alt/1,Brad: Incorrect. Map instead as for voucher_string
9 9
SourceVoucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
10 10
census_date,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate/_*/date,
11
Notes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/description/_merge/1,
11 12
coll_number,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc/_alt/1,Brad: Incorrect. Map instead as for voucher_string
12 13
SourceVoucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
13 14
census_date,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate/_*/date,
15
Notes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/description/_merge/1,
14 16
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
15 17
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
16 18
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
......
21 23
canopy_form,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",Brad: Should also be userDefined for VegBank. 
22 24
canopy_position,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",Brad: Should also be userDefined for VegBank. 
23 25
liana_infestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",Brad: Should also be userDefined for VegBank. 
24
Notes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
25 26
temp_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
26 27
ht_first_branch_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
27 28
tag1,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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"
mappings/VegX.self.stems.csv
18 18
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value
19 19
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName
20 20
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name
21
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text
21 22
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value
22 23
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text
23 24
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1]
mappings/VegX.self.plots.csv
18 18
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value
19 19
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName
20 20
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name
21
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text
21 22
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value
22 23
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text
23 24
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1]
mappings/VegX.self.organisms.csv
18 18
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value
19 19
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName
20 20
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name
21
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text
21 22
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value
22 23
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text
23 24
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1]
mappings/for_review/VegX-VegBIEN.stems.csv
48 48
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",//locationevent/taxonoccurrence,
49 49
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc,
50 50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectiondate,
51
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/description,
51 52
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,
52 53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectiondate,
54
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,
53 55
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,//aggregateoccurrence/count,
54 56
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,//aggregateoccurrence/cover,
55 57
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue",
mappings/VegX-VegBIEN.stems.csv
48 48
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left,
49 49
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,
50 50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,
51
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/description/_merge/1,
51 52
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,
52 53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,
54
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/description/_merge/1,
53 55
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
54 56
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
55 57
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",

Also available in: Unified diff