Home Verkennen Help
Registreren Inloggen
zhouyang.xie
/
guanlan-src
1
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Boom: ff17c6d6ba
Aftakkingen Labels
guanlan-src
/
app_ETL
/
configs
/
contracts
/
sinovel_sl2000_huishan.yaml

sinovel_sl2000_huishan.yaml 8.8 KB
Geschiedenis Ruwe

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 
  1. # 数据契约 — 华电威海苘山风电场 (huishan; 苘山/文登黄岚, 华电山东) — 华锐 SINOVEL 2MW, 24台/48MW
    2. 

  2. # 🔴 命名: "wendeng"编码属大唐烟台文登一期(SL1500/77,33台,另场); 本场=华电苘山, 编码 huishan, 勿混。
    3. 

  3. schema_version: 2
    4. 

  4. meta:
    5. 

  5.   oem: 华锐 SINOVEL
    6. 

  6.   model: SL2000-class (2MW DFIG geared; 精确华锐型号待合同PDF Gemini视觉)
    7. 

  7.   rated_kw: 2000        # 合同48MW÷24台; 有功max2190/变流器690V级坐实
    8. 

  8.   n_turbines: 24
    9. 

  9.   farm: huishan
    10. 

  10.   site: 山东威海 苘山 (文登黄岚, 华电)
    11. 

  11.   commissioned: null
    12. 

  12.   windows: {scada: "2025-09-01~2025-11-30 (3月, 24台)"}
    13. 

  13.   self_ref_risk: true   # 10s平均风速=机舱风; 但目录3有测风塔9csv可作独立参照解self_ref
    14. 

  14.   data_note: "SCADA=目录1/原始9xlsx(3 disjoint schema×3文件, 流式zip须re-zip读 scripts/read_sinovel_streamzip.read_fast)按(机组名称,时间)outer合并=48列/313162行; 真采样率600s实测('10s平均风速'=值口径, 'SCADA_Second'文件名误导)"
    15. 

  15. 

  16. turbine_10min:
    17. 

  17.   sampling_s: 600
    18. 

  18.   columns:
    19. 

  19.     有功功率: {canonical_id: WTUR_active_power, unit: kW, valid_range: [-100, 2200], observed_range: [-1.5, 2190.4]}
    20. 

  20.     无功功率: {canonical_id: WTUR_reactive_power, unit: kVar, valid_range: [-700, 700], sentinel: [-273, -273.2, -99], observed_range: [-627.5, 597.4]}
    21. 

  21.     机组自身限功率运行状态: {canonical_id: WTUR_curtail_flag, unit: bool, valid_range: [0, 1], note: "限电0/1供剥离", observed_range: [0.0, 1.0]}
    22. 

  22.     故障停机时间: {canonical_id: WTUR_fault_downtime, unit: min, valid_range: [0, 1000], observed_range: [0.01, 993.73]}
    23. 

  23.     10s平均风速: {canonical_id: WMET_wind_speed_nac, unit: m/s, valid_range: [0, 40], note: "机舱风self_ref", observed_range: [0.0, 21.6]}
    24. 

  24.     瞬时风向: {canonical_id: WMET_wind_dir, unit: deg, valid_range: [0, 360], observed_range: [1.42, 357.04]}
    25. 

  25.     变流器内温度: {canonical_id: WCNV_internal_temp, unit: degC, valid_range: [0, 120], sentinel: [850], note: "★⑦变频器internal温度; [0,70]健康", observed_range: [0.0, 70.0]}
    26. 

  26.     变流器电压: {canonical_id: WCNV_voltage, unit: V, valid_range: [0, 800], note: "690V级", observed_range: [0.0, 739.4]}
    27. 

  27.     齿轮箱进口压力: {canonical_id: WTRM_gbx_inlet_pressure, unit: bar, valid_range: [0, 15], note: "★⑥冷臂dP低压侧", observed_range: [0.0, 7.21]}
    28. 

  28.     齿轮箱油泵出口压力: {canonical_id: WTRM_gbx_pump_outlet_pressure, unit: bar, valid_range: [0, 15], note: "★⑥冷臂dP高压侧; dP=出口−进口(义渡口A22 dP-stuck同款须重标阈)", observed_range: [0.0, 11.64]}
    29. 

  29.     齿轮箱进口油温: {canonical_id: WTRM_gbx_inlet_oil_temp, unit: degC, valid_range: [-30, 100], sentinel: [850], observed_range: [5.57, 70.5]}
    30. 

  30.     齿轮箱油池温度: {canonical_id: WTRM_gbx_oil_sump_temp, unit: degC, valid_range: [-30, 100], sentinel: [850], observed_range: [5.33, 77.16]}
    31. 

  31.     齿轮箱高速轴前端温度: {canonical_id: WTRM_gbx_hss_front_temp, unit: degC, valid_range: [-30, 130], sentinel: [850], observed_range: [6.17, 94.1]}
    32. 

  32.     齿轮箱高速轴后端温度: {canonical_id: WTRM_gbx_hss_rear_temp, unit: degC, valid_range: [-30, 130], sentinel: [850], observed_range: [5.98, 85.8]}
    33. 

  33.     发电机转速: {canonical_id: WGEN_speed, unit: rpm, valid_range: [0, 2000], observed_range: [0.0, 1861.0]}
    34. 

  34.     发电机前轴承温度: {canonical_id: WGEN_bearing_front_temp, unit: degC, valid_range: [-30, 130], sentinel: [850, -200], observed_range: [5.27, 75.64]}
    35. 

  35.     发电机后轴承温度: {canonical_id: WGEN_bearing_rear_temp, unit: degC, valid_range: [-30, 130], sentinel: [850], observed_range: [4.52, 74.36]}
    36. 

  36.     发电机绕组u1温度: {canonical_id: WGEN_winding_u1_temp, unit: degC, valid_range: [-30, 180], sentinel: [850], observed_range: [6.07, 97.56]}
    37. 

  37.     发电机绕组u2温度: {canonical_id: WGEN_winding_u2_temp, unit: degC, valid_range: [-30, 180], sentinel: [850], observed_range: [6.1, 100.12]}
    38. 

  38.     发电机绕组v1温度: {canonical_id: WGEN_winding_v1_temp, unit: degC, valid_range: [-30, 180], sentinel: [850], observed_range: [6.05, 125.65]}
    39. 

  39.     发电机绕组v2温度: {canonical_id: WGEN_winding_v2_temp, unit: degC, valid_range: [-30, 180], sentinel: [850], observed_range: [6.05, 98.6]}
    40. 

  40.     发电机绕组w1温度: {canonical_id: WGEN_winding_w1_temp, unit: degC, valid_range: [-30, 180], sentinel: [850], observed_range: [6.12, 99.7]}
    41. 

  41.     发电机绕组w2温度: {canonical_id: WGEN_winding_w2_temp, unit: degC, valid_range: [-30, 180], sentinel: [850], observed_range: [6.08, 164.79]}
    42. 

  42.     主轴前轴承温度: {canonical_id: WROT_main_bearing_front_temp, unit: degC, valid_range: [-30, 100], sentinel: [850], note: "[4,53]健康", observed_range: [3.99, 52.85]}
    43. 

  43.     主轴后轴承温度: {canonical_id: WROT_main_bearing_rear_temp, unit: degC, valid_range: [-30, 100], sentinel: [850], observed_range: [4.29, 54.62]}
    44. 

  44.     "1#叶片变桨角度": {canonical_id: WROT_pitch_1, unit: deg, valid_range: [-5, 95], note: "min-292=哨兵/wrap界外剔", observed_range: [-4.45, 90.03]}
    45. 

  45.     "2#叶片变桨角度": {canonical_id: WROT_pitch_2, unit: deg, valid_range: [-5, 95], observed_range: [-3.19, 89.34]}
    46. 

  46.     "3#叶片变桨角度": {canonical_id: WROT_pitch_3, unit: deg, valid_range: [-5, 95], observed_range: [-4.8, 93.7]}
    47. 

  47.     "1#叶片变桨速度": {canonical_id: WROT_pitch_rate_1, unit: deg/s, valid_range: [0, 15], observed_range: [0.0, 7.95]}
    48. 

  48.     "2#叶片变桨速度": {canonical_id: WROT_pitch_rate_2, unit: deg/s, valid_range: [0, 15], observed_range: [0.0, 7.93]}
    49. 

  49.     "3#叶片变桨速度": {canonical_id: WROT_pitch_rate_3, unit: deg/s, valid_range: [0, 15], observed_range: [0.0, 8.04]}
    50. 

  50.     "1#叶片电机温度": {canonical_id: WROT_pitch_motor_temp_1, unit: degC, valid_range: [-30, 150], sentinel: [850], observed_range: [0.0, 148.9]}
    51. 

  51.     "2#叶片电机温度": {canonical_id: WROT_pitch_motor_temp_2, unit: degC, valid_range: [-30, 150], sentinel: [850], observed_range: [0.0, 120.0]}
    52. 

  52.     "3#叶片电机温度": {canonical_id: WROT_pitch_motor_temp_3, unit: degC, valid_range: [-30, 150], sentinel: [850], observed_range: [0.0, 100.3]}
    53. 

  53.     "1#叶片驱动电流": {canonical_id: WROT_pitch_current_1, unit: A, valid_range: [0, 450], observed_range: [0.0, 400.0]}
    54. 

  54.     "2#叶片驱动电流": {canonical_id: WROT_pitch_current_2, unit: A, valid_range: [0, 450], observed_range: [0.0, 407.0]}
    55. 

  55.     "3#叶片驱动电流": {canonical_id: WROT_pitch_current_3, unit: A, valid_range: [0, 450], observed_range: [0.0, 402.0]}
    56. 

  56.     偏航速度: {canonical_id: WYAW_speed, unit: deg/s, valid_range: [-20, 100], observed_range: [-14.18, 94.88]}
    57. 

  57.     偏航压力: {canonical_id: WYAW_pressure, unit: bar, valid_range: [0, 200], observed_range: [0.0, 181.23]}
    58. 

  58.     解缆角度: {canonical_id: WYAW_cable_twist, unit: deg, valid_range: [0, 720], observed_range: [0.0, 596.59]}
    59. 

  59.     机舱X方向振动: {canonical_id: WNAC_vib_x, unit: g, valid_range: [-2, 2], note: "fore-aft塔振", observed_range: [-0.55, 0.16]}
    60. 

  60.     机舱Y方向振动: {canonical_id: WNAC_vib_y, unit: g, valid_range: [-2, 2], observed_range: [-0.55, 0.1]}
    61. 

  61.     机舱温度: {canonical_id: WNAC_temp, unit: degC, valid_range: [-30, 60], observed_range: [3.54, 40.45]}
    62. 

  62.     机舱控制柜温度: {canonical_id: WNAC_cabinet_temp, unit: degC, valid_range: [-30, 60], observed_range: [3.96, 47.21]}
    63. 

  63.     塔基控制柜温度: {canonical_id: WTOW_base_cabinet_temp, unit: degC, valid_range: [-30, 60], observed_range: [3.92, 45.6]}
    64. 

  64.     环境温度: {canonical_id: WMET_ambient_temp, unit: degC, valid_range: [-40, 55], note: "环温供温度NBM去季节+反环温判别", observed_range: [2.3, 34.55]}
    65. 

  65. 

  66. # 告警层 (目录7 24台历史事件-告警) 已抽 outputs/huishan/sop/alarm_events.parquet (12777条; 变流器类2197/齿箱过滤器压差高385=⑦⑥候选锚);
    67. 

  67. # 非turbine数据段, 不入契约严格校验 (告警级候选锚非gold, 用前过SOP line503检修日聚集/假触发核)。
    68. 

  68. 

  69. cleaning:
    70. 

  70.   physical: "valid_range 界外→NaN(非clamp, apply_contract_gate); 华锐哨兵850(温度过量程,发电机绕组/轴承/叶片电机撞850)+ -200/-273.2(欠量程绝对零度系)+ -99(marker)→NaN; 已清 outputs/huishan/cleaned/turbine.parquet(313162×48×24台+指纹)"
    71. 

  71.   semantic: "SCADA 3 disjoint schema须按(机组名称,时间)outer合并; 限功率状态0/1供限电剥离; 双压dP=油泵出口−进口(冷臂); 有测风塔可解self_ref(否则机舱风禁绝对Cp/达成率)"
    72. 

  72. 

  73. traps:
    74. 

  74.   - "流式zip xlsx: pandas read_excel/openpyxl报BadZipFile; 须系统unzip抽→re-zip→pandas(scripts/read_sinovel_streamzip.read_fast)"
    75. 

  75.   - "文件名日期20250901≠内容(实测2025-11); window从数据实测"
    76. 

  76.   - "'10s平均风速'列名+'SCADA_Second'文件名误导; 真采样率600s(time.diff.median实测)"
    77. 

  77.   - "9文件3 disjoint schema, 单文件只覆盖部分子系统; 须合并才有全48通道(有功功率在schema3, 变流器/双压在schema1, 发电机/振动/限电在schema2)"
    78. 

  78.   - "命名撞车: 'wendeng'=大唐文登一期(SL1500/77); 本场华电苘山=huishan"
    79.