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:
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:
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