Data Montgomery Experience Final Report Presentation by Brian Perez
Overview of a data science capstone project focusing on creating services for users to interact with geographical data using an interactive map. The project includes analyzing 911 calls received by Montgomery County Fire & Rescue Service (MCFRS) and providing insights on incident patterns and locations. Tools such as HTML, JavaScript, Python, Tableau, and various datasets were utilized to achieve project goals. The final product includes an interactive map of shelters and recommendations for enhancing the application.
Download Presentation
![](/assets/img/so-down.gif)
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
DATA MONTGOMERY EXPERIENCE FINAL REPORT PRESENTATION BRIAN PEREZ | DATA 205 CAPSTONE IN DATA SCIENCE | FRIDAY, MAY 17TH2019
OVERVIEW OF THE PROJECT PLAN Shelters Interactive Map Goal 1 Create services that allow users to interact with geographical data via a web-based interactive map Dataset Emergency Shelter Activation Status, dataMontgomery (hospitals), and GIS Open Data (police stations) Montgomery County Fire & Rescue Service (MCFRS) Incident Analysis Goal 2 Provide an analysis of 911 calls received by MCFRS to better understand the nature, frequency and locations of the calls Dataset MCFRS_Incidents_by_Station, Population MD, Zip Code Shape File
OVERVIEW OF THE PROJECT PLAN Shelters Interactive Map Goal 1 Create services that allow users to interact with geographical data via a web-based interactive map Dataset Emergency Shelter Activation Status, dataMontgomery (hospitals), and GIS Open Data (police stations) Tools HTML, JavaScript, Leaflet JS, Bing, AWS S3 (hosting), Route 53 (Domain Name Registration) Pet Shelter Name Address Status Location Friendly 250 Richard Montgomery Drive Rockville, MD 20852 (39.078636, -77.145631) Richard Montgomery High School 250 Richard Montgomery Drive, Rockville, MD 20852 CLOSED No Montgomery County Fire & Rescue Service (MCFRS) Incident Analysis Goal 2 Provide an analysis of 911 calls received by MCFRS to better understand the nature, frequency and locations of the calls Dataset MCFRS_Incidents_by_Station, Population MD, Zip Code Shape File Tools Python, Geopy, Nominatim, pandas, numpy, matplotlib, seaborn, statsmodels.api, datetime, Tableau Fire Station Number Fire Station Nature of 911 call Monthly Total Year Month Month Num Station address Kensington Volunteer Fire Department (Station 18) 12251 Georgia Ave Wheaton, MD 20902 18 PREGNANCY 2 2017 MAY 5
SHELTERS INTERACTIVE MAP FINAL PRODUCT THE PRODUCT THE PROCESS http://itforaid.org/map/mcshelters.html - Test http://itforaid.org/map/mcshelterslive.html - Live
SHELTERS INTERACTIVE MAP RECOMMENDATIONS Provide additional details for shelters Maximum capacity permitted Description of services offered if applicable Point of Contact: email and number Shelter type (e.g. school, rec. center, community center) Set static API links when updating data in Socrata Old Link (Mar-19): https://data.montgomerycountymd.gov/resource/4yqk-nikt.geojson New Link (Apr -19): https://data.montgomerycountymd.gov/resource/mhua-idee.geojson Increase number of pet friendly shelters Enhancements to the application: Find nearest open shelter based on a user s location Integrate app. with mapping apps Add layers such as road closures and traffic conditions Provide additional details for Police Stations dataset on Data Montgomery
OVERVIEW OF THE PROJECT PLAN Shelters Interactive Map Goal 1 Create services that allow users to interact with geographical data via a web-based interactive map Dataset Emergency Shelter Activation Status, dataMontgomery (hospitals), and GIS Open Data (police stations) Tools HTML, JavaScript, Leaflet JS, Bing, AWS S3 (hosting), Route 53 (Domain Name Registration) Pet Shelter Name Address Status Location Friendly 250 Richard Montgomery Drive Rockville, MD 20852 (39.078636, -77.145631) Richard Montgomery High School 250 Richard Montgomery Drive, Rockville, MD 20852 CLOSED No Montgomery County Fire & Rescue Service (MCFRS) Incident Analysis Goal 2 Provide an analysis of 911 calls received by MCFRS to better understand the nature, frequency and locations of the calls Dataset MCFRS_Incidents_by_Station, Population MD, Zip Code Shape File Tools Python, Geopy, Nominatim, pandas, numpy, matplotlib, seaborn, statsmodels.api, datetime, Tableau Fire Station Number Monthly Total Month Num Fire Station Nature of 911 call Year Month Station address Kensington Volunteer Fire Department (Station 18) 12251 Georgia Ave Wheaton, MD 20902 18 PREGNANCY 2 2017 MAY 5
MCFRS INCIDENT ANALYSIS DESCRIPTIVE STATS Barplot - Calls Received - Agg. 3/2014 - 2/2019 Barplot - Calls Received by Year - Agg. 2014 - 2019
MCFRS INCIDENT ANALYSIS DESCRIPTIVE STATS 2019 does not have a full year of data
MCFRS INCIDENT ANALYSIS DESCRIPTIVE STATS Drop due to missing data on 3/2014
MCFRS INCIDENT ANALYSIS DESCRIPTIVE STATS Removed March 2014
MCFRS INC. ANALYSIS SEASONAL DECOMPOSITION Observed = Trend + Seasonal + Residual Calls increase over time, perhaps due to increase in population Spikes at the start of each year, perhaps due to the flu common during the winter Observed = Trend + Seasonal + Residual Trend = Overall change over time Seasonal = Change within a given period Residual = Random variation in the series
MCFRS INCIDENT ANALYSIS DATA STORY CALLS BY CITY 2014 - 2019 73% of calls are Health related Specifically Sickness The majority of the calls occur in Silver Spring (162,500) Gaithersburg-Washington Grove Volunteer Fire Department (Station 8) has received the most calls: 49,135 TREND OF HEALTH CALLS RECEIVED Most Health calls occur during the winter months - Staff Centers Accordingly - Increase Flu Shot Availability NOTE: INFO BASED ON DATA APR 2014 MAR 2019
MCFRS INCIDENT ANALYSIS RECOMMENDATIONS Add lat/long coordinates for the Fire Stations Add Time Stamp of Call Validate Zip Codes and Addresses Fire Station Original Address Fixed Address Kensington Volunteer Fire Department (Station 5) Damascus Volunteer Fire Department (Station 13) 10620 Connecticut Ave Kensington, MD 20985 10620 Connecticut Ave Kensington, MD 20895 26334 Ridge Rd Damascus, MD 20750 26334 Ridge Rd Damascus, MD 20872
EXPERIENCES & ACKNOWLEDGEMENTS Experiemces with dataMontgomery Platform Open Government: Montgomery County s commitment to increasing transparency and citizen involvement in general aspects of e-Government services Support: Quick Response from Data Owners/Staff Accessible: As a first time Socrata user, the tool meets its goal of making data accessible to the average non- technical user. Acknowledgements Montgomery County Government, dataMontgomery and Montgomery College Dennis Linders; Victoria Lewis; Kathy Luh; Kathryn Linehan; Mohamed Abdirisak; Mayro N; Peter P; Carlos C Other Resources: stackOverflow -- machinelearningmastery.com -- http://sopac-old.ucsd.edu/convertDate.shtml -- data.imap.maryland.gov, https://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml