Introduction to downloading time series data from waterinfo.be
Stijn Van Hoey
2026-09-29
Source:vignettes/wateRinfo.Rmd
wateRinfo.RmdIntroduction
The waterinfo.be API uses a
system of identifiers, called ts_id to define individual
time series. For example, the identifier ts_id = 78073042
corresponds to the time series of air pressure data for the measurement
station in Liedekerke, with a 15 min time resolution. Hence, the
ts_id identifier defines a variable of interest from a
measurement station of interest with a specific frequency (e.g. 15 min,
hourly,…). The knowledge of the proper identifier is essential to be
able to download the corresponding data.
Download with known ts identifier
In case you already know the ts_id identifier that
defines your time serie, the package provides the function
get_timeseries_tsid() to download a specific period of the
time series.
As an example, to download the air pressure time series data of
Liedekerke with a 15 min resolution (ts_id = 78073042) for
the first of January 2016:
my_data <- get_timeseries_tsid("78073042", from = "2016-01-01", to = "2016-01-02")
knitr::kable(head(my_data), align = "lcc")| Timestamp | Value | Quality Code |
|---|---|---|
| 2015-12-31 23:00:00 | 1020.9 | 130 |
| 2015-12-31 23:15:00 | 1021.0 | 130 |
| 2015-12-31 23:30:00 | 1021.1 | 130 |
| 2015-12-31 23:45:00 | 1021.2 | 130 |
| 2016-01-01 00:00:00 | 1021.3 | 130 |
| 2016-01-01 00:15:00 | 1021.5 | 130 |
For more information on defining the date period of the download, see
this
vignette. Let’s have a visual check of our data, using the
ggplot2 package:
As such, knowing the identifier is the most straightforward way of
downloading a time series. In order to find these ts_id
identifier, the package supports looking for identifiers based on a
supported variable name (limited set of supported variables by VMM) or
looking for identifiers by checking all variables for an individual
station. These methods are explained in the next sections.
Search identifier based on variable name
For a number of variables, the documentation
of the waterinfo.be API provides a direct overview option of all
available VMM measurement stations, using the so-called
Timeseriesgroup_id. For these variables, the package
provides the function get_stations() to download an
overview of available measurement stations and the related
ts_id identifiers. The latter can be used to download the time
series.
get_stations("air_pressure")## ts_id station_latitude station_longitude station_id station_no
## 1 78124042 51.20300 5.439589 12213 ME11_002
## 2 78039042 51.24379 4.266912 12208 ME04_001
## 3 78005042 51.02263 2.970584 12206 ME01_003
## 4 78073042 50.88663 4.094898 12210 ME07_006
## 5 78107042 51.16224 4.845708 12212 ME10_011
## 6 265106042 51.21839 3.232655 380308 HITTE_T4BB28001
## 7 264266042 50.92801 5.334829 379589 HITTE_T2HS11001
## 8 78022042 51.27226 3.728299 12207 ME03_017
## 9 78056042 50.86149 3.411318 12209 ME05_019
## 10 78090042 50.73795 5.141976 12211 ME09_012
## 11 258220042 51.13194 4.572651 369510 HITTE_T2LR03001
## 12 258290042 51.17392 4.611708 369524 HITTE_T2RN01001
## station_name stationparameter_name parametertype_name
## 1 Overpelt_ME Pa Pa
## 2 Melsele_ME Pa Pa
## 3 Zarren_ME Pa Pa
## 4 Liedekerke_ME Pa Pa
## 5 Herentals_ME Pa Pa
## 6 Brugge_ALMC Pa Pa
## 7 Hasselt2_ALMC Pa Pa
## 8 Boekhoute_ME Pa Pa
## 9 Waregem_ME Pa Pa
## 10 Niel-bij-St.-Truiden_ME Pa Pa
## 11 Lier_ALMC Pa Pa
## 12 Ranst_ALMC Pa Pa
## ts_unitsymbol dataprovider
## 1 hPa VMM
## 2 hPa VMM
## 3 hPa VMM
## 4 hPa VMM
## 5 hPa VMM
## 6 hPa VMM
## 7 hPa VMM
## 8 hPa VMM
## 9 hPa VMM
## 10 hPa VMM
## 11 hPa VMM
## 12 hPa VMMBy default, the expected frequency is the 15 min frequency of the
time series. However, for some of the variables, multiple frequencies
are supported by the API. The package provides a check on the supported
variables and frequencies. An overview of the currently supported
variables can be requested with the command
supported_variables() (either in Dutch, nl, or
in English, en). Actually, more variables are available
with the API (see next section), but for each of these variables the
get_stations() function is supported (i.e. the
Timeseriesgroup_id is documented by VMM).
supported_variables("en") %>%
as.list()## $variable_en
## [1] "discharge" "soil_saturation" "soil_moisture"
## [4] "dew_point_temperature" "ground_temperature" "ground_heat"
## [7] "irradiance" "air_pressure" "air_temperature_175cm"
## [10] "rainfall" "relative_humidity" "evaporation_monteith"
## [13] "evaporation_penman" "water_velocity" "water_level"
## [16] "water_temperature" "wind_direction" "wind_speed"To check which predefined frequencies are provided by the
waterinfo.be API for a given variable, the
supported_frequencies() function is available:
supported_frequencies(variable_name = "air_pressure")## [1] "15min"Hence, for air pressure data, only the 15 min resolution is supported. Compared to evaporation derived by the Monteith equation:
supported_frequencies(variable_name = "evaporation_monteith")## [1] "15min" "day" "month" "year"Multiple resolutions are available. Using the coarser time resolutions can be helpful when you want to download longer time series while keeping the number of records to download low (if the frequency would be sufficient for your analysis):
stations <- get_stations("evaporation_monteith", frequency = "year")
subset_of_columns <- stations %>% select(ts_id, station_no, station_name,
parametertype_name, ts_unitsymbol)
knitr::kable(subset_of_columns)| ts_id | station_no | station_name | parametertype_name | ts_unitsymbol |
|---|---|---|---|---|
| 94306042 | ME01_003 | Zarren_ME | PET | mm |
| 94526042 | ME10_011 | Herentals_ME | PET | mm |
| 94512042 | ME09_012 | Niel-bij-St.-Truiden_ME | PET | mm |
| 94540042 | ME11_002 | Overpelt_ME | PET | mm |
| 94470042 | ME04_001 | Melsele_ME | PET | mm |
| 94498042 | ME07_006 | Liedekerke_ME | PET | mm |
| 94484042 | ME05_019 | Waregem_ME | PET | mm |
| 94456042 | ME03_017 | Boekhoute_ME | PET | mm |
When interested in the data of Herentals_ME, we can use
the corresponding ts_id to download the time series of PET
with a yearly frequency and make a plot with ggplot:
pet_yearly <- get_timeseries_tsid("94526042", period = "P10Y")
pet_yearly %>%
na.omit() %>%
ggplot(aes(Timestamp, Value)) +
geom_bar(stat = "identity") +
scale_x_datetime(date_labels = "%Y", date_breaks = "1 year") +
xlab("") + ylab("PET Herentals (mm)")
See this
vignette to understand the period = "P10Y" format.
Remark: the get_stations() function
only works for those measurement stations belonging to the VMM
meetnet (network), related to the so-called
datasource = 1. For other
networks, i.e. datasource = 4, the enlisting is not
supported. Still, a search for data is provided starting from a given
station name, as explained in the next section.
Search identifier based on station name
In addition to the option to check the measurement stations that can
provide data for a given variable, the package provides the function
get_variables() to get an overview of the available
variables for a given station, using the station_no. The
advantage compared to the ts_id is that these
station_no names are provided by the waterinfo.be website
itself when exploring the data. When clicking on a measurement station
on the map and checking the time series graph, the
station_no is provided in the upper left corner in between
brackets.
So, for the example in the figure,
i.e. station_no = zes42a-1066, the available time series
are retrieved by using the get_variables() command:
available_variables <- get_variables("zes42a-1066")## Use datasource: 4 for data requests of this station!## ts_id station_name ts_name
## 1 55421010 Sint-Amands tij/Zeeschelde HW.KD_NKD
## 2 55429010 Sint-Amands tij/Zeeschelde Pv.HW
## 3 55435010 Sint-Amands tij/Zeeschelde Pv.Lang
## 4 55440010 Sint-Amands tij/Zeeschelde HW.Hist
## 5 55442010 Sint-Amands tij/Zeeschelde Gaugings
## 6 55446010 Sint-Amands tij/Zeeschelde GaugingsDiff
## 7 55449010 Sint-Amands tij/Zeeschelde LW.tpk
## 8 140952010 Sint-Amands tij/Zeeschelde KalJaarGem.TVDT
## 9 113485010 Sint-Amands tij/Zeeschelde Astro.LW.tpk
## 10 113487010 Sint-Amands tij/Zeeschelde Astro.Pv.LW
## 11 139597010 Sint-Amands tij/Zeeschelde KalJaarGem.DaalST
## 12 139600010 Sint-Amands tij/Zeeschelde KalJaarGem.StijgST
## 13 139603010 Sint-Amands tij/Zeeschelde KalJaarGem.tovAntwHW
## 14 139624010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.tovVlisHWST
## 15 55414010 Sint-Amands tij/Zeeschelde O.Gaugings
## 16 55426010 Sint-Amands tij/Zeeschelde Kidigi
## 17 55432010 Sint-Amands tij/Zeeschelde O.LW.KD_NKD
## 18 55437010 Sint-Amands tij/Zeeschelde Pv.LW.Lang
## 19 55439010 Sint-Amands tij/Zeeschelde O.HWLW.Kidigi
## 20 55445010 Sint-Amands tij/Zeeschelde LW.typ
## 21 94251010 Sint-Amands tij/Zeeschelde AlarmStatus.O
## 22 140937010 Sint-Amands tij/Zeeschelde O.10jo_omzettingKD-NKD_TAW
## 23 140951010 Sint-Amands tij/Zeeschelde KalJaarGem.LWDT
## 24 140965010 Sint-Amands tij/Zeeschelde 10KalJaarGem.TV
## 25 140966010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.HWST.KD_NKD
## 26 140980010 Sint-Amands tij/Zeeschelde O.10KalJaarMax.HLW.KD_NKD
## 27 140982010 Sint-Amands tij/Zeeschelde O.10KalJaarMin.LLW.KD_NKD
## 28 88623010 Sint-Amands tij/Zeeschelde Astro.HWLW
## 29 112686010 Sint-Amands tij/Zeeschelde Astro.10
## 30 139599010 Sint-Amands tij/Zeeschelde KalJaarGem.Daal
## 31 139607010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.tovVlisLWDT
## 32 139617010 Sint-Amands tij/Zeeschelde KalJaarGem.tovAntwLWDT
## 33 55418010 Sint-Amands tij/Zeeschelde HW.KK
## 34 55433010 Sint-Amands tij/Zeeschelde Model
## 35 55438010 Sint-Amands tij/Zeeschelde HW.t-h.wdw
## 36 55441010 Sint-Amands tij/Zeeschelde LW.KD_NKD
## 37 58546010 Sint-Amands tij/Zeeschelde LW.hulp
## 38 140940010 Sint-Amands tij/Zeeschelde O.KalJaarGem.LW.KD_NKD
## 39 140955010 Sint-Amands tij/Zeeschelde O.KalJaarMin.LHW.KD_NKD
## 40 140959010 Sint-Amands tij/Zeeschelde O.KalJaarMin.LLW.KD_NKD
## 41 140962010 Sint-Amands tij/Zeeschelde 10KalJaarGem.HW
## 42 140963010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.LW.KD_NKD
## 43 140968010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.LWST.KD_NKD
## 44 140974010 Sint-Amands tij/Zeeschelde 10KalJaarGem.LWDT
## 45 140979010 Sint-Amands tij/Zeeschelde 10KalJaarMin.LHW
## 46 140981010 Sint-Amands tij/Zeeschelde 10KalJaarMax.HLW
## 47 113486010 Sint-Amands tij/Zeeschelde Astro.Pv.HW
## 48 139610010 Sint-Amands tij/Zeeschelde KalJaarGem.tovAntwLWST
## 49 139615010 Sint-Amands tij/Zeeschelde KalJaarGem.Stijg
## 50 139625010 Sint-Amands tij/Zeeschelde KalJaarGem.tovAntwLW
## 51 139626010 Sint-Amands tij/Zeeschelde KalJaarGem.tovAntwHWDT
## 52 55416010 Sint-Amands tij/Zeeschelde O.01b
## 53 55434010 Sint-Amands tij/Zeeschelde HWLW.Kidigi
## 54 55447010 Sint-Amands tij/Zeeschelde LW.KK
## 55 140958010 Sint-Amands tij/Zeeschelde KalJaarMax.HLW
## 56 139604010 Sint-Amands tij/Zeeschelde 10KalJaarGem.tovAntwLWST
## 57 139605010 Sint-Amands tij/Zeeschelde KalJaarGem.StijgDT
## 58 139608010 Sint-Amands tij/Zeeschelde 10KalJaarGem.tovAntwHW
## 59 139609010 Sint-Amands tij/Zeeschelde 10KalJaarGem.tovAntwLWDT
## 60 55423010 Sint-Amands tij/Zeeschelde GaugingsGDiff
## 61 55425010 Sint-Amands tij/Zeeschelde Pv.HWLW
## 62 55428010 Sint-Amands tij/Zeeschelde O.TerrainCorr
## 63 55448010 Sint-Amands tij/Zeeschelde Pv
## 64 140938010 Sint-Amands tij/Zeeschelde O.KalJaarGem.HW.KD_NKD
## 65 140942010 Sint-Amands tij/Zeeschelde KalJaarGem.TV
## 66 140943010 Sint-Amands tij/Zeeschelde O.KalJaarGem.HWST.KD_NKD
## 67 140950010 Sint-Amands tij/Zeeschelde O.KalJaarGem.LWDT.KD_NKD
## 68 140969010 Sint-Amands tij/Zeeschelde 10KalJaarGem.LWST
## 69 140971010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.HWDT.KD_NKD
## 70 140973010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.LWDT.KD_NKD
## 71 140975010 Sint-Amands tij/Zeeschelde 10KalJaarGem.TVDT
## 72 113484010 Sint-Amands tij/Zeeschelde Astro.HW.tpk
## 73 133445010 Sint-Amands tij/Zeeschelde HIC-ECMWF-2DNevla.O
## 74 139606010 Sint-Amands tij/Zeeschelde KalJaarGem.DaalDT
## 75 139618010 Sint-Amands tij/Zeeschelde 10KalJaarGem.Stijg
## 76 139623010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.tovVlisLWST
## 77 55415010 Sint-Amands tij/Zeeschelde RC
## 78 55427010 Sint-Amands tij/Zeeschelde LW.Hist
## 79 55430010 Sint-Amands tij/Zeeschelde Pv.LW
## 80 55436010 Sint-Amands tij/Zeeschelde Pv.HW.Lang
## 81 140939010 Sint-Amands tij/Zeeschelde KalJaarGem.HW
## 82 140946010 Sint-Amands tij/Zeeschelde KalJaarGem.LWST
## 83 140949010 Sint-Amands tij/Zeeschelde KalJaarGem.HWDT
## 84 140956010 Sint-Amands tij/Zeeschelde KalJaarMin.LHW
## 85 140960010 Sint-Amands tij/Zeeschelde KalJaarMin.LLW
## 86 140961010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.HW.KD_NKD
## 87 140977010 Sint-Amands tij/Zeeschelde 10KalJaarMax.HHW
## 88 112685010 Sint-Amands tij/Zeeschelde Astro.05
## 89 139602010 Sint-Amands tij/Zeeschelde 10KalJaarGem.tovAntwLW
## 90 139611010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.tovVlisHWDT
## 91 139612010 Sint-Amands tij/Zeeschelde 10KalJaarGem.tovAntwHWDT
## 92 139614010 Sint-Amands tij/Zeeschelde 10KalJaarGem.tovAntwHWST
## 93 139619010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.tovVlisLW
## 94 139621010 Sint-Amands tij/Zeeschelde O.10KalJaarGem.tovVlisHW
## 95 55424010 Sint-Amands tij/Zeeschelde Pv.05
## 96 55431010 Sint-Amands tij/Zeeschelde Base.Lang
## 97 140941010 Sint-Amands tij/Zeeschelde KalJaarGem.LW
## 98 140944010 Sint-Amands tij/Zeeschelde KalJaarGem.HWST
## 99 140945010 Sint-Amands tij/Zeeschelde O.KalJaarGem.LWST.KD_NKD
## 100 140947010 Sint-Amands tij/Zeeschelde KalJaarGem.TVST
## 101 140954010 Sint-Amands tij/Zeeschelde KalJaarMax.HHW
## 102 140957010 Sint-Amands tij/Zeeschelde O.KalJaarMax.HLW.KD_NKD
## 103 140967010 Sint-Amands tij/Zeeschelde 10KalJaarGem.HWST
## 104 140972010 Sint-Amands tij/Zeeschelde 10KalJaarGem.HWDT
## 105 140978010 Sint-Amands tij/Zeeschelde O.10KalJaarMin.LHW.KD_NKD
## 106 140983010 Sint-Amands tij/Zeeschelde 10KalJaarMin.LLW
## 107 84309010 Sint-Amands tij/Zeeschelde KT-Percentile.O
## 108 96961010 Sint-Amands tij/Zeeschelde KT-HW
## 109 96962010 Sint-Amands tij/Zeeschelde KT-LW
## 110 99870010 Sint-Amands tij/Zeeschelde KT-AlarmStatus-Max.O
## 111 113488010 Sint-Amands tij/Zeeschelde Astro.Pv.HWLW
## 112 139616010 Sint-Amands tij/Zeeschelde 10KalJaarGem.DaalST
## 113 139620010 Sint-Amands tij/Zeeschelde 10KalJaarGem.StijgST
## 114 55417010 Sint-Amands tij/Zeeschelde Base
## 115 55419010 Sint-Amands tij/Zeeschelde Pv.10
## 116 55420010 Sint-Amands tij/Zeeschelde HW.tpk
## 117 55422010 Sint-Amands tij/Zeeschelde HW.typ
## 118 55443010 Sint-Amands tij/Zeeschelde LW.rco
## 119 55444010 Sint-Amands tij/Zeeschelde LW.t-h.wdw
## 120 55450010 Sint-Amands tij/Zeeschelde O.HW.KD_NKD
## 121 140948010 Sint-Amands tij/Zeeschelde O.KalJaarGem.HWDT.KD_NKD
## 122 140953010 Sint-Amands tij/Zeeschelde O.KalJaarMax.HHW.KD_NKD
## 123 140964010 Sint-Amands tij/Zeeschelde 10KalJaarGem.LW
## 124 140970010 Sint-Amands tij/Zeeschelde 10KalJaarGem.TVST
## 125 140976010 Sint-Amands tij/Zeeschelde O.10KalJaarMax.HHW.KD_NKD
## 126 88620010 Sint-Amands tij/Zeeschelde Astro.01
## 127 89205010 Sint-Amands tij/Zeeschelde KT-det.O
## 128 96864010 Sint-Amands tij/Zeeschelde KT-Last
## 129 139598010 Sint-Amands tij/Zeeschelde 10KalJaarGem.DaalDT
## 130 139601010 Sint-Amands tij/Zeeschelde 10KalJaarGem.StijgDT
## 131 139613010 Sint-Amands tij/Zeeschelde KalJaarGem.tovAntwHWST
## 132 139622010 Sint-Amands tij/Zeeschelde 10KalJaarGem.Daal
## parametertype_name
## 1 W
## 2 W
## 3 W
## 4 W
## 5 W
## 6 W
## 7 W
## 8 W
## 9 W_voorspeld
## 10 W_voorspeld
## 11 TideD
## 12 TideD
## 13 TideD
## 14 TideD
## 15 W
## 16 W
## 17 W
## 18 W
## 19 W
## 20 W
## 21 W
## 22 W
## 23 W
## 24 W
## 25 W
## 26 W
## 27 W
## 28 W_voorspeld
## 29 W_voorspeld
## 30 TideD
## 31 TideD
## 32 TideD
## 33 W
## 34 W
## 35 W
## 36 W
## 37 W
## 38 W
## 39 W
## 40 W
## 41 W
## 42 W
## 43 W
## 44 W
## 45 W
## 46 W
## 47 W_voorspeld
## 48 TideD
## 49 TideD
## 50 TideD
## 51 TideD
## 52 W
## 53 W
## 54 W
## 55 W
## 56 TideD
## 57 TideD
## 58 TideD
## 59 TideD
## 60 W
## 61 W
## 62 W
## 63 W
## 64 W
## 65 W
## 66 W
## 67 W
## 68 W
## 69 W
## 70 W
## 71 W
## 72 W_voorspeld
## 73 W_voorspeld
## 74 TideD
## 75 TideD
## 76 TideD
## 77 W
## 78 W
## 79 W
## 80 W
## 81 W
## 82 W
## 83 W
## 84 W
## 85 W
## 86 W
## 87 W
## 88 W_voorspeld
## 89 TideD
## 90 TideD
## 91 TideD
## 92 TideD
## 93 TideD
## 94 TideD
## 95 W
## 96 W
## 97 W
## 98 W
## 99 W
## 100 W
## 101 W
## 102 W
## 103 W
## 104 W
## 105 W
## 106 W
## 107 W_voorspeld
## 108 W_voorspeld
## 109 W_voorspeld
## 110 W_voorspeld
## 111 W_voorspeld
## 112 TideD
## 113 TideD
## 114 W
## 115 W
## 116 W
## 117 W
## 118 W
## 119 W
## 120 W
## 121 W
## 122 W
## 123 W
## 124 W
## 125 W
## 126 W_voorspeld
## 127 W_voorspeld
## 128 W_voorspeld
## 129 TideD
## 130 TideD
## 131 TideD
## 132 TideDThe available number of variables depends on the measurement station.
The representation is not standardized and also depends on the type of
meetnet.
Nevertheless, one can derive the required ts_id from the
list when interpreting the field names. Remark that the datasource can
be 4 instead of 1 for specific meetnetten (networks). The
datasource to use is printed when asking the variables for a
station.
In order to download the 10 min time series water level data for the
station in Sint-Amands tij/Zeeschelde, the ts_id = 55419010
can be used in the get_timeseries_tsid() function, taking
into account the datasource = 4 (default is 1):
tide_stamands <- get_timeseries_tsid("55419010",
from = "2017-06-01", to = "2017-06-05",
datasource = 4)
ggplot(tide_stamands, aes(Timestamp, Value)) +
geom_line() + xlab("") + ylab("waterlevel")
For some measurement stations, the number of variables can be high
(lots of precalculated derivative values) and extracting the required
time series identifier is not always straightforward. For example, the
dat Etikhove/Schuif/Nederaalbeek (K06_221), provides the
following number of variables:
available_variables <- get_variables("K06_221")## Use datasource: 1 for data requests of this station!
nrow(available_variables)## [1] 109As the measured variables at a small time resolution are of most
interest, filtering on P.15 (or P.1,
P.60,…) will help to identify measured time series, for
those stations belonging to the meetnet of VMM
(datasource = 1):
available_variables <- get_variables("K06_221")## Use datasource: 1 for data requests of this station!## station_name station_no ts_id ts_name parametertype_name
## 1 Etikhove/Schuif/Nederaalbeek K06_221 22322042 P.15 H
## 2 Etikhove/Schuif/Nederaalbeek K06_221 31882042 P.15 Hk
## 3 Etikhove/Schuif/Nederaalbeek K06_221 84094042 P.15 Volume Wachtbekken
## 4 Etikhove/Schuif/Nederaalbeek K06_221 29156042 P.15 H
## 5 Etikhove/Schuif/Nederaalbeek K06_221 22302042 P.15 H
## stationparameter_name
## 1 Hopw
## 2 Hschuif
## 3 Volume_wachtbekken
## 4 Hafw 100m afwaarts
## 5 HafwLoading and visualizing the last day (period P1D) of
available data for the water level downstream (Hafw):
afw_etikhove <- get_timeseries_tsid("22302042",
period = "P1D",
datasource = 1) # 1 is default
ggplot(afw_etikhove, aes(Timestamp, Value)) +
geom_line() + xlab("") + ylab("Volume")
We can do similar filtering to check for time series on other stations, for example the Molenbeek in Etikhove:
available_variables <- get_variables("L06_347")## Use datasource: 1 for data requests of this station!## station_name station_no ts_id ts_name parametertype_name
## 1 Etikhove/Molenbeek L06_347 276546042 P.15 v
## 2 Etikhove/Molenbeek L06_347 276494042 P.15 Q
## 3 Etikhove/Molenbeek L06_347 276277042 P.15 H
## stationparameter_name
## 1 v
## 2 Q
## 3 HAnd use the ts_id code representing discharge to create
a plot of the discharge during a storm in 2010:
etikhove <- get_timeseries_tsid("276494042",
from = "2010-11-09", to = "2010-11-16")
ggplot(etikhove, aes(Timestamp, Value)) +
geom_line() + xlab("") + ylab("Q (m3/s)")
Check the URL used to request the data
As each of these data requests is actually a call to the waterinfo.be API, the call can be
tested in a browser as well. To retrieve the URL used to request certain
data (using get_variables(), get_stations() or
get_timeseries_tsid()), check the comment()
attribute of the returned data.frame, for example:
air_stations <- get_stations("air_pressure")
comment(air_stations)## [1] "https://download.waterinfo.be/tsmdownload/KiWIS/KiWIS?type=queryServices&service=kisters&request=getTimeseriesValueLayer&datasource=1×eriesgroup_id=192918&format=json&metadata=TRUE&md_returnfields=custom_attributes%2Cstation_id%2Cstation_no%2Cstation_name%2Cstationparameter_name%2Cts_unitsymbol%2Cparametertype_name%2Cts_id%2Cca_sta&ca_sta_returnfields=dataprovider"or
etikhove <- get_timeseries_tsid("276494042",
from = "2010-11-09", to = "2010-11-16")
comment(etikhove)## [1] "https://download.waterinfo.be/tsmdownload/KiWIS/KiWIS?type=queryServices&service=kisters&request=getTimeseriesvalues&ts_id=276494042&format=json&datasource=1&returnfields=Timestamp%2CValue%2CQuality%20Code&from=2010-11-09%2000%3A00%3A00&to=2010-11-16%2000%3A00%3A00"