Name: Event Duration Monitoring - Storm Overflows - 2020
Display Field: Company_name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: The dataset includes Water and Sewerage Company with storm overflows in England, describing how often and for how long, monitored storm overflows discharged during 2020. The Water and Sewerage Companies provide this regulatory return to the Environment Agency each year to fulfil their permitted conditions to discharge from these storm overflows under the Environmental Permitting Regulations.
Copyright Text: © Environment Agency copyright and/or database right 2015. All rights reserved.
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -1E-06
YMin: -1E-06
XMax: 654800.00012207
YMax: 654740.00012207
Spatial Reference: 27700 (27700)
Drawing Info:
{"renderer":{"authoringInfo":{"type":"classedSize","classificationMethod":"esriClassifyManual"},"type":"classBreaks","field":"Counted_spills","legendOptions":{"order":"ascendingValues"},"minValue":0,"classBreakInfos":[{"symbol":{"color":[99,79,63,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,203],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"0","classMaxValue":0},{"symbol":{"color":[99,79,63,255],"size":6.3333333333333339,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,203],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"1 - 19","classMaxValue":19},{"symbol":{"color":[99,79,63,255],"size":8.6666666666666679,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,203],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"20 - 39","classMaxValue":39},{"symbol":{"color":[99,79,63,255],"size":11,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,203],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"40 - 59","classMaxValue":59},{"symbol":{"color":[99,79,63,255],"size":13.333333333333334,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,203],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"60 - 99","classMaxValue":99},{"symbol":{"color":[99,79,63,255],"size":18,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,203],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"100+","classMaxValue":378}],"classificationMethod":"esriClassifyManual"},"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Company_name (type: esriFieldTypeString, alias: Water company name, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Site_Name (type: esriFieldTypeString, alias: Site name, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Permit_number (type: esriFieldTypeString, alias: Permit number, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Activity_reference (type: esriFieldTypeString, alias: Activity reference if more than one discharge, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Shellfishery (type: esriFieldTypeString, alias: Shellfishery (Only populated for storm overflows that have shellfish water EDM requirements), SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Bathing_beach (type: esriFieldTypeString, alias: Bathing Beach (Only populated for storm overflows that have bathing water EDM requirements), SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Counted_spills (type: esriFieldTypeInteger, alias: Counted spills using 12/24 hour block counting method, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Total_Duration_hrs (type: esriFieldTypeSingle, alias: Total duration (hours) of all spills prior to processing through 12-24 hour counting method, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Percentage_operational (type: esriFieldTypeSingle, alias: % of reporting period EDM operational, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 100])
- Comments (type: esriFieldTypeString, alias: Water company comments, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Years_operational (type: esriFieldTypeSmallInteger, alias: Number of years EDM operational, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Significant_spills_SW (type: esriFieldTypeInteger, alias: Number of significant counted spills during the reporting period (for shellfish waters), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Significant_spills_BW (type: esriFieldTypeInteger, alias: Number of significant spills during the bathing season (for bathing waters), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Spill_frequency_trigger_BW_SW (type: esriFieldTypeString, alias: Spill frequency trigger on permit for shellfish waters and bathing waters, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Permit_no_full_name_UU (type: esriFieldTypeString, alias: Permit name alternative to permit number for United Utilities, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Permit_no_best_match_UU (type: esriFieldTypeString, alias: Permit number best match - Alternative permit number for United Utilities, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Folio_SW (type: esriFieldTypeString, alias: Alternative to permit number for Southern Water, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- Data_source (type: esriFieldTypeString, alias: Data source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Spill_count_class (type: esriFieldTypeString, alias: Spill count classification using RT Thresholds, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
- RT_comments (type: esriFieldTypeString, alias: The Rivers Trust comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Templates:
Name: Event Duration Monitoring - Storm Overflows - 2020
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 11/16/2021 4:54:00 PM
Schema Last Edit Date: 11/16/2021 4:54:00 PM
Data Last Edit Date: 11/16/2021 4:54:00 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat