1 Introduction

Groundwater is an important source of freshwater reserve where billions of habitants solely depend for their diverse utilisation. Groundwater crisis in the recent years has become a global concern as its vulnerability increased with greater frequency and magnitude. One of the prime causes of the shortage of groundwater storage and a decline in water level is climate change together with extensive extraction of groundwater from the shallow aquifer for agriculture, industry and other domestic purpose. Drying up of the river bed leads to poor discharge or infiltration into the sub-surface layer therefore sustaining the river stage, and health is in current need. In recent years, global warming together with climate change has led to the deficit of precipitation and an increase in evapotranspiration through a temperature rise directly influencing the recharge of a region. Variability of precipitation, temperature and evapotranspiration as predicted from various climate change scenarios will affect the aquifers which depend on physical properties of recharge areas [1]. Recharge in the arid and semi-arid regions sometimes changes due to the minimal changes in the precipitation volume [1]. The rise in mean global temperature will have a 30% decrease in groundwater recharge for 4% of the land area and 70% of the decrease in recharge in 1% of the land area globally [2]. Thus, vivid understanding of the impacts of climate change on global hydrological cycle including groundwater should be clear to undertake adaptation strategies [3]. This scenario of groundwater shortage can be termed as groundwater drought. The groundwater drought has an adverse effect on public, agricultural and industrial water supply as well as on groundwater-dependent ecosystem and water bodies [4]. According to Zekter and Everett [5], about 50% of the domestic water, 40% of the industrial supply and 20% of the irrigation supply are mainly sourced from groundwater. Thus, with an increase in the population density, the groundwater recharge as well as level will decrease more in shallow aquifer [6]. Since the twentieth century, the groundwater extraction explosively increased around the world. According to a database of 2010, the groundwater extraction is about 1000 km3/year and the major consumers are from Asia including India, China, Pakistan, Bangladesh and extraction rate has been tripled over the 50 years and still rising [7]. Major parts of the Indian aquifer system are showing a declining trend due to alteration in the pattern of precipitation. The emergence of the modern pumping system and electrification in rural areas has led to the increase in groundwater extraction from 312 km3/year in 1960s to about 743 km3/year in 2000 [8]. Sustainable management of the groundwater resources is now challenging and complex in the areas of climate change and extensive anthropogenic activities; thus, modern tool and decisions are needed to sustain long-term groundwater extraction strategies [9]. Engelenburg et al. [3] applied hydrological modelling to study the projected impact of climate in Veluwe aquifer of the Netherland to observe the effect of extensive groundwater extraction on groundwater-dependent ecosystem nearby. Salem et al. [10] studied the impact of climate change in irrigation cost for a groundwater-dependent region of North-West Bangladesh by using general circulation model and hydrological model based on support vector machine to simulate the groundwater level from meteorological variables. Before the simulation of groundwater level, analysis of present and future trend through evaluation of past data is needed. Sishodia et al. [11] analysed groundwater trend of 23 wells of a crystalline aquifer in semi-arid South India to observe whether the trends are due to physical or non-physical factors. Tiwari el al. [12] employed GRACE satellite data and groundwater level to observe the groundwater storage in Andhra Pradesh and found an overall increase which may be due to inter-annual variability of rainfall. Kumar and Rathnam [13] applied four variations of Mann–Kendal and auto-regressive integrated moving average (ARIMA) for prediction and trend analysis of 40 observational wells of Warangal district and found three wells showing positive trend and another 37 wells showing a negative trend. Positive trends in the groundwater level are a serious concern and need supervision at an early stage. A positive trend means a decrease in groundwater level below surface level and such can be due to poor recharge because of changes in land use and land cover of a particular region. Rapid urbanisation and increase in built-up areas increase the fluctuation of groundwater level due to environmental degradation and concretion of soil surface. Patra et al. [14] applied Normalised Built-up Index and estimated the land use and land cover change to identify the effects of extensive urban sprawl on groundwater recharge. Based on the trend analysis, groundwater level and recharge pattern of wells can be grouped into numerous clusters to manage them specifically. Pathak and Dodamani [15] applied hierarchical clustering method to group the fluctuation level of the wells in the Ghataprabha river basin of India and found that the cluster 1 and cluster 3 wells have high fluctuation due to groundwater drought. Ganapuram et al. [16] conducted a study to identify spatio-temporal groundwater drought and drought-prone regions using Standard Water Level Index and spline interpolation in geographical information system. Bloomfield et al. [17] studied groundwater drought in the chalk aquifer of the UK and found evapotranspiration associated with anthropogenic activities is the prime reason inducing the changing nature of drought. But till date, studies related to groundwater drought are fewer in number, but this situation needs a strategic long-term action plan.

In India, according to Central Ground Water Board (CGWB) report of 2017–2018 [18], the overall stage of groundwater extraction increased from 62 to 63%. The over-exploited regions of India are parts of Punjab, Haryana and Delhi where indiscriminate withdrawal has been observed. According to CGWB, the annual replenishable groundwater resources were 432 billion cubic metres (BCM), net annual groundwater availability is also 393 BCM, and annual groundwater draft is about 249 BCM. According to the report, 60% of the wells in India witnessed a declining trend in water level. Recent drying up of the water bodies due to an increase in the magnitude of the temperature graph in the parts of West Bengal, India, particularly in the districts of Bankura, Puruliya and West Medinapore led to the decline of water level in wells. Agricultural practice here solely depends on the extraction of groundwater through submersible pumping sets from shallow aquiferous system leading to further decline in the water level. Land use and land cover change has also put a significant effect on the recharge pattern over the regions. Theeffects of the south-west monsoon show poor recharge and slow increase in the post-monsoon water level due to poor precipitation consistency. No comprehensive scientific assessment of groundwater wells has been done over the selected river basin under study.

Thus, the objective of the study includes (1) to analyse the groundwater level variability through seasonal (pre-monsoon, monsoon and post-monsoon) trend analysis using nonparametric statistical method of Mann–Kendall test for 20 wells within the study area, (2) to understand the impact of land use and land cover change of each of the well location to visualise the controlling factor for groundwater recharge, (3) application of agglomerated hierarchical cluster analysis (HCA) to group the wells based on fluctuation scenario and lastly (4) to understand the impact of climatological variability on water level or groundwater drought by using the Standard Groundwater Level Index for three seasons from 1996 to 2018. Such studies will incur valuable information and will give a reflection of the groundwater scenario of the basin to the stakeholders and policy makers for sustainable water resources management.

2 Study area

The Shilabati river basin is an important eastern river basin of West Bengal, India, which originates from Chotonagpur Plateau in Puruliya district of West Bengal and flows in a south-easterly direction through the districts of Bankura, West Medinapore, and joins Rupnarayan River at Ghatal block of West Medinapore, West Bengal, India. The river is positioned between 23°32′ N to 23°14′ latitude and 86°40′ E to 87°46′ E longitude (Fig. 1). The elevation of the basin varies from 212 to 4 mean sea level (MSL). The total catchment area is about 3881 km2. The river is divided into eight sub-basins, namely Donai, Tamal, Kubai, Joy Panda, Parang, Purandar, Silai and Betal. The study area falls under semi-arid-to-humid climatic condition and receives an average monthly rainfall of 107 mm which is mainly concentrated in the monsoon season. The main land use and land cover of the region is agriculture and irrigation which are mainly practised using groundwater where extraction occurs through the shallow submersible pumping set. The study area covers three different terrain conditions that is undulating  hard rock terrain at the upper section, lateritic terrain in the middle and the lower section is alluvial in origin. Here, water bodies dry up every year mainly in the summer season during which people depend on the groundwater for various activities and worsen the situation [19] which makes it inevitable to evaluate the groundwater resource available within the region.

Fig. 1
figure 1

Location of the study area

3 Materials and methods

3.1 Date source

In order to fabricate the groundwater resource assessment, groundwater level data of 20 monitoring wells (Fig. 1) have been downloaded from Central Groundwater Board, Government of India, for the period of 22 years (1996–2018) of three different seasons that is pre-monsoon, monsoon and post-monsoon. Gridded monthly rainfall data of TRMM 3B43 (0.25° * 0.25°) have been downloaded for the GESDISC Web site (https://disc.gsfc.nasa.gov/) for the year 1998–2018. Land use and land cover classification maps have been prepared using Landsat images for four different years that are 1989, 2000, 2009 and 2018. The satellite images have been downloaded from UGSC Earth Explorer (https://earthexplorer.usgs.gov/) for path of 139 and row of 44 (Table 1). The locational description based on physical features (Figs. 2, 3, 4, 5, 6, 7 and 8) of each of the 20 wells has also been made given in a tabular format (Table 2). In order to identify the agricultural cropping pattern prevalent in the study area, satellite image of 3 months leading to the cultivation of Rabi (January), Kharif (October) and Zaid (March) has been downloaded from USGS Web site. False Colour Composite of year 1989, 2000, 2009 and 2018 has been prepared, and agricultural land has been extracted for the three different time periods to understand the cropping pattern (Rabi, Kharif and Zaid). The extracted vector of the three images is superimposed to witness the cropping pattern (Fig. 8).

Table 1 Information of data acquired
Fig. 2
figure 2

Digital elevation model

Fig. 3
figure 3

Geology of the study area

Fig. 4
figure 4

Aquifer depth of the study area

Fig. 5
figure 5

Geomorphology of the study area

Fig. 6
figure 6

Soil map of the study area

Fig. 7
figure 7

Slope map of the study area

Fig. 8
figure 8

Cropping pattern of the study area

Table 2 Locational description of wells

3.2 Mann–Kendall Test

Mann–Kendall test is a useful nonparametric statistical analysis to determine spatio-temporal trend within a dataset. The presence of outliers is common within a dataset of extreme events of such a nonparametric Mann–Kendall which is useful as it is based on significance of difference but not on random value [20]. The test has been formulated by Mann–Kendal [21] and is mainly applied while handling environmental time series [22]. In this test, there are two hypotheses: the null hypothesis (Ho) signifies no trend in the data set and the alternative hypothesis (HA) signifies a presence of increasing or decreasing trend within the data set. Here, Mann–Kendall test method has been applied to a long-term (1996–2018) seasonal groundwater level data of pre-monsoon, monsoon and post-monsoon periods for 20 wells to detect statistically significant trend within it. Algorithms used for Mann–Kendall test statistics S, Var and standardised test statistics Z are as follows:

$$S = \mathop \sum \limits_{i = 1}^{n = 1} \mathop \sum \limits_{j = i + 1}^{n} {\text{sig(}}X_{j} - X_{i} )$$
(1)
$${\text{Sgn}}\, (X_{j} { - }X_{i} ) = \left\{ {\begin{array}{*{20}l} { + 1} \hfill & {{\text{if}}\; (X_{j} { - }X_{i} ) { > 0}} \hfill \\ 0 \hfill & {{\text{if}}\; (X_{j} { - }X_{i} )\ge 0} \hfill \\ { - 1} \hfill & {{\text{if}}\; (X_{j} { - }X_{i} ) { > 0}} \hfill \\ \end{array} } \right.$$
(2)
$${\text{Var}}\, ( {\text{S) = 1/8}}\left[ {n(n - 1)(2n + 5) - \sum\limits_{P = 1}^{\alpha } {t_{o} (t_{o} - 1)(2t_{o} + 5)} } \right]$$
(3)
$$Z = \left\{ {\begin{array}{*{20}l} {\frac{S - 1}{{\sqrt {{\text{VAR}}\, ( {\text{S)}}} }}} \hfill & {{\text{If}}\;S > 0} \hfill \\ 0 \hfill & {{\text{If}}\;S = 0} \hfill \\ {\frac{S + 1}{{\sqrt {{\text{VAR}}\, ( {\text{S)}}} }}} \hfill & {{\text{If}}\;S < 0} \hfill \\ \end{array} } \right.$$
(4)

In these equations, Xi and Xj are the time series monitoring data in sequential order, n is the length of the time series, to is the number of the tie in the pth value and m is the numbers of tied variables. V is the variance within the data set if |Z| > Z1−α/2, (Ho) is rejected and a significant trend exists within the data. The positive value of the Z means upward rising, and a negative value means downward trend. Here, the test has been performed at a significance level of 0.05 in XLSTAT software.

3.3 Sen’s slope estimator

The magnitude of the trend has been analysed using the Sen’s slope estimator as developed by Sen [23]. It has been widely applied in numerous hydro-meteorological time series analyses [24]; here, it has been used to observe the groundwater level trend. The algorithm used in the calculation is given in the following

$$T _{i} = \frac{{x_{{i + X_{k} }} }}{j - k}$$
(5)

In this equation, the Xi and Xk represent the values of the data at the time j and k, respectively. Let’s consider

$$Q_{s} = \left\{ {\begin{array}{*{20}l} {T_{{\left( {N + 1} \right)/2}} } \hfill & {N\;{\text{is odd}}} \hfill \\ {1/2\left( {T_{N/2} + T_{{\left( {N + 2} \right)/2 }} } \right)} \hfill & {N\;{\text{is even}}} \hfill \\ \end{array} } \right.$$
(6)

A positive Qs value represents an increasing trend; a negative Qs value represents a decreasing nature of the trend.

3.4 Agglomerated hierarchical clustering

In this study, agglomerated hierarchical clustering (AHC) has been applied to group the wells into the clusters based on the fluctuation pattern with 22-year time period data. It is a method that organises the data according to the hierarchical structures based on proximity matrix [25]. There are two types of hierarchical clustering: one is the agglomerated and another is the divisive method based on how the hierarchical decomposition performed. Here, AHC has been used which is based on the definition of distance between two clusters. Five types of agglomerative techniques are there which include complete linkage, single linkage, average linkage, median linkage and lastly Ward’s linkage method. In this paper, Ward’s method has been applied. The whole procedure has been performed using XLSAT.

3.5 Standard Groundwater Level Index (SGWI)

The Standard Groundwater level Index is similar to that of the Standard Precipitation Index. It is a quantitative technique for the evaluation of groundwater level deficit in various time scales which signifies or reflects the influence of extreme drought event on the water resources scenario. Based on the SGWI number of drought years, signifying groundwater scarcity and its temporal variation can be observed [15]. Here, SGWI has been calculated for each of the 20 wells from 1996 to 2018 and for each season, i.e. pre-monsoon, monsoon and post-monsoon. SGWI has been calculated using the following equation

$$X = \frac{K - M}{\sigma }$$
(7)

where K = value of the respective year, M is the mean of 22 years, and σ is the standard deviation

4 Results and discussion

4.1 Influence of climate variable on groundwater level

Groundwater recharge of a region depends on the precipitation which infiltrates through the soil surface. Association of groundwater and rainfall is better reflected through hydrograph. The groundwater level is highly sensitive towards the changes in the precipitation scenarios. An increase in the rainfall will lead to the increase in the groundwater well and vice versa. Gridded TRMM rainfall data from 1998 to 2018 have been downloaded, and mean groundwater level of three seasons pre-monsoon, monsoon and post-monsoon for the 20 wells has been shown graphically to understand the association between them. All the graphical figures of the 20 wells have been grouped in one (Fig. 9) where the line shows the groundwater level and bar graph shows rainfall.

Fig. 9
figure 9figure 9

Graphical representation of average monthly rainfall and groundwater level (1998–2018)

Rainfall and groundwater level have been shown graphically from year 1998 to 2018 because of the non-availability of data from 1996. The graph shows the spatio-temporal distribution of the two variables. From the graph, it can be seen that when the rainfall is low, groundwater level decreased. From the well location Dhadika, it can be observed that in the recent years from 2009 to 2016, the groundwater level rose upward. In well locations like Ghatal, Ghalkunda, Belsula, Neradeul, Salboni, Brahmajhalur and Badga, groundwater level did not rise up even if the rainfall is high. Such temporal variation will give a preliminary idea of groundwater recharge, whereas it also depends on the land use/land cover characteristics of the region which should be assessed parallelly. Recently, this part of the West Bengal is facing a decline in rainfall particularly in the early monsoonal month of June and middle monsoonal month of August [26]. Dong et al. [27] also witnessed that a number of climatic model-based studies are suggesting a delayed monsoonal onset in the eastern part of tropical Indian Ocean. For this reason, the summer is getting longer and villagers are more focusing on the extraction of sub-surface water rather than surface water resources. To curb such a situation, rainwater harvesting during the wet spells is urgently required.

4.2 Impact of land use and land cover change (LULC) on groundwater level

Land use and land cover controls the groundwater recharge of a region. The utilisation of the soil surface for anthropogenic activities such as settlement and construction of road impedes the surface water infiltration in a region. Conversion of forested land into bare land increases surface run-off and hence decreases recharge. Here, land use and land cover practice around the 20 wells has been analysed for the years 1989, 2000, 2009 and 2018 (Figs. 10, 11, 12 and 13). Classified maps have been prepared using supervised classification. Nine different classes of land use and land cover have been made, and their accuracy assessment has been calculated using Kappa index. The calculated accuracy of years 1989, 2000, 2009 and 2018 is 94%, 96%, 97.2% and 95.2%, respectively. From the analysis of the classified maps, it can be seen that the areas under different LULC classes have been changed over the years (Table 3). One of the predominant LULCs in the river basin is bare land which covered 35.24% in 1989, 24.53% in 2000, 38.76% in 2009 and 33.11% in 2018 among all the other classes. The presence of bare land can be found scattered throughout the regions which indicates poor groundwater recharge, higher peaks of surface run-off and soil erosion that is quite predominant over the basin. Soil erosion also discourages groundwater recharge for this suitable cropping pattern, and crop rotation technique should be adopted for its sustainable management [28]. Percentage of dense forest cover over the region has also decreased from 1989, i.e. from 10.88% of the total area to 4.93% in 2018. This decrease in natural vegetation has far reaching effect on the groundwater potential of the study area. But the percentage of water bodies (like ponds) increased over the study area maybe to irrigate the agricultural land as the rainfall amount decreased. A locational description of the (Table 4) wells has also been done based on the LULC of the four years to identify the LULC class in and around the wells controlling the recharge pattern. Well location at Chandrakona road, Keshpur and Neradual which has been surrounded by agricultural land and fallow land in 1989 changed to settlement in 2018 which implies poor infiltration scenario of the basin. From the census report of 2011 [29], it can also be found that Chandrakona has developed into a town as such concretion increased and groundwater level decreased due to poor recharge. The majority of the well locations have been transformed into bare land where sustainable management, afforestation and artificial recharge are needed to increase the stock of sub-surface water resources.

Fig. 10
figure 10

Land use and land cover map of 1989

Fig. 11
figure 11

Land use and land cover map of 2000

Fig. 12
figure 12

Land use and land cover map of 2009

Fig. 13
figure 13

Land use and land cover map of 2018

Table 3 Areal description of LULC class
Table 4 Locational description of wells based on LULC change from 1989 to 2018

4.3 Spatio-temporal distribution of groundwater level since 1996

To determine the spatio-temporal distribution of groundwater level of each of the wells, data from 1996 to 2018 have been downloaded for three seasons pre-monsoon, monsoon and post-monsoon to calculate the descriptive statistics such as mean, standard deviation, skewness, kurtosis, variance, median, quartile 1, quartile 2, quartile 3 and their inter-quartile range which are discussed in Tables S1, S2 and S3 (Online Resource 1). From the computed Table S1 (Online Resource 1), it can be found that the mean water level of 22 years at pre-monsoon in Chandrakona and B.D. Panchal is 11.813 mbgl (metre below groundwater level) and 12.733 mbgl, respectively, which is quite low. Huge extraction of groundwater for agricultural activities and other domestic purpose may be the prime reason of concern. Standard deviation of the pre-monsoon water level depth is also high where high value is witnessed at Neradual which is 6.405 mbgl. During the monsoon, the mean groundwater level slightly improved which ranges between 2 and 7 mbgl that is mainly due to the effect of recharge through precipitation. During the post-monsoon season, the mean ranges from 1.56 to 8.6 mbgl which also reflects the replenishment of aquifers through infiltration. Most of the values of the pre-monsoon, monsoon and post-monsoon are highly skewed and showing asymmetrical distribution. Five wells of pre-monsoon, five wells of monsoon and four wells of post-monsoon are showing highly skewed values. Inter-quartile range denotes the measure of variability. The inter-quartile range is higher in case of well location at Dhadika, B.D Panchal and Ghatal for monsoon season, Dhadika, Neradeul and Ghatal for pre-monsoon and B.D Panchal and Khirpai for post-monsoon. The computed table will help to understand the variability of the groundwater level. Spatio-temporal distribution of the groundwater level of the three seasons is shown in Figs. 14, 15, 16, 17 and 18. From the distribution, it can be seen that the mid-section of the basin is having lower groundwater level during the post-monsoon season where the development of the settlement can be observed. In other words, most of the depth of the groundwater level is lowered after the offset of the monsoonal season. As the volume of precipitation in the monsoonal months decreased, farmers are utilising groundwater for paddy and vegetable cultivation affecting the sub-surface water stock of drier periods. From the socio-economic survey conducted by the authors also revealed the increased use of submersible pumping system in the recent days due to the poor and irregular water supply from the canals, drying up of the river beds and most of dug wells has become obsolete. More than 50–70 such pumps operate in the villages falling within the basin for agriculture and domestic purposes. On a global scale, this kind of spatio-temporal change analysis is fewer in number because of the lack of groundwater monitoring systems [30] but is needed for sustainable river basin management.

Fig. 14
figure 14

Groundwater level at pre-monsoon, monsoon and post-monsoon 1996

Fig. 15
figure 15

Groundwater level at pre-monsoon, monsoon and post-monsoon 2001

Fig. 16
figure 16

Groundwater level at pre-monsoon, monsoon and post-monsoon 2006

Fig. 17
figure 17

Groundwater level at pre-monsoon, monsoon and post-monsoon 2011

Fig. 18
figure 18

Groundwater level at pre-monsoon, monsoon and post-monsoon 2016

4.4 Groundwater level trend analysis

The asymmetrical distribution as observed from the statistical analysis substantiates the need for the application of the nonparametric trend method to identify the trends in the data sets. The time series data from 1996 to 2018 for the pre-monsoon, monsoon and post-monsoon have been taken under the study. The seasonal variability and groundwater crisis are observed in the study area, which can be due to the following (a) influence of the uneven distribution of precipitation and its deficit in the recent years, (b) conversion of bare land, (c) heavy extraction of groundwater through submersible pumping system for agricultural activities and domestic purpose, (d) extensive sand mining in the river bed hampering the conjunctive system between groundwater and surface water resources. From the field studies, extensive sand mining in various sections of the river has been observed disturbing the interaction of the two most important hydrological systems (Fig. S1 Online Resource 2). At the best of our knowledge, no reference studies have been done till date within the basin using the groundwater level data, whereas reference studies are available related to the soil erosion. Mann–Kendall test statistics have been applied in this paper to witness the trend. In this method, each monitoring well visualises the groundwater dynamics of the adjoining areas and each trend gives an idea of the extent of the fluctuation over the period of time [31]. The method has been executed using XLSTAT software. The trend has been analysed at a significance level of 0.05 or 5% of confidence level. Two hypotheses have been considered: Ho (null hypothesis) denotes the absence of trend and HA denotes the presence of trend within the data set. To understand the magnitude and intensity of the trend, Sen’s slope estimate has also been calculated. The Kendall’s tau, S, VAR, P and slope of each of the wells of three seasons have been given in a tabular format (Table 5). Under pre-monsoon condition, out of the 20 wells, nine wells are showing an increasing trend which means the groundwater level is declining at a higher rate. Higher value of groundwater level indicates greater decline as the level is calculated or measured from surface as zero. During the monsoon, five wells, namely Brahmajhalur, Salboni, Simlapal, Belsula and Garbeta, are showing increasing trend, i.e. groundwater level is declining and others showed no significant trend. In post-monsoon season, increasing trend is observable in 12 wells and one well (Dhadika) is showing a decreasing trend. Groundwater level in post-monsoon period is important as it signifies the quantity of recharge after monsoonal precipitation. Most of the wells showing upward trend are located near the agricultural land as reflected from the LULC analysis where extensive extraction is going on. A field survey is also conducted to inspect the groundwater crisis where most of the inhabitants informed about the extensive withdrawal using higher energy utilisation and at the higher cost. In the summer months, villagers experience drought-like condition particularly in the upstream and the middle section because of poor rainfall and practice single crop cultivation using sub-surface water reducing the sustainability of aquifers. One of the major problems of the study area includes over-abstraction from the aquifers and river and increasing demand of the water by the growing population. Under such situation, this paper contributes in identifying the hotspot areas in terms of water level decline that will help to undertake watershed management techniques likewise.

Table 5 Results of Mann–Kendall test statistics

4.5 Cluster analysis of wells based on their fluctuation scenario

Agglomerated hierarchical cluster (AHC) has been applied to classify the wells according to their fluctuation variability. It is an important statistical tool that determines each case into a separate group or cluster and connects each cluster until one cluster remains [32]. Here, hierarchical clustering based on the Ward’s linkage method has been applied. Fluctuation of the groundwater has been calculated subtracting the pre-monsoon from post-monsoon groundwater level for the period of 22 years. This statistical tool has been applied to observe long-term variability of fluctuation of groundwater level in wells and grouping them which are showing similar trends for sustainable management. Groundwater fluctuation helps in understanding the vulnerability of aquifers in terms of recharge potential controlled by climatological and anthropogenic factors The wells have been grouped into four clusters, and the details of the analysis generated from the software have been given in tabular format (Table 6). The dendrogram (Fig. 19) shows the cluster hierarchy of the wells located in the study area. It has been observed from the spatio-temporal variation in the wells of different clusters (Fig. 20) that 15 wells showed similar fluctuation variation are in cluster 1 where the mean fluctuation ranged between 1.8 and 4.329 m. The second cluster consists of only one well whose mean fluctuation is 6.305 m, and the third cluster and fourth cluster consist of two wells each with mean fluctuation between 4.52–4.01 m and 3.46–2.861, respectively. The fluctuation is higher in clusters 2 and 3. Cluster 3 consists of well location of Chandrakona road, and mean fluctuation is about 6.305 m. The box-and-whisker plot (Fig. 21) gives the indication of fluctuation of each of the wells with their respective variability. The reason for the higher fluctuation at well location Chandrakona road can be due to change in land use and land cover which was mainly surrounded by agricultural land in 1986 and transformed into a built-up area in 2018. Thus, concretion has changed the recharge scenario. Another reason for the increased fluctuation witnessed in the wells is mainly due to the precipitation variability and time taken by the aquifer to replenish as groundwater extraction overdrafts the recharge. According to CGWB published report of West Bengal (2015–2016) [33], 28.30% of the wells in Bankura district, 38.9% of the wells in Puruliya district and 38.6% of the wells in West Medinapore district are having a water table depth of 5–10 m in the month of November. A part of all the three districts falls under the basin area. Such type of cluster analysis is also new in this river basin. Towards efficient planning for sustainable groundwater management, grouping of the wells will help in the adoption of cluster-wise management strategies [34].

Table 6 Details of the cluster analysis as executed from XLSTAT software
Fig. 19
figure 19

Dendrogram of the clusters

Fig. 20
figure 20

Map showing four clusters of well

Fig. 21
figure 21

Box-and-whisker plot of the fluctuation variation in well points

4.6 Identification of groundwater drought years using Standard Groundwater Level Index

One of the natural disasters that result in the loss of life and economic destruction is drought [35]. Nowadays, groundwater crisis has become a global problem. Drought respective of groundwater is a need of concern as it is one of the freshwater reserve and an important source of drinking source for people. Due to climate change, a deficit in precipitation can be reflected in water crisis particularly in groundwater. Analysis of the hydro-geological drought using groundwater level data helps in stabilising all the ecosystem services [36]. Here, groundwater drought has been analysed using Standard Groundwater Level Index (SGWI). SGWI has been calculated for years 1996–2018 of each of the wells for three seasons. It is not possible or feasible to graphically represent the calculated data of each to present SGWI within the manuscript. The identified drought and non-drought year has been given in tabular format (Table 7). In pre-monsoon periods, well locations like Dhadika, Godapaisal, Keshpur, Chandrakona have more drought years, and in monsoon, well locations like Prasadpur, Simlapal, Raskunda have greater drought years, whereas in post-monsoon, Simlapal, Bheduasol, Neradeul have a higher frequency of drought years. The identification of drought years along with the trend analysis will help in micro-watershed conservation served by the water source locations. In 2018 (Fig. 22), the wells located in the lower middle section faced groundwater drought in terms of lowering of the water level. This section of the basin experiences high temperature variations and uneven distribution of rainfall all-round the year. According to Ghosh [37], the chances of extreme drought attack are more prone to the western degraded plateaus comprising parts of Puruliya, Bankura and West Medinapore districts of West Bengal and some parts of Rarh Bengal. Beside the climate anomalies, these wells are mainly located near the settlement centre (Fig. 13) where the current anthropogenic activities are leading to the poor recharge. In a region of rapid urbanisation and scarce surface water, detailed investigation of the effects of land use and land cover on groundwater recharge is needed [38]. Fewer studies have been conducted on the regional as well as global characterisation of the groundwater drought and its regular monitoring [4], and it is also new to this study area.

Table 7 Drought and non-drought years as analysed from Standard Groundwater Level Index
Fig. 22
figure 22

Map showing Standard Groundwater Level Index of 2018 monsoon season

5 Conclusion

The present study provided the results of the groundwater vulnerability in a river basin of West Bengal, India, in the context of climate change and extensive anthropogenic activities. The basin is dominated by agricultural practise, but in the recent years, production has been decreasing because of a deficit in precipitation and decline in the groundwater level. The study has been conducted in Shilabati river basin of West Bengal, India, located at the extension of Chotonagpur Plateau. A number of statistical techniques like descriptive test statistics, Mann–Kendall trend test, cluster analysis and SGWI have been applied to highlight the scenario. The land use and land cover analysis made here showed a decrease in dense forest cover from 10.88% in 1989 to 4.93% in 2018. Such decrease in the forest cover increases bare land and reduces the water holding capacity of soil which increases greater run-off and poor aquifer recharge. The groundwater level trend has also been observed using Mann–Kendall test statistics where 25% of the wells show declining trend in monsoon period, 45% show declining trend in pre-monsoon period and 60% show declining trend in post-monsoon period. Extensive pumping of the sub-surface water and drying of the river beds are the main cause of such decline. From the field-level study, the villagers also informed about the water scarcity in the recent years due to lack of precipitation which eventually led to the decline in groundwater level and drying of surface water bodies and giving a threat to food security. Well location at Chandrakona road has been showing higher fluctuation about 6.305 m which is mainly due to the effect of land use and land cover change and alteration of precipitation dynamics. An increase in the settlement cover here has led to increase in built-up area encouraging overland flow, and replenishment of the aquifer takes longer time. Standard Groundwater Level Index has been calculated to observe the groundwater drought within the study area. Wells located at the populated centres are showing positive values that are greater deviation from the normal depth and are signifying more decline in water level. In 2018, the wells located at the lower middle section mainly faced groundwater drought. Every year this river basin faces extreme meteorological, hydrological and agricultural drought in the month of April and March which sometimes extends to the month of June due to the delayed onset of monsoon. Discharge from the wells does not reach the satisfactory level, and the majority of the wells go dry during the hot and humid summer season [39]. Therefore, a more detailed study to explore the cumulative effects of the trend and pattern of the groundwater quantity and quality is essential. The outcome of the study can be an elementary step to improve the sustainable groundwater management strategy. To mitigate such groundwater problem, managed aquifer recharge (MAR) and aquifer yield testing can be the important solution together with rainwater harvesting techniques. Continuous monitoring of groundwater level and quality is also important to protect and increase the stock of water in the aquifer layers.