1 / 13

Introduction to WQX XML Schema

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)

helki
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to WQX XML Schema Doug Timms, enfoTech November 28, 2007

  2. Topics • Getting Started • Schema Structure • Handling of Attachments • Other things to look out for

  3. 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

  4. Data Exchange Template

  5. 36 files WQX XML Schema File Structure

  6. Simplified Data Structure

  7. Monitoring Location • Consists of Following Groups: • Monitoring Location Identity • Monitoring Location Geospatial • Attachments (i.e. Binary Object)

  8. 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…)

  9. 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

  10. 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

  11. 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

  12. 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

  13. Questions

More Related