Schema Overview
Columns indicate:
Label: a human-readable label for the property
Source: the supplier of the data value contained in the property
Property: the RDF value of the metadata element
Sub-property of: a master RDF value that the property belongs to
Range: an indication of the data type of the value of the property
Usage: description of how the property should be used
Vocab Schema: a controlled vocabulary to be applied to the value of the property
Syntax Schema: a syntax for the value of the property
Obligation: the requirement for the number of properties that can exist
| 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 | Model of the PQ monitor | 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 | 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 ISO 8601 format | ISO 8601
| 0-1 | 2003-02-02T 19:57:45.5000
| 2003-02-01T 03:54:06.4671 | 2003-02-26T15:54:17 |
| ||||
| 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 | |||||||||
| 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 | ASPIRES | .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 recording entity) | 0-1 | Electrotek | Electrotek | Electrotek | ||||||
| Data source | ASPIRES or Data provider | .dataSource | Name of the entity or organization that recorded the data (for example, a utility company). Could be the same as the data provider. | 0-1 | |||||||||
| 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 | |||||||||
| Containing dataset | Data provider | .rawData | 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 | Additional description about the event | 0-1 | |||||||||
| Software analysis | Data provider or ASPIRES | Software analysis | Software analysis performed on the event | 0-1 | |||||||||
| IEEE disturbance classification | ASPIRES or Data Provider | IEEE Disturbance | Category of this event according to the IEEE standard 1159-2009 | 0-n |
| 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 | Voltage headers: Va, Vb, Vc, Vn, Vab, Vbc, Vca, Ia, Ib, Ic, In | 1 | [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 |  |  |  |
| ||||
| Count of data samples | Data Provider or ASPIRES | .count | array | Number of data samples | 1 | 7200 | 384 | 7680 | 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 |
| 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 | array | Weather category 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-1 | Wind | Clear Day | |||||
| Isolation equipment | Data Provider | .isolationEquipment | Type of the protection equipment that cleared the disturbance 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 | 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 | 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 | 0-1 | Tree | Overload | Scheduled | |||||
| Detail | Data Provider | .detail | Additional details if available | Text | 0-1 |
| 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 |
| Maximum rms current among the three phases in amps | 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 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 |