Name: Streetlights

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9812805.523
YMin: 5126742.25991825
XMax: -9812482.0314
YMax: 5129331.2175
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"df20ccac-2b15-4b0e-8784-e78137a41877","imageData":"iVBORw0KGgoAAAANSUhEUgAAACcAAAAnCAYAAACMo1E1AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAFAklEQVRYhd2YXUhbZxjH//nOYvclka0ZRYvZsBe9kMTSL9xdswv1YmNjdjC8srIOBC92ldKEejmEDDaMN4MxZ2+6C1PG3N1k7EIThAmNUKV13eKGohRmnacxZ/zfk6PnHM+Xto7SP0jMyZucX573eZ/n/8SPZ1h+PMPy4zmGC+LN82fxWIrBF4gCtWbIcgW12gpebLyL+Z/mAUj/J1wQb13sg4xuQI7DH25DsEF5xesD5Bogy4C0DcQvrAFyCf9sfIG/yj8cLVzruU/h8fTDFzqNQEiBqau7swOTuWvoGbyBwvQsEAjzchS1nRT8oRSOvbKA6uMs7hdvPl241osJeJGBP9RlhHIU14aPAbUX2iBtTSB+vg+Lv/a42W5nuOYz5+Dz5BFqOA1fwBnGCXInlEL8wp/YeZTEvbnlw8MRLByeRDASzVz9GIWfZ1EqL9q+xU6JU3F0v92BzFffRvEIRZxstwX0224lIxaMRGOvv4b+d1O4fqUXyctDpoCl8hLGbk2hsrphCVbIpVFZW1fW/Q0FEGgBsHkwOOZYfSsrq+tIfjSE4vgIit+NmAJyzZXhLx3BsqMTYq2yzQ1RnDzzNe7NfOAejqeSya/JMS1g/tonAlBVrKkRiVOt9XUb+8C5XgUTJ3n37iEg1PA+WpIfmp1iM7igKBc8lQapgNqIZAZ60dXZAaO4ddm8EqWewWEBrwNTFYoA1X+vA3ABxwLLOmZRLsSWYG+rjjc1mq7rfy8l/tQUUN+3Tx4vEIi04UR7Jx7MTdvDsfKbRE2rhAOYVszRNy71WcNRvF/kpREASTu4oGhJDkU2M9DrCkxVPn0V3YM3rBeIticnlPvvFWc9HJs4e6WNmPxdJjlmJ1frCXii/ax2a/VwdBf1Jm6W6GpiH0bsvayFk7m07vruCRa5F4pqX9PDCdujqHRnUeSWUdrtXFldFzcksPY6D8DK6obuy/H1yvSsuG76eT6mUq3ZGo4v1vON38bs6JfuLOk+ODM4jFjTq8KRaKNRMcCp77PNPY8nZg1Ho0g/ZiNjgS3k0ohd6hN1jaWDj/xSPKVarazZnFbt/S3h6GBpFB00VgfZjd5Ar2hdPCwsvHyuTQml5zrA8b68vyUcrTUdrGIULZXNT+zCUTQEdCwEPB5tFM+1kSaco6oSIHuXreHo+YW1hu7UmLaxy0O6rWO0mE+sabovMjrh0mbJa1ie+c0aThRAuSSstUMhLtUjoo2gUWr+Oaq2wzI2ZbRO+9sXhxF6frpWB2UN22sG50rSFlCr3jZe3g/HKYnDCD2/Q/QqGg/HmqcA/YjC9Iz439V2MmrV7XncL37vDEdxSuIw4iJ6Y7emxCml+MiijPKS8+nURk3a+txs4DGHo/HjlMRhxMVQM5lL60oHI6Y1o5aqbhNsHL/PfXMwm87xjVNS5OWo0/ZmR5l77xzMEHA7tzcXID3MHmb6ksT4xiHEBWDXQcG2Hi5A9nyGP8p3DwMHMbZxfCMghxF6fhNVDM38tl354FYyYgRb/KXwZEO1Mle2iCmJwwg9v8erW6LmGGdSuhnT2sZoKck/LrbSJmLu4RRtivGNUxKHkUCkzfizBAFNS4cKxXLBU2mR/E8Cp0gZ326KYYSen9aagIyk8GOaJs5eyZbEys8Cq9Qx6eh/n3sgrDSHkaCw1sLB1pqFH1N/n2MTV3ql6TR/dHB7kozj3NPUc/2zK45S/wGlRV3/yit0rAAAAABJRU5ErkJggg==","contentType":"image/png","width":29,"height":29,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: true

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)
• assetid (type: esriFieldTypeString, alias: Streetlight ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• type (type: esriFieldTypeString, alias: Fixture Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Cobra Head: Cobra Head], [Shoebox: Shoebox], [High Mast: High Mast], ... 6 more ...)
• bulbtype (type: esriFieldTypeString, alias: Bulb Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LED: LED], [High Pressure Sodium: High Pressure Sodium], [Low-Pressure Sodium: Low-Pressure Sodium], ... 3 more ...)
• smartlight (type: esriFieldTypeString, alias: Smart Light, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• wattage (type: esriFieldTypeString, alias: Wattage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• warrantydate (type: esriFieldTypeDate, alias: Warranty Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• outage (type: esriFieldTypeString, alias: Outage, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• facingdirection (type: esriFieldTypeString, alias: Facing Direction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [East: East], [North: North], [South: South], ... 5 more ...)
• lateraloffset (type: esriFieldTypeDouble, alias: Lateral Offset, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latoffsetunits (type: esriFieldTypeString, alias: Lateral Offset Units, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Feet: Feet], [Meters: Meters])
• mountheight (type: esriFieldTypeDouble, alias: Mounting Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mountunits (type: esriFieldTypeString, alias: Mounting Height Units, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Feet: Feet], [Meters: Meters])
• locdesc (type: esriFieldTypeString, alias: Nearest Location, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• maintainedby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• collectedby (type: esriFieldTypeSmallInteger, alias: Collected By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• inspectdate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• condition (type: esriFieldTypeSmallInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Very Good], [4: Good], [3: Fair], ... 3 more ...)
• maintenance (type: esriFieldTypeString, alias: Needs Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• replacement (type: esriFieldTypeString, alias: Needs Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• retired (type: esriFieldTypeString, alias: Is Retired, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• poleglobalid (type: esriFieldTypeGUID, alias: Pole GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• cabinetglobalid (type: esriFieldTypeGUID, alias: Cabinet GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Streetlights
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• smartlight: No
• outage: No
• latoffsetunits: Feet
• mountunits: Feet
• ownedby: 0
• maintainedby: 0
• collectedby: 0
• maintenance: No
• replacement: No
• retired: No

Relationships:

• Maintenance (5) -- Related To: StreetlightMaintenance (7)
• Cabinets (6) -- Related To: Cabinets (3)
• Pole (7) -- Related To: Poles (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 9:38:49 PM

Schema Last Edit Date: 7/14/2025 11:13:06 PM

Data Last Edit Date: 7/22/2025 9:38:49 PM

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