Data Presentation for the Living Bridge

Project Information

data-wrangling, storage, hardware, hpc-storage, vpn, ssh, distributed-computing
Project Status: Complete
Project Region: Northeast
Submitted By: Scott Valcourt
Project Email: scott.valcourt@unh.edu
Project Institution: University of New Hampshire
Anchor Institution: NE-University of New Hampshire
Project Address: 268 MAST ROAD
NHPTV
Durham, New Hampshire. 03824

Mentors: Scott Valcourt
Students: Viraj Salvi

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 Information

data-wrangling, storage, hardware, hpc-storage, vpn, ssh, distributed-computing
Project Status: Complete
Project Region: Northeast
Submitted By: Scott Valcourt
Project Email: scott.valcourt@unh.edu
Project Institution: University of New Hampshire
Anchor Institution: NE-University of New Hampshire
Project Address: 268 MAST ROAD
NHPTV
Durham, New Hampshire. 03824

Mentors: Scott Valcourt
Students: Viraj Salvi

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.