MidTerm Project

SF Fire Department Calls for Service DataSet Analysis

Data

Fire Calls-For-Service includes all fire units responses to calls. Each record includes the call number, incident number, address, unit identifier, call type, and disposition. All relevant time intervals are also included. Because this dataset is based on responses, and since most calls involved multiple units, there are multiple records for each call number. Addresses are associated with a block number, intersection or call box, not a specific address.

The original dataset includes over 5.21M rows as of 16 February 2020. The original dataset includes 34 columns and each row is a response. The direct link to data set is: https://data.sfgov.org/Public-Safety/Fire-Department-Calls-for-Service/nuek-vuh3/data . The full citation is :

"This data is made available under the Public Domain Dedication and License v1.0 whose full text can be found at: www.opendatacommons.org/licenses/pddl/1.0/"

Data acquired from https://datasf.org/opendata/ on February 16 2020. Aggregated data on this page is made freely available under Open Data Commons Public Domain Dedication and License(https://opendatacommons.org/licenses/pddl/1.0/).

The dataset has following columns:

  1. 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. The column is encoded as plain text.
  2. Unit ID: Unit Identifier. For example E01 for Engine 1 or T01 for Truck 1. The column is encoded as plain text.
  3. Incident Number: A unique 8-digit number assigned by Dispatch Center (DEM) to this Fire incident. The column is encoded as plain text.
  4. Call Type: Type of call the incident falls into. The list is as follows: Medical Incident, Structure Fire, Alarms, Traffic Collision, Other, Citizen Assist / Service Call, Outside Fire, Administrative, Vehicle Fire, Water Rescue, Gas Leak (Natural and LP Gases), Odor (Strange / Unknown), Electrical Hazard, Elevator / Escalator Rescue, Smoke Investigation (Outside), Fuel Spill, Transfer, HazMat, Industrial Accidents, Explosion, Aircraft Emergency, Assist Police, Train / Rail Incident, High Angle Rescue, Watercraft in Distress, Extrication / Entrapped (Machinery, Vehicle), Oil Spill, Marine Fire, Mutual Aid / Assist Outside Agency, Confined Space / Structure Collapse, Suspicious Package, Train / Rail Fire, Lightning Strike (Investigation). The column is encoded as plain text.
  5. Call Date: Date the call is received at the 911 Dispatch Center. Used for reporting purposes. The column is encoded as Date and Time.
  6. Watch Date: Watch date when the call is received. Watch date starts at 0800 each morning and ends at 0800 the next day. The column is encoded as Date and Time.
  7. Received DtTm: Date and time of call is received at the 911 Dispatch Center. The column is encoded as Date and Time.
  8. Entry DtTm: Date and time the 911 operator submits the entry of the initical call information into the CAD system. The column is encoded as Date and Time.
  9. Dispatch DtTm: Date and time the 911 operator dispatches this unit to the call. The column is encoded as Date and Time.
  10. Response DtTm: Date and time this unit acknowledges the dispatch and records that the unit is en route to the location of the call. The column is encoded as Date and Time.
  11. On Scene DtTm: Date and time the unit records arriving to the location of the incident. The column is encoded as Date and Time.
  12. Transport DtTm: If this unit is an ambulance, date and time the unit begins the transport unit arrives to hospital. The column is encoded as Date and Time.
  13. Hospital DtTm: If this unit is an ambulance, date and time the unit arrives to the hospital. The column is encoded as Date and Time.
  14. Call Final Disposition: Disposition of the call (Code). For example TH2: Transport to Hospital - Code 2, FIR: Resolved by Fire Department. The column is encoded as plain text.
  15. Available DtTm: Date and time this unit is not longer assigned to this call and it is available for another dispatch. The column is encoded as Date and Time.
  16. Address:Address of midblock point associated with incident (obfuscated address to protect caller privacy). The column is encoded as plain text.
  17. City: City of incident. The column is encoded as plain text.
  18. Zipcode of Incident: Zipcode of Incident. The column is encoded as plain text.
  19. Battalion: Emergency Response District (There are 9 Fire Emergency Response Districts). The column is encoded as plain text.
  20. Station Area: Fire Station First Response Area associated with the address of the incident. The column is encoded as plain text.
  21. Box: Fire box associated with the address of the incident. A box is the smallest area used to divide the City. Each box is associated with a unique unit dispatch order. The City is divided into more than 2,400 boxes. The column is encoded as plain text.
  22. Original Priority: Initial call priority (Code 2: Non-Emergency or Code 3:Emergency). The column is encoded as plain text.
  23. Priority: Call priority (Code 2: Non-Emergency or Code 3:Emergency). The column is encoded as plain text.
  24. Final Priority: Final call priority (Code 2: Non-Emergency or Code 3:Emergency). The column is encoded as plain text.
  25. ALS Unit: Does this unit includes ALS (Advance Life Support) resources? Is there a paramedic in this unit? The column is encoded as check box.
  26. Call Type Group: Call types are divided into four main groups: Fire, Alarm, Potential Life Threatening and Non Life Threatening. The column is encoded as plain text.
  27. Number of Alarms: Number of alarms associated with the incident. This is a number between 1 and 5. The column is encoded as number.
  28. Unit Type: Unit type. The column is encoded as plain text.
  29. Unit sequence in call dispatch: A number that indicates the order this unit was assigned to this call. The column is encoded as number.
  30. Fire Prevention District: Bureau of Fire Prevention District associated with this address. The column is encoded as plain text.
  31. Supervisor District: Supervisor District associated with this address. The column is encoded as plain text.
  32. Neighborhooods - Analysis Boundaries: Neighborhood District associated with this address. The column is encoded as plain text.
  33. Location: Latitude and longitude of address obfuscated either to the midblock, intersection or call box. The column is encoded as location.
  34. RowID: Unique identifier used for managing data updates. It is the concatenation of Call Number and Unit ID separated by a dash. The column is encoded as plain text.

Wrangling

For reaching to a conclusion, we will be considering the data for year 2019. The data is filtered by "Received DtTm" column and its corresponding value will be between "January 2019" and "December 2019".

        Filtered by: Received DtTm      >=   January 1, 2019
                     and Received DtTm  <=   December 31, 2019