RESULTS OF: SELECT d, event_type, haz_class, fcst_type, p18, p3, p15, pa, pb, sd_in, swe, t_avg, t_max, t_max_perc, ds0sp, hdd32_18, d0, d1, d2, d3, d4, d5, hs_dry, notes FROM coop_wx WHERE site_id = 456898 AND event_type IN ('DF','OF') ORDER BY d ASC

DATE TYPE HAZ_CLASS FCST_TYPE P18 P3 P15 PA PB SD_IN SWE T_AVG T_MAX T_MAX_PERC DS0SP HDD32_18 D0 D1 D2 D3 D4 D5 HS_DRY NOTES
Oct 16, 1926DFHWET14.174.729.45TT00.0045500.55797105000000-999.9
Oct 14, 1932DFHWET8.705.503.20TT00.0046490.52495526000000-999.9ALTERED LOW AND AVG TEMPERATURE, WAS SET TO -999. Used Longmire data to help: Min: 45, Max: 52, Range: 7.
Oct 25, 1934DFHWET9.945.204.74TT81.3337400.278106242000000-999.9
Oct 2, 1947DFHWET8.195.852.34TT00.0044480.30283426000000-999.9
Oct 25, 1955DFHWET11.705.516.19TT00.0039480.579106287000000-999.9
Aug 23, 1961DFHDRY0.420.010.41FF00.0061730.8594359853415160.0
Aug 29, 1967OFHDRY0.000.000.00FF00.0069750.9094960953515165.0
Aug 31, 1967DFHDRY0.000.000.00FF00.0072770.9595161853515165.0
Sep 15, 1967DFHDRY2.100.002.10FF00.0055700.8556646853315155.0
Jun 2, 1968OFLDRY0.480.030.45FF5423.3343490.400-392832121122.5High SWE & SD, this would be hard to predict...
Jul 4, 1970OFMDRY0.610.060.55FF00.0064760.947-742451315145.0
Aug 21, 1970DFLDRY0.120.000.12FF00.0055650.6304146833315222.5Could change this to M if we change D5 to >=65.
Aug 10, 1971DFHDRY0.000.000.00FF00.0072780.9113059652415155.0
Jul 14, 1972OFLDRY2.270.901.37FF9142.0647520.18833981223127.5Super high SWE & SD, this would be hard to predict...
Sep 15, 1975DFMDRY1.920.001.92FF00.0062690.8356639243215145.0
Jul 3, 1976OFLDRY3.720.483.24TF9242.5650570.436-83112122125.0Super high SWE & SD, this would be hard to predict...
Aug 1, 1979DFMDRY0.020.000.02FF00.0057690.6712151032415145.0
Sep 21, 1980OFVHDRY2.951.921.03TF00.0032340.0487231614255287.5
Aug 15, 1981DFHDRY0.210.000.21FF00.0064720.7873552443415155.0
Jul 18, 1985DFLDRY0.010.000.01FF00.0057670.651751532415222.5Could change this to M if we change D5 >=65
Sep 4, 1986DFHDRY0.640.000.64FF00.0061700.7835555243415155.0
Oct 26, 1986DFVHDRY2.362.350.01FF00.0046500.716107388452552137.5
Jun 29, 1987DFMDRY0.690.000.69FF00.0068760.945-1236951215140.0
Aug 9, 1987DFMHDRY0.370.000.37FF00.0072830.9662944952315150.0
Aug 28, 1987DFMDRY1.430.001.43FF00.0059710.8164835743215145.0
Aug 31, 1987DFHDRY0.920.000.92FF00.0067790.9745140053315155.0
Sep 23, 1987DFHDRY2.070.002.07FF00.0068810.9747444554315160.0
Jul 14, 1988DFLDRY1.390.331.06FF00.0040460.072333812225225.0Pretty cold day... this would be hard to predict
Jul 26, 1988DFMHDRY0.340.000.34FF00.0070830.9761547452315150.0
Oct 16, 1988DFHWET7.317.290.02TT00.0048580.81297550000000-999.9
Oct 22, 1988DFHWET9.550.329.23TT00.0042550.798103431000000-999.9
Sep 23, 1989DFHDRY0.060.000.06FF00.0063690.8447441944315155.0
Nov 9, 1989DFHWET12.796.326.47TT81.5234420.634121122000000-999.9
Aug 4, 1990DFMHDRY0.800.000.80FF00.0061720.8042451742415150.0
Oct 3, 1990DFVHDRY3.082.540.54TF00.0034390.15084494143552100.0
Nov 5, 1991DFHWET10.604.785.82TT122.2640440.62511738000000-999.9
Sep 8, 1992DFVHDRY2.231.540.69FF00.0041490.1495939913255275.0
Sep 20, 1992DFMHDRY2.760.142.62FF00.0049610.7157126644225250.0
Aug 9, 1996DFHDRY1.060.001.06FF00.00-999780.9072951852415155.0
Aug 14, 2001DFMHDRY0.330.000.33FF00.0068750.8313445043315150.0
Oct 7, 2003DFVHDRY1.141.130.01FF00.0046560.6368816234145280.0
Oct 20, 2003DFHWET11.531.2210.31TT10.1545500.636101154000000-999.9
Sep 29, 2005DFHDRY1.100.900.20FF00.0050600.6478026334235267.5
Nov 6, 2006DFHWET23.1915.697.50TT00.0041490.842118136000000-999.9
Oct 27, 2012OFLWET12.401.0911.31TT173.0530320.141108204000000-999.9Dry Creek Debris flow... May remove from this list.
Aug 13, 2015DFMHDRY0.130.000.13FF00.0067780.9183349452315150.0
Sep 12, 2015DFMHWET4.200.004.20TF00.0069760.94363303000000-999.9
Oct 10, 2015DFVHDRY2.251.480.77FF00.0051550.6969136934245290.0Dry Creek
Oct 15, 2016DFHWET14.496.028.47TT00.0033360.13496193000000-999.9