How can I easily test the RiverPro templates for impact statements and crest history?
• You may have to adjust the rows in the flood and floodstmt tables to match the new flood stage. Here is a query that doe the trick, courtesy of Mike Callahan (LMK): update crest set stage = stage – [offset] where lid = ‘VTECn’; update floodstmt set stage = stage – [offset] where lid = ‘VTECn’; Where [offset] is the difference between the old and new flood stage. For example: copy DEPI3 to VTEC3. However DEPI3’s flood stage was 20 feet and VTEC3 is 8 feet. So subtract 12 feet from all of VTEC3 flood.stage and floodstmt.stage columns.
