Services

An API service provides access to information stored on the server. Services available on this API include the following:

  1. schema

  2. flatfile

  3. timeseries

Each service has a default set of information that is returned when no query string parameters are provided. Those defaults are described here. Customization of the returned information can be achieved using query string parameters.

schema

The schema service provides access to the organizational structure of the database. The default set of parameters is obtained using the URL below.

https://www.uclageo.com/gm_database/api/index.php/schema

By default, this query returns a set of HTML tables that includes a list of publicly accessible tables in the database, as well as a list of the fields and the attributes of the fields in those tables. This information can also be returned in JSON or CSV format, as described in the Query string parameters section.

flatfile

A flatfile is a single table that contains information synthesized from many different tables. You may be familiar with NGA flatfiles. The flatfile resource allows you to customize the information you’d like to put into your flatfile, and return it in HTML, JSON, or CSV format. The flatfile resource provides access to data contained in most of the publicly accessible tables in the database. The URL below will return an HTML-formatted flatfile with 50 rows containing data from the following tables: event, event_type, network, station, site, motion, time_series_metadata, intensity_measure, response_spectra. All fields within these tables are returned, with the exception of foreign keys, which are records in one table used to identify corresponding records in another table. For example, event_id appears in both the event table (as a primary key) and the motion table (as a foreign key) to identify the event that generated the motion. These keys are really important to relate tables to each other within the relational database, but they are redundant in a flatfile where the data are merged into a single table. For example, event_id is repeated for every motion for the event in the flatfile, but is contained only once in the database.

https://www.uclageo.com/gm_database/api/index.php/flatfile

If you’d like to customize your flatfile, check out our Query string parameters section.

timeseries

The timeseries service provides access to unrestricted timesereis data.

… under development …