Name: PBWORKS_Pole

Display Field: POLENUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1011027.42592741
YMin: 1822486.90197032
XMax: 1051009.15698741
YMax: 1877516.74630674
Spatial Reference: 3443 (3443)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[67,140,40,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

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: POLENUMBER, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SUBTYPE (type: esriFieldTypeString, alias: SUBTYPE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [SL: Street Light Pole], [UPL: Utility Pole with Light], [TLP: Traffic Light Pole], ... 8 more ...)
• MaintenanceResponsibility (type: esriFieldTypeString, alias: MAINTENANCERESPONSIBILITY, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1YR: 1 Year Maintenance], [CED: ComED], [CY: County], ... 14 more ...)
• MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [AL: Aluminum], [CON: Concrete], [FIB: Fiberglass], ... 4 more ...)
• FINISH (type: esriFieldTypeString, alias: FINISH, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [BL: Black], [BR: Brown], [UF: Unfinished], ... 3 more ...)
• POLEHEIGHT (type: esriFieldTypeString, alias: POLEHEIGHT, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [8: 8 Ft], [12: 12 Ft], [20: 20 Ft], ... 11 more ...)
• ARMDESIGN (type: esriFieldTypeString, alias: ARMDESIGN, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [SD: Single Davit], [ST: Single Truss], [SM: Single Mast], ... 10 more ...)
• ARMLENGTH (type: esriFieldTypeString, alias: ARMLENGTH, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [10: 10 Ft], [12: 12 Ft], [4: 4 Ft], ... 7 more ...)
• WATTAGE (type: esriFieldTypeString, alias: WATTAGE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [60: 60 watt], [70: 70 watt], [94: 94 watt], ... 34 more ...)
• BREAKAWAY (type: esriFieldTypeString, alias: BREAKAWAY, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: None], [T: T-Base], [U: Unknown], ... 1 more ...)
• BREAKAWAYCOVER (type: esriFieldTypeString, alias: BREAKAWAYCOVER, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [AL: Aluminum], [FB: Fiberglass], [UNK: Unknown], ... 2 more ...)
• BOLTCIRCLE (type: esriFieldTypeString, alias: BOLTCIRCLE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [10.5: 10.5], [11.5: 11.5], [15: 15], ... 1 more ...)
• MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [GE: GE], [HAP: Hapco], [LTK: Leotek], ... 4 more ...)
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• METHOD (type: esriFieldTypeString, alias: METHOD, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [GPS: GPS], [SCR: Screen Digitize], [UNK: Unknown])
• SOURCE (type: esriFieldTypeString, alias: SOURCE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [AS: As-Built], [DPW: DPW Field Crew], [CON: City of Naperville Map], ... 5 more ...)
• BULBTYPE (type: esriFieldTypeString, alias: BULBTYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yellow], [W: White], [U: Unknown], ... 2 more ...)
• FESTUNES (type: esriFieldTypeString, alias: FESTUNES, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [U: Unk])
• CONTROLSOURCE (type: esriFieldTypeString, alias: CONTROLSOURCE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [CON: Controller], [DIS: Disconnect], [PED: Pedestal], ... 3 more ...)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WIRELESSTRANSMITTER (type: esriFieldTypeString, alias: WIRELESSTRANSMITTER, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ANT: Antennae], [CAM: Camera], [EREP: Electric Repeater], ... 4 more ...)
• FOUNDATION (type: esriFieldTypeString, alias: FOUNDATION, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [CON: Concrete], [HEL: Helix], [DB: Direct Burial], ... 1 more ...)
• LAMPTYPE (type: esriFieldTypeString, alias: LAMPTYPE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [BL: Blue], [CH: Ceramic Metal Halide], [HPS: High Pressure Sodium], ... 6 more ...)
• POLELABLED (type: esriFieldTypeString, alias: POLELABLED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown], ... 2 more ...)
• LUMLUMINAIRDESIGN (type: esriFieldTypeString, alias: LUMLUMINAIRDESIGN, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [CML: CML], [COB: Cobra Head], [COO: Coolie Hat], ... 18 more ...)
• DATEVERIFIED (type: esriFieldTypeDate, alias: DATEVERIFIED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROADCLASS (type: esriFieldTypeString, alias: ROADCLASS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Art: Arterial], [Res: Residential], [CBD: CBD], ... 3 more ...)
• LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GRIDNUMBER (type: esriFieldTypeString, alias: Grid Number, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RELAMPYEAR (type: esriFieldTypeDate, alias: Last Relamp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• VERIFIEDBY (type: esriFieldTypeString, alias: Verified By, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [LOC: Locators], [CONT: Contractors], [ASBLT: As-Built], ... 1 more ...)
• QUADRANT (type: esriFieldTypeString, alias: Quadrant, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [1: I], [2: II], [3: III], ... 1 more ...)
• CONTROLNUMBER (type: esriFieldTypeString, alias: CONTROLNUMBER, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• LUMCOLOR (type: esriFieldTypeString, alias: LUMCOLOR, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [BLK: Black], [UNK: Unknown], [NA: N/A], ... 2 more ...)
• RN_ROADCLASS (type: esriFieldTypeSmallInteger, alias: RN_ROADCLASS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [10: Interstate/Tollway/Freeway], [20: Ramp], [30: Major Arterial], ... 5 more ...)
• RN_OWNER (type: esriFieldTypeString, alias: RN_OWNER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LOCDES (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ISL: Island], [ROW: ROW], [STOP: Stop], ... 6 more ...)
• LOCDIR (type: esriFieldTypeString, alias: Location Direction, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: North], [S: South], [E: East], ... 5 more ...)
• SCENARIO (type: esriFieldTypeString, alias: SCENARIO, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [A1: A1], [A2: A2], [A3: A3], ... 7 more ...)
• PKGID (type: esriFieldTypeString, alias: PKGID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• DIST (type: esriFieldTypeString, alias: DIST, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [TYPE 1: TYPE 1], [TYPE II: TYPE II], [TYPE III: TYPE III], ... 6 more ...)
• PLAN_B (type: esriFieldTypeString, alias: PLAN_B, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [A1: A1], [A2: A2], [A3: A3], ... 7 more ...)
• WARRANTYDATE (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• VOLTAGE (type: esriFieldTypeString, alias: Voltage, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [120: 120], [240: 240], [480: 480])
• CATALOG_NO (type: esriFieldTypeString, alias: Catalog Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LED_INSTALL (type: esriFieldTypeDate, alias: LED Install, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LUM_MANUF (type: esriFieldTypeString, alias: Lum Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Leotek: Leotek], [GE: GE], [Philips: Philips], ... 5 more ...)
• TENON (type: esriFieldTypeString, alias: TENON, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• BANNER (type: esriFieldTypeString, alias: Banner, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown], ... 13 more ...)
• SMARTGRID (type: esriFieldTypeString, alias: Smart Grid, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• SMALLCELL (type: esriFieldTypeString, alias: Small Cell, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [NA: NA - OWNED BY OTHERS], [NR: NOT RESERVED], [RE: RESERVED - EXCAMERA], ... 9 more ...)
• LOC_ID (type: esriFieldTypeInteger, alias: LOC_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SC_OWNER (type: esriFieldTypeString, alias: SMALL CELL OWNER, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SC_MAINTBY (type: esriFieldTypeString, alias: SMALL CELL MAINT BY, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SC_Status (type: esriFieldTypeString, alias: SC_Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Available: Available], [Proposed: Proposed], [Leased: Leased], ... 3 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: PBWORKS_Pole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Enabled: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/19/2024 7:53:54 PM

Schema Last Edit Date: 6/19/2024 7:53:54 PM

Data Last Edit Date: 6/19/2024 7:53:54 PM

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