Project

General

Profile

« Previous | Next » 

Revision 7151

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: Use new TNRS.tnrs_canon instead of tnrs+accepted to avoid creating additional taxonlabels for the parsed, matched, and accepted names and instead just use the most-canonicalized name of the names output by TNRS (the accepted name if available, or the matched name otherwise)

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,Accepted_scientific_name,Accepted_name.Time_submitted,Accepted_name.Name_number,Accepted_name.Name_submitted,Accepted_name.Overall_score,Accepted_name.Name_matched,Accepted_name.Name_matched_rank,Accepted_name.Name_score,Accepted_name.Name_matched_author,Accepted_name.Name_matched_url,Accepted_name.Author_matched,Accepted_name.Author_score,Accepted_name.Family_matched,Accepted_name.Family_score,Accepted_name.Name_matched_accepted_family,Accepted_name.Genus_matched,Accepted_name.Genus_score,Accepted_name.Specific_epithet_matched,Accepted_name.Specific_epithet_score,Accepted_name.Infraspecific_rank,Accepted_name.Infraspecific_epithet_matched,Accepted_name.Infraspecific_epithet_score,Accepted_name.Infraspecific_rank_2,Accepted_name.Infraspecific_epithet_2_matched,Accepted_name.Infraspecific_epithet_2_score,Accepted_name.Annotations,Accepted_name.Unmatched_terms,Accepted_name.Taxonomic_status,Accepted_name.Accepted_name,Accepted_name.Accepted_name_author,Accepted_name.Accepted_name_rank,Accepted_name.Accepted_name_url,Accepted_name.Accepted_name_species,Accepted_name.Accepted_name_family,Accepted_name.Selected,Accepted_name.Source,Accepted_name.Warnings,Accepted_name.Accepted_name_lsid,Accepted_name.Accepted_scientific_name
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,Selected,Source,Warnings
inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv
2 2 
taxonoccurrence_id,taxonOccurrencePkey,,
3 3 
Time_submitted,*Time_submitted,,
4 4 
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.
5 
Name_submitted,verbatimScientificName,,
5 
Name_submitted,OMIT,,Omitted because taxonoccurrence_id used to identify the taxonoccurrence instead
6 6 
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values
7 
Name_matched,verbatimTaxonName,,
8 7 
Name_matched,taxonName,,
9 8 
Name_matched_rank,taxonRank,,
10 9 
Name_score,*Name_score,,
11 
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name
10 
Name_matched_author,scientificNameAuthorship,/_first/1,Contains author based on matched name
12 11 
Name_matched_url,scientificNameID,,
13 
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string
12 
Author_matched,scientificNameAuthorship,/_first/2,Contains author in original string
14 13 
Author_score,*Author_score,,
15 
Family_matched,verbatimFamily,,Contains family in original string (uncommon)
14 
Family_matched,family,/_first/2,Contains family in original string (uncommon)
16 15 
Family_score,matchedFamilyFit_fraction,,
17 
Name_matched_accepted_family,family,,Contains family based on matched name
18 
Genus_matched,verbatimGenus,,
16 
Name_matched_accepted_family,family,/_first/1,Contains family based on matched name
19 17 
Genus_matched,genus,,
20 18 
Genus_score,matchedGenusFit_fraction,,
21 
Specific_epithet_matched,verbatimSpecificEpithet,,
22 19 
Specific_epithet_matched,specificEpithet,,
23 20 
Specific_epithet_score,matchedSpeciesFit_fraction,,
24 21 
Infraspecific_rank,verbatimTaxonRank,,
25 
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,
26 22 
Infraspecific_epithet_matched,infraspecificEpithet,,
27 23 
Infraspecific_epithet_score,*Infraspecific_epithet_score,,
28 24 
Infraspecific_rank_2,UNUSED,,
......
31 27 
Annotations,*Annotations,,
32 28 
Unmatched_terms,morphospecies,,
33 29 
Taxonomic_status,taxonomicStatus,,
34 
Accepted_name,acceptedTaxonName,/_first/1,
35 
Accepted_name_author,acceptedScientificNameAuthorship,/_first/1,
36 
Accepted_name_rank,acceptedTaxonRank,/_first/1,
37 
Accepted_name_url,*Accepted_name_url,/_first/1,
38 
Accepted_name_species,*Accepted_name_species,/_first/1,Also contains genus. Omitted because Accepted_name contains more info.
39 
Accepted_name_family,acceptedFamily,/_first/1/_nullIf:[null=Unknown]/value,
40 30 
Selected,*Selected,,
41 31 
Source,*Source,,
42 32 
Warnings,*Warnings,,
43 
Accepted_name_lsid,*Accepted_name_lsid,/_first/2,
44 
Accepted_scientific_name,acceptedScientificName,/_first/1,
45 
Accepted_name.Time_submitted,*Accepted_name.Time_submitted,/_first/2,
46 
Accepted_name.Name_number,OMIT,/_first/2,Identifies name only within one TNRS batch. Omitted because not globally unique.
47 
Accepted_name.Name_submitted,acceptedScientificName,/_first/2,
48 
Accepted_name.Overall_score,OMIT,/_first/2,Scores come from the matched name instead
49 
Accepted_name.Name_matched,acceptedTaxonName,/_first/2,
50 
Accepted_name.Name_matched_rank,acceptedTaxonRank,/_first/2,
51 
Accepted_name.Name_score,OMIT,/_first/2,Scores come from the matched name instead
52 
Accepted_name.Name_matched_author,acceptedScientificNameAuthorship,/_first/2/_first/1,
53 
Accepted_name.Name_matched_url,acceptedScientificNameID,/_first/2,
54 
Accepted_name.Author_matched,acceptedScientificNameAuthorship,/_first/2/_first/2,
55 
Accepted_name.Author_score,OMIT,/_first/2,Scores come from the matched name instead
56 
Accepted_name.Family_matched,acceptedFamily,/_first/2/_first/2,
57 
Accepted_name.Family_score,OMIT,/_first/2,Scores come from the matched name instead
58 
Accepted_name.Name_matched_accepted_family,acceptedFamily,/_first/2/_first/1,
59 
Accepted_name.Genus_matched,acceptedGenus,/_first/2,
60 
Accepted_name.Genus_score,OMIT,/_first/2,Scores come from the matched name instead
61 
Accepted_name.Specific_epithet_matched,acceptedSpecificEpithet,/_first/2,
62 
Accepted_name.Specific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead
63 
Accepted_name.Infraspecific_rank,acceptedTaxonRank,/_first/2,
64 
Accepted_name.Infraspecific_epithet_matched,acceptedInfraspecificEpithet,/_first/2,
65 
Accepted_name.Infraspecific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead
66 
Accepted_name.Infraspecific_rank_2,UNUSED,/_first/2,
67 
Accepted_name.Infraspecific_epithet_2_matched,UNUSED,/_first/2,
68 
Accepted_name.Infraspecific_epithet_2_score,OMIT,/_first/2,Scores come from the matched name instead
69 
Accepted_name.Annotations,*Accepted_name.Annotations,/_first/2,
70 
Accepted_name.Unmatched_terms,OMIT,/_first/2,Should be empty
71 
Accepted_name.Taxonomic_status,acceptedTaxonomicStatus,/_first/2,
72 
Accepted_name.Accepted_name,acceptedTaxonName,/_first/3,
73 
Accepted_name.Accepted_name_author,acceptedScientificNameAuthorship,/_first/3,
74 
Accepted_name.Accepted_name_rank,acceptedTaxonRank,/_first/3,
75 
Accepted_name.Accepted_name_url,*Accepted_name.Accepted_name_url,/_first/3,
76 
Accepted_name.Accepted_name_species,*Accepted_name.Accepted_name_species,/_first/3,
77 
Accepted_name.Accepted_name_family,acceptedFamily,/_first/3,
78 
Accepted_name.Selected,*Accepted_name.Selected,/_first/2,
79 
Accepted_name.Source,*Accepted_name.Source,/_first/2,
80 
Accepted_name.Warnings,*Accepted_name.Warnings,/_first/2,
81 
Accepted_name.Accepted_name_lsid,*Accepted_name.Accepted_name_lsid,/_first/3,
82 
Accepted_name.Accepted_scientific_name,acceptedScientificName,/_first/3,
33 
:true,taxonIsCanonical,,"This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
83 34 
:computer,identificationType,,
84 35 
:_,dateIdentified,/_now,
85 36 
:0,taxonOccurrenceID,,Enables the taxonoccurrence CHECK constraint to pass
inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv
3 3 
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
4 4 
:0,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass
5 5 
:0,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,Enables the taxonoccurrence CHECK constraint to pass
6 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists",
7 
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/_merge_prefix/prefix/_taxon_family_require_std/family",Contains family based on matched name
6 
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
7 
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/_merge_prefix/prefix/_taxon_family_require_std/family/_first/1",Contains family based on matched name
8 
Family_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/_merge_prefix/prefix/_taxon_family_require_std/family/_first/2",Contains family in original string (uncommon)
8 9 
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/_merge_prefix/value/_alt/2/_join_words/1/_alt/1",
9 10 
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/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2",
10 11 
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/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
......
12 13 
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/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
13 14 
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/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
14 15 
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/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
15 
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/_merge_prefix/value/_alt/2/_join_words/2",Contains author based on matched name
16 
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/_merge_prefix/value/_alt/2/_join_words/2/_first/1",Contains author based on matched name
17 
Author_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/_merge_prefix/value/_alt/2/_join_words/2/_first/2",Contains author in original string
16 18 
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value/_now,
17 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank/_first/1",
18 
Accepted_name.Infraspecific_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank/_first/2",
19 
Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank/_first/2",
20 
Accepted_name.Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank/_first/3",
21 
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/1/_nullIf:[null=Unknown]/value",
22 
Accepted_name.Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/2/_first/1",
23 
Accepted_name.Family_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/2/_first/2",
24 
Accepted_name.Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/3",
25 
Accepted_scientific_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1/_first/1",
26 
Accepted_name.Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1/_first/2",
27 
Accepted_name.Accepted_scientific_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1/_first/3",
28 
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1/_first/1",
29 
Accepted_name.Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1/_first/2",
30 
Accepted_name.Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1/_first/3",
31 
Accepted_name.Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_first/2",
32 
Accepted_name.Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_first/2",
33 
Accepted_name.Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond/_first/2",
34 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/1",
35 
Accepted_name.Infraspecific_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/2",
36 
Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/2",
37 
Accepted_name.Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/3",
38 
Accepted_name.Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2/_first/2",
39 
Accepted_name_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/1",
40 
Accepted_name.Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/2/_first/1",
41 
Accepted_name.Author_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/2/_first/2",
42 
Accepted_name.Accepted_name_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/3",
43 
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/_first/1",
44 
Accepted_name.Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/author/_first/2/_first/1",
45 
Accepted_name.Author_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/author/_first/2/_first/2",
46 
Accepted_name.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/_first/3",
47 
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/_first/1/_nullIf:[null=Unknown]/value",
48 
Accepted_name.Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/family/_first/2/_first/1",
49 
Accepted_name.Family_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/family/_first/2/_first/2",
50 
Accepted_name.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/_first/3",
51 
Accepted_name.Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/genus/_first/2",
52 
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/cond/_exists/_first/1",
53 
Accepted_scientific_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/cond/_exists/_first/1",
54 
Accepted_name.Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/cond/_exists/_first/2",
55 
Accepted_name.Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/cond/_exists/_first/2",
56 
Accepted_name.Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/cond/_exists/_first/3",
57 
Accepted_name.Accepted_scientific_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/cond/_exists/_first/3",
58 19 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has accepted name""]/then",
59 
Accepted_name.Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/specific_epithet/_first/2",
60 
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonname/_first/1",
61 
Accepted_name.Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonname/_first/2",
62 
Accepted_name.Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonname/_first/3",
63 
Accepted_scientific_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonomicname/_first/1",
64 
Accepted_name.Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonomicname/_first/2",
65 
Accepted_name.Accepted_scientific_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonomicname/_first/3",
66 
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/_first/1",
67 
Accepted_name.Infraspecific_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/verbatimrank/_first/2",
68 
Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/verbatimrank/_first/2",
69 
Accepted_name.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/_first/3",
20 
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]:[then=0]/cond","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
70 21 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
71 22 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
72 23 
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
24 
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
73 25 
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",
74 26 
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
75 
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
76 
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
27 
:true,"/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""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
28 
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/_first/1",Contains family based on matched name
29 
Family_matched,"/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/_first/2",Contains family in original string (uncommon)
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/_first/1",Contains family based on matched name
31 
Family_matched,"/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/_first/2",Contains family in original string (uncommon)
77 32 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
78 33 
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
79 34 
Name_matched_url,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode,
......
84 39 
Specific_epithet_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/else/_max/3",
85 40 
Overall_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/else/_max/4",Assuming is a fraction based on the range of values
86 41 
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonepithet,
87 
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonomicname,
88 
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/author,Contains author in original string
89 
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/family,Contains family in original string (uncommon)
90 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/genus,
91 
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",
92 42 
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",
93 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/specific_epithet,
94 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/taxonname,
95 43 
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/verbatimrank,
96 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,Contains family based on matched name
44 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/1,Contains family based on matched name
45 
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_first/2,Contains family in original string (uncommon)
97 46 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
98 47 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2,
99 48 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
100 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists",
49 
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
101 50 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2/_if[@name=""if has verbatim name""]/else",
102 51 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
103 52 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
104 53 
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
105 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2,Contains author based on matched name
54 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/1,Contains author based on matched name
55 
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_first/2,Contains author in original string
106 56 
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonstatus,
107 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,Contains author based on matched name
108 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,Contains family based on matched name
57 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author/_first/1,Contains author based on matched name
58 
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author/_first/2,Contains author in original string
59 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_first/1,Contains family based on matched name
60 
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family/_first/2,Contains family in original string (uncommon)
109 61 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
110 
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists",
62 
:true,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists","This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
111 63 
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else",
112 64 
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
113 65 
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
......
120 72 
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value/_now,
121 73 
:computer,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype,
122 74 
taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id,
123 
Accepted_name.Accepted_name_lsid,,** No join mapping for *Accepted_name.Accepted_name_lsid/_first/3 **
124 
Accepted_name.Accepted_name_species,,** No join mapping for *Accepted_name.Accepted_name_species/_first/3 **
125 
Accepted_name.Accepted_name_url,,** No join mapping for *Accepted_name.Accepted_name_url/_first/3 **
126 
Accepted_name.Annotations,,** No join mapping for *Accepted_name.Annotations/_first/2 **
127 
Accepted_name.Author_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
128 
Accepted_name.Family_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
129 
Accepted_name.Genus_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
130 
Accepted_name.Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED/_first/2 **
131 
Accepted_name.Infraspecific_epithet_2_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
132 
Accepted_name.Infraspecific_epithet_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
133 
Accepted_name.Infraspecific_rank_2,,** No non-empty join mapping for UNUSED/_first/2 **
134 
Accepted_name.Name_matched_url,,** No join mapping for acceptedScientificNameID/_first/2 **
135 
Accepted_name.Name_number,,** No non-empty join mapping for OMIT/_first/2 ** Identifies name only within one TNRS batch. Omitted because not globally unique.
136 
Accepted_name.Name_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
137 
Accepted_name.Overall_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
138 
Accepted_name.Selected,,** No join mapping for *Accepted_name.Selected/_first/2 **
139 
Accepted_name.Source,,** No join mapping for *Accepted_name.Source/_first/2 **
140 
Accepted_name.Specific_epithet_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
141 
Accepted_name.Taxonomic_status,,** No join mapping for acceptedTaxonomicStatus/_first/2 **
142 
Accepted_name.Time_submitted,,** No join mapping for *Accepted_name.Time_submitted/_first/2 **
143 
Accepted_name.Unmatched_terms,,** No non-empty join mapping for OMIT/_first/2 ** Should be empty
144 
Accepted_name.Warnings,,** No join mapping for *Accepted_name.Warnings/_first/2 **
145 
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid/_first/2 **
146 
Accepted_name_species,,** No join mapping for *Accepted_name_species/_first/1 ** Also contains genus. Omitted because Accepted_name contains more info.
147 
Accepted_name_url,,** No join mapping for *Accepted_name_url/_first/1 **
148 75 
Annotations,,** No join mapping for *Annotations **
149 76 
Author_score,,** No join mapping for *Author_score **
150 77 
Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED **
151 78 
Infraspecific_epithet_2_score,,** No non-empty join mapping for UNUSED **
152 
Infraspecific_epithet_matched,,** No join mapping for verbatimInfraspecificEpithet **
153 79 
Infraspecific_epithet_score,,** No join mapping for *Infraspecific_epithet_score **
154 80 
Infraspecific_rank_2,,** No non-empty join mapping for UNUSED **
155 81 
Name_number,,** No non-empty join mapping for OMIT ** Identifies name only within one TNRS batch. Omitted because not globally unique.
156 82 
Name_score,,** No join mapping for *Name_score **
83 
Name_submitted,,** No non-empty join mapping for OMIT ** Omitted because taxonoccurrence_id used to identify the taxonoccurrence instead
157 84 
Selected,,** No join mapping for *Selected **
158 85 
Source,,** No join mapping for *Source **
159 86 
Time_submitted,,** No join mapping for *Time_submitted **
inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref
16 16 
                                            <taxonlabel_id>
17 17 
                                                <taxonlabel>
18 18 
                                                    <creationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></creationdate>
19 
                                                    <matched_label_id>
20 
                                                        <taxonlabel>
21 
                                                            <rank>$Accepted_name_rank</rank>
22 
                                                            <taxonomicname>
23 
                                                                <_merge_prefix>
24 
                                                                    <prefix>
25 
                                                                        <_taxon_family_require_std>
26 
                                                                            <family>
27 
                                                                                <_nullIf>
28 
                                                                                    <null>Unknown</null>
29 
                                                                                    <value>$Accepted_name_family</value>
30 
                                                                                </_nullIf>
31 
                                                                            </family>
32 
                                                                        </_taxon_family_require_std>
33 
                                                                    </prefix>
34 
                                                                    <value>
35 
                                                                        <_alt>
36 
                                                                            <1>$Accepted_scientific_name</1>
37 
                                                                            <2>
38 
                                                                                <_join_words>
39 
                                                                                    <1>
40 
                                                                                        <_alt>
41 
                                                                                            <1>$Accepted_name</1>
42 
                                                                                            <2>
43 
                                                                                                <_join_words>
44 
                                                                                                    <2>$Accepted_name.Genus_matched</2>
45 
                                                                                                    <3>$Accepted_name.Specific_epithet_matched</3>
46 
                                                                                                    <5>
47 
                                                                                                        <_join_words>
48 
                                                                                                            <1>
49 
                                                                                                                <_if name="if has infraspecificEpithet">
50 
                                                                                                                    <cond>$Accepted_name.Infraspecific_epithet_matched</cond>
51 
                                                                                                                    <then>$Accepted_name_rank</then>
52 
                                                                                                                </_if>
53 
                                                                                                            </1>
54 
                                                                                                            <2>$Accepted_name.Infraspecific_epithet_matched</2>
55 
                                                                                                        </_join_words>
56 
                                                                                                    </5>
57 
                                                                                                </_join_words>
58 
                                                                                            </2>
59 
                                                                                        </_alt>
60 
                                                                                    </1>
61 
                                                                                    <2>$Accepted_name_author</2>
62 
                                                                                </_join_words>
63 
                                                                            </2>
64 
                                                                        </_alt>
65 
                                                                    </value>
66 
                                                                </_merge_prefix>
67 
                                                            </taxonomicname>
68 
                                                            <taxonverbatim>
69 
                                                                <author>$Accepted_name_author</author>
70 
                                                                <family>
71 
                                                                    <_nullIf>
72 
                                                                        <null>Unknown</null>
73 
                                                                        <value>$Accepted_name_family</value>
74 
                                                                    </_nullIf>
75 
                                                                </family>
76 
                                                                <genus>$Accepted_name.Genus_matched</genus>
77 
                                                                <morphospecies>$Unmatched_terms</morphospecies>
78 
                                                                <specific_epithet>$Accepted_name.Specific_epithet_matched</specific_epithet>
79 
                                                                <taxonname>$Accepted_name</taxonname>
80 
                                                                <taxonomicname>$Accepted_scientific_name</taxonomicname>
81 
                                                                <verbatimrank>$Accepted_name_rank</verbatimrank>
82 
                                                            </taxonverbatim>
83 
                                                        </taxonlabel>
84 
                                                    </matched_label_id>
19 
                                                    <matched_label_id>0</matched_label_id>
85 20 
                                                    <parent_id>
86 21 
                                                        <taxonlabel>
87 22 
                                                            <rank>$Name_matched_rank</rank>
......
105 40 
                                                                                                    <parent_id>
106 41 
                                                                                                        <taxonlabel>
107 42 
                                                                                                            <rank>genus</rank>
43 
                                                                                                            <matched_label_id>
44 
                                                                                                                <taxonlabel>
45 
                                                                                                                    <source_id><source><shortname>NCBI</shortname></source></source_id>
46 
                                                                                                                    <taxonomicname>$Genus_matched</taxonomicname>
47 
                                                                                                                </taxonlabel>
48 
                                                                                                            </matched_label_id>
108 49 
                                                                                                            <taxonepithet>$Genus_matched</taxonepithet>
109 50 
                                                                                                            <parent_id>
110 51 
                                                                                                                <taxonlabel>
111 52 
                                                                                                                    <rank>family</rank>
53 
                                                                                                                    <matched_label_id>
54 
                                                                                                                        <taxonlabel>
55 
                                                                                                                            <source_id><source><shortname>NCBI</shortname></source></source_id>
56 
                                                                                                                            <taxonomicname>$Name_matched_accepted_family</taxonomicname>
57 
                                                                                                                        </taxonlabel>
58 
                                                                                                                    </matched_label_id>
112 59 
                                                                                                                    <taxonepithet>$Name_matched_accepted_family</taxonepithet>
113 60 
                                                                                                                </taxonlabel>
114 61 
                                                                                                            </parent_id>
......
131 78 
                                                    <sourceaccessioncode>$Name_matched_url</sourceaccessioncode>
132 79 
                                                    <taxonlabel fkey="matched_label_id">
133 80 
                                                        <taxonepithet>$Unmatched_terms</taxonepithet>
134 
                                                        <taxonomicname>$Name_submitted</taxonomicname>
135 
                                                        <taxonverbatim>
136 
                                                            <author>$Author_matched</author>
137 
                                                            <family>$Family_matched</family>
138 
                                                            <genus>$Genus_matched</genus>
139 
                                                            <morphospecies>$Unmatched_terms</morphospecies>
140 
                                                            <specific_epithet>$Specific_epithet_matched</specific_epithet>
141 
                                                            <taxonname>$Name_matched</taxonname>
142 
                                                            <verbatimrank>$Infraspecific_rank</verbatimrank>
143 
                                                        </taxonverbatim>
81 
                                                        <taxonverbatim><verbatimrank>$Infraspecific_rank</verbatimrank></taxonverbatim>
144 82 
                                                    </taxonlabel>
145 83 
                                                    <taxonomicname>
146 84 
                                                        <_merge_prefix>
inputs/.TNRS/public.unscrubbed_taxondetermination_view/new_terms.csv
1 1 
Name_number,OMIT,,Identifies name only within one TNRS batch. Omitted because not globally unique.
2 
Name_submitted,verbatimScientificName,,
2 
Name_submitted,OMIT,,Omitted because taxonoccurrence_id used to identify the taxonoccurrence instead
3 3 
Overall_score,matchedTaxonFit_fraction,,Assuming is a fraction based on the range of values
4 
Name_matched,verbatimTaxonName,,
5 4 
Name_matched,taxonName,,
6 5 
Name_matched_rank,taxonRank,,
7 
Name_matched_author,scientificNameAuthorship,,Contains author based on matched name
6 
Name_matched_author,scientificNameAuthorship,/_first/1,Contains author based on matched name
8 7 
Name_matched_url,scientificNameID,,
9 
Author_matched,verbatimScientificNameAuthorship,,Contains author in original string
10 
Family_matched,verbatimFamily,,Contains family in original string (uncommon)
8 
Author_matched,scientificNameAuthorship,/_first/2,Contains author in original string
9 
Family_matched,family,/_first/2,Contains family in original string (uncommon)
11 10 
Family_score,matchedFamilyFit_fraction,,
12 
Name_matched_accepted_family,family,,Contains family based on matched name
13 
Genus_matched,verbatimGenus,,
11 
Name_matched_accepted_family,family,/_first/1,Contains family based on matched name
14 12 
Genus_matched,genus,,
15 13 
Genus_score,matchedGenusFit_fraction,,
16 
Specific_epithet_matched,verbatimSpecificEpithet,,
17 14 
Specific_epithet_matched,specificEpithet,,
18 15 
Specific_epithet_score,matchedSpeciesFit_fraction,,
19 16 
Infraspecific_rank,verbatimTaxonRank,,
20 
Infraspecific_epithet_matched,verbatimInfraspecificEpithet,,
21 17 
Infraspecific_epithet_matched,infraspecificEpithet,,
22 18 
Infraspecific_rank_2,UNUSED,,
23 19 
Infraspecific_epithet_2_matched,UNUSED,,
24 20 
Infraspecific_epithet_2_score,UNUSED,,
25 21 
Unmatched_terms,morphospecies,,
26 
Accepted_name,acceptedTaxonName,/_first/1,
27 
Accepted_name_author,acceptedScientificNameAuthorship,/_first/1,
28 
Accepted_name_rank,acceptedTaxonRank,/_first/1,
29 
Accepted_name_family,acceptedFamily,/_first/1/_nullIf:[null=Unknown]/value,
30 
Accepted_name.Name_number,OMIT,/_first/2,Identifies name only within one TNRS batch. Omitted because not globally unique.
31 
Accepted_name.Name_submitted,acceptedScientificName,/_first/2,
32 
Accepted_name.Overall_score,OMIT,/_first/2,Scores come from the matched name instead
33 
Accepted_name.Name_matched,acceptedTaxonName,/_first/2,
34 
Accepted_name.Name_matched_rank,acceptedTaxonRank,/_first/2,
35 
Accepted_name.Name_score,OMIT,/_first/2,Scores come from the matched name instead
36 
Accepted_name.Name_matched_author,acceptedScientificNameAuthorship,/_first/2/_first/1,
37 
Accepted_name.Name_matched_url,acceptedScientificNameID,/_first/2,
38 
Accepted_name.Author_matched,acceptedScientificNameAuthorship,/_first/2/_first/2,
39 
Accepted_name.Author_score,OMIT,/_first/2,Scores come from the matched name instead
40 
Accepted_name.Family_matched,acceptedFamily,/_first/2/_first/2,
41 
Accepted_name.Family_score,OMIT,/_first/2,Scores come from the matched name instead
42 
Accepted_name.Name_matched_accepted_family,acceptedFamily,/_first/2/_first/1,
43 
Accepted_name.Genus_matched,acceptedGenus,/_first/2,
44 
Accepted_name.Genus_score,OMIT,/_first/2,Scores come from the matched name instead
45 
Accepted_name.Specific_epithet_matched,acceptedSpecificEpithet,/_first/2,
46 
Accepted_name.Specific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead
47 
Accepted_name.Infraspecific_rank,acceptedTaxonRank,/_first/2,
48 
Accepted_name.Infraspecific_epithet_matched,acceptedInfraspecificEpithet,/_first/2,
49 
Accepted_name.Infraspecific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead
50 
Accepted_name.Infraspecific_rank_2,UNUSED,/_first/2,
51 
Accepted_name.Infraspecific_epithet_2_matched,UNUSED,/_first/2,
52 
Accepted_name.Infraspecific_epithet_2_score,OMIT,/_first/2,Scores come from the matched name instead
53 
Accepted_name.Unmatched_terms,OMIT,/_first/2,Should be empty
54 
Accepted_name.Taxonomic_status,acceptedTaxonomicStatus,/_first/2,
55 
Accepted_name.Accepted_name,acceptedTaxonName,/_first/3,
56 
Accepted_name.Accepted_name_author,acceptedScientificNameAuthorship,/_first/3,
57 
Accepted_name.Accepted_name_rank,acceptedTaxonRank,/_first/3,
58 
Accepted_name.Accepted_name_family,acceptedFamily,/_first/3,
59 
Accepted_name.Accepted_scientific_name,acceptedScientificName,/_first/3,
inputs/.TNRS/public.unscrubbed_taxondetermination_view/unmapped_terms.csv
1 1 
*Time_submitted
2 2 
*Name_score
3 3 
*Author_score
4 
verbatimInfraspecificEpithet
5 4 
*Infraspecific_epithet_score
6 5 
*Annotations
7 
*Accepted_name_url
8 
*Accepted_name_species
9 6 
*Selected
10 7 
*Source
11 8 
*Warnings
12 
*Accepted_name_lsid
13 
*Accepted_name.Time_submitted
14 
acceptedScientificNameID
15 
*Accepted_name.Annotations
16 
acceptedTaxonomicStatus
17 
*Accepted_name.Accepted_name_url
18 
*Accepted_name.Accepted_name_species
19 
*Accepted_name.Selected
20 
*Accepted_name.Source
21 
*Accepted_name.Warnings
22 
*Accepted_name.Accepted_name_lsid
schemas/vegbien.sql
4517 4517 
--
4518 4518 

  		




  4519
  4519
  
    
CREATE VIEW unscrubbed_taxondetermination_view AS


  		




  4520
  
  
    
    SELECT taxondetermination.taxonoccurrence_id, "tnrs+accepted"."Time_submitted", "tnrs+accepted"."Name_number", "tnrs+accepted"."Name_submitted", "tnrs+accepted"."Overall_score", "tnrs+accepted"."Name_matched", "tnrs+accepted"."Name_matched_rank", "tnrs+accepted"."Name_score", "tnrs+accepted"."Name_matched_author", "tnrs+accepted"."Name_matched_url", "tnrs+accepted"."Author_matched", "tnrs+accepted"."Author_score", "tnrs+accepted"."Family_matched", "tnrs+accepted"."Family_score", "tnrs+accepted"."Name_matched_accepted_family", "tnrs+accepted"."Genus_matched", "tnrs+accepted"."Genus_score", "tnrs+accepted"."Specific_epithet_matched", "tnrs+accepted"."Specific_epithet_score", "tnrs+accepted"."Infraspecific_rank", "tnrs+accepted"."Infraspecific_epithet_matched", "tnrs+accepted"."Infraspecific_epithet_score", "tnrs+accepted"."Infraspecific_rank_2", "tnrs+accepted"."Infraspecific_epithet_2_matched", "tnrs+accepted"."Infraspecific_epithet_2_score", "tnrs+accepted"."Annotations", "tnrs+accepted"."Unmatched_terms", "tnrs+accepted"."Taxonomic_status", "tnrs+accepted"."Accepted_name", "tnrs+accepted"."Accepted_name_author", "tnrs+accepted"."Accepted_name_rank", "tnrs+accepted"."Accepted_name_url", "tnrs+accepted"."Accepted_name_species", "tnrs+accepted"."Accepted_name_family", "tnrs+accepted"."Selected", "tnrs+accepted"."Source", "tnrs+accepted"."Warnings", "tnrs+accepted"."Accepted_name_lsid", "tnrs+accepted"."Accepted_scientific_name", "tnrs+accepted"."Accepted_name.Time_submitted", "tnrs+accepted"."Accepted_name.Name_number", "tnrs+accepted"."Accepted_name.Name_submitted", "tnrs+accepted"."Accepted_name.Overall_score", "tnrs+accepted"."Accepted_name.Name_matched", "tnrs+accepted"."Accepted_name.Name_matched_rank", "tnrs+accepted"."Accepted_name.Name_score", "tnrs+accepted"."Accepted_name.Name_matched_author", "tnrs+accepted"."Accepted_name.Name_matched_url", "tnrs+accepted"."Accepted_name.Author_matched", "tnrs+accepted"."Accepted_name.Author_score", "tnrs+accepted"."Accepted_name.Family_matched", "tnrs+accepted"."Accepted_name.Family_score", "tnrs+accepted"."Accepted_name.Name_matched_accepted_family", "tnrs+accepted"."Accepted_name.Genus_matched", "tnrs+accepted"."Accepted_name.Genus_score", "tnrs+accepted"."Accepted_name.Specific_epithet_matched", "tnrs+accepted"."Accepted_name.Specific_epithet_score", "tnrs+accepted"."Accepted_name.Infraspecific_rank", "tnrs+accepted"."Accepted_name.Infraspecific_epithet_matched", "tnrs+accepted"."Accepted_name.Infraspecific_epithet_score", "tnrs+accepted"."Accepted_name.Infraspecific_rank_2", "tnrs+accepted"."Accepted_name.Infraspecific_epithet_2_matched", "tnrs+accepted"."Accepted_name.Infraspecific_epithet_2_score", "tnrs+accepted"."Accepted_name.Annotations", "tnrs+accepted"."Accepted_name.Unmatched_terms", "tnrs+accepted"."Accepted_name.Taxonomic_status", "tnrs+accepted"."Accepted_name.Accepted_name", "tnrs+accepted"."Accepted_name.Accepted_name_author", "tnrs+accepted"."Accepted_name.Accepted_name_rank", "tnrs+accepted"."Accepted_name.Accepted_name_url", "tnrs+accepted"."Accepted_name.Accepted_name_species", "tnrs+accepted"."Accepted_name.Accepted_name_family", "tnrs+accepted"."Accepted_name.Selected", "tnrs+accepted"."Accepted_name.Source", "tnrs+accepted"."Accepted_name.Warnings", "tnrs+accepted"."Accepted_name.Accepted_name_lsid", "tnrs+accepted"."Accepted_name.Accepted_scientific_name" FROM (((taxondetermination JOIN taxonverbatim USING (taxonverbatim_id)) JOIN taxonlabel USING (taxonlabel_id)) JOIN "TNRS"."tnrs+accepted" ON (("tnrs+accepted"."Name_submitted" = taxonlabel.taxonomicname))) WHERE (taxondetermination.iscurrent AND (taxondetermination.source_id <> (SELECT source.source_id FROM source WHERE (source.shortname = 'TNRS'::text)))) ORDER BY taxondetermination.taxonoccurrence_id;


  		




  
  4520
  
    
    SELECT taxondetermination.taxonoccurrence_id, tnrs_canon."Time_submitted", tnrs_canon."Name_number", tnrs_canon."Name_submitted", tnrs_canon."Overall_score", tnrs_canon."Name_matched", tnrs_canon."Name_matched_rank", tnrs_canon."Name_score", tnrs_canon."Name_matched_author", tnrs_canon."Name_matched_url", tnrs_canon."Author_matched", tnrs_canon."Author_score", tnrs_canon."Family_matched", tnrs_canon."Family_score", tnrs_canon."Name_matched_accepted_family", tnrs_canon."Genus_matched", tnrs_canon."Genus_score", tnrs_canon."Specific_epithet_matched", tnrs_canon."Specific_epithet_score", tnrs_canon."Infraspecific_rank", tnrs_canon."Infraspecific_epithet_matched", tnrs_canon."Infraspecific_epithet_score", tnrs_canon."Infraspecific_rank_2", tnrs_canon."Infraspecific_epithet_2_matched", tnrs_canon."Infraspecific_epithet_2_score", tnrs_canon."Annotations", tnrs_canon."Unmatched_terms", tnrs_canon."Taxonomic_status", tnrs_canon."Selected", tnrs_canon."Source", tnrs_canon."Warnings" FROM (((taxondetermination JOIN taxonverbatim USING (taxonverbatim_id)) JOIN taxonlabel USING (taxonlabel_id)) JOIN "TNRS".tnrs_canon ON ((tnrs_canon."Name_submitted" = taxonlabel.taxonomicname))) WHERE (taxondetermination.iscurrent AND (taxondetermination.source_id <> (SELECT source.source_id FROM source WHERE (source.shortname = 'TNRS'::text)))) ORDER BY taxondetermination.taxonoccurrence_id;


  		




  4521
  4521
  
    

  		




  4522
  4522
  
    

  		




  4523
  4523
  
    
--


  		












Also available in:  Unified diff