bin tin_i tin_mass_i tin_soil_i tin_drysoil_i flask_i flask_mass_i flask_soil_i temp_i tin_f tin_mass_f tin_soil_f tin_drysoil_f flask_f flask_mass_f flask_soil_f temp_f notes NH4i_raw NO3i_raw NH4f_raw NO3f_raw moisture_i moisture_f NH4i NO3i NH4f NO3f net_min net_nit p_key datetime_i datetime_f IN 376 to 385 6 1.04 15.89 6.48 75 123.43 140.99 6.1 164 1.29 6.82 3.17 28 124.88 140.76 7.7 NULL 0.248 0.087 3.412 0.018 0.634 0.660 1.54 0.54 25.28 0.02 1.659 -0.037 1 2008-06-17 09:24:00 2008-07-01 09:00:00 2.08 674 to 677 220 1.42 17.6 10.42 14 124.77 138.57 1.4 127 1.37 7.24 4.92 94 125.78 142.04 9.3 NULL 0.619 1.015 0.724 0.2 0.444 0.395 3.23 5.29 2.94 0.28 -0.379 -0.358 2 2008-06-17 10:07:00 2008-07-01 10:30:00 8.52 1290 to 1299 16 1.39 10.95 8.47 59 123.99 134.52 5.9 211 1.26 6.18 4.86 86 117.99 129.01 1.9 NULL 0.416 0.222 0.519 1.36 0.259 0.268 2.13 1.14 2.57 1.73 0.074 0.042 3 2008-06-17 10:40:00 2008-07-01 11:00:00 3.27 236 to 244 210 1.37 10.68 4.67 34 125.76 143.9 NULL 10 1.4 12.19 5 34 125.75 139.39 3.4 NULL 1.471 0.17 5.651 0.064 0.646 0.666 9.16 1.06 49.62 0.07 2.819 -0.071 4 2008-07-01 10:00:00 2008-07-15 00:00:00 10.22 376 to 385 185 1.33 14.43 6.1 36 124.21 138.04 NULL 60 1.46 12.22 7.06 61 127.56 146.36 7.3 NULL 0.769 0.062 4.458 0.042 0.636 0.480 6.11 0.49 18.24 0.04 0.834 -0.032 5 2008-07-01 09:40:00 2008-07-15 00:00:00 6.60 674 to 677 167 1.38 9.58 2.24 48 112.84 141.09 NULL NULL NULL NULL NULL 88 121.17 143.67 6.2 sopping wet 7.209 0.569 6.158 0.133 0.895 NULL 97.21 7.67 NULL NULL NULL NULL 6 2008-07-01 10:30:00 2008-07-15 00:00:00 104.88 856 to 865 121 1.44 9.78 4.84 G 125.63 142.23 NULL 80 1.47 14.97 7.61 32 112.87 127.67 14.3 NULL 0.714 0.048 0.678 0.041 0.592 0.545 4.22 0.28 4.03 0.04 -0.031 -0.017 7 2008-07-01 09:30:00 2008-07-15 00:00:00 4.50 1290 to 1299 132 1.38 8.35 7.6 96 126.4 138.08 NULL 78 1.45 11.27 10.25 94 125.74 135.84 41 NULL 0.708 0.469 0.553 0.947 0.108 0.104 2.72 1.80 2.44 1.01 -0.076 -0.056 8 2008-07-01 10:40:00 2008-07-15 00:00:00 4.52 236 to 244 191 1.39 12.82 5.32 G 125.62 139.61 7.7 194 1.033 11.84 4.45 45 124.2 140.52 3.2 NULL 0.691 0.176 10.748 0.033 0.656 0.684 5.74 1.46 83.36 0.04 5.443 -0.101 9 2008-07-15 09:10:00 2008-07-29 00:00:00 7.20 376 to 385 134 1.06 11.14 5.65 39 126.26 139.06 9.3 36 1.48 12.19 6.18 86 112.51 126.49 8.6 NULL 0.15 0 0.444 0.038 0.545 0.561 1.03 0.00 2.89 0.09 0.139 0.006 10 2008-07-15 08:30:00 2008-07-29 00:00:00 1.03 582 to 588 254 1.43 10.58 8.22 79 122.73 133.21 1.9 1 1.49 11.62 7.68 40 126.2 141.55 NULL "actual point under snow, so it is 4 m down slope at edge of snow" 0.628 0.092 0.631 0.304 0.258 0.389 3.23 0.47 2.69 0.20 -0.058 -0.019 11 2008-07-15 08:40:00 2008-07-29 00:00:00 3.70 674 to 677 192 1.42 10.22 3.04 23 126.6 142.09 3.4 146 1.34 11.64 3.49 89 126.2 140.14 NULL 674I may be switched with 674F 5.076 0.404 6.112 0.121 0.816 0.791 71.24 5.67 83.91 0.45 0.532 -0.373 12 2008-07-15 09:30:00 2008-07-29 00:00:00 76.91 745 to 753 169 1.4 11.41 7.48 37 122.05 132.43 7.3 259 1.4 11.08 7.49 71 124.18 134.2 NULL NULL 0.623 0.352 4.45 1.653 0.393 0.371 3.96 2.23 28.24 1.66 1.694 -0.041 13 2008-07-15 10:30:00 2008-07-29 00:00:00 6.19 856 to 865 185 1.34 12.01 5.96 86 117.98 127.92 6.2 130 1.43 12.85 6.14 35 121.97 137.98 NULL NULL 0.177 0.076 0.223 0.08 0.567 0.588 1.64 0.71 1.35 0.08 -0.066 -0.045 14 2008-07-15 08:50:00 2008-07-29 00:00:00 2.35 1290 to 1299 230 1.37 10.71 9.79 29 121.52 131.55 14.3 11 1.46 10.74 10.04 30 111.2 122.47 NULL NULL 0.347 0.378 0.634 1.015 0.099 0.075 1.54 1.67 2.43 0.47 -0.022 -0.086 15 2008-07-15 10:50:00 2008-07-29 00:00:00 3.21 1659 to 1668 255 1.38 9.42 6.04 38 124.15 134.41 5 106 1.29 11.38 6.55 56 124.72 135.31 NULL "open, just barely outside of krummholz snow drift" 0.682 0.226 1.694 2.974 0.420 0.479 4.58 1.52 12.28 2.88 0.647 0.097 16 2008-07-16 08:50:00 2008-07-29 00:00:00 6.10 1808 to 1811 253 1.41 9.55 4.79 31 125.91 136.09 3.27 14 1.37 10.46 4.67 83 126.07 136.41 NULL tree 0.674 0.376 1.594 4.133 0.585 0.637 6.38 3.56 16.99 8.53 1.113 0.355 17 2008-07-16 09:00:00 2008-07-29 00:00:00 9.94 1920 to 1926 251 1.38 9.14 7.26 92 114.58 124.34 8.61 258 1.28 10.89 6.02 42 125.6 141.19 NULL soil seemed unusually wet 0.19 0.152 0.923 0.143 0.242 0.507 1.03 0.82 4.80 0.12 0.219 -0.050 18 2008-07-16 09:10:00 2008-07-29 00:00:00 1.85 236 to 244 223 1.42 14.19 7.89 43 122.45 136.95 NULL 142 1.49 17.59 8.9 35 121.91 139.67 7.9 NULL 0.323 0.039 0.882 0.377 0.493 0.540 1.76 0.21 4.32 0.31 0.190 0.007 19 2008-07-29 08:45:00 2008-08-12 00:00:00 1.97 376 to 385 103 1.04 13.61 8.18 66 117.85 130.64 NULL 234 1.37 16 7.45 64 116.97 133.47 8.9 NULL 0.096 0.02 0.682 0.016 0.432 0.584 0.53 0.11 3.97 0.02 0.239 -0.006 20 2008-07-29 08:10:00 2008-08-12 00:00:00 0.64 582 to 588 7 1.04 11.91 9.99 60 122.4 133.58 NULL 25 1.39 11.27 9.26 93 114.71 124.66 11.2 NULL 0.447 0.111 0.454 0.141 0.177 0.203 1.94 0.48 2.29 0.22 0.006 -0.019 21 2008-07-29 09:00:00 2008-08-12 00:00:00 2.42 674 to 677 16 1.4 10.77 5.01 58 119.46 131.65 NULL 67 1.39 15.31 5.29 86 112.17 131.28 8.1 674I may be switched with 674F 1.228 0.092 13.282 0.054 0.615 0.720 10.47 0.78 99.29 0.17 6.301 -0.044 22 2008-07-29 08:40:00 2008-08-12 00:00:00 11.25 745 to 753 157 1.05 11.67 8.16 76 125.11 135.44 NULL 105 1.03 10.89 7.64 70 134.07 144.08 7.6 NULL 0.364 0.115 0.453 1.849 0.331 0.330 2.11 0.67 2.70 1.49 0.101 0.059 23 2008-07-29 09:20:00 2008-08-12 00:00:00 2.78 856 to 865 177 1.47 10.36 4.93 20 124.34 135.05 NULL 235 1.05 7.89 3.3 51 120.69 130.25 7.2 NULL 0.099 0.12 0.4 0.13 0.611 0.671 0.95 1.15 5.09 0.20 0.228 -0.068 24 2008-07-29 08:30:00 2008-08-12 00:00:00 2.10 1290 to 1299 46 1.03 10.61 9.2 93 126.12 136.7 NULL 266 1.35 11.15 9.34 41 125.84 135.15 8.6 NULL 0.334 0.654 0.173 1.457 0.147 0.185 1.48 2.90 0.91 0.76 -0.194 -0.153 25 2008-07-29 10:00:00 2008-08-12 00:00:00 4.38 1659 to 1668 85 1.4 10.76 8.51 46 122.62 132.88 NULL 233 1.4 9.34 6.4 38 124.15 134.29 8.2 NULL 0.366 0.39 0.611 8.342 0.240 0.370 1.88 2.00 3.83 5.50 0.389 0.250 26 2008-07-29 09:35:00 2008-08-12 00:00:00 3.88 1808 to 1811 252 1.41 10.7 6.02 81 126.04 137.18 NULL 24 1.03 8.57 3.85 42 124.86 134.25 5.8 NULL 4.118 3.719 3.052 4.796 0.504 0.626 29.81 26.92 34.76 5.56 -1.172 -1.526 27 2008-07-29 09:40:00 2008-08-12 00:00:00 56.73 1920 to 1926 94 1.41 11.48 9.37 49 113 124.22 NULL 118 1.4 10.09 6.69 89 126.19 136.07 7.2 NULL 0.345 0.142 0.684 0.139 0.210 0.391 1.56 0.64 4.55 0.19 0.181 -0.032 28 2008-07-29 09:30:00 2008-08-12 00:00:00 2.20 236 to 244 56 1.41 10.32 5.22 50 126.89 136.76 7.9 66 1.42 11.92 5.68 94 110.82 120.6 NULL NULL 0.529 0.109 3.383 0.556 0.572 0.594 5.01 1.03 34.08 2.06 2.150 0.074 29 2008-08-12 08:45:00 2008-08-26 00:00:00 6.04 376 to 385 141 1.36 15.49 8.32 92 114.61 130.59 8.9 237 1.41 11.52 5.39 97 124.38 134.7 NULL NULL 0.329 0.08 0.524 0.722 0.507 0.606 1.67 0.41 5.15 1.94 0.358 0.109 30 2008-08-12 08:10:00 2008-08-26 00:00:00 2.08 582 to 588 268 1.62 10.32 8.76 62 127.07 137.45 11.2 128 1.07 11.24 8.83 51 120.72 130.91 NULL NULL 0.227 0.048 0.358 0.056 0.179 0.237 1.07 0.23 1.84 0.04 0.041 -0.014 31 2008-08-12 09:00:00 2008-08-26 00:00:00 1.30 674 to 677 44 1.02 12.05 6.8 96 113.19 123.34 8.1 139 1.33 11.39 5.29 91 111.56 121.78 NULL 674F extracted with 80 ml KCl 0.633 0.263 0.982 0.794 0.476 0.606 4.76 1.98 9.75 2.62 0.402 0.046 32 2008-08-12 08:40:00 2008-08-26 00:00:00 6.74 745 to 753 181 1.29 11.39 7.84 11 121.16 131.5 7.6 250 1.29 11.55 7.62 94 125.75 135.57 NULL NULL 0.418 0.085 0.72 0.555 0.351 0.383 2.49 0.51 4.75 0.87 0.187 0.026 33 2008-08-12 09:20:00 2008-08-26 00:00:00 3.00 856 to 865 79 1.47 10.18 5.31 12 125.17 136.38 7.2 122 1.04 11.57 5.58 13 126.38 136.09 NULL NULL 0.753 1.879 1.066 0.115 0.559 0.569 6.09 15.20 10.19 0.09 -0.786 -1.079 34 2008-08-12 08:30:00 2008-08-26 00:00:00 21.29 1290 to 1299 112 1.44 11.16 8.26 14 124.77 134.49 8.6 29 1.43 11.45 8.13 G 125.64 135.35 NULL NULL 0.453 0.716 0.867 0.582 0.298 0.331 2.66 4.20 5.34 0.26 -0.090 -0.281 35 2008-08-12 10:00:00 2008-08-26 00:00:00 6.86 1659 to 1668 226 1.04 12.11 9.26 27 117.27 127.82 8.2 42 1.29 11.56 8.3 58 119.46 129.31 NULL NULL 0.42 0.466 0.665 0.684 0.257 0.317 2.14 2.38 3.95 0.56 -0.001 -0.130 36 2008-08-12 09:35:00 2008-08-26 00:00:00 4.52 1808 to 1811 42 1.3 10.76 5.33 17 127.08 137.16 5.8 113 1.31 11.38 5.72 70 134.06 144.27 NULL NULL 3.576 4.002 6.793 12.442 0.574 0.562 33.31 37.28 60.76 15.30 0.391 -1.570 37 2008-08-12 09:40:00 2008-08-26 00:00:00 70.59 1920 to 1926 166 1.38 10.04 6.75 94 125.75 135.3 7.2 14 1.38 11.32 7.55 john 125.99 135.8 NULL NULL 0.386 0.131 1.282 0.256 0.380 0.379 2.61 0.88 8.42 0.12 0.361 -0.054 38 2008-08-12 09:30:00 2008-08-26 00:00:00 3.49 236 to 244 160 1.37 11.31 6.03 37 122.06 132.18 NULL NULL NULL NULL NULL NULL NULL NULL NULL final sample missing 0.912 0.282 NULL NULL 0.531 NULL 7.69 2.38 NULL NULL NULL NULL 39 2008-08-26 00:00:00 2008-09-09 00:00:00 10.07 376 to 385 235 1.04 11.38 6.74 76 125.1 135.06 NULL 212 1.46 11.27 6.79 54 120.08 129.92 NULL NULL 0.26 0.031 0.457 0.12 0.449 0.457 1.90 0.23 3.42 0.12 0.101 -0.008 40 2008-08-26 00:00:00 2008-09-09 00:00:00 2.13 582 to 588 18 1.01 11.16 8.84 89 114.2 124.63 NULL 158 1.38 11.3 9.23 41 125.84 135.97 NULL NULL 0.193 0.403 0.38 0.284 0.229 0.209 0.96 2.00 1.90 0.15 -0.065 -0.132 41 2008-08-26 00:00:00 2008-09-09 00:00:00 2.96 674 to 677 118 1.4 11.72 8.04 31 125.91 135.69 NULL 79 1.46 11.6 8.36 89 126.19 136.16 NULL NULL 0.968 0.143 4.102 0.582 0.357 0.320 6.16 0.91 24.20 0.73 1.276 -0.013 42 2008-08-26 00:00:00 2008-09-09 00:00:00 7.07 745 to 753 214 1.28 11.05 7.67 89 126.17 136.28 NULL 229 1.43 11.37 7.86 76 125.09 135.18 NULL NULL 0.438 0.578 0.83 1.295 0.346 0.353 2.65 3.50 5.09 1.35 0.021 -0.154 43 2008-08-26 00:00:00 2008-09-09 00:00:00 6.15 856 to 865 221 1.39 11.93 3.13 41 125.84 135.42 NULL 23 1.37 11.29 6.09 51 120.69 130.8 NULL NULL 0.191 0.162 0.799 0.107 0.835 0.524 4.83 4.10 6.64 0.11 -0.156 -0.285 44 2008-08-26 00:00:00 2008-09-09 00:00:00 8.93 1290 to 1299 129 1.29 11.44 7.93 66 117.85 127.65 NULL 171 1.39 11.23 8.15 89* 114.2 124.27 NULL NULL 0.65 0.229 0.769 0.856 0.346 0.313 4.06 1.43 4.45 1.41 0.026 -0.001 45 2008-08-26 00:00:00 2008-09-09 00:00:00 5.49 1659 to 1668 238 1.36 11.29 7.94 22 126.96 136.7 NULL 218 1.42 11.49 8.65 91 111.56 121.63 NULL NULL 0.261 0.06 0.38 0.213 0.337 0.282 1.62 0.37 2.10 0.39 0.036 0.001 46 2008-08-26 00:00:00 2008-09-09 00:00:00 1.99 1808 to 1811 196 1.03 11.46 6.03 54 120.08 130.28 NULL 132 1.37 11.49 6.03 22 126.96 137.34 NULL NULL 0.907 2.015 2.185 2.464 0.521 0.540 7.43 16.50 18.30 1.86 -0.269 -1.046 47 2008-08-26 00:00:00 2008-09-09 00:00:00 23.93 1920 to 1926 195 1.28 11.31 7.51 19 125.55 135.37 NULL 268 1.61 11.76 8.03 19 125.56 135.53 NULL NULL 0.212 0.369 0.747 0.298 0.379 0.367 1.39 2.42 4.73 0.16 0.077 -0.161 48 2008-08-26 00:00:00 2008-09-09 00:00:00 3.81 236 to 244 5 1.39 11.36 7.53 58 119.45 129.48 NULL 180 1.43 11.38 7.76 37 122.06 132.59 5 NULL 0.994 0.147 1.187 0.541 0.384 0.364 6.44 0.95 7.09 0.36 0.004 -0.042 49 2008-09-09 08:30:00 2008-09-23 08:40:00 7.39 376 to 385 175 1.27 11.5 6.76 70 134.07 144.79 NULL 220 1.43 12.09 5.95 51 120.69 138.81 5 NULL 0.125 0.103 0.268 0.026 0.463 0.576 0.87 0.72 1.40 0.03 -0.011 -0.049 50 2008-09-09 08:00:00 2008-09-23 08:30:00 1.59 582 to 588 131 1.48 12.43 11.25 66 117.85 128.04 NULL 210 1.37 12.47 10.97 54 120.08 130.54 5.2 NULL 0.521 0.144 0.504 0.18 0.108 0.135 2.29 0.63 2.23 0.11 -0.041 -0.037 51 2008-09-09 08:40:00 2008-09-23 08:43:00 2.92 674 to 677 101 1.37 11.32 9.12 G 125.63 135.96 NULL 135 1.42 11.61 8.96 89 126.2 136.94 4.5 NULL 0.854 0.147 2.007 0.476 0.221 0.260 4.25 0.73 10.10 0.54 0.404 -0.014 52 2008-09-09 08:20:00 2008-09-23 08:37:00 4.98 745 to 753 34 1.36 11.41 6.67 37 122.06 132.33 NULL 51 1.4 11.44 9.56 76 125.1 135.44 4.1 NULL 0.39 0.224 0.443 0.873 0.472 0.187 2.88 1.65 2.11 0.72 -0.121 -0.066 53 2008-09-09 08:50:00 2008-09-23 08:46:00 4.53 856 to 865 258 1.28 11.51 7.58 94 110.83 120.81 NULL 72 1.39 11.45 7.28 19 125.56 135.6 4.2 NULL 0.132 0.099 0.265 0.091 0.384 0.415 0.86 0.64 1.80 0.05 0.025 -0.042 54 2008-09-09 08:10:00 2008-09-23 08:34:00 1.50 1290 to 1299 159 1.41 11.61 9.46 94 125.76 135.78 NULL 145 1.3 11.12 9.23 91 111.57 121.74 3.1 NULL 0.425 0.437 0.556 0.418 0.211 0.192 2.15 2.21 2.71 0.67 -0.070 -0.110 55 2008-09-09 09:30:00 2008-09-23 09:00:00 4.36 1659 to 1668 71 1.39 11.31 10 31 125.91 135.94 NULL 179 1.02 11.36 9.78 41 125.83 135.97 2.5 NULL 0.325 0.161 0.493 0.363 0.132 0.153 1.49 0.74 2.30 0.18 0.018 -0.040 56 2008-09-09 09:10:00 2008-09-23 08:52:00 2.23 1808 to 1811 59 1.39 11.78 6.78 13 126.38 136.24 NULL 12 1.37 11.12 6.35 13 126.38 136.36 2.8 NULL 0.855 1.155 2.645 3.702 0.481 0.489 6.68 9.03 20.75 2.35 0.528 -0.477 57 2008-09-09 09:20:00 2008-09-23 08:55:00 15.71 1920 to 1926 222 1.42 11.38 9.07 97 124.37 134.36 NULL 62 1.38 11.55 9.11 22 126.96 137.37 3.7 NULL 0.336 0.192 0.832 0.294 0.232 0.240 1.75 1.00 4.21 0.13 0.114 -0.062 58 2008-09-09 09:00:00 2008-09-23 08:49:00 2.75