Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| IM_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the IM table |
|||
| EVNT_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||
| STAT_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||
| IM_RJB | FLOAT | 12 | √ | null |
|
|
Joyner and Boore (1981) Distance (km) |
|||
| IM_EPI | FLOAT | 12 | √ | null |
|
|
Epicentral distance (km) |
|||
| IM_HYPO | FLOAT | 12 | √ | null |
|
|
Hypocentral distance (km) |
|||
| IM_R | FLOAT | 12 | √ | null |
|
|
Campbell Distance, R (km) |
|||
| IM_RMS | FLOAT | 12 | √ | null |
|
|
Root-mean-squared distance (km) |
|||
| IM_CLST | FLOAT | 12 | √ | null |
|
|
Closest distance from the recording site to the ruptured fault area (km) |
|||
| IM_RX | FLOAT | 12 | √ | null |
|
|
Horizontal distance (km) from top edge of rupture. Measured perpendicular to the fault strike (km) |
|||
| IM_AZIMUTH | FLOAT | 12 | √ | null |
|
|
Source to Site Azimuth (deg) - Used to assess HW/FW locations |
|||
| PGA | FLOAT | 12 | √ | null |
|
|
Peak Ground Acceleration (g) |
|||
| PGV | FLOAT | 12 | √ | null |
|
|
Peak Ground Velocity (cm/s) |
|||
| PGD | FLOAT | 12 | √ | null |
|
|
Peak Ground Displacement (m) |
|||
| T0_010S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.01 s (g) |
|||
| T0_020S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.02 s (g) |
|||
| T0_022S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.022 s (g) |
|||
| T0_025S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.025 s (g) |
|||
| T0_029S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.029 s (g) |
|||
| T0_030S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.030 s (g) |
|||
| T0_032S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.032 s (g) |
|||
| T0_035S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.035 s (g) |
|||
| T0_036S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.036 s (g) |
|||
| T0_040S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.040 s (g) |
|||
| T0_042S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.042 s (g) |
|||
| T0_044S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.044 s (g) |
|||
| T0_045S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.045 s (g) |
|||
| T0_046S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.046 s (g) |
|||
| T0_048S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.048 s (g) |
|||
| T0_050S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.050 s (g) |
|||
| T0_055S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.055 s (g) |
|||
| T0_060S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.060 s (g) |
|||
| T0_065S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.065 s (g) |
|||
| T0_067S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.067 s (g) |
|||
| T0_070S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.070 s (g) |
|||
| T0_075S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.075 s (g) |
|||
| T0_080S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.080 s (g) |
|||
| T0_085S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.085 s (g) |
|||
| T0_090S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.090 s (g) |
|||
| T0_095S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.095 s (g) |
|||
| T0_100S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.100 s (g) |
|||
| T0_110S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.110 s (g) |
|||
| T0_120S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.120 s (g) |
|||
| T0_130S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.130 s (g) |
|||
| T0_133S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.133 s (g) |
|||
| T0_140S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.140 s (g) |
|||
| T0_150S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.150 s (g) |
|||
| T0_160S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.160 s (g) |
|||
| T0_170S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.170 s (g) |
|||
| T0_180S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.180 s (g) |
|||
| T0_190S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.190 s (g) |
|||
| T0_200S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.200 s (g) |
|||
| T0_220S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.220 s (g) |
|||
| T0_240S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.240 s (g) |
|||
| T0_250S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.250 s (g) |
|||
| T0_260S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.260 s (g) |
|||
| T0_280S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.280 s (g) |
|||
| T0_290S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.290 s (g) |
|||
| T0_300S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.300 s (g) |
|||
| T0_320S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.320 s (g) |
|||
| T0_340S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.340 s (g) |
|||
| T0_350S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.350 s (g) |
|||
| T0_360S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.360 s (g) |
|||
| T0_380S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.380 s (g) |
|||
| T0_400S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.400 s (g) |
|||
| T0_420S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.420 s (g) |
|||
| T0_440S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.440 s (g) |
|||
| T0_450S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.450 s (g) |
|||
| T0_460S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.460 s (g) |
|||
| T0_480S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.480 s (g) |
|||
| T0_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.500 s (g) |
|||
| T0_550S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.550 s (g) |
|||
| T0_600S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.600 s (g) |
|||
| T0_650S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.650 s (g) |
|||
| T0_667S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.667 s (g) |
|||
| T0_700S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.700 s (g) |
|||
| T0_750S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.750 s (g) |
|||
| T0_800S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.800 s (g) |
|||
| T0_850S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.850 s (g) |
|||
| T0_900S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.900 s (g) |
|||
| T0_950S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=0.950 s (g) |
|||
| T1_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.000 s (g) |
|||
| T1_100S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.100 s (g) |
|||
| T1_200S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.200 s (g) |
|||
| T1_300S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.300 s (g) |
|||
| T1_400S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.400 s (g) |
|||
| T1_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.500 s (g) |
|||
| T1_600S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.600 s (g) |
|||
| T1_700S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.700 s (g) |
|||
| T1_800S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.800 s (g) |
|||
| T1_900S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=1.900 s (g) |
|||
| T2_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=2.000 s (g) |
|||
| T2_200S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=2.200 s (g) |
|||
| T2_400S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=2.400 s (g) |
|||
| T2_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=2.500 s (g) |
|||
| T2_600S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=2.600 s (g) |
|||
| T2_800S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=2.800 s (g) |
|||
| T3_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=3.000 s (g) |
|||
| T3_200S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=3.200 s (g) |
|||
| T3_400S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=3.400 s (g) |
|||
| T3_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=3.500 s (g) |
|||
| T3_600S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=3.600 s (g) |
|||
| T3_800S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=3.800 s (g) |
|||
| T4_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=4.000 s (g) |
|||
| T4_200S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=4.200 s (g) |
|||
| T4_400S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=4.400 s (g) |
|||
| T4_600S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=4.600 s (g) |
|||
| T4_800S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=4.800 s (g) |
|||
| T5_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=5.000 s (g) |
|||
| T5_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=5.500 s (g) |
|||
| T6_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=6.000 s (g) |
|||
| T6_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=6.500 s (g) |
|||
| T7_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=7.000 s (g) |
|||
| T7_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=7.500 s (g) |
|||
| T8_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=8.000 s (g) |
|||
| T8_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=8.500 s (g) |
|||
| T9_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=9.000 s (g) |
|||
| T9_500S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=9.500 s (g) |
|||
| T10_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=10.000 s (g) |
|||
| T11_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=11.000 s (g) |
|||
| T12_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=12.000 s (g) |
|||
| T13_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=13.000 s (g) |
|||
| T14_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=14.000 s (g) |
|||
| T15_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=15.000 s (g) |
|||
| T20_000S | FLOAT | 12 | √ | null |
|
|
5%-Damped Pseudo Spectral Acceleration at Period T=20.000 s (g) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | IM_ID |
| EVNT_ID | Performance | Asc | EVNT_ID |
| STAT_ID | Performance | Asc | STAT_ID |
Relationships
Close relationships within degrees of separation
