Project

General

Profile

« Previous | Next » 

Revision 11643

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: tnrs: removed no longer used Accepted_scientific_name. use scrubbed_unique_taxon_name instead.

View differences:

schema.sql
103 103 
		, NULLIF(new."Name_matched", 'No suitable matches found.')
104 104 
		, new."Name_matched_author"
105 105 
		), '');
106 
BEGIN
107 
	new."Accepted_scientific_name" = NULLIF(concat_ws(' '
106 
	accepted_taxon_name_with_author text = NULLIF(concat_ws(' '
108 107 
		, NULLIF(NULLIF(new."Accepted_name_family", 'Unknown'),
109 108 
			new."Accepted_name")
110 109 
		, new."Accepted_name"
111 110 
		, new."Accepted_name_author"
112 111 
		), '');
112 
BEGIN
113 113 
	/* exclude homonyms because these are not valid matches (i.e. TNRS provides
114 114 
	a name, but the name is not meaningful because it is not unambiguous). */
115 115 
	new.is_valid_match = COALESCE(CASE
......
129 129 
			END)
130 130 
		END, false);
131 131 
	new.scrubbed_unique_taxon_name = COALESCE(
132 
		new."Accepted_scientific_name", matched_taxon_name_with_author);
132 
		accepted_taxon_name_with_author, matched_taxon_name_with_author);
133 133
134 134 
	RETURN new;
135 135 
END;
......
193 193 
    "Source" text,
194 194 
    "Warnings" text,
195 195 
    "Accepted_name_lsid" text,
196 
    "Accepted_scientific_name" text,
197 196 
    is_valid_match boolean NOT NULL,
198 197 
    scrubbed_unique_taxon_name text
199 198 
);

Also available in: Unified diff