Prepare a query of all agriculture Irrigation water rights in WestDAAT and aggregate them to HUC12

[amabdallah]

~680K water rights

We need one big flat table similar to the Analytics table but also to include the primary water source type and the centroid of all site coordinates. Then let's try to aggregate each amount into a total for each HUC12.

https://westdaat.westernstateswater.org/?state=N4IgtghgDiBcoC8D2SwBkCmA3DAbOArAHQEDsAbAMwAcALAEyWUCM9tAnKZQDQi4QAXAJYCArgBMMcSuxLt2zcr1xIAdgHMREqbAC0zAAzUipevTIBfXgHcATnFAAjDKowAzIQGMhEXAFUAZwwAOQgwDAC4AG0QAEF1Wy9RXDFbDAACAElbRPVBITUQAF1eIQDg3HEhADEhFIxbWM9hHDg3XyCLCyA