8 replies to this topic

[Michael Markieta]

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

•  flights.png   725.34K   120 downloads

[Hans van der Maarel]

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]

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.

[GrantH]

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.

[Michael Markieta]

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

[NeillG]

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.

[Michael Markieta]

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?

[A. Fenix]

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!

[Michael Markieta]

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

Shoot me an email if you have trouble with the tutorial.