The VCRWS Infrastructure Data Model (IDM) Robert Traver, - PowerPoint PPT Presentation

The VCRWS Infrastructure Data Model (IDM) Robert Traver, Virginia Smith, Michael Newman, Andrew Kurzweil, and Matthew McGauley October, 2019

Data, Data Everywhere

How to Manage an Abundance of Data? 3 Harnessing the Data Revolution (HDR), NSF (2019)

Data through Time and Space 4 Community Observations Data Model (ODM) Version 1.1 Design Specifications , CUAHSI (2008)

CUAHSI’s Observations Data Model (ODM) 5 Observations Data Model Schema, CUAHSI (2009)

VCRWS HydroServer 6

Database Features • Data Uploads • 8,000,000 values/minute • Data upload log • Data Retrieval • 30,000,000 values/minute • Retrieves data through a Query Builder Provides plots on the fly • Provides summary statistics • Allows user to download data as a .csv file • • Data sharing • Different levels of users • Able to share limit ranges of data 7

Using VCRWS HydroServer 8

Querying the IDM 9

Querying the IDM 10

Querying the IDM 11

So? 12

2019 Stormwater Management Symposium Building Resilience into Stormwater Partners MEMBERS FRIENDS Jacobs Gannett Fleming Geosyntec Michael Baker Sci-Tek Consultants Princeton Hydro T&M Associates

Questions Virginia Smith Virginia.Smith@Villanova.edu 14