| Column ID | Column Name | Description |
|---|---|---|
| A | Source of data | Defines the source of the VS profile used to populate PDB. Referenced sources are listed in the main description page of the electronic supplement |
| B | Region | Defines the state or province of each VS profile or VS30 measurement based on the latitude and longitude information of the profile |
| C | Site name | PDB site name |
| D | Site ID | Unique PDB site name for purposes of matching sites across studies and between PDB and SDB |
| E | Latitude (°) | Station latitude data from data provider |
| F | Longitude (°) | Station longitude data from data provider |
| G | Elevation (m) | Elevation of PDB site in meters, based on SRTM30 DEM |
| H | VS30 for analysis (m/s) | Preferred VS30 value in m/s, from measurements or proxy analysis |
| I | 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 |
| J | 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 |
| K | 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 |
| L | VSZ (m/s) | Time-averaged shear-wave velocity to profile depth zp |
| M | Profile depth z_p (m) | Maximum depth of VS profile in meters |
| N | Measurement method | Geophysical method used for in situ measurement of VS profile or VS30 data. 1, SASW; 2, MASW; 3, microtremor array measurements (MAMs); 4, ambient vibration measurements; 5, P-wave refraction; 6, S-wave refraction; 7, downhole or crosshole; 8, P–S suspension logging; 9, seismic CPT; −999, unknown |
| O | Original reported VS30 (m/s) | VS30 per original source document |
| P | 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 |
| Q | 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 |
| R | 30 arcsec topographic slope (m/m) | Topographic gradient (i.e., ground slope) from SRTM30 DEM. −999, unassigned |
| S | Geologic unit | Geologic unit symbol based on geologic maps. See Table 3 of the main article. −999, unassigned |
| T | Geologic name | Geologic unit name based on geologic maps. See Table 3 of the main article. −999, unassigned |
| U | Geologic age | Geologic age of unit based on geologic maps. See Table 3 of the main article. −999, unassigned |
| V | Geologic description | Description of geologic unit based on geologic maps. See Table 3 of the main article. −999, unassigned |
| W | Original reported surface geology | Geologic unit from original VS source document, if provided. −999, not provided |
| X | 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 |
| Y | New geologic category per AhdiEA2017 | Simplified geologic category based on lithology or depositional environment, based on geologic units from maps |
| Z | 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 |
| AA | PNW geology group mean VS30 (m/s) | Mean VS30 from profiles within each geologic group (this study). See Table 4 in the main article |
| AB | 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 |
| AC | 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 |
| AD | 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 |
| AE | 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 |
| AF | Slope model coef. c1 | 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 | Terrain class per IP07 | Geomorphology-based terrain classes computed from SRTM30 DEM, per study from Iwahashi and Pike (2007) |
| AH | 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 |
| AI | 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 |
| AJ | 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 |
| AK | 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 |
| AL | 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 |
| AM | 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 |
| AN | Measured VS profile Z1.0 (m) | Depth to 1 km/s horizon in meters based on VS profile, if applicable |
| AO | Measured VS profile Z1.5 (m) | Depth to 1.5 km/s horizon in meters based on VS profile, if applicable |
| AP | Measured VS profile Z2.5 (m) | Depth to 2.5 km/s horizon in meters based on VS profile, if applicable |
| AQ | Z2.5 per Stephenson 2016 | Depth to 2.5 km/s horizon in meters based crustal velocity model of W. Stephenson (personal comm., 2016) |
| AR | Preferred Z2.5 (m) | Preference to Z2.5 from velocity profile, if available, otherwise taken from column AQ |
| AS | 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) |
| AT | Basin flag | Site assigned 1 if within basin based on limit of quaternary units of geologic maps of Table 3 in the main article; site assigned 0 if outside basins |
| AU | Basin name | Basin name, if applicable, of sites with flag = 1 in Basin Flag column |
| AV | VS (m/s) at z_p | Time-averaged shear-wave velocity to profile depth zp |
| AW | VSZ (m/s) at z = 6 m | Time-averaged shear-wave velocity to profile depth of 6 m, if zp ≥ 6 m |
| AX | VSZ (m/s) at z = 8 m | Time-averaged shear-wave velocity to profile depth of 8 m, if zp ≥ 8 m |
| AY | VSZ (m/s) at z = 10 m | Time-averaged shear-wave velocity to profile depth of 10 m, if zp ≥ 10 m |
| AZ | VSZ (m/s) at z = 12 m | Time-averaged shear-wave velocity to profile depth of 12 m, if zp ≥ 12 m |
| BA | VSZ (m/s) at z = 14 m | Time-averaged shear-wave velocity to profile depth of 14 m, if zp ≥ 14 m |
| BB | VSZ (m/s) at z = 16 m | Time-averaged shear-wave velocity to profile depth of 16 m, if zp ≥ 16 m |
| BC | VSZ (m/s) at z = 18 m | Time-averaged shear-wave velocity to profile depth of 18 m, if zp ≥ 18 m |
| BD | VSZ (m/s) at z = 20 m | Time-averaged shear-wave velocity to profile depth of 20 m, if zp ≥ 20 m |
| BE | VSZ (m/s) at z = 22 m | Time-averaged shear-wave velocity to profile depth of 22 m, if zp ≥ 22 m |
| BF | VSZ (m/s) at z = 24 m | Time-averaged shear-wave velocity to profile depth of 24 m, if zp ≥ 24 m |
| BG | VSZ (m/s) at z = 26 m | Time-averaged shear-wave velocity to profile depth of 26 m, if zp ≥ 26 m |
| BH | VSZ (m/s) at z = 28 m | Time-averaged shear-wave velocity to profile depth of 28 m, if zp ≥ 28 m |
| BI | VSZ (m/s) at z = 30 m | Time-averaged shear-wave velocity to profile depth of 30 m, if zp ≥ 30 m |
| BJ | VSZ (m/s) at z = 40 m | Time-averaged shear-wave velocity to profile depth of 40 m, if zp ≥ 40 m |
| BK | VSZ (m/s) at z = 50 m | Time-averaged shear-wave velocity to profile depth of 50 m, if zp ≥ 50 m |
| BL | VSZ (m/s) at z = 60 m | Time-averaged shear-wave velocity to profile depth of 60 m, if zp ≥ 60 m |
| BM | VSZ (m/s) at z = 70 m | Time-averaged shear-wave velocity to profile depth of 70 m, if zp ≥ 70 m |
| BN | VS30 comment | Comment on derivation of VS30 from VS profile; NA if PDB site was only provided as a VS30 value |
Throughout spreadsheet, −999 indicates unknown or unassigned value. CPT, cone penetration test; DEA13, Dai et al. (2013); DEMs, digital elevation maps; IP07, Iwahashi and Pike (2007); MASW, multichannel analysis of surface waves; NEHRP, National Earthquake Hazards Reduction Program; SASW, spectral analysis of surface waves; SDB, site database; SRTM30, Shuttle Radar Topography Mission (at 30 arcsec resolution); Y16, Yong (2016).
[ Back ]