Name: TLamp

Display Field: ModelName

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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: AssetID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeInteger, alias: FacilityID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LegacyID (type: esriFieldTypeString, alias: LegacyID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WarrantyDate (type: esriFieldTypeDate, alias: WarrantyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LifeCycleStatus (type: esriFieldTypeString, alias: LifeCycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [ABN: Abandoned], ... 2 more ...)
• AssetOwner (type: esriFieldTypeSmallInteger, alias: AssetOwner, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CPG], [-1: RDFFG], [-2: Private], ... 3 more ...)
• AssetManager (type: esriFieldTypeSmallInteger, alias: AssetManager, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Asset], [2: Bylaw], [3: Civic Facility], ... 21 more ...)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PrimaryImage (type: esriFieldTypeString, alias: PrimaryImage, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• BallastSize (type: esriFieldTypeString, alias: BallastSize, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Code1])
• PhotoCell (type: esriFieldTypeString, alias: PhotoCell, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Black: Black], [Grey: Grey], [Red: Red], ... 2 more ...)
• SwitchType (type: esriFieldTypeString, alias: SwitchType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Shorting Cap], [2: Photocell], [3: Other])
• LampPosition (type: esriFieldTypeString, alias: LampPosition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [SS: Street Side], [LS: Lot Side], [UNK: Unknown])
• ModelNumber (type: esriFieldTypeString, alias: ModelNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ModelName (type: esriFieldTypeString, alias: ModelName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Wattage (type: esriFieldTypeSmallInteger, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TimeControl (type: esriFieldTypeSmallInteger, alias: TimeControl, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• OpticsType (type: esriFieldTypeString, alias: OpticsType, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3K: 3K], [4K: 4K])
• LightStyle (type: esriFieldTypeString, alias: LightStyle, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Cobra Head: Cobra Head], [Post Top: Post Top], [Post Top D: Post Top Decorative], ... 1 more ...)
• LensType (type: esriFieldTypeString, alias: LensType, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [INC: Incadescent], [LPS: Low Pressure Sodium], [HID: High Intensity Discharge], ... 5 more ...)
• ConditionDate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Condition (type: esriFieldTypeDouble, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AcquisitionCost (type: esriFieldTypeDouble, alias: AcquisitionCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeprecationMethod (type: esriFieldTypeString, alias: DeprecationMethod, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ExpectedLife (type: esriFieldTypeDouble, alias: ExpectedLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ResidualValue (type: esriFieldTypeDouble, alias: ResidualValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• CoFScore (type: esriFieldTypeDouble, alias: CoFScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CoFDate (type: esriFieldTypeDate, alias: CoFDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RiskScore (type: esriFieldTypeDouble, alias: RiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DF (type: esriFieldTypeString, alias: DF, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• FuseHolder (type: esriFieldTypeString, alias: Fuse Holder, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Crimped: Crimped], [Non-Crimped: Non-Crimped])
• FuseSize (type: esriFieldTypeSingle, alias: Fuse Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Voltage (type: esriFieldTypeInteger, alias: Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [120: 120 V], [230: 230 V], [240: 240 V], ... 4 more ...)
• Distribution (type: esriFieldTypeString, alias: Distribution Pattern, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: TLamp
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AssetOwner: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 4:00:43 AM

Schema Last Edit Date: 7/22/2025 4:00:43 AM

Data Last Edit Date: 7/22/2025 4:00:43 AM

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