Name: OutfallInspectionTable

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• INSSTART ( nullable: true, length: 8, alias: Start DateTime, type: esriFieldTypeDate )
• FACILITYID ( nullable: true, length: 50, alias: Facility Identifier, type: esriFieldTypeString )
• DISCOVERED ( nullable: true, length: 30, alias: Catchbasin Found, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• LOCATION ( nullable: true, length: 20, alias: Location, type: esriFieldTypeString )
• CONDITION ( nullable: true, length: 50, alias: Condition, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• COLOR ( nullable: true, length: 50, alias: Color, type: esriFieldTypeString , Coded Values: [1: Clear] , [2: Cloudy] , [3: Yellow] , ...4 more... )
• ODOR ( nullable: true, length: 50, alias: Odor, type: esriFieldTypeString , Coded Values: [None: None] , [Musty: Musty] , [Sewage: Sewage] , ...2 more... )
• TURBITY ( nullable: true, length: 50, alias: Clarity/Turbidity, type: esriFieldTypeString , Coded Values: [Clear: Clear] , [Cloudy: Cloudy] , [Opaque: Opaque] , ...3 more... )
• OILSHEEN ( nullable: true, length: 50, alias: Oil Sheen, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• FIELDTEST ( nullable: true, length: 50, alias: Samples Taken, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• NOTES ( nullable: true, length: 255, alias: Site Notes, type: esriFieldTypeString )
• INSEND ( nullable: true, length: 8, alias: End DateTime, type: esriFieldTypeDate )
• WORKKEY ( nullable: true, length: 50, alias: Workorder ID, type: esriFieldTypeString )
• INSPECTOR ( nullable: true, length: 50, alias: Inspection User, type: esriFieldTypeString )
• INSSTATUS ( nullable: true, length: 50, alias: Inspection Status, type: esriFieldTypeString , Coded Values: [Completed: Completed] , [Maintenance Needed: Maintenance Needed (system needs repaired)] , [Further Investigation Needed: Further Investigation Needed (discharge/flow present)] , ...2 more... )
• LASTUPDATE ( nullable: true, length: 8, alias: Last Update Date, type: esriFieldTypeDate )
• LASTEDITOR ( nullable: true, length: 50, alias: Last Editor, type: esriFieldTypeString )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• RainfallTime ( nullable: true, length: 50, alias: Time Since Last Rainfall, type: esriFieldTypeString , Coded Values: [<72: <72 Hours] , [>72: >72 Hours] )
• RainfallAmt ( nullable: true, length: 50, alias: Amount of Last Rainfall, type: esriFieldTypeString , Coded Values: [< 0.1": <0.1"] , [>0.1": >0.1"] )
• AirTemp ( nullable: true, length: 50, alias: Air Temperture, type: esriFieldTypeString )
• InvestType ( nullable: true, length: 50, alias: Investigation Type, type: esriFieldTypeString , Coded Values: [Routine Screening: Routine Screening] , [Response to Complaint: Response to Complaint] , [Other: Other] )
• Flow ( nullable: true, length: 50, alias: Flow, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• FlowDepth ( nullable: true, alias: FlowDepth, type: esriFieldTypeDouble )
• FlowWidth ( nullable: true, alias: FlowWidth, type: esriFieldTypeDouble )
• FlowVelocity ( nullable: true, alias: FlowVelocity, type: esriFieldTypeDouble )
• Floatables ( nullable: true, length: 50, alias: Floatables, type: esriFieldTypeString , Coded Values: [None: None] , [Oil Sheen: Oil Sheen] , [Suds: Suds] , ...4 more... )
• DepositsStains ( nullable: true, length: 50, alias: Deposits/Stains, type: esriFieldTypeString , Coded Values: [None: None] , [Sediment: Sediment] , [Oily: Oily] , ...2 more... )
• Vegetation ( nullable: true, length: 50, alias: Vegetation, type: esriFieldTypeString , Coded Values: [None: None] , [Normal: Normal] , [Excessive Growth: Excessive Growth] , ...2 more... )
• StructuralCondition ( nullable: true, length: 50, alias: StructuralCondition, type: esriFieldTypeString , Coded Values: [Normal: Normal] , [Other: Other] , [Cracks: Cracks] , ...1 more... )
• PhotosTaken ( nullable: true, length: 50, alias: PhotosTaken, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• ChemParaTemp ( nullable: true, length: 50, alias: Chemical Parameter Temperature, type: esriFieldTypeString )
• ChemParapH ( nullable: true, length: 50, alias: Chem Parameter pH, type: esriFieldTypeString )
• ChemParaCond ( nullable: true, length: 50, alias: Chemical Parameter Conductivity, type: esriFieldTypeString )
• ChemParaDetergent ( nullable: true, length: 50, alias: Chemical Parameter Detergent, type: esriFieldTypeString )
• ChemParaAmmonia ( nullable: true, length: 50, alias: Chemical Parameter Ammonia, type: esriFieldTypeString )
• ChemParaTurb ( nullable: true, length: 50, alias: Chemical Parameter Turbidity, type: esriFieldTypeString )
• Comments ( nullable: true, length: 250, alias: Comments, type: esriFieldTypeString )
• WaterTemp ( nullable: true, length: 10, alias: Water Temp, type: esriFieldTypeString )
• ImpactedLnth ( nullable: true, length: 50, alias: Length of Impacted Stream, type: esriFieldTypeString , Coded Values: [<10': <10'] , [10'-50': 10'-50'] , [>50': >50'] )
• FlowType ( nullable: true, length: 50, alias: Flow Type, type: esriFieldTypeString , Coded Values: [Trickle: Trickle] , [Low Flow: Low Flow] , [Heavy Flow: Heavy Flow] , ...1 more... )

Relationships:

• Outfalls (0) -- Related To: Storm Outfalls (24)

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

  Iteminfo   Thumbnail   Metadata