Google Answers Logo
View Question
 
Q: temperature in San Francisco ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: temperature in San Francisco
Category: Science > Earth Sciences
Asked by: feido-ga
List Price: $100.00
Posted: 16 Oct 2006 22:40 PDT
Expires: 15 Nov 2006 21:40 PST
Question ID: 774260
Hi 

I am looking for the temperature profile by hour for the month of
March for San Francisco.

It should look similar to the temperature profile here for chinalake
http://www.nawcwpns.navy.mil/~weather/chinalake/pubs/iob/iobaprhat.htm

I already have the temperature profile for the month of March in 2006.
What I like to have is the "average historical temperature profile"
that is the average profile over various years for the month of March.

Clarification of Question by feido-ga on 16 Oct 2006 22:44 PDT
The hourly data for March 2006 I got from the website
http://www.ndbc.noaa.gov/station_history.php?station=ftpc1

However I did not find on that website older data from prior years of
the month March

Request for Question Clarification by rainbow-ga on 17 Oct 2006 09:51 PDT
Please take a look at this data that goes back to March of 2001:

March 2006
http://www.wunderground.com/history/airport/KSFO/2006/3/1/MonthlyHistory.html

Scroll down and by clicking on a day, you will get the hourly
observations, including temperature.
For example Match 1, 2006:
http://www.wunderground.com/history/airport/KSFO/2006/3/1/DailyHistory.html

March 2005
http://www.wunderground.com/history/airport/KSFO/2005/3/1/MonthlyHistory.html

Click on a day for the hourly data of that day.

Similar data is available til March 2001.


Let me know if this information fiits your needs.

Best regards,
rainbow

Clarification of Question by feido-ga on 21 Oct 2006 09:19 PDT
Hi Rainbow, 

Thanks for your help that is very useful. I don't see the button where
to say "question finished" and where to add tip. Or do I just have to
"cancel" the question and then I will be asked to pay?

Feido

Clarification of Question by feido-ga on 21 Oct 2006 09:33 PDT
Actually, the data on
http://www.wunderground.com/history/airport/KSFO/2002/3/1/DailyHistory.html
would imply that for all days 31 days of March in all years from
2002-2006 I would have to open all the single daily files (hundred of
files) and then compute the average temperature myself.

I go up to USD 100 if someone can provide me with the temperature profile (like)
http://www.nawcwpns.navy.mil/~weather/chinalake/pubs/iob/iobaprhat.htm
but for San Francisco as the average over years for March.
Answer  
Subject: Re: temperature in San Francisco
Answered By: pafalafa-ga on 21 Oct 2006 17:35 PDT
Rated:5 out of 5 stars
 
feido-ga,

The problem with weather date, of course, is that there's so darn much
of it.  The biggest challenge has to do not only with finding the
right source, but then figuring out how to massage the raw data into
shape.

With a bit of persistence though, and a lot of wading through the NOAA
website, I finally found what I (you, actually) needed at the
following NOAA climate data site:


http://lwf.ncdc.noaa.gov/oa/climate/climatedata.html#hourly
Global and U.S.--Select by Station (Integrated Surface Hourly) 


This data set has historical hourly data records from thousands of
stations around the world.

By working my way through the options provided, I was able to access
(at no charge, as it turned out), the data for San Francisco
International Airport for all hourly temperature records for the month
of March for the period 1990-2006.

I took the hourly data for March for each year and averaged out the
temperatures for each hour; i.e., I added up all the data points for
noon temperature and found the average over the years...ditto for the
other 23 hourly periods.


The results are shown in a graph, here:



http://www.esnips.com/doc/bf2dff53-c651-44c3-b7f3-b97185a8e785/sf-temps.jpg
Hourly Avg Temp in March in SF


Click on the "Original Size" button to see it full sized.


I trust this graph is exactly what you were after.  

However, please don't rate this answer until you have everything you
need.  If you would like any additional information, just post a
Request for Clarification to let me know how I can assist you further,
and I'm at your service.

All the best, and thanks for a real challenge!

pafalafa-ga

Request for Answer Clarification by feido-ga on 21 Oct 2006 20:02 PDT
Hi Pafalafa, 

Thanks for your answer. The graph is exactly what I was looking for.
Can you please also provide the data base that you used to create the
graph?

After that I sure pay and tip. 

Thanks!

Request for Answer Clarification by feido-ga on 21 Oct 2006 20:05 PDT
With "database" I mean if you can put the Excel Spreadsheet with the
rawdata used to create the graph on your website of

http://www.esnips.com...

Thanks,

Clarification of Answer by pafalafa-ga on 22 Oct 2006 05:14 PDT
Sure thing:


http://www.esnips.com/doc/98e45e9b-9186-4214-8ad5-02017e87de3a/sf-temps.xls


Glad to hear the graph was what you needed.


paf
feido-ga rated this answer:5 out of 5 stars and gave an additional tip of: $10.00
yes, that is nice, also that they provide the standard deviations.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy