Revision 12317
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 6014 | 6014 |
|
| 6015 | 6015 |
|
| 6016 | 6016 |
-- |
| 6017 |
-- Name: _traits_06_list_taxa; Type: VIEW; Schema: public_validations; Owner: - |
|
| 6017 |
-- Name: _traits_06_list_distinct_taxa; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 6018 | 6018 |
-- |
| 6019 | 6019 |
|
| 6020 |
CREATE VIEW _traits_06_list_taxa AS |
|
| 6020 |
CREATE VIEW _traits_06_list_distinct_taxa AS
|
|
| 6021 | 6021 |
SELECT DISTINCT concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author) AS taxonwithauthor
|
| 6022 | 6022 |
FROM public.taxonverbatim |
| 6023 | 6023 |
WHERE (taxonverbatim.source_id = public.source_by_shortname(("current_schema"())::text))
|
| ... | ... | |
| 6025 | 6025 |
|
| 6026 | 6026 |
|
| 6027 | 6027 |
-- |
| 6028 |
-- Name: VIEW _traits_06_list_taxa; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 6028 |
-- Name: VIEW _traits_06_list_distinct_taxa; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 6029 | 6029 |
-- |
| 6030 | 6030 |
|
| 6031 |
COMMENT ON VIEW _traits_06_list_taxa IS ' |
|
| 6031 |
COMMENT ON VIEW _traits_06_list_distinct_taxa IS '
|
|
| 6032 | 6032 |
Note 1: No morphospecies in trait table, use taxon + authority |
| 6033 | 6033 |
Note 2: Note formation of taxonCorrected: includes family ONLY if taxon is not determined at least to genus |
| 6034 | 6034 |
'; |
| 6035 | 6035 |
|
| 6036 | 6036 |
|
| 6037 | 6037 |
-- |
| 6038 |
-- Name: _traits_07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 6038 |
-- Name: _traits_07_trait_value_and_units; Type: VIEW; Schema: public_validations; Owner: - |
|
| 6039 | 6039 |
-- |
| 6040 | 6040 |
|
| 6041 |
CREATE VIEW _traits_07_trait_value_and_units_for_first_5000_records AS
|
|
| 6041 |
CREATE VIEW _traits_07_trait_value_and_units AS |
|
| 6042 | 6042 |
SELECT trait.name AS trait, |
| 6043 | 6043 |
trait.value, |
| 6044 | 6044 |
trait.units |
| ... | ... | |
| 6050 | 6050 |
|
| 6051 | 6051 |
|
| 6052 | 6052 |
-- |
| 6053 |
-- Name: _traits_08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: - |
|
| 6053 |
-- Name: _traits_08_taxonname_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 6054 | 6054 |
-- |
| 6055 | 6055 |
|
| 6056 |
CREATE VIEW _traits_08_taxon_trait_and_value_for_first_5000_records AS |
|
| 6056 |
CREATE VIEW _traits_08_taxonname_trait_and_value_for_first_5000_records AS
|
|
| 6057 | 6057 |
SELECT concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author) AS taxonwithauthor,
|
| 6058 | 6058 |
trait.name AS trait, |
| 6059 | 6059 |
trait.value |
Also available in: Unified diff
fix: schemas/vegbien.sql: renamed output views to match input views