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: -10018627.1652033
YMin: 5011743.1871847
XMax: -9730374.04433181
YMax: 5250657.49279489
Spatial Reference: 102100 (3857)

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:

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])

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: 4/20/2021 3:08:31 PM

Schema Last Edit Date: 4/20/2021 3:08:31 PM

Data Last Edit Date: 4/20/2021 3:08:31 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Boxplots   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat