| Column ID | Column Name | Description |
|---|---|---|
| A | Region | Defines the state or province of each VS profile or VS30 measurement based on the latitude and longitude information of the station |
| B | Network | Affiliated strong motion network for SDB site. All network codes per the International Federation of Digital Seismograph Networks, http://www.fdsn.org/ (last accessed May 2017) |
| C | Station sequence no. (SSN) | A unique sequence number assigned to each strong-motion station within NGA-Subduction for identification purpose |
| D | Site name | PDB site name |
| E | Site ID | Unique PDB site name for purposes of matching sites across studies and between PDB and SDB |
| F | Latitude (°) | Station latitude data from data provider |
| G | Longitude (°) | Station longitude data from data provider |
| H | Elevation (m) | Elevation of PDB site in meters, based on SRTM30 DEM |
| I | VS30 for analysis (m/s) | Preferred VS30 value in m/s, from measurements or proxy analysis |
| J | Sigma_lnV for analysis | Log standard deviation (ln units), related to VS30 code (column L); see the Recommendations for VS30 Assignments section in the main article for further discussion |
| K | NEHRP category based on VS30 per DobryEA2000 | The preferred NEHRP site class was determined based on the VS30 for analysis values (Dobry et al., 2000). The following VS30 table was used: A ≥ 1500 m/s 760 ≤ B < 1500 m/s 360 < C < 760 m/s 180 < D ≤ 360 m/s E ≤ 180 m/s |
| L | VS30 code | A hierarchy was used to assign VS30 values and associated uncertainty to each PDB site. See the Recommendations for VS30 Assignments section in the main article |
| M | Distance to PDB profile (m) | Distance to nearest VS profile in the PDB of Table S2 in meters. For codes 0 or 1 assignment of VS profiles to NGA-Subduction SDB stations, distance must be ≤300 m |
| N | Site ID of nearest PDB profile | Site ID of associated PDB VS profile (i.e., column D of Table S2) |
| O | VSZ (m/s) | Time-averaged shear-wave velocity to profile depth zp |
| P | Profile depth z_p (m) | Maximum depth of VS profile in meters |
| Q | Original reported VS30 (m/s) | VS30 per original source document |
| R | Measured VS30 (m/s) | Measured VS30 values if zp ≥ 30 m and extrapolated values if zp < 30 m. See the VS30 Computation section and Appendix in the main article |
| S | Inferred VS30 by extending VS at z_p (m/s) | Extrapolations from VSZ to VS30 values based on DEA13 methodology. See the VS30 Computation section in the main article |
| T | 30 arcsec topographic slope (m/m) | Topographic gradient (i.e., ground slope) from SRTM30 DEM. −999, unassigned |
| U | Geologic unit | Geologic unit symbol based on geologic maps. See Table 3 in the main article. −999, unassigned |
| V | Geologic name | Geologic unit name based on geologic maps. See Table 3 in the main article. −999, unassigned |
| W | Geologic age | Geologic age of unit based on geologic maps. See Table 3 in the main article. −999, unassigned |
| X | Geologic description | Description of geologic unit based on geologic maps. See Table 3 in the main article. −999, unassigned |
| Y | Geologic age—Simple | Simplified geologic age based on geologic age (column U). R, recent; H, Holocene; P, Pleistocene; Q, undivided Quaternary; T, Tertiary; Mz, Mesozoic; Pz, Paleozoic; −999, unassigned |
| Z | New geologic category per AhdiEA2017 | Simplified geologic category based on lithology or depositional environment, based on geologic units from maps |
| AA | Final geologic group per AhdiEA17 | Combination of geologic categories into 18 groups based on similar statistics and lithology or depositional environment; see Table 4 in the main article |
| AB | PNW geology group mean VS30 (m/s) | Mean VS30 from profiles within each geologic group (this study). See Table 4 in the main article |
| AC | PNW geology group Sigma_ln VS30 | Logarithmic standard deviation of VS30 from profiles within each geologic group (this study). See Table 4 in the main article |
| AD | PNW slope-geology hybrid model VS30 (m/s) | VS30 based on geology-slope hybrid proxy model using equation (7) in the main article; NA, not applicable for geologic groups without slope dependency per Table 4 in the main article |
| AE | Preferred PNW geology proxy VS30 (m/s) | Assigned geology proxy-based VS30 for PDB site, with preference given to VS30 from hybrid model with slope; if column AC = NA, use column AB value |
| AF | Slope model coef. c0 | Regression coefficient for within-geology-group slope-dependent VS30 model; used in equation (7) in the main article. See Table 4 in the main article |
| AG | Slope model coef. c1 | Regression coefficient for within-geology-group slope-dependent VS30 model; used in equation (7). See Table 4 in the main article |
| AH | WillsEA2015 geologic bin | Geologic group name from Wills et al. (2015) geology proxy for California |
| AI | WillsEA2015 mean VS30 (m/s) | Mean VS30 in m/s for geologic groups from Wills et al. (2015) geology proxy for California |
| AJ | WillsEA2015 Sigma_ln VS30 | Natural log standard deviation of VS30 for geologic groups from Wills et al. (2015) geology proxy for California |
| AK | ParkerEA2016 CENA VS30 (m/s) | Mean VS30 in m/s for geologic groups from Parker et al. (2017) geology proxy for CENA |
| AL | ParkerEA2016 CENA sigma_ln VS30 | Natural log standard deviation of VS30 for geologic groups from Parker et al. (2017) geology proxy for CENA |
| AM | Preferred geology proxy | Preferred geology proxy used to assign VS30 and associated uncertainty to SDB site, among choices of PNW proxy (this study), Wills et al. (2015) for California, and Parker et al. (2017) for CENA. −999 indicates that the assigned VS30 value is either based on direct measurements (VS30 codes 0 and 1), or based on a terrain proxy (VS30 codes 2b or 3b, per column AS) |
| AN | Terrain class per IP07 | Geomorphology-based terrain classes computed from SRTM30 DEM, per study from Iwahashi and Pike (2007) |
| AO | PNW terrain class mean VS30 (m/s) | Mean VS30 from profiles within each IP07 terrain class (this study). See Table 6 in the main article |
| AP | PNW terrain class sigma_ln VS30 | Logarithmic standard deviation of VS30 from profiles within each IP07 terrain class (this study). See Table 6 in the main article |
| AQ | Yong16 terrain class mean VS30 (m/s) | Mean VS30 from profiles in California within each IP07 terrain class (Yong, 2016). See Table 6 in the main article |
| AR | Yong16 terrain class sigma_ln VS30 | Logarithmic standard deviation of VS30 from profiles in California within each IP07 terrain class (Yong, 2016). See Table 6 in the main article |
| AS | Preferred terrain proxy | Selected terrain proxy for VS30 assignment to SDB site. If −999, either site has directly measured VS30 (VS30 codes 0 and 1), or VS30 is based on geology proxy (VS30 codes 2a, 3a, and 3c, per column AM) |
| AT | Preferred terrain class mean VS30 (m/s) | Assigned VS30 value to PDB site, with preference given to terrain proxy from this study. For terrain classes 2, 6, and 10, mean taken from Y16 |
| AU | Preferred terrain class sigma_ln VS30 | Assigned VS30 uncertainty to PDB site, with preference given to terrain proxy from this study. For terrain classes 2, 6, and 10, mean taken from Y16 |
| AV | Measured VS profile Z1.0 (m) | Depth to 1 km/s horizon in meters based on VS profile, if applicable |
| AW | Measured VS profile Z1.5 (m) | Depth to 1.5 km/s horizon in meters based on VS profile, if applicable |
| AX | Measured VS profile Z2.5 (m) | Depth to 2.5 km/s horizon in meters based on VS profile, if applicable |
| AY | Z2.5 per Stephenson 2016 | Depth to 2.5 km/s horizon in meters based crustal velocity model of W. Stephenson ( personal comm., 2016) |
| AZ | Preferred Z2.5 (m) | Preference to Z2.5 from velocity profile, if available, otherwise taken from column AQ |
| BA | Pierce 2003 glacial tag | See Figure 1 in the main article; site assigned 1 if north of glacial terminus (i.e., previously glaciated region); site assigned 0 if south of glacial terminus (i.e., not previously glaciated region) |
Throughout spreadsheet, −999 indicates unknown or unassigned value. CENA, central and eastern North America; DEA13, Dai et al. (2013); DEMs, digital elevation maps; IP07, Iwahashi and Pike (2007); NEHRP, National Earthquake Hazards Reduction Program; PDB, profile database; SRTM30, Shuttle Radar Topography Mission (at 30 arcsec resolution); Y16, Yong (2016).
[ Back ]