Data Quality Report - Weather & Energy
Overall Status: CRITICAL
Report generated: 2026-06-24 14:36:57
Part 1: Weather Data Quality
1.1 Data Freshness
Shows when each station last received data. Active stations: KPWM (Portland Jetport) and zastmet (personal weather station).
| Station |
Last Record |
Hours Stale |
Status |
| KPWM |
2026-06-24 07:51 |
6.0 |
WARNING |
| E4229 |
2026-06-24 10:15 |
4.0 |
OK |
| E4279 |
2026-06-24 10:15 |
4.0 |
OK |
| G5290 |
2026-06-24 10:15 |
4.0 |
OK |
| G5544 |
2026-06-24 10:15 |
4.0 |
OK |
| zastmet |
2026-06-24 14:30 |
0.1 |
OK |
1.2 Data Completeness (Last 7 Days)
| Station |
Expected |
Actual |
Completeness |
Status |
| KPWM |
168 |
201 |
100.0% |
OK |
| E4229 |
168 |
636 |
100.0% |
OK |
| E4279 |
168 |
680 |
100.0% |
OK |
| G5290 |
168 |
1891 |
100.0% |
OK |
| G5544 |
168 |
1909 |
100.0% |
OK |
| zastmet |
2016 |
2015 |
100.0% |
OK |
1.3 Range Validation (Last 30 Days)
| Station |
Sensor |
Expected Range |
Actual Min |
Actual Max |
Violations |
Status |
| KPWM |
Temperature |
-40 to 110 |
37.0 |
86.0 |
0 |
OK |
| KPWM |
Humidity |
0 to 100 |
26.0 |
100.0 |
0 |
OK |
| KPWM |
Pressure |
920 to 1080 |
995.6 |
1023.4 |
0 |
OK |
| KPWM |
Wind Speed |
0 to 150 |
0.0 |
22.0 |
0 |
OK |
| E4229 |
Temperature |
-40 to 110 |
0.0 |
94.0 |
0 |
OK |
| E4229 |
Humidity |
0 to 100 |
0.0 |
98.0 |
0 |
OK |
| E4229 |
Pressure |
920 to 1080 |
1000.2 |
1025.4 |
0 |
OK |
| E4229 |
Wind Speed |
0 to 150 |
0.0 |
11.0 |
0 |
OK |
| E4279 |
Temperature |
-40 to 110 |
34.0 |
85.0 |
0 |
OK |
| E4279 |
Humidity |
0 to 100 |
1.0 |
100.0 |
0 |
OK |
| E4279 |
Pressure |
920 to 1080 |
994.9 |
1023.1 |
0 |
OK |
| E4279 |
Wind Speed |
0 to 150 |
0.0 |
6.0 |
0 |
OK |
| G5290 |
Temperature |
-40 to 110 |
34.0 |
87.0 |
0 |
OK |
| G5290 |
Humidity |
0 to 100 |
30.0 |
97.0 |
0 |
OK |
| G5290 |
Pressure |
920 to 1080 |
994.8 |
1022.4 |
0 |
OK |
| G5290 |
Wind Speed |
0 to 150 |
0.0 |
7.0 |
0 |
OK |
| G5544 |
Temperature |
-40 to 110 |
36.0 |
88.0 |
0 |
OK |
| G5544 |
Humidity |
0 to 100 |
24.0 |
96.0 |
0 |
OK |
| G5544 |
Pressure |
920 to 1080 |
996.4 |
1024.1 |
0 |
OK |
| G5544 |
Wind Speed |
0 to 150 |
0.0 |
2.0 |
0 |
OK |
1.4 Station Summary
| Station |
Total Records |
First Record |
Last Record |
| KPWM |
99,036 |
N/A |
2026-06-24 07:51 |
| E4229 |
292,147 |
N/A |
2026-06-24 10:15 |
| E4279 |
283,111 |
N/A |
2026-06-24 10:15 |
| G5290 |
156,194 |
2024-08-23 |
2026-06-24 10:15 |
| G5544 |
149,825 |
2024-11-27 |
2026-06-24 10:15 |
| zastmet |
166,005 |
2024-01-22 |
2026-06-24 14:30 |
Part 2: Energy Data Quality
2.1 Energy Data Freshness
Checks how current the energy data sources are.
| Source |
Table |
Last Record |
Staleness |
Status |
| Electric Meter (hourly) |
electric_use |
2026-06-08 |
375 hours |
CRITICAL |
| Utility Bills (monthly) |
v_monthly_utilities |
2026-05-02 |
53 days |
WARNING |
2.2 Energy Data Completeness
| Source |
Period |
Expected |
Actual |
Completeness |
Status |
| Electric Meter |
Last 30 days |
720 |
345.0 |
47.9% |
CRITICAL |
| Electricity Bills |
Since 2017 |
112 |
112.0 |
100.0% |
OK |
| Gas Bills |
Since 2017 |
112 |
108.0 |
96.4% |
OK |
2.3 Energy Range Validation
| Metric |
Expected Range |
Actual Min |
Actual Max |
Average |
Outliers |
Status |
| Monthly Electricity (kWh) |
200 - 3000 |
-357.0 |
2069.0 |
1098.0 |
2.0 |
WARNING |
| Monthly Gas (therms) |
0 - 200 |
20.0 |
288.0 |
113.0 |
18.0 |
WARNING |
2.4 Energy Summary
| Source |
Total Records |
First Record |
Last Record |
Total Value |
| Electric Meter (hourly) |
107,988 |
2014-02-01 |
2026-06-08 |
161,757 kWh |
| Utility Bills (monthly) |
112 months |
2017-01-02 |
2026-05-02 |
122,997 kWh + 12,153 therms |
Part 3: Energy Trends & Periodicity
3.1 Usage Trends Over Time
Blue bars show monthly usage, red line shows 12-month rolling average to reveal trends.
3.2 Seasonal Patterns
Average usage by month showing seasonal patterns. Error bars indicate variability.
Part 4: Solar Data Quality (SolarEdge)
4.1 API Sync Status
Status of each data type fetched from the SolarEdge API (seh_sync_metadata).
Errors here indicate the API call failed and data may be stale.
| Data Type |
Last Sync |
Last Data Timestamp |
Records Synced |
Status |
Error |
| storage |
2026-06-24 14:34 |
2026-06-24 14:34 |
0 |
OK |
|
| environmental |
2026-06-24 14:34 |
2026-06-24 14:34 |
1 |
OK |
|
| inventory |
2026-06-24 14:34 |
2026-06-24 14:34 |
6 |
OK |
|
| inverter_telemetry |
2026-06-24 14:34 |
2026-06-24 14:31 |
13 |
OK |
|
| optimizer_telemetry |
2026-06-24 14:34 |
2026-06-24 14:34 |
0 |
OK |
|
| power_details |
2026-06-24 14:34 |
2026-06-24 14:30 |
5 |
OK |
|
| site |
2026-06-24 14:34 |
2026-06-24 14:34 |
1 |
OK |
|
| equipment |
2026-06-24 14:34 |
2026-06-24 14:34 |
1 |
OK |
|
| energy |
2026-06-24 14:34 |
2026-06-24 00:00 |
2 |
OK |
|
| power |
2026-06-24 14:34 |
2026-06-24 14:34 |
5 |
OK |
|
4.2 Power Reading Completeness (Last 14 Days)
SolarEdge sends 15-minute readings (96 expected per full day).
PARTIAL means today is still in progress.
CRITICAL means fewer than 80% of readings were received.
| Date |
Readings |
Completeness |
Peak (W) |
Avg (W) |
Status |
| 2026-06-24 |
58 |
60.4% |
11,096 |
3,286 |
PARTIAL |
| 2026-06-23 |
95 |
99.0% |
8,402 |
1,704 |
OK |
| 2026-06-22 |
96 |
100.0% |
7,495 |
1,553 |
OK |
| 2026-06-21 |
95 |
99.0% |
11,262 |
1,665 |
OK |
| 2026-06-20 |
95 |
99.0% |
11,255 |
2,628 |
OK |
| 2026-06-19 |
95 |
99.0% |
11,190 |
2,539 |
OK |
| 2026-06-18 |
95 |
99.0% |
1,311 |
302 |
OK |
| 2026-06-17 |
95 |
99.0% |
11,016 |
2,983 |
OK |
| 2026-06-16 |
95 |
99.0% |
11,246 |
2,695 |
OK |
| 2026-06-15 |
95 |
99.0% |
10,091 |
2,399 |
OK |
| 2026-06-14 |
95 |
99.0% |
11,164 |
2,254 |
OK |
| 2026-06-13 |
95 |
99.0% |
10,692 |
2,868 |
OK |
| 2026-06-12 |
95 |
99.0% |
10,354 |
2,057 |
OK |
| 2026-06-11 |
95 |
99.0% |
11,219 |
2,009 |
OK |
| 2026-06-10 |
95 |
99.0% |
9,839 |
2,361 |
OK |
4.3 Daily Energy Completeness (Last 30 Days)
Daily energy totals from seh_energy_readings.
Missing days indicate the API did not return data for that date.
Today is always missing until the day is complete.
Missing days (excl. today): 0
| Date |
Energy (Wh) |
Energy (kWh) |
Status |
| 2026-06-24 |
45,667 |
45.67 |
OK |
| 2026-06-23 |
40,170 |
40.17 |
OK |
| 2026-06-22 |
37,252 |
37.25 |
OK |
| 2026-06-21 |
38,799 |
38.80 |
OK |
| 2026-06-20 |
59,899 |
59.90 |
OK |
| 2026-06-19 |
58,474 |
58.47 |
OK |
| 2026-06-18 |
7,087 |
7.09 |
OK |
| 2026-06-17 |
70,765 |
70.77 |
OK |
| 2026-06-16 |
63,633 |
63.63 |
OK |
| 2026-06-15 |
59,584 |
59.58 |
OK |
| 2026-06-14 |
53,067 |
53.07 |
OK |
| 2026-06-13 |
67,659 |
67.66 |
OK |
| 2026-06-12 |
49,128 |
49.13 |
OK |
| 2026-06-11 |
47,375 |
47.38 |
OK |
| 2026-06-10 |
56,475 |
56.48 |
OK |
| 2026-06-09 |
67,443 |
67.44 |
OK |
| 2026-06-08 |
67,112 |
67.11 |
OK |
| 2026-06-07 |
32,021 |
32.02 |
OK |
| 2026-06-06 |
33,228 |
33.23 |
OK |
| 2026-06-05 |
61,224 |
61.22 |
OK |
| 2026-06-04 |
67,798 |
67.80 |
OK |
| 2026-06-03 |
69,824 |
69.82 |
OK |
| 2026-06-02 |
49,134 |
49.13 |
OK |
| 2026-06-01 |
62,632 |
62.63 |
OK |
| 2026-05-31 |
36,717 |
36.72 |
OK |
| 2026-05-30 |
29,542 |
29.54 |
OK |
| 2026-05-29 |
45,760 |
45.76 |
OK |
| 2026-05-28 |
39,913 |
39.91 |
OK |
| 2026-05-27 |
63,224 |
63.22 |
OK |
| 2026-05-26 |
68,485 |
68.48 |
OK |
4.4 Solar Data Summary
6,990.8
Total kWh Produced
| Metric |
Value |
Status |
| Power data freshness |
0h since last reading |
OK |
| Data collection start |
2026-01-27 |
OK |
| Days with data / Calendar days |
149 / 149 (100.0%) |
OK |
4.5 Historic Data Gaps (Full Collection History)
Itemized list of all days since data collection began that have missing or
low-completeness readings. Days with <95% power readings are flagged WARNING;
days with <80% are CRITICAL. The first day of collection is expected to be partial.
2026-01-27
Collection Start
149
Calendar Days in Span
0
Days with No Power Data
Power Reading Gaps (<95% completeness, excl. today)
| Date |
Readings |
Completeness |
Status |
Note |
| 2026-01-27 |
41 |
42.7% |
CRITICAL |
First day — collection started mid-day |
Missing Daily Energy Records
No missing daily energy records — all calendar days in the collection span have energy data.
Quality Check Thresholds
Weather Data
- Freshness: Warning at 4h, Critical at 24h
- Completeness: Warning at 95%, Critical at 80%
- Temperature Range: -40F to 110F
Energy Data
- Utility Bill Freshness: Warning at 45 days, Critical at 90 days
- Monthly Electricity: 200 - 3000 kWh
- Monthly Gas: 0 - 200 therms
Data Quality Report generated by data_quality_report.py
Part of the Cumberland Center Weather Monitoring System
