Include UNDERC dataset?

[jzwart]

I was looking at the data status map and noticed University of Notre Dame Environmental Research Center (UNDERC) lakes aren't included in the dataset (green blocks in screen shot below)

There are ~170 lakes in the Solomon et al data set with max depth information, ~95 lakes with temperature observations. A bunch of other data including water clarity in there too

[lindsayplatt]

@jread-usgs checking on how separate depth and temp are from the rest of the data to see how big of a lift it would be to include.

[jordansread]

@jzwart I wonder if these are in LAGOS, which would be covered in #220 and seems like a priority.

If not we could pull them in via that figshare dataset and contact Stuart prior to doing so.

[jzwart]

My guess is that they aren't in LAGOS. @joneslabND @ctsolomon or @kaijagahm do you know if Solomon et al data set is in LAGOS?

[jordansread]

I see some tasty lake data

[jordansread]

Profile data, which has 22221 non-NA temperature values on 90 lakes, 7 with over 1K obs:

I see a "color" table with some band-specific attenuation rates, but not a clarity/secchi field in here (at least upon initial look) that we could use for secchi depth or Kd (bulk attenuation coefficient).

update as Stuart points out below, I missed PAR in the profile table, which we can calculate a day-specific Kd from and it is a lot better of a data source than Secchi depth.

[joneslabND]

We measure water color in the lab, but there is a lot of PAR profile data too. Happy to chat about the database sometime if that is helpful. Obviously. Zwart knows a lot about it already.

[joneslabND]

My guess is that they aren't in LAGOS. @joneslabND @ctsolomon or @kaijagahm do you know if Solomon et al data set is in LAGOS?

I don't believe these data are in LAGOS.

[jordansread]

@joneslabND are you supportive of us pulling the max depth data and temperature profiles into our modeling pipeline? It currently has a lot of coverage in the midwest and we're looking to improve temperature and depth.

PAR data would be great too but we can reach out later on the specifics of that. Hope you are doing well.

[joneslabND]

you are welcome to any of those data. They are in the public domain on figshare (and updated at least once per year I think). If you cite the database when using it that would be great! The PAR data should be in the profiles table along with the depth-specific temperature data.