#The Plan to fly Pennsylvania Airways
A brand new airline, Pennsylvania Airways, is celebrating its inaugural day of flights by giving away FREE tickets for 4 hours! But you have to buy your tickets at a Pennsylvania airport, they're so new there's no website yet. And right now you're all in New York City. How can we find out which airport we can drive to, and the route to take, before the sale ends?
- Geocode CARTO HQ with Geocoding API
- Make 2.5 hour isoline from CARTO HQ with Isolines API - got to get to the airport with time for security!
- Find airports in Pennsylvania
- Find those PA airports that intersect our isoline, and select the nearest one
- Create a route between CARTO and the Airport with our Routing API
- CartoDBfy our tables
- Make a map to get us there!
And since time is of the essence, let's do it all in one API request!
DATASETS:
https://team.carto.com/u/athompson/tables/states_table/public
https://team.carto.com/u/athompson/tables/ne_10m_airports/public
To drop and try again: