Data Montgomery Experience

1. Data Montgomery Experience Final report presentation Brian Perez | DATA 205 Capstone in Data Science | Friday, may 17th 2019

2. 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

3. 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) • 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

4. Shelters Interactive Map – Final product THE PRODUCT THE PROCESS http://itforaid.org/map/mcshelters.html - Test http://itforaid.org/map/mcshelterslive.html - Live

5. 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

6. 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) • 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

7. MCFRS Incident Analysis – Descriptive Stats Barplot - Calls Received - Agg. 3/2014 - 2/2019 Barplot - Calls Received by Year - Agg. 2014 - 2019

8. MCFRS Incident Analysis – Descriptive Stats 2019 does not have a full year of data

9. MCFRS Incident Analysis – Descriptive Stats Drop due to missing data on 3/2014

10. MCFRS Incident Analysis – Descriptive Stats Removed March 2014

11. 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

12. MCFRS Incident Analysis – Tableau dashboard

13. 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

14. MCFRS Incident Analysis – Recommendations • Add lat/long coordinates for the Fire Stations • Add Time Stamp of Call • Validate Zip Codes and Addresses

15. 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