762_11 Urban catchment nitrogen and phosphorous calculator

Document Sample
762_11 Urban catchment nitrogen and phosphorous calculator Powered By Docstoc
					Urban catchment nitrogen and phosphorus loadings to gro
762_11/GEHO0811BTVW-E-X, Version 1

Catchment name:                 Exeter


Version tracking   Please re-save the file with a new issue number so as not to overwrite previous versions
Calculation        Date        Created     Description of changes made
Version No         Created     By
i1                 7/24/2010 Entec         New workbook
i2                 10/5/2010 Entec         Minor changes including adding different landfill types and cemeteries
i3
i4
i5


Purpose:           This workbook carries out model calculations to estimate loads of nitrate (as N) and phosphorus
                   in an urban catchment.
                   The user is required to enter catchment data such as land use, population etc. The workbook co
                   inputs of N and P from various activities (e.g. leakage from sewers), to estimate annual total loa

                   Workbook structure and methods developed by Entec UK Ltd, June 2010.



Instructions:      Basic use:
                   Master worksheet should be copied and saved as a new spreadsheet. Enter catchment data in
                   Suggested data sources are described in the Entec report "Nitrate and Phosphate Loading to G
                   Model output is shown in the Summary and piechart sheet.

                   Advanced use:
                   The data entry sheet contains some default values (light blue cells), these values can be overtyp

                   More detailed instructions are given in the Entec report "Nitrate and Phosphate Loading to Gro



Worksheet          Name                                Function
functions:
                   Data entry                          Data entry for urban catchment and sources
                   Calculation_N                       Calculation of total urban N loading
                   Calculation_P                       Calculation of total urban P loading
                   Summary and pie chart_N             Summary of loading calculation for P and source apportionm
                   Summary and pie chart_P             Summary of loading calculation for P and source apportionm
oadings to groundwater



erwrite previous versions



dfill types and cemeteries




rate (as N) and phosphorus (as P) reaching groundwater

lation etc. The workbook contains models which estimate
 to estimate annual total loads of N and P to groundwater.

2010.




 t. Enter catchment data in worksheet "Data Entry".
nd Phosphate Loading to Groundwater"



hese values can be overtyped by the user.

 Phosphate Loading to Groundwater".




nd sources
ng
ng
or P and source apportionment chart
or P and source apportionment chart
Urban nitrogen loading                                                                                                                                                                 Key
                                                                                                                                                                                                            Data entry
                                                                                                                                                                                                            Data carried forward
Catchment                                                                     Exeter                                                                                                                        Default value, can be overwritten
                                                                                                                                                                                                            No direct N Loss (assumes any loss associated with drainage to soakaways, leaking water mains or leaking sewers)
                                                                                                                                                                                                            Calculated
Data entry on land use areas
Land use                                                                                   Km2                          Comment                       Ha                             %area                         Infiltration mm/year                                       Notes
Total urban area                                                                           44.72                                                     4472
Area residential (houses, gardens) (no direct N loss)                                       2.66            Vision of Britain Website                 266                               5.95
Area commercial/industry (no direct N loss)                                                 1.83            Vision of Britain Website                 183                               4.09
Area roads (no direct N loss)                                                               4.22            Greenspace                                422                               9.44
Area parks                                                                                 25.30            Vision of Britain Website                2530                              56.57                               235                  estimate from   rainfall and PE
Area gardens                                                                                8.35            Average allotment size                    835                              18.67                               235                  estimate from   rainfall and PE
Area allotments                                                                             0.33            From OS map                              32.5                               0.73                               235                  estimate from   rainfall and PE
Area recreational grassland and golf courses                                                1.00            CORINE                                    100                               2.24                               235                  estimate from   rainfall and PE
Area of land giving rise to contamination                                                   0.00            EAgency                                     0                               0.00                               235                  estimate from   rainfall and PE
Area landfill (non-hazardous)                                                               0.03            EAgency                                     3                               0.07                               235                  estimate from   rainfall and PE
Area landfill (inert)                                                                       0.00                                                        0                               0.00                               235                  estimate from   rainfall and PE
Area of construction activities                                                             0.80            CORINE                                     80                               1.79                               235                  estimate from   rainfall and PE
Area cemeteries                                                                             0.20            OS map                                     20                               0.45                               235                  estimate from   rainfall and PE
Area draining to SuDs and other drainage areas (see note 1)                                 1.21            Estimate                                  121                               2.71                               500                  use rainfall
                                                                                                                                                                             %rainfall draining to ground                   50                  estimate
Check (total - sub areas) (excludes area draining to SuDS) (km2)                            0.00
Note 1 - area of hardstanding (roads, car parks, roofs etc) that drain to drainage areas (e.g. SuDS), suggest use of area of commercial/industry and roads
No N loss is assumed for residential areas, commercial areas and roads. Any loss is assumed to be indirect as drainage to permeable areas

Options
Option - Loading from leaking sewers ( 2 alternative options) (select from drop down box)
          1. Calculate loading based on average sewer leakage rate             (drop down box)
Option - Loading from leaking water mains ( 2 alternative options) (select from drop down box)
           2. Calculate loading based estimated leakage rate (Ml/d)            (drop down box)
Option - Loading from septic tanks ( 2 alternative options) (select from drop down box)
         1. Calculate loading based on effluent concentration (mg/l)           (drop down box)


Data entry for population, water use, mains water leakage and sewer leakage
Input                                                                                    Value                             Unit                       Notes
Total population                                                                        111076                            person          2001 census
Population density                                                                       2484                          person/km2         Office of national stats 3142 (in 2007)
Number of burials per year                                                                350                             person          Estimate
Number of green burials per year                                                           0                              person
Population served by septic tanks                                                          0                              person
Water use (population served by septic tanks )                                            150                           l/person/d
Leaking sewers: Option 1 - Selected
Average sewer leakage rate below urban area                                                 10                         mm/year/m2
Leaking sewers: Option 2 - Not selected
Sewer flow                                                                                 230                          l/person/d        national stats (water wise UK - average water use per person per day)
Sewer leakage                                                                                2                              %             Lerner 2000
Average sewer leakage rate below urban area                                                4.17                        mm/year/m2
Mains water leakage: Option 1 - Not selected
Water use                                                                                  220                          l/person/d        national stats (water wise UK - average water use per person per day)
Leakage rate                                                                                25                              %
Water mains leakage                                                                        6.11                            Ml/d
Average water mains leakage rate below urban area                                           50                         mm/year/m2
Mains water leakage: Option 2 - Selected
Water mains leakage                                                                         5.6                           Ml/d            likely to be about 17% of supply
Average water mains leakage rate below urban area                                          45.71                       mm/year/m2

Data entry for N applications and losses

Loading from application of fertilisers (note suggested values are given in datasources)
                                                                                                                                               Nitrogen loading                                                  % Nitrogen lost due to
Land use or activity                                                           Percentage area fertilised        Fertiliser application        unfertilised area      % Nitrogen leached from soil                     attenuation                                            Notes
                                                                                          %                            Kg/N/ha/yr                  Kg/N/ha/yr                      %                                        %
                                                                                                                                          From atmospheric deposition
Parks                                                                                       25                             200                         10                          10                                       0                   Lerner 2000
Gardens                                                                                     25                             200                         10                          10                                       0                   Lerner 2000
Allotments                                                                                  50                             200                         10                          25                                       0                   Lerner 2000
Recreational grassland and golf courses                                                     50                             200                         10                          10                                       0                   Lerner 2000

Nitrogen concentration in drainage (note literature sources given values as either mg N/l or Kg N/ha/yr
                                                                                                                                            % Nitrogen lost due to
Land use or activity                                                                N concentration               Nitrogen leached                attenuation                        Notes
                                                                                        mg N/l                        Kg/N/ha/yr                       %
N loss construction activities                                                                                           60                             0               Wakida 2006
Landfill leachate (non hazardous)                                                          707                                                         80               Table 4.7, Main report
Landfill leachate (inert)                                                                   27                                                         80               Table 4.7, Main report
N concentration in sewage                                                                   45                                                          0               Bishop 1998
N concentration in mains water                                                               4                                                          0               8.4 to 14.92 NO3 raw water from river exe at Pynes Hill WTW
N concentration in surface water run-off                                                   3.5                                                          0               Table 10.2, main report
N loss from land giving rise to contamination                                               80                                                          0               Assumed
                                                                                                                  Kg/N/person/year
N loss from cemeteries                                                                                                  1.35                            0               EAgency 2007
N loss from septic tanks                                                                    50                           2.7                           50               Table 6.7 Main report

Data entry for P applications and losses

Loading from leaching of Soil P (based on Sniffer 2008)
Land use or activity                                                                Olsen P Index                      Coefficient a             Coefficient b            % P lost due to attenuation                    Notes
                                                                                       mg/Kg                                                                                          %

Parks                                                                                       25                              70                        0.31                              0                   Based on Sniffer 2006
Gardens                                                                                     25                              70                        0.31                              0                   Based on Sniffer 2006
Allotments                                                                                  25                              70                        0.31                              0                   Based on Sniffer 2006
Recreational grassland and golf courses                                                     25                              70                        0.31                              0                   Based on Sniffer 2006


Phosphorus concentration in drainage (note literature sources given values as either mg P/l or Kg P/ha/yr

Land use or activity                                                                P concentration              Phosphorus leached       % P lost due to attenuation                Notes
                                                                                        mg P/l                       Kg P/ha/yr                       %
P loss construction activities                                                                                           0                             0
Landfill leachate                                                                           0.8                                                       80                Robinson 1995
Landfill leachate (inert)                                                                    4                                                        80                Westlake 1981
P concentration in sewage                                                                    9                                                         0                Bishop, 1998
P concentration in mains water                                                               1                                                         0                Assumes dosing of mains water
P concentration in surface water run-off                                                   0.01                                                        0                Table 10.3, main report
P loss from land giving rise to contamination                                               0.5                                                        0                Assumed
                                                                                                                  Kg P/person/year
P loss from cemeteries                                                                                                  0.5                             0               Table 3.5, main report
P loss from septic tanks                                                                    15                          0.8                            50               Table 6.7, main report




Supporting calcs
1. Calculate loading based on average sewer leakage rate
2. Calculate loading based on population density
1

1. Calculate loading based on population, water use and leakage rate
2. Calculate loading based estimated leakage rate (Ml/d)
0

1. Calculate loading based on effluent concentration (mg/l)
2. Calculate loading based effluent loading (Kg /person)
1




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xls Data entry
Calculation of nitrogen loading
                                                                                                                         Nitrogen
                                                                                                        % Nitrogen        loading      % Nitrogen          % Nitrogen                                                                                                    Average loading
                                                                     Percentage         Fertiliser     leached from     unfertilised  leached from         lost due to                                Average loading over                            Concentration in   top groundwater
Land use or activity                                   Area         area fertilised    application          soil            area             soil          attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha                %            Kg N/ha/yr            %           Kg N/ha/yr           %                 %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from application of fertilisers                                                                          From atmospheric deposition
Parks                                                  2530               25               200               10              10               10                0                  6.00                       3.39            15180.0       24.49            2.6               3.39            5945500

Gardens                                                835                25               200                10                10               10             0                  6.00                       1.12            5010.0        8.08             2.6               1.12            1962250

Allotments                                             32.5               50               200                25                10               25             0                  27.50                      0.20             893.8        1.44            11.7               0.20             76375

Recreational grassland and golf courses                100                50               200                10                10               10             0                  11.00                      0.25            1100.0        1.77             4.7               0.25            235000

                                                                                                                                                           % Nitrogen                                                                                                    Average loading
                                                                                        Nitrogen                                                           lost due to                                Average loading over                            Concentration in   top groundwater
Land use or activity                                   Area                              leached                                                           attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha                              Kg/N/ha/yr                                                              %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from construction activities                    80                                  60                                                                   0                60.00                       1.07             4800.0        7.75          25.5                 1.07           188000

Liquid effluent spreading                          Not included

                                                                     Number of                                               Nitrogen        % Nitrogen    % Nitrogen                                                                                                    Average loading
                                                                     burials per        Nitrogen                           loading from     leached from   lost due to                                Average loading over                            Concentration in   top groundwater
Land use or activity                                   Area             year             leached                            grass areas          soil      attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area    Total recharge
                                                        ha                            Kg/N/person/yr                         Kg N/ha/yr           %             %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr          m3/year
Cemeteries                                              20               350               1.35                                  10               10             0                 32.4                       0.14             648.4         1.05          13.8                 0.14             47000
Cemeteries (green burials)                              20                0                1.35                                                                                     0                         0.00               0           0.00           0.0                 0.00        included above

                                                                                                                                N                          % Nitrogen                                                                                                    Average loading
                                                                                        Nitrogen        % Nitrogen        concentration                    lost due to                                Average loading over                            Concentration in   top groundwater
Land use or activity                                   Area           Infiltration       loading         leached           in leachate                     attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha             mm/year          Kg/N/ha/yr           %                mg N/l                            %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from land giving rise to contamination           0                 235                                                  80                               0                 0.00                       0.00              0.0          0.00          80.0                 0.00               0

                                                                                                                                N                          % Nitrogen                                                                                                    Average loading
                                                                                                                          concentration                    lost due to                                Average loading over                            Concentration in   top groundwater
                                                       Area           Infiltration                                         in leachate                     attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha             mm/year                                                mg N/l                            %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading          mg/l            Kg N/ha/yr         m3/year
Loading from landfill (non hazardous sites)              3                 235                                                  707                             80               1661.45                      1.11             4984.4        8.04          707.0                0.22             7050
Loading from landfill (inert sites)                      0                 235                                                   27                             80                 0.00                       0.00               0.0         0.00           0.0                 0.00               0

                                                                                                                                N                          % Nitrogen                                                                                                    Average loading
                                                                                                                          concentration                    lost due to                                Average loading over                            Concentration in   top groundwater
                                                       Area           Leakage                                               in sewage                      attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha            mm/year                                                  mg N/l                           %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from leaking sewers                            4472              10                                                     45                               0                 4.50                       4.50            20124.0       32.47          45.0                 4.50           447200
option selected
                                                                                                                                N                          % Nitrogen                                                                                                    Average loading
                                                                                                                          concentration                    lost due to                                Average loading over                            Concentration in   top groundwater
                                                       Area          Population       Sewage flow      Sewer leakage        in sewage                      attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha           person/km2        l/person/d            %                 mg N/l                           %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from leaking sewers                            4472             2484               230               2                  45                               0                 1.88                       1.88             8392.3       13.54          45.0                 1.88               0
option not selected
                                                                    Population                                N                                            % Nitrogen                                                                                                    Average loading
                                                                     served by                         concentration      N loading per                    lost due to                                Average loading over                            Concentration in   top groundwater
                                                                    septic tanks        Water use       in infiltration       person                       attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                                                        l/person/d           mg/l         Kg N/person/yr                        %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from septic tanks                                                  0                150                50               2.7                             50            not calculated                  0.00              0.00         0.00           50                  0.00               0


                                                                                                                                N                          % Nitrogen                                                                                                    Average loading
                                                                                                                           concentration                   lost due to                                Average loading over                            Concentration in   top groundwater
                                                       Area        Mains leakage Mains leakage                            in water supply                  attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha              ML/d        mm/year/m2                                mg N/l                            %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from leaking water mains                       4472             5.60            46                                       4                               0                 1.83                       1.83             8176.0       13.19            4                  1.83           2044000
                                                  Calculation adjusted to match estimated leakage
                                                                                                                                N
                                                                                        %rainfall                         concentration                    % Nitrogen                                                                                                    Average loading
                                                  Area draining                          entering                           soakaway                       lost due to                                Average loading over                            Concentration in   top groundwater
                                                  to soakaways        Rainfall          soakaway                             drainage                      attenuation   Loading (area of activity)        urban area         Loading      % total       drainage         over urban area   Total recharge
                                                        ha            mm/year               %                                 mg N/l                            %              Kg N/ha/yr                  Kg N/ha/yr         Kg N/yr      loading         mg/l             Kg N/ha/yr         m3/year
Loading from drainage to soakaways                     121             500                  50                                  3.5                              0            not calculated                  0.24             1058.8        1.71           3.5                 0.24           302500


Assumed grave density                                         1976 graves/ha
                                                                                                                                                                                                          Total loading (base soil zone)   61975.3   Kg N/yr
                                                                                                                                                                                                         Total loading (to groundwater)    46256.1   Kg N/yr
                                                                                                                                                                                                                 Total average recharge     251.7    mm/year
                                                                                                                                                                                                       Average loading (base soil zone)     13.86    Kg N/ha/year
                                                                                                                                                                                                      Average concentration (drainage)      5.51     mg N/l
                                                                                                                                                                                                  Average concentration (at water table)    4.11     mg N/l




                                              1




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsCalculations_N
Calculation of phosphorus loading
                                                                                                                                        Percentage P                                                                                                  Average loading to
                                                                                                                                         lost due to                            Average loading over                               Concentration in   groundwater over
Land use or activity                                    Area       Olsen P Index    Coefficient a     Coefficient b                      attenuation Loading (area of activity)      urban area            Loading      % total       drainage            urban area       Total recharge
                                                         ha            mg/Kg                                                                   %           Kg P/ha/yr                Kg P/ha/yr            Kg P/yr      loading         mg/l              Kg P/ha/yr          m3/year
Loading from gardens, parks etc
Parks                                                   2530             25              70                0.31                               0                  0.085                   0.048             214.66        3.28           0.036               0.048            5945500

Gardens                                                 835              25              70                0.31                               0                  0.085                   0.016              70.84        1.08           0.036               0.016            1962250

Allotments                                               33              25              70                0.31                               0                  0.085                   0.001               2.76        0.04           0.036               0.001              76375

Recreational grassland and golf courses                 100              25              70                0.31                               0                  0.085                   0.002               8.48        0.13           0.036               0.002             235000

                                                                                                                                                                                                                                                      Average loading to
                                                                                    Phosphorus                                          % P lost due                              Average loading over                             Concentration in   groundwater over
Land use or activity                                    Area                          leached                                           to attenuation Loading (area of activity)      urban area          Loading      % total       drainage            urban area       Total recharge
                                                         ha                          Kg P/ha/yr                                                %             Kg P/ha/yr                Kg P/ha/yr          Kg P/yr      loading          mg/l             Kg P/ha/yr          m3/year
Loading from construction activities                     80                              0                                                     0                0.000                     0.000              0.00         0.00          0.000                0.000            188000

Liquid effluent spreading                           Not included

                                                                    Number of                                                                                                                                                                         Average loading to
                                                                    burials per      Phosphorus                                         % P lost due                              Average loading over                             Concentration in   groundwater over
Land use or activity                                    Area           year            leached                                          to attenuation Loading (area of activity)      urban area          Loading      % total       drainage            urban area       Total recharge
                                                         ha                         Kg P/person/yr                                             %             Kg P/ha/yr                Kg P/ha/yr          Kg P/yr      loading          mg/l             Kg P/ha/yr           m3/year
Cemeteries                                               20             350               0.5                                                  0                8.750                     0.039             175.00        2.67          3.723                0.039             47000
Cemeteries (green burials)                               20              0                0.5                                                  0                0.000                     0.000              0.00         0.00          0.000                0.000         include above

                                                                                                                              P                                                                                                                       Average loading to
                                                                                                                        concentration   % P lost due                              Average loading over                             Concentration in   groundwater over
Land use or activity                                    Area         Infiltration                                        in leachate    to attenuation Loading (area of activity)      urban area          Loading      % total       drainage            urban area       Total recharge
                                                         ha           mm/year                                               mg P/l             %             Kg P/ha/yr                Kg P/ha/yr          Kg P/yr      loading         mg/l              Kg P/ha/yr          m3/year
Loading from land giving rise to contamination            0               235                                                 0.5              0                0.000                     0.000              0.00         0.00         80.000                0.000                0

                                                                                                                              P         Percentage P                                                                                                  Average loading to
                                                                                                                        concentration    lost due to                            Average loading over                               Concentration in   groundwater over
                                                        Area         Infiltration                                        in leachate     attenuation Loading (area of activity)      urban area            Loading      % total       drainage            urban area       Total recharge
                                                         ha           mm/year                                               mg P/l             %           Kg P/ha/yr                Kg P/ha/yr            Kg P/yr      loading          mg/l             Kg P/ha/yr          m3/year
Loading from landfill (non hazardous sites)               3               235                                                 0.8             80              1.880                     0.001                5.64         0.09          0.800                0.000              7050
Loading from landfill (inert sites)                       0               235                                                  4              80              0.000                     0.000                0.00         0.00          0.000                0.000                0

                                                                                                                              P                                                                                                                       Average loading to
                                                                                                                        concentration   % P lost due                              Average loading over                             Concentration in   groundwater over
                                                        Area          Leakage                                             in sewage     to attenuation Loading (area of activity)      urban area          Loading      % total       drainage            urban area       Total recharge
                                                         ha           mm/year                                                mg P/l            %             Kg P/ha/yr                Kg P/ha/yr          Kg P/yr      loading          mg/l             Kg P/ha/yr          m3/year
Loading from leaking sewers                             4472             10                                                    9               0                0.900                     0.900            4024.80       61.45          9.000                0.900            447200
option selected
                                                                                                                              P                                                                                                                       Average loading to
                                                                                                                        concentration   % P lost due                              Average loading over                             Concentration in   groundwater over
                                                        Area        Population      Sewage flow      Sewer leakage        in sewage     to attenuation Loading (area of activity)      urban area          Loading      % total       drainage            urban area       Total recharge
                                                         ha         person/km2       l/person/d            %                 mg P/l            %             Kg P/ha/yr                Kg P/ha/yr          Kg P/yr      loading          mg/l             Kg P/ha/yr          m3/year
Loading from leaking sewers                             4472           2484              230               2                   9               0                0.375                     0.375            1678.47       25.63          9.000                0.375                0
option not selected
                                                                    Population                               P                                                                                                                                        Average loading to
                                                                     served by                       concentration      P loading per  % P lost due                              Average loading over                              Concentration in   groundwater over
                                                                    septic tanks      Water use       in infiltration       person     to attenuation Loading (area of activity)      urban area           Loading      % total       drainage            urban area       Total recharge
                                                                                      l/person/d           mg/l         Kg P/person/yr        %             Kg P/ha/yr                Kg P/ha/yr           Kg P/yr      loading         mg/l              Kg P/ha/yr          m3/year
Loading from septic tanks                                                 0               150                15               0.8             50           not calculated                0.000               0.00         0.00           50                  0.000                0


                                                                                                                               P                                                                                                                      Average loading to
                                                                                                                         concentration % P lost due                               Average loading over                             Concentration in   groundwater over
                                                        Area        Mains leakage Mains leakage                         in water supply to attenuation Loading (area of activity)      urban area          Loading      % total       drainage            urban area       Total recharge
                                                         ha              ML/d        mm/year/m2                              mg P/l            %             Kg P/ha/yr                Kg P/ha/yr          Kg P/yr      loading          mg/l             Kg P/ha/yr          m3/year
Loading from leaking water mains                        4472             5.60            46                                    1               0                0.457                     0.457            2044.00       31.21          1.000                0.457            2044000
                                                   Calculation adjusted to match estimated leakage
                                                                                                                              P
                                                                                      %rainfall                         concentration                                                                                                                 Average loading to
                                                   Area draining                       entering                           soakaway      % P lost due                              Average loading over                             Concentration in   groundwater over
                                                   to soakaways       Rainfall        soakaway                             drainage     to attenuation Loading (area of activity)      urban area          Loading      % total       drainage            urban area       Total recharge
                                                         ha           mm/year             %                                 mg P/l             %             Kg P/ha/yr                Kg P/ha/yr          Kg P/yr      loading          mg/l             Kg P/ha/yr          m3/year
Loading from drainage to soakaways                      121            500                50                                 0.01              0            not calculated                0.001             3.025         0.05          0.010                0.001            302500



                                                                                                                                                                                       Total loading (base soil zone)   6549.2    Kg P/yr
                                                                                                                                                                                      Total loading (to groundwater)    4198.4    Kg P/yr
                                                                                                                                                                                              Total average recharge     251.7    mm/year
                                                                                                                                                                                    Average loading (base soil zone)     1.46     Kg P/ha/year
                                                                                                                                                                                   Average concentration (drainage)      0.58     mg P/l
                                                                                                                                                                               Average concentration (at water table)    0.37     mg P/l




                                               1




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsCalculations_P
       Summary calculations: Nitrogen loading to groundwater

       Catchment                                     Exeter


                                                                        Average loading
                                                                        over urban area              Concentration
                                                     Loading (base      (base soil zone)             at water table
       Nitrogen loading                               soil zone) %          Kg N/ha                      mg N/l
       Loading from application of fertilisers
       Parks and gardens                                 32.58                    4.51                          2.55
       Allotments                                         1.44                    0.20                         11.70
       Recreational grassland and golf courses            1.77                    0.25                          4.68
       Loading from cemeteries                            1.05                    0.14                         13.80
       Loading from construction activities               7.75                    1.07                         25.53
       Loading from land affected by contamination        0.00                    0.00                         80.00
       Loading from landfill (non hazardous sites)        8.04                    1.11                         707.00
       Loading from landfill (inert sites)                0.00                    0.00                          0.00
       Loading from leaking sewers                       32.47                    4.50                         45.00
       Loading from septic tanks                          0.00                    0.00                         50.00
       Loading from leaking water mains                  13.19                    1.83                          4.00
       Loading from drainage to soakaways                 1.71                    0.24                          3.50
       Total                                             100.00

       Total loading (base soil zone)                     61975        Kg N/yr
       Total loading (to groundwater)                     46256        Kg N/yr
       Catchment area                                      44.7        ha
       Total average recharge                              252         mm/year
       Average loading (base soil zone)                    13.9        Kg N/ha/year
       Average concentration (drainage)                    5.5         mg N/l
       Average concentration (at water table)              4.1         mg N/l


       % Nitrogen Loading (base soil zone)

                                                                  Parks and gardens 32.5 %


                                                                  Allotments 1.4 %


                                                                  Recreational grassland and golf courses 1.7 %


                                                                  Loading from cemeteries 1 %


                                                                  Loading from construction activities 7.7 %


                                                                  Loading from land affected by contamination <0.1 %


                                                                  Loading from landfill (non hazardous sites) 8 %


                                                                  Loading from landfill (inert sites) <0.1 %


                                                                  Loading from leaking sewers 32.4 %


                                                                  Loading from septic tanks <0.1 %


                                                                  Loading from leaking water mains 13.1 %


                                                                  Loading from drainage to soakaways 1.7 %




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_N
       % Nitrogen Loading (at water table)


                                                                  Parks and gardens 34.8 %


                                                                  Allotments 1.5 %


                                                                  Recreational grassland and golf courses 1.8 %


                                                                  Loading from cemeteries 1.1 %


                                                                  Loading from construction activities 8.2 %


                                                                  Loading from land affected by contamination <0.1 %


                                                                  Loading from landfill (non hazardous sites) 1.7 %


                                                                  Loading from landfill (inert sites) <0.1 %


                                                                  Loading from leaking sewers 34.7 %


                                                                  Loading from septic tanks <0.1 %


                                                                  Loading from leaking water mains 14 %


                                                                  Loading from drainage to soakaways 1.8 %




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_N
                                                    Parks and gardens 32.5 %
                                                    Allotments 1.4 %
                                                    Recreational grassland and golf courses 1.7 %
                                                    Loading from cemeteries 1 %
                                                    Loading from construction activities 7.7 %
                                                    Loading from land affected by contamination <0.1 %
                                                    Loading from landfill (non hazardous sites) 8 %
                                                    Loading from landfill (inert sites) <0.1 %
                                                    Loading from leaking sewers 32.4 %
                                                    Loading from septic tanks <0.1 %
                                                    Loading from leaking water mains 13.1 %
                                                    Loading from drainage to soakaways 1.7 %




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_N
D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_N
                                            13.54

                                     32.5           Parks and gardens 34.8 %                         4.51      34.8
                                      1.4           Allotments 1.5 %                                 0.20       1.5
                                      1.7           Recreational grassland and golf courses 1.8 % 0.25          1.9
                                        1           Loading from cemeteries 1.1 %                    0.14       1.1
                                      7.7           Loading from construction activities 8.2 %       1.07       8.3
by contamination <0.1 %       <0.1                                                                   0.00
                                                    Loading from land affected by contamination <0.1 %          0.0
                                       8            Loading from landfill (non hazardous sites) 1.7 %0.22       1.7
                              <0.1                  Loading from landfill (inert sites) <0.1 %       0.00       0.0
                                     32.4           Loading from leaking sewers 34.7 %               4.50      34.7
                              <0.1                  Loading from septic tanks <0.1 %                 0.00       0.0
                                     13.1           Loading from leaking water mains 14 %            1.83      14.1
                                      1.7           Loading from drainage to soakaways 1.8 %         0.24       1.8
                                                                                                       12.97




             D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_N
D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_N
              34.8
               1.5
               1.8
               1.1
               8.2
       <0.1
               1.7
       <0.1
              34.7
       <0.1
               14
               1.8




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_N
       Summary calculations: Phosphorus loading to groundwater

       Catchment                                     Exeter


                                                                          Average loading
                                                                          over urban area              Concentration
                                                                          (base soil zone)             at water table
       Phosphorus loading                              Loading %              Kg P/ha                      mg P/l
       Loading from application of fertilisers
       Parks and gardens                                  4.36                      0.06                       0.04
       Allotments                                         0.04                      0.00                       0.04
       Recreational grassland and golf courses            0.13                      0.00                       0.04
       Loading from cemeteries                            2.67                      0.04                       3.72
       Loading from construction activities               0.00                      0.00                       0.00
       Loading from land affected by contamination        0.00                      0.00                       80.00
       Loading from landfill (non hazardous sites)        0.09                      0.00                       0.80
       Loading from landfill (inert sites)                0.00                      0.00                       0.00
       Loading from leaking sewers                       61.45                      0.90                       9.00
       Loading from septic tanks                          0.00                      0.00                       50.00
       Loading from leaking water mains                  31.21                      0.46                       1.00
       Loading from drainage to soakaways                 0.05                      0.00                       0.01
       Total                                             100.00

       Total loading (base soil zone)                    6549.21         Kg P/yr
       Total loading (to groundwater)                    4198.37         Kg P/yr
       Catchment area                                     44.72          ha
       Total average recharge                            251.67          mm/year
       Average loading (base soil zone)                   1.46           Kg P/ha/year
       Average concentration (drainage)                   0.58           mg P/l
       Average concentration (at water table)             0.37           mg P/l


            % Phosphorus Loading
               (base soil zone)
                                                                  Parks and gardens 4.3 %


                                                                  Allotments <0.1 %


                                                                  Recreational grassland and golf courses 0.1 %


                                                                  Loading from cemeteries 2.6 %


                                                                  Loading from construction activities <0.1 %


                                                                  Loading from land affected by contamination <0.1 %


                                                                  Loading from landfill (non hazardous sites) <0.1 %


                                                                  Loading from landfill (inert sites) <0.1 %


                                                                  Loading from leaking sewers 61.4 %


                                                                  Loading from septic tanks <0.1 %


                                                                  Loading from leaking water mains 31.2 %


                                                                  Loading from drainage to soakaways <0.1 %




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_P
            % Phosphorus Loading
                (water table)

                                                                 Parks and gardens 4.3 %


                                                                 Allotments <0.1 %


                                                                 Recreational grassland and golf courses 0.1 %


                                                                 Loading from cemeteries 2.6 %


                                                                 Loading from construction activities <0.1 %


                                                                 Loading from land affected by contamination <0.1 %


                                                                 Loading from landfill (non hazardous sites) <0.1 %


                                                                 Loading from landfill (inert sites) <0.1 %


                                                                 Loading from leaking sewers 61.4 %


                                                                 Loading from septic tanks <0.1 %


                                                                 Loading from leaking water mains 31.2 %


                                                                 Loading from drainage to soakaways <0.1 %




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_P
                                                    Parks and gardens 4.3 %
                                                    Allotments <0.1 %
                                                    Recreational grassland and golf courses 0.1 %
                                                    Loading from cemeteries 2.6 %
                                                    Loading from construction activities <0.1 %
                                                    Loading from land affected by contamination <0.1 %
                                                    Loading from landfill (non hazardous sites) <0.1 %
                                                    Loading from landfill (inert sites) <0.1 %
                                                    Loading from leaking sewers 61.4 %
                                                    Loading from septic tanks <0.1 %
                                                    Loading from leaking water mains 31.2 %
                                                    Loading from drainage to soakaways <0.1 %




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_P
D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_P
                                            13.54

                                      4.3           Parks and gardens 4.3 %                          0.06        4.4
                              <0.1                  Allotments <0.1 %                                0.00        0.0
                                      0.1           Recreational grassland and golf courses 0.1 % 0.00           0.1
                                      2.6           Loading from cemeteries 2.6 %                    0.04        2.7
                              <0.1                  Loading from construction activities <0.1 %      0.00        0.0
by contamination <0.1 %       <0.1                                                                    %
                                                    Loading from land affected by contamination <0.10.00         0.0
azardous sites) <0.1 %        <0.1                                                                   0.00
                                                    Loading from landfill (non hazardous sites) <0.1 %           0.0
                              <0.1                  Loading from landfill (inert sites) <0.1 %       0.00        0.0
                                     61.4           Loading from leaking sewers 61.4 %               0.90       61.5
                              <0.1                  Loading from septic tanks <0.1 %                 0.00        0.0
                                     31.2           Loading from leaking water mains 31.2 %          0.46       31.2
                              <0.1                  Loading from drainage to soakaways <0.1 %        0.00        0.0
                                                                                                         1.46




             D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_P
D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_P
               4.3
       <0.1
               0.1
               2.6
       <0.1
       <0.1
       <0.1
       <0.1
              61.4
       <0.1
              31.2
       <0.1




D:\Docstoc\Working\pdf\131c7cf7-0013-41fd-88c1-3957833ea95c.xlsSummary and piechart_P

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:11/5/2012
language:English
pages:19