San Francisco Fire Data - Exploratory Analysis

Load Data

Download fire incident data from 2003 onwards from the below url and load the data

https://data.sfgov.org/Public-Safety/Fire-Incidents/wr8u-xric

Data cleanup

• Incidents have been consoldated into types based on National Fire Incident Reporting System (NFIR) definitions

Some insights

1. Exploring all incidents

1a. Types of incidents

• Majority of the incidents, more than 40%, are false alarms. This is nearly 5 times higher than the national average of around 8% - https://drive.google.com/file/d/0B0PBSKO1TtM7dHZJY2lrc3BGNlU/view?usp=sharing

• This is followed by Rescue, EMS and other service calls and then

• Fires

The false alarms seem to add a lot to the workload. It would be interesting to see what kind of educational and other initiatives the city undertakes to reduce the number of false alarms.

1b. Response and resolution times

• Exploring time taken to respond and time spent in resolving incidents

2. Exploring False Alarms

2a. Details of False Alarms

2b. Pattern of False Alarms

• A lot of False Alarms seem to occur at the same location/physical address.

• Exploring locations with a history of False Alarms (one False Alarm per month) - as a percentage of total False Alarms.

3. Exploring fire incidents

3a. Details of fire incidents

• Cooking, trash and rubbish fires constitute more than 40% of all the fire incidents.
• Building fires are around 10% of all the fire incidents.

3b. Trend of fire incidents by year

• Total number of fire incidents have been steady over the last decade with a dip in 2014

• Building fires have been steadily declining

3c. Trend of fire incidents by month

• There is a spike in average number of all fire incidents in Jan

• The distribution for the rest of the year seems to be fairly even

3d. Trend of fire incidents by day of the week

• Weekends have a slightly higher rate of all fire incidents

3e. Trend of fire incidents by hour of the day

• Higher rates of fire incidents occur between 4 PM and 8 PM

• Lower rates of fire incidents occur between 4 AM and 7 PM

4. Fire incidents by neighborhood

• Mission and Tenderloin have the most number of fire incidents per year

5. Trend of fire incidents by top neighborhoods

• In these neighborhoods, there is an increase in all fire incidents in 2015 but building fires decreased.
• Mission district has a marked increase of building fires in 2015 - 40 compared 28 in 2014

6. Fire incident rate - Mission & Tenderloin

• Fire incident rate per population of 1,000 (based on 2010 population data)