Diving Into the Numbers
During the Feb 16th session we took a deep dive into the numbers to see how the existing fire districts in Floyd County are performing for both Fire & EMS. The source data (provided in the supporting documents at the bottom) were provided by Sheriff Frank Loop’s team, which were extracted from the CAD platform. The Dispatch (CAD) system is a national platform used by many agencies throughout the United States.
A majority of the updates for this sessions will be diving deep into the what the numbers means, how they were calculated, and how they compare to national fire & EMS standards. Lets get to it.
The Data Model:
The raw data used to create the visualizations required a joining of addressed information for each call, which we used two separate data tables to do (not terribly difficult). The next level down was to calculate the response per call, which added the duration from dispatch to arrival of the unit(s) to the emergency. The last step was to get an average time per run because most emergency calls send multiple units from different districts within the County.
The Results
The results of the data model were put into a Power BI Dashboard to allow for additional slicing and dicing of views (i.e. different way to look at the information). In this section I will breakdown various elements of the data which were discussed on the call at length.
The combined Fire and EMS Average response time was 8 mins and 28 seconds for the entire county.
(Reference image 1: Total Combined (Fire & EMS) Average Response Dashboard)
Looking purely at Fire Department response times, the average response time is 6 mins and 37 seconds for the entire county. Noting, Fire Departments respond to all types of emergencies; see “nature” on the left side of the dashboard.
(Reference Image 2: Fire Response Times (combined))
According to the International Association of Fire Fighters (IAFF) the national average response times are between 7-8 mins for agencies with mostly fulltime/career staffing. Those numbers increase with non-career/part-time/volunteer staffing.
Breakdowns by Fire District, which is the fire department responding to any Emergency in the County (not just their district):
- New Albany Township (Served by New Chapel Fire): 4 mins 47Sec
- Lafettye Twsp: 7 mins 36 Sec
- Georgetown Twsp: 8 mins 33 Sec
- Greenville Twsp: 9 mins 37 sec
**Note, the formation of this twsp fire is < 2 year so data is skewed/light) - Franklin Twsp: Insufficient data due to service being provided by contract outside the county
Breakdown by City within the County, regardless of which Fire District responded:
- New Albany: 5 Mins 53Sec
- Georgetown: 6 Mins 30 Sec
- Floyds Knobs: 6 Mins 15 Sec
- Greenville: 8 Mins 21 Sec
Join the Meetings
Meetings are hosted through Microsoft Teams and will be virtual only while the County is in a COVID RED status.
Join on your computer or mobile app by clicking this URL/Link during the meeting date/time: bit.ly/FCFD21
Once opening the link, choose “Continue on this browser”
Alternatively, you can call in (you won’t be able to view any screens that are shared)
+1 773-917-3399,312334632# United States, Chicago
Phone Conference ID: 312 334 632#
The meeting dates/times are:
Wednesday, March, 3, 2021-6:00 P.M.
Wednesday, March 17, 2021-6:00 P.M.
**Additional meetings will be communicated when they are established.