New Jersey Water Science Center
Great Falls of the Passaic River at Paterson, N.J.
USGS IN YOUR STATE
USGS Water Science Centers are located in each state.
Refinement of the Penobscot Indian Environmental database and suppoting applications, and data export to WQX format
Project Title: Refinement of the Penobscot Indian Environmental database and suppoting applications, and data export to WQX format
The overall objectives of this extension of the project are to 1) update the main database (circa 2000) and associated applications as needed to reflect the current field program and lab analyses at PIN, 2) complete documentation on the database design and data flow, and 3) to facilitate the transfer of PINE data to the EPA’s WQX data system (node at PIN).
Statement of Problem
In the summer of 2007 the Penobscot Indian Nation was approved for a grant from EPA to establish a data-sharing node at their location. This node will be part of the EPA WQX data-exchange network. In FY08 the USGS will again assist the PIN with the remaining changes needed for the main database, updating the 2007 applications as needed after a full season of field use, providing additional training on techniques and tools in MS Access, and supporting the PINE interchange with the WQX data format. The last task will include mapping the PINE database to EPA’s WQX data- exchange format and building an export module to dump selected water-quality data into XML files for loading into the WQX node.
Strategy and Approach
The work will be coordinated between PIN and USGS through phone meetings, WebEx interactive work sessions, and email. One trip to the PIN will likely be made this year, or to a conference where a meeting can take place between USGS and PIN staff. The work will consist of workflow review, database design analysis, programming, creating or editing of forms and reports, training PIN staff, producing written communications of evaluations and recommendations, and documentation of new tools or procedures.
The USGS will work directly with PIN staff responsible for the design and operation of the PINE data system, and with any other staff (e.g., field and laboratory staff) whose involvement will facilitate the completion of the project in a timely fashion.