ArcGIS REST Services Directory
Login
Home
>
services
>
Electrical
>
DT_Load_Status (FeatureServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (Electrical/DT_Load_Status)
Layers:
Layer:
DT Sanctioned Load Status
(0)
Name:
DT Sanctioned Load Status
Display Field:
DPDCEGDB.DBO.DistributionTransformer.Name
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
DT Sanctioned Load Status
Service Item Id:
42dd7fb396744c9aa47875798e113460
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON
Min Scale:
4000
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
false
Supports Datum Transformation:
true
Extent:
XMin: 228253.4759999998
YMin: 2608744.9750999995
XMax: 248005.26040000003
YMax: 2632738.8878000006
Spatial Reference: 32646 (32646)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[138, 0, 150, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Label:
Description:
Transparency:
0
Labeling Info:
Label Placement:
esriServerPointLabelPlacementAboveRight
Label Expression:
"Con. Load-" CONCAT [DPDCEGDB.dbo.vw_xfr_blinking.Total_load_in_KW] CONCAT " kW"
Use Coded Values:
true
Symbol:
Color:
[115, 0, 0, 255]
Background Color:
N/A
Outline Color:
N/A
Vertical Alignment:
bottom
Horizontal Alignment:
center
Right to Left:
false
Angle:
0
XOffset:
0
YOffset:
0
Size:
9
Font Family:
Arial
Font Style:
normal
Font Weight:
bold
Font Decoration:
none
Min. Scale:
1500.0
Max. Scale:
0.0
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
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Name
( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Name )
DTCCode
( type: esriFieldTypeString, alias: DTC Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DTCCode )
AssetID
( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
NIN
( type: esriFieldTypeString, alias: NIN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NIN )
FromPole
( type: esriFieldTypeString, alias: From Pole, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FromPole )
FeederID
( type: esriFieldTypeString, alias: Feeder ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FeederID )
FeederName
( type: esriFieldTypeString, alias: Feeder Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FeederName )
NOCS
( type: esriFieldTypeString, alias: NOCS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOCS )
CircleName
( type: esriFieldTypeString, alias: Circle, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CircleName )
ZoneName
( type: esriFieldTypeString, alias: Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ZoneName )
Phase
( type: esriFieldTypeSmallInteger, alias: Phase, editable: true, nullable: true, defaultValue: null, modelName: Phase ,
Coded Values:
[4: R] , [2: Y] , [1: B]
, ...4 more...
)
CapacityinKVA
( type: esriFieldTypeSmallInteger, alias: Capacity in kVA, editable: true, nullable: true, defaultValue: null, modelName: CapacityinKVA ,
Coded Values:
[99: Others] , [5: 5] , [8: 7.5]
, ...76 more...
)
Impedance
( type: esriFieldTypeString, alias: Impedance (%), editable: true, nullable: true, length: 10, defaultValue: null, modelName: Impedance )
HighVoltageSideVolts
( type: esriFieldTypeSmallInteger, alias: High Voltage side Volts kV, editable: true, nullable: true, defaultValue: null, modelName: HighVoltageSideVolts ,
Coded Values:
[99: Others] , [340: 11] , [380: 33]
, ...2 more...
)
LowVoltageSideVolts
( type: esriFieldTypeSmallInteger, alias: Low Voltage side Volts kV, editable: true, nullable: true, defaultValue: null, modelName: LowVoltageSideVolts ,
Coded Values:
[99: Others] , [160: 0.230] , [210: 0.415] )
HTProtection
( type: esriFieldTypeString, alias: HT Protection, editable: true, nullable: true, length: 15, defaultValue: null, modelName: HTProtection ,
Coded Values:
[Breaker: Breaker] , [Isolator+Fuse: Isolator+Fuse] , [Fuse: Fuse]
, ...2 more...
)
LTProtection
( type: esriFieldTypeString, alias: LT Protection, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LTProtection ,
Coded Values:
[ACB: ACB] , [MCCB: MCCB] , [Fuse: Fuse]
, ...1 more...
)
NumberofWays
( type: esriFieldTypeDouble, alias: Number of Ways, editable: true, nullable: true, defaultValue: null, modelName: NumberofWays )
TransformerMounting
( type: esriFieldTypeString, alias: Transformer Mounting, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TransformerMounting ,
Coded Values:
[Single Pole: Single Pole] , [Double Pole: Double Pole] , [Tri pole: Tri pole]
, ...3 more...
)
ConditionofDT
( type: esriFieldTypeString, alias: Condition of DT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ConditionofDT ,
Coded Values:
[Good: Good] , [Poor: Poor] , [Damage: Damage]
, ...1 more...
)
TypeofCore
( type: esriFieldTypeString, alias: Type of Core, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TypeofCore ,
Coded Values:
[CRGO: CRGO] , [Amorphous: Amorphous] )
VectorGroup
( type: esriFieldTypeString, alias: Vector Group, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VectorGroup ,
Coded Values:
[Dyn11: Dyn11] , [Ynyn0: Ynyn0] , [Others: Others]
, ...1 more...
)
NoLoadLossesW
( type: esriFieldTypeDouble, alias: No Load Losses (W), editable: true, nullable: true, defaultValue: null, modelName: NoLoadLossesW )
CopperLosses
( type: esriFieldTypeString, alias: Copper Losses (W), editable: true, nullable: true, length: 50, defaultValue: null, modelName: CopperLosses )
TotalLosses
( type: esriFieldTypeString, alias: Total Losses (W), editable: true, nullable: true, length: 50, defaultValue: null, modelName: TotalLosses )
CustomerClassCode
( type: esriFieldTypeString, alias: Customer Class Code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CustomerClassCode ,
Coded Values:
[Agricultural: Agricultural] , [Industrial: Industrial] , [Residential: Residential]
, ...3 more...
)
MaximumTap
( type: esriFieldTypeString, alias: Maximum Tap, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MaximumTap )
MinimumTap
( type: esriFieldTypeString, alias: Minimum Tap, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MinimumTap )
NumberOfSteps
( type: esriFieldTypeSmallInteger, alias: Number Of Steps, editable: true, nullable: true, defaultValue: null, modelName: NumberOfSteps )
AdoptedTap
( type: esriFieldTypeString, alias: Adopted Tap, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AdoptedTap )
MagnetizingCurrent
( type: esriFieldTypeDouble, alias: Magnetizing Current, editable: true, nullable: true, defaultValue: null, modelName: MagnetizingCurrent )
TotalLoad
( type: esriFieldTypeString, alias: Total Load, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TotalLoad )
ConsumerCount
( type: esriFieldTypeDouble, alias: Consumer Count, editable: true, nullable: true, defaultValue: null, modelName: ConsumerCount )
HVSideCurrentRating
( type: esriFieldTypeString, alias: HV Side Current Rating (A), editable: true, nullable: true, length: 50, defaultValue: null, modelName: HVSideCurrentRating )
LVSideCurrentRating
( type: esriFieldTypeString, alias: LV Side Current Rating (A), editable: true, nullable: true, length: 50, defaultValue: null, modelName: LVSideCurrentRating )
CoolingType
( type: esriFieldTypeString, alias: Cooling Type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CoolingType ,
Coded Values:
[Dry: Dry] , [Oil: Oil] , [Others: Others]
, ...3 more...
)
Earthing
( type: esriFieldTypeString, alias: Earthing, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Earthing ,
Coded Values:
[Yes: Yes] , [No: No] )
DTCType
( type: esriFieldTypeString, alias: DTC Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DTCType ,
Coded Values:
[Agriculture: Agriculture] , [Commercial Complex: Commercial Complex] , [Cinema: Cinema]
, ...13 more...
)
LoadTapChangerIndicator
( type: esriFieldTypeString, alias: Load Tap Changer Indicator, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LoadTapChangerIndicator )
WeightofOil
( type: esriFieldTypeString, alias: Weight of Oil (Kg), editable: true, nullable: true, length: 50, defaultValue: null, modelName: WeightofOil )
OilQuantity
( type: esriFieldTypeString, alias: Oil Quantity (Ltr), editable: true, nullable: true, length: 20, defaultValue: null, modelName: OilQuantity )
TransformerWeight
( type: esriFieldTypeString, alias: Transformer Weight (Kg), editable: true, nullable: true, length: 20, defaultValue: null, modelName: TransformerWeight )
PercentageLoading
( type: esriFieldTypeString, alias: Percentage Loading, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PercentageLoading )
NeutralEarthing
( type: esriFieldTypeString, alias: Neutral Earthing, editable: true, nullable: true, length: 3, defaultValue: null, modelName: NeutralEarthing ,
Coded Values:
[Yes: Yes] , [No: No] )
TemperatureRisingWDG
( type: esriFieldTypeString, alias: Temperature Rising WDG (C), editable: true, nullable: true, length: 20, defaultValue: null, modelName: TemperatureRisingWDG )
TemperatureRisingOil
( type: esriFieldTypeString, alias: Temperature Rising Oil (C), editable: true, nullable: true, length: 20, defaultValue: null, modelName: TemperatureRisingOil )
Ownership
( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ownership ,
Coded Values:
[Utility: Utility] , [Private: Private] , [Others: Others] )
LifeSpan
( type: esriFieldTypeString, alias: Life Span, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LifeSpan )
TapLocation
( type: esriFieldTypeString, alias: Tap Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TapLocation ,
Coded Values:
[Primary: Primary] , [Secondary: Secondary] , [Tertiary: Tertiary] )
Configuration
( type: esriFieldTypeString, alias: Configuration, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Configuration ,
Coded Values:
[High Side Configuration: High Side Configuration] , [Low Side Configuration: Low Side Configuration] )
State
( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 15, defaultValue: null, modelName: State ,
Coded Values:
[Connected: Connected] , [Disconnected: Disconnected] , [Bypassed: Bypassed] )
Manufacturer
( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
SerialNumber
( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
ManufacturingYear
( type: esriFieldTypeString, alias: Manufacturing Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ManufacturingYear )
DateofCommissioning
( type: esriFieldTypeDate, alias: Date of Commissioning, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateofCommissioning )
WorkOrderID
( type: esriFieldTypeString, alias: WorkOrder ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkOrderID )
Remarks
( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Remarks )
LocationCodeX
( type: esriFieldTypeDouble, alias: Location Code X, editable: true, nullable: true, defaultValue: null, modelName: LocationCodeX )
LocationCodeY
( type: esriFieldTypeDouble, alias: Location Code Y, editable: true, nullable: true, defaultValue: null, modelName: LocationCodeY )
Enabled
( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled ,
Coded Values:
[0: False] , [1: True] )
HTLoop
( type: esriFieldTypeString, alias: HTLoop, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HTLoop )
Subtype
( type: esriFieldTypeSmallInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 0, modelName: Subtype )
TempString
( type: esriFieldTypeString, alias: TempString, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TempString )
EHV
( type: esriFieldTypeString, alias: EHV, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EHV ,
Coded Values:
[Yes: Yes] , [No: No] )
IsAdminApprove
( type: esriFieldTypeInteger, alias: IsAdminApprove, editable: true, nullable: true, defaultValue: null, modelName: IsAdminApprove )
ApprovedBy
( type: esriFieldTypeString, alias: ApprovedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApprovedBy )
ShiftedBy
( type: esriFieldTypeString, alias: ShiftedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ShiftedBy )
CreatedDate
( type: esriFieldTypeDate, alias: CreatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
ApproveDate
( type: esriFieldTypeDate, alias: ApproveDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ApproveDate )
UpdatedDate
( type: esriFieldTypeDate, alias: UpdatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UpdatedDate )
SurveyedBy
( type: esriFieldTypeString, alias: SurveyedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SurveyedBy )
SurveyedDate
( type: esriFieldTypeDate, alias: SurveyedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SurveyedDate )
ShiftedToMainDabase
( type: esriFieldTypeInteger, alias: ShiftedToMainDabase, editable: true, nullable: true, defaultValue: null, modelName: ShiftedToMainDabase )
TrackingNumber
( type: esriFieldTypeString, alias: TrackingNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TrackingNumber )
BookNo
( type: esriFieldTypeString, alias: BookNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BookNo )
created_user
( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
SurveyID
( type: esriFieldTypeString, alias: SurveyID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SurveyID )
DPDCAssetID
( type: esriFieldTypeString, alias: DPDCAssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DPDCAssetID )
SubstationCode
( type: esriFieldTypeString, alias: SubstationCode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SubstationCode )
Templates:
Name: DT Sanctioned Load Status
Description:
Prototype:
DPDCAssetID:
null
SubstationCode:
null
Name:
null
DTCCode:
null
AssetID:
null
NIN:
null
FromPole:
null
FeederID:
null
FeederName:
null
NOCS:
null
CircleName:
null
ZoneName:
null
Phase:
null
CapacityinKVA:
null
Impedance:
null
HighVoltageSideVolts:
null
LowVoltageSideVolts:
null
HTProtection:
null
LTProtection:
null
NumberofWays:
null
TransformerMounting:
null
ConditionofDT:
null
TypeofCore:
null
VectorGroup:
null
NoLoadLossesW:
null
CopperLosses:
null
TotalLosses:
null
CustomerClassCode:
null
MaximumTap:
null
MinimumTap:
null
NumberOfSteps:
null
AdoptedTap:
null
MagnetizingCurrent:
null
TotalLoad:
null
ConsumerCount:
null
HVSideCurrentRating:
null
LVSideCurrentRating:
null
CoolingType:
null
Earthing:
null
DTCType:
null
LoadTapChangerIndicator:
null
WeightofOil:
null
OilQuantity:
null
TransformerWeight:
null
PercentageLoading:
null
NeutralEarthing:
null
TemperatureRisingWDG:
null
TemperatureRisingOil:
null
Ownership:
null
LifeSpan:
null
TapLocation:
null
Configuration:
null
State:
null
Manufacturer:
null
SerialNumber:
null
ManufacturingYear:
null
DateofCommissioning:
null
WorkOrderID:
null
Remarks:
null
LocationCodeX:
null
LocationCodeY:
null
Enabled:
1
HTLoop:
null
Subtype:
0
TempString:
null
EHV:
null
IsAdminApprove:
null
ApprovedBy:
null
ShiftedBy:
null
CreatedDate:
null
ApproveDate:
null
UpdatedDate:
null
SurveyedBy:
null
SurveyedDate:
null
ShiftedToMainDabase:
null
TrackingNumber:
null
BookNo:
null
SurveyID:
null
Drawing Tool: esriFeatureEditToolPoint