New Zealand Local Weather Forum
Weather Discussion => Historical => Topic started by: Stephendnz on May 23, 2016, 11:27:15 AM
-
Hi Can anyone please tell me where i can get up-to-date (as in last week also) historical DAILY rainfall data for Hokitika??
I have googled all over and just keep getting mean monthly averages..
Cheers
-
Is this any good?
Weekly
https://www.wunderground.com/history/station/93615/2016/5/22/WeeklyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo=
Monthly
https://www.wunderground.com/history/station/93615/2016/5/22/MonthlyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo=
-
Hi Thanks Jenny.. that page was interesting.. but still can't seem to get a list of each day's rainfall there.. just can select individual days..
:-)
-
Maybe try cliflo, but I'm not sure how recent their info is. I'd check but I forgot my password ;-)
Welcome to the Climate Database (http://cliflo.niwa.co.nz/)
EDIT: Oh, and by the way, welcome to the forum!!!!
-
I am not sure in that case what you are after.
See the tabs half ways down. Select month then scroll down.
There is each days.
1- 0
2- 47
3- 0
4- 54
5- 27
6- 0
7- 0
8- 0
9- 0.2
10- 0.8
11- 24
12- 19
13- 16
14- 5
15- 10
16- 14
17- 0.2
18- 2
19- 0
20- 39
21- 0.4
22- 0
23- 5
Total 263.6mm
Is this what you mean.
btw that is a lot of rain for 3 weeks :)
-
Hi Stephendnz & welcome from me too!
I was in the middle of replying when Jenny posted hers.
Just to reiterate, check out either page & scroll right down.
You'll find the daily high/avg/lows there including daily rain figures.
You can copy the table into a spreadsheet if you want, or download the csv file (link beneath the table) & do what ever you wish from there.
Cheers
-
Hi Thanks for all the suggestions.. and the nice welcomes.. Jenny I guess you were referring to the original page you posted.
This one: https://www.wunderground.com/history/station/93615/2016/4/22/MonthlyHistory.html?req_city=&req_state=&req_statename=&reqdb.zip=&reqdb.magic=&reqdb.wmo=&MR=1
I see the monthly list.. I guess could extract from there with a cut and paste.. but its a bit laborious. :-) Did you extract all the data and then put in a spreadsheet and strip out the rainfall?? Or am i missing something there?? :-)
It seems the dates don't translate well.. have to recreate them in a separate column. I guess I will have to persevere..
Thanks again for the help..
-
Hi Stephendnz
Here's what I would do. (Win XP, Firefox, MS Office 2007)
Open the web page, scroll right down, click on Comma Delimited File which opens a new tab showing the csv data,
right click & select all, copy all (Ctrl C), switch to your spreadsheet & Ctrl V.
Then you need to parse the stuff, select all the data & then Menu / Data / Text to Columns, click on Comma, then the Finish button.
This will give you something like . . .
NZST Max TemperatureC Mean TemperatureC . . .
01/04/2016 18 16 . . .
02/04/2016 19 17 . . .
03/04/2016 19 18 . . .
Then you only need to select the rain column & you have the data to do with as you wish.
Depending on what platform & software you are using & how you have it set up, I imagine things should go pretty much the same.
Cheers
-
Thanks for all your help.. In the end i just cut and pasted all the data from the different months into a spreadsheet.. Got what I wanted which was the rainfall figures.. and hid the other columns..
Like this
Date Temp. (°C) Precip. (mm) Events
Date high avg low sum
1/03/15 21 18 16 12 1
2/03/15 21 18 14 0 0
3/03/15 18 18 17 22 1
4/03/15 20 18 17 5 1
5/03/15 21 18 16 7 1
6/03/15 18 16 13 19 1
7/03/15 17 15 13 14 1
8/03/15 19 16 12 0.4 1
9/03/15 18 16 12 0.6 1
10/03/15 19 16 12 0 0
11/03/15 20 16 13 0 0
12/03/15 21 18 15 0 0
13/03/15 18 16 15 0.6 1
14/03/15 19 16 12 0 0
15/03/15 21 16 10 0 0
-
Cool! Finding your own way is often the best way.
When you have a mo, and to let us know a little about you, feel free to pop a brief bit in our New Members section under General . . no need for too much, just a little something about yourself, maybe your location, interests, plans or whatever.
Cheers
-
You can get it all from Cliflo. For the last 30 days, the MetService site has the previous 30 days for one of the Hokitika sites. I have monthly totals for a selection of sites going back to 1866, though that is for several different sites.