Name: BMP Inspection/Maintenance
Display Field: INSPECTOR
Type: Table
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:
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)
- INSPDATE (type: esriFieldTypeDate, alias: INSPDATE, 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], ... 3 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], [NA: NA])
- 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], [NA: NA])
- EST_WATERDEPTH_FT (type: esriFieldTypeSmallInteger, alias: Estimated Water Depth (Feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
- BANK_STABILITY (type: esriFieldTypeSmallInteger, alias: BMP Bank Stablility, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Rill Erosion], [2: Collapsed], ... 2 more ...)
- BANK_VEGETATION (type: esriFieldTypeSmallInteger, alias: Bank Vegetation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: < 25% vegetated], [2: < 50% vegetated], ... 3 more ...)
- SEDIMENT_ACCUM (type: esriFieldTypeSmallInteger, alias: Sediment Level Prior to Cleaning, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No Sedimentation], [1: Slight Sedimentation], [2: High sedimentation])
- INVASIVE_COVER (type: esriFieldTypeSmallInteger, alias: Invasive Species Present, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Low: minor invasive species present], [2: Moderate: major invasive species present], ... 1 more ...)
- AQUATICVEG_COVER (type: esriFieldTypeSmallInteger, alias: Aquatic Vegetation Present, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: <15% pond surface covered], [2: 15-50% pond surface covered], ... 2 more ...)
- OCS_CONDITION (type: esriFieldTypeSmallInteger, alias: Outlet Control Structure Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Good: Inspect Within 2 Years], [1: Fair: Inspect Within 1 Year], [2: Poor: Requires Maintenance], ... 2 more ...)
- REPAIR_STRUCTURAL_DAMAGE (type: esriFieldTypeSmallInteger, alias: Repair_Structural_Damage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- RESTOREVEG (type: esriFieldTypeSmallInteger, alias: Restore Vegetation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- RESTOREERODEDSOIL (type: esriFieldTypeSmallInteger, alias: Restore Eroded Soil, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- REMOVEINVASIVES (type: esriFieldTypeSmallInteger, alias: Remove Invasives, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- REMOVEAQUATICVEG (type: esriFieldTypeSmallInteger, alias: Remove Aquatic Vegetation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- REMOVESEDDEBRIS (type: esriFieldTypeSmallInteger, alias: Remove Sediment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- CLEANBMPSTRUCTURES (type: esriFieldTypeSmallInteger, alias: Clean BMP Inlet/Outlet Structures, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- REPAIRBMPSTRUCTURES (type: esriFieldTypeSmallInteger, alias: Repair BMP Inlet/Outlet Structures, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- REBUILDSTRUCTURES (type: esriFieldTypeSmallInteger, alias: Rebuild Structures, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: 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: 150, nullable: true, editable: true)
- BMP_CONDITION (type: esriFieldTypeSmallInteger, alias: Overall BMP Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Good: Inspect Within 2 Years], [1: Fair: Inspect Within 1 Year], [2: Poor: Requires Maintenance], ... 2 more ...)
- FOLLOW_UP_NEEDED (type: esriFieldTypeString, alias: Follow Up Maintenance/Repair Needed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- ASSETGUID (type: esriFieldTypeGUID, alias: ASSETGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- 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)
- REMOVE_DEBRIS (type: esriFieldTypeSmallInteger, alias: Remove Debris, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: BMP Inspection/Maintenance
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- swBMP (3) -- Related To: BMPs (8)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/29/2023 1:43:28 AM
Schema Last Edit Date: 7/29/2023 1:43:28 AM
Data Last Edit Date: 7/29/2023 1:39:48 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat