No preview available
HomeMy WebLinkAbout2022_Data_Summary_Template_27May20212022 Data Summary Template Updated 5/27/2021 Third parties who wish to submit data for the 2022 Integrated Report process must use the data templates provided here. Columns in bold are required. Example submittals are included. Tab Descriptions Data Template - Template for ambient monitoring data reporting Header Definitions - describes the columns in Data Template FC Template - Template for fecal coliform reporting, including 5 in 30 results FC Header Definitions - describes the columns in FC Template Questions should be directed to: Cam McNutt cam.mcnutt@ncdenr.gov For 2022 Integrated Report, third party data submittals are due: 6/30/2021 AGENCY NCAMBNT NCAMBNT NCAMBNT UCFRBA NCAMBNT NCAMBNT NCAMBNT NCAMBNT MCFBA MCFBA MCFBA MCFBA LCFRP LCFRP NCAMBNT NCAMBNT LCFRP LCFRP NCAMBNT NCAMBNT NCAMBNT NCAMBNT LCFRP LCFRP NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT UCFRBA MCFBA LCFRP NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT UCFRBA NCAMBNT NCAMBNT NCAMBNT NCAMBNT LCFRP NCAMBNT NCAMBNT NCAMBNT NCAMBNT LCFRP NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT MCFBA NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT NCAMBNT HUC8 03050105 03050105 03050105 03030002 03030002 03030002 03030002 03030002 03030005 03030005 03030005 03030005 03030005 03030005 03050105 03050105 03030005 03030007 03050105 03050105 03030007 03030007 03030005 03030005 03020104 03020104 03050105 03050105 03050105 03050105 03030002 03030004 03030006 03030006 03050105 03050105 03030002 03030002 03030002 03040206 03050105 03030002 03030002 03030006 03030005 03050105 03050105 03030002 03030005 03050101 03030004 03030004 03030006 03030005 03030005 03050105 03050105 03030002 03030002 03030002 03030004 03030006 03040207 03020104 03030007 03050102 03030002 03030002 03030006 03010103 03030002 03040206 03020201 03030002 03030005 03030005 06010108 03030003 03030005 03030005 03010104 03030002 03030005 03030005 03030002 03030005 03030005 03030002 03030005 03030005 06010108 03010104 03030002 03030005 06010108 03030003 03030004 03030005 03030005 06010108 03030002 03030002 03030004 03030004 03030005 03030005 06010108 03030002 03030005 06010108 03030002 03030005 06010108 03030004 03010104 03030002 03030005 06010108 03030002 03030005 06010108 03030002 03030005 03030005 06010108 03030002 03030003 06010108 03030002 03030005 06010108 03030002 03030005 06010108 03030002 03040203 03040203 03030002 03030005 03030005 03030005 03030002 03040104 03040201 03030002 03030003 03010205 03030007 03010103 03020104 03040105 Station Number A1520000 A2700000 A4800000 B0070010 B0160000 B0210000 B1095000 B2450000 B8305000 B8340650 B8348000 B8349000 B8360000 B8441000 A1520000 A1520000 B8441000 B9580000 A1520000 A1520000 B9740000 B9740000 B9790000 B9790000 O7680000 O7710000 A1520000 A2700000 A4800000 A4400000 B0540050 B6230000 B8610001 B8725000 A4400000 A6400000 B0040000 B2450000 B3020000 I8970000 A6400000 B0040000 B2450000 B8920000 B9820000 A4400000 A6400000 B0040000 B9921000 C1370000 B6370000 B7600000 B8750000 B9020000 B9800000 A1520000 A2700000 B0160000 B0210000 B1095000 B7679300 B8490000 I9385000 O7680000 B9080000 C7000000 B0210000 B0540000 B8490000 N0150000 B0210000 I8970000 J0810000 B4050000 B9020000 B9050000 E7000000 B6040300 B9020000 B9050000 N3500000 B4050000 B9020000 B9050000 B4050000 B9020000 B9050000 B4050000 B9020000 B9050000 E7000000 N3500000 B4050000 B9050000 E7000000 B6040300 B6370000 B9020000 B9050000 E7000000 B4050000 B4050000 B6370000 B6370000 B9020000 B9020000 E7000000 B4050000 B9020000 E7000000 B4050000 B9050000 E7000000 B6370000 N3500000 B4050000 B9050000 E7000000 B4050000 B9020000 E7000000 B4050000 B9020000 B9050000 E7000000 B4050000 B6040300 E7000000 B4050000 B9050000 E7000000 B4050000 B9050000 E7000000 B4050000 I2750000 I4650000 B4050000 B9050000 B9020000 B9050000 B0210000 Q9160000 Q9940000 B2450000 B4210000 M390000S MC_WR N0150000 O7650000 Q8360000 LOCATION BROAD RIV AT SR 1181 NR ROCK SPRINGS SECOND BROAD RIV AT SR 1538 NR LOGAN FIRST BROAD RIV AT SR 1530 NR CASAR TROUBLESOME CRK AT US 29 BUS NR REIDSVILLE LITTLE TROUBLESOME CRK AT SR 2600 NR REIDSVILLE HAW RIV AT SR 1561 NR ALTAMAHAW JORDAN CRK AT SR 1754 NR UNION RIDGE ROBESON CRK AT BOAT ACCESS OFF SR 1943 NR HANKS CHAPEL CAPE FEAR RIV AT SR 1316 AT TAR HEEL CAPE FEAR RIV AT RM 55 NR BLADEN SPRINGS CAPE FEAR RIV AT SR 1730 ELWELL FERRY RD NR CARVERS CAPE FEAR RIV ABOVE LOCK AND DAM 1 NR EAST ARCADIA CAPE FEAR RIV AT NC 11 NR EAST ARCADIA LIVINGSTON CRK AT WRIGHT CORPORATION WALKWAY NR ACME BROAD RIV AT SR 1181 NR ROCK SPRINGS BROAD RIV AT SR 1181 NR ROCK SPRINGS LIVINGSTON CRK AT WRIGHT CORPORATION WALKWAY NR ACME NORTHEAST CAPE FEAR RIV AT US 117 AT CASTLE HAYNE BROAD RIV AT SR 1181 NR ROCK SPRINGS BROAD RIV AT SR 1181 NR ROCK SPRINGS NORTHEAST CAPE FEAR RIV AT NC 133 AT WILMINGTON NORTHEAST CAPE FEAR RIV AT NC 133 AT WILMINGTON BRUNSWICK RIV DNS US 17 AT PARK NR BELVILLE BRUNSWICK RIV DNS US 17 AT PARK NR BELVILLE PAMLICO RIV AT CM 16 NR WHICHARD BEACH CHOCOWINITY BAY ABOVE SILAS CRK NR WHICHARD BEACH BROAD RIV AT SR 1181 NR ROCK SPRINGS SECOND BROAD RIV AT SR 1538 NR LOGAN FIRST BROAD RIV AT SR 1530 NR CASAR SECOND BROAD RIV AT US 221 ALT AT CLIFFSIDE N BUFFALO CRK AT SR 2770 HUFFINE MILL RD NR MCLEANSVILLE AVENTS CRK AT SR 1418 NR COKESBURY LITTLE COHARIE CRK AT SR 1207 NR INGOLD SIX RUNS CRK AT SR 1960 NR TAYLORS BRIDGE SECOND BROAD RIV AT US 221 ALT AT CLIFFSIDE FIRST BROAD RIV AT SR 1140 NR EARL HAW RIV AT SR 2109 NR OAK RIDGE ROBESON CRK AT BOAT ACCESS OFF SR 1943 NR HANKS CHAPEL NEW HOPE CRK AT NC 54 NR DURHAM WACCAMAW RIV AT NC 130 AT FREELAND FIRST BROAD RIV AT SR 1140 NR EARL HAW RIV AT SR 2109 NR OAK RIDGE ROBESON CRK AT BOAT ACCESS OFF SR 1943 NR HANKS CHAPEL SOUTH RIV AT SR 1007 ENNIS BRIDGE RD NR KERR CAPE FEAR RIV AT CM 56 NR WILMINGTON SECOND BROAD RIV AT US 221 ALT AT CLIFFSIDE FIRST BROAD RIV AT SR 1140 NR EARL HAW RIV AT SR 2109 NR OAK RIDGE CAPE FEAR RIV AT CM 18 WILSON CRK AT US 221 NR GRAGG CAPE FEAR RIV AT US 401 AT LILLINGTON CAPE FEAR RIV AT NC 24 AT FAYETTEVILLE BLACK RIV AT NC 411 NR TOMAHAWK CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT CM 61 AT WILMINGTON BROAD RIV AT SR 1181 NR ROCK SPRINGS SECOND BROAD RIV AT SR 1538 NR LOGAN LITTLE TROUBLESOME CRK AT SR 2600 NR REIDSVILLE HAW RIV AT SR 1561 NR ALTAMAHAW JORDAN CRK AT SR 1754 NR UNION RIDGE ROCKFISH CRK AT US 401 BYPASS NR RAEFORD LITTLE COHARIE CRK AT SR 1414 MINNIE HALL RD NR SALEMBURG MONTGOMERY SLOUGH AT SR 1105 NR LONG BEACH PAMLICO RIV AT CM 16 NR WHICHARD BEACH NORTHEAST CAPE FEAR RIV AT SR 1937 NR MT OLIVE S FORK CATAWBA RIV AT SR 2524 NR SOUTH BELMONT HAW RIV AT SR 1561 NR ALTAMAHAW N BUFFALO CRK AT SR 2832 NR GREENSBORO LITTLE COHARIE CRK AT SR 1414 MINNIE HALL RD NR SALEMBURG DAN RIV AT NC 704 NR FRANCISCO HAW RIV AT SR 1561 NR ALTAMAHAW WACCAMAW RIV AT NC 130 AT FREELAND ENO RIV AT SR 1004 NR DURHAM HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS DEEP RIV AT SR 1011 OLD US 1 NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA DAN RIV AT NC 57 AT VA LINE AT MILTON HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS DAN RIV AT NC 57 AT VA LINE AT MILTON HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS DEEP RIV AT SR 1011 OLD US 1 NR MONCURE CAPE FEAR RIV AT US 401 AT LILLINGTON CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV AT US 401 AT LILLINGTON CAPE FEAR RIV AT US 401 AT LILLINGTON CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS CAPE FEAR RIV AT US 401 AT LILLINGTON DAN RIV AT NC 57 AT VA LINE AT MILTON HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE DEEP RIV AT SR 1011 OLD US 1 NR MONCURE N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV AT NAVASSA N TOE RIV AT US 19E NR INGALLS HAW RIV BELOW JORDAN DAM NR MONCURE LUMBER RIV AT SR 1303 NR MAXTON LUMBER RIV AT SR 2121 NR KINGSDALE HAW RIV BELOW JORDAN DAM NR MONCURE CAPE FEAR RIV AT NAVASSA CAPE FEAR RIV DNS HALE PT LANDING NR PHOENIX CAPE FEAR RIV AT NAVASSA HAW RIV AT SR 1561 NR ALTAMAHAW PEE DEE RIV AT NC 109 NR MANGUM MARKS CRK AT SR 1812 NR HAMLET ROBESON CRK AT BOAT ACCESS OFF SR 1943 NR HANKS CHAPEL W FORK DEEP RIV AT SR 1818 NR HIGH POINT ALBEMARLE SOUND NR FROG ISLAND S SHORE Murpheys Cr at Waycross Rd DAN RIV AT NC 704 NR FRANCISCO PAMLICO RIV AT US 17 AT WASHINGTON GOOSE CRK AT SR 1524 NR MINT HILL LATITUDE 35.39366 35.40424 35.49331 36.2768 36.28255 36.17864 36.18898 35.70315 34.74477 34.53518 34.474 34.40693 34.39687 34.33527 35.39366 35.39366 34.33527 34.36366 35.39366 35.39366 34.25183 34.25183 34.22045 34.22045 35.50791 35.5031 35.39366 35.40424 35.49331 35.23872 36.12998 35.48772 34.83473 34.852 35.23872 35.21776 36.21326 35.70315 35.91672 34.09518 35.21776 36.21326 35.70315 34.64022 34.14745 35.23872 35.21776 36.21326 33.91131 36.09695 35.40653 35.0499 34.7544 34.31808 34.19431 35.39366 35.40424 36.28255 36.17864 36.18898 34.99932 35.05553 33.91777 35.50791 35.1914 35.16666 36.17864 36.11994 35.05553 36.51459 36.17864 34.09518 36.07254 35.65342 34.31808 34.26118 35.981 35.61759 34.31808 34.26118 36.54079 35.65342 34.31808 34.26118 35.65342 34.31808 34.26118 35.65342 34.31808 34.26118 35.981 36.54079 35.65342 34.26118 35.981 35.61759 35.40653 34.31808 34.26118 35.981 35.65342 35.65342 35.40653 35.40653 34.31808 34.31808 35.981 35.65342 34.31808 35.981 35.65342 34.26118 35.981 35.40653 36.54079 35.65342 34.26118 35.981 35.65342 34.31808 35.981 35.65342 34.31808 34.26118 35.981 35.65342 35.61759 35.981 35.65342 34.26118 35.981 35.65342 34.26118 35.981 35.65342 34.74704 34.50397 35.65342 34.26118 34.31808 34.26118 36.17864 35.086 34.86257 35.70315 36.04658 35.96945 34.854014 36.51459 35.54321 35.1309 LONGITUDE -82.09476 -81.87201 -81.68133 -79.64993 -79.6116 -79.50415 -79.39484 -79.10027 -78.78563 -78.43975 -78.369 -78.29508 -78.26752 -78.20111 -82.09476 -82.09476 -78.20111 -77.89645 -82.09476 -82.09476 -77.95104 -77.95104 -77.97966 -77.97966 -77.02034 -77.04231 -82.09476 -81.87201 -81.68133 -81.76667 -79.6626 -78.90987 -78.37087 -78.2448 -81.76667 -81.60773 -79.9562 -79.10027 -78.97043 -78.54778 -81.60773 -79.9562 -79.10027 -78.31158 -77.95263 -81.76667 -81.60773 -79.9562 -78.01658 -81.80743 -78.8135 -78.85745 -78.2891 -78.02639 -77.95679 -82.09476 -81.87201 -79.6116 -79.50415 -79.39484 -79.21514 -78.53095 -78.16093 -77.02034 -78.01759 -81.03825 -79.50415 -79.70818 -78.53095 -80.30282 -79.50415 -78.54778 -78.8627 -79.06728 -78.02639 -77.98907 -82.01601 -79.09119 -78.02639 -77.98907 -79.21422 -79.06728 -78.02639 -77.98907 -79.06728 -78.02639 -77.98907 -79.06728 -78.02639 -77.98907 -82.01601 -79.21422 -79.06728 -77.98907 -82.01601 -79.09119 -78.8135 -78.02639 -77.98907 -82.01601 -79.06728 -79.06728 -78.8135 -78.8135 -78.02639 -78.02639 -82.01601 -79.06728 -78.02639 -82.01601 -79.06728 -77.98907 -82.01601 -78.8135 -79.21422 -79.06728 -77.98907 -82.01601 -79.06728 -78.02639 -82.01601 -79.06728 -78.02639 -77.98907 -82.01601 -79.06728 -79.09119 -82.01601 -79.06728 -77.98907 -82.01601 -79.06728 -77.98907 -82.01601 -79.06728 -79.32455 -78.94441 -79.06728 -77.98907 -78.02639 -77.98907 -79.50415 -79.99883 -79.71915 -79.10027 -80.01407 -75.97953 -78.12585 -80.30282 -77.06152 -80.63105 STREAM CLASS C WS-IV WS-V Tr WS-V NSW WS-IV NSW WS-V NSW WS-II HQW NSW WS-IV B NSW CA C WS-V WS-IV WS-IV CA WS-IV Sw C Sw C C C Sw B Sw C C SC Sw SC Sw SC SC SB NSW SC NSW C WS-IV WS-V Tr WS-IV WS-V NSW WS-IV HQW C Sw C Sw ORW + WS-IV C WS-V NSW WS-IV B NSW CA WS-IV NSW C Sw C WS-V NSW WS-IV B NSW CA C Sw ORW + SC Sw WS-IV C WS-V NSW SC B Tr ORW WS-IV C C Sw ORW + C Sw SC Sw C WS-IV WS-IV NSW WS-V NSW WS-II HQW NSW B C Sw SA HQW SB NSW C Sw WS-V B WS-V NSW WS-V NSW C Sw C Tr WS-V NSW C Sw WS-IV NSW WS-IV C Sw SC Sw WS-IV Tr WS-IV C Sw SC Sw C WS-IV C Sw SC Sw WS-IV C Sw SC Sw WS-IV C Sw SC Sw WS-IV Tr C WS-IV SC Sw WS-IV Tr WS-IV WS-IV C Sw SC Sw WS-IV Tr WS-IV WS-IV WS-IV WS-IV C Sw C Sw WS-IV Tr WS-IV C Sw WS-IV Tr WS-IV SC Sw WS-IV Tr WS-IV C WS-IV SC Sw WS-IV Tr WS-IV C Sw WS-IV Tr WS-IV C Sw SC Sw WS-IV Tr WS-IV WS-IV WS-IV Tr WS-IV SC Sw WS-IV Tr WS-IV SC Sw WS-IV Tr WS-IV B Sw HQW C Sw WS-IV SC Sw C Sw SC Sw WS-V NSW WS-V B C WS-IV B NSW CA WS-IV CA* SB C Sw C Tr SC NSW C methodcode 10 10 10 10 10 10 10 10 94 94 94 94 94 94 300 300 300 300 400 400 400 400 400 400 480 480 530 530 530 610 610 610 610 610 625 625 625 625 625 625 630 630 630 630 630 665 665 665 665 665 680 680 680 680 720 900 900 900 900 900 900 900 900 900 940 940 945 945 945 945 951 951 951 1000 1000 1000 1000 1002 1002 1002 1002 1010 1010 1010 1025 1025 1025 1027 1027 1027 1027 1027 1030 1030 1030 1034 1034 1034 1034 1034 1040 1040 1040 1040 1040 1040 1040 1042 1042 1042 1049 1049 1049 1051 1051 1065 1065 1065 1067 1067 1067 1075 1075 1075 1075 1077 1077 1077 1090 1090 1090 1092 1092 1092 1145 1145 1145 1147 1147 50092 50092 50803 50803 50803 70953 70953 82079 82079 82079 82079 82079 displayname Water Temperature (°C) Water Temperature (°C) Water Temperature (°C) Water Temperature (°C) Water Temperature (°C) Water Temperature (°C) Water Temperature (°C) Water Temperature (°C) Spec. conductance (uS/cm at 25°C) Spec. conductance (uS/cm at 25°C) Spec. conductance (uS/cm at 25°C) Spec. conductance (uS/cm at 25°C) Spec. conductance (uS/cm at 25°C) Spec. conductance (uS/cm at 25°C) D.O. (mg/L) D.O. (mg/L) D.O. (mg/L) D.O. (mg/L) pH (SU) pH (SU) pH (SU) pH (SU) pH (SU) pH (SU) Salinity (ppt) Salinity (ppt) TSS (mg/L) TSS (mg/L) TSS (mg/L) NH3 as N NH3 as N NH3 as N NH3 as N NH3 as N TKN as N TKN as N TKN as N TKN as N TKN as N TKN as N NO2 + NO3 as N NO2 + NO3 as N NO2 + NO3 as N NO2 + NO3 as N NO2 + NO3 as N Total Phosphorus Total Phosphorus Total Phosphorus Total Phosphorus Total Phosphorus Total Organic Carbon (mg/L as C) Total Organic Carbon (mg/L as C) Total Organic Carbon (mg/L as C) Total Organic Carbon (mg/L as C) Cyanide (mg/L) Hardness (mg/L) Hardness (mg/L) Hardness (mg/L) Hardness (mg/L) Hardness (mg/L) Hardness (mg/L) Hardness (mg/L) Hardness (mg/L) Hardness (mg/L) Chloride (mg/L) Chloride (mg/L) Sulfate (mg/L) Sulfate (mg/L) Sulfate (mg/L) Sulfate (mg/L) Fluoride (mg/L) Fluoride (mg/L) Fluoride (mg/L) Arsenic, dissolved (As) Arsenic, dissolved (As) Arsenic, dissolved (As) Arsenic, dissolved (As) Arsenic, total (As) Arsenic, total (As) Arsenic, total (As) Arsenic, total (As) Beryllium, dissolved (Be) Beryllium, dissolved (Be) Beryllium, dissolved (Be) Cadmium, dissolved (Cd) Cadmium, dissolved (Cd) Cadmium, dissolved (Cd) Cadmium, total (Cd) Cadmium, total (Cd) Cadmium, total (Cd) Cadmium, total (Cd) Cadmium, total (Cd) Chromium, dissolved (Cr) Chromium, dissolved (Cr) Chromium, dissolved (Cr) Chromium, total (Cr) Chromium, total (Cr) Chromium, total (Cr) Chromium, total (Cr) Chromium, total (Cr) Copper, dissolved (Cu) Copper, dissolved (Cu) Copper, dissolved (Cu) Copper, dissolved (Cu) Copper, dissolved (Cu) Copper, dissolved (Cu) Copper, dissolved (Cu) Copper, total (Cu) Copper, total (Cu) Copper, total (Cu) Lead, dissolved (Pb) Lead, dissolved (Pb) Lead, dissolved (Pb) Lead, total (Pb) Lead, total (Pb) Nickel, dissolved (Ni) Nickel, dissolved (Ni) Nickel, dissolved (Ni) Nickel, total (Ni) Nickel, total (Ni) Nickel, total (Ni) Silver, dissolved (Ag) Silver, dissolved (Ag) Silver, dissolved (Ag) Silver, dissolved (Ag) Silver, total (Ag) Silver, total (Ag) Silver, total (Ag) Zinc, dissolved (Zn) Zinc, dissolved (Zn) Zinc, dissolved (Zn) Zinc, total (Zn) Zinc, total (Zn) Zinc, total (Zn) Selenium, dissolved (Se) Selenium, dissolved (Se) Selenium, dissolved (Se) Selenium, total (Se) Selenium, total (Se) Mercury, total (Hg) (ng/L) Mercury, total (Hg) (ng/L) 1,4-Dioxane in Water 1,4-Dioxane in Water 1,4-Dioxane in Water Chlorophyll a (ug/L) Chlorophyll a (ug/L) Turbidity (NTU) Turbidity (NTU) Turbidity (NTU) Turbidity (NTU) Turbidity (NTU) Parameter of Interest samplegroup Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Field Other Other Other Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Nutrients (mg/L) Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Metals (ug/L) Volatile Organics (ug/L) Volatile Organics (ug/L) Volatile Organics (ug/L) Other Other Other Other Other Other Other CountOf Results 44 50 54 60 55 55 51 57 82 84 84 84 77 17 43 43 16 57 44 44 41 41 58 58 79 80 19 19 19 50 60 20 58 56 49 57 56 53 59 59 58 53 53 58 18 50 58 56 57 41 1 4 7 1 1 19 19 19 14 18 5 19 1 4 54 11 30 16 2 16 31 4 5 4 9 16 20 2 5 8 24 2 4 8 2 4 7 2 5 7 14 25 2 8 10 2 11 4 7 14 2 2 10 10 4 4 9 2 4 13 2 8 10 11 1 2 8 10 2 4 14 2 4 8 10 2 2 12 2 7 10 2 6 14 4 2 2 2 10 4 3 13 11 11 75 64 11 8 53 57 59 SumOf NDs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 3 16 24 21 16 18 4 3 0 0 0 3 0 0 1 1 8 0 0 0 0 3 39 0 0 0 0 1 0 0 0 0 0 3 0 0 0 0 0 0 0 1 0 28 4 5 4 9 16 20 2 5 8 24 2 4 8 2 4 7 2 5 7 14 25 2 8 10 2 11 4 7 13 0 0 7 7 2 2 9 0 1 12 2 8 10 10 1 2 8 10 2 4 13 2 4 8 10 2 2 12 2 7 10 1 5 13 4 2 2 2 10 2 1 4 11 11 4 19 0 0 3 0 2 SumOf Exceedences 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 2 17 0 0 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 0 0 0 8 2 3 SumOf Nonexceedances 44 50 54 60 55 55 51 55 82 84 84 84 77 17 43 43 14 40 44 44 41 41 44 58 79 80 19 19 19 50 60 20 58 56 49 57 56 53 59 59 58 53 53 58 18 50 58 56 57 41 1 4 7 1 1 19 19 19 14 18 5 19 1 4 23 11 30 16 2 16 31 4 5 4 9 16 20 2 5 8 24 2 4 8 2 4 7 2 5 7 14 25 2 8 10 2 11 4 7 14 2 1 9 9 3 3 9 2 4 13 2 8 10 11 1 2 8 10 2 4 14 2 4 8 10 2 2 12 2 7 10 2 6 14 4 2 2 2 10 4 3 13 11 11 51 64 11 8 45 55 56 EL >29 >29 >29 >32 >32 >32 >32 >32 N/A N/A N/A N/A N/A N/A <4 <5 <4 <4 <6 >9 <4.3 >8.5 <6.8 >8.5 N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A >10 >10 N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A >1 N/A >100 >100 >100 >100 N/A N/A N/A N/A >230 >230 >250 >250 N/A N/A >1.8 >1.8 >1.8 >10 >10 >10 >10 >10 >10 >10 >10 >6.5 >6.5 N/A >0.15 >0.15 >8.8 N/A N/A N/A N/A N/A >11 >50 >11 N/A N/A N/A N/A N/A acute chronic acute chronic acute chronic >2.7 N/A N/A N/A >0.54 >8.1 >0.54 N/A N/A >16 >8.2 >16 >25 N/A >25 >0.06 >0.06 >0.1 >0.06 N/A N/A N/A >36 >81 >36 N/A N/A N/A N/A N/A N/A >5 >71 >12 >25 >80 >0.35 >80 >40 >40 >25 >50 >10 >25 >50 ELNum 29 29 29 32 32 32 32 32 0 0 0 0 0 0 4 5 4 4 6 9 4.3 8.5 6.8 8.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 10 0 0 0 0 0 0 0 0 0 0 0 1 0 100 100 100 100 0 0 0 0 230 230 250 250 0 0 1.8 1.8 1.8 10 10 10 10 10 10 10 10 6.5 6.5 0 0.15 0.15 8.8 0 0 0 0 0 11 50 11 0 0 0 0 0 calculated calculated calculated calculated calculated calculated 2.7 0 0 0 0.54 8.1 0.54 0 0 16 8.2 16 25 0 25 0.06 0.06 0.1 0.06 0 0 0 36 81 36 0 0 0 0 0 0 5 71 12 25 80 0.35 80 40 40 25 50 10 25 50 MinVal 5.9 4.9 0.2 0.7 0.2 3.2 1.9 4.8 60 61 59 69 53 51 6.9 6.9 2.3 0.2 6.5 6.5 5.2 5.2 5.3 5.3 0.01 0.05 6.2 6.2 6.2 0.02 0.02 0.02 0.02 0.02 0.2 0.2 0.21 0.26 0.2 0.64 0.36 0.02 0.02 0.02 0.17 0.02 0.03 0.02 0.02 0.02 8 8 10 13 0 9 20 24 10 24 4 11 48 64 45 3 4 6 2 2 0.4 0.4 0.4 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 5 5 5 5 2.4 2.4 2 2 2 2 2 2.7 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 10 10 10 10 10 10 1 1 1 1 1 1 1 1 1 1 1 1 2.1 1.7 1 3 1 10th 7.3 7 6.8 6.4 5.7 5.1 4.7 5.6 86 86 88 88 87 55 7.7 7.7 3.2 3 7 7 6 6 6.6 6.6 0.03 0.1 6.2 6.2 6.2 0.02 0.02 0.02 0.02 0.02 0.2 0.23 0.29 0.47 0.21 0.73 0.49 0.04 0.23 0.02 0.18 0.03 0.04 0.02 0.02 0.02 8 8 10 13 0 9 20 35 18 28 4 21 48 64 100 4 6 8 2 2 0.4 0.4 0.4 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 5 5 5 5 2.4 2.4 2 2 2 2 2 2.7 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 10 10 10 10 10 10 1 1 1 1 1 1 1 1 1 1 1 1 2.4 1.7 1.2 4.3 1.4 25th 10.8 10 9.9 9.1 8.1 9.1 7.8 9.4 102 98 99 99 102 74 8.2 8.2 5 3.8 7.1 7.1 6.4 6.4 6.8 6.8 0.05 0.3 6.2 8.3 6.2 0.02 0.02 0.02 0.02 0.03 0.2 0.28 0.31 0.61 0.44 0.89 0.56 0.06 0.32 0.14 0.25 0.04 0.05 0.03 0.03 0.02 8 9 11 13 0 11 22 39 29 31 4 22 48 136 168 5 7 15 2 2 0.4 0.4 0.4 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 5 5 5 5 2.4 2.4 2 2 2 2 2 2.7 2.1 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 10 10 10 10 10 10 1 1 1 1 1 1 1 1 1 1 7 1 4.7 2 1.8 5.7 2.8 50th 17.6 15.2 16 18 15.8 16.8 16 18.2 127 118 120 118 116 90 9.6 9.6 6.2 5.2 7.3 7.3 6.7 6.7 7 7 0.43 1.32 7 11 6.2 0.02 0.04 0.02 0.03 0.04 0.25 0.34 0.4 0.81 0.58 1.1 0.61 0.09 0.51 0.22 0.32 0.06 0.08 0.03 0.04 0.02 8 12 13 13 0 12 23 45 34 40 4 25 48 545 335 6 8 22 3 3 0.4 0.4 0.4 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 5 5 5 5 2.6 2.6 2 2 2.2 2.2 2 3 2.6 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 10 10 10 13 10 10 1 1 1 1 1 3.4 6 1.4 1 1 27 2 8 3 4.3 7.5 5.3 75th 23.8 21.3 22.3 24.5 20.8 23.2 22.1 26.8 149 136 134 133 133 110 11.4 11.4 9 8 7.4 7.4 7 7 7.3 7.3 2.85 3.96 16 21 6.2 0.03 0.18 0.02 0.05 0.06 0.3 0.42 0.5 1 0.83 1.4 0.69 0.13 0.71 0.35 0.42 0.07 0.12 0.04 0.07 0.02 8 16 19 13 0 13 24 50 45 46 6 34 48 868 540 7 14 34 3 3 0.4 0.4 0.4 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 5 5 5 5 2.8 2.8 2.4 2.4 2.4 2.4 2 3.4 3 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 10 10 10 16 10.5 10 1 1 1 1 1 8.3 7.3 7.55 1 1 45 3 17 4.8 7 11 16 85th 26.4 23.6 23.3 26.7 21.8 23.9 22.8 28.4 165 156 150 152 145 129 12.2 12.2 9.5 8.6 7.5 7.5 7 7 7.5 7.5 4.2 5.28 17 76 12 0.04 0.3 0.02 0.08 0.07 0.36 0.46 0.52 1.1 1.03 1.5 0.71 0.2 0.83 0.39 0.46 0.08 0.13 0.05 0.08 0.02 8 17 28 13 0 14 25 51 51 50 8 35 48 910 740 8 17 40 3 4 0 0 0 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 6 5 5 7.2 2.8 2.8 3.5 3.5 2.4 2.4 2 3.4 3 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 10 11.2 10 16 11.9 10 1 1 1 1 1 9.1 7.3 12.53 1 1 59 4 19 6 13 16 33 90th 26.8 24.5 24.9 28 22.5 24.5 23.1 30.1 181 168 165 164 156 140 12.7 12.7 10.3 9.3 7.5 7.5 7.2 7.2 7.6 7.6 5.91 6.62 22 125 16 0.04 0.41 0.02 0.09 0.08 0.38 0.51 0.58 1.2 1.12 1.8 0.73 0.23 0.92 0.46 0.48 0.09 0.2 0.07 0.09 0.02 8 17 30 13 0 15 25 52 55 63 8 36 48 910 858 11 19 47 3 4 0.47 0.4 0.4 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 9 5 5 9 2.8 2.8 4.8 4.8 2.4 2.4 2 3.4 3 7.4 2 2 2 2.2 2 2 2 2 2 2 4.2 1 1 1 1 1 1 1 10 11.5 10 16 12 32.5 1 1 1 1 1 9.1 7.3 20.8 1 1 64 4 20.4 6.6 20.6 22 50 MaxVal 27.8 25.5 27 29.5 26.3 26.6 25 32.7 212 191 188 186 182 148 13.3 13.3 12 11 7.6 7.6 7.5 7.5 8.5 8.5 15.33 8.84 77 295 50 0.07 1.8 0.03 0.2 0.34 0.5 0.96 0.9 1.4 3.34 2.2 0.78 0.44 2.8 0.61 0.5 0.17 0.43 0.2 0.21 0.02 8 17 30 13 0 15 29 54 59 70 8 36 48 910 1500 12 77 48 3 4 0.8 0.4 0.4 2 2 2 2 2 2 2 2 5 5 5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5 5 5 5 10 5 5 10 2.8 2.8 5 5 2.4 2.4 2 3.4 3 11 2 2 2 2.2 2 2 2 2 2 2 6.4 1 1 1 1 1 1 1 10 11.5 10 16 12 55 1 1 1 1 1 9.1 7.3 26 1 1 142 10 21 6.6 550 39 110 N_Rows 44 50 54 60 55 55 51 57 82 84 84 84 77 17 43 43 16 57 44 44 41 41 58 58 79 80 19 19 19 50 60 20 58 56 49 57 56 53 59 59 58 53 53 58 18 50 58 56 57 41 1 4 7 1 1 19 19 19 14 18 5 19 1 4 54 11 30 16 2 16 31 4 5 4 9 16 20 2 5 8 24 2 4 8 2 4 7 2 5 7 14 25 2 8 10 2 11 4 7 14 2 2 10 10 4 4 9 2 4 13 2 8 10 11 1 2 8 10 2 4 14 2 4 8 10 2 2 12 2 7 10 2 6 14 4 2 2 2 10 4 3 13 11 11 75 64 11 8 53 57 59 %Exceedance 0 0 0 0 0 0 0 3.50877192982456E-02 0 0 0 0 0 0 0 0 0.125 0.298245614035088 0 0 0 0 0.241379310344828 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.574074074074074 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.5 0.1 0.1 0.25 0.25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.32 0 0 0 0.150943396226415 3.50877192982456E-02 5.08474576271186E-02 90%ConfidEC No No Yes Yes Yes No No No No No Yes No No No ConfidEC 1.79800283957399E-02 0.514178939808648 0.999972443266592 0.99855130612881 1 0.80982001 0.34829121326386 0.34829121326386 0.6558084485964 0.6558084485964 0.999999843200837 0.84356839434649 1.79800283957399E-02 5.69962000640212E-02 %Nonexceedance 1 1 1 1 1 1 1 0.964912280701754 1 1 1 1 1 1 1 1 0.875 0.701754385964912 1 1 1 1 0.758620689655172 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.425925925925926 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.5 0.9 0.9 0.75 0.75 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.68 1 1 1 0.849056603773585 0.964912280701754 0.949152542372881 ConfidMC 0.990349560778236 0.994874779072653 0.996638836814923 0.998214930584969 0.996975289249749 0.996975289249749 0.99538781368748 0.93364899098872 0.999824640762299 0.999857990580371 0.999857990580371 0.999857990580371 0.99970286255147 0.833542916579001 0.989276098208952 0.989276098208952 0.211177812251619 6.65513976040044E-06 0.990349560778236 0.990349560778236 0.986757672496821 0.986757672496821 4.56062371970948E-04 0.997795720786115 0.99975937214846 0.999783458996399 0.865199723039436 0.865199723039436 0.865199723039436 0.994874779072653 0.998214930584969 0.878693230763188 0.997795720786115 0.997278062795849 0.994304677267088 0.997550528709985 0.997278062795849 0.996264959234273 0.998016369135425 0.998016369135425 0.997795720786115 0.996264959234273 0.996264959234273 0.997795720786115 0.850205270629443 0.994874779072653 0.997795720786115 0.997278062795849 0.997550528709985 0.986757672496821 0.1001 0.3441915514036 0.522074984720061 0.1001 0.1001 0.865199723039436 0.865199723039436 0.865199723039436 0.77158767976967 0.850205270629443 0.409837977108099 0.865199723039436 0.1001 0.3441915514036 8.54682128017724E-19 0.686572737183852 0.957749918165392 0.815027132546951 0.19017999 0.815027132546951 0.961979151357036 0.3441915514036 0.409837977108099 0.3441915514036 0.612966759346749 0.815027132546951 0.878693230763188 0.19017999 0.409837977108099 0.569915278749583 0.920445995862565 0.19017999 0.3441915514036 0.569915278749583 0.19017999 0.3441915514036 0.522074984720061 0.19017999 0.409837977108099 0.522074984720061 0.77158767976967 0.928409351676722 0.19017999 0.569915278749583 0.65170878673614 0.19017999 0.686572737183852 0.3441915514036 0.522074984720061 0.77158767976967 0.19017999 0.01002001 0.264288512842236 0.264288512842236 5.23972377932003E-02 5.23972377932003E-02 0.612966759346749 0.19017999 0.3441915514036 0.746180330891955 0.19017999 0.569915278749583 0.65170878673614 0.686572737183852 0.1001 0.19017999 0.569915278749583 0.65170878673614 0.19017999 0.3441915514036 0.77158767976967 0.19017999 0.3441915514036 0.569915278749583 0.65170878673614 0.19017999 0.19017999 0.717946806191749 0.19017999 0.522074984720061 0.65170878673614 0.19017999 0.468913195599579 0.77158767976967 0.3441915514036 0.19017999 0.19017999 0.19017999 0.65170878673614 0.3441915514036 0.271242973001 0.746180330891955 0.686572737183852 0.686572737183852 3.50164324541134E-08 0.998829336396292 0.686572737183852 0.569915278749583 7.88415919087133E-02 0.93364899098872 0.854250615445667 CountOfResults 20192020 15 18 21 24 24 24 24 22 32 33 33 33 28 15 15 23 15 15 11 11 23 23 43 44 8 8 7 20 24 8 23 23 19 22 23 21 23 23 22 22 21 23 17 20 22 23 23 16 4 4 1 8 8 8 2 7 5 7 4 20 10 16 4 2 16 16 4 5 4 9 16 2 5 8 5 2 4 8 2 4 7 2 5 7 1 5 2 8 2 4 7 1 2 2 4 4 2 4 1 2 8 2 8 2 4 1 2 4 8 2 2 1 2 7 2 6 1 4 2 2 2 10 4 3 13 11 11 20 22 8 24 22 23 SumOfNDs 20192020 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 2 5 11 10 5 7 2 0 0 0 0 1 0 0 0 0 3 0 0 0 0 2 15 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 1 0 16 4 5 4 9 16 2 5 8 5 2 4 8 2 4 7 2 5 7 1 5 2 8 2 4 7 1 0 0 2 2 0 1 1 2 8 2 8 2 4 1 2 4 8 2 2 1 2 7 1 5 1 4 2 2 2 10 2 1 4 11 11 0 4 0 2 0 1 SumOf Exceedances 20192020 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 3 0 1 SumOf Nonexceedances 20192020 15 18 21 24 24 24 24 22 32 33 33 33 28 15 15 16 15 15 11 11 17 23 43 44 8 8 7 20 24 8 23 23 19 22 23 21 23 23 22 22 21 23 17 20 22 23 23 16 4 4 1 8 8 8 2 7 5 7 4 5 10 16 4 2 16 16 4 5 4 9 16 2 5 8 5 2 4 8 2 4 7 2 5 7 1 5 2 8 2 4 7 1 2 1 3 3 2 4 1 2 8 2 8 2 4 1 2 4 8 2 2 1 2 7 2 6 1 4 2 2 2 10 4 3 13 11 11 15 22 8 21 22 22 %Exceed 20192020 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.304347826086957 0 0 0 0 0.260869565217391 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.75 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.5 0.25 0.25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.25 0 0 0.125 0 4.34782608695652E-02 90%ConfidEC 20192020 Yes Yes Yes No No No No Yes No No ConfidEC 20192020 0.994195497667577 0.97729108202181 0.99999999999038 0.80982001 0.6558084485964 0.6558084485964 0.956665711668557 0.563609445818918 8.84031605038726E-02 %Nonexceed 20192020 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.695652173913043 1 1 1 1 0.739130434782609 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.25 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.5 0.75 0.75 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.75 1 1 0.875 1 0.956521739130435 ConfidMC 20192020 0.794451753024726 0.850205270629443 0.890836038363793 0.920445995862565 0.920445995862565 0.920445995862565 0.920445995862565 0.901763350923577 0.965785038306197 0.969209955971746 0.969209955971746 0.969209955971746 0.947827811966997 0.794451753024726 0.794451753024726 1.23792444211737E-03 0.794451753024726 0.794451753024726 0.686572737183852 0.686572737183852 5.80450233242295E-03 0.911596839496127 0.989276098208952 0.990349560778236 0.569915278749583 0.569915278749583 0.522074984720061 0.878693230763188 0.920445995862565 0.569915278749583 0.911596839496127 0.911596839496127 0.865199723039436 0.901763350923577 0.911596839496127 0.890836038363793 0.911596839496127 0.911596839496127 0.901763350923577 0.901763350923577 0.890836038363793 0.911596839496127 0.833542916579001 0.878693230763188 0.901763350923577 0.911596839496127 0.911596839496127 0.815027132546951 0.3441915514036 0.3441915514036 0.1001 0.569915278749583 0.569915278749583 0.569915278749583 0.19017999 0.522074984720061 0.409837977108099 0.522074984720061 0.3441915514036 3.31470029970421E-13 0.65170878673614 0.815027132546951 0.3441915514036 0.19017999 0.815027132546951 0.815027132546951 0.3441915514036 0.409837977108099 0.3441915514036 0.612966759346749 0.815027132546951 0.19017999 0.409837977108099 0.569915278749583 0.409837977108099 0.19017999 0.3441915514036 0.569915278749583 0.19017999 0.3441915514036 0.522074984720061 0.19017999 0.409837977108099 0.522074984720061 0.1001 0.409837977108099 0.19017999 0.569915278749583 0.19017999 0.3441915514036 0.522074984720061 0.1001 0.19017999 0.01002001 5.23972377932003E-02 5.23972377932003E-02 0.19017999 0.3441915514036 0.1001 0.19017999 0.569915278749583 0.19017999 0.569915278749583 0.19017999 0.3441915514036 0.1001 0.19017999 0.3441915514036 0.569915278749583 0.19017999 0.19017999 0.1001 0.19017999 0.522074984720061 0.19017999 0.468913195599579 0.1001 0.3441915514036 0.19017999 0.19017999 0.19017999 0.65170878673614 0.3441915514036 0.271242973001 0.746180330891955 0.686572737183852 0.686572737183852 1.13064281184981E-02 0.901763350923577 0.569915278749583 0.214779189189822 0.901763350923577 0.68542660232748 Header # A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN Column Header AGENCY HUC8 Station Number LOCATION LATITUDE LONGITUDE STREAM CLASS methodcode displayname Parameter of Interest samplegroup CountOfResults SumOfNDs SumOfExceedances SumOfNonexceedances EL ELNum MinVal 10th 25th 50th 75th 85th 90th MaxVal N_Rows %Exceedance 90%ConfidEC ConfidEC %Nonexceedance ConfidMC CountOfResults 20192020 SumOfNDs 20192020 SumOf Exceedences 20192020 SumOf Nonexceedances 20192020 %Exceed 20192020 90%ConfidEC 20192020 ConfidEC 20192020 %Nonexceed 20192020 ConfidMC 20192020 Description Name of collection agency (required) Not required Station number - DWR may assign a different number during the submittal process (required) Description of station location (required) Decimal Degrees (required) Decimal Degrees (required) Stream Classification (required) Method Code from QAPP (required) Parameter name - note other names are acceptable but examples provided here are preferred (required) Usually the same as displayname; DWR will populate not required Number of results 2016-2020 (required) Number of non-detects 2016-2020 (required) Sum of exceedances for 2016-2020 (required) Sum of non-exceedances for 2016-2020 (required) Evaluation level- usually the standard based on classfication, should be defined in the QAPP (required) Evaluation Level in numeric form, used to determine exceedances (required) not required - minimum value 2016-2020 not required - 10th percentile 2016-2020 not required - 25th percentile 2016-2020 not required - 50th percentile 2016-2020 not required - 75th percentile 2016-2020 not required - 85th percentile 2016-2020 not required - 90th percentile 2016-2020 not required - maximum value 2016-2020 optional - number of rows 2016-2020; Calculated: SumOfExceedances/CountOfResults; Reported in decimal form (required) Will be completed by DWR Will be calculated by DWR 2016-2020; Calculated: SumOfNonexceedances/CountOfResults; Reported in decimal form (required) Will be calculated by DWR Number of results 2019-2020 (required) Number of non-detects 2019-2020 (required) Sum of exceedances for 2019-2020 (required) Sum of non-exceedances for 2019-2020 (required) 2019-2020; Calculated: SumOfExceedances 20192020/CountOfResults 20192020; Reported in decimal form (required) DWR will calculate DWR will calculate 2019-2020; Calculated: SumOfNonexceedances 20192020/CountOfResults 20192020; Reported in decimal form (required) DWR will calculate Agency DWR DWR DWR DWR Station B0750000 B0840000 B0540050 C8896500 Latitude 36.11278 36.17299 36.12998 35.19801 Longitude -79.67181 -79.51026 -79.6626 -80.90453 Stream Class WS-V NSW WS-V NSW WS-V NSW C Date Range 4/1/2020 - 4/30/2020 6/1/2018 - 6/30/2018 7/15/2019 - 8/14/2019 1/1/2016-12/31/2020 methodcode 31616 31616 31616 31616 displayname Fecal coliform Fecal coliform Fecal coliform Fecal coliform ELNum 200/400 200/400 200/400 200/400 CountOfResults 5 5 5 82 SumOfExceedances 1 1 1 0 GeoMean 390.2 225.7 247.8 449.60727021 %Exceedance 0.2 0.2 0.2 0 N_5in30 1 1 1 0 Data_Tier 3 3 3 2 Header # A B C D E F G H I J K L M N O Column Header Agency Station Number Latitude Longitude Stream Class Date Range methodcode displayname ELNum CountOfResults SumOfExceedances GeoMean %Exceedance N_5in30 Data_Tier Description Name of collection agency (required) Station number - DWR may assign a different number during the submittal process (required) Decimal Degrees (required) Decimal Degrees (required) Stream Classification (required) For 5 in 30 collections, provide the 30-day window that samples were collected (required) Method Code from QAPP (required) Parameter name (required) Always 200/400: geometric mean is greater than 200 colonies/100ml of water, or greater than 20% of the samples exceed 400 colonies/100ml Count of individual sampling events (required) Sum of instantaneous sampling results greater than 400 colonies/100ml (required) Calculated Geomean (required for 5in30 reporting) In decimal form; Calculated = SumOfExceedances/CountOfResults (required) 1= row is reporting a 5in30 event, 0=no 5 in 30 is reported (required) DWR will fill in the correct Data Tier