snowexsql icon indicating copy to clipboard operation
snowexsql copied to clipboard

Duplicate density profile data?

Open micahjohnson150 opened this issue 2 years ago • 4 comments

@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 avatar Sep 01 '21 15:09 micahjohnson150