Global Human Settlement Layer Dataset
@owid.ghsl_degree_of_urbanisation
@owid.ghsl_degree_of_urbanisation
This dataset provides a comprehensive classification of urbanization levels for administrative regions worldwide, using the Global ADMinistrative layer version 4.1 (GADM4.1) as the source of administrative units. The classification is derived from the application of the Degree of Urbanisation model's Stage II, which evaluates each unit based on urbanization criteria. It utilizes the Global Human Settlement Layer (GHSL) data, specifically the Settlement Classification (GHS-SMOD_GLOBE_R2023A) that categorizes areas as urban, suburban, or rural, and the Population Grid (GHS-POP_GLOBE_R2023A) that provides detailed population information.
The dataset encompasses an Excel table summarizing global and country-level statistics, along with 72 CSV files. These files are organized according to various administrative division levels (from GADM levels 0 to 5) and cover different time periods from 1975 to 2030, offering a detailed view of urbanization classification for each administrative unit.
CREATE TABLE owid_ghsl_degree_of_urbanisation_1 (
"country" VARCHAR,
"year" INTEGER,
"average_area_km2_estimates" FLOAT,
"degurba_l1_population_city_estimates" FLOAT,
"degurba_l1_population_rural_area_estimates" FLOAT,
"degurba_l1_population_town_and_suburbs_estimates" FLOAT -- Degurba L1 Population Town, And, Suburbs Estimates,
"degurba_l1_units_city_estimates" FLOAT,
"degurba_l1_units_rural_area_estimates" FLOAT,
"degurba_l1_units_town_and_suburbs_estimates" FLOAT -- Degurba L1 Units Town, And, Suburbs Estimates,
"degurba_l2_population_city_estimates" FLOAT,
"degurba_l2_population_dense_town_estimates" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_estimates" FLOAT,
"degurba_l2_population_rural_dispersed_area_estimates" FLOAT,
"degurba_l2_population_semi_dense_town_estimates" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_estimates" FLOAT,
"degurba_l2_population_village_estimates" FLOAT,
"degurba_l2_units_city_estimates" FLOAT,
"degurba_l2_units_dense_town_estimates" FLOAT,
"degurba_l2_units_mostly_uninhabited_area_estimates" FLOAT,
"degurba_l2_units_rural_dispersed_area_estimates" FLOAT,
"degurba_l2_units_semi_dense_town_estimates" FLOAT,
"degurba_l2_units_suburbs_or_peri_urban_area_estimates" FLOAT,
"degurba_l2_units_village_estimates" FLOAT,
"total_area_km2_estimates" FLOAT,
"total_pop_estimates" FLOAT,
"total_units_estimates" FLOAT,
"share_of_urban_population_owid_estimates" FLOAT,
"degurba_l1_population_city_share_estimates" FLOAT,
"degurba_l1_population_rural_area_share_estimates" FLOAT,
"degurba_l1_population_town_and_suburbs_share_estimates" FLOAT -- Degurba L1 Population Town, And, Suburbs Share Estimates,
"degurba_l2_population_city_share_estimates" FLOAT,
"degurba_l2_population_dense_town_share_estimates" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_share_estimates" FLOAT,
"degurba_l2_population_rural_dispersed_area_share_estimates" FLOAT,
"degurba_l2_population_semi_dense_town_share_estimates" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_share_d833babb" FLOAT -- Degurba L2 Population Suburbs Or Peri Urban Area Share Estimates,
"degurba_l2_population_village_share_estimates" FLOAT,
"average_area_km2_projections" FLOAT,
"degurba_l1_population_city_projections" FLOAT,
"degurba_l1_population_rural_area_projections" FLOAT,
"degurba_l1_population_town_and_suburbs_projections" FLOAT -- Degurba L1 Population Town, And, Suburbs Projections,
"degurba_l1_units_city_projections" FLOAT,
"degurba_l1_units_rural_area_projections" FLOAT,
"degurba_l1_units_town_and_suburbs_projections" FLOAT -- Degurba L1 Units Town, And, Suburbs Projections,
"degurba_l2_population_city_projections" FLOAT,
"degurba_l2_population_dense_town_projections" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_projections" FLOAT,
"degurba_l2_population_rural_dispersed_area_projections" FLOAT,
"degurba_l2_population_semi_dense_town_projections" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_projections" FLOAT,
"degurba_l2_population_village_projections" FLOAT,
"degurba_l2_units_city_projections" FLOAT,
"degurba_l2_units_dense_town_projections" FLOAT,
"degurba_l2_units_mostly_uninhabited_area_projections" FLOAT,
"degurba_l2_units_rural_dispersed_area_projections" FLOAT,
"degurba_l2_units_semi_dense_town_projections" FLOAT,
"degurba_l2_units_suburbs_or_peri_urban_area_projections" FLOAT,
"degurba_l2_units_village_projections" FLOAT,
"total_area_km2_projections" FLOAT,
"total_pop_projections" FLOAT,
"total_units_projections" FLOAT,
"share_of_urban_population_owid_projections" FLOAT,
"degurba_l1_population_city_share_projections" FLOAT,
"degurba_l1_population_rural_area_share_projections" FLOAT,
"degurba_l1_population_town_and_suburbs_share_projections" FLOAT -- Degurba L1 Population Town, And, Suburbs Share Projections,
"degurba_l2_population_city_share_projections" FLOAT,
"degurba_l2_population_dense_town_share_projections" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_share_projections" FLOAT,
"degurba_l2_population_rural_dispersed_area_share_projections" FLOAT,
"degurba_l2_population_semi_dense_town_share_projections" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_share_9915f9a5" FLOAT -- Degurba L2 Population Suburbs Or Peri Urban Area Share Projections,
"degurba_l2_population_village_share_projections" FLOAT
);CREATE TABLE owid_ghsl_degree_of_urbanisation_2 (
"country" VARCHAR,
"year" INTEGER,
"location_type" VARCHAR,
"attribute" VARCHAR,
"type" VARCHAR,
"value" FLOAT
);Anyone who has the link will be able to view this.