Name: Manhole Inspection

Display Field: DATE

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7bfb481e09884b76944969e8fc6e15bf

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Manhole ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FACILITYID )
• DATE ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• SURFACE ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 55, defaultValue: null, modelName: SURFACE )
• DROP_MH ( type: esriFieldTypeString, alias: Drop Manhole?, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DROP_MH , Coded Values: [Yes: Yes] , [No: No] )
• PONDING ( type: esriFieldTypeString, alias: Ponding?, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PONDING , Coded Values: [No: No] , [On or Adjacent: On or Adjacent] )
• COV_COND ( type: esriFieldTypeString, alias: Cover/Frame Condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COV_COND , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• COV_NOTE ( type: esriFieldTypeString, alias: Cover/Frame Notes, editable: true, nullable: true, length: 999, defaultValue: null, modelName: COV_NOTE )
• INFIL ( type: esriFieldTypeString, alias: Evidence of Infiltration?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: INFIL , Coded Values: [None: None] , [Minor: Minor] , [Moderate: Moderate] , ...1 more... )
• STEP_COND ( type: esriFieldTypeString, alias: Step Condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STEP_COND , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• STEP_NOTE ( type: esriFieldTypeString, alias: Step Notes, editable: true, nullable: true, length: 999, defaultValue: null, modelName: STEP_NOTE )
• WALL_COND ( type: esriFieldTypeString, alias: Wall/Cone Condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WALL_COND , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• WALL_MAT ( type: esriFieldTypeString, alias: Wall/Cone Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WALL_MAT , Coded Values: [BRK: Brick] , [CBK: Clay Block] , [MBK: Manhole Block] , ...7 more... )
• WALL_NOTE ( type: esriFieldTypeString, alias: Wall/Cone Notes, editable: true, nullable: true, length: 999, defaultValue: null, modelName: WALL_NOTE )
• PIPE_SEAL ( type: esriFieldTypeString, alias: Pipe Seal Condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPE_SEAL , Coded Values: [Tight: Tight] , [Minor Gap(s): Minor Gap(s)] , [Major Gap(s): Major Gap(s)] , ...1 more... )
• STRUCT_DEF ( type: esriFieldTypeString, alias: Structural Cracks/Defects?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STRUCT_DEF , Coded Values: [None: None] , [Minor: Minor] , [Moderate: Moderate] , ...1 more... )
• ROOT_INT ( type: esriFieldTypeString, alias: Root Intrusion?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ROOT_INT , Coded Values: [None: None] , [Minor: Minor] , [Moderate: Moderate] , ...1 more... )
• OBSTRUCT ( type: esriFieldTypeString, alias: Flow Obstructions?, editable: true, nullable: true, length: 35, defaultValue: null, modelName: OBSTRUCT , Coded Values: [Roots: Roots] , [Debris: Debris] , [Structural Defect: Structural Defect] , ...1 more... )
• COMMENT ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 999, defaultValue: null, modelName: COMMENT )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Manhole Inspection
  Description:
  Prototype:
  COMMENT: null
  FACILITYID: null
  DATE: null
  SURFACE: null
  DROP_MH: null
  PONDING: null
  COV_COND: null
  COV_NOTE: null
  INFIL: null
  STEP_COND: null
  STEP_NOTE: null
  WALL_COND: null
  WALL_MAT: null
  WALL_NOTE: null
  PIPE_SEAL: null
  STRUCT_DEF: null
  ROOT_INT: null
  OBSTRUCT: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Manhole (0) -- Related To: Manhole (3)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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