-
1. Re: Curved Lines on a Map
Russell Christopher Oct 29, 2012 5:56 AM (in response to reinholdmerkle)Hi Reinhold -
As long as you have the coordinates of points on the flight route, you can plot them - so yes, no problem with curves.
I've attached a sample showing the paths of storms from our Visual Gallery. You'll see that all it's plotting is Lat & Long (on Rows and Columns) by Date (on the Path shelf) .
Hope this helps!
-
Storm-Analysis-7.0.twbx.zip 724.5 KB
-
-
2. Re: Curved Lines on a Map
Alex Kerin Oct 29, 2012 5:59 AM (in response to reinholdmerkle)1 of 1 people found this helpfulYou couldn't have curved routes without feeding Tableau a path with all of the points the curve goes through. While doable, probably not feasible. If this is a must have, you may get better results in a data visualization language.
Don't know about your second point - maybe another dimension on a dual axis (you can do this with maps as well) and multiple mark types?
-
3. Re: Curved Lines on a Map
reinholdmerkle Oct 29, 2012 6:12 AM (in response to Russell Christopher)Hi Russell,
thanks for your reply.
Unfortunately this doesn't really help because in this case I have only the coordinates of the origin airport and the destination airport and no other points in between. Nevertheless I would prefer a curved line and also no lines crossing each other. An example how I would prefer it you can see here: http://www.inf.uni-konstanz.de/algo/lehre/ss04/gd/apps/flight.html
Regards Reinhold
-
4. Re: Curved Lines on a Map
Ian White Oct 29, 2012 8:05 AM (in response to reinholdmerkle)1 of 1 people found this helpfulHi Reinhold
I think you are looking to create great arcs like in this post? This is something Urban Mapping, Tableau's mapping provider supports.
ian
-
5. Re: Curved Lines on a Map
Jonathan DrummeyOct 29, 2012 8:14 AM (in response to reinholdmerkle)
I can't help with the curved lines, for the multiple mark labels, you can use a table calculation that would look something like:
IF FIRST()==0 THEN
WINDOW_MAX(MAX([airport]), 0, IIF(FIRST()==0,LAST(),0))
END
Exactly how it will look will depend on your data, the arrangement of pills in the view, etc. This will return only one value and Null for everything else, so it will only draw the one label.
-
6. Re: Curved Lines on a Map
Alex Kerin Oct 29, 2012 9:34 AM (in response to reinholdmerkle)The no lines crossing each other means that Tableau will not work for you. The Urban Mapping option for curved lines would be great, but I can't imagine that they will produce non-crossing lines. I would guess you are trying to get to something like this:
These will be hand drawn in Illustrator or some other graphics package. Your example does not use great arcs; there is some sort of calculation going on to produce ever larger circles for each route.
-
7. Re: Curved Lines on a Map
Jake Baillie Oct 29, 2012 10:17 AM (in response to reinholdmerkle)1 of 1 people found this helpful1) Is there a way to have not straight lines between two points on a map but curved lines as on other flight route maps and display them so that all lines are visible ?
As others have mentioned, Mapfluence can draw great arcs with a custom TMS file in Tableau.
2) Of course origin or destination of flight routes can occur multiple times on one map. How could I influence which airport label is displayed and which is not to avoid a map like the one attached
Mapfluence gives you the ability to query "across columns", meaning that a query could be built specifying that you only want airport labels shown containing certain attributes (think airplane types, codeshare partner types, etc). You could also color the lines on the map based on those attributes. Additionally, Mapfluence has the ability to exclude specific data while visualizing - so if you only wanted unique segments, you could do that. Mapfluence's query language is very SQL-like.
For example, here's a quick map using random sample data I just made using color and thickness to represent some attributes (passenger volume and flight frequency) using unique segments.
-
8. Re: Curved Lines on a Map
reinholdmerkle Oct 30, 2012 2:25 AM (in response to Jake Baillie)Hi Jake,
that looks like it could be the solution for my topic. Where can I get or look up the detailed documentation on how to get there, i.e. what are the steps for your example above ?
Thanks and regards
Reinhold
-
9. Re: Curved Lines on a Map
reinholdmerkle Oct 30, 2012 2:45 AM (in response to Ian White)Hi Ian,
thanks for your response.
Where could I find mire and detailed info about how to proceed with Tableau and Urban Mapping as you mentioned ?
Best regards
Reinhold
-
10. Re: Curved Lines on a Map
Allan Walker May 7, 2013 2:10 PM (in response to reinholdmerkle)1 of 1 people found this helpfulYes, this is possible.
LHX to LHR, Great Circle using WGS 84 Mercator Projection / Data pre-processed using Vincenty Formula.
You don't even need path order.
OpenFlights.org data coming soon.
Some progress, pre-processed in R. Thanks to Flowing Data for the tutorial, enhanced it slightly for antipodean routes.
Next, Outputting a Tableau-readable CSV for multiple paths...
Here's a final result.
Output PNG added Message was edited by: Allan Walker
-
11. Re: Curved Lines on a Map
Allan Walker May 7, 2013 2:13 PM (in response to Allan Walker)Test Demo available here
I've limited it to the first 50,000 rows, as the total file (without joins) is 13,000,000 rows.
Note - there is an obvious error in the data (not the map), let me know if you can work it out.
Next up, creating the TDE, and joining over to Airline, Destination Airport & Equipment Type. Done.
-
12. Re: Curved Lines on a Map
reinholdmerkle May 7, 2013 2:04 AM (in response to Allan Walker)Hi Allan,
after quite a time of posting this point your approach sounds very interesting to me.
Looking forward to get more details from you because the item is still very crucial for my daily work with Tableau.
Thanks and best regards
Reinhold
-
13. Re: Curved Lines on a Map
Allan Walker May 7, 2013 8:45 AM (in response to reinholdmerkle)Hi Reinhold.
I'll do a blog post soon (hopefully this week) on how I achieved this.
Best Regards,
Allan
-
14. Re: Curved Lines on a Map
Jonathan DrummeyMay 9, 2013 6:29 PM (in response to Allan Walker)
Great work, Allan!