Revision 13875
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 557 | 557 |
|
| 558 | 558 |
|
| 559 | 559 |
-- |
| 560 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
|
| 561 |
-- |
|
| 562 |
|
|
| 563 |
CREATE VIEW taxon_best_match AS |
|
| 564 |
SELECT taxon_match.batch, |
|
| 565 |
taxon_match.match_num, |
|
| 566 |
taxon_match."Name_number", |
|
| 567 |
taxon_match."Name_submitted", |
|
| 568 |
taxon_match."Overall_score", |
|
| 569 |
taxon_match."Name_matched", |
|
| 570 |
taxon_match."Name_matched_rank", |
|
| 571 |
taxon_match."Name_score", |
|
| 572 |
taxon_match."Name_matched_author", |
|
| 573 |
taxon_match."Name_matched_url", |
|
| 574 |
taxon_match."Author_matched", |
|
| 575 |
taxon_match."Author_score", |
|
| 576 |
taxon_match."Family_matched", |
|
| 577 |
taxon_match."Family_score", |
|
| 578 |
taxon_match."Name_matched_accepted_family", |
|
| 579 |
taxon_match."Genus_matched", |
|
| 580 |
taxon_match."Genus_score", |
|
| 581 |
taxon_match."Specific_epithet_matched", |
|
| 582 |
taxon_match."Specific_epithet_score", |
|
| 583 |
taxon_match."Infraspecific_rank", |
|
| 584 |
taxon_match."Infraspecific_epithet_matched", |
|
| 585 |
taxon_match."Infraspecific_epithet_score", |
|
| 586 |
taxon_match."Infraspecific_rank_2", |
|
| 587 |
taxon_match."Infraspecific_epithet_2_matched", |
|
| 588 |
taxon_match."Infraspecific_epithet_2_score", |
|
| 589 |
taxon_match."Annotations", |
|
| 590 |
taxon_match."Unmatched_terms", |
|
| 591 |
taxon_match."Taxonomic_status", |
|
| 592 |
taxon_match."Accepted_name", |
|
| 593 |
taxon_match."Accepted_name_author", |
|
| 594 |
taxon_match."Accepted_name_rank", |
|
| 595 |
taxon_match."Accepted_name_url", |
|
| 596 |
taxon_match."Accepted_name_species", |
|
| 597 |
taxon_match."Accepted_name_family", |
|
| 598 |
taxon_match."Selected", |
|
| 599 |
taxon_match."Source", |
|
| 600 |
taxon_match."Warnings", |
|
| 601 |
taxon_match."Accepted_name_lsid", |
|
| 602 |
taxon_match.is_valid_match, |
|
| 603 |
taxon_match.scrubbed_unique_taxon_name |
|
| 604 |
FROM taxon_match |
|
| 605 |
WHERE (taxon_match."Selected" = 'true'::text); |
|
| 606 |
|
|
| 607 |
|
|
| 608 |
-- |
|
| 609 |
-- Name: VIEW taxon_best_match; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 610 |
-- |
|
| 611 |
|
|
| 612 |
COMMENT ON VIEW taxon_best_match IS ' |
|
| 613 |
to modify: |
|
| 614 |
SELECT util.recreate_view(''"TNRS"."taxon_best_match"'', $$
|
|
| 615 |
SELECT __ |
|
| 616 |
$$); |
|
| 617 |
'; |
|
| 618 |
|
|
| 619 |
|
|
| 620 |
-- |
|
| 560 | 621 |
-- Name: taxon_match_input; Type: VIEW; Schema: TNRS; Owner: - |
| 561 | 622 |
-- |
| 562 | 623 |
|
| ... | ... | |
| 911 | 972 |
|
| 912 | 973 |
|
| 913 | 974 |
-- |
| 975 |
-- Name: taxon_best_match; Type: ACL; Schema: TNRS; Owner: - |
|
| 976 |
-- |
|
| 977 |
|
|
| 978 |
REVOKE ALL ON TABLE taxon_best_match FROM PUBLIC; |
|
| 979 |
REVOKE ALL ON TABLE taxon_best_match FROM bien; |
|
| 980 |
GRANT ALL ON TABLE taxon_best_match TO bien; |
|
| 981 |
GRANT SELECT ON TABLE taxon_best_match TO bien_read; |
|
| 982 |
|
|
| 983 |
|
|
| 984 |
-- |
|
| 914 | 985 |
-- Name: taxon_match_input; Type: ACL; Schema: TNRS; Owner: - |
| 915 | 986 |
-- |
| 916 | 987 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 15519 | 15519 |
|
| 15520 | 15520 |
|
| 15521 | 15521 |
-- |
| 15522 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
|
| 15523 |
-- |
|
| 15524 |
|
|
| 15525 |
|
|
| 15526 |
|
|
| 15527 |
|
|
| 15528 |
-- |
|
| 15529 |
-- Name: VIEW taxon_best_match; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15530 |
-- |
|
| 15531 |
|
|
| 15532 |
|
|
| 15533 |
|
|
| 15534 |
|
|
| 15535 |
-- |
|
| 15522 | 15536 |
-- Name: taxon_match_input; Type: VIEW; Schema: TNRS; Owner: - |
| 15523 | 15537 |
-- |
| 15524 | 15538 |
|
| ... | ... | |
| 15840 | 15854 |
|
| 15841 | 15855 |
|
| 15842 | 15856 |
-- |
| 15857 |
-- Name: taxon_best_match; Type: ACL; Schema: TNRS; Owner: - |
|
| 15858 |
-- |
|
| 15859 |
|
|
| 15860 |
|
|
| 15861 |
|
|
| 15862 |
|
|
| 15863 |
|
|
| 15864 |
|
|
| 15865 |
|
|
| 15866 |
-- |
|
| 15843 | 15867 |
-- Name: taxon_match_input; Type: ACL; Schema: TNRS; Owner: - |
| 15844 | 15868 |
-- |
| 15845 | 15869 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19548 | 19548 |
|
| 19549 | 19549 |
|
| 19550 | 19550 |
-- |
| 19551 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
|
| 19552 |
-- |
|
| 19553 |
|
|
| 19554 |
CREATE VIEW taxon_best_match AS |
|
| 19555 |
SELECT taxon_match.batch, |
|
| 19556 |
taxon_match.match_num, |
|
| 19557 |
taxon_match."Name_number", |
|
| 19558 |
taxon_match."Name_submitted", |
|
| 19559 |
taxon_match."Overall_score", |
|
| 19560 |
taxon_match."Name_matched", |
|
| 19561 |
taxon_match."Name_matched_rank", |
|
| 19562 |
taxon_match."Name_score", |
|
| 19563 |
taxon_match."Name_matched_author", |
|
| 19564 |
taxon_match."Name_matched_url", |
|
| 19565 |
taxon_match."Author_matched", |
|
| 19566 |
taxon_match."Author_score", |
|
| 19567 |
taxon_match."Family_matched", |
|
| 19568 |
taxon_match."Family_score", |
|
| 19569 |
taxon_match."Name_matched_accepted_family", |
|
| 19570 |
taxon_match."Genus_matched", |
|
| 19571 |
taxon_match."Genus_score", |
|
| 19572 |
taxon_match."Specific_epithet_matched", |
|
| 19573 |
taxon_match."Specific_epithet_score", |
|
| 19574 |
taxon_match."Infraspecific_rank", |
|
| 19575 |
taxon_match."Infraspecific_epithet_matched", |
|
| 19576 |
taxon_match."Infraspecific_epithet_score", |
|
| 19577 |
taxon_match."Infraspecific_rank_2", |
|
| 19578 |
taxon_match."Infraspecific_epithet_2_matched", |
|
| 19579 |
taxon_match."Infraspecific_epithet_2_score", |
|
| 19580 |
taxon_match."Annotations", |
|
| 19581 |
taxon_match."Unmatched_terms", |
|
| 19582 |
taxon_match."Taxonomic_status", |
|
| 19583 |
taxon_match."Accepted_name", |
|
| 19584 |
taxon_match."Accepted_name_author", |
|
| 19585 |
taxon_match."Accepted_name_rank", |
|
| 19586 |
taxon_match."Accepted_name_url", |
|
| 19587 |
taxon_match."Accepted_name_species", |
|
| 19588 |
taxon_match."Accepted_name_family", |
|
| 19589 |
taxon_match."Selected", |
|
| 19590 |
taxon_match."Source", |
|
| 19591 |
taxon_match."Warnings", |
|
| 19592 |
taxon_match."Accepted_name_lsid", |
|
| 19593 |
taxon_match.is_valid_match, |
|
| 19594 |
taxon_match.scrubbed_unique_taxon_name |
|
| 19595 |
FROM taxon_match |
|
| 19596 |
WHERE (taxon_match."Selected" = 'true'::text); |
|
| 19597 |
|
|
| 19598 |
|
|
| 19599 |
-- |
|
| 19600 |
-- Name: VIEW taxon_best_match; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 19601 |
-- |
|
| 19602 |
|
|
| 19603 |
COMMENT ON VIEW taxon_best_match IS ' |
|
| 19604 |
to modify: |
|
| 19605 |
SELECT util.recreate_view(''"TNRS"."taxon_best_match"'', $$
|
|
| 19606 |
SELECT __ |
|
| 19607 |
$$); |
|
| 19608 |
'; |
|
| 19609 |
|
|
| 19610 |
|
|
| 19611 |
-- |
|
| 19551 | 19612 |
-- Name: taxon_match_input; Type: VIEW; Schema: TNRS; Owner: - |
| 19552 | 19613 |
-- |
| 19553 | 19614 |
|
| ... | ... | |
| 19979 | 20040 |
|
| 19980 | 20041 |
|
| 19981 | 20042 |
-- |
| 20043 |
-- Name: taxon_best_match; Type: ACL; Schema: TNRS; Owner: - |
|
| 20044 |
-- |
|
| 20045 |
|
|
| 20046 |
REVOKE ALL ON TABLE taxon_best_match FROM PUBLIC; |
|
| 20047 |
REVOKE ALL ON TABLE taxon_best_match FROM bien; |
|
| 20048 |
GRANT ALL ON TABLE taxon_best_match TO bien; |
|
| 20049 |
GRANT SELECT ON TABLE taxon_best_match TO bien_read; |
|
| 20050 |
|
|
| 20051 |
|
|
| 20052 |
-- |
|
| 19982 | 20053 |
-- Name: taxon_match_input; Type: ACL; Schema: TNRS; Owner: - |
| 19983 | 20054 |
-- |
| 19984 | 20055 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: added taxon_best_match view