Name: swSCMInspectionForm

Display Field: InspDate

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 20000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• InspDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Discovered ( type: esriFieldTypeString, alias: SCM Found?, length: 5 , Coded Values: [1: Yes] , [2: No] )
• Erosion ( type: esriFieldTypeString, alias: Level of Erosion, length: 30 , 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, length: 55 , 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, length: 5 , Coded Values: [1: Yes] , [2: No] )
• Condition ( type: esriFieldTypeString, alias: Overall Condition, length: 35 , 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, length: 8 )
• StandingWater ( type: esriFieldTypeString, alias: Is There Standing Water?, length: 5 , Coded Values: [1: Yes] , [2: No] )
• ActionPerformed ( type: esriFieldTypeString, alias: Action Performed, length: 25 , Coded Values: [1: None] , [2: Inspection] , [3: Repair] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 250 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• LastUpdate ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• ReviewStatus ( type: esriFieldTypeString, alias: Review Status, length: 10 , Coded Values: [1: Pending] , [2: Completed] , [3: In Review] )
• Reviewer ( type: esriFieldTypeString, alias: Reviewer, length: 50 )
• Attachments ( type: esriFieldTypeBlob, alias: Attachments )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• StartTime ( type: esriFieldTypeString, alias: Start Time, length: 10 )
• EndTime ( type: esriFieldTypeString, alias: End Time, length: 10 )
• Trash ( type: esriFieldTypeString, alias: Trash Accumulation, length: 55 , 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, length: 35 , Coded Values: [1: Repair structural damage] , [2: Clean trash and sediment] , [3: Restore vegetation] , ...3 more... )
• Sediment ( type: esriFieldTypeString, alias: Level of Sediment, length: 60 , 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, length: 35 , 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, length: 70 , 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, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata