We need to add a SQL call that links the dataset ID to the collection unit and then the depositional environment table in Neotoma. This then gets joined to the data in the lake report outputs so we can help prioritize the addition of future lakes.
SELECT dsid, depenvtype
FROM . . .
We need to add a SQL call that links the dataset ID to the collection unit and then the depositional environment table in Neotoma. This then gets joined to the data in the lake report outputs so we can help prioritize the addition of future lakes.