Submission information
Submission Number: 7
Submission ID: 24
Submission UUID: a3c5f6ec-d079-40c4-8499-339de8cf3b46
Submission URI: /form/project
Created: Fri, 08/30/2019 - 11:06
Completed: Fri, 08/30/2019 - 11:18
Changed: Wed, 07/29/2020 - 21:36
Remote IP address: 130.215.55.243
Submitted by: Scott Valcourt
Language: English
Is draft: No
Webform: Project
| Project Title | Data Presentation for the Living Bridge |
|---|---|
| Program | Northeast |
| Project Leader | Scott Valcourt |
| scott.valcourt@unh.edu | |
| Mobile Phone | |
| Work Phone | 6038624489 |
| Mentor(s) | Scott Valcourt |
| Student-facilitator(s) | Viraj Salvi |
| Mentee(s) | |
| Project Description | The Memorial Bridge between Kittery, ME and Portsmouth, NH has several sensors on and below that collect data and record that data in an on-bridge database in a raw form. This project is extracting data from the on-bridge database into a new researcher-facing database that will offer publicly-available dataset extractions and on-server calculations for those researchers who wish to understand the work being done on the Living Bridge. The work in this project involves the understanding of the sensor data on the bridge, the existing schema of the database, developing a new schema for the researcher-facing database, and populating the database with data from the bridge. Future scope work will involve presenting and visualizing the bridge data as parameters are entered. |
| Project Deliverables | Database schema and working database that presents data to researchers both at UNH and beyond. |
| Project Deliverables | |
| Student Research Computing Facilitator Profile | Undergraduate or graduate student interested in database development and server operations. |
| Mentee Research Computing Profile | |
| Student Facilitator Programming Skill Level | |
| Mentee Programming Skill Level | |
| Project Institution | University of New Hampshire |
| Project Address | 268 MAST ROAD NHPTV Durham, New Hampshire. 03824 |
| Anchor Institution | NE-University of New Hampshire |
| Preferred Start Date | 10/01/2018 |
| Start as soon as possible. | |
| Project Urgency | |
| Expected Project Duration (in months) | |
| Launch Presentation | |
| Launch Presentation Date | |
| Wrap Presentation | |
| Wrap Presentation Date | |
| Project Milestones | |
| Github Contributions | |
| Planned Portal Contributions (if any) | While not in the CyberTeam portal, a new portal will involve the presentation of research data that will assist new researchers into the study of the Living Bridge. |
| Planned Publications (if any) | |
| What will the student learn? | The student will learn how to develop schemas for databases and understand how to engage with researchers to present raw data in a format that can be useful for discovery. |
| What will the mentee learn? | |
| What will the Cyberteam program learn from this project? | Understanding the mechanisms associated with data architecture could lead to the development of more common datasets that could blend data and lead to new discoveries. |
| HPC resources needed to complete this project? | Initially, none, but the future approach could involve the use of HPC to calculate models using the existing data from the bridge. |
| Notes | |
| What is the impact on the development of the principal discipline(s) of the project? | This project seeks to migrate and maintain a database of sensor data from the Memorial Bridge in Portsmouth, NH. Since the original database server had a hard drive failure, the current database design has been examined to support both the operational and analytical database needs, which indicate that two databases must be kept aligned. Students have been engaged in the network and database operations of the project, which includes the rewriting of the database schemas and the migration of the data from server to server. |
| What is the impact on other disciplines? | Power systems and civil engineering students have been extracting data from the analytical database to perform studies on the impact of the tidal water movement on the bridge mounts, as well as the amount of power that tidal flows are generating across the bridge-attached turbines. |
| Is there an impact physical resources that form infrastructure? | No. |
| Is there an impact on the development of human resources for research computing? | The initial project, funded through a NSF PFI-BIC award, did not consider the growth of integrated systems that collect and store data. The research computing personnel are considering what changes need to be instituted to maintain a robust database environment that supports all of the sensor system generating data. |
| Is there an impact on institutional resources that form infrastructure? | No. |
| Is there an impact on information resources that form infrastructure? | The data that has been generated by the Living Bridge project is available for download and examination by the public and is being used by NH students as a practical study of data. |
| Is there an impact on technology transfer? | Not at this time. |
| Is there an impact on society beyond science and technology? | Understanding what conditions are on this bridge, through the sensors and data collected, can lead to an understanding of what is happening on all other bridges in the country and could lead to better bridge design and mitigation. Bridges in tidal waters have an opportunity to consider what energy generation could be achieved through the implementation of tidal turbines in the same manner in which the Living Bridge is generating power. |
| Lessons Learned | |
| Overall results | The Living Bridge Project is giving students the ability to understand data collection, storage, movement, and analytics through the study of the sensor data and power generation outcomes on the Memorial Bridge in Portsmouth, NH. |