The NCEDC uses an ORACLE database to archive meta data as well as timeseries information. SeismiQuery is a web tool that allows users to query the database for specific information about data availability as well as network, station and channel information. SeismiQuery is made up of several pre-formatted queries that focus on specific types of information and data requests. Users may also write their own queries in SQL (a primer is provided).

There are 4 parts to the SeismiQuery tool. Click on any of the following to get help for that catagory of options:

[information queries]	[data holdings]	[request tools]	[help pages]

channel

This query can provide the user with information about just what channels and instrumentation are available at different station locations. (GO)

station

This query looks at station information (excluding channel info) like location and network affiliations. (GO)

responses

This query returns channel response data in the RESP file format (ASCII). (GO)

comments
Some station operators or data collection centers use the SEED blockette 31 to include descriptive comments to data to indicate problems encountered or special situations. This query will scan for those comments either by station or channel. (GO)

events
We have loaded event catalogs from UCB going back to 1984. This query allows users to search by location, magnitude, source, date, etc. (GO)

write SQL
If users prefer, they may write their own queries using SQL. A primer in SQL is provided as well as a description of the tables available for query. (GO)

This category of queries will help the user to determine exactly what data are available from the DMC. Users can take in a gross overview or see down to the tenth of a second.

data summaries
This query gives the user a gross overview of data holdings by returning JUST the first and last date for which a network, station or channel returned data to be archived. (GO)

by station
A very useful query for looking at daily output of a station. A year long report of what days a station returned data - the output can be expanded to include timeseries information for each day; station by station. (GO)

by network
If you would prefer to see an overview of an entire network, this is the query. The expandable output is also available. (GO)

timeseries
The ultimate query for timeseries information. It displays whether stations have data available for the specified data or range of dates. Only data that has been extracted from the data acquisition archive and has been examined by the analyst will be displayed. (GO)

We have created two queries that result in request files in the following formats:

breq_fast
A timeseries query that results in a breq_fast request - our email based request format. Download the file, edit the header information and mail it to breq_fast@seismo.berkeley.edu. (See breq_fast manual for more information) (GO)

WEED
Not yet implemented at the NCEDC. (GO)

hint bar
A visual aid to assist in query choice. (GO)

general
The document you are reading.

about tables
A graphic display of the tables in our database that users may query. (GO)

SQL syntax
How to write your own query using SQL with examples specific to this database. (GO)