5 Replies Latest reply: Aug 1, 2013 6:18 AM by Jasper Thomos RSS

    Google maps - longitude and latitude isnt working

    Kristian König

      Hello,

       

      i hope to get some help i dont know whats wrong.

       

      Situation: After the "new" url i lost the map but got it back. But now i have the problem that i cant download the longitude and latitude for my towns.

       

      Here is the script:

       

      MAIN TAB (I think here is the error but dont know where):

      [spoiler]let noRows = NoOfRows('GoogleMaps')-1;

       

      for i=0 to $(noRows)

       

                let a=peek('CUSTACCOUNT',$(i),'GoogleMaps');

                let b=peek('Adresa',$(i),'GoogleMaps');

       

      Data:

                LOAD

                '$(a)' as [Kupac šifra],

                '$(b)' as Adresa,

                subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,

                subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude

                FROM [http://maps.googleapis.com/maps/geo?q=$(b)&output=xml&oe=utf8&sensor=false&key=xxx] (XmlSimple, Table is [kml]);

      next i;[/spoiler]

       

      GOOGLE MAP TAB:

      [spoiler]

      // Google Maps in QlikView

      // V0.85.2 - October 1st 2008  © Copyright QlikTech International AB 2008 / AES

      // Google Maps Key

      // get a key here http://code.google.com/apis/maps/signup.html

      gmap_key = 'xxx';

      max_zoom_level = 17; //maximum value 17

        // Variables required for calculating map

      // No need to change these

      var_pi180=                    '=pi()/180';

      var_lat_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=              '400';

      map_size_y=     '400';

       

      SET HidePrefix='_' ;

      // Field required for calcualting best zoom level

      _zoom_level:

      Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

       

      maptype:

      LOAD * INLINE [

          maptype

          roadmap

                mobile

                satellite

                terrain

                hybrid

      ];

      [/spoiler]

       

      I would appreciate any help i need this tomorrow but have no idea how to solve it

       

      Thank you in advance