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

Duplicate density profile data? #53

Open
micahjohnson150 opened this issue Sep 1, 2021 · 4 comments
Open

Duplicate density profile data? #53

micahjohnson150 opened this issue Sep 1, 2021 · 4 comments
Assignees
Labels
bug Something isn't working

Comments

@micahjohnson150
Copy link
Member

micahjohnson150 commented Sep 1, 2021

@micah-prime found this issue using the following query.

from snowexsql.data import LayerData 
from snowexsql.db import get_db 
from snowexsql.conversions import query_to_geopandas
from datetime import date 
engine, session = get_db(db_name) 

qry = session.query(LayerData)
qry = qry.filter(LayerData.date == date(2020, 2, 8))
qry = qry.filter(LayerData.site_id =="6N16")
qry = qry.filter(LayerData.type=='density')

df = query_to_geopandas(qry, engine)

Produces a data frame that has the density profile twice where one has the value AND samples A,B,C and the other only has the value.

@micahjohnson150 micahjohnson150 added the bug Something isn't working label Sep 1, 2021
@micahjohnson150 micahjohnson150 self-assigned this Sep 1, 2021
@hpmarshall
Copy link
Member

Are the density profiles identical? Sounds like a duplicate entry. @meganmason can you check your QA/QC notes on this? We definitely want to keep the one with samples A,B,C if so.

@micahjohnson150
Copy link
Member Author

depth value sample_a sample_b sample_c
0 121 306 317 295
1 111 279 263 295
2 101 316.5 306 327
3 91 376.5 378 375
4 81 349 356 342
5 71 360 385 335
6 61 332 324 340
7 51 341 335 347
8 41 383 366 400
9 31 350.5 346 355
10 21 334 347 321
11 11 315.5 326 305
12 111 279
13 121 306
14 101 316.5
15 91 376.5
16 81 349
17 71 360
18 61 332
19 51 341
20 41 383
21 31 350.5
22 21 334
23 11 315.5

Looks like it. Here is the markdown table of the results.

@hpmarshall
Copy link
Member

Thanks. Yup, that looks like a duplicate. Same date/time?

@micahjohnson150
Copy link
Member Author

Yep!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants