Name: New Pole Inventory
Display Field: POLENUMBER
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
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: -111333236.70087
YMin: -98152134.1277398
XMax: 127737436.175935
YMax: 94405611.2167764
Spatial Reference: 2913 (2913)
Drawing Info:
{"renderer":{"type":"simple","label":"","description":"","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"6ce8cdef-5aa4-4d79-ab2a-1b58211f8a71","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAYAAAAinad/AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAbRJREFUOI2t0j9oU1EUx/HvfZTXQImUQgtOxcXWig4WRBBBRIoOUjDYvk7egGYSoahgyOKWSdEuDoUkF5VUXRqCU2mghHZzsC6Ce3CQSIWWvIfc4+C/kuaZ+8QzXe7v8LnnwhngP9bA71OmeozIK4CcAD4BT6kHq4mxkcvV6XakNkCGft6fBGaYXVmkFjxOhLV99RDL0IHUUuTcK0Nz7oszhuVMTJ4aHJFTIay7Y/AVGO3ZYdlzgf5gHi+x3OqRt8IjO2+TYYT3ITUFcmFf1h60EoRLuSgZVru+C1xktnoFq2qgltmVe2FjYccV2jcZAIKvtugAVrZpBImgbsy1lDHmuIhMAIc8z2v7vr8WBMGeM1Yul8eVUovAgoiM/bq31tLpdB4Bd5wwY8xVEXkBpHrE7zzPewKO3xSR+S4oUkptAuVWq1XN5/PfnDHgJnCUH8t9O51Of8hkMmF3U1/MGDMG1EXkfRRFN3K5+L37K1YqlSZF5A3wTGv9oN/DsVilUjkPrAB3tdbP+0GxmJ6wp4ECcE1r3XSBYrHDw/aSiJzNZrMfXaGD2OvgM6CK9SREn8n+tb4DbDqU5Rp7KN0AAAAASUVORK5CYII=","contentType":"image/png","width":19.5,"height":22.285714285714292}},"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, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- OWNER (type: esriFieldTypeString, alias: Pole Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- 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 Pole, 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], ... 8 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: Traffic Signal System, 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 ...)
- 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)
- PHOTOCELL (type: esriFieldTypeString, alias: Light Photocell, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- SignalOID (type: esriFieldTypeString, alias: Traffic Signal ObectID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- 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)
- 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)
Templates:
Name: Pole Inventory
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 6/3/2020 10:58:28 PM
Schema Last Edit Date: 6/3/2020 10:58:28 PM
Data Last Edit Date: 6/3/2020 10:58:28 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Query Attachments
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat