Dataset: Indian Census Data With Geospatial Indexing

About this Dataset

Indian Census Data With Geospatial Indexing

Dataset Description:

This dataset has population data of each Indian district from 2001 and 2011 censuses.
The special thing about this data is that it has centroids for each district and state.
Centroids for a district are calculated by mapping border of each district as a polygon of latitude/longitude points in a 2D plane and then calculating their mean center.
Centroids for a state are calculated by calculating the weighted mean center of all districts that constitutes a state. The population count is the weight assigned to each district.

Example Analysis:

The complete code for calculating the centroids and web scraping for the data is shared on GitHub.
The purpose of this project was to map population density center for each state.
You can also read about the complete project here: https://medium.com/@sumit.arora/plotting-weighted-mean-population-centroids-on-a-country-map-22da408c1397

Output Screenshots:
Indian districts mapped as polygons

Mapping centroids for each district

Mean centers of population by state, 2001 vs. 2011

National center of population

Tables

District Wise Centroids

@kaggle.sirpunch_indian_census_data_with_geospatial_indexing.district_wise_centroids

20.64 KB
594 rows
4 columns


CREATE TABLE district_wise_centroids (
  "state" VARCHAR,
  "district" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

District Wise Population And Centroids

@kaggle.sirpunch_indian_census_data_with_geospatial_indexing.district_wise_population_and_centroids

22.35 KB
431 rows
6 columns


CREATE TABLE district_wise_population_and_centroids (
  "state" VARCHAR,
  "district" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "population_in_2001" BIGINT,
  "population_in_2011" BIGINT
);

District Wise Population For Year 2001 And 2011

@kaggle.sirpunch_indian_census_data_with_geospatial_indexing.district_wise_population_for_year_2001_and_2011

19.09 KB
640 rows
4 columns


CREATE TABLE district_wise_population_for_year_2001_and_2011 (
  "state" VARCHAR,
  "district" VARCHAR,
  "population_in_2001" BIGINT,
  "population_in_2011" BIGINT
);

State Wise Centroids 2001

@kaggle.sirpunch_indian_census_data_with_geospatial_indexing.state_wise_centroids_2001

3.79 KB
35 rows
3 columns


CREATE TABLE state_wise_centroids_2001 (
  "state" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);

State Wise Centroids 2011

@kaggle.sirpunch_indian_census_data_with_geospatial_indexing.state_wise_centroids_2011

3.79 KB
35 rows
3 columns


CREATE TABLE state_wise_centroids_2011 (
  "state" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);