- Species Diversity
TIP: Before you begin be sure to log into your IFWIS account to obtain all the functionality assigned to you.
The Idaho Species Catalog menubar provides three options. This blog describes the functionality of the Idaho Species Catalog (ISC) 'STATUS LISTS' option at https://fishandgame.idaho.gov/species/taxa . For an introduction to the ISC please view our background blog.
Status Lists allow the user to query and download Conservation Statuses for a species or a taxonomic group. Attributes included are United State Endangered Species Act, Species of Greatest Conservation Need, BLM Type, USFS sensitive species, and IDAPA classification.
Click "FILTER" after you have specified one or all of the criteria under Keyword, Category, and Idaho Classification. Be sure to "RESET" the filter before you begin a new filter.
Downloading the Status List is easy. Once you have filtered your species of interest simply click the orange .csv button at the bottom of the page. The .csv can then be saved and opened in MS Excel. To download a Status List for the entire state simply make sure there is no filter set and download the .csv.
Posted by idfg-aschmidt at 08/15/2013 in
I recently encountered an issue where I tried to determine which records for any of 7 out of 12 Forest Service National Forests contained data for a query. Region 4 of the USFS has 12 NFs, of which 7 have boundaries within Idaho. For a list of sensitive species occurring in the region, I wanted to determine which species occurred in 1 or more of the forests that occur in Idaho. Currently, R4 indicates 231 sensitive species, but only 56 occur in forests within Idaho.
With my original query, I simply put `Is Not Null' in the `or:' row of the query design view, but this resulted in no records being returned. It appeared that something needed to be in the `Criteria:' row of query design, but when I did this, then put `Is Not Null' in the `or' row going straight across for each field desired, only records meeting the `Criteria:' rule were returned. Example of failed query shown below:
It ended up that the query rules needed to be "tiered" or staggered in the query design view, with each OR statement completely encapsulated with parenthesis, resulting in the following GOOD SQL query:
SELECT [Tbl_USFS-R4--July_2011].ID, [Tbl_USFS-R4--July_2011].Type, [Tbl_USFS-R4--July_2011].Species, [Tbl_USFS-R4--July_2011].Common, [Tbl_USFS-R4--July_2011].Boise_NF, [Tbl_USFS-R4--July_2011].Caribou_NF, [Tbl_USFS-R4--July_2011].Challis_NF, [Tbl_USFS-R4--July_2011].Payette_NF, [Tbl_USFS-R4--July_2011].Salmon_NF, [Tbl_USFS-R4--July_2011].Sawtooth_NF, [Tbl_USFS-R4--July_2011].Targhee_NF
WHERE ((([Tbl_USFS-R4--July_2011].Boise_NF) Is Not Null)) OR ((([Tbl_USFS-R4--July_2011].Caribou_NF) Is Not Null)) OR ((([Tbl_USFS-R4--July_2011].Challis_NF) Is Not Null)) OR ((([Tbl_USFS-R4--July_2011].Payette_NF) Is Not Null)) OR ((([Tbl_USFS-R4--July_2011].Salmon_NF) Is Not Null)) OR ((([Tbl_USFS-R4--July_2011].Sawtooth_NF) Is Not Null)) OR ((([Tbl_USFS-R4--July_2011].Targhee_NF) Is Not Null));
Posted by idfg-jstrickland at 01/30/2013 in
Looking for a town, city or place outside of Idaho? You can use this website to query geographic features for all of the United States and its territories at http://geonames.usgs.gov/pls/gnispublic. Of course you can use the IDFG GeoTools LayerFetcher to zoom to locations in Idaho in ArcGIS.
Posted by idfg-ebrown at 04/07/2010 in
What is this?
We use the IFWIS Blog to keep our staff, cooperators and the public updated on what we are working on, what's new and share tips about using our software and website.
The content of the IFWIS Blog is often highly technical, but we try our best to keep our posts accessible and jargon-free. When this is not possible, we'll link to other resources online to provide background. Thanks for reading and please follow our blog for updates.
- IFWIS RSS Feed
- Daily Email Digest (All Public Content)
- Or follow just one of the many topic-specific tag feeds or pages below.