origin
The origin table contains information describing a derived or reported origin for a particular event.
|
FIELD |
COLUMN |
STORAGE |
EXTERNAL |
CHARACTER |
DESCRIPTION |
|
NUMBER |
TYPE |
FORMAT |
POSITION |
||
|
1 |
lat |
f1oat(24) |
f11.4 |
1-11 |
estimated latitude |
|
2 |
Ion |
f1oat(24) |
f11.4 |
13-23 |
estimated longitude |
|
3 |
depth |
f1oat(24) |
f9.4 |
25-33 |
estimated depth |
|
4 |
time |
f1oat(53) |
f17.5 |
35-51 |
epoch time |
|
5 |
orid |
number(9) |
i9 |
53-61 |
origin identifier |
|
6 |
evid |
number(9) |
i9 |
63-71 |
event identifier |
|
7 |
jdate |
number(8) |
i8 |
73-80 |
julian date |
|
8 |
nass |
number(4) |
i4 |
82-85 |
number of associated phases |
|
9 |
ndef |
number(4) |
i4 |
87-90 |
number of locating phases |
|
10 |
ndp |
number(4) |
i4 |
92-95 |
number of depth phases |
|
11 |
gm |
number(8) |
i8 |
97-104 |
geographic region number |
|
12 |
sm |
number(8) |
i8 |
106-113 |
seismic region number |
|
13 |
etype |
varchar2(7) |
a7 |
115-121 |
event type |
|
14 |
depdp |
f1oat(24) |
f9.4 |
123-131 |
estimated depth from depth phases |
|
15 |
dtype |
varchar2( 1) |
a1 |
133-133 |
depth method used |
|
16 |
mb |
f1oat(24) |
f7.2 |
135-141 |
body wave magnitude |
|
17 |
mbid |
number(9) |
i9 |
143-151 |
Mb magnitude identifier |
|
18 |
ms |
f1oat(24) |
f7.2 |
153-159 |
surface wave magnitude |
|
19 |
msid |
number(9) |
i9 |
161-169 |
Ms magnitude identifier |
|
20 |
ml |
f1oat(24) |
f7.2 |
171-177 |
local magnitude |
|
21 |
mUd |
number(9) |
i9 |
179-187 |
ML magnitude identifier |
|
22 |
algorithm |
varchar2( 15) |
a15 |
189-203 |
location algorithm used |
|
23 |
auth |
varchar2(15) |
a15 |
205-219 |
source/originator |
|
24 |
commid |
number(9) |
i9 |
221-229 |
comment identifier |
|
25 |
lddate |
date |
a19 |
231-249 |
load date |
|
Keys: |
Primary |
lat, lon, depth, time, auth |
|
|
Unique |
orid |
|
|
Foreign |
evid, mbid, msid, mlid, commid |
|
Data: |
Descriptive |
nass, ndef, ndp, gm, sm, etype |
|
|
Mesurement |
lat, lon, depth, time, jdate, depdp, dtype, mb, mbid, ms, msid, ml, mlid |
|
|
Administrative |
algorithm, auth, lddate |