Layer: Street Lights (ID:1)

View In: Map Viewer

Name: Street Lights

Display Field: PoleNo

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text: MSA Professional Services

Min. Scale: 13223.176942

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"RateCode","defaultSymbol":{"type":"esriPMS","url":"23cdd9a855893511306b724f37f1bf5e","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA70lEQVQokY3QMUoDURAG4H9wi7cIKbfLCYJg6wW2WhiGEOxELIRgYw4gFqm0sbfyAMLyYKsF7yDsLewfbPFmnk02aMwmTjcM3/zDZBgpESlCCKFt27Bvno1BVX1wzhUALv8NmfkspcQAplVVvTZN83EUikgRY1wR0RQAiGgtIl1d118HoZktiGg+9ER0oarXAJ5HoYgUqroEMNnZdyUibz9Tf0EzWwCY7V4BYBZjvAPw+AduHrLcg4aT75n53XvfbWFZlqcppduRtKEmZrYCcLOFzrlzAHwADalzZn7x3ncZAPR9/5nn+dMxuMEnAPANXwBS3ldWy1IAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"defaultLabel":"Undefined Rate Code","uniqueValueGroups":[{"heading":"","classes":[{"label":"Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy","description":"Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy","symbol":{"type":"esriPMS","url":"56095b94815a894ef24fc0db15a6b288","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABL0lEQVQokWNhwAECAwPFvn79+nXXrl1fscmz4NKocM+i9g/LT7FdDLvCidbo7++vK3vCwJ/5L6usj4/PrC1btuwlqDEwMFBM7qFxofAHBVmOn7wMmg+cm1kDWS+vX7/+FV6Noi/UQhUfmwdz/OSFOPmpmeU7vicJDAwMXTg1BgYGisme18+UfK3NBxMTea/IoPDMOC4wMHABsq0oGkVfqIVKvdLRRneF1Csd7QdvTmYzMDDUY2j09/fXlb2on8nzTQRdHwPPNxEGlQf2Bf7+D9Zs3LjxMlyjm5sbt9IDqzRstsGA3DNDvhei1woZGDYmwTXKftc3EHmv6M/AwMDwhesNLr0Mss8Ngv39/fs3btx4mYWBgYHhMefFC8zSTJ0Ppc/i1AQD0s+0mRkYNjIAAB4JYUjUYB1RAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"values":[["Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy"]]},{"label":"GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton","description":"GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton","symbol":{"type":"esriPMS","url":"64257ccfecc5bbd1041fe9ccad77f3a8","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABLklEQVQokY3Ov0sCcRgG8OfuvndUppPdIkIuLqdoCP1aGoKbhJcXkbaIhkBa8g+IhqZa2pv6AwL5gtOBew1RctAYF5WJCTZ0xg1Jk1LmVc/4vHx4XoGQMLPp+77vOI4/6S7C4J26vC+igQk4G/+GRJS90PP0AT1ZLBZP6/V640/IzOa9Uqi+avPJQInCm1o/ZNbdWq3W+RW2kS4/GEulQIkCAJ70xZXY4HELwHEoZGbz2shVXoQVG3Y9LYWWXthk5rOvq99gG+lyR8tY4190tIzVxeUugIMfkIiyTSNX6avxcYe+GodnrO0ReedSSncEbduOeGJ1Z9LaMC2xEJvTbquA3B7B99lcvidSBAAzg26YxbORLxHRiZTSFQAw/da8SUTUowSuQtFoWbE0QOITPqlbE5WYjugAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"values":[["GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton"]]},{"label":"SL1 - Pole and Fixture Owned by and Maintained by Madison Gas","description":"SL1 - Pole and Fixture Owned by and Maintained by Madison Gas","symbol":{"type":"esriPMS","url":"cf485fdc037d8c7e5d28ec1ae333444e","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABMUlEQVQokY3OsUsCYRgG8Ae7GyrO6bpFBG+55U6+kwM1FwfB6eDjRaQtoiGQlvwDoqGplvam/oBAPnA6aM9B6hAc4yIzMcGWM24ImpQyr3rG5+XH80qICRFpYRiGnueFq+5SHCwWH46jSNI8Dzv/hpzzrG3fcln+SLuue9lut2/+hESkOc5jM5N5SytKhEolOJVl6rVarfGv0DBG9ULhqaYoEQAgn3/eHgySewDOYyERaYzdNUzzNTnvdH0KxxnuEtHV19Vv0DBGdcsam8tfWNbY7HQmhwBOfkDOeZYxv6Gqs2UHVZ2hXA6OgoBfCyF6C1itVjdLpeBg1do8udww2e9vNYXA/gIy9m7r+pQDwGSyEWdh2y81zvmFEKInAYDvr98nEqmzbjcVi+YxzeGaEMAnqXtkuxG/BPsAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"values":[["SL1 - Pole and Fixture Owned by and Maintained by Madison Gas"]]},{"label":"SL2 - Pole and Fixture Owned by and Maintained by Middleton","description":"SL2 - Pole and Fixture Owned by and Maintained by Middleton","symbol":{"type":"esriPMS","url":"f93ba43215d43ff68d4352f5c6346d84","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABLUlEQVQokY3Ov0sCcRgG8Mc6+4lOdosIubicoiH0a2kIbjp4eRFpi2gIpCX/gGhoqqW9qT8gkC84HbjXECVCY1xUJibYctahd9+GUMq86hmflw/Pq8AnzKzatm2bpmmPuit+sLt8tz/pKCpMbPwbElHKy1wQgm7MMIzTcrlc+RMys9rL3hfl/GsMIQeBdeuQg1wrlUrNX2E30chj6SGHkPNZLD6tuI/hLQDHvpCZ1V76uiC1l3C/k/E2kK1vMvPZ19VvsJto5JFsasNfyGRT6122dgEc/IBElPLS1YKMdIYdEOkAa9YeWXQuhKgNoK7rs+6qtTNqbbC6UA97t3NFCGwP4FT6LSPjbZIA0Jrxs5CZ5xwRnQghagoAvFenbybGoke4ivqifgJafRwC+AAJvmx9Cw3gUwAAAABJRU5ErkJggg==","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"values":[["SL2 - Pole and Fixture Owned by and Maintained by Middleton"]]},{"label":"SL3 - Pole and Fixture Owned by Middleton and Maintained by Madison Gas","description":"SL3 - Pole and Fixture Owned by Middleton and Maintained by Madison Gas","symbol":{"type":"esriPMS","url":"b2876394a97cd6c4b06418e5f61d2874","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABL0lEQVQokY3Ov0sCcRgG8Ic6Bwtv0lsOIReXUzSEfi0NgZPw8iLSFtEQSEv+AdHQVEt7U39AIF9wOmi3IUyERvmKeR6ncC53coPQpJR51TM+Lx+eV0FImFnzPM8zTdNbdVfC4F63exUoimYCx/+GRJTNN5sUmc2SpVLpodFoPP8JmVkr9Hq1rckkGQsCHEl5E2Hu1Ot151eYtu3Kbr9fjgUBAGBnMNj/UNVTAHehkJm1XKtVNUYjdd6lXBcFyzph5sevq99g2rYrGccxlr/IOI7xMh5fALj+AYkom2u3q3HfX3aI+z4OpbyURE9CiM4CFovFzQMpz1etzbNtWep7IlETwNkC5qbTfMp1CQDGGxthFvnhsExE90KIjgIA7Wj0bU3Xb191PRTNY1jWugDwCfkrczuZdzIXAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"values":[["SL3 - Pole and Fixture Owned by Middleton and Maintained by Madison Gas"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"56095b94815a894ef24fc0db15a6b288","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABL0lEQVQokWNhwAECAwPFvn79+nXXrl1fscmz4NKocM+i9g/LT7FdDLvCidbo7++vK3vCwJ/5L6usj4/PrC1btuwlqDEwMFBM7qFxofAHBVmOn7wMmg+cm1kDWS+vX7/+FV6Noi/UQhUfmwdz/OSFOPmpmeU7vicJDAwMXTg1BgYGisme18+UfK3NBxMTea/IoPDMOC4wMHABsq0oGkVfqIVKvdLRRneF1Csd7QdvTmYzMDDUY2j09/fXlb2on8nzTQRdHwPPNxEGlQf2Bf7+D9Zs3LjxMlyjm5sbt9IDqzRstsGA3DNDvhei1woZGDYmwTXKftc3EHmv6M/AwMDwhesNLr0Mss8Ngv39/fs3btx4mYWBgYHhMefFC8zSTJ0Ppc/i1AQD0s+0mRkYNjIAAB4JYUjUYB1RAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"value":"Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy","label":"Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy"},{"symbol":{"type":"esriPMS","url":"64257ccfecc5bbd1041fe9ccad77f3a8","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABLklEQVQokY3Ov0sCcRgG8OfuvndUppPdIkIuLqdoCP1aGoKbhJcXkbaIhkBa8g+IhqZa2pv6AwL5gtOBew1RctAYF5WJCTZ0xg1Jk1LmVc/4vHx4XoGQMLPp+77vOI4/6S7C4J26vC+igQk4G/+GRJS90PP0AT1ZLBZP6/V640/IzOa9Uqi+avPJQInCm1o/ZNbdWq3W+RW2kS4/GEulQIkCAJ70xZXY4HELwHEoZGbz2shVXoQVG3Y9LYWWXthk5rOvq99gG+lyR8tY4190tIzVxeUugIMfkIiyTSNX6avxcYe+GodnrO0ReedSSncEbduOeGJ1Z9LaMC2xEJvTbquA3B7B99lcvidSBAAzg26YxbORLxHRiZTSFQAw/da8SUTUowSuQtFoWbE0QOITPqlbE5WYjugAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"value":"GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton","label":"GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton"},{"symbol":{"type":"esriPMS","url":"cf485fdc037d8c7e5d28ec1ae333444e","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABMUlEQVQokY3OsUsCYRgG8Ae7GyrO6bpFBG+55U6+kwM1FwfB6eDjRaQtoiGQlvwDoqGplvam/oBAPnA6aM9B6hAc4yIzMcGWM24ImpQyr3rG5+XH80qICRFpYRiGnueFq+5SHCwWH46jSNI8Dzv/hpzzrG3fcln+SLuue9lut2/+hESkOc5jM5N5SytKhEolOJVl6rVarfGv0DBG9ULhqaYoEQAgn3/eHgySewDOYyERaYzdNUzzNTnvdH0KxxnuEtHV19Vv0DBGdcsam8tfWNbY7HQmhwBOfkDOeZYxv6Gqs2UHVZ2hXA6OgoBfCyF6C1itVjdLpeBg1do8udww2e9vNYXA/gIy9m7r+pQDwGSyEWdh2y81zvmFEKInAYDvr98nEqmzbjcVi+YxzeGaEMAnqXtkuxG/BPsAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"value":"SL1 - Pole and Fixture Owned by and Maintained by Madison Gas","label":"SL1 - Pole and Fixture Owned by and Maintained by Madison Gas"},{"symbol":{"type":"esriPMS","url":"f93ba43215d43ff68d4352f5c6346d84","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABLUlEQVQokY3Ov0sCcRgG8Mc6+4lOdosIubicoiH0a2kIbjp4eRFpi2gIpCX/gGhoqqW9qT8gkC84HbjXECVCY1xUJibYctahd9+GUMq86hmflw/Pq8AnzKzatm2bpmmPuit+sLt8tz/pKCpMbPwbElHKy1wQgm7MMIzTcrlc+RMys9rL3hfl/GsMIQeBdeuQg1wrlUrNX2E30chj6SGHkPNZLD6tuI/hLQDHvpCZ1V76uiC1l3C/k/E2kK1vMvPZ19VvsJto5JFsasNfyGRT6122dgEc/IBElPLS1YKMdIYdEOkAa9YeWXQuhKgNoK7rs+6qtTNqbbC6UA97t3NFCGwP4FT6LSPjbZIA0Jrxs5CZ5xwRnQghagoAvFenbybGoke4ivqifgJafRwC+AAJvmx9Cw3gUwAAAABJRU5ErkJggg==","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"value":"SL2 - Pole and Fixture Owned by and Maintained by Middleton","label":"SL2 - Pole and Fixture Owned by and Maintained by Middleton"},{"symbol":{"type":"esriPMS","url":"b2876394a97cd6c4b06418e5f61d2874","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABL0lEQVQokY3Ov0sCcRgG8Ic6Bwtv0lsOIReXUzSEfi0NgZPw8iLSFtEQSEv+AdHQVEt7U39AIF9wOmi3IUyERvmKeR6ncC53coPQpJR51TM+Lx+eV0FImFnzPM8zTdNbdVfC4F63exUoimYCx/+GRJTNN5sUmc2SpVLpodFoPP8JmVkr9Hq1rckkGQsCHEl5E2Hu1Ot151eYtu3Kbr9fjgUBAGBnMNj/UNVTAHehkJm1XKtVNUYjdd6lXBcFyzph5sevq99g2rYrGccxlr/IOI7xMh5fALj+AYkom2u3q3HfX3aI+z4OpbyURE9CiM4CFovFzQMpz1etzbNtWep7IlETwNkC5qbTfMp1CQDGGxthFvnhsExE90KIjgIA7Wj0bU3Xb191PRTNY1jWugDwCfkrczuZdzIXAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"value":"SL3 - Pole and Fixture Owned by Middleton and Maintained by Madison Gas","label":"SL3 - Pole and Fixture Owned by Middleton and Maintained by Madison Gas"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,252,244,255],"toColor":[199,252,244,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,251,255],"toColor":[252,179,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,188,179,255],"toColor":[252,188,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,206,252,255],"toColor":[184,206,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,187,255],"toColor":[252,246,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,184,255],"toColor":[184,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,243,255],"toColor":[252,215,243,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[221,252,210,255],"toColor":[221,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,179,252,255],"toColor":[194,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,226,212,255],"toColor":[252,226,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,232,252,255],"toColor":[202,232,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[234,197,252,255],"toColor":[234,197,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,232,255],"toColor":[252,189,232,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: RateCode

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
PoleID (type: esriFieldTypeInteger, alias: Pole ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
PoleNo (type: esriFieldTypeString, alias: Pole No, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ID (type: esriFieldTypeDouble, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
FixtureID (type: esriFieldTypeString, alias: Fixture ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LightType (type: esriFieldTypeString, alias: Light Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Acorn: Acorn], [Carriage: Carriage], [Coach: Coach], ... 5 more ...)
LightModel (type: esriFieldTypeString, alias: Light Model, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [2010SRN120R3FG: 2010SRN120R3FG], [GAL 3: GAL 3], [GAL 5: GAL 5], ... 25 more ...)
BulbType (type: esriFieldTypeString, alias: Bulb Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [HPS: HPS], [LED: LED])
Wattage (type: esriFieldTypeSmallInteger, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [29: 29], [35: 35], [45: 45], ... 11 more ...)
DistToTop (type: esriFieldTypeDouble, alias: Dist To Top, SQL Type: sqlTypeOther, nullable: true, editable: true)
InstallDate (type: esriFieldTypeDate, alias: Fixture Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Fail: Fail], [Damaged: Damaged], ... 7 more ...)
OwnedBy (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City: City], [County: County], [Madison: Madison], ... 3 more ...)
MaintBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City: City], [County: County], [MG&E: MG&E], ... 3 more ...)
EditDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
UserID (type: esriFieldTypeString, alias: User ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
AutoID (type: esriFieldTypeInteger, alias: Auto ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
BulbColor (type: esriFieldTypeString, alias: Bulb Color, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [2000: 2000], [2800: 2800], [4000: 4000], ... 3 more ...)
Provider (type: esriFieldTypeString, alias: Provider, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City: City], [County: County], [MG&E: MG&E], ... 3 more ...)
FixManufacturer (type: esriFieldTypeString, alias: Fixture Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [American Electric: American Electric], [Cyclone Lighting: Cyclone Lighting], [Eclipse Lighting: Eclipse Lighting], ... 5 more ...)
ShutOffLocation (type: esriFieldTypeString, alias: Shut Off Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1703 Deming Way: 1703 Deming Way], [1818 Parmenter St: 1818 Parmenter St], [2002 Parmenter St: 2002 Parmenter St], ... 13 more ...)
Supplier (type: esriFieldTypeString, alias: Supplier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Crescent Electric - XXX-XXX-XXXX: Crescent Electric - XXX-XXX-XXXX], [Enterprise Lighting - 123-456-7890: Enterprise Lighting - 123-456-7890])
ArmStyle (type: esriFieldTypeString, alias: Arm Style, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [2' Square Cross Arm: 2' Square Cross Arm], [Davit: Davit], [Eclipse Armount: Eclipse Armount], ... 7 more ...)
ArmMaterial (type: esriFieldTypeString, alias: Arm Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Aluminum: Aluminum], [Galvanized: Galvanized], [Steel: Steel])
ArmLength (type: esriFieldTypeString, alias: Arm Length, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0'-8": 0'-8"], [10'-0": 10'-0"], [12'-0": 12'-0"], ... 4 more ...)
ArmManufacturer (type: esriFieldTypeString, alias: Arm Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Ameron: Ameron], [Beacon: Beacon], [Cyclone-Lighting: Cyclone-Lighting], ... 6 more ...)
ArmColor (type: esriFieldTypeString, alias: Arm Color, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Aluminum: Aluminum], [Black: Black], [Galvanized: Galvanized], ... 1 more ...)
NumberOfArms (type: esriFieldTypeInteger, alias: Number Of Arms, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2])
ArmInstallDate (type: esriFieldTypeDate, alias: Arm Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
RateCode (type: esriFieldTypeString, alias: Rate Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy: Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy], [GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton: GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton], [SL1 - Pole and Fixture Owned by and Maintained by Madison Gas: SL1 - Pole and Fixture Owned by and Maintained by Madison Gas], ... 2 more ...)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Fixture_ID_Old (type: esriFieldTypeString, alias: Fixture ID (Old), SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
NumberOfFixtures (type: esriFieldTypeInteger, alias: Number of Fixtures, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 1 more ...)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Types:

Field Name: LightType
Inherited
Field Name: LightModel
Inherited
Field Name: BulbType
Inherited
Field Name: Wattage
Inherited
Field Name: Condition
Inherited
Field Name: OwnedBy
Inherited
Field Name: MaintBy
Inherited
Field Name: BulbColor
Inherited
Field Name: Provider
Inherited
Field Name: FixManufacturer
Inherited
Field Name: ShutOffLocation
Inherited
Field Name: Supplier
Inherited
Field Name: ArmStyle
Inherited
Field Name: ArmMaterial
Inherited
Field Name: ArmLength
Inherited
Field Name: ArmManufacturer
Inherited
Field Name: ArmColor
Inherited
Field Name: NumberOfArms
Inherited
Field Name: RateCode
Inherited
Field Name: NumberOfFixtures
Inherited

RateCode: Alliant - Pole and Fixture Owned by Middleton and Power Supplied by Alliant Energy
NumberOfFixtures: 1

Field Name: LightType
Inherited
Field Name: LightModel
Inherited
Field Name: BulbType
Inherited
Field Name: Wattage
Inherited
Field Name: Condition
Inherited
Field Name: OwnedBy
Inherited
Field Name: MaintBy
Inherited
Field Name: BulbColor
Inherited
Field Name: Provider
Inherited
Field Name: FixManufacturer
Inherited
Field Name: ShutOffLocation
Inherited
Field Name: Supplier
Inherited
Field Name: ArmStyle
Inherited
Field Name: ArmMaterial
Inherited
Field Name: ArmLength
Inherited
Field Name: ArmManufacturer
Inherited
Field Name: ArmColor
Inherited
Field Name: NumberOfArms
Inherited
Field Name: RateCode
Inherited
Field Name: NumberOfFixtures
Inherited

RateCode: GF1 - Pole and LED Fixture Owned by Middleton and Maintained by Middleton
NumberOfFixtures: 1

Field Name: LightType
Inherited
Field Name: LightModel
Inherited
Field Name: BulbType
Inherited
Field Name: Wattage
Inherited
Field Name: Condition
Inherited
Field Name: OwnedBy
Inherited
Field Name: MaintBy
Inherited
Field Name: BulbColor
Inherited
Field Name: Provider
Inherited
Field Name: FixManufacturer
Inherited
Field Name: ShutOffLocation
Inherited
Field Name: Supplier
Inherited
Field Name: ArmStyle
Inherited
Field Name: ArmMaterial
Inherited
Field Name: ArmLength
Inherited
Field Name: ArmManufacturer
Inherited
Field Name: ArmColor
Inherited
Field Name: NumberOfArms
Inherited
Field Name: RateCode
Inherited
Field Name: NumberOfFixtures
Inherited

RateCode: SL1 - Pole and Fixture Owned by and Maintained by Madison Gas
NumberOfFixtures: 1

Field Name: LightType
Inherited
Field Name: LightModel
Inherited
Field Name: BulbType
Inherited
Field Name: Wattage
Inherited
Field Name: Condition
Inherited
Field Name: OwnedBy
Inherited
Field Name: MaintBy
Inherited
Field Name: BulbColor
Inherited
Field Name: Provider
Inherited
Field Name: FixManufacturer
Inherited
Field Name: ShutOffLocation
Inherited
Field Name: Supplier
Inherited
Field Name: ArmStyle
Inherited
Field Name: ArmMaterial
Inherited
Field Name: ArmLength
Inherited
Field Name: ArmManufacturer
Inherited
Field Name: ArmColor
Inherited
Field Name: NumberOfArms
Inherited
Field Name: RateCode
Inherited
Field Name: NumberOfFixtures
Inherited

RateCode: SL2 - Pole and Fixture Owned by and Maintained by Middleton
NumberOfFixtures: 1

Field Name: LightType
Inherited
Field Name: LightModel
Inherited
Field Name: BulbType
Inherited
Field Name: Wattage
Inherited
Field Name: Condition
Inherited
Field Name: OwnedBy
Inherited
Field Name: MaintBy
Inherited
Field Name: BulbColor
Inherited
Field Name: Provider
Inherited
Field Name: FixManufacturer
Inherited
Field Name: ShutOffLocation
Inherited
Field Name: Supplier
Inherited
Field Name: ArmStyle
Inherited
Field Name: ArmMaterial
Inherited
Field Name: ArmLength
Inherited
Field Name: ArmManufacturer
Inherited
Field Name: ArmColor
Inherited
Field Name: NumberOfArms
Inherited
Field Name: RateCode
Inherited
Field Name: NumberOfFixtures
Inherited

RateCode: SL3 - Pole and Fixture Owned by Middleton and Maintained by Madison Gas
NumberOfFixtures: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/13/2026 11:23:53 AM

Schema Last Edit Date: 9/21/2026 8:31:53 PM

Data Last Edit Date: 9/21/2026 8:31:41 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Generate Renderer Validate SQL Get Estimates ConvertFormat