Data showing on CEDEN but not on Dashboard

[j0el]

Please tell me what I am doing wrong. Thanks,

If I search CEDEN using https://ceden.waterboards.ca.gov/Home/virtAqtTool for Bifenthrin levels at (for example) Oxn_CI-06 I find 4 entries (file attached). If I look at the data dashboard I do not see that analyte in the dropdown.

export.xlsx

[mmtang]

Hi @j0el,

Thanks for bringing this to my attention. I'm currently looking into it and will follow up with you as soon as I have more information.

Thanks, Michelle

[mmtang]

Hi @j0el,

The Bifenthrin data should be available on the dashboard now. Please take a look and let me know if you don't see it. In short, we are not using the full list of analytes from CEDEN but rather a list of select analytes. Bifenthrin was not on this list initially, which is why you didn't see it in the dropdown earlier, but I just added it this week based on your inquiry, so you should see it now.

I will be working on adding more analytes to this list in the coming weeks. Please let me know if there are any other analytes from CEDEN that you would like to see in the dashboard. I would be happy to look into adding them for you. Here is a list of analytes from the CEDEN water quality table that are currently included in the dashboard:

Alkalinity as CaCO3, Total Aluminum, Total Ammonia as N, Total Arsenic, Total Barium, Total Beryllium, Total Bifenthrin, Total Boron, Dissolved Cadmium, Total Chromium, Total Chloride, Dissolved Chlorophyll a, Particulate' Copper, Total Dissolved Organic Carbon, Dissolved E. coli Fluoride, Dissolved Hardness as CaCO3, Total Lead, Total Manganese, Total Mercury, Methyl, Total Mercury, Total Moisture, Total Nickel, Total Nitrate as N, Total Nitrogen, Total, Total Nitrogen, Total Kjeldahl, Total Oxygen, Dissolved, Total Oxygen, Saturation, Total pH Phosphorus as P, Total Selenium, Total Silver, Total SpecificConductivity, Total Sulfate, Dissolved Temperature Total Dissolved Solids, Total Total Organic Carbon, Total Turbidity, Total Zinc, Total

[j0el]

Thanks so much. I am asking our team to check about any more to add.

On Fri, Oct 25, 2024, 3:08 PM Michelle Tang @.***> wrote:

Hi @j0el https://github.com/j0el,

The Bifenthrin data should be available on the dashboard now. Please take a look and let me know if you don't see it. In short, we are not using the full list of analytes from CEDEN but rather a list of select analytes. Bifenthrin was not on this list initially, which is why you didn't see it in the dropdown earlier, but I just added it this week based on your inquiry, so you should see it now.

I will be working on adding more analytes to this list in the coming weeks. Please let me know if there are any other analytes from CEDEN that you would like to see in the dashboard. I would be happy to look into adding them for you. Here is the current list of analytes:

Alkalinity as CaCO3, Total Aluminum, Total Ammonia as N, Total Arsenic, Total Barium, Total Beryllium, Total Bifenthrin, Total Boron, Dissolved Cadmium, Total Chromium, Total Chloride, Dissolved Chlorophyll a, Particulate' Copper, Total Dissolved Organic Carbon, Dissolved E. coli Fluoride, Dissolved Hardness as CaCO3, Total Lead, Total Manganese, Total Mercury, Methyl, Total Mercury, Total Moisture, Total Nickel, Total Nitrate as N, Total Nitrogen, Total, Total Nitrogen, Total Kjeldahl, Total Oxygen, Dissolved, Total Oxygen, Saturation, Total pH Phosphorus as P, Total Selenium, Total Silver, Total SpecificConductivity, Total Sulfate, Dissolved Temperature Total Dissolved Solids, Total Total Organic Carbon, Total Turbidity, Total Zinc, Total

— Reply to this email directly, view it on GitHub https://github.com/mmtang/swamp-data-dashboard/issues/11#issuecomment-2438947972, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHWZIVZNUORVV2L4T2YFULZ5K6PTAVCNFSM6AAAAABQKORS32VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMZYHE2DOOJXGI . You are receiving this because you were mentioned.Message ID: @.***>

[j0el]

Michelle, These are what we would like added if possible. Thanks.

Boron, Total

Copper, Dissolved

Fenpropathrin/Danitol

DDE (p,p')

DDT (p.p')

Dichloran

Enterococcus- Bacteria

Nitrate/Nitrite as N

Nitrite as N

Pendimethalin

Permethrin

Sulfate, Total

Total Suspended Solids

On Fri, Oct 25, 2024 at 3:08 PM Michelle Tang @.***> wrote:

Hi @j0el https://github.com/j0el,

The Bifenthrin data should be available on the dashboard now. Please take a look and let me know if you don't see it. In short, we are not using the full list of analytes from CEDEN but rather a list of select analytes. Bifenthrin was not on this list initially, which is why you didn't see it in the dropdown earlier, but I just added it this week based on your inquiry, so you should see it now.

I will be working on adding more analytes to this list in the coming weeks. Please let me know if there are any other analytes from CEDEN that you would like to see in the dashboard. I would be happy to look into adding them for you. Here is the current list of analytes:

Alkalinity as CaCO3, Total Aluminum, Total Ammonia as N, Total Arsenic, Total Barium, Total Beryllium, Total Bifenthrin, Total Boron, Dissolved Cadmium, Total Chromium, Total Chloride, Dissolved Chlorophyll a, Particulate' Copper, Total Dissolved Organic Carbon, Dissolved E. coli Fluoride, Dissolved Hardness as CaCO3, Total Lead, Total Manganese, Total Mercury, Methyl, Total Mercury, Total Moisture, Total Nickel, Total Nitrate as N, Total Nitrogen, Total, Total Nitrogen, Total Kjeldahl, Total Oxygen, Dissolved, Total Oxygen, Saturation, Total pH Phosphorus as P, Total Selenium, Total Silver, Total SpecificConductivity, Total Sulfate, Dissolved Temperature Total Dissolved Solids, Total Total Organic Carbon, Total Turbidity, Total Zinc, Total

— Reply to this email directly, view it on GitHub https://github.com/mmtang/swamp-data-dashboard/issues/11#issuecomment-2438947972, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHWZIVZNUORVV2L4T2YFULZ5K6PTAVCNFSM6AAAAABQKORS32VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMZYHE2DOOJXGI . You are receiving this because you were mentioned.Message ID: @.***>

[mmtang]

Thanks for the list. I should be able to add all of them over the next two weeks or so. I'll follow up once I've made the changes.

[j0el]

Thank you, we appreciate it a lot.

On Tue, Oct 29, 2024 at 3:06 PM Michelle Tang @.***> wrote:

Thanks for the list. I should be able to add all of them over the next two weeks or so. I'll follow up once I've made the changes.

— Reply to this email directly, view it on GitHub https://github.com/mmtang/swamp-data-dashboard/issues/11#issuecomment-2445415781, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHWZITW53O36RYV6JDDXLLZ6ABGDAVCNFSM6AAAAABQKORS32VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINBVGQYTKNZYGE . You are receiving this because you were mentioned.Message ID: @.***>

[mmtang]

Hi @j0el, I added the data for the requested analytes. Please feel free to take a look and let me know if you have any follow-up questions. Thanks!

[j0el]

This is wonderful, our team really appreciates you.

On a slightly different note. DO you know anyone who is connected with loading data into CEDEN? SOme of the labs Oxnard contracted with failed to upload data and we are not having much success getting them to do it since their contracts are over.

Best regards,

On Thu, Nov 14, 2024 at 10:34 AM Michelle Tang @.***> wrote:

Hi @j0el https://github.com/j0el, I added the data for the requested analytes. Please feel free to take a look and let me know if you have any follow-up questions. Thanks!

— Reply to this email directly, view it on GitHub https://github.com/mmtang/swamp-data-dashboard/issues/11#issuecomment-2477143886, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHWZIXEWCYHEDOPB74VDU32ATUKFAVCNFSM6AAAAABQKORS32VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINZXGE2DGOBYGY . You are receiving this because you were mentioned.Message ID: @.***>

[mmtang]

I will pass your message along to others in my office to see if they can help or offer some insight.