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-10-22 07:51	16.0	WARNING
E4229	2026-10-22 10:15	14.0	WARNING
E4279	2026-10-22 10:15	14.0	WARNING
G5290	2026-10-22 10:15	14.0	WARNING
G5544	2026-10-22 10:15	14.0	WARNING
zastmet	2026-10-23 00:30	0.1	OK
ecobee_Main Floor	2026-10-23 03:55	0.0	OK
ecobee_Basement	2026-10-23 01:20	3.0	OK

1.2 Data Completeness (Last 7 Days)

Station	Expected	Actual	Completeness	Status
KPWM	168	167	99.4%	OK
E4229	168	603	100.0%	OK
E4279	168	634	100.0%	OK
G5290	168	1772	100.0%	OK
G5544	168	1794	100.0%	OK
zastmet	2016	2015	100.0%	OK
ecobee_Main Floor	2016	2006	99.5%	OK
ecobee_Basement	2016	1977	98.1%	OK

1.3 Range Validation (Last 30 Days)

Station	Sensor	Expected Range	Actual Min	Actual Max	Status
KPWM	Temperature	-40 to 110	27.0	82.0	OK
KPWM	Humidity	0 to 100	0.0	100.0	OK
KPWM	Pressure	920 to 1080	1000.7	1037.3	OK
KPWM	Wind Speed	0 to 150	0.0	19.0	OK
E4229	Temperature	-40 to 110	0.0	84.0	OK
E4229	Humidity	0 to 100	0.0	99.0	OK
E4229	Pressure	920 to 1080	1003.9	1037.3	OK
E4229	Wind Speed	0 to 150	0.0	9.0	OK
E4279	Temperature	-40 to 110	0.0	80.0	OK
E4279	Humidity	0 to 100	0.0	100.0	OK
E4279	Pressure	920 to 1080	1000.0	1037.1	OK
E4279	Wind Speed	0 to 150	0.0	6.0	OK
G5290	Temperature	-40 to 110	26.0	81.0	OK
G5290	Humidity	0 to 100	30.0	98.0	OK
G5290	Pressure	920 to 1080	999.4	1036.2	OK
G5290	Wind Speed	0 to 150	0.0	6.0	OK
G5544	Temperature	-40 to 110	27.0	79.0	OK
G5544	Humidity	0 to 100	34.0	98.0	OK
G5544	Pressure	920 to 1080	1001.0	1037.8	OK
G5544	Wind Speed	0 to 150	0.0	1.0	OK

1.4 Station Summary

Station	Total Records	First Record	Last Record
KPWM	102,409	N/A	2026-10-22 07:51
E4229	303,065	N/A	2026-10-22 10:15
E4279	294,564	N/A	2026-10-22 10:15
G5290	188,609	2024-08-23	2026-10-22 10:15
G5544	180,313	2024-11-27	2026-10-22 10:15
zastmet	197,337	2024-01-22	2026-10-23 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	745 hours	CRITICAL
Utility Bills (monthly)	v_monthly_utilities	2026-09-02	51 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
inverter_telemetry	2026-10-23 00:34	2026-10-22 19:45	17	OK
optimizer_telemetry	2026-10-23 00:34	2026-10-12 13:49	0	OK	Not available in SolarEdge API V2
power	2026-10-23 00:34	2026-10-22 23:45	39	OK
storage	2026-10-23 00:34	2026-10-23 00:34	0	OK
environmental	2026-10-23 00:34	2026-10-23 00:34	1	OK
inventory	2026-10-23 00:34	2026-10-23 00:34	35	OK
power_details	2026-10-23 00:34	2026-10-23 00:30	42	OK
site	2026-10-23 00:34	2026-10-23 00:34	1	OK
equipment	2026-10-23 00:34	2026-10-23 00:34	1	OK
energy	2026-10-23 00:34	2026-10-22 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-10-22	96	100.0%	9,016	1,813	OK
2026-10-21	96	100.0%	10,760	2,420	OK
2026-10-20	96	100.0%	10,300	2,622	OK
2026-10-19	96	100.0%	10,443	2,653	OK
2026-10-18	96	100.0%	10,446	2,667	OK
2026-10-17	96	100.0%	8,602	1,745	OK
2026-10-16	96	100.0%	1,148	197	OK
2026-10-15	96	100.0%	10,614	2,677	OK
2026-10-14	96	100.0%	8,986	1,218	OK
2026-10-13	96	100.0%	888	126	OK
2026-10-12	96	100.0%	10,038	2,504	OK
2026-10-11	96	100.0%	3,036	761	OK
2026-10-10	96	100.0%	10,835	2,669	OK
2026-10-09	96	100.0%	10,720	1,930	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-10-23	—	—	MISSING
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
2026-10-14	27,637	27.64	OK
2026-10-13	3,006	3.01	OK
2026-10-12	59,456	59.46	OK
2026-10-11	18,292	18.29	OK
2026-10-10	64,091	64.09	OK
2026-10-09	48,232	48.23	OK
2026-10-08	45,247	45.25	OK
2026-10-07	58,996	59.00	OK
2026-10-06	64,507	64.51	OK
2026-10-05	54,423	54.42	OK
2026-10-04	48,290	48.29	OK
2026-10-03	65,529	65.53	OK
2026-10-02	28,609	28.61	OK
2026-10-01	54,035	54.03	OK
2026-09-30	12,658	12.66	OK
2026-09-29	19,343	19.34	OK
2026-09-28	7,384	7.38	OK
2026-09-27	8,715	8.71	OK
2026-09-26	21,824	21.82	OK
2026-09-25	45,325	45.33	OK
2026-09-24	66,743	66.74	OK

4.4 Solar Data Summary

25,765

Power Readings

269

Days of Energy Data

12,833.0

Total kWh Produced

47.7

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	269 / 269 (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

269

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