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

schema_version: 2
meta:
  oem: 远景 Envision (USCADA/EnOS 平台, 英文canonical列)
  model: EN182-6250 (6.25MW DFIG semi-direct, D182)
  rated_kw: 6250
  rated_note: ⚠aodu 9天窗全场低风(max ws≈9.0m/s, p_active max 3695kW)未达额定 → rated=6250 继承同型 hailesi 高风plateau实测(p50=6369), 本场窗内不可独立验证
  n_turbines: 16
  farm: aodu
  site: 吉林 敖都 (大唐)
  commissioned: null
  windows:
    src_1min: 2025-10-16~2025-10-24 (9天, 12台×9日+4台×8日, 60s实测 per日)
  self_ref_risk: true
  curtailment_verdict_cap: INSUFFICIENT (无限电指令列, fault/scada状态=位掩码未解码)
  sister_farm: hailesi (内蒙海勒斯, 同型EN182-6250 64台, 2025-10-15~24; 本契约=其同型复用+aodu逐列实测)
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:
- ★aodu raw parquet 全68列 dtype=str (EnOS导出字符串化, 含数值列) → 清洗必 pd.to_numeric(errors=coerce); 不转则一切统计崩/静默错
- '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 降级表'
- aodu独有7列(conv_cool_in/out_temp, gen_in/out_air_temp, p_active_set, p_active_set_fbk, tower_base_out_temp)=全场死列; 与hailesi共病死列(theory_p_active/hyd_station_prs/main_brg_temp_2)=同平台同病
- actual_torque=发电机侧Nm (τ/(P/ω_rotor)中位0.005≈1/187=1/齿比 验算); gen/rotor齿比186.9 全场一致; set_torque 同义参考
turbine_sec:
  sampling_s: 60
  columns:
    localtime:
      role: timestamp
    turbine_hash:
      role: provenance
      observed_range:
      - 0
      - 15
      note: hadoop hash 假名原串 ×16 (同hailesi假名制); 实名映射待业主索资
    actual_torque:
      raw_unit: Nm (gen侧; 验算 35750Nm×175rad/s≈6.25MW)
      valid_range:
      - -2000
      - 45000
      observed_range:
      - 0.0
      - 34761.79
    ccw_yaw_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障) | aodu独有列, valid_range=实测宽放'
      observed_range:
      - 0.0
      - 1.0
      valid_range:
      - -1.0
      - 2.5
    conv_cool_in_temp:
      role: dead
      note: aodu全场死列(n=183260, const=0.0)
      observed_range:
      - 0.0
      - 0.0
      valid_range:
      - -1000000000.0
      - 1000000000.0
    conv_cool_out_temp:
      role: dead
      note: aodu全场死列(n=183260, const=0.0)
      observed_range:
      - 0.0
      - 0.0
      valid_range:
      - -1000000000.0
      - 1000000000.0
    cw_yaw_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障) | aodu独有列, valid_range=实测宽放'
      observed_range:
      - 0.0
      - 1.0
      valid_range:
      - -1.0
      - 2.5
    fault_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障) | aodu独有列, valid_range=实测宽放'
      observed_range:
      - 0.0
      - 4001155.0
      valid_range:
      - -1.0
      - 6001733.5
    gb_in_oil_prs:
      raw_unit: bar (p50=1.8; 负小值=零漂)
      valid_range:
      - -5
      - 25
      observed_range:
      - -4.0
      - 3.33
    gearbox_oil_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 63.45
    gen_de_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 83.68
    gen_in_air_temp:
      role: dead
      note: aodu全场死列(n=0, const=None)
      observed_range:
      - null
      - null
      valid_range:
      - -1000000000.0
      - 1000000000.0
    gen_nde_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 84.76
    gen_out_air_temp:
      role: dead
      note: aodu全场死列(n=183260, const=0.0)
      observed_range:
      - 0.0
      - 0.0
      valid_range:
      - -1000000000.0
      - 1000000000.0
    gen_spd:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 2500
      observed_range:
      - 0.1
      - 1828.77
    grid_freq:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 45
      - 55
      observed_range:
      - 49.93
      - 50.05
    grid_ia:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 8000
      observed_range:
      - 0.0
      - 3200.0
    grid_ib:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 8000
      observed_range:
      - 0.0
      - 3208.0
    grid_ic:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 8000
      observed_range:
      - 0.0
      - 3196.0
    grid_ua:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 1500
      observed_range:
      - 1061.9
      - 1160.6
    grid_ub:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 1500
      observed_range:
      - 1060.9
      - 1160.5
    grid_uc:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 1500
      observed_range:
      - 1059.4
      - 1160.6
    high_spd_shaft_de_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 69.68
    high_spd_shaft_nde_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 78.72
    hyd_station_prs:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 400
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化 | aodu全场死列(n=183260, const=0.0)
      dead_channel: true
      role: dead
      observed_range:
      - 0.0
      - 0.0
    main_brg_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      note: 唯一活主轴承温 (temp_2 全NaN/temp_3 全零) — 双通道互证不可行 (REFUTE案先验); 30MpvF6O=探头加性偏置案
      observed_range:
      - 0.0
      - 36.1
    main_brg_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化 | aodu全场死列(n=0, const=None)
      dead_channel: true
      role: dead
      observed_range:
      - null
      - null
    main_brg_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
      observed_range:
      - 0.0
      - 36.1
    mid_spd_shaft_de_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 63.64
    mid_spd_shaft_nde_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 65.22
    nacelle_cab_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 46.53
    nacelle_in_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -1.0
      - 25.01
    nacelle_out_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化
      dead_channel: true
      observed_range:
      - -3.59
      - 13.85
    nacelle_pos:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -1440
      - 1440
      note: 累计机舱位置(±662°观测, 含解缆圈数) — 非0-360方位; 方位角=yaw_ang
      observed_range:
      - -447.95
      - 561.25
    p_active:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -200
      - 6900
      observed_range:
      - -84.65
      - 6329.1
    p_active_set:
      role: dead
      note: aodu全场死列(n=183260, const=0.0)
      observed_range:
      - 0.0
      - 0.0
      valid_range:
      - -1000000000.0
      - 1000000000.0
    p_active_set_fbk:
      role: dead
      note: aodu全场死列(n=0, const=None)
      observed_range:
      - null
      - null
      valid_range:
      - -1000000000.0
      - 1000000000.0
    p_reactive:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -3500
      - 3500
      observed_range:
      - 0.0
      - 0.01
    pitch_ang_act_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 95
      note: 真三叶 IPC (全场60/60台发电中极差p95>1°, 中位2.86°) — P赛道数据源核
      observed_range:
      - -52.25
      - 92.0
    pitch_ang_act_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 95
      note: 真三叶 IPC (全场60/60台发电中极差p95>1°, 中位2.86°) — P赛道数据源核
      observed_range:
      - -265.6
      - 92.28
    pitch_ang_act_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 95
      note: 真三叶 IPC (全场60/60台发电中极差p95>1°, 中位2.86°) — P赛道数据源核
      observed_range:
      - -266.09
      - 97.8
    pitch_bat_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 17.0
    pitch_bat_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 17.34
    pitch_bat_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - 0.0
      - 17.11
    pitch_motor_cur_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 300
      observed_range:
      - 0.0
      - 37.1
    pitch_motor_cur_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 300
      observed_range:
      - 0.0
      - 36.55
    pitch_motor_cur_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -5
      - 300
      observed_range:
      - 0.0
      - 36.41
    pitch_motor_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -3.26
      - 49.44
    pitch_motor_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -1.0
      - 49.77
    pitch_motor_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      observed_range:
      - -3.0
      - 48.87
    rotor_spd:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 15
      observed_range:
      - 0.0
      - 9.75
    scada_wtg_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障) | aodu独有列, valid_range=实测宽放'
      observed_range:
      - 1.0
      - 8.0
      valid_range:
      - -0.5
      - 13.0
    set_torque:
      raw_unit: Nm (gen侧; 验算 35750Nm×175rad/s≈6.25MW)
      valid_range:
      - -2000
      - 45000
      observed_range:
      - 0.0
      - 34790.02
    stator_wind_temp_1:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 160
      observed_range:
      - 0.0
      - 95.74
    stator_wind_temp_2:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 160
      observed_range:
      - 0.0
      - 93.96
    stator_wind_temp_3:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 160
      observed_range:
      - 0.0
      - 95.74
    theory_p_active:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -1.0
      - 2.5
      note: 全场死列 (goem 实证), 清洗保留列位但值全NaN化 | aodu全场死列(n=0, const=None)
      dead_channel: true
      role: dead
      observed_range:
      - null
      - null
    tower_base_out_temp:
      role: dead
      note: aodu全场死列(n=183260, const=0.0)
      observed_range:
      - 0.0
      - 0.0
      valid_range:
      - -1000000000.0
      - 1000000000.0
    tower_base_temp:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -45
      - 130
      sentinel:
      - 847.5
      note: 847.5=哨兵/坏块(p99被其污染), range闸+sentinel双杀
      observed_range:
      - -2.88
      - 19.44
    tower_fb_vib:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -10
      - 10
      observed_range:
      - 0.0
      - 0.48
    tower_lr_vib:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -10
      - 10
      observed_range:
      - 0.0
      - 1.34
    twist_ang:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -1440
      - 1440
      observed_range:
      - -577.45
      - 423.98
    vendor_access_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障) | aodu独有列, valid_range=实测宽放'
      observed_range:
      - 1.0
      - 9.0
      valid_range:
      - -0.5
      - 14.5
    vendor_wtg_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障) | aodu独有列, valid_range=实测宽放'
      observed_range:
      - 1.0
      - 9.0
      valid_range:
      - -0.5
      - 14.5
    wind_dir:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -180
      - 360
      note: '混合编码观测[-180,360]: 清洗 wrap 到 [-180,180)'
      observed_range:
      - -179.99
      - 179.99
    wind_spd:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - 0
      - 60
      note: '机舱风速计 (转子后自指): 禁绝对功率曲线/Cp 定论 (self_ref)'
      observed_range:
      - 0.0
      - 11.09
    wtg_sts:
      role: status
      note: '位掩码/枚举 (无官方代码表; goem 交叉推断: vendor_wtg_sts 1=发电/9=低风待机/5,6=停机族; scada 0/2=运行发电,1=停机; fault_sts 位掩码 0=无故障) | aodu独有列, valid_range=实测宽放'
      dead_channel: true
      observed_range:
      - 1.0
      - 4.0
      valid_range:
      - -0.5
      - 7.0
    yaw_ang:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -756.28
      - 807.76
      observed_range:
      - -577.45
      - 424.16
    yaw_to_wind_ang:
      raw_unit: SI/工程单位(英文canonical列名)
      valid_range:
      - -180
      - 180
      note: native 带符号对风角 (发电中位0.2°, neg_frac .497) — panel 前提门 PASS
      observed_range:
      - -179.94
      - 179.84
  section_note: 1-min 原生高频层 (60s 实测); canonical section 集无 turbine_1min → 按"高频原生层"归 turbine_sec, sampling_s=60 载真值