SeismiQuery
Database Tables

tables | definitions | SQL syntax

Table names are in BOLD and FIELDS are listed below the table names. This is a relational database, therefore FIELDS from one table can be related to FIELDS in one or many tables. FIELDS that have some relation to other TABLES are marked by like colors. For example, the FIELD ID in table B31 (or more properly noted - B31.id) is related to the FIELD B31_ID in tables CHANNEL_COMMENT and STATION_COMMENT (or CHANNEL_COMMENT.b31.id and STATION_COMMENT.b31_id). A list of definitions for some of the less obvious TABLE and FIELD names can be found on the definitions page.

NEW: Tables with temporary network information (primarily PASSCAL experiments) are now available.


B30

ID
FAMILY
NUMKEYS
NAME
KEY
KEY2
B31

ID
CLASS
TEXT
B34_ID
B32

ID

NAME
DATE_PUB
PUBLISHER
B33

ID
TEXT
B34

ID
NAME
TEXT
CHANNEL

NETWORK
STATION
LOCATION *
CHANNEL
STARTTIME
ENDTIME

LATITUDE
LONGITUDE
ELEVATION
DEPTH
AZIMUTH
DIP
RECORD_LENGTH
SAMPLE_RATE
MAX_DRIFT
LOOKUP_DFD
LOOKUP_GA
SUBCHANNEL
COMMENTS
FLAGS
LOOKUP_UNITS_IN
LOOKUP_UNITS_OUT

UPDATE_FLAG
STATION

NETWORK
STATION
STARTTIME
ENDTIME

LATITUDE
LONGITUDE
ELEVATION
SITE
LONG_WORD
WORD
LOOKUP_GA
UPDATE_FLAG
MAG

ID
MAGNITUDE
TYPE
CONTRIBUTOR
EVENT

ID
SOURCE
TIME
TIME_MS
LATITUDE
LONGITUDE
DEPTH
CATALOG
REGION
CONTRIBUTOR
LOOKUP_CSD
II_1990 *

NETWORK
STATION
CHANNEL
STARTTIME
ENDTIME

FILENAME
BYTES
LOCATION

* This is just an example of one of our many timeseries TABLEs. The naming convention is NETWORK-CODE_YEAR.
REGION

CODE
SEISMIC_REGION
REGION_TEXT
CHANNEL_COMMENT

NETWORK
STATION

CHANNEL
STARTTIME
ENDTIME

B31_ID

VALUE
STATION_COMMENT

NETWORK
STATION
STARTTIME
ENDTIME

B31_ID

VALUE

CHANNEL_SUMMARY

NETWORK
STATION
LOCATION
CHANNEL
EARLIEST
LATEST

(NOTE: this table is a compilation of data from many tables and is not "related" to any one table)

 

 

Tables specific to temporary network information

NETWORKS

ID
NETWORK
STARTYR

ENDYR
NAME
TYPE
NICKNAME
DESCRIPTION
FORMAT
MIN_LAT
MAX_LAT
MIN_LON
MAX_LON
RESULTS
PROBLEMS
ARRIVAL
RELEASE
EST_SIZE
RESTRICTED
OPERATOR

NET_OPERATORS

NETWORK_ID
NETWORK
STARTYR

CONTACT
POSITION

PERSON

ID
NAME
INSTITUTION
EMAIL

POSITION

ID
NAME

INSTITUTION

ID
NAME
ADDR1
ADDR2
COUNTRY
PHONE
FAX
TYPE

INSTITUTION_TYPE

ID
TYPE