APPENDIX A 

 FILE STRUCTURES 



A.l. Data Base Files: 



Table A-1 lists and briefly describes the database files contained in 

 the Montana Rivers Study data base. 



Table A-1: DATA BASE FILES 



1. DESCRIP.DBF This is the MASTER data base containing a summary 



of all information contained in the other data 

 bases. Every water code for which there is infor- 

 mation is represented by a record in this data 

 base, with the name of the stream, various geo- 

 graphical descriptors, and the value class assign- 

 ments for each resource category. This file is the 

 authority for names associated with water codes and 

 for the geographical descriptors of the streams. 



2. FISH. DBF This is the fisheries data base. It is a subset of 



the much larger DFWP interagency stream data base. 

 Each water code may have more than one reach code 

 assigned to it, so the number of records in this 

 data base is larger than the number of water codes. 



3. REC.DBF This is the recreation data base. Each river may 



have more than one reach code assigned to it, so 

 the number of records contained in this data base 

 is larger than the number of water codes rated. 



4. GEO. DBF This is the geological features data base. Many 



individual sites may correspond to a single water 

 code; each site is given a unique "reach" number 

 although the sites are not really "reaches". 



5. NAT. DBF This is the natural features data base (including 



botanical and specially managed biological sites). 

 Its structure is identical to that of GEO. DBF. 



6. FOOR.DBF This is the cultural features data base. Each river 



may have more than one reach code assigned to it, 

 so the number of records contained in this database 

 is larger than the number of water codes rated. 



7. WILDLIFE. DBF This is the wildlife data base. It is a subset of 



a much larger data base managed by DFWP. This file 

 contains information for each of the 354(??) 

 wildlife areas into which the state has been 

 divided by DFWP. Each of these areas contains many 

 streams corresponding to many water codes. The 

 wildlife areas and the water codes are related by 

 the following file, AREACODE.DBF. 



A-1 



