Name: Electric Wire Data
Display Field: dateinstalled
Type: Table
Geometry Type: N/A
Description:
Service Item Id: 2b6d7264641341bf90605b8cd21b1656
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
dateinstalled
(
type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateinstalled
)
-
material
(
type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: material
, Coded Values:
[0: Unknown]
, [1: Aluminum]
, [2: Copper]
, ...1 more...
)
-
diameter
(
type: esriFieldTypeDouble, alias: Wire Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter
, Coded Values:
[0: Unknown]
, [0.0641: 14]
, [0.072: 13]
, ...19 more...
)
-
measuredlength
(
type: esriFieldTypeDouble, alias: Wire Measured Length, editable: true, nullable: true, defaultValue: null, modelName: measuredlength
)
-
conductorguid
(
type: esriFieldTypeGUID, alias: ElectricLine GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: conductorguid
)
-
manufacturer
(
type: esriFieldTypeSmallInteger, alias: Manufacturer, editable: true, nullable: true, defaultValue: null, modelName: manufacturer
, Coded Values:
[0: Unknown]
, [1: Alcan]
, [2: Alcoa]
, ...10 more...
)
-
yearmanufacturered
(
type: esriFieldTypeDate, alias: Year Manufactured, editable: true, nullable: true, length: 8, defaultValue: null, modelName: yearmanufacturered
)
-
insulationtype
(
type: esriFieldTypeSmallInteger, alias: Insulation Type, editable: true, nullable: true, defaultValue: null, modelName: insulationtype
, Coded Values:
[0: Unknown]
, [1: Bare Wire]
, [2: Cross linked polyethylene]
, ...5 more...
)
-
wiretype
(
type: esriFieldTypeSmallInteger, alias: Wire Type, editable: true, nullable: true, defaultValue: null, modelName: wiretype
, Coded Values:
[0: Unknown]
, [1: AAAC]
, [2: AAC]
, ...70 more...
)
-
reelnumber
(
type: esriFieldTypeString, alias: Reel ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: reelnumber
)
-
insulationmaxvoltage
(
type: esriFieldTypeInteger, alias: Insulation rated maximum voltage, editable: true, nullable: true, defaultValue: null, modelName: insulationmaxvoltage
, Coded Values:
[0: Unknown]
, [1000: 1 kV]
, [2000: 2 kV]
, ...12 more...
)
-
lifecyclestatus
(
type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: true, defaultValue: null, modelName: lifecyclestatus
, Coded Values:
[0: Unknown]
, [1: Proposed]
, [2: Approved]
, ...15 more...
)
-
issharedneutral
(
type: esriFieldTypeSmallInteger, alias: Is Shared Neutral, editable: true, nullable: true, defaultValue: null, modelName: issharedneutral
, Coded Values:
[0: Unknown]
, [1: Yes]
, [2: No]
)
-
sharedneutralguid
(
type: esriFieldTypeGUID, alias: Shared neutral guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: sharedneutralguid
)
-
issharedneutralowner
(
type: esriFieldTypeSmallInteger, alias: Is shared neutral owner, editable: true, nullable: true, defaultValue: null, modelName: issharedneutralowner
, Coded Values:
[0: Unknown]
, [1: Yes]
, [2: No]
)
-
assettype
(
type: esriFieldTypeSmallInteger, alias: Asset Type, editable: true, nullable: true, defaultValue: null, modelName: assettype
, Coded Values:
[0: Unknown]
, [1: Overhead]
, [2: Underground]
, ...1 more...
)
-
assetgroup
(
type: esriFieldTypeInteger, alias: Asset Group, editable: true, nullable: false, defaultValue: 0, modelName: assetgroup
)
-
phasessummer
(
type: esriFieldTypeSmallInteger, alias: Phases Summer Configuration, editable: true, nullable: true, defaultValue: null, modelName: phasessummer
)
-
phaseswinter
(
type: esriFieldTypeSmallInteger, alias: Phases Winter Configuration, editable: true, nullable: true, defaultValue: null, modelName: phaseswinter
)
-
phasescurrent
(
type: esriFieldTypeSmallInteger, alias: Phases Current Configuration, editable: true, nullable: true, defaultValue: null, modelName: phasescurrent
)
-
phasesenergized
(
type: esriFieldTypeSmallInteger, alias: Phases Energized, editable: true, nullable: true, defaultValue: null, modelName: phasesenergized
)
-
globalid
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID
)
-
summerampacity
(
type: esriFieldTypeDouble, alias: Summer Ampacity, editable: true, nullable: true, defaultValue: null, modelName: ampacity
)
-
impedance
(
type: esriFieldTypeDouble, alias: Impedance, editable: true, nullable: true, defaultValue: null, modelName: Impedance
)
-
phasesplan1
(
type: esriFieldTypeSmallInteger, alias: Phases Current Configuration, editable: true, nullable: true, defaultValue: null, modelName: phasesplan1
)
-
creator
(
type: esriFieldTypeString, alias: Creator, editable: true, required: true, nullable: true, length: 255, defaultValue: null, modelName: creator
)
-
creationdate
(
type: esriFieldTypeDate, alias: Creation date, editable: true, required: true, nullable: true, length: 8, defaultValue: null, modelName: creationdate
)
-
updatedby
(
type: esriFieldTypeString, alias: Updated by, editable: true, required: true, nullable: true, length: 255, defaultValue: null, modelName: updatedby
)
-
lastupdate
(
type: esriFieldTypeDate, alias: Last update, editable: true, required: true, nullable: true, length: 8, defaultValue: null, modelName: lastupdate
)
-
winterampacity
(
type: esriFieldTypeDouble, alias: Winter Ampacity, editable: true, nullable: true, defaultValue: null, modelName: winterapacity
)
-
r25
(
type: esriFieldTypeDouble, alias: R_25, editable: true, nullable: true, defaultValue: null, modelName: R_25
)
-
r50
(
type: esriFieldTypeDouble, alias: R_50, editable: true, nullable: true, defaultValue: null, modelName: R_50
)
-
z0
(
type: esriFieldTypeDouble, alias: Z0, editable: true, nullable: true, defaultValue: null, modelName: Z0
)
-
z1
(
type: esriFieldTypeDouble, alias: Z1, editable: true, nullable: true, defaultValue: null, modelName: Z1
)
-
susceptance
(
type: esriFieldTypeDouble, alias: Susceptance, editable: true, nullable: true, defaultValue: null, modelName: Susceptance
)
-
withstandrating
(
type: esriFieldTypeDouble, alias: WithstandRating, editable: true, nullable: true, defaultValue: null, modelName: WithstandRating
)
-
tempaturerating
(
type: esriFieldTypeDouble, alias: tempaturerating, editable: true, nullable: true, defaultValue: null, modelName: tempaturerating
)
-
sctempaturerating
(
type: esriFieldTypeDouble, alias: sctempaturerating, editable: true, nullable: true, defaultValue: null, modelName: sctempaturerating
)
-
installdate
(
type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate
)
-
retireddate
(
type: esriFieldTypeDate, alias: Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: retireddate
)
-
inservicedate
(
type: esriFieldTypeDate, alias: In-Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inservicedate
)
-
isneutral
(
type: esriFieldTypeSmallInteger, alias: isneutral, editable: true, nullable: true, defaultValue: null, modelName: isneutral
, Coded Values:
[0: Unknown]
, [1: Yes]
, [2: No]
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: created_user
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: created_date
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
-
wirenumber
(
type: esriFieldTypeSmallInteger, alias: Wire number for multi wire per phase, editable: true, nullable: true, defaultValue: null, modelName: wirenumber
)
-
r_75
(
type: esriFieldTypeDouble, alias: R_75, editable: true, nullable: true, defaultValue: null, modelName: R_75
)
-
kcmil
(
type: esriFieldTypeDouble, alias: kcmil, editable: true, nullable: true, defaultValue: null, modelName: kcmil
)
-
wireweight
(
type: esriFieldTypeDouble, alias: wireweight, editable: true, nullable: true, defaultValue: null, modelName: wireweight
)
-
ratedstrength
(
type: esriFieldTypeDouble, alias: ratedstrength, editable: true, nullable: true, defaultValue: null, modelName: ratedstrength
)
-
allowableampacity
(
type: esriFieldTypeSmallInteger, alias: allowableampacity, editable: true, nullable: true, defaultValue: null, modelName: allowableampacity
)
-
structuremountdetail
(
type: esriFieldTypeGUID, alias: StructureMountDetail, editable: true, nullable: true, length: 38, defaultValue: null, modelName: StructureMountDetail
)
-
phasesnormal
(
type: esriFieldTypeSmallInteger, alias: Phases Normal, editable: true, nullable: true, defaultValue: null, modelName: phasesnormal
)
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...
Templates:
-
Name: Unknown
Description:
Prototype:
structuremountdetail: null
allowableampacity: null
dateinstalled: null
material: null
diameter: null
measuredlength: null
conductorguid: null
manufacturer: null
yearmanufacturered: null
insulationtype: null
wiretype: null
reelnumber: null
insulationmaxvoltage: null
lifecyclestatus: null
issharedneutral: null
sharedneutralguid: null
issharedneutralowner: null
assettype: null
assetgroup: 0
phasessummer: null
phaseswinter: null
phasescurrent: null
phasesenergized: null
phasesnormal: null
summerampacity: null
impedance: null
phasesplan1: null
creator: null
creationdate: null
updatedby: null
lastupdate: null
winterampacity: null
r25: null
r50: null
z0: null
z1: null
susceptance: null
withstandrating: null
tempaturerating: null
sctempaturerating: null
installdate: null
retireddate: null
inservicedate: null
isneutral: null
ratedstrength: null
wireweight: null
kcmil: null
r_75: null
wirenumber: null
Drawing Tool: esriFeatureEditToolNone
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...
Templates:
-
Name: High Voltage
Description:
Prototype:
structuremountdetail: null
allowableampacity: null
dateinstalled: null
material: null
diameter: null
measuredlength: null
conductorguid: null
manufacturer: null
yearmanufacturered: null
insulationtype: null
wiretype: null
reelnumber: null
insulationmaxvoltage: null
lifecyclestatus: null
issharedneutral: null
sharedneutralguid: null
issharedneutralowner: null
assettype: null
assetgroup: 1
phasessummer: null
phaseswinter: null
phasescurrent: null
phasesenergized: null
phasesnormal: null
summerampacity: null
impedance: null
phasesplan1: null
creator: null
creationdate: null
updatedby: null
lastupdate: null
winterampacity: null
r25: null
r50: null
z0: null
z1: null
susceptance: null
withstandrating: null
tempaturerating: null
sctempaturerating: null
installdate: null
retireddate: null
inservicedate: null
isneutral: null
ratedstrength: null
wireweight: null
kcmil: null
r_75: null
wirenumber: null
Drawing Tool: esriFeatureEditToolNone
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...
Templates:
-
Name: Low Voltage
Description:
Prototype:
structuremountdetail: null
allowableampacity: null
dateinstalled: null
material: null
diameter: null
measuredlength: null
conductorguid: null
manufacturer: null
yearmanufacturered: null
insulationtype: null
wiretype: null
reelnumber: null
insulationmaxvoltage: null
lifecyclestatus: null
issharedneutral: null
sharedneutralguid: null
issharedneutralowner: null
assettype: null
assetgroup: 2
phasessummer: null
phaseswinter: null
phasescurrent: null
phasesenergized: null
phasesnormal: null
summerampacity: null
impedance: null
phasesplan1: null
creator: null
creationdate: null
updatedby: null
lastupdate: null
winterampacity: null
r25: null
r50: null
z0: null
z1: null
susceptance: null
withstandrating: null
tempaturerating: null
sctempaturerating: null
installdate: null
retireddate: null
inservicedate: null
isneutral: null
ratedstrength: null
wireweight: null
kcmil: null
r_75: null
wirenumber: null
Drawing Tool: esriFeatureEditToolNone
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...
Templates:
-
Name: Medium Voltage
Description:
Prototype:
structuremountdetail: null
allowableampacity: null
dateinstalled: null
material: null
diameter: null
measuredlength: null
conductorguid: null
manufacturer: null
yearmanufacturered: null
insulationtype: null
wiretype: null
reelnumber: null
insulationmaxvoltage: null
lifecyclestatus: null
issharedneutral: null
sharedneutralguid: null
issharedneutralowner: null
assettype: null
assetgroup: 3
phasessummer: null
phaseswinter: null
phasescurrent: null
phasesenergized: null
phasesnormal: null
summerampacity: null
impedance: null
phasesplan1: null
creator: null
creationdate: null
updatedby: null
lastupdate: null
winterampacity: null
r25: null
r50: null
z0: null
z1: null
susceptance: null
withstandrating: null
tempaturerating: null
sctempaturerating: null
installdate: null
retireddate: null
inservicedate: null
isneutral: null
ratedstrength: null
wireweight: null
kcmil: null
r_75: null
wirenumber: null
Drawing Tool: esriFeatureEditToolNone
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
Templates:
-
Name: Neutral
Description:
Prototype:
structuremountdetail: null
allowableampacity: null
dateinstalled: null
material: null
diameter: null
measuredlength: null
conductorguid: null
manufacturer: null
yearmanufacturered: null
insulationtype: null
wiretype: null
reelnumber: null
insulationmaxvoltage: null
lifecyclestatus: null
issharedneutral: null
sharedneutralguid: null
issharedneutralowner: null
assettype: null
assetgroup: 4
phasessummer: null
phaseswinter: null
phasescurrent: null
phasesenergized: null
phasesnormal: null
summerampacity: null
impedance: null
phasesplan1: null
creator: null
creationdate: null
updatedby: null
lastupdate: null
winterampacity: null
r25: null
r50: null
z0: null
z1: null
susceptance: null
withstandrating: null
tempaturerating: null
sctempaturerating: null
installdate: null
retireddate: null
inservicedate: null
isneutral: null
ratedstrength: null
wireweight: null
kcmil: null
r_75: null
wirenumber: null
Drawing Tool: esriFeatureEditToolNone
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
Templates:
-
Name: Static Wire
Description:
Prototype:
structuremountdetail: null
allowableampacity: null
dateinstalled: null
material: null
diameter: null
measuredlength: null
conductorguid: null
manufacturer: null
yearmanufacturered: null
insulationtype: null
wiretype: null
reelnumber: null
insulationmaxvoltage: null
lifecyclestatus: null
issharedneutral: null
sharedneutralguid: null
issharedneutralowner: null
assettype: null
assetgroup: 5
phasessummer: null
phaseswinter: null
phasescurrent: null
phasesenergized: null
phasesnormal: null
summerampacity: null
impedance: null
phasesplan1: null
creator: null
creationdate: null
updatedby: null
lastupdate: null
winterampacity: null
r25: null
r50: null
z0: null
z1: null
susceptance: null
withstandrating: null
tempaturerating: null
sctempaturerating: null
installdate: null
retireddate: null
inservicedate: null
isneutral: null
ratedstrength: null
wireweight: null
kcmil: null
r_75: null
wirenumber: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: true
Supports OidReservation: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: true
Supports Coordinates Quantization: false
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Related Records
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata