**3.2 Selection of boring logs and analysis by Shake**

In this research, XML data of boring log is obtained from the national land information retrieval site "Kunijiban" [2]. The coordinate values and data in the data are saved in SQL in advance, and the closest ground data is acquired from the data corresponding to the search near the area of 200 m, and the data is analyzed. The data of the boring log obtained by this is automatically generated according to the input specifications for Shake, and the surface seismic motion is generated. In addition, the shear wave velocity is input at the time of input, but in this study, the commonly used formula shown in the road bridge specification was used to estimate Vs (**Figure 4**).
