Project

General

Profile

« Previous | Next » 

Revision 4046

mappings/DwC2-VegBIEN.specimens.csv, VegCSV-VegBIEN.specimens.csv: taxonoccurrence.sourceaccessioncode mappings: Added catalogNumber mapping, which takes precendence over recordNumber and is applicable to specimens data and direct vouchers. recordNumber should only be used as a last resort (before the taxon name) because this is collector-assigned and often not unique within anything.

View differences:

inputs/QMOR/test/import.specimens.xml.ref
201 201
                        </specimenreplicate>
202 202
                    </plantobservation>
203 203
                </aggregateoccurrence>
204
                <sourceaccessioncode>$id</sourceaccessioncode>
204
                <sourceaccessioncode>
205
                    <_alt>
206
                        <1>$id</1>
207
                        <2><_if name="if indirect voucher"><else>$catalogNumber</else></_if></2>
208
                    </_alt>
209
                </sourceaccessioncode>
205 210
                <taxondetermination>
206 211
                    <isoriginal>true</isoriginal>
207 212
                    <role>identifier</role>
mappings/VegCSV-VegBIEN.specimens.csv
1
VegCSV[DwC],VegBIEN:,Comments
2
plotArea,/location/area,
3
plotName,/location/authorlocationcode/_alt/1,
4
fieldNumber,/location/authorlocationcode/_alt/2,
5
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
6
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
7
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
9
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
10
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
11
landform,/location/landform,
12
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
13
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,
14
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
15
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
16
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",
17
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",
18
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",
19
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",
20
samplingProtocol,/location/locationevent/*_id/method/name,
21
projectName,/location/locationevent/*_id/project/projectname,
22
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
23
fieldNumber,/location/locationevent/authoreventcode,
24
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
25
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
26
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
27
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
28
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
29
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
30
precipitation,/location/locationevent/precipitation,
31
acidity,/location/locationevent/soilobs/acidity,
32
baseSaturation,/location/locationevent/soilobs/basesaturation,
33
calcium,/location/locationevent/soilobs/calcium,
34
carbon,/location/locationevent/soilobs/carbon,
35
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,
36
clay,/location/locationevent/soilobs/clay,
37
conductivity,/location/locationevent/soilobs/conductivity,
38
magnesium,/location/locationevent/soilobs/magnesium,
39
nitrogen,/location/locationevent/soilobs/nitrogen,
40
organic,/location/locationevent/soilobs/organic,
41
ph,/location/locationevent/soilobs/ph,
42
phosphorus,/location/locationevent/soilobs/phosphorus,
43
potassium,/location/locationevent/soilobs/potassium,
44
sand,/location/locationevent/soilobs/sand,
45
silt,/location/locationevent/soilobs/silt,
46
sodium,/location/locationevent/soilobs/sodium,
47
texture,/location/locationevent/soilobs/texture,
48
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
49
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
50
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
51
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,
52
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
53
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,
54
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
55
voucherType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
56
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
57
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
58
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
59
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
60
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
61
diameterBreastHeightGentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
62
lianaInfestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
63
stemNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
64
diameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
65
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
66
heightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,
67
tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
68
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
69
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
70
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
71
growthForm,/location/locationevent/taxonoccurrence/growthform,
72
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
73
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,
74
scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,
75
computer.scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
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.infraspecificEpithet,"/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/last",
78
computer.specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
79
computer.genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
80
computer.family,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
81
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
82
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
83
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
84
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
85
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
86
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
87
order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
88
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
89
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
90
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
91
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit,
92
recordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,
93
recordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,
94
voucherType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
95
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
96
temperature,/location/locationevent/temperature,
97
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
98
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
99
locality,/location/locationnarrative/_merge/1,
100
plotNotes,/location/notespublic,
101
parentPlotName,/location/parent_id/location/authorlocationcode,
102
parentLocationID,/location/parent_id/location/sourceaccessioncode,
103
slopeAspect,/location/slopeaspect/_compass/value,
104
slopeGradient,/location/slopegradient,
105
locationID,/location/sourceaccessioncode,
1
"VegCSV[DwC]","VegBIEN:","Comments"
2
"plotArea","/location/area",
3
"plotName","/location/authorlocationcode/_alt/1",
4
"fieldNumber","/location/authorlocationcode/_alt/2",
5
"verbatimElevation","/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
6
"maximumElevationInMeters","/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
7
"minimumElevationInMeters","/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8
"minimumElevationInMeters","/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
9
"maximumElevationInMeters","/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
10
"minimumElevationInMeters","/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
11
"landform","/location/landform",
12
"coordinateUncertaintyInMeters","/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1",
13
"footprintWKT","/location/locationdetermination/footprintgeometry_dwc",
14
"decimalLatitude","/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
15
"decimalLongitude","/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
16
"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",
17
"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",
18
"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",
19
"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",
20
"samplingProtocol","/location/locationevent/*_id/method/name",
21
"projectName","/location/locationevent/*_id/project/projectname",
22
"projectID","/location/locationevent/*_id/project/sourceaccessioncode",
23
"fieldNumber","/location/locationevent/authoreventcode",
24
"communityID","/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
25
"communityName","/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription",
26
"plotEventEndDate","/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value",
27
"eventDate","/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1",
28
"plotEventStartDate","/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value",
29
"eventDate","/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1",
30
"precipitation","/location/locationevent/precipitation",
31
"acidity","/location/locationevent/soilobs/acidity",
32
"baseSaturation","/location/locationevent/soilobs/basesaturation",
33
"calcium","/location/locationevent/soilobs/calcium",
34
"carbon","/location/locationevent/soilobs/carbon",
35
"cationExchangeCapacity","/location/locationevent/soilobs/cationexchangecapacity",
36
"clay","/location/locationevent/soilobs/clay",
37
"conductivity","/location/locationevent/soilobs/conductivity",
38
"magnesium","/location/locationevent/soilobs/magnesium",
39
"nitrogen","/location/locationevent/soilobs/nitrogen",
40
"organic","/location/locationevent/soilobs/organic",
41
"ph","/location/locationevent/soilobs/ph",
42
"phosphorus","/location/locationevent/soilobs/phosphorus",
43
"potassium","/location/locationevent/soilobs/potassium",
44
"sand","/location/locationevent/soilobs/sand",
45
"silt","/location/locationevent/soilobs/silt",
46
"sodium","/location/locationevent/soilobs/sodium",
47
"texture","/location/locationevent/soilobs/texture",
48
"individualCount","/location/locationevent/taxonoccurrence/aggregateoccurrence/count",
49
"coverPercent","/location/locationevent/taxonoccurrence/aggregateoccurrence/cover",
50
"censusNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
51
"volumeCanopy","/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover",
52
"fieldNotes","/location/locationevent/taxonoccurrence/aggregateoccurrence/notes",
53
"recordNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode",
54
"occurrenceID","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode",
55
"voucherType","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
56
"catalogNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
57
"stemCount","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount",
58
"basalDiameter","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter",
59
"canopyForm","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
60
"canopyPosition","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
61
"diameterBreastHeightGentry","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
62
"lianaInfestation","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
63
"stemNotes","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
64
"diameterBreastHeight","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight",
65
"height","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height",
66
"heightFirstBranch","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch",
67
"tag","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag","Quotes sort it before tag2"
68
"previousTag","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag",
69
"relativePlotX","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition",
70
"relativePlotY","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition",
71
"growthForm","/location/locationevent/taxonoccurrence/growthform",
72
"occurrenceID","/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1",
73
"catalogNumber","/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
74
"recordNumber","/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3",
75
"scientificName","/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/4",
76
"computer.scientificNameAuthorship","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
77
"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",
78
"computer.infraspecificEpithet","/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/last",
79
"computer.specificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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]/*_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]/*_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
"scientificName","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
83
"scientificNameAuthorship","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
84
"infraspecificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
85
"specificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
86
"genus","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
87
"family","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
88
"order","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
89
"class","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
90
"phylum","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
91
"kingdom","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
92
"identificationQualifier","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit",
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/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
96
"catalogNumber","/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
97
"temperature","/location/locationevent/temperature",
98
"maximumDepthInMeters","/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
99
"minimumDepthInMeters","/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
100
"locality","/location/locationnarrative/_merge/1",
101
"plotNotes","/location/notespublic",
102
"parentPlotName","/location/parent_id/location/authorlocationcode",
103
"parentLocationID","/location/parent_id/location/sourceaccessioncode",
104
"slopeAspect","/location/slopeaspect/_compass/value",
105
"slopeGradient","/location/slopegradient",
106
"locationID","/location/sourceaccessioncode",
mappings/for_review/DwC2-VegBIEN.specimens.csv
40 40
establishmentMeans,//taxonoccurrence/iscultivated,
41 41
establishmentMeans,//taxonoccurrence/isnative,
42 42
occurrenceID,//taxonoccurrence/sourceaccessioncode,
43
catalogNumber,"//taxonoccurrence/sourceaccessioncode/_if[@name=""if indirect voucher""]/else",
43 44
recordNumber,//taxonoccurrence/sourceaccessioncode,
44 45
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname,
45 46
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename,
mappings/DwC.cs-VegBIEN.specimens.csv
74 74
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
75 75
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
76 76
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
77
collectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
78
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
77
catalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
78
collectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
79
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,
79 80
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
80 81
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
81 82
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/XAL/test/import.specimens.xml.ref
257 257
                        </specimenreplicate>
258 258
                    </plantobservation>
259 259
                </aggregateoccurrence>
260
                <sourceaccessioncode>$CollectorNumber</sourceaccessioncode>
260
                <sourceaccessioncode>
261
                    <_alt>
262
                        <2><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></2>
263
                        <3>$CollectorNumber</3>
264
                    </_alt>
265
                </sourceaccessioncode>
261 266
                <taxondetermination>
262 267
                    <isoriginal>true</isoriginal>
263 268
                    <role>identifier</role>
inputs/XAL/maps/VegBIEN.specimens.csv
32 32
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
33 33
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
34 34
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
35
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
35
CatalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
36
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
36 37
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
37 38
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
38 39
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/NY/test/import.specimens.xml.ref
297 297
                <sourceaccessioncode>
298 298
                    <_alt>
299 299
                        <1>$UniqueNYInternalRecordNumber</1>
300
                        <2>
300
                        <2><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></2>
301
                        <3>
301 302
                            <_alt>
302 303
                                <1>$CollectorNumber</1>
303 304
                                <2>$FieldNumber</2>
304 305
                            </_alt>
305
                        </2>
306
                        </3>
306 307
                    </_alt>
307 308
                </sourceaccessioncode>
308 309
                <taxondetermination>
inputs/NY/maps/VegBIEN.specimens.csv
38 38
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
39 39
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
40 40
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
41
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
42
FieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,Usage inconsistent with DwC definition
41
CatalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
42
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
43
FieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,Usage inconsistent with DwC definition
43 44
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
44 45
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
45 46
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/UNCC/test/import.specimens.xml.ref
195 195
                <sourceaccessioncode>
196 196
                    <_alt>
197 197
                        <1>$accession</1>
198
                        <2>$collectno</2>
198
                        <3>$collectno</3>
199 199
                    </_alt>
200 200
                </sourceaccessioncode>
201 201
                <taxondetermination>
inputs/UNCC/maps/VegBIEN.specimens.csv
27 27
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
28 28
cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
29 29
accession,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
30
collectno,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
30
collectno,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
31 31
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
32 32
authors,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
33 33
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
inputs/ACAD/test/import.specimens.xml.ref
85 85
                <sourceaccessioncode>
86 86
                    <_alt>
87 87
                        <1>$id</1>
88
                        <2>$recordNumber</2>
88
                        <2><_if name="if indirect voucher"><else>$catalogNumber</else></_if></2>
89
                        <3>$recordNumber</3>
89 90
                    </_alt>
90 91
                </sourceaccessioncode>
91 92
                <taxondetermination>
inputs/ACAD/maps/VegBIEN.specimens.csv
20 20
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
21 21
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
22 22
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
23
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
23
catalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
24
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,
24 25
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
25 26
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
26 27
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/CVS/maps/VegBIEN.organisms.csv
10 10
authorObsCode,/location/locationevent/authoreventcode,
11 11
obsStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
12 12
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
13
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,
13
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/4,
14 14
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
15 15
confidentialityStatus,,** No input mapping for confidentialityStatus ** 
inputs/SALVIAS-CSV/test/import.organisms.xml.ref
142 142
                <sourceaccessioncode>
143 143
                    <_alt>
144 144
                        <1>$OBSERVATION_ID</1>
145
                        <2>$individual_code</2>
146
                        <3><_name><last>$orig_species</last></_name></3>
145
                        <2>
146
                            <_if name="if indirect voucher">
147
                                <else>
148
                                    <_alt>
149
                                        <1>$coll_number</1>
150
                                        <2>$voucher_string</2>
151
                                    </_alt>
152
                                </else>
153
                            </_if>
154
                        </2>
155
                        <3>$individual_code</3>
156
                        <4><_name><last>$orig_species</last></_name></4>
147 157
                    </_alt>
148 158
                </sourceaccessioncode>
149 159
                <taxondetermination>
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
35 35
y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,Brad: See comment above for x_position
36 36
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=]/value","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
37 37
OBSERVATION_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"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."
38
individual_code,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"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."
39
orig_species,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_name/last,Brad: OMIT
38
coll_number,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
39
voucher_string,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
40
individual_code,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,"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."
41
orig_species,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/4/_name/last,Brad: OMIT
40 42
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
41 43
infra_rank_1,"/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",
42 44
infra_ep_1,"/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/last",
inputs/SALVIAS/test/import.organisms.xml.ref
114 114
                <sourceaccessioncode>
115 115
                    <_alt>
116 116
                        <1>$PlotObsID</1>
117
                        <2>$Ind</2>
118
                        <3>
117
                        <2>
118
                            <_if name="if indirect voucher">
119
                                <else>
120
                                    <_alt>
121
                                        <1>$coll_number</1>
122
                                        <2>$SourceVoucher</2>
123
                                    </_alt>
124
                                </else>
125
                            </_if>
126
                        </2>
127
                        <3>$Ind</3>
128
                        <4>
119 129
                            <_name>
120 130
                                <first>$OrigGenus</first>
121 131
                                <last>$OrigSpecies</last>
122 132
                            </_name>
123
                        </3>
133
                        </4>
124 134
                    </_alt>
125 135
                </sourceaccessioncode>
126 136
                <taxondetermination>
inputs/SALVIAS/maps/VegBIEN.organisms.csv
38 38
y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,Brad: See comment above for x_position
39 39
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=]/value","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
40 40
PlotObsID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"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."
41
Ind,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"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."
42
OrigGenus,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_name/first,
43
OrigSpecies,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_name/last,Brad: OMIT
41
coll_number,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
42
SourceVoucher,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
43
Ind,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,"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."
44
OrigGenus,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/4/_name/first,
45
OrigSpecies,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/4/_name/last,Brad: OMIT
44 46
auth,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
45 47
infra_rank_1,"/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",
46 48
infra_ep_1,"/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/last",
inputs/U/test/import.specimens.xml.ref
152 152
                <sourceaccessioncode>
153 153
                    <_alt>
154 154
                        <1>$ID</1>
155
                        <2>$Number</2>
155
                        <2><_if name="if indirect voucher"><else>$Barcode</else></_if></2>
156
                        <3>$Number</3>
156 157
                    </_alt>
157 158
                </sourceaccessioncode>
158 159
                <taxondetermination>
inputs/U/maps/VegBIEN.specimens.csv
19 19
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
20 20
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
21 21
ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
22
Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
22
Barcode,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
23
Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,
23 24
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
24 25
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
25 26
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/ARIZ/test/import.specimens.xml.ref
319 319
                <sourceaccessioncode>
320 320
                    <_alt>
321 321
                        <1>$GlobalUniqueIdentifier</1>
322
                        <2>
322
                        <2><_if name="if indirect voucher"><else>$CatalogNumberNumeric</else></_if></2>
323
                        <3>
323 324
                            <_alt>
324 325
                                <1>$CollectorNumber</1>
325 326
                                <2>$FieldNumber</2>
326 327
                            </_alt>
327
                        </2>
328
                        </3>
328 329
                    </_alt>
329 330
                </sourceaccessioncode>
330 331
                <taxondetermination>
inputs/ARIZ/maps/VegBIEN.specimens.csv
43 43
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
44 44
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
45 45
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
46
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
47
FieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,Usage inconsistent with DwC definition
46
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
47
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
48
FieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,Usage inconsistent with DwC definition
48 49
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
49 50
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
50 51
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/GBIF/test/import.specimens.xml.ref
166 166
                        </specimenreplicate>
167 167
                    </plantobservation>
168 168
                </aggregateoccurrence>
169
                <sourceaccessioncode><_if name="if indirect voucher"><else>$CatalogNO</else></_if></sourceaccessioncode>
169 170
                <taxondetermination>
170 171
                    <isoriginal>true</isoriginal>
171 172
                    <role>identifier</role>
inputs/GBIF/maps/VegBIEN.specimens.csv
20 20
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
21 21
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
22 22
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
23
CatalogNO,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
23 24
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
24 25
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
25 26
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/NCU-NCSC/test/import.specimens.xml.ref
107 107
                        </value>
108 108
                    </_map>
109 109
                </isnative>
110
                <sourceaccessioncode>$Accession Number</sourceaccessioncode>
110
                <sourceaccessioncode>
111
                    <_alt>
112
                        <1>$Accession Number</1>
113
                        <2><_if name="if indirect voucher"><else>$Barcode</else></_if></2>
114
                    </_alt>
115
                </sourceaccessioncode>
111 116
                <taxondetermination>
112 117
                    <isoriginal>true</isoriginal>
113 118
                    <role>identifier</role>
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
18 18
Cultivated?,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",
19 19
Cultivated?,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",
20 20
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
21
Barcode,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
21 22
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
22 23
Accession Number,/location/sourceaccessioncode/_alt/1,
23 24
Alt E/W,,** No input mapping for Alt E/W ** 
inputs/SpeciesLink/test/import.specimens.xml.ref
458 458
                    <_alt>
459 459
                        <1>$dwc_dwcore_GlobalUniqueIdentifier</1>
460 460
                        <2>
461
                            <_if name="if indirect voucher">
462
                                <else>
463
                                    <_alt>
464
                                        <0>$dwc_dwcore_CatalogNumber</0>
465
                                        <1>$conceptual_darwin_2003_1_0_CatalogNumber</1>
466
                                        <2>$dwc_terms_catalogNumber</2>
467
                                    </_alt>
468
                                </else>
469
                            </_if>
470
                        </2>
471
                        <3>
461 472
                            <_alt>
462 473
                                <1>
463 474
                                    <_alt>
......
467 478
                                </1>
468 479
                                <2>$dwc_terms_recordNumber</2>
469 480
                            </_alt>
470
                        </2>
481
                        </3>
471 482
                    </_alt>
472 483
                </sourceaccessioncode>
473 484
                <taxondetermination>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
72 72
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
73 73
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
74 74
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
75
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
76
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
75
CatalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
76
catalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
77
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
78
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,
77 79
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
78 80
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
79 81
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
inputs/MO/test/import.specimens.xml.ref
246 246
                        </specimenreplicate>
247 247
                    </plantobservation>
248 248
                </aggregateoccurrence>
249
                <sourceaccessioncode>$CollectorNumber</sourceaccessioncode>
249
                <sourceaccessioncode>
250
                    <_alt>
251
                        <2><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></2>
252
                        <3>$CollectorNumber</3>
253
                    </_alt>
254
                </sourceaccessioncode>
250 255
                <taxondetermination>
251 256
                    <isoriginal>true</isoriginal>
252 257
                    <role>identifier</role>
inputs/MO/maps/VegBIEN.specimens.csv
29 29
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
30 30
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
31 31
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
32
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
32
CatalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
33
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
33 34
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
34 35
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
35 36
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/QMOR/maps/VegBIEN.specimens.csv
30 30
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
31 31
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
32 32
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
33
catalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
33 34
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
34 35
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
35 36
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
mappings/DwC2-VegBIEN.specimens.csv
40 40
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
41 41
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
42 42
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
43
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,
43
catalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
44
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,
44 45
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
45 46
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
46 47
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
mappings/DwC-VegBIEN.specimens.csv
149 149
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
150 150
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
151 151
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
152
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
153
collectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
154
RecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
155
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
152
CatalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
153
catalogNumber,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
154
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
155
collectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/1,
156
RecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,
157
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3/_alt/2,
156 158
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
157 159
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
158 160
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,

Also available in: Unified diff