UCLA

We describe the data model that we intend to use in a publicly available site profile database under development for the United States. The initial implementation of the database contains data from California. Currently, our prototype data model consists of JavaScript Object Notation (JSON) format files for storing metadata and data. For a site to be included in the database, the minimum metadata requirements are geodetic coordinates and elevation values, and the minimum data requirement is a shear-wave velocity profile. The JSON files are structured in a hierarchal manner to store metadata and data using a nested structure consisting of location, velocity profiles, dispersion curve data (for surface-wave methods), geotechnical data, and horizontal-to-vertical spectral ratios. The database schema at the current stage of the project, and as we continue to develop the data model we will consider including other relevant data, as well as evaluate other file formats to increase the efficiency of data storage and querying. In the current data model, location information includes site geodetic values (latitude, longitude, and elevation) and various site descriptors related to surface geology, geomorphic terrain category, slope gradient at various resolutions, and a geotechnical site category. Velocity data include the geophysical method(s) used to obtain the shear-wave velocity profile, type of data recorded, modeled primary- and shear-wave velocity as a function of depth, modeled profile maximum depth, and the calculated VS30 value. In the case of surface-wave based data, dispersion curve data can be recorded in data structure as phase velocity versus either wavelength or frequency. Geotechnical data includes boring logs penetration resistance, cone penetration test sounding logs, and laboratory index test results. Horizontal-to-vertical spectral ratio plots are given as a function of frequency.