Revision 13431
Added by Aaron Marcuse-Kubitza over 10 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: -
|
|
| 5974 |
-- Name: _plots_20_tnrs_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5975 | 5975 |
-- |
| 5976 | 5976 |
|
| 5977 | 5977 |
|
| 5978 | 5978 |
|
| 5979 | 5979 |
|
| 5980 | 5980 |
-- |
| 5981 |
-- Name: VIEW _plots_20_tnrs_input_names; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 5981 |
-- Name: VIEW _plots_20_tnrs_names; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 5982 | 5982 |
-- |
| 5983 | 5983 |
|
| 5984 | 5984 |
|
| 5985 | 5985 |
|
| 5986 | 5986 |
|
| 5987 | 5987 |
-- |
| 5988 |
-- Name: _plots_21_tnrs_output_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 5989 |
-- |
|
| 5990 |
|
|
| 5991 |
|
|
| 5992 |
|
|
| 5993 |
|
|
| 5994 |
-- |
|
| 5995 |
-- Name: VIEW _plots_21_tnrs_output_names; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 5996 |
-- |
|
| 5997 |
|
|
| 5998 |
|
|
| 5999 |
|
|
| 6000 |
|
|
| 6001 |
-- |
|
| 6002 | 5988 |
-- Name: _specimens_01_count_of_total_records_specimens_in_source_db; Type: VIEW; Schema: public_validations; Owner: - |
| 6003 | 5989 |
-- |
| 6004 | 5990 |
|
| trunk/schemas/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 |
| trunk/schemas/vegbien.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