Refinements of the Data-Collection Workflow and Use of the Penobscot Indian Nation Environmental (Pine) Database Completed
New Jersey WSC Archived Projects
A database was developed by the USGS for the Penobscot Indian Nation (PIN) in 2000 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.
START DATE: 02-APR-2007
END DATE: 28-SEP-2007
PROJECT NUMBER: 2454CZP
STUDY OBJECTIVES:
- Develop a stand-alone Access-based data-entry form for laboratory data and the ability to check and pass the data to the main PINE database. This will enable the laboratory staff to enter data and link results more easily to the field program and data.
- Revise the data-processing application developed last year to move field data collected on hand-held devices to the main PINE database. This update will remove the Excel intermediary files, simplify the processing, and allow the creation of reports critical to assessment.
STATEMENT OF PROBLEM:
A database was developed by the USGS for the Penobscot Indian Nation (PIN) in 2000 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.
Since the delivery of the PINE database, water-quality data for more than 100 sites and nearly 5,000 samples had been entered into the system through year 2005. However, the original data-entry program was designed for a different program with a different set of requirements and is very labor-intensive and inefficient in the context of the current aquatic sampling programs performed by the Penobscot Nation.
This extension of the project continues to assist the Penobscot Indian Nation with migrating to a better field data- collection process and building an improved laboratory data-entry system.
STRATEGY AND APPROACH:
The work will be coordinated between PIN and USGS through phone meetings, WebEx interactive work sessions, and email. Travel is not expected as a requirement to complete the objectives. The work will consist of workflow review, database design analysis, programming, creating forms and reports, and 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 2000 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.
START DATE: 02-APR-2007
END DATE: 28-SEP-2007
PROJECT NUMBER: 2454CZP
STUDY OBJECTIVES:
- Develop a stand-alone Access-based data-entry form for laboratory data and the ability to check and pass the data to the main PINE database. This will enable the laboratory staff to enter data and link results more easily to the field program and data.
- Revise the data-processing application developed last year to move field data collected on hand-held devices to the main PINE database. This update will remove the Excel intermediary files, simplify the processing, and allow the creation of reports critical to assessment.
STATEMENT OF PROBLEM:
A database was developed by the USGS for the Penobscot Indian Nation (PIN) in 2000 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.
Since the delivery of the PINE database, water-quality data for more than 100 sites and nearly 5,000 samples had been entered into the system through year 2005. However, the original data-entry program was designed for a different program with a different set of requirements and is very labor-intensive and inefficient in the context of the current aquatic sampling programs performed by the Penobscot Nation.
This extension of the project continues to assist the Penobscot Indian Nation with migrating to a better field data- collection process and building an improved laboratory data-entry system.
STRATEGY AND APPROACH:
The work will be coordinated between PIN and USGS through phone meetings, WebEx interactive work sessions, and email. Travel is not expected as a requirement to complete the objectives. The work will consist of workflow review, database design analysis, programming, creating forms and reports, and 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.