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. The group approved the addition of new event types as well as the creation of a new table containing event categories. Doug G. will come up with a proposal and Stephane will send it to the Standards group: The Schema Change Working Group needs your input on a couple requests approved recently. The WG agreed to expand the list of event types and introduce the notion of an event category. In order to implement this scenario, the WG came up with a new table "EventType". This table describes the different event types as well as their respective categories. We would like the CISN Standards group members to examine carefully the list of event types/categories that the SCWG came up with and make sure that we didn't ommit a certain event type or classified one in the wrong category. Thanks, - SCWG ========================================================================== The "EventType" table contains the categories that an event type belong to as well as a general description of the type. CREATE TABLE "EventType" ( "etype" VARCHAR2(7) NOT NULL, "category" VARCHAR2(25) NOT NULL, "description" VARCHAR2(80) NULL ); No list constraints (this is a reference table which allows future expansion). Key = etype, category This allows an etype to exist in multiple categories, e.g. we can create a "volcanic" category that groups tremor, tornillo, lp events, & eruption while allowing lp events to remain in the "earthquake" category as well. Continue use of 2-char etypes, they are seldom seen by people and leaving them 2-char won't upset existing output formats. - Example contents of EventType: etype Description Category ------------------------------------------------------ th thunder atmospheric sn sonic blast atmospheric co mine/tunnel collapse earth movement av debris avalanche earth movement ls landslide earth movement rb rock burst earth movement rs rockslide earth movement ve volcanic eruption earth movement le local earthquake earthquake lp long period volcanic earthquake earthquake re regional earthquake earthquake se slow earthquake earthquake ts teleseismic earthquake earthquake ce calibration explosion explosion ex chemical explosion explosion nt nuclear test explosion qb quarry blast explosion sh refraction/reflection shot explosion bc building collapse impact mi meteor impact impact pc plane crash impact vt tornillo (volcanic tremor) tremor/tornillo tr non-volcanic tremor tremor/tornillo st subnet trigger unknown uk unknown event unknown ot other unknown - Notes: * Codes can get a list of valid etypes with: SELECT DISTINCT etype FROM EventType; * Codes can get a list of valid categories with: SELECT DISTINCT category FROM EventType; * To select events for a particular etype, e.g. 'le': SELECT FROM Event WHERE etype = 'le'; * To select events for a particular category, e.g. 'explosion': SELECT FROM Event WHERE etype IN (SELECT etype FROM EventType WHERE category = 'explosion'); ========================================================================== ------------------------------------------------------------------------