Layer: Existing Pole Inventory (ID:1)

View In: Map Viewer

Name: Existing Pole Inventory

Display Field: POLENUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 32000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"COMPLETE","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"4e86cfce-9af9-49c1-a8ab-76de1965058f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAAUCAYAAACAl21KAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAX9JREFUOI2t0rFLHFEQx/Hvu3fuQZYDERtjoWmSxiK2UYKSoIhYSP6BlEl5SMBjceFkIFocKf0HLOw0ha0g2CSEgKUoqI0HAa9Js2/hzaZR1MudtwtO9+b9+DADU+aJqnz/cVWpTBnnPmcwDBym8G0ckkLQFSzh3G4G9qY1H8BcBu8MaJGJvnKH3NZMC5aA70Wglz0yr/ohndAJMNEZMHBeCDKwmsFeR+94IMdaD6AR2G8NDU1n7fYm8IZKZQPnmsOQFoIARtrtHy3YyeD1c+fiPEBXKE/V6/VnYRhOeu9HrbUuSZIjEbnODYnIlKquAIuqGhhjUFWCINgDlnNBjUbjk6pudfn6CaxAztWMMQr8AQaB36VS6ZcxZjeKooPbTC7IWnvmvf8LfIjj+Khbpi8kIh+991+stQtRFJ32yj0Kici6qs6mafpWRK4fy/aERGRbVUvVavV9rVZz/Sb/D0rGxsJymoaqehHH8RqQ9UO6Qi8uL5tAk7jQYRe/7F71D+PWgGSo+ljjAAAAAElFTkSuQmCC","contentType":"image/png","width":13,"height":15},"value":"NO","label":"No","description":""},{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"857fe01d-bdf4-4190-b9cd-05a23230c265","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAAUCAYAAACAl21KAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAY9JREFUOI2t0jFrFFEUhuH3zh024rAQgp1FOm0sDBYLSRAlJiKSItgEREgVtFyC4DJkYMOBJMVi6R9Ika2SFFaCKIbABhUsRUFtA9lCm51h7xmLsKDrbGYG/LrL/Xg4B47Pf4r/56PWHpvpEz8BLvnK206f5zyiVwqqtVkkjfd8sAAY7tZ8FjqvmGMeLT5RyiYDZBDDrVqXxQ4cFIfgSmYj5WoeMgx9Bq4NF/rwrRRk4ZmD/SH804ef+Wv9BR0t83J6d2LW0d0Gpi1jWxeIW6ySlILOsG7nRptdP+X60XIcFQEyoSJpNBoXgyCYcs5dttbGvV7vUEROC0MiMqOqa8B9Va0YY1BVKpXKPrBUCGo2m49V9UXG1zGwBgVXM8YocAKMAx89z3tvjNkLw/D1oFMIstZ+dc79Ah5EUXSY1cmFRGTFOffUWnsvDMMvo3rnQiKyoaq3kyS5KSKn53VHQiKyo6petVq9U6/X47zJ/4Gq/cnAeUmgqt+jKFoH0jwkE3rz8EcLaL2j1GGXv+xR+Q0n54bpYQx+PAAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":15},"value":"YES","label":"Yes","description":""}]},"transparency":0}
HasZ: false

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

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
POLENUMBER (type: esriFieldTypeString, alias: Pole Number (only if on pole, usually not on signal poles), SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PBOT: PBOT], [ODOT: ODOT], [TRIMET: Tri-Met], ... 7 more ...)
LGPOLESTYLE (type: esriFieldTypeString, alias: Large Traffic Signal Pole, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [SINGLEMAST: Single Mast Arm (No Street Light)], [COMBMAST: Combination Mast Arm (Signal Arm + Street Light)], [DUALMAST: Dual Mast Arm (2 Signal Arms, Opt Street Light)], ... 5 more ...)
SMPOLESTYLE (type: esriFieldTypeString, alias: Small Traffic Signal Poles, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [PEDPUSHBUTTON: Pedestrian Pushbutton Pedestal (short height about 4ft, 4.5 in OD, pole w/ pushbuttons)], [PEDSIGNAL: Pedestrian Signal Pedestal (tall height about 8ft, usually 4.5 in OD, pole w/ pedestrian signals, sometimes also pushbuttons)], [VEHICLESIG: Vehicle Signal Pedestal (even taller about 12ft, usually 4.5 in OD, w/ vehicle signal head, sometimes ped signals and pushbuttons)])
STLIGHTPOLE (type: esriFieldTypeString, alias: Street Light Pole, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [BOTTLENECK: Bottleneck], [SINGORNAMENTAL: Single Ornamental], [TWINORNAMENTAL: Twin Ornamental], ... 7 more ...)
MATERIAL (type: esriFieldTypeString, alias: Pole Material, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [STEEL: Steel], [ALUMINUM: Aluminum (check with magnet)], [WOOD: Wood], ... 3 more ...)
SIGNALRELATE (type: esriFieldTypeString, alias: Part of Traffic Signal, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
SPANWIRE (type: esriFieldTypeSmallInteger, alias: Qty Span Wire Attached, SQL Type: sqlTypeOther, nullable: true, editable: true)
PEDSIGNAL (type: esriFieldTypeSmallInteger, alias: Qty Pedestrian Signal, SQL Type: sqlTypeOther, nullable: true, editable: true)
PUSHBUTTON (type: esriFieldTypeSmallInteger, alias: Qty Pedestrian Pushbuttons, SQL Type: sqlTypeOther, nullable: true, editable: true)
SIGNS (type: esriFieldTypeSmallInteger, alias: Qty Signs, SQL Type: sqlTypeOther, nullable: true, editable: true)
VEHSIGNAL (type: esriFieldTypeString, alias: Vehicle Signal (only if on vertical), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
STLIGHT (type: esriFieldTypeString, alias: Street Light (or street light mast), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
CONTROLCAB (type: esriFieldTypeString, alias: Signal Controller Cabinet (typically 337 or 336), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
UTILITYDISCONNECT (type: esriFieldTypeString, alias: PGE/PPL Electrical Service Disconnect, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
CABINETOTHER (type: esriFieldTypeString, alias: Other Electrical Cabinet (often lighting or v-tag controller), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
CAMERA (type: esriFieldTypeString, alias: PTZ Camera, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
BLUETOOTH (type: esriFieldTypeString, alias: Bluetooth or Other Radio, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
TRANSFORMER (type: esriFieldTypeString, alias: Transformer Base, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
BANNERS (type: esriFieldTypeString, alias: Banners Mast, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
FLOWERBASKET (type: esriFieldTypeString, alias: Flower Basket Mast, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
COLOR (type: esriFieldTypeString, alias: Pole Color, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [BLACK: Black], [BLUE: Blue], [BRONZE: Bronze], ... 8 more ...)
ASSETID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DATE (type: esriFieldTypeDate, alias: Date of Inventory, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 750, nullable: true, editable: true)
COMPLETE (type: esriFieldTypeString, alias: Inventory Complete, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
PHOTOCELL (type: esriFieldTypeString, alias: Light Photocell, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
STCARTRANSFORMER (type: esriFieldTypeString, alias: Streetcar Transformer, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
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 (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)
RecordDrawing (type: esriFieldTypeString, alias: Record Drawings, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Condition (type: esriFieldTypeString, alias: Physical Condition, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [VeryGood: Very Good], [Good: Good], [Fair: Fair], ... 3 more ...)
ConditionDescription (type: esriFieldTypeString, alias: Condition Description, SQL Type: sqlTypeOther, length: 750, nullable: true, editable: true)

Types:

Field Name: OWNER
Inherited
Field Name: LGPOLESTYLE
Inherited
Field Name: SMPOLESTYLE
Inherited
Field Name: STLIGHTPOLE
Inherited
Field Name: MATERIAL
Inherited
Field Name: SIGNALRELATE
Inherited
Field Name: VEHSIGNAL
Inherited
Field Name: STLIGHT
Inherited
Field Name: CONTROLCAB
Inherited
Field Name: UTILITYDISCONNECT
Inherited
Field Name: CABINETOTHER
Inherited
Field Name: CAMERA
Inherited
Field Name: BLUETOOTH
Inherited
Field Name: TRANSFORMER
Inherited
Field Name: BANNERS
Inherited
Field Name: FLOWERBASKET
Inherited
Field Name: COLOR
Inherited
Field Name: COMPLETE
Inherited

COMPLETE: NO

Field Name: OWNER
Inherited
Field Name: LGPOLESTYLE
Inherited
Field Name: SMPOLESTYLE
Inherited
Field Name: STLIGHTPOLE
Inherited
Field Name: MATERIAL
Inherited
Field Name: SIGNALRELATE
Inherited
Field Name: VEHSIGNAL
Inherited
Field Name: STLIGHT
Inherited
Field Name: CONTROLCAB
Inherited
Field Name: UTILITYDISCONNECT
Inherited
Field Name: CABINETOTHER
Inherited
Field Name: CAMERA
Inherited
Field Name: BLUETOOTH
Inherited
Field Name: TRANSFORMER
Inherited
Field Name: BANNERS
Inherited
Field Name: FLOWERBASKET
Inherited
Field Name: COLOR
Inherited
Field Name: COMPLETE
Inherited

COMPLETE: YES

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/8/2024 4:11:08 PM

Schema Last Edit Date: 8/8/2024 4:11:08 PM

Data Last Edit Date: 8/8/2024 4:11:08 PM

Supported Operations: Query Query Top Features Query Analytic Query Bins Query Attachments Update Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat