Name: Utilities.DBO.Storm_Outfall_Inspection

Display Field: inspector

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Utilities.DBO.Storm_Outfall_Inspection
  Description:
  Prototype:
  phenols: null
  copper: null
  inspector: null
  inspectdt: null
  dryweather: null
  dateprecip: null
  amountprecip: null
  flow: null
  flowrate: null
  flowcolor: null
  colordesc: null
  colordesc_other: null
  flowodor: null
  odordesc: null
  odordesc_other: null
  flowfloatable: null
  floatabledesc: null
  floatabledesc_other: null
  recievingwater: null
  recievingwaterdesc: null
  illicitdischarge: null
  illicitdischargesource: null
  illicitdischargeaction: null
  notes: null
  assetguid: null
  ammonia: null
  detergent: null
  chlorine: null
  pH: null
  sheen: null
  flowsuff: null
  waterlevel: null
  submerged: null
  damaged: null
  erosion: null
  stainsetc: null
  benthicgrowth: null
  abnormalveg: null
  turbidity: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: lastupdate
• Editor Field: updatedby

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata