orid

Base Entity | origin
Attribute Name | orid
Logical Rolename |
ColumnName | orid
RoleName |
Definition | Origin identification. Each origin is assigned a unique positive integer which identifies it in the database. The orid is used to identify one of the many hypotheses of the actual location of the event
Note |
    Range:             orid > 0

evid

Base Entity | origin
Attribute Name | evid
Logical Rolename |
ColumnName | evid
RoleName |
Definition | Event identifier. Each event is assigned a unique integer which identifies it in a database. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network’s event identifier, which is stored in the Origin table. This allows merging data for a single event from multiple sources without insisting that database evid is identical to the source’s local event identifier
Note |
    Range:	            evid > 0

prefmag

Base Entity | origin
Attribute Name | magid
Logical Rolename | prefmag
ColumnName | prefmag
RoleName | prefmag
Definition | Preferred magnitude. This attribute holds the magnitude identifier, magid, that points to the preferred magnitude for a seismic event or an origin
Note |
    Range:             prefmag > 0

prefmec

Base Entity | origin
Attribute Name | mecid
Logical Rolename | prefmec
ColumnName | prefmec
RoleName | prefmec
Definition | Preferred mechanism. This attribute holds the mechanism identifier, mecid, that points to the preferred mechanism for a seismic event or an origin
Note |
    Range:             prefmec > 0

commid

Base Entity | origin
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

bogusflag

Base Entity | origin
Attribute Name | bogusflag
Logical Rolename |
ColumnName | bogusflag
RoleName |
Definition | This field describes whether an origin is bogus or not
Note |
    Range:		bogusflag = {0 | 1}
    		0 = no
    		1 = yes

datetime

Base Entity | origin
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

lat

Base Entity | origin
Attribute Name | lat
Logical Rolename |
ColumnName | lat
RoleName |
Definition | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
Note |
    Range:		-90.0 <= lat <= 90.0

    Units:		Degrees

lon

Base Entity | origin
Attribute Name | lon
Logical Rolename |
ColumnName | lon
RoleName |
Definition | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
Note |
    Range:		-180.0 <= lon <= 180.0

    Units:		Degrees

depth

Base Entity | origin
Attribute Name | depth
Logical Rolename |
ColumnName | depth
RoleName |
Definition | Distance in KM of the earthquake source below the geoid. Hypoinverse model types E, L or V are always geoid depths
Note |
    Range:		-10.0 <= depth <= 1000.0

    Units:		Kilometers

mdepth

Base Entity | origin
Attribute Name | mdepth
Logical Rolename |
ColumnName | mdepth
RoleName |
Definition | Distance in KM of the earthquake source below the model surface. For model depths, all the recording stations are located at the top of the model and their elevations are not used. Model types T or H if uncorrected by depth datum are always model depths
Note |
    Range:		-10.0 <= mdepth <= 1000.0

    Units:		Kilometers

type

Base Entity | origin
Attribute Name | type
Logical Rolename |
ColumnName | type
RoleName |
Definition | Type of location
Note |
    Range:		type = {H | C | A | D | U}
    		H = hypocenter
    		C = centroid
    		A = amplitude
    		D = double difference
    		U = unknown

algorithm

Base Entity | origin
Attribute Name | algorithm
Logical Rolename |
ColumnName | algorithm
RoleName |
Definition | Algorithm used. This is a brief textual description of the algorithm used to compute a seismic origin
Note |
    Range:             Any free-format string up to 15 characters

algo_assoc

Base Entity | origin
Attribute Name | algo_assoc
Logical Rolename |
ColumnName | algo_assoc
RoleName |
Definition | Association algorithm used. This is a textual description of the algorithm used for associating the data
Note |
    Range:             Any free-format string up to 80 characters

auth

Base Entity | origin
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 | origin
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

datumhor

Base Entity | origin
Attribute Name | datumhor
Logical Rolename |
ColumnName | datumhor
RoleName |
Definition | Datum type for horizontal (latitude and longitude) coordinates
Note |
    Range:             datumhor = { NAD27 | WGS84}

datumver

Base Entity | origin
Attribute Name | datumver
Logical Rolename |
ColumnName | datumver
RoleName |
Definition | Datum type for depth or elevation
Note |
    Range:             datumver = { NAD27 | WGS84 | AVERAGE}
                            AVERAGE = average of stations

gap

Base Entity | origin
Attribute Name | gap
Logical Rolename |
ColumnName | gap
RoleName |
Definition | Gap in azimuthal coverage
Note |
    Range:		0.0 <= gap <= 360.0

    Units:		Degrees

distance

Base Entity | origin
Attribute Name | distance
Logical Rolename |
ColumnName | distance
RoleName |
Definition | Distance from the origin to the nearest station
Note |
    Range:		distance >= 0.0

    Units:		Kilometers

wrms

Base Entity | origin
Attribute Name | wrms
Logical Rolename |
ColumnName | wrms
RoleName |
Definition | This attribute denotes the weighted RMS
Note |
    Range:             wrms > 0.0

stime

Base Entity | origin
Attribute Name | stime
Logical Rolename |
ColumnName | stime
RoleName |
Definition | Origin time error. This attribute denotes the standard deviation of the origin time
Note |
    Range:		stime >= 0.0

    Units:		Seconds

erhor

Base Entity | origin
Attribute Name | erhor
Logical Rolename |
ColumnName | erhor
RoleName |
Definition | Horizontal error. This attribute denotes the location uncertainty that accompanies the location
Note |
    Range:		erhor >= 0.0

    Units:		Kilometers

sdep

Base Entity | origin
Attribute Name | sdep
Logical Rolename |
ColumnName | sdep
RoleName |
Definition | Depth error. This is the standard deviation of the depth estimate
Note |
    Range:		sdep >= 0.0

    Units:		Kilometers

erlat

Base Entity | origin
Attribute Name | erlat
Logical Rolename |
ColumnName | erlat
RoleName |
Definition | Error in latitude. This is the standard deviation of the latitude estimate
Note |
    Range:		erlat >= 0.0

    Units:		Kilometers

erlon

Base Entity | origin
Attribute Name | erlon
Logical Rolename |
ColumnName | erlon
RoleName |
Definition | Error in longitude. This is the standard deviation of the longitude estimate
Note |
    Range:		erlon >= 0.0

    Units:		Kilometers

totalarr

Base Entity | origin
Attribute Name | totalarr
Logical Rolename |
ColumnName | totalarr
RoleName |
Definition | Total number of phases in the database for the specified orid. This field signifies the number of P and S arrivals with non-zero input weights
Note |
    Range:             totalarr >= 0

totalamp

Base Entity | origin
Attribute Name | totalamp
Logical Rolename |
ColumnName | totalamp
RoleName |
Definition | Total number of amplitudes in the database for the specified orid. Not all amplitudes have to associated with all magnitudes or origins
Note |
    Range:             totalamp >= 0

ndef

Base Entity | origin
Attribute Name | ndef
Logical Rolename |
ColumnName | ndef
RoleName |
Definition | This attribute denotes the number of phases with non-zero output weights used in hypocenter calculation
Note |
    Range:             ndef >= 0

nbs

Base Entity | origin
Attribute Name | nbs
Logical Rolename |
ColumnName | nbs
RoleName |
Definition | Number of S phase readings with non-zero output weights
Note |
    Range:             nbs >= 0

nbfm

Base Entity | origin
Attribute Name | nbfm
Logical Rolename |
ColumnName | nbfm
RoleName |
Definition | Number of P first motions with non-zero input weights
Note |
    Range:             nbfm >= 0

locevid

Base Entity | origin
Attribute Name | locevid
Logical Rolename |
ColumnName | locevid
RoleName |
Definition | Local event identifier. This attribute describes the original event identifier of the event. In combination with auth and subsource, it can be used to uniquely identify the original event identifier from that source. For example, waveforms from the original source may be associated with this identifier
Note |
    Range:             Any free-format string up to 12 characters long

quality

Base Entity | origin
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

fdepth

Base Entity | origin
Attribute Name | fdepth
Logical Rolename |
ColumnName | fdepth
RoleName |
Definition | This attribute indicates if the depth was fixed or not to compute the solution
Note |
    Range:		fdepth = {y | n}
    		y = fixed depth
    		n = free depth

fepi

Base Entity | origin
Attribute Name | fepi
Logical Rolename |
ColumnName | fepi
RoleName |
Definition | This attribute indicates if the epicenter was fixed or not to compute the solution
Note |
    Range:		fepi = {y | n}
    		y = fixed epicenter
    		n = free epicenter

ftime

Base Entity | origin
Attribute Name | ftime
Logical Rolename |
ColumnName | ftime
RoleName |
Definition | This attribute indicates if the origin time was fixed or not to compute the solution
Note |
    Range:		ftime = {y | n}
    		y = fixed origin time
    		n = free origin time

vmodelid

Base Entity | origin
Attribute Name | vmodelid
Logical Rolename |
ColumnName | vmodelid
RoleName |
Definition | Velocity model identification. This string identifies a version (instance) of the velocity model for the specified domain and algorithm. This version should be changed whenever the velocity model is changed. It is recommended that values 00 - 99 be used for this field
Note |

cmodelid

Base Entity | origin
Attribute Name | cmodelid
Logical Rolename |
ColumnName | cmodelid
RoleName |
Definition | Velocity model domain. This string identifies the organization responsible for the velocity model. Recommendations for this field are the SEED network name, or a unique abbreviation of the processing center when using data from multiple networks
Note |

rflag

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

crust_type

Base Entity | origin
Attribute Name | crust_type
Logical Rolename |
ColumnName | crust_type
RoleName |
Definition | The type of crust model used for travel time calculations. Each type has its own geometry of velocity layers or gradients within layers, tied to the options of the location program
Note |
    Range:		crust_type = {H | T | E | L | V}
    		H = Homogeneous layers, all stations at top (Hypoinverse CRH model)
    		T = Travel time table with linear gradient, all stations at top (Hypoinverse CRT model)
    		E = Hypoellipse layer model, using station elevations (Hypoinverse CRE model)
    		L = Hypoellipse single gradient model, using station elevations (Hypoinverse CRL model)
    		V = Hypoellipse single gradient over halfspace model, using station elevations (Hypoinverse CRV model)

crust_model

Base Entity | origin
Attribute Name | crust_model
Logical Rolename |
ColumnName | crust_model
RoleName |
Definition | The code for the regional (geographic) crust model that is dominant in the travel time calculations. The crust model depends on the location of the earthquake origin and not on the recording station. The code is for the highest weighted model if more than one is used
Note |
    Any free-format string up to 3 characters

gtype

Base Entity | origin
Attribute Name | gtype
Logical Rolename |
ColumnName | gtype
RoleName |
Definition | Geographic type. Describes the location of the event relative to the network. If the event occurred within the network's boundaries the geographic type is 'local'. If it occurs within delta < xxxx it is regional. Events outside this distance are teleseisms
Note |
    Range:gtype = | R | T| R | TR | TR | T| T| TTT
    L = local
    R = regional
    T = teleseism

lddate

Base Entity | origin
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