New data formats to get OPERA weather radars #73
Description
News from @leijnse that may be beneficial for our weather_radars() function:
The OPERA database was just updated so that it is now possible to download the information about OPERA radars from the database in JSON, JSON ARH, XLSX, and CSV formats.
How does it compare?
File paths
We currently use:
The new paths are:
The new path for the active database has a date (2025-02-24), meaning that path might change over time 😕
Columns
The new CSV is only available for the active database and also has a date in its path: Data/OPERA_RADARS_DB_24022025.csv
The columns returned for the CSV are similar to the json file, but with extra information in the column name (such as units):
library(getRad)
library(readr)
function_df <- weather_radars(source = "opera")
csv_df <- read_csv("https://www.eumetnet.eu/wp-content/themes/aeron-child/observations-programme/current-activities/opera/database/OPERA_Database/Data/OPERA_RADARS_DB_24022025.csv")
#> Rows: 219 Columns: 25
#> ── Column specification ────────────────────────────────────────────────────────
#> Delimiter: ","
#> chr (11): Country, Country ID (CCCCii), Old Country ID, WIGOS Station Identi...
#> dbl (11): Number, WMO Code, Opera Status, Longitude, Height of station (m), ...
#> lgl (3): Available for Stratus (min), Available for Cirrus/Nimbus (min), WR...
#>
#> ℹ Use `spec()` to retrieve the full column specification for this data.
#> ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
colnames(function_df)
#> [1] "radar" "number" "country" "countryid"
#> [5] "oldcountryid" "wmocode" "wigosid" "odimcode"
#> [9] "location" "status" "latitude" "longitude"
#> [13] "heightofstation" "band" "doppler" "polarization"
#> [17] "maxrange" "startyear" "heightantenna" "diameterantenna"
#> [21] "beam" "gain" "frequency" "stratus"
#> [25] "cirusnimbus" "wrwp" "finishyear" "singlerrr"
#> [29] "compositerrr" "origin" "source"
colnames(csv_df)
#> [1] "Number" "Country"
#> [3] "Country ID (CCCCii)" "Old Country ID"
#> [5] "WMO Code" "WIGOS Station Identifier"
#> [7] "ODIM code" "Location"
#> [9] "Opera Status" "Latitude"
#> [11] "Longitude" "Height of station (m)"
#> [13] "Band" "Doppler"
#> [15] "Polarization" "Max Range (km)"
#> [17] "Start Year" "Height Antenna (m)"
#> [19] "diameterantenna" "Beam"
#> [21] "Gain (dB)" "Frequency (GHz)"
#> [23] "Available for Stratus (min)" "Available for Cirrus/Nimbus (min)"
#> [25] "WRWP (min)"Created on 2025-05-23 with reprex v2.1.1
| weather_radars() | csv file | example |
|---|---|---|
| radar | bezav | |
| number | Number | 1128 |
| country | Country | Belgium |
| countryid | Country ID (CCCCii) | EBUM40 |
| oldcountryid | Old Country ID | BX40 |
| wmocode | WMO Code | 6451 |
| wigosid | WIGOS Station Identifier | |
| odimcode | ODIM code | bezav |
| location | Location | Zaventem |
| status | Opera Status | 0 |
| latitude | Latitude | 50.9054 |
| longitude | Longitude | 4.4579 |
| heightofstation | Height of station (m) | |
| band | Band | C |
| doppler | Doppler | TRUE |
| polarization | Polarization | S |
| maxrange | Max Range (km) | 240 |
| startyear | Start Year | 2003 |
| heightantenna | Height Antenna (m) | 73.0 |
| diameterantenna | Diameterantenna | 4.3 |
| beam | Beam | 0.950 |
| gain | Gain (dB) | 43.9 |
| frequency | Frequency (GHz) | 5.620 |
| stratus | Available for Stratus (min) | |
| cirusnimbus | Available for Cirrus/Nimbus (min) | |
| wrwp | WRWP (min) | |
| finishyear | ||
| singlerrr | ||
| compositerrr | ||
| origin | main | |
| source | opera |