It is currently Sun Nov 19, 2017 7:35 pm




 Page 8 of 9 [ 132 posts ]  Go to page Previous  1 ... 5, 6, 7, 8, 9  Next
Author Message
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Sat Oct 29, 2011 5:09 am 
Site Admin
User avatar

Joined: Thu Sep 16, 2004 6:14 am
Posts: 1511
Location: Brockville, ON
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:



_________________
Darryl Brambilla
CVA Big Dog / Head Cheese
a.k.a. - President & CEO
CVA7769
Image
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Sat Oct 29, 2011 6:01 am 
User avatar

Joined: Sat Mar 08, 2008 7:59 pm
Posts: 927
Location: Kelowna, BC
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.



_________________
GTX, UTX, Pacific Fjord, Pacific Northwest, NRM, CRM, Tongass Fjord, AUSP4, YBBN, YBCS, YBUD, YPEC, YHBA, KORS, 7S3, 1S2, 3W5, WA56, WA79, KCMW, 1WA6, Vancouver+
Image....ImageImage
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Sat Oct 29, 2011 4:53 pm 
User avatar

Joined: Tue Dec 01, 2009 1:26 am
Posts: 583
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



_________________
Image Image
Global+Vector,FS_G 2010,REX4,NRM,CRM,PFJ,PNW,SAK,NCA,Tong_Fjords
0S9,3W5,7S3,KCMW,KORS,PAKT,WA56,WA79,W52,PAGS,PAJN,CZST
+Portland City,2S1,CEN4,CEJ4,KHQM,7WA3,CBB7,KPDX
G_NA packs 1-8,EDBH
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Sat Oct 29, 2011 10:04 pm 
User avatar

Joined: Fri Feb 27, 2009 1:39 am
Posts: 1892
Location: Up here wishing I was down there.
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.



_________________
i7-6700K @ 4.2GHz, G SKILL DDR4 32GB @ 3200MHz
ASUS MAXIMUS VIII Formula, EK triple watercooling
ASUS dual GTX950 OC STRIX, HyperX Cloud II headset
SAMSUNG SSD 850 EVO 250GB and 500GB
EVGA Supernova G2 850W, CORSAIR Obsidian 750D
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Sat Oct 29, 2011 10:21 pm 
User avatar

Joined: Fri Feb 27, 2009 1:39 am
Posts: 1892
Location: Up here wishing I was down there.
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.



_________________
i7-6700K @ 4.2GHz, G SKILL DDR4 32GB @ 3200MHz
ASUS MAXIMUS VIII Formula, EK triple watercooling
ASUS dual GTX950 OC STRIX, HyperX Cloud II headset
SAMSUNG SSD 850 EVO 250GB and 500GB
EVGA Supernova G2 850W, CORSAIR Obsidian 750D
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Sun Oct 30, 2011 6:04 am 
User avatar

Joined: Fri Feb 27, 2009 1:39 am
Posts: 1892
Location: Up here wishing I was down there.
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



_________________
i7-6700K @ 4.2GHz, G SKILL DDR4 32GB @ 3200MHz
ASUS MAXIMUS VIII Formula, EK triple watercooling
ASUS dual GTX950 OC STRIX, HyperX Cloud II headset
SAMSUNG SSD 850 EVO 250GB and 500GB
EVGA Supernova G2 850W, CORSAIR Obsidian 750D
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Mon Oct 31, 2011 11:43 pm 
User avatar

Joined: Mon Apr 12, 2010 12:31 pm
Posts: 200
Location: Guadeloupe
Good evening,

Robert,

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

JC

CVA 0485



_________________
ImageImage
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Tue May 01, 2012 8:49 am 
User avatar

Joined: Mon Apr 30, 2012 10:32 am
Posts: 116
Location: YPJT
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



_________________
Image Image
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Tue May 01, 2012 10:52 am 
Site Admin
User avatar

Joined: Wed Dec 15, 2004 2:03 am
Posts: 1515
Location: Montreal, Quebec
Yes you can, Welcome to CVA Ryan



_________________
My two cents! OOOps they don’t make cents anymore then my two nickels.
Image
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Tue Dec 04, 2012 2:56 am 
User avatar

Joined: Fri Feb 27, 2009 1:39 am
Posts: 1892
Location: Up here wishing I was down there.
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!



_________________
i7-6700K @ 4.2GHz, G SKILL DDR4 32GB @ 3200MHz
ASUS MAXIMUS VIII Formula, EK triple watercooling
ASUS dual GTX950 OC STRIX, HyperX Cloud II headset
SAMSUNG SSD 850 EVO 250GB and 500GB
EVGA Supernova G2 850W, CORSAIR Obsidian 750D
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Tue Dec 04, 2012 2:57 am 
User avatar

Joined: Fri Feb 27, 2009 1:39 am
Posts: 1892
Location: Up here wishing I was down there.
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!



_________________
i7-6700K @ 4.2GHz, G SKILL DDR4 32GB @ 3200MHz
ASUS MAXIMUS VIII Formula, EK triple watercooling
ASUS dual GTX950 OC STRIX, HyperX Cloud II headset
SAMSUNG SSD 850 EVO 250GB and 500GB
EVGA Supernova G2 850W, CORSAIR Obsidian 750D
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Tue Dec 04, 2012 5:44 am 
User avatar

Joined: Fri Feb 27, 2009 1:39 am
Posts: 1892
Location: Up here wishing I was down there.
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!



_________________
i7-6700K @ 4.2GHz, G SKILL DDR4 32GB @ 3200MHz
ASUS MAXIMUS VIII Formula, EK triple watercooling
ASUS dual GTX950 OC STRIX, HyperX Cloud II headset
SAMSUNG SSD 850 EVO 250GB and 500GB
EVGA Supernova G2 850W, CORSAIR Obsidian 750D
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Tue Dec 04, 2012 10:49 am 

Joined: Wed Aug 22, 2012 5:35 am
Posts: 88
Location: EFHK Finland
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



_________________
Image
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Tue Dec 04, 2012 5:31 pm 
User avatar

Joined: Mon Feb 14, 2011 2:00 pm
Posts: 257
Location: Las Vegas AOR
Ah ha CVA Santa bought me some nice new shiny Arctic Routes :D



_________________
Capt. Tim H. USN NAS Fallon VFC13 Det C assigned to KLAS Mil. Sect. Alert Flt.
ImageImage
Image
CVA Prepar3D V2.4 Military and Pro Plus and Academic Pilot -- Windows 8.1
Offline
 Profile  
 
 Post subject: Re: Class of Aircraft / Routes
PostPosted: Thu Dec 06, 2012 5:18 am 
User avatar

Joined: Sat May 19, 2001 10:14 pm
Posts: 329
Location: Whitehorse YT
Thanks, Robert, for the new routes.
I think a good class 1 route would be CYXY to PAJN and return.
:)



_________________
Harry CVA1951
If I'm not flying then I'll be riding!
Image
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 8 of 9 [ 132 posts ]  Go to page Previous  1 ... 5, 6, 7, 8, 9  Next


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

cron