Here is a google sheet with the last week of data in it, it is interesting to look at the timeline view to estimate how often areas like woodshop are in use, it looks like roughly 40-50% of the time, 1,109 samples(each of a 4 minute period) indicate sound levels over background noise out of 2,805 samples
[quote=āBrandon_Green, post:42, topic:11106ā] ā¦
to estimate how often areas like woodshop are in use, it looks like roughly 40-50% of the time ā¦
[/quote]
We spend an awful lot of money on a shop that is not being used 60% of the timeā¦
Ducking nowā¦
I think the graph looks more like 61% of the time in use.
Would probably be more informative to calculate a percentage that doesnāt include midnight - 8am
Iād be more interested in how it compares to other areas than the raw percentage.
I created a sheet with the data very roughly aligned (each is sampling just based on each pis independent clock and how long it takes to post, so have to go back and align data taken during the same 4 minute period), and it is too noisy to immediately see much. Other than that the wood dust collector is picked up by the metalshop mic, and the AC turning on and off during the night is picked up by all of them.
(Axis is db, which is a logarithmic scale)
Part of the original goal of this project was to quantify if the woodshop air is too dusty(hazardous), turns out the dust collection and continuous filtering keeps woodshop air pretty good.
But metalshop often pegs the 10 micron particulate sensor at 2k ug/m^3 if someone is grinding or cutting for long periods of time( as was case Monday). Exposure to over 150 ug/m^3 average for a work day is considered a risk.
https://m2x.att.com/d/7a8c0ddb57d5afee446c8ec052427ab6
@Brandon_Green I heard there was a request to the Science committee to provide some baseline calibration of the particle sensors. Do you have more information about whatās needed?
@Brandon_Green My bad on Monday
Didnāt realize till I got home and did the old fashioned air quality testā¦ Clearing the sinuses
Definitely came back with my mask and was curious why we donāt have a filter in there too
will you please zoom in on the data from 7:00-7:30? what was the date when this was taken
Just realized that the woodshop sensor has been offline for 29 days, can anyone see if it is still there? Did it get unplugged?
@Brandon_Green: Iām late to the party, but Iām interested in your air quality project. Iām working on a related IoT project, namely a platform for data management and visualization, and Iām looking for use-cases that I can run through the platform. I see youāre using AT&Tās M2X service, and Iām wondering if I might get access to the data feed (not sure what protocols are supported, but we can handle just about anythingāMQTT, CoAP, WebSockets, REST, etc.). If the raw feed is available, Iād like to use it to build a use-case/demo, which you are welcome to use, too.
āEric
Right now itās just posting json to a rest endpoint every 4 minutes
The data should be publicly available on M2X, if you create an account you should be able to query the api to get the values at a url like
https://api-m2x.att.com/v2/devices/53665d82ee2f34a0febfae20cc75b1bf/streams/SDS021_PM10/values
Or could also push an update so the devices are sending data to another rest endpoint as well as m2x
The labels on dallas.ms/air are clickable and go to the m2x device pages (these pages have been slow to load lately)
https://m2x.att.com/d/7a8c0ddb57d5afee446c8ec052427ab6
https://m2x.att.com/d/0349cdda9597ff4a8f1d5773c0d1859b
https://m2x.att.com/d/8c4a161db98defdff594c42b91151c3f
https://m2x.att.com/d/53665d82ee2f34a0febfae20cc75b1bf
Perfect! Iāll query the data from M2X for now. Maybe in the future, we can explore some other data uplink options. Iāll work on some quick dashboards. In the mean time, if you have any ideas on visualizations or analytics youād like to see, let me know.
@Brandon_Green: Question about the dB value thatās being reported: I this is the raw sound pressure level (SPL) in the room, referenced to the standard reference amplitude of 20 microPascals = 0 dB? Or has it been āweightedā, as dB(A) or dBĀ©?
Itās the arbitrarily calculated root mean square of the value coming off the mic shifted to look like a plausible DB level. Itās not calibrated at all, so the values really donāt have a unit and can only be reasonably compared to values from the same sensor. Such as telling itās now louder in woodshop so the dust collector is probably running.