## **Industrial Sand Mining in Western Wisconsin:** Resources for Environmental Monitoring and Advocacy This page is an introduction to frac sand issues and airborne particles, aimed at connecting concerned community groups, hardware developers, and scientists. You will find resources to: * connect with projects and people facing frac sand issues and particle pollution * learn about particle pollution, health, and regulations * explore options for addressing frac sand mining in your community ****** ### Table of Contents **Frac Sand Mining** | ----------------------|--------------------- [Background Information](https://publiclab.org/wiki/nonmetallicmining#Industrial+Sand+Mining) | This page gives information about the history of frac sand mining, what it is, what it is used for, and the environmental and human health concerns that surround it. [People and Places](wiki/wisconsin) | The first permitting for Frac Sand mining in Wisconsin started in late 2006 ([Pearson, 2015](http://wisconsinfracsand.blogspot.com/)). Since then, thousands of people have participated in the fight against the frac sand mining industry's negative effects. Learn more about the groups involved and what they are doing on the Wisconsin wiki page. [Particulate Matter Monitoring](/wiki/pm) | The PM Monitoring wiki includes information that explains how particles form in the air, how they affect human health, how they are regulated, and how they can be monitored. The wiki delves deep into different ways particles form with a focus on nonmetallic mining and [silica dust](https://publiclab.org/wiki/silica-monitoring). [Advocacy Leverage Points](https://publiclab.org/wiki/frac-sand-advocacy-leverage-points) | This wiki discusses regulations surrounding frac sand mining and highlights local government leverage points towns and community groups can use to address frac sand issues. From here you can also link to the [Frac Sand Legislation wiki](https://publiclab.org/wiki/frac-sand-legislation), which discusses national and state regulations and legislation related to air quality that are particularly relevant to frac sand issues. [Action Oriented Resources](https://publiclab.org/wiki/frac-sand-action-oriented-resources) | The Action Oriented Resources wiki compiles many tools people can use in addressing frac sand issues. There are workshops on selecting advocacy strategies, guidelines for setting up an environmental monitoring program, resources for working with the media, tools for reporting pollution and contact information for state and county regulators. ***** ### Recent activity related to frac sand mining: [notes:frac-sand] ***** #### Outline of Wiki Documents [Background Information](https://publiclab.org/wiki/nonmetallicmining#Industrial+Sand+Mining) [People and Places](wiki/wisconsin) [Particulate Matter Monitoring](/wiki/pm) - [Silica dust](https://publiclab.org/wiki/silica-monitoring) - [Regulations on PM Monitoring](https://publiclab.org/wiki/pm-monitoring-regulations) - [Collecting Data on Particulate Matter](https://publiclab.org/wiki/pm-monitoring) - [Visual monitoring](/wiki/visual-pm) - [Filter-based monitoring](/wiki/filter-pm) - [Optical monitoring](/wiki/optical-pm) - [Passive monitoring](/wiki/passive-pm) - [Public Lab PM monitoring tool development](/wiki/pm-dev) - [Passive monitoring tool](https://publiclab.org/wiki/SEM-stub-pm) [Advocacy Leverage Points](https://publiclab.org/wiki/frac-sand-advocacy-leverage-points) - [Frac Sand Legislation](https://publiclab.org/wiki/frac-sand-legislation) [Action Oriented Resources](https://publiclab.org/wiki/frac-sand-action-oriented-resources) - [Identify Advocacy Pathways Workshop](https://publiclab.org/wiki/choosing-advocacy-pathways) - [Start your own Environmental Monitoring Study](https://publiclab.org/wiki/start-enviro-monitor-study) - [Strategize a media campaign](https://publiclab.org/wiki/creating-a-media-campaign) **** ####Research in progress and Wikis Related to: [Silica](https://publiclab.org/tag/silica), [Particulate Matter](https://publiclab.org/tag/silica/tag/PM), [Passive-pm monitoring](https://publiclab.org/tag/passive-pm), [Wisconsin](https://publiclab.org/tag/wisconsin)....
| Author | Comment | Last activity | Moderation | ||
|---|---|---|---|---|---|
| keshavgarg234156 | "Whenever we have such large numbers of columns then we first perform correlation analysis before plotting the graphs. In correlation analysis, we c..." | Read more » | almost 5 years ago | |||
| guolivar | "Normalising is your friend when you have things with very different ranges. Depending on what you're looking for you can divide each column by its ..." | Read more » | about 5 years ago | |||
| eustatic | "Pivot tables? Lookup or index command? Conditional formatting? all of these things can help. i had to have 10 years and 14 plant plot growth s..." | Read more » | about 5 years ago | |||
| warren | "I also noticed that some very high values make others basically unreadable. So having 2 y-axis scales can sometimes help, i guess, although that's ..." | Read more » | about 5 years ago | |||
| warren | "Thanks! Yes, i started by removing things like firmware #, for sure. It's interesting to see how some values track each other roughly, while others..." | Read more » | about 5 years ago | |||
| guolivar | "This is very much dataset, project and software dependent. Sometimes I remove columns, other times I combine them (averaging, adding, etc), other ..." | Read more » | about 5 years ago | |||
| warren | "Hi @stevie, @Aleah, @Cbarnes9, and @crispinpierce, I posted this in follow up after the purple air datalogs ended up so dense and tough to read! Th..." | Read more » | about 5 years ago | |||
| warren | "OK, i got the units to show. I trimmed back one file to just a few of the columns, just to make it more readable, but it doesn't have all the diffe..." | Read more » | about 5 years ago | |||
| warren | "If you'd like, I can change it to just links for download! But it was interesting to see the data a bit in a graph. There are just so many fields, ..." | Read more » | about 5 years ago | |||
| warren | "Hi, all, drag-and-drop for big CSVs is working again now. The graph that's generated is a bit wild because there are so many fields. But there is a..." | Read more » | about 5 years ago | |||
| stevie | "Hi Jeff I have them, I also tried to get them up. I'll send them to you. " | Read more » | about 5 years ago | |||
| warren | "Crispin, could you email me the CSVs you're working with at jeff@publiclab.org so we can debug a bit? And, you had tried uploading them here in the..." | Read more » | about 5 years ago | |||
| warren | "Hi @crispinpierce - are the 50 csv files each a 24-hour datalog? I'm going to test out uploading a CSV to help debug here, too, so hang on a sec: ..." | Read more » | about 5 years ago | |||
| crispinpierce | "@jefffalk, @stevie, @Aleah, @Cbarnes9. A script that would remove the first row (column headers) and combine 50 csv files into a single Excel workb..." | Read more » | about 5 years ago | |||
| tranglixi88 | " Cách vào tiền dàn đề online Trong đánh lô đề, soi cầu chuẩn mỗi ngày quyết định việc thắ..." | Read more » | about 5 years ago | |||
| crispinpierce | " Hi Stevie, Thanks for the quick follow-up. I had two windows open: the PublicLab conversation and the folder with the files. I dragged the files..." | Read more » | about 5 years ago | |||
| warren | "There is also a "recover comment" button shown with a disk icon in the editor; it may still have your text? On Tue, Aug 27, 2019 at 10:00 AM \<..." | Read more » | about 5 years ago | |||
| liz | "We might also find a time to jump on a video call, and do some screensharing to get on the same page (literally) and make some progress! Every Tues..." | Read more » | about 5 years ago | |||
| jeffalk | "Hi @stevie, @Aleah, @Cbarnes9, and @crispinpierce, I may be jumping the gun here but since .csv files are openable by EXCEL and can be copied and ..." | Read more » | about 5 years ago | |||
| stevie | "Hi Crispin - about getting these files up, sorry you're having trouble. Curious, are you dragging them into your email in reply or directly onto th..." | Read more » | about 5 years ago | |||
| crispinpierce | "@stevie, @warren, @jeffalk, @Aleah and @Cbarnes9. Our issue with the data files is to be able to amalgamate numerous 24-hour csv files that are wri..." | Read more » | about 5 years ago | |||
| crispinpierce | "@stevie, @warren, @jeffalk, @Aleah and @Cbarnes9. Our issue with the data files is to be able to amalgamate numerous 24-hour csv files that are wri..." | Read more » | about 5 years ago | |||
| liz | "Thank you very much @jeffalk ! Great narrative. " | Read more » | about 5 years ago | |||
| jeffalk | "Hello @liz; That might help if the someone, like me, had sense enough to look at the buttons down at the bottom (as I did not!). Here I'll try a..." | Read more » | about 5 years ago |