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

WSWCWaterDataExchange / WestDAAT

Managing the code of the Western States Water Data Access and Analysis Tool (WestDAAT)

https://westdaat.westernstateswater.org/

BSD 3-Clause "New" or "Revised" License

5 stars 4 forks source link

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

Open amabdallah opened 9 months ago

amabdallah commented 9 months ago

~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