Data Montgomery Experience - itforaid.org

Data Montgomery Experience - itforaid.org

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. 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. dataMontgomery 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, JavaScript, Leaflet JS, Bing, AWS S3 (hosting), Route 53 (Domain Name Registration) Shelter Name

Address Status Richard Montgomery High School 250 Richard Montgomery Drive, Rockville, MD 20852 Pet Friendly Location No 250 Richard Montgomery Drive Rockville, MD 20852 (39.078636, -77.145631) CLOSED 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, Tableau Fire Fire Station Kensington Volunteer Fire

Station Number 18 Nature of 911 call Monthly Total Year Month Month Num PREGNANCY 2 2017 MAY 5 Station address 12251 Georgia Ave 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. dataMontgomery Experience V. Acknowledgements SHELTERS INTERACTIVE MAP DATA CLEAN UP Extracted shelter data (GeoJSON) via Socratas 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: dataMontgomery (hospitals), and GIS Open Data (police stations) API Links changes when new data gets uploaded to dataMontgomery Old Link (Mar-19): https://data.montgomerycountymd.gov/resource/4yqk-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. dataMontgomery Experience V. Acknowledgements SHELTERS INTERACTIVE MAP FINAL PRODUCT THE 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. dataMontgomery 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 users 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. 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. dataMontgomery Experience V. Acknowledgements MCFRS INCIDENT ANALYSIS DATA CLEAN UP 1. Geocoding Incident Data Isolate Addresses Drop Duplicates Get Lat/Long 2. Reclassifying Call Types: 'Service', 'UNK) N/As = Not Reported From 99 to 5 Types ('Health', 'Structural/Environment', 'Threat/Legal', Drop Duplicates New Types

List 3. Time Series Analysis Date Format: Adding Decimal Analysis Decomposition Date 4/1/2014 = 2014.25 4. Maryland Political Tableau Analysis Boundaries Shape File Merge Lat/ Long to Incidents Format Dates: yyyy-mm-dd Population Data & Dashboard 2010 Census Merge New Types with

Incidents Add expected date formats for Time Series and Seasonal 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. dataMontgomery 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. dataMontgomery 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. 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. dataMontgomery 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. dataMontgomery 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 Kensington Volunteer Fire Department (Station 5)

Damascus Volunteer Fire Department (Station 13) Original Address 10620 Connecticut Ave Kensington, MD 20985 26334 Ridge Rd Damascus, MD 20750 Fixed Address 10620 Connecticut Ave Kensington, MD 20895 26334 Ridge Rd Damascus, MD 20872 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. dataMontgomery Experience V. Acknowledgements EXPERIENCES & ACKNOWLEDGEMENTS Pros of dataMontgomery Open Government: Montgomery Countys 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 dataMontgomery 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 stackOverflow -- machinelearningmastery.com -- http://sopac-old.ucsd.edu/convertDate.shtml -data.imap.maryland.gov

Recently Viewed Presentations

  • 2008 Auditor Workshop Output Matters 14 July 2008

    2008 Auditor Workshop Output Matters 14 July 2008

    2008 Auditor Workshop "Output Matters" 14 July 2008 Dan Conlon 951.273.5210 [email protected] Agenda AS9100 Importance to MDA MDA Assurance Provisions (MAP) MDA Audit Process AS9100 Findings Analysis Examples of AS9100 Audit Findings Common AS9100 Issues How You Can Help Conclusion...
  • Conception d'interfaces utilisateur en Java

    Conception d'interfaces utilisateur en Java

    Conception d'interfaces utilisateur en Java Cédric Dumas Jean-Daniel Fekete Ecole des Mines de Nantes Cedric.Dum[email protected] contrat Creative Commons Paternité-Pas d'Utilisation Commerciale-Partage des Conditions Initiales à l'Identique 2.0 France License
  • PowerPoint Template

    PowerPoint Template

    肿大,包膜紧张,切面隆起,边缘外翻,混浊无光,如沸水烫过 Cell and tissue injury Cellular swelling of liver Reversible injury--cellular swelling Normal cell Granularity change Hydropic change Viral hepatitis LM: The cells are swollen.
  • 4th SG13 Regional Workshop for Africa on Future

    4th SG13 Regional Workshop for Africa on Future

    It manages the creation and instantiation of virtualized network functions and automates and orchestrates provisioning of the virtual infrastructure. Its service catalog provides dynamic, model-based service definition/modification/exposure and drives the orchestration of provisioning workflows.
  • Salmon Life Cycle - MARRIC

    Salmon Life Cycle - MARRIC

    Salmonid Life Cycle Coho Salmon (Silver Salmon) Chinook Salmon (King Salmon) Steelhead Trout Eggs Need: Cool Water Clean Water Flowing Water Eggs and alevin Fry Fry Need: Protection from predators Food Cool, clean water Smolts Adult Salmonids Returning to the...
  • Nouns: Common vs. Proper, Abstract vs. Concrete

    Nouns: Common vs. Proper, Abstract vs. Concrete

    What are the different types of nouns? (Name at least 3). The first group who successfully writes down and turns in the correct answer will receive 2 Eagle Bucks per person. Goals: Our goals for today: Determine the difference between...
  • MANAGERIAL ECONOMICS 11th Edition - Cameron University

    MANAGERIAL ECONOMICS 11th Edition - Cameron University

    MANAGERIAL ECONOMICS 11th Edition By ... supply curve change in the quantity supplied shift in supply equilibrium market equilibrium price surplus shortage comparative statics analysis Basis for Demand Direct Demand Demand is the quantity customers are willing to buy under...
  • Use Cases and Use Case Diagrams - University of Hawaii

    Use Cases and Use Case Diagrams - University of Hawaii

    For each step, identify its triggers and its inputs and outputs Typical Questions Asked Activities Ask the user to execute the process using the written steps in the use case - that is, have the user role-play the use case...