Revision 7132
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schema.sql | ||
|---|---|---|
| 50 | 50 |
WITH ( |
| 51 | 51 |
OIDS=FALSE |
| 52 | 52 |
); |
| 53 |
|
|
| 54 |
CREATE OR REPLACE VIEW "tnrs+accepted" AS |
|
| 55 |
SELECT |
|
| 56 |
tnrs.* |
|
| 57 |
, tnrs_accepted."Time_submitted" AS "Accepted_name.Time_submitted" |
|
| 58 |
, tnrs_accepted."Name_number" AS "Accepted_name.Name_number" |
|
| 59 |
, tnrs_accepted."Name_submitted" AS "Accepted_name.Name_submitted" |
|
| 60 |
, tnrs_accepted."Overall_score" AS "Accepted_name.Overall_score" |
|
| 61 |
, tnrs_accepted."Name_matched" AS "Accepted_name.Name_matched" |
|
| 62 |
, tnrs_accepted."Name_matched_rank" AS "Accepted_name.Name_matched_rank" |
|
| 63 |
, tnrs_accepted."Name_score" AS "Accepted_name.Name_score" |
|
| 64 |
, tnrs_accepted."Name_matched_author" AS "Accepted_name.Name_matched_author" |
|
| 65 |
, tnrs_accepted."Name_matched_url" AS "Accepted_name.Name_matched_url" |
|
| 66 |
, tnrs_accepted."Author_matched" AS "Accepted_name.Author_matched" |
|
| 67 |
, tnrs_accepted."Author_score" AS "Accepted_name.Author_score" |
|
| 68 |
, tnrs_accepted."Family_matched" AS "Accepted_name.Family_matched" |
|
| 69 |
, tnrs_accepted."Family_score" AS "Accepted_name.Family_score" |
|
| 70 |
, tnrs_accepted."Name_matched_accepted_family" AS "Accepted_name.Name_matched_accepted_family" |
|
| 71 |
, tnrs_accepted."Genus_matched" AS "Accepted_name.Genus_matched" |
|
| 72 |
, tnrs_accepted."Genus_score" AS "Accepted_name.Genus_score" |
|
| 73 |
, tnrs_accepted."Specific_epithet_matched" AS "Accepted_name.Specific_epithet_matched" |
|
| 74 |
, tnrs_accepted."Specific_epithet_score" AS "Accepted_name.Specific_epithet_score" |
|
| 75 |
, tnrs_accepted."Infraspecific_rank" AS "Accepted_name.Infraspecific_rank" |
|
| 76 |
, tnrs_accepted."Infraspecific_epithet_matched" AS "Accepted_name.Infraspecific_epithet_matched" |
|
| 77 |
, tnrs_accepted."Infraspecific_epithet_score" AS "Accepted_name.Infraspecific_epithet_score" |
|
| 78 |
, tnrs_accepted."Infraspecific_rank_2" AS "Accepted_name.Infraspecific_rank_2" |
|
| 79 |
, tnrs_accepted."Infraspecific_epithet_2_matched" AS "Accepted_name.Infraspecific_epithet_2_matched" |
|
| 80 |
, tnrs_accepted."Infraspecific_epithet_2_score" AS "Accepted_name.Infraspecific_epithet_2_score" |
|
| 81 |
, tnrs_accepted."Annotations" AS "Accepted_name.Annotations" |
|
| 82 |
, tnrs_accepted."Unmatched_terms" AS "Accepted_name.Unmatched_terms" |
|
| 83 |
, tnrs_accepted."Taxonomic_status" AS "Accepted_name.Taxonomic_status" |
|
| 84 |
, tnrs_accepted."Accepted_name" AS "Accepted_name.Accepted_name" |
|
| 85 |
, tnrs_accepted."Accepted_name_author" AS "Accepted_name.Accepted_name_author" |
|
| 86 |
, tnrs_accepted."Accepted_name_rank" AS "Accepted_name.Accepted_name_rank" |
|
| 87 |
, tnrs_accepted."Accepted_name_url" AS "Accepted_name.Accepted_name_url" |
|
| 88 |
, tnrs_accepted."Accepted_name_species" AS "Accepted_name.Accepted_name_species" |
|
| 89 |
, tnrs_accepted."Accepted_name_family" AS "Accepted_name.Accepted_name_family" |
|
| 90 |
, tnrs_accepted."Selected" AS "Accepted_name.Selected" |
|
| 91 |
, tnrs_accepted."Source" AS "Accepted_name.Source" |
|
| 92 |
, tnrs_accepted."Warnings" AS "Accepted_name.Warnings" |
|
| 93 |
, tnrs_accepted."Accepted_name_lsid" AS "Accepted_name.Accepted_name_lsid" |
|
| 94 |
FROM tnrs |
|
| 95 |
LEFT JOIN tnrs tnrs_accepted ON |
|
| 96 |
tnrs_accepted."Name_submitted" = NULLIF(array_to_string(ARRAY[ |
|
| 97 |
NULLIF(tnrs."Accepted_name_family", 'Unknown') |
|
| 98 |
, tnrs."Accepted_name" |
|
| 99 |
, tnrs."Accepted_name_author" |
|
| 100 |
], ' '), '') |
|
| 101 |
; |
|
Also available in: Unified diff
inputs/.TNRS/: Changed tnrs+accepted to a view (defined in schema.sql) so accepted names would automatically be populated as they are parsed by TNRS, rather than needing to run `make inputs/.TNRS/tnrs+accepted/reinstall` to populate them