Date: Thu, 28 Mar 2024 15:12:26 -0500 (CDT)
Message-ID: <1861698086.202.1711656746760@os-confluence.ncsa.illinois.edu>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_201_2076558996.1711656746760"
------=_Part_201_2076558996.1711656746760
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
https://github.com/geostreams/gltg/issues/16<=
/p>
2012 Nutrient Model results by SPARROW
https://www.sciencebase.gov/=
catalog/item/5cbf5150e4b09b8c0b700df3
Need to aggregate to HUC8
The data (total N and P) is organized by ComID.
Therefore, we need to add up the value of comID to the HUC8 that comIDs =
are belong to.
Data
Steps
- Derive a relationship table between (catchment (COMID) and HUC8) from c=
rosswalk data above
- calculate (add up) the total N and P value by huc8 by using table above=
- join the table above (calcualted table) with HUC8 boundary
2002 Nutrient Model Results by SPARROW
Nitrogen output
Phosphorus
We need to join the table with HUC8 boundary to generate geospatia=
l layer
------=_Part_201_2076558996.1711656746760
Content-Type: application/octet-stream
Content-Transfer-Encoding: base64
Content-Location: file:///C:/d95d106a42fb94d8fa542df4bb889052
iVBORw0KGgoAAAANSUhEUgAAAPoAAAD6CAMAAAC/MqoPAAADAFBMVEX19fXv7+98fHx1dXV9fX23
t7eenp5wcHDn5+f09PTz8/Pd3d2SkpLY2Njt7e3Q0NCioqJycnKqqqq7u7uurq6CgoKGhobOzs7D
w8PR0dGNjY3Hx8fj4+PGxsbS0tKoqKgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAABYhwFnAAADwUlEQVR4Xu3cC2/aSBSG4akvjAOxIYEKqoZ2/v+vipp2tU0VRbQE
SlJwbYxvA8mWrPGlfh+pYXx8avHJZlDiASEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
oAHe6IXTcDYbU689Y20YP/VagzmW7ei15zi28ce9DdCx9cpL7I5eOQlDL5zEH1/tW+ZGrzSY1Asv
O7L9lco567XU4uhHvQhfzVrrFW/SWRmjt/5K3xHabz+FiqK7C3P56Iv13D2Ufa+9wfR5ayzfRYN3
0s3v2dLbm0zL4lkf4mHf9LJ7IuVEr2Sauxh8ioez/kV2T5ksvVCGxTIdryp5BuXRrmAz80uTF060
2v6/94I/s/x043tlZ72K6DVB9DYiehtVFr2cN7CXVBa9ekRvI6K3EdHbiOhtRPTqdLtdvVSSSqKH
YZ92d5JNeyHOKklfRfTlzAlO9iDacDdC+LN8QzmqiC66fbEY3E9E+Bf5u4UQ/UrOeiU3nnzjp/je
NXvG6N71g+j2Mn9HvZwbT5VEP//RfRKPwjUfjB9PQvSW3fydt3Kil0P/u8RUZpbLOMb7dGNLb2+y
vSxDqxcPXTnM7gnttTfYfpapMRg7Z2fOeGDp5/xQe3MdyOLZ55a8sM7tAyv3DrQ31pFZjmx/pUre
1+uB6Ce2Pmrpp1PO23o50Y2jwqxLelJ64SQM/5jlwSVFP/DWcgrtXRQOAAAAAAAAAKgHpRcOUXrh
fyvuA3YqerjO1g5Q13qlKsVF/8/QdVP4PR5PXgY/L+UbNZJSjsLSR+nLj8GjupS+EkqpqDNtGAaD
7ZfRxJ1uUIjWmSSHy1VrRu0ee3IqxvJKKDn1pnIihC0n3iR8ykr2sq/ZpEEFDVemmemUHSfYlT9c
rlovKhIuj3ovx8F2eH7s4JnK8Pt4woEKP7Cv0v8QN6h+MLjKdgZRE/Hh8tUCFHjBX28JcTP5vPka
bD+I3bK88Md2cJM2h5KGp+Df5/ArHOLO4be3ozhnfLh8tQAFTnOJO/HM/dvks9tK5GbFRTqM/PPh
37XVeYw2ksPlqnWi4sFQ9rev7OSCTy7scK+frIdNL/hoM9MZ6u0e48PlqwUo8ILf6c1Hs8E8mNDm
wSxmnAuxiQdbjpdkz9VDSaccOt527lfp4TLVYhQYPZrmvF/+F/HV/eUJ93Z127sLXsmT29nt5G7X
tbl/ULth3JBIOi/m/ir6OoP0cNlqzSm9oFN6oWQFnvWmaXF0AAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAPir/QahWrKTbTZtTgAAAABJRU5ErkJggg==
------=_Part_201_2076558996.1711656746760
Content-Type: application/octet-stream
Content-Transfer-Encoding: base64
Content-Location: file:///C:/f1991ee84c8b49b701891af717cb4af7
iVBORw0KGgoAAAANSUhEUgAAAPoAAAD6CAMAAAC/MqoPAAADAFBMVEX19fXv7+98fHx1dXV9fX23
t7eenp5wcHDn5+f09PTz8/Pd3d2SkpLY2Njt7e3Q0NCioqJycnKqqqq7u7uurq6CgoKGhobOzs7D
w8PR0dGNjY3Hx8fj4+PGxsbS0tKoqKgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAABYhwFnAAAEQ0lEQVR4Xu3cDVfiOBSA4UwppIIUFWZlDjLm//8qz467O7rrcR0V
Bx3oJin9IKArMjQyvI8K6c2t5dI2HG1ACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADY
Ah/cwGZE02nNjT1jEgTf3dgWi8J65MaeE9WDV+dugUbdjbyk3nAjGxG4gY149dFu1aZuZItJN/Cy
FdPfqJq9/i7tcOkrnYRvFk7cSNxvjIPex2TsdhiL6ZvgqfT2qPbwmIjJXXtZ7QvpW8wdt47lp7Tx
Sbbneyw3fZs5tcTh56zZqcXlnlQ1pXsZ5g4Pfs+aN53Dck+VQjdQhdFD0R57eQTVcY7gWumPptgM
tE7/r3vA74VJsfDN2173Ufo7Qem7iNJ3kbfSq3kBe4m30v2j9F1E6buI0ncRpe8iSven2Wy6oYp4
Kd0U+zS7klyrj8Sel+p9lP5wE+mdfZAutKdCJDfzCdXwUbpodsTo4LovzH/kr0ZCdLzsdS8XnpLg
u/jWrLWC3nU70aXXH+avqFdz4clL6fu3zSfxKNq1++D2SYjWQ3P+yls1pVfD/b/EUJamy0TBoFiw
3PRttlBLN2xlzbbslnuMhfQttljLMDg4jvb2ouOD0N3ny9K315Ja4vp+KA/D/fqSmXtL0rfWirWs
mP5GXl7X3wdK37DJSlM/o2pe1qspPVipmElFD8oNbESQrDI9uKLSl7y0bMLuTgoHAAAAAAAAAHik
3MAKlBt4kzXfYKfSu7NybAl15kaM5dHKrFn6/xb9rDM3ULmfc40nlkf69kh+UD0pZc+ETmUiT/W9
OpKJEkqpNFN1dYL54BllvnTU9BfZttEzuSZvv1laobQVYaahaAszUaqkZvctORTH8kQoOYyHsi9E
XfbjvnlsSrbKJ6fS8ZNazYZs1Pbn2V27vu4YyEHclo3SCuWtCCEbkU7Mf60HKmXmRA3ksdlHwhSi
H5r5EB7TUOZd+qpYoaNvTkw8K93059l2R3Z1h/llaV62gpFtRfefpJE1rHvAn1lCfOmfTy/08r2Y
zcUzN7bxpUg2nvTP+ezjGizbn2eb9c2P+JokSWiuO5ZXyLain56/P/bWrH7dYS53JcwpuET+hm0l
zOA2KnpSpTd0lw3PRXodeG6FfCt/fv46CRuP5b6KqazRlR17ZucHfNawGUk+CdYuzo52G7WBPLs4
4O2gl/Vn28m2ki61/J7rs/uWHOgBqDUb5rqmjlnDZsh+Vnu6grLfNmoDeXY+zPVlL4q62VNnb1Wx
FfMcRfHpeqWve66nw1z8I/lDXLR/xKJ9Ob5sXekztH95c9m/mmVNr+9Vea1UEc2zr0yj9Zc+1X+7
TZK7+Y/wKLYixOFdMvb3gQfLKDfwFoP19uZrvasnTgtO/t3755mR7yd7b6UfXYhxEvocuQEAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAADg1/AflF7EibFPkosAAAAASUVORK5CYII=
------=_Part_201_2076558996.1711656746760--