OSIsoft Pi Integrator for Esri ArcGIS: Real Time Data Explained

May 21, 2016 — Joaquin Madrid, Ph.D.  [7:43]

You have network assets geographically distributed over your service area. Many of those assets are smart: they are collecting large amounts of real time data of the highest value for your organization, your customers, regulatory agencies, etc.

If you could expose all this data via content rich Online Maps and Applications, your users would be empowered to make location based analytics, historical analysis, asses operational situations as they unfold, make time critical predictions, etc.

You turn to OSIsoft Pi Integrator for Esri ArcGIS:

  • COLLECT static and dynamic data among your Esri ArcGIS GDBs and Pi AFs.
  • EXPOSE static data via Esri ArcGIS Online Feature Services and Applications.
  • Pump dynamic data through Pi Integrator, and let Pi Integrator “drive” ArcGIS GeoEvent Extension so that your Online maps UPDATE in real time.
  • EMPOWER your end user with real time, content rich online maps.

Learn how SSP can help you with your OSIsoft Pi implementation and related services here.


Hello my name is Joaquin Madrid, I am a senior consultant with SSP Innovations and I'm going to tell you about the partnership between OSIsoft and Esri to integrate your real time data on your online maps. SSP is very excited to collaborate in this partnership because it follows the pattern of the company. The simple pattern of: collect your data, expose it, and empower your users. If we are familiarized with this pattern, what we do in Esri ArcGIS is we collect data to create our assets, and in Pi we can also collect not only assets but also real time and historical information. Once it is collected and exposed to an online service like Esri ArcGIS Online, then our users, whether they are the whole organization, different departments, customers, even regulatory agencies, will have access to it and your data will be available for a wider public.

So if you are familiarized with Esri's ArcGIS Online efforts in the last few years, and maybe even your utility has already implemented online mapping, you know that the model of collect, expose, and empower is being performed and implemented in the way of creating feature services and feature layers, exposing them through a rest point, publishing them to the online cloud, and then consuming them through either mobile devices or any other kind of mechanism for online contents. But be aware that this exposure of data is completely static. What I mean with static is that if you need to make changes to the map that is going to be served, then you will have to recollect data, make the changes, republish, and then make them available to your users.

Esri is aware of the need to update information without having to republish your services, so they created the Esri GeoEvent Extension for Server which actually consists of Esri GeoEvent Services triggered by some mechanisms absorbing data through an input with formatting of some kind and, actually many ways of formatting your input data, your output data, and the output is pushed directly into the maps that are being serviced online.

Leveraging in the capabilities of the GeoEvent Extension, OSIsoft has developed the Pi Integrator. This component sits in the middle of the big picture because it allows real time information to be mapped in to the online services directly without having to republish. And how is that done? There are two components in the Pi Integrator. The main one is Application Service, which allows you to reuse all the work that you did to publish your maps by exposing the rest points. It reuses the rest point and creates a database of assets within Pi, the database of course is going to have X and Y coordinates. And with that asset database, then the Application Service is able to publish feature services and feature layers corresponding to the assets, very similar to the way that you did it directly with Esri ArcGIS Online publishing. But furthermore, the Data Relay is a component that is periodically pulling data from the real time database, from the historical database, associating that data to the corresponding assets and then manipulating it through triggers and events in a way that it fits, in this case through HTTPS, the mechanism to make the GeoEvent Service populate the data real time on your maps. So with this architecture, what we have is that the collect, expose, empower pattern is being developed in a way that enriches your maps with real time information and provides you with richness in the data that you may not have had before. We can see many applications such as monitoring meters real time in your network. Also, trying to figure out where your crews are in time of performing some task and how they are moving or when they are approaching a particular area that may be deemed dangerous. Other analysis, like historical evolution of your network during storms, and whatever is possible with real time data. So I hope that this presentation has clarified the insight of the Pi Integrator and gives you some ideas of how you can empower your end user to provide them with real time data combined with your geographic assets to have dynamically rich maps online.

We Wrote the Book

The Indispensible Guide to ArcGIS Online

Download It for Free

Joaquin Madrid, Ph.D.

Joaquin Madrid, Ph.D.

What do you think?

Leave a comment, and share your thoughts

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.