Layer: Existing Pole Inventory

View In: Map Viewer

Name: Existing Pole Inventory - Ornamental

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":"simple","label":"","description":"","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"4343d2ae-850f-4035-9311-79c4e5baf96b","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAAUCAYAAACAl21KAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAXlJREFUOI2tzz1II1EUhuH3TIbRaLMsdtuvjYXbqsiKP4ssFiKojYOZgGgZRLDRwma1CBYpbHJTWZhKLawEQbBRRLSUFbQWjBIbZ4o5Nop/iTOz7Nfde7/7cI7Nf4r9+qDlhk7FnxFoAfYJWJUJHhJBWmYI/E2B1NPVLxwGdJde6SdMMtEfXpDn/KTCELCdBPpep9MahbyHzoG2Dw3hMhkkzKNsvcPPuIte6w0ko+zoxtcupLICdCgNy6J+XqYIkk0EyHjlUMtsAO3WmL8YB6gJxUmhUGhKp9M/LMv6Foah7zjOgeu6N7GhYrHYKSKzwG/AUVVEhCAItoDhWJAxZhpYq/F0lEqlZiH+aiFwDXwBToBjEdn0PG/vuRALEpELVb0XkRHP8w5qdSIhY8wkMGdZ1mAmk/lbr/cpZIxZAnps2+52Xffms25dqFQqrauqVa1W+3K5nB8x+EfI1/ZmW26bgatsNrsAaBRSE2ocP80DefDi/K8P/WseAd8KbBaZS17cAAAAAElFTkSuQmCC","contentType":"image/png","width":13,"height":15}},"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:

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)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/27/2020 4:48:00 PM

Schema Last Edit Date: 3/27/2020 4:48:00 PM

Data Last Edit Date: 3/27/2020 4:48:00 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

Layer: Existing Pole Inventory - Ornamental (ID:0)