Project

General

Profile

« Previous | Next » 

Revision 4173

mappings/Veg+-VegCore.csv: /_alt pass through mappings: Removed comment because the two-level mapping propagates it to all fields ending in /_alt, even though it doesn't apply to them, causing the main VegBIEN map and several datasources' maps to change unnecessarily. Also, the comment is not completely accurate because /_alt pass throughs are now used primarily to support idempotent self-joins of Veg+-VegCore.csv.

View differences:

inputs/XAL/src/specimens/VegBIEN.csv
25 25
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
26 26
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
27 27
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
28
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,Allow datasource to define custom mappings that don't pass through the default mapping
29
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines.; Allow datasource to define custom mappings that don't pass through the default mapping"
28
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
29
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
30 30
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
31 31
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
32 32
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/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
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
34
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,Allow datasource to define custom mappings that don't pass through the default mapping
35
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines.; Allow datasource to define custom mappings that don't pass through the default mapping"
34
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
35
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
36 36
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
37 37
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
38 38
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
inputs/ARIZ/src/specimens/VegBIEN.csv
19 19
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",
20 20
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",
21 21
ContinentOcean,"/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",
22
VerbatimCollectingDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/0,Allow datasource to define custom mappings that don't pass through the default mapping
22
VerbatimCollectingDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/0,
23 23
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
24 24
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
25 25
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
26
VerbatimCollectingDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/0,Allow datasource to define custom mappings that don't pass through the default mapping
26
VerbatimCollectingDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/0,
27 27
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
28 28
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
29 29
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
30
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/0,Allow datasource to define custom mappings that don't pass through the default mapping
30
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/0,
31 31
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
32 32
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
33 33
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
inputs/SpeciesLink/src/specimens/VegBIEN.csv
57 57
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
58 58
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
59 59
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
60
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,Allow datasource to define custom mappings that don't pass through the default mapping
60
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
61 61
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
62 62
-----
63 63
SELECT count(*) FROM ""SpeciesLink"".specimens
64 64
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
65
-----; Allow datasource to define custom mappings that don't pass through the default mapping"
65
-----"
66 66
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
67 67
-----
68 68
SELECT count(*) FROM ""SpeciesLink"".specimens
69 69
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
70
-----; Allow datasource to define custom mappings that don't pass through the default mapping"
70
-----"
71 71
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
72 72
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
73 73
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
......
79 79
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
80 80
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
81 81
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
82
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,Allow datasource to define custom mappings that don't pass through the default mapping
82
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
83 83
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
84 84
-----
85 85
SELECT count(*) FROM ""SpeciesLink"".specimens
86 86
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
87
-----; Allow datasource to define custom mappings that don't pass through the default mapping"
87
-----"
88 88
fieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
89 89
-----
90 90
SELECT count(*) FROM ""SpeciesLink"".specimens
91 91
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
92
-----; Allow datasource to define custom mappings that don't pass through the default mapping"
92
-----"
93 93
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
94 94
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
95 95
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
mappings/Veg+-VegBIEN.csv
97 97
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
98 98
EventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
99 99
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
100
DateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
101
dateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
100
DateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,
101
dateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,
102 102
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
103 103
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
104 104
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
......
113 113
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
114 114
EventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
115 115
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
116
DateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
117
dateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
116
DateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,
117
dateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,
118 118
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
119 119
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
120 120
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
......
161 161
sodium,/location/locationevent/soilobs/sodium,
162 162
Texture,/location/locationevent/soilobs/texture,
163 163
texture,/location/locationevent/soilobs/texture,
164
DateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
165
dateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
164
DateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,
165
dateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,
166 166
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
167 167
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
168 168
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
......
185 185
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
186 186
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
187 187
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
188
RecordNumber/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
189
recordNumber/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
188
RecordNumber/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt,
189
recordNumber/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt,
190 190
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
191 191
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
192 192
RecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
......
241 241
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
242 242
RelativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
243 243
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
244
RecordNumber/_alt,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
245
recordNumber/_alt,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
244
RecordNumber/_alt,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt,
245
recordNumber/_alt,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt,
246 246
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
247 247
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
248 248
RecordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
......
283 283
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
284 284
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",
285 285
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",
286
ScientificNameAuthorship/_alt,"/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/_alt",Allow datasource to define custom mappings that don't pass through the default mapping
287
scientificNameAuthorship/_alt,"/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/_alt",Allow datasource to define custom mappings that don't pass through the default mapping
286
ScientificNameAuthorship/_alt,"/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/_alt",
287
scientificNameAuthorship/_alt,"/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/_alt",
288 288
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/_alt/1",
289 289
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/_alt/1",
290 290
ScientificNameAuthor,"/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/_alt/2",
......
309 309
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",
310 310
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",
311 311
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",
312
DateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
313
dateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
312
DateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt,
313
dateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt,
314 314
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
315 315
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
316 316
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
mappings/Veg+.cs-VegBIEN.csv
48 48
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
49 49
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
50 50
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
51
dateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
51
dateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,
52 52
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
53 53
monthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
54 54
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
......
56 56
collectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/3,
57 57
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
58 58
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
59
dateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
59
dateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,
60 60
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
61 61
monthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
62 62
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
......
80 80
silt,/location/locationevent/soilobs/silt,
81 81
sodium,/location/locationevent/soilobs/sodium,
82 82
texture,/location/locationevent/soilobs/texture,
83
dateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
83
dateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,
84 84
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
85 85
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
86 86
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
......
92 92
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,
93 93
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
94 94
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
95
recordNumber/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
95
recordNumber/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt,
96 96
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
97 97
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
98 98
authorPlantCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/3,
......
120 120
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
121 121
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
122 122
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
123
recordNumber/_alt,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
123
recordNumber/_alt,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt,
124 124
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
125 125
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
126 126
authorPlantCode,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/3,
......
141 141
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
142 142
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
143 143
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",
144
scientificNameAuthorship/_alt,"/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/_alt",Allow datasource to define custom mappings that don't pass through the default mapping
144
scientificNameAuthorship/_alt,"/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/_alt",
145 145
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/_alt/1",
146 146
scientificNameAuthor,"/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/_alt/2",
147 147
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",
......
154 154
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",
155 155
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",
156 156
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",
157
dateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
157
dateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt,
158 158
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
159 159
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
160 160
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
mappings/for_review/Veg+-VegCore.csv
1 1
Veg+,Veg+,Comments
2 2
continentOcean,continent,
3
dateCollected/_alt,dateCollected/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
3
dateCollected/_alt,dateCollected/_alt,
4 4
dayCollected,dateCollected,
5 5
monthCollected,dateCollected,
6 6
yearCollected,dateCollected,
7 7
dateCollected,dateCollected,
8 8
collectedDate,dateCollected,
9
dateIdentified/_alt,dateIdentified/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
9
dateIdentified/_alt,dateIdentified/_alt,
10 10
dayIdentified,dateIdentified,
11 11
monthIdentified,dateIdentified,
12 12
yearIdentified,dateIdentified,
......
43 43
parentPlotID,parentLocationID,
44 44
preparation,preparations,
45 45
preparationType,preparations,
46
recordNumber/_alt,recordNumber/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
46
recordNumber/_alt,recordNumber/_alt,
47 47
collectorNumber,recordNumber,
48 48
recordNumber,recordNumber,
49 49
authorPlantCode,recordNumber,
......
52 52
collector.surName,recordedBy.surName,
53 53
relatedCatalogItem,relatedResourceID,
54 54
relationshipType,relationshipOfResource,
55
scientificNameAuthorship/_alt,scientificNameAuthorship/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
55
scientificNameAuthorship/_alt,scientificNameAuthorship/_alt,
56 56
scientificNameAuthorship,scientificNameAuthorship,
57 57
scientificNameAuthor,scientificNameAuthorship,
58 58
species,specificEpithet,
mappings/Veg+-VegCore.to_self.csv
1 1
Veg+,Veg+,Comments
2 2
continentOcean,continent,
3
dateCollected/_alt,dateCollected/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
4
dayCollected,"dateCollected/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",Allow datasource to define custom mappings that don't pass through the default mapping
5
monthCollected,"dateCollected/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",Allow datasource to define custom mappings that don't pass through the default mapping
6
yearCollected,"dateCollected/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",Allow datasource to define custom mappings that don't pass through the default mapping
7
dateCollected,dateCollected/_alt/2,Allow datasource to define custom mappings that don't pass through the default mapping
8
collectedDate,dateCollected/_alt/3,Allow datasource to define custom mappings that don't pass through the default mapping
9
dateIdentified/_alt,dateIdentified/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
10
dayIdentified,"dateIdentified/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",Allow datasource to define custom mappings that don't pass through the default mapping
11
monthIdentified,"dateIdentified/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",Allow datasource to define custom mappings that don't pass through the default mapping
12
yearIdentified,"dateIdentified/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",Allow datasource to define custom mappings that don't pass through the default mapping
13
dateIdentified,dateIdentified/_alt/2,Allow datasource to define custom mappings that don't pass through the default mapping
14
identifiedDate,dateIdentified/_alt/3,Allow datasource to define custom mappings that don't pass through the default mapping
3
dateCollected/_alt,dateCollected/_alt,
4
dayCollected,"dateCollected/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
5
monthCollected,"dateCollected/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
6
yearCollected,"dateCollected/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
7
dateCollected,dateCollected/_alt/2,
8
collectedDate,dateCollected/_alt/3,
9
dateIdentified/_alt,dateIdentified/_alt,
10
dayIdentified,"dateIdentified/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
11
monthIdentified,"dateIdentified/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
12
yearIdentified,"dateIdentified/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
13
dateIdentified,dateIdentified/_alt/2,
14
identifiedDate,dateIdentified/_alt/3,
15 15
julianDay,day,
16 16
accessRights,dcterms:accessRights,
17 17
bibliographicCitation,dcterms:bibliographicCitation,
......
43 43
parentPlotID,parentLocationID,
44 44
preparation,preparations,
45 45
preparationType,preparations,
46
recordNumber/_alt,recordNumber/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
47
collectorNumber,recordNumber/_alt/1,Allow datasource to define custom mappings that don't pass through the default mapping
48
recordNumber,recordNumber/_alt/2,Allow datasource to define custom mappings that don't pass through the default mapping
49
authorPlantCode,recordNumber/_alt/3,Allow datasource to define custom mappings that don't pass through the default mapping
46
recordNumber/_alt,recordNumber/_alt,
47
collectorNumber,recordNumber/_alt/1,
48
recordNumber,recordNumber/_alt/2,
49
authorPlantCode,recordNumber/_alt/3,
50 50
collector,recordedBy,
51 51
collector.givenName,recordedBy.givenName,
52 52
collector.surName,recordedBy.surName,
53 53
relatedCatalogItem,relatedResourceID,
54 54
relationshipType,relationshipOfResource,
55
scientificNameAuthorship/_alt,scientificNameAuthorship/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
56
scientificNameAuthorship,scientificNameAuthorship/_alt/1,Allow datasource to define custom mappings that don't pass through the default mapping
57
scientificNameAuthor,scientificNameAuthorship/_alt/2,Allow datasource to define custom mappings that don't pass through the default mapping
55
scientificNameAuthorship/_alt,scientificNameAuthorship/_alt,
56
scientificNameAuthorship,scientificNameAuthorship/_alt/1,
57
scientificNameAuthor,scientificNameAuthorship/_alt/2,
58 58
species,specificEpithet,
59 59
state,stateProvince,
60 60
remarks,taxonRemarks,
mappings/Veg+-VegCore.csv
1 1
Veg+,Veg+,Comments
2 2
continentOcean,continent,
3
dateCollected/_alt,dateCollected/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
3
dateCollected/_alt,dateCollected/_alt,
4 4
dayCollected,"dateCollected/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
5 5
monthCollected,"dateCollected/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
6 6
yearCollected,"dateCollected/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
7 7
dateCollected,dateCollected/_alt/2,
8 8
collectedDate,dateCollected/_alt/3,
9
dateIdentified/_alt,dateIdentified/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
9
dateIdentified/_alt,dateIdentified/_alt,
10 10
dayIdentified,"dateIdentified/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
11 11
monthIdentified,"dateIdentified/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
12 12
yearIdentified,"dateIdentified/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
......
43 43
parentPlotID,parentLocationID,
44 44
preparation,preparations,
45 45
preparationType,preparations,
46
recordNumber/_alt,recordNumber/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
46
recordNumber/_alt,recordNumber/_alt,
47 47
collectorNumber,recordNumber/_alt/1,
48 48
recordNumber,recordNumber/_alt/2,
49 49
authorPlantCode,recordNumber/_alt/3,
......
52 52
collector.surName,recordedBy.surName,
53 53
relatedCatalogItem,relatedResourceID,
54 54
relationshipType,relationshipOfResource,
55
scientificNameAuthorship/_alt,scientificNameAuthorship/_alt,Allow datasource to define custom mappings that don't pass through the default mapping
55
scientificNameAuthorship/_alt,scientificNameAuthorship/_alt,
56 56
scientificNameAuthorship,scientificNameAuthorship/_alt/1,
57 57
scientificNameAuthor,scientificNameAuthorship/_alt/2,
58 58
species,specificEpithet,

Also available in: Unified diff