View In:   ArcGIS Online Map Viewer

Name: D_TRANSFORMER

Display Field: CIRCLE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0b5839941f0d4ba586f66e39d2cf6887

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 745685.5766000003
YMin: 1960696.7616000008
XMax: 747287.1995999999
YMax: 1961635.3608
Spatial Reference: 32644  (32644)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [71, 153, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 0
  Label:
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [156, 0, 8, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Auxiliary Transformer
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [171, 80, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1
  Label: Transformer
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [151, 0, 168, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling 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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: subtype

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• circle_name ( type: esriFieldTypeString, alias: CIRCLE_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIRCLE_NAME )
• circle_id ( type: esriFieldTypeString, alias: CIRCLE_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIRCLE_ID )
• division_name ( type: esriFieldTypeString, alias: DIVISION_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DIVISION_NAME )
• division_id ( type: esriFieldTypeString, alias: DIVISION_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DIVISION_ID )
• sub_division_name ( type: esriFieldTypeString, alias: SUB_DIVISION_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUB_DIVISION_NAME )
• sub_division_id ( type: esriFieldTypeString, alias: SUB_DIVISION_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUB_DIVISION_ID )
• section_name ( type: esriFieldTypeString, alias: SECTION_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SECTION_NAME )
• section_id ( type: esriFieldTypeString, alias: SECTION_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SECTION_ID )
• tr_id ( type: esriFieldTypeString, alias: TR_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TR_ID )
• ptr_yard_id ( type: esriFieldTypeString, alias: PTR_YARD_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PTR_YARD_ID )
• hv_swbay_id ( type: esriFieldTypeString, alias: HV_SWBAY_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HV_SWBAY_ID )
• lv_swbay_id ( type: esriFieldTypeString, alias: LV_SWBAY_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LV_SWBAY_ID )
• trans_type ( type: esriFieldTypeString, alias: TRANS_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TRANS_TYPE )
• make ( type: esriFieldTypeString, alias: MAKE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAKE )
• serial_number ( type: esriFieldTypeString, alias: SERIAL_NUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SERIAL_NUMBER )
• year_of_mfg ( type: esriFieldTypeDate, alias: YEAR_OF_MFG, editable: true, nullable: true, length: 8, defaultValue: null, modelName: YEAR_OF_MFG )
• voltage_rating ( type: esriFieldTypeString, alias: VOLTAGE_RATING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VOLTAGE_RATING )
• mva_rating ( type: esriFieldTypeString, alias: MVA_RATING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MVA_RATING )
• rated_hv_amps ( type: esriFieldTypeString, alias: RATED_HV_AMPS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RATED_HV_AMPS )
• rated_lv_amps ( type: esriFieldTypeString, alias: RATED_LV_AMPS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RATED_LV_AMPS )
• impedance ( type: esriFieldTypeString, alias: IMPEDANCE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IMPEDANCE )
• no_available_taps ( type: esriFieldTypeString, alias: NO_AVAILABLE_TAPS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NO_AVAILABLE_TAPS )
• cooling_type ( type: esriFieldTypeString, alias: COOLING_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COOLING_TYPE )
• no_cooling_fans ( type: esriFieldTypeString, alias: NO_COOLING_FANS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NO_COOLING_FANS )
• winding_temp_tripvalue ( type: esriFieldTypeString, alias: WINDING_TEMP_TRIPVALUE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WINDING_TEMP_TRIPVALUE )
• oil_temp_tripvalue ( type: esriFieldTypeString, alias: OIL_TEMP_TRIPVALUE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OIL_TEMP_TRIPVALUE )
• switch_type ( type: esriFieldTypeString, alias: SWITCH_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SWITCH_TYPE )
• slong ( type: esriFieldTypeString, alias: SLONG, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLONG )
• created_date ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• updated_date ( type: esriFieldTypeDate, alias: UPDATED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATED_DATE )
• updated_by ( type: esriFieldTypeString, alias: UPDATED_BY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UPDATED_BY )
• workorder_id ( type: esriFieldTypeString, alias: WORKORDER_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WORKORDER_ID )
• ltconfigur ( type: esriFieldTypeString, alias: LTCONFIGUR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LTCONFIGUR )
• ltratedvol ( type: esriFieldTypeString, alias: LTRATEDVOL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LTRATEDVOL )
• ltvoltage ( type: esriFieldTypeString, alias: LTVOLTAGE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LTVOLTAGE )
• manufactur ( type: esriFieldTypeString, alias: MANUFACTUR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MANUFACTUR )
• maxtap ( type: esriFieldTypeString, alias: MAXTAP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAXTAP )
• mintap ( type: esriFieldTypeString, alias: MINTAP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MINTAP )
• nominalvol ( type: esriFieldTypeString, alias: NOMINALVOL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOMINALVOL )
• normaltap ( type: esriFieldTypeString, alias: NORMALTAP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NORMALTAP )
• normaltapn ( type: esriFieldTypeString, alias: NORMALTAPN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NORMALTAPN )
• operatingv ( type: esriFieldTypeString, alias: OPERATINGV, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OPERATINGV )
• phasedesig ( type: esriFieldTypeString, alias: PHASEDESIG, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHASEDESIG )
• primarysid ( type: esriFieldTypeString, alias: PRIMARYSID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRIMARYSID )
• ugstructureid ( type: esriFieldTypeString, alias: UGStructureID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UGStructureID )
• slat ( type: esriFieldTypeString, alias: slat, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLAT )
• substation ( type: esriFieldTypeString, alias: substation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUBSTATION )
• feeder_name ( type: esriFieldTypeString, alias: FEEDER_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FEEDER_NAME )
• location ( type: esriFieldTypeString, alias: location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• dtr_satructure_code ( type: esriFieldTypeString, alias: DTR_SATRUCTURE_CODE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DTR_SATRUCTURE_CODE )
• rmu_no ( type: esriFieldTypeString, alias: rmu_no, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RMU_NO )
• subtype ( type: esriFieldTypeSmallInteger, alias: subtype, editable: true, nullable: true, defaultValue: 0, modelName: SUBTYPE )
• feeder_id ( type: esriFieldTypeString, alias: feeder_id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FEEDER_ID )
• enabled ( type: esriFieldTypeSmallInteger, alias: enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• pole_painting_code ( type: esriFieldTypeString, alias: pole_painting_code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: POLE_PAINTING_CODE )
• rmu_id ( type: esriFieldTypeString, alias: rmu_id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RMU_ID )
• dtr_sap_structure_code ( type: esriFieldTypeString, alias: dtr_sap_structure_code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DTR_SAP_STRUCTURE_CODE )
• commisioning_date ( type: esriFieldTypeDate, alias: commisioning_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMMISIONING_DATE )
• last_surveyed_date ( type: esriFieldTypeDate, alias: last_surveyed_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_SURVEYED_DATE )

Types:

ID: 0
Name:
Domains:
• enabled:
  Inherited
Templates:
• Name:
  Description:
  Prototype:
  commisioning_date: null
  last_surveyed_date: null
  circle_name: null
  circle_id: null
  division_name: null
  division_id: null
  sub_division_name: null
  sub_division_id: null
  section_name: null
  section_id: null
  tr_id: null
  ptr_yard_id: null
  hv_swbay_id: null
  lv_swbay_id: null
  trans_type: null
  make: null
  serial_number: null
  year_of_mfg: null
  voltage_rating: null
  mva_rating: null
  rated_hv_amps: null
  rated_lv_amps: null
  impedance: null
  no_available_taps: null
  cooling_type: null
  no_cooling_fans: null
  winding_temp_tripvalue: null
  oil_temp_tripvalue: null
  switch_type: null
  slong: null
  created_date: null
  updated_date: null
  updated_by: null
  workorder_id: null
  ltconfigur: null
  ltratedvol: null
  ltvoltage: null
  manufactur: null
  maxtap: null
  mintap: null
  nominalvol: null
  normaltap: null
  normaltapn: null
  operatingv: null
  phasedesig: null
  primarysid: null
  ugstructureid: null
  slat: null
  substation: null
  feeder_name: null
  location: null
  dtr_satructure_code: null
  rmu_no: null
  subtype: 0
  feeder_id: null
  enabled: 1
  pole_painting_code: null
  rmu_id: null
  dtr_sap_structure_code: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Auxiliary Transformer
Domains:
• enabled:
  Inherited
Templates:
• Name: Auxiliary Transformer
  Description:
  Prototype:
  commisioning_date: null
  last_surveyed_date: null
  circle_name: null
  circle_id: null
  division_name: null
  division_id: null
  sub_division_name: null
  sub_division_id: null
  section_name: null
  section_id: null
  tr_id: null
  ptr_yard_id: null
  hv_swbay_id: null
  lv_swbay_id: null
  trans_type: null
  make: null
  serial_number: null
  year_of_mfg: null
  voltage_rating: null
  mva_rating: null
  rated_hv_amps: null
  rated_lv_amps: null
  impedance: null
  no_available_taps: null
  cooling_type: null
  no_cooling_fans: null
  winding_temp_tripvalue: null
  oil_temp_tripvalue: null
  switch_type: null
  slong: null
  created_date: null
  updated_date: null
  updated_by: null
  workorder_id: null
  ltconfigur: null
  ltratedvol: null
  ltvoltage: null
  manufactur: null
  maxtap: null
  mintap: null
  nominalvol: null
  normaltap: null
  normaltapn: null
  operatingv: null
  phasedesig: null
  primarysid: null
  ugstructureid: null
  slat: null
  substation: null
  feeder_name: null
  location: null
  dtr_satructure_code: null
  rmu_no: null
  subtype: 2
  feeder_id: null
  enabled: 1
  pole_painting_code: null
  rmu_id: null
  dtr_sap_structure_code: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Transformer
Domains:
• enabled:
  Inherited
Templates:
• Name: Transformer
  Description:
  Prototype:
  commisioning_date: null
  last_surveyed_date: null
  circle_name: null
  circle_id: null
  division_name: null
  division_id: null
  sub_division_name: null
  sub_division_id: null
  section_name: null
  section_id: null
  tr_id: null
  ptr_yard_id: null
  hv_swbay_id: null
  lv_swbay_id: null
  trans_type: null
  make: null
  serial_number: null
  year_of_mfg: null
  voltage_rating: null
  mva_rating: null
  rated_hv_amps: null
  rated_lv_amps: null
  impedance: null
  no_available_taps: null
  cooling_type: null
  no_cooling_fans: null
  winding_temp_tripvalue: null
  oil_temp_tripvalue: null
  switch_type: null
  slong: null
  created_date: null
  updated_date: null
  updated_by: null
  workorder_id: null
  ltconfigur: null
  ltratedvol: null
  ltvoltage: null
  manufactur: null
  maxtap: null
  mintap: null
  nominalvol: null
  normaltap: null
  normaltapn: null
  operatingv: null
  phasedesig: null
  primarysid: null
  ugstructureid: null
  slat: null
  substation: null
  feeder_name: null
  location: null
  dtr_satructure_code: null
  rmu_no: null
  subtype: 1
  feeder_id: null
  enabled: 1
  pole_painting_code: null
  rmu_id: null
  dtr_sap_structure_code: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• D_HTCustomer (0) -- Related To: D_HTCustomer (0)
• D_FEEDER_PILLAR (15) -- Related To: D_FEEDER_PILLAR (34)
• D_LTCustomer (2) -- Related To: D_LTCustomer (1)
• D_RMU (13) -- Related To: D_RMU (24)
• D_PTR_YARD (16) -- Related To: D_PTR_YARD (69)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata