Open Collections

UBC Undergraduate Research

Trends and distribution of monthly water consumption in UBC Gage B Residence, 2010-2014 McGlenn, Stephen Oct 10, 2014

Your browser doesn't seem to have a PDF viewer, please download the PDF to view this item.

Item Metadata


18861-McGlenn_S_SEEDS_2014.pdf [ 263.03kB ]
JSON: 18861-1.0108754.json
JSON-LD: 18861-1.0108754-ld.json
RDF/XML (Pretty): 18861-1.0108754-rdf.xml
RDF/JSON: 18861-1.0108754-rdf.json
Turtle: 18861-1.0108754-turtle.txt
N-Triples: 18861-1.0108754-rdf-ntriples.txt
Original Record: 18861-1.0108754-source.json
Full Text

Full Text

 UBC Social Ecological Economic Development Studies (SEEDS) Student ReportStephen McGlennTrends and distribution of monthly water consumption in UBCGage B Residence, 2010-2014.PLAN 597October 10, 201411451691University of British Columbia Disclaimer: “UBC SEEDS provides students with the opportunity to share the findings of their studies, as well as their opinions, conclusions and recommendations with the UBC community. The reader should bear in mind that this is a student project/report and is not an official document of UBC. Furthermore readers should bear in mind that these reports may not reflect the current status of activities at UBC. We urge you to contact the research persons mentioned in a report or the SEEDS Coordinator about the current status of the subject matter of a project/report”.  	   1	  PLAN 597: Assignment 1. Instructor: Jordi Honey-Roses Trends and distribution of monthly water consumption in UBC Gage B Residence, 2010-2014. Stephen McGlenn. October.10.2014. Data collection process and challenges: Information on UBC Gage B residence was gathered from UBC Energy and Water Services. Fifty-eight data points were collected on the buildings’ monthly water consumption between December 2009 (the earliest available data) and September 2014. Erin Kastner (Geospatial Information Manager, UBC Energy and Water Services) provided access to monthly and quarterly data from physical copies of the buildings’ water meter readings. Monthly data was the only metric available, thus this document provides monthly analysis, extrapolating seasonal patterns. Several months (mostly in the summer) were not recorded. In order to demonstrate a consistent monthly trend in water consumption, these values were recorded at zero rather than left out, otherwise the next available reading would indicate more than one month of consumption and would skew the analysis. Other challenges arose in the analysis. For example, there was no reading taken for the ‘low’ meter in any of the months; a zero was written in for all low meter readings. The layout of the physical copy of the water meter readings made it difficult to distinguish that a zero from the ‘low’ column was not a part of the meters ‘high’ column read-out; as a result this extra zero was present at the end of all quarterly Excel data provided from 2010. This seemed to indicate that total consumption was somehow significantly higher in 2010 than any time beyond that. After receiving confirmation from UBC Energy and Water Services, removing these extra zeros showed the expected gradual increase in water consumption over time from Gage B residence. Data	  Analysis	  Monthly water consumption was calculated by subtracting each month’s water readings from the month that followed; for example, to calculate water consumption for February 2010, the water readings from January were subtracted from February to see the difference. This difference was then converted from cubic meters into cubic feet, at the request of Erin Kastner. The mean monthly consumption of water in Gage B Residence between December 2009 and September 2014 was 165,580 cubic feet of water, where as median consumption was 187,870 cubic feet. Variance was quite high, at 12,595,920 (a standard deviation of 112,230 cubic feet). Figure 1 below describes the distribution of months with high and low water consumption. Note that months with zero water consumption are most represented by the data; despite this, 26 months are below the mean, while 32 are above, indicating that, overall, monthly water consumption is above the mean.                  0	  2	  4	  6	  8	  10	  0	   25	   50	   75	   100	   125	   150	   175	   200	   225	   250	   275	   300	   325	   350	  #	  of	  months	  Water	  consumption	  (thousands	  of	  cubic	  feet)	  Figure	  1.	  Distribution	  of	  monthly	  water	  consumption,	  UBC	  Gage	  B	  Residence	  Mean	  consumption:	  165,580	  m3	  	   2	  Trends	  in	  Water	  Consumption	  Figure 2 below describes the buildings’ trends in water consumption from December 2009 to September 2014. The black trend line indicates a slight overall increase in water consumption since December 2009, while the orange line indicates the mean consumption. Large rises in consumption over the fall and winter each year, and the large dips mostly between May and September demonstrate high seasonal variability. February, April, and October tend to be the months with the highest consumption, while June and July are the most likely to have the least amount or no data recorded. While most of the missing data is for summer months, total water consumption still increased the least during these times. One might expect higher consumption of water in the hot, dry summer months; however, decreased water demand due to low student populations over the summer months could explain this. Other explanations might include summer maintenance work, or upgrades to the water system as part of UBC’s steam to hot water conversion project, construction of which likely happens during the summer months and would likely interrupt water supply.   In addition to this seasonal variation, there are also large variations within each season. The summer of 2013 had both the lowest below average consumption (133,750 cu. ft. below mean) and lowest total consumption (127,320 cu. ft); by comparison, the summer of 2012 had high variability in consumption levels and higher overall consumption (314,170 cu. ft.). Conversely, the fall and winter of 2011-2012 had the highest above average water consumption (98,900 cu. ft. above mean), yet the fall and winter of 2013-2014 had the highest total consumption (2,358,420 cu ft) of any season recorded, despite a significant drop in consumption in January 2014.  The renovation of the building (installation of low flow faucets and toilets) occurred in the summer of 2014. The data indicates that total water consumption for summer 2014 (394,430 cu. ft.) exceeds that of any other summer recorded. A possible explanation could be that, since fixtures now use less water, occupants feel less concerned about conserving water and end up using more (i.e. rebound effect). Other explanations could be that student population levels or construction patterns could have changed in 2014 compared to previous summers, resulting in both more supply and demand for water. In any case, more data collection and analysis is needed to arrive at any significant conclusions about long-term trends in overall consumption, and the effect of the buildings renovations on water consumption.          0.00	  50.00	  100.00	  150.00	  200.00	  250.00	  300.00	  350.00	  400.00	  15/01/2010	  15/03/2010	  15/05/2010	  15/07/2010	  15/09/2010	  15/11/2010	  15/01/2011	  15/03/2011	  15/05/2011	  15/07/2011	  15/09/2011	  15/11/2011	  15/01/2012	  15/03/2012	  15/05/2012	  15/07/2012	  15/09/2012	  15/11/2012	  15/01/2013	  15/03/2013	  15/05/2013	  15/07/2013	  15/09/2013	  15/11/2013	  15/01/2014	  15/03/2014	  15/05/2014	  15/07/2014	  15/09/2014	  Water	  consumption	  (thousands	  of	  cubic	  feet)	  Figure	  2.	  UBC	  Gage	  B	  Building	  Water	  consumption,	  January	  2010-­‐September	  2014	  Summer	  2014	  renovation	  


Citation Scheme:


Citations by CSL (citeproc-js)

Usage Statistics



Customize your widget with the following options, then copy and paste the code below into the HTML of your page to embed this item in your website.
                            <div id="ubcOpenCollectionsWidgetDisplay">
                            <script id="ubcOpenCollectionsWidget"
                            async >
IIIF logo Our image viewer uses the IIIF 2.0 standard. To load this item in other compatible viewers, use this url:


Related Items