San Diego Beachwatch Data

Last Modified: 2018-08-09 05:20

Water quality data for San Diego county beaches.

Documentation

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

Resources

beachwatch-sd: file:///Users/eric/proj/virt-proj/water/water-datasets/source/ceden.waterboards.ca.gov-beachwatch-sandiego/data/beachwatch-sd.csv
Beachwatch program for San Diego county

Identity

name: ceden.waterboards.ca.gov-beachwatch-sandiego-2
identifier: 585e2989-eb46-4533-97cd-d684ab122c6a

Contacts

Wrangler: Eric Busboom, Civic Knowledge

beachwatch-sd

file:///Users/eric/proj/virt-proj/water/water-datasets/source/ceden.waterboards.ca.gov-beachwatch-sandiego/data/beachwatch-sd.csv

Beachwatch program for San Diego county

Header Datatype Description
program string program

parentproject string parentproject

project string project

stationname string stationname

stationcode string stationcode

sampledate date sampledate

collectiontime time collectiontime

locationcode string locationcode

collectiondepth integer collectiondepth

unitcollectiondepth string unitcollectiondepth

sampletypecode string sampletypecode

collectionreplicate integer collectionreplicate

resultsreplicate integer resultsreplicate

labbatch string labbatch

labsampleid string labsampleid

matrixname string matrixname

methodname string methodname

analyte string analyte

unit string unit

result integer result

observation string observation

mdl integer mdl

rl integer rl

resultqualcode string resultqualcode

qacode string qacode

batchverification string batchverification

compliancecode string compliancecode

samplecomments string samplecomments

collectioncomments string collectioncomments

resultscomments string resultscomments

batchcomments string batchcomments

eventcode string eventcode

protocolcode string protocolcode

sampleagency string sampleagency

groupsamples string groupsamples

collectionmethodname string collectionmethodname

targetlatitude number targetlatitude

targetlongitude number targetlongitude

collectiondevicedescription string collectiondevicedescription

calibrationdate string calibrationdate

positionwatercolumn string positionwatercolumn

preppreservationname string preppreservationname

preppreservationdate string preppreservationdate

digestextractmethod string digestextractmethod

digestextractdate string digestextractdate

analysisdate string analysisdate

dilutionfactor integer dilutionfactor

expectedvalue integer expectedvalue

labagency string labagency

submittingagency string submittingagency

submissioncode string submissioncode

occupationmethod string occupationmethod

startingbank string startingbank

distancefrombank string distancefrombank

unitdistancefrombank string unitdistancefrombank

streamwidth string streamwidth

unitstreamwidth string unitstreamwidth

stationwaterdepth string stationwaterdepth

unitstationwaterdepth string unitstationwaterdepth

hydromod string hydromod

hydromodloc string hydromodloc

locationdetailwqcomments string locationdetailwqcomments

channelwidth string channelwidth

upstreamlength string upstreamlength

downstreamlength string downstreamlength

totalreach string totalreach

locationdetailbacomments string locationdetailbacomments

county string

county_fips integer

regional_board string

rb_number integer

huc8 string

huc8_number string

huc10 string

huc10_number string

huc12 string

huc12_number string

waterbody_type string

sampleid string sampleid

Header	Datatype	Description
program	string	program
parentproject	string	parentproject
project	string	project
stationname	string	stationname
stationcode	string	stationcode
sampledate	date	sampledate
collectiontime	time	collectiontime
locationcode	string	locationcode
collectiondepth	integer	collectiondepth
unitcollectiondepth	string	unitcollectiondepth
sampletypecode	string	sampletypecode
collectionreplicate	integer	collectionreplicate
resultsreplicate	integer	resultsreplicate
labbatch	string	labbatch
labsampleid	string	labsampleid
matrixname	string	matrixname
methodname	string	methodname
analyte	string	analyte
unit	string	unit
result	integer	result
observation	string	observation
mdl	integer	mdl
rl	integer	rl
resultqualcode	string	resultqualcode
qacode	string	qacode
batchverification	string	batchverification
compliancecode	string	compliancecode
samplecomments	string	samplecomments
collectioncomments	string	collectioncomments
resultscomments	string	resultscomments
batchcomments	string	batchcomments
eventcode	string	eventcode
protocolcode	string	protocolcode
sampleagency	string	sampleagency
groupsamples	string	groupsamples
collectionmethodname	string	collectionmethodname
targetlatitude	number	targetlatitude
targetlongitude	number	targetlongitude
collectiondevicedescription	string	collectiondevicedescription
calibrationdate	string	calibrationdate
positionwatercolumn	string	positionwatercolumn
preppreservationname	string	preppreservationname
preppreservationdate	string	preppreservationdate
digestextractmethod	string	digestextractmethod
digestextractdate	string	digestextractdate
analysisdate	string	analysisdate
dilutionfactor	integer	dilutionfactor
expectedvalue	integer	expectedvalue
labagency	string	labagency
submittingagency	string	submittingagency
submissioncode	string	submissioncode
occupationmethod	string	occupationmethod
startingbank	string	startingbank
distancefrombank	string	distancefrombank
unitdistancefrombank	string	unitdistancefrombank
streamwidth	string	streamwidth
unitstreamwidth	string	unitstreamwidth
stationwaterdepth	string	stationwaterdepth
unitstationwaterdepth	string	unitstationwaterdepth
hydromod	string	hydromod
hydromodloc	string	hydromodloc
locationdetailwqcomments	string	locationdetailwqcomments
channelwidth	string	channelwidth
upstreamlength	string	upstreamlength
downstreamlength	string	downstreamlength
totalreach	string	totalreach
locationdetailbacomments	string	locationdetailbacomments
county	string
county_fips	integer
regional_board	string
rb_number	integer
huc8	string
huc8_number	string
huc10	string
huc10_number	string
huc12	string
huc12_number	string
waterbody_type	string
sampleid	string	sampleid