1 Reply Latest reply: Feb 11, 2012 3:44 AM by Erica Whalley RSS

    Google maps: Public Transport

      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

          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