Jump to content

All Activity

This stream auto-updates

  1. Past hour
  2. Mid to north mountain special Madison-Yancey-Mitchell- Including the cities of Faust 102 PM EST Thu Feb 5 2026 ...WINTER WEATHER ADVISORY IN EFFECT FROM 1 PM FRIDAY TO 7 AM EST SATURDAY ABOVE 3500 FEET... * WHAT...Snow expected above 3500 feet. Total snow accumulations between 1 and 3 inches with some locations up to 6 inches along the Tennessee border. Winds gusting as high as 65 mph. * WHERE...Madison, Mitchell, and Yancey Counties. * WHEN...From 1 PM Friday to 7 AM EST Saturday.
  3. I use dense rank sorting which doesn’t skip rank numbers. DENSE_RANK is a SQL window function that sorts data and assigns consecutive rankings to rows, ensuring no gaps in the sequence, even when ties occur. If multiple rows share a rank (e.g., two rows are ranked 1), the next rank is 2, not 3. It is essential for top-N analysis without skipping rank numbers. Key Aspects of DENSE_RANK: No Gaps: If two rows tie for rank 1, the next rank is 2, not 3. Ties: Identical values receive the same rank. Syntax: DENSE_RANK() OVER ([PARTITION BY <columns>] ORDER BY <columns>). Use Case: Ideal for top-N analysis where multiple rows might share the same top value, but you still want a continuous ranking order.
  4. That last one was epic, I'd love to buy a repeat. Also 12 overnight, 35 now. While above freezing this week I haven’t even sniffed close to a normal high temp in so long it feels very significant.
  5. Temp this morning here was -5.6 so a hint of things to come. Just got upgraded to a Warning with 6-8" and up to 60 mph winds. Still not completely sold on that kind of accumulation with Huron mostly and Erie especially closed for business. While this is nothing historic of course, it's still going to be a pretty solid ~24 hours out here in the Boonies.
  6. Severe works for me, I would much rather hear the thunder rolling versus transformers blowing...
  7. If we get an inch or two of snow Friday night into Saturday, then the brutal cold and wind, could be like a near blizzard at times with blowing snow.
  8. Legit can't wait for Saturday. I've got a shift at the farm outside. I will take extreme cold over heat any day of the week. Weather like this lets you know you're alive!
  9. 12Z GFS and Euro ask “what Val. Day storm?” They fwiw show sunny high pressure. But that’s still 9 days out, a relative eternity in relation to model accuracy.
  10. I don’t know why they don’t talk about wind in their disco. It’s a legit, strong wind storm that’s going to cause problems.
  11. The panels have been up since 2013.
  12. Omg you didn’t know what was him? Hahahahaha
  13. Hello - I interrupt this delightful descent into board madness with this very important Olympic news - on Peacock - you can get a quad box of live events and right now I have a quad box of live curling on and it is absolutely glorious.
  14. I been saying it for a while, need to stop paying attention to op models past day 3. They been awful.
  15. I think the OP models are going to be spitting out different solutions for the next several days till they figure out the PAC energy crap
  16. The model world has succumbed into KAOS during the past 6 hrs..................... Any semblance of run to run consistency has disappeared.
  17. 16th is well back into clown range so that’s of no help really. The 14th looks to be the 13th, then it’s the 15th, now it’s the 16th…it’s all over the place. So I think the 11th is the one to watch as of now. Has more support today... and is closer in time so obviously that is the favored one now.
  1. Load more activity
×
×
  • Create New...