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.