20231027 03223500 1.0 FALSE FWMT_NPSFMBaselineInstreamAttributeStates_Gradings_Generalised1 002 Projected GCS_NZGD_2000 Linear Unit: Meter (1.000000) NZGD_2000_New_Zealand_Transverse_Mercator <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.6.0'><WKT>PROJCS["NZGD_2000_New_Zealand_Transverse_Mercator",GEOGCS["GCS_NZGD_2000",DATUM["D_NZGD_2000",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",1600000.0],PARAMETER["False_Northing",10000000.0],PARAMETER["Central_Meridian",173.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",2193]]</WKT><XOrigin>-4020900</XOrigin><YOrigin>1900</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2193</WKID><LatestWKID>2193</LatestWKID></ProjectedCoordinateSystem> 150000000 5000 ItemDescription 20231006 11531600 20231006 11531600 Freshwater Management Tool (FWMT) Stage 1 Baseline v1.2 instream contaminant grading layer (numeric attribute, overall) . Purposely produced for engagement purposes in Auckland Council’s plan change programme for the National Policy Statement for Freshwater Management (NPS-FM). The layer is supported by external technical reports and external peer review available for prior versioning (v1.0) on Knowledge Auckland (keyword: freshwater management tool). Further reporting specific to FWMT Baseline v1.2 development is undergoing peer review for publication. The layer is a standalone product for Council’s NPS-FM programme and not subject to ongoing versioning changes as per broader FWMT programme . The layer utilises the latest FWMT Stage 1 Baseline (v1.2) outputs as of September 2023. <DIV STYLE="text-align:Left;">FWMT Stage 1 Baseline v1.2 predicted water quality across permanent streams in the Auckland region, inclusive of discharges from all land surfaces draining to freshwater and coast. Reported for 5,465 sub-catchments spanning ~490,000 Ha of land and inclusive of 107 unique contaminant sources – specifically produced for NPS-FM engagement purposes and Auckland Council.FWMT Baseline v1.2 water quality layers produced by Auckland Council’s FWMT programme (<A href="mailto:fwmt@aucklandcouncil.govt.nz" STYLE="text-decoration:underline;">fwmt@aucklandcouncil.govt.nz</A> – Healthy Waters). FWMT developed from US-EPA process-based model package modified by Healthy Waters for application to New Zealand. Baseline v1.0 outputs have undergone external peer review and are reported on Knowledge Auckland. Baseline v1.2 reporting is in preparation for external peer review and publication. Baseline water quality assessed continuously (15-min simulation timestep, daily output, multiple-year period). Freshwater Management Tool developed to supplement observational records with continuous data about event and long-term variation in flow, contaminants and contaminant sources to receiving fresh and coastal waterways – objective function, design and application for targeted management of contaminants to water quality objective. Urban and rural resource use simulated for hydrological and contaminant responses from land to water under varying weather (e.g., variation in rainfall intensity and depth, inclusive of varying antecedent conditions). Inclusive of predicted wastewater network contaminant discharges at engineered overflow points based on six of Watercare’s strategic wastewater hydraulic models (type 1 and 2 overflow events at Waiuku township and Army Bay, Mangere, Pukekohe, Rosedale and Warkworth strategic management areas). Exclusive of wastewater treatment plant discharges. Modelled instream processes include nutrient transformation, deposition and resuspension of sediment inputs and erosion of stream channel. All hydrological and contaminant inputs from land integrated through a modelled reach network from mountains to sea, demonstrating cumulative effects of resource use on flow, contaminant concentration, contaminant load and contaminant grade.Continuous instream time-series for contaminant concentration converted to daily flow-weighted average concentration prior to assessment for numeric attribute state under national (MfE, 2023) and provisional regional objective guidance (Gadd et al., 2019). Most degraded of corresponding numeric attribute states assigned as overall attribute state to each modelled reach (e.g., A, B, C, D or E where A is least degraded and E is most degraded – note only E. coli includes an E state, all other contaminants graded from A to D). Attribute states reported for five-year baseline period (2013-2017) in line with requirements for National Policy Statement for Freshwater Management. E.coli grading non-conservative; unless attributes other than 95th% at E grade, cannot be E-grade overall. Total ammoniacal nitrogen grading utilises median and 95th% concentration.Attribute states reported by FWMT Stage 1 (Baseline v1.0-v1.2) include nutrients (total oxidised nitrogen, total ammoniacal nitrogen, dissolved reactive phosphorus), faecal indicator bacteria (E. coli) and heavy metals (dissolved copper, dissolved zinc). Note, total oxidised nitrogen reported as equivalent to nitrate-nitrogen, and total ammoniacal nitrogen as equivalent to ammoniacal-nitrogen, under National Objective Framework (MfE, 2023).For all FWMT queries email: <A href="mailto:fwmt@aucklandcouncil.govt.nz" STYLE="text-decoration:underline;">fwmt@aucklandcouncil.govt.nz</A> or contact Healthy Waters – Regional Planning (Infrastructure and Environmental Services, Auckland Council).A summary of the fields and their definitions is as follows:<TABLE STYLE="margin:0 0 0 1;"><TBODY><TR><TD STYLE="padding:0 8 0 8;">Field Name</TD><TD STYLE="padding:0 8 0 8;">Layer Name</TD><TD STYLE="padding:0 8 0 8;">Description</TD><TD STYLE="padding:0 8 0 8;">Range</TD></TR><TR><TD STYLE="padding:0 8 0 8;">TON_med</TD><TD STYLE="padding:0 8 0 8;">Nitrate Median</TD><TD STYLE="padding:0 8 0 8;">Median only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">TON_overall</TD><TD STYLE="padding:0 8 0 8;">Nitrate Overall</TD><TD STYLE="padding:0 8 0 8;">See notes on Attribute State and Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">TON_95th</TD><TD STYLE="padding:0 8 0 8;">Nitrate 95th %ile</TD><TD STYLE="padding:0 8 0 8;">95th% only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">TAM_med_95th</TD><TD STYLE="padding:0 8 0 8;">Total Ammoniacal Nitrogen Overall</TD><TD STYLE="padding:0 8 0 8;">See notes on Attribute State and Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">TAM_med</TD><TD STYLE="padding:0 8 0 8;">Total Ammoniacal Nitrogen Median</TD><TD STYLE="padding:0 8 0 8;">Median only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">TAM_95th</TD><TD STYLE="padding:0 8 0 8;">Total Ammoniacal Nitrogen 95th %ile</TD><TD STYLE="padding:0 8 0 8;">95th% only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Cu_95th</TD><TD STYLE="padding:0 8 0 8;">Dissolved Copper 95th %ile</TD><TD STYLE="padding:0 8 0 8;">95th% only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Cu_med</TD><TD STYLE="padding:0 8 0 8;">Dissolved Copper Median</TD><TD STYLE="padding:0 8 0 8;">Median only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Cu_overall</TD><TD STYLE="padding:0 8 0 8;">Dissolved Copper Overall</TD><TD STYLE="padding:0 8 0 8;">See notes on Attribute State and Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Zn_med</TD><TD STYLE="padding:0 8 0 8;">Dissolved Zinc Median</TD><TD STYLE="padding:0 8 0 8;">Median only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Zn_95th</TD><TD STYLE="padding:0 8 0 8;">Dissolved Zinc 95th %ile</TD><TD STYLE="padding:0 8 0 8;">95th% only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Zn_overall</TD><TD STYLE="padding:0 8 0 8;">Dissolved Zinc Overall</TD><TD STYLE="padding:0 8 0 8;">See notes on Attribute State and Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Ecoli_med</TD><TD STYLE="padding:0 8 0 8;">Median E. coli per 100 mL</TD><TD STYLE="padding:0 8 0 8;">Median only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A, D, E</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Ecoli_540</TD><TD STYLE="padding:0 8 0 8;">E. coli % Exceedance of Counts over 540 per 100mL</TD><TD STYLE="padding:0 8 0 8;">%>540 MPN/100ml only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - E </TD></TR><TR><TD STYLE="padding:0 8 0 8;">Ecoli_260</TD><TD STYLE="padding:0 8 0 8;">E. coli % Exceedance of Counts over 260 per 100mL</TD><TD STYLE="padding:0 8 0 8;">%>260 MPN/100ml only graded. See note on Attribute Measure</TD><TD STYLE="padding:0 8 0 8;">A - E </TD></TR><TR><TD STYLE="padding:0 8 0 8;">Ecoli_95th</TD><TD STYLE="padding:0 8 0 8;">E. coli 95th %ile per 100mL</TD><TD STYLE="padding:0 8 0 8;">95th% only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Ecoli_overall</TD><TD STYLE="padding:0 8 0 8;">E. coli Overall</TD><TD STYLE="padding:0 8 0 8;">See notes on Attribute State and Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - E </TD></TR><TR><TD STYLE="padding:0 8 0 8;">DIN_med</TD><TD STYLE="padding:0 8 0 8;">Dissolved Inorganic Nitrogen Median</TD><TD STYLE="padding:0 8 0 8;">Median only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">DIN_95th</TD><TD STYLE="padding:0 8 0 8;">Dissolved Inorganic Nitrogen 95th %ile</TD><TD STYLE="padding:0 8 0 8;">95th% only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">DIN_overall</TD><TD STYLE="padding:0 8 0 8;">Dissolved Inorganic Nitrogen Overall</TD><TD STYLE="padding:0 8 0 8;">See notes on Attribute State and Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">DRP_med</TD><TD STYLE="padding:0 8 0 8;">Dissolved Reactive Phosphorus Median</TD><TD STYLE="padding:0 8 0 8;">Median only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">DRP_95th</TD><TD STYLE="padding:0 8 0 8;">Dissolved Reactive Phosphorus 95th %ile</TD><TD STYLE="padding:0 8 0 8;">95th% only graded. See note on Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">DRP_overall</TD><TD STYLE="padding:0 8 0 8;">Dissolved Reactive Phosphorus Overall</TD><TD STYLE="padding:0 8 0 8;">See notes on Attribute State and Attribute Measure.</TD><TD STYLE="padding:0 8 0 8;">A - D</TD></TR><TR><TD STYLE="padding:0 8 0 8;">SS_Class</TD><TD STYLE="padding:0 8 0 8;">Suspended Solids Class</TD><TD STYLE="padding:0 8 0 8;">National Objective Framework suspended sediment class</TD><TD STYLE="padding:0 8 0 8;">1-3</TD></TR><TR><TD STYLE="padding:0 8 0 8;">Clarity_grade</TD><TD STYLE="padding:0 8 0 8;">Clarity grade</TD><TD STYLE="padding:0 8 0 8;">Grade as derived from the Random Forest model prediction of baseline visual clarity and visual clarity thresholds (criteria) for NOF bands.</TD><TD STYLE="padding:0 8 0 8;">A-D</TD></TR></TBODY></TABLE>Additional Notes:<TABLE STYLE="margin:0 0 0 0;"><TBODY><TR><TD STYLE="padding:1 1 1 1;">Attribute state (A, B, C, D, E)</TD><TD STYLE="padding:1 1 1 1;">Worst of several instream attribute measures for a contaminant over the baseline period (2013-2017) (e.g., worst of median or 95th% for total ammoniacal nitrogen).</TD></TR><TR><TD STYLE="padding:1 1 1 1;">Attribute measure (numeric attribute state)</TD><TD STYLE="padding:1 1 1 1;">Instream grading statistics for contaminant (e.g., median, 95th%, maximum, %>260MPN/100ml, %>540MPN/100ml) derived for baseline period (2013-2017).Contaminants have varying number of statistics used for reporting against numeric attribute state criteria. Numeric attribute states are graded from the National Objective Framework (MfE, 2023) or provisional objective guidance on metals (Gadd et al., 2019). States vary from least degraded (“A”) to most degraded water quality (“D”). E. coli has additional degraded state (“E”). Several contaminants have national bottom-line states (TON, TAM) or national target (E. coli).</TD></TR><TR><TD STYLE="padding:1 1 1 1;">SS Class and Clarity Grade Classification</TD><TD STYLE="padding:1 1 1 1;">The SS Class and Clarity Grade fields were produced by Land, Water People and attributed to the digital drainage network from the Rivers Environment Classification (v2.4), method detailed in “Assessment of Sediment Load Reductions to Achieve Target Attribute States in the Streams and Rivers of Auckland Region” (August, 2023). This data was correlated to the FWMT modelled streams using the majority SS Class and Clarity Grade per FWMT subcatchment.</TD></TR></TBODY></TABLE>ReferencesMinistry for Environment. 2023. National Policy Statement for Freshwater Management 2020. <A href="https://environment.govt.nz/assets/publications/National-Policy-Statement-for-Freshwater-Management-2020.pdf" STYLE="text-decoration:underline;">https://environment.govt.nz/assets/publications/National-Policy-Statement-for-Freshwater-Management-2020.pdf</A> Gadd, J., Williamson, R., Mills, G., Hickey, C., Cameron, M., Vigar, N., Buckthought, L., and Milne, N. 2019. Developing Auckland-specific ecosystem health attributes for copper and zinc: Summary of work to date and identification of future tasks. Prepared by the National Institute of Water and Atmospheric Research, NIWA and Diffuse Sources Ltd. for Auckland Council. Auckland Council discussion paper. DP2019/004. <A href="https://knowledgeauckland.org.nz/media/1099/dp2019-004-developing-auckland-specific-ecosystem-health-attributes-cu-zn.pdf" STYLE="text-decoration:underline;">https://knowledgeauckland.org.nz/media/1099/dp2019-004-developing-auckland-specific-ecosystem-health-attributes-cu-zn.pdf</A> Snelder, T. 2023. Assessment of Sediment Load Reductions to Achieve Target Attribute States in the Streams and Rivers of Auckland Region [Draft Report]. Prepared by Land, Water People for Auckland Council.</DIV> Auckland Council: Healthy Waters FWMT_NPS-FMBaselineInstreamAttributeStates NPSFMFreshwater Management ToolConsultation Version Esri ArcGIS 12.6.3.24783 20231006 File Geodatabase Feature Class dataset EPSG 7.9.4(9.0.0) 0 Simple FALSE 0 TRUE FALSE FWMT_NPSFMBaselineInstreamAttributeStates_Gradings_Generalised1 Feature Class 0 OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. PE_SWSID PE_SWSID Integer 4 0 0 TON_med TON_med String 254 0 0 TON_95th TON_95th String 254 0 0 TAM_max TAM_max String 254 0 0 TAM_med_max TAM_med_max String 254 0 0 TAM_med_95th TAM_med_95th String 254 0 0 TAM_med TAM_med String 254 0 0 TAM_95th TAM_95th String 254 0 0 Cu_overall Cu_overall String 254 0 0 Cu_med Cu_med String 254 0 0 Cu_95th Cu_95th String 254 0 0 Zn_overall Zn_overall String 254 0 0 Zn_med Zn_med String 254 0 0 Zn_95th Zn_95th String 254 0 0 Ecoli_med Ecoli_med String 254 0 0 Ecoli_95th Ecoli_95th String 254 0 0 Ecoli_540 Ecoli_540 String 254 0 0 Ecoli_260 Ecoli_260 String 254 0 0 DIN_med DIN_med String 254 0 0 DIN_95th DIN_95th String 254 0 0 DRP_med DRP_med String 254 0 0 DRP_95th DRP_95th String 254 0 0 TON_overall TON_overall String 512 0 0 Ecoli_overall Ecoli_overall String 512 0 0 DIN_overall DIN_overall String 512 0 0 DRP_overall DRP_overall String 512 0 0 SS_Class SS_Class String 10000 0 0 Clarity_grade Clarity_grade String 10000 0 0 Shape_Length Shape_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated.