spatial-relationship
SELECT kb_user.pt <-> hot_spring.pt as distance, hot_spring.name as spring, place.name as place FROM kb_user, hot_spring, place WHERE kb_user.name = 'shokai' and place.area ~ hot_spring.pt ORDER by distance asc;
SELECT kb_user.pt <-> hot_spring.pt as distance, hot_spring.name as spring, place.name as place FROM kb_user, hot_spring, place WHERE kb_user.name = 'shokai' and place.area ~ hot_spring.pt ORDER by distance asc;