SeismiQuery Logo

SeismiQuery Help

tables | definitions | help

The IRIS Data Management Center 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 pre-formatted queries that focus on specific types of information and data requests.

There are 4 parts to the SeismiQuery tool. Click on a item below to get help for that topic.

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


Queries in this category are for gathering information (i.e. meta data) about networks, stations or channels only. Data returned by these queries has nothing to do with data holdings, per se.

virtual nets
A virtual network is one made up of stations from multiple "real" networks. See a list of Virtual Networks here.

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

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

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

temp networks
Find temporary networks and related information.

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.

events
We have loaded event catalogs from NEIC and the ISC going back to the 1960's. This query allows users to search by location, magnitude, catalog, date, etc. A mapping option is also available.

assembled
We have added tables that contain the metadata associated with assembled data sets. Many of these data sets are of active source experiments. We have data from PASSCAL, USGS, and other temporary deployments.



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.

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.

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.

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

by timeseries
The ultimate query for timeseries information. A complete tool that has several output options including a SYNC file (used by DCCs to coordinate data holdings); a graph or table of holdings displaying gaps, overlaps and continuous data; and a map option.



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

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 b. (see BREQ_FAST manual for more information)



Each pre-formatted query comes with it's own documentation. If you are feeling adventurous and wish to write your own query in SQL, you may need some help.

hint bar
A visual aid to assist in query choice.

tables
A graphic display of the tables in our database that users may query. The display is color coded to show the relationship between tables and fields.

definitions
What do each of the table fields contain and how that relates to SEED data files (if applicable).


Last modified: June, 2009