Environmental Sensor Network Data Integration Platform

Design a PostgreSQL solution for integrating real-time environmental sensor data from multiple geographically distributed research stations. Create a flexible schema that can handle heterogeneous sensor types (temperature, humidity, air quality) with automatic data normalization and anomaly detection. Implement a sliding window approach for continuous data aggregation and develop alert triggers for detecting statistically significant environmental changes.