Revision 5314
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 45 | 45 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
| 46 | 46 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 47 | 47 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 48 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 49 |
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 50 |
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 48 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 49 |
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 50 |
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 51 | 51 |
darwin:Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 52 | 52 |
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 53 | 53 |
darwin:MaximumDepth,/location/locationevent/waterdepth_m/_avg/max, |
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 50 | 50 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
| 51 | 51 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 52 | 52 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 53 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 54 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 55 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 53 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 54 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 55 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 56 | 56 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 57 | 57 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 58 | 58 |
MaximumDepth,/location/locationevent/waterdepth_m/_avg/max, |
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 227 | 227 |
</parent_id> |
| 228 | 228 |
<species>$Species</species> |
| 229 | 229 |
<taxonomicname>$ScientificName</taxonomicname> |
| 230 |
<creationdate> |
|
| 231 |
<_date> |
|
| 232 |
<day> |
|
| 233 |
<_nullIf> |
|
| 234 |
<null>0</null> |
|
| 235 |
<type>float</type> |
|
| 236 |
<value>$DayIdentified</value> |
|
| 237 |
</_nullIf> |
|
| 238 |
</day> |
|
| 239 |
<month> |
|
| 240 |
<_nullIf> |
|
| 241 |
<null>0</null> |
|
| 242 |
<type>float</type> |
|
| 243 |
<value>$MonthIdentified</value> |
|
| 244 |
</_nullIf> |
|
| 245 |
</month> |
|
| 246 |
<year> |
|
| 247 |
<_nullIf> |
|
| 248 |
<null>0</null> |
|
| 249 |
<type>float</type> |
|
| 250 |
<value>$YearIdentified</value> |
|
| 251 |
</_nullIf> |
|
| 252 |
</year> |
|
| 253 |
</_date> |
|
| 254 |
</creationdate> |
|
| 230 | 255 |
</taxonconcept> |
| 231 | 256 |
</taxonconcept_id> |
| 232 | 257 |
<determinationdate> |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 50 | 50 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 51 | 51 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor, |
| 52 | 52 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank, |
| 53 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
|
|
| 53 |
dateIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
|
| 54 | 54 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 55 | 55 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 56 | 56 |
locality,/location/locationnarrative/_merge/1, |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 201 | 201 |
<species>$specificEpithet</species> |
| 202 | 202 |
<taxonomicnamewithauthor>$scientificName</taxonomicnamewithauthor> |
| 203 | 203 |
<verbatimrank>$taxonRank</verbatimrank> |
| 204 |
<creationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></creationdate> |
|
| 204 | 205 |
</taxonconcept> |
| 205 | 206 |
</taxonconcept_id> |
| 206 | 207 |
<determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate> |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 25 | 25 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 26 | 26 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
| 27 | 27 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
| 28 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 29 | 28 |
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 29 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 30 | 30 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1, |
| 31 | 31 |
Addcoll,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/2, |
| 32 | 32 |
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| inputs/U/Specimen/test.xml.ref | ||
|---|---|---|
| 145 | 145 |
</parent_id> |
| 146 | 146 |
</taxonconcept> |
| 147 | 147 |
</parent_id> |
| 148 |
<creationdate> |
|
| 149 |
<_date> |
|
| 150 |
<year> |
|
| 151 |
<_nullIf> |
|
| 152 |
<null>0</null> |
|
| 153 |
<type>float</type> |
|
| 154 |
<value>$Detyy</value> |
|
| 155 |
</_nullIf> |
|
| 156 |
</year> |
|
| 157 |
</_date> |
|
| 158 |
</creationdate> |
|
| 148 | 159 |
</taxonconcept> |
| 149 | 160 |
</taxonconcept_id> |
| 161 |
<taxonfit>$cf</taxonfit> |
|
| 150 | 162 |
<determinationdate> |
| 151 | 163 |
<_date> |
| 152 | 164 |
<year> |
| ... | ... | |
| 158 | 170 |
</year> |
| 159 | 171 |
</_date> |
| 160 | 172 |
</determinationdate> |
| 161 |
<taxonfit>$cf</taxonfit> |
|
| 162 | 173 |
</taxondetermination> |
| 163 | 174 |
<verbatimcollectorname> |
| 164 | 175 |
<_join> |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 54 | 54 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 55 | 55 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 56 | 56 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,Contains the binomial in addition to the authority |
| 57 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 58 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 59 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 60 | 57 |
Remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes, |
| 61 | 58 |
IdentificationModifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 59 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 60 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 61 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 62 | 62 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 63 | 63 |
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1", |
| 64 | 64 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2",Don't overwrite CatalogNumberNumeric |
| inputs/ARIZ/Specimen/test.xml.ref | ||
|---|---|---|
| 227 | 227 |
<species>$Species</species> |
| 228 | 228 |
<taxonomicname>$ScientificName</taxonomicname> |
| 229 | 229 |
<taxonomicnamewithauthor>$ScientificNameAuthor</taxonomicnamewithauthor> |
| 230 |
<creationdate> |
|
| 231 |
<_date> |
|
| 232 |
<day> |
|
| 233 |
<_nullIf> |
|
| 234 |
<null>0</null> |
|
| 235 |
<type>float</type> |
|
| 236 |
<value>$DayIdentified</value> |
|
| 237 |
</_nullIf> |
|
| 238 |
</day> |
|
| 239 |
<month> |
|
| 240 |
<_nullIf> |
|
| 241 |
<null>0</null> |
|
| 242 |
<type>float</type> |
|
| 243 |
<value>$MonthIdentified</value> |
|
| 244 |
</_nullIf> |
|
| 245 |
</month> |
|
| 246 |
<year> |
|
| 247 |
<_nullIf> |
|
| 248 |
<null>0</null> |
|
| 249 |
<type>float</type> |
|
| 250 |
<value>$YearIdentified</value> |
|
| 251 |
</_nullIf> |
|
| 252 |
</year> |
|
| 253 |
</_date> |
|
| 254 |
</creationdate> |
|
| 230 | 255 |
</taxonconcept> |
| 231 | 256 |
</taxonconcept_id> |
| 257 |
<notes>$Remarks</notes> |
|
| 258 |
<taxonfit>$IdentificationModifier</taxonfit> |
|
| 232 | 259 |
<determinationdate> |
| 233 | 260 |
<_date> |
| 234 | 261 |
<day> |
| ... | ... | |
| 254 | 281 |
</year> |
| 255 | 282 |
</_date> |
| 256 | 283 |
</determinationdate> |
| 257 |
<notes>$Remarks</notes> |
|
| 258 |
<taxonfit>$IdentificationModifier</taxonfit> |
|
| 259 | 284 |
</taxondetermination> |
| 260 | 285 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
| 261 | 286 |
</taxonoccurrence> |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 170 | 170 |
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 171 | 171 |
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 172 | 172 |
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 173 |
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
|
| 174 |
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 175 |
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 176 |
conceptual_darwin_2003_1_0_YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 177 | 173 |
dwc_dwcore_Remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes, |
| 174 |
dwc_terms_dateIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
|
| 175 |
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 176 |
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 177 |
conceptual_darwin_2003_1_0_YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 178 | 178 |
conceptual_darwin_2003_1_0_Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 179 | 179 |
dwc_dwcore_Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 180 | 180 |
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 510 | 510 |
<2>$dwc_terms_scientificName</2> |
| 511 | 511 |
</_alt> |
| 512 | 512 |
</taxonomicname> |
| 513 |
<creationdate> |
|
| 514 |
<_alt> |
|
| 515 |
<1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1> |
|
| 516 |
<2> |
|
| 517 |
<_date> |
|
| 518 |
<day> |
|
| 519 |
<_nullIf> |
|
| 520 |
<null>0</null> |
|
| 521 |
<type>float</type> |
|
| 522 |
<value>$conceptual_darwin_2003_1_0_DayIdentified</value> |
|
| 523 |
</_nullIf> |
|
| 524 |
</day> |
|
| 525 |
<month> |
|
| 526 |
<_nullIf> |
|
| 527 |
<null>0</null> |
|
| 528 |
<type>float</type> |
|
| 529 |
<value>$conceptual_darwin_2003_1_0_MonthIdentified</value> |
|
| 530 |
</_nullIf> |
|
| 531 |
</month> |
|
| 532 |
<year> |
|
| 533 |
<_nullIf> |
|
| 534 |
<null>0</null> |
|
| 535 |
<type>float</type> |
|
| 536 |
<value>$conceptual_darwin_2003_1_0_YearIdentified</value> |
|
| 537 |
</_nullIf> |
|
| 538 |
</year> |
|
| 539 |
</_date> |
|
| 540 |
</2> |
|
| 541 |
</_alt> |
|
| 542 |
</creationdate> |
|
| 513 | 543 |
</taxonconcept> |
| 514 | 544 |
</taxonconcept_id> |
| 545 |
<notes>$dwc_dwcore_Remarks</notes> |
|
| 515 | 546 |
<determinationdate> |
| 516 | 547 |
<_alt> |
| 517 | 548 |
<1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1> |
| ... | ... | |
| 542 | 573 |
</2> |
| 543 | 574 |
</_alt> |
| 544 | 575 |
</determinationdate> |
| 545 |
<notes>$dwc_dwcore_Remarks</notes> |
|
| 546 | 576 |
</taxondetermination> |
| 547 | 577 |
<verbatimcollectorname> |
| 548 | 578 |
<_alt> |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
| 29 | 29 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
| 30 | 30 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 31 |
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
|
| 32 | 31 |
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 32 |
interpretationdate,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
|
| 33 | 33 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 34 | 34 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/taxonomicname, |
| 35 | 35 |
museumaccessionnumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 119 | 119 |
</taxonconcept> |
| 120 | 120 |
</parent_id> |
| 121 | 121 |
<species>$Species</species> |
| 122 |
<creationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></creationdate> |
|
| 122 | 123 |
</taxonconcept> |
| 123 | 124 |
</taxonconcept_id> |
| 125 |
<taxonfit>$taxonfit</taxonfit> |
|
| 124 | 126 |
<determinationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></determinationdate> |
| 125 |
<taxonfit>$taxonfit</taxonfit> |
|
| 126 | 127 |
</taxondetermination> |
| 127 | 128 |
<taxondetermination> |
| 128 | 129 |
<isoriginal>true</isoriginal> |
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 57 | 57 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 58 | 58 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 59 | 59 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank, |
| 60 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
|
| 61 | 60 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 61 |
dateIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
|
| 62 | 62 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 63 | 63 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 64 | 64 |
locality,/location/locationnarrative/_merge/1, |
| inputs/QMOR/Specimen/test.xml.ref | ||
|---|---|---|
| 225 | 225 |
<species>$specificEpithet</species> |
| 226 | 226 |
<taxonomicname>$scientificName</taxonomicname> |
| 227 | 227 |
<verbatimrank>$taxonRank</verbatimrank> |
| 228 |
<creationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></creationdate> |
|
| 228 | 229 |
</taxonconcept> |
| 229 | 230 |
</taxonconcept_id> |
| 231 |
<taxonfit>$identificationQualifier</taxonfit> |
|
| 230 | 232 |
<determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate> |
| 231 |
<taxonfit>$identificationQualifier</taxonfit> |
|
| 232 | 233 |
</taxondetermination> |
| 233 | 234 |
<verbatimcollectorname>$recordedBy</verbatimcollectorname> |
| 234 | 235 |
</taxonoccurrence> |
| schemas/vegbien.sql | ||
|---|---|---|
| 1130 | 1130 |
species text, |
| 1131 | 1131 |
description text, |
| 1132 | 1132 |
accessioncode text, |
| 1133 |
CONSTRAINT taxonconcept_required_key CHECK ((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND (author IS NOT NULL))))
|
|
| 1133 |
CONSTRAINT taxonconcept_required_key CHECK ((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
|
|
| 1134 | 1134 |
); |
| 1135 | 1135 |
|
| 1136 | 1136 |
|
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 229 | 229 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 230 | 230 |
scientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor, |
| 231 | 231 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank, |
| 232 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
|
| 233 |
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 234 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 235 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 236 | 232 |
taxonRemarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes, |
| 237 | 233 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 234 |
dateIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
|
| 235 |
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 236 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 237 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 238 | 238 |
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/author, |
| 239 | 239 |
originalScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/1, |
| 240 | 240 |
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 229 | 229 |
scientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonomicname, |
| 230 | 230 |
scientificNameWithAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonomicnamewithauthor, |
| 231 | 231 |
taxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/verbatimrank, |
| 232 |
dateIdentified,//taxonoccurrence/taxondetermination[]/determinationdate/_*/date, |
|
| 233 |
dayIdentified,//taxonoccurrence/taxondetermination[]/determinationdate, |
|
| 234 |
monthIdentified,//taxonoccurrence/taxondetermination[]/determinationdate, |
|
| 235 |
yearIdentified,//taxonoccurrence/taxondetermination[]/determinationdate, |
|
| 236 | 232 |
taxonRemarks,//taxonoccurrence/taxondetermination[]/notes, |
| 237 | 233 |
identificationQualifier,//taxonoccurrence/taxondetermination[]/taxonfit, |
| 234 |
dateIdentified,"//taxonoccurrence/taxondetermination[]/{determinationdate,*_id/taxonconcept/creationdate}/_*/date",
|
|
| 235 |
dayIdentified,"//taxonoccurrence/taxondetermination[]/{determinationdate,*_id/taxonconcept/creationdate}",
|
|
| 236 |
monthIdentified,"//taxonoccurrence/taxondetermination[]/{determinationdate,*_id/taxonconcept/creationdate}",
|
|
| 237 |
yearIdentified,"//taxonoccurrence/taxondetermination[]/{determinationdate,*_id/taxonconcept/creationdate}",
|
|
| 238 | 238 |
originalScientificNameAuthorship,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/author, |
| 239 | 239 |
originalScientificNameWithAuthorship,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept/identifyingtaxonomicname, |
| 240 | 240 |
originalScientificName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/canon_taxonconcept_id/taxonconcept/identifyingtaxonomicname, |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: taxonconcept_required_key: Added creationdate as an allowable minimum field when parent_id (containing the associated hierarchical concept) is specified