Post

2 followers Follow
0
Avatar

Consented Discharges to Controlled Waters with Conditions data relationships

Hi,

Am I right in thinking that to create a flat table from the look ups for determinands and effluents you have to look up using Permit Number/Permit Ref, Effluent Number, Outlet Number and Permit revision?

When I do this there are 1,155 records (just active) or 2,278 records (all) where EA_REGION does not match - not including ones where Determinands do not match (c.23K and c.78k respectively), even though the Grid reference is the same. In other cases SV0000.... or TA000....  is used but guess that is another issue:

Should I ignore the EA_REGION columns from the joining tables (Effluent and Determinands)?

Hopefully someone can help

Cheers

John

GISData //

Official comment

Avatar

Hi John,

Many thanks, the technical owner of the dataset has provided the following information:

Table Consents_active or Consents_all is linked to table effluents by EA_Region, Permit_number/Permit_ref, Permit_Version/Version, Outlet_number and Effluent_number.

Table effluents is then linked to table determinands by EA_Region, Permit_ref, Version, Outlet_number and Effluent_Number.

I hope this helps?

Ella Fotheringham

Environment Agency

Ella Fotheringham //
Comment actions Permalink

Please sign in to leave a comment.

1 comment