Revision 13389
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 5971 | 5971 |
|
| 5972 | 5972 |
|
| 5973 | 5973 |
-- |
| 5974 |
-- Name: _plots_20_tnrs_input_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5975 |
-- |
|
| 5976 |
|
|
| 5977 |
|
|
| 5978 |
|
|
| 5979 |
|
|
| 5980 |
-- |
|
| 5981 |
-- Name: _plots_21_tnrs_output_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5982 |
-- |
|
| 5983 |
|
|
| 5984 |
|
|
| 5985 |
|
|
| 5986 |
|
|
| 5987 |
-- |
|
| 5974 | 5988 |
-- Name: _specimens_01_count_of_total_records_specimens_in_source_db; Type: VIEW; Schema: public_validations; Owner: - |
| 5975 | 5989 |
-- |
| 5976 | 5990 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9386 | 9386 |
|
| 9387 | 9387 |
|
| 9388 | 9388 |
-- |
| 9389 |
-- Name: _plots_20_tnrs_input_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 9390 |
-- |
|
| 9391 |
|
|
| 9392 |
CREATE VIEW _plots_20_tnrs_input_names AS |
|
| 9393 |
SELECT DISTINCT taxonlabel.taxonomicname AS tnrs_input_name |
|
| 9394 |
FROM public.taxonlabel |
|
| 9395 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL));
|
|
| 9396 |
|
|
| 9397 |
|
|
| 9398 |
-- |
|
| 9399 |
-- Name: _plots_21_tnrs_output_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 9400 |
-- |
|
| 9401 |
|
|
| 9402 |
CREATE VIEW _plots_21_tnrs_output_names AS |
|
| 9403 |
SELECT DISTINCT taxon_scrub."concatenatedScientificName" AS tnrs_output_name |
|
| 9404 |
FROM (public.taxonlabel |
|
| 9405 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
|
| 9406 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));
|
|
| 9407 |
|
|
| 9408 |
|
|
| 9409 |
-- |
|
| 9389 | 9410 |
-- Name: _specimens_01_count_of_total_records_specimens_in_source_db; Type: VIEW; Schema: public_validations; Owner: - |
| 9390 | 9411 |
-- |
| 9391 | 9412 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9386 | 9386 |
|
| 9387 | 9387 |
|
| 9388 | 9388 |
-- |
| 9389 |
-- Name: _plots_20_tnrs_input_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 9390 |
-- |
|
| 9391 |
|
|
| 9392 |
CREATE VIEW _plots_20_tnrs_input_names AS |
|
| 9393 |
SELECT DISTINCT taxonlabel.taxonomicname AS tnrs_input_name |
|
| 9394 |
FROM public.taxonlabel |
|
| 9395 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL));
|
|
| 9396 |
|
|
| 9397 |
|
|
| 9398 |
-- |
|
| 9399 |
-- Name: _plots_21_tnrs_output_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 9400 |
-- |
|
| 9401 |
|
|
| 9402 |
CREATE VIEW _plots_21_tnrs_output_names AS |
|
| 9403 |
SELECT DISTINCT taxon_scrub."concatenatedScientificName" AS tnrs_output_name |
|
| 9404 |
FROM (public.taxonlabel |
|
| 9405 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
|
| 9406 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));
|
|
| 9407 |
|
|
| 9408 |
|
|
| 9409 |
-- |
|
| 9389 | 9410 |
-- Name: _specimens_01_count_of_total_records_specimens_in_source_db; Type: VIEW; Schema: public_validations; Owner: - |
| 9390 | 9411 |
-- |
| 9391 | 9412 |
|
Also available in: Unified diff
schemas/public_.sql: added _plots_20_tnrs_input_names, _plots_21_tnrs_output_names