Appropriate data from the .nc file, such as time, coordinates and temperature values, were extracted and converted into .csv format. This was due to the accessible format of .csv files. Csv files are commonly used for the storage and distribution of data. Analysis of the ERA5 was initiated once in this format. Originally two variables were selected for analysis (2m temperature and surface pressure), however upon initiation of analysis, a single variable, temperature, proved to be sufficient.
Each coordinate within a quarter degree of the chosen window (latitude 49–50° and longitude 8–9°) was extracted and assigned to a variable name. This allowed for individual analysis per coordinate or location. The quality and distribution for each location was then assessed. For the purposes of reanalysis in this study, the city of Frankfurt was divided into 25 distinct locations, which are tabulated below:
Table 1: Co-ordinates of each of the 25 locations in nearby regions to Frankfurt
Station location | Longitude | Latitude | Name of location |
01 | 8°E | 50°N | Oestrich - Winkel |
02 | 8.25°E | 50°N | Mainz |
03 | 8.5° E | 50° N | Hasslock (East) |
04 | 8.75° E | 50° N | Gotzehain |
05 | 9° E | 50° N | Zellhausen |
06 | 8° E | 49.75°N | Nack (Northwest) |
07 | 8.25° E | 49.75°N | Dittelsheim-Hessloch |
08 | 8.5° E | 49.75°N | Gernsneim |
09 | 8.75° E | 49.75°N | Webern |
10 | 9° E | 49.75°N | Nack (North) |
11 | 8° E | 49.5°N | Hertlinghausen (West) |
12 | 8.25° E | 49.5°N | Weisenheim am Sand |
13 | 8.5° E | 49.5°N | Wohlgelegen |
14 | 8.75° E | 49.5°N | Lampenhain (West) |
15 | 9°E | 49.5°N | Soitzberg |
16 | 8°E | 49.25°N | Dernbach |
17 | 8.25°E | 49.25°N | Oberlustadt |
18 | 8.5°E | 49.25°N | Waghausel |
19 | 8.75°E | 49.25°N | Muhlhausen |
20 | 9°E | 49.25°N | Ehrstadt (North East) |
21 | 8°E | 49°N | Schleithal (North West) |
22 | 8.25°E | 49°N | Neuburg am Rhein |
23 | 8.5°E | 49°N | Grotzingen |
24 | 8.75°E | 49°N | Kleinvillars |
25 | 9°E | 49°N | Hohenhaslach |