Data extract for external planning
Started by zeppelin, Sep 10 2019 07:09 PM
#1
Posted 10 September 2019 - 07:09 PM
Is there an easy way to extract your airline data for external planning. Like a CSV file that you can work with in excel either full dump for your airline or query based?
#2
Posted 10 September 2019 - 07:16 PM
I am looking for something smoother than cut and paste if possible.
#3
Posted 15 September 2019 - 02:13 PM
#4
Posted 21 September 2019 - 12:27 AM
Your only option is to scrape the loaded webpages and then guess/calculate the data.
This page: http://ae31.airline-...y=&map=Show Map
has a javascript that places the airports on the map.
i.e.
point = new GLatLng(-0.0166666666667,98.2833333333); marker = new GMarker(point, { icon: airportIcon, title: '(LKS/WIMO) Lasondre 1 of 1 gates available Monthly Cost: $93 Runway Length: 4,593ft Click to Rent' }); marker.value = 5; GEvent.addListener(marker, 'click', function() { location.href= '/rentgate.php?region=&country=&city=&rangemin=0&rangemax=0&lease=LKS'; }); map.addOverlay(marker);
That gets you the GPS Co-ords and the Airport Code with some other simple information.
You can then use: http://ae31.airline-...1=SYD&city2=LAX
to research routes to calculate how many PAX/Demand/Default Pricing based on Distance and Time (Demand varies throughout the year)
If you build an Excel sheet or Access database, you should be able to get almost every bit of information available.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users