CTUIR-DNR Data Management Project

1. CTUIR-DNR Data Management Project

2. DNR Data Management Improvement Project “To grow DNR Data Management Maturity to provide reliable and timely data to enrich and inform decisions.”

3. This is Accomplished by Managing data quality, Securely storing data, Analyzing data, and providing data for synthesis This will allows for: Representation of the data in internal and external forums and Management and policy decisions based on the data

4. How is CTUIR achieving this?

5. Data Assessment Phases • Phase I-Conduct interviews • Phase II-Prioritization of the information captured in the interview process • Phase III-A work plan for the development of a CDMS • CDMS work process and timeline. • Periodic check-ins with program managers and the steering committee.

6. Phase I The interview

7. Two tiers Tier one - Program Managers and Supervisors. Information needs in order to perform their jobs Tier two - Project Leaders and Staff Reporting needs as well as the number and types of data collected

8. 43 people Managers/Supervisors(13) Projects(30)

9. What Did We Learn?

10. Stakeholders Tribal Community General Community UIR Community

11. First Foods Element(Water, Salmon, Deer, Cous, Huckleberry) Salmon (15) Water (13) All (4)

12. ~160 datasets

13. Datasets Consumed 73 ~1/2 from within DNR

14. Data Sharing 26 Agencies

15. Take Away Message

16. Manager/Supervisor Good quality summary information that is readily accessible for presentation and/or for use in reports. The ability to easily track projects progress and processes

17. Project Leaders and Staff Auto-generation of reports The ability to track and manage datasets Data that is ready for analysis and reporting Simple and easy user interfaces

18. Phase II Prioritization

19. Five Criteria Organization Decision Support: Does this dataset inform a management plan (1), the issuance of a permit from a DNR program (2), or is used for DNR regulatory purposes (3), or informs more than 1 process (4)? Data Sharing: Requirement to provide this dataset to an outside agency. Inclusion in the CDMS would reduce the administrative burden to provide it? [Yes (2)/No (1)] Impact Breadth: Impact of a dataset on the entire DNR department by quantifying the number of people within DNR whom both Consume and Produce the dataset? [>8 People (3), 4-7 People (2), <3 People (1)] Level of Effort: The effort that will be required to migrate to the CDMS and automation of future data collection processes. [High (1), Moderate (2), Low (3)] Funder Preference: Currently funding the DNR Database Development Effort? [Yes (2)/No (1)]

20. Relative Importance Ranking 1. Data Sharing and Organizational Decision Support 2. Impact Breadth 3. Level of Effort 4. Funder Preference

21. Adding Them Up! 4*(Data Sharing) + 4*(Organizational Decision Support) + 3*(Impact Breadth) + 2 (Level of Effort) + Funder Preference

22. Prioritization Results Adult Weir Water Temperature/Chemistry/Sediment Stream Survey (Redds) Harvest Monitoring Screw Trap Video Monitoring Electroshocking Snorkeling Vegetation Plots Groundwater Elevation

23. Phase III The Workplan

24. How do we do that?

25. Dataset Implementation Form Dataset Working Group DRAFT “Standards & Practices” Comments & Review Final Recommendation Build Dataset In CDMS Train Launch!

26. How do we track these?

27. Project Tracking • User Interface/Dashboard • House Datasets • Manage Files • Manage Reports • Generate maps • Manages the Public Side of the DNR website • Provides data for maps and webpages • Manages Permissions to a Project

28. Project Tracking

29. Rough Sequence

30. Questions