The objective of this research is to develop the methodology for analysis and implement of the geological hazard prone area in the Taipei metropolis on the basis of borehole databases. The methodology is achieved by developing a user-friendly oriented source code with the Visual Basic language. The evaluation and classification in the geological hazard prone area in this source code can identify the potential risk caused by the geological hazard prone area in the Taipei metropolis to mitigate the loss due to natural hazard.