Name: sedaSewerLateralHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: sedaSewerLateralHistory
  Description:
  Prototype:
  wocomments: null
  wodescription: null
  assetkey: null
  workorderid: null
  workdate: null
  workby: null
  worktype: null
  attachmentid: null
  emergency: null
  flush: null
  lateralrep: null
  problem1: null
  problem2: null
  problem3: null
  failure: null
  recommendation: null
  comments: null
  serviceadd: null
  repairtype: null
  repairstatus: null
  repairlength: null
  mhdistance: null
  insptype: null
  inspreason: null
  stormdrain: null
  statewaters: null
  fullrecover: null
  gals1000: null
  estvolume: null
  overflowtype: null
  attachmentid01: null
  attachmentid02: null
  overflowcategory: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata