Name: Pipe Inspection

Display Field: inspectorname

Type: Table

Geometry Type: N/A

Description: Pipe Inspection

Service Item Id: ae91ffee9b9f44fead3aae0b71317b9f

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• parentglobal ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: parentglobal, alias: ParentGlobal )
• inspectorname ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: inspectorname, alias: 1. Inspector Name )
• inspectiondate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: inspectiondate, alias: 2. Inspection Date )
• pipepavement ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: pipepavement, alias: 3. Rate the pavement condition over pipe (cracking over pipe alignment) , Coded Values: [Good: Good: Asset functioning properly. Some aging/wear. No structural deterioration. No maintenance or corrective action required.] , [Fair: Fair: Asset functioning adequately. Some wear/degradation. Maintenance/repair/replacement may be required in the next inspection cycle. ] , [Poor: Poor: Asset not functioning adequately. Significant aging/deterioration. Maintenance required before the next inspection cycle.] )
• roadovertop ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: roadovertop, alias: 4. Is there evidence of roadway overtopping? , Coded Values: [Yes: Yes] , [No: No] )
• stabilization ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: stabilization, alias: 5. Rate the stabilization of the embankment. (Poor is: Erosion or Slope Stability.) , Coded Values: [Good: Good: Asset functioning properly. Some aging/wear. No structural deterioration. No maintenance or corrective action required.] , [Fair: Fair: Asset functioning adequately. Some wear/degradation. Maintenance/repair/replacement may be required in the next inspection cycle. ] , [Poor: Poor: Asset not functioning adequately. Significant aging/deterioration. Maintenance required before the next inspection cycle.] )
• inleterosion ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: inleterosion, alias: 6. Inlet: Is there erosion, scour, or undermining of pipe? , Coded Values: [Yes: Yes] , [No: No] )
• describeinleterosion ( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: describeinleterosion, alias: 7. If Yes, please describe: )
• outleterosion ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: outleterosion, alias: 8. Outlet: Is there erosion, scour, or undermining of pipe? , Coded Values: [Yes: Yes] , [No: No] )
• describeoutleterosion ( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: describeoutleterosion, alias: 9. If Yes, please describe: )
• endstructcond ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: endstructcond, alias: 10. Rate the physical condition of end structure (Headwall, End Section, DI, Manhole, etc.) , Coded Values: [Good: Good: Asset functioning properly. Some aging/wear. No structural deterioration. No maintenance or corrective action required.] , [Fair: Fair: Asset functioning adequately. Some wear/degradation. Maintenance/repair/replacement may be required in the next inspection cycle. ] , [Poor: Poor: Asset not functioning adequately. Significant aging/deterioration. Maintenance required before the next inspection cycle.] )
• mhgrate ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: mhgrate, alias: 11. Rate condition of grate, manhole cover, or other steel components. , Coded Values: [Good: Good: Asset functioning properly. Some aging/wear. No structural deterioration. No maintenance or corrective action required.] , [Fair: Fair: Asset functioning adequately. Some wear/degradation. Maintenance/repair/replacement may be required in the next inspection cycle. ] , [Poor: Poor: Asset not functioning adequately. Significant aging/deterioration. Maintenance required before the next inspection cycle.] )
• percentblockage ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: percentblockage, alias: 12. What is the percent blockage or sediment accumulation of the pipe? , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• jointseparation ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: jointseparation, alias: 13. Are there joint separations or gaps at seams in the pipe? , Coded Values: [Yes: Yes] , [No: No] )
• overallpipecond ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: overallpipecond, alias: 14. Rate condition. (Poor is: Voids, Loss of Backfill, Undermining, or Cracking.) , Coded Values: [Good: Good: Asset functioning properly. Some aging/wear. No structural deterioration. No maintenance or corrective action required.] , [Fair: Fair: Asset functioning adequately. Some wear/degradation. Maintenance/repair/replacement may be required in the next inspection cycle. ] , [Poor: Poor: Asset not functioning adequately. Significant aging/deterioration. Maintenance required before the next inspection cycle.] )
• describepipe ( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: describepipe, alias: 15. If Poor, please describe: )
• maintenance ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: maintenance, alias: 16. Is Maintenance or repairs required at this location? , Coded Values: [Yes: Yes] , [No: No] )
• maintactivities ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: maintactivities, alias: 17. Were maintenance activities conducted at the time of this inspection? , Coded Values: [Yes: Yes] , [No: No] )
• idde ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: idde, alias: 18. At time of inspection is there a potential IDDE present? , Coded Values: [Yes: Yes] , [No: No] )
• comments ( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: comments, alias: 19. Comments/Recommendations/Actions )
• creator ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: creator, alias: Creator )
• creationdate ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: creationdate, alias: Creation Date )
• editor ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: editor, alias: Editor )
• editdate ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: editdate, alias: Edit Date )

Templates:

• Name: Pipe Inspection
  Description:
  Prototype:
  overallpipecond: null
  comments: null
  stabilization: null
  describeoutleterosion: null
  roadovertop: null
  describeinleterosion: null
  pipepavement: null
  maintactivities: null
  inspectiondate: null
  idde: null
  endstructcond: null
  percentblockage: null
  mhgrate: null
  inleterosion: null
  inspectorname: null
  jointseparation: null
  parentglobal: null
  maintenance: null
  outleterosion: null
  describepipe: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Pipe (3) -- Related To: Pipe (3)

Capabilities: Query,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata