Create Definition Queries

Rather than using Join Layers to create the Calls and Load Points layers, you can use Definition Queries. All other Responder layers are created usingXY Event Layers or Query Layers. With this method, Responder users may see an increased performance.

TIP: If you encounter errors while progressing through the steps below, read the Nested Query Limitation with Joins topic for more information.

This applies to the LoadPoints and Calls layers.

  1. In ArcMap, right-click Responder_cached on the Display tab and select Add Data.
  2. Add the ServicePoint feature class. This is the class on which the definition query is created.
  3. Right-click the ServicePoint layer you just added and select Properties.
  4. Select the Definition Query tab.
  5. Provide the query information. Samples are provided below. You must add a new layer for each definition query. To create definition queries for both loadpoints and calls, then you must add the ServicePoint feature class to the map twice.

    Loadpoints

    In the sample below, the query connects the ServicePoint feature class (on which the definition query exists) to the RX_LOADPOINTS table. Be sure your query reflects the accurate table name and owner (Responder, in the example).

    OBJECTID in (select DEVICE_OID from RESPONDER.RX_LOADPOINTS)

    Calls

    In the sample below, the query connects the ServicePoint feature class (on which the definition query exists) to the RX_CALLS table. Be sure your query reflects the accurate table name and owner (Responder, in the example).

    oOBJECTID in (select DEVICE_OID from RESPONDER.RX_CALLS)

  6. Once you've finished adding the definition query, click Apply.
  7. Next, select the General tab. Here you can name the layer using the Layer Name field (e.g., LoadPoints, Calls). Click Apply.
  8. Click the Symbology Tab to determine how these features appear on the map. In the Show column, select Single Symbol under Features.
  9. At the right, click the symbol to edit it.
  10. Click OK to save changes and dismiss the Layer Properties.
QR code for this page

Was this helpful?