DOI Data Resource Management
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

DOI Data Resource Management PowerPoint PPT Presentation


  • 56 Views
  • Uploaded on
  • Presentation posted in: General

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: [email protected] Recreation.gov.

Download Presentation

DOI Data Resource Management

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Doi data resource management

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: [email protected]


Recreation gov

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…


Background

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


Data modeling control business architecture

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


Data modeling control business architecture1

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


Data exchange potential

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


Xml based on a data reference model

CREATE TABLE RECAREA

(RECAREA_IDCHAR(12) NOT NULL,

RECAREA_NMVARCHAR(50) NOT NULL

PRIMARY KEY (RECAREA_ID));

CREATE UNIQUE INDEX XPKRECAREA

ON RECAREA

( RECAREA_ID ASC);

CREATE TABLE RECAREA_ACT

(RECAREA_IDCHAR(12) NOT NULL,

RECAREA_ACT_CDCHAR(2) NOT NULL,

RECAREA_ACT_DESCVARCHAR(240) NULL,

RECAREA_ACT_FEEVARCHAR(240) NULL);

CREATE UNIQUE INDEX XPKRECAREA_ACT ON RECAREA_ACT

( RECAREA_IDASC,

RECAREA_ACT_CDASC);

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:


Basic standardization framework

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


Basic standardization framework in practice

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


Drm coordination and evolution

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


Primary concepts in recml

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


Recreation high level to be systems architecture with doi systems

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


  • Login