What is in the DIN dataset?

done, in all places.
--
something like this

DROP VIEW ......

/* Formatted on 10/8/2015 3:40:43 PM (QP5 v5.256.13226.35538) */
--
-- LIMNO_DIN (View)
--

CREATE OR REPLACE FORCE VIEW ...LIMNO_DIN
(
DATASET_CODE,
LIMNO_RUN,
"LOCATION NAME",
"LOCATION CODE",
DATE_TIME,
"DEPTH (m)",
"DIN (uM)",
"DIN COMMENTS",
"FILE NAME",
"DEPTH MASL"
)
AS
SELECT 'LIMNO_DIN',
LIMNO_RUN,
"LOCATION NAME",
"LOCATION CODE",
DATE_TIME,
"DEPTH (m)",
"NH4 (uM)" + "NO2 (uM)" + "NO3 (uM)",
CONCAT (CONCAT ("NH4 COMMENTS", "NO2 COMMENTS"), "NO3 COMMENTS"),
"FILE NAME",
"DEPTH MASL"
FROM LIMNO_NUTRIENTS
ORDER BY DATE_TIME, "DEPTH (m)";

GRANT SELECT ON ....

--moving this up--

john OK the dataset, but please define DIN in metadata. Produce and ask Amy to verify
need to email AMy... can also produce it myself with a view.

---------------
john to determine whether we freshen up this dataset with N=sum(nitrates, nitrites, and other N-combs)
================
For now, I corrected temporarily the urgency within the problem ( an empty data file !), but will give this closures when John gives us some direction as for whether to refresh the data with more recent seasons calculating the N as a sum of the concentration of the different states of nitrogen oxidation in samples. This data-set was sent out to other data-clearinghouses.... empty. No big whoop, at least, we did not hear complains about it in the last seven-some years.

Cheers, Inigo

On 4/24/2015 10:50 AM, Chiuchiolo, Amy wrote:
>
> Hi Inigo,
>
>
>
> I actually have no idea about this dataset. I converted the file to Excel and attached it. It only goes from the 9697 to 0001 seasons.
>
> In the nutrient dataset in the database, only NH4, NO3, NO2 and SRP are reported. In our raw nutrient data file, we do calculate DIN (NO3 + NO2 + NH4), but it is not reported in the file I submit to the database.
>
>
>
> I looked back through all the NUT files that have been submitted to the database. Up to 0304 DIN was included in the file and submitted to the database, but from 0405 on it was not. I spent some time that year going over the nutrient template (what we submit to the database) with Chris Gardner and it looks like we omitted DIN, since it was not reported in the NUT dataset. I guess it used to be reported in the DIN dataset you sent me.
>
>
>
> So, the question is, do we want to include it in the database? It could easily be included in the nutrient dataset and could probably be calculated within the database easily since it is just the SUM of NO3, NO2 and NH4. This is something John may have some input about. Maybe he knows why the DIN dataset stopped being updated after 0001. That was before my time.
>
>
>
> Amy
=================
data loaded into the site, also, into database. fixed things while await for amy.
===================
this set was not posted in mcmlter.org -- but sent off to metacat - what do we do with it, aside from fixing errors?

sent email to amy.
========================
What is in the DIN dataset? Isn’t that just a sum of the N in the macronutrient dataset? When you open the data file it doesn’t show any data.

Status: 

Priority: 

Normal