Name: Ditch Inspections
Display Field: Inspection_Date
Type: Table
Description:
Copyright Text:
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
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)
- DitchID (type: esriFieldTypeString, alias: Ditch ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Inspection_Date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Gretchen Anderson: Gretchen Anderson], [Terry Deering: Terry Deering], [Jeff Grant: Jeff Grant], ... 13 more ...)
- Wind (type: esriFieldTypeString, alias: Wind Present (Y/N), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Temperature (type: esriFieldTypeSmallInteger, alias: Temperature, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Precip (type: esriFieldTypeString, alias: Precipitation in Past 2 Days (Y/N), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Precip_Depth (type: esriFieldTypeDouble, alias: Precipitation Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Ditch_Flow (type: esriFieldTypeString, alias: Ditch Flow, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Trickle: Trickle], [Steady: Steady], ... 1 more ...)
- Standing_Water (type: esriFieldTypeString, alias: Standing Water, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Water_Clarity (type: esriFieldTypeString, alias: Water Clarity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clear: Clear Water], [Cloudy: Cloudy Water], [Opaque: Opaque Water], ... 1 more ...)
- Water_Color (type: esriFieldTypeString, alias: Water Color, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clear: Clear], [Brown: Brown], [Orange: Orange], ... 3 more ...)
- Odor (type: esriFieldTypeString, alias: Odor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Musty: Musty], [Sewage / Septic: Sewage / Septic], [None / Natural: None / Natural])
- Yard_Waste (type: esriFieldTypeString, alias: Yard Waste (Y/N), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Trash (type: esriFieldTypeString, alias: Trash/Litter Present (Y/N), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- DebrisFoam (type: esriFieldTypeString, alias: Debris Foam, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- DebrisScum (type: esriFieldTypeString, alias: Debris Floating Green Scum, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- DebrisOil (type: esriFieldTypeString, alias: Debris Oil / Film, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- DebrisVeg (type: esriFieldTypeString, alias: Debris Vegetative Mat, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- DebrisSolid (type: esriFieldTypeString, alias: Debris Sewage Solids, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Inlet_Cond (type: esriFieldTypeString, alias: Inlet Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Free Of Obstructions: Free Of Obstructions], [Stable: Stable], [Unstable: Unstable], ... 1 more ...)
- Outlet_Cond (type: esriFieldTypeString, alias: Outlet Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Free Of Obstructions: Free Of Obstructions], [Stable: Stable], [Unstable: Unstable], ... 1 more ...)
- Sediment (type: esriFieldTypeString, alias: Sediment Accumulation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Less Than 2 Inches: Depth less than 2 Inches], [Greater Than 2 Inches: Depth Greater Than 2 Inches], [Plugged: Plugged With Sediment], ... 1 more ...)
- Structural_Cond (type: esriFieldTypeString, alias: Structural Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Woody Vegetation: Woody Vegetation Present], [Riprap Displaced: Riprap Displaced], [Stable: No Erosion Present], ... 1 more ...)
- Veg_Cov (type: esriFieldTypeString, alias: Vegetation Coverage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Grass: Grass], [Natural: Natural], [Greater than 90% vegetative cover: Greater than 90% vegetative cover], ... 1 more ...)
- Veg_Height (type: esriFieldTypeString, alias: Vegetation Height, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [3-6 Inches: 3-6 Inches], [6-12 Inches: 6-12 Inches], [Excessively Tall: Excessively Tall], ... 1 more ...)
- Veg_Type (type: esriFieldTypeString, alias: Vegetation Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Normal Grass: Normal Grass], [Invasive: Invasive], [Poisonous: Poisonous], ... 3 more ...)
- Erosion (type: esriFieldTypeString, alias: Erosion / Scouring, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- DitchCond (type: esriFieldTypeString, alias: Ditch Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Good: Good], [Fair: Fair], ... 1 more ...)
- Follow_Up (type: esriFieldTypeString, alias: Follow Up Required, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Follow_Reason (type: esriFieldTypeString, alias: Follow Up Reason, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Gen_Com (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- Potential_Source (type: esriFieldTypeString, alias: Potential Source / Action Taken, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Ditch Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/15/2021 4:58:21 PM
Schema Last Edit Date: 9/15/2021 4:58:21 PM
Data Last Edit Date: 9/15/2021 4:58:21 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat