tamarack Posted December 5, 2019 Share Posted December 5, 2019 5 hours ago, MetHerb said: FWIW, I keep my weather record 7A to 7A so snowfall I what I have listed for 12/2 for example would have been snow that fell between 12/1 at 7A and 12/2 at 7A. So, I have an entry of 1.5" on 12/4 that fell mostly on the 3rd but after 7A so my storm total was 15", not 13.5". Sorry if I'm confusing the record. My season total is right it's just the dates might be slightly different from others. My 7A-7A measurements are for cocorahs, while I've been doing obs at 9P since moving to Fort Kent on 1/1/76 and wish to keep that data as uncorrupted as feasible. For the snow table, I pick the snowiest and/or most impactful date of a multi-day event to add to my record. That retains the depth of entire storms. Last April is illustrative: For my 9P obs on 4/8 I recorded 3.5" with 0.2" falling soon afterwards. Then came 3" in 2 hours the evening of the 9th with another 0.5" coming after 9P. My daily records show 3.5" for the 8th, 3.2" for the 9th, 0.5" for the 10th, while my entries into the snow table show storm #1 at 3.7", labeled as on the 8th, and storm #2's 3.5" called the 9th. May seem more complex than necessary but it works for me. Edit: Just read Kevin's "combining" post (after posting the above, of course.) Since that's how my entries are made, such combining should not be needed. Link to comment Share on other sites More sharing options...
dendrite Posted December 6, 2019 Share Posted December 6, 2019 9 hours ago, Kevin W said: Understood. It's not a big deal, really. The storm page was just something I thought I would add to give a quick, and neat indication of storm totals. Like you said, your season total is correct, and every entry in the All Records page remains as well. You're not confusing anything. Would it be a problem adding a few more years so we can add totals from seasons prior to whatever you have there (2010-11 I think?). My first season with data here was 06-07. Link to comment Share on other sites More sharing options...
gotsnow Posted December 6, 2019 Share Posted December 6, 2019 Hey Kevin, thanks for doing this...sign me up. Link to comment Share on other sites More sharing options...
Kevin W Posted December 6, 2019 Author Share Posted December 6, 2019 6 hours ago, dendrite said: Would it be a problem adding a few more years so we can add totals from seasons prior to whatever you have there (2010-11 I think?). My first season with data here was 06-07. Not a problem at all. I have data going back to 2007-08. I'll work on this a little later today and let you know when I'm done. Link to comment Share on other sites More sharing options...
Kevin W Posted December 6, 2019 Author Share Posted December 6, 2019 4 hours ago, gotsnow said: Hey Kevin, thanks for doing this...sign me up. All set. See PM Link to comment Share on other sites More sharing options...
40/70 Benchmark Posted December 6, 2019 Share Posted December 6, 2019 7 hours ago, dendrite said: Would it be a problem adding a few more years so we can add totals from seasons prior to whatever you have there (2010-11 I think?). My first season with data here was 06-07. 06-07 was my first, too. Link to comment Share on other sites More sharing options...
Kevin W Posted December 6, 2019 Author Share Posted December 6, 2019 You can now add events or totals from 2006-07 onward. I will add the season pages for those years, and add my data, when I get to work. (I have events from 2007-08 until present) Also, I know there are some with event data that goes way back. If you want it added, but don't want to enter all the records, if you send me a spreadsheet in the following format, I can get it in quickly: 1 Link to comment Share on other sites More sharing options...
codfishsnowman Posted December 6, 2019 Share Posted December 6, 2019 20 inches December 1st to 3rd Link to comment Share on other sites More sharing options...
dendrite Posted December 6, 2019 Share Posted December 6, 2019 Sweet. Thanks. Link to comment Share on other sites More sharing options...
40/70 Benchmark Posted December 7, 2019 Share Posted December 7, 2019 +1"...done. 20" Link to comment Share on other sites More sharing options...
CoastalWx Posted December 7, 2019 Share Posted December 7, 2019 On 12/3/2019 at 7:16 PM, CoastalWx said: + 8.6. 8.7 season total. + 0.2. 8.9”. Link to comment Share on other sites More sharing options...
40/70 Benchmark Posted December 7, 2019 Share Posted December 7, 2019 5 minutes ago, CoastalWx said: + 0.2. 8.9”. I'm almost halfway to last year's total lol Link to comment Share on other sites More sharing options...
NorEastermass128 Posted December 7, 2019 Share Posted December 7, 2019 +1” 6” YTD Link to comment Share on other sites More sharing options...
Lava Rock Posted December 7, 2019 Share Posted December 7, 2019 not to sound picky, but can the ranking for the snow total table be added? thanks,. Link to comment Share on other sites More sharing options...
Kevin W Posted December 7, 2019 Author Share Posted December 7, 2019 19 minutes ago, Lava Rock said: not to sound picky, but can the ranking for the snow total table be added? thanks,. I thought of that, and I'm sure it can be done, but it's not something I know how to do off the top of my head. I would love to know how, so I'm going to look into it. Link to comment Share on other sites More sharing options...
Kevin W Posted December 7, 2019 Author Share Posted December 7, 2019 If there are any SQL wizards here, the following is the query that gets the result for the home page table: SELECT user_names.user_name,city.city,state.state,SUM(events_full.amount) AS total FROM user_names,city,state,events_full WHERE user_names.user_id=events_full.user_id AND city.city_id=events_full.city_id AND state.state_id=events_full.state_id AND events_full.season_id=13 AND amount > 0 Group By user_names.user_name Link to comment Share on other sites More sharing options...
HIPPYVALLEY Posted December 7, 2019 Share Posted December 7, 2019 Yesterdays snow put me over 20" for the week. Link to comment Share on other sites More sharing options...
HoarfrostHubb Posted December 11, 2019 Share Posted December 11, 2019 32.3” season to date. Dec 11. Decemba to rememba 1 Link to comment Share on other sites More sharing options...
Damage In Tolland Posted December 11, 2019 Share Posted December 11, 2019 +4.6” 16.6” YTD Link to comment Share on other sites More sharing options...
RUNNAWAYICEBERG Posted December 11, 2019 Share Posted December 11, 2019 +3.75 10 YTD Link to comment Share on other sites More sharing options...
Sugarloaf1989 Posted December 11, 2019 Share Posted December 11, 2019 3" 18" YTD Link to comment Share on other sites More sharing options...
CT Valley Snowman Posted December 11, 2019 Share Posted December 11, 2019 3" new 20.75 Season Link to comment Share on other sites More sharing options...
Ski Patroller Posted December 11, 2019 Share Posted December 11, 2019 Colebrook, CT 3.2" today, 16.3" for season Link to comment Share on other sites More sharing options...
Torch Tiger Posted December 11, 2019 Share Posted December 11, 2019 3.3" 23.3" season Link to comment Share on other sites More sharing options...
Kevin W Posted December 11, 2019 Author Share Posted December 11, 2019 12 minutes ago, Dr. Dews said: 3.3" 23.3" season Unless we're missing something, I've got you at 22.1" Link to comment Share on other sites More sharing options...
Torch Tiger Posted December 11, 2019 Share Posted December 11, 2019 3 minutes ago, Kevin W said: Unless we're missing something, I've got you at 22.1" 1.2" on that clipper. I'm pretty meticulous 1 Link to comment Share on other sites More sharing options...
Kevin W Posted December 11, 2019 Author Share Posted December 11, 2019 41 minutes ago, Dr. Dews said: 1.2" on that clipper. I'm pretty meticulous You must mean 12/06. I didn't see that posted anywhere, but I'll get that in there. Link to comment Share on other sites More sharing options...
CoastalWx Posted December 11, 2019 Share Posted December 11, 2019 On 12/6/2019 at 10:21 PM, CoastalWx said: + 0.2. 8.9”. 4.0”. 12.9” Link to comment Share on other sites More sharing options...
NorEastermass128 Posted December 11, 2019 Share Posted December 11, 2019 +2.5” 8.5” YTD Link to comment Share on other sites More sharing options...
40/70 Benchmark Posted December 12, 2019 Share Posted December 12, 2019 +2"=22" 2 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now