DATA MONTGOMERY EXPERIENCE FINAL REPORT PRESENTATION BRIAN PEREZ
DATA MONTGOMERY EXPERIENCE FINAL REPORT PRESENTATION BRIAN PEREZ | DATA 205 CAPSTONE IN DATA SCIENCE | WEDNESDAY, MAY 1 ST 2019
AGENDA I. Overview Of Project Plan 1. 2. Shelters Interactive Map MCFRS Incident Analysis II. Shelters Interactive Map 1. 2. 3. 4. 5. Data Clean Up Descriptive Statistics Final Product: The map Data Story Recommendations III. MCFRS Incident Analysis 1. 2. 3. 4. 5. Data Clean Up Descriptive Statistics Final Product: The Analysis Data Story Recommendations IV. data. Montgomery Experience V. Acknowledgements
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 • Tools – HTML, Java. Script, Leaflet JS, Bing, AWS S 3 (hosting), Route 53 (Domain Name Registration) Pet Shelter Name Address Status Richard Montgomery High School 250 Richard Montgomery Drive, Rockville, MD 20852 Location Friendly CLOSED 250 Richard Montgomery Drive Rockville, MD 20852 (39. 078636, -77. 145631) No • Montgomery Country 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, Fire Station Monthly Month Fire Station Nature of 911 call Year Month Station address Number Total Num Tableau Kensington Volunteer Fire Department (Station 18) 18 PREGNANCY 2 2017 MAY 5 12251 Georgia Ave Wheaton, MD 20902
AGENDA I. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis II. Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
SHELTERS INTERACTIVE MAP – DATA CLEAN UP • Extracted shelter data (Geo. JSON) via Socrata’s API function – Active Shelters Link • All shelters are listed as CLOSED • Created mock data with a few shelters listed as OPEN • Included Hospital and Police stations in the area • Source: data. Montgomery (hospitals), and GIS Open Data (police stations) • API Links changes when new data gets uploaded to data. Montgomery • Old Link (Mar-19): https: //data. montgomerycountymd. gov/resource/4 yqk-nikt. geojson • New Link (Apr -19): https: //data. montgomerycountymd. gov/resource/mhua-idee. geojson
AGENDA I. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis II. Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
SHELTERS INTERACTIVE MAP – FINAL PRODUCT THE PROCESS http: //itforaid. org/map/mcshelters. html - Test http: //itforaid. org/map/mcshelterslive. html - Live
AGENDA I. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis II. Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
SHELTERS INTERACTIVE MAP – RECOMMENDATIONS • Provide additional details for shelters • Maximum capacity permitted • Description of services offered • Point of Contact: email and number • Shelter type (e. g. school, rec. center, community center) • Set static API links when updating data in Socrata • 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
AGENDA I. II. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
MCFRS INCIDENT ANALYSIS – DATA CLEAN UP 1. Geocoding Incident Data Isolate Addresses Drop Duplicates Get Lat/Long Merge Lat/Long to Incidents 2. Reclassifying Call Types: From 99 to 5 Types ('Health', 'Structural/Environment', 'Threat/Legal', 'Service', 'UNK’) N/As = “Not Reported” Drop Duplicates New Types List Merge New Types with Incidents 3. Time Series Analysis Date Format: Add expected date formats for Time Series and Seasonal Decomposition Analysis Adding Decimal Date 4/1/2014 = 2014. 25 Format Dates: yyyy-mm-dd 4. Tableau Analysis & Dashboard Maryland Political Boundaries – Shape File Population Data 2010 Census Index data based on Dates Merge All based on Zip Codes
AGENDA I. II. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
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
AGENDA I. II. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
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 – TABLEAU DASHBOARD
AGENDA I. II. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
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) TREND OF HEALTH CALLS RECEIVED Gaithersburg-Washington Grove Volunteer Fire Department (Station 8) has received the most calls: 49, 135 Most Health calls occur during the winter months - Staff Centers Accordingly Increase Flu Shot Availability NOTE: INFO BASED ON DATA APR 2014 – MAR 2019
AGENDA I. II. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations III. MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
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 26334 Ridge Rd Damascus, MD 20750 10620 Connecticut Ave Kensington, MD 20895 26334 Ridge Rd Damascus, MD 20872
AGENDA I. III. Overview Of Project Plan 1. Shelters Interactive Map 2. MCFRS Incident Analysis Shelters Interactive Map 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The map 4. Data Story 5. Recommendations MCFRS Incident Analysis 1. Data Clean Up 2. Descriptive Statistics 3. Final Product: The Analysis 4. Data Story 5. Recommendations IV. data. Montgomery Experience V. Acknowledgements
EXPERIENCES & ACKNOWLEDGEMENTS • Pros of data. Montgomery • 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. • Cons of data. Montgomery • Navigation: Navigation can be cumbersome with a large amount of unvalidated data sets and views • Maps: Mapping functionality was limited • APIs: API links should be static if possible • Acknowledgements • Kathryn L -- Dennis L -- Kathy L -- Mayro N – Peter P – Carlos C • stack. Overflow -- machinelearningmastery. com -- http: //sopac-old. ucsd. edu/convert. Date. shtml -data. imap. maryland. gov
- Slides: 25