Name: PublicWorks.DBO.transportation_lightfixture

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 144448

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2789611.4580721
YMin: 944656.529236107
XMax: 2817052.00351337
YMax: 973998.626379047
Spatial Reference: 102698 (102698)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,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: 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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, 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_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• POLE_NO (type: esriFieldTypeInteger, alias: POLE_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WATT (type: esriFieldTypeSmallInteger, alias: WATT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LUMMEN (type: esriFieldTypeInteger, alias: LUMMEN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIGHT_TYPE (type: esriFieldTypeString, alias: LIGHT_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• POLE_TYPE (type: esriFieldTypeString, alias: POLE_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WIRING (type: esriFieldTypeString, alias: WIRING, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GLASSWARE (type: esriFieldTypeString, alias: GLASSWARE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CODE_NO (type: esriFieldTypeInteger, alias: CODE_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LTID (type: esriFieldTypeString, alias: LTID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STREET_loc (type: esriFieldTypeString, alias: STREET, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• docLink (type: esriFieldTypeString, alias: docLink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date (type: esriFieldTypeDate, alias: date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• assetID (type: esriFieldTypeString, alias: assetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Priority (type: esriFieldTypeSmallInteger, alias: Priority, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CostEstimate (type: esriFieldTypeDouble, alias: CostEstimate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Invoice (type: esriFieldTypeString, alias: Invoice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Reason (type: esriFieldTypeString, alias: Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• legacyID (type: esriFieldTypeString, alias: legacyID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lightclass (type: esriFieldTypeString, alias: lightclass, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ActivationType (type: esriFieldTypeString, alias: ActivationType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BulbType (type: esriFieldTypeString, alias: BulbType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PlugSocket (type: esriFieldTypeString, alias: PlugSocket, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LightFixtureType (type: esriFieldTypeString, alias: LightFixtureType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AverageDailyUse (type: esriFieldTypeDouble, alias: AverageDailyUse, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AverageDailyUse_unit (type: esriFieldTypeString, alias: AverageDailyUse_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lumens (type: esriFieldTypeDouble, alias: Lumens, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lumens_unit (type: esriFieldTypeString, alias: Lumens_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Voltage (type: esriFieldTypeDouble, alias: Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Voltage_unit (type: esriFieldTypeString, alias: Voltage_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wattage (type: esriFieldTypeDouble, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Wattage_unit (type: esriFieldTypeString, alias: Wattage_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Retired (type: esriFieldTypeDate, alias: Retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Replaced (type: esriFieldTypeDate, alias: Replaced, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Installed (type: esriFieldTypeDate, alias: Installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AddressNumber (type: esriFieldTypeDouble, alias: AddressNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: LocationDescription, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StateValue (type: esriFieldTypeString, alias: StateValue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Support (type: esriFieldTypeString, alias: Support, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: PublicWorks.DBO.transportation_lightfixture
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• STATUS: Preliminary

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/23/2026 3:21:10 PM

Schema Last Edit Date: 9/23/2026 3:21:10 PM

Data Last Edit Date: 9/23/2026 3:21:10 PM

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