Airports and heliports in a country, for my consultancy
Every airport and heliport in your countries, in a sheet and on a map.
What it does
Every year: the airports, regional airports and heliports in your countries, with phone and website, kept in a sheet and on a map for the aviation consultancy.
In one sentence: Monthly on the 1st at 08:00, in Nairobi, Kampala and 2 more, find airports, international airports and 2 more in the area, remove duplicates, then add row in Google Sheets, email the list to you and show them on a map.
Why it is useful
Aviation consultants need a current list of airports. It refreshes itself every year.
Who it is for
Airports, airlines & aviation. Airports, airlines, flight schools, maintenance and aviation services planning routes, partners and passengers’ journeys. Every use case for airports & aviation
Best use cases
- An aviation consultancy
- An aviation fuel supplier
- A drone operator
What each run gives you
- A Google Sheet
- A map
The time it saves
Monthly on the 1st at 08:00. Doing the same work by hand takes about 60 minutes each time; it runs about 1 time a month, so it saves about 1 hours a month (an estimate). It is medium: 7 blocks.
The flow, block by block
- On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
- Our countriesWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
- Airports and heliportsxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
- Each airport onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
- Update the airports sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
- Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.
- Email me the resultsAction · EmailSends one email per run with all the items, or one email per item.
Every block can be changed after you use the template: the city, the type of place, the score, where the results go.
Use it now
Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.
How to set it up
- The xMap Flows browser extension: what is around this business: On a company’s website or a place on a map, one click shows its market and the AI employees to hire for it.
- Build your first flow in ten minutes: From a blank page to a flow that emails you a ranked list every morning.
- What xMap remembers about your company: Your city, industry and what you sell, filled in for you and always yours to change.
- Ask the map a question: How many of a kind of place, how many people for each, and where the gaps are, answered on the spot.
- Location intelligence: Using where things are, and what is around them, to make business decisions.
- POI data (points of interest): Records of places such as shops, clinics and offices, with their category, position and details.
- Catchment area: The area a store or service draws its customers from.
More for Airports, airlines & aviation
- Travel agencies for my airline’s agency sales: Travel agencies scored as partners, with the owner.
- Hotels for my airline’s stopover programme: Hub hotels scored for a stopover package, approved.
- Freight forwarders near the airport, for air cargo sales: Forwarders near the airport scored as air cargo customers.
- Hospitals near heliports, for air ambulance partnerships: Hospitals near each heliport, with the medical director.
- Hour-by-hour wind and rain for ground handling: The hours with the strongest wind and rain, for ground handling.
- Flight schools for my simulator and parts sales: Flight schools with the head of training, for simulators and parts.