Schema Overview
Assumptions
- Data provider: PQVIEW, Data analyzer: ASPIRES
- We receive the instantaneous voltage and current measurements (however, other profiles, such as rms series, can easily be added using the Time-series class)
- Only one analysis table is defined: if multiple analysis is provided by different analyzers, the analysis results should be combined into one analysis table before being inserted to MongoDB
- Event
| Label | Source | Property | Sub-property of | Range | Usage | Vocab Schema | Syntax Schema | Obligation | Example 1: Fault | Example 2: Capacitor | Example 3 | Example 4 | Note | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Event_ID | ASPIRES | .eventID | Unique identifier (ID) of the event file | 1 | 1 | 2 | 4 | ||||||||||||||||||||||
| PQ monitor location | Data provider | .pqMonitorLocationCategory | Name of the utility substation | Substation, feeder, service entrance, equipment (cap., xfmr), load | 0-1 | Service entrance | Service Entrance DataNode 5571 | Service entrance |
| ||||||||||||||||||||
| PQ monitor model | Data provider | .pqMonitorModel | Name Model of the feeder, where the PQ monitor is located | 0-1 | Service Entrance I-Sense® | Schneider Electric Circuit Monitor 4000T (Square D) | |||||||||||||||||||||||
| Nominal voltage | Data provider or ASPIRES | .nominalVoltage | Nominal voltage of the system in kV kV | 0-1 | 120 | ||||||||||||||||||||||||
| Nominal frequency | Data provider or ASPIRES | .nominalFrequency | Nominal frequency of the system in Hertz | 50, 60 | 0-1 | 60 | |||||||||||||||||||||||
| Start time | Data provider or ASPIRES | .startTime | The start time of the event file in the EDTF v1.0 ISO 8601 format | EDTF v1.0 (datetime object in python))ISO 8601
| 0-1 | 2003-02-02T 19:57:45.5000 datetime.datetime(2003, 2, 14, 20, 41, 58, 376000) :57:45.5000
| 2003-02-01T 03:54:06.4671 | 2003-02-26T15:54:17 |
| ||||||||||||||||||||
| data date time offset (start time) | ASPIRES | .timeOffset | Time difference between the start time and a time value in a datasheet | 0-1 | 0 | 0 | |||||||||||||||||||||||
| Time zone | Data provider | .timeZone | Time zone: PT, MT, CT, ET | 0-1 | Duration (move to Voltage and Current) | Data provider or ASPIRES | The time duration of the event file (sec)CT, ET | 0-1 | 0.749895833 | 0.0498697916666667 | 1 | EventTrend(numberSamples) * EventTrend(samplePeriod) | |||||||||||||||||
| Root cause | Data provider | .rootCause | Electrical incident triggering the event : short-circuit fault, energizing (capacitor, line, transformer), load change, generation | 0-1 | |||||||||||||||||||||||||
| Inferred root cause | ASPIRES | .inferredRootCause | The root cause inferred using other properties. | short-circuit fault, capacitor switching, ... | 0-1 | Short-circuit fault | Capacitor Switching | Capacitor Switching | |||||||||||||||||||||
| Degree of certainty | Data providerASPIRES | .certainty | Degree of certainty the recorded event was caused by the root cause | High, medium, low | 0-1 | ||||||||||||||||||||||||
| Data provider (entity) | ASPIRES | .dataProvider | Name of the entity or organization providing the data to ASPIRES (may not be the data creating recording entity) | 0-1 | Electrotek | Electrotek | Electrotek | ||||||||||||||||||||||
| Data source | ASPIRES or Data provider | .dataSource | Name of the entity or organization that created recorded the data (for example, a utility company). Could be the same as the data provider. | 0-1 | |||||||||||||||||||||||||
| Received Data Base Receiving database name and version | ASPIRES or Data provider | .receivedDatabase | Data Base name and version | 0-1 | Normal - PQView 3.46.0 Database - Version 3.03.04.00 | ||||||||||||||||||||||||
| Providing agent (individual or official providing the data) | Data provider | .providingAgent | Name of the individual providing the data | 0-1 | |||||||||||||||||||||||||
| Detail | Data provider | .detail | Additional details if available | 0-1 | Data (raw) | ||||||||||||||||||||||||
| Containing dataset | Data provider | .rawData | Raw data file (as received, should consider a unique file name ex) using event_ID) | PQ event file or the database file which containts the PQ event, as received | 0-1 | PQViewAccess DB (Not attached (100Mb)) | PQViewAccess DB (Not attached (100Mb)) | ||||||||||||||||||||||
| Voltage | Data provider | Time-series | Voltage data | 1 | |||||||||||||||||||||||||
| Current | Data provider | Time-series | Current data | 1 | |||||||||||||||||||||||||
| Description | Data provider | Description table | Additional description about the event | 0-1 | |||||||||||||||||||||||||
| Software analysis | Data provider or ASPIRES | Software analysis table | Software analysis performed on the event | 0-1 | |||||||||||||||||||||||||
| IEEE disturbance classification | ASPIRES or Data Provider | IEEE Disturbance table | Category of this event according to the IEEE standard 1159-2009 | 0-n |
- TIme-series (either voltage or current): example shown in voltage
| Label | Source | Property | Sub-property of | Range | Usage | Vocab Schema | Syntax Schema | Obligation | Example: Fault | Example: Capacitor | Example 3 | Example 4 | Note | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Data headers | Data Provider or ASPIRES | .headers | array (list in python) | Voltage headers: Va, Vb, Vc, Vn, Vab, Vbc, Vca, Ia, Ib, Ic, In | 1-n | [Vab, Vbc, Vca] | [Va, Vb, Vc] | [Va, Vb, Vc] | |||||||||||||||||||||||
| Time series data | Data Provider | .timeSeries | array of arrays | Voltage data: Va(n), Vb(n), Vc(n), Vn(n), Vr(n), Vab(n), Vbc(n), Vca(n) | 1-n |
|
|
|
| ||||||||||||||||||||||
| Count of data samples | Data Provider or ASPIRES | .count | array | Number of data samples | 1 | 7200 | 384 | 7680 | Note: the sampling rate for the voltages are highly likely to be all the same. In this case, just link to one field.Assumes that all phases have the same number of data points | ||||||||||||||||||||||
| Sampling rate | Data Provider or ASPIRES | .samplingRate | array | Number of data samples per one-cycle | 1 | 160 | 128 | 128 | Assumes that all phases have the same sampling rate |
- Description (currently optimized for faults–revisit as we think about other root causes)
| Label | Source | Property | Sub-property of | Range | Usage | Vocab Schema | Syntax Schema | Obligation | Example: Fault | Example: Capacitor | Example 3 | Example 4 | Note | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Weather | Data Provider | .weather | Textual description of weather array | Weather at the time when the data was recorded | Unknown, wind, lightning, heat, ice/snow, rain, clear day, tornado/hurricane ## vocabularies used in PQ View Access database | 0-n1 | Wind | Clear Day | ||||||
| Isolation equipment | Data Provider | .isolationEquipment | Type of the protection equipment that cleared the disturbance profile event recorded in the event file | Unknown, breaker, recloser, fuse, sectionalizer, switch, elbow, network protectors ## vocabularies used in PQ View Access database | 0-1 | Fuse | Switch | |||||||
| Internal agent | Data Provider | .internalAgent | Description of the equipment within the power system which (caused / resulted from the root cause)Equipment which failed | Cable, joint, transformer, conductor, splice, lightning arrester, switches, cross arm, pole, insulator, connector, other, unknown ## vocabularies used in PQ View Access database database | 0-1 | Lightning arrester | Cable | |||||||
| External agent | Data Provider | .externalAgent | Factors from outside the power system which resulted in the root cause: | Animals, lightning, wind, major event, scheduled, trees, overload, error, supply, equipment, other, unknown, earthquake ## vocabularies used in PQ View Access database database | 0-1 | Tree | Overload | Scheduled | ||||||
| Detail | Data Provider | .detail | Additional details if available | Text | 0-1 |
- Software analysis
| Label | Source | Property | Sub-property of | Range | Usage | Vocab Schema | Syntax Schema | Obligation | Example: Fault | Example: Capacitor | Example 3 | Example 4 | Note |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Analysis provider | Data Provider or ASPIRES | Name of the entity/organization performing the short-circuit fault analysis | 1 | Electrotek | Electrotek | ||||||||
| Maximum rms current | Data Provider or ASPIRES | - (array) | Maximum rms current among the three phases in amps | 0-n(0-1) | 3472.049 A | ||||||||
Peak instantaneous voltage (pu) | Data Provider or ASPIRES |
| Peak voltage magnitude among the three phases in per unit | 0-1 | 1.3193 (used absolute value) | ||||||||
Peak instantaneous current (pu) | Data Provider or ASPIRES |
| Peak current magnitude among the three phases in per unit | 0-1 | |||||||||
RMS voltage variation | Data Provider or ASPIRES |
| Voltage variation after the event | 0-1 | |||||||||
| Relative location | Data Provider or ASPIRES | Relative fault location with respect to monitor: upstream, downstream | 0-1 | ||||||||||
| Fault location (simple reactance) | Data Provider or ASPIRES | .faultLocationSimpleReactance | Estimated fault location using simple reactance method | 0-1 | |||||||||
| Fault location (Takagi) | Data Provider or ASPIRES | .faultLocationTakagi | Estimated fault location using Takagi method | 0-1 | |||||||||
| Fault clearing device | Data Provider or ASPIRES | .estimatedFaultClearingDevice | Estimated fault clearing device | 0-1 | |||||||||
Duration (cycles) | Data Provider or ASPIRES |
| Duration of the disturbance (fault) | 0-1 | 0.36 | ||||||||
Duration (cycles) | Data Provider or ASPIRES |
| Duration of the disturbance (capacitor) | 0-1 | 3.125 | ||||||||
Switching angle (º) | Data Provider or ASPIRES |
| Switching angle at the incidence of the event | 0-1 | |||||||||
Frequency (Hz) | Data Provider or ASPIRES |
| Resonant frequency | 0-1 | 1395 | ||||||||
Q variation (kvar) | Data Provider or ASPIRES | Reactive power variation after the event | 0-1 | ||||||||||
Power factor variation | Data Provider or ASPIRES |
| Power factor variation after the event | 0-1 | |||||||||
THDv (%) | Data Provider or ASPIRES | .totalHarmonicDistortion | Total harmonic disturbance in % | 0-1 | |||||||||
| Fault type | Data Provider or ASPIRES | .faultType | Phase(s) involved in the short-circuit fault: AG, BG, CG, AB(G), BC(G), CA(G), ABC(G) | 0-1 | CA(G) | ||||||||
| Fault duration | Data Provider or ASPIRES | Duration of the short-circuit fault in sec | 0-1 | 0.36 | |||||||||
| Transient rise time | Data Provider or ASPIRES | .riseTime | Transient rise time (in ns) (rise time: the time required for a pulse to rise to its peak value) http://grouper.ieee.org/groups/td/pq/documents/2010-01%20Power%20Quality%20Definitions%20Draft.pdf | 0-1 | |||||||||
| Voltage imbalance | Data Provider or ASPIRES | Ratio of the magnitude of the negative sequence component to the magnitude of the positive sequence component (in %) : % Imbalance = |Vneg|/|Vpos|*100 | 0-1 | ||||||||||
| Current imbalance | Data Provider or ASPIRES | Ratio of the magnitude of the negative sequence component to the magnitude of the positive sequence component (in %) : % Imbalance = |Vneg|/|Vpos|*100 | 0-1 | ||||||||||
| DC offset | Data Provider or ASPIRES | .dcOffset | Magnitude (in %) Ratio of the magnitude of the DC component to the magnitude of the fundamental component (in %)  not described in IEEE Standard 1159... | 0-1 | |||||||||
| Interharmonic | Data Provider or ASPIRES | .interHarmonic | magnitude (in %) : Ratio of the magnitude of the Interharmonic component to the magnitude of the fundamental component (in %) not described in IEEE Standard 1159... | 0-1 | |||||||||
| Noise | Data Provider or ASPIRES | Signal-to-Noise ratio of the voltage or current (in %) Method not recommendted to extract noise from the signal in IEEE Standard 1159... | 0-1 | ||||||||||
| Voltage fluctuations frequency | Data Provider or ASPIRES | Voltage fluctuations spectral content (in Hz) | 0-1 | ||||||||||
| Voltage fluctuations magnitude (%) | Data Provider or ASPIRES | Ratio of the magnitude of the modulation signal to the magnitude of the fundamental component (in %) not described in IEEE Standard 1159...
: Magnitude for the voltage fluctuation can be defined as the rms magnitude of the modulation signal. This can be obtained by demodulating the waveform to remove the fundamental frequency and then measuring the magnitude of the modulation components. | 0-1 | ||||||||||
| Voltage fluctuations magnitude (Pst index) | Data Provider or ASPIRES | Flicker severity index Pst as defined in IEC 61000-4-15:2003 [B15] and IEEE Std 1453TM-2004 [B28]. | 0-1 | ||||||||||
| Power frequency variation duration | Data Provider or ASPIRES | Duration of the power frequency variation (in sec) | 0-1 | ||||||||||
| Power frequency variation magnitude | Data Provider or ASPIRES | Deviation of the power system fundamental frequency from its specified nominal value (e.g., 60Hz) (in Hz) | 0-1 |
...
| Label | Source | Property | Sub-property of | Range | Usage | Vocab Schema | Syntax Schema | Obligation | Example: Fault | Example: Capacitor | Example 3 | Example 4 | Note |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category label | Data Provider or ASPIRES | .categoryID | Disturbance category label according to IEEE standard 1159-2009 Table 2009 Table 2 | 1 | Short duration RMS variations-Instantaneous-Sag | Transient-Oscillatory-Low frequency | |||||||
| Category id | Data Provider or ASPIRES | .categoryLabel | Disturbance category number or identifier according to IEEE standard 1159-2009 Table 2 | 1159-2009, table 2 | 1 | 2.1.1 | 1.2.1 | ||||||
| ROWS BELOW THIS ARE NOT CURRENTLY USED. | THE FIELDS BELOW REPEAT DATA FROM THE SOFTWARE ANALYSIS TABLE. HUMANS OR PROGRAMS SHOULD RETRIEVE RELEVANT FIELDS FROM THAT TABLE. | ||||||||||||
| Analysis Provider | Data Provider or ASPIRES | Name of the entity/organization performing the IEEE disturbance analysis | 1 | Electrotek | Electrotek | ||||||||
| Impulsive transient rise time | Data Provider or ASPIRES | Transient rise time (in ns) (rise time: the time required for a pulse to rise to its peak value) http://grouper.ieee.org/groups/td/pq/documents/2010-01%20Power%20Quality%20Definitions%20Draft.pdf | 0-1 | ||||||||||
| Impulsive transient duration | Data Provider or ASPIRES | Impulsive transient duration (in ns) | 0-1 | ||||||||||
| Frequency | Data Provider or ASPIRES | Frequency (in kHz) | 0-1 | 1.395 | |||||||||
| Oscillatory transient duration | Data Provider or ASPIRES | Duration of the oscillatory transient (in us) | 0-1 | 0.0521 us (3.125 cycles) | |||||||||
| Oscillatory transient peak voltage magnitude | Data Provider or ASPIRES | Voltage magnitude of the oscillatory transient (in per unit) | 0-1 | 1.3193 (used absolute value) | |||||||||
| RMS voltage variation magnitude | Data Provider or ASPIRES | RMS voltage variation magnitude (in per unit) | 0-1 | 0.6813 pu | |||||||||
| RMS voltage variation duration | Data Provider or ASPIRES | RMS voltage variation duration (in cycles) | 0-1 | 21. 6 cycles (0.36 sec) | |||||||||
| Current overload duration | Data Provider or ASPIRES | Duration of undervoltage caused by overload (in min) | 0-1 | ||||||||||
| Voltage imbalance | Data Provider or ASPIRES | Ratio of the magnitude of the negative sequence component to the magnitude of the positive sequence component (in %) : % Imbalance = |Vneg|/|Vpos|*100 | 0-1 | ||||||||||
| Current imbalance | Data Provider or ASPIRES | Ratio of the magnitude of the negative sequence component to the magnitude of the positive sequence component (in %) : % Imbalance = |Vneg|/|Vpos|*100 | 0-1 | ||||||||||
| Disturbance profile: DC offset | Data Provider or ASPIRES | Magnitude (in %) Ratio of the magnitude of the DC component to the magnitude of the fundamental component (in %) not described in IEEE Standard 1159... | 0-1 | ||||||||||
| THD | Data Provider or ASPIRES | Total harmonic distortion (in %) | 0-1 | ||||||||||
| Interharmonic | Data Provider or ASPIRES | magnitude (in %) : Ratio of the magnitude of the Interharmonic component to the magnitude of the fundamental component (in %) not described in IEEE Standard 1159... | 0-1 | ||||||||||
| Noise | Data Provider or ASPIRES | Signal-to-Noise ratio of the voltage or current (in %) Method not recommendted to extract noise from the signal in IEEE Standard 1159... | 0-1 | ||||||||||
| Voltage fluctuations frequency | Data Provider or ASPIRES | Voltage fluctuations spectral content (in Hz) | 0-1 | ||||||||||
| Voltage fluctuations magnitude (%) | Data Provider or ASPIRES | Ratio of the magnitude of the modulation signal to the magnitude of the fundamental component (in %) not described in IEEE Standard 1159...
: Magnitude for the voltage fluctuation can be defined as the rms magnitude of the modulation signal. This can be obtained by demodulating the waveform to remove the fundamental frequency and then measuring the magnitude of the modulation components. | 0-1 | ||||||||||
| Voltage fluctuations magnitude (Pst index) | Data Provider or ASPIRES | Flicker severity index Pst as defined in IEC 61000-4-15:2003 [B15] and IEEE Std 1453TM-2004 [B28]. | 0-1 | ||||||||||
| Power frequency variation duration | Data Provider or ASPIRES | Duration of the power frequency variation (in sec) | 0-1 | ||||||||||
| Power frequency variation magnitude | Data Provider or ASPIRES | Deviation of the power system fundamental frequency from its specified nominal value (e.g., 60Hz) (in Hz) | 0-1 |