Data Structure of Ground Deformation Database

Figure 1 shows the file system and directory structure used to store information on the selected case history of ground deformation.

Figure 1. Data structure for case history of ground deformation

Information on case history is stored in  4 subdirectories:

• Aerial photos: Scanned aerial photos after earthquake
• Boreholes: Geotechnical information on soil deposits
• Displacements: Measured displacement vectors
• Geological Maps: Scanned geological maps
• GIS files: Files for GIS analysis

Aerial Photos
Excel workbook AerialPhotos.xls in the directory Aerial Photos summarizes information on aerial photos.

Boreholes & Displacements
Excel workbook DataSummary.xls summarizes information on boreholes and displacements. It also contains earthquake information.
DataSummary.xls has seven worksheets:

• Definitions: Terms used to characterize boreholes
• GISMap: Graphic display of boreholes and displacement vectors location
• Summary: Total number of boreholes and displacement vectors
• Boreholes: Coordinates, types, files, and references for boreholes
• Displacements: Coordinate, magnitude of deformation
• Earthquake: Earthquake information
• References: List of references about boreholes

Directory Original data contains scanned data used to generate digital version of boreholes.
Directory Processed data contains Excel files and graphics of boreholes.  

Geological Maps
Excel workbook GeologyMaps.xls in the directory Geological Maps summarizes information on geological maps.  

GIS files
Excel workbook GISFiles.xls in the directory GIS Files summarizes information on GIS files. GIS files are usable with Arcview and ArcInfo. GISFiles.xls has three worksheets:

• Definitions: Terms used to characterize GIS files
• Summary: List of GIS files

There are two types of GIS files:

• Basemaps: Maps to georefence spatial data
• DEM: Digital Elevation Model

Directory BaseMaps contains base maps that are GIS enabled.
Directory DEM contains DEM files to generate topography.