Revised_SOW-GIS.docx

STATEMENT OF WORK

FOR

NATURAL RESOURCE ANALYSIS, ASSESSMENT AND POLICY SUPPORT

FOR THE

RESOURCES ASSESSMENT DIVISION AND THE RESOURCES INVENTORY DIVISION

Prepared By U. S. Department of Agriculture Natural Resources Conservation Service Resources Assessment Division and Resources Inventory Division

Beltsville, MD

TABLE OF CONTENTS

1. BACKGROUND…….…………………………….………………………………….…...4

1.1 Introduction ….………………………….………………………………….…….4

1.2 Scope……………………………………….………………………………….….4

1.3 Contractor Work Responsibility……….…………………………………….……5

1.4 Agency Mission and Overview………….…………………………………….….5

1.5a National Resources Inventory Program (NRI)….…………………………….…6 1.5b Conservation Effects Assessment Project (CEAP) ………….………………….6 1.5c Soil and Water Conservation Act (RCA) / National Conservation Plan (NCP)...7 1.5d “Emergent Work”……………………….……….........………………………

1.6 Management Structure……………….…………….……...……………………...8

1.6.1 Resources Assessment Division…………………………………………8

1.6.2 Resources Inventory Division…………………………………………...8

2. RAD GEOGRAPHIC INFORMATION SYSTEM (GIS) LAB….….….………………

2.1 RAD GIS Lab Mission and Function………………….…………………………..8

2.2 Work Location……………………………………….…………………………….8

2.3 Facility Location…………………………………….……………………….…….9

2.4 Facility Status……………………………………….……………………………..9

2.5 Lab Staffing and Responsibilities………………….………………………………9

3. TRAINING…………………………………………………………………………….…...9

3.1 Staff Orientation…………………………………………………………………...9

4. CONTRACTOR RESPONSIBILITIES AND SERVICES……………………………….10

4.1 Data Ownership…………………………………………………………………...10

4.2 Confidentiality and Ethical Requirement..…….…….……………………………10

4.3 Background Checks……………………………………………………………….10

4.4 .Contractor Furnished Services.…..………………………………………………10

4.5 Delivery Dates.…...……………….………………………………………………11

4.6 Contractor Furnished Training……………………………………………………11

4.7 Staffing Level.…………..……..………………………………………………….11

4.8 Project Manager…..…………………………………………………….…………11

4.8.1 Monthly progress reporting……………………………………………11

4.8.2 Project Manager Change………………………………………………12

4.8.3 Earned Value Management……………………………………………12

4.9 Subcontractors…….……………………………………………………………...12

5. GOVERNMENT FURNISHED PROPERTY AND SERVICES……………………….……13

5.1 General……………………………………………………………………………….13

5.2 Hardware and Software………………………………………………………………13

5.3 Access to NRCS Information Technology Systems…………………………………13

5.4 Government or Agency Unique Training……………………………………………13

5.5 NRCS Key Personnel………………………………………………………………..13

5.5.1 Contracting Officer………………………………………………………..13

5.5.2 Contracting Officer Technical Representative…….………………………14

6. WORK CONDUCTED BY GIS LAB CONTRACTOR (3 1/2).………………………..14

6.1 General……………………………………………………….………………………14

6.1.1 General Overview……………………………….…………………………14

6.1.2 Hours of Work……………………………………………………………..14

6.1.3 Interruption of Operations.…………………………………………………14

6.1.4 Quality Control…………….………………………………………………14

6.1.5 Quality Assurance…………….……………………………………………15

6.1.6 Procedure for Changing analytical processes……………………………...15

6.1.7 NRI, CEAP, RCA, NCP, and ‘Emergent Work” Databases………………15

6.1.8 Four Major Tasks…………………………………………………………..16

6.2 Tasks and Performance Standards…………………………………………………...16

6.2.1 Relational database design…………………………………………………16

6.2.1.1 Tasks…………………………..…………………………………16

6.2.1.2 Performance Standard……….…………………………………..17

6.2.2 Data assessment and Data mining…………………………………………18

6.2.2.1 Tasks……………………………………………………………..19

6.2.2.2 Performance Standard………………………………………..…19

6.2.3 Geospatial data acquisition, development, integration, analysis…………..20

6.2.3.1 Tasks……………………………………………………………..21

6.2.3.2 Performance Standard…………………………………………...21

6.2.4 Research, development and editorial review………………………………22

6.2.4.1 Tasks……………………………………………………………..22

6.2.4.2 Performance Standard…………………………………………...23

7. SELECTION CRITERIA…………………………………………………………………….24

7.1 Instructions for Preparation of Technical and Pricing Proposals……………………24

7.1.1 General Instructions……………………………………………………….24

7.1.2 PART I Pricing Proposal…………………………………………………..24

7.1.3 PART II Technical Proposal………………………………………………24

8. REFERENCES……………………………………………………………………………….26

8.1 Technical Exhibits…………………………………………………………………...26

8.2 Web Sites…………………………………………………………………………….26

8.3 Acronyms……….……………………………………………………………………26

8.4 Terms and Definitions……..…………………………………………………………27

1. BACKGROUND

1.1 Introduction

The Resources Assessment Division (RAD) and the Resources Inventory Division (RID) of the Natural Resources Conservation Service (NRCS), provide leadership for the collection and analysis of critical agency datasets, with the primary focus of supporting the development of conservation policy for NRCS and other USDA agencies. RAD, with assistance from RID, is responsible for the planning, design, development, and implementation of the Conservation Effects Assessment Project (CEAP) and the Soil and Water Resources Conservation Act (RCA); and, these responsibilities include developing data, mapping, and support for reporting activities, as well as providing geospatial data to NHQ and for agency Initiatives. Similarly, RID leads the planning, design, development, and implementation of The National Resources Inventory (NRI), with assistance from RAD. The NRI is a primary data source for agency natural resource analysis, strategic planning, and policy development.

1.2 Scope

This solicitation is focused on the data development, integration, analysis, delivery and presentation needs of the RAD and RID analytical staff, their partners and customers in order to support national policy development for NRCS and USDA. The Contractor shall provide labor and services necessary to perform the four major tasks required by RAD and RID and their support for other work throughout the agency, as described in Section 6.

1) Relational database design, development, integration and analysis

2) Data assessment and data mining.

3) Geospatial data acquisition, development, integration, analysis visualization and display.

4) Research, development and editorial review of content for technical and non-technical reports, technical posters, presentations and web content development.

The data development, integration, analysis, delivery and presentation itself is primarily focused on these areas of work:

1) National Resources Inventory (NRI).

2) Conservation Effects and Assessment Program (CEAP).

3) Soil and Waters Resource Act (RCA) / National Conservation Program (NCP).

4) “Emergent Work” to support NHQ Initiatives, agency reporting, and partnerships.

Federal RAD and RID staff are senior technical and policy analysts with advanced degrees in economics, soil science, wetland science, agronomy, landscape analysis, statistics and geography. RAD and RID staff collaborates with subject matter experts across the Federal Government to analyze, validate and summarize resource data and generate useful information to support policy development and comply with federal data management regulations.

Research needs and analysis topics vary widely but generally are focused on natural resource conditions and trends and policy/program support. Frequently, the analyses must be done under short deadline in order to support the needs of senior leadership.

The Contractor will use data from a variety of sources and provide quantitative analysis, written summaries of procedures, conclusions, metadata and graphical representations of significant information as requested. See TE-7, Sample RAD and RID Analytical Products for examples of analysis products and projects. Microsoft XP and Windows Server 2003 are the primary operating systems.

1.3 Contractor Work Responsibility

The Contractor's work responsibilities shall include all administrative services and supervision of contract staff to execute the contract. The Contractor shall conduct work in accordance with this Contract and all applicable Natural Resources Conservation Service (NRCS) directives and technical guidelines, specifications, and protocols. The Contractor shall verify that all work meets the requirements, technical standards, and performance standards specified in the contract or in referenced documents and technical exhibits. The Contracting Officer’s Representative (COR) will review all materials to ensure compliance.

Over the life of the contract, procedures and technical exhibits may be modified based on knowledge gained from their application and general policy changes. The contract will be modified as such changes occur.

Some assignments may require work outside of the regular business hours in order to satisfy short-term deadlines.

The Contractor shall maintain accurate and complete records, files, and documents related to the functions being performed. The Contractor shall perform all related administrative services such as time-keeping; hiring staff; coordinating Contractor assignments; maintaining personnel files; and maintaining records for application of the Contractor's quality control plan. The Contractor shall prepare required reports and submit written documents and/or verbal briefings as specified in Section 4, Contractor Responsibilities and Services.

1.4 Agency Mission and Overview

The USDA-NRCS is the lead Federal agency for conservation of natural resources on non-Federal lands. The NRCS mission is to provide leadership in a partnership effort to help land users conserve, maintain, and improve our natural -resources and environment. NRCS delivers technical assistance based on sound science suited to a customer's specific needs. An NRCS partnership with local conservation districts serves almost every county in the Nation, the Caribbean Area, and the Pacific Basin.

The Soil Conservation Service (SCS), predecessor to the NRCS was created on April 27, 1935, by Public Law 46 (74th Congress). As part of the USDA Reorganization Act of 1994, the name was changed to the Natural Resources Conservation Service on October 20, 1994.

NRCS conservationists, from a variety of scientific and technical disciplines, work with land users, government, communities, conservation districts, organizations, agribusiness and others in providing technical and financial assistance to carry out legislated USDA conservation programs. Using NRCS assistance and technical standards, conservation programs help land users apply practices that reduce soil erosion and sedimentation in streams, improve water quality, protect and enhance wetlands, grazing lands, and wildlife habitat and improve agricultural production. All conservation programs and initiatives administered by NRCS are described at http://www.m'cs.usda.gov.

1.5a National Resources Inventory Program The. NRI is a longitudinal (statistical) survey of land use and natural resource conditions and trends on U.S. non-Federal lands. The NRI provides natural resource managers, policy makers, scientific researchers and the public with scientifically valid, timely, and relevant information on the condition and trends of natural resources and the environment. The NRI periodically collects data on more than 300,000 area sample and 800,000 sample points. Information from the NRI plays a key role in development of conservation policy and programs for the Nation, serves to educate the public regarding natural resource issues, and provides a comprehensive nationally consistent source of data for researchers in many fields. For more information, visit the NRI Web site at http ://www.nrcs.usda. gov/technical/NRI.

Information derived from the NRI provides a scientific basis for effective public policies, sound agricultural and natural resource legislation, sensible state and national conservation programs, and focusing United States Department of Agriculture (USDA) financial and technical assistance on the most critical resource issues and concerns. Data and estimates from NRI surveys are core components of the agency's strategic planning and accountability efforts and are used to assess consequences of existing legislative mandates, such as the most recent Farm Bill (See TE-1, NRI Background ).

1.5b Conservation Effects Assessment Project (CEAP) The Conservation Effects Assessment Project (CEAP) is a multi-agency effort led by USDA, in partnership with other agencies and institutions, to quantify environmental effects of conservation practices and develop the science base for managing the agricultural landscape for environmental quality. Project findings will guide USDA conservation policy and program development and help conservationists, farmers, and ranchers make more informed conservation decisions.

The CEAP vision is enhanced natural resources and healthier ecosystems through improved conservation effectiveness and better management of agricultural landscapes. The goal of CEAP for the future is to improve efficacy of conservation practices and programs by providing the science and education base needed to enrich conservation planning, implementation, management decisions, and policy. We will address this goal by creating and using knowledge gained through CEAP research and outreach to enhance conservation planning and decision making tools and by continuing to assess environmental and ecosystem effects of conservation.

CEAP has three main components—national assessments, watershed assessments, and literature reviews and bibliographies.

For more information, visit the CEAP Web site at http://www.nrcs.usda.gov/technical/nri/ceap.

1.5c Soil and Water Resources Conservation Act The Soil and Water Resources Conservation Act (RCA) provides broad natural resource strategic assessment and planning authority for the U.S. Department of Agriculture (USDA). The RCA calls for—

· A continuing Appraisal of the Nation’s soil, water, and related resources that documents the current status and trends of soil, water, and related natural resources; the capability of these resources to meet current and projected demands; the effects of regulations, policies, and programs on these resources; and the cost and benefits of conservation measures applied under USDA conservation programs and alternative conservation approaches.

· Similarly, a National Conservation Program to guide USDA assistance to landowners for conserving soil, water, and related resources on non-Federal land. The Program evaluates the Nation’s natural resource problems; effectiveness of current authorities and programs; alternative methods for achieving conservation objectives; and costs and benefits of alternative conservation practices.

For more information, visit the RCA Web site at http://www.nrcs.usda.gov/wps/portal/nrcs/main/national/technical/nra/rca.

To provide natural resource and conservation information to the public and the conservation community, an interactive RCA Data Viewer has been developed that provides downloadable data from a variety of sources, including data on the status and trends of natural resources, conservation efforts (funding and conservation practices applied) for the agricultural sector. For more information, visit the RCA Interactive Data Viewer at http://soils.usda.gov/survey/rca/viewer/

1.5d Emergent Work “Emergent Work” are those tasks the RAD GIS Lab does to support the national office. A big part of that support is for analysis in support of agency Initiatives, reports to Congress, OMB, Farm Bill activities, and State Resource Assessments. A range of analysis on natural resource conditions, agency program activity, and information from partners and other federal agencies is needed to support very specific agency efforts. This work is an important part of the support the RAD GIS Lab is expected to provide.

1.6 Management Structure

1.6.1 Resources Assessment Division

The Resources Assessment Division (RAD) is a division within NRCS that has responsibility for leading the agency's resource analysis efforts to support USDA in policy making for planning and delivery of natural resource conservation. The Division is responsible for the GIS Lab located in Beltsville, Maryland.

1.6.2 Resources Inventory Division

The Resources Inventory Division (RID) is a division within NRCS that has responsibility for the National Resources Inventory (NRI)

Together RAD and RID assess natural resource conditions and trends on private lands in the United States, including the CEAP effort; use of geospatial technologies (GIS, GPS, remote sensing) in NRCS; and have a major role in agency's resource assessments that support USDA in policy development for resource conservation. Leadership for both Divisions is located in Beltsville, Maryland.

2. GEOGRAPHIC INFORMATION SYSTEM (GIS) LAB

2.1 RAD GIS Lab Mission and Function

The mission of the RAD GIS Lab is to support the data and information needs of RAD and RID staff, their partners and customers in NRCS and USDA. Contract requirements are focused on the data development, integration, analysis, delivery and presentation needs of RAD, RID, partners, and customers.

Organizationally, the RAD GIS Lab reports to the Division Director for RAD and is led by the RAD Lab GIS Coordinator. The senior statistical programmer is assigned to the RID statistician to support NRI related tasks. The Lab staff works closely with senior program managers to investigate and address complex resource related issues using a variety of software tools and data and statistical techniques. The NRI and associated monitoring efforts are key inputs for complex analysis needs and policy formulation.

The Contractor shall work with senior agency staff to design, develop, populate, query, analyze and maintain spatial and tabular databases critical to agency program needs. The Contractor will conduct complex spatial and tabular analysis of data, troubleshoot anomalies and generate graphics and written text to support quality review. The Contractor will provide recommendations on design enhancements, query techniques and quality control methods; work with staff to develop program assessment criteria and trending methodology.

2.2 Work Location

The Contractor shall work onsite at the NRCS Beltsville facility shown in Section 2.3. Contractor shall attend periodic meetings at other locations within the local commuting area, in order to communicate project needs. The majority of such meetings will occur at the USDA South Building and USDA Whitten Building, both located in the District of Columbia. The contractor will be responsible for transportation of Contractor employees to and from the meetings.

2.3 Facility Location

George Washington Carver Center

USDA-NRCS

5601 Sunnyside Avenue Beltsville, Maryland 20705

2.4 Facility Status

(See TE-5, Government Furnished Hardware and Software ).

2.5 Lab Staffing and Responsibilities

The RAD GIS lab will include the current level of federal employee staffing. NRCS will provide space for three full-time and one part-half Contractor employees at the Beltsville facility. The federal staff is composed of the RAD GIS Lab leader, who also serves as COR, and two Geographic Information Specialists (GIS). NRCS staff will ensure that customer needs and the timeframe for product delivery are clearly defined in each task order. Contractor will perform quality control to determine if work meets contract requirements, as well as, determine if products satisfy customer requests and are reviewed by appropriate subject matter expert and data and information is presented in a manner consistent with agency protocols.

The Contractor shall complete the tasks specified in the Contract and ensure that the work is conducted according to Contract specifications (See Section 4.8, Project Manager). The NRCS COR will serve as the technical liaison for NRCS.

The Contractor shall maintain an authoritative project database reflecting critical information on each project and product generated. Unless otherwise stated, the database will reflect the level of effort for each assignment. Customer name, date of assignment, location of final product, data used and hours spent on the assignment will be documented. Federal Geographic Data Committee (FGDC) metadata will be generated for all products.

3. TRAINING

3.1 Staff Orientation

Contractor shall receive an orientation from NRCS staff providing an overview of the agency, key data resources, inventorying and monitoring efforts, information technology (IT) environment, data and IT security issues and organizational structure of RAD, RID, and NRCS.

4. CONTRACTOR RESPONSIBILITIES AND SERVICES

4.1 Data Ownership

All products generated by the Contractor shall become the sole property of the Government and shall not be copied, copyrighted, sold, or used in any form other than in support of NRCS, USDA and its partners.

4.2 Confidentiality and Ethical Requirements

All Contract personnel shall be required to sign and abide by confidentiality and ethical requirements specified in TE-3, Ethical Requirements, and TE-2, Confidentiality Certification and Request for Access to NRI Data .

4.3 Background Checks

Each staff member shall successfully complete a basic background check (TE-8 , Personnel Security Bulletin).

USDA has established legal and regulatory requirements that must be met before access is granted to IT resources by Contractor. Following is required;

· Completed and signed background investigation questionnaire (SF85 and

SFS6 )

· FBI fingerprint card (FD-258 )

· As applicable, completion of online security awareness training within 60 days of employment

· Read and sign USDA IT user agreement

The contractor is responsible for pre-screening all personnel proposed for work under this contract/purchase order and for ensuring that all persons have submitted to the Government a completed Standard Form 85 or Standard Form 86, Questionnaire for Non-Sensitive Positions, 10 calendar days after execution of the contract. The Government will provide the forms. The forms shall be submitted to the COR. The government will provide a facility identification pass for each contract employee who is determined suitable for the job based on the background investigation. The facility identification pass shall be issued, displayed and surrendered as directed by the CO or COR.

The Government may furnish computer equipment to the minimum extent necessary for mission accomplishment. The contractor shall not use Government furnished equipment or services for non-contractual related purposes. The contractor shall comply with all computer operational and accountability procedures required by the Government (See TE-8, Personnel Security Bulletin).

4.4 Contractor Furnished Services

Contractor shall provide staff to complete the required tasks within the timeframes specified. Contractor will have knowledge of natural resources, photo interpretation, understanding of concepts and principals of GIS technology and applications, ability to use standard office automation tools, understanding of and experience with statistical sample design, statistical software, cartography and geography, excellent written and interpersonal skills and knowledge of graphic presentation software. (See TE-5, Government Furnished Hardware and Software).

4.5 Delivery Dates

The Contractor shall deliver the specified products according to the timelines established by the contract and each task order.

4.6 Contractor Furnished Training

The Contractor is responsible for providing employee training.

4.7 Staffing Level

Based on current workload projections, three full-time and one half-time contract staff is needed to support the GIS lab and RAD and RID. Unanticipated workload increases may require a modification. Additional tasks may be added to the contract as needed and the contractor will be expected to add staff if required to meet the agreed to deadline.

4.8 Project Manager

The Contractor shall provide an onsite Project Manager with experience in the management of organizations providing natural resource data collection, mapping, geospatial services, and GIS technologies. The Project Manager shall conduct overall coordination of work assignments for contract employees and shall be the primary point of contact with the Government for performance of all work under the Contract. The Project Manager responsibilities may be satisfied by the senior member of the three fulltime and one part-time staff.

An Alternate Project Manager shall be designated to act in the absence of the Project Manager. The Alternate Project Manager shall be authorized to perform all duties of the Project Manager. The Project Manager and Alternate Project Manager shall be employed by the Contractor. The name and contact information for the Project Manager and Alternate Project Manager shall be provided in writing to the Contracting Officer within 30 days after Contract award.

The Project Manager shall ensure that contractor personnel maintain an authoritative project database reflecting critical information on each project and product generated. Customer name, date of assignment, location of final product, data used and hours spent on the assignment will be documented. Where appropriate, FGDC metadata will be generated for all products.

4.8.1 Monthly progress reporting

The Contractor shall submit a monthly progress report and billing invoice covering work accomplished and hours logged for each individual and cross-referenced by project and task. (See TE-10, Example monthly invoice). A copy of the billing invoice must also be subjected by the Contractor to the CO for payment.

The progress report shall be brief and factual and shall be prepared in accordance with AGAR 452.237-76, and contain the following format;

a) A cover page containing;

1) Contract number and title;

2) Type of report, sequence number of report, and period of performance being reported;

3) Contractor's name and address;

4) Author(s); and

5) Date of report

b) Section I - An introduction covering the purpose and scope of the contract effort.

c) Section II - A description of progress and a description of each task on which effort was expended during the report period.

d) Section III - A description of any problem(s), which may impede performance along with suggested corrective action.

e) Section IV - Monthly schedule of staff hours and primary projects currently being worked on. Schedule to be updated monthly and include an explanation of any difference between actual progress and planned progress, why the differences have occurred, and options for what corrective steps.

The contractor shall provide two (2) copies of the progress report to COR at the following address:

RAD GIS Lab Coordinator

USDA - NRCS

GWCC

5601 Sunnyside Ave, MS 5410 Beltsville, MD 20705

The COR will provide materials to the CO as needed.

4.8.2 Project Manager Change

Any changes to the Project Manager shall be approved by NRCS at least five work days prior to the change. NRCS may require replacement of the Project Manager if NRCS deems the Project Manager to be unacceptable.

4.8.3 Earned Value Management

NRCS uses an Earned Value Management System in accordance with ANSI Standard 748 to report and track performance of investments that use work under this contract. Contractors doing work under this task order shall provide NRCS Project Managers with periodic EVM data documenting the cost, schedule, and performance of work. The data shall be provided within five (5) business days of the end of the reporting period. The reporting period shall be at least monthly but may be more frequent.

4.9 Subcontractors

Subcontractors may be used to accomplish the tasks and requirements of the contract. Subcontractors shall be subject to the same personnel requirements, including performing all work onsite, as specified herein for Contract personnel. The Contractor shall prepare a written plan and procedure to manage any subcontractors. The Contractor is solely responsible for the performance and cost control of its partnerships and subcontractors. Any changes to subcontractors shall require written approval by the CO. Requests for any changes will be sent to the CO at least five work days prior to the change

5. GOVERNMENT FURNISHED PROPERTY AND SERVICES

5.1 General

The Government shall provide the facilities, equipment, software, supplies, and materials described herein as Government Furnished Hardware and Software (See TE-5). The Contractor shall not use government furnished hardware and software for any purpose other than execution of work under the Contract.

5.2 Hardware and Software

See TE-5 for a listing of hardware and software provided by the government. The Government shall provide all information technology (IT) system administration support for hardware, software, operating systems, data and other related IT operations. The Government will provide a general familiarization with the automated systems for the contract personnel, but it is the responsibility of the Contractor to train their staff in use of commercially available hardware and software.

5.3 Access to NRCS Information Technology Systems

The Contractor shall have limited access to the NRCS automated systems as described in TE-6, Computer System Access Control Process, based on conditions such as those described in TE-8, Personnel Security Bulletin.

5.4 Government or Agency Unique Training

Any NRCS specific or Government-unique training deemed essential for contract employees will be provided by the Government. NRCS-specific training is defined as training that is unique to NRCS datasets, software, computer security, ethics, procedures and protocols, including the use of unique equipment and software to perform the tasks. Such training may be provided at the work site or at other sites designated by the COR.

5.5 NRCS Key Personnel

5.5.1 Contracting Officer

The Contracting Officer (CO) has the authority to enter into, administer, or terminate contracts. The CO is responsible for ensuring performance of all necessary actions for effective contracting, ensuring compliance with the terms of the Contract and safeguarding the interests of the U.S. in its contractual relationships. The CO is responsible for ensuring that sufficient funds are available for obligation. The CO is responsible for issuing task orders for the work requirements and approving any changes to the work.

5.5.2 Contracting Officer Representative

The Contracting Officer’s Representative (COR) is the primary contact for the Contractor's Project Manager. The COR is primarily responsible for managing the technical requirements of the Contract. The COR also ensures the Contractor is meeting the performance schedule and cost requirements of the Contract. The COR has the most continuous contact with the Contractor and serves as a liaison between the Contractor and the CO on matters of a technical nature.

6. WORK CONDUCTED BY GIS LAB CONTRACT STAFF

6.1 General

6.1.1 General Overview

The Contractor shall perform all tasks in accordance with policies, procedures, standards, protocols and specifications as referenced in this section and included in Section 9.1, Technical Exhibits. A more detailed list of tasks, workload, and performance standards are described for each major task in Section 6.2, Tasks, and Performance Standards.

6.1.2 Hours of Work

Unless otherwise changed by the Contracting Officer, work schedules shall be Monday through Friday, excluding legal Federal holidays. Contractor employees shall not work double shifts. Unless otherwise approved by the CO, Contractor employees shall not exceed 10 hours per day while working at the Beltsville facility. Alternate work schedules may be negotiated with the COR and approved by the CO.

6.1.3 Interruption of Operations

In case of operation interruptions (e.g., power outages, network disruptions, natural disasters) that cause the Lab to redistributed work to other facilities, it may be necessary to temporarily relocate staff to other facilities to address workload.

6.1.4 Quality Control

Quality control shall be exercised by the Contractor throughout the performance of the contract. Procedures shall be established to ensure that interim and final products meet the required level of accuracy and quality.

6.1.5 Quality Assurance

NRCS technical specialists will review Contractor work to ensure quality. Any products failing to meet performance standards shall be redone by contractor at their expense.

6.1.6 Procedure for Changing Analytical Processes

Proposed changes in processes, procedures, or protocols shall be discussed with the COR for formal approval prior to implementation.

6.1.7 NRI, CEAP, RCA, NCP, and Emergent Work Databases

The contractor will become familiar with and able to query and generate spatial and tabular products from the NRI, CEAP datasets, related databases used for the RCA, NCP, and Emergent work (e.g. NCP, PRS, ProTracts). NRCS staff will provide contractor staff with information critical to the accurate interpretation and analysis of the NRI database, CEAP datasets, and other agency program related data resources.

For the NRI, data obtained through photo interpretation are combined with on-site data collection and field office records and historical data, soils maps, and other ancillary materials to produce Annual NRI databases. Preliminary and final datasets are generated annually for the NRI. The contractor will support the analysis needs for each cycle. The exact dates for preliminary and final datasets may vary slightly.

For CEAP, the different CEAP Components provide various datasets. The CEAP Cropland Farmers Survey provides input data for water quality modeling and information to assess farming and conservation activities across the landscape at regional and the national level. Regional CEAP cropland studies require the generation of expansion factors for data interpretation. The RAD GIS Lab works with the NRI staff to provide those expansion factors. The RAD GIS Lab also works with the NRI Director in developing the NRI-based CEAP sample. CEAP data from other components are also used for national assessments such as the RCA. The exact dates for additional datasets may vary.

For the RCA, NCP analysis, NRCS, USDA, and other Federal agency conservation information is reported as part of a continuing appraisal that documents the current status and trends of soil, water, and related natural resources; the capability of these resources to meet current and projected demands; the effects of regulations, policies, and programs on these resources; and the cost and benefits of conservation measures applied under USDA conservation programs and alternative conservation approaches. The contractor will become familiar with these databases and be able to produce reports, as well as populate and maintain the information on the RCA website.

Emergent work includes a broad range of support provided to the NRCS national office. The contractor will become familiar with agency Initiatives and agency databases and be capable of providing tabular reports, geospatial information, and other information to headquarters staff that assist with agency planning and policy review and development.

6.1.8 Four Major Tasks

Products requested of and generated by the RAD GIS Lab fall into four primary work areas. The NRI database, CEAP database, related agency program and practice databases used for the RCA and Emergent work, as well as information for partner agencies such as USGS are a major source of data and cover the scope for each of the four tasks. The contractor will be expected to satisfy the following needs:

1) Relational database design, development, integration and statistical analysis/processing utilizing the NRI database.

2) Data assessment and data mining.

3) Geospatial data acquisition, development, integration, analysis, visualization and display

4) Research, development and editorial review of content for technical and non-technical reports, technical posters, presentations and web content development.

6.2 Tasks and Performance Standards

6.2.1 Relational database design, development, integration and statistical analysis/processing using the NRI, CEAP, and primary agency datasets used for the RCA, NCP, and Emergent work.

Collaborate with senior NRCS technical program staff to evaluate complex data from the NRI and where warranted, CEAP components, and agency datasets, and other sources to integrate the data to facilitate statistical, geospatial, and tabular assessments and assist in interpreting the data for program and policy applications. Troubleshoot and resolve data anomalies in conjunction with data steward and program managers. Prepare micro datasets (or subsets) for NRCS partners who are authorized to use NRI micro data and assist those partners with processes to manipulate the data and to generate estimates and associated statistical errors. Suggest data collection, analysis and design enhancements to facilitate future use by agency employees. Contractor shall have familiarity with statistical analysis for summary data (natural resources), natural resource issues, data and GIS. Possess excellent communication, analytical, presentation and computer skills.

Software skills required-statistical analysis, relational database theory, structured query language, spreadsheets, geographic information systems, word processing and email.

6.2.1.1 Tasks (Relational database design, development, integration, and statistical analysis/processing related to the NRI, CEAP, RCA, NCP, and Emergent Work) 6.2.1.1.1 Contractor shall conduct analysis using the raw NRI national dataset and generate products meeting the statistical reliability and analysis protocols, quality of information guidelines and standards defined by USDA and NRI national leadership. See http://www.ocio.usda.gov/qiguide/index.html

6.2.1.1.2 Contractor shall design, develop, maintain and populate databases to support and enhance the analysis of the NRI, trending and CEAP modeling efforts.

6.2.1.1.3 Contractor shall summarize and communicate analytical results and finds from the NRI and other analysis using charts, spreadsheets, maps and other graphic methods to effectively convey complex data.

6.2.1.1.4 Contractor shall maintain and manage detailed records of procedures, standards and protocols used in the completion of all tasks.

6.2.1.1.5 Contractor shall conduct analysis of agency program and practice data sets for updating the RCA on an annual basis (or other interval as specified by the COR).

6.2.1.1.6 Contractor shall maintain and/or access quarterly updated program and practice datasets for use in agency Emergent work to facilitate processing. NRCS staff will identify which data need to be updated on a quarterly basis.

6.2.1.2 Performance Standard (Relational database design, development, integration and statistical analysis/process using the NRI, CEAP, RCA, NCP, and Emergent Work).

6.2.1.2.1 Acceptable performance for task 6.2.1.1.1 requires the Contractor to perform as follows:

· Accurately query and interpret the NRI database using relational database techniques and statistical procedures 99 percent of the time. Procedures include the generation of standard errors or margins of errors with all data estimates.

· Adhere to NRI data access and usage policy analysis protocols and standards, NRCS and USDA IT system security policy 100 percent of the time.

· Document all projects with FGDC compliant metadata, and procedural notes. Document all scripts and tools 100 percent of the time.

· Satisfy customers requests for analytical products within the required timeframe 95 percent of the time.

6.2.1.2.2 Acceptable performance for tasks 6.2.1.1.2 requires that contact staff to perform as follows:

· Conduct quality review on incoming data from various sources, document data anomalies and communicate to COR and program manager 100 percent of the time.

· Design, develop and populate databases and generate standard relational databases to facilitate data access using standard SQL nomenclature 97 percent of the time.

· Document all projects with FGDC compliant metadata, and procedural notes. Document all scripts and tools 100 percent of the time.

· Work consistently and effectively with NRCS Technical program leadership and customers to review validate and finalize analysis needs 100 percent of the time.

6.2.1.2.3 Acceptable performance for task 6.2.1.1.3 requires the Contractor to perform as follows:

· Maps, bar charts and other, graphic representations will be clearly titled, source data accurately referenced, data and legible 100 percent of the time.

· Map products will conform to NRCS accepted cartographic principles and practices 100 percent of the time.

· Contractor will archive all products as required by contract.

6.2.1.2.4 Acceptable performance for task 6.2.1.1.4 requires the at Contractor to perform as follows:

· Document process, procedures, scripts and tools developed for all projects 100 percent of the time.

· Generate FGDC compliant metadata for all products 100 percent of the time.

· Ensure that all products and services achieve the requirements of the contract or task order.

6.2.2 Data Assessment and Data Mining

Contractor shall be responsible for researching, generating and statistically evaluating composite datasets, which may include the NRI. Statistically assess the datasets for usefulness based on customer needs and intended application. Define analysis procedures based on unique aspects of the data, and identify application limitations. Advanced knowledge of statistical analysis, natural resource trending databases, NRCS business areas and error estimation techniques used in the NRI. Excellent communication skills required.

Software skills required-statistical analysis, relational database theory, structured query language, spreadsheets, geographic information systems, word processing, and email.

6.2.2.1 Tasks (Data Assessment and Data Mining)

6.2.2.1.1 Contractor will design, develop and populate databases to support and enhance the analysis needs of RAD and RID staff, partners, customers, and cooperators.

6.2.2.1.2 Contractor will assess available NRCS data and it’s value to current and future projects. Data mining techniques will be used to explore the value of derivative products to support NRCS programs. Contractor will generate scripts and tools to enhance data access.

6.2.2.1.3 Contractor will summarize and communicate analytical results and findings graphically using bar charts, maps and other devices to effectively convey complex data.

6.2.2.1.4 Contractor will maintain and manage detailed records of procedures, standards and protocols used in the completion of all tasks.

6.2.2.2 Performance Standard

6.2.2.2.1 Acceptable performance for task 6.2.2.1.1 requires Contractor to:

· Accurately design, populate and manage relational databases using standard SQL tools and a variety of NRCS data and other data, 99% of the time.

· Adhere to data and IT security protocols, data access and usage policy, analysis protocols and standards, 100 percent of the time.

· Document all projects with FGDC compliant metadata, and procedural notes. Document all scripts and tools 100 percent of the time.

6.2.2.2.2 Acceptable performance for task 6.2.2.1.2 requires Contractor to:

· Be familiar with NRCS datasets and accurately evaluate new data for ongoing efforts 90% percent of the time. Effectively mine data from multiple sources to enhance agency analytic capability 90 percent of the time.

· Work consistently and effectively with NRCS Technical program leadership and customers to review validate and finalize analysis needs 100 percent of the time.

· Document all projects with FGDC compliant metadata and procedural notes. Document all scripts and tools 100 percent of the times.

6.2.2.2.3 Acceptable performance for task 6.2.2.1.3 requires Contractor to:

· Generate clear and concise graphics summarizing analysis results 95% of the time.

· Work with program managers to review and evaluate analysis and summary graphics 100% of the time.

6.2.2.2.4 Acceptable performance for task 6.2.2.1.4 requires Contractor tol:

· Maintain the authoritative project database reflecting critical information for each project 100% of the time.

· Submit a monthly progress report, billing invoice covering work accomplished and hours logged for each individual and cross-referenced by project and task and EVM data. The progress report shall be brief and factual and shall be prepared in accordance with AGAR Clause 452.237-76, Progress Reporting. Report will be submitted within the first week of every month 100 percent of the time.

6.2.3 Geospatial data acquisition, development, integration, analysis, visualization and display.

Contractor will develop and integrate data from a wide variety of sources, conduct advanced spatial analysis and generate cartographic output including visualizations. Contractor will communicate with a wide variety of NRCS and USDA customers and assess needs and timeframe for deliverable which will be defined in collaboration with the COR. Data sources will include analog and digital tabular, pre-existing vector and raster data and imagery. Strong knowledge of natural resources databases, GIS, and strong communication skills are critical.

Software skills required-statistical analysis, relational database, structured query language, spreadsheets, geographic information systems, cartographic display, image processing, popular internet protocols, common PC based operating systems, word processing and email tools.

6.2.3.1 Tasks (Geospatial data acquisition, development, integration, analysis, visualization and display). Contractor shall:

6.2.3.1.1 Acquire spatial data, assess usability, document source and submit to RAD and RID spatial data repository for common use.

6.2.3.1.2 Conduct spatial analysis and generate products meeting customer’s needs. Suggest alternative analysis where appropriate to enhance final product. Document analysis and products in accordance with RAD and RID procedures.

6.2.3.1.3 Generate a wide variety of thematic based cartographic and graphic products for the nation, NRCS regions and sub-regions.

6.2.3.1.4 Support and maintain RAD GIS Lab datasets and GIS layers bringing together natural resource, science based information on the effects of farming and conservation, and program/practice data and bring into a dynamic geospatial platform.

6.2.3.2 Performance Standard (Geospatial data acquisition, development, integration, analysis, visualization and display)

6.2.3.2.1 Acceptable performance for task 6.2.3.1.1 requires Contractor to:

· Document incoming, data deemed useful with FGDC compliant metadata 100 percent of the time.

· Validate incoming data and document anomalies 100 percent of the time.

· Submit data to RAD And RID repository for common use 100 percent of the time.

6.2.3.2.2 Acceptable performance for task 6.2.3.1.2 requires Contractor to:

· Accurately interpret customer request and generate draft product for review 95% of the time.

· Utilize data within its known quality limitations and convey limitations to the customer 100 percent of the time.

· Adhere to NRI data confidentiality restrictions 100 percent of the time.

· Acquire and use best available data for analysis and cartographic output 99 percent of the time. Explore and recommend alternative display methods to enhance usability of the product 100 percent of the time.

· Document analysis process and procedures 100 percent of the time.

6.2.3.2.3 Acceptable performance for task 6.2.3.1.3 requires Contractor to:

· Document analysis process and procedures 100 percent of the time.

· Generate graphic products including maps that adhere to RAD and RID, USDA and industry guidelines 99 percent of the time.

· Review products with RAD and RID staff prior to release to customer 100 percent of the time.

· Data are classified and represented accurately using appropriate statistical analysis 99 percent of the time.

6.2.3.2.4 Acceptable performance for task 6.2.3.1.4 requires Contractor :

· Document data development of specific integrated datasets that bring together program/practice, natural resource, and science based information on the effects of farming and conservation.

· Monitor and update key data elements based on recommendations by the COR.

· Revises products with RAD staff prior to release to customers 100 percent of time.

6.2.4 Contractor shall assist in the research, development and editorial review of content for technical and non-technical reports, technical posters, presentations and web content development.

Work with senior policy analysts and subject-matter experts to effectively articulate their research findings using a variety of methods. Contractor will assist staff in the development and editorial review of presentations, scientific papers, posters, maps, charts, brochures, and web content.

Software skills required-Web development and content management, word processing and email tools, desktop publishing, statistical analysis, relational database, spreadsheets, geographic information systems, cartographic display, image processing and common internet protocols.

6.2.4.1 Task (Contractor shall assist with research and development and editorial review of content for technical and nontechnical reports, technical posters, scientific papers, graphic displays, presentations and content for the Internet (WWW)).

6.2.4.1.1 Design and develop graphic layout materials for scientific journals, the Internet, speaking engagements, brochures and internal communication.

6.2.4.1.2 Provide editorial review and assist in writing scientific reports, papers and articles for publication by NRCS staff.

6.2.4.1.3 Products generated adhere to RAD and RID format requirements, are fully documented and reviewed by senior staff.

6.2.4.1.4 Design and develop Internet content for NRCS web pages which conform to NRCS, USDA and industry standards.

6.2.4.2 Performance Standard (Assist with research and development of technical and non-technical reports, posters, graphic displays, presentations and content for the Internet (WWW)

6.2.4.2.1 Acceptable performance for task 6.2.4.1.1 requires Contractor to:

· Deliver requested product to the customer within in the agreed to timeframe 100 percent of the time.

· Materials are free of typographical errors 99 percent of the time.

· Conform to USDA and NRCS publication guidelines 95 percent of the time.

6.2.4.2.2 Acceptable performance for task 6.2.4.1.2 requires…