Record:Datagraph export of GSN data

From SwissExperiment

Contents 1 Manufacturer: 2 Parameter to be measured: 3 Instruments 4 Views 5 Algorithm 6 Advantages: 7 Disadvantages: 8 What to watch out for: 9 Problems/Questions: 10 Links: 11 Documentation 12 Author:

Manufacturer:

The algorithm must be performed currently manually. Later an automation is intended, but not available yet. The operation requires an installation of the datagraph software [1]. To be able to visualize the datagraph data, the datagraph viewer extension [2] is required.

Parameter to be measured:

The output parameters are the same as the input parameters, since the measurements are only pre-aggregated by the datagraph application.

Instruments

Pegel Andelfingen export to datagraph, Pegel Halden export to datagraph, Pegel Neunforn export to datagraph, Sts400311 proc export to datagraph, Sts400311 raw export to datagraph, Sts400313 proc export to datagraph, Sts468313 raw export to datagraph, Sts468314 raw export to datagraph, Sts468316 raw export to datagraph, Sts468317 raw export to datagraph, Sts468318 raw export to datagraph, Sts468319 raw export to datagraph, Sts468320 raw export to datagraph, Sts468321 raw export to datagraph, Sts468322 proc export to datagraph, Sts470042 proc export to datagraph, Sts470042 raw export to datagraph, Sts470043 proc export to datagraph, Sts470043 raw export to datagraph, Sts470044 proc export to datagraph, Sts470044 raw export to datagraph, Sts470045 proc export to datagraph, Sts470045 raw export to datagraph, Sts470046 proc export to datagraph, Sts470046 raw export to datagraph, Sts470047 raw export to datagraph, Sts470048 proc export to datagraph, Sts470048 raw export to datagraph, Sts470049 proc export to datagraph, Sts470049 raw export to datagraph, Sts470050 raw export to datagraph, Sts470051 proc export to datagraph

Views

• Datagraph pegel Andelfingen on 24-05-2009
• Datagraph pegel Halden on 24-05-2009
• Datagraph pegel Neunforn on 24-05-2009
• Datagraph sts400311 proc on 24-05-2009
• Datagraph sts400311 raw on 24-05-2009
• Datagraph sts468313 raw on 24-05-2009
• Datagraph sts468314 raw on 24-05-2009
• Datagraph sts468316 raw on 24-05-2009
• Datagraph sts468317 raw on 24-05-2009
• Datagraph sts468318 raw on 24-05-2009
• Datagraph sts468319 raw on 24-05-2009
• Datagraph sts468320 raw on 24-05-2009
• Datagraph sts468321 raw on 24-05-2009
• Datagraph sts468322 proc on 24-05-2009
• Datagraph sts470042 proc on 24-05-2009
• Datagraph sts470042 raw on 24-05-2009
• Datagraph sts470043 proc on 24-05-2009
• Datagraph sts470044 proc on 24-05-2009
• Datagraph sts470044 raw on 24-05-2009
• Datagraph sts470045 proc on 24-05-2009
• Datagraph sts470046 proc on 24-05-2009
• Datagraph sts470046 raw on 24-05-2009
• Datagraph sts470047 raw on 24-05-2009
• Datagraph sts470048 proc on 24-05-2009
• Datagraph sts470049 proc on 24-05-2009
• Datagraph sts470049 raw on 24-05-2009
• Datagraph sts470050 raw on 24-05-2009
• Datagraph sts470051 proc on 24-05-2009

Algorithm

for streaming data:

• deploy the virtual sensor in Record:GSN
• create table in the datagraph database
• add a column timed2 of type timestamp with "on update current timestamp"
• configure the new data in the datagraph configuration web interface
• create additional database tables by calling the scripts in the aggregation directory of the datagraph distribution for each pre-aggregation level
• document everything in the Swissex wiki

for batch data:

• deploy in gsn
• add a column timed2
• update the column with the following SQL command

  update `sts468317_raw` set timed2 =from_unixtime(round(timed/1000))

• configure the new data in the datagraph configuration web interface
• create additional database tables by calling the scripts in the aggregation directory of the datagraph distribution for each pre-aggregation level
• document everything in the Swissex wiki

Advantages:

• fast graphing of measurement data in a web application

Disadvantages:

• quite some manual work is required to perform the operation

What to watch out for:

Problems/Questions:

Links:

Standards: Field observations:

Documentation

Key words:
manual correction

Record:Operation class

Author:

User:Andreas wombacher