Senior Design Projects

ECS193 A/B Winter & Spring 2019

UC Davis Water Dashboard

Name Kiernan Salmon
Affiliation Facilities Energy Conservation Office

Project's details

Project title UC Davis Water Dashboard
Background A Water Dashboard ( ) was built to help us track our water consumption against the UC Sustainable Practices Policy goals: to reduce our water consumption 20% by 2020 and 36% by 2025 ( compared to the average annual use from 2005 to 2008, normalized by population ). Since 2013, we have reduced our water use by 43%, well over our 2025 goal! The Water Dashboard was designed to help us track our progress to our goal, and since we’ve reached the goal we’re looking to reframe the dashboard to better suit our needs. On the front-end, we would like to update the aesthetics of the dashboard with a new and updated design. On the back-end, we’d like to enhance the process of adding new data to the dashboard with a database and interface for our staff to use. The existing Water Dashboard at, includes a combination of graphs from Tableau and Highcharts graphs.
Description Students working on this project will implement the front and back-end designs for an updated Water Dashboard. This dashboard will be public facing for the university, and should also include a new interface to be used internally by our Utilities Data & Engineering team to keep the dashboard’s data up to date. The student team will implement the Water Dashboard under the following requirements: MERN Stack: MongoDB, Express.js, React, Node.js Hosting on Amazon Web Services Weekly code reviews by UC Davis web developers Querying data from the OSIsoft PI System database
Deliverable We expect a dashboard that is ready to be published for campus viewing. Accompanying the dashboard will be an administrators application for the Utilities Data & Engineering team to update the dashboard's data. The dashboard should follow the aesthetic design of the mockups and pass user acceptance testing for functionality. The updated Water Dashboard will go through a review process by UC Davis web developers, before being on-boarded for hosting in a production environment.
Skill set desirable Quick learners and time to put into the project, there is a technology stack we must stick to. Students with some experience using a MERN stack is preferred, but not required.
Phone number 925-323-5489
Client time availability 30-60 min weekly or more
IP requirement Client wishes to keep IP of the project
Attachment Click here
Selected N/A
Stuff N/A