Page 1 of 2
Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 2:04 pm
by watsonm
Hi,
I noticed that in cumulusmx.db there are two columns I had not seen before that are labelled Pm2p5 and Pm10. They are both populated with -1.
I already send data via the Airlink protocol to /v1/current_conditions and wondered what these columns were being used for and if they need to be populated.
Or should I just ignore them !
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 2:26 pm
by HansR
watsonm wrote: ↑Thu 01 Dec 2022 2:04 pm
Hi,
I noticed that in cumulusmx.db there are two columns I had not seen before that are labelled Pm2p5 and Pm10. They are both populated with -1.
I already send data via the Airlink protocol to /v1/current_conditions and wondered what these columns were being used for and if they need to be populated.
Or should I just ignore them !
Mike,
I assume those are for the AirLink values when activated. The current values are the only two values displayed by CMX.
The Ecowitt AirQuality and CO2 sensors are ExtraSensors and are not displayed in the charts (you need Cutils for that
)
I don't know exactly how you deal with your alternative use of the AirLink interface but if you configured CMX
correctly (having an AirLink) then you should be able to see those two values somewhere. Did you configure an AirLink?
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 2:28 pm
by Nossie
Is that for something like the ecowitt gas sensor it doesn't use the default air quality one - it has its own particulate stuff outside of Airlink, could it be that?
edit: hans quick on the money hehe ignore me.
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 2:29 pm
by HansR
And btw: you see those only in the standard CMX charts of the interface and standard website.
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 2:31 pm
by HansR
Nossie wrote: ↑Thu 01 Dec 2022 2:28 pm
edit: hans quick on the money hehe ignore me.
Done
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 2:51 pm
by watsonm
Hans,
Thanks for replying..
I issue the Airlink API as specified here
Code: Select all
https://weatherlink.github.io/airlink-local-api/
and my data appears successfully in the ExtraSensors-> Airlink page and also gets propagated to cmxutils.
Nothing appears in cumulusmx.db .
In strings.ini I notice some combination of CO2 and PM2p5 which doesn't seem right to me but maybe it is a dual use of the table
Code: Select all
[CO2Captions]
CO2-Current=CO₂ Current
CO2-24hr=CO₂ 24h avg
CO2-Pm2p5=PM 2.5
CO2-Pm2p5-24hr=PM 2.5 24h avg
CO2-Pm10=PM 10
CO2-Pm10-24hr=PM 10 24h avg
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 3:22 pm
by HansR
You can safely ignore the ecowitt sensors now, it is the airlink this is about.
Do you see your airlink chart in the interface?
If you don't i think it is in configuration of the airlink somewhere in cmx.
You may have switched off the chart (and the data) because CUtils shows the charts and creates its own json data files. So in that case you won't see anything in that database.
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 3:42 pm
by watsonm
HansR wrote: ↑Thu 01 Dec 2022 3:22 pm
Do you see your airlink chart in the interface?
Yes I do :
CumulusMX -> extra Sensors -> Airlink Sensors
CumulusUtils -> extra -> Airlink
No problem there. I was just curious as to what these two columns were for. I think I will ignore them.
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 4:03 pm
by HansR
It probably has to do with the data json files which you most likely deactivated.
But anyway, yes if further everything is OK: ignore indeed.
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 4:04 pm
by HansR
Actually I meant: do you see the chart(!) In the interface.
Not the config to CUtils.
So: menu=>charts=>Recent=>airquality
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 4:52 pm
by watsonm
Hans,
No airquality charts!
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 5:14 pm
by HansR
Did you activate: Settings=>InternetSettings=>Normal Interval Settings=>Graph File Settings=>airquality.json?
If that is not it, I think somebody with more knowledge on the internals must kick in (@mcrossley?)
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 6:01 pm
by PaulMy
Hi,
I noticed that in cumulusmx.db there are two columns I had not seen before that are labelled Pm2p5 and Pm10. They are both populated with -1.
I already send data via the Airlink protocol to /v1/current_conditions and wondered what these columns were being used for and if they need to be populated.
I have the AirLink and see those two columns as well when I use DB Browser for SQLite, and they are populated. The data seems to match the AirLink data at Weatherlink.com.
My Charts do include the AirLink, both Localhost and website
www.komokaweather.com/cumulusmxwll
My strings.ini has and these would have been added by CMX:
Code: Select all
[CO2Captions]
CO2-Current=CO₂ Current
CO2-24hr=CO₂ 24h avg
CO2-Pm2p5=PM 2.5
CO2-Pm2p5-24hr=PM 2.5 24h avg
CO2-Pm10=PM 10
CO2-Pm10-24hr=PM 10 24h avg
EDIT:
Can you check the MXdiags and see if there are any errors reported with AirLink.
Enjoy,
Paul
Re: Air quality readings in cumulusmx database
Posted: Thu 01 Dec 2022 7:50 pm
by watsonm
Thanks Hans and Paul.
Enough time wasted on this.
Code: Select all
Did you activate: Settings=>InternetSettings=>Normal Interval Settings=>Graph File Settings=>airquality.json?
yes this is set but I guess the reason is my configuration which I will describe for Paul's "benefit" (not sure you'll get any benefit!!!
)
My setup is a mixture of FO sensors and 10 dollar sensors. I use a PMS5003 unit to retrieve the pm25/ pm10 values and python code builds up a data stream that matches the Airlink Api as mentioned above. This data is sent to the web_server/v1/current_conditions location so it is not a true Airlink unit.
Thanks for the suggestions but please don't waste any more of your time on it......
Re: Air quality readings in cumulusmx database
Posted: Tue 06 Dec 2022 1:29 pm
by watsonm
Sorted now...
After some reading of the CMX source code I modified my code to save pm2p5 and pm10 in the cumulusMX.db and set
Settings->extrasensors settings-> Air Quality Settings to Ecowitt CO2 settings
and the air quality tab and associated charts appeared....
