Name: sw.SW.SW_Inlet_Inspection

Display Field: INLET_ID

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: 15, defaultValue: null, modelName: INLET_ID )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, editable: true, nullable: false, length: 50, defaultValue: null, modelName: INSPECTOR , Coded Values: [JM: John McComas] , [DL: David Lauman] , [MC: Milton Carroll] , ...6 more... )
• 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... )
• CONDITION ( type: esriFieldTypeString, alias: INLET CONDITION, editable: true, nullable: false, length: 20, defaultValue: null, modelName: CONDITION , Coded Values: [1: EXCELLENT] , [2: GOOD] , [3: FAIR] , ...1 more... )
• MODIFICATION ( type: esriFieldTypeString, alias: INLET MODIFICATION, editable: true, nullable: false, length: 50, defaultValue: null, modelName: MODIFICATION , Coded Values: [I: INSERT] , [S: SCREEN] , [B: BOTH] , ...1 more... )
• HEIGHT_T ( type: esriFieldTypeInteger, alias: THROAT OPENING HEIGHT (in), editable: true, nullable: false, defaultValue: null, modelName: HEIGHT_T )
• LENGTH_T ( type: esriFieldTypeInteger, alias: THROAT OPENING LENGTH (in), editable: true, nullable: false, defaultValue: null, modelName: LENGTH_T )
• DEBRIS_BASIN ( type: esriFieldTypeString, alias: AMOUNT OF DEBRIS IN CATCH BASIN, editable: true, nullable: false, 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: false, 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 SCREEN OR GRATE, editable: true, nullable: false, 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 ( type: esriFieldTypeString, alias: MAINTENANCE REQUIRED - STRUCTURAL, editable: true, nullable: false, length: 50, defaultValue: null, modelName: MAINT_REQ , Coded Values: [NONE: NONE] , [UMD-SM: UMD - STRUCTURAL MAINT] , [SWC-SM: CONTRACTOR - STRUCTURAL MAINT] )
• CLEANING_REQ ( type: esriFieldTypeString, alias: CLEANING REQUIRED, editable: true, nullable: false, length: 50, defaultValue: null, modelName: CLEANING_REQ , Coded Values: [NONE: NO] , [CONT-CL: YES] )
• INSPECTION_COMPLETE ( type: esriFieldTypeString, alias: INSPECTION_COMPLETE, editable: true, nullable: false, length: 6, defaultValue: null, modelName: INSPECTION_COMPLETE , Coded Values: [Y: Yes] , [N: No] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• 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 )

Templates:

• Name: sw.SW.SW_Inlet_Inspection
  Description:
  Prototype:
  COMMENTS: null
  INLET_ID: null
  INSPECTOR:
  FEAT_STATUS: null
  CONDITION:
  MODIFICATION:
  HEIGHT_T: 0
  LENGTH_T: 0
  DEBRIS_BASIN:
  DEBRIS_INSERT:
  DEBRIS_SURFACE:
  MAINT_REQ:
  CLEANING_REQ:
  INSPECTION_COMPLETE:
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ER4069_Inlets (0) -- Related To: sw.SW.ER4069_Inlets (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