Time series list queries
Table of contents
Select a section to jump to:
- Get a list of times series for a named Parameter and Station
- Get a list of time series for all parameters at One Station
- Get a list of time series for Two Different Parameters at Two Named Stations
- Get a list of Daily Mean Flow time series for all Stations
- Get a list of Hourly Groundwater time series at selected Stations
- Get a list of all Peak-Over-Threshold time series
- Get a list of Calendar Year Total timeseries for a list of named stations
- Timeseries list with coverage and extreme value statistics for Stage
The getTimeseriesList query function provides access to the identifiers (ts_id and ts_path elements) that allow targeted retrieval of specific time series data. Furthermore, station, parameter, and time series metadata can all be retrieved with the returnfields argument - this makes getTimeseriesList the most powerful metadata function.
N.B. by default getTimeseriesList only returns ts_id to enable further time series data retrieval; these are useful for compact lists of ts_id query arguments to the getTimeseriesData and getTimeseriesDataLayer functions. To return ts_path elements and temporal extents, specify the returnfields arguments with station_no, parameter_no, ts_shortname, and coverage. Alternatively, a pre-concatenated ts_path is returned by ts_path. Site_no is redundant as this value is always 1.
This is a good point to review the discussion of the pros and cons of ts_id and ts_path.
Get a list of time series for a named Parameter and Station
https://timeseries.sepa.org.uk/KiWIS/KiWIS?service=kisters&type=queryServices&datasource=0&request=getTimeseriesList&station_name=Brigton&stationparameter_no=RE
N.B. the returnfields argument is unspecified so this generates only the default return fields
Get a list of time series for all parameters at One Station
https://timeseries.sepa.org.uk/KiWIS/KiWIS?service=kisters&type=queryServices&datasource=0&request=getTimeseriesList&station_name=Newton Stewart&returnfields=station_no,station_name,catchment_name,station_latitude,station_longitude,stationparameter_name,ts_name,ts_id,ts_path,coverage&dateformat=yyyy-MM-dd
N.B. both ts_id and the pre-concatenated ts_path are returned and either could be used to subsequently retrieve the time series data values.
Again, this is a good point to review the discussion of the pros and cons of ts_id and ts_path.
Get a list of time series for Two Different Parameters at Two Named Stations
https://timeseries.sepa.org.uk/KiWIS/KiWIS?service=kisters&type=queryServices&datasource=0&request=getTimeseriesList&station_name=Newton Stewart, Brigton&stationparameter_no=RE,SG&returnfields=station_no,station_name,catchment_name,station_latitude,station_longitude,stationparameter_name,ts_name,ts_id,coverage,ca_sta&ca_sta_returnfields=GAUGE_DATUM,GROUND_DATUM,CATCHMENT_SIZE&dateformat=yyyy-MM-dd&orderby=station_name
N.B. station custom attributes, Gauge Datum, Ground Datum and Catchment Size.
Get a list of Daily Mean Flow time series for all Stations
https://timeseries.sepa.org.uk/KiWIS/KiWIS?service=kisters&type=queryServices&datasource=0&request=getTimeseriesList&ts_shortname=HDay.Mean&stationparameter_no=Q&returnfields=station_no,station_name,catchment_name,station_latitude,station_longitude,stationparameter_name,ts_name,ts_id,ts_path,coverage&orderby=station_name
Get a list of Hourly Groundwater time series at selected Stations
https://timeseries.sepa.org.uk/KiWIS/KiWIS?service=kisters&type=queryServices&datasource=0&request=getTimeseriesList&station_no=133760,459910,336526,336427&ts_shortname=Hour.Cmd&stationparameter_no=GWL&returnfields=station_no,station_name,catchment_name,station_latitude,station_longitude,stationparameter_name,ts_name,ts_id,coverage&dateformat=yyyy-MM-dd&orderby=station_name
Get a list of all Peak-Over-Threshold time series
https://timeseries.sepa.org.uk/KiWIS/KiWIS?service=kisters&type=queryServices&datasource=0&request=getTimeseriesList&ts_shortname=POT&returnfields=station_no,station_name,catchment_name,station_latitude,station_longitude,stationparameter_name,ts_name,ts_id,coverage&dateformat=yyyy-MM-dd&orderby=station_name
N.B. this retrieves time series for two parameters at each station since ts_shortname is the same for both parameters. If you only wanted just one you could specify the stationparameter_name to the getTimeseriesList query function, e.g. request=getTimeseriesList&stationparameter_name=Level
Get a list of Calendar Year Total time series for a list of named stations
https://timeseries.sepa.org.uk/KiWIS/KiWIS?datasource=0&service=kisters&type=queryServices&request=gettimeserieslist&station_name=Boreland,Braidlie,Canonbie Raingauge,Kinmount House,Solwaybank,Unthank Raingauge,Ayton Castle,Boleside,Chesters,Jedburgh,Ladyflat Farm,Mouthbridge,Ormiston Mill,Teviothead&ts_shortname=CYear.Total&returnfields=station_name,ts_path
N.B. this retrieves a list of the station names and time series paths that can be used to collect the data with getTimeseriesValues
Timeseries list with coverage and extreme value statistics for Stage
https://timeseries.sepa.org.uk/KiWIS/KiWIS?service=kisters&type=queryServices&datasource=0&request=gettimeserieslist&ts_path=*/*/SG/15m.Cmd&returnfields=station_no,station_name,stationparameter_name,ts_unitname,ts_unitsymbol,ts_unitname_abs,station_latitude,station_longitude,stationparameter_no,ts_path,site_no,site_name,catchment_no,catchment_name,ca_sta&ca_sta_returnfields=sepa_maximum_level,sepa_maximum_level_timestamp,sepa_median_annual_maximum_level,sepa_median_annual_minimum_level,sepa_minimum_level,sepa_minimum_level_timestamp