In this video we'll walk through how to create a
feature service and layer using the PI Integrator
for Esri ArcGIS. This is going to allow us to
expose this PI system data to the
Esri ArcGIS platform.
I have already made sure that my PI
Integrator for Esri ArcGIS as well as
the Esri ArcGIS Geo Event Processor
data stores and certificates are all configured.
Additionally, my asset framework is ready
too. This was shown in the previous video.
I will bring these locomotive assets which are based
off of the same AF element
template and their attributes into the Esri ArcGIS
platform as point geometries.
I'll start by going to the
configuration portal.
I have logged on to the PI integrator for
Esri ArcGIS configuration portal.
And the URL right here.
And go ahead
and create a service.
I'll give it a name and
description.
The stream server is for the data flow and the
data server is for the integration with PI Coresight.
And I'm going to keep both checked and hit create.
The next thing I'll need to do is
create a layer.
So I'm going to create a
layer and give this a name and description as well.
And continue.
Now I'll need to configure the data
source, so I'm going to select the name of the
PI AF server as well as the AF database.
Remember the AF database was
rail company and the template
that I'm interested in is the locomotive template.
There is also the option
to select search route. And this is
something that can be helpful if you are only
bringing in a subset of the elements. In this
case, rail company is the highest element
and I'm interested in bringing in all of the
elements based off of the locomotive template for the
entire AF database. So I'll just leave the search route at that.
And hit continue.
Here we are going
to configure the template attribute
fields and these are which AF
attributes from the elements as well
as some element information that
we want to bring into the Esri ArcGIS
platform.
I'm interested in bringing in all of the
AF attributes, so I'll leave those checked.
And there is also a couple function
choices that I need to make.
For the point geometry, I need
to specify the X and Y and
you can see that because the names are
latitude and longitude, this is already
auto defaulted and selected
the function is X and Y. If your attributes
are named something different, you'll still need to just go
ahead and make the selection manually
using the appropriate drop down.
And the last function choice we'll need to make is for
the key and that's that
unique key. And I mentioned earlier that I'm going to be
doing that off of element name. So I'm going to specify that as the
key here.
And then I can continue. And
lastly, the geometry type is point because I've
specified that X and Y coordinate. And
also, for spatial reference,
I'm going to stick with the default which
is the world geo [inaudible] system 84
which is the most widely used coordinate system.
At this point,
it's now going to offer to open
the connect to ArcGIS platform wizard
and I'm going to do this option because I want the
wizard to help me automatically create the future
service and layer on the Esri ArcGIS platform
side.
And I've hit next after
confirming that I met the requirements. And in this
case, I'm going to be using the ArcGIS
online account that we used earlier.
And remember this account has been added as a data store on the
Geo Event Processor.
And so it will create a feature
service with this name
and a service layer as part of that feature
service with this name on the Esri ArcGIS online environment.
So the feature service has been successfully
created.
And the next
steps are the items on the Geo Event Processor.
This is the Geo Event Processor
and again the administrator credentials
that are specific to the Geo Event Processor.
That was successful so I can go ahead and go next.
And these are the input output
and geo services that it will create.
By default you can see it appends pigeo
to the beginning and simply for the
sake of being able to easily identify
these items on the geo event processor
manager, I'm going to go ahead and add my initials to the beginning.
You can also see this check box
to use https secure. This specifies
whether the data is going to be transmitted
securely. It is important to note that using
https does require a security
configuration on the Geo Event Processor.
So if that has been taken care of on the
Geo Event Processor, you can use this option.
If that has not been done, you have to uncheck
this box to use the http
transport. This has been done so I'm going to
use https and create.
And it has
created all 3 of those items and
then it will say when the service is
created, it'll report done. So I can hit next
and this finishes the process.
We can confirm that all of the necessary
items are successfully created and look
at the data flow by first starting here in
the configuration portal. We can see the
service and layer that were created. And
the stream server, we can look at the data flow.
We can then look at the Geo Event
Processor Manager,
we can switch to services.
Here we can see that the
Geo Event Service was created
and we can also see the corresponding input and
output by scrolling down.
Alternatively, we can use
these inputs, geo event services
and outputs to look at each individual list.
And then finally,
in Esri ArcGIS
Online I can navigate to my
content and see the rolling stock feature layer
that was just created.
Let's look at this feature layer
using the ArcGIS online map option.
And we can
load the feature layer, I'll
go to add and search for layers.
To make it easier to find, I'm going to
look at my content.
And I can see the rolling stock feature
layer and I'll go ahead and add that.
You can see all of my locomotives
appear pretty close together. So
I can zoom to
and within
this Esri map, there are a lot of
options for customization. For example, I can
use the base map option to
switch to a different
type. If I want to look at
the railroads with respect to these
locomotives, I can browse Esri
map layers.
And add the USA
railroads to the map.
Right now by
default, all of the locomotives appear
as this green box and that doesn't necessarily represent
to me what a locomotive is. And that's something that I
can also configure. I can change the
symbols. And you'll notice over
here, I can use a single symbol or I can
even use multiple symbols if I want to change
colors based off of attributes like how fast the
locomotive is moving. In my case, I'm going to
change the symbol to something that
represents a
locomotive.
And beyond just the location on the
map, if I click on one of these
locomotives, I can see all of the information that I
was interested in bringing in, in this pop-up
here. I can
change the refresh rate that the
locomotives update their position and
information as well
if I
modify this refresh interval. So in this
case, I'm going to refresh the layer
every .05 minutes.
And with this,
I can watch as these assets
move in real-time and they are going to
blink every time that they update.
And one great customization
option that is available is in addition to being
able to click on one of these and
look at that attribute information, I
mentioned that there is an integration possible with
PI Coresight. And we can use PI
Coresight to look at the historical data as well.
To be able to configure this,
we're going to configure a
pop-up for this particular layer, the
locomotives.
And we'll add an image
and this is where the
information in the configuration portal is needed.
So I'll give this a
title as explore
in PI Coresight.
And for the URL, I can get this
information from this
layer's display server.
These images are available
and I'm going to use this middle image.
Let's add it to the URL and the link
is the action that you want it to do. In my
case I want it to open and an ad hoc PI Coresight display.
So I'll use this.
And then save pop-up.
And now when I have one of these
selected, I look down and have the
Explore in PI Coresight option available.
And this opens the ad hoc
PI Coresight trend where all of the attributes
have been added here. And I can take a
look at different options and see what
the historical data looks like as well, not just
the last value. With that,
I'll go back and I'm going to have the
option to save and share this map.
Keep in mind, this is just the
Esri ArcGIS online map. There are other Esri
ArcGIS client tools, for example,
Operations Dashboard where you can combine
these type of custom maps and the maps
within operations dashboard won't have this flash
update but they can update more smoothly. And you can
incorporate other widgets like charts and gauges.
So this is really the beginning of getting your PI
system data into the Esri ArcGIS platform.
There are two other tools that are
available that I want to mention. Looking
in the configuration portal under
tools, you can see that there is the asset
extractor. And this
asset extractor is going to read assets
within a feature layer and then add them
to your PI Asset Framework. So this is a really
good option for Esri ArcGIS users who
might have all of their assets defined in
ArcGIS and are just getting started with the PI
System, so they don't have an Asset Framework built out.
And finally, there is also the
PI Integrator for Esri
ArcGIS Geo Event Monitor which is
available from the OSISoft tech support website.
If you are experiencing any issues with
the Geo Event Processor data inputs
failing while the data is streaming and it doesn't provide an
indication, this service can be installed to monitor the
data inputs and restart them if this problems occurs.
With that, that is
how you can create your feature service
and layer bringing your PI
system data into the Esri ArcGIS platform.