Name: Electric Device

Display Field: subnetworkcontrollername

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 535696.266683511
YMin: 1580909.97633253
XMax: 1233037.65513443
YMax: 2159729.54900603
Spatial Reference: 102671 (3435)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[120,120,120,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""}}

HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: GlobalID_2

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• assetgroup (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
• assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true)
• associationstatus (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 18 more ...)
• issubnetworkcontroller (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• isconnected (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
• subnetworkcontrollername (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• tiername (type: esriFieldTypeInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Electric Generation Station], [2: Electric Transmission], ... 6 more ...)
• tierrank (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: false, editable: true)
• terminalconfiguration (type: esriFieldTypeString, alias: terminalconfiguration: Terminal Configuration, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: true)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• globalid (type: esriFieldTypeGUID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)
• subnetworkname (type: esriFieldTypeString, alias: Subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• assetid (type: esriFieldTypeString, alias: assetid: Asset Identifier, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• plandevicestatus (type: esriFieldTypeSmallInteger, alias: plandevicestatus: Planning Device Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Open], [2: Closed], ... 2 more ...)
• normaldevicestatus (type: esriFieldTypeSmallInteger, alias: normaldevicestatus: Normal Device Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Open], [2: Closed], ... 2 more ...)
• currentdevicestatus (type: esriFieldTypeSmallInteger, alias: currentdevicestatus: Devices Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Open], [2: Closed], ... 2 more ...)
• winterdevicestatus (type: esriFieldTypeSmallInteger, alias: winterdevicestatus: Winter State, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Open], [2: Closed], ... 2 more ...)
• summerdevicestatus (type: esriFieldTypeSmallInteger, alias: summerdevicestatus: Summer State, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Open], [2: Closed], ... 2 more ...)
• phasesnormal (type: esriFieldTypeSmallInteger, alias: phasesnormal: Phases Normal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DeEnergized], [1: C], [2: B], ... 5 more ...)
• phasescurrent (type: esriFieldTypeSmallInteger, alias: phasescurrent: User Assigned Phases, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DeEnergized], [1: C], [2: B], ... 5 more ...)
• phasessummer (type: esriFieldTypeSmallInteger, alias: phasessummer: Summer Configuration Phases, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DeEnergized], [1: C], [2: B], ... 5 more ...)
• phaseswinter (type: esriFieldTypeSmallInteger, alias: phaseswinter: Winter Configuration Phases, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DeEnergized], [1: C], [2: B], ... 5 more ...)
• phasesplan (type: esriFieldTypeSmallInteger, alias: phasesplan: Planned Phases, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DeEnergized], [1: C], [2: B], ... 5 more ...)
• phasesenergized (type: esriFieldTypeSmallInteger, alias: phasesenergized: Phases Propagated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DeEnergized], [1: C], [2: B], ... 5 more ...)
• phasessubstituted (type: esriFieldTypeInteger, alias: phasessubstituted: Phases Substituted, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: De-energized], [1: AB --> DD], [2: ABC --> BDD], ... 31 more ...)
• phasefrequency (type: esriFieldTypeSmallInteger, alias: phasefrequency: Phase Frequency, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [50: 50 hz], [60: 60 hz])
• numphasesconstructed (type: esriFieldTypeSmallInteger, alias: numphasesconstructed: Number of phases built, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 3])
• designtype (type: esriFieldTypeSmallInteger, alias: designtype: Fuel Type, Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• grounding (type: esriFieldTypeSmallInteger, alias: grounding: Circuit Grounding or Earthing, Configuration - GY, Y or D, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Delta], [2: Wye])
• manufacturer (type: esriFieldTypeSmallInteger, alias: manufacturer: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: ABB/Westinghouse], [2: American Electric Lighting], ... 56 more ...)
• nominalvoltage (type: esriFieldTypeInteger, alias: nominalvoltage: Nominal Operation Voltage (L-L), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [208: 208 V], [240: 240 V], ... 32 more ...)
• powerrating (type: esriFieldTypeInteger, alias: powerrating: Average Load (kW), Continuous Amps Rating, Power Rating, Service Load (kW), kVA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• addpowerrating (type: esriFieldTypeInteger, alias: addpowerrating: Active Generation, DC Voltage Reference Setting, Discharge Voltage, KVAR, Rated Current, Rated DC Voltage, Rated KVA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• powermeasure (type: esriFieldTypeDouble, alias: powermeasure: Load Tap Changer Maximum Change (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• maxvoltage (type: esriFieldTypeInteger, alias: maxvoltage: Maximum Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [208: 208 V], [240: 240 V], ... 32 more ...)
• maxoperatingvoltage (type: esriFieldTypeInteger, alias: maxoperatingvoltage: Maximum Operating Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [208: 208 V], [240: 240 V], ... 32 more ...)
• compatibleunit (type: esriFieldTypeString, alias: compatibleunit: Compatible Unit Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• powerrating2 (type: esriFieldTypeInteger, alias: powerrating2: High Impulse Current, Maximum Interrupting Current, Nominal Rating, Rated Power, Rated kVA, VSC Rating, kW-Phase, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: lifecyclestatus: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 15 more ...)
• remotecontrol (type: esriFieldTypeSmallInteger, alias: remotecontrol: Device Remotely Controlled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: No], [2: All Phases], ... 1 more ...)
• model (type: esriFieldTypeString, alias: model: Device Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• loadtapchangermaximumchange (type: esriFieldTypeDouble, alias: loadtapchangermaximumchange: Load Tap Changer Maximum Change, SQL Type: sqlTypeOther, nullable: true, editable: true)
• loadtapchangerlowerbandwidth (type: esriFieldTypeDouble, alias: loadtapchangerlowerbandwidth: Load Tap Changer Lower Bandwidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maximumboost (type: esriFieldTypeDouble, alias: maximumboost: Maximum Boost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• z0psimpedance (type: esriFieldTypeDouble, alias: z0psimpedance: Sequence Impedance -Z0ps (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• z0xmimpedance (type: esriFieldTypeDouble, alias: z0xmimpedance: Sequence Impedance -Z0xm (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• z1psimpedance (type: esriFieldTypeDouble, alias: z1psimpedance: Sequence Impedance -Z1 (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• x0r0impedance (type: esriFieldTypeDouble, alias: x0r0impedance: Sequence Impedance -X0/R0pm, SQL Type: sqlTypeOther, nullable: true, editable: true)
• x1r1impedance (type: esriFieldTypeDouble, alias: x1r1impedance: Sequence Impedance -X1/R1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• z0pmimpedance (type: esriFieldTypeDouble, alias: z0pmimpedance: Sequence Impedance -Z0pm (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• primarygroundimpedance (type: esriFieldTypeDouble, alias: primarygroundimpedance: Primary Ground Impedance (ohms), Primary Ground Impedance Rg (ohms), SQL Type: sqlTypeOther, nullable: true, editable: true)
• gridsidecouplinginductance (type: esriFieldTypeDouble, alias: gridsidecouplinginductance: Grid Side Coupling Inductance (ohms), Primary Ground Impedance Rg (ohms), SQL Type: sqlTypeOther, nullable: true, editable: true)
• powerrating3 (type: esriFieldTypeInteger, alias: powerrating3: Amperage, CT Primary Rating, Rated Voltage (KV L-L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• powerrating4 (type: esriFieldTypeInteger, alias: powerrating4: No Load Losses W, Tuned Frequency, Zero Sequence Subtransient (R+X), SQL Type: sqlTypeOther, nullable: true, editable: true)
• powerrating5 (type: esriFieldTypeInteger, alias: longelectric3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• remotecontrollerindicator (type: esriFieldTypeSmallInteger, alias: Remote Control Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true)
• equipmentyype (type: esriFieldTypeSmallInteger, alias: equipmentyype: ANSI Group 2,3,4,5, Insulation Type (Liquid,Dry), Type, Type (kVA-PF, AMP-PF, kW-PF, kW-kVAR), Type of Data, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tripmode (type: esriFieldTypeSmallInteger, alias: tripmode: Single Phase Trip and Lockout, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tapsandpoles (type: esriFieldTypeSmallInteger, alias: tapsandpoles: Ground Material, Number of Taps, SQL Type: sqlTypeOther, nullable: true, editable: true)
• equipmentconfiguration3 (type: esriFieldTypeSmallInteger, alias: equipmentconfiguration3: Master Offset, Primary to Tertiary Phase Shift, SQL Type: sqlTypeOther, nullable: true, editable: true)
• equipmentconfiguration1 (type: esriFieldTypeSmallInteger, alias: equipmentconfiguration1: Fuse Type, Reverse Trips, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nominalvoltagelg (type: esriFieldTypeInteger, alias: nominalvoltagelg: Nominal Operation Voltage (L-G), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [120: 120 V], [277: 277 V], ... 9 more ...)
• directional (type: esriFieldTypeSmallInteger, alias: directional: Bi Directional, Reversible, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alternatevoltagelinetoline (type: esriFieldTypeInteger, alias: alternatevoltagelinetoline: Low Side Voltage (L-L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• alternatevoltagelinetoground (type: esriFieldTypeInteger, alias: alternatevoltagelinetoground: Low Side Voltage (L-G), SQL Type: sqlTypeOther, nullable: true, editable: true)
• electricdecimal1 (type: esriFieldTypeDouble, alias: electricdecimal1: Boost, CT Ratio, Capacitive Reactance (Ohms), Efficiency %, Grid Side coupling resistance, Maximum Boost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• electricdecimal2 (type: esriFieldTypeDouble, alias: electricdecimal2: Buck, Current Maximum Power Point (Impp), DC Capacitor, DC Voltage Control, Maximum Buck, SQL Type: sqlTypeOther, nullable: true, editable: true)
• equipmentconfiguration2 (type: esriFieldTypeSmallInteger, alias: equipmentconfiguration2: Primary to Secondary Phase Shift, Time Delay, Trip Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• electricdecimal3 (type: esriFieldTypeDouble, alias: electricdecimal3: Current Control, Fault Contribution, Inductance, Load Tap Changer Upper Bandwidth (%), PT Ratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
• electricdecimal4 (type: esriFieldTypeDouble, alias: electricdecimal4: Inductive Resistance, Power Factor, Primary Ground Impedance Xg (ohms), Reactive Power Control, SQL Type: sqlTypeOther, nullable: true, editable: true)
• electricdecimal5 (type: esriFieldTypeDouble, alias: electricdecimal5: Losses (kW/Phase), Losses (kW/phase), The tertiary base voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• electricdecimal6 (type: esriFieldTypeDouble, alias: electricdecimal6: Load Tap Changer Lower Bandwidth (%), Quality Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• peakload (type: esriFieldTypeInteger, alias: peakload: Peak Load, Peak Load (kW), SQL Type: sqlTypeOther, nullable: true, editable: true)
• offpeakload (type: esriFieldTypeInteger, alias: offpeakload: Load at Off Peak Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: district: District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: installdate: Date Installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: retireddate: Date Retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inservicedate (type: esriFieldTypeDate, alias: inservicedate: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• isvalidloop (type: esriFieldTypeSmallInteger, alias: isvalidloop: Is Loop Valid, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• spatialsource (type: esriFieldTypeSmallInteger, alias: spatialsource: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: spatialconfidence: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• ownedby (type: esriFieldTypeSmallInteger, alias: ownedby: Owned by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: maintby: Maintained by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• notes (type: esriFieldTypeString, alias: notes: General Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• symbolrotation (type: esriFieldTypeSmallInteger, alias: symbolrotation: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Electric Device
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• assettype: 0
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• maintby: 1
• ownedby: 1
• spatialconfidence: 0
• spatialsource: 0
• globalid: {00000000-0000-0000-0000-000000000000}
• subnetworkname: Unknown
• phasesenergized: 0
• numphasesconstructed: 0
• grounding: 0
• nominalvoltage: 0
• maxvoltage: 0
• maxoperatingvoltage: 0
• lifecyclestatus: 8
• remotecontrol: 0
• nominalvoltagelg: 0
• isvalidloop: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/20/2022 2:54:19 PM

Schema Last Edit Date: 1/20/2022 2:54:19 PM

Data Last Edit Date: 1/20/2022 2:54:19 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Boxplots   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Streaming   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat