SOW_-_SCIP_GIS_Program_Support.pdf

STATEMENT OF WORK FOR THE

DEPARTMENT OF INTERIOR

Bureau of Indian Affairs (BIA)

San Carlos Irrigation Project (SCIP) Geographic Information Systems

1. PURPOSE:

This Statement of Work describes support needed by the Bureau of Indian Affairs (BIA) San Carlos Irrigation Project (SCIP), for Geographic Information System (GIS) Support.

2. PROGRAM OBJECTIVES:

The Objective of this requirement is to provide program support to BIA to supply a comprehensive daily on-site GIS project manager to confirm completion of work by the SCIP Power Division (SCIP-PD). The GIS project manager will confirm the site of new construction is as described and document that information in the BIA GIS. Updating this vast amount of information will assist SCIP in operating and managing its current service area assets, and will enable SCIP to operate more efficiently, safely, and successfully for future electric utility operations.

The electric service boundaries of SCIP extends across four counties (Gila, Maricopa, Pima and Pinal) roughly from the San Carlos Apache Reservation, and Coolidge Dam and San Carlos reservoir to the east, to the border of the Gila River Indian Reservation to the north and west, and to town of Catalina in Pima County and Casa Grande-Coolidge-Florence areas in Pinal County.

The power system consists of, but is not limited to the following attributes:

• 29 electrical substations.

• 250 miles of 69 kV transmission power lines.

• 700 miles of overhead three-phase primary 12.47 kV distribution.

• 30 miles of underground three-phase primary 12.47 kV distribution.

• 450 miles of overhead single-phase 7.2 kV primary distribution.

• 70 miles of underground single-phase 7.2 kV primary distribution

• 250 miles of overhead secondary distribution

• 100 miles of underground secondary distribution

• 35,000 transmission, distribution and lighting support structures

• Approximately 2,500 square miles of electrical service territory; and

• 13,000 total service locations (meter).

3. PERIOD OF PERFORMANCE:

This contract term is for a total of 2160 hours.

Bureau of Indian Affairs (BIA)

San Carlos Irrigation Project (SCIP)

4. PLACE OF PERFORMANCE:

BIA SCIP Headquarters in Coolidge Arizona and throughout the SCIP-PD service area.

5. TASKS AND DELIVERABLES

5.1 The Contractor shall provide consulting services to assist BIA SCIP with the following tasks daily:

5.1.1 Provide consulting by maintaining an electrical utility GIS system with Trimble

GPS units to collect field data; contractor will provide assistance to SCIP personnel to utilize GIS tools; and provide advice daily to maintain and update any GIS power system modifications. (Contributes to Deliverable 1)

5.1.2 Provide consulting by adding data into an Environmental Systems Research Institute (ESRI) GIS database, utilizing specifically a GIS electric utility data model. During the data process, quality analysis and quality control checks are addressed to ensure accurate data quality and standardization. Once the GIS data is updated the onsite, Contractor is responsible for integrating that information with other information systems, such as Irrigation System O&M, Cultural and Environmental Studies, Power Line Design, engineering analysis and Power System Dispatch, as well as other departments within SCIP. (Contributes to Deliverable 1)

5.1.3 The consultant shall analyze and evaluate data involving SCIP’s electrical system facilities by collecting the data utilizing Global Positioning System (GPS) hardware and software which is then stored into a Geographic Information System (GIS). SCIP currently operates an ArcGIS Pro system.

(Contributes to Deliverable 1)

5.1.4 The consultant shall generate new or verify mapped information, using standard field sampling and electrical system data collection. (Deliverable 2)

5.1.5 Provide consultant expertise in the Design, Develop and Management of the GIS database and database management system. (Deliverable 3)

5.1.6 Provide continual consulting support and maintenance of GIS interface with computer system including global positioning systems, personal computers, data collectors, printers and plotters. (Deliverable 3)

5.1.7 Aid BIA managers in the management and integration of a variety of software and database management software, and when necessary, modifies or adapts standard software to meet program needs. Implements data documentation procedures and data distribution using appropriate technologies. Designs and develop global positioning system (GPS) data dictionaries, spatial data inventories, and cross linkages to ensure software and data structure compatibility. (Deliverable 3)

Bureau of Indian Affairs (BIA)

San Carlos Irrigation Project (SCIP) Geographic Information Systems

5.1.8 Ensure that the correct and appropriate application of geographic and cartographic concepts and principles are applied to database construction, analyses, and production of high quality digital and hardcopy GIS products.

Creates draft and presentation quality output products. (Contributes to Deliverable 1)

5.1.9 Provide expertise in maintaining a system wide inventory of all SCIP assets.

Contractor will be responsible for maintaining GIS industry standard on data collected therefore it is imperative the Contractor have in-depth knowledge of electrical design. (Contributes to Deliverable 1)

5.1.10 Provide GIS data by circuit in ESRI format in the following Coordinate system and Projection: (Contributes to Deliverable 1) Item Description Name NAD_1983_UTM_Zone_12N Projection Transverse Mercator Units Meter Datum North American Datum 1983 Ellipsoid GRS 1980

5.2.11 Delivery of data to SCIP is subject to review by SCIP and subject to correction by the Contractor at no additional cost. (Contributes to Deliverable 1)

5.2.12 Develop and support SCIP customer data integration into the UMS.net Electrical Utility Management System and NOVOTX Elements SQL databases.

5.3 The Contractor shall provide consulting services to assist BIA SCIP and provide the following deliverables by creating reports from the data in the system:

5.3.1 DELIVERABLE 1: SCIP Map Production and Analysis

(Tasks 5.2.1-5.2.3 and 5.2.8-5.2.12) Deliverable Frequency Description/Content Required SCIP Map Production and Analysis by Department

Monthly Engineering: Average 10 – map requests, map edits, analysis

Monthly

Archeology: Average 5-30 – map requests, map edits, Monthly Operations: Average 5 – map requests, map edits, analysis

Monthly Line crew: Average 10– map requests, map edits, analysis

Monthly Meter Shop: Average 10 – map requests, map edits, Bureau of Indian Affairs (BIA)

San Carlos Irrigation Project (SCIP)

Monthly

External Organization Requests (Eng. Firms, Counties, Arizona Blue stake, etc): Average 10 – map requests, map edits, analysis

Monthly Irrigation: Average 10 – map requests, map edits, analysis

Monthly Customer Service: Average 10 – map requests, map edits, analysis

Monthly Archeology: Average 5-30 – map requests, map edits,

5.3.2 DEVLIVERABLE 2: SCIP GIS Field Collection Activities (Task 5.2.4)

Deliverable Frequency Description/Content Required SCIP GIS Field Collection

Monthly Engineering: Average 10 Field collection jobs

Monthly Archeology: Average 5 Field collection jobs Monthly Operations: Average 5 Field collection jobs Monthly Line crew: Average 20 Field collection jobs Monthly Foreman 3: Average 20 Field collection jobs Monthly Meter Shop: Average 5 Field collection jobs Monthly Irrigation: Average 5 Field collection jobs Monthly Customer Service: Average 5-30 Field collection jobs

5.3.3 DELIVERABLE 3: SCIP GIS Database Support (Tasks 5.2.5-5.2.7)

Deliverable Frequency Description/Content Required SCIP GIS database (backup, design)

Monthly Arcreader published map viewer: Average 4-5 maps published

Monthly Geodatabase backup: Average 4-5 backup saves Monthly Feature dataset/feature class creation: Average 5 back up saves Monthly SCIP GIS database extrapolation: Average 10 tasks