监测点MP15： 2023-12-15 10:23:15.326 [X: 234567.892, Y: 3456789.123, Z: 1234.567]
监测点MP16： 2023-12-15 10:23:15.892 [X: 234569.123, Y: 3456790.234, Z: 1235.678]
基准点REF01：2023-12-15 10:23:15.623 [X: 234432.456, Y: 3456654.789, Z: 1242.345]

gnss接收机配置参数
Sampling Rate: 1Hz
Cut-off Angle: 10°
PDOP Limit: 3.0
RTK Mode: VRS
Data Link: 4G Network

// 网络延迟统计
Base Station -> Control Center: 45-78ms
Monitoring Points -> Control Center: 120-350ms
VRS Data Delay: 200-450ms
Package Loss Rate: 0.5%-2%

-- 数据时间戳查询
SELECT point_id, time_stamp, 
       LEAD(time_stamp) OVER (PARTITION BY point_id ORDER BY time_stamp) - time_stamp as time_diff
FROM raw_data
WHERE collect_time > '2023-12-15 00:00:00'
  AND collect_time < '2023-12-15 23:59:59';

// ComNav K708接收机固件更新
Firmware Version: 5.2.3 -> 5.3.1
PPS Output: Enabled
Clock Sync: GPS Time
Reference Station Selection: Auto

// 网络QoS配置（华为AR3260路由器）
interface GigabitEthernet 0/0/1
 qos lr outbound cir 2048 pir 4096
 qos priority-queue
 traffic-policy GNSS-DATA outbound

// 数据同步处理类
public class DataSynchronizer
{
    private const int SYNC_WINDOW = 100; // 100ms同步窗口
    private readonly ConcurrentDictionary<string, Queue<GnssData>> _dataBuffer;

    public void ProcessData(GnssData data)
    {
        var baseTime = GetBaseStationTime();
        if (Math.Abs((data.Timestamp - baseTime).TotalMilliseconds) <= SYNC_WINDOW)
        {
            // 数据同步处理
            SynchronizeData(data);
        }
    }
}

-- 优化数据存储结构
CREATE TABLE monitoring_data (
    id SERIAL PRIMARY KEY,
    point_id VARCHAR(10),
    timestamp TIMESTAMP WITH TIME ZONE,
    x DOUBLE PRECISION,
    y DOUBLE PRECISION,
    z DOUBLE PRECISION,
    pdop REAL,
    satellites INTEGER,
    solution_type SMALLINT
) PARTITION BY RANGE (timestamp);

-- 创建时间索引
CREATE INDEX idx_monitoring_data_time 
ON monitoring_data USING BRIN (timestamp);