Title: XML Web Services: Region 3 and the Chesapeake Bay Program PilotPart 2
1XML Web Services Region 3 and the Chesapeake Bay
Program Pilot-Part 2
- Brand Niemann
- XML Web Services Evangelist
- Data Standards Branch
- April 8, 2002
2Overview
- 1. Background
- 2. Information Design and Architecture
- 3. Version 0.1
- 4. Some Next Steps
- 5. Contact Information
31. 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.
41. 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).
51. Background
- 1.2 Region 3 Pilot Team
- John Armstead
- Deb Forman
- John Graves
- Brand Niemann
- Others as needed
61. 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).
71. 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.
81. 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.
92. 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).
102. 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.
112. 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.
122. 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.
132.4 MultiChannel Distribution
143. 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).
153.1 NextPage Folio Views and LivePublish
163.1 NextPage Folio Views and LivePublish
173.1 NextPage Folio Views and LivePublish
183.1 NextPage Folio Views and LivePublish
193.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.
203.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.
213.2.1 Office XP (2002)
223.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.
233.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.
243.2.2 Access 2002
253.2.2 Access 2002
263.2.2 Access 2002
273.3 XML Spy 4.3
283.4 NextPage NXT 3.3
294. 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.
304.1 EPAs Environmental Indicators Initiative
and State of the Environment Report
314.2 EPA Databases in LandView/FileMakerXML
324.3 GML Enables Common Interfaces for Access to
Geographic Data
Browser with SVG Plug-in
Styling Engine
GML Data Store
334.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
344. 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.
355. 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