USGS - science for a changing world

New Jersey Water Science Center

  home   water data   projects   publications   hazards   news   about us   contact   webcams
Great Falls of the Passaic River at Paterson, N.J

Great Falls of the Passaic River at Paterson, N.J.

           QUICK LINKS

WATER DATA

PUBLICATIONS

ABOUT US

USGS IN YOUR STATE

USGS Water Science Centers are located in each state.

There is a USGS Water Science Center office in each State. Washington Oregon California Idaho Nevada Montana Wyoming Utah Colorado Arizona New Mexico North Dakota South Dakota Nebraska Kansas Oklahoma Texas Minnesota Iowa Missouri Arkansas Louisiana Wisconsin Illinois Mississippi Michigan Indiana Ohio Kentucky Tennessee Alabama Pennsylvania West Virginia Georgia Florida Caribbean Alaska Hawaii New York Vermont New Hampshire Maine Massachusetts South Carolina North Carolina Rhode Island Virginia Connecticut New Jersey Maryland-Delaware-D.C.

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
Project Number: 2454CZP
Project Chief:
Project Start Date: 02-APR-2007
Project End Date: 28-SEP-2007

Project Objectives

  1. 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.
  2. 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.

Accessibility FOIA Privacy Policies and Notices

USA.gov logo U.S. Department of the Interior | U.S. Geological Survey
URL: http://nj.usgs.gov/projects/2454CZP/index.html
Page Contact Information: New Jersey WSC Webmaster
Page Last Modified: Monday, 14-Jan-2013 11:09:06 EST