SF Fire Department Visualization: Lone Mountain/USF

Team Tony and Friends

Data Set

This data set is attributed to Open Data and DataSF. The original link can for the data set can be found here

The original data set has 4,886,219 Rows and 34 Columns. It is data all about Fire Department Calls for Service. The website says that there may be multiple records for each call numbers since this logs the responses. This could mean that both a Fire Engine and an Ambulance could have been dispached to the scene and would then record 2 responses in the data set. An example of the type of data it contains is 'Call Type' which would tell you what the incident was or 'Neighborhood' which would tell you which neighborhood this happened in.

Draft Data Processing

The original Data set was obviously way to large so we had to filter out some things and focus on some others. We decided that we want to focus our project on Fires in the Lone Mountain/USF area. We kept in all 34 Columns just in case we would want to add something later on with columns. We did however lower the amount of Rows in our Data Set. We filtered the data on the sfgov website. We filtered from over 4 million Rows to a manageable 4,326. If this proves to be too much data we might lower our bounds and filter it even more. We filtered by date and chose a 10 year range from 2009 to 2018. We also filtered it to only include the Lone Mountain/USF neighborhood. Finally we decided that we only wanted to include Outside Fires and Structure Fires. This would fit into our general theme of looking at fires over the years in the USF area.