Create Query Layers

NOTE: We recommend using Query Layers instead of XY Event Layers.  In addition to performance improvements, Query Layers supports both Search and Identify functionality in the Responder Web/ArcFM Server integration. This functionality is limited with XY Event Layers.
  1. From the main menu, select File | Add Data | Add Query Layer. Or, right-click Layers and select Add Data.
  2. Browse to the table in the database. Below are the tables used by the Responder layers in the sample data.
    • Hazards: RX_HAZARDS

    • Tags and Grounds: RX_TAGS_AND_GROUNDS

    • Non-electric Features: RX_INCIDENT_FEATURES

    • Incidents:

      • Incident Devices: RX_INCIDENT_DEVICES_VIEW

      • Cut Wire Incident: RX_INCIDENT_DEVICES_CUTS_VIEW

      • Single Premise Incident: RX_INCIDENT_DEVICES_SVC_VIEW

    • Crews:

      • Crews:Electric Incident: RX_CREW_INCDEV_VIEW

      • Crews:Non-electric Incident: RX_CREW_INCFEAT_XY_VIEW

        To display truck information rather than crew data, use the following view.

      • Trucks: RX_TRUCK_INCDEV_VIEW

  3. Click Add. The New Query Layer window opens.
  4. Select unique identifiers for the view. For Responder views, the unique identifier is a combination of Device_FCID and Device_OID. For tables such as RX_Hazards, that already have a unique identifier, select ID.
    NOTE: For full functionality using the Search and Identify tools in the ArcFM Server integration with Responder Web, you must either select multiple fields as the primary key, or make sure your primary key has one of the following names:
    • Object ID

    • ObjectID


    • ESRI_OID

    • OID

    • ID

  5. Click Finish.
  6. Right-click the Query Layer created in the List by Source view of the Table of Contents, then select Display XY Data.
  7. Verify the XY data is correct on the Display XY Data window and click OK.
  8. Once you've added the Query layer, right-click it and select Properties. Select the General tab and modify the Layer Name as appropriate.
  9. By default, the Query layers are added under the Layers node on the Display tab. Click the Query layers and drag them into the Responder_cached group. Some of the layers in the sample data are organized into group layers (e.g., Hazards, Incidents, Crews) within the Responder_cached group.

Once you've finished adding Query layers, you can create symbology for them.

QR code for this page

Was this helpful?