YamaReco implemented a map search function for hiking records, using the GIS feature of MySQL

YamaReco is a Japanese web service that makes "you want to go to the mountain again".

The map search function for hiking records is implemented with Spatial Index and Spatial Function of MySQL to search fast. The MBRContains function is used in the standard search mode, and the ST_Contains function is used in the high accuracy search mode.