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: 544e5d690af949399c0058f1d728e44d

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

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 228253.4759999998
YMin: 2608744.9750999995
XMax: 248005.26040000003
YMax: 2632738.8878000006
Spatial Reference: 32646  (32646)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: DPDCEGDB.dbo.vw_xfr_blinking.Status
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Green
  Label: Load up to 60% of DT Capacity
  Description:
  Symbol:
  
• Value: Yellow
  Label: Load between 60% to 80% of DT Capacity
  Description:
  Symbol:
  
• Value: Red
  Label: Load more than 80% of DT Capacity
  Description:
  Symbol:
  
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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Subtype

Fields:

• DPDCEGDB.DBO.DistributionTransformer.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DPDCEGDB.DBO.DistributionTransformer.Name ( type: esriFieldTypeString, alias: Name, length: 250 )
• DPDCEGDB.DBO.DistributionTransformer.DTCCode ( type: esriFieldTypeString, alias: DTC Code, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.AssetID ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.NIN ( type: esriFieldTypeString, alias: NIN, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.FromPole ( type: esriFieldTypeString, alias: From Pole, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.FeederID ( type: esriFieldTypeString, alias: Feeder ID, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.FeederName ( type: esriFieldTypeString, alias: Feeder Name, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.NOCS ( type: esriFieldTypeString, alias: NOCS, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.CircleName ( type: esriFieldTypeString, alias: Circle, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.ZoneName ( type: esriFieldTypeString, alias: Zone, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.Phase ( type: esriFieldTypeSmallInteger, alias: Phase , Coded Values: [4: R] , [2: Y] , [1: B] , ...4 more... )
• DPDCEGDB.DBO.DistributionTransformer.CapacityinKVA ( type: esriFieldTypeSmallInteger, alias: Capacity in kVA , Coded Values: [99: Others] , [5: 5] , [8: 7.5] , ...76 more... )
• DPDCEGDB.DBO.DistributionTransformer.Impedance ( type: esriFieldTypeString, alias: Impedance (%), length: 10 )
• DPDCEGDB.DBO.DistributionTransformer.HighVoltageSideVolts ( type: esriFieldTypeSmallInteger, alias: High Voltage side Volts kV , Coded Values: [99: Others] , [340: 11] , [380: 33] , ...2 more... )
• DPDCEGDB.DBO.DistributionTransformer.LowVoltageSideVolts ( type: esriFieldTypeSmallInteger, alias: Low Voltage side Volts kV , Coded Values: [99: Others] , [160: 0.230] , [210: 0.415] )
• DPDCEGDB.DBO.DistributionTransformer.HTProtection ( type: esriFieldTypeString, alias: HT Protection, length: 15 , Coded Values: [Breaker: Breaker] , [Isolator+Fuse: Isolator+Fuse] , [Fuse: Fuse] , ...2 more... )
• DPDCEGDB.DBO.DistributionTransformer.LTProtection ( type: esriFieldTypeString, alias: LT Protection, length: 15 , Coded Values: [ACB: ACB] , [MCCB: MCCB] , [Fuse: Fuse] , ...1 more... )
• DPDCEGDB.DBO.DistributionTransformer.NumberofWays ( type: esriFieldTypeDouble, alias: Number of Ways )
• DPDCEGDB.DBO.DistributionTransformer.TransformerMounting ( type: esriFieldTypeString, alias: Transformer Mounting, length: 30 , Coded Values: [Single Pole: Single Pole] , [Double Pole: Double Pole] , [Tri pole: Tri pole] , ...3 more... )
• DPDCEGDB.DBO.DistributionTransformer.ConditionofDT ( type: esriFieldTypeString, alias: Condition of DT, length: 20 , Coded Values: [Good: Good] , [Poor: Poor] , [Damage: Damage] , ...1 more... )
• DPDCEGDB.DBO.DistributionTransformer.TypeofCore ( type: esriFieldTypeString, alias: Type of Core, length: 20 , Coded Values: [CRGO: CRGO] , [Amorphous: Amorphous] )
• DPDCEGDB.DBO.DistributionTransformer.VectorGroup ( type: esriFieldTypeString, alias: Vector Group, length: 30 , Coded Values: [Dyn11: Dyn11] , [Ynyn0: Ynyn0] , [Others: Others] , ...1 more... )
• DPDCEGDB.DBO.DistributionTransformer.NoLoadLossesW ( type: esriFieldTypeDouble, alias: No Load Losses (W) )
• DPDCEGDB.DBO.DistributionTransformer.CopperLosses ( type: esriFieldTypeString, alias: Copper Losses (W), length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.TotalLosses ( type: esriFieldTypeString, alias: Total Losses (W), length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.CustomerClassCode ( type: esriFieldTypeString, alias: Customer Class Code, length: 20 , Coded Values: [Agricultural: Agricultural] , [Industrial: Industrial] , [Residential: Residential] , ...3 more... )
• DPDCEGDB.DBO.DistributionTransformer.MaximumTap ( type: esriFieldTypeString, alias: Maximum Tap, length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.MinimumTap ( type: esriFieldTypeString, alias: Minimum Tap, length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.NumberOfSteps ( type: esriFieldTypeSmallInteger, alias: Number Of Steps )
• DPDCEGDB.DBO.DistributionTransformer.AdoptedTap ( type: esriFieldTypeString, alias: Adopted Tap, length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.MagnetizingCurrent ( type: esriFieldTypeDouble, alias: Magnetizing Current )
• DPDCEGDB.DBO.DistributionTransformer.TotalLoad ( type: esriFieldTypeString, alias: Total Load, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.ConsumerCount ( type: esriFieldTypeDouble, alias: Consumer Count )
• DPDCEGDB.DBO.DistributionTransformer.HVSideCurrentRating ( type: esriFieldTypeString, alias: HV Side Current Rating (A), length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.LVSideCurrentRating ( type: esriFieldTypeString, alias: LV Side Current Rating (A), length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.CoolingType ( type: esriFieldTypeString, alias: Cooling Type, length: 6 , Coded Values: [Dry: Dry] , [Oil: Oil] , [Others: Others] , ...3 more... )
• DPDCEGDB.DBO.DistributionTransformer.Earthing ( type: esriFieldTypeString, alias: Earthing, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• DPDCEGDB.DBO.DistributionTransformer.DTCType ( type: esriFieldTypeString, alias: DTC Type, length: 50 , Coded Values: [Agriculture: Agriculture] , [Commercial Complex: Commercial Complex] , [Cinema: Cinema] , ...13 more... )
• DPDCEGDB.DBO.DistributionTransformer.LoadTapChangerIndicator ( type: esriFieldTypeString, alias: Load Tap Changer Indicator, length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.WeightofOil ( type: esriFieldTypeString, alias: Weight of Oil (Kg), length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.OilQuantity ( type: esriFieldTypeString, alias: Oil Quantity (Ltr), length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.TransformerWeight ( type: esriFieldTypeString, alias: Transformer Weight (Kg), length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.PercentageLoading ( type: esriFieldTypeString, alias: Percentage Loading, length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.NeutralEarthing ( type: esriFieldTypeString, alias: Neutral Earthing, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• DPDCEGDB.DBO.DistributionTransformer.TemperatureRisingWDG ( type: esriFieldTypeString, alias: Temperature Rising WDG (C), length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.TemperatureRisingOil ( type: esriFieldTypeString, alias: Temperature Rising Oil (C), length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.Ownership ( type: esriFieldTypeString, alias: Ownership, length: 10 , Coded Values: [Utility: Utility] , [Private: Private] , [Others: Others] )
• DPDCEGDB.DBO.DistributionTransformer.LifeSpan ( type: esriFieldTypeString, alias: Life Span, length: 20 )
• DPDCEGDB.DBO.DistributionTransformer.TapLocation ( type: esriFieldTypeString, alias: Tap Location, length: 50 , Coded Values: [Primary: Primary] , [Secondary: Secondary] , [Tertiary: Tertiary] )
• DPDCEGDB.DBO.DistributionTransformer.Configuration ( type: esriFieldTypeString, alias: Configuration, length: 50 , Coded Values: [High Side Configuration: High Side Configuration] , [Low Side Configuration: Low Side Configuration] )
• DPDCEGDB.DBO.DistributionTransformer.State ( type: esriFieldTypeString, alias: State, length: 15 , Coded Values: [Connected: Connected] , [Disconnected: Disconnected] , [Bypassed: Bypassed] )
• DPDCEGDB.DBO.DistributionTransformer.Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.ManufacturingYear ( type: esriFieldTypeString, alias: Manufacturing Year, length: 4 )
• DPDCEGDB.DBO.DistributionTransformer.DateofCommissioning ( type: esriFieldTypeDate, alias: Date of Commissioning, length: 8 )
• DPDCEGDB.DBO.DistributionTransformer.WorkOrderID ( type: esriFieldTypeString, alias: WorkOrder ID, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.Remarks ( type: esriFieldTypeString, alias: Remarks, length: 250 )
• DPDCEGDB.DBO.DistributionTransformer.LocationCodeX ( type: esriFieldTypeDouble, alias: Location Code X )
• DPDCEGDB.DBO.DistributionTransformer.LocationCodeY ( type: esriFieldTypeDouble, alias: Location Code Y )
• DPDCEGDB.DBO.DistributionTransformer.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• DPDCEGDB.DBO.DistributionTransformer.HTLoop ( type: esriFieldTypeString, alias: HTLoop, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
• DPDCEGDB.DBO.DistributionTransformer.TempString ( type: esriFieldTypeString, alias: TempString, length: 255 )
• DPDCEGDB.DBO.DistributionTransformer.EHV ( type: esriFieldTypeString, alias: EHV, length: 20 , Coded Values: [Yes: Yes] , [No: No] )
• DPDCEGDB.DBO.DistributionTransformer.IsAdminApprove ( type: esriFieldTypeInteger, alias: IsAdminApprove )
• DPDCEGDB.DBO.DistributionTransformer.ApprovedBy ( type: esriFieldTypeString, alias: ApprovedBy, length: 255 )
• DPDCEGDB.DBO.DistributionTransformer.ShiftedBy ( type: esriFieldTypeString, alias: ShiftedBy, length: 255 )
• DPDCEGDB.DBO.DistributionTransformer.CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, length: 8 )
• DPDCEGDB.DBO.DistributionTransformer.ApproveDate ( type: esriFieldTypeDate, alias: ApproveDate, length: 8 )
• DPDCEGDB.DBO.DistributionTransformer.UpdatedDate ( type: esriFieldTypeDate, alias: UpdatedDate, length: 8 )
• DPDCEGDB.DBO.DistributionTransformer.SurveyedBy ( type: esriFieldTypeString, alias: SurveyedBy, length: 255 )
• DPDCEGDB.DBO.DistributionTransformer.SurveyedDate ( type: esriFieldTypeDate, alias: SurveyedDate, length: 8 )
• DPDCEGDB.DBO.DistributionTransformer.ShiftedToMainDabase ( type: esriFieldTypeInteger, alias: ShiftedToMainDabase )
• DPDCEGDB.DBO.DistributionTransformer.TrackingNumber ( type: esriFieldTypeString, alias: TrackingNumber, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.BookNo ( type: esriFieldTypeString, alias: BookNo, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• DPDCEGDB.DBO.DistributionTransformer.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• DPDCEGDB.DBO.DistributionTransformer.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• DPDCEGDB.DBO.DistributionTransformer.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• DPDCEGDB.DBO.DistributionTransformer.SurveyID ( type: esriFieldTypeString, alias: SurveyID, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.DPDCAssetID ( type: esriFieldTypeString, alias: DPDCAssetID, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.SubstationCode ( type: esriFieldTypeString, alias: SubstationCode, length: 50 )
• DPDCEGDB.DBO.DistributionTransformer.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• DPDCEGDB.dbo.vw_xfr_blinking.Total_load_in_KW ( type: esriFieldTypeInteger, alias: Total_load_in_KW )
• DPDCEGDB.dbo.vw_xfr_blinking.Total_load_in_KVA ( type: esriFieldTypeSingle, alias: Total_load_in_KVA )
• DPDCEGDB.dbo.vw_xfr_blinking.TransformerRating_in_KW ( type: esriFieldTypeDouble, alias: TransformerRating_in_KW )
• DPDCEGDB.dbo.vw_xfr_blinking.Status ( type: esriFieldTypeString, alias: Status, length: 7 )
• DPDCEGDB.dbo.vw_xfr_blinking.DTLoadPercentage ( type: esriFieldTypeSingle, alias: DTLoadPercentage )
• DPDCEGDB.dbo.vw_xfr_blinking.NOCSCode ( type: esriFieldTypeString, alias: NOCSCode, length: 50 )
• DPDCEGDB.dbo.vw_xfr_blinking.NOCSName ( type: esriFieldTypeString, alias: NOCSName, length: 50 )
• DPDCEGDB.dbo.vw_xfr_blinking.DTCCode ( type: esriFieldTypeString, alias: DTCCode, length: 50 )
• DPDCEGDB.dbo.vw_xfr_blinking.AssetID ( type: esriFieldTypeString, alias: AssetID, length: 50 )
• DPDCEGDB.dbo.vw_xfr_blinking.FeederID ( type: esriFieldTypeString, alias: FeederID, length: 50 )
• DPDCEGDB.dbo.vw_xfr_blinking.CapacityinKVA ( type: esriFieldTypeSmallInteger, alias: CapacityinKVA )
• DPDCEGDB.dbo.vw_xfr_blinking.Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
• DPDCEGDB.dbo.vw_xfr_blinking.ConsumerCountAll ( type: esriFieldTypeInteger, alias: ConsumerCountAll )

Types:

ID: 0
Name: Distribution Transformer
Domains:
• DPDCEGDB.DBO.DistributionTransformer.Phase:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.CapacityinKVA:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.HighVoltageSideVolts:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.LowVoltageSideVolts:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.HTProtection:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.LTProtection:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.TransformerMounting:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.ConditionofDT:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.TypeofCore:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.VectorGroup:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.CustomerClassCode:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.CoolingType:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Earthing:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.DTCType:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.NeutralEarthing:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Ownership:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.TapLocation:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Configuration:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.State:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Enabled:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.EHV:
  Inherited
• DPDCEGDB.dbo.vw_xfr_blinking.CapacityinKVA:
  Coded Values: [99: Others] , [5: 5] , [8: 7.5] , ...76 more...

---

ID: 1
Name: Auxiliary Transformer
Domains:
• DPDCEGDB.DBO.DistributionTransformer.Phase:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.CapacityinKVA:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.HighVoltageSideVolts:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.LowVoltageSideVolts:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.HTProtection:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.LTProtection:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.TransformerMounting:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.ConditionofDT:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.TypeofCore:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.VectorGroup:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.CustomerClassCode:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.CoolingType:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Earthing:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.DTCType:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.NeutralEarthing:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Ownership:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.TapLocation:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Configuration:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.State:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.Enabled:
  Inherited
• DPDCEGDB.DBO.DistributionTransformer.EHV:
  Inherited
• DPDCEGDB.dbo.vw_xfr_blinking.CapacityinKVA:
  Coded Values: [99: Others] , [5: 5] , [8: 7.5] , ...76 more...

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata