SFFD Efficiency Visual Analysis

Jiadong Wu & Xue Feng

Data

The assigned SF Fire Department Calls for Service is a public dataset hold by San Francisco government. The data contains 4.9M rows with 34 columns and each row represent a response. Since the dataset is really huge, we decided to focus on a subset of it in order to narrow down our project under a specific theme.

The code book can be found here.

Processing

In general, we filtered SF Fire Department Calls for Service and took the data starting from 2019/1/1 to 2019/1/31 as our measurement. Our goal is to find out the efficieny measured from different perspectives.

HeatMap (Vis #1):

The heat map made by Jiadong visualize the SFFD respnse efficieny among Top 5 "Rich Neighborhoods" and Top 5 "Poor Neighborhoods" in San Francisco. This heatmap is designed to discover potential social injustice on the waiting time after calling 911.

Bubble Chart (Vis #2):

Xue Feng measures San Francisco Fire Department efficieny based on 41 different regions/districts of SF. There are 6 original data categories (from our filtered dataset) being used (Details are shown below). Two(Call Number and Neighborhood District) of them are used directly to generate the bubble chart visualization, and the other three are used for further data processing and generates three other new categories for the visualization.

Some case numbers have multiple reports because different units are assigned to a same incident. Therefore, 1) Xue Feng merged rows with same Call Number into a single row; 2) When measuring new categories: Received Time to Dispatch Time or Dispatch Time to On Scene Time, Xue Feng calculates the time difference of each single Call Number that has multiple rows by using the formula: result = (latest time in the first column[minuend] - the earliest time in the second column[subtrahend]).

Original Field Names:

Call Number - A unique 9-digit number assigned by the 911 Dispatch Center (DEM) to this call. These number are used for both Police and Fire calls.
Battalion - Emergency response district (There are 10 Fire Emergency Response Districts).
Received DtTm - Date and time of call is received at the 911 Dispatch Center.
Response DtTm - Date and time this unit records acknowledges the dispatch and records that the unit is en route to the location of the call.
Dispatch DtTm - Date and time the 911 operator dispatches this unit to the call.
On Scene DtTm - Date and time the unit records arriving to the location of the incident.
Neighborhood District - Neighborhood District associated with this address, boundaries available here.
Location - Latitude and longitude of address obfuscated either to the midblock, intersection or call box.

Newly Generated Field Names:

Efficiency- This new column is generated by [ Response DtTm - Received DtTm].
Received Time to Dispatch Time - This new column is generated by (latest Dispatch DtTm - earlist Reveived DtTm).
Dispatch Time to On Scene Time - This new column is generated by (latest On Scene DtTm - earlist Dispatch DtTm).
Latitude - Latitude is generated by Location.

**The heatmap visualization uses categories in blue.
**The bubble chart visualization uses categories in green.

Extra Credit

Vis#1 - Number of Incidents of SFFD from 41 Regions in San Francisco

Vega-Lite Bar Chart



Vis#2 - Top 10 Number of Records Distribution of SFFD Call Type