efficiency only if pdc > 0
optimized query
initial monthly query
added weather chart