ATT_T__-_Electrical_GIS_SOP.pdf

STANDING OPERATING Directorate of Public Works

PROCEDURES 1Il Corps and Fort Hood, TX

NO. QAOOI Fort Hood, TX 76544-5028

Electrical Geographic Information System

1. PURPOSE: To outline the responsibilities for collecting, updating, and maintaining data required for key electrical point of interest in electric distribution system.

2. OBJECTIVE:

a. To keep GIS electrical data Spatial Data Standards for Facilities, Infrastructure, and Environment (SDSFIE) compliant, accurate, and up to date to allow for inventory tracking and modeling purpose.

b. To provide worksheets and responsibilities for collecting data to be in stored in GIS SDSFIE tables.

3. APPLICABILITY: This Standard Operating Procedure (SOP) is applicable to Contractors, Contracting Officer Representatives (COR), Engineering & Services Division, and any and all entities making changes or additions to Fort Hood's electrical distribution system. The SOP applies to all facilities. Directorate ofPublic Works (DPW) Engineering has oversight of all contracts and work being executed that impacts the electric distribution system.

4. RESPONSIBILITY:

on all key electrical points of interest after installation.

11. All data shall be gathered for existing, altered, and new electrical points of interest.

lll. Shall verify all existing worksheet data provided by the government.

turned- in. Applicable information and identified procedures by Government shall be included on as-built drawings.

VI. All worksheets and other required information shall be turned-in to Electrical Champion through COR or Government Project Manager.

VII. Install labels on point of interests.

B. Government Project Manager Responsibilities

1. Shall provide ID for all new and replacements electrical points.

11. Shall provide current data on all existing electrical points.

1l1. Shall identify all new electrical points of interests.

additions, made to system via emaiL

Attachment T - Electrical GIS SOP For Bidding Purposes Only

ATT T - 1 02.01.2016

STANDING OPERATING Directorate of Public Works PROCEDURES III Corps and Fort Hood, TX NO. QA 001 Fort Hood, TX 76544-5028

11. Shall complete worksheets with basic data (model, manufacture, KV A, type, wattage, date of installation, describe of repair, class, height) on all repairs, new installations, and modifications made to system and turn worksheets in to Electrical Champion via email.

interest and turn worksheets in to Electrical Champion.

D. Government Electrical Champion responsibilities

1. Shall assign ID's to all points of interest.

government Maintenance shop.

v. Shall be technical adviser for all worksheets

5. ELECTRICAL POINTS OF INTEREST:

6. ATTACHMENTS

Worksheet for Regulators

H. Worksheet for Risers

L Worksheet for Man Holes

It.( 0~l ~

M~

ROBERT D. ERWIN

Chief, Engineering and Services Division

Attachment T - Electrical GIS SOP

ATT T - 2 02.01.2016

SOP NO. QA 001 - Attachment 6.A.

Capacitor Banks Worksheet (For new and existing capacitor banks)

Contractor shall fill in the following data on all capacitors on project

1. Capacitor ID ________________________

2. Disposition ________________________

3. Type of Installation ________________________

4. Switch ________________________

5. Voltage ________________________

6. Capacitor KV rating ________________________

7. Unit of Measure for Capacitor ________________________

8. Letter phase Connected ________________________

9. Number of Phases ________________________

10. Control Type ________________________

11. Manufacture ________________________

12. Model Number ________________________

13. Grid Value ________________________

14. Coordinate X ________________________

15. Coordinate Y ________________________

16. Coordinate Z ________________________

17. Substation ID ________________________

18. Facility ID ________________________

19. Date of Installation ________________________

20. Narrative ________________________

Attachment T - Electrical GIS SOP

ATT T - 3 02.01.2016

SOP NO. QA 001 - Attachment 6.A.

Instructions for Capacitor Banks Worksheet (For new and existing capacitor banks)

1. Capacitor ID – First digits will reference 1 to 100 gird Fort Hood ID. Followed by CB000#. The capacitor bank ID shall be assigned by Project Manager of the project.

2. Disposition – The status of the subject item (e.g., permanent, temporary, proposed, abandoned, etc.), from lists or entered from field inspections.

3. Type of Installation - The type installation of the subject item.

4. Switch - This indicates whether the capacitor is presently in the circuit or is not presently in the circuit.

5. Voltage - The system voltage across the capacitor.

6. Capacitor KV Rating - The rating of the capacitor's ability to provide reactive power to a circuit.

7. Unit of Measure for Capacitor - The unit of measure for the electrical capacitor.

8. Letter phase Connected - The letter(s) of the phase(s) for the subject item.

9. Number of Phases - The number of phases to which this device provides reactive power.

10. Control Type - The method of adjusting the kilovar output of the capacitor.

11. Manufacture - The name of the manufacture.

12. Model Number - The Model, Product, Catalog, or Item Number of subject item.

13. Grid Value – Grid number based on one to 100 grid system.

14. Coordinate X - The x component of individual coordinate point.

15. Coordinate Y - The y component of individual coordinate point.

16. Coordinate Z - The z component of individual coordinate point.

17. Substation ID - An operator generated identifier locally used to identify the substation feeding this bus group. MF – Main Fort Hood Substation, WF – West Fort Hood Substation, CR- Clark Road Substation, NF – North Fort Hood Substation

18. Facility ID – Facility the it may be associated with

19. Date of Installation – The date on which the subject item was installed. Format for date is

YYYYMMDD

20. Narrative – A description or other unique information concerning the subject item, limited to 240 characters.

ATT T - 4 02.01.2016

SOP NO. QA 001 - Attachment 6.B.

Exterior Lights Worksheet (For new and existing Exterior Lights)

Contractor shall fill in the following data on all Exterior Lights detached from the building on project

1. Exterior Light ID ________________________

2. Light Type ________________________

3. Number of Lamps ________________________

4. Watts ________________________

5. Voltage ________________________

6. Pole ID attached ________________________

7. Grid Value ________________________

8. Coordinate X ________________________

9. Coordinate Y ________________________

10. Coordinate Z ________________________

11. Mounted Height ________________________

12. Date of Installation ________________________

13. Narrative ________________________

ATT T - 5 02.01.2016

SOP NO. QA 001 - Attachment 6.B.

Instructions for Exterior Lights Worksheet (For new and existing Exterior Lights)

1. Exterior Light ID – First digits will reference 1 to 100 grid Fort Hood ID. Followed by LE1000#.

Each ID shall be assigned by Project Manager of the project.

2. Light Type - Various kinds of mounts for external lights – LED, MH, LPS

3. Number of Lamps - The total number of lamps in fixture.

4. Watts - The light fixture wattage specification.

5. Voltage - The system voltage applied to the light fixture.

6. Pole ID – Pole ID Light attached to, if applicable

7. Grid Value - A numeric identification of a raster element in an image or grid that represents the feature.

8. Coordinate X - The x component of individual coordinate point. Format (WGS_1984_UTM_Zone 14N)

9. Coordinate Y - The y component of individual coordinate point. Format (WGS_1984_UTM_Zone 14N)

10. Coordinate z - The z component of individual coordinate point. Format (WGS_1984_UTM_Zone 14N)

11. Mount Height - The fixture mounting height in feet

12. Date of Installation – The date on which the subject item was installed. Format for date is

YYYYMMDD

13. Narrative – additional info on light

ATT T - 6 02.01.2016

SOP NO. QA 001 - Attachment 6.C.

Meter Worksheet (For new and existing meters)

Contractor shall fill in the following data on all meters on project

1. Meter ID ________________________

3. Manufacture ________________________

4. Model ________________________

5. Meter Type ________________________

6. Watt Node Meter ________________________

7. Serial Number ________________________

8. Voltage ________________________

9. Capacity of KVA ________________________

10. Frequency of system ________________________

11. KW Rate ________________________

12. Facility Number ________________________

13. AMP Rate ________________________

14. Multiplication Factor ________________________

15. Number of phase ________________________

16. Phases ________________________

17. Grid Value ________________________

18. Coordinate X ________________________

19. Coordinate Y ________________________

20. Coordinate Z ________________________

21. Narrative ________________________

ATT T - 7 02.01.2016

Instructions for Meter Worksheet (For new and existing meters)

1. Meter ID – First digits will reference 1 to 100 grid Fort Hood ID. Followed by MR000# each meter number shall be assigned by Project Manager of the project.

2. Disposition – The status of the subject item (e.g., permanent, temporary, proposed, abandoned, etc.), from lists or entered from field inspections.

3. Manufacture - Manufacture name

4. Model - The Model, Product, Catalog, or Item Number of subject item.

5. Meter Type - A label describing the features of the electrical system that the meter is measuring.

6. Watt Node Meter – Is Watt node meter part of the system. yes/ no

7. Serial Number - The manufacturer's serial or unique identification number of the subject item.

8. Voltage - The potential of the electrical system on which the meter may be used.

9. Capacity of KVA - The limit of the complex power which the demand meter can record.

10. Frequency of system - The frequency of the electrical system on which the meter should be used.

11. KW Rate - The power rating on the meter based on the current and potential transformer ratios.

12. Facility Number – Facility Meter is measuring service

13. AMP rate - The maximum continuous current rating of the meter.

14. Multiplication Factor - The multiplication factor by which one must multiply the difference in present and previous meter readings to determine actual power consumed.

15. Number of phase - The number of phases that the meter monitors.

16. Phases - The letter(s) of the phase(s) for the subject item.

17. Grid Value - Grid number based on one to 100 grid system for Fort Hood

18. Coordinate X - The x component of individual coordinate point. Format (WGS_1984_

UTM_Zone14N)

19. Coordinate Y - The Y component of individual coordinate point. Format (WGS_1984_

UTM_Zone14N)

ATT T - 8 02.01.2016

20. Coordinate Z - The Z component of individual coordinate point. Format (WGS_1984_ UTM_Zone14N)

21. Narrative - A description or other unique information concerning the subject item.

ATT T - 9 02.01.2016

SOP NO. QA 001 - Attachment 6.D.

Pole Worksheet (For new and existing poles)

Contractor shall fill in the following data on all poles on project

1. Pole (User) ID ________________________

2. Pole Height ________________________

3. Class of Pole ________________________

4. Type of Pole ________________________

5. Material Composition ________________________

6. Treatment Type ________________________

7. Grid Value ________________________

8. Coordinate X ________________________

9. Coordinate Y ________________________

10. Coordinate Z ________________________

11. Date Acquired ________________________

12. Date Treated ________________________

13. Manufacture ________________________

14. Grounded ________________________

15. Condition ________________________

16. Capped ________________________

17. Narrative ________________________

ATT T - 10 02.01.2016

SOP NO. QA 001 - Attachment 6.D.

Instructions for Pole Worksheet (For new and existing poles)

1. Pole (User) ID - A unique, user defined identifier for each record or instance of an entity. Shall be given by DPW Project Manager.

2. Pole Height – The height of the pole measured from the ground surface to the top. (ft)

3. Class of pole - A classification of the pole diameter, and consequently the breaking strength, of wooden poles.

4. Type of Pole – A field indicating the kind, class, or group of the subject item.

5. Material Composition - The material composition of the subject item, such as wood, concrete, steel, cast iron, plastic, etc to include type of wood.

6. Treatment Type - Defines any treatment applied to the pole to improve its life.

7. Grid Value – Based on Fort Hoods 1 to 100 Grid system

8. Coordinate X - The x component of individual coordinate point. Format

(WGS_1984_UTM_ZONE14N)

9. Coordinate Y - The y component of individual coordinate point. Format

10. Coordinate Z - The z component of individual coordinate point. Format

11. Date Acquired - The date on which the subject item was installed. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

12. Date Treated - The date that the pole was last treated/ born on date. Format for date is YYYYMMDD (i.e. September 15, 1994 = 19940915).

13. Manufacture – Name of manufacture

14. Grounded - An indicator as to whether or not the pole is grounded. (yes or no)

15. Condition - Indicates a state of being, or readiness for use of the subject item (e.g., good, fair, poor), from lists or field inspections.

16. Capped - Indicates whether or not the pole is capped (yes/no).

17. Narrative - A description or other unique information concerning the subject item, limited to 240

ATT T - 11 02.01.2016

SOP NO. QA 001 - Attachment 6.E.

Regulator Worksheet (For new and existing regulators)

Contractor shall fill in the following data on all regulators on the project

1. Regulator ID ________________________

3. Regulator Type ________________________

4. Regulator Usage ________________________

5. Installation Type _________________________

6. Regulator Weigh ________________________

7. Phase Letters ________________________

8. Number of Phases ________________________

9. Primary Voltage ________________________

10. Percentage of tap ________________________

11. Number of Taps ________________________

12. KVA Rating ________________________

13. Fuse Type ________________________

14. Fuse Rating ________________________

15. Cooling Type ________________________

16. Oil Capacity ________________________

17. Manufacture ________________________

18. Model Number ________________________

19. Serial Number ________________________

20. Narrative ________________________

21. Substation ID _________________________

ATT T - 12 02.01.2016

Regulator Worksheet – cont.

22. Secondary Voltage _________________________

23. Date of Manufacture _________________________

24. Grid Value _________________________

25. Coordinate X _________________________

26. Coordinate Y _________________________

27. Coordinate Z _________________________

28. Date installed/inspected _________________________

ATT T - 13 02.01.2016

Instructions for Regulator Worksheet

1. Regulator ID – First digits will reference 1 to 100 grid Fort Hood ID. Followed by R10# Each

Regulator ID shall be assigned by Project Manager of the project.

Abandoned Permanent Temporary

3. Regulator type - The type of voltage regulator.

4. Regulator Usage - An indication of whether the regulator is on a line or in a substation.

5. Installation type - The type installation of the subject item.

6. Regulator Weight - The force of the regulator toward the center of the earth due to the regulator's mass. (lbs)

7. Phase Letters - The letter(s) of the phase(s) for the subject item.

8. Number of phases - The number of phases regulated by this device.

9. Primary Voltage - The voltage on the source side of the regulator with the associated units given.

10. Percentage of Tap - The percentage of the voltage that will be changed by moving the connection up or down one tap.

11. Number of Taps - The number of available points of connection on the regulator which may be used to change the voltage.

12. KVA Rating - The maximum continuous complex power rating of the regulator.

13. Fuse Type - A label chosen from a standard list of labels describing the characteristics of the fuse.

14. Fuse Rating - The current rating of the fuse protecting the regulator. This will be on the primary side.

15. Cooling Type - The method of controlling the temperature of the regulator.

16. Oil Capacity - The manufacturer suggested volume of oil that should be maintained inside the regulator to assure safe and efficient operation. (gallon)

17. Manufacture – Name of the manufacture

18. Model Number - The Model, Product, Catalog, or Item Number of subject item.

19. Serial Number - The manufacturer's serial or unique identification number of the subject item.

20. Narrative - A description or other unique information concerning the subject item, limited to 240

ATT T - 14 02.01.2016

21. Substation ID - Substation ID - An operator generated identifier locally used to identify the substation feeding this bus group. MF – Main Fort Hood Substation, WF – West Fort Hood Substation, CR- Clark Road Substation, NF – North Fort Hood Substation

22. Secondary voltage - The voltage on the load side of the regulator with the associated units given.

23. Date of Manufacture - The date of manufacturer for the subject item. Format for date is

YYYYMMDD (i.e., September 15, 1994 = 19940915)

24. Grid Value - Grid number based on one to 100 grid system for Fort Hood

25. Coordinate X - The x component of individual coordinate point.

26. Coordinate Y - The y component of individual coordinate point.

27. Coordinate Z - Height

ATT T - 15 02.01.2016

SOP NO. QA 001 – Attachment 6.F.

Switch Worksheet (For new and existing switches)

Contractor shall fill in the following data on switches on project

1. Switch ID ________________________

3. Installation Type ________________________

4. Switch Type ________________________

5. Switch Rating ________________________

6. Voltage ________________________

7. Number of Switches ________________________

8. Number of Phases ________________________

9. Phase Letter ________________________

10. Serial numbers ________________________

11. Switch Position Condition ________________________

12. Switch Weight ________________________

13. Switch Dimension ________________________

14. Substation ID ________________________

15. Manufacture ID ________________________

16. Circuit ID ________________________

17. Grid Value ________________________

18. Coordinate X ________________________

19. Coordinate Y ________________________

20. Coordinate Z ________________________

21. Narrative ________________________

ATT T - 16 02.01.2016

Instructions for Switch Worksheet

1. Switch ID – First digits will reference 1 to 100 grid Fort Hood ID. Followed by SW10# each switch shall be assigned by Project Manager of the project.

3. Installation Type - The installation type code.

Circuit breaker Cubicle Fuse Cutout Gang Operated disconnect Pad Mounted Pole Mounted Recloser

4. Switch Type - A label chosen from a standard list of labels indicating the characteristics of a switch.

5. Switch Rating - The maximum continuous amount of current to which the switch should be subjected.

6. Voltage - The system voltage of the electrical line at the point in which the switch is inserted.

7. Number of Switches - The number of phases opened by the switch

8. Number of Phases - The number of phases opened by the switch

9. Phase letter - The letter(s) of the phase(s) for the subject item.

10. Serial Number - The manufacturer's serial, or unique identification number of the subject item.

11. Switch Position Condition - The positional condition of a switch during normal circuit conditions (e.g., normally-open, normally closed).

12. Switch Weight - The force of the switch toward the center of the earth due to the switch's mass.

13. Switch Dimension - A three dimensional description of the amount of space which a switch occupies (e.g., 2’ x 1’ x 4”).

14. Substation ID - An operator generated identifier locally used to identify the substation feeding this

Substation, NF – North Fort Hood Substation.

15. Manufacture ID – Manufacture name

16. Circuit ID – Feeder number switch is connected to

17. Grid Value - Grid number based on one to 100 grid system for Fort Hood

18. Coordinate X - The x component of individual GPS coordinate point.

ATT T - 17 02.01.2016

Instructions for Switch Worksheet-cont.

19. Coordinate Y - The Y component of individual GPS coordinate point.

20. Coordinate Z - The Z component of individual GPS coordinate point.

21. Narrative - A description or other unique information concerning the subject item, limited to 240

ATT T - 18 02.01.2016

SOP NO. QA 001 - Attachment 6.G.

Transformer and Transformer Bank Worksheet (For new and existing transformers)

Contractor shall fill in the following data on all transformers on project

1. Transformer ID ________________________

3. Type of Mounting (pole or pad mount) ________________________

4. Primary Voltage ________________________

5. Secondary Voltage ________________________

6. Number of Transformers ________________________

7. Number of Phases ________________________

8. KVA transformer ________________________

9. Total KVA (if banked or 30 pad mount) ________________________

10. Substation ID (Main, Clark, WFH, NFH) ________________________

11. Date of Installation ________________________

12. Date of Inspection ________________________

13. Condition (Red, Amber, Green) ________________________

14. Feeder Number ________________________

15. Grid Value ________________________

16. Coordinate X ________________________

17. Coordinate Y ________________________

18. Coordinate Z ________________________

19. Narrative ________________________

ATT T - 19 02.01.2016

Instructions for Transformer and Transformer Bank Worksheet

(For new and existing transformers)

1. Transformer ID – First digits will reference 1 to 100 grid Fort Hood ID. Followed by T10# for pad mounted transformer bank and T20# for a pole mounted transformer bank. Each transformer bank ID shall be assigned by Project Manager of the project.

Abandoned Permanent Temporary

3. Type of mounting - The type of mounting for the transformer bank.

Pole mounted Pad mounted Wall mounted Ceiling mounted

4. Primary Voltage - The line-to-line voltage of the electrical system that serves as the source for the transformer bank.

5. Secondary Voltage - The line-to-line voltage of the electrical system that the transformer bank serves.

6. Number of Transformers - The number of transformers in the transformer bank.

7. Total number of Phases - The number of phases of transformer group.

8. KVA - The capacity of each transformer in a group. (i.e. 2-50kva / 1-25kva, 50 is the capacity of each transformer in the first group - 25 is the capacity of each transformer in the second group.)

There can be no more than two groups in a bank.

9. Total KVA - The total KVA rate for all transformers attached to the transformer bank.

10. Substation ID - An operator generated identifier locally used to identify the substation feeding this

Substation, NF – North Fort Hood Substation

11. Date of installation - The date on which the subject item was originally installed. Format for date is

YYYYMMDD (i.e., September 15, 1994 = 19940915).

12. Date of Inspection – The last visual inspection date of the subject item. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915)

13. Condition - The condition of the subject item when last inspected (Red, Amber, Green).

14. Feeder Number - An operator generated identifier locally used to identify the feeder to the transformer bank.

15. Grid Value – Grid number based on one to 100 grid system.

Attachment T - Electrical GIS SOP

ATT T - 20 02.01.2016

Instructions for Transformer and Transformer Bank Worksheet – cont.

(For new and existing transformers)

16. Coordinate X - The x component of individual GPS coordinate point.

17. Coordinate Y - The y component of individual GPS coordinate point.

18. Coordinate Z - The z component of individual GPS coordinate point.

19. Narrative - A description or other unique information concerning the subject item to include manufacture, model number and serial numbers.

ATT T - 21 02.01.2016

SOP NO. QA 001 – Attachment 6.H.

Riser Worksheet (For new and existing risers)

Contractor shall fill in the following data on all risers on the project

1. Riser ID ________________________

2. Narrative ________________________

3. Pole ID ________________________

4. Grid ID ________________________

5. Coordinate X ________________________

6. Coordinate Y ________________________

7. Coordinate Z ________________________

8. Voltage ________________________

9. Date of Installation ________________________

10. Length of Riser ________________________

11. Spare ________________________

12. Conductor size, number and type ________________________

ATT T - 22 02.01.2016

SOP NO. QA 001 – Attachment 6.H.

Instructions for Riser Worksheet (For new and existing risers)

1. Riser ID – First digits will reference 1 to 100 grid Fort Hood ID. Followed by RP#### Riser ID shall be assigned by Project Manager of the project.

2. Narrative - A description or other unique information concerning the subject item, limited to 240 characters. Required will be size of conduit and conductor wire.

3. Pole ID – Pole ID that riser is attached to

4. Grid ID - Grid number based on one to 100 grid system for Fort Hood

5. Coordinate X - The x component of individual coordinate point.

6. Coordinate Y - The y component of individual coordinate point.

7. Coordinate Z - The z component of individual coordinate point.

8. Voltage - The voltage associated with the riser.

9. Date of Installation - The date of Installation for the subject item. Format for date is YYYYMMDD

(i.e., September 15, 1994 = 19940915)

ATT T - 23 02.01.2016

SOP NO. QA 001 - Attachment 6.I.

Manholes / Hand holes Worksheet (For new and existing manholes/hand holes)

Contractor shall fill in the following data on all manholes and hand holes on the project

1. Type ________________________

2. Material Type ________________________

3. Disposition ________________________

4. Narrative ________________________

5. Grid ID ________________________

6. Coordinate X ________________________

7. Coordinate Y ________________________

8. Coordinate Z ________________________

9. Manufacture ________________________

10. Manhole Diameter ________________________

11. Number Cables ________________________

12. Date of Installation _________________________

ATT T - 24 02.01.2016

SOP NO. QA 001 - Attachment 6.I.

Instructions for Manholes/Hand holes Worksheet (For new and existing manholes/hand holes)

1. Type – A field indicating the kind, class, or group of manhole for the subject utility. Hand hole or Manhole

2. Material type - The material composition of the subject item, such as wood, concrete, steel, cast iron, plastic, etc

3. Disposition - The status of the subject item (e.g., permanent, temporary, proposed, abandoned, etc.), from lists or entered from field inspections.

4. Narrative - A description or other unique information concerning the subject item, limited to 240 characters. To include model number and dimensions.

5. Grid ID - Grid number based on one to 100 grid system for Fort Hood

6. Coordinate X - The x component of individual coordinate point.

7. Coordinate Y - The y component of individual coordinate point.

8. Coordinate Z - The z component of individual coordinate point.

9. Manufacture – Manufacture of Manhole

10. Manhole Diameter - The maximum linear distance measured horizontally across a manhole lid.

11. Number of Cables - A number representing the total number of cables in the manhole. A cable passing through the manhole counts as one cable and a cable tying into another cable inside the manhole counts as one cable

12. Date of Installation - The date of Installation for the subject item. Format for date is YYYYMMDD

(i.e., September 15, 1994 = 19940915)

ATT T - 25 02.01.2016