search

openclimatefix / PVConsumer

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

Get pv data from Solar Shefield #30

Closed peterdudfield closed 2 years ago

peterdudfield commented 2 years ago

Get PV data straight from Solar Sheffield

more details to come

peterdudfield commented 2 years ago

Need to change datetimes, as they are not UTC in the database

peterdudfield commented 2 years ago

ALl times are UTC for passiv systems

but 36150, 36386, 43629, 60211 in pvoutput.org look a bit dodgy

peterdudfield commented 2 years ago 
update pv_system
set correct_data=false
where pv_system.pv_system_id in (36150, 36386, 43629, 60211)
JackKelly commented 2 years ago

they are not UTC in the database

Does that mean the times are not UTC in our database? (Or Sheffield's DB?)

If they're not in UTC, are they stored with an explicit UTC offset? If not, I fear we'll have duplicate "identical" datetimes at one daylight savings transition, and an hour's gap at the other DST transition!

peterdudfield commented 2 years ago

Time are UTC in our database. But there was something funny with the pv systems above .They were reporting information from about 30 mins into the future. Of course this is not possible, so there must be something wrong with that system.

Easy way was to remove them for the moment

peterdudfield commented 2 years ago

When pulling the data, we see no systems going over 1kw in the last week. This is a bit odd.

Pulling all data from 3rd July, the highest yield value was 736 watts. This is was for system ss_id=7759, system_id=35186, which has a installed cpaacity of 3.9 KWp