Name: sElectricalEquipment
Display Field: AssetID
Type: Table
Geometry Type: N/A
Description:
Definition Expression: N/A
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: false
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: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: SubType
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
, editable: false
, nullable: false
)
-
AssetID
(
type: esriFieldTypeString
, alias: AssetID
, editable: true
, nullable: false
, length: 30
)
-
LegacyID
(
type: esriFieldTypeString
, alias: LegacyID
, editable: true
, nullable: true
, length: 30
)
-
SubType
(
type: esriFieldTypeInteger
, alias: SubType
, editable: true
, nullable: true
)
-
InstallDate
(
type: esriFieldTypeDate
, alias: InstallDate
, editable: true
, nullable: true
, length: 8
)
-
WarrantyDate
(
type: esriFieldTypeDate
, alias: WarrantyDate
, editable: true
, nullable: true
, length: 8
)
-
ConditionDate
(
type: esriFieldTypeDate
, alias: ConditionDate
, editable: true
, nullable: true
, length: 8
)
-
PrimaryImage
(
type: esriFieldTypeString
, alias: PrimaryImage
, editable: true
, nullable: false
, length: 250
)
-
Manufacturer
(
type: esriFieldTypeString
, alias: Manufacturer
, editable: true
, nullable: true
, length: 20
)
-
Model
(
type: esriFieldTypeString
, alias: Model
, editable: true
, nullable: true
, length: 15
)
-
Serial
(
type: esriFieldTypeString
, alias: Serial
, editable: true
, nullable: true
, length: 10
)
-
Amperage
(
type: esriFieldTypeInteger
, alias: Amperage
, editable: true
, nullable: true
)
-
InputVoltage
(
type: esriFieldTypeInteger
, alias: InputVoltage
, editable: true
, nullable: true
, Coded Values:
[208: 208]
, [240: 240]
, [480: 480]
, ...2 more...
)
-
SecondaryVoltage
(
type: esriFieldTypeInteger
, alias: SecondaryVoltage
, editable: true
, nullable: true
, Coded Values:
[120: 120]
, [208: 208]
, [240: 240]
, ...4 more...
)
-
DEVICE_UID
(
type: esriFieldTypeString
, alias: DEVICE_UID
, editable: true
, nullable: true
, length: 30
)
-
DEVICE_SID
(
type: esriFieldTypeString
, alias: DEVICE_SID
, editable: true
, nullable: true
, length: 10
)
-
FEATURE_ID
(
type: esriFieldTypeString
, alias: FEATURE_ID
, editable: true
, nullable: true
, length: 10
)
-
GlobalID
(
type: esriFieldTypeGlobalID
, alias: GlobalID
, editable: false
, nullable: false
, length: 38
)
-
Type
(
type: esriFieldTypeString
, alias: Type
, editable: true
, nullable: true
, length: 50
, Coded Values:
[Soft Start: Soft Start]
, [Cross Line: Cross Line]
, [Autotransformer: Autotransformer]
, ...2 more...
)
-
StationFacilityID
(
type: esriFieldTypeString
, alias: StationFacilityID
, editable: true
, nullable: true
, length: 75
)
-
Notes
(
type: esriFieldTypeString
, alias: Notes
, editable: true
, nullable: true
, length: 250
)
-
Phases
(
type: esriFieldTypeString
, alias: Phases
, editable: true
, nullable: true
, length: 10
, Coded Values:
[S: Single]
, [T: Three]
)
-
Condition
(
type: esriFieldTypeString
, alias: Condition
, editable: true
, nullable: true
, length: 50
, Coded Values:
[Excellent: Excellent]
, [Good: Good]
, [Fair: Fair]
, ...2 more...
)
-
Description
(
type: esriFieldTypeString
, alias: Description
, editable: true
, nullable: true
, length: 50
)
-
TransKVA
(
type: esriFieldTypeDouble
, alias: TransKVA
, editable: true
, nullable: true
)
Types:
ID: 1
Name: Breaker
Domains:
-
Manufacturer:
Coded Values:
[Square D: Square D]
, [Other: Other]
, [GE: GE]
, ...1 more...
-
InputVoltage:
Inherited
-
SecondaryVoltage:
Inherited
-
Type:
Coded Values:
[Main: Main]
, [Other: Other]
, [Branch: Branch]
-
Phases:
Inherited
Templates:
-
Name: Breaker
Description:
Prototype:
Description: null
TransKVA: null
AssetID:
LegacyID: null
SubType: 1
InstallDate: null
WarrantyDate: null
ConditionDate: null
PrimaryImage:
Manufacturer: null
Model: null
Serial: null
Amperage: null
InputVoltage: null
SecondaryVoltage: null
DEVICE_UID: null
DEVICE_SID: null
FEATURE_ID: null
Condition: null
Type: null
StationFacilityID: null
Notes: null
Phases: null
Drawing Tool: esriFeatureEditToolNone
ID: 2
Name: Starter
Domains:
-
Manufacturer:
Coded Values:
[Allen Bradley: Allen Bradley]
, [Square D: Square D]
, [Furnace: Furnace]
, ...1 more...
-
InputVoltage:
Inherited
-
SecondaryVoltage:
Inherited
-
Type:
Inherited
-
Phases:
Inherited
Templates:
-
Name: Starter
Description:
Prototype:
Description: null
TransKVA: null
AssetID:
LegacyID: null
SubType: 2
InstallDate: null
WarrantyDate: null
ConditionDate: null
PrimaryImage:
Manufacturer: null
Model: null
Serial: null
Amperage: null
InputVoltage: null
SecondaryVoltage: null
DEVICE_UID: null
DEVICE_SID: null
FEATURE_ID: null
Condition: null
Type: null
StationFacilityID: null
Notes: null
Phases: null
Drawing Tool: esriFeatureEditToolNone
ID: 3
Name: Disconnect
Domains:
-
InputVoltage:
Inherited
-
SecondaryVoltage:
Inherited
-
Type:
Inherited
-
Phases:
Inherited
Templates:
-
Name: Disconnect
Description:
Prototype:
Description: null
TransKVA: null
AssetID:
LegacyID: null
SubType: 3
InstallDate: null
WarrantyDate: null
ConditionDate: null
PrimaryImage:
Manufacturer: null
Model: null
Serial: null
Amperage: null
InputVoltage: null
SecondaryVoltage: null
DEVICE_UID: null
DEVICE_SID: null
FEATURE_ID: null
Condition: null
Type: null
StationFacilityID: null
Notes: null
Phases: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Create,Delete,Query,Update,Uploads,Editing
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Supports Query With Historic Moment: false
Supported Operations:
Query
Query Related Records
Apply Edits
Add Features
Update Features
Delete Features
Validate SQL
Generate Renderer
Return Updates