mecid

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

oridin

Base Object | mec
Attribute Name | orid
ColumnName | oridin
Logical Rolename |
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 Object | mec
Attribute Name | orid
ColumnName | oridout
Logical Rolename |
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 Object | mec
Attribute Name | magid
ColumnName | magid
Logical Rolename |
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 Object | mec
Attribute Name | commid
ColumnName | commid
Logical Rolename |
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 Object | mec
Attribute Name | mechtype
ColumnName | mechtype
Logical Rolename |
RoleName |
Definition | Mechanism type
Note |
    Range:		mechtype = {FP | MT}
    		FP = Fault plane solution
    		MT = Moment tensor

mecalgo

Base Object | mec
Attribute Name | mecalgo
ColumnName | mecalgo
Logical Rolename |
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 Object | mec
Attribute Name | scalar
ColumnName | scalar
Logical Rolename |
RoleName |
Definition | Seismic scalar moment (no value stored for fpfit)
Note |
    Range:		-10^32 < scalar < 10^32

    Units:		Dyne centimeters

erscalar

Base Object | mec
Attribute Name | erscalar
ColumnName | erscalar
Logical Rolename |
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 Object | mec
Attribute Name | tft
ColumnName | tft
Logical Rolename |
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 Object | mec
Attribute Name | tfd
ColumnName | tfd
Logical Rolename |
RoleName |
Definition | Duration of the source time function
Note |
    Range:            tfd > 0.0

    Units:              Seconds

mxx

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

    Units:		Dyne centimeters

myy

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

    Units:		Dyne centimeters

mzz

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

    Units:		Dyne centimeters

mxy

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

    Units:		Dyne centimeters

mxz

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

    Units:		Dyne centimeters

myz

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

    Units:		Dyne centimeters

smxx

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

    Units:		Dyne centimeters

smyy

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

    Units:		Dyne centimeters

smzz

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

    Units:		Dyne centimeters

smxy

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

    Units:		Dyne centimeters

smxz

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

    Units:		Dyne centimeters

smyz

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

    Units:		Dyne centimeters

srcduration

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

    Units:		Seconds

auth

Base Object | mec
Attribute Name | auth
ColumnName | auth
Logical Rolename |
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 Object | mec
Attribute Name | subsource
ColumnName | subsource
Logical Rolename |
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 Object | mec
Attribute Name | strike1
ColumnName | strike1
Logical Rolename |
RoleName |
Definition | Strike of fault plane 1 from the best double couple
Note |
    Range:		0 <= strike1 <= 360

    Units:		Degrees

dip1

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

    Units:		Degrees

rake1

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

    Units:		Degrees

strike2

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

    Units:		Degrees

dip2

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

    Units:		Degrees

rake2

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

    Units:		Degrees

unstrike1

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

    Units:		Degrees

undip1

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

    Units:		Degrees

unrake1

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

    Units:		Degrees

unstrike2

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

    Units:		Degrees

undip2

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

    Units:		Degrees

unrake2

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

    Units:		Degrees

eigenp

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

plungep

Base Object | mec
Attribute Name | plungep
ColumnName | plungep
Logical Rolename |
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 Object | mec
Attribute Name | strikep
ColumnName | strikep
Logical Rolename |
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 Object | mec
Attribute Name | eigenn
ColumnName | eigenn
Logical Rolename |
RoleName |
Definition | Eigen value of null axis in the principal axes representation of the best double couple
Note |

plungen

Base Object | mec
Attribute Name | plungen
ColumnName | plungen
Logical Rolename |
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 Object | mec
Attribute Name | striken
ColumnName | striken
Logical Rolename |
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 Object | mec
Attribute Name | eigent
ColumnName | eigent
Logical Rolename |
RoleName |
Definition | Eigen value of tension axis in the principal axes representation of the best double couple
Note |

plunget

Base Object | mec
Attribute Name | plunget
ColumnName | plunget
Logical Rolename |
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 Object | mec
Attribute Name | striket
ColumnName | striket
Logical Rolename |
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 Object | mec
Attribute Name | nsta
ColumnName | nsta
Logical Rolename |
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 Object | mec
Attribute Name | pvr
ColumnName | pvr
Logical Rolename |
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 Object | mec
Attribute Name | quality
ColumnName | quality
Logical Rolename |
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 Object | mec
Attribute Name | pdc
ColumnName | pdc
Logical Rolename |
RoleName |
Definition | Percent double couple of the seismic moment tensor
Note |
    Range:             0 <= pdc <= 100

pclvd

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

piso

Base Object | mec
Attribute Name | piso
ColumnName | piso
Logical Rolename |
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 Object | mec
Attribute Name | datetime
ColumnName | datetime
Logical Rolename |
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 Object | mec
Attribute Name | rflag
ColumnName | rflag
Logical Rolename |
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 Object | mec
Attribute Name | lddate
ColumnName | lddate
Logical Rolename |
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