Name: Outfall_Inspections

Display Field: PKey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PKey ( type: esriFieldTypeInteger, alias: PKey )
• Outfall_ID ( type: esriFieldTypeString, alias: Outfall_ID, length: 50 )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, length: 8 )
• Investigator ( type: esriFieldTypeString, alias: Investigator, length: 50 , Coded Values: [JC: Jeremy Cooper] , [DS: David Stowe] , [TW: Timothy Wall] )
• Completed_By ( type: esriFieldTypeString, alias: Completed_By, length: 50 , Coded Values: [JC: Jeremy Cooper] , [DS: David Stowe] , [TW: Timothy Wall] )
• Air_Temp ( type: esriFieldTypeString, alias: Air_Temp, length: 50 )
• Rainfall_Last24 ( type: esriFieldTypeString, alias: Rainfall_Last24, length: 50 )
• Rainfall_Last48 ( type: esriFieldTypeString, alias: Rainfall_Last48, length: 50 )
• LandUse_Industrial ( type: esriFieldTypeString, alias: LandUse_Industrial, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LandUse_UltraUrbanResidential ( type: esriFieldTypeString, alias: LandUse_UltraUrbanResidential, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LandUse_SuburbanResidential ( type: esriFieldTypeString, alias: LandUse_SuburbanResidential, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LandUse_Commercial ( type: esriFieldTypeString, alias: LandUse_Commercial, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LandUse_OpenSpace ( type: esriFieldTypeString, alias: LandUse_OpenSpace, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LandUse_Institutional ( type: esriFieldTypeString, alias: LandUse_Institutional, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LandUse_Other ( type: esriFieldTypeString, alias: LandUse_Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• LandUse_OtherDescription ( type: esriFieldTypeString, alias: LandUse_OtherDescription, length: 200 )
• Know_Industries ( type: esriFieldTypeString, alias: Know_Industries, length: 50 )
• Background_Notes ( type: esriFieldTypeString, alias: Background_Notes, length: 200 )
• ClosedPipe_SubmergedWater ( type: esriFieldTypeString, alias: ClosedPipe_SubmergedWater, length: 50 , Coded Values: [No: No] , [Partially: Partially] , [Fully: Fully] )
• ClosedPipe_SubmergedSediment ( type: esriFieldTypeString, alias: ClosedPipe_SubmergedSediment, length: 50 , Coded Values: [No: No] , [Partially: Partially] , [Fully: Fully] )
• InStream ( type: esriFieldTypeString, alias: InStream, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• FlowPresent ( type: esriFieldTypeString, alias: FlowPresent, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• FlowDescription ( type: esriFieldTypeString, alias: FlowDescription, length: 50 , Coded Values: [Trickle: Trickle] , [Less than 1/3 full: Less than 1/3 full] , [1/3 to 2/3 Full: 1/3 to 2/3 Full] , ...1 more... )
• Temperature ( type: esriFieldTypeString, alias: Temperature, length: 50 )
• pH ( type: esriFieldTypeDouble, alias: pH )
• Ammonia ( type: esriFieldTypeString, alias: Ammonia, length: 50 )
• Physical_Indicators ( type: esriFieldTypeString, alias: PhysicalIndicators, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Odors_Sewage ( type: esriFieldTypeString, alias: Odors_Sewage, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Odor_Rancid_Sour ( type: esriFieldTypeString, alias: Odor_Rancid, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Odor_Petroleum_Gas ( type: esriFieldTypeString, alias: Odor_Petroleum_Gas, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Odor_Sulfide ( type: esriFieldTypeString, alias: Odor_Sulfide, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Odor_Other ( type: esriFieldTypeString, alias: Odor_Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Odor_OtherDesc ( type: esriFieldTypeString, alias: Odor_OtherDesc, length: 200 )
• Odor_RelativeSeverityIndex ( type: esriFieldTypeString, alias: Odor_RelativeSeverityIndex, length: 50 , Coded Values: [Faint: Faint] , [Easily Detected: Easily Detected] , [Noticeable from Distance: Noticeable from Distance] , ...1 more... )
• Color_Clear ( type: esriFieldTypeString, alias: Color_Clear, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Color_Brown ( type: esriFieldTypeString, alias: Color_Brown, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Color_Grey ( type: esriFieldTypeString, alias: Color_Grey, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Color_Yellow ( type: esriFieldTypeString, alias: Color_Yellow, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Color_Green ( type: esriFieldTypeString, alias: Color_Green, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Color_Orange ( type: esriFieldTypeString, alias: Color_Orange, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Color_Red ( type: esriFieldTypeString, alias: Color_Red, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Color_Other ( type: esriFieldTypeString, alias: Color_Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Color_OtherDesc ( type: esriFieldTypeString, alias: Color_OtherDesc, length: 200 )
• Color_RelativeSeverityIndex ( type: esriFieldTypeString, alias: Color_RelativeSeverityIndex, length: 50 , Coded Values: [Faint Colors: Faint colors in sample bottle] , [Clearly Visible: Clearly visible in sample bottle] , [Outfall Flow: Clearly visible in outfall flow] , ...1 more... )
• Turbidity ( type: esriFieldTypeString, alias: Turbidity, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Turbidity_RelativeSeverityIndex ( type: esriFieldTypeString, alias: Turbidity_RelativeSeverityIndex, length: 50 , Coded Values: [Slight Cloudiness: Slight Cloudiness] , [Cloudy: Cloudy] , [Opaque: Opaque] , ...1 more... )
• Floatables_Sewage ( type: esriFieldTypeString, alias: Floatables_Sewage, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Floatables_Petroleum ( type: esriFieldTypeString, alias: Floatables_Petroleum, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Floatables_Other ( type: esriFieldTypeString, alias: Floatables_Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Floatables_OtherDesc ( type: esriFieldTypeString, alias: Floatables_OtherDesc, length: 200 )
• Floatables_RelativeSeverityInde ( type: esriFieldTypeString, alias: Floatables_RelativeSeverityIndex, length: 50 , Coded Values: [Few or Slight: Few or slight, origin not obvious] , [Some Indications: Indications of origin] , [Some Origin Clear: Origin clear] , ...1 more... )
• Indicators_Flow_Present ( type: esriFieldTypeString, alias: Indicators_Flow_Present, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Damage_Cracking ( type: esriFieldTypeString, alias: Damage_Cracking, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Damage_PeelingPaint ( type: esriFieldTypeString, alias: Damage_PeelingPaint, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Damage_Corrosion ( type: esriFieldTypeString, alias: Damage_Corrosion, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Damage_Comments ( type: esriFieldTypeString, alias: Damage_Comments, length: 50 )
• Deposits_Oily ( type: esriFieldTypeString, alias: Deposits_Oily, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deposits_FlowLine ( type: esriFieldTypeString, alias: Deposits_FlowLine, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deposits_Paint ( type: esriFieldTypeString, alias: Deposits_Paint, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deposits_Other ( type: esriFieldTypeString, alias: Deposits_Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• Deposits_OtherDesc ( type: esriFieldTypeString, alias: Deposits_OtherDesc, length: 200 )
• Deposits_OtherComments ( type: esriFieldTypeString, alias: Deposits_OtherComments, length: 200 )
• AbnormalVegetation_Excessive ( type: esriFieldTypeString, alias: AbnormalVegetation_Excessive, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• AbnormalVegetation_Inhibited ( type: esriFieldTypeString, alias: AbnormalVegetation_Inhibited, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• AbnormalVegetation_Comments ( type: esriFieldTypeString, alias: AbnormalVegetation_Comments, length: 200 )
• PoorPoolQuality_Odors ( type: esriFieldTypeString, alias: PoorPoolQuality_Odors, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PoorPoolQuality_Colors ( type: esriFieldTypeString, alias: PoorPoolQuality_Colors, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PoorPoolQuality_Floatables ( type: esriFieldTypeString, alias: PoorPoolQuality_Floatables, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PoorPoolQuality_OilSheen ( type: esriFieldTypeString, alias: PoorPoolQuality_OilSheen, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PoorPoolQuality_Suds ( type: esriFieldTypeString, alias: PoorPoolQuality_Suds, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PoorPoolQuality_ExcessiveAlgea ( type: esriFieldTypeString, alias: PoorPoolQuality_ExcessiveAlgea, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PoorPoolQuality_Other ( type: esriFieldTypeString, alias: PoorPoolQuality_Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• PoorPoolQuality_OtherDesc ( type: esriFieldTypeString, alias: PoorPoolQuality_OtherDesc, length: 200 )
• PoorPoolQuality_Comments ( type: esriFieldTypeString, alias: PoorPoolQuality_Comments, length: 200 )
• PipeBenthicGrowth_Brown ( type: esriFieldTypeString, alias: PipeBenthicGrowth_Brown, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PipeBenthicGrowth_Orange ( type: esriFieldTypeString, alias: PipeBenthicGrowth_Orange, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PipeBenthicGrowth_Green ( type: esriFieldTypeString, alias: PipeBenthicGrowth_Green, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PipeBenthicGrowth_Other ( type: esriFieldTypeString, alias: PipeBenthicGrowth_Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• PipeBenthicGrowth_OtherDesc ( type: esriFieldTypeString, alias: PipeBenthicGrowth_OtherDesc, length: 200 )
• PipeBenthicGrowth_Comments ( type: esriFieldTypeString, alias: PipeBenthicGrowth_Comments, length: 200 )
• Characterization ( type: esriFieldTypeString, alias: Characterization, length: 50 , Coded Values: [Unlikely: Unlikely] , [Potential: Presence of two or more indicators] , [Suspect: One or more indicators with a severity of 3] , ...2 more... )
• AmmoniaTest ( type: esriFieldTypeString, alias: AmmoniaTest, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Ammonia_Reading ( type: esriFieldTypeString, alias: Ammonia_Reading, length: 50 )
• AmmoniaSource ( type: esriFieldTypeString, alias: AmmoniaSource, length: 50 , Coded Values: [Flow: Flow] , [Pool: Pool] , [UpStream: Upstream Structure] )
• TrapSet ( type: esriFieldTypeString, alias: TrapSet, length: 50 , Coded Values: [Not Set: No test] , [OBM: OBM] , [Caulk Dam: Caulk Dam] )
• DischargeConcern_Comments ( type: esriFieldTypeString, alias: DischargeConcern_Comments, length: 200 )
• SnowCoverage ( type: esriFieldTypeString, alias: SnowCoverage, length: 10 )
• ChlorineTest ( type: esriFieldTypeString, alias: ChlorineTest, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• ChlorineReading ( type: esriFieldTypeString, alias: ChlorineReading, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• DBO.swOutlet (0) -- Related To: Stormwater Sewer Outlet (4)

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

  Iteminfo   Thumbnail   Metadata