Name: Catchbasin Inspections

Display Field: CleanedOut

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 4000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CleanedOut ( type: esriFieldTypeString, alias: Was catchbasin cleaned out?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Condition ( type: esriFieldTypeString, alias: Condition of catchbasin, length: 50 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• Damage ( type: esriFieldTypeString, alias: Catchbasin damage, length: 50 , Coded Values: [Crushed: Crushed] , [Sediment Filled (clogged): Sediment Filled (clogged)] , [Corrosion: Corrosion] , ...8 more... )
• Deposits ( type: esriFieldTypeString, alias: Deposits or stains, length: 50 , Coded Values: [Oily: Oily] , [Flow Line: Flow Line] , [Paint: Paint] , ...1 more... )
• PipeAlgae ( type: esriFieldTypeString, alias: Pipe algae or growth, length: 50 , Coded Values: [Brown: Brown] , [Green: Green] , [Orange: Orange] , ...1 more... )
• Precipitation ( type: esriFieldTypeString, alias: Previous 48 hours precipitation >0.1 inches, length: 25 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• FlowPresent ( type: esriFieldTypeString, alias: Is flow present?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• FlowDescription ( type: esriFieldTypeString, alias: Description of flow, length: 50 , Coded Values: [None: None] , [Damp: Damp] , [Trickle: Trickle] , ...2 more... )
• Volume ( type: esriFieldTypeDouble, alias: Volume (liters) )
• FlowDepth ( type: esriFieldTypeDouble, alias: Flow depth (inches) )
• FlowWidth ( type: esriFieldTypeDouble, alias: Flow width (ft/in) )
• TravelTime ( type: esriFieldTypeDouble, alias: Time of travel (seconds) )
• IllicitDischarge ( type: esriFieldTypeString, alias: Do indicators suggest illicit discharge?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• TypeOfDischarge ( type: esriFieldTypeString, alias: Type of illicit discharge, length: 25 , Coded Values: [Sewer: Sewer] , [Washwater: Washwater] , [Detergent: Detergent] , ...1 more... )
• DischargeRemoved ( type: esriFieldTypeString, alias: Was illicit discharge removed?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• DateOfRemoval ( type: esriFieldTypeDate, alias: Date illicit discharge was removed, length: 8 )
• InvestigationClosed ( type: esriFieldTypeString, alias: Is investigation closed?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• DateClosed ( type: esriFieldTypeDate, alias: Date investigation was closed?, length: 8 )
• Non_IllicitConcerns ( type: esriFieldTypeString, alias: Describe any non-illicit discharge concerns, length: 250 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 250 )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• CMMS_ID ( type: esriFieldTypeString, alias: CMMS_ID, length: 50 )
• Weather ( type: esriFieldTypeString, alias: Weather at time of inspection, length: 100 )
• DepthToSump ( type: esriFieldTypeDouble, alias: Depth to sump (bottom of basin) )
• BasinFullPercent ( type: esriFieldTypeSmallInteger, alias: Percent basin full )
• BasinFullOver50 ( type: esriFieldTypeString, alias: Is basin over 50 full?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• MaintenanceNeeded ( type: esriFieldTypeString, alias: Is maintenance needed?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• PavementFailing ( type: esriFieldTypeString, alias: Pavement failing near grate, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• BrokenGrate ( type: esriFieldTypeString, alias: Broken grate, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• CannotRemoveGrate ( type: esriFieldTypeString, alias: Cannot remove grate, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• WallsFailing ( type: esriFieldTypeString, alias: Walls failing, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• CorbelFailing ( type: esriFieldTypeString, alias: Corbel failing, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• NoBottom ( type: esriFieldTypeString, alias: No bottom, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• NoOutletPipe ( type: esriFieldTypeString, alias: No outlet pipe, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• PipeBlocked ( type: esriFieldTypeString, alias: Pipe blocked, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• ExcessiveSediment ( type: esriFieldTypeString, alias: Excessive sediment, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• AsphaltConcrete ( type: esriFieldTypeString, alias: Asphalt or Concrete in structure, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• VactorCleaning ( type: esriFieldTypeString, alias: Requires vactor cleaning, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OtherMaintenance ( type: esriFieldTypeString, alias: Other maintenance needs, length: 255 )
• AdditionalObservations ( type: esriFieldTypeString, alias: Are there additional observations?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Foam ( type: esriFieldTypeString, alias: Is foam present?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Odor ( type: esriFieldTypeString, alias: Is there sanitary odor?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OdorSeverity ( type: esriFieldTypeString, alias: OdorSeverity, length: 50 , Coded Values: [Faint: Faint] , [Easily Detected: Easily Detected] , [Noticeable from a distance: Noticeable from a distance] )
• Oil ( type: esriFieldTypeString, alias: Is oil present?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Bacteria ( type: esriFieldTypeString, alias: Is bacteria present?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Trash ( type: esriFieldTypeString, alias: Is trash present?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Floatables ( type: esriFieldTypeString, alias: Floatables, length: 50 , Coded Values: [None: None] , [Sewage: Sewage] , [Subs/foam: Subs/foam] , ...3 more... )
• FloatableSeverity ( type: esriFieldTypeString, alias: FloatableSeverity, length: 50 , Coded Values: [None: None] , [Few/Slight - Origin not obvious: Few/Slight - Origin not obvious] , [Some - Indications or origins: Some - Indications or origins] , ...1 more... )
• Color ( type: esriFieldTypeString, alias: Color present, length: 40 , Coded Values: [Clear: Clear] , [Brown: Brown] , [Gray: Gray] , ...5 more... )
• ColorSeverity ( type: esriFieldTypeString, alias: ColorSeverity, length: 50 , Coded Values: [Faint colors in sample bottle: Faint colors in sample bottle] , [Clearly visible in sample bottle: Clearly visible in sample bottle] , [Clearly visible in outfall flow: Clearly visible in outfall flow] )
• Turbidity ( type: esriFieldTypeString, alias: Turbidity present, length: 40 , Coded Values: [Yes: Yes] , [No: No] )
• TurbiditySeverity ( type: esriFieldTypeString, alias: Severity of turbidity, length: 40 , Coded Values: [Slight cloudiness: Slight cloudiness] , [Cloudy: Cloudy] , [Opaque: Opaque] )
• OtherObservations ( type: esriFieldTypeString, alias: Other observations, length: 255 )
• created_user ( type: esriFieldTypeString, alias: Collected By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Collection Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Date record was last edited, length: 8 )

Relationships:

• dCatchbasin (1) -- Related To: Catchbasin (79)
• dCatchbasin (4) -- Related To: Drainage Manhole (76)
• dCatchbasin (7) -- Related To: Drain Grate (80)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata