This dataset is about cities in South Africa. It has 198 rows. It features 7 columns including country, population, latitude, and longitude.

South Africa ZA: Population in Largest City data was reported at 9,822,625.000 Person in 2017. This records an increase from the previous number of 9,615,976.000 Person for 2016. South Africa ZA: Population in Largest City data is updated yearly, averaging 3,628,124.500 Person from Dec 1960 (Median) to 2017, with 58 observations. The data reached an all-time high of 9,822,625.000 Person in 2017 and a record low of 2,136,849.000 Person in 1960. South Africa ZA: Population in Largest City data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s South Africa – Table ZA.World Bank: Population and Urbanization Statistics. Population in largest city is the urban population living in the country's largest metropolitan area.; ; United Nations, World Urbanization Prospects.; ;

About this dataset

Context

The dataset presents the median household incomes over the past decade across various racial categories identified by the U.S. Census Bureau in South Gorin. It portrays the median household income of the head of household across racial categories (excluding ethnicity) as identified by the Census Bureau. It also showcases the annual income trends, between 2011 and 2021, providing insights into the economic shifts within diverse racial communities.The dataset can be utilized to gain insights into income disparities and variations across racial categories, aiding in data analysis and decision-making..

Key observations

• White: In South Gorin, the median household income for the households where the householder is White decreased by $3,706(9.07%), between 2011 and 2021. The median household income, in 2022 inflation-adjusted dollars, was $40,862 in 2011 and $37,156 in 2021.
• Black or African American: As per the U.S. Census Bureau population data, in South Gorin, there are no households where the householder is Black or African American; hence, the median household income for the Black or African American population is not applicable.
• Refer to the research insights for more key observations on American Indian and Alaska Native, Asian, Native Hawaiian and Other Pacific Islander, Some other race and Two or more races (multiracial) households

https://i.neilsberg.com/ch/south-gorin-mo-median-household-income-by-race-trends.jpeg" alt="South Gorin, MO median household income trends across races (2011-2021, in 2022 inflation-adjusted dollars)">

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2017-2021 5-Year Estimates.

Racial categories include:

• White
• Black or African American
• American Indian and Alaska Native
• Asian
• Native Hawaiian and Other Pacific Islander
• Some other race
• Two or more races (multiracial)

Variables / Data Columns

• Race of the head of household: This column presents the self-identified race of the household head, encompassing all relevant racial categories (excluding ethnicity) applicable in South Gorin.
• 2010: 2010 median household income
• 2011: 2011 median household income
• 2012: 2012 median household income
• 2013: 2013 median household income
• 2014: 2014 median household income
• 2015: 2015 median household income
• 2016: 2016 median household income
• 2017: 2017 median household income
• 2018: 2018 median household income
• 2019: 2019 median household income
• 2020: 2020 median household income
• 2021: 2021 median household income
• 2022: 2022 median household income
• Please note: 2020 1-Year ACS estimates data was not reported by Census Bureau due to impact on survey collection and analysis during COVID-19, thus for large cities (population 65,000 and above) median household income data is not available.
• Please note: All incomes have been adjusted for inflation and are presented in 2022-inflation-adjusted dollars.

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for South Gorin median household income by race. You can refer the same here

South Africa ZA: Population in Largest City: as % of Urban Population data was reported at 26.327 % in 2017. This records an increase from the previous number of 26.291 % for 2016. South Africa ZA: Population in Largest City: as % of Urban Population data is updated yearly, averaging 23.218 % from Dec 1960 (Median) to 2017, with 58 observations. The data reached an all-time high of 26.327 % in 2017 and a record low of 18.806 % in 1991. South Africa ZA: Population in Largest City: as % of Urban Population data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s South Africa – Table ZA.World Bank: Population and Urbanization Statistics. Population in largest city is the percentage of a country's urban population living in that country's largest metropolitan area.; ; United Nations, World Urbanization Prospects.; Weighted Average;

This geodatabase reflects the U.S. Geological Survey’s (USGS) ongoing commitment to its mission of understanding the nature and distribution of global mineral commodity supply chains by updating and publishing the georeferenced locations of mineral commodity production and processing facilities, mineral exploration and development sites, and mineral commodity exporting ports in Africa. The geodatabase and geospatial data layers serve to create a new geographic information product in the form of a geospatial portable document format (PDF) map. The geodatabase contains data layers from USGS, foreign governmental, and open-source sources as follows: (1) mineral production and processing facilities, (2) mineral exploration and development sites, (3) mineral occurrence sites and deposits, (4) undiscovered mineral resource tracts for Gabon and Mauritania, (5) undiscovered mineral resource tracts for potash, platinum-group elements, and copper, (6) coal occurrence areas, (7) electric power generating facilities, (8) electric power transmission lines, (9) liquefied natural gas terminals, (10) oil and gas pipelines, (11) undiscovered, technically recoverable conventional and continuous hydrocarbon resources (by USGS geologic/petroleum province), (12) cumulative production, and recoverable conventional resources (by oil- and gas-producing nation), (13) major mineral exporting maritime ports, (14) railroads, (15) major roads, (16) major cities, (17) major lakes, (18) major river systems, (19) first-level administrative division (ADM1) boundaries for all countries in Africa, and (20) international boundaries for all countries in Africa.

The Gauteng-City Region Observatory (GCRO) commissioned Data World to conduct its Second Quality of Life Survey, with surveys being conducted in second half of 2011. The Gauteng City-Region Observatory (GCRO) was established in 2008 as a partnership between the University of Johannesburg (UJ), the University of the Witwatersrand, Johannesburg (Wits) and the Gauteng Provincial Government (GPG), with local government in Gauteng also represented. The objective of the GCRO is to inform and assist the various spheres of the Gauteng government in building and maintaining the province as an integrated and globally competitive region. The Second Quality of Life Survey must comprehensively represent the whole of Gauteng, which consists of 10 municipalities, which in turn covers 508 wards. Data World was contracted to undertake 15000 surveys across this sphere. Among the main aims of the Quality of Life Survey, is to inform the GCRO as well as provincial government and other relevant parties with regards to the perceived states of the municipalities within Gauteng, with focus on the quality of the lives of people who live within these municipalities.

Abstract

The Human Sciences Research Council (HSRC) carried out the Migration and Remittances Survey in South Africa for the World Bank in collaboration with the African Development Bank. The primary mandate of the HSRC in this project was to come up with a migration database that includes both immigrants and emigrants. The specific activities included: · A household survey with a view of producing a detailed demographic/economic database of immigrants, emigrants and non migrants · The collation and preparation of a data set based on the survey · The production of basic primary statistics for the analysis of migration and remittance behaviour in South Africa.

Like many other African countries, South Africa lacks reliable census or other data on migrants (immigrants and emigrants), and on flows of resources that accompanies movement of people. This is so because a large proportion of African immigrants are in the country undocumented. A special effort was therefore made to design a household survey that would cover sufficient numbers and proportions of immigrants, and still conform to the principles of probability sampling. The approach that was followed gives a representative picture of migration in 2 provinces, Limpopo and Gauteng, which should be reflective of migration behaviour and its impacts in South Africa.

Geographic coverage

Two provinces: Gauteng and Limpopo

Limpopo is the main corridor for migration from African countries to the north of South Africa while Gauteng is the main port of entry as it has the largest airport in Africa. Gauteng is a destination for internal and international migrants because it has three large metropolitan cities with a great economic potential and reputation for offering employment, accommodations and access to many different opportunities within a distance of 56 km. These two provinces therefore were expected to accommodate most African migrants in South Africa, co-existing with a large host population.

Analysis unit

• Household
• Individual

Universe

The target group consists of households in all communities. The survey will be conducted among metro and non-metro households. Non-metro households include those in: - small towns, - secondary cities, - peri-urban settlements and - deep rural areas. From each selected household, one adult respondent will be selected to participate in the study.

Kind of data

Sample survey data [ssd]

Sampling procedure

Migration data for South Africa are available for 2007 only at the level of local governments or municipalities from the 2007 Census; for smaller areas called "sub places" (SPs) only as recently as the 2001 census, and for the desired EAs only back so far as the Census of 1996. In sum, there was no single source that provided recent data on the five types of migrants of principal interest at the level of the Enumeration Area, which was the area for which data were needed to draw the sample since it was going to be necessary to identify migrant and non-migrant households in the sample areas in order to oversample those with migrants for interview.

In an attempt to overcome the data limitations referred to above, it was necessary to adopt a novel approach to the design of the sample for the World Bank's household migration survey in South Africa, to identify EAs with a high probability of finding immigrants and those with a low probability. This required the combined use of the three sources of data described above. The starting point was the CS 2007 survey, which provided data on migration at a local government level, classifying each local government cluster in terms of migration level, taking into account the types of migrants identified. The researchers then spatially zoomed in from these clusters to the so-called sub-places (SPs) from the 2001 Census to classifying SP clusters by migration level. Finally, the 1996 Census data were used to zoom in even further down to the EA level, using the 1996 census data on migration levels of various typed, to identify the final level of clusters for the survey, namely the spatially small EAs (each typically containing about 200 households, and hence amenable to the listing operation in the field).

A higher score or weight was attached to the 2007 Community Survey municipality-level (MN) data than to the Census 2001 sub-place (SP) data, which in turn was given a greater weight than the 1996 enumerator area (EA) data. The latter was derived exclusively from the Census 1996 EA data, but has then been reallocated to the 2001 EAs proportional to geographical size. Although these weights are purely arbitrary since it was composed from different sources, they give an indication of the relevant importance attached to the different migrant categories. These weighted migrant proportions (secondary strata), therefore constituted the second level of clusters for sampling purposes.

In addition, a system of weighting or scoring the different persons by migrant type was applied to ensure that the likelihood of finding migrants would be optimised. As part of this procedure, recent migrants (who had migrated in the preceding five years) received a higher score than lifetime migrants (who had not migrated during the preceding five years). Similarly, a higher score was attached to international immigrants (both recent and lifetime, who had come to SA from abroad) than to internal migrants (who had only moved within SA's borders). A greater weight also applied to inter-provincial (internal) than to intra-provincial migrants (who only moved within the same South African province).

How the three data sources were combined to provide overall scores for EA can be briefly described. First, in each of the two provinces, all local government units were given migration scores according to the numbers or relative proportions of the population classified in the various categories of migrants (with non-migrants given a score of 1.0. Migrants were assigned higher scores according to their priority, with international migrants given higher scores than internal migrants and recent migrants higher scores than lifetime migrants. Then within the local governments, sub-places were assigned scores assigned on the basis of inter vs. intra-provincial migrants using the 2001 census data. Each SP area in a local government was thus assigned a value which was the product of its local government score (the same for all SPs in the local government) and its own SP score. The third and final stage was to develop relative migration scores for all the EAs from the 1996 census by similarly weighting the proportions of migrants (and non-migrants, assigned always 1.0) of each type. The the final migration score for an EA is the product of its own EA score from 1996, the SP score of which it is a part (assigned to all the EAs within the SP), and the local government score from the 2007 survey.

Based on all the above principles the set of weights or scores was developed.

In sum, we multiplied the proportion of populations of each migrant type, or their incidence, by the appropriate final corresponding EA scores for persons of each type in the EA (based on multiplying the three weights together), to obtain the overall score for each EA. This takes into account the distribution of persons in the EA according to migration status in 1996, the SP score of the EA in 2001, and the local government score (in which the EA is located) from 2007. Finally, all EAs in each province were then classified into quartiles, prior to sampling from the quartiles.

From the EAs so classified, the sampling took the form of selecting EAs, i.e., primary sampling units (PSUs, which in this case are also Ultimate Sampling Units, since this is a single stage sample), according to their classification into quartiles. The proportions selected from each quartile are based on the range of EA-level scores which are assumed to reflect weighted probabilities of finding desired migrants in each EA. To enhance the likelihood of finding migrants, much higher proportions of EAs were selected into the sample from the quartiles with the higher scores compared to the lower scores (disproportionate sampling). The decision on the most appropriate categorisations was informed by the observed migration levels in the two provinces of the study area during 2007, 2001 and 1996, analysed at the lowest spatial level for which migration data was available in each case.

Because of the differences in their characteristics it was decided that the provinces of Gauteng and Limpopo should each be regarded as an explicit stratum for sampling purposes. These two provinces therefore represented the primary explicit strata. It was decided to select an equal number of EAs from these two primary strata.

The migration-level categories referred to above were treated as secondary explicit strata to ensure optimal coverage of each in the sample. The distribution of migration levels was then used to draw EAs in such a way that greater preference could be given to areas with higher proportions of migrants in general, but especially immigrants (note the relative scores assigned to each type of person above). The proportion of EAs selected into the sample from the quartiles draws upon the relative mean weighted migrant scores (referred to as proportions) found below the table, but this is a coincidence and not necessary, as any disproportionate sampling of EAs from the quartiles could be done, since it would be rectified in the weighting at the end for the analysis.

The resultant proportions of migrants then led to the following proportional allocation of sampled EAs (Quartile 1: 5 per cent (instead of 25% as in an equal distribution), Quartile 2: 15 per cent (instead

The “richness index” represents the level of economical wellbeing a country certain area in 2010. Regions with higher income per capita and low poverty rate and more access to market are wealthier and are therefore better able to prepare for and respond to adversity. The index results from the second cluster of the Principal Component Analysis preformed among 9 potential variables. The analysis identifies four dominant variables, namely “GDPppp per capita”, “agriculture share GDP per agriculture sector worker”, “poverty rate” and “market accessibility”, assigning weights of 0.33, 0.26, 0.25 and 0.16, respectively. Before to perform the analysis all variables were log transformed (except the “agriculture share GDP per agriculture sector worker”) to shorten the extreme variation and then were score-standardized (converted to distribution with average of 0 and standard deviation of 1; inverse method was applied for the “poverty rate” and “market accessibility”) in order to be comparable. The 0.5 arc-minute grid total GDPppp is based on the night time light satellite imagery of NOAA (see Ghosh, T., Powell, R., Elvidge, C. D., Baugh, K. E., Sutton, P. C., & Anderson, S. (2010).Shedding light on the global distribution of economic activity. The Open Geography Journal (3), 148-161) and adjusted to national total as recorded by International Monetary Fund for 2010. The “GDPppp per capita” was calculated dividing the total GDPppp by the population in each pixel. Further, a focal statistic ran to determine mean values within 10 km. This had a smoothing effect and represents some of the extended influence of intense economic activity for the local people. Country based data for “agriculture share GDP per agriculture sector worker” were calculated from GDPppp (data from International Monetary Fund) fraction from agriculture activity (measured by World Bank) divided by the number of worker in the agriculture sector (data from World Bank). The tabular data represents the average of the period 2008-2012 and were linked by country unit to the national boundaries shapefile (FAO/GAUL) and then converted into raster format (resolution 0.5 arc-minute). The first administrative level data for the “poverty rate” were estimated by NOAA for 2003 using nighttime lights satellite imagery. Tabular data were linked by first administrative unit to the first administrative boundaries shapefile (FAO/GAUL) and then converted into raster format (resolution 0.5 arc-minute). The 0.5 arc-minute grid “market accessibility” measures the travel distance in minutes to large cities (with population greater than 50,000 people). This dataset was developed by the European Commission and the World Bank to represent access to markets, schools, hospitals, etc.. The dataset capture the connectivity and the concentration of economic activity (in 2000). Markets may be important for a variety of reasons, including their abilities to spread risk and increase incomes. Markets are a means of linking people both spatially and over time. That is, they allow shocks (and risks) to be spread over wider areas. In particular, markets should make households less vulnerable to (localized) covariate shocks. This dataset has been produced in the framework of the “Climate change predictions in Sub-Saharan Africa: impacts and adaptations (ClimAfrica)” project, Work Package 4 (WP4). More information on ClimAfrica project is provided in the Supplemental Information section of this metadata.

Data publication: 2014-05-15

Supplemental Information:

ClimAfrica was an international project funded by European Commission under the 7th Framework Programme (FP7) for the period 2010-2014. The ClimAfrica consortium was formed by 18 institutions, 9 from Europe, 8 from Africa, and the Food and Agriculture Organization of United Nations (FAO).

ClimAfrica was conceived to respond to the urgent international need for the most appropriate and up-to-date tools and methodologies to better understand and predict climate change, assess its impact on African ecosystems and population, and develop the correct adaptation strategies. Africa is probably the most vulnerable continent to climate change and climate variability and shows diverse range of agro-ecological and geographical features. Thus the impacts of climate change can be very high and can greatly differ across the continent, and even within countries.

The project focused on the following specific objectives:

1. Develop improved climate predictions on seasonal to decadal climatic scales, especially relevant to SSA;

2. Assess climate impacts in key sectors of SSA livelihood and economy, especially water resources and agriculture;

3. Evaluate the vulnerability of ecosystems and civil population to inter-annual variations and longer trends (10 years) in climate;

4. Suggest and analyse new suited adaptation strategies, focused on local needs;

5. Develop a new concept of 10 years monitoring and forecasting warning system, useful for food security, risk management and civil protection in SSA;

6. Analyse the economic impacts of climate change on agriculture and water resources in SSA and the cost-effectiveness of potential adaptation measures.

The work of ClimAfrica project was broken down into the following work packages (WPs) closely connected. All the activities described in WP1, WP2, WP3, WP4, WP5 consider the domain of the entire South Sahara Africa region. Only WP6 has a country specific (watershed) spatial scale where models validation and detailed processes analysis are carried out.

Contact points:

Metadata Contact: FAO-Data

Resource Contact: Selvaraju Ramasamy

Resource constraints:

copyright

Online resources:

Richness index (2010)

Project deliverable D4.1 - Scenarios of major production systems in Africa

Climafrica Website - Climate Change Predictions In Sub-Saharan Africa: Impacts And Adaptations

Abstract (en): The Research on Early Life and Aging Trends and Effects (RELATE) study compiles cross-national data that contain information that can be used to examine the effects of early life conditions on older adult health conditions, including heart disease, diabetes, obesity, functionality, mortality, and self-reported health. The complete cross sectional/longitudinal dataset (n=147,278) was compiled from major studies of older adults or households across the world that in most instances are representative of the older adult population either nationally, in major urban centers, or in provinces. It includes over 180 variables with information on demographic and geographic variables along with information about early life conditions and life course events for older adults in low, middle and high income countries. Selected variables were harmonized to facilitate cross national comparisons. In this first public release of the RELATE data, a subset of the data (n=88,273) is being released. The subset includes harmonized data of older adults from the following regions of the world: Africa (Ghana and South Africa), Asia (China, India), Latin America (Costa Rica, major cities in Latin America), and the United States (Puerto Rico, Wisconsin). This first release of the data collection is composed of 19 downloadable parts: Part 1 includes the harmonized cross-national RELATE dataset, which harmonizes data from parts 2 through 19. Specifically, parts 2 through 19 include data from Costa Rica (Part 2), Puerto Rico (Part 3), the United States (Wisconsin) (Part 4), Argentina (Part 5), Barbados (Part 6), Brazil (Part 7), Chile (Part 8), Cuba (Part 9), Mexico (Parts 10 and 15), Uruguay (Part 11), China (Parts 12, 18, and 19), Ghana (Part 13), India (Part 14), Russia (Part 16), and South Africa (Part 17). The Health and Retirement Study (HRS) was also used in the compilation of the larger RELATE data set (HRS) (N=12,527), and these data are now available for public release on the HRS data products page. To access the HRS data that are part of the RELATE data set, please see the collection notes below. The purpose of this study was to compile and harmonize cross-national data from both the developing and developed world to allow for the examination of how early life conditions are related to older adult health and well being. The selection of countries for this study was based on their diversity but also on the availability of comprehensive cross sectional/panel survey data for older adults born in the early to mid 20th century in low, middle and high income countries. These data were then utilized to create the harmonized cross-national RELATE data (Part 1). Specifically, data that are being released in this version of the RELATE study come from the following studies: CHNS (China Health and Nutrition Study) CLHLS (Chinese Longitudinal Healthy Longevity Survey) CRELES (Costa Rican Study of Longevity and Healthy Aging) PREHCO (Puerto Rican Elderly: Health Conditions) SABE (Study of Aging Survey on Health and Well Being of Elders) SAGE (WHO Study on Global Ageing and Adult Health) WLS (Wisconsin Longitudinal Study) Note that the countries selected represent a diverse range in national income levels: Barbados and the United States (including Puerto Rico) represent high income countries; Argentina, Cuba, Uruguay, Chile, Costa Rica, Brazil, Mexico, and Russia represent upper middle income countries; China and India represent lower middle income countries; and Ghana represents a low income country. Users should refer to the technical report that accompanies the RELATE data for more detailed information regarding the study design of the surveys used in the construction of the cross-national data. The Research on Early Life and Aging Trends and Effects (RELATE) data includes an array of variables, including basic demographic variables (age, gender, education), variables relating to early life conditions (height, knee height, rural/urban birthplace, childhood health, childhood socioeconomic status), adult socioeconomic status (income, wealth), adult lifestyle (smoking, drinking, exercising, diet), and health outcomes (self-reported health, chronic conditions, difficulty with functionality, obesity, mortality). Not all countries have the same variables. Please refer to the technical report that is part of the documentation for more detail regarding the variables available across countries. Sample weights are applicable to all countries exc...

Large go-around, also referred to as missed approach, data set. The data set is in support of the paper presented at the OpenSky Symposium on November the 10th.

If you use this data for a scientific publication, please consider citing our paper.

The data set contains landings from 176 (mostly) large airports from 44 different countries. The landings are labelled as performing a go-around (GA) or not. In total, the data set contains almost 9 million landings with more than 33000 GAs. The data was collected from OpenSky Network's historical data base for the year 2019. The published data set contains multiple files:

go_arounds_minimal.csv.gz

Compressed CSV containing the minimal data set. It contains a row for each landing and a minimal amount of information about the landing, and if it was a GA. The data is structured in the following way:

    Column name
    Type
    Description




    time
    date time
    UTC time of landing or first GA attempt


    icao24
    string
    Unique 24-bit (hexadecimal number) ICAO identifier of the aircraft concerned


    callsign
    string
    Aircraft identifier in air-ground communications


    airport
    string
    ICAO airport code where the aircraft is landing


    runway
    string
    Runway designator on which the aircraft landed


    has_ga
    string
    "True" if at least one GA was performed, otherwise "False"


    n_approaches
    integer
    Number of approaches identified for this flight


    n_rwy_approached
    integer
    Number of unique runways approached by this flight

The last two columns, n_approaches and n_rwy_approached, are useful to filter out training and calibration flight. These have usually a large number of n_approaches, so an easy way to exclude them is to filter by n_approaches > 2.

go_arounds_augmented.csv.gz

Compressed CSV containing the augmented data set. It contains a row for each landing and additional information about the landing, and if it was a GA. The data is structured in the following way:

    Column name
    Type
    Description




    time
    date time
    UTC time of landing or first GA attempt


    icao24
    string
    Unique 24-bit (hexadecimal number) ICAO identifier of the aircraft concerned


    callsign
    string
    Aircraft identifier in air-ground communications


    airport
    string
    ICAO airport code where the aircraft is landing


    runway
    string
    Runway designator on which the aircraft landed


    has_ga
    string
    "True" if at least one GA was performed, otherwise "False"


    n_approaches
    integer
    Number of approaches identified for this flight


    n_rwy_approached
    integer
    Number of unique runways approached by this flight


    registration
    string
    Aircraft registration


    typecode
    string
    Aircraft ICAO typecode


    icaoaircrafttype
    string
    ICAO aircraft type


    wtc
    string
    ICAO wake turbulence category


    glide_slope_angle
    float
    Angle of the ILS glide slope in degrees


    has_intersection

string

    Boolean that is true if the runway has an other runway intersecting it, otherwise false


    rwy_length
    float
    Length of the runway in kilometre


    airport_country
    string
    ISO Alpha-3 country code of the airport


    airport_region
    string
    Geographical region of the airport (either Europe, North America, South America, Asia, Africa, or Oceania)


    operator_country
    string
    ISO Alpha-3 country code of the operator


    operator_region
    string
    Geographical region of the operator of the aircraft (either Europe, North America, South America, Asia, Africa, or Oceania)


    wind_speed_knts
    integer
    METAR, surface wind speed in knots


    wind_dir_deg
    integer
    METAR, surface wind direction in degrees


    wind_gust_knts
    integer
    METAR, surface wind gust speed in knots


    visibility_m
    float
    METAR, visibility in m


    temperature_deg
    integer
    METAR, temperature in degrees Celsius


    press_sea_level_p
    float
    METAR, sea level pressure in hPa


    press_p
    float
    METAR, QNH in hPA


    weather_intensity
    list
    METAR, list of present weather codes: qualifier - intensity


    weather_precipitation
    list
    METAR, list of present weather codes: weather phenomena - precipitation


    weather_desc
    list
    METAR, list of present weather codes: qualifier - descriptor


    weather_obscuration
    list
    METAR, list of present weather codes: weather phenomena - obscuration


    weather_other
    list
    METAR, list of present weather codes: weather phenomena - other

This data set is augmented with data from various public data sources. Aircraft related data is mostly from the OpenSky Network's aircraft data base, the METAR information is from the Iowa State University, and the rest is mostly scraped from different web sites. If you need help with the METAR information, you can consult the WMO's Aerodrom Reports and Forecasts handbook.

go_arounds_agg.csv.gz

Compressed CSV containing the aggregated data set. It contains a row for each airport-runway, i.e. every runway at every airport for which data is available. The data is structured in the following way:

    Column name
    Type
    Description




    airport
    string
    ICAO airport code where the aircraft is landing


    runway
    string
    Runway designator on which the aircraft landed


    n_landings
    integer
    Total number of landings observed on this runway in 2019


    ga_rate
    float
    Go-around rate, per 1000 landings


    glide_slope_angle
    float
    Angle of the ILS glide slope in degrees


    has_intersection
    string
    Boolean that is true if the runway has an other runway intersecting it, otherwise false


    rwy_length
    float
    Length of the runway in kilometres


    airport_country
    string
    ISO Alpha-3 country code of the airport


    airport_region
    string
    Geographical region of the airport (either Europe, North America, South America, Asia, Africa, or Oceania)

This aggregated data set is used in the paper for the generalized linear regression model.

Downloading the trajectories

Users of this data set with access to OpenSky Network's Impala shell can download the historical trajectories from the historical data base with a few lines of Python code. For example, you want to get all the go-arounds of the 4th of January 2019 at London City Airport (EGLC). You can use the Traffic library for easy access to the database:

import datetime from tqdm.auto import tqdm import pandas as pd from traffic.data import opensky from traffic.core import Traffic

load minimum data set

df = pd.read_csv("go_arounds_minimal.csv.gz", low_memory=False) df["time"] = pd.to_datetime(df["time"])

select London City Airport, go-arounds, and 2019-01-04

airport = "EGLC" start = datetime.datetime(year=2019, month=1, day=4).replace( tzinfo=datetime.timezone.utc ) stop = datetime.datetime(year=2019, month=1, day=5).replace( tzinfo=datetime.timezone.utc )

df_selection = df.query("airport==@airport & has_ga & (@start <= time <= @stop)")

iterate over flights and pull the data from OpenSky Network

flights = [] delta_time = pd.Timedelta(minutes=10) for _, row in tqdm(df_selection.iterrows(), total=df_selection.shape[0]): # take at most 10 minutes before and 10 minutes after the landing or go-around start_time = row["time"] - delta_time stop_time = row["time"] + delta_time

# fetch the data from OpenSky Network
flights.append(
  opensky.history(
    start=start_time.strftime("%Y-%m-%d %H:%M:%S"),
    stop=stop_time.strftime("%Y-%m-%d %H:%M:%S"),
    callsign=row["callsign"],
    return_flight=True,
  )
)

The flights can be converted into a Traffic object

Traffic.from_flights(flights)

Additional files

Additional files are available to check the quality of the classification into GA/not GA and the selection of the landing runway. These are:

validation_table.xlsx: This Excel sheet was manually completed during the review of the samples for each runway in the data set. It provides an estimate of the false positive and false negative rate of the go-around classification. It also provides an estimate of the runway misclassification rate when the airport has two or more parallel runways. The columns with the headers highlighted in red were filled in manually, the rest is generated automatically.

validation_sample.zip: For each runway, 8 batches of 500 randomly selected trajectories (or as many as available, if fewer than 4000) classified as not having a GA and up to 8 batches of 10 random landings, classified as GA, are plotted. This allows the interested user to visually inspect a random sample of the landings and go-arounds easily.

The Gauteng City-Region Observatory (GCRO) (based at the University of Johannesburg (UJ)) in partnership with the Gauteng Provincial Government contracted Development Research Africa (DRA) to conduct an integrated Quality of Life/Customer Satisfaction Survey in the Gauteng City-Region (GCR). The objective of the GCRO is to assist and inform the Gauteng Government to build Gauteng as an integrated and globally competitive region, where the economic activities of different parts of the province complement each other in consolidating Gauteng as an economic hub of Africa and an internationally recognised global cityregion. The this end, the main aim of the survey, conducted from July to October 2009, was to inform the GCRO and the Provincial Government as well as other role-players about the perceived state of the municipalities within the GCR footprint especially with regard to the quality of life of their inhabitants.

Reliable market accessibility data is critical to developing agricultural policies and investment plans for ensuring smallholder farmers’ market participation and their profitable farming, yet this data is less frequently updated. Most of the publicly available data are outdated and hard to reflect the rapid development of transportation infrastructure in African countries. For this, using a newly available accessibility model input dataset, such as new land cover data from satellites, crowdsourced road network data, and the updated population of major human settlements in Tanzania are used to update the existing market accessibility data and provides new market accessibility data layers benchmarking around the year 2015. The dataset includes three data layers representing travel time to the nearest market of five sizes (population of 20K, 50K, 100K), respectively, on 1 arc-minute (~1km) grids in Tanzania.

Abstract

A tender was posted, by the Cape Town City Council, in November 2005 for a socio-economic survey and two focus groups to be conducted in both Khayelitsha and Mitchell's Plain. This tender was awarded to the Unit for Religion and Development at the University of Stellenbosch. The purpose was to update the 2001 Census information as well as to identify key priority issues and needs to inform integrated planning for the areas. In addition, the survey was intended to assess the impact of the Urban Renewal Programme in the respective communities. The objectives of the survey and focus groups were as follows:

• To evaluate the Urban Renewal Programme in the nodes of Khayelitsha and Mitchell’s Plain in order to improve the programme outcomes and the communication thereof;

• To develop a demographic and socio-economic profile of the community in terms of household size and composition, education, income and work status. A socio-economic and demographic profile is important in the identification of community needs to inform planning;

• To measure the communities’ perceptions on the value and importance of various services as well as their level of satisfaction with the delivery of these and other services;

• To identify the key needs of the respective communities in order to inform the City on appropriate investment in facilities, infrastructure and services.

Geographic coverage

Two renewal nodes in the Western Cape: Khayelitsha and Mitchell's Plain

Analysis unit

Households and individuals

Universe

All households and de jure household members within Khayelitsha or Mitchell's Plain.

Kind of data

Sample survey data

Sampling procedure

The survey is a stratified sample of 1 000 households from the study area. The sample was stratified on two levels: first, according to the number of households of the two geographical areas in the study area; and second, according to the number of formal and informal dwelling units in each geographical area (Mitchell’s Plain and Khayelitsha).

Regarding the first level of stratification by the number of households for each nodal area, a sample was selected totalling 453 households for the Mitchell’s Plain area and 547 for Khayelitsha. The second level of stratification by dwelling unit type was done within each nodal area, for Mitchell’s Plain totalling 12 informal dwelling units and 441 formal dwelling units, and for Khayelitsha totalling 311 informal dwelling units and 236 formal dwelling units. Formal and informal households were randomly selected from a small area layer (SAL) data set. This data set was created by combining all enumerated areas (EAs) with a population of less than 500 with adjacent EAs within the same sub-place by Statistics South Africa. Assigned to the SAL are the elected datasets from the 2001 Census, one of which is housing type. Because of the small sample size, comparison between geographic areas and/or different dwelling units within the areas may not be statistically significant.

Mode of data collection

Face-to-face [f2f]

Abstract

Polluted air is a major health hazard in developing countries. Improvements in pollution monitoring and statistical techniques during the last several decades have steadily enhanced the ability to measure the health effects of air pollution. Current methods can detect significant increases in the incidence of cardiopulmonary and respiratory diseases, coughing, bronchitis, and lung cancer, as well as premature deaths from these diseases resulting from elevated concentrations of ambient Particulate Matter (Holgate 1999).

Scarce public resources have limited the monitoring of atmospheric particulate matter (PM) concentrations in developing countries, despite their large potential health effects. As a result, policymakers in many developing countries remain uncertain about the exposure of their residents to PM air pollution. The Global Model of Ambient Particulates (GMAPS) is an attempt to bridge this information gap through an econometrically estimated model for predicting PM levels in world cities (Pandey et al. forthcoming).

The estimation model is based on the latest available monitored PM pollution data from the World Health Organization, supplemented by data from other reliable sources. The current model can be used to estimate PM levels in urban residential areas and non-residential pollution hotspots. The results of the model are used to project annual average ambient PM concentrations for residential and non-residential areas in 3,226 world cities with populations larger than 100,000, as well as national capitals.

The study finds wide, systematic variations in ambient PM concentrations, both across world cities and over time. PM concentrations have risen at a slower rate than total emissions. Overall emission levels have been rising, especially for poorer countries, at nearly 6 percent per year. PM concentrations have not increased by as much, due to improvements in technology and structural shifts in the world economy. Additionally, within-country variations in PM levels can diverge greatly (by a factor of 5 in some cases), because of the direct and indirect effects of geo-climatic factors.

The primary determinants of PM concentrations are the scale and composition of economic activity, population, the energy mix, the strength of local pollution regulation, and geographic and atmospheric conditions that affect pollutant dispersion in the atmosphere.

Geographic coverage

The database covers the following countries: Afghanistan Albania Algeria Andorra Angola
Antigua and Barbuda Argentina
Armenia Australia
Austria Azerbaijan
Bahamas, The
Bahrain Bangladesh
Barbados
Belarus Belgium Belize
Benin
Bhutan
Bolivia Bosnia and Herzegovina
Brazil
Brunei
Bulgaria
Burkina Faso
Burundi Cambodia
Cameroon
Canada
Cayman Islands
Central African Republic
Chad
Chile
China
Colombia
Comoros Congo, Dem. Rep.
Congo, Rep. Costa Rica
Cote d'Ivoire
Croatia Cuba
Cyprus
Czech Republic
Denmark Dominica
Dominican Republic
Ecuador Egypt, Arab Rep.
El Salvador Eritrea Estonia Ethiopia
Faeroe Islands
Fiji
Finland France
Gabon
Gambia, The Georgia Germany Ghana
Greece
Grenada Guatemala
Guinea
Guinea-Bissau
Guyana
Haiti
Honduras
Hong Kong, China
Hungary Iceland India
Indonesia
Iran, Islamic Rep.
Iraq
Ireland Israel
Italy
Jamaica Japan
Jordan
Kazakhstan
Kenya
Korea, Dem. Rep.
Korea, Rep. Kuwait
Kyrgyz Republic Lao PDR Latvia
Lebanon Lesotho Liberia Liechtenstein
Lithuania
Luxembourg
Macao, China
Macedonia, FYR
Madagascar
Malawi
Malaysia
Maldives
Mali
Mauritania
Mexico
Moldova Mongolia
Morocco Mozambique
Myanmar Namibia Nepal
Netherlands Netherlands Antilles
New Caledonia
New Zealand Nicaragua
Niger
Nigeria Norway
Oman
Pakistan
Panama
Papua New Guinea
Paraguay
Peru
Philippines Poland
Portugal
Puerto Rico Qatar
Romania Russian Federation
Rwanda
Sao Tome and Principe
Saudi Arabia
Senegal Sierra Leone
Singapore
Slovak Republic Slovenia
Solomon Islands Somalia South Africa
Spain
Sri Lanka
St. Kitts and Nevis St. Lucia
St. Vincent and the Grenadines
Sudan
Suriname
Swaziland
Sweden
Switzerland Syrian Arab Republic
Tajikistan
Tanzania
Thailand
Togo
Trinidad and Tobago Tunisia Turkey
Turkmenistan
Uganda
Ukraine United Arab Emirates
United Kingdom
United States
Uruguay Uzbekistan
Vanuatu Venezuela, RB
Vietnam Virgin Islands (U.S.)
Yemen, Rep. Yugoslavia, FR (Serbia/Montenegro)
Zambia
Zimbabwe

Kind of data

Observation data/ratings [obs]

Mode of data collection

Other [oth]

Part of the British Academy Knowledge Frontiers: International Interdisciplinary Research funding programme. Funded by the Department for Business, Energy and Industrial Strategy (BEIS). We are one of nine research projects bringing together novel, interdisciplinary ideas from across the humanities and social sciences in collaboration with the natural, medical and engineering sciences to propose solutions to international challenges past, present and future.• Theme of ‘What is a good city?’• 2-year projects with interdisciplinary and international teams• Projects “strengthen understanding of international challenges … and engage with questions concerning the relationship between expertise, public understanding and policy delivery internationally.” (British Academy)This research project investigated the challenge of food insecurity in cities as experienced by migrant communities and explored the role of traditional foods in well-being. The global population is increasingly urbanised, with Sub-Saharan Africa experiencing the fastest rate of urban population growth. South Africa is a centre for regional migration, with Johannesburg being the destination for the largest proportion of both within-country and international migrants. The project focused on two migrant groups in Johannesburg - South African rural-to-urban migrants and international regional migrants. Urban populations are dependent on food markets for daily sustenance and nutrition, hence access to affordable, acceptable and nutritious food through markets must be prioritised by cities. By identifying the drivers of food choice in urban migrant and immigrant populations around traditional foods, barriers to consumption and engaging with those involved in knowledge in urban planning and development, this project aimed to go some way towards tackling the problem of urban food insecurity and malnutrition.