introduction to wqx xml schema n.
Skip this Video
Download Presentation
Introduction to WQX XML Schema

Loading in 2 Seconds...

play fullscreen
1 / 13

Introduction to WQX XML Schema - PowerPoint PPT Presentation

  • Uploaded on

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 (

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Introduction to WQX XML Schema' - helki

Download Now 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

  • 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 (
  • Flow Configuration Document (
  • Domain Value Database (
  • 1,2,3 found at:
  • 4 found at:
monitoring location
Monitoring Location
  • Consists of Following Groups:
    • Monitoring Location Identity
    • Monitoring Location Geospatial
    • Attachments (i.e. Binary Object)
  • 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