WHAT THE QUERY DOES: This query reports any record where a taxon is recorded as:
- endemic to a single state or province in the Global Tracking field “Jurisdictional Endemism” but NOT the Subnational Tracking field “Endemism”
- endemic to a single state or province in the Subnational Tracking field “Endemism” but NOT the Global Tracking field “Jurisdictional Endemism”
- endemic to a single state or province in either the Global Tracking field “Jurisdictional Endemism” or the Subnational Tracking field “Endemism” AND the Global Rank and Subnational Rank are not the same.
Where inconsistencies exist, values returned in the Endemism or Rank columns start with “CHECK.”
OPTION: The file Endemism_discrepancies_QC_SQL.txt may be run with Excel or CSV output to download and analyze. Endemism_discrepancies_QC_SQL_wHTML.txt is made to run with html output, as it highlights discrepancies in red and provides links to EGT and EST records so that issues can be easily reviewed and fixed.
OPTION: Query ignores records where Srank is SNR or SNA. The line “and est.s_rank not in ('SNR','SNA')” in the WHERE portion of the query can be commented out or deleted to find additional discrepancies.
OPTION: Query finds cases where the EST Endemism field is “Y” but EGT Jurisdictional Endemism is null. To ignore these cases, in the WHERE portion of the query under “--EST says endemic EGT does not” delete “or tg.d_juris_endem_id is null.”
ACTION: Review inconsistencies and update subnational data where necessary. Where global data should be updated, notify Central Science Staff by creating a support ticket to request the update (in Biotics: click “Contact Support” at the bottom of any screen, select “New support ticket” and fill in the form, entering Application: Biotics, Component: Science Request).