Roll call for All Data Points on ION

Every 15 minutes, there are on the campus 22333 data points that record different quantities (Cooling flow, Supply Temperature, Apparent Power, Reactive Energy ...). It is very difficult and time consuming to check manually each one of these data points to see if they are functional. Thus, the goal of this webtool is to perform a roll call on each of the datapoints to identify the ones that show anomalies. This application allows you to download informations about all the data points (a.k.a quantities) on the campus in the format of a CSV file. Due to the significant number of data points, it may takes between 1 and 3 minutes to perform the process. The information returned are:

  • Source name
    ex: "B014E"
  • Source ID
    ex: "651"
  • Quantity name
    ex: "HLCH_TWR_MKUP (1000gal)"
  • Quantity ID
    ex: "10460"
  • Value of the quantity
    ex: "10586"
  • Most recent time at which a measure was returned
    ex: "2016-04-04 00:00"
  • Information on the malfunctioning sources

It is possible to specify the type of malfunctioning sources you want to download. You can select several types of anomalies. One thing to note is that this rollcall of all the data points is performed at the current time. It is not possible to specify past date and time.

Will return all the data points that are responding without any of the anomaly listed below:
  • Obsolete timestamp
  • Saturated value
  • Null value
Will get data points that have a most recent timestamp older than the current time.
Will get data points that return a null value at the current time.
Will get data points that return non-physical value corresponding to a numerical saturation from the source (i.e., 21M or its variants).