Google Answers Logo
View Question
Q: temperature in San Francisco ( Answered 5 out of 5 stars,   0 Comments )
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

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

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

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

Scroll down and by clicking on a day, you will get the hourly
observations, including temperature.
For example Match 1, 2006:

March 2005

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,

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?


Clarification of Question by feido-ga on 21 Oct 2006 09:33 PDT
Actually, the data on
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)
but for San Francisco as the average over years for March.
Subject: Re: temperature in San Francisco
Answered By: pafalafa-ga on 21 Oct 2006 17:35 PDT
Rated:5 out of 5 stars

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

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:
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:
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!


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

After that I sure pay and tip. 


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


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

Glad to hear the graph was what you needed.

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.

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 with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

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