Jump to content

Photo

Data extract for external planning

- - - - -

  • Please log in to reply
3 replies to this topic

#1
zeppelin

zeppelin

    New Member

  • Member
  • 3 posts
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
zeppelin

zeppelin

    New Member

  • Member
  • 3 posts
I am looking for something smoother than cut and paste if possible.

#3
KJS607

KJS607

    The O.G. Savage

  • Member
  • 3,860 posts
  • Website:https://www.thetravelsavage.com/

User's Awards

6       3   

nope.


msg-1341-0-50048700-1680446869_thumb.png

 

I did a thing: thetravelsavage.com

 


#4
PiggyWhiskey

PiggyWhiskey

    AE Player

  • Member
  • 80 posts

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