130 likes | 312 Views
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)
E N D
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) • 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
36 files WQX XML Schema File Structure
Monitoring Location • Consists of Following Groups: • Monitoring Location Identity • Monitoring Location Geospatial • Attachments (i.e. Binary Object)
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 • 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 • 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 • 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 • 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