Introduction
Export scalar timeseries to PI type format (example config). This xml format is described in detail in the Delft-Fews published interface documentation.
Example
<?xml version="1.0" encoding="UTF-8"?> <TimeSeries xsi:schemaLocation="http://www.wldelft.nl/fews/PI http://fews.wldelft.nl/schemas/version1.0/pi-schemas/pi_timeseries.xsd" version="1.2" xmlns="http://www.wldelft.nl/fews/PI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <timeZone>0.0</timeZone> <series> <header> <type>accumulative</type> <locationId>EA_H-2001</locationId> <parameterId>Rainfall</parameterId> <timeStep unit="second" multiplier="900"/> <startDate date="2003-03-01" time="00:00:00"/> <endDate date="2003-03-01" time="05:00:00"/> <missVal>-999.0</missVal> <stationName>Bewdley</stationName> <units>m</units> </header> <event date="2003-03-01" time="00:00:00" value="-999.0" flag="88"/> <event date="2003-03-01" time="00:15:00" value="0.0010" flag="44"/> <event date="2003-03-01" time="00:30:00" value="0.0020" flag="44"/> <event date="2003-03-01" time="00:45:00" value="0.0030" flag="44"/> <event date="2003-03-01" time="01:00:00" value="0.0040" flag="44"/> <event date="2003-03-01" time="01:15:00" value="-999.0" flag="88"/> <event date="2003-03-01" time="01:30:00" value="0.0060" flag="44"/> <event date="2003-03-01" time="01:45:00" value="0.0070" flag="44"/> <event date="2003-03-01" time="02:00:00" value="0.0080" flag="44"/> <event date="2003-03-01" time="02:15:00" value="0.009000001" flag="44"/> <event date="2003-03-01" time="02:30:00" value="0.010000001" flag="44"/> <event date="2003-03-01" time="02:45:00" value="0.011000001" flag="44"/> <event date="2003-03-01" time="03:00:00" value="0.012" flag="44"/> <event date="2003-03-01" time="03:15:00" value="0.013" flag="44"/> <event date="2003-03-01" time="03:30:00" value="0.014" flag="44"/> <event date="2003-03-01" time="03:45:00" value="0.015000001" flag="44"/> <event date="2003-03-01" time="04:00:00" value="0.016" flag="44"/> <event date="2003-03-01" time="04:15:00" value="0.017" flag="44"/> <event date="2003-03-01" time="04:30:00" value="0.018000001" flag="44"/> <event date="2003-03-01" time="04:45:00" value="0.019000001" flag="44"/> <event date="2003-03-01" time="05:00:00" value="0.020000001" flag="44"/> </series> </TimeSeries>
To support the validation status, it is possible since PI timeseries version 1.19 to define flagSourceColumns and (custom)flagSources in the PI-XML timeseries format. For example a flag source column named 'V3' that has a custom flag source value 'OK' will result in an attribute
fs:V3="OK"
< TimeSeries xmlns = "http://www.wldelft.nl/fews/PI" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation = "http://www.wldelft.nl/fews/PI http://fews.wldelft.nl/schemas/version1.0/pi-schemas/pi_timeseries.xsd" version = "1.19" xmlns:fs = "http://www.wldelft.nl/fews/fs" > < timeZone >1.0</ timeZone > < series > < header > < type >instantaneous</ type > < moduleInstanceId >WerkFilter</ moduleInstanceId > < locationId >140-w_Leidsche Rijn</ locationId > < parameterId >HGTE_METING_15M</ parameterId > < timeStep unit = "second" multiplier = "900" /> < startDate date = "2012-06-25" time = "17:45:00" /> < endDate date = "2012-06-25" time = "21:45:00" /> < missVal >NaN</ missVal > < stationName >AANVOERDER_140-w_Leidsche Rijn</ stationName > < lat >52.082416488309036</ lat > < lon >5.075337740730613</ lon > < x >133623.0</ x > < y >454951.0</ y > < z >-9999.0</ z > < units >mNAP</ units > </ header > < event date = "2012-06-25" time = "19:30:00" value = "-0.414" flag = "0" fs:V3 = "OK" fs:V4 = "OK" /> < event date = "2012-06-25" time = "21:45:00" value = "-0.385" flag = "0" fs:V2 = "OK" fs:V3 = "OK" /> </ series > </ TimeSeries > |