Name: Pipes History

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: 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 )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Comments )
• leaktype ( type: esriFieldTypeString, alias: LeakType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeakType , Coded Values: [Circumference: Circumference] , [Linear: Linear] , [Pin Hole: Pin Hole] , ...2 more... )
• reporteddate ( type: esriFieldTypeDate, alias: ReportedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReportedDate )
• repaireddate ( type: esriFieldTypeDate, alias: RepairedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairedDate )
• pipeclamp ( type: esriFieldTypeString, alias: PipeClamp, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeClamp , Coded Values: [Yes: Yes] , [No: No] )
• feetreplaced ( type: esriFieldTypeDouble, alias: FeetReplaced, editable: true, nullable: true, defaultValue: null, modelName: FeetReplaced )
• sampledate ( type: esriFieldTypeDate, alias: SampleDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SampleDate )
• publicnotified ( type: esriFieldTypeString, alias: PublicNotified, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PublicNotified , Coded Values: [Yes: Yes] , [No: No] )
• cl2residual ( type: esriFieldTypeDouble, alias: Cl2Residual, editable: true, nullable: true, defaultValue: null, modelName: Cl2Residual )
• streetpatchtype ( type: esriFieldTypeString, alias: StreetPatchType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetPatchType )
• squarefeetpatched ( type: esriFieldTypeDouble, alias: SquareFeetPatched, editable: true, nullable: true, defaultValue: null, modelName: SquareFeetPatched )
• streetpatchdate ( type: esriFieldTypeDate, alias: StreetPatchDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StreetPatchDate )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkDate )
• workby ( type: esriFieldTypeString, alias: WorkBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkBy )
• worktype ( type: esriFieldTypeString, alias: WorkType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkType , Coded Values: [Pipeline Flush: Pipeline Flush] , [USA Locate: USA Locate] , [Water Main Leak: Water Main Leak] )
• diameter ( type: esriFieldTypeSmallInteger, alias: diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...12 more... )
• pipecondition ( type: esriFieldTypeString, alias: pipecondition, editable: true, nullable: true, length: 30, defaultValue: null, modelName: pipecondition , Coded Values: [Fair: Fair] , [Good: Good] , [Needs Maintenance: Needs Maintenance] )
• burydepth ( type: esriFieldTypeDouble, alias: burydepth, editable: true, nullable: true, defaultValue: null, modelName: burydepth )
• material ( type: esriFieldTypeString, alias: material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: material , Coded Values: [Ductile Iron: Ductile Iron] , [Concrete: Concrete] , [Asbestos Cement: Asbestos Cement] , ...2 more... )

Templates:

• Name: Pipes History
  Description:
  Prototype:
  burydepth: null
  material: null
  assetkey: null
  workorderid: null
  comments: null
  leaktype: null
  reporteddate: null
  repaireddate: null
  pipeclamp: null
  feetreplaced: null
  sampledate: null
  publicnotified: null
  cl2residual: null
  streetpatchtype: null
  squarefeetpatched: null
  streetpatchdate: null
  workdate: null
  workby: null
  worktype: null
  diameter: null
  pipecondition: 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