State-wise Data Of First Census Of Water Bodies
Water Bodies Census in India: Mapping Aquatic Resources Nationwide
@kaggle.khushipitroda_state_wise_data_of_first_census_of_water_bodies
Water Bodies Census in India: Mapping Aquatic Resources Nationwide
@kaggle.khushipitroda_state_wise_data_of_first_census_of_water_bodies
CREATE TABLE wbc_sk (
"rural_or_urban" VARCHAR,
"state_name" VARCHAR,
"district_name" VARCHAR,
"block_tehsil_name" VARCHAR,
"village_name" VARCHAR,
"town_municipalty_name" VARCHAR,
"ward_name" VARCHAR,
"si_no_of_water_body_within_village_town" BIGINT,
"unique_id" VARCHAR,
"water_body_name" VARCHAR,
"basin_name" VARCHAR,
"sub_basin_name" VARCHAR,
"ref_water_body_type_id_name" VARCHAR,
"nature_of_storage" VARCHAR,
"khasra_number" VARCHAR,
"water_body_loc_name" VARCHAR,
"water_body_ownership_name" VARCHAR,
"ref_water_body_in_use_id_name" VARCHAR,
"ref_reason_water_body_in_use_id1_name" VARCHAR,
"cca_water_body" DOUBLE,
"ipc_water_body" DOUBLE,
"scheme_status_reason_name" VARCHAR,
"water_body_nature_name" VARCHAR,
"manmade_water_body_type_name" VARCHAR,
"construcion_year" DOUBLE,
"construction_cost" DOUBLE,
"renovation_year" DOUBLE,
"renovation_cost" DOUBLE,
"ref_water_body_under_repair_renovation_restoration_id_name" VARCHAR,
"scheme_under_revival_is_done" VARCHAR,
"scheme_inclusion_year" DOUBLE,
"targeted_completion_year" DOUBLE,
"estimated_cost" DOUBLE,
"target_potential_revival" DOUBLE,
"irrigation_potential_revived" DOUBLE,
"water_spread_area_of_water_body" DOUBLE,
"max_depth_water_body_fully_filled" DOUBLE,
"storage_capacity_water_body_original" DOUBLE,
"storage_capacity_water_body_present" DOUBLE,
"filled_up_storage_name" VARCHAR,
"filled_up_storage_space_name" VARCHAR,
"no_town_cities_benefited" DOUBLE,
"no_villages_benefited" DOUBLE,
"no_people_benefited_by_water_body" DOUBLE,
"ref_selection_id_wua_exists_name" VARCHAR,
"extent_of_area_covered_by_wua" DOUBLE,
"number_of_wua_formed" DOUBLE,
"ref_selection_id_dip_sip_exists_name" VARCHAR,
"ref_selection_id_water_body_encroached_name" VARCHAR,
"ref_selection_id_encroachment_assessed_name" VARCHAR,
"area_encroached_percentage" DOUBLE,
"reason_water_body_in_use_name2" VARCHAR,
"reason_water_body_in_use_name3" VARCHAR
);
Anyone who has the link will be able to view this.