Update the NJWaTr database for Years 2000 through 2007 Completed
New Jersey WSC Archived Projects
Water Resource planning requires a source of reliable, relevant, easily accessible data. Multiple NJDEP agencies are involved with regulation and data collection with regard to the State's water resources. These programs include land use, water quality, water supply, and wildlife. The USGS NJ WSC has been asked to update the NJWaTr database structure to accommodate new data requirements and to facilitate linkage to other data and applications (e.g., GIS). Additionally, the USGS NJ WSC has been asked to assemble, quality-check, and prepare specific datasets for appending to the NJWaTr database. These include water-use withdrawals data and wastewater discharge data.
START DATE: 01-APR-2008
END DATE: 30-SEP-2009
PROJECT NUMBER: LJ00DBC
STUDY OBJECTIVES:
Database management, Hydrodynamic flow
There are two main objectives in this project.
1. The USGS NJ WSC has been asked to update the NJWaTr database structure to accommodate new data requirements and to facilitate linkage to other data and applications (e.g., GIS). A functional change to the existing data- loading application was also requested - to allow adding or updating records without a full reload. The database changes will be reflected in updates to the standard NJWaTr data import Template definition, all related NJWaTr applications (e.g., the data loader, data-warehouse creator), and all associated documentation.
2. The USGS NJ WSC has been asked to assemble, quality-check, and prepare specific datasets for appending to the NJWaTr database. These include water-use withdrawals data and wasterwater discharge data. The USGS will document the source data, devise quality assurance and data conversion procedures for the data, summarize and resolve any data- quality issues, and process final QA’d data into standard import tables for loading into the NJWaTr database
STATEMENT OF PROBLEM:
Water Resource planning requires a source of reliable, relevant, easily accessible data. Multiple NJDEP agencies are involved with regulation and data collection with regard to the State's water resources. These programs include land use, water quality, water supply, and wildlife. A common issue to all of them is the amount of water available to meet the competing demands, but they collect and store their data separately making their use problematic.
STRATEGY AND APPROACH:
- Update the NJWaTr database and supporting applications, structures, and documentation
- Document the NJWaTr data system update and uses of the data in a SIR.
- Assemble and document datasets as requested by NJGS.
- Develop QA strategy and perform QA on data.
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.
- Overview
Water Resource planning requires a source of reliable, relevant, easily accessible data. Multiple NJDEP agencies are involved with regulation and data collection with regard to the State's water resources. These programs include land use, water quality, water supply, and wildlife. The USGS NJ WSC has been asked to update the NJWaTr database structure to accommodate new data requirements and to facilitate linkage to other data and applications (e.g., GIS). Additionally, the USGS NJ WSC has been asked to assemble, quality-check, and prepare specific datasets for appending to the NJWaTr database. These include water-use withdrawals data and wastewater discharge data.
START DATE: 01-APR-2008
END DATE: 30-SEP-2009
PROJECT NUMBER: LJ00DBC
STUDY OBJECTIVES:
Database management, Hydrodynamic flow
There are two main objectives in this project.
1. The USGS NJ WSC has been asked to update the NJWaTr database structure to accommodate new data requirements and to facilitate linkage to other data and applications (e.g., GIS). A functional change to the existing data- loading application was also requested - to allow adding or updating records without a full reload. The database changes will be reflected in updates to the standard NJWaTr data import Template definition, all related NJWaTr applications (e.g., the data loader, data-warehouse creator), and all associated documentation.
2. The USGS NJ WSC has been asked to assemble, quality-check, and prepare specific datasets for appending to the NJWaTr database. These include water-use withdrawals data and wasterwater discharge data. The USGS will document the source data, devise quality assurance and data conversion procedures for the data, summarize and resolve any data- quality issues, and process final QA’d data into standard import tables for loading into the NJWaTr database
STATEMENT OF PROBLEM:
Water Resource planning requires a source of reliable, relevant, easily accessible data. Multiple NJDEP agencies are involved with regulation and data collection with regard to the State's water resources. These programs include land use, water quality, water supply, and wildlife. A common issue to all of them is the amount of water available to meet the competing demands, but they collect and store their data separately making their use problematic.
STRATEGY AND APPROACH:
- Update the NJWaTr database and supporting applications, structures, and documentation
- Document the NJWaTr data system update and uses of the data in a SIR.
- Assemble and document datasets as requested by NJGS.
- Develop QA strategy and perform QA on data.
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.