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: 2000

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

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 (7)

Capabilities: Create,Editing,Uploads,Query,Update,Delete,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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata