Kevin W
-
Posts
1,325 -
Joined
-
Last visited
Content Type
Profiles
Blogs
Forums
American Weather
Media Demo
Store
Gallery
Everything posted by Kevin W
-
That is sweet! I see I have some catching up to do here, and I will as soon as I can. I notice some posts in here, but I'm not sure to add them (as actual members on the list) or not. Last time I checked, there were some new names, and even totals for one storm, not the season. I'll go back and look at it all again when I update everything else, but it was getting confusing at first glance.
-
Should I change that for you?
-
I'm in Attleboro. I just went out and measured 6".
-
I have added Sandwich to the locations list.
-
I noted this. The table plugin I use has many options for data filtering, presentation and exporting, so I'll look into this when I get some time. Are there any specific ways you want last year's data shown?
-
You chose the wrong season from the dropdown. I fixed it for you, and also added this season as the default choice for new entries.
-
I just logged in under your name, and it works for me. Make sure you are logged in, then go here. You have run into this before.
-
Hi guys. I'm hearing some spots in New Hampshire are getting snow. If you were in this last season, you should be good to go. If not, you'll need to contact me for a username and password. Kevin New England Snow
-
Thanks man. Everything seems to be just fine. It was painless.
-
FYI, I moved the snow portion of my site to its own directory, something I've been needing to do for a long time. Here is the new address: New England Snow
-
Sort this page (descending) and you will see some very small amounts.
-
Yes:
-
I found this to be pretty cool!
-
Thanks for clearing that up. I thought something was wrong.
-
Not a problem doing it. Logging in does give you much more control over your own records. It's not just Dave who adds details to events. Several people now do it and I think it's great. Filtering, sorting, and searching, is much better now, than it was in the past.
-
I'm kind of wondering why you are not seeing the " suffix in the amount field. What page is this screenshot from?
-
For those who have been wanting ranks for the totals, I have been trying like crazy to find a way make it happen. Today, I found a way, but at the moment, it only works behind the scenes, not on the front end. I have contacted the vendor for the plugin I use for these tables and I'm waiting for a reply. Based on what I can tell, it doesn't look too promising, unless they can do some sort of magic for me.
-
You must mean 12/06. I didn't see that posted anywhere, but I'll get that in there.
-
Unless we're missing something, I've got you at 22.1"
-
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
-
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.
-
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:
-
All set. See PM
-
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.
-
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.
