Name: Dry Weather Screening Report

Display Field: DWF

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

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 )
• DWF ( type: esriFieldTypeString, alias: Dry Weather Flow, editable: true, nullable: true, length: 255, defaultValue: No, modelName: DWF , Coded Values: [Yes: Yes] , [No: No] )
• DFWDESC ( type: esriFieldTypeString, alias: Dry Last 48 Hours, editable: true, nullable: true, length: 255, defaultValue: No, modelName: DFWDESC , Coded Values: [Yes: Yes] , [No: No] )
• ODOR ( type: esriFieldTypeString, alias: Odor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ODOR , Coded Values: [Sewage: Sewage] , [Rotten Eggs: Rotten Eggs] , [Rancid/Sour: Rancid/Sour] , ...5 more... )
• SFSEV ( type: esriFieldTypeSmallInteger, alias: Stream Flow Rate (if known), editable: true, nullable: true, defaultValue: null, modelName: SFSEV , Coded Values: [1: Low] , [2: Normal] , [3: High] )
• ODORSEV ( type: esriFieldTypeString, alias: Odor Strength, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ODORSEV , Coded Values: [1: Faint] , [2: Moderate] , [3: Unbearable] , ...1 more... )
• COLOR ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COLOR , Coded Values: [Black: Black] , [Blue: Blue] , [Brown: Brown] , ...7 more... )
• TURBIDITY ( type: esriFieldTypeString, alias: Turbidity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TURBIDITY , Coded Values: [1: Slight Cloudiness] , [2: Cloudy] , [3: Opaque] , ...1 more... )
• FLOATABLES ( type: esriFieldTypeString, alias: Floatables (not including trash), editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOATABLES , Coded Values: [Sewage: Sewage] , [Petroleum: Petroleum] , [Suds: Suds] , ...2 more... )
• DEPOSITS_STAINS ( type: esriFieldTypeString, alias: Deposits/Stains, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DEPOSITS_STAINS , Coded Values: [Grease: Grease] , [Mineral: Mineral] , [Oil: Oil] , ...3 more... )
• FLOATABLES_SCALE ( type: esriFieldTypeString, alias: Floatables Severity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOATABLES_SCALE , Coded Values: [1: Slight] , [2: Some] , [3: Massive/Severe] , ...1 more... )
• DEPOSITS_SCALE ( type: esriFieldTypeString, alias: Deposits Severity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DEPOSITS_SCALE , Coded Values: [1: Slight] , [2: Some] , [3: Massive/Severe] , ...1 more... )
• VEGETATION ( type: esriFieldTypeString, alias: Vegetation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VEGETATION , Coded Values: [Algae: Algae] , [Dead: Dead] , [Excessive: Excessive] , ...2 more... )
• FISHKILL ( type: esriFieldTypeString, alias: Fish Kill, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FISHKILL , Coded Values: [Small: Small <5 Fish] , [Medium: Medium] , [Large: Large] , ...1 more... )
• OTHER_OBSERVATIONS ( type: esriFieldTypeString, alias: Other Observations, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHER_OBSERVATIONS )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• DWS ( type: esriFieldTypeString, alias: Dry Weather Screening, editable: true, nullable: true, length: 255, defaultValue: Dry, modelName: DWS , Coded Values: [Dry: Dry Weather Screening] , [Rain: Post-Rain Screening] )
• FIELD_CREW ( type: esriFieldTypeString, alias: Field Crew, editable: true, nullable: true, length: 255, defaultValue: Kim, modelName: FIELD_CREW , Coded Values: [Alex: Alex Pitts] , [Blair: Blair McClenathan] , [Bob: Robert Bianchi] , ...5 more... )
• LAST_RAINFALL ( type: esriFieldTypeString, alias: Last Rainfall, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAST_RAINFALL , Coded Values: [0-2: 0-2 Days] , [>2: >2 Days] , [Now: Raining Now] , ...1 more... )
• LR_AMOUNT ( type: esriFieldTypeString, alias: Last Rainfall Amount, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LR_AMOUNT , Coded Values: [<.1: <0.1"] , [>.1: >0.1"] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FACILITYID )
• SOURCE_IFKNWN ( type: esriFieldTypeString, alias: Source Of Discarge (If Known), editable: true, nullable: true, length: 255, defaultValue: null, modelName: SOURCE_IFKNWN )
• SAMPLE_COLLECTED ( type: esriFieldTypeString, alias: Sample Collected, editable: true, nullable: true, length: 255, defaultValue: No, modelName: SAMPLE_COLLECTED , Coded Values: [Yes: Yes] , [No: No] )
• PHOTO_TAKEN ( type: esriFieldTypeString, alias: Photo Taken, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_TAKEN , Coded Values: [Yes: Yes] , [No: No] )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WATERSHED )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• PROGYR ( type: esriFieldTypeSmallInteger, alias: Program Year, editable: true, nullable: true, defaultValue: null, modelName: PROGYR )
• POST_AMMONIA ( type: esriFieldTypeDouble, alias: Ammonia (ppm), editable: true, nullable: true, defaultValue: null, modelName: POST_AMMONIA )
• POST_SURF ( type: esriFieldTypeDouble, alias: Surfactants (ppm), editable: true, nullable: true, defaultValue: null, modelName: POST_SURF )
• POST_POTAS ( type: esriFieldTypeDouble, alias: Potassium (ppm), editable: true, nullable: true, defaultValue: null, modelName: POST_POTAS )
• POST_CHLOR ( type: esriFieldTypeDouble, alias: Chlorine (ppm), editable: true, nullable: true, defaultValue: null, modelName: POST_CHLOR )
• POST_AP ( type: esriFieldTypeDouble, alias: A/P Ratio, editable: true, nullable: true, defaultValue: null, modelName: POST_AP )
• POST_DATE ( type: esriFieldTypeDate, alias: Date Tested, editable: true, nullable: true, length: 8, defaultValue: null, modelName: POST_DATE )

Templates:

• Name: Dry Weather Screening Report
  Description:
  Prototype:
  POST_AP: null
  POST_CHLOR: null
  DWF: No
  DFWDESC: No
  ODOR: null
  SFSEV: null
  ODORSEV: null
  COLOR: null
  TURBIDITY: null
  FLOATABLES: null
  DEPOSITS_STAINS: null
  FLOATABLES_SCALE: null
  DEPOSITS_SCALE: null
  VEGETATION: null
  FISHKILL: null
  OTHER_OBSERVATIONS: null
  DATE: null
  DWS: Dry
  FIELD_CREW: Kim
  LAST_RAINFALL: null
  LR_AMOUNT: null
  FACILITYID: null
  SOURCE_IFKNWN: null
  SAMPLE_COLLECTED: No
  PHOTO_TAKEN: null
  WATERSHED: null
  POST_DATE: null
  POST_POTAS: null
  POST_SURF: null
  POST_AMMONIA: null
  PROGYR: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• UTILITY_MASTER_SDE.DBO.dOutfall (0) -- Related To: Outfall (3)

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

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: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

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   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata