District Level Report Rajkot

Author

Ayush Patel

Published

August 23, 2022

Introduction - Rajkot

This report aims to provide a birds eye view of the district through the lens of village amenities data released by census in 2011. Before moving towards the descriptive insights from the census data, here is what pops up when a search is executed for Rajkot district Gujarat on wikipedia.



Summary Statistics

Total Number of Villages: 835

Total Number of Gram Panchayat: 730

Total Number of Sub Districts: 14

Total Population : 1.590508^{6}

Statistical Summaries at the subdistrict level

Sub District Total Population Total SC Population Total ST Population Total Area of Vilalges Total Area Sown (Net)
Dhoraji 70351 9749 367 41506.09 34676.29
Gondal 173353 18727 363 112005.07 88959.09
Jamkandorna 78130 9601 679 56029.23 40860.80
Jasdan 265641 14126 581 128214.35 87659.13
Jetpur 119023 11349 399 59531.44 46335.88
Kotda Sangani 62059 7433 361 41918.79 27873.70
Lodhika 56744 10396 372 36899.04 25347.29
Maliya 62728 2904 46 70890.57 48877.36
Morvi 146350 13850 1852 99826.80 72634.49
Paddhari 64234 6916 581 58322.06 40501.19
Rajkot 137307 12769 673 87863.64 56787.90
Tankara 87577 7804 734 66770.57 48328.21
Upleta 100733 14696 681 64839.27 48093.00
Wankaner 166278 7659 718 109027.24 57305.17

Population and Geographical Area

It is of interest to look into which are the most densely populated villages. We can do this by creating a simple scatter plot between population of village and the total geographical area of a village.


Irrigation for Agriculture

The census provides the net area sown (hectares) in a village along with area irrigated with water source in hectares. The area under irrigation may be affected by several factors.

Area Sown vs Area under Irrigation


A distribution for the percentage of area irrigated will be interesting to look at.

Understanding what drives area under irrigation

Much is heard about rain fed agriculture in India. There are several factors that can affect area under irrigation - ranging from government supports, demographics, distance from urban clusters and several known and unknown variables. With the given data we can check if the following variables have any relation with area under irrigation:

  • Percentage of Marginalised group population in village
  • Distance from Major government offices
  • Distance from urban center
  • Total population of a village

A simple Linear regression to see if the above explanation has any merit

Dependent variable:
perc_irrigated_over_net_sown
total_population_of_village 0.0005
(0.0005)
perc_marginalised_pop 0.053
(0.098)
district_head_quarter_distance_in_km 0.068
(0.063)
sub_district_head_quarter_distance_in_km -0.048
(0.151)
nearest_statutory_town_distance_in_km -0.347**
(0.173)
sub_district_nameGondal -13.922**
(5.634)
sub_district_nameJamkandorna -11.939**
(5.456)
sub_district_nameJasdan -14.969***
(5.093)
sub_district_nameJetpur -5.692
(5.211)
sub_district_nameKotda Sangani 1.929
(6.699)
sub_district_nameLodhika -0.707
(7.136)
sub_district_nameMaliya -43.266***
(5.253)
sub_district_nameMorvi -4.368
(4.861)
sub_district_namePaddhari 15.708**
(6.421)
sub_district_nameRajkot -12.335*
(6.862)
sub_district_nameTankara 1.923
(6.346)
sub_district_nameUpleta -4.119
(5.171)
sub_district_nameWankaner 7.003
(5.315)
Constant 44.949***
(7.179)
Observations 829
R2 0.276
Adjusted R2 0.260
Residual Std. Error 21.502 (df = 810)
F Statistic 17.149*** (df = 18; 810)
Note: p<0.1; p<0.05; p<0.01

Model Diagnostic plots

Distribution of Redsiduals


Residuals vs Fitted

Note

This is to serve as a minimal example of creating parameterised reports with .rmd/.qmd files. This document is in no way analytically or statistically rigorous.