mecid

Base Entity | mec
Attribute Name | mecid
Logical Rolename |
ColumnName | mecid
RoleName |
Definition | Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database
Note |
    Range:            mecid > 0

oridin

Base Entity | mec
Attribute Name | orid
Logical Rolename | oridin
ColumnName | oridin
RoleName | oridin
Definition | Input origin. This attribute holds the origin identifier, orid, that points to the origin from which the mechanism was computed
Note |
    Range:             oridin > 0

oridout

Base Entity | mec
Attribute Name | orid
Logical Rolename | oridout
ColumnName | oridout
RoleName | oridout
Definition | Output origin. This attribute holds the origin identifier, orid, that points to the origin computed from the mechanism
Note |
    Range:             oridout > 0

magid

Base Entity | mec
Attribute Name | magid
Logical Rolename |
ColumnName | magid
RoleName |
Definition | Magnitude identifier. This key is used to identify a magnitude in the Netmag relation. It is required for every magnitude
Note |
    Range:             magid > 0

commid

Base Entity | mec
Attribute Name | commid
Logical Rolename |
ColumnName | commid
RoleName |
Definition | Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database
Note |
    Range:             commid > 0

mechtype

Base Entity | mec
Attribute Name | mechtype
Logical Rolename |
ColumnName | mechtype
RoleName |
Definition | Mechanism type
Note |
    Range:		mechtype = {FP | MT}
    		FP = Fault plane solution
    		MT = Moment tensor

mecalgo

Base Entity | mec
Attribute Name | mecalgo
Logical Rolename |
ColumnName | mecalgo
RoleName |
Definition | This attribute represents the algorithm used to compute the mechanism (TDMT,TMTS=Dreger's code; FPFIT=fpfit; SMTINV=Pasyanos code)
Note |
    Range:             Any free-format string up to 15 characters

scalar

Base Entity | mec
Attribute Name | scalar
Logical Rolename |
ColumnName | scalar
RoleName |
Definition | Seismic scalar moment (no value stored for fpfit)
Note |
    Range:		-10^32 < scalar < 10^32

    Units:		Dyne centimeters

erscalar

Base Entity | mec
Attribute Name | erscalar
Logical Rolename |
ColumnName | erscalar
RoleName |
Definition | Error in scalar moment. This is the standard deviation of the scalar moment
Note |
    Range:		erscalar >= 0.0

    Units:		Dyne centimeters

tft

Base Entity | mec
Attribute Name | tft
Logical Rolename |
ColumnName | tft
RoleName |
Definition | Type of source time function. Used to specify if time function and source half-duration are assumed, derived, or determined
Note |
    Range:            Any free-format string up to 8 characters

tfd

Base Entity | mec
Attribute Name | tfd
Logical Rolename |
ColumnName | tfd
RoleName |
Definition | Duration of the source time function
Note |
    Range:            tfd > 0.0

    Units:              Seconds

mxx

Base Entity | mec
Attribute Name | mxx
Logical Rolename |
ColumnName | mxx
RoleName |
Definition | Moment tensor elements. Given in Aki convention
Note |
    Range:		-10^32 < mxx < 10^32

    Units:		Dyne centimeters

myy

Base Entity | mec
Attribute Name | myy
Logical Rolename |
ColumnName | myy
RoleName |
Definition | Moment tensor elements. Given in Aki convention
Note |
    Range:		-10^32 < myy < 10^32

    Units:		Dyne centimeters

mzz

Base Entity | mec
Attribute Name | mzz
Logical Rolename |
ColumnName | mzz
RoleName |
Definition | Moment tensor elements. Given in Aki convention
Note |
    Range:		-10^32 < mzz < 10^32

    Units:		Dyne centimeters

mxy

Base Entity | mec
Attribute Name | mxy
Logical Rolename |
ColumnName | mxy
RoleName |
Definition | Moment tensor elements. Given in Aki convention
Note |
    Range:		-10^32 < mxy < 10^32

    Units:		Dyne centimeters

mxz

Base Entity | mec
Attribute Name | mxz
Logical Rolename |
ColumnName | mxz
RoleName |
Definition | Moment tensor elements. Given in Aki convention
Note |
    Range:		-10^32 < mxz < 10^32

    Units:		Dyne centimeters

myz

Base Entity | mec
Attribute Name | myz
Logical Rolename |
ColumnName | myz
RoleName |
Definition | Moment tensor elements. Given in Aki convention
Note |
    Range:		-10^32 < myz < 10^32

    Units:		Dyne centimeters

smxx

Base Entity | mec
Attribute Name | smxx
Logical Rolename |
ColumnName | smxx
RoleName |
Definition | Uncertainties in moment tensor elements
Note |
    Range:		-10^32 < smxx < 10^32

    Units:		Dyne centimeters

smyy

Base Entity | mec
Attribute Name | smyy
Logical Rolename |
ColumnName | smyy
RoleName |
Definition | Uncertainties in moment tensor elements
Note |
    Range:		-10^32 < smyy < 10^32

    Units:		Dyne centimeters

smzz

Base Entity | mec
Attribute Name | smzz
Logical Rolename |
ColumnName | smzz
RoleName |
Definition | Uncertainties in moment tensor elements
Note |
    Range:		-10^32 < smzz < 10^32

    Units:		Dyne centimeters

smxy

Base Entity | mec
Attribute Name | smxy
Logical Rolename |
ColumnName | smxy
RoleName |
Definition | Uncertainties in moment tensor elements
Note |
    Range:		-10^32 < smxy < 10^32

    Units:		Dyne centimeters

smxz

Base Entity | mec
Attribute Name | smxz
Logical Rolename |
ColumnName | smxz
RoleName |
Definition | Uncertainties in moment tensor elements
Note |
    Range:		-10^32 < smxz < 10^32

    Units:		Dyne centimeters

smyz

Base Entity | mec
Attribute Name | smyz
Logical Rolename |
ColumnName | smyz
RoleName |
Definition | Uncertainties in moment tensor elements
Note |
    Range:		-10^32 < smyz < 10^32

    Units:		Dyne centimeters

srcduration

Base Entity | mec
Attribute Name | srcduration
Logical Rolename |
ColumnName | srcduration
RoleName |
Definition | Source half-duration
Note |
    Range:		0.0 < srcduration < 100.0

    Units:		Seconds

auth

Base Entity | mec
Attribute Name | auth
Logical Rolename |
ColumnName | auth
RoleName |
Definition | The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record
Note |
    Range:            Any free-format string up to 15 characters

subsource

Base Entity | mec
Attribute Name | subsource
Logical Rolename |
ColumnName | subsource
RoleName |
Definition | A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE
Note |
    Range:             Any free-format string up to 8 characters

strike1

Base Entity | mec
Attribute Name | strike1
Logical Rolename |
ColumnName | strike1
RoleName |
Definition | Strike of fault plane 1 from the best double couple
Note |
    Range:		0 <= strike1 <= 360

    Units:		Degrees

dip1

Base Entity | mec
Attribute Name | dip1
Logical Rolename |
ColumnName | dip1
RoleName |
Definition | Dip of fault plane 1 from the best double couple
Note |
    Range:		-90 <= dip1 <= 90

    Units:		Degrees

rake1

Base Entity | mec
Attribute Name | rake1
Logical Rolename |
ColumnName | rake1
RoleName |
Definition | Rake of fault plane 1 from the best double couple solution
Note |
    Range:		-180 <= rake1 <= 180

    Units:		Degrees

strike2

Base Entity | mec
Attribute Name | strike2
Logical Rolename |
ColumnName | strike2
RoleName |
Definition | Strike of fault plane 2 from the best double couple
Note |
    Range:		0 <= strike2 <= 360

    Units:		Degrees

dip2

Base Entity | mec
Attribute Name | dip2
Logical Rolename |
ColumnName | dip2
RoleName |
Definition | Dip of fault plane 2 from the best double couple
Note |
    Range:		-90 <= dip2 <= 90

    Units:		Degrees

rake2

Base Entity | mec
Attribute Name | rake2
Logical Rolename |
ColumnName | rake2
RoleName |
Definition | Rake of fault plane 2 from the best double couple solution
Note |
    Range:		-180 <= rake2 <= 180

    Units:		Degrees

unstrike1

Base Entity | mec
Attribute Name | unstrike1
Logical Rolename |
ColumnName | unstrike1
RoleName |
Definition | Uncertainty in strike 1
Note |
    Range:		-180.0 <= unstrike1 <= 180.0

    Units:		Degrees

undip1

Base Entity | mec
Attribute Name | undip1
Logical Rolename |
ColumnName | undip1
RoleName |
Definition | Uncertainty in dip 1
Note |
    Range:		-180.0 <= undip1 <= 180.0

    Units:		Degrees

unrake1

Base Entity | mec
Attribute Name | unrake1
Logical Rolename |
ColumnName | unrake1
RoleName |
Definition | Uncertainty in rake 1
Note |
    Range:		-180.0 <= unrake1 <= 180.0

    Units:		Degrees

unstrike2

Base Entity | mec
Attribute Name | unstrike2
Logical Rolename |
ColumnName | unstrike2
RoleName |
Definition | Uncertainty in strike 2
Note |
    Range:		-180.0 <= unstrike2 <= 180.0

    Units:		Degrees

undip2

Base Entity | mec
Attribute Name | undip2
Logical Rolename |
ColumnName | undip2
RoleName |
Definition | Uncertainty in dip 2
Note |
    Range:		-180.0 <= undip2 <= 180.0

    Units:		Degrees

unrake2

Base Entity | mec
Attribute Name | unrake2
Logical Rolename |
ColumnName | unrake2
RoleName |
Definition | Uncertainty in rake 2
Note |
    Range:		-180.0 <= unrake2 <= 180.0

    Units:		Degrees

eigenp

Base Entity | mec
Attribute Name | eigenp
Logical Rolename |
ColumnName | eigenp
RoleName |
Definition | Eigen value of compressional axis in the principal axes representation of the best double couple
Note |

plungep

Base Entity | mec
Attribute Name | plungep
Logical Rolename |
ColumnName | plungep
RoleName |
Definition | Plunge of the compressional axis in the principal axes representation of the best double couple
Note |
    Range:		0 <= plungep <= 90

    Units:		Degrees

strikep

Base Entity | mec
Attribute Name | strikep
Logical Rolename |
ColumnName | strikep
RoleName |
Definition | Strike of compressional axis in the principal axes representation of the best double couple
Note |
    Range:		0 <= strikep <= 360

    Units:		Degrees

eigenn

Base Entity | mec
Attribute Name | eigenn
Logical Rolename |
ColumnName | eigenn
RoleName |
Definition | Eigen value of null axis in the principal axes representation of the best double couple
Note |

plungen

Base Entity | mec
Attribute Name | plungen
Logical Rolename |
ColumnName | plungen
RoleName |
Definition | Plunge of the null axis in the principal axes representation of the best double couple
Note |
    Range:		0 <= plungen <= 90

    Units:		Degrees

striken

Base Entity | mec
Attribute Name | striken
Logical Rolename |
ColumnName | striken
RoleName |
Definition | Strike of null axis in the principal axes representation of the best double couple
Note |
    Range:		0 <= striken <= 360

    Units:		Degrees

eigent

Base Entity | mec
Attribute Name | eigent
Logical Rolename |
ColumnName | eigent
RoleName |
Definition | Eigen value of tension axis in the principal axes representation of the best double couple
Note |

plunget

Base Entity | mec
Attribute Name | plunget
Logical Rolename |
ColumnName | plunget
RoleName |
Definition | Plunge of the tension axis in the principal axes representation of the best double couple
Note |
    Range:		0 <= plunget <= 90

    Units:		Degrees

striket

Base Entity | mec
Attribute Name | striket
Logical Rolename |
ColumnName | striket
RoleName |
Definition | Strike of tension axis in the principal axes representation of the best double couple
Note |
    Range:		0 <= striket <= 360

    Units:		Degrees

nsta

Base Entity | mec
Attribute Name | nsta
Logical Rolename |
ColumnName | nsta
RoleName |
Definition | This quantity is the number of observations with non-zero input weights used to compute the mechanism. For CW=nsta, for FPFIT=nPobs, for HASH=nobs
Note |
    Range:             nsta > 0

pvr

Base Entity | mec
Attribute Name | pvr
Logical Rolename |
ColumnName | pvr
RoleName |
Definition | Goodness of fit. For TDMT this is percent variance reduction; for FPFIT this is (1-misfit)*100
Note |
    Range:             0.0 <= pvr <= 100.0

quality

Base Entity | mec
Attribute Name | quality
Logical Rolename |
ColumnName | quality
RoleName |
Definition | This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad
Note |
    Range:             0.0 <= quality <= 1.0

pdc

Base Entity | mec
Attribute Name | pdc
Logical Rolename |
ColumnName | pdc
RoleName |
Definition | Percent double couple of the seismic moment tensor
Note |
    Range:             0 <= pdc <= 100

pclvd

Base Entity | mec
Attribute Name | pclvd
Logical Rolename |
ColumnName | pclvd
RoleName |
Definition | Percent compensated linear vector dipole of the seismic moment tensor
Note |
    Range:             0 <= pclvd <= 100

piso

Base Entity | mec
Attribute Name | piso
Logical Rolename |
ColumnName | piso
RoleName |
Definition | Percent isotropic of the seismic moment tensor. If the solution is constrained to have zero trace (no "ISO"), then "ISO" should be NULL, as opposed to a case where the full moment tensor was used, and the ISO component ended up being very small ("0")
Note |
    Range:             0 <= piso <= 100

datetime

Base Entity | mec
Attribute Name | datetime
Logical Rolename |
ColumnName | datetime
RoleName |
Definition | The date of associated with information in the record, in true epoch format
Note |
    Range:		Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000

    Units:		Seconds

rflag

Base Entity | mec
Attribute Name | rflag
Logical Rolename |
ColumnName | rflag
RoleName |
Definition | This flag describes whether an observation was generated automatically, by a human, or has been finalized
Note |
    Range:		rflag = {A | H | F}
    		A = automatic
    		H = reviewed by human
    		F = finalized

lddate

Base Entity | mec
Attribute Name | lddate
Logical Rolename |
ColumnName | lddate
RoleName |
Definition | Load date. Date and time that the record was created, in Oracle date datatype
Note |
    Range:		Any valid date between January 01, 4712 BC and January 01, 4712 AD

    Units:		 YYYY/MM/DD HH24:MI:SS