Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| STAT_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the STAT table |
|||
| STAT_NAME | VARCHAR | 100 | √ | null |
|
|
Station Name |
|||
| STAT_IDNGA | VARCHAR | 100 | √ | null |
|
|
Station ID as reported in NGA projects (if available) |
|||
| STAT_SEQN | INT | 10 | √ | null |
|
|
Station Sequence Number |
|||
| STAT_NET | VARCHAR | 100 | √ | null |
|
|
Station Network |
|||
| STAT_LAT | DOUBLE | 22 | √ | null |
|
|
Station Latitude in WGS84 |
|||
| STAT_LON | DOUBLE | 22 | √ | null |
|
|
Station Longitude in WGS84 |
|||
| STAT_HOUSE | VARCHAR | 6 | √ | null |
|
|
Station Housing (GMX’s C1) |
|||
| STAT_ELE | FLOAT | 12 | √ | null |
|
|
Station Elevation in m |
|||
| STAT_VS30 | FLOAT | 12 | √ | null |
|
|
Vs30 (m/s) for analysis |
|||
| STAT_SIGVS30 | FLOAT | 12 | √ | null |
|
|
Sigma of preferred Vs30 (in natural log Units) |
|||
| STAT_NEHRP | VARCHAR | 2 | √ | null |
|
|
Preferred NEHRP category based on Vs30 |
|||
| STAT_REG | VARCHAR | 100 | √ | null |
|
|
Station Region |
|||
| STAT_DEPTH | FLOAT | 12 | √ | null |
|
|
Sensor Depth |
|||
| STAT_GEOL | VARCHAR | 100 | √ | null |
|
|
Geology Description |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | STAT_ID |
Relationships
Close relationships within degrees of separation
