SOLICITATION NOTICE
R -- TECHNICAL SUPPORT FOR WATERSHED DATABASES
- Notice Date
- 11/7/2008
- Notice Type
- Presolicitation
- NAICS
- 541990
— All Other Professional, Scientific, and Technical Services
- Contracting Office
- Department of Commerce, National Oceanic and Atmospheric Administration (NOAA), Western Region Acquisition Division, 7600 Sand Point Way, Northeast, Seattle, Washington, 98115-6349
- ZIP Code
- 98115-6349
- Solicitation Number
- AB133C-09-RP-0004A
- Point of Contact
- Sharon S. Kent,, Phone: (206) 526-6035
- E-Mail Address
-
sharon.s.kent@noaa.gov
- Small Business Set-Aside
- Total HUB-Zone
- Description
- NOTE: This notice was previously advertised as a Sources Sought citing No. AB133C-09-RP-0004. This notice serves as an intent to procure technical support to NOAA, Office of Response & Restoration (ORR), through the Assessment and Restoration Division (ARD), on an as-needed basis. The objective of this contract is to support the maintenance, application, and development of NOAA's environmental databases, which serve as a repository for environmental sediment chemistry, tissue residue chemistry, and sediment toxicity data. These databases have three general applications: 1) to serve as an integral component of NOAA's Watershed Database and Mapping Projects, 2) to support site-specific investigations, including evaluations of risk or injury to NOAA resources, derivation of cleanup goals, and evaluations of remedial alternatives at hazardous waste sites or spills, and 3) to provide the foundation for conducting specialized analyses, such as exploring innovative approaches for the evaluation of sediment chemistry and toxicity data and developing new guidelines for screening sediments in support of risk assessments. The goal of NOAA's Watershed Database and Mapping Projects is to collect, summarize, and graphically display the available information on sources of contamination, sediment chemistry, observed biological effects, contaminants in biological tissue, habitat and natural resource information, and information on potential habitat restoration projects for key watersheds of interest to NOAA. These databases share a common relational database structure, which includes surface and subsurface sediment chemistry, tissue chemistry, and sediment toxicity data. The Contractor shall develop tools, procedures, and forms for reporting, record keeping, and program management. In general, the Contractor shall be responsible for performing the following tasks: Task A: Management of watershed databases The Contractor shall maintain and manage multiple large relational databases in Microsoft Visual FoxPro in support of this task. In support of NOAA's approximately 15-20 watershed database and mapping projects, new data must be added to these databases at frequent intervals, often with rapid turnaround time required. The new data may originate in a variety of electronic formats, which must be translated and imported into the watershed database structure. The contractor shall be responsible for 1) conducting a high level of QA/QC review on each new data set to make certain that the imported data match the original data provided and to identify potential problems (e.g., missing values, inconsistent units, or outliers) with the original data and 2) developing documentation for each dataset (e.g., project source, analytic methods, coordinate data projection and datum, and other critical data elements, as well as detailed records on changes and data treatment decisions). The contractor shall also be required to 3) develop or refine automated systems for importing and checking data added to the existing databases, which are maintained in Microsoft Visual FoxPro format. Because each of the approximately 20 watershed databases has the identical relational database structure, the contractor shall be responsible for 4) maintaining consistency of the common dictionary files as an essential aspect of the database management. The contractor will need to 5) develop or assist in developing database programs and procedures to query the database for a variety of uses, including tabular and graphical presentations, and create output in specific formats for export to mapping programs, such as ArcGIS. Task B: Database queries and specialized analyses The contractor shall 1) develop database queries and reports to meet a variety of objectives relating to the watershed databases, site- or regional-specific investigations, or specialized analyses such as the evaluation of the relationship of sediment chemistry to sediment toxicity. This will require the contractor to 2) generate of a wide variety of specialized queries and data outputs, often with little advance notice. Most of these queries and analyses will be conducted on NOAA/ARD standard watershed databases, but analyses of external environmental databases in a variety of structures and formats will be required. The contractor shall also conduct statistical analyses, such as the determination of significant difference between toxicity test samples and control or reference samples. Task C: Development of database tools and applications NOAA's ARD worked with EPA's Great Lakes National Program Office (GLNPO) and EPA Region 1 on a database project to make it easier for external users to put data into the relational database structure compatible with the Query Manager application. As part of this ongoing project, NOAA developed automated tools to both import data from pre-defined data templates and to conduct quality assurance checks on imported data. To support this activity, the Contractor shall continue development of this application, which includes a variety of screens, forms, and queries using Microsoft Access. The Contractor shall also provide maintenance and potential future development of this system, including linking of the imported data to the FoxPro watershed database. Water chemistry data associated with ecological exposures to hazardous substance sites is not currently managed in Query Manager. The Contractor may need to develop a parallel structure for managing water data, manage the data, and conduct queries for ecological assessment, remediation, and restoration. Natural resource damage assessments spill response data has not previously been tracked or managed in Query Manager. The Contractor shall be required to develop a consistent approach for sample tracking, including chain of custody information, developing electronic field sample data collection forms, developing electronic data deliverables (EDD) for laboratory analyses, developing methods for automating import of lab EDDs and associated field data into standard structures compatible with Query Manager, developing a structure for managing and providing data in a form to facilitate electronic data validation. Task D: Database application and data management training The Contractor shall 1) provide training in the use of both existing and newly developed data tools, templates, and data translation applications. The contractor shall 2) conduct general or project-specific database training. Experience : NOAA is seeking firms with experience in the development and management of large environmental databases that include sediment chemistry, tissue chemistry, and sediment toxicity data. Key personnel shall have a minimum of 5 years experience managing, designing, and developing environmental databases and database applications using (1) Microsoft FoxPro or Microsoft Visual FoxPro and (2) Microsoft Access. Technician(s) shall have a minimum 3 years technical experience in Microsoft FoxPro/Microsoft Visual FoxPro and Microsoft Access and a minimum 3 years experience with contaminant and waste site data, including environmental sediment chemistry, tissue contaminant-residue chemistry, and environmental contaminant toxicity data. All tasks require a high level of documented environmental database management expertise and programming experience in both Microsoft FoxPro (and/or Microsoft Visual FoxPro) and Microsoft Access. This work may be performed from any location in the continental United States, but the Contractor will be required to meet technical staff in Seattle (WA) on a periodic basis (e.g., 3-4 times / year). Training of regional staff in coastal EPA regional offices, including the Great Lakes, in the use of the database tools may also be required. The environmental data included in the watershed databases will originate from studies conducted primarily in coastal areas of the United States, territories, and protectorates. It is anticipated that a firm-fixed price, labor hour or time-and-material task order IDIQ type contract will be awarded with a base 12-month period and four one-year option periods. The North American Industry Classification Code (NAICS) is 541990 with a size standard of $7 M. All contractors doing business with the Government are now required to be registered with the Central Contractor Registry (CCR). No award can be made unless the vendor is registered in CCR. For additional information and to register in CCR please access the following web site: http://www.ccr.gov/. In addition, completion of the online representation and certifications application (ORCA) is required. A Request for Proposal (RFP) solicitation will be available on or about November 24, 2008, through this website. No paper copies of the solicitation will be issued. It is incumbent upon interested parties to register at the solicitation's site for notification and to review the site frequently for any updates/amendments to any and all documents. Technical questions regarding this solicitation should be emailed to Sharon.S.Kent@noaa.gov. This procurement is 100% HubZone Set-Aside. All responsible, responsive sources may submit an offer which will be considered by the Agency.
- Web Link
-
FedBizOpps Complete View
(https://www.fbo.gov/?s=opportunity&mode=form&id=4719afa04ba720ddd98b8536e38138bd&tab=core&_cview=1)
- Record
- SN01702594-W 20081109/081107215749-4719afa04ba720ddd98b8536e38138bd (fbodaily.com)
- Source
-
FedBizOpps Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |