Name: DisSPatchSQL.dbo.AffectedCustomersWithGrid
Display Field: Account
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
Account
(
type: esriFieldTypeString, alias: Account, length: 28
)
-
Meter
(
type: esriFieldTypeString, alias: Meter, length: 15
)
-
Substation
(
type: esriFieldTypeString, alias: Substation, length: 25
)
-
Feeder
(
type: esriFieldTypeString, alias: Feeder, length: 25
)
-
Device
(
type: esriFieldTypeString, alias: Device, length: 8000
)
-
Transformer
(
type: esriFieldTypeString, alias: Transformer, length: 25
)
-
Phase
(
type: esriFieldTypeString, alias: Phase, length: 3
)
-
OutageRecID
(
type: esriFieldTypeString, alias: OutageRecID, length: 15
)
-
PowerIsOff
(
type: esriFieldTypeSmallInteger, alias: PowerIsOff
)
-
Verified
(
type: esriFieldTypeSmallInteger, alias: Verified
)
-
AccountStatus
(
type: esriFieldTypeString, alias: AccountStatus, length: 15
)
-
ServLoc
(
type: esriFieldTypeString, alias: ServLoc, length: 25
)
-
CustomerID
(
type: esriFieldTypeString, alias: CustomerID, length: 54
)
-
Lat
(
type: esriFieldTypeDouble, alias: Lat
)
-
Lon
(
type: esriFieldTypeDouble, alias: Lon
)
-
X
(
type: esriFieldTypeDouble, alias: X
)
-
Y
(
type: esriFieldTypeDouble, alias: Y
)
-
GridID
(
type: esriFieldTypeString, alias: GridID, length: 7
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata