H-VTEC/RiverPro Frequently Asked Questions
Last Updated 2/6/07
National Weather Service
Office of Climate, Water, and Weather Services
Questions: Shannon.White@noaa.gov
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. These statements did the trick:
update crest set stage = stage - 12 where lid = 'VTEC3';
update floodstmt set stage = stage
- 12 where lid = 'VTEC3';
rpf_endtime_shifthrs : 24