Jump to content

 
Photo

Flight Routes of the World

- - - - -

  • Please log in to reply
8 replies to this topic

#1
Michael Markieta

Michael Markieta

    Contributor

  • Validated Member
  • PipPip
  • 23 posts
  • Canada

Just have to say that there is a lot of people mapping out these "global connections" types of maps and that I'm not in fact trying to steal anyones idea... seriously! But anyways, here is what I have for you to take a look at.

Tutorial and Map located on my blog:

http://www.spatialan...-flight-routes/

I've also attached the map here.

I am posting this not only for critique, but also to let those out there who are looking to work with the openflights.org data that I've written a little something on how to massage (read: handle and manipulate) the data.

Cheers!

Michael Markieta
Research Assistant - Department of Geography @ Ryerson University
B.A. Candidate - Geographic Analysis
Ryerson University
Toronto, ON, Canada

Attached Files


Michael Markieta - www.spatialanalysis.ca
Research Assistant - Department of Geography @ Ryerson University
B.A. Candidate - Geographic Analysis
Ryerson University
Toronto, ON, Canada

#2
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,900 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

Looks nice! I also appreciate the tutorial you've written up.

I was going to suggest maybe adding very faint shorelines, but quite frankly, I think the map doesn't need that.
Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics

#3
Michael Markieta

Michael Markieta

    Contributor

  • Validated Member
  • PipPip
  • 23 posts
  • Canada

Thanks Hans, I appreciate your response! I was going to add the shorelines or a solid black fill for the continents but I decided not to interfere with the visual impact of the flights creating the shorelines as they so naturally do.

In regards to the tutorial, you're very welcome! :) I had a great time working with the data and hope others will find it usefull.

Cheers,

Michael

Looks nice! I also appreciate the tutorial you've written up.

I was going to suggest maybe adding very faint shorelines, but quite frankly, I think the map doesn't need that.


Michael Markieta - www.spatialanalysis.ca
Research Assistant - Department of Geography @ Ryerson University
B.A. Candidate - Geographic Analysis
Ryerson University
Toronto, ON, Canada

#4
GrantH

GrantH

    Contributor

  • Validated Member
  • PipPip
  • 12 posts
  • United States

I am trying to duplicate this as a personal learning experience, but when I delete all the #N/A accounts within the database I only have 17,699 entries left. I sorted each column and deleted any of the #N/A occurrence; is this correct?


Beautiful map by the way.

#5
Michael Markieta

Michael Markieta

    Contributor

  • Validated Member
  • PipPip
  • 23 posts
  • Canada

I am trying to duplicate this as a personal learning experience, but when I delete all the #N/A accounts within the database I only have 17,699 entries left. I sorted each column and deleted any of the #N/A occurrence; is this correct?


Beautiful map by the way.


That's correct. I am not sure where you might be running into trouble.

You can send me an email with the spreadsheet if you like
michael[at]spatialanalysis[dot]ca

It sounds as if the lookup isn't returning all the values.

Cheers,

Michael
Michael Markieta - www.spatialanalysis.ca
Research Assistant - Department of Geography @ Ryerson University
B.A. Candidate - Geographic Analysis
Ryerson University
Toronto, ON, Canada

#6
NeillG

NeillG

    Newbie

  • Validated Member
  • Pip
  • 5 posts
  • Gender:Male
  • New Zealand

I am trying to duplicate this as a personal learning experience, but when I delete all the #N/A accounts within the database I only have 17,699 entries left. I sorted each column and deleted any of the #N/A occurrence; is this correct?


Beautiful map by the way.


I also thought I would try to duplicate this exercise using Manifold v8. I found I needed to copy all the values and paste special as values only after using the vlooup.
I then ended up with around 58000 records once cleaned.

#7
Michael Markieta

Michael Markieta

    Contributor

  • Validated Member
  • PipPip
  • 23 posts
  • Canada

I am trying to duplicate this as a personal learning experience, but when I delete all the #N/A accounts within the database I only have 17,699 entries left. I sorted each column and deleted any of the #N/A occurrence; is this correct?


Beautiful map by the way.


I also thought I would try to duplicate this exercise using Manifold v8. I found I needed to copy all the values and paste special as values only after using the vlooup.
I then ended up with around 58000 records once cleaned.



This is a good point, thanks for adding that!

I'd love to see your results, if any?
Michael Markieta - www.spatialanalysis.ca
Research Assistant - Department of Geography @ Ryerson University
B.A. Candidate - Geographic Analysis
Ryerson University
Toronto, ON, Canada

#8
A. Fenix

A. Fenix

    Analisa Fenix

  • Validated Member
  • PipPipPipPip
  • 175 posts
  • Gender:Female
  • Location:Cascadia
  • Interests:Cartography, PGIS, PPGIS, GIS, Urban/regional Planning, Conservation, Biodiversity/Cultural Diversity, Travel, History, Ecology, Geography, Biking, Gardening, Cooking, Physics, Permaculture, Sky diving, Green Roofs, Music (creating and enjoying), Photography, Carpentry, Film making, Writing...
  • No Country Selected

I love this simple elegance of this map. I agree with Hans that my initial response was to add some subtle geographic identifiers for those map viewers who are not as geographically versed as the rest of us. Perhaps just a few place names would be a helpful addition.

I'm looking forward to seeing more of your work and attempting this little mapping exercise myself thanks to your tutorial.

Great job!
Analisa Fenix
GIS Manager/Chief Cartographer
Ecotrust

#9
Michael Markieta

Michael Markieta

    Contributor

  • Validated Member
  • PipPip
  • 23 posts
  • Canada

I love this simple elegance of this map. I agree with Hans that my initial response was to add some subtle geographic identifiers for those map viewers who are not as geographically versed as the rest of us. Perhaps just a few place names would be a helpful addition.

I'm looking forward to seeing more of your work and attempting this little mapping exercise myself thanks to your tutorial.

Great job!


Cheers! I appreciate your input :D

Shoot me an email if you have trouble with the tutorial.
Michael Markieta - www.spatialanalysis.ca
Research Assistant - Department of Geography @ Ryerson University
B.A. Candidate - Geographic Analysis
Ryerson University
Toronto, ON, Canada




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->