Name: Pollution_Watchdog

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","label":"Pollution Watchdog","description":"Survey Data Locations","symbol":{"color":[20,158,206,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,38,115,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• note_intro (type: esriFieldTypeString, alias: Please take photos of the pollution using your mobile device's camera first, and then fill in this survey. Saving the photos to your device memory ensures the evidence is backed up in case of a problem when uploading your survey data., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gdpr_statement (type: esriFieldTypeString, alias: Please include your contact details so we can follow up and address any queries whilst processing the data. See our privacy policy., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: Your name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incident_date (type: esriFieldTypeDate, alias: Date of pollution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rain_48hr (type: esriFieldTypeString, alias: Recent weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Heavy: Heavy rain within the last 48 hours], [Light: Light rain within the last 48 hours], [None: No rain for 48 hours], ... 1 more ...)
• what3words (type: esriFieldTypeString, alias: what3words, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lat_long (type: esriFieldTypeString, alias: lat_long, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_location (type: esriFieldTypeString, alias: note_location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location_description (type: esriFieldTypeString, alias: Describe the location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bankside (type: esriFieldTypeString, alias: Which bank is the outfall on?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Left: Left], [Right: Right], [Middle: Middle], ... 1 more ...)
• flow_rate (type: esriFieldTypeString, alias: Please rate the flow at the outfall, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: No flow], [1: Trickle], [2: Low flow], ... 2 more ...)
• visual_impact (type: esriFieldTypeString, alias: Extent of the visual impact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: No visible effect], [2: Within 2 metres], [4: 2 - 10 metres], ... 2 more ...)
• visual_impact_score (type: esriFieldTypeInteger, alias: visual_impact_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aesthetics (type: esriFieldTypeString, alias: Aesthetics of the visible pollution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: No odour or visible aesthetics], [2: Faint smell, slight discoloration], [4: Moderate smell, moderate discoloration, small coverage of sewage fungus], ... 2 more ...)
• aesthetics_score (type: esriFieldTypeInteger, alias: aesthetics_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sewage_debris (type: esriFieldTypeString, alias: Is there sewage related debris?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• diagram_debris (type: esriFieldTypeString, alias: diagram_debris, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• other_pollution (type: esriFieldTypeString, alias: Is there any evidence of other forms of pollution?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• diagram_oil_fat (type: esriFieldTypeString, alias: diagram_oil_fat, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• total_score (type: esriFieldTypeInteger, alias: total_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• contact (type: esriFieldTypeString, alias: contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• call_water_company (type: esriFieldTypeString, alias: This is a significant pollution incident. Please report to Severn Trent Water immediately by calling 08007834444., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• call_environment_agency (type: esriFieldTypeString, alias: This is a serious pollution incident. Please report this to the Environment Agency incident hotline immediately by calling 0800 80 70 60 (24-hour service)., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contacted (type: esriFieldTypeString, alias: contacted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• note_incident_details (type: esriFieldTypeString, alias: note_incident_details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reporting_checklist (type: esriFieldTypeString, alias: Reporting checklist, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incident_number (type: esriFieldTypeString, alias: Incident number / job reference code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reporting_satisfaction_score (type: esriFieldTypeString, alias: How satisfied were you with the response you received from the hotline?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Very dissatisfied], [2: Dissatisfied], [3: Moderately satisfied/unsure], ... 2 more ...)
• reporting_comments (type: esriFieldTypeString, alias: Any other comments or feedback on the process?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_no_investigation (type: esriFieldTypeString, alias: This is a minor pollution incident and no immediate action is required at this stage. This evidence is still important and will be logged in our database. Information about minor incidents will be compiled into a report and made available to the water company, the regulator and the local catchment partnership to help plan future investigations., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• call_water_company_minor (type: esriFieldTypeString, alias: A possible clean up is required. Please contact Severn Trent Water by calling 0800 783 4444 and let them know that you've found a build up of sewage debris. This can be done when you get home if you prefer, as it does not require an urgent investigation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reported_sewage_debris (type: esriFieldTypeString, alias: reported_sewage_debris, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• note_outfall_details (type: esriFieldTypeString, alias: note_outfall_details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_contact (type: esriFieldTypeString, alias: For extra information email: projects@trentriverstrust.org, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_logo (type: esriFieldTypeString, alias: note_logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• Pollution_Watchdog_Follow_up (1) -- Related To: Follow_up (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/6/2022 10:03:11 AM

Schema Last Edit Date: 2/6/2022 10:03:11 AM

Data Last Edit Date: 2/6/2022 10:03:11 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat