Revision 13432
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9390 | 9390 |
-- |
| 9391 | 9391 |
|
| 9392 | 9392 |
CREATE VIEW _plots_20_tnrs_names AS |
| 9393 |
SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname AS tnrs_input_name, |
|
| 9393 |
SELECT taxonlabel.taxonomicname AS verbatim_name_with_author, |
|
| 9394 |
taxonlabel.taxonomicname AS tnrs_input_name, |
|
| 9394 | 9395 |
taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name |
| 9395 |
FROM (public.taxonlabel |
|
| 9396 |
FROM ((public.taxonverbatim |
|
| 9397 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
|
| 9396 | 9398 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 9397 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL))
|
|
| 9399 |
WHERE (taxonverbatim.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname))
|
|
| 9398 | 9400 |
ORDER BY taxonlabel.taxonomicname; |
| 9399 | 9401 |
|
| 9400 | 9402 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9390 | 9390 |
-- |
| 9391 | 9391 |
|
| 9392 | 9392 |
CREATE VIEW _plots_20_tnrs_names AS |
| 9393 |
SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname AS tnrs_input_name, |
|
| 9393 |
SELECT taxonlabel.taxonomicname AS verbatim_name_with_author, |
|
| 9394 |
taxonlabel.taxonomicname AS tnrs_input_name, |
|
| 9394 | 9395 |
taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name |
| 9395 |
FROM (public.taxonlabel |
|
| 9396 |
FROM ((public.taxonverbatim |
|
| 9397 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
|
| 9396 | 9398 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 9397 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL))
|
|
| 9399 |
WHERE (taxonverbatim.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname))
|
|
| 9398 | 9400 |
ORDER BY taxonlabel.taxonomicname; |
| 9399 | 9401 |
|
| 9400 | 9402 |
|
Also available in: Unified diff
schemas/public_.sql: _plots_20_tnrs_names: added verbatim name in order to also validate the formation of the concatenated name