Revision 13431
Added by Aaron Marcuse-Kubitza over 10 years ago
| public_.sql | ||
|---|---|---|
| 9386 | 9386 |
|
| 9387 | 9387 |
|
| 9388 | 9388 |
-- |
| 9389 |
-- Name: _plots_20_tnrs_input_names; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 9389 |
-- Name: _plots_20_tnrs_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 9390 | 9390 |
-- |
| 9391 | 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));
|
|
| 9392 |
CREATE VIEW _plots_20_tnrs_names AS |
|
| 9393 |
SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname AS tnrs_input_name, |
|
| 9394 |
taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name |
|
| 9395 |
FROM (public.taxonlabel |
|
| 9396 |
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))
|
|
| 9398 |
ORDER BY taxonlabel.taxonomicname; |
|
| 9396 | 9399 |
|
| 9397 | 9400 |
|
| 9398 | 9401 |
-- |
| 9399 |
-- Name: VIEW _plots_20_tnrs_input_names; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 9402 |
-- Name: VIEW _plots_20_tnrs_names; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 9400 | 9403 |
-- |
| 9401 | 9404 |
|
| 9402 |
COMMENT ON VIEW _plots_20_tnrs_input_names IS '
|
|
| 9405 |
COMMENT ON VIEW _plots_20_tnrs_names IS ' |
|
| 9403 | 9406 |
The first check is done while checking up on Aaron''s quantitative validations |
| 9404 | 9407 |
("comparing the results of the plot output queries run on VegBIEN to the data in
|
| 9405 | 9408 |
VegBank"). Several input-output queries include verbatim taxon names; if they |
| ... | ... | |
| 9407 | 9410 |
the verbatim name and not the resolved name, this first check is important. If |
| 9408 | 9411 |
Aaron is messing up the verbatim name somehow, the resolved name will not be |
| 9409 | 9412 |
correct. |
| 9410 |
'; |
|
| 9411 | 9413 |
|
| 9412 |
|
|
| 9413 |
-- |
|
| 9414 |
-- Name: _plots_21_tnrs_output_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 9415 |
-- |
|
| 9416 |
|
|
| 9417 |
CREATE VIEW _plots_21_tnrs_output_names AS |
|
| 9418 |
SELECT DISTINCT taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name |
|
| 9419 |
FROM (public.taxonlabel |
|
| 9420 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
|
| 9421 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));
|
|
| 9422 |
|
|
| 9423 |
|
|
| 9424 |
-- |
|
| 9425 |
-- Name: VIEW _plots_21_tnrs_output_names; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 9426 |
-- |
|
| 9427 |
|
|
| 9428 |
COMMENT ON VIEW _plots_21_tnrs_output_names IS ' |
|
| 9429 | 9414 |
The second check should focus on determining if Aaron is reconstructing |
| 9430 | 9415 |
morphospecies names correctly. The TNRS stores the morphospecies part of the |
| 9431 | 9416 |
name (e.g., "sp.1") in the column "Unmatched_terms"; a bit of additional |
Also available in: Unified diff
schemas/public_.sql: merged _plots_20_tnrs_input_names, _plots_21_tnrs_output_names into _plots_20_tnrs_names so the input and output names can be compared side-by-side