MONTANA RIVERS INFORMATION SYSTEM 

 Rivers Report 



scroll through the help screen. When you are finished viewing the help screens 

 press the Exit key to return to the menu. 



In this example, you will search for information on a specific wildlife species, 

 so select 'Wildlife Species' to move to the next screen (Figure 27). 



Montana Rivers Information System 

 Rivers Report 



UILDSPEC File Filter 



10/23/1989 



Put quotes around character fields. Place periods before and after 

 .NOT., .AND. or .OR. Species list is in the user's manual. 

 UPPER(SPECIES) is needed for all species queries. 



Example: To search for all units with abundant elk: 



UPPER(SPECIES) = 'ELK' .and. GAME_VAL = 3 



Figure 27. Enter WILDSPEC File Filter 



This screen presents you with an area where you will type in your search 

 expressions. Several things are critical here. First, you must know the precise 

 name of the field(s) to use and the type of field you are working with, that is, 

 whether it is a character, numeric, date, or logical field. This information is 

 available in Appendix B. Second, you must type the expression in a way that 

 conforms to dBase III syntax. This screen (Figure 27) and other similar screens 

 provide you with explanations and examples of typical expressions. 



For this exercise, we want to locate areas that contain 'core habitat' for 

 grizzly bears. Specifically, we will search for records with the words 'grizzly 

 bear' in the species field and the parameter code indicating core habitat in the 

 TE_VAL field. The Wildlife Database Structure in Appendix B provides you with 

 the codes used in the TE_VAL field and their meaning. From this page we find 

 that the core habitat areas are indicated by the number 2. Therefore, following 

 the example expression on the screen, the search expression will look like this: 



UPPER(SPECIES) = "GRIZZLY BEAR" .AND. TE VAL = 2 



Page 27 



