Project

General

Profile

« Previous | Next » 

Revision 3978

mappings/VegCSV-VegBIEN.specimens.csv: individualCount: Disambiguated alternate meaning as stem count by changing stem count fields to map to new stemCount term, which maps to plantobservation.stemcount

View differences:

inputs/SALVIAS-CSV/test/import.organisms.xml.ref
55 55
                                </else>
56 56
                            </_if>
57 57
                        </specimenreplicate>
58
                        <stemcount>$no_of_individuals</stemcount>
59 58
                        <stemobservation>
60 59
                            <basaldiameter>$basal_diam</basaldiameter>
61 60
                            <definedvalue fkey="tablerecord_id">
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
14 14
det_type,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
15 15
coll_number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc/_alt/1",Brad: Incorrect. Map instead as for voucher_string
16 16
voucher_string,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/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."
17
no_of_individuals,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,"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."
18 17
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
19 18
stem_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. 
20 19
stem_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. 
inputs/SALVIAS/test/import.organisms.xml.ref
56 56
                                </else>
57 57
                            </_if>
58 58
                        </specimenreplicate>
59
                        <stemcount>$NoInd</stemcount>
60 59
                        <stemobservation>
61 60
                            <definedvalue fkey="tablerecord_id">
62 61
                                <userdefined_id>
inputs/SALVIAS/test/import.stems.xml.ref
4 4
        <locationevent>
5 5
            <taxonoccurrence>
6 6
                <aggregateoccurrence>
7
                    <count>$NoInd</count>
8 7
                    <plantobservation>
9 8
                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
10 9
                        <stemcount>$NoInd</stemcount>
inputs/SALVIAS/maps/VegCSV.stems.csv
2 2
stem_id,,
3 3
origrecord_id_stems,,
4 4
PlotObsID,occurrenceID,
5
NoInd,individualCount,
5
NoInd,stemCount,
6 6
basal_diam,basalDiameter,
7 7
stem_dbh,diameterBreastHeight,
8 8
gentry_dbh,diameterBreastHeightGentry,
inputs/SALVIAS/maps/VegCSV.stems.full.csv
6 6
gentry_dbh,diameterBreastHeightGentry,
7 7
stem_height_m,height,
8 8
stem_height_first_branch_m,heightFirstBranch,
9
NoInd,individualCount,
10 9
stem_liana_infestation,lianaInfestation,
11 10
PlotObsID,occurrenceID,
12 11
stem_tag2,previousTag,
12
NoInd,stemCount,
13 13
stem_notes,stemNotes,
14 14
stem_tag1,tag,
15 15
origrecord_id_stems,,
inputs/SALVIAS/maps/VegBIEN.stems.csv
1 1
SALVIAS,VegBIEN:,Comments
2
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
3 2
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
4 3
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
5 4
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
inputs/SALVIAS/maps/VegBIEN.organisms.csv
15 15
DetType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
16 16
coll_number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc/_alt/1",Brad: Incorrect. Map instead as for voucher_string
17 17
SourceVoucher,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/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."
18
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,"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."
19 18
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. 
20 19
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. 
21 20
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. 
mappings/VegCSV.self.plots.csv
84 84
sodium,sodium
85 85
specificEpithet,specificEpithet
86 86
stateProvince,stateProvince
87
stemCount,stemCount
87 88
stemNotes,stemNotes
88 89
tag,tag
89 90
temperature,temperature
mappings/VegCSV.self.organisms.csv
84 84
sodium,sodium
85 85
specificEpithet,specificEpithet
86 86
stateProvince,stateProvince
87
stemCount,stemCount
87 88
stemNotes,stemNotes
88 89
tag,tag
89 90
temperature,temperature
mappings/VegCSV-VegBIEN.specimens.csv
1
VegCSV[DwC],VegBIEN:,Comments
2
plotArea,/location/area,
3
verbatimElevation,/location/elevation/_alt/1,
4
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
5
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",
6
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",
7
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
8
landform,/location/landform,
9
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
10
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,
11
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
12
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
13
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
17
samplingProtocol,/location/locationevent/*_id/method/name,
18
projectName,/location/locationevent/*_id/project/projectname,
19
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
20
plotName,/location/locationevent/authoreventcode,
21
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
22
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
23
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
24
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
25
parentLocationID,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/1,
26
parentPlotName,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/2,
27
parentPlotName,/location/locationevent/parent_id/locationevent/authoreventcode,
28
parentLocationID,/location/locationevent/parent_id/locationevent/sourceaccessioncode,
29
precipitation,/location/locationevent/precipitation,
30
acidity,/location/locationevent/soilobs/acidity,
31
baseSaturation,/location/locationevent/soilobs/basesaturation,
32
calcium,/location/locationevent/soilobs/calcium,
33
carbon,/location/locationevent/soilobs/carbon,
34
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,
35
clay,/location/locationevent/soilobs/clay,
36
conductivity,/location/locationevent/soilobs/conductivity,
37
magnesium,/location/locationevent/soilobs/magnesium,
38
nitrogen,/location/locationevent/soilobs/nitrogen,
39
organic,/location/locationevent/soilobs/organic,
40
ph,/location/locationevent/soilobs/ph,
41
phosphorus,/location/locationevent/soilobs/phosphorus,
42
potassium,/location/locationevent/soilobs/potassium,
43
sand,/location/locationevent/soilobs/sand,
44
silt,/location/locationevent/soilobs/silt,
45
sodium,/location/locationevent/soilobs/sodium,
46
texture,/location/locationevent/soilobs/texture,
47
locationID,/location/locationevent/sourceaccessioncode,
48
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value,
49
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
50
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
51
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
52
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,
53
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
54
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,
55
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
56
voucherType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
57
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
58
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
59
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
60
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
61
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
62
diameterBreastHeightGentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
63
lianaInfestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
64
stemNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
65
diameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
66
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
67
heightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,
68
tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
69
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
70
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
71
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
72
growthForm,/location/locationevent/taxonoccurrence/growthform,
73
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
74
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,
75
scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,
76
computer.taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
77
computer.scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
78
computer.infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
79
computer.specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
80
computer.genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
81
computer.family,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
82
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
83
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/taxonfit,
84
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
85
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
86
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
87
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
88
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
89
order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
90
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
91
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
92
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
93
recordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,
94
recordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,
95
voucherType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
96
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/_if[@name=""if indirect voucher""]/then/catalognumber_dwc",
97
temperature,/location/locationevent/temperature,
98
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",
99
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",
100
locality,/location/locationnarrative,
101
plotNotes,/location/notespublic,
102
slopeAspect,/location/slopeaspect/_compass/value,
103
slopeGradient,/location/slopegradient,
104
parentLocationID,/location/sourceaccessioncode/_merge/1/_alt/1,
105
parentPlotName,/location/sourceaccessioncode/_merge/1/_alt/2,
106
locationID,/location/sourceaccessioncode/_merge/2/_alt/1,
107
plotName,/location/sourceaccessioncode/_merge/2/_alt/2,
1
"VegCSV[DwC]","VegBIEN:","Comments"
2
"plotArea","/location/area",
3
"verbatimElevation","/location/elevation/_alt/1",
4
"maximumElevationInMeters","/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
5
"minimumElevationInMeters","/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",
6
"minimumElevationInMeters","/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",
7
"maximumElevationInMeters","/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
8
"landform","/location/landform",
9
"coordinateUncertaintyInMeters","/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1",
10
"footprintWKT","/location/locationdetermination/footprintgeometry_dwc",
11
"decimalLatitude","/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
12
"decimalLongitude","/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
13
"county","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14
"stateProvince","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15
"country","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16
"continent","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
17
"samplingProtocol","/location/locationevent/*_id/method/name",
18
"projectName","/location/locationevent/*_id/project/projectname",
19
"projectID","/location/locationevent/*_id/project/sourceaccessioncode",
20
"plotName","/location/locationevent/authoreventcode",
21
"communityID","/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
22
"communityName","/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription",
23
"plotEventEndDate","/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value",
24
"plotEventStartDate","/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value",
25
"parentLocationID","/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/1",
26
"parentPlotName","/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/2",
27
"parentPlotName","/location/locationevent/parent_id/locationevent/authoreventcode",
28
"parentLocationID","/location/locationevent/parent_id/locationevent/sourceaccessioncode",
29
"precipitation","/location/locationevent/precipitation",
30
"acidity","/location/locationevent/soilobs/acidity",
31
"baseSaturation","/location/locationevent/soilobs/basesaturation",
32
"calcium","/location/locationevent/soilobs/calcium",
33
"carbon","/location/locationevent/soilobs/carbon",
34
"cationExchangeCapacity","/location/locationevent/soilobs/cationexchangecapacity",
35
"clay","/location/locationevent/soilobs/clay",
36
"conductivity","/location/locationevent/soilobs/conductivity",
37
"magnesium","/location/locationevent/soilobs/magnesium",
38
"nitrogen","/location/locationevent/soilobs/nitrogen",
39
"organic","/location/locationevent/soilobs/organic",
40
"ph","/location/locationevent/soilobs/ph",
41
"phosphorus","/location/locationevent/soilobs/phosphorus",
42
"potassium","/location/locationevent/soilobs/potassium",
43
"sand","/location/locationevent/soilobs/sand",
44
"silt","/location/locationevent/soilobs/silt",
45
"sodium","/location/locationevent/soilobs/sodium",
46
"texture","/location/locationevent/soilobs/texture",
47
"locationID","/location/locationevent/sourceaccessioncode",
48
"eventDate","/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value",
49
"individualCount","/location/locationevent/taxonoccurrence/aggregateoccurrence/count",
50
"coverPercent","/location/locationevent/taxonoccurrence/aggregateoccurrence/cover",
51
"censusNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
52
"volumeCanopy","/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover",
53
"fieldNotes","/location/locationevent/taxonoccurrence/aggregateoccurrence/notes",
54
"recordNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode",
55
"occurrenceID","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode",
56
"voucherType","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
57
"catalogNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
58
"stemCount","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount",
59
"basalDiameter","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter",
60
"canopyForm","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
61
"canopyPosition","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
62
"diameterBreastHeightGentry","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
63
"lianaInfestation","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
64
"stemNotes","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
65
"diameterBreastHeight","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight",
66
"height","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height",
67
"heightFirstBranch","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch",
68
"tag","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag","Quotes sort it before tag2"
69
"previousTag","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag",
70
"relativePlotX","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition",
71
"relativePlotY","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition",
72
"growthForm","/location/locationevent/taxonoccurrence/growthform",
73
"occurrenceID","/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1",
74
"recordNumber","/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2",
75
"scientificName","/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3",
76
"computer.taxonRank","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
77
"computer.scientificNameAuthorship","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
78
"computer.infraspecificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
79
"computer.specificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
80
"computer.genus","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
81
"computer.family","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
82
"infraspecificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
83
"identificationQualifier","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/taxonfit",
84
"scientificName","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
85
"scientificNameAuthorship","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
86
"specificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
87
"genus","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
88
"family","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
89
"order","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
90
"class","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
91
"phylum","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
92
"kingdom","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
93
"recordedBy.givenName","/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first",
94
"recordedBy.surName","/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last",
95
"voucherType","/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
96
"catalogNumber","/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/_if[@name=""if indirect voucher""]/then/catalognumber_dwc",
97
"temperature","/location/locationevent/temperature",
98
"maximumDepthInMeters","/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",
99
"minimumDepthInMeters","/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",
100
"locality","/location/locationnarrative",
101
"plotNotes","/location/notespublic",
102
"slopeAspect","/location/slopeaspect/_compass/value",
103
"slopeGradient","/location/slopegradient",
104
"parentLocationID","/location/sourceaccessioncode/_merge/1/_alt/1",
105
"parentPlotName","/location/sourceaccessioncode/_merge/1/_alt/2",
106
"locationID","/location/sourceaccessioncode/_merge/2/_alt/1",
107
"plotName","/location/sourceaccessioncode/_merge/2/_alt/2",
mappings/VegCSV.self.stems.csv
84 84
sodium,sodium
85 85
specificEpithet,specificEpithet
86 86
stateProvince,stateProvince
87
stemCount,stemCount
87 88
stemNotes,stemNotes
88 89
tag,tag
89 90
temperature,temperature

Also available in: Unified diff