Revision 13041
Added by Aaron Marcuse-Kubitza almost 11 years ago
| validations.sql | ||
|---|---|---|
| 68 | 68 |
|
| 69 | 69 |
|
| 70 | 70 |
-- |
| 71 |
-- Name: _specimens_04_count_of_unique_verbatim_species_without_author; Type: VIEW; Schema: NY; Owner: -
|
|
| 71 |
-- Name: _specimens_04_count_of_species_binomials; Type: VIEW; Schema: NY; Owner: -
|
|
| 72 | 72 |
-- |
| 73 | 73 |
|
| 74 |
CREATE VIEW _specimens_04_count_of_unique_verbatim_species_without_author AS
|
|
| 74 |
CREATE VIEW _specimens_04_count_of_species_binomials AS
|
|
| 75 | 75 |
SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet")) AS taxon_names_with_author
|
| 76 | 76 |
FROM "Ecatalog_all" |
| 77 | 77 |
WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
|
| 78 | 78 |
|
| 79 | 79 |
|
| 80 | 80 |
-- |
| 81 |
-- Name: VIEW _specimens_04_count_of_unique_verbatim_species_without_author; Type: COMMENT; Schema: NY; Owner: -
|
|
| 81 |
-- Name: VIEW _specimens_04_count_of_species_binomials; Type: COMMENT; Schema: NY; Owner: -
|
|
| 82 | 82 |
-- |
| 83 | 83 |
|
| 84 |
COMMENT ON VIEW _specimens_04_count_of_unique_verbatim_species_without_author IS '
|
|
| 84 |
COMMENT ON VIEW _specimens_04_count_of_species_binomials IS '
|
|
| 85 | 85 |
Check: should return 1 row |
| 86 | 86 |
'; |
| 87 | 87 |
|
| 88 | 88 |
|
| 89 | 89 |
-- |
| 90 |
-- Name: _specimens_05_list_of_verbatim_species_excluding_author; Type: VIEW; Schema: NY; Owner: -
|
|
| 90 |
-- Name: _specimens_05_list_of_species_binomials; Type: VIEW; Schema: NY; Owner: -
|
|
| 91 | 91 |
-- |
| 92 | 92 |
|
| 93 |
CREATE VIEW _specimens_05_list_of_verbatim_species_excluding_author AS
|
|
| 93 |
CREATE VIEW _specimens_05_list_of_species_binomials AS
|
|
| 94 | 94 |
SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet") AS taxon_name_with_author
|
| 95 | 95 |
FROM "Ecatalog_all" |
| 96 | 96 |
WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
|
| 97 | 97 |
|
| 98 | 98 |
|
| 99 | 99 |
-- |
| 100 |
-- Name: VIEW _specimens_05_list_of_verbatim_species_excluding_author; Type: COMMENT; Schema: NY; Owner: -
|
|
| 100 |
-- Name: VIEW _specimens_05_list_of_species_binomials; Type: COMMENT; Schema: NY; Owner: -
|
|
| 101 | 101 |
-- |
| 102 | 102 |
|
| 103 |
COMMENT ON VIEW _specimens_05_list_of_verbatim_species_excluding_author IS '
|
|
| 103 |
COMMENT ON VIEW _specimens_05_list_of_species_binomials IS '
|
|
| 104 | 104 |
Check: should return 3335 rows |
| 105 | 105 |
'; |
| 106 | 106 |
|
Also available in: Unified diff
validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: *_of_verbatim_species_excluding_author: renamed to *_species_binomials for clarity