Google maps: Public Transport

Thu, 09 Feb 2012 10:40:44 GMT

Hi. I have managed to successful map UK postcodes onto a google map in QlikView, thanks to the support on this forum. What Id like to do is add public transport data (specifically the london undergroud network) on top of this. Is this possible?My googlemap-script bit contains the following:var_pi180

=          '=pi()/180';
var_lat_offset =     '0';
var_long_offset = '0' ;
var_mc2 =          '=256*pow(2,$(var_zoom))';
var_mc1 =          '=256*pow(2,($(var_zoom)-1))';
var_mid_lat =     '=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)';
var_mid_long =     '=min(longitude)+(max(longitude)-min(longitude))/2';
var_zoom =          '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( longitude *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))';
var_maptype =     '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';
map_size_x=         '640';
map_size_y=     '400';

SET HidePrefix='_' ;

Google maps: Public Transport

Sat, 11 Feb 2012 08:44:24 GMT

Hi Alphie

Are you trying to add line data, or just the stations (as points)?

The points would be very simple, you could do this using the method of a scatter plot, which has been described before.

There is no way to display line data in the dynamic google maps, you would have to work around by overlaying a picture, or to similar effect, but much more complicated maybe use line chart!

What are you trying to do?

Erica

topic Google maps: Public Transport in QlikView

Google maps: Public Transport

Google maps: Public Transport