Name: Banco De transformadores

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 8ecf11c35f0c405abf6c59cc0c0676b7

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 10000000

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -8610820.4966
YMin: 336876.6609000005
XMax: -8298997.5119
YMax: 587735.7886000015
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [127, 0, 173, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 6
  Label: AGRUPACION MT
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [158, 47, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: BANCO DELTA ABIERTA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [171, 142, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 5
  Label: BANCO DELTA CERRADA
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [90, 0, 150, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: BANCO PARALELO X 2
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 128, 150, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: BANCO PARALELO X 3
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [140, 0, 12, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1
  Label: TRANSFORMADOR SENCILLO
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [153, 0, 77, 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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPE

Fields:

• LAST_SYNC_EAM ( type: esriFieldTypeDate, alias: Ult. Envío a EAM (SAP), length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Subtipo )
• CUSTOM_ID ( type: esriFieldTypeString, alias: Custom ID, length: 15 )
• INTEGRATION_ID ( type: esriFieldTypeString, alias: ID Integración, length: 100 )
• LEGACY_ID ( type: esriFieldTypeString, alias: ID Sistema Anterior, length: 50 )
• PREDESIGN_ID ( type: esriFieldTypeString, alias: ID Prediseño, length: 15 )
• GOVERMENT_ID ( type: esriFieldTypeString, alias: ID Gubernamental, length: 15 )
• NAME ( type: esriFieldTypeString, alias: Matricula, length: 50 )
• ALIAS ( type: esriFieldTypeString, alias: Matricula Alternativa, length: 50 )
• DESCRIPTION ( type: esriFieldTypeString, alias: Descripcion, length: 250 )
• LOCATION_ADDRESS ( type: esriFieldTypeString, alias: Ubicacion, length: 100 )
• GRID_OPERATOR ( type: esriFieldTypeString, alias: Operador de red, length: 5 , Coded Values: [CO00: DESCONOCIDO] , [CO01: CELSIA COLOMBIA S.A. E.S.P.] , [CO02: CETSA E.S.P.] , ...13 more... )
• GRID_DIVISION ( type: esriFieldTypeString, alias: Zona/Sector Empresa, length: 10 , Coded Values: [CO0000: DESCONOCIDO / INDEFINIDO] , [CO0101: CELSIA - VALLE SUR] , [CO0102: CELSIA - VALLE CENTRO] , ...8 more... )
• OWNER ( type: esriFieldTypeString, alias: Propietario, length: 5 , Coded Values: [OR: OPERADOR DE RED] , [TP: TERCERO PARTICULAR] , [TO: TERCERO OFICIAL] , ...7 more... )
• USE_TYPE ( type: esriFieldTypeString, alias: Tipo de Uso, length: 5 , Coded Values: [T: TRANSMISION] , [D: DISTRIBUCION] , [CG: CONEXION GENERACION] , ...7 more... )
• MOUNTING_TYPE ( type: esriFieldTypeString, alias: Tipo de Montaje, length: 1 , Coded Values: [I: INTERNA] , [E: EXTERNA] )
• UNDERGROUND ( type: esriFieldTypeString, alias: Subterraneo?, length: 1 , Coded Values: [Y: SI] , [N: NO] )
• GROUNDED ( type: esriFieldTypeString, alias: Aterrizado?, length: 1 , Coded Values: [Y: SI] , [N: NO] )
• IS_VIRTUAL ( type: esriFieldTypeString, alias: Es un Banco Virtual?, length: 1 , Coded Values: [Y: SI] , [N: NO] )
• OPERATIONAL_ASSEMBLY ( type: esriFieldTypeString, alias: Conjunto del Montaje, length: 15 )
• OPERATING_VOLTAGE ( type: esriFieldTypeString, alias: Voltaje de Operacion, length: 5 , Coded Values: [500K: 500 kV] , [230K: 230 kV] , [115K: 115 kV] , ...11 more... )
• RATED_KVA ( type: esriFieldTypeDouble, alias: Potencia Nominal (kVA) )
• DEMAND_KW ( type: esriFieldTypeDouble, alias: Potencia Demandada (kW) )
• LOAD_PERCENT ( type: esriFieldTypeDouble, alias: Cargabilidad (%) )
• PHASES ( type: esriFieldTypeSmallInteger, alias: Cantidad de fases , Coded Values: [1: 1 FASE (MONOFASICO)] , [2: 2 FASES (BIFASICO)] , [3: 3 FASES (TRIFASICO)] )
• PHASES_SEQUENCE ( type: esriFieldTypeString, alias: Secuencia de Fases, length: 5 , Coded Values: [R: FASE R [A]] , [S: FASE S [B]] , [T: FASE T [C]] , ...12 more... )
• RATED_HIGH_SIDE_VOLTAGE ( type: esriFieldTypeString, alias: Tension Nominal Primario, length: 5 , Coded Values: [500K: 500 kV] , [230K: 230 kV] , [115K: 115 kV] , ...11 more... )
• RATED_LOW_SIDE_VOLTAGE ( type: esriFieldTypeString, alias: Tension Nominal Secundario, length: 10 , Coded Values: [3X254: 3x254/440V] , [3X120: 3x120/208V] , [3X127: 3x127/220V] , ...29 more... )
• HIGH_SIDE_CONFIGURATION ( type: esriFieldTypeString, alias: Configuracion Primario, length: 5 , Coded Values: [I: MONOFASICO] , [Y: TRIFASICO EN ESTRELLA] , [OY: BIFASICO EN ESTRELLA ABIERTA] , ...4 more... )
• LOW_SIDE_CONFIGURATION ( type: esriFieldTypeString, alias: Configuracion Secundario, length: 5 , Coded Values: [I: MONOFASICO] , [Y: TRIFASICO EN ESTRELLA] , [OY: BIFASICO EN ESTRELLA ABIERTA] , ...4 more... )
• LOW_SIDE_PROTECTION ( type: esriFieldTypeString, alias: Proteccion en Secundario, length: 1 , Coded Values: [Y: SI] , [N: NO] )
• INVENTORY_ASSEMBLY_LAW ( type: esriFieldTypeString, alias: Resolucion Inventario de Activos, length: 20 , Coded Values: [COR00972008: RES. CREG 097/2008] , [COR01762016: RES. CREG 176/2016] , [COR00152018: RES. CREG 015/2018] , ...1 more... )
• INVENTORY_ASSEMBLY ( type: esriFieldTypeString, alias: Unidad Constructiva Regulatoria, length: 10 )
• CENTRAL_MEASUREMENT ( type: esriFieldTypeString, alias: Medicion Centralizada, length: 1 , Coded Values: [Y: SI] , [N: NO] )
• MEASUREMENT_SIDE ( type: esriFieldTypeString, alias: Ubicacion de Medida, length: 5 , Coded Values: [HV: LADO DE ALTA TENSION] , [LV: LADO DE BAJA TENSION] )
• LV_GRID_TYPE ( type: esriFieldTypeString, alias: Tipo de Red BT, length: 5 , Coded Values: [OI: ABIERTA AISLADA] , [OB: ABIERTA DESNUDA] , [SL: ACOMETIDA (SERVICE LINE)] , ...6 more... )
• R1_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes R1 )
• R2_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes R2 )
• R3_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes R3 )
• R4_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes R4 )
• R5_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes R5 )
• R6_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes R6 )
• COMERCIAL_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes Comerciales )
• INDUSTRIAL_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes Industriales )
• SPECIAL_FARE_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Clientes con Beneficio tarifario )
• TOTAL_CUSTOMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad Total de Clientes )
• OWN_TRANSFORMER_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Transformadores )
• OTHERS_TRANSFORMER_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad de Otros Transformadores )
• TOTAL_TRANSFORMERS_QTY ( type: esriFieldTypeSmallInteger, alias: Cantidad Total de Transformadores )
• MIN_DEMAND_12H ( type: esriFieldTypeDouble, alias: Demanda MIN 12Hr (kW) )
• MIN_DEMAND_24H ( type: esriFieldTypeDouble, alias: Demanda MIN 24Hr (kW) )
• SGDG_POWER_INSTALLED ( type: esriFieldTypeDouble, alias: Potencia Instalada Gen. Dist. (kW) )
• SGDG_AVAILABILITY_STATUS ( type: esriFieldTypeString, alias: Disponibilidad Gen. Dist., length: 5 , Coded Values: [AVBLE: DISPONIBLE] , [UNAVB: INDISPONIBLE] )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Fecha de instalacion, length: 8 )
• SUMMARY_DISPLAY_RELEVANCE ( type: esriFieldTypeString, alias: Relevante Para ADMS?, length: 1 , Coded Values: [Y: SI] , [N: NO] )
• AOR_GROUP ( type: esriFieldTypeString, alias: Grupos AOR, length: 100 )
• COMMENTS ( type: esriFieldTypeString, alias: Observaciones y Comentarios, length: 1000 )
• FEEDER_ID ( type: esriFieldTypeString, alias: ID Feeder AT-MT, length: 15 )
• SUPPORT_STRUCTURE_ID ( type: esriFieldTypeString, alias: ID Estructura de Soporte, length: 15 )
• SERVICE_LOCATION_ID ( type: esriFieldTypeString, alias: ID SDP (Medida AT-MT), length: 15 )
• CONTRACTS_ID ( type: esriFieldTypeString, alias: ID Contratos, length: 15 )
• TRANSFORMER_BANK_GROUP ( type: esriFieldTypeString, alias: ID TBank Agrupador, length: 15 )
• SYMBOL_ROTATION ( type: esriFieldTypeSingle, alias: Rotación Símbolo )
• LEGACY_VERSION ( type: esriFieldTypeString, alias: Version Sistema Anterior, length: 15 )
• HYPERLINK ( type: esriFieldTypeString, alias: Hipervínculo, length: 1000 )
• CREATOR_USER ( type: esriFieldTypeString, alias: Usuario de Alta, length: 30 )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Fecha de Alta, length: 8 )
• EDITOR_USER ( type: esriFieldTypeString, alias: Usuario de Modificacion, length: 30 )
• EDITION_DATE ( type: esriFieldTypeDate, alias: Fecha de Modificacion, length: 8 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REPLACEMENT_DATE ( type: esriFieldTypeDate, alias: Fecha de Reposicion, length: 8 )
• OLD_INVENTORY_ASSEMBLY ( type: esriFieldTypeString, alias: Unidad Constructiva Regulatoria Anterior, length: 10 )
• PWR_STATUS ( type: esriFieldTypeSmallInteger, alias: Estado de Energización , Coded Values: [1: ENERGIZADO] , [0: DESENERGIZADO] )
• LAST_OUTAGE ( type: esriFieldTypeDate, alias: Fecha Últ. Apagón, length: 8 )
• TUNITS_NAME ( type: esriFieldTypeString, alias: Matr. Transf. Contenidos, length: 250 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Types:

ID: 1
Name: TRANSF. SENCILLO
Domains:
• GRID_OPERATOR:
  Inherited
• GRID_DIVISION:
  Inherited
• OWNER:
  Inherited
• USE_TYPE:
  Inherited
• MOUNTING_TYPE:
  Inherited
• UNDERGROUND:
  Inherited
• GROUNDED:
  Inherited
• IS_VIRTUAL:
  Inherited
• OPERATING_VOLTAGE:
  Inherited
• PHASES:
  Inherited
• PHASES_SEQUENCE:
  Inherited
• RATED_HIGH_SIDE_VOLTAGE:
  Inherited
• RATED_LOW_SIDE_VOLTAGE:
  Inherited
• HIGH_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_PROTECTION:
  Inherited
• INVENTORY_ASSEMBLY_LAW:
  Inherited
• CENTRAL_MEASUREMENT:
  Inherited
• MEASUREMENT_SIDE:
  Inherited
• LV_GRID_TYPE:
  Inherited
• SGDG_AVAILABILITY_STATUS:
  Inherited
• SUMMARY_DISPLAY_RELEVANCE:
  Inherited
• PWR_STATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited

---

ID: 2
Name: BANCO EN PARARELO
Domains:
• GRID_OPERATOR:
  Inherited
• GRID_DIVISION:
  Inherited
• OWNER:
  Inherited
• USE_TYPE:
  Inherited
• MOUNTING_TYPE:
  Inherited
• UNDERGROUND:
  Inherited
• GROUNDED:
  Inherited
• IS_VIRTUAL:
  Inherited
• OPERATING_VOLTAGE:
  Inherited
• PHASES:
  Inherited
• PHASES_SEQUENCE:
  Inherited
• RATED_HIGH_SIDE_VOLTAGE:
  Inherited
• RATED_LOW_SIDE_VOLTAGE:
  Inherited
• HIGH_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_PROTECTION:
  Inherited
• INVENTORY_ASSEMBLY_LAW:
  Inherited
• CENTRAL_MEASUREMENT:
  Inherited
• MEASUREMENT_SIDE:
  Inherited
• LV_GRID_TYPE:
  Inherited
• SGDG_AVAILABILITY_STATUS:
  Inherited
• SUMMARY_DISPLAY_RELEVANCE:
  Inherited
• PWR_STATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited

---

ID: 3
Name: BANCO EN ESTRELLA
Domains:
• GRID_OPERATOR:
  Inherited
• GRID_DIVISION:
  Inherited
• OWNER:
  Inherited
• USE_TYPE:
  Inherited
• MOUNTING_TYPE:
  Inherited
• UNDERGROUND:
  Inherited
• GROUNDED:
  Inherited
• IS_VIRTUAL:
  Inherited
• OPERATING_VOLTAGE:
  Inherited
• PHASES:
  Inherited
• PHASES_SEQUENCE:
  Inherited
• RATED_HIGH_SIDE_VOLTAGE:
  Inherited
• RATED_LOW_SIDE_VOLTAGE:
  Inherited
• HIGH_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_PROTECTION:
  Inherited
• INVENTORY_ASSEMBLY_LAW:
  Inherited
• CENTRAL_MEASUREMENT:
  Inherited
• MEASUREMENT_SIDE:
  Inherited
• LV_GRID_TYPE:
  Inherited
• SGDG_AVAILABILITY_STATUS:
  Inherited
• SUMMARY_DISPLAY_RELEVANCE:
  Inherited
• PWR_STATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited

---

ID: 4
Name: BANCO EN DELTA ABIERTA
Domains:
• GRID_OPERATOR:
  Inherited
• GRID_DIVISION:
  Inherited
• OWNER:
  Inherited
• USE_TYPE:
  Inherited
• MOUNTING_TYPE:
  Inherited
• UNDERGROUND:
  Inherited
• GROUNDED:
  Inherited
• IS_VIRTUAL:
  Inherited
• OPERATING_VOLTAGE:
  Inherited
• PHASES:
  Inherited
• PHASES_SEQUENCE:
  Inherited
• RATED_HIGH_SIDE_VOLTAGE:
  Inherited
• RATED_LOW_SIDE_VOLTAGE:
  Inherited
• HIGH_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_PROTECTION:
  Inherited
• INVENTORY_ASSEMBLY_LAW:
  Inherited
• CENTRAL_MEASUREMENT:
  Inherited
• MEASUREMENT_SIDE:
  Inherited
• LV_GRID_TYPE:
  Inherited
• SGDG_AVAILABILITY_STATUS:
  Inherited
• SUMMARY_DISPLAY_RELEVANCE:
  Inherited
• PWR_STATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited

---

ID: 5
Name: BANCO EN DELTA CERRADA
Domains:
• GRID_OPERATOR:
  Inherited
• GRID_DIVISION:
  Inherited
• OWNER:
  Inherited
• USE_TYPE:
  Inherited
• MOUNTING_TYPE:
  Inherited
• UNDERGROUND:
  Inherited
• GROUNDED:
  Inherited
• IS_VIRTUAL:
  Inherited
• OPERATING_VOLTAGE:
  Inherited
• PHASES:
  Inherited
• PHASES_SEQUENCE:
  Inherited
• RATED_HIGH_SIDE_VOLTAGE:
  Inherited
• RATED_LOW_SIDE_VOLTAGE:
  Inherited
• HIGH_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_PROTECTION:
  Inherited
• INVENTORY_ASSEMBLY_LAW:
  Inherited
• CENTRAL_MEASUREMENT:
  Inherited
• MEASUREMENT_SIDE:
  Inherited
• LV_GRID_TYPE:
  Inherited
• SGDG_AVAILABILITY_STATUS:
  Inherited
• SUMMARY_DISPLAY_RELEVANCE:
  Inherited
• PWR_STATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited

---

ID: 6
Name: AGRUPACIÓN DE RED INTERNA
Domains:
• GRID_OPERATOR:
  Inherited
• GRID_DIVISION:
  Inherited
• OWNER:
  Inherited
• USE_TYPE:
  Inherited
• MOUNTING_TYPE:
  Inherited
• UNDERGROUND:
  Inherited
• GROUNDED:
  Inherited
• IS_VIRTUAL:
  Inherited
• OPERATING_VOLTAGE:
  Inherited
• PHASES:
  Inherited
• PHASES_SEQUENCE:
  Inherited
• RATED_HIGH_SIDE_VOLTAGE:
  Inherited
• RATED_LOW_SIDE_VOLTAGE:
  Inherited
• HIGH_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_CONFIGURATION:
  Inherited
• LOW_SIDE_PROTECTION:
  Inherited
• INVENTORY_ASSEMBLY_LAW:
  Inherited
• CENTRAL_MEASUREMENT:
  Inherited
• MEASUREMENT_SIDE:
  Inherited
• LV_GRID_TYPE:
  Inherited
• SGDG_AVAILABILITY_STATUS:
  Inherited
• SUMMARY_DISPLAY_RELEVANCE:
  Inherited
• PWR_STATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited

---

Relationships:

• Unidades de Transformador 2W (93) -- Related To: Unidades de Transformador 2W (115)
• Feeders BT (94) -- Related To: Alimentador BT (86)
• Proyectos Relacionados (95) -- Related To: Elementos por Proyecto y Viceversa (99)
• Feeder AT-MT (96) -- Related To: Alimentadores AT-MT (85)
• Estructura de Soporte (35) -- Related To: Estructuras de Soporte (2)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata