{"id":3633,"date":"2021-03-05T13:03:13","date_gmt":"2021-03-05T21:03:13","guid":{"rendered":"https:\/\/bien.nceas.ucsb.edu\/bien\/?page_id=3633"},"modified":"2024-10-21T07:50:03","modified_gmt":"2024-10-21T15:50:03","slug":"bien-4-2-default-where-clause","status":"publish","type":"page","link":"https:\/\/bien.nceas.ucsb.edu\/bien\/biendata\/bien-4-2-default-where-clause\/","title":{"rendered":"BIEN 4.2 default WHERE clause"},"content":{"rendered":"<h2>Default SQL filters for BIEN range modeling, biendata.org and RBIEN<\/h2>\n<h3>Current version (as of 5 March 2021)<\/h3>\n<p>WHERE scrubbed_species_binomial IS NOT NULL<br \/>\nAND higher_plant_group IN ('bryophytes', 'ferns and allies','flowering plants','gymnosperms (conifers)', 'gymnosperms (non-conifer)')<br \/>\nAND is_invalid_latlong=0<br \/>\nAND is_geovalid = 1<br \/>\nAND (georef_protocol is NULL OR georef_protocol&lt;&gt;'county_centroid')<br \/>\nAND (is_centroid IS NULL OR is_centroid=0)<br \/>\nAND is_location_cultivated IS NULL<br \/>\nAND (is_cultivated_observation = 0 OR is_cultivated_observation IS NULL)<br \/>\nAND observation_type IN ('plot','specimen','literature','checklist')<br \/>\nAND ( EXTRACT(YEAR FROM event_date)&gt;=1950 OR event_date IS NULL )<br \/>\nAND is_introduced=0<\/p>\n<h3>Usage notes<\/h3>\n<ul>\n<li>Wrap the entire clause in parentheses if combining with additional WHERE criteria<\/li>\n<li>Condition \"scrubbed_species_binomial IS NOT NULL\" can be omitted if filtering by one or more species<\/li>\n<li>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.<\/li>\n<\/ul>\n<h3><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>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&lt;&gt;'county_centroid') AND (is_centroid IS NULL OR is_centroid=0) AND is_location_cultivated IS NULL [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":134,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-3633","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/3633"}],"collection":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/comments?post=3633"}],"version-history":[{"count":3,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/3633\/revisions"}],"predecessor-version":[{"id":3785,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/3633\/revisions\/3785"}],"up":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/134"}],"wp:attachment":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/media?parent=3633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}