Project

General

Profile

Bug #2936 » reaches_email_thread.txt

Michael Lee, 09/05/2007 03:47 PM

 
1
Steve writes: 
2

    
3
	Hello everyone,
4

    
5
	Recent discussions with regulatory agencies and a few internal
6
	realizations regarding how EEP will deal with problematic projects has
7
	prompted Greg Melia to begin arranging the stream morphology data
8
	according to Reaches, which are basically sections of stream(s) within
9
	restoration projects that are relatively similar in terms of: watershed
10
	area, profile, restoration design approach, etc.  The driver behind this
11
	decision is the fact that we may start receiving mitigation credit for
12
	some reaches within a restoration project while other reaches are
13
	stabilized and abandoned, at least temporarily, from the standpoint of
14
	claiming mitigation credit.  This creates a need for us to be able to
15
	assign Reaches to each of our veg plots (stream restoration only) so
16
	they can be queried by project/reach.
17

    
18
	Please consider the affects this has on the Protocol, Datasheets and
19
	Database.  For the protocol, I will coordinate with Greg and provide
20
	text that will basically direct readers to the appropriate EEP document
21
	for a more complete explanation of how Reaches are defined, and to the
22
	appropriate required drawing that will depict the location of each
23
	Reach.  Of course, Mike should begin creating room on the Datasheets and
24
	begin adding this feature to the Database.  To keep things relatively
25
	simple, consultants will not be expected to determine the reach of each
26
	plot during this year's monitoring effort. The can be applied to VBD for
27
	new projects once everything is updated, but will not be required for
28
	annual monitoring until 2008.  In other words, there is no need to
29
	rush.  Regardless, if this proposed change is more complicated than I
30
	suspect, please let me know promptly.
31

    
32
	In the mean time, Greg and I will also look at a few project examples to
33
	determine if the current required number of plots is adequate for this
34
	new stratified/representative sampling approach.  We may find that an
35
	increase in the number of required plots is necessary in order to
36
	capture vegetation data from each reach in addition to capturing a
37
	representative sample of the entire project.
38

    
39
	More later...
40

    
41
	Thanks,
42
	Steve
43
	
44
Bob replies:
45
	Hi Steve et al.,
46

    
47
	My sense from reading your document is that "reach" will be an attribute
48
	of a plot that is subject to change.  You may, for example, wish to shift
49
	a plot from one reach to another as you figure out how much of a project
50
	you can claim credit for under various assignment scenarios.  Thus, we do
51
	not want to make reach another component of the the current identifier
52
	triplet of project-team-plot.
53

    
54
	Do we want to track the changing assignment of plots to reaches, and who
55
	do we want to have access to these data?  Also, so we want to keep track
56
	of previous assignments and the start and stop dates of those assignments,
57
	or just the current assignment.  We could add a REACH table to our
58
	database that contains the following variables
59
	[projectID/plotID/reachIdentifier/startDate/endDate].  There is nothing
60
	here that precludes a plot belonging to more than one reach at a time,
61
	though we could have that business rule.
62

    
63
	There is also the questions of whether we want EEP to be able to
64
	frequently change assignment of plots to reaches within our database, and
65
	if so how that should be accomplished.  I suppose a web interface could be
66
	built, but that would be a hassle for us, though perhaps less of a hassle
67
	than getting a steady stream of emails asking for changes and then needing
68
	to generate fresh reports.
69

    
70
	I am currently inclined to follow up on our plan to send EEP a copy of
71
	the populated database annually by providing a component tool for EEP to
72
	go into the database and fiddle with assignments to reaches, after which
73
	they could rerun the summary tables as by reach as needed.  The two new
74
	things we need to add here are a modest interface for adding and editing
75
	assignment of plots to reaches, and the ability to generate reports by
76
	reach rather than just project or plot.  We would also need to have the
77
	database be able to update new versions of the database with extant reach
78
	assignments.  With this plan all information on reaches stays within EEP
79
	and never migrates to our shop.
80

    
81
	Let me know if you think this is relatively close to the mark.
82

    
83
	Bob
84
	
85
Steve again:
86
	Hello again,
87

    
88
	I regret not being more clear about reaches in my first email.  The
89
	reaches are defined during the design process and do not change.  The
90
	only scenario I can think of in which EEP would want to request a change
91
	is if an error regarding the reach assignment were discovered.  Please
92
	respond and let me know how this affects your recommendation.
93

    
94
	Also, the word-smithing is appreciated.
95

    
96
	Thanks,
97
	Steve
98
Tom:
99
	Hello,
100
	
101
	Having read this as well as Steve's clarification, it seems to me that all
102
	that is required here is an additional field in the location area of the
103
	data forms, and also the corresponding field in the database, to
104
	accommodate the assignment of a reach to each (new) plot.  Steve, do you
105
	have an example of the coding or nomenclature system used to designate a
106
	reach?
107
	
108
	Cheers, Tom
109
Bob:	
110
	If reaches are stable, then life is easy.  However, I can easily imagine
111
	EEP moving toward a plan where reaches adjust to reflect restoration
112
	success.  I would be interested in Greg's reaction to my email below.
113

    
114
	Bob
115
Steve:
116
	I know what you mean.  In fact, I recall a meeting approximately 2 years
117
	ago in which a proposal to track monitoring data by reach was made, and
118
	then declared to be "impossible" based on the number of reaches that
119
	will eventually be scattered throughout the state....
120
	
121
	Regardless, I spoke with Greg and he assured me that reaches will not
122
	change.  If a portion of a reach fails, we have the ability to subtract
123
	the linear footage of the failure, instead of readjusting the reach
124
	limits.  Tracking the success and failure of a project according to
125
	reach simply allows us to focus our data in areas that are expected to
126
	behave differently over time.
127
	
128
	The terminology and document references needed for the protocol will be
129
	provided by Greg, once all the related documents are finalized.  Given
130
	our current workload and varying priorities, that may take a couple months.
131
Bob:
132
	This is reassuring in that it makes all of our lives much easier.
133
Michael:
134
	Hi all,
135
	
136
	I am catching back up on emails.  I'll summarize where I think we are here:
137
	1) reaches are assigned to plots (or vice-versa) in the design phase
138
	2) plots don't change the reach(es) they are assigned to
139
	3) can a plot be assigned to more than one reach??
140
	4) Greg will be sending some information on what a reach is, exactly,
141
	and how we might label them with a name
142
	5) this isn't urgent at present.
143
	
144
	I'm still not real clear on what a reach is.  It seems to be a
145
	categorization of plot based on location and environmental variables.
146
	I'm not sure if a project will be mostly within one reach, or if it
147
	will have a few reaches, or if most every plot will be in its own
148
	reach within a project.
149
	
150
	--michael
(1-1/2)