The query results are displayed according to your favorite sorting (see above). When ticked the selected data streams stays on top of the selection, regardless of the pages you move to. The table consists of five columns. The first one is just the selection square (with no column name).
The second column (Code) represents the full parameter URN without unit (see https://spaces.awi.de/x/zYa0FQ at ‘Short names and URN syntax’ for more details). On the left-hand side of the parameter URN can be clicked to see more details about the parameter. By clicking ‘Detailed description’ you are forwarded to the respective entry in sensor.awi.de. When there is a PI available for the parameter’s item in sensor.awi.de (https://spaces.awi.de/x/0Ia0FQ) it is displayed here. It might be important to note, that this works only with the contact role ‘PI’, otherwise the fields is blank. Furthermore the explained properties are listed here (https://spaces.awi.de/x/2Ia0FQ), if they are set by the item editor.
On the right-hand side of the parameter URN the icon copies the full parameter URN to your clipboard. Mostly to the right of the copy tool a green icon indicates that the data stream originates from our NRT database. Occasionally a blue denotes that the corresponding data stream is part of the AWI datapool, a hadoop cluster containing non-realtime mass data (more information about that project will be announced here too). These data streams can be requested, but it takes (in parts much) longer than the NRT-notated streams.
The third column gives the Age of the data stream. In other words, what is the duration of the last timestamp from the ingested data until now. Negative values, with a purple background color show that the values are presumably erroneous. All valid values can have minutes, hours, or days as time duration. Coming with a green background the age is < 10 minutes, with an orange background color the age is < 60 minutes. Every data stream older than one hour appears with red background.
The fourth column shows the last ingested Value plus unit (for legacy reasons some data streams do not show units, but truly they have).
The fifth column is reserved for the quality flag created by autoQC
(see https://spaces.awi.de/x/2Ia0FQ). If no quality control was applied by autoQC
a 0 is printed, if yes, the last flag is printed here.
datetime | data | qf | note | |
---|---|---|---|---|
1 | 2021-06-24 01:00:00 | 3 | 2 | in |
2 | 2021-06-24 02:00:00 | 3 | 4 | out |
3 | 2021-06-24 03:00:00 | 4 | 1 | in |
4 | 2021-06-24 04:00:00 | 7 | 1 | in |
5 | 2021-06-24 05:00:00 | 11 | 3 | in |
6 | 2021-06-24 06:00:00 | 7 | 2 | in |
7 | 2021-06-24 07:00:00 | 14 | 3 | in |
8 | 2021-06-24 08:00:00 | 7 | 3 | in |
9 | 2021-06-24 09:00:00 | 6 | 3 | in |
10 | 2021-06-24 10:00:00 | 6 | 4 | out |
11 | 2021-06-24 11:00:00 | 4 | 2 | in |
12 | 2021-06-24 12:00:00 | 4 | 2 | in |
13 | 2021-06-24 13:00:00 | 11 | 1 | in |
14 | 2021-06-24 14:00:00 | 10 | 1 | in |
15 | 2021-06-24 15:00:00 | 13 | 2 | in |
16 | 2021-06-24 16:00:00 | 4 | 4 | out |
17 | 2021-06-24 17:00:00 | 9 | 3 | in |
18 | 2021-06-24 18:00:00 | 13 | 4 | out |
19 | 2021-06-24 19:00:00 | 10 | 1 | in |
20 | 2021-06-24 20:00:00 | 9 | 2 | in |
21 | 2021-06-24 21:00:00 | 11 | 3 | in |
22 | 2021-06-24 22:00:00 | 6 | 1 | in |
23 | 2021-06-24 23:00:00 | 6 | 1 | in |
24 | 2021-06-24 24:00:00 | 5 | 1 | in |
When all quality flags >3 are excluded from the table the following table remains to aggregate:
Foundation for aggregationdatetime | data | qf | note | |
---|---|---|---|---|
1 | 2021-06-24 01:00:00 | 3 | 2 | in |
3 | 2021-06-24 03:00:00 | 4 | 1 | in |
4 | 2021-06-24 04:00:00 | 7 | 1 | in |
5 | 2021-06-24 05:00:00 | 11 | 3 | in |
6 | 2021-06-24 06:00:00 | 7 | 2 | in |
7 | 2021-06-24 07:00:00 | 14 | 3 | in |
8 | 2021-06-24 08:00:00 | 7 | 3 | in |
9 | 2021-06-24 09:00:00 | 6 | 3 | in |
11 | 2021-06-24 11:00:00 | 4 | 2 | in |
12 | 2021-06-24 12:00:00 | 4 | 2 | in |
13 | 2021-06-24 13:00:00 | 11 | 1 | in |
14 | 2021-06-24 14:00:00 | 10 | 1 | in |
15 | 2021-06-24 15:00:00 | 13 | 2 | in |
17 | 2021-06-24 17:00:00 | 9 | 3 | in |
19 | 2021-06-24 19:00:00 | 10 | 1 | in |
20 | 2021-06-24 20:00:00 | 9 | 2 | in |
21 | 2021-06-24 21:00:00 | 11 | 3 | in |
22 | 2021-06-24 22:00:00 | 6 | 1 | in |
23 | 2021-06-24 23:00:00 | 6 | 1 | in |
24 | 2021-06-24 24:00:00 | 5 | 1 | in |
The resulting aggregated single-day value would be:
Aggregation of example data to daily values using arithmetic meandatetime | data | qf |
---|---|---|
2021-06-24 | 7.85 | 1 |
Your selected data streams can have different flavors for downloading. As output Format it can be chosen between JSON or tab-delimited (CSV).
Example Data – JSON type
{
"beginDate": "2021-06-08T13:00:00.000",
"endDate": "2021-06-08T13:00:30.000",
"qualityFlags": [],
"withQualityFlags": false,
"sensors": [
"station:heluwobs:heluw1:ctd_awi_578:chlorophyll_a_03"
],
"data": [
[
"2021-06-08T13:00:00.000",
20.58
],
[
"2021-06-08T13:00:01.000",
24.77
],
[
"2021-06-08T13:00:02.000",
21.3
],
[
"2021-06-08T13:00:03.000",
33.83
],
[
"2021-06-08T13:00:04.000",
23.88
],
[
"2021-06-08T13:00:05.000",
31.34
]
]
}
Example Data – CSV type
datetime station:heluwobs:heluw1:ctd_awi_578:chlorophyll_a_03 [µg/l]
2021-06-08T13:00:00.000 20.58
2021-06-08T13:00:01.000 24.77
2021-06-08T13:00:02.000 21.3
2021-06-08T13:00:03.000 33.83
2021-06-08T13:00:04.000 23.88
2021-06-08T13:00:05.000 31.34
Finally can be clicked and the request is processed. Then a list is generated. The first line is a suggestion on how to cite the data. If the item has a declared PI in sensor.awi.de she/he is included in the citation as first author. Otherwise the generic citation is used: O2A Data Services (2021): Data from provided by O2A Data Services. Alfred-Wegener-Institut, https://dashboard.awi.de/data-xxl
Below the citation three options are shown:
The data set will be – with regard to your choice – downloaded after clicking.
The download link will be copied to your clipboard so you can paste it elsewhere.
A short summary of the data set can be generated, annotated with some links to more information about the parameter. This is just an excerpt from sensor.awi.de.
// The following metadata is prepared based on sensor.awi.de descriptions.
// Always quote the principal investigator and this data service when using data! The licence is CC BY 4.0.
// See O2A documentation: https://spaces.awi.de/display/DM/
station:heluwobs:heluw1:ctd_awi_578:chlorophyll_a_03
- name: Chlorophyll A
- unit: µg/l
- type: chlorophyll a
- principal investigator(s):
Fischer, Philipp <philipp.fischer@awi.de>
- resources:
JSON representation [https://sensor.awi.de/rest/sensors/item/getDetailedItem/3833?includeChildren=true]
SensorML representation [https://sensor.awi.de/rest/sensors/item/getItemAsSensorML/3833]
Web page [https://sensor.awi.de/?id=3833]
...