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:
XMin: 7616765.26443569
YMin: 667483.795603678
XMax: 7674793.96719161
YMax: 714253.560695544
Spatial Reference: 2913 (2913)
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:
IsSystemMaintained : True
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:
Name: POLE_INVENTORY_ORNAMENTAL
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
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