guanlan-src/app_ETL/configs/contracts/sewind_w2000_nanshu.yaml

# 数据契约 — 上海电气 SEWIND W2000 2MW 齿箱DFIG (华电莱西南墅一期, 山东莱西 / 华电)
# schema_v2 SOP 标准件 (2026-07-18, 新场 onboard)。
#
# ★ 主分析层 = GBK CSV (SCADA_Minute_莱西南墅_A1-A25_<周>.csv, 单位嵌列名, 全25台/周块); 契约验原始CSV列名(非归一化)。
# reuse: 上海电气 SEWIND W2000 家族 (库内 sewind_w2000_{99_guojiadian,110_80,116_tanglong_p3} 语义层); W2000-南墅变体本场重验。
schema_version: 2

meta:
  oem: 上海电气 SEWIND
  model: W2000 2MW 齿箱DFIG (叶轮变体待定; 华电莱西49.8MW/25台=2MW)
  topology: dfig_geared            # ✅齿轮箱润滑油温+高/低速轴承温+发电机转速p50=1022高速轴
  rated_kw: 2000                   # ✅实证: 有功功率 p99~2029/max2081 (2MW级)
  rotor_d_m: null                  # 🟡 待定(docx表未抽; 库有99/105/110/116; 华电莱西2MW疑105/110待功率曲线/pdf)
  hub_height_m: null
  source_farm: 华电莱西南墅一期(49.8MW, 山东莱西, 华电)
  n_machines: 25                   # ✅ 风机名称 1-25 全有数据
  layout:
    format: "GBK CSV SCADA_Minute_莱西南墅_A1-A25_<起>-<止>.csv (周块, 全25台一文件); 22列单位嵌列名"
    encoding: gbk
    time_format: "YYYY-MM-DD HH:MM:SS (前导空格)"
    assemble: "scripts/nanshu_assemble.py (per周CSV concat; 机号=风机名称1-25; 列名即canonical带单位后缀)"
  sampling:
    turbine_10min_s: 600
    window: "2024-07-03 ~ 2025-07-03 约12月 (66周块CSV)"

turbine_10min:
  sampling_s: 600
  required: ["有功功率(kW)", "10min滑动平均风速(m/s)"]
  machine_col: 风机名称
  time_col: 时间
  columns:
    "有功功率(kW)":
      canonical_id: WAPC_active_power
      raw_unit: kW
      valid_range: [-100, 2200]
      observed_range: [-50, 2081]        # ✅ p99~2029(rated2000 plateau); 负=空转寄生真物理禁clip
      self_ref_note: "本场无测风塔 → 绝对达成率INSUFFICIENT"
    "10min滑动平均风速(m/s)":
      canonical_id: WMET_horWdSpd
      unit: m/s
      valid_range: [0, 40]
      observed_range: [0, 30]
      self_ref_risk: high
    "风轮转速(rpm)": {canonical_id: WROT_RotSpd, unit: rpm, valid_range: [-2, 22], observed_range: [0, 18]}
    "发电机转速(rpm)": {canonical_id: WGEN_Spd, unit: rpm, valid_range: [-2, 2100], observed_range: [0, 1910],
      semantic: "★高速轴p50=1022(齿箱DFIG; vs风轮转速转子)"}

    # ---- 变桨 (★per叶独立) ----
    "桨距角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]}

    # ---- 温度 (齿箱DFIG) ----
    "齿轮箱润滑油温度(℃)": {canonical_id: WTRM_TmpGbxOil, unit: degC, valid_range: [-40, 130], observed_range: [0, 77],
      semantic: "★温度NBM冷浸参照(油温); 0值=停机态(发电态过滤剔)"}
    "齿轮箱冷却水温度(℃)": {canonical_id: WTRM_TmpGbxCool, unit: degC, valid_range: [-40, 130], observed_range: [0, 70]}
    "低速轴承温度(℃)": {canonical_id: WTRM_TmpMainBrg, unit: degC, valid_range: [-40, 130], observed_range: [0, 110],
      semantic: "低速轴(主轴)轴承; 高/低速轴承配对差可做"}
    "高速轴承温度(℃)": {canonical_id: WTRM_TmpGbxHSS, unit: degC, valid_range: [-40, 130], observed_range: [0, 86]}
    "发电机定子U温度(℃)": {canonical_id: WGEN_TmpStaU, unit: degC, valid_range: [-40, 200], observed_range: [0, 124],
      semantic: "★定子三相U/V/W → 相间不平衡可做"}
    "发电机定子V温度(℃)": {canonical_id: WGEN_TmpStaV, unit: degC, valid_range: [-40, 200], observed_range: [0, 124]}
    "发电机定子W温度(℃)": {canonical_id: WGEN_TmpStaW, unit: degC, valid_range: [-40, 200], observed_range: [0, 124]}
    "发电机前轴承温度(℃)": {canonical_id: WGEN_TmpBrgFront, unit: degC, valid_range: [-40, 130], observed_range: [0, 90],
      semantic: "发电机前/后轴承双端 → 配对差可做"}
    "发电机后轴承温度(℃)": {canonical_id: WGEN_TmpBrgRear, unit: degC, valid_range: [-40, 130], observed_range: [0, 90]}
    "舱内温度(℃)": {canonical_id: WNAC_IntTmp, unit: degC, valid_range: [-40, 80], observed_range: [-5, 55]}
    "舱外温度(℃)": {canonical_id: WNAC_ExtTmp, unit: degC, valid_range: [-50, 60], observed_range: [-3, 41],
      trap: "🟡 cross-turbine同窗核前provisional; 单台变动合理(山东季节)"}

    # ---- 位置/风向 ----
    "机舱位置(°)": {canonical_id: WNAC_Dir, unit: deg, valid_range: [0, 360], observed_range: [0, 360],
      trap: "方位角[0,360) → 扇区可做(过pseudo-geo三件套); 非扭角"}
    "风向角(°)": {canonical_id: WYAW_YawErr, unit: deg, valid_range: [-180, 180], observed_range: [-18, 18],
      semantic: "对风误差(机舱相对风向); p50=0 对中好; 静态/动态偏航可做"}

cleaning:
  physical:
    - "有功功率负值=空转寄生真物理禁clip"
    - "valid_range界外→NaN非clamp; 温度0值=停机态(发电态P>50过滤剔)"
    - "无850哨兵; 无明显哨兵族(扫6周池)"
  semantic:
    - "风速self_ref+无测风塔 → 绝对达成率INSUFFICIENT"
    - "机舱位置=方位角[0,360) → 扇区(过pseudo-geo三件套); 风向角=对风误差非地理"
  derive:
    - "10min已是时均层(南墅原生); per周CSV concat"

traps:
  - "★**齿箱DFIG 2MW SEWIND W2000**: 齿箱油+高/低速轴承+发电机转速1022高速轴; 库复用sewind_w2000家族"
  - "★**单位嵌列名**(有功功率(kW)/桨距角1(°)/...℃) → 契约列名带单位后缀, 装配器直读"
  - "★**per叶桨距(桨距角1/2/3)** → 三叶不平衡可做; **定子三相U/V/W** → 相间不平衡; 高/低速轴承+发电机前后轴承 配对差"
  - "机舱位置=方位角非扭角; 风向角=对风误差[-18,18]"
  - "叶轮变体待定(库99/105/110/116; 待功率曲线/pdf); 无测风塔→绝对达成率INSUFFICIENT"