| orid |
| Base Table | origin |
| Attribute Name | orid |
| ColumnName | orid |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | evid |
| ColumnName | evid |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | magid |
| ColumnName | prefmag |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | mecid |
| ColumnName | prefmec |
| Logical Rolename | |
| 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 Table | origin |
| 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 |
| bogusflag |
| Base Table | origin |
| Attribute Name | bogusflag |
| ColumnName | bogusflag |
| Logical Rolename | |
| RoleName | |
| Definition | This field describes whether an origin is bogus or not |
| Note | Range: bogusflag = {0 | 1}
0 = no
1 = yes
|
| datetime |
| Base Table | origin |
| 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 |
| lat |
| Base Table | origin |
| Attribute Name | lat |
| ColumnName | lat |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | lon |
| ColumnName | lon |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | depth |
| ColumnName | depth |
| Logical Rolename | |
| RoleName | |
| Definition | 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 |
| Note | Range: -10.0 <= depth <= 1000.0 Units: Kilometers |
| type |
| Base Table | origin |
| Attribute Name | type |
| ColumnName | type |
| Logical Rolename | |
| RoleName | |
| Definition | Type of location |
| Note | Range: type = {H | C | A | D}
H = hypocenter
C = centroid
A = amplitude
D = double difference
|
| algorithm |
| Base Table | origin |
| Attribute Name | algorithm |
| ColumnName | algorithm |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | algo_assoc |
| ColumnName | algo_assoc |
| Logical Rolename | |
| 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 Table | origin |
| 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 Table | origin |
| 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 |
| datumhor |
| Base Table | origin |
| Attribute Name | datumhor |
| ColumnName | datumhor |
| Logical Rolename | |
| RoleName | |
| Definition | Datum type for horizontal (latitude and longitude) coordinates |
| Note | Range: datumhor = { NAD27 | WGS84} |
| datumver |
| Base Table | origin |
| Attribute Name | datumver |
| ColumnName | datumver |
| Logical Rolename | |
| RoleName | |
| Definition | Datum type for depth or elevation |
| Note | Range: datumver = { NAD27 | WGS84 | AVERAGE}
AVERAGE = average of stations
|
| gap |
| Base Table | origin |
| Attribute Name | gap |
| ColumnName | gap |
| Logical Rolename | |
| RoleName | |
| Definition | Gap in azimuthal coverage |
| Note | Range: 0.0 <= gap <= 360.0 Units: Degrees |
| distance |
| Base Table | origin |
| Attribute Name | distance |
| ColumnName | distance |
| Logical Rolename | |
| RoleName | |
| Definition | Distance from the origin to the nearest station |
| Note | Range: distance >= 0.0 Units: Kilometers |
| wrms |
| Base Table | origin |
| Attribute Name | wrms |
| ColumnName | wrms |
| Logical Rolename | |
| RoleName | |
| Definition | This attribute denotes the weighted RMS |
| Note | Range: wrms > 0.0 |
| stime |
| Base Table | origin |
| Attribute Name | stime |
| ColumnName | stime |
| Logical Rolename | |
| RoleName | |
| Definition | Origin time error. This attribute denotes the standard deviation of the origin time |
| Note | Range: stime >= 0.0 Units: Seconds |
| erhor |
| Base Table | origin |
| Attribute Name | erhor |
| ColumnName | erhor |
| Logical Rolename | |
| RoleName | |
| Definition | Horizontal error. This attribute denotes the location uncertainty that accompanies the location |
| Note | Range: erhor >= 0.0 Units: Kilometers |
| sdep |
| Base Table | origin |
| Attribute Name | sdep |
| ColumnName | sdep |
| Logical Rolename | |
| RoleName | |
| Definition | Depth error. This is the standard deviation of the depth estimate |
| Note | Range: sdep >= 0.0 Units: Kilometers |
| erlat |
| Base Table | origin |
| Attribute Name | erlat |
| ColumnName | erlat |
| Logical Rolename | |
| RoleName | |
| Definition | Error in latitude. This is the standard deviation of the latitude estimate |
| Note | Range: erlat >= 0.0 Units: Kilometers |
| erlon |
| Base Table | origin |
| Attribute Name | erlon |
| ColumnName | erlon |
| Logical Rolename | |
| RoleName | |
| Definition | Error in longitude. This is the standard deviation of the longitude estimate |
| Note | Range: erlon >= 0.0 Units: Kilometers |
| totalarr |
| Base Table | origin |
| Attribute Name | totalarr |
| ColumnName | totalarr |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | totalamp |
| ColumnName | totalamp |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | ndef |
| ColumnName | ndef |
| Logical Rolename | |
| RoleName | |
| Definition | This attribute denotes the number of phases with non-zero output weights used in hypocenter calculation |
| Note | Range: ndef >= 0 |
| nbs |
| Base Table | origin |
| Attribute Name | nbs |
| ColumnName | nbs |
| Logical Rolename | |
| RoleName | |
| Definition | Number of S phase readings with non-zero output weights |
| Note | Range: nbs >= 0 |
| nbfm |
| Base Table | origin |
| Attribute Name | nbfm |
| ColumnName | nbfm |
| Logical Rolename | |
| RoleName | |
| Definition | Number of P first motions with non-zero input weights |
| Note | Range: nbfm >= 0 |
| locevid |
| Base Table | origin |
| Attribute Name | locevid |
| ColumnName | locevid |
| Logical Rolename | |
| 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 Table | origin |
| 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 |
| fdepth |
| Base Table | origin |
| Attribute Name | fdepth |
| ColumnName | fdepth |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | fepi |
| ColumnName | fepi |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | ftime |
| ColumnName | ftime |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | vmodelid |
| ColumnName | vmodelid |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | cmodelid |
| ColumnName | cmodelid |
| Logical Rolename | |
| 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 Table | origin |
| Attribute Name | rflag |
| ColumnName | rflag |
| Logical Rolename | |
| 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 |
| lddate |
| Base Table | origin |
| 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 |