Name: swBMPInspMaint

Display Field: INSPECTOR

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• INSPECTOR (type: esriFieldTypeString, alias: Inspector or Contractor Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• INSPECTORAFFIL (type: esriFieldTypeString, alias: Inspector Affiliation, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• INSPDATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTRAIN (type: esriFieldTypeDate, alias: Date of Last Rain, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STRUCTURE_FOUND (type: esriFieldTypeString, alias: Structure Found, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• VISIT_TYPE (type: esriFieldTypeString, alias: Visit Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Inspection and Maintenance: Inspection and Maintenance], [Maintenance Only: Maintenance Only], [Inspection Only: Inspection Only])
• VISIT_REASON (type: esriFieldTypeString, alias: Visit Reason, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Corrective Maintenance: Corrective Maintenance], [Post Construction Inspection: Post Construction Inspection], [Public Complaint: Public Complaint], ... 6 more ...)
• DEBRIS (type: esriFieldTypeString, alias: Is debris present?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SURFACE_OIL (type: esriFieldTypeString, alias: Are there signs of oil on pond surface?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SURFACE_FOAM (type: esriFieldTypeString, alias: Is there foam on the pond surface?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• EST_WATERDEPTH_FT (type: esriFieldTypeDouble, alias: Estimated Water Depth (Feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
• BANK_STABILITY (type: esriFieldTypeString, alias: BMP Bank Stablility, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [N/A: N/A], [Rill Erosion: Rill Erosion], [Collapsed: Collapsed], ... 2 more ...)
• BANK_VEGETATION (type: esriFieldTypeString, alias: Bank Vegetation, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [None: None], [< 25% vegetated: < 25% vegetated], [< 50% vegetated: < 50% vegetated], ... 3 more ...)
• SEDIMENT_ACCUM (type: esriFieldTypeString, alias: Sediment Level Prior to Cleaning, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [No sediment: No sediment], [< 25% accumulation: < 25% accumulation], [25- 50% accumulation: 25- 50% accumulation], ... 1 more ...)
• INVASIVE_COVER (type: esriFieldTypeString, alias: Invasive Species Present, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true, Coded Values: [None: None], [Low: minor invasive species present: Low: minor invasive species present], [Moderate: major invasive species present: Moderate: major invasive species present], ... 1 more ...)
• AQUATICVEG_COVER (type: esriFieldTypeString, alias: Aquatic Vegetation Present, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [None: None], [<15% pond surface covered: <15% pond surface covered], [15-50% pond surface covered: 15-50% pond surface covered], ... 1 more ...)
• OCS_CONDITION (type: esriFieldTypeString, alias: Outlet Control Structure Condition, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Good: Inspect Within 2 Years: Good: Inspect Within 2 Years], [Fair: Inspect Within 1 Year: Fair: Inspect Within 1 Year], [Poor: Requires Maintenance: Poor: Requires Maintenance], ... 3 more ...)
• REPAIR_STRUCTURAL_DAMAGE (type: esriFieldTypeString, alias: Repair_Structural_Damage, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• RESTOREVEG (type: esriFieldTypeString, alias: Restore Vegetation, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• RESTOREERODEDSOIL (type: esriFieldTypeString, alias: Restore Eroded Soil, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• REMOVEINVASIVES (type: esriFieldTypeString, alias: Remove Invasives, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• REMOVEAQUATICVEG (type: esriFieldTypeString, alias: Remove Aquatic Vegetation, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• REMOVESEDDEBRIS (type: esriFieldTypeString, alias: Remove Sediment or Debris, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• WOODY_VEG_DEBRIS (type: esriFieldTypeString, alias: Significant Woody Vegetation/Debris Observed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• REMOVEWOODYVEG (type: esriFieldTypeString, alias: Remove Woody Vegetation/Debris, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• CLEANBMPSTRUCTURES (type: esriFieldTypeString, alias: Clean BMP Inlet/Outlet Structures, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• REPAIRBMPSTRUCTURES (type: esriFieldTypeString, alias: Repair BMP Inlet/Outlet Structures, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• REBUILDSTRUCTURES (type: esriFieldTypeString, alias: Rebuild Structures, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Needed: Needed], [Completed: Completed], [NA: NA])
• ADDTLINVESTIGATION (type: esriFieldTypeString, alias: Additional Investigation Required, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• OTHER (type: esriFieldTypeString, alias: Other Work Completed/Needed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BMP_CONDITION (type: esriFieldTypeString, alias: Overall BMP Condition, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Good: Inspect Within 2 Years: Good: Inspect Within 2 Years], [Fair: Inspect Within 1 Year: Fair: Inspect Within 1 Year], [Poor: Requires Maintenance: Poor: Requires Maintenance], ... 3 more ...)
• FOLLOW_UP_NEEDED (type: esriFieldTypeString, alias: Follow Up Needed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_COMPLETE (type: esriFieldTypeString, alias: QC Complete?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASSETGUID (type: esriFieldTypeGUID, alias: ASSETGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)

Templates:

Name: swBMPInspMaint
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (6) -- Related To: swBMP (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/22/2026 6:16:21 PM

Schema Last Edit Date: 10/29/2025 8:52:33 PM

Data Last Edit Date: 5/4/2026 5:18:10 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat