Socio-Economic Profiling of Urban Renewal Nodes 2006 ddi-zaf-datafirst-sepurn-2006-v1 DataFirst 2020-04-28 Nesstar Publisher Version 2 Socio-Economic Profile of Urban Renewal Nodes Khayelitsha and Mitchell's Plain SEPURN zaf-cct-sepurn-2006-v1.1 Information and Knowledge Management Department QSJ Consultants Unit for Religion and Development Research Copyright, Information and Knowledge Management Department, City of Cape Town Nesstar Publisher Manager, DataFirst Socio-Economic/Monitoring Survey [hh/sems] City of Cape Town and Unit for Religion and Development. Socio-Economic Profiling of Urban Renewal Nodes 2006 [dataset]. Cape Town: City of Cape Town, Stellenbosch: URD, University of Stellenbosch [producers], 2006. Cape Town: DataFirst [distributor], 2012. DOI: https://doi.org/10.25828/8fg6-q179 v1.1: Edited, anonymised dataset for licensed distribution. The original dataset was provided by the Information and Knowledge Management Department of the City of Cape Town. DataFirst updated this original version by including variable and value labels. These labels were based on information contained within the metadata and questionnaires that accompany the dataset. consumption/consumer behaviour [1.1] income, property and investment/saving [1.5] conflict, security and peace [4.1] crime [5.1] law enforcement [5.2] environmental degradation/pollution and protection [9.1] natural resources and energy [9.3] TRANSPORT, TRAVEL AND MOBILITY [11] community, urban and rural life [13.1] social behaviour and attitudes [13.6] social conditions and indicators [13.8] morbidity and mortality [14.4] employment [3.1] unemployment [3.5] basic skills education [6.1] compulsory and pre-school education [6.2] life-long/continuing education [6.4] post-compulsory education [6.5] language and linguistics [7.3] accidents and injuries [8.1] specific diseases and medical conditions [8.9] general health [8.4] South Africa Two renewal nodes in the Western Cape: Khayelitsha and Mitchell's Plain Households and individuals All households and de jure household members within Khayelitsha or Mitchell's Plain. Sample survey data Face-to-face [f2f] DataFirst City of Cape Town and Unit for Religion and Development. Socio-Economic Profiling of Urban Renewal Nodes 2006 [dataset]. Cape Town: City of Cape Town, Stellenbosch: URD, University of Stellenbosch [producers], 2006. Cape Town: DataFirst [distributor], 2012. DOI: https://doi.org/10.25828/8fg6-q179 Licensed use files, available for non-commercial use only SEPURN 2006 Hhold_v1.1_20120215.NSDstat 0 147 Nesstar 200801 Information and Knowledge Management Department, City of Cape Town v1.1 SEPURN 2006 Person_v1.1_20120215.NSDstat 0 27 Nesstar 200801 Information and Knowledge Management Department, City of Cape Town v1.1 Unique ID identifying household 0 0 Urban renewal node 0 0 Fieldworker 0 0 Enumerated area 0 0 TypeDwell 0 0 Satisfaction with service delivery in area 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of roads and streets 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of streetlights 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of cleanliness of area 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of water 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of sanitation 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of refuse removal 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of health services 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of housing 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of education 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with condition of policing 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Access to crèche 0 0 1 Yes 2 No Access to primary school 0 0 1 Yes 2 No Access to secondary school 0 0 1 Yes 2 No Access to clinic 0 0 1 Yes 2 No Access to post-office 0 0 1 Yes 2 No Access to community hall 0 0 1 Yes 2 No Access to shop 0 0 1 Yes 2 No Access to home shop 0 0 1 Yes 2 No Access to bus service 0 0 1 Yes 2 No Access to taxi service 0 0 1 Yes 2 No Access to train service 0 0 1 Yes 2 No Access to sport facility 0 0 1 Yes 2 No Access to recreational facilities 0 0 1 Yes 2 No Access to old age care 0 0 1 Yes 2 No Access to library 0 0 1 Yes 2 No Access to municipal offices 0 0 1 Yes 2 No Access to SAPS, law enforcement 0 0 1 Yes 2 No Access to fire brigade 0 0 1 Yes 2 No Access to ambulance service 0 0 1 Yes 2 No Satisfaction with crèche 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with primary school 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with secondary school 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with clinic 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with post-office 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with community hall 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with shop 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with home shop 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with bus service 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with taxi service 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with train service 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with sport facility 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with recreational facilities 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with old age care 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with library 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with municipal offices 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with SAPS, law enforcement 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with fire brigade 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Satisfaction with ambulance service 0 0 1 Highly Satisfied 2 Satisfied 3 Uncertain 4 Dissatisfied 5 Highly Dissatisfied Awareness of Urban Renewal Programme in Khayelitsha 0 0 1 No, I have never heard of it 2 Yes, I have heard something about it 3 Yes, familiar 4 Uncertain How respondent heard of urban renewal programme 0 0 1 Newspapers 2 Newsletters 3 Brochures and posters 4 Billboards 5 NGO Offices 6 Campaigns of City 7 Road shows 8 Radio 9 TV 10 Call Centre 11 Community meeting 12 Community leader/councillor 13 Forum 14 Clinic 15 Church/religious groups 16 Friends 17 Social Worker Awareness of specific projects initiated by urban renewal programme 0 0 1 Yes 2 No 3 Unsure Project 1 0 0 Project 2 0 0 Project 3 0 0 Project 4 0 0 Aware of Swartklip Regional Sports facility 0 0 1 Yes 2 No Aware of Colorado Multi-purpose centre (MPCC) 0 0 1 Yes 2 No Aware of Khayelitsha rail extension 0 0 1 Yes 2 No Aware of Khayelitsha CBD 0 0 1 Yes 2 No Aware of Khayelitsha HIV/AIDS 0 0 1 Yes 2 No Aware of Khayelitsha housing 0 0 1 Yes 2 No Aware of Mitchell’s Plain CBD 0 0 1 Yes 2 No Aware of Lentegeur & Mandalay Public Transport upgrade 0 0 1 Yes 2 No Aware of Mitchell’s Plain housing 0 0 1 Yes 2 No Aware of Tafelsig public space upgrade 0 0 1 Yes 2 No Aware of Swartklip Regional Sports facility 0 0 1 Yes 2 No Influence of Swartklip Regional Sports facility on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Colorado Multi-purpose centre (MPCC) on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Khayelitsha rail extension on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Khayelitsha CBD on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of of Khayelitsha HIV/AIDS on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Khayelitsha housing on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Mitchell’s Plain CBD on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Lentegeur & Mandalay Public Transport on quality of lifeupgrade 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Mitchell’s Plain housing on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Tafelsig public space upgrade on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Influence of Swartklip Regional Sports facility on quality of life 0 0 1 Yes, improved quality of life 2 No, had no effect on quality of life 3 No, decreased quality of life Impact of quality of sports grounds on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of public open space on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of housing conditions on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of job opportunities on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of access to public transport on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of roads on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of information about HIV/AIDS on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of access to services and shops on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Impact of space for community events on quality of life in the past 3 years 0 0 1 A great extent 2 To some extent 3 None 4 Worsened Pressing challenges 1 0 Pressing challenges 2 0 0 Pressing challenges 3 0 0 Quality of life improving projects 1 0 0 Quality of life improving projects 2 0 Quality of life improving projects 3 0 0 Quality of life improving projects 4 0 0 Quality of life improving projects 5 0 0 Time lived in area/community? 0 0 1 Born in this area 2 Before 1990 3 1990 to 1995 4 1996 to 2000 5 2001 to 2005 6 2006 If born elsewhere, respondent moved from which province? 0 0 -66 Other 1 Western Cape 2 Gauteng 3 Free State 4 Mpumalanga 5 KwaZulu Natal 6 Eastern Cape 7 Northern Cape 8 North West Province 9 Limpopo 10 Outside South Africa If person moved from city, from which suburb or place? 0 0 Does the household own this dwelling and is it paid for? 0 0 1 Owned and fully paid off 2 Owned but not yet paid off 3 Rented 4 Occupied rent-free 5 Not applicable Number of rooms in household 0 0 Where do you go to buy essential foodstuffs? 0 0 -66 Other 1 A shop inside a mall 2 A general dealer (i.e. Pick & Pay, Shoprite, Checkers) 3 Café 4 House shop Total household income 0 0 How much per month does the household spend on housing 0 0 How much per month does the household spend on food 0 0 How much per month does the household spend on water, rates, sanitation 0 0 How much per month does the household spend on electricity, paraffin, gas, wood 0 0 How much per month does the household spend on bus fees 0 0 How much per month does the household spend on taxi fees 0 0 How much per month does the household spend on train fees 0 0 How much per month does the household spend on own car 0 0 How much per month does the household spend on educaiton (creche, school, etc) 0 0 How much per month does the household spend on medical expenses 0 0 How much per month does the household spend on child support 0 0 How much per month does the household spend on clothing 0 0 How much per month does the household spend on accounts 0 0 How much per month does the household spend on other monthly expenses, specify 0 0 How often do you have problems in your area with people under the influence of a 0 0 1 Daily 2 Only on weekends 3 Occasionally 4 Never What kinds of problems do you experience when people in your area are under the 0 0 1 Noise 2 Violence 3 Noise and violence 4 Crime (vandalism/theft, etc.) 5 None If you or your household found yourself without any food, who/what would be the 0 0 -66 Other 1 A friend 2 One or both parents 3 A family member 4 A religious leader or pastor 5 A social worker 6 A teacher at school 7 Neighbour 8 Police 9 Clinic 10 Pharmacy 11 Doctor 12 Traditional healer 13 NGO 14 No one, went without any help If you or your household found yourself without any cash/income, who/what would 0 0 -66 Other 1 A friend 2 One or both parents 3 A family member 4 A religious leader or pastor 5 A social worker 6 A teacher at school 7 Neighbour 8 Police 9 Clinic 10 Pharmacy 11 Doctor 12 Traditional healer 13 NGO 14 No one, went without any help If you or members of your household became sick, who/what would be the first per 0 0 -66 Other 1 A friend 2 One or both parents 3 A family member 4 A religious leader or pastor 5 A social worker 6 A teacher at school 7 Neighbour 8 Police 9 Clinic 10 Pharmacy 11 Doctor 12 Traditional healer 13 NGO 14 No one, went without any help If you or members of your household were victims of crime, who/what would be the 0 0 -66 Other 1 A friend 2 One or both parents 3 A family member 4 A religious leader or pastor 5 A social worker 6 A teacher at school 7 Neighbour 8 Police 9 Clinic 10 Pharmacy 11 Doctor 12 Traditional healer 13 NGO 14 No one, went without any help If you or members of your household had drug or substance abuse problems, who/wh 0 0 -66 Other 1 A friend 2 One or both parents 3 A family member 4 A religious leader or pastor 5 A social worker 6 A teacher at school 7 Neighbour 8 Police 9 Clinic 10 Pharmacy 11 Doctor 12 Traditional healer 13 NGO 14 No one, went without any help Has any adult in the household gone hungry in the past 12 months because there w 0 0 1 Never 2 Seldom 3 Sometimes 4 Often (weekly) 5 Always (every day) Has any child (17 years and younger) in the household gone hungry in the last 12 0 0 1 Never 2 Seldom 3 Sometimes 4 Often (weekly) 5 Always (every day) Has the household been a victim of any outbreaks of fire in the last 12 months 0 0 0 Never been a victim 1 Once in the last year 2 Twice in the last year 3 Three or more times in the last year Has the dwelling been damaged by flood water in the past 12 months? 0 0 0 Never been a victim 1 Once in the last year 2 Twice in the last year 3 Three or more times in the last year How many persons of this household died for any reason during the year of 2005? 0 0 0 Never been a victim 1 Once in the last year 2 Twice in the last year 3 Three or more times in the last year Age of first person who died in 2005 0 0 Age of second person who died in 2005 0 0 Age of third person who died in 2005 0 0 Age of fourth person who died in 2005 0 0 Age of fifth person who died in 2005 0 0 Do you feel safe moving around your area during the day? 0 0 1 Strongly Agree 2 Moderately Agree 3 Uncertain 4 Moderately Disagree 5 Strongly disagree Do you feel safe moving around your area during the night? 0 0 1 Strongly Agree 2 Moderately Agree 3 Uncertain 4 Moderately Disagree 5 Strongly disagree Do you think safety has improved in your area in the past year? 0 0 1 Strongly Agree 2 Moderately Agree 3 Uncertain 4 Moderately Disagree 5 Strongly disagree What type of phone service does this household have access to? 0 0 -66 Other 1 Telephone in dwelling and cell-phone 2 Telephone in dwelling only 3 Cell-phone only 4 At a neighbour nearby 5 At a public telephone nearby 6 At another location nearby 7 At another location, not nearby 8 No access to a telephone What type of phone service does this household have access to? 0 0 -66 Other 1 Telephone in dwelling and cell-phone 2 Telephone in dwelling only 3 Cell-phone only 4 At a neighbour nearby 5 At a public telephone nearby 6 At another location nearby 7 At another location, not nearby 8 No access to a telephone Main problems experienced with the provision of water 0 0 Main problems experienced with the provision of sanitation 0 Main problems experienced with the provisions of refuse removal 0 0 Assuming that the household has electricity, do you feel that the power/electric 0 0 1 Yes 2 Unsure 3 No Unique ID identifying household 0 0 Unique ID identifying respondent 0 0 Person's sex 0 0 1 Female 2 Male Person's age 0 0 -2 Don't Know -1 Refuse 0 Baby younger than 1 yr Population group 0 0 1 Black/African 2 Coloured 3 Asian 4 White Home language 0 0 1 Afrikaans 2 isiXhosa 3 English 4 Zulu 5 isiNdebele 6 Sepedi 7 Sesotho 8 Setswana 9 Siswati 10 Tshivenda 11 Xitsonga Second language 0 0 1 Afrikaans 2 isiXhosa 3 English 4 Zulu 5 isiNdebele 6 Sepedi 7 Sesotho 8 Setswana 9 Siswati 10 Tshivenda 11 Xitsonga Grant type received 0 0 1 Old Age Grant 2 Veteran's Pension 3 Disability Grant 4 Grant in aid 5 Care dependency grant 6 Unemployment insurance 7 Child support grant 8 Foster child grant Relationship to head of household 0 0 1 Head or acting head 2 Husband, wife, partner 3 Biological child 4 Adopted child 5 Step-child 6 Foster child 7 Brother or sister 8 Biological parent 9 Step parent 10 Parent in law 11 Grand or great grand child 12 Son or daughter in law 13 Brother or sister in law 14 Other relative 15 Non related person Religious affiliation 0 0 1 Mainline churches 2 Charismatic churches 3 Pentecostal churches 4 African independent churches 5 Other christian churches 6 Islam faith 7 Hindu faith 8 African traditional belief 9 Other religion 10 No religious affiliation Does this person attend an educational institution 0 0 1 None 2 Pre-school 3 Primary school 4 Secondary school 5 Tertiary institution 6 Adult education centre Reason for individual not attending school 0 0 1 Pre-school child (not yet in school) 2 Completed school and already working 3 Completed school and looking for job 4 Left school and working 5 Left school and looking for job 6 School is too far 7 No money 8 Pregnancy 9 Failed exams 10 Got married 11 Family commitment (child minding, elderly persons, etc. 12 Due to illness Highest level of educational attainment 0 0 0 Grade 0 1 Grade 1-7 2 Grade 8/St 6/Form 1 3 Grade 9/St 7/Form 2 4 Grade 10/St 8/Form 3/NTCI 5 Grade 11/St 9/Form 4/NTCII 6 Gr 12/St 10/Form 5/Martic/NTCIII 7 Certificate without matric 8 Diploma with less than Gr. 12 9 Certificate with matric 10 Diploma with matric 11 Technikon degree 12 University degree 13 Adult education/literary classes 14 Other 15 Don't know Specify certificate, diploma or degree (e.g. Diploma in marketing or BComm, ect. 0 0 Where are pre-school children in this household taken during the day? 0 0 1 At home 2 Day care 3 Creche 4 Pre-primary What is the person's current employment status? 0 0 1 Employed 2 Unemployed and looking for work 3 Unemployed and not looking for work 4 Not applicable (under 15 or older than 65) Time spent looking for work if respondent is unemployed (months). If not looking 0 0 What is the main reason for this person not having work in the past month 0 0 1 Scholar or student 2 Home-maker or housewife 3 Pensioner or retired person (too old to work) 4 Unable to work due to illness or disability 5 Seasonal worker not working presently 6 Choose not to work 7 Could not find work What type of employment is the person involved in? 0 0 1 Work for a private person (e.g. domestic worker, gardener) 2 Work for wage/salary in the private sector 3 Work for wage/salary in the informal sector 4 Work for local/provincial/national government 5 Self-employed/employer in the private sector 6 Self-employed/employer in the informal sector 7 Farmer (farm worker, domestic on farm) 8 Labour contractor/contractor 9 Work for FBO/NGO/CBO From where do you run your business? 0 0 1 Home 2 Another location nearby in community 3 Another location further away What type of activity does the business involve? 0 0 Three major problems the person encounters running their business 0 How does the person usually travel to school or his/her workplace? 0 0 1 Not applicable 2 On foot 3 By bicycle 4 By motorcyle 5 By car as driver 6 By car as passenger 7 By minibus or taxi 8 By bus 9 By train Has anyone in this household been a victim of crime in the last 12 months? 0 0 1 Never been a victim 2 Once in the last year 3 Twice in the last year 4 Three or more times in the last year The type of crime of which person in household was victim 0 0 During the past month has any person in the household suffered from any illnesse 0 0 1 None 2 Flu or acute respiratory infection 3 Diarrhoea 4 Severe trauma (e.g. due to violence, motor vehicle accident, gunshot, assault, beating) 5 TB or severe coughing with blood 6 Depression or mental illness 7 Diabetes 8 High or low blood pressure 9 HIV/AIDS 10 Other sexually transmitted disease 11 Substance dependency 12 More than one illness or injury Does the person have a serious disability that prevents his or her full particip 0 0 1 None 2 Sight (blind/severe visual limitation) 3 Hearing (deaf, profoundly hard of hearing) 4 Communication (speech impediment) 5 Physical (e.g. needs wheelchair, crutches or prostheses; limb or hand usage limitations) 6 Intellectual (serious difficulties in learning) 7 Emotional (behavioural, psychological)