# 数据契约 — 中船海装 CSSC 齿箱DFIG 2MW (龙口二期-海装, 山东龙口 / 华电)
# schema_v2 SOP 标准件 (2026-07-18, 新场 onboard; 库内首个海装场)。
#
# ★★ 验 name-based 归一化后 parquet (scripts/longkou_haizhuang_assemble.py 输出 canonical 列名):
#    剥 per台数字前缀(A01→401_.../A025→625_) + 4段(变流器/电网/机械/振动) 按`采样时间`join。
# ★★ 海装二期 25台 A01-A025; 东气一期(DF93直驱23台/DF110齿箱6台) 另契约。
#
# reuse: 库内无海装契约参照, 本场首个海装 (envision_hailesi=远景非海装)。
schema_version: 2

meta:
  oem: 中船海装 (CSSC Haizhuang)
  model: 2MW级齿箱DFIG (精确型号待读 海装风机技术参数.pdf)
  topology: geared_dfig            # ✅铁证: 齿轮箱全套仪表 + 发电机转速~1088-1100rpm高速轴(vs风轮转速8.6rpm转子)
  rated_kw: 2000                   # ✅provisional: 有功功率 p99跨台~2110-2125/max~2165-2191 (2MW级, 10%过发); 精确待pdf
  source_farm: 龙口二期-海装 (山东龙口, 华电)
  n_machines: 25                   # A01-A025 (二期26台铭牌 vs 25台数据, 缺1台)
  layout:
    format: "xls扁平 <台>-<年月>-[<结束月>-]600-<段1/2/4/5>.xls; **归一化经 assembler**"
    assemble: "scripts/longkou_haizhuang_assemble.py (剥per台前缀 re r'\\d+_' + 4段join on 采样时间; 前缀读实际非算)"
    prefix_per_turbine: "★列名带per台前缀(A01→401/A09→509/A018→618/A025→625, 按线路4xx/5xx/6xx分段) → 剥前缀得canonical"
    segments: "4段按子系统拆(段3缺): 段1变流器+功率+齿箱 / 段2电网+6绕组+发电机+风轮 / 段4偏航+双风速+per叶变桨 / 段5机舱振动+主轴双轴承+环境; 按采样时间join(A01四段交集4198=全对齐)"
  sampling:
    turbine_10min_s: 600
    window: "★2024-12 ~ 2025-11 约12月 (修正: 文件名'2025-01-11'的11=结束月Jan到Nov, 非单月2月; ON-1原误判2月已撤)"

turbine_10min:
  sampling_s: 600
  required: [有功功率, 瞬时风速]
  machine_col: _tid
  time_col: 时间
  columns:
    时间: {role: timestamp}

    有功功率:
      canonical_id: WTUR_W
      unit: kW
      valid_range: [-150, 2300]
      observed_range: [-27, 2191]        # ✅ p99~2110-2125(rated2000 2MW级 plateau); 负=空转寄生真物理禁clip
      self_ref_note: "剥前缀后='有功功率'(段1); 段2另有'电网有功功率'/'发电机有功功率'多源; 本场无测风塔→绝对达成率INSUFFICIENT"

    瞬时风速:
      canonical_id: WMET_horWdSpd
      unit: m/s
      valid_range: [0, 40]
      observed_range: [0, 29.2]
      self_ref_risk: high
      trap: "★**双风速仪冗余**(1#风速计/2#风速计瞬时风速) → 风速传感器交叉核可做(区别东气/乾安单信号复制); 仍机舱风self_ref"

    # ---- 齿箱 (★齿箱机型标志) ----
    齿轮箱油池温度: {canonical_id: WTRM_TmpGbxOil, unit: degC, valid_range: [-40, 130], observed_range: [10, 74],
      semantic: "★温度NBM冷浸参照(油温); 齿箱DFIG"}
    齿轮箱进口油温: {canonical_id: WTRM_TmpGbxOilIn, unit: degC, valid_range: [-40, 130], observed_range: [10, 74]}
    齿轮箱高速轴前端温度: {canonical_id: WTRM_TmpGbxHSSFront, unit: degC, valid_range: [-40, 130], observed_range: [12, 80]}
    齿轮箱高速轴后端温度: {canonical_id: WTRM_TmpGbxHSSRear, unit: degC, valid_range: [-40, 130], observed_range: [12, 80]}
    齿轮箱冷却水温度: {canonical_id: WTRM_TmpGbxCool, unit: degC, valid_range: [-40, 130], observed_range: [0, 0], dead_channel: true, note: "🔴全场恒0死列(A01/A09/A025 p50=0); 禁入; 齿箱冷却走进口/油池温"}
    齿轮箱进口压力:
      canonical_id: WHYD_PressGbxIn
      unit: bar
      valid_range: [-1, 20]
      observed_range: [0, 8.8]
      semantic: "★**双压通道之一** (+齿轮箱油泵出口压力) → ⑥冷臂dP 差模/共模分解可做(memory hydraulic_dp 需双压场; 此前仅义渡口有!)"
    齿轮箱油泵出口压力: {canonical_id: WHYD_PressGbxPump, unit: bar, valid_range: [-1, 25], observed_range: [0, 13.1],
      semantic: "★双压通道之二 → ⑥冷臂dP双压分解"}

    # ---- 发电机 (★6绕组双星) ----
    发电机绕组u1温度: {canonical_id: WGEN_TmpStaU1, unit: degC, valid_range: [-40, 200], observed_range: [9, 110],
      semantic: "★**6绕组温(u1/v1/w1/u2/v2/w2 双星)** → 相间不平衡诊断富(区别东气3相/乾安3相)"}
    发电机绕组v1温度: {canonical_id: WGEN_TmpStaV1, unit: degC, valid_range: [-40, 200], observed_range: [9, 110]}
    发电机绕组w1温度: {canonical_id: WGEN_TmpStaW1, unit: degC, valid_range: [-40, 200], observed_range: [9, 110]}
    发电机绕组u2温度: {canonical_id: WGEN_TmpStaU2, unit: degC, valid_range: [-40, 200], observed_range: [9, 110]}
    发电机绕组v2温度: {canonical_id: WGEN_TmpStaV2, unit: degC, valid_range: [-40, 200], observed_range: [9, 110]}
    发电机绕组w2温度: {canonical_id: WGEN_TmpStaW2, unit: degC, valid_range: [-40, 200], observed_range: [9, 110]}
    发电机绕组最高温度: {canonical_id: WGEN_TmpStaMax, unit: degC, valid_range: [-40, 200], observed_range: [9, 115]}
    发电机冷却水温度: {canonical_id: WGEN_TmpCool, unit: degC, valid_range: [-40, 130], observed_range: [5, 70]}
    发电机前轴承温度: {canonical_id: WGEN_TmpBrgFront, unit: degC, valid_range: [-40, 130], observed_range: [4, 78],
      semantic: "发电机前/后轴承双端 → 配对差可做"}
    发电机后轴承温度: {canonical_id: WGEN_TmpBrgRear, unit: degC, valid_range: [-40, 130], observed_range: [4, 78]}

    发电机转速:
      canonical_id: WGEN_Spd
      unit: rpm
      valid_range: [-2, 2100]
      observed_range: [0, 1891]
      semantic: "★高速轴~1088-1100rpm(齿箱DFIG铁证; vs风轮转速8.6转子, 齿比~128)"
      note: "★A09全部p50=12 但**发电态(P>50)p50=1291正常**(RV-1+V-019复现: p50=12是A09停机81%的聚合假象非坏传感器); 判转速必发电态过滤"
    发电机转矩: {canonical_id: WGEN_Trq_pct, unit: "%", valid_range: [-5, 105], observed_range: [-1, 100], note: "★=转矩百分比(0-100%)非N·m; p50=4.2"}
    风轮转速: {canonical_id: WROT_Spd, unit: rpm, valid_range: [-2, 22], observed_range: [0, 14.9],
      semantic: "转子转速~8.6rpm; +风轮转速1/2/差值 冗余"}
    风轮位置: {canonical_id: WNAC_Dir, unit: deg, valid_range: [0, 360], observed_range: [0, 359.9],
      trap: "方位角[0,360) → 扇区可做(过pseudo-geo三件套)"}

    # ---- 主轴 + 振动 + 环境 ----
    主轴前轴承温度: {canonical_id: WTRM_TmpMainBrgFront, unit: degC, valid_range: [-40, 130], observed_range: [3, 46],
      semantic: "主轴前/后轴承双端 → 配对差第二组"}
    主轴后轴承温度: {canonical_id: WTRM_TmpMainBrgRear, unit: degC, valid_range: [-40, 130], observed_range: [3, 46]}
    机舱X方向振动: {canonical_id: WNAC_VibX, unit: g, valid_range: [-2, 2], observed_range: [-0.5, 0.5]}
    机舱Y方向振动: {canonical_id: WNAC_VibY, unit: g, valid_range: [-2, 2], observed_range: [-0.5, 0.5]}
    机舱振动有效值: {canonical_id: WNAC_VibRMS, unit: g, valid_range: [0, 2], observed_range: [0, 0.5]}
    环境温度:
      canonical_id: WNAC_ExtTmp
      unit: degC
      valid_range: [-50, 60]
      observed_range: [-9, 40]
      trap: "🟡 cross-turbine同窗核前provisional(同东气caveat)"
    机舱温度: {canonical_id: WNAC_IntTmp, unit: degC, valid_range: [-40, 80], observed_range: [-5, 50]}

    # ---- 偏航 + 变桨 ----
    顺时针偏航运行时间: {canonical_id: WYAW_TimeCW, unit: s, valid_range: [0, 100000000], observed_range: [0, 10000000],
      semantic: "偏航运行时间(顺/逆) → 偏航磨损剂量; 累计量差分"}
    逆时针偏航运行时间: {canonical_id: WYAW_TimeCCW, unit: s, valid_range: [0, 100000000], observed_range: [0, 10000000]}
    轴制动液压: {canonical_id: WHYD_PressBrake, unit: bar, valid_range: [-1, 400], observed_range: [0, 359], note: "刹车液压高压~200-340bar; 原[-1,250]太低致BLOCK"}
    "1#叶片变桨角度": {canonical_id: WROT_PtAngBlade1, unit: deg, valid_range: [-5, 95], observed_range: [0, 90],
      semantic: "★per叶独立(1#/2#/3#) → 三叶不平衡可做(区别乾安集距)"}
    "2#叶片变桨角度": {canonical_id: WROT_PtAngBlade2, unit: deg, valid_range: [-5, 95], observed_range: [0, 90]}
    "3#叶片变桨角度": {canonical_id: WROT_PtAngBlade3, unit: deg, valid_range: [-5, 95], observed_range: [0, 90]}

