Weather Data: Difference between revisions
Line 36: | Line 36: | ||
'''Details''' | '''Details''' | ||
* '''Download:''' [http://simwiki.net/files/weather-files-csv.zip | * '''Download Weather Data:''' | ||
** [http://simwiki.net/files/weather-files-csv.zip CSV Version] - CSV file for each location | |||
** [http://simwiki.net/files/weather-sqlite-databases.zip SQLite Version] - SQLite Database for each location | |||
*** The SQLite databases contain extra tables with extra data that could be summarized, calculated, or otherwise extrapolated from the original data | |||
*** Tables: weather, weather_days, weather_months | |||
*** See sample schema and data for sqlite databases below | |||
** '''Note:''' Use [https://7-zip.org 7zip] to extract the gzipped '''.csv.gz''' files found in the download. | ** '''Note:''' Use [https://7-zip.org 7zip] to extract the gzipped '''.csv.gz''' files found in the download. | ||
* '''Description:''' 44 years of hourly weather data (1979 - 2023) for racing circuits around the world | * '''Description:''' 44 years of hourly weather data (1979 - 2023) for racing circuits around the world | ||
Line 136: | Line 141: | ||
284036400,1979-01-01 11:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,268.07,,263.8,262.94,267.22,268.3,1023,,,69,3.63,318,,,,,,33,802,Clouds,scattered clouds,03d | 284036400,1979-01-01 11:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,268.07,,263.8,262.94,267.22,268.3,1023,,,69,3.63,318,,,,,,33,802,Clouds,scattered clouds,03d | ||
284040000,1979-01-01 12:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,268.23,,263.79,263.14,267.22,268.44,1023,,,68,3.63,316,,,,,,33,802,Clouds,scattered clouds,03d | 284040000,1979-01-01 12:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,268.23,,263.79,263.14,267.22,268.44,1023,,,68,3.63,316,,,,,,33,802,Clouds,scattered clouds,03d | ||
</nowiki></pre> | |||
'''Sample SQLite Database Schema and Data''' | |||
'''weather:''' | |||
<pre><nowiki> | |||
sqlite> select * from weather limit 3; | |||
dt,dt_iso,timezone,city_name,lat,lon,temp,visibility,dew_point,feels_like,temp_min,temp_max,pressure,sea_level,grnd_level,humidity,wind_speed,wind_deg,wind_gust,rain_1h,rain_3h,snow_1h,snow_3h,clouds_all,weather_id,weather_main,weather_description,weather_icon,dt_date,dt_time,short_name | |||
283996800,"1979-01-01 00:00:00 +0000 UTC",0.0,"Thruxton Circuit",51.206098,-1.608785,267.32,10000,264.61,260.87,267.02,267.56,1011,"","",79,5.1,360,"","","","","",20,801,Clouds,"few clouds",02n,1979-01-01,00:00:00,Thruxton | |||
284000400,"1979-01-01 01:00:00 +0000 UTC",0.0,"Thruxton Circuit",51.206098,-1.608785,267.25,10000,265.38,260.79,266.37,267.57,1012,"","",85,5.1,360,"","","","","",0,800,Clear,"sky is clear",01n,1979-01-01,01:00:00,Thruxton | |||
284004000,"1979-01-01 02:00:00 +0000 UTC",0.0,"Thruxton Circuit",51.206098,-1.608785,267.29,"",264.14,260.92,266.97,268.65,1013,"","",76,4.98,350,"","","","","",0,800,Clear,"sky is clear",01n,1979-01-01,02:00:00,Thruxton | |||
</nowiki></pre> | |||
'''weather_days:''' | |||
<pre><nowiki> | |||
sqlite> select * from weather_days limit 3; | |||
dt_date,short_name,lat,lon,rainy,temp,temp_min,temp_max,temp_day,temp_day_min,temp_day_max,temp_night,temp_night_min,temp_night_max,temp_stdev,dry_avg_factor,rain_avg_factor,rain_light_avg_factor,rain_moderate_avg_factor,rain_heavy_avg_factor,weather_main,weather_description | |||
1979-01-01,Thruxton,51.206098,-1.608785,0,266.66375,263.43,268.65,267.143846153846,265.65,268.5,266.096363636364,263.43,268.65,0.858906344542664,1.0,0.0,0.0,0.0,0.0,"Clouds,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clouds,Clouds,Clouds,Clouds,Haze,Clouds,Clouds,Clouds,Clouds","few clouds,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,broken clouds,overcast clouds,overcast clouds,overcast clouds,haze,overcast clouds,broken clouds,few clouds,scattered clouds" | |||
1979-01-02,Thruxton,51.206098,-1.608785,0,270.755,265.63,275.65,272.657692307692,268.37,275.65,268.506363636364,265.63,270.65,2.54627776072892,1.0,0.0,0.0,0.0,0.0,"Clouds,Clouds,Clouds,Clouds,Clouds,Clear,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clear,Clear,Clear,Clear,Clouds,Clouds,Clear,Clear,Clear","scattered clouds,broken clouds,scattered clouds,scattered clouds,few clouds,sky is clear,scattered clouds,broken clouds,few clouds,scattered clouds,broken clouds,scattered clouds,scattered clouds,scattered clouds,few clouds,sky is clear,sky is clear,sky is clear,sky is clear,few clouds,few clouds,sky is clear,sky is clear,sky is clear" | |||
1979-01-03,Thruxton,51.206098,-1.608785,0,270.73,264.88,274.37,272.686153846154,265.65,274.37,268.418181818182,264.88,272.65,2.66099033542355,1.0,0.0,0.0,0.0,0.0,"Clear,Clear,Clear,Clear,Clouds,Clear,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds","sky is clear,sky is clear,sky is clear,sky is clear,few clouds,sky is clear,few clouds,few clouds,broken clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds" | |||
</nowiki></pre> | |||
'''weather_months:''' | |||
<pre><nowiki> | |||
sqlite> select * from weather_months limit 3; | |||
dt_date,short_name,lat,lon,rainy,temp,temp_min,temp_max,temp_day,temp_day_min,temp_day_max,temp_night,temp_night_min,temp_night_max,temp_stdev,dry_avg_factor,rain_avg_factor,rain_light_avg_factor,rain_moderate_avg_factor,rain_heavy_avg_factor | |||
1979-01-01,Thruxton,51.206098,-1.608785,0,273.781330645161,263.43,282.14,274.424441687345,265.65,281.65,273.021290322581,263.43,282.14,1.59066133568371,0.82258064516129,0.17741935483871,0.0913978494623656,0.0134408602150538,0.00134408602150538 | |||
1979-02-01,Thruxton,51.206098,-1.608785,0,274.697589285714,267.5,282.65,275.429505494505,268.25,282.65,273.832597402597,267.5,281.65,1.42591526382216,0.733630952380952,0.266369047619048,0.107142857142857,0.0416666666666667,0.00148809523809524 | |||
1979-03-01,Thruxton,51.206098,-1.608785,0,277.934771505376,270.42,285.37,279.043275434243,271.93,285.37,276.624721407625,270.42,283.65,1.83233711447987,0.643817204301075,0.356182795698925,0.258064516129032,0.0470430107526882,0.00268817204301075 | |||
</nowiki></pre> | </nowiki></pre> |
Revision as of 20:00, 1 July 2024
Real Weather Data
Weather data is valuable to any sim as it can allow developers or modders to implement or enhance weather features such as accurate historical weather, quasi-realistic weather scenarios, weather progression algorithms, calculating weather metrics (such as averages, medians, standard deviations, etc.), and more.
Racing Circuits Real Weather Data
Latest Release: 2024-06-27
- New tracks added: Assen, Jarama, Long Beach, Mugello, Norisring, Sachsenring, Thruxton
Description
This dataset helped support the Crew Chief GTR2 Enhancements Plugin Custom Weather feature enabling realtime and slot-based, algorithm-generated quasi-realistic weather scenarios for GTR2.
Help The Cause
Donate to paypal@shovas.ca or send BTC Bitcoin to bc1q8nwwnwp9zljndlcaw4jcmj0yfyqe69fa5k54dm, LTC Litecoin to ltc1qljlmg5673q6j0s5cmxk4ggyn0x5d4npaw25vah, or DOGE Dogecoin to DSMwwdHqJ3LMxPe1HiGgNKsWBY2jPi2RwW, and help me continue this project. Thank you!
How To Donate OpenWeatherMap Weather Data Directly
Purchase OpenWeatherMap.org Marketplace > History Bulk weather data, download it, and share a link to the download.
Check and double-check:
- Date range: 1979-01-01 to 2023-12-31
- Weather Parameters: All
- Units: Kelvin
- File Format: CSV
- Download: File per location
Like this:
Details
- Download Weather Data:
- CSV Version - CSV file for each location
- SQLite Version - SQLite Database for each location
- The SQLite databases contain extra tables with extra data that could be summarized, calculated, or otherwise extrapolated from the original data
- Tables: weather, weather_days, weather_months
- See sample schema and data for sqlite databases below
- Note: Use 7zip to extract the gzipped .csv.gz files found in the download.
- Description: 44 years of hourly weather data (1979 - 2023) for racing circuits around the world
- Format: CSV, one file per location
- Parameters: dt, dt_iso, timezone, city_name, lat, lon, temp, visibility, dew_point, feels_like, temp_min, temp_max, pressure, sea_level, grnd_level, humidity, wind_speed, wind_deg, wind_gust, rain_1h, rain_3h, snow_1h, snow_3h, clouds_all, weather_id, weather_main, weather_description, weather_icon
- Locations:
- All original GTR2 tracks and additional tracks
- Adelaide Street Circuit
- Anderstorp Racing Club
- Assen, TT Circuit
- Barcelona-Catalunya (Barcelona), Circuit de
- Brands Hatch
- Canadian Tire Motorsport Park (Mosport)
- Daytona Interational Speedway
- Detroit Street Circuit
- Donington Park Circuit
- Dubai Autodrome
- Enzo e Dino Ferrari (Imola), Autodromo
- Fernanda Pires da Silva (Estoril), Autódromo
- Fuji Speedway
- Gilles Villeneuve (Montreal), Circuit
- Hermanos Rodríguez (Mexico City), Autódromo
- Hockenheimring Baden-Württemberg
- Hungaroring
- Jarama, Circuito del
- José Carlos Pace (Interlagos), Autodromo
- Kyalami Grand Prix Circuit
- Laguna Seca Raceway
- Lime Rock Park
- Long Beach, Grand Prix
- Magny-Cours, Circuit de Nevers
- Masaryk Circuit (Brno)
- Miami International Autodrome
- Mid-Ohio Sports Car Course
- Mobility Resort Motegi
- Monaco, Circuit de
- Monza, Autodromo Nazionale
- Motorsport Arena Oschersleben
- Mount Panorama Motor Racing Circuit (Bathurst)
- Mugello Circuit
- Norisring
- Nürburgring Grand-Prix Strecke
- Oulton Park Circuit
- Pergusa (Enna-Pergusa), Autodromo di
- Phillip Island Grand Prix Circuit
- Red Bull Ring
- Ricardo Tormo (Valencia), Circuit
- Road America
- Road Atlanta
- Sachsenring
- Sarthe (Le Mans), Circuit de la
- Sebring International Raceway
- Shanghai International Circuit
- Silverstone Circuit
- Snetterton Circuit
- Spa-Francorchamps Circuit de
- Suzuka International Racing Course
- Thruxton Circuit
- Virginia International Raceway (VIR)
- Watkins Glen International
- Willow Springs International Motorsports Park
- Zandvoort, Circuit
- Zhuhai International Circuit
- Zolder, Circuit
- Source: OpenWeatherMap.org History Bulk
- License: OpenWeatherMap weather database files are licensed under Open Data Commons Open Database License (ODbL) v1.0 (Summary). This license requires that users attribute any public use of the database, or works produced from the database, in the manner specified in the ODbL. It allows users to share (copy, distribute, and use the data), create (produce works from the data), and adapt (modify, transform, and build on the data), for commercial and noncommercial purposes.
- You don't have to ask permission for legitimate uses. You just have to give attribution.
Sample of Files in the Data
Anderstorp_Racing_Club_57_261829_13_600247_66271d3123a6580008cf2b7d.csv.gz Autodromo_di_Pergusa_37_520353_14_304795_66271d3123a6580008cf2b7d.csv.gz Autodromo_Enzo_e_Dino_Ferrari_44_344719_11_715851_66271d3123a6580008cf2b7d.csv.gz ... Motorsport_Arena_Oschersleben_52_025735_11_278023_66271d3123a6580008cf2b7d.csv.gz Nevers_Magny_Cours_Circuit_46_863809_3_162568_66271d3123a6580008cf2b7d.csv.gz Zhuhai_International_Circuit_22_360426_113_56353_66271d3123a6580008cf2b7d.csv.gz
Sample Data
dt,dt_iso,timezone,city_name,lat,lon,temp,visibility,dew_point,feels_like,temp_min,temp_max,pressure,sea_level,grnd_level,humidity,wind_speed,wind_deg,wind_gust,rain_1h,rain_3h,snow_1h,snow_3h,clouds_all,weather_id,weather_main,weather_description,weather_icon 283996800,1979-01-01 00:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,266.79,,263.5,260.19,266.22,267.13,1012,,,75,5.13,349,,,,,,5,800,Clear,sky is clear,01n 284000400,1979-01-01 01:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,266.84,,263.24,260.29,266.22,267.1,1014,,,73,5.07,350,,,,,,2,800,Clear,sky is clear,01n 284004000,1979-01-01 02:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,266.81,,263.06,260.35,266.39,267.04,1014,,,72,4.94,347,,,,,,0,800,Clear,sky is clear,01n 284007600,1979-01-01 03:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,265.85,,262.73,259.16,265.48,266.22,1015,,,76,4.93,344,,,,,,0,800,Clear,sky is clear,01n 284011200,1979-01-01 04:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,265.78,,262.81,259,265.35,266.33,1016,,,77,5.02,341,,,,,,0,800,Clear,sky is clear,01n 284014800,1979-01-01 05:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,265.77,,263.23,258.95,265.34,266.33,1017,,,80,5.07,342,,,,,,0,800,Clear,sky is clear,01n 284018400,1979-01-01 06:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,265.82,,263.28,259.15,265.22,266.33,1018,,,80,4.89,343,,,,,,0,800,Clear,sky is clear,01n 284022000,1979-01-01 07:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,265.74,,262.92,259.38,265.22,266.33,1019,,,78,4.46,343,,,,,,0,800,Clear,sky is clear,01n 284025600,1979-01-01 08:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,265.77,,263.51,259.73,265.36,266.33,1020,,,82,4.08,339,,,,,,0,800,Clear,sky is clear,01n 284029200,1979-01-01 09:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,266.44,,262.54,260.68,266.01,266.69,1021,,,71,3.93,334,,,,,,17,801,Clouds,few clouds,02d 284032800,1979-01-01 10:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,267.67,,264.36,262.42,266.22,267.96,1021,,,75,3.67,320,,,,,,73,803,Clouds,broken clouds,04d 284036400,1979-01-01 11:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,268.07,,263.8,262.94,267.22,268.3,1023,,,69,3.63,318,,,,,,33,802,Clouds,scattered clouds,03d 284040000,1979-01-01 12:00:00 +0000 UTC,0,Donington Park Circuit,52.829532,-1.381452,268.23,,263.79,263.14,267.22,268.44,1023,,,68,3.63,316,,,,,,33,802,Clouds,scattered clouds,03d
Sample SQLite Database Schema and Data
weather:
sqlite> select * from weather limit 3; dt,dt_iso,timezone,city_name,lat,lon,temp,visibility,dew_point,feels_like,temp_min,temp_max,pressure,sea_level,grnd_level,humidity,wind_speed,wind_deg,wind_gust,rain_1h,rain_3h,snow_1h,snow_3h,clouds_all,weather_id,weather_main,weather_description,weather_icon,dt_date,dt_time,short_name 283996800,"1979-01-01 00:00:00 +0000 UTC",0.0,"Thruxton Circuit",51.206098,-1.608785,267.32,10000,264.61,260.87,267.02,267.56,1011,"","",79,5.1,360,"","","","","",20,801,Clouds,"few clouds",02n,1979-01-01,00:00:00,Thruxton 284000400,"1979-01-01 01:00:00 +0000 UTC",0.0,"Thruxton Circuit",51.206098,-1.608785,267.25,10000,265.38,260.79,266.37,267.57,1012,"","",85,5.1,360,"","","","","",0,800,Clear,"sky is clear",01n,1979-01-01,01:00:00,Thruxton 284004000,"1979-01-01 02:00:00 +0000 UTC",0.0,"Thruxton Circuit",51.206098,-1.608785,267.29,"",264.14,260.92,266.97,268.65,1013,"","",76,4.98,350,"","","","","",0,800,Clear,"sky is clear",01n,1979-01-01,02:00:00,Thruxton
weather_days:
sqlite> select * from weather_days limit 3; dt_date,short_name,lat,lon,rainy,temp,temp_min,temp_max,temp_day,temp_day_min,temp_day_max,temp_night,temp_night_min,temp_night_max,temp_stdev,dry_avg_factor,rain_avg_factor,rain_light_avg_factor,rain_moderate_avg_factor,rain_heavy_avg_factor,weather_main,weather_description 1979-01-01,Thruxton,51.206098,-1.608785,0,266.66375,263.43,268.65,267.143846153846,265.65,268.5,266.096363636364,263.43,268.65,0.858906344542664,1.0,0.0,0.0,0.0,0.0,"Clouds,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clear,Clouds,Clouds,Clouds,Clouds,Haze,Clouds,Clouds,Clouds,Clouds","few clouds,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,sky is clear,broken clouds,overcast clouds,overcast clouds,overcast clouds,haze,overcast clouds,broken clouds,few clouds,scattered clouds" 1979-01-02,Thruxton,51.206098,-1.608785,0,270.755,265.63,275.65,272.657692307692,268.37,275.65,268.506363636364,265.63,270.65,2.54627776072892,1.0,0.0,0.0,0.0,0.0,"Clouds,Clouds,Clouds,Clouds,Clouds,Clear,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clear,Clear,Clear,Clear,Clouds,Clouds,Clear,Clear,Clear","scattered clouds,broken clouds,scattered clouds,scattered clouds,few clouds,sky is clear,scattered clouds,broken clouds,few clouds,scattered clouds,broken clouds,scattered clouds,scattered clouds,scattered clouds,few clouds,sky is clear,sky is clear,sky is clear,sky is clear,few clouds,few clouds,sky is clear,sky is clear,sky is clear" 1979-01-03,Thruxton,51.206098,-1.608785,0,270.73,264.88,274.37,272.686153846154,265.65,274.37,268.418181818182,264.88,272.65,2.66099033542355,1.0,0.0,0.0,0.0,0.0,"Clear,Clear,Clear,Clear,Clouds,Clear,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds,Clouds","sky is clear,sky is clear,sky is clear,sky is clear,few clouds,sky is clear,few clouds,few clouds,broken clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds,overcast clouds"
weather_months:
sqlite> select * from weather_months limit 3; dt_date,short_name,lat,lon,rainy,temp,temp_min,temp_max,temp_day,temp_day_min,temp_day_max,temp_night,temp_night_min,temp_night_max,temp_stdev,dry_avg_factor,rain_avg_factor,rain_light_avg_factor,rain_moderate_avg_factor,rain_heavy_avg_factor 1979-01-01,Thruxton,51.206098,-1.608785,0,273.781330645161,263.43,282.14,274.424441687345,265.65,281.65,273.021290322581,263.43,282.14,1.59066133568371,0.82258064516129,0.17741935483871,0.0913978494623656,0.0134408602150538,0.00134408602150538 1979-02-01,Thruxton,51.206098,-1.608785,0,274.697589285714,267.5,282.65,275.429505494505,268.25,282.65,273.832597402597,267.5,281.65,1.42591526382216,0.733630952380952,0.266369047619048,0.107142857142857,0.0416666666666667,0.00148809523809524 1979-03-01,Thruxton,51.206098,-1.608785,0,277.934771505376,270.42,285.37,279.043275434243,271.93,285.37,276.624721407625,270.42,283.65,1.83233711447987,0.643817204301075,0.356182795698925,0.258064516129032,0.0470430107526882,0.00268817204301075