pulling table information from a website to create dashboards

188
1
03-14-2020 12:16 PM
TravisAnderson
Occasional Contributor

I don't know anything about trying to do this, but I want to learn how to, if it's possible. I work at a water plant and our telemetry uploads current operational information to a web page in a table format. We access that mainly on our smart phones to monitor our system when when we are not in the plant. 

What I would like to do is pull information from this page, and use it within Operations Dashboard. 

I can access data from the above page using a web page JSON requests. For example,

https://xxxxxxxxxx.scadaweb.net:4443/JSON/STATION.php?addr=SH returns the following:

{ "StationName": "HSP & SCALES", "StationAddress": "SH", "StationStatus": 82, "TimeHour": 14, "TimeMinute": 10, "TimeSecond": 44, "AnalogInputs": [8.6,150,91.1,150,489.3,1000,170.4,364.6,0,109.4,177.4,0,0,0,0,0], "DiscreteInputs": [1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0], "ExpansionInputs": [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0], "FlowRates": [331,0,0,0,0,0,0,0], "FlowTotals": [52578000,0,0,0,0,0,0,0], "OutputStatusWords": [38,4160,38,4192,0,0,0,0,0,0,0,0,0,0,0,0], "PCHOAS": [2,0,2,2,0,0,0,0,0,0,0,0,0,0,0,0], "AnalogOutputs": [0,0,0,0,0,0,0,0]}

Is it possible to enter in a JSON request that would only pull the 331, which represents 331 gallons per minute? For a lack of a better way to describe this, I see a simple table and wonder how can I pull cell "A9" (A9 is just example) and shove it into a field that is contained in a layer on ArcGIS Online, which I can then use in Operations Dashboard. This sounds to simplistic, but is it possible to insert a URL into a field in a published feature layer, have it store that value from the table,  and then assign an "refresh interval" to update that value? I'm not trying to circumvent Arc Server, but we could never justify purchasing it just to update layers or to have me experiment. I've taught myself to use ArcGIS Online and Arc Desktop, but you can tell this definitely is not my area of expertise. I would really like to do more with dashboards, but I need the data from our SCADA to develop operational related dashboards (flows and pressures). We only have 15 employees so we are a very small company, but serve 17,000 people water. ArcGIS Online has been very useful for our company and I'm just looking for other ways to expanded on it by developing more apps, but I really want to incorporate these dashboards.

If anyone can point me in the right direction that would be very helpful. I think I should find a book on this stuff.

I know what I'm asking is possibly not doable.

Thank you,

Travis

0 Kudos
1 Reply
DerekLaw
Esri Community Moderator

Hi Travis,

> I would really like to do more with dashboards, but I need the data from our SCADA to develop operational related dashboards ...

Perhaps you could export the data from your SCADA system into a CSV file format, then import into Microsoft OneDrive, Dropbox, or Google Drive - then publish this data as a hosted feature layer?

Publish layers from files on Microsoft OneDrive, Dropbox, and Google Drive 

Not sure if this will work. Otherwise, I think you'll need ArcGIS Enterprise.

Hope this helps,

0 Kudos