Default SQL filters for BIEN range modeling, biendata.org and RBIEN

Current version (as of 5 March 2021)

WHERE scrubbed_species_binomial IS NOT NULL
AND higher_plant_group IN ('bryophytes', 'ferns and allies','flowering plants','gymnosperms (conifers)', 'gymnosperms (non-conifer)')
AND is_invalid_latlong=0
AND is_geovalid = 1
AND (georef_protocol is NULL OR georef_protocol<>'county_centroid')
AND (is_centroid IS NULL OR is_centroid=0)
AND is_location_cultivated IS NULL
AND (is_cultivated_observation = 0 OR is_cultivated_observation IS NULL)
AND observation_type IN ('plot','specimen','literature','checklist')
AND ( EXTRACT(YEAR FROM event_date)>=1950 OR event_date IS NULL )
AND is_introduced=0

Usage notes

• Wrap the entire clause in parentheses if combining with additional WHERE criteria
• Condition "scrubbed_species_binomial IS NOT NULL" can be omitted if filtering by one or more species
• For range modeling only, condition "AND is_introduced=0" is omitted for species with no information in the NSR database (i.e., native_status="UNK" for all countries). Range maps for these species should be used with caution as they may be based in part on introduced occurrences.