StreamNet

MitMonType Table

Many to one relationship with the MitLocation table, via WLID and ProjID.

Field Name Field Description Data Type Field Size*

ProjID StreamNet project ID. Cross reference to MitProject table int 4

WLID ID code unique to each work type by location, within a project. Cross reference to MitLocation table tinyint 1

MonitoringID Classification of general monitoring type tinyint 1

Method Primary methods used for monitoring activity. text 16

Control Does monitoring include a control stream or watershed tinyint 1

DataAvail Are monitoring data available for evaluating the effectiveness of the project? (Not necessarily currently in StreamNet tinyint 1

MonitoringObj Objectives of the monitoring effort text 16

Comments Additional information or comments. text 16

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.

Field Name	Field Description	Data Type	Field Size*
ProjID	StreamNet project ID. Cross reference to MitProject table	int	4
WLID	ID code unique to each work type by location, within a project. Cross reference to MitLocation table	tinyint	1
MonitoringID	Classification of general monitoring type	tinyint	1
Method	Primary methods used for monitoring activity.	text	16
Control	Does monitoring include a control stream or watershed	tinyint	1
DataAvail	Are monitoring data available for evaluating the effectiveness of the project? (Not necessarily currently in StreamNet	tinyint	1
MonitoringObj	Objectives of the monitoring effort	text	16
Comments	Additional information or comments.	text	16

MitMonType Table

Revised Wednesday September 28 2005