beachwatch

URL: http://library.metatab.org/sandiegodata.org-beachwatch-4/data/beachwatch.csv

Beachwatch data, with features added. 35 Columns.

  • stationcode (string): Short name for the station
  • stationgroup (string): First two characters of station code
  • sampledate (datetime): Date sample was taken
  • collectiontime (time): Time sample was taken
  • measure_code (integer): Reference to the measure codes, the unique groups of analyte, mehodname and unit.
  • analyte (string): The type of bacterial being measured, for coliform, total coliform, Enterococcus or E. coli.
  • methodname (string): Method used to count bacteria, such as “MTF”, “SM 9222 B” or “Enterolert”
  • unit (string): Measurement units, type of count per 100 ml.
  • result (integer): Measured value
  • result_group_count (integer): Number of records in this measurement group
  • result_group_std (number): Standard deviation for this group
  • result_group_mean (number): Mean for this group
  • result_group_25pctl (number): 25th percentile for this group
  • result_group_median (number): Median for this group
  • result_group_75pctl (number): 75th percentile for this group
  • result_gt_median (number): 1 if the result is greater than the median, 0 otherwise
  • result_gt_mean (number): 1 if the result is greater than the mean, 0 otherwise
  • result_lte_25pctl (number): 1 if the result is less than or equal to the 25th percentile, 0 otherwise
  • result_gte_75pctl (number): 1 if the result is greater than or equal to the 75th percentile, 0 otherwise
  • lresult (number): Log of measured value
  • lresult_group_std (number): Standard deviation of log(result) for this group
  • lresult_group_mean (number): Mean of log(result) for this group
  • lresult_group_25pctl (number): 25th percentile of log(result) for this group
  • lresult_group_median (number): Median of log(result) for this group
  • lresult_group_75pctl (number): 75th percentile of log(result) for this group
  • lresult_gt_lmedian (number): 1 if the result is greater than the median of log(result) , 0 otherwise
  • lresult_gt_lmean (number): 1 if the result is greater than the mean of log(result) , 0 otherwise
  • lresult_lte_25pctl (number): 1 if the result is less than or equal to the 25th percentile of log(result) , 0 otherwise
  • lresult_gte_75pctl (number): 1 if the result is greater than or equal to the 75th percentile of log(result) , 0 otherwise
  • labbatch (string): Identifier of the processing group in the lab
  • resultqualcode (string): Result Qualifier code. See result_qual_cv documentation
  • qacode (string): QA code. See qa_cv documentation
  • sampleagency (string): Code for agency that took the sample
  • labagency (string): Code for agency that analyzed sample
  • submittingagency (string): Code for agency that submitted sample to lab

There are no views created for this resource yet.

Additional Information

Field Value
Last updated August 10, 2018
Created August 10, 2018
Format text/csv
License No License Provided
created8 months ago
formatCSV
id61b13c2a-40bc-4fe4-a3c9-92285d373784
mimetypetext/csv
package id083b5c5a-d869-4562-a643-a00ee42462a2
position4
revision idcd14913c-5f58-45e4-acbc-d8e7f306942d
stateactive