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:

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)
• 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:

Attributes:

Relationships:

• Drainage_Ditches (0) -- Related To: Drainage Ditches (0)

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