PHMSA Data Initiatives

DataPalooza 6/3/2014 : Standards for Sharing Data Part 1

Transcript

1. 2nd Annual USDOT Data Palooza 2014 1
2. 2 2nd Annual USDOT Data Palooza 2014 PHMSA’s vision is that no harm results from hazardous materials transportation PHMSA’s mission is to safeguard people and the environment from hazardous materials transportation risks
3. 3 2nd Annual USDOT Data Palooza 2014 OHMS Strategic Plan Outcome Goals
4. Data Warehouse 4 2nd Annual USDOT Data Palooza 2014 TSA FRA FAA USCG EPA FHWA FMCSA PHMSA ATSDR Multimodal HAZMAT Intelligence Portal (HIP)
5. PHH032107-5 Other Agencies External Data Sources U.S.DOT FMCSA FAA FRA CBp (TDS) TSA USCG PHMSA OHMS/OPS More ETL Feedback US DOT # Safety Permits Federated Query Document Repository Text Search Validation Fusion Center Scorecard Reports Text Search Alerts Calendar Business Intelligence Mapping Reports TECHNICAL ARCHITECTURE Intelligence PORTAL Staging Area
6. 6 2nd Annual USDOT Data Palooza 2014 • Direct limited resources toward events posing the greatest risk; • Instant access to information at all levels of the organization • Creates a transparent and agile environment • Enables a data driven organization • Ensures clean and robust data • Foundation to support predictive analysis HIP Benefits
7. 7 2nd Annual USDOT Data Palooza 2014 Company Search Company Scorecard Daily Ranking Report Inspection Ranking Analytical Dashboards Ad-hoc Reporting Geographical Information System (GIS) capabilities to map incident data; provide accurate locations of shipper and carriers; provide capabilities to state and local communities to assist in emergency response planning; mapping commodity flow through cities and towns Key Capabilities
8. 8 2nd Annual USDOT Data Palooza 2014 Understanding Companies in HIP
9. 9 2nd Annual USDOT Data Palooza 2014 Company Search • Optional Filters: • Company • Agency • Mode • Activity • Activity Type  Activity – Every documented Transaction or Event is broken down as an activity.  Activity Type – Every Activity can be broken down into further detail as an activity type. Rendering of 5800 Incident form
10. 10 2nd Annual USDOT Data Palooza 2014 Company Scorecard • Summary • Company Detail • Inspections • Incident • Complaints • Violations • Penalties and Enforcements • Registrations • Approvals and Permits • EPA HAZMAT
11. 11 2nd Annual USDOT Data Palooza 2014 Safety Maps – Incidents 1.Link to 5800 Incident Report 2.Link to Company Scorecard
12. 12 2nd Annual USDOT Data Palooza 2014 Safety Management Dashboards Vision: Communicate through data visualization efforts that will maximize operational, tactical and strategic intelligence to identify OHMS’s future key performance indicators (KPIs)
13. 13 2nd Annual USDOT Data Palooza 2014 Safety Management Dashboards Cumulative KPIs co-located for each division Commonly used Dashboards/Reports aggregated by division Goal • Standardize information across Divisions • One location for retrieving data and reports • One location for KPIs in the QMR Tab Index of other available dashboards
14. 14 2nd Annual USDOT Data Palooza 2014 Incident Management Dashboard
15. 15 2nd Annual USDOT Data Palooza 2014 Dashboards / Data Modeling
16. 16 2nd Annual USDOT Data Palooza 2014 Identify Assess Monitor Manage • Assess the risk associated with each factor and develop mitigation strategies • Manage the risk through implementation of strategies and communication with stakeholders • Monitor to ensure compliance, course correction and continuous improvement • Identify key hazards, risk factors and issues How is the Information Used?
17. 17 2nd Annual USDOT Data Palooza 2014 Risk Profile Mode of Transportation Commodity Type Packaging Type Other Factors How is the Information Used?
18. 18 2nd Annual USDOT Data Palooza 2014  Hazardous Materials Information Center • 800-647-4922  Yolanda Braxton, MPA Program Analyst, PHMSA • Yolanda.Braxton@dot.gov • 202-366-0460  General Email Inquiries • HM_Requests@dot.gov Contact Information