-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathktc-water-data.html
314 lines (255 loc) · 14 KB
/
ktc-water-data.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title> KTC Water Data
| waterpower</title>
<meta name="author" content="John Gage"/>
<!-- Bootstrap -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.1.0/magnific-popup.min.css"/>
<link rel="stylesheet" href="./theme/css/jquery.mglass.css"/>
<link rel="stylesheet" href="./theme/css/pygment-solarized-dark.css"/>
<link rel="stylesheet" href="./theme/css/style.css"/>
<!-- Fonts -->
<link href='https://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'/>
<link href='https://fonts.googleapis.com/css?family=Istok+Web' rel='stylesheet' type='text/css'/>
<link href='https://fonts.googleapis.com/css?family=Droid+Sans+Mono' rel='stylesheet' type='text/css'/>
<link href='https://fonts.googleapis.com/css?family=Expletus+Sans' rel='stylesheet' type='text/css'>
<link rel="icon" href="./favicon.ico" type="image/x-icon">
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon">
<!-- Feeds -->
</head>
<body>
<div class="container">
<div class="page-header">
<a href="." class="avatar-container pull-left">
<div class="avatar animate ">
<div class="side"><img src="https://johngage.github.io/waterpowerdata/images/bluecircle.png" class="img-responsive"/></div>
<div class="side back"><p class="text-center">Water in Kibera</p></div>
</div>
</a>
<h1><a href=".">waterpower</a> <small>Water data and Jupyter notebooks</small></h1>
</div>
<nav class="navbar navbar-default">
<!-- Hamburger menu for mobile -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#plumage-navbar-collapse-1" aria-expanded="false">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="." title="Water data and Jupyter notebooks">waterpower</a>
</div>
<!-- Menus and search forms -->
<div class="collapse navbar-collapse" id="plumage-navbar-collapse-1">
<ul class="nav navbar-nav">
<li >
<a href="sitemap.xml">Index</a>
</li>
<li >
<a href="/">Home</a>
</li>
<li >
<a href="category/misc.html">Notebooks</a>
</li>
<li >
<a href="./pages/about.html">About</a>
</li>
<li >
<a href="./pages/book.html">Book</a>
</li>
<li >
<a href="./category/posts.html">posts</a>
</li>
<li class="active" >
<a href="./category/report.html">Report <span class="sr-only">(current)</span></a>
</li>
</ul>
<form class="navbar-form navbar-right" role="search" action="./search.html" onsubmit="return validateForm(this.elements['q'].value);">
<div class="form-group">
<div class="input-group">
<input type="text" name="q" id="tipue_search_input" class="form-control search-query" placeholder="Search" required />
<span class="input-group-btn">
<button class="btn btn-default" type="submit"><i class="fa
fa-search fa-fw"></i></button>
</span>
</div>
</div>
</form>
</div>
</nav>
</div>
<div class="container main">
<div class="row">
<div class=" col-md-6 col-md-offset-3 ">
<h1>
<a href="./ktc-water-data.html" rel="bookmark" title="Permalink to KTC Water Data"><span class="caps">KTC</span> Water Data</a>
</h1>
</div>
</div>
<div class="row">
<div class="col-md-3">
<!--<div data-spy="affix" data-offset-top="0">-->
<!--</div>-->
</div>
<div class=" col-md-6 " id="content" role="main">
<div>
<h2>How to understand water flows in Kibera</h2>
<p>There are only ten (10) numbers that are captured about water flow that are useful for the dashboard at the moment.</p>
<p>If you have other information, please share it.</p>
<ol>
<li>The hand-entered daily visual reading of the official water meter, known as the <span class="caps">WEDC</span> meter. Though there are manual entry errors, and gaps, this shows about 1,500 entries over time.</li>
</ol>
<p>Today’s reading was 70,029 liters pumped. The daily average for the 218 days of 2018 is 70,900 liters a day. That’s on the Googlesheet.</p>
<p>The <span class="caps">XIO</span> readings of:
2. Borehole Pump electrical current in amps: about 200,000 readings so far this year
3. Borehole flow in liters per minute: about 200,000 readings so far this year
4. Borehole tank level in meters: about 200,000 readings so far this year
5: <span class="caps">KTC</span> clean water pump electrical current in amps: about 200,000 readings this year
6. <span class="caps">KTC</span> Potable Water tank level in meters;
The other 15 <span class="caps">XIO</span> data feeds: hot water pump current, mezzanine tank level, etc, are not clearly labeled or calibrated.</p>
<p>For the energy-estimating <span class="caps">HOMER</span> model, we are moving some of the electrical current sensors to measure overall <span class="caps">KTC</span> power usage, and then measure a few feeds separately.</p>
<ol>
<li>
<p>The hand-entered Point of Sale numbers for jerry-can water sales, either at <span class="caps">KTC</span> or at the 10,000-liter tank at Olympic Primary.
These show sales of a few dozens of jerry cans. Fifty jerry cans is 1000 liters, so we sell a few thousand liters by jerry can, maximum.</p>
</li>
<li>
<p>The hand-entered Point of Sale numbers for bowser, or water-truck sales. These have dropped to almost zero, but have reached sales of ten or twenty thousand liters per day.</p>
</li>
<li>
<p>Estimates of water flow to Olympic School proper. Unclear to me where this data is held, and how it is acquired. I think Robert said he put a meter on the new tank for Olympic, but I didn’t see it. Please update with what you observed.</p>
</li>
<li>
<p>Daily power outages, now running at five a day. Over the past year, an average of two power outages a day, depending on how you treat outages that lasted several days. Clearly, this is the single dominant number for a dashboard attempting to capture how a service and retail business functions. No power, no product, no revenue, no customers. No meaning to marketing or sales initiatives, sales numbers or expenditures if you have no lights, power, Internet, or water pumped to showers or toilets.</p>
</li>
</ol>
<p>You mention other numbers that are unfamiliar.</p>
<p>What do you mean by “total potable water”? Are you referring to the <span class="caps">WEDC</span> meter reading for borehole water pumped? Or total water processed to remove fluoride? That’s a different, smaller number, since we use unprocessed well water to flush the toilets. What is the source of the data? Where is the data held?</p>
<p>What do you mean by “money earned from selling potable water at different kiosks”? What is this based on? Volume times price minus costs? There is an ancient spread sheet, manually entered, that made guesses in 2015 about costs and prices. Bad idea to use any ancient estimated cost data to estimate “money earned”. Might be useful to estimate “money received in payment”. What is the source, where is the data held? It costs us about <span class="caps">USD</span> $ 0.60/ 1000 liters to pump the water from the borehole, about <span class="caps">USD</span> $ 2.50/ 1000 liters to process into potable water.</p>
<p>What do you mean by “water being supplied to the school”? How is this measured? What is the source, where is the data held? What are the numbers?</p>
<p>So, after your trip, can you give a clear picture of where 70,000 liters of water a day is going?</p>
<p>It’s pretty clear that we process 20,000 liters of waste water a day from the showers and toilets. Then we throw the 20,000 liters of expensive, treated water away. It costs us about $2.50/ 1000 liters to process the water. That should be in the dashboard.</p>
<p>So, where are the other <span style="color:red"> <em>50,900</em> </span> liters a day going?</p>
<p>Exactly, where?</p>
<p>It’s been like this for three years.</p>
<p>Here is a work in progress to capture the <span class="caps">XIO</span> data from the real-time <span class="caps">XIO</span> web site. As you can see, one line of Python code brings in 525,000 readings at one-minute intervals of Borehole Pump current from 2017 and 2018. Five lines, and we have all the <span class="caps">XIO</span> data we need.</p>
<h4><span style="color:blue"> <em>Links to Jupyter Notebooks</em> </span></h4>
<p><span style="color:blue"> <a href="https://colab.research.google.com/drive/1XcQYlQx4mYPJjRZNO0gxnHKXhaJhBEgG#scrollTo=S6FGOF65K6Gd">Online Jupyter notebook analyzing <span class="caps">XIO</span> data</a> </span></p>
</div>
</div>
<div class="col-md-3">
<div class="well">
<p><abbr title="2018-08-31T00:00:00-07:00"><i class="fa fa-calendar"></i> (Fri) 2018-08-31</abbr></p>
<p><address>
<i class="fa fa-user"></i> By
<a href="./author/john-gage.html" rel="author">John Gage</a>
</address></p>
<hr/>
<p>
<a href="./category/report.html" rel="tag"
data-toggle="tooltip" class="label label-info"
title="2 articles in this category">Report</a>
<a href="/tag/water.html" data-toggle="tooltip"
class="label label-default"
title="1 article with this tag">Water</a>
</p>
<hr/>
<nav>
<ul class="pager">
<li class="previous ">
<a href="./data-analysis-links.html" title="Data analysis links" rel="prev">
<span aria-hidden="true">←</span> Older
</a>
</li>
<li class="next ">
<a href="./ktc-diagramclean-water.html" title="KTC Diagram:Clean Water" rel="next">
Newer <span aria-hidden="true">→</span>
</a>
</li>
</ul>
</nav>
</div>
</div>
</div>
</div>
<!-- TODO: make footer sticky -->
<footer class="container-fluid">
<div class="container">
<div class="row">
<div class="col-md-2">
<h5>Contact</h5>
<ul class="list-unstyled">
<li> <a href="mailto:[email protected]`">
<i class="fa fa-envelope"></i>
John Gage
</a></li>
<li> <a href="https://github.com/johngage">
<i class="fa fa-github"></i>
Github
</a></li>
<li> <a href="https://www.facebook.com/johnbgage/">
<i class="fa fa-external-link"></i>
Facebook
</a></li>
<li> <a href="https://twitter.com/johnbgage">
<i class="fa fa-twitter"></i>
Twitter
</a></li>
</ul>
</div>
<div class="col-md-2">
<h5>Resources</h5>
<ul class="list-unstyled">
<li> <a href="https://github.com/johngage">
<i class="fa fa-github"></i>
Repository
</a></li>
<li> <a href="https://docs.wradlib.org">
<i class="fa fa-external-link"></i>
Documentation
</a></li>
<li> <a href="https://groups.google.com/forum/?fromgroups=#!forum/wradlib-users">
<i class="fa fa-external-link"></i>
Data for Water
</a></li>
</ul>
</div>
<div class="col-md-2">
<h5>Browse content by</h5>
<ul class="list-unstyled">
</ul>
</div>
<div class="col-md-2 text-muted">
<h5>Copyright notice</h5>
<p>© Copyright 2017-2018 John Gage.</p>
</div>
<div class="col-md-2 text-muted">
<h5>Disclaimer</h5>
<p>All opinions expressed in this site are own personal opinions of the respective wradlib developers and are not endorsed by, nor do they represent the opinions of their previous, current and future employers or any of its affiliates, partners or customers.</p>
</div>
<div class="col-md-2">
</div>
</div>
</div>
<h5 class="text-right"><a href="#"><i class="fa fa-arrow-up"></i> Back to top</a></h5>
<div class="container">
<div class="row col-md-12 text-muted text-center">
Site generated by <a href="https://getpelican.com"> Pelican</a>.<br/>
<a href="https://github.com/kdeldycke/plumage"> Plumage</a> theme by <a href="https://kevin.deldycke.com">Kevin Deldycke</a>.
</div>
</div>
</footer>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.1.0/jquery.magnific-popup.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/fitvids/1.1.0/jquery.fitvids.min.js"></script>
<script src="./theme/js/jquery.mglass.js"></script>
<script src="./theme/js/application.js"></script>
</body>
</html>