EWDB_ArrivalStruct

Type: | struct _EWDB_ArrivalStruct
Description: | Arrival structure describing information about a phase, possibly with information relating the phase to an Origin.
Note: | The fields szCalcPhase - tResPick are only legitimate if a phase is associated with an Origin. If idOrigin is not set then these feels should be ignored.
Field | Type | Description
idPick | EWDBid | Database ID of the Pick.
idOriginPick | EWDBid | Database ID of the OriginPick, the record relating the Pick(phase) to an Origin.
idOrigin | EWDBid | Database ID of the Origin with which this phase is associated.
idChan | EWDBid | Database ID of the channel that this pick came from.
pStation | EWDB_StationStruct | Station/Component information for the channel associated with this phase.
szCalcPhase | char[6] | The calculated type of the Phase: P, S, PKP(sp?), and others up to 5 chars. This values is assigned by the phase associator or locator that created the Origin that this phase is associated with. This is not the phase type given by the picker.
tCalcPhase | double | The onset time of the phase, according to the associator/locator.
dWeight | float | The weight of the phase pick in calculating the Origin.
dWeight | float | The weight of the phase pick in calculating the Origin.
dDist | float | The epicentral distance to the station where the phase was observed.
dAzm | float | Azimuthal direction from the station where the phase was observed to the epicenter. Expressed as degrees east of North.
dTakeoff | float | Takeoff angle of the Phase from the hypocenter.
tResPick | float | Pick residual in seconds.
szExtSource | char[16] | Reserved
szExternalPickID | char[16] | Reserved
szExtPickTabName | char[16] | Reserved
szObsPhase | char[6] | The type of the Phase: P, S, PKP(sp?), and others up to 5 chars. This values is assigned by the picker(the entity that observed the phase arrival).
tObsPhase | double | The onset time of the phase, according to the picker.
cMotion | char | The initial motion of the phase: U (up), D (down).
cOnset | char | The onset type of the phase: CLEANUP??? what are the possible onset values? Berkeley has several in their documentation.
dSigma | double | Potential Phase error. Expressed in seconds. CLEANUP detailed meaning?
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_CodaAmplitudeStruct

Type: | struct _EWDB_CodaAmplitudeStruct
Description: | Information for average amplitude measurments of a coda in support of a coda termination measurement/calculation.
Note: |
Field | Type | Description
tOn | double[EWDB_MAXIMUM_AMPS_PER_CODA] | Array of window starting times for coda average amplitude measurements. Expressed as seconds since 1970.
tOff | double[EWDB_MAXIMUM_AMPS_PER_CODA] | Array of window ending times for coda average amplitude measurements. Expressed as seconds since 1970.
iAvgAmp | int[EWDB_MAXIMUM_AMPS_PER_CODA] | Array of average amplitude values for coda average amplitude measurements. Expressed as digital counts. tOn[x] and tOff[x] describe a time window during a coda at a component. AvgAmp[x] is the average wave amplitude during that window. A series of timed average amplitude measurements can be combined with a decay algorithm to estimate the coda termination time.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_CodaDurationStruct

Type: | struct _EWDB_CodaDurationStruct
Description: | Information for the Coda Duration measurement associated with a station magnitude calculation.
Note: |
Field | Type | Description
idChan | EWDBid | Database ID of the channel that this pick came from.
idTCoda | EWDBid | DB ID of the coda termination record.
tCodaTermObs | double | Time when the coda associated with this station duration magnitude, was observed to have ended. Time is expressed as seconds since 1970. *NOTE*: In general, this value should not be used. It is provided as a reference in case tCodaTermXtp contains an extrapolated value. The value of tCodaTermXtp should always be a better value. When recalculating a coda termination time, the results should be written to tCodaTermXtp.)
tCodaTermXtp | double | Time when the coda associated with this station duration magnitude ended. This will be the better of either an observed coda termination, or one calculated based on average amplitude values and a decay rate. Time is expressed as seconds since 1970.
tCodaDurObs | double | Length of the coda (in seconds) from the time of the P-pick to the time of the OBSERVED coda termination. This value should not be used for the coda estimate, use tCodaDurXtp instead. See the tCodaTermObs comment.
tCodaDurXtp | double | Length of the coda (in seconds) from the time of the P-pick to the time of the coda termination. This value is based upon tCodaTermXtp and P-pick times.
idCodaDur | EWDBid | DB ID of the coda duration record calculated by associated a Phase pick with a coda termination.
idPick | EWDBid | DB ID of the Phase arrival(pick) that is associated with a Coda termination from the same channel, to produce the coda duration(s) that this station magniutde is calculated from.
pCodaAmp | EWDB_CodaAmplitudeStruct * | Pointer to a structure of Coda Average Amplitude Values, used to calculate the coda termination time.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_CoincEventStruct

Type: | struct _EWDB_CoincEventStruct
Description: | Coincidence Trigger event structure.
Note: |
Field | Type | Description
idCoincidence | EWDBid | Database ID for the Coincidence.
tCoincTrigger | double | Time of the event trigger
idEvent | EWDBid | Database identifier of the Event with which this Coincidence is associated.
bBindToEvent | int | Boolean flag indicating whether or not this Magnitude should be bound to an Event when it is inserted into the DB. If yes, it is associated with the Event identified by idEvent upon insertion into the DB.
szSource | char[256] | Identifier of the source/author that declared the Coincidence. This could be the Logo of the Earthworm module that generated the Coincidence, or the login name of an analyst that reviewed it.
szComment | char * | Optional comment associated with the magnitude.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_EventListStruct

Type: | struct _EWDB_EventListStruct DESCRIPTION Structure to
Description: |
Note: | There was overlap between EWDB_EventListStruct and EWDB_EventStruct, so the overlapping fields from EWDB_EventListStruct were removed and EWDB_EventStruct was incorporated.
Field | Type | Description
Event | EWDB_EventStruct | Event summary information for the current event.
dOT | double | Time of the Event's preferred origin of in seconds since 1970.
dLat | float | Latitude of the preferred Origin of the Event. Expressed in degrees. (North=positive)
dLon | float | Longitude of the preferred Origin of the Event. Expressed in degrees. (East=positive)
dDepth | float | Depth of the preferred Origin of the Event. Expressed in kilometers below surface.
dPrefMag | float | preferred Magnitude of the Event.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_EventStruct

Type: | struct _EWDB_EventStruct
Description: | Structure containing information about a Database Event.
Note: |
Field | Type | Description
idEvent | EWDBid | Database ID for the event
iEventType | int | Human assigned event-type (quake, avalanche, volcano, nuclear detination). Currently the only types supported are Quake and Unknonwn. See EWDB_EVENT_TYPE_QUAKE for more information.
iDubiocity | int | Describes the perceived validity of the Event. The Dubiocity range is currently defined as TRUE/FALSE with TRUE indicating a dubious event.
bArchived | int | Indicates whether or not the Event has already been archived from the database to disk.
szComment | char[512] | Description of and comments about the Event.
szSource | char[256] | Identifier of the source/author that declared the Event. Only one Source is listed here. If more than one Source contributed to the declaration of the Event, then the manner by which this Source is chosen as THE Source is undefined. This could be the Logo of the Earthworm module that generated the Event, or the or the login name of an analyst that reviewed it.
szSourceName | char[256] | Name of the source/author that declared the Event. The SourceName is a human readable version of the Source. The SourceName could be the name of the network that generated the event, or the name of an Analyst that reviewed it.
szSourceEventID | char[256] | Event identifer assigned to this event by the Source. This would be the EventID given by and Earthworm Binder Module to an automatic event that was generated by an Earthworm.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_MagStruct

Type: | struct _EWDB_MagStruct
Description: | Summary magnitude struct.
Note: |
Field | Type | Description
idMag | EWDBid | Database ID for the Magnitude.
iMagType | int | Magnitude type: Duration, Local, BodyAmp, Surface, etc. This is an enumerated value that identifies a magnitude type. The possible enumerated values are defined in rw_mag.h.
dMagAvg | float | The summary magnitude. For most magnitude types, this is computed as a weighted average of a bunch of station magnitudes.
iNumMags | int | Number of station magnitudes used to compute the dMagAvg. For a Moment magnitude, this maybe the number of reporting stations that were used in calculating the moment.
dMagErr | float | The potential error of the summary magnitude. CLEANUP! Detailed units, meaning? I believe this is the Median Absolute Deviation of the station mags.
idEvent | EWDBid | Database identifier of the Event with which this Magnitude is associated.
bBindToEvent | int | Boolean flag indicating whether or not this Magnitude should be bound to an Event when it is inserted into the DB. If yes, it is associated with the Event identified by idEvent upon insertion into the DB.
bSetPreferred | int | Boolean flag indicating whether or not this Magnitude should be set as the Preferred Magnitude for the Event identified by idEvent. This flag is ignored if bBindToEvent is FALSE.
idOrigin | EWDBid | Optional Database identifier of the Origin that this Magnitude was calculated from.
szSource | char[256] | Identifier of the source/author that declared the Origin. This could be the Logo of the Earthworm module that generated the Origin, or the login name of an analyst that reviewed it. CLEANUP Should this be the human readable version of the source name?? It should be consistent with Origin and Mechanism.
szComment | char * | Optional comment associated with the magnitude. This is provided primarily as an option for later development. Most functions that handle the EWDB_MagStruct, do not know/care about comments.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_MergeStruct

Type: | struct _EWDB_MergeStruct
Description: | Event Merge info structure.
Note: |
Field | Type | Description
idMerge | EWDBid | Database ID for the Merge.
idEvent | EWDBid | Database identifier of the Event which is to be merged.
idPh | EWDBid | Database identifier of the Phenomenon which is to be merged with the event.
szSource | char[256] | Identifier of the source/author that declared the Merge. This could be the Logo of the Earthworm module that generated the Merge, or the login name of an analyst that reviewed it.
szHumanReadable | char[256] | Huamn readable string identifying the person or program that declared the Merge.
szComment | char * | Optional comment associated with the magnitude.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_OriginStruct

Type: | struct _EWDB_OriginStruct
Description: | Structure containing information about an Event Origin. Includes error information.
Note: |
Field | Type | Description
idOrigin | EWDBid | Database identifier of the Origin.
idEvent | EWDBid | Database identifier of the Event with which this origin is associated.
BindToEvent | int | Boolean flag indicating whether or not this Origin should be bound to an Event when it is inserted into the DB. If yes, it is associated with the Event identified by idEvent upon insertion into the DB.
SetPreferred | int | Boolean flag indicating whether or not this Origin should be set as the Preferred Origin for the Event identified by idEvent. This flag is ignored if BindToEvent is FALSE.
tOrigin | double | Origin time in seconds since 1970.
dLat | float | Lattitude of the Origin. Expressed in degrees. (North=positive)
dLon | float | Longitude of the Origin. Expressed in degrees. (East=positive)
dDepth | float | Depth of the Origin. Expressed in kilometers below surface.
dLatStart | float | Lattitude of the starting location.
dLonStart | float | Longitude of the starting location.
dDepthStart | float | Depth of the starting location .
dErrLat | float | Potential lattitude error of the Origin. Expressed in degrees.
dErrLon | float | Potential longitude error of the Origin. Expressed in degrees.
dErZ | float | Potential vertical(depth) error of the Origin. Expressed in km.
ExternalTableName | char[256] | Reserved
xidExternal | char[256] | Reserved
sRealSource | char[51] | Identifier of the source/author that declared the Origin. This could be the Logo of the Earthworm module that generated the Origin, or the login name of an analyst that reviewed it.
sSource | char[101] | Human readable name of the source/author of the origin.
Comment | char[4000] | Comment about the Origin. Currently unused.
iGap | int | Largest gap between stations used to compute the origin. The gap is the largest arc between stations, based on a epicentral circle. Expressed in degrees.
dMin | float | Epicentral distance to nearest station used in origin computation.
dRms | float | RMS misfit for the origin. What does RMS mean? CLEANUP dk 05/01/00.
iAssocRD | int | Number of readings associated with the Origin.
iAssocPh | int | Number of phases associated with the Origin.
iUsedRd | int | Number of readings used to calculate the Origin.
iUsedPh | int | Number of phases used to calculate the Origin.
iE0Azm | int | Azimuth of the smallest principal error of the error elipse. Expressed as Degrees east of North.
iE1Azm | int | Azimuth of the intermediate principal error of the error elipse. Expressed as Degrees east of North.
iE2Azm | int | Azimuth of the largest principal error of the error elipse. Expressed as Degrees east of North.
iE0Dip | int | Dip of the smallest principal error of the error elipse. Expressed as Degrees below horizontal.
iE1Dip | int | Dip of the intermediate principal error of the error elipse. Expressed as Degrees below horizontal.
iE2Dip | int | Dip of the largest principal error of the error elipse. Expressed as Degrees below horizontal.
dE0 | float | Magnitude of smallest principle error of the error elipse.
dE1 | float | Magnitude of intermediate principle error of the error elipse.
dE2 | float | Magnitude of largest principle error of the error elipse.
dMCI | double | Confidence interval. CLEANUP??? Help? Units, detailed meaning?
iFixedDepth | int | Flag indicating whether a fixed depth model was used to calculate the Origin.
iVersionNum | int | Integer > 0 indicating the version number of the current origin. The idea, is that external system will produce multiple revisions of event solutions as time goes on. Each new origin will have an increasing version number assigned to it. That way when you process origin data to produce other summary data (such as magnitudes) you can associate it with the correct origin version.
szSourceEventID | char[256] | Event identifer assigned to this origin's event by the Source. This would be the EventID given by and Earthworm Binder Module to an automatic event that was generated by an Earthworm.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_PeakAmpStruct

Type: | struct _EWDB_PeakAmpStruct
Description: | Information for the Peak Amplitude measurement associated with a station magnitude calculation.
Note: |
Field | Type | Description
idPeakAmp | EWDBid | DB ID of the Peak Amplitude record for this amplitude structure.
idChan | EWDBid | Database ID of the channel that this pick came from.
szExtSource | char[16] | Source where this amplitude was produced
szExternalAmpID | char[16] | ID of the amplitude at the source
dAmp1 | float | 1st Amplitude measurement(millimeters).
dAmpPeriod1 | float | Time period of the first measurement.
tAmp1 | double | Starting time of the first amplitude measurement. Expressed as seconds since 1970.
dAmp2 | float | 2nd Amplitude measurement(millimeters).
dAmpPeriod2 | float | Time period of the second measurement.
tAmp2 | double | Starting time of the second amplitude measurement. Expressed as seconds since 1970.
iAmpType | int | Type of amplitude.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_PhenomenonStruct

Type: | struct _EWDB_PhenomenonStruct
Description: | Phenomenon structure
Note: |
Field | Type | Description
idPh | EWDBid | Database ID for the phenomenon.
idEvent | EWDBid | Database identifier of the Event which first gave rise to this phenomenon.
szSource | char[256] | Identifier of the source/author that declared the Merge. This could be the Logo of the Earthworm module that generated the Merge, or the login name of an analyst that reviewed it.
szHumanReadable | char[256] | Huamn readable string identifying the person or program that declared the Merge.
szComment | char * | Optional comment associated with the merge.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_PlaceStruct

Type: | struct _EWDB_PlaceStruct
Description: | Towns and Places structure
Note: |
Field | Type | Description
idPlace | EWDBid | Database ID for the place.
szState | char[3] | two-letter State code
szPlaceName | char[70] | Name of the place
szPlaceType | char[20] | Type of the place
szCountry | char[30] | Country of the place
szCounty | char[30] | County of the place
dLat | double | Latitude
dLon | double | Longitude
dElev | double | Elevation
iPopulation | int | Population
iPlaceMajorType | int | Major Type (City, Dam, etc...)
iPlaceMinorType | int | Minor Type (large city, small city...)
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_StationMagStruct

Type: | struct _EWDB_StationMagStruct
Description: | Structure of Station Magnitude information.
Note: |
Field | Type | Description
pStationInfo | EWDB_StationStruct * | Station information for the station for which the magnitude was calculated.
idChan | EWDBid | Database ID of the channel that this pick came from.
pStationInfo | EWDB_StationStruct | Station/Component information for the channel associated with this phase.
idMagLink | EWDBid | DB ID of the station magnitude.
idMagnitude | EWDBid | DB ID of the summary magnitude.
iMagType | int | Type of magnitude. See rw_mag.h for a list of Magnitude types.
dMag | float | Station magnitude.
dWeight | float | Weight of the Station Magnitude in calculating the summary magnitude this Station Magnitude is associated with.
idDatum | EWDBid | DB ID of the measurement that the station magnitude is calculated from. The measurement could be a Peak Amplitude or Coda Duration.
StaMagUnion | EWDB_StationMagUnion | Information about the measurement upon which the magnitude is based. This could be either Peak Amplitude information for an Amplitude based magnitude, or Coda Duration information for a Duration based magnitude.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_StationMagUnion

Type: | union _EWDB_StationMagUnion
Description: | Structure of Station Magnitude information.
Note: |
Field | Type | Description
PeakAmp | EWDB_PeakAmpStruct | Measurement information for an Amplitude measurement.
CodaDur | EWDB_CodaDurationStruct | Measurement information for a Coda Duration measurement.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h

EWDB_TriggerStruct

Type: | struct _EWDB_TriggerStruct
Description: | Single Channel Triggerstructure.
Note: |
Field | Type | Description
idTrigger | EWDBid | Database ID for the Coincidence.
tTrigger | double | Time of the trigger
idCoincidence | EWDBid | Database identifier of the Coincidence Event with which this trigger is associated.
idChan | EWDBid | Database identifier of the channel with which this trigger is associated.
Group: | EWDB_API_LIB
Sub Group: | PARAMETRIC_API
Language: | C
Location: | ./src/oracle/schema-working/src/include/ewdb_ora_api.h