1 / 13

Transforming FIFRA and WQX Data for EPA Submission Using Reformat Web Tool

This resource presents an overview of the reformat web tool developed for converting FIFRA and WQX datasets. FIFRA data is typically column-oriented, stored in spreadsheets, while the EPA's WQX template requires a row-oriented format. The tool enables users to pivot data effectively, converting multiple columns per location into multiple rows. It discusses data export functions, input data setups, and access to reference documentation within the tool, facilitating easier submission to EPA specifications. A practical approach to transforming data for environmental monitoring is outlined.

neona
Télécharger la présentation

Transforming FIFRA and WQX Data for EPA Submission Using Reformat Web Tool

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. WQX Web and FIFRA DataUsing the reformat web tool Larry Theller, ABE, Purdue University Leighanne Hahn, OISC March 22, 2012

  2. WQX and FIFRA Data • The typical FIFRA data set is stored in spreadsheet • The spreadsheet is usually “column-oriented” • The EPA WQX template is “row-oriented” • User must “pivot” from many columns per location to many rows per location. • Pivot may be scripted, Excel™, translate function in WQX, or through online tools like this. • This tool pivots a spreadsheet in preparation for you to load into the EPA spreadsheet. OISCWQX

  3. The pink colored tab is used to export data for upload; The yellow tabs to set-up the input data; The green tabs provide a linked reference for documented elements in WQX. OISC WQX

  4. OISC WQX

  5. OISC WQX

  6. In this typical spreadsheet layout, the measurements are in columns, and each set of samples from a location is a row. OISC WQX 12

  7. The columns need to pivot so each measurement becomes one row, and the data collection notes need to be replicated for each measurement. OISC WQX

  8. OISC WQX

  9. OISC WQX

  10. OISC WQX

  11. OISC WQX

  12. Sample XML for monitoring location upload. OISC WQX

  13. The End OISC WQX

More Related