Example groundwater level data
example_data.RdExample data from site 263819081585801 L-2701. Data is a named list of "Daily" for daily groundwater level at the site and "Discrete" for discrete groundwater level measurements from the site. Updated April 9, 2021.
Examples
head(L2701_example_data$Daily)
#> # A tibble: 6 × 11
#> daily_id time_series_id parameter_code value unit_of_measure
#> <chr> <chr> <chr> <dbl> <chr>
#> 1 6f67bbd2-2872-4e6e-b6dd-e… 28d8a99d3dbd4… 62610 -5.58 ft
#> 2 0673d693-c0cc-4b65-8b69-6… 28d8a99d3dbd4… 62610 -5.16 ft
#> 3 6a7e071b-ae1f-4f94-97c3-7… 28d8a99d3dbd4… 62610 -4.79 ft
#> 4 ebb0a6cf-ab33-45ce-ae97-0… 28d8a99d3dbd4… 62610 -4.54 ft
#> 5 1b5c5f10-2495-4149-b779-b… 28d8a99d3dbd4… 62610 -4.57 ft
#> 6 68331212-03f6-4662-84e3-0… 28d8a99d3dbd4… 62610 -4.91 ft
#> # ℹ 6 more variables: last_modified <dttm>, statistic_id <chr>,
#> # monitoring_location_id <chr>, time <date>, approval_status <chr>,
#> # qualifier <chr>
head(L2701_example_data$Discrete)
#> # A tibble: 6 × 14
#> field_measurement_id field_visit_id parameter_code observing_procedure_…¹
#> <chr> <chr> <chr> <chr>
#> 1 248a7cb9-94ca-4cd3-94c8-… c33d4349-665c… 72019 S
#> 2 dbbdd939-f3a8-4ee4-95f6-… c33d4349-665c… 62610 S
#> 3 fc0370cb-51bc-4c01-9b04-… c33d4349-665c… 62611 S
#> 4 216d42b7-79f2-440e-9474-… 69191e62-6119… 72019 S
#> 5 ac35ca42-e6d8-42bd-bd23-… 69191e62-6119… 62610 S
#> 6 e6fee5cc-fe1b-46c8-ba95-… 69191e62-6119… 62611 S
#> # ℹ abbreviated name: ¹observing_procedure_code
#> # ℹ 10 more variables: value <dbl>, time <dttm>, vertical_datum <chr>,
#> # measuring_agency <chr>, monitoring_location_id <chr>,
#> # observing_procedure <chr>, unit_of_measure <chr>, approval_status <chr>,
#> # last_modified <dttm>, qualifier <chr>
head(L2701_example_data$QW)
#> OrganizationIdentifier OrganizationFormalName ActivityIdentifier
#> 1 USGS-FL USGS Florida Water Science Center nwisfl.01.97806444
#> 2 USGS-FL USGS Florida Water Science Center nwisfl.01.97904554
#> 3 USGS-FL USGS Florida Water Science Center nwisfl.01.97904554
#> 4 USGS-FL USGS Florida Water Science Center nwisfl.01.98103956
#> 5 USGS-FL USGS Florida Water Science Center nwisfl.01.98103956
#> 6 USGS-FL USGS Florida Water Science Center nwisfl.01.98103956
#> ActivityTypeCode ActivityMediaName ActivityMediaSubdivisionName
#> 1 Sample-Routine Water Groundwater
#> 2 Sample-Routine Water Groundwater
#> 3 Sample-Routine Water Groundwater
#> 4 Sample-Routine Water Groundwater
#> 5 Sample-Routine Water Groundwater
#> 6 Sample-Routine Water Groundwater
#> ActivityStartDate ActivityStartTime.Time ActivityStartTime.TimeZoneCode
#> 1 1978-09-06 16:30:00 EDT
#> 2 1979-05-09 15:00:00 EDT
#> 3 1979-05-09 15:00:00 EDT
#> 4 1981-05-20 14:15:00 EDT
#> 5 1981-05-20 14:15:00 EDT
#> 6 1981-05-20 14:15:00 EDT
#> ActivityEndDate ActivityEndTime.Time ActivityEndTime.TimeZoneCode
#> 1 <NA> <NA> <NA>
#> 2 <NA> <NA> <NA>
#> 3 <NA> <NA> <NA>
#> 4 <NA> <NA> <NA>
#> 5 <NA> <NA> <NA>
#> 6 <NA> <NA> <NA>
#> ActivityDepthHeightMeasure.MeasureValue
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> ActivityDepthHeightMeasure.MeasureUnitCode
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> ActivityDepthAltitudeReferencePointText
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> ActivityTopDepthHeightMeasure.MeasureValue
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> ActivityTopDepthHeightMeasure.MeasureUnitCode
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> ActivityBottomDepthHeightMeasure.MeasureValue
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> ActivityBottomDepthHeightMeasure.MeasureUnitCode ProjectIdentifier
#> 1 <NA> <NA>
#> 2 <NA> <NA>
#> 3 <NA> <NA>
#> 4 <NA> <NA>
#> 5 <NA> <NA>
#> 6 <NA> <NA>
#> ActivityConductingOrganizationText
#> 1 U.S. Geological Survey-Water Resources Discipline
#> 2 U.S. Geological Survey-Water Resources Discipline
#> 3 U.S. Geological Survey-Water Resources Discipline
#> 4 U.S. Geological Survey-Water Resources Discipline
#> 5 U.S. Geological Survey-Water Resources Discipline
#> 6 U.S. Geological Survey-Water Resources Discipline
#> MonitoringLocationIdentifier ActivityCommentText SampleAquifer
#> 1 USGS-263819081585801 <NA> Hawthorn Limestone Aquifer
#> 2 USGS-263819081585801 <NA> Hawthorn Limestone Aquifer
#> 3 USGS-263819081585801 <NA> Hawthorn Limestone Aquifer
#> 4 USGS-263819081585801 <NA> Hawthorn Limestone Aquifer
#> 5 USGS-263819081585801 <NA> Hawthorn Limestone Aquifer
#> 6 USGS-263819081585801 <NA> Hawthorn Limestone Aquifer
#> HydrologicCondition HydrologicEvent SampleCollectionMethod.MethodIdentifier
#> 1 Not determined Routine sample USGS
#> 2 Not determined Routine sample USGS
#> 3 Not determined Routine sample USGS
#> 4 Not determined Routine sample USGS
#> 5 Not determined Routine sample USGS
#> 6 Not determined Routine sample USGS
#> SampleCollectionMethod.MethodIdentifierContext
#> 1 USGS
#> 2 USGS
#> 3 USGS
#> 4 USGS
#> 5 USGS
#> 6 USGS
#> SampleCollectionMethod.MethodName SampleCollectionEquipmentName
#> 1 USGS Unknown
#> 2 USGS Unknown
#> 3 USGS Unknown
#> 4 USGS Unknown
#> 5 USGS Unknown
#> 6 USGS Unknown
#> ResultDetectionConditionText CharacteristicName ResultSampleFractionText
#> 1 <NA> Chloride Dissolved
#> 2 <NA> Specific conductance Total
#> 3 <NA> Chloride Dissolved
#> 4 <NA> Specific conductance Total
#> 5 <NA> Chloride Dissolved
#> 6 <NA> Specific conductance Total
#> ResultMeasureValue ResultMeasure.MeasureUnitCode MeasureQualifierCode
#> 1 52 mg/l <NA>
#> 2 580 uS/cm @25C <NA>
#> 3 50 mg/l <NA>
#> 4 535 uS/cm @25C <NA>
#> 5 54 mg/l <NA>
#> 6 537 uS/cm @25C <NA>
#> ResultStatusIdentifier StatisticalBaseCode ResultValueTypeName
#> 1 Preliminary <NA> Actual
#> 2 Historical <NA> Actual
#> 3 Preliminary <NA> Actual
#> 4 Historical <NA> Actual
#> 5 Preliminary <NA> Actual
#> 6 Historical <NA> Actual
#> ResultWeightBasisText ResultTimeBasisText ResultTemperatureBasisText
#> 1 <NA> <NA> <NA>
#> 2 <NA> <NA> 25 deg C
#> 3 <NA> <NA> <NA>
#> 4 <NA> <NA> 25 deg C
#> 5 <NA> <NA> <NA>
#> 6 <NA> <NA> 25 deg C
#> ResultParticleSizeBasisText PrecisionValue ResultCommentText USGSPCode
#> 1 <NA> NA <NA> 00940
#> 2 <NA> NA <NA> 00095
#> 3 <NA> NA <NA> 00940
#> 4 <NA> NA <NA> 00095
#> 5 <NA> NA <NA> 00940
#> 6 <NA> NA <NA> 90095
#> ResultDepthHeightMeasure.MeasureValue
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> ResultDepthHeightMeasure.MeasureUnitCode
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> ResultDepthAltitudeReferencePointText SubjectTaxonomicName
#> 1 <NA> <NA>
#> 2 <NA> <NA>
#> 3 <NA> <NA>
#> 4 <NA> <NA>
#> 5 <NA> <NA>
#> 6 <NA> <NA>
#> SampleTissueAnatomyName ResultAnalyticalMethod.MethodIdentifier
#> 1 <NA> <NA>
#> 2 <NA> <NA>
#> 3 <NA> <NA>
#> 4 <NA> <NA>
#> 5 <NA> <NA>
#> 6 <NA> <NA>
#> ResultAnalyticalMethod.MethodIdentifierContext
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> ResultAnalyticalMethod.MethodName MethodDescriptionText LaboratoryName
#> 1 <NA> <NA> <NA>
#> 2 <NA> <NA> <NA>
#> 3 <NA> <NA> <NA>
#> 4 <NA> <NA> <NA>
#> 5 <NA> <NA> <NA>
#> 6 <NA> <NA> <NA>
#> AnalysisStartDate ResultLaboratoryCommentText
#> 1 <NA> <NA>
#> 2 <NA> <NA>
#> 3 <NA> <NA>
#> 4 <NA> <NA>
#> 5 <NA> <NA>
#> 6 <NA> <NA>
#> DetectionQuantitationLimitTypeName
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> DetectionQuantitationLimitMeasure.MeasureValue
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> DetectionQuantitationLimitMeasure.MeasureUnitCode PreparationStartDate
#> 1 <NA> <NA>
#> 2 <NA> <NA>
#> 3 <NA> <NA>
#> 4 <NA> <NA>
#> 5 <NA> <NA>
#> 6 <NA> <NA>
#> ProviderName ActivityStartTime.TimeZoneCode_offset ActivityStartDateTime
#> 1 NWIS 4 1978-09-06 20:30:00
#> 2 NWIS 4 1979-05-09 19:00:00
#> 3 NWIS 4 1979-05-09 19:00:00
#> 4 NWIS 4 1981-05-20 18:15:00
#> 5 NWIS 4 1981-05-20 18:15:00
#> 6 NWIS 4 1981-05-20 18:15:00