search

openclimatefix / PVConsumer

Consumer PV data from various sources
Apache License 2.0
3 stars 1 forks source link

71881 #37

Open peterdudfield opened 2 years ago

peterdudfield commented 2 years ago

Screenshot 2022-07-15 at 14 53 58

Zeros by 71881 pv system

peterdudfield commented 2 years ago

Screenshot 2022-07-15 at 14 55 13

22241 looks a bit high

peterdudfield commented 2 years ago

more zeros

select sum(solar_generation_kw) as total_solar_generation_kw, pv_yield.pv_system_id, pv_system.pv_system_id  from pv_yield
join pv_system on pv_system.id = pv_yield.pv_system_id
where pv_system.provider = 'solar_sheffield_passiv'
and pv_yield.created_utc > '2022-07-14'
group by pv_yield.pv_system_id, pv_system.id
order by pv_yield.pv_system_id)

Screenshot 2022-07-15 at 16 09 24