Project

General

Profile

« Previous | Next » 

Revision 7070

Added by Aaron Marcuse-Kubitza almost 12 years ago

Added inputs/.TNRS/public.unscrubbed_taxondetermination_view/

View differences:

inputs/.TNRS/public.unscrubbed_taxondetermination_view/header.csv
1 
taxonoccurrence_id,Time_submitted,Name_number,Name_submitted,Overall_score,Name_matched,Name_matched_rank,Name_score,Name_matched_author,Name_matched_url,Author_matched,Author_score,Family_matched,Family_score,Name_matched_accepted_family,Genus_matched,Genus_score,Specific_epithet_matched,Specific_epithet_score,Infraspecific_rank,Infraspecific_epithet_matched,Infraspecific_epithet_score,Infraspecific_rank_2,Infraspecific_epithet_2_matched,Infraspecific_epithet_2_score,Annotations,Unmatched_terms,Taxonomic_status,Accepted_name,Accepted_name_author,Accepted_name_rank,Accepted_name_url,Accepted_name_species,Accepted_name_family,Selected,Source,Warnings,Accepted_name_lsid
inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv
1 
TNRS,VegCore,Filter,Comments
2 
taxonoccurrence_id,taxonOccurrencePkey,,
3 
Time_submitted,*Time_submitted,,
4 
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.
5 
Name_submitted,verbatimScientificName,,
6 
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values
7 
Name_matched,verbatimTaxonName,,
8 
Name_matched,taxonName,,
9 
Name_matched_rank,taxonRank,,
10 
Name_score,*Name_score,,
11 
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name
12 
Name_matched_url,scientificNameID,,
13 
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string
14 
Author_score,*Author_score,,
15 
Family_matched,verbatimFamily,,Contains family in original string (uncommon)
16 
Family_score,matchedFamilyFit_fraction,,
17 
Name_matched_accepted_family,family,,Contains family based on matched name
18 
Genus_matched,verbatimGenus,,
19 
Genus_matched,genus,,
20 
Genus_score,matchedGenusFit_fraction,,
21 
Specific_epithet_matched,verbatimSpecificEpithet,,
22 
Specific_epithet_matched,specificEpithet,,
23 
Specific_epithet_score,matchedSpeciesFit_fraction,,
24 
Infraspecific_rank,verbatimTaxonRank,,
25 
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,
26 
Infraspecific_epithet_matched,infraspecificEpithet,,
27 
Infraspecific_epithet_score,*Infraspecific_epithet_score,,
28 
Infraspecific_rank_2,UNUSED,,
29 
Infraspecific_epithet_2_matched,UNUSED,,
30 
Infraspecific_epithet_2_score,UNUSED,,
31 
Annotations,*Annotations,,
32 
Unmatched_terms,morphospecies,,
33 
Taxonomic_status,taxonomicStatus,,
34 
Accepted_name,acceptedTaxonName,,
35 
Accepted_name_author,acceptedScientificNameAuthorship,,
36 
Accepted_name_rank,acceptedTaxonRank,,
37 
Accepted_name_url,*Accepted_name_url,,
38 
Accepted_name_species,*Accepted_name_species,,Also contains genus. Omitted because Accepted_name contains more info.
39 
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,
40 
Selected,*Selected,,
41 
Source,*Source,,
42 
Warnings,*Warnings,,
43 
Accepted_name_lsid,*Accepted_name_lsid,,
inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv
1 
TNRS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
3 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",
4 
Name_matched,"/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/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1",
5 
Name_matched_accepted_family,"/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/_join_words/1/_taxon_family_require_std/family/_nullIf/value",Contains family based on matched name
6 
Name_matched,"/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/_join_words/2/_alt/2/_join_words/1/_alt/1",
7 
Genus_matched,"/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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
8 
Specific_epithet_matched,"/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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
9 
Unmatched_terms,"/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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2",
10 
Infraspecific_epithet_matched,"/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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
11 
Name_matched_rank,"/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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
12 
Infraspecific_epithet_matched,"/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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
13 
Name_matched_author,"/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/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name
14 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank",
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/1/_taxon_family_require_std/family/_nullIf/null/_first/1",
16 
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/value/_nullIf:[null=Unknown]/value",
17 
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",
18 
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",
19 
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",
20 
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",
21 
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",
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 
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 
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 
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 
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 
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",
29 
Name_matched_accepted_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",Contains family based on matched name
30 
Name_matched_accepted_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",Contains family based on matched name
31 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
32 
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
33 
Name_matched_url,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode,
34 
Name_matched_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",
35 
Family_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/1,
36 
Genus_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/2,
37 
Specific_epithet_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/3,
38 
Overall_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/4,Assuming is a fraction based on the range of values
39 
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonepithet,
40 
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonomicname,
41 
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/author,Contains author in original string
42 
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/family,Contains family in original string (uncommon)
43 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/genus,
44 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
45 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/then",
46 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/specific_epithet,
47 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/taxonname,
48 
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/verbatimrank,
49 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1,
50 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value,Contains family based on matched name
51 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
52 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,
53 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
54 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",
55 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else",
56 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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",
57 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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",
58 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
59 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,Contains author based on matched name
60 
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonstatus,
61 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,Contains author based on matched name
62 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,Contains family based on matched name
63 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
64 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
65 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",
66 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
67 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
68 
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
69 
taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id,
70 
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid **
71 
Accepted_name_species,,** No join mapping for *Accepted_name_species ** Also contains genus. Omitted because Accepted_name contains more info.
72 
Accepted_name_url,,** No join mapping for *Accepted_name_url **
73 
Annotations,,** No join mapping for *Annotations **
74 
Author_score,,** No join mapping for *Author_score **
75 
Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED **
76 
Infraspecific_epithet_2_score,,** No non-empty join mapping for UNUSED **
77 
Infraspecific_epithet_matched,,** No join mapping for verbatimInfraspecificEpithet **
78 
Infraspecific_epithet_score,,** No join mapping for *Infraspecific_epithet_score **
79 
Infraspecific_rank_2,,** No non-empty join mapping for UNUSED **
80 
Name_number,,** No non-empty join mapping for OMIT ** Identifies name only within one TNRS batch. Omitted because not globally unique.
81 
Name_score,,** No join mapping for *Name_score **
82 
Selected,,** No join mapping for *Selected **
83 
Source,,** No join mapping for *Source **
84 
Time_submitted,,** No join mapping for *Time_submitted **
85 
Warnings,,** No join mapping for *Warnings **
inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>TNRS</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationevent>
11 
                            <taxonoccurrence>
12 
                                <taxondetermination>
13 
                                    <taxonverbatim_id>
14 
                                        <taxonverbatim>
15 
                                            <taxonlabel_id>
16 
                                                <taxonlabel>
17 
                                                    <matched_label_id>
18 
                                                        <taxonlabel>
19 
                                                            <rank>$Accepted_name_rank</rank>
20 
                                                            <taxonomicname>
21 
                                                                <_join_words>
22 
                                                                    <1>
23 
                                                                        <_taxon_family_require_std>
24 
                                                                            <family>
25 
                                                                                <_nullIf>
26 
                                                                                    <null>$Accepted_name</null>
27 
                                                                                    <value>
28 
                                                                                        <_nullIf>
29 
                                                                                            <null>Unknown</null>
30 
                                                                                            <value>$Accepted_name_family</value>
31 
                                                                                        </_nullIf>
32 
                                                                                    </value>
33 
                                                                                </_nullIf>
34 
                                                                            </family>
35 
                                                                        </_taxon_family_require_std>
36 
                                                                    </1>
37 
                                                                    <2>
38 
                                                                        <_join_words>
39 
                                                                            <1>$Accepted_name</1>
40 
                                                                            <2>$Accepted_name_author</2>
41 
                                                                        </_join_words>
42 
                                                                    </2>
43 
                                                                </_join_words>
44 
                                                            </taxonomicname>
45 
                                                            <taxonverbatim>
46 
                                                                <author>$Accepted_name_author</author>
47 
                                                                <family>
48 
                                                                    <_nullIf>
49 
                                                                        <null>Unknown</null>
50 
                                                                        <value>$Accepted_name_family</value>
51 
                                                                    </_nullIf>
52 
                                                                </family>
53 
                                                                <taxonname>$Accepted_name</taxonname>
54 
                                                                <verbatimrank>$Accepted_name_rank</verbatimrank>
55 
                                                            </taxonverbatim>
56 
                                                        </taxonlabel>
57 
                                                    </matched_label_id>
58 
                                                    <parent_id>
59 
                                                        <taxonlabel>
60 
                                                            <rank>$Name_matched_rank</rank>
61 
                                                            <taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim>
62 
                                                            <parent_id>
63 
                                                                <taxonlabel>
64 
                                                                    <rank>cultivar</rank>
65 
                                                                    <parent_id>
66 
                                                                        <taxonlabel>
67 
                                                                            <rank>forma</rank>
68 
                                                                            <parent_id>
69 
                                                                                <taxonlabel>
70 
                                                                                    <rank>variety</rank>
71 
                                                                                    <parent_id>
72 
                                                                                        <taxonlabel>
73 
                                                                                            <rank>subspecies</rank>
74 
                                                                                            <parent_id>
75 
                                                                                                <taxonlabel>
76 
                                                                                                    <rank>species</rank>
77 
                                                                                                    <taxonepithet>$Specific_epithet_matched</taxonepithet>
78 
                                                                                                    <parent_id>
79 
                                                                                                        <taxonlabel>
80 
                                                                                                            <rank>genus</rank>
81 
                                                                                                            <taxonepithet>$Genus_matched</taxonepithet>
82 
                                                                                                            <parent_id>
83 
                                                                                                                <taxonlabel>
84 
                                                                                                                    <rank>family</rank>
85 
                                                                                                                    <taxonepithet>$Name_matched_accepted_family</taxonepithet>
86 
                                                                                                                </taxonlabel>
87 
                                                                                                            </parent_id>
88 
                                                                                                        </taxonlabel>
89 
                                                                                                    </parent_id>
90 
                                                                                                </taxonlabel>
91 
                                                                                            </parent_id>
92 
                                                                                        </taxonlabel>
93 
                                                                                    </parent_id>
94 
                                                                                </taxonlabel>
95 
                                                                            </parent_id>
96 
                                                                        </taxonlabel>
97 
                                                                    </parent_id>
98 
                                                                </taxonlabel>
99 
                                                            </parent_id>
100 
                                                            <taxonepithet>$Infraspecific_epithet_matched</taxonepithet>
101 
                                                        </taxonlabel>
102 
                                                    </parent_id>
103 
                                                    <rank>$Name_matched_rank</rank>
104 
                                                    <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>
105 
                                                    <taxonlabel fkey="matched_label_id">
106 
                                                        <matched_label_fit_fraction>
107 
                                                            <_max>
108 
                                                                <1>$Family_score</1>
109 
                                                                <2>$Genus_score</2>
110 
                                                                <3>$Specific_epithet_score</3>
111 
                                                                <4>$Overall_score</4>
112 
                                                            </_max>
113 
                                                        </matched_label_fit_fraction>
114 
                                                        <taxonepithet>$Unmatched_terms</taxonepithet>
115 
                                                        <taxonomicname>$Name_submitted</taxonomicname>
116 
                                                        <taxonverbatim>
117 
                                                            <author>$Author_matched</author>
118 
                                                            <family>$Family_matched</family>
119 
                                                            <genus>$Genus_matched</genus>
120 
                                                            <morphospecies>$Unmatched_terms</morphospecies>
121 
                                                            <specific_epithet>$Specific_epithet_matched</specific_epithet>
122 
                                                            <taxonname>$Name_matched</taxonname>
123 
                                                            <verbatimrank>$Infraspecific_rank</verbatimrank>
124 
                                                        </taxonverbatim>
125 
                                                    </taxonlabel>
126 
                                                    <taxonomicname>
127 
                                                        <_join_words>
128 
                                                            <1>
129 
                                                                <_taxon_family_require_std>
130 
                                                                    <family>
131 
                                                                        <_nullIf>
132 
                                                                            <null>$Name_matched</null>
133 
                                                                            <value>$Name_matched_accepted_family</value>
134 
                                                                        </_nullIf>
135 
                                                                    </family>
136 
                                                                </_taxon_family_require_std>
137 
                                                            </1>
138 
                                                            <2>
139 
                                                                <_join_words>
140 
                                                                    <1>
141 
                                                                        <_alt>
142 
                                                                            <1>$Name_matched</1>
143 
                                                                            <2>
144 
                                                                                <_join_words>
145 
                                                                                    <2>$Genus_matched</2>
146 
                                                                                    <3>$Specific_epithet_matched</3>
147 
                                                                                    <5>
148 
                                                                                        <_join_words>
149 
                                                                                            <1>
150 
                                                                                                <_if name="if has infraspecificEpithet">
151 
                                                                                                    <cond>$Infraspecific_epithet_matched</cond>
152 
                                                                                                    <then>$Name_matched_rank</then>
153 
                                                                                                </_if>
154 
                                                                                            </1>
155 
                                                                                            <2>$Infraspecific_epithet_matched</2>
156 
                                                                                        </_join_words>
157 
                                                                                    </5>
158 
                                                                                </_join_words>
159 
                                                                            </2>
160 
                                                                        </_alt>
161 
                                                                    </1>
162 
                                                                    <2>$Name_matched_author</2>
163 
                                                                </_join_words>
164 
                                                            </2>
165 
                                                        </_join_words>
166 
                                                    </taxonomicname>
167 
                                                    <taxonstatus>$Taxonomic_status</taxonstatus>
168 
                                                </taxonlabel>
169 
                                            </taxonlabel_id>
170 
                                            <author>$Name_matched_author</author>
171 
                                            <family>$Name_matched_accepted_family</family>
172 
                                            <genus>$Genus_matched</genus>
173 
                                            <specific_epithet>$Specific_epithet_matched</specific_epithet>
174 
                                            <taxonname>$Name_matched</taxonname>
175 
                                            <verbatimrank>$Name_matched_rank</verbatimrank>
176 
                                        </taxonverbatim>
177 
                                    </taxonverbatim_id>
178 
                                </taxondetermination>
179 
                                <taxonoccurrence_id>$taxonoccurrence_id</taxonoccurrence_id>
180 
                            </taxonoccurrence>
181 
                        </locationevent>
182 
                    </location>
183 
                </path>
184 
            </_simplifyPath>
185 
        </path>
186 
    </_setDefault>
187 
</VegBIEN>
188 
Inserted 0 new rows into database
inputs/.TNRS/public.unscrubbed_taxondetermination_view/new_terms.csv
1 
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.
2 
Name_submitted,verbatimScientificName,,
3 
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values
4 
Name_matched,verbatimTaxonName,,
5 
Name_matched,taxonName,,
6 
Name_matched_rank,taxonRank,,
7 
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name
8 
Name_matched_url,scientificNameID,,
9 
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string
10 
Family_matched,verbatimFamily,,Contains family in original string (uncommon)
11 
Family_score,matchedFamilyFit_fraction,,
12 
Name_matched_accepted_family,family,,Contains family based on matched name
13 
Genus_matched,verbatimGenus,,
14 
Genus_matched,genus,,
15 
Genus_score,matchedGenusFit_fraction,,
16 
Specific_epithet_matched,verbatimSpecificEpithet,,
17 
Specific_epithet_matched,specificEpithet,,
18 
Specific_epithet_score,matchedSpeciesFit_fraction,,
19 
Infraspecific_rank,verbatimTaxonRank,,
20 
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,
21 
Infraspecific_epithet_matched,infraspecificEpithet,,
22 
Infraspecific_rank_2,UNUSED,,
23 
Infraspecific_epithet_2_matched,UNUSED,,
24 
Infraspecific_epithet_2_score,UNUSED,,
25 
Unmatched_terms,morphospecies,,
26 
Accepted_name,acceptedTaxonName,,
27 
Accepted_name_author,acceptedScientificNameAuthorship,,
28 
Accepted_name_rank,acceptedTaxonRank,,
29 
Accepted_name_family,acceptedFamily,/_nullIf:[null=Unknown]/value,
inputs/.TNRS/public.unscrubbed_taxondetermination_view/unmapped_terms.csv
1 
*Time_submitted
2 
*Name_score
3 
*Author_score
4 
verbatimInfraspecificEpithet
5 
*Infraspecific_epithet_score
6 
*Annotations
7 
*Accepted_name_url
8 
*Accepted_name_species
9 
*Selected
10 
*Source
11 
*Warnings
12 
*Accepted_name_lsid
inputs/.TNRS/import_order.txt
1 1 
Source
2 2 
tnrs_accepted
3 3 
tnrs_other
4 
public.unscrubbed_taxondetermination_view

Also available in: Unified diff