Eric Edwards 5 years, 2 months ago

This data contains a stata .dta file and three state .do files. The .do files create the tables and figures from Edwards, E.C. What Lies Beneath? Aquifer Heterogeneity and the Economics of Groundwater Management. 2016. Journal of the Association of Environmental and Resource Economists, vol. 3 no. 2, pp. 453-91. The .dta file contains data linking economic data from the agricultural census to geophysical data
Farm Data
The US Agricultural Census provides the county-level economic data for the empirical work as digitized by Gutmann (2005) and Haines (2010). The agricultural census surveys farmers at approximately five year intervals. Farm value per acre is a measure of market value derived from asking farmers to report the estimated sale value of their farm and buildings. The measures of average farm size and percentage of total farm acres in corn come from the same agricultural census surveys. The dataset is constructed using observations for a 50-year window around the enactment of the GMD Act. County-level data is the smallest spatial aggregation that is currently available for the entirety of this time period. There were 11 agricultural census conducted from 1947-1997, and all variables are observed in each census except farm size, which is not available in 1954. The census is typically conducted every five years, with four years from the first observation, 1950, to 1954; 1974 to 1978; and 1978 to 1982.
Aquifer Data
Physical aquifer data comes from the Kansas Geological Survey (KGS) using data from the United States Geological Survey (USGS). KGS has developed the High Plains Atlas to visually represent this data and uses Public Land Survey System sections (one-square mile) to store the data. The variables of interest to this study are hydraulic conductivity (Cederstrand and Becker 1998); and recharge (Hansen 1991 modified by Kansas Department of Agriculture, Division of Water Resources). Hydrologic data is aggregated to county level by taking the average of each variable for all of the sections for which it is observed in a county.
Other Data
Additional data are compiled to control for land productivity. Soil capability is derived from the Gridded Soil Survey Geographic for Kansas (USDA/NRCS 2012). These data provide a score from 0 to 1 of agricultural suitability, with 1 being the best soil for agriculture. These data are provided as a 10m raster or map with cells of soil types and their suitability scores and averaged for each county by area. Table 2 provides a listing of the variables used in the regressions and the source of the data.