TRANSPORTATION MAPPING

In our research we compared mapping with different kind of transport situation between three nationalities. And as we seen on the mappings, Barcelona`s transportation system is super crowded because of tourists and we noticed that tourists are more interested in their tweets about bus than metro. Maybe this could be a desire of using some alternative kind of transportation that enables them to see the city instead of being enclosed in a metro. Our idea is to create a transport orientated mostly for tourists. This new transport is a light metro that would have it stops based on our mapping research. We selected several points which are most interesting for all nationalities. It would give them the view of the city and also leave the metro more available for the locals.

                                                                  TWITTER DATASET /ALL TOURISTS IN BARCELONA

                                                                            FLICKER DATASET / METRO SITUATION

FLICKR DATASET / DIFFERENT KIND OF TRANSPORTATION

TWITTER DATASET /  TWEET DISTANCE FOR ALL NATIONALITIES

TWITTER DATASET / TRANSPORTATION TWEETS DURING 7 DAYS

SQL EXAMPLE

PROPOSAL