View In:   ArcGIS Online Map Viewer

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

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata