Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...

Water Quality Data - RAPID Maria Project

Owners: This resource does not have an owner who is an active HydroShare user. Contact CUAHSI ( for information on this resource.
Type: Resource
Storage: The size of this resource is 3.3 MB
Created: Feb 17, 2019 at 3:22 a.m.
Last updated: Feb 27, 2019 at 8:19 p.m.
Citation: See how to cite this resource
Sharing Status: Public
Views: 3186
Downloads: 148
+1 Votes: Be the first one to 
Comments: No comments (yet)


Hurricane Maria is an example of a natural disaster that caused disruptions to infrastructure resulting in concerns with water treatment failures and potential contamination of drinking water supplies. This dataset is focused on the water quality data collected in Puerto Rico after Hurricane Maria and is part of the larger collaborative RAPID Hurricane Maria project.

This resource consists of Excel workbooks and a SQLite database. Both were populated with data and metadata corresponding to discrete water quality analysis of drinking water systems in Puerto Rico impacted by Hurricane Maria collected as part of the RAPID Maria project. Sampling and analysis was performed by a team from Virginia Tech in February-April 2018. Discrete samples were collected and returned to the lab for ICPMS analysis. Sampling was also conducted in the field for temperature, pH, free and total chlorine, turbidity, and dissolved oxygen. Complete method and variable descriptions are contained in the workbooks and database. There are two separate workbooks: one for ICPMS data and one for field data. All results are contained in the single database. Sites were sampled corresponding to several water distribution systems and source streams in southwestern Puerto Rico. Coordinates are included for the stream sites, but to preserve the security of the water distribution sites, the locations are only identified as within Puerto Rico.

The workbooks follow the specifications for YAML Observations Data Archive (YODA) exchange format ( The workbooks are templates with sheets containing tables that are mapped to entities in the Observations Data Model 2 (ODM2 - Each sheet in the workbook contains directions for its completion and brief descriptions of the attributes. The data in the sheets was converted to an SQLite database following the ODM2 schema that is also contained in this resource. Conversion was performed using a prototype Python translation software (

Subject Keywords



Coordinate System/Geographic Projection:
WGS 84 EPSG:4326
Coordinate Units:
Decimal degrees
Place/Area Name:
southwest Puerto Rico
North Latitude
East Longitude
South Latitude
West Longitude


Start Date:
End Date:



Funding Agencies

This resource was created using funding from the following sources:
Agency Name Award Title Award Number
National Science Foundation RAPID: COLLABORATIVE RESEARCH: Building Infrastructure to Prevent Disasters like Hurricane Maria 1810802


People or Organizations that contributed technically, materially, financially, or provided general support for the creation of the resource's content but are not considered authors.

Name Organization Address Phone Author Identifiers
Jeffrey Parks Virginia Polytechnic Institute and State University
William Rhoads Virginia Polytechnic Institute and State University

How to Cite

Jones, A., W. Rhoads, J. S. Horsburgh (2019). Water Quality Data - RAPID Maria Project, HydroShare,

This resource is shared under the Creative Commons Attribution CC BY.


There are currently no comments

New Comment