Name: sw.DBO.SDInlet_Inspection

Display Field: TAG

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

Supports ValidateSQL: true

Supports Calculate: false

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• INLET_ID ( type: esriFieldTypeString, alias: INLET_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INLET_ID )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, editable: true, nullable: true, length: 50, defaultValue: PJ, modelName: INSPECTOR , Coded Values: [JM: John McComas] , [DL: David Lauman] , [MC: Milton Carroll] , ...6 more... )
• EDIT_DATE ( type: esriFieldTypeDate, alias: INSPECTION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION OF INLET, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONDITION , Coded Values: [1: EXCELLENT] , [2: GOOD] , [3: FAIR] , ...1 more... )
• DEBRIS_BASIN ( type: esriFieldTypeString, alias: AMOUNT OF DEBRIS IN BASIN, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DEBRIS_BASIN , Coded Values: [LS DIA PIPE: LT 50 PCT] , [GR DIA PIPE: GR 50 PCT] , [EQ DIA PIPE: EQ 50 PCT] , ...1 more... )
• DEBRIS_INSERT ( type: esriFieldTypeString, alias: AMOUNT OF DEBRIS IN INSERT, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DEBRIS_INSERT , Coded Values: [LS DIA PIPE: LT 50 PCT] , [GR DIA PIPE: GR 50 PCT] , [EQ DIA PIPE: EQ 50 PCT] , ...1 more... )
• DEBRIS_SURFACE ( type: esriFieldTypeString, alias: AMOUNT OF DEBRIS ON GRATE OR SCREEN, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DEBRIS_SURFACE , Coded Values: [LS DIA PIPE: LT 50 PCT] , [GR DIA PIPE: GR 50 PCT] , [EQ DIA PIPE: EQ 50 PCT] , ...1 more... )
• MAINT_REQ_STRUCT ( type: esriFieldTypeString, alias: MAINTENANCE REQUIRED - STRUCTURAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINT_REQ_STRUCT , Coded Values: [NONE: NONE] , [UMD-SM: UMD - STRUCTURAL MAINT] , [SWC-SM: CONTRACTOR - STRUCTURAL MAINT] )
• CLEANING_REQ ( type: esriFieldTypeString, alias: CLEANING REQUIRED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLEANING_REQ , Coded Values: [NONE: NO] , [CONT-CL: YES] )
• INSPECTION_COMPLETE ( type: esriFieldTypeSmallInteger, alias: INSPECTION COMPLETE, editable: true, nullable: true, defaultValue: null, modelName: INSPECTION_COMPLETE , Coded Values: [1: Yes] , [0: No] )
• COMMENTS_1 ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_1 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: sw.DBO.SDInlet_Inspection
  Description:
  Prototype:
  COMMENTS_1: null
  INLET_ID: null
  INSPECTOR: PJ
  EDIT_DATE: null
  CONDITION: null
  DEBRIS_BASIN: null
  DEBRIS_INSERT: null
  DEBRIS_SURFACE: null
  MAINT_REQ_STRUCT: null
  CLEANING_REQ: null
  INSPECTION_COMPLETE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• sw.DBO.SDInletCleaning (0) -- Related To: Inlet Cleaning (0)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Coordinates Quantization: false

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