San Diego Beachwatch Data

ceden.waterboards.ca.gov-beachwatch-sandiego-2 Last Modified: 2018-08-09 14:59

Water quality data for San Diego county beaches.

San Diego Beachwatch Data

The Beachwatch data set has four bacteria measurements from 172 stations on the coast of San Diego county, from July 1998 to Decenber 2013. The four measurements are:

  • Coliform, Total 66992
  • Coliform, Fecal 65827
  • Enterococcus 65010
  • E. coli 4428

There are two units for the measurements:

  • MPN/100 mL: "Most Probable Number"
  • cfu/100mL: "Colony forming units". Number of viable bacteria, excluding the dead ones.

From Cascade Analytical:

What does CFU and MPN mean? A: CFU stands for 'Colony Forming Units' and
refers to the number of viable bacterial cells in a sample per unit of
volume. For example: 50 CFU/100 mL means 50 Colony Forming Units per 100 mL
of sample. It is different from the direct microscopic counts that include
both dead and living cells.

MPN stands for 'Most Probable Number' and refers to a method that uses
dilution cultures and a probability calculation to determine the
approximate number of viable cells in a given volume of sample. It is
useful when samples contain too few organisms for agar plates to be used or
when organisms will not grow on agar. For example: 50 MPN/100 mL means that
the Most Probable Number of viable cells in 100 mL of sample is 50.

I haven't found traditional data dictionary documentation, but there are controlled vocabulary lists online for data submitters, which explain a lot of the columns.

Documentation Links

overview : Project Overview Page

source_page : CEDEN advanced query tool page

controlled_vocab : Controlled vocabulary search page

analyte_cv : Analyte controlled vocabulary

method_cv : Method controlled vocabulary

result_qual_cv : Result Qualifier controlled vocabulary

qa_cv : QA controlled vocabulary

Contacts

Wrangler : Eric Busboom, Civic Knowledge


Loading the ZIP Package

Zip packages are compressed, so large resources may load faster.

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/ceden.waterboards.ca.gov-beachwatch-sandiego-2.zip')

Loading the CSV Package

CSV packages load resources individually, so small resources may load faster.

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/ceden.waterboards.ca.gov-beachwatch-sandiego-2.csv')

Data and Resources

Additional Info

Field Value
Version 2
Last Updated August 9, 2018, 14:59 (UTC)
Created July 16, 2018, 14:57 (UTC)
root.ckanid c2980d83-29eb-41a0-8261-1ccf2c2f83ed
root.created 2018-07-15T17:45:00
root.dataset beachwatch
root.declare metatab-latest
root.description Water quality data for San Diego county beaches.
root.giturl https://github.com/san-diego-water-quality/water-datasets.git
root.group natural-environment
root.identifier 585e2989-eb46-4533-97cd-d684ab122c6a
root.issued 2018-08-09T14:59:01
root.modified 2018-08-09T14:59:01
root.name ceden.waterboards.ca.gov-beachwatch-sandiego-2
root.origin ceden.waterboards.ca.gov
root.space sandiego
root.tag water-project
root.title San Diego Beachwatch Data
root.version 2