Weather Data: Difference between revisions
(10 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 | - Cascavel, Autódromo de aka Autódromo Internacional Zilmar Beux de Cascavel (Cascavel, Paraná, Brazil) | ||
- Ibarra | - Ibarra aka Autódromo Internacional José Tobar aka Autodromo Internacional de Yahuarcocha (Ibarra, Ecuador) | ||
- Summit Point Raceway | - 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) | |||
- Barbagallo | - Gold Coast aka Surfers Paradise Street Circuit (Surfers Paradise, Queensland) | ||
- Hamilton Street Circuit (Hamilton, New Zealand) | |||
- Hampton Downs Motorsport Park (North Waikato, New Zealand) | |||
- Calder Park | - Hidden Valley Raceway (Darwin, Northern Territory, Australia) | ||
- Canberra | - 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) | ||
- Concordia | - Wellington Street Circuit (Wellington City, Wellington, New Zealand) | ||
- General Roca ( | - Winton Motor Raceway (Winton, Victoria, Australia) | ||
- Paraná | - Concordia (Entre Ríos, Argentina) | ||
- Resistencia | - General Roca (Rio Negro, Argentina) | ||
- Paraná (Entre Ríos, Argentina) | |||
- Rosario ( | - Resistencia aka Autodromo Santiago Yaco Guarnieri (Resistencia, Chaco, Argentina) | ||
- Salta | - 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 | |||
</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:
- Date range: 1979-01-01 to 2023-12-31
- Weather Parameters: All
- Units: Kelvin
- File Format: CSV
- Download: File per location
Like this:
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
- CSV Version (1.2 GB) - Original CSV files, one for each location
- 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