origin

Logical Entity Name | origin
Default Table Name | origin
Definition | Data on event location

origin Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
orid |  | NUMERIC(15, 0) | NO | 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
evid |  | NUMERIC(15, 0) | NO | 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
prefmag |  | NUMERIC(15, 0) | YES | Preferred magnitude. This attribute holds the magnitude identifier, magid, that points to the preferred magnitude for a seismic event or an origin
prefmec |  | NUMERIC(15, 0) | YES | Preferred mechanism. This attribute holds the mechanism identifier, mecid, that points to the preferred mechanism for a seismic event or an origin
commid |  | NUMERIC(15, 0) | YES | 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
bogusflag |  | NUMERIC(1, 0) | YES | This field describes whether an origin is bogus or not
datetime |  | NUMERIC(25, 10) | NO | The date of associated with information in the record, in true epoch format
lat |  | NUMERIC(9, 7) | NO | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon |  | NUMERIC(10, 7) | NO | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
depth |  | NUMERIC(7, 3) | YES | Source depth. This attribute gives the depth of the event origin. The reference depth of 0 is usually defined as the average elevation of stations used to determine the origin, although other data may be specified. Positive values are down, negative values are up from the reference point
type |  | VARCHAR(2) | YES | Type of location
algorithm |  | VARCHAR(15) | YES | Algorithm used. This is a brief textual description of the algorithm used to compute a seismic origin
algo_assoc |  | VARCHAR(80) | YES | Association algorithm used. This is a textual description of the algorithm used for associating the data
auth |  | VARCHAR(15) | NO | 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
subsource |  | VARCHAR(8) | YES | 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
datumhor |  | VARCHAR(8) | YES | Datum type for horizontal (latitude and longitude) coordinates
datumver |  | VARCHAR(8) | YES | Datum type for depth or elevation
gap |  | NUMERIC(4, 1) | YES | Gap in azimuthal coverage
distance |  | NUMERIC(7, 3) | YES | Distance from the origin to the nearest station
wrms |  | NUMERIC(5, 3) | YES | This attribute denotes the weighted RMS
stime |  | NUMERIC(6, 3) | YES | Origin time error. This attribute denotes the standard deviation of the origin time
erhor |  | NUMERIC(7, 3) | YES | Horizontal error. This attribute denotes the location uncertainty that accompanies the location
sdep |  | NUMERIC(7, 3) | YES | Depth error. This is the standard deviation of the depth estimate
erlat |  | NUMERIC(7, 3) | YES | Error in latitude. This is the standard deviation of the latitude estimate
erlon |  | NUMERIC(7, 3) | YES | Error in longitude. This is the standard deviation of the longitude estimate
totalarr |  | NUMERIC(5, 0) | YES | 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
totalamp |  | NUMERIC(6, 0) | YES | Total number of amplitudes in the database for the specified orid. Not all amplitudes have to associated with all magnitudes or origins
ndef |  | NUMERIC(5, 0) | YES | This attribute denotes the number of phases with non-zero output weights used in hypocenter calculation
nbs |  | NUMERIC(4, 0) | YES | Number of S phase readings with non-zero output weights
nbfm |  | NUMERIC(4, 0) | YES | Number of P first motions with non-zero input weights
locevid |  | VARCHAR(12) | YES | 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
quality |  | NUMERIC(2, 1) | YES | This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad
fdepth |  | VARCHAR(1) | YES | This attribute indicates if the depth was fixed or not to compute the solution
fepi |  | VARCHAR(1) | YES | This attribute indicates if the epicenter was fixed or not to compute the solution
ftime |  | VARCHAR(1) | YES | This attribute indicates if the origin time was fixed or not to compute the solution
vmodelid |  | NUMERIC(3, 0) | YES | Velocity model identification
cmodelid |  | NUMERIC(3, 0) | YES | Crustal model identifier
rflag |  | VARCHAR(2) | YES | This flag describes whether an observation was generated automatically, by a human, or has been finalized
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

origin Relationships

Parent Entity | Child Entity | Type | Foreign Keys
event | origin | Non-Identifying | evid
mec | origin | Non-Identifying | prefmec
netmag | origin | Non-Identifying | prefmag
remark | origin | Non-Specific |
origin | assocaro | Identifying | orid
origin | assoccoo | Identifying | orid
origin | assocamo | Identifying | orid
origin | event | Non-Identifying | prefor
origin | mec | Non-Identifying | oridin
origin | mec | Non-Identifying | oridout
origin | netmag | Non-Identifying | orid
origin | origin_error | Identifying | orid

origin Check Constraints

Check Constraint Name | CheckConstraint
origin01 | cmodelid > 0
origin02 | datumhor in ('NAD27','WGS84')
origin03 | datumver in ('NAD27','WGS84','AVERAGE')
origin04 | depth >= -10.0 and depth <= 1000.0
origin05 | distance >= 0.0
origin06 | erhor >= 0.0
origin07 | erlat >= 0.0
origin08 | erlon >= 0.0
origin09 | fdepth in ('y','n')
origin10 | fepi in ('y','n')
origin11 | ftime in ('y','n')
origin12 | gap >= 0.0 and gap <= 360.0
origin15 | nbfm >= 0
origin16 | nbs >= 0
origin17 | ndef >= 0
origin18 | orid > 0
origin19 | quality >= 0.0 and quality <= 1.0
origin20 | type in ('H','HO','HR','HI','GO','C','A')
origin21 | stime >= 0.0
origin22 | vmodelid > 0
origin23 | wrms >= 0.0
origin24 | sdep >=0.0
origin25 | totalarr >=0
origin26 | totalamp >= 0
origin28 | rflag in ('a','h','f','A','H','F')