Version: 10.1

Resource Center Home

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

1. First, have your Database Administrator create Spatial Views in the database. Below is a sample script for the Calls view, followed by a sample script for the Load Points view.

   Calls:

   sdetable -o create_view -T CALLS_SPVIEW -t ARCFM.SERVICEPOINT,RESPONDER.RX_CALLS 
   –c ARCFM.SERVICEPOINT.OBJECTID,RESPONDER.RX_CALLS.ID,RESPONDER.RX_CALLS.DEVICE_OID,RESPONDER.RX_CALLS.DEVICE_FCID,
   RESPONDER.RX_CALLS.INCIDENT_ID,RESPONDER.RX_CALLS.CUSTOMER_ACCOUNT,RESPONDER.RX_CALLS.TROUBLE_AT_ACCOUNT 
   -w "ARCFM.SERVICEPOINT.OBJECTID=RESPONDER.RX_CALLS.DEVICE_OID" -i sde:oracle10g -u username -p password@server -s server
   

   Load Points:

   sdetable -o create_view -T LOADPOINTS_SPVIEW -t ARCFM.SERVICEPOINT,RESPONDER.RX_LOADPOINTS 
   -c ARCFM.SERVICEPOINT.OBJECTID,RESPONDER.RX_LOADPOINTS.ID,RESPONDER.RX_LOADPOINTS.DEVICE_OID,RESPONDER.RX_LOADPOINTS.DEVICE_FCID,
   RESPONDER.RX_LOADPOINTS.INCIDENT_ID -w "ARCFM.SERVICEPOINT.OBJECTID=RESPONDER.RX_LOADPOINTS.DEVICE_OID" -i sde:oracle10g 
   -u username -p password@server -s server
   

   Once your Database Administrator has created these scripts in the database, you can add them to your Responder_cached group in ArcMap.

2. In ArcMap, right-click Responder_cached on the Display tab and select Add Data.
3. Browse to and select the views for Calls (e.g., CALLS_SPVIEW) and Load Points (e.g., LOADPOINTS_SPVIEW).
4. Click OK.

 

For an additional performance improvement, do not display these layers at large scales.

 

---

Send Comment to documentation@schneider-electric.com