[Imported] Weather Data

[sbeadle]

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: florian, originally posted: 2018-10-24 21:32:28 Id:207
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

--------------

**_jayj:_**
**_Is there any way to utilize the data supplied from this web service directly to clearSCADA?_**

**_https://openweathermap.org/_**

**_I found a driver for wonderware that can utilize it but wondering if I can do it within clearscada._**

**_We are wanting to provide forecast info on mimics to operators and beta test integrating weather data into the control scheme, anticipating heat waves for water supply, etc._**

-------------

meghnesh:
I did explore this sometime back.

https://openweathermap.org/ offers you API's which would be is a paid service and it generates a API key for you which is used to call their API's .

Clear SCADA offers you a hyperlink option on any objects on the mimic where the API link can be configured and call.

-----------

bevanweiss:
ClearSCADA does support a few options around this:
a. WMS format for visual imports, of map layers etc. I'm not sure if OpenWeatherMap supplies these, a quick look showed map tiles, but I'm not sure if they support WMS for the request format.

b. Data import.
b1. ClearSCADA supports ODBC, so you could possible get data through this interface if OpenWeatherMap supports this (or you can proxy to it).
b2. You can create your own Simple ClearSCADA driver. This would allow you to use some reasonably simple C# (or other programming language) to get this data into ClearSCADA directly.

The Hyperlink option that megnesh mentions is more just on the visual side of things, and kind of makes the display external to ClearSCADA also... I'm not sure you'd consider this ideal.

------

sbeadle:
I imagine you would like to get the numeric forecast data from the service and put it into the ClearSCADA Forecast objects - one per value type.

For example, this service from that site:

https://openweathermap.org/forecast5

(Click on the link 'by geo co-ordinates)

This will output a JSON data block with temp, pressure, humidity etc, for each time section (dt is a unix date number).

It would be simple to script this request (you'll need to register on the site to get an app id. It may be that your SCADA server/client can't access the internet directly (a good thing!), so I would have a separate process outside the SCADA network which grabs these JSON files regularly, then pushes them as files into the SCADA zone through its firewall.

Then have a process/script which reads the JSON (easy from C#) and connects to the ClearSCADA database (use the .Net or the COM libraries) and writes them into pre-created Forecast objects. Then you can display them on trends, or even raise alarms if 'future' values go outside limits.