Data engineering application to develop a comprehensive hydro-climatological database for the High Plains region

dc.contributor.committeeChairUddameri, Venkatesh
dc.contributor.committeeMemberHernandez Uddameri, Annette
dc.creatorKafle, Aalok Sharma
dc.creator.orcid0000-0001-6599-0517 2021
dc.description.abstractOgallala Aquifer, underlying the High Plains Region of the US, provides thirty percent of all United States’ irrigation demand and supports one-sixth of the world’s total grain production. The aquifer, however, is rapidly depleting due to the over-utilization of this resource. Prolonging the useful life of aquifer requires analysis of future water use scenarios with solution strategies guided by scientific modeling procedures. Any model is the result of its underlying data and making a informed decision during data compilation helps avoid issues in the future. To facilitate hydrological modeling, it is beneficial to have a comprehensive, multi-scale, multi-resolution and, scalable dataset with historical data of the region’s climatic and meteorological parameters. This thesis outlines the design and preparation of a comprehensive relational database that archives hydrometeorological data of use in hydrological modeling. The tasks performed here, include, but are not limited to, the methods used to extract data from individual sources, imputation of missing data, arrangement of data in a homogeneous format, storing it in relational database format and estimation of parameters that are not readily available. Data were extracted from primary and secondary data sources, ensuring required quality of the data and maintaining the parameters' temporal continuity over 39 years (1981 – 2019) across all sources and stations. Kalman filtering was used for imputation of the missing data. The developed database with thirteen different hydro-climatological parameters contains a total of 1.46 billion data points with 58.4 million records. As a second objective, gridded (interpolated) data from two popular sources - Daymet and PRISM were compared with primary data(USHCN Daily Data) for estimating a suite of metrics relevant to hydro-agricultural applications. While these secondary datasets were able to capture the trend of parameters, they did not accurately estimate the values of the parameters.
dc.description.abstractEmbargo status: Restricted until 06/2022. To request the author grant access, click on the PDF link to the left.
dc.rights.availabilityRestricted until June 2022.
dc.subjectOgallala Aquifer
dc.subjectHigh Plains
dc.subjectStation and Gridded Datasets
dc.titleData engineering application to develop a comprehensive hydro-climatological database for the High Plains region
local.embargo.terms2022-05-01 and Environmental Engineering Engineering Tech University of Science in Civil Engineering
Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
4.64 MB
Adobe Portable Document Format
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
1.85 KB
Plain Text