site
The site table contains station location information. It names and describes a point on the earth where measurements are made (for example, the location of an instrument or array of instruments). This table contains information that normally changes infrequently, such as location. In addition, the site table contains types that describe the offset of a station relative to an array reference location. Global data integrity implies that the sta/ ondate in site be consistent with the sta/chan/ondate in the sitechan table.
|
FIELD |
COLUMN |
STORAGE |
EXTERNAL |
CHARACTER |
DESCRIPTION |
|
NUMBER |
TYPE |
FORMAT |
POSITION |
||
|
1 |
sta |
varchar2(6) |
a6 |
1-6 |
station identifier |
|
2 |
ondate |
number(8) |
i8 |
8-15 |
julian start date |
|
3 |
offdate |
number(8) |
i8 |
17-24 |
julian off date |
|
4 |
lat |
float(53) |
f11.6 |
26-36 |
latitude |
|
5 |
Ion |
float(53) |
f11.6 |
38-48 |
longitude |
|
6 |
elev |
float(24) |
f9.4 |
50-58 |
elevation |
|
7 |
staname |
varchar2(50) |
a50 |
60-109 |
station description |
|
8 |
statype |
varchar2(4) |
a4 |
111-114 |
station type (single station, array) |
|
9 |
refsta |
varchar2(6) |
a6 |
116-121 |
reference station for array members |
|
10 |
dnorth |
float(24) |
f9.4 |
123-131 |
offset from array reference (km) |
|
11 |
deast |
float(24) |
f9.4 |
133-141 |
offset from array reference (km) |
|
12 |
Iddate |
date |
a19 |
143-161 |
load date |
|
Keys: |
Primary |
sta, ondate |
|
|
|
|
|
Data: |
Descriptive |
sta, staname, statype, refsta |
|
|
Mesurement |
ondate, offdate, lat, lon, elev, dnorth, deast |
|
|
Administrative |
lddate |