Import Rainfall Data into Geo SCADA database Query

[Tony_Water]

Hi Everyone!

I wish to import rainfall data (from another database) into Geo SCADA and integrate it with existing mimics / structured text etc. to manage Wet Well Alarms.

I'm reaching out for ideas on how to do this - I would imagine I would need to set up an ODBC connection to the rainfall data database and import this data into a table within Geo SCADA.

Looking for ideas or suggestions that may help - or instructions from anyone who has done something similar before.

Thank you all in advance - any help would be greatly appreciated!

Tony

[sbeadle]

Depends what you want to do with that data. Do you just want a table? If you want alarms then you'll need points for each 'cell' or 'square'. Maybe you want to show map symbols, so you'll need the table to include co-ordinates, or the points need co-ordinates.

[Tony_Water]

Hi - Thanks for your reply!

We are still deciding on what exactly what data will be transferred into the GeoSCADA database and have a meeting planned soon to discuss this - but from my understanding it will be at least the site CAR ID.

With the CAR ID imported into GeoSCADA, a SQL statement within ST can identify key digital and analogue points in the database (e.g. 'Wet Well Level' and or 'Wet Well High Level') matching a given imported CAR ID and then use a method to suppress the alarm for each point within that returned SQL record set. This is to avoid the Control Room being inundated with alarms in advance of alarms (that are expected anyway) and make alarm management easier for Control Room staff.

After a given period of time - say 3 - 5 hours (when heavy rainfall has passed and Wet Wells have drained down) a further SQL statement within ST will execute and revert the suppressed alarms back to normal.

We are already using this ST logic albeit by Field Manager Area selection on a mimic - both manually by Control Room staff and through automated execution of logic by calculation of average Wet Well levels in each Field Manager area - and execute alarm suppression logic if given threshold had been exceeded.

So far this appears to be working - however the issue is granularity - using the CAR ID will target specific waste water sites rather than in geographic Field Manager areas - and this is why we considering integration of Met Office data.

So the question is how to achieve this or what would be the best way to store this imported data - on a table? and would VB / Python script be required to control when this data is imported. Again from my understanding data is already being imported into GeoSCADA so we are partly there. Any suggestions would be appreciated.

Happy to discuss

Thank you