Name: Utilities.DBO.Storm_Outfall_Inspection

Display Field: inspector

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• inspectdt ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• dryweather ( type: esriFieldTypeSmallInteger, alias: Dry Weather Inspection? , Coded Values: [1: Yes] , [2: No] )
• dateprecip ( type: esriFieldTypeDate, alias: Date of Last Precipitation, length: 8 )
• amountprecip ( type: esriFieldTypeDouble, alias: Amount of Last Precipitation )
• flow ( type: esriFieldTypeSmallInteger, alias: Flow Present? , Coded Values: [1: Yes] , [2: No] )
• flowrate ( type: esriFieldTypeSmallInteger, alias: Flow Rate , Coded Values: [1: Slow (<2 ft/s)] , [2: Moderate (2-5 ft/s)] , [3: Fast (>5 ft/s)] )
• flowcolor ( type: esriFieldTypeSmallInteger, alias: Flow contains color? , Coded Values: [1: Yes] , [2: No] )
• colordesc ( type: esriFieldTypeSmallInteger, alias: Color Description , Coded Values: [0: Brown] , [1: Clear] , [2: Green] , ...5 more... )
• colordesc_other ( type: esriFieldTypeString, alias: Specify other, length: 50 )
• flowodor ( type: esriFieldTypeSmallInteger, alias: Flow contains odor? , Coded Values: [1: Yes] , [2: No] )
• odordesc ( type: esriFieldTypeSmallInteger, alias: Odor Description , Coded Values: [0: Sewage] , [1: Sulfide] , [2: Rancid/Sour] , ...2 more... )
• odordesc_other ( type: esriFieldTypeString, alias: Specify other, length: 50 )
• flowfloatable ( type: esriFieldTypeSmallInteger, alias: Flow contains floatables? , Coded Values: [1: Yes] , [2: No] )
• floatabledesc ( type: esriFieldTypeSmallInteger, alias: Floatable Description , Coded Values: [0: Sewage] , [1: Suds] , [2: Petroleum] , ...1 more... )
• floatabledesc_other ( type: esriFieldTypeString, alias: Specify other, length: 50 )
• recievingwater ( type: esriFieldTypeSmallInteger, alias: Change in recieving water? , Coded Values: [1: Yes] , [2: No] )
• recievingwaterdesc ( type: esriFieldTypeString, alias: Description of Change, length: 150 )
• illicitdischarge ( type: esriFieldTypeSmallInteger, alias: Is Flow Illicit Discharge? , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• illicitdischargesource ( type: esriFieldTypeString, alias: Efforts to determine source, length: 150 )
• illicitdischargeaction ( type: esriFieldTypeString, alias: Corrective Action Taken, length: 150 , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• assetguid ( type: esriFieldTypeGUID, alias: Asset GUID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• flowsuff ( type: esriFieldTypeSmallInteger, alias: Flow sufficient to sample? Flow sufficient to sample? Flow sufficient to sample? , Coded Values: [1: Yes] , [2: No] )
• waterlevel ( type: esriFieldTypeDouble, alias: Water Level )
• submerged ( type: esriFieldTypeSmallInteger, alias: Submerged? , Coded Values: [1: Yes] , [2: No] )
• damaged ( type: esriFieldTypeSmallInteger, alias: Damaged? , Coded Values: [1: Yes] , [2: No] )
• erosion ( type: esriFieldTypeSmallInteger, alias: Erosion? , Coded Values: [1: Yes] , [2: No] )
• stainsetc ( type: esriFieldTypeSmallInteger, alias: Stains, Deposits, Sediment? , Coded Values: [1: Yes] , [2: No] )
• benthicgrowth ( type: esriFieldTypeSmallInteger, alias: Benthic Growth? , Coded Values: [1: Yes] , [2: No] )
• abnormalveg ( type: esriFieldTypeSmallInteger, alias: Abnormal Vegetation? , Coded Values: [1: Yes] , [2: No] )
• turbidity ( type: esriFieldTypeSmallInteger, alias: Turbidity? , Coded Values: [1: Yes] , [2: No] )
• sheen ( type: esriFieldTypeSmallInteger, alias: Surface Sheen? , Coded Values: [1: Yes] , [2: No] )
• pH ( type: esriFieldTypeDouble, alias: pH )
• chlorine ( type: esriFieldTypeDouble, alias: Chlorine )
• detergent ( type: esriFieldTypeDouble, alias: Detergent )
• copper ( type: esriFieldTypeDouble, alias: Copper )
• phenols ( type: esriFieldTypeDouble, alias: Phenols )
• ammonia ( type: esriFieldTypeDouble, alias: Ammonia )

Relationships:

• (0) -- Related To: Storm_Outlet (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata