Data
We will use the Fire Department Calls for Service dataset from DataSF. This dataset includes all fire units' responses to calls. Calls can involve multiple units so there can be many rows with the same call number. The license for the data is as follows:
"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/"
OpenData. 2020. Fire Department Calls for Service [CSV File]. Retrieved from https://data.sfgov.org/Public-Safety/Fire-Department-Calls-for-Service/nuek-vuh3 on Feb 13, 2020.
Overview of the dataset:
The Fire Department Calls for Service dataset contains the following columns:
Note: Highlighted columns represent data we will tentatively target in our visualizations
| # | Column | Description | Type | Values |
|---|---|---|---|---|
| 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. | Text | [200430004, 200444351,...] |
| 2 | Unit ID | Unit Identifier. For example E01 for Engine 1 or T01 for Truck 1. | Text | [73, E19,...] |
| 3 | Incident Number | A unique 8-digit number assigned by DEM to this Fire incident. | Text | [20019300, 20019299,...] |
| 4 | Call Type | Type of call the incident falls into. | Text | [Medical Incident, Alarms, Structure Fire,...] |
| 5 | Call Date | Date the call is received at the 911 Dispatch Center. Used for reporting purposes. | Date & Time | [04/12/2000-02/13/2020] |
| 6 | Watch Date | Watch date when the call is received. Watch date starts at 0800 each morning and ends at 0800 the next day. | Date & Time | [04/12/2000-02/13/2020] |
| 7 | Received DtTm | Date and time of call is received at the 911 Dispatch Center. | Date & Time | [2000 Apr 12 09:00:29 PM - 2020 Feb 13 11:59:15 PM] |
| 8 | Entry DtTm | Date and time the 911 operator submits the entry of the initical call information into the CAD system. | Date & Time | [2000 Apr 12 09:01:40 PM - 2020 Feb 13 11:58:02 PM] |
| 9 | Dispatch DtTm | Date and time the 911 operator dispatches this unit to the call. | Date & Time | [2000 Apr 12 09:02:00 PM - 2020 Feb 13 11:59:22 PM] |
| 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. | Date & Time | [2000 Apr 12 09:11:51 PM, ...] (can be blanks) |
| 11 | On Scene DtTm | Date and time the unit records arriving to the location of the incident. | Date & Time | [2000 Apr 12 09:14:11 PM ...] (can be blanks) |
| 12 | Transport DtTm | If this unit is an ambulance, date and time the unit begins driving to the hospital. Otherwise, blank. | Date & Time | [2000 Apr 12 09:38:18 PM ...] (can be blanks) |
| 13 | Hospital DtTm | If this unit is an ambulance, date and time the unit arrives at the hospital. | Date & Time | [2000 Apr 12 09:48:13 PM ...] (can be blanks) |
| 14 | Call Final Disposition | Disposition of the call (Code). For example TH2: Transport to Hospital - Code 2, FIR: Resolved by Fire Department. | Text | [Other, Fire, Unable to Locate, SFPD,...] |
| 15 | Available DtTm | Date and time this unit is not longer assigned to this call and it is available for another dispatch. | Date & Time | [2000 Apr 12 09:20:36 PM ...] (can be blanks) |
| 16 | Address | Address of midblock point associated with incident (obfuscated address to protect caller privacy). | Text | [100 Block of CAMBON DR,...] |
| 17 | City | City of Incident. | Text | [San Francisco, SAN FRANCISCO, Hunters Point,...] (can be blanks) |
| 18 | Zipcode of Incident | Zipcode of incident. | Text | [94132, 94107, 94118...] |
| 19 | Battalion | Emergency Response District. (There are 9 Fire Emergency Response Districts.) | Text | [B08, B07, B02,...] |
| 20 | Station Area | Fire Station First Response Area associated with the address of the incident. | Text | [19, 40,...] |
| 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. | Text | [8428, 7433,...] |
| 22 | Original Priority | Initial call priority (Code 2: Non-Emergency or Code 3:Emergency). | Text | [E, 3, 2, 1] |
| 23 | Priority | Call priority (Code 2: Non-Emergency or Code 3:Emergency). | Text | [3, 2, 1] |
| 24 | Final Priority | Final call priority (Code 2: Non-Emergency or Code 3:Emergency). | Text | [3, 2, 1] |
| 25 | ALS Unit | Does this unit includes ALS (Advance Life Support) resources? Is there a paramedic in this unit? | Boolean (True/False) | [True, False] |
| 26 | Call Type Group | Call types are divided into four main groups: Fire, Alarm, Potential Life-Threatening, and Non Life-Threatening. | Text | [Non Life-threatening, Potentially Life-Threatening, Alarm, Fire,...] |
| 27 | Number of Alarms | Number of alarms associated with the incident. This is a number between 1 and 5. | Numeric | [1-5] |
| 28 | Unit Type | Unit type | Text | [MEDIC, TRUCK, ENGINE, CHIEF, PRIVATE, RESCUE SQUAD] |
| 29 | Unit sequence in call dispatch | A number that indicates the order this unit was assigned to this call. | Numeric | [1-83] (can be blank) |
| 30 | Location | Latitude and longitude of address obfuscated either to the midblock, intersection, or call box | Coordinates | [(37.758510055874°, -122.420168825295°),...] |
| 31 | Fire Prevention District | Bureau of Fire Prevention District associated with this address. | Text | [1-6] (can be blank) |
| 32 | Supervisor District | Supervisor District associated with this address. | Text | [5, 6,...] (can be blank) |
| 33 | Neighborhoods - Analysis Boundaries | Neighborhood District associated with this address, boundaries available here. | Text | [Mission, Nob Hill, Tenderloin, Golden Gate Park,...] |
| 34 | RowID | Unique identifier used for managing data updates. It is the concatenation of Call Number and Unit ID separated by a dash. | Text | [180311463-T19,...] |