Name: Electric Wire Data

Display Field: dateinstalled

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b0104e4c123940f096288fe7ca346098

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: assetgroup

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• dateinstalled ( type: esriFieldTypeDate, alias: Date Installed, length: 8 )
• material ( type: esriFieldTypeSmallInteger, alias: Material , Coded Values: [0: Unknown] , [1: Aluminum] , [2: Copper] , ...1 more... )
• diameter ( type: esriFieldTypeDouble, alias: Wire Diameter , Coded Values: [0: Unknown] , [0.0641: 14] , [0.072: 13] , ...19 more... )
• measuredlength ( type: esriFieldTypeDouble, alias: Wire Measured Length )
• conductorguid ( type: esriFieldTypeGUID, alias: ElectricLine GUID, length: 38 )
• manufacturer ( type: esriFieldTypeSmallInteger, alias: Manufacturer , Coded Values: [0: Unknown] , [1: Alcan] , [2: Alcoa] , ...10 more... )
• yearmanufacturered ( type: esriFieldTypeDate, alias: Year Manufactured, length: 8 )
• insulationtype ( type: esriFieldTypeSmallInteger, alias: Insulation Type , Coded Values: [0: Unknown] , [1: Bare Wire] , [2: Cross linked polyethylene] , ...5 more... )
• wiretype ( type: esriFieldTypeSmallInteger, alias: Wire Type , Coded Values: [0: Unknown] , [1: AAAC] , [2: AAC] , ...70 more... )
• reelnumber ( type: esriFieldTypeString, alias: Reel ID, length: 40 )
• insulationmaxvoltage ( type: esriFieldTypeInteger, alias: Insulation rated maximum voltage , Coded Values: [0: Unknown] , [1000: 1 kV] , [2000: 2 kV] , ...12 more... )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...15 more... )
• issharedneutral ( type: esriFieldTypeSmallInteger, alias: Is Shared Neutral , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• sharedneutralguid ( type: esriFieldTypeGUID, alias: Shared neutral guid, length: 38 )
• issharedneutralowner ( type: esriFieldTypeSmallInteger, alias: Is shared neutral owner , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset Type , Coded Values: [0: Unknown] , [1: Overhead] , [2: Underground] , ...1 more... )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset Group )
• phasessummer ( type: esriFieldTypeSmallInteger, alias: Phases Summer Configuration )
• phaseswinter ( type: esriFieldTypeSmallInteger, alias: Phases Winter Configuration )
• phasescurrent ( type: esriFieldTypeSmallInteger, alias: Phases Current Configuration )
• phasesenergized ( type: esriFieldTypeSmallInteger, alias: Phases Energized )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• summerampacity ( type: esriFieldTypeDouble, alias: Summer Ampacity )
• impedance ( type: esriFieldTypeDouble, alias: Impedance )
• phasesplan1 ( type: esriFieldTypeSmallInteger, alias: Phases Current Configuration )
• creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• winterampacity ( type: esriFieldTypeDouble, alias: Winter Ampacity )
• r25 ( type: esriFieldTypeDouble, alias: R_25 )
• r50 ( type: esriFieldTypeDouble, alias: R_50 )
• z0 ( type: esriFieldTypeDouble, alias: Z0 )
• z1 ( type: esriFieldTypeDouble, alias: Z1 )
• susceptance ( type: esriFieldTypeDouble, alias: Susceptance )
• withstandrating ( type: esriFieldTypeDouble, alias: WithstandRating )
• tempaturerating ( type: esriFieldTypeDouble, alias: tempaturerating )
• sctempaturerating ( type: esriFieldTypeDouble, alias: sctempaturerating )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, length: 8 )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, length: 8 )
• isneutral ( type: esriFieldTypeSmallInteger, alias: isneutral , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• wirenumber ( type: esriFieldTypeSmallInteger, alias: Wire number for multi wire per phase )
• r_75 ( type: esriFieldTypeDouble, alias: R_75 )
• kcmil ( type: esriFieldTypeDouble, alias: kcmil )
• wireweight ( type: esriFieldTypeDouble, alias: wireweight )
• ratedstrength ( type: esriFieldTypeDouble, alias: ratedstrength )
• allowableampacity ( type: esriFieldTypeSmallInteger, alias: allowableampacity )
• structuremountdetail ( type: esriFieldTypeGUID, alias: StructureMountDetail, length: 38 )
• phasesnormal ( type: esriFieldTypeSmallInteger, alias: Phases Normal )

Types:

ID: 0
Name: Unknown
Domains:
• material:
  Inherited
• diameter:
  Inherited
• manufacturer:
  Inherited
• insulationtype:
  Inherited
• wiretype:
  Inherited
• insulationmaxvoltage:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• issharedneutral:
  Inherited
• issharedneutralowner:
  Inherited
• assettype:
  Inherited
• phasessummer:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• phaseswinter:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• phasescurrent:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• phasesenergized:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• isneutral:
  Inherited
• phasesnormal:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...

---

ID: 1
Name: High Voltage
Domains:
• material:
  Inherited
• diameter:
  Inherited
• manufacturer:
  Inherited
• insulationtype:
  Inherited
• wiretype:
  Inherited
• insulationmaxvoltage:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• issharedneutral:
  Inherited
• issharedneutralowner:
  Inherited
• assettype:
  Inherited
• phasessummer:
  Coded Values: [0: DeEnergized] , [1: III] , [2: II] , ...5 more...
• phaseswinter:
  Coded Values: [0: DeEnergized] , [1: III] , [2: II] , ...5 more...
• phasescurrent:
  Coded Values: [0: DeEnergized] , [1: III] , [2: II] , ...5 more...
• phasesenergized:
  Coded Values: [0: DeEnergized] , [1: III] , [2: II] , ...5 more...
• isneutral:
  Inherited
• phasesnormal:
  Coded Values: [0: DeEnergized] , [1: III] , [2: II] , ...5 more...

---

ID: 2
Name: Low Voltage
Domains:
• material:
  Inherited
• diameter:
  Inherited
• manufacturer:
  Inherited
• insulationtype:
  Inherited
• wiretype:
  Inherited
• insulationmaxvoltage:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• issharedneutral:
  Inherited
• issharedneutralowner:
  Inherited
• assettype:
  Inherited
• phasessummer:
  Coded Values: [0: De-Energized] , [1: c] , [2: b] , ...5 more...
• phaseswinter:
  Coded Values: [0: De-Energized] , [1: c] , [2: b] , ...5 more...
• phasescurrent:
  Coded Values: [0: De-Energized] , [1: c] , [2: b] , ...5 more...
• phasesenergized:
  Coded Values: [0: De-Energized] , [1: c] , [2: b] , ...5 more...
• phasesplan1:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• isneutral:
  Inherited
• phasesnormal:
  Coded Values: [0: De-Energized] , [1: c] , [2: b] , ...5 more...

---

ID: 3
Name: Medium Voltage
Domains:
• material:
  Inherited
• diameter:
  Inherited
• manufacturer:
  Inherited
• insulationtype:
  Inherited
• wiretype:
  Inherited
• insulationmaxvoltage:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• issharedneutral:
  Inherited
• issharedneutralowner:
  Inherited
• assettype:
  Inherited
• phasessummer:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• phaseswinter:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• phasescurrent:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• phasesenergized:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• phasesplan1:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...
• isneutral:
  Inherited
• phasesnormal:
  Coded Values: [0: DeEnergized] , [1: C] , [2: B] , ...5 more...

---

ID: 4
Name: Neutral
Domains:
• material:
  Inherited
• diameter:
  Inherited
• manufacturer:
  Inherited
• insulationtype:
  Inherited
• wiretype:
  Inherited
• insulationmaxvoltage:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• issharedneutral:
  Inherited
• issharedneutralowner:
  Inherited
• assettype:
  Inherited
• isneutral:
  Inherited

---

ID: 5
Name: Static Wire
Domains:
• material:
  Inherited
• diameter:
  Inherited
• manufacturer:
  Inherited
• insulationtype:
  Inherited
• wiretype:
  Inherited
• insulationmaxvoltage:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• issharedneutral:
  Inherited
• issharedneutralowner:
  Inherited
• assettype:
  Inherited
• isneutral:
  Inherited

---

Relationships:

• ElectricLine (10) -- Related To: Electric Line (6)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata