Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

.pickBestEcosite() consideration of record_when_last_updated #295

Open
natearoe opened this issue May 19, 2023 · 1 comment
Open

.pickBestEcosite() consideration of record_when_last_updated #295

natearoe opened this issue May 19, 2023 · 1 comment

Comments

@natearoe
Copy link

In the absence of Correlation Date being populated in the Site > Site Ecological Site History table, the .pickBestEcosite() function would benefit from considering the record_when_last_updated field to determine the best ecosite.

brownag added a commit that referenced this issue May 22, 2023
@brownag
Copy link
Member

brownag commented May 22, 2023

Thanks for pointing this out Nate. All NA correlation date (for example) seems to lead to instability in sort order depending on data source (e.g. NASIS v.s. SQLite). I've added a correction to use recwlupdated in lieu of ecositecorrdate.

There are several other instances where this kind of non-deterministic sorting sneaks into child tables: taxmoistscl, landform, landscape. You also mentioned transect ID. I will leave this issue open until I have a chance to investigate and resolve the other related issues.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants