QC Queries

Identify errors related to SRANK Review Date
Queries to help find and fix possible errors related to SRANK Review Date. (Updated 9/19/2016 by Lynn Kutner)   The following are modified from queries p...
Tue, 20 Dec, 2016 at 3:55 PM
Identify species EOs with an SRANK of "SX" or "SH" and with an EORANK value that is NOT “X”, “H”, or “F” (or is null)
This query selects species EO with an SRANK of "SX" or "SH" and with an EORANK value that is NOT “X”, “H”, or “F” (or is null). This app...
Tue, 20 Dec, 2016 at 3:57 PM
Identify invalid distribution data and rank for species EST records
This query of plant and animal ELEMENT_SUBNATIONAL records finds inconsistent or invalid distribution data and rank using the Rank and Distribution Data Con...
Mon, 26 Jul, 2021 at 7:44 AM
EST is not Locally Maintained or is Inactive
WHY PERFORM THE QC: During the exchange of ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, only locally ...
Wed, 20 Sep, 2017 at 3:39 PM
Sname is not the same as Gname or listed as a Global Synonym
WHY PERFORM THE QC: During the exchange of ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, a record is r...
Wed, 20 Sep, 2017 at 2:50 PM
Same Sname is used in more than 1 ELEMENT_SUBNATIONAL
WHY PERFORM THE QC: During the exchange of EST data from a local Network Program database to the central NatureServe database, a record is rejected if it ha...
Wed, 20 Sep, 2017 at 2:55 PM
ELEMENT_SUBNATIONAL with a subnation not matching the local subnation
WHY PERFORM THE QC: During the exchange of ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, records with ...
Wed, 20 Sep, 2017 at 3:00 PM
SRANK is Significantly Lower Conservation Value than GRANK or NRANK
WHY PERFORM THE QC: During the exchange of ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, a record is r...
Wed, 20 Sep, 2017 at 3:28 PM
ESTs exist on both a standard and a related nonstandard taxon
WHY PERFORM THE QC:  During the exchange of ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, a record fo...
Tue, 14 Nov, 2017 at 8:13 AM
EO and SOURCE_FEATURE are on different ELEMENT_SUBNATIONAL records
WHY PERFORM THE QC:  This is an invalid condition not allowed or expected by the Biotics 5 interface. Furthermore, during the exchange of ELEMENT_OCCURRENCE ...
Thu, 31 May, 2018 at 10:53 AM