Data Midterm Chinchillas

Fire Department SF data set

Data

Our data set is taken from Data SF, it is the fire department Calls for Service data set. It has 34 columns and 5.4M rows. You can find the full data set at Data sf. it's under the following license:

"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/"

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 data set column descriptions are as follow:

Field Name Data Type Definition
Call Number Text 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.
Unit ID Text Unit Identifier. For example E01 for Engine 1 or T01 for Truck 1.
Incident Number Text A unique 8-digit number assigned by DEM to this Fire incident.
Call Date Date & Time Date the call is received at the 911 Dispatch Center. Used for reporting purposes.
Call Type Text Type of call the incident falls into. See the list below.
Watch Date Date & Time Watch date when the call is received. Watch date starts at 0800 each morning and ends at 0800 the next day.
Received DtTm Date & Time Date and time of call is received at the 911 Dispatch Center.
Entry DtTm Date & Time Date and time the 911 operator submits the entry of the initical call information into the CAD system
Dispatch DtTm Date & Time Date and time the 911 operator dispatches this unit to the call.
Response DtTm Date & Time Date and time this unit acknowledges the dispatch and records that the unit is en route to the location of the call.
On Scene DtTm Date & Time Date and time the unit records arriving to the location of the incident
AVL Validated On Scene DtTm Date & Time Updated date and time the unit arrived on scene based on existing unit AVL coordinates.
Transport DtTm Date & Time If this unit is an ambulance, date and time the unit begins the transport unit arrives to hospital
Hospital DtTm Date & Time If this unit is an ambulance, date and time the unit arrives to the hospital.
Call Final Disposition Text Disposition of the call (Code). For example TH2: Transport to Hospital - Code 2, FIR: Resolved by Fire Department
Available DtTm Date & Time Date and time this unit is not longer assigned to this call and it is available for another dispatch.
Address Text Address of midblock point associated with incident (obfuscated address to protect caller privacy)
City Text City of incident
Zipcode of Incident Text Zipcode of incident
Battalion Text Emergency Response District (There are 9 Fire Emergency Response Districts)
Station Area Text Fire Station First Response Area associated with the address of the incident
Box Text 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.
Original Priority Text Initial call priority (Code 2: Non-Emergency or Code 3:Emergency).
Priority Text Call priority (Code 2: Non-Emergency or Code 3:Emergency).
Final Priority Text Final call priority (Code 2: Non-Emergency or Code 3:Emergency).
ALS Unit Boolean (True/False) Does this unit includes ALS (Advance Life Support) resources? Is there a paramedic in this unit?
Call Type Group Text Call types are divided into four main groups: Fire, Alarm, Potential Life Threatening and Non Life Threatening.
Number of Alarms Numeric Number of alarms associated with the incident. This is a number between 1 and 5.
Unit Type Text Unit type
Unit sequence in call dispatch Numeric A number that indicates the order this unit was assigned to this call
Location Coordinates Latitude and longitude of address obfuscated either to the midblock, intersection or call box
Fire Prevention District Text Bureau of Fire Prevention District associated with this address
Supervisor District Text Supervisor District associated with this address
Neighborhood District Text Neighborhood District associated with this address, boundaries available here: https://data.sfgov.org/d/p5b7-5n3h
RowID Text Unique identifier used for managing data updates. It is the concatenation of Call Number and Unit ID separated by a dash