I want to measure energy consumption after water is discharged from groundwater, energy consumption after water is distributed from aquifers to end users. Especially in Mediterranean Spain or other Mediterranean tourism areas.
Do you mean energy for storing, lifting and distributing water? e.g. irrigation pumps....
I guess it is very difficult to find those data, both at farm or local level, maybe only some water consortium knows exactly the energy expenditure for water distribution systems. I don not think it is easy to find public data.
Yes, it is quite difficult to find the total required energy consumption to support water supply system in Spain. However, please take a look at this paper for a sort of references. http://www.mdpi.com/2073-4441/7/2/652/water-07-00652.pdf