Project

General

Profile

« Previous | Next » 

Revision 5931

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.

View differences:

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