Revision 13394
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9400 | 9400 |
-- |
| 9401 | 9401 |
|
| 9402 | 9402 |
CREATE VIEW _plots_21_tnrs_output_names AS |
| 9403 |
SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name
|
|
| 9403 |
SELECT DISTINCT taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name
|
|
| 9404 | 9404 |
FROM (public.taxonlabel |
| 9405 | 9405 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 9406 | 9406 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9400 | 9400 |
-- |
| 9401 | 9401 |
|
| 9402 | 9402 |
CREATE VIEW _plots_21_tnrs_output_names AS |
| 9403 |
SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name
|
|
| 9403 |
SELECT DISTINCT taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name
|
|
| 9404 | 9404 |
FROM (public.taxonlabel |
| 9405 | 9405 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 9406 | 9406 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));
|
| trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql | ||
|---|---|---|
| 345 | 345 |
-- _plots_21_tnrs_output_names |
| 346 | 346 |
SET join_collapse_limit = DEFAULT; |
| 347 | 347 |
SET enable_hashjoin = off; |
| 348 |
SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name
|
|
| 348 |
SELECT DISTINCT taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name
|
|
| 349 | 349 |
FROM (taxonlabel |
| 350 | 350 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 351 | 351 |
WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL)); |
Also available in: Unified diff
schemas/vegbien.sql: _plots_21_tnrs_output_names: use scrubbed_unique_taxon_name (concatenated output name) because this is more similar to the concatenated name used in _plots_20_tnrs_input_names