Weather Data: Difference between revisions

From Simwiki.net
Jump to navigation Jump to search
Line 42: Line 42:
* '''Description:''' 44 years of hourly weather data (1979 - 2023) in csv and sqlite formats for racing circuits around the world
* '''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:'''
** [https://simwiki.net/files/weather-files-csv.zip CSV Version (1GB)] - Original CSV files, one for each location
** [https://1drv.ms/u/s!AqWsLwV2vzN8h_tZ5EvVdLYGTKJH4g?e=SfxcfB CSV Version (1.1 GB)] - Original CSV files, one for each location
*** Use [https://7-zip.org 7zip] to extract the gzipped '''.csv.gz''' files found in the download.
*** Use [https://7-zip.org 7zip] to extract the gzipped '''.csv.gz''' files found in the download.
** [https://simwiki.net/files/weather-sqlite-databases.zip SQLite Version (4GB)] - SQLite databases, imported from original CSV files, one for each location
** [https://simwiki.net/files/weather-sqlite-databases-pending.zip Pending: SQLite Version (4GB)] - 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
*** 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
*** Tables: weather, weather_days, weather_months

Revision as of 23:11, 5 October 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-09-19
- New locations added: Adria International Raceway, Castle Combe Circuit (Wiltshire, England), Grand Prix of Cleveland (Burke Lakefront Airport), Falkenbergs Motorbana, Gateway Motorsports Park (World Wide Technology Raceway), Circuito de Jerez, Ring Knutstorp, Mondello Park, MotorLand Aragón (Circuito de Alcañiz), Nelson Ledges Road Course, Salzburgring
- Improved real weather data weather states to improve preciseness of stats. For example, in meteorology, a Thunderstorm may or may not have Rain. So, stats were improved to be more precise in cases like this.

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, DOGE Dogecoin to DSMwwdHqJ3LMxPe1HiGgNKsWBY2jPi2RwW, or XRP Ripple to rGUoiGSjhsM14sPyePao1eqvjD6sXa1uLL 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 (1.1 GB) - Original CSV files, one for each location
      • Use 7zip to extract the gzipped .csv.gz files found in the download.
    • Pending: SQLite Version (4GB) - 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.
  • Parameters: See example data below
  • Locations:
    • All original GTR2 tracks and additional tracks
    • Adelaide Street Circuit
    • Adria International Raceway
    • Algarve (Portimao), Autódromo Internacional do
    • Anderstorp Racing Club
    • Assen, TT Circuit
    • AVUS (Grunewald)
    • Barcelona-Catalunya, Circuit de
    • Brands Hatch
    • Cadwell Park Circuit
    • Canadian Tire Motorsport Park (Mosport)
    • Carolina Motorsport Park
    • Castle Combe Circuit (Wiltshire, England)
    • Chang International Circuit
    • Cleveland, Grand Prix of (Burke Lakefront Airport)
    • Croft Circuit
    • Daytona Interational Speedway
    • Detroit Street Circuit
    • Donington Park Circuit
    • Dubai Autodrome
    • Enzo e Dino Ferrari (Imola), Autodromo
    • Falkenbergs Motorbana
    • Fernanda Pires da Silva (Estoril), Autódromo
    • Fuji Speedway
    • Gateway Motorsports Park (World Wide Technology Raceway)
    • Gilles Villeneuve (Montreal), Circuit
    • Goodwood Motor Circuit [Donated by Wingnut]
    • Helsinki Thunder
    • Hermanos Rodríguez (Mexico City), Autódromo
    • Hockenheimring Baden-Württemberg
    • Hungaroring
    • Indianapolis Motor Speedway
    • Ingliston Racing Circuit
    • Jarama, Circuito del
    • Jerez, Circuito de
    • José Carlos Pace (Interlagos), Autodromo
    • Knockhill Racing Circuit
    • Knutstorp, Ring
    • Kyalami Grand Prix Circuit
    • KymiRing [Shared with Helsinki Thunder]
    • Laguna Seca Raceway
    • Lausitzring
    • Lime Rock Park
    • Long Beach, Grand Prix
    • Macau Grand Prix (Guia Circuit)
    • Madonie (Targa Florio, Palermo), Circuito delle
    • Magny-Cours, Circuit de Nevers
    • Mallory Park Racing Circuit
    • Mantorp Park
    • Masaryk Circuit (Brno)
    • Miami International Autodrome
    • Mid-Ohio Sports Car Course
    • Motegi, Mobility Resort
    • Monaco, Circuit de
    • Mondello Park
    • Mont-Tremblant, Circuit
    • Monza, Autodromo Nazionale
    • Moscow Raceway
    • Most, Autodrom
    • MotorLand Aragón (Circuito de Alcañiz)
    • Oschersleben, Motorsport Arena
    • Mount Panorama Motor Racing Circuit (Bathurst)
    • Mugello Circuit
    • Nelson Ledges Road Course
    • Norisring
    • Nürburgring Grand-Prix Strecke
    • Oulton Park Circuit
    • Pau-Ville, Circuit de
    • Pergusa (Enna-Pergusa), Autodromo di
    • Phillip Island Grand Prix Circuit
    • Portland International Raceway
    • Red Bull Ring
    • Ricardo Tormo (Valencia), Circuit
    • Riverside International Raceway
    • Road America
    • Road Atlanta
    • Rockingham Motor Speedway (Corby, UK)
    • Sachsenring
    • Salzburgring
    • Sarthe (Le Mans), Circuit de la
    • Sebring International Raceway
    • Sepang International Circuit
    • Shanghai International Circuit
    • Silverstone Circuit
    • Slovakia Ring, Automotodróm
    • Snetterton Circuit
    • Sonoma Raceway
    • Spa-Francorchamps, Circuit de
    • Suzuka International Racing Course
    • Thruxton Circuit
    • Virginia International Raceway (VIR)
    • Watkins Glen International
    • Willow Springs International Motorsports Park
    • Zandvoort, Circuit
    • Zhejiang International Circuit
    • Zhuhai International Circuit
    • Zolder, Circuit

Sample of Files in the CSV Download

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

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

-- Thruxton
sqlite> select * from weather_days limit 3;
dt_date,short_name,lat,lon,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,temp_day_stdev,temp_night_stdev,dry_clear_avg_factor,dry_cloudy_avg_factor,dry_lightclouds_avg_factor,dry_moderateclouds_avg_factor,dry_mostlycloudy_avg_factor,dry_overcast_avg_factor,rain_verylight_avg_factor,rain_storm_avg_factor,rain_thunderstorm_avg_factor
1979-01-01,Thruxton,51.206098,-1.608785,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",0.588749217431018,0.791862017365039,0.708333333333333,0.375,0.0833333333333334,0.0416666666666666,0.0833333333333334,0.166666666666667,0.0,0.0,0.0
1979-01-02,Thruxton,51.206098,-1.608785,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",1.75642702593529,0.970446008052703,0.875,0.666666666666667,0.208333333333333,0.333333333333333,0.125,0.0,0.0,0.0,0.0
1979-01-03,Thruxton,51.206098,-1.608785,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",0.866078696015738,2.12895194018943,0.333333333333333,0.791666666666667,0.125,0.0,0.0416666666666666,0.625,0.0,0.0,0.0

weather_months:

-- Thruxton
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,temp_day_stdev,temp_night_stdev,dry_clear_avg_factor,dry_cloudy_avg_factor,dry_lightclouds_avg_factor,dry_moderateclouds_avg_factor,dry_mostlycloudy_avg_factor,dry_overcast_avg_factor,rain_verylight_avg_factor,rain_storm_avg_factor,rain_thunderstorm_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.0833333333333333,0.0134408602150538,0.00134408602150538,1.1410909368453,1.32181526178296,0.30510752688172,0.494623655913978,0.0739247311827957,0.125,0.120967741935484,0.174731182795699,0.0793010752688172,0.0,0.0
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.0877976190476191,0.0416666666666667,0.00148809523809524,0.953094419627617,0.956404737844266,0.239583333333333,0.389880952380952,0.0446428571428571,0.126488095238095,0.0446428571428571,0.174107142857143,0.144345238095238,0.0,0.0
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.227150537634409,0.0470430107526882,0.00268817204301075,1.10409738988109,1.20270113849214,0.291666666666667,0.454301075268817,0.0698924731182796,0.14247311827957,0.111559139784946,0.130376344086022,0.081989247311828,0.0,0.0

Parameters:


Parameters

    city_name City name
    lat Geographical coordinates of the location (latitude)
    lon Geographical coordinates of the location (longitude)
    main
        main.temp Temperature
        main.temp_min Minimum temperature at the moment. This is deviation from temperature that is possible for large cities and megalopolises geographically expanded (use these parameter optionally).
        main.temp_max Maximum temperature at the moment. This is deviation from temperature that is possible for large cities and megalopolises geographically expanded (use these parameter optionally).
        main.feels_like This temperature parameter accounts for the human perception of weather
        main.pressure Atmospheric pressure (on the sea level), hPa
        main.humidity Humidity, %
        main.dew_point Atmospheric temperature (varying according to pressure and humidity) below which water droplets begin to condense and dew can form. Units – default: kelvin
    wind
        wind.speed Wind speed. Units – default: meter/sec
        wind.deg Wind direction, degrees (meteorological)
        wind.gust Wind gust. Units – default: meter/sec
    clouds
        clouds.all Cloudiness, %
    rain
        rain.1h Rain volume for the last hour, mm
        rain.3h Rain volume for the last 3 hours, mm
    snow
        snow.1h Snow volume for the last hour, mm (in liquid state)
        snow.3h Snow volume for the last 3 hours, mm (in liquid state)
    weather (more info Weather condition codes)
        weather.id Weather condition id
        weather.main Group of weather parameters (Rain, Snow, Extreme etc.)
        weather.description Weather condition within the group. Please find more here
        weather.icon Weather icon id
    visibility Average visibility, metres. The maximum value of the visibility is 10km
    dt Time of data calculation, unix, UTC
    dt_isoDate and time in UTC format
    timezone Shift in seconds from UTC

Scratchpad:

- Batch 241001
  - Sportsland SUGO
  - Jeddah Corniche Circuit
  - Monteblanco, Circuito
  - Buenos Aires (Autódromo Oscar y Juan Gálvez)
  - Ezequiel Crisol (Bahia Blanca), Autódromo
  - Jacarepaguá, Rio de Janeiro (Autódromo Internacional Nelson Piquet, Autódromo Riocentro)
  - Curitiba, Autódromo Internacional de (Autódromo de Pinhais, Circuito Raul Boesel) [Address: Av. Iraí, nº 16, Pinhais, PR, Brazil]
  - Tsukuba Circuit
  - Autopolis International Racing Course
  - Termas de Río Hondo, Autódromo

- Batch 241101
  - Santa Cruz do Sul, Autódromo Internacional de
  - Brasilia BRB, Autódromo (Autódromo Internacional Nelson Piquet, Autódromo Emilio Medici, Autódromo de Brasília)
  - Goiânia (Autódromo Internacional Ayrton Senna)
  - Ibarra (Autódromo Internacional José Tobar, Autodromo Internacional de Yahuarcocha)
  - Charade, Circuit de (Circuit Louis Rosier, Circuit Clermont-Ferrand)
  - Gelleråsen Arena (Karlskoga Motorstadion)
  - Vålerbanen
  - Tarumã
  - Salvador (Circuito Ayrton Senna?)
  - Velopark

- Batch 241201
  - Circuito de Cartagena

Scratched:
- Azure Circuit [Scratch: Fantasy Circuit]
- Bilster Berg Drive Resort [Scratch: No GTR2 track]
- Córdoba (Autódromo Oscar Cabalén) [Scratch: No GTR2 track]
- Kansai aka Suzuka(?) [Scratch: No GTR2 track]
- Ningbo International Circuit [Scratch: No GTR2 track]
- Stowe Circuit ("The Stowe configuration is located on the infield of Silverstone.") [Scratch: It's just a Silverstone configuration]
- Velo Cittá, Autódromo [Mogi Guaçu, São Paulo, Brazil] [Scratch: No GTR2 track]
- Zhejiang International Circuit [Scratch: No GTR2 track]

AMS2 Tracks for GTR2 Real Weather 240705:
- Ascari, Circuito 
- Ascurra
- Buskerud / Lyngas RX Rallycross (?)
- Campo Grande
- Cascais
- Cascavel
- Curvelo
- Fontana
- Foz
- Galeao Airport
- Granja Viana
- Guaporé
- Londrina
- Ortona (Kart)
- Speedland (Kart)
- Tykki (RallyX)

Other: