It’s good at all kinds of stuff that is search adjacent, “find amesent parks with water feature within 100 miles of me that have rv parking nearby”, etc
select l.id, l.name
from locations as l
where l.type = 'amusement_park'
and exists (
select id from locations as l2
where l2.type = 'rv_parking'
and distance(l2.geo, l.geo) < $nearby_distance
)
But what we should have is a good map software where you could filter by type and distance (How many amusement parks can be in that circle?) and quickly check if there's a RV parking nearby.The hard job is collecting the data.