Configuring Responder/Smart Grid
Create Join Layers

Version: 10.1

Resource Center Home

Only the Calls and Load Points layers are created using join layers. All other Responder layers are created using XY Event Layers. Creating join layers allows you to join geographic features with Responder symbology.

Join layers allow you to join a feature class in the map with a table that contains additional information and display this information in the map. For example, you can symbolize customer calls on the map by linking the Service Point feature class with the RX_CALLS table. The table contains information about calls that are received from customers at service points.

  1. First, add a layer to the Responder_cached group by right-clicking the group layer and selecting Add Data . Add the feature class that is impacted by the layer you're creating. For example, Calls will be displayed on service points. Therefore you will add the ServicePoint layer to the Responder_cached group. The same holds true for load points. A load point denotes a service point that is impacted by an outage. Add the ServicePoint layer when creating the join layer for the load point.
  2. Once you've added the layer, right-click and select Properties. Use the General tab to rename the layer (e.g., Calls, Load Points) and click Apply.
  3. Next you will add the join to the layer. Select the Edit Joins tab in the Layer Properties window. 
  4. On the Edit Joins tab, click Add.
  5. The Add Join window displays the primary table associated with that layer (e.g., ServicePoint). Select a primary key within that table. In most instances, this is the ObjectID field.
  6. The Add Join window prompts you to select a foreign table to which the layer (primary table) is joined. Click Select to browse to and select the appropriate table.

The sample data uses the following tables for the Calls and Load Points layers.

  • Calls: RX_CALLS
  • Load Points: RX_LOADPOINTS
 
  1. Set the Cardinality to One to Many.
  2. Set the Join Type to Inner Join.
  3. Click OK to dismiss the Add Join window.
  4. Click OK to dismiss the Layer Properties window.

You can ensure that the join exists, by right-clicking the layer. Select Joins and Relates | Remove Joins. Your newly added join will appear in the Remove list. If you wish to remove it, select it from this menu.

Next, you will need to create XY Event layers.

 


Send Comment to documentation@schneider-electric.com