1 / 45

DWR GIS Data Steward Training Crash Course Version

DWR GIS Data Steward Training Crash Course Version. March 13, 2014. Overall Course Schedule. - Overview of Enterprise GIS - Data Promotion Workflow Initial Stewardship Plan Complying with DWR GIS Data Standard Final Production Packet - Publication - GeoPortal

kory
Download Presentation

DWR GIS Data Steward Training Crash Course Version

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DWR GIS Data Steward Training Crash Course Version March 13, 2014

  2. Overall Course Schedule - Overview of Enterprise GIS - Data Promotion Workflow Initial Stewardship Plan Complying with DWR GIS Data Standard Final Production Packet - Publication - GeoPortal - Long-Term Stewarding Issues - Workflow Focus: Developing Metadata - Workflow Focus: Calculating Positional Accuracy

  3. What is “The Enterprise”???

  4. The Enterprise • - Architecture • Servers, software, the network, databases • - Data • Storage, classification, geodatabase, origin (current/new, legacy, ex-DWR) • The DWR GIS Data Standard • Roles & Responsibilities • Stewards, Sub-stewards, Geodatabase Managers, Oracle instance managers, other IT support, QA/QC, Governance, EGC, end users

  5. Why a Stewarded Enterprise? • minimize duplication of effort, use of incorrect choice of dataset • facilitate easier location of best, current authoritative data • facilitate everyone working off “same sheet of music” • - reduce storage space requirements • - ability to leverage providing data as service to improve performance & reduce network demand • - assign responsibility for improvements to be made in an organized manner • - promote and provide documentation • - clarify distribution/access policy • - decisions about dataset edits are made more consistent • Ultimately, enterprise deployment of stewarded data is chosen to save time, save money, and promote use of consistent, documented data to improve the quality of everyone's work. • It requires up-front investment, but should yield back-end savings.

  6. Demo DWR GIS Atlas

  7. The Enterprise “Enterprise” is not synonymous with “centralized”. While enterprise systems may or may not be centralized, our chosen approach for DWR Enterprise GIS is federated.

  8. Data Types Project Data vs. Program Data vs. Enterprise Data (as used in this training class)

  9. Stewarded Data Origin - Legacy Data, DWR-sourced - Current/New Data, DWR-sourced - Data originating from outside DWR

  10. DWR Governance Board Enterprise GIS Planning Committee (EGC) DOE Photogrammetry Division of Technology Services DWR GIS Atlas geoDB Administration Steward 3 EGC Sub-committees Danny Luong & Nicholas Perez Misc DTS Sub-Steward Sub-Steward Sub-Steward Steward 1 Entities Outside DWR Providing Data to DWR Steward 2

  11. Roles & Responsibilities • - DBA • - Geodatabase Manager • - Data Steward • Data Sub-steward(s) (if applicable) • QA/QC Reviewer • EGC & IT support • End users

  12. The Overall Stewardship Process • Become a steward • Develop ISP (Initial Stewardship Plan) • - Get approvals from DWR Enterprise GIS Committee (EGC) for ISP • Post data to development environment, with help from DOE • - Bring data up to DWR GIS Data Standard • - Conduct QA/QC • Submit final dataset promotion packet to EGC • Once EGC approves, work with DOE to get development copy of data posted to production environment of DWR GIS Atlas • Post data to GeoPortal • - Once published, maintain/update data as necessary

  13. Enterprise Data Promotion Workflow

  14. Initial Checklist Steps Decide to become a data steward or accept a request to become one. Identify appropriate relationships and explore capacity for staff to fill various roles. Should there be sub-stewards? Who? Who will be the ArcGIS server/geodatabase administrator? Identify the correct candidate dataset for eventual promotion to DWR GIS Atlas. Compare various datasets. What are strengths and weaknesses of each? Discuss options with sub-stewards and select best candidate dataset. Begin developing draft data model. Identify final products (feature data service, map service, etc.). Initiate formal indication to DWR Enterprise GIS Committee (hereafter EGC) of intention to steward dataset. Develop Initial Stewardship Plan. 6. Secure stewardship roles and obtain signoffs.

  15. Promotion Workflow Checklist Steps 7. Submit candidate dataset. 8. Finalize draft data model and description documents (next slides will illustrate). 9. Develop Geodatabase Management Plan. 10. Develop Archive & Maintenance Plan. 11. Submit Initial Stewardship Plan to EGC. 12. EGC’s Enterprise Architecture & Applications sub-committee (EA&A) will review and approve Geodatabase Management Plan and Archive & Maintenance Plan. Revise these if necessary. 13. EGC’s Data Standards sub-committee (Data Standards) will review and approve candidate dataset selection and approve Data Model. Revise these if necessary. 14. EGC signs off on Initial Stewardship Plan.

  16. ISP Forms

  17. Data Model Example 1

  18. Data Model Example 2

  19. Data Model Example 3

  20. Promotion Workflow Checklist Steps 7. Submit candidate dataset. 8. Finalize draft data model and description documents. 9. Develop Geodatabase Management Plan. 10. Develop Archive & Maintenance Plan. 11. Submit Initial Stewardship Plan to EGC. 12. EGC’s Enterprise Architecture & Applications sub-committee (EA&A) will review and approve Geodatabase Management Plan and Archive & Maintenance Plan. Revise these if necessary. 13. EGC’s Data Standards sub-committee (Data Standards) will review and approve candidate dataset selection and approve Data Model. Revise these if necessary. 14. EGC signs off on Initial Stewardship Plan.

  21. EGC Signoff? Congratulations, you are now a steward!!!

  22. Enterprise Data Promotion Workflow

  23. Promotion Workflow Checklist Steps Ensure everyone involved in stewardship of dataset has appropriate accounts/permissions. Ensure everyone involved in stewardship of dataset has necessary training. Coordinate with any outside agencies, as necessary. Determine permissions, data security policy, and security management approach. Work with DOE to get identified candidate dataset copied into the development geodatabase environment. Develop and/or edit dataset to comply with current version of DWR GIS Data Standards.

  24. Promotion Workflow Checklist Steps 21. Complete all metadata for dataset. 22. Have independent QA/QC conducted. Obtained signoff of independent QA/QC certification. 23. Develop any end user or data sharing agreements, if necessary. 24. Complete Standards checklist. 25. Update DWR GeoPortal. 26. Submit Final Dataset Production Document to EGC.

  25. Don't know if data can be shared? Government Code Section 6254, part of what is known as the “Public Records Act” tells you what is exempt from the public domain. Or ask Sonny Fong. Or a DWR attorney. But don't just guess.

  26. Development vs. Production Environments The “Green Cans of Tuna” Notice: this is how it can be seen as “federated”

  27. Demo Development Environment & Transactional/Multiuser Editing Guidelines Document

  28. Final Dataset Production Forms

  29. DWR Spatial Data Standard

  30. It is all about QUALITY

  31. Enterprise Data Promotion Workflow

  32. Promotion Workflow Checklist Steps 27. EGC reviews document and submittal. If EGC indicates changes, revisions, or additional work, complete those changes and re-submit to EGC. 28. EGC approves dataset for publication. 29. Work with DOE to migrate data from development environment into DWR GIS Atlas production environment.

  33. Development vs. Production Environments The “Green Cans of Tuna” Notice: this is how it can be seen as “federated”

  34. Promotion!

  35. Promotion Workflow Checklist FINAL Steps 31. Update DWR DataSpace default template. 32. Maintain dataset on ongoing basis.

  36. Ongoing Changes to the Data When it comes to GIS, incorporating change benefits from a clear line of communication.

  37. Maintenance and Archiving Issues - Incorporating improvements and/or directing the process - Staying abreast of data updates from outside DWR - When to update metadata, QA/QC, positional/attribute accuracy - Are the data dynamic or static? - Versioning - Legal considerations

  38. Back to the Committee?

  39. Enterprise Data Promotion Resources • Enterprise GIS Committee (EGC) and sub-committees • Dwrgis.water.ca.gov • Existing enterprise data documents…can be used as models to follow • Meeting notes • Key documents • Specific documents, including: • ISP and Final Dataset Production packets • Enterprise Data Promotion Workflow • DWR Spatial Data Standards • Calculating Positional Accuracy • Software resources • ArcGISDiagrammer • GeoPortal • Positional Accuracy Assessment Tool extension • Your colleagues

  40. Questions? Discussion?

  41. GeoPortal

  42. Metadata

  43. Positional Accuracy & PAAT

More Related