Air quality readings in cumulusmx database

[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 !

[HansR]

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?

[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.

[HansR]

And btw: you see those only in the standard CMX charts of the interface and standard website.

[HansR]

edit: hans quick on the money hehe ignore me.

Done

[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&#8322 Current
CO2-24hr=CO&#8322 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

[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.

[watsonm]

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.

[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.

[HansR]

Actually I meant: do you see the chart(!) In the interface.
Not the config to CUtils.

So: menu=>charts=>Recent=>airquality

[watsonm]

Hans,
No airquality charts!

[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?)

[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&#8322 Current
CO2-24hr=CO&#8322 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

[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......

[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....