1 Reply Latest reply: Jan 26, 2015 12:29 PM by Borja Rodriguez RSS

    Kml Europe

    KENNETH ANDERSEN

      I'm looking for a kml file covering Europe. I found a world map here in this community but can't find a proper Europe map. Any suggestons ?

        • Re: Kml Europe
          Borja Rodriguez

          Hi,

           

          You can load first an INLINE table only with the countries of Europe and then load the KML file filtering the Countries with a "WHERE EXISTS(Country, Country_intheKML)" sentence.

           

           

          Countries:

          LOAD * INLINE [

              Country

              Spain

              Portugal

              France

              Italy

          ];

           

          LOAD

              World.Name as Country,

              World.Area as Country_poly

          FROM 'lib://Downloads/World.kml'

          (kml, Table is [World/Features])

          where Exists(Country, Country);

           

          Capture.PNG