Revision 7304
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
darwin:Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 29 | 29 |
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 30 | 30 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 31 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 32 |
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 33 |
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 34 | 31 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet", |
| 35 | 32 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 36 | 33 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 38 | 38 |
recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 39 | 39 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 40 | 40 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 41 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 42 | 41 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 43 | 42 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 44 | 43 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 83 | 83 |
<taxonverbatim> |
| 84 | 84 |
<taxonlabel_id> |
| 85 | 85 |
<taxonlabel> |
| 86 |
<creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate> |
|
| 87 | 86 |
<parent_id> |
| 88 | 87 |
<taxonlabel> |
| 89 | 88 |
<rank>$taxonRank</rank> |
| inputs/WIN/Specimen/VegBIEN.csv | ||
|---|---|---|
| 39 | 39 |
recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 40 | 40 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 41 | 41 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 42 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 43 | 42 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 44 | 43 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 45 | 44 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/WIN/Specimen/test.xml.ref | ||
|---|---|---|
| 88 | 88 |
<taxonverbatim> |
| 89 | 89 |
<taxonlabel_id> |
| 90 | 90 |
<taxonlabel> |
| 91 |
<creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate> |
|
| 92 | 91 |
<parent_id> |
| 93 | 92 |
<taxonlabel> |
| 94 | 93 |
<rank>$taxonRank</rank> |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
Number,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 30 | 30 |
ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 31 | 31 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 32 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 33 | 32 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| 34 | 33 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 35 | 34 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/U/Specimen/test.xml.ref | ||
|---|---|---|
| 93 | 93 |
<taxonverbatim> |
| 94 | 94 |
<taxonlabel_id> |
| 95 | 95 |
<taxonlabel> |
| 96 |
<creationdate> |
|
| 97 |
<_date> |
|
| 98 |
<year> |
|
| 99 |
<_nullIf> |
|
| 100 |
<null>0</null> |
|
| 101 |
<type>float</type> |
|
| 102 |
<value>$Detyy</value> |
|
| 103 |
</_nullIf> |
|
| 104 |
</year> |
|
| 105 |
</_date> |
|
| 106 |
</creationdate> |
|
| 107 | 96 |
<parent_id> |
| 108 | 97 |
<taxonlabel> |
| 109 | 98 |
<parent_id> |
| inputs/QFA/Specimen/VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 41 | 41 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 42 | 42 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 43 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 44 | 43 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 45 | 44 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 46 | 45 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/QFA/Specimen/test.xml.ref | ||
|---|---|---|
| 99 | 99 |
<taxonverbatim> |
| 100 | 100 |
<taxonlabel_id> |
| 101 | 101 |
<taxonlabel> |
| 102 |
<creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate> |
|
| 103 | 102 |
<parent_id> |
| 104 | 103 |
<taxonlabel> |
| 105 | 104 |
<rank>$taxonRank</rank> |
| inputs/UBC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 38 | 38 |
recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 39 | 39 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 40 | 40 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 41 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 42 | 41 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 43 | 42 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 44 | 43 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/UBC/Specimen/test.xml.ref | ||
|---|---|---|
| 83 | 83 |
<taxonverbatim> |
| 84 | 84 |
<taxonlabel_id> |
| 85 | 85 |
<taxonlabel> |
| 86 |
<creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate> |
|
| 87 | 86 |
<parent_id> |
| 88 | 87 |
<taxonlabel> |
| 89 | 88 |
<rank>$taxonRank</rank> |
| inputs/HIBG/Specimen/VegBIEN.csv | ||
|---|---|---|
| 38 | 38 |
recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 39 | 39 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 40 | 40 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 41 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 42 | 41 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 43 | 42 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 44 | 43 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
surname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2, |
| 20 | 20 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 21 | 21 |
taxonobservation_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 22 |
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 23 | 22 |
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet", |
| 24 | 23 |
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet", |
| 25 | 24 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet", |
| inputs/TRTE/Specimen/VegBIEN.csv | ||
|---|---|---|
| 38 | 38 |
recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 39 | 39 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 40 | 40 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 41 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 42 | 41 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 43 | 42 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 44 | 43 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| schemas/vegbien.my.sql | ||
|---|---|---|
| 500 | 500 |
taxonlabel_id int(11) NOT NULL, |
| 501 | 501 |
source_id int(11) NOT NULL, |
| 502 | 502 |
sourceaccessioncode varchar(255), |
| 503 |
creationdate date, |
|
| 504 | 503 |
taxonstatus varchar(255), |
| 505 | 504 |
canon_label_id int(11), |
| 506 | 505 |
matched_label_id int(11), |
| ... | ... | |
| 534 | 533 |
|
| 535 | 534 |
|
| 536 | 535 |
-- |
| 537 |
-- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public; Owner: - |
|
| 538 |
-- |
|
| 539 |
|
|
| 540 |
|
|
| 541 |
|
|
| 542 |
|
|
| 543 |
-- |
|
| 544 | 536 |
-- Name: COLUMN taxonlabel.canon_label_id; Type: COMMENT; Schema: public; Owner: - |
| 545 | 537 |
-- |
| 546 | 538 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1183 | 1183 |
taxonlabel_id integer NOT NULL, |
| 1184 | 1184 |
source_id integer NOT NULL, |
| 1185 | 1185 |
sourceaccessioncode text, |
| 1186 |
creationdate date, |
|
| 1187 | 1186 |
taxonstatus taxonomic_status, |
| 1188 | 1187 |
canon_label_id integer, |
| 1189 | 1188 |
matched_label_id integer, |
| ... | ... | |
| 1224 | 1223 |
|
| 1225 | 1224 |
|
| 1226 | 1225 |
-- |
| 1227 |
-- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public; Owner: - |
|
| 1228 |
-- |
|
| 1229 |
|
|
| 1230 |
COMMENT ON COLUMN taxonlabel.creationdate IS 'The date the taxonlabel was created or defined. For a taxonlabel applied in a taxondetermination, this is the date the determination was made.'; |
|
| 1231 |
|
|
| 1232 |
|
|
| 1233 |
-- |
|
| 1234 | 1226 |
-- Name: COLUMN taxonlabel.canon_label_id; Type: COMMENT; Schema: public; Owner: - |
| 1235 | 1227 |
-- |
| 1236 | 1228 |
|
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 180 | 180 |
parentScientificNameID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 181 | 181 |
parentTaxonConceptID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 182 | 182 |
parentTaxonID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 183 |
dateIdentified,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/creationdate, |
|
| 184 |
dayIdentified,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/creationdate, |
|
| 185 |
monthIdentified,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/creationdate, |
|
| 186 |
yearIdentified,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/creationdate, |
|
| 187 | 183 |
taxonIsCanonical,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/cond", |
| 188 | 184 |
parentScientificNameID,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 189 | 185 |
parentTaxonConceptID,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| inputs/HIBG/Specimen/test.xml.ref | ||
|---|---|---|
| 83 | 83 |
<taxonverbatim> |
| 84 | 84 |
<taxonlabel_id> |
| 85 | 85 |
<taxonlabel> |
| 86 |
<creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate> |
|
| 87 | 86 |
<parent_id> |
| 88 | 87 |
<taxonlabel> |
| 89 | 88 |
<rank>$taxonRank</rank> |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 163 | 163 |
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 164 | 164 |
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 165 | 165 |
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 166 |
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 167 |
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 168 |
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 169 |
conceptual_darwin_2003_1_0_YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 170 | 166 |
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet", |
| 171 | 167 |
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 172 | 168 |
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 236 | 236 |
<taxonverbatim> |
| 237 | 237 |
<taxonlabel_id> |
| 238 | 238 |
<taxonlabel> |
| 239 |
<creationdate> |
|
| 240 |
<_alt> |
|
| 241 |
<1><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></1> |
|
| 242 |
<2> |
|
| 243 |
<_date> |
|
| 244 |
<day> |
|
| 245 |
<_nullIf> |
|
| 246 |
<null>0</null> |
|
| 247 |
<type>float</type> |
|
| 248 |
<value>$conceptual_darwin_2003_1_0_DayIdentified</value> |
|
| 249 |
</_nullIf> |
|
| 250 |
</day> |
|
| 251 |
<month> |
|
| 252 |
<_nullIf> |
|
| 253 |
<null>0</null> |
|
| 254 |
<type>float</type> |
|
| 255 |
<value>$conceptual_darwin_2003_1_0_MonthIdentified</value> |
|
| 256 |
</_nullIf> |
|
| 257 |
</month> |
|
| 258 |
<year> |
|
| 259 |
<_nullIf> |
|
| 260 |
<null>0</null> |
|
| 261 |
<type>float</type> |
|
| 262 |
<value>$conceptual_darwin_2003_1_0_YearIdentified</value> |
|
| 263 |
</_nullIf> |
|
| 264 |
</year> |
|
| 265 |
</_date> |
|
| 266 |
</2> |
|
| 267 |
</_alt> |
|
| 268 |
</creationdate> |
|
| 269 | 239 |
<parent_id> |
| 270 | 240 |
<taxonlabel> |
| 271 | 241 |
<parent_id> |
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 32 | 32 |
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 33 | 33 |
FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Usage inconsistent with DwC definition |
| 34 | 34 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 35 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 36 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 37 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 38 | 35 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet", |
| 39 | 36 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 40 | 37 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 129 | 129 |
<taxonverbatim> |
| 130 | 130 |
<taxonlabel_id> |
| 131 | 131 |
<taxonlabel> |
| 132 |
<creationdate> |
|
| 133 |
<_date> |
|
| 134 |
<day> |
|
| 135 |
<_nullIf> |
|
| 136 |
<null>0</null> |
|
| 137 |
<type>float</type> |
|
| 138 |
<value>$DayIdentified</value> |
|
| 139 |
</_nullIf> |
|
| 140 |
</day> |
|
| 141 |
<month> |
|
| 142 |
<_nullIf> |
|
| 143 |
<null>0</null> |
|
| 144 |
<type>float</type> |
|
| 145 |
<value>$MonthIdentified</value> |
|
| 146 |
</_nullIf> |
|
| 147 |
</month> |
|
| 148 |
<year> |
|
| 149 |
<_nullIf> |
|
| 150 |
<null>0</null> |
|
| 151 |
<type>float</type> |
|
| 152 |
<value>$YearIdentified</value> |
|
| 153 |
</_nullIf> |
|
| 154 |
</year> |
|
| 155 |
</_date> |
|
| 156 |
</creationdate> |
|
| 157 | 132 |
<parent_id> |
| 158 | 133 |
<taxonlabel> |
| 159 | 134 |
<parent_id> |
| inputs/CVS/taxonObservation_/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
surName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2, |
| 24 | 24 |
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 25 | 25 |
TAXONOBSERVATION_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 26 |
interpretationDate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 27 | 26 |
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 28 | 27 |
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet", |
| 29 | 28 |
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet/_alt/2", |
| inputs/CVS/taxonObservation_/test.xml.ref | ||
|---|---|---|
| 35 | 35 |
<taxonverbatim> |
| 36 | 36 |
<taxonlabel_id> |
| 37 | 37 |
<taxonlabel> |
| 38 |
<creationdate><_dateRangeStart><value>$interpretationDate</value></_dateRangeStart></creationdate> |
|
| 39 | 38 |
<parent_id> |
| 40 | 39 |
<taxonlabel> |
| 41 | 40 |
<rank>$taxonLevel</rank> |
| 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 |
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value/_now, |
|
| 7 | 6 |
: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.)" |
| 8 | 7 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 9 | 8 |
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref | ||
|---|---|---|
| 15 | 15 |
<taxonverbatim> |
| 16 | 16 |
<taxonlabel_id> |
| 17 | 17 |
<taxonlabel> |
| 18 |
<creationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></creationdate> |
|
| 19 | 18 |
<matched_label_id>0</matched_label_id> |
| 20 | 19 |
<parent_id> |
| 21 | 20 |
<taxonlabel> |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 44 | 44 |
GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 45 | 45 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 46 | 46 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 47 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 48 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 49 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 50 | 47 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet", |
| 51 | 48 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 52 | 49 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/ARIZ/Specimen/test.xml.ref | ||
|---|---|---|
| 111 | 111 |
<taxonverbatim> |
| 112 | 112 |
<taxonlabel_id> |
| 113 | 113 |
<taxonlabel> |
| 114 |
<creationdate> |
|
| 115 |
<_date> |
|
| 116 |
<day> |
|
| 117 |
<_nullIf> |
|
| 118 |
<null>0</null> |
|
| 119 |
<type>float</type> |
|
| 120 |
<value>$DayIdentified</value> |
|
| 121 |
</_nullIf> |
|
| 122 |
</day> |
|
| 123 |
<month> |
|
| 124 |
<_nullIf> |
|
| 125 |
<null>0</null> |
|
| 126 |
<type>float</type> |
|
| 127 |
<value>$MonthIdentified</value> |
|
| 128 |
</_nullIf> |
|
| 129 |
</month> |
|
| 130 |
<year> |
|
| 131 |
<_nullIf> |
|
| 132 |
<null>0</null> |
|
| 133 |
<type>float</type> |
|
| 134 |
<value>$YearIdentified</value> |
|
| 135 |
</_nullIf> |
|
| 136 |
</year> |
|
| 137 |
</_date> |
|
| 138 |
</creationdate> |
|
| 139 | 114 |
<parent_id> |
| 140 | 115 |
<taxonlabel> |
| 141 | 116 |
<parent_id> |
| inputs/TRT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 43 | 43 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 44 | 44 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 45 | 45 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 46 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 47 | 46 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 48 | 47 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 49 | 48 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| inputs/TRT/Specimen/test.xml.ref | ||
|---|---|---|
| 118 | 118 |
<taxonverbatim> |
| 119 | 119 |
<taxonlabel_id> |
| 120 | 120 |
<taxonlabel> |
| 121 |
<creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate> |
|
| 122 | 121 |
<parent_id> |
| 123 | 122 |
<taxonlabel> |
| 124 | 123 |
<rank>$taxonRank</rank> |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 32 | 32 |
<taxonverbatim> |
| 33 | 33 |
<taxonlabel_id> |
| 34 | 34 |
<taxonlabel> |
| 35 |
<creationdate><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></creationdate> |
|
| 36 | 35 |
<parent_id> |
| 37 | 36 |
<taxonlabel> |
| 38 | 37 |
<parent_id> |
| inputs/TRTE/Specimen/test.xml.ref | ||
|---|---|---|
| 83 | 83 |
<taxonverbatim> |
| 84 | 84 |
<taxonlabel_id> |
| 85 | 85 |
<taxonlabel> |
| 86 |
<creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate> |
|
| 87 | 86 |
<parent_id> |
| 88 | 87 |
<taxonlabel> |
| 89 | 88 |
<rank>$taxonRank</rank> |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 180 | 180 |
parentScientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 181 | 181 |
parentTaxonConceptID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 182 | 182 |
parentTaxonID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 183 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
|
| 184 |
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 185 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 186 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 187 | 183 |
taxonIsCanonical,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond", |
| 188 | 184 |
parentScientificNameID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 189 | 185 |
parentTaxonConceptID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: Removed creationdate, which duplicates taxondetermination.determinationdate