Saturday, January 27, 2024

Newspaper Graph Series

Newspaper Graph series

Newspaper Graphs series

Journalism is a profession which requires lot of story telling using graphs. Here I am going to re-create graphs published in newspapers. Today I have taken Indian express and tried to recreate some of the graphs. First let’s see the graphs as published in the newspaper:

Recreation in R using ggplot2 and friends packages

I am going to try my hand first with left-hand side graph. It seems many people like barplots but ofcourse they are straight-forward and very informative.

#install libraries 

library(tidyverse)

# Create datasets
States <- c("Gujarat", "Maharashtra", "Karnatka", "Rajasthan", "Kerala", 
            "Haryana", "Tamil Nadu", "Telangana", "Punjab", "MP")
rooftopSolar = c(2898.16, 1716.3, 1562.11, 1002.44, 512.67, 486.23, 
                 449.22, 343.78, 298.92, 296.02)

roofTopSolCap = tibble(Sates = States,
                       `Rooftop solar` = rooftopSolar)

# See there are two kinds of numeric labels one is in white colour the other one is # in black so let's create two variables to be used to separate them.
roofTopSolCap <- roofTopSolCap |> 
  mutate(gujLabel = case_when(
    States == "Gujarat" ~ 2898.16,
    .default = NULL
  )) |> 
  mutate(restLabel = case_when(
    States == "Gujarat" ~ NA,
    .default = `Rooftop solar`
  ))


# Make a bar plot

roofs <- roofTopSolCap |> 
  ggplot(aes(x = reorder(States, `Rooftop solar`), y = `Rooftop solar`))+
  geom_col(fill = '#83b315') +
  geom_text(aes(label = scales::comma(gujLabel, accuracy = 0.01)), 
            position = position_dodge(0.2),
            hjust = 1.2, # inside the bar
            colour = 'white',
            size = 4
  ) +
  geom_text(aes(label = scales::comma(restLabel, accuracy = 0.01)), 
            position = position_dodge(0.2),
            hjust = -0.08, # outside the bar
            colour = 'black',
            size = 4
  )+
  labs(x = "",
       y = "", 
       title = "TOP 10 STATES WITH HIGHEST \nROOFTOP SOLAR CAPACITY",
       caption = 'As on 31.12.2023 \n Numerical values are in MW') +
  coord_flip() +
  theme(
    panel.grid.major.y = element_blank(),
    panel.grid.major.x = element_blank(),
    panel.background = element_rect(fill = 'white'),
    axis.ticks = element_blank(),
  ) +
  geom_vline(xintercept = c(0.5,1.5, 2.5,3.5,4.5,5.5,6.5,7.5,8.5,9.5,10.5), colour = 'black')+ # vlines between the states
  geom_hline(yintercept = c(0), colour = 'black')+ #set a onset line for bars - usually used in BBC reporting.
  scale_y_continuous(labels = NULL)
roofs

Ok this is an attempt but still the red inked labelling is not there which I think not worth the effort. Now, let’s deal with the other graph:

#Let's create the data first

Years <- c("Before Mar'14*", "2014-15", "2015-16", 
           "2016-17", "2017-18", "2018-19", "2019-20",
           "2020-21", "2021-22", "2022-23", "2023-24**")
solPowCap <- c(2821.91, 1171.62, 3130.36, 5658.63,
               9563.69, 6750, 6510.06, 5628.8, 12760.5,
               12783.8, 6539.12)
Years <- factor(Years, levels =  c("Before Mar'14*", "2014-15", "2015-16", "2016-17", "2017-18", "2018-19", "2019-20", "2020-21", "2021-22", "2022-23", "2023-24**"))
solPowerCap <- tibble(
  Years = Years,
  solPowCap = solPowCap
) # ok the data is now ready

# create bar chart

solPow <- solPowerCap |> 
  ggplot(aes(x = Years, y = solPowCap)) +
  geom_col(fill = "#86b2d6") +
  geom_text(aes(label = scales::comma(solPowCap, accuracy = 0.01)), 
            position = position_dodge(0.2),
            hjust = -0.08, # outside the bar
            colour = 'black',
            size = 4,
            angle = 90)+
  labs(x = "",
       y = "", 
       title = "YEAR WISE INSTALLED \nSOLAR POWER CAPACITY",
       caption = "*Total \n **TillDec'2023 \nSource: Ministry of New and Renewable Energy") +
  theme(panel.grid.major.y = element_blank(),
    panel.grid.major.x = element_blank(),
    panel.background = element_rect(fill = 'white'),
    axis.ticks = element_blank(),
    axis.text.x = element_text(angle = 90, vjust = 0.5, hjust=1)
    ) + geom_hline(yintercept = 0) +  
  ylim(c(0, 23000)) 
  solPow

I don’t know what software they use but a powerful library of a freeware can also produce good plots.

Friday, March 25, 2022

Sabalgarh

To conduct a field survey I was required to go to Sabalgarh, a small town, 70km from Morena town, of Morena district in Madhya Pradesh. It was quite different from the fast life of Delhi and was a pleasant break from it :-). My good friend, Amit Bansal is from this town, so I stayed with his family. They have a very nice house and an electronics item shop by the name Janhit Enterprises (If you happen to visit there and buy something, I can get you some good discount ;-)). 

Janhit Enterprises and its very friendly owner: Manish Bansal.


I was surprised to see the lifestyle of people there, if you want to have a glimpse of how people lived in medieval India, you should visit rural areas of Sabalgarh. Almost every person has a tika/tilak on his forehead. All men over 50 wear dhoti and keep moustache. I was surprised because I have not seen people wearing dhoti since I was five and even then I could count them. The rural folks, still, are highly religious, their lives revolves around religion. Big gatherings happen on religious events. An even I witnessed was a community lunch and the menu was sugarless rice pudding (kheer), guldana (sweet bundi/or just a sweet) and potato curry (alloo ki sabji) and that's it! no puri, roti or anything. It was very funny but eat sabji alone with your fingers and if you find it too spicy start eating kheer and guldana together. The combination of sugarless kheer and very sweet guldana, I only found in this region. It was revealed later that a new temple was built and it was inaugurated by reciting Bhagwat Geeta. Though it was crowded but it was a pleasant experience including the taste of food!

A Bhandara (community lunch) near Atar village in Sabalgarh Tehsil

I then went on to see the Chambal river, there is a ghat (river bank), near a village called Rahoo so it is know as Rahoo ka ghat. It was a tumultous journey to the ghat but the scene was breathtaking and very soothing. Few people were catching fish and I took bath in the cold water of Chambal (I do not recommend the bath, it is treacherous and can be fatal). Geomorphologically, there were potholes and worth a notice (see in the video below). It was amazing! All in all, sabalgarh is a small town with its indigenous way of life and my journey to this town was memorable. In a sentence it was worth it!

Rahoo ka ghat




Wednesday, August 4, 2021

River linking and related concerns in India

India, with its vast length and breadth, manifests multifarious diversity in terms of people, land, animals, customs, traditions, history, water. It is this diversity that made various famous people made comment on it, to name a few Pt. Nehru said India has unity in diversity and very famous "Kos kos par badle paani char kos par bani" meaning that at every kos (ca. 200 meters) taste of water changes and at every four kos language also changes.  Geographically, this cannot be more true, India is notorious for its floods and droughts at the same time. Some regions have plenty of water (ground as well as surface) e.g. W.Bengal, Haryana, Punjab, Western UP etc. while others face chronic water shortage e.g. Bundelkhand, Rayalseema regions etc. Further, monsoon in India is also spatially as well as temporally varies i.e. approx. 75% of the total precipitation occurs in four monsoon months (June - September) and the remaining 25% occurs in rest of the 8 months. Further, the country faces high spatial variability of precipitation with a distinct pattern of distribution from east to the west (as in fig. 1).  As apparent from the fig.1 eastern and north eastern India experiences high rainfall while the western India has low rainfall. The water situation due to above explained reasons, water distribution in India is highly varied. This leads to flood situations in some parts of the country while other face drought creating a situation of water-surplus river basins and water-deficient river basins.

Distribution of Rainfall in India.

Challenges to India's Development:

1. India's population is increased and slated to be world's most populous country. It is expected to be stabilized at around 1640 million. Consequently, water availability per capita is bound to decline from 1820 m2/yr in 2001 to 1140 m2/yr in 2050. Further, additional water usage such as industry, agriculture, institutions etc will also increase. To some estimates, India's water availability is to be increased by 3 times. 

2. India's energy demand has been spiraling along with the economic development. India's energy demand is slated to increase by 2.5 times which require eco-friendly energy resources such as solar, hydro-electric power, nuclear power etc.

3. Monsoon dependent India needs water storage per person to deal with non-monsoon water shortages.

4. Water is a contentious issue in India, the infamous Cauveri river water distribution tussle between Karnataka, Tamil Nadu and Kerala needs no explanation. The issue is that every region (inter-state or intra-state) wants water but reluctant to share the water resources with other states. Since, India has over 60% of population in agriculture, irrigation water will remain a potent political issue.

It is in this background Inter-linking of rivers (ILR) has been proposed and re-proposed.

History of ILR:

Proposed By

Photo

Year

Features

Present Status

Sir Arthur Cotton

 


1839

He conceived a plan to link rivers in Southern India for inland navigation. While the project was partially implemented,

·         The river linking canals could not survive in the face of rapid development

Dr. K.L. Rao

 


1972

·         Linking the northern Ganga River with the southern Couvery River

·         Required lifting of water over 450 m

·         Envisaged to supply water to drought prone areas of south UP and South Bihar

·         Discarded because of high financial cost and very large energy requirement

Captain D.J. Dashtur

 


1977

·         Proposed the Himalayan and Garland canals to be inter-connected at two points (Delhi and Patna) by five pipelines of 3.7m in diameter

·         Surplus waters in the country to be utilized to irrigate 219 Mha of agriculture land

·         Found to be technically infeasible

National Water Development Authority (NDWA)

 


1980-2000

·         Two components were identified 

1) Himalayan River component (14 river linking) and 

2) Peninsular River component (16 river linking).        

·         Work is going on Ken-Betwa project.

The table is modified from Mirza, M., Ahmed A U (2006)

Issues related to ILR:

1. Other Inter Basin Transfer projects.

It has been claimed that adverse environmental impacts of IBT projects outweigh their beneficial impacts.

2. Food and Irrigation

Despite the expansion of irrigation over the years, availability of chemical fertilizers, introduction of high yield varieties, India's crop yield per hectare remains lower than other countries in the region e.g. wheat yield in China is 40 % more than what India produces. Further, China grows one kilo rice in 300-400 lts of water whereas India uses 4000 lts of water to grow same quantity of rice. So without adding more water to the agriculture it is still possible to increase crop yield. This argument opposes the need of more water for the crops. Further, flood irrigation has been widely criticized for tropical and subtropical areas and has adverse impacts on soil as well as ground water conditions.

3. Hydrological situation:

The whole ILR project is based upon the concept of transferring water from areas of surplus to areas of deficit. However, this concept was contested by the fact that every drop of water in a river perform some function and thus there is no surplus water even in chronic flooding rivers. Flood water is seen as the source of free minerals for the land, free recharge for the groundwater resources, free medium for the growth and transportation of fish and conversation of biological diversity, free bumper harvest for humans etc. Further, at the micro level, the flood flows flush the silt from the riverbeds in the plains to the delta areas free of cost. Flushing of water to sea support the rich fisheries in the estuaries and keep away the saline incursion from the sea. Transferring water from a "surplus" area takes away the multi-ecological services, the flood water does. The idea of surplus water is considered as reductionist approach. Therefore, to keep the ecological services water should not be transferred.

4. Risk and ILR as a system:

This argument is one of the most powerful. The ILR is a system, whereby one component receives water from another component e.g. Peninsular component is planned to receive water from Himalayan component. If a link is become non-functional or not constructed; the other parts might not work as efficiently as has been thought or planned. Thus, this can risk the whole system of ILR. 

5. Flood and Drought mitigation

Ganga River has been identified as a "surplus basin". Now, lets see how Ganga varies in its flow. Ganga's peak discharge is 55,415 cubic meters per second (cumecs) at Farakka during the four monsoon months, a 100 m wide 10 m deep canal can divert at most 2,000 cumecs to provide 4 % relief. For the rest of 8 months (non-monsoon), Ganga flows at 5,280 cumecs and diversion of 2,000 cumecs will deny Bihar 38 %  of Ganga water when it is needed the most. Alternatively, using a canal only for 4 months would be economically a non-sense. Thus notion of flood mitigation seems flawed. 

6. Health Concerns

Dams and reservoirs are evidenced to cause favourable conditions for the growth of various disease causing vectors. When long canals transport water from one location to multiple locations they also carry disease causing vectors. Since the water is a medium of growth for these vectors, an likely disease outbreak, an epidemic can occur. Diseases such as malaria, guinea worm, river blindness and multiple diarrhoel diseases are common diseases related to water projects. Further, fertilizers in the canal water, water effluents, pesticides, hazardous chemicals can jeopardize environment as well as public health.

7. Social and Ecological impacts

Big water are know to displace people and wildlife attributed to submerged area behind dams. Since 1950, big dam projects have displaced 40 million people. This causes heightened social tensions in both rural and urban India. Narmada bachao is one of the most popular movement against the dams on Narmada river. More such movements might rise up if the people perceives the issue threatening their security of livelihood and shelter.

8. Economic costs

The ILR project is the largest inter-basin water transfer ever taken in the world. The estimated cost of the entire project is in the range of $ 200 billion; by any estimate the cost is huge! One argument is that if one component of the ILR fails, the probability of failure of other parts or the whole is huge, threatening the survival of whole ILR project. In such a scenario, debt of $200 billion is too huge to forget and can have serious political, social and economical consequences.

The above issue might show the ILR project in bad light but these issues must be considered and discussed at lengths to make ILR a success.  

Conclusion:

The ideas and arguments discussed above were taken from the book "Interlinking of Rivers in India: Issues and concerns". However, the issue is not a simple one and India has to grow and to achieve sustainable development goals #1 End poverty, #2 Zero hunger #6 clean water and sanitation #7 affordable and clean energy, India needs to distribute its water resources spatially and remove the temporal barrier to its access. There are a number of anti-ILR views, majority of them recommend for a more ecological friendly approach i.e. water-shed development, switching to less water intensive crops etc. The benefit of these alternative approaches is that they are well distributed, can be built using bottom-up approach. More on this will be addressed in another blog.


Bibliography:

“Interlinking of Rivers in India: Issues and Concerns.” Routledge & CRC Press, https://www.routledge.com/Interlinking-of-Rivers-in-India-Issues-and-Concerns/Mirza-Ahmed-Ahmad/p/book/9780415404693. Accessed 4 Aug. 2021.