Revision 7170
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv | ||
|---|---|---|
| 3 | 3 |
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3", |
| 4 | 4 |
:0,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass |
| 5 | 5 |
:0,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,Enables the taxonoccurrence CHECK constraint to pass |
| 6 |
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)" |
|
| 7 | 6 |
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value/_now, |
| 8 | 7 |
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)" |
| 9 | 8 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| ... | ... | |
| 38 | 37 |
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_first/1,Contains family based on matched name |
| 39 | 38 |
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_first/2,Contains family in original string (uncommon) |
| 40 | 39 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 41 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",
|
|
| 40 |
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies,
|
|
| 42 | 41 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 43 | 42 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname, |
| 44 | 43 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 173 | 173 |
individualID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/2", |
| 174 | 174 |
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 175 | 175 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 176 |
taxonIsCanonical,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 177 |
taxonNameOrEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 178 |
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 179 | 176 |
parentScientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 180 | 177 |
parentTaxonConceptID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 181 | 178 |
parentTaxonID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| ... | ... | |
| 217 | 214 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 218 | 215 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| 219 | 216 |
taxonIsCanonical,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists", |
| 220 |
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 221 | 217 |
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else", |
| 222 | 218 |
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4, |
| 223 | 219 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
| ... | ... | |
| 232 | 228 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author, |
| 233 | 229 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family, |
| 234 | 230 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 235 |
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 236 |
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else", |
|
| 231 |
morphospecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies, |
|
| 237 | 232 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 238 | 233 |
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname, |
| 239 | 234 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 173 | 173 |
individualID,"//taxonoccurrence/sourceaccessioncode/_if[@name=""if organism in AggregateOccurrence""]/else", |
| 174 | 174 |
occurrenceID,//taxonoccurrence/sourceaccessioncode, |
| 175 | 175 |
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/party/fullname, |
| 176 |
taxonIsCanonical,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 177 |
taxonNameOrEpithet,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 178 |
verbatimScientificName,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 179 | 176 |
parentScientificNameID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 180 | 177 |
parentTaxonConceptID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 181 | 178 |
parentTaxonID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| ... | ... | |
| 217 | 214 |
genus,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
| 218 | 215 |
specificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
| 219 | 216 |
taxonIsCanonical,"//taxonlabel/taxonomicname/_if[@name=""if has verbatim name""]/cond/_exists", |
| 220 |
verbatimScientificName,"//taxonlabel/taxonomicname/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 221 | 217 |
morphospecies,"//taxonlabel/taxonomicname/_if[@name=""if has verbatim name""]/else", |
| 222 | 218 |
subspecies,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
| 223 | 219 |
infraspecificEpithet,"//taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/cond", |
| ... | ... | |
| 232 | 228 |
scientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/author, |
| 233 | 229 |
family,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/family, |
| 234 | 230 |
genus,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/genus, |
| 235 |
verbatimScientificName,"//taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 236 |
morphospecies,"//taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else", |
|
| 231 |
morphospecies,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/morphospecies, |
|
| 237 | 232 |
specificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/specific_epithet, |
| 238 | 233 |
taxonName,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/taxonname, |
| 239 | 234 |
scientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/taxonomicname, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Removed no longer used mappings for verbatimScientificName in _if conditions