Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Maptime Seattle Postgis - Problem 2
SELECT a.name, ST_Distance(c.geom, a.geom, true) * 0.000621371 AS distance_as_miles
FROM geo.cities_ne c
CROSS JOIN transport.airports_ne a
WHERE c.name = 'Seattle'
ORDER BY ST_Distance(c.geom, a.geom, true) ASC
LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment