Surface Water Data Base Consolidation and Collection.
Surface Water Data Base Consolidation and Collection. This is a notice of intent to award a sole source purchase order to Thomas Herrett for the collection of hard copy files and conversion to the USGS Automated Data Processing System (ADAPS). The tasks include removing non-quality-controlled historical data from display on NWISWeb (and potentially the NWIS database); especially data with obvious errors and any data that are known to have not received sufficient quality-control for publication, developing and implementing a plan to remove or approve (based on appropriate quality assurance) provisional historical data stored in NWIS; the first priority should be provisional data that are available publicly on NWISWeb, and setting very-high and very-low tesholds for all parameter code 00045 and 00065 data descriptors (DD) displayed publicly on NWISWeb (or parameter code 72192 input DDs at cumulative precipitation stations). Mr. Herrett is uniquely qualified as he has an in-depth knowledge of not only the DB but also the hundreds of sites from which the data is retrieved. In addition to the sites he is very knowledgeable about the high and low tesholds required to be set in ADAPS to prevent errant data from being store in the system. These tesholds are specific to each of the nearly 300 individual sites across the state. These tasks would likely take 30 days of training with an experienced mentor and probably frequent feedback thereafter. Other interested concerns having the ability to meet the USGS requirement may submit a proposal to the Contracting Officer no later than 08/26/2016 at 1300 EDT. As required by FAR 5.102(c) (1) the RFQ G16PS00687 will be made available upon request. Contact the Contracting Officer at sevans@usgs.gov for a copy of the RFQ. All submissions will be considered by the agency and evaluated to determine if competitive opportunities exist. Estimated start date is 10/01/2016. For further information, please contact the Contracting Specialist at (916) 278-9334 or sevans@usgs.gov. NAICS: 541611, Administrative and Management Consulting Services. $15.0 M. G16PS00687 Department of the Interior US Geological Survey Office of Acquisitions and Grants
8/17/16, 5:02 PM SURFACE WATER DATABASE CLEANUP
Added: Jul 21, 2016 11:17 am Surface Water Data Base Consolidation and Collection. This sources sought notice is for informational purposes only and shall not be considered a solicitation, obligation, or commitment by the Government. This notice is for market research. Introduction: The Data Section in the Oregon Water Science Center (ORWSC) has a large DataBase (DB) of Hydrologic Information that is served to the public. Errors and omissions in the DB require corrections to be made to meet USGS standards and policy. Additionally the current database is shifting from the Automated Data Processing System (ADAPS) to Aquarius, the cleanup of data before and after the migration is required as well as the update of the current Peak Flow File (PFF). The Peak Flow file stores and makes available peak flow information for each stream gaging station on the NWISweb. Data from the USGS PFF are used in the determination of flood-frequency estimates that aid in the design of water and transportation infrastructure, delineation of floodplain boundaries, and regulation of development and utilization of lands toughout the Nation. Over the past 40 years the ORWSC DB has accumulated errors and omissions that need to be corrected so that the public cannot access erroneous data. Additionally there is a significant amount of data that has not undergone appropriate quality assurance reviews. The erroneous data causes problems when retrieving large blocks of data for statistical analysis and when undergoing quality control audits. Scripts have been developed that can help identify some of the erroneous data and in some cases can correct the problem. The current database is shifting from ADAPS to Aquarius, the cleanup of data before and after the migration is required as well as the update of the current Peak Flow file. Definitions/Applicable Documents: Databases consists of those records stored in ADAPS, the Peak Flow File and Site File which are resourced by National Water Information System (NWIS) for public use. The purpose is to remove or correct erroneous data (manually or with scripts) and if needed correct the ADAPS/Aquarius processing methods that create the errant data in order to stop creating problem data. The primary objective is to provide a DB that meets the USGS Office of Surface Water (OSW) policies and ensure that the migration of data from the ADAPS DB to the Aquarius DB has been made, and post migration cleanup in Aquarius is complete. The DB contains daily and instantaneous values for over 900 sites covering a time span of over 100 years for some sites. A secondary but highly important task is the cleanup and quality assurance of the PFF database. The PFF database is a high-profile database that reflects and highlights the quality of USGS data collection programs; as such, the accuracy, characterization, and completeness of the data are critical. A significant portion of the records to be removed or corrected are stored in the USGS record storeroom (hard copies) where the past 100+ of gaging station records are stored and maintained. Therefore the potential contractor must utilize USGS office space. The purpose of this notice is to determine interest and capability of potential sources. The NAICS is 518210, Data Processing, with a size standard of $32.5 Million. Contractors must be currently registered in the System for Award Management (SAM) database. This is not a request for quotation or a solicitation for offers. Interested parties will submit an email detailing their capabilities and experience with these services. Sufficient information must be provided to demonstrate the ability to complete the services. This is not a request for quotation or an announcement of a solicitation. Responses will be used for market research only. Responses are due no later than 08/03/2016 1300 EDT. Response may be submitted to Stewart Evans by email at sevans@usgs.gov. Place of performance is: USGS Oregon Water Science Center 2130 SW 5th Ave Portland, OR 97201 POC: Stewart Evans (916) 278-9334 or sevans@usgs.gov G16PS00687 Department of the Interior US Geological Survey
7/21/16, 11:17 AM