Summary: Dataset contains information for all calls of Service
to the San Francisco Fire Department. Each row item contains 34
columns of detailed data.
Columns in Dataset: Call Number, Unit ID, Incident Number, Call Type,
Call Date, Watch Date, Received DtTm, Entry DtTm, Dispatched DtTm,
Response DtTm, On Scene DtTm, Transport DtTm, Hospital DtTm, Call Final Disposition,
Available DtTm, Address, City, Zipcode of Incident, Batallion,
Station Area, Box, Original Priority, Priority, Final Priority, ALS Unit,
Call Type Group, Number of Alarms, Unit Type, Unit sequence in call dispatch,
Fire Prevention District, Supervisor District, Neighborhoods - Analysis Boundaries,
Location, RowID
Original Dataset Columns Used: Call Type, Received DtTm, Response DtTm
New Added Columns: Decimal Response Time (Time in Minutes of difference in Received DtTm and Respnse DtTm)
Data Wrangling Performed: Eliminated date with response time of zero (null).
eliminated date that the fire department did not response, which had missing Response DtTm value.
Limited the timeframe of calls to January 2019.
Prototype Objective for Reference: Show average response time (in minutes) for each type of incident call category.
Prototype 2
Original Dataset Columns Used: Call Type
New Added Columns: none
Data Wrangling Performed: Limited the timeframe of calls to January 2019.
Prototype Objective for Reference: Show proportions of majority of incident calls.
Prototype 3
Original Dataset Columns Used: Call Type, Neighborhoods - Analysis Boundaries
New Added Columns: none
Data Wrangling Performed: Limited the timeframe of calls to January 2019.
Limited the data to the top four most common call types which were alarms, citizen assist / service call,
medical incident, structure fire, and traffic collusion in January 2019.
Excluded the following neighborhoods with low call numbers: Lincoln Park,
McLaren Park, Seacliff and the category 'None'.
Prototype Objective for Reference: Shows the number of calls for the top four call
categories broked down and stacked for each San Francisco neighborhood.
Prototype 4 (Evolved from Prototype 3)
Original Dataset Columns Used: Call Type, Neighborhoods - Analysis Boundaries, Avg. Response Time
New Added Columns: Avg. Response Time
Data Wrangling Performed: Limited the timeframe of calls to January 2019.
Limited the data to the top four most common call types which were
medical incident, alarms, structure fire, and traffic collusion in January 2019.
Excluded the following neighborhoods:'None'.
Prototype Objective for Reference: Shows the average response time(Difference between Received DtTm & On Scene DtTm) of all Neighborhoods of 4 most frequent Call Types in January 2019.
Prototype 5
Original Dataset Columns Used: Unit Type, Call Type, Priority, Average Response Time.
New Added Columns: None.
Data Wrangling Performed: Limited the timeframe of calls to January 2019. I filtered some data which had blank parts, the Average Respnse time is a new column that shows average response time according to different dimentions.
Prototype Objective for Reference: Shows the average response time based on 3 different dimentions: The call priority, unit type, and call type in January 2019.
Prototype 6 (Evolved from Prototype 1)
Original Dataset Columns Used: Call Type, Received DtTm, On Scene DtTm
New Added Columns: Decimal Response Time (Time in Minutes of difference in Received DtTm and On Scene DtTm)
Data Wrangling Performed: Eliminated date with response time of zero (null).
eliminated date that the fire department did not response, which had missing Response DtTm value.
Limited the timeframe of calls to January 2019.
Prototype Objective for Reference: Show average response time (in minutes) for each type of incident call category.
Original Dataset Columns Used: Call Type, Received DtTm, On Scene DtTm
New Added Columns: Decimal Response Time (Time in Minutes of difference in Received DtTm and On Scene DtTm)
Data Wrangling Performed: Eliminated date with response time of zero (null).
Eliminated data that the fire department did not respond to, which had missing Response DtTm value.
Limited the timeframe of calls to January 2019.
Prototype Objective for Reference: Show average response time (in minutes) for each type of incident call category.
Original Dataset Columns Used: Call Type, Neighborhoods - Analysis Boundaries, Avg. Response Time
New Added Columns: Avg. Response Time
Data Wrangling Performed: Limited the timeframe of calls to January 2019.
Limited the data to the top four most common call types which were
medical incident, alarms, structure fire, and traffic collusion in January 2019.
Excluded the following neighborhoods:'None'.
Prototype Objective for Reference: Shows the average response time(Difference between Received DtTm & On Scene DtTm) of all Neighborhoods of 4 most frequent Call Types in January 2019.