5 Replies Latest reply: Jun 20, 2013 3:12 AM by Jerry Lau RSS

    Google GeoCoding not working anymore

    Marc van Eijk

       

      In order to get the logitude and latitude data form Google I have used the below mentioned scripting.

      But this is not working anymore.

      Does anyone has an idea?

       

      Table1:

      LOAD

                 Address,

                 Patient,

           Population,

           City    

      FROM testgoogle.xlsx

      (ooxml, embedded labels, table is Blad1);

       

       

       

       

       

      let noRows = NoOfRows('Table1');

       

      for i=0 to $(noRows)

       

                let c=peek('City',$(i),'Table1');

                let p=peek('Population',$(i),'Table1');

                let a=peek('Address',$(i),'Table1');

       

              Data:

                LOAD

                '$(c)' as City,

                '$(p)' as Population,

                '$(a)' as Address,

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

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

       

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