Name: swSCMInspectionForm

Display Field: InspDate

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 20000

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 )
• InspDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• Discovered ( type: esriFieldTypeString, alias: SCM Found?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Discovered , Coded Values: [1: Yes] , [2: No] )
• Erosion ( type: esriFieldTypeString, alias: Level of Erosion, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Erosion , Coded Values: [1: None - No Material Loss] , [2: Low - Minor Material Loss] , [3: Moderate - Major Material Loss] , ...1 more... )
• VegHealth ( type: esriFieldTypeString, alias: Vegetation Health, editable: true, nullable: true, length: 55, defaultValue: null, modelName: VegHealth , Coded Values: [1: Good - full healthy vegetation coverage] , [2: Fair - majority of area covered with healthy vegetation] , [3: Poor - bare vegetation coverage] , ...2 more... )
• WoodyVeg ( type: esriFieldTypeString, alias: Nuisance Woody Vegetation, editable: true, nullable: true, length: 5, defaultValue: null, modelName: WoodyVeg , Coded Values: [1: Yes] , [2: No] )
• Condition ( type: esriFieldTypeString, alias: Overall Condition, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Condition , Coded Values: [1: Good – inspect within 2 years] , [2: Fair - inspect within 1 year] , [3: Poor – requires maintenance] , ...1 more... )
• DateRain ( type: esriFieldTypeDate, alias: Date of Last Rain, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateRain )
• StandingWater ( type: esriFieldTypeString, alias: Is There Standing Water?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: StandingWater , Coded Values: [1: Yes] , [2: No] )
• ActionPerformed ( type: esriFieldTypeString, alias: Action Performed, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ActionPerformed , Coded Values: [1: None] , [2: Inspection] , [3: Repair] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• LastUpdate ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastEditor )
• ReviewStatus ( type: esriFieldTypeString, alias: Review Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ReviewStatus , Coded Values: [1: Pending] , [2: Completed] , [3: In Review] )
• Reviewer ( type: esriFieldTypeString, alias: Reviewer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Reviewer )
• Attachments ( type: esriFieldTypeBlob, alias: Attachments, editable: true, nullable: true, defaultValue: null, modelName: Attachments )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• StartTime ( type: esriFieldTypeString, alias: Start Time, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StartTime )
• EndTime ( type: esriFieldTypeString, alias: End Time, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EndTime )
• Trash ( type: esriFieldTypeString, alias: Trash Accumulation, editable: true, nullable: true, length: 55, defaultValue: null, modelName: Trash , Coded Values: [1: None - no trash accumulation] , [2: Low - several items of trash in BMP] , [3: Moderate - some trash accumulation at inlet/outlet] , ...1 more... )
• ActionNeeded ( type: esriFieldTypeString, alias: Action Needed, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ActionNeeded , Coded Values: [1: Repair structural damage] , [2: Clean trash and sediment] , [3: Restore vegetation] , ...3 more... )
• Sediment ( type: esriFieldTypeString, alias: Level of Sediment, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Sediment , Coded Values: [1: None - no sediment or debris] , [2: Low - less than 25% sediment accumulation or debris] , [3: Moderate - 25-50% sediment accumulation or debris] , ...1 more... )
• Spillway ( type: esriFieldTypeString, alias: Emergency Spillway Condition, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Spillway , Coded Values: [1: Good – inspect within 2 years] , [2: Fair - inspect within 1 year] , [3: Poor – requires maintenance] , ...1 more... )
• BMPAccess ( type: esriFieldTypeString, alias: SCM Accessibility, editable: true, nullable: true, length: 70, defaultValue: null, modelName: BMPAccess , Coded Values: [1: Good - maintained access area for crew and vehicle] , [2: Fair - access area designated for crew and vehicle but not maintained] , [3: Poor - inadequate access for crew and vehicle] , ...1 more... )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• 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 )

Templates:

• Name: swSCMInspectionForm
  Description:
  Prototype:
  Editor: null
  InspDate: null
  Discovered: null
  Erosion: null
  VegHealth: null
  WoodyVeg: null
  Condition: null
  DateRain: null
  StandingWater: null
  ActionPerformed: null
  Notes: null
  Inspector: null
  LastUpdate: null
  LastEditor: null
  ReviewStatus: null
  Reviewer: null
  Attachments: null
  GUID: null
  StartTime: null
  EndTime: null
  Trash: null
  ActionNeeded: null
  Sediment: null
  Spillway: null
  BMPAccess: null
  CreationDate: null
  Creator: null
  EditDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Stormwater_Control_Measures (0) -- Related To: Stormwater Control Measure (0)

Capabilities: Query,Extract,ChangeTracking

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

Supports OidReservation: 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   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata