Request #106 (D. Given)
=======================

Add table EpochTimeBase

A table is needed by new functions in the TrueTime package to determine
if datetime values in the database are "true" or "nominal". This table
will most likely only contain one row. The ondate/offdate attribute is
included to allow a wholesale change of timebase at a future date.

Proposed table definition:

Create Table EpochTimeBase (
base      VARCHAR2(1)  NOT NULL,
ondate	  DATE         NOT NULL,
offdate	  DATE,	
PRIMARY KEY (base, ondate),
CONSTRAINT  CHECK (base IN ('T','N'))
)

T = true
N = nominal

------------------------------------------------------------------------
==> Approved.
------------------------------------------------------------------------

Request #104 (D. Oppenheimer):
==============================

Request 1 of 2: Expand "event types" definitions

I would like to expand the number of "event types" to reflect the usage
by Hypoinverse, the proposed usage in QuakeML, and some addition fields
proposed by Doug Given, as indicated in the table below.  

Rows with 2-char fields in the CISN column indicate existing usage in
the CISN schema.  

Rows without a 2-char field in the CISN column are proposed.   

Rows with an "X" in the QML column indicate the type is represented
in QuakeML

See Request 2 for discussion of "Broad Category" column.

Event Type               CISN QML Broad Category
------------------------ ---- --- --------------
local event               le   X  Earthquake
regional event            re      Earthquake
teleseism                 ts      Earthquake
quarry blast              qb   X  Explosion
nuclear test              nt   X  Explosion
unknown event             uk   X  Unknown
sonic blast               sn   X  Atmospheric
subnet trigger            st      Unknown
chemical explosion             X  Explosion
landslide                      X  Earth Movement
debris avalanche               X  Earth Movement
rockslide                      X  Earth Movement
collapse                       X  Earth Movement
volcanic eruption              X  Earth Movement
meteor impact                  X  Impact
plane crash                    X  Impact
building collapse              X  Impact
long period volcanic              Earthquake
rock burst                        Earth movement
tremor                            Tremor/tornillo
tornillo                          Tremor/tornillo
slow earthquake                   Earthquake
atmospheric (thunder)             Atmospheric
calibration event                 Explosion
refraction/reflection shot        Explosion

------------------------------------------------------------------------
==> New event types 'lp' & 'ex' approved.
    Allan to update Jiggle accordingly.
------------------------------------------------------------------------

Request #105 (D. Oppenheimer):
==============================

Request 2 of 2: Add "ecategory" field

If the first request is approved to expand the number of etypes, I then
propose that the expanded list of etypes be grouped according to 8 broad
categories shown below and listed in the table of Request 1.  The purpose
of the ecategory field will be to simplify searches.

Earthquake 
Explosion 
Unknown
Atmospheric 
Earth Movement 
Impact 
Tremor/tornillo 
Other 

The purpose of the ecategory field will be to simplify searches.

------------------------------------------------------------------------
==> Discussed. Ellen & Stephane tasked to come up with a proposal.
------------------------------------------------------------------------