Weather Data: Difference between revisions

From Simwiki.net
Jump to navigation Jump to search
 
(9 intermediate revisions by the same user not shown)
Line 50: Line 50:
*** 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
* '''Discussion:''' [https://www.simwiki.net/forums/viewtopic.php?p=4 Click here to discuss]
* '''Source:''' [https://openweathermap.org/history-bulk OpenWeatherMap.org History Bulk]
* '''Source:''' [https://openweathermap.org/history-bulk OpenWeatherMap.org History Bulk]
** [https://openweathermap.org/history-bulk#parameter Description of parameters]
** [https://openweathermap.org/history-bulk#parameter Description of parameters]
Line 95: Line 96:
** Carolina Motorsport Park
** Carolina Motorsport Park
** Cartagena, Circuito de (Spain)
** Cartagena, Circuito de (Spain)
** Cacá Bueno Circuit (Galeao Airport; Rio de Janeiro, Brazil) [Shared with Jacarepaguá]
** Cascais [Shared with Estoril]
** Castle Combe Circuit (Wiltshire, England)
** Castle Combe Circuit (Wiltshire, England)
** Chang International Circuit
** Chang International Circuit
Line 173: Line 176:
** Suzuka International Racing Course
** Suzuka International Racing Course
** Tarumã, Autódromo Internacional de
** Tarumã, Autódromo Internacional de
** Termas de Río Hondo, Autódromo
** Termas de Río Hondo, Autódromo (Termas de Río Hondo, Santiago del Estero, Argentina)
** Thruxton Circuit
** Thruxton Circuit
** Tsukuba Circuit
** Tsukuba Circuit
Line 309: Line 312:
- Batch 241201
- Batch 241201
   - Paul Ricard, Circuit
   - Paul Ricard, Circuit
   - Cascavel, Autódromo de (Autódromo Internacional Zilmar Beux de Cascavel)
   - Cascavel, Autódromo de aka Autódromo Internacional Zilmar Beux de Cascavel (Cascavel, Paraná, Brazil)
   - Ibarra (Autódromo Internacional José Tobar, Autodromo Internacional de Yahuarcocha)
   - Ibarra aka Autódromo Internacional José Tobar aka Autodromo Internacional de Yahuarcocha (Ibarra, Ecuador)
   - Summit Point Motorsports Park (Summit Point Raceway)
   - Summit Point Motorsports Park aka Summit Point Raceway (Summit Point, WV, USA)
     - Circuits: Summit Point Main, Jefferson Circuit, Shenandoah Circuit,
     - Circuits: Summit Point Main, Jefferson Circuit, Shenandoah Circuit,
       Washington Circuit
       Washington Circuit
   - Guaporé
   - Guaporé, Autódromo Internacional de (Guaporé, Rio Grande do Sul, Brazil)
   - Fontana (Auto Club Speedway, California Speedway
   - Fontana aka Auto Club Speedway aka California Speedway (Fontana, California, USA)
   - Ascari, Circuito (Ronda, Málaga, Spain)
   - Ascari, Circuito (Ronda, Málaga, Spain)
   - Boavista, Circuito da (Porto, Portugal)
   - Boavista, Circuito da (Porto, Portugal)
   - Dehesa Alcolea, Auto Club La
   - Dehesa Alcolea, Auto Club La (Alcolea del Pinar, Guadalajara, Spain)
   - Maze Sea Circuit
   - Maze Sea Circuit (Maze, Nishikan-ku, Niigata-shi, Niigata-ken Japan)


- Batch 250101
- Batch 250101
Line 336: Line 339:
   - Eduardo Copello, Autódromo (El Zonda, San Juan, Argentina)
   - Eduardo Copello, Autódromo (El Zonda, San Juan, Argentina)
   - Autódromo San Luis (San Luis Potosí, México)
   - Autódromo San Luis (San Luis Potosí, México)
  - Ahvenisto Race Circuit aka Ahveniston Moottorirata (Hämeenlinna, Finland)
  - Alastaro Circuit (Virttaa, Loimaa, Finland)
  - Botniaring Racing Circuit (Southern Ostrobothnia, Jurva, Finland)
  - Keimola Motor Stadium aka Keimolan Moottorirata (Vantaa, Finland)
  - Kemora Circuit (Central Ostrobothnia, Veteli, Finland)
  - Motopark Raceway (Pieksämäki, Finland)
  - Seinäjoki Street Circuit (Kapernaumi, Seinäjoki City, Finland)
  - Taupo International Motorsport Park aka Bruce McLaren Motorsport Park (Broadlands Road, Taupō, New Zealand)
- Batch 250301
  - Amaroo Park [Shared with Eastern Creek]
  - Barbagallo Raceway aka Wanneroo Raceway aka CARCO.com.au Raceway (Wattle Avenue, Neerabup, Western Australia)
  - Calder Park Raceway (Melbourne, Victoria, Australia)
  - Canberra Street Circuit (Canberra, Australian Capital Territory, Australia)
  - Eastern Creek aka Sydney Motorsport Park (Eastern Creek, New South Wales)
  - Gold Coast aka Surfers Paradise Street Circuit (Surfers Paradise, Queensland)
  - Hamilton Street Circuit (Hamilton, New Zealand)
  - Hampton Downs Motorsport Park (North Waikato, New Zealand)
  - Hidden Valley Raceway (Darwin, Northern Territory, Australia)
  - Lakeside Park International Raceway (Kurwongbah, City of Moreton Bay, Queensland, Australia)
- Batch 250401
  - Mallala Motor Sport Park aka Mallala Race Circuit (Mallala, South Australia, Australia)
  - Manfeild aka Circuit Chris Amon aka Manfeild Autocourse (Feilding, New Zealand)
  - Oran Park Raceway (Narellan, New South Wales) [Shared with Eastern Creek]
  - Pukekohe Park Raceway (Pukekohe, New Zealand)
  - Queensland Raceway (Willowbank, Ipswich, Queensland)
  - Ruapuna aka Euromarque Motorsport Park (Christchurch, New Zealand)
  - Symmons Plains Raceway (Launceston, Tasmania)
  - Teretonga Park (Invercargill, New Zealand)
  - Timaru International Motor Raceway (Timaru, New Zealand)
- Batch 250501
  - Townsville Street Circuit aka Reid Park Street Circuit (Townsville, Queensland, Australia)
  - Wellington Street Circuit (Wellington City, Wellington, New Zealand)
  - Winton Motor Raceway (Winton, Victoria, Australia)
  - Concordia (Entre Ríos, Argentina)
  - General Roca (Rio Negro, Argentina)
  - Paraná (Entre Ríos, Argentina)
  - Resistencia aka Autodromo Santiago Yaco Guarnieri (Resistencia, Chaco, Argentina)
  - Rosario aka Batangas Racing Circuit (Barrio Maligaya, Rosario, Batangas, Philippines)
  - Salta aka Autódromo Martín Miguel de Güemes (Salta, Salta Province, Argentina)
  - Mar Del Plata, Autódromo Ciudad de (Mar del Plata, Buenos Aires, Argentina)
- Batch 250601
  - Guangdong International Circuit (Sihui, Zhaoqing, Guangdong Province, People's Republic of China)
  - Turagua Pancho Pepe Cróquer, Autódromo Internacional de (Turagua, Venezuela)
- Future Weather Locations
  * Start by ranking with ChatGPT for popularity in video games
  - Rallycross Tracks:
  - Foz (X Games Foz do Iguaçu Rallycross) [Rallycross]
    - Tykki [Rallycross]
  - Kart Track:
    - Buskerud [Kart]
    - Granja Viana (Kartódromo Internacional da Granja Viana) [Kart]
    - Lentola Karting Park
    - Londrina [Kart]
    - Ortona [Kart]
    - Speedland [Kart]


- Scratched Locations
- Scratched Locations
Line 344: Line 407:
     - Córdoba (Autódromo Oscar Cabalén)
     - Córdoba (Autódromo Oscar Cabalén)
     - Curvelo (Circuito dos Cristais)
     - Curvelo (Circuito dos Cristais)
    - José Muñiz, Autódromo (Río Gallegos, Provincia de Santa Cruz, Argentina)
     - Kansai aka Suzuka(?)
     - Kansai aka Suzuka(?)
     - Ningbo International Circuit
     - Ningbo International Circuit
    - Rafaela, Autódromo Ciudad de (Rafaela, Santa Fe, Argentina)
    - San Martín aka Autódromo General San Martín aka Automóvil Club Comodorio Rivadavia (Comodoro Rivadavia, Chubut, Argentina)
     - Velo Cittá, Autódromo [Mogi Guaçu, São Paulo, Brazil]
     - Velo Cittá, Autódromo [Mogi Guaçu, São Paulo, Brazil]
     - Zhejiang International Circuit
     - Zhejiang International Circuit
   - Layout of Existing Circuit:
   - Layout of Existing Circuit:
     - Stowe Circuit ("The Stowe configuration is located on the infield of Silverstone.") [Scratch: It's just a Silverstone configuration]
     - Stowe Circuit (Layout at Silverstone)
   - Fantasy Track:
   - Fantasy Track:
    - Aorta, Citta Di
     - Azure Circuit
     - Azure Circuit
     - Aorta, Citta Di
     - Birubi Southern Cross
 
    - Troyton Raceway
AMS2 Tracks for GTR2 Real Weather 240705:
- Ascari, Circuito
- Ascurra
- Buskerud / Lyngas RX Rallycross (?)
- Campo Grande
- Cascais
- Curvelo
- Fontana
- Foz
- Galeao Airport
- Granja Viana
- Guaporé
- Londrina
- Ortona (Kart)
- Speedland (Kart)
- Tykki (RallyX)


Australian Tracks 241020
- Future To-Dos for Weather Locations
- As mentioned in this Australian&NewZealand Track Pack post: https://trackaholics.forumotion.com/t9095-australiannewzealand-track-pack#169166
  - KymiRing shares with Helsinki Thunder but is 108km away so could use it's
- _Taupo2005
    own weather at some point
- 06_Pukekohe_Park
- 2012_Ruapuna
- Adelaide2011
- Barbagallo
- Bathurst
- Birubi_SouthernCross
- Calder Park
- Canberra
- EasternCreek2012
- FVRGOLDCOAST09
- FVRHAMILTON10
- HamptonDowns
- HiddenValley
- LakesidePark
- Mallala
- Manfeild
- OranPark
- PhillipIsland
- Pukekohe2013
- Queensland2012
- Sydney
- SymmonsPlains
- Teretonga
- Timaru
- Townsville2012
- TroytonRaceway
- Wellington
- Winton


Finnish Tracks 241020
- Australian Tracks 241020
- As mentioned in the Finnish Track Pack post: https://trackaholics.forumotion.com/t2093-finnish-track-pack?highlight=pack
  - As mentioned in this Australian&NewZealand Track Pack post: https://trackaholics.forumotion.com/t9095-australiannewzealand-track-pack#169166
- Ahvenisto
  - Processed 241115
- Alastaro
- Botniaring
- Helsinki Thunder
- Keimola
- Kemora
- Lentola
- Motopark Raceway
- Nokia Finnish F1 Grand Prix
- Seinäjoki


Argentia Tracks 241025
- Finnish Tracks 241020
- As mentioned in the Pistas Argentinas Track Pack post: https://trackaholics.forumotion.com/t9101-pistas-argentinas-trackpack?highlight=pistas
  - As mentioned in the Finnish Track Pack post: https://trackaholics.forumotion.com/t2093-finnish-track-pack?highlight=pack
- Concordia
  - Processed 241115
- General Roca (2 layouts)
- Paraná
- Resistencia
- Rio Gallegos
- Rosario (2 layouts)
- Salta
- San Martín


Other:
- Argentia Tracks 241025
...
  - As mentioned in the Pistas Argentinas Track Pack post: https://trackaholics.forumotion.com/t9101-pistas-argentinas-trackpack?highlight=pistas
  - Processed 241115
</nowiki></pre>
</nowiki></pre>

Latest revision as of 03:12, 20 November 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-11-04
- New locations supported: Autódromo Brasilia BRB, Circuito de Cartagena, Circuit de Charade, Gelleråsen Arena (Karlskoga Motorstadion), Goiânia, Salvador (Circuito Ayrton Senna aka CAB Circuit), Autódromo Internacional de Santa Cruz do Sul, Autódromo Internacional de Tarumã, Vålerbanen, Velopark
- Fixed: In the previous release (2024-10-05), only new tracks had migrated data in sqlite databases. Fully migrated sqlite databases will be published in the next release.
- Fixed: Visibility wasn't properly migrated as visibility data had gaps of zero records. It now uses an average when the data is missing.

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.

See SHO Weather Generator if you're interested in the scripts that generate weather scenario files based on this real weather data.

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.2 GB) - Original CSV files, one for each location
      • Use 7zip to extract the gzipped .csv.gz files found in the download.
    • SQLite Version (4.9 GB) - 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
  • Discussion: Click here to discuss
  • 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

Tracks Already Supported

  • All Original GTR2 Tracks:
    • Anderstorp Racing Club
    • Barcelona-Catalunya, Circuit de
    • Brno (Masaryk Circuit)
    • Donington Park Circuit
    • Dubai Audodrome
    • Enna-Pergusa (Autodromo di Pergusa)
    • Estoril (Autódromo Fernanda Pires da Silva)
    • Hockenheimring Baden-Württemberg
    • Imola (Autodromo Enzo e Dino Ferrari)
    • Magny-Cours (Circuit de Nevers Magny-Cours)
    • Monza, Autodromo Nazionale
    • Oschersleben, Motorsport Arena
    • Spa-Francorchamps, Circuit de
    • Valencia (Circuit Ricardo Tormo)
    • Zhuhai International Circuit
  • Extra Tracks:
    • Adelaide Street Circuit
    • Adria International Raceway
    • Algarve (Portimao), Autódromo Internacional do
    • Assen, TT Circuit
    • Autopolis International Racing Course
    • AVUS (Grunewald)
    • Bahia Blanca (Ezequiel Crisol, Autódromo)
    • Brands Hatch
    • Brasilia BRB, Autódromo (Autódromo Internacional Nelson Piquet, Autódromo Emilio Medici, Autódromo de Brasília)
    • Buenos Aires (Autódromo Oscar y Juan Gálvez)
    • Cadwell Park Circuit
    • Canadian Tire Motorsport Park (Mosport)
    • Carolina Motorsport Park
    • Cartagena, Circuito de (Spain)
    • Cacá Bueno Circuit (Galeao Airport; Rio de Janeiro, Brazil) [Shared with Jacarepaguá]
    • Cascais [Shared with Estoril]
    • Castle Combe Circuit (Wiltshire, England)
    • Chang International Circuit
    • Charade, Circuit de (Circuit Louis Rosier, Circuit Clermont-Ferrand)
    • Cleveland, Grand Prix of (Burke Lakefront Airport)
    • Croft Circuit
    • Curitiba, Autódromo Internacional de (Autódromo de Pinhais, Circuito Raul Boesel) [Address: Av. Iraí, nº 16, Pinhais, PR, Brazil]
    • Daytona Interational Speedway
    • Detroit Belle Isle [Shared with Detroit Street Circuit]
    • Detroit Street Circuit
    • Falkenbergs Motorbana
    • Fuji Speedway
    • Gateway Motorsports Park (World Wide Technology Raceway)
    • Gelleråsen Arena (Karlskoga Motorstadion)
    • Gilles Villeneuve (Montreal), Circuit
    • Goiânia (Autódromo Internacional Ayrton Senna)
    • Goodwood Motor Circuit [Donated by Wingnut]
    • Helsinki Thunder
    • Hermanos Rodríguez (Mexico City), Autódromo
    • Hungaroring
    • Indianapolis Motor Speedway
    • Ingliston Racing Circuit
    • Interlagos (Autódromo José Carlos Pace)
    • Jacarepaguá, Rio de Janeiro (Autódromo Internacional Nelson Piquet, Autódromo Riocentro)
    • Jarama, Circuito del
    • Jeddah Corniche Circuit
    • Jerez, Circuito de
    • 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
    • Mallory Park Racing Circuit
    • Mantorp Park
    • Miami International Autodrome
    • Mid-Ohio Sports Car Course
    • Monaco, Circuit de
    • Mondello Park
    • Mont-Tremblant, Circuit
    • Monteblanco, Circuito (Huelva, Spain)
    • Moscow Raceway
    • Most, Autodrom
    • Motegi, Mobility Resort
    • MotorLand Aragón (Circuito de Alcañiz)
    • 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
    • Phillip Island Grand Prix Circuit
    • Portland International Raceway (Oregon, USA)
    • Red Bull Ring
    • Riverside International Raceway
    • Road America
    • Road Atlanta
    • Rockingham Motor Speedway (Corby, UK)
    • Sachsenring
    • Salvador, Bahia, Brazil (Circuito Ayrton Senna aka CAB Circuit)
    • Salzburgring
    • Santa Cruz do Sul, Autódromo Internacional de
    • Sarthe (Le Mans), Circuit de la
    • Sebring International Raceway
    • Sepang International Circuit
    • Shanghai International Circuit
    • Shanghai Street Circuit [Shared with Shanghai International Circuit]
    • Silverstone Circuit
    • Slovakia Ring, Automotodróm
    • Snetterton Cicuit
    • Sonoma Raceway (Sears Point Raceway / Infineon Raceway)
    • SUGO, Sportsland
    • Suzuka International Racing Course
    • Tarumã, Autódromo Internacional de
    • Termas de Río Hondo, Autódromo (Termas de Río Hondo, Santiago del Estero, Argentina)
    • Thruxton Circuit
    • Tsukuba Circuit
    • Vålerbanen (Braskereidfoss, Norway)
    • Velopark (Nova Santa Rita, Rio Grande do Sul, Brazil)
    • Virginia International Raceway (VIR)
    • Watkins Glen International
    • Willow Springs International Motorsports Park
    • Zandvoort, Circuit
    • Zhejiang International Circuit
    • Zolder, Circuit

Releases

  • [2024-10-05]
    • New locations supported: Autopolis International Racing Course, Bahia Blanca (Ezequiel Crisol, Autódromo), Buenos Aires (Autódromo Oscar y Juan Gálvez), Autódromo Internacional de Curitiba (Autódromo de Pinhais, Circuito Raul Boesel), Jacarepaguá (Autódromo Internacional Nelson Piquet, Autódromo Riocentro), Jeddah Corniche Circuit, Circuito Monteblanco (Huelva, Spain), Sportsland SUGO, Autódromo Termas de Río Hondo, Tsukuba Circuit
    • Bug (2024-11-02): In the previous release (2024-10-05), only new tracks had migrated data in sqlite databases. Fully migrated sqlite databases will be published in the next release.
    • CSV Version (1.2 GB) - Original CSV files, one for each location
    • SQLite Version (4.9 GB) - SQLite databases, imported from original CSV files, one for each location
  • [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.
  • [2024-08-18]
    • New locations added: Carolina Motorsport Park, Chang International Circuit, Mantorp Park, Moscow Raceway, Most (Autodrom), Portland International Raceway, Sepang International Circuit, Slovakia Ring (Automotodróm), Sonoma Raceway, Zhejiang International Circuit
    • Fix for Spa which had bad temperature data
  • [2024-07-04]
    • New tracks added: Cadwell, Goodwood, Knockhill, Lausitzring, Pau-Ville, Rockingham (Corby, UK), Madonie (Targa Florio, Palermo)
  • [2024-06-27]
    • New tracks added: Assen, Jarama, Long Beach, Mugello, Norisring, Sachsenring, Thruxton

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 241201
  - Paul Ricard, Circuit
  - Cascavel, Autódromo de aka Autódromo Internacional Zilmar Beux de Cascavel (Cascavel, Paraná, Brazil)
  - Ibarra aka Autódromo Internacional José Tobar aka Autodromo Internacional de Yahuarcocha (Ibarra, Ecuador)
  - Summit Point Motorsports Park aka Summit Point Raceway (Summit Point, WV, USA)
    - Circuits: Summit Point Main, Jefferson Circuit, Shenandoah Circuit,
      Washington Circuit
  - Guaporé, Autódromo Internacional de (Guaporé, Rio Grande do Sul, Brazil)
  - Fontana aka Auto Club Speedway aka California Speedway (Fontana, California, USA)
  - Ascari, Circuito (Ronda, Málaga, Spain)
  - Boavista, Circuito da (Porto, Portugal)
  - Dehesa Alcolea, Auto Club La (Alcolea del Pinar, Guadalajara, Spain)
  - Maze Sea Circuit (Maze, Nishikan-ku, Niigata-shi, Niigata-ken Japan)

- Batch 250101
  - Nikko Circuit
  - Tokachi International Speedway (Takikubo, Sarabetsu, Hokkaido, Japan)
  - Hokkaido Speed Park (Shiraoi Circuit)
  - Mine Circuit, Mazda (Nishinihon)
  - Sendai Hi-Land Raceway (Aoba-ku, Sendai, Miyagi Prefecture, Japan)
  - Viedma, Autódromo Ciudad de
  - Gran Premio de Santa Fe (Santa Fe, Santa Fe Province, Argentina)
  - Lago Potrero de los Funes Circuit (San Luis, capital city of the San Luis Province, Argentina)
  - Ciudad de Oberá (Oberá, Misiones, Argentina)
  - Roberto José Mouras, Autódromo (La Plata, Argentina)

- Batch 250201
  - Eduardo Copello, Autódromo (El Zonda, San Juan, Argentina)
  - Autódromo San Luis (San Luis Potosí, México)
  - Ahvenisto Race Circuit aka Ahveniston Moottorirata (Hämeenlinna, Finland)
  - Alastaro Circuit (Virttaa, Loimaa, Finland)
  - Botniaring Racing Circuit (Southern Ostrobothnia, Jurva, Finland)
  - Keimola Motor Stadium aka Keimolan Moottorirata (Vantaa, Finland)
  - Kemora Circuit (Central Ostrobothnia, Veteli, Finland)
  - Motopark Raceway (Pieksämäki, Finland)
  - Seinäjoki Street Circuit (Kapernaumi, Seinäjoki City, Finland)
  - Taupo International Motorsport Park aka Bruce McLaren Motorsport Park (Broadlands Road, Taupō, New Zealand)

- Batch 250301
  - Amaroo Park [Shared with Eastern Creek]
  - Barbagallo Raceway aka Wanneroo Raceway aka CARCO.com.au Raceway (Wattle Avenue, Neerabup, Western Australia)
  - Calder Park Raceway (Melbourne, Victoria, Australia)
  - Canberra Street Circuit (Canberra, Australian Capital Territory, Australia)
  - Eastern Creek aka Sydney Motorsport Park (Eastern Creek, New South Wales)
  - Gold Coast aka Surfers Paradise Street Circuit (Surfers Paradise, Queensland)
  - Hamilton Street Circuit (Hamilton, New Zealand)
  - Hampton Downs Motorsport Park (North Waikato, New Zealand)
  - Hidden Valley Raceway (Darwin, Northern Territory, Australia)
  - Lakeside Park International Raceway (Kurwongbah, City of Moreton Bay, Queensland, Australia)

- Batch 250401
  - Mallala Motor Sport Park aka Mallala Race Circuit (Mallala, South Australia, Australia)
  - Manfeild aka Circuit Chris Amon aka Manfeild Autocourse (Feilding, New Zealand)
  - Oran Park Raceway (Narellan, New South Wales) [Shared with Eastern Creek]
  - Pukekohe Park Raceway (Pukekohe, New Zealand)
  - Queensland Raceway (Willowbank, Ipswich, Queensland)
  - Ruapuna aka Euromarque Motorsport Park (Christchurch, New Zealand)
  - Symmons Plains Raceway (Launceston, Tasmania)
  - Teretonga Park (Invercargill, New Zealand)
  - Timaru International Motor Raceway (Timaru, New Zealand)

- Batch 250501
  - Townsville Street Circuit aka Reid Park Street Circuit (Townsville, Queensland, Australia)
  - Wellington Street Circuit (Wellington City, Wellington, New Zealand)
  - Winton Motor Raceway (Winton, Victoria, Australia)
  - Concordia (Entre Ríos, Argentina)
  - General Roca (Rio Negro, Argentina)
  - Paraná (Entre Ríos, Argentina)
  - Resistencia aka Autodromo Santiago Yaco Guarnieri (Resistencia, Chaco, Argentina)
  - Rosario aka Batangas Racing Circuit (Barrio Maligaya, Rosario, Batangas, Philippines)
  - Salta aka Autódromo Martín Miguel de Güemes (Salta, Salta Province, Argentina)
  - Mar Del Plata, Autódromo Ciudad de (Mar del Plata, Buenos Aires, Argentina)

- Batch 250601
  - Guangdong International Circuit (Sihui, Zhaoqing, Guangdong Province, People's Republic of China)
  - Turagua Pancho Pepe Cróquer, Autódromo Internacional de (Turagua, Venezuela)

- Future Weather Locations
  * Start by ranking with ChatGPT for popularity in video games
  - Rallycross Tracks:
   - Foz (X Games Foz do Iguaçu Rallycross) [Rallycross]
    - Tykki [Rallycross]
  - Kart Track:
    - Buskerud [Kart]
    - Granja Viana (Kartódromo Internacional da Granja Viana) [Kart]
    - Lentola Karting Park
    - Londrina [Kart]
    - Ortona [Kart]
    - Speedland [Kart]

- Scratched Locations
  - No GTR2 Track:
    - Ascurra (Autódromo Max Mohr) [Dirt]
    - Bilster Berg Drive Resort
    - Campo Grande, Autódromo Internacional de
    - Córdoba (Autódromo Oscar Cabalén)
    - Curvelo (Circuito dos Cristais)
    - José Muñiz, Autódromo (Río Gallegos, Provincia de Santa Cruz, Argentina)
    - Kansai aka Suzuka(?)
    - Ningbo International Circuit
    - Rafaela, Autódromo Ciudad de (Rafaela, Santa Fe, Argentina)
    - San Martín aka Autódromo General San Martín aka Automóvil Club Comodorio Rivadavia (Comodoro Rivadavia, Chubut, Argentina)
    - Velo Cittá, Autódromo [Mogi Guaçu, São Paulo, Brazil]
    - Zhejiang International Circuit
  - Layout of Existing Circuit:
    - Stowe Circuit (Layout at Silverstone)
  - Fantasy Track:
    - Aorta, Citta Di
    - Azure Circuit
    - Birubi Southern Cross
    - Troyton Raceway

- Future To-Dos for Weather Locations
  - KymiRing shares with Helsinki Thunder but is 108km away so could use it's
    own weather at some point

- Australian Tracks 241020
  - As mentioned in this Australian&NewZealand Track Pack post: https://trackaholics.forumotion.com/t9095-australiannewzealand-track-pack#169166
  - Processed 241115

- Finnish Tracks 241020
  - As mentioned in the Finnish Track Pack post: https://trackaholics.forumotion.com/t2093-finnish-track-pack?highlight=pack
  - Processed 241115

- Argentia Tracks 241025
  - As mentioned in the Pistas Argentinas Track Pack post: https://trackaholics.forumotion.com/t9101-pistas-argentinas-trackpack?highlight=pistas
  - Processed 241115