Run Orders Continued from page 43 Carefully fill out the dialog box when loading the Network_Street_Centroids_XY.dbf for Closest Facility analysis. Be patient while several thousand centroids load. lists arrival order, and Total_Minutes contains the travel time for each station to each centroid. Open the Fire Stations table and place it above the Routes attributes. 1. Before exporting arrival data for First through Fifth Due, join station names, apparatus, and personnel to each route. 2. To join Fire Station data to the Routes, rightclick on Routes in the TOC and select Join. 3. In the Join Data dialog box, choose Facility ID as the field in this layer that the join will be based on, choose Fire Stations as the table to join to the layer or load the table from, and choose INDEX as the field in the table to base the join on and choose Keep all records. 4. Click OK, allow indexing, and inspect the Routes table. With the Station Number (STATION_N) for up to five responders for each modeled street segment, the next step is the crux of this entire procedure. Exports and Joins Now to export the five tables, one for each arrival order, individually join each table to the streets, and calculate station and travel time for each arrival. After successfully joining Routes to Fire Stations, the next step is to apply a definition query to filter the Routes attributes by arrival and export each subset to a separate dBASE table. 1. In the TOC, right-click on Routes and choose Properties. Click the Definition Query tab. In the formula box, request all records where CFRoutes.FacilityRank = 1. This subset represents travel records for first-on-scene stations. Times should be short, especially near fire stations. ArcUser Fall 2009 Parameter Load From: Sort Field: Location Position: Name (under Location Analysis Properties): Search Tolerance: Table 3: Incident loading parameters Value Network_Street_Centroid_XYEvents INDEX Use Geometry INDEX 500 Feet Carefully set the Closest Facility Solver parameters. 2. The next step is to export the First Due records. In the filtered Routes attribute table, click Options and select Export. Save the exported table to Redlands\DBFFiles and name it RO_01.dbf. Do not add the table to the map yet. 3. Reset the definition query to CFRoutes. FacilityRank = 2 and export again, saving as RO_02.dbf. Again, don't add the table to the map. 4. Repeat this procedure for RO_03, RO_04, and RO_05. Now, add all five RO files to your map. Save the project again. Join the filtered dBASE files to the Street with Speed layer to calculate values, then remove the join. www.esri.com