RFP_26-14,_Attachment_A_-_Appendix.pdf

RFP 26-14, ATTACHMENT A

FACILITY INVENTORY ITEM RULE

A-1

Appendix A. Tables.

Pole Unique Identifier for location to be installed if required.

Bartow will supply identifier tags.

Station Number - 5 digits. Bartow asset identification number

Framing H- Horizontal V – Vertical, no crossarm.

Pole Usage Distribution, Secondary, Span-Guy, Lighting, Foreign

Owner Bartow, Duke Energy, TECO, Other Birthmark Manufacture Date Birthmark date or Not Available

Material Wood, Concrete, Fiberglass, Steel, Ductile Iron, Other

Height 30 feet to 110 feet in five-foot increments.

Height Determination Method Birthmark or Estimate Class Wood: 1,2,3,4,5. Concrete: II, III, IV or KIPS.

Ductile Iron H1, H2 Treatment Type CCA, Creosote, Penta X-coordinate via GPS Y-coordinate via GPS

Stub Poles May be multiple records and multiple attachments that need to be cleared

Stub pole to be pulled No attachments, can be pulled by Bartow

Attachment needs to be transferred Joint use attaches are still attached.

Pole

Mounted Light

Multiple records per pole possible

Pole Number Fixture Type Area, Roadway, Flood, Acorn, Coach Lamp Type HPS, LED Lamp Wattage 100, 150, 250, 400 Watt HPS

40, 98, 194, 212, 237 Watt LED Billing Class Road, Rental, (Bartow Determination Rules)

One Unit

Transformer Bank OH

Pole Number Source side circuit identifier Circuit Name

A-2

Phase (1st transformer) A, B, or C KVA Marking (1st transformer) KVA Marking or No Marking Transformer ID Number Verify and update Bartow asset number #### Animal Package? Y or N

Two Unit

Bank OH

Assumes Delta/Delta connection

Pole Number Source side circuit identifier Circuit Name Phase (1st transformer) A, B, or C KVA Marking (1st transformer) KVA Marking or No Marking Transformer ID Number (1st transformer) Verify and update Bartow asset number #### Phase (2nd transformer – if any) A, B, or C KVA Marking (2nd transformer – if any) KVA Marking or No Marking Transformer ID Number Verify and update Bartow asset number ####

Three Unit

Bank OH

Phase (1st transformer) A, B, or C KVA Marking (1st transformer) KVA Marking or No Marking Transformer ID Number (1st transformer) Verify and update Bartow asset number #### Phase (2nd transformer – if any) A, B, or C KVA Marking (2nd transformer – if any) KVA Marking or No Marking

Transformer ID Number (2nd transformer

– if any)

Verify and update Bartow asset number ####

Phase (3rd transformer – if any) A, B, or C KVA Marking (3rd transformer – if any) KVA Marking or No Marking Transformer ID Number (3rd transformer

– if any) Verify and update Bartow asset number ####

Secondary Connection Wye or Delta

OH Switch

Pole Number Bartow asset number

Switch Number Field Information or not available Type Load break, or non load break Size 1200-amp 900-amp, 600 amp, 300 amps Status Open or Closed

Capacitor

A-3

Size Verify three-phase size, KVAR marking, or not available

Number Number of individual units Phase ABC Size 450 KVAR, Other

Regulator

Source side circuit identifier Circuit Name Number Number of regulators at location Phase ABC Size 167, 250, 333 KVA

Recloser

Number Number of reclosers at location Phase A, B, C, AB, AC, BC, ABC Size 50, 70, 100, 140, 225, 280 AMP

Trip Saver Multiple taps on one pole possible

Number Number of Trip Savers on tap Phase A, B, C, AB, AC, BC, ABC Size 100, 200

Overhead Fuse

Multiple records per pole possible

Station Number Source side circuit identifier Circuit Name Fuse Size Bartow fuse tag or Not Available

Phasing A, B, C, AB, AC, BC, ABC

Arrester

Source side circuit identifier Circuit Name Number Number of arresters at location Phase A, B, C, AB, AC, BC, ABC Type Porcelain or Polymer

OH to UG Transition

Underground Risers

Phase A, B, C, AB, AC, BC, ABC Source side circuit identifier

Electric Service OH

A-4

Meter # Source Transformer Station Number X-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Y-coordinate Via High Accuracy GPS — NAD 1983 State Plane Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Electric Service

UGD

Meter # Source Transformer Station Number X-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Y-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Un-Metered

Service

Location Via High Accuracy GPS — NAD 1983 State Plane

Decimal Degrees accepted as alternate submission

Type Sign, light, traffic signal, other

Single Phase Pad

Station Number Bartow asset number Phase Field Information or from Bartow Subdivision Maps or Not Available. A, B, C, AB, AC, BC, ABC KVA Marking KVA Marking in field, from maps or Not Available Transformer ID Bartow Asset number from field or Not Available X-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Y-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Two Unit

Station Number Phase (1st transformer) A, B, or C KVA Marking (1st transformer) KVA Marking or No Marking Transformer ID Number (1st transformer) Verify and update Bartow asset number #### Phase (2nd transformer – if any) A, B, or C

A-5

KVA Marking (2nd transformer – if any) KVA Marking or No Marking Transformer ID Number Verify and update Bartow asset number ####

X-coordinate Via High Accuracy GPS — NAD 1983 State Plane Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Y-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Three Phase

Phase Field Information or from Bartow Subdivision

Maps., ABC KVA Marking KVA Marking in field, from maps or Not Available Transformer ID Bartow Asset number from field or Not Available X-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Y-coordinate Via High Accuracy GPS — NAD 1983 State Plane

A-6

Switch Cabinet

Pad- Mounted

Phase Field Information or from Bartow Subdivision Maps.

A, B, C, AB, AC, BC, ABC

Type PME 9, PME 6, Fuse. From Bartow underground subdivision maps.

X-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Y-coordinate Via High Accuracy GPS — NAD 1983 State Plane

UGD

Terminating Cabinet

Phase Field Information or from Bartow Subdivision Maps.

A, B, C, AB, AC, BC, ABC

X-coordinate Via High Accuracy GPS — NAD 1983 State Plane

Florida West FIPS 0902 (US Feet); WGS 1984 Decimal Degrees accepted as alternate submission

Y-coordinate Via High Accuracy GPS — NAD 1983 State Plane

A-1

Appendix B

Acceptance Criteria and QA/QC Procedures

A set of acceptance criteria will be established to allow both the contractor and Bartow to objectively identify when delivered products are accepted. There are both manual and automated processes that will be necessary to follow to assure that the products meet the specifications.

1. The contractor is responsible for achieving a 98.0% accuracy rate for the capture of required feature elements as defined in the scope of work. Accuracy is defined as the existence, completeness and placement (state plane coordinates) of the geographic features or data. The contractor is responsible for achieving a positional accuracy of 0.3 meters (sub-foot) for the placement of all geographic features. If more than 2.0% of the geographic features are in error, the contractor shall be responsible for correcting the errors identified by Bartow. If fewer than 2.0% of the geographic features are in error, then Bartow shall be responsible for correcting those errors in house.

2. The contractor is responsible for achieving a 98.0% accuracy rate for the capture of required feature attribute data. Accuracy is defined as the existence and completeness associated with the geographic feature(s). If more than 2.0% of the attribute data is in error, the contractor shall be responsible for correcting the errors identified by OEU. If fewer than 2.0% of the annotation is in error, then Bartow shall be responsible for correcting those errors in house.

Quality Assurance Project Plan (QAPP)

1. A complete check will be done for the first deliveries to confirm that the contractor is doing the work correctly.

A complete feature check will allow Bartow to confirm that the ESRI feature classes and geodatabase contain all of the required features (98%). The goal is to reach a level of confidence in the contractor's work so that a sample check can be used to check the remainder of the coverage.

Bartow will select a random sample of the features to field validate. This sample will be compared to the data submitted by the contractor.

2. A sample check will be done on subsequent submissions until a delivery falls below the acceptable level of accuracy. At this point a complete check is performed on the current delivery. This is to confirm that the problem is isolated to this delivery and not a decline in quality or the introduction of a systematic problem in the contractor's process. The problem could be caused by a change in personnel, corrupt software or lack of attention.

3. The contractor is responsible for achieving a 100.0% accuracy rate for ESRI feature classes and geodatabase complying with the database design specifications. This criteria defines the structure of the feature classes and geodatabase.

Database checks will use scripts to check for the following criteria:

Criteria QA/QC Check Script None of the features that are defined in the database design as having a database record will be missing a database record.

Use an ESRI system script to compare features with records.

Features must correspond to their specific database record.

Use ESRI systems to check features are linked to correct record.

Attributes are populated with legal value ranges. Use frequency analysis and compare field values against valid lookup table codes. ESRI feature class domains may be applied to enforce legal values at

A-2 the field level and prevent invalid entries during data collection.

Database fields will be defined per the database design.

Run script on the database to check definitions.

The number of database fields will match the database design.

Run script on the database to check definitions.

Look up tables are linked to the correct tables and fields.

Use ArcGIS Pro scripts to verify lookup table linkages and confirm related tables contain a unique identifier field in both the feature class and related table. ESRI feature class domains provide an additional enforcement layer to ensure only valid values are used in designated fields.

4. The contractor is responsible for achieving a 98.0% accuracy rate for the capture of the required database attributes when compared to the requirements. If more than 2.0% of the database attributes are in error, the contractor shall be responsible for correcting the errors identified by Bartow. If fewer than 2.0% of the database attributes are in error, then Bartow shall be responsible for correcting those errors in house.

This criteria is dependent on the quality and completeness of Bartow 's source documents. QA/QC checks for criteria #3 will confirm that the definition of the field is correct. The Owner will check that the data in the fields is correct by comparing the original source with the deliverable. A sample check will need to be made to confirm that the attribute data is correct. The volume of data will not allow a complete check of the data in each field for each record.

Confirmation Plots and Digital Files If redelivery by the contractor is needed, then the contractor is responsible for achieving a 99.0% accuracy rate for correcting true errors identified by Bartow. Errors identified by Bartow that are subjective (interpretive) and/or are due to source errors will not be subjected to or considered in the acceptance rating.

Other Acceptance Criteria Errors generated by the contractor due to conflicts that exist between source document(s) will not be subjected to or considered in the acceptance rating. This excludes conflicts that were resolved between the contractor and Bartow via problem/action reports or any other documented method.

The use of problem / action reports used to identify and resolve problems shall be at the sole discretion of the contractor. Responses are due within 48 hours (two business days) of receiving the problem / action report.

Non-responses to problem / action reports will not be subjected to or considered in the acceptance rating.

Any errors contained within Bartow supplied data/documents, or any errors caused by Bartow supplied data/documents not specifically identified as being within the scope of work to find and correct, will not be subjected to or considered in the acceptance rating.

Anomalies which the contractor cannot resolve shall be brought to the attention of Bartow and will not be subjected to or considered in the acceptance rating, regardless of whether they are flagged.

The contractor is not responsible for "errors" generated due to proposed/pending change orders and these

"errors" will not be subjected to or considered in the acceptance rating. Change orders must be agreed to by both the contractor and Bartow and formally documented for a change order to be implemented in the conversion process. Approved change orders do not affect the error calculation formulas and specifications until 30 days after execution.

C-1

Appendix C

Source Materials

All source materials are provided in digital format.

Bartow System:

1. Digital file of Polk County Landbase with Bartow service territory, Bartow city limits and map grid overlay

2. Digital files of subdivision maps.

LEGACY PAPER RECORDS

Subdivision Maps

We have a mixture of paper and digital maps of underground subdivisions showing conductor size and phases, transformer and vault locations and phasing, and secondary vaults and conductor. Most underground facilities are labeled in the field with identification numbers and phasing that corresponds to the subdivision maps.

INCODE DATABASES

METER MASTER FILE (AS400)

(EMINQUIRE)

Each electric meter location is given a nine-digit assigned account number that stays with that location.

The first seven digits remain the same, the last two digits will change as new tenants move into a location.

Meter numbers are recorded for each account.

Identified Data:

Meter Number, Current Account Number, Customer Address (billing address), Customer Address (used to identify true location), Serial Number for Meter – identified on meter can, stock number (type of meter), number of phases, Date set, date removed, rotation (rotation of phases for three-phase customer)

VERSATERM FILE

Electric Meter File for monthly readings used by CSO meter readers.

Identified data:

Date (set, remove, change) Account #, UBO Address (for customer), demand type, KVA, KW, billing code, miscellaneous, meter #, reading, demand, multiplier, and remarks (ex. Big dog)

C-1

Appendix D

Estimated Bartow Facility Quantities*

Overhead System Bartow Poles** 13,359 Overhead Transformers 2,208 Streetlights 5,278 Yard Lights Included in

Streetlight Trip Savers 82 Lateral Fuses 2,616 Reclosers 10 estimated Capacitors 5 Switches 152 Meters 13,600 Overhead to Underground Transitions 300 estimated

Underground System Pad Mounted Transformers 1,372

* All numbers are approximate ** Includes light poles.

E-1

Appendix E

Bid Items

Per unit prices will be given for the following items:

1. Pole, including all attachments and equipment as shown in Appendix A. Circuit configuration, either Horizontal or Vertical, will be identified at each pole.

2. Poles without asset id will be tagged.

3. Service Location, including all attribute data as defined in Appendix A for both metered and un-metered services. Source transformer for all service locations will be identified.

4. Underground Facilities including all attribute data in Appendix A for pad mounted transformers, termination cabinets and switch cabinets.

5. Phasing for all primary conductors.

6. Phases will be tagged at phase rolls, switches, underground risers, fuses, trip savers and reclosers.

7. Photo of each pole showing all equipment.