Project

General

Profile

« Previous | Next » 

Revision 7129

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv: Mapped Accepted_name.*

View differences:

inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv
31 31 
Annotations,*Annotations,,
32 32 
Unmatched_terms,morphospecies,,
33 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,
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 40 
Selected,*Selected,,
41 41 
Source,*Source,,
42 42 
Warnings,*Warnings,,
43 
Accepted_name_lsid,*Accepted_name_lsid,,
44 
Accepted_name.Time_submitted,*Accepted_name.Time_submitted,,
45 
Accepted_name.Name_number,*Accepted_name.Name_number,,
46 
Accepted_name.Name_submitted,*Accepted_name.Name_submitted,,
47 
Accepted_name.Overall_score,*Accepted_name.Overall_score,,
48 
Accepted_name.Name_matched,*Accepted_name.Name_matched,,
49 
Accepted_name.Name_matched_rank,*Accepted_name.Name_matched_rank,,
50 
Accepted_name.Name_score,*Accepted_name.Name_score,,
51 
Accepted_name.Name_matched_author,*Accepted_name.Name_matched_author,,
52 
Accepted_name.Name_matched_url,*Accepted_name.Name_matched_url,,
53 
Accepted_name.Author_matched,*Accepted_name.Author_matched,,
54 
Accepted_name.Author_score,*Accepted_name.Author_score,,
55 
Accepted_name.Family_matched,*Accepted_name.Family_matched,,
56 
Accepted_name.Family_score,*Accepted_name.Family_score,,
57 
Accepted_name.Name_matched_accepted_family,*Accepted_name.Name_matched_accepted_family,,
58 
Accepted_name.Genus_matched,*Accepted_name.Genus_matched,,
59 
Accepted_name.Genus_score,*Accepted_name.Genus_score,,
60 
Accepted_name.Specific_epithet_matched,*Accepted_name.Specific_epithet_matched,,
61 
Accepted_name.Specific_epithet_score,*Accepted_name.Specific_epithet_score,,
62 
Accepted_name.Infraspecific_rank,*Accepted_name.Infraspecific_rank,,
63 
Accepted_name.Infraspecific_epithet_matched,*Accepted_name.Infraspecific_epithet_matched,,
64 
Accepted_name.Infraspecific_epithet_score,*Accepted_name.Infraspecific_epithet_score,,
65 
Accepted_name.Infraspecific_rank_2,*Accepted_name.Infraspecific_rank_2,,
66 
Accepted_name.Infraspecific_epithet_2_matched,*Accepted_name.Infraspecific_epithet_2_matched,,
67 
Accepted_name.Infraspecific_epithet_2_score,*Accepted_name.Infraspecific_epithet_2_score,,
68 
Accepted_name.Annotations,*Accepted_name.Annotations,,
69 
Accepted_name.Unmatched_terms,*Accepted_name.Unmatched_terms,,
70 
Accepted_name.Taxonomic_status,*Accepted_name.Taxonomic_status,,
71 
Accepted_name.Accepted_name,*Accepted_name.Accepted_name,,
72 
Accepted_name.Accepted_name_author,*Accepted_name.Accepted_name_author,,
73 
Accepted_name.Accepted_name_rank,*Accepted_name.Accepted_name_rank,,
74 
Accepted_name.Accepted_name_url,*Accepted_name.Accepted_name_url,,
75 
Accepted_name.Accepted_name_species,*Accepted_name.Accepted_name_species,,
76 
Accepted_name.Accepted_name_family,*Accepted_name.Accepted_name_family,,
77 
Accepted_name.Selected,*Accepted_name.Selected,,
78 
Accepted_name.Source,*Accepted_name.Source,,
79 
Accepted_name.Warnings,*Accepted_name.Warnings,,
80 
Accepted_name.Accepted_name_lsid,*Accepted_name.Accepted_name_lsid,,
43 
Accepted_name_lsid,*Accepted_name_lsid,/_first/2,
44 
Accepted_name.Time_submitted,*Accepted_name.Time_submitted,/_first/2,
45 
Accepted_name.Name_number,OMIT,/_first/2,Identifies name only within one TNRS batch. Omitted because not globally unique.
46 
Accepted_name.Name_submitted,acceptedScientificName,/_first/2,
47 
Accepted_name.Overall_score,OMIT,/_first/2,Scores come from the matched name instead
48 
Accepted_name.Name_matched,acceptedTaxonName,/_first/2,
49 
Accepted_name.Name_matched_rank,acceptedTaxonRank,/_first/2,
50 
Accepted_name.Name_score,OMIT,/_first/2,Scores come from the matched name instead
51 
Accepted_name.Name_matched_author,acceptedScientificNameAuthorship,/_first/2/_first/1,
52 
Accepted_name.Name_matched_url,acceptedScientificNameID,/_first/2,
53 
Accepted_name.Author_matched,acceptedScientificNameAuthorship,/_first/2/_first/2,
54 
Accepted_name.Author_score,OMIT,/_first/2,Scores come from the matched name instead
55 
Accepted_name.Family_matched,acceptedFamily,/_first/2/_first/2,
56 
Accepted_name.Family_score,OMIT,/_first/2,Scores come from the matched name instead
57 
Accepted_name.Name_matched_accepted_family,acceptedFamily,/_first/2/_first/1,
58 
Accepted_name.Genus_matched,acceptedGenus,/_first/2,
59 
Accepted_name.Genus_score,OMIT,/_first/2,Scores come from the matched name instead
60 
Accepted_name.Specific_epithet_matched,acceptedSpecificEpithet,/_first/2,
61 
Accepted_name.Specific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead
62 
Accepted_name.Infraspecific_rank,acceptedTaxonRank,/_first/2,
63 
Accepted_name.Infraspecific_epithet_matched,acceptedInfraspecificEpithet,/_first/2,
64 
Accepted_name.Infraspecific_epithet_score,OMIT,/_first/2,Scores come from the matched name instead
65 
Accepted_name.Infraspecific_rank_2,UNUSED,/_first/2,
66 
Accepted_name.Infraspecific_epithet_2_matched,UNUSED,/_first/2,
67 
Accepted_name.Infraspecific_epithet_2_score,OMIT,/_first/2,Scores come from the matched name instead
68 
Accepted_name.Annotations,*Accepted_name.Annotations,/_first/2,
69 
Accepted_name.Unmatched_terms,OMIT,/_first/2,Should be empty
70 
Accepted_name.Taxonomic_status,acceptedTaxonomicStatus,/_first/2,
71 
Accepted_name.Accepted_name,acceptedTaxonName,/_first/3,
72 
Accepted_name.Accepted_name_author,acceptedScientificNameAuthorship,/_first/3,
73 
Accepted_name.Accepted_name_rank,acceptedTaxonRank,/_first/3,
74 
Accepted_name.Accepted_name_url,*Accepted_name.Accepted_name_url,/_first/3,
75 
Accepted_name.Accepted_name_species,*Accepted_name.Accepted_name_species,/_first/3,
76 
Accepted_name.Accepted_name_family,acceptedFamily,/_first/3,
77 
Accepted_name.Selected,*Accepted_name.Selected,/_first/2,
78 
Accepted_name.Source,*Accepted_name.Source,/_first/2,
79 
Accepted_name.Warnings,*Accepted_name.Warnings,/_first/2,
80 
Accepted_name.Accepted_name_lsid,*Accepted_name.Accepted_name_lsid,/_first/3,
81 81 
:computer,identificationType,,
82 82 
:_,dateIdentified,/_now,
83 83 
:0,taxonOccurrenceID,,Enables the taxonoccurrence CHECK constraint to pass
inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv
15 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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
16 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/_join_words/2/_alt/2/_join_words/2",Contains author based on matched name
17 17 
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value/_now,
18 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/rank",
19 
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",
20 
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",
21 
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",
22 
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",
23 
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",
24 
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",
25 
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",
26 
Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/matched_label_id/_if[@name=""if is canonical name""]/else/taxonlabel/taxonverbatim/taxonname",
27 
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",
18 
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",
19 
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",
20 
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",
21 
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",
22 
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/_first/1",
23 
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/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1/_first/2",
24 
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/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1/_first/3",
25 
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/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/2/_first/2",
26 
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/_first/1/_nullIf:[null=Unknown]/value",
27 
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/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_first/2/_first/1",
28 
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/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_first/2/_first/2",
29 
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/_join_words/1/_taxon_family_require_std/family/_nullIf/value/_first/3",
30 
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/_join_words/2/_alt/1/_first/2",
31 
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/_first/1",
32 
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/_join_words/2/_alt/2/_join_words/1/_alt/1/_first/2",
33 
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/_join_words/2/_alt/2/_join_words/1/_alt/1/_first/3",
34 
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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2/_first/2",
35 
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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_first/2",
36 
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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond/_first/2",
37 
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/_first/1",
38 
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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/2",
39 
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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/2",
40 
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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_first/3",
41 
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/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2/_first/2",
42 
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/_first/1",
43 
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/_join_words/2/_alt/2/_join_words/2/_first/2/_first/1",
44 
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/_join_words/2/_alt/2/_join_words/2/_first/2/_first/2",
45 
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/_join_words/2/_alt/2/_join_words/2/_first/3",
46 
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",
47 
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",
48 
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",
49 
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",
50 
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",
51 
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",
52 
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",
53 
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",
54 
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",
55 
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",
56 
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",
57 
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",
58 
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",
59 
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",
60 
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",
61 
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",
62 
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",
63 
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",
28 64 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
29 65 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
30 66 
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",
......
73 109 
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value/_now,
74 110 
:computer,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype,
75 111 
taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id,
76 
Accepted_name.Accepted_name,,** No join mapping for *Accepted_name.Accepted_name **
77 
Accepted_name.Accepted_name_author,,** No join mapping for *Accepted_name.Accepted_name_author **
78 
Accepted_name.Accepted_name_family,,** No join mapping for *Accepted_name.Accepted_name_family **
79 
Accepted_name.Accepted_name_lsid,,** No join mapping for *Accepted_name.Accepted_name_lsid **
80 
Accepted_name.Accepted_name_rank,,** No join mapping for *Accepted_name.Accepted_name_rank **
81 
Accepted_name.Accepted_name_species,,** No join mapping for *Accepted_name.Accepted_name_species **
82 
Accepted_name.Accepted_name_url,,** No join mapping for *Accepted_name.Accepted_name_url **
83 
Accepted_name.Annotations,,** No join mapping for *Accepted_name.Annotations **
84 
Accepted_name.Author_matched,,** No join mapping for *Accepted_name.Author_matched **
85 
Accepted_name.Author_score,,** No join mapping for *Accepted_name.Author_score **
86 
Accepted_name.Family_matched,,** No join mapping for *Accepted_name.Family_matched **
87 
Accepted_name.Family_score,,** No join mapping for *Accepted_name.Family_score **
88 
Accepted_name.Genus_matched,,** No join mapping for *Accepted_name.Genus_matched **
89 
Accepted_name.Genus_score,,** No join mapping for *Accepted_name.Genus_score **
90 
Accepted_name.Infraspecific_epithet_2_matched,,** No join mapping for *Accepted_name.Infraspecific_epithet_2_matched **
91 
Accepted_name.Infraspecific_epithet_2_score,,** No join mapping for *Accepted_name.Infraspecific_epithet_2_score **
92 
Accepted_name.Infraspecific_epithet_matched,,** No join mapping for *Accepted_name.Infraspecific_epithet_matched **
93 
Accepted_name.Infraspecific_epithet_score,,** No join mapping for *Accepted_name.Infraspecific_epithet_score **
94 
Accepted_name.Infraspecific_rank,,** No join mapping for *Accepted_name.Infraspecific_rank **
95 
Accepted_name.Infraspecific_rank_2,,** No join mapping for *Accepted_name.Infraspecific_rank_2 **
96 
Accepted_name.Name_matched,,** No join mapping for *Accepted_name.Name_matched **
97 
Accepted_name.Name_matched_accepted_family,,** No join mapping for *Accepted_name.Name_matched_accepted_family **
98 
Accepted_name.Name_matched_author,,** No join mapping for *Accepted_name.Name_matched_author **
99 
Accepted_name.Name_matched_rank,,** No join mapping for *Accepted_name.Name_matched_rank **
100 
Accepted_name.Name_matched_url,,** No join mapping for *Accepted_name.Name_matched_url **
101 
Accepted_name.Name_number,,** No join mapping for *Accepted_name.Name_number **
102 
Accepted_name.Name_score,,** No join mapping for *Accepted_name.Name_score **
103 
Accepted_name.Name_submitted,,** No join mapping for *Accepted_name.Name_submitted **
104 
Accepted_name.Overall_score,,** No join mapping for *Accepted_name.Overall_score **
105 
Accepted_name.Selected,,** No join mapping for *Accepted_name.Selected **
106 
Accepted_name.Source,,** No join mapping for *Accepted_name.Source **
107 
Accepted_name.Specific_epithet_matched,,** No join mapping for *Accepted_name.Specific_epithet_matched **
108 
Accepted_name.Specific_epithet_score,,** No join mapping for *Accepted_name.Specific_epithet_score **
109 
Accepted_name.Taxonomic_status,,** No join mapping for *Accepted_name.Taxonomic_status **
110 
Accepted_name.Time_submitted,,** No join mapping for *Accepted_name.Time_submitted **
111 
Accepted_name.Unmatched_terms,,** No join mapping for *Accepted_name.Unmatched_terms **
112 
Accepted_name.Warnings,,** No join mapping for *Accepted_name.Warnings **
113 
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid **
114 
Accepted_name_species,,** No join mapping for *Accepted_name_species ** Also contains genus. Omitted because Accepted_name contains more info.
115 
Accepted_name_url,,** No join mapping for *Accepted_name_url **
112 
Accepted_name.Accepted_name_lsid,,** No join mapping for *Accepted_name.Accepted_name_lsid/_first/3 **
113 
Accepted_name.Accepted_name_species,,** No join mapping for *Accepted_name.Accepted_name_species/_first/3 **
114 
Accepted_name.Accepted_name_url,,** No join mapping for *Accepted_name.Accepted_name_url/_first/3 **
115 
Accepted_name.Annotations,,** No join mapping for *Accepted_name.Annotations/_first/2 **
116 
Accepted_name.Author_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
117 
Accepted_name.Family_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
118 
Accepted_name.Genus_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
119 
Accepted_name.Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED/_first/2 **
120 
Accepted_name.Infraspecific_epithet_2_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
121 
Accepted_name.Infraspecific_epithet_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
122 
Accepted_name.Infraspecific_rank_2,,** No non-empty join mapping for UNUSED/_first/2 **
123 
Accepted_name.Name_matched_url,,** No join mapping for acceptedScientificNameID/_first/2 **
124 
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.
125 
Accepted_name.Name_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
126 
Accepted_name.Overall_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
127 
Accepted_name.Selected,,** No join mapping for *Accepted_name.Selected/_first/2 **
128 
Accepted_name.Source,,** No join mapping for *Accepted_name.Source/_first/2 **
129 
Accepted_name.Specific_epithet_score,,** No non-empty join mapping for OMIT/_first/2 ** Scores come from the matched name instead
130 
Accepted_name.Taxonomic_status,,** No join mapping for acceptedTaxonomicStatus/_first/2 **
131 
Accepted_name.Time_submitted,,** No join mapping for *Accepted_name.Time_submitted/_first/2 **
132 
Accepted_name.Unmatched_terms,,** No non-empty join mapping for OMIT/_first/2 ** Should be empty
133 
Accepted_name.Warnings,,** No join mapping for *Accepted_name.Warnings/_first/2 **
134 
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid/_first/2 **
135 
Accepted_name_species,,** No join mapping for *Accepted_name_species/_first/1 ** Also contains genus. Omitted because Accepted_name contains more info.
136 
Accepted_name_url,,** No join mapping for *Accepted_name_url/_first/1 **
116 137 
Annotations,,** No join mapping for *Annotations **
117 138 
Author_score,,** No join mapping for *Author_score **
118 139 
Infraspecific_epithet_2_matched,,** No non-empty join mapping for UNUSED **
inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref
37 37 
                                                                        </_taxon_family_require_std>
38 38 
                                                                    </1>
39 39 
                                                                    <2>
40 
                                                                        <_join_words>
41 
                                                                            <1>$Accepted_name</1>
42 
                                                                            <2>$Accepted_name_author</2>
43 
                                                                        </_join_words>
40 
                                                                        <_alt>
41 
                                                                            <1>$Accepted_name.Name_submitted</1>
42 
                                                                            <2>
43 
                                                                                <_join_words>
44 
                                                                                    <1>
45 
                                                                                        <_alt>
46 
                                                                                            <1>$Accepted_name</1>
47 
                                                                                            <2>
48 
                                                                                                <_join_words>
49 
                                                                                                    <2>$Accepted_name.Genus_matched</2>
50 
                                                                                                    <3>$Accepted_name.Specific_epithet_matched</3>
51 
                                                                                                    <5>
52 
                                                                                                        <_join_words>
53 
                                                                                                            <1>
54 
                                                                                                                <_if name="if has infraspecificEpithet">
55 
                                                                                                                    <cond>$Accepted_name.Infraspecific_epithet_matched</cond>
56 
                                                                                                                    <then>$Accepted_name_rank</then>
57 
                                                                                                                </_if>
58 
                                                                                                            </1>
59 
                                                                                                            <2>$Accepted_name.Infraspecific_epithet_matched</2>
60 
                                                                                                        </_join_words>
61 
                                                                                                    </5>
62 
                                                                                                </_join_words>
63 
                                                                                            </2>
64 
                                                                                        </_alt>
65 
                                                                                    </1>
66 
                                                                                    <2>$Accepted_name_author</2>
67 
                                                                                </_join_words>
68 
                                                                            </2>
69 
                                                                        </_alt>
44 70 
                                                                    </2>
45 71 
                                                                </_join_words>
46 72 
                                                            </taxonomicname>
......
52 78 
                                                                        <value>$Accepted_name_family</value>
53 79 
                                                                    </_nullIf>
54 80 
                                                                </family>
81 
                                                                <genus>$Accepted_name.Genus_matched</genus>
82 
                                                                <specific_epithet>$Accepted_name.Specific_epithet_matched</specific_epithet>
55 83 
                                                                <taxonname>$Accepted_name</taxonname>
84 
                                                                <taxonomicname>$Accepted_name.Name_submitted</taxonomicname>
56 85 
                                                                <verbatimrank>$Accepted_name_rank</verbatimrank>
57 86 
                                                            </taxonverbatim>
58 87 
                                                        </taxonlabel>
inputs/.TNRS/public.unscrubbed_taxondetermination_view/new_terms.csv
23 23 
Infraspecific_epithet_2_matched,UNUSED,,
24 24 
Infraspecific_epithet_2_score,UNUSED,,
25 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,
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,
inputs/.TNRS/public.unscrubbed_taxondetermination_view/unmapped_terms.csv
11 11 
*Warnings
12 12 
*Accepted_name_lsid
13 13 
*Accepted_name.Time_submitted
14 
*Accepted_name.Name_number
15 
*Accepted_name.Name_submitted
16 
*Accepted_name.Overall_score
17 
*Accepted_name.Name_matched
18 
*Accepted_name.Name_matched_rank
19 
*Accepted_name.Name_score
20 
*Accepted_name.Name_matched_author
21 
*Accepted_name.Name_matched_url
22 
*Accepted_name.Author_matched
23 
*Accepted_name.Author_score
24 
*Accepted_name.Family_matched
25 
*Accepted_name.Family_score
26 
*Accepted_name.Name_matched_accepted_family
27 
*Accepted_name.Genus_matched
28 
*Accepted_name.Genus_score
29 
*Accepted_name.Specific_epithet_matched
30 
*Accepted_name.Specific_epithet_score
31 
*Accepted_name.Infraspecific_rank
32 
*Accepted_name.Infraspecific_epithet_matched
33 
*Accepted_name.Infraspecific_epithet_score
34 
*Accepted_name.Infraspecific_rank_2
35 
*Accepted_name.Infraspecific_epithet_2_matched
36 
*Accepted_name.Infraspecific_epithet_2_score
14 
acceptedScientificNameID
37 15 
*Accepted_name.Annotations
38 
*Accepted_name.Unmatched_terms
39 
*Accepted_name.Taxonomic_status
40 
*Accepted_name.Accepted_name
41 
*Accepted_name.Accepted_name_author
42 
*Accepted_name.Accepted_name_rank
16 
acceptedTaxonomicStatus
43 17 
*Accepted_name.Accepted_name_url
44 18 
*Accepted_name.Accepted_name_species
45 
*Accepted_name.Accepted_name_family
46 19 
*Accepted_name.Selected
47 20 
*Accepted_name.Source
48 21 
*Accepted_name.Warnings

Also available in: Unified diff