Overview
The Core OEM SQL Data is a Certified Product Point Template for Wind Turbines defines optional telemetry Bazefield recommends for advanced analysis of 10-minute data sets often provided by Wind Turbine OEM SCADA systems. These points are not required for monitoring but can be helpful for more accurate month-end reporting, and situations where data coverage and quality is critical to the end-user. It is meant to compliment much of the OPC data found in the Core Real-Time Data template.
Template Definition
The Core OEM SQL template specifically holds all the critical “raw” pre-aggregated 10-minute data expected from most Wind Turbine SCADA systems. Specifically, it is common for many vendors of wind turbines to host an on-site SQL database with localized schema for the below points. Bazefield supports interfaces to all major OEM SQL databases to map OEM definitions and namespaces of the below points to the normalized point names provided in the table.
Minimum Requirements
In most modern wind turbines, there will be a significant number points available beyond this list which are vendor or SCADA specific. This list represents the minimum, common list of critical data often available in ALL vendors and SCADA systems.
Details on the Point Names, Descriptions, and Types are below.
Required for Bazefield Core Dashboard functionality
Optional for common additional data streams/sources
Name | Description | Type | Unit | |
|---|---|---|---|---|
ActivePower.10m | Active power of wind turbine, from ODBC SQL Historian | SCADA (SQL) | kW | |
AmbientTemperature.10m | Ambient temperature, from ODBC SQL Historian | SCADA (SQL) | o | |
Blade_PitchAngle.10m | Avg pitch angle of all three blades from ODBC SQL Historian | SCADA (SQL) | o | |
Blade1_PitchAngle.10m | Pitch angle of first blade from ODBC SQL Historian | SCADA (SQL) | o | |
Blade2_PitchAngle.10m | Pitch angle of second blade from ODBC SQL Historian | SCADA (SQL) | o | |
Blade3_PitchAngle.10m | Pitch angle of third blade from ODBC SQL Historian | SCADA (SQL) | o | |
Current.10m | Voltage, from ODBC SQL Historian | SCADA (SQL) | A | |
CurrentA.10m | Current in phase A, from ODBC SQL Historian | SCADA (SQL) | A | |
CurrentB.10m | Current in phase B, from ODBC SQL Historian | SCADA (SQL) | A | |
CurrentC.10m | Current in phase C, from ODBC SQL Historian | SCADA (SQL) | A | |
ErrorCode.10m | Error code (single tag) for OEM vendor at end of interval, from ODBC SQL Historian | SCADA (SQL) | -- | |
Frequency.10m | Grid frequency in Hz, from ODBC SQL Historian | SCADA (SQL) | Hz | |
GeneratorSpeed.10m | Generator speed in RPM, typically from the OPC interface | SCADA (SQL) | RPM | |
NacelleDirection.10m | Nacelle direction, from ODBC SQL Historian | SCADA (SQL) | o | |
OperationState.10m | Native operating state for the WTG, from ODBC SQL Historian | SCADA (SQL) | -- | |
PowerFactor.10m | Power factor, typically from ODBC SQL Historian | SCADA (SQL) | % | |
ReactivePower.10m | Reactive power of wind turbine, from ODBC SQL Historian | SCADA (SQL) | kVar | |
RotorSpeed.10m | Rotor speed in RPM, typically from the OPC interface | SCADA (SQL) | RPM | |
TotalEnergyConsumed.10m | Lifetime energy consumed counter at end of interval, from ODBC SQL Historian | SCADA (SQL) | kWh | |
TotalEnergyProduced.10m | Lifetime energy produced counter at end of interval, from ODBC SQL Historian | SCADA (SQL) | kWh | |
Voltage.10m | Current, from ODBC SQL Historian | SCADA (SQL) | V | |
VoltageA.10m | Voltage in phase A, from ODBC SQL Historian | SCADA (SQL) | V | |
VoltageB.10m | Voltage in phase B, from ODBC SQL Historian | SCADA (SQL) | V | |
VoltageC.10m | Voltage in phase C, from ODBC SQL Historian | SCADA (SQL) | V | |
WindDirection.10m | Absolute wind direction from wind vane measurement, from ODBC SQL Historian | SCADA (SQL) | o | |
WindSpeed.10m | Nacelle wind speed of wind turbine (primary anemombeter), from ODBC SQL Historian | SCADA (SQL) | m/s |