In this paper, a mechanism of implementing visualization with level of detail (LoD) at multi-scale is proposed on spatial database. Based on the spatial index V-Reactive tree, different LoDs can be represented, at the same time generalization at multi-scale can be implemented. Furthermore, the perspective query algorithm can decrease the complexity of implementing the mechanism. According to the characteristics of 3D visualization, the index tree is optimized for better image quality. The experimental results show that the mechanism is fit for 3D GIS applications with mass data.