Name: sw.DBO.SDInlet_Inspection

Display Field: TAG

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

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 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CleaningDate ( type: esriFieldTypeDate, alias: CleaningDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CleaningDate )
• Comments_Contractor ( type: esriFieldTypeString, alias: Comments_Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments_Contractor )
• IC_PH2A ( type: esriFieldTypeSmallInteger, alias: INSPECTION_COMPLETE_PH2A, editable: true, nullable: true, defaultValue: null, modelName: IC_PH2A , Coded Values: [1: Yes] , [0: No] )
• FEAT_STATUS ( type: esriFieldTypeString, alias: INLET STATUS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FEAT_STATUS , Coded Values: [ACT: Active] , [ABD: Abandoned] , [PRO: Proposed] , ...5 more... )
• MODIFICATION ( type: esriFieldTypeString, alias: INLET MODIFICATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODIFICATION , Coded Values: [I: INSERT] , [S: SCREEN] , [B: BOTH] , ...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] )
• HEIGHT_THROAT ( type: esriFieldTypeDouble, alias: THROAT OPENING HEIGHT (in), editable: true, nullable: true, defaultValue: null, modelName: HEIGHT_THROAT )
• LENGTH_THROAT ( type: esriFieldTypeDouble, alias: THROAT OPENING LENGTH (in), editable: true, nullable: true, defaultValue: null, modelName: LENGTH_THROAT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: sw.DBO.SDInlet_Inspection
  Description:
  Prototype:
  LENGTH_THROAT: null
  INLET_ID: null
  HEIGHT_THROAT: null
  CleaningDate: null
  Comments_Contractor: null
  IC_PH2A: null
  FEAT_STATUS: null
  MODIFICATION: null
  DEBRIS_BASIN: null
  DEBRIS_INSERT: null
  DEBRIS_SURFACE: null
  MAINT_REQ_STRUCT: null
  CLEANING_REQ: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,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   Apply Edits   Add Features   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata