{"@type": "dcat:Dataset", "accessLevel": "public", "contactPoint": {"@type": "vcard:Contact", "fn": "Gholam Shakouri", "hasEmail": "mailto:Gholam.Shakouri@water.ca.gov"}, "description": "Excel Application Tool for Agricultural Water Use Data 1998 - 2005\r\nDepartment of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California.  The 1998 \u2013 2005 agricultural water use data were developed by all 4 DWR\u2019s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using California Ag Water Use model for updating the information in the California Water Plan Updates-2003 & 2009.  Therefore, this current Excel application tool just covers agricultural water use data from the period of 1998 - 2005 water years.   It should also be mentioned that there are 2 other similar Excel application tools that cover 2006 - 2010 and 2011 - 2015 agricultural water use data for the California Water plan Updates - 2013 and 2018, respectively.  Outputs data provided from this Excel  application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs  1998 \u2013 2005 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu.  \r\nFurthermore, throughout the whole process numerous computations and aggregation equations in various worksheets were included in this Excel application.  And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won\u2019t be tampered with or changed/revised. \r\n\r\nFollowing are definitions of terminology and listing of 20 crop categories used in this Excel application.\r\n\r\n1. Study Area Maps\r\nThe California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR),  \r\nThe next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the \r\n smallest study areas used by DWR is DAU/County.  Many planning studies begin at the Dau or PA level, and the results are aggregated into hydrologic regions for presentation.\r\n\r\n2. Irrigated Crop Area (ICA) in acres\r\nThe total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) \r\n\r\n3. Multi-cropping (MC) in acres\r\nA section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field.\r\n\r\n4. Evapotranspiration (ET)\r\nCombination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed.  It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity.\r\n\r\n5. Reference Evapotranspiration (ETo)\r\nReference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988).  \r\n \r\n6. Penman-Monteith Equation (PM)\r\nEquation is used to estimate ETo when daily solar radiation, maximum and minimum air temperature, dew point temperature, and wind speed data are available. It is recommended by both the America Society of Civil Engineers and United Nations FAO for estimating ETo.  \r\n \r\n7. Crop Evapotranspiration (ETc), both in unit value (acre feet per acre), & volume (acre feet)\r\nCommonly known as potential evapotranspiration, which is the amount of water used by plants in transpiration and evaporation of water from adjacent plants and soil surfaces during a specific time period. ETc is computed as the product of reference evapotranspiration (ETo) and a crop coefficient (Kc) value, i.e., ETc = ETo x Kc. One Acre foot equals about 325851 gallons, or enough water to cover an acre of land about the size of a football field, one foot deep.\r\n\r\n8. Crop Coefficient (Kc)\r\nRelates ET of a given crop at a specific time in its growth stage to a reference ET. Incorporates effects of crop growth state, crop density, and other cultural factors affecting ET. The reference condition has been termed \"potential\" and relates to grass. The main sources of Kc information are the FAO 24 (Doorenbos and Pruitt 1977) and FAO 56 (Allen et al. 1988) papers on evapotranspiration. \r\n\r\n9. Effective Precipitation (Ep), both in unit value (acre feet per acre), & volume (acre feet)\r\nFraction of rainfall effectively used by a crop, rather than mobilized as runoff or deep percolation\r\n \r\n10. Evapotranspiration of Applied Water (ETaw), both in unit value (acre feet per acre), & volume (acre feet)\r\nNet amount of irrigation water needed to produce a crop (not including irrigation application efficiency). Soil characteristic data and crop information with precipitation and ETc data are used to generate hypothetical water balance irrigation schedules to determine ETaw. \r\n \r\n11. Applied Water (AW), both in unit value (acre feet per acre), & volume (acre feet)\r\nEstimated as the ETaw divided by the mean seasonal irrigation system application efficiency.\r\n \r\n12. Consumed Fraction (CF) in percentage (%)\r\nAn estimate of how irrigation water is efficiently applied on fields to meet crop water, frost protection, and leaching requirements for a whole season or full year.\r\n\r\n13. Crop category numbers and descriptions\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nCrop Category\t\tCrop category description.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n1\t\tGrain (wheat, wheat_winter, wheat_spring, barley, oats, misc._grain & hay)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n2\t\tRice (rice, rice_wild, rice_flooded, rice-upland)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n3\t\tCotton\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n4\t\tSugar beet (sugar-beet, sugar_beet_late, sugar_beet_early)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n5\t\tCorn\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n6\t\tDry beans\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n7\t\tSafflower\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n8\t\tOther field crops (flax, hops, grain_sorghum, sudan,castor-beans, misc._field, sunflower, sorghum/sudan_hybrid, millet, sugarcane\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n9\t\tAlfalfa (alfalfa, alfalfa_mixtures, alfalfa_cut, alfalfa_annual)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n10\t\tPasture (pasture, clover, pasture_mixed, pasture_native, misc._grasses, turf_farm, pasture_bermuda, pasture_rye, klein_grass, pasture_fescue)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n11\t\tTomato processing (tomato_processing, tomato_processing_drip, tomato_processing_sfc)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n12\t\tTomato fresh (tomato_fresh, tomato_fresh_drip, tomato_fresh_sfc)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n13\t\tCucurbits (cucurbits, melons, squash, cucumbers, cucumbers_fresh_market, cucumbers_machine-harvest, watermelon)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n14\t\tOnion & garlic (onion & garlic, onions, onions_dry, onions_green, garlic)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n15\t\tPotatoes (potatoes, potatoes_sweet)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n16\t\tTruck_Crops_misc (artichokes, truck_crops, asparagus, beans_green, carrots, celery, lettuce, peas, spinach, bus h_berries, strawberries, peppers, broccoli, cabbage, cauliflower)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n17\t\tAlmond & pistachios\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n18\t\tOther Deciduous (apples, apricots, walnuts, cherries, peaches, nectarines, pears, plums, prunes, figs, kiwis)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n19\t\tCitrus & subtropical (grapefruit, lemons, oranges, dates, avocados, olives, jojoba)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n20\t\tVineyards (grape_table, grape_raisin, grape_wine)", "distribution": [{"@type": "dcat:Distribution", "description": "Agricultural Water Use Data 1998-2005 zipped", "downloadURL": "https://data.cnra.ca.gov/dataset/bd87a165-5861-4281-bd56-caccd8219a4f/resource/95410a17-5717-4eca-bb61-3815001cfde9/download/agricultural-water-use-data1998_2005.zip", "format": ".zip", "mediaType": "application/octet-stream", "title": "Agricultural Water Use Data 1998-2005 zipped"}], "identifier": "d246264c-1696-43e3-83af-3cc251bbf2f0", "issued": "2024-02-07T19:41:25.064301", "keyword": ["California", "california department of water resources"], "modified": "2024-08-05T18:14:42.650067", "publisher": {"@type": "org:Organization", "name": "California Department of Water Resources"}, "theme": ["Natural Resources", "Water"], "title": "Agricultural Water Use Data 1998-2005"}