3 ms·
Pseudo SQL select l.id, l.name from locations as l where l.type = 'amusement_park' and exists ( select id from locations as l2
by skydhash 2mo ago
Pseudo SQL
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.