Introduction to wqx xml schema
This presentation is the property of its rightful owner.
Sponsored Links
1 / 13

Introduction to WQX XML Schema PowerPoint PPT Presentation


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

Introduction to WQX XML Schema. Doug Timms, enfoTech November 28, 2007. Topics. Getting Started Schema Structure Handling of Attachments Other things to look out for. Helpful Resources. Data Exchange Template (WQX_DET_v1.0.xls) XML Schema (WQX_Schema_v1.0.zip)

Download Presentation

Introduction to WQX XML Schema

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


Introduction to wqx xml schema

Introduction to WQX XML Schema

Doug Timms, enfoTech

November 28, 2007


Topics

Topics

  • Getting Started

  • Schema Structure

  • Handling of Attachments

  • Other things to look out for


Helpful resources

Helpful Resources

  • Data Exchange Template (WQX_DET_v1.0.xls)

  • XML Schema (WQX_Schema_v1.0.zip)

  • Flow Configuration Document (WQX_FCD_v1.0.zip)

  • Domain Value Database (WQX_ODS_MS_Access.zip)

  • 1,2,3 found at: http://www.exchangenetwork.net/exchanges/water/wqx.htm

  • 4 found at: http://www.epa.gov/storet/wqx_downloads.html


Data exchange template

Data Exchange Template


Wqx xml schema file structure

36 files

WQX XML Schema File Structure


Simplified data structure

Simplified Data Structure


Monitoring location

Monitoring Location

  • Consists of Following Groups:

    • Monitoring Location Identity

    • Monitoring Location Geospatial

    • Attachments (i.e. Binary Object)


Activity

Activity

  • Consists of Following Groups:

    • Activity Description

    • Activity Location

    • Sample Description

    • Attachments (i.e. Binary Object)

    • Children Results

  • Used to report expanded list of Activity Types (Field Measurement, Quality Control Samples, Dups, Blanks, Vertical Profile, Data Logger, etc…)


Activity group

Activity Group

  • Used as a generic method to group related Activities:

    • Field Set:Used to group field activities

    • QC Sample:Used to group activities/samples with related quality control samples

    • Replicate: Used to group samples/measurements of the same type, medium, etc

    • Subsample:Used to group samples with subsamples

  • Completely optional and up to data provider on what level of detail to provide


Domain values

Domain Values

  • For any fields that are marked as “Domain List = Yes”, you will need to either:

    • use EPA/WQX’s values in your database

    • Create a mapping table (or procedure) that converts your codes to EPA’s

  • Special Case: ResultAnalyticalMethod

    • Allows either using EPA’s domain values or your own

    • AnalyticalMethodContext:

      • If = EPA predefined value (NIOSH, USEPA, AOAC, etc)

      • Otherwise set =- to your Organization ID

      • Otherwise it will be rejected


Transaction handling

Transaction Handling

  • Submit data either as “Insert/Updates” or “Deletes”

  • Insert/Update:

    • Use WQX_WQX_v1.0.xsd

    • Don’t need to specify insert or update: system will recognize this

    • In order to update a result, must resupply all information for that activity

  • Delete:

    • Use WQX_WQX_Delete_v1.0.xsd

    • Just need to supply Primary Key for the Project, Monitoring Location, Activity, or Activity Group you would like to delete

    • When a component is deleted, all children information is deleted as well

  • Your system should have some capability to understand which data has been updated since your last submission


Including attachments

Including Attachments

  • Attachments can be tracked at:

    • Project

    • Monitoring Location

    • Activity

    • Result

  • Store the attachment’s filename (including extension) in XML

    • Therefore each attachment must have a unique filename

  • Include attachments outside of XML, in ZIP file


Questions

Questions


  • Login