Name: sedaSewerLateralHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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 )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: Work Date, length: 8 )
• workby ( type: esriFieldTypeString, alias: Work By, length: 50 , Coded Values: [Staff: Staff] , [Contractor: Contractor] )
• worktype ( type: esriFieldTypeString, alias: Work Type, length: 50 )
• attachmentid ( type: esriFieldTypeInteger, alias: AttachmentID )
• emergency ( type: esriFieldTypeString, alias: emergency, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• flush ( type: esriFieldTypeString, alias: flush, length: 30 , Coded Values: [Flush: Flush] , [Rod: Rod] , [Plunge: Plunge] , ...3 more... )
• lateralrep ( type: esriFieldTypeString, alias: lateralrep, length: 30 , Coded Values: [Open Trench: Open Trench] , [Trencless: Trencless] , [C.O. Cap/Lid: C.O. Cap/Lid] )
• problem1 ( type: esriFieldTypeString, alias: problem1, length: 30 , Coded Values: [ROOT: Roots] , [GRSE: Grease] , [DEBR: Debris] , ...14 more... )
• problem2 ( type: esriFieldTypeString, alias: problem2, length: 30 , Coded Values: [ROOT: Roots] , [GRSE: Grease] , [DEBR: Debris] , ...14 more... )
• problem3 ( type: esriFieldTypeString, alias: problem3, length: 30 , Coded Values: [ROOT: Roots] , [GRSE: Grease] , [DEBR: Debris] , ...14 more... )
• failure ( type: esriFieldTypeString, alias: failure, length: 30 , Coded Values: [None: None] , [Stoppage: Stoppage] , [Overflow: Overflow] , ...1 more... )
• recommendation ( type: esriFieldTypeString, alias: recommendation, length: 50 , Coded Values: [Repair: Repair] , [Replace: Replace] , [Flush: Flush] , ...5 more... )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• serviceadd ( type: esriFieldTypeString, alias: serviceadd, length: 1000 )
• repairtype ( type: esriFieldTypeString, alias: repairtype, length: 25 , Coded Values: [Open Trench: Open Trench] , [Trenchless: Trenchless] )
• repairstatus ( type: esriFieldTypeString, alias: repairstatus, length: 25 , Coded Values: [Complete: Complete] , [Pending: Pending] )
• repairlength ( type: esriFieldTypeDouble, alias: repairlength )
• mhdistance ( type: esriFieldTypeString, alias: mhdistance, length: 10 )
• insptype ( type: esriFieldTypeString, alias: insptype, length: 25 , Coded Values: [CCTV: CCTV] , [Visual: Visual] , [Dye Test: Dye Test] , ...1 more... )
• inspreason ( type: esriFieldTypeString, alias: inspreason, length: 50 , Coded Values: [RT: Routine] , [FOL: Follow up] , [CALL: Called Out] , ...2 more... )
• stormdrain ( type: esriFieldTypeSmallInteger, alias: stormdrain , Coded Values: [1: Yes] , [0: No] )
• statewaters ( type: esriFieldTypeSmallInteger, alias: statewaters , Coded Values: [1: Yes] , [0: No] )
• fullrecover ( type: esriFieldTypeSmallInteger, alias: fullrecover , Coded Values: [1: Yes] , [0: No] )
• gals1000 ( type: esriFieldTypeSmallInteger, alias: gals1000 , Coded Values: [1: Yes] , [0: No] )
• estvolume ( type: esriFieldTypeSmallInteger, alias: estvolume )
• overflowtype ( type: esriFieldTypeString, alias: overflowtype, length: 20 , Coded Values: [SSO: SSO] , [Backup: Backup] , [Private: Private] )
• attachmentid01 ( type: esriFieldTypeInteger, alias: attachmentid01 )
• attachmentid02 ( type: esriFieldTypeInteger, alias: attachmentid02 )
• overflowcategory ( type: esriFieldTypeSmallInteger, alias: overflowcategory , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata