Default WHERE clause for BIEN range modeling, biendata.org and RBIEN
- Wrap the entire clause in parentheses if combining with additional WHERE criteria
- "scrubbed_species_binomial IS NOT NULL" can be omitted if filtering by one or more species
Current version (5 March 2021)
WHERE scrubbed_species_binomial IS NOT NULL
AND observation_type IN ('plot','specimen','literature','checklist')
AND is_geovalid = 1
AND (georef_protocol is NULL OR georef_protocol<>'county centroid')
AND (is_centroid IS NULL OR is_centroid=0)
AND higher_plant_group IN ('bryophytes', 'ferns and allies','flowering plants','gymnosperms (conifers)', 'gymnosperms (non-conifer)')
AND (is_introduced=0 OR is_introduced IS NULL)
AND is_location_cultivated IS NULL
AND (is_cultivated_observation = 0 OR is_cultivated_observation IS NULL)