4

I am looking for historical weather data (mostly temperature and sunshine hours) for France (specifically the City of Sceaux).

I found meteofrance who offer free historical weather data per day. The only way that I found to download the data is one file per day with all stations. What I would be looking for is a download of a single file that contains information for multiple days at the same station. So to say historical data per station, not per day. Does meteofrance or a similar source offer something like this or should I use weatherunderground for this?

k-nut
  • 211
  • 1
  • 6
  • Is Villacoublay too far away for your purposes? Can you use METAR reports (which include temperature, but not sunshine hours) for the station LFPV (Villacoublay). ftp://ftp.ncdc.noaa.gov/pub/data/noaa/ has large amounts of data (only one year at a time, but that's not bad) –  Jul 05 '15 at 17:10
  • The location looks promising. As far as I can tell the data that you linked to contains ish, not METAR formatted data or am I not seeing/understanding something? – k-nut Jul 06 '15 at 08:54
  • Of course I can just as well use ish formated data. Just wondering. – k-nut Jul 06 '15 at 09:04

2 Answers2

2

BigQuery has NOAA data, this from the closest station I found to Sceaux:

SELECT year, mo, da, temp
FROM [bigquery-public-data:noaa_gsod.gsod2010] a 
JOIN (
  SELECT name, usaf, wban
  FROM [bigquery-public-data:noaa_gsod.stations] 
  WHERE country='FR' 
  AND lat BETWEEN 48.7 AND 48.8
  AND lon BETWEEN 2.2 AND 2.3
  LIMIT 100 
) b 
ON a.stn=b.usaf AND a.wban=b.wban
ORDER BY 1,2,3

BigQuery also has ghcn_d data, but no station is as close as the NOAA one.

If you haven't tried BigQuery:

Felipe Hoffa
  • 211
  • 2
  • 6
2

The wunderground API is pretty great for that. You just need to register for a key. Here is an ipython notebook to get you started: https://github.com/joshmalina/pollution/blob/master/notebooks/Build_historical_weather_data.ipynb

compguy24
  • 246
  • 2
  • 4