|
|
| Format | NUMBER(12,1) |
| Description | Measured amplitude of ground motion. Ideally, this is the amplitude of the maximum zero-to-peak by period motion, corrected for both system gain and frequency response. The amplitude type can be specified in the AMPTYPE attribute. |
| Units | Nanometers |
| Values | 0 to 99999999999.9 |
| Relations | AMPLITUDE |
|
|
| Format | NUMBER(8) |
| Description | ID number of an amplitude. Primary key on the amplitude relation. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | AMPLITUDE PHASE AMPDESCRIPT |
|
|
| Format | VARCHAR2(8) |
| Description | Amplitude type name |
| Units | - |
| Values | 0-to-p p-to-p ... |
| Relations | AMPLITUDE |
|
|
| Format | VARCHAR2(8) |
| Description | Code of agency that computed in this row of this relation |
| Units | - |
| Values | From the ISC/WDC agency list |
| Relations | AFFILIATION AMPDESCRIPT ASSOCIATION BIBLIOGRAPHY BIBLIO_AUTHOR BIBLIO_EVENT EVENT FAULT_PLANES HYPOC_ERR HYPOCENTER INTENSITY MOMENT_TENSOR MOMENT_TENSOR_ERR NETMAG PHASE PRINCIPAL_AXES PUB_COMMENTS REMARK SCALAR_MOMENT SITE SITE_OUTAGE SITE_SORT STAMAG UNASSOC_COMMENTS |
|
|
| Format | NUMBER(5,2) |
| Description | Measured value of azimuth |
| Units | Degrees, clock-wise from north |
| Values | 0 to 359.99 |
| Relations | PHASE |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if measured azimuth is of a phase is used in a hypocenter computation |
| Units | - |
| Values | 'D' or NULL |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(6,3) |
| Description | Largest gap in azimuth between stations with times that are defining for a hypocenter |
| Units | Degrees |
| Values | 0 to 359.999 |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(6,3) |
| Description | Azimuth residual: measured azimuth - station to event azimuth |
| Units | Degrees |
| Values | -179.999 to ?180 |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(12,4) |
| Description | Azimuth or strike of one eigenvector of the principal axis system. |
| Units | degrees |
| Values | 0 to 360 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(12,4) |
| Description | Plunge of one eigenvector of the principal axis system. |
| Units | degrees |
| Values | 0 to 360 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(12,4) |
| Description | Eigenvalue of one eigenvector of the principal axis system for the moment tensor. |
| Units | |
| Values | 0 to 99999999.9999 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if an event is excluded from the ISC Bulletin. The banished flag is set only in response to seismologist editing. |
| Units | - |
| Values | 'B' or NULL |
| Relations | EVENT |
|
|
| Format | VARCHAR2(1) |
| Description | Flag set if the hypocentre entry is a centroid. |
| Units | - |
| Values | C or NULL |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(3) |
| Description | Channel code on which an arrival time was picked and slowness, azimuth and amplitude were measured. If measurements were made on different channels, then there should be several phases of the same reading. |
| Units | - |
| Values |
NULL chan is common since it was often not reported, unknown values are represented by '?'. Non-NULL values are restricted to those of the FDSN list. Most common non-NULL values of character 1, band code: B=broadband, S=short-period ... character 2, Instrument code: H=high-gain, D=pressure sensor ... character 3, Orientation code: Z=vertical, E=east, N=north ... |
| Relations | PHASE AMPLITUDE |
|
|
| Format | DATE |
| Description | 23:59:59 on last date of operation of a seismometer with a particular station code. When only first month of operation is known, last day of that month. When only first year of operation is know, DEC-31 of that year. NULL when the first date of operation is unknown. Instruments may be changed or relocated up to 1 km from the original site without requiring a new code. Temporary shut downs are not recorded in the site table. |
| Units | day |
| Values | Any Oracle date earlier than SYSDATE |
| Relations | SITE |
|
|
| Format | VARCHAR2(8) |
| Description | UNIX user name of the process that stored a report. |
| Units | - |
| Values | Any valid UNIX user name |
| Relations | REPORT |
|
|
| Format | NUMBER(8) |
| Description | Event with which a hypocenter was grouped in a report to the ISC. When reports are collected with only one hypocenter for each event, a new event is created with one grouped hypocenter in each case. |
| Units | - |
| Values | Any unique number in the range of 1 to 99999999. |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(8) |
| Description | Part of the unique key identifying a published comment. Identifies distinct comments within an ID_NAME/ID_VALUE block. NOTE if the value is 0 then this comment should not be published. |
| Units | - |
| Values | 1 to 99999999. |
| Relations | PUB_COMMENTS UNASSOC_COMMENTS |
|
|
| Format | VARCHAR2(2) |
| Description | A code indicating a subjective judgement on confidence in a hypocentral time or location. |
| Units | - |
| Values | For reported hypocenters: a reported confidence code or a summary representation of one of a standard set of confidence comments, including:;;'LC': low-confidence solution;;For ISC hypocenters:;;NULL: standard value; no special reason to doubt hypocentral accuracy.;;'Poor': a poor quality solution, i.e., the data misfit is large, the misfit norm is broad, or the misfit norm has multiple local minima. |
| Relations | HYPOC_ERR |
|
|
| Format | VARCHAR2(9) |
| Description | Coordinate system used to describe the 6 components of the moment tensor. |
| Units | - |
| Values |
SPHERICAL spherical polar coordinates, R, radius, T theta and P phi. CARTESIAN x,y,z coordinates Note: Values are inserted so that X subtituted for R, Y for T and Z for P. |
| Relations | PHASE AMPLITUDE |
|
|
| Format | VARCHAR2(30) |
| Description | Description of the type of data in the corresponding VALUE attribute |
| Units | Any |
| Values | Any |
| Relations | PHASE_MISC HYPOCENTER_MISC |
|
|
| Format | DATE |
| Description | Time to nearest second |
| Units | day |
| Values | Any Oracle date earlier than SYSDATE |
| Relations | AMPLITUDE HYPOCENTER PHASE UNASSOC_COMMENTS |
|
|
| Format | NUMBER(10,1) |
| Description | Arithmetic (plus or minus) uncertainty of a measured amplitude |
| Units | Nanometers |
| Values | 0 to 999999999.9, or NULL |
| Relations | AMPLITUDE |
|
|
| Format | NUMBER(5,2) |
| Description | Arithmetic (plus or minus) uncertainty of a measured azimuth |
| Units | Degrees |
| Values | 0 to 360, or NULL |
| Relations | PHASE |
|
|
| Format | NUMBER(8) |
| Description | Arithmetic (plus or minus) uncertainty of a measured period |
| Units | Seconds |
| Values | 0 to 99999999, or NULL |
| Relations | AMPLITUDE |
|
|
| Format | NUMBER(5,2) |
| Description | Arithmetic (plus or minus) uncertainty of a measured slowness |
| Units | Seconds / Degree |
| Values | 0 to 999.99 |
| Relations | PHASE |
|
|
| Format | NUMBER(6,3) |
| Description | Distance between a station and a hypocenter |
| Units | Degrees |
| Values | 0 to 180 |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(9,5) |
| Description | Arrival time uncertainty |
| Units | Seconds |
| Values | 0 to 9999.99999, or NULL |
| Relations | PHASE |
|
|
| Format | NUMBER(8,5) |
| Description | Depth computed from differences between arrival times of depth phases and direct phases, presuming the epicentre computed from inversion of the direct phase arrival times. |
| Units | Kilometres |
| Values | 0 to 999.99999, or NULL |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if depth is fixed. For ISC hypocenters the flag may be set by seismologist editing, in which case the depth will be fixed in subsequent re-computations of the hypocenter. In addition, the flag may be set by the location algorithm if it fails to converge with a free depth. |
| Units | - |
| Values |
'F' = fixed depth (sdepth = NULL) 'N' = depth given only as "normal" in an historical file (in database, depth = 33 km, sdepth = NULL) 'S' = depth given only as "shallow" in an historical file (in database, depth = 33 km, sdepth = 35 km) 'I' = depth given only as "intermediate" in an historical file (in database, depth = 200 km, sdepth = 115 km) 'D' = depth given only as "deep" in an historical file (in database, depth = 500 km, sdepth = 200 km) 'R' = a depth range is given in an historical file (in database, depth = range midpoint, sdepth = half of range) |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set to 'D' if data is excluded from the ISC Bulletin. No measurement from a deprecated datum is used in computing any earthquake parameter in the Bulletin or Catalogue. Event formation does not use deprecated phases or epicentres. The flag can be set to 'M' to indicate a modification or correction of the data has been carried out after publication. The 'P' flag indicates preliminary data tht is expected to be replaced prior to publication. |
| Units | - |
| Values | 'D','M','P' or NULL |
| Relations | AMPLITUDE association.html fault_planes.html hypocenter.html hypoc_err.html intensity.html moment_tensor.html moment_tensor_err.html netmag.html phase.html principal_axes.html pub_comments.html scalar_moment.html stamag.html |
|
|
| Format | NUMBER(8,5) |
| Description | Depth of a seismic event or seismic sensor below the free surface of the earth |
| Units | Kilometres |
| Values | 0 to 999.99, or NULL |
| Relations | HYPOCENTER SITE SCALAR_MOMENT |
|
|
| Format | NUMBER(8,5) |
| Description | Dip of same nodal plane as strike, specified by FAULT. |
| Units | Degrees |
| Values | 0 to 90 |
| Relations | FAULT_PLANES |
|
|
| Format | VARCHAR2(40) |
| Description | Directory where a report is stored. This is a sub-directory of the directory named by environment variable $QINPUT. |
| Units | - |
| Values | Any valid UNIX directory name |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | Presumed or computed source duration, half duration for Harvard (GCMT/HRVD). |
| Units | s |
| Values | |
| Relations | SCALAR_MOMENT MOMENT_TENSOR |
|
|
| Format | NUMBER(8,1) |
| Description | Elevation of the earth's surface above the geoid |
| Units | meters |
| Values | +/-9999999.9, or NULL if unknown |
| Relations | SITE |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if phase arrival was reported to ISC as emergent |
| Units | - |
| Values | 'e' or NULL |
| Relations | PHASE |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if epicentre is fixed. For ISC hypocenters the flag may be set by seismologist editing, in which case the epicentre will be fixed in subsequent re-computations of the hypocenter. In addition, the flag may be set by the location algorithm if it fails to converge with a free depth. |
| Units | - |
| Values | 'F' or NULL |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(6,3) |
| Description | Event-to-station azimuth. After a hypocenter is computed, the azimuth (clockwise from north) of a great circle path at the event towards the station is computed. |
| Units | Degrees |
| Values | 0 to 359.999 |
| Relations | ASSOCIATION |
|
|
| Format | VARCHAR2(4) |
| Description | Event type. A string indicating whether the event is certainly or probably a tectonic earthquake, an explosion or a mining-related event. |
| Units | - |
| Values |
For reported hypocenters: if an event type is reported then the equivalent ISF code is loaded in the ISC database, but most are reported without an event type, in which case ISC's etype is NULL. Some agencies have a policy of excluding suspected explosions or mining related events, in which case ISC's etype may indicate a probable earthquake. For some agencies, an inverted scheme is used in which all events are presumed to be mining-related except those marked tectonic. For ISC hypocenters: an interpretation of codes reported with other hypocenters grouped in the same event. The ISF codes are shown in the Search output description for origin data. |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(8) |
| Description | Identification number of an event. Primary key on the event table. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | EVENT BIBLIO_EVENT INTENSITY |
|
|
| Format | NUMBER(8) |
| Description | Exponent of both the moment, the individual components and the eigenvalues. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | SCALAR_MOMENT |
|
|
| Format | VARCHAR2(1) |
| Description | 'F' if described plane is preferred for fault, 'A' if described plane is preferred for aux or NULL if preference is unknown |
| Units | - |
| Values | F, A, NULL |
| Relations | FAULT_PLANES |
|
|
| Format | NUMBER |
| Description | Fraction of the moment released as a compensated linear vector dipole. |
| Units | |
| Values | |
| Relations | MOMENT_TENSOR PRINCIPAL_AXES |
|
|
| Format | NUMBER(8,5) |
| Description | Uncertainty of the value of the fraction of the moment released as a compensated linear vector dipole, FCLVD. |
| Units | |
| Values | 0 to 9999.9999 |
| Relations | MOMENT_TENSOR_ERR |
|
|
| Format | VARCHAR2(20) |
| Description | Name of the file that a report e-mailed to the ISC is saved as. |
| Units | - |
| Values | Any valid UNIX file name |
| Relations | REPORT |
|
|
| Format | DATE |
| Description | The date of the earliest hypocentre in a report |
| Units | - |
| Values | - |
| Relations | REPORT |
|
|
| Format | DATE |
| Description | The date of the earliest phase in a report |
| Units | - |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8) |
| Description | ID number of a scalar moment. Serves as the primary key on the SCALAR_MOMENT table and elsewhere an external key to the tables holding details of the solution. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | FAULT_PLANES MOMENT_TENSOR MOMENT_TENSOR_ERR PRINCIPAL_AXES PUB_COMMENTS SCALAR_MOMENT |
|
|
| Format | NUMBER(4) |
| Description | Geographic Region Number: one of the 700 smaller regions outlined in Flinn and Engdahl, 1965. On the hypocenter table, each committed insert or update of lat or lon triggers a stored procedure to set SRN. |
| Units | - |
| Values | 1 to 729 |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(13) |
| Description | Name of a group to which a station belongs, used to organise stations internally at the ISC. A station may belong to only one publicly known network, but the ISC groups stations internally (e.g., by country, operator, or reporting agency) for various purposes. |
| Units | - |
| Values | Any string of upper and lower case letters, digits and punctuation. |
| Relations | AFFILIATION |
|
|
| Format | VARCHAR2(12) |
| Description | Where a station belongs to a group, this is the type of that group. |
| Units | - |
| Values | Any string of upper and lower case letters, digits and punctuation. Examples include 'country','operator','reporter'. |
| Relations | AFFILIATION |
|
|
| Format | NUMBER(8) |
| Description | The number of hypocentres in a report |
| Units | - |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The maximum latitude of any hypocentre in a report. HYP_MIN_LAT, HYP_MAX_LAT, HYP_MIN_LON and HYP_MAX_LON can be used to indicate the region over which hypocentres are computed by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The maximum longitude of any hypocentre in a report. HYP_MIN_LAT, HYP_MAX_LAT, HYP_MIN_LON and HYP_MAX_LON can be used to indicate the region over which hypocentres are computed by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The minimum latitude of any hypocentre in a report. HYP_MIN_LAT, HYP_MAX_LAT, HYP_MIN_LON and HYP_MAX_LON can be used to indicate the region over which hypocentres are computed by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The minimum longitude of any hypocentre in a report. HYP_MIN_LAT, HYP_MAX_LAT, HYP_MIN_LON and HYP_MAX_LON can be used to indicate the region over which hypocentres are computed by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8) |
| Description | ID number of a hypocenter. Primary key on the hypocenter table and elsewhere an external key to the hypocenter table. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | ASSOCIATION HYPOC_ERR HYPOCENTER HYPOCENTER_MISC INTENSITY NETMAG SCALAR_MOMENT STAMAG |
|
|
| Format | VARCHAR2(6) |
| Description | Type of external key by which this published comment is joined. |
| Units | - |
| Values | 'hypid', 'evid', 'phid', 'macroid' |
| Relations | PUB_COMMENTS |
|
|
| Format | NUMBER(8) |
| Description | Value of external key by which this published comment is joined. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | PUB_COMMENTS |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if phase was reported as impulsive. |
| Units | - |
| Values | The leading character of an impulsive indication in a report to the ISC. In most cases, 'i'. NULL if the phase was reported without an indication that the phase was impulsive; no distinction is made between phases in reports with no impulsive indications for any phase and individual phases missing an impulsive flag in a report that allows them. |
| Relations | PHASE |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if a phase is the initial phase in a reading. The flag is used for straightforward sorting of readings in selections from the database. |
| Units | - |
| Values | 'I' or NULL. |
| Relations | PHASE |
|
|
| Format | NUMBER(8) |
| Description | ID of the ISC event with which a hypocenter is grouped. Each hypocenter is grouped with at most two events: the event with which it is reported and an ISC event created by grouping hypocenters or reported events. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(1) |
| Description | This variable is used as a Boolean. 'Y' means that the variable is printed by the ISC in ISF #PARAM comments when it is found in hypocenter_misc and in ISF #MEASURE comments when it is found in phase_misc. |
| Units | none |
| Values | 'Y' or 'N' |
| Relations | MISC_DATATYPES |
|
|
| Format | VARCHAR2(40) |
| Description | String to be written an ISF #PARAM or #MEASURE comment that will identify the datatype there. |
| Units | none |
| Values | Any string composed of upper-case letters and underscores |
| Relations | MISC_DATATYPES |
|
|
| Format | DATE |
| Description | The date of the latest hypocentre in a report |
| Units | - |
| Values | - |
| Relations | REPORT |
|
|
| Format | DATE |
| Description | The date of the latest phase in a report |
| Units | - |
| Values | - |
| Relations | REPORT |
|
|
| Format | VARCHAR2(8,5) |
| Description | Latitude: distance north from the equator (<0 for south). Not the geocentric latitude; i.e., a correction for the earth's ellipticity must be made to accurately compute the distance between two hypocenter or site locations from latitude and longitude in the database. |
| Units | degrees |
| Values | -90 to +90 |
| Relations | HYPOCENTER INTENSITY SITE INTENSITY |
|
|
| Format | DATE |
| Description | Date (local time, to the nearest second) on which a row was entered an ISC database. On tables with lddate, each committed insert triggers a stored procedure to set lddate=SYSDATE if lddate is NULL. |
| Units | days |
| Values | Any Oracle date between 1999-APR-01 (when the ISC relational database was established) and SYSDATE. |
| Relations | AFFILIATION AMPDESCRIPT ASSOCIATION BIBLIOGRAPHY BIBLIO_AUTHOR BIBLIO_EVENT EVENT FAULT_PLANES HYPOC_ERR HYPOCENTER INTENSITY MOMENT_TENSOR MOMENT_TENSOR_ERR NETMAG PHASE PRINCIPAL_AXES PUB_COMMENTS REMARK REPORT SCALAR_MOMENT SITE SITE_OUTAGE SITE_SORT STAMAG UNASSOC_COMMENTS |
|
|
| Format | NUMBER(3) |
| Description | Line number in text that has been broken in into lines for more convenient display. |
| Units | - |
| Values | 1 to 999 |
| Relations | MACROSEISMIC PUB_COMMENTS UNASSOC_COMMENTS REMARK SITE_INFO |
|
|
| Format | NUMBER(9,2) |
| Description | Logarithm base 10 of ground motion amplitude divided by period. The value reported to the ISC, according to the manual of observatory practice, should be the maximum of (amplitude/period) in the wavetrain of the named phase, corrected for system gain and frequency response. |
| Units | amplitude in Nanometers, period in Seconds |
| Values | -9999999.99 to +9999999.99 |
| Relations | AMPLITUDE |
|
|
| Format | NUMBER(8,5) |
| Description | Longitude: distance east (<0 for west) from the prime meridian. |
| Units | degrees |
| Values | -180 to +180 |
| Relations | HYPOCENTER SITE INTENSITY |
|
|
| Format | VARCHAR2(1) |
| Description | Long period first motion. The first character of any long-period first motion indication reported to the ISC is stored in the database, except that encoding of long period and short period first motion into a single character in "telegraphic format" is interpreted. |
| Units | - |
| Values |
'c', 'C', '+' usually indicate compression (up or away from the event) 'd', 'D', '-' usually indicated dilation (down or towards the event) |
| Relations | PHASE |
|
|
| Format | NUMBER(8) |
| Description | Identification number of a given magnitude. The primary key on the netmag and stamag tables. An external key in the hypocenter table to netmag table for more information about the primary magnitude value, which is included in the hypocenter table. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | HYPOCENTER NETMAG SCALAR_MOMENT STAMAG |
|
|
| Format | NUMBER(4,2) |
| Description | The value of a magnitude. For reported events, a reported magnitude is entered as reported. ISC network magnitudes are computed as the unweighted mean of the associated station magnitudes of the same type (e.g., mb or MS) and in the appropriate distance range. |
| Units | - |
| Values | 0.00 to 10.00, or NULL. |
| Relations | HYPOCENTER NETMAG STAMAG |
|
|
| Format | VARCHAR2(6) |
| Description | Type of magnitude |
| Units | - |
| Values |
For magnitudes computed by the ISC: MS = surface wave magnitude mb = body wave magnitude For magnitude reported to ISC: Just as reported; typical values, in addition to MS and mb as above, include ML = local magnitude MR = Richter magnitude -- often a synonym for ML MD = duration magnitude MN = body wave magnitude from Lg MW = moment magnitude ME = energy magnitude ISC does not normally compute magnitudes from other reported earthquake parameters (e.g., seismic moment or radiated energy), but includes derived magnitudes in the Bulletin only when others have reported them to ISC. |
| Relations | HYPOCENTER NETMAG STAMAG |
|
|
| Format | NUMBER(6,3) |
| Description | Maximum and minimum distances of associated stations with at least one defining arrival time. |
| Units | degrees |
| Values | 0 to 179.999 |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(40) |
| Description | Name of a datatype in phase_misc or hypocenter_misc. This name can be used to join on phase_misc.data_type hypocenter_misc.data_type. There should be no rows in phase_misc or hypocenter_misc with data_type without a corresponding misc_datatype.misc_name. |
| Units | none |
| Values | Any non-null Oracle character string |
| Relations | MISC_DATATYPES |
|
|
| Format | DATE |
| Description | Last date at which a table row was modified. In a row that has not been modified since it was inserted, moddate is NULL |
| Units | day |
| Values | Any Oracle date earlier than SYSDATE, or NULL |
| Relations | AFFILIATION AMPDESCRIPT ASSOCIATION BIBLIOGRAPHY BIBLIO_AUTHOR BIBLIO_EVENT EVENT FAULT_PLANES HYPOC_ERR HYPOCENTER INTENSITY MOMENT_TENSOR MOMENT_TENSOR_ERR NETMAG PHASE PRINCIPAL_AXES PUB_COMMENTS REMARK REPORT SCALAR_MOMENT SITE SITE_OUTAGE SITE_SORT STAMAG UNASSOC_COMMENTS |
|
|
| Format | NUMBER(8,5) |
| Description | Mantissa of the scalar moment. |
| Units | N.m |
| Values | 1 to 99999999 |
| Relations | SCALAR_MOMENT |
|
|
| Format | NUMBER(8,5) |
| Description | Uncertainty of the value of the scalar moment, MOMENT. |
| Units | |
| Values | 0 to 9999.9999 |
| Relations | MOMENT_TENSOR_ERR |
|
|
| Format | NUMBER(8,5) |
| Description | Mantissa of one of the six (MRR,MTT,MPP,MRT,MTP,MPR) independent components of the moment tensor. The exponent is required from SCALAR_MOMENT FACTOR. |
| Units | N.m |
| Values | 0 to 999.99999, or NULL |
| Relations | MOMENT_TENSOR |
|
|
| Format | NUMBER(8,5) |
| Description | Uncertainty of one of the six (MRR,MTT,MPP,MRT,MTP,MPR) independent components of the moment tensor. |
| Units | |
| Values | 0 to 999.99999, or NULL |
| Relations | MOMENT_TENSOR_ERR |
|
|
| Format | NUMBER(3) |
| Description | Millisecond component of a time. For times requiring accuracy better than one second, the complete time is given by DAY and MSEC. |
| Units | milliseconds |
| Values | 0 to 999 |
| Relations | AMPLITUDE HYPOCENTER PHASE |
|
|
| Format | NUMBER(4) |
| Description | Number of phases associated with a hypocenter. For reported hypocenters, NULL if unknown to ISC. For ISC hypocenters, set when a hypocenter is re-computed. (That is, after phases are put or taken in editing, nass will be out of date until the hypocenter is re-computed.) |
| Units | - |
| Values |
1 to 9999, or NULL (only reported hypocenters). If non-NULL, NASS >= NDEF >= NSTA. |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(5) |
| Description | Total number of components used in inversion ( body wave records for GCMT/HRVD). |
| Units | |
| Values | 1 99999 |
| Relations | MOMENT_TENSOR |
|
|
| Format | NUMBER(5) |
| Description | Total number of components used in inversion ( mantle wave records for GCMT/HRVD). |
| Units | |
| Values | 1 99999 |
| Relations | MOMENT_TENSOR |
|
|
| Format | NUMBER(4) |
| Description | Number of phases with a defining measurement for a hypocenter. For reported hypocenters, may be presumed as NASS if not otherwise clear in reports to ISC, and may be NULL if unknown to ISC. For ISC hypocenters, set when a hypocenter is re-computed. (That is, after editing, ndef may be out of date until the hypocenter is re-computed.) |
| Units | - |
| Values |
1 to 9999, or NULL (only reported hypocenters). If non-NULL, NASS >= NDEF >= NSTA. |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(4) |
| Description | Number of distinct stations that have one or more phases with a defining measurement for a hypocenter. |
| Units | - |
| Values |
1 to 9999, or NULL (only reported hypocenters). If non-NULL, NASS >= NSTA >= NDEF >= NDEFSTA. |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(4) |
| Description | Number of associated depth phases. For reported hypocenters, may be NULL if unknown to ISC. For ISC hypocenters, set when a hypocenter is re-computed. (That is, may be out of date after editing until the hypocenter is re-computed.) |
| Units | - |
| Values | 0 to 9999, or NULL (only reported hypocenters) |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(6) |
| Description | Network code used publicly to show station ownership and distinguish from stations in other networks that may have the same station code. |
| Units | - |
| Values | Codes from the ISC/WDC-A network list. |
| Relations | AFFILIATION ASSOCIATION PHASE SITE SITE_ALT_NAMES SITE_OUTAGE |
|
|
| Format | NUMBER(4) |
| Description | Number of distinct stations with at least one phase associated with a hypocenter or an amplitude contributing to a magnitude. |
| Units | - |
| Values |
1 to 9999, or NULL (only reported hypocenters). If non-NULL, NASS >= NDEF >= NSTA. |
| Relations | HYPOCENTER NETMAG |
|
|
| Format | NUMBER(5) |
| Description | The number of stations used in the inversion. ( body wave records for GCMT/HRVD). |
| Units | |
| Values | 1 99999 |
| Relations | MOMENT_TENSOR |
|
|
| Format | NUMBER(5) |
| Description | The number of stations used in the inversion. ( mantle wave or surface wave records for GCMT/HRVD). |
| Units | |
| Values | 1 99999 |
| Relations | MOMENT_TENSOR |
|
|
| Format | NUMBER(3) |
| Description | Number of P polarities used. |
| Units | - |
| Values | 1 to 999 |
| Relations | FAULT_PLANES |
|
|
| Format | NUMBER(3) |
| Description | Number of S polarities used. |
| Units | - |
| Values | 1 to 999 |
| Relations | FAULT_PLANES |
|
|
| Format | NUMBER(3) |
| Description | Number of stations used. |
| Units | - |
| Values | 1 to 999 |
| Relations | FAULT_PLANES |
|
|
| Format | DATE |
| Description | Date when a station outage started, i.e., when a station went off. |
| Units | day |
| Values | Any Oracle date earlier than sysdate |
| Relations | SITE_OUTAGE |
|
|
| Format | DATE |
| Description | Date when a station outage ended, i.e., when a station came back on. |
| Units | day |
| Values | Any Oracle date earlier than sysdate |
| Relations | SITE_OUTAGE |
|
|
| Format | DATE |
| Description | 00:00:00.0 on first date of operation of a seismometer with a particular station code. When only first month of operation is known, day one of that month. When only first year of operation is know, JAN-01 of that year. NULL when the first date of operation is unknown. Instruments may be changed or relocated up to 1 km from the original site without requiring a new code. Temporary shut downs are not recorded in the site table. |
| Units | day |
| Values | Any Oracle date earlier than sysdate |
| Relations | SITE |
|
|
| Format | NUMBER(12,4) |
| Description | Azimuth or strike of one eigenvector of the principal axis system. |
| Units | degrees |
| Values | 0 to 360 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(12,4) |
| Description | Plunge of one eigenvector of the principal axis system. |
| Units | degrees |
| Values | 0 to 360 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(12,4) |
| Description | Eigenvalue of one eigenvector of the principal axis system for the moment tensor. |
| Units | |
| Values | 0 to 99999999.9999 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(6,2) |
| Description | Period of measured amplitude. Ideally, this is the period of the maximum zero-to-peak by period motion. |
| Units | Seconds |
| Values | 0 to 9999.99 |
| Relations | AMPLITUDE |
|
|
| Format | VARCHAR(8) |
| Description | Phase name, indicating propagation mode within the earth, in many cases by a sequence of letters for layers within the earth through which a ray path travelled and boundaries from which reflected from a ray path reflected. Also, some special-purpose names that modify the meaning of other values in the row. |
| Units | - |
| Values |
In the phase table and for reported associations: names exactly as reported to the ISC. Such phase names often encode information additional to propagation mode within the earth, such as impulsiveness and uncertainty or alternative possible identifications. In ISC associations: phase names as described in the IASPEI manual of observatory practice. |
| Relations | ASSOCIATION PHASE STAMAG |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if an ISC seismologist editing the Bulletin has indicated that subsequent ISC processing should not consider phase re-identification hypotheses. |
| Units | - |
| Values | 'F' or NULL |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(8) |
| Description | Phase identification number. Primary key on the phase table. Used in other tables to indicate which phase is associated or for which phase a measurement was made. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | AMPLITUDE ASSOCIATION PHASE PHASE_MISC STAMAG |
|
|
| Format | NUMBER(8) |
| Description | ID of the preferred hypocentre for a given estimate. The ISC receives independently reported epicentre estimates that agencies associate phase data with. Often these are duplicated and the pref_hypid indicates which one is to be published or used during editing |
| Units | - |
| Values | 1 to 99999999, or NULL |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(8) |
| Description | ID of the preferred reading for a given record. When the ISC receives independently reported times at the same network/station on the same channel at approximately the same time, it concludes that they are "duplicates", i.e., redundant readings from one seismic record. A preferred reading is selected based on completeness of measurements, number of phases and a preference for readings from the station operator. |
| Units | - |
| Values | 1 to 99999999, or NULL |
| Relations | PHASE |
|
|
| Format | VARCHAR2(6) |
| Description | Network code of the stations primary network, typically the FDSN code. It is needed to allow the inclusion and identification of stations with no IRS station code. |
| Units | - |
| Values | Local or FDSN network code. |
| Relations | SITE |
|
|
| Format | NUMBER(8) |
| Description | ID number (hypid) of the primary hypocenter for an event. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | EVENT |
|
|
| Format | VARCHAR2(6) |
| Description | For an alternate station code, the primary code of the same station. Historically, some stations have been identified internationally by several different codes. In each case, ISC/WDC-A have agreed a preferred code. In order to minimise loss of information, however, the station codes of historical arrivals are not changed, so a link to the primary code for that station is required. |
| Units | - |
| Values | NULL (for stations already identified by their primary code) or a primary station code from the ISC/WDC-A list of codes. Thus, a string of 3 to 5 characters beginning with an uppercase letter and limited to uppercase letters, digits and '*'. |
| Relations | SITE |
|
|
| Format | VARCHAR2(20) |
| Description | Brief description of the type of data present in a report. This will be taken, where possible, from the subject line of the e-mail message including the report or from the header of the report itself. |
| Units | - |
| Values | Any character string |
| Relations | REPORT |
|
|
| Format | VARCHAR(1500) |
| Description | Text of a published comment. |
| Units | - |
| Values | Any character string |
| Relations | PUB_COMMENTS |
|
|
| Format | NUMBER(8,5) |
| Description | Rake or slip vector of the described nodal plane, specified by FAULT. |
| Units | Degrees |
| Values | -180 to 180 |
| Relations | FAULT_PLANES |
|
|
| Format | NUMBER(8) |
| Description | Identification number of a reading. A non-unique number in the phase table that is shared by all of the phases in one reading. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | PHASE |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if an event is ready for publication in the ISC bulletin. It is set to T to indicate that the event is being edited and the flag is removed on completion. |
| Units | - |
| Values | 'R', 'T' or NULL |
| Relations | EVENT |
|
|
| Format | VARCHAR2(80) |
| Description | Name of a region, no larger than an independent country, in which a station is located. Usually a political region, e.g., a province of China or Canada, or a state in the USA. |
| Units | - |
| Values | Any region name |
| Relations | SITE |
|
|
| Format | VARCHAR2(80) |
| Description | One line of a remark, intended for internal use within the ISC to track special information about any type of data. |
| Units | - |
| Values | Any string |
| Relations | REMARK |
|
|
| Format | VARCHAR2(72) |
| Description | One line of text to record information about a station. |
| Units | - |
| Values | Any string |
| Relations | SITE_INFO |
|
|
| Format | NUMBER(8) |
| Description | Remark identification number. Together with lineno, primary key on the remark table. In other tables, external key to the remark table. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | AFFILIATION AMPDESCRIPT ASSOCIATION BIBLIOGRAPHY BIBLIO_AUTHOR BIBLIO_EVENT EVENT FAULT_PLANES HYPOC_ERR HYPOCENTER INTENSITY MACROSEISMIC MOMENT_TENSOR MOMENT_TENSOR_ERR NETMAG PHASE PRINCIPAL_AXES PUB_COMMENTS REMARK SCALAR_MOMENT SITE SITE_ALT_NAMES SITE_OUTAGE SITE_SORT STAMAG UNASSOC_COMMENTS |
|
|
| Format | NUMBER(8) |
| Description | ID number of a report received at the ISC. Primary key on the report table. This is the same ID number that is recorded in the REPORTER field of many other relations. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | REPORT |
|
|
| Format | VARCHAR2(1) |
| Description | Indicates whether a report can be replaced. Typically where a preliminary report would be followed at some later time by a definitive data set. |
| Units | |
| Values | 'R' or NULL |
| Relations | REPORT |
|
|
| Format | NUMBER(8) |
| Description | Number of a data report received at the ISC. |
| Units | - |
| Values | 1 to 99999999 |
| Relations | AFFILIATION AMPDESCRIPT ASSOCIATION BIBLIOGRAPHY BIBLIO_AUTHOR BIBLIO_EVENT EVENT FAULT_PLANES HYPOC_ERR HYPOCENTER INTENSITY MACROSEISMIC MOMENT_TENSOR MOMENT_TENSOR_ERR NETMAG PHASE PRINCIPAL_AXES PUB_COMMENTS SCALAR_MOMENT SITE SITE_ALT_NAMES SITE_OUTAGE SITE_SORT STAMAG UNASSOC_COMMENTS |
|
|
| Format | VARCHAR2(8) |
| Description | Code of the agency that sent a report. |
| Units | - |
| Values | From the ISC/WDC agency list |
| Relations | REPORT |
|
|
| Format | VARCHAR2(24) |
| Description | Reporting agency's description of a report. This will be taken, where possible, from the subject line of the e-mail message including the report or from the header of the report itself. |
| Units | - |
| Values | Any character string |
| Relations | REPORT |
|
|
| Format | NUMBER(6,3) |
| Description | Standard error of depth. In reported hypocenters, any depth reported uncertainty is saved in this attribute. |
| Units | Kilometres |
| Values | 0 to 999.999, or NULL. NULL in ISC hypocenters with fixed depth. NULL in hypocenter depths without an uncertainty, which are not necessarily fixed. |
| Relations | HYPOC_ERR |
|
|
| Format | NUMBER(8,4) |
| Description | Standard deviation of the observations. From hypocenters computed only from arrival time, standard deviation of travel time residuals. ISC records summary statistics reported in bulletins but does not compute them from reported times. |
| Units | Seconds |
| Values | 0 to 9999.9999 |
| Relations | HYPOC_ERR |
|
|
| Format | NUMBER(6,3) |
| Description | Station to event azimuth. For reported associations, ISC records reported SEAZ but does not compute SEAZ from reported locations. For ISC associations, SEAZ is computed from geocentric latitude and longitude. That is, a correction for the earth's ellipticity is applied before computing SEAZ. |
| Units | Degrees, clockwise from north |
| Values | 0 to 359.999 |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(9,2) |
| Description | Measured slowness, uncorrected. |
| Units | Seconds / Degree |
| Values | 0 to 1000 |
| Relations | PHASE |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if measured slowness of phase phid was used in computing hypocenter hypid. |
| Units | - |
| Values | 'S' or NULL |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(6,3) |
| Description | Slowness residual, i.e., measured slowness minus slowness expected for the station and hypocenter locations, from the velocity model used to compute the hypocenter. |
| Units | Seconds / Degree |
| Values | -999.999 to +999.999 |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(8,4) |
| Description |
Lengths of the semi-major and semi-minor axes of the
epicentre uncertainty ellipse. For reported and ISC locations
reported with latitude and longitude uncertainties, the larger
and smaller of these two uncertainties. For hypocentres reported with only a single horizontal error, the (presumably maximum) horizontal error is stored as SMAJAX, while SMINAX and STRIKE are null. |
| Units | Kilometres |
| Values | 0 to 9999.9999 |
| Relations | HYPOC_ERR |
|
|
| Format | VARCHAR2(30) |
| Description | Model or method used for the calculation of the scalar moment. |
| Units | - |
| Values | 3 component best double couple double couple surface spectra |
| Relations | SCALAR_MOMENT |
|
|
| Format | VARCHAR2(1) |
| Description | Short period first motion. The first character of any "short-period" first motion indication reported to the ISC is stored in the database, except that encoding of long period and short period first motion into a single character in "telegraphic format" is interpreted. |
| Units | - |
| Values |
'c', 'C', '+' usually indicate compression (up or away from the event) 'd', 'D', '-' usually indicate dilation (down or towards the event) |
| Relations | PHASE |
|
|
| Format | NUMBER(4) |
| Description | Seismic Region Number: one of the fifty large regions outlined in Flinn and Engdahl, 1965. On the hypocenter table, each committed insert or update of lat or lon triggers a stored procedure to set SRN. |
| Units | - |
| Values | 1 to 50 |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(6) |
| Description | Station code |
| Units | - |
| Values | Codes from the station list maintained jointly by ISC and WDC-A for Seismology. Thus, restricted to strings of an upper case letter followed by upper case letters, digits, and '*' |
| Relations | AFFILIATION ASSOCIATION PHASE SITE SITE_ALT_NAMES SITE_INFO SITE_OUTAGE SITE_SORT |
|
|
| Format | NUMBER(8) |
| Description | The number of distinct stations in a report |
| Units | - |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The maximum latitude of any station in a report. STA_MIN_LAT, STA_MAX_LAT, STA_MIN_LON and STA_MAX_LON can be used to indicate the region over which stations are used by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The maximum longitude of any station in a report. STA_MIN_LAT, STA_MAX_LAT, STA_MIN_LON and STA_MAX_LON can be used to indicate the region over which stations are used by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The minimum latitude of any station in a report. STA_MIN_LAT, STA_MAX_LAT, STA_MIN_LON and STA_MAX_LON can be used to indicate the region over which stations are used by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | NUMBER(8,5) |
| Description | The minimum longitude of any station in a report. STA_MIN_LAT, STA_MAX_LAT, STA_MIN_LON and STA_MAX_LON can be used to indicate the region over which stations are used by each agency. |
| Units | Degrees |
| Values | - |
| Relations | REPORT |
|
|
| Format | VARCHAR2(80) |
| Description | Descriptive name of a station location, often the name of a town or city near or around the station. A hierarchy of location, 'city, province, country', is never used. Instead, name of broader geographic divisions stored in the REGION attribute. |
| Units | - |
| Values | Any string of mixed-case letters, digits and punctuation. |
| Relations | SITE |
|
|
| Format | NUMBER(4) |
| Description | Collection status of a report received at the ISC. A value of -99 or -9 means that a row of the report relation is marked for deletion and should be ignored. A value of 98 means that a row was entered into the relation for a report already held by the ISC - i.e. the LDDATE will not correspond to the date that the report was received. Other values are those returned by the software responsible for filing incoming e-mails. The meaning of these numbers will depend on the checker used by capture for the report but in general indicate the successful filing of an e-mail as file FILENAME in directory DIRNAME. |
| Units | - |
| Values | 1 to 9999 |
| Relations | REPORT |
|
|
| Format | VARCHAR2(8) |
| Description | Station type |
| Units | - |
| Values |
'1 site': single site '3 comp': three-component '1 comp': one-component 'nn array': array of |
| Relations | SITE |
|
|
| Format | NUMBER(6,3) |
| Description | For reported hypocenters, reported origin time uncertainty or NULL if not reported. For ISC hypocenters, standard deviation of the origin time or NULL if time was fixed in the inversion. |
| Units | seconds |
| Values | 0 to 1000 |
| Relations | HYPOC_ERR |
|
|
| Format | NUMBER(4,1) |
| Description |
Strike of the semi-major axis of the epicentre uncertainty
ellipse. For ISC hypocenters with latitude and longitude
uncertainty, 0 if latitude uncertainty is larger and 90 if
longitude uncertainty (corrected for latitude) is larger. For
data if the strike is -1 then the SMAJAX is standard error of
latitude and SMINAX of longitude. For hypocentres reported with only a single horizontal error, the (presumably maximum) horizontal error is stored as SMAJAX, while SMINAX and STRIKE are null. |
| Units | - |
| Values | 0 to 180 |
| Relations | HYPOC_ERR |
|
|
| Format | NUMBER(8,5) |
| Description | Strike of either nodal plane, specified by FAULT. |
| Units | Degrees |
| Values | 0 to 360 |
| Relations | FAULT_PLANES |
|
|
| Format | NUMBER(12,4) |
| Description | Components of the covariance matrix from a hypocenter inversion |
| Units |
Seconds2 (STT) Kilometre-seconds (STX, STY, STZ) Kilomtres2 (SXX, SXY, SYY, SYZ, SZX, SZZ) |
| Values | 0 to 99999999.9999 |
| Relations | HYPOC_ERR |
|
|
| Format | NUMBER(12,4) |
| Description | Azimuth or strike of one eigenvector of the principal axis system. |
| Units | degrees |
| Values | 0 to 360 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(12,4) |
| Description | Plunge of one eigenvector of the principal axis system. |
| Units | degrees |
| Values | 0 to 360 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(12,4) |
| Description | Eigenvalue of one eigenvector of the principal axis system for the moment tensor. |
| Units | |
| Values | 0 to 99999999.9999 |
| Relations | PRINCIPAL_AXES |
|
|
| Format | NUMBER(8,5) |
| Description | Uncertainty of the value of azimuth (strike) of one eigenvector, T, B or P of the principal axis system for the moment tensor. |
| Units | |
| Values | 0 to 9999.9999 |
| Relations | MOMENT_TENSOR_ERR |
|
|
| Format | NUMBER(8,5) |
| Description | Uncertainty of the value of plunge of one eigenvector, T, B or P of the principal axis system for the moment tensor. |
| Units | |
| Values | 0 to 9999.9999 |
| Relations | MOMENT_TENSOR_ERR |
|
|
| Format | NUMBER(8,5) |
| Description | Uncertainty of the eigenvalue of one eigenvector, T, B or P of the principal axis system for the moment tensor. |
| Units | |
| Values | 0 to 9999.9999 |
| Relations | MOMENT_TENSOR_ERR |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if time of an associated phase is defining in computation of a hypocenter. For reported hypocenters, may be presumed true if not clearly stated in a report to the ISC. For ISC hypocenters, normally set based on phase code during hypocentral relocation. Thus, may be out of date following editing if a phase is renamed. |
| Units | - |
| Values | 'T' or NULL |
| Relations | ASSOCIATION |
|
|
| Format | NUMBER(6,3) |
| Description | Travel-time residual: observed arrival time - arrival time expected from hypocenter, origin time and velocity model. Thus, negative for earlier than expected observed arrival times. |
| Units | seconds |
| Values | -999.999 to +999.999 |
| Relations | ASSOCIATION |
|
|
| Format | VARCHAR2(1) |
| Description | Flag, set if origin time of a hypocenter is fixed. For ISC hypocenters the flag may be set by seismologist editing, in which case the depth will be fixed in subsequent re-computations of the hypocenter. In addition, the flag may be set by the location algorithm to a reported origin time if it fails to converge with a free origin time. |
| Units | - |
| Values | 'F' or NULL |
| Relations | HYPOCENTER |
|
|
| Format | VARCHAR2(8) |
| Description | Type of information in this row of the site_info table |
| Units | - |
| Values | '???' |
| Relations | SITE_INFO |
|
|
| Format | VARCHAR2(6) |
| Description | Type of moment tensor calculation either 'FM' (first motion) or 'BDC' (best double-couple) |
| Units | - |
| Values | BDC, FM |
| Relations | FAULT_PLANES |
|
|
| Format | NUMBER(4,2) |
| Description | Uncertainty of the magnitude. For magnitudes reported to ISC, the reported uncertainty is stored in the ISC database, or NULL is stored for magnitudes reported with no uncertainty. For ISC-computed network magnitudes, delmag is the standard deviation of the associated station magnitudes divided by the square root of the number of station magnitudes. For ISC-computed station magnitudes, delmag is null. |
| Units | - |
| Values | ?10 to ?10 |
| Relations | NETMAG STAMAG |
|
|
| Format | VARCHAR2(40) |
| Description | Identifier for an ISF #PARAM or #MEASURE comment. |
| Units | none |
| Values | The units in which the variable is stored in the phase_misc or hypocenter_misc table and in which the variable is written in ISC #MEASURE and #PARAM comments. |
| Relations | MISC_DATATYPES |
|
|
| Format | VARCHAR2(40) |
| Description | The value of the data type for PHASE_MISC and HYPOCENTER_MISC |
| Units | Any |
| Values | Any |
| Relations | HYPOCENTER_MISC PHASE_MISC |
|
|
| Format | |
| Description | A name for the velocity model used to compute a hypocenter. The ISC does not require an indication of the velocity model in every report, but may assign a velocity model to all reports from a given source within a given time period based on other information from the reporting agency. On the hypocenter table, a trigger on insert runs a stored procedure to assign velo_model for certain authors. |
| Units | - |
| Values |
NULL = reported hypocenter where ISC is uncertain of model used. 'JB' = Jeffreys-Bullen [1938] 'iasp91' = Kennett [1991] 'ak135' = |
| Relations | HYPOCENTER |
|
|
| Format | NUMBER(4,3) |
| Description | Posterior weight of the associated arrival time used in computing the hypocenter. A real number giving the relative weight, possibly reduced in an iterative scheme for times with large residuals. Not a subjective measure of quality. The ISC records only weights reported for individual associations; it does not compute weights from procedures even if they are described to the ISC. |
| Units | - |
| Values | NULL (for many reported associations) or 0.000 to 1.000 |
| Relations | ASSOCIATION |