Document ID: EPA-R10-OW-2022-0418-0088
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2022-05-26T04:00Z

Pebble Limited Partnership
               HDR "MesoHabitat" Database - Data Dictionary

Table of Contents
	Database Description	
	Data Table Descriptions
	Figure 1  Field Descriptions

Database Description
Meso habitat survey locations, habitat types, bed width measurements, and habitat features from meso habitat surveys in the NFK, SFK, and UTC in 2007.

Location data from these tables are not found in the GLR, just in the data tables.  R2 did QC3 GIS analysis on the latitude / longitude coordinates, so they are labeled as QC3.  Future QC3 revisions to location data can be made to this database.

The database consists of the following data tables (listed in alphabetical order): 
   MesoHabitat
   OffChannelMesoFeatures

Data Table Descriptions (listed as ordered above)

Note on data names:  Data attribute names are listed as TableName.AttributeName.  Sometimes a database name is also needed, and will be listed first.  Example:  GLR.tblGeoLoc_Fish_HDR.GeoLocName.

MesoHabitat
   PK = LocID
   MesoHabitat observations and measurements.  Location data are not in the GLR, so are provided within this data table.
   FK to GLR:  none
   
OffChannelMesoFeatures
   PK = Lat_WGS84 + Long_WGS84
   Observations recorded during the 2007 MesoHabitat study, only for the NFK and SFK.  These are stream features that are not located on the mainstem channel.  Location data are included within this data table.
   FK to GLR:  none

Figure 1.  Field Descriptions
Fields are listed for each table separately, and in the order as within the table.  

 (see "EIS HDRMesoHabitat Dict Fields v20180227.xls")