Define Layer Mapping

Explanation

This activity is the first of two steps to enable geodata to be shown in the GIS Map. This is done by first entering a service (URL) and then by defining the relationship between geographical layers in geodatabase (Layer ID) and business object's logical unit (LU name) in IFS Cloud. This enables two things:

• Defining the service and layer enables GIS information to be shown in GIS Map page.
• Defining the LU enables connection between GIS object and IFS business objects to be made in GIS Map page.

This activity should be performed by a system administrator or equivalent person. The second step is to add layers and users in GIS Layer Group page.

Add Editable Layers in GIS Map page:

In the GIS Layer Mapping page, create a new record entering the Map Service URL, Layer ID, Layer Display Name, LU Name and selecting the Layer Type as Editable.

Optionally, enter a SQL Condition. This condition filter values shown in Link Object dialog. The value in the condition field must follow the format: column_name, value and operator. For example, a logical unit LinastLinearAsset with database view LINAST_LINEAR_ASSET_UIV:

• Condition: revision_status_db in ('Preliminary','Active') and linear_asset_type = 'ROAD-TRUNK'.

Optionally, select a Sort Order. This controls the order in which layers are shown in layer navigator and in which order layers are loaded in GIS Map.

Add Read Only Layers in GIS Map page:

In the GIS Layer Mapping page, create a new record entering the Map Service URL, Layer ID, Layer Display Name and selecting the Layer Type as Read Only.

Add Basemaps - in GIS Map page:

In the GIS Layer Mapping page, create a new record entering the Map Service URL, Layer Display Name and selecting the Layer Type as Basemap.

Enter a Definition Expression - Filter GIS objects in GIS Map page by using a definition expression:

In the GIS Layer Mapping page, Definition Expression field, enter a layer's attribute name and a valid SQL search criteria:

• color = 'Red' shows GIS objects in GIS Map window where its value is equal to Red in the attribute field with name color.
• color like 'B%' shows GIS objects where its values starts with a B like Blue and Brown.
• color in ('Blue','Yellow') shows GIS objects where the list consists of values Blue and Yellow.

Add layer to your user in GIS Layer Group page. Open GIS Map and toggle on the layer in Layer Navigator. GIS objects will be shown according to the above definition expression.

The following is valid for a definition expression:

• Definition Expression is optional.
• It filters GIS objects in GIS Map by using layer's attributes (fields) and values in ArcGIS.
• A correctly entered expression has effect on both editable layers (feature service) and read only layers (map service).
• A recommendation is to first test definition expression on the layer's REST service query page on ArcGIS, before entering it in GIS Layer Mapping page. If the query retrieves values on Rest service page, then it will also work when used as a definition expression in GIS Integration. How to enter a successful query on a layer by using the REST service page is described in ArcGIS online documentation.
• Possible attributes (fields) to search on are found on the layer's REST service page, under a section called Fields.
• Possible SQL operators:

=	Equal
<>	Not equal. Note: This operator may also be written as !=
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal
BETWEEN	Between an inclusive range
LIKE	Search for a pattern
IN	To specify multiple possible values for a column

Enter Label Options - Show a text on GIS objects by using label options.

In the GIS Layer Mapping page, Label Options field for an Editable layer, enter values for text, color, size, font and visible scale ranges in a list, by using the following attributes: labelText, fontColor, fontSize, fontFamily, minScale and maxScale. A complete list could look as follows:

{
"labelText": "Historical Work Order",
"fontColor": "#FF0000",
"fontSize": 14,
"fontFamily": "Arial",
"minScale": "165000000",
"maxScale": "5000"
}

The above list will show the text Historical Work Order on GIS objects in red color with font size 14 and font type Arial.

The following is valid for a label option:

• The label option functionality in the GIS integration is not the same as the more advanced configuration of labels available in ArcGIS Online and in ArcGIS Desktop Tools. The label options functionality in the GIS integration is a quick and easy way of creating labels, by using a set of available control attributes, without having to use any ArcGIS tools.
• Label options only apply to editable layers.
• Visible scale ranges:

Minimum scale (minScale) - Label will not be drawn if you zoom out beyond the defined scale value. For example, enter a high value like 165000000 and the label will not be shown when zooming out beyond the scale 1:165000000.

Maximum scale (maxScale) - Label will not be drawn if you zoom in beyond the defined scale. For example, enter a high value like 5000 and the label will not be shown when zooming in beyond the scale 1:5000.

• The value for color (fontColor) should be entered in hexadecimal format, like this:

Black: #000000
Red: #FF0000
Lime: #00FF00
Blue: #0000FF

The above values are just examples. Available hexadecimal values for colors can easily be found on the Internet.

• It's possible to show attribute (field) values from the layer in ArcGIS. Possible fields to show values from, are found on the layer's feature service, on ArcGIS REST interface. Open the REST URL for the layer's service in a web browser. Fields for the layer are shown in a section called Fields. For example consider a layer with the following fields:

ROUTE ( type: esriFieldTypeString , alias: ROUTE , editable: true , nullable: true , length: 15 )
STREET ( type: esriFieldTypeString , alias: NAME , editable: true , nullable: true , length: 40 )

• The field name is case sensitive. It's a good idea to review layer's field name carefully and enter it in the exact same way as shown on the layer's ArcGIS REST interface.
• Field names should be entered within curly brackets, like this: "labelText": "{ROUTE} {STREET}"
• Text can be added like this: "labelText": "Route: {ROUTE} Name: {STREET}"
• The complete list of attributes and attributes for fields should be enclosed by curly brackets. The following will show values from the ROUTE field and the STREET field:

{
"labelText": "Route: {ROUTE} Name: {STREET}",
"fontColor": "#FF0000",
"fontSize": 14,
"fontFamily": "Arial",
"minScale": "165000000",
"maxScale": "5000"
}

• Labels might not appear in situations when GIS objects in the map are close to each other. The solution is to zoom in.

Use Proxy - Set the layer to always use the proxy.

It is possible to allow automatic access to secured map services, without showing ArcGIS logon dialog, by entering the ArcGIS user credentials in the proxy. A token will be automatically generated by the REST service and be valid for 60 minutes. This requires the setting Use Proxy to be enabled on the layer in GIS Layer Mapping page. The following should be valid for the selected layer:

• Map service is secured (private) and requires the user to logon by entering credentials.
• Map service URL is added in proxy configuration, as described in Define GIS Settings and GIS Concepts.
• Map service URL in proxy configuration is defined with user name and password, as described in Define GIS Settings and GIS Concepts.

 In all other situations the setting Use Proxy can be disabled.

Prerequisites

A map or a feature services should have been created and made available on ArcGIS servers:

• Editable layers should have the service URL format: http://<host>/<instance>/rest/services/<serviceName>/FeatureServer
• Read only layers and background maps (basemaps) should have the URL format: http://<host>/<instance>/rest/services/<serviceName>/MapServer
• Added layers could have been made available on many different ArcGIS servers, both locally and on cloud services like ArcGIS online and ArcGIS portal.

The following are described in ArcGIS online documentation and must have been completed before entering an URL in layer mapping:

• How to install an ArcGIS server or how to use the cloud service called ArcGIS online.
• How to create layers.
• How to publish layers to a service on a ArcGIS server.
• How to make a service available for users on an ArcGIS server.
• How to define wanted operations on services: Create, Delete, Query, Sync and Update on a ArcGIS server.

Logical units (LU) should have been defined with value GisintConnections as a service name in Solution Manager/User Interface/Object Connections. This enables LU to be shown and selected from List of Values in GIS Object Configuration page.

User should be have been assigned with DEFINE_SQL system privilege in order to enable values to be entered in Condition field.

System Effects

The following three different types of geodata will be made available in GIS Map page:

1. GIS objects using editable layers and where business object connections can be made.
2. GIS objects using read only layers.
3. Background map (basemap), like maps and building layouts.

More information about editable layers, read only layers and basemaps are found in GIS Concepts.

The following is also valid for the below layer mapping:

• GIS objects in GIS Map page is not shown until both GIS layer mapping and GIS layer group configuration is completed.
• Secured layers (private) are not shown in GIS Map, until proxy configuration is completed: Define GIS Settings and GIS Concepts.
• Enter a value for sort order to control in which order layers are shown and loaded GIS Map page. Try to change sort order if a point feature is hidden behind a polygon or a line.
• It's not possible to add the same layer twice. URL and layer ID must differ.

Pages

GIS Layer Mapping

Activity Diagrams

BDR for GIS Integration