Revision 7157
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/.TNRS/tnrs_other/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonname", |
| 23 | 23 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/verbatimrank", |
| 24 | 24 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 25 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 26 | 25 |
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", |
| 27 | 26 |
Genus_matched,"/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", |
| 28 | 27 |
Genus_matched,"/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", |
| inputs/.TNRS/tnrs_accepted/VegBIEN.csv | ||
|---|---|---|
| 24 | 24 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/verbatimrank", |
| 25 | 25 |
: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 accepted names (names that scrub to themselves) |
| 26 | 26 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 27 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 28 | 27 |
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", |
| 29 | 28 |
:true,"/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""]/cond/_exists",This table contains only accepted names (names that scrub to themselves) |
| 30 | 29 |
Genus_matched,"/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/VegBIEN.csv | ||
|---|---|---|
| 52 | 52 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 53 | 53 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 54 | 54 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 55 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 56 | 55 |
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", |
| 57 | 56 |
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", |
| 58 | 57 |
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", |
| inputs/VASCAN/Taxon/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 11 | 11 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 12 | 12 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 13 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 14 | 13 |
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", |
| 15 | 14 |
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", |
| 16 | 15 |
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", |
| inputs/VegBank/stemcount_/VegBIEN.csv | ||
|---|---|---|
| 32 | 32 |
HAVING count(distinct taxonimportance_id) > 1 |
| 33 | 33 |
-----" |
| 34 | 34 |
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists", |
| 35 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1]. |
|
| 36 |
|
|
| 37 |
[1] The following query returns rows: |
|
| 38 |
----- |
|
| 39 |
SELECT taxonobservation_id, count(distinct taxonimportance_id) |
|
| 40 |
FROM ""VegBank"".taxonimportance |
|
| 41 |
GROUP BY taxonobservation_id |
|
| 42 |
HAVING count(distinct taxonimportance_id) > 1 |
|
| 43 |
-----" |
|
| 44 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1]. |
|
| 45 |
|
|
| 46 |
[1] The following query returns rows: |
|
| 47 |
----- |
|
| 48 |
SELECT taxonobservation_id, count(distinct taxonimportance_id) |
|
| 49 |
FROM ""VegBank"".taxonimportance |
|
| 50 |
GROUP BY taxonobservation_id |
|
| 51 |
HAVING count(distinct taxonimportance_id) > 1 |
|
| 52 |
-----" |
|
| 35 | 53 |
basalarea,,** No join mapping for *basalarea ** |
| 36 | 54 |
biomass,,** No join mapping for *biomass ** |
| 37 | 55 |
covercode,,** No join mapping for *covercode ** |
| inputs/TRTE/Specimen/test.xml.ref | ||
|---|---|---|
| 123 | 123 |
<parent_id> |
| 124 | 124 |
<taxonlabel> |
| 125 | 125 |
<rank>$taxonRank</rank> |
| 126 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 127 | 126 |
<parent_id> |
| 128 | 127 |
<taxonlabel> |
| 129 | 128 |
<rank>cultivar</rank> |
| ... | ... | |
| 308 | 307 |
</path> |
| 309 | 308 |
</_setDefault> |
| 310 | 309 |
</VegBIEN> |
| 311 |
Inserted 35 new rows into database |
|
| 310 |
Inserted 34 new rows into database |
|
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 37 | 37 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet", |
| 38 | 38 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet", |
| 39 | 39 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 40 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 40 | 41 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
| 41 | 42 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 42 | 43 |
Species,/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, |
| ... | ... | |
| 46 | 47 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family, |
| 47 | 48 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 48 | 49 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 50 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 49 | 51 |
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value, |
| 50 | 52 |
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 51 | 53 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1, |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 226 | 226 |
parentTaxonConceptID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 227 | 227 |
parentTaxonID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 228 | 228 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 229 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 230 | 229 |
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=cultivar]/taxonepithet", |
| 231 | 230 |
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", |
| 232 | 231 |
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", |
| inputs/bien2_traits/TraitObservation/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 21 | 21 |
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 22 | 22 |
InfraspecificRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 23 |
InfraspecificRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 24 | 23 |
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", |
| 25 | 24 |
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", |
| 26 | 25 |
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", |
| inputs/bien2_traits/TraitObservation/test.xml.ref | ||
|---|---|---|
| 66 | 66 |
<parent_id> |
| 67 | 67 |
<taxonlabel> |
| 68 | 68 |
<rank>$InfraspecificRank</rank> |
| 69 |
<taxonverbatim><verbatimrank>$InfraspecificRank</verbatimrank></taxonverbatim> |
|
| 70 | 69 |
<parent_id> |
| 71 | 70 |
<taxonlabel> |
| 72 | 71 |
<rank>cultivar</rank> |
| ... | ... | |
| 188 | 187 |
</path> |
| 189 | 188 |
</_setDefault> |
| 190 | 189 |
</VegBIEN> |
| 191 |
Inserted 35 new rows into database |
|
| 190 |
Inserted 33 new rows into database |
|
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 47 | 47 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 48 | 48 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 49 | 49 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 50 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 51 | 50 |
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", |
| 52 | 51 |
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", |
| 53 | 52 |
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", |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 123 | 123 |
<parent_id> |
| 124 | 124 |
<taxonlabel> |
| 125 | 125 |
<rank>$taxonRank</rank> |
| 126 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 127 | 126 |
<parent_id> |
| 128 | 127 |
<taxonlabel> |
| 129 | 128 |
<rank>cultivar</rank> |
| ... | ... | |
| 309 | 308 |
</path> |
| 310 | 309 |
</_setDefault> |
| 311 | 310 |
</VegBIEN> |
| 312 |
Inserted 47 new rows into database |
|
| 311 |
Inserted 45 new rows into database |
|
| inputs/.NCBI/nodes/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
parent tax_id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 5 | 5 |
parent tax_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 6 | 6 |
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 7 |
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 8 | 7 |
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank, |
| 9 | 8 |
tax_id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode, |
| 10 | 9 |
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank", |
| inputs/WIN/Specimen/VegBIEN.csv | ||
|---|---|---|
| 47 | 47 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 48 | 48 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 49 | 49 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 50 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 51 | 50 |
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", |
| 52 | 51 |
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", |
| 53 | 52 |
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", |
| inputs/WIN/Specimen/test.xml.ref | ||
|---|---|---|
| 123 | 123 |
<parent_id> |
| 124 | 124 |
<taxonlabel> |
| 125 | 125 |
<rank>$taxonRank</rank> |
| 126 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 127 | 126 |
<parent_id> |
| 128 | 127 |
<taxonlabel> |
| 129 | 128 |
<rank>cultivar</rank> |
| ... | ... | |
| 302 | 301 |
</path> |
| 303 | 302 |
</_setDefault> |
| 304 | 303 |
</VegBIEN> |
| 305 |
Inserted 37 new rows into database |
|
| 304 |
Inserted 36 new rows into database |
|
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
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", |
| 23 | 23 |
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", |
| 24 | 24 |
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]/taxonepithet", |
| 25 |
SpeciesInvID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 25 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
| 26 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 27 | 28 |
SpeciesName,/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, |
| ... | ... | |
| 31 | 32 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family, |
| 32 | 33 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 33 | 34 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 35 |
SpeciesInvID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 34 | 36 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
| 35 | 37 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
| 36 | 38 |
Description,,** No join mapping for *Description ** |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 105 | 105 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 106 | 106 |
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2",Brad: This is the author of the scientificName. |
| 107 | 107 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 108 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 109 | 108 |
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", |
| 110 | 109 |
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", |
| 111 | 110 |
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", |
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 191 | 191 |
<parent_id> |
| 192 | 192 |
<taxonlabel> |
| 193 | 193 |
<rank>$infra_rank_1</rank> |
| 194 |
<taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim> |
|
| 195 | 194 |
<parent_id> |
| 196 | 195 |
<taxonlabel> |
| 197 | 196 |
<rank>cultivar</rank> |
| ... | ... | |
| 391 | 390 |
</path> |
| 392 | 391 |
</_setDefault> |
| 393 | 392 |
</VegBIEN> |
| 394 |
Inserted 52 new rows into database |
|
| 393 |
Inserted 50 new rows into database |
|
| inputs/QFA/Specimen/VegBIEN.csv | ||
|---|---|---|
| 49 | 49 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 50 | 50 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 51 | 51 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 52 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 53 | 52 |
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", |
| 54 | 53 |
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", |
| 55 | 54 |
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", |
| inputs/QFA/Specimen/test.xml.ref | ||
|---|---|---|
| 139 | 139 |
<parent_id> |
| 140 | 140 |
<taxonlabel> |
| 141 | 141 |
<rank>$taxonRank</rank> |
| 142 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 143 | 142 |
<parent_id> |
| 144 | 143 |
<taxonlabel> |
| 145 | 144 |
<rank>cultivar</rank> |
| ... | ... | |
| 323 | 322 |
</path> |
| 324 | 323 |
</_setDefault> |
| 325 | 324 |
</VegBIEN> |
| 326 |
Inserted 47 new rows into database |
|
| 325 |
Inserted 45 new rows into database |
|
| inputs/UBC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 47 | 47 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 48 | 48 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 49 | 49 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 50 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 51 | 50 |
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", |
| 52 | 51 |
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", |
| 53 | 52 |
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", |
| inputs/UBC/Specimen/test.xml.ref | ||
|---|---|---|
| 123 | 123 |
<parent_id> |
| 124 | 124 |
<taxonlabel> |
| 125 | 125 |
<rank>$taxonRank</rank> |
| 126 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 127 | 126 |
<parent_id> |
| 128 | 127 |
<taxonlabel> |
| 129 | 128 |
<rank>cultivar</rank> |
| ... | ... | |
| 309 | 308 |
</path> |
| 310 | 309 |
</_setDefault> |
| 311 | 310 |
</VegBIEN> |
| 312 |
Inserted 43 new rows into database |
|
| 311 |
Inserted 41 new rows into database |
|
| inputs/HIBG/Specimen/VegBIEN.csv | ||
|---|---|---|
| 47 | 47 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 48 | 48 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 49 | 49 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 50 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 51 | 50 |
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", |
| 52 | 51 |
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", |
| 53 | 52 |
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", |
| inputs/HIBG/Specimen/test.xml.ref | ||
|---|---|---|
| 123 | 123 |
<parent_id> |
| 124 | 124 |
<taxonlabel> |
| 125 | 125 |
<rank>$taxonRank</rank> |
| 126 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 127 | 126 |
<parent_id> |
| 128 | 127 |
<taxonlabel> |
| 129 | 128 |
<rank>cultivar</rank> |
| ... | ... | |
| 310 | 309 |
</path> |
| 311 | 310 |
</_setDefault> |
| 312 | 311 |
</VegBIEN> |
| 313 |
Inserted 40 new rows into database |
|
| 312 |
Inserted 39 new rows into database |
|
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 109 | 109 |
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 110 | 110 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1", |
| 111 | 111 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/2", |
| 112 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank/_alt/1", |
|
| 113 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank/_alt/2", |
|
| 114 | 112 |
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", |
| 115 | 113 |
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", |
| 116 | 114 |
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", |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 161 | 161 |
<2>$infrarank</2> |
| 162 | 162 |
</_alt> |
| 163 | 163 |
</rank> |
| 164 |
<taxonverbatim> |
|
| 165 |
<verbatimrank> |
|
| 166 |
<_alt> |
|
| 167 |
<1>$usdaRank</1> |
|
| 168 |
<2>$infrarank</2> |
|
| 169 |
</_alt> |
|
| 170 |
</verbatimrank> |
|
| 171 |
</taxonverbatim> |
|
| 172 | 164 |
<parent_id> |
| 173 | 165 |
<taxonlabel> |
| 174 | 166 |
<rank>cultivar</rank> |
| ... | ... | |
| 305 | 297 |
</path> |
| 306 | 298 |
</_setDefault> |
| 307 | 299 |
</VegBIEN> |
| 308 |
Inserted 29 new rows into database |
|
| 300 |
Inserted 28 new rows into database |
|
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 111 | 111 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 112 | 112 |
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2",Brad: This is the author of the scientificName. |
| 113 | 113 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 114 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 115 | 114 |
specific_epithet,"/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", |
| 116 | 115 |
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", |
| 117 | 116 |
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", |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 219 | 219 |
<parent_id> |
| 220 | 220 |
<taxonlabel> |
| 221 | 221 |
<rank>$infra_rank_1</rank> |
| 222 |
<taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim> |
|
| 223 | 222 |
<parent_id> |
| 224 | 223 |
<taxonlabel> |
| 225 | 224 |
<rank>cultivar</rank> |
| ... | ... | |
| 407 | 406 |
</path> |
| 408 | 407 |
</_setDefault> |
| 409 | 408 |
</VegBIEN> |
| 410 |
Inserted 54 new rows into database |
|
| 409 |
Inserted 52 new rows into database |
|
| inputs/CVS/stemCount_/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
taxonObservation_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 9 | 9 |
taxonObservation_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 10 | 10 |
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists", |
| 11 |
taxonObservation_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 12 |
taxonObservation_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 11 | 13 |
basalArea,,** No join mapping for *basalarea ** |
| 12 | 14 |
biomass,,** No join mapping for *biomass ** |
| 13 | 15 |
cust_cvs_StemFrequency,,** No join mapping for *cust_cvs_StemFrequency ** |
| inputs/CVS/taxonObservation_/VegBIEN.csv | ||
|---|---|---|
| 36 | 36 |
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""var. ""]/2", |
| 37 | 37 |
interpretationDate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 38 | 38 |
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 39 |
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 40 | 39 |
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", |
| 41 | 40 |
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", |
| 42 | 41 |
denorm_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/_alt/1", |
| ... | ... | |
| 55 | 54 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet/_alt/2", |
| 56 | 55 |
taxonLevel,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank, |
| 57 | 56 |
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank", |
| 57 |
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 58 | 58 |
denorm_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_alt/1, |
| 59 | 59 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_alt/2, |
| 60 | 60 |
plantNameWithAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1, |
| ... | ... | |
| 75 | 75 |
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname, |
| 76 | 76 |
plantNameWithAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname, |
| 77 | 77 |
taxonLevel,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 78 |
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 78 | 79 |
interpretationDate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value, |
| 79 | 80 |
taxonFit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 80 | 81 |
authorPlantName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1, |
| inputs/CVS/taxonObservation_/test.xml.ref | ||
|---|---|---|
| 91 | 91 |
<parent_id> |
| 92 | 92 |
<taxonlabel> |
| 93 | 93 |
<rank>$taxonLevel</rank> |
| 94 |
<taxonverbatim><verbatimrank>$taxonLevel</verbatimrank></taxonverbatim> |
|
| 95 | 94 |
<parent_id> |
| 96 | 95 |
<taxonlabel> |
| 97 | 96 |
<rank>cultivar</rank> |
| ... | ... | |
| 280 | 279 |
</path> |
| 281 | 280 |
</_setDefault> |
| 282 | 281 |
</VegBIEN> |
| 283 |
Inserted 31 new rows into database |
|
| 282 |
Inserted 30 new rows into database |
|
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/then", |
| 20 | 20 |
: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.)" |
| 21 | 21 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 22 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 23 | 22 |
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", |
| 24 | 23 |
:true,"/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""]/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.)" |
| 25 | 24 |
Genus_matched,"/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/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref | ||
|---|---|---|
| 20 | 20 |
<parent_id> |
| 21 | 21 |
<taxonlabel> |
| 22 | 22 |
<rank>$Name_matched_rank</rank> |
| 23 |
<taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim> |
|
| 24 | 23 |
<parent_id> |
| 25 | 24 |
<taxonlabel> |
| 26 | 25 |
<rank>cultivar</rank> |
| inputs/.TNRS/tnrs_other/test.xml.ref | ||
|---|---|---|
| 54 | 54 |
<parent_id> |
| 55 | 55 |
<taxonlabel> |
| 56 | 56 |
<rank>$Name_matched_rank</rank> |
| 57 |
<taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim> |
|
| 58 | 57 |
<parent_id> |
| 59 | 58 |
<taxonlabel> |
| 60 | 59 |
<rank>cultivar</rank> |
| ... | ... | |
| 170 | 169 |
</path> |
| 171 | 170 |
</_setDefault> |
| 172 | 171 |
</VegBIEN> |
| 173 |
Inserted 15 new rows into database |
|
| 172 |
Inserted 13 new rows into database |
|
| inputs/.TNRS/tnrs_accepted/test.xml.ref | ||
|---|---|---|
| 18 | 18 |
<parent_id> |
| 19 | 19 |
<taxonlabel> |
| 20 | 20 |
<rank>$Name_matched_rank</rank> |
| 21 |
<taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim> |
|
| 22 | 21 |
<parent_id> |
| 23 | 22 |
<taxonlabel> |
| 24 | 23 |
<rank>cultivar</rank> |
| ... | ... | |
| 146 | 145 |
</path> |
| 147 | 146 |
</_setDefault> |
| 148 | 147 |
</VegBIEN> |
| 149 |
Inserted 18 new rows into database |
|
| 148 |
Inserted 16 new rows into database |
|
| inputs/TRT/Specimen/test.xml.ref | ||
|---|---|---|
| 158 | 158 |
<parent_id> |
| 159 | 159 |
<taxonlabel> |
| 160 | 160 |
<rank>$taxonRank</rank> |
| 161 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 162 | 161 |
<parent_id> |
| 163 | 162 |
<taxonlabel> |
| 164 | 163 |
<rank>cultivar</rank> |
| ... | ... | |
| 346 | 345 |
</path> |
| 347 | 346 |
</_setDefault> |
| 348 | 347 |
</VegBIEN> |
| 349 |
Inserted 43 new rows into database |
|
| 348 |
Inserted 41 new rows into database |
|
| inputs/VASCAN/Taxon/test.xml.ref | ||
|---|---|---|
| 55 | 55 |
<parent_id> |
| 56 | 56 |
<taxonlabel> |
| 57 | 57 |
<rank>$taxonRank</rank> |
| 58 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim> |
|
| 59 | 58 |
<parent_id> |
| 60 | 59 |
<taxonlabel> |
| 61 | 60 |
<rank>cultivar</rank> |
| ... | ... | |
| 174 | 173 |
</path> |
| 175 | 174 |
</_setDefault> |
| 176 | 175 |
</VegBIEN> |
| 177 |
Inserted 13 new rows into database |
|
| 176 |
Inserted 11 new rows into database |
|
| inputs/TRTE/Specimen/VegBIEN.csv | ||
|---|---|---|
| 47 | 47 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2", |
| 48 | 48 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value, |
| 49 | 49 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 50 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 51 | 50 |
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", |
| 52 | 51 |
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", |
| 53 | 52 |
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", |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 226 | 226 |
parentTaxonConceptID,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 227 | 227 |
parentTaxonID,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 228 | 228 |
taxonRank,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 229 |
taxonRank,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
|
| 230 | 229 |
cultivar,//taxonlabel/parent_id[rank=cultivar]/taxonepithet, |
| 231 | 230 |
forma,//taxonlabel/parent_id[rank=forma]/taxonepithet, |
| 232 | 231 |
variety,//taxonlabel/parent_id[rank=variety]/taxonepithet, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: primary taxonlabel's parent taxonlabel: Fixed bug where a taxonverbatim was incorrectly being created solely to store the taxonRank, even though it was already stored in the taxonlabel's rank field