Refinement of the Penobscot Indian Environmental database and supporting applications, and data export to WQX format Completed
New Jersey WSC Archived Projects
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.
START DATE: 12-NOV-2007
END DATE: 30-SEP-2008
PROJECT NUMBER: 2454D9C
STUDY OBJECTIVES:
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.
DISCLAIMER: This webpage contains information about completed or inactive projects from the NJ Water Science Center. It has been created for historical purposes and may be a utility to locate published information. This page should not be considered an authoritative source. You are encouraged to contact the NJ WSC for more current information.
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.
START DATE: 12-NOV-2007
END DATE: 30-SEP-2008
PROJECT NUMBER: 2454D9C
STUDY OBJECTIVES:
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.
DISCLAIMER: This webpage contains information about completed or inactive projects from the NJ Water Science Center. It has been created for historical purposes and may be a utility to locate published information. This page should not be considered an authoritative source. You are encouraged to contact the NJ WSC for more current information.