Water samples from natural recreational waters in San Mateo County are sampled each week for concentrations of indicator bacteria including E. Coli, Enterococcus, and Coliform bacteria. If concentrations of indicator bacteria exceed State or County standards, the area is posted to warn users that they may become ill if they engage in water contact activities in the posted area. More information about results and testing can be found on the San Mateo County Health System site: http://smchealth.org/environ/beaches This dataset contains readings from January, 2012 to the present and is updated weekly.
This dataset has the following 18 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Site Id | site_id | text | AB41131 AB41113 AB4114 AB4117 AB41126 view top 100 |
| Site Name | site_name | text | SAN VICENTE CREEK CALERA CREEK SAN PEDRO CREEK FRENCHMANS CREEK PILARCITOS CREEK view top 100 |
| Site Type | site_type | text | BEACH CREEK view top 100 |
| Process Date | process_da | calendar_date | 2019-10-03T00:00:00.000 2012-09-13T00:00:00.000 2012-08-30T00:00:00.000 2013-06-13T00:00:00.000 2013-06-20T00:00:00.000 view top 100 |
| Enterolert Enterococci Result | enterolert_enterococci_rst | number | 10.0 20.0 31.0 74 63.0 view top 100 |
| Colilert 18 E. Coli Result | colilert_18_e_coli_rslt | number | 10.0 20.0 41.0 31.0 52.0 view top 100 |
| Colilert 18 Total Coliform Result | colilert_18_total_coliform_rst | number | 10.0 24196.0 20.0 41.0 31.0 view top 100 |
| Enterolert Enterococci Posted | enterolert_enterococci_pst | text | N Y view top 100 |
| Colilert 18 E. Coli Posted | colilert_18_e_coli_pst | text | N Y view top 100 |
| Colilert 18 Total Coliform Posted | colilert_18_total_coliform_pst | text | N Y view top 100 |
| Enterolert Enterococci Qualifier | enterolert_enterococci_qfr | text | < > view top 100 |
| Colilert 18 E. Coli Qualifier | colilert_18_e_coli_qfr | text | < > view top 100 |
| Colilert 18 Total Coliform Qualifier | colilert_18_total_coliform_qfr | text | < > view top 100 |
| Location | location | point | {"coordinates":[-122.51782662352194,37.52419917189864],"type":"Point"} {"coordinates":[-122.49634347550025,37.611788761155495],"type":"Point"} {"coordinates":[-122.50555418949028,37.596159681072194],"type":"Point"} {"coordinates":[-122.45146439861297,37.480824106533454],"type":"Point"} {"coordinates":[-122.448999999108,37.476000000066286],"type":"Point"} view top 100 |
| location_address | location_address | text | 37 300074516597725 37 52419917189864 37 611788761155495 37 596159681072194 37 480824106533454 view top 100 |
| location_city | location_city | text | view top 100 |
| location_state | location_state | text | view top 100 |
| location_zip | location_zip | text | 94019 94060 94044 94038 view top 100 |