search

sintel-dev / Zephyr

https://dtail.gitbook.io/zephyr/
MIT License
9 stars 2 forks source link

Create vibrations entityset #16

Open sarahmish opened 1 year ago

sarahmish commented 1 year ago

In addition to create_entityset_scada and create_entityset_pidata, we want to add create_entityset_vibrations.

Entities to include:

Necessary columns in vibrations

Metadata of vibrations

'vibrations': {
    'index': '_index',
    'make_index': True,
    'time_index': 'timestamp',
    'logical_types': {
        'COD_ELEMENT': 'categorical',
        'turbine_id': 'categorical',
        'signal_id': 'categorical',
        'timestamp': 'datetime',
        'sensorName': 'categorical',
        'sensorType': 'categorical',
        'sensorSerial': 'integer_nullable',
        'siteName': 'categorical',
        'turbineName': 'categorical',
        'turbineSerial': 'integer_nullable',
        'configurationName': 'natural_language',
        'softwareVersion': 'categorical',
        'rpm': 'double',
        'rpmStatus': 'natural_language',
        'duration': 'natural_language',
        'condition': 'categorical',
        'maskTime': 'datetime',
        'Mask Status': 'natural_language',
        'System Serial': 'categorical',
        'WPS-ActivePower-Average': 'double',
        'WPS-ActivePower-Minimum': 'double',
        'WPS-ActivePower-Maximum': 'double',
        'WPS-ActivePower-Deviation': 'double',
        'WPS-ActivePower-StartTime': 'datetime',
        'WPS-ActivePower-StopTime': 'datetime',
        'WPS-ActivePower-Counts': 'natural_language',
        'Measured RPM': 'double',
        'WPS-ActivePower': 'double',
        'WPS-Gearoiltemperature': 'double',
        'WPS-GeneratorRPM': 'double',
        'WPS-PitchReference': 'double',
        'WPS-RotorRPM': 'double',
        'WPS-Windspeed': 'double',
        'WPS-YawAngle': 'double',
        'overload warning': 'categorical',
        'bias warning': 'categorical',
        'bias voltage': 'double',
        'xValueOffset': 'double',
        'xValueDelta': 'double',
        'xValueUnit': 'categorical',
        'yValueUnit': 'categorical',
        'TotalCount-RPM0': 'double',
        'TotalCount-RPM1': 'double',
        'TotalCount-RPM2': 'double',
        'TotalCount-RPM3': 'double'
    }
}