search

usgs-makerspace / makerspace-sandbox

Some initial R code for playing with data processing (maybe some light visualization).
Other
0 stars 5 forks source link

Explore data on a storm propagating salt through the network #293

Closed lindsayplatt closed 4 years ago

lindsayplatt commented 4 years ago

Choose a few NGWOS sites & play with specific conductivity data

mhines-usgs commented 4 years ago

did some brief googling this afternoon for ideas (these are less related to propagating salt through network and more on the so what)

salt pollution in freshwater https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0221355 leads to higher cyanobacteria levels (harmful algal blooms) - could we find data that correlates between salt leves in lake erie (or near by gages) along with hab outbreaks?

pdf with impacts on freshwater animals and habitats (marshes) https://seagrant.psu.edu/file/1884/download?token=qjJeoJVS - at certain saline levels, fish will die, frogs will die, etc. landcover changes from historic native types to certain tolerant grasses/ potential for a good story/good visual other than graphs

http://www.startribune.com/rising-salt-levels-threaten-twin-cities-lakes-by-2050/419088124/ Twin Cities is a hot spot in a national study of lakes and road-salt runoff. It showed that salt concentrations in the Mississippi, mostly from road salt, have increased 81 percent since 1985. Many lakes around the Twin Cities are becoming so salty from winter road maintenance that, within three decades, they will no longer support native fish and plants. The legal pollution standard for salt set by the Environmental Protection Agency is 230 milligrams per liter. And that amounts to one teaspoon per five gallons of water.

lindsayplatt commented 4 years ago

CSV & interactive version of this graph available here: https://github.com/usgs-makerspace/makerspace-sandbox/tree/master/salt-propogation

image

Thoughts after exploring the data:

  1. Show how road salt changes during snow vs rain storm?
  2. Is there a difference between how road salt affects SC in urban vs rural locations? For now, based urban/rural indicator in data off of county populations > 100,000. We will need a better way to do this in the future.
  3. If we do a graph, could do the y values as something with more significance than "SC, uS/cm". Perhaps "tablespoons of salt added" or something?
mhines-usgs commented 4 years ago

Estimates of Road Salt Application across the Conterminous United States, 1992-2015 https://www.sciencebase.gov/catalog/item/5b15a50ce4b092d9651e22b9

lindsayplatt commented 4 years ago

Study that Laura was a part of: https://www.usgs.gov/centers/umid-water/science/evaluating-chloride-trends-due-road-salt-use-and-its?qt-science_center_objects=0#qt-science_center_objects

Should also reach out to Hilary Dugan to get her thoughts.

abriggs-usgs commented 4 years ago

With the link above ^^ does anyone else just get a set of blank tabs?

mwernimont commented 4 years ago

The link to Laura's viz? No, got the viz to shoe up. Lindsays PR also shows up.

abriggs-usgs commented 4 years ago

Weird. It is working now.

mhines-usgs commented 4 years ago

Study that Laura was a part of: https://www.usgs.gov/centers/umid-water/science/evaluating-chloride-trends-due-road-salt-use-and-its?qt-science_center_objects=0#qt-science_center_objects

thoughts from this: ". Increasing concentrations during non-deicing periods suggest that chloride was stored in hydrologic reservoirs, such as the shallow groundwater system, during the winter and slowly released in baseflow throughout the year. " so perhaps we would want to look at levels throughout the year after a particularly snowy year? (when presumably a lot of salt might be used)

would be interesting to consider also looking at some kind of data like the estimates of road salt usage, and perhaps extending that analysis if we could (the metadata explain where the data are from and their process) to bring it up to the present time. that might give a nice background layer sort of like the gage conditions map that we could animate over time. and then pick out specific gages to help tell more of a story?

mhines-usgs commented 4 years ago

david: look at relating salt levels to the amount of land cover dataset, transportation/paved areas - more salt being applied

mhines-usgs commented 4 years ago

Hilary's shiny app of data http://argyron.limnology.wisc.edu:3838/ChlorideObservations/

lindsayplatt commented 4 years ago

This initial exploration seems complete to me now that we have discussed and identified the path forward. Closing.