I delve into the strategic use of historical accident data to identify high-risk zones. This session showcases how the Bangkok Metropolitan Administration has employed GIS analysis on historical accident data to pinpoint areas with a higher incidence of accidents. The insights derived from this analysis inform targeted physical improvements, contributing to a safer urban environment. Additionally, I investigate the power of analyzing retrospective traffic data to identify congestion hotspots. By examining historical traffic patterns, we pinpoint road segments experiencing the highest congestion. This granular understanding enables informed decision-making in urban planning and traffic management, offering practical solutions to alleviate congestion. These insights are derived from GIS and Map API.