snowexsql
snowexsql copied to clipboard
Duplicate density profile data?
@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.