Name: Streetlights

Display Field: assetid

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: 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":"eb7c00f3-e7d2-4380-b89d-2b819970e8e5","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)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• 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)
• esrignss_positionsourcetype (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
• esrignss_receiver (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• esrignss_latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_altitude (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_h_rms (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_v_rms (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_fixdatetime (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• esrignss_fixtype (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
• esrignss_correctionage (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_stationid (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_numsats (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
• esrignss_pdop (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_hdop (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_vdop (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_direction (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_speed (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrisnsr_azimuth (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_h_rms (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_v_rms (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_positions (type: esriFieldTypeInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_h_stddev (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, 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: Streetlight Maintenance (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   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat