Ramsey County regularly tests beaches for water quality during beach season, from June through August each year. Ramsey County uses the state E. coli water quality standard to identify water bodies that may be contaminated with fecal waste. Higher levels of E. coli in the water may or may not be accompanied by higher levels and an increased risk of harmful bacteria; varying survival rates of bacteria make is impossible to definitively state when these harmful bacteria are present. Two samples are taken from each Ramsey County beach weekly to test E. coli levels.
This dataset has the following 13 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Date | date | calendar_date | 2022-07-19T00:00:00.000 2022-08-30T00:00:00.000 2024-05-21T00:00:00.000 2020-08-11T00:00:00.000 2021-08-03T00:00:00.000 view top 100 | |
Beach | beach | text | Lake McCarrons Lake Owasso Lake Johanna Lake Gervais Lake Josephine view top 100 | |
Status | status | text | Open Closed view top 100 | |
Test 1/Site 1 | test_1_site_1 | number | Colony Forming Units (CFU) per 100 milliliters of water | 1 2 4.1 3.1 5.2 view top 100 |
Test 2/Site 2 | test_2_site_2 | number | Colony Forming Units (CFU) per 100 milliliters of water | 1 2 3.1 5.2 4.1 view top 100 |
Sample Mean | sample_mean | number | Mean of sample 1 and sample 2 | 1.0 1.4 2.0 2.5 1.7 view top 100 |
30 Day Sample Mean | _30_day_sample_mean | number | sample mean over 30 days | 3 2.3 3.7 3.5 3.4 view top 100 |
Address | address | text | 1795 North Rice Street, Roseville, MN 55113 3500 Lake Johanna Boulevard, Arden Hills, MN 55112 370 North Owasso Boulevard, Shoreview, MN 55126 2420 Edgerton Street, Little Canada, MN 55117 3027 Lexington Avenue North, Roseville, MN 55113 view top 100 | |
Sampling Site ID | sampling_site_id | text | 62-0054-00-203 62-0078-00-205 62-0056-00-216 62-0061-00-209 62-0067-00-117 view top 100 | |
Latitude | latitude | number | 45.06877017 45.0474925387 45.0420382997 45.013717779 45.0942619502 view top 100 | |
Longitude | longitude | number | -93.1149667218 -93.1757748861 -92.9966451326 -93.0535894157 -93.1076142549 view top 100 | |
New Georeferenced Column | geocoded_column | point | {"coordinates":[-93.1149667218,45.0420382997],"type":"Point"} {"coordinates":[-93.1757748861,45.0474925387],"type":"Point"} {"coordinates":[-93.0535894157,44.983040738],"type":"Point"} {"coordinates":[-92.9966451326,45.0942619502],"type":"Point"} {"coordinates":[-93.1227803144,45.0682052115],"type":"Point"} view top 100 | |
Upload date | upload_date | date | 2022-07-06T20:51:29.763Z 2022-07-06T20:58:20.227Z 2022-07-13T18:35:02.394Z 2022-07-21T15:33:48.411Z 2022-07-27T20:08:54.063Z view top 100 |