Data Quality Report - Weather & Energy

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-11-12 08:51	15.0	WARNING
E4279	2026-11-12 11:15	13.0	WARNING
G5290	2026-11-12 11:15	13.0	WARNING
G5544	2026-11-12 11:15	13.0	WARNING
zastmet	2026-11-13 00:30	0.1	OK
ecobee_Main Floor	2026-11-13 04:55	0.0	OK
ecobee_Basement	2026-11-13 02:10	3.0	OK

1.2 Data Completeness (Last 7 Days)

Station	Expected	Actual	Completeness	Status
KPWM	168	212	100.0%	OK
E4279	168	629	100.0%	OK
G5290	168	1814	100.0%	OK
G5544	168	1829	100.0%	OK
zastmet	2016	2011	99.8%	OK
ecobee_Main Floor	2016	2005	99.5%	OK
ecobee_Basement	2016	1972	97.8%	OK

1.3 Range Validation (Last 30 Days)

Station	Sensor	Expected Range	Actual Min	Actual Max	Status
KPWM	Temperature	-40 to 110	26.1	73.0	OK
KPWM	Humidity	0 to 100	0.0	100.0	OK
KPWM	Pressure	920 to 1080	1000.7	1035.2	OK
KPWM	Wind Speed	0 to 150	0.0	22.0	OK
E4279	Temperature	-40 to 110	0.0	74.0	OK
E4279	Humidity	0 to 100	0.0	100.0	OK
E4279	Pressure	920 to 1080	1000.0	1034.7	OK
E4279	Wind Speed	0 to 150	0.0	7.0	OK
G5290	Temperature	-40 to 110	22.0	72.0	OK
G5290	Humidity	0 to 100	28.0	98.0	OK
G5290	Pressure	920 to 1080	999.4	1034.0	OK
G5290	Wind Speed	0 to 150	0.0	8.0	OK
G5544	Temperature	-40 to 110	25.0	70.0	OK
G5544	Humidity	0 to 100	27.0	98.0	OK
G5544	Pressure	920 to 1080	1001.0	1035.6	OK
G5544	Wind Speed	0 to 150	0.0	2.0	OK

1.4 Station Summary

Station	Total Records	First Record	Last Record
KPWM	102,969	N/A	2026-11-12 08:51
E4279	296,629	N/A	2026-11-12 11:15
G5290	194,630	2024-08-23	2026-11-12 11:15
G5544	186,341	2024-11-27	2026-11-12 11:15
zastmet	203,392	2024-01-22	2026-11-13 00: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-09-21	1249 hours	CRITICAL
Utility Bills (monthly)	v_monthly_utilities	2026-09-02	72 days	WARNING

2.2 Energy Data Completeness

Source	Period	Expected	Actual	Completeness	Status
Electric Meter	Last 30 days	720	0.0	0.0%	CRITICAL
Electricity Bills	Since 2017	116	116.0	100.0%	OK
Gas Bills	Since 2017	116	112.0	96.6%	OK

2.3 Energy Range Validation

Metric	Expected Range	Actual Min	Actual Max	Average	Outliers	Status
Monthly Electricity (kWh)	200 - 3000	472.0	2069.0	1110.0	0.0	OK
Monthly Gas (therms)	0 - 200	20.0	288.0	110.0	18.0	WARNING

2.4 Energy Summary

Source	Total Records	First Record	Last Record	Total Value
Electric Meter (hourly)	110,508	2014-02-01	2026-09-21	160,651 kWh (net of solar export)
Utility Bills (monthly)	116 months	2017-01-02	2026-09-02	128,778 kWh + 12,330 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
power	2026-11-13 00:34	2026-11-12 23:45	39	OK
storage	2026-11-13 00:34	2026-11-13 00:34	0	OK
environmental	2026-11-13 00:34	2026-11-13 00:34	1	OK
inventory	2026-11-13 00:34	2026-11-13 00:34	35	OK
inverter_telemetry	2026-11-13 00:34	2026-11-12 18:00	10	OK
optimizer_telemetry	2026-11-13 00:34	2026-10-12 13:49	0	OK	Not available in SolarEdge API V2
power_details	2026-11-13 00:34	2026-11-13 00:30	42	OK
site	2026-11-13 00:34	2026-11-13 00:34	1	OK
equipment	2026-11-13 00:34	2026-11-13 00:34	1	OK
energy	2026-11-13 00:34	2026-11-12 00:00	2	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-11-12	96	100.0%	2,162	263	OK
2026-11-11	96	100.0%	9,911	1,606	OK
2026-11-10	96	100.0%	9,206	1,541	OK
2026-11-09	96	100.0%	9,400	1,081	OK
2026-11-08	96	100.0%	5,935	648	OK
2026-11-07	96	100.0%	2,337	246	OK
2026-11-06	96	100.0%	1,900	293	OK
2026-11-05	96	100.0%	6,797	860	OK
2026-11-04	96	100.0%	9,074	2,047	OK
2026-11-03	96	100.0%	5,233	720	OK
2026-11-02	96	100.0%	8,228	1,722	OK
2026-11-01	96	100.0%	10,037	2,494	OK
2026-10-31	96	100.0%	10,160	2,393	OK
2026-10-30	96	100.0%	9,796	2,079	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): 1

Date	Energy (Wh)	Energy (kWh)	Status
2026-11-13	—	—	MISSING
2026-11-12	6,305	6.30	OK
2026-11-11	41,687	41.69	OK
2026-11-10	35,977	35.98	OK
2026-11-09	24,867	24.87	OK
2026-11-08	15,331	15.33	OK
2026-11-07	5,949	5.95	OK
2026-11-06	7,001	7.00	OK
2026-11-05	20,466	20.47	OK
2026-11-04	49,434	49.43	OK
2026-11-03	17,301	17.30	OK
2026-11-02	41,819	41.82	OK
2026-11-01	59,884	59.88	OK
2026-10-31	57,775	57.77	OK
2026-10-30	50,947	50.95	OK
2026-10-29	55,910	55.91	OK
2026-10-28	42,818	42.82	OK
2026-10-27	62,903	62.90	OK
2026-10-26	37,043	37.04	OK
2026-10-25	61,524	61.52	OK
2026-10-24	62,347	62.35	OK
2026-10-23	63,829	63.83	OK
2026-10-22	43,165	43.16	OK
2026-10-21	57,478	57.48	OK
2026-10-20	62,933	62.93	OK
2026-10-19	63,670	63.67	OK
2026-10-18	64,012	64.01	OK
2026-10-17	40,787	40.79	OK
2026-10-16	4,786	4.79	OK
2026-10-15	64,405	64.41	OK

4.4 Solar Data Summary

27,781

Power Readings

290

Days of Energy Data

13,754.5

Total kWh Produced

47.4

Avg Daily kWh

80.8

Best Day kWh

100.0%

Day Coverage

Metric	Value	Status
Power data freshness	0h since last reading	OK
Data collection start	2026-01-27	OK
Days with data / Calendar days	290 / 290 (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

290

Calendar Days in Span

Days with No Power Data

Days <95% Complete

Missing Energy Records

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