ESRI ArcSDE Data Storage

A feature class (layer) is comprised of three components

  1. Business Table 
  2. Feature Table 
  3. Spatial Index Table
  • Business table - contains attributes and spatial column.
  • Feature Table -Stores geometry and annotations
  • Spatial Table - Defines grid range and shape envelope for each feature

Performance Tips

  • Reduce amount of data processed for faster queries
  • Provide a filter to limit number of rows
  • Index tables and feature layers for fast retrieval
    • Adjust Tile Size based on average feature envelope to fine tune spatial grid 
    • Leave SDE tablespace or database as is for ArcSDE application use
    • Store data in new tablespace or database
    • Use Multiple logins for each users so that each user is allocated with dedicated table space
    • If versioning is enabled , maintenance of versions is must through version management tools
ESRI Field Apps Integration

Now ESRI has enabled all field apps to interact with other mobile apps to complete workflow. For example the field worker may be in Workforce App and then search for Asset in Collector and review attributes.

The App integration comes to life using a URL scheme. The scheme is a well-known standard for inter-app communication on mobile devices which is already used by Collector, Explorer and Workforce for ArcGIS to remotely control other field apps and pass context to them. The following Apps support URL scheme integration.

  • Collector
  • Navigator
  • Workforce
  • Survey 123
  • Explorer

 

Maximo 7.6 Map Manager and ESRI REST Services

With Maximo 7.6 the configuration and integration of ESRI ArcGIS services are managed in one place- Map Manager.  Log into Maximo , on the top left search for "Map " , when you are in console you can configure the following items :

  1.  Map Manager - needs ArcGIS REST Service URL to spatially enable Maximo with maps for displaying Assets, Location, Workorder Polygons
  2. Geometry Service - used by Maximo Spatial for drawing tools on the map
  3. Geocode Service -used by geocoding tools configured in Maximo Spatial Map
  4. Select or Enter a "SITE" value for each Map. Each SITE can have only one associated SITE.
  5. Public Maps such as Google Maps, ESRI Maps, Openstreet Maps can also be configured to pull in as basemaps to enhance the Maximo Spatial display. 

 

EAM Integration Workflow questions with ESRI Apps

There is always an important question to answer what ESRI field app should we use to integrate with EAM Systems such as IBM Maximo or SAP Hana or Oracle WAM  or custom Workmanagement software. 

We have three options : 

  • ArcGIS Collector
    • Feature (Points, Polylines, Polygons) collection from field
    • Supports Apple iOS, Android, Windows
    • New and Existing features can be collected
    • Offline editing is okay
    • Named user access only
       
  • ArcGIS Survery123
    • Feature (Points Only) collection from field
    • Supports Apple iOS, Android, Windows
    • New and Existing features can be collected
    • Offline editing is enabled
    • Supports anonymous access
  • GeoForm
    • Feature (Points Only) collection from field
    • Supported only through Web UI
    • New features can be collected or added but Existing feature edits are not supported
    • Supports anonymous access
       

With iPAD and Windows Mobile devices we recommend to use ArcGIS Collector and Survey123. Both are robust they are easy to use for end users, easy to administer workflows for GIS supervisors.

Should you have any questions please reach out to us here.

ESRI SDE Version Workflow and Integration with EAM Systems

The new version of Maximo can be configured to sync Asset and Location updates through feature service (ArcGIS REST Service) published from Versioned Workspace.  For example, in your Enterprise GIS system, you can create SDE Version for each workflow and post it to QAQC version. The Supervisor or QC Admin will review the QAQC version, resolve conflicts and post the edits to Default version. The Maximo feature service can be configured to consume either from QAQC version or Default version depending on your requirements.  A sample workflow is shown below to help ESRI Geodatabase Admin plan ESRI SDE Version workflow for Enterprise GIS.

ESRI Version Workflow for Maximo Integrations.png
Naren RanganathanComment
ESRI Integration with Maximo and SAP through ArcGIS Web Adaptor

Most of the ESRI integrations are through ArcGIS REST services. In order to publish REST services, there is an important need to review the architecture how REST services are published using ArcGIS Server technology.  Based on simple Single Machine strategy,  we need Windows Server, IIS Server (to serve web services)ArcGIS Server Standard or Advanced, ArcGIS Web Adaptor,  ArcGIS Desktop or ArcGIS Pro. 

Why to use ArcGIS Web Adaptor?

  • Allows to integrate Portal for ArcGIS with your organization's existing Web Servers such as IIS, Weblogic.

  • Allows to utilize your existing organization's identity store and security policies at the web-tier. For example you can tie-in active directory users authenticated using integrated Windows Login and ArcGIS portal .

  • Allows to expose ArcGIS Portal through port 80 and 443

Installation steps of ArcGIS Web Adaptor :

  • Verify minimum system requirements
  • Enable HTTPS on web server
  • Install ArcGIS Web Adaptor 
  • Configure ArcGIS Web Adaptor for use with Portal for ArcGIS
ArcGIS Web Adaptor.png
Naren RanganathanComment
ESRI Architecture for Maximo Integration

Here is the hardware list  for ESRI : 

  1. Load Balancer
  2. ArcGIS Web Adaptor
  3. ArcGIS Server
  4. Database  Server

Here is the hardware list for Maximo 

  1. Maximo UI , Maximo App Server, Database Server

ArcGIS Enterprise Implementation - Single Machine and Multiple Machines Architecture

 ArcGIS Enterprise Implementation for Single Machine- High Availability - Active

ArcGIS Enterprise Implementation for Single Machine- High Availability - Active

 ArcGIS Enterprise Implementation -Multiple Machines - High Availability with Third- Party Load Balancer

ArcGIS Enterprise Implementation -Multiple Machines - High Availability with Third- Party Load Balancer

Naren RanganathanComment
Sync GIS and Maximo

Starting Maximo 7.6, it is easy to configure seamless sync between ESRI and Maximo. 

Steps : 

  1. Configure  and Publish ArcGIS REST services (feature services if you are editing), (map services if you are just viewing)
  2. Log into Maximo 
  3. Go to Map Manager 
  4. Add feature service url
  5. Add individual layer
  6. Configure individual layers by creating GIS objects and also linking them with parent object as Workorder, or Location or Asset
  7. Save 
  8. Save map manager 

Internally for each GIS object, Maximo creates a multiversioned view and manages the updates through Java code behind the scenes. ( Technical tip) . For example if you create a GIS Object with name Valve then internally it creates a Valve_EVW database object. Also you can run SQL queries against this new object. For example you can run "Select count(*) from Valve_EVW;". 

 

 

 

ESRI, GE SmallWorld & Maximo Integration

For the utilities using GE Small World as core GIS software, we can automate extracting data into ESRI format for publishing ArcGIS REST services for Maximo spatial integration or for webmaps for ArcGIS Collector.
 

 The geospatial data is extracted from GE Smallworld GIS to ESRI Geodatabase.

The geospatial data is extracted from GE Smallworld GIS to ESRI Geodatabase.

  • GE Small World GIS --> Custom Sync Process --> ESRI --> ESRI REST Services --> Maximo
  • GE Small World GIS --> Custom Sync Process --> ESRI --> ESRI REST Services --> ArcGIS Collector

Please contact us or schedule a call how we can help extracting data from GE Small World GIS.