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.
Refinements of the Data-Collection Workflow and Use of the Penobscot Indian Nation Environmental (Pine) Database
Project Title: Refinements of the Data-Collection Workflow and Use of the Penobscot Indian Nation Environmental (Pine) Database
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.