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:

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

Attributes:

Relationships:

• Drainage_Outfalls (0) -- Related To: Drainage Outfalls (0)

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