This is an R Notebook to reconcile the CARE asset inventory survey against the SweetSense asset inventory survey. The CSV files were obtained from the mWater portal.
CareSurvey <- read.csv("D:/Google Drive/School/PDX/SWEET Lab/Ethiopia/Asset Inventories/CareSurvey.csv", header=FALSE)
SweetSenseSurvey <- read.csv("D:/Google Drive/School/PDX/SWEET Lab/Ethiopia/Asset Inventories/SweetSenseSurvey.csv", header=FALSE)
CareSurvey_simple = unname(unlist(CareSurvey[1,]))
CareSurvey_simple <- as.character(CareSurvey_simple)
SweetSenseSurvey_simple = unname(unlist(SweetSenseSurvey[1,]))
SweetSenseSurvey_simple <- as.character(SweetSenseSurvey_simple)
index = which(!(SweetSenseSurvey_simple %in% CareSurvey_simple))
SweetSenseSurvey_simple[index] [1] "Country"
[2] "Country (Location Answered) (latitude)"
[3] "Country (Location Answered) (longitude)"
[4] "Country (Location Answered - accuracy)"
[5] "Country (Location Answered - altitude)"
[6] "Water system (distribution scheme linked to this update)"
[7] "County / Region"
[8] "Sub-County"
[9] "Local Officer Name"
[10] "Local officer telephone number"
[11] "Rural/Urban"
[12] "What is the service area for this scheme - How many kilometers from here do the pipes run?"
[13] "Is this scheme used for agriculture and irrigation by farmers?"
[14] "How many farmers use this scheme? "
[15] "What is the average sized farm that uses this water (hectares)? "
[16] "How many times per week does the water trucking occur?"
[17] "Add any other comments on water trucking details"
[18] "Physical state of the well/borehole"
[19] "Type of Power"
[20] "Production of system: yield or discharge (meters cubed/hour)"
[21] "Please take a picture of the Borehole"
[22] "Please take a picture of the Borehole Meter"
[23] "Does the scheme have any emerging problems that might lead to non-functionality in the near future?"
[24] "Was the water scheme out of service one or more days in the last year?"
[25] "How many times has the pump broken in the last year?"
[26] "How many days per week does the pump run on average?"
[27] "How many hours per day does the pump run on average?"
[28] "Is this a seasonal water scheme that commonly fails in the dry season? (Don't Know)"
[29] "Does how often the pump used depend if it is wet/rainy season?"
[30] "Does how often the pump used depend if it is wet/rainy season? (Don't Know)"
[31] "During wet/rainy seasons how many days a week does the pump run on average?"
[32] "During wet/rainy seasons how many hours per day does the pump run on average?"
[33] "Are solar panels tracking type?"
[34] "Solar Panel power rating (Watts)"
[35] "Solar Panel Condition"
[36] "Solar Panels picture"
[37] "Year when generator was installed (or year of re-installation)"
[38] "Year when generator was installed (or year of re-installation) (Don't Know)"
[39] "Generator brand (Don't Know)"
[40] "Generator max Amps (starting amps)"
[41] "Picture of generator technical details / nameplate"
[42] "Pump Controller Manufacturer"
[43] "Pump Controller Manufacturer (Other (please specify)) - specify"
[44] "Pump Controller Model Number"
[45] "Picture of pump controller"
[46] "Pump Controller Manufacturer"
[47] "Pump Motor Model Number"
[48] "Pump head model number"
[49] "Well pump remarks"
[50] "Is a sensor installed at the site?"
[51] "Type of sensor installed (Other (please specify)) - specify"
[52] "Type of Sensor Input"
[53] "Picture of Sensor input"
[54] "What is the tariff amount (in KES)?"
[55] "What is the tariff amount (in ETB)?"
[56] "What is the tariff per camel (KES)?"
[57] "What is the tariff per camel (KES)? (Not Applicable)"
[58] "What is the tariff per camel (ETB)?"
[59] "What is the tariff per camel (ETB)? (Not Applicable)"
[60] "What is the tariff per cattle (KES)?"
[61] "What is the tariff per cattle (KES)? (Not Applicable)"
[62] "What is the tariff per cattle (ETB)?"
[63] "What is the tariff per cattle (ETB)? (Not Applicable)"
[64] "What is the tariff per horse/donkey (KES)?"
[65] "What is the tariff per horse/donkey (KES)? (Not Applicable)"
[66] "What is the tariff per horse/donkey (ETB)?"
[67] "What is the tariff per horse/donkey (ETB)? (Not Applicable)"
[68] "What is the tariff per goat/sheep (KES)?"
[69] "What is the tariff per goat/sheep (KES)? (Not Applicable)"
[70] "What is the tariff per goat/sheep (ETB)?"
[71] "What is the tariff per goat/sheep (ETB)? (Not Applicable)"
[72] "What is the monthly institutional tariff (KES)?"
[73] "What is the monthly institutional tariff (ETB)?"
[74] "When this borehole is working, from where do households primarily get their water?"
[75] "When this borehole is working, from where do households primarily get their water? (Other (please specify)) - specify"
[76] "When this borehole is working, how many hours per day do households typically spend collecting water?"
[77] "When this borehole is not working, from where do households primarily get their water? "
[78] "When this borehole is not working, from where do households primarily get their water? (Other (please specify)) - specify"
[79] "When this borehole is not working, from where do households primarily get their water? (Don't Know)"
[80] "When this borehole is NOT working, and households have to use an alternative water source, how many hours per day do households spend collecting water?"
[81] "When this borehole is NOT working, and households have to use an alternative water source, how many hours per day do households spend collecting water? (Don't Know)"
[82] "Has there been some water quality testing for this scheme in the past?"
[83] "Year of most recent water quality test done?"
[84] "Year of most recent water quality test done? (Don't Know)"
[85] "What was the result?"
[86] "What was the result? (Don't Know)"
[87] "Are there specific contaminants of concern?"
[88] "Are there specific contaminants of concern? (Other (please specify)) - specify" index [1] 9 10 11 12 13 14 15 17 18 19 21 23 24 25 26 34 35 39 40 41 42 44
[23] 52 56 57 59 60 62 63 64 65 66 67 68 69 70 71 72 76 79 82 83 84 85
[45] 86 87 88 89 90 99 101 106 107 111 112 114 115 116 117 118 119 120 121 122 123 124
[67] 125 126 127 128 129 131 132 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149CareSurvey_simple[index]
[1] "Roster"
[2] "Zone"
[3] "Kebele"
[4] "Context"
[5] "Name of water supply scheme"
[6] "Year of water scheme construction (or most recent rehabilitation) in EFY"
[7] "Year of water scheme construction (or most recent rehabilitation) in EFY (Don't Know)"
[8] "What is the total number of water sources supplying the scheme?"
[9] "Type of scheme"
[10] "Total number of tap stands"
[11] "Total number of household connections"
[12] "Total number of institutional connections"
[13] "Index"
[14] "Type of water source"
[15] "Location of the water source (latitude)"
[16] "Location of the water source (longitude)"
[17] "Location of the water source (administrative region)"
[18] "Location of the water source (accuracy)"
[19] "Location of the water source (altitude)"
[20] "Please take a picture of the water source"
[21] "Name of the borehole/well"
[22] "Borehole or well diameter (inches)"
[23] "Is the well seal unsanitary?"
[24] "The well/ borehole is not fenced, or the fencing is damaged, permitting unauthorised entry and livestock access?"
[25] "Is there any other source of pollution (e.g. animal excreta, rubbish, surface water) within 10m of the borehole?"
[26] "Is there a latrine within 30 meters radius?"
[27] "Where is the location of the latrine?"
[28] "Does the water point have adequate drainage so that excess water drains away and does not stand around the water point?"
[29] "Is the well/ borehole vulnerable to flood damage?"
[30] "Is there more than one generator for this scheme?"
[31] "Is there a generator house?"
[32] "Is the generator house lockable and securely protects the installed equipment?"
[33] "Types of lifting device (power)"
[34] "Types of lifting device (power) (Other (please specify)) - specify"
[35] "Year (EFY) pump installation (or last repair/replacement)"
[36] "Year (EFY) pump installation (or last repair/replacement) (Don't Know)"
[37] "Physical state of the pump"
[38] "Type of hand pump"
[39] "Type of hand pump (Other (please specify)) - specify"
[40] "Year (EFY) when generator was installed (or year of re-installation)"
[41] "Year (EFY) when generator was installed (or year of re-installation) (Don't Know)"
[42] "Generator fuel"
[43] "Is fuel securely kept in a safe location?"
[44] "Generator KVA"
[45] "Generator KVA (Comments)"
[46] "Generator max Amps(starting amps)"
[47] "Generator max Amps(starting amps) (Comments)"
[48] "Generator last service date"
[49] "Generator last service date (Don't Know)"
[50] "Generator alternator manufacturer"
[51] "Generator alternator model"
[52] "Is a water level measurement done during this survey?"
[53] "Date and time when water level measurement was done"
[54] "Which type of device was used to measure water level? "
[55] "Which type of device was used to measure water level? (Other (please specify)) - specify"
[56] "Was the static Water level measured BEFORE pumping?"
[57] "What is the static water level measurement BEFORE pumping in meters?"
[58] "Reason for not doing the 'BEFORE pumping' water level measurement?"
[59] "Reason for not doing the 'BEFORE pumping' water level measurement? (Other (please specify)) - specify"
[60] "How long (in minutes) has the pump been running continuously on the day of the survey?"
[61] "Was the water level measured AFTER pumping?"
[62] "What is the water level measurement AFTER pumping (in meters)"
[63] "How long (in minutes) the pump worked before the static water measurement conducted"
[64] "Reason for not doing the AFTER pumping measurement?"
[65] "Reason for not doing the AFTER pumping measurement? (Other (please specify)) - specify"
[66] "Is a flow-rate measurement done during this survey?"
[67] "How was the flow-rate calculated?"
[68] "How was the flow-rate calculated? (Other (please specify)) - specify"
[69] "What was the flow-rate measurement (litres/sec)"
[70] "Reason for not measuring the water flow-rate?"
[71] "Reason for not measuring the water flow-rate? (Other (please specify)) - specify"
[72] "While functional, does the scheme have any emerging problems that might lead to non-functionality in the near future"
[73] "Production of system: yield or discharge (l/sec)"
[74] "Production of system: yield or discharge (l/sec) (Comments)"
[75] "On average, how many hours a day is the water source operating?"
[76] "Construction year of the spring in EFY (or the year of rehabilitation)"
[77] "Construction year of the spring in EFY (or the year of rehabilitation) (Don't Know)"
[78] "Physical state of the spring protection"
[79] "Construction year of the surface water in EFY (or the year of rehabilitation)"
[80] "Construction year of the surface water in EFY (or the year of rehabilitation) (Don't Know)"
[81] "Physical state of the surface water intake"
[82] "Types of lifting device (power)"
[83] "Types of lifting device (power) (Other (please specify)) - specify"
[84] "Year (EFY) pump installation (or last repair/replacement)"
[85] "Year (EFY) pump installation (or last repair/replacement) (Don't Know)"
[86] "Physical state of the pump"
[87] "Type of hand pump"
[88] "Type of hand pump (Other (please specify)) - specify"
[89] "Is there a generator house?"
[90] "Is the generator house lockable and securely protects the installed equipment?"
[91] "Year (EFY) when generator was installed (or year of re-installation)"
[92] "Year (EFY) when generator was installed (or year of re-installation) (Don't Know)"
[93] "Generator fuel"
[94] "Is fuel securely kept in a safe location?"
[95] "Generator KVA"
[96] "Generator KVA (Comments)"
[97] "Generator max Amps(starting amps)"
[98] "Generator max Amps(starting amps) (Comments)"
[99] "Generator last service date"
[100] "Generator last service date (Don't Know)"
[101] "Generator alternator manufacturer"
[102] "Generator alternator model"
[103] "Switchboard manufacturer"
[104] "Switchboard model"
[105] "Switchboard power (KW)"
[106] "Switchboard power (KW) (Comments)"
[107] "Switchboard voltage"
[108] "Switchboard voltage (Comments)"
[109] "Switchboard Ampere"
[110] "Switchboard Ampere (Comments)"
[111] "Switchboard picture"
[112] "Year of solar installation (or year of re-installation)"
[113] "Year of solar installation (or year of re-installation) (Don't Know)"
[114] "Physical state of the solar installation"
[115] "Who installed the system (name of contractor)?"
[116] "Solar installation picture"
[117] "Type voltage of submersible pump"
[118] "D/C to A/C Voltage Inverter Manufacturer"
[119] "D/C to A/C Voltage Inverter Model"
[120] "D/C to A/C Voltage Inverter Rate Power (watts)"
[121] "D/C to A/C Voltage Inverter Peak Power (watts)"
[122] "D/C to A/C Voltage Inverter: A/C Current Charging Range (amp)"
[123] "Pump controller manufacturer"
[124] "Pump controller model"
[125] "Pump controller serial number"
[126] "Power (max) Kw"
[127] "Pump controller input current (Amps)"
[128] "PV panels manufacturer brand"
[129] "PV panels model number"
[130] "PV panel type"
[131] "PV panels size (individual, metres longest side)"
[132] "PV panels size (individual, metres longest side) (Comments)"
[133] "PV panel wattage (per panel)"
[134] "PV panel wattage (per panel) (Comments)"
[135] "Total number of PV panels"
[136] "Are the PV panels in a fenced area?"
[137] "Tick if the following components of the installation are present"
[138] "Is a sensor installed?"
[139] "Sensor telephone number"
[140] "Index"
[141] "Location of the reservoir (latitude)"
[142] "Location of the reservoir (longitude)"
[143] "Location of the reservoir (administrative region)"
[144] "Location of the reservoir (accuracy)"
[145] "Location of the reservoir (altitude)"
[146] "Please take reservoir picture "
[147] "Ground or elevated reservoir?"
[148] "Reservoir type"
[149] "Reservoir capacity in cubic meters?"
[150] "Reservoir capacity in cubic meters? (Comments)"
[151] "Year of construction of the reservoir in EFY (or year of rehabilitation)"
[152] "Year of construction of the reservoir in EFY (or year of rehabilitation) (Don't Know)"
[153] "Physical state of reservoir"
[154] "Year of the main line was constructed in EFY (or year of rehabilitation)"
[155] "Year of the main line was constructed in EFY (or year of rehabilitation) (Don't Know)"
[156] "Physical state of main line"
[157] "Year of construction of the secondary distribution network in EFY (or year of rehabilitation)"
[158] "Year of construction of the secondary distribution network in EFY (or year of rehabilitation) (Don't Know)"
[159] "Physical state of secondary distribution network"
[160] "Is there a water treatment plant?"
[161] "What kind of water treatment plant it is?"
[162] "What kind of water treatment plant it is? (Other (please specify)) - specify"
[163] "Physical state of treatment plant"
[164] "Year treatment plant was constructed (EFY), if replaced, year of most recent replacement"
[165] "Year treatment plant was constructed (EFY), if replaced, year of most recent replacement (Don't Know)"
[166] "Is chlorination practised?"
[167] "Describe chlorination practice"
[168] "How often is chlorination practised?"
[169] "Are there livestock drinking facilities?"
[170] "Physical state of livestock drinking facilities"
[171] "Year livestock drinking facilities were constructed in EFY (or rehabilitated)"
[172] "Year livestock drinking facilities were constructed in EFY (or rehabilitated) (Don't Know)"
[173] "Is the source selected for water quality sampling?"
[174] "Date of taking water quality sample"
[175] "Select a unique code comprising woreda initials e.g. DF 01 for a sample from Dalifage"
[176] "Is the source selected for Fluoride test?"
[177] "Date of Fluoride test done"
[178] "Write the Fluoride test result in mg/l"
[179] "Write the Fluoride test result in mg/l (Comments)"
[180] "Is the source selected for EC/TDS test?"
[181] "Date of EC/TDS test done"
[182] "Write the EC test result in ppm (mg/l)"
[183] "Write the EC test result in ppm (mg/l) (Comments)"
[184] "Write the TDS test result in ppm (mg/l)"
[185] "Write the TDS test result in ppm (mg/l) (Comments)"
[186] "Is the source selected for pH test?"
[187] "Date of pH test done"
[188] "Write the pH test result"
[189] "Write the pH test result (Comments)"
[190] "To what extent are women represented in the WASHCO?"
[191] "How much money is currently held by the WASHCO (in Birr)?"
[192] "How many households live in this village or town?"
[193] "How many households are served by the scheme that live within 1.0 km (if rural) or 250 m (if urban)"
[194] "What is the tariff amount (in Birr)?"
[195] "What is the tariff amount (in Birr)? (Comments)"
[196] "What is the tariff per camel (Birr)"
[197] "What is the tariff per camel (Birr) (Comments)"
[198] "What is the tariff per camel (Birr) (Not Applicable)"
[199] "What is the tariff per cattle (Birr)"
[200] "What is the tariff per cattle (Birr) (Comments)"
[201] "What is the tariff per cattle (Birr) (Not Applicable)"
[202] "What is the tariff per Horse/Donkey (Birr)"
[203] "What is the tariff per Horse/Donkey (Birr) (Comments)"
[204] "What is the tariff per Horse/Donkey (Birr) (Not Applicable)"
[205] "What is the tariff per goat/sheep (Birr)"
[206] "What is the tariff per goat/sheep (Birr) (Comments)"
[207] "What is the tariff per goat/sheep (Birr) (Not Applicable)"
[208] "What is the monthly institutional tariff (Birr)?"
[209] "What is the monthly institutional tariff (Birr)? (Comments)"
[210] "Maximum one direction time taken to reach the water point(s) in minutes by any regular user"
[211] "Index"
[212] "Name of the tap stand"
[213] "Tap location (latitude)"
[214] "Tap location (longitude)"
[215] "Tap location (administrative region)"
[216] "Tap location (accuracy)"
[217] "Tap location (altitude)"
[218] "Year of tap stand construction in EFY (or the year of rehabilitation)"
[219] "Year of tap stand construction in EFY (or the year of rehabilitation) (Don't Know)"
[220] "Is the public tap stand currently functional?"
[221] "Tap picture"
[222] "Number of months since non-functional/partially functional"
[223] "Main cause of non-functionality/partial functionality"
[224] "Main cause of non-functionality/partial functionality (Other (please specify)) - specify"
[225] "Physical state of the tap stand"
[226] "Is there a water meter at the tap stand?"
[227] "Is the water meter working?"
[228] "Is the water meter working? (Don't Know)"
[229] "What is the current reading in water meter?"
[230] "Is this public tap selected for water quality test"
[231] "Select a unique code similar with the code you used to label the test bag"