Attribute Rules can help improve the quality of data and automate editing workflows. Learn how Attribute Rules can support GIS Data Management: https://community.esri.com/people/tdewitte-esristaff/blog/2018/05/07/automating-calculations-and-con...
I am using GIS for mapping water utility. We are currently using SCADA for controlling the network. Would like to know how can we integrate SCADA and GIS for spatial viewing of the whole network. Would love to hear from you all!
my first question is what are you wanting to see from SCADA in the GIS and how do you want to use this information?
If just visualizing the volume of water at a point, then I would create an independent point feature class that you would place or create a feature at the location of the SCADA device and then export readings from your SCADA to this point feature class, updating the attribute that contains the reading. This feature class would not be versioned. If you are wanting to see the status of devices (valves, etc) that affect flow and you want this information in the utility network, you could create an app that pushes information from the SCADA to the utility network service using the Rest End Point to update the device status attribute in the default version and validate the update. If you are using a Geometric Network, you would need to writing a similar utility in ArcObjects or python to load the updated data to the feature. If updating the Geometric Network or Utility Network with information frequently, many features per minute, you could impact performance. There is a big difference between sensor data like volume of water vs device status information like valve open.
This is a great use case you have and you're in good hands if you've got John Alsup answering your comments 😃
If you're going to be at the Esri UC this would be a good topic to bring up with some of the Esri staff or Vendors there. You may find that the vendors you are using to store your SCADA data you may have COTS software available to you through that vendor that can achieve what you're looking for (OSIsoft's PI Integrator for Esri ArcGIS, https://www.osisoft.com/solutions/advanced-integrations/esri-arcgis/ ). You may also be inspired to develop an in-house solutions for what John is describing, which could rely on anything from python scripts (run from a geoprocessing server), using a GeoEvent server to update the GIS, or even staging your SCADA data into the GIS periodically and leveraging ArcGIS Insights to do the analysis and presentation of the data. Bring some good use cases and get some hard numbers from your SCADA systems like: what types of points, how many points are you showing, which values from SCADA do you want to bring over, and how often are you going to need to poll your SCADA system for updates.