Name: Outfall Inspections
Display Field: InspDate
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)
- StructureID (type: esriFieldTypeString, alias: Outfall ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- InspDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Gretchen Anderson: Gretchen Anderson], [Terry Deering: Terry Deering], [Jeff Grant: Jeff Grant], ... 13 more ...)
- Precip (type: esriFieldTypeString, alias: Precipitation In Past 3 Days ?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- PrecipInches (type: esriFieldTypeSmallInteger, alias: Precipitation Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ApproxTemp (type: esriFieldTypeSmallInteger, alias: Approximate Temperature, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Wind (type: esriFieldTypeString, alias: Wind Present ?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Submerged (type: esriFieldTypeString, alias: Pipe Submerged ?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [No: No], [Partially: Partially], [Fully: Fully])
- 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])
- DebrisOils (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])
- DebrisSolids (type: esriFieldTypeString, alias: Debris Sewage Solids, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Odor (type: esriFieldTypeString, alias: Odor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Musty: Musty], [Sewage: Sewage])
- WaterClarity (type: esriFieldTypeString, alias: Water Clarity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clear: Clear], [Cloudy: Cloudy], [Opaque: Opaque], ... 1 more ...)
- PipeFlows (type: esriFieldTypeString, alias: Pipe Flow, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [None: None], [Trickle: Trickle], [Steady: Steady], ... 1 more ...)
- SeepFlow (type: esriFieldTypeString, alias: Seepage Flow, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [None: None], [Trickle: Trickle], [Steady: Steady], ... 1 more ...)
- FlowColor (type: esriFieldTypeString, alias: Flow Color, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Clear: Clear], [Brown: Brown], [Black: Black], ... 3 more ...)
- Sediment (type: esriFieldTypeString, alias: Sediment Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Open: Open], [Quarter: 1/4 Full], [Half: 1/2 Full], ... 2 more ...)
- Structure (type: esriFieldTypeString, alias: Structure Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Good: Good], [Fair: Fair], ... 1 more ...)
- Litter (type: esriFieldTypeString, alias: Trash / Litter, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- YardWaste (type: esriFieldTypeString, alias: Yard Waste, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FollowUp (type: esriFieldTypeString, alias: Follow-Up Required, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: created_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)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- IllicitDischarge (type: esriFieldTypeString, alias: Illicit Discharge, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- IllicitDischargeComments (type: esriFieldTypeString, alias: Illicit Discharge Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
Templates:
Name: Outfall Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/17/2022 8:03:09 PM
Schema Last Edit Date: 5/17/2022 8:03:09 PM
Data Last Edit Date: 5/17/2022 8:03:09 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