CyberShake DB Queries - Revision history

Scottcal: /* Rupture_Variations Table */

2016-04-07T20:14:23Z

Rupture_Variations Table

Scottcal: /* Accessing ERF Info (rates, probabilities, site distances, etc) */

2016-04-07T20:11:01Z

Accessing ERF Info (rates, probabilities, site distances, etc)

Scottcal: /* Rupture_Variations Table */

2016-04-07T20:07:11Z

Rupture_Variations Table

Scottcal: /* CyberShake Database Queries */

2016-04-07T20:06:55Z

CyberShake Database Queries

Kmilner: /* CyberShake_Site_Ruptures Table */

2015-06-11T23:41:22Z

CyberShake_Site_Ruptures Table

Kmilner at 23:40, 11 June 2015

2015-06-11T23:40:25Z

Kmilner at 23:29, 11 June 2015

2015-06-11T23:29:36Z

Kmilner: Created page with '= CyberShake Database Queries = This page contains various CyberShake database queries which may be be of use to users. We suggest that you use a graphical SQL interface for exp…'

2015-06-11T23:24:38Z

Created page with '= CyberShake Database Queries = This page contains various CyberShake database queries which may be be of use to users. We suggest that you use a graphical SQL interface for exp…'

New page

= CyberShake Database Queries =

This page contains various CyberShake database queries which may be be of use to users. We suggest that you use a graphical SQL interface for exploring the CyberShake database.

== Accessing ERF Info (rates, probabilities, site distances, etc) ==

The "Ruptures" table contains information on each rupture in the Earthquake Rupture Forecasts (ERFs) used in CyberShake.

Current ERFs in use:
ERF_ID=35: Standard UCREF2, 1.0 km rupture surface discretization
ERF_ID=36: Same as 35 but 200 m rupture surface discretization for 1hz runs

Fields:

<pre>
mysql> describe Ruptures;
+--------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| ERF_ID | int(10) unsigned | NO | PRI | NULL | |
| Source_ID | int(10) unsigned | NO | PRI | NULL | |
| Rupture_ID | int(10) unsigned | NO | PRI | NULL | |
| Source_Name | varchar(100) | NO | | NULL | |
| Source_Type | varchar(20) | YES | | NULL | |
| Mag | double | NO | | NULL | |
| Prob | double | NO | | NULL | |
| Grid_Spacing | double | NO | | NULL | |
| Num_Rows | int(11) | NO | | NULL | |
| Num_Columns | int(11) | NO | | NULL | |
| Num_Points | int(11) | NO | | NULL | |
| Start_Lat | double | NO | | NULL | |
| Start_Lon | double | NO | | NULL | |
| Start_Depth | double | NO | | NULL | |
| End_Lat | double | NO | | NULL | |
| End_Lon | double | NO | | NULL | |
| End_Depth | double | NO | | NULL | |
+--------------+------------------+------+-----+---------+-------+
</pre>

For example, to see all available information on Source 0:

<pre>
mysql> SELECT * FROM Ruptures WHERE ERF_ID=35 AND Source_ID=0;
+--------+-----------+------------+--------------+-------------+------+---------------+--------------+----------+-------------+------------+-----------+------------+-------------+-----------+---------+-----------+
| ERF_ID | Source_ID | Rupture_ID | Source_Name | Source_Type | Mag | Prob | Grid_Spacing | Num_Rows | Num_Columns | Num_Points | Start_Lat | Start_Lon | Start_Depth | End_Lat | End_Lon | End_Depth |
+--------+-----------+------------+--------------+-------------+------+---------------+--------------+----------+-------------+------------+-----------+------------+-------------+-----------+---------+-----------+
| 35 | 0 | 0 | Calaveras;CC | null | 5.95 | 0.00030383517 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
| 35 | 0 | 1 | Calaveras;CC | null | 6.05 | 0.0010007863 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
| 35 | 0 | 2 | Calaveras;CC | null | 6.15 | 0.0017895743 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
| 35 | 0 | 3 | Calaveras;CC | null | 6.25 | 0.0018958241 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
| 35 | 0 | 4 | Calaveras;CC | null | 6.35 | 0.0015825889 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
| 35 | 0 | 5 | Calaveras;CC | null | 6.45 | 0.0010841207 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
| 35 | 0 | 6 | Calaveras;CC | null | 6.55 | 0.0004575977 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
| 35 | 0 | 7 | Calaveras;CC | null | 6.65 | 0.00010773571 | 1 | 4 | 59 | 236 | 37.441475 | -121.80358 | 4.68 | 36.992928 | -121.47 | 4.68 |
+--------+-----------+------------+--------------+-------------+------+---------------+--------------+----------+-------------+------------+-----------+------------+-------------+-----------+---------+-----------+
</pre>

@@ Line 62: / Line 62: @@
 The "Rupture_Variations" table contains information about each rupture variation - each realization created with the rupture generator, with a hypocenter and slip distribution.  Linking this table with the Ruptures table allows you to select a specific variation of a rupture with the hypocenter in a certain location.  This is dependent on the specific rupture generator used, identified by the Rup_Var_Scenario_ID.
-Rup_Var_Scenario_ID=3: Graves & Pitarka (2006), used in early CyberShake runs.
+Rup_Var_Scenario_ID=3: Graves & Pitarka (2007), used in preliminary testing and Study 1.0.
 Rup_Var_Scenario_ID=4: Graves & Pitarka (2010), used in Study 2.2, 13.4, and 14.2.
 Rup_Var_Scenario_ID=5: Graves & Pitarka (2014) with random hypocenter spacing, only used in testing.
 Rup_Var_Scenario_ID=6: Graves & Pitarka (2014) with uniform hypocenter spacing, used in Study 15.4 and 15.12.
 <pre>

@@ Line 60: / Line 60: @@
 === Rupture_Variations Table ===
-The "Rupture_Variations" table contains information about each rupture variation - each realization created with the rupture generator, with a hypocenter and slip distribution.  Linking this table with the Ruptures table allows you to select a specific variation of a rupture with the hypocenter in a certain location.
+The "Rupture_Variations" table contains information about each rupture variation - each realization created with the rupture generator, with a hypocenter and slip distribution.  Linking this table with the Ruptures table allows you to select a specific variation of a rupture with the hypocenter in a certain location.  This is dependent on the specific rupture generator used, identified by the Rup_Var_Scenario_ID.
 <pre>
@@ Line 79: / Line 84: @@
 </pre>
-For example, to look at information
+For example, to look at information for ERF 36, source 0, rupture 0:
 === CyberShake_Site_Ruptures Table ===

@@ Line 78: / Line 78: @@
 +---------------------+---------------------+------+-----+---------+-------+
 </pre>
 === CyberShake_Site_Ruptures Table ===

@@ Line 60: / Line 60: @@
 === CyberShake_Site_Ruptures Table ===
-the "CyberShake_Site_Ruptures" table maps CyberShake sites to the Ruptures within a given cutoff distance. This can be used to find all ruptures for which CyberShake has been computed for a given site. It also contains source distances.
+the "CyberShake_Site_Ruptures" table maps CyberShake sites to the Ruptures within a given cutoff distance. This can be used to find all ruptures for which CyberShake has been computed for a given site. It also contains the minimum 3D distance between each site and rupture surface.
 NOTE: Some distances are currently (as of 6/11/2015) excluded for ERF 36. You can use distances for ERF 35 in their place as they are equivalent.

@@ Line 91: / Line 91: @@
 |         18 |     35 |         7 |          4 |         200 |             68.19 |
 +------------+--------+-----------+------------+-------------+-------------------+
 </pre>

@@ Line 56: / Line 56: @@
 |     35 |         0 |          7 | Calaveras;CC | null        | 6.65 | 0.00010773571 |            1 |        4 |          59 |        236 | 37.441475 | -121.80358 |        4.68 | 36.992928 | -121.47 |      4.68 |
 +--------+-----------+------------+--------------+-------------+------+---------------+--------------+----------+-------------+------------+-----------+------------+-------------+-----------+---------+-----------+
 </pre>

@@ Line 4: / Line 4: @@
 == Accessing ERF Info (rates, probabilities, site distances, etc) ==
 The "Ruptures" table contains information on each rupture in the Earthquake Rupture Forecasts (ERFs) used in CyberShake.
@@ Line 54: / Line 56: @@
 |     35 |         0 |          7 | Calaveras;CC | null        | 6.65 | 0.00010773571 |            1 |        4 |          59 |        236 | 37.441475 | -121.80358 |        4.68 | 36.992928 | -121.47 |      4.68 |
 +--------+-----------+------------+--------------+-------------+------+---------------+--------------+----------+-------------+------------+-----------+------------+-------------+-----------+---------+-----------+
 </pre>