Revision 5931
Added by Aaron Marcuse-Kubitza over 12 years ago
inputs/.TNRS/tnrs_other/VegBIEN.csv | ||
---|---|---|
10 | 10 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
11 | 11 |
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
12 | 12 |
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name |
13 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank,
|
|
14 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf:[null=Unknown]/value,
|
|
15 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
|
|
16 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
|
|
17 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,
|
|
18 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/author,
|
|
19 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/binomial,
|
|
20 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/family/_nullIf:[null=Unknown]/value,
|
|
21 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/verbatimrank,
|
|
13 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank",
|
|
14 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf:[null=Unknown]/value",
|
|
15 |
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
|
|
16 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
|
|
17 |
Accepted_name_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2",
|
|
18 |
Accepted_name_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/author",
|
|
19 |
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/binomial",
|
|
20 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/family/_nullIf:[null=Unknown]/value",
|
|
21 |
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",
|
|
22 | 22 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
23 | 23 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
24 | 24 |
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/tnrs_other/test.xml.ref | ||
---|---|---|
11 | 11 |
<taxonverbatim> |
12 | 12 |
<taxonlabel_id> |
13 | 13 |
<taxonlabel> |
14 |
<_taxonlabel_set_matched_label_id> |
|
15 |
<matched_label_id> |
|
16 |
<taxonlabel> |
|
17 |
<rank>$Accepted_name_rank</rank> |
|
18 |
<taxonomicname> |
|
19 |
<_join_words> |
|
20 |
<1> |
|
21 |
<_taxon_family_require_std> |
|
22 |
<family> |
|
23 |
<_nullIf> |
|
24 |
<null>Unknown</null> |
|
25 |
<value>$Accepted_name_family</value> |
|
26 |
</_nullIf> |
|
27 |
</family> |
|
28 |
</_taxon_family_require_std> |
|
29 |
</1> |
|
30 |
<2> |
|
31 |
<_join_words> |
|
32 |
<1>$Accepted_name</1> |
|
33 |
<2>$Accepted_name_author</2> |
|
34 |
</_join_words> |
|
35 |
</2> |
|
36 |
</_join_words> |
|
37 |
</taxonomicname> |
|
38 |
<taxonverbatim> |
|
39 |
<author>$Accepted_name_author</author> |
|
40 |
<binomial>$Accepted_name</binomial> |
|
41 |
<family> |
|
42 |
<_nullIf> |
|
43 |
<null>Unknown</null> |
|
44 |
<value>$Accepted_name_family</value> |
|
45 |
</_nullIf> |
|
46 |
</family> |
|
47 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
|
48 |
</taxonverbatim> |
|
49 |
</taxonlabel> |
|
50 |
</matched_label_id> |
|
51 |
</_taxonlabel_set_matched_label_id> |
|
14 |
<matched_label_id> |
|
15 |
<taxonlabel> |
|
16 |
<rank>$Accepted_name_rank</rank> |
|
17 |
<taxonomicname> |
|
18 |
<_join_words> |
|
19 |
<1> |
|
20 |
<_taxon_family_require_std> |
|
21 |
<family> |
|
22 |
<_nullIf> |
|
23 |
<null>Unknown</null> |
|
24 |
<value>$Accepted_name_family</value> |
|
25 |
</_nullIf> |
|
26 |
</family> |
|
27 |
</_taxon_family_require_std> |
|
28 |
</1> |
|
29 |
<2> |
|
30 |
<_join_words> |
|
31 |
<1>$Accepted_name</1> |
|
32 |
<2>$Accepted_name_author</2> |
|
33 |
</_join_words> |
|
34 |
</2> |
|
35 |
</_join_words> |
|
36 |
</taxonomicname> |
|
37 |
<taxonverbatim> |
|
38 |
<author>$Accepted_name_author</author> |
|
39 |
<binomial>$Accepted_name</binomial> |
|
40 |
<family> |
|
41 |
<_nullIf> |
|
42 |
<null>Unknown</null> |
|
43 |
<value>$Accepted_name_family</value> |
|
44 |
</_nullIf> |
|
45 |
</family> |
|
46 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
|
47 |
</taxonverbatim> |
|
48 |
</taxonlabel> |
|
49 |
</matched_label_id> |
|
52 | 50 |
<parent_id> |
53 | 51 |
<taxonlabel> |
54 | 52 |
<rank>$Name_matched_rank</rank> |
inputs/.TNRS/tnrs_accepted/VegBIEN.csv | ||
---|---|---|
10 | 10 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
11 | 11 |
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
12 | 12 |
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name |
13 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank,
|
|
14 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf:[null=Unknown]/value,
|
|
15 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
|
|
16 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
|
|
17 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,
|
|
18 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/author,
|
|
19 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/binomial,
|
|
20 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/family/_nullIf:[null=Unknown]/value,
|
|
21 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/verbatimrank,
|
|
13 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank",
|
|
14 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf:[null=Unknown]/value",
|
|
15 |
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
|
|
16 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
|
|
17 |
Accepted_name_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2",
|
|
18 |
Accepted_name_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/author",
|
|
19 |
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/binomial",
|
|
20 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/family/_nullIf:[null=Unknown]/value",
|
|
21 |
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",
|
|
22 | 22 |
: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) |
23 | 23 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
24 | 24 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank", |
inputs/.TNRS/tnrs_accepted/test.xml.ref | ||
---|---|---|
11 | 11 |
<taxonverbatim> |
12 | 12 |
<taxonlabel_id> |
13 | 13 |
<taxonlabel> |
14 |
<_taxonlabel_set_matched_label_id> |
|
15 |
<matched_label_id> |
|
16 |
<taxonlabel> |
|
17 |
<rank>$Accepted_name_rank</rank> |
|
18 |
<taxonomicname> |
|
19 |
<_join_words> |
|
20 |
<1> |
|
21 |
<_taxon_family_require_std> |
|
22 |
<family> |
|
23 |
<_nullIf> |
|
24 |
<null>Unknown</null> |
|
25 |
<value>$Accepted_name_family</value> |
|
26 |
</_nullIf> |
|
27 |
</family> |
|
28 |
</_taxon_family_require_std> |
|
29 |
</1> |
|
30 |
<2> |
|
31 |
<_join_words> |
|
32 |
<1>$Accepted_name</1> |
|
33 |
<2>$Accepted_name_author</2> |
|
34 |
</_join_words> |
|
35 |
</2> |
|
36 |
</_join_words> |
|
37 |
</taxonomicname> |
|
38 |
<taxonverbatim> |
|
39 |
<author>$Accepted_name_author</author> |
|
40 |
<binomial>$Accepted_name</binomial> |
|
41 |
<family> |
|
42 |
<_nullIf> |
|
43 |
<null>Unknown</null> |
|
44 |
<value>$Accepted_name_family</value> |
|
45 |
</_nullIf> |
|
46 |
</family> |
|
47 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
|
48 |
</taxonverbatim> |
|
49 |
</taxonlabel> |
|
50 |
</matched_label_id> |
|
51 |
</_taxonlabel_set_matched_label_id> |
|
52 | 14 |
<matched_label_id>0</matched_label_id> |
53 | 15 |
<parent_id> |
54 | 16 |
<taxonlabel> |
mappings/VegCore-VegBIEN.csv | ||
---|---|---|
138 | 138 |
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2", |
139 | 139 |
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/9/_join_words:[1=""cult. ""]/2", |
140 | 140 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2", |
141 |
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank, |
|
142 |
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family, |
|
143 |
acceptedScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/1, |
|
144 |
acceptedBinomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1, |
|
145 |
acceptedGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
146 |
acceptedSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
147 |
acceptedSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/4, |
|
148 |
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
149 |
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
|
150 |
acceptedInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
|
151 |
acceptedVariety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2", |
|
152 |
acceptedForma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2", |
|
153 |
acceptedCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2", |
|
154 |
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2, |
|
155 |
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/author, |
|
156 |
acceptedBinomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/binomial, |
|
157 |
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/family, |
|
158 |
acceptedGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/genus, |
|
159 |
acceptedSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/specific_epithet, |
|
160 |
acceptedScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/taxonomicname, |
|
161 |
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/verbatimrank, |
|
162 | 141 |
parentScientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
163 | 142 |
parentTaxonConceptID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
164 | 143 |
parentTaxonID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
... | ... | |
168 | 147 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
169 | 148 |
accordingTo,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/1, |
170 | 149 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
150 |
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank", |
|
151 |
acceptedFamily,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family", |
|
152 |
acceptedScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/1", |
|
153 |
acceptedBinomial,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1", |
|
154 |
acceptedGenus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2", |
|
155 |
acceptedSpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3", |
|
156 |
acceptedSubspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/4", |
|
157 |
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
158 |
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
|
159 |
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
|
160 |
acceptedVariety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2", |
|
161 |
acceptedForma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2", |
|
162 |
acceptedCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2", |
|
163 |
acceptedScientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2", |
|
164 |
acceptedScientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/author", |
|
165 |
acceptedBinomial,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/binomial", |
|
166 |
acceptedFamily,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/family", |
|
167 |
acceptedGenus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/genus", |
|
168 |
acceptedSpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/specific_epithet", |
|
169 |
acceptedScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonomicname", |
|
170 |
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/verbatimrank", |
|
171 | 171 |
taxonIsCanonical,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond", |
172 | 172 |
parentScientificNameID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
173 | 173 |
parentTaxonConceptID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
mappings/for_review/VegCore-VegBIEN.csv | ||
---|---|---|
138 | 138 |
forma,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel/taxonomicname", |
139 | 139 |
cultivar,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel/taxonomicname", |
140 | 140 |
scientificNameAuthorship,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel/taxonomicname", |
141 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/rank, |
|
142 |
acceptedFamily,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
143 |
acceptedScientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
144 |
acceptedBinomial,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
145 |
acceptedGenus,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
146 |
acceptedSpecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
147 |
acceptedSubspecies,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
148 |
acceptedInfraspecificEpithet,"//*_id/taxonlabel/taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/cond", |
|
149 |
acceptedTaxonRank,"//*_id/taxonlabel/taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/then", |
|
150 |
acceptedInfraspecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
151 |
acceptedVariety,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
152 |
acceptedForma,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
153 |
acceptedCultivar,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
154 |
acceptedScientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
155 |
acceptedScientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonverbatim/author, |
|
156 |
acceptedBinomial,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonverbatim/binomial, |
|
157 |
acceptedFamily,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonverbatim/family, |
|
158 |
acceptedGenus,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonverbatim/genus, |
|
159 |
acceptedSpecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonverbatim/specific_epithet, |
|
160 |
acceptedScientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonverbatim/taxonomicname, |
|
161 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/taxonverbatim/verbatimrank, |
|
162 | 141 |
parentScientificNameID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
163 | 142 |
parentTaxonConceptID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
164 | 143 |
parentTaxonID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
... | ... | |
168 | 147 |
yearIdentified,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/creationdate, |
169 | 148 |
accordingTo,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/creator_id/party/fullname, |
170 | 149 |
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/creator_id/party/fullname, |
150 |
acceptedTaxonRank,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank", |
|
151 |
acceptedFamily,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
152 |
acceptedScientificName,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
153 |
acceptedBinomial,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
154 |
acceptedGenus,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
155 |
acceptedSpecificEpithet,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
156 |
acceptedSubspecies,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
157 |
acceptedInfraspecificEpithet,"//taxonlabel/matched_label_id/taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/cond", |
|
158 |
acceptedTaxonRank,"//taxonlabel/matched_label_id/taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/then", |
|
159 |
acceptedInfraspecificEpithet,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
160 |
acceptedVariety,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
161 |
acceptedForma,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
162 |
acceptedCultivar,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
163 |
acceptedScientificNameAuthorship,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname", |
|
164 |
acceptedScientificNameAuthorship,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/author", |
|
165 |
acceptedBinomial,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/binomial", |
|
166 |
acceptedFamily,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/family", |
|
167 |
acceptedGenus,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/genus", |
|
168 |
acceptedSpecificEpithet,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/specific_epithet", |
|
169 |
acceptedScientificName,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonomicname", |
|
170 |
acceptedTaxonRank,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/verbatimrank", |
|
171 | 171 |
taxonIsCanonical,"//taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/cond", |
172 | 172 |
parentScientificNameID,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
173 | 173 |
parentTaxonConceptID,"//parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: accepted* taxonomic terms: If is canonical name, don't populate a separate accepted taxonlabel because the taxonlabel itself is accepted. If is not canonical name, populate matched_label_id directly when the row is created instead of waiting until after all rows are created and using _taxonlabel_set_matched_label_id(). This is possible now that accepted taxonlabels occur only in TNRS's tnrs_accepted table, which is specially marked as taxonIsCanonical. Avoiding _taxonlabel_set_matched_label_id() should fix the slowdown that occurs when it's used on large tables.