cleaning:
  physical:
    - "有功功率负值=空转寄生真物理禁clip"
    - "valid_range界外→NaN非clamp; 齿箱压力/温 0值=停机态(发电态P>50过滤自然剔)"
    - "无850哨兵(区别东气/乾安); 其余哨兵待扫"
  semantic:
    - "风速self_ref+无测风塔 → 绝对达成率INSUFFICIENT; 但双风速仪可交叉核"
    - "风轮位置=方位角[0,360) → 扇区(过pseudo-geo三件套)"
    - "偏航运行时间累计量差分"
  derive:
    - "10min已是时均层(海装原生); 4段join后单记录"
    - "★温度NBM发展性**可做**(窗约12月2024-12~2025-11); 齿箱冷浸参照=油温"

traps:
  - "★**剥per台前缀+4段join**: 列名带per台数字前缀(读实际非算) + 4段按采样时间join(段3缺)"
  - "★**窗约12月非2月**(文件名'2025-01-11'的11=结束月; ON-1原误判修正) → 温度NBM发展性可做"
  - "★**齿箱DFIG 2MW**: 齿箱全套+发电机转速1100rpm高速轴; 双压通道(齿箱进口+油泵出口)→⑥冷臂dP双压分解(稀缺!)"
  - "★**6绕组双星** → 相间不平衡富; **双风速仪** → 传感器交叉核; per叶变桨 → 三叶不平衡"
  - "A09转速全p50=12=停机81%聚合假象(发电态p50=1291正常, RV-1订正, 非坏传感器); A020 p99低(高风数据少非异型)"
  - "无850哨兵(区别东气/乾安)"