Revision 7153
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 165 | 165 |
LEFT JOIN tnrs tnrs_accepted ON tnrs_accepted."Name_submitted" = tnrs."Accepted_scientific_name"; |
| 166 | 166 |
COMMENT ON VIEW tnrs_canon |
| 167 | 167 |
IS 'The most canonicalized name output by TNRS. This will be the accepted name if available, and the matched name otherwise. In either case, the match scores are always from the matched name, not the accepted name (whose match scores should always be close to 1).'; |
| 168 |
|
|
| 169 |
|
|
| 170 |
CREATE OR REPLACE VIEW "tnrs+accepted" AS |
|
| 171 |
SELECT |
|
| 172 |
tnrs.* |
|
| 173 |
, tnrs_accepted."Time_submitted" AS "Accepted_name.Time_submitted" |
|
| 174 |
, tnrs_accepted."Name_number" AS "Accepted_name.Name_number" |
|
| 175 |
, tnrs_accepted."Name_submitted" AS "Accepted_name.Name_submitted" |
|
| 176 |
, tnrs_accepted."Overall_score" AS "Accepted_name.Overall_score" |
|
| 177 |
, tnrs_accepted."Name_matched" AS "Accepted_name.Name_matched" |
|
| 178 |
, tnrs_accepted."Name_matched_rank" AS "Accepted_name.Name_matched_rank" |
|
| 179 |
, tnrs_accepted."Name_score" AS "Accepted_name.Name_score" |
|
| 180 |
, tnrs_accepted."Name_matched_author" AS "Accepted_name.Name_matched_author" |
|
| 181 |
, tnrs_accepted."Name_matched_url" AS "Accepted_name.Name_matched_url" |
|
| 182 |
, tnrs_accepted."Author_matched" AS "Accepted_name.Author_matched" |
|
| 183 |
, tnrs_accepted."Author_score" AS "Accepted_name.Author_score" |
|
| 184 |
, tnrs_accepted."Family_matched" AS "Accepted_name.Family_matched" |
|
| 185 |
, tnrs_accepted."Family_score" AS "Accepted_name.Family_score" |
|
| 186 |
, tnrs_accepted."Name_matched_accepted_family" AS "Accepted_name.Name_matched_accepted_family" |
|
| 187 |
, tnrs_accepted."Genus_matched" AS "Accepted_name.Genus_matched" |
|
| 188 |
, tnrs_accepted."Genus_score" AS "Accepted_name.Genus_score" |
|
| 189 |
, tnrs_accepted."Specific_epithet_matched" AS "Accepted_name.Specific_epithet_matched" |
|
| 190 |
, tnrs_accepted."Specific_epithet_score" AS "Accepted_name.Specific_epithet_score" |
|
| 191 |
, tnrs_accepted."Infraspecific_rank" AS "Accepted_name.Infraspecific_rank" |
|
| 192 |
, tnrs_accepted."Infraspecific_epithet_matched" AS "Accepted_name.Infraspecific_epithet_matched" |
|
| 193 |
, tnrs_accepted."Infraspecific_epithet_score" AS "Accepted_name.Infraspecific_epithet_score" |
|
| 194 |
, tnrs_accepted."Infraspecific_rank_2" AS "Accepted_name.Infraspecific_rank_2" |
|
| 195 |
, tnrs_accepted."Infraspecific_epithet_2_matched" AS "Accepted_name.Infraspecific_epithet_2_matched" |
|
| 196 |
, tnrs_accepted."Infraspecific_epithet_2_score" AS "Accepted_name.Infraspecific_epithet_2_score" |
|
| 197 |
, tnrs_accepted."Annotations" AS "Accepted_name.Annotations" |
|
| 198 |
, tnrs_accepted."Unmatched_terms" AS "Accepted_name.Unmatched_terms" |
|
| 199 |
, tnrs_accepted."Taxonomic_status" AS "Accepted_name.Taxonomic_status" |
|
| 200 |
, tnrs_accepted."Accepted_name" AS "Accepted_name.Accepted_name" |
|
| 201 |
, tnrs_accepted."Accepted_name_author" AS "Accepted_name.Accepted_name_author" |
|
| 202 |
, tnrs_accepted."Accepted_name_rank" AS "Accepted_name.Accepted_name_rank" |
|
| 203 |
, tnrs_accepted."Accepted_name_url" AS "Accepted_name.Accepted_name_url" |
|
| 204 |
, tnrs_accepted."Accepted_name_species" AS "Accepted_name.Accepted_name_species" |
|
| 205 |
, tnrs_accepted."Accepted_name_family" AS "Accepted_name.Accepted_name_family" |
|
| 206 |
, tnrs_accepted."Selected" AS "Accepted_name.Selected" |
|
| 207 |
, tnrs_accepted."Source" AS "Accepted_name.Source" |
|
| 208 |
, tnrs_accepted."Warnings" AS "Accepted_name.Warnings" |
|
| 209 |
, tnrs_accepted."Accepted_name_lsid" AS "Accepted_name.Accepted_name_lsid" |
|
| 210 |
, tnrs_accepted."Accepted_scientific_name" AS "Accepted_name.Accepted_scientific_name" |
|
| 211 |
FROM tnrs |
|
| 212 |
LEFT JOIN tnrs tnrs_accepted ON |
|
| 213 |
tnrs_accepted."Name_submitted" = tnrs."Accepted_scientific_name" |
|
| 214 |
; |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: Removed no longer used tnrs+accepted. Use tnrs_canon or a self-join of tnrs instead