XML Web Services: Region 3 and the Chesapeake Bay Program PilotPart 2

1
XML Web Services Region 3 and the Chesapeake Bay
Program Pilot-Part 2

• Brand Niemann
• XML Web Services Evangelist
• Data Standards Branch
• April 8, 2002

2
Overview

• 1. Background
• 2. Information Design and Architecture
• 3. Version 0.1
• 4. Some Next Steps
• 5. Contact Information

3
1. Background

• 1.1 February 27 - 28 Region 3/Mid-Atlantic
  States Information Management Meeting.
• 1.2 Region 3 Pilot Team.
• 1.3 March 13 - 14 OEI National Meeting.
• 1.4 April 11 Chesapeake Bay Program Information
  Management Subcommittee.
• 1.5 April 22 - 26(?) Region 3 Demonstration and
  Discussion.

4
1. Background

• 1.1 February 27-28 Region 3/Mid-Atlantic States
  Information Management Meeting Presentations
• XML Web Services Introduction (myself).
• Setting Environmental Priorities Based on
  Environmental Data and Indicators (Rich Pepino
  and John Armstead).
• Regional Advisory Information Management
  Information Technology Team (AIM/IT) (Deb
  Forman).
• XML Web Services Region 3 and the Chesapeake Bay
  Program (myself).
• Region 3 Matrix Inventory (database inventory by
  levels and themes for state of the environment
  reporting) (Deb Forman).
• Proposal for an IT solution for SOR reporting
  (John Graves).
• Region 3 Pilot Team formed (see next slide).

5
1. Background

• 1.2 Region 3 Pilot Team
• John Armstead
• Deb Forman
• John Graves
• Brand Niemann
• Others as needed

6
1. Background

• 1.3 March 13 - 14 OEI National Meeting
• March 11-13 XML Web Services Training, Pilots,
  and Consultations for Region 5 (myself).
• March 12 Lead Region role and what it will mean
  for Region 5 for FY 2003-4 (John Armstead and Deb
  Forman).
• Informal discussions of Region 3 Pilot (team).
• Formal discussions of Region 5 pilots (Steve
  Goranson and Region 5 staff).

7
1. Background

• 1.4 April 11 Chesapeake Bay Information
  Management Subcommittee Presentation
• XML Web Services Introduction.
• XML Web Services Region 3 and Chesapeake Bay
  Program (Part 1).
• XML Web Services Region 3 and Chesapeake Bay
  Program Pilot Part 2.
• GML and Environmental Decision Making.
• Proposed Pennsylvania/CBPO XML/GML Pilot Project.

8
1. Background

• 1.5 April 22 - 26(?) Region 3 Proposed
  Presentation and Demonstration
• Status of collecting pilot database from content
  providers.
• Discussion of information design.
• Discussion of architecture issues.
• Demonstrations (live Internet and laptop).
• Discussion of next steps for version 0.2.

9
2. Information Design and Architecture

• 2.1 Analysis of the Region 3 Matrix Inventory.
• 2.2 Table and document user interface to selected
  measures for one theme (Maintain and Restore
  Productive Aquatic Habitats, Wetlands, Streams,
  Lakes and Coastal Waters).
• 2.3 Use XML content network technology to
  integrate the content over the Region 3 network
  and the Internet.
• 2.4 Multi-channel Distribution (print, CD-ROM,
  Web, telephone, and assistive devices).

10
2. Information Design and Architecture

• 2.1 Analysis of the Inventory Matrix
• Levels 1-6 and 4 SOR themes.
• PowerPoint presentations.
• Specific Web sites
• MAIA, fish.rti.org, etc.
• EPA databases
• PCS, CERCLIS, AIRS, etc.
• Lots of CBPO LAN documents.

11
2. Information Design and Architecture

• 2.2 Table and document user interface to selected
  measures for one theme (Maintain and Restore
  Productive Aquatic Habitats, Wetlands, Streams,
  Lakes and Coastal Waters)
• Category Number (1-4 and 6), Category Name, and
  Selected Measures (21). Only two linked so far.
• Six databases. Only two linked so far.

12
2. Information Design and Architecture

• 2.3 Use XML content network technology to
  integrate the content over the Region 3 network
  and the Internet
• Import and repurpose static content.
• Link to changing Web page content.
• Convert Web database content to XML Web Services
  that deliver real data that can be repurposed via
  scripts and the XML Document Object Model (DOM).
• Use XML Content Adapters (e.g. NXT 3) that
  convert relational databases into XML data
  streams in real time.

13
2.4 MultiChannel Distribution
14
3. Version 0.1

