1 / 20

Viewing, Managing and Editing Realtime Data

Viewing, Managing and Editing Realtime Data. 1971-2000 normals. User entered values. Original values from database. When you refresh data If no edited data exists The latest value from database becomes the “original” If an edit exists If the new database value is

rrubinstein
Download Presentation

Viewing, Managing and Editing Realtime Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Viewing, Managingand EditingRealtime Data

  2. 1971-2000 normals User entered values Original values from database

  3. When you refresh data If no edited data exists The latest value from database becomes the “original” If an edit exists If the new database value is the same as “original” then edit is kept If an edit exists If the new database value is NOT the same as “original” then the program asks what to do 1971-2000 normals User entered values Original values from database

  4. The main interface could be used to estimate missing values Anything can be a predictor/predictand

  5. However, the forecast vs observed scatterplot is only a general summary of the results, not that useful if you want to know the forecast equation itself.

  6. Here, the cross correlation graph (to the right of main interface) helps East Rim Divide (predictor 1) SWE (inches) Given East Rim Divide, what should Gros Ventre Summit (Final Predictand) be?

  7. Example: January precipitation from Loomis Park is missing. Elevation 13800’ 10350’ 8650’ 7000’ Streamgage 5200’

  8. Load nearby stations as predictors Set target months Inspect predictor quality Is there a wide spread in the individual station predictions? The closest site has the worst correlation? Perhaps there’s an outlier?

  9. East Rim Divide versus Loomis Park January Precipitation An outlier!

  10. Gros Ventre Summit versus Loomis Park January Precipitation 1985 isn’t an outlier here so maybe East Rim is bad

  11. Our options FIX THE DATABASE!!!! Exclude East Rim from analysis Manually edit East Rim’s station sheet data

  12. Our options FIX THE DATABASE!!!! Exclude East Rim from analysis Manually edit East Rim’s station sheet data Limit the years of the analysis If other predictors are missing 1985, require serial completeness (under “Advanced Regression Options”)

  13. With east rim divide fixed the scatter plot looks ok… The prediction is around 4.3” +/- 0.5”

  14. Enter 4.3” (or your value) here. Actual value 4.2”… Not bad!

  15. When running static equations, viper will alert you to missing data

  16. Options: “Smart Skip” to not evaluate any equation that needs this data “Use Averages” uses 1971-2000 normal in place of real data Enter a “new value” Stored temporarily or permanently based on this checkbox

  17. Into the station data sheet If you need to edit some data, it might also be to the right 

  18. External CSV files have the same format as the station data sheet

  19. Sometimes the 1971-2000 normal stored in the database is wrong. Your options…. 1: FIX THE DATABASE!!!!!! 2: Go to the “averages” worksheet and manually enter your values

More Related