Pages

18 March 2013

Google Map in Oracle EAM (GIS Integration)


Geographic Information System (GIS) is an information system for storing, analyzing, managing and presenting digital data such as geographic features present on the Earth's surface using spatial references. Some of the GIS solutions available in the market are ESRI, Google Maps, Oracle Spatial, etc.

A Geocode (Geospatial Entity Object code) is a representation format of a geospatial coordinate measurement used to provide a standard representation of an exact geospatial point location on the earth. For example, the format (41°54'12"N, 87°37'35"W) indicates latitude, longitude of a unique location on earth.

Latitude gives the location of a place on earth north or south of the equator. Lines of Latitude are the horizontal lines shown running east-to-west on maps. Latitude is given as an angular measurement ranging from 0° at Equator to +90° at North Pole and -90° at South Pole. An example of a latitude in DMS (Degrees Minutes Seconds) format is 41°54'12"N

Longitude is the east-west geographic coordinate measurement. Longitude is given as an angular measurement ranging from 0° at the prime meridian to +180° eastward and −180° westward.
An example of a longitude in DMS (Degrees Minutes Seconds) format is 87°37'35"W

Release 12.1.1 enables GIS Integration using web based source map viewer of Google maps and provision is given to allow assets/ instances to be geocoded so that they can be spatially located on the map viewer. All item instances, i.e. EAM Assets and OAT instances are eligible to be geocoded and viewed in the Asset map viewer
Release 12.1.1 provides ability so that item instances can have a provision to capture their geocodes i.e. Latitude and Longitude. This can be done either manually through a mass data entry page or automatically through an API.

In Enterprise Assets Maintenance, users can search for any EAM assets using simple/ advanced search, enter geocodes for the assets using the 'Mass Geocode Entry' form, then locate the resulting asset on the map viewer by invoking the 'Map All' button. Alternatively, users can navigate to the Asset details page and locate the particular asset on the map viewer.

When a user selects any asset icon on the map viewer, details such as Asset Number, Description, Asset Group, Owning Department, Asset Location and Geocodes are displayed in a pop up. Also, hyperlinks are displayed for performing the following actions:
1. View asset details page
2. Create work request
3. Create work order
4. View open work requests
5. View open work orders
6. View Graphical Asset hierarchy.
When user selects any of the above actions, the page control is transferred to the appropriate tab in EAM responsibility with the context of the asset number selected. All other details corresponding to the selected asset number are defaulted when the page is rendered


Setup Steps

To enable the GIS Integration using Google Map feature, follow these instructions:

1. Set the following profile options:
  • (R) System Administrator
  • (N) Profile > Systems
    • 'CSI: Mapviewer Name' = Google
Profile value can be set at any level.
    • 'CSI: Google Registration key'
This profile hold the complete registration key (license key) for the Google Maps and can be set at any level
    • 'CSI: Google Map Client ID'
This profile hold the client ID for the licensed copy of