This articles gives an overview of the data points that can be found in the Water Chemical Records.
Water chemicals are details of the water samples in the USGS water database. The chemical records break down the various chemicals detected in the samples analyzed.
USGS
- USGS Id: Unique identifier assigned by the USGS
Measurement Data
Chemical measurements include both raw and normalized values:
- Amount: Amount measured
- Amount mg/L: Amount normalized to milligrams per liter
- Units: Units measured
- Specific Gravity: Specific gravity measured
- Chemical: Name of the chemical or element
Dates
Several dates are tracked for each chemical record:
- Sample Date: When the water sample was collected
- Analysis Date: When the chemical analysis was performed
- Completion Date: When the well was completed
Records Management
Multiple identifiers are used to track and reference records:
- Well Id: Unique identifier for the well
- Simple Id: Integer-based well identifier for quick querying
- Id: Internal unique identifier for the record
- Internal Id: Integer-based record identifier for quick querying
- Date Catalogued: When the record entered the export database
- Date Created: When the record was first created in WellDatabase
- Date Last Modified: When the record was last modified
Data Model
The schema in our data model provides a complete and detailed framework for capturing and analyzing the data available in WellDatabase.
Explore other articles by searching the topics on the left or if you have any questions feel free to email support@welldatabase.com