| 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
|
fix: schemas/vegbien.sql: renamed output views to match input views