New Colorado site-specific diversions / withdrawals water use data

WSWCWaterDataExchange / MappingStatesDataToWaDE2.0

Manage all code to map and import state's data into WaDE 2.0

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

4 stars 1 forks source link

New Colorado site-specific diversions / withdrawals water use data #293

Closed rwjam closed 3 months ago

rwjam commented 6 months ago

based off this project: https://github.com/WSWCWaterDataExchange/MappingStatesDataToWaDE2.0/issues/60

should use same links to download data. Let's try to connect this timeseries now with the water right IDs.

Also review this issue (maybe new POU shp files to work with): https://github.com/WSWCWaterDataExchange/MappingStatesDataToWaDE2.0/issues/307

rwjam commented 5 months ago

We want to try and tie individual water right record sites to monthly water use site records.

Issue that it looks like CO Rest API service returns the TOTAL USE per site and does not distinguish the amount for each water right in the event that a site has M:M water right records.

For a temp fix, we can just focus on the sites with a single water right record tied to them, and exclude the timeseries records that tie to a site with multiple water rights. This can be done with a bonus script to remove time series records from input files where groupby(AssociatedNativeAllocationIDs) > 1 per site.

using these sites as our base for water right information: link
want to tie this monthly timeseries record: link

Issue that we can't get the API to work. Do we need a new api key? @amabdallah Adel to reach out to CO and ask

amabdallah commented 5 months ago

I looked a bit more into the API token for Colorado. You need to sign in (using your work Gmail) and they generate a new key for you.

rwjam commented 5 months ago

Finished updating https://github.com/WSWCWaterDataExchange/MappingStatesDataToWaDE2.0/commit/b85bee30060a507c551bd887fde9f026cde414c0

rwjam commented 5 months ago

Finished updating https://github.com/WSWCWaterDataExchange/MappingStatesDataToWaDE2.0/commit/b85bee30060a507c551bd887fde9f026cde414c0

rwjam commented 3 months ago

We are missisng this 'bonus' script & any documentation on how this was accomplished. I need to track that down / recreate it by hand if need be. _

This can be done with a bonus script to remove time series records from input files where groupby(AssociatedNativeAllocationIDs) > 1 per site. _

rwjam commented 3 months ago

Actually, it looks like we did not create a bonus script for this, and instead performed this limitation during the initial download of the time series data.