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

schema_version: 2
meta:
  oem: 远景 Envision (USCADA/EnOS 平台, 英文canonical列)
  model: EN182-6250 (6.25MW DFIG semi-direct, D182)
  rated_kw: 6250
  rated_note: 高风plateau实测 p50=6369/p99=6690 (短时boost超发) → p_active上界按6900放
  n_turbines: 64
  farm: hailesi
  site: 内蒙 海勒斯 (大唐)
  commissioned: null
  windows:
    src_1min: 2025-10-15~2025-10-24 (10天, 61-64台/日, 60s实测)
  self_ref_risk: true
  curtailment_verdict_cap: INSUFFICIENT (无限电指令列, fault/scada状态=位掩码未解码)
  sister_farm: aodu (吉林敖都, 同型EN182 ×16, 2025-10-16~24 — ✅已契约化 envision_en182_6250_aodu.yaml 2026-07-17, 同型复用+逐列实测)
cleaning:
  physical: valid_range 界外→NaN (apply_contract_gate, 非clamp); 无int哨兵 (NaN表缺测, goem哨兵扫描=0) 但range闸仍防; wind_dir wrap至[-180,180)
  semantic: 状态列= status role 不清洗数值; 死列(11farmwide)保留列位全NaN + clean_gate 记账; machine_id=装配注入turbine_hash; section=turbine_sec(1-min原生高频层)为分析正层(P赛道), 10min派生层可后补
traps:
- 'gen_brg_temp_1-4 全场死列 — 发电机轴承温度实际走 gen_de_temp/gen_nde_temp (命名陷阱: brg编号列≠实测列)'
- 'main_brg_temp_2 全NaN / temp_3 全零 → 仅 temp_1 活: 主轴承双通道互证物理不可行 (verification REFUTE 案先验)'
- theory_p_active/hyd_station_prs/wtg_sts(常量4)/conv_*_reactor_temp/nacelle_out_temp 全场死
- 'hash台名假名制 (30MpvF6O 等): gym/相对分析可用, 实名报告 BLOCKED 待映射表'
- 'fault_sts/scada_wtg_sts 含位掩码大数 (540024896等): 勿当枚举平均; 限电确诊 INSUFFICIENT'
- wind_dir 混合编码 [-180,360] 需 wrap; yaw_to_wind_ang 已是带符号 native
- '数据窗仅10天: 季节性判据(R-M3)不适用; NBM calib 窗不足跨季 — 变化型筛查按 SOP §0.2 降级表'
turbine_sec:
  sampling_s: 60
  columns:
    localtime:
      role: timestamp
    turbine_hash:
      role: provenance
      observed_range:
      - 0
      - 63
      note: hadoop hash 假名原串 (追溯/fingerprint用); 实名映射待业主索资
    pitch_motor_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -5.0
      - 72.68
    yaw_to_wind_ang:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -180
      - 180
      observed_range:
      - -179.98
      - 179.98
      note: native 带符号对风角 (发电中位0.2°, neg_frac .497) — panel 前提门 PASS
    gearbox_oil_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 4.2
      - 63.86
    gen_nde_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 6.7
      - 89.13
    high_spd_shaft_de_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 4.7
      - 74.89
    theory_p_active:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -1.0
      - 2.5
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    p_reactive:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -3500
      - 3500
      observed_range:
      - -565.84
      - 184.9
    pitch_cab_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 24.0
    pitch_ang_act_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 95
      observed_range:
      - -168.65
      - 89.59
      note: 真三叶 IPC (全场60/60台发电中极差p95>1°, 中位2.86°) — P赛道数据源核
    conv_mach_reactor_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    wtg_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障)'
      observed_range:
      - 4.0
      - 4.0
      dead_channel: true
    scada_wtg_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障)'
      observed_range:
      - 0
      - 4194306.0
    high_spd_shaft_nde_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 4.8
      - 80.32
    gen_brg_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 6.7
      - 89.0
    pitch_motor_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -3.99
      - 60.88
    pitch_motor_cur_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 300
      observed_range:
      - 0
      - 43.12
    gen_de_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 6.9
      - 79.74
    wind_spd:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 60
      observed_range:
      - 0.4
      - 19.27
      note: '机舱风速计 (转子后自指): 禁绝对功率曲线/Cp 定论 (self_ref)'
    p_active:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -200
      - 6900
      observed_range:
      - -63.0
      - 6788.46
    stator_wind_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 160
      observed_range:
      - 4.0
      - 120.4
    hyd_station_prs:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 400
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    grid_ua:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 1500
      observed_range:
      - 1091.7
      - 1194.4
    main_brg_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    cw_yaw_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障)'
      observed_range:
      - 0
      - 1.0
    pitch_bat_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 23.78
    conv_grid_reactor_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    pitch_cab_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 23.0
    nacelle_cab_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 13.3
      - 46.5
    pitch_motor_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -2.46
      - 54.99
    ccw_yaw_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障)'
      observed_range:
      - 0
      - 1.0
    twist_ang:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -1440
      - 1440
      observed_range:
      - -503.52
      - 537.84
    set_torque:
      raw_unit: Nm (gen侧; 验算 35750Nm×175rad/s≈6.25MW)
      valid_range:
      - -2000
      - 45000
      observed_range:
      - 0
      - 35750.67
    vendor_access_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障)'
      observed_range:
      - 1.0
      - 9.0
    gen_brg_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    pitch_ang_act_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 95
      observed_range:
      - -23.7
      - 92.0
      note: 真三叶 IPC (全场60/60台发电中极差p95>1°, 中位2.86°) — P赛道数据源核
    wind_dir:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -180
      - 360
      observed_range:
      - -179.99
      - 360.0
      note: '混合编码观测[-180,360]: 清洗 wrap 到 [-180,180)'
    fault_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障)'
      observed_range:
      - 0
      - 1447646336.0
    grid_ic:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 8000
      observed_range:
      - 0
      - 3256.0
    stator_wind_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 160
      observed_range:
      - 3.7
      - 121.14
    nacelle_out_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    grid_ub:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 1500
      observed_range:
      - 1108.8
      - 1190.0
    tower_base_cab_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 9.4
      - 32.3
    pitch_bat_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 23.0
    mid_spd_shaft_nde_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 5.2
      - 65.02
    gen_spd:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 2500
      observed_range:
      - 0
      - 1849.48
    gb_in_oil_prs:
      raw_unit: bar (p50=1.8; 负小值=零漂)
      valid_range:
      - -5
      - 25
      observed_range:
      - -4.0
      - 3.99
    rotor_spd:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 15
      observed_range:
      - 0
      - 9.98
    vendor_wtg_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障)'
      observed_range:
      - 1.0
      - 9.0
    actual_torque:
      raw_unit: Nm (gen侧; 验算 35750Nm×175rad/s≈6.25MW)
      valid_range:
      - -2000
      - 45000
      observed_range:
      - 0
      - 35725.52
    gen_brg_temp_4:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    pitch_ang_act_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 95
      observed_range:
      - -5.74
      - 94.94
      note: 真三叶 IPC (全场60/60台发电中极差p95>1°, 中位2.86°) — P赛道数据源核
    pitch_cab_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 5.0
      - 24.0
    tower_fb_vib:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -10
      - 10
      observed_range:
      - 0
      - 2.78
    stator_wind_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 160
      observed_range:
      - 4.0
      - 120.4
    pitch_motor_cur_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 300
      observed_range:
      - 0
      - 30.13
    grid_ib:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 8000
      observed_range:
      - 0
      - 3280.0
    nacelle_in_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 5.14
      - 30.5
    main_brg_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    main_shaft_spd:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 15
      observed_range:
      - 0
      - 10.12
    pitch_bat_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 5.14
      - 23.26
    grid_uc:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 1500
      observed_range:
      - 1115.5
      - 1186.9
    tower_base_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -0.96
      - 847.5
      sentinel:
      - 847.5
      note: 847.5=哨兵/坏块(p99被其污染), range闸+sentinel双杀
    main_brg_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 4.6
      - 38.7
      note: 唯一活主轴承温 (temp_2 全NaN/temp_3 全零) — 双通道互证不可行 (REFUTE案先验); 30MpvF6O=探头加性偏置案
    mid_spd_shaft_de_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 5.3
      - 65.6
    grid_freq:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 45
      - 55
      observed_range:
      - 49.95
      - 50.05
    yaw_ang:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -756.28
      - 807.76
      observed_range:
      - -503.52
      - 537.84
    gen_brg_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0
      - 1
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
    nacelle_pos:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -1440
      - 1440
      observed_range:
      - -662.74
      - 611.06
      note: 累计机舱位置(±662°观测, 含解缆圈数) — 非0-360方位; 方位角=yaw_ang
    pitch_motor_cur_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 300
      observed_range:
      - 0
      - 52.1
    tower_lr_vib:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -10
      - 10
      observed_range:
      - 0
      - 2.78
    grid_ia:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 8000
      observed_range:
      - 0
      - 3320.0
    turbine_idx:
      role: machine_id
      valid_range:
      - 0
      - 63
      observed_range:
      - 0
      - 63
      note: '装配注入: hash台名字典序索引; machine_col 用本列 (字符串hash列会被population断言误报)'
  section_note: 1-min 原生高频层 (60s 实测); canonical section 集无 turbine_1min → 按"高频原生层"归 turbine_sec, sampling_s=60 载真值