Weather Data: Difference between revisions

From Simwiki.net
Jump to navigation Jump to search
No edit summary
Line 38: Line 38:
'''Details'''
'''Details'''


* '''Description:''' 44 years of hourly weather data (1979 - 2023) in csv and sqlite formats for racing circuits around the world
* '''Download Weather Data:'''
* '''Download Weather Data:'''
** [http://simwiki.net/files/weather-files-csv.zip CSV Version] - Original CSV files, one for each location
** [http://simwiki.net/files/weather-files-csv.zip CSV Version] - Original CSV files, one for each location
Line 45: Line 46:
*** Tables: weather, weather_days, weather_months
*** Tables: weather, weather_days, weather_months
*** See sample schema and data for sqlite databases below
*** See sample schema and data for sqlite databases below
* '''Description:''' 44 years of hourly weather data (1979 - 2023) for racing circuits around the world
* '''Source:''' [https://openweathermap.org/history-bulk OpenWeatherMap.org History Bulk]
** [https://openweathermap.org/history-bulk#parameter Description of parameters]
** [https://openweathermap.org/weather-conditions Weather codes and icons referenced in data]
** [https://openweather.co.uk/storage/app/media/Terms/Openweather_terms_and_conditions_of_sale.pdf OpenWeatherMap.org Terms and Conditions of Sale] ([https://simwiki.net/files/Openweather_terms_and_conditions_of_sale.pdf Backup Link])
* '''License:'''
** See '''license.txt''' in downloads for full details
** Downloads are licensed under Creative Commons Attribution-NonCommercial 4.0 International.
*** You don't have to ask permission for legitimate uses. You just have to give credit.
** OpenWeatherMap weather data is licensed under [https://opendatacommons.org/licenses/odbl/1-0/ Open Data Commons Open Database License (ODbL) v1.0] ([https://opendatacommons.org/licenses/odbl/summary/ 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.
* '''Format:''' CSV, one file per location
* '''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
* '''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
Line 107: Line 117:
** Zhuhai International Circuit
** Zhuhai International Circuit
** Zolder, Circuit
** Zolder, Circuit
* '''Source:''' [https://openweathermap.org/history-bulk OpenWeatherMap.org History Bulk]
** [https://openweathermap.org/history-bulk#parameter Description of parameters]
** [https://openweathermap.org/weather-conditions Weather codes and icons referenced in data]
** [https://openweather.co.uk/storage/app/media/Terms/Openweather_terms_and_conditions_of_sale.pdf OpenWeatherMap.org Terms and Conditions of Sale] ([https://simwiki.net/files/Openweather_terms_and_conditions_of_sale.pdf Backup Link])
* '''License:''' OpenWeatherMap weather database files are licensed under [https://opendatacommons.org/licenses/odbl/1-0/ Open Data Commons Open Database License (ODbL) v1.0] ([https://opendatacommons.org/licenses/odbl/summary/ 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'''
'''Sample of Files in the Data'''

Revision as of 18:22, 2 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 much more, making for more immersive, varied, and interesting weather experiences.

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:

  1. Date range: 1979-01-01 to 2023-12-31
  2. Weather Parameters: All
  3. Units: Kelvin
  4. File Format: CSV
  5. Download: File per location

Like this:

Openweathermap-24062901.png

Details

  • Description: 44 years of hourly weather data (1979 - 2023) in csv and sqlite formats for racing circuits around the world
  • Download Weather Data:
    • CSV Version - Original CSV files, one for each location
      • Use 7zip to extract the gzipped .csv.gz files found in the download.
    • SQLite Version - SQLite databases, imported from original CSV files, one 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
  • Source: OpenWeatherMap.org History Bulk
  • License:
    • See license.txt in downloads for full details
    • Downloads are licensed under Creative Commons Attribution-NonCommercial 4.0 International.
      • You don't have to ask permission for legitimate uses. You just have to give credit.
    • OpenWeatherMap weather data is 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.
  • 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

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