• 3.1 NextPage Folio Views and LivePublish.
• 3.2 Microsoft Office XP and Access 2002.
• 3.3 Altova XML Spy 4.3.
• 3.4 NextPage NXT 3.3 (not used yet).

15
3.1 NextPage Folio Views and LivePublish
16
3.1 NextPage Folio Views and LivePublish
17
3.1 NextPage Folio Views and LivePublish
18
3.1 NextPage Folio Views and LivePublish
19
3.1 NextPage Folio Views and LivePublish

• Uses of XML
• Serve up native XML.
• Convert XML to HTML using a CSS or XSL at run
  time using the Display Filter API.
• Convert XML to HTML at build time.
• Uses an XML-based file to define site look and
  feel.
• The build Makefiles are XML files that define the
  structure and contents of the information
  collections.
• XML-based legacy conversion tools simplify the
  conversion of existing content into HTML.
• Indexsheets (XIL) define and control the indexing
  of content like stylesheets (XSL) define and
  control the formatting.

20
3.2 Office XP and Access 2002

• 3.2.1 Office XP (2002)
• EPA Policy November 14, 2001, Margaret
  Schneider, OEI Principal Deputy Assistant
  Administrator
• Although the new Windows XP operating system is
  not approved (until testing is complete), the
  Microsoft Office software suite is permitted for
  use on the Agency network regardless of version
  (e.g. Office 2000 or Office XP).
• Microsoft Office XP XML Web Services Toolkit
• http//msdn.microsoft.com/office (free download)
• 3.2.2 Access 2002
• Step by Step Book excerpts.
• Region 3 database example.

21
3.2.1 Office XP (2002)
22
3.2.2 Access 2002

• Source Chapter 3. Getting Information Into and
  Out of a Database, Step by Step Microsoft Access
  2002
• Best practices
• Link to other databases rather than import so can
  view and edit in both systems.
• Share databases by exporting to XML (universal
  format).
• http//office.microsoft.com/assistance/2002/articl
  es/acExOfScenariosUsingXML.aspx
• Import
• Open Access 2002 database.
• File, Get External Data, Import, Files of type,
  XML Documents, Import both XML and XSD, select
  file to be imported, Import, Import XML, Options,
  Structure and Data, Okay.
• Open and view database tables to confirm data was
  imported.

23
3.2.2 Access 2002

• Exporting to other applications
• Works for Table, Query, Form, and Report.
• Open Access 2002 database and select a table.
• File, Export, select XML Documents, Save as type,
  Export, Export XML, select both Data (XML) and
  Schema (XSD) of the data, Okay.
• See screen captures on next pages.
• See Advanced, Schema tab and select appropriate
  option.
• Look at XML, XSD, and XSL files in XML Spy 4.3.

24
3.2.2 Access 2002
25
3.2.2 Access 2002
26
3.2.2 Access 2002
27
3.3 XML Spy 4.3
28
3.4 NextPage NXT 3.3
29
4. Some Next Steps

• 4.1 EPAs Environmental Indicators Initiative
  and State of the Environment Report
• http//www.scituate.tpmc.com/indicators/index.htm
• 4.2 EPA Databases in LandView/FileMakerXML
• 4.3 XML/GML Web Services Proposed Pennsylvania
  Pilot Project.

30
4.1 EPAs Environmental Indicators Initiative
and State of the Environment Report
31
4.2 EPA Databases in LandView/FileMakerXML
32
4.3 GML Enables Common Interfaces for Access to
Geographic Data
Browser with SVG Plug-in
Styling Engine
GML Data Store
33
4.3 GML Enables GeoWeb Services
Analysis Services
Service Registry
Schema Registry
GML Data
GML Schemas
GML Schemas
Geo-Web
GML Data
GML Data
GML Data
Data Access Services
Coordinate Transformation
Portrayal Services
34
4. Some Next Steps

• 4.3 Proposed Pennsylvania XML/GML Web Services
  Pilot Project
• Components
• Development of an agreed to list of data objects,
  sensors, etc. to be stored in a Registry.
• Web Feature Servers.
• Web Coverage Server.
• Sensor Collection Server.
• Map Portrayal Service and Viewer Clients.
• Data sources PA State GIS Data, CBPO Water
  Quality data, etc.

35
5. Contact Information

• Brand Niemann. Ph.D.
• USEPA Headquarters, EPA West, Room 6143D
• Office of Environmental Information, MC 2822T
• 1200 Pennsylvania Avenue, NW, Washington, DC
  20460
• 202-566-1657
• niemann.brand_at_epa.gov
• EPA http//161.80.70.167
• Outside EPA http//130.11.44.140