Victor Levesque U.S. Geological Survey - PowerPoint Presentation

Slide1

Victor LevesqueU.S. Geological SurveyFlorida Water Science CenterTampa, Florida

Documenting

Regression Analysis

for

Index Velocity RatingsSlide2

OverviewData required for the rating(Stage-area and Index velocity)What to collect and what to keepAssembling and Documenting the dataExamplesRating documentation(Stage-area and Index velocity)Assembling and Documenting the dataWhat information is neededExamplesSlide3

Two RatingsStage-to-areaIndex-to-mean velocityQ = VASlide4

Stage-to-Area RatingCollect cross-section survey andwater level dataAssemble dataDocument data and resultsCreate and document a stage-area ratingSlide5

Data CollectionStandard cross-sectionClearly mark cross-section in the field and document in the ratingInclude a site sketchInclude distancesDocument survey methodIdentify water level data and datum

Index

Sensor

Standard cross-section

Flow direction

Oak tree on left bank. Orange X on trunk.

20 feet upstream

150 feet

Large rock with orange XSlide6

Important items to rememberCross section must be referenced to stageSurvey past the maximum expected stageYou should routinely check for channel changes Every year for first three yearsIf there is a departure in the index velocity ratingAfter a high flow eventUse the same cross-section for resurveyData CollectionSlide7

Assemble the DataData can be input to a spreadsheetDescribe how and where data were collectedLabel all columnsInclude times and time datumInclude water level data measured during the time of the surveyInclude a site sketchSlide8
Slide9

Stage-Area Rating - Poor ExampleSlide10

Limited DocumentationSlide11

Stage-Area WorkbookSlide12

Where, when, who

How data were collected and what are the data

DetailsSlide13

Plot the Cross-SectionSlide14

Cross-section corrected to WS elevationSlide15

Input Data to AreaComp AreaComp USGS program for the purpose of attaining cross sectional area Can use data tables or WinRiver ASCII files Provides output for stage and areahttp://hydroacoustics.usgs.gov/indexvelocity/software.shtmlSlide16

Generate a Stage-Area RatingSave all output from AreaCompInclude data in Rating WorkbookSlide17

Stage-Area Rating final worksheetSlide18

Documenting the Stage-Area RatingHow were data collected and transformed?What data were used to create the rating?Documentation to describe how the rating was developedLeave no doubt as to how, what, and why the rating was developedSlide19

Index Velocity Rating Collect calibration dataDischargeStageIndex Velocity (RangeAvg X,Y, Z, Multi-Cell X,Y,Z)Assemble dataDocument dataPerform Regression AnalysisIdentify and Document Selected RatingSlide20

Collect Calibration DataSynchronize all data sensor timesConfigure index velocity and stage sensor data collection intervalSave and document all dataSlide21

Assemble the Calibration DataDischarge measurementsDates, start and end times, and total dischargeStageDates, times and stageIndex VelocityDates and timesRangeAvg X,Y,Z, Multi-Cell X,Y,Z, depthIndex Velocity ConfigurationSlide22

Rating Analysis DocumentationLabel all data columnsInclude information about the dataRearrange the data columns as necessarySynchronize and Synthesize DataCreate an organized data tablePerform regression analysisSelect appropriate ratingSlide23

Discharge Data WorksheetSlide24

Stage Data WorksheetFree Excel Interpolation Add-In available:http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htmSlide25

Index Velocity Data WorksheetSlide26

Synchronize and Synthesize DataSlide27

Synchronize and Synthesize DataSlide28

Synchronization and SynthesisSlide29

Create an Organized Data TableSlide30

Add VariablesSlide31

Exploratory Data AnalysisPlot with Measured-Mean Velocity (y-axis)Index velocity (X, Y, Z, multi-cell X,Y,Z)StageSlide32

Index VelocitySlide33

StageSlide34

This is NOT Regression AnalysisSlide35

Inadequate DocumentationSlide36

Index-to-Mean Velocity RegressionAll DataSlide37

Regression Analysis continuedSlide38

Select Appropriate RatingSlide39

Check the RatingSlide40

Regression AnalysisSlide41

Rating SummarySlide42

SummaryCollect and document dataCarefully assemble and identify dataMaintain good notesPerform thorough analysisClearly identify the final rating and provide information for the selectionLeave no doubt as to how, what, and why the rating was developedSlide43

Questions?