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:

• 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... )
• INLET_ID ( type: esriFieldTypeString, alias: INLET_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INLET_ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TYPE , Coded Values: [B10: B10 Inlet] , [B15: B15] , [DCO: D Combination Inlet] , ...30 more... )
• 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... )
• ACCESSIBLE ( type: esriFieldTypeSmallInteger, alias: IS THE INLET ACCESSIBLE, editable: true, nullable: true, defaultValue: null, modelName: ACCESSIBLE , Coded Values: [1: Yes] , [0: No] )
• COMMENTS ( type: esriFieldTypeString, alias: REASON FOR INACCESSIBILITY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• DEBRIS ( type: esriFieldTypeString, alias: AMOUNT OF DEBRIS IN CATCH BASIN, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DEBRIS , Coded Values: [LS DIA PIPE: LT 50 PCT] , [GR DIA PIPE: GR 50 PCT] , [EQ DIA PIPE: EQ 50 PCT] , ...1 more... )
• MAINT_REQ ( type: esriFieldTypeSmallInteger, alias: IS MAINTENANCE REQUIRED, editable: true, nullable: true, defaultValue: null, modelName: MAINT_REQ , Coded Values: [1: Yes] , [0: No] )
• MAINT_TYPE ( type: esriFieldTypeString, alias: TYPE OF MAINTENANCE REQUIRED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINT_TYPE , Coded Values: [WW Storm Inlet Choke: WW Storm Inlet Choke] , [WW Storm Damaged Inlet: WW Storm Damaged Inlet] , [NONE: NONE] )
• COMMENTS_1 ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_1 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssignTo ( type: esriFieldTypeString, alias: AssignTo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssignTo , Coded Values: [SWM: Stormwater Management] , [Other: Other] , [UMD: Utility Maintenance Division] )
• WorkOrderType ( type: esriFieldTypeString, alias: WorkOrderType, editable: true, nullable: true, length: 100, defaultValue: null, modelName: WorkOrderType )
• CleaningDate ( type: esriFieldTypeDate, alias: CleaningDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CleaningDate )
• Cleaning_Priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Cleaning_Priority , Coded Values: [P1: Priority 1] , [P2: Priority 2] , [P3: Priority 3] , ...3 more... )
• 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, 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:
  HEIGHT_THROAT: null
  INSPECTOR: PJ
  INLET_ID: null
  TYPE: null
  CONDITION: null
  ACCESSIBLE: null
  COMMENTS: null
  DEBRIS: null
  MAINT_REQ: null
  MAINT_TYPE: null
  COMMENTS_1: null
  CLEANING_REQ: null
  LENGTH_THROAT: null
  AssignTo: null
  WorkOrderType: null
  CleaningDate: null
  Cleaning_Priority: 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
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

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