DOI Data Resource Management

1. DOI Data Resource Management Recreation One Stop Standardization Pilot March 17, 2004 POC: Craig Tanner, IT Pioneers, L.L.C., 703-626-2730, e-mail: craig@itpioneers.com

2. Recreation.gov • The Goal: to collect recreational data efficiently from the various agencies who managed facilities across the country and to satisfy the various requests from the consumers of this data. • The Approach: to develop an xml based solution for data interchange • The Problem: There was an initial rush to implement a solution. Data owners were frustrated with the initial attempt at implementation. The way they thought about their data was different than the process for collecting it. The project stalled. • The Solution: Step back and start from the beginning…

3. Background • Multi-Department, multi-agency, including Federal, State, Local Govt. and great interest from private sector • Recreation.gov was stuck – Couldn’t make significant progress. Lacked an approach • Published XML Schema but no data integration • An Enterprise Architecture Approach – FEA provided a formal “business oriented’ approach business owners could buy into. • Community of Practice Approach – Information Exchange Drivers with Modernization Blueprint Drivers • Data modeling and re-issuing of the XML brought all parties back to the table

4. Data Modeling Control: Business Architecture The DOI Recreation LOB fits within the Federal Enterprise Architecture by tying to the Federal “Natural Resources” LOB. Within the Federal LOB, the DOI Recreation LOB ties to the “Recreational Resource Management and Tourism” sub-function. Natural Resources (Federal Line of Business) Recreational Resource Management and Tourism (Federal Sub-function) Recreation Information Management Recreation Operations Recreation Resource Education and Outreach Recreation Resource Management Recreation Resource Permits Recreation Resource Planning DOI Activities

5. Data Modeling Control: Business Architecture Recreation Operations Recreation Resource Education and Outreach Recreation Resource Management Recreation Resource Permits Recreation Resource Planning Recreation Information Management 3A - Inspect Commercial Special Recreation Permits For Compliance 26 - Prepare and Revise Recreation Activity Plans H8 - Collect Data for Recreation Resources 5T - Operate Recreation Sites And Campgrounds H7 - Evaluate Recreation Areas H8 - Collect Data for Recreation Resources Z1 - Provide Technical Assistance for Recreation 8X - Conduct Environmental Reviews for Recreation - Fish & Wildlife Service 8P - Manage Wildlife for Recreation 1S - Manage Commercial Activities Manage Recreation Reservation and Information Services 1R - Issue and Manage Special Recreation Permits For Commercial Users 1S - Manage Commercial Activities S3 - Provide Education and Interpretation Products J0 - Assess Linear Recreation Resources T2 - Oversee Concessions Operations 51 - Manage Recreation 1Q - Issue and Manage Recreation Use Permits R1 - Manage Cultural And Natural Resources Exhibits and Information Manage Recreation Reservation & Information Services H7 - Evaluate Recreation Areas 1P - Issue and Manage Special Recreation Permits for Non Commercial Use

6. Data Exchange Potential Systems from the following categories have been identified as being in contact with Recreation data: • E-Government • Geospatial Systems • Inventory, Content, and Metrics • Permitting • Learning Systems/Portals • General Support Systems

7. CREATE TABLE RECAREA (RECAREA_ID CHAR(12) NOT NULL, RECAREA_NM VARCHAR(50) NOT NULL PRIMARY KEY (RECAREA_ID)); CREATE UNIQUE INDEX XPKRECAREA ON RECAREA ( RECAREA_ID ASC); CREATE TABLE RECAREA_ACT (RECAREA_ID CHAR(12) NOT NULL, RECAREA_ACT_CD CHAR(2) NOT NULL, RECAREA_ACT_DESC VARCHAR(240) NULL, RECAREA_ACT_FEE VARCHAR(240) NULL); CREATE UNIQUE INDEX XPKRECAREA_ACT ON RECAREA_ACT ( RECAREA_ID ASC, RECAREA_ACT_CD ASC); Physical Model Schema (SQL) RECREATION-AREA IDENTIFIER RECREATION-AREA NAME RECREATION-AREA MAP URL TEXT RECREATION-AREA IDENTIFIER (FK) RECREATION-ACTIVITY TYPE CODE RECREATION-AREA-ACTIVITY DESCRIPTION TEXT RECREATION-AREA-ACTIVITY FEE DESCRIPTION TEXT XML Schema METADATA REGISTRY/REPOSITORY Glossary of Metadata DOMAIN: RECREATION-ACTIVITY TYPE CODE <?xml version="1.0" ?> <xsd:Schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xs:element name="RecAreaActivity"> <xs:annotation> <xs:documentation>A recreational activity available at a Recreation Area. </xs:documentation> </xs:annotation> <xs:complexType> <xs:sequence> <xs:element name="RecAreaActivityType" type="xs:string"> <xs:annotation> <xs:documentation>The code that denotes a specific kind of Recreational Activity.</xs:documentation> </xs:annotation> </xs:element> REGISTRY ENTRY: RECREATION-ACTIVITY TYPE CODE DATA TYPE: CHARACTER LENGTH: 2 DEFINITION: The code that denotes a specific kind of Recreational Activity CLASS WORD: CODE A1|AIR-HANG GLIDING B1|BOATING-SAILING B2|BOATING-CANOEING B3|BOATING-KAYAKING C1|CAMPING-CAMP SITES C2|CAMPING-FREE SPACE H1|HIKING-TRAILS H2|HIKING-FREE RANGE S1|SWIMMING-LAKE, POND S2|SWIMMING-POOL XML Based on a Data Reference Model Subject Area: RECREATION Notional Super Type: RECREATION AREA Information Exchange Package: PUBLIC RECREATION AMENITY REQUEST RECREATION-AREA Data Object: DOI Conceptual Data Entities (Standardized) RECREATION-AREA-ACTIVITY Data Property: DOI Conceptual Data Elements (Standardized) Data Representation:

8. People Basic Standardization Framework Consumer Engineer SME Architect Steward(s) Chief Data Architect States Harvest Or Design Analyze & Refine Integrate & Refine Review (Technical & Cross Functional Update Publish & View Use in Integrated Systems & Information Exchange

9. People Basic Standardization Framework-In Practice Consumer Engineer SME Architect Steward(s) Data Architect States Harvest Or Design Access Repository Artifacts Previous RecML Harvest Metadata Analyze & Refine Access Repository Artifacts Iterative Facilitated Modeling Sessions (Multi-Department and Agency) Integrate & Refine Draft New RecML Introduce Cross-Departmental Data Standards Store Repository Artifacts Develop Transformation Model Review (Technical & Cross Functional Model Review Package RecML Review Package Repository Standardization Management Facility Update Working RecML Working Recreation Model Update Repository Artifacts Working Transformation Model Publish& View V1.0 RecML Schema Recreation.gov Conceptual Model V1.0 Use in Integrated Systems & Information Exchange Pointers to accessible, integrated e-Gov Data Artifact Reuse and Integration Use RecML Schema Use Information Knowledge and Requirements Implement Physical Standards DRM Program Performance Measurements

10. RIDB DRM Coordination and Evolution Approved DOI-DRM Rel 1 Approved DOI-DRM Rel x+1 DOI-DRM Published Release Initial DOI-DRM V1 Candidate DOI-DRM Vx+1 Candidate DOI-DRM Vx+2 Recreation Subject Area Logical Data Model V1 Recreation Subject Area Transformation Model Recreation Subject Area Logical Data Model – Vx +1 Release 1.0 RecML Review RecML Original RecML

11. Primary Concepts in RecML • Address • Event • Facility • Facility Activity • Facility Association • Facility Covers • Facility Event • Organization • Organization Facility Role • Organization Recreation Area Role • Recreation Area • Recreation Area Activity • Recreation Area Advisory • Recreation Area Association • Recreation Area Covers • Recreation Area Event • Recreation Area Facility • Recreational Activity • Vendor • Vendor Activity

12. Recreation High Level To-Be Systems Architecture (with DOI systems)