search

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

KS water use data #38

Open amabdallah opened 4 years ago

amabdallah commented 4 years ago

Read this page and scroll down to Kansas Water Use Publications

Download the Support Files for both irrigation and municipal https://agriculture.ks.gov/divisions-programs/dwr/water-appropriation/water-use-reporting

Fact sheet (HTTP 404 The resource cannot be found) https://agriculture.ks.gov/docs/default-source/dwr-water-appropriation-documents/waterusedatacollection-2015b0d5d4002e6262e1aa5bff0000620720.pdf?sfvrsn=61b7b6c1_14

rwjam commented 3 years ago

Links at the bottom of KS webpage contain water use per year, separated by Irrigation Summary Reports and Municipal Summary Reports. Data available for 2010 - 2014 (pending 2015-2017).

However, each link does not follow the same delivery format. Some are given via repository, others in tabular csv files, others PDF document. Will take a little work to dig through each year and format all the available data into a single workable format.

"May" be multiple ReportingunitTypes. Keep an eye out for 1) Counties, 2) Irrigation Water-Use Analysis Regions, & 3) Regional Planning Areas (see Irrigation Water Use 2014 for example.

rwjam commented 3 years ago

Irrigation water use for 2013 data all comes in one spreadsheet. Could take crop type and irr sys type headings from 2014 and translate them into the 2013 data.

"Might" be able to use the PDF documents. Not an easy copy-paste. Will have to transform PDF -to- Table, but its not perfect and will require each table to be fixed and altered (roughly 10 tables per year per Irrigation / Municipal use)

rwjam commented 2 years ago

We need to ask KS for the following info...