Layer: England Unmonitored CSOs 2020 (ID:0)

View In: Map Viewer

Name: England Unmonitored CSOs 2020

Display Field: COMPANY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

This data was created using the Consented Discharges to Controlled Waters database from the Environment Agency’s Public Register. A join was performed to calculate those CSOs which were not located using matching permit numbers in the annual return EDM data provided by the EA for 2020. The CSOs which were located were then removed from this layer to leave those that are unmonitored. CABA IDs have been added to this layer.

Copyright Text: Environment Agency Conditional Licence. View full conditions on data.gov.uk. Attribution statement: © Environment Agency copyright and/or database right 2020. 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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[255,255,255,255],"size":7.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[99,79,63,255],"width":1.5,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

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: Name of company/individual holding permit, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
DISCHARGE_SITE_NAME (type: esriFieldTypeString, alias: Name of site where discharge is occuring, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
DSI_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: Description of type of site, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
ADD_OF_DISCHARGE_SITE_LINE_1 (type: esriFieldTypeString, alias: Address line 1, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
ADD_OF_DISCHARGE_SITE_LINE_2 (type: esriFieldTypeString, alias: Address line 2, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
ADD_OF_DISCHARGE_SITE_LINE_3 (type: esriFieldTypeString, alias: Address line 3, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
ADD_OF_DISCHARGE_SITE_LINE_4 (type: esriFieldTypeString, alias: Address line 4, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
ADD_OF_DISCHARGE_SITE_PCODE (type: esriFieldTypeString, alias: Postcode, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
DISTRICT_COUNCIL (type: esriFieldTypeString, alias: District council, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
CATC_NAME (type: esriFieldTypeString, alias: CATC_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
SOURCE (type: esriFieldTypeString, alias: Environment Agency region full description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
PERMIT_NUMBER (type: esriFieldTypeString, alias: Permit number, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
RECEIVING_WATER (type: esriFieldTypeString, alias: Receiving water, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
RECEIVING_ENVIRON_TYPE_CODE (type: esriFieldTypeString, alias: Receiving water type, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
EFFECTIVE_DATE (type: esriFieldTypeDate, alias: Date permit became effective, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
STATUS_DESCRIPTION (type: esriFieldTypeString, alias: Code for relevant section/schedule of act of Parliament, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
OUTLET_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: Description of type of outlet, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
OUTLET_GRID_REF (type: esriFieldTypeString, alias: Grid reference of outlet, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
EFF_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: Description of type of effluent, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
EFFLUENT_GRID_REF (type: esriFieldTypeString, alias: Grid reference of effluent sampling point, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
CaBA_Partnership (type: esriFieldTypeString, alias: CaBA Partnership, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CaBA_ID (type: esriFieldTypeSmallInteger, alias: CaBA ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
CaBA_Catchment (type: esriFieldTypeString, alias: CaBA Catchment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Easting (type: esriFieldTypeSingle, alias: Easting, SQL Type: sqlTypeOther, nullable: true, editable: true)
Northing (type: esriFieldTypeSingle, alias: Northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
RT_comments (type: esriFieldTypeString, alias: The Rivers Trust comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/7/2021 7:36:02 AM

Schema Last Edit Date: 4/7/2021 7:36:02 AM

Data Last Edit Date: 4/7/2021 7:36:02 AM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat