New Jersey WSC Archived Projects
A database was developed by the USGS for the Penobscot Indian Nation (PIN) in 1999 to store water-quality and associated data. A data-entry application in MS Access was also provided. The resulting database and data-entry application are referred to as the Penobscot Indian Nation Environmental (PINE) database. For FY11 the USGS has been requested for development assistance to further improve the PINE data system, and to provide additional training.
START DATE: 14-MAR-2011
END DATE: 30-SEP-2011
PROJECT NUMBER: LJ00EHV
STUDY OBJECTIVES:
The overall objectives of this extension of the project are to:
- Accommodate vertically-oriented constituent data as the new download format from handheld data recorders (affects several processes and data structures);
- Update the main database design and domain tables as needed;
- Update the Archival process to accommodate the vertical raw data format;
- Update the Field data download and bottle check-in/processing procedures and methods;
- Update the Lab procedures and provide a more generic way to control how forms are populated (based on a constituent-container relationship);
- Implement new procedural QA rules as necessary;
- Evaluate how to accommodate continuously-recorded data;
- Provide additional training of PIN staff on data management and handling.
STATEMENT OF PROBLEM:
A database was developed by the USGS for the Penobscot Indian Nation (PIN) in 1999 to store water-quality and associated data. A data-entry application in MS Access was also provided. The resulting database and data-entry application are referred to as the Penobscot Indian Nation Environmental (PINE) database.
In early 2006 the USGS was contacted by PIN staff about updating the data system to make it easier to use (particularly lab data entry) and to review the PINE structure in the context of their current sampling program. They also decided to use hand-held devices in the field to record data instead of relying only on paper forms as in the past. A new partnership was formed and since that time the USGS has continued to work with the Penobscot Indian Nation in the further development of the PINE data system. This work has included switching raw data files from Excel to Access, implementing database design changes to accommodate site visits, direct loading of data formats from handheld devices, new data-review/edit and data-loading programs, and lab support through bottle check-in procedures and automatic setup of lab data-entry forms based on checked-in sample containers. The resulting system of database files and applications is now called the Penobscot Indian Nation Water-Quality Data System.
In the summer of 2007 the Penobscot Indian Nation was approved for a grant from EPA to establish a WQX data- exchange network node at their location. They have since implemented the node infrastructure and mapped the PINE database design to WQX in order to produce output compatible with the WQX schema. Additional technical support was provided for updates to structures and processes in 2008 and 2009.
The partnership with USGS from 2006 through 2009 also included training of PIN staff in MS Access and form development, and additional expansion has taken place in the interim along with discussion of future directions and needs. For FY11 the USGS has been requested for development assistance to further improve the PINE data system, and to provide additional training. Several tasks have been discussed between the parties, and prioritized. The effort in FY11 will follow priorities until the funds are depleted.
STRATEGY AND APPROACH:
The work will be coordinated between PIN and USGS through phone meetings, WebEx interactive work sessions, email, and one site visit to Maine for intensive collaborative work. 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.
A database was developed by the USGS for the Penobscot Indian Nation (PIN) in 1999 to store water-quality and associated data. A data-entry application in MS Access was also provided. The resulting database and data-entry application are referred to as the Penobscot Indian Nation Environmental (PINE) database. For FY11 the USGS has been requested for development assistance to further improve the PINE data system, and to provide additional training.
START DATE: 14-MAR-2011
END DATE: 30-SEP-2011
PROJECT NUMBER: LJ00EHV
STUDY OBJECTIVES:
The overall objectives of this extension of the project are to:
- Accommodate vertically-oriented constituent data as the new download format from handheld data recorders (affects several processes and data structures);
- Update the main database design and domain tables as needed;
- Update the Archival process to accommodate the vertical raw data format;
- Update the Field data download and bottle check-in/processing procedures and methods;
- Update the Lab procedures and provide a more generic way to control how forms are populated (based on a constituent-container relationship);
- Implement new procedural QA rules as necessary;
- Evaluate how to accommodate continuously-recorded data;
- Provide additional training of PIN staff on data management and handling.
STATEMENT OF PROBLEM:
A database was developed by the USGS for the Penobscot Indian Nation (PIN) in 1999 to store water-quality and associated data. A data-entry application in MS Access was also provided. The resulting database and data-entry application are referred to as the Penobscot Indian Nation Environmental (PINE) database.
In early 2006 the USGS was contacted by PIN staff about updating the data system to make it easier to use (particularly lab data entry) and to review the PINE structure in the context of their current sampling program. They also decided to use hand-held devices in the field to record data instead of relying only on paper forms as in the past. A new partnership was formed and since that time the USGS has continued to work with the Penobscot Indian Nation in the further development of the PINE data system. This work has included switching raw data files from Excel to Access, implementing database design changes to accommodate site visits, direct loading of data formats from handheld devices, new data-review/edit and data-loading programs, and lab support through bottle check-in procedures and automatic setup of lab data-entry forms based on checked-in sample containers. The resulting system of database files and applications is now called the Penobscot Indian Nation Water-Quality Data System.
In the summer of 2007 the Penobscot Indian Nation was approved for a grant from EPA to establish a WQX data- exchange network node at their location. They have since implemented the node infrastructure and mapped the PINE database design to WQX in order to produce output compatible with the WQX schema. Additional technical support was provided for updates to structures and processes in 2008 and 2009.
The partnership with USGS from 2006 through 2009 also included training of PIN staff in MS Access and form development, and additional expansion has taken place in the interim along with discussion of future directions and needs. For FY11 the USGS has been requested for development assistance to further improve the PINE data system, and to provide additional training. Several tasks have been discussed between the parties, and prioritized. The effort in FY11 will follow priorities until the funds are depleted.
STRATEGY AND APPROACH:
The work will be coordinated between PIN and USGS through phone meetings, WebEx interactive work sessions, email, and one site visit to Maine for intensive collaborative work. 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.