Name: Street light maintenance history

Display Field: LightID

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• LightGUID ( type: esriFieldTypeGUID , alias: GID , length: 38 )
• LightID ( type: esriFieldTypeSmallInteger , alias: LightID )
• Street ( type: esriFieldTypeString , alias: Street , length: 50 )
• Location ( type: esriFieldTypeString , alias: Address , length: 50 )
• PoleNumber ( type: esriFieldTypeString , alias: PoleNumber , length: 20 )
• WattBefore ( type: esriFieldTypeSmallInteger , alias: WattBefore )
• WattAfter ( type: esriFieldTypeSmallInteger , alias: WattAfter )
• TypeBefore ( type: esriFieldTypeString , alias: TypeBefore , length: 12 )
• TypeAfter ( type: esriFieldTypeString , alias: TypeAfter , length: 12 )
• ReportBy ( type: esriFieldTypeString , alias: ReportSource , length: 20 )
• ReportDate ( type: esriFieldTypeDate , alias: ReportDate , length: 8 )
• WorkType ( type: esriFieldTypeString , alias: WorkType , length: 20 , Coded Values: [Replace/Repair: Replace/Repair] , [Remove: Remove] , [Move Out: Move Out] , ...2 more... )
• WorkDate ( type: esriFieldTypeDate , alias: WorkDate , length: 8 )
• PhotoCellReplaced ( type: esriFieldTypeString , alias: PhotoCellReplaced , length: 10 )
• LightReplaced ( type: esriFieldTypeString , alias: LightReplaced , length: 10 )
• WiringRepaired ( type: esriFieldTypeString , alias: WiringRepaired , length: 10 )
• NewLightTaken ( type: esriFieldTypeSmallInteger , alias: NewLightTaken )
• NewLightReturn ( type: esriFieldTypeSmallInteger , alias: NewLightReturn )
• FaultyLightReturn ( type: esriFieldTypeSmallInteger , alias: FaultyLightReturn )
• LightReturnDate ( type: esriFieldTypeDate , alias: LightReturnDate , length: 8 )
• WarrantyRequest ( type: esriFieldTypeDate , alias: WarrantyRequest , length: 8 )
• WarrantyReceived ( type: esriFieldTypeDate , alias: WarrantyReceived , length: 8 )
• ShieldInstalled ( type: esriFieldTypeString , alias: ShieldInstalled , length: 50 )
• UnitilCharge ( type: esriFieldTypeDouble , alias: UtitilPaid )
• PaymentDate ( type: esriFieldTypeDate , alias: PaymentDate , length: 8 )
• Notes ( type: esriFieldTypeString , alias: Notes , length: 100 )
• RTEID ( type: esriFieldTypeInteger , alias: RTEID )

Relationships:

• StreetLights (0) -- Related To: StreetLights (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata