QC Queries

EST records for SPECIES that have an EO but the DISTRIBUTION CONFIDENCE is not “confident”:
This query finds all ELEMENT_SUBNATIONAL records for SPECIES that have an EO, and the DISTRIBUTION CONFIDENCE is any value other than “confident”:  NT (N...
Tue, 20 Dec, 2016 at 3:41 PM
Identify inconsistencies in the SRANK of infra taxa and their related “parent” species
This query checks for inconsistencies in the SRANK of infra taxa and their related “parent” species.  Example: Infra SRANK = S4 and parent SRANK = SH.    ...
Tue, 20 Dec, 2016 at 3:41 PM
EO records with “Last Observation Date” (LASTOBS) values that potentially need review
This query selects EO records with “Last Observation Date” (LASTOBS) values that potentially need review.  ACTION: Please review the values in the EO LA...
Tue, 20 Dec, 2016 at 3:44 PM
EST records that have a NATIONAL origin of “exotic”, the SUBNATIONAL DISTRIBUTION CONFIDENCE is “Confident,” and the SUBNATIONAL ORIGIN is either “Native” or “Unknown/Undetermined
This query selects all ELEMENT_SUBNATIONAL records that have a NATIONAL origin of “exotic” in your nation, the SUBNATIONAL DISTRIBUTION CONFIDENCE is “Confi...
Tue, 20 Dec, 2016 at 3:46 PM
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...
Thu, 3 Aug, 2017 at 9:18 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