search

bcgov / water-quality-analysis

R scripts to calculate water quality trends and the water quality index at selected ambient monitoring stations in B.C.
Apache License 2.0
11 stars 4 forks source link

What are the EMS codes for 'NO2/NO3', 'NO2+NO3'? #10

Closed joethorley closed 7 years ago

stephhazlitt commented 8 years ago

I found NO2 + NO3 in the dict-num.xls file available in the EMS metadata record in the BC Data Catalogue. Parameter Code: 0110

joethorley commented 8 years ago

Isn't 0110 just = Nitrogen NO3 Total I can get N02 and N03 separately - I just don't know what both together are or divided by each other

stephhazlitt commented 8 years ago

Sorry, that should have been 0109: Nitrogen NO2 + NO3. I am still working on finding NO2/NO3.

ateucher commented 8 years ago

There is also Nitrate(NO3) + Nitrite(NO2) Dissolved, which is parameter code 1109

joethorley commented 8 years ago

Currently I have

Nitrate Dissolved,EMS_1110,mg/L,mean
Nitrate Soluble,EMS_NO3_,mg/L,mean
Nitrate Total,EMS_0110,mg/L,mean
Nitrate Nitrite,EMS_0109,mg/L,mean
Nitrite Dissolved,EMS_0111,mg/L,mean
Nitrogen Dissolved,EMS_1114,mg/L,mean
Nitrogen Total,EMS_0114,mg/L,mean

I'm thinking I should rename Nitrate Nitrate as Nitrate Nitrite Total and add

Nitrate Nitrite Dissolved,EMS_1109,mg/L,mean
ateucher commented 8 years ago

To get the full suite of possible parameters with codes, can you just use rems and pull out all unique combinations of PARAMETER and PARAMETER_CODE?

Why do you need to rename them?

stephhazlitt commented 8 years ago

For interpreting the report with parameter recommendations per station: NO2/NO3 == NO2 + NO3

joethorley commented 8 years ago

@ateucher I've done that and have included it in wqbc. However the EMS naming scheme is inconsistent. To make the names easier to guess and easier to interpret and process by a computer we introduced a new naming scheme in wqbc. The names do of course link to the EMS codes so are unambiguous in that sense (and can therefore be linked to the EMS PARAMETER names). The real problem is people using names without linking them to EMS codes.

joethorley commented 8 years ago

@stephhazlitt After a peruse of the report I concur with your conclusion that NO2/NO3 == NO2 + NO3 (does this mean that NO2 and N03 are both 0.5 ;)). I'm closing the thread as the question has been answered.

joethorley commented 8 years ago

Actually I'm reopening as I need to resolve Nitrate Nitrite and

Nitrate Nitrite Dissolved,EMS_1109,mg/L,mean