Canadian Virtual Airlines
https://canadianva.com/forum/

Class of Aircraft / Routes
https://canadianva.com/forum/viewtopic.php?f=1&t=1408		 Page 8 of 9
Author:  CVA7769 [ Sat Oct 29, 2011 5:09 am ]
Post subject:  Re: Class of Aircraft / Routes
CVA0014 wrote:
I loaded Canadian routes with return flights on Google Fusion Tables.

http://www.google.com/fusiontables/DataSource?snapid=S304087kqac

Click on red dot for Airport information.

To filter hubs and classes, click on OPTIONS beside Showing all rows at top left.

Click on dropdown (Airport by default), and chose Hub or Class.

Hubs:
H = Halifax
M = Montreal
T = Toronto
V = Vancouver
C = Cargo

Classes: 1, 2, 3, 4 and 5

Click APPLY to see results.

You can click Add Condition for combined filters like Hub=M Class=1 to see all class 1 routes in Montreal hub.

EDIT: Added City and Country to airports.


NOTE: I'm looking into adding a label to the lines (Route and return flight).



AWESOME!!!!!! :mrgreen:
Author:  Cal Jordan (CVA371) [ Sat Oct 29, 2011 6:01 am ]
Post subject:  Re: Class of Aircraft / Routes
Good Job! but I did notice that in city mode there is a few errors, Dryden is in Texas, and Victoria Harbor is in China,
I think we will have to change to flight time for routes to Dryden.... :lol: But it will be a nice tool to use.
Author:  CVA0319 [ Sat Oct 29, 2011 4:53 pm ]
Post subject:  Re: Class of Aircraft / Routes
Robert,
This is great stuff! Must have taken hours and hours to pull off, thanks for what looks to be a tireless effort on the part of yourself and all involved!

Gary
Author:  CVA0014 [ Sat Oct 29, 2011 10:04 pm ]
Post subject:  Re: Class of Aircraft / Routes
You're welcome. It took a few days, there's a lot of batch file manipulation and BASIC programming to get the CSV upload file just the way Google wants it.

I had never done this map stuff before and I'm only scratching the surface. I'm just using the upload feature, there's a KML feature which gives much more flexibility. But like anything, more flexibility means more complexity for the programmers, more learning.

I don't like having to be dependant on Chuck for a Airport download, there's no automated feature on the software we are using to manage the database. I can download routes, but not the airports.

I'd like to figure out how to interface with FS Commander for the coordinates; that would have much better descriptions of the airports, I wouldn't have to bother Chuck for a new download and up-to-date information as well.

Yeah, don't select City for the LOCATION dropdown. Google uses it's own search engine instead of the coordinates provided:
- CZBF Bathurst ends up in Bathurst, Australia.
- CYWH Victoria Harbour ends up in Victoria Harbour, Hong Kong
- CYYH Spence Bay ends up as Spencer Bay Street, South Africa.
- CYHD Dryden Airport ends up in Dryden Airport, Texas.
- CYHM Hamilton ends up in McConnell AFB, Kansas. WTF?
- CYAY Saint-Anthony Airport ends up in St Anthony Lane, Missouri.
- CYEU Eureka ends up in Eureka Hill Road, Pennsylvania.
- CYUX Hall Beach ends up in Whitehall Beach Road, Maryland.
- CYGV Havre St Pierre ends up in St Pierre, Montana.

I have an idea what to do to stop Google from doing that.
Author:  CVA0014 [ Sat Oct 29, 2011 10:21 pm ]
Post subject:  Re: Class of Aircraft / Routes
I concatenated City and Country into Location.

Only 2 airports still get hyperspaced if your try to use LOCATION in the Location dropdown:
- CZBF Bathurst is still in Australia.
- CYVO Val D'Or is in Spain.

This is as good as it's going to get. We only need Routes mode anyways.
Author:  CVA0014 [ Sun Oct 30, 2011 6:04 am ]
Post subject:  Re: Class of Aircraft / Routes
Cal Jordan (CVA371) wrote:
... it will be a nice tool to use.



Yup, I like it 'cause it helps me see at a glance where I have gaps in the routes. I'm a visual person, having a list of airports doesn't give me a good indication. Like Montreal class 4 routes, I can't hop province to province straight across Canada, yet:

Image
Author:  jcrollé [ Mon Oct 31, 2011 11:43 pm ]
Post subject:  Re: Class of Aircraft / Routes
Good evening,

Robert,

Congratulations for this very good job, it helps me a lot.
Again, congratulations to the CVA Management.

JC

CVA 0485
Author:  cva1077 [ Tue May 01, 2012 8:49 am ]
Post subject:  Re: Class of Aircraft / Routes
Hi,

I was just wondering whether it would be acceptable to use the PMDG BAe Jetstream 4100 on routes suggested for the DHC-8-200?

Thanks
Author:  CVA9214 [ Tue May 01, 2012 10:52 am ]
Post subject:  Re: Class of Aircraft / Routes
Yes you can, Welcome to CVA Ryan
Author:  CVA0014 [ Tue Dec 04, 2012 2:56 am ]
Post subject:  Re: Class of Aircraft / Routes
New class 1 routes for Vancouver hub:

CVA6121 (1S2 to 1WA6)
CVA6122 (1WA6 to 1S2)
CVA6123 (1WA6 to 2S1)
CVA6124 (2S1 to 1WA6)
CVA6125 (7S3 to KHQM)
CVA6126 (KHQM to 7S3)
CVA6127 (KHQM to 2WA1)
CVA6128 (2WA1 to KHQM)
CVA6129 (CYXS to CAV4)
CVA6130 (CAV4 to CYXS)
CVA6131 (CAV4 to CAH4)
CVA6132 (CAH4 to CAV4)
CVA6133 (CAH4 to CYCP)
CVA6134 (CYCP to CAH4)
CVA6135 (CYCP to CYRV)
CVA6136 (CYRV to CYCP)
CVA6137 (CYRV to CYGE)
CVA6138 (CYGE to CYRV)
CVA6139 (CYGE to CAA8)
CVA6140 (CAA8 to CYGE)
CVA6141 (CAA8 to CEN4)
CVA6142 (CEN4 to CAA8)
CVA6143 (CEN4 to CZPC)
CVA6144 (CZPC to CEN4)
CVA6145 (CZST to PAKT)
CVA6146 (PAKT to CZST)


Enjoy!
Author:  CVA0014 [ Tue Dec 04, 2012 2:57 am ]
Post subject:  Re: Class of Aircraft / Routes
New class 2 routes for Vancouver hub:

CVA6243 (CYPR to CYXS)
CVA6244 (CYXS to CYPR)
CVA6245 (CYYC to CYCG)
CVA6246 (CYCG to CYYC)
CVA6247 (CYCG to CYXS)
CVA6248 (CYXS to CYCG)
CVA6249 (PAFA to PANC)
CVA6250 (PAJN to CYXT)
CVA6251 (CYXT to PAJN)
CVA6252 (CYYC to CYQL)


Enjoy some more!
Author:  CVA0014 [ Tue Dec 04, 2012 5:44 am ]
Post subject:  Re: Class of Aircraft / Routes
Updated class 3 routes for Vancouver hub:

Imported CVA6401 (CYEG to CYVR)
Imported CVA6402 (CYYC to CYYZ)
Imported CVA6403 (CYYZ to CYYC)
Imported CVA6404 (CYVR to CYYZ)
Imported CVA6405 (CYYZ to CYVR)
Imported CVA6406 (CYVR to CYXY)
Imported CVA6407 (CYXY to CYVR)
Imported CVA6408 (CYYC to KDFW)
Imported CVA6409 (KDFW to CYYC)
Imported CVA6410 (CYVR to KORD)
Imported CVA6411 (KORD to CYVR)
Imported CVA6412 (CYVR to KIAH)
Imported CVA6413 (KIAH to CYVR)
Imported CVA6414 (CYVR to KPHX)
Imported CVA6415 (KPHX to CYVR)
Imported CVA6416 (PANC to CYVR)
Imported CVA6417 (CYVR to PANC)
Imported CVA6418 (KORD to KLGA)
Imported CVA6421 (KLGA to KORD)
Imported CVA6419 (KBOS to KORD)
Imported CVA6420 (KORD to KBOS)
Imported CVA6422 (KDFW to KATL)
Imported CVA6423 (KATL to KDFW)
Imported CVA6424 (CYVR to CYWG)
Imported CVA6425 (CYWG to CYVR)
Imported CVA6426 (CYVR to KDEN)
Imported CVA6427 (KDEN to CYVR)
Imported CVA6437 (CYVR to KSLC)
Imported CVA6428 (KSLC to CYVR)
Imported CVA6429 (KAUS to KDFW)
Imported CVA6436 (KDFW to KAUS)
Imported CVA6430 (KDFW to KSFO)
Imported CVA6431 (KSFO to CYVR)


New class 3 routes for Vancouver hub:

Imported CVA6435 (CYVR to CYED)
Imported CVA6438 (CYFB to CYZF)
Imported CVA6439 (CYZF to CYFB)
Imported CVA6440 (CYZF to CYXY)
Imported CVA6441 (CYXY to CYZF)
Imported CVA6442 (CYXY to CYVR)
Imported CVA6443 (CYVR to CYXY)
Imported CVA6444 (CYVR to CYYC)
Imported CVA6445 (CYYC to CYVR)
Imported CVA6446 (CYYC to CYXE)
Imported CVA6447 (CYXE to CYYC)
Imported CVA6448 (CYXE to CYWG)
Imported CVA6449 (CYWG to CYXE)
Imported CVA6450 (CYWG to CYOW)
Imported CVA6451 (CYOW to CYWG)
Imported CVA6452 (CYXY to CYQH)
Imported CVA6453 (CYQH to CYXY)
Imported CVA6454 (CYXY to CYOC)
Imported CVA6455 (CYOC to CYXY)
Imported CVA6456 (CYXY to CYDA)
Imported CVA6457 (CYDA to CYXY)
Imported CVA6458 (CYVR to CYYE)
Imported CVA6459 (CYYE to CYVR)
Imported CVA6460 (CYVR to CYPR)
Imported CVA6461 (CYPR to CYVR)
Imported CVA6462 (CYVR to CYXT)
Imported CVA6463 (CYXT to CYVR)
Imported CVA6464 (CYVR to CYXJ)
Imported CVA6465 (CYXJ to CYVR)
Imported CVA6466 (CYYC to CYEG)
Imported CVA6467 (CYEG to CYYC)
Imported CVA6468 (CYYC to CYQU)
Imported CVA6469 (CYQU to CYYC)
Imported CVA6470 (CYYC to CYMM)
Imported CVA6471 (CYMM to CYYC)
Imported CVA6472 (CYYC to CYOD)
Imported CVA6473 (CYOD to CYYC)
Imported CVA6474 (CYXE to CYPA)
Imported CVA6475 (CYPA to CYXE)
Imported CVA6476 (CYXE to CYQR)
Imported CVA6477 (CYQR to CYXE)
Imported CVA6478 (CYWG to CYQD)
Imported CVA6479 (CYQD to CYWG)
Imported CVA6480 (CYWG to CYYQ)
Imported CVA6481 (CYYQ to CYWG)
Imported CVA6482 (CYZF to CYEV)
Imported CVA6483 (CYEV to CYZF)
Imported CVA6484 (CYZF to CYOA)
Imported CVA6485 (CYOA to CYZF)
Imported CVA6486 (CYZF to CYYQ)
Imported CVA6487 (CYYQ to CYZF)
Imported CVA6488 (CYFB to CYUX)
Imported CVA6489 (CYUX to CYFB)
Imported CVA6490 (CYFB to CYBK)
Imported CVA6491 (CYBK to CYFB)
Imported CVA6492 (CYFB to CYLT)
Imported CVA6493 (CYLT to CYFB)
Imported CVA6494 (CYFB to CYRT)
Imported CVA6495 (CYRT to CYFB)
Imported CVA6496 (CYFB to CYRB)
Imported CVA6497 (CYRB to CYFB)
Imported CVA6498 (CYOW to CYFB)
Imported CVA6499 (CYFB to CYOW)
Imported CVA6500 (CYRT to CYZF)
Imported CVA6501 (CYZF to CYRT)
Imported CVA6502 (CYZF to CYXY)
Imported CVA6503 (CYXY to CYZF)
Imported CVA6504 (CYXY to CYYC)
Imported CVA6505 (CYYC to CYXY)
Imported CVA6506 (CYYC to CYVR)
Imported CVA6507 (CYVR to CYYC)
Imported CVA6508 (CYVR to CYZF)
Imported CVA6509 (CYZF to CYVR)
Imported CVA6510 (CYRT to CYWG)
Imported CVA6511 (CYWG to CYRT)
Imported CVA6512 (CYEV to CYRB)
Imported CVA6513 (CYRB to CYEV)
Imported CVA6514 (CYRB to CYLT)
Imported CVA6515 (CYLT to CYRB)
Imported CVA6516 (CYFB to CYHZ)
Imported CVA6517 (CYHZ to CYFB)
Imported CVA6518 (CYFB to CYHK)
Imported CVA6519 (CYHK to CYFB)
Imported CVA6520 (CYHK to CYCB)
Imported CVA6521 (CYCB to CYHK)
Imported CVA6522 (CYCB to CYZF)
Imported CVA6523 (CYZF to CYCB)
Imported CVA6524 (CYXY to CYVR)
Imported CVA6525 (CYVR to CYXY)
Imported CVA6526 (CYVR to KASE)
Imported CVA6527 (KASE to CYVR)
Imported CVA6528 (YSSY to YBBN)
Imported CVA6529 (YBBN to YSSY)
Imported CVA6530 (YSSY to YBCS)
Imported CVA6531 (YBCS to YSSY)
Imported CVA6532 (YSSY to YMML)
Imported CVA6533 (YMML to YSSY)
Imported CVA6534 (YSSY to YPPH)
Imported CVA6535 (YPPH to YSSY)

Have fun!
Author:  CVA1175 [ Tue Dec 04, 2012 10:49 am ]
Post subject:  Re: Class of Aircraft / Routes
A lot of new routes! Wow. Thank You.

I have one wish: whenever you have the time and passion there are the CYVR-KOTH North Bend-KACV Arcata-KSFO and vice versa flights missing from the Vancouver hub flights. I sincerely think that CVA pilots should have the possibility to fly and see the giant Humboldt redwoods in Northern California... If possible I would love these routes in both class 1 and 2.

If the Santa brings me the 27 inch monitor and the PMDG 737 NGX and these routes my Christmas would be more than perfect.

Jaakko
Author:  CAF440 [ Tue Dec 04, 2012 5:31 pm ]
Post subject:  Re: Class of Aircraft / Routes
Ah ha CVA Santa bought me some nice new shiny Arctic Routes :D
Author:  mhooner [ Thu Dec 06, 2012 5:18 am ]
Post subject:  Re: Class of Aircraft / Routes
Thanks, Robert, for the new routes.
I think a good class 1 route would be CYXY to PAJN and return.
:)
Page 8 of 9 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/