Domovská stránka Prehľadávať Pomoc
Registrovať Prihlásiť sa
zhouyang.xie
/
guanlan-src
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 7e95e4c8e9
Branche Tagy
guanlan-src
/
app_ETL
/
configs
/
contracts
/
mingyang_my1_5_mima.yaml

mingyang_my1_5_mima.yaml 9.8 KB
História Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576 
  1. # 密马鬃梁 明阳双馈 1.5MW ×67 (山西浑源, 大唐) — WINDDATA 新生态批第2场 (飞尺角样板后)
    2. 

  2. # G-OEM 实证 2026-07-11 (survey.json note): 两宽层皆600s真采样(层名min=假名) / rated=1500(平台实测) /
    3. 

  3. #   哨兵族 -100精确+3276.7=int16溢出/10+±100倍坏块 / 状态码语义推断(无代码表) / 偏航列=0/1 flag
    4. 

  4. # 结构裁定: 两个导出(SCADA10分钟数据 61台×2023 / min语义层 32台×2022.10-2024.03) = 同一10min数据的互补列集
    5. 

  5. #   (21列同名同义同600s网格) → 单 turbine_10min section, 装配时按(风机,时间)外合并; 每列带 src 覆盖注
    6. 

  6. # 生态: 大唐+山西+明阳 = 对照华电山东系全新 (systemic 生态多样性用)
    7. 

  7. schema_version: 2
    8. 

  8. meta:
    9. 

  9.   oem: 明阳 MingYang (EnOS_Turbine_MYWind_Doubly_Fed)
    10. 

  10.   model: MY1.5 双馈 (型号未见铭牌文档, 从EnOS模型ID+额定实测定; 待补真型号)
    11. 

  11.   rated_kw: 1500
    12. 

  12.   n_turbines: 67        # 声称67(文件名/EnOS场站); 10min主层61(缺14,34-38); 语义层32(仅1-33缺14); 34-38五台无数据; 14号=专属EnOS zip
    13. 

  13.   farm: mima
    14. 

  14.   site: 山西浑源 密马鬃梁 (大唐)
    15. 

  15.   commissioned: null
    16. 

  16.   windows: {src_wide: "2023-01-01~2023-12-31 (61台, 9通道独有)", src_semantic: "2022-10~2024-03 (18月, 32台, 状态码/变桨/vane独有)", union: "2022-10~2024-03; 全61台仅2023, 34-67号无语义列", sec_enos: "2024Q1 (32台, 长表未契约化另存)"}
    17. 

  17.   self_ref_risk: true   # 风速=机舱风速计, 无测风塔 → 禁绝对Cp/达成率
    18. 

  18.   curtailment_verdict_cap: INSUFFICIENT  # 无有功功率限定值列 + 状态码无代码表 → 限电不可确诊(只能候选)
    19. 

  19. 

  20. turbine_10min:   # 装配层 = src_wide(scada/SCADA10分钟数据/*.csv) ⊕ src_semantic(scada/min/2023/*.csv) 按(风机,时间)外合并; GBK; dt=600s双层实证
    21. 

  21.   sampling_s: 600
    22. 

  22.   columns:
    23. 

  23.     时间: {role: timestamp}
    24. 

  24.     风机: {role: machine_id, valid_range: [1, 67], observed_range: [1, 67], note: "int台号; union实有61台"}
    25. 

  25.     # === 共有列 (双src, 重叠区2023×1-33 装配时核一致性) ===
    26. 

  26.     "平均发电机功率实时值(kW)": {raw_unit: kW, to_canonical: 1, valid_range: [-100, 1700], observed_range: [-100, 1565], sentinel: [-100], trap: "-100精确哨兵(非真负载); rated=1500实测"}
    27. 

  27.     平均发电机转速实时值: {raw_unit: rpm, to_canonical: 1, valid_range: [0, 2000], observed_range: [-100, 1870], sentinel: [-100], note: "DFIG 1.5MW ~1800rpm级"}
    28. 

  28.     "平均风速实时值(m/s)": {raw_unit: mps, to_canonical: 1, valid_range: [0, 45], observed_range: [0, 30.3], trap: "机舱风速计 self_ref"}
    29. 

  29.     平均机舱方向绝对角度: {raw_unit: deg, to_canonical: 1, valid_range: [0, 360], observed_range: [0, 360], trap: "环量: 0/360跨越均值无效, circular法; frame(地理绝对?)未验, vane联合验遗留"}
    30. 

  30.     平均主轴转速: {raw_unit: rpm, to_canonical: 1, valid_range: [0, 25], observed_range: [0, 10537], trap: "语义src见10537坏块 → range闸杀; 物理≤19"}
    31. 

  31.     平均机舱外温度: {raw_unit: C, to_canonical: 1, valid_range: [-45, 55], observed_range: [-2953, 848], trap: "±100倍坏块双向; 山西高原冬-38.9真值保留"}
    32. 

  32.     平均机舱温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 60], observed_range: [-31, 1108], trap: "1108坏块; -1精确疑哨兵但冬-1真值可能→保守不设哨兵, 残差用稳健统计"}
    33. 

  33.     平均机舱电柜温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 90], observed_range: [0, 203], trap: "203坏块"}
    34. 

  34.     平均塔基电柜温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 90], observed_range: [-1236, 477], trap: "±100倍坏块"}
    35. 

  35.     平均转子轴承a温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 120], observed_range: [-1475, 51.3], trap: "±100倍坏块", note: "主轴承前位(明阳'转子轴承'=主轴系)"}
    36. 

  36.     平均转子轴承b温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 120], observed_range: [-1844, 99.8], trap: "±100倍坏块", note: "主轴承后位"}
    37. 

  37.     平均齿轮油温: {raw_unit: C, to_canonical: 1, valid_range: [-40, 100], observed_range: [-164.5, 535], trap: "双向坏块"}
    38. 

  38.     平均齿轮箱de端轴承温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 120], observed_range: [-103, 500], trap: "500坏块"}
    39. 

  39.     平均齿轮箱nde端轴承温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 120], observed_range: [-2951, 563], trap: "±100倍坏块"}
    40. 

  40.     平均发电机de端轴承温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 150], observed_range: [-2213, 83.6], trap: "±100倍坏块"}
    41. 

  41.     平均发电机nde端轴承温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 150], observed_range: [-27, 85]}
    42. 

  42.     平均发电机定子绕组u温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 180], observed_range: [-2951, 381], trap: "±100倍坏块", note: "F级155阈"}
    43. 

  43.     平均发电机定子绕组v温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 180], observed_range: [-23, 138.1]}
    44. 

  44.     平均发电机定子绕组w温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 180], observed_range: [-1475, 137], trap: "±100倍坏块"}
    45. 

  45.     # === src_wide 独有 (61台×2023) ===
    46. 

  46.     最大偏航逆时针: {raw_unit: flag, to_canonical: 1, valid_range: [0, 1], observed_range: [0, 1], trap: "0/1活动flag非计数; 偏航频次=求和只得下界", note: "src:wide-only"}
    47. 

  47.     最大偏航顺时针: {raw_unit: flag, to_canonical: 1, valid_range: [0, 1], observed_range: [0, 1], trap: "同上", note: "src:wide-only"}
    48. 

  48.     "最大风速实时值(m/s)": {raw_unit: mps, to_canonical: 1, valid_range: [0, 60], observed_range: [0, 40.4], note: "src:wide-only"}
    49. 

  49.     平均电缆扭转总角度: {raw_unit: deg, to_canonical: 1, valid_range: [-1500, 1500], observed_range: [-1056, 900], note: "src:wide-only; 解缆/扭缆代理"}
    50. 

  50.     最大y轴振动实时值: {raw_unit: g_or_ms2, to_canonical: 1, valid_range: [-5, 5], observed_range: [-0.4, 1.9], trap: "单位未标定(g或m/s²); 只台内相对/趋势", note: "src:wide-only"}
    51. 

  51.     最大z轴振动实时值: {raw_unit: g_or_ms2, to_canonical: 1, valid_range: [-5, 5], observed_range: [-0.4, 4.1], trap: "同上", note: "src:wide-only"}
    52. 

  52.     平均发电机冷风温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 130], observed_range: [-27.9, 115.8], note: "src:wide-only"}
    53. 

  53.     平均轮毂温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 90], observed_range: [-26.8, 3276.7], trap: "3276.7=int16溢出/10哨兵", note: "src:wide-only"}
    54. 

  54.     平均塔基温度: {raw_unit: C, to_canonical: 1, valid_range: [-40, 60], observed_range: [-27.4, 945], trap: "945坏块", note: "src:wide-only"}
    55. 

  55.     # === src_semantic 独有 (32台×2022.10-2024.03) ===
    56. 

  56.     平均机组运行模式: {role: state_enum, raw_unit: code, to_canonical: 1, valid_range: [0, 30], observed_range: [2, 20], trap: "语义推断(无代码表): 3=正常运行主导, 9=次; 分数=窗内换态, 稳态判据=整数", note: "src:semantic-only"}
    57. 

  57.     平均机组刹车程序: {role: state_enum, raw_unit: code, to_canonical: 1, valid_range: [0, 300], observed_range: [0, 200], trap: "代码语义未知, 只作事件flag", note: "src:semantic-only"}
    58. 

  58.     平均变桨角度: {raw_unit: deg, to_canonical: 1, valid_range: [-10, 95], observed_range: [-21.2, 94.5], trap: "集距(单值非三叶); -21.2低于物理→range闸杀; 全场唯一桨距列(32台)", note: "src:semantic-only"}
    59. 

  59.     平均机舱方向总角度: {raw_unit: deg, to_canonical: 1, valid_range: [-30000, 30000], observed_range: [-695, 26370], note: "src:semantic-only; 累计角(解缆代理)"}
    60. 

  60.     平均风向1秒平均值: {raw_unit: deg, to_canonical: 1, valid_range: [-180, 180], observed_range: [-176, 176], trap: "vane相对风向(±180制)→对风角候选; frame/符号约定未验(与机舱绝对角联合验遗留)", note: "src:semantic-only"}
    61. 

  61.     平均机组运行状态码: {role: state_enum, raw_unit: code, to_canonical: 1, valid_range: [0, 30], observed_range: [1, 25], trap: "语义推断(无代码表): 20=发电(99.3%正功率), 6=低风待机(w̄2.3), 2-5=有风停机族(限电/故障/检修不可分→限电INSUFFICIENT), 7-19=启动过渡; 仅整数=稳态窗可判", note: "src:semantic-only"}
    62. 

  62.     平均首触故障地址码: {role: state_enum, raw_unit: code, to_canonical: 1, valid_range: [0, 99999], observed_range: [0, 1026], trap: "地址码非码本体, 无手册→只作故障flag(>0)", note: "src:semantic-only"}
    63. 

  63.     "平均功率因数设定值(kW)": {raw_unit: dimensionless, to_canonical: 1, valid_range: [0, 1.2], observed_range: [1, 1], trap: "表头单位(kW)错标, 实为功率因数(恒1)", note: "src:semantic-only"}
    64. 

  64.     平均发电机转速设定值: {raw_unit: rpm, to_canonical: 1, valid_range: [0, 2000], observed_range: [300, 1550], note: "src:semantic-only; 转速setpoint — 控制律分析可用"}
    65. 

  65. 

  66. cleaning:
    67. 

  67.   physical: "valid_range clip→NaN (apply_contract_gate); -100哨兵(功率/转速)→NaN; int16溢出3276.7/±100倍坏块由range闸杀"
    68. 

  68.   semantic: "状态码/模式=平均分类值→稳态判据仅整数窗; 环量列circular法; 偏航flag求和=频次下界; 装配=两src按(风机,时间)外合并, 共有列重叠区(2023×1-33)核一致性后取wide为主"
    69. 

  69. traps:
    70. 

  70.   - "层名骗局: 'min/分钟数据'目录实测600s=10分钟 (G-OEM per台median实证; 勿按名当1分钟层)"
    71. 

  71.   - "台覆盖三张皮: 声称67 / wide src 61(缺14,34-38) / semantic src 32(仅1-33缺14) / 34-38五台无数据; 14号=专属EnOS zip"
    72. 

  72.   - "限电不可确诊: 无有功功率限定值 + 状态码无代码表(2-5停机族限电/故障不可分) → 限电结论上限INSUFFICIENT"
    73. 

  73.   - "窗错位: wide=2023全年 / 秒级EnOS=2024Q1 零重叠; 语义src 2024Q1可与秒级交叉验"
    74. 

  74.   - "偏航列=0/1活动flag非计数 → 偏航次数只能得下界"
    75. 

  75.   - "无测风塔+机舱风self_ref → 禁绝对Cp/达成率; 相对机群筛可用"
    76. 

  76.   - "缺少数据0513.txt自报缺项与实测不符: 桨距/vane语义src 32台实有 → 信数据不信自报清单(双向核)"
    77.