Name: Underground Transformer Banks
Display Field: FacilityID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 7000
Max. Scale: 0
Default Visibility: true
Max Record Count: 16000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 2411871.89388055
YMin: 1854487.76723218
XMax: 2441153.61550342
YMax: 1865806.14801664
Spatial Reference: 102672 (3436)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"Phase","field2":null,"field3":null,"defaultSymbol":{"type":"esriPMS","url":"deb359c59eb4184e75730b11f391df42","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAAPCAYAAADphp8SAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAPlJREFUOI2d061KREEYBuBnYPGAbJBjEqthsxgMil6AIKjVJIggJlmT4GLwB0WMYvcCBLvVe/AODCe5YYKM4Sy6q/tzdt82wzfPvBOmpkIS9cDnsJlaBWQar4n1QHtyKMtOQoxLOMb5RFBiXozNzrKZeAh8TAJdhPJpUE+c4XAsKOX5oqLY7d4L7CfuA+/VGxXFXXn23/wldipBiS2sDbhiO+X5ciiKt6FQYgrXA5uWbW+wOqrRERaGQqwkNgPPfaHELE5HIGWy7CrF+BL46ge1AjOVoBgb2MNjD5Ro4KAS8ptW4inQ7m50+7dhhczpfJ2fg4GNMZGefAMsMj1kF7l9TwAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":11,"angle":0,"xoffset":0,"yoffset":0},"defaultLabel":"UNK","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"cd6b9479e4dbdc4cb97919b0675c20c5","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAjJJREFUSIm11U9o01AcB/DvC+mOwhgIjQdvE8RbJspgTIuHMVJQetCDu/gn62EgsoM4RaubzIkiOJg086CuqIjgn9Rpi4qz+GdgKRN0iOiYh06RCnVqt/55Pw8uZVnaJm31e0t+733y473kRcR/jLj8gojkekHGWNyCE5EOQKkX55xrgiB0F/GljpVrkRCkJqlmeCG7gI7WTpWINMZY3LQsUpOELS0eAJgrMdedzWXR4GooW3/6+onphlhi0BxjzNQ+59ybL+TvDYb60dd1DC7RFWCMacvHEFESgNsOt4QxdjyWmEDo3QDaEu3wbNwWBKDZzbPFiUj9+XtePq0fBQCcvX8Smze0gnMeNDauJjyXy0kAVD12FzOZSQDAh18xRF89wPatvuLG1YSLoqh8TX2RTzzeZ7o/EO1Fu+xB46rGAABv1fjS6xkci1xGgRZNtXR+FrcnbmGPd79CRHK57it1Hng/M41g4nDJ4uAzFR2bOiGtXhME0OIYJyK5wAvKSHi4wrOBsegVHNrdJ5c7Nsp1Hph88wLjny9WxC9NHcGONh+a167TneLuzGJGOaOfqggbGR0fwZD/vFtggiMc0ZcP8fZHxBF+59MF7JrugrzeuuwW/Hs6hf7IQUewkeHwOYw2X7XHbz66jnR+tir8+bcbiCX2YuXSWHC/rwd+X09VuJGKp+LUx0RNqJFkKmnFGWNxzrl2YGevWpf+N2Hjiy12LghCNxHZHqN2KfkPXVn4F/kDa/fReDKY3SsAAAAASUVORK5CYII=","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"1 PHASE","description":""},{"symbol":{"type":"esriPMS","url":"019bbb1fbdc7595c5aa49914804d36c2","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAtNJREFUSIm11XtMjXEcx/H37ymboWzCdrKWOXNJ/iiFhmJxOHLE/MEOkuuJ/mHDZi47D5JlM5v5x5n7pWRslDlKzC1jynWuU2NyzoxC0s38fv5JO6eedITPX8/zfH/P6/fd77fn9wTzHxPse6OUivtbUAhR3g5XShUCtr/FpZQuTdMyWvGWjm25RccJDwvvMtzY3Ih1bIpDKeUSQpT7LUt4WDgT45MBvAbvmnyuDetXy674PQg2GOQVQvi1L6XUAWf+pTzmWuwIITxCiHjfMUopT5sGDHG/tCyZs+zJXS48OMewyChihsbGKaXifDfPKJ3igN7U3MiZm3nszXSRk5dFtHkE3YK7FQK/3aDf4lLKGYCt+HYRcyYsILRXb1ITZnPt3lUmj7aYlFIOIYSrS7gQwln9+SOPXz/AlphKfUM9o6LHoB/axJjoBEJ6hujAn+NKKQcQl1t8jHTrMhoa61nnWs2uFXtIsyym4MZZ5lvTTFJKXdM0PWC8ZRP1l29eENa7HwP6D+Bk0QmKq/ZTcseGLWkm7tuFeD96MfU1OVs+wIBxh5TSdKzkMOvnbeTd+yr0y0sByLq4lnExidgtaRxxH2DtvPUAAXduEkI4Sh/eYEqslR7de5KTm80P1QRA9fdXnL6Sz/JZKxnYfxDPKp8SNWi44bFh2Pm3hjpK7hfjXLyNsid3yXu+w6++szSTKaNTSBk3nR3Ht6JHZhMUFBQYXnD9LGmTF9H8vZmcgq1GQzjg3seWJduxjJzGrUelJMYmdY57P3j4VFfD4MghVLytwJ6Qjp10wwk+1dYwNmY8+sENxEfFt6u3w48WHWb5jAwAzBFmzBFmQ9g39uSFuG9doE9on47xSk8Fl18WUHfqS6dg27gr89ls3d0x/rWhlg2p2X8MA0yKnYqn2tMeF0KUSyldq+aucXRJ9s/5X6dla+eapmUopTo8JwKN4T+0beFf5Cch8Qsg1SWshQAAAABJRU5ErkJggg==","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0},"value":"3","label":"3 PHASE","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: Phase
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- SubtypeCode (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FacilityID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- LocationID (type: esriFieldTypeString, alias: Location ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PhasingCode (type: esriFieldTypeInteger, alias: Phasing Code, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: A], [2: B], [1: C], ... 4 more ...)
- OperatingVoltage (type: esriFieldTypeInteger, alias: Operating Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [160: 4.16/7.2 kV], [210: 7.2/12.4 kV], [230: 7.6/13.2 kV], ... 3 more ...)
- FeederID (type: esriFieldTypeString, alias: Feeder ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 1 more ...)
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SecVolt (type: esriFieldTypeInteger, alias: Secondary Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [160: 4.16/7.2 kV], [210: 7.2/12.4 kV], [230: 7.6/13.2 kV], ... 3 more ...)
- LabelText (type: esriFieldTypeString, alias: Label Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Phase (type: esriFieldTypeDouble, alias: Phase, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Label_field (type: esriFieldTypeString, alias: Label_field, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- MOBILEUSER (type: esriFieldTypeString, alias: MOBILEUSER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MOBILEDATE (type: esriFieldTypeDate, alias: MOBILEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- RF_SubtypeCode2 (type: esriFieldTypeInteger, alias: Subtype Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RF_BankKVA2 (type: esriFieldTypeDouble, alias: Rated KVA, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 kVa], [5: 5 kVa], [10: 10 kVa], ... 20 more ...)
- RF_Substation (type: esriFieldTypeString, alias: Substation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: AVA], [2: CEN], [3: 14S])
- RF_PrimaryOpen (type: esriFieldTypeInteger, alias: Primary Open, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Feeds Through], [2: Open North], [3: Open South], ... 2 more ...)
- SerialNumber (type: esriFieldTypeString, alias: SerialNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Installer (type: esriFieldTypeString, alias: Installer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- DateEnergized (type: esriFieldTypeDate, alias: DateEnergized, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SecVoltsText (type: esriFieldTypeString, alias: SecVoltsText, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [120240: 120-240], [120208: 120-208], [240480: 240-480], ... 1 more ...)
- NOTES1 (type: esriFieldTypeString, alias: NOTES1, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
- NOTES2 (type: esriFieldTypeString, alias: NOTES2, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
- NOTES3 (type: esriFieldTypeString, alias: NOTES3, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
- NOTES4 (type: esriFieldTypeString, alias: NOTES4, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
- NOTES5 (type: esriFieldTypeString, alias: NOTES5, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
- NOTES6 (type: esriFieldTypeString, alias: NOTES6, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
- NOTES7 (type: esriFieldTypeString, alias: NOTES7, SQL Type: sqlTypeOther, length: 110, nullable: true, editable: true)
- OUT1WIRESIZE (type: esriFieldTypeInteger, alias: OUT1WIRESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 2 AWG], [2: 4 AWG], [3: 6 AWG], ... 7 more ...)
- OUT2WIRESIZE (type: esriFieldTypeInteger, alias: OUT2WIRESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 2 AWG], [2: 4 AWG], [3: 6 AWG], ... 7 more ...)
- OUT3WIRESIZE (type: esriFieldTypeInteger, alias: OUT3WIRESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 2 AWG], [2: 4 AWG], [3: 6 AWG], ... 7 more ...)
- OUT4WIRESIZE (type: esriFieldTypeInteger, alias: OUT4WIRESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 2 AWG], [2: 4 AWG], [3: 6 AWG], ... 7 more ...)
- OUT5WIRESIZE (type: esriFieldTypeInteger, alias: OUT5WIRESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 2 AWG], [2: 4 AWG], [3: 6 AWG], ... 7 more ...)
- OUT6WIRESIZE (type: esriFieldTypeInteger, alias: OUT6WIRESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 2 AWG], [2: 4 AWG], [3: 6 AWG], ... 7 more ...)
- OUT7WIRESIZE (type: esriFieldTypeInteger, alias: OUT7WIRESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 2 AWG], [2: 4 AWG], [3: 6 AWG], ... 7 more ...)
- LINE1TO (type: esriFieldTypeSmallInteger, alias: LINE1TO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: SERVICE], [1: STREETLIGHT], [2: PEDESTAL], ... 1 more ...)
- LINE2TO (type: esriFieldTypeSmallInteger, alias: LINE2TO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: SERVICE], [1: STREETLIGHT], [2: PEDESTAL], ... 1 more ...)
- LINE3TO (type: esriFieldTypeSmallInteger, alias: LINE3TO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: SERVICE], [1: STREETLIGHT], [2: PEDESTAL], ... 1 more ...)
- LINE4TO (type: esriFieldTypeSmallInteger, alias: LINE4TO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: SERVICE], [1: STREETLIGHT], [2: PEDESTAL], ... 1 more ...)
- LINE5TO (type: esriFieldTypeSmallInteger, alias: LINE5TO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: SERVICE], [1: STREETLIGHT], [2: PEDESTAL], ... 1 more ...)
- LINE6TO (type: esriFieldTypeSmallInteger, alias: LINE6TO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: SERVICE], [1: STREETLIGHT], [2: PEDESTAL], ... 1 more ...)
- LINE7TO (type: esriFieldTypeSmallInteger, alias: LINE7TO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: SERVICE], [1: STREETLIGHT], [2: PEDESTAL], ... 1 more ...)
- FEEDFROM (type: esriFieldTypeString, alias: FEEDFROM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Xformer: Transformer], [Pedestal: Pedestal], [Pole: Pole])
- FEEDFROMDIR (type: esriFieldTypeString, alias: FEEDFROMDIR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [North: North], [East: East], [South: South], ... 1 more ...)
- Impedance (type: esriFieldTypeDouble, alias: Impedance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RF_Status (type: esriFieldTypeInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: New], [2: Used])
- RF_PCBSticker (type: esriFieldTypeInteger, alias: RF_PCBSticker, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- MfgDate (type: esriFieldTypeDate, alias: MfgDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABB Power: ABB Power], [Allis Chalmers: Allis Chalmers], [Central Moloney: Central Moloney], ... 15 more ...)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Types:
ID: 1
Name: 1
Domains:
- Field Name: PhasingCode
Inherited
- Field Name: OperatingVoltage
Inherited
- Field Name: FeederID
Inherited
- Field Name: SecVolt
Inherited
- Field Name: RF_BankKVA2
Inherited
- Field Name: RF_Substation
Inherited
- Field Name: RF_PrimaryOpen
Inherited
- Field Name: SecVoltsText
Inherited
- Field Name: OUT1WIRESIZE
Inherited
- Field Name: OUT2WIRESIZE
Inherited
- Field Name: OUT3WIRESIZE
Inherited
- Field Name: OUT4WIRESIZE
Inherited
- Field Name: OUT5WIRESIZE
Inherited
- Field Name: OUT6WIRESIZE
Inherited
- Field Name: OUT7WIRESIZE
Inherited
- Field Name: LINE1TO
Inherited
- Field Name: LINE2TO
Inherited
- Field Name: LINE3TO
Inherited
- Field Name: LINE4TO
Inherited
- Field Name: LINE5TO
Inherited
- Field Name: LINE6TO
Inherited
- Field Name: LINE7TO
Inherited
- Field Name: FEEDFROM
Inherited
- Field Name: FEEDFROMDIR
Inherited
- Field Name: RF_Status
Inherited
- Field Name: RF_PCBSticker
Inherited
- Field Name: Manufacturer
Inherited
Templates:
Name: 1, UG
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Phase: 1
- SubtypeCode: 2
- Type: UG
Name: 1, OH
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Phase: 1
- SubtypeCode: 2
- Type: OH
ID: 3
Name: 3
Domains:
- Field Name: PhasingCode
Inherited
- Field Name: OperatingVoltage
Inherited
- Field Name: FeederID
Inherited
- Field Name: SecVolt
Inherited
- Field Name: RF_BankKVA2
Inherited
- Field Name: RF_Substation
Inherited
- Field Name: RF_PrimaryOpen
Inherited
- Field Name: SecVoltsText
Inherited
- Field Name: OUT1WIRESIZE
Inherited
- Field Name: OUT2WIRESIZE
Inherited
- Field Name: OUT3WIRESIZE
Inherited
- Field Name: OUT4WIRESIZE
Inherited
- Field Name: OUT5WIRESIZE
Inherited
- Field Name: OUT6WIRESIZE
Inherited
- Field Name: OUT7WIRESIZE
Inherited
- Field Name: LINE1TO
Inherited
- Field Name: LINE2TO
Inherited
- Field Name: LINE3TO
Inherited
- Field Name: LINE4TO
Inherited
- Field Name: LINE5TO
Inherited
- Field Name: LINE6TO
Inherited
- Field Name: LINE7TO
Inherited
- Field Name: FEEDFROM
Inherited
- Field Name: FEEDFROMDIR
Inherited
- Field Name: RF_Status
Inherited
- Field Name: RF_PCBSticker
Inherited
- Field Name: Manufacturer
Inherited
Templates:
Name: 3, UG
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Phase: 3
- SubtypeCode: 2
- Type: UG
Name: 3, OH
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Phase: 3
- SubtypeCode: 2
- Type: OH
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/22/2025 3:16:35 PM
Schema Last Edit Date: 7/22/2025 3:16:35 PM
Data Last Edit Date: 7/22/2025 3:16:35 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat