This query of plant and animal ELEMENT_SUBNATIONAL records finds inconsistent or invalid distribution data and rank using the Rank and Distribution Data Consistency (TAXON_SUBNATIONAL.DDF).

Records with the following TAXON_SUBNATIONAL.DDF values (reported in the rank_dist_check column) can be selected: 

• INVALID - ANIMAL RECORD MISSING POPULATION VALUE
• INVALID DATA COMBO
• INVALID DATA COMBO - HYBRID WITH RANK NOT SNA
• INVALID EST IDENTIFIER NO_DATA_FOUND
• INVALID - NO DISTRIBUTION DATA FOUND
• INVALID RANK SYNTAX
• VALID DATA COMBO - BUT REVIEW SUGGESTED
• MULTIPLE RANKS - UNABLE TO EVALUATE
• NOTHING VALID OR INVALID FOUND
• VALID DATA COMBO

Distribution data are reported in 2 columns (keep whichever you prefer):

• DISTRIBUTION_DATA: distribution data with field names concatenated in one column
• DIST_DATA_COND: distribution data without field names concatenated in one column

(via delimlist)

ACTION:

Step 1: Update the DDF values to prevent problems that would otherwise show up in the query results.

Step 2: Run the attached query to review subnational distribution grid values and make updates as needed.