EMSC3025 Assignment 3 – 2022 Depth-to-groundwater data are available on Wattle (in csv format) for the following sites from the NSW real time data website https://realtimedata.waternsw.com.au/: Location Site Code Latitude Longitude Toganmain GW036275 -34.67366381 145.62335066 Amberdell GW036582 -35.81162421 144.83094756 Barratta GW036871 -35.27369 144.53366 Howlong GW273166 -35.9753313 146.6173406 Wagga Wagga GW273167 -35.10069265 147.36927431 Narranderra GW040956 -34.69664 146.34222 Jerilderie GW036211 -35.06580143 145.3797645 McLellons Bore Rd GW403747 -35.02931202 145.59362677 Forbes GW036597 -33.7657 147.4806 Roeta Rd GW036284 -33.35378083 145.03003542 i) Load the depth-to-groundwater data (see Pandas csv tutorial for help) ii) (5 marks) Calculate the groundwater change at each of the sites from a combination of satellite data and soil moisture modelling data i.e. Δ Groundwater = Δ TWS – Δ soil moisture iii) (5 marks) Plot the time series of depth to groundwater level and groundwater calculated in ii) for each well site using two different y-scales on the same plot (hint: matplotlib twinx) iv) (3 marks) Calculate the effective porosity at each location i.e. Δ depth-to-groundwater ′ porosity = Δ Groundwater v) (5 marks) Produce a spatial map of effective porosity over the region (i.e. interpolate between the discrete data points), include the Murray-Darling Basin and well site locations on your map vi) (2 marks) Comment on your results and the limitations of this study Include your python notebook and any text files created during the assignment in your submission.
